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

Line 95: IF (p_level >= FND_LOG.g_current_runtime_level) THEN

91: l_error_text VARCHAR(512);
92:
93: BEGIN
94:
95: IF (p_level >= FND_LOG.g_current_runtime_level) THEN
96:
97: FND_LOG.string(p_level, l_mod_name||'.rec_details', p_msg||
98: ' ,HEADER_ID='|| p_rail_rec.HEADER_ID||
99: ' ,LINE_ID='|| p_rail_rec.LINE_ID||

Line 97: FND_LOG.string(p_level, l_mod_name||'.rec_details', p_msg||

93: BEGIN
94:
95: IF (p_level >= FND_LOG.g_current_runtime_level) THEN
96:
97: FND_LOG.string(p_level, l_mod_name||'.rec_details', p_msg||
98: ' ,HEADER_ID='|| p_rail_rec.HEADER_ID||
99: ' ,LINE_ID='|| p_rail_rec.LINE_ID||
100: ' ,ORG_ID='|| p_rail_rec.ORG_ID||
101: ' ,AMOUNT='|| p_rail_rec.AMOUNT||

Line 137: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

133:
134: EXCEPTION
135:
136: WHEN OTHERS THEN
137: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
138: --first log the sqlerrm
139: l_error_text := substr (SQLERRM, 1, 512);
140: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
141: --then add it to the message api list

Line 140: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

136: WHEN OTHERS THEN
137: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
138: --first log the sqlerrm
139: l_error_text := substr (SQLERRM, 1, 512);
140: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
141: --then add it to the message api list
142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
143: END IF;
144: RAISE;

Line 166: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

162: l_set_of_books_id ar_system_parameters_all.set_of_books_id%TYPE;
163:
164: BEGIN
165:
166: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
167: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_org_id='||p_org_id);
168: END IF;
169:
170: OPEN l_org_csr;

Line 167: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_org_id='||p_org_id);

163:
164: BEGIN
165:
166: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
167: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_org_id='||p_org_id);
168: END IF;
169:
170: OPEN l_org_csr;
171: FETCH l_org_csr INTO l_set_of_books_id ;

Line 174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

170: OPEN l_org_csr;
171: FETCH l_org_csr INTO l_set_of_books_id ;
172: CLOSE l_org_csr;
173:
174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
175: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'l_set_of_books_id='||l_set_of_books_id);
176: END IF;
177:
178: RETURN (l_set_of_books_id);

Line 175: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'l_set_of_books_id='||l_set_of_books_id);

171: FETCH l_org_csr INTO l_set_of_books_id ;
172: CLOSE l_org_csr;
173:
174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
175: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.end', 'l_set_of_books_id='||l_set_of_books_id);
176: END IF;
177:
178: RETURN (l_set_of_books_id);
179:

Line 183: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

179:
180: EXCEPTION
181: WHEN OTHERS THEN
182:
183: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
184: --first log the sqlerrm
185: l_error_text := substr (SQLERRM, 1, 512);
186: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
187: --then add it to the message api list

Line 186: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

182:
183: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
184: --first log the sqlerrm
185: l_error_text := substr (SQLERRM, 1, 512);
186: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
187: --then add it to the message api list
188: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
189: END IF;
190:

Line 257: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

253:
254:
255: BEGIN
256:
257: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
258: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_oks_rec.tax_status='||p_oks_rec.tax_status||' ,p_okc_rec.cust_acct_id='||p_okc_rec.cust_acct_id||' ,p_okc_line_rec.cust_acct_id='||p_okc_line_rec.cust_acct_id||
259: ' ,p_oks_rec.EXEMPT_CERTIFICATE_NUMBER='||p_oks_rec.EXEMPT_CERTIFICATE_NUMBER||' ,p_oks_rec.EXEMPT_REASON_CODE='||p_oks_rec.EXEMPT_REASON_CODE||' ,p_oks_rec.TAX_EXEMPTION_ID='||p_oks_rec.TAX_EXEMPTION_ID||
260: ' ,p_oks_rec.TAX_CLASSIFICATION_CODE='||p_oks_rec.TAX_CLASSIFICATION_CODE||' ,p_oks_rec.TAX_CODE='||p_oks_rec.TAX_CODE);
261: END IF;

Line 258: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_oks_rec.tax_status='||p_oks_rec.tax_status||' ,p_okc_rec.cust_acct_id='||p_okc_rec.cust_acct_id||' ,p_okc_line_rec.cust_acct_id='||p_okc_line_rec.cust_acct_id||

254:
255: BEGIN
256:
257: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
258: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_oks_rec.tax_status='||p_oks_rec.tax_status||' ,p_okc_rec.cust_acct_id='||p_okc_rec.cust_acct_id||' ,p_okc_line_rec.cust_acct_id='||p_okc_line_rec.cust_acct_id||
259: ' ,p_oks_rec.EXEMPT_CERTIFICATE_NUMBER='||p_oks_rec.EXEMPT_CERTIFICATE_NUMBER||' ,p_oks_rec.EXEMPT_REASON_CODE='||p_oks_rec.EXEMPT_REASON_CODE||' ,p_oks_rec.TAX_EXEMPTION_ID='||p_oks_rec.TAX_EXEMPTION_ID||
260: ' ,p_oks_rec.TAX_CLASSIFICATION_CODE='||p_oks_rec.TAX_CLASSIFICATION_CODE||' ,p_oks_rec.TAX_CODE='||p_oks_rec.TAX_CODE);
261: END IF;
262:

Line 276: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

272:
273: --Get exemption information if tax_status is 'E'
274: IF NVL(p_oks_rec.tax_status, 'S') = 'E' THEN
275:
276: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
277: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_status','p_oks_rec.tax_status: Tax Status is E (Exempt)');
278: END IF;
279:
280: --Check if the header and lines have the same cust_acct_id

Line 277: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_status','p_oks_rec.tax_status: Tax Status is E (Exempt)');

273: --Get exemption information if tax_status is 'E'
274: IF NVL(p_oks_rec.tax_status, 'S') = 'E' THEN
275:
276: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
277: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_status','p_oks_rec.tax_status: Tax Status is E (Exempt)');
278: END IF;
279:
280: --Check if the header and lines have the same cust_acct_id
281: --We only use the header level exemptions for the lines

Line 298: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

294: FETCH cust_acct_csr INTO l_line_cust_acct_id;
295: CLOSE cust_acct_csr;
296: END IF;
297:
298: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
299: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_accts','l_header_cust_acct_id='||l_header_cust_acct_id||' ,l_line_cust_acct_id='||l_line_cust_acct_id);
300: END IF;
301:
302: IF l_header_cust_acct_id = l_line_cust_acct_id THEN

Line 299: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_accts','l_header_cust_acct_id='||l_header_cust_acct_id||' ,l_line_cust_acct_id='||l_line_cust_acct_id);

295: CLOSE cust_acct_csr;
296: END IF;
297:
298: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
299: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_accts','l_header_cust_acct_id='||l_header_cust_acct_id||' ,l_line_cust_acct_id='||l_line_cust_acct_id);
300: END IF;
301:
302: IF l_header_cust_acct_id = l_line_cust_acct_id THEN
303:

Line 306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

302: IF l_header_cust_acct_id = l_line_cust_acct_id THEN
303:
304: px_rail_rec.TAX_EXEMPT_FLAG := p_oks_rec.TAX_STATUS;
305:
306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
307: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_accts','Header and line have same customer account ID');
308: END IF;
309:
310: IF(p_oks_rec.EXEMPT_CERTIFICATE_NUMBER IS NOT NULL)THEN

Line 307: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_accts','Header and line have same customer account ID');

303:
304: px_rail_rec.TAX_EXEMPT_FLAG := p_oks_rec.TAX_STATUS;
305:
306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
307: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_accts','Header and line have same customer account ID');
308: END IF;
309:
310: IF(p_oks_rec.EXEMPT_CERTIFICATE_NUMBER IS NOT NULL)THEN
311:

Line 323: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

319: OPEN tax_exempt_csr(p_oks_rec.TAX_EXEMPTION_ID);
320: FETCH tax_exempt_csr INTO tax_rec;
321: CLOSE tax_exempt_csr;
322:
323: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
324: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_tax_exempt_csr','old contracts - tax_rec.EXEMPT_CERTIFICATE_NUMBER='|| tax_rec.EXEMPT_CERTIFICATE_NUMBER||
325: ' ,tax_rec.EXEMPT_REASON_CODE='|| tax_rec.EXEMPT_REASON_CODE);
326: END IF;
327:

Line 324: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_tax_exempt_csr','old contracts - tax_rec.EXEMPT_CERTIFICATE_NUMBER='|| tax_rec.EXEMPT_CERTIFICATE_NUMBER||

320: FETCH tax_exempt_csr INTO tax_rec;
321: CLOSE tax_exempt_csr;
322:
323: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
324: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_tax_exempt_csr','old contracts - tax_rec.EXEMPT_CERTIFICATE_NUMBER='|| tax_rec.EXEMPT_CERTIFICATE_NUMBER||
325: ' ,tax_rec.EXEMPT_REASON_CODE='|| tax_rec.EXEMPT_REASON_CODE);
326: END IF;
327:
328: px_rail_rec.TAX_EXEMPT_NUMBER := tax_rec.EXEMPT_CERTIFICATE_NUMBER;

Line 338: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

334:
335: IF get_taxcode_from_taxexempt_csr%FOUND THEN
336: px_rail_rec.TAX_CLASSIFICATION_CODE := l_tax_code;
337:
338: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
339: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_taxcode_from_taxexempt_csr','old contracts - TAX_CLASSIFICATION_CODE='|| l_tax_code);
340: END IF;
341: END IF;
342: CLOSE get_taxcode_from_taxexempt_csr;

Line 339: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_taxcode_from_taxexempt_csr','old contracts - TAX_CLASSIFICATION_CODE='|| l_tax_code);

335: IF get_taxcode_from_taxexempt_csr%FOUND THEN
336: px_rail_rec.TAX_CLASSIFICATION_CODE := l_tax_code;
337:
338: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
339: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_taxcode_from_taxexempt_csr','old contracts - TAX_CLASSIFICATION_CODE='|| l_tax_code);
340: END IF;
341: END IF;
342: CLOSE get_taxcode_from_taxexempt_csr;
343: --end npalepu

Line 350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

346:
347: ELSE
348:
349: --log the line level customer id and header level customer id
350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
351: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_accts','header and line have different customers, cannot use header exemptions for line, setting TAX_EXEMPT_FLAG to S (Standard)');
352: END IF;
353:
354: --since the exemption flag is 'E' taken from the header, and we cannot use it

Line 351: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_accts','header and line have different customers, cannot use header exemptions for line, setting TAX_EXEMPT_FLAG to S (Standard)');

347: ELSE
348:
349: --log the line level customer id and header level customer id
350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
351: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_accts','header and line have different customers, cannot use header exemptions for line, setting TAX_EXEMPT_FLAG to S (Standard)');
352: END IF;
353:
354: --since the exemption flag is 'E' taken from the header, and we cannot use it
355: --we should NOT set the exemption flag to 'E'

Line 366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

362:
363: -- Populate Tax Classification Code
364: IF p_oks_rec.TAX_CLASSIFICATION_CODE IS NOT NULL THEN
365:
366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
367: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_new','New contract, TAX_CLASSIFICATION_CODE='||p_oks_rec.TAX_CLASSIFICATION_CODE);
368: END IF;
369:
370: --Contracts created after R12

Line 367: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_new','New contract, TAX_CLASSIFICATION_CODE='||p_oks_rec.TAX_CLASSIFICATION_CODE);

363: -- Populate Tax Classification Code
364: IF p_oks_rec.TAX_CLASSIFICATION_CODE IS NOT NULL THEN
365:
366: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
367: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_new','New contract, TAX_CLASSIFICATION_CODE='||p_oks_rec.TAX_CLASSIFICATION_CODE);
368: END IF;
369:
370: --Contracts created after R12
371: px_rail_rec.TAX_CLASSIFICATION_CODE := p_oks_rec.TAX_CLASSIFICATION_CODE;

Line 375: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

371: px_rail_rec.TAX_CLASSIFICATION_CODE := p_oks_rec.TAX_CLASSIFICATION_CODE;
372:
373: ELSIF p_oks_rec.TAX_CODE IS NOT NULL THEN
374:
375: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
376: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_old','Old contract, TAX_CODE='||p_oks_rec.TAX_CODE);
377: END IF;
378:
379: --Historical contracts

Line 376: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_old','Old contract, TAX_CODE='||p_oks_rec.TAX_CODE);

372:
373: ELSIF p_oks_rec.TAX_CODE IS NOT NULL THEN
374:
375: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
376: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_old','Old contract, TAX_CODE='||p_oks_rec.TAX_CODE);
377: END IF;
378:
379: --Historical contracts
380: OPEN tax_code_csr(p_oks_rec.TAX_CODE);

Line 387: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

383: IF tax_code_csr%FOUND THEN
384:
385: px_rail_rec.TAX_CLASSIFICATION_CODE := l_tax_code;
386:
387: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
388: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_old','classification code from ZX_ID_TCC_MAPPING, l_tax_code='|| l_tax_code);
389: END IF;
390:
391: END IF; --of IF tax_code_csr%FOUND THEN

Line 388: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_old','classification code from ZX_ID_TCC_MAPPING, l_tax_code='|| l_tax_code);

384:
385: px_rail_rec.TAX_CLASSIFICATION_CODE := l_tax_code;
386:
387: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
388: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.classification_code_old','classification code from ZX_ID_TCC_MAPPING, l_tax_code='|| l_tax_code);
389: END IF;
390:
391: END IF; --of IF tax_code_csr%FOUND THEN
392: CLOSE tax_code_csr;

Line 396: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

392: CLOSE tax_code_csr;
393:
394: END IF; --of IF p_oks_rec.TAX_CLASSIFICATION_CODE IS NOT NULL THEN
395:
396: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
397: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
398: END IF;
399:
400:

Line 397: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);

393:
394: END IF; --of IF p_oks_rec.TAX_CLASSIFICATION_CODE IS NOT NULL THEN
395:
396: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
397: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
398: END IF;
399:
400:
401: EXCEPTION

Line 405: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

401: EXCEPTION
402:
403: WHEN OTHERS THEN
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
406: --first log the sqlerrm
407: l_error_text := substr (SQLERRM, 1, 512);
408: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
409: --then add it to the message api list

Line 408: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
405: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
406: --first log the sqlerrm
407: l_error_text := substr (SQLERRM, 1, 512);
408: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
409: --then add it to the message api list
410: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
411: END IF;
412:

Line 475: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

471:
472:
473: BEGIN
474:
475: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
476: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_okc_rec.INV_RULE_ID='||p_okc_rec.INV_RULE_ID||' ,p_okc_rec.START_DATE='||p_okc_rec.START_DATE||' ,p_okc_rec.org_id='||p_okc_rec.org_id||
477: ' ,p_okc_rec.currency_code='||p_okc_rec.currency_code||' ,p_okc_rec.PAYMENT_TERM_ID='||p_okc_rec.PAYMENT_TERM_ID||' ,p_oks_rec.INV_TRX_TYPE='||p_oks_rec.INV_TRX_TYPE||
478: ' ,p_okc_rec.CONVERSION_TYPE='||p_okc_rec.CONVERSION_TYPE||' ,p_okc_rec.CONVERSION_RATE='||p_okc_rec.CONVERSION_RATE||' ,p_okc_rec.CONVERSION_RATE_DATE='||p_okc_rec.CONVERSION_RATE_DATE||
479: ' ,p_okc_rec.BILL_TO_SITE_USE_ID='||p_okc_rec.BILL_TO_SITE_USE_ID||' ,p_okc_rec.SHIP_TO_SITE_USE_ID='||p_okc_rec.SHIP_TO_SITE_USE_ID);

Line 476: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_okc_rec.INV_RULE_ID='||p_okc_rec.INV_RULE_ID||' ,p_okc_rec.START_DATE='||p_okc_rec.START_DATE||' ,p_okc_rec.org_id='||p_okc_rec.org_id||

472:
473: BEGIN
474:
475: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
476: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_okc_rec.INV_RULE_ID='||p_okc_rec.INV_RULE_ID||' ,p_okc_rec.START_DATE='||p_okc_rec.START_DATE||' ,p_okc_rec.org_id='||p_okc_rec.org_id||
477: ' ,p_okc_rec.currency_code='||p_okc_rec.currency_code||' ,p_okc_rec.PAYMENT_TERM_ID='||p_okc_rec.PAYMENT_TERM_ID||' ,p_oks_rec.INV_TRX_TYPE='||p_oks_rec.INV_TRX_TYPE||
478: ' ,p_okc_rec.CONVERSION_TYPE='||p_okc_rec.CONVERSION_TYPE||' ,p_okc_rec.CONVERSION_RATE='||p_okc_rec.CONVERSION_RATE||' ,p_okc_rec.CONVERSION_RATE_DATE='||p_okc_rec.CONVERSION_RATE_DATE||
479: ' ,p_okc_rec.BILL_TO_SITE_USE_ID='||p_okc_rec.BILL_TO_SITE_USE_ID||' ,p_okc_rec.SHIP_TO_SITE_USE_ID='||p_okc_rec.SHIP_TO_SITE_USE_ID);
480: END IF;

Line 542: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

538: px_rail_rec.PAYMENT_TERM_ID := p_okc_rec.PAYMENT_TERM_ID;
539:
540: ------------------ SBG rule -------------------------------
541:
542: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
543: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_get_cust_trx_type_id','p_oks_rec.INV_TRX_TYPE='||p_oks_rec.INV_TRX_TYPE||' ,p_org_id='||p_okc_rec.org_id);
544: END IF;
545:
546:

Line 543: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_get_cust_trx_type_id','p_oks_rec.INV_TRX_TYPE='||p_oks_rec.INV_TRX_TYPE||' ,p_org_id='||p_okc_rec.org_id);

539:
540: ------------------ SBG rule -------------------------------
541:
542: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
543: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_get_cust_trx_type_id','p_oks_rec.INV_TRX_TYPE='||p_oks_rec.INV_TRX_TYPE||' ,p_org_id='||p_okc_rec.org_id);
544: END IF;
545:
546:
547: px_rail_rec.CUST_TRX_TYPE_ID := get_cust_trx_type_id(

Line 551: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

547: px_rail_rec.CUST_TRX_TYPE_ID := get_cust_trx_type_id(
548: p_org_id => p_okc_rec.org_id,
549: p_inv_trx_type => p_oks_rec.INV_TRX_TYPE);
550:
551: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
552: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_cust_trx_type_id','px_rail_rec.CUST_TRX_TYPE_ID='||px_rail_rec.CUST_TRX_TYPE_ID);
553: END IF;
554:
555: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 552: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_cust_trx_type_id','px_rail_rec.CUST_TRX_TYPE_ID='||px_rail_rec.CUST_TRX_TYPE_ID);

548: p_org_id => p_okc_rec.org_id,
549: p_inv_trx_type => p_oks_rec.INV_TRX_TYPE);
550:
551: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
552: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_cust_trx_type_id','px_rail_rec.CUST_TRX_TYPE_ID='||px_rail_rec.CUST_TRX_TYPE_ID);
553: END IF;
554:
555: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
556: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);

Line 555: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

551: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
552: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_cust_trx_type_id','px_rail_rec.CUST_TRX_TYPE_ID='||px_rail_rec.CUST_TRX_TYPE_ID);
553: END IF;
554:
555: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
556: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
557: END IF;
558:
559: EXCEPTION

Line 556: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);

552: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_cust_trx_type_id','px_rail_rec.CUST_TRX_TYPE_ID='||px_rail_rec.CUST_TRX_TYPE_ID);
553: END IF;
554:
555: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
556: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
557: END IF;
558:
559: EXCEPTION
560:

Line 563: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

559: EXCEPTION
560:
561: WHEN OTHERS THEN
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
564: --first log the sqlerrm
565: l_error_text := substr (SQLERRM, 1, 512);
566: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
567: --then add it to the message api list

Line 566: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
563: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
564: --first log the sqlerrm
565: l_error_text := substr (SQLERRM, 1, 512);
566: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
567: --then add it to the message api list
568: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
569: END IF;
570:

Line 655: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

651: l_need_header_tax VARCHAR2(1);
652:
653: BEGIN
654:
655: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
656: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin', 'p_okc_line_rec.INV_RULE_ID='||p_okc_line_rec.INV_RULE_ID||' ,p_oks_line_rec.id='||p_oks_line_rec.id||' ,p_okc_line_rec.PRICE_NEGOTIATED='||p_okc_line_rec.PRICE_NEGOTIATED||
657: ' ,p_okc_line_rec.START_DATE='||p_okc_line_rec.START_DATE||' ,p_oks_line_rec.TAX_STATUS='||p_oks_line_rec.TAX_STATUS||' ,p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER='||p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER||
658: ' ,p_oks_line_rec.EXEMPT_REASON_CODE='||p_oks_line_rec.EXEMPT_REASON_CODE||' ,p_oks_line_rec.TAX_EXEMPTION_ID='||p_oks_line_rec.TAX_EXEMPTION_ID||' ,p_oks_line_rec.TAX_CLASSIFICATION_CODE='||p_oks_line_rec.TAX_CLASSIFICATION_CODE||
659: ' ,p_oks_line_rec.TAX_CODE='||p_oks_line_rec.TAX_CODE||' ,p_okc_line_rec.PAYMENT_TERM_ID='||p_okc_line_rec.PAYMENT_TERM_ID||

Line 656: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin', 'p_okc_line_rec.INV_RULE_ID='||p_okc_line_rec.INV_RULE_ID||' ,p_oks_line_rec.id='||p_oks_line_rec.id||' ,p_okc_line_rec.PRICE_NEGOTIATED='||p_okc_line_rec.PRICE_NEGOTIATED||

652:
653: BEGIN
654:
655: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
656: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin', 'p_okc_line_rec.INV_RULE_ID='||p_okc_line_rec.INV_RULE_ID||' ,p_oks_line_rec.id='||p_oks_line_rec.id||' ,p_okc_line_rec.PRICE_NEGOTIATED='||p_okc_line_rec.PRICE_NEGOTIATED||
657: ' ,p_okc_line_rec.START_DATE='||p_okc_line_rec.START_DATE||' ,p_oks_line_rec.TAX_STATUS='||p_oks_line_rec.TAX_STATUS||' ,p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER='||p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER||
658: ' ,p_oks_line_rec.EXEMPT_REASON_CODE='||p_oks_line_rec.EXEMPT_REASON_CODE||' ,p_oks_line_rec.TAX_EXEMPTION_ID='||p_oks_line_rec.TAX_EXEMPTION_ID||' ,p_oks_line_rec.TAX_CLASSIFICATION_CODE='||p_oks_line_rec.TAX_CLASSIFICATION_CODE||
659: ' ,p_oks_line_rec.TAX_CODE='||p_oks_line_rec.TAX_CODE||' ,p_okc_line_rec.PAYMENT_TERM_ID='||p_okc_line_rec.PAYMENT_TERM_ID||
660: ' ,p_okc_line_rec.BILL_TO_SITE_USE_ID='||p_okc_line_rec.BILL_TO_SITE_USE_ID||' ,p_okc_line_rec.SHIP_TO_SITE_USE_ID='||p_okc_line_rec.SHIP_TO_SITE_USE_ID);

Line 691: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

687: px_rail_rec.TAX_EXEMPT_FLAG := p_oks_line_rec.TAX_STATUS;
688:
689: IF(NVL(px_rail_rec.TAX_EXEMPT_FLAG, 'S') = 'E') THEN
690:
691: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
692: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_status','Tax status is E, p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER='|| p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER||
693: ' ,p_oks_line_rec.EXEMPT_REASON_CODE='|| p_oks_line_rec.EXEMPT_REASON_CODE||' ,p_oks_line_rec.TAX_EXEMPTION_ID='||p_oks_line_rec.TAX_EXEMPTION_ID);
694: END IF;
695:

Line 692: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_status','Tax status is E, p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER='|| p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER||

688:
689: IF(NVL(px_rail_rec.TAX_EXEMPT_FLAG, 'S') = 'E') THEN
690:
691: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
692: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_status','Tax status is E, p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER='|| p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER||
693: ' ,p_oks_line_rec.EXEMPT_REASON_CODE='|| p_oks_line_rec.EXEMPT_REASON_CODE||' ,p_oks_line_rec.TAX_EXEMPTION_ID='||p_oks_line_rec.TAX_EXEMPTION_ID);
694: END IF;
695:
696: IF(p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER IS NOT NULL)THEN

Line 729: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

725:
726: IF get_taxcode_from_taxexempt_csr%FOUND THEN
727: px_rail_rec.TAX_CLASSIFICATION_CODE := l_tax_code;
728:
729: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
730: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_taxcode_from_taxexempt_csr','old contracts - TAX_CLASSIFICATION_CODE='|| l_tax_code);
731: END IF;
732: END IF;
733: CLOSE get_taxcode_from_taxexempt_csr;

Line 730: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_taxcode_from_taxexempt_csr','old contracts - TAX_CLASSIFICATION_CODE='|| l_tax_code);

726: IF get_taxcode_from_taxexempt_csr%FOUND THEN
727: px_rail_rec.TAX_CLASSIFICATION_CODE := l_tax_code;
728:
729: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
730: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_taxcode_from_taxexempt_csr','old contracts - TAX_CLASSIFICATION_CODE='|| l_tax_code);
731: END IF;
732: END IF;
733: CLOSE get_taxcode_from_taxexempt_csr;
734: --end npalepu

Line 758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

754: --default tax status to 'S'
755: px_rail_rec.TAX_EXEMPT_FLAG := 'S';
756: END IF;
757:
758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
759: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','New Contract - tax_classification_code='||p_oks_line_rec.TAX_CLASSIFICATION_CODE);
760: END IF;
761:
762: ELSIF p_oks_line_rec.TAX_CODE IS NOT NULL THEN

Line 759: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','New Contract - tax_classification_code='||p_oks_line_rec.TAX_CLASSIFICATION_CODE);

755: px_rail_rec.TAX_EXEMPT_FLAG := 'S';
756: END IF;
757:
758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
759: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','New Contract - tax_classification_code='||p_oks_line_rec.TAX_CLASSIFICATION_CODE);
760: END IF;
761:
762: ELSIF p_oks_line_rec.TAX_CODE IS NOT NULL THEN
763:

Line 782: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

778: --default tax status to 'S'
779: px_rail_rec.TAX_EXEMPT_FLAG := 'S';
780: END IF;
781:
782: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
783: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','Old unmigarted Contract - tax_code='||p_oks_line_rec.TAX_CODE||' ,corresponding classification_code='||l_tax_code);
784: END IF;
785:
786: ELSE

Line 783: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','Old unmigarted Contract - tax_code='||p_oks_line_rec.TAX_CODE||' ,corresponding classification_code='||l_tax_code);

779: px_rail_rec.TAX_EXEMPT_FLAG := 'S';
780: END IF;
781:
782: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
783: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','Old unmigarted Contract - tax_code='||p_oks_line_rec.TAX_CODE||' ,corresponding classification_code='||l_tax_code);
784: END IF;
785:
786: ELSE
787: --no tax code on line level, need header information

Line 794: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

790: IF px_rail_rec.TAX_CLASSIFICATION_CODE IS NULL AND px_rail_rec.TAX_EXEMPT_FLAG IS NULL THEN --gbgupta
791: l_need_header_tax := 'Y';
792: END IF;
793:
794: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
795: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','Both tax classication code and tax code are null');
796: END IF;
797:
798: END IF; -- of IF p_oks_rec.TAX_CLASSIFICATION_CODE IS NOT NULL THEN

Line 795: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','Both tax classication code and tax code are null');

791: l_need_header_tax := 'Y';
792: END IF;
793:
794: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
795: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','Both tax classication code and tax code are null');
796: END IF;
797:
798: END IF; -- of IF p_oks_rec.TAX_CLASSIFICATION_CODE IS NOT NULL THEN
799:

Line 838: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

834: -------------------- PTR rule -----------------------------
835: px_rail_rec.PAYMENT_TERM_ID := p_okc_line_rec.PAYMENT_TERM_ID;
836:
837:
838: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
839: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status||' ,x_need_header_tax='||x_need_header_tax);
840: END IF;
841:
842: EXCEPTION

Line 839: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status||' ,x_need_header_tax='||x_need_header_tax);

835: px_rail_rec.PAYMENT_TERM_ID := p_okc_line_rec.PAYMENT_TERM_ID;
836:
837:
838: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
839: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status||' ,x_need_header_tax='||x_need_header_tax);
840: END IF;
841:
842: EXCEPTION
843:

Line 846: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

842: EXCEPTION
843:
844: WHEN OTHERS THEN
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
847: --first log the sqlerrm
848: l_error_text := substr (SQLERRM, 1, 512);
849: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
850: --then add it to the message api list

Line 849: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
846: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
847: --first log the sqlerrm
848: l_error_text := substr (SQLERRM, 1, 512);
849: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
850: --then add it to the message api list
851: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
852: END IF;
853:

Line 936: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

932:
933:
934: BEGIN
935:
936: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
937: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin', 'px_rail_rec.SHIP_TO_SITE_USE_ID='||px_rail_rec.SHIP_TO_SITE_USE_ID||' ,px_rail_rec.BILL_TO_SITE_USE_ID='||px_rail_rec.BILL_TO_SITE_USE_ID);
938: END IF;
939:
940: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 937: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin', 'px_rail_rec.SHIP_TO_SITE_USE_ID='||px_rail_rec.SHIP_TO_SITE_USE_ID||' ,px_rail_rec.BILL_TO_SITE_USE_ID='||px_rail_rec.BILL_TO_SITE_USE_ID);

933:
934: BEGIN
935:
936: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
937: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin', 'px_rail_rec.SHIP_TO_SITE_USE_ID='||px_rail_rec.SHIP_TO_SITE_USE_ID||' ,px_rail_rec.BILL_TO_SITE_USE_ID='||px_rail_rec.BILL_TO_SITE_USE_ID);
938: END IF;
939:
940: x_return_status := OKC_API.G_RET_STS_SUCCESS;
941:

Line 976: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

972: px_rail_rec.BILL_TO_CUST_ACCT_SITE_ID := cust_info_rec.CUST_ACCT_SITE_ID;
973: END IF;
974: CLOSE cur_cust_info;
975:
976: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
977: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
978: END IF;
979:
980: EXCEPTION

Line 977: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);

973: END IF;
974: CLOSE cur_cust_info;
975:
976: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
977: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
978: END IF;
979:
980: EXCEPTION
981:

Line 984: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

980: EXCEPTION
981:
982: WHEN OTHERS THEN
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
984: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
985: --first log the sqlerrm
986: l_error_text := substr (SQLERRM, 1, 512);
987: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
988: --then add it to the message api list

Line 987: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
984: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
985: --first log the sqlerrm
986: l_error_text := substr (SQLERRM, 1, 512);
987: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
988: --then add it to the message api list
989: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
990: END IF;
991:

Line 1017: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1013:
1014: l_legal_entity_id NUMBER;
1015:
1016: BEGIN
1017: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1018: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','begin');
1019: END IF;
1020:
1021: --Initialize the global PL/SQL table

Line 1018: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','begin');

1014: l_legal_entity_id NUMBER;
1015:
1016: BEGIN
1017: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1018: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','begin');
1019: END IF;
1020:
1021: --Initialize the global PL/SQL table
1022: ZX_GLOBAL_STRUCTURES_PKG.init_trx_line_dist_tbl(1);

Line 1035: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1031: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LEVEL_TYPE(1) := 'LINE';
1032: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_LEVEL_ACTION(1) := 'CREATE';
1033:
1034: /*Added by nchadala on 16-JUL-2007 for Bug#6164825*/
1035: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1036: FND_LOG.string(FND_LOG.level_statement, l_mod_name, 'Added the trxtypeid to the AR dist table='||p_rail_rec.cust_trx_type_id);
1037: END IF;
1038: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(1) := p_rail_rec.cust_trx_type_id;
1039:

Line 1036: FND_LOG.string(FND_LOG.level_statement, l_mod_name, 'Added the trxtypeid to the AR dist table='||p_rail_rec.cust_trx_type_id);

1032: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_LEVEL_ACTION(1) := 'CREATE';
1033:
1034: /*Added by nchadala on 16-JUL-2007 for Bug#6164825*/
1035: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1036: FND_LOG.string(FND_LOG.level_statement, l_mod_name, 'Added the trxtypeid to the AR dist table='||p_rail_rec.cust_trx_type_id);
1037: END IF;
1038: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(1) := p_rail_rec.cust_trx_type_id;
1039:
1040: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.QUOTE_FLAG(1) := 'Y';

Line 1051: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1047: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(1) := p_rail_rec.conversion_type;
1048: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(1) := p_rail_rec.minimum_accountable_unit;
1049: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRECISION(1) := p_rail_rec.PRECISION;
1050:
1051: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1052: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_get_legal_entity_id','p_bill_to_cust_acct_id='||p_rail_rec.bill_to_cust_acct_id||' ,p_cust_trx_type_id='||p_rail_rec.cust_trx_type_id||' ,p_org_id='||p_rail_rec.org_id);
1053: END IF;
1054:
1055: l_legal_entity_id := get_legal_entity_id(

Line 1052: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_get_legal_entity_id','p_bill_to_cust_acct_id='||p_rail_rec.bill_to_cust_acct_id||' ,p_cust_trx_type_id='||p_rail_rec.cust_trx_type_id||' ,p_org_id='||p_rail_rec.org_id);

1048: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(1) := p_rail_rec.minimum_accountable_unit;
1049: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRECISION(1) := p_rail_rec.PRECISION;
1050:
1051: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1052: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_get_legal_entity_id','p_bill_to_cust_acct_id='||p_rail_rec.bill_to_cust_acct_id||' ,p_cust_trx_type_id='||p_rail_rec.cust_trx_type_id||' ,p_org_id='||p_rail_rec.org_id);
1053: END IF;
1054:
1055: l_legal_entity_id := get_legal_entity_id(
1056: p_bill_to_cust_acct_id => p_rail_rec.bill_to_cust_acct_id,

Line 1060: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1056: p_bill_to_cust_acct_id => p_rail_rec.bill_to_cust_acct_id,
1057: p_cust_trx_type_id => p_rail_rec.cust_trx_type_id,
1058: p_org_id => p_rail_rec.org_id);
1059:
1060: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1061: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_legal_entity_id','l_legal_entity_id='||l_legal_entity_id);
1062: END IF;
1063:
1064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID(1) := l_legal_entity_id;

Line 1061: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_legal_entity_id','l_legal_entity_id='||l_legal_entity_id);

1057: p_cust_trx_type_id => p_rail_rec.cust_trx_type_id,
1058: p_org_id => p_rail_rec.org_id);
1059:
1060: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1061: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_legal_entity_id','l_legal_entity_id='||l_legal_entity_id);
1062: END IF;
1063:
1064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID(1) := l_legal_entity_id;
1065:

Line 1108: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1104: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_THIRD_PTY_ACCT_SITE_ID(1) := p_rail_rec.BILL_TO_CUST_ACCT_SITE_ID;
1105: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(1) := p_rail_rec.SHIP_TO_CUST_ACCT_SITE_ID;
1106: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG (1) := 'N';
1107:
1108: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1109: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1110: END IF;
1111:
1112: EXCEPTION

Line 1109: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');

1105: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.SHIP_THIRD_PTY_ACCT_SITE_ID(1) := p_rail_rec.SHIP_TO_CUST_ACCT_SITE_ID;
1106: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_AMT_INCLUDES_TAX_FLAG (1) := 'N';
1107:
1108: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1109: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1110: END IF;
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN

Line 1114: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1110: END IF;
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1115: --first log the sqlerrm
1116: l_error_text := substr (SQLERRM, 1, 512);
1117: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1118: --then add it to the message api list

Line 1117: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

1113: WHEN OTHERS THEN
1114: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1115: --first log the sqlerrm
1116: l_error_text := substr (SQLERRM, 1, 512);
1117: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1118: --then add it to the message api list
1119: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1120: END IF;
1121: RAISE;

Line 1164: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1160: l_set_of_books_id NUMBER;
1161:
1162: BEGIN
1163:
1164: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1165: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_org_id='|| p_org_id||' ,p_inv_trx_type='|| p_inv_trx_type);
1166: END IF;
1167:
1168: l_cust_trx_type_id := NULL;

Line 1165: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_org_id='|| p_org_id||' ,p_inv_trx_type='|| p_inv_trx_type);

1161:
1162: BEGIN
1163:
1164: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1165: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_org_id='|| p_org_id||' ,p_inv_trx_type='|| p_inv_trx_type);
1166: END IF;
1167:
1168: l_cust_trx_type_id := NULL;
1169:

Line 1172: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1168: l_cust_trx_type_id := NULL;
1169:
1170: l_set_of_books_id := get_set_of_books_id(p_org_id);
1171:
1172: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1173: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_set_of_books_id','l_set_of_books_id='|| l_set_of_books_id);
1174: END IF;
1175:
1176: IF p_inv_trx_type IS NOT NULL THEN

Line 1173: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_set_of_books_id','l_set_of_books_id='|| l_set_of_books_id);

1169:
1170: l_set_of_books_id := get_set_of_books_id(p_org_id);
1171:
1172: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1173: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_set_of_books_id','l_set_of_books_id='|| l_set_of_books_id);
1174: END IF;
1175:
1176: IF p_inv_trx_type IS NOT NULL THEN
1177: OPEN cur_custtrx_type_id(l_set_of_books_id, p_inv_trx_type, p_org_id);

Line 1181: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1177: OPEN cur_custtrx_type_id(l_set_of_books_id, p_inv_trx_type, p_org_id);
1178: FETCH cur_custtrx_type_id INTO l_cust_trx_type_id;
1179: CLOSE cur_custtrx_type_id;
1180:
1181: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1182: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_trx_type','p_inv_trx_type is not null, l_cust_trx_type_id='||l_cust_trx_type_id);
1183: END IF;
1184:
1185: END IF;

Line 1182: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_trx_type','p_inv_trx_type is not null, l_cust_trx_type_id='||l_cust_trx_type_id);

1178: FETCH cur_custtrx_type_id INTO l_cust_trx_type_id;
1179: CLOSE cur_custtrx_type_id;
1180:
1181: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1182: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.cust_trx_type','p_inv_trx_type is not null, l_cust_trx_type_id='||l_cust_trx_type_id);
1183: END IF;
1184:
1185: END IF;
1186:

Line 1192: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1188: OPEN cur_default_custtrx_type_id(l_set_of_books_id,p_org_id);
1189: FETCH cur_default_custtrx_type_id INTO l_cust_trx_type_id;
1190: CLOSE cur_default_custtrx_type_id;
1191:
1192: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1193: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_trx_type','l_cust_trx_type_id is null, default value - l_cust_trx_type_id=' || l_cust_trx_type_id);
1194: END IF;
1195:
1196: END IF;

Line 1193: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_trx_type','l_cust_trx_type_id is null, default value - l_cust_trx_type_id=' || l_cust_trx_type_id);

1189: FETCH cur_default_custtrx_type_id INTO l_cust_trx_type_id;
1190: CLOSE cur_default_custtrx_type_id;
1191:
1192: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1193: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_trx_type','l_cust_trx_type_id is null, default value - l_cust_trx_type_id=' || l_cust_trx_type_id);
1194: END IF;
1195:
1196: END IF;
1197:

Line 1198: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1194: END IF;
1195:
1196: END IF;
1197:
1198: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1199: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','l_cust_trx_type_id='||l_cust_trx_type_id);
1200: END IF;
1201:
1202: RETURN l_cust_trx_type_id;

Line 1199: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','l_cust_trx_type_id='||l_cust_trx_type_id);

1195:
1196: END IF;
1197:
1198: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1199: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','l_cust_trx_type_id='||l_cust_trx_type_id);
1200: END IF;
1201:
1202: RETURN l_cust_trx_type_id;
1203:

Line 1208: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1204: EXCEPTION
1205:
1206: WHEN OTHERS THEN
1207:
1208: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1209: --first log the sqlerrm
1210: l_error_text := substr (SQLERRM, 1, 512);
1211: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1212: --then add it to the message api list

Line 1211: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

1207:
1208: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1209: --first log the sqlerrm
1210: l_error_text := substr (SQLERRM, 1, 512);
1211: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1212: --then add it to the message api list
1213: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1214: END IF;
1215:

Line 1267: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1263: l_otoc_le_info XLE_BUSINESSINFO_GRP.otoc_le_rec;
1264:
1265: BEGIN
1266:
1267: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1268: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id='||p_chr_id);
1269: END IF;
1270:
1271: OPEN cur_k_header(p_chr_id);

Line 1268: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id='||p_chr_id);

1264:
1265: BEGIN
1266:
1267: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1268: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id='||p_chr_id);
1269: END IF;
1270:
1271: OPEN cur_k_header(p_chr_id);
1272: FETCH cur_k_header INTO l_org_id, l_bill_to_cust_acct_id, l_inv_trx_type;

Line 1275: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1271: OPEN cur_k_header(p_chr_id);
1272: FETCH cur_k_header INTO l_org_id, l_bill_to_cust_acct_id, l_inv_trx_type;
1273: CLOSE cur_k_header;
1274:
1275: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1276: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_k_header', 'l_org_id='||l_org_id||' ,l_bill_to_cust_acct_id='||l_bill_to_cust_acct_id||' ,l_inv_trx_type='||l_inv_trx_type);
1277: END IF;
1278:
1279: IF l_bill_to_cust_acct_id IS NULL THEN

Line 1276: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_k_header', 'l_org_id='||l_org_id||' ,l_bill_to_cust_acct_id='||l_bill_to_cust_acct_id||' ,l_inv_trx_type='||l_inv_trx_type);

1272: FETCH cur_k_header INTO l_org_id, l_bill_to_cust_acct_id, l_inv_trx_type;
1273: CLOSE cur_k_header;
1274:
1275: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1276: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_k_header', 'l_org_id='||l_org_id||' ,l_bill_to_cust_acct_id='||l_bill_to_cust_acct_id||' ,l_inv_trx_type='||l_inv_trx_type);
1277: END IF;
1278:
1279: IF l_bill_to_cust_acct_id IS NULL THEN
1280: OPEN cur_okc_lines(p_chr_id);

Line 1284: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1280: OPEN cur_okc_lines(p_chr_id);
1281: FETCH cur_okc_lines INTO l_bill_to_cust_acct_id;
1282: CLOSE cur_okc_lines;
1283:
1284: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1285: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_okc_lines', 'l_bill_to_cust_acct_id='||l_bill_to_cust_acct_id);
1286: END IF;
1287: END IF;
1288:

Line 1285: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_okc_lines', 'l_bill_to_cust_acct_id='||l_bill_to_cust_acct_id);

1281: FETCH cur_okc_lines INTO l_bill_to_cust_acct_id;
1282: CLOSE cur_okc_lines;
1283:
1284: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1285: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_okc_lines', 'l_bill_to_cust_acct_id='||l_bill_to_cust_acct_id);
1286: END IF;
1287: END IF;
1288:
1289:

Line 1294: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1290: l_cust_trx_type_id := get_cust_trx_type_id(
1291: p_org_id => l_org_id,
1292: p_inv_trx_type => l_inv_trx_type);
1293:
1294: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1295: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_get_cust_trx_type_id', 'l_cust_trx_type_id='||l_cust_trx_type_id);
1296: END IF;
1297:
1298: OPEN cur_batch_source_id(l_org_id);

Line 1295: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_get_cust_trx_type_id', 'l_cust_trx_type_id='||l_cust_trx_type_id);

1291: p_org_id => l_org_id,
1292: p_inv_trx_type => l_inv_trx_type);
1293:
1294: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1295: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_get_cust_trx_type_id', 'l_cust_trx_type_id='||l_cust_trx_type_id);
1296: END IF;
1297:
1298: OPEN cur_batch_source_id(l_org_id);
1299: FETCH cur_batch_source_id INTO l_batch_source_id;

Line 1302: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1298: OPEN cur_batch_source_id(l_org_id);
1299: FETCH cur_batch_source_id INTO l_batch_source_id;
1300: CLOSE cur_batch_source_id;
1301:
1302: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1303: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1304: END IF;
1305:
1306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1303: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);

1299: FETCH cur_batch_source_id INTO l_batch_source_id;
1300: CLOSE cur_batch_source_id;
1301:
1302: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1303: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1304: END IF;
1305:
1306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1307: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_ XLE_BUSINESSINFO_GRP.get_ordertocash_info','p_customer_type: BILL_TO'||' ,p_customer_id: '|| l_bill_to_cust_acct_id||

Line 1306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1302: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1303: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1304: END IF;
1305:
1306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1307: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_ XLE_BUSINESSINFO_GRP.get_ordertocash_info','p_customer_type: BILL_TO'||' ,p_customer_id: '|| l_bill_to_cust_acct_id||
1308: ' ,P_transaction_type_id: '|| l_cust_trx_type_id||' ,p_batch_source_id: '|| l_batch_source_id||' ,p_operating_unit_id: '|| l_org_id);
1309: END IF;
1310:

Line 1307: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_ XLE_BUSINESSINFO_GRP.get_ordertocash_info','p_customer_type: BILL_TO'||' ,p_customer_id: '|| l_bill_to_cust_acct_id||

1303: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1304: END IF;
1305:
1306: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1307: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_ XLE_BUSINESSINFO_GRP.get_ordertocash_info','p_customer_type: BILL_TO'||' ,p_customer_id: '|| l_bill_to_cust_acct_id||
1308: ' ,P_transaction_type_id: '|| l_cust_trx_type_id||' ,p_batch_source_id: '|| l_batch_source_id||' ,p_operating_unit_id: '|| l_org_id);
1309: END IF;
1310:
1311:

Line 1324: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1320: x_otoc_le_info => l_otoc_le_info);
1321:
1322: l_legal_entity_id := l_otoc_le_info.LEGAL_ENTITY_ID;
1323:
1324: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1325: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);
1326: END IF;
1327:
1328: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1325: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);

1321:
1322: l_legal_entity_id := l_otoc_le_info.LEGAL_ENTITY_ID;
1323:
1324: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1325: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);
1326: END IF;
1327:
1328: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1329: RAISE FND_API.g_exc_unexpected_error;

Line 1334: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1330: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1331: RAISE FND_API.g_exc_error;
1332: END IF;
1333:
1334: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1335: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1336: END IF;
1337:
1338: RETURN (l_legal_entity_id);

Line 1335: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');

1331: RAISE FND_API.g_exc_error;
1332: END IF;
1333:
1334: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1335: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1336: END IF;
1337:
1338: RETURN (l_legal_entity_id);
1339:

Line 1344: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

1340: EXCEPTION
1341:
1342: WHEN FND_API.g_exc_error THEN
1343:
1344: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1345: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1346: END IF;
1347:
1348: IF (cur_k_header%isopen) THEN

Line 1345: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');

1341:
1342: WHEN FND_API.g_exc_error THEN
1343:
1344: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1345: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1346: END IF;
1347:
1348: IF (cur_k_header%isopen) THEN
1349: CLOSE cur_k_header;

Line 1360: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

1356: END IF;
1357:
1358: WHEN FND_API.g_exc_unexpected_error THEN
1359:
1360: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1361: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1362: END IF;
1363:
1364: IF (cur_k_header%isopen) THEN

Line 1361: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');

1357:
1358: WHEN FND_API.g_exc_unexpected_error THEN
1359:
1360: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1361: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1362: END IF;
1363:
1364: IF (cur_k_header%isopen) THEN
1365: CLOSE cur_k_header;

Line 1376: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1372: END IF;
1373:
1374: WHEN OTHERS THEN
1375:
1376: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1377: --first log the sqlerrm
1378: l_error_text := substr (SQLERRM, 1, 512);
1379: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1380: --then add it to the message api list

Line 1379: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

1375:
1376: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1377: --first log the sqlerrm
1378: l_error_text := substr (SQLERRM, 1, 512);
1379: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1380: --then add it to the message api list
1381: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1382: END IF;
1383:

Line 1428: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1424: l_otoc_le_info XLE_BUSINESSINFO_GRP.otoc_le_rec;
1425:
1426: BEGIN
1427:
1428: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1429: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_bill_to_cust_acct_id='||p_bill_to_cust_acct_id||' ,p_cust_trx_type_id='||p_cust_trx_type_id||' ,p_org_id='||p_org_id);
1430: END IF;
1431:
1432:

Line 1429: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_bill_to_cust_acct_id='||p_bill_to_cust_acct_id||' ,p_cust_trx_type_id='||p_cust_trx_type_id||' ,p_org_id='||p_org_id);

1425:
1426: BEGIN
1427:
1428: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1429: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_bill_to_cust_acct_id='||p_bill_to_cust_acct_id||' ,p_cust_trx_type_id='||p_cust_trx_type_id||' ,p_org_id='||p_org_id);
1430: END IF;
1431:
1432:
1433: OPEN cur_batch_source_id;

Line 1437: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1433: OPEN cur_batch_source_id;
1434: FETCH cur_batch_source_id INTO l_batch_source_id;
1435: CLOSE cur_batch_source_id;
1436:
1437: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1438: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1439: END IF;
1440:
1441: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 1438: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);

1434: FETCH cur_batch_source_id INTO l_batch_source_id;
1435: CLOSE cur_batch_source_id;
1436:
1437: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1438: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1439: END IF;
1440:
1441: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1442: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_ XLE_BUSINESSINFO_GRP.get_ordertocash_info','p_customer_type: BILL_TO'||' ,p_customer_id: '|| p_bill_to_cust_acct_id||

Line 1441: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1437: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1438: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1439: END IF;
1440:
1441: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1442: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_ XLE_BUSINESSINFO_GRP.get_ordertocash_info','p_customer_type: BILL_TO'||' ,p_customer_id: '|| p_bill_to_cust_acct_id||
1443: ' ,P_transaction_type_id: '|| p_cust_trx_type_id||' ,p_batch_source_id: '|| l_batch_source_id||' ,p_operating_unit_id: '|| p_org_id);
1444: END IF;
1445:

Line 1442: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_ XLE_BUSINESSINFO_GRP.get_ordertocash_info','p_customer_type: BILL_TO'||' ,p_customer_id: '|| p_bill_to_cust_acct_id||

1438: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1439: END IF;
1440:
1441: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1442: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calling_ XLE_BUSINESSINFO_GRP.get_ordertocash_info','p_customer_type: BILL_TO'||' ,p_customer_id: '|| p_bill_to_cust_acct_id||
1443: ' ,P_transaction_type_id: '|| p_cust_trx_type_id||' ,p_batch_source_id: '|| l_batch_source_id||' ,p_operating_unit_id: '|| p_org_id);
1444: END IF;
1445:
1446:

Line 1459: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1455: x_otoc_Le_info => l_otoc_le_info);
1456:
1457: l_legal_entity_id := l_otoc_le_info.LEGAL_ENTITY_ID;
1458:
1459: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1460: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);
1461: END IF;
1462:
1463: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1460: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);

1456:
1457: l_legal_entity_id := l_otoc_le_info.LEGAL_ENTITY_ID;
1458:
1459: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1460: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_XLE_BUSINESSINFO_GRP.get_ordertocash_info','x_return_status='||l_return_status||' ,x_otoc_le_info.LEGAL_ENTITY_ID='||l_otoc_le_info.LEGAL_ENTITY_ID);
1461: END IF;
1462:
1463: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1464: RAISE FND_API.g_exc_unexpected_error;

Line 1469: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1465: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1466: RAISE FND_API.g_exc_error;
1467: END IF;
1468:
1469: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1470: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1471: END IF;
1472:
1473: RETURN (l_legal_entity_id);

Line 1470: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');

1466: RAISE FND_API.g_exc_error;
1467: END IF;
1468:
1469: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1470: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1471: END IF;
1472:
1473: RETURN (l_legal_entity_id);
1474:

Line 1479: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

1475: EXCEPTION
1476:
1477: WHEN FND_API.g_exc_error THEN
1478:
1479: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1480: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1481: END IF;
1482:
1483: IF (cur_batch_source_id%isopen) THEN

Line 1480: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');

1476:
1477: WHEN FND_API.g_exc_error THEN
1478:
1479: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1480: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1481: END IF;
1482:
1483: IF (cur_batch_source_id%isopen) THEN
1484: CLOSE cur_batch_source_id;

Line 1489: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

1485: END IF;
1486:
1487: WHEN FND_API.g_exc_unexpected_error THEN
1488:
1489: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1490: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1491: END IF;
1492:
1493: IF (cur_batch_source_id%isopen) THEN

Line 1490: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');

1486:
1487: WHEN FND_API.g_exc_unexpected_error THEN
1488:
1489: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1490: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1491: END IF;
1492:
1493: IF (cur_batch_source_id%isopen) THEN
1494: CLOSE cur_batch_source_id;

Line 1499: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1495: END IF;
1496:
1497: WHEN OTHERS THEN
1498:
1499: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1500: --first log the sqlerrm
1501: l_error_text := substr (SQLERRM, 1, 512);
1502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1503: --then add it to the message api list

Line 1502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

1498:
1499: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1500: --first log the sqlerrm
1501: l_error_text := substr (SQLERRM, 1, 512);
1502: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1503: --then add it to the message api list
1504: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1505: END IF;
1506:

Line 1639: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

1635: */
1636: --end npalepu
1637:
1638: --0. log the input details
1639: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1640: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_chr_id='||p_chr_id||' ,p_cle_id= '||p_cle_id||' ,line_amount='||l_line_amount);
1641: print_g_rail_rec(
1642: p_rail_rec => px_rail_rec,
1643: p_msg => 'Begin get_tax, PX_RAIL_REC details',

Line 1640: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_chr_id='||p_chr_id||' ,p_cle_id= '||p_cle_id||' ,line_amount='||l_line_amount);

1636: --end npalepu
1637:
1638: --0. log the input details
1639: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1640: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_chr_id='||p_chr_id||' ,p_cle_id= '||p_cle_id||' ,line_amount='||l_line_amount);
1641: print_g_rail_rec(
1642: p_rail_rec => px_rail_rec,
1643: p_msg => 'Begin get_tax, PX_RAIL_REC details',
1644: p_level => FND_LOG.level_procedure);

Line 1644: p_level => FND_LOG.level_procedure);

1640: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','p_chr_id='||p_chr_id||' ,p_cle_id= '||p_cle_id||' ,line_amount='||l_line_amount);
1641: print_g_rail_rec(
1642: p_rail_rec => px_rail_rec,
1643: p_msg => 'Begin get_tax, PX_RAIL_REC details',
1644: p_level => FND_LOG.level_procedure);
1645: END IF;
1646:
1647: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1648: IF(FND_API.G_TRUE = p_init_msg_list) THEN

Line 1658: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

1654: FETCH okc_hdr_csr INTO l_okc_hdr_rec;
1655: IF (okc_hdr_csr%notfound) THEN
1656: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
1657: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1658: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1659: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
1660: END IF;
1661: FND_MSG_PUB.ADD;
1662: CLOSE okc_hdr_csr;

Line 1659: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);

1655: IF (okc_hdr_csr%notfound) THEN
1656: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
1657: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1658: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1659: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
1660: END IF;
1661: FND_MSG_PUB.ADD;
1662: CLOSE okc_hdr_csr;
1663: RAISE FND_API.g_exc_error;

Line 1667: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1663: RAISE FND_API.g_exc_error;
1664: END IF;
1665: CLOSE okc_hdr_csr;
1666:
1667: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1668: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_okc_hdr_csr', 'ok');
1669: END IF;
1670:
1671: G_RAIL_REC.HEADER_ID := p_chr_id;

Line 1668: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_okc_hdr_csr', 'ok');

1664: END IF;
1665: CLOSE okc_hdr_csr;
1666:
1667: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1668: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_okc_hdr_csr', 'ok');
1669: END IF;
1670:
1671: G_RAIL_REC.HEADER_ID := p_chr_id;
1672: G_RAIL_REC.LINE_ID := p_cle_id;

Line 1685: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1681: OPEN oks_hdr_csr(p_chr_id);
1682: FETCH oks_hdr_csr INTO l_oks_hdr_rec;
1683: CLOSE oks_hdr_csr;
1684:
1685: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1686: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_oks_hdr_csr', 'ok');
1687: END IF;
1688:
1689: --3. populate hdr rules in G_RAIL_REC

Line 1686: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_oks_hdr_csr', 'ok');

1682: FETCH oks_hdr_csr INTO l_oks_hdr_rec;
1683: CLOSE oks_hdr_csr;
1684:
1685: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1686: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_oks_hdr_csr', 'ok');
1687: END IF;
1688:
1689: --3. populate hdr rules in G_RAIL_REC
1690: get_hdr_rules(

Line 1696: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1692: p_okc_rec => l_okc_hdr_rec,
1693: px_rail_rec => G_RAIL_REC,
1694: x_return_status => x_return_status);
1695:
1696: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1697: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_rules', 'x_return_status='||x_return_status);
1698: print_g_rail_rec(
1699: p_rail_rec => G_RAIL_REC,
1700: p_msg => 'After calling get_hdr_rules, G_RAIL_REC details',

Line 1697: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_rules', 'x_return_status='||x_return_status);

1693: px_rail_rec => G_RAIL_REC,
1694: x_return_status => x_return_status);
1695:
1696: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1697: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_rules', 'x_return_status='||x_return_status);
1698: print_g_rail_rec(
1699: p_rail_rec => G_RAIL_REC,
1700: p_msg => 'After calling get_hdr_rules, G_RAIL_REC details',
1701: p_level => FND_LOG.level_statement);

Line 1701: p_level => FND_LOG.level_statement);

1697: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_rules', 'x_return_status='||x_return_status);
1698: print_g_rail_rec(
1699: p_rail_rec => G_RAIL_REC,
1700: p_msg => 'After calling get_hdr_rules, G_RAIL_REC details',
1701: p_level => FND_LOG.level_statement);
1702: END IF;
1703:
1704:
1705: --4. find out if p_cle_id is top line (for subscription) or sub line id

Line 1721: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1717: --end npalepu
1718: END IF;
1719: CLOSE cur_sub_lines;
1720:
1721: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1722: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_cur_sub_lines', 'p_cle_id='||p_cle_id||' ,l_parent_cle_id='||l_parent_cle_id);
1723: END IF;
1724:
1725: --5. All tax details except amount are at the topline level

Line 1722: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_cur_sub_lines', 'p_cle_id='||p_cle_id||' ,l_parent_cle_id='||l_parent_cle_id);

1718: END IF;
1719: CLOSE cur_sub_lines;
1720:
1721: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1722: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_cur_sub_lines', 'p_cle_id='||p_cle_id||' ,l_parent_cle_id='||l_parent_cle_id);
1723: END IF;
1724:
1725: --5. All tax details except amount are at the topline level
1726: -- get the topline details from okc table

Line 1733: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1729: IF okc_line_csr%FOUND THEN
1730: G_RAIL_REC.UNIT_SELLING_PRICE := nvl(l_okc_line_rec.price_unit, l_okc_line_rec.price_negotiated);
1731: G_RAIL_REC.AMOUNT := nvl(l_okc_line_rec.price_negotiated, 0);
1732:
1733: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1734: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_line_open_oks_line_csr', 'line id='||l_okc_line_rec.id);
1735: END IF;
1736:
1737: --6. get the topline details from oks table

Line 1734: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_line_open_oks_line_csr', 'line id='||l_okc_line_rec.id);

1730: G_RAIL_REC.UNIT_SELLING_PRICE := nvl(l_okc_line_rec.price_unit, l_okc_line_rec.price_negotiated);
1731: G_RAIL_REC.AMOUNT := nvl(l_okc_line_rec.price_negotiated, 0);
1732:
1733: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1734: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_line_open_oks_line_csr', 'line id='||l_okc_line_rec.id);
1735: END IF;
1736:
1737: --6. get the topline details from oks table
1738: OPEN oks_line_csr(p_chr_id, l_okc_line_rec.id);

Line 1758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1754: px_rail_rec => G_RAIL_REC,
1755: x_return_status => x_return_status,
1756: x_need_header_tax => l_need_header_tax);
1757:
1758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1759: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_line_rules', 'x_return_status='||x_return_status||' ,l_need_header_tax='||l_need_header_tax);
1760: print_g_rail_rec(
1761: p_rail_rec => G_RAIL_REC,
1762: p_msg => 'After calling get_line_rules, G_RAIL_REC details',

Line 1759: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_line_rules', 'x_return_status='||x_return_status||' ,l_need_header_tax='||l_need_header_tax);

1755: x_return_status => x_return_status,
1756: x_need_header_tax => l_need_header_tax);
1757:
1758: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1759: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_line_rules', 'x_return_status='||x_return_status||' ,l_need_header_tax='||l_need_header_tax);
1760: print_g_rail_rec(
1761: p_rail_rec => G_RAIL_REC,
1762: p_msg => 'After calling get_line_rules, G_RAIL_REC details',
1763: p_level => FND_LOG.level_statement);

Line 1763: p_level => FND_LOG.level_statement);

1759: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_line_rules', 'x_return_status='||x_return_status||' ,l_need_header_tax='||l_need_header_tax);
1760: print_g_rail_rec(
1761: p_rail_rec => G_RAIL_REC,
1762: p_msg => 'After calling get_line_rules, G_RAIL_REC details',
1763: p_level => FND_LOG.level_statement);
1764: END IF;
1765:
1766: --8. get the item details
1767: OPEN cur_item(l_okc_line_rec.id);

Line 1795: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1791: p_okc_line_rec => l_okc_line_rec,
1792: px_rail_rec => G_RAIL_REC,
1793: x_return_status => x_return_status);
1794:
1795: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1796: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_tax', 'x_return_status='||x_return_status);
1797: print_g_rail_rec(
1798: p_rail_rec => G_RAIL_REC,
1799: p_msg => 'After calling get_hdr_tax on top line, G_RAIL_REC details',

Line 1796: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_tax', 'x_return_status='||x_return_status);

1792: px_rail_rec => G_RAIL_REC,
1793: x_return_status => x_return_status);
1794:
1795: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1796: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_tax', 'x_return_status='||x_return_status);
1797: print_g_rail_rec(
1798: p_rail_rec => G_RAIL_REC,
1799: p_msg => 'After calling get_hdr_tax on top line, G_RAIL_REC details',
1800: p_level => FND_LOG.level_statement);

Line 1800: p_level => FND_LOG.level_statement);

1796: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_tax', 'x_return_status='||x_return_status);
1797: print_g_rail_rec(
1798: p_rail_rec => G_RAIL_REC,
1799: p_msg => 'After calling get_hdr_tax on top line, G_RAIL_REC details',
1800: p_level => FND_LOG.level_statement);
1801: END IF;
1802:
1803: END IF; --of IF l_need_header_tax = 'Y' THEN
1804:

Line 1814: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1810: --else get the topline values
1811: IF (nvl(l_parent_cle_id, -99) = p_cle_id) THEN
1812:
1813: --p_cle_id is id of topline, do nothing
1814: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1815: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.amount','p_cle_id='||p_cle_id||' is topline id');
1816: END IF;
1817:
1818: ELSE

Line 1815: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.amount','p_cle_id='||p_cle_id||' is topline id');

1811: IF (nvl(l_parent_cle_id, -99) = p_cle_id) THEN
1812:
1813: --p_cle_id is id of topline, do nothing
1814: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1815: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.amount','p_cle_id='||p_cle_id||' is topline id');
1816: END IF;
1817:
1818: ELSE
1819:

Line 1824: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1820: --p_cle_id is id of subline, get the subline amount
1821: G_RAIL_REC.UNIT_SELLING_PRICE := nvl(sub_line_rec.price_unit, sub_line_rec.price_negotiated);
1822: G_RAIL_REC.AMOUNT := nvl(sub_line_rec.price_negotiated, 0);
1823:
1824: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1825: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.amount','p_cle_id='||p_cle_id||' is subline id, sub_line_rec.price_negotiated='||sub_line_rec.price_negotiated);
1826: END IF;
1827:
1828: END IF;

Line 1825: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.amount','p_cle_id='||p_cle_id||' is subline id, sub_line_rec.price_negotiated='||sub_line_rec.price_negotiated);

1821: G_RAIL_REC.UNIT_SELLING_PRICE := nvl(sub_line_rec.price_unit, sub_line_rec.price_negotiated);
1822: G_RAIL_REC.AMOUNT := nvl(sub_line_rec.price_negotiated, 0);
1823:
1824: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1825: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.amount','p_cle_id='||p_cle_id||' is subline id, sub_line_rec.price_negotiated='||sub_line_rec.price_negotiated);
1826: END IF;
1827:
1828: END IF;
1829:

Line 1858: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

1854: CLOSE get_operating_unit;
1855:
1856: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_TRX_TYPE');
1857: FND_MESSAGE.set_token('NAME', l_op_unit_name);
1858: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1859: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.no_trx_type', FALSE);
1860: END IF;
1861: FND_MSG_PUB.ADD;
1862: RAISE FND_API.g_exc_error;

Line 1859: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.no_trx_type', FALSE);

1855:
1856: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_TRX_TYPE');
1857: FND_MESSAGE.set_token('NAME', l_op_unit_name);
1858: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1859: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.no_trx_type', FALSE);
1860: END IF;
1861: FND_MSG_PUB.ADD;
1862: RAISE FND_API.g_exc_error;
1863: END IF;

Line 1882: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1878: p_chr_id => p_chr_id,
1879: px_rail_rec => G_RAIL_REC,
1880: x_return_status => x_return_status);
1881:
1882: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1883: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_tax_integration', 'x_return_status='||x_return_status);
1884: END IF;
1885:
1886: --in case the exemption control is null, we default it to 'S'

Line 1883: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_tax_integration', 'x_return_status='||x_return_status);

1879: px_rail_rec => G_RAIL_REC,
1880: x_return_status => x_return_status);
1881:
1882: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1883: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_tax_integration', 'x_return_status='||x_return_status);
1884: END IF;
1885:
1886: --in case the exemption control is null, we default it to 'S'
1887: G_RAIL_REC.tax_exempt_flag := nvl(G_RAIL_REC.tax_exempt_flag, 'S');

Line 1897: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1893: OPEN Cur_Batch_Source_Id(G_RAIL_REC.org_id);
1894: FETCH Cur_Batch_Source_Id INTO l_batch_source_id;
1895: CLOSE Cur_Batch_Source_Id;
1896:
1897: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1898: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.validating_exemptions','calling ZX_TCM_VALIDATE_EXEMPT_PKG.VALIDATE_TAX_EXEMPTIONS to validate tax exemptions'||
1899: ' ,p_tax_exempt_number='|| G_RAIL_REC.EXEMPT_CERTIFICATE_NUMBER ||
1900: ' ,p_tax_exempt_reason_code='|| G_RAIL_REC.EXEMPT_REASON_CODE ||
1901: ' ,p_ship_to_org_id='|| G_RAIL_REC.ship_to_site_use_id ||

Line 1898: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.validating_exemptions','calling ZX_TCM_VALIDATE_EXEMPT_PKG.VALIDATE_TAX_EXEMPTIONS to validate tax exemptions'||

1894: FETCH Cur_Batch_Source_Id INTO l_batch_source_id;
1895: CLOSE Cur_Batch_Source_Id;
1896:
1897: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1898: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.validating_exemptions','calling ZX_TCM_VALIDATE_EXEMPT_PKG.VALIDATE_TAX_EXEMPTIONS to validate tax exemptions'||
1899: ' ,p_tax_exempt_number='|| G_RAIL_REC.EXEMPT_CERTIFICATE_NUMBER ||
1900: ' ,p_tax_exempt_reason_code='|| G_RAIL_REC.EXEMPT_REASON_CODE ||
1901: ' ,p_ship_to_org_id='|| G_RAIL_REC.ship_to_site_use_id ||
1902: ' ,p_invoice_to_org_id='|| G_RAIL_REC.bill_to_site_use_id ||

Line 1935: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1931: x_return_status => l_ret_stat,
1932: x_msg_count => l_msg_count,
1933: x_msg_data => l_msg_data);
1934:
1935: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1936: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.After_VALIDATE_TAX_EXEMPTIONS', 'l_valid_flag='||l_valid_flag);
1937: End If;
1938:
1939: IF l_valid_flag <> 'Y' THEN

Line 1936: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.After_VALIDATE_TAX_EXEMPTIONS', 'l_valid_flag='||l_valid_flag);

1932: x_msg_count => l_msg_count,
1933: x_msg_data => l_msg_data);
1934:
1935: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1936: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.After_VALIDATE_TAX_EXEMPTIONS', 'l_valid_flag='||l_valid_flag);
1937: End If;
1938:
1939: IF l_valid_flag <> 'Y' THEN
1940: --reset the tax_exempt_flag to 'S'

Line 1953: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

1949: END IF;
1950: EXCEPTION
1951: WHEN OTHERS THEN
1952:
1953: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1954: --first log the sqlerrm
1955: l_error_text := substr (SQLERRM, 1, 512);
1956: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.exemption_validation_error', l_error_text);
1957: --then add it to the message api list

Line 1956: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.exemption_validation_error', l_error_text);

1952:
1953: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1954: --first log the sqlerrm
1955: l_error_text := substr (SQLERRM, 1, 512);
1956: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.exemption_validation_error', l_error_text);
1957: --then add it to the message api list
1958: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1959: END IF;
1960: IF Cur_Batch_Source_Id%ISOPEN THEN

Line 1971: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1967:
1968: --16. get the default tcc if null
1969: --fix bug 4952080, need to call the defaulting logic if tax_classification_code is null
1970: IF G_RAIL_REC.tax_classification_code IS NULL THEN
1971: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1972: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_tcc','calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification to get default tcc'||
1973: ' ,p_ship_to_site_use_id='|| G_RAIL_REC.ship_to_site_use_id ||
1974: ' ,p_bill_to_site_use_id='|| G_RAIL_REC.bill_to_site_use_id ||
1975: ' ,p_inventory_item_id='|| G_RAIL_REC.inventory_item_id ||

Line 1972: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_tcc','calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification to get default tcc'||

1968: --16. get the default tcc if null
1969: --fix bug 4952080, need to call the defaulting logic if tax_classification_code is null
1970: IF G_RAIL_REC.tax_classification_code IS NULL THEN
1971: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1972: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_tcc','calling ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification to get default tcc'||
1973: ' ,p_ship_to_site_use_id='|| G_RAIL_REC.ship_to_site_use_id ||
1974: ' ,p_bill_to_site_use_id='|| G_RAIL_REC.bill_to_site_use_id ||
1975: ' ,p_inventory_item_id='|| G_RAIL_REC.inventory_item_id ||
1976: ' ,p_organization_id='|| G_RAIL_REC.org_id ||

Line 2006: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

2002:
2003: EXCEPTION
2004: WHEN OTHERS THEN
2005:
2006: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2007: --first log the sqlerrm
2008: l_error_text := substr (SQLERRM, 1, 512);
2009: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.default_tcc_error', l_error_text);
2010: --then add it to the message api list

Line 2009: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.default_tcc_error', l_error_text);

2005:
2006: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2007: --first log the sqlerrm
2008: l_error_text := substr (SQLERRM, 1, 512);
2009: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.default_tcc_error', l_error_text);
2010: --then add it to the message api list
2011: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2012: END IF;
2013: RAISE FND_API.g_exc_unexpected_error;

Line 2017: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2013: RAISE FND_API.g_exc_unexpected_error;
2014:
2015: END; --of inner block
2016:
2017: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2018: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_tcc','after call to ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification, p_tax_classification_code='||l_default_tax_code);
2019: END IF;
2020:
2021: G_RAIL_REC.tax_classification_code := l_default_tax_code;

Line 2018: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_tcc','after call to ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification, p_tax_classification_code='||l_default_tax_code);

2014:
2015: END; --of inner block
2016:
2017: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2018: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.default_tcc','after call to ZX_AR_TAX_CLASSIFICATN_DEF_PKG.get_default_tax_classification, p_tax_classification_code='||l_default_tax_code);
2019: END IF;
2020:
2021: G_RAIL_REC.tax_classification_code := l_default_tax_code;
2022:

Line 2027: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2023: END IF; --of IF G_RAIL_REC.tax_classification_code IS NULL
2024: --end of bug 4952080
2025:
2026:
2027: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2028: print_g_rail_rec(
2029: p_rail_rec => G_RAIL_REC,
2030: p_msg => 'Final state of G_RAIL_REC details, before calling ZX_API_PUB.calculate_tax',
2031: p_level => FND_LOG.level_statement);

Line 2031: p_level => FND_LOG.level_statement);

2027: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2028: print_g_rail_rec(
2029: p_rail_rec => G_RAIL_REC,
2030: p_msg => 'Final state of G_RAIL_REC details, before calling ZX_API_PUB.calculate_tax',
2031: p_level => FND_LOG.level_statement);
2032: END IF;
2033:
2034:
2035: --17. populate pl/sql global table

Line 2040: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2036: init_zx_trxline_dist_tbl(p_rail_rec => G_RAIL_REC);
2037:
2038:
2039: --18. finally call the zx api to calculate tax
2040: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2041: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','calling ZX_API_PUB.calculate_tax, p_quote_flag=Y, p_data_transfer_mode=PLS, p_validation_level=FND_API.G_VALID_LEVEL_FULL, transaction_rec_details.'||
2042: ' ,trec.internal_organization_id='||transaction_rec.internal_organization_id||
2043: ' ,trec.application_id='||transaction_rec.application_id||
2044: ' ,trec.entity_code='||transaction_rec.entity_code||

Line 2041: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','calling ZX_API_PUB.calculate_tax, p_quote_flag=Y, p_data_transfer_mode=PLS, p_validation_level=FND_API.G_VALID_LEVEL_FULL, transaction_rec_details.'||

2037:
2038:
2039: --18. finally call the zx api to calculate tax
2040: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2041: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','calling ZX_API_PUB.calculate_tax, p_quote_flag=Y, p_data_transfer_mode=PLS, p_validation_level=FND_API.G_VALID_LEVEL_FULL, transaction_rec_details.'||
2042: ' ,trec.internal_organization_id='||transaction_rec.internal_organization_id||
2043: ' ,trec.application_id='||transaction_rec.application_id||
2044: ' ,trec.entity_code='||transaction_rec.entity_code||
2045: ' ,trec.event_class_code='||transaction_rec.event_class_code||

Line 2063: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

2059: p_quote_flag => 'Y',
2060: p_data_transfer_mode => 'PLS',
2061: x_doc_level_recalc_flag => l_doc_level_recalc_flag);
2062:
2063: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2064: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','after call to ZX_API_PUB.calculate_tax, x_return_status='||x_return_status||' ,x_doc_level_recalc_flag='||l_doc_level_recalc_flag);
2065: END IF;
2066:
2067: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2064: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','after call to ZX_API_PUB.calculate_tax, x_return_status='||x_return_status||' ,x_doc_level_recalc_flag='||l_doc_level_recalc_flag);

2060: p_data_transfer_mode => 'PLS',
2061: x_doc_level_recalc_flag => l_doc_level_recalc_flag);
2062:
2063: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2064: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.calculate_tax','after call to ZX_API_PUB.calculate_tax, x_return_status='||x_return_status||' ,x_doc_level_recalc_flag='||l_doc_level_recalc_flag);
2065: END IF;
2066:
2067: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2068: RAISE FND_API.g_exc_unexpected_error;

Line 2099: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

2095: px_rail_rec := G_RAIL_REC;
2096:
2097:
2098: --20. log the tax details and exit
2099: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2100: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status||' ,px_rail_rec(key details). '||
2101: ' .AMOUNT=' || px_rail_rec.AMOUNT ||
2102: ' .TAX_VALUE=' || px_rail_rec.TAX_VALUE ||
2103: ' .TAX_RATE=' || px_rail_rec.TAX_RATE ||

Line 2100: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status||' ,px_rail_rec(key details). '||

2096:
2097:
2098: --20. log the tax details and exit
2099: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2100: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status||' ,px_rail_rec(key details). '||
2101: ' .AMOUNT=' || px_rail_rec.AMOUNT ||
2102: ' .TAX_VALUE=' || px_rail_rec.TAX_VALUE ||
2103: ' .TAX_RATE=' || px_rail_rec.TAX_RATE ||
2104: ' .AMOUNT_INCLUDES_TAX_FLAG=' || px_rail_rec.AMOUNT_INCLUDES_TAX_FLAG ||

Line 2110: p_level => FND_LOG.level_procedure);

2106:
2107: print_g_rail_rec(
2108: p_rail_rec => px_rail_rec,
2109: p_msg => 'End get_tax, PX_RAIL_REC details',
2110: p_level => FND_LOG.level_procedure);
2111: END IF;
2112: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2113:
2114:

Line 2119: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN

2115: EXCEPTION
2116: WHEN FND_API.g_exc_error THEN
2117: x_return_status := FND_API.G_RET_STS_ERROR ;
2118:
2119: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2120: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
2121: END IF;
2122: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2123:

Line 2120: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);

2116: WHEN FND_API.g_exc_error THEN
2117: x_return_status := FND_API.G_RET_STS_ERROR ;
2118:
2119: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2120: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
2121: END IF;
2122: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2123:
2124: IF okc_hdr_csr%ISOPEN THEN

Line 2169: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

2165:
2166: WHEN FND_API.g_exc_unexpected_error THEN
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2168:
2169: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2170: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
2171: END IF;
2172: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2173:

Line 2170: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);

2166: WHEN FND_API.g_exc_unexpected_error THEN
2167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2168:
2169: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2170: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
2171: END IF;
2172: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2173:
2174: IF okc_hdr_csr%ISOPEN THEN

Line 2219: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN

2215:
2216: WHEN OTHERS THEN
2217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2218:
2219: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2220: --first log the sqlerrm
2221: l_error_text := substr (SQLERRM, 1, 240);
2222: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2223: --then add it to the message api list

Line 2222: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);

2218:
2219: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2220: --first log the sqlerrm
2221: l_error_text := substr (SQLERRM, 1, 240);
2222: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2223: --then add it to the message api list
2224: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2225: END IF;
2226: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );