eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_UTIL_CORE

Line 54: l_worker_min_tab WSH_UTIL_CORE.id_tab_type;

50: p_fte_installed IN VARCHAR2 default NULL,
51: p_create_facilities IN VARCHAR2 default NULL) IS
52:
53:
54: l_worker_min_tab WSH_UTIL_CORE.id_tab_type;
55: l_worker_max_tab WSH_UTIL_CORE.id_tab_type;
56: l_new_request_id NUMBER := 0;
57: i NUMBER := 0;
58: l_sqlcode NUMBER;

Line 55: l_worker_max_tab WSH_UTIL_CORE.id_tab_type;

51: p_create_facilities IN VARCHAR2 default NULL) IS
52:
53:
54: l_worker_min_tab WSH_UTIL_CORE.id_tab_type;
55: l_worker_max_tab WSH_UTIL_CORE.id_tab_type;
56: l_new_request_id NUMBER := 0;
57: i NUMBER := 0;
58: l_sqlcode NUMBER;
59: l_sqlerr VARCHAR2(2000);

Line 78: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

74: l_import_start_date Date;
75:
76: BEGIN
77:
78: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
79: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
80:
81: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
82: IF l_debug_on IS NULL THEN

Line 79: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

75:
76: BEGIN
77:
78: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
79: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
80:
81: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
82: IF l_debug_on IS NULL THEN
83: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 220: WSH_UTIL_CORE.printmsg('Error Submitting concurrent request for worker : '||i);

216: WSH_DEBUG_SV.log(l_module_name, 'Child request ID ', l_new_request_id);
217: END IF;
218:
219: IF l_new_request_id = 0 THEN
220: WSH_UTIL_CORE.printmsg('Error Submitting concurrent request for worker : '||i);
221: l_completion_status := 'ERROR';
222: END IF;
223:
224: END LOOP;

Line 306: WSH_UTIL_CORE.printmsg('No matching records for the entered parameters');

302: EXCEPTION
303:
304: WHEN No_Data_Found THEN
305:
306: WSH_UTIL_CORE.printmsg('No matching records for the entered parameters');
307: IF l_debug_on THEN
308: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
309: END IF;
310:

Line 315: WSH_UTIL_CORE.printmsg('Exception occurred in Map_Locations Program');

311: WHEN others THEN
312: l_sqlcode := SQLCODE;
313: l_sqlerr := SQLERRM;
314:
315: WSH_UTIL_CORE.printmsg('Exception occurred in Map_Locations Program');
316: WSH_UTIL_CORE.printmsg('SQLCODE : ' || l_sqlcode);
317: WSH_UTIL_CORE.printmsg('SQLERRM : ' || l_sqlerr);
318:
319: l_completion_status := 'ERROR';

Line 316: WSH_UTIL_CORE.printmsg('SQLCODE : ' || l_sqlcode);

312: l_sqlcode := SQLCODE;
313: l_sqlerr := SQLERRM;
314:
315: WSH_UTIL_CORE.printmsg('Exception occurred in Map_Locations Program');
316: WSH_UTIL_CORE.printmsg('SQLCODE : ' || l_sqlcode);
317: WSH_UTIL_CORE.printmsg('SQLERRM : ' || l_sqlerr);
318:
319: l_completion_status := 'ERROR';
320: p_errbuf := 'Exception occurred in Map_Locations Program';

Line 317: WSH_UTIL_CORE.printmsg('SQLERRM : ' || l_sqlerr);

313: l_sqlerr := SQLERRM;
314:
315: WSH_UTIL_CORE.printmsg('Exception occurred in Map_Locations Program');
316: WSH_UTIL_CORE.printmsg('SQLCODE : ' || l_sqlcode);
317: WSH_UTIL_CORE.printmsg('SQLERRM : ' || l_sqlerr);
318:
319: l_completion_status := 'ERROR';
320: p_errbuf := 'Exception occurred in Map_Locations Program';
321: p_retcode := '2';

Line 365: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;

361:
362: BEGIN
363:
364:
365: WSH_UTIL_CORE.Enable_Concurrent_Log_Print;
366:
367: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
368: IF l_debug_on IS NULL THEN
369: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 404: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

400: END IF;
401:
402:
403: IF l_return_status NOT IN
404: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
405:
406: WSH_UTIL_CORE.printmsg('Failed in Procedure Process_Locations');
407: WSH_UTIL_CORE.printmsg(l_sqlcode);
408: WSH_UTIL_CORE.printmsg(l_sqlerr);

Line 406: WSH_UTIL_CORE.printmsg('Failed in Procedure Process_Locations');

402:
403: IF l_return_status NOT IN
404: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
405:
406: WSH_UTIL_CORE.printmsg('Failed in Procedure Process_Locations');
407: WSH_UTIL_CORE.printmsg(l_sqlcode);
408: WSH_UTIL_CORE.printmsg(l_sqlerr);
409: l_completion_status := 'ERROR';
410: END IF;

Line 407: WSH_UTIL_CORE.printmsg(l_sqlcode);

403: IF l_return_status NOT IN
404: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
405:
406: WSH_UTIL_CORE.printmsg('Failed in Procedure Process_Locations');
407: WSH_UTIL_CORE.printmsg(l_sqlcode);
408: WSH_UTIL_CORE.printmsg(l_sqlerr);
409: l_completion_status := 'ERROR';
410: END IF;
411:

Line 408: WSH_UTIL_CORE.printmsg(l_sqlerr);

404: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
405:
406: WSH_UTIL_CORE.printmsg('Failed in Procedure Process_Locations');
407: WSH_UTIL_CORE.printmsg(l_sqlcode);
408: WSH_UTIL_CORE.printmsg(l_sqlerr);
409: l_completion_status := 'ERROR';
410: END IF;
411:
412: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS(l_completion_status,'');

Line 441: WSH_UTIL_CORE.printmsg('Exception occurred in Map_Locations_Child_Program');

437: p_retcode := '2';
438:
439: l_sqlcode := SQLCODE;
440: l_sqlerr := SQLERRM;
441: WSH_UTIL_CORE.printmsg('Exception occurred in Map_Locations_Child_Program');
442: WSH_UTIL_CORE.printmsg('SQLCODE : ' || l_sqlcode);
443: WSH_UTIL_CORE.printmsg('SQLERRM : ' || l_sqlerr);
444: IF l_debug_on THEN
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 442: WSH_UTIL_CORE.printmsg('SQLCODE : ' || l_sqlcode);

438:
439: l_sqlcode := SQLCODE;
440: l_sqlerr := SQLERRM;
441: WSH_UTIL_CORE.printmsg('Exception occurred in Map_Locations_Child_Program');
442: WSH_UTIL_CORE.printmsg('SQLCODE : ' || l_sqlcode);
443: WSH_UTIL_CORE.printmsg('SQLERRM : ' || l_sqlerr);
444: IF l_debug_on THEN
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
446: END IF;

Line 443: WSH_UTIL_CORE.printmsg('SQLERRM : ' || l_sqlerr);

439: l_sqlcode := SQLCODE;
440: l_sqlerr := SQLERRM;
441: WSH_UTIL_CORE.printmsg('Exception occurred in Map_Locations_Child_Program');
442: WSH_UTIL_CORE.printmsg('SQLCODE : ' || l_sqlcode);
443: WSH_UTIL_CORE.printmsg('SQLERRM : ' || l_sqlerr);
444: IF l_debug_on THEN
445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
446: END IF;
447:

Line 472: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

468: l_debug_on BOOLEAN;
469:
470: BEGIN
471:
472: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
473:
474: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
475: IF l_debug_on IS NULL THEN
476: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

Line 522: WSH_UTIL_CORE.printmsg(' Error in Insert_records : ' || sqlerrm);

518: EXCEPTION
519:
520: WHEN Others THEN
521:
522: WSH_UTIL_CORE.printmsg(' Error in Insert_records : ' || sqlerrm);
523: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.pop(l_module_name);
526: END IF;

Line 523: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

519:
520: WHEN Others THEN
521:
522: WSH_UTIL_CORE.printmsg(' Error in Insert_records : ' || sqlerrm);
523: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.pop(l_module_name);
526: END IF;
527:

Line 561: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

557: wsh_debug_sv.logmsg(l_module_name, 'before bulk delete:' ||to_char(sysdate, 'dd/mm/yyyy hh:mi:ss'));
558: END IF;
559:
560:
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
562:
563: FORALL i IN l_del_loc_id_tab.first .. l_del_loc_id_tab.last
564:
565: DELETE from wsh_region_locations where location_id = l_del_loc_id_tab(i)

Line 580: WSH_UTIL_CORE.printmsg(' Error in Delete_records: ' || sqlerrm);

576: END IF;
577:
578: EXCEPTION
579: WHEN Others THEN
580: WSH_UTIL_CORE.printmsg(' Error in Delete_records: ' || sqlerrm);
581: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
582: IF l_debug_on THEN
583: WSH_DEBUG_SV.pop(l_module_name);
584: END IF;

Line 581: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

577:
578: EXCEPTION
579: WHEN Others THEN
580: WSH_UTIL_CORE.printmsg(' Error in Delete_records: ' || sqlerrm);
581: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
582: IF l_debug_on THEN
583: WSH_DEBUG_SV.pop(l_module_name);
584: END IF;
585: END Delete_records;

Line 623: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

619: WSH_DEBUG_SV.push(l_module_name);
620: wsh_debug_sv.logmsg(l_module_name, 'before bulk update:' ||to_char(sysdate, 'dd/mm/yyyy hh:mi:ss'));
621: END IF;
622:
623: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
624:
625: FORALL cnt IN l_upd_loc_id_tab.first .. l_upd_loc_id_tab.last
626:
627: UPDATE wsh_region_locations

Line 678: WSH_UTIL_CORE.printmsg(' Error in Update_records: ' || sqlerrm);

674: END IF;
675:
676: EXCEPTION
677: WHEN Others THEN
678: WSH_UTIL_CORE.printmsg(' Error in Update_records: ' || sqlerrm);
679: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.pop(l_module_name);
682: END IF;

Line 679: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

675:
676: EXCEPTION
677: WHEN Others THEN
678: WSH_UTIL_CORE.printmsg(' Error in Update_records: ' || sqlerrm);
679: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
680: IF l_debug_on THEN
681: WSH_DEBUG_SV.pop(l_module_name);
682: END IF;
683:

Line 728: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

724:
725: wsh_debug_sv.logmsg(l_module_name, 'before process_records:' ||to_char(sysdate, 'dd/mm/yyyy hh:mi:ss'));
726: END IF;
727:
728: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
729:
730: SAVEPOINT before_db_update;
731:
732: Delete_records(x_return_status => l_return_status);

Line 733: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

729:
730: SAVEPOINT before_db_update;
731:
732: Delete_records(x_return_status => l_return_status);
733: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
734: RAISE delete_failed;
735: END IF;
736:
737: Insert_Records(x_return_status => l_return_status);

Line 738: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

734: RAISE delete_failed;
735: END IF;
736:
737: Insert_Records(x_return_status => l_return_status);
738: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
739: RAISE insert_failed;
740: END IF;
741:
742: Update_Records(x_return_status => l_return_status);

Line 743: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

739: RAISE insert_failed;
740: END IF;
741:
742: Update_Records(x_return_status => l_return_status);
743: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
744: RAISE update_failed;
745: END IF;
746:
747: l_location_id_tab.delete;

Line 764: WSH_UTIL_CORE.printmsg(' Error in Process_records - delete: ' || sqlerrm);

760:
761: EXCEPTION
762:
763: WHEN delete_failed THEN
764: WSH_UTIL_CORE.printmsg(' Error in Process_records - delete: ' || sqlerrm);
765: ROLLBACK to before_db_update;
766: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
767: IF l_debug_on THEN
768: WSH_DEBUG_SV.pop(l_module_name);

Line 766: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

762:
763: WHEN delete_failed THEN
764: WSH_UTIL_CORE.printmsg(' Error in Process_records - delete: ' || sqlerrm);
765: ROLLBACK to before_db_update;
766: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
767: IF l_debug_on THEN
768: WSH_DEBUG_SV.pop(l_module_name);
769: END IF;
770: WHEN insert_failed THEN

Line 771: WSH_UTIL_CORE.printmsg(' Error in Process_records - insert: ' || sqlerrm);

767: IF l_debug_on THEN
768: WSH_DEBUG_SV.pop(l_module_name);
769: END IF;
770: WHEN insert_failed THEN
771: WSH_UTIL_CORE.printmsg(' Error in Process_records - insert: ' || sqlerrm);
772: ROLLBACK to before_db_update;
773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
774: IF l_debug_on THEN
775: WSH_DEBUG_SV.pop(l_module_name);

Line 773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

769: END IF;
770: WHEN insert_failed THEN
771: WSH_UTIL_CORE.printmsg(' Error in Process_records - insert: ' || sqlerrm);
772: ROLLBACK to before_db_update;
773: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
774: IF l_debug_on THEN
775: WSH_DEBUG_SV.pop(l_module_name);
776: END IF;
777:

Line 779: WSH_UTIL_CORE.printmsg(' Error in Process_records - update: ' || sqlerrm);

775: WSH_DEBUG_SV.pop(l_module_name);
776: END IF;
777:
778: WHEN update_failed THEN
779: WSH_UTIL_CORE.printmsg(' Error in Process_records - update: ' || sqlerrm);
780: ROLLBACK to before_db_update;
781: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
782: IF l_debug_on THEN
783: WSH_DEBUG_SV.pop(l_module_name);

Line 781: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

777:
778: WHEN update_failed THEN
779: WSH_UTIL_CORE.printmsg(' Error in Process_records - update: ' || sqlerrm);
780: ROLLBACK to before_db_update;
781: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
782: IF l_debug_on THEN
783: WSH_DEBUG_SV.pop(l_module_name);
784: END IF;
785: WHEN Others THEN

Line 786: WSH_UTIL_CORE.printmsg('Error in Process_records : ' || sqlerrm);

782: IF l_debug_on THEN
783: WSH_DEBUG_SV.pop(l_module_name);
784: END IF;
785: WHEN Others THEN
786: WSH_UTIL_CORE.printmsg('Error in Process_records : ' || sqlerrm);
787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
788: IF l_debug_on THEN
789: WSH_DEBUG_SV.pop(l_module_name);
790: END IF;

Line 787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

783: WSH_DEBUG_SV.pop(l_module_name);
784: END IF;
785: WHEN Others THEN
786: WSH_UTIL_CORE.printmsg('Error in Process_records : ' || sqlerrm);
787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
788: IF l_debug_on THEN
789: WSH_DEBUG_SV.pop(l_module_name);
790: END IF;
791: END;

Line 922: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

918: WSH_DEBUG_SV.log(l_module_name,'P_START_DATE',P_START_DATE);
919: WSH_DEBUG_SV.log(l_module_name,'P_END_DATE',P_END_DATE);
920: END IF;
921:
922: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
923:
924: ----------------------------------------------------------------------
925: -- Depending on the location type, fetch all the data into respective
926: -- PL/SQL tables. The call Map_Location_To_Region to map the data.

Line 1006: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from Map_Location_To_Region : '|| l_return_status);
1004: END IF;
1005:
1006: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1007:
1008: IF l_debug_on THEN
1009: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1010: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlcode);

Line 1013: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));

1009: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1010: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlcode);
1011: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlerr);
1012: ELSE
1013: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1014: WSH_UTIL_CORE.printmsg(l_sqlcode);
1015: WSH_UTIL_CORE.printmsg(l_sqlerr);
1016: END IF;
1017:

Line 1014: WSH_UTIL_CORE.printmsg(l_sqlcode);

1010: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlcode);
1011: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlerr);
1012: ELSE
1013: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1014: WSH_UTIL_CORE.printmsg(l_sqlcode);
1015: WSH_UTIL_CORE.printmsg(l_sqlerr);
1016: END IF;
1017:
1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1015: WSH_UTIL_CORE.printmsg(l_sqlerr);

1011: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlerr);
1012: ELSE
1013: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1014: WSH_UTIL_CORE.printmsg(l_sqlcode);
1015: WSH_UTIL_CORE.printmsg(l_sqlerr);
1016: END IF;
1017:
1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1019: END IF;

Line 1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1014: WSH_UTIL_CORE.printmsg(l_sqlcode);
1015: WSH_UTIL_CORE.printmsg(l_sqlerr);
1016: END IF;
1017:
1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1019: END IF;
1020:
1021: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1022: -- WSH_UTIL_CORE.println('Processing Next Location');

Line 1021: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');

1017:
1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1019: END IF;
1020:
1021: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1022: -- WSH_UTIL_CORE.println('Processing Next Location');
1023: -- WSH_UTIL_CORE.println('*******************************************');
1024: END LOOP;
1025:

Line 1022: -- WSH_UTIL_CORE.println('Processing Next Location');

1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1019: END IF;
1020:
1021: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1022: -- WSH_UTIL_CORE.println('Processing Next Location');
1023: -- WSH_UTIL_CORE.println('*******************************************');
1024: END LOOP;
1025:
1026: -- Bug 4722963

Line 1023: -- WSH_UTIL_CORE.println('*******************************************');

1019: END IF;
1020:
1021: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1022: -- WSH_UTIL_CORE.println('Processing Next Location');
1023: -- WSH_UTIL_CORE.println('*******************************************');
1024: END LOOP;
1025:
1026: -- Bug 4722963
1027:

Line 1034: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1030: THEN
1031:
1032: Process_Records(x_return_status => l_return_status);
1033:
1034: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1036: END IF;
1037:
1038: END IF;

Line 1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1031:
1032: Process_Records(x_return_status => l_return_status);
1033:
1034: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1035: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1036: END IF;
1037:
1038: END IF;
1039: -- Bug 4722963 end

Line 1115: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1111: IF l_debug_on THEN
1112: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from Map_Location_To_Region : '|| l_return_status);
1113: END IF;
1114:
1115: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1116:
1117: IF l_debug_on THEN
1118: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1119: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlcode);

Line 1122: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));

1118: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1119: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlcode);
1120: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlerr);
1121: ELSE
1122: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1123: WSH_UTIL_CORE.printmsg(l_sqlcode);
1124: WSH_UTIL_CORE.printmsg(l_sqlerr);
1125: END IF;
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1123: WSH_UTIL_CORE.printmsg(l_sqlcode);

1119: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlcode);
1120: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlerr);
1121: ELSE
1122: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1123: WSH_UTIL_CORE.printmsg(l_sqlcode);
1124: WSH_UTIL_CORE.printmsg(l_sqlerr);
1125: END IF;
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1127: END IF;

Line 1124: WSH_UTIL_CORE.printmsg(l_sqlerr);

1120: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlerr);
1121: ELSE
1122: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1123: WSH_UTIL_CORE.printmsg(l_sqlcode);
1124: WSH_UTIL_CORE.printmsg(l_sqlerr);
1125: END IF;
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1127: END IF;
1128:

Line 1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1122: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1123: WSH_UTIL_CORE.printmsg(l_sqlcode);
1124: WSH_UTIL_CORE.printmsg(l_sqlerr);
1125: END IF;
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1127: END IF;
1128:
1129: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1130: -- WSH_UTIL_CORE.println('Processing Next Location');

Line 1129: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');

1125: END IF;
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1127: END IF;
1128:
1129: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1130: -- WSH_UTIL_CORE.println('Processing Next Location');
1131: -- WSH_UTIL_CORE.println('*******************************************');
1132: END LOOP;
1133:

Line 1130: -- WSH_UTIL_CORE.println('Processing Next Location');

1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1127: END IF;
1128:
1129: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1130: -- WSH_UTIL_CORE.println('Processing Next Location');
1131: -- WSH_UTIL_CORE.println('*******************************************');
1132: END LOOP;
1133:
1134: -- Bug 4722963

Line 1131: -- WSH_UTIL_CORE.println('*******************************************');

1127: END IF;
1128:
1129: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1130: -- WSH_UTIL_CORE.println('Processing Next Location');
1131: -- WSH_UTIL_CORE.println('*******************************************');
1132: END LOOP;
1133:
1134: -- Bug 4722963
1135:

Line 1140: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1136: IF NOT p_insert_flag AND
1137: (l_location_id_tab.COUNT > 0 OR l_del_loc_id_tab.COUNT > 0 OR l_upd_loc_id_tab.COUNT > 0 )
1138: THEN
1139: Process_Records(x_return_status => l_return_status);
1140: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1141: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1142: END IF;
1143: END IF;
1144: -- Bug 4722963 end

Line 1141: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1137: (l_location_id_tab.COUNT > 0 OR l_del_loc_id_tab.COUNT > 0 OR l_upd_loc_id_tab.COUNT > 0 )
1138: THEN
1139: Process_Records(x_return_status => l_return_status);
1140: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1141: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1142: END IF;
1143: END IF;
1144: -- Bug 4722963 end
1145: END IF;

Line 1219: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from Map_Location_To_Region : '|| l_return_status);
1217: END IF;
1218:
1219: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1220:
1221: IF l_debug_on THEN
1222: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1223: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlcode);

Line 1226: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));

1222: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1223: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlcode);
1224: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlerr);
1225: ELSE
1226: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1227: WSH_UTIL_CORE.printmsg(l_sqlcode);
1228: WSH_UTIL_CORE.printmsg(l_sqlerr);
1229: END IF;
1230:

Line 1227: WSH_UTIL_CORE.printmsg(l_sqlcode);

1223: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlcode);
1224: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlerr);
1225: ELSE
1226: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1227: WSH_UTIL_CORE.printmsg(l_sqlcode);
1228: WSH_UTIL_CORE.printmsg(l_sqlerr);
1229: END IF;
1230:
1231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1228: WSH_UTIL_CORE.printmsg(l_sqlerr);

1224: WSH_DEBUG_SV.logmsg(l_module_name,l_sqlerr);
1225: ELSE
1226: WSH_UTIL_CORE.printmsg('Failed in API Map_Location_To_Region for location : '||l_loc_tab(i));
1227: WSH_UTIL_CORE.printmsg(l_sqlcode);
1228: WSH_UTIL_CORE.printmsg(l_sqlerr);
1229: END IF;
1230:
1231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1232: END IF;

Line 1231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1227: WSH_UTIL_CORE.printmsg(l_sqlcode);
1228: WSH_UTIL_CORE.printmsg(l_sqlerr);
1229: END IF;
1230:
1231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1232: END IF;
1233:
1234: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1235: -- WSH_UTIL_CORE.println('Processing Next Location');

Line 1234: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');

1230:
1231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1232: END IF;
1233:
1234: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1235: -- WSH_UTIL_CORE.println('Processing Next Location');
1236: -- WSH_UTIL_CORE.println('*******************************************');
1237: END LOOP;
1238:

Line 1235: -- WSH_UTIL_CORE.println('Processing Next Location');

1231: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1232: END IF;
1233:
1234: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1235: -- WSH_UTIL_CORE.println('Processing Next Location');
1236: -- WSH_UTIL_CORE.println('*******************************************');
1237: END LOOP;
1238:
1239: -- Bug 4722963

Line 1236: -- WSH_UTIL_CORE.println('*******************************************');

1232: END IF;
1233:
1234: -- WSH_UTIL_CORE.println('After call to Map_Location_To_Region');
1235: -- WSH_UTIL_CORE.println('Processing Next Location');
1236: -- WSH_UTIL_CORE.println('*******************************************');
1237: END LOOP;
1238:
1239: -- Bug 4722963
1240: IF NOT p_insert_flag AND

Line 1244: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1240: IF NOT p_insert_flag AND
1241: (l_location_id_tab.COUNT > 0 OR l_del_loc_id_tab.COUNT > 0 OR l_upd_loc_id_tab.COUNT > 0 )
1242: THEN
1243: Process_Records(x_return_status => l_return_status);
1244: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1245: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1246: END IF;
1247: END IF;
1248: -- Bug 4722963 end

Line 1245: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1241: (l_location_id_tab.COUNT > 0 OR l_del_loc_id_tab.COUNT > 0 OR l_upd_loc_id_tab.COUNT > 0 )
1242: THEN
1243: Process_Records(x_return_status => l_return_status);
1244: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1245: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1246: END IF;
1247: END IF;
1248: -- Bug 4722963 end
1249: END IF;

Line 1260: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1256: END IF;
1257: END IF;
1258: x_return_status := l_return_status;
1259:
1260: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1261: --R12.1.1 Standalone Project - Start
1262: --Commit the data only if its Normal Mode
1263: IF G_MODE = 'STANDALONE' THEN
1264: --

Line 1292: WSH_UTIL_CORE.printmsg('No records found for the entered parameters');

1288: IF l_debug_on THEN
1289: WSH_DEBUG_SV.logmsg(l_module_name,'No records found for the entered parameters');
1290: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1291: ELSE
1292: WSH_UTIL_CORE.printmsg('No records found for the entered parameters');
1293: END IF;
1294:
1295: WHEN Others THEN
1296: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1296: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1292: WSH_UTIL_CORE.printmsg('No records found for the entered parameters');
1293: END IF;
1294:
1295: WHEN Others THEN
1296: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1297: x_sqlcode := SQLCODE;
1298: x_sqlerr := SQLERRM;
1299:
1300: IF l_debug_on THEN

Line 1306: WSH_UTIL_CORE.printmsg('When Others of Procedure Mapping_Regions_Main ');

1302: WSH_DEBUG_SV.logmsg(l_module_name,x_sqlcode);
1303: WSH_DEBUG_SV.logmsg(l_module_name,x_sqlerr);
1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1305: ELSE
1306: WSH_UTIL_CORE.printmsg('When Others of Procedure Mapping_Regions_Main ');
1307: WSH_UTIL_CORE.printmsg(x_sqlcode);
1308: WSH_UTIL_CORE.printmsg(x_sqlerr);
1309: END IF;
1310:

Line 1307: WSH_UTIL_CORE.printmsg(x_sqlcode);

1303: WSH_DEBUG_SV.logmsg(l_module_name,x_sqlerr);
1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1305: ELSE
1306: WSH_UTIL_CORE.printmsg('When Others of Procedure Mapping_Regions_Main ');
1307: WSH_UTIL_CORE.printmsg(x_sqlcode);
1308: WSH_UTIL_CORE.printmsg(x_sqlerr);
1309: END IF;
1310:
1311: END Mapping_Regions_Main;

Line 1308: WSH_UTIL_CORE.printmsg(x_sqlerr);

1304: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1305: ELSE
1306: WSH_UTIL_CORE.printmsg('When Others of Procedure Mapping_Regions_Main ');
1307: WSH_UTIL_CORE.printmsg(x_sqlcode);
1308: WSH_UTIL_CORE.printmsg(x_sqlerr);
1309: END IF;
1310:
1311: END Mapping_Regions_Main;
1312:

Line 1411: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1407: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'MAP_LOCATION_TO_REGION';
1408:
1409: BEGIN
1410: --bug 7158136
1411: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1412: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1413:
1414: j := l_location_id_tab.COUNT;
1415: --

Line 1412: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1408:
1409: BEGIN
1410: --bug 7158136
1411: --x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1412: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1413:
1414: j := l_location_id_tab.COUNT;
1415: --
1416: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 1620: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1616: p_location_source => l_location_source,
1617: p_parent_region => l_parent_region,
1618: x_return_status => l_return_status);
1619:
1620: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1621: IF l_debug_on THEN
1622: WSH_DEBUG_SV.logmsg(l_module_name,'Insert failed for Null Region for Location : '||p_location_id);
1623: ELSE
1624: WSH_UTIL_CORE.printmsg('Insert failed for Null Region for Location : '||p_location_id);

Line 1624: WSH_UTIL_CORE.printmsg('Insert failed for Null Region for Location : '||p_location_id);

1620: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1621: IF l_debug_on THEN
1622: WSH_DEBUG_SV.logmsg(l_module_name,'Insert failed for Null Region for Location : '||p_location_id);
1623: ELSE
1624: WSH_UTIL_CORE.printmsg('Insert failed for Null Region for Location : '||p_location_id);
1625: END IF;
1626: RAISE Insert_Failed;
1627: END IF;
1628: ELSE

Line 1775: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1771: IF l_debug_on THEN
1772: WSH_DEBUG_SV.logmsg(l_module_name,'After calling Insert_Record for location id :' || p_location_id);
1773: END IF;
1774:
1775: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1776: IF l_debug_on THEN
1777: WSH_DEBUG_SV.logmsg(l_module_name,'Insert failed for Region '||l_region_table(i).region_id||' for Location : '||p_location_id);
1778: ELSE
1779: WSH_UTIL_CORE.printmsg('Insert failed for Region '||l_region_table(i).region_id||' for Location : '||p_location_id);

Line 1779: WSH_UTIL_CORE.printmsg('Insert failed for Region '||l_region_table(i).region_id||' for Location : '||p_location_id);

1775: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1776: IF l_debug_on THEN
1777: WSH_DEBUG_SV.logmsg(l_module_name,'Insert failed for Region '||l_region_table(i).region_id||' for Location : '||p_location_id);
1778: ELSE
1779: WSH_UTIL_CORE.printmsg('Insert failed for Region '||l_region_table(i).region_id||' for Location : '||p_location_id);
1780: END IF;
1781: RAISE Insert_Failed;
1782: END IF;
1783: ELSE

Line 1907: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1903: EXCEPTION
1904:
1905: WHEN Insert_Failed THEN
1906:
1907: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1908: IF l_debug_on THEN
1909:
1910: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in API Insert_Record');
1911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INSERT_FAILED');

Line 1913: WSH_UTIL_CORE.printmsg('Failed in API Insert_Record');

1909:
1910: WSH_DEBUG_SV.logmsg(l_module_name,'Failed in API Insert_Record');
1911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INSERT_FAILED');
1912: ELSE
1913: WSH_UTIL_CORE.printmsg('Failed in API Insert_Record');
1914: END IF;
1915:
1916: rollback to wsh_location_exists;
1917:

Line 1920: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1916: rollback to wsh_location_exists;
1917:
1918: WHEN Others THEN
1919:
1920: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1921: l_sqlcode := SQLCODE;
1922: l_sqlerr := SQLERRM;
1923: IF l_debug_on THEN
1924: WSH_DEBUG_SV.logmsg(l_module_name,'When Others of Procedure Map_Location_To_Region for location : '||p_location_id);

Line 1965: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1961: l_sqlerr VARCHAR2(2000);
1962:
1963: BEGIN
1964:
1965: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1966:
1967: INSERT INTO WSH_REGION_LOCATIONS(
1968: region_id,
1969: location_id,

Line 1997: WSH_UTIL_CORE.printmsg(' Insert into WSH_REGION_LOCATIONS failed : ' || sqlerrm);

1993: EXCEPTION
1994:
1995: WHEN Others THEN
1996:
1997: WSH_UTIL_CORE.printmsg(' Insert into WSH_REGION_LOCATIONS failed : ' || sqlerrm);
1998: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1999:
2000: End Insert_Record;
2001:

Line 1998: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1994:
1995: WHEN Others THEN
1996:
1997: WSH_UTIL_CORE.printmsg(' Insert into WSH_REGION_LOCATIONS failed : ' || sqlerrm);
1998: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1999:
2000: End Insert_Record;
2001:
2002:

Line 2115: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN

2111: WSH_DEBUG_SV.log(l_module_name,'l_return_status1',l_return_status1);
2112: END IF;
2113:
2114: IF ( l_return_status1 NOT IN
2115: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
2116: l_pkg_name := 'WSH_LOCATIONS_PKG';
2117: l_proc_name := 'Process_Locations';
2118: raise e_loc;
2119: END IF;

Line 2136: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2132: IF l_debug_on THEN
2133: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
2134: END IF;
2135:
2136: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2137: IF l_debug_on THEN
2138: WSH_DEBUG_SV.pop(l_module_name);
2139: END IF;
2140: return 'SUCCESS';

Line 2241: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

2237: --
2238: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Transfer_Location';
2239: BEGIN
2240:
2241: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2242: --
2243: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2244: --
2245: IF l_debug_on IS NULL

Line 2359: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

2355: x_sqlcode => l_sqlcode,
2356: x_sqlerr => l_sqlerr);
2357:
2358: IF l_return_status NOT IN
2359: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2360: --
2361: IF l_debug_on THEN
2362: WSH_DEBUG_SV.log(l_module_name,'Failed in Procedure Process_Locations');
2363: END IF;

Line 2367: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

2363: END IF;
2364: END IF;
2365:
2366: IF l_map_regions = 'Y' AND l_return_status NOT IN
2367: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2368:
2369: IF l_debug_on THEN
2370: WSH_DEBUG_SV.log(l_module_name,'----------------------------------');
2371: WSH_DEBUG_SV.log(l_module_name,'*** Map Regions parameter is Yes ***');

Line 2386: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

2382: x_return_status => l_return_status,
2383: x_sqlcode => l_sqlcode,
2384: x_sqlerr => l_sqlerr);
2385:
2386: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2387: IF l_debug_on THEN
2388: WSH_DEBUG_SV.log(l_module_name,'Failed in Procedure Mapping_Regions_Main');
2389: END IF;
2390: END IF;

Line 2429: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2425:
2426: END IF;
2427:
2428: IF x_loc_rec.wsh_location_id IS NULL THEN
2429: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2430: END IF;
2431: IF l_debug_on THEN
2432: WSH_DEBUG_SV.log(l_module_name,'Returning wsh_location_id : '||x_loc_rec.wsh_location_id);
2433: WSH_DEBUG_SV.pop(l_module_name);

Line 2439: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

2435:
2436: EXCEPTION
2437:
2438: WHEN OTHERS THEN
2439: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2440: IF l_debug_on THEN
2441: WSH_DEBUG_SV.pop(l_module_name);
2442: END IF;
2443:

Line 2633: Region_Loc_zone_tab WSH_UTIL_CORE.Id_Tab_Type;

2629: l_ship_method_code VARCHAR2(30);
2630: l_prev_ship_method VARCHAR2(30);
2631: l_session_id NUMBER;
2632: l_transit_time NUMBER;
2633: Region_Loc_zone_tab WSH_UTIL_CORE.Id_Tab_Type;
2634: Loc_Region_zone_tab WSH_UTIL_CORE.Id_Tab_Type;
2635: get_From_Region_tab WSH_UTIL_CORE.Id_Tab_Type;
2636: get_To_Region_tab WSH_UTIL_CORE.Id_Tab_Type ;
2637: l_return_status VARCHAR2(55);

Line 2634: Loc_Region_zone_tab WSH_UTIL_CORE.Id_Tab_Type;

2630: l_prev_ship_method VARCHAR2(30);
2631: l_session_id NUMBER;
2632: l_transit_time NUMBER;
2633: Region_Loc_zone_tab WSH_UTIL_CORE.Id_Tab_Type;
2634: Loc_Region_zone_tab WSH_UTIL_CORE.Id_Tab_Type;
2635: get_From_Region_tab WSH_UTIL_CORE.Id_Tab_Type;
2636: get_To_Region_tab WSH_UTIL_CORE.Id_Tab_Type ;
2637: l_return_status VARCHAR2(55);
2638: dummy number (5);

Line 2635: get_From_Region_tab WSH_UTIL_CORE.Id_Tab_Type;

2631: l_session_id NUMBER;
2632: l_transit_time NUMBER;
2633: Region_Loc_zone_tab WSH_UTIL_CORE.Id_Tab_Type;
2634: Loc_Region_zone_tab WSH_UTIL_CORE.Id_Tab_Type;
2635: get_From_Region_tab WSH_UTIL_CORE.Id_Tab_Type;
2636: get_To_Region_tab WSH_UTIL_CORE.Id_Tab_Type ;
2637: l_return_status VARCHAR2(55);
2638: dummy number (5);
2639: CURSOR get_session_id IS

Line 2636: get_To_Region_tab WSH_UTIL_CORE.Id_Tab_Type ;

2632: l_transit_time NUMBER;
2633: Region_Loc_zone_tab WSH_UTIL_CORE.Id_Tab_Type;
2634: Loc_Region_zone_tab WSH_UTIL_CORE.Id_Tab_Type;
2635: get_From_Region_tab WSH_UTIL_CORE.Id_Tab_Type;
2636: get_To_Region_tab WSH_UTIL_CORE.Id_Tab_Type ;
2637: l_return_status VARCHAR2(55);
2638: dummy number (5);
2639: CURSOR get_session_id IS
2640: SELECT mrp_atp_schedule_temp_s.nextVal

Line 2717: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

2713: WSH_DEBUG_SV.log(l_module_name,'P_MODE_CODE',P_MODE_CODE);
2714: END IF;
2715: --
2716:
2717: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
2718: x_transit_time := null;
2719:
2720: IF p_ship_method_code IS NULL THEN
2721: