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 416: decode( decode(p_new_revision_label, FND_API.G_MISS_CHAR, NULL, p_new_revision_label),

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

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

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

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

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

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

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

Line 490: p_from_revision_id = FND_API.G_MISS_NUM)

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

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

704: END UPDATE_REVISION_CHANGE_NOTICE;
705:
706: PROCEDURE Query_Target_Revised_Item (
707: p_api_version IN NUMBER := 1.0
708: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
709: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
710: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711: , x_return_status OUT NOCOPY VARCHAR2
712: , x_msg_count OUT NOCOPY NUMBER

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

705:
706: PROCEDURE Query_Target_Revised_Item (
707: p_api_version IN NUMBER := 1.0
708: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
709: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
710: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711: , x_return_status OUT NOCOPY VARCHAR2
712: , x_msg_count OUT NOCOPY NUMBER
713: , x_msg_data OUT NOCOPY VARCHAR2

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

706: PROCEDURE Query_Target_Revised_Item (
707: p_api_version IN NUMBER := 1.0
708: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
709: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
710: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711: , x_return_status OUT NOCOPY VARCHAR2
712: , x_msg_count OUT NOCOPY NUMBER
713: , x_msg_data OUT NOCOPY VARCHAR2
714: , p_change_id IN NUMBER

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

763:
764: l_api_name := 'QUERY_TARGET_REVISED_ITEM';
765: l_api_version := 1.0;
766:
767: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
768: THEN
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771:

Line 769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

765: l_api_version := 1.0;
766:
767: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
768: THEN
769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771:
772: -- Initialize message list if p_init_msg_list is set to TRUE.
773: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 773: IF FND_API.to_Boolean(p_init_msg_list) THEN

769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
770: END IF;
771:
772: -- Initialize message list if p_init_msg_list is set to TRUE.
773: IF FND_API.to_Boolean(p_init_msg_list) THEN
774: FND_MSG_PUB.Initialize;
775: END IF;
776: l_return_status := 'S';
777:

Line 787: l_return_status := FND_API.G_RET_STS_ERROR;

783: CLOSE c_check_revision_id;
784:
785: IF l_dummy <> 1
786: THEN
787: l_return_status := FND_API.G_RET_STS_ERROR;
788: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
789: THEN
790: Fnd_message.set_name('ENG', 'ENG_REVISION_INVALID');
791: Fnd_msg_pub.Add;

Line 817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

813: END IF;
814: IF c_query_revised_item%ISOPEN THEN
815: CLOSE c_query_revised_item;
816: END IF;
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
821: END IF;

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

827: END Query_Target_Revised_Item;
828:
829: PROCEDURE Get_Component_Intf_Change_Dtls (
830: p_api_version IN NUMBER := 1.0
831: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
832: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
833: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: , x_return_status OUT NOCOPY VARCHAR2
835: , x_msg_count OUT NOCOPY NUMBER

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

828:
829: PROCEDURE Get_Component_Intf_Change_Dtls (
830: p_api_version IN NUMBER := 1.0
831: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
832: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
833: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: , x_return_status OUT NOCOPY VARCHAR2
835: , x_msg_count OUT NOCOPY NUMBER
836: , x_msg_data OUT NOCOPY VARCHAR2

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

829: PROCEDURE Get_Component_Intf_Change_Dtls (
830: p_api_version IN NUMBER := 1.0
831: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
832: -- , p_commit IN VARCHAR2 := FND_API.G_FALSE,
833: -- , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
834: , x_return_status OUT NOCOPY VARCHAR2
835: , x_msg_count OUT NOCOPY NUMBER
836: , x_msg_data OUT NOCOPY VARCHAR2
837: , p_change_id IN NUMBER

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

866: FROM eng_revised_items
867: WHERE revised_item_id = p_revised_item_id
868: AND (p_effectivity_date IS NULL OR scheduled_date = p_effectivity_date)
869: AND bill_sequence_id = p_bill_sequence_id
870: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)
871: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
872: AND nvl(from_end_item_rev_id, '-1')
873: = nvl(p_from_end_item_rev_id, '-1')
874: AND change_id = p_change_id

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

867: WHERE revised_item_id = p_revised_item_id
868: AND (p_effectivity_date IS NULL OR scheduled_date = p_effectivity_date)
869: AND bill_sequence_id = p_bill_sequence_id
870: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)
871: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
872: AND nvl(from_end_item_rev_id, '-1')
873: = nvl(p_from_end_item_rev_id, '-1')
874: AND change_id = p_change_id
875: AND status_type IN (1);

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

880: FROM bom_components_b
881: WHERE component_item_id = p_component_item_id
882: AND (p_effectivity_date IS NULL OR effectivity_date = p_effectivity_date)
883: AND bill_sequence_id = p_bill_sequence_id
884: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)
885: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
886: AND nvl(from_end_item_rev_id, '-1')
887: = nvl(p_from_end_item_rev_id, '-1')
888: AND change_notice = p_change_notice

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

881: WHERE component_item_id = p_component_item_id
882: AND (p_effectivity_date IS NULL OR effectivity_date = p_effectivity_date)
883: AND bill_sequence_id = p_bill_sequence_id
884: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR)
885: = nvl(p_from_end_item_unit_number, FND_API.G_MISS_CHAR)
886: AND nvl(from_end_item_rev_id, '-1')
887: = nvl(p_from_end_item_rev_id, '-1')
888: AND change_notice = p_change_notice
889: AND old_component_sequence_id = p_old_component_sequence_id

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

893:
894: l_api_name := 'GET_COMPONENT_INTF_CHANGE_DTLS';
895: l_api_version := 1.0;
896:
897: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
898: THEN
899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: END IF;
901:

Line 899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

895: l_api_version := 1.0;
896:
897: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
898: THEN
899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: END IF;
901:
902: -- Initialize message list if p_init_msg_list is set to TRUE.
903: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 903: IF FND_API.to_Boolean(p_init_msg_list) THEN

899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: END IF;
901:
902: -- Initialize message list if p_init_msg_list is set to TRUE.
903: IF FND_API.to_Boolean(p_init_msg_list) THEN
904: FND_MSG_PUB.Initialize;
905: END IF;
906: l_return_status := 'S';
907:

Line 910: l_return_status := FND_API.G_RET_STS_ERROR;

906: l_return_status := 'S';
907:
908: /* IF l_dummy <> 1
909: THEN
910: l_return_status := FND_API.G_RET_STS_ERROR;
911: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
912: THEN
913: Fnd_message.set_name('ENG', 'ENG_effectivity_details not provided INVALID');
914: Fnd_msg_pub.Add;

Line 957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

953: THEN
954: CLOSE c_query_revised_component;
955: END IF;
956:
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
959: THEN
960: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
961: END IF;

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

976: * and user access as PW already handles this.
977: *********************************************************************/
978: PROCEDURE Check_Rev_Comp_Editable (
979: p_component_sequence_id IN NUMBER
980: , x_rev_comp_editable_flag OUT NOCOPY VARCHAR2 -- FND_API.G_TRUE, FND_API.G_FALSE
981: ) IS
982: -- Cursor to check if revised component is editable
983: -- 1: revised item privilege based on profile access values
984: -- 2: revised item status check

Line 1011: x_rev_comp_editable_flag := FND_API.G_FALSE;

1007: -- 3: common bom for src pending changes
1008: AND bcb.bill_sequence_id = eri.bill_sequence_id;
1009: l_revised_item_seq_id NUMBER;
1010: BEGIN
1011: x_rev_comp_editable_flag := FND_API.G_FALSE;
1012: OPEN c_chk_rev_comp_editable;
1013: FETCH c_chk_rev_comp_editable INTO l_revised_item_seq_id;
1014: IF (c_chk_rev_comp_editable%FOUND)
1015: THEN

Line 1016: x_rev_comp_editable_flag := FND_API.G_TRUE;

1012: OPEN c_chk_rev_comp_editable;
1013: FETCH c_chk_rev_comp_editable INTO l_revised_item_seq_id;
1014: IF (c_chk_rev_comp_editable%FOUND)
1015: THEN
1016: x_rev_comp_editable_flag := FND_API.G_TRUE;
1017: END IF;
1018: CLOSE c_chk_rev_comp_editable;
1019: EXCEPTION
1020: WHEN OTHERS THEN