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.BOM_RTG_PUB dependencies on FND_API

Line 1297: FND_API.G_MISS_CHAR) <>

1293:
1294: FOR table_index IN 1..record_count
1295: LOOP
1296: IF NVL(p_rtg_revision_tbl(table_index).assembly_item_name,
1297: FND_API.G_MISS_CHAR) <>
1298: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1299: OR
1300: NVL(p_rtg_revision_tbl(table_index).organization_code,
1301: FND_API.G_MISS_CHAR) <>

Line 1298: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

1294: FOR table_index IN 1..record_count
1295: LOOP
1296: IF NVL(p_rtg_revision_tbl(table_index).assembly_item_name,
1297: FND_API.G_MISS_CHAR) <>
1298: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1299: OR
1300: NVL(p_rtg_revision_tbl(table_index).organization_code,
1301: FND_API.G_MISS_CHAR) <>
1302: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 1301: FND_API.G_MISS_CHAR) <>

1297: FND_API.G_MISS_CHAR) <>
1298: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1299: OR
1300: NVL(p_rtg_revision_tbl(table_index).organization_code,
1301: FND_API.G_MISS_CHAR) <>
1302: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1303: THEN
1304: RETURN FALSE;
1305: END IF;

Line 1302: NVL(p_organization_code, FND_API.G_MISS_CHAR)

1298: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1299: OR
1300: NVL(p_rtg_revision_tbl(table_index).organization_code,
1301: FND_API.G_MISS_CHAR) <>
1302: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1303: THEN
1304: RETURN FALSE;
1305: END IF;
1306: END LOOP;

Line 1337: FND_API.G_MISS_CHAR) <>

1333:
1334: FOR table_index IN 1..record_count
1335: LOOP
1336: IF NVL(p_operation_tbl(table_index).assembly_item_name,
1337: FND_API.G_MISS_CHAR) <>
1338: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1339: OR
1340: NVL(p_operation_tbl(table_index).organization_code,
1341: FND_API.G_MISS_CHAR) <>

Line 1338: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

1334: FOR table_index IN 1..record_count
1335: LOOP
1336: IF NVL(p_operation_tbl(table_index).assembly_item_name,
1337: FND_API.G_MISS_CHAR) <>
1338: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1339: OR
1340: NVL(p_operation_tbl(table_index).organization_code,
1341: FND_API.G_MISS_CHAR) <>
1342: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 1341: FND_API.G_MISS_CHAR) <>

1337: FND_API.G_MISS_CHAR) <>
1338: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1339: OR
1340: NVL(p_operation_tbl(table_index).organization_code,
1341: FND_API.G_MISS_CHAR) <>
1342: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1343: OR
1344: NVL(p_operation_tbl(table_index).alternate_routing_code,
1345: FND_API.G_MISS_CHAR) <>

Line 1342: NVL(p_organization_code, FND_API.G_MISS_CHAR)

1338: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1339: OR
1340: NVL(p_operation_tbl(table_index).organization_code,
1341: FND_API.G_MISS_CHAR) <>
1342: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1343: OR
1344: NVL(p_operation_tbl(table_index).alternate_routing_code,
1345: FND_API.G_MISS_CHAR) <>
1346: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

Line 1345: FND_API.G_MISS_CHAR) <>

1341: FND_API.G_MISS_CHAR) <>
1342: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1343: OR
1344: NVL(p_operation_tbl(table_index).alternate_routing_code,
1345: FND_API.G_MISS_CHAR) <>
1346: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1347: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1348: <> 'XXXXXXXXXX'
1349: THEN

Line 1346: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

1342: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1343: OR
1344: NVL(p_operation_tbl(table_index).alternate_routing_code,
1345: FND_API.G_MISS_CHAR) <>
1346: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1347: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1348: <> 'XXXXXXXXXX'
1349: THEN
1350: RETURN FALSE;

Line 1347: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

1343: OR
1344: NVL(p_operation_tbl(table_index).alternate_routing_code,
1345: FND_API.G_MISS_CHAR) <>
1346: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1347: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1348: <> 'XXXXXXXXXX'
1349: THEN
1350: RETURN FALSE;
1351: END IF;

Line 1384: FND_API.G_MISS_CHAR) <>

1380:
1381: FOR table_index IN 1..record_count
1382: LOOP
1383: IF NVL(p_op_resource_tbl (table_index).assembly_item_name,
1384: FND_API.G_MISS_CHAR) <>
1385: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1386: OR NVL(p_op_resource_tbl(table_index).organization_code,
1387: FND_API.G_MISS_CHAR) <>
1388: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 1385: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

1381: FOR table_index IN 1..record_count
1382: LOOP
1383: IF NVL(p_op_resource_tbl (table_index).assembly_item_name,
1384: FND_API.G_MISS_CHAR) <>
1385: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1386: OR NVL(p_op_resource_tbl(table_index).organization_code,
1387: FND_API.G_MISS_CHAR) <>
1388: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1389: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,

Line 1387: FND_API.G_MISS_CHAR) <>

1383: IF NVL(p_op_resource_tbl (table_index).assembly_item_name,
1384: FND_API.G_MISS_CHAR) <>
1385: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1386: OR NVL(p_op_resource_tbl(table_index).organization_code,
1387: FND_API.G_MISS_CHAR) <>
1388: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1389: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1390: FND_API.G_MISS_CHAR) <>
1391: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

Line 1388: NVL(p_organization_code, FND_API.G_MISS_CHAR)

1384: FND_API.G_MISS_CHAR) <>
1385: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1386: OR NVL(p_op_resource_tbl(table_index).organization_code,
1387: FND_API.G_MISS_CHAR) <>
1388: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1389: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1390: FND_API.G_MISS_CHAR) <>
1391: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1392: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

Line 1390: FND_API.G_MISS_CHAR) <>

1386: OR NVL(p_op_resource_tbl(table_index).organization_code,
1387: FND_API.G_MISS_CHAR) <>
1388: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1389: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1390: FND_API.G_MISS_CHAR) <>
1391: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1392: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1393: <> 'XXXXXXXXXX'
1394: THEN

Line 1391: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

1387: FND_API.G_MISS_CHAR) <>
1388: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1389: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1390: FND_API.G_MISS_CHAR) <>
1391: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1392: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1393: <> 'XXXXXXXXXX'
1394: THEN
1395: RETURN FALSE;

Line 1392: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

1388: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1389: OR NVL(p_op_resource_tbl(table_index).alternate_routing_code,
1390: FND_API.G_MISS_CHAR) <>
1391: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1392: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1393: <> 'XXXXXXXXXX'
1394: THEN
1395: RETURN FALSE;
1396: END IF;

Line 1429: FND_API.G_MISS_CHAR) <>

1425:
1426: FOR table_index IN 1..record_count
1427: LOOP
1428: IF NVL(p_sub_resource_tbl(table_index).assembly_item_name,
1429: FND_API.G_MISS_CHAR) <>
1430: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1431: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1432: FND_API.G_MISS_CHAR) <>
1433: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 1430: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

1426: FOR table_index IN 1..record_count
1427: LOOP
1428: IF NVL(p_sub_resource_tbl(table_index).assembly_item_name,
1429: FND_API.G_MISS_CHAR) <>
1430: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1431: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1432: FND_API.G_MISS_CHAR) <>
1433: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1434: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,

Line 1432: FND_API.G_MISS_CHAR) <>

1428: IF NVL(p_sub_resource_tbl(table_index).assembly_item_name,
1429: FND_API.G_MISS_CHAR) <>
1430: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1431: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1432: FND_API.G_MISS_CHAR) <>
1433: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1434: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1435: FND_API.G_MISS_CHAR) <>
1436: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

Line 1433: NVL(p_organization_code, FND_API.G_MISS_CHAR)

1429: FND_API.G_MISS_CHAR) <>
1430: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1431: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1432: FND_API.G_MISS_CHAR) <>
1433: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1434: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1435: FND_API.G_MISS_CHAR) <>
1436: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1437: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

Line 1435: FND_API.G_MISS_CHAR) <>

1431: OR NVL(p_sub_resource_tbl(table_index).organization_code,
1432: FND_API.G_MISS_CHAR) <>
1433: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1434: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1435: FND_API.G_MISS_CHAR) <>
1436: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1437: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1438: <> 'XXXXXXXXXX'
1439: THEN

Line 1436: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

1432: FND_API.G_MISS_CHAR) <>
1433: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1434: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1435: FND_API.G_MISS_CHAR) <>
1436: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1437: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1438: <> 'XXXXXXXXXX'
1439: THEN
1440: RETURN FALSE;

Line 1437: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

1433: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1434: OR NVL(p_sub_resource_tbl(table_index).alternate_routing_code,
1435: FND_API.G_MISS_CHAR) <>
1436: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1437: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1438: <> 'XXXXXXXXXX'
1439: THEN
1440: RETURN FALSE;
1441: END IF;

Line 1473: FND_API.G_MISS_CHAR) <>

1469: record_count := p_op_network_tbl.COUNT;
1470: FOR table_index IN 1..record_count
1471: LOOP
1472: IF NVL(p_op_network_tbl(table_index).assembly_item_name,
1473: FND_API.G_MISS_CHAR) <>
1474: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1475: OR NVL(p_op_network_tbl(table_index).organization_code,
1476: FND_API.G_MISS_CHAR) <>
1477: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 1474: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

1470: FOR table_index IN 1..record_count
1471: LOOP
1472: IF NVL(p_op_network_tbl(table_index).assembly_item_name,
1473: FND_API.G_MISS_CHAR) <>
1474: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1475: OR NVL(p_op_network_tbl(table_index).organization_code,
1476: FND_API.G_MISS_CHAR) <>
1477: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1478: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,

Line 1476: FND_API.G_MISS_CHAR) <>

1472: IF NVL(p_op_network_tbl(table_index).assembly_item_name,
1473: FND_API.G_MISS_CHAR) <>
1474: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1475: OR NVL(p_op_network_tbl(table_index).organization_code,
1476: FND_API.G_MISS_CHAR) <>
1477: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1478: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1479: FND_API.G_MISS_CHAR) <>
1480: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

Line 1477: NVL(p_organization_code, FND_API.G_MISS_CHAR)

1473: FND_API.G_MISS_CHAR) <>
1474: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
1475: OR NVL(p_op_network_tbl(table_index).organization_code,
1476: FND_API.G_MISS_CHAR) <>
1477: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1478: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1479: FND_API.G_MISS_CHAR) <>
1480: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1481: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

Line 1479: FND_API.G_MISS_CHAR) <>

1475: OR NVL(p_op_network_tbl(table_index).organization_code,
1476: FND_API.G_MISS_CHAR) <>
1477: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1478: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1479: FND_API.G_MISS_CHAR) <>
1480: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1481: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1482: <> 'XXXXXXXXXX'
1483: THEN

Line 1480: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

1476: FND_API.G_MISS_CHAR) <>
1477: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1478: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1479: FND_API.G_MISS_CHAR) <>
1480: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1481: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1482: <> 'XXXXXXXXXX'
1483: THEN
1484: RETURN FALSE;

Line 1481: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)

1477: NVL(p_organization_code, FND_API.G_MISS_CHAR)
1478: OR NVL(p_op_network_tbl(table_index).alternate_routing_code,
1479: FND_API.G_MISS_CHAR) <>
1480: NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1481: AND NVL(p_alternate_routing_code, FND_API.G_MISS_CHAR)
1482: <> 'XXXXXXXXXX'
1483: THEN
1484: RETURN FALSE;
1485: END IF;

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

1525: BEGIN
1526:
1527: ---- if Routing header record exist
1528: IF (p_rtg_header_rec.assembly_item_name IS NOT NULL AND
1529: p_rtg_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR)
1530: OR
1531: (p_rtg_header_rec.organization_code IS NOT NULL AND
1532: p_rtg_header_rec.organization_code <> FND_API.G_MISS_CHAR)
1533: OR

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

1528: IF (p_rtg_header_rec.assembly_item_name IS NOT NULL AND
1529: p_rtg_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR)
1530: OR
1531: (p_rtg_header_rec.organization_code IS NOT NULL AND
1532: p_rtg_header_rec.organization_code <> FND_API.G_MISS_CHAR)
1533: OR
1534: (p_rtg_header_rec.alternate_routing_code IS NOT NULL AND
1535: p_rtg_header_rec.alternate_routing_code <>
1536: FND_API.G_MISS_CHAR)

Line 1536: FND_API.G_MISS_CHAR)

1532: p_rtg_header_rec.organization_code <> FND_API.G_MISS_CHAR)
1533: OR
1534: (p_rtg_header_rec.alternate_routing_code IS NOT NULL AND
1535: p_rtg_header_rec.alternate_routing_code <>
1536: FND_API.G_MISS_CHAR)
1537: THEN
1538: l_assembly_item_name :=
1539: p_rtg_header_rec.assembly_item_name;
1540: l_organization_code :=

Line 2147: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

2143: , p_mesg_token_tbl => l_mesg_token_tbl
2144: , x_mesg_token_tbl => l_mesg_token_tbl
2145: );
2146:
2147: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2148: THEN
2149: BOM_Rtg_Globals.Set_Debug('N');
2150: END IF;
2151: END IF;

Line 2197: l_assembly_item_name = FND_API.G_MISS_CHAR)

2193: RAISE G_EXC_SEV_QUIT_OBJECT;
2194: END IF;
2195:
2196: IF (l_assembly_item_name IS NULL OR
2197: l_assembly_item_name = FND_API.G_MISS_CHAR)
2198: OR
2199: (l_organization_code IS NULL OR
2200: l_organization_code = FND_API.G_MISS_CHAR)
2201: THEN

Line 2200: l_organization_code = FND_API.G_MISS_CHAR)

2196: IF (l_assembly_item_name IS NULL OR
2197: l_assembly_item_name = FND_API.G_MISS_CHAR)
2198: OR
2199: (l_organization_code IS NULL OR
2200: l_organization_code = FND_API.G_MISS_CHAR)
2201: THEN
2202: l_other_message := 'BOM_ASSY_OR_ORG_MISSING';
2203: RAISE G_EXC_SEV_QUIT_OBJECT;
2204: END IF;

Line 2219: ELSIF l_organization_id = FND_API.G_MISS_NUM

2215: l_token_tbl(1).token_name := 'ORG_CODE';
2216: l_token_tbl(1).token_value := l_organization_code;
2217: RAISE G_EXC_SEV_QUIT_OBJECT;
2218:
2219: ELSIF l_organization_id = FND_API.G_MISS_NUM
2220: THEN
2221: l_other_message := 'BOM_UNEXP_ORG_INVALID';
2222: RAISE G_EXC_UNEXP_SKIP_OBJECT;
2223: END IF;

Line 2247: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

2243: --dbms_output.put_line('Call the Private API Process_Rtg. . .' ) ;
2244:
2245: Bom_Rtg_Pvt.Process_Rtg
2246: ( p_api_version_number => p_api_version_number
2247: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2248: , x_return_status => l_return_status
2249: , x_msg_count => x_msg_count
2250: , p_rtg_header_rec => p_rtg_header_rec
2251: , p_rtg_revision_tbl => p_rtg_revision_tbl