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 FND_FILE

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 638: fnd_file.put_line(fnd_file.LOG,' 2 Variables Initialised ');

634: */
635: p_process_flag := jai_constants.successful ;
636: p_process_message := null ;
637:
638: fnd_file.put_line(fnd_file.LOG,' 2 Variables Initialised ');
639:
640: IF p_total_disc_amount IS NULL THEN
641: p_process_flag := jai_constants.expected_error;
642: p_process_message := 'Service Tax Discounted cannot be NULL ';

Line 643: fnd_file.put_line(fnd_file.LOG,' 3 EXPECTED ERROR - Service Tax Discounted amount cannot be NULL ');

639:
640: IF p_total_disc_amount IS NULL THEN
641: p_process_flag := jai_constants.expected_error;
642: p_process_message := 'Service Tax Discounted cannot be NULL ';
643: fnd_file.put_line(fnd_file.LOG,' 3 EXPECTED ERROR - Service Tax Discounted amount cannot be NULL ');
644: return;
645: END IF;
646:
647: /*

Line 656: fnd_file.put_line(fnd_file.LOG,' 4 EXPECTED ERROR -Receivable Application record with the receivable_application_id -> '||p_receivable_application_id ||' not found ');

652: IF CUR_GET_RECEIVABLE_APP%NOTFOUND THEN
653: CLOSE cur_get_receivable_app;
654: p_process_flag := jai_constants.expected_error;
655: p_process_message := 'Receivable Application record with the receivable_application_id -> '||p_receivable_application_id ||' not found ';
656: fnd_file.put_line(fnd_file.LOG,' 4 EXPECTED ERROR -Receivable Application record with the receivable_application_id -> '||p_receivable_application_id ||' not found ');
657: return;
658: END IF;
659:
660: /*

Line 679: fnd_file.put_line(fnd_file.LOG,' 5 value of p_tax_ediscounted -> '|| p_tax_ediscounted

675:
676: /*
677: || End of 4193633
678: */
679: fnd_file.put_line(fnd_file.LOG,' 5 value of p_tax_ediscounted -> '|| p_tax_ediscounted
680: ||', p_tax_uediscounted -> ' || p_tax_uediscounted
681: ||', ln_total_rec_disc_amt -> '|| ln_total_rec_disc_amt
682: ||', rec_cur_get_receivable_app.tax_ediscounted -> '||rec_cur_get_receivable_app.tax_ediscounted
683: ||', rec_cur_get_receivable_app.tax_uediscounted -> '||rec_cur_get_receivable_app.tax_uediscounted

Line 700: fnd_file.put_line(fnd_file.LOG,' 6 EXPECTED ERROR - Earned Discount Account Setup not found in ar_receivables_trx_all ');

696: CLOSE cur_get_receivable_app;
697: CLOSE cur_get_disc_ccid;
698: p_process_flag := jai_constants.expected_error ;
699: p_process_message := 'Earned Discount Account Setup not found in ar_receivables_trx_all ';
700: fnd_file.put_line(fnd_file.LOG,' 6 EXPECTED ERROR - Earned Discount Account Setup not found in ar_receivables_trx_all ');
701: return;
702: END IF;
703: p_earned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;
704: CLOSE cur_get_disc_ccid;

Line 707: fnd_file.put_line(fnd_file.LOG,' 6 Earned Discount Account code combination id is '||rec_cur_get_disc_ccid.code_combination_id);

703: p_earned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;
704: CLOSE cur_get_disc_ccid;
705: END IF;
706:
707: fnd_file.put_line(fnd_file.LOG,' 6 Earned Discount Account code combination id is '||rec_cur_get_disc_ccid.code_combination_id);
708: /*
709: || Get the code combination id for the Unearned Discount Account
710: */
711: IF rec_cur_get_receivable_app.tax_uediscounted <> 0 THEN

Line 721: fnd_file.put_line(fnd_file.LOG,' 8 EXPECTED ERROR - UnEarned Discount Account Setup not found in ar_receivables_trx_all ');

717: CLOSE cur_get_receivable_app;
718: CLOSE cur_get_disc_ccid;
719: p_process_flag := jai_constants.expected_error ;
720: p_process_message := 'UnEarned Discount Account Setup not found in ar_receivables_trx_all ';
721: fnd_file.put_line(fnd_file.LOG,' 8 EXPECTED ERROR - UnEarned Discount Account Setup not found in ar_receivables_trx_all ');
722: return;
723: END IF;
724: p_unearned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;
725: CLOSE cur_get_disc_ccid;

Line 728: fnd_file.put_line(fnd_file.LOG,' 9 Unearned Account CCID is -> '||rec_cur_get_disc_ccid.code_combination_id);

724: p_unearned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;
725: CLOSE cur_get_disc_ccid;
726:
727: END IF;
728: fnd_file.put_line(fnd_file.LOG,' 9 Unearned Account CCID is -> '||rec_cur_get_disc_ccid.code_combination_id);
729: CLOSE cur_get_receivable_app;
730: fnd_file.put_line(fnd_file.LOG,' 10 Value of out variables p_tax_ediscounted ->' || p_tax_ediscounted
731: ||', p_earned_disc_ccid ->' || p_earned_disc_ccid
732: ||', p_tax_uediscounted ->' || p_tax_uediscounted

Line 730: fnd_file.put_line(fnd_file.LOG,' 10 Value of out variables p_tax_ediscounted ->' || p_tax_ediscounted

726:
727: END IF;
728: fnd_file.put_line(fnd_file.LOG,' 9 Unearned Account CCID is -> '||rec_cur_get_disc_ccid.code_combination_id);
729: CLOSE cur_get_receivable_app;
730: fnd_file.put_line(fnd_file.LOG,' 10 Value of out variables p_tax_ediscounted ->' || p_tax_ediscounted
731: ||', p_earned_disc_ccid ->' || p_earned_disc_ccid
732: ||', p_tax_uediscounted ->' || p_tax_uediscounted
733: ||', p_unearned_disc_ccid ->' || p_unearned_disc_ccid
734: ||', p_process_flag ->' || p_process_flag

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 958: fnd_file.put_line(fnd_file.LOG,'p_org_id:'||p_org_id );

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:
961: /*
962: || Variable Initialization

Line 959: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );

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:
961: /*
962: || Variable Initialization
963: */

Line 983: fnd_file.put_line(fnd_file.LOG,'2 processing record, customer_trx_id '||rec_c_fetch_inv_cm_rec.customer_trx_id

979: cp_sh_service_edu_cess => upper(jai_constants.tax_type_sh_service_edu_cess) --Added by Bgowrava for forward porting bug#5989740
980: )
981: LOOP
982:
983: fnd_file.put_line(fnd_file.LOG,'2 processing record, customer_trx_id '||rec_c_fetch_inv_cm_rec.customer_trx_id
984: ||', invoice line id '||rec_c_fetch_inv_cm_rec.link_to_cust_trx_line_id
985: ||', tax line id '||rec_c_fetch_inv_cm_rec.customer_trx_line_id
986: ||', tax_id '|| rec_c_fetch_inv_cm_rec.tax_id
987: ||', tax rate '||rec_c_fetch_inv_cm_rec.tax_rate

Line 1006: fnd_file.put_line(fnd_file.LOG,'3 before call to procedure jai_cmn_rgm_recording_pkg.insert_reference ');

1002: /****
1003: ||insert the invoices and credit memo's into the jai_rgm_trx_refs
1004: ||using the procedure jai_cmn_rgm_recording_pkg.insert_reference
1005: *****/
1006: fnd_file.put_line(fnd_file.LOG,'3 before call to procedure jai_cmn_rgm_recording_pkg.insert_reference ');
1007:
1008: savepoint before_ref_inv_cm;
1009:
1010: ln_external_flag := null; --Added by zhiwei.xin for bug 13777022 on 24-Feb-2012

Line 1029: fnd_file.put_line( fnd_file.log, '3.5 continue next line process for line 1)from OpenAPi and 2)External and 3)GL date >= POT date should not populate repo ');

1025: and is_accrual_basis(rec_c_fetch_inv_cm_rec.customer_trx_line_id)
1026: THEN
1027:
1028: --ROLLBACK to before_ref_inv_cm; comment out by zhiwei.xin for bug 13535100 on 07-Feb-2012
1029: fnd_file.put_line( fnd_file.log, '3.5 continue next line process for line 1)from OpenAPi and 2)External and 3)GL date >= POT date should not populate repo ');
1030: --END IF; comment out by zhiwei.xin for bug 13535100 on 07-Feb-2012
1031: ------------------------------------------------------------------------------
1032: --Added by zhiwei for POT change Bug#13023443 on 20110929 end
1033:

Line 1068: fnd_file.put_line(fnd_file.LOG,'4 returned from procedure jai_cmn_rgm_recording_pkg.insert_reference, lv_process_flag - '||lv_process_flag

1064: p_process_flag => lv_process_flag ,
1065: p_process_message => lv_process_message
1066: );
1067:
1068: fnd_file.put_line(fnd_file.LOG,'4 returned from procedure jai_cmn_rgm_recording_pkg.insert_reference, lv_process_flag - '||lv_process_flag
1069: ||'lv_process_message - '||lv_process_message);
1070:
1071:
1072: IF lv_process_flag = jai_constants.expected_error OR

Line 1081: fnd_file.put_line( fnd_file.log, '5 error in call to jai_cmn_rgm_recording_pkg.insert_reference - lv_process_flag '||lv_process_flag

1077: ||1. Rollback to save point
1078: ||2. Set out variables p_process_flag and p_process_message accordingly
1079: */
1080: ROLLBACK to before_ref_inv_cm;
1081: fnd_file.put_line( fnd_file.log, '5 error in call to jai_cmn_rgm_recording_pkg.insert_reference - lv_process_flag '||lv_process_flag
1082: ||', lv_process_message'||lv_process_message);
1083: p_process_flag := lv_process_flag ;
1084: p_process_message := lv_process_message ;
1085: END IF;

Line 1088: fnd_file.put_line(fnd_file.LOG,'6 inserted record in jai_rgm_trx_refs with reference_id '||ln_reference_id );

1084: p_process_message := lv_process_message ;
1085: END IF;
1086:
1087: ln_invoices_processed := ln_invoices_processed + 1;
1088: fnd_file.put_line(fnd_file.LOG,'6 inserted record in jai_rgm_trx_refs with reference_id '||ln_reference_id );
1089:
1090: END IF; -- added by zhiwei.xin for bug 13535100 on 07-Feb-2012
1091: end if;--Added by qiong.liu for bug 16001407
1092:

Line 1095: fnd_file.put_line(fnd_file.LOG,'5 End of procedure : jai_rgm_process_ar.populate_inv_cm_references, number of invoices/CM processed '||ln_invoices_processed );

1091: end if;--Added by qiong.liu for bug 16001407
1092:
1093: END LOOP;
1094:
1095: fnd_file.put_line(fnd_file.LOG,'5 End of procedure : jai_rgm_process_ar.populate_inv_cm_references, number of invoices/CM processed '||ln_invoices_processed );
1096:
1097: --Added by Wenqiong begin
1098: FOR rec_c_fetch_receipt_rec IN c_fetch_receipt_rec
1099: LOOP

Line 1101: fnd_file.put_line(fnd_file.LOG,'2.1 processing record, cash_receipt_id '||rec_c_fetch_receipt_rec.cash_receipt_id

1097: --Added by Wenqiong begin
1098: FOR rec_c_fetch_receipt_rec IN c_fetch_receipt_rec
1099: LOOP
1100:
1101: fnd_file.put_line(fnd_file.LOG,'2.1 processing record, cash_receipt_id '||rec_c_fetch_receipt_rec.cash_receipt_id
1102: ||', tax_id '|| rec_c_fetch_receipt_rec.tax_id
1103: ||', tax rate '||rec_c_fetch_receipt_rec.tax_rate
1104: ||', transactional tax amount '||rec_c_fetch_receipt_rec.tax_amount
1105: ||', currency '||rec_c_fetch_receipt_rec.currency_code

Line 1114: fnd_file.put_line(fnd_file.LOG,'2.2 before call to procedure jai_cmn_rgm_recording_pkg.insert_reference ');

1110: /****
1111: ||insert the receipts into the jai_rgm_trx_refs
1112: ||using the procedure jai_cmn_rgm_recording_pkg.insert_reference
1113: *****/
1114: fnd_file.put_line(fnd_file.LOG,'2.2 before call to procedure jai_cmn_rgm_recording_pkg.insert_reference ');
1115: savepoint before_ref_receipt;
1116: jai_cmn_rgm_recording_pkg.insert_reference (
1117: p_reference_id => ln_reference_id ,
1118: p_organization_id => p_organization_id ,

Line 1151: fnd_file.put_line(fnd_file.LOG,'2.3 returned from procedure jai_cmn_rgm_recording_pkg.insert_reference, lv_process_flag - '||lv_process_flag

1147: p_process_flag => lv_process_flag ,
1148: p_process_message => lv_process_message
1149: );
1150:
1151: fnd_file.put_line(fnd_file.LOG,'2.3 returned from procedure jai_cmn_rgm_recording_pkg.insert_reference, lv_process_flag - '||lv_process_flag
1152: ||'lv_process_message - '||lv_process_message);
1153:
1154:
1155: IF lv_process_flag = jai_constants.expected_error OR

Line 1164: fnd_file.put_line( fnd_file.log, '2.4 error in call to jai_cmn_rgm_recording_pkg.insert_reference - lv_process_flag '||lv_process_flag

1160: ||1. Rollback to save point
1161: ||2. Set out variables p_process_flag and p_process_message accordingly
1162: */
1163: ROLLBACK to before_ref_receipt;
1164: fnd_file.put_line( fnd_file.log, '2.4 error in call to jai_cmn_rgm_recording_pkg.insert_reference - lv_process_flag '||lv_process_flag
1165: ||', lv_process_message'||lv_process_message);
1166: p_process_flag := lv_process_flag ;
1167: p_process_message := lv_process_message ;
1168: END IF;

Line 1171: fnd_file.put_line(fnd_file.LOG,'2.5 inserted record in jai_rgm_trx_refs with reference_id '||ln_reference_id );

1167: p_process_message := lv_process_message ;
1168: END IF;
1169:
1170: ln_receipts_processed := ln_receipts_processed + 1;
1171: fnd_file.put_line(fnd_file.LOG,'2.5 inserted record in jai_rgm_trx_refs with reference_id '||ln_reference_id );
1172: END LOOP;
1173: --Added by Wenqiong End
1174: EXCEPTION
1175: WHEN OTHERS THEN

Line 1303: fnd_file.put_line(fnd_file.LOG,'delete_non_existant_cm p_org_id:'||p_org_id );

1299:
1300: p_process_flag := lv_process_flag ;
1301: p_process_message := lv_process_message ;
1302:
1303: fnd_file.put_line(fnd_file.LOG,'delete_non_existant_cm p_org_id:'||p_org_id );
1304: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );
1305:
1306: /*
1307: || Source type would indicate CREDIT MEMO REVERSAL

Line 1304: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );

1300: p_process_flag := lv_process_flag ;
1301: p_process_message := lv_process_message ;
1302:
1303: fnd_file.put_line(fnd_file.LOG,'delete_non_existant_cm p_org_id:'||p_org_id );
1304: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );
1305:
1306: /*
1307: || Source type would indicate CREDIT MEMO REVERSAL
1308: */

Line 1327: fnd_file.put_line(fnd_file.LOG,' ********************1 PROCESSING REC_C_GET_INCOMPLETED_CM.CM_CUSTOMER_TRX_ID -> '||rec_c_get_incompleted_cm.cm_customer_trx_id

1323:
1324: /*########################################################################################################
1325: || SET SAVE POINT POINT FOR EACH CM_CUSTOMER_TRX_ID RECORD
1326: ########################################################################################################*/
1327: fnd_file.put_line(fnd_file.LOG,' ********************1 PROCESSING REC_C_GET_INCOMPLETED_CM.CM_CUSTOMER_TRX_ID -> '||rec_c_get_incompleted_cm.cm_customer_trx_id
1328: ||' ******************** ');
1329:
1330:
1331: /*

Line 1358: fnd_file.put_line(fnd_file.LOG,' 3 Passing CM-CM-REV record, for the CM-CM-APP with rec_c_get_cm_cm_app_rec.cm_customer_trx_id -> '||rec_c_get_cm_cm_app_rec.trx_reference2 --Bo Li for Bug9305067 change attribute2 to trx_reference2

1354:
1355: /*
1356: || Insert a record into the repository corresponding to the 'CM-CM-REV'
1357: */
1358: fnd_file.put_line(fnd_file.LOG,' 3 Passing CM-CM-REV record, for the CM-CM-APP with rec_c_get_cm_cm_app_rec.cm_customer_trx_id -> '||rec_c_get_cm_cm_app_rec.trx_reference2 --Bo Li for Bug9305067 change attribute2 to trx_reference2
1359: ||' and reference_id -> '||rec_c_get_cm_cm_app_rec.reference_id
1360: ||',repository_id -> '|| rec_c_get_cm_cm_app_rec.repository_id);
1361:
1362:

Line 1366: fnd_file.put_line(fnd_file.LOG,' 3.1 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry original amount -> '||nvl(rec_c_get_cm_cm_app_rec.debit_amount,rec_c_get_cm_cm_app_rec.credit_amount)

1362:
1363:
1364: ln_amount := nvl(rec_c_get_cm_cm_app_rec.debit_amount,rec_c_get_cm_cm_app_rec.credit_amount) * (-1);
1365:
1366: fnd_file.put_line(fnd_file.LOG,' 3.1 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry original amount -> '||nvl(rec_c_get_cm_cm_app_rec.debit_amount,rec_c_get_cm_cm_app_rec.credit_amount)
1367: ||', reversal entry amount -> '||ln_amount );
1368:
1369: /*csahoo for bug#5879769...start*/
1370:

Line 1386: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

1382: p_process_message => lv_process_message
1383: );
1384:
1385: IF lv_process_flag <> jai_constants.successful THEN
1386: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
1387: return;
1388: END IF;
1389:
1390: /*csahoo for bug#5879769...end*/

Line 1435: fnd_file.put_line(fnd_file.LOG,' 4 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );

1431: ---------------------------------------------------------------------------------
1432: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
1433: );
1434:
1435: fnd_file.put_line(fnd_file.LOG,' 4 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1436:
1437:
1438: IF lv_process_flag = jai_constants.expected_error OR
1439: lv_process_flag = jai_constants.unexpected_error

Line 1450: fnd_file.put_line( fnd_file.log, '5 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - lv_process_flag '||lv_process_flag

1446: ||4. Exit from the loop
1447: */
1448: ln_err_cm_customer_trx_id := rec_c_get_incompleted_cm.cm_customer_trx_id;
1449: ROLLBACK to roll_to_last_cm;
1450: fnd_file.put_line( fnd_file.log, '5 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - lv_process_flag '||lv_process_flag
1451: ||', lv_process_message'||lv_process_message ||'cm_customer_trx_id - '||ln_err_cm_customer_trx_id);
1452: p_process_flag := lv_process_flag ;
1453: p_process_message := lv_process_message ;
1454: EXIT;

Line 1467: fnd_file.put_line(fnd_file.LOG,' 6 before call to jai_cmn_rgm_recording_pkg.update_reference for updating CM reference to 0-> '||rec_c_get_incompleted_cm.cm_customer_trx_id

1463: || Update the Credit Reference and set Recovered Amount to 0 as this credit memo has been incompleted
1464: ########################################################################################################*/
1465: FOR rec_cur_upd_cm_ref IN cur_upd_cm_ref (cp_cm_customer_trx_id => rec_c_get_incompleted_cm.cm_customer_trx_id)
1466: LOOP
1467: fnd_file.put_line(fnd_file.LOG,' 6 before call to jai_cmn_rgm_recording_pkg.update_reference for updating CM reference to 0-> '||rec_c_get_incompleted_cm.cm_customer_trx_id
1468: ||', reference_id -> '||rec_cur_upd_cm_ref.reference_id );
1469:
1470: jai_cmn_rgm_recording_pkg.update_reference (
1471: p_source => p_source ,

Line 1486: fnd_file.put_line( fnd_file.log, '7 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag

1482: || Set out variables p_process_flag and p_process_message accordingly
1483: */
1484: ln_err_cm_customer_trx_id := rec_c_get_incompleted_cm.cm_customer_trx_id;
1485: ROLLBACK to roll_to_last_cm;
1486: fnd_file.put_line( fnd_file.log, '7 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag
1487: ||', lv_process_message'||lv_process_message);
1488: p_process_flag := lv_process_flag ;
1489: p_process_message := lv_process_message ;
1490: END IF;

Line 1492: fnd_file.put_line(fnd_file.LOG,' 8 Returned from jai_cmn_rgm_recording_pkg.update_reference after updating CM reference' );

1488: p_process_flag := lv_process_flag ;
1489: p_process_message := lv_process_message ;
1490: END IF;
1491:
1492: fnd_file.put_line(fnd_file.LOG,' 8 Returned from jai_cmn_rgm_recording_pkg.update_reference after updating CM reference' );
1493: END LOOP;
1494:
1495: END IF; /* End if of ln_err_cm_customer_trx_id <> rec_c_get_incompleted_cm.cm_customer_trx_id*/
1496:

Line 1510: fnd_file.put_line(fnd_file.LOG,' 9 Passing CM-INV-REV record, for the CM-INV-APP with rec_c_get_cm_inv_app_rec.inv_customer_trx_id -> '||rec_c_get_cm_inv_app_rec.attribute1

1506: --, cp_attribute_context => 'CM-INV-APP'
1507: )
1508: LOOP
1509:
1510: fnd_file.put_line(fnd_file.LOG,' 9 Passing CM-INV-REV record, for the CM-INV-APP with rec_c_get_cm_inv_app_rec.inv_customer_trx_id -> '||rec_c_get_cm_inv_app_rec.attribute1
1511: ||', rec_c_get_cm_inv_app_rec.cm_customer_trx_id -> '||rec_c_get_cm_inv_app_rec.attribute2
1512: ||' reference_id -> '||rec_c_get_cm_inv_app_rec.reference_id
1513: ||', repository_id -> '|| rec_c_get_cm_inv_app_rec.repository_id);
1514:

Line 1518: fnd_file.put_line(fnd_file.LOG,' 9.1 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );

1514:
1515: /*
1516: || Insert a record into the repository corresponding to the 'CM-CM-REV'
1517: */
1518: fnd_file.put_line(fnd_file.LOG,' 9.1 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1519:
1520: ln_amount := nvl(rec_c_get_cm_inv_app_rec.debit_amount,rec_c_get_cm_inv_app_rec.credit_amount) * (-1);
1521:
1522: fnd_file.put_line(fnd_file.LOG,' 10 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry original amount -> '||nvl(rec_c_get_cm_inv_app_rec.debit_amount,rec_c_get_cm_inv_app_rec.credit_amount)

Line 1522: fnd_file.put_line(fnd_file.LOG,' 10 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry original amount -> '||nvl(rec_c_get_cm_inv_app_rec.debit_amount,rec_c_get_cm_inv_app_rec.credit_amount)

1518: fnd_file.put_line(fnd_file.LOG,' 9.1 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1519:
1520: ln_amount := nvl(rec_c_get_cm_inv_app_rec.debit_amount,rec_c_get_cm_inv_app_rec.credit_amount) * (-1);
1521:
1522: fnd_file.put_line(fnd_file.LOG,' 10 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry original amount -> '||nvl(rec_c_get_cm_inv_app_rec.debit_amount,rec_c_get_cm_inv_app_rec.credit_amount)
1523: ||', reversal entry amount -> '||ln_amount );
1524:
1525: /*csahoo for bug#5879769...start*/
1526:

Line 1542: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

1538: p_process_message => lv_process_message
1539: );
1540:
1541: IF lv_process_flag <> jai_constants.successful THEN
1542: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
1543: return;
1544: END IF;
1545:
1546: /*csahoo for bug#5879769...end*/

Line 1601: fnd_file.put_line(fnd_file.LOG,' 10.1 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );

1597: ---------------------------------------------------------------------------
1598: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
1599: );
1600:
1601: fnd_file.put_line(fnd_file.LOG,' 10.1 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1602:
1603:
1604: IF lv_process_flag = jai_constants.expected_error OR
1605: lv_process_flag = jai_constants.unexpected_error

Line 1614: fnd_file.put_line( fnd_file.log, '11 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - lv_process_flag '||lv_process_flag

1610: ||2. Set out variables p_process_flag and p_process_message accordingly
1611: */
1612: ln_err_cm_customer_trx_id := rec_c_get_incompleted_cm.cm_customer_trx_id;
1613: ROLLBACK to roll_to_last_cm;
1614: fnd_file.put_line( fnd_file.log, '11 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - lv_process_flag '||lv_process_flag
1615: ||', lv_process_message'||lv_process_message);
1616: p_process_flag := lv_process_flag ;
1617: p_process_message := lv_process_message ;
1618: EXIT;

Line 1626: fnd_file.put_line(fnd_file.LOG,' 12 before call to jai_cmn_rgm_recording_pkg.update_reference for updating INV reference_id - '||rec_c_get_cm_inv_app_rec.reference_id

1622: /*########################################################################################################
1623: || Update the Recovered Amount of the Invoice Reference against the CM application
1624: ########################################################################################################*/
1625:
1626: fnd_file.put_line(fnd_file.LOG,' 12 before call to jai_cmn_rgm_recording_pkg.update_reference for updating INV reference_id - '||rec_c_get_cm_inv_app_rec.reference_id
1627: ||', amount to be adjusted from recovered_Amount -> '||nvl(rec_c_get_cm_inv_app_rec.debit_amount,rec_c_get_cm_inv_app_rec.credit_amount) * (-1)
1628: );
1629:
1630:

Line 1647: fnd_file.put_line( fnd_file.log, '13 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag

1643: || Set out variables p_process_flag and p_process_message accordingly
1644: */
1645: ln_err_cm_customer_trx_id := rec_c_get_incompleted_cm.cm_customer_trx_id;
1646: ROLLBACK to roll_to_last_cm;
1647: fnd_file.put_line( fnd_file.log, '13 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag
1648: ||', lv_process_message'||lv_process_message);
1649: p_process_flag := lv_process_flag ;
1650: p_process_message := lv_process_message ;
1651: EXIT;

Line 1654: fnd_file.put_line(fnd_file.LOG,' 14 Returned from jai_cmn_rgm_recording_pkg.update_reference after updating invoice reference' );

1650: p_process_message := lv_process_message ;
1651: EXIT;
1652: END IF;
1653:
1654: fnd_file.put_line(fnd_file.LOG,' 14 Returned from jai_cmn_rgm_recording_pkg.update_reference after updating invoice reference' );
1655:
1656: END LOOP; /* End of 'CM-INV-APP record processing for an CM application against an invoice' */
1657:
1658: END IF; /* End if of ln_err_cm_customer_trx_id <> rec_c_get_incompleted_cm.cm_customer_trx_id*/

Line 1665: fnd_file.put_line(fnd_file.LOG,' 15 END of one CM processing ');

1661: || Reset the savepoint to the previous cm_customer_trx_id
1662: ln_set_save_point := rec_c_get_incompleted_cm.cm_customer_trx_id;
1663: */
1664: END IF;--Add by Xiao for POT change, reg bug#12533434 on 16-May-2011
1665: fnd_file.put_line(fnd_file.LOG,' 15 ******************** END of one CM processing ******************** ');
1666: END LOOP; /* End of CM reference processing */
1667:
1668:
1669: /* Added by Ramananda for bug#4407165 */

Line 1942: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_rgm_process_ar.populate_cm_app' );

1938: invoice_id = cp_cm_customer_trx_id ;
1939:
1940: BEGIN
1941:
1942: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_rgm_process_ar.populate_cm_app' );
1943: fnd_file.put_line(fnd_file.LOG,'p_org_id:'||p_org_id );
1944: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );
1945:
1946: p_process_flag := jai_constants.successful ;

Line 1943: fnd_file.put_line(fnd_file.LOG,'p_org_id:'||p_org_id );

1939:
1940: BEGIN
1941:
1942: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_rgm_process_ar.populate_cm_app' );
1943: fnd_file.put_line(fnd_file.LOG,'p_org_id:'||p_org_id );
1944: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );
1945:
1946: p_process_flag := jai_constants.successful ;
1947: p_process_message := null ;

Line 1944: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );

1940: BEGIN
1941:
1942: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_rgm_process_ar.populate_cm_app' );
1943: fnd_file.put_line(fnd_file.LOG,'p_org_id:'||p_org_id );
1944: fnd_file.put_line(fnd_file.LOG,'p_organization_id:'||p_organization_id );
1945:
1946: p_process_flag := jai_constants.successful ;
1947: p_process_message := null ;
1948:

Line 1958: fnd_file.put_line(fnd_file.LOG,'2 processing credit memo with receivable_application_id as '||rec_c_get_cm_rec_app.receivable_application_id

1954: --lv_type:= 'INV'; --commented by Xiao for bug#6773751
1955: FOR rec_c_get_cm_rec_app IN c_get_cm_rec_app ( cp_source_ar => p_source )
1956: LOOP
1957:
1958: fnd_file.put_line(fnd_file.LOG,'2 processing credit memo with receivable_application_id as '||rec_c_get_cm_rec_app.receivable_application_id
1959: ||'against invoice with customer_trx_id '||rec_c_get_cm_rec_app.inv_customer_trx_id );
1960:
1961: /*########################################################################################################
1962: || INITIALIZING THE VARIABLES

Line 1979: fnd_file.put_line(fnd_file.LOG,'3 Variables initialized' );

1975: lv_process_message := null ;
1976:
1977: ln_inclusive_total_amt := null ; --added by walton for inclusive tax 29-Nov-07
1978:
1979: fnd_file.put_line(fnd_file.LOG,'3 Variables initialized' );
1980:
1981: /*########################################################################################################
1982: || SET A SAVEPOINT FOR EACH NEW CREDIT MEMO RECEIVABLE APPLICATION
1983: ########################################################################################################*/

Line 2031: fnd_file.put_line(fnd_file.LOG,'5 start of determine application source type');

2027: ln_total_tax_applied := rec_c_get_cm_rec_app.cm_app_tax_amt + (rec_c_get_cm_rec_app.cm_app_line_amt/ln_tmp_line_total_amt) * ln_inclusive_total_amt;
2028: /*Bug 9919612 - End*/
2029: ------------------------------------------------------------------------------------------------------
2030:
2031: fnd_file.put_line(fnd_file.LOG,'5 start of determine application source type');
2032:
2033: /*
2034: || If the CM tax amount is +ve then it is CREDIT MEMO REVERSAL/UNAPPLICATION
2035: || IF the CM tax receipt amount is -ve then it is CREDIT MEMO APPLICATION

Line 2055: fnd_file.put_line(fnd_file.LOG,'7 credit memo type is lv_source_trx_type-> '||lv_source_trx_type);

2051: lv_source_trx_type := jai_constants.trx_type_cm_app ;
2052:
2053: END IF;
2054:
2055: fnd_file.put_line(fnd_file.LOG,'7 credit memo type is lv_source_trx_type-> '||lv_source_trx_type);
2056:
2057:
2058: IF ln_sign_of_credit_memo <> 0 THEN
2059: /*########################################################################################################

Line 2073: fnd_file.put_line(fnd_file.LOG,'4 start of invoice reference tax line, rec_c_get_refinvrec_for_upd.reference_id -> '|| rec_c_get_refinvrec_for_upd.reference_id );

2069: IF NOT is_accrual_basis(rec_c_get_refinvrec_for_upd.line_id) THEN
2070: ----------------------------------------------------------------------------------------------
2071: --Add by Xiao for POT change, reg bug#12533434 on 16-May-2011, end
2072:
2073: fnd_file.put_line(fnd_file.LOG,'4 start of invoice reference tax line, rec_c_get_refinvrec_for_upd.reference_id -> '|| rec_c_get_refinvrec_for_upd.reference_id );
2074:
2075:
2076: /*########################################################################################################
2077: || Calculation of the Service Tax Component of Credit Memo Tax Amount which needs to be considered

Line 2080: fnd_file.put_line(fnd_file.LOG,'8 Start of Credit Memo Service Tax Component calculation');

2076: /*########################################################################################################
2077: || Calculation of the Service Tax Component of Credit Memo Tax Amount which needs to be considered
2078: ########################################################################################################*/
2079:
2080: fnd_file.put_line(fnd_file.LOG,'8 Start of Credit Memo Service Tax Component calculation');
2081:
2082: ln_eff_cm_tax_amount := (abs(ln_total_tax_applied)/ln_inv_tot_tax_amt) * rec_c_get_refinvrec_for_upd.recoverable_amount; --modified by walton for inclusive tax 29-Nov-07
2083:
2084: fnd_file.put_line(fnd_file.LOG,'9 rec_c_get_cm_rec_app.cm_app_tax_amt effective -> '||rec_c_get_cm_rec_app.cm_app_tax_amt

Line 2084: fnd_file.put_line(fnd_file.LOG,'9 rec_c_get_cm_rec_app.cm_app_tax_amt effective -> '||rec_c_get_cm_rec_app.cm_app_tax_amt

2080: fnd_file.put_line(fnd_file.LOG,'8 Start of Credit Memo Service Tax Component calculation');
2081:
2082: ln_eff_cm_tax_amount := (abs(ln_total_tax_applied)/ln_inv_tot_tax_amt) * rec_c_get_refinvrec_for_upd.recoverable_amount; --modified by walton for inclusive tax 29-Nov-07
2083:
2084: fnd_file.put_line(fnd_file.LOG,'9 rec_c_get_cm_rec_app.cm_app_tax_amt effective -> '||rec_c_get_cm_rec_app.cm_app_tax_amt
2085: ||', ln_inv_tot_tax_amt -> '||ln_inv_tot_tax_amt
2086: ||', rec_c_get_refinvrec_for_upd.recoverable_amount -> '||rec_c_get_refinvrec_for_upd.recoverable_amount
2087: ||', cash receipt tax amount is ln_eff_cm_tax_amount -> '||ln_eff_cm_tax_amount
2088: ||', rec_c_get_refinvrec_for_upd.recovered_amount -> '||rec_c_get_refinvrec_for_upd.recovered_amount);

Line 2103: fnd_file.put_line(fnd_file.LOG,'10 rec_c_get_refinvrec_for_upd.recovered_amount + ln_eff_cm_tax_amount -> rec_c_get_refinvrec_for_upd.recoverable_amount hence ln_eff_cm_tax_amount '||ln_eff_cm_tax_amount);

2099: || IF yes then set Credit Memo amount = recoverable amount - recovered amount
2100: || so that the recovered amount never exceeds the recoverable amount
2101: */
2102: ln_eff_cm_tax_amount := (rec_c_get_refinvrec_for_upd.recoverable_amount - rec_c_get_refinvrec_for_upd.recovered_amount) ;
2103: fnd_file.put_line(fnd_file.LOG,'10 rec_c_get_refinvrec_for_upd.recovered_amount + ln_eff_cm_tax_amount -> rec_c_get_refinvrec_for_upd.recoverable_amount hence ln_eff_cm_tax_amount '||ln_eff_cm_tax_amount);
2104: END IF;
2105:
2106:
2107: /*########################################################################################################

Line 2131: fnd_file.put_line(fnd_file.LOG,' 13 rec_c_get_cm_rec_app.invoice_currency_code ' || rec_c_get_cm_rec_app.invoice_currency_code ||

2127: ln_trx_amount := (ln_amount / nvl(rec_c_get_cm_rec_app.cm_exchange_rate,1)) ;
2128: ELSE
2129: ln_trx_amount := ln_amount;
2130: END IF;
2131: fnd_file.put_line(fnd_file.LOG,' 13 rec_c_get_cm_rec_app.invoice_currency_code ' || rec_c_get_cm_rec_app.invoice_currency_code ||
2132: ' rec_c_get_cm_rec_app.cm_currency_code ' || rec_c_get_cm_rec_app.cm_currency_code ||
2133: ' ln_trx_amount ' || ln_trx_amount ||
2134: ' ln_amount ' || ln_amount ||
2135: ' rec_c_get_cm_rec_app.invoice_exchange_rate ' || rec_c_get_cm_rec_app.invoice_exchange_rate ||

Line 2137: fnd_file.put_line(fnd_file.LOG,' 14 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );

2133: ' ln_trx_amount ' || ln_trx_amount ||
2134: ' ln_amount ' || ln_amount ||
2135: ' rec_c_get_cm_rec_app.invoice_exchange_rate ' || rec_c_get_cm_rec_app.invoice_exchange_rate ||
2136: ' rec_c_get_cm_rec_app.cm_exchange_rate ' || rec_c_get_cm_rec_app.cm_exchange_rate );
2137: fnd_file.put_line(fnd_file.LOG,' 14 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2138:
2139: /*csahoo for bug#5879769...start*/
2140:
2141: ln_organization_id := NULL;

Line 2156: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

2152: p_process_message => lv_process_message
2153: );
2154:
2155: IF lv_process_flag <> jai_constants.successful THEN
2156: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
2157: return;
2158: END IF;
2159:
2160: /*csahoo for bug#5879769...end*/

Line 2213: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );

2209: -----------------------------------------------------------------------------
2210: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
2211: );
2212:
2213: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2214:
2215:
2216: IF lv_process_flag = jai_constants.expected_error OR
2217: lv_process_flag = jai_constants.unexpected_error

Line 2226: fnd_file.put_line( fnd_file.log, '16 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - lv_process_flag '||lv_process_flag

2222: ||2. Set out variables p_process_flag and p_process_message accordingly
2223: */
2224: ln_receivable_application_id := rec_c_get_cm_rec_app.receivable_application_id ;
2225: ROLLBACK to roll_to_cm_app;
2226: fnd_file.put_line( fnd_file.log, '16 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - lv_process_flag '||lv_process_flag
2227: ||', lv_process_message'||lv_process_message);
2228: p_process_flag := lv_process_flag ;
2229: p_process_message := lv_process_message ;
2230: EXIT;

Line 2238: fnd_file.put_line(fnd_file.LOG,' 11 before call to jai_cmn_rgm_recording_pkg.update_reference for updating invoice reference' );

2234: /*########################################################################################################
2235: || Update the Invoice Reference Recovered Amount with the effective Credit Memo tax amount
2236: ########################################################################################################*/
2237:
2238: fnd_file.put_line(fnd_file.LOG,' 11 before call to jai_cmn_rgm_recording_pkg.update_reference for updating invoice reference' );
2239:
2240: jai_cmn_rgm_recording_pkg.update_reference (
2241: p_source => p_source ,
2242: p_reference_id => rec_c_get_refinvrec_for_upd.reference_id ,

Line 2258: fnd_file.put_line( fnd_file.log, '12 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag

2254: ln_receivable_application_id := rec_c_get_cm_rec_app.receivable_application_id ;
2255: ROLLBACK to roll_to_cm_app;
2256: p_process_flag := lv_process_flag ;
2257: p_process_message := lv_process_message ;
2258: fnd_file.put_line( fnd_file.log, '12 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag
2259: ||', lv_process_message'||lv_process_message);
2260:
2261: EXIT;
2262: END IF;

Line 2265: fnd_file.put_line(fnd_file.LOG,' 13 Returned from jai_cmn_rgm_recording_pkg.update_reference after updating invoice reference' );

2261: EXIT;
2262: END IF;
2263:
2264:
2265: fnd_file.put_line(fnd_file.LOG,' 13 Returned from jai_cmn_rgm_recording_pkg.update_reference after updating invoice reference' );
2266:
2267: /*
2268: || Get the sum of the effective cm tax amount applied across all the reference invoice lines
2269: */

Line 2272: fnd_file.put_line( fnd_file.log, '17 value of ln_eff_cm_tottax_amt is - '||ln_eff_cm_tottax_amt );

2268: || Get the sum of the effective cm tax amount applied across all the reference invoice lines
2269: */
2270: ln_eff_cm_tottax_amt := nvl(abs(ln_eff_cm_tottax_amt),0) + abs(ln_eff_cm_tax_amount);
2271:
2272: fnd_file.put_line( fnd_file.log, '17 value of ln_eff_cm_tottax_amt is - '||ln_eff_cm_tottax_amt );
2273: END IF; --Add by Xiao for POT change, reg bug#12533434 on 16-May-2011
2274: END LOOP; -- End of Invoice Reference line processing
2275:
2276:

Line 2298: fnd_file.put_line(fnd_file.LOG,'18 Total Effective CM recoverable amount ln_tot_effcm_rb_amt - ' || ln_tot_effcm_rb_amt

2294: || Get the ratio in which the CM needs to be apportioned
2295: */
2296: ln_cm_ref_ratio := abs(ln_eff_cm_tottax_amt)/abs(ln_tot_effcm_rb_amt);
2297:
2298: fnd_file.put_line(fnd_file.LOG,'18 Total Effective CM recoverable amount ln_tot_effcm_rb_amt - ' || ln_tot_effcm_rb_amt
2299: ||', actual total cm apportioned amoungst ln_eff_cm_tottax_amt - '|| ln_eff_cm_tottax_amt
2300: ||', cm eff ratio ln_cm_ref_ratio - '||ln_cm_ref_ratio
2301: );
2302:

Line 2322: fnd_file.put_line(fnd_file.LOG,'19 Processing Credit memo reference tax line, rec_c_get_refcmrec_for_upd.reference_id -> '|| rec_c_get_refcmrec_for_upd.reference_id );

2318: || Initialize the variable ln_cm_ref_upd
2319: */
2320: ln_cm_ref_upd := null;
2321:
2322: fnd_file.put_line(fnd_file.LOG,'19 Processing Credit memo reference tax line, rec_c_get_refcmrec_for_upd.reference_id -> '|| rec_c_get_refcmrec_for_upd.reference_id );
2323:
2324: /*
2325: || Calculate the value of ln_cm_ref_upd
2326: */

Line 2353: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

2349: p_process_message => lv_process_message
2350: );
2351:
2352: IF lv_process_flag <> jai_constants.successful THEN
2353: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
2354: return;
2355: END IF;
2356:
2357: /*csahoo for bug#5879769...end*/

Line 2359: fnd_file.put_line(fnd_file.LOG,' 23 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );

2355: END IF;
2356:
2357: /*csahoo for bug#5879769...end*/
2358:
2359: fnd_file.put_line(fnd_file.LOG,' 23 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2360: lv_attribute_context := 'CM-CM-APP';--rchandan for bug#4428980
2361: /*Bug 10623735 - Multiply by Exchange Rate only if Invoice is not in INR*/
2362: IF (rec_c_get_cm_rec_app.invoice_currency_code <> 'INR'
2363: and rec_c_get_cm_rec_app.cm_currency_code = 'INR') THEN

Line 2371: fnd_file.put_line(fnd_file.LOG,' rec_c_get_cm_rec_app.invoice_currency_code ' || rec_c_get_cm_rec_app.invoice_currency_code ||

2367: ln_trx_amount := (ln_cm_ref_upd / nvl(rec_c_get_cm_rec_app.cm_exchange_rate,1)) ;
2368: ELSE
2369: ln_trx_amount := ln_cm_ref_upd;
2370: END IF;
2371: fnd_file.put_line(fnd_file.LOG,' rec_c_get_cm_rec_app.invoice_currency_code ' || rec_c_get_cm_rec_app.invoice_currency_code ||
2372: ' rec_c_get_cm_rec_app.cm_currency_code ' || rec_c_get_cm_rec_app.cm_currency_code ||
2373: ' ln_trx_amount ' || ln_trx_amount ||
2374: ' ln_cm_ref_upd ' || ln_cm_ref_upd ||
2375: ' rec_c_get_cm_rec_app.invoice_exchange_rate ' || rec_c_get_cm_rec_app.invoice_exchange_rate ||

Line 2389: fnd_file.put_line(fnd_file.LOG,'ln_total_tax_amt '|| ln_total_tax_amt ||' rec_c_get_cm_rec_app.cm_exchange_rate '|| rec_c_get_cm_rec_app.cm_exchange_rate ||

2385: ELSE
2386: ln_exc_gain_loss_amt := 0;
2387: END IF;
2388:
2389: fnd_file.put_line(fnd_file.LOG,'ln_total_tax_amt '|| ln_total_tax_amt ||' rec_c_get_cm_rec_app.cm_exchange_rate '|| rec_c_get_cm_rec_app.cm_exchange_rate ||
2390: ' rec_c_get_cm_rec_app.invoice_exchange_rate '|| rec_c_get_cm_rec_app.invoice_exchange_rate ||
2391: ' ln_exc_gain_loss_amt '|| ln_exc_gain_loss_amt || ' ln_cm_ref_upd '|| ln_cm_ref_upd ||
2392: ' ln_discounted_amount ' ||ln_discounted_amount);
2393:

Line 2437: fnd_file.put_line(fnd_file.LOG,' 24 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );

2433: -------------------------------------------------------------------------------
2434: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
2435: );
2436:
2437: fnd_file.put_line(fnd_file.LOG,' 24 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2438:
2439:
2440: IF lv_process_flag = jai_constants.expected_error OR
2441: lv_process_flag = jai_constants.unexpected_error

Line 2449: fnd_file.put_line( fnd_file.log, '25 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - lv_process_flag '||lv_process_flag

2445: ||1. Rollback to save point
2446: ||2. Set out variables p_process_flag and p_process_message accordingly
2447: */
2448: ROLLBACK to roll_to_cm_app;
2449: fnd_file.put_line( fnd_file.log, '25 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - 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: EXIT;

Line 2489: fnd_file.put_line( fnd_file.log, '16.1 error in call to jai_rgm_trx_recording_pkg.exc_gain_loss_accounting - lv_process_flag '||lv_process_flag

2485: ln_receivable_application_id := rec_c_get_cm_rec_app.receivable_application_id;
2486: ROLLBACK to roll_to_last_receivable;
2487: p_process_flag := lv_process_flag ;
2488: p_process_message := lv_process_message ;
2489: fnd_file.put_line( fnd_file.log, '16.1 error in call to jai_rgm_trx_recording_pkg.exc_gain_loss_accounting - lv_process_flag '||lv_process_flag
2490: ||', lv_process_message'||lv_process_message);
2491: EXIT;
2492: END IF;
2493: END IF;

Line 2496: fnd_file.put_line(fnd_file.LOG,' 20 before call to jai_cmn_rgm_recording_pkg.update_reference for credit memo references '

2492: END IF;
2493: END IF;
2494: -- Added for Bug 8294236 - End
2495:
2496: fnd_file.put_line(fnd_file.LOG,' 20 before call to jai_cmn_rgm_recording_pkg.update_reference for credit memo references '
2497: ||' ,abs(rec_c_get_refcmrec_for_upd.recoverable_amount) -> '||abs(rec_c_get_refcmrec_for_upd.recoverable_amount)
2498: ||' ,recovered amount i.e ln_cm_ref_upd -> '||ln_cm_ref_upd
2499: );
2500:

Line 2512: fnd_file.put_line(fnd_file.LOG,' 21 Returned from jai_cmn_rgm_recording_pkg.update_reference for credit memo references' );

2508: p_recovered_amount => ln_cm_ref_upd ,
2509: p_process_flag => lv_process_flag ,
2510: p_process_message => lv_process_message
2511: );
2512: fnd_file.put_line(fnd_file.LOG,' 21 Returned from jai_cmn_rgm_recording_pkg.update_reference for credit memo references' );
2513:
2514: IF lv_process_flag = jai_constants.expected_error OR
2515: lv_process_flag = jai_constants.unexpected_error
2516: THEN

Line 2523: fnd_file.put_line( fnd_file.log, '22 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag

2519: ||1. Rollback to save point
2520: ||2. Set out variables p_process_flag and p_process_message accordingly
2521: */
2522: ROLLBACK to roll_to_cm_app;
2523: fnd_file.put_line( fnd_file.log, '22 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag
2524: ||', lv_process_message'||lv_process_message);
2525: p_process_flag := lv_process_flag ;
2526: p_process_message := lv_process_message ;
2527: EXIT;

Line 2536: fnd_file.put_line(fnd_file.LOG,' 26 Finished processing the receivable' );

2532:
2533: END IF; /* End if of sign of credit memo*/
2534:
2535: ln_uncommitted_transactions := ln_uncommitted_transactions + 1;
2536: fnd_file.put_line(fnd_file.LOG,' 26 Finished processing the receivable' );
2537:
2538: IF ln_uncommitted_transactions >= 500 THEN
2539: commit;
2540: ln_uncommitted_transactions := 0;

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 2829: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_rgm_process_ar.populate_receipt_records' );

2825:
2826:
2827: BEGIN
2828:
2829: fnd_file.put_line(fnd_file.LOG,'1 Entering procedure : jai_rgm_process_ar.populate_receipt_records' );
2830:
2831: /*
2832: ||Initialize the variables
2833: */

Line 2844: fnd_file.put_line(fnd_file.LOG,'2 processing cash receipt with receivable_application_id as '||rec_c_get_rec_app.receivable_application_id

2840: *****/
2841: FOR rec_c_get_rec_app IN c_get_rec_app ( cp_source_ar => p_source )
2842: LOOP
2843:
2844: fnd_file.put_line(fnd_file.LOG,'2 processing cash receipt with receivable_application_id as '||rec_c_get_rec_app.receivable_application_id
2845: ||'against invoice with customer_trx_id '||rec_c_get_rec_app.customer_trx_id );
2846:
2847: /*########################################################################################################
2848: || Initializing the variables

Line 2861: fnd_file.put_line(fnd_file.LOG,'3 Variables initialized' );

2857: lv_process_message := null ;
2858:
2859: ln_inclusive_total_amt := null ; --added by walton for inclusive tax 29-Nov-07
2860:
2861: fnd_file.put_line(fnd_file.LOG,'3 Variables initialized' );
2862:
2863: SAVEPOINT roll_to_last_receivable;
2864:
2865: /*Bug 11932841 - Passes NULL to LINE_ID parameters to get the total amount for the transaction - Start*/

Line 2949: fnd_file.put_line(fnd_file.LOG,'3.1 rec_c_get_rec_app.customer_trx_id: '|| rec_c_get_rec_app.customer_trx_id || ' '

2945: END IF;
2946: ln_cash_rcpt_line_amt := (ln_line_total_amt/ln_line_amt) * rec_c_get_rec_app.cash_rcpt_line_amt;
2947: ln_cash_rcpt_tax_amt := (ln_inv_tot_tax_amt/ln_inv_tax_amt) * rec_c_get_rec_app.cash_rcpt_tax_amt;
2948: ln_cr_tax_disc_amt := (ln_inv_tot_tax_amt/ln_inv_tax_amt) * rec_c_get_rec_app.cr_tax_disc_amt;
2949: fnd_file.put_line(fnd_file.LOG,'3.1 rec_c_get_rec_app.customer_trx_id: '|| rec_c_get_rec_app.customer_trx_id || ' '
2950: || ' rec_c_get_refrec_for_upd.item_line_id: ' || rec_c_get_refrec_for_upd.item_line_id);
2951: fnd_file.put_line(fnd_file.LOG,'3.2 ln_line_total_amt: '|| ln_line_total_amt || ' ' || ' ln_inv_tot_tax_amt: ' || ln_inv_tot_tax_amt
2952: || ' ' || 'ln_line_amt: ' || ln_line_amt || ' ' || 'ln_inv_tax_amt: ' || ln_inv_tax_amt);
2953: fnd_file.put_line(fnd_file.LOG,'3.3 ln_cash_rcpt_line_amt: '|| ln_cash_rcpt_line_amt || ' ' || ' ln_cash_rcpt_tax_amt: ' || ln_cash_rcpt_tax_amt

Line 2951: fnd_file.put_line(fnd_file.LOG,'3.2 ln_line_total_amt: '|| ln_line_total_amt || ' ' || ' ln_inv_tot_tax_amt: ' || ln_inv_tot_tax_amt

2947: ln_cash_rcpt_tax_amt := (ln_inv_tot_tax_amt/ln_inv_tax_amt) * rec_c_get_rec_app.cash_rcpt_tax_amt;
2948: ln_cr_tax_disc_amt := (ln_inv_tot_tax_amt/ln_inv_tax_amt) * rec_c_get_rec_app.cr_tax_disc_amt;
2949: fnd_file.put_line(fnd_file.LOG,'3.1 rec_c_get_rec_app.customer_trx_id: '|| rec_c_get_rec_app.customer_trx_id || ' '
2950: || ' rec_c_get_refrec_for_upd.item_line_id: ' || rec_c_get_refrec_for_upd.item_line_id);
2951: fnd_file.put_line(fnd_file.LOG,'3.2 ln_line_total_amt: '|| ln_line_total_amt || ' ' || ' ln_inv_tot_tax_amt: ' || ln_inv_tot_tax_amt
2952: || ' ' || 'ln_line_amt: ' || ln_line_amt || ' ' || 'ln_inv_tax_amt: ' || ln_inv_tax_amt);
2953: fnd_file.put_line(fnd_file.LOG,'3.3 ln_cash_rcpt_line_amt: '|| ln_cash_rcpt_line_amt || ' ' || ' ln_cash_rcpt_tax_amt: ' || ln_cash_rcpt_tax_amt
2954: || ' ' || 'Inclusive amt: ' || (rec_c_get_rec_app.cash_rcpt_line_amt/ln_line_amt) * ln_inclusive_total_amt);
2955: ln_total_tax_applied := ln_cash_rcpt_tax_amt + ((rec_c_get_rec_app.cash_rcpt_line_amt/ln_line_amt) * ln_inclusive_total_amt);

Line 2953: fnd_file.put_line(fnd_file.LOG,'3.3 ln_cash_rcpt_line_amt: '|| ln_cash_rcpt_line_amt || ' ' || ' ln_cash_rcpt_tax_amt: ' || ln_cash_rcpt_tax_amt

2949: fnd_file.put_line(fnd_file.LOG,'3.1 rec_c_get_rec_app.customer_trx_id: '|| rec_c_get_rec_app.customer_trx_id || ' '
2950: || ' rec_c_get_refrec_for_upd.item_line_id: ' || rec_c_get_refrec_for_upd.item_line_id);
2951: fnd_file.put_line(fnd_file.LOG,'3.2 ln_line_total_amt: '|| ln_line_total_amt || ' ' || ' ln_inv_tot_tax_amt: ' || ln_inv_tot_tax_amt
2952: || ' ' || 'ln_line_amt: ' || ln_line_amt || ' ' || 'ln_inv_tax_amt: ' || ln_inv_tax_amt);
2953: fnd_file.put_line(fnd_file.LOG,'3.3 ln_cash_rcpt_line_amt: '|| ln_cash_rcpt_line_amt || ' ' || ' ln_cash_rcpt_tax_amt: ' || ln_cash_rcpt_tax_amt
2954: || ' ' || 'Inclusive amt: ' || (rec_c_get_rec_app.cash_rcpt_line_amt/ln_line_amt) * ln_inclusive_total_amt);
2955: ln_total_tax_applied := ln_cash_rcpt_tax_amt + ((rec_c_get_rec_app.cash_rcpt_line_amt/ln_line_amt) * ln_inclusive_total_amt);
2956: /*Bug 11932841 - End*/
2957: fnd_file.put_line(fnd_file.LOG,'4 start of invoice reference tax line , rec_c_get_refrec_for_upd.reference_id -> '|| rec_c_get_refrec_for_upd.reference_id );

Line 2957: fnd_file.put_line(fnd_file.LOG,'4 start of invoice reference tax line , rec_c_get_refrec_for_upd.reference_id -> '|| rec_c_get_refrec_for_upd.reference_id );

2953: fnd_file.put_line(fnd_file.LOG,'3.3 ln_cash_rcpt_line_amt: '|| ln_cash_rcpt_line_amt || ' ' || ' ln_cash_rcpt_tax_amt: ' || ln_cash_rcpt_tax_amt
2954: || ' ' || 'Inclusive amt: ' || (rec_c_get_rec_app.cash_rcpt_line_amt/ln_line_amt) * ln_inclusive_total_amt);
2955: ln_total_tax_applied := ln_cash_rcpt_tax_amt + ((rec_c_get_rec_app.cash_rcpt_line_amt/ln_line_amt) * ln_inclusive_total_amt);
2956: /*Bug 11932841 - End*/
2957: fnd_file.put_line(fnd_file.LOG,'4 start of invoice reference tax line , rec_c_get_refrec_for_upd.reference_id -> '|| rec_c_get_refrec_for_upd.reference_id );
2958: lv_attribute_context := NULL;
2959: /*########################################################################################################
2960: || Determine the receipt Application Type (Receipt Application, Receipt Reversal)
2961: ########################################################################################################*/

Line 2962: fnd_file.put_line(fnd_file.LOG,'5 start of determine application source type');

2958: lv_attribute_context := NULL;
2959: /*########################################################################################################
2960: || Determine the receipt Application Type (Receipt Application, Receipt Reversal)
2961: ########################################################################################################*/
2962: fnd_file.put_line(fnd_file.LOG,'5 start of determine application source type');
2963:
2964: /*
2965: || If the cash receipt tax amount is -ve then it is RECEIPT REVERSAL/UNAPPLICATION
2966: || IF the cash receipt tax receipt amount is +ve then it is RECEIPT APPLICATION

Line 3005: fnd_file.put_line(fnd_file.LOG,'6 cash receipt has sign = 0 i.e tax applied amount = 0 hence exit ');

3001: ELSE
3002: /*
3003: || cash receipt amount is zero hence exit current loop and process next receipt application
3004: */
3005: fnd_file.put_line(fnd_file.LOG,'6 cash receipt has sign = 0 i.e tax applied amount = 0 hence exit ');
3006: exit;
3007: END IF;
3008:
3009: fnd_file.put_line(fnd_file.LOG,'7 cash receipt is lv_source_trx_type->'||lv_source_trx_type);

Line 3009: fnd_file.put_line(fnd_file.LOG,'7 cash receipt is lv_source_trx_type->'||lv_source_trx_type);

3005: fnd_file.put_line(fnd_file.LOG,'6 cash receipt has sign = 0 i.e tax applied amount = 0 hence exit ');
3006: exit;
3007: END IF;
3008:
3009: fnd_file.put_line(fnd_file.LOG,'7 cash receipt is lv_source_trx_type->'||lv_source_trx_type);
3010:
3011: /*########################################################################################################
3012: || Calculation of the Service Tax Component of Cash Receipt Tax Amount which needs to be considered
3013: ########################################################################################################*/

Line 3015: fnd_file.put_line(fnd_file.LOG,'8 Start of Cash Receipt Service Tax Component calculation, ln_inv_tot_tax_amt'||ln_inv_tot_tax_amt);

3011: /*########################################################################################################
3012: || Calculation of the Service Tax Component of Cash Receipt Tax Amount which needs to be considered
3013: ########################################################################################################*/
3014:
3015: fnd_file.put_line(fnd_file.LOG,'8 Start of Cash Receipt Service Tax Component calculation, ln_inv_tot_tax_amt'||ln_inv_tot_tax_amt);
3016:
3017: /*Bug 10148245 - Start*/
3018:
3019: OPEN c_chk_apply_in_detail(rec_c_get_rec_app.cash_receipt_id, rec_c_get_rec_app.receivable_application_id);

Line 3033: fnd_file.put_line(fnd_file.LOG,'8.1 Total Invoice Amount for Line ' || ln_link_to_cust_trx_id || ' is ln_inv_tot_tax_amt '||ln_inv_tot_tax_amt);

3029: OPEN c_tot_tax_amount(ln_link_to_cust_trx_id);
3030: FETCH c_tot_tax_amount INTO ln_inv_tot_tax_amt;
3031: CLOSE c_tot_tax_amount;
3032:
3033: fnd_file.put_line(fnd_file.LOG,'8.1 Total Invoice Amount for Line ' || ln_link_to_cust_trx_id || ' is ln_inv_tot_tax_amt '||ln_inv_tot_tax_amt);
3034:
3035: OPEN c_receipt_tax_amount(ln_link_to_cust_trx_id, rec_c_get_rec_app.cash_receipt_id, rec_c_get_rec_app.receivable_application_id);
3036: FETCH c_receipt_tax_amount INTO ln_receipt_tax_amt, ln_rcpt_tax_disc_amt;
3037: CLOSE c_receipt_tax_amount;

Line 3039: fnd_file.put_line(fnd_file.LOG,'8.2 Tax Amount applied ' || ln_receipt_tax_amt || ' Tax Discount Applied '|| ln_rcpt_tax_disc_amt);

3035: OPEN c_receipt_tax_amount(ln_link_to_cust_trx_id, rec_c_get_rec_app.cash_receipt_id, rec_c_get_rec_app.receivable_application_id);
3036: FETCH c_receipt_tax_amount INTO ln_receipt_tax_amt, ln_rcpt_tax_disc_amt;
3037: CLOSE c_receipt_tax_amount;
3038:
3039: fnd_file.put_line(fnd_file.LOG,'8.2 Tax Amount applied ' || ln_receipt_tax_amt || ' Tax Discount Applied '|| ln_rcpt_tax_disc_amt);
3040:
3041: /*Bug 11932841 - If Exclusive Tax amount is zero, then set lv_inv_tot_tax_amt to 1 to avoid Divisor by Zero error in further calculations*/
3042: IF ln_inv_tot_tax_amt = 0 THEN
3043: ln_inv_tot_tax_amt := 1;

Line 3081: fnd_file.put_line(fnd_file.LOG,'10 rec_c_get_refrec_for_upd.recovered_amount + ln_eff_cr_tax_amount < 0 , ln_eff_cr_tax_amount '||ln_eff_cr_tax_amount);

3077: || so that the net recovered amount equals zero.
3078: */
3079: ln_eff_cr_tax_amount := rec_c_get_refrec_for_upd.recovered_amount * rec_c_get_rec_app.sign_of_cash_receipt;
3080:
3081: fnd_file.put_line(fnd_file.LOG,'10 rec_c_get_refrec_for_upd.recovered_amount + ln_eff_cr_tax_amount < 0 , ln_eff_cr_tax_amount '||ln_eff_cr_tax_amount);
3082:
3083:
3084: ELSIF rec_c_get_refrec_for_upd.recovered_amount + ln_eff_cr_tax_amount > rec_c_get_refrec_for_upd.recoverable_amount THEN
3085: /*

Line 3092: fnd_file.put_line(fnd_file.LOG,'11 rec_c_get_refrec_for_upd.recovered_amount + ln_eff_cr_tax_amount > rec_c_get_refrec_for_upd.recoverable_amount hence ln_eff_cr_tax_amount '||ln_eff_cr_tax_amount);

3088: || IF yes then set cash receipt amount = recoverable amount - recovered amount
3089: || so that the recovered amount never exceeds the recoverable amount
3090: */
3091: ln_eff_cr_tax_amount := rec_c_get_refrec_for_upd.recoverable_amount - rec_c_get_refrec_for_upd.recovered_amount ;
3092: fnd_file.put_line(fnd_file.LOG,'11 rec_c_get_refrec_for_upd.recovered_amount + ln_eff_cr_tax_amount > rec_c_get_refrec_for_upd.recoverable_amount hence ln_eff_cr_tax_amount '||ln_eff_cr_tax_amount);
3093: END IF;
3094: ELSE --(rec_c_get_refrec_for_upd.resersal_flag = 'Y')
3095: /*Bug 11787045 - If Credit Memo application on a Receipt is reversed, then ln_eff_cr_tax_amount needs to be a positive tax amount
3096: Hence the below calculation must be done only in case of CM application on a Receipt or reversal of Invoice application*/

Line 3099: fnd_file.put_line(fnd_file.LOG,'10" Credit Memo entries : ln_eff_cr_tax_amount := rec_c_get_refrec_for_upd.recoverable_amount - rec_c_get_refrec_for_upd.recovered_amount ' || ln_eff_cr_tax_amount );

3095: /*Bug 11787045 - If Credit Memo application on a Receipt is reversed, then ln_eff_cr_tax_amount needs to be a positive tax amount
3096: Hence the below calculation must be done only in case of CM application on a Receipt or reversal of Invoice application*/
3097: -- IF ln_eff_cr_tax_amount < 0 THEN Rolling back the changes done for Bug 11787045 by mmurtuza
3098: ln_eff_cr_tax_amount := rec_c_get_refrec_for_upd.recoverable_amount - rec_c_get_refrec_for_upd.recovered_amount ;
3099: fnd_file.put_line(fnd_file.LOG,'10" Credit Memo entries : ln_eff_cr_tax_amount := rec_c_get_refrec_for_upd.recoverable_amount - rec_c_get_refrec_for_upd.recovered_amount ' || ln_eff_cr_tax_amount );
3100: --END IF; Rolling back the changes done for Bug 11787045 by mmurtuza
3101: END IF; --NVL(rec_c_get_refrec_for_upd.REVERSAL_FLAG,'N') = 'N'
3102:
3103: ---------------------------------------------------------------------------------

Line 3118: fnd_file.put_line(fnd_file.LOG,'9 ln_cr_tax_disc_amt ->'||ln_cr_tax_disc_amt

3114: ln_eff_cr_disc_amount := (ln_cr_tax_disc_amt/ln_inv_tot_tax_amt) * rec_c_get_refrec_for_upd.recoverable_amount ;
3115: END IF;
3116: /*Bug 10148245 - End*/
3117:
3118: fnd_file.put_line(fnd_file.LOG,'9 ln_cr_tax_disc_amt ->'||ln_cr_tax_disc_amt
3119: ||', ln_inv_tot_tax_amt ->'||ln_inv_tot_tax_amt
3120: ||', rec_c_get_refrec_for_upd.recoverable_amount ->'||rec_c_get_refrec_for_upd.recoverable_amount
3121: ||', cash receipt tax amount is ln_eff_cr_tax_amount ->'||ln_eff_cr_tax_amount
3122: ||', rec_c_get_refrec_for_upd.recovered_amount ->'||rec_c_get_refrec_for_upd.recovered_amount);

Line 3138: fnd_file.put_line(fnd_file.LOG,'10 effective recovered amount > effective recoverable amount hence, ln_eff_cr_disc_amount '||ln_eff_cr_disc_amount);

3134: || Keeping this condition in mind , the discounted amount should get adjusted
3135: */
3136: ln_eff_cr_disc_amount := nvl(rec_c_get_refrec_for_upd.recoverable_amount,0) - (nvl(rec_c_get_refrec_for_upd.recovered_amount,0) + nvl(ln_eff_cr_tax_amount,0) );
3137:
3138: fnd_file.put_line(fnd_file.LOG,'10 effective recovered amount > effective recoverable amount hence, ln_eff_cr_disc_amount '||ln_eff_cr_disc_amount);
3139:
3140: ELSIF rec_c_get_refrec_for_upd.discounted_amount + ln_eff_cr_disc_amount < 0 THEN
3141: /*
3142: || -ve discounted amount

Line 3147: fnd_file.put_line(fnd_file.LOG,'10 rec_c_get_refrec_for_upd.discounted_amount + ln_eff_cr_disc_amount < 0 , ln_eff_cr_tax_amount '||ln_eff_cr_tax_amount);

3143: || The total discounted amount cannot be lesser than 0
3144: */
3145: ln_eff_cr_disc_amount := rec_c_get_refrec_for_upd.discounted_amount * rec_c_get_rec_app.sign_of_cr_disc;
3146:
3147: fnd_file.put_line(fnd_file.LOG,'10 rec_c_get_refrec_for_upd.discounted_amount + ln_eff_cr_disc_amount < 0 , ln_eff_cr_tax_amount '||ln_eff_cr_tax_amount);
3148:
3149: END IF;
3150: END IF; --NVL(rec_c_get_refrec_for_upd.REVERSAL_FLAG,'N') = 'N'
3151:

Line 3179: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

3175: p_process_message => lv_process_message
3176: );
3177:
3178: IF lv_process_flag <> jai_constants.successful THEN
3179: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
3180: return;
3181: END IF;
3182:
3183: /*csahoo for bug#5879769...end*/

Line 3186: fnd_file.put_line(fnd_file.LOG,' 14 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );

3182:
3183: /*csahoo for bug#5879769...end*/
3184:
3185:
3186: fnd_file.put_line(fnd_file.LOG,' 14 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
3187: /*Bug 10623735
3188: If Invoice and Receipt currency are different, data in AR_RECEIVABLE_APPLICATIONS_ALL is populated
3189: in Invoice Currency. Hence the same cannot be passed as Transaction Amount in JAI_RGM_TRX_RECORDS
3190: Transaction Amount Data in JAI_RGM_TRX_RECORDS must be in Receipt Currency for Receipt Application Event.

Line 3203: fnd_file.put_line(fnd_file.LOG,' rec_c_get_rec_app.invoice_currency_code ' || rec_c_get_rec_app.invoice_currency_code ||

3199: ln_trx_amount := (ln_eff_cr_tax_amount / nvl(rec_c_get_rec_app.receipt_exchange_rate,1)) ;
3200: ELSE
3201: ln_trx_amount := ln_eff_cr_tax_amount;
3202: END IF;
3203: fnd_file.put_line(fnd_file.LOG,' rec_c_get_rec_app.invoice_currency_code ' || rec_c_get_rec_app.invoice_currency_code ||
3204: ' rec_c_get_rec_app.receipt_currency_code ' || rec_c_get_rec_app.receipt_currency_code ||
3205: ' ln_trx_amount ' || ln_trx_amount ||
3206: ' ln_eff_cr_tax_amount ' || ln_eff_cr_tax_amount ||
3207: ' rec_c_get_rec_app.invoice_exchange_rate ' || rec_c_get_rec_app.invoice_exchange_rate ||

Line 3268: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );

3264: ----------------------------------------------------------------------------
3265: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
3266: );
3267:
3268: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
3269:
3270:
3271: IF lv_process_flag = jai_constants.expected_error OR
3272: lv_process_flag = jai_constants.unexpected_error

Line 3283: fnd_file.put_line( fnd_file.log, '16 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - lv_process_flag '||lv_process_flag

3279: ln_receivable_application_id := rec_c_get_rec_app.receivable_application_id;
3280: ROLLBACK to roll_to_last_receivable;
3281: p_process_flag := lv_process_flag ;
3282: p_process_message := lv_process_message ;
3283: fnd_file.put_line( fnd_file.log, '16 error in call to jai_cmn_rgm_recording_pkg.insert_repository_entry - lv_process_flag '||lv_process_flag
3284: ||', lv_process_message'||lv_process_message);
3285: EXIT;
3286: END IF;
3287:

Line 3320: fnd_file.put_line( fnd_file.log, '16.1 error in call to jai_rgm_trx_recording_pkg.exc_gain_loss_accounting - lv_process_flag '||lv_process_flag

3316: ln_receivable_application_id := rec_c_get_rec_app.receivable_application_id;
3317: ROLLBACK to roll_to_last_receivable;
3318: p_process_flag := lv_process_flag ;
3319: p_process_message := lv_process_message ;
3320: fnd_file.put_line( fnd_file.log, '16.1 error in call to jai_rgm_trx_recording_pkg.exc_gain_loss_accounting - lv_process_flag '||lv_process_flag
3321: ||', lv_process_message'||lv_process_message);
3322: EXIT;
3323: END IF;
3324: END IF;

Line 3331: fnd_file.put_line(fnd_file.LOG,' 12 before call to jai_cmn_rgm_recording_pkg.update_reference ' );

3327: /*########################################################################################################
3328: || update the effective cash receipt tax amount into the reference table
3329: ########################################################################################################*/
3330:
3331: fnd_file.put_line(fnd_file.LOG,' 12 before call to jai_cmn_rgm_recording_pkg.update_reference ' );
3332:
3333: savepoint before_ref_upd;
3334: jai_cmn_rgm_recording_pkg.update_reference (
3335: p_source => p_source ,

Line 3355: fnd_file.put_line( fnd_file.log, '12.1 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag

3351: ln_receivable_application_id := rec_c_get_rec_app.receivable_application_id;
3352: ROLLBACK to roll_to_last_receivable;
3353: p_process_flag := lv_process_flag ;
3354: p_process_message := lv_process_message ;
3355: fnd_file.put_line( fnd_file.log, '12.1 error in call to jai_cmn_rgm_recording_pkg.update_reference - lv_process_flag '||lv_process_flag
3356: ||', lv_process_message'||lv_process_message);
3357:
3358: EXIT;
3359: END IF;

Line 3361: fnd_file.put_line(fnd_file.LOG,' 13 Returned from jai_cmn_rgm_recording_pkg.update_reference ' );

3357:
3358: EXIT;
3359: END IF;
3360: END IF;--Add by Xiao for POT change, reg bug#12533434 on 16-May-2011
3361: fnd_file.put_line(fnd_file.LOG,' 13 Returned from jai_cmn_rgm_recording_pkg.update_reference ' );
3362:
3363: END LOOP;
3364:
3365: ln_uncommitted_transactions := ln_uncommitted_transactions + 1;

Line 3366: fnd_file.put_line(fnd_file.LOG,' 17 Finished processing the cash receipt ' );

3362:
3363: END LOOP;
3364:
3365: ln_uncommitted_transactions := ln_uncommitted_transactions + 1;
3366: fnd_file.put_line(fnd_file.LOG,' 17 Finished processing the cash receipt ' );
3367:
3368: IF ln_uncommitted_transactions >= 50 THEN
3369: commit;
3370: ln_uncommitted_transactions := 0;

Line 3900: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

3896: p_process_message => lv_process_message
3897: );
3898:
3899: IF lv_process_flag <> jai_constants.successful THEN
3900: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
3901: return;
3902: END IF; */
3903: ----------------------------------------------------------------------------------------------
3904: --Commented by zhiwei for POT 12925963 on 20110908 end

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 4008: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

4004: p_process_flag => lv_process_flag,
4005: p_process_message => lv_process_message);
4006:
4007: IF lv_process_flag <> jai_constants.successful THEN
4008: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
4009: RETURN;
4010: END IF;
4011:
4012: ln_tax_amount := round(ln_reversal_amount * rec_reversal_entries.tax_amt/ln_total_rec_amt,

Line 4053: fnd_file.put_line( fnd_file.log,

4049: p_accrual_basis => 'Y');
4050:
4051: IF lv_process_flag = jai_constants.expected_error OR
4052: lv_process_flag = jai_constants.unexpected_error THEN
4053: fnd_file.put_line( fnd_file.log,
4054: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
4055: ||', lv_process_message'||lv_process_message);
4056: p_process_flag := lv_process_flag;
4057: p_process_message := lv_process_message;

Line 4093: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

4089: p_process_flag => lv_process_flag,
4090: p_process_message => lv_process_message);
4091:
4092: IF lv_process_flag <> jai_constants.successful THEN
4093: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
4094: RETURN;
4095: END IF;
4096:
4097: ld_accounting_date := rec_claim_line.gl_date;

Line 4139: fnd_file.put_line( fnd_file.log,

4135: p_accrual_basis => 'Y');
4136:
4137: IF lv_process_flag = jai_constants.expected_error OR
4138: lv_process_flag = jai_constants.unexpected_error THEN
4139: fnd_file.put_line( fnd_file.log,
4140: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
4141: ||', lv_process_message'||lv_process_message);
4142: p_process_flag := lv_process_flag;
4143: p_process_message := lv_process_message;

Line 4181: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

4177: p_process_flag => lv_process_flag,
4178: p_process_message => lv_process_message);
4179:
4180: IF lv_process_flag <> jai_constants.successful THEN
4181: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
4182: RETURN;
4183: END IF;
4184:
4185: ln_tax_amount := lr_ar_ref_records.TAX_AMOUNT;

Line 4226: fnd_file.put_line( fnd_file.log,

4222: p_accrual_basis => 'Y');
4223:
4224: IF lv_process_flag = jai_constants.expected_error OR
4225: lv_process_flag = jai_constants.unexpected_error THEN
4226: fnd_file.put_line( fnd_file.log,
4227: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
4228: ||', lv_process_message'||lv_process_message);
4229: p_process_flag := lv_process_flag;
4230: p_process_message := lv_process_message;

Line 4273: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

4269: p_process_flag => lv_process_flag,
4270: p_process_message => lv_process_message);
4271:
4272: IF lv_process_flag <> jai_constants.successful THEN
4273: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
4274: RETURN;
4275: END IF;
4276:
4277:

Line 4318: fnd_file.put_line( fnd_file.log,

4314: p_accrual_basis => 'Y');
4315:
4316: IF lv_process_flag = jai_constants.expected_error OR
4317: lv_process_flag = jai_constants.unexpected_error THEN
4318: fnd_file.put_line( fnd_file.log,
4319: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
4320: ||', lv_process_message'||lv_process_message);
4321: p_process_flag := lv_process_flag;
4322: p_process_message := lv_process_message;

Line 4380: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

4376: p_process_flag => lv_process_flag,
4377: p_process_message => lv_process_message);
4378:
4379: IF lv_process_flag <> jai_constants.successful THEN
4380: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
4381: RETURN;
4382: END IF;
4383:
4384:

Line 4423: fnd_file.put_line( fnd_file.log,

4419: p_accrual_basis => 'Y');
4420:
4421: IF lv_process_flag = jai_constants.expected_error OR
4422: lv_process_flag = jai_constants.unexpected_error THEN
4423: fnd_file.put_line( fnd_file.log,
4424: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
4425: ||', lv_process_message'||lv_process_message);
4426: p_process_flag := lv_process_flag;
4427: p_process_message := lv_process_message;

Line 4487: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);

4483: p_process_flag => lv_process_flag,
4484: p_process_message => lv_process_message);
4485:
4486: IF lv_process_flag <> jai_constants.successful THEN
4487: FND_FILE.put_line(fnd_file.log, 'Error Flag:'||lv_process_flag||' Error Message:'||lv_process_message);
4488: RETURN;
4489: END IF;
4490:
4491:

Line 4530: fnd_file.put_line( fnd_file.log,

4526: p_accrual_basis => 'Y');
4527:
4528: IF lv_process_flag = jai_constants.expected_error OR
4529: lv_process_flag = jai_constants.unexpected_error THEN
4530: fnd_file.put_line( fnd_file.log,
4531: '5.1 ERROR IN CALL TO jai_cmn_rgm_processing_pkg.populate_repository - lv_process_flag '||lv_process_flag
4532: ||', lv_process_message'||lv_process_message);
4533: p_process_flag := lv_process_flag;
4534: p_process_message := lv_process_message;

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 4684: fnd_file.put_line( fnd_file.log, '1.1 From and To Date parameters for Service Tax Processing cannot be less than Effective Date for

4680: /* --This is commented by Xiao for POT changes, reg bug#12533434 on 10-May-2011,
4681: --as ST processor should process for both Accrual/Cash basis.
4682:
4683: IF ld_st_accrual_date > p_from_date OR ld_st_accrual_date > p_to_date THEN
4684: fnd_file.put_line( fnd_file.log, '1.1 From and To Date parameters for Service Tax Processing cannot be less than Effective Date for
4685: Service Tax Point of Taxation in Regime Registration - lv_process_flag '|| jai_constants.unexpected_error
4686: ||', lv_process_message Verify Date Parameters');
4687: p_process_flag := jai_constants.unexpected_error ;
4688: p_process_message := 'Verify Date Parameters' ;

Line 4691: fnd_file.put_line(fnd_file.LOG,'2 i/p is p_regime_id ->'||p_regime_id

4687: p_process_flag := jai_constants.unexpected_error ;
4688: p_process_message := 'Verify Date Parameters' ;
4689: END IF;*/
4690: /*Bug 11821537 - End*/
4691: fnd_file.put_line(fnd_file.LOG,'2 i/p is p_regime_id ->'||p_regime_id
4692: ||', p_regime_id ->'||p_regime_id
4693: ||', p_organization_type ->'||p_organization_type
4694: ||', p_from_date ->'||p_from_date
4695: ||', p_to_date ->'||p_to_date

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;