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

Line 64: fnd_msg_pub.initialize;

60:
61: --
62: -- Initialize message list.
63: IF fnd_api.to_boolean(p_init_msg_lst) THEN
64: fnd_msg_pub.initialize;
65: END IF;
66:
67:
68:

Line 89: fnd_msg_pub.ADD;

85: IF (l_debug = 1) THEN
86: debug_print('Invalid Logical Transaction Type Code', 9);
87: END IF;
88: fnd_message.set_name('INV', 'INV_INT_LOGTRXCODE');
89: fnd_msg_pub.ADD;
90: RAISE fnd_api.g_exc_error;
91:
92: END IF;
93:

Line 106: fnd_msg_pub.ADD;

102: IF (l_debug = 1) THEN
103: debug_print('Transaction Type is null ', 9);
104: END IF;
105: fnd_message.set_name('INV', 'INV_INT_TRXTYPCODE');
106: fnd_msg_pub.ADD;
107: RAISE fnd_api.g_exc_error;
108:
109: END IF;
110:

Line 125: fnd_msg_pub.ADD;

121: IF (l_debug = 1) THEN
122: debug_print('Transaction Type not found ', 9);
123: END IF;
124: fnd_message.set_name('INV', 'INV_INT_TRXTYPCODE');
125: fnd_msg_pub.ADD;
126: RAISE fnd_api.g_exc_error;
127: END;
128:
129: IF l_count <> 1 THEN

Line 134: fnd_msg_pub.ADD;

130: IF (l_debug = 1) THEN
131: debug_print('Transaction Type not found ', 9);
132: END IF;
133: fnd_message.set_name('INV', 'INV_INT_TRXTYPCODE');
134: fnd_msg_pub.ADD;
135: RAISE fnd_api.g_exc_error;
136:
137: END IF;
138:

Line 158: fnd_msg_pub.ADD;

154: debug_print('Transaction Action ID : ' ||
155: l_transaction_action_id, 9);
156: END IF;
157: fnd_message.set_name('INV', 'INV_INT_TRXTYPCODE');
158: fnd_msg_pub.ADD;
159: RAISE fnd_api.g_exc_error;
160:
161: END IF;
162:

Line 177: fnd_msg_pub.ADD;

173: IF (l_debug = 1) THEN
174: debug_print('Transaction Action is invalid', 9);
175: END IF;
176: fnd_message.set_name('INV', 'INV_INT_TRXACTCODE');
177: fnd_msg_pub.ADD;
178: RAISE fnd_api.g_exc_error;
179:
180: END IF;
181:

Line 200: fnd_msg_pub.ADD;

196: debug_print('Org. not found :' ||
197: p_mtl_trx_tbl(i).organization_id, 9);
198: END IF;
199: fnd_message.set_name('INV', 'INV_INT_ORGCODE');
200: fnd_msg_pub.ADD;
201: RAISE fnd_api.g_exc_error;
202: END;
203:
204: IF l_count <> 1 THEN

Line 210: fnd_msg_pub.ADD;

206: debug_print('Invalid Organization :' ||
207: p_mtl_trx_tbl(i).organization_id, 9);
208: END IF;
209: fnd_message.set_name('INV', 'INV_INT_XORGCODE');
210: fnd_msg_pub.ADD;
211: RAISE fnd_api.g_exc_error;
212:
213: END IF;
214:

Line 232: fnd_msg_pub.ADD;

228: IF (l_debug = 1) THEN
229: debug_print('Transfer Org. is null', 9);
230: END IF;
231: fnd_message.set_name('INV', 'INV_INT_XORGCODE');
232: fnd_msg_pub.ADD;
233: RAISE fnd_api.g_exc_error;
234: END IF;
235:
236: BEGIN

Line 250: fnd_msg_pub.ADD;

246: debug_print('Transfer Org. not found :' ||
247: p_mtl_trx_tbl(i).transfer_organization_id, 9);
248: END IF;
249: fnd_message.set_name('INV', 'INV_INT_XORGCODE');
250: fnd_msg_pub.ADD;
251: RAISE fnd_api.g_exc_error;
252: END;
253:
254: IF (l_count <> 1) THEN

Line 261: fnd_msg_pub.ADD;

257: p_mtl_trx_tbl(i).transfer_organization_id,
258: 9);
259: END IF;
260: fnd_message.set_name('INV', 'INV_INT_XORGCODE');
261: fnd_msg_pub.ADD;
262: RAISE fnd_api.g_exc_error;
263:
264: END IF;
265: END IF;

Line 281: fnd_msg_pub.ADD;

277: IF (l_debug = 1) THEN
278: debug_print('Item not found', 9);
279: END IF;
280: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
281: fnd_msg_pub.ADD;
282: RAISE fnd_api.g_exc_error;
283: END;
284:
285: IF l_count <> 1 THEN

Line 291: fnd_msg_pub.ADD;

287: debug_print('Invalid item in the current Org. :' ||
288: p_mtl_trx_tbl(i).inventory_item_id, 9);
289: END IF;
290: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
291: fnd_msg_pub.ADD;
292: RAISE fnd_api.g_exc_error;
293:
294: END IF;
295:

Line 317: fnd_msg_pub.ADD;

313: debug_print('Item not found in the transfer Org. :'
314: || p_mtl_trx_tbl(i).inventory_item_id, 9);
315: END IF;
316: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
317: fnd_msg_pub.ADD;
318: RAISE fnd_api.g_exc_error;
319: END;
320:
321: IF (l_count <> 1) THEN

Line 327: fnd_msg_pub.ADD;

323: debug_print('Invalid item in the transfer Org. :' ||
324: p_mtl_trx_tbl(i).inventory_item_id, 9);
325: END IF;
326: fnd_message.set_name('INV', 'INV_INT_ITMCODE');
327: fnd_msg_pub.ADD;
328: RAISE fnd_api.g_exc_error;
329:
330: END IF;
331: END IF;

Line 346: fnd_msg_pub.ADD;

342: IF (l_debug = 1) THEN
343: debug_print('Both release id and po header id are null. One of them should have a valid value', 9);
344: END IF;
345: fnd_message.set_name('INV', 'INV_INT_RETCODE');
346: fnd_msg_pub.ADD;
347: RAISE fnd_api.g_exc_error;
348:
349: END IF;
350:

Line 358: fnd_msg_pub.ADD;

354: IF (l_debug = 1) THEN
355: debug_print('The old PO price and the new PO price shouldnt be null', 9);
356: END IF;
357: fnd_message.set_name('INV', 'INV_INT_RETQTYCODE');
358: fnd_msg_pub.ADD;
359: RAISE fnd_api.g_exc_error;
360:
361: END IF;
362:

Line 372: fnd_msg_pub.ADD;

368: IF (l_debug = 1) THEN
369: debug_print('Transaction Source ID is null', 9);
370: END IF;
371: fnd_message.set_name('INV', 'INV_INT_PO');
372: fnd_msg_pub.ADD;
373: RAISE fnd_api.g_exc_error;
374:
375: END IF;
376:

Line 390: fnd_msg_pub.ADD;

386: IF (l_debug = 1) THEN
387: debug_print('Cannot find the purchase order information or the po is invalid', 9);
388: END IF;
389: fnd_message.set_name('INV', 'INV_INT_PO');
390: fnd_msg_pub.ADD;
391: RAISE fnd_api.g_exc_error;
392: END;
393:
394: IF (l_count <> 1) THEN

Line 400: fnd_msg_pub.ADD;

396: IF (l_debug = 1) THEN
397: debug_print('Invalid puchase order header ID :' || p_mtl_trx_tbl(i).transaction_source_id, 9);
398: END IF;
399: fnd_message.set_name('INV', 'INV_INT_PO');
400: fnd_msg_pub.ADD;
401: RAISE fnd_api.g_exc_error;
402:
403: END IF;
404:

Line 424: fnd_msg_pub.ADD;

420: debug_print('Cannot find the specified subinventory :'
421: || p_mtl_trx_tbl(i).locator_id, 9);
422: END IF;
423: fnd_message.set_name('INV', 'INV_INT_SUBCODE');
424: fnd_msg_pub.ADD;
425: RAISE fnd_api.g_exc_error;
426: END;
427:
428: IF (l_count <> 1) THEN

Line 434: fnd_msg_pub.ADD;

430: debug_print('Invalid subinventory :' ||
431: p_mtl_trx_tbl(i).subinventory_code, 9);
432: END IF;
433: fnd_message.set_name('INV', 'INV_INT_SUBCODE');
434: fnd_msg_pub.ADD;
435: RAISE fnd_api.g_exc_error;
436:
437: END IF;
438:

Line 465: fnd_msg_pub.ADD;

461: IF (l_debug = 1) THEN
462: debug_print('Restricted Subinevntory', 9);
463: END IF;
464: fnd_message.set_name('INV', 'INV_INT_SUBCODE');
465: fnd_msg_pub.ADD;
466: RAISE fnd_api.g_exc_error;
467: END;
468:
469: IF (l_count <> 1) THEN

Line 474: fnd_msg_pub.ADD;

470: IF (l_debug = 1) THEN
471: debug_print('Invalid subinventory', 9);
472: END IF;
473: fnd_message.set_name('INV', 'INV_INT_SUBCODE');
474: fnd_msg_pub.ADD;
475: RAISE fnd_api.g_exc_error;
476:
477: END IF;
478:

Line 499: fnd_msg_pub.ADD;

495: debug_print('Cannot find the specified locator :'
496: || p_mtl_trx_tbl(i).locator_id, 9);
497: END IF;
498: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
499: fnd_msg_pub.ADD;
500: RAISE fnd_api.g_exc_error;
501: END;
502:
503: IF (l_count <> 1) THEN

Line 509: fnd_msg_pub.ADD;

505: debug_print('Invalid locator :' ||
506: p_mtl_trx_tbl(i).locator_id, 9);
507: END IF;
508: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
509: fnd_msg_pub.ADD;
510: RAISE fnd_api.g_exc_error;
511:
512: END IF;
513:

Line 541: fnd_msg_pub.ADD;

537: IF (l_debug = 1) THEN
538: debug_print('Restricted Sub/loc', 9);
539: END IF;
540: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
541: fnd_msg_pub.ADD;
542: RAISE fnd_api.g_exc_error;
543: END;
544:
545: IF (l_count <> 1) THEN

Line 550: fnd_msg_pub.ADD;

546: IF (l_debug = 1) THEN
547: debug_print('Invalid locator', 9);
548: END IF;
549: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
550: fnd_msg_pub.ADD;
551: RAISE fnd_api.g_exc_error;
552:
553: END IF;
554:

Line 579: fnd_msg_pub.ADD;

575: IF (l_debug = 1) THEN
576: debug_print('Drop Ship Source not found', 9);
577: END IF;
578: fnd_message.set_name('INV', 'INV_INT_SRCCODE');
579: fnd_msg_pub.ADD;
580: RAISE fnd_api.g_exc_error;
581: END;
582:
583: l_count := 0;

Line 598: fnd_msg_pub.ADD;

594: IF (l_debug = 1) THEN
595: debug_print('Sales Order is not valid for the current date', 9);
596: END IF;
597: fnd_message.set_name('INV', 'INV_INT_SALEXP');
598: fnd_msg_pub.ADD;
599: RAISE fnd_api.g_exc_error;
600: END;
601:
602: IF (l_count <> 1) THEN

Line 607: fnd_msg_pub.ADD;

603: IF (l_debug = 1) THEN
604: debug_print('Cannot find the sales order or sales order IS NOT active', 9);
605: END IF;
606: fnd_message.set_name('INV', 'INV_INT_SALEXP');
607: fnd_msg_pub.ADD;
608: RAISE fnd_api.g_exc_error;
609:
610: END IF;
611:

Line 626: fnd_msg_pub.ADD;

622: IF (l_debug = 1) THEN
623: debug_print('Invalid transaction quantity : quantity should be negative', 9);
624: END IF;
625: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY');
626: fnd_msg_pub.ADD;
627: RAISE fnd_api.g_exc_error;
628: END IF;
629:
630: IF (p_mtl_trx_tbl(i).transaction_quantity < 0) AND

Line 638: fnd_msg_pub.ADD;

634: IF (l_debug = 1) THEN
635: debug_print('Invalid transaction quantity : quantity should be positive', 9);
636: END IF;
637: fnd_message.set_name('INV', 'INV_INVALID_QUANTITY');
638: fnd_msg_pub.ADD;
639: RAISE fnd_api.g_exc_error;
640: END IF;
641: ******/
642: --13. Validate distribution account id

Line 653: fnd_msg_pub.ADD;

649: IF (l_debug = 1) THEN
650: debug_print('Distribution account is null', 9);
651: END IF;
652: fnd_message.set_name('INV', 'INV_INT_DISTCODE');
653: fnd_msg_pub.ADD;
654: RAISE fnd_api.g_exc_error;
655: END IF;
656:
657: debug_print('Distribution account :' ||

Line 677: fnd_msg_pub.ADD;

673: debug_print('Distribution account not found :' ||
674: p_mtl_trx_tbl(i).distribution_account_id, 9);
675: END IF;
676: fnd_message.set_name('INV', 'INV_INT_DISTCODE');
677: fnd_msg_pub.ADD;
678: RAISE fnd_api.g_exc_error;
679: END;
680:
681: IF (l_count <> 1) THEN

Line 688: fnd_msg_pub.ADD;

684: debug_print('Invalid distribution account :' ||
685: p_mtl_trx_tbl(i).distribution_account_id, 9);
686: END IF;
687: fnd_message.set_name('INV', 'INV_INT_DISTCODE');
688: fnd_msg_pub.ADD;
689: RAISE fnd_api.g_exc_error;
690:
691: END IF;
692:

Line 730: fnd_msg_pub.ADD;

726: debug_print('Period not open', 9);
727: END IF;
728: -- FND_MESSAGE.set_name('INV', 'INV_INT_PRDCODE');
729: FND_MESSAGE.set_name('INV', 'INV_NO_OPEN_PERIOD');
730: fnd_msg_pub.ADD;
731: RAISE fnd_api.g_exc_error;
732:
733: END IF;
734:

Line 743: fnd_msg_pub.ADD;

739: debug_print('Invalid Account Period ID passed : ' ||
740: p_mtl_trx_tbl(i).acct_period_id || ' is not the same as ' || l_acct_period_id, 9);
741: END IF;
742: FND_MESSAGE.set_name('INV', 'INV_NO_OPEN_PERIOD');
743: fnd_msg_pub.ADD;
744: RAISE fnd_api.g_exc_error;
745:
746: END IF;
747:

Line 765: fnd_msg_pub.ADD;

761: debug_print('Invalid Transaction UOM : ' ||
762: p_mtl_trx_tbl(i).transaction_uom, 9);
763: END IF;
764: fnd_message.set_name('INV', 'INV_INT_UOMCODE');
765: fnd_msg_pub.ADD;
766: RAISE fnd_api.g_exc_error;
767: END;
768:
769: IF (l_count) = 0 THEN

Line 775: fnd_msg_pub.ADD;

771: debug_print('Transaction UOM : ' ||
772: p_mtl_trx_tbl(i).transaction_uom || ' not found', 9);
773: END IF;
774: fnd_message.set_name('INV', 'INV_INT_UOMCODE');
775: fnd_msg_pub.ADD;
776: RAISE fnd_api.g_exc_error;
777:
778: END IF;
779:

Line 788: fnd_msg_pub.ADD;

784: IF (l_debug = 1) THEN
785: debug_print('Invalid Cost Group', 9);
786: END IF;
787: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
788: fnd_msg_pub.ADD;
789: RAISE fnd_api.g_exc_error;
790:
791: END IF;
792:

Line 807: fnd_msg_pub.ADD;

803: IF (l_debug = 1) THEN
804: debug_print('Cost Group not found', 9);
805: END IF;
806: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
807: fnd_msg_pub.ADD;
808: RAISE fnd_api.g_exc_error;
809: END;
810:
811: IF (l_count = 0) THEN

Line 816: fnd_msg_pub.ADD;

812: IF (l_debug = 1) THEN
813: debug_print('Cost Group not found : ' || p_mtl_trx_tbl(i).cost_group_id, 9);
814: END IF;
815: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
816: fnd_msg_pub.ADD;
817: RAISE fnd_api.g_exc_error;
818:
819: END IF;
820:

Line 834: fnd_msg_pub.ADD;

830: IF (l_debug = 1) THEN
831: debug_print('Invalid Cost Group in the Transfer Org.', 9);
832: END IF;
833: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
834: fnd_msg_pub.ADD;
835: RAISE fnd_api.g_exc_error;
836:
837: END IF;
838:

Line 853: fnd_msg_pub.ADD;

849: IF (l_debug = 1) THEN
850: debug_print('Cost Group not found', 9);
851: END IF;
852: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
853: fnd_msg_pub.ADD;
854: RAISE fnd_api.g_exc_error;
855: END;
856:
857: IF (l_count = 0) THEN

Line 862: fnd_msg_pub.ADD;

858: IF (l_debug = 1) THEN
859: debug_print('Transfer Cost Group not found : ' || p_mtl_trx_tbl(i).transfer_cost_group_id , 9);
860: END IF;
861: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
862: fnd_msg_pub.ADD;
863: RAISE fnd_api.g_exc_error;
864:
865: END IF;
866:

Line 878: fnd_msg_pub.ADD;

874: IF (l_debug = 1) THEN
875: debug_print('Transaction batch and sequence are not populated', 9);
876: END IF;
877: fnd_message.set_name('INV', 'INV_INVALID_BATCH');
878: fnd_msg_pub.ADD;
879: RAISE fnd_api.g_exc_error;
880:
881: END IF;
882:

Line 905: fnd_msg_pub.ADD;

901: IF (l_debug = 1) THEN
902: debug_print('Invalid Locator ID', 9);
903: END IF;
904: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
905: fnd_msg_pub.ADD;
906: RAISE fnd_api.g_exc_error;
907: END;
908:
909:

Line 917: fnd_msg_pub.ADD;

913: IF (l_debug = 1) THEN
914: debug_print('Invalid Project', 9);
915: END IF;
916: fnd_message.set_name('INV', 'INV_NO_PROJECT');
917: fnd_msg_pub.ADD;
918: RAISE fnd_api.g_exc_error;
919:
920: END IF;
921:

Line 931: fnd_msg_pub.ADD;

927: IF (l_debug = 1) THEN
928: debug_print('Invalid Task', 9);
929: END IF;
930: fnd_message.set_name('INV', 'INV_NO_PROJECT');
931: fnd_msg_pub.ADD;
932: RAISE fnd_api.g_exc_error;
933:
934: END IF;
935:

Line 958: fnd_msg_pub.ADD;

954: IF (l_debug = 1) THEN
955: debug_print('Transaction Source ID is null', 9);
956: END IF;
957: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
958: fnd_msg_pub.ADD;
959: RAISE fnd_api.g_exc_error;
960:
961: END IF;
962:

Line 975: fnd_msg_pub.ADD;

971: IF (l_debug = 1) THEN
972: debug_print('Cannot find the sales order information', 9);
973: END IF;
974: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
975: fnd_msg_pub.ADD;
976: RAISE fnd_api.g_exc_error;
977: END;
978:
979: IF (l_count <> 1) THEN

Line 985: fnd_msg_pub.ADD;

981: IF (l_debug = 1) THEN
982: debug_print('Invalid sales order ID :' || p_mtl_trx_tbl(i).transaction_source_id, 9);
983: END IF;
984: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
985: fnd_msg_pub.ADD;
986: RAISE fnd_api.g_exc_error;
987:
988: END IF;
989:

Line 1010: fnd_msg_pub.ADD;

1006: IF (l_debug = 1) THEN
1007: debug_print('Transaction Source ID/rcv_transaction_id is null', 9);
1008: END IF;
1009: fnd_message.set_name('INV', 'INV_INT_PO');
1010: fnd_msg_pub.ADD;
1011: RAISE fnd_api.g_exc_error;
1012:
1013: END IF;
1014:

Line 1030: fnd_msg_pub.ADD;

1026: IF (l_debug = 1) THEN
1027: debug_print('Cannot find the purchase order information', 9);
1028: END IF;
1029: fnd_message.set_name('INV', 'INV_INT_PO');
1030: fnd_msg_pub.ADD;
1031: RAISE fnd_api.g_exc_error;
1032: END;
1033:
1034: IF (l_count <> 1) THEN

Line 1040: fnd_msg_pub.ADD;

1036: IF (l_debug = 1) THEN
1037: debug_print('Invalid puchase order header ID :' || p_mtl_trx_tbl(i).transaction_source_id, 9);
1038: END IF;
1039: fnd_message.set_name('INV', 'INV_INT_PO');
1040: fnd_msg_pub.ADD;
1041: RAISE fnd_api.g_exc_error;
1042:
1043: END IF;
1044:

Line 1062: fnd_msg_pub.ADD;

1058: IF (l_debug = 1) THEN
1059: debug_print('Trx source line ID is null', 9);
1060: END IF;
1061: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
1062: fnd_msg_pub.ADD;
1063: RAISE fnd_api.g_exc_error;
1064:
1065: END IF;
1066:

Line 1078: fnd_msg_pub.ADD;

1074: IF (l_debug = 1) THEN
1075: debug_print('Cannot find the sales order line information', 9);
1076: END IF;
1077: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
1078: fnd_msg_pub.ADD;
1079: RAISE fnd_api.g_exc_error;
1080: END;
1081:
1082: IF (l_count <> 1) THEN

Line 1088: fnd_msg_pub.ADD;

1084: IF (l_debug = 1) THEN
1085: debug_print('Invalid sales order line :' || p_mtl_trx_tbl(i).transaction_source_id, 9);
1086: END IF;
1087: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
1088: fnd_msg_pub.ADD;
1089: RAISE fnd_api.g_exc_error;
1090:
1091: END IF;
1092:

Line 1108: fnd_msg_pub.ADD;

1104: IF (l_debug = 1) THEN
1105: debug_print('Invoiced flag is not set to N ', 9);
1106: END IF;
1107: fnd_message.set_name('INV', 'INV_INT_INVOICE_FLAG');
1108: fnd_msg_pub.ADD;
1109: RAISE fnd_api.g_exc_error;
1110:
1111: END IF;
1112:

Line 1120: fnd_msg_pub.ADD;

1116: IF (l_debug = 1) THEN
1117: debug_print('I/C cost cannot be null ', 9);
1118: END IF;
1119: fnd_message.set_name('INV', 'INV_INT_IC_COST');
1120: fnd_msg_pub.ADD;
1121: RAISE fnd_api.g_exc_error;
1122:
1123: END IF;
1124:

Line 1133: fnd_msg_pub.ADD;

1129: IF (l_debug = 1) THEN
1130: debug_print('Costed flag is not set to N ', 9);
1131: END IF;
1132: fnd_message.set_name('INV', 'INV_INT_COSTED_FLAG');
1133: fnd_msg_pub.ADD;
1134: RAISE fnd_api.g_exc_error;
1135:
1136: END IF;
1137:

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

1148: debug_print('Expected Error', 9);
1149: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1150: END IF;
1151: x_return_status := FND_API.G_RET_STS_ERROR;
1152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1153:
1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1155: IF (l_debug = 1) THEN
1156: debug_print('Unexpected Error', 9);

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

1156: debug_print('Unexpected Error', 9);
1157: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1158: END IF;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1160: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1161:
1162: WHEN OTHERS THEN
1163: IF (l_debug = 1) THEN
1164: debug_print('Error Type Others', 9);

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

1164: debug_print('Error Type Others', 9);
1165: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1166: END IF;
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1168: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1169:
1170: END validate_input_parameters;
1171:
1172:

Line 1248: fnd_msg_pub.initialize;

1244:
1245: --
1246: -- Initialize message list.
1247: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1248: fnd_msg_pub.initialize;
1249: END IF;
1250:
1251: IF (p_logical_trx_type_code = INV_LOGICAL_TRANSACTIONS_PUB.G_LOGTRXCODE_RETROPRICEUPD) THEN
1252: l_logical_transaction := 2;

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

1431: debug_print('Expected Error', 9);
1432: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1433: debug_print('Return Status :' || x_return_status);
1434: END IF;
1435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1436:
1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: IF (l_debug = 1) THEN

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

1440: debug_print('Expected Error', 9);
1441: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1442: debug_print('Return Status :' || x_return_status);
1443: END IF;
1444: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1445:
1446: WHEN OTHERS THEN
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: IF (l_debug = 1) THEN

Line 1453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>

1449: debug_print('Error type others', 9);
1450: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1451: debug_print('Return Status :' || x_return_status);
1452: END IF;
1453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>
1454: x_msg_data);
1455:
1456: END inv_mmt_insert;
1457:

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

2080: debug_print('Expected Error', 9);
2081: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2082: debug_print('Return Status :' || x_return_status);
2083: END IF;
2084: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2085:
2086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2088: IF (l_debug = 1) THEN

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

2089: debug_print('Expected Error', 9);
2090: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2091: debug_print('Return Status :' || x_return_status);
2092: END IF;
2093: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2094:
2095: WHEN OTHERS THEN
2096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2097: IF (l_debug = 1) THEN

Line 2102: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>

2098: debug_print('Error type others', 9);
2099: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2100: debug_print('Return Status :' || x_return_status);
2101: END IF;
2102: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>
2103: x_msg_data);
2104: END inv_lot_serial_insert;
2105:
2106: PROCEDURE generate_serial_numbers

Line 2181: FND_MSG_PUB.ADD;

2177: debug_print('error code: ' || l_errorcode, 9);
2178: END IF;
2179:
2180: FND_MESSAGE.SET_NAME('INV', 'INV_GET_SER_INFO_ERR');
2181: FND_MSG_PUB.ADD;
2182: RAISE FND_API.G_EXC_ERROR;
2183: END IF;
2184:
2185: IF (l_debug = 1) THEN

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

2220: debug_print('Expected Error', 9);
2221: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2222: debug_print('Return Status :' || x_return_status);
2223: END IF;
2224: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2225:
2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2228: IF (l_debug = 1) THEN

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

2229: debug_print('Expected Error', 9);
2230: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2231: debug_print('Return Status :' || x_return_status);
2232: END IF;
2233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2234:
2235: WHEN OTHERS THEN
2236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2237: IF (l_debug = 1) THEN

Line 2242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>

2238: debug_print('Error type others', 9);
2239: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2240: debug_print('Return Status :' || x_return_status);
2241: END IF;
2242: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>
2243: x_msg_data);
2244: END generate_serial_numbers;
2245:
2246: PROCEDURE inv_mut_insert

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

2549: debug_print('Expected Error', 9);
2550: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2551: debug_print('Return Status :' || x_return_status);
2552: END IF;
2553: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2554:
2555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2557: IF (l_debug = 1) THEN

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

2558: debug_print('Expected Error', 9);
2559: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2560: debug_print('Return Status :' || x_return_status);
2561: END IF;
2562: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2563:
2564: WHEN OTHERS THEN
2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2566: IF (l_debug = 1) THEN

Line 2571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>

2567: debug_print('Error type others', 9);
2568: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2569: debug_print('Return Status :' || x_return_status);
2570: END IF;
2571: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>
2572: x_msg_data);
2573:
2574: END inv_mut_insert;
2575:

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

2611: debug_print('Expected Error', 9);
2612: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2613: debug_print('Return Status :' || x_return_status);
2614: END IF;
2615: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2616:
2617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2619: IF (l_debug = 1) THEN

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

2620: debug_print('Expected Error', 9);
2621: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2622: debug_print('Return Status :' || x_return_status);
2623: END IF;
2624: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2625:
2626: WHEN OTHERS THEN
2627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2628: IF (l_debug = 1) THEN

Line 2633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>

2629: debug_print('Error type others', 9);
2630: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2631: debug_print('Return Status :' || x_return_status);
2632: END IF;
2633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data =>
2634: x_msg_data);
2635: END update_serial_numbers;
2636:
2637: END inv_logical_transactions_pvt;