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_TRX_REPO_EXTRACT_PKG dependencies on FND_GLOBAL

Line 196: lv_user_id fnd_user.user_id%type default fnd_global.user_id;

192:
193: --
194: -- Global variables used throught the package
195: --
196: lv_user_id fnd_user.user_id%type default fnd_global.user_id;
197: lv_login_id fnd_logins.login_id%type default fnd_global.login_id;
198:
199: function get_settled_service_type
200: ( p_transaction_source jai_trx_repo_extract_gt.transaction_source%type

Line 197: lv_login_id fnd_logins.login_id%type default fnd_global.login_id;

193: --
194: -- Global variables used throught the package
195: --
196: lv_user_id fnd_user.user_id%type default fnd_global.user_id;
197: lv_login_id fnd_logins.login_id%type default fnd_global.login_id;
198:
199: function get_settled_service_type
200: ( p_transaction_source jai_trx_repo_extract_gt.transaction_source%type
201: , p_document_id jai_trx_repo_extract_gt.document_id%type

Line 710: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||

706: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
707: , pn_reg_id => ln_reg_id
708: );
709:
710: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
711: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
712: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
713: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
714: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||

Line 711: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||

707: , pn_reg_id => ln_reg_id
708: );
709:
710: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
711: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
712: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
713: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
714: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
715: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||

Line 712: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||

708: );
709:
710: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
711: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
712: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
713: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
714: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
715: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||
716: 'p_query_settled_flag='||p_query_settled_flag

Line 713: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||

709:
710: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
711: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
712: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
713: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
714: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
715: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||
716: 'p_query_settled_flag='||p_query_settled_flag
717: );

Line 714: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||

710: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
711: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
712: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
713: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
714: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
715: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||
716: 'p_query_settled_flag='||p_query_settled_flag
717: );
718:

Line 715: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||

711: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
712: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
713: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
714: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
715: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||
716: 'p_query_settled_flag='||p_query_settled_flag
717: );
718:
719: for r_repo_recs in c_get_repo_recs

Line 727: jai_cmn_debug_contexts_pkg.print (ln_reg_id, '2. r_repo_recs.service_type_code ='||r_repo_recs.service_type_code || fnd_global.local_chr(10)

723: lr_trx_repo_extract := null;
724:
725: jai_cmn_debug_contexts_pkg.print (ln_reg_id, '1. r_repo_recs.service_type_code ='||r_repo_recs.service_type_code );
726:
727: jai_cmn_debug_contexts_pkg.print (ln_reg_id, '2. r_repo_recs.service_type_code ='||r_repo_recs.service_type_code || fnd_global.local_chr(10)
728: ||',r_repo_recs.source='||r_repo_recs.source );
729: lr_trx_repo_extract.gl_date := NULL;--Add by Xiao for POT Phase III changes, reg bug#12895841 on 1-Aug-2011 --Added by Chong.Lei for POT code port
730:
731: --if r_repo_recs.source in ('AP','AR') then --Commented by Chong.Lei for POT code port

Line 946: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||

942: --Added by Qiong for bug13405553 end
943:
944: jai_cmn_debug_contexts_pkg.print
945: (ln_reg_id
946: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
947: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
948: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
949: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||

Line 947: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||

943:
944: jai_cmn_debug_contexts_pkg.print
945: (ln_reg_id
946: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
947: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
948: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
949: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||

Line 948: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||

944: jai_cmn_debug_contexts_pkg.print
945: (ln_reg_id
946: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
947: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
948: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
949: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||

Line 949: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||

945: (ln_reg_id
946: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
947: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
948: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
949: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
953: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||

Line 950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||

946: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
947: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
948: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
949: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
953: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
954: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||

Line 951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||

947: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
948: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
949: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
953: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
954: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
955: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||

Line 952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||

948: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
949: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
953: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
954: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
955: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
956: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||

Line 953: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||

949: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
953: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
954: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
955: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
956: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
957: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc

Line 954: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||

950: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
953: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
954: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
955: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
956: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
957: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
958: );

Line 955: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||

951: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
953: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
954: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
955: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
956: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
957: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
958: );
959: jai_cmn_debug_contexts_pkg.print

Line 956: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||

952: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
953: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
954: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
955: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
956: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
957: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
958: );
959: jai_cmn_debug_contexts_pkg.print
960: ( ln_reg_id

Line 961: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||

957: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
958: );
959: jai_cmn_debug_contexts_pkg.print
960: ( ln_reg_id
961: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
962: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
963: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
964: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||

Line 962: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||

958: );
959: jai_cmn_debug_contexts_pkg.print
960: ( ln_reg_id
961: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
962: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
963: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
964: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||

Line 963: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||

959: jai_cmn_debug_contexts_pkg.print
960: ( ln_reg_id
961: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
962: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
963: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
964: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||

Line 964: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||

960: ( ln_reg_id
961: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
962: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
963: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
964: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
968: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||

Line 965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||

961: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
962: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
963: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
964: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
968: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
969: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||

Line 966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||

962: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
963: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
964: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
968: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
969: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
970: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||

Line 967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||

963: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
964: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
968: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
969: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
970: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
971: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||

Line 968: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||

964: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
968: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
969: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
970: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
971: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
972: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code

Line 969: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||

965: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
968: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
969: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
970: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
971: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
972: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code
973: );

Line 970: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||

966: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
968: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
969: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
970: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
971: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
972: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code
973: );
974: insert into jai_trx_repo_extract_gt

Line 971: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||

967: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
968: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
969: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
970: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
971: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
972: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code
973: );
974: insert into jai_trx_repo_extract_gt
975: (

Line 1266: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||

1262:
1263:
1264: jai_cmn_debug_contexts_pkg.print
1265: (ln_reg_id
1266: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
1267: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
1268: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
1269: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||

Line 1267: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||

1263:
1264: jai_cmn_debug_contexts_pkg.print
1265: (ln_reg_id
1266: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
1267: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
1268: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
1269: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
1271: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||

Line 1268: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||

1264: jai_cmn_debug_contexts_pkg.print
1265: (ln_reg_id
1266: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
1267: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
1268: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
1269: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
1271: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
1272: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||

Line 1269: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||

1265: (ln_reg_id
1266: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
1267: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
1268: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
1269: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
1271: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
1272: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
1273: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||

Line 1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||

1266: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
1267: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
1268: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
1269: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
1271: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
1272: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
1273: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
1274: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||

Line 1271: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||

1267: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
1268: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
1269: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
1271: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
1272: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
1273: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
1274: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
1275: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc

Line 1272: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||

1268: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
1269: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
1271: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
1272: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
1273: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
1274: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
1275: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
1276: );

Line 1273: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||

1269: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
1271: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
1272: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
1273: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
1274: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
1275: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
1276: );
1277: jai_cmn_debug_contexts_pkg.print

Line 1274: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||

1270: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
1271: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
1272: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
1273: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
1274: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
1275: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
1276: );
1277: jai_cmn_debug_contexts_pkg.print
1278: ( ln_reg_id

Line 1279: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||

1275: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
1276: );
1277: jai_cmn_debug_contexts_pkg.print
1278: ( ln_reg_id
1279: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
1280: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
1281: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
1282: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||

Line 1280: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||

1276: );
1277: jai_cmn_debug_contexts_pkg.print
1278: ( ln_reg_id
1279: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
1280: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
1281: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
1282: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||

Line 1281: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||

1277: jai_cmn_debug_contexts_pkg.print
1278: ( ln_reg_id
1279: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
1280: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
1281: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
1282: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||

Line 1282: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||

1278: ( ln_reg_id
1279: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
1280: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
1281: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
1282: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||

Line 1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||

1279: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
1280: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
1281: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
1282: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||

Line 1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||

1280: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
1281: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
1282: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
1288: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||

Line 1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||

1281: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
1282: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
1288: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
1289: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||

Line 1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||

1282: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
1288: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
1289: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
1290: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||

Line 1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||

1283: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
1288: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
1289: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
1290: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
1291: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||

Line 1288: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||

1284: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
1288: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
1289: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
1290: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
1291: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||
1292: 'lr_trx_repo_extract.processed_flag ='|| lr_trx_repo_extract.processed_flag

Line 1289: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||

1285: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
1288: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
1289: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
1290: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
1291: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||
1292: 'lr_trx_repo_extract.processed_flag ='|| lr_trx_repo_extract.processed_flag
1293: );

Line 1290: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||

1286: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
1288: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
1289: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
1290: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
1291: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||
1292: 'lr_trx_repo_extract.processed_flag ='|| lr_trx_repo_extract.processed_flag
1293: );
1294:

Line 1291: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||

1287: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
1288: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
1289: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
1290: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
1291: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||
1292: 'lr_trx_repo_extract.processed_flag ='|| lr_trx_repo_extract.processed_flag
1293: );
1294:
1295: update jai_trx_repo_extract_gt

Line 2225: ,'Call Parameters:' ||fnd_global.local_chr(10)

2221: , pn_reg_id => ln_reg_id
2222: );
2223:
2224: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2225: ,'Call Parameters:' ||fnd_global.local_chr(10)
2226: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
2227: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2228: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2229: );

Line 2226: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)

2222: );
2223:
2224: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2225: ,'Call Parameters:' ||fnd_global.local_chr(10)
2226: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
2227: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2228: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2229: );
2230:

Line 2227: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)

2223:
2224: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2225: ,'Call Parameters:' ||fnd_global.local_chr(10)
2226: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
2227: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2228: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2229: );
2230:
2231: fnd_file.put_line(fnd_file.log,' Call Parameters for get_document_details procedure :' ||fnd_global.local_chr(10)

Line 2228: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)

2224: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2225: ,'Call Parameters:' ||fnd_global.local_chr(10)
2226: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
2227: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2228: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2229: );
2230:
2231: fnd_file.put_line(fnd_file.log,' Call Parameters for get_document_details procedure :' ||fnd_global.local_chr(10)
2232: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)

Line 2231: fnd_file.put_line(fnd_file.log,' Call Parameters for get_document_details procedure :' ||fnd_global.local_chr(10)

2227: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2228: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2229: );
2230:
2231: fnd_file.put_line(fnd_file.log,' Call Parameters for get_document_details procedure :' ||fnd_global.local_chr(10)
2232: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
2233: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2234: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2235: ); --12560704

Line 2232: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)

2228: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2229: );
2230:
2231: fnd_file.put_line(fnd_file.log,' Call Parameters for get_document_details procedure :' ||fnd_global.local_chr(10)
2232: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
2233: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2234: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2235: ); --12560704
2236:

Line 2233: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)

2229: );
2230:
2231: fnd_file.put_line(fnd_file.log,' Call Parameters for get_document_details procedure :' ||fnd_global.local_chr(10)
2232: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
2233: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2234: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2235: ); --12560704
2236:
2237: if p_document_line_id is null or p_document_source is null then

Line 2234: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)

2230:
2231: fnd_file.put_line(fnd_file.log,' Call Parameters for get_document_details procedure :' ||fnd_global.local_chr(10)
2232: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
2233: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
2234: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
2235: ); --12560704
2236:
2237: if p_document_line_id is null or p_document_source is null then
2238: fnd_file.put_line(fnd_file.log,'Document references cannot be null, cannot continue to derive the document details'); --12560704

Line 2261: fnd_file.put_line(fnd_file.log,'Purchase transaction details are r_po_details.document_id '||r_po_details.document_id||fnd_global.local_chr(10)

2257: ,'Purchase Order does not exists for po_header_id ='||p_document_id ||' and po_line_id='|| p_document_line_id
2258: );
2259: end if;
2260:
2261: fnd_file.put_line(fnd_file.log,'Purchase transaction details are r_po_details.document_id '||r_po_details.document_id||fnd_global.local_chr(10)
2262: ||'r_po_details.document_line_id =' ||r_po_details.document_line_id ||fnd_global.local_chr(10)
2263: ||'r_po_details.document_line_amt =' ||r_po_details.document_line_amt ||fnd_global.local_chr(10)
2264: ||'r_po_details.organization_id =' ||r_po_details.organization_id ||fnd_global.local_chr(10)
2265: ||'r_po_details.location_id =' ||r_po_details.location_id ||fnd_global.local_chr(10)); --12560704

Line 2262: ||'r_po_details.document_line_id =' ||r_po_details.document_line_id ||fnd_global.local_chr(10)

2258: );
2259: end if;
2260:
2261: fnd_file.put_line(fnd_file.log,'Purchase transaction details are r_po_details.document_id '||r_po_details.document_id||fnd_global.local_chr(10)
2262: ||'r_po_details.document_line_id =' ||r_po_details.document_line_id ||fnd_global.local_chr(10)
2263: ||'r_po_details.document_line_amt =' ||r_po_details.document_line_amt ||fnd_global.local_chr(10)
2264: ||'r_po_details.organization_id =' ||r_po_details.organization_id ||fnd_global.local_chr(10)
2265: ||'r_po_details.location_id =' ||r_po_details.location_id ||fnd_global.local_chr(10)); --12560704
2266:

Line 2263: ||'r_po_details.document_line_amt =' ||r_po_details.document_line_amt ||fnd_global.local_chr(10)

2259: end if;
2260:
2261: fnd_file.put_line(fnd_file.log,'Purchase transaction details are r_po_details.document_id '||r_po_details.document_id||fnd_global.local_chr(10)
2262: ||'r_po_details.document_line_id =' ||r_po_details.document_line_id ||fnd_global.local_chr(10)
2263: ||'r_po_details.document_line_amt =' ||r_po_details.document_line_amt ||fnd_global.local_chr(10)
2264: ||'r_po_details.organization_id =' ||r_po_details.organization_id ||fnd_global.local_chr(10)
2265: ||'r_po_details.location_id =' ||r_po_details.location_id ||fnd_global.local_chr(10)); --12560704
2266:
2267:

Line 2264: ||'r_po_details.organization_id =' ||r_po_details.organization_id ||fnd_global.local_chr(10)

2260:
2261: fnd_file.put_line(fnd_file.log,'Purchase transaction details are r_po_details.document_id '||r_po_details.document_id||fnd_global.local_chr(10)
2262: ||'r_po_details.document_line_id =' ||r_po_details.document_line_id ||fnd_global.local_chr(10)
2263: ||'r_po_details.document_line_amt =' ||r_po_details.document_line_amt ||fnd_global.local_chr(10)
2264: ||'r_po_details.organization_id =' ||r_po_details.organization_id ||fnd_global.local_chr(10)
2265: ||'r_po_details.location_id =' ||r_po_details.location_id ||fnd_global.local_chr(10)); --12560704
2266:
2267:
2268: p_trx_repo_extract.transaction_source := 'PURCHASING' ;

Line 2265: ||'r_po_details.location_id =' ||r_po_details.location_id ||fnd_global.local_chr(10)); --12560704

2261: fnd_file.put_line(fnd_file.log,'Purchase transaction details are r_po_details.document_id '||r_po_details.document_id||fnd_global.local_chr(10)
2262: ||'r_po_details.document_line_id =' ||r_po_details.document_line_id ||fnd_global.local_chr(10)
2263: ||'r_po_details.document_line_amt =' ||r_po_details.document_line_amt ||fnd_global.local_chr(10)
2264: ||'r_po_details.organization_id =' ||r_po_details.organization_id ||fnd_global.local_chr(10)
2265: ||'r_po_details.location_id =' ||r_po_details.location_id ||fnd_global.local_chr(10)); --12560704
2266:
2267:
2268: p_trx_repo_extract.transaction_source := 'PURCHASING' ;
2269: p_trx_repo_extract.party_name := r_po_details.party_name ;

Line 2307: fnd_file.put_line(fnd_file.log,'c_get_rcv_details details for po receipt v_organization_id= '||v_organization_id||fnd_global.local_chr(10)

2303:
2304: open c_get_rcv_details;
2305: fetch c_get_rcv_details into v_organization_id,v_location_id,v_po_header_id,v_po_line_id,v_transaction_id;
2306: close c_get_rcv_details;
2307: fnd_file.put_line(fnd_file.log,'c_get_rcv_details details for po receipt v_organization_id= '||v_organization_id||fnd_global.local_chr(10)
2308: || ' v_location_id = '||v_location_id|| fnd_global.local_chr(10) || ' v_po_header_id = '||v_po_header_id||' v_po_line_id --> '||v_po_line_id ); --12560704
2309:
2310: open c_get_receipt_details(v_transaction_id);
2311: fetch c_get_receipt_details into r_rcv_details;

Line 2308: || ' v_location_id = '||v_location_id|| fnd_global.local_chr(10) || ' v_po_header_id = '||v_po_header_id||' v_po_line_id --> '||v_po_line_id ); --12560704

2304: open c_get_rcv_details;
2305: fetch c_get_rcv_details into v_organization_id,v_location_id,v_po_header_id,v_po_line_id,v_transaction_id;
2306: close c_get_rcv_details;
2307: fnd_file.put_line(fnd_file.log,'c_get_rcv_details details for po receipt v_organization_id= '||v_organization_id||fnd_global.local_chr(10)
2308: || ' v_location_id = '||v_location_id|| fnd_global.local_chr(10) || ' v_po_header_id = '||v_po_header_id||' v_po_line_id --> '||v_po_line_id ); --12560704
2309:
2310: open c_get_receipt_details(v_transaction_id);
2311: fetch c_get_receipt_details into r_rcv_details;
2312: close c_get_receipt_details;

Line 2342: fnd_file.put_line(fnd_file.log,'Receiving transaction details are r_rcv_details.document_id '||r_rcv_details.document_id||fnd_global.local_chr(10)

2338: p_trx_repo_extract.location_id := r_rcv_details.location_id;
2339: else
2340: p_trx_repo_extract.location_id := v_location_id;
2341: end if;
2342: fnd_file.put_line(fnd_file.log,'Receiving transaction details are r_rcv_details.document_id '||r_rcv_details.document_id||fnd_global.local_chr(10)
2343: ||'r_rcv_details.document_line_id =' ||r_rcv_details.document_line_id ||fnd_global.local_chr(10)
2344: ||'r_rcv_details.document_line_amt =' ||r_rcv_details.document_line_amt ||fnd_global.local_chr(10)
2345: ||'r_rcv_details.organization_id =' ||r_rcv_details.organization_id ||fnd_global.local_chr(10)
2346: ||'r_rcv_details.location_id =' ||r_rcv_details.location_id ||fnd_global.local_chr(10));--12560704

Line 2343: ||'r_rcv_details.document_line_id =' ||r_rcv_details.document_line_id ||fnd_global.local_chr(10)

2339: else
2340: p_trx_repo_extract.location_id := v_location_id;
2341: end if;
2342: fnd_file.put_line(fnd_file.log,'Receiving transaction details are r_rcv_details.document_id '||r_rcv_details.document_id||fnd_global.local_chr(10)
2343: ||'r_rcv_details.document_line_id =' ||r_rcv_details.document_line_id ||fnd_global.local_chr(10)
2344: ||'r_rcv_details.document_line_amt =' ||r_rcv_details.document_line_amt ||fnd_global.local_chr(10)
2345: ||'r_rcv_details.organization_id =' ||r_rcv_details.organization_id ||fnd_global.local_chr(10)
2346: ||'r_rcv_details.location_id =' ||r_rcv_details.location_id ||fnd_global.local_chr(10));--12560704
2347:

Line 2344: ||'r_rcv_details.document_line_amt =' ||r_rcv_details.document_line_amt ||fnd_global.local_chr(10)

2340: p_trx_repo_extract.location_id := v_location_id;
2341: end if;
2342: fnd_file.put_line(fnd_file.log,'Receiving transaction details are r_rcv_details.document_id '||r_rcv_details.document_id||fnd_global.local_chr(10)
2343: ||'r_rcv_details.document_line_id =' ||r_rcv_details.document_line_id ||fnd_global.local_chr(10)
2344: ||'r_rcv_details.document_line_amt =' ||r_rcv_details.document_line_amt ||fnd_global.local_chr(10)
2345: ||'r_rcv_details.organization_id =' ||r_rcv_details.organization_id ||fnd_global.local_chr(10)
2346: ||'r_rcv_details.location_id =' ||r_rcv_details.location_id ||fnd_global.local_chr(10));--12560704
2347:
2348: open c_get_rcv_line_loc_srvtyp (cp_po_line_id => v_po_line_id) ;

Line 2345: ||'r_rcv_details.organization_id =' ||r_rcv_details.organization_id ||fnd_global.local_chr(10)

2341: end if;
2342: fnd_file.put_line(fnd_file.log,'Receiving transaction details are r_rcv_details.document_id '||r_rcv_details.document_id||fnd_global.local_chr(10)
2343: ||'r_rcv_details.document_line_id =' ||r_rcv_details.document_line_id ||fnd_global.local_chr(10)
2344: ||'r_rcv_details.document_line_amt =' ||r_rcv_details.document_line_amt ||fnd_global.local_chr(10)
2345: ||'r_rcv_details.organization_id =' ||r_rcv_details.organization_id ||fnd_global.local_chr(10)
2346: ||'r_rcv_details.location_id =' ||r_rcv_details.location_id ||fnd_global.local_chr(10));--12560704
2347:
2348: open c_get_rcv_line_loc_srvtyp (cp_po_line_id => v_po_line_id) ;
2349: fetch c_get_rcv_line_loc_srvtyp into lv_service_type,p_trx_repo_extract.repository_tax_amt;

Line 2346: ||'r_rcv_details.location_id =' ||r_rcv_details.location_id ||fnd_global.local_chr(10));--12560704

2342: fnd_file.put_line(fnd_file.log,'Receiving transaction details are r_rcv_details.document_id '||r_rcv_details.document_id||fnd_global.local_chr(10)
2343: ||'r_rcv_details.document_line_id =' ||r_rcv_details.document_line_id ||fnd_global.local_chr(10)
2344: ||'r_rcv_details.document_line_amt =' ||r_rcv_details.document_line_amt ||fnd_global.local_chr(10)
2345: ||'r_rcv_details.organization_id =' ||r_rcv_details.organization_id ||fnd_global.local_chr(10)
2346: ||'r_rcv_details.location_id =' ||r_rcv_details.location_id ||fnd_global.local_chr(10));--12560704
2347:
2348: open c_get_rcv_line_loc_srvtyp (cp_po_line_id => v_po_line_id) ;
2349: fetch c_get_rcv_line_loc_srvtyp into lv_service_type,p_trx_repo_extract.repository_tax_amt;
2350: close c_get_rcv_line_loc_srvtyp;

Line 2814: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are r_ap_details.document_id '||r_ap_details.document_id||fnd_global.local_chr(10)

2810:
2811: p_trx_repo_extract.repository_tax_amt := ln_repository_tax_amount;
2812: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details p_trx_repo_extract.repository_tax_amt '||p_trx_repo_extract.repository_tax_amt);--12560704
2813:
2814: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are r_ap_details.document_id '||r_ap_details.document_id||fnd_global.local_chr(10)
2815: ||'r_ap_details.document_line_id =' ||r_ap_details.document_line_id ||fnd_global.local_chr(10)
2816: ||'r_ap_details.document_line_num =' ||r_ap_details.document_line_num ||fnd_global.local_chr(10)
2817: ||'r_ap_details.document_line_qty =' ||r_ap_details.document_line_qty ||fnd_global.local_chr(10)
2818: ||'p_trx_repo_extract.document_line_amt =' ||p_trx_repo_extract.document_line_amt ||fnd_global.local_chr(10)

Line 2815: ||'r_ap_details.document_line_id =' ||r_ap_details.document_line_id ||fnd_global.local_chr(10)

2811: p_trx_repo_extract.repository_tax_amt := ln_repository_tax_amount;
2812: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details p_trx_repo_extract.repository_tax_amt '||p_trx_repo_extract.repository_tax_amt);--12560704
2813:
2814: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are r_ap_details.document_id '||r_ap_details.document_id||fnd_global.local_chr(10)
2815: ||'r_ap_details.document_line_id =' ||r_ap_details.document_line_id ||fnd_global.local_chr(10)
2816: ||'r_ap_details.document_line_num =' ||r_ap_details.document_line_num ||fnd_global.local_chr(10)
2817: ||'r_ap_details.document_line_qty =' ||r_ap_details.document_line_qty ||fnd_global.local_chr(10)
2818: ||'p_trx_repo_extract.document_line_amt =' ||p_trx_repo_extract.document_line_amt ||fnd_global.local_chr(10)
2819: -- comment by Chong.Lei for POT code port start

Line 2816: ||'r_ap_details.document_line_num =' ||r_ap_details.document_line_num ||fnd_global.local_chr(10)

2812: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details p_trx_repo_extract.repository_tax_amt '||p_trx_repo_extract.repository_tax_amt);--12560704
2813:
2814: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are r_ap_details.document_id '||r_ap_details.document_id||fnd_global.local_chr(10)
2815: ||'r_ap_details.document_line_id =' ||r_ap_details.document_line_id ||fnd_global.local_chr(10)
2816: ||'r_ap_details.document_line_num =' ||r_ap_details.document_line_num ||fnd_global.local_chr(10)
2817: ||'r_ap_details.document_line_qty =' ||r_ap_details.document_line_qty ||fnd_global.local_chr(10)
2818: ||'p_trx_repo_extract.document_line_amt =' ||p_trx_repo_extract.document_line_amt ||fnd_global.local_chr(10)
2819: -- comment by Chong.Lei for POT code port start
2820: --||'r_ap_details.organization_id =' ||r_ap_details.organization_id ||fnd_global.local_chr(10)

Line 2817: ||'r_ap_details.document_line_qty =' ||r_ap_details.document_line_qty ||fnd_global.local_chr(10)

2813:
2814: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are r_ap_details.document_id '||r_ap_details.document_id||fnd_global.local_chr(10)
2815: ||'r_ap_details.document_line_id =' ||r_ap_details.document_line_id ||fnd_global.local_chr(10)
2816: ||'r_ap_details.document_line_num =' ||r_ap_details.document_line_num ||fnd_global.local_chr(10)
2817: ||'r_ap_details.document_line_qty =' ||r_ap_details.document_line_qty ||fnd_global.local_chr(10)
2818: ||'p_trx_repo_extract.document_line_amt =' ||p_trx_repo_extract.document_line_amt ||fnd_global.local_chr(10)
2819: -- comment by Chong.Lei for POT code port start
2820: --||'r_ap_details.organization_id =' ||r_ap_details.organization_id ||fnd_global.local_chr(10)
2821: --||'r_ap_details.location_id =' ||r_ap_details.location_id ||fnd_global.local_chr(10)

Line 2818: ||'p_trx_repo_extract.document_line_amt =' ||p_trx_repo_extract.document_line_amt ||fnd_global.local_chr(10)

2814: fnd_file.put_line(fnd_file.log,'Standalone AP invoice details are r_ap_details.document_id '||r_ap_details.document_id||fnd_global.local_chr(10)
2815: ||'r_ap_details.document_line_id =' ||r_ap_details.document_line_id ||fnd_global.local_chr(10)
2816: ||'r_ap_details.document_line_num =' ||r_ap_details.document_line_num ||fnd_global.local_chr(10)
2817: ||'r_ap_details.document_line_qty =' ||r_ap_details.document_line_qty ||fnd_global.local_chr(10)
2818: ||'p_trx_repo_extract.document_line_amt =' ||p_trx_repo_extract.document_line_amt ||fnd_global.local_chr(10)
2819: -- comment by Chong.Lei for POT code port start
2820: --||'r_ap_details.organization_id =' ||r_ap_details.organization_id ||fnd_global.local_chr(10)
2821: --||'r_ap_details.location_id =' ||r_ap_details.location_id ||fnd_global.local_chr(10)
2822: );--12560704

Line 2820: --||'r_ap_details.organization_id =' ||r_ap_details.organization_id ||fnd_global.local_chr(10)

2816: ||'r_ap_details.document_line_num =' ||r_ap_details.document_line_num ||fnd_global.local_chr(10)
2817: ||'r_ap_details.document_line_qty =' ||r_ap_details.document_line_qty ||fnd_global.local_chr(10)
2818: ||'p_trx_repo_extract.document_line_amt =' ||p_trx_repo_extract.document_line_amt ||fnd_global.local_chr(10)
2819: -- comment by Chong.Lei for POT code port start
2820: --||'r_ap_details.organization_id =' ||r_ap_details.organization_id ||fnd_global.local_chr(10)
2821: --||'r_ap_details.location_id =' ||r_ap_details.location_id ||fnd_global.local_chr(10)
2822: );--12560704
2823: -- comment by Chong.Lei for POT code port end
2824: /*10434986 - End*/

Line 2821: --||'r_ap_details.location_id =' ||r_ap_details.location_id ||fnd_global.local_chr(10)

2817: ||'r_ap_details.document_line_qty =' ||r_ap_details.document_line_qty ||fnd_global.local_chr(10)
2818: ||'p_trx_repo_extract.document_line_amt =' ||p_trx_repo_extract.document_line_amt ||fnd_global.local_chr(10)
2819: -- comment by Chong.Lei for POT code port start
2820: --||'r_ap_details.organization_id =' ||r_ap_details.organization_id ||fnd_global.local_chr(10)
2821: --||'r_ap_details.location_id =' ||r_ap_details.location_id ||fnd_global.local_chr(10)
2822: );--12560704
2823: -- comment by Chong.Lei for POT code port end
2824: /*10434986 - End*/
2825: /*

Line 3171: ,'rec.transaction_source='||rec.transaction_source || fnd_global.local_chr(10) ||

3167: for rec in c_get_recs_to_update
3168: loop
3169: -- For each record in temporary table which is not yet processed
3170: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3171: ,'rec.transaction_source='||rec.transaction_source || fnd_global.local_chr(10) ||
3172: 'rec.document_id='||rec.document_id || fnd_global.local_chr(10) ||
3173: 'rec.document_line_id='||rec.document_line_id || fnd_global.local_chr(10) ||
3174: 'rec.service_type_code='||rec.service_type_code
3175: );

Line 3172: 'rec.document_id='||rec.document_id || fnd_global.local_chr(10) ||

3168: loop
3169: -- For each record in temporary table which is not yet processed
3170: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3171: ,'rec.transaction_source='||rec.transaction_source || fnd_global.local_chr(10) ||
3172: 'rec.document_id='||rec.document_id || fnd_global.local_chr(10) ||
3173: 'rec.document_line_id='||rec.document_line_id || fnd_global.local_chr(10) ||
3174: 'rec.service_type_code='||rec.service_type_code
3175: );
3176: --

Line 3173: 'rec.document_line_id='||rec.document_line_id || fnd_global.local_chr(10) ||

3169: -- For each record in temporary table which is not yet processed
3170: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3171: ,'rec.transaction_source='||rec.transaction_source || fnd_global.local_chr(10) ||
3172: 'rec.document_id='||rec.document_id || fnd_global.local_chr(10) ||
3173: 'rec.document_line_id='||rec.document_line_id || fnd_global.local_chr(10) ||
3174: 'rec.service_type_code='||rec.service_type_code
3175: );
3176: --
3177: -- Update the transaction tables with the service type code based on source value

Line 3464: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_get_jai_pa_details ' ||fnd_global.local_chr(10)

3460:
3461: -- Begin 5876390, 6012570
3462: elsif JAI_AR_RCTLA_TRIGGER_PKG.is_this_projects_context (lr_inv_attr.interface_header_context) then -- Invoice imported from Projects
3463:
3464: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_get_jai_pa_details ' ||fnd_global.local_chr(10)
3465: ||'cp_project_number='||lr_inv_attr.interface_line_attribute1 ||fnd_global.local_chr(10)
3466: ||'cp_draft_inv_num='||lr_inv_attr.interface_line_attribute2 ||fnd_global.local_chr(10)
3467: ||'cp_line_num='||lr_inv_attr.interface_line_attribute6 ||fnd_global.local_chr (10)
3468: );

Line 3465: ||'cp_project_number='||lr_inv_attr.interface_line_attribute1 ||fnd_global.local_chr(10)

3461: -- Begin 5876390, 6012570
3462: elsif JAI_AR_RCTLA_TRIGGER_PKG.is_this_projects_context (lr_inv_attr.interface_header_context) then -- Invoice imported from Projects
3463:
3464: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_get_jai_pa_details ' ||fnd_global.local_chr(10)
3465: ||'cp_project_number='||lr_inv_attr.interface_line_attribute1 ||fnd_global.local_chr(10)
3466: ||'cp_draft_inv_num='||lr_inv_attr.interface_line_attribute2 ||fnd_global.local_chr(10)
3467: ||'cp_line_num='||lr_inv_attr.interface_line_attribute6 ||fnd_global.local_chr (10)
3468: );
3469: open c_get_jai_pa_details ( cp_project_number => lr_inv_attr.interface_line_attribute1

Line 3466: ||'cp_draft_inv_num='||lr_inv_attr.interface_line_attribute2 ||fnd_global.local_chr(10)

3462: elsif JAI_AR_RCTLA_TRIGGER_PKG.is_this_projects_context (lr_inv_attr.interface_header_context) then -- Invoice imported from Projects
3463:
3464: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_get_jai_pa_details ' ||fnd_global.local_chr(10)
3465: ||'cp_project_number='||lr_inv_attr.interface_line_attribute1 ||fnd_global.local_chr(10)
3466: ||'cp_draft_inv_num='||lr_inv_attr.interface_line_attribute2 ||fnd_global.local_chr(10)
3467: ||'cp_line_num='||lr_inv_attr.interface_line_attribute6 ||fnd_global.local_chr (10)
3468: );
3469: open c_get_jai_pa_details ( cp_project_number => lr_inv_attr.interface_line_attribute1
3470: , cp_draft_inv_num => lr_inv_attr.interface_line_attribute2

Line 3467: ||'cp_line_num='||lr_inv_attr.interface_line_attribute6 ||fnd_global.local_chr (10)

3463:
3464: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_get_jai_pa_details ' ||fnd_global.local_chr(10)
3465: ||'cp_project_number='||lr_inv_attr.interface_line_attribute1 ||fnd_global.local_chr(10)
3466: ||'cp_draft_inv_num='||lr_inv_attr.interface_line_attribute2 ||fnd_global.local_chr(10)
3467: ||'cp_line_num='||lr_inv_attr.interface_line_attribute6 ||fnd_global.local_chr (10)
3468: );
3469: open c_get_jai_pa_details ( cp_project_number => lr_inv_attr.interface_line_attribute1
3470: , cp_draft_inv_num => lr_inv_attr.interface_line_attribute2
3471: , cp_line_num => lr_inv_attr.interface_line_attribute6

Line 3500: , 'OPEN/FETCH/CLOSE c_get_po_reference'||fnd_global.local_chr(10)

3496: end if; --> lr_inv_attr.created
3497: END IF;
3498: elsif p_reference_source = 'AP' then
3499: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3500: , 'OPEN/FETCH/CLOSE c_get_po_reference'||fnd_global.local_chr(10)
3501: ||'p_reference_invoice_id ='||p_reference_invoice_id
3502: ||'p_reference_item_line_id ='||p_reference_item_line_id
3503: );
3504:

Line 3511: ,'lr_po_reference.po_header_id =' ||lr_po_reference.po_header_id || fnd_global.local_chr(10) ||

3507: );
3508: fetch c_get_po_reference into lr_po_reference;
3509:
3510: jai_cmn_debug_contexts_pkg.print(ln_reg_id
3511: ,'lr_po_reference.po_header_id =' ||lr_po_reference.po_header_id || fnd_global.local_chr(10) ||
3512: 'lr_po_reference.po_line_id =' ||lr_po_reference.po_line_id
3513: );
3514: if c_get_po_reference%FOUND THEN --If condition added by JMEENA for bug#8943349
3515: IF lr_po_reference.rcv_transaction_id is NULL THEN /*If Condition added by vkantamn for Bug#6083978 */