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.29.12020000.2 2013/01/30 03:23:50 vkaranam 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 258: Description: Following errors encountered by autobuild when compiling the package jai_rcv_rgm_claims_pkg.

254: Fix:
255: changes are done in update_rcv_lines procedure.
256:
257: 25. 17-Mar-2011 abezgam for Bug#11880460
258: Description: Following errors encountered by autobuild when compiling the package jai_rcv_rgm_claims_pkg.
259: 1. wrong number or types of arguments in call to insert_vat_repository_entry
260: 2. 'TEMP_REC'.'SHIPMENT_LINE_ID': invalid identifier
261: Fix:
262: 1. Corrected the parameters in the call to the procedure jai_cmn_rgm_recording_pkg.insert_vat_repository_entry.

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

417: p_location_id := ln_location_id;
418: EXCEPTION
419: WHEN OTHERS THEN
420: p_process_status := jai_constants.unexpected_error;
421: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.get_location Error:'||SQLERRM,1,250);
422: END get_location;
423:
424: PROCEDURE generate_schedule(
425: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,

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

1389: p_correct_rtv_qty => ln_correct_rtv_qty,
1390: p_process_message => lv_process_message,
1391: p_process_status => lv_process_status,
1392: /* Added the following by Ramananda for bug#4530112 */
1393: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35
1394: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35
1395: );
1396:
1397: IF lv_process_status <> jai_constants.successful THEN

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

1390: p_process_message => lv_process_message,
1391: p_process_status => lv_process_status,
1392: /* Added the following by Ramananda for bug#4530112 */
1393: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35
1394: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35
1395: );
1396:
1397: IF lv_process_status <> jai_constants.successful THEN
1398: p_process_status := lv_process_status;

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

1563: p_rtv_qty => r_trx.quantity,
1564: --p_recoverable_amount => ln_total_cenvat_amount,
1565: p_process_message => lv_process_message,
1566: p_process_status => lv_process_status,
1567: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1568: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1569: );
1570:
1571: IF lv_process_status <> jai_constants.successful THEN

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

1564: --p_recoverable_amount => ln_total_cenvat_amount,
1565: p_process_message => lv_process_message,
1566: p_process_status => lv_process_status,
1567: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1568: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1569: );
1570:
1571: IF lv_process_status <> jai_constants.successful THEN
1572: p_process_status := lv_process_status;

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

1668: p_correct_receive_qty => r_base_trx.quantity,
1669: --p_recoverable_amount => ln_total_cenvat_amount,
1670: p_process_status => lv_process_status,
1671: p_process_message => lv_process_message,
1672: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1673: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1674: );
1675:
1676: IF lv_process_status <> jai_constants.successful THEN

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

1669: --p_recoverable_amount => ln_total_cenvat_amount,
1670: p_process_status => lv_process_status,
1671: p_process_message => lv_process_message,
1672: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1673: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1674: );
1675:
1676: IF lv_process_status <> jai_constants.successful THEN
1677: p_process_status := lv_process_status;

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

1780: p_shipment_line_id => r_base_trx.shipment_line_id,
1781: p_correct_rtv_qty => r_base_trx.quantity,
1782: p_process_message => lv_process_message,
1783: p_process_status => lv_process_status,
1784: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1785: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1786: );
1787:
1788: IF lv_process_status <> jai_constants.successful THEN

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

1781: p_correct_rtv_qty => r_base_trx.quantity,
1782: p_process_message => lv_process_message,
1783: p_process_status => lv_process_status,
1784: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
1785: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
1786: );
1787:
1788: IF lv_process_status <> jai_constants.successful THEN
1789: p_process_status := lv_process_status;

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

2298: p_shipment_line_id => rec_claims.shipment_line_id,
2299: p_recovered_amount => rec_claims.installment_amount,
2300: p_process_message => lv_process_message,
2301: p_process_status => lv_process_status,
2302: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
2303: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
2304: );
2305:
2306: IF lv_process_status <> jai_constants.successful THEN

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

2299: p_recovered_amount => rec_claims.installment_amount,
2300: p_process_message => lv_process_message,
2301: p_process_status => lv_process_status,
2302: p_invoice_no => jai_rcv_rgm_claims_pkg.gv_invoice_no_dflt, --File.Sql.35 Cbabu
2303: p_invoice_date => jai_rcv_rgm_claims_pkg.gd_invoice_date_dflt --File.Sql.35 Cbabu
2304: );
2305:
2306: IF lv_process_status <> jai_constants.successful THEN
2307: p_process_status := lv_process_status;

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

2315:
2316: EXCEPTION
2317: WHEN OTHERS THEN
2318: p_process_status := jai_constants.unexpected_error;
2319: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.process_claim Error:'||SQLERRM,1,200);
2320: END process_claim;
2321:
2322: /*PROCEDURE process_no_claim(
2323: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,

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

2588: p_process_status := jai_constants.successful;
2589: p_process_message := NULL;
2590:
2591:
2592: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_no_claim', 'START');
2593:
2594: OPEN c_regime(NULL, jai_constants.vat_regime);
2595: FETCH c_regime INTO r_regime;
2596: CLOSE c_regime;

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

2875: -- Added by Jia for FP Bug#8805693, End
2876:
2877: END LOOP;
2878:
2879: lv_codepath := jai_general_pkg.plot_codepath(3, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_no_claim', 'START');
2880: EXCEPTION
2881: WHEN OTHERS THEN
2882: p_process_status := jai_constants.unexpected_error;
2883: p_process_message := SUBSTR(SQLERRM,1,200);

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

2923:
2924: r_regime c_regime%ROWTYPE;
2925:
2926: BEGIN
2927: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_batch', 'START');
2928:
2929:
2930: OPEN c_regime(p_regime_id, NULL);
2931: FETCH c_regime INTO r_regime;

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

2992: IF p_commit_switch = 'Y' THEN
2993: COMMIT;
2994: END IF;
2995:
2996: lv_codepath := jai_general_pkg.plot_codepath(1, lv_codepath, 'jai_rcv_rgm_claims_pkg.process_batch', 'END');
2997: END process_batch;
2998:
2999: PROCEDURE do_rtv_accounting(
3000: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE,

Line 3837: END jai_rcv_rgm_claims_pkg;

3833: p_process_status := jai_constants.unexpected_error;
3834: p_process_message := SUBSTR(SQLERRM,1,200);
3835: END do_rma_accounting;
3836:
3837: END jai_rcv_rgm_claims_pkg;