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 94: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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

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

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

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

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

Line 187: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 191: FND_LOG.STRING(g_level_statement,

187: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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;

Line 215: FND_LOG.STRING(g_level_statement,

211:
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:

Line 225: FND_LOG.STRING(g_level_statement,

221: THEN :temp := 1; else :temp := 0; END IF; END;' USING OUT l_temp ;
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 ');

Line 228: FND_LOG.STRING(g_level_statement,

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;
231: END IF;
232: end comment out for bug 4417523 */

Line 237: FND_LOG.STRING(g_level_statement,

233: --
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:

Line 247: FND_LOG.STRING(g_level_statement,

243: 'THEN :temp := 1; ELSE :temp := 0;END IF; END;' USING IN OUT l_temp ;
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 ');

Line 250: FND_LOG.STRING(g_level_statement,

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;
253: END IF;
254:

Line 258: FND_LOG.STRING(g_level_unexpected,

254:
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;

Line 271: FND_LOG.STRING(g_level_statement,

267: end if;
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:

Line 298: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

294: l_msg VARCHAR2(60);
295:
296: 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 (+)');

Line 300: FND_LOG.STRING(g_level_statement,

296: 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:

Line 312: FND_LOG.STRING(g_level_statement,

308: if (p_compiled_action is not null) then
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:

Line 319: FND_LOG.STRING(g_level_statement,

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');
322: END IF;
323: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_CODE(') >0) THEN

Line 325: FND_LOG.STRING(g_level_statement,

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');
328: END IF;
329: pr_do_not_use_this_tax_flag := TRUE;

Line 333: FND_LOG.STRING(g_level_statement,

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');
336: END IF;
337: ELSIF (instr(p_compiled_action, 'ZX_TDS_PROCESS_CEC_PVT.DO_NOT_USE_THIS_TAX_GROUP(') >0) THEN

Line 339: FND_LOG.STRING(g_level_statement,

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');
342: END IF;
343: pr_do_not_use_this_group_flag := TRUE;

Line 355: FND_LOG.STRING(g_level_statement,

351: end if;
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;

Line 364: FND_LOG.STRING(g_level_statement,

360: 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;

Line 398: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

394: order by display_order;
395:
396: 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 (+)');

Line 400: FND_LOG.STRING(g_level_statement,

396: 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;

Line 453: FND_LOG.STRING(g_level_statement,

449: end LOOP;
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;

Line 492: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

488: l_counter NUMBER;
489:
490: 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 (+)');

Line 494: FND_LOG.STRING(g_level_statement,

490: 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;

Line 530: FND_LOG.STRING(g_level_statement,

526: end LOOP;
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;

Line 596: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

592: from hr_organization_units
593: where organization_id = c_organization_id;
594:
595: 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',

Line 599: FND_LOG.STRING(g_level_statement,

595: 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;

Line 646: FND_LOG.STRING(g_level_statement,

642:
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;

Line 661: FND_LOG.STRING(g_level_statement,

657: pg_classification := p_classification;
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;

Line 673: FND_LOG.STRING(g_level_statement,

669:
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:

Line 706: FND_LOG.STRING(g_level_unexpected,

702: elsif l_column = 'TELEPHONE_NUMBER_3' then
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;

Line 714: FND_LOG.STRING(g_level_statement,

710: end if;
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:

Line 770: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

766: ACCT_SITE.CUST_ACCT_SITE_ID = c_address_id;
767:
768: BEGIN
769:
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',

Line 773: FND_LOG.STRING(g_level_statement,

769:
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 ||

Line 795: FND_LOG.STRING(g_level_statement,

791: END IF;
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:

Line 814: FND_LOG.STRING(g_level_statement,

810: fetch c_site_loc_rec into pr_site_loc_rec;
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||

Line 841: FND_LOG.STRING(g_level_statement,

837: ELSIF upper(p_classification) = 'TAX_CLASSIFICATION' then
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;

Line 849: FND_LOG.STRING(g_level_statement,

845: END IF;
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;

Line 859: FND_LOG.STRING(g_level_statement,

855:
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');

Line 936: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

932: ZP.PARTY_TYPE_CODE = 'THIRD_PARTY';
933:
934: BEGIN
935:
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',

Line 939: FND_LOG.STRING(g_level_statement,

935:
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||

Line 1024: FND_LOG.STRING(g_level_statement,

1020: p_classification => p_classification);
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1194: FND_LOG.STRING(g_level_statement,

1190:
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;

Line 1202: FND_LOG.STRING(g_level_statement,

1198: END IF;
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:

Line 1249: FND_LOG.STRING(g_level_statement,

1245: l_value := NULL;
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;

Line 1300: FND_LOG.STRING(g_level_statement,

1296: l_value := NULL;
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;

Line 1330: FND_LOG.STRING(g_level_statement,

1326: return FALSE;
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;

Line 1363: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1359: l_column VARCHAR2(150);
1360:
1361: BEGIN
1362:
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',

Line 1366: FND_LOG.STRING(g_level_statement,

1362:
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;

Line 1399: FND_LOG.STRING(g_level_statement,

1395: END LOOP;
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,

Line 1403: FND_LOG.STRING(g_level_statement,

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',
1405: 'ZX_TDS_PROCESS_CEC_PVT.get_location_column (-)');
1406: END IF;
1407: return NULL;

Line 1432: FND_LOG.STRING(g_level_statement,

1428:
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));

Line 1444: FND_LOG.STRING(g_level_statement,

1440: END LOOP;
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,

Line 1448: FND_LOG.STRING(g_level_statement,

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',
1450: 'Get Location Column (-)');
1451: END IF;
1452: END IF;

Line 1456: FND_LOG.STRING(g_level_statement,

1452: END IF;
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;

Line 1482: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1478: p_flag IN BOOLEAN) is
1479:
1480: 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 (+)');

Line 1484: FND_LOG.STRING(g_level_statement,

1480: 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:

Line 1581: FND_LOG.STRING(g_level_statement,

1577: end if;
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;

Line 1603: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1599: l_x VARCHAR2(20);
1600:
1601: 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 (+)');

Line 1605: FND_LOG.STRING(g_level_statement,

1601: 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;

Line 1631: FND_LOG.STRING(g_level_statement,

1627: end if;
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;

Line 1651: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1647: procedure dump_pr_stats_rec_tbl is
1648:
1649: 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 (+)');

Line 1653: FND_LOG.STRING(g_level_statement,

1649: 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:

Line 1663: FND_LOG.STRING(g_level_statement,

1659: dump_stats_rec(i);
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;

Line 1701: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1697: l_return_val BOOLEAN;
1698:
1699: BEGIN
1700:
1701: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1702: l_return_val := FALSE;
1703:
1704: IF (g_level_statement >= g_current_runtime_level) THEN
1705: FND_LOG.STRING(g_level_statement,

Line 1705: FND_LOG.STRING(g_level_statement,

1701: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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:

Line 1717: FND_LOG.STRING(g_level_statement,

1713: p_operator,
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;

Line 1724: FND_LOG.STRING(g_level_statement,

1720: p_operator||p_value||' evaluates to TRUE');
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;

Line 1738: FND_LOG.STRING(g_level_statement,

1734: p_flag => l_return_val);
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;

Line 1755: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1751: l_return_val BOOLEAN;
1752:
1753: BEGIN
1754:
1755: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1756: l_return_val := FALSE;
1757:
1758: IF (g_level_statement >= g_current_runtime_level ) THEN
1759: FND_LOG.STRING(g_level_statement,

Line 1759: FND_LOG.STRING(g_level_statement,

1755: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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:

Line 1771: FND_LOG.STRING(g_level_statement,

1767: p_operator,
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;

Line 1778: FND_LOG.STRING(g_level_statement,

1774: p_operator||p_value||' evaluates to TRUE');
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;

Line 1792: FND_LOG.STRING(g_level_statement,

1788: p_flag => l_return_val);
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;

Line 1814: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1810: l_return_val BOOLEAN;
1811:
1812: BEGIN
1813:
1814: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1815: l_return_val := FALSE;
1816:
1817: IF (g_level_statement >= g_current_runtime_level ) THEN
1818: FND_LOG.STRING(g_level_statement,

Line 1818: FND_LOG.STRING(g_level_statement,

1814: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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:

Line 1830: FND_LOG.STRING(g_level_statement,

1826: p_operator,
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;

Line 1837: FND_LOG.STRING(g_level_statement,

1833: p_operator||p_value||' evaluates to TRUE');
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;

Line 1851: FND_LOG.STRING(g_level_statement,

1847: p_flag => l_return_val);
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;

Line 1874: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1870: l_return_val BOOLEAN;
1871:
1872: BEGIN
1873:
1874: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1875: l_return_val := FALSE;
1876:
1877: IF (g_level_statement >= g_current_runtime_level ) THEN
1878: FND_LOG.STRING(g_level_statement,

Line 1878: FND_LOG.STRING(g_level_statement,

1874: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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:

Line 1890: FND_LOG.STRING(g_level_statement,

1886: p_operator,
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;

Line 1897: FND_LOG.STRING(g_level_statement,

1893: p_operator||p_value||' evaluates to TRUE');
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;

Line 1911: FND_LOG.STRING(g_level_statement,

1907: p_flag => l_return_val);
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;

Line 1933: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1929: l_return_val BOOLEAN;
1930:
1931: BEGIN
1932:
1933: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1934: l_return_val := FALSE;
1935:
1936: IF (g_level_statement >= g_current_runtime_level ) THEN
1937: FND_LOG.STRING(g_level_statement,

Line 1937: FND_LOG.STRING(g_level_statement,

1933: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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;

Line 1950: FND_LOG.STRING(g_level_statement,

1946: p_operator,
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;

Line 1957: FND_LOG.STRING(g_level_statement,

1953: p_operator||p_value||' evaluates to TRUE');
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;

Line 1971: FND_LOG.STRING(g_level_statement,

1967: p_flag => l_return_val);
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',

Line 1974: FND_LOG.STRING(g_level_statement,

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 (-)');
1977: END IF;
1978: return l_return_val;

Line 1996: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1992: l_return_val BOOLEAN;
1993:
1994: BEGIN
1995:
1996: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1997: l_return_val := FALSE;
1998:
1999: IF (g_level_statement >= g_current_runtime_level ) THEN
2000: FND_LOG.STRING(g_level_statement,

Line 2000: FND_LOG.STRING(g_level_statement,

1996: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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;

Line 2013: FND_LOG.STRING(g_level_statement,

2009: p_operator,
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;

Line 2020: FND_LOG.STRING(g_level_statement,

2016: p_operator||p_value||' evaluates to TRUE');
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;

Line 2035: FND_LOG.STRING(g_level_statement,

2031: dump_stats_rec(IDX_POA);
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;

Line 2057: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2053: l_return_val BOOLEAN;
2054:
2055: BEGIN
2056:
2057: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2058: l_return_val := FALSE;
2059:
2060: IF (g_level_statement >= g_current_runtime_level ) THEN
2061: FND_LOG.STRING(g_level_statement,

Line 2061: FND_LOG.STRING(g_level_statement,

2057: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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;

Line 2075: FND_LOG.STRING(g_level_statement,

2071: p_operator,
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

Line 2081: FND_LOG.STRING(g_level_statement,

2077: 'The Trx condition evaluates to TRUE');
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;

Line 2095: FND_LOG.STRING(g_level_statement,

2091: dump_stats_rec(IDX_TRX); --for bug1833141
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:

Line 2116: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2112: l_return_val BOOLEAN ;
2113:
2114: BEGIN
2115:
2116: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2117: l_return_val := FALSE;
2118:
2119: IF (g_level_statement >= g_current_runtime_level ) THEN
2120: FND_LOG.STRING(g_level_statement,

Line 2120: FND_LOG.STRING(g_level_statement,

2116: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
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:

Line 2133: FND_LOG.STRING(g_level_statement,

2129: p_operator,
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

Line 2139: FND_LOG.STRING(g_level_statement,

2135: 'Item Condition Evaluates to TRUE');
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;

Line 2157: FND_LOG.STRING(g_level_statement,

2153: dump_stats_rec(IDX_ITEM); --for bug1833141
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;

Line 2171: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2167:
2168: PROCEDURE user_message (p_msg IN VARCHAR2 default NULL) is
2169: BEGIN
2170:
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',

Line 2174: FND_LOG.STRING(g_level_statement,

2170:
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

Line 2182: FND_LOG.STRING(g_level_statement,

2178: if (p_msg is not null) then
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:

Line 2197: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2193: PROCEDURE system_message (p_msg IN VARCHAR2 default NULL) is
2194:
2195: BEGIN
2196:
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',

Line 2200: FND_LOG.STRING(g_level_statement,

2196:
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:

Line 2213: FND_LOG.STRING(g_level_statement,

2209: end if;
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:

Line 2223: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2219:
2220: PROCEDURE apply_exception (p_exception IN VARCHAR2 default NULL) is
2221: BEGIN
2222:
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',

Line 2226: FND_LOG.STRING(g_level_statement,

2222:
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.

Line 2236: FND_LOG.STRING(g_level_statement,

2232: pr_tax_rate := to_number(p_exception);
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:

Line 2246: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2242:
2243: PROCEDURE do_not_apply_exception (p_exception IN VARCHAR2 default NULL) is
2244: BEGIN
2245:
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',

Line 2249: FND_LOG.STRING(g_level_statement,

2245:
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;

Line 2255: FND_LOG.STRING(g_level_statement,

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,
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:

Line 2265: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2261:
2262: PROCEDURE use_tax_code (p_tax_code IN VARCHAR2 default NULL) is
2263: BEGIN
2264:
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',

Line 2268: FND_LOG.STRING(g_level_statement,

2264:
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',

Line 2271: FND_LOG.STRING(g_level_statement,

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;
2275:

Line 2281: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2277:
2278: PROCEDURE use_this_tax_code (p_tax_code IN VARCHAR2 default NULL) is
2279: BEGIN
2280:
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',

Line 2284: FND_LOG.STRING(g_level_statement,

2280:
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',

Line 2287: FND_LOG.STRING(g_level_statement,

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;
2291:

Line 2297: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2293:
2294: PROCEDURE default_tax_code (p_tax_code IN VARCHAR2 default NULL) is
2295: BEGIN
2296:
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',

Line 2300: FND_LOG.STRING(g_level_statement,

2296:
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',

Line 2303: FND_LOG.STRING(g_level_statement,

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;
2307:

Line 2313: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2309:
2310: PROCEDURE use_this_tax_group (p_tax_group_code IN VARCHAR2 default NULL) is
2311: BEGIN
2312:
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',

Line 2316: FND_LOG.STRING(g_level_statement,

2312:
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,

Line 2320: FND_LOG.STRING(g_level_statement,

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 (-)');
2323: END IF;
2324:

Line 2330: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2326:
2327: PROCEDURE do_not_use_this_tax_code(p_param IN VARCHAR2 DEFAULT NULL) is
2328: BEGIN
2329:
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',

Line 2333: FND_LOG.STRING(g_level_statement,

2329:
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;

Line 2339: FND_LOG.STRING(g_level_statement,

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,
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:

Line 2349: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2345:
2346: PROCEDURE do_not_use_this_tax_group(p_param IN VARCHAR2 DEFAULT NULL) is
2347: BEGIN
2348:
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',

Line 2352: FND_LOG.STRING(g_level_statement,

2348:
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;

Line 2360: FND_LOG.STRING(g_level_statement,

2356: END IF;
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:

Line 2448: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2444:
2445:
2446: BEGIN
2447:
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',

Line 2451: FND_LOG.STRING(g_level_statement,

2447:
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:

Line 2509: FND_LOG.STRING(g_level_statement,

2505:
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;

Line 2564: FND_LOG.STRING(g_level_statement,

2560:
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: