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 303: app_exception.raise_exception;

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

Line 313: app_exception.raise_exception;

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

Line 317: app_exception.raise_exception;

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

Line 325: app_exception.raise_exception;

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

Line 930: app_exception.raise_exception;

926: -- Updating budgetary control flag from Y to N
927: IF ((recinfo.enable_budgetary_control_flag = 'Y') AND (x_enable_budgetary_control_f = 'N')) THEN
928: IF (GL_SUMMARY_TEMPLATES_PKG.is_funds_check_not_none(x_ledger_Id)) THEN
929: fnd_message.set_name('SQLGL', 'GL_DISABLE_BUDGETARY_CONTROL');
930: app_exception.raise_exception;
931: END IF;
932: IF (GL_BUD_ASSIGN_RANGE_PKG.is_funds_check_not_none(x_ledger_Id)) THEN
933: fnd_message.set_name('SQLGL', 'GL_DISABLE_BUDGETARY_CONTROL');
934: app_exception.raise_exception;

Line 934: app_exception.raise_exception;

930: app_exception.raise_exception;
931: END IF;
932: IF (GL_BUD_ASSIGN_RANGE_PKG.is_funds_check_not_none(x_ledger_Id)) THEN
933: fnd_message.set_name('SQLGL', 'GL_DISABLE_BUDGETARY_CONTROL');
934: app_exception.raise_exception;
935: END IF;
936: END IF;
937:
938: -- Updating budget journals flag from N to Y

Line 942: app_exception.raise_exception;

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

Line 952: app_exception.raise_exception;

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

Line 959: -- app_exception.raise_exception;

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

Line 965: app_exception.raise_exception;

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

Line 1698: app_exception.raise_exception;

1694: IF c_dup%FOUND THEN
1695: CLOSE c_dup;
1696:
1697: fnd_message.set_name('SQLGL', 'GL_LEDGER_DUPLICATE_LEDGER');
1698: app_exception.raise_exception;
1699: END IF;
1700:
1701: CLOSE c_dup;
1702:

Line 1712: app_exception.raise_exception;

1708: IF c_dup2%FOUND THEN
1709: CLOSE c_dup2;
1710:
1711: fnd_message.set_name('SQLGL', 'GL_LEDGER_DUPLICATE_LEDGER');
1712: app_exception.raise_exception;
1713: END IF;
1714:
1715: CLOSE c_dup2;
1716: EXCEPTION

Line 1717: WHEN app_exceptions.application_exception THEN

1713: END IF;
1714:
1715: CLOSE c_dup2;
1716: EXCEPTION
1717: WHEN app_exceptions.application_exception THEN
1718: RAISE;
1719: WHEN OTHERS THEN
1720: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1721: fnd_message.set_token('PROCEDURE',

Line 1747: app_exception.raise_exception;

1743: IF c_dup%FOUND THEN
1744: CLOSE c_dup;
1745:
1746: fnd_message.set_name('SQLGL', 'GL_LEDGER_DUPLICATE_SHORT_NAME');
1747: app_exception.raise_exception;
1748: END IF;
1749:
1750: CLOSE c_dup;
1751: EXCEPTION

Line 1752: WHEN app_exceptions.application_exception THEN

1748: END IF;
1749:
1750: CLOSE c_dup;
1751: EXCEPTION
1752: WHEN app_exceptions.application_exception THEN
1753: RAISE;
1754: WHEN OTHERS THEN
1755: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1756: fnd_message.set_token('PROCEDURE',

Line 1784: app_exception.raise_exception;

1780: CLOSE c_getid;
1781:
1782: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
1783: fnd_message.set_token('SEQUENCE', 'GL_LEDGERS_S');
1784: app_exception.raise_exception;
1785: END IF;
1786: EXCEPTION
1787: WHEN app_exceptions.application_exception THEN
1788: RAISE;

Line 1787: WHEN app_exceptions.application_exception THEN

1783: fnd_message.set_token('SEQUENCE', 'GL_LEDGERS_S');
1784: app_exception.raise_exception;
1785: END IF;
1786: EXCEPTION
1787: WHEN app_exceptions.application_exception THEN
1788: RAISE;
1789: WHEN OTHERS THEN
1790: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1791: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.get_unique_id');

Line 1824: WHEN app_exceptions.application_exception THEN

1820: CLOSE c_is_coa_frozen;
1821:
1822: RETURN FALSE;
1823: EXCEPTION
1824: WHEN app_exceptions.application_exception THEN
1825: RAISE;
1826: WHEN OTHERS THEN
1827: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1828: fnd_message.set_token('PROCEDURE', 'GL_LEDGERS_PKG.is_coa_frozen');

Line 1878: app_exception.raise_exception;

1874:
1875: x_bal_seg_column_name := NULL;
1876: x_bal_seg_value_set_id := NULL;
1877: fnd_message.set_name('SQLGL', 'GL_LEDGER_ERR_GETTING_BAL_SEG');
1878: app_exception.raise_exception;
1879: END IF;
1880:
1881: OPEN c_get_mgt_seg_column_name;
1882:

Line 1896: --app_exception.raise_exception;

1892: x_mgt_seg_value_set_id := NULL;
1893: fnd_message.set_name('SQLGL', 'GL_LEDGER_ERR_GETTING_MGT_SEG');
1894: -- Now the management segment value is an optional segment
1895: -- commneted by Srini Pala.
1896: --app_exception.raise_exception;
1897: END IF;
1898: EXCEPTION
1899: WHEN app_exceptions.application_exception THEN
1900: RAISE;

Line 1899: WHEN app_exceptions.application_exception THEN

1895: -- commneted by Srini Pala.
1896: --app_exception.raise_exception;
1897: END IF;
1898: EXCEPTION
1899: WHEN app_exceptions.application_exception THEN
1900: RAISE;
1901: WHEN OTHERS THEN
1902: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1903: fnd_message.set_token('PROCEDURE',

Line 2413: app_exception.raise_exception;

2409: OR ((recinfo.attribute15 IS NULL) AND(x_attribute15 IS NULL)))) THEN
2410: RETURN;
2411: ELSE
2412: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2413: app_exception.raise_exception;
2414: END IF;
2415: END lock_row;
2416:
2417: -- **********************************************************************

Line 2969: app_exception.raise_exception;

2965: OR ((recinfo.attribute15 IS NULL) AND(x_attribute15 IS NULL)))) THEN
2966: RETURN;
2967: ELSE
2968: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
2969: app_exception.raise_exception;
2970: END IF;
2971: END lock_set;
2972:
2973: -- **********************************************************************

Line 3220: app_exception.raise_exception;

3216: IF (return_value) THEN
3217: IF (Y_Account_Code = 'NET_INCOME') THEN
3218: IF (fnd_flex_keyval.column_value(1) <> 'N') THEN
3219: fnd_message.set_name('SQLGL', 'GL_NET_INCOME_COMBINATION');
3220: app_exception.raise_exception;
3221: ELSIF (fnd_flex_keyval.qualifier_value('DETAIL_POSTING_ALLOWED', 'D') <> 'N') THEN
3222: fnd_message.set_name('SQLGL', 'GL_NET_INCOME_SEGMENTS');
3223: app_exception.raise_exception;
3224: END IF;

Line 3223: app_exception.raise_exception;

3219: fnd_message.set_name('SQLGL', 'GL_NET_INCOME_COMBINATION');
3220: app_exception.raise_exception;
3221: ELSIF (fnd_flex_keyval.qualifier_value('DETAIL_POSTING_ALLOWED', 'D') <> 'N') THEN
3222: fnd_message.set_name('SQLGL', 'GL_NET_INCOME_SEGMENTS');
3223: app_exception.raise_exception;
3224: END IF;
3225: END IF;
3226: Y_CCID := fnd_flex_keyval.combination_id;
3227: ELSE