eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_TCS_REP_PKG dependencies on JAI_AR_TCS_REP_PKG

Line 1: package body jai_ar_tcs_rep_pkg AS

1: package body jai_ar_tcs_rep_pkg AS
2: /* $Header: jai_tcs_repo_pkg.plb 120.30.12020000.2 2013/03/18 06:02:20 zxin ship $ */
3:
4:
5: /** Package level variables used in debug package*/

Line 6: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE DEFAULT 'TCS.JAI_AR_TCS_REP_PKG';

2: /* $Header: jai_tcs_repo_pkg.plb 120.30.12020000.2 2013/03/18 06:02:20 zxin ship $ */
3:
4:
5: /** Package level variables used in debug package*/
6: lv_object_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE DEFAULT 'TCS.JAI_AR_TCS_REP_PKG';
7: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
8: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
9: /****
10: || Get the primary key

Line 126: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.JAI_AR_TCS_REP_PKG.get_tcs_fin_year'

122: OPEN c_get_period_year(lv_gl_calendar_id,cp_trx_date);
123: FETCH c_get_period_year INTO lv_fin_year;
124: CLOSE c_get_period_year;
125:
126: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_STATEMENT, 'JAI.PLSQL.JAI_AR_TCS_REP_PKG.get_tcs_fin_year'
127: ,'Get ' || cp_rgm_code || ' Finanical year: ' || lv_fin_year);
128: return lv_fin_year;
129:
130: EXCEPTION

Line 132: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_UNEXPECTED, 'JAI.PLSQL.JAI_AR_TCS_REP_PKG.get_tcs_fin_year.Other_Exception '

128: return lv_fin_year;
129:
130: EXCEPTION
131: WHEN OTHERS THEN
132: jai_cmn_utils_pkg.WRITE_FND_LOG(FND_LOG.LEVEL_UNEXPECTED, 'JAI.PLSQL.JAI_AR_TCS_REP_PKG.get_tcs_fin_year.Other_Exception '
133: , SQLCODE || ':' || SQLERRM
134: );
135:
136: END get_tcs_fin_year;

Line 200: v_ref_23 := 'jai_ar_tcs_rep_pkg.wsh_interim_accounting';

196: || VARIABLES INITIALIZATION - PART -1
197: ########################################################################################################*/
198: lv_member_name := 'WSH_INTERIM_ACCOUNTING';
199: v_std_text := 'India Localization Entry for sales order #' ;
200: v_ref_23 := 'jai_ar_tcs_rep_pkg.wsh_interim_accounting';
201: v_ref_24 := 'wsh_new_deliveries';
202: v_ref_25 := 'delivery_id';
203: -- lv_source_name := jai_constants.tcs_source ; -- modified by csahoo for bug#6155839
204: -- lv_category_name := 'Receivables India' ; -- modified by csahoo for bug#6155839

Line 387: p_process_message := 'Unexpected error in the jai_ar_tcs_rep_pkg.wsh_interim_accounting '||substr(sqlerrm,1,300);

383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: p_process_flag := jai_constants.unexpected_error;
387: p_process_message := 'Unexpected error in the jai_ar_tcs_rep_pkg.wsh_interim_accounting '||substr(sqlerrm,1,300);
388:
389: END wsh_interim_accounting;
390:
391: /*Bug 12543504 - Fetches the TCS Taxes from RMA Receipt. Moves the TCS Liability to Interim Liability as this is Receipt for RMA Order

Line 738: p_process_message := 'Unexpected error in the jai_ar_tcs_rep_pkg.receipt_interim_accounting '||substr(sqlerrm,1,300);

734:
735: EXCEPTION
736: WHEN OTHERS THEN
737: p_process_flag := jai_constants.unexpected_error;
738: p_process_message := 'Unexpected error in the jai_ar_tcs_rep_pkg.receipt_interim_accounting '||substr(sqlerrm,1,300);
739:
740: END receipt_interim_accounting;
741:
742: /*Bug 12543504 - End*/

Line 823: v_ref_23 := 'jai_ar_tcs_rep_pkg.ar_accounting';

819: /*########################################################################################################
820: || VARIABLES INITIALIZATION - PART -1
821: ########################################################################################################*/
822: lv_member_name := 'AR_ACCOUNTING';
823: v_ref_23 := 'jai_ar_tcs_rep_pkg.ar_accounting';
824: v_ref_24 := 'ra_customer_trx_all' ;
825: v_ref_25 := 'customer_trx_id' ;
826: -- lv_source_name := jai_constants.tcs_source ; -- modified by csahoo for bug#6155839 commented for bug#9587338
827: -- lv_category_name := 'Receivables India' ; -- modified by csahoo for bug#6155839 commented for bug#9587338

Line 1035: p_process_message := 'Unexpected error in the jai_ar_tcs_rep_pkg.man_ar_completion_accounting '||substr(sqlerrm,1,300);

1031:
1032: EXCEPTION
1033: WHEN OTHERS THEN
1034: p_process_flag := jai_constants.unexpected_error;
1035: p_process_message := 'Unexpected error in the jai_ar_tcs_rep_pkg.man_ar_completion_accounting '||substr(sqlerrm,1,300);
1036:
1037: END ar_accounting;
1038:
1039:

Line 1128: lv_object_name := 'TCS.JAI_AR_TCS_REP_PKG';

1124: /*########################################################################################################
1125: || VARIABLES INITIALIZATION - PART -1
1126: ########################################################################################################*/
1127: lv_member_name := 'VALIDATE_SALES_ORDER';
1128: lv_object_name := 'TCS.JAI_AR_TCS_REP_PKG';
1129: set_debug_context;
1130: /*commented by csahoo for bug# 6401388
1131: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context ,
1132: pn_reg_id => ln_reg_id

Line 3140: pv_log_msg => ' before call to jai_ar_tcs_rep_pkg.process_transactions '

3136: || cash receipt applications/unapplications
3137: *******************************************/
3138: /*commented by csahoo for bug# 6401388
3139: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3140: pv_log_msg => ' before call to jai_ar_tcs_rep_pkg.process_transactions '
3141: );*/
3142: jai_ar_tcs_rep_pkg.process_transactions ( p_araa => p_araa ,
3143: p_event => p_araa.application_type ,
3144: -- p_called_from => lv_document_type ,

Line 3142: jai_ar_tcs_rep_pkg.process_transactions ( p_araa => p_araa ,

3138: /*commented by csahoo for bug# 6401388
3139: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3140: pv_log_msg => ' before call to jai_ar_tcs_rep_pkg.process_transactions '
3141: );*/
3142: jai_ar_tcs_rep_pkg.process_transactions ( p_araa => p_araa ,
3143: p_event => p_araa.application_type ,
3144: -- p_called_from => lv_document_type ,
3145: p_process_flag => lv_process_flag ,
3146: p_process_message => lv_process_message

Line 3150: pv_log_msg => ' Return from jai_ar_tcs_rep_pkg.process_transactions '

3146: p_process_message => lv_process_message
3147: );
3148: /*commented by csahoo for bug# 6401388
3149: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3150: pv_log_msg => ' Return from jai_ar_tcs_rep_pkg.process_transactions '
3151: );*/
3152: IF lv_process_flag = jai_constants.expected_error OR ---------A2
3153: lv_process_flag = jai_constants.unexpected_error OR
3154: lv_process_flag = jai_constants.not_applicable

Line 5818: p_process_message := ' Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document'||substr(SQLERRM,1,300) ;

5814: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
5815: EXCEPTION
5816: WHEN OTHERS THEN
5817: p_process_flag := jai_constants.unexpected_error;
5818: p_process_message := ' Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document'||substr(SQLERRM,1,300) ;
5819: /*commented by csahoo for bug# 6401388
5820: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5821: pv_log_msg => 'Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document -> '||substr(SQLERRM,1,300)
5822: );*/

Line 5821: pv_log_msg => 'Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document -> '||substr(SQLERRM,1,300)

5817: p_process_flag := jai_constants.unexpected_error;
5818: p_process_message := ' Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document'||substr(SQLERRM,1,300) ;
5819: /*commented by csahoo for bug# 6401388
5820: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5821: pv_log_msg => 'Unexpected error occured while processing jai_ar_tcs_rep_pkg.generate_document -> '||substr(SQLERRM,1,300)
5822: );*/
5823:
5824: END generate_document;
5825:

Line 6601: p_process_message := lv_context||' Unexpected error occured while processing jai_ar_tcs_rep_pkg.process_transactions'||SQLERRM ;

6597: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
6598: EXCEPTION
6599: WHEN OTHERS THEN
6600: p_process_flag := jai_constants.unexpected_error;
6601: p_process_message := lv_context||' Unexpected error occured while processing jai_ar_tcs_rep_pkg.process_transactions'||SQLERRM ;
6602: /*commented by csahoo for bug# 6401388
6603: jai_cmn_debug_contexts_pkg.print( pn_reg_id => ln_reg_id ,
6604: pv_log_msg => p_process_message ,
6605: pn_statement_level => jai_cmn_debug_contexts_pkg.summary

Line 6691: p_errbuf := 'Unexpected error in the jai_ar_tcs_rep_pkg.update_pan_for_tcs '||substr(sqlerrm,1,300);

6687:
6688: EXCEPTION
6689: WHEN OTHERS THEN
6690: p_return_code := 2;
6691: p_errbuf := 'Unexpected error in the jai_ar_tcs_rep_pkg.update_pan_for_tcs '||substr(sqlerrm,1,300);
6692:
6693: END update_pan_for_tcs;
6694: END jai_ar_tcs_rep_pkg;

Line 6694: END jai_ar_tcs_rep_pkg;

6690: p_return_code := 2;
6691: p_errbuf := 'Unexpected error in the jai_ar_tcs_rep_pkg.update_pan_for_tcs '||substr(sqlerrm,1,300);
6692:
6693: END update_pan_for_tcs;
6694: END jai_ar_tcs_rep_pkg;