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 477: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

473:
474:
475: BEGIN
476:
477: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
478: 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||
479: ' ,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||
480: ' ,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||
481: ' ,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 478: 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||

474:
475: BEGIN
476:
477: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
478: 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||
479: ' ,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||
480: ' ,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||
481: ' ,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);
482: END IF;

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

554: px_rail_rec.PAYMENT_TERM_ID := p_okc_rec.PAYMENT_TERM_ID;
555:
556: ------------------ SBG rule -------------------------------
557:
558: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
559: 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);
560: END IF;
561:
562:

Line 559: 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);

555:
556: ------------------ SBG rule -------------------------------
557:
558: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
559: 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);
560: END IF;
561:
562:
563: px_rail_rec.CUST_TRX_TYPE_ID := get_cust_trx_type_id(

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

563: px_rail_rec.CUST_TRX_TYPE_ID := get_cust_trx_type_id(
564: p_org_id => p_okc_rec.org_id,
565: p_inv_trx_type => p_oks_rec.INV_TRX_TYPE);
566:
567: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
568: 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);
569: END IF;
570:
571: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

Line 568: 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);

564: p_org_id => p_okc_rec.org_id,
565: p_inv_trx_type => p_oks_rec.INV_TRX_TYPE);
566:
567: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
568: 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);
569: END IF;
570:
571: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
572: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);

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

567: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
568: 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);
569: END IF;
570:
571: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
572: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
573: END IF;
574:
575: EXCEPTION

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

568: 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);
569: END IF;
570:
571: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
572: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
573: END IF;
574:
575: EXCEPTION
576:

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

575: EXCEPTION
576:
577: WHEN OTHERS THEN
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
580: --first log the sqlerrm
581: l_error_text := substr (SQLERRM, 1, 512);
582: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
583: --then add it to the message api list

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

578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
580: --first log the sqlerrm
581: l_error_text := substr (SQLERRM, 1, 512);
582: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
583: --then add it to the message api list
584: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
585: END IF;
586:

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

671: l_need_header_tax VARCHAR2(1);
672:
673: BEGIN
674:
675: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
676: 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||
677: ' ,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||
678: ' ,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||
679: ' ,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 676: 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||

672:
673: BEGIN
674:
675: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
676: 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||
677: ' ,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||
678: ' ,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||
679: ' ,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||
680: ' ,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 725: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

721: px_rail_rec.TAX_EXEMPT_FLAG := p_oks_line_rec.TAX_STATUS;
722:
723: IF(NVL(px_rail_rec.TAX_EXEMPT_FLAG, 'S') = 'E') THEN
724:
725: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
726: 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||
727: ' ,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);
728: END IF;
729:

Line 726: 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||

722:
723: IF(NVL(px_rail_rec.TAX_EXEMPT_FLAG, 'S') = 'E') THEN
724:
725: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
726: 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||
727: ' ,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);
728: END IF;
729:
730: IF(p_oks_line_rec.EXEMPT_CERTIFICATE_NUMBER IS NOT NULL)THEN

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

759:
760: IF get_taxcode_from_taxexempt_csr%FOUND THEN
761: px_rail_rec.TAX_CLASSIFICATION_CODE := l_tax_code;
762:
763: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
764: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_taxcode_from_taxexempt_csr','old contracts - TAX_CLASSIFICATION_CODE='|| l_tax_code);
765: END IF;
766: END IF;
767: CLOSE get_taxcode_from_taxexempt_csr;

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

760: IF get_taxcode_from_taxexempt_csr%FOUND THEN
761: px_rail_rec.TAX_CLASSIFICATION_CODE := l_tax_code;
762:
763: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
764: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_taxcode_from_taxexempt_csr','old contracts - TAX_CLASSIFICATION_CODE='|| l_tax_code);
765: END IF;
766: END IF;
767: CLOSE get_taxcode_from_taxexempt_csr;
768: --end npalepu

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

788: --default tax status to 'S'
789: px_rail_rec.TAX_EXEMPT_FLAG := 'S';
790: END IF;
791:
792: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
793: 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);
794: END IF;
795:
796: ELSIF p_oks_line_rec.TAX_CODE IS NOT NULL THEN

Line 793: 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);

789: px_rail_rec.TAX_EXEMPT_FLAG := 'S';
790: END IF;
791:
792: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
793: 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);
794: END IF;
795:
796: ELSIF p_oks_line_rec.TAX_CODE IS NOT NULL THEN
797:

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

812: --default tax status to 'S'
813: px_rail_rec.TAX_EXEMPT_FLAG := 'S';
814: END IF;
815:
816: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
817: 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);
818: END IF;
819:
820: ELSE

Line 817: 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);

813: px_rail_rec.TAX_EXEMPT_FLAG := 'S';
814: END IF;
815:
816: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
817: 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);
818: END IF;
819:
820: ELSE
821: --no tax code on line level, need header information

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

824: IF px_rail_rec.TAX_CLASSIFICATION_CODE IS NULL AND px_rail_rec.TAX_EXEMPT_FLAG IS NULL THEN --gbgupta
825: l_need_header_tax := 'Y';
826: END IF;
827:
828: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
829: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','Both tax classication code and tax code are null');
830: END IF;
831:
832: END IF; -- of IF p_oks_rec.TAX_CLASSIFICATION_CODE IS NOT NULL THEN

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

825: l_need_header_tax := 'Y';
826: END IF;
827:
828: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
829: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.tax_classification_code','Both tax classication code and tax code are null');
830: END IF;
831:
832: END IF; -- of IF p_oks_rec.TAX_CLASSIFICATION_CODE IS NOT NULL THEN
833:

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

868: -------------------- PTR rule -----------------------------
869: px_rail_rec.PAYMENT_TERM_ID := p_okc_line_rec.PAYMENT_TERM_ID;
870:
871:
872: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
873: 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);
874: END IF;
875:
876: EXCEPTION

Line 873: 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);

869: px_rail_rec.PAYMENT_TERM_ID := p_okc_line_rec.PAYMENT_TERM_ID;
870:
871:
872: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
873: 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);
874: END IF;
875:
876: EXCEPTION
877:

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

876: EXCEPTION
877:
878: WHEN OTHERS THEN
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
880: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
881: --first log the sqlerrm
882: l_error_text := substr (SQLERRM, 1, 512);
883: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
884: --then add it to the message api list

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

879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
880: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
881: --first log the sqlerrm
882: l_error_text := substr (SQLERRM, 1, 512);
883: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
884: --then add it to the message api list
885: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
886: END IF;
887:

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

966:
967:
968: BEGIN
969:
970: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
971: 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);
972: END IF;
973:
974: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 971: 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);

967:
968: BEGIN
969:
970: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
971: 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);
972: END IF;
973:
974: x_return_status := OKC_API.G_RET_STS_SUCCESS;
975:

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

1006: px_rail_rec.BILL_TO_CUST_ACCT_SITE_ID := cust_info_rec.CUST_ACCT_SITE_ID;
1007: END IF;
1008: CLOSE cur_cust_info;
1009:
1010: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1011: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
1012: END IF;
1013:
1014: EXCEPTION

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

1007: END IF;
1008: CLOSE cur_cust_info;
1009:
1010: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1011: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status);
1012: END IF;
1013:
1014: EXCEPTION
1015:

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

1014: EXCEPTION
1015:
1016: WHEN OTHERS THEN
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1019: --first log the sqlerrm
1020: l_error_text := substr (SQLERRM, 1, 512);
1021: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1022: --then add it to the message api list

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

1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1019: --first log the sqlerrm
1020: l_error_text := substr (SQLERRM, 1, 512);
1021: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1022: --then add it to the message api list
1023: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1024: END IF;
1025:

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

1048: l_legal_entity_id NUMBER;
1049: l_bill_from_location_id NUMBER; /* added for bug8323627 */
1050:
1051: BEGIN
1052: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1053: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','begin');
1054: END IF;
1055:
1056: --Initialize the global PL/SQL table

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

1049: l_bill_from_location_id NUMBER; /* added for bug8323627 */
1050:
1051: BEGIN
1052: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1053: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.begin','begin');
1054: END IF;
1055:
1056: --Initialize the global PL/SQL table
1057: ZX_GLOBAL_STRUCTURES_PKG.init_trx_line_dist_tbl(1);

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

1066: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.TRX_LEVEL_TYPE(1) := 'LINE';
1067: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_LEVEL_ACTION(1) := 'CREATE';
1068:
1069: /*Added by nchadala on 16-JUL-2007 for Bug#6164825*/
1070: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1071: 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);
1072: END IF;
1073: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(1) := p_rail_rec.cust_trx_type_id;
1074:

Line 1071: 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);

1067: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LINE_LEVEL_ACTION(1) := 'CREATE';
1068:
1069: /*Added by nchadala on 16-JUL-2007 for Bug#6164825*/
1070: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1071: 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);
1072: END IF;
1073: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.RECEIVABLES_TRX_TYPE_ID(1) := p_rail_rec.cust_trx_type_id;
1074:
1075: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.QUOTE_FLAG(1) := 'Y';

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

1082: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.CURRENCY_CONVERSION_TYPE(1) := p_rail_rec.conversion_type;
1083: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(1) := p_rail_rec.minimum_accountable_unit;
1084: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRECISION(1) := p_rail_rec.PRECISION;
1085:
1086: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1087: 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);
1088: END IF;
1089:
1090: l_legal_entity_id := get_legal_entity_id(

Line 1087: 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);

1083: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.MINIMUM_ACCOUNTABLE_UNIT(1) := p_rail_rec.minimum_accountable_unit;
1084: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.PRECISION(1) := p_rail_rec.PRECISION;
1085:
1086: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1087: 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);
1088: END IF;
1089:
1090: l_legal_entity_id := get_legal_entity_id(
1091: p_bill_to_cust_acct_id => p_rail_rec.bill_to_cust_acct_id,

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

1091: p_bill_to_cust_acct_id => p_rail_rec.bill_to_cust_acct_id,
1092: p_cust_trx_type_id => p_rail_rec.cust_trx_type_id,
1093: p_org_id => p_rail_rec.org_id);
1094:
1095: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1096: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_legal_entity_id','l_legal_entity_id='||l_legal_entity_id);
1097: END IF;
1098:
1099: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID(1) := l_legal_entity_id;

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

1092: p_cust_trx_type_id => p_rail_rec.cust_trx_type_id,
1093: p_org_id => p_rail_rec.org_id);
1094:
1095: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1096: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_legal_entity_id','l_legal_entity_id='||l_legal_entity_id);
1097: END IF;
1098:
1099: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.LEGAL_ENTITY_ID(1) := l_legal_entity_id;
1100:

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

1152: END;
1153: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(1) := l_bill_from_location_id;
1154: /* code added for bug8323627 -- end */
1155:
1156: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1157: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1158: END IF;
1159:
1160: EXCEPTION

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

1153: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.BILL_FROM_LOCATION_ID(1) := l_bill_from_location_id;
1154: /* code added for bug8323627 -- end */
1155:
1156: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1157: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1158: END IF;
1159:
1160: EXCEPTION
1161: WHEN OTHERS THEN

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

1158: END IF;
1159:
1160: EXCEPTION
1161: WHEN OTHERS THEN
1162: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1163: --first log the sqlerrm
1164: l_error_text := substr (SQLERRM, 1, 512);
1165: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1166: --then add it to the message api list

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

1161: WHEN OTHERS THEN
1162: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1163: --first log the sqlerrm
1164: l_error_text := substr (SQLERRM, 1, 512);
1165: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1166: --then add it to the message api list
1167: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1168: END IF;
1169: RAISE;

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

1208: l_set_of_books_id NUMBER;
1209:
1210: BEGIN
1211:
1212: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1213: 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);
1214: END IF;
1215:
1216: l_cust_trx_type_id := NULL;

Line 1213: 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);

1209:
1210: BEGIN
1211:
1212: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1213: 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);
1214: END IF;
1215:
1216: l_cust_trx_type_id := NULL;
1217:

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

1216: l_cust_trx_type_id := NULL;
1217:
1218: l_set_of_books_id := get_set_of_books_id(p_org_id);
1219:
1220: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1221: 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);
1222: END IF;
1223:
1224: IF p_inv_trx_type IS NOT NULL THEN

Line 1221: 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);

1217:
1218: l_set_of_books_id := get_set_of_books_id(p_org_id);
1219:
1220: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1221: 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);
1222: END IF;
1223:
1224: IF p_inv_trx_type IS NOT NULL THEN
1225: OPEN cur_custtrx_type_id(l_set_of_books_id, p_inv_trx_type, p_org_id);

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

1225: OPEN cur_custtrx_type_id(l_set_of_books_id, p_inv_trx_type, p_org_id);
1226: FETCH cur_custtrx_type_id INTO l_cust_trx_type_id;
1227: CLOSE cur_custtrx_type_id;
1228:
1229: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1230: 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);
1231: END IF;
1232:
1233: END IF;

Line 1230: 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);

1226: FETCH cur_custtrx_type_id INTO l_cust_trx_type_id;
1227: CLOSE cur_custtrx_type_id;
1228:
1229: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1230: 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);
1231: END IF;
1232:
1233: END IF;
1234:

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

1236: OPEN cur_default_custtrx_type_id(l_set_of_books_id,p_org_id);
1237: FETCH cur_default_custtrx_type_id INTO l_cust_trx_type_id;
1238: CLOSE cur_default_custtrx_type_id;
1239:
1240: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1241: 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);
1242: END IF;
1243:
1244: END IF;

Line 1241: 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);

1237: FETCH cur_default_custtrx_type_id INTO l_cust_trx_type_id;
1238: CLOSE cur_default_custtrx_type_id;
1239:
1240: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1241: 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);
1242: END IF;
1243:
1244: END IF;
1245:

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

1242: END IF;
1243:
1244: END IF;
1245:
1246: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1247: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','l_cust_trx_type_id='||l_cust_trx_type_id);
1248: END IF;
1249:
1250: RETURN l_cust_trx_type_id;

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

1243:
1244: END IF;
1245:
1246: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1247: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','l_cust_trx_type_id='||l_cust_trx_type_id);
1248: END IF;
1249:
1250: RETURN l_cust_trx_type_id;
1251:

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

1252: EXCEPTION
1253:
1254: WHEN OTHERS THEN
1255:
1256: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1257: --first log the sqlerrm
1258: l_error_text := substr (SQLERRM, 1, 512);
1259: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1260: --then add it to the message api list

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

1255:
1256: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1257: --first log the sqlerrm
1258: l_error_text := substr (SQLERRM, 1, 512);
1259: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1260: --then add it to the message api list
1261: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1262: END IF;
1263:

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

1311: l_otoc_le_info XLE_BUSINESSINFO_GRP.otoc_le_rec;
1312:
1313: BEGIN
1314:
1315: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1316: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id='||p_chr_id);
1317: END IF;
1318:
1319: OPEN cur_k_header(p_chr_id);

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

1312:
1313: BEGIN
1314:
1315: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1316: FND_LOG.string(FND_LOG.level_procedure, l_mod_name || '.begin', 'p_chr_id='||p_chr_id);
1317: END IF;
1318:
1319: OPEN cur_k_header(p_chr_id);
1320: FETCH cur_k_header INTO l_org_id, l_bill_to_cust_acct_id, l_inv_trx_type;

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

1319: OPEN cur_k_header(p_chr_id);
1320: FETCH cur_k_header INTO l_org_id, l_bill_to_cust_acct_id, l_inv_trx_type;
1321: CLOSE cur_k_header;
1322:
1323: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1324: 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);
1325: END IF;
1326:
1327: IF l_bill_to_cust_acct_id IS NULL THEN

Line 1324: 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);

1320: FETCH cur_k_header INTO l_org_id, l_bill_to_cust_acct_id, l_inv_trx_type;
1321: CLOSE cur_k_header;
1322:
1323: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1324: 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);
1325: END IF;
1326:
1327: IF l_bill_to_cust_acct_id IS NULL THEN
1328: OPEN cur_okc_lines(p_chr_id);

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

1328: OPEN cur_okc_lines(p_chr_id);
1329: FETCH cur_okc_lines INTO l_bill_to_cust_acct_id;
1330: CLOSE cur_okc_lines;
1331:
1332: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1333: 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);
1334: END IF;
1335: END IF;
1336:

Line 1333: 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);

1329: FETCH cur_okc_lines INTO l_bill_to_cust_acct_id;
1330: CLOSE cur_okc_lines;
1331:
1332: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1333: 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);
1334: END IF;
1335: END IF;
1336:
1337:

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

1338: l_cust_trx_type_id := get_cust_trx_type_id(
1339: p_org_id => l_org_id,
1340: p_inv_trx_type => l_inv_trx_type);
1341:
1342: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1343: 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);
1344: END IF;
1345:
1346: OPEN cur_batch_source_id(l_org_id);

Line 1343: 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);

1339: p_org_id => l_org_id,
1340: p_inv_trx_type => l_inv_trx_type);
1341:
1342: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1343: 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);
1344: END IF;
1345:
1346: OPEN cur_batch_source_id(l_org_id);
1347: FETCH cur_batch_source_id INTO l_batch_source_id;

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

1346: OPEN cur_batch_source_id(l_org_id);
1347: FETCH cur_batch_source_id INTO l_batch_source_id;
1348: CLOSE cur_batch_source_id;
1349:
1350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1351: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1352: END IF;
1353:
1354: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

1347: FETCH cur_batch_source_id INTO l_batch_source_id;
1348: CLOSE cur_batch_source_id;
1349:
1350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1351: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1352: END IF;
1353:
1354: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1355: 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 1354: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1350: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1351: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1352: END IF;
1353:
1354: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1355: 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||
1356: ' ,P_transaction_type_id: '|| l_cust_trx_type_id||' ,p_batch_source_id: '|| l_batch_source_id||' ,p_operating_unit_id: '|| l_org_id);
1357: END IF;
1358:

Line 1355: 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||

1351: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1352: END IF;
1353:
1354: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1355: 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||
1356: ' ,P_transaction_type_id: '|| l_cust_trx_type_id||' ,p_batch_source_id: '|| l_batch_source_id||' ,p_operating_unit_id: '|| l_org_id);
1357: END IF;
1358:
1359:

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

1368: x_otoc_le_info => l_otoc_le_info);
1369:
1370: l_legal_entity_id := l_otoc_le_info.LEGAL_ENTITY_ID;
1371:
1372: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1373: 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);
1374: END IF;
1375:
1376: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1373: 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);

1369:
1370: l_legal_entity_id := l_otoc_le_info.LEGAL_ENTITY_ID;
1371:
1372: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1373: 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);
1374: END IF;
1375:
1376: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1377: RAISE FND_API.g_exc_unexpected_error;

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

1378: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1379: RAISE FND_API.g_exc_error;
1380: END IF;
1381:
1382: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1383: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1384: END IF;
1385:
1386: RETURN (l_legal_entity_id);

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

1379: RAISE FND_API.g_exc_error;
1380: END IF;
1381:
1382: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1383: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1384: END IF;
1385:
1386: RETURN (l_legal_entity_id);
1387:

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

1388: EXCEPTION
1389:
1390: WHEN FND_API.g_exc_error THEN
1391:
1392: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1393: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1394: END IF;
1395:
1396: IF (cur_k_header%isopen) THEN

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

1389:
1390: WHEN FND_API.g_exc_error THEN
1391:
1392: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1393: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1394: END IF;
1395:
1396: IF (cur_k_header%isopen) THEN
1397: CLOSE cur_k_header;

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

1404: END IF;
1405:
1406: WHEN FND_API.g_exc_unexpected_error THEN
1407:
1408: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1409: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1410: END IF;
1411:
1412: IF (cur_k_header%isopen) THEN

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

1405:
1406: WHEN FND_API.g_exc_unexpected_error THEN
1407:
1408: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1409: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1410: END IF;
1411:
1412: IF (cur_k_header%isopen) THEN
1413: CLOSE cur_k_header;

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

1420: END IF;
1421:
1422: WHEN OTHERS THEN
1423:
1424: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1425: --first log the sqlerrm
1426: l_error_text := substr (SQLERRM, 1, 512);
1427: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1428: --then add it to the message api list

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

1423:
1424: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1425: --first log the sqlerrm
1426: l_error_text := substr (SQLERRM, 1, 512);
1427: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1428: --then add it to the message api list
1429: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1430: END IF;
1431:

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

1472: l_otoc_le_info XLE_BUSINESSINFO_GRP.otoc_le_rec;
1473:
1474: BEGIN
1475:
1476: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1477: 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);
1478: END IF;
1479:
1480:

Line 1477: 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);

1473:
1474: BEGIN
1475:
1476: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1477: 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);
1478: END IF;
1479:
1480:
1481: OPEN cur_batch_source_id;

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

1481: OPEN cur_batch_source_id;
1482: FETCH cur_batch_source_id INTO l_batch_source_id;
1483: CLOSE cur_batch_source_id;
1484:
1485: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1486: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1487: END IF;
1488:
1489: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

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

1482: FETCH cur_batch_source_id INTO l_batch_source_id;
1483: CLOSE cur_batch_source_id;
1484:
1485: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1486: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1487: END IF;
1488:
1489: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1490: 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 1489: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

1485: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1486: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1487: END IF;
1488:
1489: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1490: 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||
1491: ' ,P_transaction_type_id: '|| p_cust_trx_type_id||' ,p_batch_source_id: '|| l_batch_source_id||' ,p_operating_unit_id: '|| p_org_id);
1492: END IF;
1493:

Line 1490: 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||

1486: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.after_cur_batch_source_id', 'l_batch_source_id='||l_batch_source_id);
1487: END IF;
1488:
1489: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1490: 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||
1491: ' ,P_transaction_type_id: '|| p_cust_trx_type_id||' ,p_batch_source_id: '|| l_batch_source_id||' ,p_operating_unit_id: '|| p_org_id);
1492: END IF;
1493:
1494:

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

1503: x_otoc_Le_info => l_otoc_le_info);
1504:
1505: l_legal_entity_id := l_otoc_le_info.LEGAL_ENTITY_ID;
1506:
1507: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1508: 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);
1509: END IF;
1510:
1511: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1508: 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);

1504:
1505: l_legal_entity_id := l_otoc_le_info.LEGAL_ENTITY_ID;
1506:
1507: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1508: 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);
1509: END IF;
1510:
1511: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1512: RAISE FND_API.g_exc_unexpected_error;

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

1513: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1514: RAISE FND_API.g_exc_error;
1515: END IF;
1516:
1517: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1518: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1519: END IF;
1520:
1521: RETURN (l_legal_entity_id);

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

1514: RAISE FND_API.g_exc_error;
1515: END IF;
1516:
1517: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1518: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','end');
1519: END IF;
1520:
1521: RETURN (l_legal_entity_id);
1522:

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

1523: EXCEPTION
1524:
1525: WHEN FND_API.g_exc_error THEN
1526:
1527: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1528: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1529: END IF;
1530:
1531: IF (cur_batch_source_id%isopen) THEN

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

1524:
1525: WHEN FND_API.g_exc_error THEN
1526:
1527: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1528: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'end_error');
1529: END IF;
1530:
1531: IF (cur_batch_source_id%isopen) THEN
1532: CLOSE cur_batch_source_id;

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

1533: END IF;
1534:
1535: WHEN FND_API.g_exc_unexpected_error THEN
1536:
1537: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1538: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1539: END IF;
1540:
1541: IF (cur_batch_source_id%isopen) THEN

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

1534:
1535: WHEN FND_API.g_exc_unexpected_error THEN
1536:
1537: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1538: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_unexpected_error', 'end_unexpected_error');
1539: END IF;
1540:
1541: IF (cur_batch_source_id%isopen) THEN
1542: CLOSE cur_batch_source_id;

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

1543: END IF;
1544:
1545: WHEN OTHERS THEN
1546:
1547: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1548: --first log the sqlerrm
1549: l_error_text := substr (SQLERRM, 1, 512);
1550: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1551: --then add it to the message api list

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

1546:
1547: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
1548: --first log the sqlerrm
1549: l_error_text := substr (SQLERRM, 1, 512);
1550: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
1551: --then add it to the message api list
1552: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
1553: END IF;
1554:

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

1683: */
1684: --end npalepu
1685:
1686: --0. log the input details
1687: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1688: 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);
1689: print_g_rail_rec(
1690: p_rail_rec => px_rail_rec,
1691: p_msg => 'Begin get_tax, PX_RAIL_REC details',

Line 1688: 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);

1684: --end npalepu
1685:
1686: --0. log the input details
1687: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
1688: 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);
1689: print_g_rail_rec(
1690: p_rail_rec => px_rail_rec,
1691: p_msg => 'Begin get_tax, PX_RAIL_REC details',
1692: p_level => FND_LOG.level_procedure);

Line 1692: p_level => FND_LOG.level_procedure);

1688: 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);
1689: print_g_rail_rec(
1690: p_rail_rec => px_rail_rec,
1691: p_msg => 'Begin get_tax, PX_RAIL_REC details',
1692: p_level => FND_LOG.level_procedure);
1693: END IF;
1694:
1695: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1696: IF(FND_API.G_TRUE = p_init_msg_list) THEN

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

1702: FETCH okc_hdr_csr INTO l_okc_hdr_rec;
1703: IF (okc_hdr_csr%notfound) THEN
1704: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
1705: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1706: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1707: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
1708: END IF;
1709: FND_MSG_PUB.ADD;
1710: CLOSE okc_hdr_csr;

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

1703: IF (okc_hdr_csr%notfound) THEN
1704: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_INV_CONTRACT');
1705: FND_MESSAGE.set_token('CONTRACT_ID', p_chr_id);
1706: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1707: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.basic_validation', FALSE);
1708: END IF;
1709: FND_MSG_PUB.ADD;
1710: CLOSE okc_hdr_csr;
1711: RAISE FND_API.g_exc_error;

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

1711: RAISE FND_API.g_exc_error;
1712: END IF;
1713: CLOSE okc_hdr_csr;
1714:
1715: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1716: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_okc_hdr_csr', 'ok');
1717: END IF;
1718:
1719: G_RAIL_REC.HEADER_ID := p_chr_id;

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

1712: END IF;
1713: CLOSE okc_hdr_csr;
1714:
1715: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1716: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_okc_hdr_csr', 'ok');
1717: END IF;
1718:
1719: G_RAIL_REC.HEADER_ID := p_chr_id;
1720: G_RAIL_REC.LINE_ID := p_cle_id;

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

1729: OPEN oks_hdr_csr(p_chr_id);
1730: FETCH oks_hdr_csr INTO l_oks_hdr_rec;
1731: CLOSE oks_hdr_csr;
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||'.after_oks_hdr_csr', 'ok');
1735: END IF;
1736:
1737: --3. populate hdr rules in G_RAIL_REC

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

1730: FETCH oks_hdr_csr INTO l_oks_hdr_rec;
1731: CLOSE oks_hdr_csr;
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||'.after_oks_hdr_csr', 'ok');
1735: END IF;
1736:
1737: --3. populate hdr rules in G_RAIL_REC
1738: get_hdr_rules(

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

1740: p_okc_rec => l_okc_hdr_rec,
1741: px_rail_rec => G_RAIL_REC,
1742: x_return_status => x_return_status);
1743:
1744: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1745: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_rules', 'x_return_status='||x_return_status);
1746: print_g_rail_rec(
1747: p_rail_rec => G_RAIL_REC,
1748: p_msg => 'After calling get_hdr_rules, G_RAIL_REC details',

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

1741: px_rail_rec => G_RAIL_REC,
1742: x_return_status => x_return_status);
1743:
1744: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1745: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_rules', 'x_return_status='||x_return_status);
1746: print_g_rail_rec(
1747: p_rail_rec => G_RAIL_REC,
1748: p_msg => 'After calling get_hdr_rules, G_RAIL_REC details',
1749: p_level => FND_LOG.level_statement);

Line 1749: p_level => FND_LOG.level_statement);

1745: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_rules', 'x_return_status='||x_return_status);
1746: print_g_rail_rec(
1747: p_rail_rec => G_RAIL_REC,
1748: p_msg => 'After calling get_hdr_rules, G_RAIL_REC details',
1749: p_level => FND_LOG.level_statement);
1750: END IF;
1751:
1752:
1753: --4. find out if p_cle_id is top line (for subscription) or sub line id

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

1765: --end npalepu
1766: END IF;
1767: CLOSE cur_sub_lines;
1768:
1769: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1770: 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);
1771: END IF;
1772:
1773: --5. All tax details except amount are at the topline level

Line 1770: 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);

1766: END IF;
1767: CLOSE cur_sub_lines;
1768:
1769: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1770: 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);
1771: END IF;
1772:
1773: --5. All tax details except amount are at the topline level
1774: -- get the topline details from okc table

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

1777: IF okc_line_csr%FOUND THEN
1778: G_RAIL_REC.UNIT_SELLING_PRICE := nvl(l_okc_line_rec.price_unit, l_okc_line_rec.price_negotiated);
1779: G_RAIL_REC.AMOUNT := nvl(l_okc_line_rec.price_negotiated, 0);
1780:
1781: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1782: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_line_open_oks_line_csr', 'line id='||l_okc_line_rec.id);
1783: END IF;
1784:
1785: --6. get the topline details from oks table

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

1778: G_RAIL_REC.UNIT_SELLING_PRICE := nvl(l_okc_line_rec.price_unit, l_okc_line_rec.price_negotiated);
1779: G_RAIL_REC.AMOUNT := nvl(l_okc_line_rec.price_negotiated, 0);
1780:
1781: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1782: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.top_line_open_oks_line_csr', 'line id='||l_okc_line_rec.id);
1783: END IF;
1784:
1785: --6. get the topline details from oks table
1786: OPEN oks_line_csr(p_chr_id, l_okc_line_rec.id);

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

1802: px_rail_rec => G_RAIL_REC,
1803: x_return_status => x_return_status,
1804: x_need_header_tax => l_need_header_tax);
1805:
1806: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1807: 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);
1808: print_g_rail_rec(
1809: p_rail_rec => G_RAIL_REC,
1810: p_msg => 'After calling get_line_rules, G_RAIL_REC details',

Line 1807: 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);

1803: x_return_status => x_return_status,
1804: x_need_header_tax => l_need_header_tax);
1805:
1806: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1807: 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);
1808: print_g_rail_rec(
1809: p_rail_rec => G_RAIL_REC,
1810: p_msg => 'After calling get_line_rules, G_RAIL_REC details',
1811: p_level => FND_LOG.level_statement);

Line 1811: p_level => FND_LOG.level_statement);

1807: 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);
1808: print_g_rail_rec(
1809: p_rail_rec => G_RAIL_REC,
1810: p_msg => 'After calling get_line_rules, G_RAIL_REC details',
1811: p_level => FND_LOG.level_statement);
1812: END IF;
1813:
1814: --8. get the item details
1815: OPEN cur_item(l_okc_line_rec.id);

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

1839: p_okc_line_rec => l_okc_line_rec,
1840: px_rail_rec => G_RAIL_REC,
1841: x_return_status => x_return_status);
1842:
1843: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1844: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_tax', 'x_return_status='||x_return_status);
1845: print_g_rail_rec(
1846: p_rail_rec => G_RAIL_REC,
1847: p_msg => 'After calling get_hdr_tax on top line, G_RAIL_REC details',

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

1840: px_rail_rec => G_RAIL_REC,
1841: x_return_status => x_return_status);
1842:
1843: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1844: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_tax', 'x_return_status='||x_return_status);
1845: print_g_rail_rec(
1846: p_rail_rec => G_RAIL_REC,
1847: p_msg => 'After calling get_hdr_tax on top line, G_RAIL_REC details',
1848: p_level => FND_LOG.level_statement);

Line 1848: p_level => FND_LOG.level_statement);

1844: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_get_hdr_tax', 'x_return_status='||x_return_status);
1845: print_g_rail_rec(
1846: p_rail_rec => G_RAIL_REC,
1847: p_msg => 'After calling get_hdr_tax on top line, G_RAIL_REC details',
1848: p_level => FND_LOG.level_statement);
1849: END IF;
1850:
1851: END IF; --of IF l_need_header_tax = 'Y' THEN
1852:

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

1858: --else get the topline values
1859: IF (nvl(l_parent_cle_id, -99) = p_cle_id) THEN
1860:
1861: --p_cle_id is id of topline, do nothing
1862: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1863: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.amount','p_cle_id='||p_cle_id||' is topline id');
1864: END IF;
1865:
1866: ELSE

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

1859: IF (nvl(l_parent_cle_id, -99) = p_cle_id) THEN
1860:
1861: --p_cle_id is id of topline, do nothing
1862: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1863: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.amount','p_cle_id='||p_cle_id||' is topline id');
1864: END IF;
1865:
1866: ELSE
1867:

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

1868: --p_cle_id is id of subline, get the subline amount
1869: G_RAIL_REC.UNIT_SELLING_PRICE := nvl(sub_line_rec.price_unit, sub_line_rec.price_negotiated);
1870: G_RAIL_REC.AMOUNT := nvl(sub_line_rec.price_negotiated, 0);
1871:
1872: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1873: 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);
1874: END IF;
1875:
1876: END IF;

Line 1873: 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);

1869: G_RAIL_REC.UNIT_SELLING_PRICE := nvl(sub_line_rec.price_unit, sub_line_rec.price_negotiated);
1870: G_RAIL_REC.AMOUNT := nvl(sub_line_rec.price_negotiated, 0);
1871:
1872: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1873: 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);
1874: END IF;
1875:
1876: END IF;
1877:

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

1902: CLOSE get_operating_unit;
1903:
1904: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_TRX_TYPE');
1905: FND_MESSAGE.set_token('NAME', l_op_unit_name);
1906: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1907: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.no_trx_type', FALSE);
1908: END IF;
1909: FND_MSG_PUB.ADD;
1910: RAISE FND_API.g_exc_error;

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

1903:
1904: FND_MESSAGE.set_name(G_OKS_APP_NAME, 'OKS_NO_TRX_TYPE');
1905: FND_MESSAGE.set_token('NAME', l_op_unit_name);
1906: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
1907: FND_LOG.message(FND_LOG.level_error, l_mod_name || '.no_trx_type', FALSE);
1908: END IF;
1909: FND_MSG_PUB.ADD;
1910: RAISE FND_API.g_exc_error;
1911: END IF;

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

1926: p_chr_id => p_chr_id,
1927: px_rail_rec => G_RAIL_REC,
1928: x_return_status => x_return_status);
1929:
1930: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1931: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_tax_integration', 'x_return_status='||x_return_status);
1932: END IF;
1933:
1934: --in case the exemption control is null, we default it to 'S'

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

1927: px_rail_rec => G_RAIL_REC,
1928: x_return_status => x_return_status);
1929:
1930: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1931: FND_LOG.string(FND_LOG.level_statement, l_mod_name||'.after_tax_integration', 'x_return_status='||x_return_status);
1932: END IF;
1933:
1934: --in case the exemption control is null, we default it to 'S'
1935: G_RAIL_REC.tax_exempt_flag := nvl(G_RAIL_REC.tax_exempt_flag, 'S');

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

1941: OPEN Cur_Batch_Source_Id(G_RAIL_REC.org_id);
1942: FETCH Cur_Batch_Source_Id INTO l_batch_source_id;
1943: CLOSE Cur_Batch_Source_Id;
1944:
1945: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1946: 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'||
1947: ' ,p_tax_exempt_number='|| G_RAIL_REC.EXEMPT_CERTIFICATE_NUMBER ||
1948: ' ,p_tax_exempt_reason_code='|| G_RAIL_REC.EXEMPT_REASON_CODE ||
1949: ' ,p_ship_to_org_id='|| G_RAIL_REC.ship_to_site_use_id ||

Line 1946: 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'||

1942: FETCH Cur_Batch_Source_Id INTO l_batch_source_id;
1943: CLOSE Cur_Batch_Source_Id;
1944:
1945: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1946: 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'||
1947: ' ,p_tax_exempt_number='|| G_RAIL_REC.EXEMPT_CERTIFICATE_NUMBER ||
1948: ' ,p_tax_exempt_reason_code='|| G_RAIL_REC.EXEMPT_REASON_CODE ||
1949: ' ,p_ship_to_org_id='|| G_RAIL_REC.ship_to_site_use_id ||
1950: ' ,p_invoice_to_org_id='|| G_RAIL_REC.bill_to_site_use_id ||

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

1979: x_return_status => l_ret_stat,
1980: x_msg_count => l_msg_count,
1981: x_msg_data => l_msg_data);
1982:
1983: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1984: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.After_VALIDATE_TAX_EXEMPTIONS', 'l_valid_flag='||l_valid_flag);
1985: End If;
1986:
1987: IF l_valid_flag <> 'Y' THEN

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

1980: x_msg_count => l_msg_count,
1981: x_msg_data => l_msg_data);
1982:
1983: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
1984: FND_LOG.string(FND_LOG.level_statement, l_mod_name || '.After_VALIDATE_TAX_EXEMPTIONS', 'l_valid_flag='||l_valid_flag);
1985: End If;
1986:
1987: IF l_valid_flag <> 'Y' THEN
1988: --reset the tax_exempt_flag to 'S'

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

1997: END IF;
1998: EXCEPTION
1999: WHEN OTHERS THEN
2000:
2001: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2002: --first log the sqlerrm
2003: l_error_text := substr (SQLERRM, 1, 512);
2004: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.exemption_validation_error', l_error_text);
2005: --then add it to the message api list

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

2000:
2001: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2002: --first log the sqlerrm
2003: l_error_text := substr (SQLERRM, 1, 512);
2004: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.exemption_validation_error', l_error_text);
2005: --then add it to the message api list
2006: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2007: END IF;
2008: IF Cur_Batch_Source_Id%ISOPEN THEN

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

2015:
2016: --16. get the default tcc if null
2017: --fix bug 4952080, need to call the defaulting logic if tax_classification_code is null
2018: IF G_RAIL_REC.tax_classification_code IS NULL THEN
2019: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2020: 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'||
2021: ' ,p_ship_to_site_use_id='|| G_RAIL_REC.ship_to_site_use_id ||
2022: ' ,p_bill_to_site_use_id='|| G_RAIL_REC.bill_to_site_use_id ||
2023: ' ,p_inventory_item_id='|| G_RAIL_REC.inventory_item_id ||

Line 2020: 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'||

2016: --16. get the default tcc if null
2017: --fix bug 4952080, need to call the defaulting logic if tax_classification_code is null
2018: IF G_RAIL_REC.tax_classification_code IS NULL THEN
2019: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2020: 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'||
2021: ' ,p_ship_to_site_use_id='|| G_RAIL_REC.ship_to_site_use_id ||
2022: ' ,p_bill_to_site_use_id='|| G_RAIL_REC.bill_to_site_use_id ||
2023: ' ,p_inventory_item_id='|| G_RAIL_REC.inventory_item_id ||
2024: ' ,p_organization_id='|| G_RAIL_REC.org_id ||

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

2050:
2051: EXCEPTION
2052: WHEN OTHERS THEN
2053:
2054: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2055: --first log the sqlerrm
2056: l_error_text := substr (SQLERRM, 1, 512);
2057: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.default_tcc_error', l_error_text);
2058: --then add it to the message api list

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

2053:
2054: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2055: --first log the sqlerrm
2056: l_error_text := substr (SQLERRM, 1, 512);
2057: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.default_tcc_error', l_error_text);
2058: --then add it to the message api list
2059: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2060: END IF;
2061: RAISE FND_API.g_exc_unexpected_error;

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

2061: RAISE FND_API.g_exc_unexpected_error;
2062:
2063: END; --of inner block
2064:
2065: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2066: 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);
2067: END IF;
2068:
2069: G_RAIL_REC.tax_classification_code := l_default_tax_code;

Line 2066: 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);

2062:
2063: END; --of inner block
2064:
2065: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2066: 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);
2067: END IF;
2068:
2069: G_RAIL_REC.tax_classification_code := l_default_tax_code;
2070:

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

2071: END IF; --of IF G_RAIL_REC.tax_classification_code IS NULL
2072: --end of bug 4952080
2073:
2074:
2075: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2076: print_g_rail_rec(
2077: p_rail_rec => G_RAIL_REC,
2078: p_msg => 'Final state of G_RAIL_REC details, before calling ZX_API_PUB.calculate_tax',
2079: p_level => FND_LOG.level_statement);

Line 2079: p_level => FND_LOG.level_statement);

2075: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2076: print_g_rail_rec(
2077: p_rail_rec => G_RAIL_REC,
2078: p_msg => 'Final state of G_RAIL_REC details, before calling ZX_API_PUB.calculate_tax',
2079: p_level => FND_LOG.level_statement);
2080: END IF;
2081:
2082:
2083: --17. populate pl/sql global table

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

2084: init_zx_trxline_dist_tbl(p_rail_rec => G_RAIL_REC);
2085:
2086:
2087: --18. finally call the zx api to calculate tax
2088: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2089: 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.'||
2090: ' ,trec.internal_organization_id='||transaction_rec.internal_organization_id||
2091: ' ,trec.application_id='||transaction_rec.application_id||
2092: ' ,trec.entity_code='||transaction_rec.entity_code||

Line 2089: 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.'||

2085:
2086:
2087: --18. finally call the zx api to calculate tax
2088: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2089: 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.'||
2090: ' ,trec.internal_organization_id='||transaction_rec.internal_organization_id||
2091: ' ,trec.application_id='||transaction_rec.application_id||
2092: ' ,trec.entity_code='||transaction_rec.entity_code||
2093: ' ,trec.event_class_code='||transaction_rec.event_class_code||

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

2107: p_quote_flag => 'Y',
2108: p_data_transfer_mode => 'PLS',
2109: x_doc_level_recalc_flag => l_doc_level_recalc_flag);
2110:
2111: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2112: 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);
2113: END IF;
2114:
2115: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2112: 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);

2108: p_data_transfer_mode => 'PLS',
2109: x_doc_level_recalc_flag => l_doc_level_recalc_flag);
2110:
2111: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2112: 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);
2113: END IF;
2114:
2115: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
2116: RAISE FND_API.g_exc_unexpected_error;

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

2143: px_rail_rec := G_RAIL_REC;
2144:
2145:
2146: --20. log the tax details and exit
2147: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2148: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status||' ,px_rail_rec(key details). '||
2149: ' .AMOUNT=' || px_rail_rec.AMOUNT ||
2150: ' .TAX_VALUE=' || px_rail_rec.TAX_VALUE ||
2151: ' .TAX_RATE=' || px_rail_rec.TAX_RATE ||

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

2144:
2145:
2146: --20. log the tax details and exit
2147: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2148: FND_LOG.string(FND_LOG.level_procedure, l_mod_name||'.end','x_return_status='||x_return_status||' ,px_rail_rec(key details). '||
2149: ' .AMOUNT=' || px_rail_rec.AMOUNT ||
2150: ' .TAX_VALUE=' || px_rail_rec.TAX_VALUE ||
2151: ' .TAX_RATE=' || px_rail_rec.TAX_RATE ||
2152: ' .AMOUNT_INCLUDES_TAX_FLAG=' || px_rail_rec.AMOUNT_INCLUDES_TAX_FLAG ||

Line 2158: p_level => FND_LOG.level_procedure);

2154:
2155: print_g_rail_rec(
2156: p_rail_rec => px_rail_rec,
2157: p_msg => 'End get_tax, PX_RAIL_REC details',
2158: p_level => FND_LOG.level_procedure);
2159: END IF;
2160: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2161:
2162:

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

2163: EXCEPTION
2164: WHEN FND_API.g_exc_error THEN
2165: x_return_status := FND_API.G_RET_STS_ERROR ;
2166:
2167: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2168: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
2169: END IF;
2170: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2171:

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

2164: WHEN FND_API.g_exc_error THEN
2165: x_return_status := FND_API.G_RET_STS_ERROR ;
2166:
2167: IF (FND_LOG.level_error >= FND_LOG.g_current_runtime_level) THEN
2168: FND_LOG.string(FND_LOG.level_error, l_mod_name || '.end_error', 'x_return_status=' || x_return_status);
2169: END IF;
2170: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2171:
2172: IF okc_hdr_csr%ISOPEN THEN

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

2213:
2214: WHEN FND_API.g_exc_unexpected_error THEN
2215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2216:
2217: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2218: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
2219: END IF;
2220: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2221:

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

2214: WHEN FND_API.g_exc_unexpected_error THEN
2215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2216:
2217: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2218: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_unexpected_error', 'x_return_status=' || x_return_status);
2219: END IF;
2220: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
2221:
2222: IF okc_hdr_csr%ISOPEN THEN

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

2263:
2264: WHEN OTHERS THEN
2265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2266:
2267: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2268: --first log the sqlerrm
2269: l_error_text := substr (SQLERRM, 1, 240);
2270: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2271: --then add it to the message api list

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

2266:
2267: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) THEN
2268: --first log the sqlerrm
2269: l_error_text := substr (SQLERRM, 1, 240);
2270: FND_LOG.string(FND_LOG.level_unexpected, l_mod_name || '.end_other_error', l_error_text);
2271: --then add it to the message api list
2272: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, l_error_text);
2273: END IF;
2274: FND_MSG_PUB.count_and_get(p_count => x_msg_count, p_data => x_msg_data );