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

Line 231: FND_MESSAGE.Set_Name(g_app_name, l_message);

227: END IF;
228:
229: IF (l_message IS NOT NULL)
230: THEN
231: FND_MESSAGE.Set_Name(g_app_name, l_message);
232: FND_MSG_PUB.Add;
233: FND_MSG_PUB.Count_And_Get(
234: p_encoded => FND_API.G_FALSE,
235: p_count => x_msg_count,

Line 247: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

243: EXCEPTION
244: WHEN OTHERS THEN
245: x_delete_ok := FND_API.G_FALSE;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
248: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
249: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
250: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
251: FND_MSG_PUB.Add;

Line 248: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

244: WHEN OTHERS THEN
245: x_delete_ok := FND_API.G_FALSE;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
248: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
249: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
250: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
251: FND_MSG_PUB.Add;
252: FND_MSG_PUB.Count_And_Get(

Line 249: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

245: x_delete_ok := FND_API.G_FALSE;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
248: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
249: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
250: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
251: FND_MSG_PUB.Add;
252: FND_MSG_PUB.Count_And_Get(
253: p_encoded => FND_API.G_FALSE,

Line 250: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
248: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
249: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
250: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
251: FND_MSG_PUB.Add;
252: FND_MSG_PUB.Count_And_Get(
253: p_encoded => FND_API.G_FALSE,
254: p_count => x_msg_count,

Line 529: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

525: IF c_get_assoc_category_id%ISOPEN THEN
526: CLOSE c_get_assoc_category_id;
527: END IF;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
530: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
531: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
532: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
533: FND_MSG_PUB.Add;

Line 530: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

526: CLOSE c_get_assoc_category_id;
527: END IF;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
530: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
531: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
532: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
533: FND_MSG_PUB.Add;
534: FND_MSG_PUB.Count_And_Get(

Line 531: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

527: END IF;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
530: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
531: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
532: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
533: FND_MSG_PUB.Add;
534: FND_MSG_PUB.Count_And_Get(
535: p_encoded => FND_API.G_FALSE,

Line 532: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
530: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
531: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
532: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
533: FND_MSG_PUB.Add;
534: FND_MSG_PUB.Count_And_Get(
535: p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,

Line 639: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

635:
636: EXCEPTION
637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
640: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
641: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
642: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
643: FND_MSG_PUB.Add;

Line 640: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

636: EXCEPTION
637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
640: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
641: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
642: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
643: FND_MSG_PUB.Add;
644: FND_MSG_PUB.Count_And_Get(

Line 641: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
640: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
641: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
642: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
643: FND_MSG_PUB.Add;
644: FND_MSG_PUB.Count_And_Get(
645: p_encoded => FND_API.G_FALSE,

Line 642: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
640: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
641: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
642: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
643: FND_MSG_PUB.Add;
644: FND_MSG_PUB.Count_And_Get(
645: p_encoded => FND_API.G_FALSE,
646: p_count => x_msg_count,

Line 724: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

720: WHEN NO_DATA_FOUND THEN
721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722: WHEN OTHERS THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
725: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
726: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
727: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
728: FND_MSG_PUB.Add;

Line 725: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722: WHEN OTHERS THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
725: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
726: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
727: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
728: FND_MSG_PUB.Add;
729: FND_MSG_PUB.Count_And_Get(

Line 726: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

722: WHEN OTHERS THEN
723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
725: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
726: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
727: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
728: FND_MSG_PUB.Add;
729: FND_MSG_PUB.Count_And_Get(
730: p_encoded => FND_API.G_FALSE,

Line 727: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
724: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
725: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
726: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
727: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
728: FND_MSG_PUB.Add;
729: FND_MSG_PUB.Count_And_Get(
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,

Line 970: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

966: IF FND_API.To_Boolean(p_commit) THEN
967: ROLLBACK TO Sync_Phase_Change_PUB;
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
971: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
972: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
973: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
974: FND_MSG_PUB.Add;

Line 971: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

967: ROLLBACK TO Sync_Phase_Change_PUB;
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
971: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
972: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
973: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
974: FND_MSG_PUB.Add;
975: FND_MSG_PUB.Count_And_Get(

Line 972: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
971: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
972: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
973: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
974: FND_MSG_PUB.Add;
975: FND_MSG_PUB.Count_And_Get(
976: p_encoded => FND_API.G_FALSE,

Line 973: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
970: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
971: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
972: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
973: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
974: FND_MSG_PUB.Add;
975: FND_MSG_PUB.Count_And_Get(
976: p_encoded => FND_API.G_FALSE,
977: p_count => x_msg_count,

Line 1244: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

1240: IF FND_API.To_Boolean(p_commit) THEN
1241: ROLLBACK TO Sync_Phase_Change_PUB;
1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1245: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1246: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1247: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1248: FND_MSG_PUB.Add;

Line 1245: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

1241: ROLLBACK TO Sync_Phase_Change_PUB;
1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1245: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1246: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1247: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1248: FND_MSG_PUB.Add;
1249: FND_MSG_PUB.Count_And_Get(

Line 1246: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1245: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1246: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1247: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1248: FND_MSG_PUB.Add;
1249: FND_MSG_PUB.Count_And_Get(
1250: p_encoded => FND_API.G_FALSE,

Line 1247: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

1243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1244: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1245: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1246: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1247: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1248: FND_MSG_PUB.Add;
1249: FND_MSG_PUB.Count_And_Get(
1250: p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,

Line 1449: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_DUP_ERR');

1445: IF (FND_API.To_Boolean(p_commit)) THEN
1446: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1447: END IF;
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_DUP_ERR');
1450: FND_MSG_PUB.Add;
1451: FND_MSG_PUB.Count_And_Get(
1452: p_encoded => FND_API.G_FALSE,
1453: p_count => x_msg_count,

Line 1461: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_TRACK_EXISTS');

1457: IF (FND_API.To_Boolean(p_commit)) THEN
1458: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1459: END IF;
1460: x_return_status := FND_API.G_RET_STS_ERROR;
1461: FND_MESSAGE.Set_Name(g_app_name, 'EGO_ITEM_PROJ_TRACK_EXISTS');
1462: FND_MSG_PUB.Add;
1463: FND_MSG_PUB.Count_And_Get(
1464: p_encoded => FND_API.G_FALSE,
1465: p_count => x_msg_count,

Line 1485: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

1481: IF (FND_API.To_Boolean(p_commit)) THEN
1482: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1483: END IF;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1486: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1487: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1488: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1489: FND_MSG_PUB.Add;

Line 1486: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

1482: ROLLBACK TO Create_Proj_Item_Assoc_PUB;
1483: END IF;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1486: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1487: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1488: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1489: FND_MSG_PUB.Add;
1490: FND_MSG_PUB.Count_And_Get(

Line 1487: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

1483: END IF;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1486: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1487: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1488: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1489: FND_MSG_PUB.Add;
1490: FND_MSG_PUB.Count_And_Get(
1491: p_encoded => FND_API.G_FALSE,

Line 1488: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1486: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1487: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1488: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1489: FND_MSG_PUB.Add;
1490: FND_MSG_PUB.Count_And_Get(
1491: p_encoded => FND_API.G_FALSE,
1492: p_count => x_msg_count,

Line 1616: FND_MESSAGE.Set_Name(g_app_name, 'EGO_IPI_INSUFFICIENT_PARAMS');

1612: p_association_code IS NULL OR
1613: p_dest_item_id IS NULL OR
1614: p_dest_org_id IS NULL
1615: ) THEN
1616: FND_MESSAGE.Set_Name(g_app_name, 'EGO_IPI_INSUFFICIENT_PARAMS');
1617: FND_MESSAGE.Set_Token('PROG_NAME', g_pkg_name||'.'||l_api_name);
1618: FND_MSG_PUB.Add;
1619: RAISE FND_API.G_EXC_ERROR;
1620: END IF;

Line 1617: FND_MESSAGE.Set_Token('PROG_NAME', g_pkg_name||'.'||l_api_name);

1613: p_dest_item_id IS NULL OR
1614: p_dest_org_id IS NULL
1615: ) THEN
1616: FND_MESSAGE.Set_Name(g_app_name, 'EGO_IPI_INSUFFICIENT_PARAMS');
1617: FND_MESSAGE.Set_Token('PROG_NAME', g_pkg_name||'.'||l_api_name);
1618: FND_MSG_PUB.Add;
1619: RAISE FND_API.G_EXC_ERROR;
1620: END IF;
1621:

Line 1665: FND_MESSAGE.Set_Name(g_app_name, 'EGO_GENERIC_MSG_TEXT');

1661: x_return_status := l_return_status;
1662: END IF;
1663: IF l_msg_count = 1 THEN
1664: -- add the fetched message into error stack
1665: FND_MESSAGE.Set_Name(g_app_name, 'EGO_GENERIC_MSG_TEXT');
1666: FND_MESSAGE.Set_Token('MESSAGE', l_msg_data);
1667: FND_MSG_PUB.Add;
1668: END IF;
1669: END IF;

Line 1666: FND_MESSAGE.Set_Token('MESSAGE', l_msg_data);

1662: END IF;
1663: IF l_msg_count = 1 THEN
1664: -- add the fetched message into error stack
1665: FND_MESSAGE.Set_Name(g_app_name, 'EGO_GENERIC_MSG_TEXT');
1666: FND_MESSAGE.Set_Token('MESSAGE', l_msg_data);
1667: FND_MSG_PUB.Add;
1668: END IF;
1669: END IF;
1670: END LOOP;

Line 1703: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

1699: IF FND_API.To_Boolean(p_commit) THEN
1700: ROLLBACK TO Copy_Project_PUB;
1701: END IF;
1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1704: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1705: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1706: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1707: FND_MSG_PUB.Add;

Line 1704: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

1700: ROLLBACK TO Copy_Project_PUB;
1701: END IF;
1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1704: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1705: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1706: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1707: FND_MSG_PUB.Add;
1708: FND_MSG_PUB.Count_And_Get(

Line 1705: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

1701: END IF;
1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1704: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1705: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1706: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1707: FND_MSG_PUB.Add;
1708: FND_MSG_PUB.Count_And_Get(
1709: p_encoded => FND_API.G_FALSE,

Line 1706: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1704: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1705: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1706: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1707: FND_MSG_PUB.Add;
1708: FND_MSG_PUB.Count_And_Get(
1709: p_encoded => FND_API.G_FALSE,
1710: p_count => x_msg_count,

Line 1828: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);

1824: IF (FND_API.To_Boolean(p_commit)) THEN
1825: ROLLBACK TO Copy_Item_Assocs_PUB;
1826: END IF;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1829: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1830: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1831: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1832: FND_MSG_PUB.Add;

Line 1829: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);

1825: ROLLBACK TO Copy_Item_Assocs_PUB;
1826: END IF;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1829: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1830: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1831: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1832: FND_MSG_PUB.Add;
1833: FND_MSG_PUB.Count_And_Get(

Line 1830: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);

1826: END IF;
1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1829: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1830: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1831: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1832: FND_MSG_PUB.Add;
1833: FND_MSG_PUB.Count_And_Get(
1834: p_encoded => FND_API.G_FALSE,

Line 1831: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);

1827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1828: FND_MESSAGE.Set_Name(g_app_name, g_plsql_err);
1829: FND_MESSAGE.Set_Token(g_pkg_name_token, g_pkg_name);
1830: FND_MESSAGE.Set_Token(g_api_name_token, l_api_name);
1831: FND_MESSAGE.Set_Token(g_sql_err_msg_token, SQLERRM);
1832: FND_MSG_PUB.Add;
1833: FND_MSG_PUB.Count_And_Get(
1834: p_encoded => FND_API.G_FALSE,
1835: p_count => x_msg_count,