DBA Data[Home] [Help]

APPS.WSH_ROUTING_REQUEST dependencies on FND_API

Line 630: l_msg := FND_MSG_PUB.get(i, FND_API.G_FALSE);

626:
627: IF (FND_MSG_PUB.Count_Msg > 0 ) THEN
628: --Loop through all the messages in stack.
629: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP
630: l_msg := FND_MSG_PUB.get(i, FND_API.G_FALSE);
631: IF l_debug_on THEN
632: WSH_DEBUG_SV.log(l_module_name,'Stack Message :',l_msg);
633: END IF;
634:

Line 1553: raise FND_API.G_EXC_ERROR;

1549: p_index =>l_prev_line_number,
1550: x_return_status =>l_return_status);
1551:
1552: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1553: raise FND_API.G_EXC_ERROR;
1554: END IF;
1555:
1556: WHILE (l_index IS NOT NULL ) LOOP --{
1557: g_file_line_number := p_file_fields.file_line_number(l_index);

Line 1567: raise FND_API.G_EXC_ERROR;

1563: p_index =>g_file_line_number,
1564: x_return_status =>l_return_status);
1565:
1566: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
1567: raise FND_API.G_EXC_ERROR;
1568: END IF;
1569:
1570: --Find the mandatory missing columns.
1571: IF (Find_Miss_Column(11) ) THEN

Line 1708: WHEN FND_API.G_EXC_ERROR THEN

1704: IF l_debug_on THEN
1705: WSH_DEBUG_SV.pop(l_module_name);
1706: END IF;
1707: EXCEPTION
1708: WHEN FND_API.G_EXC_ERROR THEN
1709: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1710:
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has

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

1708: WHEN FND_API.G_EXC_ERROR THEN
1709: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
1710:
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
1713: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1714: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1715: END IF;
1716:

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

1710:
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
1713: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1714: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1715: END IF;
1716:
1717: WHEN OTHERS THEN
1718: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2383: WHEN FND_API.G_EXC_ERROR THEN

2379: IF l_debug_on THEN
2380: WSH_DEBUG_SV.pop(l_module_name);
2381: END IF;
2382: EXCEPTION
2383: WHEN FND_API.G_EXC_ERROR THEN
2384: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2385:
2386: IF l_debug_on THEN
2387: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has

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

2383: WHEN FND_API.G_EXC_ERROR THEN
2384: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2385:
2386: IF l_debug_on THEN
2387: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2388: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2390: END IF;
2391:

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

2385:
2386: IF l_debug_on THEN
2387: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2388: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2389: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2390: END IF;
2391:
2392: WHEN OTHERS THEN
2393: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2516: raise fnd_api.g_exc_error;

2512: IF (p_vendor_id IS NULL) THEN
2513: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2514: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_vendor_id');
2515: wsh_util_core.add_message(x_return_status,l_module_name);
2516: raise fnd_api.g_exc_error;
2517: END IF;
2518:
2519: IF (P_location_code IS NULL) THEN
2520: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');

Line 2523: raise fnd_api.g_exc_error;

2519: IF (P_location_code IS NULL) THEN
2520: FND_MESSAGE.SET_NAME('WSH','WSH_REQUIRED_FIELD_NULL');
2521: FND_MESSAGE.SET_TOKEN('FIELD_NAME','p_location_code');
2522: wsh_util_core.add_message(x_return_status,l_module_name);
2523: raise fnd_api.g_exc_error;
2524: END IF;
2525:
2526: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2527:

Line 2583: raise FND_API.G_EXC_ERROR;

2579: l_party_site_msg := p_location_code;
2580: FND_MESSAGE.SET_NAME('WSH','WSH_INACTIVE_PARTY_SITE');
2581: FND_MESSAGE.SET_TOKEN('PARTY_SITE',l_party_site_msg);
2582: fnd_msg_pub.add;
2583: raise FND_API.G_EXC_ERROR;
2584: END IF;
2585: -- } IB-Phase-2
2586:
2587: --Address information are already created, so update the Address Information

Line 2629: WHEN FND_API.G_EXC_ERROR THEN

2625: IF l_debug_on THEN
2626: WSH_DEBUG_SV.pop(l_module_name);
2627: END IF;
2628: EXCEPTION
2629: WHEN FND_API.G_EXC_ERROR THEN
2630: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2631:
2632: IF (check_location_csr%ISOPEN) THEN
2633: CLOSE check_location_csr;

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

2633: CLOSE check_location_csr;
2634: END IF;
2635:
2636: IF l_debug_on THEN
2637: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2638: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2640: END IF;
2641:

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

2635:
2636: IF l_debug_on THEN
2637: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2638: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2639: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2640: END IF;
2641:
2642: WHEN OTHERS THEN
2643: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2806: WHEN FND_API.G_EXC_ERROR THEN

2802: WSH_DEBUG_SV.pop(l_module_name);
2803: END IF;
2804:
2805: EXCEPTION
2806: WHEN FND_API.G_EXC_ERROR THEN
2807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2808:
2809: IF l_debug_on THEN
2810: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has

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

2806: WHEN FND_API.G_EXC_ERROR THEN
2807: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2808:
2809: IF l_debug_on THEN
2810: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2811: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2812: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2813: END IF;
2814:

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

2808:
2809: IF l_debug_on THEN
2810: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2811: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2812: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2813: END IF;
2814:
2815: WHEN OTHERS THEN
2816: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2941: raise fnd_api.g_exc_error;

2937: ) THEN
2938:
2939: FND_MESSAGE.SET_NAME('WSH','WSH_RR_PO_ERROR_CLOSED');
2940: fnd_msg_pub.add;
2941: raise fnd_api.g_exc_error;
2942: END IF;
2943:
2944: --If PO is cancelled.
2945: IF (nvl(l_po_status_rec.cancel_flag(l_index),'N') = 'Y' ) THEN

Line 2948: raise fnd_api.g_exc_error;

2944: --If PO is cancelled.
2945: IF (nvl(l_po_status_rec.cancel_flag(l_index),'N') = 'Y' ) THEN
2946: FND_MESSAGE.SET_NAME('WSH','WSH_RR_PO_ERROR_CANCELLED');
2947: fnd_msg_pub.add;
2948: raise fnd_api.g_exc_error;
2949: END IF;
2950:
2951: --If PO is in Hold.
2952: IF (nvl(l_po_status_rec.hold_flag(l_index),'N') = 'Y') THEN

Line 2955: raise fnd_api.g_exc_error;

2951: --If PO is in Hold.
2952: IF (nvl(l_po_status_rec.hold_flag(l_index),'N') = 'Y') THEN
2953: FND_MESSAGE.SET_NAME('WSH','WSH_RR_PO_ERROR_HOLD');
2954: fnd_msg_pub.add;
2955: raise fnd_api.g_exc_error;
2956: END IF;
2957:
2958: --If PO is not Approved.
2959: IF (nvl(l_po_status_rec.approval_flag(l_index),'N') <> 'Y' ) THEN

Line 2962: raise fnd_api.g_exc_error;

2958: --If PO is not Approved.
2959: IF (nvl(l_po_status_rec.approval_flag(l_index),'N') <> 'Y' ) THEN
2960: FND_MESSAGE.SET_NAME('WSH','WSH_RR_PO_ERROR_UNAPPROVED');
2961: fnd_msg_pub.add;
2962: raise fnd_api.g_exc_error;
2963: END IF;
2964:
2965: l_index:=l_po_status_rec.approval_flag.next(l_index);
2966: END LOOP;

Line 2968: raise fnd_api.g_exc_error;

2964:
2965: l_index:=l_po_status_rec.approval_flag.next(l_index);
2966: END LOOP;
2967: ELSE
2968: raise fnd_api.g_exc_error;
2969: END IF;
2970:
2971: IF l_num_errors > 0 THEN
2972: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 2981: WHEN FND_API.G_EXC_ERROR THEN

2977: IF l_debug_on THEN
2978: WSH_DEBUG_SV.pop(l_module_name);
2979: END IF;
2980: EXCEPTION
2981: WHEN FND_API.G_EXC_ERROR THEN
2982: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2983:
2984: IF l_debug_on THEN
2985: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has

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

2981: WHEN FND_API.G_EXC_ERROR THEN
2982: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2983:
2984: IF l_debug_on THEN
2985: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2986: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2988: END IF;
2989:

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

2983:
2984: IF l_debug_on THEN
2985: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
2986: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2987: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2988: END IF;
2989:
2990: WHEN OTHERS THEN
2991: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3099: raise fnd_api.g_exc_error;

3095: p_line.latest_pickup_date(p_line_index) IS NULL) THEN
3096: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_REQ_PICKUP_DATE');
3097: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_index);
3098: fnd_msg_pub.add;
3099: raise fnd_api.g_exc_error;
3100: ELSIF (p_line.earliest_pickup_date(p_line_index) IS NOT NULL
3101: and p_line.latest_pickup_date(p_line_index) IS NULL) THEN
3102: p_line.latest_pickup_date(p_line_index):= p_line.earliest_pickup_date(p_line_index);
3103: ELSIF (p_line.earliest_pickup_date(p_line_index) IS NULL

Line 3113: raise fnd_api.g_exc_error;

3109: IF (p_line.earliest_pickup_date(p_line_index) > p_line.latest_pickup_date(p_line_index) ) THEN
3110: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_INV_PICKUP_DATE');
3111: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line_index);
3112: fnd_msg_pub.add;
3113: raise fnd_api.g_exc_error;
3114: END IF;
3115:
3116: END IF;
3117:

Line 3124: raise fnd_api.g_exc_error;

3120: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');
3121: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_item_qty));
3122: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_line_index);
3123: fnd_msg_pub.add;
3124: raise fnd_api.g_exc_error;
3125: END IF;
3126:
3127: --No negative weight.
3128: IF (nvl(p_line.weight(p_line_index),1) < 0 ) THEN

Line 3133: raise fnd_api.g_exc_error;

3129: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');
3130: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_total_weight));
3131: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_line_index);
3132: fnd_msg_pub.add;
3133: raise fnd_api.g_exc_error;
3134: END IF;
3135:
3136:
3137: --No negative volume.

Line 3143: raise fnd_api.g_exc_error;

3139: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');
3140: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_total_volume));
3141: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_line_index);
3142: fnd_msg_pub.add;
3143: raise fnd_api.g_exc_error;
3144: END IF;
3145:
3146:
3147: --If Weight UOM is given then weight is requried, vice-versa.

Line 3160: raise fnd_api.g_exc_error;

3156: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_weight_uom));
3157: END IF;
3158: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_line_index);
3159: fnd_msg_pub.add;
3160: raise fnd_api.g_exc_error;
3161: END IF;
3162:
3163: --If Volume UOM is given then Volume is requried, vice-versa.
3164: IF ( (p_line.volume(p_line_index) IS NOT NULL and p_line.volume_uom(p_line_index) IS NULL )

Line 3176: raise fnd_api.g_exc_error;

3172: END IF;
3173:
3174: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_line_index);
3175: fnd_msg_pub.add;
3176: raise fnd_api.g_exc_error;
3177: END IF;
3178:
3179: l_item_qty:=p_line.item_quantity(p_line_index);
3180:

Line 3195: raise fnd_api.g_exc_error;

3191: IF (get_item_uom%NOTFOUND) THEN
3192: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_UOM');
3193: fnd_msg_pub.add;
3194: CLOSE get_item_uom;
3195: raise fnd_api.g_exc_error;
3196: END IF;
3197: CLOSE get_item_uom;
3198:
3199: --Convert the routing request line qty to detail line qty UOM.

Line 3319: WHEN FND_API.G_EXC_ERROR THEN

3315: IF l_debug_on THEN
3316: WSH_DEBUG_SV.pop(l_module_name);
3317: END IF;
3318: EXCEPTION
3319: WHEN FND_API.G_EXC_ERROR THEN
3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3321:
3322: IF l_debug_on THEN
3323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has

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

3319: WHEN FND_API.G_EXC_ERROR THEN
3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3321:
3322: IF l_debug_on THEN
3323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3324: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3325: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3326: END IF;
3327:

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

3321:
3322: IF l_debug_on THEN
3323: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3324: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3325: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3326: END IF;
3327:
3328: WHEN OTHERS THEN
3329: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3400: raise fnd_api.g_exc_error;

3396: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_number_of_containers));
3397: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_delivery_index);
3398: fnd_msg_pub.add;
3399:
3400: raise fnd_api.g_exc_error;
3401: END IF;
3402:
3403: IF (nvl(p_delivery.total_weight(p_delivery_index),1) < 0 ) THEN
3404: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');

Line 3409: raise fnd_api.g_exc_error;

3405: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_del_total_weight));
3406: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_delivery_index);
3407: fnd_msg_pub.add;
3408:
3409: raise fnd_api.g_exc_error;
3410: END IF;
3411:
3412:
3413: IF (nvl(p_delivery.total_volume(p_delivery_index),1) < 0 ) THEN

Line 3419: raise fnd_api.g_exc_error;

3415: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_del_total_volume));
3416: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_delivery_index);
3417: fnd_msg_pub.add;
3418:
3419: raise fnd_api.g_exc_error;
3420: END IF;
3421:
3422:
3423: --If weigh UOM given the weight is requried, vice-versa

Line 3436: raise fnd_api.g_exc_error;

3432: END IF;
3433: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_delivery_index);
3434: fnd_msg_pub.add;
3435:
3436: raise fnd_api.g_exc_error;
3437: END IF;
3438:
3439: --If volume UOM given the volume is requried, vice-versa
3440: IF ((p_delivery.total_volume(p_delivery_index) IS NOT NULL and p_delivery.volume_uom(p_delivery_index) IS NULL)

Line 3453: raise fnd_api.g_exc_error;

3449:
3450: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_delivery_index);
3451: fnd_msg_pub.add;
3452:
3453: raise fnd_api.g_exc_error;
3454: END IF;
3455:
3456:
3457: --Create/Update Ship location ,party and contacts information.

Line 3499: WHEN FND_API.G_EXC_ERROR THEN

3495: IF l_debug_on THEN
3496: WSH_DEBUG_SV.pop(l_module_name);
3497: END IF;
3498: EXCEPTION
3499: WHEN FND_API.G_EXC_ERROR THEN
3500: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3501:
3502: p_delivery.error_flag(p_delivery_index):= 'Y';
3503:

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

3502: p_delivery.error_flag(p_delivery_index):= 'Y';
3503:
3504:
3505: IF l_debug_on THEN
3506: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3507: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3508: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3509: END IF;
3510:

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

3504:
3505: IF l_debug_on THEN
3506: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3507: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3508: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3509: END IF;
3510:
3511: WHEN OTHERS THEN
3512: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3621: WHEN FND_API.G_EXC_ERROR THEN

3617: IF l_debug_on THEN
3618: WSH_DEBUG_SV.pop(l_module_name);
3619: END IF;
3620: EXCEPTION
3621: WHEN FND_API.G_EXC_ERROR THEN
3622: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3623:
3624: p_delivery.error_flag(p_delivery_index):= 'Y';
3625:

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

3624: p_delivery.error_flag(p_delivery_index):= 'Y';
3625:
3626:
3627: IF l_debug_on THEN
3628: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3629: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3631: END IF;
3632:

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

3626:
3627: IF l_debug_on THEN
3628: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3629: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3631: END IF;
3632:
3633: WHEN OTHERS THEN
3634: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3963: WHEN FND_API.G_EXC_ERROR THEN

3959: WSH_DEBUG_SV.log(l_module_name,'x_new_detail_ids.count',x_new_detail_ids.count);
3960: WSH_DEBUG_SV.pop(l_module_name);
3961: END IF;
3962: EXCEPTION
3963: WHEN FND_API.G_EXC_ERROR THEN
3964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3965:
3966: IF l_debug_on THEN
3967: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has

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

3963: WHEN FND_API.G_EXC_ERROR THEN
3964: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
3965:
3966: IF l_debug_on THEN
3967: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3968: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3969: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3970: END IF;
3971:

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

3965:
3966: IF l_debug_on THEN
3967: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
3968: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3969: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3970: END IF;
3971:
3972: WHEN OTHERS THEN
3973: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4056: raise fnd_api.g_exc_error;

4052: --Unassigned allowed only lines are released status 'X' i.e. Inbound open lines.
4053: IF (del_rec.released_status <> 'X' ) THEN
4054: FND_MESSAGE.SET_NAME('WSH','WSH_RR_UNASSIGN_DET_ERROR');
4055: fnd_msg_pub.add;
4056: raise fnd_api.g_exc_error;
4057: END IF;
4058: l_detail_ids(l_detail_ids.count + 1):= del_rec.delivery_detail_id;
4059:
4060:

Line 4118: WHEN FND_API.G_EXC_ERROR THEN

4114: IF l_debug_on THEN
4115: WSH_DEBUG_SV.pop(l_module_name);
4116: END IF;
4117: EXCEPTION
4118: WHEN FND_API.G_EXC_ERROR THEN
4119: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
4120:
4121: IF l_debug_on THEN
4122: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has

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

4118: WHEN FND_API.G_EXC_ERROR THEN
4119: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
4120:
4121: IF l_debug_on THEN
4122: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4123: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4124: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4125: END IF;
4126:

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

4120:
4121: IF l_debug_on THEN
4122: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4123: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4124: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4125: END IF;
4126:
4127: WHEN OTHERS THEN
4128: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4248: p_init_msg_list => FND_API.G_FALSE,

4244: l_dd_action_prms.action_code := 'AUTOCREATE-DEL';
4245:
4246: WSH_INTERFACE_GRP.Delivery_Detail_Action (
4247: p_api_version_number => 1.0,
4248: p_init_msg_list => FND_API.G_FALSE,
4249: p_commit => FND_API.G_FALSE,
4250: x_return_status => l_return_status,
4251: x_msg_count => l_msg_count,
4252: x_msg_data => l_msg_data,

Line 4249: p_commit => FND_API.G_FALSE,

4245:
4246: WSH_INTERFACE_GRP.Delivery_Detail_Action (
4247: p_api_version_number => 1.0,
4248: p_init_msg_list => FND_API.G_FALSE,
4249: p_commit => FND_API.G_FALSE,
4250: x_return_status => l_return_status,
4251: x_msg_count => l_msg_count,
4252: x_msg_data => l_msg_data,
4253: p_detail_id_tab => p_detail_ids,

Line 4302: raise fnd_api.g_exc_error;

4298: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM', l_del_info.source_line_number);
4299: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM', l_del_info.po_shipment_line_number);
4300: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_del_info.source_blanket_reference_num);
4301: fnd_msg_pub.add;
4302: raise fnd_api.g_exc_error;
4303: ELSE
4304: x_new_deliveries(1):=l_del_info.delivery_id;
4305: END IF;
4306: l_prev_delivery_id:=l_del_info.delivery_id;

Line 4342: raise fnd_api.g_exc_error;

4338: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_del_info.source_blanket_reference_num);
4339: fnd_msg_pub.add;
4340: END LOOP;
4341:
4342: raise fnd_api.g_exc_error;
4343: END IF;
4344:
4345: ELSE
4346: raise fnd_api.g_exc_error;

Line 4346: raise fnd_api.g_exc_error;

4342: raise fnd_api.g_exc_error;
4343: END IF;
4344:
4345: ELSE
4346: raise fnd_api.g_exc_error;
4347: END IF;
4348:
4349:
4350: --Plan the newly created delivery.

Line 4471: WHEN FND_API.G_EXC_ERROR THEN

4467: IF l_debug_on THEN
4468: WSH_DEBUG_SV.pop(l_module_name);
4469: END IF;
4470: EXCEPTION
4471: WHEN FND_API.G_EXC_ERROR THEN
4472: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
4473:
4474: p_delivery.error_flag(p_delivery_index):= 'Y';
4475:

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

4473:
4474: p_delivery.error_flag(p_delivery_index):= 'Y';
4475:
4476: IF l_debug_on THEN
4477: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4478: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4479: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4480: END IF;
4481:

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

4475:
4476: IF l_debug_on THEN
4477: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4478: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4479: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4480: END IF;
4481:
4482: WHEN OTHERS THEN
4483: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4572: raise fnd_api.g_exc_error;

4568: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');
4569: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_request_revision));
4570: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',p_line_number);
4571: fnd_msg_pub.add;
4572: raise fnd_api.g_exc_error;
4573: END IF;
4574:
4575:
4576: --Validate and create Supplier information.

Line 4612: raise fnd_api.g_exc_error;

4608: FND_MESSAGE.SET_TOKEN('C_REV_NUM', p_request_revision);
4609: FND_MESSAGE.SET_TOKEN('P_REV_NUM', l_revision_number);
4610: fnd_msg_pub.add;
4611:
4612: raise fnd_api.g_exc_error;
4613: END IF;
4614:
4615: --Unassign the lines from delivery, since every
4616: --revision is replacement of another.

Line 4669: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

4671:
4672: IF l_debug_on THEN
4673: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4674: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4675: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4676: END IF;
4677:
4678: IF ( get_revision_number_csr%ISOPEN) THEN
4679: CLOSE get_revision_number_csr;

Line 4754: raise fnd_api.g_exc_error;

4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.log(l_module_name,'x_org_id',x_org_id);
4752: END IF;
4753: IF (x_org_id is NULL) THEN
4754: raise fnd_api.g_exc_error;
4755: END IF;
4756:
4757:
4758: IF l_debug_on THEN

Line 4762: WHEN FND_API.G_EXC_ERROR THEN

4758: IF l_debug_on THEN
4759: WSH_DEBUG_SV.pop(l_module_name);
4760: END IF;
4761: EXCEPTION
4762: WHEN FND_API.G_EXC_ERROR THEN
4763: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
4764:
4765: IF l_debug_on THEN
4766: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has

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

4762: WHEN FND_API.G_EXC_ERROR THEN
4763: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
4764:
4765: IF l_debug_on THEN
4766: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4767: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4768: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4769: END IF;
4770:

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

4764:
4765: IF l_debug_on THEN
4766: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
4767: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4768: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4769: END IF;
4770:
4771: FND_MESSAGE.SET_NAME('WSH','WSH_OI_INVALID_ORG');
4772: fnd_msg_pub.add;

Line 4991: raise FND_API.G_EXC_ERROR;

4987: --Error if any one of header,delivery or line record has no data.
4988: IF (p_header.supplier_name.count <> 1 OR p_delivery.ship_from_address1.count < 1 OR p_line.po_header_number.count < 1) THEN
4989: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INV_FILE_FORMAT');
4990: fnd_msg_pub.add;
4991: raise FND_API.G_EXC_ERROR;
4992: END IF;
4993:
4994: l_header_index := p_header.supplier_name.first;
4995: WHILE (l_header_index IS NOT NULL) LOOP --{ Header Loop

Line 5006: raise FND_API.G_EXC_ERROR;

5002:
5003:
5004: -- Hedaer is invalid ,ignore remaining lines
5005: IF ( p_header.error_flag(l_header_index) = 'Y' ) THEN
5006: raise FND_API.G_EXC_ERROR;
5007: END IF;
5008:
5009:
5010: --Call api to handle header level validation.

Line 5184: raise FND_API.G_EXC_ERROR;

5180: IF (p_line.item_quantity(l_line_index) = 0 AND l_detail_att.prev_routing_req_id is NULL) THEN
5181: FND_MESSAGE.SET_NAME('WSH','WSH_RR_INVALID_CORRECTION');
5182: fnd_msg_pub.add;
5183:
5184: raise FND_API.G_EXC_ERROR;
5185: END IF;
5186:
5187: --Validate Operation Unit
5188: Validate_Org(

Line 5247: raise FND_API.G_EXC_ERROR;

5243: (l_po_info.source_blanket_reference_id IS NULL
5244: AND p_line.po_release_number(l_line_index) IS NOT NULL)
5245: ) THEN
5246:
5247: raise FND_API.G_EXC_ERROR;
5248: END IF;
5249:
5250:
5251: --Validate the PO for correct status.

Line 5337: raise FND_API.G_EXC_ERROR;

5333: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_BUYER_PO');
5334: FND_MESSAGE.SET_TOKEN('PO_NUMBER', p_line.po_header_number(l_line_index));
5335: fnd_msg_pub.add;
5336:
5337: raise FND_API.G_EXC_ERROR;
5338: END IF;
5339:
5340: IF ( (l_po_not_found_detail.source_blanket_reference_id IS NOT NULL
5341: AND p_line.po_release_number(l_line_index) IS NULL)

Line 5346: raise FND_API.G_EXC_ERROR;

5342: OR
5343: (l_po_not_found_detail.source_blanket_reference_id IS NULL
5344: AND p_line.po_release_number(l_line_index) IS NOT NULL)
5345: ) THEN
5346: raise FND_API.G_EXC_ERROR;
5347: END IF;
5348:
5349: --PO line found, validate for correct PO status.
5350: Validate_PO(

Line 5410: raise FND_API.G_EXC_ERROR;

5406: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_line.po_line_number(l_line_index));
5407: FND_MESSAGE.SET_TOKEN('SHIP_NUMBER', p_line.po_shipment_number(l_line_index));
5408: FND_MESSAGE.SET_TOKEN('OP_UNIT', p_line.po_operating_unit(l_line_index));
5409: fnd_msg_pub.add;
5410: raise FND_API.G_EXC_ERROR;
5411: END IF;
5412:
5413: CLOSE get_po_not_found_detail;
5414: END IF; --}

Line 5497: raise FND_API.G_EXC_ERROR;

5493: x_num_warnings => l_num_warnings,
5494: x_num_errors => l_num_errors);
5495:
5496: IF (l_new_detail_ids.count > 1) THEN
5497: raise FND_API.G_EXC_ERROR;
5498: END IF;
5499:
5500:
5501: EXCEPTION

Line 5502: WHEN FND_API.G_EXC_ERROR THEN

5498: END IF;
5499:
5500:
5501: EXCEPTION
5502: WHEN FND_API.G_EXC_ERROR THEN
5503: IF l_debug_on THEN
5504: WSH_DEBUG_SV.log(l_module_name,'Line e_line_error :',l_return_status);
5505: END IF;
5506:

Line 5675: WHEN FND_API.G_EXC_ERROR THEN

5671: END LOOP; --} Line Loop
5672:
5673:
5674: EXCEPTION
5675: WHEN FND_API.G_EXC_ERROR THEN
5676: IF l_debug_on THEN
5677: WSH_DEBUG_SV.log(l_module_name,'Header error: ',l_return_status);
5678: END IF;
5679:

Line 5722: raise FND_API.G_EXC_ERROR;

5718: END IF;
5719:
5720: IF (l_header_error >= p_header.supplier_name.count) THEN
5721: --All header records are error.
5722: raise FND_API.G_EXC_ERROR;
5723: ELSIF (l_header_error < p_header.supplier_name.count and l_header_error > 0 ) THEN
5724: --Error header record is grater than one and less the total header records.
5725: raise wsh_util_core.g_exc_warning;
5726: END IF;

Line 5740: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

5742:
5743: IF l_debug_on THEN
5744: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
5745: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5746: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5747: END IF;
5748:
5749: WHEN wsh_util_core.g_exc_warning THEN
5750: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING ;

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

5751:
5752: IF l_debug_on THEN
5753: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.g_exc_warning
5754: exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5755: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5756: END IF;
5757:
5758:
5759: WHEN OTHERS THEN

Line 5877: raise FND_API.G_EXC_ERROR;

5873: END IF;
5874:
5875:
5876: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
5877: raise FND_API.G_EXC_ERROR;
5878: END IF;
5879:
5880: WHILE (l_index IS NOT NULL ) LOOP --{
5881: g_file_line_number := p_file_fields.file_line_number(l_index);

Line 6257: WHEN FND_API.G_EXC_ERROR THEN

6253: WSH_DEBUG_SV.pop(l_module_name);
6254: END IF;
6255:
6256: EXCEPTION
6257: WHEN FND_API.G_EXC_ERROR THEN
6258: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
6259: --
6260: -- Start code for Bugfix 4070732
6261: --

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

6285: --
6286: -- End of Code Bugfix 4070732
6287: --
6288: IF l_debug_on THEN
6289: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
6290: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6291: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6292: END IF;
6293:

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

6287: --
6288: IF l_debug_on THEN
6289: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has
6290: occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
6291: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
6292: END IF;
6293:
6294: WHEN OTHERS THEN
6295: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;