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

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

171: WSH_DEBUG_SV.log(l_module_name,'l_debug_num ',l_debug_num);
172: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
173: 'Oracle error message is '||
174: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
175: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
176: END IF;
177: END clear_wsh_prev_tabs;
178:
179:

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

317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
319: 'Oracle error message is '||
320: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
321: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
322: END IF;
323: END calc_service_mode;
324:
325:

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

443: IF l_debug_on THEN
444: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
445: 'Oracle error message is '||
446: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
447: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
448: END IF;
449: END check_null_fields;
450:
451:

Line 534: RAISE FND_API.G_EXC_ERROR;

530: FND_MESSAGE.SET_TOKEN('FIELD_NAME',l_token);
531: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,
532: l_module_name);
533:
534: RAISE FND_API.G_EXC_ERROR;
535:
536: END IF;
537:
538: p_additional_line_info_rec.inv_interfaced_flag(p_index) := 'X';

Line 616: RAISE FND_API.G_EXC_ERROR;

612: IF(l_item_type = 'CONT_ITEM') THEN
613: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_ITEM_TYPE');
614: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,
615: l_module_name);
616: RAISE FND_API.G_EXC_ERROR;
617: END IF;
618: END IF; --}
619: END IF; --}
620:

Line 637: RAISE FND_API.G_EXC_ERROR;

633: IF l_debug_on THEN
634: WSH_DEBUG_SV.log(l_module_name,'l_token ',l_token);
635: END IF;
636:
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: IF l_debug_on THEN
641: WSH_DEBUG_SV.log(l_module_name,'requeste_quantity ',

Line 650: WHEN FND_API.G_EXC_ERROR THEN

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

Line 654: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

650: WHEN FND_API.G_EXC_ERROR THEN
651: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
652: --
653: IF l_debug_on THEN
654: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
655: || '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: --

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

652: --
653: IF l_debug_on THEN
654: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
655: || '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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

655: || '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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
661: --
662: IF l_debug_on THEN
663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||

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

661: --
662: IF l_debug_on THEN
663: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
664: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
665: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
666: END IF;
667:
668: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
669: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

682: IF l_debug_on THEN
683: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
684: 'Oracle error message is '||
685: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
686: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
687: END IF;
688:
689: END Calc_wt_vol_qty;
690:

Line 844: raise fnd_api.g_exc_error;

840: --If party not exists, throw an error message and return.
841: IF l_debug_on THEN
842: WSH_DEBUG_SV.log(l_module_name,'Party does not Exist for the Vendor ');
843: END IF;
844: raise fnd_api.g_exc_error;
845: -- } IB-Phase-2
846: END IF;
847:
848:

Line 878: RAISE FND_API.G_EXC_ERROR;

874:
875: /* if no lines were validated successfully, but there were some
876: eligible records then raise error */
877:
878: RAISE FND_API.G_EXC_ERROR;
879: ELSE
880:
881: /* if no lines were validated successfully, and no lines were
882: eligible then return success */

Line 998: WHEN FND_API.G_EXC_ERROR THEN

994: WSH_DEBUG_SV.pop(l_module_name);
995: END IF;
996: --
997: EXCEPTION
998: WHEN FND_API.G_EXC_ERROR THEN
999: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1000: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1001: --
1002: IF l_debug_on THEN

Line 1003: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

999: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1000: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1001: --
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
1004: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1005: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1006: END IF;
1007: --

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

1001: --
1002: IF l_debug_on THEN
1003: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
1004: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1005: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1006: END IF;
1007: --
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1004: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1005: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1006: END IF;
1007: --
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1010: --
1011: IF l_debug_on THEN
1012: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||

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

1010: --
1011: IF l_debug_on THEN
1012: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
1013: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1014: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1015: END IF;
1016:
1017: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1018: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
1033: 'Oracle error message is '||
1034: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1035: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1036: END IF;
1037:
1038: END Create_delivery_details;
1039:

Line 1094: RAISE FND_API.G_EXC_ERROR;

1090: END IF;
1091:
1092: IF x_table_count = 0 THEN
1093: --bms do we need to set some message
1094: RAISE FND_API.G_EXC_ERROR;
1095: END IF;
1096:
1097:
1098: IF p_line_rec.org_id.COUNT = 0 AND nvl(p_action_prms.caller,'@@@') <> 'WSH_IB_UTIL' THEN

Line 2138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2134: IF p_action_prms.caller = 'OM' THEN
2135: IF l_debug_on THEN
2136: WSH_DEBUG_SV.log(l_module_name,'x_table_count ',x_table_count);
2137: END IF;
2138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2139: END IF;
2140:
2141: p_line_rec.shipping_eligible_flag.EXTEND;
2142: p_line_rec.shipping_eligible_flag(p_line_rec.shipping_eligible_flag.FIRST) := 'Y';

Line 2941: WHEN FND_API.G_EXC_ERROR THEN

2937: WSH_DEBUG_SV.pop(l_module_name);
2938: END IF;
2939:
2940: EXCEPTION
2941: WHEN FND_API.G_EXC_ERROR THEN
2942: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2943: --
2944: IF l_debug_on THEN
2945: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

Line 2945: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

2941: WHEN FND_API.G_EXC_ERROR THEN
2942: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2943: --
2944: IF l_debug_on THEN
2945: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
2946: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2948: END IF;
2949: --

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

2943: --
2944: IF l_debug_on THEN
2945: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
2946: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2948: END IF;
2949: --
2950: WHEN e_extend_error THEN
2951: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2957: WSH_DEBUG_SV.log(l_module_name,'l_field_name ',l_field_name);
2958: WSH_DEBUG_SV.log(l_module_name,'l_count ',l_count);
2959: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_extend_error');
2960: END IF;
2961: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2962: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2963: --
2964: IF l_debug_on THEN
2965: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||

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

2963: --
2964: IF l_debug_on THEN
2965: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
2966: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2968: END IF;
2969:
2970: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2971: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2984: IF l_debug_on THEN
2985: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
2986: 'Oracle error message is '||
2987: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2988: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2989: END IF;
2990:
2991:
2992: END Extend_tables;

Line 3107: RAISE FND_API.G_EXC_ERROR;

3103: ELSE
3104: IF l_debug_on THEN
3105: WSH_DEBUG_SV.log(l_module_name,'bad caller ',p_action_prms.caller);
3106: END IF;
3107: RAISE FND_API.G_EXC_ERROR;
3108: END IF;
3109:
3110: IF p_action_prms.org_id IS NULL THEN
3111: IF l_debug_on THEN

Line 3119: RAISE FND_API.G_EXC_ERROR;

3115: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
3116: FND_MESSAGE.SET_TOKEN('FIELD_NAME','ORG_ID');
3117: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,
3118: l_module_name);
3119: RAISE FND_API.G_EXC_ERROR;
3120: END IF;
3121:
3122:
3123: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_POPULATE_ORGANIZATION_ID) = 1

Line 3458: RAISE FND_API.G_EXC_ERROR;

3454:
3455: IF p_line_rec.org_id(i) <> p_line_rec.org_id(p_line_rec.org_id.FIRST) then
3456: FND_MESSAGE.SET_NAME('WSH','WSH_ORG_ID_INVALID');
3457: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR);
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;
3460: END IF;
3461:
3462: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PO_DEFAULT_SHIPFROM_LVL)=1

Line 3721: WHEN FND_API.G_EXC_ERROR THEN

3717: WSH_DEBUG_SV.pop(l_module_name);
3718: END IF;
3719:
3720: EXCEPTION
3721: WHEN FND_API.G_EXC_ERROR THEN
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3724: --
3725: IF l_debug_on THEN

Line 3726: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
3724: --
3725: IF l_debug_on THEN
3726: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
3727: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3728: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3729: END IF;
3730: --

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

3724: --
3725: IF l_debug_on THEN
3726: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
3727: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3728: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3729: END IF;
3730: --
3731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3732: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 3731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3727: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3728: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3729: END IF;
3730: --
3731: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3732: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3733: --
3734: IF l_debug_on THEN
3735: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||

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

3733: --
3734: IF l_debug_on THEN
3735: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
3736: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3738: END IF;
3739:
3740: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3741: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

3754: IF l_debug_on THEN
3755: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
3756: 'Oracle error message is '||
3757: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3758: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3759: END IF;
3760:
3761: END Validate_lines ;
3762:

Line 4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4233: WSH_DEBUG_SV.log(l_module_name,'l_line_rec_count', l_line_rec_count);
4234: WSH_DEBUG_SV.log(l_module_name,'p_index', p_index);
4235: END IF;
4236: IF l_rec_inserted_count <> l_line_rec_count THEN
4237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4238: END IF;
4239:
4240: -- DBI Project
4241: -- Insert of wsh_delivery_details, call DBI API after the insert.

Line 4256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4252: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
4253: END IF;
4254: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
4255: -- just pass this return status to caller API
4256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4257: END IF;
4258: -- End of Code for DBI Project
4259: --
4260:

Line 4463: WHEN FND_API.G_EXC_ERROR THEN

4459: IF l_debug_on THEN
4460: WSH_DEBUG_SV.pop(l_module_name,'e_success');
4461: END IF;
4462:
4463: WHEN FND_API.G_EXC_ERROR THEN
4464: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4465: --
4466: IF l_debug_on THEN
4467: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

Line 4467: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '

4463: WHEN FND_API.G_EXC_ERROR THEN
4464: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4465: --
4466: IF l_debug_on THEN
4467: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4468: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4469: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4470: END IF;
4471: --

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

4465: --
4466: IF l_debug_on THEN
4467: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has '
4468: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4469: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4470: END IF;
4471: --
4472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4473: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 4472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4468: || 'occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4469: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4470: END IF;
4471: --
4472: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4473: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4474: --
4475: IF l_debug_on THEN
4476: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||

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

4474: --
4475: IF l_debug_on THEN
4476: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. ' ||
4477: 'Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4478: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4479: END IF;
4480:
4481: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4482: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

4498: IF l_debug_on THEN
4499: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4500: 'Oracle error message is '||
4501: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4502: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4503: END IF;
4504:
4505:
4506: END bulk_insert_details;

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

4623: IF l_debug_on THEN
4624: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4625: 'Oracle error message is '||
4626: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4628: END IF;
4629:
4630: END Set_message;
4631:

Line 4781: RAISE FND_API.G_EXC_ERROR;

4777: IF ( p_line_rec.source_header_type_id(p_index) <> 1 )AND
4778: ( p_line_rec.source_header_type_id(p_index) <> 2 ) THEN
4779: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_SRC_HDR_TP');
4780: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR);
4781: RAISE FND_API.G_EXC_ERROR;
4782: END IF;
4783:
4784:
4785: -- If the PO is a non-blanket PO,then the fields 'source_blanket_reference_id '

Line 4793: RAISE FND_API.G_EXC_ERROR;

4789: ( p_line_rec.source_blanket_reference_num(p_index) IS NOT NULL) THEN
4790: FND_MESSAGE.SET_NAME('WSH','WSH_IB_BLANKET_VAL_NOT_NULL');
4791: FND_MESSAGE.SET_TOKEN('PONUM',p_line_rec.source_header_number(p_index));
4792: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR);
4793: RAISE FND_API.G_EXC_ERROR;
4794: END IF;
4795: END IF;
4796: --end of code for Bug # 3188208
4797:

Line 4822: RAISE FND_API.G_EXC_ERROR;

4818: ELSIF p_line_rec.source_line_type_code(p_index) <> 'GB' AND
4819: p_line_rec.source_line_type_code(p_index) <> 'GB_OSP' THEN
4820: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_SOURCE_LINE_TYPE');
4821: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR);
4822: RAISE FND_API.G_EXC_ERROR;
4823: END IF;
4824:
4825: --
4826: IF p_line_rec.vendor_id(p_index) IS NULL THEN

Line 4856: RAISE FND_API.G_EXC_ERROR;

4852: AND p_line_rec.shipping_control(p_index) <> 'SUPPLIER' THEN
4853:
4854: FND_MESSAGE.SET_NAME('WSH','WSH_IB_INVALID_SHIPPING_CNTRL');
4855: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_ERROR);
4856: RAISE FND_API.G_EXC_ERROR;
4857: END IF;
4858: --
4859:
4860: --

Line 4882: WHEN FND_API.G_EXC_ERROR THEN

4878: WSH_DEBUG_SV.logmsg(l_module_name,'L_EXC_MANDATORY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4879: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:L_EXC_MANDATORY');
4880: END IF;
4881: --
4882: WHEN FND_API.G_EXC_ERROR THEN
4883: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4884:
4885: --
4886: -- Debug Statements

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

4885: --
4886: -- Debug Statements
4887: --
4888: IF l_debug_on THEN
4889: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4890: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4891: END IF;
4892: --
4893: WHEN OTHERS THEN

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

4886: -- Debug Statements
4887: --
4888: IF l_debug_on THEN
4889: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4890: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4891: END IF;
4892: --
4893: WHEN OTHERS THEN
4894: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;