DBA Data[Home] [Help]

APPS.WSH_ITM_ITEM_SYNC dependencies on WSH_ITM_CUSTOMIZE

Line 437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_ITEM_SYNC',WSH_DEBUG_SV.C_PROC_LEVEL);

433: --
434: -- Debug Statements
435: --
436: IF l_debug_on THEN
437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_ITEM_SYNC',WSH_DEBUG_SV.C_PROC_LEVEL);
438: END IF;
439: --
440: WSH_ITM_CUSTOMIZE.ALTER_ITEM_SYNC(l_Item_Table);
441:

Line 440: WSH_ITM_CUSTOMIZE.ALTER_ITEM_SYNC(l_Item_Table);

436: IF l_debug_on THEN
437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_ITM_CUSTOMIZE.ALTER_ITEM_SYNC',WSH_DEBUG_SV.C_PROC_LEVEL);
438: END IF;
439: --
440: WSH_ITM_CUSTOMIZE.ALTER_ITEM_SYNC(l_Item_Table);
441:
442: --Create SQL and bind parameters
443: FOR I IN 1..l_Item_Table.COUNT
444: LOOP

Line 703: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_CUSTOMIZE.POPULATE_DATA');

699: --
700:
701: EXCEPTION
702: WHEN OTHERS THEN
703: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_CUSTOMIZE.POPULATE_DATA');
704: errbuf := 'Error in procedure WSH_ITM_CUSTOMIZE.POPULATE_DATA failed with unexpected error';
705: retcode := '2';
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.logmsg(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);

Line 704: errbuf := 'Error in procedure WSH_ITM_CUSTOMIZE.POPULATE_DATA failed with unexpected error';

700:
701: EXCEPTION
702: WHEN OTHERS THEN
703: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_CUSTOMIZE.POPULATE_DATA');
704: errbuf := 'Error in procedure WSH_ITM_CUSTOMIZE.POPULATE_DATA failed with unexpected error';
705: retcode := '2';
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.logmsg(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
708: WSH_DEBUG_SV.pop(l_module_name);