DBA Data[Home] [Help]

APPS.IEM_DBLINK_PVT dependencies on FND_MESSAGE

Line 241: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_OES_NOT_FOUND');

237: p_data => x_msg_data
238: );
239: EXCEPTION
240: WHEN oes_not_found THEN
241: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_OES_NOT_FOUND');
242: FND_MSG_PUB.Add;
243: x_return_status := FND_API.G_RET_STS_ERROR ;
244: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
245: -- database link creation cannot be rolled back, it must be dropped manually

Line 258: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_GLNAME_INVALID');

254: l_num := DBMS_SQL.EXECUTE(l_v_id);
255: DBMS_SQL.CLOSE_CURSOR(l_v_id);
256: end if;
257: -- ROLLBACK TO CREATE_LINK_PVT;
258: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_GLNAME_INVALID');
259: FND_MSG_PUB.Add;
260: x_return_status := FND_API.G_RET_STS_ERROR ;
261: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
262:

Line 276: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_GLNAME_INVALID');

272: DBMS_SQL.CLOSE_CURSOR(l_v_id);
273: end if;
274:
275: -- ROLLBACK TO CREATE_LINK_PVT;
276: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_GLNAME_INVALID');
277: FND_MSG_PUB.Add;
278: x_return_status := FND_API.G_RET_STS_ERROR ;
279: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
280: WHEN db_name_invalid THEN

Line 292: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_PSWD_GLNAME_INVALID');

288: DBMS_SQL.CLOSE_CURSOR(l_v_id);
289: end if;
290:
291: -- ROLLBACK TO CREATE_LINK_PVT;
292: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_PSWD_GLNAME_INVALID');
293: FND_MSG_PUB.Add;
294: x_return_status := FND_API.G_RET_STS_ERROR ;
295: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
296: WHEN db_name_invalid_spc THEN

Line 308: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_GLNAME_INVALID');

304: DBMS_SQL.CLOSE_CURSOR(l_v_id);
305: end if;
306:
307: -- ROLLBACK TO CREATE_LINK_PVT;
308: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_GLNAME_INVALID');
309: FND_MSG_PUB.Add;
310: x_return_status := FND_API.G_RET_STS_ERROR ;
311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
312:

Line 326: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_GLNAME_INVALID');

322: DBMS_SQL.CLOSE_CURSOR(l_v_id);
323: end if;
324:
325: -- ROLLBACK TO CREATE_LINK_PVT;
326: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_GLNAME_INVALID');
327: FND_MSG_PUB.Add;
328: x_return_status := FND_API.G_RET_STS_ERROR ;
329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
330: WHEN login_denied THEN

Line 342: FND_MESSAGE.SET_NAME('IEM','IEM_DBLINK_LOGIN_DENIED');

338: DBMS_SQL.CLOSE_CURSOR(l_v_id);
339: end if;
340:
341: -- ROLLBACK TO CREATE_LINK_PVT;
342: FND_MESSAGE.SET_NAME('IEM','IEM_DBLINK_LOGIN_DENIED');
343: FND_MSG_PUB.Add;
344: x_return_status := FND_API.G_RET_STS_ERROR ;
345: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
346:

Line 359: FND_MESSAGE.SET_NAME('IEM','IEM_DBLINK_LOGIN_DENIED');

355: DBMS_SQL.CLOSE_CURSOR(l_v_id);
356: end if;
357:
358: -- ROLLBACK TO CREATE_LINK_PVT;
359: FND_MESSAGE.SET_NAME('IEM','IEM_DBLINK_LOGIN_DENIED');
360: FND_MSG_PUB.Add;
361: x_return_status := FND_API.G_RET_STS_ERROR ;
362: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
363:

Line 376: FND_MESSAGE.SET_NAME('IEM','IEM_DBLINK_LOGIN_DENIED');

372: DBMS_SQL.CLOSE_CURSOR(l_v_id);
373: end if;
374:
375: -- ROLLBACK TO CREATE_LINK_PVT;
376: FND_MESSAGE.SET_NAME('IEM','IEM_DBLINK_LOGIN_DENIED');
377: FND_MSG_PUB.Add;
378: x_return_status := FND_API.G_RET_STS_ERROR ;
379: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
380:

Line 385: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_DB_LINK');

381: WHEN duplicate_db_link THEN
382:
383: -- don't drop database link as rollback as this drop the links for the existing link.
384: -- ROLLBACK TO CREATE_LINK_PVT;
385: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_DB_LINK');
386: FND_MSG_PUB.Add;
387: x_return_status := FND_API.G_RET_STS_ERROR ;
388: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
389:

Line 394: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_DB_LINK');

390: WHEN db_link_exist THEN
391:
392: -- don't drop database link as rollback as this drop the links for the existing link.
393: -- ROLLBACK TO CREATE_LINK_PVT;
394: FND_MESSAGE.SET_NAME('IEM','IEM_DUPLICATE_DB_LINK');
395: FND_MSG_PUB.Add;
396: x_return_status := FND_API.G_RET_STS_ERROR ;
397: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
398:

Line 411: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_PROTOCOL_NOT_VALID');

407: DBMS_SQL.CLOSE_CURSOR(l_v_id);
408: end if;
409:
410: -- ROLLBACK TO CREATE_LINK_PVT;
411: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_PROTOCOL_NOT_VALID');
412: FND_MSG_PUB.Add;
413: x_return_status := FND_API.G_RET_STS_ERROR ;
414: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
415: WHEN sid_invalid THEN

Line 427: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_SID_NOT_VALID');

423: DBMS_SQL.CLOSE_CURSOR(l_v_id);
424: end if;
425:
426: -- ROLLBACK TO CREATE_LINK_PVT;
427: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_SID_NOT_VALID');
428: FND_MSG_PUB.Add;
429: x_return_status := FND_API.G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
431: WHEN tns_no_listener THEN

Line 443: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_TNS_NO_LISTENER');

439: DBMS_SQL.CLOSE_CURSOR(l_v_id);
440: end if;
441:
442: -- ROLLBACK TO CREATE_LINK_PVT;
443: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_TNS_NO_LISTENER');
444: FND_MSG_PUB.Add;
445: x_return_status := FND_API.G_RET_STS_ERROR ;
446: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
447: WHEN host_invalid THEN

Line 459: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_HOST_INVALID');

455: DBMS_SQL.CLOSE_CURSOR(l_v_id);
456: end if;
457:
458: -- ROLLBACK TO CREATE_LINK_PVT;
459: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_HOST_INVALID');
460: FND_MSG_PUB.Add;
461: x_return_status := FND_API.G_RET_STS_ERROR ;
462: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
463:

Line 476: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_HOST_INVALID');

472: DBMS_SQL.CLOSE_CURSOR(l_v_id);
473: end if;
474:
475: -- ROLLBACK TO CREATE_LINK_PVT;
476: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_HOST_INVALID');
477: FND_MSG_PUB.Add;
478: x_return_status := FND_API.G_RET_STS_ERROR ;
479: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
480:

Line 493: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_DBCONN_DESC_INVALID');

489: DBMS_SQL.CLOSE_CURSOR(l_v_id);
490: end if;
491:
492: -- ROLLBACK TO CREATE_LINK_PVT;
493: FND_MESSAGE.SET_NAME('IEM','IEM_SSS_DBCONN_DESC_INVALID');
494: FND_MSG_PUB.Add;
495: x_return_status := FND_API.G_RET_STS_ERROR ;
496: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
497:

Line 549: -- FND_MESSAGE.SET_NAME('IEM','IEM_LINK_LOGIN_DENIED');

545: end if;
546:
547: -- end if;
548: -- ROLLBACK TO CREATE_LINK_PVT;
549: -- FND_MESSAGE.SET_NAME('IEM','IEM_LINK_LOGIN_DENIED');
550: -- FND_MSG_PUB.Add;
551: x_return_status := FND_API.G_RET_STS_ERROR ;
552: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
553: IF FND_MSG_PUB.Check_Msg_Level

Line 700: FND_MESSAGE.SET_NAME('IEM','IEM_LINK_DOES_NOT_EXIST');

696: ( p_count => x_msg_count,
697: p_data => x_msg_data
698: );
699: WHEN OTHERS THEN
700: FND_MESSAGE.SET_NAME('IEM','IEM_LINK_DOES_NOT_EXIST');
701: FND_MSG_PUB.Add;
702: x_return_status := FND_API.G_RET_STS_ERROR ;
703: --FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
704: --ROLLBACK TO delete_link_pvt;