DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_CMN_RGM_PROCESSING_PKG

Line 1: PACKAGE BODY jai_cmn_rgm_processing_pkg AS

1: PACKAGE BODY jai_cmn_rgm_processing_pkg AS
2: /* $Header: jai_cmn_rgm_prc.plb 120.72.12020000.8 2013/03/25 02:57:54 zxin ship $ */
3:
4: /* */
5: /*----------------------------------------------------------------------------------------------------------------------------

Line 315: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_processing_pkg.get_reversal_account_name';

311: p_location_id IN NUMBER
312: ) RETURN VARCHAR2 IS
313:
314:
315: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_processing_pkg.get_reversal_account_name';
316:
317: CURSOR c_regime_code(cp_regime_id IN NUMBER) IS
318: SELECT regime_code
319: FROM JAI_RGM_DEFINITIONS

Line 446: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_processing_pkg.insert_request_details';

442: FROM fnd_concurrent_requests
443: WHERE request_id = cp_request_id;
444:
445: /* Added by Ramananda for bug#4407165 */
446: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_processing_pkg.insert_request_details';
447:
448: BEGIN
449:
450: ln_conc_request_id := FND_PROFILE.value('CONC_REQUEST_ID');

Line 730: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_cmn_rgm_processing_pkg.claim_reversal_trx_lines: '

726: , p_account_name => lv_account_name);
727:
728: IF ln_charge_account_id IS NULL THEN
729: lv_process_message := 'Interim Recovery Account/Recovery Account is not defined at the regime registration.';
730: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_cmn_rgm_processing_pkg.claim_reversal_trx_lines: '
731: ||lv_process_message);
732: END IF;
733:
734: IF nvl(ln_entered_amt, 0) <> 0 THEN

Line 766: lv_account_name := jai_cmn_rgm_processing_pkg.get_reversal_account_name(

762: IF pv_action = 'REVERSAL' THEN
763: -- code ported from BL12.1.3 by zhiwei.xin on 23-JAN-2013 begin
764: --Changed by Qiong for POT reversal begin
765: ------------------------------------------------------------------
766: lv_account_name := jai_cmn_rgm_processing_pkg.get_reversal_account_name(
767: p_regime_id => ln_regime_id
768: , p_organization_type => jai_constants.service_tax_orgn_type
769: , p_organization_id => ln_organization_id
770: , p_location_id => ln_location_id);

Line 789: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_cmn_rgm_processing_pkg.claim_reversal_trx_lines: '

785: , p_account_name => lv_account_name);
786:
787: IF ln_charge_account_id IS NULL THEN
788: lv_process_message := 'Interim Recovery Account/Recovery Account is not defined at the regime registration.';
789: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_cmn_rgm_processing_pkg.claim_reversal_trx_lines: '
790: ||lv_process_message);
791: END IF;
792: jai_cmn_rgm_recording_pkg.post_accounting(
793: p_regime_code => lv_regime_code,

Line 869: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_cmn_rgm_processing_pkg.claim_reversal_trx_lines: '

865: , p_account_name => lv_account_name);
866:
867: IF ln_charge_account_id IS NULL THEN
868: lv_process_message := 'Reversal Account /Liability Account is not defined at the regime registration.';
869: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_cmn_rgm_processing_pkg.claim_reversal_trx_lines: '
870: ||lv_process_message);
871: END IF;
872: jai_cmn_rgm_recording_pkg.post_accounting(
873: p_regime_code => lv_regime_code,

Line 915: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_cmn_rgm_processing_pkg.claim_reversal_trx_lines: '

911: , p_account_name => lv_account_name);
912:
913: IF ln_charge_account_id IS NULL THEN
914: lv_process_message := 'Reversal Account /Liability Account is not defined at the regime registration.';
915: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_cmn_rgm_processing_pkg.claim_reversal_trx_lines: '
916: ||lv_process_message);
917: END IF;
918: jai_cmn_rgm_recording_pkg.post_accounting(
919: p_regime_code => lv_regime_code,

Line 4230: P_CALLED_FROM => 'jai_cmn_rgm_processing_pkg.PROCESS',

4226: P_VAT_INVOICE_NO => lv_vat_invoice_number ,
4227: P_TRANSACTION_TYPE => jai_cmn_rgm_vat_accnt_pkg.gv_transaction_type_dflt,
4228: P_DEFAULT_INVOICE_DATE => NVL(ld_override_invoice_date,SYSDATE),
4229: P_BATCH_ID => ln_batch_id ,
4230: P_CALLED_FROM => 'jai_cmn_rgm_processing_pkg.PROCESS',
4231: P_DEBUG => lv_debug ,
4232: P_PROCESS_FLAG => lv_acct_process_flag ,
4233: P_PROCESS_MESSAGE => lv_acct_process_message
4234: );

Line 4392: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));

4388:
4389: EXCEPTION
4390: WHEN OTHERS THEN
4391: RETCODE := '2';
4392: Fnd_File.PUT_LINE(Fnd_File.LOG,'Unexpected Error occured in procedure jai_cmn_rgm_processing_pkg.process '||substr(sqlerrm,1,300));
4393: lb_completion_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',substr(sqlerrm,1,1000));
4394: ERRBUF := substr(sqlerrm,1,1000);
4395: lv_inv_gen_process_flag := jai_constants.unexpected_error;
4396: lv_acct_process_flag := jai_constants.unexpected_error;

Line 4543: lv_called_from CONSTANT varchar2(100) := 'jai_cmn_rgm_processing_pkg.populate_repository';

4539: AND rgtf.organization_id = p_organization_id--Added by zhiwei for POT Bug#12970828 on 20110915
4540: AND rgtf.party_type = 'V');
4541:
4542: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AP_INVOICE_DISTRIBUTIONS_ALL';
4543: lv_called_from CONSTANT varchar2(100) := 'jai_cmn_rgm_processing_pkg.populate_repository';
4544: ln_repository_id NUMBER;
4545: ln_discounted_amt NUMBER := 0;
4546: ln_organization_id NUMBER := p_organization_id;
4547: ln_location_id NUMBER;

Line 4992: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag

4988:
4989: IF lv_process_flag = jai_constants.expected_error OR
4990: lv_process_flag = jai_constants.unexpected_error THEN
4991: fnd_file.put_line( fnd_file.log,
4992: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
4993: ||', lv_process_message'||lv_process_message);
4994: p_process_flag := lv_process_flag;
4995: p_process_message := lv_process_message;
4996: END IF;

Line 5087: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag

5083:
5084: IF lv_process_flag = jai_constants.expected_error OR
5085: lv_process_flag = jai_constants.unexpected_error THEN
5086: fnd_file.put_line( fnd_file.log,
5087: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
5088: ||', lv_process_message'||lv_process_message);
5089: p_process_flag := lv_process_flag;
5090: p_process_message := lv_process_message;
5091: END IF;

Line 5200: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag

5196:
5197: IF lv_process_flag = jai_constants.expected_error OR
5198: lv_process_flag = jai_constants.unexpected_error THEN
5199: fnd_file.put_line( fnd_file.log,
5200: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
5201: ||', lv_process_message'||lv_process_message);
5202: p_process_flag := lv_process_flag;
5203: p_process_message := lv_process_message;
5204: END IF;

Line 5303: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag

5299:
5300: IF lv_process_flag = jai_constants.expected_error OR
5301: lv_process_flag = jai_constants.unexpected_error THEN
5302: fnd_file.put_line( fnd_file.log,
5303: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
5304: ||', lv_process_message'||lv_process_message);
5305: p_process_flag := lv_process_flag;
5306: p_process_message := lv_process_message;
5307: END IF;

Line 5320: END jai_cmn_rgm_processing_pkg;

5316: END populate_repository;
5317: ----------------------------------------------------------------------------------------------
5318: --Add by Xiao for POT change, reg bug#12533434 on 10-May-2011, end
5319:
5320: END jai_cmn_rgm_processing_pkg;