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.IBE_PHYSICALMAP_GRP dependencies on FND_MESSAGE

Line 257: FND_MESSAGE.set_name(

253: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
254: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
255:
256: IF l_default_msite = g_yes THEN
257: FND_MESSAGE.set_name(
258: 'IBE',
259: 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
260: FND_MESSAGE.set_token(
261: 'LANG',

Line 260: FND_MESSAGE.set_token(

256: IF l_default_msite = g_yes THEN
257: FND_MESSAGE.set_name(
258: 'IBE',
259: 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
260: FND_MESSAGE.set_token(
261: 'LANG',
262: p_language_code_tbl(l_index));
263: ELSE
264: FND_MESSAGE.set_name(

Line 264: FND_MESSAGE.set_name(

260: FND_MESSAGE.set_token(
261: 'LANG',
262: p_language_code_tbl(l_index));
263: ELSE
264: FND_MESSAGE.set_name(
265: 'IBE',
266: 'IBE_DSP_PHYSMAP_EXISTS');
267: FND_MESSAGE.set_token(
268: 'MSITE_ID',

Line 267: FND_MESSAGE.set_token(

263: ELSE
264: FND_MESSAGE.set_name(
265: 'IBE',
266: 'IBE_DSP_PHYSMAP_EXISTS');
267: FND_MESSAGE.set_token(
268: 'MSITE_ID',
269: TO_CHAR(l_msite_id));
270: FND_MESSAGE.set_token(
271: 'LANG',

Line 270: FND_MESSAGE.set_token(

266: 'IBE_DSP_PHYSMAP_EXISTS');
267: FND_MESSAGE.set_token(
268: 'MSITE_ID',
269: TO_CHAR(l_msite_id));
270: FND_MESSAGE.set_token(
271: 'LANG',
272: p_language_code_tbl(l_index));
273: END IF;
274: FND_MESSAGE.set_token(

Line 274: FND_MESSAGE.set_token(

270: FND_MESSAGE.set_token(
271: 'LANG',
272: p_language_code_tbl(l_index));
273: END IF;
274: FND_MESSAGE.set_token(
275: 'ID',
276: TO_CHAR(l_deliverable_id));
277: FND_MSG_PUB.add;
278: END IF;

Line 337: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');

333: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
334:
335: --added by YAXU on 08/02/2002
336: IF l_default_msite = g_yes and l_default_lang = g_yes THEN
337: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');
338: END IF;
339: IF l_default_msite = g_yes and l_default_lang = g_no THEN
340: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
341: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));

Line 340: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');

336: IF l_default_msite = g_yes and l_default_lang = g_yes THEN
337: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');
338: END IF;
339: IF l_default_msite = g_yes and l_default_lang = g_no THEN
340: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
341: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));
342: END IF;
343: IF l_default_msite = g_no and l_default_lang = g_yes THEN
344: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');

Line 341: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));

337: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');
338: END IF;
339: IF l_default_msite = g_yes and l_default_lang = g_no THEN
340: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
341: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));
342: END IF;
343: IF l_default_msite = g_no and l_default_lang = g_yes THEN
344: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');
345: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));

Line 344: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');

340: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
341: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));
342: END IF;
343: IF l_default_msite = g_no and l_default_lang = g_yes THEN
344: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');
345: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
346: END IF;
347: IF l_default_msite = g_no and l_default_lang = g_no THEN
348: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_EXISTS');

Line 345: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));

341: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));
342: END IF;
343: IF l_default_msite = g_no and l_default_lang = g_yes THEN
344: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');
345: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
346: END IF;
347: IF l_default_msite = g_no and l_default_lang = g_no THEN
348: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_EXISTS');
349: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));

Line 348: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_EXISTS');

344: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');
345: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
346: END IF;
347: IF l_default_msite = g_no and l_default_lang = g_no THEN
348: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_EXISTS');
349: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));
350: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
351: END IF;
352: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));

Line 349: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));

345: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
346: END IF;
347: IF l_default_msite = g_no and l_default_lang = g_no THEN
348: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_EXISTS');
349: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));
350: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
351: END IF;
352: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
353: FND_MSG_PUB.add;

Line 350: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));

346: END IF;
347: IF l_default_msite = g_no and l_default_lang = g_no THEN
348: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_EXISTS');
349: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));
350: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
351: END IF;
352: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
353: FND_MSG_PUB.add;
354:

Line 352: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));

348: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_EXISTS');
349: FND_MESSAGE.set_token('LANG', p_language_code_tbl(l_index));
350: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
351: END IF;
352: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
353: FND_MSG_PUB.add;
354:
355: END IF;
356:

Line 682: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');

678: WHERE lgl_phys_map_id = p_lgl_phys_map_id_tbl(l_index);
679: IF SQL%NOTFOUND THEN
680: -- RAISE IBE_DSPMGRVALIDATION_GRP.physmap_not_exists_exception;
681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
682: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
683: FND_MESSAGE.set_token(
684: 'ID',
685: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
686: FND_MSG_PUB.add;

Line 683: FND_MESSAGE.set_token(

679: IF SQL%NOTFOUND THEN
680: -- RAISE IBE_DSPMGRVALIDATION_GRP.physmap_not_exists_exception;
681: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
682: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
683: FND_MESSAGE.set_token(
684: 'ID',
685: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
686: FND_MSG_PUB.add;
687: END IF;

Line 706: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');

702: /*
703: WHEN IBE_DSPMGRVALIDATION_GRP.physmap_not_exists_exception THEN
704: -- only warning; no error
705: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
706: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
707: FND_MESSAGE.set_token(
708: 'ID',
709: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
710: FND_MSG_PUB.add;

Line 707: FND_MESSAGE.set_token(

703: WHEN IBE_DSPMGRVALIDATION_GRP.physmap_not_exists_exception THEN
704: -- only warning; no error
705: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
706: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_NOT_EXISTS');
707: FND_MESSAGE.set_token(
708: 'ID',
709: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
710: FND_MSG_PUB.add;
711: END IF;

Line 1393: FND_MESSAGE.set_name('IBE',

1389: IF FND_MSG_PUB.check_msg_level
1390: (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1391: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1392: IF l_default_msite = g_yes THEN
1393: FND_MESSAGE.set_name('IBE',
1394: 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
1395: FND_MESSAGE.set_token('LANG',
1396: p_language_code_tbl(l_index));
1397: ELSE

Line 1395: FND_MESSAGE.set_token('LANG',

1391: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1392: IF l_default_msite = g_yes THEN
1393: FND_MESSAGE.set_name('IBE',
1394: 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
1395: FND_MESSAGE.set_token('LANG',
1396: p_language_code_tbl(l_index));
1397: ELSE
1398: FND_MESSAGE.set_name('IBE',
1399: 'IBE_DSP_PHYSMAP_EXISTS');

Line 1398: FND_MESSAGE.set_name('IBE',

1394: 'IBE_DSP_PHYSMAP_ALL_LNG_EXISTS');
1395: FND_MESSAGE.set_token('LANG',
1396: p_language_code_tbl(l_index));
1397: ELSE
1398: FND_MESSAGE.set_name('IBE',
1399: 'IBE_DSP_PHYSMAP_EXISTS');
1400: FND_MESSAGE.set_token('MSITE_ID',
1401: TO_CHAR(l_msite_id));
1402: FND_MESSAGE.set_token(

Line 1400: FND_MESSAGE.set_token('MSITE_ID',

1396: p_language_code_tbl(l_index));
1397: ELSE
1398: FND_MESSAGE.set_name('IBE',
1399: 'IBE_DSP_PHYSMAP_EXISTS');
1400: FND_MESSAGE.set_token('MSITE_ID',
1401: TO_CHAR(l_msite_id));
1402: FND_MESSAGE.set_token(
1403: 'LANG', p_language_code_tbl(l_index));
1404: END IF;

Line 1402: FND_MESSAGE.set_token(

1398: FND_MESSAGE.set_name('IBE',
1399: 'IBE_DSP_PHYSMAP_EXISTS');
1400: FND_MESSAGE.set_token('MSITE_ID',
1401: TO_CHAR(l_msite_id));
1402: FND_MESSAGE.set_token(
1403: 'LANG', p_language_code_tbl(l_index));
1404: END IF;
1405: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
1406: FND_MSG_PUB.add;

Line 1405: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));

1401: TO_CHAR(l_msite_id));
1402: FND_MESSAGE.set_token(
1403: 'LANG', p_language_code_tbl(l_index));
1404: END IF;
1405: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
1406: FND_MSG_PUB.add;
1407: END IF;
1408: WHEN OTHERS THEN
1409: ROLLBACK TO SAVE_ONE_PHYSICALMAP;

Line 1447: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');

1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1444: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1445:
1446: IF l_default_msite = g_yes and l_default_lang = g_yes THEN
1447: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');
1448: END IF;
1449: IF l_default_msite = g_no and l_default_lang = g_yes THEN
1450: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');
1451: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));

Line 1450: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');

1446: IF l_default_msite = g_yes and l_default_lang = g_yes THEN
1447: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');
1448: END IF;
1449: IF l_default_msite = g_no and l_default_lang = g_yes THEN
1450: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');
1451: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
1452: END IF;
1453: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
1454: FND_MSG_PUB.add;

Line 1451: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));

1447: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_ALL_ALL_EXISTS');
1448: END IF;
1449: IF l_default_msite = g_no and l_default_lang = g_yes THEN
1450: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');
1451: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
1452: END IF;
1453: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
1454: FND_MSG_PUB.add;
1455:

Line 1453: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));

1449: IF l_default_msite = g_no and l_default_lang = g_yes THEN
1450: FND_MESSAGE.set_name('IBE', 'IBE_DSP_PHYSMAP_STE_ALL_EXISTS');
1451: FND_MESSAGE.set_token('MSITE_ID', TO_CHAR(l_msite_id));
1452: END IF;
1453: FND_MESSAGE.set_token('ID', TO_CHAR(l_deliverable_id));
1454: FND_MSG_PUB.add;
1455:
1456: END IF;
1457:

Line 1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1463:
1464:
1465: WHEN OTHERS THEN
1466: ROLLBACK TO SAVE_PHYSICALMAP;
1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_MSG_PUB.Add;

Line 1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1464:
1465: WHEN OTHERS THEN
1466: ROLLBACK TO SAVE_PHYSICALMAP;
1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1465: WHEN OTHERS THEN
1466: ROLLBACK TO SAVE_PHYSICALMAP;
1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1466: ROLLBACK TO SAVE_PHYSICALMAP;
1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1474: THEN

Line 1627: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1623: p_data => x_msg_data,
1624: p_encoded => 'F');
1625: WHEN OTHERS THEN
1626: ROLLBACK TO SAVE_PHYSICALMAP;
1627: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1628: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1629: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1630: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1631: FND_MSG_PUB.Add;

Line 1628: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1624: p_encoded => 'F');
1625: WHEN OTHERS THEN
1626: ROLLBACK TO SAVE_PHYSICALMAP;
1627: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1628: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1629: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1630: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1631: FND_MSG_PUB.Add;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1629: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1625: WHEN OTHERS THEN
1626: ROLLBACK TO SAVE_PHYSICALMAP;
1627: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1628: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1629: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1630: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1631: FND_MSG_PUB.Add;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1630: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1626: ROLLBACK TO SAVE_PHYSICALMAP;
1627: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1628: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1629: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1630: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1631: FND_MSG_PUB.Add;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1634: THEN

Line 1746: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1742: p_data => x_msg_data,
1743: p_encoded => 'F');
1744: WHEN OTHERS THEN
1745: ROLLBACK TO DELETE_PHYSICALMAP;
1746: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1747: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1748: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1749: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1750: FND_MSG_PUB.Add;

Line 1747: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1743: p_encoded => 'F');
1744: WHEN OTHERS THEN
1745: ROLLBACK TO DELETE_PHYSICALMAP;
1746: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1747: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1748: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1749: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1750: FND_MSG_PUB.Add;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1748: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1744: WHEN OTHERS THEN
1745: ROLLBACK TO DELETE_PHYSICALMAP;
1746: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1747: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1748: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1749: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1750: FND_MSG_PUB.Add;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1749: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1745: ROLLBACK TO DELETE_PHYSICALMAP;
1746: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1747: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1748: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1749: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1750: FND_MSG_PUB.Add;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1753: THEN

Line 1831: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1827: p_data => x_msg_data,
1828: p_encoded => 'F');
1829: WHEN OTHERS THEN
1830: ROLLBACK TO REPLACE_CONTENT;
1831: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1832: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1833: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1834: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1835: FND_MSG_PUB.Add;

Line 1832: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1828: p_encoded => 'F');
1829: WHEN OTHERS THEN
1830: ROLLBACK TO REPLACE_CONTENT;
1831: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1832: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1833: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1834: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1835: FND_MSG_PUB.Add;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1833: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1829: WHEN OTHERS THEN
1830: ROLLBACK TO REPLACE_CONTENT;
1831: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1832: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1833: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1834: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1835: FND_MSG_PUB.Add;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1834: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1830: ROLLBACK TO REPLACE_CONTENT;
1831: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1832: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1833: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1834: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1835: FND_MSG_PUB.Add;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1838: THEN