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

Line 1: PACKAGE BODY xla_aad_upload_pvt AS

1: PACKAGE BODY xla_aad_upload_pvt AS
2: /* $Header: xlaalupl.pkb 120.32.12020000.4 2013/01/30 11:51:16 sgullape ship $ */
3:
4: --=============================================================================
5: -- **************** declaraions ********************

Line 28: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_aad_upload_pvt';

24: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
25: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
26:
27: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
28: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_aad_upload_pvt';
29:
30: g_log_level NUMBER;
31: g_log_enabled BOOLEAN;
32:

Line 50: (p_location => 'xla_aad_upload_pvt.trace');

46: RAISE;
47:
48: WHEN OTHERS THEN
49: xla_exceptions_pkg.raise_message
50: (p_location => 'xla_aad_upload_pvt.trace');
51: END trace;
52:
53:
54: --=============================================================================

Line 132: ,p_value_1 => 'xla_aad_upload_pvt.submit_request'

128: xla_aad_loader_util_pvt.stack_error
129: (p_appli_s_name => 'XLA'
130: ,p_msg_name => 'XLA_COMMON_ERROR'
131: ,p_token_1 => 'LOCATION'
132: ,p_value_1 => 'xla_aad_upload_pvt.submit_request'
133: ,p_token_2 => 'ERROR'
134: ,p_value_2 => sqlcode ||' - '|| sqlerrm); --Bug 16208537
135: RAISE;
136:

Line 209: ,p_value_1 => 'xla_aad_upload_pvt.upload_data'

205: xla_aad_loader_util_pvt.stack_error
206: (p_appli_s_name => 'XLA'
207: ,p_msg_name => 'XLA_COMMON_ERROR'
208: ,p_token_1 => 'LOCATION'
209: ,p_value_1 => 'xla_aad_upload_pvt.upload_data'
210: ,p_token_2 => 'ERROR'
211: ,p_value_2 => sqlcode ||' - '|| sqlerrm); --Bug 16208537
212: RAISE;
213:

Line 847: trace(p_msg => 'Error in xla_aad_upload_pvt.validation is : '||l_excp_code||'-'||l_exception,

843: l_exception := sqlerrm; --Bug 16208537
844: l_excp_code := sqlcode;
845:
846: IF (C_LEVEL_EVENT >= g_log_level) THEN
847: trace(p_msg => 'Error in xla_aad_upload_pvt.validation is : '||l_excp_code||'-'||l_exception,
848: p_module => l_log_module,
849: p_level => C_LEVEL_EVENT);
850: END IF;
851:

Line 856: ,p_value_1 => 'xla_aad_upload_pvt.validation'

852: xla_aad_loader_util_pvt.stack_error
853: (p_appli_s_name => 'XLA'
854: ,p_msg_name => 'XLA_COMMON_ERROR'
855: ,p_token_1 => 'LOCATION'
856: ,p_value_1 => 'xla_aad_upload_pvt.validation'
857: ,p_token_2 => 'ERROR'
858: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
859: RAISE;
860: END;

Line 1247: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_descriptions',

1243: l_exception := sqlerrm; --Bug 16208537
1244: l_excp_code := sqlcode;
1245:
1246: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1247: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_descriptions',
1248: p_module => l_log_module,
1249: p_level => C_LEVEL_PROCEDURE);
1250: END IF;
1251:

Line 1253: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_descriptions is : '||l_excp_code||'-'||l_exception,

1249: p_level => C_LEVEL_PROCEDURE);
1250: END IF;
1251:
1252: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1253: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_descriptions is : '||l_excp_code||'-'||l_exception,
1254: p_module => l_log_module,
1255: p_level => C_LEVEL_PROCEDURE);
1256: END IF;
1257:

Line 1263: ,p_value_1 => 'xla_aad_upload_pvt.populate_descriptions'

1259: xla_aad_loader_util_pvt.stack_error
1260: (p_appli_s_name => 'XLA'
1261: ,p_msg_name => 'XLA_COMMON_ERROR'
1262: ,p_token_1 => 'LOCATION'
1263: ,p_value_1 => 'xla_aad_upload_pvt.populate_descriptions'
1264: ,p_token_2 => 'ERROR'
1265: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
1266: RAISE;
1267:

Line 1659: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_mapping_sets',

1655: l_exception := sqlerrm; --Bug 16208537
1656: l_excp_code := sqlcode;
1657:
1658: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1659: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_mapping_sets',
1660: p_module => l_log_module,
1661: p_level => C_LEVEL_PROCEDURE);
1662: END IF;
1663:

Line 1665: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_mapping_sets is : '||l_excp_code||'-'||l_exception,

1661: p_level => C_LEVEL_PROCEDURE);
1662: END IF;
1663:
1664: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1665: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_mapping_sets is : '||l_excp_code||'-'||l_exception,
1666: p_module => l_log_module,
1667: p_level => C_LEVEL_PROCEDURE);
1668: END IF;
1669:

Line 1674: ,p_value_1 => 'xla_aad_upload_pvt.populate_mapping_sets'

1670: xla_aad_loader_util_pvt.stack_error
1671: (p_appli_s_name => 'XLA'
1672: ,p_msg_name => 'XLA_COMMON_ERROR'
1673: ,p_token_1 => 'LOCATION'
1674: ,p_value_1 => 'xla_aad_upload_pvt.populate_mapping_sets'
1675: ,p_token_2 => 'ERROR'
1676: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
1677: RAISE;
1678:

Line 1995: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_analytical_criteria',

1991: l_exception := sqlerrm; --Bug 16208537
1992: l_excp_code := sqlcode;
1993:
1994: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1995: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_analytical_criteria',
1996: p_module => l_log_module,
1997: p_level => C_LEVEL_PROCEDURE);
1998: END IF;
1999:

Line 2001: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_analytical_criteria is : '||l_excp_code||'-'||l_exception,

1997: p_level => C_LEVEL_PROCEDURE);
1998: END IF;
1999:
2000: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2001: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_analytical_criteria is : '||l_excp_code||'-'||l_exception,
2002: p_module => l_log_module,
2003: p_level => C_LEVEL_PROCEDURE);
2004: END IF;
2005:

Line 2010: ,p_value_1 => 'xla_aad_upload_pvt.populate_analytical_criteria'

2006: xla_aad_loader_util_pvt.stack_error
2007: (p_appli_s_name => 'XLA'
2008: ,p_msg_name => 'XLA_COMMON_ERROR'
2009: ,p_token_1 => 'LOCATION'
2010: ,p_value_1 => 'xla_aad_upload_pvt.populate_analytical_criteria'
2011: ,p_token_2 => 'ERROR'
2012: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
2013: RAISE;
2014:

Line 2516: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_adrs',

2512: l_exception := sqlerrm; --Bug 16208537
2513: l_excp_code := sqlcode;
2514:
2515: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2516: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_adrs',
2517: p_module => l_log_module,
2518: p_level => C_LEVEL_PROCEDURE);
2519: END IF;
2520:

Line 2522: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_adrs is : '||l_excp_code||'-'||l_exception,

2518: p_level => C_LEVEL_PROCEDURE);
2519: END IF;
2520:
2521: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2522: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_adrs is : '||l_excp_code||'-'||l_exception,
2523: p_module => l_log_module,
2524: p_level => C_LEVEL_PROCEDURE);
2525: END IF;
2526:

Line 2532: ,p_value_1 => 'xla_aad_upload_pvt.populate_adrs'

2528: xla_aad_loader_util_pvt.stack_error
2529: (p_appli_s_name => 'XLA'
2530: ,p_msg_name => 'XLA_COMMON_ERROR'
2531: ,p_token_1 => 'LOCATION'
2532: ,p_value_1 => 'xla_aad_upload_pvt.populate_adrs'
2533: ,p_token_2 => 'ERROR'
2534: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
2535: RAISE;
2536:

Line 2852: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_journal_line_types',

2848: l_exception := sqlerrm; --Bug 16208537
2849: l_excp_code := sqlcode;
2850:
2851: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2852: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_journal_line_types',
2853: p_module => l_log_module,
2854: p_level => C_LEVEL_PROCEDURE);
2855: END IF;
2856:

Line 2858: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_journal_line_types is : '||l_excp_code||'-'||l_exception,

2854: p_level => C_LEVEL_PROCEDURE);
2855: END IF;
2856:
2857: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2858: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_journal_line_types is : '||l_excp_code||'-'||l_exception,
2859: p_module => l_log_module,
2860: p_level => C_LEVEL_PROCEDURE);
2861: END IF;
2862:

Line 2867: ,p_value_1 => 'xla_aad_upload_pvt.populate_journal_line_types'

2863: xla_aad_loader_util_pvt.stack_error
2864: (p_appli_s_name => 'XLA'
2865: ,p_msg_name => 'XLA_COMMON_ERROR'
2866: ,p_token_1 => 'LOCATION'
2867: ,p_value_1 => 'xla_aad_upload_pvt.populate_journal_line_types'
2868: ,p_token_2 => 'ERROR'
2869: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
2870: RAISE;
2871:

Line 3469: trace(p_msg => 'In exception of xla_aad_upload_pvt.procedure populate_jlds',

3465: l_exception := sqlerrm; --Bug 16208537
3466: l_excp_code := sqlcode;
3467:
3468: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3469: trace(p_msg => 'In exception of xla_aad_upload_pvt.procedure populate_jlds',
3470: p_module => l_log_module,
3471: p_level => C_LEVEL_PROCEDURE);
3472: END IF;
3473:

Line 3475: trace(p_msg => 'Error in xla_aad_upload_pvt.procedure populate_jlds is :'||l_excp_code||'-'||l_exception,

3471: p_level => C_LEVEL_PROCEDURE);
3472: END IF;
3473:
3474: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3475: trace(p_msg => 'Error in xla_aad_upload_pvt.procedure populate_jlds is :'||l_excp_code||'-'||l_exception,
3476: p_module => l_log_module,
3477: p_level => C_LEVEL_PROCEDURE);
3478: END IF;
3479:

Line 3484: ,p_value_1 => 'xla_aad_upload_pvt.populate_jlds'

3480: xla_aad_loader_util_pvt.stack_error
3481: (p_appli_s_name => 'XLA'
3482: ,p_msg_name => 'XLA_COMMON_ERROR'
3483: ,p_token_1 => 'LOCATION'
3484: ,p_value_1 => 'xla_aad_upload_pvt.populate_jlds'
3485: ,p_token_2 => 'ERROR'
3486: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
3487: RAISE;
3488:

Line 3869: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_aads',

3865: l_exception := sqlerrm; --Bug 16208537
3866: l_excp_code := sqlcode;
3867:
3868: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3869: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_aads',
3870: p_module => l_log_module,
3871: p_level => C_LEVEL_PROCEDURE);
3872: END IF;
3873:

Line 3875: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_aads is : '||l_excp_code||'-'||l_exception,

3871: p_level => C_LEVEL_PROCEDURE);
3872: END IF;
3873:
3874: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3875: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_aads is : '||l_excp_code||'-'||l_exception,
3876: p_module => l_log_module,
3877: p_level => C_LEVEL_PROCEDURE);
3878: END IF;
3879:

Line 3884: ,p_value_1 => 'xla_aad_upload_pvt.populate_aads'

3880: xla_aad_loader_util_pvt.stack_error
3881: (p_appli_s_name => 'XLA'
3882: ,p_msg_name => 'XLA_COMMON_ERROR'
3883: ,p_token_1 => 'LOCATION'
3884: ,p_value_1 => 'xla_aad_upload_pvt.populate_aads'
3885: ,p_token_2 => 'ERROR'
3886: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
3887: RAISE;
3888:

Line 4034: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_acctg_methods',

4030: l_exception := sqlerrm; --Bug 16208537
4031: l_excp_code := sqlcode;
4032:
4033: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4034: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_acctg_methods',
4035: p_module => l_log_module,
4036: p_level => C_LEVEL_PROCEDURE);
4037: END IF;
4038:

Line 4040: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_acctg_methods is : '||l_excp_code||'-'||l_exception,

4036: p_level => C_LEVEL_PROCEDURE);
4037: END IF;
4038:
4039: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4040: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_acctg_methods is : '||l_excp_code||'-'||l_exception,
4041: p_module => l_log_module,
4042: p_level => C_LEVEL_PROCEDURE);
4043: END IF;
4044:

Line 4049: ,p_value_1 => 'xla_aad_upload_pvt.populate_acctg_methods'

4045: xla_aad_loader_util_pvt.stack_error
4046: (p_appli_s_name => 'XLA'
4047: ,p_msg_name => 'XLA_COMMON_ERROR'
4048: ,p_token_1 => 'LOCATION'
4049: ,p_value_1 => 'xla_aad_upload_pvt.populate_acctg_methods'
4050: ,p_token_2 => 'ERROR'
4051: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
4052: RAISE;
4053:

Line 4143: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_history',

4139: l_exception := sqlerrm; -- --Bug 16208537
4140: l_excp_code := sqlcode;
4141:
4142: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4143: trace(p_msg => 'In exception of xla_aad_upload_pvt.populate_history',
4144: p_module => l_log_module,
4145: p_level => C_LEVEL_PROCEDURE);
4146: END IF;
4147:

Line 4149: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_history is : '||l_excp_code||'-'||l_exception,

4145: p_level => C_LEVEL_PROCEDURE);
4146: END IF;
4147:
4148: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4149: trace(p_msg => 'Error in xla_aad_upload_pvt.populate_history is : '||l_excp_code||'-'||l_exception,
4150: p_module => l_log_module,
4151: p_level => C_LEVEL_PROCEDURE);
4152: END IF;
4153:

Line 4158: ,p_value_1 => 'xla_aad_upload_pvt.populate_history'

4154: xla_aad_loader_util_pvt.stack_error
4155: (p_appli_s_name => 'XLA'
4156: ,p_msg_name => 'XLA_COMMON_ERROR'
4157: ,p_token_1 => 'LOCATION'
4158: ,p_value_1 => 'xla_aad_upload_pvt.populate_history'
4159: ,p_token_2 => 'ERROR'
4160: ,p_value_2 => l_excp_code ||' - '|| l_exception); --Bug 16208537
4161: RAISE;
4162: END populate_history;

Line 4334: ,p_value_1 => 'xla_aad_upload_pvt.populate_data'

4330: xla_aad_loader_util_pvt.stack_error
4331: (p_appli_s_name => 'XLA'
4332: ,p_msg_name => 'XLA_COMMON_ERROR'
4333: ,p_token_1 => 'LOCATION'
4334: ,p_value_1 => 'xla_aad_upload_pvt.populate_data'
4335: ,p_token_2 => 'ERROR'
4336: ,p_value_2 => sqlcode ||' - '|| sqlerrm); --Bug 16208537
4337: RAISE;
4338:

Line 4410: ,p_value_1 => 'xla_aad_upload_pvt.post_upload'

4406: xla_aad_loader_util_pvt.stack_error
4407: (p_appli_s_name => 'XLA'
4408: ,p_msg_name => 'XLA_COMMON_ERROR'
4409: ,p_token_1 => 'LOCATION'
4410: ,p_value_1 => 'xla_aad_upload_pvt.post_upload'
4411: ,p_token_2 => 'ERROR'
4412: ,p_value_2 => sqlcode ||' - '|| sqlerrm); --Bug 16208537
4413: RETURN 'ERROR';
4414:

Line 4518: ,p_value_1 => 'xla_aad_upload_pvt.upload'

4514: xla_aad_loader_util_pvt.stack_error
4515: (p_appli_s_name => 'XLA'
4516: ,p_msg_name => 'XLA_COMMON_ERROR'
4517: ,p_token_1 => 'LOCATION'
4518: ,p_value_1 => 'xla_aad_upload_pvt.upload'
4519: ,p_token_2 => 'ERROR'
4520: ,p_value_2 => sqlcode ||' - '||sqlerrm); --Bug 16208537
4521: END upload;
4522:

Line 4539: END xla_aad_upload_pvt;

4535: IF NOT g_log_enabled THEN
4536: g_log_level := C_LEVEL_LOG_DISABLED;
4537: END IF;
4538:
4539: END xla_aad_upload_pvt;