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.INV_LOT_TRX_VALIDATION_PUB dependencies on FND_MSG_PUB

Line 44: fnd_msg_pub.ADD;

40: EXCEPTION
41: WHEN OTHERS
42: THEN
43: fnd_message.set_name ('WMS', 'WMS_INSTALL_CHK_ERROR');
44: fnd_msg_pub.ADD;
45: RAISE fnd_api.g_exc_unexpected_error;
46: END;
47:
48: SELECT wsm_enabled_flag

Line 64: fnd_msg_pub.ADD;

60: EXCEPTION
61: WHEN OTHERS
62: THEN
63: fnd_message.set_name ('WMS', 'WMS_INSTALL_CHK_ERROR');
64: fnd_msg_pub.ADD;
65: RAISE fnd_api.g_exc_unexpected_error;
66: END;
67:
68: x_return_status := fnd_api.g_ret_sts_success;

Line 69: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

65: RAISE fnd_api.g_exc_unexpected_error;
66: END;
67:
68: x_return_status := fnd_api.g_ret_sts_success;
69: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
70: EXCEPTION
71: WHEN NO_DATA_FOUND
72: THEN
73: fnd_message.set_name ('INV', 'INV_INVALID_ORG');

Line 74: fnd_msg_pub.ADD;

70: EXCEPTION
71: WHEN NO_DATA_FOUND
72: THEN
73: fnd_message.set_name ('INV', 'INV_INVALID_ORG');
74: fnd_msg_pub.ADD;
75: x_return_status := fnd_api.g_ret_sts_error;
76: fnd_msg_pub.count_and_get (p_count => x_msg_count
77: , p_data => x_msg_data);
78: WHEN fnd_api.g_exc_error

Line 76: fnd_msg_pub.count_and_get (p_count => x_msg_count

72: THEN
73: fnd_message.set_name ('INV', 'INV_INVALID_ORG');
74: fnd_msg_pub.ADD;
75: x_return_status := fnd_api.g_ret_sts_error;
76: fnd_msg_pub.count_and_get (p_count => x_msg_count
77: , p_data => x_msg_data);
78: WHEN fnd_api.g_exc_error
79: THEN
80: x_return_status := fnd_api.g_ret_sts_error;

Line 81: fnd_msg_pub.count_and_get (p_count => x_msg_count

77: , p_data => x_msg_data);
78: WHEN fnd_api.g_exc_error
79: THEN
80: x_return_status := fnd_api.g_ret_sts_error;
81: fnd_msg_pub.count_and_get (p_count => x_msg_count
82: , p_data => x_msg_data);
83: WHEN fnd_api.g_exc_unexpected_error
84: THEN
85: x_return_status := fnd_api.g_ret_sts_error;

Line 86: fnd_msg_pub.count_and_get (p_count => x_msg_count

82: , p_data => x_msg_data);
83: WHEN fnd_api.g_exc_unexpected_error
84: THEN
85: x_return_status := fnd_api.g_ret_sts_error;
86: fnd_msg_pub.count_and_get (p_count => x_msg_count
87: , p_data => x_msg_data);
88: WHEN OTHERS
89: THEN
90: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 92: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

88: WHEN OTHERS
89: THEN
90: x_return_status := fnd_api.g_ret_sts_unexp_error;
91:
92: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
93: THEN
94: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Get_Org_info');
95: END IF;
96:

Line 94: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Get_Org_info');

90: x_return_status := fnd_api.g_ret_sts_unexp_error;
91:
92: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
93: THEN
94: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Get_Org_info');
95: END IF;
96:
97: fnd_msg_pub.count_and_get (p_count => x_msg_count
98: , p_data => x_msg_data);

Line 97: fnd_msg_pub.count_and_get (p_count => x_msg_count

93: THEN
94: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Get_Org_info');
95: END IF;
96:
97: fnd_msg_pub.count_and_get (p_count => x_msg_count
98: , p_data => x_msg_data);
99: END get_org_info;
100:
101: /*********************************************************************************************

Line 229: fnd_msg_pub.ADD;

225: )
226: THEN
227: x_validation_status := 'N';
228: fnd_message.set_name ('INV', 'INV_MISSING_REQUIRED_PARAMETER');
229: fnd_msg_pub.ADD;
230: RAISE fnd_api.g_exc_error;
231: END IF;
232:
233: l_start_count := p_st_lot_num_tbl.COUNT;

Line 257: fnd_msg_pub.ADD;

253: print_debug ('INV_TOO_MANY_LOT_SPLIT', 'Validate_Lots');
254: END IF;
255:
256: fnd_message.set_name ('INV', 'INV_TOO_MANY_LOT_SPLIT');
257: fnd_msg_pub.ADD;
258: x_validation_status := 'N';
259: RAISE fnd_api.g_exc_error;
260: END IF;
261:

Line 268: fnd_msg_pub.ADD;

264: IF (p_st_quantity_tbl (1) <= p_rs_quantity_tbl (1))
265: THEN
266: -- means this is not a partial split.
267: fnd_message.set_name ('INV', 'INV_MIN_LOT_SPLIT');
268: fnd_msg_pub.ADD;
269: x_validation_status := 'N';
270: RAISE fnd_api.g_exc_error;
271: END IF;
272: END IF;

Line 279: fnd_msg_pub.ADD;

275: LOOP
276: IF (p_rs_org_id_tbl (i) <> p_st_org_id_tbl (1))
277: THEN
278: fnd_message.set_name ('INV', 'INV_LOT_TRX_DIFF_ORG');
279: fnd_msg_pub.ADD;
280: x_validation_status := 'N';
281: RAISE fnd_api.g_exc_error;
282: END IF;
283:

Line 287: fnd_msg_pub.ADD;

283:
284: IF (p_rs_item_id_tbl (i) <> p_st_item_id_tbl (1))
285: THEN
286: fnd_message.set_name ('INV', 'INV_LOT_TRX_DIFF_ITEM');
287: fnd_msg_pub.ADD;
288: x_validation_status := 'N';
289: RAISE fnd_api.g_exc_error;
290: END IF;
291:

Line 297: fnd_msg_pub.ADD;

293: NVL (p_rs_revision_tbl (1), 'NULL')
294: )
295: THEN
296: fnd_message.set_name ('INV', 'INV_LOT_TRX_DIFF_REVISION');
297: fnd_msg_pub.ADD;
298: x_validation_status := 'N';
299: RAISE fnd_api.g_exc_error;
300: END IF;
301:

Line 311: fnd_msg_pub.ADD;

307: )
308: )
309: THEN
310: fnd_message.set_name ('INV', 'INV_LOT_TRX_DIFF_LOT_EXP_DATE');
311: fnd_msg_pub.ADD;
312: x_validation_status := 'N';
313: RAISE fnd_api.g_exc_error;
314: END IF;
315: END LOOP;

Line 362: fnd_msg_pub.ADD;

358: THEN
359: IF (l_start_count > 1)
360: THEN
361: fnd_message.set_name ('INV', 'INV_MIN_START_LOT_TRANSLATE');
362: fnd_msg_pub.ADD;
363: x_validation_status := 'N';
364: RAISE fnd_api.g_exc_error;
365: END IF;
366:

Line 370: fnd_msg_pub.ADD;

366:
367: IF (l_result_count > 1)
368: THEN
369: fnd_message.set_name ('INV', 'INV_MIN_RESULT_LOT_TRANSLATE');
370: fnd_msg_pub.ADD;
371: x_validation_status := 'N';
372: RAISE fnd_api.g_exc_error;
373: END IF;
374:

Line 378: fnd_msg_pub.ADD;

374:
375: IF (p_rs_org_id_tbl (1) <> p_st_org_id_tbl (1))
376: THEN
377: fnd_message.set_name ('INV', 'INV_LOT_TRX_DIFF_ORG');
378: fnd_msg_pub.ADD;
379: x_validation_status := 'N';
380: RAISE fnd_api.g_exc_error;
381: END IF;
382:

Line 407: fnd_msg_pub.ADD;

403: OR l_st_serial_control_code <> l_rs_serial_control_code
404: )
405: THEN
406: fnd_message.set_name ('INV', 'INV_LOT_SERIAL_CODE_DIFF');
407: fnd_msg_pub.ADD;
408: x_validation_status := 'N';
409: RAISE fnd_api.g_exc_error;
410: END IF;
411: END IF;

Line 486: fnd_msg_pub.ADD;

482: THEN
483: IF (l_start_count < 2)
484: THEN
485: fnd_message.set_name ('INV', 'INV_MIN_START_LOT_MERGE');
486: fnd_msg_pub.ADD;
487: x_validation_status := 'N';
488: RAISE fnd_api.g_exc_error;
489: END IF;
490:

Line 494: fnd_msg_pub.ADD;

490:
491: IF (l_result_count > 1)
492: THEN
493: fnd_message.set_name ('INV', 'INV_MAX_RESULT_LOT_MERGE');
494: fnd_msg_pub.ADD;
495: x_validation_status := 'N';
496: RAISE fnd_api.g_exc_error;
497: END IF;
498:

Line 506: fnd_msg_pub.ADD;

502: THEN
503: IF (p_st_org_id_tbl (i) <> p_st_org_id_tbl (i + 1))
504: THEN
505: fnd_message.set_name ('INV', 'INV_LOT_TRX_DIFF_ORG');
506: fnd_msg_pub.ADD;
507: x_validation_status := 'N';
508: RAISE fnd_api.g_exc_error;
509: END IF;
510: END IF;

Line 515: fnd_msg_pub.ADD;

511:
512: IF (p_st_org_id_tbl (i) <> p_rs_org_id_tbl (1))
513: THEN
514: fnd_message.set_name ('INV', 'INV_LOT_TRX_DIFF_ORG');
515: fnd_msg_pub.ADD;
516: x_validation_status := 'N';
517: RAISE fnd_api.g_exc_error;
518: END IF;
519:

Line 525: fnd_msg_pub.ADD;

521: THEN
522: IF (p_st_item_id_tbl (i) <> p_st_item_id_tbl (i + 1))
523: THEN
524: fnd_message.set_name ('INV', 'INV_LOT_TRX_DIFF_ITEM');
525: fnd_msg_pub.ADD;
526: x_validation_status := 'N';
527: RAISE fnd_api.g_exc_error;
528: END IF;
529: END IF;

Line 534: fnd_msg_pub.ADD;

530:
531: IF (p_st_item_id_tbl (i) <> p_rs_item_id_tbl (1))
532: THEN
533: fnd_message.set_name ('INV', 'INV_LOT_TRX_DIFF_ITEM');
534: fnd_msg_pub.ADD;
535: x_validation_status := 'N';
536: RAISE fnd_api.g_exc_error;
537: END IF;
538:

Line 551: fnd_msg_pub.ADD;

547: print_debug ('Duplicate Lot', 'Validate_lots');
548: END IF;
549:
550: fnd_message.set_name ('INV', 'INV_DUPLICATE_LOT');
551: fnd_msg_pub.ADD;
552: x_validation_status := 'N';
553: RAISE fnd_api.g_exc_error;
554: END IF;
555: END IF;

Line 599: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

595: END IF;
596:
597: x_validation_status := 'Y';
598: x_return_status := fnd_api.g_ret_sts_success;
599: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
600: EXCEPTION
601: WHEN fnd_api.g_exc_error
602: THEN
603: x_validation_status := 'N';

Line 605: fnd_msg_pub.count_and_get (p_count => x_msg_count

601: WHEN fnd_api.g_exc_error
602: THEN
603: x_validation_status := 'N';
604: x_return_status := fnd_api.g_ret_sts_error;
605: fnd_msg_pub.count_and_get (p_count => x_msg_count
606: , p_data => x_msg_data);
607: WHEN fnd_api.g_exc_unexpected_error
608: THEN
609: x_validation_status := 'N';

Line 611: fnd_msg_pub.count_and_get (p_count => x_msg_count

607: WHEN fnd_api.g_exc_unexpected_error
608: THEN
609: x_validation_status := 'N';
610: x_return_status := fnd_api.g_ret_sts_unexp_error;
611: fnd_msg_pub.count_and_get (p_count => x_msg_count
612: , p_data => x_msg_data);
613: WHEN OTHERS
614: THEN
615: x_validation_status := 'N';

Line 618: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

614: THEN
615: x_validation_status := 'N';
616: x_return_status := fnd_api.g_ret_sts_unexp_error;
617:
618: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
619: THEN
620: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lots');
621: END IF;
622:

Line 620: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lots');

616: x_return_status := fnd_api.g_ret_sts_unexp_error;
617:
618: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
619: THEN
620: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lots');
621: END IF;
622:
623: fnd_msg_pub.count_and_get (p_count => x_msg_count
624: , p_data => x_msg_data);

Line 623: fnd_msg_pub.count_and_get (p_count => x_msg_count

619: THEN
620: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lots');
621: END IF;
622:
623: fnd_msg_pub.count_and_get (p_count => x_msg_count
624: , p_data => x_msg_data);
625: END validate_lots;
626:
627: /*********************************************************************************************

Line 691: fnd_msg_pub.ADD;

687: OR p_inventory_item_id IS NULL
688: )
689: THEN
690: fnd_message.set_name ('INV', 'INV_MISSING_REQUIRED_PARAMETER');
691: fnd_msg_pub.ADD;
692: RAISE fnd_api.g_exc_error;
693: END IF;
694:
695: IF (p_transaction_type_id = inv_globals.g_type_inv_lot_split)

Line 740: fnd_msg_pub.ADD;

736:
737: /* Bug:4405157. Modified the following message to be more specific to
738: Split transaction W.R.T Issue 15 of the bug*/
739: fnd_message.set_name ('INV', 'INV_INVALID_LOT_ITEM_LOT_SPLIT');
740: fnd_msg_pub.ADD;
741: RAISE fnd_api.g_exc_unexpected_error;
742: END;
743: END;
744: ELSIF (p_transaction_type_id = inv_globals.g_type_inv_lot_merge)

Line 789: fnd_msg_pub.ADD;

785:
786: /* Bug:4405157. Modified the following message to be more specific to
787: Merge transaction W.R.T Issue 15 of the bug*/
788: fnd_message.set_name ('INV', 'INV_INVALID_LOT_ITEM_LOT_MERGE');
789: fnd_msg_pub.ADD;
790: RAISE fnd_api.g_exc_unexpected_error;
791: END;
792: END;
793: ELSIF (p_transaction_type_id = inv_globals.g_type_inv_lot_translate)

Line 838: fnd_msg_pub.ADD;

834: END IF;
835: /* Bug:4405157. Modified the following message to be more specific to
836: Translate transaction W.R.T Issue 15 of the bug*/
837: fnd_message.set_name ('INV', 'INV_INVALID_LOT_ITEM_LOT_XLATE');
838: fnd_msg_pub.ADD;
839: RAISE fnd_api.g_exc_unexpected_error;
840: END;
841: END;
842: END IF;

Line 870: fnd_msg_pub.ADD;

866:
867: ELSE
868: fnd_message.set_name ('INV', 'INV_INVALID_LOT');
869: END IF;
870: fnd_msg_pub.ADD;
871: RAISE fnd_api.g_exc_error;
872: END IF;
873:
874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

870: fnd_msg_pub.ADD;
871: RAISE fnd_api.g_exc_error;
872: END IF;
873:
874: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
875: EXCEPTION
876: WHEN fnd_api.g_exc_error
877: THEN
878: x_validation_status := 'N';

Line 880: fnd_msg_pub.count_and_get (p_count => x_msg_count

876: WHEN fnd_api.g_exc_error
877: THEN
878: x_validation_status := 'N';
879: x_return_status := fnd_api.g_ret_sts_error;
880: fnd_msg_pub.count_and_get (p_count => x_msg_count
881: , p_data => x_msg_data);
882: WHEN fnd_api.g_exc_unexpected_error
883: THEN
884: x_validation_status := 'N';

Line 886: fnd_msg_pub.count_and_get (p_count => x_msg_count

882: WHEN fnd_api.g_exc_unexpected_error
883: THEN
884: x_validation_status := 'N';
885: x_return_status := fnd_api.g_ret_sts_unexp_error;
886: fnd_msg_pub.count_and_get (p_count => x_msg_count
887: , p_data => x_msg_data);
888: WHEN OTHERS
889: THEN
890: x_validation_status := 'N';

Line 893: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

889: THEN
890: x_validation_status := 'N';
891: x_return_status := fnd_api.g_ret_sts_unexp_error;
892:
893: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
894: THEN
895: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Start_Lot');
896: END IF;
897:

Line 895: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Start_Lot');

891: x_return_status := fnd_api.g_ret_sts_unexp_error;
892:
893: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
894: THEN
895: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Start_Lot');
896: END IF;
897:
898: fnd_msg_pub.count_and_get (p_count => x_msg_count
899: , p_data => x_msg_data);

Line 898: fnd_msg_pub.count_and_get (p_count => x_msg_count

894: THEN
895: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Start_Lot');
896: END IF;
897:
898: fnd_msg_pub.count_and_get (p_count => x_msg_count
899: , p_data => x_msg_data);
900: END validate_start_lot;
901:
902: /*********************************************************************************************

Line 981: fnd_msg_pub.ADD;

977: print_debug ('Missing Required Parameter', 'Validate_Result_Lot');
978: END IF;
979:
980: fnd_message.set_name ('INV', 'INV_MISSING_REQUIRED_PARAMETER');
981: fnd_msg_pub.ADD;
982: RAISE fnd_api.g_exc_error;
983: END IF;
984: /* Bug#4363274. This check is not required.
985: IF (p_transaction_type_id = inv_globals.g_type_inv_lot_merge)

Line 1006: fnd_msg_pub.ADD;

1002:
1003: IF (p_st_lot_num_tbl (i) = p_rs_lot_num_tbl (1))
1004: THEN
1005: fnd_message.set_name ('INV', 'INV_MERGELOT_USED');
1006: fnd_msg_pub.ADD;
1007: l_validation_status := 'N';
1008: RAISE fnd_api.g_exc_error;
1009: END IF;
1010: END LOOP;

Line 1023: fnd_msg_pub.ADD;

1019: EXCEPTION
1020: WHEN NO_DATA_FOUND
1021: THEN
1022: fnd_message.set_name ('INV', 'INV_INT_ORG_CODE');
1023: fnd_msg_pub.ADD;
1024: x_validation_status := 'N';
1025: RAISE fnd_api.g_exc_unexpected_error;
1026: END;
1027:

Line 1053: fnd_msg_pub.ADD;

1049: IF (l_lot_count > 0)
1050: THEN
1051: l_validation_status := 'N';
1052: fnd_message.set_name ('INV', 'INV_INT_LOTUNIQEXP');
1053: fnd_msg_pub.ADD;
1054: RAISE fnd_api.g_exc_error;
1055: ELSE
1056: l_validation_status := 'Y';
1057: END IF;

Line 1072: fnd_msg_pub.ADD;

1068: IF (l_lot_count > 0)
1069: THEN
1070: l_validation_status := 'N';
1071: fnd_message.set_name ('INV', 'INV_INT_LOTUNIQEXP');
1072: fnd_msg_pub.ADD;
1073: RAISE fnd_api.g_exc_error;
1074: ELSE
1075: l_validation_status := 'Y';
1076: END IF;

Line 1091: fnd_msg_pub.ADD;

1087: END IF;
1088:
1089: l_validation_status := 'N';
1090: fnd_message.set_name ('INV', 'INV_DUPLICATE_LOT');
1091: fnd_msg_pub.ADD;
1092: RAISE fnd_api.g_exc_error;
1093: END IF;
1094: END IF;
1095: END LOOP;

Line 1112: fnd_msg_pub.ADD;

1108: IF (l_lot_count > 0)
1109: THEN
1110: l_validation_status := 'N';
1111: fnd_message.set_name ('INV', 'INV_INT_LOTUNIQEXP');
1112: fnd_msg_pub.ADD;
1113: RAISE fnd_api.g_exc_error;
1114: ELSE
1115: l_validation_status := 'Y';
1116: END IF;

Line 1131: fnd_msg_pub.ADD;

1127: IF (l_lot_count > 0)
1128: THEN
1129: l_validation_status := 'N';
1130: fnd_message.set_name ('INV', 'INV_INT_LOTUNIQEXP');
1131: fnd_msg_pub.ADD;
1132: RAISE fnd_api.g_exc_error;
1133: ELSE
1134: l_validation_status := 'Y';
1135: END IF;

Line 1153: fnd_msg_pub.ADD;

1149: -- for lot merge, the resultant lot can be an existing item, but of the same item,
1150: -- cannot be from different items.
1151: l_validation_status := 'N';
1152: fnd_message.set_name ('INV', 'INV_INT_LOTUNIQEXP');
1153: fnd_msg_pub.ADD;
1154: RAISE fnd_api.g_exc_error;
1155: ELSE
1156: l_validation_status := 'Y';
1157: END IF;

Line 1172: fnd_msg_pub.ADD;

1168: IF (l_lot_count > 0)
1169: THEN
1170: l_validation_status := 'N';
1171: fnd_message.set_name ('INV', 'INV_INT_LOTUNIQEXP');
1172: fnd_msg_pub.ADD;
1173: RAISE fnd_api.g_exc_error;
1174: ELSE
1175: l_validation_status := 'Y';
1176: END IF;

Line 1196: fnd_msg_pub.ADD;

1192: IF (l_lot_count > 0)
1193: THEN
1194: l_validation_status := 'N';
1195: fnd_message.set_name ('INV', 'INV_LOT_EXISTS');
1196: fnd_msg_pub.ADD;
1197: RAISE fnd_api.g_exc_error;
1198: ELSE
1199: l_validation_status := 'Y';
1200: END IF;

Line 1213: fnd_msg_pub.ADD;

1209: IF l_lot_count > 0
1210: THEN
1211: l_validation_status := 'N';
1212: fnd_message.set_name ('INV', 'INV_LOT_EXISTS');
1213: fnd_msg_pub.ADD;
1214: RAISE fnd_api.g_exc_error;
1215: ELSE
1216: l_validation_status := 'Y';
1217: END IF;

Line 1232: fnd_msg_pub.ADD;

1228: IF l_lot_count > 0
1229: THEN
1230: l_validation_status := 'N';
1231: fnd_message.set_name ('INV', 'INV_LOT_EXISTS');
1232: fnd_msg_pub.ADD;
1233: RAISE fnd_api.g_exc_error;
1234: ELSE
1235: l_validation_status := 'Y';
1236: END IF;

Line 1251: fnd_msg_pub.ADD;

1247: END IF;
1248:
1249: l_validation_status := 'N';
1250: fnd_message.set_name ('INV', 'INV_DUPLICATE_LOT');
1251: fnd_msg_pub.ADD;
1252: RAISE fnd_api.g_exc_error;
1253: END IF;
1254: END IF;
1255: END LOOP;

Line 1282: fnd_msg_pub.ADD;

1278: IF (l_lot_count > 0)
1279: THEN
1280: l_validation_status := 'N';
1281: fnd_message.set_name ('INV', 'INV_LOT_EXISTS');
1282: fnd_msg_pub.ADD;
1283: RAISE fnd_api.g_exc_error;
1284: ELSE
1285: l_validation_status := 'Y';
1286: END IF;

Line 1298: fnd_msg_pub.ADD;

1294: IF l_lot_count > 0
1295: THEN
1296: l_validation_status := 'N';
1297: fnd_message.set_name ('INV', 'INV_LOT_EXISTS');
1298: fnd_msg_pub.ADD;
1299: RAISE fnd_api.g_exc_error;
1300: ELSE
1301: l_validation_status := 'Y';
1302: END IF;

Line 1317: fnd_msg_pub.ADD;

1313: IF l_lot_count > 0
1314: THEN
1315: l_validation_status := 'N';
1316: fnd_message.set_name ('INV', 'INV_LOT_EXISTS');
1317: fnd_msg_pub.ADD;
1318: RAISE fnd_api.g_exc_error;
1319: ELSE
1320: l_validation_status := 'Y';
1321: END IF;

Line 1344: FND_MSG_PUB.ADD;

1340: end loop;
1341:
1342: if( l_found = false ) then
1343: FND_MESSAGE.SET_NAME('INV', 'INV_DIFF_MERGE_ITEM');
1344: FND_MSG_PUB.ADD;
1345: l_validation_status := 'N';
1346: raise FND_API.G_EXC_ERROR;
1347: end if;
1348: IF (l_debug = 1) THEN

Line 1384: FND_MSG_PUB.ADD;

1380:
1381: IF l_lot_count = 0 Then
1382: l_validation_status := 'N';
1383: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_LOT');
1384: FND_MSG_PUB.ADD;
1385: raise FND_API.G_EXC_ERROR;
1386: else
1387: l_validation_status := 'Y';
1388: end if;

Line 1407: fnd_msg_pub.ADD;

1403:
1404: IF (x_validation_status <> 'Y')
1405: THEN
1406: fnd_message.set_name ('INV', 'INV_INVALID_LOT');
1407: fnd_msg_pub.ADD;
1408: RAISE fnd_api.g_exc_error;
1409: END IF;
1410:
1411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1407: fnd_msg_pub.ADD;
1408: RAISE fnd_api.g_exc_error;
1409: END IF;
1410:
1411: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1412: EXCEPTION
1413: WHEN fnd_api.g_exc_error
1414: THEN
1415: x_validation_status := l_validation_status;

Line 1417: fnd_msg_pub.count_and_get (p_count => x_msg_count

1413: WHEN fnd_api.g_exc_error
1414: THEN
1415: x_validation_status := l_validation_status;
1416: x_return_status := fnd_api.g_ret_sts_error;
1417: fnd_msg_pub.count_and_get (p_count => x_msg_count
1418: , p_data => x_msg_data);
1419: WHEN fnd_api.g_exc_unexpected_error
1420: THEN
1421: x_validation_status := l_validation_status;

Line 1423: fnd_msg_pub.count_and_get (p_count => x_msg_count

1419: WHEN fnd_api.g_exc_unexpected_error
1420: THEN
1421: x_validation_status := l_validation_status;
1422: x_return_status := fnd_api.g_ret_sts_unexp_error;
1423: fnd_msg_pub.count_and_get (p_count => x_msg_count
1424: , p_data => x_msg_data);
1425: WHEN OTHERS
1426: THEN
1427: x_validation_status := l_validation_status;

Line 1430: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1426: THEN
1427: x_validation_status := l_validation_status;
1428: x_return_status := fnd_api.g_ret_sts_unexp_error;
1429:
1430: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1431: THEN
1432: fnd_msg_pub.add_exc_msg (g_pkg_name
1433: , 'Validate_Result_Lot_Uniqueness');
1434: END IF;

Line 1432: fnd_msg_pub.add_exc_msg (g_pkg_name

1428: x_return_status := fnd_api.g_ret_sts_unexp_error;
1429:
1430: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1431: THEN
1432: fnd_msg_pub.add_exc_msg (g_pkg_name
1433: , 'Validate_Result_Lot_Uniqueness');
1434: END IF;
1435:
1436: fnd_msg_pub.count_and_get (p_count => x_msg_count

Line 1436: fnd_msg_pub.count_and_get (p_count => x_msg_count

1432: fnd_msg_pub.add_exc_msg (g_pkg_name
1433: , 'Validate_Result_Lot_Uniqueness');
1434: END IF;
1435:
1436: fnd_msg_pub.count_and_get (p_count => x_msg_count
1437: , p_data => x_msg_data);
1438: END validate_result_lot;
1439:
1440: /*********************************************************************************************

Line 1498: fnd_msg_pub.ADD;

1494: OR p_result_inv_item_id IS NULL
1495: )
1496: THEN
1497: fnd_message.set_name ('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1498: fnd_msg_pub.ADD;
1499: x_validation_status := 'N';
1500: RAISE fnd_api.g_exc_unexpected_error;
1501: END IF;
1502:

Line 1519: fnd_msg_pub.ADD;

1515: fnd_message.set_name ('INV', 'INV_ALREADY_EXISTS');
1516: fnd_message.set_token ('ENTITY'
1517: , fnd_message.get_string ('INV', 'LOT_NUMBER')
1518: );
1519: fnd_msg_pub.ADD;
1520: RAISE fnd_api.g_exc_error;
1521: ELSE
1522: x_validation_status := 'Y';
1523: END IF;

Line 1531: FND_MSG_PUB.ADD;

1527: else
1528: x_validation_status := 'N';
1529: FND_MESSAGE.SET_NAME('INV', 'INV_ALREADY_EXISTS');
1530: FND_MESSAGE.SET_TOKEN('ENTITY', FND_MESSAGE.get_String('INV', 'LOT_NUMBER'));
1531: FND_MSG_PUB.ADD;
1532: raise FND_API.G_EXC_ERROR;
1533: end if;*/
1534: x_validation_status := 'Y';
1535: END IF;

Line 1538: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1534: x_validation_status := 'Y';
1535: END IF;
1536:
1537: x_return_status := fnd_api.g_ret_sts_success;
1538: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1539: EXCEPTION
1540: WHEN fnd_api.g_exc_error
1541: THEN
1542: x_return_status := fnd_api.g_ret_sts_error;

Line 1543: fnd_msg_pub.count_and_get (p_count => x_msg_count

1539: EXCEPTION
1540: WHEN fnd_api.g_exc_error
1541: THEN
1542: x_return_status := fnd_api.g_ret_sts_error;
1543: fnd_msg_pub.count_and_get (p_count => x_msg_count
1544: , p_data => x_msg_data);
1545: WHEN fnd_api.g_exc_unexpected_error
1546: THEN
1547: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1548: fnd_msg_pub.count_and_get (p_count => x_msg_count

1544: , p_data => x_msg_data);
1545: WHEN fnd_api.g_exc_unexpected_error
1546: THEN
1547: x_return_status := fnd_api.g_ret_sts_unexp_error;
1548: fnd_msg_pub.count_and_get (p_count => x_msg_count
1549: , p_data => x_msg_data);
1550: WHEN OTHERS
1551: THEN
1552: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1554: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1550: WHEN OTHERS
1551: THEN
1552: x_return_status := fnd_api.g_ret_sts_unexp_error;
1553:
1554: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1555: THEN
1556: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lot_Translate');
1557: END IF;
1558:

Line 1556: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lot_Translate');

1552: x_return_status := fnd_api.g_ret_sts_unexp_error;
1553:
1554: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1555: THEN
1556: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lot_Translate');
1557: END IF;
1558:
1559: fnd_msg_pub.count_and_get (p_count => x_msg_count
1560: , p_data => x_msg_data);

Line 1559: fnd_msg_pub.count_and_get (p_count => x_msg_count

1555: THEN
1556: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lot_Translate');
1557: END IF;
1558:
1559: fnd_msg_pub.count_and_get (p_count => x_msg_count
1560: , p_data => x_msg_data);
1561: END validate_lot_translate;
1562:
1563:

Line 1610: fnd_msg_pub.ADD;

1606: END;
1607: IF(l_lpn_context <> 1) --does not resides in inventory
1608: THEN
1609: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
1610: fnd_msg_pub.ADD;
1611: IF (l_debug = 1) THEN
1612: print_debug('validate_lpn_info: Invalid LPN Context for FROM LPN' , 'validate_lpn_info');
1613: END IF;
1614: l_validation_status := 'N';

Line 1641: fnd_msg_pub.ADD;

1637: END;
1638: IF(l_lpn_context NOT IN (1,5)) --does not 'resides in inventory' and not 'defined but not used'
1639: THEN
1640: fnd_message.set_name('INV', 'INV_INVALID_LPN_CONTEXT');
1641: fnd_msg_pub.ADD;
1642: IF (l_debug = 1) THEN
1643: print_debug('validate_lpn_info: Invalid LPN Context for TO LPN', 'validate_lpn_info');
1644: END IF;
1645: l_validation_status := 'N';

Line 1655: fnd_msg_pub.ADD;

1651: OR
1652: (NVL(l_locator_id, -9999) <> NVL(p_rs_locator_id_tbl(i), -9999))
1653: ) THEN
1654: fnd_message.set_name('INV', 'INV_INT_LPN');
1655: fnd_msg_pub.ADD;
1656: IF (l_debug = 1) THEN
1657: print_debug('validate_lpn_info: Org/Sub/Loc of LPN does not match', 'validate_lpn_info');
1658: END IF;
1659: l_validation_status := 'N';

Line 1668: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1664: END LOOP;
1665:
1666: x_validation_status := 'Y';
1667: x_return_status := fnd_api.g_ret_sts_success;
1668: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1669: EXCEPTION
1670: WHEN fnd_api.g_exc_error
1671: THEN
1672: x_validation_status := l_validation_status;

Line 1674: fnd_msg_pub.count_and_get (p_count => x_msg_count

1670: WHEN fnd_api.g_exc_error
1671: THEN
1672: x_validation_status := l_validation_status;
1673: x_return_status := fnd_api.g_ret_sts_error;
1674: fnd_msg_pub.count_and_get (p_count => x_msg_count
1675: , p_data => x_msg_data);
1676: WHEN fnd_api.g_exc_unexpected_error
1677: THEN
1678: x_validation_status := l_validation_status;

Line 1680: fnd_msg_pub.count_and_get (p_count => x_msg_count

1676: WHEN fnd_api.g_exc_unexpected_error
1677: THEN
1678: x_validation_status := l_validation_status;
1679: x_return_status := fnd_api.g_ret_sts_unexp_error;
1680: fnd_msg_pub.count_and_get (p_count => x_msg_count
1681: , p_data => x_msg_data);
1682: WHEN OTHERS
1683: THEN
1684: x_validation_status := 'E';

Line 1687: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1683: THEN
1684: x_validation_status := 'E';
1685: x_return_status := fnd_api.g_ret_sts_unexp_error;
1686:
1687: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1688: THEN
1689: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lpn_Info');
1690: END IF;
1691:

Line 1689: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lpn_Info');

1685: x_return_status := fnd_api.g_ret_sts_unexp_error;
1686:
1687: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1688: THEN
1689: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lpn_Info');
1690: END IF;
1691:
1692: fnd_msg_pub.count_and_get (p_count => x_msg_count
1693: , p_data => x_msg_data);

Line 1692: fnd_msg_pub.count_and_get (p_count => x_msg_count

1688: THEN
1689: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Lpn_Info');
1690: END IF;
1691:
1692: fnd_msg_pub.count_and_get (p_count => x_msg_count
1693: , p_data => x_msg_data);
1694:
1695: END validate_lpn_info;
1696:

Line 1771: fnd_msg_pub.ADD;

1767: OR p_inventory_item_id IS NULL
1768: )
1769: THEN
1770: fnd_message.set_name ('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1771: fnd_msg_pub.ADD;
1772: x_validation_status := 'N';
1773: RAISE fnd_api.g_exc_error;
1774: END IF;
1775:

Line 1820: fnd_msg_pub.ADD;

1816: , 'CAPS_LOT_NUMBER'
1817: )
1818: , FALSE
1819: );
1820: fnd_msg_pub.ADD;
1821: x_validation_status := 'N';
1822: END;
1823: ELSE
1824: l_status_id := p_status_id;

Line 1873: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1869: END IF;
1870:
1871: x_validation_status := l_validation_status;
1872: x_return_status := fnd_api.g_ret_sts_success;
1873: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1874: EXCEPTION
1875: WHEN fnd_api.g_exc_error
1876: THEN
1877: x_return_status := fnd_api.g_ret_sts_error;

Line 1878: fnd_msg_pub.count_and_get (p_count => x_msg_count

1874: EXCEPTION
1875: WHEN fnd_api.g_exc_error
1876: THEN
1877: x_return_status := fnd_api.g_ret_sts_error;
1878: fnd_msg_pub.count_and_get (p_count => x_msg_count
1879: , p_data => x_msg_data);
1880: WHEN fnd_api.g_exc_unexpected_error
1881: THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1883: fnd_msg_pub.count_and_get (p_count => x_msg_count

1879: , p_data => x_msg_data);
1880: WHEN fnd_api.g_exc_unexpected_error
1881: THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: fnd_msg_pub.count_and_get (p_count => x_msg_count
1884: , p_data => x_msg_data);
1885: WHEN OTHERS
1886: THEN
1887: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1889: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

1885: WHEN OTHERS
1886: THEN
1887: x_return_status := fnd_api.g_ret_sts_unexp_error;
1888:
1889: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1890: THEN
1891: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Material_Status');
1892: END IF;
1893:

Line 1891: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Material_Status');

1887: x_return_status := fnd_api.g_ret_sts_unexp_error;
1888:
1889: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
1890: THEN
1891: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Material_Status');
1892: END IF;
1893:
1894: fnd_msg_pub.count_and_get (p_count => x_msg_count
1895: , p_data => x_msg_data);

Line 1894: fnd_msg_pub.count_and_get (p_count => x_msg_count

1890: THEN
1891: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Material_Status');
1892: END IF;
1893:
1894: fnd_msg_pub.count_and_get (p_count => x_msg_count
1895: , p_data => x_msg_data);
1896: END validate_material_status;
1897:
1898: /****************************************************************************

Line 1935: fnd_msg_pub.ADD;

1931: OR p_inventory_item_id IS NULL
1932: )
1933: THEN
1934: fnd_message.set_name ('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1935: fnd_msg_pub.ADD;
1936: x_validation_status := 'N';
1937: RAISE fnd_api.g_exc_error;
1938: END IF;
1939:

Line 1991: fnd_msg_pub.ADD;

1987: , 'CAPS_SERIAL_NUMBERS'
1988: )
1989: , FALSE
1990: );
1991: fnd_msg_pub.ADD;
1992: x_validation_status := 'N';
1993: END;
1994: ELSE
1995: l_status_id := p_status_id;

Line 2077: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2073: END IF;
2074:
2075: x_validation_status := l_validation_status;
2076: x_return_status := fnd_api.g_ret_sts_success;
2077: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2078: EXCEPTION
2079: WHEN fnd_api.g_exc_error
2080: THEN
2081: x_return_status := fnd_api.g_ret_sts_error;

Line 2082: fnd_msg_pub.count_and_get (p_count => x_msg_count

2078: EXCEPTION
2079: WHEN fnd_api.g_exc_error
2080: THEN
2081: x_return_status := fnd_api.g_ret_sts_error;
2082: fnd_msg_pub.count_and_get (p_count => x_msg_count
2083: , p_data => x_msg_data);
2084: WHEN fnd_api.g_exc_unexpected_error
2085: THEN
2086: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2087: fnd_msg_pub.count_and_get (p_count => x_msg_count

2083: , p_data => x_msg_data);
2084: WHEN fnd_api.g_exc_unexpected_error
2085: THEN
2086: x_return_status := fnd_api.g_ret_sts_unexp_error;
2087: fnd_msg_pub.count_and_get (p_count => x_msg_count
2088: , p_data => x_msg_data);
2089: WHEN OTHERS
2090: THEN
2091: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2093: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2089: WHEN OTHERS
2090: THEN
2091: x_return_status := fnd_api.g_ret_sts_unexp_error;
2092:
2093: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2094: THEN
2095: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Serial_Status');
2096: END IF;
2097:

Line 2095: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Serial_Status');

2091: x_return_status := fnd_api.g_ret_sts_unexp_error;
2092:
2093: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2094: THEN
2095: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Serial_Status');
2096: END IF;
2097:
2098: fnd_msg_pub.count_and_get (p_count => x_msg_count
2099: , p_data => x_msg_data);

Line 2098: fnd_msg_pub.count_and_get (p_count => x_msg_count

2094: THEN
2095: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Serial_Status');
2096: END IF;
2097:
2098: fnd_msg_pub.count_and_get (p_count => x_msg_count
2099: , p_data => x_msg_data);
2100: END validate_serial_status;
2101:
2102: /******************************************************************************************

Line 2146: * FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

2142:
2143: /*********************************************************************************************
2144: * Pseudo-codes: *
2145: * x_return_status := FND_API.G_RET_STS_SUCCESS;
2146: * FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2147: *
2148: * call INV_LOT_SEL_ATTR.is_enabled to see if the lot attributes is enabled for this
2149: * item/org/category combination
2150: *

Line 2317: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2313: print_debug ('Validate Attributes', 'Validate_Attributes');
2314: END IF;
2315:
2316: x_return_status := fnd_api.g_ret_sts_success;
2317: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2318:
2319: IF (l_debug = 1)
2320: THEN
2321: print_debug ('p_inventory_item_id is ' || p_inventory_item_id

Line 2485: fnd_msg_pub.add;

2481: arent filled in
2482: IF (l_rs_lot_attr_category IS NULL AND l_count > 0) THEN
2483: print_debug('Resultant lot category is null', 'Validate_Attributes');
2484: fnd_message.set_name('INV', 'INV_VALID_CAT');
2485: fnd_msg_pub.add;
2486: raise FND_API.G_EXC_ERROR;
2487: end if;
2488:
2489: ******/

Line 2516: fnd_msg_pub.ADD;

2512: || l_rs_lot_attr_category
2513: , 'Validate_Attributes'
2514: );
2515: fnd_message.set_name ('INV', 'INV_VALID_CAT');
2516: fnd_msg_pub.ADD;
2517: RAISE fnd_api.g_exc_error;
2518: END IF;
2519:
2520: -- parent lot does not have attributes.

Line 2852: fnd_msg_pub.ADD;

2848: ('SEGMENT'
2849: , v_segments.application_column_name
2850: (j)
2851: );
2852: fnd_msg_pub.ADD;
2853: END IF;
2854: END IF;
2855: END IF;
2856:

Line 2900: fnd_msg_pub.ADD;

2896: x_return_status := fnd_api.g_ret_sts_error;
2897: x_msg_data := fnd_flex_descval.error_message;
2898: fnd_message.set_name ('INV', 'GENERIC');
2899: fnd_message.set_token ('MSGBODY', x_msg_data);
2900: fnd_msg_pub.ADD;
2901: x_msg_count := NVL (x_msg_count, 0) + 1;
2902: RAISE fnd_api.g_exc_error;
2903: END IF;
2904: ELSE

Line 2908: fnd_msg_pub.count_and_get (p_count => x_msg_count

2904: ELSE
2905: -- no context found;
2906: l_validation_status := 'Y';
2907: x_return_status := fnd_api.g_ret_sts_success;
2908: fnd_msg_pub.count_and_get (p_count => x_msg_count
2909: , p_data => x_msg_data);
2910: END IF; -- if l_context_value is not null
2911:
2912: x_lot_attr_tbl := g_lot_attributes_tbl;

Line 2919: fnd_msg_pub.count_and_get (p_count => x_msg_count

2915: WHEN fnd_api.g_exc_error
2916: THEN
2917: x_validation_status := l_validation_status;
2918: x_return_status := fnd_api.g_ret_sts_error;
2919: fnd_msg_pub.count_and_get (p_count => x_msg_count
2920: , p_data => x_msg_data);
2921: WHEN fnd_api.g_exc_unexpected_error
2922: THEN
2923: x_validation_status := l_validation_status;

Line 2925: fnd_msg_pub.count_and_get (p_count => x_msg_count

2921: WHEN fnd_api.g_exc_unexpected_error
2922: THEN
2923: x_validation_status := l_validation_status;
2924: x_return_status := fnd_api.g_ret_sts_unexp_error;
2925: fnd_msg_pub.count_and_get (p_count => x_msg_count
2926: , p_data => x_msg_data);
2927: WHEN OTHERS
2928: THEN
2929: x_validation_status := l_validation_status;

Line 2932: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2928: THEN
2929: x_validation_status := l_validation_status;
2930: x_return_status := fnd_api.g_ret_sts_unexp_error;
2931:
2932: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2933: THEN
2934: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Attributes');
2935: END IF;
2936:

Line 2934: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Attributes');

2930: x_return_status := fnd_api.g_ret_sts_unexp_error;
2931:
2932: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2933: THEN
2934: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Attributes');
2935: END IF;
2936:
2937: fnd_msg_pub.count_and_get (p_count => x_msg_count
2938: , p_data => x_msg_data);

Line 2937: fnd_msg_pub.count_and_get (p_count => x_msg_count

2933: THEN
2934: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Attributes');
2935: END IF;
2936:
2937: fnd_msg_pub.count_and_get (p_count => x_msg_count
2938: , p_data => x_msg_data);
2939: END validate_attributes;
2940:
2941: /*********************************************************************************

Line 3051: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

3047: END IF;
3048:
3049: l_validation_status := 'Y';
3050: x_return_status := fnd_api.g_ret_sts_success;
3051: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3052: l_enabled_attributes :=
3053: inv_lot_sel_attr.is_enabled (p_flex_name => l_attributes_name
3054: , p_organization_id => p_organization_id
3055: , p_inventory_item_id => p_inventory_item_id

Line 3479: fnd_msg_pub.ADD;

3475: ('SEGMENT'
3476: , v_segments.application_column_name
3477: (j)
3478: );
3479: fnd_msg_pub.ADD;
3480: END IF;
3481: END IF;
3482: END IF;
3483:

Line 3527: fnd_msg_pub.ADD;

3523: x_return_status := fnd_api.g_ret_sts_error;
3524: x_msg_data := fnd_flex_descval.error_message;
3525: fnd_message.set_name ('INV', 'GENERIC');
3526: fnd_message.set_token ('MSGBODY', x_msg_data);
3527: fnd_msg_pub.ADD;
3528: x_msg_count := NVL (x_msg_count, 0) + 1;
3529: RAISE fnd_api.g_exc_error;
3530: END IF;
3531: ELSE

Line 3535: fnd_msg_pub.count_and_get (p_count => x_msg_count

3531: ELSE
3532: -- no context found;
3533: l_validation_status := 'Y';
3534: x_return_status := fnd_api.g_ret_sts_success;
3535: fnd_msg_pub.count_and_get (p_count => x_msg_count
3536: , p_data => x_msg_data);
3537: END IF; -- if l_context_value is not null
3538:
3539: x_ser_attr_tbl := g_lot_ser_attributes_tbl;

Line 3547: fnd_msg_pub.count_and_get (p_count => x_msg_count

3543: WHEN fnd_api.g_exc_error
3544: THEN
3545: x_validation_status := l_validation_status;
3546: x_return_status := fnd_api.g_ret_sts_error;
3547: fnd_msg_pub.count_and_get (p_count => x_msg_count
3548: , p_data => x_msg_data);
3549: WHEN fnd_api.g_exc_unexpected_error
3550: THEN
3551: x_validation_status := l_validation_status;

Line 3553: fnd_msg_pub.count_and_get (p_count => x_msg_count

3549: WHEN fnd_api.g_exc_unexpected_error
3550: THEN
3551: x_validation_status := l_validation_status;
3552: x_return_status := fnd_api.g_ret_sts_unexp_error;
3553: fnd_msg_pub.count_and_get (p_count => x_msg_count
3554: , p_data => x_msg_data);
3555: WHEN OTHERS
3556: THEN
3557: x_validation_status := 'E';

Line 3560: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3556: THEN
3557: x_validation_status := 'E';
3558: x_return_status := fnd_api.g_ret_sts_unexp_error;
3559:
3560: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3561: THEN
3562: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_serial_attributes');
3563: END IF;
3564:

Line 3562: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_serial_attributes');

3558: x_return_status := fnd_api.g_ret_sts_unexp_error;
3559:
3560: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3561: THEN
3562: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_serial_attributes');
3563: END IF;
3564:
3565: fnd_msg_pub.count_and_get (p_count => x_msg_count
3566: , p_data => x_msg_data);

Line 3565: fnd_msg_pub.count_and_get (p_count => x_msg_count

3561: THEN
3562: fnd_msg_pub.add_exc_msg (g_pkg_name, 'validate_serial_attributes');
3563: END IF;
3564:
3565: fnd_msg_pub.count_and_get (p_count => x_msg_count
3566: , p_data => x_msg_data);
3567: END validate_serial_attributes;
3568:
3569: /*********************************************************************************************

Line 3777: fnd_msg_pub.ADD;

3773: );
3774: END IF;
3775:
3776: fnd_message.set_name ('INV', 'INV_ERROR_GET_COST_GROUP');
3777: fnd_msg_pub.ADD;
3778: x_validation_status := 'N';
3779: RAISE fnd_api.g_exc_error;
3780: END IF;
3781:

Line 3788: fnd_msg_pub.ADD;

3784: l_cost_group_id := v_cost_group_id;
3785: ELSIF (l_cost_group_id <> v_cost_group_id)
3786: THEN
3787: fnd_message.set_name ('INV', 'INV_INT_CSTGRP');
3788: fnd_msg_pub.ADD;
3789: x_validation_status := 'N';
3790: RAISE fnd_api.g_exc_error;
3791: END IF;
3792:

Line 3818: fnd_msg_pub.ADD;

3814: LOOP
3815: IF (x_rs_cost_group_tbl (i) <> l_cost_group_id)
3816: THEN
3817: fnd_message.set_name ('INV', 'INV_LOT_DIFF_COSTGROUP');
3818: fnd_msg_pub.ADD;
3819: l_validation_status := 'N';
3820: RAISE fnd_api.g_exc_error;
3821: END IF;
3822: END LOOP;

Line 3887: fnd_msg_pub.ADD;

3883:
3884: IF (l_return_status <> fnd_api.g_ret_sts_success)
3885: THEN
3886: fnd_message.set_name ('INV', 'INV_ERROR_GET_COST_GROUP');
3887: fnd_msg_pub.ADD;
3888: x_validation_status := 'N';
3889: RAISE fnd_api.g_exc_error;
3890: END IF;
3891: END IF;

Line 3897: fnd_msg_pub.ADD;

3893: IF (l_current_cost_group_id <> l_cost_group_id)
3894: THEN
3895: fnd_message.set_name ('INV', 'INV_DIFF_MERGE_COST_GROUP');
3896: fnd_message.set_token ('ENTITY1', l_lot_number);
3897: fnd_msg_pub.ADD;
3898: x_validation_status := 'N';
3899: RAISE fnd_api.g_exc_error;
3900: END IF;
3901: END LOOP;

Line 3910: fnd_msg_pub.count_and_get (p_count => x_msg_count

3906: THEN
3907: -- do nothing. let the trx manager assign the cost group;
3908: x_validation_status := 'Y';
3909: x_return_status := fnd_api.g_ret_sts_success;
3910: fnd_msg_pub.count_and_get (p_count => x_msg_count
3911: , p_data => x_msg_data
3912: );
3913: RETURN;
3914: END IF;

Line 3917: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

3913: RETURN;
3914: END IF;
3915: END IF;
3916:
3917: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3918: EXCEPTION
3919: WHEN fnd_api.g_exc_error
3920: THEN
3921: x_return_status := fnd_api.g_ret_sts_error;

Line 3922: fnd_msg_pub.count_and_get (p_count => x_msg_count

3918: EXCEPTION
3919: WHEN fnd_api.g_exc_error
3920: THEN
3921: x_return_status := fnd_api.g_ret_sts_error;
3922: fnd_msg_pub.count_and_get (p_count => x_msg_count
3923: , p_data => x_msg_data);
3924: WHEN fnd_api.g_exc_unexpected_error
3925: THEN
3926: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3927: fnd_msg_pub.count_and_get (p_count => x_msg_count

3923: , p_data => x_msg_data);
3924: WHEN fnd_api.g_exc_unexpected_error
3925: THEN
3926: x_return_status := fnd_api.g_ret_sts_unexp_error;
3927: fnd_msg_pub.count_and_get (p_count => x_msg_count
3928: , p_data => x_msg_data);
3929: WHEN OTHERS
3930: THEN
3931: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3933: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

3929: WHEN OTHERS
3930: THEN
3931: x_return_status := fnd_api.g_ret_sts_unexp_error;
3932:
3933: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3934: THEN
3935: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Material_Status');
3936: END IF;
3937:

Line 3935: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Material_Status');

3931: x_return_status := fnd_api.g_ret_sts_unexp_error;
3932:
3933: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3934: THEN
3935: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Material_Status');
3936: END IF;
3937:
3938: fnd_msg_pub.count_and_get (p_count => x_msg_count
3939: , p_data => x_msg_data);

Line 3938: fnd_msg_pub.count_and_get (p_count => x_msg_count

3934: THEN
3935: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Material_Status');
3936: END IF;
3937:
3938: fnd_msg_pub.count_and_get (p_count => x_msg_count
3939: , p_data => x_msg_data);
3940: END validate_cost_groups;
3941:
3942: /*********************************************************************************************

Line 4141: fnd_msg_pub.ADD;

4137: EXCEPTION
4138: WHEN NO_DATA_FOUND
4139: THEN
4140: fnd_message.set_name ('INV', 'INV_INT_ITEM_CODE');
4141: fnd_msg_pub.ADD;
4142: RAISE fnd_api.g_exc_error;
4143: END;
4144:
4145: IF (l_debug = 1) THEN

Line 4204: fnd_msg_pub.ADD;

4200: fnd_message.set_name ('INV', 'INV-CANNOT CONVERT');
4201: fnd_message.set_token ('UOM', l_start_uom_code);
4202: fnd_message.set_token ('ROUTINE'
4203: , g_pkg_name || 'Validate_Quantity');
4204: fnd_msg_pub.ADD;
4205: x_validation_status := 'N';
4206: RAISE fnd_api.g_exc_unexpected_error;
4207: END IF;
4208: ELSE

Line 4243: fnd_msg_pub.ADD;

4239: IF (l_debug = 1) THEN
4240: print_debug ('get_immediate_lpn_item_qty has returned error', 'Validate_Quantity');
4241: END IF;
4242: fnd_message.set_name ('INV', 'INV_NOT_ENOUGH_ATT');
4243: fnd_msg_pub.ADD;
4244: RAISE fnd_api.g_exc_error;
4245: END IF;
4246:
4247: IF (l_debug = 1) THEN

Line 4255: fnd_msg_pub.ADD;

4251: END IF;
4252:
4253: IF (l_att_qty < l_start_primary_qty) THEN
4254: fnd_message.set_name ('INV', 'INV_NOT_ENOUGH_ATT');
4255: fnd_msg_pub.ADD;
4256: RAISE fnd_api.g_exc_error;
4257: END IF;
4258:
4259: IF (p_transaction_type_id = inv_globals.g_type_inv_lot_translate) THEN

Line 4262: fnd_msg_pub.ADD;

4258:
4259: IF (p_transaction_type_id = inv_globals.g_type_inv_lot_translate) THEN
4260: IF (l_att_qty <> l_start_primary_qty) THEN
4261: fnd_message.set_name ('INV', 'INV_LOT_TRANSLATE_QTY_ERR');
4262: fnd_msg_pub.ADD;
4263: RAISE fnd_api.g_exc_error;
4264: END IF;
4265: END IF;
4266:

Line 4290: fnd_msg_pub.ADD;

4286: IF (l_result_qty = -99999) THEN
4287: fnd_message.set_name ('INV', 'INV-CANNOT CONVERT');
4288: fnd_message.set_token ('UOM', l_start_uom_code);
4289: fnd_message.set_token ('ROUTINE', g_pkg_name || 'Validate_Quantity');
4290: fnd_msg_pub.ADD;
4291: x_validation_status := 'N';
4292: RAISE fnd_api.g_exc_unexpected_error;
4293: END IF;
4294: ELSE

Line 4303: fnd_msg_pub.ADD;

4299: AND l_result_qty = l_att_qty
4300: AND p_transaction_type_id = inv_globals.g_type_inv_lot_split
4301: ) THEN
4302: fnd_message.set_name ('INV', 'INV_MIN_LOT_SPLIT');
4303: fnd_msg_pub.ADD;
4304: RAISE fnd_api.g_exc_error;
4305: END IF;
4306:
4307: l_total_qty := l_total_qty + l_result_qty;

Line 4334: fnd_msg_pub.ADD;

4330: print_debug ('Lot = > ' || p_rs_lot_num_tbl (i), 'Validate_Quantity');
4331: print_debug ('l_lot_serial_count = > ' || l_lot_serial_count, 'Validate_Quantity');
4332: END IF;
4333: fnd_message.set_name ('INV', 'INV_INVLTPU_LOTTRX_QTY');
4334: fnd_msg_pub.ADD;
4335: RAISE fnd_api.g_exc_error;
4336: END IF;
4337: END IF;
4338: END LOOP;

Line 4342: fnd_msg_pub.ADD;

4338: END LOOP;
4339:
4340: IF (l_total_qty = 0) THEN
4341: fnd_message.set_name ('INV', 'INV_INLTPU_QTY');
4342: fnd_msg_pub.ADD;
4343: RAISE fnd_api.g_exc_error;
4344: END IF;
4345:
4346: IF (l_total_qty <> l_start_primary_qty) THEN

Line 4351: fnd_msg_pub.ADD;

4347: IF ( p_transaction_type_id = inv_globals.g_type_inv_lot_split
4348: AND l_total_qty > l_start_primary_qty) THEN
4349: x_validation_status := 'N';
4350: fnd_message.set_name ('INV', 'INV_TOTAL_EXCEED_SPLIT');
4351: fnd_msg_pub.ADD;
4352: RAISE fnd_api.g_exc_error;
4353: ELSIF (p_transaction_type_id = inv_globals.g_type_inv_lot_translate) THEN
4354: x_validation_status := 'N';
4355: fnd_message.set_name ('INV', 'INV_TOTAL_EXCEED_TRANSLATE');

Line 4356: fnd_msg_pub.ADD;

4352: RAISE fnd_api.g_exc_error;
4353: ELSIF (p_transaction_type_id = inv_globals.g_type_inv_lot_translate) THEN
4354: x_validation_status := 'N';
4355: fnd_message.set_name ('INV', 'INV_TOTAL_EXCEED_TRANSLATE');
4356: fnd_msg_pub.ADD;
4357: RAISE fnd_api.g_exc_error;
4358: END IF;
4359: END IF;
4360:

Line 4372: fnd_msg_pub.ADD;

4368: print_debug('Fractional qty is present for a lot serial controlled item'
4369: , 'Validate_Quantity');
4370: END IF;
4371: fnd_message.set_name ('INV', 'INV_LOT_SER_QTY_VIOLATION');
4372: fnd_msg_pub.ADD;
4373: RAISE fnd_api.g_exc_error;
4374: END IF;
4375:
4376: IF ( p_st_ser_number_tbl.COUNT <> l_start_primary_qty

Line 4391: fnd_msg_pub.ADD;

4387: print_debug('l_total_qty => ' || l_total_qty, 'Validate_Quantity');
4388: END IF;
4389: x_validation_status := 'N';
4390: fnd_message.set_name ('INV', 'INV_INVLTPU_LOTTRX_QTY');
4391: fnd_msg_pub.ADD;
4392: RAISE fnd_api.g_exc_error;
4393: END IF;
4394: END IF;
4395: /* for lot merge, the check if the starting lot have enough qty to transact in

Line 4419: fnd_msg_pub.ADD;

4415: fnd_message.set_token ('UOM', l_start_uom_code);
4416: fnd_message.set_token ('ROUTINE'
4417: , g_pkg_name || 'Validate_Quantity'
4418: );
4419: fnd_msg_pub.ADD;
4420: x_validation_status := 'N';
4421: RAISE fnd_api.g_exc_unexpected_error;
4422: END IF;
4423: ELSE

Line 4461: fnd_msg_pub.ADD;

4457: IF (l_debug = 1) THEN
4458: print_debug ('get_immediates_lpn_qty returned error', 'Validate_Quantity');
4459: END IF;
4460: fnd_message.set_name ('INV', 'INV_NOT_ENOUGH_ATT');
4461: fnd_msg_pub.ADD;
4462: RAISE fnd_api.g_exc_error;
4463: END IF;
4464:
4465: IF (l_debug = 1) THEN

Line 4473: fnd_msg_pub.ADD;

4469: END IF;
4470:
4471: IF (l_att_qty < l_start_primary_qty) THEN
4472: fnd_message.set_name ('INV', 'INV_NOT_ENOUGH_ATT');
4473: fnd_msg_pub.ADD;
4474: RAISE fnd_api.g_exc_error;
4475: END IF;
4476:
4477: /*OSFM support for Serialized Lot Items

Line 4500: fnd_msg_pub.ADD;

4496: print_debug ('Lot = > ' || p_st_lot_num_tbl (i), 'Validate_Quantity');
4497: print_debug ('l_lot_serial_count = > ' || l_lot_serial_count, 'Validate_Quantity');
4498: END IF;
4499: fnd_message.set_name ('INV', 'INV_INVLTPU_LOTTRX_QTY');
4500: fnd_msg_pub.ADD;
4501: RAISE fnd_api.g_exc_error;
4502: END IF;
4503: END IF;
4504:

Line 4528: fnd_msg_pub.ADD;

4524: THEN
4525: fnd_message.set_name ('INV', 'INV-CANNOT CONVERT');
4526: fnd_message.set_token ('UOM', l_start_uom_code);
4527: fnd_message.set_token ('ROUTINE', g_pkg_name || 'Validate_Quantity');
4528: fnd_msg_pub.ADD;
4529: x_validation_status := 'N';
4530: RAISE fnd_api.g_exc_unexpected_error;
4531: END IF;
4532: ELSE

Line 4544: fnd_msg_pub.ADD;

4540:
4541: IF (l_result_qty <> l_total_qty) THEN
4542: x_validation_status := 'N';
4543: fnd_message.set_name ('INV', 'INV_QTY_NOT_MATCHED');
4544: fnd_msg_pub.ADD;
4545: RAISE fnd_api.g_exc_error;
4546: END IF;
4547:
4548: /*For lot - serial items*/

Line 4553: fnd_msg_pub.ADD;

4549: IF (l_serial_code IN (2, 5)) THEN
4550: IF ( TRUNC (l_start_primary_qty) <> TRUNC (l_start_primary_qty, 6)
4551: OR TRUNC (l_total_qty) <> TRUNC (l_total_qty, 6) ) THEN
4552: fnd_message.set_name ('INV', 'INV_LOT_SER_QTY_VIOLATION');
4553: fnd_msg_pub.ADD;
4554: RAISE fnd_api.g_exc_error;
4555: END IF;
4556:
4557: IF ( p_st_ser_number_tbl.COUNT <> l_total_qty

Line 4561: fnd_msg_pub.ADD;

4557: IF ( p_st_ser_number_tbl.COUNT <> l_total_qty
4558: OR p_rs_ser_number_tbl.COUNT <> l_result_qty ) THEN
4559: x_validation_status := 'N';
4560: fnd_message.set_name ('INV', 'INV_INVLTPU_LOTTRX_QTY');
4561: fnd_msg_pub.ADD;
4562: RAISE fnd_api.g_exc_error;
4563: END IF;
4564: END IF;
4565: END IF;

Line 4567: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

4563: END IF;
4564: END IF;
4565: END IF;
4566:
4567: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4568: EXCEPTION
4569: WHEN fnd_api.g_exc_error
4570: THEN
4571: x_return_status := fnd_api.g_ret_sts_error;

Line 4572: fnd_msg_pub.count_and_get (p_count => x_msg_count

4568: EXCEPTION
4569: WHEN fnd_api.g_exc_error
4570: THEN
4571: x_return_status := fnd_api.g_ret_sts_error;
4572: fnd_msg_pub.count_and_get (p_count => x_msg_count
4573: , p_data => x_msg_data);
4574: WHEN fnd_api.g_exc_unexpected_error
4575: THEN
4576: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4577: fnd_msg_pub.count_and_get (p_count => x_msg_count

4573: , p_data => x_msg_data);
4574: WHEN fnd_api.g_exc_unexpected_error
4575: THEN
4576: x_return_status := fnd_api.g_ret_sts_unexp_error;
4577: fnd_msg_pub.count_and_get (p_count => x_msg_count
4578: , p_data => x_msg_data);
4579: WHEN OTHERS
4580: THEN
4581: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4583: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

4579: WHEN OTHERS
4580: THEN
4581: x_return_status := fnd_api.g_ret_sts_unexp_error;
4582:
4583: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4584: THEN
4585: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Quantity');
4586: END IF;
4587:

Line 4585: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Quantity');

4581: x_return_status := fnd_api.g_ret_sts_unexp_error;
4582:
4583: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4584: THEN
4585: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Quantity');
4586: END IF;
4587:
4588: fnd_msg_pub.count_and_get (p_count => x_msg_count
4589: , p_data => x_msg_data);

Line 4588: fnd_msg_pub.count_and_get (p_count => x_msg_count

4584: THEN
4585: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Quantity');
4586: END IF;
4587:
4588: fnd_msg_pub.count_and_get (p_count => x_msg_count
4589: , p_data => x_msg_data);
4590: END validate_quantity;
4591:
4592: /*********************************************************************************************

Line 4611: fnd_msg_pub.ADD;

4607: BEGIN
4608: IF (p_organization_id IS NULL)
4609: THEN
4610: fnd_message.set_name ('INV', 'INV_MISSING_REQUIRED_PARAMETER');
4611: fnd_msg_pub.ADD;
4612: x_validation_status := 'N';
4613: RAISE fnd_api.g_exc_error;
4614: END IF;
4615:

Line 4636: fnd_msg_pub.ADD;

4632: OR l_period_tbl_id = -1
4633: )
4634: THEN
4635: fnd_message.set_name ('INV', 'INV_NO_OPEN_PERIOD');
4636: fnd_msg_pub.ADD;
4637: x_validation_status := 'N';
4638: RAISE fnd_api.g_exc_error;
4639: END IF;
4640: END LOOP;

Line 4645: fnd_msg_pub.ADD;

4641:
4642: IF (l_period_id = 0 OR l_period_id = -1)
4643: THEN
4644: fnd_message.set_name ('INV', 'INV_NO_OPEN_PERIOD');
4645: fnd_msg_pub.ADD;
4646: x_validation_status := 'N';
4647: RAISE fnd_api.g_exc_error;
4648: ELSE
4649: x_validation_status := 'Y';

Line 4651: fnd_msg_pub.count_and_get (p_count => x_msg_count

4647: RAISE fnd_api.g_exc_error;
4648: ELSE
4649: x_validation_status := 'Y';
4650: x_return_status := fnd_api.g_ret_sts_success;
4651: fnd_msg_pub.count_and_get (p_count => x_msg_count
4652: , p_data => x_msg_data);
4653: END IF;
4654: EXCEPTION
4655: WHEN fnd_api.g_exc_error

Line 4658: fnd_msg_pub.count_and_get (p_count => x_msg_count

4654: EXCEPTION
4655: WHEN fnd_api.g_exc_error
4656: THEN
4657: x_return_status := fnd_api.g_ret_sts_error;
4658: fnd_msg_pub.count_and_get (p_count => x_msg_count
4659: , p_data => x_msg_data);
4660: WHEN fnd_api.g_exc_unexpected_error
4661: THEN
4662: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4663: fnd_msg_pub.count_and_get (p_count => x_msg_count

4659: , p_data => x_msg_data);
4660: WHEN fnd_api.g_exc_unexpected_error
4661: THEN
4662: x_return_status := fnd_api.g_ret_sts_unexp_error;
4663: fnd_msg_pub.count_and_get (p_count => x_msg_count
4664: , p_data => x_msg_data);
4665: WHEN OTHERS
4666: THEN
4667: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4669: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

4665: WHEN OTHERS
4666: THEN
4667: x_return_status := fnd_api.g_ret_sts_unexp_error;
4668:
4669: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4670: THEN
4671: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Organization');
4672: END IF;
4673:

Line 4671: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Organization');

4667: x_return_status := fnd_api.g_ret_sts_unexp_error;
4668:
4669: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
4670: THEN
4671: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Organization');
4672: END IF;
4673:
4674: fnd_msg_pub.count_and_get (p_count => x_msg_count
4675: , p_data => x_msg_data);

Line 4674: fnd_msg_pub.count_and_get (p_count => x_msg_count

4670: THEN
4671: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_Organization');
4672: END IF;
4673:
4674: fnd_msg_pub.count_and_get (p_count => x_msg_count
4675: , p_data => x_msg_data);
4676: END validate_organization;
4677:
4678: /***********************************Validate_Serials*************************

Line 4736: fnd_msg_pub.ADD;

4732: END IF;
4733:
4734: l_validation_status := 'N';
4735: fnd_message.set_name ('INV', 'INV_MISSING_REQUIRED_PARAMETER');
4736: fnd_msg_pub.ADD;
4737: RAISE fnd_api.g_exc_error;
4738: END IF;
4739:
4740: l_st_var_index := p_st_ser_number_tbl.FIRST;

Line 4768: fnd_msg_pub.ADD;

4764: END IF;
4765:
4766: l_validation_status := 'N';
4767: fnd_message.set_name ('INV', 'INV_SERIAL_MATCH_ERROR');
4768: fnd_msg_pub.ADD;
4769: RAISE fnd_api.g_exc_error;
4770: /*Bug:5147899. Modified the following condition to throw error
4771: only when the group_mark_id holds a not null value other than -1 */
4772: ELSIF ( p_st_ser_grp_mark_id_tbl (i) IS NOT NULL

Line 4787: fnd_msg_pub.ADD;

4783: END IF;
4784:
4785: l_validation_status := 'N';
4786: fnd_message.set_name ('INV', 'INV_SERIAL_IN_USE');
4787: fnd_msg_pub.ADD;
4788: RAISE fnd_api.g_exc_error;
4789: ELSE
4790: /*Lot status validations are done in lot_trx_split_validations seperately.
4791: *Here we are only concerned with serial status validations.

Line 4892: fnd_msg_pub.ADD;

4888: );
4889: END IF;
4890:
4891: fnd_message.set_name ('WMS', 'WMS_VALIDATE_STATUS_ERROR');
4892: fnd_msg_pub.ADD;
4893: fnd_msg_pub.count_and_get (p_count => x_msg_count
4894: , p_data => x_msg_data
4895: );
4896: l_validation_status := 'N';

Line 4893: fnd_msg_pub.count_and_get (p_count => x_msg_count

4889: END IF;
4890:
4891: fnd_message.set_name ('WMS', 'WMS_VALIDATE_STATUS_ERROR');
4892: fnd_msg_pub.ADD;
4893: fnd_msg_pub.count_and_get (p_count => x_msg_count
4894: , p_data => x_msg_data
4895: );
4896: l_validation_status := 'N';
4897: RAISE fnd_api.g_exc_unexpected_error;

Line 4981: fnd_msg_pub.ADD;

4977: END IF;
4978:
4979: l_validation_status := 'N';
4980: fnd_message.set_name ('INV', 'INV_FAIL_VALIDATE_SERIAL');
4981: fnd_msg_pub.ADD;
4982: RAISE fnd_api.g_exc_error;
4983: END IF;
4984:
4985: l_rs_var_index := p_rs_ser_number_tbl.NEXT (l_rs_var_index);

Line 4991: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

4987: END IF;
4988:
4989: x_validation_status := 'Y';
4990: x_return_status := fnd_api.g_ret_sts_success;
4991: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
4992:
4993: IF (l_debug = 1)
4994: THEN
4995: print_debug ('breadcrumb 150', 'Validate_serials');

Line 5003: fnd_msg_pub.count_and_get (p_count => x_msg_count

4999: WHEN fnd_api.g_exc_error
5000: THEN
5001: x_validation_status := l_validation_status;
5002: x_return_status := fnd_api.g_ret_sts_error;
5003: fnd_msg_pub.count_and_get (p_count => x_msg_count
5004: , p_data => x_msg_data);
5005: WHEN fnd_api.g_exc_unexpected_error
5006: THEN
5007: x_validation_status := l_validation_status;

Line 5009: fnd_msg_pub.count_and_get (p_count => x_msg_count

5005: WHEN fnd_api.g_exc_unexpected_error
5006: THEN
5007: x_validation_status := l_validation_status;
5008: x_return_status := fnd_api.g_ret_sts_unexp_error;
5009: fnd_msg_pub.count_and_get (p_count => x_msg_count
5010: , p_data => x_msg_data);
5011: WHEN OTHERS
5012: THEN
5013: x_validation_status := 'E';

Line 5016: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

5012: THEN
5013: x_validation_status := 'E';
5014: x_return_status := fnd_api.g_ret_sts_unexp_error;
5015:
5016: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5017: THEN
5018: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_serials');
5019: END IF;
5020:

Line 5018: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_serials');

5014: x_return_status := fnd_api.g_ret_sts_unexp_error;
5015:
5016: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5017: THEN
5018: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_serials');
5019: END IF;
5020:
5021: fnd_msg_pub.count_and_get (p_count => x_msg_count
5022: , p_data => x_msg_data);

Line 5021: fnd_msg_pub.count_and_get (p_count => x_msg_count

5017: THEN
5018: fnd_msg_pub.add_exc_msg (g_pkg_name, 'Validate_serials');
5019: END IF;
5020:
5021: fnd_msg_pub.count_and_get (p_count => x_msg_count
5022: , p_data => x_msg_data);
5023: END validate_serials;
5024:
5025: /*********************************************************************************************

Line 5060: fnd_msg_pub.ADD;

5056: EXCEPTION
5057: WHEN NO_DATA_FOUND
5058: THEN
5059: fnd_message.set_name ('INV', 'INV_INVALID_ITEM');
5060: fnd_msg_pub.ADD;
5061: RAISE fnd_api.g_exc_unexpected_error;
5062: END;
5063:
5064: print_debug ('Shelf Life Period ' || l_shelf_life_code, 'Compute Lot Exp');

Line 5089: fnd_msg_pub.ADD;

5085: EXCEPTION
5086: WHEN NO_DATA_FOUND
5087: THEN
5088: fnd_message.set_name ('INV', 'INV_INVALID_LOT');
5089: fnd_msg_pub.ADD;
5090: RAISE fnd_api.g_exc_unexpected_error;
5091: END;
5092:
5093: print_debug ('Lot exp date after split1 ' || l_lotexpdate

Line 5100: fnd_msg_pub.ADD;

5096:
5097: IF (l_lotexpdate IS NULL)
5098: THEN
5099: fnd_message.set_name ('INV', 'INV_INVALID_LOT_EXP');
5100: fnd_msg_pub.ADD;
5101: RAISE fnd_api.g_exc_unexpected_error;
5102: END IF;
5103:
5104: -- Update all the resulting lots with this exp date

Line 5131: fnd_msg_pub.ADD;

5127: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5128: fnd_message.set_token ('ENTITY1'
5129: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5130: );
5131: fnd_msg_pub.ADD;
5132: RAISE fnd_api.g_exc_unexpected_error;
5133: END;
5134:
5135: print_debug ('Lot exp date after split3 ' || l_lotexpdate

Line 5172: fnd_msg_pub.ADD;

5168:
5169: IF (l_lotexpdate IS NULL)
5170: THEN
5171: fnd_message.set_name ('INV', 'INV_INVALID_LOT_EXP');
5172: fnd_msg_pub.ADD;
5173: RAISE fnd_api.g_exc_unexpected_error;
5174: END IF;
5175:
5176: p_rs_lot_exp_tbl (1) := fnd_date.canonical_to_date (l_lotexpdate);

Line 5197: fnd_msg_pub.ADD;

5193: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5194: fnd_message.set_token ('ENTITY1'
5195: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5196: );
5197: fnd_msg_pub.ADD;
5198: RAISE fnd_api.g_exc_unexpected_error;
5199: END;
5200:
5201: print_debug ('Lot exp date update merge2 ' || l_lotexpdate

Line 5219: fnd_msg_pub.ADD;

5215: EXCEPTION
5216: WHEN NO_DATA_FOUND
5217: THEN
5218: fnd_message.set_name ('INV', 'INV_INVALID_LOT');
5219: fnd_msg_pub.ADD;
5220: RAISE fnd_api.g_exc_unexpected_error;
5221: END;
5222:
5223: print_debug ('Lot exp date after translate1 ' || l_lotexpdate

Line 5230: fnd_msg_pub.ADD;

5226:
5227: IF (l_lotexpdate IS NULL)
5228: THEN
5229: fnd_message.set_name ('INV', 'INV_INVALID_LOT_EXP');
5230: fnd_msg_pub.ADD;
5231: RAISE fnd_api.g_exc_unexpected_error;
5232: END IF;
5233:
5234: BEGIN

Line 5251: fnd_msg_pub.ADD;

5247: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5248: fnd_message.set_token ('ENTITY1'
5249: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5250: );
5251: fnd_msg_pub.ADD;
5252: RAISE fnd_api.g_exc_unexpected_error;
5253: END;
5254:
5255: print_debug ('Lot exp date update translate2 ' || l_lotexpdate

Line 5277: fnd_msg_pub.ADD;

5273: EXCEPTION
5274: WHEN NO_DATA_FOUND
5275: THEN
5276: fnd_message.set_name ('INV', 'INV_INVALID_LOT');
5277: fnd_msg_pub.ADD;
5278: RAISE fnd_api.g_exc_unexpected_error;
5279: END;
5280:
5281: print_debug ('Lot exp date user defined :split1 ' || l_lotexpdate

Line 5301: fnd_msg_pub.ADD;

5297:
5298: IF (l_lotexpdate IS NULL)
5299: THEN
5300: fnd_message.set_name ('INV', 'INV_INVALID_LOT_EXP');
5301: fnd_msg_pub.ADD;
5302: RAISE fnd_api.g_exc_unexpected_error;
5303: END IF;
5304:
5305: BEGIN

Line 5323: fnd_msg_pub.ADD;

5319: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5320: fnd_message.set_token ('ENTITY1'
5321: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5322: );
5323: fnd_msg_pub.ADD;
5324: RAISE fnd_api.g_exc_unexpected_error;
5325: END;
5326:
5327: print_debug ( 'Lot exp date user defined : after update split3 '

Line 5368: fnd_msg_pub.ADD;

5364: || l_lotexpdate
5365: , 'Compute Lot Exp'
5366: );
5367: fnd_message.set_name ('INV', 'INV_INVALID_LOT');
5368: fnd_msg_pub.ADD;
5369: RAISE fnd_api.g_exc_unexpected_error;
5370: END;
5371:
5372: print_debug ( 'Lot exp date user defined : Merge3 '

Line 5390: fnd_msg_pub.ADD;

5386: THEN
5387: IF (l_lotexpdate IS NULL)
5388: THEN
5389: fnd_message.set_name ('INV', 'INV_INVALID_LOT_EXP');
5390: fnd_msg_pub.ADD;
5391: RAISE fnd_api.g_exc_unexpected_error;
5392: END IF;
5393:
5394: BEGIN

Line 5412: fnd_msg_pub.ADD;

5408: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5409: fnd_message.set_token ('ENTITY1'
5410: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5411: );
5412: fnd_msg_pub.ADD;
5413: RAISE fnd_api.g_exc_unexpected_error;
5414: END;
5415:
5416: print_debug ( 'Lot exp date user defined : after update Merge6 '

Line 5438: fnd_msg_pub.ADD;

5434: EXCEPTION
5435: WHEN NO_DATA_FOUND
5436: THEN
5437: fnd_message.set_name ('INV', 'INV_INVALID_LOT');
5438: fnd_msg_pub.ADD;
5439: RAISE fnd_api.g_exc_unexpected_error;
5440: END;
5441:
5442: print_debug ( 'Lot exp date user defined : Translate1 '

Line 5450: fnd_msg_pub.ADD;

5446:
5447: IF (l_lotexpdate IS NULL)
5448: THEN
5449: fnd_message.set_name ('INV', 'INV_INVALID_LOT_EXP');
5450: fnd_msg_pub.ADD;
5451: RAISE fnd_api.g_exc_unexpected_error;
5452: END IF;
5453:
5454: BEGIN

Line 5472: fnd_msg_pub.ADD;

5468: fnd_message.set_name ('INV', 'INV_UPDATE_ERROR');
5469: fnd_message.set_token ('ENTITY1'
5470: , 'MTL_TRANSACTION_LOTS_INTERFACE'
5471: );
5472: fnd_msg_pub.ADD;
5473: RAISE fnd_api.g_exc_unexpected_error;
5474: END;
5475:
5476: print_debug

Line 5486: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

5482: END IF;
5483: END IF;
5484:
5485: x_return_status := fnd_api.g_ret_sts_success;
5486: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5487: EXCEPTION
5488: WHEN fnd_api.g_exc_error
5489: THEN
5490: x_return_status := fnd_api.g_ret_sts_error;

Line 5491: fnd_msg_pub.count_and_get (p_count => x_msg_count

5487: EXCEPTION
5488: WHEN fnd_api.g_exc_error
5489: THEN
5490: x_return_status := fnd_api.g_ret_sts_error;
5491: fnd_msg_pub.count_and_get (p_count => x_msg_count
5492: , p_data => x_msg_data);
5493: WHEN fnd_api.g_exc_unexpected_error
5494: THEN
5495: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5496: fnd_msg_pub.count_and_get (p_count => x_msg_count

5492: , p_data => x_msg_data);
5493: WHEN fnd_api.g_exc_unexpected_error
5494: THEN
5495: x_return_status := fnd_api.g_ret_sts_unexp_error;
5496: fnd_msg_pub.count_and_get (p_count => x_msg_count
5497: , p_data => x_msg_data);
5498: WHEN OTHERS
5499: THEN
5500: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5502: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

5498: WHEN OTHERS
5499: THEN
5500: x_return_status := fnd_api.g_ret_sts_unexp_error;
5501:
5502: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5503: THEN
5504: fnd_msg_pub.add_exc_msg (g_pkg_name, 'compute_lot_expiration');
5505: END IF;
5506:

Line 5504: fnd_msg_pub.add_exc_msg (g_pkg_name, 'compute_lot_expiration');

5500: x_return_status := fnd_api.g_ret_sts_unexp_error;
5501:
5502: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5503: THEN
5504: fnd_msg_pub.add_exc_msg (g_pkg_name, 'compute_lot_expiration');
5505: END IF;
5506:
5507: fnd_msg_pub.count_and_get (p_count => x_msg_count
5508: , p_data => x_msg_data);

Line 5507: fnd_msg_pub.count_and_get (p_count => x_msg_count

5503: THEN
5504: fnd_msg_pub.add_exc_msg (g_pkg_name, 'compute_lot_expiration');
5505: END IF;
5506:
5507: fnd_msg_pub.count_and_get (p_count => x_msg_count
5508: , p_data => x_msg_data);
5509: END compute_lot_expiration;
5510:
5511: PROCEDURE update_item_serial (

Line 5720: fnd_msg_pub.ADD;

5716: to INV_SERIAL_UNIQUENESS */
5717: /*Bug:5397573. Modified the following message from INV_SERIAL_UNIQUENESS
5718: to INV_JOB_SERIAL_UNIQUENESS. */
5719: fnd_message.set_name ('INV', 'INV_JOB_SERIAL_UNIQUENESS');
5720: fnd_msg_pub.ADD;
5721: RAISE fnd_api.g_exc_error;
5722: END IF;
5723:
5724: IF (l_update_attr) THEN

Line 5872: fnd_msg_pub.count_and_get (p_count => x_msg_count

5868: EXCEPTION
5869: WHEN fnd_api.g_exc_error
5870: THEN
5871: x_return_status := fnd_api.g_ret_sts_error;
5872: fnd_msg_pub.count_and_get (p_count => x_msg_count
5873: , p_data => x_msg_data);
5874: WHEN fnd_api.g_exc_unexpected_error
5875: THEN
5876: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5877: fnd_msg_pub.count_and_get (p_count => x_msg_count

5873: , p_data => x_msg_data);
5874: WHEN fnd_api.g_exc_unexpected_error
5875: THEN
5876: x_return_status := fnd_api.g_ret_sts_unexp_error;
5877: fnd_msg_pub.count_and_get (p_count => x_msg_count
5878: , p_data => x_msg_data);
5879: WHEN rollback_serial_update
5880: THEN
5881: ROLLBACK TO initial_state_svpt;

Line 5886: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

5882: WHEN OTHERS
5883: THEN
5884: x_return_status := fnd_api.g_ret_sts_unexp_error;
5885:
5886: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5887: THEN
5888: fnd_msg_pub.add_exc_msg (g_pkg_name, 'update_item_serial');
5889: END IF;
5890:

Line 5888: fnd_msg_pub.add_exc_msg (g_pkg_name, 'update_item_serial');

5884: x_return_status := fnd_api.g_ret_sts_unexp_error;
5885:
5886: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
5887: THEN
5888: fnd_msg_pub.add_exc_msg (g_pkg_name, 'update_item_serial');
5889: END IF;
5890:
5891: fnd_msg_pub.count_and_get (p_count => x_msg_count
5892: , p_data => x_msg_data);

Line 5891: fnd_msg_pub.count_and_get (p_count => x_msg_count

5887: THEN
5888: fnd_msg_pub.add_exc_msg (g_pkg_name, 'update_item_serial');
5889: END IF;
5890:
5891: fnd_msg_pub.count_and_get (p_count => x_msg_count
5892: , p_data => x_msg_data);
5893: ROLLBACK TO initial_state_svpt;
5894: END;
5895: END inv_lot_trx_validation_pub;