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_GLOBAL

Line 1325: arp_global.CRLF ||'Error :'|| SQLERRM);

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||
1329: 'Error :'||SQLERRM);

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 1771: arp_global.CRLF || 'Error :'|| SQLERRM);

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||
1775: 'Error :'||SQLERRM);

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 1989: arp_global.CRLF ||'Error :'|| SQLERRM);

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||
1993: 'Error :'||SQLERRM);

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 2269: arp_global.CRLF || 'Error :'|| SQLERRM);

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||
2273: 'Error :'||SQLERRM);

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 2465: arp_global.CRLF ||'Error :'|| SQLERRM);

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||
2469: 'Error :'||SQLERRM);

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 2648: arp_global.CRLF ||'Error :'|| SQLERRM);

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||
2652: 'Error :'||SQLERRM);

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 2876: arp_global.CRLF ||'Error :'|| SQLERRM);

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||
2880: 'Error :'||SQLERRM);

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 3097: arp_global.CRLF ||'Error :'|| SQLERRM);

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||
3101: 'Error :'||SQLERRM);

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 3942: arp_global.CRLF || 'Error :'|| SQLERRM);

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||
3946: 'Error :'||SQLERRM);

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 4145: arp_global.CRLF || 'Error :'|| SQLERRM);

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||
4149: 'Error :'||SQLERRM);

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 4564: arp_global.CRLF || 'Error :'|| SQLERRM);

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||
4568: 'Error :'||SQLERRM);

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 4639: arp_global.CRLF || 'Error :'|| SQLERRM);

4635: -- WHEN NO_DATA_FOUND THEN NULL;
4636: WHEN OTHERS THEN
4637: local_log(procedure_name => 'mfar_hook',
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);

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 4763: arp_global.CRLF || 'Error :'|| SQLERRM);

4759: -- WHEN NO_DATA_FOUND THEN NULL;
4760: WHEN OTHERS THEN
4761: local_log(procedure_name => 'mfar_cmapp_fetch',
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);

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 4890: arp_global.CRLF || 'Error :'|| SQLERRM);

4886: -- WHEN NO_DATA_FOUND THEN NULL;
4887: WHEN OTHERS THEN
4888: local_log(procedure_name => 'mfar_cmapp_trx_update',
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);

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 5416: arp_global.CRLF || 'Error :'|| SQLERRM);

5412: -- WHEN NO_DATA_FOUND THEN NULL;
5413: WHEN OTHERS THEN
5414: local_log(procedure_name => 'mfar_reg_cmapp_curr_round',
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);

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 5603: arp_global.CRLF || 'Error :'|| SQLERRM);

5599: WHEN NO_DATA_FOUND THEN NULL;
5600: WHEN OTHERS THEN
5601: local_log(procedure_name => 'mfar_cmapp_from_to',
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);

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 5793: arp_global.CRLF || 'Error :'|| SQLERRM);

5789: WHEN NO_DATA_FOUND THEN NULL;
5790: WHEN OTHERS THEN
5791: local_log(procedure_name => 'mfar_cm_app_insert_extract',
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);

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 5957: arp_global.CRLF || 'Error :'|| SQLERRM);

5953: -- WHEN NO_DATA_FOUND THEN NULL;
5954: WHEN OTHERS THEN
5955: local_log(procedure_name => 'mfar_app_dist_cr',
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);

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 6202: arp_global.CRLF || 'Error :'|| SQLERRM);

6198: -- WHEN NO_DATA_FOUND THEN NULL;
6199: WHEN OTHERS THEN
6200: local_log(procedure_name => 'mfar_crh_dist',
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);

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 6373: arp_global.CRLF || 'Error :'|| SQLERRM);

6369: -- WHEN NO_DATA_FOUND THEN NULL;
6370: WHEN OTHERS THEN
6371: local_log(procedure_name => 'mfar_crh_dist',
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);

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 6906: arp_global.CRLF || 'Error :'|| SQLERRM);

6902: -- WHEN NO_DATA_FOUND THEN NULL;
6903: WHEN OTHERS THEN
6904: local_log(procedure_name => 'mfar_get_ra',
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);

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 7155: arp_global.CRLF || 'Error :'|| SQLERRM);

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||
7159: 'Error :'||SQLERRM);

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 7282: arp_global.CRLF || 'Error :'|| SQLERRM);

7278: -- WHEN NO_DATA_FOUND THEN NULL;
7279: WHEN OTHERS THEN
7280: local_log(procedure_name => 'mfar_mcd_dist_cr',
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);

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 7425: arp_global.CRLF || 'Error :'|| SQLERRM);

7421: -- WHEN NO_DATA_FOUND THEN NULL;
7422: WHEN OTHERS THEN
7423: local_log(procedure_name => 'mfar_mcd_dist_cr',
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);

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 7656: arp_global.CRLF || 'Error :'|| SQLERRM);

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||
7660: 'Error :'||SQLERRM);

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 7854: arp_global.CRLF || 'Error :'|| SQLERRM);

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||
7858: 'Error :'||SQLERRM);

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 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 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 8394: arp_global.CRLF || 'Error :'|| SQLERRM);

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||
8398: 'Error :'||SQLERRM);

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 8906: arp_global.CRLF || 'Error :'|| SQLERRM);

8902: -- WHEN NO_DATA_FOUND THEN NULL;
8903: WHEN OTHERS THEN
8904: local_log(procedure_name => 'mfar_insert_crh_extract',
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);

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 9052: arp_global.CRLF || 'Error :'|| SQLERRM);

9048: -- WHEN NO_DATA_FOUND THEN NULL;
9049: WHEN OTHERS THEN
9050: local_log(procedure_name => 'prorate_extract_acctd_amounts',
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);

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 9202: arp_global.CRLF ||'Error :'|| SQLERRM);

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||
9206: 'Error :'||SQLERRM);

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: