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

Line 414: decode( decode(p_new_revision_label, FND_API.G_MISS_CHAR, NULL, p_new_revision_label),

410: values (x_inventory_item_id,
411: x_organization_id,
412: x_revision,
413: --x_revision,
414: decode( decode(p_new_revision_label, FND_API.G_MISS_CHAR, NULL, p_new_revision_label),
415: NULL, x_revision, p_new_revision_label),
416: sysdate,
417: x_userid,
418: sysdate,

Line 427: decode(x_revision_description,FND_API.G_MISS_CHAR,NULL,x_revision_description),

423: decode(x_scheduled_date, trunc(sysdate), sysdate, x_scheduled_date),
424: x_revised_item_sequence_id,
425: mtl_item_revisions_b_s.NEXTVAL,
426: 1,
427: decode(x_revision_description,FND_API.G_MISS_CHAR,NULL,x_revision_description),
428: decode(p_new_revision_reason_code, FND_API.G_MISS_CHAR, NULL, p_new_revision_reason_code)
429: )RETURNING revision_id INTO l_revision_id;
430:
431: SELECT userenv('LANG') INTO l_language_code FROM dual;

Line 428: decode(p_new_revision_reason_code, FND_API.G_MISS_CHAR, NULL, p_new_revision_reason_code)

424: x_revised_item_sequence_id,
425: mtl_item_revisions_b_s.NEXTVAL,
426: 1,
427: decode(x_revision_description,FND_API.G_MISS_CHAR,NULL,x_revision_description),
428: decode(p_new_revision_reason_code, FND_API.G_MISS_CHAR, NULL, p_new_revision_reason_code)
429: )RETURNING revision_id INTO l_revision_id;
430:
431: SELECT userenv('LANG') INTO l_language_code FROM dual;
432: -- description is stored in MTL_ITEM_REVISIONS_TL

Line 456: decode(x_revision_description,FND_API.G_MISS_CHAR,NULL,x_revision_description)

452: sysdate,
453: x_userid,
454: x_userid,
455: /* Item revision description support for ECO Bug: 1667419 */
456: decode(x_revision_description,FND_API.G_MISS_CHAR,NULL,x_revision_description)
457: FROM FND_LANGUAGES lang
458: where lang.INSTALLED_FLAG in ('I', 'B')
459: and not exists
460: (select NULL

Line 488: p_from_revision_id = FND_API.G_MISS_NUM)

484: --11.5.10E
485: -- Fetching the from revision, if it is null, then fetching the
486: -- current revision
487: IF (p_from_revision_id is NULL OR
488: p_from_revision_id = FND_API.G_MISS_NUM)
489: THEN
490: l_curr_rev_id := bom_revisions.GET_ITEM_REVISION_ID_FN(
491: examine_type => 'IMPL_ONLY'
492: , org_id => x_organization_id

Line 685: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

681: END UPDATE_REVISION_CHANGE_NOTICE;
682:
683: PROCEDURE Query_Target_Revised_Item (
684: p_api_version IN NUMBER := 1.0
685: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
686: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
687: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
688: , x_return_status OUT NOCOPY VARCHAR2
689: , x_msg_count OUT NOCOPY NUMBER

Line 686: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,

682:
683: PROCEDURE Query_Target_Revised_Item (
684: p_api_version IN NUMBER := 1.0
685: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
686: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
687: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
688: , x_return_status OUT NOCOPY VARCHAR2
689: , x_msg_count OUT NOCOPY NUMBER
690: , x_msg_data OUT NOCOPY VARCHAR2

Line 687: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

683: PROCEDURE Query_Target_Revised_Item (
684: p_api_version IN NUMBER := 1.0
685: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
686: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
687: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
688: , x_return_status OUT NOCOPY VARCHAR2
689: , x_msg_count OUT NOCOPY NUMBER
690: , x_msg_data OUT NOCOPY VARCHAR2
691: , p_change_id IN NUMBER

Line 744: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

740:
741: l_api_name := 'QUERY_TARGET_REVISED_ITEM';
742: l_api_version := 1.0;
743:
744: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
745: THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:

Line 746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

742: l_api_version := 1.0;
743:
744: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
745: THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749: -- Initialize message list if p_init_msg_list is set to TRUE.
750: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 750: IF FND_API.to_Boolean(p_init_msg_list) THEN

746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749: -- Initialize message list if p_init_msg_list is set to TRUE.
750: IF FND_API.to_Boolean(p_init_msg_list) THEN
751: FND_MSG_PUB.Initialize;
752: END IF;
753: l_return_status := 'S';
754:

Line 764: l_return_status := FND_API.G_RET_STS_ERROR;

760: CLOSE c_check_revision_id;
761:
762: IF l_dummy <> 1
763: THEN
764: l_return_status := FND_API.G_RET_STS_ERROR;
765: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
766: THEN
767: Fnd_message.set_name('ENG', 'ENG_REVISION_INVALID');
768: Fnd_msg_pub.Add;

Line 794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

790: END IF;
791: IF c_query_revised_item%ISOPEN THEN
792: CLOSE c_query_revised_item;
793: END IF;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
796: THEN
797: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
798: END IF;

Line 808: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

804: END Query_Target_Revised_Item;
805:
806: PROCEDURE Get_Component_Intf_Change_Dtls (
807: p_api_version IN NUMBER := 1.0
808: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
809: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
810: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
811: , x_return_status OUT NOCOPY VARCHAR2
812: , x_msg_count OUT NOCOPY NUMBER

Line 809: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,

805:
806: PROCEDURE Get_Component_Intf_Change_Dtls (
807: p_api_version IN NUMBER := 1.0
808: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
809: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
810: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
811: , x_return_status OUT NOCOPY VARCHAR2
812: , x_msg_count OUT NOCOPY NUMBER
813: , x_msg_data OUT NOCOPY VARCHAR2

Line 810: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

806: PROCEDURE Get_Component_Intf_Change_Dtls (
807: p_api_version IN NUMBER := 1.0
808: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
809: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
810: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
811: , x_return_status OUT NOCOPY VARCHAR2
812: , x_msg_count OUT NOCOPY NUMBER
813: , x_msg_data OUT NOCOPY VARCHAR2
814: , p_change_id IN NUMBER

Line 847: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)

843: FROM eng_revised_items
844: WHERE revised_item_id = p_revised_item_id
845: AND (p_effectivity_date IS NULL OR scheduled_date = p_effectivity_date)
846: AND bill_sequence_id = p_bill_sequence_id
847: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)
848: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
849: AND nvl(from_end_item_rev_id, '-1')
850: = nvl(p_from_end_item_rev_id, '-1')
851: AND change_id = p_change_id

Line 848: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)

844: WHERE revised_item_id = p_revised_item_id
845: AND (p_effectivity_date IS NULL OR scheduled_date = p_effectivity_date)
846: AND bill_sequence_id = p_bill_sequence_id
847: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)
848: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
849: AND nvl(from_end_item_rev_id, '-1')
850: = nvl(p_from_end_item_rev_id, '-1')
851: AND change_id = p_change_id
852: AND status_type IN (1);

Line 861: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)

857: FROM bom_components_b
858: WHERE component_item_id = p_component_item_id
859: AND (p_effectivity_date IS NULL OR effectivity_date = p_effectivity_date)
860: AND bill_sequence_id = p_bill_sequence_id
861: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)
862: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
863: AND nvl(from_end_item_rev_id, '-1')
864: = nvl(p_from_end_item_rev_id, '-1')
865: AND change_notice = p_change_notice

Line 862: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)

858: WHERE component_item_id = p_component_item_id
859: AND (p_effectivity_date IS NULL OR effectivity_date = p_effectivity_date)
860: AND bill_sequence_id = p_bill_sequence_id
861: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)
862: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
863: AND nvl(from_end_item_rev_id, '-1')
864: = nvl(p_from_end_item_rev_id, '-1')
865: AND change_notice = p_change_notice
866: AND old_component_sequence_id = p_old_component_sequence_id

Line 874: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

870:
871: l_api_name := 'GET_COMPONENT_INTF_CHANGE_DTLS';
872: l_api_version := 1.0;
873:
874: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
875: THEN
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:

Line 876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

872: l_api_version := 1.0;
873:
874: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
875: THEN
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 880: IF FND_API.to_Boolean(p_init_msg_list) THEN

876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: END IF;
878:
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean(p_init_msg_list) THEN
881: FND_MSG_PUB.Initialize;
882: END IF;
883: l_return_status := 'S';
884:

Line 887: l_return_status := FND_API.G_RET_STS_ERROR;

883: l_return_status := 'S';
884:
885: /* IF l_dummy <> 1
886: THEN
887: l_return_status := FND_API.G_RET_STS_ERROR;
888: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
889: THEN
890: Fnd_message.set_name('ENG', 'ENG_effectivity_details not provided INVALID');
891: Fnd_msg_pub.Add;

Line 934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

930: THEN
931: CLOSE c_query_revised_component;
932: END IF;
933:
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
936: THEN
937: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
938: END IF;

Line 957: , x_rev_comp_editable_flag OUT NOCOPY VARCHAR2 -- FND_API.G_TRUE, FND_API.G_FALSE

953: * and user access as PW already handles this.
954: *********************************************************************/
955: PROCEDURE Check_Rev_Comp_Editable (
956: p_component_sequence_id IN NUMBER
957: , x_rev_comp_editable_flag OUT NOCOPY VARCHAR2 -- FND_API.G_TRUE, FND_API.G_FALSE
958: ) IS
959: -- Cursor to check if revised component is editable
960: -- 1: revised item privilege based on profile access values
961: -- 2: revised item status check

Line 988: x_rev_comp_editable_flag := FND_API.G_FALSE;

984: -- 3: common bom for src pending changes
985: AND bcb.bill_sequence_id = eri.bill_sequence_id;
986: l_revised_item_seq_id NUMBER;
987: BEGIN
988: x_rev_comp_editable_flag := FND_API.G_FALSE;
989: OPEN c_chk_rev_comp_editable;
990: FETCH c_chk_rev_comp_editable INTO l_revised_item_seq_id;
991: IF (c_chk_rev_comp_editable%FOUND)
992: THEN

Line 993: x_rev_comp_editable_flag := FND_API.G_TRUE;

989: OPEN c_chk_rev_comp_editable;
990: FETCH c_chk_rev_comp_editable INTO l_revised_item_seq_id;
991: IF (c_chk_rev_comp_editable%FOUND)
992: THEN
993: x_rev_comp_editable_flag := FND_API.G_TRUE;
994: END IF;
995: CLOSE c_chk_rev_comp_editable;
996: EXCEPTION
997: WHEN OTHERS THEN