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_JOURNAL_ENTRIES_PKG dependencies on XLA_EXCEPTIONS_PKG

Line 100: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);

96: PROCEDURE validate_line_number
97: (p_header_id IN INTEGER
98: ,p_line_num IN INTEGER
99: ,p_application_id IN INTEGER
100: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);
101:
102: PROCEDURE validate_display_line_number
103: (p_header_id IN INTEGER
104: ,p_line_num IN INTEGER

Line 107: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);

103: (p_header_id IN INTEGER
104: ,p_line_num IN INTEGER
105: ,p_display_line_num IN INTEGER
106: ,p_application_id IN INTEGER
107: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);
108:
109: PROCEDURE validate_ae_type_code
110: (p_accounting_entry_type_code IN VARCHAR2
111: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);

Line 111: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);

107: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);
108:
109: PROCEDURE validate_ae_type_code
110: (p_accounting_entry_type_code IN VARCHAR2
111: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);
112:
113: PROCEDURE validate_ae_status_code
114: (p_status_code IN VARCHAR2
115: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);

Line 115: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);

111: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);
112:
113: PROCEDURE validate_ae_status_code
114: (p_status_code IN VARCHAR2
115: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);
116:
117: /*
118: FUNCTION unreserve_funds
119: (p_ae_header_id IN INTEGER

Line 123: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

119: (p_ae_header_id IN INTEGER
120: ,p_application_id IN INTEGER
121: ,p_ledger_id IN INTEGER
122: ,p_packet_id IN INTEGER
123: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
124: RETURN BOOLEAN;
125: */
126:
127: FUNCTION validate_completion_action

Line 191: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE

187: ,p_last_updated_by OUT NOCOPY INTEGER
188: ,p_last_update_login OUT NOCOPY INTEGER
189: ,p_transfer_request_id OUT NOCOPY INTEGER
190: ,p_retcode OUT NOCOPY VARCHAR2
191: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE
192: ,p_context IN VARCHAR2 DEFAULT NULL --added bug 10226301
193: ,p_rev_flag IN VARCHAR2 DEFAULT 'N'
194: ,p_rev_method IN VARCHAR2 DEFAULT 'N'
195: ,p_rev_orig_event_id IN NUMBER DEFAULT -1);

Line 242: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);

238: ,p_msg_mode IN VARCHAR2);
239:
240: PROCEDURE validate_balance_type_code
241: (p_balance_type_code IN VARCHAR2
242: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);
243:
244: FUNCTION validate_description
245: (p_entity_id IN INTEGER
246: ,p_event_id IN INTEGER

Line 290: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);

286:
287: PROCEDURE validate_code_combination_id
288: (p_line_num IN INTEGER
289: ,p_code_combination_id IN INTEGER
290: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE);
291:
292: FUNCTION validate_lines
293: (p_entity_id IN INTEGER
294: ,p_event_id IN INTEGER

Line 515: WHEN xla_exceptions_pkg.application_exception THEN

511: fnd_log.string(p_level, p_module, p_msg);
512: END IF;
513:
514: EXCEPTION
515: WHEN xla_exceptions_pkg.application_exception THEN
516: RAISE;
517:
518: WHEN OTHERS THEN
519: xla_exceptions_pkg.raise_message

Line 519: xla_exceptions_pkg.raise_message

515: WHEN xla_exceptions_pkg.application_exception THEN
516: RAISE;
517:
518: WHEN OTHERS THEN
519: xla_exceptions_pkg.raise_message
520: (p_location => 'xla_journal_entries_pkg.trace');
521: END trace;
522:
523: --=============================================================================

Line 602: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

598: ,p_last_update_date OUT NOCOPY DATE
599: ,p_last_updated_by OUT NOCOPY INTEGER
600: ,p_last_update_login OUT NOCOPY INTEGER
601: ,p_retcode OUT NOCOPY INTEGER
602: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
603: IS
604: CURSOR c IS
605: SELECT enable_budgetary_control_flag
606: FROM gl_ledgers

Line 672: WHEN xla_exceptions_pkg.application_exception THEN

668: p_level => C_LEVEL_PROCEDURE);
669: END IF;
670:
671: EXCEPTION
672: WHEN xla_exceptions_pkg.application_exception THEN
673: ROLLBACK;
674: RAISE;
675:
676: WHEN OTHERS THEN

Line 678: xla_exceptions_pkg.raise_message

674: RAISE;
675:
676: WHEN OTHERS THEN
677: ROLLBACK;
678: xla_exceptions_pkg.raise_message
679: (p_location => 'xla_journal_entries_pkg.create_journal_entry_header');
680:
681: END create_journal_entry_header;
682:

Line 728: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

724: ,p_last_update_date OUT NOCOPY DATE
725: ,p_last_updated_by OUT NOCOPY INTEGER
726: ,p_last_update_login OUT NOCOPY INTEGER
727: ,p_retcode OUT NOCOPY INTEGER
728: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
729: IS
730:
731: l_event_source_info xla_events_pub_pkg.t_event_source_info;
732: l_entity_id INTEGER;

Line 807: xla_exceptions_pkg.raise_message

803: ,p_closing_status => l_closing_status
804: ,p_period_type => l_period_type);
805:
806: IF (p_period_name IS NULL) THEN
807: xla_exceptions_pkg.raise_message
808: (p_appli_s_name => 'XLA'
809: ,p_msg_name => 'XLA_AP_INVALID_GL_DATE'
810: ,p_token_1 => 'GL_DATE'
811: ,p_value_1 => to_char(p_gl_date,'DD-MON-YYYY')

Line 923: WHEN xla_exceptions_pkg.application_exception THEN

919: p_level => C_LEVEL_PROCEDURE);
920: END IF;
921:
922: EXCEPTION
923: WHEN xla_exceptions_pkg.application_exception THEN
924: ROLLBACK;
925: RAISE;
926:
927: WHEN OTHERS THEN

Line 929: xla_exceptions_pkg.raise_message

925: RAISE;
926:
927: WHEN OTHERS THEN
928: ROLLBACK;
929: xla_exceptions_pkg.raise_message
930: (p_location => 'xla_journal_entries_pkg.create_journal_entry_header');
931:
932: END create_journal_entry_header;
933:

Line 974: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

970: ,p_last_update_date OUT NOCOPY DATE
971: ,p_last_updated_by OUT NOCOPY INTEGER
972: ,p_last_update_login OUT NOCOPY INTEGER
973: ,p_retcode OUT NOCOPY INTEGER
974: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
975: IS
976: l_info t_je_info;
977: l_status_code VARCHAR2(30) := C_AE_STATUS_INCOMPLETE;
978: l_closing_status VARCHAR2(30);

Line 1030: xla_exceptions_pkg.raise_message

1026: ,p_closing_status => l_closing_status
1027: ,p_period_type => l_period_type);
1028:
1029: IF (p_period_name IS NULL) THEN
1030: xla_exceptions_pkg.raise_message
1031: (p_appli_s_name => 'XLA'
1032: ,p_msg_name => 'XLA_AP_INVALID_GL_DATE'
1033: ,p_token_1 => 'GL_DATE'
1034: ,p_value_1 => to_char(p_gl_date,'DD-MON-YYYY')

Line 1134: WHEN xla_exceptions_pkg.application_exception THEN

1130: p_level => C_LEVEL_PROCEDURE);
1131: END IF;
1132:
1133: EXCEPTION
1134: WHEN xla_exceptions_pkg.application_exception THEN
1135: ROLLBACK;
1136: RAISE;
1137: WHEN OTHERS THEN
1138: ROLLBACK;

Line 1139: xla_exceptions_pkg.raise_message

1135: ROLLBACK;
1136: RAISE;
1137: WHEN OTHERS THEN
1138: ROLLBACK;
1139: xla_exceptions_pkg.raise_message
1140: (p_location => 'xla_journal_entries_pkg.update_journal_entry_header');
1141:
1142: END update_journal_entry_header;
1143:

Line 1155: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

1151: PROCEDURE delete_journal_entry
1152: (p_ae_header_id IN INTEGER
1153: ,p_application_id IN INTEGER
1154: ,p_mode IN VARCHAR2 DEFAULT C_DELETE_NORMAL_MODE
1155: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
1156: IS
1157: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1158: l_info t_je_info;
1159: l_log_module VARCHAR2(240);

Line 1204: WHEN xla_exceptions_pkg.application_exception THEN

1200: p_module => l_log_module,
1201: p_level => C_LEVEL_PROCEDURE);
1202: END IF;
1203: EXCEPTION
1204: WHEN xla_exceptions_pkg.application_exception THEN
1205: ROLLBACK;
1206: RAISE;
1207:
1208: WHEN OTHERS THEN

Line 1210: xla_exceptions_pkg.raise_message

1206: RAISE;
1207:
1208: WHEN OTHERS THEN
1209: ROLLBACK;
1210: xla_exceptions_pkg.raise_message
1211: (p_location => 'xla_journal_entries_pkg.update_journal_entry_header');
1212:
1213: END delete_journal_entry;
1214:

Line 1285: xla_exceptions_pkg.raise_message

1281: --
1282: OPEN c_period;
1283: IF (c_period%FOUND) THEN
1284: CLOSE c_period;
1285: xla_exceptions_pkg.raise_message
1286: (p_appli_s_name => 'XLA'
1287: ,p_msg_name => 'XLA_MJE_CANT_DEL_CLOSED_PERIOD'
1288: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);
1289: END IF;

Line 1288: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);

1284: CLOSE c_period;
1285: xla_exceptions_pkg.raise_message
1286: (p_appli_s_name => 'XLA'
1287: ,p_msg_name => 'XLA_MJE_CANT_DEL_CLOSED_PERIOD'
1288: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);
1289: END IF;
1290: CLOSE c_period;
1291:
1292: OPEN c_entries;

Line 1311: xla_exceptions_pkg.raise_message

1307: ,p_request_id => NULL
1308: ,p_accounting_batch_id => NULL
1309: ,p_update_mode => C_BALANCE_DELETE
1310: ,p_execution_mode => C_BALANCE_ONLINE)) THEN
1311: xla_exceptions_pkg.raise_message
1312: (p_appli_s_name => 'XLA'
1313: ,p_msg_name => 'XLA_INTERNAL_ERROR'
1314: ,p_token_1 => 'MESSAGE'
1315: ,p_value_1 => 'Error in balance calculation'

Line 1318: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);

1314: ,p_token_1 => 'MESSAGE'
1315: ,p_value_1 => 'Error in balance calculation'
1316: ,p_token_2 => 'LOCATION'
1317: ,p_value_2 => 'XLA_JOURNAL_ENTRIES_PKG.delete_journal_entries'
1318: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);
1319: END IF;
1320: END IF;
1321: END IF;
1322: */

Line 1364: xla_exceptions_pkg.raise_message

1360: ,p_amb_context_code => NULL
1361: ,p_update_mode => 'D')) THEN
1362: ROLLBACK to SAVEPOINT DELETE_JOURNAL_ENTRIES;
1363:
1364: xla_exceptions_pkg.raise_message
1365: (p_appli_s_name => 'XLA'
1366: ,p_msg_name => 'XLA_COMMON_INTERNAL_ERROR'
1367: ,p_token_1 => 'MESSAGE'
1368: ,p_value_1 => 'Error in xla_analytical_criteria_pkg.single_update_detail_value'

Line 1371: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);

1367: ,p_token_1 => 'MESSAGE'
1368: ,p_value_1 => 'Error in xla_analytical_criteria_pkg.single_update_detail_value'
1369: ,p_token_2 => 'LOCATION'
1370: ,p_value_2 => 'XLA_JOURNAL_ENTRIES_PKG.delete_journal_entries'
1371: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);
1372: END IF;
1373: END LOOP;
1374:
1375: FORALL k in 1..j

Line 1402: WHEN xla_exceptions_pkg.application_exception THEN

1398: p_level => C_LEVEL_PROCEDURE);
1399: END IF;
1400:
1401: EXCEPTION
1402: WHEN xla_exceptions_pkg.application_exception THEN
1403: ROLLBACK;
1404: IF (c_entries%ISOPEN) THEN
1405: CLOSE c_entries;
1406: END IF;

Line 1420: xla_exceptions_pkg.raise_message

1416: END IF;
1417: IF (c_period%ISOPEN) THEN
1418: CLOSE c_period;
1419: END IF;
1420: xla_exceptions_pkg.raise_message
1421: (p_location => 'xla_journal_entries_pkg.delete_journal_entries');
1422:
1423: END delete_journal_entries;
1424:

Line 1478: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

1474: ,p_last_update_date OUT NOCOPY DATE
1475: ,p_last_updated_by OUT NOCOPY INTEGER
1476: ,p_last_update_login OUT NOCOPY INTEGER
1477: ,p_retcode OUT NOCOPY INTEGER
1478: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
1479: IS
1480: l_info t_je_info;
1481:
1482: l_funct_curr VARCHAR2(15);

Line 1548: xla_exceptions_pkg.raise_message(

1544: ELSE
1545: l_encumbrance_type_id := p_encumbrance_type_id;
1546:
1547: IF l_encumbrance_type_id IS NULL THEN -- 5522973
1548: xla_exceptions_pkg.raise_message(
1549: p_appli_s_name => 'XLA'
1550: ,p_msg_name => 'XLA_AP_NO_ENCUM_TYPE'
1551: ,p_msg_mode => p_msg_mode);
1552: ELSE

Line 1557: xla_exceptions_pkg.raise_message(

1553: OPEN cur_enc;
1554: FETCH cur_enc INTO l_enabled, l_enc_type;
1555: IF cur_enc%NOTFOUND THEN
1556: CLOSE cur_enc;
1557: xla_exceptions_pkg.raise_message(
1558: p_appli_s_name => 'XLA'
1559: ,p_msg_name => 'XLA_AP_INVALID_ENCU_TYPE'
1560: ,p_token_1 => 'ENCUMBRANCE_TYPE_ID'
1561: ,p_value_1 => l_encumbrance_type_id

Line 1565: xla_exceptions_pkg.raise_message(

1561: ,p_value_1 => l_encumbrance_type_id
1562: ,p_msg_mode => p_msg_mode);
1563: ELSIF l_enabled = 'N' THEN
1564: CLOSE cur_enc;
1565: xla_exceptions_pkg.raise_message(
1566: p_appli_s_name => 'XLA'
1567: ,p_msg_name => 'XLA_AP_INACTIVE_ENCUM_TYPE'
1568: ,p_token_1 => 'ENCUMBRANCE_TYPE_ID'
1569: ,p_value_1 => l_enc_type

Line 1788: WHEN xla_exceptions_pkg.application_exception THEN

1784: p_level => C_LEVEL_PROCEDURE);
1785: END IF;
1786:
1787: EXCEPTION
1788: WHEN xla_exceptions_pkg.application_exception THEN
1789: ROLLBACK;
1790: IF (c%ISOPEN) THEN
1791: CLOSE c;
1792: END IF;

Line 1800: xla_exceptions_pkg.raise_message

1796: ROLLBACK;
1797: IF (c%ISOPEN) THEN
1798: CLOSE c;
1799: END IF;
1800: xla_exceptions_pkg.raise_message
1801: (p_location => 'xla_journal_entries_pkg.create_journal_entry_line');
1802:
1803: END create_journal_entry_line;
1804:

Line 1855: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

1851: ,p_last_update_date OUT NOCOPY DATE
1852: ,p_last_updated_by OUT NOCOPY INTEGER
1853: ,p_last_update_login OUT NOCOPY INTEGER
1854: ,p_retcode OUT NOCOPY INTEGER
1855: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
1856: IS
1857: l_info t_je_info;
1858:
1859: l_funct_curr VARCHAR2(15);

Line 1927: xla_exceptions_pkg.raise_message

1923: FETCH c_line INTO l_ccid_old;
1924: CLOSE c_line;
1925:
1926: IF (l_ccid_old IS NULL) THEN
1927: xla_exceptions_pkg.raise_message
1928: (p_appli_s_name => 'XLA'
1929: ,p_msg_name => 'XLA_MJE_INVALID_LINE_NUM'
1930: ,p_token_1 => 'LINE_NUM'
1931: ,p_value_1 => p_ae_line_num

Line 2103: WHEN xla_exceptions_pkg.application_exception THEN

2099: p_level => C_LEVEL_PROCEDURE);
2100: END IF;
2101:
2102: EXCEPTION
2103: WHEN xla_exceptions_pkg.application_exception THEN
2104: IF (c_line%ISOPEN) THEN
2105: CLOSE c_line;
2106: END IF;
2107: RAISE;

Line 2112: xla_exceptions_pkg.raise_message

2108: WHEN OTHERS THEN
2109: IF (c_line%ISOPEN) THEN
2110: CLOSE c_line;
2111: END IF;
2112: xla_exceptions_pkg.raise_message
2113: (p_location => 'xla_journal_entries_pkg.update_journal_entry_line');
2114:
2115: END update_journal_entry_line;
2116:

Line 2128: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

2124: PROCEDURE delete_journal_entry_line
2125: (p_ae_header_id IN INTEGER
2126: ,p_ae_line_num IN INTEGER
2127: ,p_application_id IN INTEGER
2128: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
2129: IS
2130:
2131: l_info t_je_info;
2132: l_bal_seg INTEGER;

Line 2182: xla_exceptions_pkg.raise_message

2178: ,p_amb_context_code => NULL
2179: ,p_update_mode => 'D')) THEN
2180: ROLLBACK to SAVEPOINT DELETE_JOURNAL_ENTRY;
2181:
2182: xla_exceptions_pkg.raise_message
2183: (p_appli_s_name => 'XLA'
2184: ,p_msg_name => 'XLA_COMMON_INTERNAL_ERROR'
2185: ,p_token_1 => 'MESSAGE'
2186: ,p_value_1 => 'Error in xla_analytical_criteria_pkg.single_update_detail_value'

Line 2213: WHEN xla_exceptions_pkg.application_exception THEN

2209: p_level => C_LEVEL_PROCEDURE);
2210: END IF;
2211:
2212: EXCEPTION
2213: WHEN xla_exceptions_pkg.application_exception THEN
2214: ROLLBACK;
2215: RAISE;
2216:
2217: WHEN OTHERS THEN

Line 2219: xla_exceptions_pkg.raise_message

2215: RAISE;
2216:
2217: WHEN OTHERS THEN
2218: ROLLBACK;
2219: xla_exceptions_pkg.raise_message
2220: (p_location => 'xla_journal_entries_pkg.delete_journal_entry_line');
2221:
2222: END delete_journal_entry_line;
2223:

Line 2248: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE

2244: ,p_last_updated_by OUT NOCOPY INTEGER
2245: ,p_last_update_login OUT NOCOPY INTEGER
2246: ,p_transfer_request_id OUT NOCOPY INTEGER
2247: ,p_retcode OUT NOCOPY VARCHAR2
2248: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE
2249: ,p_context IN VARCHAR2 DEFAULT NULL) --added bug 10226301
2250: IS
2251: l_log_module VARCHAR2(240);
2252: BEGIN

Line 2297: WHEN xla_exceptions_pkg.application_exception THEN

2293: p_level => C_LEVEL_PROCEDURE);
2294: END IF;
2295:
2296: EXCEPTION
2297: WHEN xla_exceptions_pkg.application_exception THEN
2298: ROLLBACK;
2299: RAISE;
2300:
2301: WHEN OTHERS THEN

Line 2303: xla_exceptions_pkg.raise_message

2299: RAISE;
2300:
2301: WHEN OTHERS THEN
2302: ROLLBACK;
2303: xla_exceptions_pkg.raise_message
2304: (p_location => 'xla_journal_entries_pkg.complete_journal_entry');
2305:
2306: END complete_journal_entry;
2307:

Line 2331: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE

2327: ,p_last_updated_by OUT NOCOPY INTEGER
2328: ,p_last_update_login OUT NOCOPY INTEGER
2329: ,p_transfer_request_id OUT NOCOPY INTEGER
2330: ,p_retcode OUT NOCOPY VARCHAR2
2331: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE
2332: ,p_context IN VARCHAR2 DEFAULT NULL --added bug 10226301
2333: ,p_rev_flag IN VARCHAR2 DEFAULT 'N'
2334: ,p_rev_method IN VARCHAR2 DEFAULT 'N'
2335: ,p_rev_orig_event_id IN NUMBER DEFAULT -1)

Line 2743: xla_exceptions_pkg.raise_message

2739: ,p_accounting_batch_id => NULL
2740: ,p_update_mode => l_bal_update_mode
2741: ,p_execution_mode => C_BALANCE_ONLINE)) THEN
2742:
2743: xla_exceptions_pkg.raise_message
2744: (p_appli_s_name => 'XLA'
2745: ,p_msg_name => 'XLA_INTERNAL_ERROR'
2746: ,p_token_1 => 'MESSAGE'
2747: ,p_value_1 => 'Error in balance calculation'

Line 2750: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);

2746: ,p_token_1 => 'MESSAGE'
2747: ,p_value_1 => 'Error in balance calculation'
2748: ,p_token_2 => 'LOCATION'
2749: ,p_value_2 => 'XLA_JOURNAL_ENTRIES_PKG.complete_journal_entry' -- Bug 13614923
2750: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);
2751: END IF;
2752: ELSE
2753: IF (NOT xla_balances_calc_pkg.massive_update
2754: (p_application_id => l_info.application_id

Line 2763: xla_exceptions_pkg.raise_message

2759: ,p_accounting_batch_id => NULL
2760: ,p_update_mode => l_bal_update_mode
2761: ,p_execution_mode => C_BALANCE_ONLINE)) THEN
2762:
2763: xla_exceptions_pkg.raise_message
2764: (p_appli_s_name => 'XLA'
2765: ,p_msg_name => 'XLA_INTERNAL_ERROR'
2766: ,p_token_1 => 'MESSAGE'
2767: ,p_value_1 => 'Error in balance calculation'

Line 2770: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);

2766: ,p_token_1 => 'MESSAGE'
2767: ,p_value_1 => 'Error in balance calculation'
2768: ,p_token_2 => 'LOCATION'
2769: ,p_value_2 => 'XLA_JOURNAL_ENTRIES_PKG.complete_journal_entry' --Bug 13614923
2770: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);
2771: END IF;
2772:
2773: END IF;
2774: END IF;

Line 2839: WHEN xla_exceptions_pkg.application_exception THEN

2835: p_module => l_log_module,
2836: p_level => C_LEVEL_PROCEDURE);
2837: END IF;
2838: EXCEPTION
2839: WHEN xla_exceptions_pkg.application_exception THEN
2840: ROLLBACK;
2841: RAISE;
2842: WHEN OTHERS THEN
2843: ROLLBACK;

Line 2844: xla_exceptions_pkg.raise_message

2840: ROLLBACK;
2841: RAISE;
2842: WHEN OTHERS THEN
2843: ROLLBACK;
2844: xla_exceptions_pkg.raise_message
2845: (p_location => 'xla_journal_entries_pkg.complete_journal_entry');
2846:
2847: END complete_journal_entry;
2848:

Line 2872: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE

2868: ,p_gl_date IN DATE
2869: ,p_completion_option IN VARCHAR2
2870: ,p_functional_curr IN VARCHAR2
2871: ,p_je_source_name IN VARCHAR2
2872: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE
2873: ,p_rev_header_id OUT NOCOPY INTEGER
2874: ,p_rev_event_id OUT NOCOPY INTEGER
2875: ,p_completion_retcode OUT NOCOPY VARCHAR2
2876: ,p_transfer_request_id OUT NOCOPY INTEGER

Line 2935: xla_exceptions_pkg.raise_message

2931: IF (p_completion_option NOT in (C_COMPLETION_OPTION_DRAFT,
2932: C_COMPLETION_OPTION_FINAL,
2933: C_COMPLETION_OPTION_TRANSFER,
2934: C_COMPLETION_OPTION_POST)) THEN
2935: xla_exceptions_pkg.raise_message
2936: (p_appli_s_name => 'XLA'
2937: ,p_msg_name => 'XLA_MJE_INVALID_COMP_OPTION'
2938: ,p_msg_mode => p_msg_mode);
2939: END IF;

Line 2942: xla_exceptions_pkg.raise_message

2938: ,p_msg_mode => p_msg_mode);
2939: END IF;
2940:
2941: IF (l_info.status_code <> C_AE_STATUS_FINAL) THEN
2942: xla_exceptions_pkg.raise_message
2943: (p_appli_s_name => 'XLA'
2944: ,p_msg_name => 'XLA_MJE_NO_REV_NON_FINAL'
2945: ,p_msg_mode => p_msg_mode);
2946: END IF;

Line 3000: WHEN xla_exceptions_pkg.application_exception THEN

2996: p_level => C_LEVEL_PROCEDURE);
2997: END IF;
2998:
2999: EXCEPTION
3000: WHEN xla_exceptions_pkg.application_exception THEN
3001: ROLLBACK;
3002: RAISE;
3003:
3004: WHEN OTHERS THEN

Line 3006: xla_exceptions_pkg.raise_message

3002: RAISE;
3003:
3004: WHEN OTHERS THEN
3005: ROLLBACK;
3006: xla_exceptions_pkg.raise_message
3007: (p_location => 'xla_journal_entries_pkg.reverse_journal_entry');
3008:
3009: END reverse_journal_entry;
3010:

Line 3028: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE

3024: ,p_gl_date IN DATE
3025: ,p_completion_option IN VARCHAR2
3026: ,p_functional_curr IN VARCHAR2
3027: ,p_je_source_name IN VARCHAR2
3028: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE
3029: ,p_rev_header_id OUT NOCOPY INTEGER
3030: ,p_rev_event_id OUT NOCOPY INTEGER
3031: ,p_completion_retcode OUT NOCOPY VARCHAR2
3032: ,p_transfer_request_id OUT NOCOPY INTEGER

Line 3080: xla_exceptions_pkg.raise_message

3076: IF (p_completion_option NOT in (C_COMPLETION_OPTION_DRAFT,
3077: C_COMPLETION_OPTION_FINAL,
3078: C_COMPLETION_OPTION_TRANSFER,
3079: C_COMPLETION_OPTION_POST)) THEN
3080: xla_exceptions_pkg.raise_message
3081: (p_appli_s_name => 'XLA'
3082: ,p_msg_name => 'XLA_MJE_INVALID_COMP_OPTION'
3083: ,p_msg_mode => p_msg_mode);
3084: END IF;

Line 3087: xla_exceptions_pkg.raise_message

3083: ,p_msg_mode => p_msg_mode);
3084: END IF;
3085:
3086: IF (l_info.status_code <> C_AE_STATUS_FINAL) THEN
3087: xla_exceptions_pkg.raise_message
3088: (p_appli_s_name => 'XLA'
3089: ,p_msg_name => 'XLA_MJE_NO_REV_NON_FINAL'
3090: ,p_msg_mode => p_msg_mode);
3091: END IF;

Line 3141: WHEN xla_exceptions_pkg.application_exception THEN

3137: p_level => C_LEVEL_PROCEDURE);
3138: END IF;
3139:
3140: EXCEPTION
3141: WHEN xla_exceptions_pkg.application_exception THEN
3142: ROLLBACK;
3143: RAISE;
3144:
3145: WHEN OTHERS THEN

Line 3147: xla_exceptions_pkg.raise_message

3143: RAISE;
3144:
3145: WHEN OTHERS THEN
3146: ROLLBACK;
3147: xla_exceptions_pkg.raise_message
3148: (p_location => 'xla_journal_entries_pkg.reverse_journal_entry');
3149:
3150: END reverse_journal_entry;
3151:

Line 3326: xla_exceptions_pkg.raise_message

3322: ,l_info.attribute15;
3323: CLOSE c_header;
3324:
3325: IF (l_info.ledger_id IS NULL) THEN
3326: xla_exceptions_pkg.raise_message
3327: (p_appli_s_name => 'XLA'
3328: ,p_msg_name => 'XLA_MJE_INVALID_HEADER_ID'
3329: ,p_msg_mode => p_msg_mode);
3330: END IF;

Line 3340: WHEN xla_exceptions_pkg.application_exception THEN

3336: END IF;
3337:
3338: RETURN l_info;
3339: EXCEPTION
3340: WHEN xla_exceptions_pkg.application_exception THEN
3341: IF (c_header%ISOPEN) THEN
3342: CLOSE c_header;
3343: END IF;
3344: RAISE;

Line 3350: xla_exceptions_pkg.raise_message

3346: WHEN OTHERS THEN
3347: IF (c_header%ISOPEN) THEN
3348: CLOSE c_header;
3349: END IF;
3350: xla_exceptions_pkg.raise_message
3351: (p_location => 'xla_journal_entries_pkg.get_header_info');
3352: END get_header_info;
3353:
3354:

Line 3364: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

3360: --=============================================================================
3361: PROCEDURE validate_code_combination_id
3362: (p_line_num IN INTEGER
3363: ,p_code_combination_id IN INTEGER
3364: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
3365: IS
3366: CURSOR C IS
3367: SELECT code_combination_id
3368: FROM gl_code_combinations

Line 3395: xla_exceptions_pkg.raise_message

3391: p_module => l_log_module,
3392: p_level => C_LEVEL_ERROR);
3393: END IF;
3394:
3395: xla_exceptions_pkg.raise_message
3396: (p_appli_s_name => 'XLA'
3397: ,p_msg_name => 'XLA_AP_INVALID_CCID'
3398: ,p_token_1 => 'ACCOUNT_VALUE'
3399: ,p_value_1 => NULL

Line 3412: WHEN xla_exceptions_pkg.application_exception THEN

3408: p_level => C_LEVEL_PROCEDURE);
3409: END IF;
3410:
3411: EXCEPTION
3412: WHEN xla_exceptions_pkg.application_exception THEN
3413: IF (c%ISOPEN) THEN
3414: CLOSE c;
3415: END IF;
3416: RAISE;

Line 3422: xla_exceptions_pkg.raise_message

3418: WHEN OTHERS THEN
3419: IF (c%ISOPEN) THEN
3420: CLOSE c;
3421: END IF;
3422: xla_exceptions_pkg.raise_message
3423: (p_location => 'xla_journal_entries_pkg.validate_code_combination_id');
3424: END validate_code_combination_id;
3425:
3426:

Line 3435: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

3431: --
3432: --=============================================================================
3433: PROCEDURE validate_ae_status_code
3434: (p_status_code IN VARCHAR2
3435: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
3436: IS
3437: l_log_module VARCHAR2(240);
3438: BEGIN
3439: IF g_log_enabled THEN

Line 3458: xla_exceptions_pkg.raise_message

3454: p_module => l_log_module,
3455: p_level => C_LEVEL_ERROR);
3456: END IF;
3457:
3458: xla_exceptions_pkg.raise_message
3459: (p_appli_s_name => 'XLA'
3460: ,p_msg_name => 'XLA_MJE_INVALID_AE_STATUS'
3461: ,p_msg_mode => p_msg_mode);
3462: END IF;

Line 3471: WHEN xla_exceptions_pkg.application_exception THEN

3467: p_level => C_LEVEL_PROCEDURE);
3468: END IF;
3469:
3470: EXCEPTION
3471: WHEN xla_exceptions_pkg.application_exception THEN
3472: RAISE;
3473:
3474: WHEN OTHERS THEN
3475: xla_exceptions_pkg.raise_message

Line 3475: xla_exceptions_pkg.raise_message

3471: WHEN xla_exceptions_pkg.application_exception THEN
3472: RAISE;
3473:
3474: WHEN OTHERS THEN
3475: xla_exceptions_pkg.raise_message
3476: (p_location => 'xla_journal_entries_pkg.validate_ae_status_code');
3477: END validate_ae_status_code;
3478:
3479:

Line 3488: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

3484: --
3485: --=============================================================================
3486: PROCEDURE validate_ae_type_code
3487: (p_accounting_entry_type_code IN VARCHAR2
3488: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
3489: IS
3490: l_log_module VARCHAR2(240);
3491: BEGIN
3492: IF g_log_enabled THEN

Line 3511: xla_exceptions_pkg.raise_message

3507: p_module => l_log_module,
3508: p_level => C_LEVEL_ERROR);
3509: END IF;
3510:
3511: xla_exceptions_pkg.raise_message
3512: (p_appli_s_name => 'XLA'
3513: ,p_msg_name => 'XLA_MJE_INVALID_AE_TYPE'
3514: ,p_token_1 => 'TYPE'
3515: ,p_value_1 => p_accounting_entry_type_code

Line 3526: WHEN xla_exceptions_pkg.application_exception THEN

3522: p_level => C_LEVEL_PROCEDURE);
3523: END IF;
3524:
3525: EXCEPTION
3526: WHEN xla_exceptions_pkg.application_exception THEN
3527: RAISE;
3528: WHEN OTHERS THEN
3529: xla_exceptions_pkg.raise_message
3530: (p_location => 'xla_journal_entries_pkg.validate_ae_type_code');

Line 3529: xla_exceptions_pkg.raise_message

3525: EXCEPTION
3526: WHEN xla_exceptions_pkg.application_exception THEN
3527: RAISE;
3528: WHEN OTHERS THEN
3529: xla_exceptions_pkg.raise_message
3530: (p_location => 'xla_journal_entries_pkg.validate_ae_type_code');
3531: END validate_ae_type_code;
3532:
3533:

Line 3545: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

3541: PROCEDURE validate_line_number
3542: (p_header_id IN INTEGER
3543: ,p_line_num IN INTEGER
3544: ,p_application_id IN INTEGER
3545: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
3546: IS
3547: CURSOR c IS
3548: SELECT ae_line_num
3549: FROM xla_ae_lines

Line 3578: xla_exceptions_pkg.raise_message

3574: p_module => l_log_module,
3575: p_level => C_LEVEL_ERROR);
3576: END IF;
3577:
3578: xla_exceptions_pkg.raise_message
3579: (p_appli_s_name => 'XLA'
3580: ,p_msg_name => 'XLA_MJE_INVALID_LINE_NUM'
3581: ,p_token_1 => 'LINE_NUM'
3582: ,p_value_1 => p_line_num

Line 3593: WHEN xla_exceptions_pkg.application_exception THEN

3589: p_level => C_LEVEL_PROCEDURE);
3590: END IF;
3591:
3592: EXCEPTION
3593: WHEN xla_exceptions_pkg.application_exception THEN
3594: IF (c%ISOPEN) THEN
3595: CLOSE c;
3596: END IF;
3597: RAISE;

Line 3603: xla_exceptions_pkg.raise_message

3599: WHEN OTHERS THEN
3600: IF (c%ISOPEN) THEN
3601: CLOSE c;
3602: END IF;
3603: xla_exceptions_pkg.raise_message
3604: (p_location => 'xla_journal_entries_pkg.validate_line_number`');
3605: END validate_line_number;
3606:
3607: --=============================================================================

Line 3618: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

3614: (p_header_id IN INTEGER
3615: ,p_line_num IN INTEGER
3616: ,p_display_line_num IN INTEGER
3617: ,p_application_id IN INTEGER
3618: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
3619: IS
3620: CURSOR c IS
3621: SELECT ae_line_num
3622: FROM xla_ae_lines

Line 3652: xla_exceptions_pkg.raise_message

3648: p_module => l_log_module,
3649: p_level => C_LEVEL_ERROR);
3650: END IF;
3651:
3652: xla_exceptions_pkg.raise_message
3653: (p_appli_s_name => 'XLA'
3654: ,p_msg_name => 'XLA_MJE_LINE_NUM_EXIST'
3655: ,p_token_1 => 'LINE_NUM'
3656: ,p_value_1 => p_display_line_num

Line 3668: WHEN xla_exceptions_pkg.application_exception THEN

3664: p_level => C_LEVEL_PROCEDURE);
3665: END IF;
3666:
3667: EXCEPTION
3668: WHEN xla_exceptions_pkg.application_exception THEN
3669: IF (c%ISOPEN) THEN
3670: CLOSE c;
3671: END IF;
3672: RAISE;

Line 3678: xla_exceptions_pkg.raise_message

3674: WHEN OTHERS THEN
3675: IF (c%ISOPEN) THEN
3676: CLOSE c;
3677: END IF;
3678: xla_exceptions_pkg.raise_message
3679: (p_location => 'xla_journal_entries_pkg.validate_display_line_number`');
3680:
3681: END validate_display_line_number;
3682:

Line 3792: WHEN xla_exceptions_pkg.application_exception THEN

3788: END IF;
3789:
3790: RETURN l_retcode;
3791: EXCEPTION
3792: WHEN xla_exceptions_pkg.application_exception THEN
3793: IF (c_line%ISOPEN) THEN
3794: CLOSE c_line;
3795: END IF;
3796: RAISE;

Line 3802: xla_exceptions_pkg.raise_message

3798: WHEN OTHERS THEN
3799: IF (c_line%ISOPEN) THEN
3800: CLOSE c_line;
3801: END IF;
3802: xla_exceptions_pkg.raise_message
3803: (p_location => 'xla_journal_entries_pkg.validate_lines');
3804: END validate_lines;
3805:
3806: --=============================================================================

Line 3866: WHEN xla_exceptions_pkg.application_exception THEN

3862: END IF;
3863:
3864: RETURN l_retcode;
3865: EXCEPTION
3866: WHEN xla_exceptions_pkg.application_exception THEN
3867: RAISE;
3868:
3869: WHEN OTHERS THEN
3870: xla_exceptions_pkg.raise_message

Line 3870: xla_exceptions_pkg.raise_message

3866: WHEN xla_exceptions_pkg.application_exception THEN
3867: RAISE;
3868:
3869: WHEN OTHERS THEN
3870: xla_exceptions_pkg.raise_message
3871: (p_location => 'xla_journal_entries_pkg.validate_completion_action');
3872: END validate_completion_action;
3873:
3874:

Line 3923: xla_exceptions_pkg.raise_message

3919: p_module => l_log_module,
3920: p_level => C_LEVEL_ERROR);
3921: END IF;
3922:
3923: xla_exceptions_pkg.raise_message
3924: (p_appli_s_name => 'XLA'
3925: ,p_msg_name => 'XLA_MJE_INVALID_LEDGER_ID'
3926: ,p_token_1 => 'LEDGER_ID'
3927: ,p_value_1 => p_ledger_id

Line 3945: WHEN xla_exceptions_pkg.application_exception THEN

3941: END IF;
3942:
3943: RETURN l_return;
3944: EXCEPTION
3945: WHEN xla_exceptions_pkg.application_exception THEN
3946: IF (c_bc_enabled%ISOPEN) THEN
3947: CLOSE c_bc_enabled;
3948: END IF;
3949: RAISE;

Line 3955: xla_exceptions_pkg.raise_message

3951: WHEN OTHERS THEN
3952: IF (c_bc_enabled%ISOPEN) THEN
3953: CLOSE c_bc_enabled;
3954: END IF;
3955: xla_exceptions_pkg.raise_message
3956: (p_location => 'xla_journal_entries_pkg.is_budgetary_control_enabled');
3957:
3958: END is_budgetary_control_enabled;
3959:

Line 4001: xla_exceptions_pkg.raise_message

3997: ,p_request_id => NULL
3998: ,p_accounting_batch_id => NULL
3999: ,p_update_mode => C_BALANCE_DELETE
4000: ,p_execution_mode => C_BALANCE_ONLINE)) THEN
4001: xla_exceptions_pkg.raise_message
4002: (p_appli_s_name => 'XLA'
4003: ,p_msg_name => 'XLA_INTERNAL_ERROR'
4004: ,p_token_1 => 'MESSAGE'
4005: ,p_value_1 => 'Error in balance calculation'

Line 4008: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);

4004: ,p_token_1 => 'MESSAGE'
4005: ,p_value_1 => 'Error in balance calculation'
4006: ,p_token_2 => 'LOCATION'
4007: ,p_value_2 => 'XLA_JOURNAL_ENTRIES_PKG.undo_draft_entry' --Bug 13614923
4008: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);
4009: END IF;
4010: ELSE
4011: IF (NOT xla_balances_calc_pkg.massive_update
4012: (p_application_id => p_info.application_id

Line 4021: xla_exceptions_pkg.raise_message

4017: ,p_accounting_batch_id => NULL
4018: ,p_update_mode => C_BALANCE_DELETE
4019: ,p_execution_mode => C_BALANCE_ONLINE)) THEN
4020:
4021: xla_exceptions_pkg.raise_message
4022: (p_appli_s_name => 'XLA'
4023: ,p_msg_name => 'XLA_INTERNAL_ERROR'
4024: ,p_token_1 => 'MESSAGE'
4025: ,p_value_1 => 'Error in balance calculation'

Line 4028: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);

4024: ,p_token_1 => 'MESSAGE'
4025: ,p_value_1 => 'Error in balance calculation'
4026: ,p_token_2 => 'LOCATION'
4027: ,p_value_2 => 'XLA_JOURNAL_ENTRIES_PKG.undo_draft_entry' --Bug 13614923
4028: ,p_msg_mode => xla_exceptions_pkg.C_STANDARD_MESSAGE);
4029: END IF;
4030: END IF;
4031:
4032: --

Line 4059: WHEN xla_exceptions_pkg.application_exception THEN

4055: p_level => C_LEVEL_PROCEDURE);
4056: END IF;
4057:
4058: EXCEPTION
4059: WHEN xla_exceptions_pkg.application_exception THEN
4060: RAISE;
4061:
4062: WHEN OTHERS THEN
4063: xla_exceptions_pkg.raise_message

Line 4063: xla_exceptions_pkg.raise_message

4059: WHEN xla_exceptions_pkg.application_exception THEN
4060: RAISE;
4061:
4062: WHEN OTHERS THEN
4063: xla_exceptions_pkg.raise_message
4064: (p_location => 'xla_journal_entries_pkg.undo_draft_entry');
4065: END undo_draft_entry;
4066:
4067:

Line 4126: WHEN xla_exceptions_pkg.application_exception THEN

4122: END IF;
4123:
4124: RETURN l_retcode;
4125: EXCEPTION
4126: WHEN xla_exceptions_pkg.application_exception THEN
4127: RAISE;
4128: WHEN OTHERS THEN
4129: xla_exceptions_pkg.raise_message
4130: (p_location => 'xla_journal_entries_pkg.validate_reversal_method');

Line 4129: xla_exceptions_pkg.raise_message

4125: EXCEPTION
4126: WHEN xla_exceptions_pkg.application_exception THEN
4127: RAISE;
4128: WHEN OTHERS THEN
4129: xla_exceptions_pkg.raise_message
4130: (p_location => 'xla_journal_entries_pkg.validate_reversal_method');
4131: END validate_reversal_method;
4132:
4133:

Line 4502: WHEN xla_exceptions_pkg.application_exception THEN

4498: END IF;
4499: END LOOP;
4500:
4501: EXCEPTION
4502: WHEN xla_exceptions_pkg.application_exception THEN
4503: ROLLBACK ;
4504: RAISE;
4505:
4506: WHEN OTHERS THEN

Line 4508: xla_exceptions_pkg.raise_message

4504: RAISE;
4505:
4506: WHEN OTHERS THEN
4507: ROLLBACK;
4508: xla_exceptions_pkg.raise_message
4509: (p_location => 'xla_journal_entries_pkg.create_mrc_reversal_entry');
4510:
4511: END create_mrc_reversal_entry;
4512:

Line 4559: xla_exceptions_pkg.raise_message

4555: ,p_closing_status => l_closing_status
4556: ,p_period_type => l_period_type);
4557:
4558: IF (l_period_name IS NULL) THEN
4559: xla_exceptions_pkg.raise_message
4560: (p_appli_s_name => 'XLA'
4561: ,p_msg_name => 'XLA_AP_INVALID_GL_DATE'
4562: ,p_token_1 => 'GL_DATE'
4563: ,p_value_1 => to_char(p_gl_date,'DD-MON-YYYY')

Line 4890: WHEN xla_exceptions_pkg.application_exception THEN

4886: p_level => C_LEVEL_PROCEDURE);
4887: END IF;
4888:
4889: EXCEPTION
4890: WHEN xla_exceptions_pkg.application_exception THEN
4891: ROLLBACK ;
4892: RAISE;
4893:
4894: WHEN OTHERS THEN

Line 4896: xla_exceptions_pkg.raise_message

4892: RAISE;
4893:
4894: WHEN OTHERS THEN
4895: ROLLBACK;
4896: xla_exceptions_pkg.raise_message
4897: (p_location => 'xla_journal_entries_pkg.create_reversal_entry');
4898:
4899: END create_reversal_entry;
4900:

Line 4974: WHEN xla_exceptions_pkg.application_exception THEN

4970: p_level => C_LEVEL_PROCEDURE);
4971: END IF;
4972:
4973: EXCEPTION
4974: WHEN xla_exceptions_pkg.application_exception THEN
4975: IF (c_lines%ISOPEN) THEN
4976: CLOSE c_lines;
4977: END IF;
4978: ROLLBACK;

Line 4986: xla_exceptions_pkg.raise_message

4982: IF (c_lines%ISOPEN) THEN
4983: CLOSE c_lines;
4984: END IF;
4985: ROLLBACK;
4986: xla_exceptions_pkg.raise_message
4987: (p_location => 'xla_journal_entries_pkg.reorder_line_number');
4988:
4989: END reorder_line_number;
4990:

Line 5062: WHEN xla_exceptions_pkg.application_exception THEN

5058: END IF;
5059:
5060: RETURN l_retcode;
5061: EXCEPTION
5062: WHEN xla_exceptions_pkg.application_exception THEN
5063: RAISE;
5064:
5065: WHEN OTHERS THEN
5066: xla_exceptions_pkg.raise_message

Line 5066: xla_exceptions_pkg.raise_message

5062: WHEN xla_exceptions_pkg.application_exception THEN
5063: RAISE;
5064:
5065: WHEN OTHERS THEN
5066: xla_exceptions_pkg.raise_message
5067: (p_location => 'xla_journal_entries_pkg.reserve_funds');
5068: END reserve_funds;
5069:
5070: --=============================================================================

Line 5219: WHEN xla_exceptions_pkg.application_exception THEN

5215: END IF;
5216:
5217: RETURN l_retcode;
5218: EXCEPTION
5219: WHEN xla_exceptions_pkg.application_exception THEN
5220: RAISE;
5221:
5222: WHEN OTHERS THEN
5223: xla_exceptions_pkg.raise_message

Line 5223: xla_exceptions_pkg.raise_message

5219: WHEN xla_exceptions_pkg.application_exception THEN
5220: RAISE;
5221:
5222: WHEN OTHERS THEN
5223: xla_exceptions_pkg.raise_message
5224: (p_location => 'xla_journal_entries_pkg.get_sequence_number');
5225: END get_sequence_number;
5226:
5227:

Line 5306: WHEN xla_exceptions_pkg.application_exception THEN

5302: END IF;
5303:
5304: RETURN l_retcode;
5305: EXCEPTION
5306: WHEN xla_exceptions_pkg.application_exception THEN
5307: ROLLBACK to SAVEPOINT POPULATE_SEQUENCE_NUMBERS;
5308: RAISE;
5309:
5310: WHEN OTHERS THEN

Line 5312: xla_exceptions_pkg.raise_message

5308: RAISE;
5309:
5310: WHEN OTHERS THEN
5311: ROLLBACK to SAVEPOINT POPULATE_SEQUENCE_NUMBERS;
5312: xla_exceptions_pkg.raise_message
5313: (p_location => 'xla_journal_entries_pkg.populate_sequence_numbers');
5314:
5315: END populate_sequence_numbers;
5316:

Line 6027: WHEN xla_exceptions_pkg.application_exception THEN

6023: END IF;
6024:
6025: RETURN l_retcode;
6026: EXCEPTION
6027: WHEN xla_exceptions_pkg.application_exception THEN
6028: IF (c_lines%ISOPEN) THEN
6029: CLOSE c_lines;
6030: END IF;
6031: IF (c_mrc_ledgers%ISOPEN) THEN

Line 6044: xla_exceptions_pkg.raise_message

6040: IF (c_mrc_ledgers%ISOPEN) THEN
6041: CLOSE c_mrc_ledgers;
6042: END IF;
6043:
6044: xla_exceptions_pkg.raise_message
6045: (p_location => 'xla_journal_entries_pkg.create_mrc_entries');
6046:
6047: END create_mrc_entries;
6048:

Line 6157: WHEN xla_exceptions_pkg.application_exception THEN

6153: p_level => C_LEVEL_PROCEDURE);
6154: END IF;
6155:
6156: EXCEPTION
6157: WHEN xla_exceptions_pkg.application_exception THEN
6158: ROLLBACK;
6159: IF (c_entries%ISOPEN) THEN
6160: CLOSE c_entries;
6161: END IF;

Line 6169: xla_exceptions_pkg.raise_message

6165: ROLLBACK;
6166: IF (c_entries%ISOPEN) THEN
6167: CLOSE c_entries;
6168: END IF;
6169: xla_exceptions_pkg.raise_message
6170: (p_location => 'xla_journal_entries_pkg.delete_mrc_entries');
6171: END delete_mrc_entries;
6172:
6173: --=============================================================================

Line 6249: WHEN xla_exceptions_pkg.application_exception THEN

6245: p_level => C_LEVEL_PROCEDURE);
6246: END IF;
6247:
6248: EXCEPTION
6249: WHEN xla_exceptions_pkg.application_exception THEN
6250: ROLLBACK;
6251: RAISE;
6252:
6253: WHEN OTHERS THEN

Line 6254: xla_exceptions_pkg.raise_message

6250: ROLLBACK;
6251: RAISE;
6252:
6253: WHEN OTHERS THEN
6254: xla_exceptions_pkg.raise_message
6255: (p_location => 'xla_journal_entries_pkg.transfer_to_gl');
6256: END transfer_to_gl;
6257:
6258: --=============================================================================

Line 6313: WHEN xla_exceptions_pkg.application_exception THEN

6309: p_level => C_LEVEL_PROCEDURE);
6310: END IF;
6311:
6312: EXCEPTION
6313: WHEN xla_exceptions_pkg.application_exception THEN
6314: ROLLBACK;
6315: RAISE;
6316:
6317: WHEN OTHERS THEN

Line 6319: xla_exceptions_pkg.raise_message

6315: RAISE;
6316:
6317: WHEN OTHERS THEN
6318: ROLLBACK;
6319: xla_exceptions_pkg.raise_message
6320: (p_location => 'xla_journal_entries_pkg.update_event_status');
6321: END update_event_status;
6322:
6323:

Line 6384: WHEN xla_exceptions_pkg.application_exception THEN

6380:
6381: WHEN NO_DATA_FOUND THEN
6382: RETURN (NULL);
6383:
6384: WHEN xla_exceptions_pkg.application_exception THEN
6385: ROLLBACK;
6386: RAISE;
6387:
6388: WHEN OTHERS THEN

Line 6390: xla_exceptions_pkg.raise_message

6386: RAISE;
6387:
6388: WHEN OTHERS THEN
6389: ROLLBACK;
6390: xla_exceptions_pkg.raise_message
6391: (p_location => 'xla_journal_entries_pkg.round_currency');
6392: END round_currency;
6393:
6394:

Line 6402: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

6398: --
6399: --=============================================================================
6400: PROCEDURE validate_balance_type_code
6401: (p_balance_type_code IN VARCHAR2
6402: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
6403: IS
6404: l_log_module VARCHAR2(240);
6405: BEGIN
6406: IF g_log_enabled THEN

Line 6423: xla_exceptions_pkg.raise_message

6419: p_module => l_log_module,
6420: p_level => C_LEVEL_ERROR);
6421: END IF;
6422:
6423: xla_exceptions_pkg.raise_message
6424: (p_appli_s_name => 'XLA'
6425: ,p_msg_name => 'XLA_AP_INVALID_BALANCE_TYPE'
6426: ,p_token_1 => 'BALANCE_TYPE'
6427: ,p_value_1 => p_balance_type_code

Line 6438: WHEN xla_exceptions_pkg.application_exception THEN

6434: p_level => C_LEVEL_PROCEDURE);
6435: END IF;
6436:
6437: EXCEPTION
6438: WHEN xla_exceptions_pkg.application_exception THEN
6439: RAISE;
6440:
6441: WHEN OTHERS THEN
6442: xla_exceptions_pkg.raise_message

Line 6442: xla_exceptions_pkg.raise_message

6438: WHEN xla_exceptions_pkg.application_exception THEN
6439: RAISE;
6440:
6441: WHEN OTHERS THEN
6442: xla_exceptions_pkg.raise_message
6443: (p_location => 'xla_journal_entries_pkg.validate_balance_type_code');
6444: END validate_balance_type_code;
6445:
6446:

Line 6515: WHEN xla_exceptions_pkg.application_exception THEN

6511: END IF;
6512:
6513: RETURN l_result;
6514: EXCEPTION
6515: WHEN xla_exceptions_pkg.application_exception THEN
6516: IF (c%ISOPEN) THEN
6517: CLOSE c;
6518: END IF;
6519: RAISE;

Line 6525: xla_exceptions_pkg.raise_message

6521: WHEN OTHERS THEN
6522: IF (c%ISOPEN) THEN
6523: CLOSE c;
6524: END IF;
6525: xla_exceptions_pkg.raise_message
6526: (p_location => 'xla_journal_entries_pkg.validate_legal_entity_id');
6527: END validate_legal_entity_id;
6528:
6529: --=============================================================================

Line 6662: WHEN xla_exceptions_pkg.application_exception THEN

6658: END IF;
6659:
6660: RETURN l_result;
6661: EXCEPTION
6662: WHEN xla_exceptions_pkg.application_exception THEN
6663: IF (c%ISOPEN) THEN
6664: CLOSE c;
6665: END IF;
6666: RAISE;

Line 6671: xla_exceptions_pkg.raise_message

6667: WHEN OTHERS THEN
6668: IF (c%ISOPEN) THEN
6669: CLOSE c;
6670: END IF;
6671: xla_exceptions_pkg.raise_message
6672: (p_location => 'xla_journal_entries_pkg.validate_line_counts');
6673: END validate_line_counts;
6674:
6675: --=============================================================================

Line 6728: WHEN xla_exceptions_pkg.application_exception THEN

6724: END IF;
6725:
6726: RETURN l_result;
6727: EXCEPTION
6728: WHEN xla_exceptions_pkg.application_exception THEN
6729: RAISE;
6730: WHEN OTHERS THEN
6731: xla_exceptions_pkg.raise_message
6732: (p_location => 'xla_journal_entries_pkg.validate_description');

Line 6731: xla_exceptions_pkg.raise_message

6727: EXCEPTION
6728: WHEN xla_exceptions_pkg.application_exception THEN
6729: RAISE;
6730: WHEN OTHERS THEN
6731: xla_exceptions_pkg.raise_message
6732: (p_location => 'xla_journal_entries_pkg.validate_description');
6733: END validate_description;
6734:
6735:

Line 6765: xla_exceptions_pkg.raise_message

6761: p_module => l_log_module,
6762: p_level => C_LEVEL_ERROR);
6763: END IF;
6764:
6765: xla_exceptions_pkg.raise_message
6766: (p_appli_s_name => 'XLA'
6767: ,p_msg_name => 'XLA_MJE_INVALID_DELETE_MODE'
6768: ,p_msg_mode => p_msg_mode);
6769: ELSIF (p_status_code = C_AE_STATUS_FINAL AND

Line 6777: xla_exceptions_pkg.raise_message

6773: p_module => l_log_module,
6774: p_level => C_LEVEL_ERROR);
6775: END IF;
6776:
6777: xla_exceptions_pkg.raise_message
6778: (p_appli_s_name => 'XLA'
6779: ,p_msg_name => 'XLA_MJE_INVALID_DELETE_FINAL'
6780: ,p_msg_mode => p_msg_mode);
6781: END IF;

Line 6790: WHEN xla_exceptions_pkg.application_exception THEN

6786: p_level => C_LEVEL_PROCEDURE);
6787: END IF;
6788:
6789: EXCEPTION
6790: WHEN xla_exceptions_pkg.application_exception THEN
6791: RAISE;
6792: WHEN OTHERS THEN
6793: xla_exceptions_pkg.raise_message
6794: (p_location => 'xla_journal_entries_pkg.validate_delete_mode');

Line 6793: xla_exceptions_pkg.raise_message

6789: EXCEPTION
6790: WHEN xla_exceptions_pkg.application_exception THEN
6791: RAISE;
6792: WHEN OTHERS THEN
6793: xla_exceptions_pkg.raise_message
6794: (p_location => 'xla_journal_entries_pkg.validate_delete_mode');
6795: END validate_delete_mode;
6796:
6797:

Line 6848: WHEN xla_exceptions_pkg.application_exception THEN

6844: END IF;
6845:
6846: RETURN l_retcode;
6847: EXCEPTION
6848: WHEN xla_exceptions_pkg.application_exception THEN
6849: IF (c%ISOPEN) THEN
6850: CLOSE c;
6851: END IF;
6852: RAISE;

Line 6858: xla_exceptions_pkg.raise_message

6854: WHEN OTHERS THEN
6855: IF (c%ISOPEN) THEN
6856: CLOSE c;
6857: END IF;
6858: xla_exceptions_pkg.raise_message
6859: (p_location => 'xla_journal_entries_pkg.clear_errors');
6860: END clear_errors;
6861:
6862: --=============================================================================

Line 6873: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)

6869: (p_ae_header_id IN INTEGER
6870: ,p_application_id IN INTEGER
6871: ,p_ledger_id IN INTEGER
6872: ,p_packet_id IN INTEGER
6873: ,p_msg_mode IN VARCHAR2 DEFAULT xla_exceptions_pkg.C_STANDARD_MESSAGE)
6874: RETURN BOOLEAN
6875: IS
6876: l_funds_retcode VARCHAR2(30);
6877: l_retcode BOOLEAN := TRUE;

Line 6908: WHEN xla_exceptions_pkg.application_exception THEN

6904: END IF;
6905:
6906: RETURN l_retcode;
6907: EXCEPTION
6908: WHEN xla_exceptions_pkg.application_exception THEN
6909: RAISE;
6910: WHEN OTHERS THEN
6911: xla_exceptions_pkg.raise_message
6912: (p_location => 'xla_journal_entries_pkg.unreserve_funds');

Line 6911: xla_exceptions_pkg.raise_message

6907: EXCEPTION
6908: WHEN xla_exceptions_pkg.application_exception THEN
6909: RAISE;
6910: WHEN OTHERS THEN
6911: xla_exceptions_pkg.raise_message
6912: (p_location => 'xla_journal_entries_pkg.unreserve_funds');
6913: END unreserve_funds;
6914: */
6915:

Line 7026: WHEN xla_exceptions_pkg.application_exception THEN

7022: p_level => C_LEVEL_PROCEDURE);
7023: END IF;
7024:
7025: EXCEPTION
7026: WHEN xla_exceptions_pkg.application_exception THEN
7027: IF (c%ISOPEN) THEN
7028: CLOSE c;
7029: END IF;
7030: RAISE;

Line 7035: xla_exceptions_pkg.raise_message

7031: WHEN OTHERS THEN
7032: IF (c%ISOPEN) THEN
7033: CLOSE c;
7034: END IF;
7035: xla_exceptions_pkg.raise_message
7036: (p_location => 'xla_journal_entries_pkg. get_ledger_info');
7037: END get_ledger_info;
7038:
7039: --=============================================================================

Line 7077: WHEN xla_exceptions_pkg.application_exception THEN

7073: p_level => C_LEVEL_PROCEDURE);
7074: END IF;
7075:
7076: EXCEPTION
7077: WHEN xla_exceptions_pkg.application_exception THEN
7078: IF (c%ISOPEN) THEN
7079: CLOSE c;
7080: END IF;
7081: RAISE;

Line 7086: xla_exceptions_pkg.raise_message

7082: WHEN OTHERS THEN
7083: IF (c%ISOPEN) THEN
7084: CLOSE c;
7085: END IF;
7086: xla_exceptions_pkg.raise_message
7087: (p_location => 'xla_journal_entries_pkg. get_ledger_options');
7088: END get_ledger_options;
7089:
7090:

Line 7161: WHEN xla_exceptions_pkg.application_exception THEN

7157: p_level => C_LEVEL_PROCEDURE);
7158: END IF;
7159:
7160: EXCEPTION
7161: WHEN xla_exceptions_pkg.application_exception THEN
7162: IF (c_seg%ISOPEN) THEN
7163: CLOSE c_seg;
7164: END IF;
7165: RAISE;

Line 7170: xla_exceptions_pkg.raise_message

7166: WHEN OTHERS THEN
7167: IF (c_seg%ISOPEN) THEN
7168: CLOSE c_seg;
7169: END IF;
7170: xla_exceptions_pkg.raise_message
7171: (p_location => 'xla_journal_entries_pkg.update_segment_values');
7172: END update_segment_values;
7173:
7174: --=============================================================================

Line 7207: xla_exceptions_pkg.raise_message

7203: FETCH c INTO l_code;
7204: IF (c%NOTFOUND) THEN
7205: CLOSE c;
7206:
7207: xla_exceptions_pkg.raise_message
7208: (p_appli_s_name => 'XLA'
7209: ,p_msg_name => 'XLA_MJE_INVALID_JOURNAL_CAT'
7210: ,p_token_1 => 'JE_CATEGORY'
7211: ,p_value_1 => p_je_category_name

Line 7223: WHEN xla_exceptions_pkg.application_exception THEN

7219: p_level => C_LEVEL_PROCEDURE);
7220: END IF;
7221:
7222: EXCEPTION
7223: WHEN xla_exceptions_pkg.application_exception THEN
7224: IF (c%ISOPEN) THEN
7225: CLOSE c;
7226: END IF;
7227: RAISE;

Line 7233: xla_exceptions_pkg.raise_message

7229: WHEN OTHERS THEN
7230: IF (c%ISOPEN) THEN
7231: CLOSE c;
7232: END IF;
7233: xla_exceptions_pkg.raise_message
7234: (p_location => 'xla_journal_entries_pkg.validate_je_category');
7235: END validate_je_category;
7236:
7237: --============================================================================

Line 7267: xla_exceptions_pkg.raise_message

7263:
7264: OPEN c;
7265: FETCH c INTO l_app_id;
7266: IF (c%NOTFOUND) THEN
7267: xla_exceptions_pkg.raise_message
7268: (p_appli_s_name => 'XLA'
7269: ,p_msg_name => 'XLA_MJE_INVALID_APP_ID'
7270: ,p_token_1 => 'APPLICATION_ID'
7271: ,p_value_1 => p_application_id);

Line 7282: WHEN xla_exceptions_pkg.application_exception THEN

7278: p_level => C_LEVEL_PROCEDURE);
7279: END IF;
7280:
7281: EXCEPTION
7282: WHEN xla_exceptions_pkg.application_exception THEN
7283: IF (c%ISOPEN) THEN
7284: CLOSE c;
7285: END IF;
7286: RAISE;

Line 7292: xla_exceptions_pkg.raise_message

7288: WHEN OTHERS THEN
7289: IF (c%ISOPEN) THEN
7290: CLOSE c;
7291: END IF;
7292: xla_exceptions_pkg.raise_message
7293: (p_location => 'xla_journal_entries_pkg.validate_application_id');
7294: END validate_application_id;
7295:
7296: --=============================================================================

Line 7334: xla_exceptions_pkg.raise_message

7330: OPEN c;
7331: FETCH c INTO l_ledger_name, l_classification_code, l_latest_encumbrance_year, l_bc_enabled_flag;
7332:
7333: IF (c%NOTFOUND) THEN
7334: xla_exceptions_pkg.raise_message
7335: (p_appli_s_name => 'XLA'
7336: ,p_msg_name => 'XLA_MJE_INVALID_LEDGER_ID'
7337: ,p_token_1 => 'LEDGER_ID'
7338: ,p_value_1 => p_ledger_id);

Line 7344: xla_exceptions_pkg.raise_message

7340: -- Encumbrance , C_JE_ENCUMBRANCE commented for bug12664485
7341: -- modified 'ALC_TRANSACTION' to 'ALC'
7342: IF (p_balance_type_code in (C_JE_BUDGET) AND
7343: l_classification_code NOT in ('PRIMARY', 'ALC')) THEN
7344: xla_exceptions_pkg.raise_message
7345: (p_appli_s_name => 'XLA'
7346: ,p_msg_name => 'XLA_MJE_INVALID_LEDGER_ASSGN'
7347: ,p_token_1 => 'LEDGER_NAME'
7348: ,p_value_1 => l_ledger_name);

Line 7353: xla_exceptions_pkg.raise_message

7349: END IF;
7350:
7351: IF (p_balance_type_code = C_JE_ENCUMBRANCE AND
7352: l_latest_encumbrance_year IS NULL) THEN
7353: xla_exceptions_pkg.raise_message
7354: (p_appli_s_name => 'XLA'
7355: ,p_msg_name => 'XLA_MJE_INVALID_ENCUM_LEDGER'
7356: ,p_token_1 => 'LEDGER_NAME'
7357: ,p_value_1 => l_ledger_name);

Line 7361: xla_exceptions_pkg.raise_message

7357: ,p_value_1 => l_ledger_name);
7358: END IF;
7359:
7360: IF (p_budgetary_control_flag = 'Y' AND l_bc_enabled_flag = 'N') THEN
7361: xla_exceptions_pkg.raise_message
7362: (p_appli_s_name => 'XLA'
7363: ,p_msg_name => 'XLA_MJE_INVALID_BC_LEDGER'
7364: ,p_token_1 => 'LEDGER_NAME'
7365: ,p_value_1 => l_ledger_name);

Line 7377: WHEN xla_exceptions_pkg.application_exception THEN

7373: p_level => C_LEVEL_PROCEDURE);
7374: END IF;
7375:
7376: EXCEPTION
7377: WHEN xla_exceptions_pkg.application_exception THEN
7378: IF (c%ISOPEN) THEN
7379: CLOSE c;
7380: END IF;
7381: RAISE;

Line 7387: xla_exceptions_pkg.raise_message

7383: WHEN OTHERS THEN
7384: IF (c%ISOPEN) THEN
7385: CLOSE c;
7386: END IF;
7387: xla_exceptions_pkg.raise_message
7388: (p_location => 'xla_journal_entries_pkg.validate_ledger');
7389: end validate_ledger;
7390:
7391: --=============================================================================

Line 7607: WHEN xla_exceptions_pkg.application_exception THEN

7603: END IF;
7604:
7605: RETURN l_result;
7606: EXCEPTION
7607: WHEN xla_exceptions_pkg.application_exception THEN
7608: IF (c_lines%ISOPEN) THEN
7609: CLOSE c_lines;
7610: END IF;
7611: RAISE;

Line 7616: xla_exceptions_pkg.raise_message

7612: WHEN OTHERS THEN
7613: IF (c_lines%ISOPEN) THEN
7614: CLOSE c_lines;
7615: END IF;
7616: xla_exceptions_pkg.raise_message
7617: (p_location => 'xla_journal_entries_pkg.validate_amounts');
7618: end validate_amounts;
7619:
7620: --=============================================================================

Line 7741: WHEN xla_exceptions_pkg.application_exception THEN

7737: p_level => C_LEVEL_PROCEDURE);
7738: END IF;
7739:
7740: EXCEPTION
7741: WHEN xla_exceptions_pkg.application_exception THEN
7742: RAISE;
7743:
7744: WHEN OTHERS THEN
7745: xla_exceptions_pkg.raise_message

Line 7745: xla_exceptions_pkg.raise_message

7741: WHEN xla_exceptions_pkg.application_exception THEN
7742: RAISE;
7743:
7744: WHEN OTHERS THEN
7745: xla_exceptions_pkg.raise_message
7746: (p_location => 'xla_journal_entries_pkg.calculate_amounts');
7747: END calculate_amounts;
7748:
7749:

Line 7802: WHEN xla_exceptions_pkg.application_exception THEN

7798: END IF;
7799:
7800: RETURN l_period_name;
7801: EXCEPTION
7802: WHEN xla_exceptions_pkg.application_exception THEN
7803: IF (c%ISOPEN) THEN
7804: CLOSE c;
7805: END IF;
7806: RAISE;

Line 7812: xla_exceptions_pkg.raise_message

7808: WHEN OTHERS THEN
7809: IF (c%ISOPEN) THEN
7810: CLOSE c;
7811: END IF;
7812: xla_exceptions_pkg.raise_message
7813: (p_location => 'xla_journal_entries_pkg.get_period_name');
7814: END get_period_name;
7815:
7816:

Line 7881: WHEN xla_exceptions_pkg.application_exception THEN

7877: p_level => C_LEVEL_PROCEDURE);
7878: END IF;
7879:
7880: EXCEPTION
7881: WHEN xla_exceptions_pkg.application_exception THEN
7882: RAISE;
7883:
7884: WHEN OTHERS THEN
7885: xla_exceptions_pkg.raise_message

Line 7885: xla_exceptions_pkg.raise_message

7881: WHEN xla_exceptions_pkg.application_exception THEN
7882: RAISE;
7883:
7884: WHEN OTHERS THEN
7885: xla_exceptions_pkg.raise_message
7886: (p_location => 'xla_journal_entries_pkg.funds_check_result');
7887: END funds_check_result;
7888:
7889:

Line 8445: WHEN xla_exceptions_pkg.application_exception THEN

8441: p_level => C_LEVEL_PROCEDURE);
8442: END IF;
8443:
8444: EXCEPTION
8445: WHEN xla_exceptions_pkg.application_exception THEN
8446: RAISE;
8447:
8448: WHEN OTHERS THEN
8449: xla_exceptions_pkg.raise_message

Line 8449: xla_exceptions_pkg.raise_message

8445: WHEN xla_exceptions_pkg.application_exception THEN
8446: RAISE;
8447:
8448: WHEN OTHERS THEN
8449: xla_exceptions_pkg.raise_message
8450: (p_location => 'xla_journal_entries_pkg.create_distribution_link');
8451:
8452: END create_distribution_link;
8453:

Line 8505: WHEN xla_exceptions_pkg.application_exception THEN

8501: p_level => C_LEVEL_PROCEDURE);
8502: END IF;
8503:
8504: EXCEPTION
8505: WHEN xla_exceptions_pkg.application_exception THEN
8506: RAISE;
8507:
8508: WHEN OTHERS THEN
8509: xla_exceptions_pkg.raise_message

Line 8509: xla_exceptions_pkg.raise_message

8505: WHEN xla_exceptions_pkg.application_exception THEN
8506: RAISE;
8507:
8508: WHEN OTHERS THEN
8509: xla_exceptions_pkg.raise_message
8510: (p_location => 'xla_journal_entries_pkg.delete_distribution_link');
8511: END delete_distribution_link;
8512:
8513: PROCEDURE update_distribution_link

Line 8596: WHEN xla_exceptions_pkg.application_exception THEN

8592: p_level => C_LEVEL_PROCEDURE);
8593: END IF;
8594:
8595: EXCEPTION
8596: WHEN xla_exceptions_pkg.application_exception THEN
8597: RAISE;
8598:
8599: WHEN OTHERS THEN
8600: xla_exceptions_pkg.raise_message

Line 8600: xla_exceptions_pkg.raise_message

8596: WHEN xla_exceptions_pkg.application_exception THEN
8597: RAISE;
8598:
8599: WHEN OTHERS THEN
8600: xla_exceptions_pkg.raise_message
8601: (p_location => 'xla_journal_entries_pkg.update_distribution_link');
8602:
8603: END update_distribution_link;
8604:

Line 8712: WHEN xla_exceptions_pkg.application_exception THEN

8708: p_level => C_LEVEL_PROCEDURE);
8709: END IF;
8710:
8711: EXCEPTION
8712: WHEN xla_exceptions_pkg.application_exception THEN
8713: RAISE;
8714:
8715: WHEN OTHERS THEN
8716: xla_exceptions_pkg.raise_message

Line 8716: xla_exceptions_pkg.raise_message

8712: WHEN xla_exceptions_pkg.application_exception THEN
8713: RAISE;
8714:
8715: WHEN OTHERS THEN
8716: xla_exceptions_pkg.raise_message
8717: (p_location => 'xla_journal_entries_pkg.create_reversal_distr_link');
8718: END create_reversal_distr_link;
8719:
8720: FUNCTION is_reversal

Line 8786: WHEN xla_exceptions_pkg.application_exception THEN

8782: RETURN TRUE;
8783:
8784: END IF;
8785: EXCEPTION
8786: WHEN xla_exceptions_pkg.application_exception THEN
8787: RAISE;
8788:
8789: WHEN OTHERS THEN
8790: xla_exceptions_pkg.raise_message

Line 8790: xla_exceptions_pkg.raise_message

8786: WHEN xla_exceptions_pkg.application_exception THEN
8787: RAISE;
8788:
8789: WHEN OTHERS THEN
8790: xla_exceptions_pkg.raise_message
8791: (p_location => 'xla_journal_entries_pkg.is_reversal');
8792: END is_reversal;
8793:
8794: --

Line 8895: WHEN xla_exceptions_pkg.application_exception THEN

8891: p_level => C_LEVEL_PROCEDURE);
8892: END IF;
8893:
8894: EXCEPTION
8895: WHEN xla_exceptions_pkg.application_exception THEN
8896: RAISE;
8897:
8898: WHEN OTHERS THEN
8899: xla_exceptions_pkg.raise_message

Line 8899: xla_exceptions_pkg.raise_message

8895: WHEN xla_exceptions_pkg.application_exception THEN
8896: RAISE;
8897:
8898: WHEN OTHERS THEN
8899: xla_exceptions_pkg.raise_message
8900: (p_location => 'xla_journal_entries_pkg.get_rev_line_info');
8901: END get_rev_line_info;
8902:
8903: --

Line 9008: WHEN xla_exceptions_pkg.application_exception THEN

9004: p_level => C_LEVEL_PROCEDURE);
9005: END IF;
9006:
9007: EXCEPTION
9008: WHEN xla_exceptions_pkg.application_exception THEN
9009: RAISE;
9010:
9011: WHEN OTHERS THEN
9012: xla_exceptions_pkg.raise_message

Line 9012: xla_exceptions_pkg.raise_message

9008: WHEN xla_exceptions_pkg.application_exception THEN
9009: RAISE;
9010:
9011: WHEN OTHERS THEN
9012: xla_exceptions_pkg.raise_message
9013: (p_location => 'xla_journal_entries_pkg.get_mrc_rev_line_info');
9014: END get_mrc_rev_line_info;
9015:
9016: PROCEDURE IsReversible

Line 9045: xla_exceptions_pkg.raise_message

9041: close c_reversible;
9042:
9043: Exception
9044: WHEN OTHERS THEN
9045: xla_exceptions_pkg.raise_message
9046: (p_location => 'xla_journal_entries_pkg.isReversible');
9047: END IsReversible;
9048: --=============================================================================
9049: --