DBA Data[Home] [Help]

APPS.BOM_RTG_PUB dependencies on FND_API

Line 1290: FND_API.G_MISS_CHAR) <>

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) <>

Line 1291: NVL(p_assembly_item_name, 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)

Line 1294: 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;

Line 1295: NVL(p_organization_code, 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;
1299: END LOOP;

Line 1330: FND_API.G_MISS_CHAR) <>

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) <>

Line 1331: NVL(p_assembly_item_name, 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)

Line 1334: 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) <>

Line 1335: NVL(p_organization_code, 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)

Line 1338: 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

Line 1339: NVL(p_alternate_routing_code, 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
1343: RETURN FALSE;

Line 1340: AND NVL(p_alternate_routing_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;
1344: END IF;

Line 1377: FND_API.G_MISS_CHAR) <>

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)

Line 1378: NVL(p_assembly_item_name, 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,

Line 1380: FND_API.G_MISS_CHAR) <>

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)

Line 1381: NVL(p_organization_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)

Line 1383: 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

Line 1384: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

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;

Line 1385: AND NVL(p_alternate_routing_code, 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;
1389: END IF;

Line 1422: FND_API.G_MISS_CHAR) <>

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)

Line 1423: NVL(p_assembly_item_name, 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,

Line 1425: FND_API.G_MISS_CHAR) <>

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)

Line 1426: NVL(p_organization_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)

Line 1428: 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

Line 1429: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

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;

Line 1430: AND NVL(p_alternate_routing_code, 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;
1434: END IF;

Line 1466: FND_API.G_MISS_CHAR) <>

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)

Line 1467: NVL(p_assembly_item_name, 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,

Line 1469: FND_API.G_MISS_CHAR) <>

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)

Line 1470: NVL(p_organization_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)

Line 1472: 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

Line 1473: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

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;

Line 1474: AND NVL(p_alternate_routing_code, 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;
1478: END IF;

Line 1522: p_rtg_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR)

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

Line 1525: p_rtg_header_rec.organization_code <> FND_API.G_MISS_CHAR)

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)

Line 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 :=

Line 2140: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

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;

Line 2190: l_assembly_item_name = FND_API.G_MISS_CHAR)

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

Line 2193: l_organization_code = FND_API.G_MISS_CHAR)

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;

Line 2212: ELSIF l_organization_id = FND_API.G_MISS_NUM

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;

Line 2240: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

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