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_OTM_RIQ_XML dependencies on FND_API

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

367: IF l_debug_on THEN
368: WSH_DEBUG_SV.push(l_module_name);
369: END IF;
370:
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373:
374:
375:

Line 413: WHEN FND_API.G_EXC_ERROR THEN

409: END IF;
410: --
411: EXCEPTION
412:
413: WHEN FND_API.G_EXC_ERROR THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;
415:
416: IF l_debug_on THEN
417: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 414: x_return_status := FND_API.G_RET_STS_ERROR;

410: --
411: EXCEPTION
412:
413: WHEN FND_API.G_EXC_ERROR THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;
415:
416: IF l_debug_on THEN
417: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

413: WHEN FND_API.G_EXC_ERROR THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;
415:
416: IF l_debug_on THEN
417: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
419: END IF;
420:
421: WHEN others THEN

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

414: x_return_status := FND_API.G_RET_STS_ERROR;
415:
416: IF l_debug_on THEN
417: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
419: END IF;
420:
421: WHEN others THEN
422: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 457: x_return_status := FND_API.G_RET_STS_SUCCESS;

453: IF l_debug_on THEN
454: WSH_DEBUG_SV.push(l_module_name);
455: END IF;
456:
457: x_return_status := FND_API.G_RET_STS_SUCCESS;
458:
459:
460:
461:

Line 541: WHEN FND_API.G_EXC_ERROR THEN

537: END IF;
538: --
539: EXCEPTION
540:
541: WHEN FND_API.G_EXC_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_ERROR;
543:
544: IF l_debug_on THEN
545: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 542: x_return_status := FND_API.G_RET_STS_ERROR;

538: --
539: EXCEPTION
540:
541: WHEN FND_API.G_EXC_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_ERROR;
543:
544: IF l_debug_on THEN
545: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

541: WHEN FND_API.G_EXC_ERROR THEN
542: x_return_status := FND_API.G_RET_STS_ERROR;
543:
544: IF l_debug_on THEN
545: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
547: END IF;
548:
549: WHEN others THEN

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

542: x_return_status := FND_API.G_RET_STS_ERROR;
543:
544: IF l_debug_on THEN
545: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
547: END IF;
548:
549: WHEN others THEN
550: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 582: x_return_status := FND_API.G_RET_STS_SUCCESS;

578: IF l_debug_on THEN
579: WSH_DEBUG_SV.push(l_module_name);
580: END IF;
581:
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583:
584:
585:
586:

Line 651: WHEN FND_API.G_EXC_ERROR THEN

647: END IF;
648: --
649: EXCEPTION
650:
651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653:
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 652: x_return_status := FND_API.G_RET_STS_ERROR;

648: --
649: EXCEPTION
650:
651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653:
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

651: WHEN FND_API.G_EXC_ERROR THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653:
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
657: END IF;
658:
659: WHEN others THEN

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

652: x_return_status := FND_API.G_RET_STS_ERROR;
653:
654: IF l_debug_on THEN
655: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
656: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
657: END IF;
658:
659: WHEN others THEN
660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 694: x_return_status := FND_API.G_RET_STS_SUCCESS;

690: IF l_debug_on THEN
691: WSH_DEBUG_SV.push(l_module_name);
692: END IF;
693:
694: x_return_status := FND_API.G_RET_STS_SUCCESS;
695:
696:
697:
698: i := p_source_line_rates_tab.FIRST;

Line 764: WHEN FND_API.G_EXC_ERROR THEN

760: END IF;
761: --
762: EXCEPTION
763:
764: WHEN FND_API.G_EXC_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_ERROR;
766:
767: IF l_debug_on THEN
768: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 765: x_return_status := FND_API.G_RET_STS_ERROR;

761: --
762: EXCEPTION
763:
764: WHEN FND_API.G_EXC_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_ERROR;
766:
767: IF l_debug_on THEN
768: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
769: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

764: WHEN FND_API.G_EXC_ERROR THEN
765: x_return_status := FND_API.G_RET_STS_ERROR;
766:
767: IF l_debug_on THEN
768: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
769: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
770: END IF;
771:
772: WHEN others THEN

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

765: x_return_status := FND_API.G_RET_STS_ERROR;
766:
767: IF l_debug_on THEN
768: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
769: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
770: END IF;
771:
772: WHEN others THEN
773: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 814: x_return_status := FND_API.G_RET_STS_SUCCESS;

810: IF l_debug_on THEN
811: WSH_DEBUG_SV.push(l_module_name);
812: END IF;
813:
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816:
817:
818: i := p_result_consolidation_id_tab.FIRST;

Line 876: WHEN FND_API.G_EXC_ERROR THEN

872: END IF;
873: --
874: EXCEPTION
875:
876: WHEN FND_API.G_EXC_ERROR THEN
877: x_return_status := FND_API.G_RET_STS_ERROR;
878:
879: IF l_debug_on THEN
880: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 877: x_return_status := FND_API.G_RET_STS_ERROR;

873: --
874: EXCEPTION
875:
876: WHEN FND_API.G_EXC_ERROR THEN
877: x_return_status := FND_API.G_RET_STS_ERROR;
878:
879: IF l_debug_on THEN
880: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
881: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

876: WHEN FND_API.G_EXC_ERROR THEN
877: x_return_status := FND_API.G_RET_STS_ERROR;
878:
879: IF l_debug_on THEN
880: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
881: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
882: END IF;
883:
884: WHEN others THEN

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

877: x_return_status := FND_API.G_RET_STS_ERROR;
878:
879: IF l_debug_on THEN
880: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
881: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
882: END IF;
883:
884: WHEN others THEN
885: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1029: x_return_status := FND_API.G_RET_STS_SUCCESS;

1025: IF l_debug_on THEN
1026: WSH_DEBUG_SV.push(l_module_name);
1027: END IF;
1028:
1029: x_return_status := FND_API.G_RET_STS_SUCCESS;
1030:
1031: l_carrier_id:=NULL;
1032:
1033: IF(p_carrier_id IS NOT NULL)

Line 1043: x_return_status := FND_API.G_RET_STS_ERROR;

1039: END IF;
1040:
1041: IF (l_carrier_id IS NULL)
1042: THEN
1043: x_return_status := FND_API.G_RET_STS_ERROR;
1044: END IF;
1045:
1046: IF l_debug_on THEN
1047: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

Line 1053: WHEN FND_API.G_EXC_ERROR THEN

1049: END IF;
1050: --
1051: EXCEPTION
1052:
1053: WHEN FND_API.G_EXC_ERROR THEN
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055:
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1054: x_return_status := FND_API.G_RET_STS_ERROR;

1050: --
1051: EXCEPTION
1052:
1053: WHEN FND_API.G_EXC_ERROR THEN
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055:
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1058: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

1053: WHEN FND_API.G_EXC_ERROR THEN
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055:
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1058: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1059: END IF;
1060:
1061: WHEN others THEN

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

1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055:
1056: IF l_debug_on THEN
1057: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1058: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1059: END IF;
1060:
1061: WHEN others THEN
1062: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1114: x_return_status := FND_API.G_RET_STS_SUCCESS;

1110: wsh_debug_sv.log(l_module_name, 'lookup_code', p_lookup_code);
1111: wsh_debug_sv.log(l_module_name, 'lookup_type', p_lookup_type);
1112: END IF;
1113:
1114: x_return_status := FND_API.G_RET_STS_SUCCESS;
1115:
1116: l_code:=NULL;
1117:
1118: IF(p_lookup_code IS NOT NULL)

Line 1130: x_return_status := FND_API.G_RET_STS_ERROR;

1126: x_lookup_code:=l_code;
1127:
1128: IF (l_code IS NULL)
1129: THEN
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: END IF;
1132:
1133: IF l_debug_on THEN
1134: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

Line 1140: WHEN FND_API.G_EXC_ERROR THEN

1136: END IF;
1137: --
1138: EXCEPTION
1139:
1140: WHEN FND_API.G_EXC_ERROR THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142:
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1141: x_return_status := FND_API.G_RET_STS_ERROR;

1137: --
1138: EXCEPTION
1139:
1140: WHEN FND_API.G_EXC_ERROR THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142:
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

1140: WHEN FND_API.G_EXC_ERROR THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142:
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1146: END IF;
1147:
1148: WHEN others THEN

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

1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142:
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1145: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1146: END IF;
1147:
1148: WHEN others THEN
1149: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1205: x_return_status := FND_API.G_RET_STS_SUCCESS;

1201: IF l_debug_on THEN
1202: WSH_DEBUG_SV.push(l_module_name);
1203: END IF;
1204:
1205: x_return_status := FND_API.G_RET_STS_SUCCESS;
1206:
1207:
1208:
1209: l_uom:=NULL;

Line 1246: WHEN FND_API.G_EXC_ERROR THEN

1242: END IF;
1243: --
1244: EXCEPTION
1245:
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248:
1249: IF l_debug_on THEN
1250: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1247: x_return_status := FND_API.G_RET_STS_ERROR;

1243: --
1244: EXCEPTION
1245:
1246: WHEN FND_API.G_EXC_ERROR THEN
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248:
1249: IF l_debug_on THEN
1250: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

1246: WHEN FND_API.G_EXC_ERROR THEN
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248:
1249: IF l_debug_on THEN
1250: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1252: END IF;
1253:
1254: WHEN others THEN

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

1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248:
1249: IF l_debug_on THEN
1250: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1252: END IF;
1253:
1254: WHEN others THEN
1255: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1300: x_return_status := FND_API.G_RET_STS_SUCCESS;

1296: IF l_debug_on THEN
1297: WSH_DEBUG_SV.push(l_module_name);
1298: END IF;
1299:
1300: x_return_status := FND_API.G_RET_STS_SUCCESS;
1301:
1302:
1303:
1304: l_uom:=NULL;

Line 1336: WHEN FND_API.G_EXC_ERROR THEN

1332: END IF;
1333: --
1334: EXCEPTION
1335:
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338:
1339: IF l_debug_on THEN
1340: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

1333: --
1334: EXCEPTION
1335:
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338:
1339: IF l_debug_on THEN
1340: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1341: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

1336: WHEN FND_API.G_EXC_ERROR THEN
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338:
1339: IF l_debug_on THEN
1340: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1341: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1342: END IF;
1343:
1344: WHEN others THEN

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

1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338:
1339: IF l_debug_on THEN
1340: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1341: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1342: END IF;
1343:
1344: WHEN others THEN
1345: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1388: x_return_status := FND_API.G_RET_STS_SUCCESS;

1384: IF l_debug_on THEN
1385: WSH_DEBUG_SV.push(l_module_name);
1386: END IF;
1387:
1388: x_return_status := FND_API.G_RET_STS_SUCCESS;
1389:
1390: IF((g_carrier_freight_codes.EXISTS(p_carrier_id)) AND (g_carrier_generic_flags.EXISTS(p_carrier_id)))
1391: THEN
1392: x_generic:=g_carrier_generic_flags(p_carrier_id);

Line 1419: WHEN FND_API.G_EXC_ERROR THEN

1415: END IF;
1416: --
1417: EXCEPTION
1418:
1419: WHEN FND_API.G_EXC_ERROR THEN
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421:
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1420: x_return_status := FND_API.G_RET_STS_ERROR;

1416: --
1417: EXCEPTION
1418:
1419: WHEN FND_API.G_EXC_ERROR THEN
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421:
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1424: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

1419: WHEN FND_API.G_EXC_ERROR THEN
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421:
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1424: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1425: END IF;
1426:
1427: WHEN others THEN

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

1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421:
1422: IF l_debug_on THEN
1423: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1424: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1425: END IF;
1426:
1427: WHEN others THEN
1428: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1478: x_return_status := FND_API.G_RET_STS_SUCCESS;

1474: IF l_debug_on THEN
1475: WSH_DEBUG_SV.push(l_module_name);
1476: END IF;
1477: --
1478: x_return_status := FND_API.G_RET_STS_SUCCESS;
1479:
1480: l_count:=x_source_header_rates_tab.COUNT;
1481:
1482: IF (l_count > 0)

Line 1532: WHEN FND_API.G_EXC_ERROR THEN

1528: END IF;
1529: --
1530: EXCEPTION
1531:
1532: WHEN FND_API.G_EXC_ERROR THEN
1533: x_return_status := FND_API.G_RET_STS_ERROR;
1534:
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1533: x_return_status := FND_API.G_RET_STS_ERROR;

1529: --
1530: EXCEPTION
1531:
1532: WHEN FND_API.G_EXC_ERROR THEN
1533: x_return_status := FND_API.G_RET_STS_ERROR;
1534:
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1537: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

1532: WHEN FND_API.G_EXC_ERROR THEN
1533: x_return_status := FND_API.G_RET_STS_ERROR;
1534:
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1537: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1538: END IF;
1539:
1540: WHEN others THEN

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

1533: x_return_status := FND_API.G_RET_STS_ERROR;
1534:
1535: IF l_debug_on THEN
1536: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1537: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1538: END IF;
1539:
1540: WHEN others THEN
1541: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1578: x_return_status := FND_API.G_RET_STS_SUCCESS;

1574: IF l_debug_on THEN
1575: WSH_DEBUG_SV.push(l_module_name);
1576: END IF;
1577:
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: l_transit_time:=NULL;
1581: l_transit_time_uom:=NULL;
1582:

Line 1599: raise FND_API.G_EXC_ERROR;

1595: THEN
1596:
1597: WSH_DEBUG_SV.log(l_module_name,'Get_OTM_To_EBS_UOM Failed');
1598: END IF;
1599: raise FND_API.G_EXC_ERROR;
1600: END IF;
1601:
1602:
1603: IF (l_transit_time_uom IS NOT NULL)

Line 1633: WHEN FND_API.G_EXC_ERROR THEN

1629: END IF;
1630: --
1631: EXCEPTION
1632:
1633: WHEN FND_API.G_EXC_ERROR THEN
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635:
1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1634: x_return_status := FND_API.G_RET_STS_ERROR;

1630: --
1631: EXCEPTION
1632:
1633: WHEN FND_API.G_EXC_ERROR THEN
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635:
1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

1633: WHEN FND_API.G_EXC_ERROR THEN
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635:
1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1639: END IF;
1640:
1641: WHEN others THEN

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

1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635:
1636: IF l_debug_on THEN
1637: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1639: END IF;
1640:
1641: WHEN others THEN
1642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1692: x_return_status := FND_API.G_RET_STS_SUCCESS;

1688: IF l_debug_on THEN
1689: WSH_DEBUG_SV.push(l_module_name);
1690: END IF;
1691:
1692: x_return_status := FND_API.G_RET_STS_SUCCESS;
1693:
1694: l_ship_method_code:=NULL;
1695: IF(p_carrier_id IS NOT NULL AND p_mode IS NOT NULL AND p_service_level IS NOT NULL)
1696: THEN

Line 1705: x_return_status := FND_API.G_RET_STS_ERROR;

1701: END IF;
1702: IF(l_ship_method_code IS NULL)
1703: THEN
1704: x_ship_method_code:=NULL;
1705: x_return_status := FND_API.G_RET_STS_ERROR;
1706: ELSE
1707: x_ship_method_code:=l_ship_method_code;
1708: END IF;
1709:

Line 1719: WHEN FND_API.G_EXC_ERROR THEN

1715: END IF;
1716: --
1717: EXCEPTION
1718:
1719: WHEN FND_API.G_EXC_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721:
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 1720: x_return_status := FND_API.G_RET_STS_ERROR;

1716: --
1717: EXCEPTION
1718:
1719: WHEN FND_API.G_EXC_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721:
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

1719: WHEN FND_API.G_EXC_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721:
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1725: END IF;
1726:
1727: WHEN others THEN

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

1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721:
1722: IF l_debug_on THEN
1723: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1724: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1725: END IF;
1726:
1727: WHEN others THEN
1728: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1818: x_return_status := FND_API.G_RET_STS_SUCCESS;

1814: WSH_DEBUG_SV.log(l_module_name, 'p_org_id', p_org_id);
1815: WSH_DEBUG_SV.log(l_module_name, 'p_customer_id', p_customer_id);
1816: END IF;
1817:
1818: x_return_status := FND_API.G_RET_STS_SUCCESS;
1819:
1820:
1821: IF((p_location_id IS NOT NULL) AND ((p_org_id IS NOT NULL) OR (p_customer_id IS NOT NULL)))
1822: THEN

Line 1896: x_return_status := FND_API.G_RET_STS_ERROR;

1892:
1893:
1894:
1895: ELSE
1896: x_return_status := FND_API.G_RET_STS_ERROR;
1897: END IF;
1898: ELSE
1899: x_return_status := FND_API.G_RET_STS_ERROR;
1900: END IF;

Line 1899: x_return_status := FND_API.G_RET_STS_ERROR;

1895: ELSE
1896: x_return_status := FND_API.G_RET_STS_ERROR;
1897: END IF;
1898: ELSE
1899: x_return_status := FND_API.G_RET_STS_ERROR;
1900: END IF;
1901:
1902:
1903: IF l_debug_on THEN

Line 1968: x_return_status := FND_API.G_RET_STS_SUCCESS;

1964: IF l_debug_on THEN
1965: WSH_DEBUG_SV.push(l_module_name);
1966: END IF;
1967: --
1968: x_return_status := FND_API.G_RET_STS_SUCCESS;
1969:
1970: l_line_rec:= NEW WSH_OTM_RIQ_LINE_REC();
1971: x_source_line_tab.DELETE;
1972:

Line 2004: raise FND_API.G_EXC_ERROR;

2000: IF l_debug_on
2001: THEN
2002: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
2003: END IF;
2004: raise FND_API.G_EXC_ERROR;
2005: END IF;
2006:
2007:
2008: --UOM Domain is public do not specify

Line 2029: raise FND_API.G_EXC_ERROR;

2025: IF l_debug_on
2026: THEN
2027: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Volume Failed');
2028: END IF;
2029: raise FND_API.G_EXC_ERROR;
2030: END IF;
2031:
2032:
2033: --UOM Domain is public do not specify

Line 2078: raise FND_API.G_EXC_ERROR;

2074: IF l_debug_on
2075: THEN
2076: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Dim Failed');
2077: END IF;
2078: raise FND_API.G_EXC_ERROR;
2079: END IF;
2080: IF l_debug_on
2081: THEN
2082: WSH_DEBUG_SV.log(l_module_name,'Length',l_length);

Line 2133: RAISE FND_API.G_EXC_ERROR;

2129: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2130: IF l_debug_on THEN
2131: WSH_DEBUG_SV.log(l_module_name,'WSH_CUSTOM_PUB.Override_RIQ_XML_Attribute Failed');
2132: END IF;
2133: RAISE FND_API.G_EXC_ERROR;
2134: END IF;
2135: IF l_debug_on THEN
2136: WSH_DEBUG_SV.logmsg(l_module_name,' x_source_line_tab(j).Weight : '
2137: ||x_source_line_tab(j).Weight

Line 2180: RAISE FND_API.G_EXC_ERROR;

2176: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2177: IF l_debug_on THEN
2178: WSH_DEBUG_SV.log(l_module_name,'WSH_CUSTOM_PUB.Override_RIQ_XML_Attribute Failed');
2179: END IF;
2180: RAISE FND_API.G_EXC_ERROR;
2181: END IF;
2182: IF l_debug_on THEN
2183: WSH_DEBUG_SV.logmsg(l_module_name, ' x_source_header_xml_rec.TotalWeight : '
2184: ||x_source_header_xml_rec.TotalWeight

Line 2195: WHEN FND_API.G_EXC_ERROR THEN

2191: END IF;
2192: --
2193: EXCEPTION
2194:
2195: WHEN FND_API.G_EXC_ERROR THEN
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197:
2198: IF l_debug_on THEN
2199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2196: x_return_status := FND_API.G_RET_STS_ERROR;

2192: --
2193: EXCEPTION
2194:
2195: WHEN FND_API.G_EXC_ERROR THEN
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197:
2198: IF l_debug_on THEN
2199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

2195: WHEN FND_API.G_EXC_ERROR THEN
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197:
2198: IF l_debug_on THEN
2199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2201: END IF;
2202:
2203: WHEN others THEN

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

2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197:
2198: IF l_debug_on THEN
2199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2201: END IF;
2202:
2203: WHEN others THEN
2204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2261: x_return_status := FND_API.G_RET_STS_SUCCESS;

2257: IF l_debug_on THEN
2258: WSH_DEBUG_SV.push(l_module_name);
2259: END IF;
2260: --
2261: x_return_status := FND_API.G_RET_STS_SUCCESS;
2262:
2263: x_source_header_tab.DELETE;
2264: x_source_header_tab.EXTEND(p_source_header_tab.COUNT);
2265: l_header_rec:=NEW WSH_OTM_RIQ_HEADER_REC();

Line 2315: RAISE FND_API.G_EXC_ERROR;

2311: WSH_DEBUG_SV.log(l_module_name,'user',g_user_name);
2312: WSH_DEBUG_SV.log(l_module_name,'pwd',g_password);
2313: END IF;
2314:
2315: RAISE FND_API.G_EXC_ERROR;
2316:
2317: END IF;
2318:
2319: l_header_rec.UserName:=g_user_name;

Line 2371: raise FND_API.G_EXC_ERROR;

2367: THEN
2368:
2369: WSH_DEBUG_SV.log(l_module_name,'Source Location Get Info Failed');
2370: END IF;
2371: raise FND_API.G_EXC_ERROR;
2372: END IF;
2373:
2374:
2375:

Line 2419: raise FND_API.G_EXC_ERROR;

2415:
2416: WSH_DEBUG_SV.log(l_module_name,'Dest Location Get Info Failed');
2417: END IF;
2418:
2419: raise FND_API.G_EXC_ERROR;
2420: END IF;
2421:
2422: --Dates
2423: IF (p_source_header_tab(i).ship_date IS NOT NULL)

Line 2469: raise FND_API.G_EXC_ERROR;

2465: IF l_debug_on
2466: THEN
2467: WSH_DEBUG_SV.log(l_module_name,'Dest Location Get Info Failed');
2468: END IF;
2469: raise FND_API.G_EXC_ERROR;
2470: END IF;
2471:
2472:
2473: IF (l_generic_carrier = 'Y')

Line 2537: raise FND_API.G_EXC_ERROR;

2533: IF l_debug_on
2534: THEN
2535: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
2536: END IF;
2537: raise FND_API.G_EXC_ERROR;
2538: END IF;
2539:
2540:
2541: --UOM Domain is public do not specify

Line 2562: raise FND_API.G_EXC_ERROR;

2558: IF l_debug_on
2559: THEN
2560: WSH_DEBUG_SV.log(l_module_name,'Get_EBS_To_OTM_UOM Volume Failed');
2561: END IF;
2562: raise FND_API.G_EXC_ERROR;
2563: END IF;
2564:
2565:
2566: --UOM Domain is public do not specify

Line 2582: WHEN FND_API.G_EXC_ERROR THEN

2578: END IF;
2579: --
2580: EXCEPTION
2581:
2582: WHEN FND_API.G_EXC_ERROR THEN
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584:
2585: IF l_debug_on THEN
2586: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2583: x_return_status := FND_API.G_RET_STS_ERROR;

2579: --
2580: EXCEPTION
2581:
2582: WHEN FND_API.G_EXC_ERROR THEN
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584:
2585: IF l_debug_on THEN
2586: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2587: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

2582: WHEN FND_API.G_EXC_ERROR THEN
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584:
2585: IF l_debug_on THEN
2586: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2587: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2588: END IF;
2589:
2590: WHEN others THEN

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

2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584:
2585: IF l_debug_on THEN
2586: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2587: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2588: END IF;
2589:
2590: WHEN others THEN
2591: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3167: x_return_status := FND_API.G_RET_STS_SUCCESS;

3163: END IF;
3164: IF l_debug_on THEN
3165: WSH_DEBUG_SV.push(l_module_name);
3166: END IF;
3167: x_return_status := FND_API.G_RET_STS_SUCCESS;
3168:
3169: IF (p_action IS NOT NULL)
3170: THEN
3171: IF (p_action = 'GET_RATE_CHOICE')

Line 3207: WHEN FND_API.G_EXC_ERROR THEN

3203: END IF;
3204: --
3205: EXCEPTION
3206:
3207: WHEN FND_API.G_EXC_ERROR THEN
3208: x_return_status := FND_API.G_RET_STS_ERROR;
3209:
3210: IF l_debug_on THEN
3211: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3208: x_return_status := FND_API.G_RET_STS_ERROR;

3204: --
3205: EXCEPTION
3206:
3207: WHEN FND_API.G_EXC_ERROR THEN
3208: x_return_status := FND_API.G_RET_STS_ERROR;
3209:
3210: IF l_debug_on THEN
3211: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3212: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

3207: WHEN FND_API.G_EXC_ERROR THEN
3208: x_return_status := FND_API.G_RET_STS_ERROR;
3209:
3210: IF l_debug_on THEN
3211: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3212: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3213: END IF;
3214:
3215: WHEN others THEN

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

3208: x_return_status := FND_API.G_RET_STS_ERROR;
3209:
3210: IF l_debug_on THEN
3211: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3212: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3213: END IF;
3214:
3215: WHEN others THEN
3216: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3257: x_return_status := FND_API.G_RET_STS_SUCCESS;

3253: IF l_debug_on THEN
3254: WSH_DEBUG_SV.push(l_module_name);
3255: END IF;
3256: --
3257: x_return_status := FND_API.G_RET_STS_SUCCESS;
3258:
3259: OPEN c_extract(p_xml,p_xpath);
3260: FETCH c_extract INTO x_xml_seq;
3261: CLOSE c_extract;

Line 3273: WHEN FND_API.G_EXC_ERROR THEN

3269: END IF;
3270: --
3271: EXCEPTION
3272:
3273: WHEN FND_API.G_EXC_ERROR THEN
3274: x_return_status := FND_API.G_RET_STS_ERROR;
3275:
3276: IF l_debug_on THEN
3277: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3274: x_return_status := FND_API.G_RET_STS_ERROR;

3270: --
3271: EXCEPTION
3272:
3273: WHEN FND_API.G_EXC_ERROR THEN
3274: x_return_status := FND_API.G_RET_STS_ERROR;
3275:
3276: IF l_debug_on THEN
3277: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

3273: WHEN FND_API.G_EXC_ERROR THEN
3274: x_return_status := FND_API.G_RET_STS_ERROR;
3275:
3276: IF l_debug_on THEN
3277: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3279: END IF;
3280:
3281: WHEN others THEN

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

3274: x_return_status := FND_API.G_RET_STS_ERROR;
3275:
3276: IF l_debug_on THEN
3277: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3278: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3279: END IF;
3280:
3281: WHEN others THEN
3282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3326: x_return_status := FND_API.G_RET_STS_SUCCESS;

3322: IF l_debug_on THEN
3323: WSH_DEBUG_SV.push(l_module_name);
3324: END IF;
3325: --
3326: x_return_status := FND_API.G_RET_STS_SUCCESS;
3327:
3328: IF l_debug_on
3329: THEN
3330: WSH_DEBUG_SV.log(l_module_name,'prefix:',p_xpath_prefix);

Line 3370: x_return_status:=FND_API.G_RET_STS_ERROR;

3366:
3367: IF ((l_status_code IS NULL) OR (l_status_code <> 'SUCCESS'))
3368: THEN
3369:
3370: x_return_status:=FND_API.G_RET_STS_ERROR;
3371:
3372: IF l_debug_on
3373: THEN
3374: --Log status code

Line 3414: raise FND_API.G_EXC_ERROR;

3410:
3411: WSH_DEBUG_SV.log(l_module_name,'Fetch_XML_Match Failed');
3412: END IF;
3413:
3414: raise FND_API.G_EXC_ERROR;
3415: END IF;
3416:
3417: i:=l_xml_seq.FIRST;
3418: WHILE (i IS NOT NULL)

Line 3440: WHEN FND_API.G_EXC_ERROR THEN

3436: END IF;
3437: --
3438: EXCEPTION
3439:
3440: WHEN FND_API.G_EXC_ERROR THEN
3441: x_return_status := FND_API.G_RET_STS_ERROR;
3442:
3443: IF l_debug_on THEN
3444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3441: x_return_status := FND_API.G_RET_STS_ERROR;

3437: --
3438: EXCEPTION
3439:
3440: WHEN FND_API.G_EXC_ERROR THEN
3441: x_return_status := FND_API.G_RET_STS_ERROR;
3442:
3443: IF l_debug_on THEN
3444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

3440: WHEN FND_API.G_EXC_ERROR THEN
3441: x_return_status := FND_API.G_RET_STS_ERROR;
3442:
3443: IF l_debug_on THEN
3444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3446: END IF;
3447:
3448: WHEN others THEN

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

3441: x_return_status := FND_API.G_RET_STS_ERROR;
3442:
3443: IF l_debug_on THEN
3444: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3445: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3446: END IF;
3447:
3448: WHEN others THEN
3449: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3506: x_return_status := FND_API.G_RET_STS_SUCCESS;

3502: END IF;
3503: --
3504:
3505: x_cost := NULL;
3506: x_return_status := FND_API.G_RET_STS_SUCCESS;
3507:
3508: l_cost_summary:=NULL;
3509: l_currency:=NULL;
3510:

Line 3570: raise FND_API.G_EXC_ERROR;

3566: x_conversion_type => l_currency_conversion_type,
3567: x_amount => l_rate
3568: );
3569: else
3570: raise FND_API.G_EXC_ERROR;
3571: end if;
3572:
3573: EXCEPTION
3574: WHEN OTHERS THEN

Line 3578: raise FND_API.G_EXC_ERROR;

3574: WHEN OTHERS THEN
3575: IF l_debug_on THEN
3576: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected exception occurred while getting the conversion type or converting the amount');
3577: END IF;
3578: raise FND_API.G_EXC_ERROR;
3579: END;
3580:
3581: IF (l_negative='Y' AND l_rate IS NOT NULL AND l_rate > 0)
3582: THEN

Line 3589: raise FND_API.G_EXC_ERROR;

3585:
3586: -- l_negative <> 'Y' is added not to error out discount amount
3587: IF((l_rate IS NULL) OR (l_rate < 0 AND l_negative <> 'Y'))
3588: THEN
3589: raise FND_API.G_EXC_ERROR;
3590: END IF;
3591:
3592: END IF;
3593:

Line 3607: WHEN FND_API.G_EXC_ERROR THEN

3603: END IF;
3604: --
3605: EXCEPTION
3606:
3607: WHEN FND_API.G_EXC_ERROR THEN
3608: x_return_status := FND_API.G_RET_STS_ERROR;
3609:
3610: -- l_return_status is set from wsh_util_core.get_currency_conversion_type
3611: -- if it's success, gl_currency_api.convert_amount failed

Line 3608: x_return_status := FND_API.G_RET_STS_ERROR;

3604: --
3605: EXCEPTION
3606:
3607: WHEN FND_API.G_EXC_ERROR THEN
3608: x_return_status := FND_API.G_RET_STS_ERROR;
3609:
3610: -- l_return_status is set from wsh_util_core.get_currency_conversion_type
3611: -- if it's success, gl_currency_api.convert_amount failed
3612: -- otherwise, error message is already set in the api, so no need to set it

Line 3648: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);

3644: wsh_util_core.add_message(x_return_status);
3645: end if;
3646:
3647: IF l_debug_on THEN
3648: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3649: WSH_DEBUG_SV.log(l_module_name,'l_currency',l_currency);
3650: WSH_DEBUG_SV.log(l_module_name,'p_currency',p_currency);
3651: WSH_DEBUG_SV.log(l_module_name,'l_cost_summary',l_cost_summary);
3652: WSH_DEBUG_SV.log(l_module_name,'l_rate',l_rate);

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

3649: WSH_DEBUG_SV.log(l_module_name,'l_currency',l_currency);
3650: WSH_DEBUG_SV.log(l_module_name,'p_currency',p_currency);
3651: WSH_DEBUG_SV.log(l_module_name,'l_cost_summary',l_cost_summary);
3652: WSH_DEBUG_SV.log(l_module_name,'l_rate',l_rate);
3653: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3654: END IF;
3655:
3656: WHEN others THEN
3657: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3707: x_return_status := FND_API.G_RET_STS_SUCCESS;

3703: IF l_debug_on THEN
3704: WSH_DEBUG_SV.push(l_module_name);
3705: END IF;
3706: --
3707: x_return_status := FND_API.G_RET_STS_SUCCESS;
3708:
3709:
3710: Extract_Single_Cost(
3711: p_xml=>p_xml,

Line 3725: raise FND_API.G_EXC_ERROR;

3721:
3722: WSH_DEBUG_SV.log(l_module_name,'Extract_Single_Cost Failed');
3723: END IF;
3724:
3725: raise FND_API.G_EXC_ERROR;
3726: END IF;
3727:
3728: IF l_debug_on THEN
3729: WSH_DEBUG_SV.log(l_module_name,'After Extract_Single_Cost, Summary Rate:'||l_summary_rate);

Line 3739: raise FND_API.G_EXC_ERROR;

3735: THEN
3736:
3737: WSH_DEBUG_SV.log(l_module_name,'x_summary_rate null');
3738: END IF;
3739: raise FND_API.G_EXC_ERROR;
3740: END IF;
3741:
3742:
3743:

Line 3758: raise FND_API.G_EXC_ERROR;

3754:
3755: WSH_DEBUG_SV.log(l_module_name,'Fetch_XML_Match Failed');
3756: END IF;
3757:
3758: raise FND_API.G_EXC_ERROR;
3759: END IF;
3760:
3761: --Initialize base and charge to 0
3762: l_base_rate:=0;

Line 3805: raise FND_API.G_EXC_ERROR;

3801:
3802: WSH_DEBUG_SV.log(l_module_name,'Extract_Single_Cost Failed');
3803: END IF;
3804:
3805: raise FND_API.G_EXC_ERROR;
3806: END IF;
3807:
3808: IF l_debug_on
3809: THEN

Line 3855: raise FND_API.G_EXC_ERROR;

3851: WSH_DEBUG_SV.log(l_module_name,'l_base_rate',l_base_rate);
3852: WSH_DEBUG_SV.log(l_module_name,'l_charge',l_charge);
3853: END IF;
3854:
3855: raise FND_API.G_EXC_ERROR;
3856:
3857:
3858: END IF;
3859:

Line 3880: WHEN FND_API.G_EXC_ERROR THEN

3876: END IF;
3877: --
3878: EXCEPTION
3879:
3880: WHEN FND_API.G_EXC_ERROR THEN
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882:
3883: IF l_debug_on THEN
3884: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 3881: x_return_status := FND_API.G_RET_STS_ERROR;

3877: --
3878: EXCEPTION
3879:
3880: WHEN FND_API.G_EXC_ERROR THEN
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882:
3883: IF l_debug_on THEN
3884: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3885: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

3880: WHEN FND_API.G_EXC_ERROR THEN
3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882:
3883: IF l_debug_on THEN
3884: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3885: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3886: END IF;
3887:
3888: WHEN others THEN

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

3881: x_return_status := FND_API.G_RET_STS_ERROR;
3882:
3883: IF l_debug_on THEN
3884: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3885: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3886: END IF;
3887:
3888: WHEN others THEN
3889: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3945: x_return_status := FND_API.G_RET_STS_SUCCESS;

3941: IF l_debug_on THEN
3942: WSH_DEBUG_SV.push(l_module_name);
3943: END IF;
3944: --
3945: x_return_status := FND_API.G_RET_STS_SUCCESS;
3946:
3947: IF l_debug_on
3948: THEN
3949:

Line 4078: WHEN FND_API.G_EXC_ERROR THEN

4074: END IF;
4075: --
4076: EXCEPTION
4077:
4078: WHEN FND_API.G_EXC_ERROR THEN
4079: x_return_status := FND_API.G_RET_STS_ERROR;
4080:
4081: IF l_debug_on THEN
4082: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4079: x_return_status := FND_API.G_RET_STS_ERROR;

4075: --
4076: EXCEPTION
4077:
4078: WHEN FND_API.G_EXC_ERROR THEN
4079: x_return_status := FND_API.G_RET_STS_ERROR;
4080:
4081: IF l_debug_on THEN
4082: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4083: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

4078: WHEN FND_API.G_EXC_ERROR THEN
4079: x_return_status := FND_API.G_RET_STS_ERROR;
4080:
4081: IF l_debug_on THEN
4082: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4083: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4084: END IF;
4085:
4086: WHEN others THEN

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

4079: x_return_status := FND_API.G_RET_STS_ERROR;
4080:
4081: IF l_debug_on THEN
4082: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4083: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4084: END IF;
4085:
4086: WHEN others THEN
4087: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4138: x_return_status := FND_API.G_RET_STS_SUCCESS;

4134: IF l_debug_on THEN
4135: WSH_DEBUG_SV.push(l_module_name);
4136: END IF;
4137: --
4138: x_return_status := FND_API.G_RET_STS_SUCCESS;
4139:
4140:
4141: i:=x_result_consolidation_id_tab.LAST;
4142: IF (i IS NULL)

Line 4256: WHEN FND_API.G_EXC_ERROR THEN

4252: END IF;
4253: --
4254: EXCEPTION
4255:
4256: WHEN FND_API.G_EXC_ERROR THEN
4257: x_return_status := FND_API.G_RET_STS_ERROR;
4258:
4259: IF l_debug_on THEN
4260: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4257: x_return_status := FND_API.G_RET_STS_ERROR;

4253: --
4254: EXCEPTION
4255:
4256: WHEN FND_API.G_EXC_ERROR THEN
4257: x_return_status := FND_API.G_RET_STS_ERROR;
4258:
4259: IF l_debug_on THEN
4260: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

4256: WHEN FND_API.G_EXC_ERROR THEN
4257: x_return_status := FND_API.G_RET_STS_ERROR;
4258:
4259: IF l_debug_on THEN
4260: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4262: END IF;
4263:
4264: WHEN others THEN

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

4257: x_return_status := FND_API.G_RET_STS_ERROR;
4258:
4259: IF l_debug_on THEN
4260: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4262: END IF;
4263:
4264: WHEN others THEN
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4314: x_return_status := FND_API.G_RET_STS_SUCCESS;

4310: IF l_debug_on THEN
4311: WSH_DEBUG_SV.push(l_module_name);
4312: END IF;
4313: --
4314: x_return_status := FND_API.G_RET_STS_SUCCESS;
4315:
4316:
4317:
4318:

Line 4512: WHEN FND_API.G_EXC_ERROR THEN

4508: END IF;
4509: --
4510: EXCEPTION
4511:
4512: WHEN FND_API.G_EXC_ERROR THEN
4513: x_return_status := FND_API.G_RET_STS_ERROR;
4514:
4515: IF l_debug_on THEN
4516: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4513: x_return_status := FND_API.G_RET_STS_ERROR;

4509: --
4510: EXCEPTION
4511:
4512: WHEN FND_API.G_EXC_ERROR THEN
4513: x_return_status := FND_API.G_RET_STS_ERROR;
4514:
4515: IF l_debug_on THEN
4516: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

4512: WHEN FND_API.G_EXC_ERROR THEN
4513: x_return_status := FND_API.G_RET_STS_ERROR;
4514:
4515: IF l_debug_on THEN
4516: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4518: END IF;
4519:
4520: WHEN others THEN

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

4513: x_return_status := FND_API.G_RET_STS_ERROR;
4514:
4515: IF l_debug_on THEN
4516: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4517: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4518: END IF;
4519:
4520: WHEN others THEN
4521: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4572: x_return_status := FND_API.G_RET_STS_SUCCESS;

4568: IF l_debug_on THEN
4569: WSH_DEBUG_SV.push(l_module_name);
4570: END IF;
4571: --
4572: x_return_status := FND_API.G_RET_STS_SUCCESS;
4573:
4574: --i is the source header rates tab index
4575: i:=x_source_header_rates_tab.LAST;
4576: IF (i IS NULL)

Line 4617: raise FND_API.G_EXC_ERROR;

4613: IF l_debug_on
4614: THEN
4615: WSH_DEBUG_SV.log(l_module_name,'Dest Location Get Info Failed');
4616: END IF;
4617: raise FND_API.G_EXC_ERROR;
4618: END IF;
4619: x_source_header_rates_tab(i).carrier_freight_code := l_carrier_freight_code;
4620: END IF;
4621:

Line 4654: raise FND_API.G_EXC_ERROR;

4650:
4651: WSH_DEBUG_SV.log(l_module_name,'Allocate_rates Failed');
4652: END IF;
4653:
4654: raise FND_API.G_EXC_ERROR;
4655: END IF;
4656:
4657:
4658: --

Line 4666: WHEN FND_API.G_EXC_ERROR THEN

4662: END IF;
4663: --
4664: EXCEPTION
4665:
4666: WHEN FND_API.G_EXC_ERROR THEN
4667: x_return_status := FND_API.G_RET_STS_ERROR;
4668:
4669: IF l_debug_on THEN
4670: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4667: x_return_status := FND_API.G_RET_STS_ERROR;

4663: --
4664: EXCEPTION
4665:
4666: WHEN FND_API.G_EXC_ERROR THEN
4667: x_return_status := FND_API.G_RET_STS_ERROR;
4668:
4669: IF l_debug_on THEN
4670: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

4666: WHEN FND_API.G_EXC_ERROR THEN
4667: x_return_status := FND_API.G_RET_STS_ERROR;
4668:
4669: IF l_debug_on THEN
4670: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4672: END IF;
4673:
4674: WHEN others THEN

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

4667: x_return_status := FND_API.G_RET_STS_ERROR;
4668:
4669: IF l_debug_on THEN
4670: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4671: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4672: END IF;
4673:
4674: WHEN others THEN
4675: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4729: x_return_status := FND_API.G_RET_STS_SUCCESS;

4725: IF l_debug_on THEN
4726: WSH_DEBUG_SV.push(l_module_name);
4727: END IF;
4728: --
4729: x_return_status := FND_API.G_RET_STS_SUCCESS;
4730:
4731:
4732: --i is the source header rates tab index
4733: i:=x_source_header_rates_tab.LAST;

Line 4784: raise FND_API.G_EXC_ERROR;

4780: IF l_debug_on
4781: THEN
4782: WSH_DEBUG_SV.log(l_module_name,'Get_Carrier_Info Failed');
4783: END IF;
4784: raise FND_API.G_EXC_ERROR;
4785: END IF;
4786: x_source_header_rates_tab(i).carrier_freight_code := l_carrier_freight_code;
4787: END IF;
4788:

Line 4825: raise FND_API.G_EXC_ERROR;

4821:
4822: WSH_DEBUG_SV.log(l_module_name,'Allocate_rates Failed');
4823: END IF;
4824:
4825: raise FND_API.G_EXC_ERROR;
4826: END IF;
4827: ELSE
4828: IF l_debug_on
4829: THEN

Line 4848: WHEN FND_API.G_EXC_ERROR THEN

4844: END IF;
4845: --
4846: EXCEPTION
4847:
4848: WHEN FND_API.G_EXC_ERROR THEN
4849: x_return_status := FND_API.G_RET_STS_ERROR;
4850:
4851: IF l_debug_on THEN
4852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 4849: x_return_status := FND_API.G_RET_STS_ERROR;

4845: --
4846: EXCEPTION
4847:
4848: WHEN FND_API.G_EXC_ERROR THEN
4849: x_return_status := FND_API.G_RET_STS_ERROR;
4850:
4851: IF l_debug_on THEN
4852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

4848: WHEN FND_API.G_EXC_ERROR THEN
4849: x_return_status := FND_API.G_RET_STS_ERROR;
4850:
4851: IF l_debug_on THEN
4852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4854: END IF;
4855:
4856: WHEN others THEN

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

4849: x_return_status := FND_API.G_RET_STS_ERROR;
4850:
4851: IF l_debug_on THEN
4852: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4853: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4854: END IF;
4855:
4856: WHEN others THEN
4857: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4915: x_return_status := FND_API.G_RET_STS_SUCCESS;

4911: IF l_debug_on THEN
4912: WSH_DEBUG_SV.push(l_module_name);
4913: END IF;
4914: --
4915: x_return_status := FND_API.G_RET_STS_SUCCESS;
4916:
4917: IF l_debug_on
4918: THEN
4919: WSH_DEBUG_SV.log(l_module_name,'p_xml_output',p_xml_output.getStringVal());

Line 4936: raise FND_API.G_EXC_ERROR;

4932:
4933: WSH_DEBUG_SV.log(l_module_name,'Fetch_XML_Match Failed');
4934: END IF;
4935:
4936: raise FND_API.G_EXC_ERROR;
4937: END IF;
4938:
4939: i:=l_xml_seq.FIRST;
4940:

Line 4971: raise FND_API.G_EXC_ERROR;

4967:
4968: WSH_DEBUG_SV.log(l_module_name,'Extract_Ship_Method Failed');
4969: END IF;
4970:
4971: raise FND_API.G_EXC_ERROR;
4972: END IF;
4973:
4974:
4975:

Line 5016: raise FND_API.G_EXC_ERROR;

5012:
5013: WSH_DEBUG_SV.log(l_module_name,'Populate_Get_SM_Result Failed');
5014: END IF;
5015:
5016: raise FND_API.G_EXC_ERROR;
5017: END IF;
5018:
5019: ELSE
5020: IF l_debug_on THEN

Line 5024: raise FND_API.G_EXC_ERROR;

5020: IF l_debug_on THEN
5021: WSH_DEBUG_SV.log(l_module_name,'Path does not exist',G_XPATH_GET_SM_RESULT);
5022:
5023: END IF;
5024: raise FND_API.G_EXC_ERROR;
5025:
5026:
5027: END IF;
5028:

Line 5037: WHEN FND_API.G_EXC_ERROR THEN

5033: END IF;
5034: --
5035: EXCEPTION
5036:
5037: WHEN FND_API.G_EXC_ERROR THEN
5038: x_return_status := FND_API.G_RET_STS_ERROR;
5039:
5040: IF l_debug_on THEN
5041: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 5038: x_return_status := FND_API.G_RET_STS_ERROR;

5034: --
5035: EXCEPTION
5036:
5037: WHEN FND_API.G_EXC_ERROR THEN
5038: x_return_status := FND_API.G_RET_STS_ERROR;
5039:
5040: IF l_debug_on THEN
5041: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5042: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

5037: WHEN FND_API.G_EXC_ERROR THEN
5038: x_return_status := FND_API.G_RET_STS_ERROR;
5039:
5040: IF l_debug_on THEN
5041: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5042: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5043: END IF;
5044:
5045: WHEN others THEN

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

5038: x_return_status := FND_API.G_RET_STS_ERROR;
5039:
5040: IF l_debug_on THEN
5041: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5042: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5043: END IF;
5044:
5045: WHEN others THEN
5046: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5106: x_return_status := FND_API.G_RET_STS_SUCCESS;

5102: p_source_line_tab(p_source_line_tab.FIRST).source_header_id);
5103: WSH_DEBUG_SV.log(l_module_name,'p_source_header_rec.currency',p_source_header_rec.currency);
5104: END IF;
5105: --
5106: x_return_status := FND_API.G_RET_STS_SUCCESS;
5107:
5108: IF p_source_header_rec.currency IS NOT NULL THEN
5109: l_currency_code := p_source_header_rec.currency;
5110: ELSE

Line 5152: raise FND_API.G_EXC_ERROR;

5148:
5149: WSH_DEBUG_SV.log(l_module_name,'Extract_Ship_Method Failed');
5150: END IF;
5151:
5152: raise FND_API.G_EXC_ERROR;
5153: END IF;
5154:
5155: IF l_debug_on
5156: THEN

Line 5184: raise FND_API.G_EXC_ERROR;

5180:
5181: WSH_DEBUG_SV.log(l_module_name,'Populate_Get_FC_Result Failed');
5182: END IF;
5183:
5184: raise FND_API.G_EXC_ERROR;
5185: END IF;
5186: ELSE
5187:
5188: IF l_debug_on THEN

Line 5192: raise FND_API.G_EXC_ERROR;

5188: IF l_debug_on THEN
5189: WSH_DEBUG_SV.log(l_module_name,'Path does not exist',G_XPATH_FREIGHT_COST_RESULT);
5190:
5191: END IF;
5192: raise FND_API.G_EXC_ERROR;
5193: END IF;
5194: --
5195: IF l_debug_on THEN
5196: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

Line 5202: x_return_status := FND_API.G_RET_STS_ERROR;

5198: END IF;
5199: --
5200: EXCEPTION
5201: WHEN ORDER_NO_HEADER_ID_ERROR THEN
5202: x_return_status := FND_API.G_RET_STS_ERROR;
5203:
5204: IF l_debug_on THEN
5205: WSH_DEBUG_SV.logmsg(l_module_name,'Order Header Id is null',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ORDER_NO_HEADER_ID_ERROR');

Line 5210: x_return_status := FND_API.G_RET_STS_ERROR;

5206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ORDER_NO_HEADER_ID_ERROR');
5207: END IF;
5208:
5209: WHEN ORDER_NO_CURR_ERROR THEN
5210: x_return_status := FND_API.G_RET_STS_ERROR;
5211:
5212: IF l_debug_on THEN
5213: WSH_DEBUG_SV.logmsg(l_module_name,'Transactional Curr Code is not defined for the order.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ORDER_NO_CURR_ERROR');

Line 5217: WHEN FND_API.G_EXC_ERROR THEN

5213: WSH_DEBUG_SV.logmsg(l_module_name,'Transactional Curr Code is not defined for the order.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ORDER_NO_CURR_ERROR');
5215: END IF;
5216:
5217: WHEN FND_API.G_EXC_ERROR THEN
5218: x_return_status := FND_API.G_RET_STS_ERROR;
5219:
5220: IF l_debug_on THEN
5221: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 5218: x_return_status := FND_API.G_RET_STS_ERROR;

5214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ORDER_NO_CURR_ERROR');
5215: END IF;
5216:
5217: WHEN FND_API.G_EXC_ERROR THEN
5218: x_return_status := FND_API.G_RET_STS_ERROR;
5219:
5220: IF l_debug_on THEN
5221: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

5217: WHEN FND_API.G_EXC_ERROR THEN
5218: x_return_status := FND_API.G_RET_STS_ERROR;
5219:
5220: IF l_debug_on THEN
5221: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5223: END IF;
5224:
5225: WHEN others THEN

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

5218: x_return_status := FND_API.G_RET_STS_ERROR;
5219:
5220: IF l_debug_on THEN
5221: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5222: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5223: END IF;
5224:
5225: WHEN others THEN
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5294: x_return_status := FND_API.G_RET_STS_SUCCESS;

5290: IF l_debug_on THEN
5291: WSH_DEBUG_SV.push(l_module_name);
5292: END IF;
5293: --
5294: x_return_status := FND_API.G_RET_STS_SUCCESS;
5295:
5296:
5297: Fetch_XML_Match(
5298: p_xml=>p_xml_output,

Line 5311: raise FND_API.G_EXC_ERROR;

5307:
5308: WSH_DEBUG_SV.log(l_module_name,'Fetch_XML_Match Failed');
5309: END IF;
5310:
5311: raise FND_API.G_EXC_ERROR;
5312: END IF;
5313:
5314:
5315: i:=l_xml_seq.FIRST;

Line 5341: --raise FND_API.G_EXC_ERROR;

5337: WSH_DEBUG_SV.log(l_module_name,'Extract_Ship_Method Failed');
5338: END IF;
5339: l_SM_failure:='Y';
5340:
5341: --raise FND_API.G_EXC_ERROR;
5342:
5343:
5344: END IF;
5345:

Line 5413: raise FND_API.G_EXC_ERROR;

5409: THEN
5410: WSH_DEBUG_SV.log(l_module_name,'Extract_Rate Failed');
5411: END IF;
5412:
5413: raise FND_API.G_EXC_ERROR;
5414: END IF;
5415:
5416:
5417: IF l_debug_on

Line 5504: raise FND_API.G_EXC_ERROR;

5500: THEN
5501: WSH_DEBUG_SV.log(l_module_name,'Populate_Choose_SM_Result Failed');
5502: END IF;
5503:
5504: raise FND_API.G_EXC_ERROR;
5505: END IF;
5506:
5507: l_sm_i:=l_SM_tab.NEXT(l_sm_i);
5508:

Line 5525: raise FND_API.G_EXC_ERROR;

5521:
5522: WSH_DEBUG_SV.log(l_module_name,'Sort Failed');
5523: END IF;
5524:
5525: raise FND_API.G_EXC_ERROR;
5526: END IF;
5527:
5528: IF (x_source_header_rates_tab.COUNT = 0)
5529: THEN

Line 5537: raise FND_API.G_EXC_ERROR;

5533: WSH_DEBUG_SV.log(l_module_name,'No Valid results for Choos Ship Method');
5534: END IF;
5535:
5536:
5537: raise FND_API.G_EXC_ERROR;
5538:
5539: END IF;
5540:
5541: --

Line 5549: WHEN FND_API.G_EXC_ERROR THEN

5545: END IF;
5546: --
5547: EXCEPTION
5548:
5549: WHEN FND_API.G_EXC_ERROR THEN
5550: x_return_status := FND_API.G_RET_STS_ERROR;
5551:
5552: IF l_debug_on THEN
5553: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 5550: x_return_status := FND_API.G_RET_STS_ERROR;

5546: --
5547: EXCEPTION
5548:
5549: WHEN FND_API.G_EXC_ERROR THEN
5550: x_return_status := FND_API.G_RET_STS_ERROR;
5551:
5552: IF l_debug_on THEN
5553: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

5549: WHEN FND_API.G_EXC_ERROR THEN
5550: x_return_status := FND_API.G_RET_STS_ERROR;
5551:
5552: IF l_debug_on THEN
5553: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5555: END IF;
5556:
5557: WHEN others THEN

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

5550: x_return_status := FND_API.G_RET_STS_ERROR;
5551:
5552: IF l_debug_on THEN
5553: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5555: END IF;
5556:
5557: WHEN others THEN
5558: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5609: x_return_status := FND_API.G_RET_STS_SUCCESS;

5605: IF l_debug_on THEN
5606: WSH_DEBUG_SV.push(l_module_name);
5607: END IF;
5608: --
5609: x_return_status := FND_API.G_RET_STS_SUCCESS;
5610:
5611: IF(p_xml_output IS NOT NULL)
5612: THEN
5613: --g_xml_namespace_map:=p_xml_output.getNameSpace();

Line 5643: raise FND_API.G_EXC_ERROR;

5639:
5640: WSH_DEBUG_SV.log(l_module_name,'Check_Response_Status Failed');
5641: END IF;
5642:
5643: raise FND_API.G_EXC_ERROR;
5644: END IF;
5645:
5646:
5647:

Line 5668: raise FND_API.G_EXC_ERROR;

5664:
5665: WSH_DEBUG_SV.log(l_module_name,'Handle_Choose_SM_Response Failed');
5666: END IF;
5667:
5668: raise FND_API.G_EXC_ERROR;
5669: END IF;
5670:
5671:
5672: ELSIF(p_action='R')

Line 5692: raise FND_API.G_EXC_ERROR;

5688:
5689: WSH_DEBUG_SV.log(l_module_name,'Handle_Get_FC_Response Failed');
5690: END IF;
5691:
5692: raise FND_API.G_EXC_ERROR;
5693: END IF;
5694:
5695:
5696: ELSIF (p_action= 'C')

Line 5722: raise FND_API.G_EXC_ERROR;

5718:
5719: WSH_DEBUG_SV.log(l_module_name,'Handle_Get_FC_Response Failed');
5720: END IF;
5721:
5722: raise FND_API.G_EXC_ERROR;
5723: END IF;
5724:
5725:
5726: END IF;

Line 5738: WHEN FND_API.G_EXC_ERROR THEN

5734: END IF;
5735: --
5736: EXCEPTION
5737:
5738: WHEN FND_API.G_EXC_ERROR THEN
5739: x_return_status := FND_API.G_RET_STS_ERROR;
5740:
5741: IF l_debug_on THEN
5742: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 5739: x_return_status := FND_API.G_RET_STS_ERROR;

5735: --
5736: EXCEPTION
5737:
5738: WHEN FND_API.G_EXC_ERROR THEN
5739: x_return_status := FND_API.G_RET_STS_ERROR;
5740:
5741: IF l_debug_on THEN
5742: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

5738: WHEN FND_API.G_EXC_ERROR THEN
5739: x_return_status := FND_API.G_RET_STS_ERROR;
5740:
5741: IF l_debug_on THEN
5742: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5744: END IF;
5745:
5746: WHEN others THEN

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

5739: x_return_status := FND_API.G_RET_STS_ERROR;
5740:
5741: IF l_debug_on THEN
5742: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5744: END IF;
5745:
5746: WHEN others THEN
5747: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5793: x_return_status := FND_API.G_RET_STS_SUCCESS;

5789: IF l_debug_on THEN
5790: WSH_DEBUG_SV.push(l_module_name);
5791: END IF;
5792: --
5793: x_return_status := FND_API.G_RET_STS_SUCCESS;
5794:
5795: --Clean up cache
5796: g_carrier_freight_codes.DELETE;
5797: g_carrier_generic_flags.DELETE;

Line 5840: RAISE FND_API.G_EXC_ERROR;

5836: FND_MESSAGE.SET_TOKEN('PRF_NAME',fnd_message.get_string('WSH','WSH_OTM_PASSWORD'));
5837: FND_MSG_PUB.ADD;
5838: END IF;
5839:
5840: RAISE FND_API.G_EXC_ERROR;
5841: END IF;--}
5842:
5843: --Time Zone
5844: g_timezone_code:=FND_TIMEZONES.get_server_timezone_code;

Line 5864: WHEN FND_API.G_EXC_ERROR THEN

5860: END IF;
5861: --
5862: EXCEPTION
5863:
5864: WHEN FND_API.G_EXC_ERROR THEN
5865: x_return_status := FND_API.G_RET_STS_ERROR;
5866:
5867: IF l_debug_on THEN
5868: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 5865: x_return_status := FND_API.G_RET_STS_ERROR;

5861: --
5862: EXCEPTION
5863:
5864: WHEN FND_API.G_EXC_ERROR THEN
5865: x_return_status := FND_API.G_RET_STS_ERROR;
5866:
5867: IF l_debug_on THEN
5868: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

5864: WHEN FND_API.G_EXC_ERROR THEN
5865: x_return_status := FND_API.G_RET_STS_ERROR;
5866:
5867: IF l_debug_on THEN
5868: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5870: END IF;
5871:
5872: WHEN others THEN

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

5865: x_return_status := FND_API.G_RET_STS_ERROR;
5866:
5867: IF l_debug_on THEN
5868: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5869: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5870: END IF;
5871:
5872: WHEN others THEN
5873: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5909: x_return_status := FND_API.G_RET_STS_SUCCESS;

5905: IF l_debug_on THEN
5906: WSH_DEBUG_SV.push(l_module_name);
5907: END IF;
5908: --
5909: x_return_status := FND_API.G_RET_STS_SUCCESS;
5910:
5911: --Clean up cache
5912: g_carrier_freight_codes.DELETE;
5913: g_carrier_generic_flags.DELETE;

Line 5927: WHEN FND_API.G_EXC_ERROR THEN

5923: END IF;
5924: --
5925: EXCEPTION
5926:
5927: WHEN FND_API.G_EXC_ERROR THEN
5928: x_return_status := FND_API.G_RET_STS_ERROR;
5929:
5930: IF l_debug_on THEN
5931: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 5928: x_return_status := FND_API.G_RET_STS_ERROR;

5924: --
5925: EXCEPTION
5926:
5927: WHEN FND_API.G_EXC_ERROR THEN
5928: x_return_status := FND_API.G_RET_STS_ERROR;
5929:
5930: IF l_debug_on THEN
5931: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5932: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

5927: WHEN FND_API.G_EXC_ERROR THEN
5928: x_return_status := FND_API.G_RET_STS_ERROR;
5929:
5930: IF l_debug_on THEN
5931: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5932: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5933: END IF;
5934:
5935: WHEN others THEN

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

5928: x_return_status := FND_API.G_RET_STS_ERROR;
5929:
5930: IF l_debug_on THEN
5931: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5932: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5933: END IF;
5934:
5935: WHEN others THEN
5936: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 5999: x_return_status := FND_API.G_RET_STS_SUCCESS;

5995: IF l_debug_on THEN
5996: WSH_DEBUG_SV.push(l_module_name);
5997: END IF;
5998: --
5999: x_return_status := FND_API.G_RET_STS_SUCCESS;
6000:
6001:
6002: l_source_line_tab_xml:= NEW WSH_OTM_RIQ_LINE_TAB();
6003: --Get a new line table for each header

Line 6043: raise FND_API.G_EXC_ERROR;

6039: THEN
6040:
6041: WSH_DEBUG_SV.log(l_module_name,'Format_Line_Input_For_Xml Failed');
6042: END IF;
6043: raise FND_API.G_EXC_ERROR;
6044:
6045: END IF;
6046:
6047:

Line 6065: raise FND_API.G_EXC_ERROR;

6061:
6062: WSH_DEBUG_SV.log(l_module_name,'Create_RIQ_XML Failed');
6063: END IF;
6064:
6065: raise FND_API.G_EXC_ERROR;
6066:
6067: END IF;
6068:
6069:

Line 6083: raise FND_API.G_EXC_ERROR;

6079: THEN
6080: WSH_DEBUG_SV.log(l_module_name,'print_CLOB Failed');
6081: END IF;
6082:
6083: raise FND_API.G_EXC_ERROR;
6084: END IF;
6085: END IF;
6086:
6087:

Line 6110: raise FND_API.G_EXC_ERROR;

6106: THEN
6107:
6108: WSH_DEBUG_SV.log(l_module_name,'POST_REQUEST_TO_OTM Failed');
6109: END IF;
6110: raise FND_API.G_EXC_ERROR;
6111:
6112: END IF;
6113:
6114: IF ((l_xmlCLOB IS NULL) OR (DBMS_LOB.GETLENGTH(l_xmlCLOB) <= 0))

Line 6122: raise FND_API.G_EXC_ERROR;

6118: THEN
6119:
6120: WSH_DEBUG_SV.log(l_module_name,'Returned CLOB is invalid');
6121: END IF;
6122: raise FND_API.G_EXC_ERROR;
6123:
6124: END IF;
6125:
6126:

Line 6147: raise FND_API.G_EXC_ERROR;

6143: THEN
6144: WSH_DEBUG_SV.log(l_module_name,'print_CLOB Failed');
6145: END IF;
6146:
6147: raise FND_API.G_EXC_ERROR;
6148: END IF;
6149: END IF;
6150:
6151: IF l_debug_on

Line 6192: raise FND_API.G_EXC_ERROR;

6188: THEN
6189: WSH_DEBUG_SV.log(l_module_name,'Parse_RIQ_Output_XML Failed');
6190: END IF;
6191:
6192: raise FND_API.G_EXC_ERROR;
6193:
6194: END IF;
6195:
6196:

Line 6210: WHEN FND_API.G_EXC_ERROR THEN

6206: END IF;
6207: --
6208: EXCEPTION
6209:
6210: WHEN FND_API.G_EXC_ERROR THEN
6211: x_return_status := FND_API.G_RET_STS_ERROR;
6212:
6213: IF l_debug_on THEN
6214: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 6211: x_return_status := FND_API.G_RET_STS_ERROR;

6207: --
6208: EXCEPTION
6209:
6210: WHEN FND_API.G_EXC_ERROR THEN
6211: x_return_status := FND_API.G_RET_STS_ERROR;
6212:
6213: IF l_debug_on THEN
6214: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6215: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

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

6210: WHEN FND_API.G_EXC_ERROR THEN
6211: x_return_status := FND_API.G_RET_STS_ERROR;
6212:
6213: IF l_debug_on THEN
6214: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6215: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6216: END IF;
6217:
6218: WHEN others THEN

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

6211: x_return_status := FND_API.G_RET_STS_ERROR;
6212:
6213: IF l_debug_on THEN
6214: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6215: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6216: END IF;
6217:
6218: WHEN others THEN
6219: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 6284: x_return_status := FND_API.G_RET_STS_SUCCESS;

6280: IF l_debug_on THEN
6281: WSH_DEBUG_SV.push(l_module_name);
6282: END IF;
6283: --
6284: x_return_status := FND_API.G_RET_STS_SUCCESS;
6285:
6286: FND_MSG_PUB.initialize;
6287:
6288: --ECO 5516007 changes start, FP(5573379) to R12

Line 6307: RAISE FND_API.G_EXC_ERROR;

6303: -- Handle Return Status for Error or Unexpected error.
6304: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
6305: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
6306: -- standard error raising, as used in this API
6307: RAISE FND_API.G_EXC_ERROR;
6308: END IF;
6309: --ECO 5516007 changes end, FP to R12
6310: /*Bug7329859 storing x_source_line_tab in a global table to use in API Format_Header_Input_For_Xml*/
6311: g_source_line_tab_temp.DELETE;

Line 6325: raise FND_API.G_EXC_ERROR;

6321: IF l_debug_on
6322: THEN
6323: WSH_DEBUG_SV.log(l_module_name,'print_source_line_tab Failed');
6324: END IF;
6325: raise FND_API.G_EXC_ERROR;
6326: END IF;
6327:
6328: print_source_header_tab (
6329: p_source_header_tab=>x_source_header_tab,

Line 6337: raise FND_API.G_EXC_ERROR;

6333: IF l_debug_on
6334: THEN
6335: WSH_DEBUG_SV.log(l_module_name,'print_source_header_tab Failed');
6336: END IF;
6337: raise FND_API.G_EXC_ERROR;
6338: END IF;
6339:
6340: END IF;
6341:

Line 6350: raise FND_API.G_EXC_ERROR;

6346: IF l_debug_on
6347: THEN
6348: WSH_DEBUG_SV.log(l_module_name,'Init_Globals Failed');
6349: END IF;
6350: raise FND_API.G_EXC_ERROR;
6351: END IF;
6352:
6353:
6354: l_source_header_tab_xml:= NEW WSH_OTM_RIQ_HEADER_TAB();

Line 6372: raise FND_API.G_EXC_ERROR;

6368:
6369: WSH_DEBUG_SV.log(l_module_name,'Format_Header_Input_For_Xml Failed');
6370: END IF;
6371:
6372: raise FND_API.G_EXC_ERROR;
6373: END IF;
6374:
6375: l_failed_header_count:=0;
6376: l_total_header_count:=l_source_header_tab_xml.COUNT;

Line 6382: IF (nvl(l_param_info.organization_id,FND_API.G_MISS_NUM) <>

6378: WHILE(i IS NOT NULL)
6379: LOOP
6380: --OTM R12 Org-Specific start . Added the check l_param_info.otm_enabled = 'Y and
6381: --the corresponding ELSE part.
6382: IF (nvl(l_param_info.organization_id,FND_API.G_MISS_NUM) <>
6383: x_source_header_tab(i).ship_from_org_id) THEN --{
6384: WSH_SHIPPING_PARAMS_PVT.Get(
6385: p_organization_id => x_source_header_tab(i).ship_from_org_id,
6386: x_param_info => l_param_info,

Line 6397: RAISE FND_API.G_EXC_ERROR;

6393: x_source_header_tab(i).ship_from_org_id);
6394: END IF;
6395: IF (l_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,
6396: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
6397: RAISE FND_API.G_EXC_ERROR;
6398: END IF;
6399: END IF; --}
6400: --OTM R12 End
6401:

Line 6428: --raise FND_API.G_EXC_ERROR;

6424: THEN
6425: WSH_DEBUG_SV.log(l_module_name,'Process_One_Header Failed');
6426: END IF;
6427: l_failed_header_count:=l_failed_header_count+1;
6428: --raise FND_API.G_EXC_ERROR;
6429: END IF;
6430: ELSE --OTM R12 Org-Specific. Added the else part.
6431: IF l_debug_on THEN
6432: WSH_DEBUG_SV.log(l_module_name,'OTM not enabled for organzation', x_source_header_tab(i).ship_from_org_id);

Line 6450: raise FND_API.G_EXC_ERROR;

6446: IF l_debug_on
6447: THEN
6448: WSH_DEBUG_SV.log(l_module_name,'Clear_Globals Failed');
6449: END IF;
6450: raise FND_API.G_EXC_ERROR;
6451: END IF;
6452:
6453: IF (l_debug_on)
6454: THEN

Line 6466: raise FND_API.G_EXC_ERROR;

6462: IF l_debug_on
6463: THEN
6464: WSH_DEBUG_SV.log(l_module_name,'print_source_line_tab Failed');
6465: END IF;
6466: raise FND_API.G_EXC_ERROR;
6467: END IF;
6468:
6469: print_source_header_tab (
6470: p_source_header_tab=>x_source_header_tab,

Line 6478: raise FND_API.G_EXC_ERROR;

6474: IF l_debug_on
6475: THEN
6476: WSH_DEBUG_SV.log(l_module_name,'print_source_header_tab Failed');
6477: END IF;
6478: raise FND_API.G_EXC_ERROR;
6479: END IF;
6480:
6481:
6482: print_rates_tab (

Line 6492: raise FND_API.G_EXC_ERROR;

6488: IF l_debug_on
6489: THEN
6490: WSH_DEBUG_SV.log(l_module_name,'print_source_header_tab Failed');
6491: END IF;
6492: raise FND_API.G_EXC_ERROR;
6493: END IF;
6494:
6495: print_CS_Results(
6496: p_result_consolidation_id_tab=>x_result_consolidation_id_tab,

Line 6511: raise FND_API.G_EXC_ERROR;

6507: IF l_debug_on
6508: THEN
6509: WSH_DEBUG_SV.log(l_module_name,'print_CS_Results Failed');
6510: END IF;
6511: raise FND_API.G_EXC_ERROR;
6512: END IF;
6513:
6514:
6515:

Line 6576: p_encoded => FND_API.G_FALSE

6572: FND_MSG_PUB.Count_And_Get
6573: (
6574: p_count => x_msg_count,
6575: p_data => x_msg_data,
6576: p_encoded => FND_API.G_FALSE
6577: );
6578: IF l_debug_on
6579: THEN
6580: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);

Line 6593: WHEN FND_API.G_EXC_ERROR THEN

6589: END IF;
6590: --
6591: EXCEPTION
6592:
6593: WHEN FND_API.G_EXC_ERROR THEN
6594: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');
6595: IF l_debug_on
6596: THEN
6597: FND_MESSAGE.SET_TOKEN('LOGFILE',WSH_DEBUG_SV.g_Dir||'/'||WSH_DEBUG_SV.g_File);

Line 6614: p_encoded => FND_API.G_FALSE

6610: FND_MSG_PUB.Count_And_Get
6611: (
6612: p_count => x_msg_count,
6613: p_data => x_msg_data,
6614: p_encoded => FND_API.G_FALSE
6615: );
6616:
6617: IF l_debug_on THEN
6618: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

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

6614: p_encoded => FND_API.G_FALSE
6615: );
6616:
6617: IF l_debug_on THEN
6618: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6619: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
6620: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);
6621: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6622: END IF;

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

6617: IF l_debug_on THEN
6618: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6619: WSH_DEBUG_SV.log(l_module_name,'x_msg_count',x_msg_count);
6620: WSH_DEBUG_SV.log(l_module_name,'x_msg_data',x_msg_data);
6621: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6622: END IF;
6623:
6624: WHEN OTHERS THEN
6625: FND_MESSAGE.SET_NAME('FTE','FTE_PRC_LOG_FILE_NAME');

Line 6646: p_encoded => FND_API.G_FALSE

6642: FND_MSG_PUB.Count_And_Get
6643: (
6644: p_count => x_msg_count,
6645: p_data => x_msg_data,
6646: p_encoded => FND_API.G_FALSE
6647: );
6648: --wsh_util_core.default_handler('WSH_OTM_RIQ_XML.CALL_OTM_FOR_OM',l_module_name);
6649: --
6650: IF l_debug_on THEN