DBA Data[Home] [Help]

APPS.GL_ARCH_PRG_FROM_PRD_PKG dependencies on FND_MESSAGE

Line 51: fnd_message.set_name('SQLGL', 'GL_PERIOD_NOT_PERM_CLOSED');

47:
48: IF get_from_period%FOUND THEN
49: CLOSE get_from_period;
50: IF (x_closing_status <> 'P') THEN
51: fnd_message.set_name('SQLGL', 'GL_PERIOD_NOT_PERM_CLOSED');
52: app_exception.raise_exception;
53: END IF;
54: ELSE
55: x_closing_status := 'N';

Line 57: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');

53: END IF;
54: ELSE
55: x_closing_status := 'N';
56: CLOSE get_from_period;
57: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
58: app_exception.raise_exception;
59: END IF;
60:
61: EXCEPTION

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

61: EXCEPTION
62: WHEN app_exceptions.application_exception THEN
63: RAISE;
64: WHEN OTHERS THEN
65: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
66: fnd_message.set_token('PROCEDURE',
67: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_act_arch');
68: RAISE;
69: END get_from_prd_bal_act_arch;

Line 66: fnd_message.set_token('PROCEDURE',

62: WHEN app_exceptions.application_exception THEN
63: RAISE;
64: WHEN OTHERS THEN
65: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
66: fnd_message.set_token('PROCEDURE',
67: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_act_arch');
68: RAISE;
69: END get_from_prd_bal_act_arch;
70:

Line 127: fnd_message.set_name('SQLGL', 'GL_PERIOD_NOT_PERM_CLOSED');

123:
124: IF get_from_period%FOUND THEN
125: CLOSE get_from_period;
126: IF (x_closing_status <> 'P') THEN
127: fnd_message.set_name('SQLGL', 'GL_PERIOD_NOT_PERM_CLOSED');
128: app_exception.raise_exception;
129: END IF;
130: ELSE
131: CLOSE get_from_period;

Line 133: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');

129: END IF;
130: ELSE
131: CLOSE get_from_period;
132: x_closing_status := 'N';
133: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
134: app_exception.raise_exception;
135: END IF;
136:
137: EXCEPTION

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

137: EXCEPTION
138: WHEN app_exceptions.application_exception THEN
139: RAISE;
140: WHEN OTHERS THEN
141: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
142: fnd_message.set_token('PROCEDURE',
143: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_act_purg');
144: RAISE;
145: END get_from_prd_bal_act_purg;

Line 142: fnd_message.set_token('PROCEDURE',

138: WHEN app_exceptions.application_exception THEN
139: RAISE;
140: WHEN OTHERS THEN
141: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
142: fnd_message.set_token('PROCEDURE',
143: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_act_purg');
144: RAISE;
145: END get_from_prd_bal_act_purg;
146:

Line 193: fnd_message.set_name('SQLGL', 'GL_PERIOD_NOT_PERM_CLOSED');

189:
190: IF get_from_period%FOUND THEN
191: CLOSE get_from_period;
192: IF (x_closing_status <> 'P') THEN
193: fnd_message.set_name('SQLGL', 'GL_PERIOD_NOT_PERM_CLOSED');
194: app_exception.raise_exception;
195: END IF;
196: ELSE
197: x_closing_status := 'N';

Line 199: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');

195: END IF;
196: ELSE
197: x_closing_status := 'N';
198: CLOSE get_from_period;
199: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
200: app_exception.raise_exception;
201: END IF;
202:
203: EXCEPTION

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

203: EXCEPTION
204: WHEN app_exceptions.application_exception THEN
205: RAISE;
206: WHEN OTHERS THEN
207: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
208: fnd_message.set_token('PROCEDURE',
209: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_act_both');
210: RAISE;
211: END get_from_prd_bal_act_both;

Line 208: fnd_message.set_token('PROCEDURE',

204: WHEN app_exceptions.application_exception THEN
205: RAISE;
206: WHEN OTHERS THEN
207: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
208: fnd_message.set_token('PROCEDURE',
209: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_act_both');
210: RAISE;
211: END get_from_prd_bal_act_both;
212:

Line 261: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');

257: x_closing_status := 'Y';
258: ELSE
259: x_closing_status := 'N';
260: CLOSE get_from_period;
261: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
262: app_exception.raise_exception;
263: END IF;
264:
265: EXCEPTION

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

265: EXCEPTION
266: WHEN app_exceptions.application_exception THEN
267: RAISE;
268: WHEN OTHERS THEN
269: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
270: fnd_message.set_token('PROCEDURE',
271: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_bud_arch');
272: RAISE;
273: END get_from_prd_bal_bud_arch;

Line 270: fnd_message.set_token('PROCEDURE',

266: WHEN app_exceptions.application_exception THEN
267: RAISE;
268: WHEN OTHERS THEN
269: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
270: fnd_message.set_token('PROCEDURE',
271: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_bud_arch');
272: RAISE;
273: END get_from_prd_bal_bud_arch;
274:

Line 334: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');

330: x_closing_status := 'Y';
331: ELSE
332: x_closing_status := 'N';
333: CLOSE get_from_period;
334: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
335: app_exception.raise_exception;
336: END IF;
337:
338: EXCEPTION

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

338: EXCEPTION
339: WHEN app_exceptions.application_exception THEN
340: RAISE;
341: WHEN OTHERS THEN
342: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
343: fnd_message.set_token('PROCEDURE',
344: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_bud_arch');
345: RAISE;
346: END get_from_prd_bal_bud_purg;

Line 343: fnd_message.set_token('PROCEDURE',

339: WHEN app_exceptions.application_exception THEN
340: RAISE;
341: WHEN OTHERS THEN
342: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
343: fnd_message.set_token('PROCEDURE',
344: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_bud_arch');
345: RAISE;
346: END get_from_prd_bal_bud_purg;
347:

Line 396: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');

392: x_closing_status := 'Y';
393: ELSE
394: x_closing_status := 'N';
395: CLOSE get_from_period;
396: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
397: app_exception.raise_exception;
398: END IF;
399:
400: EXCEPTION

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

400: EXCEPTION
401: WHEN app_exceptions.application_exception THEN
402: RAISE;
403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
405: fnd_message.set_token('PROCEDURE',
406: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_bud_arch');
407: RAISE;
408: END get_from_prd_bal_bud_both;

Line 405: fnd_message.set_token('PROCEDURE',

401: WHEN app_exceptions.application_exception THEN
402: RAISE;
403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
405: fnd_message.set_token('PROCEDURE',
406: 'gl_arch_prg_from_prd_pkg.get_from_prd_bal_bud_arch');
407: RAISE;
408: END get_from_prd_bal_bud_both;
409:

Line 459: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');

455: x_closing_status := 'Y';
456: ELSE
457: x_closing_status := 'N';
458: CLOSE get_to_period;
459: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
460: app_exception.raise_exception;
461: END IF;
462:
463: EXCEPTION

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

463: EXCEPTION
464: WHEN app_exceptions.application_exception THEN
465: RAISE;
466: WHEN OTHERS THEN
467: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
468: fnd_message.set_token('PROCEDURE',
469: 'gl_arch_prg_from_prd_pkg.get_to_prd_trn_both');
470: RAISE;
471: END get_to_prd_trn_both;

Line 468: fnd_message.set_token('PROCEDURE',

464: WHEN app_exceptions.application_exception THEN
465: RAISE;
466: WHEN OTHERS THEN
467: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
468: fnd_message.set_token('PROCEDURE',
469: 'gl_arch_prg_from_prd_pkg.get_to_prd_trn_both');
470: RAISE;
471: END get_to_prd_trn_both;
472:

Line 523: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');

519: x_closing_status := 'Y';
520: ELSE
521: x_closing_status := 'N';
522: CLOSE get_to_period;
523: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
524: app_exception.raise_exception;
525: END IF;
526:
527: EXCEPTION

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

527: EXCEPTION
528: WHEN app_exceptions.application_exception THEN
529: RAISE;
530: WHEN OTHERS THEN
531: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
532: fnd_message.set_token('PROCEDURE',
533: 'gl_arch_prg_from_prd_pkg.get_to_prd_trn_standard');
534: RAISE;
535: END get_to_prd_trn_standard;

Line 532: fnd_message.set_token('PROCEDURE',

528: WHEN app_exceptions.application_exception THEN
529: RAISE;
530: WHEN OTHERS THEN
531: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
532: fnd_message.set_token('PROCEDURE',
533: 'gl_arch_prg_from_prd_pkg.get_to_prd_trn_standard');
534: RAISE;
535: END get_to_prd_trn_standard;
536:

Line 587: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');

583: x_closing_status := 'Y';
584: ELSE
585: x_closing_status := 'N';
586: CLOSE get_to_period;
587: FND_message.set_name('SQLGL', 'GL_NO_PERIODS_FOUND');
588: app_exception.raise_exception;
589: END IF;
590:
591: EXCEPTION

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

591: EXCEPTION
592: WHEN app_exceptions.application_exception THEN
593: RAISE;
594: WHEN OTHERS THEN
595: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
596: fnd_message.set_token('PROCEDURE',
597: 'gl_arch_prg_from_prd_pkg.get_to_prd_trn_average');
598: RAISE;
599: END get_to_prd_trn_average;

Line 596: fnd_message.set_token('PROCEDURE',

592: WHEN app_exceptions.application_exception THEN
593: RAISE;
594: WHEN OTHERS THEN
595: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
596: fnd_message.set_token('PROCEDURE',
597: 'gl_arch_prg_from_prd_pkg.get_to_prd_trn_average');
598: RAISE;
599: END get_to_prd_trn_average;
600: