DBA Data[Home] [Help]

APPS.GL_CALCULATE_TAX2_PKG dependencies on FND_MESSAGE

Line 242: fnd_message.set_name('SQLGL', 'GL_CTAX_BAD_TAX_CCID');

238:
239: row_count := dbms_sql.execute_and_fetch(ccid_cursor);
240:
241: IF (row_count = 0) THEN
242: fnd_message.set_name('SQLGL', 'GL_CTAX_BAD_TAX_CCID');
243: fnd_message.set_token('TAX_CODE', tax_code);
244: app_exception.raise_exception;
245: END IF;
246:

Line 243: fnd_message.set_token('TAX_CODE', tax_code);

239: row_count := dbms_sql.execute_and_fetch(ccid_cursor);
240:
241: IF (row_count = 0) THEN
242: fnd_message.set_name('SQLGL', 'GL_CTAX_BAD_TAX_CCID');
243: fnd_message.set_token('TAX_CODE', tax_code);
244: app_exception.raise_exception;
245: END IF;
246:
247:

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

402: tax_rate, non_bal_tax_ccid, temp_return_status, err_msg);
403: tax_rate := tax_rate / 100;
404:
405: IF (temp_return_status = 'E') THEN
406: FND_MESSAGE.Set_Name('ZX', err_msg);
407: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
408: APP_EXCEPTION.Raise_Exception;
409: ELSIF (temp_return_status = 'U') THEN
410: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

Line 407: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

403: tax_rate := tax_rate / 100;
404:
405: IF (temp_return_status = 'E') THEN
406: FND_MESSAGE.Set_Name('ZX', err_msg);
407: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
408: APP_EXCEPTION.Raise_Exception;
409: ELSIF (temp_return_status = 'U') THEN
410: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
411: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

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

406: FND_MESSAGE.Set_Name('ZX', err_msg);
407: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
408: APP_EXCEPTION.Raise_Exception;
409: ELSIF (temp_return_status = 'U') THEN
410: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
411: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
412: APP_EXCEPTION.Raise_Exception;
413: END IF;
414:

Line 411: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

407: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
408: APP_EXCEPTION.Raise_Exception;
409: ELSIF (temp_return_status = 'U') THEN
410: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
411: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
412: APP_EXCEPTION.Raise_Exception;
413: END IF;
414:
415: -- Get the tax code

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

416: zx_gl_tax_options_pkg.get_tax_rate_code
417: (1.0, tax_type, tax_code_id, tax_code, temp_return_status, err_msg);
418:
419: IF (temp_return_status = 'E') THEN
420: FND_MESSAGE.Set_Name('ZX', err_msg);
421: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
422: APP_EXCEPTION.Raise_Exception;
423: ELSIF (temp_return_status = 'U') THEN
424: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

Line 421: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

417: (1.0, tax_type, tax_code_id, tax_code, temp_return_status, err_msg);
418:
419: IF (temp_return_status = 'E') THEN
420: FND_MESSAGE.Set_Name('ZX', err_msg);
421: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
422: APP_EXCEPTION.Raise_Exception;
423: ELSIF (temp_return_status = 'U') THEN
424: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
425: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

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

420: FND_MESSAGE.Set_Name('ZX', err_msg);
421: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
422: APP_EXCEPTION.Raise_Exception;
423: ELSIF (temp_return_status = 'U') THEN
424: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
425: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
426: APP_EXCEPTION.Raise_Exception;
427: END IF;
428:

Line 425: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

421: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
422: APP_EXCEPTION.Raise_Exception;
423: ELSIF (temp_return_status = 'U') THEN
424: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
425: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
426: APP_EXCEPTION.Raise_Exception;
427: END IF;
428:
429: -- Get the tax group

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

520: next_tax_rate, next_non_bal_tax_ccid, temp_return_status, err_msg);
521: next_tax_rate := next_tax_rate / 100;
522:
523: IF (temp_return_status = 'E') THEN
524: FND_MESSAGE.Set_Name('ZX', err_msg);
525: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
526: APP_EXCEPTION.Raise_Exception;
527: ELSIF (temp_return_status = 'U') THEN
528: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

Line 525: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

521: next_tax_rate := next_tax_rate / 100;
522:
523: IF (temp_return_status = 'E') THEN
524: FND_MESSAGE.Set_Name('ZX', err_msg);
525: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
526: APP_EXCEPTION.Raise_Exception;
527: ELSIF (temp_return_status = 'U') THEN
528: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
529: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

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

524: FND_MESSAGE.Set_Name('ZX', err_msg);
525: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
526: APP_EXCEPTION.Raise_Exception;
527: ELSIF (temp_return_status = 'U') THEN
528: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
529: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
530: APP_EXCEPTION.Raise_Exception;
531: END IF;
532:

Line 529: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

525: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
526: APP_EXCEPTION.Raise_Exception;
527: ELSIF (temp_return_status = 'U') THEN
528: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
529: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
530: APP_EXCEPTION.Raise_Exception;
531: END IF;
532:
533: -- Get the tax code

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

534: zx_gl_tax_options_pkg.get_tax_rate_code
535: (1.0, next_tax_type, next_tax_code_id, next_tax_code, temp_return_status, err_msg);
536:
537: IF (temp_return_status = 'E') THEN
538: FND_MESSAGE.Set_Name('ZX', err_msg);
539: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
540: APP_EXCEPTION.Raise_Exception;
541: ELSIF (temp_return_status = 'U') THEN
542: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

Line 539: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

535: (1.0, next_tax_type, next_tax_code_id, next_tax_code, temp_return_status, err_msg);
536:
537: IF (temp_return_status = 'E') THEN
538: FND_MESSAGE.Set_Name('ZX', err_msg);
539: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
540: APP_EXCEPTION.Raise_Exception;
541: ELSIF (temp_return_status = 'U') THEN
542: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
543: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

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

538: FND_MESSAGE.Set_Name('ZX', err_msg);
539: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
540: APP_EXCEPTION.Raise_Exception;
541: ELSIF (temp_return_status = 'U') THEN
542: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
543: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
544: APP_EXCEPTION.Raise_Exception;
545: END IF;
546:

Line 543: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');

539: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
540: APP_EXCEPTION.Raise_Exception;
541: ELSIF (temp_return_status = 'U') THEN
542: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
543: fnd_message.set_token('PROCEDURE', 'gl_calculate_tax2_pkg.fetch_cursor');
544: APP_EXCEPTION.Raise_Exception;
545: END IF;
546:
547: -- Get a group id for the next set