DBA Data[Home] [Help]

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.11.12010000.2 2008/08/07 13:51:04 jmeena 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.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

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

120: || VARIABLES INITIALIZATION - PART -1
121: ########################################################################################################*/
122: lv_member_name := 'WSH_INTERIM_ACCOUNTING';
123: v_std_text := 'India Localization Entry for sales order #' ;
124: v_ref_23 := 'jai_ar_tcs_rep_pkg.wsh_interim_accounting';
125: v_ref_24 := 'wsh_new_deliveries';
126: v_ref_25 := 'delivery_id';
127: lv_source_name := jai_constants.tcs_source ; -- modified by csahoo for bug#6155839
128: lv_category_name := 'Receivables India' ; -- modified by csahoo for bug#6155839

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

306:
307: EXCEPTION
308: WHEN OTHERS THEN
309: p_process_flag := jai_constants.unexpected_error;
310: p_process_message := 'Unexpected error in the jai_ar_tcs_rep_pkg.wsh_interim_accounting '||substr(sqlerrm,1,300);
311:
312: END wsh_interim_accounting;
313:
314: PROCEDURE ar_accounting ( p_ract IN RA_CUSTOMER_TRX_ALL%ROWTYPE DEFAULT NULL ,

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

361: /*########################################################################################################
362: || VARIABLES INITIALIZATION - PART -1
363: ########################################################################################################*/
364: lv_member_name := 'AR_ACCOUNTING';
365: v_ref_23 := 'jai_ar_tcs_rep_pkg.ar_accounting';
366: v_ref_24 := 'ra_customer_trx_all' ;
367: v_ref_25 := 'customer_trx_id' ;
368: lv_source_name := jai_constants.tcs_source ; -- modified by csahoo for bug#6155839
369: lv_category_name := 'Receivables India' ; -- modified by csahoo for bug#6155839

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

545:
546: EXCEPTION
547: WHEN OTHERS THEN
548: p_process_flag := jai_constants.unexpected_error;
549: p_process_message := 'Unexpected error in the jai_ar_tcs_rep_pkg.man_ar_completion_accounting '||substr(sqlerrm,1,300);
550:
551: END ar_accounting;
552:
553:

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

634: /*########################################################################################################
635: || VARIABLES INITIALIZATION - PART -1
636: ########################################################################################################*/
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

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

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 ,
2629: -- p_called_from => lv_document_type ,

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

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 ,
2629: -- p_called_from => lv_document_type ,
2630: p_process_flag => lv_process_flag ,
2631: p_process_message => lv_process_message

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

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
2639: lv_process_flag = jai_constants.not_applicable

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

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) ;
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: );*/

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

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;
5213:

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

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 ;
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

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

6070:
6071: EXCEPTION
6072: WHEN OTHERS THEN
6073: p_return_code := 2;
6074: p_errbuf := 'Unexpected error in the jai_ar_tcs_rep_pkg.update_pan_for_tcs '||substr(sqlerrm,1,300);
6075:
6076: END update_pan_for_tcs;
6077: END jai_ar_tcs_rep_pkg;

Line 6077: END jai_ar_tcs_rep_pkg;

6073: p_return_code := 2;
6074: p_errbuf := 'Unexpected error in the jai_ar_tcs_rep_pkg.update_pan_for_tcs '||substr(sqlerrm,1,300);
6075:
6076: END update_pan_for_tcs;
6077: END jai_ar_tcs_rep_pkg;