DBA Data[Home] [Help]

APPS.GL_BUD_ASSIGN_RANGE_PKG dependencies on APP_EXCEPTION

Line 39: WHEN app_exceptions.application_exception THEN

35:
36: CLOSE c_no_fc;
37:
38: EXCEPTION
39: WHEN app_exceptions.application_exception THEN
40: RAISE;
41: WHEN OTHERS THEN
42: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
43: fnd_message.set_token('PROCEDURE',

Line 67: app_exception.raise_exception;

63:
64: IF chk_duplicates%FOUND THEN
65: CLOSE chk_duplicates;
66: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_BUD_RANGE_SEQ');
67: app_exception.raise_exception;
68: END IF;
69:
70: CLOSE chk_duplicates;
71:

Line 73: WHEN app_exceptions.application_exception THEN

69:
70: CLOSE chk_duplicates;
71:
72: EXCEPTION
73: WHEN app_exceptions.application_exception THEN
74: RAISE;
75: WHEN OTHERS THEN
76: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
77: fnd_message.set_token('PROCEDURE',

Line 97: app_exception.raise_exception;

93:
94: IF NOT lock_rng%FOUND THEN
95: CLOSE lock_rng;
96: fnd_message.set_name('SQLGL', 'GL_BUDORG_CANNOT_LOCK_RANGE');
97: app_exception.raise_exception;
98: END IF;
99:
100: CLOSE lock_rng;
101:

Line 103: WHEN app_exceptions.application_exception THEN

99:
100: CLOSE lock_rng;
101:
102: EXCEPTION
103: WHEN app_exceptions.application_exception THEN
104: RAISE;
105: WHEN OTHERS THEN
106: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
107: fnd_message.set_token('PROCEDURE',

Line 304: app_exception.raise_exception;

300: ELSE
301: CLOSE get_new_id;
302: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
303: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_ASSIGNMENT_RANGES_S');
304: app_exception.raise_exception;
305: END IF;
306: L_Status := X_Status;
307: END IF;
308:

Line 323: app_exception.raise_exception;

319:
320: IF check_overlaps%FOUND THEN
321: CLOSE check_overlaps;
322: fnd_message.set_name('SQLGL', 'GL_BUDORG_RANGES_OVERLAP');
323: app_exception.raise_exception;
324: ELSE
325: CLOSE check_overlaps;
326: END IF;
327:

Line 872: APP_EXCEPTION.RAISE_EXCEPTION;

868: ) then
869: return;
870: else
871: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
872: APP_EXCEPTION.RAISE_EXCEPTION;
873: end if;
874: else
875: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
876: APP_EXCEPTION.RAISE_EXCEPTION;

Line 876: APP_EXCEPTION.RAISE_EXCEPTION;

872: APP_EXCEPTION.RAISE_EXCEPTION;
873: end if;
874: else
875: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
876: APP_EXCEPTION.RAISE_EXCEPTION;
877: end if;
878: END Lock_Row;
879:
880: PROCEDURE Update_Row(X_Rowid VARCHAR2,

Line 1213: app_exception.raise_exception;

1209: CLOSE check_entry_code;
1210: fnd_message.set_name('SQLGL', 'GL_API_VALUE_NOT_EXIST');
1211: fnd_message.set_token('VALUE', X_Entry_Code);
1212: fnd_message.set_token('ATTRIBUTE', 'EntryCode');
1213: app_exception.raise_exception;
1214: END IF;
1215: CLOSE check_entry_code;
1216:
1217: -- Validate Budget Name

Line 1224: app_exception.raise_exception;

1220: IF check_bud_org_name%FOUND THEN
1221: CLOSE check_bud_org_name;
1222: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_RANGES_FOR_ALL');
1223: fnd_message.set_token('ALL', dummy);
1224: app_exception.raise_exception;
1225: END IF;
1226: CLOSE check_bud_org_name;
1227:
1228: -- Validate currency_code exists and is enabled in FND_CURRENCIES

Line 1246: app_exception.raise_exception;

1242: IF (X_Entry_Code = 'C') THEN
1243: IF ((X_Currency_Code <> L_Functional_Currency) AND
1244: (X_Currency_Code <> 'STAT')) THEN
1245: fnd_message.set_name('SQLGL', 'GL_API_BUDORG_CALC_CURR_ERR');
1246: app_exception.raise_exception;
1247: END IF;
1248: END IF;
1249:
1250: -- Validate that the currency selected is an active currency.

Line 1256: app_exception.raise_exception;

1252: FETCH active_currencies INTO dummy;
1253: IF active_currencies%NOTFOUND THEN
1254: CLOSE active_currencies;
1255: fnd_message.set_name('SQLGL', 'GL_API_INVALID_CURR');
1256: app_exception.raise_exception;
1257: END IF;
1258: CLOSE active_currencies;
1259:
1260:

Line 1354: WHEN app_exceptions.application_exception THEN

1350: X_Attribute15,
1351: L_Chart_Of_Accounts_Id);
1352:
1353: EXCEPTION
1354: WHEN app_exceptions.application_exception THEN
1355: RAISE;
1356: WHEN OTHERS THEN
1357: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1358: fnd_message.set_token('PROCEDURE',