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

268:
269: lv_member_name := 'EXTRACT_RGM_TRXS';
270: set_debug_context;
271: p_process_flag := jai_constants.SUCCESSFUL;
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) ||

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

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

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

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

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

391: lr_trx_repo_extract.repository_invoice_id := r_repo_recs.invoice_id ;
392: lr_trx_repo_extract.repository_line_id := r_repo_recs.item_line_id ;
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) ||

Line 410: jai_cmn_debug_contexts_pkg.print

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

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

482: ,lr_trx_repo_extract.repository_line_id
483: ,lr_trx_repo_extract.repository_source
484: ,null
485: );
486: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After insert into jai_trx_repo_extract_gt');
487: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'End of Loop -> for r_repo_recs in c_get_repo_recs');
488:
489: end loop; --> r_repo_recs in c_get_repo_recs
490:

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

483: ,lr_trx_repo_extract.repository_source
484: ,null
485: );
486: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After insert into jai_trx_repo_extract_gt');
487: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'End of Loop -> for r_repo_recs in c_get_repo_recs');
488:
489: end loop; --> r_repo_recs in c_get_repo_recs
490:
491:

Line 615: jai_cmn_debug_contexts_pkg.print

611:
612: end if;
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) ||

Line 628: jai_cmn_debug_contexts_pkg.print

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

Line 674: jai_cmn_debug_contexts_pkg.print

670: or r_docs.document_id is null -- incase of order management it will be null
671: )
672: and document_line_id = r_docs.document_line_id;
673:
674: jai_cmn_debug_contexts_pkg.print
675: ( ln_reg_id
676: , 'Number of rows updated ='||sql%rowcount
677: );
678: end loop;

Line 687: jai_cmn_debug_contexts_pkg.print

683:
684: for r_org in (select distinct organization_id from jai_trx_repo_extract_gt where organization_id is not null)
685: loop
686:
687: jai_cmn_debug_contexts_pkg.print
688: (ln_reg_id
689: , 'OPEN/FETCH/CLOSE c_get_organization_name, r_org.organization_id='||r_org.organization_id
690: );
691:

Line 696: jai_cmn_debug_contexts_pkg.print

692: open c_get_organization_name (cp_organization_id => r_org.organization_id);
693: fetch c_get_organization_name into lv_organization_name;
694: close c_get_organization_name ;
695:
696: jai_cmn_debug_contexts_pkg.print
697: (ln_reg_id
698: ,'lv_organization_name='||lv_organization_name
699: );
700:

Line 714: jai_cmn_debug_contexts_pkg.print

710: --
711:
712: for r_loc in (select distinct location_id from jai_trx_repo_extract_gt where location_id is not null )
713: loop
714: jai_cmn_debug_contexts_pkg.print
715: (ln_reg_id
716: ,'OPEN/FETCH/CLOSE c_get_location_name, r_loc.location_id='||r_loc.location_id
717: );
718:

Line 723: jai_cmn_debug_contexts_pkg.print

719: open c_get_location_name (cp_location_id => r_loc.location_id);
720: fetch c_get_location_name into lv_location_name;
721: close c_get_location_name ;
722:
723: jai_cmn_debug_contexts_pkg.print
724: (ln_reg_id
725: ,'lv_location_name='||lv_location_name
726: );
727:

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

732: end loop;
733:
734: /** Deregister procedure and return*/
735: <>
736: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
737:
738: exception
739: when others then
740: p_process_flag := jai_constants.unexpected_error;

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

738: exception
739: when others then
740: p_process_flag := jai_constants.unexpected_error;
741: p_process_message := lv_context||'->'||sqlerrm;
742: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
743: jai_cmn_debug_contexts_pkg.print_stack;
744: end extract_rgm_trxs;
745:
746: /*------------------------------------------------------------------------------------------------------------*/

Line 743: jai_cmn_debug_contexts_pkg.print_stack;

739: when others then
740: p_process_flag := jai_constants.unexpected_error;
741: p_process_message := lv_context||'->'||sqlerrm;
742: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
743: jai_cmn_debug_contexts_pkg.print_stack;
744: end extract_rgm_trxs;
745:
746: /*------------------------------------------------------------------------------------------------------------*/
747:

Line 1106: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

1102:
1103: lv_member_name := 'GET_DOCUMENT_DETAILS';
1104: set_debug_context;
1105: p_process_flag := jai_constants.SUCCESSFUL;
1106: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1107: , pn_reg_id => ln_reg_id
1108: );
1109:
1110:

Line 1111: jai_cmn_debug_contexts_pkg.print ( ln_reg_id

1107: , pn_reg_id => ln_reg_id
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)

Line 1135: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1131: fetch c_get_po_details into r_po_details;
1132: close c_get_po_details;
1133:
1134: if r_po_details.document_id is null then
1135: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1136: ,'Purchase Order does not exists for po_header_id ='||p_document_id ||' and po_line_id='|| p_document_line_id
1137: );
1138: end if;
1139:

Line 1184: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1180: fetch c_get_po_details into r_po_details;
1181: close c_get_po_details;
1182:
1183: if r_po_details.document_id is null then
1184: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1185: ,'Purchase Order does not exists for po_header_id ='||p_document_id ||' and po_line_id='|| p_document_line_id
1186: );
1187: end if;
1188:

Line 1232: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1228: fetch c_get_so_details into r_so_details;
1229: close c_get_so_details;
1230:
1231: if r_so_details.document_id is null then
1232: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1233: ,'Sales Order does not exists for header_id='||p_document_id ||' and line_id ='||p_document_line_id
1234: );
1235: end if;
1236:

Line 1291: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1287: fetch c_get_pa_details into r_pa_details;
1288: close c_get_pa_details;
1289:
1290: if r_pa_details.document_id is null then
1291: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1292: ,'Project Draft Invoice does not exists for p_document_id ='||p_document_id ||' and p_document_line_id='||p_document_line_id
1293: );
1294: end if;
1295:

Line 1335: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1331: fetch c_get_ra_trx_details into r_ra_trx_details;
1332: close c_get_ra_trx_details;
1333:
1334: if r_ra_trx_details.document_id is null then
1335: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1336: ,'AR Transaction does not exists for ra_customer_trx_id='||p_document_id ||' and customer_trx_line_id='||p_document_line_id
1337: );
1338: end if;
1339: p_trx_repo_extract.transaction_source := 'RECEIVABLES' ;

Line 1379: jai_cmn_debug_contexts_pkg.print

1375: CLOSE l_get_si_details_csr;
1376:
1377: IF r_ra_trx_details.document_id IS NULL
1378: THEN
1379: jai_cmn_debug_contexts_pkg.print
1380: ( ln_reg_id,'AP Transaction does not exists for invoice_id='||
1381: p_document_id ||' and line_number='||p_document_line_id
1382: );
1383: END IF;

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

1450: END IF; -- (p_document_source = jai_constants.AP_STANDALONE_INVOICE)
1451: --------------------------------------------------------------------------
1452: /** Deregister procedure and return*/
1453: <>
1454: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
1455:
1456: exception
1457: when others then
1458: p_process_flag := jai_constants.unexpected_error;

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

1456: exception
1457: when others then
1458: p_process_flag := jai_constants.unexpected_error;
1459: p_process_message := lv_context||'->'||sqlerrm;
1460: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1461: jai_cmn_debug_contexts_pkg.print_stack;
1462: end get_document_details ;
1463:
1464: /*------------------------------------------------------------------------------------------------------------*/

Line 1461: jai_cmn_debug_contexts_pkg.print_stack;

1457: when others then
1458: p_process_flag := jai_constants.unexpected_error;
1459: p_process_message := lv_context||'->'||sqlerrm;
1460: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1461: jai_cmn_debug_contexts_pkg.print_stack;
1462: end get_document_details ;
1463:
1464: /*------------------------------------------------------------------------------------------------------------*/
1465: -- Overloading the GET_DOC_FROM_REFERENCE to return only organization_id, location_id and service_type_code for a given document reference

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

1737:
1738: /* Initialize the process variables */
1739: p_process_flag := jai_constants.SUCCESSFUL;
1740:
1741: jai_cmn_debug_contexts_pkg.register (lv_context, ln_reg_id);
1742: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Begin loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);
1743: for rec in c_get_recs_to_update
1744: loop
1745: -- For each record in temporary table which is not yet processed

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

1738: /* Initialize the process variables */
1739: p_process_flag := jai_constants.SUCCESSFUL;
1740:
1741: jai_cmn_debug_contexts_pkg.register (lv_context, ln_reg_id);
1742: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Begin loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);
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

Line 1746: jai_cmn_debug_contexts_pkg.print (ln_reg_id

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

Line 1800: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1796: , last_updated_by = lv_user_id
1797: , last_update_login = lv_login_id
1798: where transfer_id = rec.document_id;
1799:
1800: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1801: ,'No of rows updated in trx table='||sql%rowcount
1802: );
1803: --Added by Lion for bug#6911533 on 2008/04/22
1804: -------------------------------------------------------------------------

Line 1826: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1822: , last_update_login = lv_login_id
1823: where source_document_id = rec.document_id
1824: and source = 'SERVICE_DISTRIBUTE_IN';
1825:
1826: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1827: ,'No of rows updated in repository table for source SERVICE_DISTRIBUTE_IN='||sql%rowcount
1828: );
1829:
1830: -- Begin 5876390, 6012570

Line 1857: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1853: , last_update_login = lv_login_id
1854: where customer_trx_id = rec.repository_invoice_id
1855: and customer_trx_line_id = rec.repository_line_id;
1856:
1857: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1858: ,'Rows updated in ja_in_ra_customer_trx_lines='||sql%rowcount
1859: );
1860: end if;
1861:

Line 1865: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1861:
1862: -- End Bug 5876390, 6012570
1863:
1864: if rec.transaction_source not in ('SERVICE_DISTRIBUTE_OUT') then
1865: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1866: ,'No of rows updated in trx table='||sql%rowcount
1867: );
1868: end if;
1869:

Line 1880: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1876: , last_update_date = sysdate
1877: , last_updated_by = lv_user_id
1878: where repository_id = rec.transaction_repository_id;
1879:
1880: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1881: ,'No of rows updated in jai_rgm_trx_records table='||sql%rowcount
1882: );
1883: --
1884: -- Mark record in global temp table as PROCESSED

Line 1890: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1886: update jai_trx_repo_extract_gt
1887: set processed_flag = 'Y'
1888: where transaction_repository_id = rec.transaction_repository_id;
1889:
1890: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1891: ,'No of rows updated in jai_trx_repo_extract_gt table='||sql%rowcount
1892: );
1893:
1894: end loop;

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

1891: ,'No of rows updated in jai_trx_repo_extract_gt table='||sql%rowcount
1892: );
1893:
1894: end loop;
1895: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'End loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);
1896:
1897: /** Deregister procedure and return*/
1898: <>
1899: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);

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

1895: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'End loop for C_GET_RECS_TO_UPDATE', jai_cmn_debug_contexts_pkg.summary);
1896:
1897: /** Deregister procedure and return*/
1898: <>
1899: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
1900:
1901: exception
1902: when others then
1903: p_process_flag := jai_constants.unexpected_error;

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

1901: exception
1902: when others then
1903: p_process_flag := jai_constants.unexpected_error;
1904: p_process_message := lv_context||'->'||sqlerrm;
1905: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1906: jai_cmn_debug_contexts_pkg.print_stack;
1907:
1908: end update_service_type;
1909:

Line 1906: jai_cmn_debug_contexts_pkg.print_stack;

1902: when others then
1903: p_process_flag := jai_constants.unexpected_error;
1904: p_process_message := lv_context||'->'||sqlerrm;
1905: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1906: jai_cmn_debug_contexts_pkg.print_stack;
1907:
1908: end update_service_type;
1909:
1910: /*------------------------------------------------------------------------------------------------------------*/

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

2013:
2014: lv_member_name := 'DERRIVE_DOC_FROM_REF';
2015: set_debug_context;
2016:
2017: jai_cmn_debug_contexts_pkg.register ( lv_context, ln_reg_id );
2018:
2019: if p_reference_source = 'AR' then
2020:
2021: lv_created_from := null;

Line 2022: 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);

2018:
2019: if p_reference_source = 'AR' then
2020:
2021: lv_created_from := null;
2022: 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);
2023:
2024: --
2025: -- Get the invoice attributes to make a decision regarding from where to fetch document details.
2026: -- If the invoice is an imported one then document is Sales Order other wise AR Invoice details will be fetched

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

2030: );
2031: fetch c_chk_ar_inv_attr into lr_inv_attr;
2032: close c_chk_ar_inv_attr;
2033:
2034: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lr_inv_attr.created_from='||lr_inv_attr.created_from
2035: ||',lr_inv_attr.interface_header_context='||lr_inv_attr.interface_header_context
2036: ||',lr_inv_attr.interface_header_attribute1(order number)='||lr_inv_attr.interface_header_attribute1
2037: ||',lr_inv_attr.interface_line_attribute6(oe_line_id)='||lr_inv_attr.interface_line_attribute6
2038: ) ;

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

2068: ,ln_draft_invoice_line_id;
2069: close c_get_jai_pa_details;
2070:
2071:
2072: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_draft_invoice_id='||ln_draft_invoice_id
2073: ||'ln_draft_invoice_line_id='||ln_draft_invoice_line_id
2074: );
2075: p_trx_repo_extract_rec.transaction_source := 'PROJECTS';
2076: p_trx_repo_extract_rec.document_id := ln_draft_invoice_id;

Line 2091: jai_cmn_debug_contexts_pkg.print (ln_reg_id

2087: end if; --> lr_inv_attr.created
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: );

Line 2108: jai_cmn_debug_contexts_pkg.print(ln_reg_id

2104: IF (c_get_po_reference%FOUND)
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:

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

2143: end if;
2144:
2145: /** Deregister procedure and return*/
2146: <>
2147: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);
2148:
2149: exception
2150: when others then
2151: p_process_flag := jai_constants.unexpected_error;

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

2149: exception
2150: when others then
2151: p_process_flag := jai_constants.unexpected_error;
2152: p_process_message := lv_context||'->'||sqlerrm;
2153: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2154: jai_cmn_debug_contexts_pkg.print_stack;
2155:
2156: end derrive_doc_from_ref;
2157:

Line 2154: jai_cmn_debug_contexts_pkg.print_stack;

2150: when others then
2151: p_process_flag := jai_constants.unexpected_error;
2152: p_process_message := lv_context||'->'||sqlerrm;
2153: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2154: jai_cmn_debug_contexts_pkg.print_stack;
2155:
2156: end derrive_doc_from_ref;
2157:
2158: /*------------------------------------------------------------------------------------------------------------*/