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.7.12010000.3 2008/11/25 04:24:50 mbremkum ship $ */
3:
4: /******************************************************************************************************************************************************
5: Created By : aiyer

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

232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: p_error_flag := jai_constants.unexpected_error;
236: p_error_message := 'Unexpected Error Occured in procedure jai_ar_rgm_processing_pkg.get_regime_info - '||substr(sqlerrm,1,300);
237: END get_regime_info;
238:
239: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
240: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,

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

324: ln_total_rec_disc_amt JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ;
325:
326: BEGIN
327:
328: fnd_file.put_line(fnd_file.LOG,'********************* 1 START OF PROCEDURE jai_ar_rgm_processing_pkg.GET_AR_TAX_DISC_ACCNT *********************');
329:
330: /*
331: || Variable Intialization
332: */

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

431: ||', p_unearned_disc_ccid ->' || p_unearned_disc_ccid
432: ||', p_process_flag ->' || p_process_flag
433: ||', p_process_message ->' || p_process_message
434: );
435: fnd_file.put_line(fnd_file.LOG,'********************* 10 END OF PROCEDURE jai_ar_rgm_processing_pkg.GET_AR_TAX_DISC_ACCNT *********************');
436:
437: EXCEPTION
438: WHEN OTHERS THEN
439: p_process_flag := jai_constants.unexpected_error ;

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

545: ||Based on the input parameters get invoice details
546: ||for which localization has corresponding service tax
547: ******/
548:
549: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_ar_rgm_processing_pkg.populate_inv_cm_references' );
550:
551: fnd_file.put_line(fnd_file.LOG,'p_org_id:'||p_org_id );
552: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );
553:

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

650: EXCEPTION
651: WHEN OTHERS THEN
652:
653: lv_process_flag := jai_constants.unexpected_error;
654: lv_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_inv_cm_references'||substr(SQLERRM,1,500) ;
655: ROLLBACK to before_ref_inv_cm;
656:
657: END populate_inv_cm_references;
658:

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

681: lv_attribute_context jai_rgm_trx_records.attribute_context%TYPE ; --rchandan for bug#4428980
682: lv_source_table jai_rgm_trx_records.source_table_name%TYPE ; --rchandan for bug#4428980
683:
684: /* Added by Ramananda for bug#4407165 */
685: lv_object_name CONSTANT VARCHAR2(61) := 'jai_ar_rgm_processing_pkg.delete_non_existant_cm';
686:
687: /*
688: || 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
689: || 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 1161: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_CM_APP';--rchandan for bug#4428980

1157: lv_application_type ar_receivable_applications_all.application_type%TYPE ;--rchandan for bug#4428980
1158: lv_status ar_receivable_applications_all.status%TYPE ;--rchandan for bug#4428980
1159: lv_type ra_cust_trx_types_all.type%TYPE ;--rchandan for bug#4428980
1160: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1161: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_CM_APP';--rchandan for bug#4428980
1162: lv_attribute_context jai_rgm_trx_records.attribute_context%TYPE ;--rchandan for bug#4428980
1163:
1164: ln_total_tax_applied NUMBER; --added by walton for inclusive tax 29-Nov-07
1165: ln_line_total_amt NUMBER; --added by walton for inclusive tax 29-Nov-07

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

1837: END LOOP; -- End of receivables fetch loop
1838:
1839: EXCEPTION
1840: WHEN OTHERS THEN
1841: fnd_file.put_line(fnd_file.LOG,' 27 In exception section of jai_ar_rgm_processing_pkg.populate_cm_app' );
1842: p_process_flag := jai_constants.unexpected_error;
1843: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_cm_app'||SQLERRM ;
1844: END populate_cm_app;
1845:

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

1839: EXCEPTION
1840: WHEN OTHERS THEN
1841: fnd_file.put_line(fnd_file.LOG,' 27 In exception section of jai_ar_rgm_processing_pkg.populate_cm_app' );
1842: p_process_flag := jai_constants.unexpected_error;
1843: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_cm_app'||SQLERRM ;
1844: END populate_cm_app;
1845:
1846:
1847: procedure populate_receipt_records ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,

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

1868: ln_uncommitted_transactions NUMBER(10) := 0 ;
1869: lv_service_type_code JAI_AR_TRX_LINES.service_type_code%TYPE ;/*5879769*/
1870: ln_location_id NUMBER(15);/*5879769*/
1871: lv_source_table CONSTANT jai_rgm_trx_records.source_table_name%TYPE := 'AR_RECEIVABLE_APPLICATIONS_ALL';--rchandan for bug#4428980
1872: lv_called_from CONSTANT varchar2(100) := 'jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS';--rchandan for bug#4428980
1873:
1874: ln_total_tax_applied NUMBER; --added by walton for inclusive tax 29-Nov-07
1875: ln_line_total_amt NUMBER; --added by walton for inclusive tax 29-Nov-07
1876: ln_inclusive_total_amt NUMBER; --added by walton for inclusive tax 29-Nov-07

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

2327:
2328: EXCEPTION
2329: WHEN OTHERS THEN
2330: p_process_flag := jai_constants.unexpected_error;
2331: p_process_message := 'Unexpected error occured while processing jai_ar_rgm_processing_pkg.populate_receipt_records'||SQLERRM ;
2332:
2333: END populate_receipt_records;
2334:
2335:

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

2353: lv_process_message VARCHAR2(1996) ;
2354: lv_organization_id jai_rgm_parties.organization_id%type;
2355: BEGIN
2356:
2357: fnd_file.put_line(fnd_file.LOG,'############################## 1 START OF PROCEDURE TO jai_ar_rgm_processing_pkg.PROCESS_RECORDS ############################## ');
2358:
2359: /*########################################################################################################
2360: || VARIABLES INITIALIZATION
2361: ########################################################################################################*/

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

2381: /*########################################################################################################
2382: || PROCESS AR INVOICE AND CREDIT MEMO'S FOR REFERENCE ENTRIES
2383: ########################################################################################################*/
2384:
2385: fnd_file.put_line(fnd_file.LOG,'############################## 3 BEFORE CALL TO jai_ar_rgm_processing_pkg.POPULATE_INV_CM_REFERENCES ##############################');
2386:
2387: populate_inv_cm_references ( p_regime_id => p_regime_id ,
2388: p_organization_type => p_organization_type ,
2389: p_organization_id => p_organization_id ,/*5879769*/

Line 2409: 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

2405: || As Returned status is an error hence:-
2406: || Set out variables p_process_flag and p_process_message accordingly
2407: */
2408:
2409: 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
2410: ||', lv_process_message'||lv_process_message);
2411: p_process_flag := lv_process_flag ;
2412: p_process_message := lv_process_message ;
2413: END IF;

Line 2415: 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||

2411: p_process_flag := lv_process_flag ;
2412: p_process_message := lv_process_message ;
2413: END IF;
2414:
2415: 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||
2416: ' lv_process_message- '||lv_process_message||'############################## ');
2417:
2418:
2419: /*########################################################################################################

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

2423: /*
2424: || Reverse all those AR Credit Memo's which have been incompleted/incompleted
2425: || and deleted from base ar tables
2426: */
2427: fnd_file.put_line(fnd_file.LOG,'############################## 6 BEFORE CALL TO jai_ar_rgm_processing_pkg.DELETE_NON_EXISTANT_CM ############################## ');
2428:
2429: delete_non_existant_cm ( p_regime_id => p_regime_id ,
2430: p_organization_type => p_organization_type ,
2431: p_organization_id => p_organization_id ,/*5879769*/

Line 2449: 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

2445: || As Returned status is an error hence:-
2446: || Set out variables p_process_flag and p_process_message accordingly
2447: */
2448:
2449: 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
2450: ||', lv_process_message'||lv_process_message);
2451: p_process_flag := lv_process_flag ;
2452: p_process_message := lv_process_message ;
2453: END IF;

Line 2456: 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||

2452: p_process_message := lv_process_message ;
2453: END IF;
2454:
2455:
2456: 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||
2457: ' lv_process_message- '||lv_process_message||'############################## ');
2458:
2459:
2460: /*########################################################################################################

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

2461: || PROCESS AR CREDIT MEMO APPLICATIONS AGAINST INVOICES
2462: ########################################################################################################*/
2463:
2464:
2465: fnd_file.put_line(fnd_file.LOG,'############################## 9 BEFORE CALL TO jai_ar_rgm_processing_pkg.POPULATE_CM_APP ############################## ');
2466:
2467: populate_cm_app ( p_regime_id => p_regime_id ,
2468: p_organization_type => p_organization_type ,
2469: p_organization_id => p_organization_id ,/*5879769*/

Line 2487: 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

2483: /*
2484: || As Returned status is an error hence:-
2485: || Set out variables p_process_flag and p_process_message accordingly
2486: */
2487: 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
2488: ||', lv_process_message'||lv_process_message);
2489: p_process_flag := lv_process_flag ;
2490: p_process_message := lv_process_message ;
2491: END IF;

Line 2494: 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||

2490: p_process_message := lv_process_message ;
2491: END IF;
2492:
2493:
2494: 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||
2495: ' lv_process_message- '||lv_process_message||'##############################');
2496:
2497:
2498: /*########################################################################################################

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

2499: || PROCESS AR CASH RECEIPT APPLICATIONS AGAINST INVOICES
2500: ########################################################################################################*/
2501:
2502:
2503: fnd_file.put_line(fnd_file.LOG,'############################## 12 BEFORE CALL TO jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS ##############################');
2504:
2505: populate_receipt_records ( p_regime_id => p_regime_id ,
2506: p_organization_type => p_organization_type ,
2507: p_organization_id => p_organization_id ,/*5879769*/

Line 2524: 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

2520: /*
2521: || As Returned status is an error hence:-
2522: || Set out variables p_process_flag and p_process_message accordingly
2523: */
2524: 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
2525: ||', lv_process_message'||lv_process_message);
2526: p_process_flag := lv_process_flag ;
2527: p_process_message := lv_process_message ;
2528: END IF;

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

2526: p_process_flag := lv_process_flag ;
2527: p_process_message := lv_process_message ;
2528: END IF;
2529:
2530: fnd_file.put_line(fnd_file.LOG,'##############################14 RETURNED FROM jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS'||'lv_process_flag - '||lv_process_flag||
2531: ' lv_process_message- '||lv_process_message||'##############################');
2532:
2533:
2534: fnd_file.put_line(fnd_file.LOG,'############################## 15 END OF PROCEDURE TO jai_ar_rgm_processing_pkg.PROCESS_RECORDS - ##############################');

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

2530: fnd_file.put_line(fnd_file.LOG,'##############################14 RETURNED FROM jai_ar_rgm_processing_pkg.POPULATE_RECEIPT_RECORDS'||'lv_process_flag - '||lv_process_flag||
2531: ' lv_process_message- '||lv_process_message||'##############################');
2532:
2533:
2534: fnd_file.put_line(fnd_file.LOG,'############################## 15 END OF PROCEDURE TO jai_ar_rgm_processing_pkg.PROCESS_RECORDS - ##############################');
2535:
2536: EXCEPTION
2537: WHEN OTHERS THEN
2538: lv_process_flag := jai_constants.unexpected_error;

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

2535:
2536: EXCEPTION
2537: WHEN OTHERS THEN
2538: lv_process_flag := jai_constants.unexpected_error;
2539: lv_process_message := ' 16 Unexpected error occured while processing jai_ar_rgm_processing_pkg.process_records'||SQLERRM ;
2540:
2541: END process_records;
2542:
2543: END jai_ar_rgm_processing_pkg ;

Line 2543: END jai_ar_rgm_processing_pkg ;

2539: lv_process_message := ' 16 Unexpected error occured while processing jai_ar_rgm_processing_pkg.process_records'||SQLERRM ;
2540:
2541: END process_records;
2542:
2543: END jai_ar_rgm_processing_pkg ;