DBA Data[Home] [Help]

APPS.IEU_WORK_SOURCE_PVT dependencies on FND_MSG_PUB

Line 71: fnd_msg_pub.delete_msg();

67: l_yes := 'Y';
68: l_no := 'N';
69: l_ws_not_valid_flag := 'Y';
70: l_deactive_time := sysdate-1;
71: fnd_msg_pub.delete_msg();
72: x_return_status := fnd_api.g_ret_sts_success;
73: FND_MSG_PUB.initialize;
74: x_msg_data := '';
75: select to_char(sysdate, 'yyyy/mm/dd') into l_temp_date from dual;

Line 73: FND_MSG_PUB.initialize;

69: l_ws_not_valid_flag := 'Y';
70: l_deactive_time := sysdate-1;
71: fnd_msg_pub.delete_msg();
72: x_return_status := fnd_api.g_ret_sts_success;
73: FND_MSG_PUB.initialize;
74: x_msg_data := '';
75: select to_char(sysdate, 'yyyy/mm/dd') into l_temp_date from dual;
76: l_language := FND_GLOBAL.CURRENT_LANGUAGE;
77: -- for update description and dis function for not active case,

Line 257: fnd_msg_pub.delete_msg();

253:
254:
255: begin
256: l_not_valid_flag := 'N';
257: fnd_msg_pub.delete_msg();
258: x_return_status := fnd_api.g_ret_sts_success;
259: FND_MSG_PUB.initialize;
260: x_msg_data := '';
261: -- nothing need to check here since distribution function already be checked in javabean

Line 259: FND_MSG_PUB.initialize;

255: begin
256: l_not_valid_flag := 'N';
257: fnd_msg_pub.delete_msg();
258: x_return_status := fnd_api.g_ret_sts_success;
259: FND_MSG_PUB.initialize;
260: x_msg_data := '';
261: -- nothing need to check here since distribution function already be checked in javabean
262: -- check work source name and work source code
263: EXECUTE IMMEDIATE ' select count(*) from ieu_uwqm_work_sources_b where upper(ws_code) = upper(:1) and not_valid_flag=:2 '