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_CHANGE_ORDER_PUB dependencies on INV_EBI_ECO_OUTPUT_OBJ

Line 136: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

132: ************************************************************************************/
133: PROCEDURE transfer_engg_item_mfg(
134: p_item IN inv_ebi_item_obj
135: ,p_alt_bom_designator IN VARCHAR2
136: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
137: ) IS
138: l_item_approval_status VARCHAR2(30);
139: l_item_number VARCHAR2(2000);
140: l_is_engineering_item VARCHAR2(3);

Line 151: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

147: BEGIN
148: SAVEPOINT inv_ebi_engg_item_save_pnt;
149: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_mfg');
150: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
151: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
152:
153: IF(p_item.main_obj_type.inventory_item_id IS NULL OR
154: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN
155:

Line 314: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

310:
311: PROCEDURE validate_component_items(
312: p_organization_code IN VARCHAR2
313: ,p_component_item_tbl IN inv_ebi_rev_comp_tbl
314: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
315: ) IS
316: l_is_master_org VARCHAR2(3);
317: l_organization_id NUMBER;
318: l_component_item_name VARCHAR2(240);

Line 324: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

320: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
321: l_output_status inv_ebi_output_status;
322: BEGIN
323: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
324: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
325: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_component_items ORG CODE: '|| p_organization_code);
326: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
327: l_pk_col_name_val_pairs.EXTEND(1);
328: l_pk_col_name_val_pairs(1).name := 'organization_code';

Line 1201: l_eco_output_obj inv_ebi_eco_output_obj;

1197: l_revision VARCHAR2(3);
1198: l_revision_set BOOLEAN := FALSE;
1199: l_cnt_nmval NUMBER := 0;
1200: l_item_output_obj inv_ebi_item_output_obj;
1201: l_eco_output_obj inv_ebi_eco_output_obj;
1202: l_item_count NUMBER :=0;
1203: l_update_item_count NUMBER :=0;
1204: l_output_status inv_ebi_output_status;
1205:

Line 1589: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

1585: PROCEDURE process_bom(
1586: p_commit IN VARCHAR2 := FND_API.g_false
1587: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
1588: ,x_eco_obj_list OUT NOCOPY inv_ebi_eco_obj_tbl
1589: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1590: ) IS
1591:
1592: l_eco_obj inv_ebi_eco_obj;
1593: l_replicate_bom_item_obj inv_ebi_revised_item_obj;

Line 1605: l_out inv_ebi_eco_output_obj;

1601: l_replicate_bom_cnt NUMBER := 0;
1602: l_common_bom_found VARCHAR2(1);
1603: l_replicate_bom_found VARCHAR2(1);
1604: l_output_status inv_ebi_output_status;
1605: l_out inv_ebi_eco_output_obj;
1606: l_eco_idx NUMBER;
1607: l_item_idx NUMBER;
1608: l_name_value_tbl inv_ebi_name_value_tbl;
1609: l_is_bom_exists VARCHAR2(1);

Line 1618: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

1614:
1615: FND_MSG_PUB.initialize;
1616:
1617: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1618: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1619:
1620: l_common_assy_item_tbl := inv_ebi_revised_item_tbl();
1621: l_replicate_bom_tbl := inv_ebi_revised_item_tbl();
1622: l_common_org_tbl := FND_TABLE_OF_VARCHAR2_30();

Line 1922: ,x_out OUT NOCOPY inv_ebi_eco_output_obj

1918:
1919: PROCEDURE process_change_order(
1920: p_commit IN VARCHAR2 := FND_API.g_false
1921: ,p_eco_obj IN inv_ebi_eco_obj
1922: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1923: ) IS
1924:
1925: l_change_id NUMBER;
1926: l_change_notice VARCHAR2(10);

Line 1938: l_out inv_ebi_eco_output_obj;

1934: l_revitem_output_tbl inv_ebi_revitem_output_obj_tbl;
1935: l_revision VARCHAR2(3);
1936: l_change_type_code NUMBER;
1937: l_status_name VARCHAR2(30);
1938: l_out inv_ebi_eco_output_obj;
1939: l_item_output inv_ebi_item_output_obj;
1940: l_uda_output inv_ebi_uda_output_obj;
1941: l_pkdata ego_col_name_value_pair_array;
1942: l_pkcode ego_col_name_value_pair_array;

Line 1956: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

1952: INV_EBI_UTIL.debug_line('STEP 20: CHANGE NOTICE: '|| p_eco_obj.eco_change_order_type.eco_name ||
1953: ' ORG CODE: '|| p_eco_obj.eco_change_order_type.organization_code );
1954: l_uda_output := inv_ebi_uda_output_obj(NULL,NULL);
1955: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1956: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1957:
1958: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();
1959:
1960: bom_globals.set_bo_identifier(bom_globals.g_eco_bo);

Line 2150: x_out := inv_ebi_eco_output_obj( l_change_notice,l_change_id,l_organization_id,l_organization_code,

2146: l_uda_output := inv_ebi_uda_output_obj(l_out.uda_output.failed_row_id_list,l_out.uda_output.errorcode);
2147: END IF;
2148: --End of Udas processing
2149: INV_EBI_UTIL.debug_line('STEP 110: END Processing UDAS');
2150: x_out := inv_ebi_eco_output_obj( l_change_notice,l_change_id,l_organization_id,l_organization_code,
2151: l_out.output_status,NULL,l_uda_output);
2152:
2153: IF FND_API.to_boolean(p_commit) THEN
2154: COMMIT;

Line 2206: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl

2202:
2203: PROCEDURE process_change_order_list_core(
2204: p_commit IN VARCHAR2 := fnd_api.g_false
2205: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
2206: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
2207: ,x_return_status OUT NOCOPY VARCHAR2
2208: ,x_msg_count OUT NOCOPY NUMBER
2209: ,x_msg_data OUT NOCOPY VARCHAR2
2210: )

Line 2214: l_inv_ebi_eco_output_obj inv_ebi_eco_output_obj;

2210: )
2211: IS
2212: l_inv_ebi_eco_obj inv_ebi_eco_obj;
2213: l_eco_obj inv_ebi_eco_obj;
2214: l_inv_ebi_eco_output_obj inv_ebi_eco_output_obj;
2215: l_part_err_msg VARCHAR2(32000);
2216: l_eco_name VARCHAR2(10);
2217: l_org_code VARCHAR2(3);
2218: l_is_master_org VARCHAR2(1);

Line 2264: x_out := inv_ebi_eco_output_obj_tbl();

2260: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
2261: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
2262:
2263: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2264: x_out := inv_ebi_eco_output_obj_tbl();
2265: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();
2266: l_eco_obj_tbl := inv_ebi_eco_obj_tbl();
2267: l_eco_obj_tbl := p_eco_obj_list;
2268:

Line 2305: x_out(i) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_item_output_obj.output_status,NULL,NULL);

2301: ,x_eco_obj => l_eco_obj
2302: );
2303:
2304: IF l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2305: x_out(i) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_item_output_obj.output_status,NULL,NULL);
2306: RAISE FND_API.g_exc_unexpected_error;
2307: END IF;
2308:
2309: l_eco_obj_tbl(i) := l_eco_obj;

Line 2362: x_out(i) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_item_output_obj.output_status,NULL,NULL);

2358: );
2359:
2360:
2361: IF l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2362: x_out(i) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_item_output_obj.output_status,NULL,NULL);
2363: RAISE FND_API.g_exc_unexpected_error;
2364: END IF;
2365:
2366: l_eco_obj_tbl(i) := l_eco_obj;

Line 2434: x_out(l_index) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_output_status,NULL,NULL);

2430:
2431: l_eco_name := l_upd_eco_name_tbl(i);
2432: l_output_status := l_item_output_obj.output_status;
2433: l_index := l_upd_eco_idx_tbl(i);
2434: x_out(l_index) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_output_status,NULL,NULL);
2435:
2436: END IF;
2437: END LOOP;
2438: RAISE fnd_api.g_exc_unexpected_error;

Line 2446: ,x_out => l_inv_ebi_eco_output_obj

2442: process_bom(
2443: p_commit => p_commit
2444: ,p_eco_obj_list => l_eco_obj_tbl
2445: ,x_eco_obj_list => l_eco_obj_list
2446: ,x_out => l_inv_ebi_eco_output_obj
2447: );
2448:
2449: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_bom status is ' || l_inv_ebi_eco_output_obj.output_status.return_status);
2450: IF (l_inv_ebi_eco_output_obj.output_status.return_status <> FND_API.g_ret_sts_success )THEN

Line 2449: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_bom status is ' || l_inv_ebi_eco_output_obj.output_status.return_status);

2445: ,x_eco_obj_list => l_eco_obj_list
2446: ,x_out => l_inv_ebi_eco_output_obj
2447: );
2448:
2449: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_bom status is ' || l_inv_ebi_eco_output_obj.output_status.return_status);
2450: IF (l_inv_ebi_eco_output_obj.output_status.return_status <> FND_API.g_ret_sts_success )THEN
2451: l_eco_name := l_inv_ebi_eco_output_obj.change_notice;
2452: l_org_code := l_inv_ebi_eco_output_obj.organization_code;
2453: FOR i IN 1..l_eco_obj_tbl.COUNT LOOP

Line 2450: IF (l_inv_ebi_eco_output_obj.output_status.return_status <> FND_API.g_ret_sts_success )THEN

2446: ,x_out => l_inv_ebi_eco_output_obj
2447: );
2448:
2449: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_bom status is ' || l_inv_ebi_eco_output_obj.output_status.return_status);
2450: IF (l_inv_ebi_eco_output_obj.output_status.return_status <> FND_API.g_ret_sts_success )THEN
2451: l_eco_name := l_inv_ebi_eco_output_obj.change_notice;
2452: l_org_code := l_inv_ebi_eco_output_obj.organization_code;
2453: FOR i IN 1..l_eco_obj_tbl.COUNT LOOP
2454:

Line 2451: l_eco_name := l_inv_ebi_eco_output_obj.change_notice;

2447: );
2448:
2449: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_bom status is ' || l_inv_ebi_eco_output_obj.output_status.return_status);
2450: IF (l_inv_ebi_eco_output_obj.output_status.return_status <> FND_API.g_ret_sts_success )THEN
2451: l_eco_name := l_inv_ebi_eco_output_obj.change_notice;
2452: l_org_code := l_inv_ebi_eco_output_obj.organization_code;
2453: FOR i IN 1..l_eco_obj_tbl.COUNT LOOP
2454:
2455: IF( l_eco_obj_tbl(i).eco_change_order_type.eco_name = l_eco_name AND

Line 2452: l_org_code := l_inv_ebi_eco_output_obj.organization_code;

2448:
2449: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_bom status is ' || l_inv_ebi_eco_output_obj.output_status.return_status);
2450: IF (l_inv_ebi_eco_output_obj.output_status.return_status <> FND_API.g_ret_sts_success )THEN
2451: l_eco_name := l_inv_ebi_eco_output_obj.change_notice;
2452: l_org_code := l_inv_ebi_eco_output_obj.organization_code;
2453: FOR i IN 1..l_eco_obj_tbl.COUNT LOOP
2454:
2455: IF( l_eco_obj_tbl(i).eco_change_order_type.eco_name = l_eco_name AND
2456: l_eco_obj_tbl(i).eco_change_order_type.organization_code = l_org_code ) THEN

Line 2457: x_out(i) := l_inv_ebi_eco_output_obj;

2453: FOR i IN 1..l_eco_obj_tbl.COUNT LOOP
2454:
2455: IF( l_eco_obj_tbl(i).eco_change_order_type.eco_name = l_eco_name AND
2456: l_eco_obj_tbl(i).eco_change_order_type.organization_code = l_org_code ) THEN
2457: x_out(i) := l_inv_ebi_eco_output_obj;
2458: END IF;
2459:
2460: END LOOP;
2461: RAISE FND_API.g_exc_unexpected_error;

Line 2474: ,x_out => l_inv_ebi_eco_output_obj

2470:
2471: process_change_order(
2472: p_commit => p_commit
2473: ,p_eco_obj => l_inv_ebi_eco_obj
2474: ,x_out => l_inv_ebi_eco_output_obj
2475: );
2476: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order STATUS '|| l_inv_ebi_eco_output_obj.output_status.return_status);
2477: x_out(i) := l_inv_ebi_eco_output_obj;
2478:

Line 2476: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order STATUS '|| l_inv_ebi_eco_output_obj.output_status.return_status);

2472: p_commit => p_commit
2473: ,p_eco_obj => l_inv_ebi_eco_obj
2474: ,x_out => l_inv_ebi_eco_output_obj
2475: );
2476: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order STATUS '|| l_inv_ebi_eco_output_obj.output_status.return_status);
2477: x_out(i) := l_inv_ebi_eco_output_obj;
2478:
2479: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2480:

Line 2477: x_out(i) := l_inv_ebi_eco_output_obj;

2473: ,p_eco_obj => l_inv_ebi_eco_obj
2474: ,x_out => l_inv_ebi_eco_output_obj
2475: );
2476: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order STATUS '|| l_inv_ebi_eco_output_obj.output_status.return_status);
2477: x_out(i) := l_inv_ebi_eco_output_obj;
2478:
2479: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2480:
2481: RAISE FND_API.g_exc_unexpected_error;

Line 2509: x_out(l_index) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_output_status,NULL,NULL);

2505:
2506: l_eco_name := l_upd_eco_name_tbl(i);
2507: l_output_status := l_item_output_obj.output_status;
2508: l_index := l_upd_eco_idx_tbl(i);
2509: x_out(l_index) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_output_status,NULL,NULL);
2510:
2511: END IF;
2512: END LOOP;
2513: RAISE fnd_api.g_exc_unexpected_error;

Line 2559: x_out(i) := inv_ebi_eco_output_obj( l_eco_obj_list(i).eco_change_order_type.eco_name,NULL,NULL,l_eco_obj_list(i).eco_change_order_type.organization_code

2555: INV_EBI_UTIL.debug_line('STEP 160: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_item_output_obj.output_status.return_status);
2556: END IF;
2557:
2558: IF (l_item_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2559: x_out(i) := inv_ebi_eco_output_obj( l_eco_obj_list(i).eco_change_order_type.eco_name,NULL,NULL,l_eco_obj_list(i).eco_change_order_type.organization_code
2560: ,l_item_output_obj.output_status,NULL,NULL);
2561: RAISE FND_API.g_exc_unexpected_error;
2562: END IF;
2563: END LOOP;

Line 2635: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl

2631:
2632: PROCEDURE process_change_order_list(
2633: p_commit IN VARCHAR2 := fnd_api.g_false
2634: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
2635: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
2636: ,x_return_status OUT NOCOPY VARCHAR2
2637: ,x_msg_count OUT NOCOPY NUMBER
2638: ,x_msg_data OUT NOCOPY VARCHAR2
2639: )

Line 2686: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl

2682: ************************************************************************************/
2683: PROCEDURE validate_change_order_list(
2684: p_commit IN VARCHAR2 := fnd_api.g_false
2685: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
2686: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
2687: ,x_return_status OUT NOCOPY VARCHAR2
2688: ,x_msg_count OUT NOCOPY NUMBER
2689: ,x_msg_data OUT NOCOPY VARCHAR2
2690: )