DBA Data[Home] [Help]

APPS.IEU_WORK_ACTION_PVT dependencies on FND_MSG_PUB

Line 36: fnd_msg_pub.delete_msg();

32: name_fail_exception EXCEPTION;
33:
34: BEGIN
35:
36: fnd_msg_pub.delete_msg();
37: x_return_status := fnd_api.g_ret_sts_success;
38: FND_MSG_PUB.initialize;
39: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
40: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 38: FND_MSG_PUB.initialize;

34: BEGIN
35:
36: fnd_msg_pub.delete_msg();
37: x_return_status := fnd_api.g_ret_sts_success;
38: FND_MSG_PUB.initialize;
39: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
40: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
41: x_msg_data := '';
42:

Line 195: fnd_msg_pub.add;

191: WHEN name_fail_exception THEN
192: x_return_status := fnd_api.g_ret_sts_unexp_error;
193:
194: fnd_message.set_name ('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
195: fnd_msg_pub.add;
196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197: fnd_msg_pub.count_and_get (
198: p_count => x_msg_count,
199: p_data => x_msg_data

Line 197: fnd_msg_pub.count_and_get (

193:
194: fnd_message.set_name ('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
195: fnd_msg_pub.add;
196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197: fnd_msg_pub.count_and_get (
198: p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201:

Line 243: fnd_msg_pub.delete_msg();

239:
240: BEGIN
241:
242:
243: fnd_msg_pub.delete_msg();
244: x_return_status := fnd_api.g_ret_sts_success;
245: FND_MSG_PUB.initialize;
246:
247: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

Line 245: FND_MSG_PUB.initialize;

241:
242:
243: fnd_msg_pub.delete_msg();
244: x_return_status := fnd_api.g_ret_sts_success;
245: FND_MSG_PUB.initialize;
246:
247: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
248: l_set_id_count :=0;
249: temp_act_user_label := LTRIM(RTRIM(p_label));

Line 285: FND_MSG_PUB.Add;

281: --DBMS_OUTPUT.PUT_LINE(' set lable count : '|| l_set_id_count);
282:
283: if (l_act_usr_lbl_count <> 0 or l_set_id_count <> 0) then
284: FND_MESSAGE.set_name('IEU', 'IEU_PROV_WP_LABLE_UNIQUE');
285: FND_MSG_PUB.Add;
286: x_return_status := FND_API.G_RET_STS_ERROR;
287: end if;
288:
289: -- x_return_status := fnd_api.g_ret_sts_success;

Line 291: x_msg_count := fnd_msg_pub.COUNT_MSG();

287: end if;
288:
289: -- x_return_status := fnd_api.g_ret_sts_success;
290:
291: x_msg_count := fnd_msg_pub.COUNT_MSG();
292:
293: FOR i in 1..x_msg_count LOOP
294: l_msg_data := '';
295: l_msg_count := 0;

Line 296: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

292:
293: FOR i in 1..x_msg_count LOOP
294: l_msg_data := '';
295: l_msg_count := 0;
296: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
297: x_msg_data := x_msg_data || ',' || l_msg_data;
298: END LOOP;
299:
300: EXCEPTION

Line 305: x_msg_count := fnd_msg_pub.COUNT_MSG();

301:
302: WHEN FND_API.G_EXC_ERROR THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305: x_msg_count := fnd_msg_pub.COUNT_MSG();
306:
307: FOR i in 1..x_msg_count LOOP
308: l_msg_data := '';
309: l_msg_count := 0;

Line 310: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

306:
307: FOR i in 1..x_msg_count LOOP
308: l_msg_data := '';
309: l_msg_count := 0;
310: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
311: x_msg_data := x_msg_data || ',' || l_msg_data;
312: END LOOP;
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 316: x_msg_count := fnd_msg_pub.COUNT_MSG();

312: END LOOP;
313:
314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: x_msg_count := fnd_msg_pub.COUNT_MSG();
317:
318: FOR i in 1..x_msg_count LOOP
319: l_msg_data := '';
320: l_msg_count := 0;

Line 321: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

317:
318: FOR i in 1..x_msg_count LOOP
319: l_msg_data := '';
320: l_msg_count := 0;
321: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
322: x_msg_data := x_msg_data || ',' || l_msg_data;
323: END LOOP;
324: WHEN OTHERS THEN
325: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;

Line 327: x_msg_count := fnd_msg_pub.COUNT_MSG();

323: END LOOP;
324: WHEN OTHERS THEN
325: --Rollback to IEU_UWQ_MEDIA_TYPES_PVT;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
327: x_msg_count := fnd_msg_pub.COUNT_MSG();
328:
329: FOR i in 1..x_msg_count LOOP
330: l_msg_data := '';
331: l_msg_count := 0;

Line 332: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);

328:
329: FOR i in 1..x_msg_count LOOP
330: l_msg_data := '';
331: l_msg_count := 0;
332: FND_MSG_PUB.Get(i, fnd_api.g_true, l_msg_data, l_msg_count);
333: x_msg_data := x_msg_data || ',' || l_msg_data;
334: END LOOP;
335:
336: END Validate_Action_Label;

Line 446: fnd_msg_pub.delete_msg();

442: l_section_map_sequence IEU_WP_NODE_SECTION_MAPS.SECTION_MAP_SEQUENCE%type;
443: l_panel_sec_cat_code IEU_WP_ACTION_MAPS.PANEL_SEC_CAT_CODE%type;
444: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
445: BEGIN
446: fnd_msg_pub.delete_msg();
447: x_return_status := fnd_api.g_ret_sts_success;
448: FND_MSG_PUB.initialize;
449: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
450: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 448: FND_MSG_PUB.initialize;

444: l_action_map_type_code IEU_WP_ACTION_MAPS.ACTION_MAP_TYPE_CODE%type;
445: BEGIN
446: fnd_msg_pub.delete_msg();
447: x_return_status := fnd_api.g_ret_sts_success;
448: FND_MSG_PUB.initialize;
449: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
450: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
451: x_msg_data := '';
452: l_count := 0;

Line 740: fnd_msg_pub.delete_msg();

736: and c.maction_def_id = a.wp_action_def_id
737: );
738: BEGIN
739:
740: fnd_msg_pub.delete_msg();
741: x_return_status := fnd_api.g_ret_sts_success;
742: FND_MSG_PUB.initialize;
743: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
744: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 742: FND_MSG_PUB.initialize;

738: BEGIN
739:
740: fnd_msg_pub.delete_msg();
741: x_return_status := fnd_api.g_ret_sts_success;
742: FND_MSG_PUB.initialize;
743: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
744: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
745: x_msg_data := '';
746: