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.

[Home] [Help]

APPS.PO_PRICE_HELPER dependencies on PO_VALIDATIONS

Line 49: PO_VALIDATIONS.result_type_rank(PO_VALIDATIONS.c_result_type_warning);

45: -- Constants.
46: ---------------------------------------------------------------------------
47:
48: c_result_type_rank_WARNING CONSTANT NUMBER :=
49: PO_VALIDATIONS.result_type_rank(PO_VALIDATIONS.c_result_type_warning);
50:
51: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_ENTITY_TYPE_LINE;
52:
53: c_UNIT_PRICE CONSTANT VARCHAR2(30) := 'UNIT_PRICE';

Line 51: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_ENTITY_TYPE_LINE;

47:
48: c_result_type_rank_WARNING CONSTANT NUMBER :=
49: PO_VALIDATIONS.result_type_rank(PO_VALIDATIONS.c_result_type_warning);
50:
51: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_ENTITY_TYPE_LINE;
52:
53: c_UNIT_PRICE CONSTANT VARCHAR2(30) := 'UNIT_PRICE';
54:
55: -- PO_HEADERS_ALL.type_lookup_code

Line 127: PO_VALIDATIONS.validate_unit_price_change(

123: IF PO_LOG.d_stmt THEN
124: PO_LOG.stmt(d_mod,d_position,'l_line_id_tbl',l_line_id_tbl);
125: END IF;
126:
127: PO_VALIDATIONS.validate_unit_price_change(
128: p_line_id_tbl => l_line_id_tbl
129: , p_price_break_lookup_code_tbl => l_price_break_lookup_code_tbl
130: , p_stopping_result_type => PO_VALIDATIONS.c_result_type_FAILURE
131: , x_result_type => l_result_type

Line 130: , p_stopping_result_type => PO_VALIDATIONS.c_result_type_FAILURE

126:
127: PO_VALIDATIONS.validate_unit_price_change(
128: p_line_id_tbl => l_line_id_tbl
129: , p_price_break_lookup_code_tbl => l_price_break_lookup_code_tbl
130: , p_stopping_result_type => PO_VALIDATIONS.c_result_type_FAILURE
131: , x_result_type => l_result_type
132: , x_result_set_id => l_result_set_id
133: , x_results => l_results
134: );

Line 142: IF (PO_VALIDATIONS.result_type_rank(l_result_type) >=

138: PO_LOG.stmt(d_mod,d_position,'l_result_set_id',l_result_set_id);
139: PO_LOG.stmt(d_mod,d_position,'l_result_type',l_result_type);
140: END IF;
141:
142: IF (PO_VALIDATIONS.result_type_rank(l_result_type) >=
143: c_result_type_rank_WARNING)
144: THEN
145: x_system_allows_update := 'Y';
146: ELSE

Line 355: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

351:
352: d_position := 1;
353:
354: IF (x_result_set_id IS NULL) THEN
355: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
356: END IF;
357:
358: d_position := 100;
359:

Line 394: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

390:
391: d_position := 200;
392:
393: IF (SQL%ROWCOUNT > 0) THEN
394: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
395: ELSE
396: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
397: END IF;
398:

Line 396: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

392:
393: IF (SQL%ROWCOUNT > 0) THEN
394: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
395: ELSE
396: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
397: END IF;
398:
399: IF PO_LOG.d_proc THEN
400: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

Line 577: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

573:
574: END LOOP;
575:
576: IF (l_results_count < x_results.result_type.COUNT) THEN
577: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
578: ELSE
579: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
580: END IF;
581:

Line 579: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

575:
576: IF (l_results_count < x_results.result_type.COUNT) THEN
577: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
578: ELSE
579: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
580: END IF;
581:
582: IF PO_LOG.d_proc THEN
583: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 688: x_result_set_id := PO_VALIDATIONS.next_result_set_id();

684:
685: d_position := 1;
686:
687: IF (x_result_set_id IS NULL) THEN
688: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
689: END IF;
690:
691: d_position := 100;
692:

Line 723: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

719:
720: d_position := 200;
721:
722: IF (SQL%ROWCOUNT > 0) THEN
723: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
724: ELSE
725: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
726: END IF;
727:

Line 725: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

721:
722: IF (SQL%ROWCOUNT > 0) THEN
723: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
724: ELSE
725: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
726: END IF;
727:
728: IF PO_LOG.d_proc THEN
729: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);

Line 905: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

901:
902: END IF;
903:
904: IF (l_results_count < x_results.result_type.COUNT) THEN
905: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
906: ELSE
907: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
908: END IF;
909:

Line 907: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

903:
904: IF (l_results_count < x_results.result_type.COUNT) THEN
905: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
906: ELSE
907: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
908: END IF;
909:
910: IF PO_LOG.d_proc THEN
911: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);