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 79: 115.1 4193633 jai_cmn_rgm_recording_pkg 115.1 Aiyer 23-Feb-2005 Functional dependency due to spec change.

75: jai_rgm_process_ar_taxes_pkg_b.sql
76: ----------------------------------------------------------------------------------------------------------------------------------------------------
77: 115.0 4146634 IN60105D2 + Aiyer 27-Jan-2005 4146708 is the release bug
78: 4146708 for SERVICE/CESS enhancement release
79: 115.1 4193633 jai_cmn_rgm_recording_pkg 115.1 Aiyer 23-Feb-2005 Functional dependency due to spec change.
80:
81: ----------------------------------------------------------------------------------------------------------------------------------------------------
82:
83:

Line 256: Called From : jai_cmn_rgm_recording_pkg.insert_reference

252: Created Date : 27-jan-2005
253: Enhancement Bug : 4146634
254: Purpose : Gte the tax earned and Unearned discounts associated with the Receivable application
255: the jai_rgm_trx_refs and jai_rgms_trx_records appropriately.
256: Called From : jai_cmn_rgm_recording_pkg.insert_reference
257:
258: Change History: -
259: =================
260: 1 20-Feb-2005 aiyer - Bug # 4193633 - File Version# 115.1

Line 588: ||using the procedure jai_cmn_rgm_recording_pkg.insert_reference

584: );
585:
586: /****
587: ||insert the invoices and credit memo's into the jai_rgm_trx_refs
588: ||using the procedure jai_cmn_rgm_recording_pkg.insert_reference
589: *****/
590: fnd_file.put_line(fnd_file.LOG,'3 before call to procedure jai_cmn_rgm_recording_pkg.insert_reference ');
591:
592: savepoint before_ref_inv_cm;

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

586: /****
587: ||insert the invoices and credit memo's into the jai_rgm_trx_refs
588: ||using the procedure jai_cmn_rgm_recording_pkg.insert_reference
589: *****/
590: fnd_file.put_line(fnd_file.LOG,'3 before call to procedure jai_cmn_rgm_recording_pkg.insert_reference ');
591:
592: savepoint before_ref_inv_cm;
593:
594: jai_cmn_rgm_recording_pkg.insert_reference (

Line 594: jai_cmn_rgm_recording_pkg.insert_reference (

590: fnd_file.put_line(fnd_file.LOG,'3 before call to procedure jai_cmn_rgm_recording_pkg.insert_reference ');
591:
592: savepoint before_ref_inv_cm;
593:
594: jai_cmn_rgm_recording_pkg.insert_reference (
595: p_reference_id => ln_reference_id ,
596: p_organization_id => p_organization_id ,/*5879769*/
597: p_source => p_source ,
598: p_invoice_id => rec_c_fetch_inv_cm_rec.customer_trx_id ,

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

620: p_process_flag => lv_process_flag ,
621: p_process_message => lv_process_message
622: );
623:
624: fnd_file.put_line(fnd_file.LOG,'4 returned from procedure jai_cmn_rgm_recording_pkg.insert_reference, lv_process_flag - '||lv_process_flag
625: ||'lv_process_message - '||lv_process_message);
626:
627:
628: IF lv_process_flag = jai_constants.expected_error OR

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

633: ||1. Rollback to save point
634: ||2. Set out variables p_process_flag and p_process_message accordingly
635: */
636: ROLLBACK to before_ref_inv_cm;
637: 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
638: ||', lv_process_message'||lv_process_message);
639: p_process_flag := lv_process_flag ;
640: p_process_message := lv_process_message ;
641: END IF;

Line 832: 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)

828:
829:
830: ln_amount := nvl(rec_c_get_cm_cm_app_rec.debit_amount,rec_c_get_cm_cm_app_rec.credit_amount) * (-1);
831:
832: 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)
833: ||', reversal entry amount -> '||ln_amount );
834:
835: /*csahoo for bug#5879769...start*/
836:

Line 860: jai_cmn_rgm_recording_pkg.insert_repository_entry (

856: /*csahoo for bug#5879769...end*/
857:
858: lv_attribute_context := 'CM-CM-REV'; --rchandan for bug#4428980
859:
860: jai_cmn_rgm_recording_pkg.insert_repository_entry (
861: p_repository_id => ln_repository_id ,
862: p_regime_id => p_regime_id ,
863: p_tax_type => rec_c_get_cm_cm_app_rec.tax_type ,
864: p_organization_type => p_organization_type ,

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

893: p_attribute2 => rec_c_get_incompleted_cm.cm_customer_trx_id
894: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
895: );
896:
897: fnd_file.put_line(fnd_file.LOG,' 4 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
898:
899:
900: IF lv_process_flag = jai_constants.expected_error OR
901: lv_process_flag = jai_constants.unexpected_error

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

908: ||4. Exit from the loop
909: */
910: ln_err_cm_customer_trx_id := rec_c_get_incompleted_cm.cm_customer_trx_id;
911: ROLLBACK to roll_to_last_cm;
912: 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
913: ||', lv_process_message'||lv_process_message ||'cm_customer_trx_id - '||ln_err_cm_customer_trx_id);
914: p_process_flag := lv_process_flag ;
915: p_process_message := lv_process_message ;
916: EXIT;

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

925: || Update the Credit Reference and set Recovered Amount to 0 as this credit memo has been incompleted
926: ########################################################################################################*/
927: 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)
928: LOOP
929: 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
930: ||', reference_id -> '||rec_cur_upd_cm_ref.reference_id );
931:
932: jai_cmn_rgm_recording_pkg.update_reference (
933: p_source => p_source ,

Line 932: jai_cmn_rgm_recording_pkg.update_reference (

928: LOOP
929: 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
930: ||', reference_id -> '||rec_cur_upd_cm_ref.reference_id );
931:
932: jai_cmn_rgm_recording_pkg.update_reference (
933: p_source => p_source ,
934: p_reference_id => rec_cur_upd_cm_ref.reference_id ,
935: p_recovered_amount => rec_cur_upd_cm_ref.recovered_amount * (-1) ,
936: p_process_flag => lv_process_flag ,

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

944: || Set out variables p_process_flag and p_process_message accordingly
945: */
946: ln_err_cm_customer_trx_id := rec_c_get_incompleted_cm.cm_customer_trx_id;
947: ROLLBACK to roll_to_last_cm;
948: 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
949: ||', lv_process_message'||lv_process_message);
950: p_process_flag := lv_process_flag ;
951: p_process_message := lv_process_message ;
952: END IF;

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

950: p_process_flag := lv_process_flag ;
951: p_process_message := lv_process_message ;
952: END IF;
953:
954: fnd_file.put_line(fnd_file.LOG,' 8 Returned from jai_cmn_rgm_recording_pkg.update_reference after updating CM reference' );
955: END LOOP;
956:
957: END IF; /* End if of ln_err_cm_customer_trx_id <> rec_c_get_incompleted_cm.cm_customer_trx_id*/
958:

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

975:
976: /*
977: || Insert a record into the repository corresponding to the 'CM-CM-REV'
978: */
979: fnd_file.put_line(fnd_file.LOG,' 9.1 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
980:
981: ln_amount := nvl(rec_c_get_cm_inv_app_rec.debit_amount,rec_c_get_cm_inv_app_rec.credit_amount) * (-1);
982:
983: 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 983: 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)

979: fnd_file.put_line(fnd_file.LOG,' 9.1 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
980:
981: ln_amount := nvl(rec_c_get_cm_inv_app_rec.debit_amount,rec_c_get_cm_inv_app_rec.credit_amount) * (-1);
982:
983: 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)
984: ||', reversal entry amount -> '||ln_amount );
985:
986: /*csahoo for bug#5879769...start*/
987:

Line 1011: jai_cmn_rgm_recording_pkg.insert_repository_entry (

1007: /*csahoo for bug#5879769...end*/
1008:
1009: lv_attribute_context := 'CM-INV-REV'; --rchandan for bug#4428980
1010: lv_source_table := 'JAI_RGM_TRX_RECORDS'; --rchandan for bug#4428980
1011: jai_cmn_rgm_recording_pkg.insert_repository_entry (
1012: p_repository_id => ln_repository_id ,
1013: p_regime_id => p_regime_id ,
1014: p_tax_type => rec_c_get_cm_inv_app_rec.tax_type ,
1015: p_organization_type => p_organization_type ,

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

1045: p_attribute2 => rec_c_get_cm_inv_app_rec.attribute2
1046: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
1047: );
1048:
1049: fnd_file.put_line(fnd_file.LOG,' 10.1 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1050:
1051:
1052: IF lv_process_flag = jai_constants.expected_error OR
1053: lv_process_flag = jai_constants.unexpected_error

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

1058: ||2. Set out variables p_process_flag and p_process_message accordingly
1059: */
1060: ln_err_cm_customer_trx_id := rec_c_get_incompleted_cm.cm_customer_trx_id;
1061: ROLLBACK to roll_to_last_cm;
1062: 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
1063: ||', lv_process_message'||lv_process_message);
1064: p_process_flag := lv_process_flag ;
1065: p_process_message := lv_process_message ;
1066: EXIT;

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

1070: /*########################################################################################################
1071: || Update the Recovered Amount of the Invoice Reference against the CM application
1072: ########################################################################################################*/
1073:
1074: 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
1075: ||', 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)
1076: );
1077:
1078:

Line 1079: jai_cmn_rgm_recording_pkg.update_reference (

1075: ||', 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)
1076: );
1077:
1078:
1079: jai_cmn_rgm_recording_pkg.update_reference (
1080: p_source => p_source ,
1081: p_reference_id => rec_c_get_cm_inv_app_rec.reference_id ,
1082: p_recovered_amount => ln_amount ,
1083: p_process_flag => lv_process_flag ,

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

1091: || Set out variables p_process_flag and p_process_message accordingly
1092: */
1093: ln_err_cm_customer_trx_id := rec_c_get_incompleted_cm.cm_customer_trx_id;
1094: ROLLBACK to roll_to_last_cm;
1095: 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
1096: ||', lv_process_message'||lv_process_message);
1097: p_process_flag := lv_process_flag ;
1098: p_process_message := lv_process_message ;
1099: EXIT;

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

1098: p_process_message := lv_process_message ;
1099: EXIT;
1100: END IF;
1101:
1102: fnd_file.put_line(fnd_file.LOG,' 14 Returned from jai_cmn_rgm_recording_pkg.update_reference after updating invoice reference' );
1103:
1104: END LOOP; /* End of 'CM-INV-APP record processing for an CM application against an invoice' */
1105:
1106: END IF; /* End if of ln_err_cm_customer_trx_id <> rec_c_get_incompleted_cm.cm_customer_trx_id*/

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

1524: || Make an entry into the repository with the apportioned Credit Memo Tax amount to be applied against a reference invoice
1525: */
1526: /* ln_amount := abs(ln_eff_cm_tax_amount) * ln_sign_of_credit_memo ; */
1527: ln_amount := abs(ln_eff_cm_tax_amount) ;
1528: fnd_file.put_line(fnd_file.LOG,' 14 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1529:
1530: /*csahoo for bug#5879769...start*/
1531:
1532: ln_organization_id := NULL;

Line 1554: jai_cmn_rgm_recording_pkg.insert_repository_entry (

1550:
1551: /*csahoo for bug#5879769...end*/
1552:
1553: lv_attribute_context := 'CM-INV-APP';
1554: jai_cmn_rgm_recording_pkg.insert_repository_entry (
1555: p_repository_id => ln_repository_id ,
1556: p_regime_id => p_regime_id ,
1557: p_tax_type => rec_c_get_refinvrec_for_upd.tax_type ,
1558: p_organization_type => p_organization_type ,

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

1588: p_attribute2 => rec_c_get_cm_rec_app.cm_customer_trx_id
1589: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
1590: );
1591:
1592: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1593:
1594:
1595: IF lv_process_flag = jai_constants.expected_error OR
1596: lv_process_flag = jai_constants.unexpected_error

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

1601: ||2. Set out variables p_process_flag and p_process_message accordingly
1602: */
1603: ln_receivable_application_id := rec_c_get_cm_rec_app.receivable_application_id ;
1604: ROLLBACK to roll_to_cm_app;
1605: 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
1606: ||', lv_process_message'||lv_process_message);
1607: p_process_flag := lv_process_flag ;
1608: p_process_message := lv_process_message ;
1609: EXIT;

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

1613: /*########################################################################################################
1614: || Update the Invoice Reference Recovered Amount with the effective Credit Memo tax amount
1615: ########################################################################################################*/
1616:
1617: fnd_file.put_line(fnd_file.LOG,' 11 before call to jai_cmn_rgm_recording_pkg.update_reference for updating invoice reference' );
1618:
1619: jai_cmn_rgm_recording_pkg.update_reference (
1620: p_source => p_source ,
1621: p_reference_id => rec_c_get_refinvrec_for_upd.reference_id ,

Line 1619: jai_cmn_rgm_recording_pkg.update_reference (

1615: ########################################################################################################*/
1616:
1617: fnd_file.put_line(fnd_file.LOG,' 11 before call to jai_cmn_rgm_recording_pkg.update_reference for updating invoice reference' );
1618:
1619: jai_cmn_rgm_recording_pkg.update_reference (
1620: p_source => p_source ,
1621: p_reference_id => rec_c_get_refinvrec_for_upd.reference_id ,
1622: p_recovered_amount => ln_amount ,
1623: p_process_flag => lv_process_flag ,

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

1633: ln_receivable_application_id := rec_c_get_cm_rec_app.receivable_application_id ;
1634: ROLLBACK to roll_to_cm_app;
1635: p_process_flag := lv_process_flag ;
1636: p_process_message := lv_process_message ;
1637: 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
1638: ||', lv_process_message'||lv_process_message);
1639:
1640: EXIT;
1641: END IF;

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

1640: EXIT;
1641: END IF;
1642:
1643:
1644: fnd_file.put_line(fnd_file.LOG,' 13 Returned from jai_cmn_rgm_recording_pkg.update_reference after updating invoice reference' );
1645:
1646: /*
1647: || Get the sum of the effective cm tax amount applied across all the reference invoice lines
1648: */

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

1728: END IF;
1729:
1730: /*csahoo for bug#5879769...end*/
1731:
1732: fnd_file.put_line(fnd_file.LOG,' 23 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1733: lv_attribute_context := 'CM-CM-APP';--rchandan for bug#4428980
1734: jai_cmn_rgm_recording_pkg.insert_repository_entry (
1735: p_repository_id => ln_repository_id ,
1736: p_regime_id => p_regime_id ,

Line 1734: jai_cmn_rgm_recording_pkg.insert_repository_entry (

1730: /*csahoo for bug#5879769...end*/
1731:
1732: fnd_file.put_line(fnd_file.LOG,' 23 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1733: lv_attribute_context := 'CM-CM-APP';--rchandan for bug#4428980
1734: jai_cmn_rgm_recording_pkg.insert_repository_entry (
1735: p_repository_id => ln_repository_id ,
1736: p_regime_id => p_regime_id ,
1737: p_tax_type => rec_c_get_refcmrec_for_upd.tax_type ,
1738: p_organization_type => p_organization_type ,

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

1767: p_attribute2 => rec_c_get_cm_rec_app.cm_customer_trx_id
1768: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
1769: );
1770:
1771: fnd_file.put_line(fnd_file.LOG,' 24 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
1772:
1773:
1774: IF lv_process_flag = jai_constants.expected_error OR
1775: lv_process_flag = jai_constants.unexpected_error

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

1779: ||1. Rollback to save point
1780: ||2. Set out variables p_process_flag and p_process_message accordingly
1781: */
1782: ROLLBACK to roll_to_cm_app;
1783: 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
1784: ||', lv_process_message'||lv_process_message);
1785: p_process_flag := lv_process_flag ;
1786: p_process_message := lv_process_message ;
1787: EXIT;

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

1787: EXIT;
1788: END IF;
1789:
1790:
1791: fnd_file.put_line(fnd_file.LOG,' 20 before call to jai_cmn_rgm_recording_pkg.update_reference for credit memo references '
1792: ||' ,abs(rec_c_get_refcmrec_for_upd.recoverable_amount) -> '||abs(rec_c_get_refcmrec_for_upd.recoverable_amount)
1793: ||' ,recovered amount i.e ln_cm_ref_upd -> '||ln_cm_ref_upd
1794: );
1795:

Line 1800: jai_cmn_rgm_recording_pkg.update_reference (

1796:
1797: /*
1798: || Update the cm reference line with the amount in ln_cm_ref_upd
1799: */
1800: jai_cmn_rgm_recording_pkg.update_reference (
1801: p_source => p_source ,
1802: p_reference_id => rec_c_get_refcmrec_for_upd.reference_id ,
1803: p_recovered_amount => ln_cm_ref_upd ,
1804: p_process_flag => lv_process_flag ,

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

1803: p_recovered_amount => ln_cm_ref_upd ,
1804: p_process_flag => lv_process_flag ,
1805: p_process_message => lv_process_message
1806: );
1807: fnd_file.put_line(fnd_file.LOG,' 21 Returned from jai_cmn_rgm_recording_pkg.update_reference for credit memo references' );
1808:
1809: IF lv_process_flag = jai_constants.expected_error OR
1810: lv_process_flag = jai_constants.unexpected_error
1811: THEN

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

1814: ||1. Rollback to save point
1815: ||2. Set out variables p_process_flag and p_process_message accordingly
1816: */
1817: ROLLBACK to roll_to_cm_app;
1818: 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
1819: ||', lv_process_message'||lv_process_message);
1820: p_process_flag := lv_process_flag ;
1821: p_process_message := lv_process_message ;
1822: EXIT;

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

2216:
2217: /*csahoo for bug#5879769...end*/
2218:
2219:
2220: fnd_file.put_line(fnd_file.LOG,' 14 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2221:
2222: jai_cmn_rgm_recording_pkg.insert_repository_entry (
2223: p_repository_id => ln_repository_id ,
2224: p_regime_id => p_regime_id ,

Line 2222: jai_cmn_rgm_recording_pkg.insert_repository_entry (

2218:
2219:
2220: fnd_file.put_line(fnd_file.LOG,' 14 before call to jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2221:
2222: jai_cmn_rgm_recording_pkg.insert_repository_entry (
2223: p_repository_id => ln_repository_id ,
2224: p_regime_id => p_regime_id ,
2225: p_tax_type => rec_c_get_refrec_for_upd.tax_type ,
2226: p_organization_type => p_organization_type ,

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

2256: p_attribute2 => rec_c_get_rec_app.cash_receipt_id
2257: , p_accntg_required_flag => jai_constants.yes --File.Sql.35 Cbabu
2258: );
2259:
2260: fnd_file.put_line(fnd_file.LOG,' 15 Returned from jai_cmn_rgm_recording_pkg.insert_repository_entry ' );
2261:
2262:
2263: IF lv_process_flag = jai_constants.expected_error OR
2264: lv_process_flag = jai_constants.unexpected_error

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

2271: ln_receivable_application_id := rec_c_get_rec_app.receivable_application_id;
2272: ROLLBACK to roll_to_last_receivable;
2273: p_process_flag := lv_process_flag ;
2274: p_process_message := lv_process_message ;
2275: 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
2276: ||', lv_process_message'||lv_process_message);
2277: EXIT;
2278: END IF;
2279:

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

2281: /*########################################################################################################
2282: || update the effective cash receipt tax amount into the reference table
2283: ########################################################################################################*/
2284:
2285: fnd_file.put_line(fnd_file.LOG,' 12 before call to jai_cmn_rgm_recording_pkg.update_reference ' );
2286:
2287: savepoint before_ref_upd;
2288: jai_cmn_rgm_recording_pkg.update_reference (
2289: p_source => p_source ,

Line 2288: jai_cmn_rgm_recording_pkg.update_reference (

2284:
2285: fnd_file.put_line(fnd_file.LOG,' 12 before call to jai_cmn_rgm_recording_pkg.update_reference ' );
2286:
2287: savepoint before_ref_upd;
2288: jai_cmn_rgm_recording_pkg.update_reference (
2289: p_source => p_source ,
2290: p_reference_id => rec_c_get_refrec_for_upd.reference_id ,
2291: p_recovered_amount => ln_eff_cr_tax_amount ,
2292: p_discounted_amount => ln_eff_cr_disc_amount ,

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

2305: ln_receivable_application_id := rec_c_get_rec_app.receivable_application_id;
2306: ROLLBACK to roll_to_last_receivable;
2307: p_process_flag := lv_process_flag ;
2308: p_process_message := lv_process_message ;
2309: 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
2310: ||', lv_process_message'||lv_process_message);
2311:
2312: EXIT;
2313: END IF;

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

2311:
2312: EXIT;
2313: END IF;
2314:
2315: fnd_file.put_line(fnd_file.LOG,' 13 Returned from jai_cmn_rgm_recording_pkg.update_reference ' );
2316:
2317: END LOOP;
2318:
2319: ln_uncommitted_transactions := ln_uncommitted_transactions + 1;