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 74: lv_user_id fnd_user.user_id%type default fnd_global.user_id;

70:
71: --
72: -- Global variables used throught the package
73: --
74: lv_user_id fnd_user.user_id%type default fnd_global.user_id;
75: lv_login_id fnd_logins.login_id%type default fnd_global.login_id;
76:
77: function get_settled_service_type
78: ( p_transaction_source jai_trx_repo_extract_gt.transaction_source%type

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

71: --
72: -- Global variables used throught the package
73: --
74: lv_user_id fnd_user.user_id%type default fnd_global.user_id;
75: lv_login_id fnd_logins.login_id%type default fnd_global.login_id;
76:
77: function get_settled_service_type
78: ( p_transaction_source jai_trx_repo_extract_gt.transaction_source%type
79: , p_document_id jai_trx_repo_extract_gt.document_id%type

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

272: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
273: , pn_reg_id => ln_reg_id
274: );
275:
276: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
277: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
278: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
279: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
280: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||

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

273: , pn_reg_id => ln_reg_id
274: );
275:
276: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
277: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
278: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
279: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
280: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
281: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||

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

274: );
275:
276: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
277: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
278: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
279: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
280: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
281: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||
282: 'p_query_settled_flag='||p_query_settled_flag

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

275:
276: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
277: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
278: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
279: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
280: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
281: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||
282: 'p_query_settled_flag='||p_query_settled_flag
283: );

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

276: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
277: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
278: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
279: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
280: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
281: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||
282: 'p_query_settled_flag='||p_query_settled_flag
283: );
284:

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

277: 'p_regime_code =' ||p_regime_code || fnd_global.local_chr(10) ||
278: 'p_organization_id=' ||p_organization_id || fnd_global.local_chr(10) ||
279: 'p_location_id =' ||p_location_id || fnd_global.local_chr(10) ||
280: 'p_from_trx_date =' ||p_from_trx_date || fnd_global.local_chr(10) ||
281: 'p_to_trx_date =' ||p_to_trx_date || fnd_global.local_chr(10) ||
282: 'p_query_settled_flag='||p_query_settled_flag
283: );
284:
285: for r_repo_recs in c_get_repo_recs

Line 293: 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)

289: lr_trx_repo_extract := null;
290:
291: jai_cmn_debug_contexts_pkg.print (ln_reg_id, '1. r_repo_recs.service_type_code ='||r_repo_recs.service_type_code );
292:
293: 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)
294: ||',r_repo_recs.source='||r_repo_recs.source );
295:
296: if r_repo_recs.source in ('AP','AR') then
297:

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

393: lr_trx_repo_extract.service_type_code := r_repo_recs.service_type_code ;
394:
395: jai_cmn_debug_contexts_pkg.print
396: (ln_reg_id
397: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
398: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
399: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
400: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
401: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||

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

394:
395: jai_cmn_debug_contexts_pkg.print
396: (ln_reg_id
397: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
398: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
399: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
400: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
401: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
402: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||

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

395: jai_cmn_debug_contexts_pkg.print
396: (ln_reg_id
397: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
398: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
399: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
400: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
401: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
402: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
403: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||

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

396: (ln_reg_id
397: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
398: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
399: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
400: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
401: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
402: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
403: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
404: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||

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

397: , 'Before insert into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
398: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
399: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
400: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
401: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
402: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
403: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
404: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
405: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||

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

398: 'lr_trx_repo_extract.transaction_repository_id ='|| lr_trx_repo_extract.transaction_repository_id || fnd_global.local_chr(10) ||
399: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
400: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
401: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
402: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
403: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
404: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
405: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
406: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||

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

399: 'lr_trx_repo_extract.transaction_reference_id ='|| lr_trx_repo_extract.transaction_reference_id || fnd_global.local_chr(10) ||
400: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
401: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
402: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
403: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
404: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
405: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
406: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
407: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||

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

400: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
401: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
402: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
403: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
404: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
405: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
406: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
407: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
408: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc

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

401: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
402: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
403: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
404: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
405: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
406: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
407: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
408: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
409: );

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

402: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
403: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
404: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
405: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
406: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
407: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
408: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
409: );
410: jai_cmn_debug_contexts_pkg.print

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

403: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
404: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
405: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
406: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
407: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
408: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
409: );
410: jai_cmn_debug_contexts_pkg.print
411: ( ln_reg_id

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

408: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
409: );
410: jai_cmn_debug_contexts_pkg.print
411: ( ln_reg_id
412: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
413: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
414: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
415: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
416: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||

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

409: );
410: jai_cmn_debug_contexts_pkg.print
411: ( ln_reg_id
412: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
413: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
414: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
415: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
416: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
417: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||

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

410: jai_cmn_debug_contexts_pkg.print
411: ( ln_reg_id
412: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
413: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
414: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
415: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
416: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
417: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
418: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||

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

411: ( ln_reg_id
412: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
413: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
414: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
415: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
416: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
417: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
418: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
419: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||

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

412: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
413: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
414: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
415: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
416: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
417: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
418: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
419: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
420: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||

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

413: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
414: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
415: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
416: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
417: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
418: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
419: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
420: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
421: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||

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

414: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
415: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
416: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
417: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
418: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
419: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
420: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
421: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
422: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||

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

415: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
416: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
417: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
418: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
419: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
420: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
421: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
422: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
423: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code

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

416: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
417: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
418: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
419: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
420: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
421: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
422: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
423: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code
424: );

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

417: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
418: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
419: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
420: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
421: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
422: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
423: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code
424: );
425:

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

418: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
419: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
420: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
421: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
422: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
423: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code
424: );
425:
426: insert into jai_trx_repo_extract_gt

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

613:
614: lr_trx_repo_extract.document_line_id := lr_trx_repo_extract.document_line_num; --Added by Lion for bug#6911533
615: jai_cmn_debug_contexts_pkg.print
616: (ln_reg_id
617: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
618: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
619: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
620: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
621: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||

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

614: lr_trx_repo_extract.document_line_id := lr_trx_repo_extract.document_line_num; --Added by Lion for bug#6911533
615: jai_cmn_debug_contexts_pkg.print
616: (ln_reg_id
617: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
618: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
619: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
620: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
621: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
622: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||

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

615: jai_cmn_debug_contexts_pkg.print
616: (ln_reg_id
617: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
618: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
619: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
620: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
621: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
622: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
623: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||

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

616: (ln_reg_id
617: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
618: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
619: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
620: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
621: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
622: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
623: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
624: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||

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

617: , 'Before update into jai_trx_repo_extract_gt' || fnd_global.local_chr(10) ||
618: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
619: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
620: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
621: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
622: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
623: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
624: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
625: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||

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

618: 'lr_trx_repo_extract.transaction_source ='|| lr_trx_repo_extract.transaction_source || fnd_global.local_chr(10) ||
619: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
620: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
621: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
622: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
623: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
624: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
625: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
626: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc

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

619: 'lr_trx_repo_extract.party_name ='|| lr_trx_repo_extract.party_name || fnd_global.local_chr(10) ||
620: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
621: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
622: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
623: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
624: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
625: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
626: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
627: );

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

620: 'lr_trx_repo_extract.document_number ='|| lr_trx_repo_extract.document_number || fnd_global.local_chr(10) ||
621: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
622: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
623: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
624: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
625: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
626: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
627: );
628: jai_cmn_debug_contexts_pkg.print

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

621: 'lr_trx_repo_extract.document_date ='|| lr_trx_repo_extract.document_date || fnd_global.local_chr(10) ||
622: 'lr_trx_repo_extract.document_id ='|| lr_trx_repo_extract.document_id || fnd_global.local_chr(10) ||
623: 'lr_trx_repo_extract.document_line_id ='|| lr_trx_repo_extract.document_line_id || fnd_global.local_chr(10) ||
624: 'lr_trx_repo_extract.document_line_num ='|| lr_trx_repo_extract.document_line_num || fnd_global.local_chr(10) ||
625: 'lr_trx_repo_extract.document_line_item ='|| lr_trx_repo_extract.document_line_item || fnd_global.local_chr(10) ||
626: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
627: );
628: jai_cmn_debug_contexts_pkg.print
629: ( ln_reg_id

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

626: 'lr_trx_repo_extract.document_line_desc ='|| lr_trx_repo_extract.document_line_desc
627: );
628: jai_cmn_debug_contexts_pkg.print
629: ( ln_reg_id
630: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
631: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
632: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
633: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
634: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||

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

627: );
628: jai_cmn_debug_contexts_pkg.print
629: ( ln_reg_id
630: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
631: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
632: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
633: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
634: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
635: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||

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

628: jai_cmn_debug_contexts_pkg.print
629: ( ln_reg_id
630: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
631: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
632: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
633: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
634: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
635: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
636: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||

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

629: ( ln_reg_id
630: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
631: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
632: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
633: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
634: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
635: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
636: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
637: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||

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

630: ,'lr_trx_repo_extract.document_line_qty ='|| lr_trx_repo_extract.document_line_qty || fnd_global.local_chr(10) ||
631: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
632: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
633: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
634: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
635: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
636: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
637: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
638: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||

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

631: 'lr_trx_repo_extract.document_line_uom ='|| lr_trx_repo_extract.document_line_uom || fnd_global.local_chr(10) ||
632: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
633: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
634: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
635: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
636: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
637: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
638: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
639: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||

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

632: 'lr_trx_repo_extract.document_line_amt ='|| lr_trx_repo_extract.document_line_amt || fnd_global.local_chr(10) ||
633: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
634: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
635: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
636: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
637: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
638: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
639: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
640: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||

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

633: 'lr_trx_repo_extract.document_currency_code ='|| lr_trx_repo_extract.document_currency_code || fnd_global.local_chr(10) ||
634: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
635: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
636: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
637: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
638: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
639: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
640: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
641: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||

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

634: 'lr_trx_repo_extract.repository_tax_amt ='|| lr_trx_repo_extract.repository_tax_amt || fnd_global.local_chr(10) ||
635: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
636: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
637: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
638: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
639: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
640: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
641: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
642: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||

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

635: 'lr_trx_repo_extract.organization_name ='|| lr_trx_repo_extract.organization_name || fnd_global.local_chr(10) ||
636: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
637: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
638: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
639: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
640: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
641: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
642: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||
643: 'lr_trx_repo_extract.processed_flag ='|| lr_trx_repo_extract.processed_flag

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

636: 'lr_trx_repo_extract.location_name ='|| lr_trx_repo_extract.location_name || fnd_global.local_chr(10) ||
637: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
638: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
639: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
640: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
641: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
642: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||
643: 'lr_trx_repo_extract.processed_flag ='|| lr_trx_repo_extract.processed_flag
644: );

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

637: 'lr_trx_repo_extract.organization_id ='|| lr_trx_repo_extract.organization_id || fnd_global.local_chr(10) ||
638: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
639: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
640: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
641: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
642: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||
643: 'lr_trx_repo_extract.processed_flag ='|| lr_trx_repo_extract.processed_flag
644: );
645:

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

638: 'lr_trx_repo_extract.location_id ='|| lr_trx_repo_extract.location_id || fnd_global.local_chr(10) ||
639: 'lr_trx_repo_extract.inventory_item_id ='|| lr_trx_repo_extract.inventory_item_id || fnd_global.local_chr(10) ||
640: 'lr_trx_repo_extract.party_id ='|| lr_trx_repo_extract.party_id || fnd_global.local_chr(10) ||
641: 'lr_trx_repo_extract.service_type_code ='|| lr_trx_repo_extract.service_type_code || fnd_global.local_chr(10) ||
642: 'lr_trx_repo_extract.updatable_flag ='|| lr_trx_repo_extract.updatable_flag || fnd_global.local_chr(10) ||
643: 'lr_trx_repo_extract.processed_flag ='|| lr_trx_repo_extract.processed_flag
644: );
645:
646: update jai_trx_repo_extract_gt

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

1108: );
1109:
1110:
1111: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1112: ,'Call Parameters:' ||fnd_global.local_chr(10)
1113: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
1114: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
1115: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
1116: );

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

1109:
1110:
1111: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1112: ,'Call Parameters:' ||fnd_global.local_chr(10)
1113: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
1114: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
1115: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
1116: );
1117:

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

1110:
1111: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1112: ,'Call Parameters:' ||fnd_global.local_chr(10)
1113: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
1114: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
1115: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
1116: );
1117:
1118: if p_document_line_id is null or p_document_source is null then

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

1111: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1112: ,'Call Parameters:' ||fnd_global.local_chr(10)
1113: ||'p_document_id =' ||p_document_id ||fnd_global.local_chr(10)
1114: ||'p_document_line_id =' ||p_document_line_id ||fnd_global.local_chr(10)
1115: ||'p_document_source =' ||p_document_source ||fnd_global.local_chr(10)
1116: );
1117:
1118: if p_document_line_id is null or p_document_source is null then
1119: p_process_message := 'Document references cannot be null, cannot continue to derive the document details';

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

1743: for rec in c_get_recs_to_update
1744: loop
1745: -- For each record in temporary table which is not yet processed
1746: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1747: ,'rec.transaction_source='||rec.transaction_source || fnd_global.local_chr(10) ||
1748: 'rec.document_id='||rec.document_id || fnd_global.local_chr(10) ||
1749: 'rec.document_line_id='||rec.document_line_id || fnd_global.local_chr(10) ||
1750: 'rec.service_type_code='||rec.service_type_code
1751: );

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

1744: loop
1745: -- For each record in temporary table which is not yet processed
1746: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1747: ,'rec.transaction_source='||rec.transaction_source || fnd_global.local_chr(10) ||
1748: 'rec.document_id='||rec.document_id || fnd_global.local_chr(10) ||
1749: 'rec.document_line_id='||rec.document_line_id || fnd_global.local_chr(10) ||
1750: 'rec.service_type_code='||rec.service_type_code
1751: );
1752: --

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

1745: -- For each record in temporary table which is not yet processed
1746: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1747: ,'rec.transaction_source='||rec.transaction_source || fnd_global.local_chr(10) ||
1748: 'rec.document_id='||rec.document_id || fnd_global.local_chr(10) ||
1749: 'rec.document_line_id='||rec.document_line_id || fnd_global.local_chr(10) ||
1750: 'rec.service_type_code='||rec.service_type_code
1751: );
1752: --
1753: -- Update the transaction tables with the service type code based on source value

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

2054:
2055: -- Begin 5876390, 6012570
2056: elsif JAI_AR_RCTLA_TRIGGER_PKG.is_this_projects_context (lr_inv_attr.interface_header_context) then -- Invoice imported from Projects
2057:
2058: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_get_jai_pa_details ' ||fnd_global.local_chr(10)
2059: ||'cp_project_number='||lr_inv_attr.interface_line_attribute1 ||fnd_global.local_chr(10)
2060: ||'cp_draft_inv_num='||lr_inv_attr.interface_line_attribute2 ||fnd_global.local_chr(10)
2061: ||'cp_line_num='||lr_inv_attr.interface_line_attribute6 ||fnd_global.local_chr (10)
2062: );

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

2055: -- Begin 5876390, 6012570
2056: elsif JAI_AR_RCTLA_TRIGGER_PKG.is_this_projects_context (lr_inv_attr.interface_header_context) then -- Invoice imported from Projects
2057:
2058: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_get_jai_pa_details ' ||fnd_global.local_chr(10)
2059: ||'cp_project_number='||lr_inv_attr.interface_line_attribute1 ||fnd_global.local_chr(10)
2060: ||'cp_draft_inv_num='||lr_inv_attr.interface_line_attribute2 ||fnd_global.local_chr(10)
2061: ||'cp_line_num='||lr_inv_attr.interface_line_attribute6 ||fnd_global.local_chr (10)
2062: );
2063: open c_get_jai_pa_details ( cp_project_number => lr_inv_attr.interface_line_attribute1

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

2056: elsif JAI_AR_RCTLA_TRIGGER_PKG.is_this_projects_context (lr_inv_attr.interface_header_context) then -- Invoice imported from Projects
2057:
2058: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_get_jai_pa_details ' ||fnd_global.local_chr(10)
2059: ||'cp_project_number='||lr_inv_attr.interface_line_attribute1 ||fnd_global.local_chr(10)
2060: ||'cp_draft_inv_num='||lr_inv_attr.interface_line_attribute2 ||fnd_global.local_chr(10)
2061: ||'cp_line_num='||lr_inv_attr.interface_line_attribute6 ||fnd_global.local_chr (10)
2062: );
2063: open c_get_jai_pa_details ( cp_project_number => lr_inv_attr.interface_line_attribute1
2064: , cp_draft_inv_num => lr_inv_attr.interface_line_attribute2

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

2057:
2058: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_get_jai_pa_details ' ||fnd_global.local_chr(10)
2059: ||'cp_project_number='||lr_inv_attr.interface_line_attribute1 ||fnd_global.local_chr(10)
2060: ||'cp_draft_inv_num='||lr_inv_attr.interface_line_attribute2 ||fnd_global.local_chr(10)
2061: ||'cp_line_num='||lr_inv_attr.interface_line_attribute6 ||fnd_global.local_chr (10)
2062: );
2063: open c_get_jai_pa_details ( cp_project_number => lr_inv_attr.interface_line_attribute1
2064: , cp_draft_inv_num => lr_inv_attr.interface_line_attribute2
2065: , cp_line_num => lr_inv_attr.interface_line_attribute6

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

2088:
2089: elsif p_reference_source = 'AP' then
2090:
2091: jai_cmn_debug_contexts_pkg.print (ln_reg_id
2092: , 'OPEN/FETCH/CLOSE c_get_po_reference'||fnd_global.local_chr(10)
2093: ||'p_reference_invoice_id ='||p_reference_invoice_id
2094: ||'p_reference_item_line_id ='||p_reference_item_line_id
2095: );
2096:

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

2105: THEN
2106: ------------------------------------------------------------------------
2107:
2108: jai_cmn_debug_contexts_pkg.print(ln_reg_id
2109: ,'lr_po_reference.po_header_id =' ||lr_po_reference.po_header_id || fnd_global.local_chr(10) ||
2110: 'lr_po_reference.po_line_id =' ||lr_po_reference.po_line_id
2111: );
2112:
2113: IF lr_po_reference.rcv_transaction_id is NULL THEN /*If Condition added by vkantamn for Bug#6083978 */