DBA Data[Home] [Help]

APPS.INV_EBI_ITEM_HELPER dependencies on EGO_ITEM_PUB

Line 1368: EGO_ITEM_PUB.Process_Item_Revision(

1364: l_effectivity_date := SYSDATE;
1365: ELSE
1366: l_effectivity_date := l_item.main_obj_type.effectivity_date;
1367: END IF;
1368: EGO_ITEM_PUB.Process_Item_Revision(
1369: p_api_version => 1.0
1370: ,p_init_msg_list => FND_API.g_false
1371: ,p_commit => FND_API.g_false
1372: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create

Line 1413: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item ');

1409: END IF; -- Bug 7412466
1410: END IF; -- End of Bug 7601514
1411: END IF;
1412:
1413: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item ');
1414: EGO_ITEM_PUB.process_item(
1415: p_api_version => 1.0
1416: ,p_init_msg_list => l_item.main_obj_type.init_msg_list
1417: ,p_commit => FND_API.g_false

Line 1414: EGO_ITEM_PUB.process_item(

1410: END IF; -- End of Bug 7601514
1411: END IF;
1412:
1413: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item ');
1414: EGO_ITEM_PUB.process_item(
1415: p_api_version => 1.0
1416: ,p_init_msg_list => l_item.main_obj_type.init_msg_list
1417: ,p_commit => FND_API.g_false
1418: ,p_transaction_type => l_transaction_type

Line 1836: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item ');

1832: ,p_repair_program => l_item.mrp_obj_type.repair_program
1833: ,p_subcontracting_component => l_item.gplanning_obj_type.subcontracting_component
1834: ,p_outsourced_assembly => l_item.purchasing_obj_type.outsourced_assembly
1835: );
1836: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item ');
1837:
1838: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
1839: RAISE FND_API.g_exc_unexpected_error;
1840: END IF;

Line 2025: EGO_ITEM_PUB.process_user_attrs_for_item(

2021: ,p_transaction_type => l_transaction_type
2022: );
2023: l_attributes_row_table(i) := l_attributes_row_obj;
2024: END LOOP;
2025: EGO_ITEM_PUB.process_user_attrs_for_item(
2026: p_api_version => p_api_version
2027: ,p_inventory_item_id => p_inventory_item_id
2028: ,p_organization_id => p_organization_id
2029: ,p_attributes_row_table => l_attributes_row_table

Line 2098: l_item_org_assignment_rec ego_item_pub.item_org_assignment_rec_type;

2094: ,p_org_id_tbl IN inv_ebi_org_tbl
2095: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2096: )
2097: IS
2098: l_item_org_assignment_rec ego_item_pub.item_org_assignment_rec_type;
2099: l_item_org_assignment_tbl ego_item_pub.item_org_assignment_tbl_type;
2100: l_output_status inv_ebi_output_status;
2101: l_api_version NUMBER:=1.0;
2102: l_item_org_tbl_count NUMBER := 1;

Line 2099: l_item_org_assignment_tbl ego_item_pub.item_org_assignment_tbl_type;

2095: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2096: )
2097: IS
2098: l_item_org_assignment_rec ego_item_pub.item_org_assignment_rec_type;
2099: l_item_org_assignment_tbl ego_item_pub.item_org_assignment_tbl_type;
2100: l_output_status inv_ebi_output_status;
2101: l_api_version NUMBER:=1.0;
2102: l_item_org_tbl_count NUMBER := 1;
2103: BEGIN

Line 2115: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_org_assignments ');

2111: l_item_org_assignment_rec.item_number := p_item_number;
2112: l_item_org_assignment_rec.organization_id := p_org_id_tbl(i).org_id;
2113: l_item_org_assignment_tbl(i) := l_item_org_assignment_rec;
2114: END LOOP;
2115: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2116: EGO_ITEM_PUB.process_item_org_assignments(
2117: p_api_version => l_api_version --don't pass as of now
2118: ,p_init_msg_list => p_init_msg_list
2119: ,p_commit => FND_API.g_false

Line 2116: EGO_ITEM_PUB.process_item_org_assignments(

2112: l_item_org_assignment_rec.organization_id := p_org_id_tbl(i).org_id;
2113: l_item_org_assignment_tbl(i) := l_item_org_assignment_rec;
2114: END LOOP;
2115: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2116: EGO_ITEM_PUB.process_item_org_assignments(
2117: p_api_version => l_api_version --don't pass as of now
2118: ,p_init_msg_list => p_init_msg_list
2119: ,p_commit => FND_API.g_false
2120: ,p_item_org_assignment_tbl => l_item_org_assignment_tbl

Line 2124: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_org_assignments ');

2120: ,p_item_org_assignment_tbl => l_item_org_assignment_tbl
2121: ,x_return_status => x_out.output_status.return_status
2122: ,x_msg_count => x_out.output_status.msg_count
2123: );
2124: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_org_assignments ');
2125: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2126: RAISE FND_API.g_exc_unexpected_error;
2127: END IF;
2128: END IF;

Line 2169: l_transaction_type VARCHAR2(20):=ego_item_pub.g_ttype_create;

2165: ,p_category_id_tbl IN inv_ebi_category_obj_tbl_type
2166: ,x_out OUT NOCOPY inv_ebi_item_output_obj
2167: )
2168: IS
2169: l_transaction_type VARCHAR2(20):=ego_item_pub.g_ttype_create;
2170: l_category_output inv_ebi_category_output_obj;
2171: l_output_status inv_ebi_output_status;
2172: BEGIN
2173: SAVEPOINT inv_ebi_cat_id_save_pnt;

Line 2178: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_cat_assignment ');

2174: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_category_assignments ');
2175: l_category_output := inv_ebi_category_output_obj(NULL);
2176: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2177: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL);
2178: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2179: FOR i IN 1..p_category_id_tbl.COUNT LOOP
2180: EGO_ITEM_PUB.process_item_cat_assignment(
2181: p_api_version => p_api_version
2182: ,p_init_msg_list => p_init_msg_list

Line 2180: EGO_ITEM_PUB.process_item_cat_assignment(

2176: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2177: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_category_output,NULL,NULL,NULL);
2178: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2179: FOR i IN 1..p_category_id_tbl.COUNT LOOP
2180: EGO_ITEM_PUB.process_item_cat_assignment(
2181: p_api_version => p_api_version
2182: ,p_init_msg_list => p_init_msg_list
2183: ,p_commit => FND_API.g_false
2184: ,p_category_id => p_category_id_tbl(i).cat_id

Line 2195: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_cat_assignment ');

2191: ,x_msg_count => x_out.output_status.msg_count
2192: ,x_msg_data => x_out.output_status.msg_data
2193: );
2194: END LOOP;
2195: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING EGO_ITEM_PUB.process_item_cat_assignment ');
2196: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2197: RAISE FND_API.g_exc_unexpected_error;
2198: END IF;
2199: IF FND_API.to_boolean( p_commit ) THEN