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.INV_EBI_ITEM_HELPER dependencies on INV_EBI_OUTPUT_STATUS

Line 257: l_output_status inv_ebi_output_status;

253: ,x_out OUT NOCOPY inv_ebi_item_output_obj
254: ,x_item OUT NOCOPY inv_ebi_item_obj
255: ) IS
256: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
257: l_output_status inv_ebi_output_status;
258: BEGIN
259: x_item := p_item;
260: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
261: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);

Line 260: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

256: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
257: l_output_status inv_ebi_output_status;
258: BEGIN
259: x_item := p_item;
260: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
261: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
262: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
263: IF ( (p_item.main_obj_type.organization_id IS NULL OR p_item.main_obj_type.organization_id = fnd_api.g_miss_num)
264: AND p_item.main_obj_type.organization_code IS NOT NULL ) THEN

Line 1182: l_output_status inv_ebi_output_status;

1178: l_item_desc_gen_method VARCHAR2(3) := 'U';
1179: l_is_master_org VARCHAR2(3) := 'N';
1180: l_is_new_item_request_reqd VARCHAR2(3) := 'N';
1181: l_eng_item_flag VARCHAR2(3);
1182: l_output_status inv_ebi_output_status;
1183: l_count NUMBER;
1184: l_master_org NUMBER;
1185: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
1186: l_apply_template_update VARCHAR2(2000);

Line 1202: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

1198: BEGIN
1199: SAVEPOINT inv_ebi_pvt_item_save_pnt;
1200: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_item_pvt ');
1201: l_item := p_item;
1202: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1203: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
1204: l_item_number := l_item.main_obj_type.item_number;
1205: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
1206: IF(l_item_number IS NULL OR l_item_number = fnd_api.g_miss_char) THEN

Line 1961: l_output_status inv_ebi_output_status;

1957: l_attributes_row_obj ego_user_attr_row_obj;
1958: l_transaction_type VARCHAR2(20);
1959: l_data_level VARCHAR2(25);
1960: l_revision_id NUMBER;
1961: l_output_status inv_ebi_output_status;
1962: BEGIN
1963: SAVEPOINT inv_ebi_item_uda_save_pnt;
1964: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
1965: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

Line 1965: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

1961: l_output_status inv_ebi_output_status;
1962: BEGIN
1963: SAVEPOINT inv_ebi_item_uda_save_pnt;
1964: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
1965: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1966: x_uda_output_obj := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,l_uda_out,NULL,NULL,NULL,NULL);
1967: INV_EBI_UTIL.transform_uda (
1968: p_uda_input_obj => p_uda_input_obj
1969: ,x_attributes_row_table => l_attributes_row_table

Line 2100: l_output_status inv_ebi_output_status;

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
2104: SAVEPOINT inv_ebi_org_id_save_pnt;

Line 2106: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

2102: l_item_org_tbl_count NUMBER := 1;
2103: BEGIN
2104: SAVEPOINT inv_ebi_org_id_save_pnt;
2105: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_org_id_assignments ');
2106: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2107: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2108: IF p_org_id_tbl.COUNT > 0 THEN
2109: FOR i IN 1..p_org_id_tbl.COUNT LOOP
2110: l_item_org_assignment_rec.inventory_item_id := p_inventory_item_id;

Line 2171: l_output_status inv_ebi_output_status;

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;
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);

Line 2176: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

2172: BEGIN
2173: SAVEPOINT inv_ebi_cat_id_save_pnt;
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(

Line 2261: l_output_status inv_ebi_output_status;

2257: l_attribute12 mtl_mfg_part_numbers.attribute12%TYPE;
2258: l_attribute13 mtl_mfg_part_numbers.attribute13%TYPE;
2259: l_attribute14 mtl_mfg_part_numbers.attribute14%TYPE;
2260: l_attribute15 mtl_mfg_part_numbers.attribute15%TYPE;
2261: l_output_status inv_ebi_output_status;
2262: CURSOR c_mfg_part_num(
2263: p_manufacturer_id IN NUMBER
2264: ,p_mfg_part_num IN VARCHAR2
2265: ,P_organization_id IN NUMBER

Line 2299: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

2295: AND inventory_item_id = p_inventory_item_id;
2296: BEGIN
2297: SAVEPOINT inv_ebi_part_num_save_pnt;
2298: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_HELPER.process_part_num_association ');
2299: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2300: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2301: IF p_mfg_part_obj.mfg_part_num IS NOT NULL THEN
2302: OPEN c_mfg_part_num(
2303: p_manufacturer_id => p_mfg_part_obj.manufacturer_id

Line 2583: l_output_status inv_ebi_output_status;

2579: l_inventory_item_id NUMBER;
2580: l_organization_id NUMBER;
2581: l_organization_code VARCHAR2(3);
2582: l_item_number VARCHAR2(2000);
2583: l_output_status inv_ebi_output_status;
2584: l_category_output inv_ebi_category_output_obj;
2585:
2586: l_mfg_part_num_obj inv_ebi_manufacturer_part_obj;
2587: l_master_org_id NUMBER;

Line 2594: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

2590: l_operating_unit VARCHAR2(240);
2591: l_operating_unit_id NUMBER;
2592: BEGIN
2593: SAVEPOINT inv_ebi_sync_item_save_pnt;
2594: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2595: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
2596: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
2597:
2598: --Create or update item

Line 3119: l_output_status inv_ebi_output_status;

3115: l_attr ego_user_attr_data_table;
3116: l_count NUMBER := 0;
3117: l_new_attr_in_tbl VARCHAR2(1) := fnd_api.g_false;
3118: l_uda_out inv_ebi_uda_output_obj;
3119: l_output_status inv_ebi_output_status;
3120: l_attr_group_name VARCHAR2(30);
3121: l_data_level VARCHAR2(20) := NULL;
3122: l_data_level1 VARCHAR2(20) := NULL;
3123:

Line 3149: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

3145: AND ass.data_level_int_name = p_data_level_int_name;
3146:
3147: BEGIN
3148: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
3149: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3150: x_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_uda_out);
3151:
3152: l_attr_grp_req_tbl := EGO_ATTR_GROUP_REQUEST_TABLE();
3153:

Line 3309: l_output_status inv_ebi_output_status;

3305: l_application_id NUMBER;
3306: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
3307: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
3308: l_uda_output_obj inv_ebi_eco_output_obj;
3309: l_output_status inv_ebi_output_status;
3310:
3311: CURSOR c_attr_group_id IS
3312: SELECT DISTINCT ems.attr_group_id
3313: FROM

Line 3324: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

3320: ems.attr_group_id = ass.attr_group_id;
3321:
3322: BEGIN
3323:
3324: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3325: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
3326:
3327:
3328: IF( p_inventory_item_id IS NOT NULL AND