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.ARP_XLA_EXTRACT_MAIN_PKG dependencies on ARP_XLA_EXTRACT_MAIN_PKG

Line 1: PACKAGE BODY arp_xla_extract_main_pkg AS

1: PACKAGE BODY arp_xla_extract_main_pkg AS
2: /* $Header: ARPXLEXB.pls 120.189.12020000.7 2012/11/01 02:04:48 samara ship $ */
3:
4: TYPE t_lock IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
5: l_lock t_lock;

Line 694: -- arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID

690: cr.distribution_set_id, -- DISTRIBUTION_SET_ID
691: NULL, -- PAYMENT_SCHEDULE_ID
692: cr.receipt_method_id, -- RECEIPT_METHOD_ID
693: cr.receivables_trx_id, -- RECEIVABLES_TRX_ID
694: -- arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
695: -- arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
696: -- ED and UNED activity id should only be available on the to doc in application
697: NULL, -- ED_ADJ_RECEIVABLES_TRX_ID
698: NULL, -- UNED_RECEIVABLES_TRX_ID

Line 695: -- arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID

691: NULL, -- PAYMENT_SCHEDULE_ID
692: cr.receipt_method_id, -- RECEIPT_METHOD_ID
693: cr.receivables_trx_id, -- RECEIVABLES_TRX_ID
694: -- arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
695: -- arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
696: -- ED and UNED activity id should only be available on the to doc in application
697: NULL, -- ED_ADJ_RECEIVABLES_TRX_ID
698: NULL, -- UNED_RECEIVABLES_TRX_ID
699: cr.set_of_books_id, -- SET_OF_BOOKS_ID

Line 843: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cr()+');

839:
840:
841: BEGIN
842: local_log(procedure_name => 'load_line_data_app_from_cr',
843: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cr()+');
844: -- Insert line level data in Line GT with
845: -- selected_flag = Y
846: -- level_flag = L
847: -- From_to_flag = F

Line 996: -- arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID

992: cr.distribution_set_id, -- DISTRIBUTION_SET_ID
993: NULL, -- PAYMENT_SCHEDULE_ID
994: cr.receipt_method_id, -- RECEIPT_METHOD_ID
995: cr.receivables_trx_id, -- RECEIVABLES_TRX_ID
996: -- arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
997: -- arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
998: -- ED and UNED activity id should only be available on the to doc in application
999: NULL, -- ED_ADJ_RECEIVABLES_TRX_ID
1000: NULL, -- UNED_RECEIVABLES_TRX_ID

Line 997: -- arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID

993: NULL, -- PAYMENT_SCHEDULE_ID
994: cr.receipt_method_id, -- RECEIPT_METHOD_ID
995: cr.receivables_trx_id, -- RECEIVABLES_TRX_ID
996: -- arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
997: -- arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
998: -- ED and UNED activity id should only be available on the to doc in application
999: NULL, -- ED_ADJ_RECEIVABLES_TRX_ID
1000: NULL, -- UNED_RECEIVABLES_TRX_ID
1001: cr.set_of_books_id, -- SET_OF_BOOKS_ID

Line 1319: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-');

1315: AND app.applied_customer_trx_id = trx.customer_trx_id;
1316:
1317:
1318: local_log(procedure_name => 'load_line_data_app_from_cr',
1319: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-');
1320: EXCEPTION
1321: -- WHEN NO_DATA_FOUND THEN NULL;
1322: WHEN OTHERS THEN
1323: local_log(procedure_name => 'load_line_data_app_from_cr',

Line 1324: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cr '||

1320: EXCEPTION
1321: -- WHEN NO_DATA_FOUND THEN NULL;
1322: WHEN OTHERS THEN
1323: local_log(procedure_name => 'load_line_data_app_from_cr',
1324: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cr '||
1325: arp_global.CRLF ||'Error :'|| SQLERRM);
1326: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1327: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1328: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cr'|| arp_global.CRLF||

Line 1328: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cr'|| arp_global.CRLF||

1324: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cr '||
1325: arp_global.CRLF ||'Error :'|| SQLERRM);
1326: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1327: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1328: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cr'|| arp_global.CRLF||
1329: 'Error :'||SQLERRM);
1330: FND_MSG_PUB.ADD;
1331: RAISE;
1332: END load_line_data_app_from_cr;

Line 1346: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+');

1342: PROCEDURE load_line_data_app_from_cm(p_application_id IN NUMBER DEFAULT 222)
1343: IS
1344: BEGIN
1345: local_log(procedure_name => 'load_line_data_app_from_cm',
1346: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+');
1347: -- Insert line level data in Line GT with
1348: -- selected_flag = Y
1349: -- level_flag = L
1350: -- From_to_flag = F

Line 1765: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-');

1761: AND NVL(psch.terms_sequence_number,1) = 1;
1762:
1763:
1764: local_log(procedure_name => 'load_line_data_app_from_cm',
1765: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-');
1766: EXCEPTION
1767: -- WHEN NO_DATA_FOUND THEN NULL;
1768: WHEN OTHERS THEN
1769: local_log(procedure_name => 'load_line_data_app_from_cm',

Line 1770: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cm '||

1766: EXCEPTION
1767: -- WHEN NO_DATA_FOUND THEN NULL;
1768: WHEN OTHERS THEN
1769: local_log(procedure_name => 'load_line_data_app_from_cm',
1770: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cm '||
1771: arp_global.CRLF || 'Error :'|| SQLERRM);
1772: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1773: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1774: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cm'|| arp_global.CRLF||

Line 1774: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cm'|| arp_global.CRLF||

1770: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cm '||
1771: arp_global.CRLF || 'Error :'|| SQLERRM);
1772: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1773: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1774: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cm'|| arp_global.CRLF||
1775: 'Error :'||SQLERRM);
1776: FND_MSG_PUB.ADD;
1777: RAISE;
1778: END load_line_data_app_from_cm;

Line 1795: p_msg_text => 'arp_xla_extract_main_pkg.load_header_data_ctlgd ()+');

1791: PROCEDURE Load_header_data_ctlgd(p_application_id IN NUMBER DEFAULT 222)
1792: IS
1793: BEGIN
1794: local_log(procedure_name => 'load_header_data_ctlgd',
1795: p_msg_text => 'arp_xla_extract_main_pkg.load_header_data_ctlgd ()+');
1796: -----------------------
1797: -- Insert header into ar_xla_lines_extract with
1798: -- selected_flg = 'Y'
1799: -- level_flg = 'H'

Line 1982: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-');

1978: +------------------------------------------------*/
1979: /* to be removed at the end of the project*/
1980: -- Load_header_data_ctlgd_h ;
1981: local_log(procedure_name => 'load_header_data_ctlgd',
1982: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-');
1983:
1984: EXCEPTION
1985: -- WHEN NO_DATA_FOUND THEN NULL;
1986: WHEN OTHERS THEN

Line 1988: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_ctlgd '||

1984: EXCEPTION
1985: -- WHEN NO_DATA_FOUND THEN NULL;
1986: WHEN OTHERS THEN
1987: local_log(procedure_name => 'load_header_data_ctlgd',
1988: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_ctlgd '||
1989: arp_global.CRLF ||'Error :'|| SQLERRM);
1990: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1991: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1992: 'Procedure :arp_xla_extract_main_pkg.load_header_data_ctlgd'|| arp_global.CRLF||

Line 1992: 'Procedure :arp_xla_extract_main_pkg.load_header_data_ctlgd'|| arp_global.CRLF||

1988: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_ctlgd '||
1989: arp_global.CRLF ||'Error :'|| SQLERRM);
1990: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1991: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1992: 'Procedure :arp_xla_extract_main_pkg.load_header_data_ctlgd'|| arp_global.CRLF||
1993: 'Error :'||SQLERRM);
1994: FND_MSG_PUB.ADD;
1995: RAISE;
1996: END Load_header_data_ctlgd;

Line 2010: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+');

2006: PROCEDURE Load_header_data_adj(p_application_id IN NUMBER DEFAULT 222)
2007: IS
2008: BEGIN
2009: local_log(procedure_name => 'load_header_data_adj',
2010: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+');
2011: -- Insert into Lines GT for adjustments because header level
2012: -- shared sources can be used.
2013: INSERT INTO AR_XLA_LINES_EXTRACT(
2014: EVENT_ID

Line 2263: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-');

2259: AND ard.ref_cust_trx_line_gl_dist_id is null;
2260:
2261: -- Load_header_data_adj_h;
2262: local_log(procedure_name => 'load_header_data_adj',
2263: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-');
2264: EXCEPTION
2265: -- WHEN NO_DATA_FOUND THEN NULL;
2266: WHEN OTHERS THEN
2267: local_log(procedure_name => 'load_header_data_adj',

Line 2268: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_adj '||

2264: EXCEPTION
2265: -- WHEN NO_DATA_FOUND THEN NULL;
2266: WHEN OTHERS THEN
2267: local_log(procedure_name => 'load_header_data_adj',
2268: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_adj '||
2269: arp_global.CRLF || 'Error :'|| SQLERRM);
2270: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2271: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2272: 'Procedure :arp_xla_extract_main_pkg.load_header_data_adj'|| arp_global.CRLF||

Line 2272: 'Procedure :arp_xla_extract_main_pkg.load_header_data_adj'|| arp_global.CRLF||

2268: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_adj '||
2269: arp_global.CRLF || 'Error :'|| SQLERRM);
2270: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2271: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2272: 'Procedure :arp_xla_extract_main_pkg.load_header_data_adj'|| arp_global.CRLF||
2273: 'Error :'||SQLERRM);
2274: FND_MSG_PUB.ADD;
2275: RAISE;
2276: END Load_header_data_adj;

Line 2292: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+');

2288: PROCEDURE Load_header_data_crh(p_application_id IN NUMBER DEFAULT 222)
2289: IS
2290: BEGIN
2291: local_log(procedure_name => 'load_header_data_crh',
2292: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+');
2293: -- Insert header data to line level
2294: -- Pure Header sources and Shared header sources
2295: INSERT INTO AR_XLA_LINES_EXTRACT(
2296: EVENT_ID

Line 2459: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-');

2455: AND gt.source_id_int_1 = cr.cash_receipt_id
2456: AND cr.set_of_books_id = sob.set_of_books_id;
2457:
2458: local_log(procedure_name => 'load_header_data_crh',
2459: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-');
2460: EXCEPTION
2461: -- WHEN NO_DATA_FOUND THEN NULL;
2462: WHEN OTHERS THEN
2463: local_log(procedure_name => 'load_header_data_crh',

Line 2464: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_crh '||

2460: EXCEPTION
2461: -- WHEN NO_DATA_FOUND THEN NULL;
2462: WHEN OTHERS THEN
2463: local_log(procedure_name => 'load_header_data_crh',
2464: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_crh '||
2465: arp_global.CRLF ||'Error :'|| SQLERRM);
2466: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2467: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2468: 'Procedure :arp_xla_extract_main_pkg.load_header_data_crh'|| arp_global.CRLF||

Line 2468: 'Procedure :arp_xla_extract_main_pkg.load_header_data_crh'|| arp_global.CRLF||

2464: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_crh '||
2465: arp_global.CRLF ||'Error :'|| SQLERRM);
2466: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2467: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2468: 'Procedure :arp_xla_extract_main_pkg.load_header_data_crh'|| arp_global.CRLF||
2469: 'Error :'||SQLERRM);
2470: FND_MSG_PUB.ADD;
2471: RAISE;
2472: END Load_header_data_crh;

Line 2487: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+');

2483: PROCEDURE Load_header_data_th(p_application_id IN NUMBER DEFAULT 222)
2484: IS
2485: BEGIN
2486: local_log(procedure_name => 'Load_header_data_th',
2487: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+');
2488: INSERT INTO AR_XLA_LINES_EXTRACT(
2489: EVENT_ID
2490: ,SOURCE_ID
2491: ,SOURCE_TABLE

Line 2642: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-');

2638: AND trx.set_of_books_id = sob.set_of_books_id;
2639:
2640: -- Load_header_data_th_h;
2641: local_log(procedure_name => 'Load_header_data_th',
2642: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-');
2643: EXCEPTION
2644: -- WHEN NO_DATA_FOUND THEN NULL;
2645: WHEN OTHERS THEN
2646: local_log(procedure_name => 'Load_header_data_th',

Line 2647: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_th'||

2643: EXCEPTION
2644: -- WHEN NO_DATA_FOUND THEN NULL;
2645: WHEN OTHERS THEN
2646: local_log(procedure_name => 'Load_header_data_th',
2647: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_th'||
2648: arp_global.CRLF ||'Error :'|| SQLERRM);
2649: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2650: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2651: 'Procedure :arp_xla_extract_main_pkg.load_header_data_th'|| arp_global.CRLF||

Line 2651: 'Procedure :arp_xla_extract_main_pkg.load_header_data_th'|| arp_global.CRLF||

2647: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_th'||
2648: arp_global.CRLF ||'Error :'|| SQLERRM);
2649: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2650: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2651: 'Procedure :arp_xla_extract_main_pkg.load_header_data_th'|| arp_global.CRLF||
2652: 'Error :'||SQLERRM);
2653: FND_MSG_PUB.ADD;
2654: RAISE;
2655: END Load_header_data_th;

Line 2673: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+');

2669: PROCEDURE load_line_data_ctlgd(p_application_id IN NUMBER DEFAULT 222)
2670: IS
2671: BEGIN
2672: local_log(procedure_name => 'load_line_data_ctlgd',
2673: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+');
2674: -- Insert line level data in Line GT with
2675: -- level_flag = L
2676:
2677: INSERT INTO ar_xla_lines_extract (

Line 2870: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-');

2866: AND gld.set_of_books_id = sob.set_of_books_id
2867: AND gld.org_id = osp.org_id(+)
2868: AND gld.account_set_flag = 'N';
2869: local_log(procedure_name => 'load_line_data_ctlgd',
2870: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-');
2871: EXCEPTION
2872: -- WHEN NO_DATA_FOUND THEN NULL;
2873: WHEN OTHERS THEN
2874: local_log(procedure_name => 'load_line_data_ctlgd',

Line 2875: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd '||

2871: EXCEPTION
2872: -- WHEN NO_DATA_FOUND THEN NULL;
2873: WHEN OTHERS THEN
2874: local_log(procedure_name => 'load_line_data_ctlgd',
2875: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd '||
2876: arp_global.CRLF ||'Error :'|| SQLERRM);
2877: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2878: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2879: 'Procedure :arp_xla_extract_main_pkg.load_line_data_ctlgd'|| arp_global.CRLF||

Line 2879: 'Procedure :arp_xla_extract_main_pkg.load_line_data_ctlgd'|| arp_global.CRLF||

2875: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd '||
2876: arp_global.CRLF ||'Error :'|| SQLERRM);
2877: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2878: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2879: 'Procedure :arp_xla_extract_main_pkg.load_line_data_ctlgd'|| arp_global.CRLF||
2880: 'Error :'||SQLERRM);
2881: FND_MSG_PUB.ADD;
2882: RAISE;
2883: END load_line_data_ctlgd;

Line 2898: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+');

2894: PROCEDURE load_line_data_adj(p_application_id IN NUMBER DEFAULT 222)
2895: IS
2896: BEGIN
2897: local_log(procedure_name => 'load_line_data_adj',
2898: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+');
2899:
2900: -- Insert line level data in Line GT with
2901: -- selected_flag = N
2902: -- level_flag = L

Line 3091: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-');

3087: AND dist.ref_cust_trx_line_gl_dist_id = gldt.cust_trx_line_gl_dist_id(+)
3088: AND adj.set_of_books_id = sob.set_of_books_id
3089: AND adj.org_id = osp.org_id(+);
3090: local_log(procedure_name => 'load_line_data_adj',
3091: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-');
3092: EXCEPTION
3093: -- WHEN NO_DATA_FOUND THEN NULL;
3094: WHEN OTHERS THEN
3095: local_log(procedure_name => 'load_line_data_adj',

Line 3096: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_adj '||

3092: EXCEPTION
3093: -- WHEN NO_DATA_FOUND THEN NULL;
3094: WHEN OTHERS THEN
3095: local_log(procedure_name => 'load_line_data_adj',
3096: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_adj '||
3097: arp_global.CRLF ||'Error :'|| SQLERRM);
3098: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3099: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3100: 'Procedure :arp_xla_extract_main_pkg.load_line_data_adj'|| arp_global.CRLF||

Line 3100: 'Procedure :arp_xla_extract_main_pkg.load_line_data_adj'|| arp_global.CRLF||

3096: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_adj '||
3097: arp_global.CRLF ||'Error :'|| SQLERRM);
3098: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3099: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3100: 'Procedure :arp_xla_extract_main_pkg.load_line_data_adj'|| arp_global.CRLF||
3101: 'Error :'||SQLERRM);
3102: FND_MSG_PUB.ADD;
3103: RAISE;
3104: END load_line_data_adj;

Line 3121: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+');

3117: PROCEDURE load_line_data_app_to_trx(p_application_id IN NUMBER DEFAULT 222)
3118: IS
3119: BEGIN
3120: local_log(procedure_name => 'load_line_data_app_to_trx',
3121: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+');
3122: -- Insert line level data in Line GT with
3123: -- selected_flag = Y
3124: -- level_flag = L
3125: -- from_to_flag = T

Line 3254: arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID

3250: NULL, -- DISTRIBUTION_SET_ID
3251: psch.payment_schedule_id, -- PAYMENT_SCHEDULE_ID
3252: trxt.receipt_method_id, -- RECEIPT_METHOD_ID
3253: NULL, -- RECEIVABLES_TRX_ID
3254: arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
3255: arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
3256: trxt.set_of_books_id, -- SET_OF_BOOKS_ID
3257: trxt.primary_salesrep_id, -- SALESREP_ID
3258: trxt.bill_to_site_use_id, -- BILL_SITE_USE_ID

Line 3255: arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID

3251: psch.payment_schedule_id, -- PAYMENT_SCHEDULE_ID
3252: trxt.receipt_method_id, -- RECEIPT_METHOD_ID
3253: NULL, -- RECEIVABLES_TRX_ID
3254: arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
3255: arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
3256: trxt.set_of_books_id, -- SET_OF_BOOKS_ID
3257: trxt.primary_salesrep_id, -- SALESREP_ID
3258: trxt.bill_to_site_use_id, -- BILL_SITE_USE_ID
3259: trxt.drawee_site_use_id, -- DRAWEE_SITE_USE_ID

Line 3936: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-');

3932:
3933:
3934:
3935: local_log(procedure_name => 'load_line_data_app_to_trx',
3936: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-');
3937: EXCEPTION
3938: -- WHEN NO_DATA_FOUND THEN NULL;
3939: WHEN OTHERS THEN
3940: local_log(procedure_name => 'load_line_data_app_to_trx',

Line 3941: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_to_trx '||

3937: EXCEPTION
3938: -- WHEN NO_DATA_FOUND THEN NULL;
3939: WHEN OTHERS THEN
3940: local_log(procedure_name => 'load_line_data_app_to_trx',
3941: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_to_trx '||
3942: arp_global.CRLF || 'Error :'|| SQLERRM);
3943: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3944: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3945: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||

Line 3945: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||

3941: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_to_trx '||
3942: arp_global.CRLF || 'Error :'|| SQLERRM);
3943: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3944: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3945: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||
3946: 'Error :'||SQLERRM);
3947: FND_MSG_PUB.ADD;
3948: RAISE;
3949: END load_line_data_app_to_trx;

Line 3958: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_unid ()+');

3954: PROCEDURE load_line_data_app_unid(p_application_id IN NUMBER DEFAULT 222)
3955: IS
3956: BEGIN
3957: local_log(procedure_name => 'load_line_data_app_unid',
3958: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_unid ()+');
3959: -- Insert line level data in Line GT with
3960: -- selected_flag = Y
3961: -- level_flag = L
3962: -- from_to_flag = T

Line 4138: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_unid ()-');

4134: AND app.set_of_books_id = sob.set_of_books_id
4135: AND dist.source_type = 'UNID';
4136:
4137: local_log(procedure_name => 'load_line_data_app_unid',
4138: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_unid ()-');
4139:
4140: EXCEPTION
4141: -- WHEN NO_DATA_FOUND THEN NULL;
4142: WHEN OTHERS THEN

Line 4144: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_unid '||

4140: EXCEPTION
4141: -- WHEN NO_DATA_FOUND THEN NULL;
4142: WHEN OTHERS THEN
4143: local_log(procedure_name => 'load_line_data_app_unid',
4144: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_unid '||
4145: arp_global.CRLF || 'Error :'|| SQLERRM);
4146: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4147: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4148: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||

Line 4148: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||

4144: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_unid '||
4145: arp_global.CRLF || 'Error :'|| SQLERRM);
4146: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4147: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4148: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||
4149: 'Error :'||SQLERRM);
4150: FND_MSG_PUB.ADD;
4151: RAISE;
4152: END load_line_data_app_unid;

Line 4166: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+');

4162: PROCEDURE load_line_data_crh(p_application_id IN NUMBER DEFAULT 222)
4163: IS
4164: BEGIN
4165: local_log(procedure_name => 'load_line_data_crh',
4166: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+');
4167: -- Line data CR in Line GT
4168: -- Selected_flag = N
4169: -- Level_flag = L
4170: INSERT INTO ar_xla_lines_extract (

Line 4558: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-');

4554:
4555:
4556:
4557: local_log(procedure_name => 'load_line_data_crh',
4558: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-');
4559: EXCEPTION
4560: -- WHEN NO_DATA_FOUND THEN NULL;
4561: WHEN OTHERS THEN
4562: local_log(procedure_name => 'load_line_data_crh',

Line 4563: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_crh '||

4559: EXCEPTION
4560: -- WHEN NO_DATA_FOUND THEN NULL;
4561: WHEN OTHERS THEN
4562: local_log(procedure_name => 'load_line_data_crh',
4563: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_crh '||
4564: arp_global.CRLF || 'Error :'|| SQLERRM);
4565: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4566: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4567: 'Procedure :arp_xla_extract_main_pkg.load_line_data_crh'|| arp_global.CRLF||

Line 4567: 'Procedure :arp_xla_extract_main_pkg.load_line_data_crh'|| arp_global.CRLF||

4563: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_crh '||
4564: arp_global.CRLF || 'Error :'|| SQLERRM);
4565: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4566: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4567: 'Procedure :arp_xla_extract_main_pkg.load_line_data_crh'|| arp_global.CRLF||
4568: 'Error :'||SQLERRM);
4569: FND_MSG_PUB.ADD;
4570: RAISE;
4571: END load_line_data_crh;

Line 4599: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()+');

4595: l_res VARCHAR2(1);
4596: l_execution VARCHAR2(1) := 'N';
4597: BEGIN
4598: local_log(procedure_name => 'mfar_hook',
4599: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()+');
4600: IF NVL(FND_PROFILE.value('AR_MFAR_ACTIVATED'), 'N') = 'N' THEN
4601: l_execution := 'N';
4602: ELSE
4603: l_execution := 'Y';

Line 4633: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()-');

4629: mfar_rctapp_curr_round;
4630:
4631: END IF;
4632: local_log(procedure_name => 'mfar_hook',
4633: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()-');
4634: EXCEPTION
4635: -- WHEN NO_DATA_FOUND THEN NULL;
4636: WHEN OTHERS THEN
4637: local_log(procedure_name => 'mfar_hook',

Line 4642: 'Procedure :arp_xla_extract_main_pkg.mfar_hook'|| arp_global.CRLF||

4638: p_msg_text => 'EXCEPTION OTHERS in mfar_hook '||
4639: arp_global.CRLF || 'Error :'|| SQLERRM);
4640: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4641: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4642: 'Procedure :arp_xla_extract_main_pkg.mfar_hook'|| arp_global.CRLF||
4643: 'Error :'||SQLERRM);
4644: FND_MSG_PUB.ADD;
4645: RAISE;
4646: END mfar_hook;

Line 4711: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_fetch ()+');

4707: l_cmapp_curr_round_tab cmapp_curr_round_tab;
4708: BEGIN
4709:
4710: local_log(procedure_name => 'mfar_cmapp_fetch',
4711: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_fetch ()+');
4712:
4713: OPEN cmapp_curr_round_cur;
4714: LOOP
4715: fetch cmapp_curr_round_cur bulk collect into l_cmapp_curr_round_tab LIMIT MAX_ARRAY_SIZE;

Line 4757: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_fetch ()-');

4753:
4754: END IF;
4755:
4756: local_log(procedure_name => 'mfar_cmapp_fetch',
4757: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_fetch ()-');
4758: EXCEPTION
4759: -- WHEN NO_DATA_FOUND THEN NULL;
4760: WHEN OTHERS THEN
4761: local_log(procedure_name => 'mfar_cmapp_fetch',

Line 4766: 'Procedure :arp_xla_extract_main_pkg.mfar_cmapp_fetch'|| arp_global.CRLF||

4762: p_msg_text => 'EXCEPTION OTHERS in mfar_cmapp_fetch '||
4763: arp_global.CRLF || 'Error :'|| SQLERRM);
4764: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4765: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4766: 'Procedure :arp_xla_extract_main_pkg.mfar_cmapp_fetch'|| arp_global.CRLF||
4767: 'Error :'||SQLERRM);
4768: FND_MSG_PUB.ADD;
4769: RAISE;
4770:

Line 4811: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_trx_update ()+');

4807:
4808: BEGIN
4809:
4810: local_log(procedure_name => 'mfar_cmapp_trx_update',
4811: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_trx_update ()+');
4812:
4813: local_round := p_cmapp_curr_round.acctd_amount;
4814:
4815: local_log(procedure_name => 'mfar_cmapp_trx_update',

Line 4883: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_trx_update ()-');

4879: AND event_class_code = 'CREDIT_MEMO';
4880: END LOOP;
4881:
4882: local_log(procedure_name => 'mfar_cmapp_trx_update',
4883: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_trx_update ()-');
4884:
4885: EXCEPTION
4886: -- WHEN NO_DATA_FOUND THEN NULL;
4887: WHEN OTHERS THEN

Line 4893: 'Procedure :arp_xla_extract_main_pkg.mfar_cmapp_trx_update'|| arp_global.CRLF||

4889: p_msg_text => 'EXCEPTION OTHERS in mfar_cmapp_trx_update '||
4890: arp_global.CRLF || 'Error :'|| SQLERRM);
4891: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4892: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4893: 'Procedure :arp_xla_extract_main_pkg.mfar_cmapp_trx_update'|| arp_global.CRLF||
4894: 'Error :'||SQLERRM);
4895: FND_MSG_PUB.ADD;
4896: RAISE;
4897:

Line 4916: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_reg_cmapp_curr_round ()+');

4912: IS
4913: BEGIN
4914:
4915: local_log(procedure_name => 'mfar_reg_cmapp_curr_round',
4916: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_reg_cmapp_curr_round ()+');
4917:
4918: -- Insert MFAR CURR_ROUND rows for regular Credit Memos
4919: INSERT INTO ar_xla_lines_extract (
4920: EVENT_ID

Line 5409: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_reg_cmapp_curr_round ()-');

5405: AND l.event_id = curr.event_id
5406: AND l.source_id = curr.source_id;
5407:
5408: local_log(procedure_name => 'mfar_reg_cmapp_curr_round',
5409: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_reg_cmapp_curr_round ()-');
5410:
5411: EXCEPTION
5412: -- WHEN NO_DATA_FOUND THEN NULL;
5413: WHEN OTHERS THEN

Line 5419: 'Procedure :arp_xla_extract_main_pkg.mfar_reg_cmapp_curr_round'|| arp_global.CRLF||

5415: p_msg_text => 'EXCEPTION OTHERS in mfar_reg_cmapp_curr_round '||
5416: arp_global.CRLF || 'Error :'|| SQLERRM);
5417: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5418: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5419: 'Procedure :arp_xla_extract_main_pkg.mfar_reg_cmapp_curr_round'|| arp_global.CRLF||
5420: 'Error :'||SQLERRM);
5421: FND_MSG_PUB.ADD;
5422: RAISE;
5423: END;

Line 5572: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_from_to ()+');

5568: ORDER BY ra.receivable_application_id, (NVL(ard.from_amount_cr,0)-NVL(ard.from_amount_dr,0)); -- Bug 14140214
5569:
5570: begin
5571: local_log(procedure_name => 'mfar_cmapp_from_to',
5572: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cmapp_from_to ()+');
5573:
5574: -- Fetch the data of ar_cm_from_cur to the record l_ar_cm_from_tab
5575: open ar_cm_from_cur;
5576: loop

Line 5606: 'Procedure :arp_xla_extract_main_pkg.mfar_cmapp_from_to'|| arp_global.CRLF||

5602: p_msg_text => 'EXCEPTION OTHERS in mfar_cmapp_from_to '||
5603: arp_global.CRLF || 'Error :'|| SQLERRM);
5604: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5605: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5606: 'Procedure :arp_xla_extract_main_pkg.mfar_cmapp_from_to'|| arp_global.CRLF||
5607: 'Error :'||SQLERRM);
5608: FND_MSG_PUB.ADD;
5609: RAISE;
5610:

Line 5654: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cm_app_insert_extract()+');

5650:
5651: BEGIN
5652:
5653: local_log(procedure_name => 'mfar_cm_app_insert_extract',
5654: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cm_app_insert_extract()+');
5655:
5656: FOR i in p_ar_cm_from_rec.FIRST..p_ar_cm_from_rec.LAST
5657: LOOP
5658:

Line 5786: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cm_app_insert_extract()-');

5782: FORALL r IN l_cm_app_mfar_extract_tab.first..l_cm_app_mfar_extract_tab.last
5783: INSERT INTO ar_xla_lines_extract VALUES l_cm_app_mfar_extract_tab(r);
5784:
5785: local_log(procedure_name => 'mfar_cm_app_insert_extract',
5786: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_cm_app_insert_extract()-');
5787:
5788: EXCEPTION
5789: WHEN NO_DATA_FOUND THEN NULL;
5790: WHEN OTHERS THEN

Line 5796: 'Procedure :arp_xla_extract_main_pkg.mfar_cm_app_insert_extract'|| arp_global.CRLF||

5792: p_msg_text => 'EXCEPTION OTHERS in mfar_cm_app_insert_extract '||
5793: arp_global.CRLF || 'Error :'|| SQLERRM);
5794: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5795: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5796: 'Procedure :arp_xla_extract_main_pkg.mfar_cm_app_insert_extract'|| arp_global.CRLF||
5797: 'Error :'||SQLERRM);
5798: FND_MSG_PUB.ADD;
5799: RAISE;
5800:

Line 5818: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_app_dist_cr ()+');

5814:
5815: PROCEDURE mfar_app_dist_cr IS
5816: BEGIN
5817: local_log(procedure_name => 'mfar_app_dist_cr',
5818: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_app_dist_cr ()+');
5819: --
5820: -- For a RECP_CREATE and RECP_UPDATE events
5821: -- All application distributions are necessary for the MFAR CRH building
5822: --

Line 5951: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_app_dist_cr ()-');

5947: AND ard.ref_cust_trx_line_gl_dist_id = ctlgd.cust_trx_line_gl_dist_id(+)
5948: ORDER BY ard.line_id;
5949:
5950: local_log(procedure_name => 'mfar_app_dist_cr',
5951: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_app_dist_cr ()-');
5952: EXCEPTION
5953: -- WHEN NO_DATA_FOUND THEN NULL;
5954: WHEN OTHERS THEN
5955: local_log(procedure_name => 'mfar_app_dist_cr',

Line 5960: 'Procedure :arp_xla_extract_main_pkg.mfar_app_dist_cr'|| arp_global.CRLF||

5956: p_msg_text => 'EXCEPTION OTHERS in mfar_app_dist_cr '||
5957: arp_global.CRLF || 'Error :'|| SQLERRM);
5958: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5959: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5960: 'Procedure :arp_xla_extract_main_pkg.mfar_app_dist_cr'|| arp_global.CRLF||
5961: 'Error :'||SQLERRM);
5962: FND_MSG_PUB.ADD;
5963: RAISE;
5964: END;

Line 5980: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_crh_dist ()+');

5976:
5977: PROCEDURE mfar_crh_dist IS
5978: BEGIN
5979: local_log(procedure_name => 'mfar_crh_dist',
5980: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_crh_dist ()+');
5981: -- All CRH distribution part of the current posting will serve for the
5982: -- Additional distribution building
5983: INSERT INTO ar_crh_gt (
5984: cash_receipt_id ,

Line 6196: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_app_dist_cr ()-');

6192: AND paircrh.factor_discount_amount <> ( nvl(pairard.amount_dr,0) - nvl(pairard.amount_cr,0) )
6193: AND cr.set_of_books_id = lg.ledger_id;
6194:
6195: local_log(procedure_name => 'mfar_crh_dist',
6196: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_app_dist_cr ()-');
6197: EXCEPTION
6198: -- WHEN NO_DATA_FOUND THEN NULL;
6199: WHEN OTHERS THEN
6200: local_log(procedure_name => 'mfar_crh_dist',

Line 6205: 'Procedure :arp_xla_extract_main_pkg.mfar_crh_dist'|| arp_global.CRLF||

6201: p_msg_text => 'EXCEPTION OTHERS in mfar_crh_dist '||
6202: arp_global.CRLF || 'Error :'|| SQLERRM);
6203: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
6204: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
6205: 'Procedure :arp_xla_extract_main_pkg.mfar_crh_dist'|| arp_global.CRLF||
6206: 'Error :'||SQLERRM);
6207: FND_MSG_PUB.ADD;
6208: RAISE;
6209: END;

Line 6345: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_app_by_crh ()+');

6341: l_crh_mfar_extract_record crh_mfar_extract_record_type;
6342:
6343: BEGIN
6344: local_log(procedure_name => 'mfar_produit_app_by_crh',
6345: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_app_by_crh ()+');
6346:
6347: OPEN mfar_extract_cur;
6348: LOOP
6349: FETCH mfar_extract_cur BULK COLLECT INTO l_crh_mfar_extract_record LIMIT MAX_ARRAY_SIZE;

Line 6367: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_app_by_crh ()-');

6363: CLOSE mfar_extract_cur;
6364:
6365:
6366: local_log(procedure_name => 'mfar_produit_app_by_crh',
6367: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_app_by_crh ()-');
6368: EXCEPTION
6369: -- WHEN NO_DATA_FOUND THEN NULL;
6370: WHEN OTHERS THEN
6371: local_log(procedure_name => 'mfar_crh_dist',

Line 6376: 'Procedure :arp_xla_extract_main_pkg.mfar_produit_app_by_crh'|| arp_global.CRLF||

6372: p_msg_text => 'EXCEPTION OTHERS in mfar_produit_app_by_crh '||
6373: arp_global.CRLF || 'Error :'|| SQLERRM);
6374: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
6375: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
6376: 'Procedure :arp_xla_extract_main_pkg.mfar_produit_app_by_crh'|| arp_global.CRLF||
6377: 'Error :'||SQLERRM);
6378: FND_MSG_PUB.ADD;
6379: RAISE;
6380: END;

Line 6879: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_get_ra ()+');

6875:
6876:
6877: BEGIN
6878: local_log(procedure_name => 'mfar_get_ra',
6879: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_get_ra ()+');
6880:
6881: OPEN mfar_extract_app_cur;
6882: LOOP
6883: FETCH mfar_extract_app_cur BULK COLLECT INTO l_crh_mfar_extract_record LIMIT MAX_ARRAY_SIZE;

Line 6900: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_get_ra ()-');

6896:
6897: CLOSE mfar_extract_app_cur;
6898:
6899: local_log(procedure_name => 'mfar_get_ra',
6900: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_get_ra ()-');
6901: EXCEPTION
6902: -- WHEN NO_DATA_FOUND THEN NULL;
6903: WHEN OTHERS THEN
6904: local_log(procedure_name => 'mfar_get_ra',

Line 6909: 'Procedure :arp_xla_extract_main_pkg.mfar_get_ra'|| arp_global.CRLF||

6905: p_msg_text => 'EXCEPTION OTHERS in mfar_get_ra '||
6906: arp_global.CRLF || 'Error :'|| SQLERRM);
6907: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
6908: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
6909: 'Procedure :arp_xla_extract_main_pkg.mfar_get_ra'|| arp_global.CRLF||
6910: 'Error :'||SQLERRM);
6911: FND_MSG_PUB.ADD;
6912: RAISE;
6913: END mfar_get_ra;

Line 6927: p_msg_text => 'arp_xla_extract_main_pkg.mfar_rctapp_curr_round ()+');

6923: PROCEDURE mfar_rctapp_curr_round
6924: IS
6925: BEGIN
6926: local_log(procedure_name => 'mfar_rctapp_curr_round',
6927: p_msg_text => 'arp_xla_extract_main_pkg.mfar_rctapp_curr_round ()+');
6928:
6929: INSERT INTO ar_xla_lines_extract (
6930: EVENT_ID
6931: ,LINE_NUMBER

Line 7058: arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID

7054: NULL, -- DISTRIBUTION_SET_ID
7055: psch.payment_schedule_id, -- PAYMENT_SCHEDULE_ID
7056: trxt.receipt_method_id, -- RECEIPT_METHOD_ID
7057: NULL, -- RECEIVABLES_TRX_ID
7058: arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
7059: arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
7060: trxt.set_of_books_id, -- SET_OF_BOOKS_ID
7061: trxt.primary_salesrep_id, -- SALESREP_ID
7062: trxt.bill_to_site_use_id, -- BILL_SITE_USE_ID

Line 7059: arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID

7055: psch.payment_schedule_id, -- PAYMENT_SCHEDULE_ID
7056: trxt.receipt_method_id, -- RECEIPT_METHOD_ID
7057: NULL, -- RECEIVABLES_TRX_ID
7058: arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
7059: arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
7060: trxt.set_of_books_id, -- SET_OF_BOOKS_ID
7061: trxt.primary_salesrep_id, -- SALESREP_ID
7062: trxt.bill_to_site_use_id, -- BILL_SITE_USE_ID
7063: trxt.drawee_site_use_id, -- DRAWEE_SITE_USE_ID

Line 7148: p_msg_text => 'arp_xla_extract_main_pkg.mfar_rctapp_curr_round ()-');

7144: AND currard.source_type = 'CURR_ROUND';
7145:
7146:
7147: local_log(procedure_name => 'mfar_rctapp_curr_round',
7148: p_msg_text => 'arp_xla_extract_main_pkg.mfar_rctapp_curr_round ()-');
7149:
7150: EXCEPTION
7151: -- WHEN NO_DATA_FOUND THEN NULL;
7152: WHEN OTHERS THEN

Line 7154: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.mfar_rctapp_curr_round '||

7150: EXCEPTION
7151: -- WHEN NO_DATA_FOUND THEN NULL;
7152: WHEN OTHERS THEN
7153: local_log(procedure_name => 'mfar_rctapp_curr_round',
7154: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.mfar_rctapp_curr_round '||
7155: arp_global.CRLF || 'Error :'|| SQLERRM);
7156: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7157: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7158: 'Procedure :arp_xla_extract_main_pkg.mfar_rctapp_curr_round'|| arp_global.CRLF||

Line 7158: 'Procedure :arp_xla_extract_main_pkg.mfar_rctapp_curr_round'|| arp_global.CRLF||

7154: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.mfar_rctapp_curr_round '||
7155: arp_global.CRLF || 'Error :'|| SQLERRM);
7156: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7157: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7158: 'Procedure :arp_xla_extract_main_pkg.mfar_rctapp_curr_round'|| arp_global.CRLF||
7159: 'Error :'||SQLERRM);
7160: FND_MSG_PUB.ADD;
7161: RAISE;
7162: END mfar_rctapp_curr_round;

Line 7168: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_mcd_dist_cr ()+');

7164:
7165: PROCEDURE mfar_mcd_dist_cr IS
7166: BEGIN
7167: local_log(procedure_name => 'mfar_mcd_dist_cr',
7168: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_mcd_dist_cr ()+');
7169: INSERT INTO ar_crh_app_gt (
7170: entity_id
7171: ,receivable_application_id
7172: ,cash_receipt_history_id

Line 7276: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_mcd_dist_cr ()-');

7272: AND mcd.cash_receipt_history_id = crh.cash_receipt_history_id(+)
7273: AND mcd.misc_cash_distribution_id = ard.source_id
7274: AND ard.source_table = 'MCD';
7275: local_log(procedure_name => 'mfar_mcd_dist_cr',
7276: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_mcd_dist_cr ()-');
7277: EXCEPTION
7278: -- WHEN NO_DATA_FOUND THEN NULL;
7279: WHEN OTHERS THEN
7280: local_log(procedure_name => 'mfar_mcd_dist_cr',

Line 7285: 'Procedure :arp_xla_extract_main_pkg.mfar_mcd_dist_cr'|| arp_global.CRLF||

7281: p_msg_text => 'EXCEPTION OTHERS in mfar_mcd_dist_cr '||
7282: arp_global.CRLF || 'Error :'|| SQLERRM);
7283: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7284: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7285: 'Procedure :arp_xla_extract_main_pkg.mfar_mcd_dist_cr'|| arp_global.CRLF||
7286: 'Error :'||SQLERRM);
7287: FND_MSG_PUB.ADD;
7288: RAISE;
7289: END;

Line 7294: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_mcd_by_crh ()+');

7290:
7291: PROCEDURE mfar_produit_mcd_by_crh IS
7292: BEGIN
7293: local_log(procedure_name => 'mfar_produit_mcd_by_crh',
7294: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_mcd_by_crh ()+');
7295:
7296: INSERT INTO ar_xla_lines_extract
7297: (EVENT_ID
7298: ,LINE_NUMBER

Line 7419: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_mcd_by_crh ()-');

7415: WHERE crh.entity_id = mcd.entity_id
7416: AND mcd.source_table = 'MCD'
7417: AND crh.event_id = gt.event_id;
7418: local_log(procedure_name => 'mfar_produit_mcd_by_crh',
7419: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_mcd_by_crh ()-');
7420: EXCEPTION
7421: -- WHEN NO_DATA_FOUND THEN NULL;
7422: WHEN OTHERS THEN
7423: local_log(procedure_name => 'mfar_mcd_dist_cr',

Line 7428: 'Procedure :arp_xla_extract_main_pkg.mfar_produit_mcd_by_crh'|| arp_global.CRLF||

7424: p_msg_text => 'EXCEPTION OTHERS in mfar_produit_mcd_by_crh '||
7425: arp_global.CRLF || 'Error :'|| SQLERRM);
7426: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7427: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7428: 'Procedure :arp_xla_extract_main_pkg.mfar_produit_mcd_by_crh'|| arp_global.CRLF||
7429: 'Error :'||SQLERRM);
7430: FND_MSG_PUB.ADD;
7431: RAISE;
7432: END;

Line 7454: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+');

7450: PROCEDURE load_line_data_th(P_APPLICATION_ID IN NUMBER DEFAULT 222)
7451: IS
7452: BEGIN
7453: local_log(procedure_name => 'load_line_data_th',
7454: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+');
7455:
7456: INSERT INTO ar_xla_lines_extract (
7457: EVENT_ID
7458: ,LINE_NUMBER

Line 7650: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-');

7646: AND trx.set_of_books_id = sob.set_of_books_id
7647: AND trx.customer_trx_id = psch.customer_trx_id
7648: AND NVL(psch.terms_sequence_number,1) = 1;
7649: local_log(procedure_name => 'load_line_data_th',
7650: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-');
7651: EXCEPTION
7652: -- WHEN NO_DATA_FOUND THEN NULL;
7653: WHEN OTHERS THEN
7654: local_log(procedure_name => 'load_line_data_th',

Line 7655: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_th '||

7651: EXCEPTION
7652: -- WHEN NO_DATA_FOUND THEN NULL;
7653: WHEN OTHERS THEN
7654: local_log(procedure_name => 'load_line_data_th',
7655: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_th '||
7656: arp_global.CRLF || 'Error :'|| SQLERRM);
7657: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7658: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7659: 'Procedure :arp_xla_extract_main_pkg.load_line_data_th'|| arp_global.CRLF||

Line 7659: 'Procedure :arp_xla_extract_main_pkg.load_line_data_th'|| arp_global.CRLF||

7655: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_th '||
7656: arp_global.CRLF || 'Error :'|| SQLERRM);
7657: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7658: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7659: 'Procedure :arp_xla_extract_main_pkg.load_line_data_th'|| arp_global.CRLF||
7660: 'Error :'||SQLERRM);
7661: FND_MSG_PUB.ADD;
7662: RAISE;
7663: END load_line_data_th;

Line 7670: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_mcd()+');

7666: PROCEDURE load_line_data_mcd(p_application_id IN NUMBER DEFAULT 222)
7667: IS
7668: BEGIN
7669: local_log(procedure_name => 'load_line_data_mcd',
7670: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_mcd()+');
7671: -- Insert line level data in Line GT with
7672: -- selected_flag = N
7673: -- level_flag = L
7674: -- From_to_flag = NULL

Line 7848: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_mcd()-');

7844: AND mcd.cash_receipt_history_id = crh.cash_receipt_history_id(+);
7845: -- AND dist.source_type = 'MISCCASH';
7846:
7847: local_log(procedure_name => 'load_line_data_mcd',
7848: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_mcd()-');
7849: EXCEPTION
7850: -- WHEN NO_DATA_FOUND THEN NULL;
7851: WHEN OTHERS THEN
7852: local_log(procedure_name => 'load_line_data_mcd',

Line 7853: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_mcd '||

7849: EXCEPTION
7850: -- WHEN NO_DATA_FOUND THEN NULL;
7851: WHEN OTHERS THEN
7852: local_log(procedure_name => 'load_line_data_mcd',
7853: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_mcd '||
7854: arp_global.CRLF || 'Error :'|| SQLERRM);
7855: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7856: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7857: 'Procedure :arp_xla_extract_main_pkg.load_line_data_mcd'|| arp_global.CRLF||

Line 7857: 'Procedure :arp_xla_extract_main_pkg.load_line_data_mcd'|| arp_global.CRLF||

7853: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_mcd '||
7854: arp_global.CRLF || 'Error :'|| SQLERRM);
7855: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7856: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7857: 'Procedure :arp_xla_extract_main_pkg.load_line_data_mcd'|| arp_global.CRLF||
7858: 'Error :'||SQLERRM);
7859: FND_MSG_PUB.ADD;
7860: RAISE;
7861: END load_line_data_mcd;

Line 7897: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.extract()+');

7893: AND event_class_code in ('RECEIPT','MISC_RECEIPT','CREDIT_MEMO');
7894: l_sob_id NUMBER;
7895: BEGIN
7896: local_log(procedure_name => 'extract',
7897: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.extract()+');
7898: local_log(procedure_name => 'extract',
7899: p_msg_text => ' p_application_id :'|| p_application_id );
7900: local_log(procedure_name => 'extract',
7901: p_msg_text => ' p_accounting_mode :'|| p_accounting_mode);

Line 7966: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.extract()-');

7962: END IF;
7963: -- END IF;
7964:
7965: local_log(procedure_name => 'extract',
7966: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.extract()-');
7967: EXCEPTION
7968: -- WHEN NO_DATA_FOUND THEN NULL;
7969: WHEN OTHERS THEN
7970: local_log(procedure_name => 'extract',

Line 7971: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.extract '|| arp_global.CRLF ||

7967: EXCEPTION
7968: -- WHEN NO_DATA_FOUND THEN NULL;
7969: WHEN OTHERS THEN
7970: local_log(procedure_name => 'extract',
7971: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.extract '|| arp_global.CRLF ||
7972: 'Error :'|| SQLERRM);
7973: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7974: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7975: 'Procedure :arp_xla_extract_main_pkg.extract'|| arp_global.CRLF||

Line 7975: 'Procedure :arp_xla_extract_main_pkg.extract'|| arp_global.CRLF||

7971: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.extract '|| arp_global.CRLF ||
7972: 'Error :'|| SQLERRM);
7973: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
7974: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
7975: 'Procedure :arp_xla_extract_main_pkg.extract'|| arp_global.CRLF||
7976: 'Error :'||SQLERRM);
7977: FND_MSG_PUB.ADD;
7978: APP_EXCEPTION.RAISE_EXCEPTION;
7979: END extract;

Line 8060: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+');

8056: l_pst_id NUMBER;
8057: l_date DATE;
8058: BEGIN
8059: local_log(procedure_name => 'postprocessing',
8060: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+');
8061:
8062: IF p_accounting_mode = 'F' THEN
8063:
8064: SELECT ar_posting_control_s.NEXTVAL

Line 8209: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-');

8205: 'BILL_REVERSE' ));
8206:
8207: END IF;
8208: local_log(procedure_name => 'postprocessing',
8209: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-');
8210: EXCEPTION
8211: -- WHEN NO_DATA_FOUND THEN NULL;
8212: WHEN OTHERS THEN
8213: local_log(procedure_name => 'postprocessing',

Line 8214: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF ||

8210: EXCEPTION
8211: -- WHEN NO_DATA_FOUND THEN NULL;
8212: WHEN OTHERS THEN
8213: local_log(procedure_name => 'postprocessing',
8214: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF ||
8215: 'Error :'|| SQLERRM);
8216: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8217: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8218: 'Procedure :arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF||

Line 8218: 'Procedure :arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF||

8214: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF ||
8215: 'Error :'|| SQLERRM);
8216: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8217: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8218: 'Procedure :arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF||
8219: 'Error :'||SQLERRM);
8220: FND_MSG_PUB.ADD;
8221: APP_EXCEPTION.RAISE_EXCEPTION;
8222: END postprocessing;

Line 8230: p_msg_text =>'arp_xla_extract_main_pkg.flag_the_posting_id()+');

8226: PROCEDURE flag_the_posting_id(p_accounting_mode IN VARCHAR2)
8227: IS
8228: BEGIN
8229: local_log(procedure_name => 'flag_the_posting_id',
8230: p_msg_text =>'arp_xla_extract_main_pkg.flag_the_posting_id()+');
8231:
8232: postprocessing(p_application_id => 222
8233: ,p_accounting_mode => p_accounting_mode);
8234:

Line 8236: p_msg_text =>'ARP_XLA_EXTRACT_MAIN_PKG.flag_the_posting_id()-');

8232: postprocessing(p_application_id => 222
8233: ,p_accounting_mode => p_accounting_mode);
8234:
8235: local_log(procedure_name => 'flag_the_posting_id',
8236: p_msg_text =>'ARP_XLA_EXTRACT_MAIN_PKG.flag_the_posting_id()-');
8237: END flag_the_posting_id;
8238:
8239:
8240: /*-----------------------------------------------------------+

Line 8268: p_msg_text =>'arp_xla_extract_main_pkg.preaccounting()+');

8264: ,p_report_request_id IN NUMBER)
8265: IS
8266: BEGIN
8267: local_log(procedure_name =>'preaccounting',
8268: p_msg_text =>'arp_xla_extract_main_pkg.preaccounting()+');
8269:
8270: local_log(procedure_name =>'preaccounting',
8271: p_msg_text =>' p_application_id :'||p_application_id);
8272: local_log(procedure_name =>'preaccounting',

Line 8388: p_msg_text =>'arp_xla_extract_main_pkg.preaccounting -');

8384: AND trh.posting_control_id = -3
8385: FOR UPDATE OF trh.transaction_history_id;
8386:
8387: local_log(procedure_name =>'preaccounting',
8388: p_msg_text =>'arp_xla_extract_main_pkg.preaccounting -');
8389: EXCEPTION
8390: -- WHEN NO_DATA_FOUND THEN NULL;
8391: WHEN OTHERS THEN
8392: local_log(procedure_name =>'preaccounting',

Line 8393: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.lock_documents_for_xla '||

8389: EXCEPTION
8390: -- WHEN NO_DATA_FOUND THEN NULL;
8391: WHEN OTHERS THEN
8392: local_log(procedure_name =>'preaccounting',
8393: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.lock_documents_for_xla '||
8394: arp_global.CRLF || 'Error :'|| SQLERRM);
8395: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8396: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8397: 'Procedure :arp_xla_extract_main_pkg.lock_documents_for_xla'|| arp_global.CRLF||

Line 8397: 'Procedure :arp_xla_extract_main_pkg.lock_documents_for_xla'|| arp_global.CRLF||

8393: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.lock_documents_for_xla '||
8394: arp_global.CRLF || 'Error :'|| SQLERRM);
8395: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8396: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8397: 'Procedure :arp_xla_extract_main_pkg.lock_documents_for_xla'|| arp_global.CRLF||
8398: 'Error :'||SQLERRM);
8399: FND_MSG_PUB.ADD;
8400: APP_EXCEPTION.RAISE_EXCEPTION;
8401: END preaccounting;

Line 8437: 'Procedure:arp_xla_extract_main_pkg.lock_documents_for_xla

8433: EXCEPTION
8434: WHEN OTHERS THEN
8435: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8436: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8437: 'Procedure:arp_xla_extract_main_pkg.lock_documents_for_xla
8438: Error:'||SQLERRM);
8439: FND_MSG_PUB.ADD;
8440: -- APP_EXCEPTION.RAISE_EXCEPTION;
8441: RETURN 'ERROR';

Line 8473: 'Procedure:arp_xla_extract_main_pkg.extract

8469: EXCEPTION
8470: WHEN OTHERS THEN
8471: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8472: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8473: 'Procedure:arp_xla_extract_main_pkg.extract
8474: Mode:'||l_mode||'
8475: Error:'||SQLERRM);
8476: FND_MSG_PUB.ADD;
8477: -- APP_EXCEPTION.RAISE_EXCEPTION;

Line 8518: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status

8514: -- no functional impact. For now, the FND_GENERIC_MESSAGE is used
8515: -- We might need to end up seeded messages later.
8516: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8517: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8518: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status
8519: Error: accounting is '||l_mode||' - mode should be D (Draft) or F (Final)');
8520: FND_MSG_PUB.ADD;
8521: -- APP_EXCEPTION.RAISE_EXCEPTION;
8522: RETURN 'ERROR';

Line 8526: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status

8522: RETURN 'ERROR';
8523: WHEN OTHERS THEN
8524: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8525: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8526: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status
8527: Mode:'||l_mode||'
8528: Error:'||SQLERRM);
8529: FND_MSG_PUB.ADD;
8530: APP_EXCEPTION.RAISE_EXCEPTION;

Line 8548: --local_log('arp_xla_extract_main_pkg',' get_segment_value +');

8544: l_fetch_row INTEGER;
8545: l_stmt VARCHAR2(2000);
8546: l_xla_user VARCHAR2(30);
8547: BEGIN
8548: --local_log('arp_xla_extract_main_pkg',' get_segment_value +');
8549: l_stmt :=
8550: ' SELECT '||p_segment_name||'
8551: FROM gl_code_combinations
8552: WHERE chart_of_accounts_id = :coa_id

Line 8554: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);

8550: ' SELECT '||p_segment_name||'
8551: FROM gl_code_combinations
8552: WHERE chart_of_accounts_id = :coa_id
8553: AND code_combination_id = :ccid ';
8554: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
8555: l_c := DBMS_SQL.OPEN_CURSOR;
8556: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
8557: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
8558: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);

Line 8564: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');

8560: l_exec := DBMS_SQL.EXECUTE(l_c);
8561: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
8562: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
8563: DBMS_SQL.CLOSE_CURSOR(l_c);
8564: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');
8565: END;
8566:
8567: /*-------------------------------------------------------------------------------+
8568: | Procedure Name : mfar_insert_crh_extract

Line 8626: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_insert_crh_extract ()+');

8622:
8623:
8624: BEGIN
8625: local_log(procedure_name => 'mfar_insert_crh_extract',
8626: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_insert_crh_extract ()+');
8627:
8628: FOR i IN p_crh_mfar_extract_record.FIRST..p_crh_mfar_extract_record.LAST
8629: LOOP
8630:

Line 8899: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_insert_crh_extract ()-');

8895: FORALL r IN l_mfar_extract_tab.first..l_mfar_extract_tab.last
8896: INSERT INTO ar_xla_lines_extract VALUES l_mfar_extract_tab(r);
8897:
8898: local_log(procedure_name => 'mfar_insert_crh_extract',
8899: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_insert_crh_extract ()-');
8900:
8901: EXCEPTION
8902: -- WHEN NO_DATA_FOUND THEN NULL;
8903: WHEN OTHERS THEN

Line 8909: 'Procedure :arp_xla_extract_main_pkg.mfar_insert_crh_extract'|| arp_global.CRLF||

8905: p_msg_text => 'EXCEPTION OTHERS in mfar_insert_crh_extract '||
8906: arp_global.CRLF || 'Error :'|| SQLERRM);
8907: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
8908: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
8909: 'Procedure :arp_xla_extract_main_pkg.mfar_insert_crh_extract'|| arp_global.CRLF||
8910: 'Error :'||SQLERRM);
8911: FND_MSG_PUB.ADD;
8912: RAISE;
8913:

Line 8935: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.prorate_extract_acctd_amounts()+');

8931:
8932:
8933: BEGIN
8934: local_log(procedure_name => 'prorate_extract_acctd_amounts',
8935: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.prorate_extract_acctd_amounts()+');
8936:
8937: FOR i IN p_extract_record.FIRST..p_extract_record.LAST
8938: LOOP
8939:

Line 9045: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.prorate_extract_acctd_amounts ()-');

9041: FORALL r IN l_extract_tab.first..l_extract_tab.last
9042: INSERT INTO ar_xla_lines_extract VALUES l_extract_tab(r);
9043:
9044: local_log(procedure_name => 'prorate_extract_acctd_amounts',
9045: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.prorate_extract_acctd_amounts ()-');
9046:
9047: EXCEPTION
9048: -- WHEN NO_DATA_FOUND THEN NULL;
9049: WHEN OTHERS THEN

Line 9055: 'Procedure :arp_xla_extract_main_pkg.prorate_extract_acctd_amounts'|| arp_global.CRLF||

9051: p_msg_text => 'EXCEPTION OTHERS in prorate_extract_acctd_amounts '||
9052: arp_global.CRLF || 'Error :'|| SQLERRM);
9053: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
9054: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
9055: 'Procedure :arp_xla_extract_main_pkg.prorate_extract_acctd_amounts'|| arp_global.CRLF||
9056: 'Error :'||SQLERRM);
9057: FND_MSG_PUB.ADD;
9058: RAISE;
9059:

Line 9201: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.get_glr_ccid '||

9197: EXCEPTION
9198: WHEN NO_DATA_FOUND then return NULL;
9199: WHEN OTHERS THEN
9200: local_log(procedure_name => 'get_glr_ccid',
9201: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.get_glr_ccid '||
9202: arp_global.CRLF ||'Error :'|| SQLERRM);
9203: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
9204: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
9205: 'Procedure :arp_xla_extract_main_pkg.get_glr_ccid'|| arp_global.CRLF||

Line 9205: 'Procedure :arp_xla_extract_main_pkg.get_glr_ccid'|| arp_global.CRLF||

9201: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.get_glr_ccid '||
9202: arp_global.CRLF ||'Error :'|| SQLERRM);
9203: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
9204: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
9205: 'Procedure :arp_xla_extract_main_pkg.get_glr_ccid'|| arp_global.CRLF||
9206: 'Error :'||SQLERRM);
9207: FND_MSG_PUB.ADD;
9208: RAISE;
9209:

Line 9721: END arp_xla_extract_main_pkg;

9717:
9718: END;
9719:
9720:
9721: END arp_xla_extract_main_pkg;