DBA Data[Home] [Help]

APPS.GL_CALCULATE_TAX2_PKG dependencies on GL_CALCULATE_TAX2_PKG

Line 1: PACKAGE BODY GL_CALCULATE_TAX2_PKG as

1: PACKAGE BODY GL_CALCULATE_TAX2_PKG as
2: /* $Header: glujet2b.pls 120.3.12000000.2 2007/07/03 17:09:29 djogg ship $ */
3:
4: ---
5: --- PRIVATE VARIABLES

Line 48: -- gl_calculate_tax2_pkg.build_selects(1, 'L');

44: -- Arguments
45: -- coa_id Current chart of accounts
46: -- calculation_level Calculation level - journal or line
47: -- Example
48: -- gl_calculate_tax2_pkg.build_selects(1, 'L');
49: -- Notes
50: --
51: PROCEDURE build_selects(coa_id NUMBER,
52: calculation_level VARCHAR2) IS

Line 214: -- gl_calculate_tax2_pkg.get_tax_ccid(1, 2, '01', '01-JAN-91',

210: -- tax_ccid Tax ccid for the current line
211: -- bad_acct Indicates that the tax account is bad
212: -- bad_csegs Gives the bad account
213: -- Example
214: -- gl_calculate_tax2_pkg.get_tax_ccid(1, 2, '01', '01-JAN-91',
215: -- tax_ccid, bad_acct, bad_csegs);
216: -- Notes
217: --
218: PROCEDURE get_tax_ccid(coa_id NUMBER,

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

Line 574: END GL_CALCULATE_TAX2_PKG;

570: dbms_sql.close_cursor(lines_cursor);
571: dbms_sql.close_cursor(ccid_cursor);
572: END close_cursor;
573:
574: END GL_CALCULATE_TAX2_PKG;