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_PERIODS_PKG dependencies on APP_EXCEPTION

Line 295: app_exception.raise_exception;

291:
292: IF chk_duplicates%FOUND THEN
293: CLOSE chk_duplicates;
294: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_PERIOD_NUMBER');
295: app_exception.raise_exception;
296: END IF;
297:
298: CLOSE chk_duplicates;
299:

Line 301: WHEN app_exceptions.application_exception THEN

297:
298: CLOSE chk_duplicates;
299:
300: EXCEPTION
301: WHEN app_exceptions.application_exception THEN
302: RAISE;
303: WHEN OTHERS THEN
304: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
305: fnd_message.set_token('PROCEDURE', 'PERIODS.check_unique_num');

Line 329: app_exception.raise_exception;

325:
326: IF (chk_duplicates%FOUND) THEN
327: CLOSE chk_duplicates;
328: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_PERIOD_NAME');
329: app_exception.raise_exception;
330: END IF;
331:
332: CLOSE chk_duplicates;
333:

Line 335: WHEN app_exceptions.application_exception THEN

331:
332: CLOSE chk_duplicates;
333:
334: EXCEPTION
335: WHEN app_exceptions.application_exception THEN
336: RAISE;
337: WHEN OTHERS THEN
338: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
339: fnd_message.set_token('PROCEDURE', 'PERIODS.check_unique_name');

Line 402: WHEN app_exceptions.application_exception THEN

398:
399: CLOSE chk_actual;
400:
401: EXCEPTION
402: WHEN app_exceptions.application_exception THEN
403: RAISE;
404: WHEN OTHERS THEN
405: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
406: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');

Line 440: WHEN app_exceptions.application_exception THEN

436:
437: CLOSE chk_budget;
438:
439: EXCEPTION
440: WHEN app_exceptions.application_exception THEN
441: RAISE;
442: WHEN OTHERS THEN
443: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
444: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');

Line 471: WHEN app_exceptions.application_exception THEN

467:
468: CLOSE chk_encumbrance;
469:
470: EXCEPTION
471: WHEN app_exceptions.application_exception THEN
472: RAISE;
473: WHEN OTHERS THEN
474: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
475: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');

Line 613: app_exception.raise_exception;

609: -- validate input parameters
610: if ( X_Period_Set_Name is null) then
611:
612: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');
613: app_exception.raise_exception;
614: end if;
615:
616: if (X_OWNER = 'SEED') then
617: user_id := 1;

Line 734: app_exception.raise_exception;

730:
731:
732: IF (instr(X_period_name, '''') <> 0) THEN
733: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');
734: app_exception.raise_exception;
735: END IF;
736:
737: IF (instr(X_entered_period_name, '''') <> 0) THEN
738: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

Line 739: app_exception.raise_exception;

735: END IF;
736:
737: IF (instr(X_entered_period_name, '''') <> 0) THEN
738: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');
739: app_exception.raise_exception;
740: END IF;
741:
742: IF (X_Adjustment_Period_Flag = 'N') THEN
743: -- If this is not an adjusting period, then verify that this period

Line 752: app_exception.raise_exception;

748: X_End_Date,
749: null)
750: ) THEN
751: fnd_message.set_name('SQLGL', 'GL_CALENDAR_OVERLAP_PERIODS');
752: app_exception.raise_exception;
753: END IF;
754:
755: -- Reset the maximum length, if necessary
756: fix_max_len('I', X_Period_Type, NULL, NULL, X_End_Date - X_Start_Date + 1);

Line 973: APP_EXCEPTION.RAISE_EXCEPTION;

969: ) then
970: return;
971: else
972: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
973: APP_EXCEPTION.RAISE_EXCEPTION;
974: end if;
975: END Lock_Row;
976:
977: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 1033: app_exception.raise_exception;

1029: X_Entered_Period_Name,
1030: X_Description)) THEN
1031: IF (gl_periods_pkg.check_period_used(X_Rowid)) THEN
1032: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_IN_USE');
1033: app_exception.raise_exception;
1034: END IF;
1035: END IF;
1036:
1037:

Line 1040: app_exception.raise_exception;

1036:
1037:
1038: IF (instr(X_period_name, '''') <> 0) THEN
1039: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');
1040: app_exception.raise_exception;
1041: END IF;
1042:
1043: IF (instr(X_entered_period_name, '''') <> 0) THEN
1044: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

Line 1045: app_exception.raise_exception;

1041: END IF;
1042:
1043: IF (instr(X_entered_period_name, '''') <> 0) THEN
1044: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');
1045: app_exception.raise_exception;
1046: END IF;
1047:
1048: -- If this is not an adjusting period, then verify that this period
1049: -- does not overlap with any other periods

Line 1058: app_exception.raise_exception;

1054: X_End_Date,
1055: X_RowId)
1056: ) THEN
1057: fnd_message.set_name('SQLGL', 'GL_CALENDAR_OVERLAP_PERIODS');
1058: app_exception.raise_exception;
1059: END IF;
1060: END IF;
1061:
1062:

Line 1215: app_exception.raise_exception;

1211:
1212: -- Make sure the period has never been used
1213: IF (gl_periods_pkg.check_period_used(X_Rowid)) THEN
1214: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_IN_USE');
1215: app_exception.raise_exception;
1216: END IF;
1217:
1218: IF (X_Adjustment_Period_Flag = 'N') THEN
1219: -- Reset the maximum length, if necessary

Line 1451: app_exception.raise_exception;

1447: -- check if a period has more than 35 days
1448: IF( x_start_date_new - x_end_date + 1 > 35
1449: AND period_set_with_AB(x_period_set_name) = 'YES') THEN
1450: fnd_message.set_name('SQLGL', 'GL_AB_PERIOD_LASTS_M_35');
1451: app_exception.raise_exception;
1452: END IF;
1453:
1454: -- populate GL_TRANSACTION_DATES table
1455: entered_year := TO_CHAR(x_end_date, 'YYYY');

Line 1651: app_exception.raise_exception;

1647: CLOSE check_period_num;
1648: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
1649: fnd_message.set_token('VALUE', Y_Period_Type);
1650: fnd_message.set_token('ATTRIBUTE', 'PeriodType');
1651: app_exception.raise_exception;
1652: ELSE
1653: CLOSE check_period_num;
1654: END IF;
1655:

Line 1659: app_exception.raise_exception;

1655:
1656: IF (Y_Period_Num < 1 OR Y_Period_Num > v_number_per_fiscal_year) THEN
1657: fnd_message.set_name('SQLGL', 'GL_PERIOD_NUMBER_LESS_THAN_MAX');
1658: fnd_message.set_token('MAX_NUM', v_number_per_fiscal_year);
1659: app_exception.raise_exception;
1660: END IF;
1661:
1662: -- Check that the Entered Period Name does not contain any spaces.
1663: IF (INSTR(Y_Entered_Period_Name,' ') <> 0) THEN

Line 1665: app_exception.raise_exception;

1661:
1662: -- Check that the Entered Period Name does not contain any spaces.
1663: IF (INSTR(Y_Entered_Period_Name,' ') <> 0) THEN
1664: fnd_message.set_name('SQLGL', 'GL_CALENDAR_NAME_NO_SPACES');
1665: app_exception.raise_exception;
1666: END IF;
1667:
1668: IF (instr(Y_period_name, '''') <> 0) THEN
1669: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

Line 1670: app_exception.raise_exception;

1666: END IF;
1667:
1668: IF (instr(Y_period_name, '''') <> 0) THEN
1669: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');
1670: app_exception.raise_exception;
1671: END IF;
1672:
1673: IF (instr(Y_entered_period_name, '''') <> 0) THEN
1674: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

Line 1675: app_exception.raise_exception;

1671: END IF;
1672:
1673: IF (instr(Y_entered_period_name, '''') <> 0) THEN
1674: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');
1675: app_exception.raise_exception;
1676: END IF;
1677:
1678: -- Call the forms table handler.
1679: GL_PERIODS_PKG.Insert_Row(Y_Rowid,

Line 1708: WHEN app_exceptions.application_exception THEN

1704: Y_Adjustment_Period_Flag
1705: );
1706:
1707: EXCEPTION
1708: WHEN app_exceptions.application_exception THEN
1709: RAISE;
1710: WHEN OTHERS THEN
1711: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1712: fnd_message.set_token('PROCEDURE', 'GL_PERIODS_PKG.Insert_Period');

Line 1809: app_exception.raise_exception;

1805: (old_quarter_num <> Y_Quarter_Num) OR
1806: (old_entered_period_name <> Y_Entered_Period_Name) OR
1807: (old_adjustment_period_flag <> Y_Adjustment_Period_Flag)) THEN
1808: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_IN_USE');
1809: app_exception.raise_exception;
1810: END IF;
1811: END IF;
1812:
1813: -- Cannot update the period type.

Line 1817: app_exception.raise_exception;

1813: -- Cannot update the period type.
1814: IF (old_period_type <> Y_Period_Type) THEN
1815: fnd_message.set_name('SQLGL', 'GL_API_UPDATE_NOT_ALLOWED');
1816: fnd_message.set_token('ATTRIBUTE', 'UserPeriodType');
1817: app_exception.raise_exception;
1818: END IF;
1819:
1820: -- Check Unique Combination.
1821: GL_PERIODS_PKG.check_unique_num(calendar_name => Y_Period_Set_Name,

Line 1836: app_exception.raise_exception;

1832: IF check_period_num%NOTFOUND THEN
1833: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
1834: fnd_message.set_token('VALUE', Y_Period_Type);
1835: fnd_message.set_token('ATTRIBUTE', 'PeriodType');
1836: app_exception.raise_exception;
1837: ELSE
1838: CLOSE check_period_num;
1839: END IF;
1840:

Line 1844: app_exception.raise_exception;

1840:
1841: IF (Y_Period_Num < 1 OR Y_Period_Num > v_number_per_fiscal_year) THEN
1842: fnd_message.set_name('SQLGL', 'GL_PERIOD_NUMBER_LESS_THAN_MAX');
1843: fnd_message.set_token('MAX_NUM', v_number_per_fiscal_year);
1844: app_exception.raise_exception;
1845: END IF;
1846:
1847: -- Check that the Entered Period Name does not contain any spaces.
1848: IF (INSTR(Y_Entered_Period_Name,' ') <> 0) THEN

Line 1850: app_exception.raise_exception;

1846:
1847: -- Check that the Entered Period Name does not contain any spaces.
1848: IF (INSTR(Y_Entered_Period_Name,' ') <> 0) THEN
1849: fnd_message.set_name('SQLGL', 'GL_CALENDAR_NAME_NO_SPACES');
1850: app_exception.raise_exception;
1851: END IF;
1852:
1853: IF (instr(Y_period_name, '''') <> 0) THEN
1854: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

Line 1855: app_exception.raise_exception;

1851: END IF;
1852:
1853: IF (instr(Y_period_name, '''') <> 0) THEN
1854: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');
1855: app_exception.raise_exception;
1856: END IF;
1857:
1858: IF (instr(Y_entered_period_name, '''') <> 0) THEN
1859: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

Line 1860: app_exception.raise_exception;

1856: END IF;
1857:
1858: IF (instr(Y_entered_period_name, '''') <> 0) THEN
1859: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');
1860: app_exception.raise_exception;
1861: END IF;
1862:
1863: -- Call the forms table handler.
1864: GL_PERIODS_PKG.Update_Row(Y_Rowid,

Line 1891: WHEN app_exceptions.application_exception THEN

1887: Y_Adjustment_Period_Flag
1888: );
1889:
1890: EXCEPTION
1891: WHEN app_exceptions.application_exception THEN
1892: RAISE;
1893: WHEN OTHERS THEN
1894: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1895: fnd_message.set_token('PROCEDURE', 'GL_PERIODS_PKG.Update_Period');