DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on EGO_ITEM_PUB

Line 3362: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.assign_item_to_org');

3358: FND_MSG_PUB.add;
3359: RAISE FND_API.g_exc_unexpected_error;
3360: END IF;
3361: END IF;
3362: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.assign_item_to_org');
3363: EGO_ITEM_PUB.assign_item_to_org(
3364: p_api_version => 1.0
3365: ,p_commit => FND_API.g_false
3366: ,p_Item_Number => p_item_name

Line 3363: EGO_ITEM_PUB.assign_item_to_org(

3359: RAISE FND_API.g_exc_unexpected_error;
3360: END IF;
3361: END IF;
3362: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.assign_item_to_org');
3363: EGO_ITEM_PUB.assign_item_to_org(
3364: p_api_version => 1.0
3365: ,p_commit => FND_API.g_false
3366: ,p_Item_Number => p_item_name
3367: ,p_Organization_Id => p_organization_id

Line 3371: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING EGO_ITEM_PUB.assign_item_to_org STATUS: ' || x_return_status);

3367: ,p_Organization_Id => p_organization_id
3368: ,x_return_status => x_return_status
3369: ,x_msg_count => x_msg_count
3370: );
3371: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING EGO_ITEM_PUB.assign_item_to_org STATUS: ' || x_return_status);
3372: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3373: RAISE FND_API.g_exc_unexpected_error;
3374: END IF;
3375: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

Line 3414: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING EGO_ITEM_PUB.Process_Item_Revision');

3410:
3411: --If master orgs current revision is not there in context org,create it
3412: IF(l_count = 0) THEN
3413: l_effectivity_date := l_effectivity_date + 1/86400; -- To keep efectivity date of next rev 1 sec higher than earlier rev
3414: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING EGO_ITEM_PUB.Process_Item_Revision');
3415: EGO_ITEM_PUB.Process_Item_Revision(
3416: p_api_version => 1.0
3417: ,p_init_msg_list => FND_API.g_false
3418: ,p_commit => FND_API.g_false

Line 3415: EGO_ITEM_PUB.Process_Item_Revision(

3411: --If master orgs current revision is not there in context org,create it
3412: IF(l_count = 0) THEN
3413: l_effectivity_date := l_effectivity_date + 1/86400; -- To keep efectivity date of next rev 1 sec higher than earlier rev
3414: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING EGO_ITEM_PUB.Process_Item_Revision');
3415: EGO_ITEM_PUB.Process_Item_Revision(
3416: p_api_version => 1.0
3417: ,p_init_msg_list => FND_API.g_false
3418: ,p_commit => FND_API.g_false
3419: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create

Line 3451: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING EGO_ITEM_PUB.Process_Item_Revision STATUS: '|| x_return_status);

3447: ,x_return_status => x_return_status
3448: ,x_msg_count => x_msg_count
3449: ,x_msg_data => x_msg_data
3450: ) ;
3451: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING EGO_ITEM_PUB.Process_Item_Revision STATUS: '|| x_return_status);
3452: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3453: x_msg_data := x_msg_data || ' -> Item Number:' || p_item_name || ' -> Org Id: ' || p_organization_id;
3454: RAISE FND_API.g_exc_unexpected_error;
3455: END IF;

Line 4170: l_item_org_assignment_rec EGO_ITEM_PUB.item_org_assignment_rec_type;

4166: l_change_line_tbl ENG_ECO_PUB.change_line_tbl_type;
4167: l_revision VARCHAR2(3);
4168: l_is_component_item_exists VARCHAR2(3);
4169: l_api_version NUMBER:=1.0;
4170: l_item_org_assignment_rec EGO_ITEM_PUB.item_org_assignment_rec_type;
4171: l_item_org_assignment_tbl EGO_ITEM_PUB.item_org_assignment_tbl_type;
4172: l_inventory_item_id NUMBER;
4173: l_organization_id NUMBER;
4174: l_component_item_name VARCHAR2(240);

Line 4171: l_item_org_assignment_tbl EGO_ITEM_PUB.item_org_assignment_tbl_type;

4167: l_revision VARCHAR2(3);
4168: l_is_component_item_exists VARCHAR2(3);
4169: l_api_version NUMBER:=1.0;
4170: l_item_org_assignment_rec EGO_ITEM_PUB.item_org_assignment_rec_type;
4171: l_item_org_assignment_tbl EGO_ITEM_PUB.item_org_assignment_tbl_type;
4172: l_inventory_item_id NUMBER;
4173: l_organization_id NUMBER;
4174: l_component_item_name VARCHAR2(240);
4175: l_master_org NUMBER;