DBA Data[Home] [Help]

APPS.WSH_CONC_UTIL_PKG dependencies on WSH_UTIL_CORE

Line 326: l_work_ids WSH_UTIL_CORE.ID_TAB_TYPE;

322: --
323: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PROCESS_ENTITY_SM';
324:
325: l_continue BOOLEAN;
326: l_work_ids WSH_UTIL_CORE.ID_TAB_TYPE;
327: l_update_ids WSH_UTIL_CORE.ID_TAB_TYPE;
328:
329: l_work_index NUMBER;
330: l_update_index NUMBER;

Line 327: l_update_ids WSH_UTIL_CORE.ID_TAB_TYPE;

323: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'PROCESS_ENTITY_SM';
324:
325: l_continue BOOLEAN;
326: l_work_ids WSH_UTIL_CORE.ID_TAB_TYPE;
327: l_update_ids WSH_UTIL_CORE.ID_TAB_TYPE;
328:
329: l_work_index NUMBER;
330: l_update_index NUMBER;
331:

Line 490: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);

486: WHEN OTHERS THEN
487: IF c_current_trips%ISOPEN THEN CLOSE c_current_trips; END IF;
488: IF c_current_dels%ISOPEN THEN CLOSE c_current_dels; END IF;
489: IF c_current_details%ISOPEN THEN CLOSE c_current_details; END IF;
490: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
491: IF l_debug_on THEN
492: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
493: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
494: WSH_DEBUG_SV.log(l_module_name, 'out x_count', x_count);

Line 618: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);

614:
615: WHEN OTHERS THEN
616: IF c_lock_service%ISOPEN THEN CLOSE c_lock_service; END IF;
617: IF c_request_completed%ISOPEN THEN CLOSE c_request_completed; END IF;
618: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
619: IF l_debug_on THEN
620: WSH_DEBUG_SV.logmsg(l_module_name,'OTHERS exception has occured.'
621: ,WSH_DEBUG_SV.C_EXCEP_LEVEL);
622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 672: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

668: END print_output;
669:
670: BEGIN
671:
672: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
673:
674: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
675: --
676: IF l_debug_on IS NULL

Line 801: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);

797: print_output;
798:
799: EXCEPTION
800: WHEN OTHERS THEN
801: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
802:
803: l_completion_status := 'ERROR';
804: l_errbuf := SQLERRM;
805: IF l_debug_on THEN

Line 811: WSH_UTIL_CORE.printmsg(l_errbuf);

807: 'Internal unexpected error has occured. Oracle error message',
808: l_errbuf,
809: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
810: END IF;
811: WSH_UTIL_CORE.printmsg(l_errbuf);
812:
813: IF c_ship_methods%ISOPEN THEN CLOSE c_ship_methods; END IF;
814: ROLLBACK;
815: END;

Line 837: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);

833:
834:
835: EXCEPTION
836: WHEN OTHERS THEN
837: WSH_UTIL_CORE.DEFAULT_HANDLER(l_module_name);
838:
839: l_completion_status := 'ERROR';
840: l_errbuf := SQLERRM;
841: IF l_debug_on THEN

Line 847: WSH_UTIL_CORE.printmsg(l_errbuf);

843: 'API unexpected error has occured. Oracle error message',
844: l_errbuf,
845: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
846: END IF;
847: WSH_UTIL_CORE.printmsg(l_errbuf);
848:
849: l_rc := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,
850: 'update_ship_method_SRS');
851: errbuf := l_errbuf;