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 701: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_CUSTOMIZE.POPULATE_DATA');

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

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

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