DBA Data[Home] [Help]

APPS.BOM_BO_PUB dependencies on FND_API

Line 795: FND_API.G_MISS_CHAR) <>

791:
792: FOR table_index IN 1..record_count
793: LOOP
794: IF NVL(p_bom_revision_tbl(table_index).assembly_item_name,
795: FND_API.G_MISS_CHAR) <>
796: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
797: OR
798: NVL(p_bom_revision_tbl(table_index).organization_code,
799: FND_API.G_MISS_CHAR) <>

Line 796: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

792: FOR table_index IN 1..record_count
793: LOOP
794: IF NVL(p_bom_revision_tbl(table_index).assembly_item_name,
795: FND_API.G_MISS_CHAR) <>
796: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
797: OR
798: NVL(p_bom_revision_tbl(table_index).organization_code,
799: FND_API.G_MISS_CHAR) <>
800: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 799: FND_API.G_MISS_CHAR) <>

795: FND_API.G_MISS_CHAR) <>
796: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
797: OR
798: NVL(p_bom_revision_tbl(table_index).organization_code,
799: FND_API.G_MISS_CHAR) <>
800: NVL(p_organization_code, FND_API.G_MISS_CHAR)
801: THEN
802: RETURN FALSE;
803: END IF;

Line 800: NVL(p_organization_code, FND_API.G_MISS_CHAR)

796: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
797: OR
798: NVL(p_bom_revision_tbl(table_index).organization_code,
799: FND_API.G_MISS_CHAR) <>
800: NVL(p_organization_code, FND_API.G_MISS_CHAR)
801: THEN
802: RETURN FALSE;
803: END IF;
804: END LOOP;

Line 823: IF NVL(p_bom_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>

819: record_count := p_bom_component_tbl.COUNT;
820:
821: FOR table_index IN 1..record_count
822: LOOP
823: IF NVL(p_bom_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
824: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
825: OR
826: NVL(p_bom_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
827: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 824: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

820:
821: FOR table_index IN 1..record_count
822: LOOP
823: IF NVL(p_bom_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
824: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
825: OR
826: NVL(p_bom_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
827: NVL(p_organization_code, FND_API.G_MISS_CHAR)
828: THEN

Line 826: NVL(p_bom_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>

822: LOOP
823: IF NVL(p_bom_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
824: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
825: OR
826: NVL(p_bom_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
827: NVL(p_organization_code, FND_API.G_MISS_CHAR)
828: THEN
829: RETURN FALSE;
830: END IF;

Line 827: NVL(p_organization_code, FND_API.G_MISS_CHAR)

823: IF NVL(p_bom_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
824: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
825: OR
826: NVL(p_bom_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
827: NVL(p_organization_code, FND_API.G_MISS_CHAR)
828: THEN
829: RETURN FALSE;
830: END IF;
831: END LOOP;

Line 850: IF NVL(p_bom_ref_designator_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>

846: record_count := p_bom_ref_designator_tbl.COUNT;
847:
848: FOR table_index IN 1..record_count
849: LOOP
850: IF NVL(p_bom_ref_designator_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
851: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
852: OR
853: NVL(p_bom_ref_designator_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
854: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 851: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

847:
848: FOR table_index IN 1..record_count
849: LOOP
850: IF NVL(p_bom_ref_designator_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
851: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
852: OR
853: NVL(p_bom_ref_designator_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
854: NVL(p_organization_code, FND_API.G_MISS_CHAR)
855: THEN

Line 853: NVL(p_bom_ref_designator_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>

849: LOOP
850: IF NVL(p_bom_ref_designator_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
851: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
852: OR
853: NVL(p_bom_ref_designator_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
854: NVL(p_organization_code, FND_API.G_MISS_CHAR)
855: THEN
856: RETURN FALSE;
857: END IF;

Line 854: NVL(p_organization_code, FND_API.G_MISS_CHAR)

850: IF NVL(p_bom_ref_designator_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
851: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
852: OR
853: NVL(p_bom_ref_designator_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
854: NVL(p_organization_code, FND_API.G_MISS_CHAR)
855: THEN
856: RETURN FALSE;
857: END IF;
858: END LOOP;

Line 883: IF NVL(p_bom_sub_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>

879: p_organization_code || ' processing records ' || p_bom_sub_component_tbl.COUNT);
880: end if;
881: FOR table_index IN 1..record_count
882: LOOP
883: IF NVL(p_bom_sub_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
884: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
885: OR
886: NVL(p_bom_sub_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
887: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 884: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

880: end if;
881: FOR table_index IN 1..record_count
882: LOOP
883: IF NVL(p_bom_sub_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
884: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
885: OR
886: NVL(p_bom_sub_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
887: NVL(p_organization_code, FND_API.G_MISS_CHAR)
888: THEN

Line 886: NVL(p_bom_sub_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>

882: LOOP
883: IF NVL(p_bom_sub_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
884: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
885: OR
886: NVL(p_bom_sub_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
887: NVL(p_organization_code, FND_API.G_MISS_CHAR)
888: THEN
889: RETURN FALSE;
890: END IF;

Line 887: NVL(p_organization_code, FND_API.G_MISS_CHAR)

883: IF NVL(p_bom_sub_component_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
884: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
885: OR
886: NVL(p_bom_sub_component_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
887: NVL(p_organization_code, FND_API.G_MISS_CHAR)
888: THEN
889: RETURN FALSE;
890: END IF;
891: END LOOP;

Line 916: IF NVL(p_bom_comp_ops_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>

912: p_organization_code || ' processing records ' || record_count);
913: end if;
914: FOR table_index IN 1..record_count
915: LOOP
916: IF NVL(p_bom_comp_ops_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
917: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
918: OR
919: NVL(p_bom_comp_ops_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
920: NVL(p_organization_code, FND_API.G_MISS_CHAR)

Line 917: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)

913: end if;
914: FOR table_index IN 1..record_count
915: LOOP
916: IF NVL(p_bom_comp_ops_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
917: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
918: OR
919: NVL(p_bom_comp_ops_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
920: NVL(p_organization_code, FND_API.G_MISS_CHAR)
921: THEN

Line 919: NVL(p_bom_comp_ops_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>

915: LOOP
916: IF NVL(p_bom_comp_ops_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
917: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
918: OR
919: NVL(p_bom_comp_ops_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
920: NVL(p_organization_code, FND_API.G_MISS_CHAR)
921: THEN
922: RETURN FALSE;
923: END IF;

Line 920: NVL(p_organization_code, FND_API.G_MISS_CHAR)

916: IF NVL(p_bom_comp_ops_tbl(table_index).assembly_item_name, FND_API.G_MISS_CHAR) <>
917: NVL(p_assembly_item_name, FND_API.G_MISS_CHAR)
918: OR
919: NVL(p_bom_comp_ops_tbl(table_index).organization_code, FND_API.G_MISS_CHAR) <>
920: NVL(p_organization_code, FND_API.G_MISS_CHAR)
921: THEN
922: RETURN FALSE;
923: END IF;
924: END LOOP;

Line 955: p_bom_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR)

951: l_assembly_item_name VARCHAR2(240);
952: record_count NUMBER;
953: BEGIN
954: IF (p_bom_header_rec.assembly_item_name IS NOT NULL AND
955: p_bom_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR)
956: OR
957: (p_bom_header_rec.organization_code IS NOT NULL AND
958: p_bom_header_rec.organization_code <> FND_API.G_MISS_CHAR)
959: THEN

Line 958: p_bom_header_rec.organization_code <> FND_API.G_MISS_CHAR)

954: IF (p_bom_header_rec.assembly_item_name IS NOT NULL AND
955: p_bom_header_rec.assembly_item_name <> FND_API.G_MISS_CHAR)
956: OR
957: (p_bom_header_rec.organization_code IS NOT NULL AND
958: p_bom_header_rec.organization_code <> FND_API.G_MISS_CHAR)
959: THEN
960: l_assembly_item_name :=
961: p_bom_header_rec.assembly_item_name;
962: l_organization_code :=

Line 1431: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

1427: , p_mesg_token_tbl => l_mesg_token_tbl
1428: , x_mesg_token_tbl => l_mesg_token_tbl
1429: );
1430:
1431: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
1432: THEN
1433: BOM_Globals.Set_Debug('N');
1434: END IF;
1435: END IF;

Line 1484: l_assembly_item_name = FND_API.G_MISS_CHAR)

1480: RAISE G_EXC_SEV_QUIT_OBJECT;
1481: END IF;
1482:
1483: IF (l_assembly_item_name IS NULL OR
1484: l_assembly_item_name = FND_API.G_MISS_CHAR)
1485: OR
1486: (l_organization_code IS NULL OR
1487: l_organization_code = FND_API.G_MISS_CHAR)
1488: THEN

Line 1487: l_organization_code = FND_API.G_MISS_CHAR)

1483: IF (l_assembly_item_name IS NULL OR
1484: l_assembly_item_name = FND_API.G_MISS_CHAR)
1485: OR
1486: (l_organization_code IS NULL OR
1487: l_organization_code = FND_API.G_MISS_CHAR)
1488: THEN
1489: l_other_message := 'BOM_ASSY_OR_ORG_MISSING';
1490: RAISE G_EXC_SEV_QUIT_OBJECT;
1491: END IF;

Line 1506: ELSIF l_organization_id = FND_API.G_MISS_NUM

1502: l_token_tbl(1).token_name := 'ORG_CODE';
1503: l_token_tbl(1).token_value := l_organization_code;
1504: RAISE G_EXC_SEV_QUIT_OBJECT;
1505:
1506: ELSIF l_organization_id = FND_API.G_MISS_NUM
1507: THEN
1508: l_other_message := 'BOM_UNEXP_ORG_INVALID';
1509: RAISE G_EXC_UNEXP_SKIP_OBJECT;
1510: END IF;

Line 1960: l_bomheaders_tbl(hdrRec).return_status = FND_API.G_MISS_CHAR

1956:
1957: FOR hdrRec IN 1..l_hdrcount
1958: LOOP
1959: IF l_bomheaders_tbl(hdrRec).return_status IS NULL OR
1960: l_bomheaders_tbl(hdrRec).return_status = FND_API.G_MISS_CHAR
1961: THEN
1962: l_assembly_item_name := l_bomheaders_tbl(hdrRec).assembly_item_name;
1963: l_organization_code := l_bomheaders_tbl(hdrRec).organization_code;
1964: l_alternate_bom_code := l_bomheaders_tbl(hdrRec).alternate_bom_code;

Line 2049: l_bomrevisions_tbl(revRec).return_status = FND_API.G_MISS_CHAR

2045: FOR revRec IN 1..l_revcount
2046: LOOP
2047:
2048: IF l_bomrevisions_tbl(revRec).return_status IS NULL OR
2049: l_bomrevisions_tbl(revRec).return_status = FND_API.G_MISS_CHAR
2050: THEN
2051:
2052: IF (l_assembly_item_name IS NULL) OR
2053: (l_assembly_item_name IS NOT NULL AND

Line 2146: l_bomcomponents_tbl(compRec).return_status = FND_API.G_MISS_CHAR

2142: FOR compRec IN 1..l_compcount
2143: LOOP
2144:
2145: IF l_bomcomponents_tbl(compRec).return_status IS NULL OR
2146: l_bomcomponents_tbl(compRec).return_status = FND_API.G_MISS_CHAR
2147: THEN
2148:
2149: IF (l_assembly_item_name IS NULL) OR
2150: (l_assembly_item_name IS NOT NULL AND

Line 2305: l_bomsubcomponents_tbl(scompRec).return_status = FND_API.G_MISS_CHAR

2301: FOR scompRec IN 1..l_subcompcount
2302: LOOP
2303:
2304: IF l_bomsubcomponents_tbl(scompRec).return_status IS NULL OR
2305: l_bomsubcomponents_tbl(scompRec).return_status = FND_API.G_MISS_CHAR
2306: THEN
2307:
2308: IF (l_assembly_item_name IS NULL) OR
2309: (l_assembly_item_name IS NOT NULL AND

Line 2410: l_bomrefdesignators_tbl(rdesRec).return_status = FND_API.G_MISS_CHAR

2406: FOR rdesRec IN 1..l_refdescount
2407: LOOP
2408:
2409: IF l_bomrefdesignators_tbl(rdesRec).return_status IS NULL OR
2410: l_bomrefdesignators_tbl(rdesRec).return_status = FND_API.G_MISS_CHAR
2411: THEN
2412:
2413: IF (l_assembly_item_name IS NULL) OR
2414: (l_assembly_item_name IS NOT NULL AND

Line 2515: l_bomcompoperations_tbl(copsRec).return_status = FND_API.G_MISS_CHAR

2511: FOR copsRec IN 1..l_compopscount
2512: LOOP
2513:
2514: IF l_bomcompoperations_tbl(copsRec).return_status IS NULL OR
2515: l_bomcompoperations_tbl(copsRec).return_status = FND_API.G_MISS_CHAR
2516: THEN
2517:
2518: IF (l_assembly_item_name IS NULL) OR
2519: (l_assembly_item_name IS NOT NULL AND

Line 3703: l_input_bomheader_rec.assembly_item_name <> FND_API.G_MISS_CHAR)

3699:
3700: BEGIN
3701:
3702: IF (l_input_bomheader_rec.assembly_item_name IS NOT NULL AND
3703: l_input_bomheader_rec.assembly_item_name <> FND_API.G_MISS_CHAR)
3704: OR
3705: (l_input_bomheader_rec.organization_code IS NOT NULL AND
3706: l_input_bomheader_rec.organization_code <> FND_API.G_MISS_CHAR)
3707: THEN

Line 3706: l_input_bomheader_rec.organization_code <> FND_API.G_MISS_CHAR)

3702: IF (l_input_bomheader_rec.assembly_item_name IS NOT NULL AND
3703: l_input_bomheader_rec.assembly_item_name <> FND_API.G_MISS_CHAR)
3704: OR
3705: (l_input_bomheader_rec.organization_code IS NOT NULL AND
3706: l_input_bomheader_rec.organization_code <> FND_API.G_MISS_CHAR)
3707: THEN
3708: l_bom_header_rec.Assembly_item_name := l_input_bomheader_rec.Assembly_item_name ;
3709: l_bom_header_rec.Organization_Code := l_input_bomheader_rec.Organization_Code;
3710: l_bom_header_rec.Alternate_Bom_Code := NULL;

Line 3772: l_input_bomcomponents_tbl(compRec).return_status = FND_API.G_MISS_CHAR

3768: IF (l_compcount > 0) THEN
3769: FOR compRec in 1.. l_compcount
3770: LOOP
3771: IF l_input_bomcomponents_tbl(compRec).return_status IS NULL OR
3772: l_input_bomcomponents_tbl(compRec).return_status = FND_API.G_MISS_CHAR
3773: THEN
3774: l_bom_component_tbl(compRec).Organization_Code :=
3775: l_input_bomcomponents_tbl(compRec).Organization_Code ;
3776: l_bom_component_tbl(compRec).Assembly_Item_Name :=