[Home] [Help]
2: /* $Header: jai_tcs_repo_pkg.plb 120.11.12010000.2 2008/08/07 13:51:04 jmeena 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: *****/
132: set_debug_context;
133:
134:
135: /*commented by csahoo for bug# 6401388
136: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
137: pn_reg_id => ln_reg_id
138: );*/
139: p_process_flag := jai_constants.successful ;
140: p_process_message := null ;
161: || by calling the function jai_cmn_rgm_recording_pkg.get_account
162: *********************************************************************************************************/
163:
164: /*commented by csahoo for bug# 6401388
165: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
166: pv_log_msg => 'Before call to jai_cmn_rgm_recording_pkg.get_account for int liab'
167: );*/
168: v_liab_acc_ccid := jai_cmn_rgm_recording_pkg.get_account (
169: p_regime_id => rec_cur_get_picking_taxes.regime_id ,
174: p_account_name => jai_constants.liability
175: );
176:
177: /*commented by csahoo for bug# 6401388
178: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
179: pv_log_msg => 'Before call to jai_cmn_rgm_recording_pkg.get_account for liab'
180: );*/
181: v_int_liab_acc_ccid := jai_cmn_rgm_recording_pkg.get_account (
182: p_regime_id => rec_cur_get_picking_taxes.regime_id ,
196: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
197: || This is an error condition and the current processing has to be stopped
198: **********************************************************************************************************/
199: /*commented by csahoo for bug# 6401388
200: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
201: pv_log_msg => 'Error in call to jai_cmn_rgm_recording_pkg.get_account'
202: );*/
203: p_process_flag := jai_constants.expected_error;
204: p_process_message := 'Invalid Code combination ,please check the TCS Tax - Tax Accounting Setup';
209: /*
210: ||Credit the liability account
211: */
212: /*commented by csahoo for bug# 6401388
213: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
214: PV_LOG_MSG => 'CREDIT MEMO ENTRIES GETTING PASSED TO jai_cmn_gl_pkg.create_gl_entry ARE :- ' ||fnd_global.local_chr(10)
215: ||', p_organization_id -> '|| p_organization_id ||fnd_global.local_chr(10)
216: ||', p_currency_code -> '|| p_currency_code ||fnd_global.local_chr(10)
217: ||', p_credit_amount -> '|| round(rec_cur_get_picking_taxes.func_tax_amount) ||fnd_global.local_chr(10)
255: /*
256: ||Debit the Interim liability account
257: */
258: /*
259: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
260: pv_log_msg => 'DEBIT MEMO ENTRIES GETTING PASSED TO jai_cmn_gl_pkg.create_gl_entry ARE :- '||fnd_global.local_chr(10)
261: ||', p_organization_id -> '|| p_organization_id ||fnd_global.local_chr(10)
262: ||', p_currency_code -> '|| p_currency_code ||fnd_global.local_chr(10)
263: ||', p_credit_amount -> '|| 0 ||fnd_global.local_chr(10)
298:
299: END LOOP;
300:
301: /*commented by csahoo for bug# 6401388
302: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
303: pv_log_msg => '**************** WSH_INTERIM_ACCOUNTING SUCCESSFULLY COMPLETED ****************'
304: );
305: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
306:
301: /*commented by csahoo for bug# 6401388
302: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
303: pv_log_msg => '**************** WSH_INTERIM_ACCOUNTING SUCCESSFULLY COMPLETED ****************'
304: );
305: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
306:
307: EXCEPTION
308: WHEN OTHERS THEN
309: p_process_flag := jai_constants.unexpected_error;
369: lv_category_name := 'Receivables India' ; -- modified by csahoo for bug#6155839
370: set_debug_context;
371:
372:
373: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
374: pn_reg_id => ln_reg_id
375: ); --commmented by CSahoo, BUG#5631784*/
376: p_process_flag := jai_constants.successful ;
377: p_process_message := null ;
399: || by calling the function jai_cmn_rgm_recording_pkg.get_account
400: *********************************************************************************************************/
401:
402: /*commented by csahoo for bug# 6401388
403: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
404: pv_log_msg => 'Before call to jai_cmn_rgm_recording_pkg.get_account for int liab'
405: );*/
406: v_liab_acc_ccid := jai_cmn_rgm_recording_pkg.get_account (
407: p_regime_id => rec_cur_get_inv_det.regime_id ,
412: p_account_name => jai_constants.liability
413: );
414:
415: /*commented by csahoo for bug# 6401388
416: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
417: pv_log_msg => 'Before call to jai_cmn_rgm_recording_pkg.get_account for liab'
418: );*/
419: v_int_liab_acc_ccid := jai_cmn_rgm_recording_pkg.get_account (
420: p_regime_id => rec_cur_get_inv_det.regime_id ,
434: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
435: || This is an error condition and the current processing has to be stopped
436: **********************************************************************************************************/
437: /*commented by csahoo for bug# 6401388
438: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
439: pv_log_msg => 'Error in call to jai_cmn_rgm_recording_pkg.get_account'
440: );*/
441: p_process_flag := jai_constants.expected_error;
442: p_process_message := 'Invalid Code combination ,please check the TCS Tax - Tax Accounting Setup';
447: /*
448: ||Credit the liability account
449: */
450: /*commented by csahoo for bug# 6401388
451: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
452: PV_LOG_MSG => 'CREDIT MEMO ENTRIES GETTING PASSED TO jai_cmn_gl_pkg.create_gl_entry ARE :- ' ||fnd_global.local_chr(10)
453: ||', p_organization_id -> '|| rec_cur_get_inv_det.organization_id ||fnd_global.local_chr(10)
454: ||', p_currency_code -> '|| p_ract.invoice_currency_code ||fnd_global.local_chr(10)
455: ||', p_credit_amount -> '|| round(rec_cur_get_inv_det.func_tax_amount) ||fnd_global.local_chr(10)
493: /*
494: ||Debit the Interim liability account
495: */
496: /*commented by csahoo for bug# 6401388
497: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
498: pv_log_msg => 'DEBIT MEMO ENTRIES GETTING PASSED TO jai_cmn_gl_pkg.create_gl_entry ARE :- '||fnd_global.local_chr(10)
499: ||', p_organization_id -> '|| rec_cur_get_inv_det.organization_id ||fnd_global.local_chr(10)
500: ||', p_currency_code -> '|| p_ract.invoice_currency_code ||fnd_global.local_chr(10)
501: ||', p_credit_amount -> '|| 0 ||fnd_global.local_chr(10)
537:
538: END LOOP;
539:
540: /*commented by csahoo for bug# 6401388
541: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
542: pv_log_msg => '**************** MAN_AR_COMPLETION_ACCOUNTING SUCCESSFULLY COMPLETED ****************'
543: );
544: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
545:
540: /*commented by csahoo for bug# 6401388
541: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
542: pv_log_msg => '**************** MAN_AR_COMPLETION_ACCOUNTING SUCCESSFULLY COMPLETED ****************'
543: );
544: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
545:
546: EXCEPTION
547: WHEN OTHERS THEN
548: p_process_flag := jai_constants.unexpected_error;
617: JAI_OM_OE_SO_LINES jsl
618: WHERE
619: jsl.header_id = cp_header_id;
620:
621: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;
622: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
623: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
624:
625: ln_exists NUMBER ;
618: WHERE
619: jsl.header_id = cp_header_id;
620:
621: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;
622: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
623: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
624:
625: ln_exists NUMBER ;
626: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
619: jsl.header_id = cp_header_id;
620:
621: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE ;
622: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
623: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
624:
625: ln_exists NUMBER ;
626: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
627: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
637: lv_member_name := 'VALIDATE_SALES_ORDER';
638: lv_object_name := 'TCS.JAI_AR_TCS_REP_PKG';
639: set_debug_context;
640: /*commented by csahoo for bug# 6401388
641: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
642: pn_reg_id => ln_reg_id
643: );*/
644: lv_process_flag := jai_constants.successful ;
645: lv_process_message := null ;
657: IF ln_event = jai_constants.order_booked AND
658: p_ooh.flow_status_code <> jai_constants.order_booked
659: THEN
660: /*commented by csahoo for bug# 6401388
661: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
662: pv_log_msg => ' Skip the transaction as order has a flow status code as '|| p_ooh.flow_status_code ||' which is different from BOOKED '
663: );*/
664: p_process_flag := jai_constants.not_applicable ;
665: return;
674: OPEN cur_chk_tcs_applicable ( cp_header_id => p_ooh.header_id ) ;
675: FETCH cur_chk_tcs_applicable INTO ln_exists ;
676: IF CUR_CHK_TCS_APPLICABLE%NOTFOUND THEN
677: /*commented by csahoo for bug# 6401388
678: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
679: pv_log_msg => ' Skip as order does not have TCS type of taxes '
680: );*/
681: p_process_flag := jai_constants.not_applicable ;
682: return;
706: ||Rows with no TCS type of taxes exists hence error out
707: */
708: CLOSE cur_chk_tcs_for_all_lines ;
709: /*commented by csahoo for bug# 6401388
710: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
711: 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)
712: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
713: ||', lv_process_message -> '||lv_process_message
714: );*/
749: || Set out variables p_process_flag and p_process_message accordingly
750: */
751: --call to debug package
752: /*commented by csahoo for bug# 6401388
753: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
754: pv_log_msg => 'Error In processing of jai_inv_items_pkg.jai_get_attrib'||fnd_global.local_chr(10)
755: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
756: ||', lv_process_message -> '||lv_process_message
757: );*/
773: || then stop the transaction and throw an error.
774: */
775: IF nvl(lv_first_itm_class,'$$') <> nvl(lv_item_classification,'###') THEN
776: /*commented by csahoo for bug# 6401388
777: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
778: 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)
779: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
780: ||', lv_process_message -> '||lv_process_message
781: );*/
788:
789: END IF;
790:
791: /*commented by csahoo for bug# 6401388
792: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
793: pv_log_msg => '**************** VALIDATE_SALES_ORDER SUCCESSFULLY COMPLETED ****************'
794: );
795: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
796:
791: /*commented by csahoo for bug# 6401388
792: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
793: pv_log_msg => '**************** VALIDATE_SALES_ORDER SUCCESSFULLY COMPLETED ****************'
794: );
795: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
796:
797:
798: END validate_sales_order ;
799:
941: lv_member_name := 'VALIDATE_INVOICE';
942: set_debug_context;
943:
944: /*commented by csahoo for bug# 6401388
945: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
946: pn_reg_id => ln_reg_id
947: );*/
948:
949: lv_process_flag := jai_constants.successful ;
952: p_process_flag := lv_process_flag ;
953: p_process_message := lv_process_message ;
954:
955: /*commented by csahoo for bug# 6401388
956: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
957: pv_log_msg => ' Validating the Document '||fnd_global.local_chr(10)
958: ||', p_ract.trx_number -> '||p_ract.trx_number ||fnd_global.local_chr(10)
959: ||', p_ract.customer_trx_id -> '||p_ract.customer_trx_id
960: );*/
961: /*########################################################################################################
962: || CHECK TCS APPLICABILITY PART -2
963: ########################################################################################################*/
964: /*commented by csahoo for bug# 6401388
965: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
966: pv_log_msg => ' Check TCS applicability '
967: );*/
968: /*
969: || Check whether the TCS is applicable on the document if no
972: OPEN cur_chk_tcs_applicable ( cp_customer_trx_id => p_ract.customer_trx_id );
973: FETCH cur_chk_tcs_applicable INTO ld_source_doc_date ,ln_organization_id;
974: IF cur_chk_tcs_applicable%NOTFOUND THEN
975: /*commented by csahoo for bug# 6401388
976: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
977: pv_log_msg => ' TCS taxes not present on Invoice '
978: );*/
979: CLOSE cur_chk_tcs_applicable ;
980: /*
982: || IF yes punch/reset to null, the customer_trx_id into jai_rgm_item_gen_docs.generated_doc_id based on the
983: ||complete flag
984: */
985: /*commented by csahoo for bug# 6401388
986: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
987: pv_log_msg => 'Call to procedure update_item_gen_docs to check whether this is the TCS secondary document'
988: );*/
989:
990: update_item_gen_docs ( p_trx_number => p_ract.trx_number ,
994: p_process_flag => lv_process_flag ,
995: p_process_message => lv_process_message
996: );
997: /*commented by csahoo for bug# 6401388
998: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
999: pv_log_msg => 'returned from update_item_gen_docs lv_process_flag -> '||fnd_global.local_chr(10)
1000: ||', lv_process_flag -> '|| lv_process_flag || fnd_global.local_chr(10)
1001: ||', lv_process_message -> '|| lv_process_message || fnd_global.local_chr(10)
1002: );*/
1001: ||', lv_process_message -> '|| lv_process_message || fnd_global.local_chr(10)
1002: );*/
1003:
1004: /*commented by csahoo for bug# 6401388
1005: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1006: pv_log_msg => 'Skip furthur processing as Invoice does not have TCS type of taxes '
1007: );*/
1008:
1009: p_process_flag := lv_process_flag ;
1014: END IF;
1015: CLOSE cur_chk_tcs_applicable ;
1016:
1017: /*commented by csahoo for bug# 6401388
1018: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1019: pv_log_msg => ' Document Parameters '||fnd_global.local_chr(10)
1020: ||', source_doc_date -> '||ld_source_doc_date ||fnd_global.local_chr(10)
1021: ||', organization_id-> '||ln_organization_id
1022: );*/
1028: FETCH cur_get_doc_det INTO lv_trx_type;
1029: CLOSE cur_get_doc_det ;
1030:
1031: /*commented by csahoo for bug# 6401388
1032: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1033: pv_log_msg => ' Current document type is '||lv_trx_type
1034: );*/
1035: /*
1036: || Return if document type is a credit memo
1037: || as there is no functionality around a Credit Memo Completion/Incompletion
1038: */
1039: IF lv_trx_type = 'CM' THEN
1040: /*commented by csahoo for bug# 6401388
1041: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1042: pv_log_msg => ' Current document is a CM hence SKIP'
1043: );*/
1044: p_process_flag := jai_constants.not_applicable;
1045: return;
1051:
1052: IF ln_event = jai_constants.trx_event_completion THEN
1053:
1054: /*commented by csahoo for bug# 6401388
1055: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1056: pv_log_msg => ' Event is -> '||ln_event
1057: );*/
1058:
1059: /*########################################################################################################
1063:
1064: IF p_ract.complete_flag = jai_constants.yes THEN
1065:
1066: /*commented by csahoo for bug# 6401388
1067: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1068: pv_log_msg => ' Complete -> '||p_ract.complete_flag
1069: );*/
1070:
1071: IF lv_trx_type IN (jai_constants.ar_invoice_type_inv,jai_constants.ar_doc_type_dm) THEN
1074: */
1075: lv_doc_type := jai_constants.trx_type_inv_comp;
1076: ELSE
1077: /*commented by csahoo for bug# 6401388
1078: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1079: pv_log_msg => ' Skip as type -> '||lv_trx_type ||' not applicable for TCS processing '
1080: );*/
1081: p_process_flag := jai_constants.not_applicable;
1082: return;
1092: */
1093: lv_doc_type := jai_constants.trx_type_inv_incomp;
1094: ELSE
1095: /*commented by csahoo for bug# 6401388
1096: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1097: pv_log_msg => ' Skip as type -> '||lv_trx_type ||' not applicable for TCS processing '
1098: );*/
1099: p_process_flag := jai_constants.not_applicable;
1100: return;
1123: OPEN cur_chk_tcs_settlement ( cp_customer_trx_id => p_ract.customer_trx_id );
1124: FETCH cur_chk_tcs_settlement INTO ln_exists;
1125: IF CUR_CHK_TCS_SETTLEMENT%FOUND THEN
1126: /*commented by csahoo for bug# 6401388
1127: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1128: pv_log_msg => 'Error :- Cannot Incomplete the invoice if it has already been settled '||fnd_global.local_chr(10)
1129: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1130: ||', lv_process_message -> '||lv_process_message
1131: );*/
1159: ||Rows with no TCS type of taxes exists hence error out
1160: */
1161: CLOSE cur_chk_tcs_for_all_lines ;
1162: /*commented by csahoo for bug# 6401388
1163: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1164: pv_log_msg => 'Error :- Cannot complete the invoice if some lines have TCS type of tax and some dont '||fnd_global.local_chr(10)
1165: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1166: ||', lv_process_message -> '||lv_process_message
1167: );*/
1200: || Set out variables p_process_flag and p_process_message accordingly
1201: */
1202: --call to debug package
1203: /*commented by csahoo for bug# 6401388
1204: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1205: pv_log_msg => 'Error In processing of jai_inv_items_pkg.jai_get_attrib'||fnd_global.local_chr(10)
1206: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1207: ||', lv_process_message -> '||lv_process_message
1208: );*/
1224: || then stop the transaction and throw an error.
1225: */
1226: IF nvl(lv_first_itm_class,'$$') <> nvl(lv_item_classification,'###') THEN
1227: /*commented by csahoo for bug# 6401388
1228: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1229: pv_log_msg => 'Error :- Cannot complete as all lines do not belong to the same Item Classification '||fnd_global.local_chr(10)
1230: ||', lv_process_flag -> '|| lv_process_flag ||fnd_global.local_chr(10)
1231: ||', lv_process_message -> '||lv_process_message
1232: );*/
1305:
1306: p_document_type := lv_doc_type;
1307:
1308: /*commented by csahoo for bug# 6401388
1309: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1310: pv_log_msg => '**************** END OF VALIDATE_INVOICE ****************'
1311: );
1312: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1313: END validate_invoice;
1308: /*commented by csahoo for bug# 6401388
1309: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1310: pv_log_msg => '**************** END OF VALIDATE_INVOICE ****************'
1311: );
1312: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1313: END validate_invoice;
1314:
1315:
1316:
1447: lv_member_name := 'VALIDATE_APP_UNAPP';
1448: set_debug_context;
1449:
1450: /*commented by csahoo for bug# 6401388
1451: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
1452: pn_reg_id => ln_reg_id
1453: );*/
1454:
1455: lv_process_flag := jai_constants.successful ;
1460: ln_sign_of_app_fr_doc := null ;
1461: ln_sign_of_app := sign(nvl(p_araa.amount_applied,0));
1462:
1463: /*commented by csahoo for bug# 6401388
1464: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1465: pv_log_msg => ' Processing the APPLICATION record ' ||fnd_global.local_chr(10)
1466: ||', receivable_application_id -> ' ||p_araa.receivable_application_id ||fnd_global.local_chr(10)
1467: ||', application_type -> ' ||p_araa.application_type ||fnd_global.local_chr(10)
1468: ||', status -> ' ||p_araa.status ||fnd_global.local_chr(10)
1487: || Check that cash receipt has tcs type of taxes which have been confirmed
1488: || Exit processing if the same is not found
1489: */
1490: /*commented by csahoo for bug# 6401388
1491: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1492: pv_log_msg => ' Checking TCS applicability On applied from documents'
1493: );*/
1494: OPEN cur_chk_crtcs_applicable (cp_cash_receipt_id => p_araa.cash_receipt_id );
1495: FETCH cur_chk_crtcs_applicable INTO ln_app_fr_itm_class, ln_app_fr_amount;
1495: FETCH cur_chk_crtcs_applicable INTO ln_app_fr_itm_class, ln_app_fr_amount;
1496:
1497: IF cur_chk_crtcs_applicable%NOTFOUND THEN
1498: /*commented by csahoo for bug# 6401388
1499: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1500: pv_log_msg => ' Skip As TCS not applicable ON Derived from documents '
1501: );*/
1502: CLOSE cur_chk_crtcs_applicable;
1503: p_process_flag := jai_constants.not_applicable ;
1506: /*
1507: ||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
1508: */
1509: /*commented by csahoo for bug# 6401388
1510: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1511: pv_log_msg => 'TCS is applicable'
1512: );*/
1513:
1514: IF p_araa.status = jai_constants.ar_status_activity THEN
1516: || As current receivable application is an activity indicating a receipt to receipt getting applied to another receipt
1517: || or Credit Memo hence stop this processing as otherwise this would lead to down stream TCS data corruption.
1518: */
1519: /*commented by csahoo for bug# 6401388
1520: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1521: pv_log_msg => 'Cannot apply a RECEIPT to any other document (any of them having TCS applicability) other than a Invoice or Debit Memo'
1522: );*/
1523: p_process_flag := jai_constants.expected_error;
1524: p_process_message := 'Cannot apply a RECEIPT to any other document (any of them having TCS applicability) other than a Invoice or Debit Memo';
1556: OPEN cur_chk_tcs_applicable( cp_customer_trx_id => p_araa.customer_trx_id );
1557: FETCH cur_chk_tcs_applicable INTO ln_app_fr_organization_id, ln_app_fr_inventory_item_id, ln_app_fr_amount;
1558:
1559: /*commented by csahoo for bug# 6401388
1560: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1561: pv_log_msg => 'Application type is '||p_araa.application_type
1562: );*/
1563:
1564: IF CUR_CHK_TCS_APPLICABLE%NOTFOUND THEN
1562: );*/
1563:
1564: IF CUR_CHK_TCS_APPLICABLE%NOTFOUND THEN
1565: /*commented by csahoo for bug# 6401388
1566: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1567: pv_log_msg => ' Skip As TCS not applicable ON Derived from documents '
1568: );*/
1569: CLOSE cur_chk_tcs_applicable;
1570: p_process_flag := jai_constants.not_applicable ;
1610: || Set out variables p_process_flag and p_process_message accordingly
1611: */
1612: --call to debug package
1613: /*commented by csahoo for bug# 6401388
1614: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1615: pv_log_msg => ' Error in getting the item attribute'||fnd_global.local_chr(10)
1616: ||', p_process_flag -> '|| p_process_flag
1617: ||', lv_process_message -> '|| lv_process_message
1618: );*/
1625: /*
1626: ||Return in case the scenario is niether CASH nor CM
1627: */
1628: /*commented by csahoo for bug# 6401388
1629: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1630: pv_log_msg => ' Skip as scenario is niether CASH nor CM '
1631: );*/
1632: p_process_flag := jai_constants.not_applicable ;
1633: return;
1633: return;
1634: END IF; -------------A1
1635:
1636: /*commented by csahoo for bug# 6401388
1637: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1638: pv_log_msg => ' Application document type is '||lv_app_doc_type
1639: );*/
1640:
1641:
1653: IF CUR_CHK_TCS_APPLICABLE%NOTFOUND THEN
1654: CLOSE cur_chk_tcs_applicable;
1655: p_process_flag := jai_constants.not_applicable ;
1656: /*commented by csahoo for bug# 6401388
1657: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1658: pv_log_msg => ' Skip the processing as TCS is not applicable on the transaction'
1659: );*/
1660: return;
1661: END IF;
1682: || Set out variables p_process_flag and p_process_message accordingly
1683: */
1684: --call to debug package
1685: /*commented by csahoo for bug# 6401388
1686: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1687: pv_log_msg => ' Error in getting the item classification '||fnd_global.local_chr(10)
1688: ||', p_process_flag -> '|| p_process_flag
1689: ||', lv_process_message -> '|| lv_process_message
1690: );*/
1709: THEN
1710: IF ln_app_fr_itm_class <> ln_app_to_itm_class THEN
1711:
1712: /*commented by csahoo for bug# 6401388
1713: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1714: pv_log_msg => ' Item classification for the application from and to item class do not match hence error '||fnd_global.local_chr(10)
1715: ||', p_process_flag -> '|| p_process_flag
1716: ||', lv_process_message -> '|| lv_process_message
1717: );*/
1725: ||Do not allow overapplication transactions in case they both have TCS type of taxes
1726: */
1727: IF nvl(p_araa.amount_applied,0) > nvl(ln_app_to_amount,0) THEN
1728: /*commented by csahoo for bug# 6401388
1729: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1730: pv_log_msg => 'Case for Overapplication detected , Stop '||fnd_global.local_chr(10)
1731: ||', p_araa.amount_applied -> '|| p_araa.amount_applied ||fnd_global.local_chr(10)
1732: ||', applied to amount -> '|| ln_app_to_amount ||fnd_global.local_chr(10)
1733: ||', p_process_flag -> '|| p_process_flag ||fnd_global.local_chr(10)
1761: ||Exit processing as original application did not hit the repository.
1762: */
1763: CLOSE cur_chk_parent_rec;
1764: /*commented by csahoo for bug# 6401388
1765: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1766: pv_log_msg => 'Skip,case For unapplication, Parent transaction record is not present in the repository'||fnd_global.local_chr(10)
1767: ||', p_process_flag -> '|| p_process_flag ||fnd_global.local_chr(10)
1768: );*/
1769:
1779: */
1780: p_process_flag := jai_constants.expected_error ;
1781: p_process_message := 'Parent application has already been settled. hence cannot unapply';
1782: /*commented by csahoo for bug# 6401388
1783: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1784: pv_log_msg => ' Error :-Parent application has already been settled. hence cannot unapply'||fnd_global.local_chr(10)
1785: ||', p_process_flag -> '|| p_process_flag
1786: ||', lv_process_message -> '|| lv_process_message
1787: );*/
1808: /*
1809: ||Exit processing as original application did not hit the repository.
1810: */
1811: /*commented by csahoo for bug# 6401388
1812: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1813: pv_log_msg => ' Skip the processing as TCS is not applicable on the transaction'||fnd_global.local_chr(10)
1814: ||', p_process_flag -> '|| p_process_flag
1815: );*/
1816: CLOSE cur_chk_parent_rec;
1824: /*
1825: || Original Application already settled hence
1826: */
1827: /*commented by csahoo for bug# 6401388
1828: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1829: pv_log_msg => ' Error :-Parent application has already been settled. hence cannot unapply'||fnd_global.local_chr(10)
1830: ||', p_process_flag -> '|| p_process_flag
1831: ||', lv_process_message -> '|| lv_process_message
1832: );*/
1844: p_document_type := lv_app_doc_type ;
1845: p_item_classification := ln_app_to_itm_class ;
1846:
1847: /*commented by csahoo for bug# 6401388
1848: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1849: pv_log_msg => '**************** PROCEDURE VALIDATE_APP_UNAPP SUCCESSFUL ****************'
1850: );
1851:
1852: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1848: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1849: pv_log_msg => '**************** PROCEDURE VALIDATE_APP_UNAPP SUCCESSFUL ****************'
1850: );
1851:
1852: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
1853:
1854: END validate_app_unapp;
1855:
1856: PROCEDURE validate_receipts ( p_acra IN AR_CASH_RECEIPTS_ALL%ROWTYPE ,
1915:
1916: lv_member_name := 'VALIDATE_RECEIPTS';
1917: set_debug_context;
1918: /*commented by csahoo for bug# 6401388
1919: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1920: , pn_reg_id => ln_reg_id
1921: ); --commmented by CSahoo, BUG#5631784
1922:
1923:
1921: ); --commmented by CSahoo, BUG#5631784
1922:
1923:
1924: /*commented by csahoo for bug# 6401388
1925: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1926: pv_log_msg => ' PARAMETERS VALUES PASSED TO VALIDATE_RECEIPTS : - ' ||fnd_global.local_chr(10)
1927: ||', p_acra.receipt_number -> '||p_acra.receipt_number ||fnd_global.local_chr(10)
1928: ||', p_acra.cash_receipt_id -> '||p_acra.cash_receipt_id ||fnd_global.local_chr(10)
1929: ||', p_acra.amount -> '||p_acra.amount ||fnd_global.local_chr(10)
1940: /*########################################################################################################
1941: || CHECK TCS APPLICABILITY PART -2
1942: ########################################################################################################*/
1943: /*commented by csahoo for bug# 6401388
1944: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1945: pv_log_msg => ' Check TCS applicability '
1946: );*/
1947: /*
1948: || Check whether the TCS is applicable on the document if no
1967: || In case it does not exist, then error out the record as it need not hit the repository
1968: || If it exists then check whether it has been settled . If yes then throw an error
1969: */
1970: /*commented by csahoo for bug# 6401388
1971: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1972: pv_log_msg => 'Validate for Receipt Reversal '
1973: );*/
1974: OPEN cur_chk_tcs_settlement ( cp_source_document_id => p_acra.cash_receipt_id ,
1975: cp_source_document_type => jai_constants.ar_cash_tax_confirmed
1979: /*
1980: ||Original receipt not found in repository hence throw an error
1981: */
1982: /*commented by csahoo for bug# 6401388
1983: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
1984: pv_log_msg => 'Original Receipt Confirmation records does not exists in the repository. Cannot reverse receipt'
1985: );*/
1986: CLOSE cur_chk_tcs_settlement;
1987: p_process_flag := jai_constants.expected_error;
1996: || TCS taxes pertaining to the receipt have already been settled
1997: || Cannot allow receipt to be reversed.
1998: */
1999: /*commented by csahoo for bug# 6401388
2000: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2001: pv_log_msg => ' TCS On the original confirmed receipt has been settled. CAnnot reverse the receipt'
2002: );*/
2003: p_process_flag := jai_constants.expected_error;
2004: p_process_message := 'Cannot reverse the receipt as the tcs taxes pertaining to the receipt have been confirmed ';
2008: CLOSE cur_chk_tcs_settlement;
2009: END IF; /* Receipt reversal */
2010:
2011: /*commented by csahoo for bug# 6401388
2012: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2013: pv_log_msg => '**************** END OF VALIDATE_RECEIPTS ****************'
2014: );
2015:
2016: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2012: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2013: pv_log_msg => '**************** END OF VALIDATE_RECEIPTS ****************'
2014: );
2015:
2016: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2017: END validate_receipts;
2018:
2019: PROCEDURE process_invoices ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE ,
2020: p_document_type VARCHAR2 ,
2130:
2131: lv_member_name := 'PROCESS_INVOICES';
2132: set_debug_context;
2133: /*commented by csahoo for bug# 6401388
2134: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2135: , pn_reg_id => ln_reg_id
2136: );*/
2137:
2138: lv_process_flag := jai_constants.successful ;
2310:
2311: END IF; /* Invoice completion / Incompletion*/
2312:
2313: /*commented by csahoo for bug# 6401388
2314: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2315: pv_log_msg => '**************** END OF PROCESS_INVOICES ****************'
2316: );
2317: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2318: END process_invoices;
2313: /*commented by csahoo for bug# 6401388
2314: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2315: pv_log_msg => '**************** END OF PROCESS_INVOICES ****************'
2316: );
2317: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2318: END process_invoices;
2319:
2320:
2321: procedure process_receipts ( p_acra AR_CASH_RECEIPTS_ALL%ROWTYPE ,
2453: ########################################################################################################*/
2454: lv_member_name := 'PROCESS_RECEIPTS';
2455: set_debug_context;
2456: /*commented by csahoo for bug# 6401388
2457: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2458: , pn_reg_id => ln_reg_id
2459: );*/
2460:
2461: lv_process_flag := jai_constants.successful ;
2474: *******/
2475:
2476: IF p_document_type = jai_constants.ar_cash_tax_confirmed THEN ---------C1
2477: /*commented by csahoo for bug# 6401388
2478: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2479: pv_log_msg => ' Confirmation processing for the receipts with the following details'||fnd_global.local_chr(10)
2480: ||', p_acra.receipt_number -> '||p_acra.receipt_number ||fnd_global.local_chr(10)
2481: ||', p_acra.cash_receipt_id -> '||p_acra.cash_receipt_id ||fnd_global.local_chr(10)
2482: ||', p_acra.amount -> '||p_acra.amount ||fnd_global.local_chr(10)
2499:
2500: ln_local_transaction_id := ln_transaction_id;
2501:
2502: /*commented by csahoo for bug# 6401388
2503: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2504: pv_log_msg => ' Before call to insert_repository_references '
2505: );*/
2506:
2507: insert_repository_references (
2532: p_process_message => lv_process_message
2533: );
2534:
2535: /*commented by csahoo for bug# 6401388
2536: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2537: pv_log_msg => ' Return from insert_repository_references '
2538: );*/
2539:
2540: IF lv_process_flag = jai_constants.expected_error OR ---------A2
2546: || Set out variables p_process_flag and p_process_message accordingly
2547: */
2548: --call to debug package
2549: /*commented by csahoo for bug# 6401388
2550: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2551: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
2552: );*/
2553:
2554: p_process_flag := lv_process_flag ;
2564: /*
2565: || Copy the taxes from the invoice/DM transaction to the TCS tax repository
2566: */
2567: /*commented by csahoo for bug# 6401388
2568: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2569: pv_log_msg => ' Before call to copy_taxes_from_source '
2570: );*/
2571:
2572: copy_taxes_from_source ( p_source_document_type => p_document_type ,
2576: p_process_flag => lv_process_flag ,
2577: p_process_message => lv_process_message
2578: );
2579: /*commented by csahoo for bug# 6401388
2580: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2581: pv_log_msg => ' Return from copy_taxes_from_source '
2582: );*/
2583: IF lv_process_flag = jai_constants.expected_error OR ---------A2
2584: lv_process_flag = jai_constants.unexpected_error OR
2589: || Set out variables p_process_flag and p_process_message accordingly
2590: */
2591: --call to debug package
2592: /*commented by csahoo for bug# 6401388
2593: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2594: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
2595: );*/
2596:
2597: p_process_flag := lv_process_flag ;
2602: /*########################################################################################################
2603: || PROCESS AR CASH RECEIPT APPLICATIONS/UNAPPLICATIONS ---- PART -3
2604: ########################################################################################################*/
2605: /*commented by csahoo for bug# 6401388
2606: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2607: pv_log_msg => ' Cash receipt application processing '
2608: );*/
2609: /******
2610: ||Fetch all the latest applications related to the cash receipt
2620: || Call the procedure to process
2621: || cash receipt applications/unapplications
2622: *******************************************/
2623: /*commented by csahoo for bug# 6401388
2624: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2625: pv_log_msg => ' before call to jai_ar_tcs_rep_pkg.process_transactions '
2626: );*/
2627: jai_ar_tcs_rep_pkg.process_transactions ( p_araa => p_araa ,
2628: p_event => p_araa.application_type ,
2630: p_process_flag => lv_process_flag ,
2631: p_process_message => lv_process_message
2632: );
2633: /*commented by csahoo for bug# 6401388
2634: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2635: pv_log_msg => ' Return from jai_ar_tcs_rep_pkg.process_transactions '
2636: );*/
2637: IF lv_process_flag = jai_constants.expected_error OR ---------A2
2638: lv_process_flag = jai_constants.unexpected_error OR
2643: || Set out variables p_process_flag and p_process_message accordingly
2644: */
2645: --call to debug package
2646: /*commented by csahoo for bug# 6401388
2647: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2648: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
2649: );*/
2650:
2651: p_process_flag := lv_process_flag ;
2666: ########################################################################################################*/
2667:
2668: ELSIF p_document_type = jai_constants.trx_type_rct_rvs THEN ---------C1
2669: /*commented by csahoo for bug# 6401388
2670: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2671: pv_log_msg => ' Start of receipt reversal processing '
2672: );*/
2673: OPEN cur_get_parent_transaction ( cp_source_document_id => p_acra.cash_receipt_id ,
2674: cp_source_document_type => jai_constants.ar_cash_tax_confirmed
2680: || If not found then receipt reversal also need not hit the repository.
2681: */
2682: IF CUR_GET_PARENT_TRANSACTION%FOUND THEN
2683: /*commented by csahoo for bug# 6401388
2684: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2685: pv_log_msg => ' Parent receipt confirmation record found parent_transaction_id -> '||ln_parent_transaction_id
2686: );*/
2687:
2688: copy_references ( p_parent_transaction_id => ln_parent_transaction_id ,
2702: || Set out variables p_process_flag and p_process_message accordingly
2703: */
2704: CLOSE cur_get_parent_transaction ;
2705: /*commented by csahoo for bug# 6401388
2706: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2707: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
2708: );*/
2709:
2710: p_process_flag := lv_process_flag ;
2714: END IF;
2715: CLOSE cur_get_parent_transaction ;
2716: END IF;
2717: /*commented by csahoo for bug# 6401388
2718: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2719: pv_log_msg => '**************** END OF PROCESS_RECEIPTS ****************'
2720: );
2721:
2722: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2718: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2719: pv_log_msg => '**************** END OF PROCESS_RECEIPTS ****************'
2720: );
2721:
2722: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
2723: END process_receipts;
2724:
2725:
2726: PROCEDURE process_applications ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
2916: ########################################################################################################*/
2917: lv_member_name := 'PROCESS_APPLICATIONS';
2918: set_debug_context;
2919: /*commented by csahoo for bug# 6401388
2920: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
2921: pn_reg_id => ln_reg_id
2922: );*/
2923:
2924: /*commented by csahoo for bug# 6401388
2921: pn_reg_id => ln_reg_id
2922: );*/
2923:
2924: /*commented by csahoo for bug# 6401388
2925: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
2926: pv_log_msg => ' Processing the APPLICATION record ' ||fnd_global.local_chr(10)
2927: ||', receivable_application_id -> ' ||p_araa.receivable_application_id ||fnd_global.local_chr(10)
2928: ||', application_type -> ' ||p_araa.application_type ||fnd_global.local_chr(10)
2929: ||', status -> ' ||p_araa.status ||fnd_global.local_chr(10)
3027: ln_app_amount := nvl(p_araa.amount_applied,0) * ln_exchange_rate ;
3028:
3029:
3030: /*commented by csahoo for bug# 6401388
3031: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3032: pv_log_msg => ' Values for the Internal FROm and TO variables are ' ||fnd_global.local_chr(10)
3033: ||', ln_app_to_doc_id -> ' ||ln_app_to_doc_id ||fnd_global.local_chr(10)
3034: ||', ln_app_to_doc_type -> ' ||ln_app_to_doc_type ||fnd_global.local_chr(10)
3035: ||', ln_app_to_doc_table -> ' ||ln_app_to_doc_table ||fnd_global.local_chr(10)
3060: || Also get the tcs amount based on the later document date
3061: ******/
3062: IF ld_app_fr_doc_date >= ld_app_to_doc_date THEN -----------A2
3063: /*commented by csahoo for bug# 6401388
3064: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3065: pv_log_msg => ' From date >= To date '||fnd_global.local_chr(10)
3066: ||', ld_app_fr_doc_date -> '||ld_app_fr_doc_date
3067: ||', ld_app_to_doc_date => '|| ld_app_to_doc_date ||fnd_global.local_chr(10)
3068: );*/
3081: || Applied To document is later
3082: */
3083:
3084: /*commented by csahoo for bug# 6401388
3085: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3086: pv_log_msg => ' To date is greater than from date '||fnd_global.local_chr(10)
3087: ||', ld_app_fr_doc_date -> '||ld_app_fr_doc_date ||fnd_global.local_chr(10)
3088: ||', ld_app_to_doc_date => '|| ld_app_to_doc_date
3089: );*/
3101: END IF; -----------A2
3102:
3103:
3104: /*commented by csahoo for bug# 6401388
3105: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3106: pv_log_msg => ' based on later date derivation logic values derived are ' ||fnd_global.local_chr(10)
3107: ||', ln_app_ref_doc_id -> ' ||ln_app_ref_doc_id ||fnd_global.local_chr(10)
3108: ||', ln_app_ref_doc_type -> ' ||ln_app_ref_doc_type ||fnd_global.local_chr(10)
3109: ||', ln_app_ref_doc_table -> ' ||ln_app_ref_doc_table ||fnd_global.local_chr(10)
3146: );
3147: FETCH cur_get_parent_transaction INTO ln_parent_transaction_id;
3148: CLOSE cur_get_parent_transaction ;
3149: /*commented by csahoo for bug# 6401388
3150: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3151: pv_log_msg => ' parent transaction id is (ln_parent_transaction_id)' ||ln_parent_transaction_id
3152: );*/
3153:
3154:
3162: FETCH cur_get_transaction_id INTO ln_transaction_id ;
3163: CLOSE cur_get_transaction_id ;
3164:
3165: /*commented by csahoo for bug# 6401388
3166: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3167: pv_log_msg => ' Before call to insert_repository_references '
3168: );*/
3169: insert_repository_references (
3170: p_regime_id => NULL ,
3195: );
3196:
3197:
3198: /*commented by csahoo for bug# 6401388
3199: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3200: pv_log_msg => ' Returned from call to insert_repository_references, lv_process_flag -> '||lv_process_flag
3201: );*/
3202: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3203: lv_process_flag = jai_constants.unexpected_error OR
3208: || Set out variables p_process_flag and p_process_message accordingly
3209: */
3210: --call to debug package
3211: /*commented by csahoo for bug# 6401388
3212: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3213: pv_log_msg => ' Error in procedure insert_repository_references '
3214: ||', p_process_flag -> '|| p_process_flag
3215: ||', lv_process_message -> '|| lv_process_message
3216: );*/
3222: /*########################################################################################################
3223: || COPY APPLICATION TAXES FROM SOURCE TRANSACTION TABLES INTO JAI_RGM_TAXES TABLE ---- PART -2
3224: ########################################################################################################*/
3225: /*commented by csahoo for bug# 6401388
3226: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3227: pv_log_msg => ' Before call to copy_taxes_from_source '
3228: );*/
3229: copy_taxes_from_source ( p_source_document_type => ln_app_ref_doc_type ,
3230: p_source_document_id => ln_app_ref_doc_id ,
3234: p_process_message => lv_process_message
3235: );
3236:
3237: /*commented by csahoo for bug# 6401388
3238: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3239: pv_log_msg => ' Returned from call to copy_taxes_from_source, lv_process_flag -> '||lv_process_flag
3240: );*/
3241: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3242: lv_process_flag = jai_constants.unexpected_error OR
3247: || Set out variables p_process_flag and p_process_message accordingly
3248: */
3249: --call to debug package
3250: /*commented by csahoo for bug# 6401388
3251: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3252: pv_log_msg => ' Error in procedure copy_taxes_from_source '
3253: ||', p_process_flag -> '|| p_process_flag
3254: ||', lv_process_message -> '|| lv_process_message
3255: );*/
3257: p_process_message := lv_process_message ;
3258: return;
3259: END IF; ---------A2
3260: /*commented by csahoo for bug# 6401388
3261: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3262: pv_log_msg => '**************** PROCEDURE PROCESS_APPLICATIONS SUCCESSFULLY COMPLETED ****************'
3263: );
3264: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3265: END process_applications;
3260: /*commented by csahoo for bug# 6401388
3261: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3262: pv_log_msg => '**************** PROCEDURE PROCESS_APPLICATIONS SUCCESSFULLY COMPLETED ****************'
3263: );
3264: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3265: END process_applications;
3266:
3267:
3268: PROCEDURE process_unapp_rcpt_rev ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE DEFAULT NULL ,
3310: ########################################################################################################*/
3311: lv_member_name := 'PROCESS_UNAPP_RCPT_REV';
3312: set_debug_context;
3313: /*commented by csahoo for bug# 6401388
3314: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
3315: , pn_reg_id => ln_reg_id
3316: );*/
3317:
3318: lv_process_flag := jai_constants.successful ;
3324: /* IF p_document_type In ( jai_constants.trx_type_rct_unapp ,
3325: jai_constants.trx_type_cm_unapp
3326: )
3327: THEN
3328: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3329: pv_log_msg => ' Processing the UN APPLICATION record ' ||fnd_global.local_chr(10)
3330: ||', p_document_type -> ' ||p_document_type ||fnd_global.local_chr(10)
3331: ||', receivable_application_id -> ' ||p_araa.receivable_application_id ||fnd_global.local_chr(10)
3332: ||', application_type -> ' ||p_araa.application_type ||fnd_global.local_chr(10)
3339: ||', gl_date -> ' ||p_araa.gl_date ||fnd_global.local_chr(10)
3340: ||', org_id -> ' ||p_araa.org_id
3341: );
3342: ELSIF p_document_type = jai_constants.trx_type_rct_rvs THEN
3343: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3344: pv_log_msg => ' Processing the Receipt reversal record ' ||fnd_global.local_chr(10)
3345: ||', p_document_type -> ' ||p_document_type ||fnd_global.local_chr(10)
3346: ||', cash_receipt_id -> ' ||p_acra.cash_receipt_id||fnd_global.local_chr(10)
3347: ||', receipt_number -> ' ||p_acra.cash_receipt_id||fnd_global.local_chr(10)
3383: END IF;
3384:
3385:
3386: /*commented by csahoo for bug# 6401388
3387: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3388: pv_log_msg => ' Values derived for an application/reversal are ' ||fnd_global.local_chr(10)
3389: ||', ln_new_document_id -> ' ||ln_new_document_id ||fnd_global.local_chr(10)
3390: ||', ld_new_document_date -> ' ||ld_new_document_date ||fnd_global.local_chr(10)
3391: ||', ln_source_document_id -> ' ||ln_source_document_id ||fnd_global.local_chr(10)
3406: ) ;
3407: FETCH cur_get_parent_trx INTO ln_parent_transaction_id ;
3408:
3409: /*commented by csahoo for bug# 6401388
3410: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3411: pv_log_msg => ' Parent transaction is ->' ||ln_parent_transaction_id
3412: );*/
3413: /*
3414: || Check that the source receipt confirmation record has been found in the TCS repository.
3416: */
3417: IF CUR_GET_PARENT_TRX%FOUND THEN
3418: CLOSE cur_get_parent_trx ;
3419: /*commented by csahoo for bug# 6401388
3420: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3421: pv_log_msg => ' Parent transaction found, Before call to copy_references '
3422: );*/
3423: copy_references ( p_parent_transaction_id => ln_parent_transaction_id ,
3424: p_new_document_id => ln_new_document_id ,
3429: p_process_message => lv_process_message
3430: );
3431:
3432: /*commented by csahoo for bug# 6401388
3433: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3434: pv_log_msg => ' returned from call to copy_references lv_process_flag -> '||lv_process_flag
3435: );*/
3436: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3437: lv_process_flag = jai_constants.unexpected_error OR
3442: || Set out variables p_process_flag and p_process_message accordingly
3443: */
3444: --call to debug package
3445: /*commented by csahoo for bug# 6401388
3446: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3447: pv_log_msg => ' Error in processing copy references ' ||fnd_global.local_chr(10)
3448: ||',lv_process_flag -> '||lv_process_flag ||fnd_global.local_chr(10)
3449: ||',lv_process_message -> '||lv_process_message
3450: );*/
3458: */
3459: p_process_flag := jai_constants.not_applicable;
3460: END IF; /* Parent transaction found*/
3461: /*commented by csahoo for bug# 6401388
3462: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3463: pv_log_msg => '**************** PROCEDURE PROCESS_UNAPP_RCPT_REV SUCCESSFULLY COMPLETED ****************'
3464: );
3465: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3466: END process_unapp_rcpt_rev ;
3461: /*commented by csahoo for bug# 6401388
3462: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3463: pv_log_msg => '**************** PROCEDURE PROCESS_UNAPP_RCPT_REV SUCCESSFULLY COMPLETED ****************'
3464: );
3465: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3466: END process_unapp_rcpt_rev ;
3467:
3468:
3469: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
3518: ################################################################################################################*/
3519: lv_member_name := 'INSERT_REPOSITORY_REFERENCES';
3520: set_debug_context;
3521: /*commented by csahoo for bug# 6401388
3522: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
3523: , pn_reg_id => ln_reg_id
3524: );*/
3525:
3526: /*commented by csahoo for bug# 6401388
3523: , pn_reg_id => ln_reg_id
3524: );*/
3525:
3526: /*commented by csahoo for bug# 6401388
3527: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3528: pv_log_msg => ' PARAMETERS VALUES PASSED TO INSERT_REPOSITORY_REFERENCES : - ' ||fnd_global.local_chr(10)
3529: ||', p_regime_id -> '||p_regime_id ||fnd_global.local_chr(10)
3530: ||', p_transaction_id -> '||p_transaction_id ||fnd_global.local_chr(10)
3531: ||', p_source_ref_document_id -> '||p_source_ref_document_id ||fnd_global.local_chr(10)
3588: IF p_regime_id IS NULL OR
3589: p_org_tan_no IS NULL
3590: THEN
3591: /*commented by csahoo for bug# 6401388
3592: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3593: pv_log_msg => ' Derive regime values as they are null '
3594: );*/
3595: OPEN c_get_rgm_attribute ( cp_regime_code => jai_constants.tcs_regime ,
3596: cp_attribute_code => jai_constants.rgm_attr_code_org_tan ,
3605: END IF;
3606: CLOSE c_get_rgm_attribute;
3607:
3608: /*commented by csahoo for bug# 6401388
3609: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3610: pv_log_msg => 'Regime values are '
3611: ||', ln_regime_id -> '||ln_regime_id
3612: ||', lv_org_tan_no -> '||lv_org_tan_no
3613: );*/
3617: lv_org_tan_no := p_org_tan_no ;
3618: END IF;
3619:
3620: /*commented by csahoo for bug# 6401388
3621: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3622: pv_log_msg => 'Regime values are '
3623: ||', ln_regime_id -> '||ln_regime_id
3624: ||', lv_org_tan_no -> '||lv_org_tan_no
3625: );*/
3629: ################################################################################################################*/
3630:
3631:
3632: /*commented by csahoo for bug# 6401388
3633: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3634: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
3635: ||', trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
3636: ||', regime_id -> '||ln_regime_id ||fnd_global.local_chr(10)
3637: ||', transaction_id -> '||p_transaction_id ||fnd_global.local_chr(10)
3741: NULL
3742: );
3743:
3744: /*commented by csahoo for bug# 6401388
3745: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3746: END insert_repository_references;
3747:
3748: procedure insert_repository_taxes (
3749: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3816: ################################################################################################################*/
3817: lv_member_name := 'INSERT_REPOSITORY_TAXES';
3818: set_debug_context;
3819: /*commented by csahoo for bug# 6401388
3820: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
3821: , pn_reg_id => ln_reg_id
3822: );*/
3823:
3824: /*commented by csahoo for bug# 6401388
3821: , pn_reg_id => ln_reg_id
3822: );*/
3823:
3824: /*commented by csahoo for bug# 6401388
3825: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3826: pv_log_msg => ' PARAMETERS VALUES PASSED TO INSERT_REPOSITORY_TAXES : - '||fnd_global.local_chr(10)
3827: ||', p_trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
3828: ||', p_tax_id -> '||p_tax_id ||fnd_global.local_chr(10)
3829: ||', p_tax_type -> '||p_tax_type ||fnd_global.local_chr(10)
3899: */
3900: ln_tax_modified_by := nvl(p_tax_modified_by ,jai_constants.tax_modified_by_system );
3901:
3902: /*commented by csahoo for bug# 6401388
3903: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3904: pv_log_msg => ' VALUES insert into JAI_RGM_TAXES are : - ' ||fnd_global.local_chr(10)
3905: ||', tax_det_id -> '||ln_tax_det_id ||fnd_global.local_chr(10)
3906: ||', trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
3907: ||', tax_type -> '||p_tax_type ||fnd_global.local_chr(10)
3954: ln_login_id
3955: );
3956:
3957: /*commented by csahoo for bug# 6401388
3958: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3959: pv_log_msg => ' Insert successful'
3960: );*/
3961: UPDATE
3962: jai_rgm_refs_all
3965: WHERE
3966: trx_ref_id = p_trx_ref_id;
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 => ' jai_rgm_refs_all.total_tax_amt successfully updated '
3971: );*/
3972: /*commented by csahoo for bug# 6401388
3973: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3969: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3970: pv_log_msg => ' jai_rgm_refs_all.total_tax_amt successfully updated '
3971: );*/
3972: /*commented by csahoo for bug# 6401388
3973: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3974: pv_log_msg => '**************** END OF INSERT_REPOSITORY_TAXES ****************'
3975: );
3976: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3977: END insert_repository_taxes ;
3972: /*commented by csahoo for bug# 6401388
3973: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3974: pv_log_msg => '**************** END OF INSERT_REPOSITORY_TAXES ****************'
3975: );
3976: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3977: END insert_repository_taxes ;
3978:
3979:
3980: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4049: ########################################################################################################*/
4050: lv_member_name := 'COPY_TAXES_FROM_SOURCE';
4051: set_debug_context;
4052: /*commented by csahoo for bug# 6401388
4053: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
4054: , pn_reg_id => ln_reg_id
4055: );*/
4056:
4057: /*commented by csahoo for bug# 6401388
4054: , pn_reg_id => ln_reg_id
4055: );*/
4056:
4057: /*commented by csahoo for bug# 6401388
4058: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4059: pv_log_msg => ' PARAMETERS VALUES PASSED TO COPY_TAXES_FROM_SOURCE : - ' ||fnd_global.local_chr(10)
4060: ||', p_source_document_type -> '||p_source_document_type ||fnd_global.local_chr(10)
4061: ||', p_source_document_id -> '||p_source_document_id ||fnd_global.local_chr(10)
4062: ||', p_source_document_line_id -> '||p_source_document_line_id ||fnd_global.local_chr(10)
4092: || the TCS tax repository table jai_rgm_taxes
4093: ***/
4094:
4095: /*commented by csahoo for bug# 6401388
4096: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4097: pv_log_msg => ' copy TAXES From JAI_AR_TRX_TAX_LINES - p_source_document_type -> '||p_source_document_type
4098: );*/
4099: FOR rec_cur_get_inv_taxes IN cur_get_inv_taxes ( cp_customer_trx_id => p_source_document_id ,
4100: cp_customer_trx_line_id => p_source_document_line_id
4122: || Set out variables p_process_flag and p_process_message accordingly
4123: */
4124: --call to debug package
4125: /*commented by csahoo for bug# 6401388
4126: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4127: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
4128: );*/
4129:
4130: p_process_flag := lv_process_flag ;
4137: /*
4138: ||Source is receipt
4139: */
4140: /*commented by csahoo for bug# 6401388
4141: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4142: pv_log_msg => ' copy TAXES From jai_cmn_document_taxes - p_source_document_id -> '||p_source_document_id
4143: ||', p_source_document_type -> '||p_source_document_type
4144: );*/
4145: FOR rec_cur_get_rcpt_taxes IN cur_get_rcpt_taxes (cp_source_doc_id => p_source_document_id )
4166: || Set out variables p_process_flag and p_process_message accordingly
4167: */
4168: --call to debug package
4169: /*commented by csahoo for bug# 6401388
4170: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4171: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
4172: );*/
4173:
4174: p_process_flag := lv_process_flag ;
4179:
4180: END IF; --------------------------A1
4181:
4182: /*commented by csahoo for bug# 6401388
4183: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4184: pv_log_msg => '****************COPY_TAXES_FROM_SOURCE ENDS SUCCESSFULLY ****************'
4185: );
4186: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4187: END copy_taxes_from_source;
4182: /*commented by csahoo for bug# 6401388
4183: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4184: pv_log_msg => '****************COPY_TAXES_FROM_SOURCE ENDS SUCCESSFULLY ****************'
4185: );
4186: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4187: END copy_taxes_from_source;
4188:
4189: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4190: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4234:
4235: lv_member_name := 'COPY_REFERENCES';
4236: set_debug_context;
4237: /*commented by csahoo for bug# 6401388
4238: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
4239: , pn_reg_id => ln_reg_id
4240: );*/
4241:
4242: /*commented by csahoo for bug# 6401388
4239: , pn_reg_id => ln_reg_id
4240: );*/
4241:
4242: /*commented by csahoo for bug# 6401388
4243: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4244: pv_log_msg => ' PARAMETERS VALUES PASSED TO COPY_REFERENCES : - ' ||fnd_global.local_chr(10)
4245: ||', p_parent_transaction_id -> '||p_parent_transaction_id ||fnd_global.local_chr(10)
4246: ||', p_new_document_id -> '||p_new_document_id ||fnd_global.local_chr(10)
4247: ||', p_new_document_type -> '||p_new_document_type ||fnd_global.local_chr(10)
4281: CLOSE cur_get_trx_ref_id ;
4282:
4283:
4284: /*commented by csahoo for bug# 6401388
4285: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4286: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4287: ||', regime_id -> '||rec_cur_get_refs.regime_id ||fnd_global.local_chr(10)
4288: ||', trx_ref_id -> '||ln_trx_ref_id ||fnd_global.local_chr(10)
4289: ||', transaction_id -> '||ln_transaction_id ||fnd_global.local_chr(10)
4393: NULL
4394: );
4395:
4396: /*commented by csahoo for bug# 6401388
4397: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4398: pv_log_msg => ' After Insert into jai_rgm_refs_all'
4399: );*/
4400:
4401: /*
4411: FETCH cur_get_tax_det_id INTO ln_tax_det_id;
4412: CLOSE cur_get_tax_det_id;
4413:
4414: /*commented by csahoo for bug# 6401388
4415: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4416: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4417: ||', tax_det_id -> '||ln_tax_det_id ||fnd_global.local_chr(10)
4418: ||', trx_ref_id -> '||ln_trx_ref_id ||fnd_global.local_chr(10)
4419: ||', tax_type -> '||rec_cur_get_rgm_taxes.tax_type ||fnd_global.local_chr(10)
4466:
4467:
4468:
4469: /*commented by csahoo for bug# 6401388
4470: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4471: pv_log_msg => ' After Insert into jai_rgm_taxes '
4472: );*/
4473: END LOOP; /* End of tax population */
4474: END LOOP; /*End of jai_rgm_refs_all population */
4473: END LOOP; /* End of tax population */
4474: END LOOP; /*End of jai_rgm_refs_all population */
4475:
4476: /*commented by csahoo for bug# 6401388
4477: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4478: pv_log_msg => '**************** END OF COPY_REFERENCES ****************'
4479: );
4480:
4481: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4477: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4478: pv_log_msg => '**************** END OF COPY_REFERENCES ****************'
4479: );
4480:
4481: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4482: END copy_references;
4483:
4484:
4485: PROCEDURE update_item_gen_docs ( p_trx_number IN RA_CUSTOMER_TRX_ALL.TRX_NUMBER%TYPE ,
4519:
4520: lv_member_name := 'UPDATE_ITEM_GEN_DOCS';
4521: set_debug_context;
4522: /*commented by csahoo for bug# 6401388
4523: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
4524: pn_reg_id => ln_reg_id
4525: );
4526:
4527: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4523: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
4524: pn_reg_id => ln_reg_id
4525: );
4526:
4527: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4528: pv_log_msg => 'VALUES PASSED TO UPDATE_ITEM_GEN_DOCS ARE :- ' ||fnd_global.local_chr(10)
4529: ||', p_trx_number -> '||p_trx_number ||fnd_global.local_chr(10)
4530: ||', p_customer_trx_id -> '||p_customer_trx_id ||fnd_global.local_chr(10)
4531: ||', p_complete_flag -> '||p_complete_flag ||fnd_global.local_chr(10)
4567: /*
4568: ||Do nothing if the generated_doc_id is null and invoice is getting incompleted
4569: */
4570: /*commented by csahoo for bug# 6401388
4571: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4572: pv_log_msg => 'Skip the TCS ITEM GENDOCS update as :- ' ||fnd_global.local_chr(10)
4573: ||', p_complete_flag -> '||p_complete_flag ||fnd_global.local_chr(10)
4574: ||', ln_generated_doc_id -> '||ln_generated_doc_id
4575: );*/
4578: END IF;
4579: END IF;
4580:
4581: /*commented by csahoo for bug# 6401388
4582: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4583: 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)
4584: ||', generated_doc_id -> '||ln_generated_doc_id
4585: );*/
4586: UPDATE jai_rgm_item_gen_docs
4594: END IF;
4595: CLOSE cur_upd_gen_docs;
4596:
4597: /*commented by csahoo for bug# 6401388
4598: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4599: pv_log_msg => '**************** END OF UPDATE_ITEM_GEN_DOCS ****************'
4600: );
4601:
4602: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4598: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4599: pv_log_msg => '**************** END OF UPDATE_ITEM_GEN_DOCS ****************'
4600: );
4601:
4602: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4603:
4604: END update_item_gen_docs;
4605:
4606:
4690:
4691: lv_member_name := 'GENERATE_DOCUMENT';
4692: set_debug_context;
4693: /*commented by csahoo for bug# 6401388
4694: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
4695: pn_reg_id => ln_reg_id
4696: );
4697:
4698: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4694: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
4695: pn_reg_id => ln_reg_id
4696: );
4697:
4698: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4699: pv_log_msg => 'Parameter passed to GENERATE_DOCUMENT are -> ' ||fnd_global.local_chr(10)
4700: ||', transaction_id -> '||p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
4701: ||', p_total_tax_amt -> '||p_total_tax_amt ||fnd_global.local_chr(10)
4702: ||', source_document_type is -> '||p_rgm_ref.source_document_type ||fnd_global.local_chr(10)
4713: ||Skip the transaction if p_total_tax_amt is 0
4714: ################################################################################################################*/
4715: IF nvl(p_total_tax_amt,0) = 0 THEN
4716: /*commented by csahoo for bug# 6401388
4717: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4718: pv_log_msg => 'As transaction total_tax_amt is -> '||p_total_tax_amt||' hence skipping the transaction.'
4719: );*/
4720: p_process_flag := jai_constants.not_applicable ;
4721: return;
4725: ||Get batch source information
4726: ################################################################################################################*/
4727:
4728: /*commented by csahoo for bug# 6401388
4729: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4730: pv_log_msg => ' Deriving the batch source information '
4731: );*/
4732:
4733: /*
4756: || Derive the batch source name based on the document type
4757: ################################################################################################################*/
4758:
4759: /*commented by csahoo for bug# 6401388
4760: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4761: pv_log_msg => ' Deriving the batch source name based on the document type'
4762: );*/
4763:
4764: IF p_rgm_ref.source_document_type in ( jai_constants.ar_cash_tax_confirmed , /* Receipt confirmation */
4799: /*
4800: ||Skip the transaction
4801: */
4802: /*commented by csahoo for bug# 6401388
4803: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4804: pv_log_msg => 'Skip the transaction '
4805: );*/
4806: p_process_flag := jai_constants.not_applicable;
4807: p_process_message := null;
4816: || Error out if the batch source name is null i.e regime party setup for
4817: */
4818: IF lv_batch_src_name IS NULL THEN
4819: /*commented by csahoo for bug# 6401388
4820: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4821: pv_log_msg => 'Batch source definition has not be defined for the inventory organization '||p_rgm_ref.organization_id
4822: );*/
4823:
4824: p_process_flag := jai_constants.expected_error;
4828: END IF;
4829:
4830:
4831: /*commented by csahoo for bug# 6401388
4832: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4833: pv_log_msg => 'Document Type is lv_batch_src_name -> '||lv_batch_src_name
4834: );*/
4835:
4836: OPEN cur_get_batch_source ( cp_org_id => p_rgm_ref.org_id ,
4839:
4840: FETCH cur_get_batch_source INTO rec_cur_get_batch_source;
4841: IF cur_get_batch_source%NOTFOUND THEN
4842: /*commented by csahoo for bug# 6401388
4843: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4844: pv_log_msg => 'TCS batch source has not been defined '
4845: );*/
4846: CLOSE cur_get_batch_source ;
4847: p_process_flag := jai_constants.expected_error;
4851: END IF;
4852: CLOSE cur_get_batch_source ;
4853:
4854: /*commented by csahoo for bug# 6401388
4855: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4856: pv_log_msg => 'batch source details are:- ' ||fnd_global.local_chr(10)
4857: ||', lv_batch_src_name -> '||lv_batch_src_name ||fnd_global.local_chr(10)
4858: ||', rec_cur_get_batch_source.batch_source_id -> '||rec_cur_get_batch_source.batch_source_id ||fnd_global.local_chr(10)
4859: ||', rec_cur_get_batch_source.default_inv_trx_type -> '||rec_cur_get_batch_source.default_inv_trx_type ||fnd_global.local_chr(10)
4872: || This check is not required in case of credit memo
4873: */
4874: IF ln_term_id IS NULL THEN
4875: /*commented by csahoo for bug# 6401388
4876: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4877: pv_log_msg => 'Error:- Default term is not defined in the transction type -> '||rec_cur_get_batch_source.name
4878: );*/
4879: p_process_flag := jai_constants.expected_error;
4880: lv_process_message := 'Cannot process transaction. A default term needs to be defined FOR the Transaction TYPE '||rec_cur_get_batch_source.name ;
4894: ||Throw an error if the Set of books has not been defined
4895: */
4896: IF lv_set_of_books_id IS NULL THEN
4897: /*commented by csahoo for bug# 6401388
4898: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4899: pv_log_msg => 'Error:- Set of books not defined for org_id -> '||p_rgm_ref.org_id
4900: );*/
4901:
4902: p_process_flag := jai_constants.expected_error;
4921:
4922: IF ln_bill_to_address_id IS NULL THEN
4923:
4924: /*commented by csahoo for bug# 6401388
4925: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4926: pv_log_msg => 'Error:- Bill to address not defined for the customer id -> '||p_rgm_ref.party_id
4927: ||' customer site -> '||p_rgm_ref.party_site_id
4928: );*/
4929:
4966: || INSERT INTO RA_INTERFACE_LINES_ALL TABLE
4967: ################################################################################################################*/
4968:
4969: /*commented by csahoo for bug# 6401388
4970: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4971: pv_log_msg => 'Before inserting into the interface tables, Values are :- ' || fnd_global.local_chr(10)
4972: ||', interface_line_id -> '|| p_rgm_ref.transaction_id || fnd_global.local_chr(10)
4973: ||', i/p tax amount -> '|| p_total_tax_amt || fnd_global.local_chr(10)
4974: ||', document creation amount -> '|| ln_amount || fnd_global.local_chr(10)
5060: ln_login_id
5061: );
5062:
5063: /*commented by csahoo for bug# 6401388
5064: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5065: pv_log_msg => 'After Insert statement of the interface tables '
5066: );*/
5067:
5068:
5084: || Code Combination id has been returned as null from the function jai_cmn_rgm_recording_pkg.get_account
5085: || This is an error condition and the current processing has to be stopped
5086: **********************************************************************************************************/
5087: /*commented by csahoo for bug# 6401388
5088: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5089: pv_log_msg => 'Invalid code combination of TCS tax Accounting'
5090: );*/
5091: p_process_flag := jai_constants.expected_error;
5092: lv_process_message := 'Invalid Code combination ,please check the TCS Tax - Tax Accounting Setup';
5095: return;
5096: END IF;
5097:
5098: /*commented by csahoo for bug# 6401388
5099: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5100: pv_log_msg => 'Inserting values into ra_interface_distributions_all for REV row:- '||fnd_global.local_chr(10)
5101: ||', interface_line_id -> '|| p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
5102: ||', interface_line_context -> '|| lv_batch_src_name ||fnd_global.local_chr(10)
5103: ||', interface_line_attribute2 -> '|| p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
5147:
5148:
5149:
5150: /*commented by csahoo for bug# 6401388
5151: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5152: pv_log_msg => 'Inserting values into jai_rgm_item_gen_docs :- ' ||fnd_global.local_chr(10)
5153: ||', transaction_id -> '||p_rgm_ref.transaction_id ||fnd_global.local_chr(10)
5154: ||', source_document_id -> '||p_rgm_ref.source_document_id ||fnd_global.local_chr(10)
5155: ||', source_document_type -> '||p_rgm_ref.source_document_type ||fnd_global.local_chr(10)
5193: ln_login_id
5194: );
5195:
5196: /*commented by csahoo for bug# 6401388
5197: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5198: pv_log_msg => 'Data successfully inserted into jai_rgm_item_gen_docs'
5199: );
5200:
5201:
5198: pv_log_msg => 'Data successfully inserted into jai_rgm_item_gen_docs'
5199: );
5200:
5201:
5202: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
5203: EXCEPTION
5204: WHEN OTHERS THEN
5205: p_process_flag := jai_constants.unexpected_error;
5206: p_process_message := ' Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document'||substr(SQLERRM,1,300) ;
5204: WHEN OTHERS THEN
5205: p_process_flag := jai_constants.unexpected_error;
5206: p_process_message := ' Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document'||substr(SQLERRM,1,300) ;
5207: /*commented by csahoo for bug# 6401388
5208: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5209: pv_log_msg => 'Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document -> '||substr(SQLERRM,1,300)
5210: );*/
5211:
5212: END generate_document;
5468:
5469: lv_member_name := 'PROCESS_TRANSACTIONS';
5470: set_debug_context;
5471: /*commented by csahoo for bug# 6401388
5472: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
5473: pn_reg_id => ln_reg_id
5474: );*/
5475: lv_process_flag := jai_constants.successful ;
5476: lv_process_message := null ;
5480: ln_event := p_event ;
5481:
5482:
5483: /*commented by csahoo for bug# 6401388
5484: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5485: pv_log_msg => '******************Start of JAI_AR_TC_SREP_PKG.PROCESS_TRANSACTIONS***************, Event is '||p_event
5486: );*/
5487:
5488:
5492: IF p_event = jai_constants.order_booked OR
5493: p_event = jai_constants.wsh_ship_confirm
5494: THEN ---------A1
5495: /*commented by csahoo for bug# 6401388
5496: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5497: pv_log_msg => '******************Before call to VALIDATE_SALES_ORDER/SHIP CONFIRM ***************, lv_document_type '||lv_document_type
5498: );*/
5499: validate_sales_order ( p_ooh => p_ooh ,
5500: p_process_flag => lv_process_flag ,
5501: p_process_message => lv_process_message
5502: );
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 => '******************Returned from call to VALIDATE_SALES_ORDER/SHIP CONFIRM ***************, lv_process_flag '||lv_process_flag
5507: );*/
5508:
5509: IF lv_process_flag = jai_constants.not_applicable THEN
5507: );*/
5508:
5509: IF lv_process_flag = jai_constants.not_applicable THEN
5510: /*commented by csahoo for bug# 6401388
5511: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5512: pv_log_msg => 'Skip the transaction'
5513: );*/
5514: return;
5515: END IF;
5522: || Set out variables p_process_flag and p_process_message accordingly
5523: */
5524: --call to debug package
5525: /*commented by csahoo for bug# 6401388
5526: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5527: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
5528: );*/
5529:
5530: p_process_flag := lv_process_flag ;
5556: ########################################################################################################*/
5557: IF p_event = jai_constants.trx_event_completion THEN ---------B1
5558:
5559: /*commented by csahoo for bug# 6401388
5560: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5561: pv_log_msg => '******************Before call to VALIDATE_INVOICE ***************, lv_document_type '||lv_document_type
5562: );*/
5563: validate_invoice ( p_ract => p_ract ,
5564: p_document_type => lv_document_type ,
5566: p_process_message => lv_process_message
5567: );
5568:
5569: /*commented by csahoo for bug# 6401388
5570: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5571: pv_log_msg => '******************Returned from call to VALIDATE_INVOICE ***************, lv_process_flag '||lv_process_flag
5572: );*/
5573: IF lv_process_flag = jai_constants.not_applicable THEN
5574: /*commented by csahoo for bug# 6401388
5571: pv_log_msg => '******************Returned from call to VALIDATE_INVOICE ***************, lv_process_flag '||lv_process_flag
5572: );*/
5573: IF lv_process_flag = jai_constants.not_applicable THEN
5574: /*commented by csahoo for bug# 6401388
5575: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5576: pv_log_msg => 'Skip the transaction'
5577: );*/
5578: return;
5579: END IF;
5586: || Set out variables p_process_flag and p_process_message accordingly
5587: */
5588: --call to debug package
5589: /*commented by csahoo for bug# 6401388
5590: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5591: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
5592: );*/
5593:
5594: p_process_flag := lv_process_flag ;
5603: );
5604:
5605: IF lv_process_flag = jai_constants.not_applicable THEN
5606: /*commented by csahoo for bug# 6401388
5607: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5608: pv_log_msg => 'Skip the transaction'
5609: );*/
5610:
5611: return;
5620: || Set out variables p_process_flag and p_process_message accordingly
5621: */
5622: --call to debug package
5623: /*commented by csahoo for bug# 6401388
5624: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5625: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
5626: );*/
5627:
5628: p_process_flag := lv_process_flag ;
5641: THEN
5642: lv_document_type := p_event;
5643:
5644: /*commented by csahoo for bug# 6401388
5645: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5646: pv_log_msg => ' Before call to validate_receipts : - p_event -> '||p_event
5647: );*/
5648: validate_receipts ( p_acra => p_acra ,
5649: p_document_type => lv_document_type ,
5651: p_process_message => lv_process_message
5652: );
5653:
5654: /*commented by csahoo for bug# 6401388
5655: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5656: pv_log_msg => ' Returned from validate_receipts lv_process_flag: '||lv_process_flag
5657: );*/
5658: IF lv_process_flag = jai_constants.not_applicable THEN
5659: /*commented by csahoo for bug# 6401388
5656: pv_log_msg => ' Returned from validate_receipts lv_process_flag: '||lv_process_flag
5657: );*/
5658: IF lv_process_flag = jai_constants.not_applicable THEN
5659: /*commented by csahoo for bug# 6401388
5660: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5661: pv_log_msg => 'Skip the transaction'
5662: );*/
5663:
5664: return;
5672: || Set out variables p_process_flag and p_process_message accordingly
5673: */
5674: --call to debug package
5675: /*commented by csahoo for bug# 6401388
5676: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5677: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
5678: );*/
5679:
5680: p_process_flag := lv_process_flag ;
5681: p_process_message := lv_process_message ;
5682: return;
5683: END IF; ---------C2
5684: /*commented by csahoo for bug# 6401388
5685: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5686: pv_log_msg => ' Before call to process_receipts : - p_event -> '||p_event
5687: );*/
5688:
5689: process_receipts ( p_acra => p_acra ,
5691: p_process_flag => lv_process_flag ,
5692: p_process_message => lv_process_message
5693: );
5694: /*commented by csahoo for bug# 6401388
5695: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5696: pv_log_msg => ' Returned from process_receipts lv_process_flag: '||lv_process_flag
5697: );*/
5698:
5699: IF lv_process_flag = jai_constants.not_applicable THEN
5697: );*/
5698:
5699: IF lv_process_flag = jai_constants.not_applicable THEN
5700: /*commented by csahoo for bug# 6401388
5701: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5702: pv_log_msg => 'Skip the transaction'
5703: );*/
5704:
5705: return;
5713: || Set out variables p_process_flag and p_process_message accordingly
5714: */
5715: --call to debug package
5716: /*commented by csahoo for bug# 6401388
5717: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5718: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
5719: );*/
5720:
5721: p_process_flag := lv_process_flag ;
5736: /***********
5737: ||Validate application and unapplications
5738: ***********/
5739: /*commented by csahoo for bug# 6401388
5740: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5741: pv_log_msg => ' Before call to validate_app_unapp : - p_event -> '||p_event
5742: );*/
5743:
5744: validate_app_unapp (
5749: p_process_message => lv_process_message
5750: );
5751:
5752: /*commented by csahoo for bug# 6401388
5753: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5754: pv_log_msg => ' Returned from validate_app_unapp lv_process_flag: '||lv_process_flag
5755: );*/
5756:
5757: IF lv_process_flag = jai_constants.not_applicable THEN
5755: );*/
5756:
5757: IF lv_process_flag = jai_constants.not_applicable THEN
5758: /*commented by csahoo for bug# 6401388
5759: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5760: pv_log_msg => 'Skip the transaction'
5761: );*/
5762: return;
5763: END IF;
5771: || Set out variables p_process_flag and p_process_message accordingly
5772: */
5773: --call to debug package
5774: /*commented by csahoo for bug# 6401388
5775: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5776: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
5777: );*/
5778:
5779: p_process_flag := lv_process_flag ;
5786: jai_constants.trx_type_cm_app
5787: )
5788: THEN
5789: /*commented by csahoo for bug# 6401388
5790: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5791: pv_log_msg => ' Before call to process_applications : - p_event -> '||p_event
5792: );*/
5793:
5794: process_applications ( p_araa => p_araa ,
5797: p_process_flag => lv_process_flag ,
5798: p_process_message => lv_process_message
5799: );
5800: /*commented by csahoo for bug# 6401388
5801: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5802: pv_log_msg => ' Returned from process_applications lv_process_flag: '||lv_process_flag
5803: );*/
5804:
5805: ELSIF lv_document_type IN ( jai_constants.trx_type_rct_unapp, ---------D3
5806: jai_constants.trx_type_cm_unapp
5807: )
5808: THEN
5809: /*commented by csahoo for bug# 6401388
5810: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5811: pv_log_msg => ' Before call to process_unapp_rcpt_rev : - p_event -> '||p_event
5812: );*/
5813:
5814: process_unapp_rcpt_rev ( p_araa => p_araa ,
5818: p_process_message => lv_process_message
5819: );
5820:
5821: /*commented by csahoo for bug# 6401388
5822: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5823: pv_log_msg => ' Returned from process_unapp_rcpt_rev lv_process_flag: '||lv_process_flag
5824: );*/
5825:
5826: END IF; ---------D3
5826: END IF; ---------D3
5827:
5828: IF lv_process_flag = jai_constants.not_applicable THEN ---------D4
5829: /*commented by csahoo for bug# 6401388
5830: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5831: pv_log_msg => 'Skip the transaction'
5832: );*/
5833:
5834: return;
5842: || Set out variables p_process_flag and p_process_message accordingly
5843: */
5844: --call to debug package
5845: /*commented by csahoo for bug# 6401388
5846: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5847: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
5848: );*/
5849:
5850: p_process_flag := lv_process_flag ;
5864: jai_constants.ar_invoice_type_cm
5865: )
5866: THEN
5867: /*commented by csahoo for bug# 6401388
5868: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5869: pv_log_msg => ' Before call to generate_document : - p_event -> '||p_event
5870: );*/
5871:
5872:
5885: p_process_message => lv_process_message
5886: );
5887:
5888: /*commented by csahoo for bug# 6401388
5889: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5890: pv_log_msg => ' Returned from generate_document lv_process_flag: '||lv_process_flag
5891: );*/
5892:
5893: IF lv_process_flag = jai_constants.not_applicable THEN ---------D4
5891: );*/
5892:
5893: IF lv_process_flag = jai_constants.not_applicable THEN ---------D4
5894: /*commented by csahoo for bug# 6401388
5895: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5896: pv_log_msg => 'Skip the transaction'
5897: );*/
5898:
5899: return;
5907: || Set out variables p_process_flag and p_process_message accordingly
5908: */
5909: --call to debug package
5910: /*commented by csahoo for bug# 6401388
5911: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5912: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
5913: );*/
5914:
5915: p_process_flag := lv_process_flag ;
5927: */
5928: IF ln_transaction_id IS NOT NULL THEN
5929:
5930: /*commented by csahoo for bug# 6401388
5931: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5932: pv_log_msg => ' Before call to jai_rgm_thhold_proc_pkg.maintain_threshold : - p_event -> '||p_event
5933: ||', ln_transaction_id -> '||ln_transaction_id
5934: );*/
5935:
5938: p_process_message => lv_process_message
5939: );
5940:
5941: /*commented by csahoo for bug# 6401388
5942: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5943: pv_log_msg => ' Returned from jai_rgm_thhold_proc_pkg.maintain_threshold lv_process_flag: '||lv_process_flag
5944: );*/
5945:
5946: IF lv_process_flag = jai_constants.not_applicable THEN
5944: );*/
5945:
5946: IF lv_process_flag = jai_constants.not_applicable THEN
5947: /*commented by csahoo for bug# 6401388
5948: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5949: pv_log_msg => 'Skip the transaction'
5950: );*/
5951:
5952: return;
5960: || Set out variables p_process_flag and p_process_message accordingly
5961: */
5962: --call to debug package
5963: /*commented by csahoo for bug# 6401388
5964: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5965: pv_log_msg => ' Error : - lv_process_flag -> '||lv_process_flag||' - '||lv_process_message
5966: );*/
5967:
5968: p_process_flag := lv_process_flag ;
5971: END IF; ---------D2
5972: END IF;
5973:
5974: /*commented by csahoo for bug# 6401388
5975: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5976: pv_log_msg => '**************** END OF PROCESS TRANSACTION ****************'
5977: );
5978:
5979:
5976: pv_log_msg => '**************** END OF PROCESS TRANSACTION ****************'
5977: );
5978:
5979:
5980: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
5981: EXCEPTION
5982: WHEN OTHERS THEN
5983: p_process_flag := jai_constants.unexpected_error;
5984: p_process_message := lv_context||' Unexpected error occured while processing jai_ar_tcs_rep_pkg.process_transactions'||SQLERRM ;
5982: WHEN OTHERS THEN
5983: p_process_flag := jai_constants.unexpected_error;
5984: p_process_message := lv_context||' Unexpected error occured while processing jai_ar_tcs_rep_pkg.process_transactions'||SQLERRM ;
5985: /*commented by csahoo for bug# 6401388
5986: jai_cmn_debug_contexts_pkg.print( pn_reg_id => ln_reg_id ,
5987: pv_log_msg => p_process_message ,
5988: pn_statement_level => jai_cmn_debug_contexts_pkg.summary
5989: );
5990:
5984: p_process_message := lv_context||' Unexpected error occured while processing jai_ar_tcs_rep_pkg.process_transactions'||SQLERRM ;
5985: /*commented by csahoo for bug# 6401388
5986: jai_cmn_debug_contexts_pkg.print( pn_reg_id => ln_reg_id ,
5987: pv_log_msg => p_process_message ,
5988: pn_statement_level => jai_cmn_debug_contexts_pkg.summary
5989: );
5990:
5991: jai_cmn_debug_contexts_pkg.print_stack;*/
5992:
5987: pv_log_msg => p_process_message ,
5988: pn_statement_level => jai_cmn_debug_contexts_pkg.summary
5989: );
5990:
5991: jai_cmn_debug_contexts_pkg.print_stack;*/
5992:
5993: END process_transactions ;
5994:
5995: PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
6011:
6012: lv_member_name := 'UPDATE_PAN_FOR_TCS';
6013: set_debug_context;
6014: /*commented by csahoo for bug# 6401388
6015: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
6016: pn_reg_id => ln_reg_id
6017: );
6018:
6019: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6015: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
6016: pn_reg_id => ln_reg_id
6017: );
6018:
6019: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6020: pv_log_msg => 'Parameter passed to update_pan_for_tcs are -> ' ||fnd_global.local_chr(10)
6021: ||', p_party_id -> '||p_party_id ||fnd_global.local_chr(10)
6022: ||', p_old_pan_no -> '||p_old_pan_no ||fnd_global.local_chr(10)
6023: ||', p_new_pan_no -> '||p_new_pan_no
6028: ln_request_id := fnd_global.conc_request_id;
6029:
6030:
6031: /*commented by csahoo for bug# 6401388
6032: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6033: pv_log_msg => 'Updating the table JAI_CMN_CUS_ADDRESSES'
6034: );*/
6035:
6036: /*
6044: customer_id = p_party_id
6045: AND pan_no = p_old_pan_no ;
6046:
6047: /*commented by csahoo for bug# 6401388
6048: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6049: pv_log_msg => 'Update to table JAI_CMN_CUS_ADDRESSES successful. Now updating the table jai_rgm_thresholds '
6050: );*/
6051:
6052:
6062: AND party_pan_no = p_old_pan_no ;
6063:
6064:
6065: /*commented by csahoo for bug# 6401388
6066: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6067: pv_log_msg => '**************** UPDATE_PAN_FOR_TCS SUCCESSFULLY COMPLETED ****************'
6068: );
6069: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
6070:
6065: /*commented by csahoo for bug# 6401388
6066: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
6067: pv_log_msg => '**************** UPDATE_PAN_FOR_TCS SUCCESSFULLY COMPLETED ****************'
6068: );
6069: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
6070:
6071: EXCEPTION
6072: WHEN OTHERS THEN
6073: p_return_code := 2;