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.PO_INVOICES_SV2 dependencies on ASN_DEBUG

Line 5: -- g_asn_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');

1: PACKAGE BODY po_invoices_sv2 AS
2: /* $Header: POXIVRPB.pls 120.44.12020000.2 2013/02/28 10:37:40 gke ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: -- g_asn_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');
6: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790: rcv debug enhancement
7:
8: create_invoice_error EXCEPTION; --SBI
9:

Line 6: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790: rcv debug enhancement

2: /* $Header: POXIVRPB.pls 120.44.12020000.2 2013/02/28 10:37:40 gke ship $*/
3:
4: -- Read the profile option that enables/disables the debug log
5: -- g_asn_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');
6: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790: rcv debug enhancement
7:
8: create_invoice_error EXCEPTION; --SBI
9:
10:

Line 38: IF (g_asn_debug = 'Y') THEN

34: FROM
35: po_line_locations_all
36: WHERE
37: line_location_id = p_po_line_location_id;
38: IF (g_asn_debug = 'Y') THEN
39: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has ship to location id = ' || l_ship_to_location_id);
40: END IF;
41: RETURN l_ship_to_location_id;
42: EXCEPTION

Line 39: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has ship to location id = ' || l_ship_to_location_id);

35: po_line_locations_all
36: WHERE
37: line_location_id = p_po_line_location_id;
38: IF (g_asn_debug = 'Y') THEN
39: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has ship to location id = ' || l_ship_to_location_id);
40: END IF;
41: RETURN l_ship_to_location_id;
42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN

Line 44: IF (g_asn_debug = 'Y') THEN

40: END IF;
41: RETURN l_ship_to_location_id;
42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN
44: IF (g_asn_debug = 'Y') THEN
45: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has no ship to location id');
46: END IF;
47: RETURN NULL;
48: WHEN OTHERS THEN

Line 45: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has no ship to location id');

41: RETURN l_ship_to_location_id;
42: EXCEPTION
43: WHEN NO_DATA_FOUND THEN
44: IF (g_asn_debug = 'Y') THEN
45: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has no ship to location id');
46: END IF;
47: RETURN NULL;
48: WHEN OTHERS THEN
49: IF (g_asn_debug = 'Y') THEN

Line 49: IF (g_asn_debug = 'Y') THEN

45: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has no ship to location id');
46: END IF;
47: RETURN NULL;
48: WHEN OTHERS THEN
49: IF (g_asn_debug = 'Y') THEN
50: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has some problem. This is not acceptable.');
51: END IF;
52: RETURN NULL;
53:

Line 50: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has some problem. This is not acceptable.');

46: END IF;
47: RETURN NULL;
48: WHEN OTHERS THEN
49: IF (g_asn_debug = 'Y') THEN
50: asn_debug.put_line('po_line_location_id = ' || p_po_line_location_id || ' has some problem. This is not acceptable.');
51: END IF;
52: RETURN NULL;
53:
54: END get_ship_to_location_id;

Line 84: IF (g_asn_debug = 'Y') THEN

80: WHERE
81: trx_id = p_trx_id
82: AND trx_line_id = p_trx_line_id
83: AND entity_code = p_entity_code;
84: IF (g_asn_debug = 'Y') THEN
85: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has a tax classification code = ' || l_tax_classification_code);
86: END IF;
87: RETURN l_tax_classification_code;
88: EXCEPTION

Line 85: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has a tax classification code = ' || l_tax_classification_code);

81: trx_id = p_trx_id
82: AND trx_line_id = p_trx_line_id
83: AND entity_code = p_entity_code;
84: IF (g_asn_debug = 'Y') THEN
85: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has a tax classification code = ' || l_tax_classification_code);
86: END IF;
87: RETURN l_tax_classification_code;
88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN

Line 90: IF (g_asn_debug = 'Y') THEN

86: END IF;
87: RETURN l_tax_classification_code;
88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN
90: IF (g_asn_debug = 'Y') THEN
91: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has no tax classification code');
92: END IF;
93: RETURN NULL;
94: WHEN OTHERS THEN

Line 91: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has no tax classification code');

87: RETURN l_tax_classification_code;
88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN
90: IF (g_asn_debug = 'Y') THEN
91: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has no tax classification code');
92: END IF;
93: RETURN NULL;
94: WHEN OTHERS THEN
95: IF (g_asn_debug = 'Y') THEN

Line 95: IF (g_asn_debug = 'Y') THEN

91: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has no tax classification code');
92: END IF;
93: RETURN NULL;
94: WHEN OTHERS THEN
95: IF (g_asn_debug = 'Y') THEN
96: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has some problem. This is not acceptable.');
97: END IF;
98: RETURN NULL;
99: END get_tax_classification_code;

Line 96: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has some problem. This is not acceptable.');

92: END IF;
93: RETURN NULL;
94: WHEN OTHERS THEN
95: IF (g_asn_debug = 'Y') THEN
96: asn_debug.put_line(p_entity_code || '=' || p_trx_id || ' has some problem. This is not acceptable.');
97: END IF;
98: RETURN NULL;
99: END get_tax_classification_code;
100:

Line 595: IF (g_asn_debug = 'Y') THEN

591:
592:
593: BEGIN
594: /**** BEGIN create_receipt_invoices ***/
595: IF (g_asn_debug = 'Y') THEN
596: asn_debug.put_line('Begin Create Receipt Invoices ... ');
597: END IF;
598:
599: X_invoice_count := 0;

Line 596: asn_debug.put_line('Begin Create Receipt Invoices ... ');

592:
593: BEGIN
594: /**** BEGIN create_receipt_invoices ***/
595: IF (g_asn_debug = 'Y') THEN
596: asn_debug.put_line('Begin Create Receipt Invoices ... ');
597: END IF;
598:
599: X_invoice_count := 0;
600: X_invoice_running_total := 0;

Line 624: IF (g_asn_debug = 'Y') THEN

620: END IF;
621:
622:
623: X_progress := '020';
624: IF (g_asn_debug = 'Y') THEN
625: asn_debug.put_line('Begin processing rcv txns ... [' || to_char(x_aging_period) || ']');
626: END IF;
627:
628:

Line 625: asn_debug.put_line('Begin processing rcv txns ... [' || to_char(x_aging_period) || ']');

621:
622:
623: X_progress := '020';
624: IF (g_asn_debug = 'Y') THEN
625: asn_debug.put_line('Begin processing rcv txns ... [' || to_char(x_aging_period) || ']');
626: END IF;
627:
628:
629: IF (X_rcv_shipment_header_id IS NULL) THEN

Line 631: IF (g_asn_debug = 'Y') THEN

627:
628:
629: IF (X_rcv_shipment_header_id IS NULL) THEN
630:
631: IF (g_asn_debug = 'Y') THEN
632: asn_debug.put_line('opening c_receipt_txns');
633: END IF;
634: OPEN c_receipt_txns;
635: ELSE

Line 632: asn_debug.put_line('opening c_receipt_txns');

628:
629: IF (X_rcv_shipment_header_id IS NULL) THEN
630:
631: IF (g_asn_debug = 'Y') THEN
632: asn_debug.put_line('opening c_receipt_txns');
633: END IF;
634: OPEN c_receipt_txns;
635: ELSE
636: IF (g_asn_debug = 'Y') THEN

Line 636: IF (g_asn_debug = 'Y') THEN

632: asn_debug.put_line('opening c_receipt_txns');
633: END IF;
634: OPEN c_receipt_txns;
635: ELSE
636: IF (g_asn_debug = 'Y') THEN
637: asn_debug.put_line('opening c_receipt_txns2');
638: END IF;
639: OPEN c_receipt_txns2;
640:

Line 637: asn_debug.put_line('opening c_receipt_txns2');

633: END IF;
634: OPEN c_receipt_txns;
635: ELSE
636: IF (g_asn_debug = 'Y') THEN
637: asn_debug.put_line('opening c_receipt_txns2');
638: END IF;
639: OPEN c_receipt_txns2;
640:
641: END IF;

Line 649: IF (g_asn_debug = 'Y') THEN

645: X_progress := '030';
646:
647: IF (X_rcv_shipment_header_id IS NULL) THEN
648:
649: IF (g_asn_debug = 'Y') THEN
650: asn_debug.put_line('fetching c_receipt_txns');
651: END IF;
652: FETCH c_receipt_txns INTO X_rcv_txns;
653:

Line 650: asn_debug.put_line('fetching c_receipt_txns');

646:
647: IF (X_rcv_shipment_header_id IS NULL) THEN
648:
649: IF (g_asn_debug = 'Y') THEN
650: asn_debug.put_line('fetching c_receipt_txns');
651: END IF;
652: FETCH c_receipt_txns INTO X_rcv_txns;
653:
654: IF (c_receipt_txns%NOTFOUND) THEN

Line 655: IF (g_asn_debug = 'Y') THEN

651: END IF;
652: FETCH c_receipt_txns INTO X_rcv_txns;
653:
654: IF (c_receipt_txns%NOTFOUND) THEN
655: IF (g_asn_debug = 'Y') THEN
656: asn_debug.put_line('closing c_receipt_txns');
657: END IF;
658: CLOSE C_receipt_txns;
659: EXIT;

Line 656: asn_debug.put_line('closing c_receipt_txns');

652: FETCH c_receipt_txns INTO X_rcv_txns;
653:
654: IF (c_receipt_txns%NOTFOUND) THEN
655: IF (g_asn_debug = 'Y') THEN
656: asn_debug.put_line('closing c_receipt_txns');
657: END IF;
658: CLOSE C_receipt_txns;
659: EXIT;
660: END IF;

Line 663: IF (g_asn_debug = 'Y') THEN

659: EXIT;
660: END IF;
661:
662: ELSE
663: IF (g_asn_debug = 'Y') THEN
664: asn_debug.put_line('fetching c_receipt_txns2');
665: END IF;
666: FETCH c_receipt_txns2 INTO X_rcv_txns;
667:

Line 664: asn_debug.put_line('fetching c_receipt_txns2');

660: END IF;
661:
662: ELSE
663: IF (g_asn_debug = 'Y') THEN
664: asn_debug.put_line('fetching c_receipt_txns2');
665: END IF;
666: FETCH c_receipt_txns2 INTO X_rcv_txns;
667:
668: IF (c_receipt_txns2%NOTFOUND) THEN

Line 669: IF (g_asn_debug = 'Y') THEN

665: END IF;
666: FETCH c_receipt_txns2 INTO X_rcv_txns;
667:
668: IF (c_receipt_txns2%NOTFOUND) THEN
669: IF (g_asn_debug = 'Y') THEN
670: asn_debug.put_line('closing c_receipt_txns2');
671: END IF;
672: CLOSE C_receipt_txns2;
673: EXIT;

Line 670: asn_debug.put_line('closing c_receipt_txns2');

666: FETCH c_receipt_txns2 INTO X_rcv_txns;
667:
668: IF (c_receipt_txns2%NOTFOUND) THEN
669: IF (g_asn_debug = 'Y') THEN
670: asn_debug.put_line('closing c_receipt_txns2');
671: END IF;
672: CLOSE C_receipt_txns2;
673: EXIT;
674: END IF;

Line 678: IF (g_asn_debug = 'Y') THEN

674: END IF;
675:
676: END IF;
677:
678: IF (g_asn_debug = 'Y') THEN
679: asn_debug.put_line('IN processing rcv txns ... ');
680: END IF;
681:
682: X_progress := '040';

Line 679: asn_debug.put_line('IN processing rcv txns ... ');

675:
676: END IF;
677:
678: IF (g_asn_debug = 'Y') THEN
679: asn_debug.put_line('IN processing rcv txns ... ');
680: END IF;
681:
682: X_progress := '040';
683:

Line 829: asn_debug.put_line('create_invoice_num raised error');

825: X_rcv_txns.pack_slip,
826: X_rcv_txns.receipt_num);
827: EXCEPTION
828: WHEN others THEN
829: asn_debug.put_line('create_invoice_num raised error');
830: X_curr_inv_process_flag := 'N';
831: X_first_rcv_txn_flag := 'Y';
832: END;
833: END IF;*/

Line 975: asn_debug.put_line('Setting the values of X_curr_conversion_rate1 and X_curr_conversion_rate_date1 to NULL');

971: /* Bug 8741094 Setting the values of X_curr_conversion_rate1 and X_curr_conversion_rate_date1 to NULL if the
972: functional currency is the same as the foreign currency, and the currency conversion rate type is not 'User'. */
973: IF (NVL(UPPER(x_curr_conversion_rate_type),'$#%@^$$') <> 'USER'
974: AND X_rcv_txns.currency_code = X_def_base_currency_code) THEN
975: asn_debug.put_line('Setting the values of X_curr_conversion_rate1 and X_curr_conversion_rate_date1 to NULL');
976: X_curr_conversion_rate1 := NULL;
977: X_curr_conversion_rate_date1 := NULL;
978: END IF;
979: /* End of fix for Bug 8741094 */

Line 981: IF (g_asn_debug = 'Y') THEN

977: X_curr_conversion_rate_date1 := NULL;
978: END IF;
979: /* End of fix for Bug 8741094 */
980:
981: IF (g_asn_debug = 'Y') THEN
982: asn_debug.put_line('creating invoice headers');
983: END IF;
984: /* bug 1832024 : we need to insert terms id into the interface table
985: so that ap get the value */

Line 982: asn_debug.put_line('creating invoice headers');

978: END IF;
979: /* End of fix for Bug 8741094 */
980:
981: IF (g_asn_debug = 'Y') THEN
982: asn_debug.put_line('creating invoice headers');
983: END IF;
984: /* bug 1832024 : we need to insert terms id into the interface table
985: so that ap get the value */
986:

Line 990: asn_debug.put_line('x_curr_pay_site_id='||x_curr_pay_site_id||' and X_rcv_txns.default_pay_site_id='||X_rcv_txns.default_pay_site_id);

986:
987:
988: if (x_curr_inv_process_flag = 'Y') THEN
989: if (x_dist_count > 0 ) then -- 2531542
990: asn_debug.put_line('x_curr_pay_site_id='||x_curr_pay_site_id||' and X_rcv_txns.default_pay_site_id='||X_rcv_txns.default_pay_site_id);
991:
992: /* Bug 7512542 Calling create_invoice_num here to ensure
993: gapless invoice numbering and passing the parameters which
994: correspond to the RT record being invoiced */

Line 1006: asn_debug.put_line('Invoice Number = ' ||X_curr_invoice_num);

1002: X_curr_le_transaction_date,
1003: X_curr_packing_slip,
1004: X_curr_receipt_num);
1005:
1006: asn_debug.put_line('Invoice Number = ' ||X_curr_invoice_num);
1007:
1008: EXCEPTION
1009: WHEN others THEN
1010: asn_debug.put_line('create_invoice_num raised error');

Line 1010: asn_debug.put_line('create_invoice_num raised error');

1006: asn_debug.put_line('Invoice Number = ' ||X_curr_invoice_num);
1007:
1008: EXCEPTION
1009: WHEN others THEN
1010: asn_debug.put_line('create_invoice_num raised error');
1011: X_curr_inv_process_flag := 'N';
1012: X_first_rcv_txn_flag := 'Y';
1013: END;
1014: /* End bug 7512542 */

Line 1143: IF (g_asn_debug = 'Y') THEN

1139: IF MOD(X_invoice_count , X_commit_interval) = 0
1140: AND x_invoice_count > 0 THEN
1141: X_progress := '100';
1142:
1143: IF (g_asn_debug = 'Y') THEN
1144: asn_debug.put_line('Committing changes ... ');
1145: END IF;
1146: COMMIT;
1147: END IF;

Line 1144: asn_debug.put_line('Committing changes ... ');

1140: AND x_invoice_count > 0 THEN
1141: X_progress := '100';
1142:
1143: IF (g_asn_debug = 'Y') THEN
1144: asn_debug.put_line('Committing changes ... ');
1145: END IF;
1146: COMMIT;
1147: END IF;
1148:

Line 1166: asn_debug.put_line('create_invoice_num raised error');

1162: X_rcv_txns.pack_slip,
1163: X_rcv_txns.receipt_num);
1164: EXCEPTION
1165: WHEN others THEN
1166: asn_debug.put_line('create_invoice_num raised error');
1167: X_curr_inv_process_flag := 'N';
1168: END;
1169: END IF;*/
1170: /* End bug 7512542 */

Line 1228: asn_debug.put_line('pparthasmatch_option '||x_rcv_txns.match_option);

1224: X_rcv_txns.shipment_line_id,
1225: X_received_amount);
1226: ELSE
1227: X_received_amount := 0;
1228: asn_debug.put_line('pparthasmatch_option '||x_rcv_txns.match_option);
1229: po_invoices_sv2.get_received_quantity(X_rcv_txns.transaction_id,
1230: X_rcv_txns.shipment_line_id,
1231: X_received_quantity,
1232: X_rcv_txns.match_option ); --5100177

Line 1251: asn_debug.put_line('pparthas from shipment '||X_unit_meas_lookup_code);

1247: * from PO shipment if the match option is PO.
1248: */
1249: if X_rcv_txns.match_option = 'P' then
1250: X_unit_meas_lookup_code := X_rcv_txns.unit_meas_lookup_code;
1251: asn_debug.put_line('pparthas from shipment '||X_unit_meas_lookup_code);
1252: elsif X_rcv_txns.match_option = 'R' then
1253: X_unit_meas_lookup_code := X_rcv_txns.unit_of_measure;
1254: asn_debug.put_line('pparthas from rt '||X_unit_meas_lookup_code);
1255: end if;

Line 1254: asn_debug.put_line('pparthas from rt '||X_unit_meas_lookup_code);

1250: X_unit_meas_lookup_code := X_rcv_txns.unit_meas_lookup_code;
1251: asn_debug.put_line('pparthas from shipment '||X_unit_meas_lookup_code);
1252: elsif X_rcv_txns.match_option = 'R' then
1253: X_unit_meas_lookup_code := X_rcv_txns.unit_of_measure;
1254: asn_debug.put_line('pparthas from rt '||X_unit_meas_lookup_code);
1255: end if;
1256:
1257:
1258: if (x_received_quantity <> 0 or x_received_amount <> 0) then

Line 1352: asn_debug.put_line('Setting the values of X_curr_conversion_rate and X_curr_conversion_rate_date to NULL');

1348: /* Bug 8741094 Setting the values of X_curr_conversion_rate and X_curr_conversion_rate_date to NULL if the
1349: functional currency is the same as the foreign currency, and the currency conversion rate type is not 'User'. */
1350: IF (NVL(UPPER(x_curr_conversion_rate_type),'$#%@^$$') <> 'USER'
1351: AND X_rcv_txns.currency_code = X_def_base_currency_code) THEN
1352: asn_debug.put_line('Setting the values of X_curr_conversion_rate and X_curr_conversion_rate_date to NULL');
1353: X_curr_conversion_rate := NULL;
1354: X_curr_conversion_rate_date := NULL;
1355: END IF;
1356: /* End of fix for Bug 8741094 */

Line 1360: IF (g_asn_debug = 'Y') THEN

1356: /* End of fix for Bug 8741094 */
1357:
1358: /* Removed the fix of 2379414 from here as it is already commented */
1359:
1360: IF (g_asn_debug = 'Y') THEN
1361: asn_debug.put_line('creating invoice distributions');
1362: END IF;
1363:
1364: /* Bug 7512542 Calling create_invoice_num here to ensure gapless invoicing */

Line 1361: asn_debug.put_line('creating invoice distributions');

1357:
1358: /* Removed the fix of 2379414 from here as it is already commented */
1359:
1360: IF (g_asn_debug = 'Y') THEN
1361: asn_debug.put_line('creating invoice distributions');
1362: END IF;
1363:
1364: /* Bug 7512542 Calling create_invoice_num here to ensure gapless invoicing */
1365:

Line 1384: asn_debug.put_line('Invoice Number = ' ||X_curr_invoice_num);

1380: X_curr_le_transaction_date,
1381: X_curr_packing_slip,
1382: X_curr_receipt_num);
1383:
1384: asn_debug.put_line('Invoice Number = ' ||X_curr_invoice_num);
1385:
1386: EXCEPTION
1387: WHEN others THEN
1388: asn_debug.put_line('create_invoice_num raised error');

Line 1388: asn_debug.put_line('create_invoice_num raised error');

1384: asn_debug.put_line('Invoice Number = ' ||X_curr_invoice_num);
1385:
1386: EXCEPTION
1387: WHEN others THEN
1388: asn_debug.put_line('create_invoice_num raised error');
1389: X_curr_inv_process_flag := 'N';
1390: X_first_rcv_txn_flag := 'Y';
1391:
1392: END;

Line 1466: IF (g_asn_debug = 'Y') THEN

1462:
1463:
1464: END IF; -- if X_rcv_first_flag
1465:
1466: IF (g_asn_debug = 'Y') THEN
1467: asn_debug.put_line('Completed create receipt invoices program... ');
1468: END IF;
1469:
1470: select count(*) into x_dist_count

Line 1467: asn_debug.put_line('Completed create receipt invoices program... ');

1463:
1464: END IF; -- if X_rcv_first_flag
1465:
1466: IF (g_asn_debug = 'Y') THEN
1467: asn_debug.put_line('Completed create receipt invoices program... ');
1468: END IF;
1469:
1470: select count(*) into x_dist_count
1471: from ap_invoice_lines_interface

Line 1528: IF (g_asn_debug = 'Y') THEN

1524: fnd_message.set_name('PO', 'PO_ERS_CONC_REQUEST_CHECK');
1525: fnd_message.set_token('REQUEST', TO_CHAR(v_req_id));
1526: fnd_message.set_token('BATCH', x_group_id);
1527:
1528: IF (g_asn_debug = 'Y') THEN
1529: asn_debug.put_line(fnd_message.get);
1530: END IF;
1531: END IF;
1532:

Line 1529: asn_debug.put_line(fnd_message.get);

1525: fnd_message.set_token('REQUEST', TO_CHAR(v_req_id));
1526: fnd_message.set_token('BATCH', x_group_id);
1527:
1528: IF (g_asn_debug = 'Y') THEN
1529: asn_debug.put_line(fnd_message.get);
1530: END IF;
1531: END IF;
1532:
1533: RETURN (X_completion_status);

Line 1540: IF (g_asn_debug = 'Y') THEN

1536:
1537: /* */
1538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1539: l_error_msg := FND_MSG_PUB.get(p_encoded => 'F');
1540: IF (g_asn_debug = 'Y') THEN
1541: ASN_DEBUG.put_line(l_error_msg);
1542: END IF;
1543: RAISE;
1544: /* */

Line 1541: ASN_DEBUG.put_line(l_error_msg);

1537: /* */
1538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1539: l_error_msg := FND_MSG_PUB.get(p_encoded => 'F');
1540: IF (g_asn_debug = 'Y') THEN
1541: ASN_DEBUG.put_line(l_error_msg);
1542: END IF;
1543: RAISE;
1544: /* */
1545: WHEN others THEN

Line 1546: IF (g_asn_debug = 'Y') THEN

1542: END IF;
1543: RAISE;
1544: /* */
1545: WHEN others THEN
1546: IF (g_asn_debug = 'Y') THEN
1547: asn_debug.put_line('Error in Create Receipt Invoices ...');
1548: END IF;
1549: po_message_s.sql_error('create_receipt_invoices', X_progress, sqlcode);
1550: RAISE;

Line 1547: asn_debug.put_line('Error in Create Receipt Invoices ...');

1543: RAISE;
1544: /* */
1545: WHEN others THEN
1546: IF (g_asn_debug = 'Y') THEN
1547: asn_debug.put_line('Error in Create Receipt Invoices ...');
1548: END IF;
1549: po_message_s.sql_error('create_receipt_invoices', X_progress, sqlcode);
1550: RAISE;
1551: END create_receipt_invoices;

Line 1614: IF (g_asn_debug = 'Y') THEN

1610: X_pay_cross_rate NUMBER;
1611: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;
1612:
1613: BEGIN
1614: IF (g_asn_debug = 'Y') THEN
1615: asn_debug.put_line('Wrapping up the current invoice ... ');
1616: END IF;
1617:
1618: IF (X_curr_inv_process_flag = 'Y') THEN

Line 1615: asn_debug.put_line('Wrapping up the current invoice ... ');

1611: X_ap_pay_curr po_vendor_sites.payment_currency_code%TYPE;
1612:
1613: BEGIN
1614: IF (g_asn_debug = 'Y') THEN
1615: asn_debug.put_line('Wrapping up the current invoice ... ');
1616: END IF;
1617:
1618: IF (X_curr_inv_process_flag = 'Y') THEN
1619: X_progress := '010';

Line 1642: IF (g_asn_debug = 'Y') THEN

1638: ELSE
1639: X_ap_pay_curr := X_curr_pay_curr_code;
1640: END IF;
1641:
1642: IF (g_asn_debug = 'Y') THEN
1643: asn_debug.put_line ('x_pay_cross_rate ='|| x_pay_cross_rate);
1644: asn_debug.put_line ('X_pay_curr_invoice_amount ='|| ap_utilities_pkg.ap_round_currency(X_curr_invoice_amount * X_pay_cross_rate, X_ap_pay_curr));
1645: END IF;
1646:

Line 1643: asn_debug.put_line ('x_pay_cross_rate ='|| x_pay_cross_rate);

1639: X_ap_pay_curr := X_curr_pay_curr_code;
1640: END IF;
1641:
1642: IF (g_asn_debug = 'Y') THEN
1643: asn_debug.put_line ('x_pay_cross_rate ='|| x_pay_cross_rate);
1644: asn_debug.put_line ('X_pay_curr_invoice_amount ='|| ap_utilities_pkg.ap_round_currency(X_curr_invoice_amount * X_pay_cross_rate, X_ap_pay_curr));
1645: END IF;
1646:
1647: -- create invoice header here

Line 1644: asn_debug.put_line ('X_pay_curr_invoice_amount ='|| ap_utilities_pkg.ap_round_currency(X_curr_invoice_amount * X_pay_cross_rate, X_ap_pay_curr));

1640: END IF;
1641:
1642: IF (g_asn_debug = 'Y') THEN
1643: asn_debug.put_line ('x_pay_cross_rate ='|| x_pay_cross_rate);
1644: asn_debug.put_line ('X_pay_curr_invoice_amount ='|| ap_utilities_pkg.ap_round_currency(X_curr_invoice_amount * X_pay_cross_rate, X_ap_pay_curr));
1645: END IF;
1646:
1647: -- create invoice header here
1648:

Line 1735: IF (g_asn_debug = 'Y') THEN

1731: x_invoice_num VARCHAR2 (45);
1732: -- SBI ENH
1733:
1734: BEGIN
1735: IF (g_asn_debug = 'Y') THEN
1736: asn_debug.put_line ('Constructing Invoice Num for the invoice ... ');
1737: END IF;
1738:
1739: x_progress := '001';

Line 1736: asn_debug.put_line ('Constructing Invoice Num for the invoice ... ');

1732: -- SBI ENH
1733:
1734: BEGIN
1735: IF (g_asn_debug = 'Y') THEN
1736: asn_debug.put_line ('Constructing Invoice Num for the invoice ... ');
1737: END IF;
1738:
1739: x_progress := '001';
1740:

Line 1793: IF (g_asn_debug = 'Y') THEN

1789: x_return_status ,
1790: x_msg_count ,
1791: x_msg_data
1792: );
1793: IF (g_asn_debug = 'Y') THEN
1794: asn_debug.put_line ('rcv_gapless_numbering.generate_invoice_number returned with status = ' || x_return_status );
1795: asn_debug.put_line ('x_invoice_num = ' || x_invoice_num );
1796: END IF;
1797:

Line 1794: asn_debug.put_line ('rcv_gapless_numbering.generate_invoice_number returned with status = ' || x_return_status );

1790: x_msg_count ,
1791: x_msg_data
1792: );
1793: IF (g_asn_debug = 'Y') THEN
1794: asn_debug.put_line ('rcv_gapless_numbering.generate_invoice_number returned with status = ' || x_return_status );
1795: asn_debug.put_line ('x_invoice_num = ' || x_invoice_num );
1796: END IF;
1797:
1798: IF (x_return_status = fnd_api.g_ret_sts_success and x_invoice_num is NOT NULL)

Line 1795: asn_debug.put_line ('x_invoice_num = ' || x_invoice_num );

1791: x_msg_data
1792: );
1793: IF (g_asn_debug = 'Y') THEN
1794: asn_debug.put_line ('rcv_gapless_numbering.generate_invoice_number returned with status = ' || x_return_status );
1795: asn_debug.put_line ('x_invoice_num = ' || x_invoice_num );
1796: END IF;
1797:
1798: IF (x_return_status = fnd_api.g_ret_sts_success and x_invoice_num is NOT NULL)
1799: THEN

Line 2008: IF (g_asn_debug = 'Y') THEN

2004: X_received_quantity);
2005: exception
2006: WHEN NO_DATA_FOUND THEN
2007:
2008: IF (g_asn_debug = 'Y') THEN
2009: asn_debug.put_line('conversion not defined between uoms '||x_primary_uom||' and '||X_po_uom);
2010:
2011: END IF;
2012: RAISE;

Line 2009: asn_debug.put_line('conversion not defined between uoms '||x_primary_uom||' and '||X_po_uom);

2005: exception
2006: WHEN NO_DATA_FOUND THEN
2007:
2008: IF (g_asn_debug = 'Y') THEN
2009: asn_debug.put_line('conversion not defined between uoms '||x_primary_uom||' and '||X_po_uom);
2010:
2011: END IF;
2012: RAISE;
2013:

Line 2016: IF (g_asn_debug = 'Y') THEN

2012: RAISE;
2013:
2014: WHEN OTHERS THEN
2015:
2016: IF (g_asn_debug = 'Y') THEN
2017: asn_debug.put_line('Exception occured while converting from uom '||x_primary_uom||' to uom '||X_po_uom);
2018: asn_debug.put_line('Check if conversion exists between uoms '||x_primary_uom||' and '||X_po_uom);
2019: END IF;
2020: RAISE;

Line 2017: asn_debug.put_line('Exception occured while converting from uom '||x_primary_uom||' to uom '||X_po_uom);

2013:
2014: WHEN OTHERS THEN
2015:
2016: IF (g_asn_debug = 'Y') THEN
2017: asn_debug.put_line('Exception occured while converting from uom '||x_primary_uom||' to uom '||X_po_uom);
2018: asn_debug.put_line('Check if conversion exists between uoms '||x_primary_uom||' and '||X_po_uom);
2019: END IF;
2020: RAISE;
2021: END;

Line 2018: asn_debug.put_line('Check if conversion exists between uoms '||x_primary_uom||' and '||X_po_uom);

2014: WHEN OTHERS THEN
2015:
2016: IF (g_asn_debug = 'Y') THEN
2017: asn_debug.put_line('Exception occured while converting from uom '||x_primary_uom||' to uom '||X_po_uom);
2018: asn_debug.put_line('Check if conversion exists between uoms '||x_primary_uom||' and '||X_po_uom);
2019: END IF;
2020: RAISE;
2021: END;
2022: ELSE

Line 2288: IF (g_asn_debug = 'Y') THEN

2284: x_po_uom po_lines_all.unit_meas_lookup_code%type; -- Added for bug 6822594
2285: X_conversion_factor NUMBER :=0; -- Added for bug 6822594
2286:
2287: BEGIN
2288: IF (g_asn_debug = 'Y') THEN
2289: asn_debug.put_line('Begin Create Invoice Distributions ');
2290:
2291: /* PoR with LCM project Begin */
2292: asn_debug.put_line('X_quantity: '||X_quantity);

Line 2289: asn_debug.put_line('Begin Create Invoice Distributions ');

2285: X_conversion_factor NUMBER :=0; -- Added for bug 6822594
2286:
2287: BEGIN
2288: IF (g_asn_debug = 'Y') THEN
2289: asn_debug.put_line('Begin Create Invoice Distributions ');
2290:
2291: /* PoR with LCM project Begin */
2292: asn_debug.put_line('X_quantity: '||X_quantity);
2293: asn_debug.put_line('X_unit_price: '||X_unit_price);

Line 2292: asn_debug.put_line('X_quantity: '||X_quantity);

2288: IF (g_asn_debug = 'Y') THEN
2289: asn_debug.put_line('Begin Create Invoice Distributions ');
2290:
2291: /* PoR with LCM project Begin */
2292: asn_debug.put_line('X_quantity: '||X_quantity);
2293: asn_debug.put_line('X_unit_price: '||X_unit_price);
2294: asn_debug.put_line('X_exchange_rate_type: '||X_exchange_rate_type);
2295: asn_debug.put_line('X_exchange_date: '||X_exchange_date);
2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);

Line 2293: asn_debug.put_line('X_unit_price: '||X_unit_price);

2289: asn_debug.put_line('Begin Create Invoice Distributions ');
2290:
2291: /* PoR with LCM project Begin */
2292: asn_debug.put_line('X_quantity: '||X_quantity);
2293: asn_debug.put_line('X_unit_price: '||X_unit_price);
2294: asn_debug.put_line('X_exchange_rate_type: '||X_exchange_rate_type);
2295: asn_debug.put_line('X_exchange_date: '||X_exchange_date);
2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);
2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);

Line 2294: asn_debug.put_line('X_exchange_rate_type: '||X_exchange_rate_type);

2290:
2291: /* PoR with LCM project Begin */
2292: asn_debug.put_line('X_quantity: '||X_quantity);
2293: asn_debug.put_line('X_unit_price: '||X_unit_price);
2294: asn_debug.put_line('X_exchange_rate_type: '||X_exchange_rate_type);
2295: asn_debug.put_line('X_exchange_date: '||X_exchange_date);
2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);
2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);
2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);

Line 2295: asn_debug.put_line('X_exchange_date: '||X_exchange_date);

2291: /* PoR with LCM project Begin */
2292: asn_debug.put_line('X_quantity: '||X_quantity);
2293: asn_debug.put_line('X_unit_price: '||X_unit_price);
2294: asn_debug.put_line('X_exchange_rate_type: '||X_exchange_rate_type);
2295: asn_debug.put_line('X_exchange_date: '||X_exchange_date);
2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);
2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);
2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);
2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);

Line 2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);

2292: asn_debug.put_line('X_quantity: '||X_quantity);
2293: asn_debug.put_line('X_unit_price: '||X_unit_price);
2294: asn_debug.put_line('X_exchange_rate_type: '||X_exchange_rate_type);
2295: asn_debug.put_line('X_exchange_date: '||X_exchange_date);
2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);
2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);
2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);
2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);
2300: asn_debug.put_line('X_reference_1: '||X_reference_1);

Line 2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);

2293: asn_debug.put_line('X_unit_price: '||X_unit_price);
2294: asn_debug.put_line('X_exchange_rate_type: '||X_exchange_rate_type);
2295: asn_debug.put_line('X_exchange_date: '||X_exchange_date);
2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);
2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);
2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);
2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);
2300: asn_debug.put_line('X_reference_1: '||X_reference_1);
2301: asn_debug.put_line('X_reference_2: '||X_reference_2);

Line 2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);

2294: asn_debug.put_line('X_exchange_rate_type: '||X_exchange_rate_type);
2295: asn_debug.put_line('X_exchange_date: '||X_exchange_date);
2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);
2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);
2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);
2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);
2300: asn_debug.put_line('X_reference_1: '||X_reference_1);
2301: asn_debug.put_line('X_reference_2: '||X_reference_2);
2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);

Line 2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);

2295: asn_debug.put_line('X_exchange_date: '||X_exchange_date);
2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);
2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);
2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);
2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);
2300: asn_debug.put_line('X_reference_1: '||X_reference_1);
2301: asn_debug.put_line('X_reference_2: '||X_reference_2);
2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);
2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);

Line 2300: asn_debug.put_line('X_reference_1: '||X_reference_1);

2296: asn_debug.put_line('X_exchange_rate: '||X_exchange_rate);
2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);
2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);
2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);
2300: asn_debug.put_line('X_reference_1: '||X_reference_1);
2301: asn_debug.put_line('X_reference_2: '||X_reference_2);
2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);
2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);
2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);

Line 2301: asn_debug.put_line('X_reference_2: '||X_reference_2);

2297: asn_debug.put_line('X_invoice_date: '||X_invoice_date);
2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);
2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);
2300: asn_debug.put_line('X_reference_1: '||X_reference_1);
2301: asn_debug.put_line('X_reference_2: '||X_reference_2);
2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);
2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);
2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);
2305: asn_debug.put_line('X_period_name: '||X_period_name);

Line 2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);

2298: asn_debug.put_line('X_receipt_date: '||X_receipt_date);
2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);
2300: asn_debug.put_line('X_reference_1: '||X_reference_1);
2301: asn_debug.put_line('X_reference_2: '||X_reference_2);
2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);
2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);
2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);
2305: asn_debug.put_line('X_period_name: '||X_period_name);
2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);

Line 2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);

2299: asn_debug.put_line('X_vendor_income_tax_region: '||X_vendor_income_tax_region);
2300: asn_debug.put_line('X_reference_1: '||X_reference_1);
2301: asn_debug.put_line('X_reference_2: '||X_reference_2);
2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);
2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);
2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);
2305: asn_debug.put_line('X_period_name: '||X_period_name);
2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2307: asn_debug.put_line('X_unique_id: '||X_unique_id);

Line 2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);

2300: asn_debug.put_line('X_reference_1: '||X_reference_1);
2301: asn_debug.put_line('X_reference_2: '||X_reference_2);
2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);
2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);
2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);
2305: asn_debug.put_line('X_period_name: '||X_period_name);
2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2307: asn_debug.put_line('X_unique_id: '||X_unique_id);
2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);

Line 2305: asn_debug.put_line('X_period_name: '||X_period_name);

2301: asn_debug.put_line('X_reference_2: '||X_reference_2);
2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);
2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);
2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);
2305: asn_debug.put_line('X_period_name: '||X_period_name);
2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2307: asn_debug.put_line('X_unique_id: '||X_unique_id);
2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);
2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);

Line 2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);

2302: asn_debug.put_line('X_awt_flag: '||X_awt_flag);
2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);
2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);
2305: asn_debug.put_line('X_period_name: '||X_period_name);
2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2307: asn_debug.put_line('X_unique_id: '||X_unique_id);
2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);
2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);
2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);

Line 2307: asn_debug.put_line('X_unique_id: '||X_unique_id);

2303: asn_debug.put_line('X_awt_group_id: '||X_awt_group_id);
2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);
2305: asn_debug.put_line('X_period_name: '||X_period_name);
2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2307: asn_debug.put_line('X_unique_id: '||X_unique_id);
2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);
2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);
2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);
2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);

Line 2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);

2304: asn_debug.put_line('X_accounting_date: '||X_accounting_date);
2305: asn_debug.put_line('X_period_name: '||X_period_name);
2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2307: asn_debug.put_line('X_unique_id: '||X_unique_id);
2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);
2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);
2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);
2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);
2312: asn_debug.put_line('X_match_option: '||X_match_option);

Line 2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);

2305: asn_debug.put_line('X_period_name: '||X_period_name);
2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2307: asn_debug.put_line('X_unique_id: '||X_unique_id);
2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);
2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);
2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);
2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);
2312: asn_debug.put_line('X_match_option: '||X_match_option);
2313: asn_debug.put_line('X_amount: '||X_amount);

Line 2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);

2306: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2307: asn_debug.put_line('X_unique_id: '||X_unique_id);
2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);
2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);
2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);
2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);
2312: asn_debug.put_line('X_match_option: '||X_match_option);
2313: asn_debug.put_line('X_amount: '||X_amount);
2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);

Line 2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);

2307: asn_debug.put_line('X_unique_id: '||X_unique_id);
2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);
2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);
2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);
2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);
2312: asn_debug.put_line('X_match_option: '||X_match_option);
2313: asn_debug.put_line('X_amount: '||X_amount);
2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);
2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);

Line 2312: asn_debug.put_line('X_match_option: '||X_match_option);

2308: asn_debug.put_line('X_curr_invoice_amount: '||X_curr_invoice_amount);
2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);
2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);
2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);
2312: asn_debug.put_line('X_match_option: '||X_match_option);
2313: asn_debug.put_line('X_amount: '||X_amount);
2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);
2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);
2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);

Line 2313: asn_debug.put_line('X_amount: '||X_amount);

2309: asn_debug.put_line('X_curr_inv_process_flag: '||X_curr_inv_process_flag);
2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);
2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);
2312: asn_debug.put_line('X_match_option: '||X_match_option);
2313: asn_debug.put_line('X_amount: '||X_amount);
2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);
2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);
2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);
2317: asn_debug.put_line('X_base_currency_code: '||X_base_currency_code);

Line 2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);

2310: asn_debug.put_line('X_receipt_num: '||X_receipt_num);
2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);
2312: asn_debug.put_line('X_match_option: '||X_match_option);
2313: asn_debug.put_line('X_amount: '||X_amount);
2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);
2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);
2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);
2317: asn_debug.put_line('X_base_currency_code: '||X_base_currency_code);
2318: asn_debug.put_line('X_transaction_type: '||X_transaction_type);

Line 2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);

2311: asn_debug.put_line('X_rcv_transaction_id: '||X_rcv_transaction_id);
2312: asn_debug.put_line('X_match_option: '||X_match_option);
2313: asn_debug.put_line('X_amount: '||X_amount);
2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);
2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);
2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);
2317: asn_debug.put_line('X_base_currency_code: '||X_base_currency_code);
2318: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2319: asn_debug.put_line('X_receipt_event: '||X_receipt_event);

Line 2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);

2312: asn_debug.put_line('X_match_option: '||X_match_option);
2313: asn_debug.put_line('X_amount: '||X_amount);
2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);
2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);
2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);
2317: asn_debug.put_line('X_base_currency_code: '||X_base_currency_code);
2318: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2319: asn_debug.put_line('X_receipt_event: '||X_receipt_event);
2320: asn_debug.put_line('X_lcm_shipment_line_id: '||X_lcm_shipment_line_id);

Line 2317: asn_debug.put_line('X_base_currency_code: '||X_base_currency_code);

2313: asn_debug.put_line('X_amount: '||X_amount);
2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);
2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);
2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);
2317: asn_debug.put_line('X_base_currency_code: '||X_base_currency_code);
2318: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2319: asn_debug.put_line('X_receipt_event: '||X_receipt_event);
2320: asn_debug.put_line('X_lcm_shipment_line_id: '||X_lcm_shipment_line_id);
2321: /* PoR with LCM project End */

Line 2318: asn_debug.put_line('X_transaction_type: '||X_transaction_type);

2314: asn_debug.put_line('X_matching_basis: '||X_matching_basis);
2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);
2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);
2317: asn_debug.put_line('X_base_currency_code: '||X_base_currency_code);
2318: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2319: asn_debug.put_line('X_receipt_event: '||X_receipt_event);
2320: asn_debug.put_line('X_lcm_shipment_line_id: '||X_lcm_shipment_line_id);
2321: /* PoR with LCM project End */
2322: END IF;

Line 2319: asn_debug.put_line('X_receipt_event: '||X_receipt_event);

2315: asn_debug.put_line('X_unit_meas_lookup_code: '||X_unit_meas_lookup_code);
2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);
2317: asn_debug.put_line('X_base_currency_code: '||X_base_currency_code);
2318: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2319: asn_debug.put_line('X_receipt_event: '||X_receipt_event);
2320: asn_debug.put_line('X_lcm_shipment_line_id: '||X_lcm_shipment_line_id);
2321: /* PoR with LCM project End */
2322: END IF;
2323:

Line 2320: asn_debug.put_line('X_lcm_shipment_line_id: '||X_lcm_shipment_line_id);

2316: asn_debug.put_line('X_invoice_currency_code: '||X_invoice_currency_code);
2317: asn_debug.put_line('X_base_currency_code: '||X_base_currency_code);
2318: asn_debug.put_line('X_transaction_type: '||X_transaction_type);
2319: asn_debug.put_line('X_receipt_event: '||X_receipt_event);
2320: asn_debug.put_line('X_lcm_shipment_line_id: '||X_lcm_shipment_line_id);
2321: /* PoR with LCM project End */
2322: END IF;
2323:
2324: /********************

Line 2368: IF (g_asn_debug = 'Y') THEN

2364:
2365: /* Removed the fix of 2379414 as it is already commented */
2366:
2367: /* PoR with LCM project Begin */
2368: IF (g_asn_debug = 'Y') THEN
2369: asn_debug.put_line('X_sum_order_qty: '||X_sum_order_qty);
2370: asn_debug.put_line('X_sum_order_amt: '||X_sum_order_amt);
2371: END IF;
2372: /* PoR with LCM project End */

Line 2369: asn_debug.put_line('X_sum_order_qty: '||X_sum_order_qty);

2365: /* Removed the fix of 2379414 as it is already commented */
2366:
2367: /* PoR with LCM project Begin */
2368: IF (g_asn_debug = 'Y') THEN
2369: asn_debug.put_line('X_sum_order_qty: '||X_sum_order_qty);
2370: asn_debug.put_line('X_sum_order_amt: '||X_sum_order_amt);
2371: END IF;
2372: /* PoR with LCM project End */
2373:

Line 2370: asn_debug.put_line('X_sum_order_amt: '||X_sum_order_amt);

2366:
2367: /* PoR with LCM project Begin */
2368: IF (g_asn_debug = 'Y') THEN
2369: asn_debug.put_line('X_sum_order_qty: '||X_sum_order_qty);
2370: asn_debug.put_line('X_sum_order_amt: '||X_sum_order_amt);
2371: END IF;
2372: /* PoR with LCM project End */
2373:
2374: IF (X_count > 0) THEN

Line 2448: IF (g_asn_debug = 'Y') THEN

2444: x_curr_qty := x_quantity;
2445: END IF;
2446:
2447: /* PoR with LCM project Begin */
2448: IF (g_asn_debug = 'Y') THEN
2449: asn_debug.put_line('x_curr_amount: '||x_curr_amount);
2450: asn_debug.put_line('x_curr_qty: '||x_curr_qty);
2451: END IF;
2452: /* PoR with LCM project End */

Line 2449: asn_debug.put_line('x_curr_amount: '||x_curr_amount);

2445: END IF;
2446:
2447: /* PoR with LCM project Begin */
2448: IF (g_asn_debug = 'Y') THEN
2449: asn_debug.put_line('x_curr_amount: '||x_curr_amount);
2450: asn_debug.put_line('x_curr_qty: '||x_curr_qty);
2451: END IF;
2452: /* PoR with LCM project End */
2453:

Line 2450: asn_debug.put_line('x_curr_qty: '||x_curr_qty);

2446:
2447: /* PoR with LCM project Begin */
2448: IF (g_asn_debug = 'Y') THEN
2449: asn_debug.put_line('x_curr_amount: '||x_curr_amount);
2450: asn_debug.put_line('x_curr_qty: '||x_curr_qty);
2451: END IF;
2452: /* PoR with LCM project End */
2453:
2454: X_progress := '085';

Line 2471: IF (g_asn_debug = 'Y') THEN

2467: X_invoice_currency_code);
2468: END IF;
2469:
2470: /* PoR with LCM project Begin */
2471: IF (g_asn_debug = 'Y') THEN
2472: asn_debug.put_line('x_curr_amount: '||x_curr_amount);
2473: asn_debug.put_line('x_curr_qty: '||x_curr_qty);
2474: asn_debug.put_line('X_conversion_rate: '||X_conversion_rate);
2475: END IF;

Line 2472: asn_debug.put_line('x_curr_amount: '||x_curr_amount);

2468: END IF;
2469:
2470: /* PoR with LCM project Begin */
2471: IF (g_asn_debug = 'Y') THEN
2472: asn_debug.put_line('x_curr_amount: '||x_curr_amount);
2473: asn_debug.put_line('x_curr_qty: '||x_curr_qty);
2474: asn_debug.put_line('X_conversion_rate: '||X_conversion_rate);
2475: END IF;
2476: /* PoR with LCM project End */

Line 2473: asn_debug.put_line('x_curr_qty: '||x_curr_qty);

2469:
2470: /* PoR with LCM project Begin */
2471: IF (g_asn_debug = 'Y') THEN
2472: asn_debug.put_line('x_curr_amount: '||x_curr_amount);
2473: asn_debug.put_line('x_curr_qty: '||x_curr_qty);
2474: asn_debug.put_line('X_conversion_rate: '||X_conversion_rate);
2475: END IF;
2476: /* PoR with LCM project End */
2477:

Line 2474: asn_debug.put_line('X_conversion_rate: '||X_conversion_rate);

2470: /* PoR with LCM project Begin */
2471: IF (g_asn_debug = 'Y') THEN
2472: asn_debug.put_line('x_curr_amount: '||x_curr_amount);
2473: asn_debug.put_line('x_curr_qty: '||x_curr_qty);
2474: asn_debug.put_line('X_conversion_rate: '||X_conversion_rate);
2475: END IF;
2476: /* PoR with LCM project End */
2477:
2478: X_progress := '140';

Line 2494: IF (g_asn_debug = 'Y') THEN

2490: X_base_currency_code);
2491: END IF;
2492:
2493: /* PoR with LCM project Begin*/
2494: IF (g_asn_debug = 'Y') THEN
2495: asn_debug.put_line('X_base_amount: '||X_base_amount);
2496: END IF;
2497: /* PoR with LCM project End */
2498:

Line 2495: asn_debug.put_line('X_base_amount: '||X_base_amount);

2491: END IF;
2492:
2493: /* PoR with LCM project Begin*/
2494: IF (g_asn_debug = 'Y') THEN
2495: asn_debug.put_line('X_base_amount: '||X_base_amount);
2496: END IF;
2497: /* PoR with LCM project End */
2498:
2499: /*** call object handler to create the item distributions ***/

Line 2502: IF (g_asn_debug = 'Y') THEN

2498:
2499: /*** call object handler to create the item distributions ***/
2500: X_progress := '140';
2501:
2502: IF (g_asn_debug = 'Y') THEN
2503: asn_debug.put_line('Creating Item Distribution...');
2504: END IF;
2505:
2506:

Line 2503: asn_debug.put_line('Creating Item Distribution...');

2499: /*** call object handler to create the item distributions ***/
2500: X_progress := '140';
2501:
2502: IF (g_asn_debug = 'Y') THEN
2503: asn_debug.put_line('Creating Item Distribution...');
2504: END IF;
2505:
2506:
2507: SELECT NVL(MAX(line_number), 0) + 1

Line 2584: IF (g_asn_debug = 'Y') THEN

2580: X_invoiced_unit_price := X_unit_price ;
2581: END IF;
2582:
2583: /* PoR with LCM project Begin */
2584: IF (g_asn_debug = 'Y') THEN
2585: asn_debug.put_line('X_invoiced_quantity: '||X_invoiced_quantity);
2586: asn_debug.put_line('X_conversion_factor: '||X_conversion_factor);
2587: asn_debug.put_line('X_invoiced_unit_price: '||X_invoiced_unit_price);
2588: asn_debug.put_line('x_invoiced_amount: '||x_invoiced_amount);

Line 2585: asn_debug.put_line('X_invoiced_quantity: '||X_invoiced_quantity);

2581: END IF;
2582:
2583: /* PoR with LCM project Begin */
2584: IF (g_asn_debug = 'Y') THEN
2585: asn_debug.put_line('X_invoiced_quantity: '||X_invoiced_quantity);
2586: asn_debug.put_line('X_conversion_factor: '||X_conversion_factor);
2587: asn_debug.put_line('X_invoiced_unit_price: '||X_invoiced_unit_price);
2588: asn_debug.put_line('x_invoiced_amount: '||x_invoiced_amount);
2589: END IF;

Line 2586: asn_debug.put_line('X_conversion_factor: '||X_conversion_factor);

2582:
2583: /* PoR with LCM project Begin */
2584: IF (g_asn_debug = 'Y') THEN
2585: asn_debug.put_line('X_invoiced_quantity: '||X_invoiced_quantity);
2586: asn_debug.put_line('X_conversion_factor: '||X_conversion_factor);
2587: asn_debug.put_line('X_invoiced_unit_price: '||X_invoiced_unit_price);
2588: asn_debug.put_line('x_invoiced_amount: '||x_invoiced_amount);
2589: END IF;
2590: /* PoR with LCM project End */

Line 2587: asn_debug.put_line('X_invoiced_unit_price: '||X_invoiced_unit_price);

2583: /* PoR with LCM project Begin */
2584: IF (g_asn_debug = 'Y') THEN
2585: asn_debug.put_line('X_invoiced_quantity: '||X_invoiced_quantity);
2586: asn_debug.put_line('X_conversion_factor: '||X_conversion_factor);
2587: asn_debug.put_line('X_invoiced_unit_price: '||X_invoiced_unit_price);
2588: asn_debug.put_line('x_invoiced_amount: '||x_invoiced_amount);
2589: END IF;
2590: /* PoR with LCM project End */
2591:

Line 2588: asn_debug.put_line('x_invoiced_amount: '||x_invoiced_amount);

2584: IF (g_asn_debug = 'Y') THEN
2585: asn_debug.put_line('X_invoiced_quantity: '||X_invoiced_quantity);
2586: asn_debug.put_line('X_conversion_factor: '||X_conversion_factor);
2587: asn_debug.put_line('X_invoiced_unit_price: '||X_invoiced_unit_price);
2588: asn_debug.put_line('x_invoiced_amount: '||x_invoiced_amount);
2589: END IF;
2590: /* PoR with LCM project End */
2591:
2592: insert into ap_invoice_lines_interface

Line 2711: IF (g_asn_debug = 'Y') THEN

2707:
2708: ELSE /** X_count = 0, this should be an error we should have atleast one
2709: distribution for our rcv. txn.**/
2710:
2711: IF (g_asn_debug = 'Y') THEN
2712: asn_debug.put_line('->Error: No distr available.');
2713: END IF;
2714: po_interface_errors_sv1.handle_interface_errors(
2715: X_transaction_type,

Line 2712: asn_debug.put_line('->Error: No distr available.');

2708: ELSE /** X_count = 0, this should be an error we should have atleast one
2709: distribution for our rcv. txn.**/
2710:
2711: IF (g_asn_debug = 'Y') THEN
2712: asn_debug.put_line('->Error: No distr available.');
2713: END IF;
2714: po_interface_errors_sv1.handle_interface_errors(
2715: X_transaction_type,
2716: 'FATAL',

Line 2790: IF (g_asn_debug = 'Y') THEN

2786: l_progress VARCHAR2(3);
2787: BEGIN
2788: l_progress := '000';
2789:
2790: IF (g_asn_debug = 'Y') THEN
2791: ASN_DEBUG.put_line('Enter create use invoices');
2792: END IF;
2793:
2794: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2791: ASN_DEBUG.put_line('Enter create use invoices');

2787: BEGIN
2788: l_progress := '000';
2789:
2790: IF (g_asn_debug = 'Y') THEN
2791: ASN_DEBUG.put_line('Enter create use invoices');
2792: END IF;
2793:
2794: x_return_status := FND_API.G_RET_STS_SUCCESS;
2795:

Line 2805: IF (g_asn_debug = 'Y') THEN

2801: THEN
2802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2803: END IF; -- check api version compatibility
2804:
2805: IF (g_asn_debug = 'Y') THEN
2806: ASN_DEBUG.put_line('API Version Check is passed');
2807: END IF;
2808:
2809: l_progress := '010';

Line 2806: ASN_DEBUG.put_line('API Version Check is passed');

2802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2803: END IF; -- check api version compatibility
2804:
2805: IF (g_asn_debug = 'Y') THEN
2806: ASN_DEBUG.put_line('API Version Check is passed');
2807: END IF;
2808:
2809: l_progress := '010';
2810:

Line 2811: IF (g_asn_debug = 'Y') THEN

2807: END IF;
2808:
2809: l_progress := '010';
2810:
2811: IF (g_asn_debug = 'Y') THEN
2812: ASN_DEBUG.put_line('Aging period passing in = ' || p_aging_period);
2813: END IF;
2814:
2815: IF (p_aging_period IS NULL) THEN

Line 2812: ASN_DEBUG.put_line('Aging period passing in = ' || p_aging_period);

2808:
2809: l_progress := '010';
2810:
2811: IF (g_asn_debug = 'Y') THEN
2812: ASN_DEBUG.put_line('Aging period passing in = ' || p_aging_period);
2813: END IF;
2814:
2815: IF (p_aging_period IS NULL) THEN
2816:

Line 2817: IF (g_asn_debug = 'Y') THEN

2813: END IF;
2814:
2815: IF (p_aging_period IS NULL) THEN
2816:
2817: IF (g_asn_debug = 'Y') THEN
2818: ASN_DEBUG.put_line('Getting aging period from profile');
2819: END IF;
2820:
2821: l_aging_period :=

Line 2818: ASN_DEBUG.put_line('Getting aging period from profile');

2814:
2815: IF (p_aging_period IS NULL) THEN
2816:
2817: IF (g_asn_debug = 'Y') THEN
2818: ASN_DEBUG.put_line('Getting aging period from profile');
2819: END IF;
2820:
2821: l_aging_period :=
2822: NVL(FLOOR(TO_NUMBER(FND_PROFILE.VALUE('AGING_PERIOD'))), 0);

Line 2824: IF (g_asn_debug = 'Y') THEN

2820:
2821: l_aging_period :=
2822: NVL(FLOOR(TO_NUMBER(FND_PROFILE.VALUE('AGING_PERIOD'))), 0);
2823:
2824: IF (g_asn_debug = 'Y') THEN
2825: ASN_DEBUG.put_line('After getting aging period from profile,
2826: aging period = ' || l_aging_period);
2827: END IF;
2828:

Line 2825: ASN_DEBUG.put_line('After getting aging period from profile,

2821: l_aging_period :=
2822: NVL(FLOOR(TO_NUMBER(FND_PROFILE.VALUE('AGING_PERIOD'))), 0);
2823:
2824: IF (g_asn_debug = 'Y') THEN
2825: ASN_DEBUG.put_line('After getting aging period from profile,
2826: aging period = ' || l_aging_period);
2827: END IF;
2828:
2829: IF (l_aging_period < 0) THEN

Line 2838: IF (g_asn_debug = 'Y') THEN

2834: END IF; -- p_aging_period IS NULL
2835:
2836: l_cutoff_date := TRUNC(SYSDATE) + 1 - l_aging_period;
2837:
2838: IF (g_asn_debug = 'Y') THEN
2839: ASN_DEBUG.put_line('Aging Period = ' || l_aging_period ||
2840: ' Cutoff Date = ' || l_cutoff_date);
2841: END IF;
2842:

Line 2839: ASN_DEBUG.put_line('Aging Period = ' || l_aging_period ||

2835:
2836: l_cutoff_date := TRUNC(SYSDATE) + 1 - l_aging_period;
2837:
2838: IF (g_asn_debug = 'Y') THEN
2839: ASN_DEBUG.put_line('Aging Period = ' || l_aging_period ||
2840: ' Cutoff Date = ' || l_cutoff_date);
2841: END IF;
2842:
2843: l_progress := '020';

Line 2850: IF (g_asn_debug = 'Y') THEN

2846: SELECT base_currency_code
2847: INTO l_def_base_currency_code
2848: FROM ap_system_parameters;
2849:
2850: IF (g_asn_debug = 'Y') THEN
2851: ASN_DEBUG.put_line('Base Currency Code = ' || l_def_base_currency_code);
2852: END IF;
2853:
2854: OPEN PO_INVOICES_SV2.c_consumption(l_cutoff_date);

Line 2851: ASN_DEBUG.put_line('Base Currency Code = ' || l_def_base_currency_code);

2847: INTO l_def_base_currency_code
2848: FROM ap_system_parameters;
2849:
2850: IF (g_asn_debug = 'Y') THEN
2851: ASN_DEBUG.put_line('Base Currency Code = ' || l_def_base_currency_code);
2852: END IF;
2853:
2854: OPEN PO_INVOICES_SV2.c_consumption(l_cutoff_date);
2855:

Line 2856: IF (g_asn_debug = 'Y') THEN

2852: END IF;
2853:
2854: OPEN PO_INVOICES_SV2.c_consumption(l_cutoff_date);
2855:
2856: IF (g_asn_debug = 'Y') THEN
2857: ASN_DEBUG.put_line('Using Bulk Collect. Limit = ' || g_fetch_size);
2858: END IF;
2859:
2860: LOOP

Line 2857: ASN_DEBUG.put_line('Using Bulk Collect. Limit = ' || g_fetch_size);

2853:
2854: OPEN PO_INVOICES_SV2.c_consumption(l_cutoff_date);
2855:
2856: IF (g_asn_debug = 'Y') THEN
2857: ASN_DEBUG.put_line('Using Bulk Collect. Limit = ' || g_fetch_size);
2858: END IF;
2859:
2860: LOOP
2861: l_progress := '030';

Line 2863: IF (g_asn_debug = 'Y') THEN

2859:
2860: LOOP
2861: l_progress := '030';
2862:
2863: IF (g_asn_debug = 'Y') THEN
2864: ASN_DEBUG.put_line('In Outer Loop');
2865: END IF;
2866:
2867: l_commit_lower := 1;

Line 2864: ASN_DEBUG.put_line('In Outer Loop');

2860: LOOP
2861: l_progress := '030';
2862:
2863: IF (g_asn_debug = 'Y') THEN
2864: ASN_DEBUG.put_line('In Outer Loop');
2865: END IF;
2866:
2867: l_commit_lower := 1;
2868: l_commit_upper := 0;

Line 2898: IF (g_asn_debug = 'Y') THEN

2894: l_consumption.unit_meas_lookup_code
2895: LIMIT g_fetch_size;
2896:
2897: l_progress := '040';
2898: IF (g_asn_debug = 'Y') THEN
2899: ASN_DEBUG.put_line('After Bulk Collect. Fetched ' ||
2900: l_consumption.po_header_id.COUNT || ' records');
2901: END IF;
2902:

Line 2899: ASN_DEBUG.put_line('After Bulk Collect. Fetched ' ||

2895: LIMIT g_fetch_size;
2896:
2897: l_progress := '040';
2898: IF (g_asn_debug = 'Y') THEN
2899: ASN_DEBUG.put_line('After Bulk Collect. Fetched ' ||
2900: l_consumption.po_header_id.COUNT || ' records');
2901: END IF;
2902:
2903: FOR i IN 1..l_consumption.po_header_id.COUNT LOOP

Line 2905: IF (g_asn_debug = 'Y') THEN

2901: END IF;
2902:
2903: FOR i IN 1..l_consumption.po_header_id.COUNT LOOP
2904:
2905: IF (g_asn_debug = 'Y') THEN
2906: ASN_DEBUG.put_line('In Inner Loop. i = ' || i);
2907: END IF;
2908:
2909: IF (l_first_flag = FND_API.G_TRUE) THEN

Line 2906: ASN_DEBUG.put_line('In Inner Loop. i = ' || i);

2902:
2903: FOR i IN 1..l_consumption.po_header_id.COUNT LOOP
2904:
2905: IF (g_asn_debug = 'Y') THEN
2906: ASN_DEBUG.put_line('In Inner Loop. i = ' || i);
2907: END IF;
2908:
2909: IF (l_first_flag = FND_API.G_TRUE) THEN
2910: l_progress := '050';

Line 2914: IF (g_asn_debug = 'Y') THEN

2910: l_progress := '050';
2911:
2912: l_first_flag := FND_API.G_FALSE;
2913:
2914: IF (g_asn_debug = 'Y') THEN
2915: ASN_DEBUG.put_line('First Record.');
2916: END IF;
2917:
2918: l_org_id := l_consumption.org_id(i);

Line 2915: ASN_DEBUG.put_line('First Record.');

2911:
2912: l_first_flag := FND_API.G_FALSE;
2913:
2914: IF (g_asn_debug = 'Y') THEN
2915: ASN_DEBUG.put_line('First Record.');
2916: END IF;
2917:
2918: l_org_id := l_consumption.org_id(i);
2919:

Line 2925: IF (g_asn_debug = 'Y') THEN

2921: SELECT 'USE-' || ap_interface_groups_s.nextval
2922: INTO l_group_id
2923: FROM sys.dual;
2924:
2925: IF (g_asn_debug = 'Y') THEN
2926: ASN_DEBUG.put_line('group_id = ' || l_group_id);
2927: END IF;
2928:
2929: -- get invoice description

Line 2926: ASN_DEBUG.put_line('group_id = ' || l_group_id);

2922: INTO l_group_id
2923: FROM sys.dual;
2924:
2925: IF (g_asn_debug = 'Y') THEN
2926: ASN_DEBUG.put_line('group_id = ' || l_group_id);
2927: END IF;
2928:
2929: -- get invoice description
2930: FND_MESSAGE.set_name('PO', 'PO_INV_CR_USE_INVOICE_DESC');

Line 2934: IF (g_asn_debug = 'Y') THEN

2930: FND_MESSAGE.set_name('PO', 'PO_INV_CR_USE_INVOICE_DESC');
2931: FND_MESSAGE.set_token('RUN_DATE', sysdate);
2932: l_invoice_desc := FND_MESSAGE.get;
2933:
2934: IF (g_asn_debug = 'Y') THEN
2935: ASN_DEBUG.put_line('invoice_desc = ' || l_invoice_desc);
2936: END IF;
2937: PO_INVOICES_SV2.reset_header_values(
2938: l_return_status,

Line 2935: ASN_DEBUG.put_line('invoice_desc = ' || l_invoice_desc);

2931: FND_MESSAGE.set_token('RUN_DATE', sysdate);
2932: l_invoice_desc := FND_MESSAGE.get;
2933:
2934: IF (g_asn_debug = 'Y') THEN
2935: ASN_DEBUG.put_line('invoice_desc = ' || l_invoice_desc);
2936: END IF;
2937: PO_INVOICES_SV2.reset_header_values(
2938: l_return_status,
2939: l_consumption,

Line 2947: IF (g_asn_debug = 'Y') THEN

2943: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2945: END IF;
2946:
2947: IF (g_asn_debug = 'Y') THEN
2948: ASN_DEBUG.put_line('Done Initializing Header variables.');
2949: END IF;
2950:
2951: END IF; -- l_first_flag = FND_API.G_TRUE

Line 2948: ASN_DEBUG.put_line('Done Initializing Header variables.');

2944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2945: END IF;
2946:
2947: IF (g_asn_debug = 'Y') THEN
2948: ASN_DEBUG.put_line('Done Initializing Header variables.');
2949: END IF;
2950:
2951: END IF; -- l_first_flag = FND_API.G_TRUE
2952:

Line 2964: IF (g_asn_debug = 'Y') THEN

2960: l_progress := '060';
2961:
2962: l_header_idx := l_header_idx + 1;
2963:
2964: IF (g_asn_debug = 'Y') THEN
2965: ASN_DEBUG.put_line('Invoice header needs to be created for ' ||
2966: 'previous records.');
2967: END IF;
2968:

Line 2965: ASN_DEBUG.put_line('Invoice header needs to be created for ' ||

2961:
2962: l_header_idx := l_header_idx + 1;
2963:
2964: IF (g_asn_debug = 'Y') THEN
2965: ASN_DEBUG.put_line('Invoice header needs to be created for ' ||
2966: 'previous records.');
2967: END IF;
2968:
2969: IF (g_asn_debug = 'Y') THEN

Line 2969: IF (g_asn_debug = 'Y') THEN

2965: ASN_DEBUG.put_line('Invoice header needs to be created for ' ||
2966: 'previous records.');
2967: END IF;
2968:
2969: IF (g_asn_debug = 'Y') THEN
2970: ASN_DEBUG.put_line('# of lines for this invoice = ' ||
2971: l_distr_count);
2972: END IF;
2973:

Line 2970: ASN_DEBUG.put_line('# of lines for this invoice = ' ||

2966: 'previous records.');
2967: END IF;
2968:
2969: IF (g_asn_debug = 'Y') THEN
2970: ASN_DEBUG.put_line('# of lines for this invoice = ' ||
2971: l_distr_count);
2972: END IF;
2973:
2974: l_progress := '065';

Line 2989: IF (g_asn_debug = 'Y') THEN

2985: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2987: END IF;
2988:
2989: IF (g_asn_debug = 'Y') THEN
2990: ASN_DEBUG.put_line('Stored Header Information into table');
2991: END IF;
2992:
2993: l_distr_count := 0;

Line 2990: ASN_DEBUG.put_line('Stored Header Information into table');

2986: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2987: END IF;
2988:
2989: IF (g_asn_debug = 'Y') THEN
2990: ASN_DEBUG.put_line('Stored Header Information into table');
2991: END IF;
2992:
2993: l_distr_count := 0;
2994: l_invoice_count := l_invoice_count + 1;

Line 3006: IF (g_asn_debug = 'Y') THEN

3002: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;
3005:
3006: IF (g_asn_debug = 'Y') THEN
3007: ASN_DEBUG.put_line('Done Resetting Header Variables');
3008: ASN_DEBUG.put_line('# of headers created after last commit= ' ||
3009: l_header_idx || ' Commit interval= ' ||
3010: p_commit_interval);

Line 3007: ASN_DEBUG.put_line('Done Resetting Header Variables');

3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: END IF;
3005:
3006: IF (g_asn_debug = 'Y') THEN
3007: ASN_DEBUG.put_line('Done Resetting Header Variables');
3008: ASN_DEBUG.put_line('# of headers created after last commit= ' ||
3009: l_header_idx || ' Commit interval= ' ||
3010: p_commit_interval);
3011: END IF;

Line 3008: ASN_DEBUG.put_line('# of headers created after last commit= ' ||

3004: END IF;
3005:
3006: IF (g_asn_debug = 'Y') THEN
3007: ASN_DEBUG.put_line('Done Resetting Header Variables');
3008: ASN_DEBUG.put_line('# of headers created after last commit= ' ||
3009: l_header_idx || ' Commit interval= ' ||
3010: p_commit_interval);
3011: END IF;
3012:

Line 3019: IF (g_asn_debug = 'Y') THEN

3015: -- created so far needs to be inserted and committed.
3016:
3017: l_progress := '070';
3018:
3019: IF (g_asn_debug = 'Y') THEN
3020: ASN_DEBUG.put_line('Bulk Insert into header interface');
3021: END IF;
3022:
3023: PO_INVOICES_SV2.create_invoice_hdr(

Line 3020: ASN_DEBUG.put_line('Bulk Insert into header interface');

3016:
3017: l_progress := '070';
3018:
3019: IF (g_asn_debug = 'Y') THEN
3020: ASN_DEBUG.put_line('Bulk Insert into header interface');
3021: END IF;
3022:
3023: PO_INVOICES_SV2.create_invoice_hdr(
3024: l_return_status,

Line 3035: IF (g_asn_debug = 'Y') THEN

3031: END IF;
3032:
3033: l_progress := '073';
3034:
3035: IF (g_asn_debug = 'Y') THEN
3036: ASN_DEBUG.put_line('Bulk Insert into line interface');
3037: END IF;
3038:
3039: PO_INVOICES_SV2.create_invoice_distr(

Line 3036: ASN_DEBUG.put_line('Bulk Insert into line interface');

3032:
3033: l_progress := '073';
3034:
3035: IF (g_asn_debug = 'Y') THEN
3036: ASN_DEBUG.put_line('Bulk Insert into line interface');
3037: END IF;
3038:
3039: PO_INVOICES_SV2.create_invoice_distr(
3040: l_return_status,

Line 3056: IF (g_asn_debug = 'Y') THEN

3052: l_header_idx := 0;
3053: COMMIT;
3054:
3055: l_progress := '080';
3056: IF (g_asn_debug = 'Y') THEN
3057: ASN_DEBUG.put_line('After commit');
3058: END IF;
3059:
3060: END IF; -- l_header_idx = p_commit_interval

Line 3057: ASN_DEBUG.put_line('After commit');

3053: COMMIT;
3054:
3055: l_progress := '080';
3056: IF (g_asn_debug = 'Y') THEN
3057: ASN_DEBUG.put_line('After commit');
3058: END IF;
3059:
3060: END IF; -- l_header_idx = p_commit_interval
3061:

Line 3070: IF (g_asn_debug = 'Y') THEN

3066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3067: END IF;
3068:
3069: l_progress := '090';
3070: IF (g_asn_debug = 'Y') THEN
3071: ASN_DEBUG.put_line('Deriving more line information');
3072: END IF;
3073:
3074: l_distr_count := l_distr_count + 1;

Line 3071: ASN_DEBUG.put_line('Deriving more line information');

3067: END IF;
3068:
3069: l_progress := '090';
3070: IF (g_asn_debug = 'Y') THEN
3071: ASN_DEBUG.put_line('Deriving more line information');
3072: END IF;
3073:
3074: l_distr_count := l_distr_count + 1;
3075:

Line 3083: IF (g_asn_debug = 'Y') THEN

3079: l_consumption.quantity_invoiced(i) :=
3080: l_consumption.quantity_ordered(i) -
3081: l_consumption.quantity_billed(i);
3082:
3083: IF (g_asn_debug = 'Y') THEN
3084: ASN_DEBUG.put_line('po_distribution_id = ' ||
3085: l_consumption.po_distribution_id(i) ||
3086: 'Quantity to invoice = ' ||
3087: l_consumption.quantity_invoiced(i));

Line 3084: ASN_DEBUG.put_line('po_distribution_id = ' ||

3080: l_consumption.quantity_ordered(i) -
3081: l_consumption.quantity_billed(i);
3082:
3083: IF (g_asn_debug = 'Y') THEN
3084: ASN_DEBUG.put_line('po_distribution_id = ' ||
3085: l_consumption.po_distribution_id(i) ||
3086: 'Quantity to invoice = ' ||
3087: l_consumption.quantity_invoiced(i));
3088: END IF;

Line 3103: IF (g_asn_debug = 'Y') THEN

3099: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3101: END IF;
3102:
3103: IF (g_asn_debug = 'Y') THEN
3104: ASN_DEBUG.put_line('line_amount = ' ||
3105: l_consumption.invoice_line_amount(i));
3106: ASN_DEBUG.put_line('Cumu. Invoive amt = '||l_curr.invoice_amount);
3107: END IF;

Line 3104: ASN_DEBUG.put_line('line_amount = ' ||

3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3101: END IF;
3102:
3103: IF (g_asn_debug = 'Y') THEN
3104: ASN_DEBUG.put_line('line_amount = ' ||
3105: l_consumption.invoice_line_amount(i));
3106: ASN_DEBUG.put_line('Cumu. Invoive amt = '||l_curr.invoice_amount);
3107: END IF;
3108:

Line 3106: ASN_DEBUG.put_line('Cumu. Invoive amt = '||l_curr.invoice_amount);

3102:
3103: IF (g_asn_debug = 'Y') THEN
3104: ASN_DEBUG.put_line('line_amount = ' ||
3105: l_consumption.invoice_line_amount(i));
3106: ASN_DEBUG.put_line('Cumu. Invoive amt = '||l_curr.invoice_amount);
3107: END IF;
3108:
3109: l_commit_upper := l_commit_upper + 1;
3110:

Line 3118: IF (g_asn_debug = 'Y') THEN

3114:
3115: -- l_curr.invoice_date := l_consumption.creation_date(i);
3116:
3117:
3118: IF (g_asn_debug = 'Y') THEN
3119: ASN_DEBUG.put_line('-*-*-*-*-*- Done with one line -*-*-*-*-*-');
3120: END IF;
3121: END LOOP; -- for i in 1.. po_header_id.count
3122:

Line 3119: ASN_DEBUG.put_line('------ Done with one line ------');

3115: -- l_curr.invoice_date := l_consumption.creation_date(i);
3116:
3117:
3118: IF (g_asn_debug = 'Y') THEN
3119: ASN_DEBUG.put_line('-*-*-*-*-*- Done with one line -*-*-*-*-*-');
3120: END IF;
3121: END LOOP; -- for i in 1.. po_header_id.count
3122:
3123: l_progress := '100';

Line 3125: IF (g_asn_debug = 'Y') THEN

3121: END LOOP; -- for i in 1.. po_header_id.count
3122:
3123: l_progress := '100';
3124:
3125: IF (g_asn_debug = 'Y') THEN
3126: ASN_DEBUG.put_line('Exit inner loop');
3127: END IF;
3128:
3129: IF (g_asn_debug = 'Y') THEN

Line 3126: ASN_DEBUG.put_line('Exit inner loop');

3122:
3123: l_progress := '100';
3124:
3125: IF (g_asn_debug = 'Y') THEN
3126: ASN_DEBUG.put_line('Exit inner loop');
3127: END IF;
3128:
3129: IF (g_asn_debug = 'Y') THEN
3130: ASN_DEBUG.put_line('Insert remaining distributions from pl/sql table'

Line 3129: IF (g_asn_debug = 'Y') THEN

3125: IF (g_asn_debug = 'Y') THEN
3126: ASN_DEBUG.put_line('Exit inner loop');
3127: END IF;
3128:
3129: IF (g_asn_debug = 'Y') THEN
3130: ASN_DEBUG.put_line('Insert remaining distributions from pl/sql table'
3131: || ' to lines interface table');
3132: END IF;
3133:

Line 3130: ASN_DEBUG.put_line('Insert remaining distributions from pl/sql table'

3126: ASN_DEBUG.put_line('Exit inner loop');
3127: END IF;
3128:
3129: IF (g_asn_debug = 'Y') THEN
3130: ASN_DEBUG.put_line('Insert remaining distributions from pl/sql table'
3131: || ' to lines interface table');
3132: END IF;
3133:
3134: PO_INVOICES_SV2.create_invoice_distr(

Line 3149: IF (g_asn_debug = 'Y') THEN

3145:
3146: END LOOP; -- loop for bulk fetching consumption advice
3147:
3148: l_progress := '110';
3149: IF (g_asn_debug = 'Y') THEN
3150: ASN_DEBUG.put_line('Exit outer loop');
3151: END IF;
3152:
3153: IF c_consumption%ISOPEN THEN

Line 3150: ASN_DEBUG.put_line('Exit outer loop');

3146: END LOOP; -- loop for bulk fetching consumption advice
3147:
3148: l_progress := '110';
3149: IF (g_asn_debug = 'Y') THEN
3150: ASN_DEBUG.put_line('Exit outer loop');
3151: END IF;
3152:
3153: IF c_consumption%ISOPEN THEN
3154: CLOSE c_consumption;

Line 3158: IF (g_asn_debug = 'Y') THEN

3154: CLOSE c_consumption;
3155: END IF;
3156:
3157: IF (l_distr_count > 0) THEN
3158: IF (g_asn_debug = 'Y') THEN
3159: ASN_DEBUG.put_line('l_distr_count = ' || l_distr_count || '. Need to' ||
3160: ' perform some clean up work.');
3161: END IF;
3162:

Line 3159: ASN_DEBUG.put_line('l_distr_count = ' || l_distr_count || '. Need to' ||

3155: END IF;
3156:
3157: IF (l_distr_count > 0) THEN
3158: IF (g_asn_debug = 'Y') THEN
3159: ASN_DEBUG.put_line('l_distr_count = ' || l_distr_count || '. Need to' ||
3160: ' perform some clean up work.');
3161: END IF;
3162:
3163: l_header_idx := l_header_idx + 1;

Line 3165: IF (g_asn_debug = 'Y') THEN

3161: END IF;
3162:
3163: l_header_idx := l_header_idx + 1;
3164:
3165: IF (g_asn_debug = 'Y') THEN
3166: ASN_DEBUG.put_line('# of headers created after last commit= ' ||
3167: l_header_idx);
3168: END IF;
3169:

Line 3166: ASN_DEBUG.put_line('# of headers created after last commit= ' ||

3162:
3163: l_header_idx := l_header_idx + 1;
3164:
3165: IF (g_asn_debug = 'Y') THEN
3166: ASN_DEBUG.put_line('# of headers created after last commit= ' ||
3167: l_header_idx);
3168: END IF;
3169:
3170: PO_INVOICES_SV2.store_header_info(

Line 3184: IF (g_asn_debug = 'Y') THEN

3180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3181: END IF;
3182:
3183: l_progress := '120';
3184: IF (g_asn_debug = 'Y') THEN
3185: ASN_DEBUG.put_line('Insert remaining invoice headers');
3186: END IF;
3187:
3188: PO_INVOICES_SV2.create_invoice_hdr(

Line 3185: ASN_DEBUG.put_line('Insert remaining invoice headers');

3181: END IF;
3182:
3183: l_progress := '120';
3184: IF (g_asn_debug = 'Y') THEN
3185: ASN_DEBUG.put_line('Insert remaining invoice headers');
3186: END IF;
3187:
3188: PO_INVOICES_SV2.create_invoice_hdr(
3189: l_return_status,

Line 3201: IF (g_asn_debug = 'Y') THEN

3197:
3198: COMMIT;
3199:
3200: l_progress := '130';
3201: IF (g_asn_debug = 'Y') THEN
3202: ASN_DEBUG.put_line('Call invoice import program');
3203: END IF;
3204:
3205: SELECT ap_batches_s.nextval

Line 3202: ASN_DEBUG.put_line('Call invoice import program');

3198: COMMIT;
3199:
3200: l_progress := '130';
3201: IF (g_asn_debug = 'Y') THEN
3202: ASN_DEBUG.put_line('Call invoice import program');
3203: END IF;
3204:
3205: SELECT ap_batches_s.nextval
3206: INTO l_tmp_batch_id

Line 3213: IF (g_asn_debug = 'Y') THEN

3209: FND_MESSAGE.set_name('PO', 'PO_INV_CR_USE_BATCH_DESC');
3210: l_batch_name := FND_MESSAGE.get || '/' || TO_CHAR(sysdate) ||
3211: '/' || TO_CHAR(l_tmp_batch_id);
3212:
3213: IF (g_asn_debug = 'Y') THEN
3214: ASN_DEBUG.put_line('Batch name = ' || l_batch_name);
3215: END IF;
3216:
3217: l_user_id := NULL;

Line 3214: ASN_DEBUG.put_line('Batch name = ' || l_batch_name);

3210: l_batch_name := FND_MESSAGE.get || '/' || TO_CHAR(sysdate) ||
3211: '/' || TO_CHAR(l_tmp_batch_id);
3212:
3213: IF (g_asn_debug = 'Y') THEN
3214: ASN_DEBUG.put_line('Batch name = ' || l_batch_name);
3215: END IF;
3216:
3217: l_user_id := NULL;
3218: l_login_id := NULL;

Line 3238: IF (g_asn_debug = 'Y') THEN

3234:
3235: FND_MESSAGE.set_name('PO', 'PO_ERS_CONC_REQUEST_CHECK');
3236: FND_MESSAGE.set_token('REQUEST', TO_CHAR(l_request_id));
3237: FND_MESSAGE.set_token('BATCH', l_batch_name);
3238: IF (g_asn_debug = 'Y') THEN
3239: ASN_DEBUG.put_line(FND_MESSAGE.get);
3240: END IF;
3241:
3242: END IF; -- l_distr_count > 0

Line 3239: ASN_DEBUG.put_line(FND_MESSAGE.get);

3235: FND_MESSAGE.set_name('PO', 'PO_ERS_CONC_REQUEST_CHECK');
3236: FND_MESSAGE.set_token('REQUEST', TO_CHAR(l_request_id));
3237: FND_MESSAGE.set_token('BATCH', l_batch_name);
3238: IF (g_asn_debug = 'Y') THEN
3239: ASN_DEBUG.put_line(FND_MESSAGE.get);
3240: END IF;
3241:
3242: END IF; -- l_distr_count > 0
3243:

Line 3244: IF (g_asn_debug = 'Y') THEN

3240: END IF;
3241:
3242: END IF; -- l_distr_count > 0
3243:
3244: IF (g_asn_debug = 'Y') THEN
3245: ASN_DEBUG.put_line('Exit create_use_invoices');
3246: END IF;
3247:
3248: EXCEPTION

Line 3245: ASN_DEBUG.put_line('Exit create_use_invoices');

3241:
3242: END IF; -- l_distr_count > 0
3243:
3244: IF (g_asn_debug = 'Y') THEN
3245: ASN_DEBUG.put_line('Exit create_use_invoices');
3246: END IF;
3247:
3248: EXCEPTION
3249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3252: IF (g_asn_debug = 'Y') THEN

3248: EXCEPTION
3249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3251: l_error_msg := FND_MSG_PUB.get(p_encoded => 'F');
3252: IF (g_asn_debug = 'Y') THEN
3253: ASN_DEBUG.put_line(l_api_name || '-' || l_progress);
3254: ASN_DEBUG.put_line(l_error_msg);
3255: END IF;
3256:

Line 3253: ASN_DEBUG.put_line(l_api_name || '-' || l_progress);

3249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3251: l_error_msg := FND_MSG_PUB.get(p_encoded => 'F');
3252: IF (g_asn_debug = 'Y') THEN
3253: ASN_DEBUG.put_line(l_api_name || '-' || l_progress);
3254: ASN_DEBUG.put_line(l_error_msg);
3255: END IF;
3256:
3257: IF c_consumption%ISOPEN THEN

Line 3254: ASN_DEBUG.put_line(l_error_msg);

3250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3251: l_error_msg := FND_MSG_PUB.get(p_encoded => 'F');
3252: IF (g_asn_debug = 'Y') THEN
3253: ASN_DEBUG.put_line(l_api_name || '-' || l_progress);
3254: ASN_DEBUG.put_line(l_error_msg);
3255: END IF;
3256:
3257: IF c_consumption%ISOPEN THEN
3258: CLOSE c_consumption;

Line 3272: IF (g_asn_debug = 'Y') THEN

3268: WHEN OTHERS THEN
3269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3270: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3271: l_error_msg := FND_MSG_PUB.get(p_encoded => 'F');
3272: IF (g_asn_debug = 'Y') THEN
3273: ASN_DEBUG.put_line(l_api_name || '-' || l_progress);
3274: ASN_DEBUG.put_line(l_error_msg);
3275: END IF;
3276:

Line 3273: ASN_DEBUG.put_line(l_api_name || '-' || l_progress);

3269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3270: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3271: l_error_msg := FND_MSG_PUB.get(p_encoded => 'F');
3272: IF (g_asn_debug = 'Y') THEN
3273: ASN_DEBUG.put_line(l_api_name || '-' || l_progress);
3274: ASN_DEBUG.put_line(l_error_msg);
3275: END IF;
3276:
3277: IF c_consumption%ISOPEN THEN

Line 3274: ASN_DEBUG.put_line(l_error_msg);

3270: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3271: l_error_msg := FND_MSG_PUB.get(p_encoded => 'F');
3272: IF (g_asn_debug = 'Y') THEN
3273: ASN_DEBUG.put_line(l_api_name || '-' || l_progress);
3274: ASN_DEBUG.put_line(l_error_msg);
3275: END IF;
3276:
3277: IF c_consumption%ISOPEN THEN
3278: CLOSE c_consumption;

Line 3367: IF (g_asn_debug = 'Y') THEN

3363: l_api_name VARCHAR2(50) := 'store_header_info';
3364: BEGIN
3365: x_return_status := FND_API.G_RET_STS_SUCCESS;
3366:
3367: IF (g_asn_debug = 'Y') THEN
3368: ASN_DEBUG.put_line('Storing header data into PL/SQL tables');
3369: END IF;
3370:
3371: x_ap_inv_header.invoice_num(p_index) :=

Line 3368: ASN_DEBUG.put_line('Storing header data into PL/SQL tables');

3364: BEGIN
3365: x_return_status := FND_API.G_RET_STS_SUCCESS;
3366:
3367: IF (g_asn_debug = 'Y') THEN
3368: ASN_DEBUG.put_line('Storing header data into PL/SQL tables');
3369: END IF;
3370:
3371: x_ap_inv_header.invoice_num(p_index) :=
3372: PO_INVOICES_SV2.create_invoice_num(

Line 3398: IF (g_asn_debug = 'Y') THEN

3394: x_ap_inv_header.terms_id(p_index) := p_curr.payment_terms_id;
3395: x_ap_inv_header.group_id(p_index) := p_group_id;
3396: x_ap_inv_header.org_id(p_index) := p_org_id;
3397:
3398: IF (g_asn_debug = 'Y') THEN
3399: ASN_DEBUG.put_line('Invoice id = ' || x_ap_inv_header.invoice_id(p_index));
3400: END IF;
3401: EXCEPTION
3402: WHEN OTHERS THEN

Line 3399: ASN_DEBUG.put_line('Invoice id = ' || x_ap_inv_header.invoice_id(p_index));

3395: x_ap_inv_header.group_id(p_index) := p_group_id;
3396: x_ap_inv_header.org_id(p_index) := p_org_id;
3397:
3398: IF (g_asn_debug = 'Y') THEN
3399: ASN_DEBUG.put_line('Invoice id = ' || x_ap_inv_header.invoice_id(p_index));
3400: END IF;
3401: EXCEPTION
3402: WHEN OTHERS THEN
3403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3495: IF (g_asn_debug = 'Y') THEN

3491: x_invoice_line_amount := AP_UTILITIES_PKG.ap_round_currency(
3492: p_quantity * p_unit_price,
3493: p_invoice_currency_code);
3494:
3495: IF (g_asn_debug = 'Y') THEN
3496: ASN_DEBUG.put_line('line amount = ' || x_invoice_line_amount);
3497: END IF;
3498:
3499: x_curr_invoice_amount := x_curr_invoice_amount + x_invoice_line_amount;

Line 3496: ASN_DEBUG.put_line('line amount = ' || x_invoice_line_amount);

3492: p_quantity * p_unit_price,
3493: p_invoice_currency_code);
3494:
3495: IF (g_asn_debug = 'Y') THEN
3496: ASN_DEBUG.put_line('line amount = ' || x_invoice_line_amount);
3497: END IF;
3498:
3499: x_curr_invoice_amount := x_curr_invoice_amount + x_invoice_line_amount;
3500: EXCEPTION