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_PUB dependencies on INV_EBI_ITEM_HELPER

Line 20: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

16: l_is_master_org VARCHAR2(3) := FND_API.g_false;
17: l_is_new_item_request_reqd VARCHAR2(3) := FND_API.g_false;
18: l_output_status inv_ebi_output_status;
19: l_item_catalog_group_code VARCHAR2(40);
20: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
21: BEGIN
22: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
23: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
24: FND_MSG_PUB.initialize;

Line 25: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

21: BEGIN
22: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
23: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL);
24: FND_MSG_PUB.initialize;
25: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
26: IF(p_transaction_type = INV_EBI_ITEM_PUB.g_otype_create) THEN
27: IF(p_item.main_obj_type.organization_id IS NULL OR p_item.main_obj_type.organization_id = fnd_api.g_miss_num) THEN
28:
29: x_out.organization_id := INV_EBI_ITEM_HELPER.get_default_master_org(

Line 29: x_out.organization_id := INV_EBI_ITEM_HELPER.get_default_master_org(

25: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
26: IF(p_transaction_type = INV_EBI_ITEM_PUB.g_otype_create) THEN
27: IF(p_item.main_obj_type.organization_id IS NULL OR p_item.main_obj_type.organization_id = fnd_api.g_miss_num) THEN
28:
29: x_out.organization_id := INV_EBI_ITEM_HELPER.get_default_master_org(
30: p_config => p_item.name_value_tbl
31: );
32:
33: IF x_out.organization_id IS NULL THEN

Line 52: l_is_new_item_request_reqd := INV_EBI_ITEM_HELPER.is_new_item_request_reqd(

48:
49: END IF;
50:
51: IF(l_is_master_org = FND_API.g_true) THEN
52: l_is_new_item_request_reqd := INV_EBI_ITEM_HELPER.is_new_item_request_reqd(
53: p_item_catalog_group_id => p_item.main_obj_type.item_catalog_group_id
54: );
55:
56: IF(l_is_new_item_request_reqd = FND_API.g_true) THEN

Line 62: l_item_catalog_group_code := INV_EBI_ITEM_HELPER.id_to_value(

58: IF p_item.main_obj_type.item_catalog_group_code IS NULL THEN
59: l_pk_col_name_val_pairs.EXTEND(1);
60: l_pk_col_name_val_pairs(1).name := 'item_catalog_group_id';
61: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_catalog_group_id;
62: l_item_catalog_group_code := INV_EBI_ITEM_HELPER.id_to_value(
63: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
64: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ITEM_CATALOG_GROUP
65: );
66: l_pk_col_name_val_pairs.TRIM(1);

Line 64: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ITEM_CATALOG_GROUP

60: l_pk_col_name_val_pairs(1).name := 'item_catalog_group_id';
61: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_catalog_group_id;
62: l_item_catalog_group_code := INV_EBI_ITEM_HELPER.id_to_value(
63: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
64: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ITEM_CATALOG_GROUP
65: );
66: l_pk_col_name_val_pairs.TRIM(1);
67:
68: ELSE

Line 130: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');

126: INV_EBI_UTIL.debug_line('STEP: 10 '||'START INSIDE INV_EBI_ITEM_PUB.process_item '||
127: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||
128: 'Item Number: '||p_item.main_obj_type.item_number
129: );
130: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');
131: INV_EBI_ITEM_HELPER.populate_item_ids(
132: p_item => p_item
133: ,x_out => x_out
134: ,x_item => l_item

Line 131: INV_EBI_ITEM_HELPER.populate_item_ids(

127: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||
128: 'Item Number: '||p_item.main_obj_type.item_number
129: );
130: INV_EBI_UTIL.debug_line('STEP: 20 '||'START CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');
131: INV_EBI_ITEM_HELPER.populate_item_ids(
132: p_item => p_item
133: ,x_out => x_out
134: ,x_item => l_item
135: );

Line 136: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');

132: p_item => p_item
133: ,x_out => x_out
134: ,x_item => l_item
135: );
136: INV_EBI_UTIL.debug_line('STEP: 30 '||'END CALLING INV_EBI_ITEM_HELPER.populate_item_ids ');
137:
138: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;

Line 165: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING INV_EBI_ITEM_HELPER.sync_item ');

161: l_item.main_obj_type.effectivity_date := sysdate+(2/(60*60*24));
162: END IF;
163:
164: --To create Production item
165: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING INV_EBI_ITEM_HELPER.sync_item ');
166:
167: INV_EBI_ITEM_HELPER.sync_item (
168: p_commit => FND_API.g_false
169: ,p_operation => p_operation

Line 167: INV_EBI_ITEM_HELPER.sync_item (

163:
164: --To create Production item
165: INV_EBI_UTIL.debug_line('STEP: 60 '||'START CALLING INV_EBI_ITEM_HELPER.sync_item ');
166:
167: INV_EBI_ITEM_HELPER.sync_item (
168: p_commit => FND_API.g_false
169: ,p_operation => p_operation
170: ,p_item => l_item
171: ,x_out => l_out

Line 174: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING INV_EBI_ITEM_HELPER.sync_item ');

170: ,p_item => l_item
171: ,x_out => l_out
172: );
173:
174: INV_EBI_UTIL.debug_line('STEP: 70 '||'END CALLING INV_EBI_ITEM_HELPER.sync_item ');
175: IF (l_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
176: x_out.output_status.msg_data := l_out.output_status.msg_data;
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;

Line 191: INV_EBI_ITEM_HELPER.process_item_uda(

187:
188: -- To process Udas
189: IF (INV_EBI_UTIL.is_pim_installed AND l_item.main_obj_type.item_catalog_group_id IS NOT NULL ) THEN
190: IF (l_item.uda_type IS NOT NULL AND l_item.uda_type.attribute_group_tbl.COUNT > 0) THEN
191: INV_EBI_ITEM_HELPER.process_item_uda(
192: p_api_version => l_api_version
193: ,p_inventory_item_id => x_out.inventory_item_id
194: ,p_organization_id => x_out.organization_id
195: ,p_item_catalog_group_id => l_item.main_obj_type.item_catalog_group_id

Line 218: INV_EBI_UTIL.debug_line('STEP: 80 '||'END INSIDE INV_EBI_ITEM_HELPER.process_item '||

214:
215: IF FND_API.to_boolean(p_commit) THEN
216: COMMIT;
217: END IF;
218: INV_EBI_UTIL.debug_line('STEP: 80 '||'END INSIDE INV_EBI_ITEM_HELPER.process_item '||
219: 'ORGANIZATION CODE: '||p_item.main_obj_type.organization_code||
220: 'Item Number: '||p_item.main_obj_type.item_number
221: );
222: INV_EBI_UTIL.wrapup;

Line 316: INV_EBI_ITEM_HELPER.get_item_balance(

312: END LOOP;
313:
314: l_item_balance_input := inv_ebi_item_bal_input_list(l_item_bal_input_tbl);
315:
316: INV_EBI_ITEM_HELPER.get_item_balance(
317: p_item_balance_input => l_item_balance_input
318: ,x_item_balance_output => x_item_balance_output
319: ,x_return_status => x_return_status
320: ,x_msg_count => x_msg_count

Line 364: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.start_date_active);

360: ------------------------------------------------------------------
361: -- To Convert Date Fields in main_obj_type (INV_EBI_ITEM_MAIN_OBJ)
362: ------------------------------------------------------------------
363: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.start_date_active_str :=
364: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.start_date_active);
365: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.end_date_active_str :=
366: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.end_date_active);
367: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date_str:=
368: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date);

Line 366: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.end_date_active);

362: ------------------------------------------------------------------
363: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.start_date_active_str :=
364: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.start_date_active);
365: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.end_date_active_str :=
366: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.end_date_active);
367: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date_str:=
368: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date);
369: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.last_update_date_str :=
370: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.last_update_date_str);

Line 368: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date);

364: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.start_date_active);
365: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.end_date_active_str :=
366: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.end_date_active);
367: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date_str:=
368: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date);
369: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.last_update_date_str :=
370: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.last_update_date_str);
371: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.program_update_date_str:=
372: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.program_update_date);

Line 370: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.last_update_date_str);

366: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.end_date_active);
367: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date_str:=
368: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date);
369: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.last_update_date_str :=
370: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.last_update_date_str);
371: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.program_update_date_str:=
372: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.program_update_date);
373:
374: --------------------------------------------------------------------------------

Line 372: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.program_update_date);

368: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.creation_date);
369: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.last_update_date_str :=
370: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.last_update_date_str);
371: x_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.program_update_date_str:=
372: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.main_obj_type.program_update_date);
373:
374: --------------------------------------------------------------------------------
375: -- To Convert Date Fields in deprecated_obj_type (INV_EBI_ITEM_DEPRECATED_OBJ)
376: --------------------------------------------------------------------------------

Line 379: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.engineering_date);

375: -- To Convert Date Fields in deprecated_obj_type (INV_EBI_ITEM_DEPRECATED_OBJ)
376: --------------------------------------------------------------------------------
377: IF(p_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type IS NOT NULL) THEN
378: x_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.engineering_date_str :=
379: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.engineering_date);
380: x_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.wh_update_date :=
381: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.wh_update_date);
382: END IF;
383:

Line 381: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.wh_update_date);

377: IF(p_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type IS NOT NULL) THEN
378: x_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.engineering_date_str :=
379: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.engineering_date);
380: x_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.wh_update_date :=
381: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.deprecated_obj_type.wh_update_date);
382: END IF;
383:
384: --------------------------------------------------------------------------------
385: -- To Convert Date Fields in attribute_group_tbl(INV_EBI_UDA_ATTR_GRP_TBL)

Line 397: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.uda_type.attribute_group_tbl(j).attributes_tbl(k).attr_value_date);

393: AND p_item_tbl_obj.item_attr_tbl(i).item_obj.uda_type.attribute_group_tbl(j).attributes_tbl.COUNT>0) THEN
394: FOR k IN p_item_tbl_obj.item_attr_tbl(i).item_obj.uda_type.attribute_group_tbl(j).attributes_tbl.FIRST..
395: p_item_tbl_obj.item_attr_tbl(i).item_obj.uda_type.attribute_group_tbl(j).attributes_tbl.LAST LOOP
396: x_item_tbl_obj.item_attr_tbl(i).item_obj.uda_type.attribute_group_tbl(j).attributes_tbl(k).attr_value_date_str :=
397: INV_EBI_ITEM_HELPER.convert_date_str(p_item_tbl_obj.item_attr_tbl(i).item_obj.uda_type.attribute_group_tbl(j).attributes_tbl(k).attr_value_date);
398: END LOOP;
399: END IF;
400: END LOOP;
401: END IF;

Line 438: INV_EBI_ITEM_HELPER.set_server_time_zone;

434: l_get_opr_attrs_tbl := inv_ebi_get_opr_attrs_tbl();
435: l_items := p_items;
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: INV_EBI_ITEM_HELPER.set_server_time_zone;
439:
440: IF (l_items.item_table.COUNT > 0) THEN
441: FOR i IN l_items.item_table.FIRST..l_items.item_table.LAST LOOP
442: l_get_opr_attrs_tbl.extend();

Line 457: INV_EBI_ITEM_HELPER.get_item_attributes(

453: END LOOP;
454:
455: l_get_item_inp_obj := inv_ebi_get_item_input(l_get_opr_attrs_tbl,p_name_val_list.name_value_table);
456:
457: INV_EBI_ITEM_HELPER.get_item_attributes(
458: p_get_item_inp_obj => l_get_item_inp_obj
459: ,x_item_tbl_obj => x_item_tbl_obj
460: ,x_return_status => x_return_status
461: ,x_msg_count => x_msg_count