DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS dependencies on PO_VALIDATIONS

Line 5: c_ENTITY_TYPE_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE_LOCATION;

1: PACKAGE BODY PO_VAL_SHIPMENTS AS
2: -- $Header: PO_VAL_SHIPMENTS.plb 120.14 2006/09/20 18:25:10 tpoon noship $
3:
4:
5: c_ENTITY_TYPE_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE_LOCATION;
6: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;
7:
8: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
9: c_RATE CONSTANT VARCHAR2(30) := 'RATE';

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

2: -- $Header: PO_VAL_SHIPMENTS.plb 120.14 2006/09/20 18:25:10 tpoon noship $
3:
4:
5: c_ENTITY_TYPE_LINE_LOCATION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE_LOCATION;
6: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_LINE;
7:
8: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
9: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
10: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

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

261: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
262: END IF;
263:
264: IF (x_result_set_id IS NULL) THEN
265: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
266: END IF;
267:
268: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
269:

Line 268: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

264: IF (x_result_set_id IS NULL) THEN
265: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
266: END IF;
267:
268: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
269:
270: l_input_size := p_line_loc_id_tbl.COUNT;
271:
272: l_line_loc_id_tbl := PO_TBL_NUMBER();

Line 317: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

313: )
314: ;
315:
316: IF (SQL%ROWCOUNT > 0) THEN
317: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
318: END IF;
319:
320: END IF;
321:

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

319:
320: END IF;
321:
322: IF PO_LOG.d_proc THEN
323: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
324: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
325: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
326: END IF;
327:

Line 389: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

385: END IF;
386: END LOOP;
387:
388: IF (l_results_count < x_results.result_type.COUNT) THEN
389: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
390: ELSE
391: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
392: END IF;
393:

Line 391: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

387:
388: IF (l_results_count < x_results.result_type.COUNT) THEN
389: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
390: ELSE
391: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
392: END IF;
393:
394: IF PO_LOG.d_proc THEN
395: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

Line 840: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

836:
837: END LOOP;
838:
839: IF (l_results_count < x_results.result_type.COUNT) THEN
840: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
841: ELSE
842: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
843: END IF;
844:

Line 842: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

838:
839: IF (l_results_count < x_results.result_type.COUNT) THEN
840: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
841: ELSE
842: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
843: END IF;
844:
845: IF PO_LOG.d_proc THEN
846: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);

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

954: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
955: END IF;
956:
957: IF (x_result_set_id IS NULL) THEN
958: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
959: END IF;
960:
961:
962: FORALL i IN 1 .. p_line_loc_id_tbl.COUNT

Line 1018: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1014: NVL(PLL.quantity_financed, 0))
1015: ;
1016:
1017: IF (SQL%ROWCOUNT > 0) THEN
1018: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1019: ELSE
1020: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1021: END IF;
1022:

Line 1020: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1016:
1017: IF (SQL%ROWCOUNT > 0) THEN
1018: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1019: ELSE
1020: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1021: END IF;
1022:
1023: IF PO_LOG.d_proc THEN
1024: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

1020: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1021: END IF;
1022:
1023: IF PO_LOG.d_proc THEN
1024: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1025: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1026: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1027: END IF;
1028:

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

1136: PO_LOG.proc_begin(d_mod,'x_result_set_id',x_result_set_id);
1137: END IF;
1138:
1139: IF (x_result_set_id IS NULL) THEN
1140: x_result_set_id := PO_VALIDATIONS.next_result_set_id();
1141: END IF;
1142:
1143: FORALL i IN 1 .. p_line_loc_id_tbl.COUNT
1144: INSERT INTO PO_VALIDATION_RESULTS_GT

Line 1197: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1193: NVL(PLL.amount_financed, 0))
1194: ;
1195:
1196: IF (SQL%ROWCOUNT > 0) THEN
1197: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1198: ELSE
1199: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1200: END IF;
1201:

Line 1199: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1195:
1196: IF (SQL%ROWCOUNT > 0) THEN
1197: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1198: ELSE
1199: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1200: END IF;
1201:
1202: IF PO_LOG.d_proc THEN
1203: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);

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

1199: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1200: END IF;
1201:
1202: IF PO_LOG.d_proc THEN
1203: PO_VALIDATIONS.log_validation_results_gt(d_mod,9,x_result_set_id);
1204: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);
1205: PO_LOG.proc_end(d_mod,'x_result_set_id',x_result_set_id);
1206: END IF;
1207:

Line 1364: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;

1360: END LOOP;
1361:
1362: -- Bug 5532560 START
1363: IF (l_results_count < x_results.result_type.COUNT) THEN
1364: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1365: ELSE
1366: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1367: END IF;
1368:

Line 1366: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;

1362: -- Bug 5532560 START
1363: IF (l_results_count < x_results.result_type.COUNT) THEN
1364: x_result_type := PO_VALIDATIONS.c_result_type_FAILURE;
1365: ELSE
1366: x_result_type := PO_VALIDATIONS.c_result_type_SUCCESS;
1367: END IF;
1368:
1369: IF PO_LOG.d_proc THEN
1370: PO_LOG.proc_end(d_mod,'x_result_type',x_result_type);