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_MESSAGE

Line 187: fnd_message.set_name ('JTF','JTF_RS_LAST_NAME_NULL');

183: --Put all the Validations here
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:

Line 194: fnd_message.set_name ('JTF','JTF_RS_USER_NAME_NULL');

190: end if;
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);

Line 201: fnd_message.set_name ('JTF','JTF_RS_USER_EXISTS');

197: else
198: open c_dup_user_name (l_user_name);
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;

Line 202: fnd_message.set_token ('P_USER_NAME',l_user_name);

198: open c_dup_user_name (l_user_name);
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;

Line 214: fnd_message.set_name ('JTF','JTF_RS_INV_MGR_USER');

210: if l_mgr_user_name is not null then
211: open c_mgr_user_name (l_mgr_user_name);
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

Line 215: fnd_message.set_token ('P_MGR_USER_NAME',l_mgr_user_name);

211: open c_mgr_user_name (l_mgr_user_name);
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);

Line 222: fnd_message.set_name ('JTF','JTF_RS_MGR_INV_RESOURCE');

218: else
219: open c_mgr_resource_id (l_mgr_user_id);
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;

Line 223: fnd_message.set_token ('P_MGR_USER_NAME',l_mgr_user_name);

219: open c_mgr_resource_id (l_mgr_user_id);
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;

Line 234: fnd_message.set_name ('JTF','JTF_RS_NAV_GRP_NULL');

230: end if;
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);

Line 241: fnd_message.set_name ('JTF','JTF_RS_INV_NAV_GRP');

237: else
238: open c_nav_group (l_nav_group1);
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;

Line 242: fnd_message.set_token ('P_NAV_GROUP',l_nav_group1);

238: open c_nav_group (l_nav_group1);
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;

Line 253: fnd_message.set_name ('JTF','JTF_RS_INV_NAV_GRP');

249: if l_nav_group2 is not null then
250: open c_nav_group (l_nav_group2);
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;

Line 254: fnd_message.set_token ('P_NAV_GROUP',l_nav_group2);

250: open c_nav_group (l_nav_group2);
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;

Line 263: fnd_message.set_name ('JTF','JTF_RS_RESP_NAME_NULL');

259: end if;
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);

Line 270: fnd_message.set_name ('JTF','JTF_RS_INV_RESP_NAME');

266: else
267: open c_resp_group (l_resp_group1);
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;

Line 271: fnd_message.set_token ('P_RESP_NAME',l_resp_group1);

267: open c_resp_group (l_resp_group1);
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;

Line 282: fnd_message.set_name ('JTF','JTF_RS_INV_RESP_NAME');

278: if l_resp_group2 is not null then
279: open c_resp_group (l_resp_group2);
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;

Line 283: fnd_message.set_token ('P_RESP_NAME',l_resp_group2);

279: open c_resp_group (l_resp_group2);
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;

Line 295: fnd_message.set_name ('JTF','JTF_RS_INV_NAV_RESP_MAP');

291: if (l_app_family_id1 is not null) AND (l_responsibility_id1 is not null) then
292: open c_nav_resp_group (l_app_family_id1, l_responsibility_id1);
293: fetch c_nav_resp_group into l_num;
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';

Line 296: fnd_message.set_token ('P_RESP_NAME',l_resp_group1);

292: open c_nav_resp_group (l_app_family_id1, l_responsibility_id1);
293: fetch c_nav_resp_group into l_num;
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;

Line 297: fnd_message.set_token ('P_NAV_GROUP',l_nav_group1);

293: fetch c_nav_resp_group into l_num;
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;

Line 308: fnd_message.set_name ('JTF','JTF_RS_INV_NAV_RESP_MAP');

304: if (l_app_family_id2 is not null) AND (l_responsibility_id2 is not null) then
305: open c_nav_resp_group (l_app_family_id2, l_responsibility_id2);
306: fetch c_nav_resp_group into l_num;
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';

Line 309: fnd_message.set_token ('P_RESP_NAME',l_resp_group2);

305: open c_nav_resp_group (l_app_family_id2, l_responsibility_id2);
306: fetch c_nav_resp_group into l_num;
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;

Line 310: fnd_message.set_token ('P_NAV_GROUP',l_nav_group2);

306: fetch c_nav_resp_group into l_num;
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;

Line 322: fnd_message.set_name ('JTF','JTF_RS_INV_RES_GRP');

318: if l_resource_group is not null then
319: open c_res_group (l_resource_group);
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;

Line 323: fnd_message.set_token ('P_RES_GRP',l_resource_group);

319: open c_res_group (l_resource_group);
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;

Line 335: fnd_message.set_name ('JTF','JTF_RS_INV_ROLE_NAME');

331: if l_res_role1 is not null then
332: open c_res_role (l_res_role1);
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;

Line 336: fnd_message.set_token ('P_ROLE_NAME',l_res_role1);

332: open c_res_role (l_res_role1);
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;

Line 347: fnd_message.set_name ('JTF','JTF_RS_INV_ROLE_NAME');

343: if l_res_role2 is not null then
344: open c_res_role (l_res_role2);
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;

Line 348: fnd_message.set_token ('P_ROLE_NAME',l_res_role2);

344: open c_res_role (l_res_role2);
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;

Line 540: fnd_message.set_encoded(l_msg_data1);

536: p_msg_index_out => l_msg_index_out
537: );
538: l_msg_data1 := l_msg_data1||FND_GLOBAL.Local_Chr(10)||l_msg_data;
539: end loop;
540: fnd_message.set_encoded(l_msg_data1);
541: l_error_text := l_msg_data1;
542: end if;
543:
544: fnd_message.set_name ('JTF','JTF_RS_USER_NOT_CREATED');

Line 544: fnd_message.set_name ('JTF','JTF_RS_USER_NOT_CREATED');

540: fnd_message.set_encoded(l_msg_data1);
541: l_error_text := l_msg_data1;
542: end if;
543:
544: fnd_message.set_name ('JTF','JTF_RS_USER_NOT_CREATED');
545: fnd_message.set_token ('P_USER_NAME',l_user_name);
546: l_error_text := fnd_message.get||l_error_text;
547:
548: update_upload_data (

Line 545: fnd_message.set_token ('P_USER_NAME',l_user_name);

541: l_error_text := l_msg_data1;
542: end if;
543:
544: fnd_message.set_name ('JTF','JTF_RS_USER_NOT_CREATED');
545: fnd_message.set_token ('P_USER_NAME',l_user_name);
546: l_error_text := fnd_message.get||l_error_text;
547:
548: update_upload_data (
549: P_TRANSACTION_NO => p_transaction_no,

Line 546: l_error_text := fnd_message.get||l_error_text;

542: end if;
543:
544: fnd_message.set_name ('JTF','JTF_RS_USER_NOT_CREATED');
545: fnd_message.set_token ('P_USER_NAME',l_user_name);
546: l_error_text := fnd_message.get||l_error_text;
547:
548: update_upload_data (
549: P_TRANSACTION_NO => p_transaction_no,
550: P_RECORD_NO => l_record_no,

Line 569: fnd_message.set_name ('JTF','JTF_RS_USER_CRT_WITH_WARNING');

565: x_msg_data => l_msg_data
566: );
567:
568: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
569: fnd_message.set_name ('JTF','JTF_RS_USER_CRT_WITH_WARNING');
570: fnd_message.set_token ('P_USER_NAME',l_user_name);
571: l_error_text := fnd_message.get;
572:
573: fnd_message.set_name ('JTF','JTF_RS_UNABLE_SEND_PASSWD');

Line 570: fnd_message.set_token ('P_USER_NAME',l_user_name);

566: );
567:
568: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
569: fnd_message.set_name ('JTF','JTF_RS_USER_CRT_WITH_WARNING');
570: fnd_message.set_token ('P_USER_NAME',l_user_name);
571: l_error_text := fnd_message.get;
572:
573: fnd_message.set_name ('JTF','JTF_RS_UNABLE_SEND_PASSWD');
574: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;

Line 571: l_error_text := fnd_message.get;

567:
568: if not (l_return_status = fnd_api.g_ret_sts_success) THEN
569: fnd_message.set_name ('JTF','JTF_RS_USER_CRT_WITH_WARNING');
570: fnd_message.set_token ('P_USER_NAME',l_user_name);
571: l_error_text := fnd_message.get;
572:
573: fnd_message.set_name ('JTF','JTF_RS_UNABLE_SEND_PASSWD');
574: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;
575:

Line 573: fnd_message.set_name ('JTF','JTF_RS_UNABLE_SEND_PASSWD');

569: fnd_message.set_name ('JTF','JTF_RS_USER_CRT_WITH_WARNING');
570: fnd_message.set_token ('P_USER_NAME',l_user_name);
571: l_error_text := fnd_message.get;
572:
573: fnd_message.set_name ('JTF','JTF_RS_UNABLE_SEND_PASSWD');
574: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;
575:
576: update_upload_data (
577: P_TRANSACTION_NO => p_transaction_no,

Line 574: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;

570: fnd_message.set_token ('P_USER_NAME',l_user_name);
571: l_error_text := fnd_message.get;
572:
573: fnd_message.set_name ('JTF','JTF_RS_UNABLE_SEND_PASSWD');
574: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;
575:
576: update_upload_data (
577: P_TRANSACTION_NO => p_transaction_no,
578: P_RECORD_NO => l_record_no,

Line 583: fnd_message.set_name ('JTF','JTF_RS_USER_CREATED');

579: P_PROCESS_STATUS => 'W',
580: P_ERROR_TEXT => l_error_text
581: );
582: else
583: fnd_message.set_name ('JTF','JTF_RS_USER_CREATED');
584: fnd_message.set_token ('P_USER_NAME',l_user_name);
585: l_error_text := fnd_message.get;
586:
587: fnd_message.set_name ('JTF','JTF_RS_USER_PASSWD');

Line 584: fnd_message.set_token ('P_USER_NAME',l_user_name);

580: P_ERROR_TEXT => l_error_text
581: );
582: else
583: fnd_message.set_name ('JTF','JTF_RS_USER_CREATED');
584: fnd_message.set_token ('P_USER_NAME',l_user_name);
585: l_error_text := fnd_message.get;
586:
587: fnd_message.set_name ('JTF','JTF_RS_USER_PASSWD');
588: fnd_message.set_token ('P_USER_PASSWD',l_user_password);

Line 585: l_error_text := fnd_message.get;

581: );
582: else
583: fnd_message.set_name ('JTF','JTF_RS_USER_CREATED');
584: fnd_message.set_token ('P_USER_NAME',l_user_name);
585: l_error_text := fnd_message.get;
586:
587: fnd_message.set_name ('JTF','JTF_RS_USER_PASSWD');
588: fnd_message.set_token ('P_USER_PASSWD',l_user_password);
589: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;

Line 587: fnd_message.set_name ('JTF','JTF_RS_USER_PASSWD');

583: fnd_message.set_name ('JTF','JTF_RS_USER_CREATED');
584: fnd_message.set_token ('P_USER_NAME',l_user_name);
585: l_error_text := fnd_message.get;
586:
587: fnd_message.set_name ('JTF','JTF_RS_USER_PASSWD');
588: fnd_message.set_token ('P_USER_PASSWD',l_user_password);
589: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;
590:
591: update_upload_data (

Line 588: fnd_message.set_token ('P_USER_PASSWD',l_user_password);

584: fnd_message.set_token ('P_USER_NAME',l_user_name);
585: l_error_text := fnd_message.get;
586:
587: fnd_message.set_name ('JTF','JTF_RS_USER_PASSWD');
588: fnd_message.set_token ('P_USER_PASSWD',l_user_password);
589: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;
590:
591: update_upload_data (
592: P_TRANSACTION_NO => p_transaction_no,

Line 589: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;

585: l_error_text := fnd_message.get;
586:
587: fnd_message.set_name ('JTF','JTF_RS_USER_PASSWD');
588: fnd_message.set_token ('P_USER_PASSWD',l_user_password);
589: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||fnd_message.get;
590:
591: update_upload_data (
592: P_TRANSACTION_NO => p_transaction_no,
593: P_RECORD_NO => l_record_no,

Line 613: fnd_message.set_encoded(l_msg_data1);

609: p_msg_index_out => l_msg_index_out
610: );
611: l_msg_data1 := l_msg_data1||FND_GLOBAL.Local_Chr(10)||l_msg_data;
612: end loop;
613: fnd_message.set_encoded(l_msg_data1);
614: l_error_text := l_msg_data1;
615: end if;
616:
617: l_error_text := l_error_text||FND_GLOBAL.Local_Chr(10)||sqlcode||' : '||sqlerrm;

Line 661: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

657: set request_id = l_request
658: where transaction_no = p_transaction_no;
659:
660: exception when others then
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;

Line 662: fnd_message.set_token('P_SQLCODE',SQLCODE);

658: where transaction_no = p_transaction_no;
659:
660: exception when others then
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;

Line 663: fnd_message.set_token('P_SQLERRM',SQLERRM);

659:
660: exception when others then
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);

Line 664: fnd_message.set_token('P_API_NAME', l_api_name);

660: exception when others then
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;