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 731: RAISE fnd_api.g_exc_error;

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:
735: IF (((p_mtl_trx_tbl(i).acct_period_id IS NOT NULL) AND

Line 744: RAISE fnd_api.g_exc_error;

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:
748: --15. Validate transaction UOM

Line 766: RAISE fnd_api.g_exc_error;

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

Line 776: RAISE fnd_api.g_exc_error;

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:
780: --16. Validate cost groups. Cost groups should already be populated

Line 789: RAISE fnd_api.g_exc_error;

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

Line 808: RAISE fnd_api.g_exc_error;

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

Line 817: RAISE fnd_api.g_exc_error;

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:
821: -- 17. Validate cost groups for transfer organziations.

Line 835: RAISE fnd_api.g_exc_error;

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

Line 854: RAISE fnd_api.g_exc_error;

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

Line 863: RAISE fnd_api.g_exc_error;

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

Line 879: RAISE fnd_api.g_exc_error;

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:
883: --19. If the locator is passed and it is project enabled, we would

Line 906: RAISE fnd_api.g_exc_error;

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:
910: IF (l_project_id IS NOT NULL) THEN

Line 918: RAISE fnd_api.g_exc_error;

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

Line 932: RAISE fnd_api.g_exc_error;

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

Line 959: RAISE fnd_api.g_exc_error;

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

Line 976: RAISE fnd_api.g_exc_error;

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

Line 986: RAISE fnd_api.g_exc_error;

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

Line 1011: RAISE fnd_api.g_exc_error;

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

Line 1031: RAISE fnd_api.g_exc_error;

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

Line 1041: RAISE fnd_api.g_exc_error;

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

Line 1063: RAISE fnd_api.g_exc_error;

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

Line 1079: RAISE fnd_api.g_exc_error;

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

Line 1089: RAISE fnd_api.g_exc_error;

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

Line 1109: RAISE fnd_api.g_exc_error;

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:
1113: IF (p_mtl_trx_tbl(i).intercompany_cost IS NULL) OR

Line 1121: RAISE fnd_api.g_exc_error;

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

Line 1134: RAISE fnd_api.g_exc_error;

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:
1138: END IF; -- If p_validation level set to true.

Line 1146: WHEN FND_API.G_EXC_ERROR THEN

1142:
1143: x_return_status := l_return_status;
1144:
1145: EXCEPTION
1146: WHEN FND_API.G_EXC_ERROR THEN
1147: IF (l_debug = 1) THEN
1148: debug_print('Expected Error', 9);
1149: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1150: END IF;

Line 1151: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
1157: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1158: END IF;

Line 1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

1179: | |
1180: | Input Parameters : |
1181: | p_api_version_number - API version number |
1182: | p_init_msg_lst - Whether initialize the error message list or not|
1183: | Should be fnd_api.g_false or fnd_api.g_true |
1184: | p_mtl_trx_rec - An array of mtl_trx_rec_type records |
1185: | |
1186: | Output Parameters : |
1187: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |

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

1183: | Should be fnd_api.g_false or fnd_api.g_true |
1184: | p_mtl_trx_rec - An array of mtl_trx_rec_type records |
1185: | |
1186: | Output Parameters : |
1187: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1188: | fnd_api.g_ret_sts_exc_error, if an expected |
1189: | error occurred |
1190: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1191: | eror occurred |

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

1184: | p_mtl_trx_rec - An array of mtl_trx_rec_type records |
1185: | |
1186: | Output Parameters : |
1187: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1188: | fnd_api.g_ret_sts_exc_error, if an expected |
1189: | error occurred |
1190: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1191: | eror occurred |
1192: | x_msg_count - Number of error message in the error message |

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

1186: | Output Parameters : |
1187: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1188: | fnd_api.g_ret_sts_exc_error, if an expected |
1189: | error occurred |
1190: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1191: | eror occurred |
1192: | x_msg_count - Number of error message in the error message |
1193: | list |
1194: | x_msg_data - If the number of error message in the error |

Line 1204: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1200: x_return_status OUT NOCOPY VARCHAR2
1201: , x_msg_count OUT NOCOPY NUMBER
1202: , x_msg_data OUT NOCOPY VARCHAR2
1203: , p_api_version_number IN NUMBER
1204: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1205: , p_mtl_trx_tbl IN inv_logical_transaction_global.mtl_trx_tbl_type
1206: , p_logical_trx_type_code IN NUMBER
1207:
1208:

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

1237: END IF;
1238:
1239: --
1240: -- Standard call to check for call compatibility
1241: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
1242: RAISE fnd_api.g_exc_unexpected_error;
1243: END IF;
1244:
1245: --

Line 1242: RAISE fnd_api.g_exc_unexpected_error;

1238:
1239: --
1240: -- Standard call to check for call compatibility
1241: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
1242: RAISE fnd_api.g_exc_unexpected_error;
1243: END IF;
1244:
1245: --
1246: -- Initialize message list.

Line 1247: IF fnd_api.to_boolean(p_init_msg_lst) THEN

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

Line 1420: x_return_status := fnd_api.g_ret_sts_success;

1416: );
1417:
1418: END LOOP;
1419:
1420: x_return_status := fnd_api.g_ret_sts_success;
1421: IF (l_debug = 1) THEN
1422: debug_print('After inv insert', 9);
1423: debug_print('Return Status :' || x_return_status, 9);
1424: END IF;

Line 1428: WHEN FND_API.G_EXC_ERROR THEN

1424: END IF;
1425:
1426:
1427: EXCEPTION
1428: WHEN FND_API.G_EXC_ERROR THEN
1429: x_return_status := FND_API.G_RET_STS_ERROR;
1430: IF (l_debug = 1) THEN
1431: debug_print('Expected Error', 9);
1432: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 1429: x_return_status := FND_API.G_RET_STS_ERROR;

1425:
1426:
1427: EXCEPTION
1428: WHEN FND_API.G_EXC_ERROR THEN
1429: x_return_status := FND_API.G_RET_STS_ERROR;
1430: IF (l_debug = 1) THEN
1431: debug_print('Expected Error', 9);
1432: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1433: debug_print('Return Status :' || x_return_status);

Line 1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
1440: debug_print('Expected Error', 9);
1441: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
1440: debug_print('Expected Error', 9);
1441: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1442: debug_print('Return Status :' || x_return_status);

Line 1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
1449: debug_print('Error type others', 9);
1450: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
1451: debug_print('Return Status :' || x_return_status);

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

1465: | |
1466: | Input Parameters : |
1467: | p_api_version_number - API version number |
1468: | p_init_msg_lst - Whether initialize the error message list or not|
1469: | Should be fnd_api.g_false or fnd_api.g_true |
1470: | p_parent_transaction_id - the transaction id of the parent transaction|
1471: | in mmt. |
1472: | p_transaction_id - the transaction id of the new logical |
1473: | transaction in mmt. |

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

1474: | p_lot_control_code - the lot control code of the item |
1475: | p_serial_control_code - the serial control code of the item |
1476: | |
1477: | Output Parameters : |
1478: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1479: | fnd_api.g_ret_sts_exc_error, if an expected |
1480: | error occurred |
1481: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1482: | eror occurred |

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

1475: | p_serial_control_code - the serial control code of the item |
1476: | |
1477: | Output Parameters : |
1478: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1479: | fnd_api.g_ret_sts_exc_error, if an expected |
1480: | error occurred |
1481: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1482: | eror occurred |
1483: | x_msg_count - Number of error message in the error message |

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

1477: | Output Parameters : |
1478: | x_return_status - fnd_api.g_ret_sts_success, if succeeded |
1479: | fnd_api.g_ret_sts_exc_error, if an expected |
1480: | error occurred |
1481: | fnd_api.g_ret_sts_unexp_error, if an unexpected |
1482: | eror occurred |
1483: | x_msg_count - Number of error message in the error message |
1484: | list |
1485: | x_msg_data - If the number of error message in the error |

Line 1496: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1492: x_return_status OUT NOCOPY VARCHAR2
1493: , x_msg_count OUT NOCOPY NUMBER
1494: , x_msg_data OUT NOCOPY VARCHAR2
1495: , p_api_version_number IN NUMBER := 1.0
1496: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1497: , p_parent_transaction_id IN NUMBER
1498: , p_transaction_id IN NUMBER
1499: , p_lot_control_code IN NUMBER
1500: , p_serial_control_code IN NUMBER

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

1875: p_inventory_item_id => null,
1876: p_trx_source_type_id => null,
1877: p_receipt_issue_type => null);
1878:
1879: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1880: IF (l_debug = 1) THEN
1881: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1882: END IF;
1883: RAISE FND_API.G_EXC_ERROR;

Line 1883: RAISE FND_API.G_EXC_ERROR;

1879: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1880: IF (l_debug = 1) THEN
1881: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1882: END IF;
1883: RAISE FND_API.G_EXC_ERROR;
1884: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1885: IF (l_debug = 1) THEN
1886: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1887: END IF;

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

1880: IF (l_debug = 1) THEN
1881: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1882: END IF;
1883: RAISE FND_API.G_EXC_ERROR;
1884: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1885: IF (l_debug = 1) THEN
1886: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1887: END IF;
1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1884: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1885: IF (l_debug = 1) THEN
1886: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1887: END IF;
1888: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1889: END IF;
1890:
1891: ELSIF (p_serial_control_code = 6) THEN
1892: IF (l_debug = 1) THEN

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

1904: p_lot_number => l_mtln.lot_number,
1905: p_qty => p_primary_quantity,
1906: p_revision => p_revision);
1907:
1908: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1909: IF (l_debug = 1) THEN
1910: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1911: END IF;
1912: RAISE FND_API.G_EXC_ERROR;

Line 1912: RAISE FND_API.G_EXC_ERROR;

1908: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1909: IF (l_debug = 1) THEN
1910: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1911: END IF;
1912: RAISE FND_API.G_EXC_ERROR;
1913: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1914: IF (l_debug = 1) THEN
1915: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
1916: END IF;

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

1909: IF (l_debug = 1) THEN
1910: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1911: END IF;
1912: RAISE FND_API.G_EXC_ERROR;
1913: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1914: IF (l_debug = 1) THEN
1915: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
1916: END IF;
1917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1913: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1914: IF (l_debug = 1) THEN
1915: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
1916: END IF;
1917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1918: END IF;
1919:
1920:
1921: inv_mut_insert

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

1929: p_inventory_item_id => l_mtln.inventory_item_id,
1930: p_trx_source_type_id => l_mtln.transaction_source_type_id,
1931: p_receipt_issue_type => 1);
1932:
1933: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1934: IF (l_debug = 1) THEN
1935: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
1936: END IF;
1937: RAISE FND_API.G_EXC_ERROR;

Line 1937: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 1942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1938: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1939: IF (l_debug = 1) THEN
1940: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1941: END IF;
1942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1943: END IF;
1944:
1945: END IF; -- end of if serial_control_code is in (2,5)
1946: END LOOP; -- end of loop l_mtln

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

1966: p_inventory_item_id => null,
1967: p_trx_source_type_id => null,
1968: p_receipt_issue_type => null);
1969:
1970: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1971: IF (l_debug = 1) THEN
1972: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1973: END IF;
1974: RAISE FND_API.G_EXC_ERROR;

Line 1974: RAISE FND_API.G_EXC_ERROR;

1970: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1971: IF (l_debug = 1) THEN
1972: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1973: END IF;
1974: RAISE FND_API.G_EXC_ERROR;
1975: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1976: IF (l_debug = 1) THEN
1977: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1978: END IF;

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

1971: IF (l_debug = 1) THEN
1972: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
1973: END IF;
1974: RAISE FND_API.G_EXC_ERROR;
1975: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1976: IF (l_debug = 1) THEN
1977: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1978: END IF;
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1975: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1976: IF (l_debug = 1) THEN
1977: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
1978: END IF;
1979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1980: END IF;
1981:
1982: ELSIF (p_serial_control_code = 6) THEN
1983: IF (l_debug = 1) THEN

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

1996: p_lot_number => null,
1997: p_qty => p_primary_quantity,
1998: p_revision => p_revision);
1999:
2000: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2001: IF (l_debug = 1) THEN
2002: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
2003: END IF;
2004: RAISE FND_API.G_EXC_ERROR;

Line 2004: RAISE FND_API.G_EXC_ERROR;

2000: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2001: IF (l_debug = 1) THEN
2002: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
2003: END IF;
2004: RAISE FND_API.G_EXC_ERROR;
2005: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2006: IF (l_debug = 1) THEN
2007: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
2008: END IF;

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

2001: IF (l_debug = 1) THEN
2002: debug_print('generate_serial_number returns error: ' || x_msg_data, 9);
2003: END IF;
2004: RAISE FND_API.G_EXC_ERROR;
2005: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2006: IF (l_debug = 1) THEN
2007: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
2008: END IF;
2009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2005: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2006: IF (l_debug = 1) THEN
2007: debug_print('generate_serial_number returns unexpected error: ' || x_msg_data, 9);
2008: END IF;
2009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2010: END IF;
2011:
2012: IF (l_debug = 1) THEN
2013: debug_print('generate_serial_numbers returns success', 9);

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

2026: p_inventory_item_id => p_inventory_item_id,
2027: p_trx_source_type_id => p_trx_source_type_id,
2028: p_receipt_issue_type => 1);
2029:
2030: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2031: IF (l_debug = 1) THEN
2032: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
2033: END IF;
2034: RAISE FND_API.G_EXC_ERROR;

Line 2034: RAISE FND_API.G_EXC_ERROR;

2030: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2031: IF (l_debug = 1) THEN
2032: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
2033: END IF;
2034: RAISE FND_API.G_EXC_ERROR;
2035: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2036: IF (l_debug = 1) THEN
2037: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
2038: END IF;

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

2031: IF (l_debug = 1) THEN
2032: debug_print('inv_mut_insert returns error: ' || x_msg_data, 9);
2033: END IF;
2034: RAISE FND_API.G_EXC_ERROR;
2035: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2036: IF (l_debug = 1) THEN
2037: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
2038: END IF;
2039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2035: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2036: IF (l_debug = 1) THEN
2037: debug_print('inv_mut_insert returns unexpected error: ' || x_msg_data, 9);
2038: END IF;
2039: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2040: END IF;
2041: END IF;
2042: END IF; -- p_lot_control_code = 2
2043:

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

2054: p_ser_num_tbl => l_serial_number_tbl,
2055: p_organization_id => p_organization_id,
2056: p_inventory_item_id => p_inventory_item_id);
2057:
2058: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2059: IF (l_debug = 1) THEN
2060: debug_print('update_serial_numbers returns error: ' || x_msg_data, 9);
2061: END IF;
2062: RAISE FND_API.G_EXC_ERROR;

Line 2062: RAISE FND_API.G_EXC_ERROR;

2058: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2059: IF (l_debug = 1) THEN
2060: debug_print('update_serial_numbers returns error: ' || x_msg_data, 9);
2061: END IF;
2062: RAISE FND_API.G_EXC_ERROR;
2063: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2064: IF (l_debug = 1) THEN
2065: debug_print('update_serial_numbers returns unexpected error: ' || x_msg_data, 9);
2066: END IF;

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

2059: IF (l_debug = 1) THEN
2060: debug_print('update_serial_numbers returns error: ' || x_msg_data, 9);
2061: END IF;
2062: RAISE FND_API.G_EXC_ERROR;
2063: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2064: IF (l_debug = 1) THEN
2065: debug_print('update_serial_numbers returns unexpected error: ' || x_msg_data, 9);
2066: END IF;
2067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2063: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2064: IF (l_debug = 1) THEN
2065: debug_print('update_serial_numbers returns unexpected error: ' || x_msg_data, 9);
2066: END IF;
2067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2068: END IF;
2069: END IF;
2070:
2071: x_return_status := fnd_api.g_ret_sts_success;

Line 2071: x_return_status := fnd_api.g_ret_sts_success;

2067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2068: END IF;
2069: END IF;
2070:
2071: x_return_status := fnd_api.g_ret_sts_success;
2072: IF (l_debug = 1) THEN
2073: debug_print('Before returning from inv_lot_serial_insert', 9);
2074: debug_print('Return Status :' || x_return_status, 9);
2075: END IF;

Line 2077: WHEN FND_API.G_EXC_ERROR THEN

2073: debug_print('Before returning from inv_lot_serial_insert', 9);
2074: debug_print('Return Status :' || x_return_status, 9);
2075: END IF;
2076: EXCEPTION
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079: IF (l_debug = 1) THEN
2080: debug_print('Expected Error', 9);
2081: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2078: x_return_status := FND_API.G_RET_STS_ERROR;

2074: debug_print('Return Status :' || x_return_status, 9);
2075: END IF;
2076: EXCEPTION
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: x_return_status := FND_API.G_RET_STS_ERROR;
2079: IF (l_debug = 1) THEN
2080: debug_print('Expected Error', 9);
2081: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2082: debug_print('Return Status :' || x_return_status);

Line 2086: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
2089: debug_print('Expected Error', 9);
2090: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
2089: debug_print('Expected Error', 9);
2090: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2091: debug_print('Return Status :' || x_return_status);

Line 2096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
2098: debug_print('Error type others', 9);
2099: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2100: debug_print('Return Status :' || x_return_status);

Line 2182: RAISE FND_API.G_EXC_ERROR;

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
2186: debug_print('MTL_SERIAL_CHECK.INV_SERIAL_INFO returns true', 9);

Line 2210: x_return_status := fnd_api.g_ret_sts_success;

2206: debug_print('l_end_ser is ' || l_end_ser, 9);
2207: END IF;
2208: END IF;
2209:
2210: x_return_status := fnd_api.g_ret_sts_success;
2211: IF (l_debug = 1) THEN
2212: debug_print('Before return from generate_serial_numbers', 9);
2213: debug_print('Return Status :' || x_return_status, 9);
2214: END IF;

Line 2217: WHEN FND_API.G_EXC_ERROR THEN

2213: debug_print('Return Status :' || x_return_status, 9);
2214: END IF;
2215:
2216: EXCEPTION
2217: WHEN FND_API.G_EXC_ERROR THEN
2218: x_return_status := FND_API.G_RET_STS_ERROR;
2219: IF (l_debug = 1) THEN
2220: debug_print('Expected Error', 9);
2221: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2218: x_return_status := FND_API.G_RET_STS_ERROR;

2214: END IF;
2215:
2216: EXCEPTION
2217: WHEN FND_API.G_EXC_ERROR THEN
2218: x_return_status := FND_API.G_RET_STS_ERROR;
2219: IF (l_debug = 1) THEN
2220: debug_print('Expected Error', 9);
2221: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2222: debug_print('Return Status :' || x_return_status);

Line 2226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
2229: debug_print('Expected Error', 9);
2230: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
2229: debug_print('Expected Error', 9);
2230: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2231: debug_print('Return Status :' || x_return_status);

Line 2236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
2238: debug_print('Error type others', 9);
2239: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2240: debug_print('Return Status :' || x_return_status);

Line 2540: x_return_status := fnd_api.g_ret_sts_success;

2536: ,SYSDATE
2537: );
2538: END IF;
2539:
2540: x_return_status := fnd_api.g_ret_sts_success;
2541: IF (l_debug = 1) THEN
2542: debug_print('Before return from inv_mut_insert', 9);
2543: debug_print('Return Status :' || x_return_status, 9);
2544: END IF;

Line 2546: WHEN FND_API.G_EXC_ERROR THEN

2542: debug_print('Before return from inv_mut_insert', 9);
2543: debug_print('Return Status :' || x_return_status, 9);
2544: END IF;
2545: EXCEPTION
2546: WHEN FND_API.G_EXC_ERROR THEN
2547: x_return_status := FND_API.G_RET_STS_ERROR;
2548: IF (l_debug = 1) THEN
2549: debug_print('Expected Error', 9);
2550: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2547: x_return_status := FND_API.G_RET_STS_ERROR;

2543: debug_print('Return Status :' || x_return_status, 9);
2544: END IF;
2545: EXCEPTION
2546: WHEN FND_API.G_EXC_ERROR THEN
2547: x_return_status := FND_API.G_RET_STS_ERROR;
2548: IF (l_debug = 1) THEN
2549: debug_print('Expected Error', 9);
2550: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2551: debug_print('Return Status :' || x_return_status);

Line 2555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
2558: debug_print('Expected Error', 9);
2559: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
2558: debug_print('Expected Error', 9);
2559: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2560: debug_print('Return Status :' || x_return_status);

Line 2565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
2567: debug_print('Error type others', 9);
2568: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2569: debug_print('Return Status :' || x_return_status);

Line 2608: WHEN FND_API.G_EXC_ERROR THEN

2604: to the number of serial numbers that needed to be updated', 9);
2605: END IF;
2606: END IF;
2607: EXCEPTION
2608: WHEN FND_API.G_EXC_ERROR THEN
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: IF (l_debug = 1) THEN
2611: debug_print('Expected Error', 9);
2612: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2609: x_return_status := FND_API.G_RET_STS_ERROR;

2605: END IF;
2606: END IF;
2607: EXCEPTION
2608: WHEN FND_API.G_EXC_ERROR THEN
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: IF (l_debug = 1) THEN
2611: debug_print('Expected Error', 9);
2612: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2613: debug_print('Return Status :' || x_return_status);

Line 2617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
2620: debug_print('Expected Error', 9);
2621: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);

Line 2618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
2620: debug_print('Expected Error', 9);
2621: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2622: debug_print('Return Status :' || x_return_status);

Line 2627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
2629: debug_print('Error type others', 9);
2630: debug_print('SQL Error: ' || Sqlerrm(SQLCODE),1);
2631: debug_print('Return Status :' || x_return_status);