DBA Data[Home] [Help]

APPS.JG_ZZ_TAX dependencies on JG_ZZ_TAX

Line 1: PACKAGE BODY JG_ZZ_TAX AS

1: PACKAGE BODY JG_ZZ_TAX AS
2: /* $Header: jgzzrtxb.pls 120.10.12010000.1 2008/07/28 07:58:21 appldev ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 20: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax.BEGIN',

16: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
17:
18: IF (g_level_statement >= g_current_runtime_level ) THEN
19: FND_LOG.STRING(g_level_statement,
20: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax.BEGIN',
21: 'JG_ZZ_TAX: recalculate_tax(+)');
22: END IF;
23:
24: l_country_code := NULL;

Line 21: 'JG_ZZ_TAX: recalculate_tax(+)');

17:
18: IF (g_level_statement >= g_current_runtime_level ) THEN
19: FND_LOG.STRING(g_level_statement,
20: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax.BEGIN',
21: 'JG_ZZ_TAX: recalculate_tax(+)');
22: END IF;
23:
24: l_country_code := NULL;
25: --l_tax_method := NULL;

Line 36: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax',

32: --l_country_code := FND_PROFILE.VALUE('JGZZ_COUNTRY_CODE');
33:
34: IF (g_level_statement >= g_current_runtime_level ) THEN
35: FND_LOG.STRING(g_level_statement,
36: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax',
37: 'l_country_code = ' || l_country_code);
38: END IF;
39:
40: IF NVL(l_country_code,'$') IN ('BR','AR','CO') THEN

Line 55: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax',

51: WHEN OTHERS THEN
52: l_tax_method := NULL;
53: IF (g_level_unexpected >= g_current_runtime_level ) THEN
54: FND_LOG.STRING(g_level_unexpected,
55: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax',
56: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
57: END IF;
58: END;
59:

Line 80: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax',

76: END IF;
77:
78: IF (g_level_statement >= g_current_runtime_level ) THEN
79: FND_LOG.STRING(g_level_statement,
80: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax',
81: 'l_return_code = ' || l_return_code);
82: FND_LOG.STRING(g_level_statement,
83: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax.END',
84: 'JG_ZZ_TAX: recalculate_tax(-)');

Line 83: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax.END',

79: FND_LOG.STRING(g_level_statement,
80: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax',
81: 'l_return_code = ' || l_return_code);
82: FND_LOG.STRING(g_level_statement,
83: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax.END',
84: 'JG_ZZ_TAX: recalculate_tax(-)');
85: END IF;
86:
87: RETURN l_return_code;

Line 84: 'JG_ZZ_TAX: recalculate_tax(-)');

80: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax',
81: 'l_return_code = ' || l_return_code);
82: FND_LOG.STRING(g_level_statement,
83: 'JG.PLSQL.JG_ZZ_TAX.recalculate_tax.END',
84: 'JG_ZZ_TAX: recalculate_tax(-)');
85: END IF;
86:
87: RETURN l_return_code;
88: END recalculate_tax;

Line 104: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code.BEGIN',

100: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
101:
102: IF (g_level_statement >= g_current_runtime_level ) THEN
103: FND_LOG.STRING(g_level_statement,
104: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code.BEGIN',
105: 'JG_ZZ_TAX: get_default_tax_code(+)');
106: END IF;
107:
108: l_country_code := NULL;

Line 105: 'JG_ZZ_TAX: get_default_tax_code(+)');

101:
102: IF (g_level_statement >= g_current_runtime_level ) THEN
103: FND_LOG.STRING(g_level_statement,
104: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code.BEGIN',
105: 'JG_ZZ_TAX: get_default_tax_code(+)');
106: END IF;
107:
108: l_country_code := NULL;
109: --l_tax_method := NULL;

Line 133: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',

129: WHEN OTHERS THEN
130: l_tax_method := NULL;
131: IF (g_level_unexpected >= g_current_runtime_level ) THEN
132: FND_LOG.STRING(g_level_unexpected,
133: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',
134: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
135: END IF;
136:
137: END;

Line 141: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',

137: END;
138:
139: IF (g_level_statement >= g_current_runtime_level ) THEN
140: FND_LOG.STRING(g_level_statement,
141: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',
142: 'l_tax_method = ' || l_tax_method);
143: FND_LOG.STRING(g_level_statement,
144: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',
145: 'l_org_id = ' || TO_CHAR(l_org_id));

Line 144: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',

140: FND_LOG.STRING(g_level_statement,
141: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',
142: 'l_tax_method = ' || l_tax_method);
143: FND_LOG.STRING(g_level_statement,
144: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',
145: 'l_org_id = ' || TO_CHAR(l_org_id));
146: END IF;
147:
148: IF NVL(l_tax_method,'$') = 'LTE' THEN

Line 156: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code'

152: l_org_id := ZX_AR_TAX_CLASSIFICATN_DEF_PKG.sysinfo.ar_product_options_rec.org_id;
153:
154: IF (g_level_statement >= g_current_runtime_level ) THEN
155: FND_LOG.STRING(g_level_statement,
156: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code'
157: ,
158: 'l_org_id = ' || TO_CHAR(l_org_id));
159: END IF;
160:

Line 186: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',

182: WHEN OTHERS THEN
183: l_tax_code := NULL;
184: IF (g_level_unexpected >= g_current_runtime_level ) THEN
185: FND_LOG.STRING(g_level_unexpected,
186: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',
187: sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));
188: END IF;
189: END;
190: END IF;

Line 196: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',

192: -- END IF;
193:
194: IF (g_level_statement >= g_current_runtime_level ) THEN
195: FND_LOG.STRING(g_level_statement,
196: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',
197: 'l_tax_code = ' || l_tax_code);
198: FND_LOG.STRING(g_level_statement,
199: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code.END',
200: 'JG_ZZ_TAX: get_default_tax_code(-)');

Line 199: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code.END',

195: FND_LOG.STRING(g_level_statement,
196: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',
197: 'l_tax_code = ' || l_tax_code);
198: FND_LOG.STRING(g_level_statement,
199: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code.END',
200: 'JG_ZZ_TAX: get_default_tax_code(-)');
201: END IF;
202:
203: RETURN (l_tax_code);

Line 200: 'JG_ZZ_TAX: get_default_tax_code(-)');

196: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code',
197: 'l_tax_code = ' || l_tax_code);
198: FND_LOG.STRING(g_level_statement,
199: 'JG.PLSQL.JG_ZZ_TAX.get_default_tax_code.END',
200: 'JG_ZZ_TAX: get_default_tax_code(-)');
201: END IF;
202:
203: RETURN (l_tax_code);
204:

Line 235: END JG_ZZ_TAX;

231: RETURN (l_tax_code);
232:
233: END get_default_tax_code;
234:
235: END JG_ZZ_TAX;