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

Line 27: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

23: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
24: --
25: IF l_debug_on IS NULL
26: THEN
27: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
28: END IF;
29: --
30: IF l_debug_on THEN
31: wsh_debug_sv.push (l_module_name, 'Rtrim_delivery');

Line 31: wsh_debug_sv.push (l_module_name, 'Rtrim_delivery');

27: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
28: END IF;
29: --
30: IF l_debug_on THEN
31: wsh_debug_sv.push (l_module_name, 'Rtrim_delivery');
32: END IF;
33:
34: p_out_rec := p_in_rec;
35:

Line 142: WSH_DEBUG_SV.pop(l_module_name);

138: p_out_rec.AUTO_AP_EXCLUDE_FLAG :=RTRIM(p_in_rec.AUTO_AP_EXCLUDE_FLAG);
139:
140:
141: IF l_debug_on THEN
142: WSH_DEBUG_SV.pop(l_module_name);
143: END IF;
144:
145: EXCEPTION
146:

Line 151: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||

147: WHEN OTHERS THEN
148: wsh_util_core.default_handler (
149: 'WSH_TRIP_STOPS_GRP.Rtrim_delivery', l_module_name);
150: IF l_debug_on THEN
151: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
152: ' Oracle error message is '|| SQLERRM,
153: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
155: END IF;

Line 153: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

149: 'WSH_TRIP_STOPS_GRP.Rtrim_delivery', l_module_name);
150: IF l_debug_on THEN
151: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
152: ' Oracle error message is '|| SQLERRM,
153: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
155: END IF;
156: RAISE;
157:

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

150: IF l_debug_on THEN
151: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
152: ' Oracle error message is '|| SQLERRM,
153: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
155: END IF;
156: RAISE;
157:
158: END Rtrim_delivery;

Line 495: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

491: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
492: --
493: IF l_debug_on IS NULL
494: THEN
495: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
496: END IF;
497: --
498: IF l_debug_on THEN
499: WSH_DEBUG_SV.push(l_module_name);

Line 499: WSH_DEBUG_SV.push(l_module_name);

495: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
496: END IF;
497: --
498: IF l_debug_on THEN
499: WSH_DEBUG_SV.push(l_module_name);
500: END IF;
501: x_return_status := wsh_util_core.g_ret_sts_success;
502: --
503: x_pvt_rec.DELIVERY_ID := p_pub_rec.DELIVERY_ID;

Line 657: WSH_DEBUG_SV.pop(l_module_name);

653: END IF;
654: --
655:
656: IF l_debug_on THEN
657: WSH_DEBUG_SV.pop(l_module_name);
658: END IF;
659: EXCEPTION
660: WHEN OTHERS THEN
661: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_PUB.map_pub_to_pvt',l_module_name);

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

661: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_PUB.map_pub_to_pvt',l_module_name);
662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
663: --
664: IF l_debug_on THEN
665: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
666: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
667: END IF;
668: --
669: END map_pub_to_pvt;

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

662: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
663: --
664: IF l_debug_on THEN
665: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
666: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
667: END IF;
668: --
669: END map_pub_to_pvt;
670:

Line 727: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

723: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
724: --
725: IF l_debug_on IS NULL
726: THEN
727: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
728: END IF;
729: --
730: IF l_debug_on THEN
731: wsh_debug_sv.push(l_module_name);

Line 731: wsh_debug_sv.push(l_module_name);

727: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
728: END IF;
729: --
730: IF l_debug_on THEN
731: wsh_debug_sv.push(l_module_name);
732: END IF;
733: -- Standard call to check for call compatibility
734: IF NOT FND_API.Compatible_API_Call
735: ( l_api_version_number

Line 767: wsh_debug_sv.log(l_module_name,'Return Status After Calling map_pub_to_pvt',l_return_status);

763: x_pvt_rec => l_rec_attr_tab(1),
764: x_return_status => l_return_status);
765: --
766: IF l_debug_on THEN
767: wsh_debug_sv.log(l_module_name,'Return Status After Calling map_pub_to_pvt',l_return_status);
768: END IF;
769: --
770: wsh_util_core.api_post_call(
771: p_return_status => l_return_status,

Line 783: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_delivery_name',l_return_status);

779: p_delivery_name => l_rec_attr_tab(1).name,
780: x_return_status => l_return_status);
781: --
782: IF l_debug_on THEN
783: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_delivery_name',l_return_status);
784: END IF;
785: --
786: wsh_util_core.api_post_call(
787: p_return_status => l_return_status,

Line 817: wsh_debug_sv.log(l_module_name,'Return Status After Calling create_update_delivery',l_return_status);

813: x_msg_count => x_msg_count,
814: x_msg_data => x_msg_data);
815: --
816: IF l_debug_on THEN
817: wsh_debug_sv.log(l_module_name,'Return Status After Calling create_update_delivery',l_return_status);
818: END IF;
819: --
820: wsh_util_core.api_post_call(
821: p_return_status => l_return_status,

Line 846: WSH_DEBUG_SV.pop(l_module_name);

842: , p_data => x_msg_data
843: );
844: --
845: IF l_debug_on THEN
846: WSH_DEBUG_SV.pop(l_module_name);
847: END IF;
848: --
849: EXCEPTION
850: WHEN FND_API.G_EXC_ERROR THEN

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

855: , p_data => x_msg_data
856: );
857: --
858: IF l_debug_on THEN
859: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
861: END IF;
862: --
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

856: );
857: --
858: IF l_debug_on THEN
859: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
860: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
861: END IF;
862: --
863: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

868: , p_data => x_msg_data
869: );
870: --
871: IF l_debug_on THEN
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
874: END IF;
875: --
876: WHEN OTHERS THEN

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

869: );
870: --
871: IF l_debug_on THEN
872: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
873: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
874: END IF;
875: --
876: WHEN OTHERS THEN
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

888: , p_data => x_msg_data
889: );
890: --
891: IF l_debug_on THEN
892: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
893: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
894: END IF;
895: --
896: END Create_Update_Delivery;

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

889: );
890: --
891: IF l_debug_on THEN
892: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
893: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
894: END IF;
895: --
896: END Create_Update_Delivery;
897:

Line 967: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

963: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
964: --
965: IF l_debug_on IS NULL
966: THEN
967: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
968: END IF;
969: --
970: IF l_debug_on THEN
971: wsh_debug_sv.push(l_module_name);

Line 971: wsh_debug_sv.push(l_module_name);

967: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
968: END IF;
969: --
970: IF l_debug_on THEN
971: wsh_debug_sv.push(l_module_name);
972: END IF;
973: --
974: -- Standard call to check for call compatibility
975: IF NOT FND_API.Compatible_API_Call

Line 996: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_delivery_name',l_return_status);

992: p_delivery_name => p_delivery_name,
993: x_return_status => l_return_status);
994: --
995: IF l_debug_on THEN
996: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_delivery_name',l_return_status);
997: END IF;
998: --
999: wsh_util_core.api_post_call(
1000: p_return_status => l_return_status,

Line 1054: wsh_debug_sv.log(l_module_name,'Return Status After Calling Delivery_Action Wrapper',x_return_status);

1050: x_msg_count => x_msg_count,
1051: x_msg_data => x_msg_data);
1052: --
1053: IF l_debug_on THEN
1054: wsh_debug_sv.log(l_module_name,'Return Status After Calling Delivery_Action Wrapper',x_return_status);
1055: END IF;
1056: --
1057: wsh_util_core.api_post_call(
1058: p_return_status => x_return_status,

Line 1084: WSH_DEBUG_SV.pop(l_module_name);

1080: , p_data => x_msg_data
1081: );
1082: --
1083: IF l_debug_on THEN
1084: WSH_DEBUG_SV.pop(l_module_name);
1085: END IF;
1086: --
1087: EXCEPTION
1088: WHEN FND_API.G_EXC_ERROR THEN

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

1093: , p_data => x_msg_data
1094: );
1095: --
1096: IF l_debug_on THEN
1097: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1098: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1099: END IF;
1100: --
1101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1094: );
1095: --
1096: IF l_debug_on THEN
1097: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1098: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1099: END IF;
1100: --
1101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1106: , p_data => x_msg_data
1107: );
1108: --
1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1112: END IF;
1113: --
1114: WHEN OTHERS THEN

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

1107: );
1108: --
1109: IF l_debug_on THEN
1110: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1112: END IF;
1113: --
1114: WHEN OTHERS THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1126: , p_data => x_msg_data
1127: );
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1132: END IF;
1133: --
1134:

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

1127: );
1128: --
1129: IF l_debug_on THEN
1130: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1131: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1132: END IF;
1133: --
1134:
1135: END Delivery_Action;

Line 1200: l_debug_on := WSH_DEBUG_SV.Is_Debug_Enabled;

1196: -- Enabling Debug Starts
1197: l_debug_on := WSH_DEBUG_INTERFACE.G_DEBUG;
1198:
1199: IF ( l_debug_on IS NULL ) THEN
1200: l_debug_on := WSH_DEBUG_SV.Is_Debug_Enabled;
1201: END IF;
1202:
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');

Line 1204: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');

1200: l_debug_on := WSH_DEBUG_SV.Is_Debug_Enabled;
1201: END IF;
1202:
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');
1205: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1206: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1207: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1208: IF p_delivery_name.count > 0 THEN

Line 1205: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');

1201: END IF;
1202:
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');
1205: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1206: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1207: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1208: IF p_delivery_name.count > 0 THEN
1209: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');

Line 1206: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);

1202:
1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');
1205: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1206: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1207: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1208: IF p_delivery_name.count > 0 THEN
1209: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');
1210: FOR i IN 1..p_delivery_name.count LOOP

Line 1207: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);

1203: IF l_debug_on THEN
1204: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');
1205: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1206: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1207: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1208: IF p_delivery_name.count > 0 THEN
1209: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');
1210: FOR i IN 1..p_delivery_name.count LOOP
1211: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Delivery_Name(' || i || ') => '

Line 1209: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');

1205: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1206: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1207: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1208: IF p_delivery_name.count > 0 THEN
1209: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');
1210: FOR i IN 1..p_delivery_name.count LOOP
1211: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Delivery_Name(' || i || ') => '
1212: || p_delivery_name(i));
1213: END LOOP;

Line 1211: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Delivery_Name(' || i || ') => '

1207: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1208: IF p_delivery_name.count > 0 THEN
1209: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');
1210: FOR i IN 1..p_delivery_name.count LOOP
1211: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Delivery_Name(' || i || ') => '
1212: || p_delivery_name(i));
1213: END LOOP;
1214: END IF;
1215: END IF;

Line 1227: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status from Validate_Org : ' || x_return_status);

1223: l_organization_id ,
1224: p_organization_code,
1225: x_return_status );
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status from Validate_Org : ' || x_return_status);
1228: END IF;
1229:
1230: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1231: RAISE WSH_INVALID_ORGANIZATION;

Line 1248: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status for Delivery Name (' ||

1244: l_delivery_id ,
1245: l_delivery_name,
1246: x_return_status);
1247: IF l_debug_on THEN
1248: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status for Delivery Name (' ||
1249: l_delivery_name || ') : ' || x_return_status);
1250: END IF;
1251:
1252: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 1290: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status for Delivery Id (' ||

1286: x_num_errors => l_num_errors ,
1287: x_num_warnings => l_num_warnings );
1288:
1289: IF l_debug_on THEN
1290: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status for Delivery Id (' ||
1291: l_delivery_id || ') : ' || l_return_status);
1292: END IF;
1293:
1294: END LOOP; -- } l_Count For Loop.

Line 1305: WSH_DEBUG_SV.Logmsg(l_module_name,

1301:
1302: ELSE
1303: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1304: IF l_debug_on THEN
1305: WSH_DEBUG_SV.Logmsg(l_module_name,
1306: 'Deliveries passed are Invalid for generating ' || upper(p_report_set_name));
1307: END IF;
1308:
1309: END IF;

Line 1316: WSH_DEBUG_SV.Pop(l_module_name);

1312: p_count => x_msg_count,
1313: p_data => x_msg_data );
1314:
1315: IF l_debug_on THEN
1316: WSH_DEBUG_SV.Pop(l_module_name);
1317: END IF;
1318:
1319: -- Exception Handling Block
1320: EXCEPTION

Line 1324: WSH_DEBUG_SV.Logmsg(l_module_name,

1320: EXCEPTION
1321: WHEN FND_API.G_EXC_ERROR THEN
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.Logmsg(l_module_name,
1325: 'Expected error occured. Oracle error message is ' || SQLERRM,
1326: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1327: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');
1328: END IF;

Line 1326: WSH_DEBUG_SV.C_EXCEP_LEVEL);

1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.Logmsg(l_module_name,
1325: 'Expected error occured. Oracle error message is ' || SQLERRM,
1326: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1327: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');
1328: END IF;
1329: FND_MSG_PUB.Count_And_Get(
1330: p_count => x_msg_count,

Line 1327: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');

1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.Logmsg(l_module_name,
1325: 'Expected error occured. Oracle error message is ' || SQLERRM,
1326: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1327: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');
1328: END IF;
1329: FND_MSG_PUB.Count_And_Get(
1330: p_count => x_msg_count,
1331: p_data => x_msg_data );

Line 1336: WSH_DEBUG_SV.Logmsg(l_module_name,

1332:
1333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.Logmsg(l_module_name,
1337: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1338: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1339: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');
1340: END IF;

Line 1338: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.Logmsg(l_module_name,
1337: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1338: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1339: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');
1340: END IF;
1341: FND_MSG_PUB.Count_And_Get(
1342: p_count => x_msg_count,

Line 1339: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');

1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.Logmsg(l_module_name,
1337: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1338: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1339: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');
1340: END IF;
1341: FND_MSG_PUB.Count_And_Get(
1342: p_count => x_msg_count,
1343: p_data => x_msg_data );

Line 1348: WSH_DEBUG_SV.Logmsg(l_module_name, 'WSH_INVALID_ORGANIZATION : ' || x_return_status);

1344:
1345: WHEN WSH_INVALID_ORGANIZATION THEN
1346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1347: IF l_debug_on THEN
1348: WSH_DEBUG_SV.Logmsg(l_module_name, 'WSH_INVALID_ORGANIZATION : ' || x_return_status);
1349: END IF;
1350: FND_MSG_PUB.Count_And_Get(
1351: p_count => x_msg_count,
1352: p_data => x_msg_data );

Line 1358: WSH_DEBUG_SV.Logmsg(l_module_name, 'WSH_INVALID_DELIVERY : ' || x_return_status);

1354: WHEN WSH_INVALID_DELIVERY THEN
1355: FND_MESSAGE.Set_Name('WSH', 'WSH_DOC_INVALID_DELIVERY');
1356: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1357: IF l_debug_on THEN
1358: WSH_DEBUG_SV.Logmsg(l_module_name, 'WSH_INVALID_DELIVERY : ' || x_return_status);
1359: END IF;
1360: WSH_UTIL_CORE.Add_Message(x_return_status);
1361: FND_MSG_PUB.Count_And_Get(
1362: p_count => x_msg_count,

Line 1369: WSH_DEBUG_SV.Logmsg(l_module_name, 'Unexpected Error : ' || x_return_status);

1365: WHEN OTHERS THEN
1366: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERIES_PUB.GENEREATE_DOCUMENTS');
1367: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1368: IF l_debug_on THEN
1369: WSH_DEBUG_SV.Logmsg(l_module_name, 'Unexpected Error : ' || x_return_status);
1370: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error Message : ' || SQLERRM);
1371: END IF;
1372: FND_MSG_PUB.Count_And_Get(
1373: p_count => x_msg_count,

Line 1370: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error Message : ' || SQLERRM);

1366: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERIES_PUB.GENEREATE_DOCUMENTS');
1367: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1368: IF l_debug_on THEN
1369: WSH_DEBUG_SV.Logmsg(l_module_name, 'Unexpected Error : ' || x_return_status);
1370: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error Message : ' || SQLERRM);
1371: END IF;
1372: FND_MSG_PUB.Count_And_Get(
1373: p_count => x_msg_count,
1374: p_data => x_msg_data );