[Home] [Help]
2: /* $Header: jai_tcs_repo_pkg.plb 120.30.12020000.2 2013/03/18 06:02:20 zxin ship $ */
3:
4:
5: /** Package level variables used in debug package*/
6: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE DEFAULT 'TCS.JAI_AR_TCS_REP_PKG';
7: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
8: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
9: /****
10: || Get the primary key
3:
4:
5: /** Package level variables used in debug package*/
6: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE DEFAULT 'TCS.JAI_AR_TCS_REP_PKG';
7: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
8: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
9: /****
10: || Get the primary key
11: || for the table jai_rgm_refs_all
4:
5: /** Package level variables used in debug package*/
6: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE DEFAULT 'TCS.JAI_AR_TCS_REP_PKG';
7: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
8: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
9: /****
10: || Get the primary key
11: || for the table jai_rgm_refs_all
12: *****/
209: set_debug_context;
210:
211:
212: /*commented by csahoo for bug# 6401388
213: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
214: pn_reg_id => ln_reg_id
215: );*/
216: p_process_flag := jai_constants.successful ;
217: p_process_message := null ;
238: || by calling the function jai_cmn_rgm_recording_pkg.get_account
239: *********************************************************************************************************/
240:
241: /*commented by csahoo for bug# 6401388
242: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
243: pv_log_msg => 'Before call to jai_cmn_rgm_recording_pkg.get_account for int liab'
244: );*/
245: v_liab_acc_ccid := jai_cmn_rgm_recording_pkg.get_account (
246: p_regime_id => rec_cur_get_picking_taxes.regime_id ,
251: p_account_name => jai_constants.liability
252: );
253:
254: /*commented by csahoo for bug# 6401388
255: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
256: pv_log_msg => 'Before call to jai_cmn_rgm_recording_pkg.get_account for liab'
257: );*/
258: v_int_liab_acc_ccid := jai_cmn_rgm_recording_pkg.get_account (
259: p_regime_id => rec_cur_get_picking_taxes.regime_id ,
273: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
274: || This is an error condition and the current processing has to be stopped
275: **********************************************************************************************************/
276: /*commented by csahoo for bug# 6401388
277: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
278: pv_log_msg => 'Error in call to jai_cmn_rgm_recording_pkg.get_account'
279: );*/
280: p_process_flag := jai_constants.expected_error;
281: p_process_message := 'Invalid Code combination ,please check the TCS Tax - Tax Accounting Setup';
286: /*
287: ||Credit the liability account
288: */
289: /*commented by csahoo for bug# 6401388
290: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
291: PV_LOG_MSG => 'CREDIT MEMO ENTRIES GETTING PASSED TO jai_cmn_gl_pkg.create_gl_entry ARE :- ' ||fnd_global.local_chr(10)
292: ||', p_organization_id -> '|| p_organization_id ||fnd_global.local_chr(10)
293: ||', p_currency_code -> '|| p_currency_code ||fnd_global.local_chr(10)
294: ||', p_credit_amount -> '|| round(rec_cur_get_picking_taxes.func_tax_amount) ||fnd_global.local_chr(10)
332: /*
333: ||Debit the Interim liability account
334: */
335: /*
336: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
337: pv_log_msg => 'DEBIT MEMO ENTRIES GETTING PASSED TO jai_cmn_gl_pkg.create_gl_entry ARE :- '||fnd_global.local_chr(10)
338: ||', p_organization_id -> '|| p_organization_id ||fnd_global.local_chr(10)
339: ||', p_currency_code -> '|| p_currency_code ||fnd_global.local_chr(10)
340: ||', p_credit_amount -> '|| 0 ||fnd_global.local_chr(10)
375:
376: END LOOP;
377:
378: /*commented by csahoo for bug# 6401388
379: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
380: pv_log_msg => '**************** WSH_INTERIM_ACCOUNTING SUCCESSFULLY COMPLETED ****************'
381: );
382: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
383:
378: /*commented by csahoo for bug# 6401388
379: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
380: pv_log_msg => '**************** WSH_INTERIM_ACCOUNTING SUCCESSFULLY COMPLETED ****************'
381: );
382: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: p_process_flag := jai_constants.unexpected_error;
831:
832: set_debug_context;
833:
834:
835: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
836: pn_reg_id => ln_reg_id
837: ); --commmented by CSahoo, BUG#5631784*/
838: p_process_flag := jai_constants.successful ;
839: p_process_message := null ;
861: || by calling the function jai_cmn_rgm_recording_pkg.get_account
862: *********************************************************************************************************/
863:
864: /*commented by csahoo for bug# 6401388
865: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
866: pv_log_msg => 'Before call to jai_cmn_rgm_recording_pkg.get_account for int liab'
867: );*/
868: v_liab_acc_ccid := jai_cmn_rgm_recording_pkg.get_account (
869: p_regime_id => rec_cur_get_inv_det.regime_id ,
874: p_account_name => jai_constants.liability
875: );
876:
877: /*commented by csahoo for bug# 6401388
878: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
879: pv_log_msg => 'Before call to jai_cmn_rgm_recording_pkg.get_account for liab'
880: );*/
881: v_int_liab_acc_ccid := jai_cmn_rgm_recording_pkg.get_account (
882: p_regime_id => rec_cur_get_inv_det.regime_id ,
896: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
897: || This is an error condition and the current processing has to be stopped
898: **********************************************************************************************************/
899: /*commented by csahoo for bug# 6401388
900: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
901: pv_log_msg => 'Error in call to jai_cmn_rgm_recording_pkg.get_account'
902: );*/
903: p_process_flag := jai_constants.expected_error;
904: p_process_message := 'Invalid Code combination ,please check the TCS Tax - Tax Accounting Setup';
913: /*
914: ||Credit the liability account
915: */
916: /*commented by csahoo for bug# 6401388
917: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
918: PV_LOG_MSG => 'CREDIT MEMO ENTRIES GETTING PASSED TO jai_cmn_gl_pkg.create_gl_entry ARE :- ' ||fnd_global.local_chr(10)
919: ||', p_organization_id -> '|| rec_cur_get_inv_det.organization_id ||fnd_global.local_chr(10)
920: ||', p_currency_code -> '|| p_ract.invoice_currency_code ||fnd_global.local_chr(10)
921: ||', p_credit_amount -> '|| round(rec_cur_get_inv_det.func_tax_amount) ||fnd_global.local_chr(10)
979: /*
980: ||Debit the Interim liability account
981: */
982: /*commented by csahoo for bug# 6401388
983: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
984: pv_log_msg => 'DEBIT MEMO ENTRIES GETTING PASSED TO jai_cmn_gl_pkg.create_gl_entry ARE :- '||fnd_global.local_chr(10)
985: ||', p_organization_id -> '|| rec_cur_get_inv_det.organization_id ||fnd_global.local_chr(10)
986: ||', p_currency_code -> '|| p_ract.invoice_currency_code ||fnd_global.local_chr(10)
987: ||', p_credit_amount -> '|| 0 ||fnd_global.local_chr(10)
1023:
1024: END LOOP;
1025:
1026: /*commented by csahoo for bug# 6401388
1027: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1028: pv_log_msg => '**************** MAN_AR_COMPLETION_ACCOUNTING SUCCESSFULLY COMPLETED ****************'
1029: );
1030: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1031:
1026: /*commented by csahoo for bug# 6401388
1027: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1028: pv_log_msg => '**************** MAN_AR_COMPLETION_ACCOUNTING SUCCESSFULLY COMPLETED ****************'
1029: );
1030: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: p_process_flag := jai_constants.unexpected_error;
1107: JAI_OM_OE_SO_LINES jsl
1108: WHERE
1109: jsl.header_id = cp_header_id;
1110:
1111: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;
1112: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
1113: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
1114:
1115: ln_exists NUMBER ;
1108: WHERE
1109: jsl.header_id = cp_header_id;
1110:
1111: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;
1112: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
1113: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
1114:
1115: ln_exists NUMBER ;
1116: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1109: jsl.header_id = cp_header_id;
1110:
1111: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;
1112: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
1113: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
1114:
1115: ln_exists NUMBER ;
1116: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1117: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1127: lv_member_name := 'VALIDATE_SALES_ORDER';
1128: lv_object_name := 'TCS.JAI_AR_TCS_REP_PKG';
1129: set_debug_context;
1130: /*commented by csahoo for bug# 6401388
1131: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
1132: pn_reg_id => ln_reg_id
1133: );*/
1134: lv_process_flag := jai_constants.successful ;
1135: lv_process_message := null ;
1147: IF ln_event = jai_constants.order_booked AND
1148: p_ooh.flow_status_code <> jai_constants.order_booked
1149: THEN
1150: /*commented by csahoo for bug# 6401388
1151: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1152: pv_log_msg => ' Skip the transaction as order has a flow status code as '|| p_ooh.flow_status_code ||' which is different from BOOKED '
1153: );*/
1154: p_process_flag := jai_constants.not_applicable ;
1155: return;
1164: OPEN cur_chk_tcs_applicable ( cp_header_id => p_ooh.header_id ) ;
1165: FETCH cur_chk_tcs_applicable INTO ln_exists ;
1166: IF CUR_CHK_TCS_APPLICABLE%NOTFOUND THEN
1167: /*commented by csahoo for bug# 6401388
1168: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1169: pv_log_msg => ' Skip as order does not have TCS type of taxes '
1170: );*/
1171: p_process_flag := jai_constants.not_applicable ;
1172: return;
1196: ||Rows with no TCS type of taxes exists hence error out
1197: */
1198: CLOSE cur_chk_tcs_for_all_lines ;
1199: /*commented by csahoo for bug# 6401388
1200: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1201: pv_log_msg => 'Error :- Cannot Book/ship the sales order if some lines have TCS type of tax and some dont '||fnd_global.local_chr(10)
1202: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1203: ||', lv_process_message -> '||lv_process_message
1204: );*/
1239: || Set out variables p_process_flag and p_process_message accordingly
1240: */
1241: --call to debug package
1242: /*commented by csahoo for bug# 6401388
1243: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1244: pv_log_msg => 'Error In processing of jai_inv_items_pkg.jai_get_attrib'||fnd_global.local_chr(10)
1245: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1246: ||', lv_process_message -> '||lv_process_message
1247: );*/
1263: || then stop the transaction and throw an error.
1264: */
1265: IF nvl(lv_first_itm_class,'$$') <> nvl(lv_item_classification,'###') THEN
1266: /*commented by csahoo for bug# 6401388
1267: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1268: pv_log_msg => 'Error :- Cannot Book/Ship the sales order as as all lines do not belong to the same Item Classification '||fnd_global.local_chr(10)
1269: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1270: ||', lv_process_message -> '||lv_process_message
1271: );*/
1278:
1279: END IF;
1280:
1281: /*commented by csahoo for bug# 6401388
1282: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1283: pv_log_msg => '**************** VALIDATE_SALES_ORDER SUCCESSFULLY COMPLETED ****************'
1284: );
1285: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1286:
1281: /*commented by csahoo for bug# 6401388
1282: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1283: pv_log_msg => '**************** VALIDATE_SALES_ORDER SUCCESSFULLY COMPLETED ****************'
1284: );
1285: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1286:
1287:
1288: END validate_sales_order ;
1289:
1437: lv_member_name := 'VALIDATE_INVOICE';
1438: set_debug_context;
1439:
1440: /*commented by csahoo for bug# 6401388
1441: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
1442: pn_reg_id => ln_reg_id
1443: );*/
1444:
1445: lv_process_flag := jai_constants.successful ;
1448: p_process_flag := lv_process_flag ;
1449: p_process_message := lv_process_message ;
1450:
1451: /*commented by csahoo for bug# 6401388
1452: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1453: pv_log_msg => ' Validating the Document '||fnd_global.local_chr(10)
1454: ||', p_ract.trx_number -> '||p_ract.trx_number ||fnd_global.local_chr(10)
1455: ||', p_ract.customer_trx_id -> '||p_ract.customer_trx_id
1456: );*/
1457: /*########################################################################################################
1458: || CHECK TCS APPLICABILITY PART -2
1459: ########################################################################################################*/
1460: /*commented by csahoo for bug# 6401388
1461: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1462: pv_log_msg => ' Check TCS applicability '
1463: );*/
1464: /*
1465: || Check whether the TCS is applicable on the document if no
1468: OPEN cur_chk_tcs_applicable ( cp_customer_trx_id => p_ract.customer_trx_id );
1469: FETCH cur_chk_tcs_applicable INTO ld_source_doc_date ,ln_organization_id;
1470: IF cur_chk_tcs_applicable%NOTFOUND THEN
1471: /*commented by csahoo for bug# 6401388
1472: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1473: pv_log_msg => ' TCS taxes not present on Invoice '
1474: );*/
1475: CLOSE cur_chk_tcs_applicable ;
1476: /*
1478: || IF yes punch/reset to null, the customer_trx_id into jai_rgm_item_gen_docs.generated_doc_id based on the
1479: ||complete flag
1480: */
1481: /*commented by csahoo for bug# 6401388
1482: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1483: pv_log_msg => 'Call to procedure update_item_gen_docs to check whether this is the TCS secondary document'
1484: );*/
1485:
1486: update_item_gen_docs ( p_trx_number => p_ract.trx_number ,
1490: p_process_flag => lv_process_flag ,
1491: p_process_message => lv_process_message
1492: );
1493: /*commented by csahoo for bug# 6401388
1494: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1495: pv_log_msg => 'returned from update_item_gen_docs lv_process_flag -> '||fnd_global.local_chr(10)
1496: ||', lv_process_flag -> '|| lv_process_flag || fnd_global.local_chr(10)
1497: ||', lv_process_message -> '|| lv_process_message || fnd_global.local_chr(10)
1498: );*/
1497: ||', lv_process_message -> '|| lv_process_message || fnd_global.local_chr(10)
1498: );*/
1499:
1500: /*commented by csahoo for bug# 6401388
1501: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1502: pv_log_msg => 'Skip furthur processing as Invoice does not have TCS type of taxes '
1503: );*/
1504:
1505: p_process_flag := lv_process_flag ;
1510: END IF;
1511: CLOSE cur_chk_tcs_applicable ;
1512:
1513: /*commented by csahoo for bug# 6401388
1514: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1515: pv_log_msg => ' Document Parameters '||fnd_global.local_chr(10)
1516: ||', source_doc_date -> '||ld_source_doc_date ||fnd_global.local_chr(10)
1517: ||', organization_id-> '||ln_organization_id
1518: );*/
1524: FETCH cur_get_doc_det INTO lv_trx_type;
1525: CLOSE cur_get_doc_det ;
1526:
1527: /*commented by csahoo for bug# 6401388
1528: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1529: pv_log_msg => ' Current document type is '||lv_trx_type
1530: );*/
1531: /*Bug 10245810 - Repository to be updated during CM Completion also*/
1532: /*
1542:
1543: IF ln_event = jai_constants.trx_event_completion THEN
1544:
1545: /*commented by csahoo for bug# 6401388
1546: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1547: pv_log_msg => ' Event is -> '||ln_event
1548: );*/
1549:
1550: /*########################################################################################################
1554:
1555: IF p_ract.complete_flag = jai_constants.yes THEN
1556:
1557: /*commented by csahoo for bug# 6401388
1558: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1559: pv_log_msg => ' Complete -> '||p_ract.complete_flag
1560: );*/
1561: /*Bug 10245810 - Added CM Type also. Repository to be updated during CM Completion also*/
1562: IF lv_trx_type IN (jai_constants.ar_invoice_type_inv,jai_constants.ar_doc_type_dm,jai_constants.ar_invoice_type_cm) THEN
1565: */
1566: lv_doc_type := jai_constants.trx_type_inv_comp;
1567: ELSE
1568: /*commented by csahoo for bug# 6401388
1569: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1570: pv_log_msg => ' Skip as type -> '||lv_trx_type ||' not applicable for TCS processing '
1571: );*/
1572: p_process_flag := jai_constants.not_applicable;
1573: return;
1584: */
1585: lv_doc_type := jai_constants.trx_type_inv_incomp;
1586: ELSE
1587: /*commented by csahoo for bug# 6401388
1588: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1589: pv_log_msg => ' Skip as type -> '||lv_trx_type ||' not applicable for TCS processing '
1590: );*/
1591: p_process_flag := jai_constants.not_applicable;
1592: return;
1617: OPEN cur_chk_tcs_settlement ( cp_customer_trx_id => p_ract.customer_trx_id );
1618: FETCH cur_chk_tcs_settlement INTO ln_exists;
1619: IF CUR_CHK_TCS_SETTLEMENT%FOUND THEN
1620: /*commented by csahoo for bug# 6401388
1621: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1622: pv_log_msg => 'Error :- Cannot Incomplete the invoice if it has already been settled '||fnd_global.local_chr(10)
1623: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1624: ||', lv_process_message -> '||lv_process_message
1625: );*/
1656: ||Rows with no TCS type of taxes exists hence error out
1657: */
1658: CLOSE cur_chk_tcs_for_all_lines ;
1659: /*commented by csahoo for bug# 6401388
1660: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1661: pv_log_msg => 'Error :- Cannot complete the invoice if some lines have TCS type of tax and some dont '||fnd_global.local_chr(10)
1662: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1663: ||', lv_process_message -> '||lv_process_message
1664: );*/
1698: || Set out variables p_process_flag and p_process_message accordingly
1699: */
1700: --call to debug package
1701: /*commented by csahoo for bug# 6401388
1702: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1703: pv_log_msg => 'Error In processing of jai_inv_items_pkg.jai_get_attrib'||fnd_global.local_chr(10)
1704: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1705: ||', lv_process_message -> '||lv_process_message
1706: );*/
1722: || then stop the transaction and throw an error.
1723: */
1724: IF nvl(lv_first_itm_class,'$$') <> nvl(lv_item_classification,'###') THEN
1725: /*commented by csahoo for bug# 6401388
1726: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1727: pv_log_msg => 'Error :- Cannot complete as all lines do not belong to the same Item Classification '||fnd_global.local_chr(10)
1728: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1729: ||', lv_process_message -> '||lv_process_message
1730: );*/
1820:
1821: p_document_type := lv_doc_type;
1822:
1823: /*commented by csahoo for bug# 6401388
1824: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1825: pv_log_msg => '**************** END OF VALIDATE_INVOICE ****************'
1826: );
1827: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1828: END validate_invoice;
1823: /*commented by csahoo for bug# 6401388
1824: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1825: pv_log_msg => '**************** END OF VALIDATE_INVOICE ****************'
1826: );
1827: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1828: END validate_invoice;
1829:
1830:
1831:
1962: lv_member_name := 'VALIDATE_APP_UNAPP';
1963: set_debug_context;
1964:
1965: /*commented by csahoo for bug# 6401388
1966: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
1967: pn_reg_id => ln_reg_id
1968: );*/
1969:
1970: lv_process_flag := jai_constants.successful ;
1975: ln_sign_of_app_fr_doc := null ;
1976: ln_sign_of_app := sign(nvl(p_araa.amount_applied,0));
1977:
1978: /*commented by csahoo for bug# 6401388
1979: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1980: pv_log_msg => ' Processing the APPLICATION record ' ||fnd_global.local_chr(10)
1981: ||', receivable_application_id -> ' ||p_araa.receivable_application_id ||fnd_global.local_chr(10)
1982: ||', application_type -> ' ||p_araa.application_type ||fnd_global.local_chr(10)
1983: ||', status -> ' ||p_araa.status ||fnd_global.local_chr(10)
2002: || Check that cash receipt has tcs type of taxes which have been confirmed
2003: || Exit processing if the same is not found
2004: */
2005: /*commented by csahoo for bug# 6401388
2006: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2007: pv_log_msg => ' Checking TCS applicability On applied from documents'
2008: );*/
2009: OPEN cur_chk_crtcs_applicable (cp_cash_receipt_id => p_araa.cash_receipt_id );
2010: FETCH cur_chk_crtcs_applicable INTO ln_app_fr_itm_class, ln_app_fr_amount;
2010: FETCH cur_chk_crtcs_applicable INTO ln_app_fr_itm_class, ln_app_fr_amount;
2011:
2012: IF cur_chk_crtcs_applicable%NOTFOUND THEN
2013: /*commented by csahoo for bug# 6401388
2014: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2015: pv_log_msg => ' Skip As TCS not applicable ON Derived from documents '
2016: );*/
2017: CLOSE cur_chk_crtcs_applicable;
2018: p_process_flag := jai_constants.not_applicable ;
2021: /*
2022: ||Check for ACTIVITY I.E receipt to receipt or receipt to credit memo any other type of application other than Receipt/CM to INV or DM
2023: */
2024: /*commented by csahoo for bug# 6401388
2025: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2026: pv_log_msg => 'TCS is applicable'
2027: );*/
2028:
2029: IF p_araa.status = jai_constants.ar_status_activity THEN
2031: || As current receivable application is an activity indicating a receipt to receipt getting applied to another receipt
2032: || or Credit Memo hence stop this processing as otherwise this would lead to down stream TCS data corruption.
2033: */
2034: /*commented by csahoo for bug# 6401388
2035: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2036: pv_log_msg => 'Cannot apply a RECEIPT to any other document (any of them having TCS applicability) other than a Invoice or Debit Memo'
2037: );*/
2038: p_process_flag := jai_constants.expected_error;
2039: p_process_message := 'Cannot apply a RECEIPT to any other document (any of them having TCS applicability) other than a Invoice or Debit Memo';
2071: OPEN cur_chk_tcs_applicable( cp_customer_trx_id => p_araa.customer_trx_id );
2072: FETCH cur_chk_tcs_applicable INTO ln_app_fr_organization_id, ln_app_fr_inventory_item_id, ln_app_fr_amount;
2073:
2074: /*commented by csahoo for bug# 6401388
2075: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2076: pv_log_msg => 'Application type is '||p_araa.application_type
2077: );*/
2078:
2079: IF CUR_CHK_TCS_APPLICABLE%NOTFOUND THEN
2077: );*/
2078:
2079: IF CUR_CHK_TCS_APPLICABLE%NOTFOUND THEN
2080: /*commented by csahoo for bug# 6401388
2081: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2082: pv_log_msg => ' Skip As TCS not applicable ON Derived from documents '
2083: );*/
2084: CLOSE cur_chk_tcs_applicable;
2085: p_process_flag := jai_constants.not_applicable ;
2125: || Set out variables p_process_flag and p_process_message accordingly
2126: */
2127: --call to debug package
2128: /*commented by csahoo for bug# 6401388
2129: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2130: pv_log_msg => ' Error in getting the item attribute'||fnd_global.local_chr(10)
2131: ||', p_process_flag -> '|| p_process_flag
2132: ||', lv_process_message -> '|| lv_process_message
2133: );*/
2140: /*
2141: ||Return in case the scenario is niether CASH nor CM
2142: */
2143: /*commented by csahoo for bug# 6401388
2144: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2145: pv_log_msg => ' Skip as scenario is niether CASH nor CM '
2146: );*/
2147: p_process_flag := jai_constants.not_applicable ;
2148: return;
2148: return;
2149: END IF; -------------A1
2150:
2151: /*commented by csahoo for bug# 6401388
2152: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2153: pv_log_msg => ' Application document type is '||lv_app_doc_type
2154: );*/
2155:
2156:
2168: IF CUR_CHK_TCS_APPLICABLE%NOTFOUND THEN
2169: CLOSE cur_chk_tcs_applicable;
2170: p_process_flag := jai_constants.not_applicable ;
2171: /*commented by csahoo for bug# 6401388
2172: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2173: pv_log_msg => ' Skip the processing as TCS is not applicable on the transaction'
2174: );*/
2175: return;
2176: END IF;
2197: || Set out variables p_process_flag and p_process_message accordingly
2198: */
2199: --call to debug package
2200: /*commented by csahoo for bug# 6401388
2201: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2202: pv_log_msg => ' Error in getting the item classification '||fnd_global.local_chr(10)
2203: ||', p_process_flag -> '|| p_process_flag
2204: ||', lv_process_message -> '|| lv_process_message
2205: );*/
2224: THEN
2225: IF ln_app_fr_itm_class <> ln_app_to_itm_class THEN
2226:
2227: /*commented by csahoo for bug# 6401388
2228: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2229: pv_log_msg => ' Item classification for the application from and to item class do not match hence error '||fnd_global.local_chr(10)
2230: ||', p_process_flag -> '|| p_process_flag
2231: ||', lv_process_message -> '|| lv_process_message
2232: );*/
2240: ||Do not allow overapplication transactions in case they both have TCS type of taxes
2241: */
2242: IF nvl(p_araa.amount_applied,0) > nvl(ln_app_to_amount,0) THEN
2243: /*commented by csahoo for bug# 6401388
2244: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2245: pv_log_msg => 'Case for Overapplication detected , Stop '||fnd_global.local_chr(10)
2246: ||', p_araa.amount_applied -> '|| p_araa.amount_applied ||fnd_global.local_chr(10)
2247: ||', applied to amount -> '|| ln_app_to_amount ||fnd_global.local_chr(10)
2248: ||', p_process_flag -> '|| p_process_flag ||fnd_global.local_chr(10)
2276: ||Exit processing as original application did not hit the repository.
2277: */
2278: CLOSE cur_chk_parent_rec;
2279: /*commented by csahoo for bug# 6401388
2280: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2281: pv_log_msg => 'Skip,case For unapplication, Parent transaction record is not present in the repository'||fnd_global.local_chr(10)
2282: ||', p_process_flag -> '|| p_process_flag ||fnd_global.local_chr(10)
2283: );*/
2284:
2294: */
2295: p_process_flag := jai_constants.expected_error ;
2296: p_process_message := 'Parent application has already been settled. hence cannot unapply';
2297: /*commented by csahoo for bug# 6401388
2298: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2299: pv_log_msg => ' Error :-Parent application has already been settled. hence cannot unapply'||fnd_global.local_chr(10)
2300: ||', p_process_flag -> '|| p_process_flag
2301: ||', lv_process_message -> '|| lv_process_message
2302: );*/
2323: /*
2324: ||Exit processing as original application did not hit the repository.
2325: */
2326: /*commented by csahoo for bug# 6401388
2327: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2328: pv_log_msg => ' Skip the processing as TCS is not applicable on the transaction'||fnd_global.local_chr(10)
2329: ||', p_process_flag -> '|| p_process_flag
2330: );*/
2331: CLOSE cur_chk_parent_rec;
2339: /*
2340: || Original Application already settled hence
2341: */
2342: /*commented by csahoo for bug# 6401388
2343: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2344: pv_log_msg => ' Error :-Parent application has already been settled. hence cannot unapply'||fnd_global.local_chr(10)
2345: ||', p_process_flag -> '|| p_process_flag
2346: ||', lv_process_message -> '|| lv_process_message
2347: );*/
2359: p_document_type := lv_app_doc_type ;
2360: p_item_classification := ln_app_to_itm_class ;
2361:
2362: /*commented by csahoo for bug# 6401388
2363: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2364: pv_log_msg => '**************** PROCEDURE VALIDATE_APP_UNAPP SUCCESSFUL ****************'
2365: );
2366:
2367: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2363: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2364: pv_log_msg => '**************** PROCEDURE VALIDATE_APP_UNAPP SUCCESSFUL ****************'
2365: );
2366:
2367: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2368:
2369: END validate_app_unapp;
2370:
2371: PROCEDURE validate_receipts ( p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE ,
2430:
2431: lv_member_name := 'VALIDATE_RECEIPTS';
2432: set_debug_context;
2433: /*commented by csahoo for bug# 6401388
2434: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2435: , pn_reg_id => ln_reg_id
2436: ); --commmented by CSahoo, BUG#5631784
2437:
2438:
2436: ); --commmented by CSahoo, BUG#5631784
2437:
2438:
2439: /*commented by csahoo for bug# 6401388
2440: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2441: pv_log_msg => ' PARAMETERS VALUES PASSED TO VALIDATE_RECEIPTS : - ' ||fnd_global.local_chr(10)
2442: ||', p_acra.receipt_number -> '||p_acra.receipt_number ||fnd_global.local_chr(10)
2443: ||', p_acra.cash_receipt_id -> '||p_acra.cash_receipt_id ||fnd_global.local_chr(10)
2444: ||', p_acra.amount -> '||p_acra.amount ||fnd_global.local_chr(10)
2455: /*########################################################################################################
2456: || CHECK TCS APPLICABILITY PART -2
2457: ########################################################################################################*/
2458: /*commented by csahoo for bug# 6401388
2459: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2460: pv_log_msg => ' Check TCS applicability '
2461: );*/
2462: /*
2463: || Check whether the TCS is applicable on the document if no
2482: || In case it does not exist, then error out the record as it need not hit the repository
2483: || If it exists then check whether it has been settled . If yes then throw an error
2484: */
2485: /*commented by csahoo for bug# 6401388
2486: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2487: pv_log_msg => 'Validate for Receipt Reversal '
2488: );*/
2489: OPEN cur_chk_tcs_settlement ( cp_source_document_id => p_acra.cash_receipt_id ,
2490: cp_source_document_type => jai_constants.ar_cash_tax_confirmed
2494: /*
2495: ||Original receipt not found in repository hence throw an error
2496: */
2497: /*commented by csahoo for bug# 6401388
2498: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2499: pv_log_msg => 'Original Receipt Confirmation records does not exists in the repository. Cannot reverse receipt'
2500: );*/
2501: CLOSE cur_chk_tcs_settlement;
2502: p_process_flag := jai_constants.expected_error;
2511: || TCS taxes pertaining to the receipt have already been settled
2512: || Cannot allow receipt to be reversed.
2513: */
2514: /*commented by csahoo for bug# 6401388
2515: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2516: pv_log_msg => ' TCS On the original confirmed receipt has been settled. CAnnot reverse the receipt'
2517: );*/
2518: p_process_flag := jai_constants.expected_error;
2519: p_process_message := 'Cannot reverse the receipt as the tcs taxes pertaining to the receipt have been confirmed ';
2523: CLOSE cur_chk_tcs_settlement;
2524: END IF; /* Receipt reversal */
2525:
2526: /*commented by csahoo for bug# 6401388
2527: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2528: pv_log_msg => '**************** END OF VALIDATE_RECEIPTS ****************'
2529: );
2530:
2531: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2527: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2528: pv_log_msg => '**************** END OF VALIDATE_RECEIPTS ****************'
2529: );
2530:
2531: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2532: END validate_receipts;
2533:
2534: PROCEDURE process_invoices ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,
2535: p_document_type VARCHAR2 ,
2645:
2646: lv_member_name := 'PROCESS_INVOICES';
2647: set_debug_context;
2648: /*commented by csahoo for bug# 6401388
2649: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2650: , pn_reg_id => ln_reg_id
2651: );*/
2652:
2653: lv_process_flag := jai_constants.successful ;
2825:
2826: END IF; /* Invoice completion / Incompletion*/
2827:
2828: /*commented by csahoo for bug# 6401388
2829: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2830: pv_log_msg => '**************** END OF PROCESS_INVOICES ****************'
2831: );
2832: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2833: END process_invoices;
2828: /*commented by csahoo for bug# 6401388
2829: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2830: pv_log_msg => '**************** END OF PROCESS_INVOICES ****************'
2831: );
2832: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2833: END process_invoices;
2834:
2835:
2836: procedure process_receipts ( p_acra AR_CASH_RECEIPTS_ALL%ROWTYPE ,
2968: ########################################################################################################*/
2969: lv_member_name := 'PROCESS_RECEIPTS';
2970: set_debug_context;
2971: /*commented by csahoo for bug# 6401388
2972: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2973: , pn_reg_id => ln_reg_id
2974: );*/
2975:
2976: lv_process_flag := jai_constants.successful ;
2989: *******/
2990:
2991: IF p_document_type = jai_constants.ar_cash_tax_confirmed THEN ---------C1
2992: /*commented by csahoo for bug# 6401388
2993: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2994: pv_log_msg => ' Confirmation processing for the receipts with the following details'||fnd_global.local_chr(10)
2995: ||', p_acra.receipt_number -> '||p_acra.receipt_number ||fnd_global.local_chr(10)
2996: ||', p_acra.cash_receipt_id -> '||p_acra.cash_receipt_id ||fnd_global.local_chr(10)
2997: ||', p_acra.amount -> '||p_acra.amount ||fnd_global.local_chr(10)
3014:
3015: ln_local_transaction_id := ln_transaction_id;
3016:
3017: /*commented by csahoo for bug# 6401388
3018: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3019: pv_log_msg => ' Before call to insert_repository_references '
3020: );*/
3021:
3022: insert_repository_references (
3047: p_process_message => lv_process_message
3048: );
3049:
3050: /*commented by csahoo for bug# 6401388
3051: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3052: pv_log_msg => ' Return from insert_repository_references '
3053: );*/
3054:
3055: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3061: || Set out variables p_process_flag and p_process_message accordingly
3062: */
3063: --call to debug package
3064: /*commented by csahoo for bug# 6401388
3065: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3066: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
3067: );*/
3068:
3069: p_process_flag := lv_process_flag ;
3079: /*
3080: || Copy the taxes from the invoice/DM transaction to the TCS tax repository
3081: */
3082: /*commented by csahoo for bug# 6401388
3083: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3084: pv_log_msg => ' Before call to copy_taxes_from_source '
3085: );*/
3086:
3087: copy_taxes_from_source ( p_source_document_type => p_document_type ,
3091: p_process_flag => lv_process_flag ,
3092: p_process_message => lv_process_message
3093: );
3094: /*commented by csahoo for bug# 6401388
3095: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3096: pv_log_msg => ' Return from copy_taxes_from_source '
3097: );*/
3098: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3099: lv_process_flag = jai_constants.unexpected_error OR
3104: || Set out variables p_process_flag and p_process_message accordingly
3105: */
3106: --call to debug package
3107: /*commented by csahoo for bug# 6401388
3108: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3109: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
3110: );*/
3111:
3112: p_process_flag := lv_process_flag ;
3117: /*########################################################################################################
3118: || PROCESS AR CASH RECEIPT APPLICATIONS/UNAPPLICATIONS ---- PART -3
3119: ########################################################################################################*/
3120: /*commented by csahoo for bug# 6401388
3121: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3122: pv_log_msg => ' Cash receipt application processing '
3123: );*/
3124: /******
3125: ||Fetch all the latest applications related to the cash receipt
3135: || Call the procedure to process
3136: || cash receipt applications/unapplications
3137: *******************************************/
3138: /*commented by csahoo for bug# 6401388
3139: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3140: pv_log_msg => ' before call to jai_ar_tcs_rep_pkg.process_transactions '
3141: );*/
3142: jai_ar_tcs_rep_pkg.process_transactions ( p_araa => p_araa ,
3143: p_event => p_araa.application_type ,
3145: p_process_flag => lv_process_flag ,
3146: p_process_message => lv_process_message
3147: );
3148: /*commented by csahoo for bug# 6401388
3149: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3150: pv_log_msg => ' Return from jai_ar_tcs_rep_pkg.process_transactions '
3151: );*/
3152: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3153: lv_process_flag = jai_constants.unexpected_error OR
3158: || Set out variables p_process_flag and p_process_message accordingly
3159: */
3160: --call to debug package
3161: /*commented by csahoo for bug# 6401388
3162: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3163: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
3164: );*/
3165:
3166: p_process_flag := lv_process_flag ;
3181: ########################################################################################################*/
3182:
3183: ELSIF p_document_type = jai_constants.trx_type_rct_rvs THEN ---------C1
3184: /*commented by csahoo for bug# 6401388
3185: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3186: pv_log_msg => ' Start of receipt reversal processing '
3187: );*/
3188: OPEN cur_get_parent_transaction ( cp_source_document_id => p_acra.cash_receipt_id ,
3189: cp_source_document_type => jai_constants.ar_cash_tax_confirmed
3195: || If not found then receipt reversal also need not hit the repository.
3196: */
3197: IF CUR_GET_PARENT_TRANSACTION%FOUND THEN
3198: /*commented by csahoo for bug# 6401388
3199: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3200: pv_log_msg => ' Parent receipt confirmation record found parent_transaction_id -> '||ln_parent_transaction_id
3201: );*/
3202:
3203: copy_references ( p_parent_transaction_id => ln_parent_transaction_id ,
3217: || Set out variables p_process_flag and p_process_message accordingly
3218: */
3219: CLOSE cur_get_parent_transaction ;
3220: /*commented by csahoo for bug# 6401388
3221: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3222: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
3223: );*/
3224:
3225: p_process_flag := lv_process_flag ;
3229: END IF;
3230: CLOSE cur_get_parent_transaction ;
3231: END IF;
3232: /*commented by csahoo for bug# 6401388
3233: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3234: pv_log_msg => '**************** END OF PROCESS_RECEIPTS ****************'
3235: );
3236:
3237: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3233: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3234: pv_log_msg => '**************** END OF PROCESS_RECEIPTS ****************'
3235: );
3236:
3237: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3238: END process_receipts;
3239:
3240:
3241: PROCEDURE process_applications ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
3441: ########################################################################################################*/
3442: lv_member_name := 'PROCESS_APPLICATIONS';
3443: set_debug_context;
3444: /*commented by csahoo for bug# 6401388
3445: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
3446: pn_reg_id => ln_reg_id
3447: );*/
3448:
3449: /*commented by csahoo for bug# 6401388
3446: pn_reg_id => ln_reg_id
3447: );*/
3448:
3449: /*commented by csahoo for bug# 6401388
3450: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3451: pv_log_msg => ' Processing the APPLICATION record ' ||fnd_global.local_chr(10)
3452: ||', receivable_application_id -> ' ||p_araa.receivable_application_id ||fnd_global.local_chr(10)
3453: ||', application_type -> ' ||p_araa.application_type ||fnd_global.local_chr(10)
3454: ||', status -> ' ||p_araa.status ||fnd_global.local_chr(10)
3552: ln_app_amount := nvl(p_araa.amount_applied,0) * ln_exchange_rate ;
3553:
3554:
3555: /*commented by csahoo for bug# 6401388
3556: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3557: pv_log_msg => ' Values for the Internal FROm and TO variables are ' ||fnd_global.local_chr(10)
3558: ||', ln_app_to_doc_id -> ' ||ln_app_to_doc_id ||fnd_global.local_chr(10)
3559: ||', ln_app_to_doc_type -> ' ||ln_app_to_doc_type ||fnd_global.local_chr(10)
3560: ||', ln_app_to_doc_table -> ' ||ln_app_to_doc_table ||fnd_global.local_chr(10)
3585: || Also get the tcs amount based on the later document date
3586: ******/
3587: IF ld_app_fr_doc_date >= ld_app_to_doc_date THEN -----------A2
3588: /*commented by csahoo for bug# 6401388
3589: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3590: pv_log_msg => ' From date >= To date '||fnd_global.local_chr(10)
3591: ||', ld_app_fr_doc_date -> '||ld_app_fr_doc_date
3592: ||', ld_app_to_doc_date => '|| ld_app_to_doc_date ||fnd_global.local_chr(10)
3593: );*/
3612: || Applied To document is later
3613: */
3614:
3615: /*commented by csahoo for bug# 6401388
3616: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3617: pv_log_msg => ' To date is greater than from date '||fnd_global.local_chr(10)
3618: ||', ld_app_fr_doc_date -> '||ld_app_fr_doc_date ||fnd_global.local_chr(10)
3619: ||', ld_app_to_doc_date => '|| ld_app_to_doc_date
3620: );*/
3637: END IF; -----------A2
3638:
3639:
3640: /*commented by csahoo for bug# 6401388
3641: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3642: pv_log_msg => ' based on later date derivation logic values derived are ' ||fnd_global.local_chr(10)
3643: ||', ln_app_ref_doc_id -> ' ||ln_app_ref_doc_id ||fnd_global.local_chr(10)
3644: ||', ln_app_ref_doc_type -> ' ||ln_app_ref_doc_type ||fnd_global.local_chr(10)
3645: ||', ln_app_ref_doc_table -> ' ||ln_app_ref_doc_table ||fnd_global.local_chr(10)
3682: );
3683: FETCH cur_get_parent_transaction INTO ln_parent_transaction_id;
3684: CLOSE cur_get_parent_transaction ;
3685: /*commented by csahoo for bug# 6401388
3686: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3687: pv_log_msg => ' parent transaction id is (ln_parent_transaction_id)' ||ln_parent_transaction_id
3688: );*/
3689:
3690:
3698: FETCH cur_get_transaction_id INTO ln_transaction_id ;
3699: CLOSE cur_get_transaction_id ;
3700:
3701: /*commented by csahoo for bug# 6401388
3702: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3703: pv_log_msg => ' Before call to insert_repository_references '
3704: );*/
3705: insert_repository_references (
3706: p_regime_id => NULL ,
3731: );
3732:
3733:
3734: /*commented by csahoo for bug# 6401388
3735: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3736: pv_log_msg => ' Returned from call to insert_repository_references, lv_process_flag -> '||lv_process_flag
3737: );*/
3738: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3739: lv_process_flag = jai_constants.unexpected_error OR
3744: || Set out variables p_process_flag and p_process_message accordingly
3745: */
3746: --call to debug package
3747: /*commented by csahoo for bug# 6401388
3748: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3749: pv_log_msg => ' Error in procedure insert_repository_references '
3750: ||', p_process_flag -> '|| p_process_flag
3751: ||', lv_process_message -> '|| lv_process_message
3752: );*/
3758: /*########################################################################################################
3759: || COPY APPLICATION TAXES FROM SOURCE TRANSACTION TABLES INTO JAI_RGM_TAXES TABLE ---- PART -2
3760: ########################################################################################################*/
3761: /*commented by csahoo for bug# 6401388
3762: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3763: pv_log_msg => ' Before call to copy_taxes_from_source '
3764: );*/
3765: copy_taxes_from_source ( p_source_document_type => ln_app_ref_doc_type ,
3766: p_source_document_id => ln_app_ref_doc_id ,
3770: p_process_message => lv_process_message
3771: );
3772:
3773: /*commented by csahoo for bug# 6401388
3774: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3775: pv_log_msg => ' Returned from call to copy_taxes_from_source, lv_process_flag -> '||lv_process_flag
3776: );*/
3777: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3778: lv_process_flag = jai_constants.unexpected_error OR
3783: || Set out variables p_process_flag and p_process_message accordingly
3784: */
3785: --call to debug package
3786: /*commented by csahoo for bug# 6401388
3787: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3788: pv_log_msg => ' Error in procedure copy_taxes_from_source '
3789: ||', p_process_flag -> '|| p_process_flag
3790: ||', lv_process_message -> '|| lv_process_message
3791: );*/
3793: p_process_message := lv_process_message ;
3794: return;
3795: END IF; ---------A2
3796: /*commented by csahoo for bug# 6401388
3797: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3798: pv_log_msg => '**************** PROCEDURE PROCESS_APPLICATIONS SUCCESSFULLY COMPLETED ****************'
3799: );
3800: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3801: END process_applications;
3796: /*commented by csahoo for bug# 6401388
3797: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3798: pv_log_msg => '**************** PROCEDURE PROCESS_APPLICATIONS SUCCESSFULLY COMPLETED ****************'
3799: );
3800: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3801: END process_applications;
3802:
3803:
3804: PROCEDURE process_unapp_rcpt_rev ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL ,
3846: ########################################################################################################*/
3847: lv_member_name := 'PROCESS_UNAPP_RCPT_REV';
3848: set_debug_context;
3849: /*commented by csahoo for bug# 6401388
3850: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
3851: , pn_reg_id => ln_reg_id
3852: );*/
3853:
3854: lv_process_flag := jai_constants.successful ;
3860: /* IF p_document_type In ( jai_constants.trx_type_rct_unapp ,
3861: jai_constants.trx_type_cm_unapp
3862: )
3863: THEN
3864: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3865: pv_log_msg => ' Processing the UN APPLICATION record ' ||fnd_global.local_chr(10)
3866: ||', p_document_type -> ' ||p_document_type ||fnd_global.local_chr(10)
3867: ||', receivable_application_id -> ' ||p_araa.receivable_application_id ||fnd_global.local_chr(10)
3868: ||', application_type -> ' ||p_araa.application_type ||fnd_global.local_chr(10)
3875: ||', gl_date -> ' ||p_araa.gl_date ||fnd_global.local_chr(10)
3876: ||', org_id -> ' ||p_araa.org_id
3877: );
3878: ELSIF p_document_type = jai_constants.trx_type_rct_rvs THEN
3879: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3880: pv_log_msg => ' Processing the Receipt reversal record ' ||fnd_global.local_chr(10)
3881: ||', p_document_type -> ' ||p_document_type ||fnd_global.local_chr(10)
3882: ||', cash_receipt_id -> ' ||p_acra.cash_receipt_id||fnd_global.local_chr(10)
3883: ||', receipt_number -> ' ||p_acra.cash_receipt_id||fnd_global.local_chr(10)
3919: END IF;
3920:
3921:
3922: /*commented by csahoo for bug# 6401388
3923: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3924: pv_log_msg => ' Values derived for an application/reversal are ' ||fnd_global.local_chr(10)
3925: ||', ln_new_document_id -> ' ||ln_new_document_id ||fnd_global.local_chr(10)
3926: ||', ld_new_document_date -> ' ||ld_new_document_date ||fnd_global.local_chr(10)
3927: ||', ln_source_document_id -> ' ||ln_source_document_id ||fnd_global.local_chr(10)
3942: ) ;
3943: FETCH cur_get_parent_trx INTO ln_parent_transaction_id ;
3944:
3945: /*commented by csahoo for bug# 6401388
3946: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3947: pv_log_msg => ' Parent transaction is ->' ||ln_parent_transaction_id
3948: );*/
3949: /*
3950: || Check that the source receipt confirmation record has been found in the TCS repository.
3952: */
3953: IF CUR_GET_PARENT_TRX%FOUND THEN
3954: CLOSE cur_get_parent_trx ;
3955: /*commented by csahoo for bug# 6401388
3956: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3957: pv_log_msg => ' Parent transaction found, Before call to copy_references '
3958: );*/
3959: copy_references ( p_parent_transaction_id => ln_parent_transaction_id ,
3960: p_new_document_id => ln_new_document_id ,
3965: p_process_message => lv_process_message
3966: );
3967:
3968: /*commented by csahoo for bug# 6401388
3969: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3970: pv_log_msg => ' returned from call to copy_references lv_process_flag -> '||lv_process_flag
3971: );*/
3972: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3973: lv_process_flag = jai_constants.unexpected_error OR
3978: || Set out variables p_process_flag and p_process_message accordingly
3979: */
3980: --call to debug package
3981: /*commented by csahoo for bug# 6401388
3982: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3983: pv_log_msg => ' Error in processing copy references ' ||fnd_global.local_chr(10)
3984: ||',lv_process_flag -> '||lv_process_flag ||fnd_global.local_chr(10)
3985: ||',lv_process_message -> '||lv_process_message
3986: );*/
3994: */
3995: p_process_flag := jai_constants.not_applicable;
3996: END IF; /* Parent transaction found*/
3997: /*commented by csahoo for bug# 6401388
3998: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3999: pv_log_msg => '**************** PROCEDURE PROCESS_UNAPP_RCPT_REV SUCCESSFULLY COMPLETED ****************'
4000: );
4001: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4002: END process_unapp_rcpt_rev ;
3997: /*commented by csahoo for bug# 6401388
3998: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3999: pv_log_msg => '**************** PROCEDURE PROCESS_UNAPP_RCPT_REV SUCCESSFULLY COMPLETED ****************'
4000: );
4001: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4002: END process_unapp_rcpt_rev ;
4003:
4004:
4005: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
4054: ################################################################################################################*/
4055: lv_member_name := 'INSERT_REPOSITORY_REFERENCES';
4056: set_debug_context;
4057: /*commented by csahoo for bug# 6401388
4058: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
4059: , pn_reg_id => ln_reg_id
4060: );*/
4061:
4062: /*commented by csahoo for bug# 6401388
4059: , pn_reg_id => ln_reg_id
4060: );*/
4061:
4062: /*commented by csahoo for bug# 6401388
4063: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4064: pv_log_msg => ' PARAMETERS VALUES PASSED TO INSERT_REPOSITORY_REFERENCES : - ' ||fnd_global.local_chr(10)
4065: ||', p_regime_id -> '||p_regime_id ||fnd_global.local_chr(10)
4066: ||', p_transaction_id -> '||p_transaction_id ||fnd_global.local_chr(10)
4067: ||', p_source_ref_document_id -> '||p_source_ref_document_id ||fnd_global.local_chr(10)
4129: IF p_regime_id IS NULL OR
4130: p_org_tan_no IS NULL
4131: THEN
4132: /*commented by csahoo for bug# 6401388
4133: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4134: pv_log_msg => ' Derive regime values as they are null '
4135: );*/
4136: OPEN c_get_rgm_attribute ( cp_regime_code => jai_constants.tcs_regime ,
4137: cp_attribute_code => jai_constants.rgm_attr_code_org_tan ,
4146: END IF;
4147: CLOSE c_get_rgm_attribute;
4148:
4149: /*commented by csahoo for bug# 6401388
4150: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4151: pv_log_msg => 'Regime values are '
4152: ||', ln_regime_id -> '||ln_regime_id
4153: ||', lv_org_tan_no -> '||lv_org_tan_no
4154: );*/
4158: lv_org_tan_no := p_org_tan_no ;
4159: END IF;
4160:
4161: /*commented by csahoo for bug# 6401388
4162: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4163: pv_log_msg => 'Regime values are '
4164: ||', ln_regime_id -> '||ln_regime_id
4165: ||', lv_org_tan_no -> '||lv_org_tan_no
4166: );*/
4170: ################################################################################################################*/
4171:
4172:
4173: /*commented by csahoo for bug# 6401388
4174: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4175: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4176: ||', trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
4177: ||', regime_id -> '||ln_regime_id ||fnd_global.local_chr(10)
4178: ||', transaction_id -> '||p_transaction_id ||fnd_global.local_chr(10)
4282: NULL
4283: );
4284:
4285: /*commented by csahoo for bug# 6401388
4286: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4287: END insert_repository_references;
4288:
4289: procedure insert_repository_taxes (
4290: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4387: ################################################################################################################*/
4388: lv_member_name := 'INSERT_REPOSITORY_TAXES';
4389: set_debug_context;
4390: /*commented by csahoo for bug# 6401388
4391: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
4392: , pn_reg_id => ln_reg_id
4393: );*/
4394:
4395: /*commented by csahoo for bug# 6401388
4392: , pn_reg_id => ln_reg_id
4393: );*/
4394:
4395: /*commented by csahoo for bug# 6401388
4396: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4397: pv_log_msg => ' PARAMETERS VALUES PASSED TO INSERT_REPOSITORY_TAXES : - '||fnd_global.local_chr(10)
4398: ||', p_trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
4399: ||', p_tax_id -> '||p_tax_id ||fnd_global.local_chr(10)
4400: ||', p_tax_type -> '||p_tax_type ||fnd_global.local_chr(10)
4470: */
4471: ln_tax_modified_by := nvl(p_tax_modified_by ,jai_constants.tax_modified_by_system );
4472:
4473: /*commented by csahoo for bug# 6401388
4474: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4475: pv_log_msg => ' VALUES insert into JAI_RGM_TAXES are : - ' ||fnd_global.local_chr(10)
4476: ||', tax_det_id -> '||ln_tax_det_id ||fnd_global.local_chr(10)
4477: ||', trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
4478: ||', tax_type -> '||p_tax_type ||fnd_global.local_chr(10)
4525: ln_login_id
4526: );
4527:
4528: /*commented by csahoo for bug# 6401388
4529: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4530: pv_log_msg => ' Insert successful'
4531: );*/
4532: UPDATE
4533: jai_rgm_refs_all
4536: WHERE
4537: trx_ref_id = p_trx_ref_id;
4538:
4539: /*commented by csahoo for bug# 6401388
4540: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4541: pv_log_msg => ' jai_rgm_refs_all.total_tax_amt successfully updated '
4542: );*/
4543: /*commented by csahoo for bug# 6401388
4544: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4540: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4541: pv_log_msg => ' jai_rgm_refs_all.total_tax_amt successfully updated '
4542: );*/
4543: /*commented by csahoo for bug# 6401388
4544: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4545: pv_log_msg => '**************** END OF INSERT_REPOSITORY_TAXES ****************'
4546: );
4547: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4548: END insert_repository_taxes ;
4543: /*commented by csahoo for bug# 6401388
4544: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4545: pv_log_msg => '**************** END OF INSERT_REPOSITORY_TAXES ****************'
4546: );
4547: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4548: END insert_repository_taxes ;
4549:
4550:
4551: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4620: ########################################################################################################*/
4621: lv_member_name := 'COPY_TAXES_FROM_SOURCE';
4622: set_debug_context;
4623: /*commented by csahoo for bug# 6401388
4624: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
4625: , pn_reg_id => ln_reg_id
4626: );*/
4627:
4628: /*commented by csahoo for bug# 6401388
4625: , pn_reg_id => ln_reg_id
4626: );*/
4627:
4628: /*commented by csahoo for bug# 6401388
4629: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4630: pv_log_msg => ' PARAMETERS VALUES PASSED TO COPY_TAXES_FROM_SOURCE : - ' ||fnd_global.local_chr(10)
4631: ||', p_source_document_type -> '||p_source_document_type ||fnd_global.local_chr(10)
4632: ||', p_source_document_id -> '||p_source_document_id ||fnd_global.local_chr(10)
4633: ||', p_source_document_line_id -> '||p_source_document_line_id ||fnd_global.local_chr(10)
4663: || the TCS tax repository table jai_rgm_taxes
4664: ***/
4665:
4666: /*commented by csahoo for bug# 6401388
4667: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4668: pv_log_msg => ' copy TAXES From JAI_AR_TRX_TAX_LINES - p_source_document_type -> '||p_source_document_type
4669: );*/
4670: FOR rec_cur_get_inv_taxes IN cur_get_inv_taxes ( cp_customer_trx_id => p_source_document_id ,
4671: cp_customer_trx_line_id => p_source_document_line_id
4693: || Set out variables p_process_flag and p_process_message accordingly
4694: */
4695: --call to debug package
4696: /*commented by csahoo for bug# 6401388
4697: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4698: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
4699: );*/
4700:
4701: p_process_flag := lv_process_flag ;
4708: /*
4709: ||Source is receipt
4710: */
4711: /*commented by csahoo for bug# 6401388
4712: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4713: pv_log_msg => ' copy TAXES From jai_cmn_document_taxes - p_source_document_id -> '||p_source_document_id
4714: ||', p_source_document_type -> '||p_source_document_type
4715: );*/
4716: FOR rec_cur_get_rcpt_taxes IN cur_get_rcpt_taxes (cp_source_doc_id => p_source_document_id )
4737: || Set out variables p_process_flag and p_process_message accordingly
4738: */
4739: --call to debug package
4740: /*commented by csahoo for bug# 6401388
4741: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4742: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
4743: );*/
4744:
4745: p_process_flag := lv_process_flag ;
4750:
4751: END IF; --------------------------A1
4752:
4753: /*commented by csahoo for bug# 6401388
4754: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4755: pv_log_msg => '****************COPY_TAXES_FROM_SOURCE ENDS SUCCESSFULLY ****************'
4756: );
4757: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4758: END copy_taxes_from_source;
4753: /*commented by csahoo for bug# 6401388
4754: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4755: pv_log_msg => '****************COPY_TAXES_FROM_SOURCE ENDS SUCCESSFULLY ****************'
4756: );
4757: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4758: END copy_taxes_from_source;
4759:
4760: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4761: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4805:
4806: lv_member_name := 'COPY_REFERENCES';
4807: set_debug_context;
4808: /*commented by csahoo for bug# 6401388
4809: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
4810: , pn_reg_id => ln_reg_id
4811: );*/
4812:
4813: /*commented by csahoo for bug# 6401388
4810: , pn_reg_id => ln_reg_id
4811: );*/
4812:
4813: /*commented by csahoo for bug# 6401388
4814: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4815: pv_log_msg => ' PARAMETERS VALUES PASSED TO COPY_REFERENCES : - ' ||fnd_global.local_chr(10)
4816: ||', p_parent_transaction_id -> '||p_parent_transaction_id ||fnd_global.local_chr(10)
4817: ||', p_new_document_id -> '||p_new_document_id ||fnd_global.local_chr(10)
4818: ||', p_new_document_type -> '||p_new_document_type ||fnd_global.local_chr(10)
4852: CLOSE cur_get_trx_ref_id ;
4853:
4854:
4855: /*commented by csahoo for bug# 6401388
4856: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4857: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4858: ||', regime_id -> '||rec_cur_get_refs.regime_id ||fnd_global.local_chr(10)
4859: ||', trx_ref_id -> '||ln_trx_ref_id ||fnd_global.local_chr(10)
4860: ||', transaction_id -> '||ln_transaction_id ||fnd_global.local_chr(10)
4964: NULL
4965: );
4966:
4967: /*commented by csahoo for bug# 6401388
4968: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4969: pv_log_msg => ' After Insert into jai_rgm_refs_all'
4970: );*/
4971:
4972: /*
4982: FETCH cur_get_tax_det_id INTO ln_tax_det_id;
4983: CLOSE cur_get_tax_det_id;
4984:
4985: /*commented by csahoo for bug# 6401388
4986: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4987: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4988: ||', tax_det_id -> '||ln_tax_det_id ||fnd_global.local_chr(10)
4989: ||', trx_ref_id -> '||ln_trx_ref_id ||fnd_global.local_chr(10)
4990: ||', tax_type -> '||rec_cur_get_rgm_taxes.tax_type ||fnd_global.local_chr(10)
5037:
5038:
5039:
5040: /*commented by csahoo for bug# 6401388
5041: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5042: pv_log_msg => ' After Insert into jai_rgm_taxes '
5043: );*/
5044: END LOOP; /* End of tax population */
5045: END LOOP; /*End of jai_rgm_refs_all population */
5044: END LOOP; /* End of tax population */
5045: END LOOP; /*End of jai_rgm_refs_all population */
5046:
5047: /*commented by csahoo for bug# 6401388
5048: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5049: pv_log_msg => '**************** END OF COPY_REFERENCES ****************'
5050: );
5051:
5052: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
5048: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5049: pv_log_msg => '**************** END OF COPY_REFERENCES ****************'
5050: );
5051:
5052: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
5053: END copy_references;
5054:
5055:
5056: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
5090:
5091: lv_member_name := 'UPDATE_ITEM_GEN_DOCS';
5092: set_debug_context;
5093: /*commented by csahoo for bug# 6401388
5094: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
5095: pn_reg_id => ln_reg_id
5096: );
5097:
5098: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5094: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
5095: pn_reg_id => ln_reg_id
5096: );
5097:
5098: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5099: pv_log_msg => 'VALUES PASSED TO UPDATE_ITEM_GEN_DOCS ARE :- ' ||fnd_global.local_chr(10)
5100: ||', p_trx_number -> '||p_trx_number ||fnd_global.local_chr(10)
5101: ||', p_customer_trx_id -> '||p_customer_trx_id ||fnd_global.local_chr(10)
5102: ||', p_complete_flag -> '||p_complete_flag ||fnd_global.local_chr(10)
5138: /*
5139: ||Do nothing if the generated_doc_id is null and invoice is getting incompleted
5140: */
5141: /*commented by csahoo for bug# 6401388
5142: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5143: pv_log_msg => 'Skip the TCS ITEM GENDOCS update as :- ' ||fnd_global.local_chr(10)
5144: ||', p_complete_flag -> '||p_complete_flag ||fnd_global.local_chr(10)
5145: ||', ln_generated_doc_id -> '||ln_generated_doc_id
5146: );*/
5149: END IF;
5150: END IF;
5151:
5152: /*commented by csahoo for bug# 6401388
5153: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5154: pv_log_msg => 'valid transaction record found in table jai_rgm_item_gen_docs. Updating the table jai_rgm_item_gen_docs with ' ||fnd_global.local_chr(10)
5155: ||', generated_doc_id -> '||ln_generated_doc_id
5156: );*/
5157: UPDATE jai_rgm_item_gen_docs
5165: END IF;
5166: CLOSE cur_upd_gen_docs;
5167:
5168: /*commented by csahoo for bug# 6401388
5169: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5170: pv_log_msg => '**************** END OF UPDATE_ITEM_GEN_DOCS ****************'
5171: );
5172:
5173: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
5169: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5170: pv_log_msg => '**************** END OF UPDATE_ITEM_GEN_DOCS ****************'
5171: );
5172:
5173: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
5174:
5175: END update_item_gen_docs;
5176:
5177:
5270:
5271: lv_member_name := 'GENERATE_DOCUMENT';
5272: set_debug_context;
5273: /*commented by csahoo for bug# 6401388
5274: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
5275: pn_reg_id => ln_reg_id
5276: );
5277:
5278: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5274: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
5275: pn_reg_id => ln_reg_id
5276: );
5277:
5278: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5279: pv_log_msg => 'Parameter passed to GENERATE_DOCUMENT are -> ' ||fnd_global.local_chr(10)
5280: ||', transaction_id -> '||p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
5281: ||', p_total_tax_amt -> '||p_total_tax_amt ||fnd_global.local_chr(10)
5282: ||', source_document_type is -> '||p_rgm_ref.source_document_type ||fnd_global.local_chr(10)
5293: ||Skip the transaction if p_total_tax_amt is 0
5294: ################################################################################################################*/
5295: IF nvl(p_total_tax_amt,0) = 0 THEN
5296: /*commented by csahoo for bug# 6401388
5297: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5298: pv_log_msg => 'As transaction total_tax_amt is -> '||p_total_tax_amt||' hence skipping the transaction.'
5299: );*/
5300: p_process_flag := jai_constants.not_applicable ;
5301: return;
5305: ||Get batch source information
5306: ################################################################################################################*/
5307:
5308: /*commented by csahoo for bug# 6401388
5309: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5310: pv_log_msg => ' Deriving the batch source information '
5311: );*/
5312:
5313: /*
5336: || Derive the batch source name based on the document type
5337: ################################################################################################################*/
5338:
5339: /*commented by csahoo for bug# 6401388
5340: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5341: pv_log_msg => ' Deriving the batch source name based on the document type'
5342: );*/
5343:
5344: IF p_rgm_ref.source_document_type in ( jai_constants.ar_cash_tax_confirmed , /* Receipt confirmation */
5379: /*
5380: ||Skip the transaction
5381: */
5382: /*commented by csahoo for bug# 6401388
5383: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5384: pv_log_msg => 'Skip the transaction '
5385: );*/
5386: p_process_flag := jai_constants.not_applicable;
5387: p_process_message := null;
5396: || Error out if the batch source name is null i.e regime party setup for
5397: */
5398: IF lv_batch_src_name IS NULL THEN
5399: /*commented by csahoo for bug# 6401388
5400: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5401: pv_log_msg => 'Batch source definition has not be defined for the inventory organization '||p_rgm_ref.organization_id
5402: );*/
5403:
5404: p_process_flag := jai_constants.expected_error;
5408: END IF;
5409:
5410:
5411: /*commented by csahoo for bug# 6401388
5412: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5413: pv_log_msg => 'Document Type is lv_batch_src_name -> '||lv_batch_src_name
5414: );*/
5415:
5416: OPEN cur_get_batch_source ( cp_org_id => p_rgm_ref.org_id ,
5419:
5420: FETCH cur_get_batch_source INTO rec_cur_get_batch_source;
5421: IF cur_get_batch_source%NOTFOUND THEN
5422: /*commented by csahoo for bug# 6401388
5423: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5424: pv_log_msg => 'TCS batch source has not been defined '
5425: );*/
5426: CLOSE cur_get_batch_source ;
5427: p_process_flag := jai_constants.expected_error;
5431: END IF;
5432: CLOSE cur_get_batch_source ;
5433:
5434: /*commented by csahoo for bug# 6401388
5435: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5436: pv_log_msg => 'batch source details are:- ' ||fnd_global.local_chr(10)
5437: ||', lv_batch_src_name -> '||lv_batch_src_name ||fnd_global.local_chr(10)
5438: ||', rec_cur_get_batch_source.batch_source_id -> '||rec_cur_get_batch_source.batch_source_id ||fnd_global.local_chr(10)
5439: ||', rec_cur_get_batch_source.default_inv_trx_type -> '||rec_cur_get_batch_source.default_inv_trx_type ||fnd_global.local_chr(10)
5452: || This check is not required in case of credit memo
5453: */
5454: IF ln_term_id IS NULL THEN
5455: /*commented by csahoo for bug# 6401388
5456: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5457: pv_log_msg => 'Error:- Default term is not defined in the transction type -> '||rec_cur_get_batch_source.name
5458: );*/
5459: p_process_flag := jai_constants.expected_error;
5460: lv_process_message := 'Cannot process transaction. A default term needs to be defined FOR the Transaction TYPE '||rec_cur_get_batch_source.name ;
5474: ||Throw an error if the Set of books has not been defined
5475: */
5476: IF lv_set_of_books_id IS NULL THEN
5477: /*commented by csahoo for bug# 6401388
5478: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5479: pv_log_msg => 'Error:- Set of books not defined for org_id -> '||p_rgm_ref.org_id
5480: );*/
5481:
5482: p_process_flag := jai_constants.expected_error;
5501:
5502: IF ln_bill_to_address_id IS NULL THEN
5503:
5504: /*commented by csahoo for bug# 6401388
5505: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5506: pv_log_msg => 'Error:- Bill to address not defined for the customer id -> '||p_rgm_ref.party_id
5507: ||' customer site -> '||p_rgm_ref.party_site_id
5508: );*/
5509:
5546: || INSERT INTO RA_INTERFACE_LINES_ALL TABLE
5547: ################################################################################################################*/
5548:
5549: /*commented by csahoo for bug# 6401388
5550: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5551: pv_log_msg => 'Before inserting into the interface tables, Values are :- ' || fnd_global.local_chr(10)
5552: ||', interface_line_id -> '|| p_rgm_ref.transaction_id || fnd_global.local_chr(10)
5553: ||', i/p tax amount -> '|| p_total_tax_amt || fnd_global.local_chr(10)
5554: ||', document creation amount -> '|| ln_amount || fnd_global.local_chr(10)
5672: END IF;
5673: --bug#8214204,end*/
5674:
5675: /*commented by csahoo for bug# 6401388
5676: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5677: pv_log_msg => 'After Insert statement of the interface tables '
5678: );*/
5679:
5680:
5696: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
5697: || This is an error condition and the current processing has to be stopped
5698: **********************************************************************************************************/
5699: /*commented by csahoo for bug# 6401388
5700: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5701: pv_log_msg => 'Invalid code combination of TCS tax Accounting'
5702: );*/
5703: p_process_flag := jai_constants.expected_error;
5704: lv_process_message := 'Invalid Code combination ,please check the TCS Tax - Tax Accounting Setup';
5707: return;
5708: END IF;
5709:
5710: /*commented by csahoo for bug# 6401388
5711: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5712: pv_log_msg => 'Inserting values into ra_interface_distributions_all for REV row:- '||fnd_global.local_chr(10)
5713: ||', interface_line_id -> '|| p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
5714: ||', interface_line_context -> '|| lv_batch_src_name ||fnd_global.local_chr(10)
5715: ||', interface_line_attribute2 -> '|| p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
5759:
5760:
5761:
5762: /*commented by csahoo for bug# 6401388
5763: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5764: pv_log_msg => 'Inserting values into jai_rgm_item_gen_docs :- ' ||fnd_global.local_chr(10)
5765: ||', transaction_id -> '||p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
5766: ||', source_document_id -> '||p_rgm_ref.source_document_id ||fnd_global.local_chr(10)
5767: ||', source_document_type -> '||p_rgm_ref.source_document_type ||fnd_global.local_chr(10)
5805: ln_login_id
5806: );
5807:
5808: /*commented by csahoo for bug# 6401388
5809: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5810: pv_log_msg => 'Data successfully inserted into jai_rgm_item_gen_docs'
5811: );
5812:
5813:
5810: pv_log_msg => 'Data successfully inserted into jai_rgm_item_gen_docs'
5811: );
5812:
5813:
5814: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
5815: EXCEPTION
5816: WHEN OTHERS THEN
5817: p_process_flag := jai_constants.unexpected_error;
5818: p_process_message := ' Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document'||substr(SQLERRM,1,300) ;
5816: WHEN OTHERS THEN
5817: p_process_flag := jai_constants.unexpected_error;
5818: p_process_message := ' Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document'||substr(SQLERRM,1,300) ;
5819: /*commented by csahoo for bug# 6401388
5820: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5821: pv_log_msg => 'Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document -> '||substr(SQLERRM,1,300)
5822: );*/
5823:
5824: END generate_document;
6085:
6086: lv_member_name := 'PROCESS_TRANSACTIONS';
6087: set_debug_context;
6088: /*commented by csahoo for bug# 6401388
6089: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
6090: pn_reg_id => ln_reg_id
6091: );*/
6092: lv_process_flag := jai_constants.successful ;
6093: lv_process_message := null ;
6097: ln_event := p_event ;
6098:
6099:
6100: /*commented by csahoo for bug# 6401388
6101: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6102: pv_log_msg => '******************Start of JAI_AR_TC_SREP_PKG.PROCESS_TRANSACTIONS***************, Event is '||p_event
6103: );*/
6104:
6105:
6109: IF p_event = jai_constants.order_booked OR
6110: p_event = jai_constants.wsh_ship_confirm
6111: THEN ---------A1
6112: /*commented by csahoo for bug# 6401388
6113: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6114: pv_log_msg => '******************Before call to VALIDATE_SALES_ORDER/SHIP CONFIRM ***************, lv_document_type '||lv_document_type
6115: );*/
6116: validate_sales_order ( p_ooh => p_ooh ,
6117: p_process_flag => lv_process_flag ,
6118: p_process_message => lv_process_message
6119: );
6120:
6121: /*commented by csahoo for bug# 6401388
6122: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6123: pv_log_msg => '******************Returned from call to VALIDATE_SALES_ORDER/SHIP CONFIRM ***************, lv_process_flag '||lv_process_flag
6124: );*/
6125:
6126: IF lv_process_flag = jai_constants.not_applicable THEN
6124: );*/
6125:
6126: IF lv_process_flag = jai_constants.not_applicable THEN
6127: /*commented by csahoo for bug# 6401388
6128: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6129: pv_log_msg => 'Skip the transaction'
6130: );*/
6131: return;
6132: END IF;
6139: || Set out variables p_process_flag and p_process_message accordingly
6140: */
6141: --call to debug package
6142: /*commented by csahoo for bug# 6401388
6143: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6144: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
6145: );*/
6146:
6147: p_process_flag := lv_process_flag ;
6173: ########################################################################################################*/
6174: IF p_event = jai_constants.trx_event_completion THEN ---------B1
6175:
6176: /*commented by csahoo for bug# 6401388
6177: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6178: pv_log_msg => '******************Before call to VALIDATE_INVOICE ***************, lv_document_type '||lv_document_type
6179: );*/
6180: validate_invoice ( p_ract => p_ract ,
6181: p_document_type => lv_document_type ,
6183: p_process_message => lv_process_message
6184: );
6185:
6186: /*commented by csahoo for bug# 6401388
6187: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6188: pv_log_msg => '******************Returned from call to VALIDATE_INVOICE ***************, lv_process_flag '||lv_process_flag
6189: );*/
6190: IF lv_process_flag = jai_constants.not_applicable THEN
6191: /*commented by csahoo for bug# 6401388
6188: pv_log_msg => '******************Returned from call to VALIDATE_INVOICE ***************, lv_process_flag '||lv_process_flag
6189: );*/
6190: IF lv_process_flag = jai_constants.not_applicable THEN
6191: /*commented by csahoo for bug# 6401388
6192: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6193: pv_log_msg => 'Skip the transaction'
6194: );*/
6195: return;
6196: END IF;
6203: || Set out variables p_process_flag and p_process_message accordingly
6204: */
6205: --call to debug package
6206: /*commented by csahoo for bug# 6401388
6207: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6208: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
6209: );*/
6210:
6211: p_process_flag := lv_process_flag ;
6220: );
6221:
6222: IF lv_process_flag = jai_constants.not_applicable THEN
6223: /*commented by csahoo for bug# 6401388
6224: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6225: pv_log_msg => 'Skip the transaction'
6226: );*/
6227:
6228: return;
6237: || Set out variables p_process_flag and p_process_message accordingly
6238: */
6239: --call to debug package
6240: /*commented by csahoo for bug# 6401388
6241: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6242: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
6243: );*/
6244:
6245: p_process_flag := lv_process_flag ;
6258: THEN
6259: lv_document_type := p_event;
6260:
6261: /*commented by csahoo for bug# 6401388
6262: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6263: pv_log_msg => ' Before call to validate_receipts : - p_event -> '||p_event
6264: );*/
6265: validate_receipts ( p_acra => p_acra ,
6266: p_document_type => lv_document_type ,
6268: p_process_message => lv_process_message
6269: );
6270:
6271: /*commented by csahoo for bug# 6401388
6272: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6273: pv_log_msg => ' Returned from validate_receipts lv_process_flag: '||lv_process_flag
6274: );*/
6275: IF lv_process_flag = jai_constants.not_applicable THEN
6276: /*commented by csahoo for bug# 6401388
6273: pv_log_msg => ' Returned from validate_receipts lv_process_flag: '||lv_process_flag
6274: );*/
6275: IF lv_process_flag = jai_constants.not_applicable THEN
6276: /*commented by csahoo for bug# 6401388
6277: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6278: pv_log_msg => 'Skip the transaction'
6279: );*/
6280:
6281: return;
6289: || Set out variables p_process_flag and p_process_message accordingly
6290: */
6291: --call to debug package
6292: /*commented by csahoo for bug# 6401388
6293: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6294: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
6295: );*/
6296:
6297: p_process_flag := lv_process_flag ;
6298: p_process_message := lv_process_message ;
6299: return;
6300: END IF; ---------C2
6301: /*commented by csahoo for bug# 6401388
6302: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6303: pv_log_msg => ' Before call to process_receipts : - p_event -> '||p_event
6304: );*/
6305:
6306: process_receipts ( p_acra => p_acra ,
6308: p_process_flag => lv_process_flag ,
6309: p_process_message => lv_process_message
6310: );
6311: /*commented by csahoo for bug# 6401388
6312: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6313: pv_log_msg => ' Returned from process_receipts lv_process_flag: '||lv_process_flag
6314: );*/
6315:
6316: IF lv_process_flag = jai_constants.not_applicable THEN
6314: );*/
6315:
6316: IF lv_process_flag = jai_constants.not_applicable THEN
6317: /*commented by csahoo for bug# 6401388
6318: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6319: pv_log_msg => 'Skip the transaction'
6320: );*/
6321:
6322: return;
6330: || Set out variables p_process_flag and p_process_message accordingly
6331: */
6332: --call to debug package
6333: /*commented by csahoo for bug# 6401388
6334: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6335: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
6336: );*/
6337:
6338: p_process_flag := lv_process_flag ;
6353: /***********
6354: ||Validate application and unapplications
6355: ***********/
6356: /*commented by csahoo for bug# 6401388
6357: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6358: pv_log_msg => ' Before call to validate_app_unapp : - p_event -> '||p_event
6359: );*/
6360:
6361: validate_app_unapp (
6366: p_process_message => lv_process_message
6367: );
6368:
6369: /*commented by csahoo for bug# 6401388
6370: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6371: pv_log_msg => ' Returned from validate_app_unapp lv_process_flag: '||lv_process_flag
6372: );*/
6373:
6374: IF lv_process_flag = jai_constants.not_applicable THEN
6372: );*/
6373:
6374: IF lv_process_flag = jai_constants.not_applicable THEN
6375: /*commented by csahoo for bug# 6401388
6376: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6377: pv_log_msg => 'Skip the transaction'
6378: );*/
6379: return;
6380: END IF;
6388: || Set out variables p_process_flag and p_process_message accordingly
6389: */
6390: --call to debug package
6391: /*commented by csahoo for bug# 6401388
6392: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6393: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
6394: );*/
6395:
6396: p_process_flag := lv_process_flag ;
6403: jai_constants.trx_type_cm_app
6404: )
6405: THEN
6406: /*commented by csahoo for bug# 6401388
6407: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6408: pv_log_msg => ' Before call to process_applications : - p_event -> '||p_event
6409: );*/
6410:
6411: process_applications ( p_araa => p_araa ,
6414: p_process_flag => lv_process_flag ,
6415: p_process_message => lv_process_message
6416: );
6417: /*commented by csahoo for bug# 6401388
6418: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6419: pv_log_msg => ' Returned from process_applications lv_process_flag: '||lv_process_flag
6420: );*/
6421:
6422: ELSIF lv_document_type IN ( jai_constants.trx_type_rct_unapp, ---------D3
6423: jai_constants.trx_type_cm_unapp
6424: )
6425: THEN
6426: /*commented by csahoo for bug# 6401388
6427: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6428: pv_log_msg => ' Before call to process_unapp_rcpt_rev : - p_event -> '||p_event
6429: );*/
6430:
6431: process_unapp_rcpt_rev ( p_araa => p_araa ,
6435: p_process_message => lv_process_message
6436: );
6437:
6438: /*commented by csahoo for bug# 6401388
6439: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6440: pv_log_msg => ' Returned from process_unapp_rcpt_rev lv_process_flag: '||lv_process_flag
6441: );*/
6442:
6443: END IF; ---------D3
6443: END IF; ---------D3
6444:
6445: IF lv_process_flag = jai_constants.not_applicable THEN ---------D4
6446: /*commented by csahoo for bug# 6401388
6447: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6448: pv_log_msg => 'Skip the transaction'
6449: );*/
6450:
6451: return;
6459: || Set out variables p_process_flag and p_process_message accordingly
6460: */
6461: --call to debug package
6462: /*commented by csahoo for bug# 6401388
6463: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6464: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
6465: );*/
6466:
6467: p_process_flag := lv_process_flag ;
6481: jai_constants.ar_invoice_type_cm
6482: )
6483: THEN
6484: /*commented by csahoo for bug# 6401388
6485: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6486: pv_log_msg => ' Before call to generate_document : - p_event -> '||p_event
6487: );*/
6488:
6489:
6502: p_process_message => lv_process_message
6503: );
6504:
6505: /*commented by csahoo for bug# 6401388
6506: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6507: pv_log_msg => ' Returned from generate_document lv_process_flag: '||lv_process_flag
6508: );*/
6509:
6510: IF lv_process_flag = jai_constants.not_applicable THEN ---------D4
6508: );*/
6509:
6510: IF lv_process_flag = jai_constants.not_applicable THEN ---------D4
6511: /*commented by csahoo for bug# 6401388
6512: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6513: pv_log_msg => 'Skip the transaction'
6514: );*/
6515:
6516: return;
6524: || Set out variables p_process_flag and p_process_message accordingly
6525: */
6526: --call to debug package
6527: /*commented by csahoo for bug# 6401388
6528: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6529: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
6530: );*/
6531:
6532: p_process_flag := lv_process_flag ;
6544: */
6545: IF ln_transaction_id IS NOT NULL THEN
6546:
6547: /*commented by csahoo for bug# 6401388
6548: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6549: pv_log_msg => ' Before call to jai_rgm_thhold_proc_pkg.maintain_threshold : - p_event -> '||p_event
6550: ||', ln_transaction_id -> '||ln_transaction_id
6551: );*/
6552:
6555: p_process_message => lv_process_message
6556: );
6557:
6558: /*commented by csahoo for bug# 6401388
6559: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6560: pv_log_msg => ' Returned from jai_rgm_thhold_proc_pkg.maintain_threshold lv_process_flag: '||lv_process_flag
6561: );*/
6562:
6563: IF lv_process_flag = jai_constants.not_applicable THEN
6561: );*/
6562:
6563: IF lv_process_flag = jai_constants.not_applicable THEN
6564: /*commented by csahoo for bug# 6401388
6565: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6566: pv_log_msg => 'Skip the transaction'
6567: );*/
6568:
6569: return;
6577: || Set out variables p_process_flag and p_process_message accordingly
6578: */
6579: --call to debug package
6580: /*commented by csahoo for bug# 6401388
6581: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6582: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
6583: );*/
6584:
6585: p_process_flag := lv_process_flag ;
6588: END IF; ---------D2
6589: END IF;
6590:
6591: /*commented by csahoo for bug# 6401388
6592: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6593: pv_log_msg => '**************** END OF PROCESS TRANSACTION ****************'
6594: );
6595:
6596:
6593: pv_log_msg => '**************** END OF PROCESS TRANSACTION ****************'
6594: );
6595:
6596:
6597: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
6598: EXCEPTION
6599: WHEN OTHERS THEN
6600: p_process_flag := jai_constants.unexpected_error;
6601: p_process_message := lv_context||' Unexpected error occured while processing jai_ar_tcs_rep_pkg.process_transactions'||SQLERRM ;
6599: WHEN OTHERS THEN
6600: p_process_flag := jai_constants.unexpected_error;
6601: p_process_message := lv_context||' Unexpected error occured while processing jai_ar_tcs_rep_pkg.process_transactions'||SQLERRM ;
6602: /*commented by csahoo for bug# 6401388
6603: jai_cmn_debug_contexts_pkg.print( pn_reg_id => ln_reg_id ,
6604: pv_log_msg => p_process_message ,
6605: pn_statement_level => jai_cmn_debug_contexts_pkg.summary
6606: );
6607:
6601: p_process_message := lv_context||' Unexpected error occured while processing jai_ar_tcs_rep_pkg.process_transactions'||SQLERRM ;
6602: /*commented by csahoo for bug# 6401388
6603: jai_cmn_debug_contexts_pkg.print( pn_reg_id => ln_reg_id ,
6604: pv_log_msg => p_process_message ,
6605: pn_statement_level => jai_cmn_debug_contexts_pkg.summary
6606: );
6607:
6608: jai_cmn_debug_contexts_pkg.print_stack;*/
6609:
6604: pv_log_msg => p_process_message ,
6605: pn_statement_level => jai_cmn_debug_contexts_pkg.summary
6606: );
6607:
6608: jai_cmn_debug_contexts_pkg.print_stack;*/
6609:
6610: END process_transactions ;
6611:
6612: PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
6628:
6629: lv_member_name := 'UPDATE_PAN_FOR_TCS';
6630: set_debug_context;
6631: /*commented by csahoo for bug# 6401388
6632: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
6633: pn_reg_id => ln_reg_id
6634: );
6635:
6636: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6632: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
6633: pn_reg_id => ln_reg_id
6634: );
6635:
6636: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6637: pv_log_msg => 'Parameter passed to update_pan_for_tcs are -> ' ||fnd_global.local_chr(10)
6638: ||', p_party_id -> '||p_party_id ||fnd_global.local_chr(10)
6639: ||', p_old_pan_no -> '||p_old_pan_no ||fnd_global.local_chr(10)
6640: ||', p_new_pan_no -> '||p_new_pan_no
6645: ln_request_id := fnd_global.conc_request_id;
6646:
6647:
6648: /*commented by csahoo for bug# 6401388
6649: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6650: pv_log_msg => 'Updating the table JAI_CMN_CUS_ADDRESSES'
6651: );*/
6652:
6653: /*
6661: customer_id = p_party_id
6662: AND pan_no = p_old_pan_no ;
6663:
6664: /*commented by csahoo for bug# 6401388
6665: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6666: pv_log_msg => 'Update to table JAI_CMN_CUS_ADDRESSES successful. Now updating the table jai_rgm_thresholds '
6667: );*/
6668:
6669:
6679: AND party_pan_no = p_old_pan_no ;
6680:
6681:
6682: /*commented by csahoo for bug# 6401388
6683: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6684: pv_log_msg => '**************** UPDATE_PAN_FOR_TCS SUCCESSFULLY COMPLETED ****************'
6685: );
6686: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
6687:
6682: /*commented by csahoo for bug# 6401388
6683: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6684: pv_log_msg => '**************** UPDATE_PAN_FOR_TCS SUCCESSFULLY COMPLETED ****************'
6685: );
6686: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
6687:
6688: EXCEPTION
6689: WHEN OTHERS THEN
6690: p_return_code := 2;