1286:
1287: FOR table_index IN 1..record_count
1288: LOOP
1289: IF NVL(p_rtg_revision_tbl(table_index).assembly_item_name,
1290: FND_API.G_MISS_CHAR) <>
1291: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1292: OR
1293: NVL(p_rtg_revision_tbl(table_index).organization_code,
1294: FND_API.G_MISS_CHAR) <>
1287: FOR table_index IN 1..record_count
1288: LOOP
1289: IF NVL(p_rtg_revision_tbl(table_index).assembly_item_name,
1290: FND_API.G_MISS_CHAR) <>
1291: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1292: OR
1293: NVL(p_rtg_revision_tbl(table_index).organization_code,
1294: FND_API.G_MISS_CHAR) <>
1295: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1290: FND_API.G_MISS_CHAR) <>
1291: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1292: OR
1293: NVL(p_rtg_revision_tbl(table_index).organization_code,
1294: FND_API.G_MISS_CHAR) <>
1295: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1296: THEN
1297: RETURN FALSE;
1298: END IF;
1291: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1292: OR
1293: NVL(p_rtg_revision_tbl(table_index).organization_code,
1294: FND_API.G_MISS_CHAR) <>
1295: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1296: THEN
1297: RETURN FALSE;
1298: END IF;
1299: END LOOP;
1326:
1327: FOR table_index IN 1..record_count
1328: LOOP
1329: IF NVL(p_operation_tbl(table_index).assembly_item_name,
1330: FND_API.G_MISS_CHAR) <>
1331: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1332: OR
1333: NVL(p_operation_tbl(table_index).organization_code,
1334: FND_API.G_MISS_CHAR) <>
1327: FOR table_index IN 1..record_count
1328: LOOP
1329: IF NVL(p_operation_tbl(table_index).assembly_item_name,
1330: FND_API.G_MISS_CHAR) <>
1331: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1332: OR
1333: NVL(p_operation_tbl(table_index).organization_code,
1334: FND_API.G_MISS_CHAR) <>
1335: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1330: FND_API.G_MISS_CHAR) <>
1331: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1332: OR
1333: NVL(p_operation_tbl(table_index).organization_code,
1334: FND_API.G_MISS_CHAR) <>
1335: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1336: OR
1337: NVL(p_operation_tbl(table_index).alternate_routing_code,
1338: FND_API.G_MISS_CHAR) <>
1331: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1332: OR
1333: NVL(p_operation_tbl(table_index).organization_code,
1334: FND_API.G_MISS_CHAR) <>
1335: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1336: OR
1337: NVL(p_operation_tbl(table_index).alternate_routing_code,
1338: FND_API.G_MISS_CHAR) <>
1339: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1334: FND_API.G_MISS_CHAR) <>
1335: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1336: OR
1337: NVL(p_operation_tbl(table_index).alternate_routing_code,
1338: FND_API.G_MISS_CHAR) <>
1339: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1340: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1341: <> 'XXXXXXXXXX'
1342: THEN
1335: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1336: OR
1337: NVL(p_operation_tbl(table_index).alternate_routing_code,
1338: FND_API.G_MISS_CHAR) <>
1339: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1340: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1341: <> 'XXXXXXXXXX'
1342: THEN
1343: RETURN FALSE;
1336: OR
1337: NVL(p_operation_tbl(table_index).alternate_routing_code,
1338: FND_API.G_MISS_CHAR) <>
1339: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1340: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1341: <> 'XXXXXXXXXX'
1342: THEN
1343: RETURN FALSE;
1344: END IF;
1373:
1374: FOR table_index IN 1..record_count
1375: LOOP
1376: IF NVL(p_op_resource_tbl (table_index).assembly_item_name,
1377: FND_API.G_MISS_CHAR) <>
1378: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1379: OR NVL(p_op_resource_tbl(table_index).organization_code,
1380: FND_API.G_MISS_CHAR) <>
1381: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1374: FOR table_index IN 1..record_count
1375: LOOP
1376: IF NVL(p_op_resource_tbl (table_index).assembly_item_name,
1377: FND_API.G_MISS_CHAR) <>
1378: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1379: OR NVL(p_op_resource_tbl(table_index).organization_code,
1380: FND_API.G_MISS_CHAR) <>
1381: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1382: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1376: IF NVL(p_op_resource_tbl (table_index).assembly_item_name,
1377: FND_API.G_MISS_CHAR) <>
1378: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1379: OR NVL(p_op_resource_tbl(table_index).organization_code,
1380: FND_API.G_MISS_CHAR) <>
1381: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1382: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1383: FND_API.G_MISS_CHAR) <>
1384: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1377: FND_API.G_MISS_CHAR) <>
1378: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1379: OR NVL(p_op_resource_tbl(table_index).organization_code,
1380: FND_API.G_MISS_CHAR) <>
1381: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1382: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1383: FND_API.G_MISS_CHAR) <>
1384: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1385: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1379: OR NVL(p_op_resource_tbl(table_index).organization_code,
1380: FND_API.G_MISS_CHAR) <>
1381: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1382: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1383: FND_API.G_MISS_CHAR) <>
1384: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1385: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1386: <> 'XXXXXXXXXX'
1387: THEN
1380: FND_API.G_MISS_CHAR) <>
1381: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1382: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1383: FND_API.G_MISS_CHAR) <>
1384: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1385: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1386: <> 'XXXXXXXXXX'
1387: THEN
1388: RETURN FALSE;
1381: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1382: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1383: FND_API.G_MISS_CHAR) <>
1384: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1385: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1386: <> 'XXXXXXXXXX'
1387: THEN
1388: RETURN FALSE;
1389: END IF;
1418:
1419: FOR table_index IN 1..record_count
1420: LOOP
1421: IF NVL(p_sub_resource_tbl(table_index).assembly_item_name,
1422: FND_API.G_MISS_CHAR) <>
1423: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1424: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1425: FND_API.G_MISS_CHAR) <>
1426: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1419: FOR table_index IN 1..record_count
1420: LOOP
1421: IF NVL(p_sub_resource_tbl(table_index).assembly_item_name,
1422: FND_API.G_MISS_CHAR) <>
1423: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1424: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1425: FND_API.G_MISS_CHAR) <>
1426: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1427: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1421: IF NVL(p_sub_resource_tbl(table_index).assembly_item_name,
1422: FND_API.G_MISS_CHAR) <>
1423: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1424: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1425: FND_API.G_MISS_CHAR) <>
1426: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1427: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1428: FND_API.G_MISS_CHAR) <>
1429: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1422: FND_API.G_MISS_CHAR) <>
1423: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1424: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1425: FND_API.G_MISS_CHAR) <>
1426: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1427: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1428: FND_API.G_MISS_CHAR) <>
1429: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1430: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1424: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1425: FND_API.G_MISS_CHAR) <>
1426: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1427: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1428: FND_API.G_MISS_CHAR) <>
1429: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1430: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1431: <> 'XXXXXXXXXX'
1432: THEN
1425: FND_API.G_MISS_CHAR) <>
1426: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1427: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1428: FND_API.G_MISS_CHAR) <>
1429: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1430: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1431: <> 'XXXXXXXXXX'
1432: THEN
1433: RETURN FALSE;
1426: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1427: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1428: FND_API.G_MISS_CHAR) <>
1429: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1430: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1431: <> 'XXXXXXXXXX'
1432: THEN
1433: RETURN FALSE;
1434: END IF;
1462: record_count := p_op_network_tbl.COUNT;
1463: FOR table_index IN 1..record_count
1464: LOOP
1465: IF NVL(p_op_network_tbl(table_index).assembly_item_name,
1466: FND_API.G_MISS_CHAR) <>
1467: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1468: OR NVL(p_op_network_tbl(table_index).organization_code,
1469: FND_API.G_MISS_CHAR) <>
1470: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1463: FOR table_index IN 1..record_count
1464: LOOP
1465: IF NVL(p_op_network_tbl(table_index).assembly_item_name,
1466: FND_API.G_MISS_CHAR) <>
1467: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1468: OR NVL(p_op_network_tbl(table_index).organization_code,
1469: FND_API.G_MISS_CHAR) <>
1470: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1471: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1465: IF NVL(p_op_network_tbl(table_index).assembly_item_name,
1466: FND_API.G_MISS_CHAR) <>
1467: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1468: OR NVL(p_op_network_tbl(table_index).organization_code,
1469: FND_API.G_MISS_CHAR) <>
1470: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1471: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1472: FND_API.G_MISS_CHAR) <>
1473: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1466: FND_API.G_MISS_CHAR) <>
1467: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1468: OR NVL(p_op_network_tbl(table_index).organization_code,
1469: FND_API.G_MISS_CHAR) <>
1470: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1471: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1472: FND_API.G_MISS_CHAR) <>
1473: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1474: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1468: OR NVL(p_op_network_tbl(table_index).organization_code,
1469: FND_API.G_MISS_CHAR) <>
1470: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1471: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1472: FND_API.G_MISS_CHAR) <>
1473: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1474: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1475: <> 'XXXXXXXXXX'
1476: THEN
1469: FND_API.G_MISS_CHAR) <>
1470: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1471: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1472: FND_API.G_MISS_CHAR) <>
1473: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1474: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1475: <> 'XXXXXXXXXX'
1476: THEN
1477: RETURN FALSE;
1470: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1471: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1472: FND_API.G_MISS_CHAR) <>
1473: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1474: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1475: <> 'XXXXXXXXXX'
1476: THEN
1477: RETURN FALSE;
1478: END IF;
1518: BEGIN
1519:
1520: ---- if Routing header record exist
1521: IF (p_rtg_header_rec.assembly_item_name IS NOT NULL AND
1522: p_rtg_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR)
1523: OR
1524: (p_rtg_header_rec.organization_code IS NOT NULL AND
1525: p_rtg_header_rec.organization_code <> FND_API.G_MISS_CHAR)
1526: OR
1521: IF (p_rtg_header_rec.assembly_item_name IS NOT NULL AND
1522: p_rtg_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR)
1523: OR
1524: (p_rtg_header_rec.organization_code IS NOT NULL AND
1525: p_rtg_header_rec.organization_code <> FND_API.G_MISS_CHAR)
1526: OR
1527: (p_rtg_header_rec.alternate_routing_code IS NOT NULL AND
1528: p_rtg_header_rec.alternate_routing_code <>
1529: FND_API.G_MISS_CHAR)
1525: p_rtg_header_rec.organization_code <> FND_API.G_MISS_CHAR)
1526: OR
1527: (p_rtg_header_rec.alternate_routing_code IS NOT NULL AND
1528: p_rtg_header_rec.alternate_routing_code <>
1529: FND_API.G_MISS_CHAR)
1530: THEN
1531: l_assembly_item_name :=
1532: p_rtg_header_rec.assembly_item_name;
1533: l_organization_code :=
2136: , p_mesg_token_tbl => l_mesg_token_tbl
2137: , x_mesg_token_tbl => l_mesg_token_tbl
2138: );
2139:
2140: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2141: THEN
2142: BOM_Rtg_Globals.Set_Debug('N');
2143: END IF;
2144: END IF;
2186: RAISE G_EXC_SEV_QUIT_OBJECT;
2187: END IF;
2188:
2189: IF (l_assembly_item_name IS NULL OR
2190: l_assembly_item_name = FND_API.G_MISS_CHAR)
2191: OR
2192: (l_organization_code IS NULL OR
2193: l_organization_code = FND_API.G_MISS_CHAR)
2194: THEN
2189: IF (l_assembly_item_name IS NULL OR
2190: l_assembly_item_name = FND_API.G_MISS_CHAR)
2191: OR
2192: (l_organization_code IS NULL OR
2193: l_organization_code = FND_API.G_MISS_CHAR)
2194: THEN
2195: l_other_message := 'BOM_ASSY_OR_ORG_MISSING';
2196: RAISE G_EXC_SEV_QUIT_OBJECT;
2197: END IF;
2208: l_token_tbl(1).token_name := 'ORG_CODE';
2209: l_token_tbl(1).token_value := l_organization_code;
2210: RAISE G_EXC_SEV_QUIT_OBJECT;
2211:
2212: ELSIF l_organization_id = FND_API.G_MISS_NUM
2213: THEN
2214: l_other_message := 'BOM_UNEXP_ORG_INVALID';
2215: RAISE G_EXC_UNEXP_SKIP_OBJECT;
2216: END IF;
2236: --dbms_output.put_line('Call the Private API Process_Rtg. . .' ) ;
2237:
2238: Bom_Rtg_Pvt.Process_Rtg
2239: ( p_api_version_number => p_api_version_number
2240: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2241: , x_return_status => l_return_status
2242: , x_msg_count => x_msg_count
2243: , p_rtg_header_rec => p_rtg_header_rec
2244: , p_rtg_revision_tbl => p_rtg_revision_tbl