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_CMN_RGM_RECORDING_PKG

Line 275: 115.1 4193633 jai_cmn_rgm_recording_pkg 115.1 Aiyer 23-Feb-2005 Functional dependency due to spec change.

271: jai_rgm_process_ar_taxes_pkg_b.sql
272: ----------------------------------------------------------------------------------------------------------------------------------------------------
273: 115.0 4146634 IN60105D2 + Aiyer 27-Jan-2005 4146708 is the release bug
274: 4146708 for SERVICE/CESS enhancement release
275: 115.1 4193633 jai_cmn_rgm_recording_pkg 115.1 Aiyer 23-Feb-2005 Functional dependency due to spec change.
276:
277: ----------------------------------------------------------------------------------------------------------------------------------------------------
278:
279:

Line 558: Called From : jai_cmn_rgm_recording_pkg.insert_reference

554: Created Date : 27-jan-2005
555: Enhancement Bug : 4146634
556: Purpose : Gte the tax earned and Unearned discounts associated with the Receivable application
557: the jai_rgm_trx_refs and jai_rgms_trx_records appropriately.
558: Called From : jai_cmn_rgm_recording_pkg.insert_reference
559:
560: Change History: -
561: =================
562: 1 20-Feb-2005 aiyer - Bug # 4193633 - File Version# 115.1

Line 1004: ||using the procedure jai_cmn_rgm_recording_pkg.insert_reference

1000:
1001:
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;

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 1036: jai_cmn_rgm_recording_pkg.insert_reference (

1032: --Added by zhiwei for POT change Bug#13023443 on 20110929 end
1033:
1034: ELSE -- added by zhiwei.xin for bug 13535100 on 07-Feb-2012
1035:
1036: jai_cmn_rgm_recording_pkg.insert_reference (
1037: p_reference_id => ln_reference_id ,
1038: p_organization_id => p_organization_id ,/*5879769*/
1039: p_source => p_source ,
1040: p_invoice_id => rec_c_fetch_inv_cm_rec.customer_trx_id ,

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 1112: ||using the procedure jai_cmn_rgm_recording_pkg.insert_reference

1108: );
1109:
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 (

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 1116: jai_cmn_rgm_recording_pkg.insert_reference (

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 ,
1119: p_source => p_source ,
1120: p_invoice_id => rec_c_fetch_receipt_rec.cash_receipt_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 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 1394: jai_cmn_rgm_recording_pkg.insert_repository_entry (

1390: /*csahoo for bug#5879769...end*/
1391:
1392: lv_attribute_context := 'CM-CM-REV'; --rchandan for bug#4428980
1393:
1394: jai_cmn_rgm_recording_pkg.insert_repository_entry (
1395: p_repository_id => ln_repository_id ,
1396: p_regime_id => p_regime_id ,
1397: p_tax_type => rec_c_get_cm_cm_app_rec.tax_type ,
1398: p_organization_type => p_organization_type ,

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 1470: jai_cmn_rgm_recording_pkg.update_reference (

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 ,
1472: p_reference_id => rec_cur_upd_cm_ref.reference_id ,
1473: p_recovered_amount => rec_cur_upd_cm_ref.recovered_amount * (-1) ,
1474: p_process_flag => lv_process_flag ,

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 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 1559: jai_cmn_rgm_recording_pkg.insert_repository_entry (

1555:
1556:
1557: --lv_attribute_context := 'CM-INV-REV'; --rchandan for bug#4428980 -- commented by Xiao for bug#6773751
1558: lv_source_table := 'JAI_RGM_TRX_RECORDS'; --rchandan for bug#4428980
1559: jai_cmn_rgm_recording_pkg.insert_repository_entry (
1560: p_repository_id => ln_repository_id ,
1561: p_regime_id => p_regime_id ,
1562: p_tax_type => rec_c_get_cm_inv_app_rec.tax_type ,
1563: p_organization_type => p_organization_type ,

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 1631: jai_cmn_rgm_recording_pkg.update_reference (

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:
1631: jai_cmn_rgm_recording_pkg.update_reference (
1632: p_source => p_source ,
1633: p_reference_id => rec_c_get_cm_inv_app_rec.reference_id ,
1634: p_recovered_amount => ln_amount ,
1635: p_process_flag => lv_process_flag ,

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 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 2170: jai_cmn_rgm_recording_pkg.insert_repository_entry (

2166: lv_attribute_context := 'CM-DM-APP';
2167: end if;
2168: /*Bug 10623735*/
2169: ln_func_amount := (ln_amount * nvl(rec_c_get_cm_rec_app.invoice_exchange_rate,1)) ;
2170: jai_cmn_rgm_recording_pkg.insert_repository_entry (
2171: p_repository_id => ln_repository_id ,
2172: p_regime_id => p_regime_id ,
2173: p_tax_type => rec_c_get_refinvrec_for_upd.tax_type ,
2174: p_organization_type => p_organization_type ,

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 2240: jai_cmn_rgm_recording_pkg.update_reference (

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 ,
2243: p_recovered_amount => ln_amount ,
2244: p_process_flag => lv_process_flag ,

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 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 2395: jai_cmn_rgm_recording_pkg.insert_repository_entry (

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:
2394: -- Added for Bug 8294236 - End
2395: jai_cmn_rgm_recording_pkg.insert_repository_entry (
2396: p_repository_id => ln_repository_id ,
2397: p_regime_id => p_regime_id ,
2398: p_tax_type => rec_c_get_refcmrec_for_upd.tax_type ,
2399: p_organization_type => p_organization_type ,

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 2459: jai_cmn_rgm_recording_pkg.exc_gain_loss_accounting(

2455:
2456: -- Added for Bug 8294236 - Start
2457: IF nvl(ln_exc_gain_loss_amt,0) <> 0 THEN
2458:
2459: jai_cmn_rgm_recording_pkg.exc_gain_loss_accounting(
2460: p_repository_id => ln_repository_id ,
2461: p_regime_id => p_regime_id ,
2462: p_tax_type => rec_c_get_refcmrec_for_upd.tax_type ,
2463: p_organization_type => p_organization_type ,

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 2505: jai_cmn_rgm_recording_pkg.update_reference (

2501:
2502: /*
2503: || Update the cm reference line with the amount in ln_cm_ref_upd
2504: */
2505: jai_cmn_rgm_recording_pkg.update_reference (
2506: p_source => p_source ,
2507: p_reference_id => rec_c_get_refcmrec_for_upd.reference_id ,
2508: p_recovered_amount => ln_cm_ref_upd ,
2509: p_process_flag => lv_process_flag ,

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 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 3225: jai_cmn_rgm_recording_pkg.insert_repository_entry (

3221: END IF;
3222:
3223: -- Added for Bug 8294236 - End
3224:
3225: jai_cmn_rgm_recording_pkg.insert_repository_entry (
3226: p_repository_id => ln_repository_id ,
3227: p_regime_id => p_regime_id ,
3228: p_tax_type => rec_c_get_refrec_for_upd.tax_type ,
3229: p_organization_type => p_organization_type ,

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 3290: jai_cmn_rgm_recording_pkg.exc_gain_loss_accounting(

3286: END IF;
3287:
3288: -- Added for Bug 8294236 - Start
3289: IF nvl(ln_exc_gain_loss_amt,0) <> 0 THEN
3290: jai_cmn_rgm_recording_pkg.exc_gain_loss_accounting(
3291: p_repository_id => ln_repository_id ,
3292: p_regime_id => p_regime_id ,
3293: p_tax_type => rec_c_get_refrec_for_upd.tax_type ,
3294: p_organization_type => p_organization_type ,

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 3334: jai_cmn_rgm_recording_pkg.update_reference (

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 ,
3336: p_reference_id => rec_c_get_refrec_for_upd.reference_id ,
3337: p_recovered_amount => ln_eff_cr_tax_amount ,
3338: p_discounted_amount => ln_eff_cr_disc_amount ,

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 3917: jai_cmn_rgm_recording_pkg.insert_repository_entry (

3913:
3914:
3915:
3916: /*Check on TRX_REFERENCE_CONTEXT and TRX_REFERENCE1..5 fields*/
3917: jai_cmn_rgm_recording_pkg.insert_repository_entry (
3918: p_repository_id => ln_repository_id ,
3919: p_regime_id => p_regime_id ,
3920: p_tax_type => r_ar_ref_records.tax_type ,
3921: p_organization_type => p_organization_type ,

Line 3962: jai_cmn_rgm_recording_pkg.update_reference (

3958: p_process_flag := lv_process_flag ;
3959: p_process_message := lv_process_message ;
3960: END IF;
3961: --start additions by mmurtuza for bug#12777500
3962: jai_cmn_rgm_recording_pkg.update_reference (
3963: p_source => p_source ,
3964: p_reference_id => r_ar_ref_records.reference_id ,
3965: p_recovered_amount => r_ar_ref_records.trx_tax_amount ,
3966: p_process_flag => lv_process_flag ,

Line 4016: jai_cmn_rgm_recording_pkg.insert_repository_entry(

4012: ln_tax_amount := round(ln_reversal_amount * rec_reversal_entries.tax_amt/ln_total_rec_amt,
4013: jai_constants.service_rgm_rnd_factor);
4014:
4015: IF nvl(ln_tax_amount, 0) > 0 THEN
4016: jai_cmn_rgm_recording_pkg.insert_repository_entry(
4017: p_repository_id => ln_repository_id,
4018: p_regime_id => p_regime_id,
4019: p_tax_type => rec_reversal_entries.tax_type,
4020: p_organization_type => p_organization_type,

Line 4102: jai_cmn_rgm_recording_pkg.insert_repository_entry(

4098: ln_tax_amount := round(rec_claim_line.claim_amt * rec_claim_entries.tax_amt/ln_total_amount,
4099: jai_constants.service_rgm_rnd_factor);
4100:
4101: IF nvl(ln_tax_amount, 0) > 0 THEN
4102: jai_cmn_rgm_recording_pkg.insert_repository_entry(
4103: p_repository_id => ln_repository_id,
4104: p_regime_id => p_regime_id,
4105: p_tax_type => rec_claim_entries.tax_type,
4106: p_organization_type => p_organization_type,

Line 4189: jai_cmn_rgm_recording_pkg.insert_repository_entry(

4185: ln_tax_amount := lr_ar_ref_records.TAX_AMOUNT;
4186: ln_trx_tax_amount := lr_ar_ref_records.TRX_TAX_AMOUNT;
4187:
4188: IF nvl(lr_ar_ref_records.tax_amount, 0) > 0 THEN
4189: jai_cmn_rgm_recording_pkg.insert_repository_entry(
4190: p_repository_id => ln_repository_id,
4191: p_regime_id => p_regime_id,
4192: p_tax_type => rec_receipt_entries.tax_type,
4193: p_organization_type => p_organization_type,

Line 4279: jai_cmn_rgm_recording_pkg.insert_repository_entry(

4275: END IF;
4276:
4277:
4278: IF nvl(lr_ar_ref_records.tax_amount, 0) <> 0 THEN
4279: jai_cmn_rgm_recording_pkg.insert_repository_entry(
4280: p_repository_id => ln_repository_id,
4281: p_regime_id => p_regime_id,
4282: p_tax_type => rec_receipt_entries.tax_type,
4283: p_organization_type => p_organization_type,

Line 4386: jai_cmn_rgm_recording_pkg.insert_repository_entry(

4382: END IF;
4383:
4384:
4385: IF nvl(ln_tax_amount, 0) <> 0 THEN
4386: jai_cmn_rgm_recording_pkg.insert_repository_entry(
4387: p_repository_id => ln_repository_id,
4388: p_regime_id => p_regime_id,
4389: p_tax_type => rec_receipt_entries.tax_type,
4390: p_organization_type => p_organization_type,

Line 4493: jai_cmn_rgm_recording_pkg.insert_repository_entry(

4489: END IF;
4490:
4491:
4492: IF nvl(ln_tax_amount, 0) <> 0 THEN
4493: jai_cmn_rgm_recording_pkg.insert_repository_entry(
4494: p_repository_id => ln_repository_id,
4495: p_regime_id => p_regime_id,
4496: p_tax_type => rec_receipt_entries.tax_type,
4497: p_organization_type => p_organization_type,

Line 5685: || by calling the function jai_cmn_rgm_recording_pkg.get_account

5681:
5682:
5683: /*********************************************************************************************************
5684: || Get the code combination id from the Organization/Regime Registration setup
5685: || by calling the function jai_cmn_rgm_recording_pkg.get_account
5686: *********************************************************************************************************/
5687:
5688: ln_ccid_tax_type := jai_cmn_rgm_recording_pkg.get_account (
5689: p_regime_id => pn_regime_id,

Line 5688: ln_ccid_tax_type := jai_cmn_rgm_recording_pkg.get_account (

5684: || Get the code combination id from the Organization/Regime Registration setup
5685: || by calling the function jai_cmn_rgm_recording_pkg.get_account
5686: *********************************************************************************************************/
5687:
5688: ln_ccid_tax_type := jai_cmn_rgm_recording_pkg.get_account (
5689: p_regime_id => pn_regime_id,
5690: p_organization_type => jai_constants.orgn_type_io,
5691: p_organization_id => pn_organization_id,
5692: p_location_id => pn_location_id,

Line 5698: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account

5694: p_account_name => jai_constants.liability
5695: );
5696: IF ln_ccid_tax_type IS NULL THEN
5697: /**********************************************************************************************************
5698: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
5699: || This is an error condition and the current processing has to be stopped
5700: **********************************************************************************************************/
5701:
5702: p_process_flag := jai_constants.expected_error;

Line 5831: ln_tax_type_ccid := jai_cmn_rgm_recording_pkg.get_account(

5827: lv_tax_type := pv_tax_type;
5828: ln_entered_amt := round(abs(pn_tran_tax_amount), jai_constants.service_rgm_rnd_factor);
5829: ln_accounted_amt := round(abs(pn_func_tax_amount), jai_constants.service_rgm_rnd_factor);
5830:
5831: ln_tax_type_ccid := jai_cmn_rgm_recording_pkg.get_account(
5832: p_regime_id => pn_regime_id,
5833: p_organization_type => jai_constants.orgn_type_io,
5834: p_organization_id => pn_organization_id,
5835: p_location_id => pn_location_id,

Line 5929: jai_cmn_rgm_recording_pkg.post_accounting(

5925: ln_cr_account := ln_tax_type_ccid;
5926: END IF;
5927:
5928: IF nvl(ln_entered_amt, 0) <> 0 THEN
5929: jai_cmn_rgm_recording_pkg.post_accounting(
5930: p_regime_code => jai_constants.service_regime,
5931: p_tax_type => lv_tax_type,
5932: p_organization_type => jai_constants.service_tax_orgn_type,
5933: p_organization_id => pn_organization_id,

Line 5958: jai_cmn_rgm_recording_pkg.post_accounting(

5954: p_attribute1 => lv_attribute1,
5955: p_attribute2 => lv_attribute2
5956: );
5957:
5958: jai_cmn_rgm_recording_pkg.post_accounting(
5959: p_regime_code => jai_constants.service_regime,
5960: p_tax_type => lv_tax_type,
5961: p_organization_type => jai_constants.service_tax_orgn_type,
5962: p_organization_id => pn_organization_id,