DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_WF_PUB dependencies on FND_MSG_PUB

Line 182: fnd_msg_pub.initialize;

178: END IF;
179:
180: IF fnd_api.to_boolean (p_init_msg_list)
181: THEN
182: fnd_msg_pub.initialize;
183: END IF;
184:
185: IF l_attr_access_level = 'UWA' THEN
186: l_approved := 'A';

Line 203: fnd_msg_pub.add;

199: IF c_resource%NOTFOUND THEN
200: --dbms_output.put_line('The Resource passed is Invalid');
201: fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RESOURCE_ID');
202: fnd_message.set_token('P_EMP_RESOURCE_ID', l_resource_id);
203: fnd_msg_pub.add;
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207: CLOSE c_resource;

Line 215: fnd_msg_pub.add;

211: IF c_resource_update%NOTFOUND THEN
212: --dbms_output.put_line('The Resource passed is Invalid');
213: fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RESOURCE_ID');
214: fnd_message.set_token('P_EMP_RESOURCE_ID', l_resource_id);
215: fnd_msg_pub.add;
216: x_return_status := fnd_api.g_ret_sts_unexp_error;
217: RAISE fnd_api.g_exc_unexpected_error;
218: END IF;
219: CLOSE c_resource_update;

Line 624: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

620: THEN
621: COMMIT WORK;
622: END IF;
623:
624: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
625:
626: EXCEPTION
627: WHEN fnd_api.g_exc_unexpected_error
628: THEN

Line 632: fnd_msg_pub.count_and_get (

628: THEN
629:
630: ROLLBACK TO start_rs_workflow;
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_msg_pub.count_and_get (
633: p_count => x_msg_count,
634: p_data => x_msg_data
635: );
636: WHEN OTHERS

Line 646: fnd_msg_pub.add;

642: if (l_errname is not null) then
643: fnd_message.set_name('FND', 'WF_ERROR');
644: fnd_message.set_token('ERROR_MESSAGE', l_errmsg);
645: fnd_message.set_token('ERROR_STACK', l_errstack);
646: fnd_msg_pub.add;
647: end if;
648:
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 650: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

646: fnd_msg_pub.add;
647: end if;
648:
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
651:
652: END start_update_resource_wf;
653:
654: PROCEDURE check_error_flag (

Line 983: if (fnd_msg_pub.count_msg > 0) then

979: );
980:
981: if (x_return_status <> 'S') then
982: x_resultout := 'U';
983: if (fnd_msg_pub.count_msg > 0) then
984: for i in 1..fnd_msg_pub.count_msg loop
985: fnd_msg_pub.get (
986: p_msg_index => i,
987: p_data => l_msg_data,

Line 984: for i in 1..fnd_msg_pub.count_msg loop

980:
981: if (x_return_status <> 'S') then
982: x_resultout := 'U';
983: if (fnd_msg_pub.count_msg > 0) then
984: for i in 1..fnd_msg_pub.count_msg loop
985: fnd_msg_pub.get (
986: p_msg_index => i,
987: p_data => l_msg_data,
988: p_encoded => 'F',

Line 985: fnd_msg_pub.get (

981: if (x_return_status <> 'S') then
982: x_resultout := 'U';
983: if (fnd_msg_pub.count_msg > 0) then
984: for i in 1..fnd_msg_pub.count_msg loop
985: fnd_msg_pub.get (
986: p_msg_index => i,
987: p_data => l_msg_data,
988: p_encoded => 'F',
989: p_msg_index_out => l_msg_index_out