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.83.12010000.4 2008/12/09 16:47:04 ankausha ship $ */
3:
4: TYPE t_lock IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
5: l_lock t_lock;

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

305: PROCEDURE load_line_data_app_from_cr(p_application_id IN NUMBER DEFAULT 222)
306: IS
307: BEGIN
308: local_log(procedure_name => 'load_line_data_app_from_cr',
309: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cr()+');
310: -- Insert line level data in Line GT with
311: -- selected_flag = Y
312: -- level_flag = L
313: -- From_to_flag = F

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

430: cr.distribution_set_id, -- DISTRIBUTION_SET_ID
431: NULL, -- PAYMENT_SCHEDULE_ID
432: cr.receipt_method_id, -- RECEIPT_METHOD_ID
433: cr.receivables_trx_id, -- RECEIVABLES_TRX_ID
434: -- arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
435: -- arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
436: -- ED and UNED activity id should only be available on the to doc in application
437: NULL, -- ED_ADJ_RECEIVABLES_TRX_ID
438: NULL, -- UNED_RECEIVABLES_TRX_ID

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

431: NULL, -- PAYMENT_SCHEDULE_ID
432: cr.receipt_method_id, -- RECEIPT_METHOD_ID
433: cr.receivables_trx_id, -- RECEIVABLES_TRX_ID
434: -- arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
435: -- arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
436: -- ED and UNED activity id should only be available on the to doc in application
437: NULL, -- ED_ADJ_RECEIVABLES_TRX_ID
438: NULL, -- UNED_RECEIVABLES_TRX_ID
439: cr.set_of_books_id, -- SET_OF_BOOKS_ID

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

749: AND app.applied_customer_trx_id = trx.customer_trx_id;
750:
751:
752: local_log(procedure_name => 'load_line_data_app_from_cr',
753: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cr ()-');
754: EXCEPTION
755: -- WHEN NO_DATA_FOUND THEN NULL;
756: WHEN OTHERS THEN
757: local_log(procedure_name => 'load_line_data_app_from_cr',

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

754: EXCEPTION
755: -- WHEN NO_DATA_FOUND THEN NULL;
756: WHEN OTHERS THEN
757: local_log(procedure_name => 'load_line_data_app_from_cr',
758: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cr '||
759: arp_global.CRLF ||'Error :'|| SQLERRM);
760: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
761: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
762: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cr'|| arp_global.CRLF||

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

758: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cr '||
759: arp_global.CRLF ||'Error :'|| SQLERRM);
760: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
761: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
762: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cr'|| arp_global.CRLF||
763: 'Error :'||SQLERRM);
764: FND_MSG_PUB.ADD;
765: RAISE;
766: END load_line_data_app_from_cr;

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

776: PROCEDURE load_line_data_app_from_cm(p_application_id IN NUMBER DEFAULT 222)
777: IS
778: BEGIN
779: local_log(procedure_name => 'load_line_data_app_from_cm',
780: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cm ()+');
781: -- Insert line level data in Line GT with
782: -- selected_flag = Y
783: -- level_flag = L
784: -- From_to_flag = F

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

1184: AND NVL(psch.terms_sequence_number,1) = 1;
1185:
1186:
1187: local_log(procedure_name => 'load_line_data_app_from_cm',
1188: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_from_cm ()-');
1189: EXCEPTION
1190: -- WHEN NO_DATA_FOUND THEN NULL;
1191: WHEN OTHERS THEN
1192: local_log(procedure_name => 'load_line_data_app_from_cm',

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

1189: EXCEPTION
1190: -- WHEN NO_DATA_FOUND THEN NULL;
1191: WHEN OTHERS THEN
1192: local_log(procedure_name => 'load_line_data_app_from_cm',
1193: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cm '||
1194: arp_global.CRLF || 'Error :'|| SQLERRM);
1195: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1196: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1197: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cm'|| arp_global.CRLF||

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

1193: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_from_cm '||
1194: arp_global.CRLF || 'Error :'|| SQLERRM);
1195: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1196: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1197: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_from_cm'|| arp_global.CRLF||
1198: 'Error :'||SQLERRM);
1199: FND_MSG_PUB.ADD;
1200: RAISE;
1201: END load_line_data_app_from_cm;

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

1214: PROCEDURE Load_header_data_ctlgd(p_application_id IN NUMBER DEFAULT 222)
1215: IS
1216: BEGIN
1217: local_log(procedure_name => 'load_header_data_ctlgd',
1218: p_msg_text => 'arp_xla_extract_main_pkg.load_header_data_ctlgd ()+');
1219: -----------------------
1220: -- Insert header into ar_xla_lines_extract with
1221: -- selected_flg = 'Y'
1222: -- level_flg = 'H'

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

1400: +------------------------------------------------*/
1401: /* to be removed at the end of the project*/
1402: -- Load_header_data_ctlgd_h ;
1403: local_log(procedure_name => 'load_header_data_ctlgd',
1404: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_ctlgd()-');
1405:
1406: EXCEPTION
1407: -- WHEN NO_DATA_FOUND THEN NULL;
1408: WHEN OTHERS THEN

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

1406: EXCEPTION
1407: -- WHEN NO_DATA_FOUND THEN NULL;
1408: WHEN OTHERS THEN
1409: local_log(procedure_name => 'load_header_data_ctlgd',
1410: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_ctlgd '||
1411: arp_global.CRLF ||'Error :'|| SQLERRM);
1412: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1413: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1414: 'Procedure :arp_xla_extract_main_pkg.load_header_data_ctlgd'|| arp_global.CRLF||

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

1410: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_ctlgd '||
1411: arp_global.CRLF ||'Error :'|| SQLERRM);
1412: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1413: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1414: 'Procedure :arp_xla_extract_main_pkg.load_header_data_ctlgd'|| arp_global.CRLF||
1415: 'Error :'||SQLERRM);
1416: FND_MSG_PUB.ADD;
1417: RAISE;
1418: END Load_header_data_ctlgd;

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

1428: PROCEDURE Load_header_data_adj(p_application_id IN NUMBER DEFAULT 222)
1429: IS
1430: BEGIN
1431: local_log(procedure_name => 'load_header_data_adj',
1432: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()+');
1433: -- Insert into Lines GT for adjustments because header level
1434: -- shared sources can be used.
1435: INSERT INTO AR_XLA_LINES_EXTRACT(
1436: EVENT_ID

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

1590: AND ctlgd.account_class = 'REC';
1591:
1592: -- Load_header_data_adj_h;
1593: local_log(procedure_name => 'load_header_data_adj',
1594: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_adj()-');
1595: EXCEPTION
1596: -- WHEN NO_DATA_FOUND THEN NULL;
1597: WHEN OTHERS THEN
1598: local_log(procedure_name => 'load_header_data_adj',

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

1595: EXCEPTION
1596: -- WHEN NO_DATA_FOUND THEN NULL;
1597: WHEN OTHERS THEN
1598: local_log(procedure_name => 'load_header_data_adj',
1599: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_adj '||
1600: arp_global.CRLF || 'Error :'|| SQLERRM);
1601: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1602: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1603: 'Procedure :arp_xla_extract_main_pkg.load_header_data_adj'|| arp_global.CRLF||

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

1599: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_adj '||
1600: arp_global.CRLF || 'Error :'|| SQLERRM);
1601: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1602: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1603: 'Procedure :arp_xla_extract_main_pkg.load_header_data_adj'|| arp_global.CRLF||
1604: 'Error :'||SQLERRM);
1605: FND_MSG_PUB.ADD;
1606: RAISE;
1607: END Load_header_data_adj;

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

1619: PROCEDURE Load_header_data_crh(p_application_id IN NUMBER DEFAULT 222)
1620: IS
1621: BEGIN
1622: local_log(procedure_name => 'load_header_data_crh',
1623: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()+');
1624: -- Insert header data to line level
1625: -- Pure Header sources and Shared header sources
1626: INSERT INTO AR_XLA_LINES_EXTRACT(
1627: EVENT_ID

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

1786: AND gt.source_id_int_1 = cr.cash_receipt_id
1787: AND cr.set_of_books_id = sob.set_of_books_id;
1788:
1789: local_log(procedure_name => 'load_header_data_crh',
1790: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_header_data_crh()-');
1791: EXCEPTION
1792: -- WHEN NO_DATA_FOUND THEN NULL;
1793: WHEN OTHERS THEN
1794: local_log(procedure_name => 'load_header_data_crh',

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

1791: EXCEPTION
1792: -- WHEN NO_DATA_FOUND THEN NULL;
1793: WHEN OTHERS THEN
1794: local_log(procedure_name => 'load_header_data_crh',
1795: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_crh '||
1796: arp_global.CRLF ||'Error :'|| SQLERRM);
1797: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1798: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1799: 'Procedure :arp_xla_extract_main_pkg.load_header_data_crh'|| arp_global.CRLF||

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

1795: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_crh '||
1796: arp_global.CRLF ||'Error :'|| SQLERRM);
1797: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1798: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1799: 'Procedure :arp_xla_extract_main_pkg.load_header_data_crh'|| arp_global.CRLF||
1800: 'Error :'||SQLERRM);
1801: FND_MSG_PUB.ADD;
1802: RAISE;
1803: END Load_header_data_crh;

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

1814: PROCEDURE Load_header_data_th(p_application_id IN NUMBER DEFAULT 222)
1815: IS
1816: BEGIN
1817: local_log(procedure_name => 'Load_header_data_th',
1818: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()+');
1819: INSERT INTO AR_XLA_LINES_EXTRACT(
1820: EVENT_ID
1821: ,SOURCE_ID
1822: ,SOURCE_TABLE

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

1969: AND trx.set_of_books_id = sob.set_of_books_id;
1970:
1971: -- Load_header_data_th_h;
1972: local_log(procedure_name => 'Load_header_data_th',
1973: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.Load_header_data_th()-');
1974: EXCEPTION
1975: -- WHEN NO_DATA_FOUND THEN NULL;
1976: WHEN OTHERS THEN
1977: local_log(procedure_name => 'Load_header_data_th',

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

1974: EXCEPTION
1975: -- WHEN NO_DATA_FOUND THEN NULL;
1976: WHEN OTHERS THEN
1977: local_log(procedure_name => 'Load_header_data_th',
1978: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_th'||
1979: arp_global.CRLF ||'Error :'|| SQLERRM);
1980: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1981: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1982: 'Procedure :arp_xla_extract_main_pkg.load_header_data_th'|| arp_global.CRLF||

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

1978: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_header_data_th'||
1979: arp_global.CRLF ||'Error :'|| SQLERRM);
1980: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
1981: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
1982: 'Procedure :arp_xla_extract_main_pkg.load_header_data_th'|| arp_global.CRLF||
1983: 'Error :'||SQLERRM);
1984: FND_MSG_PUB.ADD;
1985: RAISE;
1986: END Load_header_data_th;

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

2000: PROCEDURE load_line_data_ctlgd(p_application_id IN NUMBER DEFAULT 222)
2001: IS
2002: BEGIN
2003: local_log(procedure_name => 'load_line_data_ctlgd',
2004: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()+');
2005: -- Insert line level data in Line GT with
2006: -- level_flag = L
2007:
2008: INSERT INTO ar_xla_lines_extract (

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

2197: AND gld.set_of_books_id = sob.set_of_books_id
2198: AND gld.org_id = osp.org_id(+)
2199: AND gld.account_set_flag = 'N';
2200: local_log(procedure_name => 'load_line_data_ctlgd',
2201: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_ctlgd()-');
2202: EXCEPTION
2203: -- WHEN NO_DATA_FOUND THEN NULL;
2204: WHEN OTHERS THEN
2205: local_log(procedure_name => 'load_line_data_ctlgd',

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

2202: EXCEPTION
2203: -- WHEN NO_DATA_FOUND THEN NULL;
2204: WHEN OTHERS THEN
2205: local_log(procedure_name => 'load_line_data_ctlgd',
2206: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd '||
2207: arp_global.CRLF ||'Error :'|| SQLERRM);
2208: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2209: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2210: 'Procedure :arp_xla_extract_main_pkg.load_line_data_ctlgd'|| arp_global.CRLF||

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

2206: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_ctlgd '||
2207: arp_global.CRLF ||'Error :'|| SQLERRM);
2208: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2209: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2210: 'Procedure :arp_xla_extract_main_pkg.load_line_data_ctlgd'|| arp_global.CRLF||
2211: 'Error :'||SQLERRM);
2212: FND_MSG_PUB.ADD;
2213: RAISE;
2214: END load_line_data_ctlgd;

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

2225: PROCEDURE load_line_data_adj(p_application_id IN NUMBER DEFAULT 222)
2226: IS
2227: BEGIN
2228: local_log(procedure_name => 'load_line_data_adj',
2229: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()+');
2230:
2231: -- Insert line level data in Line GT with
2232: -- selected_flag = N
2233: -- level_flag = L

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

2416: AND dist.ref_cust_trx_line_gl_dist_id = gldt.cust_trx_line_gl_dist_id(+)
2417: AND adj.set_of_books_id = sob.set_of_books_id
2418: AND adj.org_id = osp.org_id(+);
2419: local_log(procedure_name => 'load_line_data_adj',
2420: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_adj()-');
2421: EXCEPTION
2422: -- WHEN NO_DATA_FOUND THEN NULL;
2423: WHEN OTHERS THEN
2424: local_log(procedure_name => 'load_line_data_adj',

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

2421: EXCEPTION
2422: -- WHEN NO_DATA_FOUND THEN NULL;
2423: WHEN OTHERS THEN
2424: local_log(procedure_name => 'load_line_data_adj',
2425: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_adj '||
2426: arp_global.CRLF ||'Error :'|| SQLERRM);
2427: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2428: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2429: 'Procedure :arp_xla_extract_main_pkg.load_line_data_adj'|| arp_global.CRLF||

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

2425: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_adj '||
2426: arp_global.CRLF ||'Error :'|| SQLERRM);
2427: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
2428: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
2429: 'Procedure :arp_xla_extract_main_pkg.load_line_data_adj'|| arp_global.CRLF||
2430: 'Error :'||SQLERRM);
2431: FND_MSG_PUB.ADD;
2432: RAISE;
2433: END load_line_data_adj;

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

2446: PROCEDURE load_line_data_app_to_trx(p_application_id IN NUMBER DEFAULT 222)
2447: IS
2448: BEGIN
2449: local_log(procedure_name => 'load_line_data_app_to_trx',
2450: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_to_trx ()+');
2451: -- Insert line level data in Line GT with
2452: -- selected_flag = Y
2453: -- level_flag = L
2454: -- from_to_flag = T

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

2575: NULL, -- DISTRIBUTION_SET_ID
2576: psch.payment_schedule_id, -- PAYMENT_SCHEDULE_ID
2577: trxt.receipt_method_id, -- RECEIPT_METHOD_ID
2578: NULL, -- RECEIVABLES_TRX_ID
2579: arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
2580: arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
2581: trxt.set_of_books_id, -- SET_OF_BOOKS_ID
2582: trxt.primary_salesrep_id, -- SALESREP_ID
2583: trxt.bill_to_site_use_id, -- BILL_SITE_USE_ID

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

2576: psch.payment_schedule_id, -- PAYMENT_SCHEDULE_ID
2577: trxt.receipt_method_id, -- RECEIPT_METHOD_ID
2578: NULL, -- RECEIVABLES_TRX_ID
2579: arp_xla_extract_main_pkg.ed_uned_trx('EDISC',app.org_id), -- ED_ADJ_RECEIVABLES_TRX_ID
2580: arp_xla_extract_main_pkg.ed_uned_trx('UNEDISC',app.org_id), -- UNED_RECEIVABLES_TRX_ID
2581: trxt.set_of_books_id, -- SET_OF_BOOKS_ID
2582: trxt.primary_salesrep_id, -- SALESREP_ID
2583: trxt.bill_to_site_use_id, -- BILL_SITE_USE_ID
2584: trxt.drawee_site_use_id, -- DRAWEE_SITE_USE_ID

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

3241:
3242:
3243:
3244: local_log(procedure_name => 'load_line_data_app_to_trx',
3245: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_to_trx ()-');
3246: EXCEPTION
3247: -- WHEN NO_DATA_FOUND THEN NULL;
3248: WHEN OTHERS THEN
3249: local_log(procedure_name => 'load_line_data_app_to_trx',

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

3246: EXCEPTION
3247: -- WHEN NO_DATA_FOUND THEN NULL;
3248: WHEN OTHERS THEN
3249: local_log(procedure_name => 'load_line_data_app_to_trx',
3250: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_to_trx '||
3251: arp_global.CRLF || 'Error :'|| SQLERRM);
3252: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3253: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3254: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||

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

3250: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_to_trx '||
3251: arp_global.CRLF || 'Error :'|| SQLERRM);
3252: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3253: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3254: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||
3255: 'Error :'||SQLERRM);
3256: FND_MSG_PUB.ADD;
3257: RAISE;
3258: END load_line_data_app_to_trx;

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

3263: PROCEDURE load_line_data_app_unid(p_application_id IN NUMBER DEFAULT 222)
3264: IS
3265: BEGIN
3266: local_log(procedure_name => 'load_line_data_app_unid',
3267: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_unid ()+');
3268: -- Insert line level data in Line GT with
3269: -- selected_flag = Y
3270: -- level_flag = L
3271: -- from_to_flag = T

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

3443: AND app.set_of_books_id = sob.set_of_books_id
3444: AND dist.source_type = 'UNID';
3445:
3446: local_log(procedure_name => 'load_line_data_app_unid',
3447: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_app_unid ()-');
3448:
3449: EXCEPTION
3450: -- WHEN NO_DATA_FOUND THEN NULL;
3451: WHEN OTHERS THEN

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

3449: EXCEPTION
3450: -- WHEN NO_DATA_FOUND THEN NULL;
3451: WHEN OTHERS THEN
3452: local_log(procedure_name => 'load_line_data_app_unid',
3453: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_unid '||
3454: arp_global.CRLF || 'Error :'|| SQLERRM);
3455: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3456: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3457: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||

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

3453: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_app_unid '||
3454: arp_global.CRLF || 'Error :'|| SQLERRM);
3455: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3456: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3457: 'Procedure :arp_xla_extract_main_pkg.load_line_data_app_to_trx'|| arp_global.CRLF||
3458: 'Error :'||SQLERRM);
3459: FND_MSG_PUB.ADD;
3460: RAISE;
3461: END load_line_data_app_unid;

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

3471: PROCEDURE load_line_data_crh(p_application_id IN NUMBER DEFAULT 222)
3472: IS
3473: BEGIN
3474: local_log(procedure_name => 'load_line_data_crh',
3475: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()+');
3476: -- Line data CR in Line GT
3477: -- Selected_flag = N
3478: -- Level_flag = L
3479: INSERT INTO ar_xla_lines_extract (

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

3860:
3861:
3862:
3863: local_log(procedure_name => 'load_line_data_crh',
3864: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_date_crh ()-');
3865: EXCEPTION
3866: -- WHEN NO_DATA_FOUND THEN NULL;
3867: WHEN OTHERS THEN
3868: local_log(procedure_name => 'load_line_data_crh',

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

3865: EXCEPTION
3866: -- WHEN NO_DATA_FOUND THEN NULL;
3867: WHEN OTHERS THEN
3868: local_log(procedure_name => 'load_line_data_crh',
3869: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_crh '||
3870: arp_global.CRLF || 'Error :'|| SQLERRM);
3871: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3872: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3873: 'Procedure :arp_xla_extract_main_pkg.load_line_data_crh'|| arp_global.CRLF||

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

3869: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_crh '||
3870: arp_global.CRLF || 'Error :'|| SQLERRM);
3871: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3872: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3873: 'Procedure :arp_xla_extract_main_pkg.load_line_data_crh'|| arp_global.CRLF||
3874: 'Error :'||SQLERRM);
3875: FND_MSG_PUB.ADD;
3876: RAISE;
3877: END load_line_data_crh;

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

3901: l_res VARCHAR2(1);
3902: l_execution VARCHAR2(1) := 'N';
3903: BEGIN
3904: local_log(procedure_name => 'mfar_hook',
3905: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()+');
3906: IF NVL(FND_PROFILE.value('AR_MFAR_ACTIVATED'), 'N') = 'N' THEN
3907: l_execution := 'N';
3908: ELSE
3909: l_execution := 'Y';

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

3925: -- Create the times of addition distribution for MCD
3926: mfar_produit_mcd_by_crh;
3927: END IF;
3928: local_log(procedure_name => 'mfar_hook',
3929: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_hook ()-');
3930: EXCEPTION
3931: -- WHEN NO_DATA_FOUND THEN NULL;
3932: WHEN OTHERS THEN
3933: local_log(procedure_name => 'mfar_hook',

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

3934: p_msg_text => 'EXCEPTION OTHERS in mfar_hook '||
3935: arp_global.CRLF || 'Error :'|| SQLERRM);
3936: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
3937: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
3938: 'Procedure :arp_xla_extract_main_pkg.mfar_hook'|| arp_global.CRLF||
3939: 'Error :'||SQLERRM);
3940: FND_MSG_PUB.ADD;
3941: RAISE;
3942: END mfar_hook;

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

3944:
3945: PROCEDURE mfar_app_dist_cr IS
3946: BEGIN
3947: local_log(procedure_name => 'mfar_app_dist_cr',
3948: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_app_dist_cr ()+');
3949: --
3950: -- For a RECP_CREATE and RECP_UPDATE events
3951: -- All application distributions are necessary for the MFAR CRH building
3952: --

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

4066: AND ard.ref_customer_trx_line_id = ctl.customer_trx_line_id(+)
4067: AND ard.ref_cust_trx_line_gl_dist_id = ctlgd.cust_trx_line_gl_dist_id(+);
4068:
4069: local_log(procedure_name => 'mfar_app_dist_cr',
4070: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_app_dist_cr ()-');
4071: EXCEPTION
4072: -- WHEN NO_DATA_FOUND THEN NULL;
4073: WHEN OTHERS THEN
4074: local_log(procedure_name => 'mfar_app_dist_cr',

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

4075: p_msg_text => 'EXCEPTION OTHERS in mfar_app_dist_cr '||
4076: arp_global.CRLF || 'Error :'|| SQLERRM);
4077: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4078: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4079: 'Procedure :arp_xla_extract_main_pkg.mfar_app_dist_cr'|| arp_global.CRLF||
4080: 'Error :'||SQLERRM);
4081: FND_MSG_PUB.ADD;
4082: RAISE;
4083: END;

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

4084:
4085: PROCEDURE mfar_crh_dist IS
4086: BEGIN
4087: local_log(procedure_name => 'mfar_crh_dist',
4088: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_crh_dist ()+');
4089: -- All CRH distribution part of the current posting will serve for the
4090: -- Additional distribution building
4091: INSERT INTO ar_crh_gt (
4092: cash_receipt_id ,

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

4143: AND ard.source_table = 'CRH'
4144: AND ard.source_type IN ('CASH','REMITTANCE','CONFIRMATION')
4145: AND cr.set_of_books_id = lg.ledger_id;
4146: local_log(procedure_name => 'mfar_crh_dist',
4147: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_app_dist_cr ()-');
4148: EXCEPTION
4149: -- WHEN NO_DATA_FOUND THEN NULL;
4150: WHEN OTHERS THEN
4151: local_log(procedure_name => 'mfar_crh_dist',

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

4152: p_msg_text => 'EXCEPTION OTHERS in mfar_crh_dist '||
4153: arp_global.CRLF || 'Error :'|| SQLERRM);
4154: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4155: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4156: 'Procedure :arp_xla_extract_main_pkg.mfar_crh_dist'|| arp_global.CRLF||
4157: 'Error :'||SQLERRM);
4158: FND_MSG_PUB.ADD;
4159: RAISE;
4160: END;

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

4162:
4163: PROCEDURE mfar_produit_app_by_crh IS
4164: BEGIN
4165: local_log(procedure_name => 'mfar_produit_app_by_crh',
4166: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_app_by_crh ()+');
4167: --
4168: -- Build the MFAR distribution for CRH
4169: --
4170: INSERT INTO ar_xla_lines_extract

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

4315: 'CONFIRMED','Y','N'),'N') = 'Y'
4316: AND crh.event_id = gt.event_id;
4317:
4318: local_log(procedure_name => 'mfar_produit_app_by_crh',
4319: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_app_by_crh ()-');
4320: EXCEPTION
4321: -- WHEN NO_DATA_FOUND THEN NULL;
4322: WHEN OTHERS THEN
4323: local_log(procedure_name => 'mfar_crh_dist',

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

4324: p_msg_text => 'EXCEPTION OTHERS in mfar_produit_app_by_crh '||
4325: arp_global.CRLF || 'Error :'|| SQLERRM);
4326: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4327: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4328: 'Procedure :arp_xla_extract_main_pkg.mfar_produit_app_by_crh'|| arp_global.CRLF||
4329: 'Error :'||SQLERRM);
4330: FND_MSG_PUB.ADD;
4331: RAISE;
4332: END;

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

4335:
4336: PROCEDURE mfar_get_ra IS
4337: BEGIN
4338: local_log(procedure_name => 'mfar_get_ra',
4339: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_get_ra ()+');
4340: INSERT INTO ar_xla_lines_extract
4341: (EVENT_ID
4342: ,LINE_NUMBER
4343: ,MFAR_ADDITIONAL_ENTRY

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

4494: FROM ar_cash_receipt_history_all a
4495: WHERE a.cash_receipt_id = cr.cash_receipt_id
4496: AND a.posting_control_id <> -3);
4497: local_log(procedure_name => 'mfar_get_ra',
4498: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_get_ra ()-');
4499: EXCEPTION
4500: -- WHEN NO_DATA_FOUND THEN NULL;
4501: WHEN OTHERS THEN
4502: local_log(procedure_name => 'mfar_get_ra',

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

4503: p_msg_text => 'EXCEPTION OTHERS in mfar_get_ra '||
4504: arp_global.CRLF || 'Error :'|| SQLERRM);
4505: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4506: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4507: 'Procedure :arp_xla_extract_main_pkg.mfar_get_ra'|| arp_global.CRLF||
4508: 'Error :'||SQLERRM);
4509: FND_MSG_PUB.ADD;
4510: RAISE;
4511: END;

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

4514:
4515: PROCEDURE mfar_mcd_dist_cr IS
4516: BEGIN
4517: local_log(procedure_name => 'mfar_mcd_dist_cr',
4518: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_mcd_dist_cr ()+');
4519: INSERT INTO ar_crh_app_gt (
4520: entity_id
4521: ,receivable_application_id
4522: ,cash_receipt_history_id

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

4620: AND mcd.cash_receipt_history_id = crh.cash_receipt_history_id(+)
4621: AND mcd.misc_cash_distribution_id = ard.source_id
4622: AND ard.source_table = 'MCD';
4623: local_log(procedure_name => 'mfar_mcd_dist_cr',
4624: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_mcd_dist_cr ()-');
4625: EXCEPTION
4626: -- WHEN NO_DATA_FOUND THEN NULL;
4627: WHEN OTHERS THEN
4628: local_log(procedure_name => 'mfar_mcd_dist_cr',

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

4629: p_msg_text => 'EXCEPTION OTHERS in mfar_mcd_dist_cr '||
4630: arp_global.CRLF || 'Error :'|| SQLERRM);
4631: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4632: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4633: 'Procedure :arp_xla_extract_main_pkg.mfar_mcd_dist_cr'|| arp_global.CRLF||
4634: 'Error :'||SQLERRM);
4635: FND_MSG_PUB.ADD;
4636: RAISE;
4637: END;

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

4638:
4639: PROCEDURE mfar_produit_mcd_by_crh IS
4640: BEGIN
4641: local_log(procedure_name => 'mfar_produit_mcd_by_crh',
4642: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_mcd_by_crh ()+');
4643:
4644: INSERT INTO ar_xla_lines_extract
4645: (EVENT_ID
4646: ,LINE_NUMBER

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

4763: WHERE crh.entity_id = mcd.entity_id
4764: AND mcd.source_table = 'MCD'
4765: AND crh.event_id = gt.event_id;
4766: local_log(procedure_name => 'mfar_produit_mcd_by_crh',
4767: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_produit_mcd_by_crh ()-');
4768: EXCEPTION
4769: -- WHEN NO_DATA_FOUND THEN NULL;
4770: WHEN OTHERS THEN
4771: local_log(procedure_name => 'mfar_mcd_dist_cr',

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

4772: p_msg_text => 'EXCEPTION OTHERS in mfar_produit_mcd_by_crh '||
4773: arp_global.CRLF || 'Error :'|| SQLERRM);
4774: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
4775: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
4776: 'Procedure :arp_xla_extract_main_pkg.mfar_produit_mcd_by_crh'|| arp_global.CRLF||
4777: 'Error :'||SQLERRM);
4778: FND_MSG_PUB.ADD;
4779: RAISE;
4780: END;

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

4798: PROCEDURE load_line_data_th(P_APPLICATION_ID IN NUMBER DEFAULT 222)
4799: IS
4800: BEGIN
4801: local_log(procedure_name => 'load_line_data_th',
4802: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+');
4803:
4804: INSERT INTO ar_xla_lines_extract (
4805: EVENT_ID
4806: ,LINE_NUMBER

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

4994: AND trx.set_of_books_id = sob.set_of_books_id
4995: AND trx.customer_trx_id = psch.customer_trx_id
4996: AND NVL(psch.terms_sequence_number,1) = 1;
4997: local_log(procedure_name => 'load_line_data_th',
4998: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-');
4999: EXCEPTION
5000: -- WHEN NO_DATA_FOUND THEN NULL;
5001: WHEN OTHERS THEN
5002: local_log(procedure_name => 'load_line_data_th',

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

4999: EXCEPTION
5000: -- WHEN NO_DATA_FOUND THEN NULL;
5001: WHEN OTHERS THEN
5002: local_log(procedure_name => 'load_line_data_th',
5003: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_th '||
5004: arp_global.CRLF || 'Error :'|| SQLERRM);
5005: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5006: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5007: 'Procedure :arp_xla_extract_main_pkg.load_line_data_th'|| arp_global.CRLF||

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

5003: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_th '||
5004: arp_global.CRLF || 'Error :'|| SQLERRM);
5005: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5006: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5007: 'Procedure :arp_xla_extract_main_pkg.load_line_data_th'|| arp_global.CRLF||
5008: 'Error :'||SQLERRM);
5009: FND_MSG_PUB.ADD;
5010: RAISE;
5011: END load_line_data_th;

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

5014: PROCEDURE load_line_data_mcd(p_application_id IN NUMBER DEFAULT 222)
5015: IS
5016: BEGIN
5017: local_log(procedure_name => 'load_line_data_mcd',
5018: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_mcd()+');
5019: -- Insert line level data in Line GT with
5020: -- selected_flag = N
5021: -- level_flag = L
5022: -- From_to_flag = NULL

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

5192: AND mcd.cash_receipt_history_id = crh.cash_receipt_history_id(+);
5193: -- AND dist.source_type = 'MISCCASH';
5194:
5195: local_log(procedure_name => 'load_line_data_mcd',
5196: p_msg_text => 'arp_xla_extract_main_pkg.load_line_data_mcd()-');
5197: EXCEPTION
5198: -- WHEN NO_DATA_FOUND THEN NULL;
5199: WHEN OTHERS THEN
5200: local_log(procedure_name => 'load_line_data_mcd',

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

5197: EXCEPTION
5198: -- WHEN NO_DATA_FOUND THEN NULL;
5199: WHEN OTHERS THEN
5200: local_log(procedure_name => 'load_line_data_mcd',
5201: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_mcd '||
5202: arp_global.CRLF || 'Error :'|| SQLERRM);
5203: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5204: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5205: 'Procedure :arp_xla_extract_main_pkg.load_line_data_mcd'|| arp_global.CRLF||

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

5201: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.load_line_data_mcd '||
5202: arp_global.CRLF || 'Error :'|| SQLERRM);
5203: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5204: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5205: 'Procedure :arp_xla_extract_main_pkg.load_line_data_mcd'|| arp_global.CRLF||
5206: 'Error :'||SQLERRM);
5207: FND_MSG_PUB.ADD;
5208: RAISE;
5209: END load_line_data_mcd;

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

5240: AND set_of_books_id IS NOT NULL;
5241: l_sob_id NUMBER;
5242: BEGIN
5243: local_log(procedure_name => 'extract',
5244: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.extract()+');
5245: local_log(procedure_name => 'extract',
5246: p_msg_text => ' p_application_id :'|| p_application_id );
5247: local_log(procedure_name => 'extract',
5248: p_msg_text => ' p_accounting_mode :'|| p_accounting_mode);

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

5305: END IF;
5306: -- END IF;
5307:
5308: local_log(procedure_name => 'extract',
5309: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.extract()-');
5310: EXCEPTION
5311: -- WHEN NO_DATA_FOUND THEN NULL;
5312: WHEN OTHERS THEN
5313: local_log(procedure_name => 'extract',

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

5310: EXCEPTION
5311: -- WHEN NO_DATA_FOUND THEN NULL;
5312: WHEN OTHERS THEN
5313: local_log(procedure_name => 'extract',
5314: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.extract '|| arp_global.CRLF ||
5315: 'Error :'|| SQLERRM);
5316: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5317: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5318: 'Procedure :arp_xla_extract_main_pkg.extract'|| arp_global.CRLF||

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

5314: p_msg_text => 'EXCEPTION OTHERS in arp_xla_extract_main_pkg.extract '|| arp_global.CRLF ||
5315: 'Error :'|| SQLERRM);
5316: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5317: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5318: 'Procedure :arp_xla_extract_main_pkg.extract'|| arp_global.CRLF||
5319: 'Error :'||SQLERRM);
5320: FND_MSG_PUB.ADD;
5321: APP_EXCEPTION.RAISE_EXCEPTION;
5322: END extract;

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

5399: l_pst_id NUMBER;
5400: l_date DATE;
5401: BEGIN
5402: local_log(procedure_name => 'postprocessing',
5403: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()+');
5404:
5405: IF p_accounting_mode = 'F' THEN
5406:
5407: SELECT ar_posting_control_s.NEXTVAL

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

5529: 'BILL_REVERSE' ));
5530:
5531: END IF;
5532: local_log(procedure_name => 'postprocessing',
5533: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.postprocessing()-');
5534: EXCEPTION
5535: -- WHEN NO_DATA_FOUND THEN NULL;
5536: WHEN OTHERS THEN
5537: local_log(procedure_name => 'postprocessing',

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

5534: EXCEPTION
5535: -- WHEN NO_DATA_FOUND THEN NULL;
5536: WHEN OTHERS THEN
5537: local_log(procedure_name => 'postprocessing',
5538: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF ||
5539: 'Error :'|| SQLERRM);
5540: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5541: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5542: 'Procedure :arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF||

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

5538: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF ||
5539: 'Error :'|| SQLERRM);
5540: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5541: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5542: 'Procedure :arp_xla_extract_main_pkg.postprocessing '|| arp_global.CRLF||
5543: 'Error :'||SQLERRM);
5544: FND_MSG_PUB.ADD;
5545: APP_EXCEPTION.RAISE_EXCEPTION;
5546: END postprocessing;

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

5550: PROCEDURE flag_the_posting_id(p_accounting_mode IN VARCHAR2)
5551: IS
5552: BEGIN
5553: local_log(procedure_name => 'flag_the_posting_id',
5554: p_msg_text =>'arp_xla_extract_main_pkg.flag_the_posting_id()+');
5555:
5556: postprocessing(p_application_id => 222
5557: ,p_accounting_mode => p_accounting_mode);
5558:

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

5556: postprocessing(p_application_id => 222
5557: ,p_accounting_mode => p_accounting_mode);
5558:
5559: local_log(procedure_name => 'flag_the_posting_id',
5560: p_msg_text =>'ARP_XLA_EXTRACT_MAIN_PKG.flag_the_posting_id()-');
5561: END flag_the_posting_id;
5562:
5563:
5564: /*-----------------------------------------------------------+

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

5588: ,p_report_request_id IN NUMBER)
5589: IS
5590: BEGIN
5591: local_log(procedure_name =>'preaccounting',
5592: p_msg_text =>'arp_xla_extract_main_pkg.preaccounting()+');
5593:
5594: local_log(procedure_name =>'preaccounting',
5595: p_msg_text =>' p_application_id :'||p_application_id);
5596: local_log(procedure_name =>'preaccounting',

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

5708: AND trh.posting_control_id = -3
5709: FOR UPDATE OF trh.transaction_history_id;
5710:
5711: local_log(procedure_name =>'preaccounting',
5712: p_msg_text =>'arp_xla_extract_main_pkg.preaccounting -');
5713: EXCEPTION
5714: -- WHEN NO_DATA_FOUND THEN NULL;
5715: WHEN OTHERS THEN
5716: local_log(procedure_name =>'preaccounting',

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

5713: EXCEPTION
5714: -- WHEN NO_DATA_FOUND THEN NULL;
5715: WHEN OTHERS THEN
5716: local_log(procedure_name =>'preaccounting',
5717: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.lock_documents_for_xla '||
5718: arp_global.CRLF || 'Error :'|| SQLERRM);
5719: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5720: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5721: 'Procedure :arp_xla_extract_main_pkg.lock_documents_for_xla'|| arp_global.CRLF||

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

5717: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.lock_documents_for_xla '||
5718: arp_global.CRLF || 'Error :'|| SQLERRM);
5719: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5720: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5721: 'Procedure :arp_xla_extract_main_pkg.lock_documents_for_xla'|| arp_global.CRLF||
5722: 'Error :'||SQLERRM);
5723: FND_MSG_PUB.ADD;
5724: APP_EXCEPTION.RAISE_EXCEPTION;
5725: END preaccounting;

Line 5761: 'Procedure:arp_xla_extract_main_pkg.lock_documents_for_xla

5757: EXCEPTION
5758: WHEN OTHERS THEN
5759: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5760: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5761: 'Procedure:arp_xla_extract_main_pkg.lock_documents_for_xla
5762: Error:'||SQLERRM);
5763: FND_MSG_PUB.ADD;
5764: -- APP_EXCEPTION.RAISE_EXCEPTION;
5765: RETURN 'ERROR';

Line 5797: 'Procedure:arp_xla_extract_main_pkg.extract

5793: EXCEPTION
5794: WHEN OTHERS THEN
5795: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5796: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5797: 'Procedure:arp_xla_extract_main_pkg.extract
5798: Mode:'||l_mode||'
5799: Error:'||SQLERRM);
5800: FND_MSG_PUB.ADD;
5801: -- APP_EXCEPTION.RAISE_EXCEPTION;

Line 5842: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status

5838: -- no functional impact. For now, the FND_GENERIC_MESSAGE is used
5839: -- We might need to end up seeded messages later.
5840: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5841: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5842: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status
5843: Error: accounting is '||l_mode||' - mode should be D (Draft) or F (Final)');
5844: FND_MSG_PUB.ADD;
5845: -- APP_EXCEPTION.RAISE_EXCEPTION;
5846: RETURN 'ERROR';

Line 5850: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status

5846: RETURN 'ERROR';
5847: WHEN OTHERS THEN
5848: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
5849: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
5850: 'Procedure:arp_xla_extract_main_pkg.posting_ctl_status
5851: Mode:'||l_mode||'
5852: Error:'||SQLERRM);
5853: FND_MSG_PUB.ADD;
5854: APP_EXCEPTION.RAISE_EXCEPTION;

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

5868: l_fetch_row INTEGER;
5869: l_stmt VARCHAR2(2000);
5870: l_xla_user VARCHAR2(30);
5871: BEGIN
5872: --local_log('arp_xla_extract_main_pkg',' get_segment_value +');
5873: l_stmt :=
5874: ' SELECT '||p_segment_name||'
5875: FROM gl_code_combinations
5876: WHERE chart_of_accounts_id = :coa_id

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

5874: ' SELECT '||p_segment_name||'
5875: FROM gl_code_combinations
5876: WHERE chart_of_accounts_id = :coa_id
5877: AND code_combination_id = :ccid ';
5878: --local_log('arp_xla_extract_main_pkg',' l_stmt :'||l_stmt);
5879: l_c := DBMS_SQL.OPEN_CURSOR;
5880: DBMS_SQL.PARSE(l_c, l_stmt, DBMS_SQL.NATIVE);
5881: DBMS_SQL.BIND_VARIABLE(l_c,':coa_id',p_coa_id);
5882: DBMS_SQL.BIND_VARIABLE(l_c,':ccid',p_ccid);

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

5884: l_exec := DBMS_SQL.EXECUTE(l_c);
5885: l_fetch_row := DBMS_SQL.FETCH_ROWS(l_c);
5886: DBMS_SQL.COLUMN_VALUE(l_c, 1, x_segment_value);
5887: DBMS_SQL.CLOSE_CURSOR(l_c);
5888: --local_log('arp_xla_extract_main_pkg',' get_segment_value -');
5889: END;
5890:
5891:
5892: FUNCTION the_segment_value(p_coa_id IN NUMBER,

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

6026: EXCEPTION
6027: WHEN NO_DATA_FOUND then return NULL;
6028: WHEN OTHERS THEN
6029: local_log(procedure_name => 'get_glr_ccid',
6030: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.get_glr_ccid '||
6031: arp_global.CRLF ||'Error :'|| SQLERRM);
6032: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
6033: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
6034: 'Procedure :arp_xla_extract_main_pkg.get_glr_ccid'|| arp_global.CRLF||

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

6030: p_msg_text =>'EXCEPTION OTHERS in arp_xla_extract_main_pkg.get_glr_ccid '||
6031: arp_global.CRLF ||'Error :'|| SQLERRM);
6032: FND_MESSAGE.SET_NAME('FND', 'FND_GENERIC_MESSAGE');
6033: FND_MESSAGE.SET_TOKEN('MESSAGE' ,
6034: 'Procedure :arp_xla_extract_main_pkg.get_glr_ccid'|| arp_global.CRLF||
6035: 'Error :'||SQLERRM);
6036: FND_MSG_PUB.ADD;
6037: RAISE;
6038:

Line 6550: END arp_xla_extract_main_pkg;

6546:
6547: END;
6548:
6549:
6550: END arp_xla_extract_main_pkg;