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_ACCT_SETUP_PKG dependencies on XLA_ACCT_SETUP_PKG

Line 1: PACKAGE BODY xla_acct_setup_pkg AS

1: PACKAGE BODY xla_acct_setup_pkg AS
2: -- $Header: xlasuaoi.pkb 120.17.12000000.2 2007/07/24 15:22:31 jlarre ship $
3: /*===========================================================================+
4: | Copyright (c) 1995-2002 Oracle Corporation |
5: | Redwood Shores, CA, USA |

Line 9: | xla_acct_setup_pkg |

5: | Redwood Shores, CA, USA |
6: | All rights reserved. |
7: +============================================================================+
8: | PACKAGE NAME |
9: | xla_acct_setup_pkg |
10: | |
11: | DESCRIPTION |
12: | XLA Accounting Options Setup |
13: | The package defaults values for the accounting setup options. |

Line 191: trace('> xla_acct_setup_pkg.setup_ledger_options' , 10);

187: ,valuation_method_flag
188: FROM xla_subledgers;
189:
190: BEGIN
191: trace('> xla_acct_setup_pkg.setup_ledger_options' , 10);
192: trace('ledger_id = '||p_ledger_id , 20);
193: trace('primary_ledger_id = '||p_primary_ledger_id , 20);
194:
195: ----------------------------------------------------------------------------

Line 223: trace('< xla_acct_setup_pkg.setup_ledger_options' , 10);

219: ,p_event_class_code => NULL);
220:
221: END LOOP;
222:
223: trace('< xla_acct_setup_pkg.setup_ledger_options' , 10);
224:
225: EXCEPTION
226: WHEN xla_exceptions_pkg.application_exception THEN
227: RAISE;

Line 230: (p_location => 'xla_acct_setup_pkg.setup_ledger_options');

226: WHEN xla_exceptions_pkg.application_exception THEN
227: RAISE;
228: WHEN OTHERS THEN
229: xla_exceptions_pkg.raise_message
230: (p_location => 'xla_acct_setup_pkg.setup_ledger_options');
231:
232: END setup_ledger_options;
233:
234:

Line 275: trace('> xla_acct_setup_pkg.check_acctg_method_for_ledger' , 10);

271:
272: l_pr_ledger_coa c_pr_ledger_coa%rowtype;
273:
274: BEGIN
275: trace('> xla_acct_setup_pkg.check_acctg_method_for_ledger' , 10);
276: trace('ledger_id = '||p_ledger_id , 20);
277: trace('primary_ledger_id = '||p_primary_ledger_id , 20);
278:
279: l_primary_ledger_id := p_primary_ledger_id;

Line 331: ,p_value_2 => 'xla_acct_setup_pkgcheck_acctg_method_for_ledger');

327: ,p_msg_name => 'XLA_COMMON_ERROR'
328: ,p_token_1 => 'ERROR'
329: ,p_value_1 => 'Transaction COA mismatched with ledger COA for '||l_pr_ledger_name
330: ,p_token_2 => 'LOCATION'
331: ,p_value_2 => 'xla_acct_setup_pkgcheck_acctg_method_for_ledger');
332: END IF;
333: ELSE
334: -------------------------------------------------------------------
335: -- Ledger is secondary, so check the chart of accounts of primary

Line 371: ,p_value_2 => 'xla_acct_setup_pkgcheck_acctg_method_for_ledger');

367: ,p_msg_name => 'XLA_COMMON_ERROR'
368: ,p_token_1 => 'ERROR'
369: ,p_value_1 => 'Transaction COA mismatched with the primary ledger COA for '||l_ledger_name
370: ,p_token_2 => 'LOCATION'
371: ,p_value_2 => 'xla_acct_setup_pkgcheck_acctg_method_for_ledger');
372: END IF;
373: END IF;
374: END IF;
375: END IF;

Line 378: trace('< xla_acct_setup_pkg.check_acctg_method_for_ledger' , 10);

374: END IF;
375: END IF;
376: CLOSE c_ledger;
377:
378: trace('< xla_acct_setup_pkg.check_acctg_method_for_ledger' , 10);
379:
380: EXCEPTION
381: WHEN xla_exceptions_pkg.application_exception THEN
382: IF c_ledger%ISOPEN THEN

Line 403: (p_location => 'xla_acct_setup_pkg.check_acctg_method_for_ledger');

399: IF c_pr_ledger_coa%ISOPEN THEN
400: CLOSE c_pr_ledger_coa;
401: END IF;
402: xla_exceptions_pkg.raise_message
403: (p_location => 'xla_acct_setup_pkg.check_acctg_method_for_ledger');
404: END check_acctg_method_for_ledger;
405:
406:
407:

Line 430: trace('> xla_acct_setup_pkg.perform_event_class_setup' , 10);

426: ORDER BY xlr.ledger_category_code;
427: l_valutation_method_flag VARCHAR2(1);
428:
429: BEGIN
430: trace('> xla_acct_setup_pkg.perform_event_class_setup' , 10);
431: trace('p_event_class_code = '||p_event_class_code , 20);
432: trace('p_application_id = '||p_application_id , 20);
433:
434: SELECT valuation_method_flag

Line 473: trace('< xla_acct_setup_pkg.perform_event_class_setup' , 10);

469: ,p_event_class_code => p_event_class_code);
470: END IF;
471:
472: END LOOP;
473: trace('< xla_acct_setup_pkg.perform_event_class_setup' , 10);
474: EXCEPTION
475: WHEN xla_exceptions_pkg.application_exception THEN
476: RAISE;
477: WHEN OTHERS THEN

Line 479: (p_location => 'xla_acct_setup_pkg.perform_event_class_setup');

475: WHEN xla_exceptions_pkg.application_exception THEN
476: RAISE;
477: WHEN OTHERS THEN
478: xla_exceptions_pkg.raise_message
479: (p_location => 'xla_acct_setup_pkg.perform_event_class_setup');
480: END perform_event_class_setup;
481:
482:
483: --=============================================================================

Line 492: trace('> xla_acct_setup_pkg.delete_event_class_setup' , 10);

488: PROCEDURE delete_event_class_setup
489: (p_application_id IN NUMBER
490: ,p_event_class_code IN VARCHAR2) IS
491: BEGIN
492: trace('> xla_acct_setup_pkg.delete_event_class_setup' , 10);
493: trace('p_event_class_code = '||p_event_class_code , 20);
494: trace('p_application_id = '||p_application_id , 20);
495:
496: ----------------------------------------------------------------------------

Line 504: trace('< xla_acct_setup_pkg.delete_event_class_setup' , 10);

500: WHERE application_id = p_application_id
501: AND event_class_code = p_event_class_code;
502: trace('Number of rows deleted = '||SQL%ROWCOUNT , 40);
503:
504: trace('< xla_acct_setup_pkg.delete_event_class_setup' , 10);
505: EXCEPTION
506: WHEN xla_exceptions_pkg.application_exception THEN
507: RAISE;
508: WHEN OTHERS THEN

Line 510: (p_location => 'xla_acct_setup_pkg.delete_event_class_setup');

506: WHEN xla_exceptions_pkg.application_exception THEN
507: RAISE;
508: WHEN OTHERS THEN
509: xla_exceptions_pkg.raise_message
510: (p_location => 'xla_acct_setup_pkg.delete_event_class_setup');
511: END delete_event_class_setup;
512:
513:
514:

Line 541: xla_utility_pkg.activate('SRS_DBP', 'xla_acct_setup_pkg.perform_application_setup_cp');

537: WHERE application_id = NVL(p_application_id,application_id);
538:
539: l_sysdate DATE;
540: BEGIN
541: xla_utility_pkg.activate('SRS_DBP', 'xla_acct_setup_pkg.perform_application_setup_cp');
542:
543: trace('> xla_acct_setup_pkg.perform_application_setup_cp', 20);
544: trace('p_application_id = '||p_application_id,20);
545:

Line 543: trace('> xla_acct_setup_pkg.perform_application_setup_cp', 20);

539: l_sysdate DATE;
540: BEGIN
541: xla_utility_pkg.activate('SRS_DBP', 'xla_acct_setup_pkg.perform_application_setup_cp');
542:
543: trace('> xla_acct_setup_pkg.perform_application_setup_cp', 20);
544: trace('p_application_id = '||p_application_id,20);
545:
546: xla_environment_pkg.refresh;
547:

Line 784: trace('< xla_acct_setup_pkg.perform_application_setup_cp', 20);

780: ----------------------------------------------------------------------------
781: p_retcode := 0;
782: p_errbuf := NULL;
783:
784: trace('< xla_acct_setup_pkg.perform_application_setup_cp', 20);
785: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
786: EXCEPTION
787: WHEN xla_exceptions_pkg.application_exception THEN
788: ----------------------------------------------------------------------------

Line 785: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');

781: p_retcode := 0;
782: p_errbuf := NULL;
783:
784: trace('< xla_acct_setup_pkg.perform_application_setup_cp', 20);
785: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
786: EXCEPTION
787: WHEN xla_exceptions_pkg.application_exception THEN
788: ----------------------------------------------------------------------------
789: -- set out variables

Line 795: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);

791: p_retcode := 2;
792: p_errbuf := xla_messages_pkg.get_message;
793:
794: xla_utility_pkg.print_logfile(p_errbuf);
795: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);
796: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
797: WHEN OTHERS THEN
798: ----------------------------------------------------------------------------
799: -- set out variables

Line 796: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');

792: p_errbuf := xla_messages_pkg.get_message;
793:
794: xla_utility_pkg.print_logfile(p_errbuf);
795: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);
796: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
797: WHEN OTHERS THEN
798: ----------------------------------------------------------------------------
799: -- set out variables
800: ----------------------------------------------------------------------------

Line 805: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);

801: p_retcode := 2;
802: p_errbuf := sqlerrm;
803:
804: xla_utility_pkg.print_logfile(p_errbuf);
805: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);
806: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
807: END perform_application_setup_cp;
808:
809:

Line 806: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');

802: p_errbuf := sqlerrm;
803:
804: xla_utility_pkg.print_logfile(p_errbuf);
805: trace('< xla_acct_setup_pkg.perform_application_setup_cp (exception)', 20);
806: xla_utility_pkg.deactivate('xla_acct_setup_pkg.perform_application_setup_cp');
807: END perform_application_setup_cp;
808:
809:
810:

Line 865: trace('> xla_acct_setup_pkg.insert_launch_options' , 10);

861: WHERE application_id = p_application_id
862: AND ledger_id = p_ledger_id;
863:
864: BEGIN
865: trace('> xla_acct_setup_pkg.insert_launch_options' , 10);
866: trace('ledger_id = '||p_ledger_id , 20);
867: trace('application_id = '||p_application_id , 20);
868:
869: OPEN c_launch_options;

Line 915: trace('< xla_acct_setup_pkg.insert_launch_options' , 10);

911: END IF;
912:
913: CLOSE c_launch_options;
914:
915: trace('< xla_acct_setup_pkg.insert_launch_options' , 10);
916: EXCEPTION
917: WHEN xla_exceptions_pkg.application_exception THEN
918: IF c_launch_options%ISOPEN THEN
919: CLOSE c_launch_options;

Line 927: (p_location => 'xla_acct_setup_pkg.insert_launch_options');

923: IF c_launch_options%ISOPEN THEN
924: CLOSE c_launch_options;
925: END IF;
926: xla_exceptions_pkg.raise_message
927: (p_location => 'xla_acct_setup_pkg.insert_launch_options');
928: END insert_launch_options;
929:
930:
931: --=============================================================================

Line 948: trace('> xla_acct_setup_pkg.insert_ledger_options' , 10);

944: WHERE application_id = p_application_id
945: AND ledger_id = p_ledger_id;
946:
947: BEGIN
948: trace('> xla_acct_setup_pkg.insert_ledger_options' , 10);
949: trace('ledger_id = '||p_ledger_id , 20);
950: trace('application_id = '||p_application_id , 20);
951:
952: OPEN c_ledger_options;

Line 1001: trace('< xla_acct_setup_pkg.insert_ledger_options' , 10);

997: );
998: END IF;
999: CLOSE c_ledger_options;
1000:
1001: trace('< xla_acct_setup_pkg.insert_ledger_options' , 10);
1002: EXCEPTION
1003: WHEN xla_exceptions_pkg.application_exception THEN
1004: IF c_ledger_options%ISOPEN THEN
1005: CLOSE c_ledger_options;

Line 1013: (p_location => 'xla_acct_setup_pkg.insert_ledger_options');

1009: IF c_ledger_options%ISOPEN THEN
1010: CLOSE c_ledger_options;
1011: END IF;
1012: xla_exceptions_pkg.raise_message
1013: (p_location => 'xla_acct_setup_pkg.insert_ledger_options');
1014: END insert_ledger_options;
1015:
1016:
1017: --=============================================================================

Line 1040: trace('> xla_acct_setup_pkg.insert_je_category' , 10);

1036: WHERE xjc.application_id = p_application_id
1037: AND xjc.ledger_id = p_ledger_id);
1038:
1039: BEGIN
1040: trace('> xla_acct_setup_pkg.insert_je_category' , 10);
1041: trace('p_ledger_id = '||p_ledger_id , 20);
1042: trace('p_application_id = '||p_application_id , 20);
1043: trace('p_event_class_code = '||p_event_class_code , 20);
1044:

Line 1070: trace('< xla_acct_setup_pkg.insert_je_category' , 10);

1066: ,xla_environment_pkg.g_usr_id
1067: ,xla_environment_pkg.g_login_id);
1068: END LOOP;
1069:
1070: trace('< xla_acct_setup_pkg.insert_je_category' , 10);
1071:
1072: EXCEPTION
1073: WHEN xla_exceptions_pkg.application_exception THEN
1074: RAISE;

Line 1077: (p_location => 'xla_acct_setup_pkg.insert_je_category');

1073: WHEN xla_exceptions_pkg.application_exception THEN
1074: RAISE;
1075: WHEN OTHERS THEN
1076: xla_exceptions_pkg.raise_message
1077: (p_location => 'xla_acct_setup_pkg.insert_je_category');
1078: END insert_je_category;
1079:
1080:
1081: --=============================================================================

Line 1101: trace('> xla_acct_setup_pkg.check_primary_ledger_options' , 10);

1097: WHERE application_id = p_application_id
1098: AND ledger_id = p_primary_ledger_id;
1099:
1100: BEGIN
1101: trace('> xla_acct_setup_pkg.check_primary_ledger_options' , 10);
1102: trace('primary_ledger_id = '||p_primary_ledger_id , 20);
1103: trace('application_id = '||p_application_id , 20);
1104:
1105: l_application_id := p_application_id;

Line 1131: trace('< xla_acct_setup_pkg.check_primary_ledger_options' , 10);

1127:
1128: END IF;
1129: CLOSE c_launch_options;
1130:
1131: trace('< xla_acct_setup_pkg.check_primary_ledger_options' , 10);
1132:
1133: EXCEPTION
1134: WHEN xla_exceptions_pkg.application_exception THEN
1135: IF c_launch_options%ISOPEN THEN

Line 1144: (p_location => 'xla_acct_setup_pkg.check_primary_ledger_options');

1140: IF c_launch_options%ISOPEN THEN
1141: CLOSE c_launch_options;
1142: END IF;
1143: xla_exceptions_pkg.raise_message
1144: (p_location => 'xla_acct_setup_pkg.check_primary_ledger_options');
1145: END check_primary_ledger_options;
1146:
1147:
1148: --=============================================================================

Line 1172: trace('> xla_acct_setup_pkg.check_ledger_currency' , 10);

1168: FROM xla_gl_ledgers_v
1169: WHERE ledger_id = p_ledger_id;
1170:
1171: BEGIN
1172: trace('> xla_acct_setup_pkg.check_ledger_currency' , 10);
1173: trace('primary_ledger_id = '||p_primary_ledger_id , 20);
1174: trace('ledger_id = '||p_ledger_id , 20);
1175:
1176: l_primary_ledger_id := p_primary_ledger_id;

Line 1195: trace('< xla_acct_setup_pkg.check_ledger_currency' , 10);

1191: ELSE
1192: l_return := TRUE;
1193: END IF;
1194:
1195: trace('< xla_acct_setup_pkg.check_ledger_currency' , 10);
1196:
1197: RETURN l_return;
1198:
1199: EXCEPTION

Line 1204: (p_location => 'xla_acct_setup_pkg.check_ledger_currency');

1200: WHEN xla_exceptions_pkg.application_exception THEN
1201: RAISE;
1202: WHEN OTHERS THEN
1203: xla_exceptions_pkg.raise_message
1204: (p_location => 'xla_acct_setup_pkg.check_ledger_currency');
1205: END check_ledger_currency;
1206:
1207:
1208: --=============================================================================

Line 1221: trace('> xla_acct_setup_pkg.setup_options' , 10);

1217: ,p_application_id IN NUMBER
1218: ,p_valuation_method_flag IN VARCHAR2
1219: ,p_event_class_code IN VARCHAR2) IS
1220: BEGIN
1221: trace('> xla_acct_setup_pkg.setup_options' , 10);
1222: trace('p_ledger_id = '||p_ledger_id , 20);
1223: trace('p_primary_ledger_id = '||p_primary_ledger_id , 20);
1224: trace('p_application_id = '||p_application_id , 20);
1225:

Line 1300: trace('< xla_acct_setup_pkg.setup_options' , 10);

1296: ,p_event_class_code => p_event_class_code);
1297: END IF;
1298:
1299:
1300: trace('< xla_acct_setup_pkg.setup_options' , 10);
1301:
1302: EXCEPTION
1303: WHEN xla_exceptions_pkg.application_exception THEN
1304: RAISE;

Line 1307: (p_location => 'xla_acct_setup_pkg.setup_options');

1303: WHEN xla_exceptions_pkg.application_exception THEN
1304: RAISE;
1305: WHEN OTHERS THEN
1306: xla_exceptions_pkg.raise_message
1307: (p_location => 'xla_acct_setup_pkg.setup_options');
1308: END setup_options;
1309:
1310:
1311:

Line 1319: trace('> xla_acct_setup_pkg.set_default_values' , 10);

1315: --
1316: --=============================================================================
1317: PROCEDURE set_default_values IS
1318: BEGIN
1319: trace('> xla_acct_setup_pkg.set_default_values' , 10);
1320:
1321: g_accounting_mode_code := 'F';
1322: g_acctg_mode_override_flag := 'Y';
1323: g_summary_report_flag := 'N';

Line 1348: trace('< xla_acct_setup_pkg.set_default_values' , 10);

1344: g_transfer_to_gl_mode_code := NULL;
1345: g_acct_reversal_option_code := 'SIDE';
1346: g_enabled_flag := 'Y';
1347:
1348: trace('< xla_acct_setup_pkg.set_default_values' , 10);
1349: EXCEPTION
1350: WHEN xla_exceptions_pkg.application_exception THEN
1351: RAISE;
1352: WHEN OTHERS THEN

Line 1354: (p_location => 'xla_acct_setup_pkg.set_default_values');

1350: WHEN xla_exceptions_pkg.application_exception THEN
1351: RAISE;
1352: WHEN OTHERS THEN
1353: xla_exceptions_pkg.raise_message
1354: (p_location => 'xla_acct_setup_pkg.set_default_values');
1355: END set_default_values;
1356:
1357:
1358:

Line 1382: trace('> xla_acct_setup_pkg.upgrade_ledger_options' , 10);

1378: ,p_processing_unit_size IN NUMBER
1379: ,p_transfer_to_gl_mode_code IN VARCHAR2
1380: ,p_acct_reversal_option_code IN VARCHAR2) IS
1381: BEGIN
1382: trace('> xla_acct_setup_pkg.upgrade_ledger_options' , 10);
1383: trace('ledger_id = '||p_ledger_id , 20);
1384: trace('p_application_id = '||p_application_id , 20);
1385:
1386: ----------------------------------------------------------------------------

Line 1611: trace('< xla_acct_setup_pkg.upgrade_ledger_options' , 10);

1607: ,p_value_2 => 'Either the application is not registered or '||
1608: 'setups are missing for the ledger and application');
1609: END IF;
1610:
1611: trace('< xla_acct_setup_pkg.upgrade_ledger_options' , 10);
1612:
1613: EXCEPTION
1614: WHEN xla_exceptions_pkg.application_exception THEN
1615: RAISE;

Line 1618: (p_location => 'xla_acct_setup_pkg.upgrade_ledger_options');

1614: WHEN xla_exceptions_pkg.application_exception THEN
1615: RAISE;
1616: WHEN OTHERS THEN
1617: xla_exceptions_pkg.raise_message
1618: (p_location => 'xla_acct_setup_pkg.upgrade_ledger_options');
1619: END upgrade_ledger_options;
1620:
1621:
1622: --=============================================================================

Line 1652: END xla_acct_setup_pkg;

1648: BEGIN
1649: g_debug_flag := NVL(fnd_profile.value('XLA_DEBUG_TRACE'),'N');
1650:
1651:
1652: END xla_acct_setup_pkg;