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_AR_RGM_PROCESSING_PKG dependencies on JAI_AR_RGM_PROCESSING_PKG

Line 1: PACKAGE BODY jai_ar_rgm_processing_pkg

1: PACKAGE BODY jai_ar_rgm_processing_pkg
2: /* $Header: jai_ar_rgm_proc.plb 120.53.12020000.4 2013/01/09 08:10:17 qioliu ship $ */
3:
4: /******************************************************************************************************************************************************
5: Created By : aiyer

Line 538: p_error_message := 'Unexpected Error Occured in procedure jai_ar_rgm_processing_pkg.get_regime_info - '||substr(sqlerrm,1,300);

534:
535: EXCEPTION
536: WHEN OTHERS THEN
537: p_error_flag := jai_constants.unexpected_error;
538: p_error_message := 'Unexpected Error Occured in procedure jai_ar_rgm_processing_pkg.get_regime_info - '||substr(sqlerrm,1,300);
539: END get_regime_info;
540:
541: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
542: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,

Line 630: fnd_file.put_line(fnd_file.LOG,'* 1 START OF PROCEDURE jai_ar_rgm_processing_pkg.GET_AR_TAX_DISC_ACCNT *');

626: ln_total_rec_disc_amt JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
627:
628: BEGIN
629:
630: fnd_file.put_line(fnd_file.LOG,'********************* 1 START OF PROCEDURE jai_ar_rgm_processing_pkg.GET_AR_TAX_DISC_ACCNT *********************');
631:
632: /*
633: || Variable Intialization
634: */

Line 737: fnd_file.put_line(fnd_file.LOG,'* 10 END OF PROCEDURE jai_ar_rgm_processing_pkg.GET_AR_TAX_DISC_ACCNT *');

733: ||', p_unearned_disc_ccid ->' || p_unearned_disc_ccid
734: ||', p_process_flag ->' || p_process_flag
735: ||', p_process_message ->' || p_process_message
736: );
737: fnd_file.put_line(fnd_file.LOG,'********************* 10 END OF PROCEDURE jai_ar_rgm_processing_pkg.GET_AR_TAX_DISC_ACCNT *********************');
738:
739: EXCEPTION
740: WHEN OTHERS THEN
741: p_process_flag := jai_constants.unexpected_error ;

Line 956: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_ar_rgm_processing_pkg.populate_inv_cm_references' );

952: ||Based on the input parameters get invoice details
953: ||for which localization has corresponding service tax
954: ******/
955:
956: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_ar_rgm_processing_pkg.populate_inv_cm_references' );
957:
958: fnd_file.put_line(fnd_file.LOG,'p_org_id:'||p_org_id );
959: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );
960:

Line 1178: lv_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_inv_cm_references'||substr(SQLERRM,1,500) ;

1174: EXCEPTION
1175: WHEN OTHERS THEN
1176:
1177: lv_process_flag := jai_constants.unexpected_error;
1178: lv_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_inv_cm_references'||substr(SQLERRM,1,500) ;
1179: ROLLBACK to before_ref_inv_cm;
1180:
1181: END populate_inv_cm_references;
1182:

Line 1209: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_rgm_processing_pkg.delete_non_existant_cm';

1205: lv_attribute_context jai_rgm_trx_records.attribute_context%TYPE ; --rchandan for bug#4428980
1206: lv_source_table jai_rgm_trx_records.source_table_name%TYPE ; --rchandan for bug#4428980
1207:
1208: /* Added by Ramananda for bug#4407165 */
1209: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_rgm_processing_pkg.delete_non_existant_cm';
1210:
1211: /*
1212: || Get all the cm's which exist in the reference table jai_rgm_trx_refs and have been incompleted/incompleted and deleted from AR base table
1213: || IF a CM has been incompleted then it would exist with complete_flag = 'N' . if a CM has been incompleted and deleted then it would not exist

Line 1716: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_CM_APP';--rchandan for bug#4428980

1712: lv_application_type ar_receivable_applications_all.application_type%TYPE ;--rchandan for bug#4428980
1713: lv_status ar_receivable_applications_all.status%TYPE ;--rchandan for bug#4428980
1714: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980
1715: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1716: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_CM_APP';--rchandan for bug#4428980
1717: lv_attribute_context jai_rgm_trx_records.attribute_context%TYPE ;--rchandan for bug#4428980
1718:
1719: ln_total_tax_applied NUMBER; --added by walton for inclusive tax 29-Nov-07
1720: ln_line_total_amt NUMBER; --added by walton for inclusive tax 29-Nov-07

Line 2546: fnd_file.put_line(fnd_file.LOG,' 27 In exception section of jai_ar_rgm_processing_pkg.populate_cm_app' );

2542: END LOOP; -- End of receivables fetch loop
2543:
2544: EXCEPTION
2545: WHEN OTHERS THEN
2546: fnd_file.put_line(fnd_file.LOG,' 27 In exception section of jai_ar_rgm_processing_pkg.populate_cm_app' );
2547: p_process_flag := jai_constants.unexpected_error;
2548: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_cm_app'||SQLERRM ;
2549: END populate_cm_app;
2550:

Line 2548: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_cm_app'||SQLERRM ;

2544: EXCEPTION
2545: WHEN OTHERS THEN
2546: fnd_file.put_line(fnd_file.LOG,' 27 In exception section of jai_ar_rgm_processing_pkg.populate_cm_app' );
2547: p_process_flag := jai_constants.unexpected_error;
2548: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_cm_app'||SQLERRM ;
2549: END populate_cm_app;
2550:
2551:
2552: procedure populate_receipt_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,

Line 2579: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS';--rchandan for bug#4428980

2575: ln_uncommitted_transactions NUMBER(10) := 0 ;
2576: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
2577: ln_location_id NUMBER(15);/*5879769*/
2578: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
2579: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS';--rchandan for bug#4428980
2580:
2581: ln_total_tax_applied NUMBER; --added by walton for inclusive tax 29-Nov-07
2582: ln_line_total_amt NUMBER; --added by walton for inclusive tax 29-Nov-07
2583: ln_inclusive_total_amt NUMBER; --added by walton for inclusive tax 29-Nov-07

Line 3377: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_receipt_records'||SQLERRM ;

3373:
3374: EXCEPTION
3375: WHEN OTHERS THEN
3376: p_process_flag := jai_constants.unexpected_error;
3377: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_receipt_records'||SQLERRM ;
3378:
3379: END populate_receipt_records;
3380:
3381: /*Bug 11821537 - Start*/

Line 3396: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.populate_repository';

3392: p_organization_id IN JAI_RGM_PARTIES.ORGANIZATION_ID%TYPE DEFAULT NULL)
3393: IS
3394: /*Variables*/
3395: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'CUSTOMER_TRX_LINE_ALL';
3396: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.populate_repository';
3397: ln_repository_id NUMBER;
3398: ln_discounted_amt NUMBER := 0;
3399:
3400: /*Cursors*/

Line 3956: fnd_file.put_line( fnd_file.log, '5.1 ERROR IN CALL TO jai_ar_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag

3952: p_invoice_no => r_ar_transactions.st_inv_number --Added by Qiong for Advanced Receipts
3953: );
3954: IF lv_process_flag = jai_constants.expected_error OR
3955: lv_process_flag = jai_constants.unexpected_error THEN
3956: fnd_file.put_line( fnd_file.log, '5.1 ERROR IN CALL TO jai_ar_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
3957: ||', lv_process_message'||lv_process_message);
3958: p_process_flag := lv_process_flag ;
3959: p_process_message := lv_process_message ;
3960: END IF;

Line 3971: fnd_file.put_line( fnd_file.log, '6.1 ERROR IN CALL TO jai_ar_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag

3967: p_process_message => lv_process_message
3968: );
3969: IF lv_process_flag = jai_constants.expected_error OR
3970: lv_process_flag = jai_constants.unexpected_error THEN
3971: fnd_file.put_line( fnd_file.log, '6.1 ERROR IN CALL TO jai_ar_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
3972: ||', lv_process_message'||lv_process_message);
3973: p_process_flag := lv_process_flag ;
3974: p_process_message := lv_process_message ;
3975: END IF;

Line 4659: fnd_file.put_line(fnd_file.LOG,'############################## 1 START OF PROCEDURE TO jai_ar_rgm_processing_pkg.PROCESS_RECORDS ############################## ');

4655: --ld_st_accrual_date DATE; /*11821537*/ --Commented by zhiwei.hou for POT code port.
4656: /*Bug 11821537 - End*/
4657: BEGIN
4658:
4659: fnd_file.put_line(fnd_file.LOG,'############################## 1 START OF PROCEDURE TO jai_ar_rgm_processing_pkg.PROCESS_RECORDS ############################## ');
4660:
4661: /*########################################################################################################
4662: || VARIABLES INITIALIZATION
4663: ########################################################################################################*/

Line 4705: fnd_file.put_line(fnd_file.LOG,'############################## 3 BEFORE CALL TO jai_ar_rgm_processing_pkg.POPULATE_INV_CM_REFERENCES ##############################');

4701: /*########################################################################################################
4702: || PROCESS AR INVOICE AND CREDIT MEMO'S FOR REFERENCE ENTRIES
4703: ########################################################################################################*/
4704:
4705: fnd_file.put_line(fnd_file.LOG,'############################## 3 BEFORE CALL TO jai_ar_rgm_processing_pkg.POPULATE_INV_CM_REFERENCES ##############################');
4706:
4707: populate_inv_cm_references ( p_regime_id => p_regime_id ,
4708: p_organization_type => p_organization_type ,
4709: p_organization_id => p_organization_id ,/*5879769*/

Line 4737: fnd_file.put_line( fnd_file.log, '4 ERROR IN CALL TO jai_ar_rgm_processing_pkg.POPULATE_INV_CM_REFERENCES - lv_process_flag '||lv_process_flag

4733: || As Returned status is an error hence:-
4734: || Set out variables p_process_flag and p_process_message accordingly
4735: */
4736:
4737: fnd_file.put_line( fnd_file.log, '4 ERROR IN CALL TO jai_ar_rgm_processing_pkg.POPULATE_INV_CM_REFERENCES - lv_process_flag '||lv_process_flag
4738: ||', lv_process_message'||lv_process_message);
4739: p_process_flag := lv_process_flag ;
4740: p_process_message := lv_process_message ;
4741: END IF;

Line 4743: fnd_file.put_line(fnd_file.LOG,'############################## 5 RETURNED FROM jai_ar_rgm_processing_pkg.POPULATE_INV_CM_REFERENCES'||'lv_process_flag - '||lv_process_flag||

4739: p_process_flag := lv_process_flag ;
4740: p_process_message := lv_process_message ;
4741: END IF;
4742:
4743: fnd_file.put_line(fnd_file.LOG,'############################## 5 RETURNED FROM jai_ar_rgm_processing_pkg.POPULATE_INV_CM_REFERENCES'||'lv_process_flag - '||lv_process_flag||
4744: ' lv_process_message- '||lv_process_message||'############################## ');
4745:
4746: fnd_file.put_line(fnd_file.LOG,'############################## 6 BEFORE CALL TO jai_ar_rgm_processing_pkg.populate_repository ##############################');
4747:

Line 4746: fnd_file.put_line(fnd_file.LOG,'############################## 6 BEFORE CALL TO jai_ar_rgm_processing_pkg.populate_repository ##############################');

4742:
4743: fnd_file.put_line(fnd_file.LOG,'############################## 5 RETURNED FROM jai_ar_rgm_processing_pkg.POPULATE_INV_CM_REFERENCES'||'lv_process_flag - '||lv_process_flag||
4744: ' lv_process_message- '||lv_process_message||'############################## ');
4745:
4746: fnd_file.put_line(fnd_file.LOG,'############################## 6 BEFORE CALL TO jai_ar_rgm_processing_pkg.populate_repository ##############################');
4747:
4748: populate_repository ( p_regime_id => p_regime_id ,
4749: p_organization_type => p_organization_type ,
4750: p_organization_id => p_organization_id ,

Line 4767: fnd_file.put_line( fnd_file.log, '7 ERROR IN CALL TO jai_ar_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag

4763: /*
4764: || As Returned status is an error hence:-
4765: || Set out variables p_process_flag and p_process_message accordingly
4766: */
4767: fnd_file.put_line( fnd_file.log, '7 ERROR IN CALL TO jai_ar_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
4768: ||', lv_process_message'||lv_process_message);
4769: p_process_flag := lv_process_flag ;
4770: p_process_message := lv_process_message ;
4771: END IF;

Line 4773: fnd_file.put_line(fnd_file.LOG,'############################## 8 RETURNED FROM jai_ar_rgm_processing_pkg.populate_repository'||'lv_process_flag - '||lv_process_flag||

4769: p_process_flag := lv_process_flag ;
4770: p_process_message := lv_process_message ;
4771: END IF;
4772:
4773: fnd_file.put_line(fnd_file.LOG,'############################## 8 RETURNED FROM jai_ar_rgm_processing_pkg.populate_repository'||'lv_process_flag - '||lv_process_flag||
4774: ' lv_process_message- '||lv_process_message||'############################## ');
4775: /*########################################################################################################
4776: || DELETE NON INCOMPLETE/NON-EXISTING CREDIT MEMO'S
4777: ########################################################################################################*/

Line 4787: fnd_file.put_line(fnd_file.LOG,'############################## 6 BEFORE CALL TO jai_ar_rgm_processing_pkg.DELETE_NON_EXISTANT_CM ############################## ');

4783: /*Bug 11821537 - Update repository entry. Accounting is taken care during AR Invoice Creation or Import
4784: Hence commenting procedures delete_non_existant_cm, populate_cm_app and populate_receipt_records
4785: Code shall be rewritten to pick AR Invoices*/
4786: --/* --Commented comments by zhiwei.hou for POT code port.
4787: fnd_file.put_line(fnd_file.LOG,'############################## 6 BEFORE CALL TO jai_ar_rgm_processing_pkg.DELETE_NON_EXISTANT_CM ############################## ');
4788:
4789: delete_non_existant_cm ( p_regime_id => p_regime_id ,
4790: p_organization_type => p_organization_type ,
4791: p_organization_id => p_organization_id ,

Line 4805: fnd_file.put_line( fnd_file.log, '7 ERROR IN CALL TO jai_ar_rgm_processing_pkg.DELETE_NON_EXISTANT_CM - lv_process_flag '||lv_process_flag

4801: IF lv_process_flag = jai_constants.expected_error OR
4802: lv_process_flag = jai_constants.unexpected_error
4803: THEN
4804:
4805: fnd_file.put_line( fnd_file.log, '7 ERROR IN CALL TO jai_ar_rgm_processing_pkg.DELETE_NON_EXISTANT_CM - lv_process_flag '||lv_process_flag
4806: ||', lv_process_message'||lv_process_message);
4807: p_process_flag := lv_process_flag ;
4808: p_process_message := lv_process_message ;
4809: END IF;

Line 4812: fnd_file.put_line(fnd_file.LOG,'############################## 8 RETURNED FROM jai_ar_rgm_processing_pkg.DELETE_NON_EXISTANT_CM'||'lv_process_flag - '||lv_process_flag||

4808: p_process_message := lv_process_message ;
4809: END IF;
4810:
4811:
4812: fnd_file.put_line(fnd_file.LOG,'############################## 8 RETURNED FROM jai_ar_rgm_processing_pkg.DELETE_NON_EXISTANT_CM'||'lv_process_flag - '||lv_process_flag||
4813: ' lv_process_message- '||lv_process_message||'############################## ');
4814: --*/--Commented comments by zhiwei.hou for POT code port
4815:
4816: /*########################################################################################################

Line 4821: fnd_file.put_line(fnd_file.LOG,'############################## 9 BEFORE CALL TO jai_ar_rgm_processing_pkg.POPULATE_CM_APP ############################## ');

4817: || PROCESS AR CREDIT MEMO APPLICATIONS AGAINST INVOICES
4818: ########################################################################################################*/
4819:
4820: --/*--Commented comments by zhiwei.hou for POT code port.
4821: fnd_file.put_line(fnd_file.LOG,'############################## 9 BEFORE CALL TO jai_ar_rgm_processing_pkg.POPULATE_CM_APP ############################## ');
4822:
4823: populate_cm_app ( p_regime_id => p_regime_id ,
4824: p_organization_type => p_organization_type ,
4825: p_organization_id => p_organization_id ,

Line 4840: fnd_file.put_line( fnd_file.log, '10 error in call to jai_ar_rgm_processing_pkg.populate_cm_app - lv_process_flag '||lv_process_flag

4836: IF lv_process_flag = jai_constants.expected_error OR
4837: lv_process_flag = jai_constants.unexpected_error
4838: THEN
4839:
4840: fnd_file.put_line( fnd_file.log, '10 error in call to jai_ar_rgm_processing_pkg.populate_cm_app - lv_process_flag '||lv_process_flag
4841: ||', lv_process_message'||lv_process_message);
4842: p_process_flag := lv_process_flag ;
4843: p_process_message := lv_process_message ;
4844: END IF;

Line 4847: fnd_file.put_line(fnd_file.LOG,'############################## 11 RETURNED FROM CALL TO jai_ar_rgm_processing_pkg.POPULATE_CM_APP '||'lv_process_flag - '||lv_process_flag||

4843: p_process_message := lv_process_message ;
4844: END IF;
4845:
4846:
4847: fnd_file.put_line(fnd_file.LOG,'############################## 11 RETURNED FROM CALL TO jai_ar_rgm_processing_pkg.POPULATE_CM_APP '||'lv_process_flag - '||lv_process_flag||
4848: ' lv_process_message- '||lv_process_message||'##############################');
4849:
4850: --*/--Commented comments by zhiwei.hou for POT code port.
4851: /*########################################################################################################

Line 4856: fnd_file.put_line(fnd_file.LOG,'############################## 12 BEFORE CALL TO jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS ##############################');

4852: || PROCESS AR CASH RECEIPT APPLICATIONS AGAINST INVOICES
4853: ########################################################################################################*/
4854:
4855: --/*--Commented comments by zhiwei.hou for POT code port.
4856: fnd_file.put_line(fnd_file.LOG,'############################## 12 BEFORE CALL TO jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS ##############################');
4857:
4858: populate_receipt_records ( p_regime_id => p_regime_id ,
4859: p_organization_type => p_organization_type ,
4860: p_organization_id => p_organization_id ,

Line 4874: fnd_file.put_line( fnd_file.log, '13 ERROR IN CALL TO jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS - lv_process_flag '||lv_process_flag

4870: IF lv_process_flag = jai_constants.expected_error OR
4871: lv_process_flag = jai_constants.unexpected_error
4872: THEN
4873:
4874: fnd_file.put_line( fnd_file.log, '13 ERROR IN CALL TO jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS - lv_process_flag '||lv_process_flag
4875: ||', lv_process_message'||lv_process_message);
4876: p_process_flag := lv_process_flag ;
4877: p_process_message := lv_process_message ;
4878: END IF;

Line 4880: fnd_file.put_line(fnd_file.LOG,'##############################14 RETURNED FROM jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS'||'lv_process_flag - '||lv_process_flag||

4876: p_process_flag := lv_process_flag ;
4877: p_process_message := lv_process_message ;
4878: END IF;
4879:
4880: fnd_file.put_line(fnd_file.LOG,'##############################14 RETURNED FROM jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS'||'lv_process_flag - '||lv_process_flag||
4881: ' lv_process_message- '||lv_process_message||'##############################');
4882: --*/--Commented comments by zhiwei.hou for POT code port.
4883:
4884: fnd_file.put_line(fnd_file.LOG,'############################## 15 END OF PROCEDURE TO jai_ar_rgm_processing_pkg.PROCESS_RECORDS - ##############################');

Line 4884: fnd_file.put_line(fnd_file.LOG,'############################## 15 END OF PROCEDURE TO jai_ar_rgm_processing_pkg.PROCESS_RECORDS - ##############################');

4880: fnd_file.put_line(fnd_file.LOG,'##############################14 RETURNED FROM jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS'||'lv_process_flag - '||lv_process_flag||
4881: ' lv_process_message- '||lv_process_message||'##############################');
4882: --*/--Commented comments by zhiwei.hou for POT code port.
4883:
4884: fnd_file.put_line(fnd_file.LOG,'############################## 15 END OF PROCEDURE TO jai_ar_rgm_processing_pkg.PROCESS_RECORDS - ##############################');
4885:
4886: EXCEPTION
4887: WHEN OTHERS THEN
4888: lv_process_flag := jai_constants.unexpected_error;

Line 4889: lv_process_message := ' 16 Unexpected error occured while processing jai_ar_rgm_processing_pkg.process_records'||SQLERRM ;

4885:
4886: EXCEPTION
4887: WHEN OTHERS THEN
4888: lv_process_flag := jai_constants.unexpected_error;
4889: lv_process_message := ' 16 Unexpected error occured while processing jai_ar_rgm_processing_pkg.process_records'||SQLERRM ;
4890:
4891: END process_records;
4892:
4893: /*Added by Wenqiong for Advanced Receipt on Service Taxes Begin */

Line 5574: p_process_message := ' Unexpected error occured while processing jai_ar_rgm_processing_pkg.generate_documents'||substr(SQLERRM,1,1500) ;

5570:
5571: EXCEPTION
5572: WHEN OTHERS THEN
5573: p_process_flag := jai_constants.unexpected_error;
5574: p_process_message := ' Unexpected error occured while processing jai_ar_rgm_processing_pkg.generate_documents'||substr(SQLERRM,1,1500) ;
5575: END generate_documents;
5576:
5577: --========================================================================
5578: -- PROCEDURE : generate_docuements PUBLIC

Line 5840: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_ar_rgm_processing_pkg.generate_gl_entry: '

5836: p_tax_type => lv_tax_type,
5837: p_account_name => jai_constants.liability);
5838: IF ln_tax_type_ccid IS NULL THEN
5839: lv_process_message := 'Liability Account is not defined at the regime registration.';
5840: RAISE_APPLICATION_ERROR(-20007, 'Error - package jai_ar_rgm_processing_pkg.generate_gl_entry: '
5841: ||lv_process_message);
5842: END IF;
5843:
5844: OPEN cur_get_unapplied_account;

Line 6130: END jai_ar_rgm_processing_pkg ;

6126: p_document_type := lv_app_doc_type;
6127:
6128: END validate_app_unapp;
6129: /*Added by Wenqiong for Advanced Receipt on Service Taxes End */
6130: END jai_ar_rgm_processing_pkg ;