Resolving The Problem

Check the appropriate log file for this particular download:
Sample lines from $BASE/log/infc_log/MEMP1/skud_cai.log
Download Begins ...16-AUG-01 11: 28:08|0|20010816112808|YANTRA|CSKU
MEMP1|0|0|-6502|110|0|0|ORA-06502: PL/SQL: numeric or value error: character to
number conversion error| |PR_GET_DFLT_PCKTYPE_PRODCLASS|0|Sqlcode :-6502Error in
main procedure for Item Download. ORA-06502: PL/SQL: numeric or value error: ch
aracter to number conversion error|0|20010816112815|YANTRA|CSKU

This message does not appear to be correct for the PR_GET_DFLT_PCKTYPE_PRODCLASS procedure checked out OK.

Put the DBMS_OUTPUT comment as soon as procedure PR_SKUD_INS_CRP_SKU began but that comment was not appearing . Implies problem

The procedure declaration :
PROCEDURE PR_SKUD_INS_CRP_SKU ( WHSE IN OUT CHAR,
REC_NOTIFICATION_ITEM IN OUT
APPS.CAI_NOTIFICATION_EXPORT@ORAPROD_WMS%ROWTYPE,
REC_MTL_SYSTEM_ITEMS IN OUT
APPS.MTL_SYSTEM_ITEMS_WMS_V@ORAPROD_WMS%ROWTYPE,
LCL_ITEM_ID IN OUT VARCHAR2,
SQLCD IN OUT NUMBER ) ;

Checked that WHSE and LCL_ITEM_ID were getting assigned as CHAR and the two cursors were just getting rows assignned into them so there seems no problem with them. Could be the procedure variable declarations and asssingments before the BEGIN word.

in Procedure PR_SKUD_INS_CRP_SKU , vaiables defined as follows
LCL_SHELF_LIFE NUMBER(13,4) := ' ';
LCL_KIT_CARTONS NUMBER(05) := ' ';

Oracle 7.3.4 allows this type assignement(number field character or
null string assignment) but it is now allowed in 8.1.6.2

so changed as follows
LCL_SHELF_LIFE NUMBER(13,4) := 0 ;
LCL_KIT_CARTONS NUMBER(05) := 0;