DBA Data[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on FND_MSG_PUB

Line 95: FND_MSG_PUB.add;

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;

Line 111: FND_MSG_PUB.count_and_get(

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

Line 172: FND_MSG_PUB.add;

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;

Line 199: FND_MSG_PUB.add;

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:

Line 273: FND_MSG_PUB.count_and_get(

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

Line 284: FND_MSG_PUB.count_and_get(

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

Line 338: FND_MSG_PUB.add;

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

Line 354: FND_MSG_PUB.add;

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;

Line 365: FND_MSG_PUB.count_and_get(

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

Line 405: FND_MSG_PUB.initialize;

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

Line 451: FND_MSG_PUB.add;

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;

Line 474: FND_MSG_PUB.count_and_get(

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

Line 483: FND_MSG_PUB.count_and_get(

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

Line 680: FND_MSG_PUB.count_and_get(

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

Line 1219: FND_MSG_PUB.initialize;

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:

Line 1465: FND_MSG_PUB.count_and_get(

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

Line 1513: FND_MSG_PUB.initialize;

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:

Line 1552: FND_MSG_PUB.count_and_get(

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

Line 1615: FND_MSG_PUB.initialize;

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:

Line 1881: FND_MSG_PUB.count_and_get(

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

Line 1949: FND_MSG_PUB.initialize;

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

Line 2169: FND_MSG_PUB.count_and_get(

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

Line 2255: FND_MSG_PUB.initialize;

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

Line 2644: FND_MSG_PUB.initialize;

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:

Line 2695: FND_MSG_PUB.initialize;

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: