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.JAI_RCV_RGM_CLAIMS_PKG dependencies on JAI_RCV_RGM_CLAIMS_PKG

Line 1: PACKAGE BODY jai_rcv_rgm_claims_pkg AS

1: PACKAGE BODY jai_rcv_rgm_claims_pkg AS
2: /* $Header: jai_rcv_rgm_clm.plb 120.15.12010000.2 2008/10/14 10:17:08 lgopalsa ship $ */
3:
4:
5: TABLE_RCV_TRANSACTIONS CONSTANT VARCHAR2(30) := 'RCV_TRANSACTIONS';

Line 113: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu

109:
110: Added the following as the object is not compiled because of R12 changes.
111: These were introudced as default values were removed from the procedure spec. and function spec.
112: 1. Procedue call update_rcv_lines is changed:
113: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
114: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
115:
116: 2. Procedure call generate_schedule is changed:
117: p_override => jai_constants.no

Line 114: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu

110: Added the following as the object is not compiled because of R12 changes.
111: These were introudced as default values were removed from the procedure spec. and function spec.
112: 1. Procedue call update_rcv_lines is changed:
113: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
114: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
115:
116: 2. Procedure call generate_schedule is changed:
117: p_override => jai_constants.no
118:

Line 126: before the call to jai_rcv_rgm_claims_pkg.insert_rcv_lines. If no VAT type of taxes

122:
123: 11. 02-Aug-2005 Ramananda for Bug#4519719. File Version 120.2
124: Issue : Processing should not take place if no VAT type of taxes
125: Fis : Added a condition to check if VAT type of taxes exist in the receipt
126: before the call to jai_rcv_rgm_claims_pkg.insert_rcv_lines. If no VAT type of taxes
127: exist, the return from the procedure.
128:
129: Dependency due to this bug:-
130: jai_rcv_trx_prc.plb (120.4)

Line 352: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.get_location Error:'||SQLERRM,1,250);

348: p_location_id := ln_location_id;
349: EXCEPTION
350: WHEN OTHERS THEN
351: p_process_status := jai_constants.unexpected_error;
352: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.get_location Error:'||SQLERRM,1,250);
353: END get_location;
354:
355: PROCEDURE generate_schedule(
356: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,

Line 1322: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35

1318: p_correct_rtv_qty => ln_correct_rtv_qty,
1319: p_process_message => lv_process_message,
1320: p_process_status => lv_process_status,
1321: /* Added the following by Ramananda for bug#4530112 */
1322: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35
1323: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35
1324: );
1325:
1326: IF lv_process_status <> jai_constants.successful THEN

Line 1323: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35

1319: p_process_message => lv_process_message,
1320: p_process_status => lv_process_status,
1321: /* Added the following by Ramananda for bug#4530112 */
1322: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35
1323: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35
1324: );
1325:
1326: IF lv_process_status <> jai_constants.successful THEN
1327: p_process_status := lv_process_status;

Line 1496: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu

1492: p_rtv_qty => r_trx.quantity,
1493: --p_recoverable_amount => ln_total_cenvat_amount,
1494: p_process_message => lv_process_message,
1495: p_process_status => lv_process_status,
1496: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1497: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1498: );
1499:
1500: IF lv_process_status <> jai_constants.successful THEN

Line 1497: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu

1493: --p_recoverable_amount => ln_total_cenvat_amount,
1494: p_process_message => lv_process_message,
1495: p_process_status => lv_process_status,
1496: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1497: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1498: );
1499:
1500: IF lv_process_status <> jai_constants.successful THEN
1501: p_process_status := lv_process_status;

Line 1601: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu

1597: p_correct_receive_qty => r_base_trx.quantity,
1598: --p_recoverable_amount => ln_total_cenvat_amount,
1599: p_process_status => lv_process_status,
1600: p_process_message => lv_process_message,
1601: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1602: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1603: );
1604:
1605: IF lv_process_status <> jai_constants.successful THEN

Line 1602: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu

1598: --p_recoverable_amount => ln_total_cenvat_amount,
1599: p_process_status => lv_process_status,
1600: p_process_message => lv_process_message,
1601: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1602: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1603: );
1604:
1605: IF lv_process_status <> jai_constants.successful THEN
1606: p_process_status := lv_process_status;

Line 1713: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu

1709: p_shipment_line_id => r_base_trx.shipment_line_id,
1710: p_correct_rtv_qty => r_base_trx.quantity,
1711: p_process_message => lv_process_message,
1712: p_process_status => lv_process_status,
1713: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1714: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1715: );
1716:
1717: IF lv_process_status <> jai_constants.successful THEN

Line 1714: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu

1710: p_correct_rtv_qty => r_base_trx.quantity,
1711: p_process_message => lv_process_message,
1712: p_process_status => lv_process_status,
1713: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1714: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1715: );
1716:
1717: IF lv_process_status <> jai_constants.successful THEN
1718: p_process_status := lv_process_status;

Line 2222: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu

2218: p_shipment_line_id => rec_claims.shipment_line_id,
2219: p_recovered_amount => rec_claims.installment_amount,
2220: p_process_message => lv_process_message,
2221: p_process_status => lv_process_status,
2222: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
2223: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
2224: );
2225:
2226: IF lv_process_status <> jai_constants.successful THEN

Line 2223: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu

2219: p_recovered_amount => rec_claims.installment_amount,
2220: p_process_message => lv_process_message,
2221: p_process_status => lv_process_status,
2222: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
2223: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
2224: );
2225:
2226: IF lv_process_status <> jai_constants.successful THEN
2227: p_process_status := lv_process_status;

Line 2239: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.process_claim Error:'||SQLERRM,1,200);

2235:
2236: EXCEPTION
2237: WHEN OTHERS THEN
2238: p_process_status := jai_constants.unexpected_error;
2239: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.process_claim Error:'||SQLERRM,1,200);
2240: END process_claim;
2241:
2242: /*PROCEDURE process_no_claim(
2243: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,

Line 2452: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_no_claim', 'START');

2448: p_process_status := jai_constants.successful;
2449: p_process_message := NULL;
2450:
2451:
2452: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_no_claim', 'START');
2453:
2454: OPEN c_regime(NULL, jai_constants.vat_regime);
2455: FETCH c_regime INTO r_regime;
2456: CLOSE c_regime;

Line 2666: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_no_claim', 'START');

2662: WHERE shipment_header_id = r_shipment_lines.shipment_header_id
2663: AND shipment_line_id = r_shipment_lines.shipment_line_id;
2664: END LOOP;
2665:
2666: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_no_claim', 'START');
2667: EXCEPTION
2668: WHEN OTHERS THEN
2669: p_process_status := jai_constants.unexpected_error;
2670: p_process_message := SUBSTR(SQLERRM,1,200);

Line 2714: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_batch', 'START');

2710:
2711: r_regime c_regime%ROWTYPE;
2712:
2713: BEGIN
2714: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_batch', 'START');
2715:
2716:
2717: OPEN c_regime(p_regime_id, NULL);
2718: FETCH c_regime INTO r_regime;

Line 2783: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_batch', 'END');

2779: IF p_commit_switch = 'Y' THEN
2780: COMMIT;
2781: END IF;
2782:
2783: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_batch', 'END');
2784: END process_batch;
2785:
2786: PROCEDURE do_rtv_accounting(
2787: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

Line 3494: END jai_rcv_rgm_claims_pkg;

3490: p_process_status := jai_constants.unexpected_error;
3491: p_process_message := SUBSTR(SQLERRM,1,200);
3492: END do_rma_accounting;
3493:
3494: END jai_rcv_rgm_claims_pkg;