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 FND_LOG

Line 93: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

89: pr_stats_default_rec pr_stats_rec_type;
90:
91: g_current_runtime_level NUMBER;
92:
93: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
94: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
96:
97: -- Parameters required for evaluating Constraint, Condition Set and Exception Set.

Line 94: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

90:
91: g_current_runtime_level NUMBER;
92:
93: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
94: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
96:
97: -- Parameters required for evaluating Constraint, Condition Set and Exception Set.
98: g_cec_ship_to_party_site_id NUMBER;

Line 95: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

91: g_current_runtime_level NUMBER;
92:
93: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
94: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
95: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
96:
97: -- Parameters required for evaluating Constraint, Condition Set and Exception Set.
98: g_cec_ship_to_party_site_id NUMBER;
99: g_cec_bill_to_party_site_id NUMBER;

Line 186: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

182: l_and_condition VARCHAR2(2000);
183:
184: begin
185:
186: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
187:
188:
189: IF (g_level_statement >= g_current_runtime_level ) THEN
190: FND_LOG.STRING(g_level_statement,

Line 190: FND_LOG.STRING(g_level_statement,

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

Line 214: FND_LOG.STRING(g_level_statement,

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

Line 224: FND_LOG.STRING(g_level_statement,

220: THEN :temp := 1; else :temp := 0; END IF; END;' USING OUT l_temp ;
221:
222: IF (g_level_statement >= g_current_runtime_level ) THEN
223: IF l_temp = 1 THEN
224: FND_LOG.STRING(g_level_statement,
225: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is satisfied ');
226: ELSE
227: FND_LOG.STRING(g_level_statement,
228: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is NOT satisfied ');

Line 227: FND_LOG.STRING(g_level_statement,

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

Line 236: FND_LOG.STRING(g_level_statement,

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

Line 246: FND_LOG.STRING(g_level_statement,

242: 'THEN :temp := 1; ELSE :temp := 0;END IF; END;' USING IN OUT l_temp ;
243:
244: IF (g_level_statement >= g_current_runtime_level ) THEN
245: IF l_temp = 1 THEN
246: FND_LOG.STRING(g_level_statement,
247: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is satisfied ');
248: ELSE
249: FND_LOG.STRING(g_level_statement,
250: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_lines', 'Condition is NOT satisfied ');

Line 249: FND_LOG.STRING(g_level_statement,

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

Line 257: FND_LOG.STRING(g_level_unexpected,

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

Line 270: FND_LOG.STRING(g_level_statement,

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

Line 297: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

293: l_msg VARCHAR2(60);
294:
295: begin
296:
297: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
298: IF (g_level_statement >= g_current_runtime_level ) THEN
299: FND_LOG.STRING(g_level_statement,
300: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action.BEGIN',
301: 'ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action (+)');

Line 299: FND_LOG.STRING(g_level_statement,

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

Line 311: FND_LOG.STRING(g_level_statement,

307: if (p_compiled_action is not null) then
308: BEGIN
309:
310: IF (g_level_statement >= g_current_runtime_level ) THEN
311: FND_LOG.STRING(g_level_statement,
312: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec_action',
313: 'Compiled Action: ' || p_compiled_action);
314: END IF;
315:

Line 318: FND_LOG.STRING(g_level_statement,

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

Line 324: FND_LOG.STRING(g_level_statement,

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

Line 332: FND_LOG.STRING(g_level_statement,

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

Line 338: FND_LOG.STRING(g_level_statement,

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

Line 354: FND_LOG.STRING(g_level_statement,

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

Line 363: FND_LOG.STRING(g_level_statement,

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

Line 397: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

393: order by display_order;
394:
395: begin
396:
397: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
398: IF (g_level_statement >= g_current_runtime_level ) THEN
399: FND_LOG.STRING(g_level_statement,
400: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines.BEGIN',
401: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_lines (+)');

Line 399: FND_LOG.STRING(g_level_statement,

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

Line 452: FND_LOG.STRING(g_level_statement,

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

Line 491: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

487: l_counter NUMBER;
488:
489: begin
490:
491: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
492: IF (g_level_statement >= g_current_runtime_level ) THEN
493: FND_LOG.STRING(g_level_statement,
494: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.create_compiled_action.BEGIN',
495: 'ZX_TDS_PROCESS_CEC_PVT.create_compiled_action (+)');

Line 493: FND_LOG.STRING(g_level_statement,

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

Line 529: FND_LOG.STRING(g_level_statement,

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

Line 595: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

591: from hr_organization_units
592: where organization_id = c_organization_id;
593:
594: BEGIN
595: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
596:
597: IF (g_level_statement >= g_current_runtime_level ) THEN
598: FND_LOG.STRING(g_level_statement,
599: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location.BEGIN',

Line 598: FND_LOG.STRING(g_level_statement,

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

Line 645: FND_LOG.STRING(g_level_statement,

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

Line 660: FND_LOG.STRING(g_level_statement,

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

Line 672: FND_LOG.STRING(g_level_statement,

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

Line 705: FND_LOG.STRING(g_level_unexpected,

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

Line 713: FND_LOG.STRING(g_level_statement,

709: end if;
710:
711: IF (g_level_statement >= g_current_runtime_level ) THEN
712:
713: FND_LOG.STRING(g_level_statement,
714: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_hr_location.END',
715: 'ZX_TDS_PROCESS_CEC_PVT.get_hr_location (-)');
716: END IF;
717:

Line 769: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

765: ACCT_SITE.CUST_ACCT_SITE_ID = c_address_id;
766:
767: BEGIN
768:
769: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
770:
771: IF (g_level_statement >= g_current_runtime_level ) THEN
772: FND_LOG.STRING(g_level_statement,
773: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location.BEGIN',

Line 772: FND_LOG.STRING(g_level_statement,

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

Line 794: FND_LOG.STRING(g_level_statement,

790: END IF;
791:
792: IF (g_level_statement >= g_current_runtime_level ) THEN
793:
794: FND_LOG.STRING(g_level_statement,
795: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_site_location',
796: 'pr_site_use_rec.cust_acct_site_id: '||pr_site_use_rec.cust_acct_site_id);
797: END IF;
798:

Line 813: FND_LOG.STRING(g_level_statement,

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

Line 840: FND_LOG.STRING(g_level_statement,

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

Line 848: FND_LOG.STRING(g_level_statement,

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

Line 858: FND_LOG.STRING(g_level_statement,

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

Line 935: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

931: ZP.PARTY_TYPE_CODE = 'THIRD_PARTY';
932:
933: BEGIN
934:
935: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
936:
937: IF (g_level_statement >= g_current_runtime_level ) THEN
938: FND_LOG.STRING(g_level_statement,
939: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.compare_condition.BEGIN',

Line 938: FND_LOG.STRING(g_level_statement,

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

Line 1023: FND_LOG.STRING(g_level_statement,

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

Line 1050: FND_LOG.STRING(g_level_statement,'Calling Function: ',p_calling_function);

1046: return FALSE;
1047: END IF;
1048: ELSE
1049: IF (g_level_statement >= g_current_runtime_level ) THEN
1050: FND_LOG.STRING(g_level_statement,'Calling Function: ',p_calling_function);
1051: FND_LOG.STRING(g_level_statement,'g_cec_bill_to_party_id: ',nvl(g_cec_bill_to_party_id,0));
1052: FND_LOG.STRING(g_level_statement,'g_cec_ship_to_party_id: ',nvl(g_cec_ship_to_party_id,0));
1053: END IF;
1054:

Line 1051: FND_LOG.STRING(g_level_statement,'g_cec_bill_to_party_id: ',nvl(g_cec_bill_to_party_id,0));

1047: END IF;
1048: ELSE
1049: IF (g_level_statement >= g_current_runtime_level ) THEN
1050: FND_LOG.STRING(g_level_statement,'Calling Function: ',p_calling_function);
1051: FND_LOG.STRING(g_level_statement,'g_cec_bill_to_party_id: ',nvl(g_cec_bill_to_party_id,0));
1052: FND_LOG.STRING(g_level_statement,'g_cec_ship_to_party_id: ',nvl(g_cec_ship_to_party_id,0));
1053: END IF;
1054:
1055: BEGIN

Line 1052: FND_LOG.STRING(g_level_statement,'g_cec_ship_to_party_id: ',nvl(g_cec_ship_to_party_id,0));

1048: ELSE
1049: IF (g_level_statement >= g_current_runtime_level ) THEN
1050: FND_LOG.STRING(g_level_statement,'Calling Function: ',p_calling_function);
1051: FND_LOG.STRING(g_level_statement,'g_cec_bill_to_party_id: ',nvl(g_cec_bill_to_party_id,0));
1052: FND_LOG.STRING(g_level_statement,'g_cec_ship_to_party_id: ',nvl(g_cec_ship_to_party_id,0));
1053: END IF;
1054:
1055: BEGIN
1056: OPEN get_vat_reg_num_site(p_id);

Line 1087: FND_LOG.STRING(g_level_statement,'Value: ',nvl(l_reg_number,0));

1083: END IF;
1084: END IF;
1085:
1086: IF (g_level_statement >= g_current_runtime_level ) THEN
1087: FND_LOG.STRING(g_level_statement,'Value: ',nvl(l_reg_number,0));
1088: END IF;
1089:
1090: IF l_reg_number IS NULL THEN
1091: IF upper(p_calling_function) = 'BILL_TO' THEN

Line 1097: FND_LOG.STRING(g_level_statement,'Value: ',nvl(l_pty_id,0));

1093: ELSE
1094: l_pty_id := g_cec_SHIP_to_party_id;
1095: END IF;
1096: IF (g_level_statement >= g_current_runtime_level ) THEN
1097: FND_LOG.STRING(g_level_statement,'Value: ',nvl(l_pty_id,0));
1098: END IF;
1099: BEGIN
1100: OPEN get_vat_reg_num_cust(l_pty_id);
1101: FETCH get_vat_reg_num_cust INTO l_party_tax_profile_id,l_reg_number;

Line 1109: FND_LOG.STRING(g_level_statement,'Value: ',nvl(l_reg_number,0));

1105: CLOSE get_vat_reg_num_cust;
1106: END;
1107:
1108: IF (g_level_statement >= g_current_runtime_level ) THEN
1109: FND_LOG.STRING(g_level_statement,'Value: ',nvl(l_reg_number,0));
1110: END IF;
1111:
1112: IF l_reg_number IS NULL THEN
1113: IF l_party_tax_profile_id IS NOT NULL THEN

Line 1139: FND_LOG.STRING(g_level_statement,'Value: ',nvl(l_reg_number,0));

1135: END IF;
1136: END IF;
1137:
1138: IF (g_level_statement >= g_current_runtime_level ) THEN
1139: FND_LOG.STRING(g_level_statement,'Value: ',nvl(l_reg_number,0));
1140: END IF;
1141:
1142: IF p_operator = 'IS' THEN
1143: return l_reg_number IS NOT NULL;

Line 1193: FND_LOG.STRING(g_level_statement,

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

Line 1201: FND_LOG.STRING(g_level_statement,

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

Line 1248: FND_LOG.STRING(g_level_statement,

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

Line 1299: FND_LOG.STRING(g_level_statement,

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

Line 1329: FND_LOG.STRING(g_level_statement,

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

Line 1362: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1358: l_column VARCHAR2(150);
1359:
1360: BEGIN
1361:
1362: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1363:
1364: IF (g_level_statement >= g_current_runtime_level ) THEN
1365: FND_LOG.STRING(g_level_statement,
1366: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.BEGIN',

Line 1365: FND_LOG.STRING(g_level_statement,

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

Line 1393: FND_LOG.STRING(g_level_statement,

1389: END LOOP;
1390:
1391: IF l_context is NULL then
1392: IF (g_level_statement >= g_current_runtime_level ) THEN
1393: FND_LOG.STRING(g_level_statement,
1394: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1395: 'No context which matches the style');
1396:
1397: FND_LOG.STRING(g_level_statement,

Line 1397: FND_LOG.STRING(g_level_statement,

1393: FND_LOG.STRING(g_level_statement,
1394: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1395: 'No context which matches the style');
1396:
1397: FND_LOG.STRING(g_level_statement,
1398: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.END',
1399: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (-)');
1400: END IF;
1401: return NULL;

Line 1426: FND_LOG.STRING(g_level_statement,

1422:
1423: l_column := pr_segments.application_column_name(i);
1424: IF (g_level_statement >= g_current_runtime_level ) THEN
1425:
1426: FND_LOG.STRING(g_level_statement,
1427: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1428: ' Segment name= '||pr_segments.segment_name(i)||
1429: ' Column Name= '|| pr_segments.application_column_name(i)||
1430: ' Description= '||pr_segments.description(i));

Line 1438: FND_LOG.STRING(g_level_statement,

1434: END LOOP;
1435:
1436: IF l_column is NULL then
1437: IF (g_level_statement >= g_current_runtime_level ) THEN
1438: FND_LOG.STRING(g_level_statement,
1439: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1440: 'No column which matches the value of '||
1441: 'input parameter p_classification');
1442: FND_LOG.STRING(g_level_statement,

Line 1442: FND_LOG.STRING(g_level_statement,

1438: FND_LOG.STRING(g_level_statement,
1439: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1440: 'No column which matches the value of '||
1441: 'input parameter p_classification');
1442: FND_LOG.STRING(g_level_statement,
1443: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column',
1444: 'Get Location Column (-)');
1445: END IF;
1446: END IF;

Line 1450: FND_LOG.STRING(g_level_statement,

1446: END IF;
1447:
1448: IF (g_level_statement >= g_current_runtime_level ) THEN
1449:
1450: FND_LOG.STRING(g_level_statement,
1451: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.get_location_column.END',
1452: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (-)');
1453: END IF;
1454: RETURN l_column;

Line 1476: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1472: p_flag IN BOOLEAN) is
1473:
1474: begin
1475:
1476: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1477: IF (g_level_statement >= g_current_runtime_level ) THEN
1478: FND_LOG.STRING(g_level_statement,
1479: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.BEGIN',
1480: 'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (+)');

Line 1478: FND_LOG.STRING(g_level_statement,

1474: begin
1475:
1476: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1477: IF (g_level_statement >= g_current_runtime_level ) THEN
1478: FND_LOG.STRING(g_level_statement,
1479: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.BEGIN',
1480: 'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (+)');
1481: END IF;
1482:

Line 1575: FND_LOG.STRING(g_level_statement,

1571: end if;
1572: end if;
1573:
1574: IF (g_level_statement >= g_current_runtime_level ) THEN
1575: FND_LOG.STRING(g_level_statement,
1576: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.END',
1577: 'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (-)');
1578: END IF;
1579: end update_pr_stats_rec_tbl;

Line 1597: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1593: l_x VARCHAR2(20);
1594:
1595: begin
1596:
1597: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1598: IF (g_level_statement >= g_current_runtime_level) THEN
1599: FND_LOG.STRING(g_level_statement,
1600: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec.BEGIN',
1601: ' ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec (+)');

Line 1599: FND_LOG.STRING(g_level_statement,

1595: begin
1596:
1597: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1598: IF (g_level_statement >= g_current_runtime_level) THEN
1599: FND_LOG.STRING(g_level_statement,
1600: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec.BEGIN',
1601: ' ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec (+)');
1602:
1603: END IF;

Line 1625: FND_LOG.STRING(g_level_statement,

1621: end if;
1622:
1623: IF (g_level_statement >= g_current_runtime_level) THEN
1624:
1625: FND_LOG.STRING(g_level_statement,
1626: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec.END',
1627: ' ZX_TDS_PROCESS_CEC_PVT.dump_stats_rec (-)');
1628: END IF;
1629: end dump_stats_rec;

Line 1645: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1641: procedure dump_pr_stats_rec_tbl is
1642:
1643: begin
1644:
1645: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1646: IF (g_level_statement >= g_current_runtime_level) THEN
1647: FND_LOG.STRING(g_level_statement,
1648: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl.BEGIN',
1649: ' ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl (+)');

Line 1647: FND_LOG.STRING(g_level_statement,

1643: begin
1644:
1645: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1646: IF (g_level_statement >= g_current_runtime_level) THEN
1647: FND_LOG.STRING(g_level_statement,
1648: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl.BEGIN',
1649: ' ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl (+)');
1650: END IF;
1651:

Line 1657: FND_LOG.STRING(g_level_statement,

1653: dump_stats_rec(i);
1654: end LOOP;
1655:
1656: IF (g_level_statement >= g_current_runtime_level) THEN
1657: FND_LOG.STRING(g_level_statement,
1658: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl.END',
1659: ' ZX_TDS_PROCESS_CEC_PVT.dump_pr_stats_rec_tbl (-)');
1660: END IF;
1661: end dump_pr_stats_rec_tbl;

Line 1695: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1691: l_return_val BOOLEAN;
1692:
1693: BEGIN
1694:
1695: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1696: l_return_val := FALSE;
1697:
1698: IF (g_level_statement >= g_current_runtime_level) THEN
1699: FND_LOG.STRING(g_level_statement,

Line 1699: FND_LOG.STRING(g_level_statement,

1695: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1696: l_return_val := FALSE;
1697:
1698: IF (g_level_statement >= g_current_runtime_level) THEN
1699: FND_LOG.STRING(g_level_statement,
1700: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code.BEGIN',
1701: 'ZX_TDS_PROCESS_CEC_PVT.tax_code (+)');
1702: END IF;
1703:

Line 1711: FND_LOG.STRING(g_level_statement,

1707: p_operator,
1708: p_value);
1709: if l_return_val = TRUE then
1710: IF (g_level_statement >= g_current_runtime_level ) THEN
1711: FND_LOG.STRING(g_level_statement,
1712: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code',
1713: 'The condition Tax code '||p_classification||
1714: p_operator||p_value||' evaluates to TRUE');
1715: END IF;

Line 1718: FND_LOG.STRING(g_level_statement,

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

Line 1732: FND_LOG.STRING(g_level_statement,

1728: p_flag => l_return_val);
1729: dump_stats_rec(IDX_TAX_CODE); --for bug1833141
1730: end if;
1731: IF (g_level_statement >= g_current_runtime_level) THEN
1732: FND_LOG.STRING(g_level_statement,
1733: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.tax_code.END',
1734: 'ZX_TDS_PROCESS_CEC_PVT.tax_code (-)');
1735: END IF;
1736: return l_return_val;

Line 1749: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1745: l_return_val BOOLEAN;
1746:
1747: BEGIN
1748:
1749: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1750: l_return_val := FALSE;
1751:
1752: IF (g_level_statement >= g_current_runtime_level ) THEN
1753: FND_LOG.STRING(g_level_statement,

Line 1753: FND_LOG.STRING(g_level_statement,

1749: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1750: l_return_val := FALSE;
1751:
1752: IF (g_level_statement >= g_current_runtime_level ) THEN
1753: FND_LOG.STRING(g_level_statement,
1754: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to.BEGIN',
1755: 'ZX_TDS_PROCESS_CEC_PVT.Ship_To (+)');
1756: END IF;
1757:

Line 1765: FND_LOG.STRING(g_level_statement,

1761: p_operator,
1762: p_value);
1763: if l_return_val = TRUE then
1764: IF (g_level_statement >= g_current_runtime_level ) THEN
1765: FND_LOG.STRING(g_level_statement,
1766: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to',
1767: 'The condition Ship to '||p_classification||
1768: p_operator||p_value||' evaluates to TRUE');
1769: END IF;

Line 1772: FND_LOG.STRING(g_level_statement,

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

Line 1786: FND_LOG.STRING(g_level_statement,

1782: p_flag => l_return_val);
1783: dump_stats_rec(IDX_SHIP_TO); --for bug1833141
1784: end if;
1785: IF (g_level_statement >= g_current_runtime_level ) THEN
1786: FND_LOG.STRING(g_level_statement,
1787: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_to.END',
1788: 'ZX_TDS_PROCESS_CEC_PVT.Ship_To (-)');
1789: END IF;
1790: return l_return_val;

Line 1808: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1804: l_return_val BOOLEAN;
1805:
1806: BEGIN
1807:
1808: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1809: l_return_val := FALSE;
1810:
1811: IF (g_level_statement >= g_current_runtime_level ) THEN
1812: FND_LOG.STRING(g_level_statement,

Line 1812: FND_LOG.STRING(g_level_statement,

1808: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1809: l_return_val := FALSE;
1810:
1811: IF (g_level_statement >= g_current_runtime_level ) THEN
1812: FND_LOG.STRING(g_level_statement,
1813: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from.BEGIN',
1814: 'ZX_TDS_PROCESS_CEC_PVT.Ship_From(+)');
1815: END IF;
1816:

Line 1824: FND_LOG.STRING(g_level_statement,

1820: p_operator,
1821: p_value);
1822: if l_return_val = TRUE then
1823: IF (g_level_statement >= g_current_runtime_level ) THEN
1824: FND_LOG.STRING(g_level_statement,
1825: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from',
1826: 'The condition Ship From '||p_classification||
1827: p_operator||p_value||' evaluates to TRUE');
1828: END IF;

Line 1831: FND_LOG.STRING(g_level_statement,

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

Line 1845: FND_LOG.STRING(g_level_statement,

1841: p_flag => l_return_val);
1842: dump_stats_rec(IDX_SHIP_FROM); --for bug1833141
1843: end if;
1844: IF (g_level_statement >= g_current_runtime_level ) THEN
1845: FND_LOG.STRING(g_level_statement,
1846: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.ship_from.END',
1847: 'ZX_TDS_PROCESS_CEC_PVT.Ship_From (-)');
1848: END IF;
1849: return l_return_val;

Line 1868: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1864: l_return_val BOOLEAN;
1865:
1866: BEGIN
1867:
1868: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1869: l_return_val := FALSE;
1870:
1871: IF (g_level_statement >= g_current_runtime_level ) THEN
1872: FND_LOG.STRING(g_level_statement,

Line 1872: FND_LOG.STRING(g_level_statement,

1868: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1869: l_return_val := FALSE;
1870:
1871: IF (g_level_statement >= g_current_runtime_level ) THEN
1872: FND_LOG.STRING(g_level_statement,
1873: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to.BEGIN',
1874: 'ZX_TDS_PROCESS_CEC_PVT.bill_to (+)');
1875: END IF;
1876:

Line 1884: FND_LOG.STRING(g_level_statement,

1880: p_operator,
1881: p_value);
1882: if l_return_val = TRUE then
1883: IF (g_level_statement >= g_current_runtime_level ) THEN
1884: FND_LOG.STRING(g_level_statement,
1885: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to',
1886: 'The condition Bill to '||p_classification||
1887: p_operator||p_value||' evaluates to TRUE');
1888: END IF;

Line 1891: FND_LOG.STRING(g_level_statement,

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

Line 1905: FND_LOG.STRING(g_level_statement,

1901: p_flag => l_return_val);
1902: dump_stats_rec(IDX_BILL_TO);
1903: end if;
1904: IF (g_level_statement >= g_current_runtime_level ) THEN
1905: FND_LOG.STRING(g_level_statement,
1906: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.bill_to.END',
1907: 'ZX_TDS_PROCESS_CEC_PVT.bill_to (-)');
1908: END IF;
1909: return l_return_val;

Line 1927: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1923: l_return_val BOOLEAN;
1924:
1925: BEGIN
1926:
1927: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1928: l_return_val := FALSE;
1929:
1930: IF (g_level_statement >= g_current_runtime_level ) THEN
1931: FND_LOG.STRING(g_level_statement,

Line 1931: FND_LOG.STRING(g_level_statement,

1927: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1928: l_return_val := FALSE;
1929:
1930: IF (g_level_statement >= g_current_runtime_level ) THEN
1931: FND_LOG.STRING(g_level_statement,
1932: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.BEGIN',
1933: 'ZX_TDS_PROCESS_CEC_PVT.poo (+)');
1934:
1935: END IF;

Line 1944: FND_LOG.STRING(g_level_statement,

1940: p_operator,
1941: p_value);
1942: if l_return_val = TRUE then
1943: IF (g_level_statement >= g_current_runtime_level ) THEN
1944: FND_LOG.STRING(g_level_statement,
1945: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',
1946: 'The condition POO '||p_classification||
1947: p_operator||p_value||' evaluates to TRUE');
1948: END IF;

Line 1951: FND_LOG.STRING(g_level_statement,

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

Line 1965: FND_LOG.STRING(g_level_statement,

1961: p_flag => l_return_val);
1962: dump_stats_rec(IDX_POO); --for bug1833141
1963: end if;
1964: IF (g_level_statement >= g_current_runtime_level ) THEN
1965: FND_LOG.STRING(g_level_statement,
1966: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',
1967: 'Point of Origin (-)');
1968: FND_LOG.STRING(g_level_statement,
1969: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.END',

Line 1968: FND_LOG.STRING(g_level_statement,

1964: IF (g_level_statement >= g_current_runtime_level ) THEN
1965: FND_LOG.STRING(g_level_statement,
1966: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo',
1967: 'Point of Origin (-)');
1968: FND_LOG.STRING(g_level_statement,
1969: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poo.END',
1970: 'ZX_TDS_PROCESS_CEC_PVT.poo (-)');
1971: END IF;
1972: return l_return_val;

Line 1990: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1986: l_return_val BOOLEAN;
1987:
1988: BEGIN
1989:
1990: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1991: l_return_val := FALSE;
1992:
1993: IF (g_level_statement >= g_current_runtime_level ) THEN
1994: FND_LOG.STRING(g_level_statement,

Line 1994: FND_LOG.STRING(g_level_statement,

1990: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1991: l_return_val := FALSE;
1992:
1993: IF (g_level_statement >= g_current_runtime_level ) THEN
1994: FND_LOG.STRING(g_level_statement,
1995: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa.BEGIN',
1996: 'ZX_TDS_PROCESS_CEC_PVT.poa (+)');
1997:
1998: END IF;

Line 2007: FND_LOG.STRING(g_level_statement,

2003: p_operator,
2004: p_value);
2005: if l_return_val = TRUE then
2006: IF (g_level_statement >= g_current_runtime_level ) THEN
2007: FND_LOG.STRING(g_level_statement,
2008: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa',
2009: 'The condition POA '||p_classification||
2010: p_operator||p_value||' evaluates to TRUE');
2011: END IF;

Line 2014: FND_LOG.STRING(g_level_statement,

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

Line 2029: FND_LOG.STRING(g_level_statement,

2025: dump_stats_rec(IDX_POA);
2026: end if;
2027: IF (g_level_statement >= g_current_runtime_level ) THEN
2028:
2029: FND_LOG.STRING(g_level_statement,
2030: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.poa.END',
2031: 'ZX_TDS_PROCESS_CEC_PVT.poa (-)');
2032: END IF;
2033: return l_return_val;

Line 2051: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2047: l_return_val BOOLEAN;
2048:
2049: BEGIN
2050:
2051: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2052: l_return_val := FALSE;
2053:
2054: IF (g_level_statement >= g_current_runtime_level ) THEN
2055: FND_LOG.STRING(g_level_statement,

Line 2055: FND_LOG.STRING(g_level_statement,

2051: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2052: l_return_val := FALSE;
2053:
2054: IF (g_level_statement >= g_current_runtime_level ) THEN
2055: FND_LOG.STRING(g_level_statement,
2056: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx.BEGIN',
2057: 'ZX_TDS_PROCESS_CEC_PVT.trx (+)');
2058:
2059: END IF;

Line 2069: FND_LOG.STRING(g_level_statement,

2065: p_operator,
2066: p_value);
2067: if l_return_val = TRUE then
2068: IF (g_level_statement >= g_current_runtime_level ) THEN
2069: FND_LOG.STRING(g_level_statement,
2070: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx',
2071: 'The Trx condition evaluates to TRUE');
2072: END IF;
2073: else

Line 2075: FND_LOG.STRING(g_level_statement,

2071: 'The Trx condition evaluates to TRUE');
2072: END IF;
2073: else
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 FALSE');
2078: END IF;
2079: end if;

Line 2089: FND_LOG.STRING(g_level_statement,

2085: dump_stats_rec(IDX_TRX); --for bug1833141
2086: end if;
2087: IF (g_level_statement >= g_current_runtime_level ) THEN
2088:
2089: FND_LOG.STRING(g_level_statement,
2090: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.trx.END',
2091: 'ZX_TDS_PROCESS_CEC_PVT.trx (-)');
2092: END IF;
2093:

Line 2110: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2106: l_return_val BOOLEAN ;
2107:
2108: BEGIN
2109:
2110: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2111: l_return_val := FALSE;
2112:
2113: IF (g_level_statement >= g_current_runtime_level ) THEN
2114: FND_LOG.STRING(g_level_statement,

Line 2114: FND_LOG.STRING(g_level_statement,

2110: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2111: l_return_val := FALSE;
2112:
2113: IF (g_level_statement >= g_current_runtime_level ) THEN
2114: FND_LOG.STRING(g_level_statement,
2115: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item.BEGIN',
2116: 'ZX_TDS_PROCESS_CEC_PVT.item (+)');
2117: END IF;
2118:

Line 2127: FND_LOG.STRING(g_level_statement,

2123: p_operator,
2124: p_value);
2125: if l_return_val = TRUE then
2126: IF (g_level_statement >= g_current_runtime_level ) THEN
2127: FND_LOG.STRING(g_level_statement,
2128: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item',
2129: 'Item Condition Evaluates to TRUE');
2130: END IF;
2131: else

Line 2133: FND_LOG.STRING(g_level_statement,

2129: 'Item Condition Evaluates to TRUE');
2130: END IF;
2131: else
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 FALSE');
2136: END IF;
2137: end if;

Line 2151: FND_LOG.STRING(g_level_statement,

2147: dump_stats_rec(IDX_ITEM); --for bug1833141
2148: end if;
2149:
2150: IF (g_level_statement >= g_current_runtime_level ) THEN
2151: FND_LOG.STRING(g_level_statement,
2152: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.item.END',
2153: 'ZX_TDS_PROCESS_CEC_PVT.item (-)');
2154: END IF;
2155: return l_return_val;

Line 2165: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2161:
2162: PROCEDURE user_message (p_msg IN VARCHAR2 default NULL) is
2163: BEGIN
2164:
2165: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2166:
2167: IF (g_level_statement >= g_current_runtime_level ) THEN
2168: FND_LOG.STRING(g_level_statement,
2169: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.user_message.BEGIN',

Line 2168: FND_LOG.STRING(g_level_statement,

2164:
2165: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2166:
2167: IF (g_level_statement >= g_current_runtime_level ) THEN
2168: FND_LOG.STRING(g_level_statement,
2169: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.user_message.BEGIN',
2170: 'ZX_TDS_PROCESS_CEC_PVT.user_message (+)');
2171: END IF;
2172: if (p_msg is not null) then

Line 2176: FND_LOG.STRING(g_level_statement,

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

Line 2191: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2187: PROCEDURE system_message (p_msg IN VARCHAR2 default NULL) is
2188:
2189: BEGIN
2190:
2191: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2192:
2193: IF (g_level_statement >= g_current_runtime_level ) THEN
2194: FND_LOG.STRING(g_level_statement,
2195: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.system_message.BEGIN',

Line 2194: FND_LOG.STRING(g_level_statement,

2190:
2191: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2192:
2193: IF (g_level_statement >= g_current_runtime_level ) THEN
2194: FND_LOG.STRING(g_level_statement,
2195: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.system_message.BEGIN',
2196: 'ZX_TDS_PROCESS_CEC_PVT.system_message (+)');
2197: END IF;
2198:

Line 2207: FND_LOG.STRING(g_level_statement,

2203: end if;
2204: end if;
2205:
2206: IF (g_level_statement >= g_current_runtime_level ) THEN
2207: FND_LOG.STRING(g_level_statement,
2208: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.system_message.END',
2209: 'ZX_TDS_PROCESS_CEC_PVT.system_message (-)');
2210: END IF;
2211:

Line 2217: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2213:
2214: PROCEDURE apply_exception (p_exception IN VARCHAR2 default NULL) is
2215: BEGIN
2216:
2217: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2218:
2219: IF (g_level_statement >= g_current_runtime_level ) THEN
2220: FND_LOG.STRING(g_level_statement,
2221: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.apply_exception.BEGIN',

Line 2220: FND_LOG.STRING(g_level_statement,

2216:
2217: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2218:
2219: IF (g_level_statement >= g_current_runtime_level ) THEN
2220: FND_LOG.STRING(g_level_statement,
2221: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.apply_exception.BEGIN',
2222: 'ZX_TDS_PROCESS_CEC_PVT.Apply_Exception (+)');
2223: END IF;
2224: -- set pr_tax_rate with p_exception.

Line 2230: FND_LOG.STRING(g_level_statement,

2226: pr_tax_rate := to_number(p_exception);
2227: end if;
2228:
2229: IF (g_level_statement >= g_current_runtime_level ) THEN
2230: FND_LOG.STRING(g_level_statement,
2231: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.apply_exception.END',
2232: 'ZX_TDS_PROCESS_CEC_PVT.Apply_Exception (-)');
2233: END IF;
2234:

Line 2240: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2236:
2237: PROCEDURE do_not_apply_exception (p_exception IN VARCHAR2 default NULL) is
2238: BEGIN
2239:
2240: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2241:
2242: IF (g_level_statement >= g_current_runtime_level ) THEN
2243: FND_LOG.STRING(g_level_statement,
2244: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_apply_exception.BEGIN',

Line 2243: FND_LOG.STRING(g_level_statement,

2239:
2240: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2241:
2242: IF (g_level_statement >= g_current_runtime_level ) THEN
2243: FND_LOG.STRING(g_level_statement,
2244: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_apply_exception.BEGIN',
2245: 'ZX_TDS_PROCESS_CEC_PVT.Do_Not_Apply_Exception (+)');
2246: END IF;
2247: NULL;

Line 2249: FND_LOG.STRING(g_level_statement,

2245: 'ZX_TDS_PROCESS_CEC_PVT.Do_Not_Apply_Exception (+)');
2246: END IF;
2247: NULL;
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.END',
2251: 'ZX_TDS_PROCESS_CEC_PVT.Do_Not_Apply_Exception (-)');
2252: END IF;
2253:

Line 2259: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2255:
2256: PROCEDURE use_tax_code (p_tax_code IN VARCHAR2 default NULL) is
2257: BEGIN
2258:
2259: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2260:
2261: IF (g_level_statement >= g_current_runtime_level ) THEN
2262: FND_LOG.STRING(g_level_statement,
2263: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.BEGIN',

Line 2262: FND_LOG.STRING(g_level_statement,

2258:
2259: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2260:
2261: IF (g_level_statement >= g_current_runtime_level ) THEN
2262: FND_LOG.STRING(g_level_statement,
2263: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.BEGIN',
2264: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (+)');
2265: FND_LOG.STRING(g_level_statement,
2266: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.END',

Line 2265: FND_LOG.STRING(g_level_statement,

2261: IF (g_level_statement >= g_current_runtime_level ) THEN
2262: FND_LOG.STRING(g_level_statement,
2263: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.BEGIN',
2264: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (+)');
2265: FND_LOG.STRING(g_level_statement,
2266: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_tax_code.END',
2267: 'ZX_TDS_PROCESS_CEC_PVT.use_tax_code (-)');
2268: END IF;
2269:

Line 2275: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2271:
2272: PROCEDURE use_this_tax_code (p_tax_code IN VARCHAR2 default NULL) is
2273: BEGIN
2274:
2275: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2276:
2277: IF (g_level_statement >= g_current_runtime_level ) THEN
2278: FND_LOG.STRING(g_level_statement,
2279: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.BEGIN',

Line 2278: FND_LOG.STRING(g_level_statement,

2274:
2275: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2276:
2277: IF (g_level_statement >= g_current_runtime_level ) THEN
2278: FND_LOG.STRING(g_level_statement,
2279: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.BEGIN',
2280: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (+)');
2281: FND_LOG.STRING(g_level_statement,
2282: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.END',

Line 2281: FND_LOG.STRING(g_level_statement,

2277: IF (g_level_statement >= g_current_runtime_level ) THEN
2278: FND_LOG.STRING(g_level_statement,
2279: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.BEGIN',
2280: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (+)');
2281: FND_LOG.STRING(g_level_statement,
2282: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code.END',
2283: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_code (-)');
2284: END IF;
2285:

Line 2291: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2287:
2288: PROCEDURE default_tax_code (p_tax_code IN VARCHAR2 default NULL) is
2289: BEGIN
2290:
2291: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2292:
2293: IF (g_level_statement >= g_current_runtime_level ) THEN
2294: FND_LOG.STRING(g_level_statement,
2295: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.BEGIN',

Line 2294: FND_LOG.STRING(g_level_statement,

2290:
2291: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2292:
2293: IF (g_level_statement >= g_current_runtime_level ) THEN
2294: FND_LOG.STRING(g_level_statement,
2295: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.BEGIN',
2296: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (+)');
2297: FND_LOG.STRING(g_level_statement,
2298: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.END',

Line 2297: FND_LOG.STRING(g_level_statement,

2293: IF (g_level_statement >= g_current_runtime_level ) THEN
2294: FND_LOG.STRING(g_level_statement,
2295: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.BEGIN',
2296: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (+)');
2297: FND_LOG.STRING(g_level_statement,
2298: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.default_tax_code.END',
2299: 'ZX_TDS_PROCESS_CEC_PVT.default_tax_code (-)');
2300: END IF;
2301:

Line 2307: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2303:
2304: PROCEDURE use_this_tax_group (p_tax_group_code IN VARCHAR2 default NULL) is
2305: BEGIN
2306:
2307: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2308:
2309: IF (g_level_statement >= g_current_runtime_level ) THEN
2310: FND_LOG.STRING(g_level_statement,
2311: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.BEGIN',

Line 2310: FND_LOG.STRING(g_level_statement,

2306:
2307: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2308:
2309: IF (g_level_statement >= g_current_runtime_level ) THEN
2310: FND_LOG.STRING(g_level_statement,
2311: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.BEGIN',
2312: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (+)');
2313:
2314: FND_LOG.STRING(g_level_statement,

Line 2314: FND_LOG.STRING(g_level_statement,

2310: FND_LOG.STRING(g_level_statement,
2311: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.BEGIN',
2312: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (+)');
2313:
2314: FND_LOG.STRING(g_level_statement,
2315: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group.END',
2316: 'ZX_TDS_PROCESS_CEC_PVT.use_this_tax_group (-)');
2317: END IF;
2318:

Line 2324: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2320:
2321: PROCEDURE do_not_use_this_tax_code(p_param IN VARCHAR2 DEFAULT NULL) is
2322: BEGIN
2323:
2324: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2325:
2326: IF (g_level_statement >= g_current_runtime_level ) THEN
2327: FND_LOG.STRING(g_level_statement,
2328: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code.BEGIN',

Line 2327: FND_LOG.STRING(g_level_statement,

2323:
2324: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2325:
2326: IF (g_level_statement >= g_current_runtime_level ) THEN
2327: FND_LOG.STRING(g_level_statement,
2328: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code.BEGIN',
2329: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code (+)');
2330: END IF;
2331: pr_do_not_use_this_tax_flag := TRUE;

Line 2333: FND_LOG.STRING(g_level_statement,

2329: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code (+)');
2330: END IF;
2331: pr_do_not_use_this_tax_flag := TRUE;
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.END',
2335: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_code (-)');
2336: END IF;
2337:

Line 2343: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2339:
2340: PROCEDURE do_not_use_this_tax_group(p_param IN VARCHAR2 DEFAULT NULL) is
2341: BEGIN
2342:
2343: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2344:
2345: IF (g_level_statement >= g_current_runtime_level ) THEN
2346: FND_LOG.STRING(g_level_statement,
2347: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group.BEGIN',

Line 2346: FND_LOG.STRING(g_level_statement,

2342:
2343: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2344:
2345: IF (g_level_statement >= g_current_runtime_level ) THEN
2346: FND_LOG.STRING(g_level_statement,
2347: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group.BEGIN',
2348: 'ZX_TDS_PROCESS_CEC_PVT.do_not_use_this_tax_group (+)');
2349:
2350: END IF;

Line 2354: FND_LOG.STRING(g_level_statement,

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

Line 2442: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2438:
2439:
2440: BEGIN
2441:
2442: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2443:
2444: IF (g_level_statement >= g_current_runtime_level ) THEN
2445: FND_LOG.STRING(g_level_statement,
2446: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec.BEGIN',

Line 2445: FND_LOG.STRING(g_level_statement,

2441:
2442: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2443:
2444: IF (g_level_statement >= g_current_runtime_level ) THEN
2445: FND_LOG.STRING(g_level_statement,
2446: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec.BEGIN',
2447: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec(+)');
2448: END IF;
2449:

Line 2503: FND_LOG.STRING(g_level_statement,

2499:
2500:
2501: If NVL(pr_do_not_use_this_group_flag, FALSE) then
2502: IF (g_level_statement >= g_current_runtime_level ) THEN
2503: FND_LOG.STRING(g_level_statement,
2504: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec',
2505: 'Constraint Evaluated to False - Do not use the Condition Group');
2506:
2507: END IF;

Line 2558: FND_LOG.STRING(g_level_statement,

2554:
2555: p_action_rec_tbl := pr_action_rec_tbl;
2556:
2557: IF (g_level_statement >= g_current_runtime_level ) THEN
2558: FND_LOG.STRING(g_level_statement,
2559: 'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.evaluate_cec.END',
2560: 'ZX_TDS_PROCESS_CEC_PVT: evaluate_cec(-)');
2561: END IF;
2562: