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_API

Line 25: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

21: x_return_status OUT NOCOPY VARCHAR2
22: , x_msg_count OUT NOCOPY NUMBER
23: , x_msg_data OUT NOCOPY VARCHAR2
24: , p_api_version_number IN NUMBER
25: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
26: , p_mtl_trx_tbl IN inv_logical_transaction_global.mtl_trx_tbl_type
27: , p_validation_level IN VARCHAR2
28: , p_logical_trx_type_code IN NUMBER
29: ) IS

Line 31: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

27: , p_validation_level IN VARCHAR2
28: , p_logical_trx_type_code IN NUMBER
29: ) IS
30:
31: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
32: l_count NUMBER := 0;
33: l_so_line_id NUMBER := 0;
34: l_so_header_id NUMBER := 0;
35: l_order_number VARCHAR2(40);

Line 57: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN

53: BEGIN
54:
55: --
56: -- Standard call to check for call compatibility
57: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
58: RAISE fnd_api.g_exc_unexpected_error;
59: END IF;
60:
61: --

Line 58: RAISE fnd_api.g_exc_unexpected_error;

54:
55: --
56: -- Standard call to check for call compatibility
57: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
58: RAISE fnd_api.g_exc_unexpected_error;
59: END IF;
60:
61: --
62: -- Initialize message list.

Line 63: IF fnd_api.to_boolean(p_init_msg_lst) THEN

59: END IF;
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:

Line 90: RAISE fnd_api.g_exc_error;

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:
94: -- For sales order transactions, we do not have to validate them

Line 97: IF (p_validation_level = fnd_api.g_true) THEN

93:
94: -- For sales order transactions, we do not have to validate them
95: -- since they are already validated by INV TM
96:
97: IF (p_validation_level = fnd_api.g_true) THEN
98:
99: --2. Validate Transaction Action, Source and Type
100:
101: IF (p_mtl_trx_tbl(i).transaction_type_id) IS NULL THEN

Line 107: RAISE fnd_api.g_exc_error;

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:
111: BEGIN

Line 126: RAISE fnd_api.g_exc_error;

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
130: IF (l_debug = 1) THEN

Line 135: RAISE fnd_api.g_exc_error;

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:
139: IF (l_debug = 1) THEN

Line 159: RAISE fnd_api.g_exc_error;

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

Line 178: RAISE fnd_api.g_exc_error;

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

Line 201: RAISE fnd_api.g_exc_error;

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
205: IF (l_debug = 1) THEN

Line 211: RAISE fnd_api.g_exc_error;

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:
215: --4. Validate Transfer Organization

Line 233: RAISE fnd_api.g_exc_error;

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
237: SELECT COUNT(1) INTO l_count

Line 251: RAISE fnd_api.g_exc_error;

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
255: IF (l_debug = 1) THEN

Line 262: RAISE fnd_api.g_exc_error;

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

Line 282: RAISE fnd_api.g_exc_error;

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
286: IF (l_debug = 1) THEN

Line 292: RAISE fnd_api.g_exc_error;

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:
296: --6. Validate Item for the transfer organization - only if the

Line 318: RAISE fnd_api.g_exc_error;

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
322: IF (l_debug = 1) THEN

Line 328: RAISE fnd_api.g_exc_error;

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

Line 347: RAISE fnd_api.g_exc_error;

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:
351: IF (p_mtl_trx_tbl(i).old_po_price IS NULL or

Line 359: RAISE fnd_api.g_exc_error;

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:
363: --8. Check for invalid PO header ID

Line 373: RAISE fnd_api.g_exc_error;

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:
377: BEGIN

Line 391: RAISE fnd_api.g_exc_error;

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

Line 401: RAISE fnd_api.g_exc_error;

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:
405: END IF;

Line 425: RAISE fnd_api.g_exc_error;

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
429: IF (l_debug = 1) THEN

Line 435: RAISE fnd_api.g_exc_error;

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:
439: l_count := 0;

Line 466: RAISE fnd_api.g_exc_error;

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
470: IF (l_debug = 1) THEN

Line 475: RAISE fnd_api.g_exc_error;

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:
479: END IF;

Line 500: RAISE fnd_api.g_exc_error;

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
504: IF (l_debug = 1) THEN

Line 510: RAISE fnd_api.g_exc_error;

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:
514: l_count := 0;

Line 542: RAISE fnd_api.g_exc_error;

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
546: IF (l_debug = 1) THEN

Line 551: RAISE fnd_api.g_exc_error;

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:
555: END IF;

Line 580: RAISE fnd_api.g_exc_error;

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;
584: BEGIN

Line 599: RAISE fnd_api.g_exc_error;

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
603: IF (l_debug = 1) THEN

Line 608: RAISE fnd_api.g_exc_error;

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:
612: END IF;

Line 627: RAISE fnd_api.g_exc_error;

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
631: (p_mtl_trx_tbl(i).transaction_action_id in

Line 639: RAISE fnd_api.g_exc_error;

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
643: -- Assumption is that the distribution account id should have been

Line 654: RAISE fnd_api.g_exc_error;

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 :' ||
658: p_mtl_trx_tbl(i).distribution_account_id, 9);

Line 678: RAISE fnd_api.g_exc_error;

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

Line 689: RAISE fnd_api.g_exc_error;

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

Line 749: RAISE fnd_api.g_exc_error;

745: END IF;
746: -- FND_MESSAGE.set_name('INV', 'INV_INT_PRDCODE');
747: FND_MESSAGE.set_name('INV', 'INV_NO_OPEN_PERIOD');
748: fnd_msg_pub.ADD;
749: RAISE fnd_api.g_exc_error;
750:
751: END IF;
752:
753: IF (((p_mtl_trx_tbl(i).acct_period_id IS NOT NULL) AND

Line 762: RAISE fnd_api.g_exc_error;

758: p_mtl_trx_tbl(i).acct_period_id || ' is not the same as ' || l_acct_period_id, 9);
759: END IF;
760: FND_MESSAGE.set_name('INV', 'INV_NO_OPEN_PERIOD');
761: fnd_msg_pub.ADD;
762: RAISE fnd_api.g_exc_error;
763:
764: END IF;
765:
766: --15. Validate transaction UOM

Line 784: RAISE fnd_api.g_exc_error;

780: p_mtl_trx_tbl(i).transaction_uom, 9);
781: END IF;
782: fnd_message.set_name('INV', 'INV_INT_UOMCODE');
783: fnd_msg_pub.ADD;
784: RAISE fnd_api.g_exc_error;
785: END;
786:
787: IF (l_count) = 0 THEN
788: IF (l_debug = 1) THEN

Line 794: RAISE fnd_api.g_exc_error;

790: p_mtl_trx_tbl(i).transaction_uom || ' not found', 9);
791: END IF;
792: fnd_message.set_name('INV', 'INV_INT_UOMCODE');
793: fnd_msg_pub.ADD;
794: RAISE fnd_api.g_exc_error;
795:
796: END IF;
797:
798: --16. Validate cost groups. Cost groups should already be populated

Line 807: RAISE fnd_api.g_exc_error;

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

Line 826: RAISE fnd_api.g_exc_error;

822: debug_print('Cost Group not found', 9);
823: END IF;
824: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
825: fnd_msg_pub.ADD;
826: RAISE fnd_api.g_exc_error;
827: END;
828:
829: IF (l_count = 0) THEN
830: IF (l_debug = 1) THEN

Line 835: RAISE fnd_api.g_exc_error;

831: debug_print('Cost Group not found : ' || p_mtl_trx_tbl(i).cost_group_id, 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:
839: -- 17. Validate cost groups for transfer organziations.

Line 853: RAISE fnd_api.g_exc_error;

849: debug_print('Invalid Cost Group in the Transfer Org.', 9);
850: END IF;
851: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
852: fnd_msg_pub.ADD;
853: RAISE fnd_api.g_exc_error;
854:
855: END IF;
856:
857: l_count := 0;

Line 872: RAISE fnd_api.g_exc_error;

868: debug_print('Cost Group not found', 9);
869: END IF;
870: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
871: fnd_msg_pub.ADD;
872: RAISE fnd_api.g_exc_error;
873: END;
874:
875: IF (l_count = 0) THEN
876: IF (l_debug = 1) THEN

Line 881: RAISE fnd_api.g_exc_error;

877: debug_print('Transfer Cost Group not found : ' || p_mtl_trx_tbl(i).transfer_cost_group_id , 9);
878: END IF;
879: fnd_message.set_name('INV', 'INV_INT_CSTGRP');
880: fnd_msg_pub.ADD;
881: RAISE fnd_api.g_exc_error;
882:
883: END IF;
884:
885:

Line 897: RAISE fnd_api.g_exc_error;

893: debug_print('Transaction batch and sequence are not populated', 9);
894: END IF;
895: fnd_message.set_name('INV', 'INV_INVALID_BATCH');
896: fnd_msg_pub.ADD;
897: RAISE fnd_api.g_exc_error;
898:
899: END IF;
900:
901: --19. If the locator is passed and it is project enabled, we would

Line 924: RAISE fnd_api.g_exc_error;

920: debug_print('Invalid Locator ID', 9);
921: END IF;
922: fnd_message.set_name('INV', 'INV_INT_LOCCODE');
923: fnd_msg_pub.ADD;
924: RAISE fnd_api.g_exc_error;
925: END;
926:
927:
928: IF (l_project_id IS NOT NULL) THEN

Line 936: RAISE fnd_api.g_exc_error;

932: debug_print('Invalid Project', 9);
933: END IF;
934: fnd_message.set_name('INV', 'INV_NO_PROJECT');
935: fnd_msg_pub.ADD;
936: RAISE fnd_api.g_exc_error;
937:
938: END IF;
939:
940: END IF;

Line 950: RAISE fnd_api.g_exc_error;

946: debug_print('Invalid Task', 9);
947: END IF;
948: fnd_message.set_name('INV', 'INV_NO_PROJECT');
949: fnd_msg_pub.ADD;
950: RAISE fnd_api.g_exc_error;
951:
952: END IF;
953:
954: END IF;

Line 977: RAISE fnd_api.g_exc_error;

973: debug_print('Transaction Source ID is null', 9);
974: END IF;
975: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
976: fnd_msg_pub.ADD;
977: RAISE fnd_api.g_exc_error;
978:
979: END IF;
980:
981:

Line 994: RAISE fnd_api.g_exc_error;

990: debug_print('Cannot find the sales order information', 9);
991: END IF;
992: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
993: fnd_msg_pub.ADD;
994: RAISE fnd_api.g_exc_error;
995: END;
996:
997: IF (l_count <> 1) THEN
998:

Line 1004: RAISE fnd_api.g_exc_error;

1000: debug_print('Invalid sales order ID :' || p_mtl_trx_tbl(i).transaction_source_id, 9);
1001: END IF;
1002: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
1003: fnd_msg_pub.ADD;
1004: RAISE fnd_api.g_exc_error;
1005:
1006: END IF;
1007:
1008: END IF;

Line 1029: RAISE fnd_api.g_exc_error;

1025: debug_print('Transaction Source ID/rcv_transaction_id is null', 9);
1026: END IF;
1027: fnd_message.set_name('INV', 'INV_INT_PO');
1028: fnd_msg_pub.ADD;
1029: RAISE fnd_api.g_exc_error;
1030:
1031: END IF;
1032:
1033: BEGIN

Line 1049: RAISE fnd_api.g_exc_error;

1045: debug_print('Cannot find the purchase order information', 9);
1046: END IF;
1047: fnd_message.set_name('INV', 'INV_INT_PO');
1048: fnd_msg_pub.ADD;
1049: RAISE fnd_api.g_exc_error;
1050: END;
1051:
1052: IF (l_count <> 1) THEN
1053:

Line 1059: RAISE fnd_api.g_exc_error;

1055: debug_print('Invalid puchase order header ID :' || p_mtl_trx_tbl(i).transaction_source_id, 9);
1056: END IF;
1057: fnd_message.set_name('INV', 'INV_INT_PO');
1058: fnd_msg_pub.ADD;
1059: RAISE fnd_api.g_exc_error;
1060:
1061: END IF;
1062:
1063: END IF;

Line 1081: RAISE fnd_api.g_exc_error;

1077: debug_print('Trx source line ID is null', 9);
1078: END IF;
1079: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
1080: fnd_msg_pub.ADD;
1081: RAISE fnd_api.g_exc_error;
1082:
1083: END IF;
1084:
1085: BEGIN

Line 1097: RAISE fnd_api.g_exc_error;

1093: debug_print('Cannot find the sales order line information', 9);
1094: END IF;
1095: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
1096: fnd_msg_pub.ADD;
1097: RAISE fnd_api.g_exc_error;
1098: END;
1099:
1100: IF (l_count <> 1) THEN
1101:

Line 1107: RAISE fnd_api.g_exc_error;

1103: debug_print('Invalid sales order line :' || p_mtl_trx_tbl(i).transaction_source_id, 9);
1104: END IF;
1105: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
1106: fnd_msg_pub.ADD;
1107: RAISE fnd_api.g_exc_error;
1108:
1109: END IF;
1110:
1111:

Line 1127: RAISE fnd_api.g_exc_error;

1123: debug_print('Invoiced flag is not set to N ', 9);
1124: END IF;
1125: fnd_message.set_name('INV', 'INV_INT_INVOICE_FLAG');
1126: fnd_msg_pub.ADD;
1127: RAISE fnd_api.g_exc_error;
1128:
1129: END IF;
1130:
1131: IF (p_mtl_trx_tbl(i).intercompany_cost IS NULL) OR

Line 1139: RAISE fnd_api.g_exc_error;

1135: debug_print('I/C cost cannot be null ', 9);
1136: END IF;
1137: fnd_message.set_name('INV', 'INV_INT_IC_COST');
1138: fnd_msg_pub.ADD;
1139: RAISE fnd_api.g_exc_error;
1140:
1141: END IF;
1142:
1143: END IF;

Line 1152: RAISE fnd_api.g_exc_error;

1148: debug_print('Costed flag is not set to N ', 9);
1149: END IF;
1150: fnd_message.set_name('INV', 'INV_INT_COSTED_FLAG');
1151: fnd_msg_pub.ADD;
1152: RAISE fnd_api.g_exc_error;
1153:
1154: END IF;
1155:
1156: END IF; -- If p_validation level set to true.

Line 1164: WHEN FND_API.G_EXC_ERROR THEN

1160:
1161: x_return_status := l_return_status;
1162:
1163: EXCEPTION
1164: WHEN FND_API.G_EXC_ERROR THEN
1165: IF (l_debug = 1) THEN
1166: debug_print('Expected Error', 9);
1167: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1168: END IF;

Line 1169: x_return_status := FND_API.G_RET_STS_ERROR;

1165: IF (l_debug = 1) THEN
1166: debug_print('Expected Error', 9);
1167: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1168: END IF;
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1171:
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: IF (l_debug = 1) THEN

Line 1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1168: END IF;
1169: x_return_status := FND_API.G_RET_STS_ERROR;
1170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1171:
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: IF (l_debug = 1) THEN
1174: debug_print('Unexpected Error', 9);
1175: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1176: END IF;

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1173: IF (l_debug = 1) THEN
1174: debug_print('Unexpected Error', 9);
1175: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1176: END IF;
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1179:
1180: WHEN OTHERS THEN
1181: IF (l_debug = 1) THEN

Line 1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1181: IF (l_debug = 1) THEN
1182: debug_print('Error Type Others', 9);
1183: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1184: END IF;
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1187:
1188: END validate_input_parameters;
1189:

Line 1201: | Should be fnd_api.g_false or fnd_api.g_true |

1197: | |
1198: | Input Parameters : |
1199: | p_api_version_number - API version number |
1200: | p_init_msg_lst - Whether initialize the error message list or not|
1201: | Should be fnd_api.g_false or fnd_api.g_true |
1202: | p_mtl_trx_rec - An array of mtl_trx_rec_type records |
1203: | |
1204: | Output Parameters : |
1205: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |

Line 1205: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |

1201: | Should be fnd_api.g_false or fnd_api.g_true |
1202: | p_mtl_trx_rec - An array of mtl_trx_rec_type records |
1203: | |
1204: | Output Parameters : |
1205: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1206: | fnd_api.g_ret_sts_exc_error, if an expected |
1207: | error occurred |
1208: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1209: | eror occurred |

Line 1206: | fnd_api.g_ret_sts_exc_error, if an expected |

1202: | p_mtl_trx_rec - An array of mtl_trx_rec_type records |
1203: | |
1204: | Output Parameters : |
1205: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1206: | fnd_api.g_ret_sts_exc_error, if an expected |
1207: | error occurred |
1208: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1209: | eror occurred |
1210: | x_msg_count - Number of error message in the error message |

Line 1208: | fnd_api.g_ret_sts_unexp_error, if an unexpected |

1204: | Output Parameters : |
1205: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1206: | fnd_api.g_ret_sts_exc_error, if an expected |
1207: | error occurred |
1208: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1209: | eror occurred |
1210: | x_msg_count - Number of error message in the error message |
1211: | list |
1212: | x_msg_data - If the number of error message in the error |

Line 1222: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1218: x_return_status OUT NOCOPY VARCHAR2
1219: , x_msg_count OUT NOCOPY NUMBER
1220: , x_msg_data OUT NOCOPY VARCHAR2
1221: , p_api_version_number IN NUMBER
1222: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1223: , p_mtl_trx_tbl IN inv_logical_transaction_global.mtl_trx_tbl_type
1224: , p_logical_trx_type_code IN NUMBER
1225:
1226:

Line 1259: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN

1255: END IF;
1256:
1257: --
1258: -- Standard call to check for call compatibility
1259: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
1260: RAISE fnd_api.g_exc_unexpected_error;
1261: END IF;
1262:
1263: --

Line 1260: RAISE fnd_api.g_exc_unexpected_error;

1256:
1257: --
1258: -- Standard call to check for call compatibility
1259: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
1260: RAISE fnd_api.g_exc_unexpected_error;
1261: END IF;
1262:
1263: --
1264: -- Initialize message list.

Line 1265: IF fnd_api.to_boolean(p_init_msg_lst) THEN

1261: END IF;
1262:
1263: --
1264: -- Initialize message list.
1265: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1266: fnd_msg_pub.initialize;
1267: END IF;
1268:
1269: IF (p_logical_trx_type_code = INV_LOGICAL_TRANSACTIONS_PUB.G_LOGTRXCODE_RETROPRICEUPD) THEN

Line 1438: x_return_status := fnd_api.g_ret_sts_success;

1434: );
1435:
1436: END LOOP;
1437:
1438: x_return_status := fnd_api.g_ret_sts_success;
1439: IF (l_debug = 1) THEN
1440: debug_print('After inv insert', 9);
1441: debug_print('Return Status :' || x_return_status, 9);
1442: END IF;

Line 1446: WHEN FND_API.G_EXC_ERROR THEN

1442: END IF;
1443:
1444:
1445: EXCEPTION
1446: WHEN FND_API.G_EXC_ERROR THEN
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: IF (l_debug = 1) THEN
1449: debug_print('Expected Error', 9);
1450: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 1447: x_return_status := FND_API.G_RET_STS_ERROR;

1443:
1444:
1445: EXCEPTION
1446: WHEN FND_API.G_EXC_ERROR THEN
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: IF (l_debug = 1) THEN
1449: debug_print('Expected Error', 9);
1450: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1451: debug_print('Return Status :' || x_return_status);

Line 1455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 => x_msg_data);
1454:
1455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457: IF (l_debug = 1) THEN
1458: debug_print('Expected Error', 9);
1459: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 1456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1452: END IF;
1453: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1454:
1455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457: IF (l_debug = 1) THEN
1458: debug_print('Expected Error', 9);
1459: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1460: debug_print('Return Status :' || x_return_status);

Line 1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1461: END IF;
1462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1463:
1464: WHEN OTHERS THEN
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: IF (l_debug = 1) THEN
1467: debug_print('Error type others', 9);
1468: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1469: debug_print('Return Status :' || x_return_status);

Line 1487: | Should be fnd_api.g_false or fnd_api.g_true |

1483: | |
1484: | Input Parameters : |
1485: | p_api_version_number - API version number |
1486: | p_init_msg_lst - Whether initialize the error message list or not|
1487: | Should be fnd_api.g_false or fnd_api.g_true |
1488: | p_parent_transaction_id - the transaction id of the parent transaction|
1489: | in mmt. |
1490: | p_transaction_id - the transaction id of the new logical |
1491: | transaction in mmt. |

Line 1496: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |

1492: | p_lot_control_code - the lot control code of the item |
1493: | p_serial_control_code - the serial control code of the item |
1494: | |
1495: | Output Parameters : |
1496: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1497: | fnd_api.g_ret_sts_exc_error, if an expected |
1498: | error occurred |
1499: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1500: | eror occurred |

Line 1497: | fnd_api.g_ret_sts_exc_error, if an expected |

1493: | p_serial_control_code - the serial control code of the item |
1494: | |
1495: | Output Parameters : |
1496: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1497: | fnd_api.g_ret_sts_exc_error, if an expected |
1498: | error occurred |
1499: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1500: | eror occurred |
1501: | x_msg_count - Number of error message in the error message |

Line 1499: | fnd_api.g_ret_sts_unexp_error, if an unexpected |

1495: | Output Parameters : |
1496: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1497: | fnd_api.g_ret_sts_exc_error, if an expected |
1498: | error occurred |
1499: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1500: | eror occurred |
1501: | x_msg_count - Number of error message in the error message |
1502: | list |
1503: | x_msg_data - If the number of error message in the error |

Line 1514: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1510: x_return_status OUT NOCOPY VARCHAR2
1511: , x_msg_count OUT NOCOPY NUMBER
1512: , x_msg_data OUT NOCOPY VARCHAR2
1513: , p_api_version_number IN NUMBER := 1.0
1514: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1515: , p_parent_transaction_id IN NUMBER
1516: , p_transaction_id IN NUMBER
1517: , p_lot_control_code IN NUMBER
1518: , p_serial_control_code IN NUMBER

Line 1931: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1927: p_inventory_item_id => null,
1928: p_trx_source_type_id => null,
1929: p_receipt_issue_type => null);
1930:
1931: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1932: IF (l_debug = 1) THEN
1933: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1934: END IF;
1935: RAISE FND_API.G_EXC_ERROR;

Line 1935: RAISE FND_API.G_EXC_ERROR;

1931: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1932: IF (l_debug = 1) THEN
1933: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1934: END IF;
1935: RAISE FND_API.G_EXC_ERROR;
1936: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1937: IF (l_debug = 1) THEN
1938: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1939: END IF;

Line 1936: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1932: IF (l_debug = 1) THEN
1933: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1934: END IF;
1935: RAISE FND_API.G_EXC_ERROR;
1936: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1937: IF (l_debug = 1) THEN
1938: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1939: END IF;
1940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1936: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1937: IF (l_debug = 1) THEN
1938: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1939: END IF;
1940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1941: END IF;
1942:
1943: ELSIF (p_serial_control_code = 6) THEN
1944: IF (l_debug = 1) THEN

Line 1960: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1956: p_lot_number => l_mtln.lot_number,
1957: p_qty => p_primary_quantity,
1958: p_revision => p_revision);
1959:
1960: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1961: IF (l_debug = 1) THEN
1962: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1963: END IF;
1964: RAISE FND_API.G_EXC_ERROR;

Line 1964: RAISE FND_API.G_EXC_ERROR;

1960: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1961: IF (l_debug = 1) THEN
1962: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1963: END IF;
1964: RAISE FND_API.G_EXC_ERROR;
1965: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1966: IF (l_debug = 1) THEN
1967: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
1968: END IF;

Line 1965: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1961: IF (l_debug = 1) THEN
1962: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1963: END IF;
1964: RAISE FND_API.G_EXC_ERROR;
1965: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1966: IF (l_debug = 1) THEN
1967: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
1968: END IF;
1969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1965: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1966: IF (l_debug = 1) THEN
1967: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
1968: END IF;
1969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1970: END IF;
1971:
1972:
1973: inv_mut_insert

Line 1985: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1981: p_inventory_item_id => l_mtln.inventory_item_id,
1982: p_trx_source_type_id => l_mtln.transaction_source_type_id,
1983: p_receipt_issue_type => 1);
1984:
1985: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1986: IF (l_debug = 1) THEN
1987: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
1988: END IF;
1989: RAISE FND_API.G_EXC_ERROR;

Line 1989: RAISE FND_API.G_EXC_ERROR;

1985: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1986: IF (l_debug = 1) THEN
1987: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
1988: END IF;
1989: RAISE FND_API.G_EXC_ERROR;
1990: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: IF (l_debug = 1) THEN
1992: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1993: END IF;

Line 1990: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1986: IF (l_debug = 1) THEN
1987: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
1988: END IF;
1989: RAISE FND_API.G_EXC_ERROR;
1990: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: IF (l_debug = 1) THEN
1992: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1993: END IF;
1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1990: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: IF (l_debug = 1) THEN
1992: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1993: END IF;
1994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1995: END IF;
1996:
1997: END IF; -- end of if serial_control_code is in (2,5)
1998: END LOOP; -- end of loop l_mtln

Line 2022: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2018: p_inventory_item_id => null,
2019: p_trx_source_type_id => null,
2020: p_receipt_issue_type => null);
2021:
2022: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2023: IF (l_debug = 1) THEN
2024: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
2025: END IF;
2026: RAISE FND_API.G_EXC_ERROR;

Line 2026: RAISE FND_API.G_EXC_ERROR;

2022: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2023: IF (l_debug = 1) THEN
2024: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
2025: END IF;
2026: RAISE FND_API.G_EXC_ERROR;
2027: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2028: IF (l_debug = 1) THEN
2029: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
2030: END IF;

Line 2027: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2023: IF (l_debug = 1) THEN
2024: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
2025: END IF;
2026: RAISE FND_API.G_EXC_ERROR;
2027: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2028: IF (l_debug = 1) THEN
2029: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
2030: END IF;
2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2027: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2028: IF (l_debug = 1) THEN
2029: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
2030: END IF;
2031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2032: END IF;
2033:
2034: ELSIF (p_serial_control_code = 6) THEN
2035: IF (l_debug = 1) THEN

Line 2052: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2048: p_lot_number => null,
2049: p_qty => p_primary_quantity,
2050: p_revision => p_revision);
2051:
2052: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2053: IF (l_debug = 1) THEN
2054: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
2055: END IF;
2056: RAISE FND_API.G_EXC_ERROR;

Line 2056: RAISE FND_API.G_EXC_ERROR;

2052: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2053: IF (l_debug = 1) THEN
2054: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
2055: END IF;
2056: RAISE FND_API.G_EXC_ERROR;
2057: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2058: IF (l_debug = 1) THEN
2059: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
2060: END IF;

Line 2057: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2053: IF (l_debug = 1) THEN
2054: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
2055: END IF;
2056: RAISE FND_API.G_EXC_ERROR;
2057: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2058: IF (l_debug = 1) THEN
2059: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
2060: END IF;
2061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2057: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2058: IF (l_debug = 1) THEN
2059: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
2060: END IF;
2061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2062: END IF;
2063:
2064: IF (l_debug = 1) THEN
2065: debug_print('generate_serial_numbers returns success', 9);

Line 2082: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2078: p_inventory_item_id => p_inventory_item_id,
2079: p_trx_source_type_id => p_trx_source_type_id,
2080: p_receipt_issue_type => 1);
2081:
2082: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2083: IF (l_debug = 1) THEN
2084: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
2085: END IF;
2086: RAISE FND_API.G_EXC_ERROR;

Line 2086: RAISE FND_API.G_EXC_ERROR;

2082: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2083: IF (l_debug = 1) THEN
2084: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
2085: END IF;
2086: RAISE FND_API.G_EXC_ERROR;
2087: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2088: IF (l_debug = 1) THEN
2089: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
2090: END IF;

Line 2087: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2083: IF (l_debug = 1) THEN
2084: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
2085: END IF;
2086: RAISE FND_API.G_EXC_ERROR;
2087: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2088: IF (l_debug = 1) THEN
2089: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
2090: END IF;
2091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2087: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2088: IF (l_debug = 1) THEN
2089: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
2090: END IF;
2091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2092: END IF;
2093: END IF;
2094: END IF; -- p_lot_control_code = 2
2095:

Line 2110: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

2106: p_ser_num_tbl => l_serial_number_tbl,
2107: p_organization_id => p_organization_id,
2108: p_inventory_item_id => p_inventory_item_id);
2109:
2110: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2111: IF (l_debug = 1) THEN
2112: debug_print('update_serial_numbers returns error: ' || x_msg_data, 9);
2113: END IF;
2114: RAISE FND_API.G_EXC_ERROR;

Line 2114: RAISE FND_API.G_EXC_ERROR;

2110: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2111: IF (l_debug = 1) THEN
2112: debug_print('update_serial_numbers returns error: ' || x_msg_data, 9);
2113: END IF;
2114: RAISE FND_API.G_EXC_ERROR;
2115: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2116: IF (l_debug = 1) THEN
2117: debug_print('update_serial_numbers returns unexpected error: ' || x_msg_data, 9);
2118: END IF;

Line 2115: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2111: IF (l_debug = 1) THEN
2112: debug_print('update_serial_numbers returns error: ' || x_msg_data, 9);
2113: END IF;
2114: RAISE FND_API.G_EXC_ERROR;
2115: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2116: IF (l_debug = 1) THEN
2117: debug_print('update_serial_numbers returns unexpected error: ' || x_msg_data, 9);
2118: END IF;
2119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2115: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2116: IF (l_debug = 1) THEN
2117: debug_print('update_serial_numbers returns unexpected error: ' || x_msg_data, 9);
2118: END IF;
2119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2120: END IF;
2121: END IF;
2122:
2123: x_return_status := fnd_api.g_ret_sts_success;

Line 2123: x_return_status := fnd_api.g_ret_sts_success;

2119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2120: END IF;
2121: END IF;
2122:
2123: x_return_status := fnd_api.g_ret_sts_success;
2124: IF (l_debug = 1) THEN
2125: debug_print('Before returning from inv_lot_serial_insert', 9);
2126: debug_print('Return Status :' || x_return_status, 9);
2127: END IF;

Line 2129: WHEN FND_API.G_EXC_ERROR THEN

2125: debug_print('Before returning from inv_lot_serial_insert', 9);
2126: debug_print('Return Status :' || x_return_status, 9);
2127: END IF;
2128: EXCEPTION
2129: WHEN FND_API.G_EXC_ERROR THEN
2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131: IF (l_debug = 1) THEN
2132: debug_print('Expected Error', 9);
2133: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2130: x_return_status := FND_API.G_RET_STS_ERROR;

2126: debug_print('Return Status :' || x_return_status, 9);
2127: END IF;
2128: EXCEPTION
2129: WHEN FND_API.G_EXC_ERROR THEN
2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131: IF (l_debug = 1) THEN
2132: debug_print('Expected Error', 9);
2133: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2134: debug_print('Return Status :' || x_return_status);

Line 2138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2134: debug_print('Return Status :' || x_return_status);
2135: END IF;
2136: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2137:
2138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2140: IF (l_debug = 1) THEN
2141: debug_print('Expected Error', 9);
2142: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2135: END IF;
2136: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2137:
2138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2140: IF (l_debug = 1) THEN
2141: debug_print('Expected Error', 9);
2142: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2143: debug_print('Return Status :' || x_return_status);

Line 2148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2144: END IF;
2145: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2146:
2147: WHEN OTHERS THEN
2148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2149: IF (l_debug = 1) THEN
2150: debug_print('Error type others', 9);
2151: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2152: debug_print('Return Status :' || x_return_status);

Line 2234: RAISE FND_API.G_EXC_ERROR;

2230: END IF;
2231:
2232: FND_MESSAGE.SET_NAME('INV', 'INV_GET_SER_INFO_ERR');
2233: FND_MSG_PUB.ADD;
2234: RAISE FND_API.G_EXC_ERROR;
2235: END IF;
2236:
2237: IF (l_debug = 1) THEN
2238: debug_print('MTL_SERIAL_CHECK.INV_SERIAL_INFO returns true', 9);

Line 2262: x_return_status := fnd_api.g_ret_sts_success;

2258: debug_print('l_end_ser is ' || l_end_ser, 9);
2259: END IF;
2260: END IF;
2261:
2262: x_return_status := fnd_api.g_ret_sts_success;
2263: IF (l_debug = 1) THEN
2264: debug_print('Before return from generate_serial_numbers', 9);
2265: debug_print('Return Status :' || x_return_status, 9);
2266: END IF;

Line 2269: WHEN FND_API.G_EXC_ERROR THEN

2265: debug_print('Return Status :' || x_return_status, 9);
2266: END IF;
2267:
2268: EXCEPTION
2269: WHEN FND_API.G_EXC_ERROR THEN
2270: x_return_status := FND_API.G_RET_STS_ERROR;
2271: IF (l_debug = 1) THEN
2272: debug_print('Expected Error', 9);
2273: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2270: x_return_status := FND_API.G_RET_STS_ERROR;

2266: END IF;
2267:
2268: EXCEPTION
2269: WHEN FND_API.G_EXC_ERROR THEN
2270: x_return_status := FND_API.G_RET_STS_ERROR;
2271: IF (l_debug = 1) THEN
2272: debug_print('Expected Error', 9);
2273: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2274: debug_print('Return Status :' || x_return_status);

Line 2278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2274: debug_print('Return Status :' || x_return_status);
2275: END IF;
2276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2277:
2278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2280: IF (l_debug = 1) THEN
2281: debug_print('Expected Error', 9);
2282: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2275: END IF;
2276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2277:
2278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2280: IF (l_debug = 1) THEN
2281: debug_print('Expected Error', 9);
2282: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2283: debug_print('Return Status :' || x_return_status);

Line 2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2284: END IF;
2285: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2286:
2287: WHEN OTHERS THEN
2288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2289: IF (l_debug = 1) THEN
2290: debug_print('Error type others', 9);
2291: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2292: debug_print('Return Status :' || x_return_status);

Line 2592: x_return_status := fnd_api.g_ret_sts_success;

2588: ,SYSDATE
2589: );
2590: END IF;
2591:
2592: x_return_status := fnd_api.g_ret_sts_success;
2593: IF (l_debug = 1) THEN
2594: debug_print('Before return from inv_mut_insert', 9);
2595: debug_print('Return Status :' || x_return_status, 9);
2596: END IF;

Line 2598: WHEN FND_API.G_EXC_ERROR THEN

2594: debug_print('Before return from inv_mut_insert', 9);
2595: debug_print('Return Status :' || x_return_status, 9);
2596: END IF;
2597: EXCEPTION
2598: WHEN FND_API.G_EXC_ERROR THEN
2599: x_return_status := FND_API.G_RET_STS_ERROR;
2600: IF (l_debug = 1) THEN
2601: debug_print('Expected Error', 9);
2602: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2599: x_return_status := FND_API.G_RET_STS_ERROR;

2595: debug_print('Return Status :' || x_return_status, 9);
2596: END IF;
2597: EXCEPTION
2598: WHEN FND_API.G_EXC_ERROR THEN
2599: x_return_status := FND_API.G_RET_STS_ERROR;
2600: IF (l_debug = 1) THEN
2601: debug_print('Expected Error', 9);
2602: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2603: debug_print('Return Status :' || x_return_status);

Line 2607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2603: debug_print('Return Status :' || x_return_status);
2604: END IF;
2605: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2606:
2607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2609: IF (l_debug = 1) THEN
2610: debug_print('Expected Error', 9);
2611: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2604: END IF;
2605: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2606:
2607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2609: IF (l_debug = 1) THEN
2610: debug_print('Expected Error', 9);
2611: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2612: debug_print('Return Status :' || x_return_status);

Line 2617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2660: WHEN FND_API.G_EXC_ERROR THEN

2656: to the number of serial numbers that needed to be updated', 9);
2657: END IF;
2658: END IF;
2659: EXCEPTION
2660: WHEN FND_API.G_EXC_ERROR THEN
2661: x_return_status := FND_API.G_RET_STS_ERROR;
2662: IF (l_debug = 1) THEN
2663: debug_print('Expected Error', 9);
2664: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2661: x_return_status := FND_API.G_RET_STS_ERROR;

2657: END IF;
2658: END IF;
2659: EXCEPTION
2660: WHEN FND_API.G_EXC_ERROR THEN
2661: x_return_status := FND_API.G_RET_STS_ERROR;
2662: IF (l_debug = 1) THEN
2663: debug_print('Expected Error', 9);
2664: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2665: debug_print('Return Status :' || x_return_status);

Line 2669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2665: debug_print('Return Status :' || x_return_status);
2666: END IF;
2667: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2668:
2669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2671: IF (l_debug = 1) THEN
2672: debug_print('Expected Error', 9);
2673: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2666: END IF;
2667: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2668:
2669: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2671: IF (l_debug = 1) THEN
2672: debug_print('Expected Error', 9);
2673: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2674: debug_print('Return Status :' || x_return_status);

Line 2679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2675: END IF;
2676: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2677:
2678: WHEN OTHERS THEN
2679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2680: IF (l_debug = 1) THEN
2681: debug_print('Error type others', 9);
2682: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2683: debug_print('Return Status :' || x_return_status);