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 143: WSH_DEBUG_SV.pop(l_module_name);

139: p_out_rec.client_code :=RTRIM(p_in_rec.client_code ); -- LSP PROJECT
140:
141:
142: IF l_debug_on THEN
143: WSH_DEBUG_SV.pop(l_module_name);
144: END IF;
145:
146: EXCEPTION
147:

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

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

Line 154: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 189: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

185: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
186: --
187: IF l_debug_on IS NULL
188: THEN
189: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
190: END IF;
191: --
192: IF l_debug_on THEN
193: wsh_debug_sv.push (l_module_name, 'Validate_Delivery');

Line 193: wsh_debug_sv.push (l_module_name, 'Validate_Delivery');

189: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
190: END IF;
191: --
192: IF l_debug_on THEN
193: wsh_debug_sv.push (l_module_name, 'Validate_Delivery');
194: END IF;
195: --
196: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
197:

Line 510: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

506: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
507: --
508: IF l_debug_on IS NULL
509: THEN
510: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
511: END IF;
512: --
513: IF l_debug_on THEN
514: WSH_DEBUG_SV.push(l_module_name);

Line 514: WSH_DEBUG_SV.push(l_module_name);

510: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
511: END IF;
512: --
513: IF l_debug_on THEN
514: WSH_DEBUG_SV.push(l_module_name);
515: END IF;
516: x_return_status := wsh_util_core.g_ret_sts_success;
517: --
518: x_pvt_rec.DELIVERY_ID := p_pub_rec.DELIVERY_ID;

Line 679: WSH_DEBUG_SV.pop(l_module_name);

675: x_pvt_rec.consignee_flag := p_pub_rec.consignee_flag;
676: -- RTV changes
677:
678: IF l_debug_on THEN
679: WSH_DEBUG_SV.pop(l_module_name);
680: END IF;
681: EXCEPTION
682: WHEN OTHERS THEN
683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_PUB.map_pub_to_pvt',l_module_name);

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

683: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_PUB.map_pub_to_pvt',l_module_name);
684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
685: --
686: IF l_debug_on THEN
687: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
689: END IF;
690: --
691: END map_pub_to_pvt;

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

684: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
685: --
686: IF l_debug_on THEN
687: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
688: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
689: END IF;
690: --
691: END map_pub_to_pvt;
692:

Line 751: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

747: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
748: --
749: IF l_debug_on IS NULL
750: THEN
751: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
752: END IF;
753: --
754: IF l_debug_on THEN
755: wsh_debug_sv.push(l_module_name);

Line 755: wsh_debug_sv.push(l_module_name);

751: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
752: END IF;
753: --
754: IF l_debug_on THEN
755: wsh_debug_sv.push(l_module_name);
756: END IF;
757: -- Standard call to check for call compatibility
758: IF NOT FND_API.Compatible_API_Call
759: ( l_api_version_number

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

787: x_pvt_rec => l_rec_attr_tab(1),
788: x_return_status => l_return_status);
789: --
790: IF l_debug_on THEN
791: wsh_debug_sv.log(l_module_name,'Return Status After Calling map_pub_to_pvt',l_return_status);
792: END IF;
793: --
794: wsh_util_core.api_post_call(
795: p_return_status => l_return_status,

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

803: p_delivery_name => l_rec_attr_tab(1).name,
804: x_return_status => l_return_status);
805: --
806: IF l_debug_on THEN
807: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_delivery_name',l_return_status);
808: END IF;
809: --
810: wsh_util_core.api_post_call(
811: p_return_status => l_return_status,

Line 817: wsh_debug_sv.log(l_module_name,'Locking del ',l_rec_attr_tab(1).delivery_id);

813: x_num_warnings => l_num_warnings);
814: --
815: -- Bug 9772252: Added code to lock the delivery when the action is 'Update'
816: IF l_debug_on THEN
817: wsh_debug_sv.log(l_module_name,'Locking del ',l_rec_attr_tab(1).delivery_id);
818: END IF;
819: BEGIN
820: WSH_NEW_DELIVERIES_PVT.Lock_Dlvy_No_Compare(l_rec_attr_tab(1).delivery_id);
821: EXCEPTION

Line 828: WSH_DEBUG_SV.log(l_module_name,'Could not lock delivery: ',p_delivery_info.delivery_id);

824: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
825: FND_MESSAGE.Set_Name('WSH', 'WSH_NO_LOCK');
826: WSH_UTIL_CORE.add_message (WSH_UTIL_CORE.G_RET_STS_ERROR);
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.log(l_module_name,'Could not lock delivery: ',p_delivery_info.delivery_id);
829: END IF;
830: goto count_messasge;
831: END;
832: --Bug 9772252: End of changes

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

854: p_org_code => l_rec_attr_tab(1).ORGANIZATION_CODE ,
855: x_return_status => l_return_status );
856: --
857: IF l_debug_on THEN
858: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_org',l_return_status);
859: END IF;
860: --
861: wsh_util_core.api_post_call(p_return_status => l_return_status,
862: x_num_errors => l_num_errors,

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

867: x_volume_uom_code => l_volume_uom_code,
868: x_return_status => l_return_status );
869: --
870: IF l_debug_on THEN
871: wsh_debug_sv.log(l_module_name,'Return Status After Calling get_default_uoms',l_return_status);
872: END IF;
873: --
874: wsh_util_core.api_post_call(p_return_status => l_return_status,
875: x_num_errors => l_num_errors,

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

899: x_msg_count => x_msg_count,
900: x_msg_data => x_msg_data);
901: --
902: IF l_debug_on THEN
903: wsh_debug_sv.log(l_module_name,'Return Status After Calling create_update_delivery',l_return_status);
904: END IF;
905: --
906: wsh_util_core.api_post_call(
907: p_return_status => l_return_status,

Line 933: WSH_DEBUG_SV.pop(l_module_name);

929: , p_data => x_msg_data
930: );
931: --
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.pop(l_module_name);
934: END IF;
935: --
936: EXCEPTION
937: WHEN FND_API.G_EXC_ERROR THEN

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

942: , p_data => x_msg_data
943: );
944: --
945: IF l_debug_on THEN
946: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
948: END IF;
949: --
950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

943: );
944: --
945: IF l_debug_on THEN
946: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
948: END IF;
949: --
950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

955: , p_data => x_msg_data
956: );
957: --
958: IF l_debug_on THEN
959: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
960: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
961: END IF;
962: --
963: WHEN OTHERS THEN

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

956: );
957: --
958: IF l_debug_on THEN
959: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
960: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
961: END IF;
962: --
963: WHEN OTHERS THEN
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

975: , p_data => x_msg_data
976: );
977: --
978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
981: END IF;
982: --
983: END Create_Update_Delivery;

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

976: );
977: --
978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
980: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
981: END IF;
982: --
983: END Create_Update_Delivery;
984:

Line 1054: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1050: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1051: --
1052: IF l_debug_on IS NULL
1053: THEN
1054: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1055: END IF;
1056: --
1057: IF l_debug_on THEN
1058: wsh_debug_sv.push(l_module_name);

Line 1058: wsh_debug_sv.push(l_module_name);

1054: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1055: END IF;
1056: --
1057: IF l_debug_on THEN
1058: wsh_debug_sv.push(l_module_name);
1059: END IF;
1060: --
1061: -- Standard call to check for call compatibility
1062: IF NOT FND_API.Compatible_API_Call

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

1079: p_delivery_name => p_delivery_name,
1080: x_return_status => l_return_status);
1081: --
1082: IF l_debug_on THEN
1083: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_delivery_name',l_return_status);
1084: END IF;
1085: --
1086: wsh_util_core.api_post_call(
1087: p_return_status => l_return_status,

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

1137: x_msg_count => x_msg_count,
1138: x_msg_data => x_msg_data);
1139: --
1140: IF l_debug_on THEN
1141: wsh_debug_sv.log(l_module_name,'Return Status After Calling Delivery_Action Wrapper',x_return_status);
1142: END IF;
1143: --
1144: wsh_util_core.api_post_call(
1145: p_return_status => x_return_status,

Line 1171: WSH_DEBUG_SV.pop(l_module_name);

1167: , p_data => x_msg_data
1168: );
1169: --
1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.pop(l_module_name);
1172: END IF;
1173: --
1174: EXCEPTION
1175: WHEN FND_API.G_EXC_ERROR THEN

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

1180: , p_data => x_msg_data
1181: );
1182: --
1183: IF l_debug_on THEN
1184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1186: END IF;
1187: --
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1181: );
1182: --
1183: IF l_debug_on THEN
1184: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_EXCEP_LEVEL);
1185: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1186: END IF;
1187: --
1188: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1193: , p_data => x_msg_data
1194: );
1195: --
1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1199: END IF;
1200: --
1201: WHEN OTHERS THEN

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

1194: );
1195: --
1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1199: END IF;
1200: --
1201: WHEN OTHERS THEN
1202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

1213: , p_data => x_msg_data
1214: );
1215: --
1216: IF l_debug_on THEN
1217: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1218: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1219: END IF;
1220: --
1221:

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

1214: );
1215: --
1216: IF l_debug_on THEN
1217: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1218: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1219: END IF;
1220: --
1221:
1222: END Delivery_Action;

Line 1287: l_debug_on := WSH_DEBUG_SV.Is_Debug_Enabled;

1283: -- Enabling Debug Starts
1284: l_debug_on := WSH_DEBUG_INTERFACE.G_DEBUG;
1285:
1286: IF ( l_debug_on IS NULL ) THEN
1287: l_debug_on := WSH_DEBUG_SV.Is_Debug_Enabled;
1288: END IF;
1289:
1290: IF l_debug_on THEN
1291: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');

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

1287: l_debug_on := WSH_DEBUG_SV.Is_Debug_Enabled;
1288: END IF;
1289:
1290: IF l_debug_on THEN
1291: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');
1292: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1293: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1294: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1295: IF p_delivery_name.count > 0 THEN

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

1288: END IF;
1289:
1290: IF l_debug_on THEN
1291: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');
1292: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1293: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1294: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1295: IF p_delivery_name.count > 0 THEN
1296: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');

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

1289:
1290: IF l_debug_on THEN
1291: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');
1292: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1293: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1294: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1295: IF p_delivery_name.count > 0 THEN
1296: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');
1297: FOR i IN 1..p_delivery_name.count LOOP

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

1290: IF l_debug_on THEN
1291: WSH_DEBUG_SV.Push(l_module_name, 'Generate_Documents');
1292: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1293: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1294: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1295: IF p_delivery_name.count > 0 THEN
1296: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');
1297: FOR i IN 1..p_delivery_name.count LOOP
1298: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Delivery_Name(' || i || ') => '

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

1292: WSH_DEBUG_SV.Logmsg(l_module_name, 'Parameters passed to Generate_Documents');
1293: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Report_Set_Name => ' || p_report_set_name);
1294: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1295: IF p_delivery_name.count > 0 THEN
1296: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');
1297: FOR i IN 1..p_delivery_name.count LOOP
1298: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Delivery_Name(' || i || ') => '
1299: || p_delivery_name(i));
1300: END LOOP;

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

1294: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Organization_Code => ' || p_organization_code);
1295: IF p_delivery_name.count > 0 THEN
1296: WSH_DEBUG_SV.Logmsg(l_module_name, 'Delivery Names Passed : ');
1297: FOR i IN 1..p_delivery_name.count LOOP
1298: WSH_DEBUG_SV.Logmsg(l_module_name, 'P_Delivery_Name(' || i || ') => '
1299: || p_delivery_name(i));
1300: END LOOP;
1301: END IF;
1302: END IF;

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

1310: l_organization_id ,
1311: p_organization_code,
1312: x_return_status );
1313: IF l_debug_on THEN
1314: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status from Validate_Org : ' || x_return_status);
1315: END IF;
1316:
1317: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
1318: RAISE WSH_INVALID_ORGANIZATION;

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

1331: l_delivery_id ,
1332: l_delivery_name,
1333: x_return_status);
1334: IF l_debug_on THEN
1335: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status for Delivery Name (' ||
1336: l_delivery_name || ') : ' || x_return_status);
1337: END IF;
1338:
1339: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

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

1373: x_num_errors => l_num_errors ,
1374: x_num_warnings => l_num_warnings );
1375:
1376: IF l_debug_on THEN
1377: WSH_DEBUG_SV.Logmsg(l_module_name, 'Return status for Delivery Id (' ||
1378: l_delivery_id || ') : ' || l_return_status);
1379: END IF;
1380:
1381: END LOOP; -- } l_Count For Loop.

Line 1392: WSH_DEBUG_SV.Logmsg(l_module_name,

1388:
1389: ELSE
1390: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.Logmsg(l_module_name,
1393: 'Deliveries passed are Invalid for generating ' || upper(p_report_set_name));
1394: END IF;
1395:
1396: END IF;

Line 1403: WSH_DEBUG_SV.Pop(l_module_name);

1399: p_count => x_msg_count,
1400: p_data => x_msg_data );
1401:
1402: IF l_debug_on THEN
1403: WSH_DEBUG_SV.Pop(l_module_name);
1404: END IF;
1405:
1406: -- Exception Handling Block
1407: EXCEPTION

Line 1411: WSH_DEBUG_SV.Logmsg(l_module_name,

1407: EXCEPTION
1408: WHEN FND_API.G_EXC_ERROR THEN
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: IF l_debug_on THEN
1411: WSH_DEBUG_SV.Logmsg(l_module_name,
1412: 'Expected error occured. Oracle error message is ' || SQLERRM,
1413: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1414: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');
1415: END IF;

Line 1413: WSH_DEBUG_SV.C_EXCEP_LEVEL);

1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: IF l_debug_on THEN
1411: WSH_DEBUG_SV.Logmsg(l_module_name,
1412: 'Expected error occured. Oracle error message is ' || SQLERRM,
1413: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1414: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');
1415: END IF;
1416: FND_MSG_PUB.Count_And_Get(
1417: p_count => x_msg_count,

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

1410: IF l_debug_on THEN
1411: WSH_DEBUG_SV.Logmsg(l_module_name,
1412: 'Expected error occured. Oracle error message is ' || SQLERRM,
1413: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1414: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_ERROR');
1415: END IF;
1416: FND_MSG_PUB.Count_And_Get(
1417: p_count => x_msg_count,
1418: p_data => x_msg_data );

Line 1423: WSH_DEBUG_SV.Logmsg(l_module_name,

1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.Logmsg(l_module_name,
1424: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1425: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1426: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');
1427: END IF;

Line 1425: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.Logmsg(l_module_name,
1424: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1425: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1426: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');
1427: END IF;
1428: FND_MSG_PUB.Count_And_Get(
1429: p_count => x_msg_count,

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

1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.Logmsg(l_module_name,
1424: 'Unexpected error occured. Oracle error message is ' || SQLERRM,
1425: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1426: WSH_DEBUG_SV.Pop(l_module_name, 'EXCEPTION: FND_API.G_EXC_UNEXPECTED_ERROR');
1427: END IF;
1428: FND_MSG_PUB.Count_And_Get(
1429: p_count => x_msg_count,
1430: p_data => x_msg_data );

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

1431:
1432: WHEN WSH_INVALID_ORGANIZATION THEN
1433: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1434: IF l_debug_on THEN
1435: WSH_DEBUG_SV.Logmsg(l_module_name, 'WSH_INVALID_ORGANIZATION : ' || x_return_status);
1436: END IF;
1437: FND_MSG_PUB.Count_And_Get(
1438: p_count => x_msg_count,
1439: p_data => x_msg_data );

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

1441: WHEN WSH_INVALID_DELIVERY THEN
1442: FND_MESSAGE.Set_Name('WSH', 'WSH_DOC_INVALID_DELIVERY');
1443: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1444: IF l_debug_on THEN
1445: WSH_DEBUG_SV.Logmsg(l_module_name, 'WSH_INVALID_DELIVERY : ' || x_return_status);
1446: END IF;
1447: WSH_UTIL_CORE.Add_Message(x_return_status);
1448: FND_MSG_PUB.Count_And_Get(
1449: p_count => x_msg_count,

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

1452: WHEN OTHERS THEN
1453: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERIES_PUB.GENEREATE_DOCUMENTS');
1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1455: IF l_debug_on THEN
1456: WSH_DEBUG_SV.Logmsg(l_module_name, 'Unexpected Error : ' || x_return_status);
1457: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error Message : ' || SQLERRM);
1458: END IF;
1459: FND_MSG_PUB.Count_And_Get(
1460: p_count => x_msg_count,

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

1453: WSH_UTIL_CORE.Default_Handler('WSH_DELIVERIES_PUB.GENEREATE_DOCUMENTS');
1454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1455: IF l_debug_on THEN
1456: WSH_DEBUG_SV.Logmsg(l_module_name, 'Unexpected Error : ' || x_return_status);
1457: WSH_DEBUG_SV.Logmsg(l_module_name, 'Error Message : ' || SQLERRM);
1458: END IF;
1459: FND_MSG_PUB.Count_And_Get(
1460: p_count => x_msg_count,
1461: p_data => x_msg_data );