DBA Data[Home] [Help]

APPS.IEU_WP_ACTION_PVT dependencies on FND_MSG_PUB

Line 36: fnd_msg_pub.delete_msg();

32: l_application_id number;
33: BEGIN
34: l_responsibility_id := rec_obj.responsibility_id;
35: l_application_id := rec_obj.application_id;
36: fnd_msg_pub.delete_msg();
37: x_return_status := fnd_api.g_ret_sts_success;
38: FND_MSG_PUB.initialize;
39: x_msg_data := '';
40:

Line 38: FND_MSG_PUB.initialize;

34: l_responsibility_id := rec_obj.responsibility_id;
35: l_application_id := rec_obj.application_id;
36: fnd_msg_pub.delete_msg();
37: x_return_status := fnd_api.g_ret_sts_success;
38: FND_MSG_PUB.initialize;
39: x_msg_data := '';
40:
41: if (rec_obj.responsibility_id is null) then
42: l_responsibility_id := -2;

Line 142: fnd_msg_pub.delete_msg();

138: FROM ieu_wp_param_props_b
139: WHERE action_param_set_id = v_param_set_id;
140: cur_rec c_cursor%ROWTYPE;
141: begin
142: fnd_msg_pub.delete_msg();
143: x_return_status := fnd_api.g_ret_sts_success;
144: FND_MSG_PUB.initialize;
145: x_msg_data := '';
146:

Line 144: FND_MSG_PUB.initialize;

140: cur_rec c_cursor%ROWTYPE;
141: begin
142: fnd_msg_pub.delete_msg();
143: x_return_status := fnd_api.g_ret_sts_success;
144: FND_MSG_PUB.initialize;
145: x_msg_data := '';
146:
147: v_param_set_id := r_param_set_id;
148: OPEN c_cursor;

Line 230: fnd_msg_pub.delete_msg();

226: v_CursorID INTEGER;
227: v_Dummy INTEGER;
228:
229: BEGIN
230: fnd_msg_pub.delete_msg();
231: x_return_status := fnd_api.g_ret_sts_success;
232: FND_MSG_PUB.initialize;
233: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
234: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 232: FND_MSG_PUB.initialize;

228:
229: BEGIN
230: fnd_msg_pub.delete_msg();
231: x_return_status := fnd_api.g_ret_sts_success;
232: FND_MSG_PUB.initialize;
233: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
234: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
235: x_msg_data := '';
236: execute immediate ' update IEU_WP_ACT_PARAM_SETS_TL ' ||

Line 292: fnd_msg_pub.delete_msg();

288: l_cur_obj_versn NUMBER;
289:
290: BEGIN
291:
292: fnd_msg_pub.delete_msg();
293: x_return_status := fnd_api.g_ret_sts_success;
294: FND_MSG_PUB.initialize;
295: x_msg_data := '';
296:

Line 294: FND_MSG_PUB.initialize;

290: BEGIN
291:
292: fnd_msg_pub.delete_msg();
293: x_return_status := fnd_api.g_ret_sts_success;
294: FND_MSG_PUB.initialize;
295: x_msg_data := '';
296:
297: execute immediate 'select unique(object_version_number) from ieu_wp_action_maps where wp_action_map_ID = :1'
298: into l_cur_obj_versn using rec_obj.wp_action_map_id;

Line 407: fnd_msg_pub.delete_msg();

403: FROM ieu_uwq_sel_enumerators
404: where sel_enum_id = v_sel_enum_id);
405: c_rec2 c_cursor2%ROWTYPE;
406: BEGIN
407: fnd_msg_pub.delete_msg();
408: x_return_status := fnd_api.g_ret_sts_success;
409: FND_MSG_PUB.initialize;
410: x_msg_data := '';
411:

Line 409: FND_MSG_PUB.initialize;

405: c_rec2 c_cursor2%ROWTYPE;
406: BEGIN
407: fnd_msg_pub.delete_msg();
408: x_return_status := fnd_api.g_ret_sts_success;
409: FND_MSG_PUB.initialize;
410: x_msg_data := '';
411:
412: if(r_MACTION_DEF_TYPE_FLAG <> 'F') then
413: v_type_code := 'NODE';

Line 540: fnd_msg_pub.delete_msg();

536: media_count NUMBER(15);
537: temp_svr_type_id NUMBER(15);
538: l_count NUMBER(15) :=0;
539: BEGIN
540: fnd_msg_pub.delete_msg();
541: x_return_status := fnd_api.g_ret_sts_success;
542: FND_MSG_PUB.initialize;
543: x_msg_data := '';
544: execute immediate ' select count(*) '||

Line 542: FND_MSG_PUB.initialize;

538: l_count NUMBER(15) :=0;
539: BEGIN
540: fnd_msg_pub.delete_msg();
541: x_return_status := fnd_api.g_ret_sts_success;
542: FND_MSG_PUB.initialize;
543: x_msg_data := '';
544: execute immediate ' select count(*) '||
545: ' from ieu_wp_action_maps where wp_action_map_id = :1 '||
546: ' and responsibility_id is null'

Line 653: fnd_msg_pub.delete_msg();

649:
650:
651: BEGIN
652:
653: fnd_msg_pub.delete_msg();
654: x_return_status := fnd_api.g_ret_sts_success;
655: FND_MSG_PUB.initialize;
656: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
657: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 655: FND_MSG_PUB.initialize;

651: BEGIN
652:
653: fnd_msg_pub.delete_msg();
654: x_return_status := fnd_api.g_ret_sts_success;
655: FND_MSG_PUB.initialize;
656: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
657: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
658: x_msg_data := '';
659:

Line 790: fnd_msg_pub.delete_msg();

786: c_rec2 c_cur2%ROWTYPE;
787: null_string varchar2(200) := null;
788: BEGIN
789:
790: fnd_msg_pub.delete_msg();
791: x_return_status := fnd_api.g_ret_sts_success;
792: FND_MSG_PUB.initialize;
793: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
794: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 792: FND_MSG_PUB.initialize;

788: BEGIN
789:
790: fnd_msg_pub.delete_msg();
791: x_return_status := fnd_api.g_ret_sts_success;
792: FND_MSG_PUB.initialize;
793: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
794: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
795: x_msg_data := '';
796:

Line 1100: fnd_msg_pub.delete_msg();

1096: c_rec2 c_cur2%ROWTYPE;
1097:
1098: Begin
1099:
1100: fnd_msg_pub.delete_msg();
1101: x_return_status := fnd_api.g_ret_sts_success;
1102: FND_MSG_PUB.initialize;
1103: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1104: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 1102: FND_MSG_PUB.initialize;

1098: Begin
1099:
1100: fnd_msg_pub.delete_msg();
1101: x_return_status := fnd_api.g_ret_sts_success;
1102: FND_MSG_PUB.initialize;
1103: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1104: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1105: x_msg_data := '';
1106:

Line 1347: fnd_msg_pub.delete_msg();

1343: c_rec2 c_cur2%ROWTYPE;
1344:
1345: l_count NUMBER:=1;
1346: begin
1347: fnd_msg_pub.delete_msg();
1348: x_return_status := fnd_api.g_ret_sts_success;
1349: FND_MSG_PUB.initialize;
1350:
1351: x_msg_data := '';

Line 1349: FND_MSG_PUB.initialize;

1345: l_count NUMBER:=1;
1346: begin
1347: fnd_msg_pub.delete_msg();
1348: x_return_status := fnd_api.g_ret_sts_success;
1349: FND_MSG_PUB.initialize;
1350:
1351: x_msg_data := '';
1352: if (r_panel = 'F') then
1353: v_enumId := r_enumId;

Line 1551: fnd_msg_pub.delete_msg();

1547: c_rec2 c_cur2%ROWTYPE;
1548:
1549: BEGIN
1550:
1551: fnd_msg_pub.delete_msg();
1552: x_return_status := fnd_api.g_ret_sts_success;
1553: FND_MSG_PUB.initialize;
1554: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1555: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;

Line 1553: FND_MSG_PUB.initialize;

1549: BEGIN
1550:
1551: fnd_msg_pub.delete_msg();
1552: x_return_status := fnd_api.g_ret_sts_success;
1553: FND_MSG_PUB.initialize;
1554: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
1555: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1556: x_msg_data := '';
1557: