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 JAI_CMN_DEBUG_CONTEXTS_PKG

Line 706: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

702:
703: lv_member_name := 'EXTRACT_RGM_TRXS';
704: set_debug_context;
705: p_process_flag := jai_constants.SUCCESSFUL;
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) ||

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 722: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Begin for r_repo_recs in c_get_repo_recs loop');

718:
719: for r_repo_recs in c_get_repo_recs
720: loop
721:
722: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Begin for r_repo_recs in c_get_repo_recs loop');
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:

Line 725: jai_cmn_debug_contexts_pkg.print (ln_reg_id, '1. r_repo_recs.service_type_code ='||r_repo_recs.service_type_code );

721:
722: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Begin for r_repo_recs in c_get_repo_recs loop');
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

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 944: jai_cmn_debug_contexts_pkg.print

940:
941: end if;
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) ||

Line 959: jai_cmn_debug_contexts_pkg.print

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

Line 1040: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After insert into jai_trx_repo_extract_gt');

1036: ,lr_trx_repo_extract.gl_date --Add by Xiao for POT Phase III, reg bug#12895841. --Added by Chong.Lei for POT code port
1037: ,lr_trx_repo_extract.st_inv_number --Add by Qiong for Advanced Receipts
1038: ,lr_trx_repo_extract.source_trx_type --Add by Qiong for Advanced Receipts
1039: );
1040: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After insert into jai_trx_repo_extract_gt');
1041: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'End of Loop -> for r_repo_recs in c_get_repo_recs');
1042:
1043: end loop; --> r_repo_recs in c_get_repo_recs
1044:

Line 1041: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'End of Loop -> for r_repo_recs in c_get_repo_recs');

1037: ,lr_trx_repo_extract.st_inv_number --Add by Qiong for Advanced Receipts
1038: ,lr_trx_repo_extract.source_trx_type --Add by Qiong for Advanced Receipts
1039: );
1040: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After insert into jai_trx_repo_extract_gt');
1041: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'End of Loop -> for r_repo_recs in c_get_repo_recs');
1042:
1043: end loop; --> r_repo_recs in c_get_repo_recs
1044:
1045:

Line 1264: jai_cmn_debug_contexts_pkg.print

1260:
1261: end if;
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) ||

Line 1277: jai_cmn_debug_contexts_pkg.print

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

Line 1325: jai_cmn_debug_contexts_pkg.print

1321: and source_trx_type = NVL( r_docs.source_trx_type, source_trx_type) --Add by Qiong for advanced receipts bug13361952
1322: and repository_line_id = NVL( r_docs.repository_line_id,repository_line_id) --Add by Qiong for bug#13405553
1323: and document_line_id = r_docs.document_line_id;
1324:
1325: jai_cmn_debug_contexts_pkg.print
1326: ( ln_reg_id
1327: , 'Number of rows updated ='||sql%rowcount
1328: );
1329: end loop;

Line 1338: jai_cmn_debug_contexts_pkg.print

1334:
1335: for r_org in (select distinct organization_id from jai_trx_repo_extract_gt where organization_id is not null)
1336: loop
1337:
1338: jai_cmn_debug_contexts_pkg.print
1339: (ln_reg_id
1340: , 'OPEN/FETCH/CLOSE c_get_organization_name, r_org.organization_id='||r_org.organization_id
1341: );
1342:

Line 1347: jai_cmn_debug_contexts_pkg.print

1343: open c_get_organization_name (cp_organization_id => r_org.organization_id);
1344: fetch c_get_organization_name into lv_organization_name;
1345: close c_get_organization_name ;
1346:
1347: jai_cmn_debug_contexts_pkg.print
1348: (ln_reg_id
1349: ,'lv_organization_name='||lv_organization_name
1350: );
1351:

Line 1365: jai_cmn_debug_contexts_pkg.print

1361: --
1362:
1363: for r_loc in (select distinct location_id from jai_trx_repo_extract_gt where location_id is not null )
1364: loop
1365: jai_cmn_debug_contexts_pkg.print
1366: (ln_reg_id
1367: ,'OPEN/FETCH/CLOSE c_get_location_name, r_loc.location_id='||r_loc.location_id
1368: );
1369:

Line 1374: jai_cmn_debug_contexts_pkg.print

1370: open c_get_location_name (cp_location_id => r_loc.location_id);
1371: fetch c_get_location_name into lv_location_name;
1372: close c_get_location_name ;
1373:
1374: jai_cmn_debug_contexts_pkg.print
1375: (ln_reg_id
1376: ,'lv_location_name='||lv_location_name
1377: );
1378:

Line 1387: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);

1383: end loop;
1384:
1385: /** Deregister procedure and return*/
1386: <>
1387: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
1388:
1389: exception
1390: when others then
1391: p_process_flag := jai_constants.unexpected_error;

Line 1393: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

1389: exception
1390: when others then
1391: p_process_flag := jai_constants.unexpected_error;
1392: p_process_message := lv_context||'->'||sqlerrm;
1393: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1394: jai_cmn_debug_contexts_pkg.print_stack;
1395: end extract_rgm_trxs;
1396:
1397: /*------------------------------------------------------------------------------------------------------------*/

Line 1394: jai_cmn_debug_contexts_pkg.print_stack;

1390: when others then
1391: p_process_flag := jai_constants.unexpected_error;
1392: p_process_message := lv_context||'->'||sqlerrm;
1393: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1394: jai_cmn_debug_contexts_pkg.print_stack;
1395: end extract_rgm_trxs;
1396:
1397: /*------------------------------------------------------------------------------------------------------------*/
1398:

Line 2220: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

2216:
2217: lv_member_name := 'GET_DOCUMENT_DETAILS';
2218: set_debug_context;
2219: p_process_flag := jai_constants.SUCCESSFUL;
2220: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2221: , pn_reg_id => ln_reg_id
2222: );
2223:
2224: jai_cmn_debug_contexts_pkg.print ( ln_reg_id

Line 2224: jai_cmn_debug_contexts_pkg.print ( ln_reg_id

2220: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
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)

Line 2256: jai_cmn_debug_contexts_pkg.print (ln_reg_id

2252: close c_get_po_details;
2253:
2254: if r_po_details.document_id is null then
2255: fnd_file.put_line(fnd_file.log,'Purchase Order does not exists for po_header_id ='||p_document_id ||' and po_line_id='|| p_document_line_id); --12560704
2256: jai_cmn_debug_contexts_pkg.print (ln_reg_id
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:

Line 2315: jai_cmn_debug_contexts_pkg.print (ln_reg_id

2311: fetch c_get_receipt_details into r_rcv_details;
2312: close c_get_receipt_details;
2313:
2314: if r_rcv_details.document_id is null then
2315: jai_cmn_debug_contexts_pkg.print (ln_reg_id
2316: ,'Receipt does not exists for transaction_id ='||v_transaction_id
2317: );
2318: end if;
2319:

Line 2368: jai_cmn_debug_contexts_pkg.print (ln_reg_id

2364: fetch c_get_so_details into r_so_details;
2365: close c_get_so_details;
2366:
2367: if r_so_details.document_id is null then
2368: jai_cmn_debug_contexts_pkg.print (ln_reg_id
2369: ,'Sales Order does not exists for header_id='||p_document_id ||' and line_id ='||p_document_line_id
2370: );
2371: end if;
2372:

Line 2427: jai_cmn_debug_contexts_pkg.print (ln_reg_id

2423: fetch c_get_pa_details into r_pa_details;
2424: close c_get_pa_details;
2425:
2426: if r_pa_details.document_id is null then
2427: jai_cmn_debug_contexts_pkg.print (ln_reg_id
2428: ,'Project Draft Invoice does not exists for p_document_id ='||p_document_id ||' and p_document_line_id='||p_document_line_id
2429: );
2430: end if;
2431: --Added by Qiong for bug13597785 begin

Line 2564: jai_cmn_debug_contexts_pkg.print (ln_reg_id

2560: fetch c_get_ra_trx_details into r_ra_trx_details;
2561: close c_get_ra_trx_details;
2562:
2563: if r_ra_trx_details.document_id is null then
2564: jai_cmn_debug_contexts_pkg.print (ln_reg_id
2565: ,'AR Transaction does not exists for ra_customer_trx_id='||p_document_id ||' and customer_trx_line_id='||p_document_line_id
2566: );
2567: end if;
2568: -- p_trx_repo_extract.transaction_source := 'RECEIVABLES' ; --Comment by Chong.Lei for POT code port

Line 2840: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);

2836: END IF;
2837: --End of bug#8943349
2838: /** Deregister procedure and return*/
2839: <>
2840: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
2841:
2842: exception
2843: when others then
2844: p_process_flag := jai_constants.unexpected_error;

Line 2846: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

2842: exception
2843: when others then
2844: p_process_flag := jai_constants.unexpected_error;
2845: p_process_message := lv_context||'->'||sqlerrm;
2846: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2847: jai_cmn_debug_contexts_pkg.print_stack;
2848: end get_document_details ;
2849:
2850: /*------------------------------------------------------------------------------------------------------------*/

Line 2847: jai_cmn_debug_contexts_pkg.print_stack;

2843: when others then
2844: p_process_flag := jai_constants.unexpected_error;
2845: p_process_message := lv_context||'->'||sqlerrm;
2846: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2847: jai_cmn_debug_contexts_pkg.print_stack;
2848: end get_document_details ;
2849:
2850: /*------------------------------------------------------------------------------------------------------------*/
2851: -- Overloading the GET_DOC_FROM_REFERENCE to return only organization_id, location_id and service_type_code for a given document reference

Line 3165: jai_cmn_debug_contexts_pkg.register (lv_context, ln_reg_id);

3161:
3162: /* Initialize the process variables */
3163: p_process_flag := jai_constants.SUCCESSFUL;
3164:
3165: jai_cmn_debug_contexts_pkg.register (lv_context, ln_reg_id);
3166: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Begin loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);
3167: for rec in c_get_recs_to_update
3168: loop
3169: -- For each record in temporary table which is not yet processed

Line 3166: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Begin loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);

3162: /* Initialize the process variables */
3163: p_process_flag := jai_constants.SUCCESSFUL;
3164:
3165: jai_cmn_debug_contexts_pkg.register (lv_context, ln_reg_id);
3166: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Begin loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);
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

Line 3170: jai_cmn_debug_contexts_pkg.print (ln_reg_id

3166: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Begin loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);
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

Line 3225: jai_cmn_debug_contexts_pkg.print (ln_reg_id

3221: , last_updated_by = lv_user_id
3222: , last_update_login = lv_login_id
3223: where transfer_id = rec.document_id;
3224:
3225: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3226: ,'No of rows updated in trx table='||sql%rowcount
3227: );
3228:
3229: --

Line 3241: jai_cmn_debug_contexts_pkg.print (ln_reg_id

3237: , last_update_login = lv_login_id
3238: where source_document_id = rec.document_id
3239: and source = 'SERVICE_DISTRIBUTE_IN';
3240:
3241: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3242: ,'No of rows updated in repository table for source SERVICE_DISTRIBUTE_IN='||sql%rowcount
3243: );
3244:
3245: -- Begin 5876390, 6012570

Line 3272: jai_cmn_debug_contexts_pkg.print (ln_reg_id

3268: , last_update_login = lv_login_id
3269: where customer_trx_id = rec.repository_invoice_id
3270: and customer_trx_line_id = rec.repository_line_id;
3271:
3272: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3273: ,'Rows updated in ja_in_ra_customer_trx_lines='||sql%rowcount
3274: );
3275: end if;
3276:

Line 3280: jai_cmn_debug_contexts_pkg.print (ln_reg_id

3276:
3277: -- End Bug 5876390, 6012570
3278:
3279: if rec.transaction_source not in ('SERVICE_DISTRIBUTE_OUT') then
3280: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3281: ,'No of rows updated in trx table='||sql%rowcount
3282: );
3283: end if;
3284:

Line 3295: jai_cmn_debug_contexts_pkg.print (ln_reg_id

3291: , last_update_date = sysdate
3292: , last_updated_by = lv_user_id
3293: where repository_id = rec.transaction_repository_id;
3294:
3295: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3296: ,'No of rows updated in jai_rgm_trx_records table='||sql%rowcount
3297: );
3298: --
3299: -- Mark record in global temp table as PROCESSED

Line 3305: jai_cmn_debug_contexts_pkg.print (ln_reg_id

3301: update jai_trx_repo_extract_gt
3302: set processed_flag = 'Y'
3303: where transaction_repository_id = rec.transaction_repository_id;
3304:
3305: jai_cmn_debug_contexts_pkg.print (ln_reg_id
3306: ,'No of rows updated in jai_trx_repo_extract_gt table='||sql%rowcount
3307: );
3308:
3309: end loop;

Line 3310: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'End loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);

3306: ,'No of rows updated in jai_trx_repo_extract_gt table='||sql%rowcount
3307: );
3308:
3309: end loop;
3310: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'End loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);
3311:
3312: /** Deregister procedure and return*/
3313: <>
3314: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);

Line 3314: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);

3310: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'End loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);
3311:
3312: /** Deregister procedure and return*/
3313: <>
3314: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
3315:
3316: exception
3317: when others then
3318: p_process_flag := jai_constants.unexpected_error;

Line 3320: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

3316: exception
3317: when others then
3318: p_process_flag := jai_constants.unexpected_error;
3319: p_process_message := lv_context||'->'||sqlerrm;
3320: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
3321: jai_cmn_debug_contexts_pkg.print_stack;
3322:
3323: end update_service_type;
3324:

Line 3321: jai_cmn_debug_contexts_pkg.print_stack;

3317: when others then
3318: p_process_flag := jai_constants.unexpected_error;
3319: p_process_message := lv_context||'->'||sqlerrm;
3320: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
3321: jai_cmn_debug_contexts_pkg.print_stack;
3322:
3323: end update_service_type;
3324:
3325: /*------------------------------------------------------------------------------------------------------------*/

Line 3413: jai_cmn_debug_contexts_pkg.register ( lv_context, ln_reg_id );

3409:
3410: lv_member_name := 'DERRIVE_DOC_FROM_REF';
3411: set_debug_context;
3412:
3413: jai_cmn_debug_contexts_pkg.register ( lv_context, ln_reg_id );
3414:
3415: if p_reference_source = 'AR' then
3416: /*Add by Wenqiong for Advanced Receipts Begin*/
3417: -----------------------------------------------

Line 3428: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_chk_ar_inv_attr, p_reference_invoice_id='||p_reference_invoice_id);

3424: -----------------------------------------------
3425: /*Add by Wenqiong for Advanced Receipts End*/
3426:
3427: lv_created_from := null;
3428: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'OPEN/FETCH/CLOSE c_chk_ar_inv_attr, p_reference_invoice_id='||p_reference_invoice_id);
3429:
3430: --
3431: -- Get the invoice attributes to make a decision regarding from where to fetch document details.
3432: -- If the invoice is an imported one then document is Sales Order other wise AR Invoice details will be fetched

Line 3440: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lr_inv_attr.created_from='||lr_inv_attr.created_from

3436: );
3437: fetch c_chk_ar_inv_attr into lr_inv_attr;
3438: close c_chk_ar_inv_attr;
3439:
3440: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lr_inv_attr.created_from='||lr_inv_attr.created_from
3441: ||',lr_inv_attr.interface_header_context='||lr_inv_attr.interface_header_context
3442: ||',lr_inv_attr.interface_header_attribute1(order number)='||lr_inv_attr.interface_header_attribute1
3443: ||',lr_inv_attr.interface_line_attribute6(oe_line_id)='||lr_inv_attr.interface_line_attribute6
3444: ) ;

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 3478: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_draft_invoice_id='||ln_draft_invoice_id

3474: ,ln_draft_invoice_line_id;
3475: close c_get_jai_pa_details;
3476:
3477:
3478: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_draft_invoice_id='||ln_draft_invoice_id
3479: ||'ln_draft_invoice_line_id='||ln_draft_invoice_line_id
3480: );
3481: p_trx_repo_extract_rec.transaction_source := 'PROJECTS';
3482: p_trx_repo_extract_rec.document_id := ln_draft_invoice_id;

Line 3499: jai_cmn_debug_contexts_pkg.print (ln_reg_id

3495:
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: );

Line 3510: jai_cmn_debug_contexts_pkg.print(ln_reg_id

3506: ,cp_distribution_id => p_reference_item_line_id
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

Line 3553: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);

3549: end if; -- End if of bug#8943349
3550:
3551: /** Deregister procedure and return*/
3552: <>
3553: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
3554:
3555: exception
3556: when others then
3557: p_process_flag := jai_constants.unexpected_error;

Line 3559: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

3555: exception
3556: when others then
3557: p_process_flag := jai_constants.unexpected_error;
3558: p_process_message := lv_context||'->'||sqlerrm;
3559: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
3560: jai_cmn_debug_contexts_pkg.print_stack;
3561:
3562: end derrive_doc_from_ref;
3563:

Line 3560: jai_cmn_debug_contexts_pkg.print_stack;

3556: when others then
3557: p_process_flag := jai_constants.unexpected_error;
3558: p_process_message := lv_context||'->'||sqlerrm;
3559: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
3560: jai_cmn_debug_contexts_pkg.print_stack;
3561:
3562: end derrive_doc_from_ref;
3563:
3564: /*------------------------------------------------------------------------------------------------------------*/