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.ZX_TCM_GET_EXEMPT_PKG dependencies on FND_LOG

Line 5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

1: PACKAGE BODY ZX_TCM_GET_EXEMPT_PKG AS
2: /* $Header: zxcgetexemptb.pls 120.26.12010000.3 2008/12/06 17:49:19 ssanka ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL NUMBER;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

2: /* $Header: zxcgetexemptb.pls 120.26.12010000.3 2008/12/06 17:49:19 ssanka ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL NUMBER;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

3:
4: G_CURRENT_RUNTIME_LEVEL NUMBER;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GET_EXEMPT_PKG';

Line 8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

4: G_CURRENT_RUNTIME_LEVEL NUMBER;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GET_EXEMPT_PKG';
12: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GET_EXEMPT_PKG';
12: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
13: procedure period_date_range( p_tax_date in date,

Line 10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GET_EXEMPT_PKG';
12: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
13: procedure period_date_range( p_tax_date in date,
14: p_ledger_id IN NUMBER,

Line 12: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_TCM_GET_EXEMPT_PKG';
12: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
13: procedure period_date_range( p_tax_date in date,
14: p_ledger_id IN NUMBER,
15: start_date out NOCOPY date,
16: end_date out NOCOPY date ) is

Line 34: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions.period_date_range', l_log_msg);

30: open sel_date( p_tax_date );
31: fetch sel_date into start_date, end_date;
32: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
33: l_log_msg := 'start_date '||to_char(start_date);
34: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions.period_date_range', l_log_msg);
35: END IF;
36:
37:
38: if sel_date%notfound

Line 42: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions.period_date_range', l_log_msg);

38: if sel_date%notfound
39: then
40: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
41: l_log_msg := 'No Data found';
42: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions.period_date_range', l_log_msg);
43: END IF;
44:
45: close sel_date;
46:

Line 129: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);

125: BEGIN
126:
127: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
128: l_log_msg := 'Get Exemptions';
129: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
130: END IF;
131: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions',
133: 'p_ptp_id '|| to_char(p_ptp_id) || ' '||

Line 132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions',

128: l_log_msg := 'Get Exemptions';
129: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
130: END IF;
131: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
132: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions',
133: 'p_ptp_id '|| to_char(p_ptp_id) || ' '||
134: 'p_cust_account_id '|| to_char(p_cust_account_id) || ' '||
135: 'p_site_use_id '|| to_char(p_site_use_id) || ' '||
136: 'p_inventory_item_id '|| to_char(p_inventory_item_id)|| ' '||

Line 178: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME,

174: and lookup_code = x_exemption_rec.exempt_reason_code;
175: EXCEPTION
176: WHEN NO_DATA_FOUND THEN
177: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
178: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME,
179: 'There is no exempt reason lookup type for this exempt reason.');
180: END IF;
181: RAISE FND_API.G_EXC_ERROR;
182: WHEN OTHERS THEN

Line 184: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME,

180: END IF;
181: RAISE FND_API.G_EXC_ERROR;
182: WHEN OTHERS THEN
183: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME,
185: 'Failed when trying to get the meaning for Reason Code due to '||SQLERRM);
186: END IF;
187: RAISE FND_API.G_EXC_ERROR;
188: END;

Line 192: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);

188: END;
189: END IF;
190: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
191: l_log_msg := 'Tax Exemptions Id '||to_char(x_exemption_rec.exemption_id) || ' Percent Exempt '||to_char(x_exemption_rec.percent_exempt);
192: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
193: END IF;
194: EXIT;
195:
196: END IF;

Line 226: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);

222:
223:
224: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
225: l_log_msg := 'Get Exemptions Source Tax';
226: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
227: END IF;
228:
229: IF l_tax_exmpt_cr_method_code = 'USE_EXEMPTIONS' THEN
230: IF l_tax_exmpt_source_tax IS NOT NULL THEN

Line 276: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);

272: END LOOP;
273: CLOSE exemptions;
274: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
275: l_log_msg := 'Tax Exemptions Id '||to_char(x_exemption_rec.exemption_id) || ' Percent Exempt '||to_char(x_exemption_rec.percent_exempt);
276: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
277: END IF;
278: END IF;
279: END IF;
280: END IF;

Line 315: -----l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

311: l_tax_jurisdiction_id NUMBER;
312: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
313: l_tax_jurisdiction_id_tbl NUMBER_TBL_TYPE;
314: l_precedence_level_tbl NUMBER_TBL_TYPE;
315: -----l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
316: BEGIN
317: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
318: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
319: l_log_msg := 'Get Tax Exemptions ' ||

Line 317: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

313: l_tax_jurisdiction_id_tbl NUMBER_TBL_TYPE;
314: l_precedence_level_tbl NUMBER_TBL_TYPE;
315: -----l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
316: BEGIN
317: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
318: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
319: l_log_msg := 'Get Tax Exemptions ' ||
320: 'p_bill_to_cust_site_use_id= '|| p_bill_to_cust_site_use_id ||
321: 'p_bill_to_cust_acct_id= '|| p_bill_to_cust_acct_id ||

Line 340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);

336: 'p_tax_jurisdiction_id= '|| p_tax_jurisdiction_id ||
337: 'p_multiple_jurisdictions_flag= '||p_multiple_jurisdictions_flag ||
338: 'p_event_class_rec.ledger_id= '||p_event_class_rec.ledger_id
339: ;
340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
341: END IF;
342:
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344: IF p_exempt_control_flag = 'E' and p_reason_code is null THEN

Line 380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);

376: x_exemption_rec);
377: IF x_exemption_rec.exemption_id IS NULL THEN
378: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
379: l_log_msg := 'Calling get_exemptions with p_bill_to_party_ptp_id';
380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
381: END IF;
382: -- call ptp_based_exemptions with p_bill_to_party_ptp_id,
383: get_exemptions( p_bill_to_party_ptp_id,
384: p_bill_to_cust_acct_id,

Line 421: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);

417: IF x_exemption_rec.exemption_id IS NULL THEN
418: -- call ptp_based_exemptions with p_sold_to_party_ptp_id,
419: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
420: l_log_msg := 'Calling get_exemptions with p_sold_to_party_ptp_id';
421: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
422: END IF;
423: get_exemptions( p_sold_to_party_ptp_id,
424: p_bill_to_cust_acct_id,
425: p_bill_to_cust_site_use_id,

Line 549: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);

545: l_start_date,
546: l_end_date);
547: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
548: l_log_msg := 'l_start_date '||to_char(l_start_date);
549: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', l_log_msg);
550: END IF;
551:
552:
553: n := l_tax_jurisdiction_id_tbl.last;

Line 574: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', 'Unapproved exemption exists');

570: and nvl(tax_jurisdiction_id,-999) = nvl(l_tax_jurisdiction_id,-999)
571: and exemption_status_code = 'UNAPPROVED';
572:
573: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
574: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions', 'Unapproved exemption exists');
575: END IF;
576:
577: exception
578: when no_data_found THEN

Line 587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions',

583:
584: IF l_exists = 'N' THEN
585: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
586: l_log_msg := 'Create Unapproved Exemption';
587: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions',
588: l_log_msg);
589: END IF;
590:
591: SELECT zx_exemptions_s.nextval

Line 601: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions',

597: x_exemption_rec.exempt_reason_code := p_reason_code;
598: x_exemption_rec.exempt_certificate_number := p_exempt_certificate_number;
599:
600: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
601: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || 'Get_tax_exemptions',
602: 'Exemption Id '|| to_char(x_exemption_rec.exemption_id) || ' '||
603: 'Tax Regime Code '|| p_TAX_REGIME_CODE || ' '||
604: 'Tax '|| p_TAX || ' '||
605: 'Tax Status Code ' ||p_TAX_STATUS_CODE || ' ' ||