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_JE_LINES_PKG dependencies on FND_MESSAGE

Line 40: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_LINE_NUM');

36: FETCH chk_duplicates INTO dummy;
37:
38: IF chk_duplicates%FOUND THEN
39: CLOSE chk_duplicates;
40: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_LINE_NUM');
41: app_exception.raise_exception;
42: END IF;
43:
44: CLOSE chk_duplicates;

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

46: EXCEPTION
47: WHEN app_exceptions.application_exception THEN
48: RAISE;
49: WHEN OTHERS THEN
50: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
51: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.check_unique');
52: RAISE;
53: END check_unique;
54:

Line 51: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.check_unique');

47: WHEN app_exceptions.application_exception THEN
48: RAISE;
49: WHEN OTHERS THEN
50: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
51: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.check_unique');
52: RAISE;
53: END check_unique;
54:
55: PROCEDURE delete_lines(header_id NUMBER) IS

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

64: EXCEPTION
65: WHEN app_exceptions.application_exception THEN
66: RAISE;
67: WHEN OTHERS THEN
68: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
69: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.delete_lines');
70: RAISE;
71: END delete_lines;
72:

Line 69: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.delete_lines');

65: WHEN app_exceptions.application_exception THEN
66: RAISE;
67: WHEN OTHERS THEN
68: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
69: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.delete_lines');
70: RAISE;
71: END delete_lines;
72:
73: PROCEDURE update_lines(header_id NUMBER,

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

173: WHERE je_header_id = header_id;
174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
178: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.update_lines');
179: RAISE;
180: END update_lines;
181:

Line 178: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.update_lines');

174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
178: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.update_lines');
179: RAISE;
180: END update_lines;
181:
182: PROCEDURE calculate_totals( header_id NUMBER,

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

206: CLOSE calc_totals;
207:
208: EXCEPTION
209: WHEN OTHERS THEN
210: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
211: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.calculate_totals');
212: RAISE;
213: END calculate_totals;
214:

Line 211: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.calculate_totals');

207:
208: EXCEPTION
209: WHEN OTHERS THEN
210: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
211: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.calculate_totals');
212: RAISE;
213: END calculate_totals;
214:
215: FUNCTION header_has_stat(header_id NUMBER) RETURN BOOLEAN IS

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

231: CLOSE has_stat;
232: RETURN(TRUE);
233: EXCEPTION
234: WHEN OTHERS THEN
235: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
236: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.header_has_stat');
237: RAISE;
238: END header_has_stat;
239:

Line 236: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.header_has_stat');

232: RETURN(TRUE);
233: EXCEPTION
234: WHEN OTHERS THEN
235: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
236: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.header_has_stat');
237: RAISE;
238: END header_has_stat;
239:
240: FUNCTION header_has_tax(header_id NUMBER) RETURN BOOLEAN IS

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

256: CLOSE has_tax;
257: RETURN(TRUE);
258: EXCEPTION
259: WHEN OTHERS THEN
260: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
261: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.header_has_tax');
262: RAISE;
263: END header_has_tax;
264:

Line 261: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.header_has_tax');

257: RETURN(TRUE);
258: EXCEPTION
259: WHEN OTHERS THEN
260: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
261: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.header_has_tax');
262: RAISE;
263: END header_has_tax;
264:
265: PROCEDURE populate_fields(x_ledger_id NUMBER,

Line 321: FND_MESSAGE.Set_Name('ZX', err_msg);

317: temp_return_status, err_msg
318: );
319:
320: IF (temp_return_status = 'E') THEN
321: FND_MESSAGE.Set_Name('ZX', err_msg);
322: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.populate_fields');
323: -- APP_EXCEPTION.Raise_Exception;
324: ELSIF (temp_return_status = 'U') THEN
325: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

Line 322: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.populate_fields');

318: );
319:
320: IF (temp_return_status = 'E') THEN
321: FND_MESSAGE.Set_Name('ZX', err_msg);
322: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.populate_fields');
323: -- APP_EXCEPTION.Raise_Exception;
324: ELSIF (temp_return_status = 'U') THEN
325: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
326: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.populate_fields');

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

321: FND_MESSAGE.Set_Name('ZX', err_msg);
322: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.populate_fields');
323: -- APP_EXCEPTION.Raise_Exception;
324: ELSIF (temp_return_status = 'U') THEN
325: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
326: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.populate_fields');
327: APP_EXCEPTION.Raise_Exception;
328: END IF;
329: END IF;

Line 326: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.populate_fields');

322: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.populate_fields');
323: -- APP_EXCEPTION.Raise_Exception;
324: ELSIF (temp_return_status = 'U') THEN
325: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
326: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.populate_fields');
327: APP_EXCEPTION.Raise_Exception;
328: END IF;
329: END IF;
330:

Line 352: fnd_message.set_encoded(fnd_flex_keyval.encoded_error_message);

348: x_unit_of_measure => x_unit_of_measure,
349: x_jgzz_recon_flag => x_jgzz_recon_flag);
350:
351: ELSE
352: fnd_message.set_encoded(fnd_flex_keyval.encoded_error_message);
353: app_exception.raise_exception;
354: END IF;
355:
356: END populate_fields;

Line 473: FND_MESSAGE.Set_Name('ZX', err_msg);

469: dummy_return_status, err_msg
470: );
471:
472: IF (dummy_return_status = 'E') THEN
473: FND_MESSAGE.Set_Name('ZX', err_msg);
474: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.init_acct_dependencies');
475: -- APP_EXCEPTION.Raise_Exception;
476: ELSIF (dummy_return_status = 'U') THEN
477: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

Line 474: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.init_acct_dependencies');

470: );
471:
472: IF (dummy_return_status = 'E') THEN
473: FND_MESSAGE.Set_Name('ZX', err_msg);
474: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.init_acct_dependencies');
475: -- APP_EXCEPTION.Raise_Exception;
476: ELSIF (dummy_return_status = 'U') THEN
477: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
478: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.init_acct_dependencies');

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

473: FND_MESSAGE.Set_Name('ZX', err_msg);
474: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.init_acct_dependencies');
475: -- APP_EXCEPTION.Raise_Exception;
476: ELSIF (dummy_return_status = 'U') THEN
477: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
478: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.init_acct_dependencies');
479: APP_EXCEPTION.Raise_Exception;
480: END IF;
481:

Line 478: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.init_acct_dependencies');

474: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.init_acct_dependencies');
475: -- APP_EXCEPTION.Raise_Exception;
476: ELSIF (dummy_return_status = 'U') THEN
477: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
478: fnd_message.set_token('PROCEDURE', 'gl_je_lines_pkg.init_acct_dependencies');
479: APP_EXCEPTION.Raise_Exception;
480: END IF;
481:
482: -- Get the default rounding rule code and default include tax flag

Line 653: FND_MESSAGE.Set_Name('ZX', err_msg);

649: temp_includes_tax_flag,
650: temp_return_status, err_msg);
651:
652: IF (temp_return_status = 'E') THEN
653: FND_MESSAGE.Set_Name('ZX', err_msg);
654: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_tax_code');
655: --APP_EXCEPTION.Raise_Exception;
656: ELSIF (temp_return_status = 'U') THEN
657: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

Line 654: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_tax_code');

650: temp_return_status, err_msg);
651:
652: IF (temp_return_status = 'E') THEN
653: FND_MESSAGE.Set_Name('ZX', err_msg);
654: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_tax_code');
655: --APP_EXCEPTION.Raise_Exception;
656: ELSIF (temp_return_status = 'U') THEN
657: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
658: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_tax_code');

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

653: FND_MESSAGE.Set_Name('ZX', err_msg);
654: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_tax_code');
655: --APP_EXCEPTION.Raise_Exception;
656: ELSIF (temp_return_status = 'U') THEN
657: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
658: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_tax_code');
659: APP_EXCEPTION.Raise_Exception;
660: END IF;
661:

Line 658: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_tax_code');

654: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_tax_code');
655: --APP_EXCEPTION.Raise_Exception;
656: ELSIF (temp_return_status = 'U') THEN
657: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
658: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_tax_code');
659: APP_EXCEPTION.Raise_Exception;
660: END IF;
661:
662: IF (output_type = 'I') THEN

Line 699: FND_MESSAGE.Set_Name('ZX', err_msg);

695: err_msg
696: );
697:
698: IF (temp_return_status = 'E') THEN
699: FND_MESSAGE.Set_Name('ZX', err_msg);
700: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_rounding_rule');
701: --APP_EXCEPTION.Raise_Exception;
702: ELSIF (temp_return_status = 'U') THEN
703: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

Line 700: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_rounding_rule');

696: );
697:
698: IF (temp_return_status = 'E') THEN
699: FND_MESSAGE.Set_Name('ZX', err_msg);
700: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_rounding_rule');
701: --APP_EXCEPTION.Raise_Exception;
702: ELSIF (temp_return_status = 'U') THEN
703: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
704: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_rounding_rule');

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

699: FND_MESSAGE.Set_Name('ZX', err_msg);
700: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_rounding_rule');
701: --APP_EXCEPTION.Raise_Exception;
702: ELSIF (temp_return_status = 'U') THEN
703: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
704: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_rounding_rule');
705: APP_EXCEPTION.Raise_Exception;
706: END IF;
707:

Line 704: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_rounding_rule');

700: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_rounding_rule');
701: --APP_EXCEPTION.Raise_Exception;
702: ELSIF (temp_return_status = 'U') THEN
703: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
704: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_rounding_rule');
705: APP_EXCEPTION.Raise_Exception;
706: END IF;
707:
708: IF default_rounding_rule_code IS NOT NULL THEN

Line 764: FND_MESSAGE.Set_Name('ZX', err_msg);

760: temp_return_status,
761: err_msg);
762:
763: IF (temp_return_status = 'E') THEN
764: FND_MESSAGE.Set_Name('ZX', err_msg);
765: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_includes_tax');
766: -- APP_EXCEPTION.Raise_Exception;
767: ELSIF (temp_return_status = 'U') THEN
768: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

Line 765: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_includes_tax');

761: err_msg);
762:
763: IF (temp_return_status = 'E') THEN
764: FND_MESSAGE.Set_Name('ZX', err_msg);
765: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_includes_tax');
766: -- APP_EXCEPTION.Raise_Exception;
767: ELSIF (temp_return_status = 'U') THEN
768: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
769: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_includes_tax');

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

764: FND_MESSAGE.Set_Name('ZX', err_msg);
765: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_includes_tax');
766: -- APP_EXCEPTION.Raise_Exception;
767: ELSIF (temp_return_status = 'U') THEN
768: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
769: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_includes_tax');
770: APP_EXCEPTION.Raise_Exception;
771: END IF;
772:

Line 769: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_includes_tax');

765: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_includes_tax');
766: -- APP_EXCEPTION.Raise_Exception;
767: ELSIF (temp_return_status = 'U') THEN
768: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
769: fnd_message.set_token('FUNCTION', 'gl_je_lines_pkg.default_includes_tax');
770: APP_EXCEPTION.Raise_Exception;
771: END IF;
772:
773: IF temp_includes_tax_flag IS NOT NULL THEN

Line 1157: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

1153: OPEN C;
1154: FETCH C INTO Recinfo;
1155: if (C%NOTFOUND) then
1156: CLOSE C;
1157: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
1158: APP_EXCEPTION.Raise_Exception;
1159: end if;
1160: CLOSE C;
1161:

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

1371: X_Jgzz_Recon_Id=>X_Jgzz_Recon_Id,
1372: X_Jgzz_Recon_Ref=>X_Jgzz_Recon_Ref);
1373: END IF;
1374: else
1375: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1376: APP_EXCEPTION.RAISE_EXCEPTION;
1377: end if;
1378: else
1379: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

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

1375: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1376: APP_EXCEPTION.RAISE_EXCEPTION;
1377: end if;
1378: else
1379: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1380: APP_EXCEPTION.RAISE_EXCEPTION;
1381: end if;
1382: END Lock_Row;
1383: