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.PO_VAL_PRICE_DIFFS dependencies on PO_LOG

Line 28: PO_LOG.get_package_base('PO_VAL_PRICE_DIFFS');

24: ---------------------------------------------------------------------------
25:
26: -- The module base for this package.
27: D_PACKAGE_BASE CONSTANT VARCHAR2(50) :=
28: PO_LOG.get_package_base('PO_VAL_PRICE_DIFFS');
29:
30: -- The module base for the subprogram.
31: D_max_mul_ge_zero CONSTANT VARCHAR2(100) :=
32: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_mul_ge_zero');

Line 32: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_mul_ge_zero');

28: PO_LOG.get_package_base('PO_VAL_PRICE_DIFFS');
29:
30: -- The module base for the subprogram.
31: D_max_mul_ge_zero CONSTANT VARCHAR2(100) :=
32: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_mul_ge_zero');
33:
34: D_max_mul_ge_min_mul CONSTANT VARCHAR2(100) :=
35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_mul_ge_min_mul');
36:

Line 35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_mul_ge_min_mul');

31: D_max_mul_ge_zero CONSTANT VARCHAR2(100) :=
32: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_mul_ge_zero');
33:
34: D_max_mul_ge_min_mul CONSTANT VARCHAR2(100) :=
35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_mul_ge_min_mul');
36:
37: D_min_mul_ge_zero CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_mul_ge_zero');
39:

Line 38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_mul_ge_zero');

34: D_max_mul_ge_min_mul CONSTANT VARCHAR2(100) :=
35: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'max_mul_ge_min_mul');
36:
37: D_min_mul_ge_zero CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_mul_ge_zero');
39:
40: D_mul_ge_zero CONSTANT VARCHAR2(100) :=
41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mul_ge_zero');
42:

Line 41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mul_ge_zero');

37: D_min_mul_ge_zero CONSTANT VARCHAR2(100) :=
38: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'min_mul_ge_zero');
39:
40: D_mul_ge_zero CONSTANT VARCHAR2(100) :=
41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mul_ge_zero');
42:
43: D_unique_price_diff_num CONSTANT VARCHAR2(100) :=
44: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unique_price_diff_num');
45:

Line 44: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unique_price_diff_num');

40: D_mul_ge_zero CONSTANT VARCHAR2(100) :=
41: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'mul_ge_zero');
42:
43: D_unique_price_diff_num CONSTANT VARCHAR2(100) :=
44: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unique_price_diff_num');
45:
46: D_price_diff_num_gt_zero CONSTANT VARCHAR2(100) :=
47: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_num_gt_zero');
48:

Line 47: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_num_gt_zero');

43: D_unique_price_diff_num CONSTANT VARCHAR2(100) :=
44: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unique_price_diff_num');
45:
46: D_price_diff_num_gt_zero CONSTANT VARCHAR2(100) :=
47: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_num_gt_zero');
48:
49: D_unique_price_type CONSTANT VARCHAR2(100) :=
50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unique_price_type');
51:

Line 50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unique_price_type');

46: D_price_diff_num_gt_zero CONSTANT VARCHAR2(100) :=
47: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'price_diff_num_gt_zero');
48:
49: D_unique_price_type CONSTANT VARCHAR2(100) :=
50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unique_price_type');
51:
52: D_spo_price_type_on_src_doc CONSTANT VARCHAR2(100) :=
53: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_price_type_on_src_doc');
54:

Line 53: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_price_type_on_src_doc');

49: D_unique_price_type CONSTANT VARCHAR2(100) :=
50: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'unique_price_type');
51:
52: D_spo_price_type_on_src_doc CONSTANT VARCHAR2(100) :=
53: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_price_type_on_src_doc');
54:
55: D_spo_mul_btwn_min_max CONSTANT VARCHAR2(100) :=
56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_mul_btwn_min_max');
57:

Line 56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_mul_btwn_min_max');

52: D_spo_price_type_on_src_doc CONSTANT VARCHAR2(100) :=
53: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_price_type_on_src_doc');
54:
55: D_spo_mul_btwn_min_max CONSTANT VARCHAR2(100) :=
56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_mul_btwn_min_max');
57:
58: D_spo_mul_ge_min CONSTANT VARCHAR2(100) :=
59: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_mul_ge_min');
60:

Line 59: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_mul_ge_min');

55: D_spo_mul_btwn_min_max CONSTANT VARCHAR2(100) :=
56: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_mul_btwn_min_max');
57:
58: D_spo_mul_ge_min CONSTANT VARCHAR2(100) :=
59: PO_LOG.get_subprogram_base(D_PACKAGE_BASE,'spo_mul_ge_min');
60:
61:
62: -------------------------------------------------------------------------------
63: -- This procedure determines if max mulitipliers are greater than or equal to

Line 280: IF PO_LOG.d_proc THEN

276: IS
277: d_mod CONSTANT VARCHAR2(100) := D_spo_price_type_on_src_doc;
278: BEGIN
279:
280: IF PO_LOG.d_proc THEN
281: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
282: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
283: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
284: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);

Line 281: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);

277: d_mod CONSTANT VARCHAR2(100) := D_spo_price_type_on_src_doc;
278: BEGIN
279:
280: IF PO_LOG.d_proc THEN
281: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
282: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
283: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
284: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
285: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);

Line 282: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);

278: BEGIN
279:
280: IF PO_LOG.d_proc THEN
281: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
282: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
283: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
284: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
285: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
286: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 283: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);

279:
280: IF PO_LOG.d_proc THEN
281: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
282: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
283: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
284: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
285: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
286: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
287: END IF;

Line 284: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);

280: IF PO_LOG.d_proc THEN
281: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
282: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
283: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
284: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
285: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
286: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
287: END IF;
288:

Line 285: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);

281: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
282: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
283: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
284: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
285: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
286: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
287: END IF;
288:
289: IF (x_result_set_id IS NULL) THEN

Line 286: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

282: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
283: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
284: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
285: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
286: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
287: END IF;
288:
289: IF (x_result_set_id IS NULL) THEN
290: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 332: IF PO_LOG.d_proc THEN

328: ELSE
329: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
330: END IF;
331:
332: IF PO_LOG.d_proc THEN
333: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
334: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
335: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
336: END IF;

Line 334: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

330: END IF;
331:
332: IF PO_LOG.d_proc THEN
333: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
334: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
335: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
336: END IF;
337:
338: EXCEPTION

Line 335: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

331:
332: IF PO_LOG.d_proc THEN
333: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
334: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
335: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
336: END IF;
337:
338: EXCEPTION
339: WHEN OTHERS THEN

Line 340: IF PO_LOG.d_exc THEN

336: END IF;
337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: IF PO_LOG.d_exc THEN
341: PO_LOG.exc(d_mod,0,NULL);
342: END IF;
343: RAISE;
344:

Line 341: PO_LOG.exc(d_mod,0,NULL);

337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: IF PO_LOG.d_exc THEN
341: PO_LOG.exc(d_mod,0,NULL);
342: END IF;
343: RAISE;
344:
345: END spo_price_type_on_src_doc;

Line 366: IF PO_LOG.d_proc THEN

362: IS
363: d_mod CONSTANT VARCHAR2(100) := D_spo_mul_btwn_min_max;
364: BEGIN
365:
366: IF PO_LOG.d_proc THEN
367: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
368: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
369: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
370: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);

Line 367: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);

363: d_mod CONSTANT VARCHAR2(100) := D_spo_mul_btwn_min_max;
364: BEGIN
365:
366: IF PO_LOG.d_proc THEN
367: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
368: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
369: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
370: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
371: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);

Line 368: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);

364: BEGIN
365:
366: IF PO_LOG.d_proc THEN
367: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
368: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
369: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
370: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
371: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
372: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);

Line 369: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);

365:
366: IF PO_LOG.d_proc THEN
367: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
368: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
369: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
370: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
371: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
372: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
373: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 370: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);

366: IF PO_LOG.d_proc THEN
367: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
368: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
369: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
370: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
371: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
372: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
373: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
374: END IF;

Line 371: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);

367: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
368: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
369: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
370: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
371: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
372: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
373: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
374: END IF;
375:

Line 372: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);

368: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
369: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
370: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
371: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
372: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
373: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
374: END IF;
375:
376: IF (x_result_set_id IS NULL) THEN

Line 373: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

369: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
370: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
371: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
372: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
373: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
374: END IF;
375:
376: IF (x_result_set_id IS NULL) THEN
377: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 428: IF PO_LOG.d_proc THEN

424: ELSE
425: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
426: END IF;
427:
428: IF PO_LOG.d_proc THEN
429: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
430: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
431: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
432: END IF;

Line 430: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

426: END IF;
427:
428: IF PO_LOG.d_proc THEN
429: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
430: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
431: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
432: END IF;
433:
434: EXCEPTION

Line 431: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

427:
428: IF PO_LOG.d_proc THEN
429: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
430: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
431: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
432: END IF;
433:
434: EXCEPTION
435: WHEN OTHERS THEN

Line 436: IF PO_LOG.d_exc THEN

432: END IF;
433:
434: EXCEPTION
435: WHEN OTHERS THEN
436: IF PO_LOG.d_exc THEN
437: PO_LOG.exc(d_mod,0,NULL);
438: END IF;
439: RAISE;
440:

Line 437: PO_LOG.exc(d_mod,0,NULL);

433:
434: EXCEPTION
435: WHEN OTHERS THEN
436: IF PO_LOG.d_exc THEN
437: PO_LOG.exc(d_mod,0,NULL);
438: END IF;
439: RAISE;
440:
441: END spo_mul_btwn_min_max;

Line 463: IF PO_LOG.d_proc THEN

459: IS
460: d_mod CONSTANT VARCHAR2(100) := D_spo_mul_ge_min;
461: BEGIN
462:
463: IF PO_LOG.d_proc THEN
464: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
465: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
466: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
467: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);

Line 464: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);

460: d_mod CONSTANT VARCHAR2(100) := D_spo_mul_ge_min;
461: BEGIN
462:
463: IF PO_LOG.d_proc THEN
464: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
465: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
466: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
467: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
468: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);

Line 465: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);

461: BEGIN
462:
463: IF PO_LOG.d_proc THEN
464: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
465: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
466: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
467: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
468: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
469: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);

Line 466: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);

462:
463: IF PO_LOG.d_proc THEN
464: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
465: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
466: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
467: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
468: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
469: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
470: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

Line 467: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);

463: IF PO_LOG.d_proc THEN
464: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
465: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
466: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
467: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
468: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
469: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
470: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
471: END IF;

Line 468: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);

464: PO_LOG.proc_begin(d_mod,'p_price_differential_id_tbl',p_price_differential_id_tbl);
465: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
466: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
467: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
468: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
469: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
470: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
471: END IF;
472:

Line 469: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);

465: PO_LOG.proc_begin(d_mod,'p_entity_type_tbl',p_entity_type_tbl);
466: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
467: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
468: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
469: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
470: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
471: END IF;
472:
473: IF (x_result_set_id IS NULL) THEN

Line 470: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);

466: PO_LOG.proc_begin(d_mod,'p_from_line_location_id_tbl',p_from_line_location_id_tbl);
467: PO_LOG.proc_begin(d_mod,'p_from_line_id_tbl',p_from_line_id_tbl);
468: PO_LOG.proc_begin(d_mod,'p_multiplier_tbl',p_multiplier_tbl);
469: PO_LOG.proc_begin(d_mod,'p_price_type_tbl',p_price_type_tbl);
470: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
471: END IF;
472:
473: IF (x_result_set_id IS NULL) THEN
474: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

Line 519: IF PO_LOG.d_proc THEN

515: ELSE
516: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
517: END IF;
518:
519: IF PO_LOG.d_proc THEN
520: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
521: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
522: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
523: END IF;

Line 521: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

517: END IF;
518:
519: IF PO_LOG.d_proc THEN
520: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
521: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
522: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
523: END IF;
524:
525: EXCEPTION

Line 522: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

518:
519: IF PO_LOG.d_proc THEN
520: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
521: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
522: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
523: END IF;
524:
525: EXCEPTION
526: WHEN OTHERS THEN

Line 527: IF PO_LOG.d_exc THEN

523: END IF;
524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF PO_LOG.d_exc THEN
528: PO_LOG.exc(d_mod,0,NULL);
529: END IF;
530: RAISE;
531:

Line 528: PO_LOG.exc(d_mod,0,NULL);

524:
525: EXCEPTION
526: WHEN OTHERS THEN
527: IF PO_LOG.d_exc THEN
528: PO_LOG.exc(d_mod,0,NULL);
529: END IF;
530: RAISE;
531:
532: END spo_mul_ge_min;