91: l_pk_col_name_val_pairs.TRIM(1);
92: IF (x_item.main_obj_type.organization_id IS NULL) THEN
93: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
94: FND_MESSAGE.set_token('COL_VALUE', p_change_order_obj.organization_code);
95: FND_MSG_PUB.add;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98: ELSE
99: x_item.main_obj_type.organization_id := p_change_order_obj.organization_id;
107: EXCEPTION
108: WHEN FND_API.g_exc_error THEN
109: x_out.output_status.return_status := FND_API.g_ret_sts_error;
110: IF(x_out.output_status.msg_data IS NULL) THEN
111: FND_MSG_PUB.count_and_get(
112: p_encoded => FND_API.g_false
113: ,p_count => x_out.output_status.msg_count
114: ,p_data => x_out.output_status.msg_data
115: );
168: l_pk_col_name_val_pairs.TRIM(2);
169: IF (l_inventory_item_id IS NULL ) THEN
170: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
171: FND_MESSAGE.set_token('COL_VALUE', p_item.main_obj_type.item_number);
172: FND_MSG_PUB.add;
173: RAISE FND_API.g_exc_unexpected_error;
174: END IF;
175: ELSE
176: l_inventory_item_id := p_item.main_obj_type.inventory_item_id;
195: IF(NVL(l_item_approval_status, 'A') <> 'A') THEN
196:
197: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NOT_APPROVED');
198: FND_MESSAGE.set_token('ITEM', p_item.main_obj_type.item_number);
199: FND_MSG_PUB.add;
200: RAISE FND_API.g_exc_error;
201:
202: ELSE --End of Bug 8299853
203:
269: WHEN FND_API.g_exc_unexpected_error THEN
270: ROLLBACK TO inv_ebi_engg_item_save_pnt;
271: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
272: IF(x_out.output_status.msg_data IS NULL) THEN
273: FND_MSG_PUB.count_and_get(
274: p_encoded => FND_API.g_false
275: ,p_count => x_out.output_status.msg_count
276: ,p_data => x_out.output_status.msg_data
277: );
280: WHEN FND_API.g_exc_error THEN
281: ROLLBACK TO inv_ebi_engg_item_save_pnt;
282: x_out.output_status.return_status := FND_API.g_ret_sts_error;
283: IF(x_out.output_status.msg_data IS NULL) THEN
284: FND_MSG_PUB.count_and_get(
285: p_encoded => FND_API.g_false
286: ,p_count => x_out.output_status.msg_count
287: ,p_data => x_out.output_status.msg_data
288: );
334: INV_EBI_UTIL.debug_line('STEP 20: ORG ID: '|| l_organization_id);
335: IF (l_organization_id IS NULL) THEN
336: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
337: FND_MESSAGE.set_token('COL_VALUE',p_organization_code);
338: FND_MSG_PUB.add;
339: RAISE FND_API.g_exc_error;
340: END IF;
341: l_is_master_org := INV_EBI_UTIL.is_master_org(l_organization_id);
342: IF(p_component_item_tbl IS NOT NULL AND p_component_item_tbl.COUNT > 0) THEN
350: );
351: IF(l_is_master_org = fnd_api.g_true AND l_is_component_item_exists = fnd_api.g_false) THEN
352: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
353: FND_MESSAGE.set_token('COMP_ITEM', l_component_item_name);
354: FND_MSG_PUB.add;
355: RAISE FND_API.g_exc_error;
356: END IF;
357: END IF;
358: END LOOP;
361: EXCEPTION
362: WHEN FND_API.g_exc_error THEN
363: x_out.output_status.return_status := FND_API.g_ret_sts_error;
364: IF(x_out.output_status.msg_data IS NULL) THEN
365: FND_MSG_PUB.count_and_get(
366: p_encoded => FND_API.g_false
367: ,p_count => x_out.output_status.msg_count
368: ,p_data => x_out.output_status.msg_data
369: );
401: ' ORGANIZATION ID : '|| p_item.main_obj_type.organization_id);
402: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
403: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
404: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
405: FND_MSG_PUB.initialize;
406:
407: IF(INV_EBI_ITEM_HELPER.is_item_exists (
408: p_organization_id => p_item.main_obj_type.organization_id
409: ,p_item_number => p_item.main_obj_type.item_number
447: END IF;
448:
449: FND_MESSAGE.set_token('ITEM',p_item.main_obj_type.item_number);
450: FND_MESSAGE.set_token('ITEM_CATALOG', l_item_catalog_group_code);
451: FND_MSG_PUB.add;
452: RAISE FND_API.g_exc_error;
453:
454: END IF;
455: END IF;
470: EXCEPTION
471: WHEN FND_API.g_exc_unexpected_error THEN
472: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
473: IF(x_out.output_status.msg_data IS NULL) THEN
474: FND_MSG_PUB.count_and_get(
475: p_encoded => FND_API.g_false
476: ,p_count => x_out.output_status.msg_count
477: ,p_data => x_out.output_status.msg_data
478: );
479: END IF;
480: WHEN FND_API.g_exc_error THEN
481: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
482: IF(x_out.output_status.msg_data IS NULL) THEN
483: FND_MSG_PUB.count_and_get(
484: p_encoded => FND_API.g_false
485: ,p_count => x_out.output_status.msg_count
486: ,p_data => x_out.output_status.msg_data
487: );
676: EXCEPTION
677: WHEN FND_API.g_exc_unexpected_error THEN
678: x_return_status := FND_API.g_ret_sts_error;
679: IF(x_msg_data IS NULL) THEN
680: FND_MSG_PUB.count_and_get(
681: p_encoded => FND_API.g_false
682: ,p_count => x_msg_count
683: ,p_data => x_msg_data
684: );
1215: inventory_item_id = p_inventory_item_id;
1216:
1217: BEGIN
1218: SAVEPOINT inv_ebi_chg_items_save_pnt;
1219: FND_MSG_PUB.initialize;
1220:
1221: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1222: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
1223:
1461:
1462: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1463:
1464: IF(x_out.output_status.msg_data IS NULL) THEN
1465: FND_MSG_PUB.count_and_get(
1466: p_encoded => FND_API.g_false
1467: ,p_count => x_out.output_status.msg_data
1468: ,p_data => x_out.output_status.msg_data
1469: );
1509: l_output_status inv_ebi_output_status;
1510:
1511: BEGIN
1512: SAVEPOINT inv_ebi_proc_upd_item_save_pnt;
1513: FND_MSG_PUB.initialize;
1514: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_update_items');
1515: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1516: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
1517:
1548:
1549: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1550:
1551: IF(x_out.output_status.msg_data IS NULL) THEN
1552: FND_MSG_PUB.count_and_get(
1553: p_encoded => FND_API.g_false
1554: ,p_count => x_out.output_status.msg_count
1555: ,p_data => x_out.output_status.msg_data
1556: );
1611:
1612: BEGIN
1613: SAVEPOINT inv_ebi_process_bom_save_pnt;
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:
1877:
1878: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1879:
1880: IF(x_out.output_status.msg_data IS NULL) THEN
1881: FND_MSG_PUB.count_and_get(
1882: p_encoded => FND_API.g_false
1883: ,p_count => x_out.output_status.msg_count
1884: ,p_data => x_out.output_status.msg_data
1885: );
1945: l_api_version NUMBER:=1.0;
1946: l_is_task_template_set BOOLEAN := FALSE;
1947: BEGIN
1948: SAVEPOINT inv_ebi_chg_order_save_pnt;
1949: FND_MSG_PUB.initialize;
1950:
1951: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order' );
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 );
2165: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
2166: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
2167:
2168: IF(x_out.output_status.msg_data IS NULL) THEN
2169: FND_MSG_PUB.count_and_get(
2170: p_encoded => FND_API.g_false
2171: ,p_count => x_out.output_status.msg_count
2172: ,p_data => x_out.output_status.msg_data
2173: );
2251: */
2252:
2253: SAVEPOINT inv_ebi_prc_chg_ord_save_pnt;
2254: ERROR_HANDLER.Initialize;
2255: FND_MSG_PUB.initialize;
2256: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core');
2257: INV_EBI_UTIL.debug_line( ' **************** Apps Context Details ****************' );
2258: INV_EBI_UTIL.debug_line(' User Id: ' || FND_GLOBAL.USER_ID || '; Responsibility Application id: ' ||
2259: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
2640: IS
2641: BEGIN
2642: SAVEPOINT inv_ebi_prc_chg_lst_save_pnt;
2643: ERROR_HANDLER.Initialize;
2644: FND_MSG_PUB.initialize;
2645: INV_EBI_UTIL.setup();
2646: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
2647: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2648:
2691: IS
2692: BEGIN
2693: --SAVEPOINT inv_ebi_val_chg_lst_save_pnt;
2694: ERROR_HANDLER.Initialize;
2695: FND_MSG_PUB.initialize;
2696: INV_EBI_UTIL.setup();
2697: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_change_order_list');
2698: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2699: