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_SHIPMENTS2 dependencies on STANDARD

Line 178: OR (p_doc_type = 'STANDARD' AND p_shipment_type_tbl(i) <> 'STANDARD') THEN

174: p_validation_id => PO_VAL_CONSTANTS.c_shipment_type_not_null);
175: x_result_type := po_validations.c_result_type_failure;
176: ELSIF (p_doc_type = 'QUOTATION' AND p_shipment_type_tbl(i) <> 'QUOTATION')
177: OR (p_doc_type = 'BLANKET' AND p_shipment_type_tbl(i) <> 'PRICE BREAK')
178: OR (p_doc_type = 'STANDARD' AND p_shipment_type_tbl(i) <> 'STANDARD') THEN
179: x_results.add_result(p_entity_type => c_entity_type_line_location,
180: p_entity_id => p_id_tbl(i),
181: p_column_name => 'SHIPMENT_TYPE',
182: p_column_val => p_shipment_type_tbl(i),

Line 1051: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal

1047: RAISE;
1048: END qty_rcv_exception_code;
1049:
1050: -------------------------------------------------------------------------
1051: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
1052: -- to NONE, REJECT or WARNING
1053: -------------------------------------------------------------------------
1054: PROCEDURE enforce_ship_to_loc_code(
1055: p_id_tbl IN po_tbl_number,

Line 1076: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal

1072: po_log.proc_begin(d_mod, 'p_shipment_type_tbl', p_shipment_type_tbl);
1073: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1074: END IF;
1075:
1076: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
1077: -- to NONE, REJECT or WARNING
1078: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1079: IF ( p_shipment_type_tbl(i) = 'STANDARD'
1080: AND p_enforce_ship_to_loc_code_tbl(i) IS NOT NULL

Line 1079: IF ( p_shipment_type_tbl(i) = 'STANDARD'

1075:
1076: -- If shipment_type is STANDARD and enforce_ship_to_loc_code is not equal
1077: -- to NONE, REJECT or WARNING
1078: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1079: IF ( p_shipment_type_tbl(i) = 'STANDARD'
1080: AND p_enforce_ship_to_loc_code_tbl(i) IS NOT NULL
1081: AND (p_enforce_ship_to_loc_code_tbl(i) NOT IN('NONE', 'REJECT', 'WARNING'))) THEN
1082: x_results.add_result(p_entity_type => c_entity_type_line_location,
1083: p_entity_id => p_id_tbl(i),

Line 1106: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal

1102: RAISE;
1103: END enforce_ship_to_loc_code;
1104:
1105: -------------------------------------------------------------------------
1106: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not equal
1107: -- to NONE, REJECT or WARNING
1108: -------------------------------------------------------------------------
1109: PROCEDURE allow_sub_receipts_flag(
1110: p_id_tbl IN po_tbl_number,

Line 1131: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and

1127: po_log.proc_begin(d_mod, 'p_allow_sub_receipts_flag_tbl', p_allow_sub_receipts_flag_tbl);
1128: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1129: END IF;
1130:
1131: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and
1132: -- not equal to NONE, REJECT or WARNING
1133: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1134: IF p_shipment_type_tbl(i) = 'STANDARD' AND p_allow_sub_receipts_flag_tbl(i) IS NOT NULL
1135: AND p_allow_sub_receipts_flag_tbl(i) NOT IN('Y', 'N') THEN

Line 1134: IF p_shipment_type_tbl(i) = 'STANDARD' AND p_allow_sub_receipts_flag_tbl(i) IS NOT NULL

1130:
1131: -- If shipment_type is STANDARD and allow_sub_receipts_flag is not null and
1132: -- not equal to NONE, REJECT or WARNING
1133: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1134: IF p_shipment_type_tbl(i) = 'STANDARD' AND p_allow_sub_receipts_flag_tbl(i) IS NOT NULL
1135: AND p_allow_sub_receipts_flag_tbl(i) NOT IN('Y', 'N') THEN
1136: x_results.add_result(p_entity_type => c_entity_type_line_location,
1137: p_entity_id => p_id_tbl(i),
1138: p_column_name => 'ALLOW_SUB_RECEIPTS_FLAG',

Line 1159: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null

1155: RAISE;
1156: END allow_sub_receipts_flag;
1157:
1158: -------------------------------------------------------------------------
1159: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
1160: -- and less than zero.
1161: -------------------------------------------------------------------------
1162: PROCEDURE days_early_receipt_allowed(
1163: p_id_tbl IN po_tbl_number,

Line 1184: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null

1180: po_log.proc_begin(d_mod, 'p_days_early_rcpt_allowed_tbl', p_days_early_rcpt_allowed_tbl);
1181: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1182: END IF;
1183:
1184: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
1185: -- and less than zero.
1186: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1187: IF (p_shipment_type_tbl(i) = 'STANDARD'
1188: AND p_days_early_rcpt_allowed_tbl(i) IS NOT NULL

Line 1187: IF (p_shipment_type_tbl(i) = 'STANDARD'

1183:
1184: -- If shipment_type is STANDARD and days_early_receipt_allowed is not null
1185: -- and less than zero.
1186: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1187: IF (p_shipment_type_tbl(i) = 'STANDARD'
1188: AND p_days_early_rcpt_allowed_tbl(i) IS NOT NULL
1189: AND p_days_early_rcpt_allowed_tbl(i) < 0) THEN
1190: x_results.add_result(p_entity_type => c_entity_type_line_location,
1191: p_entity_id => p_id_tbl(i),

Line 1213: -- If shipment_type is STANDARD and receipt_days_expection_code is not null

1209: RAISE;
1210: END days_early_receipt_allowed;
1211:
1212: -------------------------------------------------------------------------
1213: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
1214: -- and not 'NONE', 'REJECT' not 'WARNING'
1215: -------------------------------------------------------------------------
1216: PROCEDURE receipt_days_exception_code(
1217: p_id_tbl IN po_tbl_number,

Line 1238: -- If shipment_type is STANDARD and receipt_days_expection_code is not null

1234: po_log.proc_begin(d_mod, 'p_days_early_exception_code_tbl', p_rcpt_days_exception_code_tbl);
1235: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1236: END IF;
1237:
1238: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
1239: -- and not 'NONE', 'REJECT' not 'WARNING'
1240: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1241: IF p_shipment_type_tbl(i) = 'STANDARD'
1242: AND p_rcpt_days_exception_code_tbl(i) IS NOT NULL

Line 1241: IF p_shipment_type_tbl(i) = 'STANDARD'

1237:
1238: -- If shipment_type is STANDARD and receipt_days_expection_code is not null
1239: -- and not 'NONE', 'REJECT' not 'WARNING'
1240: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1241: IF p_shipment_type_tbl(i) = 'STANDARD'
1242: AND p_rcpt_days_exception_code_tbl(i) IS NOT NULL
1243: AND p_rcpt_days_exception_code_tbl(i) NOT IN('NONE', 'REJECT', 'WARNING') THEN
1244: x_results.add_result(p_entity_type => c_entity_type_line_location,
1245: p_entity_id => p_id_tbl(i),

Line 1267: -- If shipment_type is STANDARD and invoice_close_tolerance is not null

1263: RAISE;
1264: END receipt_days_exception_code;
1265:
1266: -------------------------------------------------------------------------
1267: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
1268: -- and less than or equal to zero or greater than or equal to 100.
1269: -------------------------------------------------------------------------
1270: PROCEDURE invoice_close_tolerance(
1271: p_id_tbl IN po_tbl_number,

Line 1292: -- If shipment_type is STANDARD and invoice_close_tolerance is not null

1288: po_log.proc_begin(d_mod, 'p_invoice_close_tolerance_tbl', p_invoice_close_tolerance_tbl);
1289: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1290: END IF;
1291:
1292: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
1293: -- and less than or equal to zero or greater than or equal to 100.
1294: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1295: IF p_shipment_type_tbl(i) = 'STANDARD' AND
1296: p_invoice_close_tolerance_tbl(i) IS NOT NULL AND

Line 1295: IF p_shipment_type_tbl(i) = 'STANDARD' AND

1291:
1292: -- If shipment_type is STANDARD and invoice_close_tolerance is not null
1293: -- and less than or equal to zero or greater than or equal to 100.
1294: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1295: IF p_shipment_type_tbl(i) = 'STANDARD' AND
1296: p_invoice_close_tolerance_tbl(i) IS NOT NULL AND
1297: (p_invoice_close_tolerance_tbl(i) < 0 OR p_invoice_close_tolerance_tbl(i) > 100) THEN
1298: x_results.add_result(p_entity_type => c_entity_type_line_location,
1299: p_entity_id => p_invoice_close_tolerance_tbl(i),

Line 1321: -- If shipment_type is STANDARD and receive_close_tolerance is not null

1317: RAISE;
1318: END invoice_close_tolerance;
1319:
1320: -------------------------------------------------------------------------
1321: -- If shipment_type is STANDARD and receive_close_tolerance is not null
1322: -- and less than or equal to zero or greater than or equal to 100.
1323: -------------------------------------------------------------------------
1324: PROCEDURE receive_close_tolerance(
1325: p_id_tbl IN po_tbl_number,

Line 1346: -- If shipment_type is STANDARD and receive_close_tolerance is not null

1342: po_log.proc_begin(d_mod, 'p_receive_close_tolerance_tbl', p_receive_close_tolerance_tbl);
1343: po_log.LOG(po_log.c_proc_begin, d_mod, NULL, 'x_results', x_results);
1344: END IF;
1345:
1346: -- If shipment_type is STANDARD and receive_close_tolerance is not null
1347: -- and less than or equal to zero or greater than or equal to 100.
1348: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1349: IF p_shipment_type_tbl(i) = 'STANDARD' AND
1350: p_receive_close_tolerance_tbl(i) IS NOT NULL AND

Line 1349: IF p_shipment_type_tbl(i) = 'STANDARD' AND

1345:
1346: -- If shipment_type is STANDARD and receive_close_tolerance is not null
1347: -- and less than or equal to zero or greater than or equal to 100.
1348: FOR i IN 1 .. p_id_tbl.COUNT LOOP
1349: IF p_shipment_type_tbl(i) = 'STANDARD' AND
1350: p_receive_close_tolerance_tbl(i) IS NOT NULL AND
1351: (p_receive_close_tolerance_tbl(i) < 0 OR p_receive_close_tolerance_tbl(i) > 100) THEN
1352: x_results.add_result(p_entity_type => c_entity_type_line_location,
1353: p_entity_id => p_id_tbl(i),

Line 1422: AND p_shipment_type_tbl(i) = 'STANDARD'

1418: 'RECEIVING_ROUTING_ID',
1419: p_receiving_routing_id_tbl(i)
1420: FROM DUAL
1421: WHERE p_receiving_routing_id_tbl(i) IS NOT NULL
1422: AND p_shipment_type_tbl(i) = 'STANDARD'
1423: AND NOT EXISTS(SELECT 1
1424: FROM rcv_routing_headers rrh
1425: WHERE rrh.routing_header_id = p_receiving_routing_id_tbl(i));
1426: