eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_IMPORT_USER_PUB dependencies on FND_MSG_PUB

Line 140: fnd_msg_pub.Initialize;

136:
137: BEGIN
138:
139: for i_upload_data in upload_data loop
140: fnd_msg_pub.Initialize;
141:
142: begin
143: savepoint jtf_rs_bulk_import;
144:

Line 188: fnd_msg_pub.add;

184:
185: --Validate Last Name
186: if l_last_name is null then
187: fnd_message.set_name ('JTF','JTF_RS_LAST_NAME_NULL');
188: fnd_msg_pub.add;
189: l_error_flag := 'Y';
190: end if;
191:
192: --Validate User Name

Line 195: fnd_msg_pub.add;

191:
192: --Validate User Name
193: if l_user_name is null then
194: fnd_message.set_name ('JTF','JTF_RS_USER_NAME_NULL');
195: fnd_msg_pub.add;
196: l_error_flag := 'Y';
197: else
198: open c_dup_user_name (l_user_name);
199: fetch c_dup_user_name into l_num;

Line 203: fnd_msg_pub.add;

199: fetch c_dup_user_name into l_num;
200: if c_dup_user_name%found then
201: fnd_message.set_name ('JTF','JTF_RS_USER_EXISTS');
202: fnd_message.set_token ('P_USER_NAME',l_user_name);
203: fnd_msg_pub.add;
204: l_error_flag := 'Y';
205: end if;
206: close c_dup_user_name;
207: end if;

Line 216: fnd_msg_pub.add;

212: fetch c_mgr_user_name into l_mgr_user_id;
213: if c_mgr_user_name%notfound then
214: fnd_message.set_name ('JTF','JTF_RS_INV_MGR_USER');
215: fnd_message.set_token ('P_MGR_USER_NAME',l_mgr_user_name);
216: fnd_msg_pub.add;
217: l_error_flag := 'Y';
218: else
219: open c_mgr_resource_id (l_mgr_user_id);
220: fetch c_mgr_resource_id into l_mgr_resource_id;

Line 224: fnd_msg_pub.add;

220: fetch c_mgr_resource_id into l_mgr_resource_id;
221: if c_mgr_resource_id%notfound then
222: fnd_message.set_name ('JTF','JTF_RS_MGR_INV_RESOURCE');
223: fnd_message.set_token ('P_MGR_USER_NAME',l_mgr_user_name);
224: fnd_msg_pub.add;
225: l_error_flag := 'Y';
226: end if;
227: close c_mgr_resource_id;
228: end if;

Line 235: fnd_msg_pub.add;

231:
232: --Validate Nav Groups
233: if l_nav_group1 is null then
234: fnd_message.set_name ('JTF','JTF_RS_NAV_GRP_NULL');
235: fnd_msg_pub.add;
236: l_error_flag_resp := 'Y';
237: else
238: open c_nav_group (l_nav_group1);
239: fetch c_nav_group into l_app_family_id1;

Line 243: fnd_msg_pub.add;

239: fetch c_nav_group into l_app_family_id1;
240: if c_nav_group%notfound then
241: fnd_message.set_name ('JTF','JTF_RS_INV_NAV_GRP');
242: fnd_message.set_token ('P_NAV_GROUP',l_nav_group1);
243: fnd_msg_pub.add;
244: l_error_flag_resp := 'Y';
245: end if;
246: close c_nav_group;
247: end if;

Line 255: fnd_msg_pub.add;

251: fetch c_nav_group into l_app_family_id2;
252: if c_nav_group%notfound then
253: fnd_message.set_name ('JTF','JTF_RS_INV_NAV_GRP');
254: fnd_message.set_token ('P_NAV_GROUP',l_nav_group2);
255: fnd_msg_pub.add;
256: l_error_flag_resp := 'Y';
257: end if;
258: close c_nav_group;
259: end if;

Line 264: fnd_msg_pub.add;

260:
261: --Validate Responsibility
262: if l_resp_group1 is null then
263: fnd_message.set_name ('JTF','JTF_RS_RESP_NAME_NULL');
264: fnd_msg_pub.add;
265: l_error_flag_resp := 'Y';
266: else
267: open c_resp_group (l_resp_group1);
268: fetch c_resp_group into l_responsibility_id1;

Line 272: fnd_msg_pub.add;

268: fetch c_resp_group into l_responsibility_id1;
269: if c_resp_group%notfound then
270: fnd_message.set_name ('JTF','JTF_RS_INV_RESP_NAME');
271: fnd_message.set_token ('P_RESP_NAME',l_resp_group1);
272: fnd_msg_pub.add;
273: l_error_flag_resp := 'Y';
274: end if;
275: close c_resp_group;
276: end if;

Line 284: fnd_msg_pub.add;

280: fetch c_resp_group into l_responsibility_id2;
281: if c_resp_group%notfound then
282: fnd_message.set_name ('JTF','JTF_RS_INV_RESP_NAME');
283: fnd_message.set_token ('P_RESP_NAME',l_resp_group2);
284: fnd_msg_pub.add;
285: l_error_flag_resp := 'Y';
286: end if;
287: close c_resp_group;
288: end if;

Line 298: fnd_msg_pub.add;

294: if c_nav_resp_group%notfound then
295: fnd_message.set_name ('JTF','JTF_RS_INV_NAV_RESP_MAP');
296: fnd_message.set_token ('P_RESP_NAME',l_resp_group1);
297: fnd_message.set_token ('P_NAV_GROUP',l_nav_group1);
298: fnd_msg_pub.add;
299: l_error_flag_resp := 'Y';
300: end if;
301: close c_nav_resp_group;
302: end if;

Line 311: fnd_msg_pub.add;

307: if c_nav_resp_group%notfound then
308: fnd_message.set_name ('JTF','JTF_RS_INV_NAV_RESP_MAP');
309: fnd_message.set_token ('P_RESP_NAME',l_resp_group2);
310: fnd_message.set_token ('P_NAV_GROUP',l_nav_group2);
311: fnd_msg_pub.add;
312: l_error_flag_resp := 'Y';
313: end if;
314: close c_nav_resp_group;
315: end if;

Line 324: fnd_msg_pub.add;

320: fetch c_res_group into l_group_id;
321: if c_res_group%notfound then
322: fnd_message.set_name ('JTF','JTF_RS_INV_RES_GRP');
323: fnd_message.set_token ('P_RES_GRP',l_resource_group);
324: fnd_msg_pub.add;
325: l_error_flag_grp := 'Y';
326: end if;
327: close c_res_group;
328: end if;

Line 337: fnd_msg_pub.add;

333: fetch c_res_role into l_role_id1, l_role_code1;
334: if c_res_role%notfound then
335: fnd_message.set_name ('JTF','JTF_RS_INV_ROLE_NAME');
336: fnd_message.set_token ('P_ROLE_NAME',l_res_role1);
337: fnd_msg_pub.add;
338: l_error_flag_role := 'Y';
339: end if;
340: close c_res_role;
341: end if;

Line 349: fnd_msg_pub.add;

345: fetch c_res_role into l_role_id2, l_role_code2;
346: if c_res_role%notfound then
347: fnd_message.set_name ('JTF','JTF_RS_INV_ROLE_NAME');
348: fnd_message.set_token ('P_ROLE_NAME',l_res_role2);
349: fnd_msg_pub.add;
350: l_error_flag_role := 'Y';
351: end if;
352: close c_res_role;
353: end if;

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

526: end if;
527:
528: if (l_error_flag = 'Y' OR l_error_flag_resp = 'Y' OR
529: l_error_flag_grp = 'Y' OR l_error_flag_role = 'Y') then
530: if (fnd_msg_pub.count_msg > 0) then
531: for i in 1..fnd_msg_pub.count_msg loop
532: fnd_msg_pub.get
533: (p_msg_index => i,
534: p_data => l_msg_data,

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

527:
528: if (l_error_flag = 'Y' OR l_error_flag_resp = 'Y' OR
529: l_error_flag_grp = 'Y' OR l_error_flag_role = 'Y') then
530: if (fnd_msg_pub.count_msg > 0) then
531: for i in 1..fnd_msg_pub.count_msg loop
532: fnd_msg_pub.get
533: (p_msg_index => i,
534: p_data => l_msg_data,
535: p_encoded => 'F',

Line 532: fnd_msg_pub.get

528: if (l_error_flag = 'Y' OR l_error_flag_resp = 'Y' OR
529: l_error_flag_grp = 'Y' OR l_error_flag_role = 'Y') then
530: if (fnd_msg_pub.count_msg > 0) then
531: for i in 1..fnd_msg_pub.count_msg loop
532: fnd_msg_pub.get
533: (p_msg_index => i,
534: p_data => l_msg_data,
535: p_encoded => 'F',
536: p_msg_index_out => l_msg_index_out

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

599: end if;
600:
601: exception
602: when others then
603: if (fnd_msg_pub.count_msg > 0) then
604: for i in 1..fnd_msg_pub.count_msg loop
605: fnd_msg_pub.get
606: (p_msg_index => i,
607: p_data => l_msg_data,

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

600:
601: exception
602: when others then
603: if (fnd_msg_pub.count_msg > 0) then
604: for i in 1..fnd_msg_pub.count_msg loop
605: fnd_msg_pub.get
606: (p_msg_index => i,
607: p_data => l_msg_data,
608: p_encoded => 'F',

Line 605: fnd_msg_pub.get

601: exception
602: when others then
603: if (fnd_msg_pub.count_msg > 0) then
604: for i in 1..fnd_msg_pub.count_msg loop
605: fnd_msg_pub.get
606: (p_msg_index => i,
607: p_data => l_msg_data,
608: p_encoded => 'F',
609: p_msg_index_out => l_msg_index_out

Line 665: FND_MSG_PUB.add;

661: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
662: fnd_message.set_token('P_SQLCODE',SQLCODE);
663: fnd_message.set_token('P_SQLERRM',SQLERRM);
664: fnd_message.set_token('P_API_NAME', l_api_name);
665: FND_MSG_PUB.add;
666: x_return_status := fnd_api.g_ret_sts_unexp_error;
667: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
668: RAISE fnd_api.g_exc_unexpected_error;
669:

Line 667: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

663: fnd_message.set_token('P_SQLERRM',SQLERRM);
664: fnd_message.set_token('P_API_NAME', l_api_name);
665: FND_MSG_PUB.add;
666: x_return_status := fnd_api.g_ret_sts_unexp_error;
667: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
668: RAISE fnd_api.g_exc_unexpected_error;
669:
670: END import_user;
671: