DBA Data[Home] [Help]

APPS.GL_PERIODS_PKG dependencies on FND_MESSAGE

Line 294: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_PERIOD_NUMBER');

290: FETCH chk_duplicates INTO dummy;
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;

Line 304: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
306: RAISE;
307: END check_unique_num;
308:

Line 305: fnd_message.set_token('PROCEDURE', 'PERIODS.check_unique_num');

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');
306: RAISE;
307: END check_unique_num;
308:
309:

Line 328: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_PERIOD_NAME');

324: FETCH chk_duplicates INTO dummy;
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;

Line 338: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
340: RAISE;
341: END check_unique_name;
342:

Line 339: fnd_message.set_token('PROCEDURE', 'PERIODS.check_unique_name');

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');
340: RAISE;
341: END check_unique_name;
342:
343:

Line 371: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

367: CLOSE get_data;
368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
372: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');
373: fnd_message.set_token('EVENT', 'Getting data');
374: RAISE;
375: END;

Line 372: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');

368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
372: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');
373: fnd_message.set_token('EVENT', 'Getting data');
374: RAISE;
375: END;
376:

Line 373: fnd_message.set_token('EVENT', 'Getting data');

369: EXCEPTION
370: WHEN OTHERS THEN
371: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
372: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');
373: fnd_message.set_token('EVENT', 'Getting data');
374: RAISE;
375: END;
376:
377: -- Check for use with actuals

Line 405: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
407: fnd_message.set_token('EVENT', 'Checking Actuals');
408: RAISE;
409: END;

Line 406: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');

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');
407: fnd_message.set_token('EVENT', 'Checking Actuals');
408: RAISE;
409: END;
410:

Line 407: fnd_message.set_token('EVENT', 'Checking Actuals');

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');
407: fnd_message.set_token('EVENT', 'Checking Actuals');
408: RAISE;
409: END;
410:
411: -- Check for use with budgets

Line 443: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
445: fnd_message.set_token('EVENT', 'Checking Budgets');
446: RAISE;
447: END;

Line 444: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');

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');
445: fnd_message.set_token('EVENT', 'Checking Budgets');
446: RAISE;
447: END;
448:

Line 445: fnd_message.set_token('EVENT', 'Checking Budgets');

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');
445: fnd_message.set_token('EVENT', 'Checking Budgets');
446: RAISE;
447: END;
448:
449: -- Check for use with encumbrances

Line 474: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
476: fnd_message.set_token('EVENT', 'Checking Encumbrances');
477: RAISE;
478: END;

Line 475: fnd_message.set_token('PROCEDURE', 'PERIODS.check_period_used');

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');
476: fnd_message.set_token('EVENT', 'Checking Encumbrances');
477: RAISE;
478: END;
479:

Line 476: fnd_message.set_token('EVENT', 'Checking Encumbrances');

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');
476: fnd_message.set_token('EVENT', 'Checking Encumbrances');
477: RAISE;
478: END;
479:
480: -- Check period used by projects

Line 612: fnd_message.set_name('SQLGL', 'GL_LOAD_ROW_NO_DATA');

608: BEGIN
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

Line 733: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

729: BEGIN
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

Line 738: 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');
739: app_exception.raise_exception;
740: END IF;
741:
742: IF (X_Adjustment_Period_Flag = 'N') THEN

Line 751: fnd_message.set_name('SQLGL', 'GL_CALENDAR_OVERLAP_PERIODS');

747: X_Start_Date,
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

Line 972: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

968: AND (X_Adjustment_Period_Flag IS NULL)))
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:

Line 1032: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_IN_USE');

1028: X_Quarter_Num,
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:

Line 1039: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

1035: END IF;
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

Line 1044: 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');
1045: app_exception.raise_exception;
1046: END IF;
1047:
1048: -- If this is not an adjusting period, then verify that this period

Line 1057: fnd_message.set_name('SQLGL', 'GL_CALENDAR_OVERLAP_PERIODS');

1053: X_Start_Date,
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:

Line 1214: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_IN_USE');

1210: CLOSE get_old_name;
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

Line 1415: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

1411: END IF;
1412:
1413: EXCEPTION
1414: WHEN OTHERS THEN
1415: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1416: fnd_message.set_token('PROCEDURE',
1417: 'gl_periods_pkg.period_set_with_AB');
1418: RAISE;
1419:

Line 1416: fnd_message.set_token('PROCEDURE',

1412:
1413: EXCEPTION
1414: WHEN OTHERS THEN
1415: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1416: fnd_message.set_token('PROCEDURE',
1417: 'gl_periods_pkg.period_set_with_AB');
1418: RAISE;
1419:
1420: END period_set_with_AB;

Line 1450: fnd_message.set_name('SQLGL', 'GL_AB_PERIOD_LASTS_M_35');

1446:
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

Line 1648: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

1644: FETCH check_period_num INTO v_number_per_fiscal_year;
1645:
1646: IF check_period_num%NOTFOUND THEN
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

Line 1649: fnd_message.set_token('VALUE', Y_Period_Type);

1645:
1646: IF check_period_num%NOTFOUND THEN
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;

Line 1650: fnd_message.set_token('ATTRIBUTE', 'PeriodType');

1646: IF check_period_num%NOTFOUND THEN
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;

Line 1657: fnd_message.set_name('SQLGL', 'GL_PERIOD_NUMBER_LESS_THAN_MAX');

1653: CLOSE check_period_num;
1654: END IF;
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:

Line 1658: fnd_message.set_token('MAX_NUM', v_number_per_fiscal_year);

1654: END IF;
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.

Line 1664: fnd_message.set_name('SQLGL', 'GL_CALENDAR_NAME_NO_SPACES');

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
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

Line 1669: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

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');
1670: app_exception.raise_exception;
1671: END IF;
1672:
1673: IF (instr(Y_entered_period_name, '''') <> 0) THEN

Line 1674: 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');
1675: app_exception.raise_exception;
1676: END IF;
1677:
1678: -- Call the forms table handler.

Line 1711: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
1713: RAISE;
1714: END Insert_Period;
1715:

Line 1712: fnd_message.set_token('PROCEDURE', 'GL_PERIODS_PKG.Insert_Period');

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');
1713: RAISE;
1714: END Insert_Period;
1715:
1716: PROCEDURE Update_Period(Y_Rowid IN OUT NOCOPY VARCHAR2,

Line 1808: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_IN_USE');

1804: (old_period_num <> Y_Period_Num) OR
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:

Line 1815: fnd_message.set_name('SQLGL', 'GL_API_UPDATE_NOT_ALLOWED');

1811: END IF;
1812:
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:

Line 1816: fnd_message.set_token('ATTRIBUTE', 'UserPeriodType');

1812:
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.

Line 1833: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');

1829: OPEN check_period_num;
1830: FETCH check_period_num INTO v_number_per_fiscal_year;
1831:
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

Line 1834: fnd_message.set_token('VALUE', Y_Period_Type);

1830: FETCH check_period_num INTO v_number_per_fiscal_year;
1831:
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;

Line 1835: fnd_message.set_token('ATTRIBUTE', 'PeriodType');

1831:
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;

Line 1842: fnd_message.set_name('SQLGL', 'GL_PERIOD_NUMBER_LESS_THAN_MAX');

1838: CLOSE check_period_num;
1839: END IF;
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:

Line 1843: fnd_message.set_token('MAX_NUM', v_number_per_fiscal_year);

1839: END IF;
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.

Line 1849: fnd_message.set_name('SQLGL', 'GL_CALENDAR_NAME_NO_SPACES');

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
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

Line 1854: fnd_message.set_name('SQLGL', 'GL_CALENDAR_PERIOD_WITH_QUOTE');

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');
1855: app_exception.raise_exception;
1856: END IF;
1857:
1858: IF (instr(Y_entered_period_name, '''') <> 0) THEN

Line 1859: 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');
1860: app_exception.raise_exception;
1861: END IF;
1862:
1863: -- Call the forms table handler.

Line 1894: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

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');
1896: RAISE;
1897: END Update_Period;
1898:

Line 1895: fnd_message.set_token('PROCEDURE', 'GL_PERIODS_PKG.Update_Period');

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');
1896: RAISE;
1897: END Update_Period;
1898:
1899: END gl_periods_pkg;