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_PICKING_BATCHES_GRP dependencies on WSH_DEBUG_SV

Line 242: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

238: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
239: --
240: IF l_debug_on IS NULL THEN
241: --{
242: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
243: --}
244: END IF;
245: --
246: SAVEPOINT PICKING_BATCH_GRP;

Line 254: wsh_debug_sv.push(l_module_name);

250: -- Debug Statements
251: --
252: IF l_debug_on THEN
253: --{
254: wsh_debug_sv.push(l_module_name);
255: --
256: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMBER', p_api_version_number);
257: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);
258: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);

Line 256: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMBER', p_api_version_number);

252: IF l_debug_on THEN
253: --{
254: wsh_debug_sv.push(l_module_name);
255: --
256: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMBER', p_api_version_number);
257: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);
258: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);
259: --}
260: END IF;

Line 257: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);

253: --{
254: wsh_debug_sv.push(l_module_name);
255: --
256: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMBER', p_api_version_number);
257: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);
258: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);
259: --}
260: END IF;
261:

Line 258: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);

254: wsh_debug_sv.push(l_module_name);
255: --
256: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMBER', p_api_version_number);
257: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);
258: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);
259: --}
260: END IF;
261:
262: IF NOT fnd_api.compatible_api_call(

Line 289: wsh_debug_sv.log(l_module_name,'PROCESSING THE RULE INFORMATION'|| ' P_RULE_ID : ' || TO_CHAR( l_rule_id ) || ' P_RULE_NAME: '|| l_rule_name);

285: -- Debug Statements
286: --
287: IF l_debug_on THEN
288: --{
289: wsh_debug_sv.log(l_module_name,'PROCESSING THE RULE INFORMATION'|| ' P_RULE_ID : ' || TO_CHAR( l_rule_id ) || ' P_RULE_NAME: '|| l_rule_name);
290: --}
291: END IF;
292: --
293: IF ( l_rule_id is NOT NULL AND l_rule_id <> FND_API.G_MISS_NUM ) OR ( l_rule_name is NOT NULL AND l_rule_name <> FND_API.G_MISS_CHAR ) THEN

Line 311: WSH_DEBUG_SV.logmsg(l_module_name, 'FETCHING PICKING RULE INFO FOR THE GIVEN RULE ID AND RULE NAME' );

307: -- Debug Statements
308: --
309: IF l_debug_on THEN
310: --{
311: WSH_DEBUG_SV.logmsg(l_module_name, 'FETCHING PICKING RULE INFO FOR THE GIVEN RULE ID AND RULE NAME' );
312: --}
313: END IF;
314: --
315: -- fetch Picking Rule Information for the given picking Rule Id

Line 366: WSH_DEBUG_SV.logmsg(l_module_name, 'P_RULE_ID : ' || TO_CHAR( p_rule_id ) || 'P_RULE_NAME: '|| p_rule_name || ' DOES NOT EXIST.');

362: -- Debug Statements
363: --
364: IF l_debug_on THEN
365: --{
366: WSH_DEBUG_SV.logmsg(l_module_name, 'P_RULE_ID : ' || TO_CHAR( p_rule_id ) || 'P_RULE_NAME: '|| p_rule_name || ' DOES NOT EXIST.');
367: --}
368: END IF;
369: --
370: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ATTRIBUTE');

Line 377: WSH_DEBUG_SV.pop(l_module_name);

373: wsh_util_core.add_message(x_return_status);
374: CLOSE Get_Picking_Rule_Info;
375: IF l_debug_on THEN
376: --{
377: WSH_DEBUG_SV.pop(l_module_name);
378: --}
379: END IF;
380: --
381: return;

Line 444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ORG',WSH_DEBUG_SV.C_PROC_LEVEL);

440: --{
441:
442: IF l_debug_on THEN
443: --{
444: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_ORG',WSH_DEBUG_SV.C_PROC_LEVEL);
445: --}
446: END IF;
447: WSH_UTIL_VALIDATE.Validate_Org(
448: p_Org_id => l_batch_in_rec.Organization_Id,

Line 454: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

450: x_return_status => l_return_status);
451:
452: IF l_debug_on THEN
453: --{
454: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
455: --}
456: END IF;
457: --
458: wsh_util_core.api_post_call(

Line 470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.Check_Wms_Org',WSH_DEBUG_SV.C_PROC_LEVEL);

466:
467: -- Bug# 3480908 - start - Checking whether the org is a WMS org
468: IF l_debug_on THEN
469: --{
470: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.Check_Wms_Org',WSH_DEBUG_SV.C_PROC_LEVEL);
471: --}
472: END IF;
473: l_is_WMS_org := WSH_UTIL_VALIDATE.Check_Wms_Org(
474: p_organization_id => l_batch_grp_rec.Organization_Id);

Line 478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

474: p_organization_id => l_batch_grp_rec.Organization_Id);
475:
476: IF l_debug_on THEN
477: --{
478: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
479: --}
480: END IF;
481: --
482: wsh_util_core.api_post_call(

Line 518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_REPORT_SET',WSH_DEBUG_SV.C_PROC_LEVEL);

514: IF ( l_batch_in_rec.Document_Set_Id IS NOT NULL) OR ( l_batch_in_rec.Document_Set_name IS NOT NULL) THEN
515: --{
516: IF l_debug_on THEN
517: --{
518: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_REPORT_SET',WSH_DEBUG_SV.C_PROC_LEVEL);
519: --}
520: END IF;
521: WSH_UTIL_VALIDATE.Validate_Report_Set(
522: p_report_set_id => l_batch_in_rec.Document_Set_Id,

Line 528: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

524: x_return_status => l_return_status);
525:
526: IF l_debug_on THEN
527: --{
528: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
529: --}
530: END IF;
531: --
532: wsh_util_core.api_post_call(

Line 566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD',WSH_DEBUG_SV.C_PROC_LEVEL);

562: IF ( l_batch_in_rec.Ship_Method_Code IS NOT NULL) OR ( l_batch_in_rec.Ship_Method_Name IS NOT NULL) THEN
563: --{
564: IF l_debug_on THEN
565: --{
566: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_METHOD',WSH_DEBUG_SV.C_PROC_LEVEL);
567: --}
568: END IF;
569: WSH_UTIL_VALIDATE.Validate_Ship_Method(
570: p_ship_method_code => l_batch_in_rec.Ship_Method_Code,

Line 576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

572: x_return_status => l_return_status);
573:
574: IF l_debug_on THEN
575: --{
576: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
577: --}
578: END IF;
579: --
580: wsh_util_core.api_post_call(

Line 614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CUSTOMER',WSH_DEBUG_SV.C_PROC_LEVEL);

610: IF ( ( l_batch_in_rec.Customer_Id IS NOT NULL) OR ( l_batch_in_rec.Customer_Number IS NOT NULL) ) THEN
611: --{
612: IF l_debug_on THEN
613: --{
614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CUSTOMER',WSH_DEBUG_SV.C_PROC_LEVEL);
615: --}
616: END IF;
617: WSH_UTIL_VALIDATE.Validate_Customer(
618: p_Customer_id => l_batch_in_rec.Customer_Id,

Line 624: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

620: x_return_status => l_return_status);
621:
622: IF l_debug_on THEN
623: --{
624: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
625: --}
626: END IF;
627: --
628: wsh_util_core.api_post_call(

Line 798: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);

794: IF ( ( l_batch_in_rec.Ship_To_Location_Id IS NOT NULL) OR ( l_batch_in_rec.Ship_To_Location_code IS NOT NULL ) ) THEN
795: --{
796: IF l_debug_on THEN
797: --{
798: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
799: --}
800: END IF;
801: WSH_UTIL_VALIDATE.Validate_Location(
802: p_location_id => l_batch_in_rec.Ship_To_Location_Id,

Line 809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

805: p_isWshLocation => TRUE);
806:
807: IF l_debug_on THEN
808: --{
809: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
810: --}
811: END IF;
812: --
813: wsh_util_core.api_post_call(

Line 850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);

846: IF ( ( l_batch_in_rec.Ship_From_Location_Id IS NOT NULL) OR ( l_batch_in_rec.Ship_From_Location_code IS NOT NULL ) ) THEN
847: --{
848: IF l_debug_on THEN
849: --{
850: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_LOCATION',WSH_DEBUG_SV.C_PROC_LEVEL);
851: --}
852: END IF;
853: WSH_UTIL_VALIDATE.Validate_Location(
854: p_location_id => l_batch_in_rec.Ship_From_Location_Id,

Line 861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

857: p_isWshLocation => TRUE);
858:
859: IF l_debug_on THEN
860: --{
861: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
862: --}
863: END IF;
864: --
865: wsh_util_core.api_post_call(

Line 904: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

900: IF ( ( l_batch_in_rec.Trip_Id IS NOT NULL ) OR ( l_batch_in_rec.Trip_Name IS NOT NULL ) ) THEN
901: --{
902: IF l_debug_on THEN
903: --{
904: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_TRIP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
905: --}
906: END IF;
907: WSH_UTIL_VALIDATE.Validate_Trip_Name(
908: p_trip_id => l_batch_in_rec.Trip_Id,

Line 914: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

910: x_return_status => l_return_status);
911:
912: IF l_debug_on THEN
913: --{
914: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
915: --}
916: END IF;
917: --
918: wsh_util_core.api_post_call(

Line 953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

949: IF ( ( l_batch_in_rec.Delivery_Id IS NOT NULL) OR ( l_batch_in_rec.Delivery_Name IS NOT NULL ) ) THEN
950: --{
951: IF l_debug_on THEN
952: --{
953: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_DELIVERY_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
954: --}
955: END IF;
956: WSH_UTIL_VALIDATE.Validate_Delivery_Name(
957: p_delivery_id => l_batch_in_rec.Delivery_Id,

Line 963: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

959: x_return_status => l_return_status);
960:
961: IF l_debug_on THEN
962: --{
963: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
964: --}
965: END IF;
966: --
967: wsh_util_core.api_post_call(

Line 1015: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_STOP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1011: IF ( ( l_batch_in_rec.Trip_Stop_Id IS NOT NULL ) OR ( l_batch_in_rec.trip_stop_location_id IS NOT NULL ) ) THEN
1012: --{
1013: IF l_debug_on THEN
1014: --{
1015: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_STOP_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1016: --}
1017: END IF;
1018: WSH_UTIL_VALIDATE.Validate_Stop_Name(
1019: p_stop_id => l_batch_in_rec.Trip_Stop_Id,

Line 1027: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1023: x_return_status => l_return_status);
1024:
1025: IF l_debug_on THEN
1026: --{
1027: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1028: --}
1029: END IF;
1030: --
1031: wsh_util_core.api_post_call(

Line 1069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_GROUP_RULE_NAMe',WSH_DEBUG_SV.C_PROC_LEVEL);

1065: IF ( ( l_batch_in_rec.pick_grouping_rule_Id IS NOT NULL) OR ( l_batch_in_rec.pick_grouping_rule_Name IS NOT NULL ) ) THEN
1066: --{
1067: IF l_debug_on THEN
1068: --{
1069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_GROUP_RULE_NAMe',WSH_DEBUG_SV.C_PROC_LEVEL);
1070: --}
1071: END IF;
1072: WSH_UTIL_VALIDATE.Validate_Pick_Group_Rule_Name(
1073: p_pick_grouping_rule_id => l_batch_in_rec.pick_grouping_rule_Id,

Line 1079: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1075: x_return_status => l_return_status);
1076:
1077: IF l_debug_on THEN
1078: --{
1079: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1080: --}
1081: END IF;
1082: --
1083: wsh_util_core.api_post_call(

Line 1118: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_SEQ_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1114: IF ( ( l_batch_in_rec.pick_sequence_rule_Id IS NOT NULL) OR ( l_batch_in_rec.pick_sequence_rule_Name IS NOT NULL ) ) THEN
1115: --{
1116: IF l_debug_on THEN
1117: --{
1118: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_PICK_SEQ_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1119: --}
1120: END IF;
1121: WSH_UTIL_VALIDATE.Validate_Pick_Seq_Rule_Name(
1122: p_pick_sequence_rule_id => l_batch_in_rec.pick_sequence_rule_Id,

Line 1128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1124: x_return_status => l_return_status);
1125:
1126: IF l_debug_on THEN
1127: --{
1128: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1129: --}
1130: END IF;
1131: --
1132: wsh_util_core.api_post_call(

Line 1204: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_CON_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

1200: IF ( ( l_batch_in_rec.ship_confirm_rule_Id IS NOT NULL) OR ( l_batch_in_rec.ship_confirm_rule_Name IS NOT NULL ) ) THEN
1201: --{
1202: IF l_debug_on THEN
1203: --{
1204: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_SHIP_CON_RULE_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1205: --}
1206: END IF;
1207: WSH_UTIL_VALIDATE.Validate_Ship_Con_Rule_Name(
1208: p_ship_confirm_rule_id => l_batch_in_rec.ship_confirm_rule_Id,

Line 1214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1210: x_return_status => l_return_status);
1211:
1212: IF l_debug_on THEN
1213: --{
1214: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1215: --}
1216: END IF;
1217: --
1218: wsh_util_core.api_post_call(

Line 1250: wsh_debug_sv.logmsg(l_module_name, 'Error - WSH_NO_ACTUAL_DEP_DATE');

1246: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1247: wsh_util_core.add_message(x_return_status);
1248: --
1249: IF l_debug_on THEN
1250: wsh_debug_sv.logmsg(l_module_name, 'Error - WSH_NO_ACTUAL_DEP_DATE');
1251: wsh_debug_sv.pop(l_module_name);
1252: END IF;
1253: --
1254: RETURN;

Line 1251: wsh_debug_sv.pop(l_module_name);

1247: wsh_util_core.add_message(x_return_status);
1248: --
1249: IF l_debug_on THEN
1250: wsh_debug_sv.logmsg(l_module_name, 'Error - WSH_NO_ACTUAL_DEP_DATE');
1251: wsh_debug_sv.pop(l_module_name);
1252: END IF;
1253: --
1254: RETURN;
1255: --

Line 1303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CARRIER',WSH_DEBUG_SV.C_PROC_LEVEL);

1299: IF ( ( l_batch_in_rec.Carrier_Id IS NOT NULL ) OR ( l_batch_in_rec.Carrier_Name IS NOT NULL ) ) THEN
1300: --{
1301: IF l_debug_on THEN
1302: --{
1303: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_VALIDATE.VALIDATE_CARRIER',WSH_DEBUG_SV.C_PROC_LEVEL);
1304: --}
1305: END IF;
1306: WSH_UTIL_VALIDATE.Validate_Carrier(
1307: x_Carrier_id => l_batch_in_rec.Carrier_Id,

Line 1313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1309: x_return_status => l_return_status);
1310:
1311: IF l_debug_on THEN
1312: --{
1313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1314: --}
1315: END IF;
1316: --
1317: wsh_util_core.api_post_call(

Line 2182: WSH_DEBUG_SV.pop(l_module_name);

2178: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2179: wsh_util_core.add_message(x_return_status);
2180: --
2181: IF l_debug_on THEN
2182: WSH_DEBUG_SV.pop(l_module_name);
2183: END IF;
2184: --
2185: return;
2186: --}

Line 2201: wsh_debug_sv.pop(l_module_name);

2197: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2198: wsh_util_core.add_message(x_return_status, l_module_name);
2199: --
2200: IF l_debug_on THEN
2201: wsh_debug_sv.pop(l_module_name);
2202: END IF;
2203: --
2204: RETURN;
2205: --}

Line 2215: WSH_DEBUG_SV.pop(l_module_name);

2211: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_ORGANIZATION');
2212: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2213: wsh_util_core.add_message(x_return_status);
2214: IF l_debug_on THEN
2215: WSH_DEBUG_SV.pop(l_module_name);
2216: END IF;
2217: return;
2218: END IF;
2219:

Line 2226: wsh_debug_sv.logmsg(l_module_name, 'Return status from WSH_SHIPPING_PARAMS_PVT.Get is :'||l_return_status );

2222: x_param_info => l_param_info,
2223: x_return_status => l_return_status);
2224:
2225: IF l_debug_on THEN
2226: wsh_debug_sv.logmsg(l_module_name, 'Return status from WSH_SHIPPING_PARAMS_PVT.Get is :'||l_return_status );
2227: END IF;
2228:
2229: wsh_util_core.api_post_call(
2230: p_return_status => l_return_status,

Line 2242: WSH_DEBUG_SV.pop(l_module_name);

2238: FND_MESSAGE.SET_NAME('ORGANIZATION_NAME', WSH_UTIL_CORE.Get_Org_Name(l_batch_grp_rec.organization_id));
2239: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2240: wsh_util_core.add_message(x_return_status);
2241: IF l_debug_on THEN
2242: WSH_DEBUG_SV.pop(l_module_name);
2243: END IF;
2244: return;
2245: END IF;
2246:

Line 2252: WSH_DEBUG_SV.pop(l_module_name);

2248: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTOCREATE_DEL');
2249: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2250: wsh_util_core.add_message(x_return_status);
2251: IF l_debug_on THEN
2252: WSH_DEBUG_SV.pop(l_module_name);
2253: END IF;
2254: return;
2255: END IF;
2256:

Line 2262: WSH_DEBUG_SV.pop(l_module_name);

2258: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AC_DEL_CRITERIA');
2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2260: wsh_util_core.add_message(x_return_status);
2261: IF l_debug_on THEN
2262: WSH_DEBUG_SV.pop(l_module_name);
2263: END IF;
2264: return;
2265: END IF;
2266:

Line 2272: WSH_DEBUG_SV.pop(l_module_name);

2268: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PICK');
2269: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2270: wsh_util_core.add_message(x_return_status);
2271: IF l_debug_on THEN
2272: WSH_DEBUG_SV.pop(l_module_name);
2273: END IF;
2274: return;
2275: END IF;
2276:

Line 2282: WSH_DEBUG_SV.pop(l_module_name);

2278: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_SHIP');
2279: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2280: wsh_util_core.add_message(x_return_status);
2281: IF l_debug_on THEN
2282: WSH_DEBUG_SV.pop(l_module_name);
2283: END IF;
2284: return;
2285: END IF;
2286:

Line 2292: WSH_DEBUG_SV.pop(l_module_name);

2288: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_APPEND_AUTO_PACK');
2289: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2290: wsh_util_core.add_message(x_return_status);
2291: IF l_debug_on THEN
2292: WSH_DEBUG_SV.pop(l_module_name);
2293: END IF;
2294: return;
2295: END IF;
2296:

Line 2303: WSH_DEBUG_SV.pop(l_module_name);

2299: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'APPEND_FLAG');
2300: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2301: wsh_util_core.add_message(x_return_status);
2302: IF l_debug_on THEN
2303: WSH_DEBUG_SV.pop(l_module_name);
2304: END IF;
2305: return;
2306: END IF;
2307: -- Bug 3463315 End of Append_Flag validation

Line 2321: WSH_DEBUG_SV.pop(l_module_name);

2317: FND_MESSAGE.SET_NAME('WSH','WSH_ORG_SHIPFROM_NOT_COMP');
2318: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2319: wsh_util_core.add_message(x_return_status);
2320: IF l_debug_on THEN
2321: WSH_DEBUG_SV.pop(l_module_name);
2322: END IF;
2323: return;
2324: END IF;
2325: ELSIF l_batch_grp_rec.Organization_Id IS NOT NULL THEN

Line 2351: WSH_DEBUG_SV.pop(l_module_name);

2347: FND_MESSAGE.SET_NAME('WSH','WSH_PR_NO_WAREHOUSE');
2348: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2349: wsh_util_core.add_message(x_return_status);
2350: IF l_debug_on THEN
2351: WSH_DEBUG_SV.pop(l_module_name);
2352: END IF;
2353: RETURN;
2354: ELSE --}{
2355: -- Warning if warehouse specified and others null

Line 2401: WSH_DEBUG_SV.pop(l_module_name);

2397: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2398: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2399: wsh_util_core.add_message(x_return_status);
2400: IF l_debug_on THEN
2401: WSH_DEBUG_SV.pop(l_module_name);
2402: END IF;
2403: RETURN;
2404: ELSIF l_batch_grp_rec.crossdock_criteria_id IS NOT NULL AND
2405: l_batch_grp_rec.allocation_method IN (WSH_PICK_LIST.C_CROSSDOCK_ONLY,

Line 2416: WSH_DEBUG_SV.pop(l_module_name);

2412: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_XDOCK_CRITERION');
2413: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2414: wsh_util_core.add_message(x_return_status);
2415: IF l_debug_on THEN
2416: WSH_DEBUG_SV.pop(l_module_name);
2417: END IF;
2418: RETURN;
2419: END IF;
2420: ELSIF (l_batch_grp_rec.crossdock_criteria_id IS NOT NULL AND

Line 2426: WSH_DEBUG_SV.pop(l_module_name);

2422: FND_MESSAGE.SET_NAME('WSH','WSH_XDOCK_INVALID_ALLOCMETHOD');
2423: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2424: wsh_util_core.add_message(x_return_status);
2425: IF l_debug_on THEN
2426: WSH_DEBUG_SV.pop(l_module_name);
2427: END IF;
2428: RETURN;
2429: -- Bug#7168917: Dynamic_replenish_flag value should not be 'Yes' when
2430: -- allocation method is 'Cross Dock Only' OR 'Prioritize Inventory'.

Line 2438: WSH_DEBUG_SV.pop(l_module_name);

2434: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'DYNAMIC_REPLENISHMENT_FLAG');
2435: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2436: wsh_util_core.add_message(x_return_status);
2437: IF l_debug_on THEN
2438: WSH_DEBUG_SV.pop(l_module_name);
2439: END IF;
2440: RETURN;
2441: END IF;
2442: ELSE -- non WMS org

Line 2449: WSH_DEBUG_SV.pop(l_module_name);

2445: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ALLOCATION_METHOD');
2446: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2447: wsh_util_core.add_message(x_return_status);
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.pop(l_module_name);
2450: END IF;
2451: RETURN;
2452: END IF;
2453: --}

Line 2465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);

2461: -- Calling the Private API to Create the Batch
2462:
2463: IF l_debug_on THEN
2464: --{
2465: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.INSERT_ROW',WSH_DEBUG_SV.C_PROC_LEVEL);
2466: --}
2467: END IF;
2468: --
2469: WSH_PICKING_BATCHES_PKG.Insert_Row(

Line 2555: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2551: );
2552:
2553: IF l_debug_on THEN
2554: --{
2555: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2556: --}
2557: END IF;
2558: --
2559: wsh_util_core.api_post_call(

Line 2583: WSH_DEBUG_SV.pop(l_module_name);

2579: );
2580:
2581: IF l_debug_on THEN
2582: --{
2583: WSH_DEBUG_SV.pop(l_module_name);
2584: --}
2585: END IF;
2586: --
2587: EXCEPTION

Line 2601: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2597: );
2598:
2599: IF l_debug_on THEN
2600: --{
2601: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2602: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2603: --}
2604: END IF;
2605: --

Line 2602: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

2598:
2599: IF l_debug_on THEN
2600: --{
2601: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2602: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2603: --}
2604: END IF;
2605: --
2606:

Line 2622: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PUB_CONSOL_DEL_PR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2618: );
2619:
2620: IF l_debug_on THEN
2621: --{
2622: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PUB_CONSOL_DEL_PR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PUB_CONSOL_DEL_PR');
2624: --}
2625: END IF;
2626: --

Line 2623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PUB_CONSOL_DEL_PR');

2619:
2620: IF l_debug_on THEN
2621: --{
2622: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_PUB_CONSOL_DEL_PR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_PUB_CONSOL_DEL_PR');
2624: --}
2625: END IF;
2626: --
2627:

Line 2642: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2638: --
2639:
2640: IF l_debug_on THEN
2641: --{
2642: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2644: --}
2645: END IF;
2646: WHEN OTHERS THEN

Line 2643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2639:
2640: IF l_debug_on THEN
2641: --{
2642: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2643: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2644: --}
2645: END IF;
2646: WHEN OTHERS THEN
2647: ROLLBACK TO PICKING_BATCH_GRP;

Line 2659: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2655: );
2656:
2657: IF l_debug_on THEN
2658: --{
2659: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2660: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2661: --}
2662: END IF;
2663: --

Line 2660: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

2656:
2657: IF l_debug_on THEN
2658: --{
2659: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2660: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2661: --}
2662: END IF;
2663: --
2664: END Create_Batch;

Line 2752: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2748: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2749: --
2750: IF l_debug_on IS NULL THEN
2751: --{
2752: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2753: --}
2754: END IF;
2755: --
2756: SAVEPOINT PICKING_BATCH_GRP;

Line 2764: wsh_debug_sv.push(l_module_name);

2760: -- Debug Statements
2761: --
2762: IF l_debug_on THEN
2763: --{
2764: wsh_debug_sv.push(l_module_name);
2765: --
2766: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMER', p_api_version_number);
2767: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);
2768: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);

Line 2766: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMER', p_api_version_number);

2762: IF l_debug_on THEN
2763: --{
2764: wsh_debug_sv.push(l_module_name);
2765: --
2766: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMER', p_api_version_number);
2767: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);
2768: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);
2769: wsh_debug_sv.LOG(l_module_name, 'P_NUM_WORKERS', p_num_workers);
2770: --}

Line 2767: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);

2763: --{
2764: wsh_debug_sv.push(l_module_name);
2765: --
2766: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMER', p_api_version_number);
2767: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);
2768: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);
2769: wsh_debug_sv.LOG(l_module_name, 'P_NUM_WORKERS', p_num_workers);
2770: --}
2771: END IF;

Line 2768: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);

2764: wsh_debug_sv.push(l_module_name);
2765: --
2766: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMER', p_api_version_number);
2767: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);
2768: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);
2769: wsh_debug_sv.LOG(l_module_name, 'P_NUM_WORKERS', p_num_workers);
2770: --}
2771: END IF;
2772:

Line 2769: wsh_debug_sv.LOG(l_module_name, 'P_NUM_WORKERS', p_num_workers);

2765: --
2766: wsh_debug_sv.LOG(l_module_name, 'P_API_VERSION_NUMER', p_api_version_number);
2767: wsh_debug_sv.LOG(l_module_name, 'P_INIT_MSG_LIST', p_init_msg_list);
2768: wsh_debug_sv.LOG(l_module_name, 'P_COMMIT', p_commit);
2769: wsh_debug_sv.LOG(l_module_name, 'P_NUM_WORKERS', p_num_workers);
2770: --}
2771: END IF;
2772:
2773: IF NOT fnd_api.compatible_api_call(

Line 2819: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2815: x_return_status => l_return_status);
2816:
2817: IF l_debug_on THEN
2818: --{
2819: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2820: --}
2821: END IF;
2822: --
2823: wsh_util_core.api_post_call(

Line 2865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2861: x_return_status => l_return_status);
2862:
2863: IF l_debug_on THEN
2864: --{
2865: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2866: --}
2867: END IF;
2868: --
2869: wsh_util_core.api_post_call(

Line 2884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);

2880: IF ( p_release_mode = 'CONCURRENT' ) THEN
2881: --{
2882: IF l_debug_on THEN
2883: --{
2884: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICKING_BATCHES_PKG.SUBMIT_RELEASE_REQUEST',WSH_DEBUG_SV.C_PROC_LEVEL);
2885: --}
2886: END IF;
2887: --
2888: x_request_id := WSH_PICKING_BATCHES_PKG.Submit_Release_Request(

Line 2894: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2890: p_log_level => l_log_level,
2891: p_num_workers => p_num_workers);
2892: IF l_debug_on THEN
2893: --{
2894: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2895: --}
2896: END IF;
2897: --
2898: wsh_util_core.api_post_call(

Line 2918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.ONLINE_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);

2914:
2915: ELSE
2916: IF l_debug_on THEN
2917: --{
2918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_PICK_LIST.ONLINE_RELEASE',WSH_DEBUG_SV.C_PROC_LEVEL);
2919: --}
2920: END IF;
2921: --
2922: WSH_PICK_LIST.Online_Release(

Line 2930: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2926: p_pick_skip => l_pick_skip);
2927:
2928: IF l_debug_on THEN
2929: --{
2930: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2931: --}
2932: END IF;
2933: --
2934: wsh_util_core.api_post_call(

Line 2981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

2977:
2978:
2979: IF l_debug_on THEN
2980: --{
2981: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
2982: --}
2983: END IF;
2984: --
2985: wsh_util_core.api_post_call(

Line 3007: WSH_DEBUG_SV.pop(l_module_name);

3003: );
3004:
3005: IF l_debug_on THEN
3006: --{
3007: WSH_DEBUG_SV.pop(l_module_name);
3008: --}
3009: END IF;
3010: --
3011: EXCEPTION

Line 3025: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3021: );
3022:
3023: IF l_debug_on THEN
3024: --{
3025: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3027: --}
3028: END IF;
3029: --

Line 3026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

3022:
3023: IF l_debug_on THEN
3024: --{
3025: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3027: --}
3028: END IF;
3029: --
3030:

Line 3045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3041: --
3042:
3043: IF l_debug_on THEN
3044: --{
3045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3047: --}
3048: END IF;
3049: WHEN OTHERS THEN

Line 3046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

3042:
3043: IF l_debug_on THEN
3044: --{
3045: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3046: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3047: --}
3048: END IF;
3049: WHEN OTHERS THEN
3050: ROLLBACK TO PICKING_BATCH_GRP;

Line 3062: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

3058: );
3059:
3060: IF l_debug_on THEN
3061: --{
3062: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3063: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3064: --}
3065: END IF;
3066: --

Line 3063: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

3059:
3060: IF l_debug_on THEN
3061: --{
3062: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3063: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3064: --}
3065: END IF;
3066: --
3067: END Release_Batch;