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.GL_LEDGERS_PKG dependencies on APP_EXCEPTION

Line 306: app_exception.raise_exception;

302: IF (period_counter = 1 AND v_first_ledger_period_name IS NOT NULL) THEN
303: EXIT;
304: ELSIF(v_first_ledger_period_name IS NULL) THEN
305: fnd_message.set_name('SQLGL', 'GL_LEDGER_ENABLE_STS_FLAG');
306: app_exception.raise_exception;
307: END IF;
308: period_counter := period_counter + 1;
309: END LOOP;
310: CLOSE first_ledger_period;

Line 316: app_exception.raise_exception;

312: -- Validate secondary tracking flag - Ledger API checks.
313: IF (x_enable_secondary_track_flag = 'Y') THEN
314: IF (FND_FLEX_APIS.get_qualifier_segnum(101,'GL#',x_chart_of_accounts_id,'GL_SECONDARY_TRACKING',temp) = FALSE) THEN
315: fnd_message.set_name('SQLGL', 'GL_API_LEDGER_CHK_SECD_SEG');
316: app_exception.raise_exception;
317: END IF;
318: IF(x_enable_avgbal_flag = 'Y') THEN
319: fnd_message.set_name('SQLGL', 'GL_LEDGER_ENABLE_STS_FLAG');
320: app_exception.raise_exception;

Line 320: app_exception.raise_exception;

316: app_exception.raise_exception;
317: END IF;
318: IF(x_enable_avgbal_flag = 'Y') THEN
319: fnd_message.set_name('SQLGL', 'GL_LEDGER_ENABLE_STS_FLAG');
320: app_exception.raise_exception;
321: END IF;
322: END IF;
323:
324: -- Validate secondary tracking for revaluation flag - Ledger API checks

Line 328: app_exception.raise_exception;

324: -- Validate secondary tracking for revaluation flag - Ledger API checks
325: IF (x_enable_reval_ss_track_flag = 'Y') THEN
326: IF (FND_FLEX_APIS.get_qualifier_segnum(101,'GL#',x_chart_of_accounts_id,'GL_SECONDARY_TRACKING',temp) = FALSE) THEN
327: fnd_message.set_name('SQLGL', 'GL_API_LEDGER_CHK_SECD_SEG');
328: app_exception.raise_exception;
329: END IF;
330: END IF;
331:
332: -- Create an implicit access set header for the corresponding new created

Line 935: app_exception.raise_exception;

931: -- Updating budgetary control flag from Y to N
932: IF ((recinfo.enable_budgetary_control_flag = 'Y') AND (x_enable_budgetary_control_f = 'N')) THEN
933: IF (GL_SUMMARY_TEMPLATES_PKG.is_funds_check_not_none(x_ledger_Id)) THEN
934: fnd_message.set_name('SQLGL', 'GL_DISABLE_BUDGETARY_CONTROL');
935: app_exception.raise_exception;
936: END IF;
937: IF (GL_BUD_ASSIGN_RANGE_PKG.is_funds_check_not_none(x_ledger_Id)) THEN
938: fnd_message.set_name('SQLGL', 'GL_DISABLE_BUDGETARY_CONTROL');
939: app_exception.raise_exception;

Line 939: app_exception.raise_exception;

935: app_exception.raise_exception;
936: END IF;
937: IF (GL_BUD_ASSIGN_RANGE_PKG.is_funds_check_not_none(x_ledger_Id)) THEN
938: fnd_message.set_name('SQLGL', 'GL_DISABLE_BUDGETARY_CONTROL');
939: app_exception.raise_exception;
940: END IF;
941: END IF;
942:
943: -- Updating budget journals flag from N to Y

Line 947: app_exception.raise_exception;

943: -- Updating budget journals flag from N to Y
944: IF ((recinfo.require_budget_journals_flag = 'N') AND (x_require_budget_journals_flag = 'Y')) THEN
945: IF (GL_BUDGETS_PKG.is_budget_journals_not_req(x_ledger_Id)) THEN
946: fnd_message.set_name('SQLGL', 'GL_FAIL_REQUIRE_BUDGET_JOURNAL');
947: app_exception.raise_exception;
948: END IF;
949: END IF;
950:
951: -- Updating average balances translation options

Line 957: app_exception.raise_exception;

953: (recinfo.translate_qatd_flag <> x_translate_qatd_flag) OR
954: (recinfo.translate_yatd_flag <> x_translate_yatd_flag)) THEN
955: IF (GL_LEDGERS_PKG.Check_Avg_Translation(x_ledger_Id)) THEN
956: fnd_message.set_name('SQLGL', 'GL_LEDGER_TRANSLATION_FLAGS');
957: app_exception.raise_exception;
958: END IF;
959: END IF;
960:
961: -- Updating MRC ledger type code from N to R or P

Line 964: -- app_exception.raise_exception;

960:
961: -- Updating MRC ledger type code from N to R or P
962: -- IF ((old_mrc_ledger_type_code <> 'N') AND (x_mrc_ledger_type_code <> old_mrc_ledger_type_code)) THEN
963: -- fnd_message.set_name('SQLGL', 'GL_API_LEDGER_MRC_SOB_NOT_UPDATE');
964: -- app_exception.raise_exception;
965: -- END IF;
966:
967: IF (recinfo.enable_reval_ss_track_flag = 'N' AND x_enable_reval_ss_track_flag = 'Y') THEN
968: IF (FND_FLEX_APIS.get_qualifier_segnum(101,'GL#',x_chart_of_accounts_id,'GL_SECONDARY_TRACKING',temp) = FALSE) THEN

Line 970: app_exception.raise_exception;

966:
967: IF (recinfo.enable_reval_ss_track_flag = 'N' AND x_enable_reval_ss_track_flag = 'Y') THEN
968: IF (FND_FLEX_APIS.get_qualifier_segnum(101,'GL#',x_chart_of_accounts_id,'GL_SECONDARY_TRACKING',temp) = FALSE) THEN
969: fnd_message.set_name('SQLGL', 'GL_API_LEDGER_CHK_SECD_SEG');
970: app_exception.raise_exception;
971: END IF;
972: END IF;
973: -- end of Ledger API checks.
974:

Line 1705: app_exception.raise_exception;

1701: IF c_dup%FOUND THEN
1702: CLOSE c_dup;
1703:
1704: fnd_message.set_name('SQLGL', 'GL_LEDGER_DUPLICATE_LEDGER');
1705: app_exception.raise_exception;
1706: END IF;
1707:
1708: CLOSE c_dup;
1709:

Line 1719: app_exception.raise_exception;

1715: IF c_dup2%FOUND THEN
1716: CLOSE c_dup2;
1717:
1718: fnd_message.set_name('SQLGL', 'GL_LEDGER_DUPLICATE_LEDGER');
1719: app_exception.raise_exception;
1720: END IF;
1721:
1722: CLOSE c_dup2;
1723: EXCEPTION

Line 1724: WHEN app_exceptions.application_exception THEN

1720: END IF;
1721:
1722: CLOSE c_dup2;
1723: EXCEPTION
1724: WHEN app_exceptions.application_exception THEN
1725: RAISE;
1726: WHEN OTHERS THEN
1727: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1728: fnd_message.set_token('PROCEDURE',

Line 1754: app_exception.raise_exception;

1750: IF c_dup%FOUND THEN
1751: CLOSE c_dup;
1752:
1753: fnd_message.set_name('SQLGL', 'GL_LEDGER_DUPLICATE_SHORT_NAME');
1754: app_exception.raise_exception;
1755: END IF;
1756:
1757: CLOSE c_dup;
1758: EXCEPTION

Line 1759: WHEN app_exceptions.application_exception THEN

1755: END IF;
1756:
1757: CLOSE c_dup;
1758: EXCEPTION
1759: WHEN app_exceptions.application_exception THEN
1760: RAISE;
1761: WHEN OTHERS THEN
1762: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1763: fnd_message.set_token('PROCEDURE',

Line 1791: app_exception.raise_exception;

1787: CLOSE c_getid;
1788:
1789: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
1790: fnd_message.set_token('SEQUENCE', 'GL_LEDGERS_S');
1791: app_exception.raise_exception;
1792: END IF;
1793: EXCEPTION
1794: WHEN app_exceptions.application_exception THEN
1795: RAISE;

Line 1794: WHEN app_exceptions.application_exception THEN

1790: fnd_message.set_token('SEQUENCE', 'GL_LEDGERS_S');
1791: app_exception.raise_exception;
1792: END IF;
1793: EXCEPTION
1794: WHEN app_exceptions.application_exception THEN
1795: RAISE;
1796: WHEN OTHERS THEN
1797: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1798: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.get_unique_id');

Line 1831: WHEN app_exceptions.application_exception THEN

1827: CLOSE c_is_coa_frozen;
1828:
1829: RETURN FALSE;
1830: EXCEPTION
1831: WHEN app_exceptions.application_exception THEN
1832: RAISE;
1833: WHEN OTHERS THEN
1834: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1835: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.is_coa_frozen');

Line 1885: app_exception.raise_exception;

1881:
1882: x_bal_seg_column_name := NULL;
1883: x_bal_seg_value_set_id := NULL;
1884: fnd_message.set_name('SQLGL', 'GL_LEDGER_ERR_GETTING_BAL_SEG');
1885: app_exception.raise_exception;
1886: END IF;
1887:
1888: OPEN c_get_mgt_seg_column_name;
1889:

Line 1903: --app_exception.raise_exception;

1899: x_mgt_seg_value_set_id := NULL;
1900: fnd_message.set_name('SQLGL', 'GL_LEDGER_ERR_GETTING_MGT_SEG');
1901: -- Now the management segment value is an optional segment
1902: -- commneted by Srini Pala.
1903: --app_exception.raise_exception;
1904: END IF;
1905: EXCEPTION
1906: WHEN app_exceptions.application_exception THEN
1907: RAISE;

Line 1906: WHEN app_exceptions.application_exception THEN

1902: -- commneted by Srini Pala.
1903: --app_exception.raise_exception;
1904: END IF;
1905: EXCEPTION
1906: WHEN app_exceptions.application_exception THEN
1907: RAISE;
1908: WHEN OTHERS THEN
1909: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1910: fnd_message.set_token('PROCEDURE',

Line 2422: app_exception.raise_exception;

2418: OR ((recinfo.attribute15 IS NULL) AND(x_attribute15 IS NULL)))) THEN
2419: RETURN;
2420: ELSE
2421: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2422: app_exception.raise_exception;
2423: END IF;
2424: END lock_row;
2425:
2426: -- **********************************************************************

Line 2979: app_exception.raise_exception;

2975: OR ((recinfo.attribute15 IS NULL) AND(x_attribute15 IS NULL)))) THEN
2976: RETURN;
2977: ELSE
2978: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2979: app_exception.raise_exception;
2980: END IF;
2981: END lock_set;
2982:
2983: -- **********************************************************************

Line 3230: app_exception.raise_exception;

3226: IF (return_value) THEN
3227: IF (Y_Account_Code = 'NET_INCOME') THEN
3228: IF (fnd_flex_keyval.column_value(1) <> 'N') THEN
3229: fnd_message.set_name('SQLGL', 'GL_NET_INCOME_COMBINATION');
3230: app_exception.raise_exception;
3231: ELSIF (fnd_flex_keyval.qualifier_value('DETAIL_POSTING_ALLOWED', 'D') <> 'N') THEN
3232: fnd_message.set_name('SQLGL', 'GL_NET_INCOME_SEGMENTS');
3233: app_exception.raise_exception;
3234: END IF;

Line 3233: app_exception.raise_exception;

3229: fnd_message.set_name('SQLGL', 'GL_NET_INCOME_COMBINATION');
3230: app_exception.raise_exception;
3231: ELSIF (fnd_flex_keyval.qualifier_value('DETAIL_POSTING_ALLOWED', 'D') <> 'N') THEN
3232: fnd_message.set_name('SQLGL', 'GL_NET_INCOME_SEGMENTS');
3233: app_exception.raise_exception;
3234: END IF;
3235: END IF;
3236: Y_CCID := fnd_flex_keyval.combination_id;
3237: ELSE