DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on INV_EBI_OUTPUT_STATUS

Line 18: l_output_status inv_ebi_output_status;

14: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
15: ) IS
16: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
17: l_main_item_obj inv_ebi_item_main_obj;
18: l_output_status inv_ebi_output_status;
19: BEGIN
20: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
21: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
22: IF(p_revised_item.item IS NOT NULL ) THEN

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

16: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
17: l_main_item_obj inv_ebi_item_main_obj;
18: l_output_status inv_ebi_output_status;
19: BEGIN
20: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
21: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
22: IF(p_revised_item.item IS NOT NULL ) THEN
23: x_item := p_revised_item.item;
24: ELSE

Line 134: l_output_status inv_ebi_output_status;

130: ) IS
131: l_approval_status VARCHAR2(30);
132: l_item_number VARCHAR2(2000);
133: l_is_engineering_item VARCHAR2(3);
134: l_output_status inv_ebi_output_status;
135: l_designator_option NUMBER;
136: l_alt_bom_designator VARCHAR2(10);
137: l_inventory_item_id NUMBER;
138: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

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

138: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
139:
140: BEGIN
141: SAVEPOINT inv_ebi_engg_item_save_pnt;
142: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
143: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
144:
145: IF(p_item.main_obj_type.inventory_item_id IS NULL OR
146: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN

Line 280: l_output_status inv_ebi_output_status;

276: l_organization_id NUMBER;
277: l_component_item_name VARCHAR2(240);
278: l_is_component_item_exists VARCHAR2(3);
279: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
280: l_output_status inv_ebi_output_status;
281: BEGIN
282: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
283: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
284: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

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

278: l_is_component_item_exists VARCHAR2(3);
279: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
280: l_output_status inv_ebi_output_status;
281: BEGIN
282: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
283: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
284: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
285: l_pk_col_name_val_pairs.EXTEND(1);
286: l_pk_col_name_val_pairs(1).name := 'organization_code';

Line 346: l_output_status inv_ebi_output_status;

342: PROCEDURE validate_eco(
343: p_eco_obj IN inv_ebi_eco_obj
344: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
345: ) IS
346: l_output_status inv_ebi_output_status;
347: l_item_output inv_ebi_item_output_obj;
348: l_transaction_type VARCHAR2(20);
349: l_organization_id NUMBER;
350: BEGIN

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

347: l_item_output inv_ebi_item_output_obj;
348: l_transaction_type VARCHAR2(20);
349: l_organization_id NUMBER;
350: BEGIN
351: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
352: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
353: FND_MSG_PUB.initialize;
354: IF p_eco_obj.eco_revised_item_type IS NOT NULL THEN
355: FOR i IN 1..p_eco_obj.eco_revised_item_type.COUNT LOOP

Line 507: l_output_status inv_ebi_output_status;

503: l_pkcode ego_col_name_value_pair_array;
504: l_eco_obj inv_ebi_eco_obj;
505: l_eco_obj_validate_eco inv_ebi_eco_obj;
506: l_out inv_ebi_eco_output_obj;
507: l_output_status inv_ebi_output_status;
508: l_item_output inv_ebi_item_output_obj;
509: l_item_output_tbl inv_ebi_item_output_tbl;
510: l_curr_status_code NUMBER;
511: l_status_code NUMBER;

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

546: --fnd_global.apps_initialize(1068,56229,724,0);
547: l_uda_output := inv_ebi_uda_output_obj(NULL,NULL);
548: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');
549: l_category_output := inv_ebi_category_output_obj(NULL);
550: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
551: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
552: l_item_output_tbl := inv_ebi_item_output_tbl();
553: l_item_obj_tbl := inv_ebi_item_attr_tbl();
554: l_update_item_tab := FND_TABLE_OF_NUMBER();

Line 1529: l_eco_lst_obj := inv_ebi_eco_out_obj(l_eco_obj,inv_ebi_output_status(l_return_status,l_count,l_msg_data,NULL));

1525: ELSE
1526: x_msg_data := l_part_msgtxt;
1527: END IF;
1528: END IF;
1529: l_eco_lst_obj := inv_ebi_eco_out_obj(l_eco_obj,inv_ebi_output_status(l_return_status,l_count,l_msg_data,NULL));
1530: l_eco_obj_tbl.EXTEND();
1531: l_eco_obj_tbl(l_cnt_cid) := l_eco_lst_obj;
1532: END LOOP;
1533: IF (l_ovrflw_msg='Y') AND SUBSTR(x_msg_data,length(x_msg_data)-2) <> '...' THEN