DBA Data[Home] [Help]

APPS.WSH_CONC_UTIL_PKG dependencies on WSH_UTIL_CORE

Line 338: l_work_ids WSH_UTIL_CORE.ID_TAB_TYPE;

334: --
335: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PROCESS_ENTITY_SM';
336:
337: l_continue BOOLEAN;
338: l_work_ids WSH_UTIL_CORE.ID_TAB_TYPE;
339: l_update_ids WSH_UTIL_CORE.ID_TAB_TYPE;
340:
341: l_work_index NUMBER;
342: l_update_index NUMBER;

Line 339: l_update_ids WSH_UTIL_CORE.ID_TAB_TYPE;

335: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PROCESS_ENTITY_SM';
336:
337: l_continue BOOLEAN;
338: l_work_ids WSH_UTIL_CORE.ID_TAB_TYPE;
339: l_update_ids WSH_UTIL_CORE.ID_TAB_TYPE;
340:
341: l_work_index NUMBER;
342: l_update_index NUMBER;
343:

Line 502: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);

498: WHEN OTHERS THEN
499: IF c_current_trips%ISOPEN THEN CLOSE c_current_trips; END IF;
500: IF c_current_dels%ISOPEN THEN CLOSE c_current_dels; END IF;
501: IF c_current_details%ISOPEN THEN CLOSE c_current_details; END IF;
502: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
503: IF l_debug_on THEN
504: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
505: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
506: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);

Line 630: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);

626:
627: WHEN OTHERS THEN
628: IF c_lock_service%ISOPEN THEN CLOSE c_lock_service; END IF;
629: IF c_request_completed%ISOPEN THEN CLOSE c_request_completed; END IF;
630: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
631: IF l_debug_on THEN
632: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
633: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
634: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 684: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

680: END print_output;
681:
682: BEGIN
683:
684: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
685:
686: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
687: --
688: IF l_debug_on IS NULL

Line 813: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);

809: print_output;
810:
811: EXCEPTION
812: WHEN OTHERS THEN
813: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
814:
815: l_completion_status := 'ERROR';
816: l_errbuf := SQLERRM;
817: IF l_debug_on THEN

Line 823: WSH_UTIL_CORE.printmsg(l_errbuf);

819: 'Internal unexpected error has occured. Oracle error message',
820: l_errbuf,
821: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
822: END IF;
823: WSH_UTIL_CORE.printmsg(l_errbuf);
824:
825: IF c_ship_methods%ISOPEN THEN CLOSE c_ship_methods; END IF;
826: ROLLBACK;
827: END;

Line 849: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);

845:
846:
847: EXCEPTION
848: WHEN OTHERS THEN
849: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
850:
851: l_completion_status := 'ERROR';
852: l_errbuf := SQLERRM;
853: IF l_debug_on THEN

Line 859: WSH_UTIL_CORE.printmsg(l_errbuf);

855: 'API unexpected error has occured. Oracle error message',
856: l_errbuf,
857: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
858: END IF;
859: WSH_UTIL_CORE.printmsg(l_errbuf);
860:
861: l_rc := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,
862: 'update_ship_method_SRS');
863: errbuf := l_errbuf;