eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_PROCESS_CEC_PVT dependencies on ZX_TDS_PROCESS_CEC_PVT

Line 1: PACKAGE BODY ZX_TDS_PROCESS_CEC_PVT as

1: PACKAGE BODY ZX_TDS_PROCESS_CEC_PVT as
2: /* $Header: zxdilcecevalpvb.pls 120.17.12010000.2 2009/04/02 06:58:12 ssanka ship $ */
3:
4: ----------------------------
5: -- Constants

Line 192: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines.BEGIN',

188:
189:
190: IF (g_level_statement >= g_current_runtime_level ) THEN
191: FND_LOG.STRING(g_level_statement,
192: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines.BEGIN',
193: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec_lines(+)');
194:
195: END IF;
196:

Line 193: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec_lines(+)');

189:
190: IF (g_level_statement >= g_current_runtime_level ) THEN
191: FND_LOG.STRING(g_level_statement,
192: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines.BEGIN',
193: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec_lines(+)');
194:
195: END IF;
196:
197: l_temp :=0;

Line 216: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines',

212: -- First Execute with all "AND" only. Each function in the condition
213: -- sets the global flag accordingly.
214: IF (g_level_statement >= g_current_runtime_level ) THEN
215: FND_LOG.STRING(g_level_statement,
216: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines',
217: 'Compiled Condition: ' || l_and_condition);
218: END IF;
219:
220: EXECUTE IMMEDIATE 'BEGIN '|| l_and_condition ||'

Line 226: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is satisfied ');

222:
223: IF (g_level_statement >= g_current_runtime_level ) THEN
224: IF l_temp = 1 THEN
225: FND_LOG.STRING(g_level_statement,
226: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is satisfied ');
227: ELSE
228: FND_LOG.STRING(g_level_statement,
229: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is NOT satisfied ');
230: END IF;

Line 229: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is NOT satisfied ');

225: FND_LOG.STRING(g_level_statement,
226: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is satisfied ');
227: ELSE
228: FND_LOG.STRING(g_level_statement,
229: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is NOT satisfied ');
230: END IF;
231: END IF;
232: end comment out for bug 4417523 */
233: --

Line 238: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines',

234: -- Now execute with original conditions to evaluate.
235: --
236: IF (g_level_statement >= g_current_runtime_level ) THEN
237: FND_LOG.STRING(g_level_statement,
238: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines',
239: 'Compiled Condition: ' || p_compiled_condition);
240: END IF;
241:
242: EXECUTE IMMEDIATE 'BEGIN '|| p_compiled_condition||

Line 248: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is satisfied ');

244:
245: IF (g_level_statement >= g_current_runtime_level ) THEN
246: IF l_temp = 1 THEN
247: FND_LOG.STRING(g_level_statement,
248: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is satisfied ');
249: ELSE
250: FND_LOG.STRING(g_level_statement,
251: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is NOT satisfied ');
252: END IF;

Line 251: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is NOT satisfied ');

247: FND_LOG.STRING(g_level_statement,
248: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is satisfied ');
249: ELSE
250: FND_LOG.STRING(g_level_statement,
251: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is NOT satisfied ');
252: END IF;
253: END IF;
254:
255: EXCEPTION

Line 259: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Error Message: ' || sqlerrm);

255: EXCEPTION
256: WHEN OTHERS THEN
257: IF (g_level_unexpected >= g_current_runtime_level ) THEN
258: FND_LOG.STRING(g_level_unexpected,
259: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Error Message: ' || sqlerrm);
260: END IF;
261: app_exception.raise_exception;
262: END;
263: if l_temp = 1 then

Line 272: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines.END',

268: end if;
269: IF (g_level_statement >= g_current_runtime_level ) THEN
270:
271: FND_LOG.STRING(g_level_statement,
272: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines.END',
273: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec_lines(-)');
274: END IF;
275:
276: return l_result;

Line 273: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec_lines(-)');

269: IF (g_level_statement >= g_current_runtime_level ) THEN
270:
271: FND_LOG.STRING(g_level_statement,
272: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines.END',
273: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec_lines(-)');
274: END IF;
275:
276: return l_result;
277: end evaluate_cec_lines;

Line 301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action.BEGIN',

297:
298: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
299: IF (g_level_statement >= g_current_runtime_level ) THEN
300: FND_LOG.STRING(g_level_statement,
301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action.BEGIN',
302: 'ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action (+)');
303: END IF;
304:
305: pr_do_not_use_this_tax_flag := FALSE;

Line 302: 'ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action (+)');

298: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
299: IF (g_level_statement >= g_current_runtime_level ) THEN
300: FND_LOG.STRING(g_level_statement,
301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action.BEGIN',
302: 'ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action (+)');
303: END IF;
304:
305: pr_do_not_use_this_tax_flag := FALSE;
306: pr_do_not_use_this_group_flag := FALSE;

Line 313: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',

309: BEGIN
310:
311: IF (g_level_statement >= g_current_runtime_level ) THEN
312: FND_LOG.STRING(g_level_statement,
313: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
314: 'Compiled Action: ' || p_compiled_action);
315: END IF;
316:
317: IF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.USE_THIS_TAX_CODE(') >0) THEN

Line 317: IF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.USE_THIS_TAX_CODE(') >0) THEN

313: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
314: 'Compiled Action: ' || p_compiled_action);
315: END IF;
316:
317: IF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.USE_THIS_TAX_CODE(') >0) THEN
318: IF (g_level_statement >= g_current_runtime_level ) THEN
319: FND_LOG.STRING(g_level_statement,
320: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
321: 'Use this Tax');

Line 320: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',

316:
317: IF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.USE_THIS_TAX_CODE(') >0) THEN
318: IF (g_level_statement >= g_current_runtime_level ) THEN
319: FND_LOG.STRING(g_level_statement,
320: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
321: 'Use this Tax');
322: END IF;
323: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_CODE(') >0) THEN
324: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 323: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_CODE(') >0) THEN

319: FND_LOG.STRING(g_level_statement,
320: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
321: 'Use this Tax');
322: END IF;
323: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_CODE(') >0) THEN
324: IF (g_level_statement >= g_current_runtime_level ) THEN
325: FND_LOG.STRING(g_level_statement,
326: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
327: 'DO NOT use this Tax');

Line 326: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',

322: END IF;
323: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_CODE(') >0) THEN
324: IF (g_level_statement >= g_current_runtime_level ) THEN
325: FND_LOG.STRING(g_level_statement,
326: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
327: 'DO NOT use this Tax');
328: END IF;
329: pr_do_not_use_this_tax_flag := TRUE;
330:

Line 331: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.USE_THIS_TAX_GROUP(') >0) THEN

327: 'DO NOT use this Tax');
328: END IF;
329: pr_do_not_use_this_tax_flag := TRUE;
330:
331: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.USE_THIS_TAX_GROUP(') >0) THEN
332: IF (g_level_statement >= g_current_runtime_level ) THEN
333: FND_LOG.STRING(g_level_statement,
334: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
335: 'Use this Tax Condition Group');

Line 334: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',

330:
331: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.USE_THIS_TAX_GROUP(') >0) THEN
332: IF (g_level_statement >= g_current_runtime_level ) THEN
333: FND_LOG.STRING(g_level_statement,
334: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
335: 'Use this Tax Condition Group');
336: END IF;
337: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_GROUP(') >0) THEN
338: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 337: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_GROUP(') >0) THEN

333: FND_LOG.STRING(g_level_statement,
334: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
335: 'Use this Tax Condition Group');
336: END IF;
337: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_GROUP(') >0) THEN
338: IF (g_level_statement >= g_current_runtime_level ) THEN
339: FND_LOG.STRING(g_level_statement,
340: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
341: 'DO NOT use this Tax Condition Group');

Line 340: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',

336: END IF;
337: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_GROUP(') >0) THEN
338: IF (g_level_statement >= g_current_runtime_level ) THEN
339: FND_LOG.STRING(g_level_statement,
340: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
341: 'DO NOT use this Tax Condition Group');
342: END IF;
343: pr_do_not_use_this_group_flag := TRUE;
344:

Line 356: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',

352: EXCEPTION
353: WHEN OTHERS THEN
354: IF (g_level_statement >= g_current_runtime_level ) THEN
355: FND_LOG.STRING(g_level_statement,
356: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
357: 'Error Message: ' || sqlerrm);
358: END IF;
359: app_exception.raise_exception;
360: END;

Line 365: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action.END',

361: end if;
362: IF (g_level_statement >= g_current_runtime_level ) THEN
363:
364: FND_LOG.STRING(g_level_statement,
365: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action.END',
366: 'ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action (-)');
367: END IF;
368: end evaluate_cec_action;
369:

Line 366: 'ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action (-)');

362: IF (g_level_statement >= g_current_runtime_level ) THEN
363:
364: FND_LOG.STRING(g_level_statement,
365: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action.END',
366: 'ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action (-)');
367: END IF;
368: end evaluate_cec_action;
369:
370: /*===========================================================================+

Line 401: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines.BEGIN',

397:
398: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
399: IF (g_level_statement >= g_current_runtime_level ) THEN
400: FND_LOG.STRING(g_level_statement,
401: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines.BEGIN',
402: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines (+)');
403:
404: END IF;
405:

Line 402: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines (+)');

398: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
399: IF (g_level_statement >= g_current_runtime_level ) THEN
400: FND_LOG.STRING(g_level_statement,
401: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines.BEGIN',
402: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines (+)');
403:
404: END IF;
405:
406: for cec_rec in cec_csr(p_cec_id) LOOP

Line 416: 'ZX_TDS_PROCESS_CEC_PVT.'|| cec_rec.tax_condition_entity||'(';

412: -- SHIP_FROM, SHIP_TO, POO, POA, ITEM, TRX, BILL_TO ...
413: --
414: if (cec_rec.tax_condition_entity is not null) then
415: l_compiled_line := l_compiled_line ||
416: 'ZX_TDS_PROCESS_CEC_PVT.'|| cec_rec.tax_condition_entity||'(';
417: l_end := ')';
418: end if;
419: --
420: -- COUNTRY, STATE, PROVINCE, CITY, TAX_CLASSIFICATION ...

Line 454: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines.END',

450:
451: IF (g_level_statement >= g_current_runtime_level ) THEN
452:
453: FND_LOG.STRING(g_level_statement,
454: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines.END',
455: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines (-)');
456: END IF;
457: return l_compiled_line;
458: end create_compiled_lines;

Line 455: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines (-)');

451: IF (g_level_statement >= g_current_runtime_level ) THEN
452:
453: FND_LOG.STRING(g_level_statement,
454: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines.END',
455: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines (-)');
456: END IF;
457: return l_compiled_line;
458: end create_compiled_lines;
459:

Line 495: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_action.BEGIN',

491:
492: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
493: IF (g_level_statement >= g_current_runtime_level ) THEN
494: FND_LOG.STRING(g_level_statement,
495: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_action.BEGIN',
496: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_action (+)');
497:
498: END IF;
499: l_counter := 1;

Line 496: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_action (+)');

492: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
493: IF (g_level_statement >= g_current_runtime_level ) THEN
494: FND_LOG.STRING(g_level_statement,
495: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_action.BEGIN',
496: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_action (+)');
497:
498: END IF;
499: l_counter := 1;
500: pr_action_rec_tbl.delete;

Line 506: l_compiled_action := l_compiled_action || 'ZX_TDS_PROCESS_CEC_PVT.'||

502: for action_rec in action_csr(p_cec_id, p_action_type)
503: LOOP
504: -- ERROR_MESSAGE, SYSTEM_ERROR, USE_TAX_CODE ...
505: if (action_rec.tax_condition_action_code is not null) then
506: l_compiled_action := l_compiled_action || 'ZX_TDS_PROCESS_CEC_PVT.'||
507: action_rec.tax_condition_action_code ||'(';
508: l_end := ');';
509: end if;
510:

Line 531: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_action.END',

527:
528: IF (g_level_statement >= g_current_runtime_level ) THEN
529:
530: FND_LOG.STRING(g_level_statement,
531: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_action.END',
532: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_action (-)');
533: END IF;
534: return l_compiled_action;
535: end create_compiled_action;

Line 532: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_action (-)');

528: IF (g_level_statement >= g_current_runtime_level ) THEN
529:
530: FND_LOG.STRING(g_level_statement,
531: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_action.END',
532: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_action (-)');
533: END IF;
534: return l_compiled_action;
535: end create_compiled_action;
536:

Line 600: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location.BEGIN',

596: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
597:
598: IF (g_level_statement >= g_current_runtime_level ) THEN
599: FND_LOG.STRING(g_level_statement,
600: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location.BEGIN',
601: 'ZX_TDS_PROCESS_CEC_PVT.get_hr_location (+)');
602:
603: END IF;
604:

Line 601: 'ZX_TDS_PROCESS_CEC_PVT.get_hr_location (+)');

597:
598: IF (g_level_statement >= g_current_runtime_level ) THEN
599: FND_LOG.STRING(g_level_statement,
600: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location.BEGIN',
601: 'ZX_TDS_PROCESS_CEC_PVT.get_hr_location (+)');
602:
603: END IF;
604:
605: IF p_organization_id is not NULL then

Line 647: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location',

643: IF pg_classification IS NULL OR pg_classification <> p_classification THEN
644:
645: IF (g_level_statement >= g_current_runtime_level ) THEN
646: FND_LOG.STRING(g_level_statement,
647: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location',
648: 'Same organization but different classification');
649:
650: END IF;
651:

Line 662: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location',

658: ELSE --Same organization and same classificationas cached
659:
660: IF (g_level_statement >= g_current_runtime_level ) THEN
661: FND_LOG.STRING(g_level_statement,
662: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location',
663: 'Same organization and same classificationas cached: ');
664:
665: END IF;
666:

Line 674: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location',

670: END IF; --IF NVL(pr_org_loc_rec.location_id, -1) <> NVL(l_location_id,-2) THEN
671:
672: IF (g_level_statement >= g_current_runtime_level ) THEN
673: FND_LOG.STRING(g_level_statement,
674: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location',
675: 'l_column: '|| l_column);
676: END IF;
677:
678: --end bug fix 4417523

Line 707: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location',

703: l_column_value := pr_org_loc_rec.TELEPHONE_NUMBER_3;
704: else
705: IF (g_level_unexpected >= g_current_runtime_level ) THEN
706: FND_LOG.STRING(g_level_unexpected,
707: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location',
708: 'Invalid Column');
709: END IF;
710: end if;
711:

Line 715: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location.END',

711:
712: IF (g_level_statement >= g_current_runtime_level ) THEN
713:
714: FND_LOG.STRING(g_level_statement,
715: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location.END',
716: 'ZX_TDS_PROCESS_CEC_PVT.get_hr_location (-)');
717: END IF;
718:
719: return upper(l_column_value);

Line 716: 'ZX_TDS_PROCESS_CEC_PVT.get_hr_location (-)');

712: IF (g_level_statement >= g_current_runtime_level ) THEN
713:
714: FND_LOG.STRING(g_level_statement,
715: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location.END',
716: 'ZX_TDS_PROCESS_CEC_PVT.get_hr_location (-)');
717: END IF;
718:
719: return upper(l_column_value);
720:

Line 774: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location.BEGIN',

770: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
771:
772: IF (g_level_statement >= g_current_runtime_level ) THEN
773: FND_LOG.STRING(g_level_statement,
774: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location.BEGIN',
775: 'ZX_TDS_PROCESS_CEC_PVT.get_site_location (+)'||
776: 'p_site_use_id= ' || p_site_use_id ||
777: 'p_classification= ' || p_classification ||
778: 'pr_site_use_rec.site_used_id= '||pr_site_use_rec.site_use_id) ;

Line 775: 'ZX_TDS_PROCESS_CEC_PVT.get_site_location (+)'||

771:
772: IF (g_level_statement >= g_current_runtime_level ) THEN
773: FND_LOG.STRING(g_level_statement,
774: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location.BEGIN',
775: 'ZX_TDS_PROCESS_CEC_PVT.get_site_location (+)'||
776: 'p_site_use_id= ' || p_site_use_id ||
777: 'p_classification= ' || p_classification ||
778: 'pr_site_use_rec.site_used_id= '||pr_site_use_rec.site_use_id) ;
779: END IF;

Line 796: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location',

792:
793: IF (g_level_statement >= g_current_runtime_level ) THEN
794:
795: FND_LOG.STRING(g_level_statement,
796: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location',
797: 'pr_site_use_rec.cust_acct_site_id: '||pr_site_use_rec.cust_acct_site_id);
798: END IF;
799:
800: IF nvl(pr_site_loc_rec.cust_acct_site_id, -1) <> nvl(pr_site_use_rec.cust_acct_site_id,-2) then

Line 815: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location',

811: close c_site_loc_rec;
812:
813: IF (g_level_statement >= g_current_runtime_level ) THEN
814: FND_LOG.STRING(g_level_statement,
815: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location',
816: 'pr_site_loc_rec.COUNTRY'||pr_site_loc_rec.COUNTRY||' STATE '||pr_site_loc_rec.STATE||
817: ' PROVINCE '||pr_site_loc_rec.PROVINCE||
818: ' CITY '||pr_site_loc_rec.CITY||
819: ' COUNTY '||pr_site_loc_rec.COUNTY||

Line 842: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location',

838: l_location := pr_site_use_rec.TAX_CLASSIFICATION;
839: ELSE
840: IF (g_level_statement >= g_current_runtime_level ) THEN
841: FND_LOG.STRING(g_level_statement,
842: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location',
843: 'Invalid value for p_classification');
844: END IF;
845: END IF;
846:

Line 850: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location.END',

846:
847: IF (g_level_statement >= g_current_runtime_level ) THEN
848:
849: FND_LOG.STRING(g_level_statement,
850: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location.END',
851: 'ZX_TDS_PROCESS_CEC_PVT.get_site_location (-)'||
852: ' location: '||l_location);
853: END IF;
854: RETURN upper(l_location);

Line 851: 'ZX_TDS_PROCESS_CEC_PVT.get_site_location (-)'||

847: IF (g_level_statement >= g_current_runtime_level ) THEN
848:
849: FND_LOG.STRING(g_level_statement,
850: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location.END',
851: 'ZX_TDS_PROCESS_CEC_PVT.get_site_location (-)'||
852: ' location: '||l_location);
853: END IF;
854: RETURN upper(l_location);
855:

Line 860: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location',

856: EXCEPTION
857: when others then
858: IF (g_level_statement >= g_current_runtime_level ) THEN
859: FND_LOG.STRING(g_level_statement,
860: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location',
861: 'Exception in Get Site Location: ' || SQLCODE ||' ; '||SQLERRM);
862: END IF;
863: system_message('Exception');
864: END get_site_location;

Line 940: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition.BEGIN',

936: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
937:
938: IF (g_level_statement >= g_current_runtime_level ) THEN
939: FND_LOG.STRING(g_level_statement,
940: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition.BEGIN',
941: 'ZX_TDS_PROCESS_CEC_PVT.compare_condition (+)'||
942: ' p_id = '||to_char(p_id)||
943: ' P_calling_function: '|| P_calling_function||
944: ' p_classification: '|| p_classification ||

Line 941: 'ZX_TDS_PROCESS_CEC_PVT.compare_condition (+)'||

937:
938: IF (g_level_statement >= g_current_runtime_level ) THEN
939: FND_LOG.STRING(g_level_statement,
940: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition.BEGIN',
941: 'ZX_TDS_PROCESS_CEC_PVT.compare_condition (+)'||
942: ' p_id = '||to_char(p_id)||
943: ' P_calling_function: '|| P_calling_function||
944: ' p_classification: '|| p_classification ||
945: ' p_operator: '||p_operator||

Line 1025: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',

1021: l_value := upper(p_value);
1022:
1023: IF (g_level_statement >= g_current_runtime_level) THEN
1024: FND_LOG.STRING(g_level_statement,
1025: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',
1026: ' l_temp = '|| l_temp ||
1027: ' l_value = ' || l_value);
1028: END IF;
1029:

Line 1195: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',

1191: l_value := upper(p_value);
1192:
1193: IF (g_level_statement >= g_current_runtime_level) THEN
1194: FND_LOG.STRING(g_level_statement,
1195: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',
1196: ' l_temp = '|| l_temp ||
1197: ' l_value = ' || l_value);
1198: END IF;
1199:

Line 1203: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',

1199:
1200: IF upper(p_classification) = 'WAREHOUSE' then
1201: IF (g_level_statement >= g_current_runtime_level) THEN
1202: FND_LOG.STRING(g_level_statement,
1203: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',
1204: ' Calling Function is Ship From and p_classification is WAREHOUSE');
1205: END IF;
1206:
1207: open warehouse_csr(g_cec_ledger_id, g_cec_internal_organization_id);

Line 1250: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',

1246: end if;
1247:
1248: IF (g_level_statement >= g_current_runtime_level) THEN
1249: FND_LOG.STRING(g_level_statement,
1250: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',
1251: ' l_temp = '|| l_temp ||
1252: ' l_value = ' || l_value);
1253: END IF;
1254:

Line 1301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',

1297: end if;
1298:
1299: IF (g_level_statement >= g_current_runtime_level) THEN
1300: FND_LOG.STRING(g_level_statement,
1301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition',
1302: ' l_temp = '|| l_temp ||
1303: ' l_value = ' || l_value);
1304: END IF;
1305:

Line 1331: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition.END',

1327: END IF;
1328: IF (g_level_statement >= g_current_runtime_level ) THEN
1329:
1330: FND_LOG.STRING(g_level_statement,
1331: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition.END',
1332: 'ZX_TDS_PROCESS_CEC_PVT.compare_condition (-)');
1333: END IF;
1334: END compare_condition;
1335:

Line 1332: 'ZX_TDS_PROCESS_CEC_PVT.compare_condition (-)');

1328: IF (g_level_statement >= g_current_runtime_level ) THEN
1329:
1330: FND_LOG.STRING(g_level_statement,
1331: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition.END',
1332: 'ZX_TDS_PROCESS_CEC_PVT.compare_condition (-)');
1333: END IF;
1334: END compare_condition;
1335:
1336:

Line 1367: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.BEGIN',

1363: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1364:
1365: IF (g_level_statement >= g_current_runtime_level ) THEN
1366: FND_LOG.STRING(g_level_statement,
1367: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.BEGIN',
1368: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (+)');
1369:
1370: END IF;
1371: fnd_dflex.get_flexfield(

Line 1368: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (+)');

1364:
1365: IF (g_level_statement >= g_current_runtime_level ) THEN
1366: FND_LOG.STRING(g_level_statement,
1367: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.BEGIN',
1368: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (+)');
1369:
1370: END IF;
1371: fnd_dflex.get_flexfield(
1372: 'PER',

Line 1400: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',

1396:
1397: IF l_context is NULL then
1398: IF (g_level_statement >= g_current_runtime_level ) THEN
1399: FND_LOG.STRING(g_level_statement,
1400: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1401: 'No context which matches the style');
1402:
1403: FND_LOG.STRING(g_level_statement,
1404: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.END',

Line 1404: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.END',

1400: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1401: 'No context which matches the style');
1402:
1403: FND_LOG.STRING(g_level_statement,
1404: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.END',
1405: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (-)');
1406: END IF;
1407: return NULL;
1408: END IF;

Line 1405: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (-)');

1401: 'No context which matches the style');
1402:
1403: FND_LOG.STRING(g_level_statement,
1404: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.END',
1405: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (-)');
1406: END IF;
1407: return NULL;
1408: END IF;
1409: --commented out for bug 4417523 end*/

Line 1433: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',

1429: l_column := pr_segments.application_column_name(i);
1430: IF (g_level_statement >= g_current_runtime_level ) THEN
1431:
1432: FND_LOG.STRING(g_level_statement,
1433: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1434: ' Segment name= '||pr_segments.segment_name(i)||
1435: ' Column Name= '|| pr_segments.application_column_name(i)||
1436: ' Description= '||pr_segments.description(i));
1437: END IF;

Line 1445: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',

1441:
1442: IF l_column is NULL then
1443: IF (g_level_statement >= g_current_runtime_level ) THEN
1444: FND_LOG.STRING(g_level_statement,
1445: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1446: 'No column which matches the value of '||
1447: 'input parameter p_classification');
1448: FND_LOG.STRING(g_level_statement,
1449: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',

Line 1449: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',

1445: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1446: 'No column which matches the value of '||
1447: 'input parameter p_classification');
1448: FND_LOG.STRING(g_level_statement,
1449: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1450: 'Get Location Column (-)');
1451: END IF;
1452: END IF;
1453:

Line 1457: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.END',

1453:
1454: IF (g_level_statement >= g_current_runtime_level ) THEN
1455:
1456: FND_LOG.STRING(g_level_statement,
1457: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.END',
1458: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (-)');
1459: END IF;
1460: RETURN l_column;
1461:

Line 1458: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (-)');

1454: IF (g_level_statement >= g_current_runtime_level ) THEN
1455:
1456: FND_LOG.STRING(g_level_statement,
1457: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.END',
1458: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (-)');
1459: END IF;
1460: RETURN l_column;
1461:
1462: END get_location_column;

Line 1485: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.BEGIN',

1481:
1482: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1483: IF (g_level_statement >= g_current_runtime_level ) THEN
1484: FND_LOG.STRING(g_level_statement,
1485: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.BEGIN',
1486: 'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (+)');
1487: END IF;
1488:
1489: if (p_flag) then

Line 1486: 'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (+)');

1482: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1483: IF (g_level_statement >= g_current_runtime_level ) THEN
1484: FND_LOG.STRING(g_level_statement,
1485: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.BEGIN',
1486: 'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (+)');
1487: END IF;
1488:
1489: if (p_flag) then
1490: if (upper(p_classification) = 'COUNTRY' and

Line 1582: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.END',

1578: end if;
1579:
1580: IF (g_level_statement >= g_current_runtime_level ) THEN
1581: FND_LOG.STRING(g_level_statement,
1582: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.END',
1583: 'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (-)');
1584: END IF;
1585: end update_pr_stats_rec_tbl;
1586:

Line 1583: 'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (-)');

1579:
1580: IF (g_level_statement >= g_current_runtime_level ) THEN
1581: FND_LOG.STRING(g_level_statement,
1582: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.END',
1583: 'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (-)');
1584: END IF;
1585: end update_pr_stats_rec_tbl;
1586:
1587: /*===========================================================================+

Line 1606: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec.BEGIN',

1602:
1603: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1604: IF (g_level_statement >= g_current_runtime_level) THEN
1605: FND_LOG.STRING(g_level_statement,
1606: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec.BEGIN',
1607: ' ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec (+)');
1608:
1609: END IF;
1610:

Line 1607: ' ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec (+)');

1603: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1604: IF (g_level_statement >= g_current_runtime_level) THEN
1605: FND_LOG.STRING(g_level_statement,
1606: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec.BEGIN',
1607: ' ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec (+)');
1608:
1609: END IF;
1610:
1611: if (p_x = IDX_SHIP_FROM) then

Line 1632: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec.END',

1628:
1629: IF (g_level_statement >= g_current_runtime_level) THEN
1630:
1631: FND_LOG.STRING(g_level_statement,
1632: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec.END',
1633: ' ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec (-)');
1634: END IF;
1635: end dump_stats_rec;
1636:

Line 1633: ' ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec (-)');

1629: IF (g_level_statement >= g_current_runtime_level) THEN
1630:
1631: FND_LOG.STRING(g_level_statement,
1632: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec.END',
1633: ' ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec (-)');
1634: END IF;
1635: end dump_stats_rec;
1636:
1637: /*===========================================================================+

Line 1654: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl.BEGIN',

1650:
1651: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1652: IF (g_level_statement >= g_current_runtime_level) THEN
1653: FND_LOG.STRING(g_level_statement,
1654: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl.BEGIN',
1655: ' ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl (+)');
1656: END IF;
1657:
1658: for i in IDX_SHIP_FROM .. IDX_TAX_CODE LOOP

Line 1655: ' ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl (+)');

1651: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1652: IF (g_level_statement >= g_current_runtime_level) THEN
1653: FND_LOG.STRING(g_level_statement,
1654: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl.BEGIN',
1655: ' ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl (+)');
1656: END IF;
1657:
1658: for i in IDX_SHIP_FROM .. IDX_TAX_CODE LOOP
1659: dump_stats_rec(i);

Line 1664: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl.END',

1660: end LOOP;
1661:
1662: IF (g_level_statement >= g_current_runtime_level) THEN
1663: FND_LOG.STRING(g_level_statement,
1664: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl.END',
1665: ' ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl (-)');
1666: END IF;
1667: end dump_pr_stats_rec_tbl;
1668:

Line 1665: ' ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl (-)');

1661:
1662: IF (g_level_statement >= g_current_runtime_level) THEN
1663: FND_LOG.STRING(g_level_statement,
1664: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl.END',
1665: ' ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl (-)');
1666: END IF;
1667: end dump_pr_stats_rec_tbl;
1668:
1669: -------------------

Line 1706: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code.BEGIN',

1702: l_return_val := FALSE;
1703:
1704: IF (g_level_statement >= g_current_runtime_level) THEN
1705: FND_LOG.STRING(g_level_statement,
1706: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code.BEGIN',
1707: 'ZX_TDS_PROCESS_CEC_PVT.tax_code (+)');
1708: END IF;
1709:
1710: l_return_val := compare_condition ( g_cec_ship_to_party_site_id,

Line 1707: 'ZX_TDS_PROCESS_CEC_PVT.tax_code (+)');

1703:
1704: IF (g_level_statement >= g_current_runtime_level) THEN
1705: FND_LOG.STRING(g_level_statement,
1706: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code.BEGIN',
1707: 'ZX_TDS_PROCESS_CEC_PVT.tax_code (+)');
1708: END IF;
1709:
1710: l_return_val := compare_condition ( g_cec_ship_to_party_site_id,
1711: 'TAX_CODE',

Line 1718: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code',

1714: p_value);
1715: if l_return_val = TRUE then
1716: IF (g_level_statement >= g_current_runtime_level ) THEN
1717: FND_LOG.STRING(g_level_statement,
1718: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code',
1719: 'The condition Tax code '||p_classification||
1720: p_operator||p_value||' evaluates to TRUE');
1721: END IF;
1722: else

Line 1725: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code',

1721: END IF;
1722: else
1723: IF (g_level_statement >= g_current_runtime_level ) THEN
1724: FND_LOG.STRING(g_level_statement,
1725: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code',
1726: 'The condition Tax code '||p_classification||
1727: p_operator||p_value||' evaluates to FALSE');
1728: END IF;
1729: end if;

Line 1739: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code.END',

1735: dump_stats_rec(IDX_TAX_CODE); --for bug1833141
1736: end if;
1737: IF (g_level_statement >= g_current_runtime_level) THEN
1738: FND_LOG.STRING(g_level_statement,
1739: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code.END',
1740: 'ZX_TDS_PROCESS_CEC_PVT.tax_code (-)');
1741: END IF;
1742: return l_return_val;
1743: END tax_code;

Line 1740: 'ZX_TDS_PROCESS_CEC_PVT.tax_code (-)');

1736: end if;
1737: IF (g_level_statement >= g_current_runtime_level) THEN
1738: FND_LOG.STRING(g_level_statement,
1739: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code.END',
1740: 'ZX_TDS_PROCESS_CEC_PVT.tax_code (-)');
1741: END IF;
1742: return l_return_val;
1743: END tax_code;
1744:

Line 1760: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to.BEGIN',

1756: l_return_val := FALSE;
1757:
1758: IF (g_level_statement >= g_current_runtime_level ) THEN
1759: FND_LOG.STRING(g_level_statement,
1760: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to.BEGIN',
1761: 'ZX_TDS_PROCESS_CEC_PVT.Ship_To (+)');
1762: END IF;
1763:
1764: l_return_val := compare_condition ( g_cec_ship_to_site_use_id,

Line 1761: 'ZX_TDS_PROCESS_CEC_PVT.Ship_To (+)');

1757:
1758: IF (g_level_statement >= g_current_runtime_level ) THEN
1759: FND_LOG.STRING(g_level_statement,
1760: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to.BEGIN',
1761: 'ZX_TDS_PROCESS_CEC_PVT.Ship_To (+)');
1762: END IF;
1763:
1764: l_return_val := compare_condition ( g_cec_ship_to_site_use_id,
1765: 'SHIP_TO',

Line 1772: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to',

1768: p_value);
1769: if l_return_val = TRUE then
1770: IF (g_level_statement >= g_current_runtime_level ) THEN
1771: FND_LOG.STRING(g_level_statement,
1772: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to',
1773: 'The condition Ship to '||p_classification||
1774: p_operator||p_value||' evaluates to TRUE');
1775: END IF;
1776: else

Line 1779: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to',

1775: END IF;
1776: else
1777: IF (g_level_statement >= g_current_runtime_level ) THEN
1778: FND_LOG.STRING(g_level_statement,
1779: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to',
1780: 'The condition Ship to '||p_classification||
1781: p_operator||p_value||' evaluates to FALSE');
1782: END IF;
1783: end if;

Line 1793: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to.END',

1789: dump_stats_rec(IDX_SHIP_TO); --for bug1833141
1790: end if;
1791: IF (g_level_statement >= g_current_runtime_level ) THEN
1792: FND_LOG.STRING(g_level_statement,
1793: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to.END',
1794: 'ZX_TDS_PROCESS_CEC_PVT.Ship_To (-)');
1795: END IF;
1796: return l_return_val;
1797: END ship_to;

Line 1794: 'ZX_TDS_PROCESS_CEC_PVT.Ship_To (-)');

1790: end if;
1791: IF (g_level_statement >= g_current_runtime_level ) THEN
1792: FND_LOG.STRING(g_level_statement,
1793: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to.END',
1794: 'ZX_TDS_PROCESS_CEC_PVT.Ship_To (-)');
1795: END IF;
1796: return l_return_val;
1797: END ship_to;
1798:

Line 1819: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from.BEGIN',

1815: l_return_val := FALSE;
1816:
1817: IF (g_level_statement >= g_current_runtime_level ) THEN
1818: FND_LOG.STRING(g_level_statement,
1819: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from.BEGIN',
1820: 'ZX_TDS_PROCESS_CEC_PVT.Ship_From(+)');
1821: END IF;
1822:
1823: l_return_val := compare_condition ( g_cec_product_org_id,

Line 1820: 'ZX_TDS_PROCESS_CEC_PVT.Ship_From(+)');

1816:
1817: IF (g_level_statement >= g_current_runtime_level ) THEN
1818: FND_LOG.STRING(g_level_statement,
1819: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from.BEGIN',
1820: 'ZX_TDS_PROCESS_CEC_PVT.Ship_From(+)');
1821: END IF;
1822:
1823: l_return_val := compare_condition ( g_cec_product_org_id,
1824: 'SHIP_FROM',

Line 1831: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from',

1827: p_value);
1828: if l_return_val = TRUE then
1829: IF (g_level_statement >= g_current_runtime_level ) THEN
1830: FND_LOG.STRING(g_level_statement,
1831: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from',
1832: 'The condition Ship From '||p_classification||
1833: p_operator||p_value||' evaluates to TRUE');
1834: END IF;
1835: else

Line 1838: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from',

1834: END IF;
1835: else
1836: IF (g_level_statement >= g_current_runtime_level ) THEN
1837: FND_LOG.STRING(g_level_statement,
1838: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from',
1839: 'The condition Ship From '||p_classification||
1840: p_operator||p_value||' evaluates to FALSE');
1841: END IF;
1842: end if;

Line 1852: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from.END',

1848: dump_stats_rec(IDX_SHIP_FROM); --for bug1833141
1849: end if;
1850: IF (g_level_statement >= g_current_runtime_level ) THEN
1851: FND_LOG.STRING(g_level_statement,
1852: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from.END',
1853: 'ZX_TDS_PROCESS_CEC_PVT.Ship_From (-)');
1854: END IF;
1855: return l_return_val;
1856: END ship_from;

Line 1853: 'ZX_TDS_PROCESS_CEC_PVT.Ship_From (-)');

1849: end if;
1850: IF (g_level_statement >= g_current_runtime_level ) THEN
1851: FND_LOG.STRING(g_level_statement,
1852: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from.END',
1853: 'ZX_TDS_PROCESS_CEC_PVT.Ship_From (-)');
1854: END IF;
1855: return l_return_val;
1856: END ship_from;
1857:

Line 1879: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to.BEGIN',

1875: l_return_val := FALSE;
1876:
1877: IF (g_level_statement >= g_current_runtime_level ) THEN
1878: FND_LOG.STRING(g_level_statement,
1879: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to.BEGIN',
1880: 'ZX_TDS_PROCESS_CEC_PVT.bill_to (+)');
1881: END IF;
1882:
1883: l_return_val := compare_condition ( g_cec_bill_to_site_use_id,

Line 1880: 'ZX_TDS_PROCESS_CEC_PVT.bill_to (+)');

1876:
1877: IF (g_level_statement >= g_current_runtime_level ) THEN
1878: FND_LOG.STRING(g_level_statement,
1879: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to.BEGIN',
1880: 'ZX_TDS_PROCESS_CEC_PVT.bill_to (+)');
1881: END IF;
1882:
1883: l_return_val := compare_condition ( g_cec_bill_to_site_use_id,
1884: 'BILL_TO',

Line 1891: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to',

1887: p_value);
1888: if l_return_val = TRUE then
1889: IF (g_level_statement >= g_current_runtime_level ) THEN
1890: FND_LOG.STRING(g_level_statement,
1891: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to',
1892: 'The condition Bill to '||p_classification||
1893: p_operator||p_value||' evaluates to TRUE');
1894: END IF;
1895: else

Line 1898: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to',

1894: END IF;
1895: else
1896: IF (g_level_statement >= g_current_runtime_level ) THEN
1897: FND_LOG.STRING(g_level_statement,
1898: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to',
1899: 'The condition Bill to '||p_classification||
1900: p_operator||p_value||' evaluates to FALSE');
1901: END IF;
1902: end if;

Line 1912: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to.END',

1908: dump_stats_rec(IDX_BILL_TO);
1909: end if;
1910: IF (g_level_statement >= g_current_runtime_level ) THEN
1911: FND_LOG.STRING(g_level_statement,
1912: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to.END',
1913: 'ZX_TDS_PROCESS_CEC_PVT.bill_to (-)');
1914: END IF;
1915: return l_return_val;
1916: END bill_to;

Line 1913: 'ZX_TDS_PROCESS_CEC_PVT.bill_to (-)');

1909: end if;
1910: IF (g_level_statement >= g_current_runtime_level ) THEN
1911: FND_LOG.STRING(g_level_statement,
1912: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to.END',
1913: 'ZX_TDS_PROCESS_CEC_PVT.bill_to (-)');
1914: END IF;
1915: return l_return_val;
1916: END bill_to;
1917:

Line 1938: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.BEGIN',

1934: l_return_val := FALSE;
1935:
1936: IF (g_level_statement >= g_current_runtime_level ) THEN
1937: FND_LOG.STRING(g_level_statement,
1938: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.BEGIN',
1939: 'ZX_TDS_PROCESS_CEC_PVT.poo (+)');
1940:
1941: END IF;
1942:

Line 1939: 'ZX_TDS_PROCESS_CEC_PVT.poo (+)');

1935:
1936: IF (g_level_statement >= g_current_runtime_level ) THEN
1937: FND_LOG.STRING(g_level_statement,
1938: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.BEGIN',
1939: 'ZX_TDS_PROCESS_CEC_PVT.poo (+)');
1940:
1941: END IF;
1942:
1943: l_return_val := compare_condition ( g_cec_poo_location_id,

Line 1951: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',

1947: p_value);
1948: if l_return_val = TRUE then
1949: IF (g_level_statement >= g_current_runtime_level ) THEN
1950: FND_LOG.STRING(g_level_statement,
1951: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',
1952: 'The condition POO '||p_classification||
1953: p_operator||p_value||' evaluates to TRUE');
1954: END IF;
1955: else

Line 1958: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',

1954: END IF;
1955: else
1956: IF (g_level_statement >= g_current_runtime_level ) THEN
1957: FND_LOG.STRING(g_level_statement,
1958: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',
1959: 'The condition POO '||p_classification||
1960: p_operator||p_value||' evaluates to FALSE');
1961: END IF;
1962: end if;

Line 1972: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',

1968: dump_stats_rec(IDX_POO); --for bug1833141
1969: end if;
1970: IF (g_level_statement >= g_current_runtime_level ) THEN
1971: FND_LOG.STRING(g_level_statement,
1972: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',
1973: 'Point of Origin (-)');
1974: FND_LOG.STRING(g_level_statement,
1975: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.END',
1976: 'ZX_TDS_PROCESS_CEC_PVT.poo (-)');

Line 1975: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.END',

1971: FND_LOG.STRING(g_level_statement,
1972: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',
1973: 'Point of Origin (-)');
1974: FND_LOG.STRING(g_level_statement,
1975: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.END',
1976: 'ZX_TDS_PROCESS_CEC_PVT.poo (-)');
1977: END IF;
1978: return l_return_val;
1979: END poo;

Line 1976: 'ZX_TDS_PROCESS_CEC_PVT.poo (-)');

1972: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',
1973: 'Point of Origin (-)');
1974: FND_LOG.STRING(g_level_statement,
1975: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.END',
1976: 'ZX_TDS_PROCESS_CEC_PVT.poo (-)');
1977: END IF;
1978: return l_return_val;
1979: END poo;
1980:

Line 2001: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa.BEGIN',

1997: l_return_val := FALSE;
1998:
1999: IF (g_level_statement >= g_current_runtime_level ) THEN
2000: FND_LOG.STRING(g_level_statement,
2001: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa.BEGIN',
2002: 'ZX_TDS_PROCESS_CEC_PVT.poa (+)');
2003:
2004: END IF;
2005:

Line 2002: 'ZX_TDS_PROCESS_CEC_PVT.poa (+)');

1998:
1999: IF (g_level_statement >= g_current_runtime_level ) THEN
2000: FND_LOG.STRING(g_level_statement,
2001: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa.BEGIN',
2002: 'ZX_TDS_PROCESS_CEC_PVT.poa (+)');
2003:
2004: END IF;
2005:
2006: l_return_val := compare_condition ( g_cec_poa_location_id,

Line 2014: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa',

2010: p_value);
2011: if l_return_val = TRUE then
2012: IF (g_level_statement >= g_current_runtime_level ) THEN
2013: FND_LOG.STRING(g_level_statement,
2014: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa',
2015: 'The condition POA '||p_classification||
2016: p_operator||p_value||' evaluates to TRUE');
2017: END IF;
2018: else

Line 2021: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa',

2017: END IF;
2018: else
2019: IF (g_level_statement >= g_current_runtime_level ) THEN
2020: FND_LOG.STRING(g_level_statement,
2021: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa',
2022: 'The condition POA '||p_classification||
2023: p_operator||p_value||' evaluates to FALSE');
2024: END IF;
2025: end if;

Line 2036: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa.END',

2032: end if;
2033: IF (g_level_statement >= g_current_runtime_level ) THEN
2034:
2035: FND_LOG.STRING(g_level_statement,
2036: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa.END',
2037: 'ZX_TDS_PROCESS_CEC_PVT.poa (-)');
2038: END IF;
2039: return l_return_val;
2040: END poa;

Line 2037: 'ZX_TDS_PROCESS_CEC_PVT.poa (-)');

2033: IF (g_level_statement >= g_current_runtime_level ) THEN
2034:
2035: FND_LOG.STRING(g_level_statement,
2036: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa.END',
2037: 'ZX_TDS_PROCESS_CEC_PVT.poa (-)');
2038: END IF;
2039: return l_return_val;
2040: END poa;
2041:

Line 2062: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx.BEGIN',

2058: l_return_val := FALSE;
2059:
2060: IF (g_level_statement >= g_current_runtime_level ) THEN
2061: FND_LOG.STRING(g_level_statement,
2062: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx.BEGIN',
2063: 'ZX_TDS_PROCESS_CEC_PVT.trx (+)');
2064:
2065: END IF;
2066:

Line 2063: 'ZX_TDS_PROCESS_CEC_PVT.trx (+)');

2059:
2060: IF (g_level_statement >= g_current_runtime_level ) THEN
2061: FND_LOG.STRING(g_level_statement,
2062: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx.BEGIN',
2063: 'ZX_TDS_PROCESS_CEC_PVT.trx (+)');
2064:
2065: END IF;
2066:
2067: l_return_val := compare_condition (

Line 2076: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx',

2072: p_value);
2073: if l_return_val = TRUE then
2074: IF (g_level_statement >= g_current_runtime_level ) THEN
2075: FND_LOG.STRING(g_level_statement,
2076: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx',
2077: 'The Trx condition evaluates to TRUE');
2078: END IF;
2079: else
2080: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 2082: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx',

2078: END IF;
2079: else
2080: IF (g_level_statement >= g_current_runtime_level ) THEN
2081: FND_LOG.STRING(g_level_statement,
2082: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx',
2083: 'The Trx condition evaluates to FALSE');
2084: END IF;
2085: end if;
2086: -- Only when p_oprator is not NOT_FOUND, update pr_stats_rec_tbl.

Line 2096: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx.END',

2092: end if;
2093: IF (g_level_statement >= g_current_runtime_level ) THEN
2094:
2095: FND_LOG.STRING(g_level_statement,
2096: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx.END',
2097: 'ZX_TDS_PROCESS_CEC_PVT.trx (-)');
2098: END IF;
2099:
2100: return l_return_val;

Line 2097: 'ZX_TDS_PROCESS_CEC_PVT.trx (-)');

2093: IF (g_level_statement >= g_current_runtime_level ) THEN
2094:
2095: FND_LOG.STRING(g_level_statement,
2096: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx.END',
2097: 'ZX_TDS_PROCESS_CEC_PVT.trx (-)');
2098: END IF;
2099:
2100: return l_return_val;
2101: END trx;

Line 2121: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item.BEGIN',

2117: l_return_val := FALSE;
2118:
2119: IF (g_level_statement >= g_current_runtime_level ) THEN
2120: FND_LOG.STRING(g_level_statement,
2121: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item.BEGIN',
2122: 'ZX_TDS_PROCESS_CEC_PVT.item (+)');
2123: END IF;
2124:
2125:

Line 2122: 'ZX_TDS_PROCESS_CEC_PVT.item (+)');

2118:
2119: IF (g_level_statement >= g_current_runtime_level ) THEN
2120: FND_LOG.STRING(g_level_statement,
2121: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item.BEGIN',
2122: 'ZX_TDS_PROCESS_CEC_PVT.item (+)');
2123: END IF;
2124:
2125:
2126: l_return_val := compare_condition ( g_cec_trx_line_id,

Line 2134: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item',

2130: p_value);
2131: if l_return_val = TRUE then
2132: IF (g_level_statement >= g_current_runtime_level ) THEN
2133: FND_LOG.STRING(g_level_statement,
2134: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item',
2135: 'Item Condition Evaluates to TRUE');
2136: END IF;
2137: else
2138: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 2140: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item',

2136: END IF;
2137: else
2138: IF (g_level_statement >= g_current_runtime_level ) THEN
2139: FND_LOG.STRING(g_level_statement,
2140: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item',
2141: 'Item Condition Evaluates to FALSE');
2142: END IF;
2143: end if;
2144: --

Line 2158: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item.END',

2154: end if;
2155:
2156: IF (g_level_statement >= g_current_runtime_level ) THEN
2157: FND_LOG.STRING(g_level_statement,
2158: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item.END',
2159: 'ZX_TDS_PROCESS_CEC_PVT.item (-)');
2160: END IF;
2161: return l_return_val;
2162: END item;

Line 2159: 'ZX_TDS_PROCESS_CEC_PVT.item (-)');

2155:
2156: IF (g_level_statement >= g_current_runtime_level ) THEN
2157: FND_LOG.STRING(g_level_statement,
2158: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item.END',
2159: 'ZX_TDS_PROCESS_CEC_PVT.item (-)');
2160: END IF;
2161: return l_return_val;
2162: END item;
2163:

Line 2175: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.user_message.BEGIN',

2171: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2172:
2173: IF (g_level_statement >= g_current_runtime_level ) THEN
2174: FND_LOG.STRING(g_level_statement,
2175: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.user_message.BEGIN',
2176: 'ZX_TDS_PROCESS_CEC_PVT.user_message (+)');
2177: END IF;
2178: if (p_msg is not null) then
2179: pr_message_token := p_msg;

Line 2176: 'ZX_TDS_PROCESS_CEC_PVT.user_message (+)');

2172:
2173: IF (g_level_statement >= g_current_runtime_level ) THEN
2174: FND_LOG.STRING(g_level_statement,
2175: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.user_message.BEGIN',
2176: 'ZX_TDS_PROCESS_CEC_PVT.user_message (+)');
2177: END IF;
2178: if (p_msg is not null) then
2179: pr_message_token := p_msg;
2180: end if;

Line 2183: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.user_message.END',

2179: pr_message_token := p_msg;
2180: end if;
2181: IF (g_level_statement >= g_current_runtime_level ) THEN
2182: FND_LOG.STRING(g_level_statement,
2183: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.user_message.END',
2184: 'ZX_TDS_PROCESS_CEC_PVT.user_message (-)');
2185: END IF;
2186:
2187: END user_message;

Line 2184: 'ZX_TDS_PROCESS_CEC_PVT.user_message (-)');

2180: end if;
2181: IF (g_level_statement >= g_current_runtime_level ) THEN
2182: FND_LOG.STRING(g_level_statement,
2183: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.user_message.END',
2184: 'ZX_TDS_PROCESS_CEC_PVT.user_message (-)');
2185: END IF;
2186:
2187: END user_message;
2188:

Line 2201: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.system_message.BEGIN',

2197: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2198:
2199: IF (g_level_statement >= g_current_runtime_level ) THEN
2200: FND_LOG.STRING(g_level_statement,
2201: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.system_message.BEGIN',
2202: 'ZX_TDS_PROCESS_CEC_PVT.system_message (+)');
2203: END IF;
2204:
2205: if (p_msg is not null) then

Line 2202: 'ZX_TDS_PROCESS_CEC_PVT.system_message (+)');

2198:
2199: IF (g_level_statement >= g_current_runtime_level ) THEN
2200: FND_LOG.STRING(g_level_statement,
2201: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.system_message.BEGIN',
2202: 'ZX_TDS_PROCESS_CEC_PVT.system_message (+)');
2203: END IF;
2204:
2205: if (p_msg is not null) then
2206: pr_message_token := fnd_message.get_string('AR',p_msg);

Line 2214: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.system_message.END',

2210: end if;
2211:
2212: IF (g_level_statement >= g_current_runtime_level ) THEN
2213: FND_LOG.STRING(g_level_statement,
2214: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.system_message.END',
2215: 'ZX_TDS_PROCESS_CEC_PVT.system_message (-)');
2216: END IF;
2217:
2218: END system_message;

Line 2215: 'ZX_TDS_PROCESS_CEC_PVT.system_message (-)');

2211:
2212: IF (g_level_statement >= g_current_runtime_level ) THEN
2213: FND_LOG.STRING(g_level_statement,
2214: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.system_message.END',
2215: 'ZX_TDS_PROCESS_CEC_PVT.system_message (-)');
2216: END IF;
2217:
2218: END system_message;
2219:

Line 2227: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.apply_exception.BEGIN',

2223: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2224:
2225: IF (g_level_statement >= g_current_runtime_level ) THEN
2226: FND_LOG.STRING(g_level_statement,
2227: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.apply_exception.BEGIN',
2228: 'ZX_TDS_PROCESS_CEC_PVT.Apply_Exception (+)');
2229: END IF;
2230: -- set pr_tax_rate with p_exception.
2231: if (p_exception is not null) then

Line 2228: 'ZX_TDS_PROCESS_CEC_PVT.Apply_Exception (+)');

2224:
2225: IF (g_level_statement >= g_current_runtime_level ) THEN
2226: FND_LOG.STRING(g_level_statement,
2227: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.apply_exception.BEGIN',
2228: 'ZX_TDS_PROCESS_CEC_PVT.Apply_Exception (+)');
2229: END IF;
2230: -- set pr_tax_rate with p_exception.
2231: if (p_exception is not null) then
2232: pr_tax_rate := to_number(p_exception);

Line 2237: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.apply_exception.END',

2233: end if;
2234:
2235: IF (g_level_statement >= g_current_runtime_level ) THEN
2236: FND_LOG.STRING(g_level_statement,
2237: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.apply_exception.END',
2238: 'ZX_TDS_PROCESS_CEC_PVT.Apply_Exception (-)');
2239: END IF;
2240:
2241: END apply_exception;

Line 2238: 'ZX_TDS_PROCESS_CEC_PVT.Apply_Exception (-)');

2234:
2235: IF (g_level_statement >= g_current_runtime_level ) THEN
2236: FND_LOG.STRING(g_level_statement,
2237: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.apply_exception.END',
2238: 'ZX_TDS_PROCESS_CEC_PVT.Apply_Exception (-)');
2239: END IF;
2240:
2241: END apply_exception;
2242:

Line 2250: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_apply_exception.BEGIN',

2246: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2247:
2248: IF (g_level_statement >= g_current_runtime_level ) THEN
2249: FND_LOG.STRING(g_level_statement,
2250: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_apply_exception.BEGIN',
2251: 'ZX_TDS_PROCESS_CEC_PVT.Do_Not_Apply_Exception (+)');
2252: END IF;
2253: NULL;
2254: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 2251: 'ZX_TDS_PROCESS_CEC_PVT.Do_Not_Apply_Exception (+)');

2247:
2248: IF (g_level_statement >= g_current_runtime_level ) THEN
2249: FND_LOG.STRING(g_level_statement,
2250: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_apply_exception.BEGIN',
2251: 'ZX_TDS_PROCESS_CEC_PVT.Do_Not_Apply_Exception (+)');
2252: END IF;
2253: NULL;
2254: IF (g_level_statement >= g_current_runtime_level ) THEN
2255: FND_LOG.STRING(g_level_statement,

Line 2256: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_apply_exception.END',

2252: END IF;
2253: NULL;
2254: IF (g_level_statement >= g_current_runtime_level ) THEN
2255: FND_LOG.STRING(g_level_statement,
2256: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_apply_exception.END',
2257: 'ZX_TDS_PROCESS_CEC_PVT.Do_Not_Apply_Exception (-)');
2258: END IF;
2259:
2260: END do_not_apply_exception;

Line 2257: 'ZX_TDS_PROCESS_CEC_PVT.Do_Not_Apply_Exception (-)');

2253: NULL;
2254: IF (g_level_statement >= g_current_runtime_level ) THEN
2255: FND_LOG.STRING(g_level_statement,
2256: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_apply_exception.END',
2257: 'ZX_TDS_PROCESS_CEC_PVT.Do_Not_Apply_Exception (-)');
2258: END IF;
2259:
2260: END do_not_apply_exception;
2261:

Line 2269: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.BEGIN',

2265: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2266:
2267: IF (g_level_statement >= g_current_runtime_level ) THEN
2268: FND_LOG.STRING(g_level_statement,
2269: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.BEGIN',
2270: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (+)');
2271: FND_LOG.STRING(g_level_statement,
2272: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.END',
2273: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (-)');

Line 2270: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (+)');

2266:
2267: IF (g_level_statement >= g_current_runtime_level ) THEN
2268: FND_LOG.STRING(g_level_statement,
2269: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.BEGIN',
2270: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (+)');
2271: FND_LOG.STRING(g_level_statement,
2272: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.END',
2273: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (-)');
2274: END IF;

Line 2272: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.END',

2268: FND_LOG.STRING(g_level_statement,
2269: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.BEGIN',
2270: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (+)');
2271: FND_LOG.STRING(g_level_statement,
2272: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.END',
2273: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (-)');
2274: END IF;
2275:
2276: END use_tax_code;

Line 2273: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (-)');

2269: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.BEGIN',
2270: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (+)');
2271: FND_LOG.STRING(g_level_statement,
2272: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.END',
2273: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (-)');
2274: END IF;
2275:
2276: END use_tax_code;
2277:

Line 2285: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.BEGIN',

2281: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2282:
2283: IF (g_level_statement >= g_current_runtime_level ) THEN
2284: FND_LOG.STRING(g_level_statement,
2285: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.BEGIN',
2286: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (+)');
2287: FND_LOG.STRING(g_level_statement,
2288: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.END',
2289: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (-)');

Line 2286: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (+)');

2282:
2283: IF (g_level_statement >= g_current_runtime_level ) THEN
2284: FND_LOG.STRING(g_level_statement,
2285: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.BEGIN',
2286: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (+)');
2287: FND_LOG.STRING(g_level_statement,
2288: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.END',
2289: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (-)');
2290: END IF;

Line 2288: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.END',

2284: FND_LOG.STRING(g_level_statement,
2285: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.BEGIN',
2286: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (+)');
2287: FND_LOG.STRING(g_level_statement,
2288: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.END',
2289: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (-)');
2290: END IF;
2291:
2292: END use_this_tax_code;

Line 2289: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (-)');

2285: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.BEGIN',
2286: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (+)');
2287: FND_LOG.STRING(g_level_statement,
2288: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.END',
2289: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (-)');
2290: END IF;
2291:
2292: END use_this_tax_code;
2293:

Line 2301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.BEGIN',

2297: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2298:
2299: IF (g_level_statement >= g_current_runtime_level ) THEN
2300: FND_LOG.STRING(g_level_statement,
2301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.BEGIN',
2302: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (+)');
2303: FND_LOG.STRING(g_level_statement,
2304: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.END',
2305: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (-)');

Line 2302: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (+)');

2298:
2299: IF (g_level_statement >= g_current_runtime_level ) THEN
2300: FND_LOG.STRING(g_level_statement,
2301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.BEGIN',
2302: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (+)');
2303: FND_LOG.STRING(g_level_statement,
2304: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.END',
2305: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (-)');
2306: END IF;

Line 2304: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.END',

2300: FND_LOG.STRING(g_level_statement,
2301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.BEGIN',
2302: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (+)');
2303: FND_LOG.STRING(g_level_statement,
2304: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.END',
2305: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (-)');
2306: END IF;
2307:
2308: END default_tax_code;

Line 2305: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (-)');

2301: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.BEGIN',
2302: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (+)');
2303: FND_LOG.STRING(g_level_statement,
2304: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.END',
2305: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (-)');
2306: END IF;
2307:
2308: END default_tax_code;
2309:

Line 2317: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.BEGIN',

2313: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2314:
2315: IF (g_level_statement >= g_current_runtime_level ) THEN
2316: FND_LOG.STRING(g_level_statement,
2317: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.BEGIN',
2318: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (+)');
2319:
2320: FND_LOG.STRING(g_level_statement,
2321: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.END',

Line 2318: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (+)');

2314:
2315: IF (g_level_statement >= g_current_runtime_level ) THEN
2316: FND_LOG.STRING(g_level_statement,
2317: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.BEGIN',
2318: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (+)');
2319:
2320: FND_LOG.STRING(g_level_statement,
2321: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.END',
2322: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (-)');

Line 2321: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.END',

2317: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.BEGIN',
2318: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (+)');
2319:
2320: FND_LOG.STRING(g_level_statement,
2321: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.END',
2322: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (-)');
2323: END IF;
2324:
2325: END use_this_tax_group;

Line 2322: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (-)');

2318: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (+)');
2319:
2320: FND_LOG.STRING(g_level_statement,
2321: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.END',
2322: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (-)');
2323: END IF;
2324:
2325: END use_this_tax_group;
2326:

Line 2334: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code.BEGIN',

2330: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2331:
2332: IF (g_level_statement >= g_current_runtime_level ) THEN
2333: FND_LOG.STRING(g_level_statement,
2334: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code.BEGIN',
2335: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code (+)');
2336: END IF;
2337: pr_do_not_use_this_tax_flag := TRUE;
2338: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 2335: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code (+)');

2331:
2332: IF (g_level_statement >= g_current_runtime_level ) THEN
2333: FND_LOG.STRING(g_level_statement,
2334: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code.BEGIN',
2335: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code (+)');
2336: END IF;
2337: pr_do_not_use_this_tax_flag := TRUE;
2338: IF (g_level_statement >= g_current_runtime_level ) THEN
2339: FND_LOG.STRING(g_level_statement,

Line 2340: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code.END',

2336: END IF;
2337: pr_do_not_use_this_tax_flag := TRUE;
2338: IF (g_level_statement >= g_current_runtime_level ) THEN
2339: FND_LOG.STRING(g_level_statement,
2340: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code.END',
2341: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code (-)');
2342: END IF;
2343:
2344: END do_not_use_this_tax_code;

Line 2341: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code (-)');

2337: pr_do_not_use_this_tax_flag := TRUE;
2338: IF (g_level_statement >= g_current_runtime_level ) THEN
2339: FND_LOG.STRING(g_level_statement,
2340: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code.END',
2341: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code (-)');
2342: END IF;
2343:
2344: END do_not_use_this_tax_code;
2345:

Line 2353: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group.BEGIN',

2349: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2350:
2351: IF (g_level_statement >= g_current_runtime_level ) THEN
2352: FND_LOG.STRING(g_level_statement,
2353: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group.BEGIN',
2354: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group (+)');
2355:
2356: END IF;
2357: pr_do_not_use_this_group_flag := TRUE;

Line 2354: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group (+)');

2350:
2351: IF (g_level_statement >= g_current_runtime_level ) THEN
2352: FND_LOG.STRING(g_level_statement,
2353: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group.BEGIN',
2354: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group (+)');
2355:
2356: END IF;
2357: pr_do_not_use_this_group_flag := TRUE;
2358: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 2361: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group.END',

2357: pr_do_not_use_this_group_flag := TRUE;
2358: IF (g_level_statement >= g_current_runtime_level ) THEN
2359:
2360: FND_LOG.STRING(g_level_statement,
2361: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group.END',
2362: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group (-)');
2363: END IF;
2364:
2365: END do_not_use_this_tax_group;

Line 2362: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group (-)');

2358: IF (g_level_statement >= g_current_runtime_level ) THEN
2359:
2360: FND_LOG.STRING(g_level_statement,
2361: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group.END',
2362: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group (-)');
2363: END IF;
2364:
2365: END do_not_use_this_tax_group;
2366:

Line 2452: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec.BEGIN',

2448: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2449:
2450: IF (g_level_statement >= g_current_runtime_level ) THEN
2451: FND_LOG.STRING(g_level_statement,
2452: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec.BEGIN',
2453: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec(+)');
2454: END IF;
2455:
2456: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2453: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec(+)');

2449:
2450: IF (g_level_statement >= g_current_runtime_level ) THEN
2451: FND_LOG.STRING(g_level_statement,
2452: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec.BEGIN',
2453: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec(+)');
2454: END IF;
2455:
2456: p_return_status := FND_API.G_RET_STS_SUCCESS;
2457:

Line 2510: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec',

2506:
2507: If NVL(pr_do_not_use_this_group_flag, FALSE) then
2508: IF (g_level_statement >= g_current_runtime_level ) THEN
2509: FND_LOG.STRING(g_level_statement,
2510: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec',
2511: 'Constraint Evaluated to False - Do not use the Condition Group');
2512:
2513: END IF;
2514: p_cec_result := false;

Line 2565: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec.END',

2561: p_action_rec_tbl := pr_action_rec_tbl;
2562:
2563: IF (g_level_statement >= g_current_runtime_level ) THEN
2564: FND_LOG.STRING(g_level_statement,
2565: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec.END',
2566: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec(-)');
2567: END IF;
2568:
2569: exception

Line 2566: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec(-)');

2562:
2563: IF (g_level_statement >= g_current_runtime_level ) THEN
2564: FND_LOG.STRING(g_level_statement,
2565: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec.END',
2566: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec(-)');
2567: END IF;
2568:
2569: exception
2570: when no_data_found then

Line 2585: END ZX_TDS_PROCESS_CEC_PVT;

2581:
2582: BEGIN
2583: init_stats_rec_tbl;
2584:
2585: END ZX_TDS_PROCESS_CEC_PVT;