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

Line 4: c_ENTITY_TYPE_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_DISTRIBUTION;

1: PACKAGE BODY PO_VAL_DISTRIBUTIONS AS
2: -- $Header: PO_VAL_DISTRIBUTIONS.plb 120.16.12010000.2 2008/12/08 10:43:23 cvardia ship $
3:
4: c_ENTITY_TYPE_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_DISTRIBUTION;
5: c_NEW CONSTANT VARCHAR2(3) := 'NEW';
6: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
7: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

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

191: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
192: END IF;
193:
194: IF (x_result_set_id IS NULL) THEN
195: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
196: END IF;
197:
198: FORALL i IN 1 .. p_dist_id_tbl.COUNT
199: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 252: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

248: NVL(POD.quantity_financed, 0))
249: ;
250:
251: IF (SQL%ROWCOUNT > 0) THEN
252: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
253: ELSE
254: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
255: END IF;
256:

Line 254: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

250:
251: IF (SQL%ROWCOUNT > 0) THEN
252: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
253: ELSE
254: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
255: END IF;
256:
257: IF PO_LOG.d_proc THEN
258: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

Line 258: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

254: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
255: END IF;
256:
257: IF PO_LOG.d_proc THEN
258: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
259: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
260: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
261: END IF;
262:

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

327: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
328: END IF;
329:
330: IF (x_result_set_id IS NULL) THEN
331: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
332: END IF;
333:
334: FORALL i IN 1 .. p_dist_id_tbl.COUNT
335: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 386: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

382: NVL(POD.amount_financed, 0),
383: NVL(POD.amount_billed, 0));
384:
385: IF (SQL%ROWCOUNT > 0) THEN
386: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
387: ELSE
388: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
389: END IF;
390:

Line 388: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

384:
385: IF (SQL%ROWCOUNT > 0) THEN
386: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
387: ELSE
388: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
389: END IF;
390:
391: IF PO_LOG.d_proc THEN
392: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

Line 392: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

388: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
389: END IF;
390:
391: IF PO_LOG.d_proc THEN
392: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
393: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
394: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
395: END IF;
396:

Line 483: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

479:
480: END LOOP;
481:
482: IF (l_results_count < x_results.result_type.COUNT) THEN
483: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
484: ELSE
485: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
486: END IF;
487:

Line 485: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

481:
482: IF (l_results_count < x_results.result_type.COUNT) THEN
483: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
484: ELSE
485: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
486: END IF;
487:
488: IF PO_LOG.d_proc THEN
489: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 601: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

597:
598: END LOOP;
599:
600: IF (l_results_count < x_results.result_type.COUNT) THEN
601: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
602: ELSE
603: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
604: END IF;
605:

Line 603: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

599:
600: IF (l_results_count < x_results.result_type.COUNT) THEN
601: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
602: ELSE
603: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
604: END IF;
605:
606: IF PO_LOG.d_proc THEN
607: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 793: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

789: END IF; -- l_po_enc_flag = 'Y'
790: END LOOP;
791:
792: IF (l_results_count < x_results.result_type.COUNT) THEN
793: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
794: ELSE
795: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
796: END IF;
797:

Line 795: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

791:
792: IF (l_results_count < x_results.result_type.COUNT) THEN
793: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
794: ELSE
795: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
796: END IF;
797:
798: END gl_enc_date_not_null_open;
799:

Line 859: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

855:
856: END IF; -- if is_gms_enabled
857:
858: IF (l_results_count < x_results.result_type.COUNT) THEN
859: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
860: ELSE
861: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
862: END IF;
863:

Line 861: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

857:
858: IF (l_results_count < x_results.result_type.COUNT) THEN
859: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
860: ELSE
861: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
862: END IF;
863:
864: END gms_data_valid;
865:

Line 951: l_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

947:
948:
949: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
950: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
951: l_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
952: ELSE
953: l_result_type := PO_VALIDATIONS.c_result_type_WARNING;
954: END IF;
955:

Line 953: l_result_type := PO_VALIDATIONS.c_result_type_WARNING;

949: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
950: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
951: l_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
952: ELSE
953: l_result_type := PO_VALIDATIONS.c_result_type_WARNING;
954: END IF;
955:
956: x_results.add_result(
957: p_entity_type => c_entity_type_DISTRIBUTION

Line 971: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;

967: END LOOP;
968:
969: IF (l_results_count < x_results.result_type.COUNT) THEN
970:
971: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
972:
973: FOR j IN 1..x_results.result_type.COUNT LOOP
974: IF (x_results.result_type(j) = PO_VALIDATIONS.c_result_type_FAILURE)
975: THEN

Line 974: IF (x_results.result_type(j) = PO_VALIDATIONS.c_result_type_FAILURE)

970:
971: x_result_type := PO_VALIDATIONS.c_result_type_WARNING;
972:
973: FOR j IN 1..x_results.result_type.COUNT LOOP
974: IF (x_results.result_type(j) = PO_VALIDATIONS.c_result_type_FAILURE)
975: THEN
976: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
977: END IF;
978: exit;

Line 976: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

972:
973: FOR j IN 1..x_results.result_type.COUNT LOOP
974: IF (x_results.result_type(j) = PO_VALIDATIONS.c_result_type_FAILURE)
975: THEN
976: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
977: END IF;
978: exit;
979: END LOOP;
980:

Line 982: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

978: exit;
979: END LOOP;
980:
981: ELSE
982: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
983: END IF;
984:
985: IF PO_LOG.d_proc THEN
986: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 1139: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1135: END IF;
1136: END LOOP;
1137:
1138: IF (l_results_count < x_results.result_type.COUNT) THEN
1139: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1140: ELSE
1141: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1142: END IF;
1143:

Line 1141: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1137:
1138: IF (l_results_count < x_results.result_type.COUNT) THEN
1139: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1140: ELSE
1141: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1142: END IF;
1143:
1144: IF po_log.d_proc THEN
1145: po_log.proc_end(d_mod, 'x_result_type', x_result_type);