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_ROUTING_REQUEST dependencies on FND_MSG_PUB

Line 164: fnd_msg_pub.add;

160: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
161: END IF;
162: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
163: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
164: fnd_msg_pub.add;
165:
166: END Create_Address_Record;
167:
168:

Line 231: fnd_msg_pub.add;

227: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
228: END IF;
229: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
230: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
231: fnd_msg_pub.add;
232:
233: END Create_Line_Record;
234:
235:

Line 304: fnd_msg_pub.add;

300: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
301: END IF;
302: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
303: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
304: fnd_msg_pub.add;
305:
306: END Create_Delivery_Record;
307:
308:

Line 362: fnd_msg_pub.add;

358: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
359: END IF;
360: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
361: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
362: fnd_msg_pub.add;
363:
364: END Create_Header_Record;
365:
366:

Line 447: fnd_msg_pub.add;

443: END IF;
444:
445: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
446: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
447: fnd_msg_pub.add;
448:
449: END Is_All_Line_Error;
450:
451:

Line 509: fnd_msg_pub.add;

505: END IF;
506:
507: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
508: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
509: fnd_msg_pub.add;
510:
511: raise ;
512: END set_message;
513:

Line 584: fnd_msg_pub.add;

580: END IF;
581:
582: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
583: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
584: fnd_msg_pub.add;
585:
586: raise ;
587: END add_time_to_date;
588:

Line 623: WSH_DEBUG_SV.log(l_module_name,'Message Count:',FND_MSG_PUB.Count_Msg);

619: END IF;
620:
621:
622: IF l_debug_on THEN
623: WSH_DEBUG_SV.log(l_module_name,'Message Count:',FND_MSG_PUB.Count_Msg);
624: END IF;
625:
626:
627: IF (FND_MSG_PUB.Count_Msg > 0 ) THEN

Line 627: IF (FND_MSG_PUB.Count_Msg > 0 ) THEN

623: WSH_DEBUG_SV.log(l_module_name,'Message Count:',FND_MSG_PUB.Count_Msg);
624: END IF;
625:
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

Line 629: FOR i IN 1..FND_MSG_PUB.Count_Msg LOOP

625:
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;

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 642: FND_MSG_PUB.initialize;

638: END IF;
639:
640: --Since message are collect from FND stack ,initialized the stack to avoid
641: --duplicate message being collected.
642: FND_MSG_PUB.initialize;
643:
644: IF l_debug_on THEN
645: WSH_DEBUG_SV.log(l_module_name,'After Init Message
646: Count:',FND_MSG_PUB.Count_Msg);

Line 646: Count:',FND_MSG_PUB.Count_Msg);

642: FND_MSG_PUB.initialize;
643:
644: IF l_debug_on THEN
645: WSH_DEBUG_SV.log(l_module_name,'After Init Message
646: Count:',FND_MSG_PUB.Count_Msg);
647: END IF;
648: IF l_debug_on THEN
649: WSH_DEBUG_SV.pop(l_module_name);
650: END IF;

Line 899: fnd_msg_pub.add;

895: END IF;
896:
897: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
898: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
899: fnd_msg_pub.add;
900:
901: raise ;
902: END Init_Routing_Req_Validation;
903:

Line 1026: fnd_msg_pub.add;

1022: END IF;
1023:
1024: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1025: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1026: fnd_msg_pub.add;
1027:
1028: raise ;
1029: END Init_Supplier_Validation;
1030:

Line 1113: fnd_msg_pub.add;

1109: l_find_miss_column:= true;
1110: FND_MESSAGE.SET_NAME('WSH','WSH_RR_MISS_COLUMN');
1111: FND_MESSAGE.SET_TOKEN('COL_NAME',g_field.name(i));
1112: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',g_file_line_number);
1113: fnd_msg_pub.add;
1114: END IF;
1115: END IF;
1116:
1117: g_field.supplied(i):= 'N';

Line 1136: fnd_msg_pub.add;

1132: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1133: END IF;
1134: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1135: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1136: fnd_msg_pub.add;
1137:
1138: raise;
1139: END Find_Miss_Column;
1140:

Line 1192: fnd_msg_pub.add;

1188: THEN
1189: FND_MESSAGE.SET_NAME('WSH','WSH_RR_REQUIRED_FIELD_NULL');
1190: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(p_index));
1191: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',g_file_line_number);
1192: fnd_msg_pub.add;
1193:
1194: l_status := false;
1195: END IF;
1196: --vendor merge changes {

Line 1243: fnd_msg_pub.add;

1239:
1240: FND_MESSAGE.SET_NAME('WSH','WSH_RR_EXC_SIZE');
1241: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(p_index));
1242: FND_MESSAGE.SET_TOKEN('LINE_NUMBER',g_file_line_number);
1243: fnd_msg_pub.add;
1244:
1245: l_status := false;
1246: END IF;
1247:

Line 1274: fnd_msg_pub.add;

1270: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1271: END IF;
1272: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1273: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1274: fnd_msg_pub.add;
1275:
1276: RETURN false;
1277: END Is_field_valid;
1278:

Line 1473: fnd_msg_pub.add;

1469:
1470: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_INVALID_FIELD');
1471: FND_MESSAGE.SET_TOKEN('FIELD_NAME', p_col_name);
1472: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_index);
1473: fnd_msg_pub.add;
1474:
1475: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1476: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1477: fnd_msg_pub.add;

Line 1477: fnd_msg_pub.add;

1473: fnd_msg_pub.add;
1474:
1475: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1476: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1477: fnd_msg_pub.add;
1478:
1479:
1480: END Process_Address_Line;
1481:

Line 1908: fnd_msg_pub.add;

1904: END IF;
1905: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_INVALID_FIELD');
1906: FND_MESSAGE.SET_TOKEN('FIELD_NAME', p_col_name);
1907: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_index);
1908: fnd_msg_pub.add;
1909:
1910: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1911: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1912: fnd_msg_pub.add;

Line 1912: fnd_msg_pub.add;

1908: fnd_msg_pub.add;
1909:
1910: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1911: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1912: fnd_msg_pub.add;
1913:
1914:
1915: END Process_Line;
1916:

Line 2142: fnd_msg_pub.add;

2138: END IF;
2139: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_INVALID_FIELD');
2140: FND_MESSAGE.SET_TOKEN('FIELD_NAME', p_col_name);
2141: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_index);
2142: fnd_msg_pub.add;
2143:
2144: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2145: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2146: fnd_msg_pub.add;

Line 2146: fnd_msg_pub.add;

2142: fnd_msg_pub.add;
2143:
2144: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2145: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2146: fnd_msg_pub.add;
2147:
2148: END Process_Delivery;
2149:
2150:

Line 2248: fnd_msg_pub.add;

2244: END IF;
2245: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_INVALID_FIELD');
2246: FND_MESSAGE.SET_TOKEN('FIELD_NAME', p_col_name);
2247: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', p_index);
2248: fnd_msg_pub.add;
2249:
2250: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2251: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2252: fnd_msg_pub.add;

Line 2252: fnd_msg_pub.add;

2248: fnd_msg_pub.add;
2249:
2250: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2251: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2252: fnd_msg_pub.add;
2253:
2254: END Process_Header;
2255:
2256:

Line 2405: fnd_msg_pub.add;

2401: END IF;
2402:
2403: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2404: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2405: fnd_msg_pub.add;
2406:
2407: END Validate_UOM;
2408:
2409:

Line 2582: fnd_msg_pub.add;

2578: THEN
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:

Line 2657: fnd_msg_pub.add;

2653: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2654: END IF;
2655: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2656: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2657: fnd_msg_pub.add;
2658:
2659: END Process_Address;
2660:
2661:

Line 2827: fnd_msg_pub.add;

2823: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2824: END IF;
2825: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
2826: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
2827: fnd_msg_pub.add;
2828:
2829: END Create_PO;
2830:
2831:

Line 2940: fnd_msg_pub.add;

2936: nvl(l_po_status_rec.cancel_flag(l_index),'N') <> 'Y'
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.

Line 2947: fnd_msg_pub.add;

2943:
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.

Line 2954: fnd_msg_pub.add;

2950:
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.

Line 2961: fnd_msg_pub.add;

2957:
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);

Line 3002: fnd_msg_pub.add;

2998: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2999: END IF;
3000: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
3001: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
3002: fnd_msg_pub.add;
3003:
3004: END Validate_PO;
3005:
3006: -- Start of comments

Line 3098: fnd_msg_pub.add;

3094: IF (p_line.earliest_pickup_date(p_line_index) IS NULL and
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);

Line 3112: fnd_msg_pub.add;

3108:
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;

Line 3123: fnd_msg_pub.add;

3119: IF (p_line.Item_quantity(p_line_index) < 0 ) THEN
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.

Line 3132: fnd_msg_pub.add;

3128: IF (nvl(p_line.weight(p_line_index),1) < 0 ) THEN
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:

Line 3142: fnd_msg_pub.add;

3138: IF (nvl(p_line.volume(p_line_index),1) < 0 ) THEN
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:

Line 3159: fnd_msg_pub.add;

3155: ELSE
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.

Line 3175: fnd_msg_pub.add;

3171: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_volume_uom));
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);

Line 3193: fnd_msg_pub.add;

3189: OPEN get_item_uom(p_line.item_uom(p_line_index));
3190: FETCH get_item_uom INTO l_tmp;
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;

Line 3341: fnd_msg_pub.add;

3337: END IF;
3338:
3339: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
3340: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
3341: fnd_msg_pub.add;
3342:
3343: END Validate_line;
3344:
3345:

Line 3398: fnd_msg_pub.add;

3394: IF (nvl(p_delivery.Number_of_containers(p_delivery_index),1) < 0 ) THEN
3395: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');
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:

Line 3407: fnd_msg_pub.add;

3403: IF (nvl(p_delivery.total_weight(p_delivery_index),1) < 0 ) THEN
3404: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');
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:

Line 3417: fnd_msg_pub.add;

3413: IF (nvl(p_delivery.total_volume(p_delivery_index),1) < 0 ) THEN
3414: FND_MESSAGE.SET_NAME('WSH','WSH_RR_NO_NEG_NUM');
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:

Line 3434: fnd_msg_pub.add;

3430: ELSE
3431: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_del_weight_uom));
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:

Line 3451: fnd_msg_pub.add;

3447: FND_MESSAGE.SET_TOKEN('FIELD_NAME',g_field.name(c_del_volume_uom));
3448: END IF;
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:

Line 3526: fnd_msg_pub.add;

3522: END IF;
3523:
3524: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
3525: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
3526: fnd_msg_pub.add;
3527:
3528: END Validate_Delivery;
3529:
3530:

Line 3648: fnd_msg_pub.add;

3644: END IF;
3645:
3646: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
3647: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
3648: fnd_msg_pub.add;
3649:
3650: END Validate_Delivery_uom;
3651:
3652:

Line 3985: fnd_msg_pub.add;

3981: END IF;
3982:
3983: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
3984: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
3985: fnd_msg_pub.add;
3986:
3987: END Update_Split_Details;
3988:
3989:

Line 4055: fnd_msg_pub.add;

4051:
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:

Line 4141: fnd_msg_pub.add;

4137:
4138:
4139: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
4140: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
4141: fnd_msg_pub.add;
4142:
4143: END UnAssign_Details;
4144:
4145:

Line 4301: fnd_msg_pub.add;

4297: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_del_info.source_header_number);
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;

Line 4339: fnd_msg_pub.add;

4335: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_del_info.source_header_number);
4336: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM', l_del_info.source_line_number);
4337: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM', l_del_info.po_shipment_line_number);
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;

Line 4497: fnd_msg_pub.add;

4493: END IF;
4494:
4495: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
4496: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
4497: fnd_msg_pub.add;
4498:
4499: END Create_Delivery;
4500:
4501:

Line 4571: fnd_msg_pub.add;

4567: IF (p_request_revision < 0 ) THEN
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:

Line 4610: fnd_msg_pub.add;

4606: IF (p_request_revision <= nvl(l_revision_number,-99) ) THEN
4607: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_INVALID_REVISION');
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:

Line 4699: fnd_msg_pub.add;

4695: END IF;
4696:
4697: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
4698: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
4699: fnd_msg_pub.add;
4700:
4701: END Validate_Header;
4702:
4703:

Line 4772: fnd_msg_pub.add;

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;
4773:
4774: WHEN OTHERS THEN
4775: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4776:

Line 4787: fnd_msg_pub.add;

4783: END IF;
4784:
4785: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
4786: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
4787: fnd_msg_pub.add;
4788:
4789:
4790: END validate_org;
4791:

Line 4990: fnd_msg_pub.add;

4986:
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;

Line 5048: WSH_DEBUG_SV.log(l_module_name,'Message Count :',FND_MSG_PUB.Count_Msg);

5044: WSH_DEBUG_SV.log(l_module_name,'l_prev_delivery_index',l_prev_delivery_index);
5045: WSH_DEBUG_SV.log(l_module_name,'p_delivery.error_flag',p_delivery.error_flag(l_delivery_index));
5046: WSH_DEBUG_SV.log(l_module_name,'p_line.item_quantity',p_line.item_quantity(l_line_index));
5047: WSH_DEBUG_SV.log(l_module_name,'prev_routing_req_id',l_detail_att.prev_routing_req_id);
5048: WSH_DEBUG_SV.log(l_module_name,'Message Count :',FND_MSG_PUB.Count_Msg);
5049: END IF;
5050:
5051: l_new_detail_ids.delete;
5052:

Line 5085: fnd_msg_pub.add;

5081: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
5082: l_warn_count:=l_warn_count + 1;
5083: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_WARN');
5084: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5085: fnd_msg_pub.add;
5086: ELSE
5087: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_SUCCESS');
5088: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5089: END IF;

Line 5096: fnd_msg_pub.add;

5092: l_warn_count:=l_warn_count + 1;
5093: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_WARN');
5094: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5095: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5096: fnd_msg_pub.add;
5097: ELSE
5098: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_SUCCESS');
5099: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5100: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);

Line 5117: fnd_msg_pub.add;

5113: ELSE
5114: p_delivery.error_flag(l_prev_delivery_index):='Y';
5115: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
5116: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5117: fnd_msg_pub.add;
5118:
5119: IF l_debug_on THEN
5120: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery Rollback to save point l_delivery_savepoint');
5121: END IF;

Line 5182: fnd_msg_pub.add;

5178: -- First Routing Request should not be correction.
5179: -- A correction is routing request line with zero quantity.
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:

Line 5335: fnd_msg_pub.add;

5331: IF (l_po_not_found_detail.shipping_control <> 'BUYER') THEN
5332: CLOSE get_po_not_found_detail;
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:

Line 5409: fnd_msg_pub.add;

5405: FND_MESSAGE.SET_TOKEN('REL_NUMBER', p_line.po_release_number(l_line_index));
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;

Line 5511: fnd_msg_pub.add;

5507: p_line.error_flag(l_line_index):='Y';
5508: p_delivery.error_flag(l_delivery_index):='Y';
5509: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
5510: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5511: fnd_msg_pub.add;
5512:
5513: IF (get_po_not_found_detail%ISOPEN) THEN
5514: CLOSE get_po_not_found_detail;
5515: END IF;

Line 5532: fnd_msg_pub.add;

5528: p_line.error_flag(l_line_index):='Y';
5529: p_delivery.error_flag(l_delivery_index):='Y';
5530:
5531: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_LINES_LOCKED');
5532: fnd_msg_pub.add;
5533:
5534: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
5535: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5536: fnd_msg_pub.add;

Line 5536: fnd_msg_pub.add;

5532: fnd_msg_pub.add;
5533:
5534: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
5535: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5536: fnd_msg_pub.add;
5537:
5538: IF (get_po_not_found_detail%ISOPEN) THEN
5539: CLOSE get_po_not_found_detail;
5540: END IF;

Line 5568: fnd_msg_pub.add;

5564: p_delivery.error_flag(l_delivery_index):='Y';
5565:
5566: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
5567: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
5568: fnd_msg_pub.add;
5569:
5570: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
5571: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5572: fnd_msg_pub.add;

Line 5572: fnd_msg_pub.add;

5568: fnd_msg_pub.add;
5569:
5570: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
5571: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5572: fnd_msg_pub.add;
5573: END;
5574:
5575:
5576: l_id := l_new_detail_ids.first;

Line 5619: fnd_msg_pub.add;

5615: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
5616: l_warn_count:=l_warn_count + 1;
5617: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_WARN');
5618: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5619: fnd_msg_pub.add;
5620: ELSE
5621: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_SUCCESS');
5622: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5623: END IF;

Line 5630: fnd_msg_pub.add;

5626: l_warn_count:=l_warn_count + 1;
5627: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_WARN');
5628: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5629: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5630: fnd_msg_pub.add;
5631: ELSE
5632: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_SUCCESS');
5633: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5634: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);

Line 5651: fnd_msg_pub.add;

5647: ELSE
5648: p_delivery.error_flag(l_delivery_index):='Y';
5649: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
5650: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5651: fnd_msg_pub.add;
5652:
5653: IF l_debug_on THEN
5654: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery Rollback to save point l_delivery_savepoint');
5655: END IF;

Line 5684: fnd_msg_pub.add;

5680: l_header_error := l_header_error + 1;
5681: p_header.error_flag(l_header_index):='Y';
5682: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_HEADER_FAILED');
5683: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_header_index);
5684: fnd_msg_pub.add;
5685:
5686:
5687: WHEN others THEN
5688: IF l_debug_on THEN

Line 5696: fnd_msg_pub.add;

5692: p_header.error_flag(l_header_index):='Y';
5693:
5694: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
5695: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
5696: fnd_msg_pub.add;
5697:
5698: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_HEADER_FAILED');
5699: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_header_index);
5700: fnd_msg_pub.add;

Line 5700: fnd_msg_pub.add;

5696: fnd_msg_pub.add;
5697:
5698: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_HEADER_FAILED');
5699: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_header_index);
5700: fnd_msg_pub.add;
5701:
5702: END;
5703:
5704: l_header_index := p_header.supplier_name.next(l_header_index);

Line 5772: fnd_msg_pub.add;

5768: END IF;
5769:
5770: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
5771: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
5772: fnd_msg_pub.add;
5773:
5774: END Process_Routing_Request;
5775:
5776:

Line 5924: fnd_msg_pub.add;

5920: IF (l_prev_level_number = 1) THEN
5921: IF ( l_header.error_flag(l_prev_line_number)='Y') THEN
5922: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_HEADER_FAILED');
5923: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_line_number);
5924: fnd_msg_pub.add;
5925: END IF;
5926: ELSIF (l_prev_level_number = 2) THEN
5927: IF (l_delivery.error_flag(l_prev_line_number)='Y') THEN
5928: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');

Line 5930: fnd_msg_pub.add;

5926: ELSIF (l_prev_level_number = 2) THEN
5927: IF (l_delivery.error_flag(l_prev_line_number)='Y') THEN
5928: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
5929: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_line_number);
5930: fnd_msg_pub.add;
5931: END IF;
5932: ELSIF (l_prev_level_number = 3) THEN
5933: IF (l_line.error_flag(l_prev_line_number)='Y') THEN
5934: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');

Line 5936: fnd_msg_pub.add;

5932: ELSIF (l_prev_level_number = 3) THEN
5933: IF (l_line.error_flag(l_prev_line_number)='Y') THEN
5934: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
5935: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line.delivery_line_number(l_prev_line_number));
5936: fnd_msg_pub.add;
5937: END IF;
5938: END IF;
5939:
5940: END IF; --}

Line 6020: fnd_msg_pub.add;

6016: IF (l_prev_level_number = 1) THEN
6017: IF ( l_header.error_flag(l_prev_line_number)='Y') THEN
6018: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_HEADER_FAILED');
6019: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_line_number);
6020: fnd_msg_pub.add;
6021: END IF;
6022: ELSIF (l_prev_level_number = 2) THEN
6023: IF (l_delivery.error_flag(l_prev_line_number)='Y') THEN
6024: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');

Line 6026: fnd_msg_pub.add;

6022: ELSIF (l_prev_level_number = 2) THEN
6023: IF (l_delivery.error_flag(l_prev_line_number)='Y') THEN
6024: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
6025: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_line_number);
6026: fnd_msg_pub.add;
6027: END IF;
6028: ELSIF (l_prev_level_number = 3) THEN
6029: IF (l_line.error_flag(l_prev_line_number)='Y') THEN
6030: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');

Line 6032: fnd_msg_pub.add;

6028: ELSIF (l_prev_level_number = 3) THEN
6029: IF (l_line.error_flag(l_prev_line_number)='Y') THEN
6030: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_DEL_ERROR');
6031: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_line.delivery_line_number(l_prev_line_number));
6032: fnd_msg_pub.add;
6033: END IF;
6034: END IF;
6035:
6036:

Line 6400: FND_MSG_PUB.Initialize;

6396: END IF;
6397:
6398: --Initialize error message and fnd message table.
6399: g_error_tbl.delete;
6400: FND_MSG_PUB.Initialize;
6401:
6402: --Colleted the input scalar parameter to record to facilities
6403: --passing as parameter between api's.
6404: l_in_param.caller:=p_caller;