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_DIFFS2 dependencies on PO_VALIDATIONS

Line 3: c_entity_type_price_diff CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_PRICE_DIFF;

1: PACKAGE BODY PO_VAL_PRICE_DIFFS2 AS
2: -- $Header: PO_VAL_PRICE_DIFFS2.plb 120.8 2006/08/02 23:14:51 jinwang noship $
3: c_entity_type_price_diff CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_entity_type_PRICE_DIFF;
4: -- The module base for this package.
5: d_package_base CONSTANT VARCHAR2(50) := po_log.get_package_base('PO_VAL_PRICE_DIFFS2');
6:
7: -- The module base for the subprogram.

Line 33: x_result_set_id := po_validations.next_result_set_id();

29: IS
30: d_mod CONSTANT VARCHAR2(100) := d_price_type;
31: BEGIN
32: IF x_result_set_id IS NULL THEN
33: x_result_set_id := po_validations.next_result_set_id();
34: END IF;
35:
36: x_result_type := po_validations.c_result_type_success;
37:

Line 36: x_result_type := po_validations.c_result_type_success;

32: IF x_result_set_id IS NULL THEN
33: x_result_set_id := po_validations.next_result_set_id();
34: END IF;
35:
36: x_result_type := po_validations.c_result_type_success;
37:
38: IF po_log.d_proc THEN
39: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
40: po_log.proc_begin(d_mod, 'p_price_type_tbl', p_price_type_tbl);

Line 58: po_validations.c_result_type_failure,

54: token1_name,
55: token1_value,
56: validation_id)
57: SELECT x_result_set_id,
58: po_validations.c_result_type_failure,
59: c_entity_type_price_diff,
60: p_id_tbl(i),
61: DECODE(p_price_type_tbl(i), NULL, 'PO_PDOI_COLUMN_NOT_NULL', 'PO_PDOI_SVC_INVALID_PRICE_TYPE'),
62: 'PRICE_TYPE',

Line 76: x_result_type := po_validations.c_result_type_failure;

72: FROM po_price_diff_lookups_v
73: WHERE price_differential_type = p_price_type_tbl(i)));
74:
75: IF (SQL%ROWCOUNT > 0) THEN
76: x_result_type := po_validations.c_result_type_failure;
77: END IF;
78:
79: IF po_log.d_proc THEN
80: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 80: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

76: x_result_type := po_validations.c_result_type_failure;
77: END IF;
78:
79: IF po_log.d_proc THEN
80: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
81: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
82: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
83: END IF;
84: EXCEPTION

Line 108: x_result_set_id := po_validations.next_result_set_id();

104: d_mod CONSTANT VARCHAR2(100) := d_multiple_price_diff;
105: l_gt_key NUMBER;
106: BEGIN
107: IF x_result_set_id IS NULL THEN
108: x_result_set_id := po_validations.next_result_set_id();
109: END IF;
110:
111: x_result_type := po_validations.c_result_type_success;
112:

Line 111: x_result_type := po_validations.c_result_type_success;

107: IF x_result_set_id IS NULL THEN
108: x_result_set_id := po_validations.next_result_set_id();
109: END IF;
110:
111: x_result_type := po_validations.c_result_type_success;
112:
113: IF po_log.d_proc THEN
114: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
115: po_log.proc_begin(d_mod, 'p_price_type_tbl', p_price_type_tbl);

Line 153: po_validations.c_result_type_failure,

149: token1_name,
150: token1_value,
151: validation_id)
152: SELECT x_result_set_id,
153: po_validations.c_result_type_failure,
154: c_entity_type_price_diff,
155: p_id_tbl(i),
156: 'PO_PDOI_SVC_NO_MULTI_DIFF',
157: 'PRICE_TYPE',

Line 191: x_result_type := po_validations.c_result_type_failure;

187: DELETE FROM po_session_gt
188: WHERE key = l_gt_key;
189:
190: IF (SQL%ROWCOUNT > 0) THEN
191: x_result_type := po_validations.c_result_type_failure;
192: END IF;
193:
194: IF po_log.d_proc THEN
195: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 195: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

191: x_result_type := po_validations.c_result_type_failure;
192: END IF;
193:
194: IF po_log.d_proc THEN
195: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
196: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
197: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
198: END IF;
199: EXCEPTION

Line 226: x_result_type := po_validations.c_result_type_success;

222: IF (x_results IS NULL) THEN
223: x_results := po_validation_results_type.new_instance();
224: END IF;
225:
226: x_result_type := po_validations.c_result_type_success;
227:
228: IF po_log.d_proc THEN
229: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
230: po_log.proc_begin(d_mod, 'p_entity_type_tbl', p_entity_type_tbl);

Line 246: x_result_type := po_validations.c_result_type_failure;

242: p_column_name => 'ENTITY_TYPE',
243: p_column_val => p_entity_type_tbl(i),
244: p_message_name => 'PO_PDOI_SVC_INVALID_ENT_TYPE',
245: p_validation_id => PO_VAL_CONSTANTS.c_entity_type);
246: x_result_type := po_validations.c_result_type_failure;
247: END IF;
248: END LOOP;
249:
250: IF po_log.d_proc THEN

Line 281: x_result_type := po_validations.c_result_type_success;

277: IF (x_results IS NULL) THEN
278: x_results := po_validation_results_type.new_instance();
279: END IF;
280:
281: x_result_type := po_validations.c_result_type_success;
282:
283: IF po_log.d_proc THEN
284: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
285: po_log.proc_begin(d_mod, 'p_entity_type_tbl', p_entity_type_tbl);

Line 298: x_result_type := po_validations.c_result_type_failure;

294: p_column_name => 'MUTLIPLIER',
295: p_column_val => p_multiplier_tbl(i),
296: p_message_name => 'PO_PDOI_SVC_MUST_MULTIPLIER',
297: p_validation_id => PO_VAL_CONSTANTS.c_multiplier_not_null);
298: x_result_type := po_validations.c_result_type_failure;
299: ELSIF p_entity_type_tbl(i) IN('BLANKET LINE', 'PRICE BREAK') AND p_multiplier_tbl(i) IS NOT NULL THEN
300: x_results.add_result(p_entity_type => c_entity_type_price_diff,
301: p_entity_id => p_id_tbl(i),
302: p_column_name => 'MULTIPLIER',

Line 306: x_result_type := po_validations.c_result_type_failure;

302: p_column_name => 'MULTIPLIER',
303: p_column_val => p_multiplier_tbl(i),
304: p_message_name => 'PO_PDOI_SVC_NO_MULTIPLIER',
305: p_validation_id => PO_VAL_CONSTANTS.c_multiplier_null);
306: x_result_type := po_validations.c_result_type_failure;
307: END IF;
308: END LOOP;
309:
310: IF po_log.d_proc THEN

Line 341: x_result_type := po_validations.c_result_type_success;

337: IF (x_results IS NULL) THEN
338: x_results := po_validation_results_type.new_instance();
339: END IF;
340:
341: x_result_type := po_validations.c_result_type_success;
342:
343: IF po_log.d_proc THEN
344: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
345: po_log.proc_begin(d_mod, 'p_entity_type_tbl', p_entity_type_tbl);

Line 358: x_result_type := po_validations.c_result_type_failure;

354: p_column_name => 'MIN_MULTIPLIER',
355: p_column_val => p_min_multiplier_tbl(i),
356: p_message_name => 'PO_PDOI_SVC_NO_MIN_MULT',
357: p_validation_id => PO_VAL_CONSTANTS.c_min_multiplier_null);
358: x_result_type := po_validations.c_result_type_failure;
359: ELSIF p_entity_type_tbl(i) IN('BLANKET LINE', 'PRICE BREAK') AND p_min_multiplier_tbl(i) IS NULL THEN
360: x_results.add_result(p_entity_type => c_entity_type_price_diff,
361: p_entity_id => p_id_tbl(i),
362: p_column_name => 'MIN_MULTIPLIER',

Line 366: x_result_type := po_validations.c_result_type_failure;

362: p_column_name => 'MIN_MULTIPLIER',
363: p_column_val => p_min_multiplier_tbl(i),
364: p_message_name => 'PO_PDOI_SVC_MUST_MIN_MULT',
365: p_validation_id => PO_VAL_CONSTANTS.c_min_multiplier_not_null);
366: x_result_type := po_validations.c_result_type_failure;
367: END IF;
368: END LOOP;
369:
370: IF po_log.d_proc THEN

Line 401: x_result_type := po_validations.c_result_type_success;

397: IF (x_results IS NULL) THEN
398: x_results := po_validation_results_type.new_instance();
399: END IF;
400:
401: x_result_type := po_validations.c_result_type_success;
402:
403: IF po_log.d_proc THEN
404: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);
405: po_log.proc_begin(d_mod, 'p_entity_type_tbl', p_entity_type_tbl);

Line 418: x_result_type := po_validations.c_result_type_failure;

414: p_column_name => 'MAX_MULTIPLIER',
415: p_column_val => p_max_multiplier_tbl(i),
416: p_message_name => 'PO_PDOI_SVC_NO_MAX_MULT',
417: p_validation_id => PO_VAL_CONSTANTS.c_max_multiplier_null);
418: x_result_type := po_validations.c_result_type_failure;
419: END IF;
420: END LOOP;
421:
422: IF po_log.d_proc THEN

Line 448: x_result_set_id := po_validations.next_result_set_id();

444: IS
445: d_mod CONSTANT VARCHAR2(100) := d_style_related_info;
446: BEGIN
447: IF x_result_set_id IS NULL THEN
448: x_result_set_id := po_validations.next_result_set_id();
449: END IF;
450:
451: IF po_log.d_proc THEN
452: po_log.proc_begin(d_mod, 'p_id_tbl', p_id_tbl);

Line 457: x_result_type := po_validations.c_result_type_success;

453: po_log.proc_begin(d_mod, 'p_style_id_tbl', p_style_id_tbl);
454: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
455: END IF;
456:
457: x_result_type := po_validations.c_result_type_success;
458:
459: -- bug5130037
460: -- Have NVL() around pdsh.price_differentials_flag
461: FORALL i IN 1 .. p_id_tbl.COUNT

Line 474: po_validations.c_result_type_failure,

470: token1_name,
471: token1_value,
472: validation_id)
473: SELECT x_result_set_id,
474: po_validations.c_result_type_failure,
475: c_entity_type_price_diff,
476: p_id_tbl(i),
477: 'PO_PDOI_PRICE_DIFF_STYLE',
478: 'STYLE_ID',

Line 490: x_result_type := po_validations.c_result_type_failure;

486: WHERE pdsh.style_id = p_style_id_tbl(i) AND
487: NVL(pdsh.price_differentials_flag, 'N') = 'N');
488:
489: IF (SQL%ROWCOUNT > 0) THEN
490: x_result_type := po_validations.c_result_type_failure;
491: END IF;
492:
493: IF po_log.d_proc THEN
494: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

Line 494: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);

490: x_result_type := po_validations.c_result_type_failure;
491: END IF;
492:
493: IF po_log.d_proc THEN
494: po_validations.log_validation_results_gt(d_mod, 9, x_result_set_id);
495: po_log.proc_end(d_mod, 'x_result_type', x_result_type);
496: po_log.proc_end(d_mod, 'x_result_set_id', x_result_set_id);
497: END IF;
498: EXCEPTION