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_EXT_FWK_PUB dependencies on FND_MESSAGE

Line 262: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

258: ROLLBACK TO Delete_Action_Data_Level;
259: END IF;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261:
262: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
263: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
264: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
265: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
266: FND_MSG_PUB.Add;

Line 263: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

259: END IF;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261:
262: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
263: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
264: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
265: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
266: FND_MSG_PUB.Add;
267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 264: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261:
262: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
263: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
264: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
265: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
266: FND_MSG_PUB.Add;
267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
268: ,p_count => x_msg_count

Line 265: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

261:
262: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
263: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
264: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
265: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
266: FND_MSG_PUB.Add;
267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
268: ,p_count => x_msg_count
269: ,p_data => x_msg_data);

Line 870: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

866: EXCEPTION
867: WHEN OTHERS THEN
868: code_debug (l_api_name||' EXCEPTION -- OTHERS ');
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
871: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
872: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
873: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
874: FND_MSG_PUB.Add;

Line 871: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

867: WHEN OTHERS THEN
868: code_debug (l_api_name||' EXCEPTION -- OTHERS ');
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
871: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
872: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
873: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
874: FND_MSG_PUB.Add;
875: END Process_Value_Set_Val;

Line 872: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

868: code_debug (l_api_name||' EXCEPTION -- OTHERS ');
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
871: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
872: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
873: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
874: FND_MSG_PUB.Add;
875: END Process_Value_Set_Val;
876:

Line 873: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
871: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
872: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
873: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
874: FND_MSG_PUB.Add;
875: END Process_Value_Set_Val;
876:
877:

Line 975: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

971: ROLLBACK TO Delete_Attribute_PRV;
972: END IF;
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974:
975: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
976: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
977: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
978: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
979: FND_MSG_PUB.Add;

Line 976: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

972: END IF;
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974:
975: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
976: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
977: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
978: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
979: FND_MSG_PUB.Add;
980: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 977: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974:
975: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
976: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
977: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
978: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
979: FND_MSG_PUB.Add;
980: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
981: ,p_count => x_msg_count

Line 978: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

974:
975: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
976: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
977: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
978: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
979: FND_MSG_PUB.Add;
980: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
981: ,p_count => x_msg_count
982: ,p_data => x_msg_data);

Line 1058: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1054: IF FND_API.TO_BOOLEAN(p_commit) THEN
1055: ROLLBACK TO Delete_Attribute_Group_PVT;
1056: END IF;
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1059: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1060: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1061: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1062: FND_MSG_PUB.Add;

Line 1059: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1055: ROLLBACK TO Delete_Attribute_Group_PVT;
1056: END IF;
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1059: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1060: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1061: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1062: FND_MSG_PUB.Add;
1063: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 1060: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

1056: END IF;
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1059: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1060: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1061: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1062: FND_MSG_PUB.Add;
1063: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1064: ,p_count => x_msg_count

Line 1061: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1058: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1059: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1060: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1061: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1062: FND_MSG_PUB.Add;
1063: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1064: ,p_count => x_msg_count
1065: ,p_data => x_msg_data);

Line 1532: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');

1528:
1529: --------------------------------------
1530: -- Report that the URL is not valid --
1531: --------------------------------------
1532: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
1533: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', p_attr_group_metadata_obj.ATTR_GROUP_DISP_NAME);
1534: FND_MSG_PUB.Add;
1535:
1536: RAISE FND_API.G_EXC_ERROR;

Line 1533: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', p_attr_group_metadata_obj.ATTR_GROUP_DISP_NAME);

1529: --------------------------------------
1530: -- Report that the URL is not valid --
1531: --------------------------------------
1532: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
1533: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', p_attr_group_metadata_obj.ATTR_GROUP_DISP_NAME);
1534: FND_MSG_PUB.Add;
1535:
1536: RAISE FND_API.G_EXC_ERROR;
1537: END IF;

Line 2588: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_GRP_EXIST');

2584: IF FND_API.To_Boolean(p_commit) THEN
2585: ROLLBACK TO Create_Attribute_Group_PUB;
2586: END IF;
2587: x_return_status := FND_API.G_RET_STS_ERROR;
2588: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_GRP_EXIST');
2589: FND_MSG_PUB.Add;
2590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2591: ,p_count => x_msg_count
2592: ,p_data => x_msg_data);

Line 2602: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_NUM');

2598: IF FND_API.TO_BOOLEAN(p_commit) THEN
2599: ROLLBACK TO Create_Attribute_Group_PUB;
2600: END IF;
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_NUM');
2603: FND_MSG_PUB.Add;
2604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2605: ,p_count => x_msg_count
2606: ,p_data => x_msg_data);

Line 2614: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_UND_SC');

2610: IF FND_API.TO_BOOLEAN(p_commit) THEN
2611: ROLLBACK TO Create_Attribute_Group_PUB;
2612: END IF;
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_UND_SC');
2615: FND_MSG_PUB.Add;
2616: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2617: ,p_count => x_msg_count
2618: ,p_data => x_msg_data);

Line 2633: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

2629: FROM FND_NEW_MESSAGES
2630: WHERE MESSAGE_NAME = 'EGO_INTERNAL_NAME_EXISTS'
2631: AND LANGUAGE_CODE = USERENV('LANG');
2632: ELSE
2633: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2634: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2635: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2636: -- SQLERRM from the autonomous transaction will not be reflected here
2637: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.

Line 2634: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

2630: WHERE MESSAGE_NAME = 'EGO_INTERNAL_NAME_EXISTS'
2631: AND LANGUAGE_CODE = USERENV('LANG');
2632: ELSE
2633: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2634: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2635: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2636: -- SQLERRM from the autonomous transaction will not be reflected here
2637: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.
2638: -- Bug 6120553

Line 2635: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

2631: AND LANGUAGE_CODE = USERENV('LANG');
2632: ELSE
2633: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2634: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2635: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2636: -- SQLERRM from the autonomous transaction will not be reflected here
2637: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.
2638: -- Bug 6120553
2639: FND_MESSAGE.Set_Token('SQL_ERR_MSG', NVL(l_sql_errm, SQLERRM)||' '||FND_FLEX_DSC_API.Message());

Line 2639: FND_MESSAGE.Set_Token('SQL_ERR_MSG', NVL(l_sql_errm, SQLERRM)||' '||FND_FLEX_DSC_API.Message());

2635: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2636: -- SQLERRM from the autonomous transaction will not be reflected here
2637: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.
2638: -- Bug 6120553
2639: FND_MESSAGE.Set_Token('SQL_ERR_MSG', NVL(l_sql_errm, SQLERRM)||' '||FND_FLEX_DSC_API.Message());
2640: FND_MSG_PUB.Add;
2641: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2642: ,p_count => x_msg_count
2643: ,p_data => x_msg_data);

Line 2869: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

2865: IF FND_API.TO_BOOLEAN(p_commit) THEN
2866: ROLLBACK TO Copy_Attribute_Group_PUB;
2867: END IF;
2868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2869: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2870: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2871: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2872: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2873: FND_MSG_PUB.Add;

Line 2870: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

2866: ROLLBACK TO Copy_Attribute_Group_PUB;
2867: END IF;
2868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2869: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2870: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2871: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2872: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2873: FND_MSG_PUB.Add;
2874: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 2871: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

2867: END IF;
2868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2869: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2870: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2871: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2872: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2873: FND_MSG_PUB.Add;
2874: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2875: ,p_count => x_msg_count

Line 2872: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

2868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2869: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2870: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2871: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2872: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2873: FND_MSG_PUB.Add;
2874: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2875: ,p_count => x_msg_count
2876: ,p_data => x_msg_data);

Line 3053: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

3049:
3050: IF (l_attr_group_pks IS NULL) THEN
3051: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
3052: ELSE
3053: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3054: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3055: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3056: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3057: FND_MSG_PUB.Add;

Line 3054: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

3050: IF (l_attr_group_pks IS NULL) THEN
3051: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
3052: ELSE
3053: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3054: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3055: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3056: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3057: FND_MSG_PUB.Add;
3058: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 3055: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

3051: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
3052: ELSE
3053: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3054: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3055: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3056: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3057: FND_MSG_PUB.Add;
3058: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3059: ,p_count => x_msg_count

Line 3056: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

3052: ELSE
3053: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3054: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3055: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3056: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3057: FND_MSG_PUB.Add;
3058: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3059: ,p_count => x_msg_count
3060: ,p_data => x_msg_data);

Line 3204: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

3200: IF FND_API.TO_BOOLEAN(p_commit) THEN
3201: ROLLBACK TO Update_Attribute_Group_PUB;
3202: END IF;
3203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3204: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3205: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3206: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3207: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3208: FND_MSG_PUB.Add;

Line 3205: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

3201: ROLLBACK TO Update_Attribute_Group_PUB;
3202: END IF;
3203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3204: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3205: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3206: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3207: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3208: FND_MSG_PUB.Add;
3209: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 3206: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

3202: END IF;
3203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3204: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3205: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3206: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3207: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3208: FND_MSG_PUB.Add;
3209: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3210: ,p_count => x_msg_count

Line 3207: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

3203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3204: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3205: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3206: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3207: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3208: FND_MSG_PUB.Add;
3209: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3210: ,p_count => x_msg_count
3211: ,p_data => x_msg_data);

Line 3273: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

3269:
3270: IF (l_attr_group_pks IS NULL) THEN
3271: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
3272: ELSE
3273: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3274: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3275: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3276: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3277: FND_MSG_PUB.Add;

Line 3274: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

3270: IF (l_attr_group_pks IS NULL) THEN
3271: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
3272: ELSE
3273: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3274: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3275: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3276: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3277: FND_MSG_PUB.Add;
3278: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 3275: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

3271: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
3272: ELSE
3273: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3274: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3275: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3276: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3277: FND_MSG_PUB.Add;
3278: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3279: ,p_count => x_msg_count

Line 3276: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

3272: ELSE
3273: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3274: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3275: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3276: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3277: FND_MSG_PUB.Add;
3278: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3279: ,p_count => x_msg_count
3280: ,p_data => x_msg_data);

Line 3344: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ASSOCS_EXIST1');

3340: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
3341: AND LANGUAGE = USERENV('LANG');
3342:
3343:
3344: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ASSOCS_EXIST1');
3345: FND_MESSAGE.Set_Token('ATTR_GRP_NAME', l_attr_group_disp_name);
3346: FND_MSG_PUB.Add;
3347: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3348: ,p_count => x_msg_count

Line 3345: FND_MESSAGE.Set_Token('ATTR_GRP_NAME', l_attr_group_disp_name);

3341: AND LANGUAGE = USERENV('LANG');
3342:
3343:
3344: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ASSOCS_EXIST1');
3345: FND_MESSAGE.Set_Token('ATTR_GRP_NAME', l_attr_group_disp_name);
3346: FND_MSG_PUB.Add;
3347: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3348: ,p_count => x_msg_count
3349: ,p_data => x_msg_data);

Line 3378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

3374: ROLLBACK TO Delete_Attribute_Group_PUB;
3375: END IF;
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3377:
3378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3379: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3380: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3382: FND_MSG_PUB.Add;

Line 3379: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

3375: END IF;
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3377:
3378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3379: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3380: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3382: FND_MSG_PUB.Add;
3383: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 3380: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3377:
3378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3379: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3380: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3382: FND_MSG_PUB.Add;
3383: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3384: ,p_count => x_msg_count

Line 3381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

3377:
3378: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3379: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3380: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3382: FND_MSG_PUB.Add;
3383: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3384: ,p_count => x_msg_count
3385: ,p_data => x_msg_data);

Line 4322: fnd_message.set_name(G_APP_NAME, 'EGO_TRANSACTION_TYPE');

4318: SAVEPOINT SYNC_DATA_LEVEL;
4319: END IF;
4320:
4321: IF (p_transaction_type IS NULL) THEN
4322: fnd_message.set_name(G_APP_NAME, 'EGO_TRANSACTION_TYPE');
4323: l_msg_data := fnd_msg_pub.get();
4324: ELSIF p_application_id IS NULL THEN
4325: fnd_message.set_name(G_APP_NAME, 'EGO_EF_APPLICATION_ID');
4326: l_msg_data := fnd_msg_pub.get();

Line 4325: fnd_message.set_name(G_APP_NAME, 'EGO_EF_APPLICATION_ID');

4321: IF (p_transaction_type IS NULL) THEN
4322: fnd_message.set_name(G_APP_NAME, 'EGO_TRANSACTION_TYPE');
4323: l_msg_data := fnd_msg_pub.get();
4324: ELSIF p_application_id IS NULL THEN
4325: fnd_message.set_name(G_APP_NAME, 'EGO_EF_APPLICATION_ID');
4326: l_msg_data := fnd_msg_pub.get();
4327: ELSIF p_attr_group_type IS NULL THEN
4328: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GROUP_TYPE');
4329: l_msg_data := fnd_msg_pub.get();

Line 4328: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GROUP_TYPE');

4324: ELSIF p_application_id IS NULL THEN
4325: fnd_message.set_name(G_APP_NAME, 'EGO_EF_APPLICATION_ID');
4326: l_msg_data := fnd_msg_pub.get();
4327: ELSIF p_attr_group_type IS NULL THEN
4328: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GROUP_TYPE');
4329: l_msg_data := fnd_msg_pub.get();
4330: ELSIF p_data_level_name IS NULL THEN
4331: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');
4332: l_msg_data := fnd_msg_pub.get();

Line 4331: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');

4327: ELSIF p_attr_group_type IS NULL THEN
4328: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GROUP_TYPE');
4329: l_msg_data := fnd_msg_pub.get();
4330: ELSIF p_data_level_name IS NULL THEN
4331: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');
4332: l_msg_data := fnd_msg_pub.get();
4333: END IF;
4334:
4335: IF l_msg_data IS NOT NULL THEN

Line 4336: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');

4332: l_msg_data := fnd_msg_pub.get();
4333: END IF;
4334:
4335: IF l_msg_data IS NOT NULL THEN
4336: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4337: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4338: fnd_message.set_token('VALUE', l_msg_data);
4339: FND_MSG_PUB.Add;
4340: RAISE FND_API.G_EXC_ERROR;

Line 4337: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);

4333: END IF;
4334:
4335: IF l_msg_data IS NOT NULL THEN
4336: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4337: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4338: fnd_message.set_token('VALUE', l_msg_data);
4339: FND_MSG_PUB.Add;
4340: RAISE FND_API.G_EXC_ERROR;
4341: END IF;

Line 4338: fnd_message.set_token('VALUE', l_msg_data);

4334:
4335: IF l_msg_data IS NOT NULL THEN
4336: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4337: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4338: fnd_message.set_token('VALUE', l_msg_data);
4339: FND_MSG_PUB.Add;
4340: RAISE FND_API.G_EXC_ERROR;
4341: END IF;
4342: code_debug(l_api_name ||' Mandatory param validation complete '||p_transaction_type);

Line 4372: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL_LIMIT');

4368: l_data_level_id := l_data_level_id + 1;
4369: END IF;
4370:
4371: IF l_data_level_id = ((p_application_id+1) * 100) THEN
4372: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL_LIMIT');
4373: FND_MSG_PUB.Add;
4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;
4376:

Line 4466: fnd_message.set_name(G_APP_NAME, 'EGO_EF_INVALID_DATA_LEVEL');

4462: AND data_level_name = p_data_level_name;
4463: code_debug(l_api_name ||' Data level id being used in update: '||l_data_level_id);
4464:
4465: IF x_data_level_id IS NOT NULL AND x_data_level_id <> l_data_level_id THEN
4466: fnd_message.set_name(G_APP_NAME, 'EGO_EF_INVALID_DATA_LEVEL');
4467: FND_MSG_PUB.Add;
4468: RAISE FND_API.G_EXC_ERROR;
4469: END IF;
4470: UPDATE EGO_DATA_LEVEL_TL

Line 4606: fnd_message.set_name(G_APP_NAME, 'EGO_TRANSACTION_TYPE');

4602: SAVEPOINT SYNC_DL_ASSOC;
4603: END IF;
4604:
4605: IF (p_transaction_type IS NULL) THEN
4606: fnd_message.set_name(G_APP_NAME, 'EGO_TRANSACTION_TYPE');
4607: l_msg_data := fnd_msg_pub.get();
4608: ELSIF p_attr_group_id IS NULL AND
4609: p_application_id IS NULL AND
4610: p_attr_group_type IS NULL AND

Line 4612: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GRP');

4608: ELSIF p_attr_group_id IS NULL AND
4609: p_application_id IS NULL AND
4610: p_attr_group_type IS NULL AND
4611: p_attr_group_name IS NULL THEN
4612: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GRP');
4613: l_msg_data := fnd_msg_pub.get();
4614: ELSIF p_data_level_id IS NULL AND
4615: p_data_level_name IS NULL THEN
4616: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');

Line 4616: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');

4612: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GRP');
4613: l_msg_data := fnd_msg_pub.get();
4614: ELSIF p_data_level_id IS NULL AND
4615: p_data_level_name IS NULL THEN
4616: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');
4617: l_msg_data := fnd_msg_pub.get();
4618: END IF;
4619:
4620: IF l_msg_data IS NOT NULL THEN

Line 4621: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');

4617: l_msg_data := fnd_msg_pub.get();
4618: END IF;
4619:
4620: IF l_msg_data IS NOT NULL THEN
4621: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4622: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4623: fnd_message.set_token('VALUE', l_msg_data);
4624: FND_MSG_PUB.Add;
4625: RAISE FND_API.G_EXC_ERROR;

Line 4622: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);

4618: END IF;
4619:
4620: IF l_msg_data IS NOT NULL THEN
4621: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4622: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4623: fnd_message.set_token('VALUE', l_msg_data);
4624: FND_MSG_PUB.Add;
4625: RAISE FND_API.G_EXC_ERROR;
4626: END IF;

Line 4623: fnd_message.set_token('VALUE', l_msg_data);

4619:
4620: IF l_msg_data IS NOT NULL THEN
4621: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4622: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4623: fnd_message.set_token('VALUE', l_msg_data);
4624: FND_MSG_PUB.Add;
4625: RAISE FND_API.G_EXC_ERROR;
4626: END IF;
4627: code_debug(l_api_name ||' Mandatory param validation complete '||p_transaction_type);

Line 4649: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);

4645: code_debug(l_api_name ||' Attr Group Id '||l_attr_group_id);
4646:
4647: EXCEPTION
4648: WHEN NO_DATA_FOUND THEN
4649: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4650: IF p_attr_group_id IS NULL THEN
4651: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4652: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4653: ELSE

Line 4651: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );

4647: EXCEPTION
4648: WHEN NO_DATA_FOUND THEN
4649: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4650: IF p_attr_group_id IS NULL THEN
4651: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4652: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4653: ELSE
4654: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4655: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);

Line 4652: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );

4648: WHEN NO_DATA_FOUND THEN
4649: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4650: IF p_attr_group_id IS NULL THEN
4651: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4652: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4653: ELSE
4654: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4655: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);
4656: END IF;

Line 4654: FND_MESSAGE.Set_Token('NAME','Attribute Id' );

4650: IF p_attr_group_id IS NULL THEN
4651: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4652: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4653: ELSE
4654: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4655: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);
4656: END IF;
4657: FND_MSG_PUB.Add;
4658: RAISE FND_API.G_EXC_ERROR;

Line 4655: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);

4651: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4652: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4653: ELSE
4654: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4655: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);
4656: END IF;
4657: FND_MSG_PUB.Add;
4658: RAISE FND_API.G_EXC_ERROR;
4659: END;

Line 4683: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);

4679: code_debug(l_api_name ||' Data Level Id '||l_data_level_rec.data_level_id);
4680:
4681: EXCEPTION
4682: WHEN NO_DATA_FOUND THEN
4683: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4684: IF p_data_level_id IS NULL THEN
4685: FND_MESSAGE.Set_Token('NAME','Data Level' );
4686: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4687: ELSE

Line 4685: FND_MESSAGE.Set_Token('NAME','Data Level' );

4681: EXCEPTION
4682: WHEN NO_DATA_FOUND THEN
4683: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4684: IF p_data_level_id IS NULL THEN
4685: FND_MESSAGE.Set_Token('NAME','Data Level' );
4686: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4687: ELSE
4688: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4689: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);

Line 4686: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);

4682: WHEN NO_DATA_FOUND THEN
4683: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4684: IF p_data_level_id IS NULL THEN
4685: FND_MESSAGE.Set_Token('NAME','Data Level' );
4686: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4687: ELSE
4688: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4689: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);
4690: END IF;

Line 4688: FND_MESSAGE.Set_Token('NAME','Data Level Id' );

4684: IF p_data_level_id IS NULL THEN
4685: FND_MESSAGE.Set_Token('NAME','Data Level' );
4686: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4687: ELSE
4688: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4689: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);
4690: END IF;
4691: FND_MSG_PUB.Add;
4692: RAISE FND_API.G_EXC_ERROR;

Line 4689: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);

4685: FND_MESSAGE.Set_Token('NAME','Data Level' );
4686: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4687: ELSE
4688: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4689: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);
4690: END IF;
4691: FND_MSG_PUB.Add;
4692: RAISE FND_API.G_EXC_ERROR;
4693: END;

Line 4719: FND_MESSAGE.SET_NAME(G_APP_NAME,'EGO_EF_DEFAULT_NOT_ALLOWED');

4715: l_defaulting := '';
4716: END IF;
4717: ELSE
4718: IF p_defaulting IS NOT NULL OR p_defaulting_name IS NOT NULL THEN
4719: FND_MESSAGE.SET_NAME(G_APP_NAME,'EGO_EF_DEFAULT_NOT_ALLOWED');
4720: FND_MSG_PUB.Add;
4721: RAISE FND_API.G_EXC_ERROR;
4722: END IF;
4723: END IF;

Line 4726: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);

4722: END IF;
4723: END IF;
4724: EXCEPTION
4725: WHEN NO_DATA_FOUND THEN
4726: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4727: IF p_defaulting IS NULL THEN
4728: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4729: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4730: ELSE

Line 4728: FND_MESSAGE.Set_Token('NAME','Defaulting ' );

4724: EXCEPTION
4725: WHEN NO_DATA_FOUND THEN
4726: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4727: IF p_defaulting IS NULL THEN
4728: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4729: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4730: ELSE
4731: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4732: FND_MESSAGE.Set_Token('VALUE',p_defaulting);

Line 4729: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );

4725: WHEN NO_DATA_FOUND THEN
4726: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4727: IF p_defaulting IS NULL THEN
4728: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4729: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4730: ELSE
4731: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4732: FND_MESSAGE.Set_Token('VALUE',p_defaulting);
4733: END IF;

Line 4731: FND_MESSAGE.Set_Token('NAME','Defaulting ' );

4727: IF p_defaulting IS NULL THEN
4728: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4729: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4730: ELSE
4731: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4732: FND_MESSAGE.Set_Token('VALUE',p_defaulting);
4733: END IF;
4734: FND_MSG_PUB.Add;
4735: RAISE FND_API.G_EXC_ERROR;

Line 4732: FND_MESSAGE.Set_Token('VALUE',p_defaulting);

4728: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4729: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4730: ELSE
4731: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4732: FND_MESSAGE.Set_Token('VALUE',p_defaulting);
4733: END IF;
4734: FND_MSG_PUB.Add;
4735: RAISE FND_API.G_EXC_ERROR;
4736: END;

Line 4763: fnd_message.set_name(G_APP_NAME,'EGO_VIEW_PRIV_NOT_ALLOWED');

4759: END IF;
4760: ELSE
4761: IF p_view_priv_id IS NOT NULL OR p_view_priv_name IS NOT NULL THEN
4762: -- flash message you cannot view privileges
4763: fnd_message.set_name(G_APP_NAME,'EGO_VIEW_PRIV_NOT_ALLOWED');
4764: FND_MSG_PUB.Add;
4765: RAISE FND_API.G_EXC_ERROR;
4766: END IF;
4767: END IF;

Line 4770: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);

4766: END IF;
4767: END IF;
4768: EXCEPTION
4769: WHEN NO_DATA_FOUND THEN
4770: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4771: IF p_view_priv_id IS NOT NULL THEN
4772: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4773: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4774: ELSIF p_view_priv_name IS NOT NULL THEN

Line 4772: FND_MESSAGE.Set_Token('NAME','View Privilege' );

4768: EXCEPTION
4769: WHEN NO_DATA_FOUND THEN
4770: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4771: IF p_view_priv_id IS NOT NULL THEN
4772: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4773: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4774: ELSIF p_view_priv_name IS NOT NULL THEN
4775: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4776: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);

Line 4773: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );

4769: WHEN NO_DATA_FOUND THEN
4770: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4771: IF p_view_priv_id IS NOT NULL THEN
4772: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4773: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4774: ELSIF p_view_priv_name IS NOT NULL THEN
4775: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4776: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4777: ELSE

Line 4775: FND_MESSAGE.Set_Token('NAME','View Privilege' );

4771: IF p_view_priv_id IS NOT NULL THEN
4772: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4773: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4774: ELSIF p_view_priv_name IS NOT NULL THEN
4775: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4776: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4777: ELSE
4778: FND_MESSAGE.set_token('NAME','View Privilege');
4779: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);

Line 4776: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);

4772: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4773: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4774: ELSIF p_view_priv_name IS NOT NULL THEN
4775: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4776: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4777: ELSE
4778: FND_MESSAGE.set_token('NAME','View Privilege');
4779: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);
4780: END IF;

Line 4778: FND_MESSAGE.set_token('NAME','View Privilege');

4774: ELSIF p_view_priv_name IS NOT NULL THEN
4775: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4776: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4777: ELSE
4778: FND_MESSAGE.set_token('NAME','View Privilege');
4779: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);
4780: END IF;
4781: FND_MSG_PUB.Add;
4782: RAISE FND_API.G_EXC_ERROR;

Line 4779: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);

4775: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4776: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4777: ELSE
4778: FND_MESSAGE.set_token('NAME','View Privilege');
4779: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);
4780: END IF;
4781: FND_MSG_PUB.Add;
4782: RAISE FND_API.G_EXC_ERROR;
4783: END;

Line 4810: fnd_message.set_name(G_APP_NAME,'EGO_EDIT_PRIV_NOT_ALLOWED');

4806: END IF;
4807: ELSE
4808: IF p_edit_priv_id IS NOT NULL OR p_edit_priv_name IS NOT NULL THEN
4809: -- flash message you cannot view privileges
4810: fnd_message.set_name(G_APP_NAME,'EGO_EDIT_PRIV_NOT_ALLOWED');
4811: FND_MSG_PUB.Add;
4812: RAISE FND_API.G_EXC_ERROR;
4813: END IF;
4814: END IF;

Line 4817: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);

4813: END IF;
4814: END IF;
4815: EXCEPTION
4816: WHEN NO_DATA_FOUND THEN
4817: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4818: IF p_edit_priv_id IS NOT NULL THEN
4819: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4820: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4821: ELSIF p_edit_priv_name IS NOT NULL THEN

Line 4819: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );

4815: EXCEPTION
4816: WHEN NO_DATA_FOUND THEN
4817: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4818: IF p_edit_priv_id IS NOT NULL THEN
4819: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4820: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4821: ELSIF p_edit_priv_name IS NOT NULL THEN
4822: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4823: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);

Line 4820: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );

4816: WHEN NO_DATA_FOUND THEN
4817: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4818: IF p_edit_priv_id IS NOT NULL THEN
4819: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4820: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4821: ELSIF p_edit_priv_name IS NOT NULL THEN
4822: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4823: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4824: ELSE

Line 4822: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );

4818: IF p_edit_priv_id IS NOT NULL THEN
4819: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4820: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4821: ELSIF p_edit_priv_name IS NOT NULL THEN
4822: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4823: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4824: ELSE
4825: FND_MESSAGE.set_token('NAME','Edit Privilege');
4826: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);

Line 4823: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);

4819: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4820: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4821: ELSIF p_edit_priv_name IS NOT NULL THEN
4822: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4823: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4824: ELSE
4825: FND_MESSAGE.set_token('NAME','Edit Privilege');
4826: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);
4827: END IF;

Line 4825: FND_MESSAGE.set_token('NAME','Edit Privilege');

4821: ELSIF p_edit_priv_name IS NOT NULL THEN
4822: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4823: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4824: ELSE
4825: FND_MESSAGE.set_token('NAME','Edit Privilege');
4826: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);
4827: END IF;
4828: FND_MSG_PUB.Add;
4829: RAISE FND_API.G_EXC_ERROR;

Line 4826: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);

4822: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4823: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4824: ELSE
4825: FND_MESSAGE.set_token('NAME','Edit Privilege');
4826: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);
4827: END IF;
4828: FND_MSG_PUB.Add;
4829: RAISE FND_API.G_EXC_ERROR;
4830: END;

Line 4835: fnd_message.set_name(G_APP_NAME,'EGO_PRE_EVENT_NOT_ALLOWED');

4831: code_debug(l_api_name ||' Edit Priv id '||l_edit_priv_id);
4832:
4833: IF NVL(p_raise_pre_event,'N') IN ('Y', 'N') THEN
4834: IF l_data_level_rec.enable_pre_event = 'N' AND NVL(p_raise_pre_event,'N') = 'Y' THEN
4835: fnd_message.set_name(G_APP_NAME,'EGO_PRE_EVENT_NOT_ALLOWED');
4836: FND_MSG_PUB.Add;
4837: RAISE FND_API.G_EXC_ERROR;
4838: ELSE
4839: l_raise_pre_event := NVL(p_raise_pre_event,'N');

Line 4842: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);

4838: ELSE
4839: l_raise_pre_event := NVL(p_raise_pre_event,'N');
4840: END IF;
4841: ELSE
4842: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4843: FND_MESSAGE.Set_Token('NAME','Pre Event' );
4844: FND_MESSAGE.Set_Token('VALUE',l_raise_pre_event );
4845: FND_MSG_PUB.Add;
4846: RAISE FND_API.G_EXC_ERROR;

Line 4843: FND_MESSAGE.Set_Token('NAME','Pre Event' );

4839: l_raise_pre_event := NVL(p_raise_pre_event,'N');
4840: END IF;
4841: ELSE
4842: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4843: FND_MESSAGE.Set_Token('NAME','Pre Event' );
4844: FND_MESSAGE.Set_Token('VALUE',l_raise_pre_event );
4845: FND_MSG_PUB.Add;
4846: RAISE FND_API.G_EXC_ERROR;
4847: END IF;

Line 4844: FND_MESSAGE.Set_Token('VALUE',l_raise_pre_event );

4840: END IF;
4841: ELSE
4842: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4843: FND_MESSAGE.Set_Token('NAME','Pre Event' );
4844: FND_MESSAGE.Set_Token('VALUE',l_raise_pre_event );
4845: FND_MSG_PUB.Add;
4846: RAISE FND_API.G_EXC_ERROR;
4847: END IF;
4848: code_debug(l_api_name ||' Pre Event '||l_raise_pre_event);

Line 4852: fnd_message.set_name(G_APP_NAME,'EGO_POST_EVENT_NOT_ALLOWED');

4848: code_debug(l_api_name ||' Pre Event '||l_raise_pre_event);
4849:
4850: IF NVL(p_raise_post_event,'N') IN ('Y', 'N') THEN
4851: IF l_data_level_rec.enable_post_event = 'N' AND NVL(p_raise_post_event,'N') = 'Y' THEN
4852: fnd_message.set_name(G_APP_NAME,'EGO_POST_EVENT_NOT_ALLOWED');
4853: FND_MSG_PUB.Add;
4854: RAISE FND_API.G_EXC_ERROR;
4855: ELSE
4856: l_raise_post_event := NVL(p_raise_post_event,'N');

Line 4859: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);

4855: ELSE
4856: l_raise_post_event := NVL(p_raise_post_event,'N');
4857: END IF;
4858: ELSE
4859: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4860: FND_MESSAGE.Set_Token('NAME','Post Event' );
4861: FND_MESSAGE.Set_Token('VALUE',l_raise_post_event );
4862: FND_MSG_PUB.Add;
4863: RAISE FND_API.G_EXC_ERROR;

Line 4860: FND_MESSAGE.Set_Token('NAME','Post Event' );

4856: l_raise_post_event := NVL(p_raise_post_event,'N');
4857: END IF;
4858: ELSE
4859: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4860: FND_MESSAGE.Set_Token('NAME','Post Event' );
4861: FND_MESSAGE.Set_Token('VALUE',l_raise_post_event );
4862: FND_MSG_PUB.Add;
4863: RAISE FND_API.G_EXC_ERROR;
4864: END IF;

Line 4861: FND_MESSAGE.Set_Token('VALUE',l_raise_post_event );

4857: END IF;
4858: ELSE
4859: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4860: FND_MESSAGE.Set_Token('NAME','Post Event' );
4861: FND_MESSAGE.Set_Token('VALUE',l_raise_post_event );
4862: FND_MSG_PUB.Add;
4863: RAISE FND_API.G_EXC_ERROR;
4864: END IF;
4865: code_debug(l_api_name ||' Post Event '||l_raise_post_event);

Line 5645: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_UNIQUE');

5641: ROLLBACK TO Create_Attribute_PUB;
5642: END IF;
5643:
5644: x_return_status := FND_API.G_RET_STS_ERROR;
5645: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_UNIQUE');
5646: FND_MSG_PUB.Add;
5647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5648: ,p_count => x_msg_count
5649: ,p_data => x_msg_data);

Line 5660: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_NUM');

5656: ROLLBACK TO Create_Attribute_PUB;
5657: END IF;
5658:
5659: x_return_status := FND_API.G_RET_STS_ERROR;
5660: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_NUM');
5661: FND_MSG_PUB.Add;
5662: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5663: ,p_count => x_msg_count
5664: ,p_data => x_msg_data);

Line 5672: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_UND_SC');

5668: ROLLBACK TO Create_Attribute_PUB;
5669: END IF;
5670:
5671: x_return_status := FND_API.G_RET_STS_ERROR;
5672: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_UND_SC');
5673: FND_MSG_PUB.Add;
5674: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5675: ,p_count => x_msg_count
5676: ,p_data => x_msg_data);

Line 5684: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_INTRNL_NAME_ERR');

5680: ROLLBACK TO Create_Attribute_PUB;
5681: END IF;
5682:
5683: x_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_INTRNL_NAME_ERR');
5685: FND_MSG_PUB.Add;
5686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5687: ,p_count => x_msg_count
5688: ,p_data => x_msg_data);

Line 5696: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');

5692: ROLLBACK TO Create_Attribute_PUB;
5693: END IF;
5694:
5695: x_return_status := FND_API.G_RET_STS_ERROR;
5696: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
5697: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
5698: FND_MSG_PUB.Add;
5699: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5700: ,p_count => x_msg_count

Line 5697: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);

5693: END IF;
5694:
5695: x_return_status := FND_API.G_RET_STS_ERROR;
5696: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
5697: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
5698: FND_MSG_PUB.Add;
5699: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5700: ,p_count => x_msg_count
5701: ,p_data => x_msg_data);

Line 5709: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_DUP_SEQ_ERR');

5705: ROLLBACK TO Create_Attribute_PUB;
5706: END IF;
5707:
5708: x_return_status := FND_API.G_RET_STS_ERROR;
5709: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_DUP_SEQ_ERR');
5710: FND_MSG_PUB.Add;
5711: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5712: ,p_count => x_msg_count
5713: ,p_data => x_msg_data);

Line 5722: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');

5718: ROLLBACK TO Create_Attribute_PUB;
5719: END IF;
5720:
5721: x_return_status := FND_API.G_RET_STS_ERROR;
5722: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');
5723: FND_MSG_PUB.Add;
5724: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5725: ,p_count => x_msg_count
5726: ,p_data => x_msg_data);

Line 5736: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_COL_DT_ERR');

5732: ROLLBACK TO Create_Attribute_PUB;
5733: END IF;
5734:
5735: x_return_status := FND_API.G_RET_STS_ERROR;
5736: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_COL_DT_ERR');
5737: FND_MSG_PUB.Add;
5738: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5739: ,p_count => x_msg_count
5740: ,p_data => x_msg_data);

Line 5748: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');

5744: ROLLBACK TO Create_Attribute_PUB;
5745: END IF;
5746:
5747: x_return_status := FND_API.G_RET_STS_ERROR;
5748: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');
5749: FND_MSG_PUB.Add;
5750: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5751: ,p_count => x_msg_count
5752: ,p_data => x_msg_data);

Line 5759: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');

5755: IF FND_API.TO_BOOLEAN(p_commit) THEN
5756: ROLLBACK TO Create_Attribute_PUB;
5757: END IF;
5758: x_return_status := FND_API.G_RET_STS_ERROR;
5759: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');
5760: FND_MSG_PUB.Add;
5761: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5762: ,p_count => x_msg_count
5763: ,p_data => x_msg_data);

Line 5771: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_NO_VS_ERR');

5767: ROLLBACK TO Create_Attribute_PUB;
5768: END IF;
5769:
5770: x_return_status := FND_API.G_RET_STS_ERROR;
5771: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_NO_VS_ERR');
5772: FND_MSG_PUB.Add;
5773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5774: ,p_count => x_msg_count
5775: ,p_data => x_msg_data);

Line 5794: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');

5790: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
5791: AND LANGUAGE = USERENV('LANG');
5792:
5793: x_return_status := FND_API.G_RET_STS_ERROR;
5794: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5795: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', l_attr_group_disp_name);
5796: FND_MSG_PUB.Add;
5797: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5798: ,p_count => x_msg_count

Line 5795: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', l_attr_group_disp_name);

5791: AND LANGUAGE = USERENV('LANG');
5792:
5793: x_return_status := FND_API.G_RET_STS_ERROR;
5794: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5795: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', l_attr_group_disp_name);
5796: FND_MSG_PUB.Add;
5797: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5798: ,p_count => x_msg_count
5799: ,p_data => x_msg_data);

Line 5803: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');

5799: ,p_data => x_msg_data);
5800: EXCEPTION
5801: WHEN NO_DATA_FOUND THEN
5802: x_return_status := FND_API.G_RET_STS_ERROR;
5803: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5804: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', null);
5805: FND_MSG_PUB.Add;
5806: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5807: ,p_count => x_msg_count

Line 5804: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', null);

5800: EXCEPTION
5801: WHEN NO_DATA_FOUND THEN
5802: x_return_status := FND_API.G_RET_STS_ERROR;
5803: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5804: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', null);
5805: FND_MSG_PUB.Add;
5806: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5807: ,p_count => x_msg_count
5808: ,p_data => x_msg_data);

Line 5816: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

5812: IF FND_API.TO_BOOLEAN(p_commit) THEN
5813: ROLLBACK TO Create_Attribute_PUB;
5814: END IF;
5815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5816: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
5817: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5818: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5819: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5820: FND_MSG_PUB.Add;

Line 5817: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

5813: ROLLBACK TO Create_Attribute_PUB;
5814: END IF;
5815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5816: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
5817: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5818: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5819: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5820: FND_MSG_PUB.Add;
5821: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 5818: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

5814: END IF;
5815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5816: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
5817: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5818: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5819: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5820: FND_MSG_PUB.Add;
5821: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5822: ,p_count => x_msg_count

Line 5819: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

5815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5816: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
5817: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5818: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5819: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5820: FND_MSG_PUB.Add;
5821: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5822: ,p_count => x_msg_count
5823: ,p_data => x_msg_data);

Line 6316: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');

6312: IF FND_API.To_Boolean(p_commit) THEN
6313: ROLLBACK TO Update_Attribute_PUB;
6314: END IF;
6315: x_return_status := FND_API.G_RET_STS_ERROR;
6316: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
6317: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
6318: FND_MSG_PUB.Add;
6319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6320: ,p_count => x_msg_count

Line 6317: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);

6313: ROLLBACK TO Update_Attribute_PUB;
6314: END IF;
6315: x_return_status := FND_API.G_RET_STS_ERROR;
6316: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
6317: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
6318: FND_MSG_PUB.Add;
6319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6320: ,p_count => x_msg_count
6321: ,p_data => x_msg_data);

Line 6328: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ATTR_DUP_SEQ_ERR');

6324: IF FND_API.To_Boolean(p_commit) THEN
6325: ROLLBACK TO Update_Attribute_PUB;
6326: END IF;
6327: x_return_status := FND_API.G_RET_STS_ERROR;
6328: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ATTR_DUP_SEQ_ERR');
6329: FND_MSG_PUB.Add;
6330: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6331: ,p_count => x_msg_count
6332: ,p_data => x_msg_data);

Line 6338: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');

6334: IF FND_API.TO_BOOLEAN(p_commit) THEN
6335: ROLLBACK TO Update_Attribute_PUB;
6336: END IF;
6337: x_return_status := FND_API.G_RET_STS_ERROR;
6338: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');
6339: FND_MSG_PUB.Add;
6340: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6341: ,p_count => x_msg_count
6342: ,p_data => x_msg_data);

Line 6350: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');

6346: IF FND_API.To_Boolean(p_commit) THEN
6347: ROLLBACK TO Update_Attribute_PUB;
6348: END IF;
6349: x_return_status := FND_API.G_RET_STS_ERROR;
6350: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');
6351: FND_MSG_PUB.Add;
6352: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6353: ,p_count => x_msg_count
6354: ,p_data => x_msg_data);

Line 6362: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

6358: ROLLBACK TO Update_Attribute_PUB;
6359: END IF;
6360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6361:
6362: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6363: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6364: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6365: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6366: FND_MSG_PUB.Add;

Line 6363: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

6359: END IF;
6360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6361:
6362: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6363: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6364: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6365: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6366: FND_MSG_PUB.Add;
6367: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 6364: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

6360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6361:
6362: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6363: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6364: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6365: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6366: FND_MSG_PUB.Add;
6367: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6368: ,p_count => x_msg_count

Line 6365: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

6361:
6362: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6363: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6364: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6365: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6366: FND_MSG_PUB.Add;
6367: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6368: ,p_count => x_msg_count
6369: ,p_data => x_msg_data);

Line 7179: x_msg_data := fnd_message.get();

7175: code_debug(l_api_name ||' EXCEPTION - OTHERS '||SQLERRM);
7176: IF FND_API.To_Boolean( p_commit ) THEN
7177: ROLLBACK TO Create_Value_Set_PUB;
7178: END IF;
7179: x_msg_data := fnd_message.get();
7180: IF x_msg_data IS NULL THEN
7181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7182: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7183: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

Line 7182: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

7178: END IF;
7179: x_msg_data := fnd_message.get();
7180: IF x_msg_data IS NULL THEN
7181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7182: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7183: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7184: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7185: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
7186: FND_MSG_PUB.Add;

Line 7183: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

7179: x_msg_data := fnd_message.get();
7180: IF x_msg_data IS NULL THEN
7181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7182: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7183: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7184: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7185: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
7186: FND_MSG_PUB.Add;
7187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 7184: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

7180: IF x_msg_data IS NULL THEN
7181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7182: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7183: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7184: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7185: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
7186: FND_MSG_PUB.Add;
7187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7188: ,p_count => x_msg_count

Line 7185: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());

7181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7182: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7183: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7184: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7185: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
7186: FND_MSG_PUB.Add;
7187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7188: ,p_count => x_msg_count
7189: ,p_data => x_msg_data);

Line 7471: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

7467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7468:
7469: code_debug('SQL_ERR_MSG ' || SQLERRM);
7470:
7471: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7472: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7473: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7474: FND_MSG_PUB.Add;
7475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 7472: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

7468:
7469: code_debug('SQL_ERR_MSG ' || SQLERRM);
7470:
7471: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7472: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7473: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7474: FND_MSG_PUB.Add;
7475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7476: ,p_count => x_msg_count

Line 7473: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

7469: code_debug('SQL_ERR_MSG ' || SQLERRM);
7470:
7471: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7472: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7473: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7474: FND_MSG_PUB.Add;
7475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7476: ,p_count => x_msg_count
7477: ,p_data => x_msg_data);

Line 7728: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

7724: ROLLBACK TO Update_Value_Set_PUB;
7725: END IF;
7726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7727:
7728: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7729: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7730: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7731: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7732: FND_MSG_PUB.Add;

Line 7729: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

7725: END IF;
7726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7727:
7728: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7729: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7730: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7731: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7732: FND_MSG_PUB.Add;
7733: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 7730: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

7726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7727:
7728: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7729: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7730: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7731: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7732: FND_MSG_PUB.Add;
7733: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7734: ,p_count => x_msg_count

Line 7731: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

7727:
7728: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7729: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7730: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7731: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7732: FND_MSG_PUB.Add;
7733: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7734: ,p_count => x_msg_count
7735: ,p_data => x_msg_data);

Line 7947: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

7943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7944:
7945: code_debug('SQL_ERR_MSG ' || SQLERRM);
7946:
7947: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7948: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7949: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7950: FND_MSG_PUB.Add;
7951: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 7948: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

7944:
7945: code_debug('SQL_ERR_MSG ' || SQLERRM);
7946:
7947: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7948: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7949: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7950: FND_MSG_PUB.Add;
7951: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7952: ,p_count => x_msg_count

Line 7949: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

7945: code_debug('SQL_ERR_MSG ' || SQLERRM);
7946:
7947: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7948: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7949: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7950: FND_MSG_PUB.Add;
7951: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7952: ,p_count => x_msg_count
7953: ,p_data => x_msg_data);

Line 8125: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

8121: ROLLBACK TO Insert_Value_Set_Table_Inf_PUB;
8122: END IF;
8123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8124:
8125: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8126: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8127: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8128: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8129: FND_MSG_PUB.Add;

Line 8126: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

8122: END IF;
8123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8124:
8125: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8126: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8127: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8128: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8129: FND_MSG_PUB.Add;
8130: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 8127: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

8123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8124:
8125: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8126: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8127: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8128: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8129: FND_MSG_PUB.Add;
8130: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8131: ,p_count => x_msg_count

Line 8128: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

8124:
8125: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8126: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8127: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8128: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8129: FND_MSG_PUB.Add;
8130: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8131: ,p_count => x_msg_count
8132: ,p_data => x_msg_data);

Line 8268: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

8264: ROLLBACK TO Update_Value_Set_Table_Inf_PUB;
8265: END IF;
8266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8267:
8268: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8269: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8270: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8271: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8272: FND_MSG_PUB.Add;

Line 8269: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

8265: END IF;
8266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8267:
8268: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8269: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8270: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8271: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8272: FND_MSG_PUB.Add;
8273: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 8270: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

8266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8267:
8268: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8269: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8270: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8271: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8272: FND_MSG_PUB.Add;
8273: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8274: ,p_count => x_msg_count

Line 8271: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

8267:
8268: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8269: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8270: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8271: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8272: FND_MSG_PUB.Add;
8273: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8274: ,p_count => x_msg_count
8275: ,p_data => x_msg_data);

Line 8585: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

8581: ROLLBACK TO Create_Value_Set_Val_PUB;
8582: END IF;
8583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8584:
8585: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8586: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8587: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8588: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8589: FND_MSG_PUB.Add;

Line 8586: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

8582: END IF;
8583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8584:
8585: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8586: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8587: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8588: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8589: FND_MSG_PUB.Add;
8590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 8587: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

8583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8584:
8585: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8586: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8587: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8588: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8589: FND_MSG_PUB.Add;
8590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8591: ,p_count => x_msg_count

Line 8588: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

8584:
8585: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8586: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8587: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8588: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8589: FND_MSG_PUB.Add;
8590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8591: ,p_count => x_msg_count
8592: ,p_data => x_msg_data);

Line 8748: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

8744: ROLLBACK TO Update_Value_Set_Val_PUB;
8745: END IF;
8746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8747:
8748: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8749: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8750: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8751: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8752: FND_MSG_PUB.Add;

Line 8749: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

8745: END IF;
8746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8747:
8748: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8749: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8750: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8751: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8752: FND_MSG_PUB.Add;
8753: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 8750: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

8746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8747:
8748: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8749: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8750: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8751: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8752: FND_MSG_PUB.Add;
8753: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8754: ,p_count => x_msg_count

Line 8751: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

8747:
8748: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8749: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8750: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8751: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8752: FND_MSG_PUB.Add;
8753: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8754: ,p_count => x_msg_count
8755: ,p_data => x_msg_data);

Line 9158: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');

9154: END IF;
9155: END IF;
9156:
9157: IF l_invalid_params THEN
9158: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
9159: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
9160: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
9161: FND_MSG_PUB.Add;
9162: RAISE FND_API.G_EXC_ERROR;

Line 9159: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);

9155: END IF;
9156:
9157: IF l_invalid_params THEN
9158: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
9159: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
9160: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
9161: FND_MSG_PUB.Add;
9162: RAISE FND_API.G_EXC_ERROR;
9163: END IF;

Line 9160: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);

9156:
9157: IF l_invalid_params THEN
9158: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
9159: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
9160: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
9161: FND_MSG_PUB.Add;
9162: RAISE FND_API.G_EXC_ERROR;
9163: END IF;
9164:

Line 9341: Fnd_Message.Set_Name (application => 'EGO',

9337: AND AGV.ATTR_GROUP_NAME = AV.ATTR_GROUP_NAME
9338: AND AGV.ATTR_GROUP_ID = p_attr_group_id;
9339:
9340: IF(l_attr_count = 0 AND l_variant_flag = 'Y') THEN
9341: Fnd_Message.Set_Name (application => 'EGO',
9342: name => 'EGO_EF_NO_ATTR_EXIST'
9343: );
9344: FND_MSG_PUB.Add;
9345: RAISE e_variant_assocs_excep;

Line 9387: Fnd_Message.Set_Name (application => 'EGO',

9383:
9384:
9385: --EXECUTE IMMEDIATE l_dyn_sql;
9386: IF(l_style_exists = 'T' AND l_variant_flag = 'Y') THEN
9387: Fnd_Message.Set_Name (application => 'EGO',
9388: name => 'EGO_VARIANT_STYLE_EXIST'
9389: );
9390: FND_MSG_PUB.Add;
9391: RAISE e_variant_assocs_excep;

Line 9517: Fnd_Message.Set_Name (application => 'EGO',

9513:
9514: l_data_level_name := Get_Data_Level_DispName(l_existing_datalevel);
9515:
9516:
9517: Fnd_Message.Set_Name (application => 'EGO',
9518: name => 'EGO_EF_DL_MISMATCH_ERR'
9519: );
9520:
9521: Fnd_Message.Set_Token ( token => 'ATTR_GROUP'

Line 9521: Fnd_Message.Set_Token ( token => 'ATTR_GROUP'

9517: Fnd_Message.Set_Name (application => 'EGO',
9518: name => 'EGO_EF_DL_MISMATCH_ERR'
9519: );
9520:
9521: Fnd_Message.Set_Token ( token => 'ATTR_GROUP'
9522: , value => l_attr_disp_name
9523: , translate => false
9524: );
9525:

Line 9527: Fnd_Message.Set_Token ( token => 'DATA_LEVEL'

9523: , translate => false
9524: );
9525:
9526:
9527: Fnd_Message.Set_Token ( token => 'DATA_LEVEL'
9528: , value => l_data_level_name
9529: , translate => false
9530: );
9531:

Line 9532: x_msg_data := Fnd_Message.Get;

9528: , value => l_data_level_name
9529: , translate => false
9530: );
9531:
9532: x_msg_data := Fnd_Message.Get;
9533:
9534: WHEN e_variant_assocs_excep THEN
9535: IF FND_API.To_Boolean(p_commit) THEN
9536: ROLLBACK TO Create_Association_PUB;

Line 9553: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

9549: ROLLBACK TO Create_Association_PUB;
9550: END IF;
9551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9552:
9553: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9554: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9555: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9556: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9557: FND_MSG_PUB.Add;

Line 9554: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

9550: END IF;
9551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9552:
9553: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9554: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9555: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9556: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9557: FND_MSG_PUB.Add;
9558: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 9555: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

9551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9552:
9553: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9554: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9555: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9556: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9557: FND_MSG_PUB.Add;
9558: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9559: ,p_count => x_msg_count

Line 9556: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

9552:
9553: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9554: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9555: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9556: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9557: FND_MSG_PUB.Add;
9558: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9559: ,p_count => x_msg_count
9560: ,p_data => x_msg_data);

Line 9640: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

9636:
9637: IF l_attr_group_id IS NULL THEN
9638: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
9639: ELSE
9640: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9641: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9642: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9643: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9644: FND_MSG_PUB.Add;

Line 9641: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

9637: IF l_attr_group_id IS NULL THEN
9638: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
9639: ELSE
9640: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9641: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9642: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9643: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9644: FND_MSG_PUB.Add;
9645: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 9642: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

9638: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
9639: ELSE
9640: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9641: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9642: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9643: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9644: FND_MSG_PUB.Add;
9645: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9646: ,p_count => x_msg_count

Line 9643: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

9639: ELSE
9640: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9641: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9642: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9643: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9644: FND_MSG_PUB.Add;
9645: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9646: ,p_count => x_msg_count
9647: ,p_data => x_msg_data);

Line 9725: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

9721:
9722: IF l_object_id IS NULL THEN
9723: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoObjectIdForObjectName';
9724: ELSE
9725: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9726: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9727: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9728: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9729: FND_MSG_PUB.Add;

Line 9726: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

9722: IF l_object_id IS NULL THEN
9723: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoObjectIdForObjectName';
9724: ELSE
9725: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9726: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9727: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9728: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9729: FND_MSG_PUB.Add;
9730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 9727: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

9723: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoObjectIdForObjectName';
9724: ELSE
9725: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9726: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9727: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9728: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9729: FND_MSG_PUB.Add;
9730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9731: ,p_count => x_msg_count

Line 9728: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

9724: ELSE
9725: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9726: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9727: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9728: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9729: FND_MSG_PUB.Add;
9730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9731: ,p_count => x_msg_count
9732: ,p_data => x_msg_data);

Line 9808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

9804: ROLLBACK TO Update_Association_PUB;
9805: END IF;
9806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9807:
9808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9810: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9812: FND_MSG_PUB.Add;

Line 9809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

9805: END IF;
9806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9807:
9808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9810: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9812: FND_MSG_PUB.Add;
9813: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 9810: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

9806: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9807:
9808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9810: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9812: FND_MSG_PUB.Add;
9813: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9814: ,p_count => x_msg_count

Line 9811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

9807:
9808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9810: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9812: FND_MSG_PUB.Add;
9813: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9814: ,p_count => x_msg_count
9815: ,p_data => x_msg_data);

Line 9885: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

9881:
9882: IF l_association_id IS NULL THEN
9883: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
9884: ELSE
9885: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9886: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9887: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9888: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9889: FND_MSG_PUB.Add;

Line 9886: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

9882: IF l_association_id IS NULL THEN
9883: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
9884: ELSE
9885: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9886: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9887: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9888: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9889: FND_MSG_PUB.Add;
9890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 9887: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

9883: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
9884: ELSE
9885: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9886: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9887: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9888: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9889: FND_MSG_PUB.Add;
9890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9891: ,p_count => x_msg_count

Line 9888: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

9884: ELSE
9885: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9886: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9887: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9888: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9889: FND_MSG_PUB.Add;
9890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9891: ,p_count => x_msg_count
9892: ,p_data => x_msg_data);

Line 9976: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

9972: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
9973: ELSIF l_association_id IS NULL THEN
9974: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
9975: ELSE
9976: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9977: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9978: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9979: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9980: FND_MSG_PUB.Add;

Line 9977: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

9973: ELSIF l_association_id IS NULL THEN
9974: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
9975: ELSE
9976: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9977: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9978: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9979: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9980: FND_MSG_PUB.Add;
9981: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 9978: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

9974: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
9975: ELSE
9976: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9977: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9978: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9979: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9980: FND_MSG_PUB.Add;
9981: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9982: ,p_count => x_msg_count

Line 9979: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

9975: ELSE
9976: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9977: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9978: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9979: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9980: FND_MSG_PUB.Add;
9981: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9982: ,p_count => x_msg_count
9983: ,p_data => x_msg_data);

Line 10200: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

10196: CLOSE get_assoc_records;
10197: END IF;
10198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10199:
10200: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10201: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10202: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10203: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10204: FND_MSG_PUB.Add;

Line 10201: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

10197: END IF;
10198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10199:
10200: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10201: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10202: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10203: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10204: FND_MSG_PUB.Add;
10205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10202: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

10198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10199:
10200: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10201: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10202: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10203: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10204: FND_MSG_PUB.Add;
10205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10206: ,p_count => x_msg_count

Line 10203: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

10199:
10200: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10201: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10202: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10203: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10204: FND_MSG_PUB.Add;
10205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10206: ,p_count => x_msg_count
10207: ,p_data => x_msg_data);

Line 10343: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

10339: ROLLBACK TO Create_Page_PUB;
10340: END IF;
10341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10342:
10343: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10344: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10345: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10346: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10347: FND_MSG_PUB.Add;

Line 10344: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

10340: END IF;
10341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10342:
10343: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10344: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10345: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10346: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10347: FND_MSG_PUB.Add;
10348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10345: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

10341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10342:
10343: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10344: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10345: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10346: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10347: FND_MSG_PUB.Add;
10348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10349: ,p_count => x_msg_count

Line 10346: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

10342:
10343: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10344: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10345: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10346: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10347: FND_MSG_PUB.Add;
10348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10349: ,p_count => x_msg_count
10350: ,p_data => x_msg_data);

Line 10445: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

10441: ROLLBACK TO Update_Page_PUB;
10442: END IF;
10443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10444:
10445: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10446: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10447: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10448: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10449: FND_MSG_PUB.Add;

Line 10446: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

10442: END IF;
10443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10444:
10445: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10446: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10447: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10448: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10449: FND_MSG_PUB.Add;
10450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10447: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

10443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10444:
10445: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10446: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10447: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10448: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10449: FND_MSG_PUB.Add;
10450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10451: ,p_count => x_msg_count

Line 10448: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

10444:
10445: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10446: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10447: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10448: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10449: FND_MSG_PUB.Add;
10450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10451: ,p_count => x_msg_count
10452: ,p_data => x_msg_data);

Line 10533: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

10529:
10530: IF l_page_id IS NULL THEN
10531: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
10532: ELSE
10533: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10534: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10535: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10536: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10537: FND_MSG_PUB.Add;

Line 10534: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

10530: IF l_page_id IS NULL THEN
10531: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
10532: ELSE
10533: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10534: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10535: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10536: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10537: FND_MSG_PUB.Add;
10538: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10535: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

10531: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
10532: ELSE
10533: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10534: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10535: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10536: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10537: FND_MSG_PUB.Add;
10538: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10539: ,p_count => x_msg_count

Line 10536: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

10532: ELSE
10533: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10534: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10535: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10536: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10537: FND_MSG_PUB.Add;
10538: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10539: ,p_count => x_msg_count
10540: ,p_data => x_msg_data);

Line 10607: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

10603: ROLLBACK TO Delete_Page_PUB;
10604: END IF;
10605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10606:
10607: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10608: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10609: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10610: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10611: FND_MSG_PUB.Add;

Line 10608: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

10604: END IF;
10605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10606:
10607: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10608: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10609: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10610: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10611: FND_MSG_PUB.Add;
10612: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10609: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

10605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10606:
10607: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10608: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10609: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10610: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10611: FND_MSG_PUB.Add;
10612: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10613: ,p_count => x_msg_count

Line 10610: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

10606:
10607: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10608: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10609: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10610: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10611: FND_MSG_PUB.Add;
10612: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10613: ,p_count => x_msg_count
10614: ,p_data => x_msg_data);

Line 10678: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

10674:
10675: IF l_page_id IS NULL THEN
10676: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
10677: ELSE
10678: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10679: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10680: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10681: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10682: FND_MSG_PUB.Add;

Line 10679: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

10675: IF l_page_id IS NULL THEN
10676: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
10677: ELSE
10678: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10679: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10680: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10681: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10682: FND_MSG_PUB.Add;
10683: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10680: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

10676: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
10677: ELSE
10678: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10679: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10680: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10681: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10682: FND_MSG_PUB.Add;
10683: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10684: ,p_count => x_msg_count

Line 10681: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

10677: ELSE
10678: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10679: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10680: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10681: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10682: FND_MSG_PUB.Add;
10683: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10684: ,p_count => x_msg_count
10685: ,p_data => x_msg_data);

Line 10848: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');

10844: WHERE A.ASSOCIATION_ID = PE.ASSOCIATION_ID
10845: AND PE.PAGE_ID = p_page_id
10846: AND PE.ASSOCIATION_ID = p_association_id;
10847:
10848: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10849: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10850: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10851: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10852: FND_MSG_PUB.Add;

Line 10849: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);

10845: AND PE.PAGE_ID = p_page_id
10846: AND PE.ASSOCIATION_ID = p_association_id;
10847:
10848: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10849: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10850: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10851: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10852: FND_MSG_PUB.Add;
10853: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10850: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);

10846: AND PE.ASSOCIATION_ID = p_association_id;
10847:
10848: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10849: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10850: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10851: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10852: FND_MSG_PUB.Add;
10853: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10854: ,p_count => x_msg_count

Line 10851: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);

10847:
10848: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10849: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10850: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10851: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10852: FND_MSG_PUB.Add;
10853: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10854: ,p_count => x_msg_count
10855: ,p_data => x_msg_data);

Line 10865: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

10861: EXCEPTION
10862: WHEN OTHERS THEN
10863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10864:
10865: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10866: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10867: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10868: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10869: FND_MSG_PUB.Add;

Line 10866: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

10862: WHEN OTHERS THEN
10863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10864:
10865: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10866: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10867: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10868: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10869: FND_MSG_PUB.Add;
10870: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10867: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

10863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10864:
10865: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10866: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10867: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10868: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10869: FND_MSG_PUB.Add;
10870: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10871: ,p_count => x_msg_count

Line 10868: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

10864:
10865: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10866: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10867: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10868: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10869: FND_MSG_PUB.Add;
10870: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10871: ,p_count => x_msg_count
10872: ,p_data => x_msg_data);

Line 10881: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

10877: ROLLBACK TO Create_Page_Entry_PUB;
10878: END IF;
10879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10880:
10881: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10882: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10883: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10884: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10885: FND_MSG_PUB.Add;

Line 10882: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

10878: END IF;
10879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10880:
10881: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10882: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10883: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10884: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10885: FND_MSG_PUB.Add;
10886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10883: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

10879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10880:
10881: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10882: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10883: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10884: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10885: FND_MSG_PUB.Add;
10886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10887: ,p_count => x_msg_count

Line 10884: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

10880:
10881: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10882: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10883: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10884: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10885: FND_MSG_PUB.Add;
10886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10887: ,p_count => x_msg_count
10888: ,p_data => x_msg_data);

Line 10975: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');

10971: WHERE A.ASSOCIATION_ID = PE.ASSOCIATION_ID
10972: AND PE.PAGE_ID = p_page_id
10973: AND PE.ASSOCIATION_ID = p_new_association_id;
10974:
10975: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10976: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10977: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10978: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10979: FND_MSG_PUB.Add;

Line 10976: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);

10972: AND PE.PAGE_ID = p_page_id
10973: AND PE.ASSOCIATION_ID = p_new_association_id;
10974:
10975: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10976: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10977: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10978: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10979: FND_MSG_PUB.Add;
10980: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10977: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);

10973: AND PE.ASSOCIATION_ID = p_new_association_id;
10974:
10975: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10976: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10977: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10978: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10979: FND_MSG_PUB.Add;
10980: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10981: ,p_count => x_msg_count

Line 10978: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);

10974:
10975: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10976: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10977: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10978: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10979: FND_MSG_PUB.Add;
10980: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10981: ,p_count => x_msg_count
10982: ,p_data => x_msg_data);

Line 10992: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

10988: EXCEPTION
10989: WHEN OTHERS THEN
10990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10991:
10992: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10993: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10994: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10995: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10996: FND_MSG_PUB.Add;

Line 10993: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

10989: WHEN OTHERS THEN
10990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10991:
10992: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10993: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10994: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10995: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10996: FND_MSG_PUB.Add;
10997: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 10994: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

10990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10991:
10992: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10993: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10994: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10995: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10996: FND_MSG_PUB.Add;
10997: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10998: ,p_count => x_msg_count

Line 10995: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

10991:
10992: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10993: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10994: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10995: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10996: FND_MSG_PUB.Add;
10997: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10998: ,p_count => x_msg_count
10999: ,p_data => x_msg_data);

Line 11008: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

11004: ROLLBACK TO Update_Page_Entry_PUB;
11005: END IF;
11006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11007:
11008: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11009: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11010: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11011: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11012: FND_MSG_PUB.Add;

Line 11009: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

11005: END IF;
11006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11007:
11008: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11009: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11010: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11011: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11012: FND_MSG_PUB.Add;
11013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 11010: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

11006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11007:
11008: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11009: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11010: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11011: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11012: FND_MSG_PUB.Add;
11013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11014: ,p_count => x_msg_count

Line 11011: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

11007:
11008: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11009: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11010: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11011: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11012: FND_MSG_PUB.Add;
11013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11014: ,p_count => x_msg_count
11015: ,p_data => x_msg_data);

Line 11080: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

11076: ROLLBACK TO Delete_Page_Entry_PUB;
11077: END IF;
11078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11079:
11080: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11081: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11082: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11083: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11084: FND_MSG_PUB.Add;

Line 11081: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

11077: END IF;
11078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11079:
11080: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11081: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11082: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11083: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11084: FND_MSG_PUB.Add;
11085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 11082: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

11078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11079:
11080: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11081: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11082: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11083: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11084: FND_MSG_PUB.Add;
11085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11086: ,p_count => x_msg_count

Line 11083: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

11079:
11080: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11081: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11082: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11083: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11084: FND_MSG_PUB.Add;
11085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11086: ,p_count => x_msg_count
11087: ,p_data => x_msg_data);

Line 11214: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

11210: ROLLBACK TO Create_Function_PUB;
11211: END IF;
11212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11213:
11214: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11215: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11216: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11217: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11218: FND_MSG_PUB.Add;

Line 11215: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

11211: END IF;
11212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11213:
11214: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11215: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11216: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11217: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11218: FND_MSG_PUB.Add;
11219: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 11216: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

11212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11213:
11214: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11215: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11216: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11217: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11218: FND_MSG_PUB.Add;
11219: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11220: ,p_count => x_msg_count

Line 11217: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

11213:
11214: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11215: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11216: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11217: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11218: FND_MSG_PUB.Add;
11219: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11220: ,p_count => x_msg_count
11221: ,p_data => x_msg_data);

Line 11309: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

11305: ROLLBACK TO Update_Function_PUB;
11306: END IF;
11307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11308:
11309: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11310: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11311: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11312: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11313: FND_MSG_PUB.Add;

Line 11310: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

11306: END IF;
11307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11308:
11309: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11310: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11311: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11312: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11313: FND_MSG_PUB.Add;
11314: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 11311: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

11307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11308:
11309: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11310: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11311: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11312: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11313: FND_MSG_PUB.Add;
11314: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11315: ,p_count => x_msg_count

Line 11312: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

11308:
11309: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11310: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11311: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11312: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11313: FND_MSG_PUB.Add;
11314: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11315: ,p_count => x_msg_count
11316: ,p_data => x_msg_data);

Line 11419: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

11415: ROLLBACK TO Delete_Function_PUB;
11416: END IF;
11417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11418:
11419: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11420: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11421: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11422: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11423: FND_MSG_PUB.Add;

Line 11420: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

11416: END IF;
11417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11418:
11419: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11420: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11421: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11422: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11423: FND_MSG_PUB.Add;
11424: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 11421: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

11417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11418:
11419: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11420: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11421: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11422: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11423: FND_MSG_PUB.Add;
11424: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11425: ,p_count => x_msg_count

Line 11422: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

11418:
11419: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11420: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11421: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11422: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11423: FND_MSG_PUB.Add;
11424: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11425: ,p_count => x_msg_count
11426: ,p_data => x_msg_data);

Line 11604: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_SEQ_ERR');

11600: ROLLBACK TO Create_Action_PUB;
11601: END IF;
11602: x_return_status := FND_API.G_RET_STS_ERROR;
11603: x_errorcode := 1;
11604: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_SEQ_ERR');
11605: FND_MSG_PUB.Add;
11606: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11607: ,p_count => x_msg_count
11608: ,p_data => x_msg_data);

Line 11616: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_NAME_ERR');

11612: ROLLBACK TO Create_Action_PUB;
11613: END IF;
11614: x_return_status := FND_API.G_RET_STS_ERROR;
11615: x_errorcode := 1;
11616: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_NAME_ERR');
11617: FND_MSG_PUB.Add;
11618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11619: ,p_count => x_msg_count
11620: ,p_data => x_msg_data);

Line 11628: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

11624: ROLLBACK TO Create_Action_PUB;
11625: END IF;
11626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11627: x_errorcode := 1;
11628: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11629: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11630: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11631: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11632: FND_MSG_PUB.Add;

Line 11629: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

11625: END IF;
11626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11627: x_errorcode := 1;
11628: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11629: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11630: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11631: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11632: FND_MSG_PUB.Add;
11633: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 11630: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

11626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11627: x_errorcode := 1;
11628: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11629: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11630: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11631: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11632: FND_MSG_PUB.Add;
11633: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11634: ,p_count => x_msg_count

Line 11631: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

11627: x_errorcode := 1;
11628: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11629: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11630: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11631: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11632: FND_MSG_PUB.Add;
11633: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11634: ,p_count => x_msg_count
11635: ,p_data => x_msg_data);

Line 11717: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

11713:
11714: IF l_attr_group_id IS NULL THEN
11715: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
11716: ELSE
11717: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11718: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11720: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11721: FND_MSG_PUB.Add;

Line 11718: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

11714: IF l_attr_group_id IS NULL THEN
11715: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
11716: ELSE
11717: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11718: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11720: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11721: FND_MSG_PUB.Add;
11722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 11719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

11715: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
11716: ELSE
11717: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11718: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11720: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11721: FND_MSG_PUB.Add;
11722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11723: ,p_count => x_msg_count

Line 11720: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

11716: ELSE
11717: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11718: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11720: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11721: FND_MSG_PUB.Add;
11722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11723: ,p_count => x_msg_count
11724: ,p_data => x_msg_data);

Line 11887: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_SEQ_ERR');

11883: ROLLBACK TO Update_Action_PUB;
11884: END IF;
11885: x_return_status := FND_API.G_RET_STS_ERROR;
11886: x_errorcode := 1;
11887: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_SEQ_ERR');
11888: FND_MSG_PUB.Add;
11889: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11890: ,p_count => x_msg_count
11891: ,p_data => x_msg_data);

Line 11899: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_NAME_ERR');

11895: ROLLBACK TO Update_Action_PUB;
11896: END IF;
11897: x_return_status := FND_API.G_RET_STS_ERROR;
11898: x_errorcode := 1;
11899: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_NAME_ERR');
11900: FND_MSG_PUB.Add;
11901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11902: ,p_count => x_msg_count
11903: ,p_data => x_msg_data);

Line 11911: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

11907: ROLLBACK TO Update_Action_PUB;
11908: END IF;
11909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11910:
11911: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11912: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11913: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11914: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11915: FND_MSG_PUB.Add;

Line 11912: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

11908: END IF;
11909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11910:
11911: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11912: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11913: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11914: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11915: FND_MSG_PUB.Add;
11916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 11913: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

11909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11910:
11911: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11912: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11913: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11914: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11915: FND_MSG_PUB.Add;
11916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11917: ,p_count => x_msg_count

Line 11914: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

11910:
11911: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11912: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11913: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11914: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11915: FND_MSG_PUB.Add;
11916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11917: ,p_count => x_msg_count
11918: ,p_data => x_msg_data);

Line 12022: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

12018: ROLLBACK TO Delete_Action_PUB;
12019: END IF;
12020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12021:
12022: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12023: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12024: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12025: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12026: FND_MSG_PUB.Add;

Line 12023: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

12019: END IF;
12020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12021:
12022: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12023: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12024: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12025: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12026: FND_MSG_PUB.Add;
12027: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 12024: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

12020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12021:
12022: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12023: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12024: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12025: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12026: FND_MSG_PUB.Add;
12027: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12028: ,p_count => x_msg_count

Line 12025: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

12021:
12022: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12023: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12024: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12025: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12026: FND_MSG_PUB.Add;
12027: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12028: ,p_count => x_msg_count
12029: ,p_data => x_msg_data);

Line 12114: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

12110: ROLLBACK TO Create_Visibilty_DL_PUB;
12111: END IF;
12112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12113:
12114: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12115: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12116: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12117: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12118: FND_MSG_PUB.Add;

Line 12115: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

12111: END IF;
12112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12113:
12114: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12115: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12116: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12117: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12118: FND_MSG_PUB.Add;
12119: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 12116: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

12112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12113:
12114: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12115: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12116: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12117: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12118: FND_MSG_PUB.Add;
12119: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12120: ,p_count => x_msg_count

Line 12117: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

12113:
12114: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12115: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12116: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12117: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12118: FND_MSG_PUB.Add;
12119: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12120: ,p_count => x_msg_count
12121: ,p_data => x_msg_data);

Line 12219: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

12215: ROLLBACK TO Create_Action_Display_PUB;
12216: END IF;
12217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12218:
12219: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12220: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12221: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12222: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12223: FND_MSG_PUB.Add;

Line 12220: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

12216: END IF;
12217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12218:
12219: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12220: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12221: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12222: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12223: FND_MSG_PUB.Add;
12224: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 12221: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

12217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12218:
12219: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12220: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12221: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12222: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12223: FND_MSG_PUB.Add;
12224: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12225: ,p_count => x_msg_count

Line 12222: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

12218:
12219: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12220: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12221: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12222: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12223: FND_MSG_PUB.Add;
12224: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12225: ,p_count => x_msg_count
12226: ,p_data => x_msg_data);

Line 12310: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

12306: ROLLBACK TO Create_Action_Display_PUB;
12307: END IF;
12308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12309:
12310: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12311: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12312: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12313: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12314: FND_MSG_PUB.Add;

Line 12311: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

12307: END IF;
12308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12309:
12310: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12311: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12312: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12313: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12314: FND_MSG_PUB.Add;
12315: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 12312: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

12308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12309:
12310: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12311: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12312: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12313: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12314: FND_MSG_PUB.Add;
12315: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12316: ,p_count => x_msg_count

Line 12313: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

12309:
12310: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12311: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12312: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12313: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12314: FND_MSG_PUB.Add;
12315: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12316: ,p_count => x_msg_count
12317: ,p_data => x_msg_data);

Line 12482: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

12478: ROLLBACK TO Update_Action_Display_PUB;
12479: END IF;
12480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12481:
12482: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12483: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12484: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12485: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12486: FND_MSG_PUB.Add;

Line 12483: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

12479: END IF;
12480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12481:
12482: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12483: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12484: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12485: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12486: FND_MSG_PUB.Add;
12487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 12484: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

12480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12481:
12482: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12483: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12484: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12485: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12486: FND_MSG_PUB.Add;
12487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12488: ,p_count => x_msg_count

Line 12485: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

12481:
12482: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12483: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12484: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12485: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12486: FND_MSG_PUB.Add;
12487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12488: ,p_count => x_msg_count
12489: ,p_data => x_msg_data);

Line 12642: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

12638: ROLLBACK TO Update_Action_Display_PUB;
12639: END IF;
12640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12641:
12642: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12643: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12644: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12645: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12646: FND_MSG_PUB.Add;

Line 12643: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

12639: END IF;
12640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12641:
12642: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12643: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12644: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12645: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12646: FND_MSG_PUB.Add;
12647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 12644: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

12640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12641:
12642: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12643: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12644: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12645: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12646: FND_MSG_PUB.Add;
12647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12648: ,p_count => x_msg_count

Line 12645: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

12641:
12642: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12643: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12644: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12645: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12646: FND_MSG_PUB.Add;
12647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12648: ,p_count => x_msg_count
12649: ,p_data => x_msg_data);

Line 12761: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

12757: ROLLBACK TO Delete_Action_Display_PUB;
12758: END IF;
12759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12760:
12761: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12762: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12763: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12764: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12765: FND_MSG_PUB.Add;

Line 12762: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

12758: END IF;
12759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12760:
12761: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12762: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12763: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12764: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12765: FND_MSG_PUB.Add;
12766: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 12763: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

12759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12760:
12761: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12762: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12763: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12764: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12765: FND_MSG_PUB.Add;
12766: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12767: ,p_count => x_msg_count

Line 12764: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

12760:
12761: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12762: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12763: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12764: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12765: FND_MSG_PUB.Add;
12766: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12767: ,p_count => x_msg_count
12768: ,p_data => x_msg_data);

Line 12895: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

12891: ROLLBACK TO Create_Function_Param_PUB;
12892: END IF;
12893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12894:
12895: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12897: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12898: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12899: FND_MSG_PUB.Add;

Line 12896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

12892: END IF;
12893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12894:
12895: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12897: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12898: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12899: FND_MSG_PUB.Add;
12900: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 12897: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

12893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12894:
12895: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12897: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12898: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12899: FND_MSG_PUB.Add;
12900: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12901: ,p_count => x_msg_count

Line 12898: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

12894:
12895: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12897: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12898: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12899: FND_MSG_PUB.Add;
12900: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12901: ,p_count => x_msg_count
12902: ,p_data => x_msg_data);

Line 12986: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

12982: ROLLBACK TO Update_Function_Param_PUB;
12983: END IF;
12984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12985:
12986: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12987: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12988: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12989: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12990: FND_MSG_PUB.Add;

Line 12987: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

12983: END IF;
12984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12985:
12986: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12987: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12988: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12989: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12990: FND_MSG_PUB.Add;
12991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 12988: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

12984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12985:
12986: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12987: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12988: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12989: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12990: FND_MSG_PUB.Add;
12991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12992: ,p_count => x_msg_count

Line 12989: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

12985:
12986: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12987: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12988: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12989: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12990: FND_MSG_PUB.Add;
12991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12992: ,p_count => x_msg_count
12993: ,p_data => x_msg_data);

Line 13064: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13060: ROLLBACK TO Delete_Function_Param_PUB;
13061: END IF;
13062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13063:
13064: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13065: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13066: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13067: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13068: FND_MSG_PUB.Add;

Line 13065: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13061: END IF;
13062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13063:
13064: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13065: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13066: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13067: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13068: FND_MSG_PUB.Add;
13069: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13066: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13063:
13064: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13065: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13066: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13067: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13068: FND_MSG_PUB.Add;
13069: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13070: ,p_count => x_msg_count

Line 13067: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13063:
13064: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13065: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13066: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13067: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13068: FND_MSG_PUB.Add;
13069: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13070: ,p_count => x_msg_count
13071: ,p_data => x_msg_data);

Line 13188: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13184: ROLLBACK TO Create_Mapping_PUB;
13185: END IF;
13186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13187:
13188: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13189: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13190: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13191: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13192: FND_MSG_PUB.Add;

Line 13189: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13185: END IF;
13186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13187:
13188: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13189: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13190: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13191: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13192: FND_MSG_PUB.Add;
13193: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13190: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13187:
13188: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13189: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13190: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13191: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13192: FND_MSG_PUB.Add;
13193: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13194: ,p_count => x_msg_count

Line 13191: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13187:
13188: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13189: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13190: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13191: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13192: FND_MSG_PUB.Add;
13193: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13194: ,p_count => x_msg_count
13195: ,p_data => x_msg_data);

Line 13278: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13274:
13275: IF l_application_id IS NULL THEN
13276: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
13277: ELSE
13278: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13279: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13280: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13281: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13282: FND_MSG_PUB.Add;

Line 13279: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13275: IF l_application_id IS NULL THEN
13276: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
13277: ELSE
13278: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13279: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13280: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13281: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13282: FND_MSG_PUB.Add;
13283: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13280: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13276: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
13277: ELSE
13278: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13279: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13280: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13281: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13282: FND_MSG_PUB.Add;
13283: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13284: ,p_count => x_msg_count

Line 13281: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13277: ELSE
13278: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13279: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13280: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13281: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13282: FND_MSG_PUB.Add;
13283: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13284: ,p_count => x_msg_count
13285: ,p_data => x_msg_data);

Line 13414: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13410: ROLLBACK TO Update_Mapping_PUB;
13411: END IF;
13412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13413:
13414: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13415: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13416: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13417: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13418: FND_MSG_PUB.Add;

Line 13415: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13411: END IF;
13412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13413:
13414: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13415: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13416: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13417: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13418: FND_MSG_PUB.Add;
13419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13416: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13413:
13414: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13415: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13416: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13417: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13418: FND_MSG_PUB.Add;
13419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13420: ,p_count => x_msg_count

Line 13417: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13413:
13414: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13415: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13416: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13417: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13418: FND_MSG_PUB.Add;
13419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13420: ,p_count => x_msg_count
13421: ,p_data => x_msg_data);

Line 13516: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13512:
13513: IF l_application_id IS NULL THEN
13514: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
13515: ELSE
13516: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13517: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13518: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13519: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13520: FND_MSG_PUB.Add;

Line 13517: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13513: IF l_application_id IS NULL THEN
13514: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
13515: ELSE
13516: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13517: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13518: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13519: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13520: FND_MSG_PUB.Add;
13521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13518: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13514: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
13515: ELSE
13516: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13517: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13518: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13519: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13520: FND_MSG_PUB.Add;
13521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13522: ,p_count => x_msg_count

Line 13519: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13515: ELSE
13516: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13517: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13518: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13519: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13520: FND_MSG_PUB.Add;
13521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13522: ,p_count => x_msg_count
13523: ,p_data => x_msg_data);

Line 13590: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13586: ROLLBACK TO Delete_Func_Mapping_PUB;
13587: END IF;
13588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13589:
13590: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13591: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13592: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13593: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13594: FND_MSG_PUB.Add;

Line 13591: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13587: END IF;
13588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13589:
13590: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13591: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13592: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13593: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13594: FND_MSG_PUB.Add;
13595: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13592: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13589:
13590: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13591: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13592: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13593: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13594: FND_MSG_PUB.Add;
13595: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13596: ,p_count => x_msg_count

Line 13593: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13589:
13590: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13591: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13592: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13593: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13594: FND_MSG_PUB.Add;
13595: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13596: ,p_count => x_msg_count
13597: ,p_data => x_msg_data);

Line 13665: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13661: ROLLBACK TO Delete_Func_Param_Mapping_PUB;
13662: END IF;
13663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13664:
13665: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13666: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13667: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13668: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13669: FND_MSG_PUB.Add;

Line 13666: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13662: END IF;
13663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13664:
13665: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13666: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13667: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13668: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13669: FND_MSG_PUB.Add;
13670: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13667: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13664:
13665: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13666: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13667: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13668: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13669: FND_MSG_PUB.Add;
13670: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13671: ,p_count => x_msg_count

Line 13668: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13664:
13665: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13666: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13667: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13668: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13669: FND_MSG_PUB.Add;
13670: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13671: ,p_count => x_msg_count
13672: ,p_data => x_msg_data);

Line 13800: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13796: ROLLBACK TO Create_Action_Group_PUB;
13797: END IF;
13798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13799:
13800: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13804: FND_MSG_PUB.Add;

Line 13801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13797: END IF;
13798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13799:
13800: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13804: FND_MSG_PUB.Add;
13805: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13799:
13800: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13804: FND_MSG_PUB.Add;
13805: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13806: ,p_count => x_msg_count

Line 13803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13799:
13800: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13804: FND_MSG_PUB.Add;
13805: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13806: ,p_count => x_msg_count
13807: ,p_data => x_msg_data);

Line 13894: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13890: ROLLBACK TO Update_Action_Group_PUB;
13891: END IF;
13892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13893:
13894: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13895: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13896: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13897: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13898: FND_MSG_PUB.Add;

Line 13895: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13891: END IF;
13892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13893:
13894: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13895: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13896: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13897: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13898: FND_MSG_PUB.Add;
13899: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13896: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13893:
13894: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13895: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13896: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13897: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13898: FND_MSG_PUB.Add;
13899: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13900: ,p_count => x_msg_count

Line 13897: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13893:
13894: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13895: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13896: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13897: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13898: FND_MSG_PUB.Add;
13899: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13900: ,p_count => x_msg_count
13901: ,p_data => x_msg_data);

Line 13972: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

13968: ROLLBACK TO Delete_Action_Group_PUB;
13969: END IF;
13970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13971:
13972: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13973: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13974: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13975: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13976: FND_MSG_PUB.Add;

Line 13973: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

13969: END IF;
13970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13971:
13972: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13973: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13974: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13975: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13976: FND_MSG_PUB.Add;
13977: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 13974: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

13970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13971:
13972: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13973: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13974: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13975: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13976: FND_MSG_PUB.Add;
13977: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13978: ,p_count => x_msg_count

Line 13975: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

13971:
13972: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13973: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13974: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13975: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13976: FND_MSG_PUB.Add;
13977: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13978: ,p_count => x_msg_count
13979: ,p_data => x_msg_data);

Line 14078: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

14074: ROLLBACK TO Create_Action_Group_Entry_PUB;
14075: END IF;
14076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14077:
14078: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14079: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14080: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14081: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14082: FND_MSG_PUB.Add;

Line 14079: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

14075: END IF;
14076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14077:
14078: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14079: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14080: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14081: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14082: FND_MSG_PUB.Add;
14083: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 14080: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

14076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14077:
14078: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14079: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14080: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14081: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14082: FND_MSG_PUB.Add;
14083: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14084: ,p_count => x_msg_count

Line 14081: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

14077:
14078: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14079: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14080: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14081: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14082: FND_MSG_PUB.Add;
14083: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14084: ,p_count => x_msg_count
14085: ,p_data => x_msg_data);

Line 14152: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

14148: ROLLBACK TO Update_Action_Group_Entry_PUB;
14149: END IF;
14150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14151:
14152: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14153: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14154: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14155: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14156: FND_MSG_PUB.Add;

Line 14153: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

14149: END IF;
14150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14151:
14152: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14153: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14154: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14155: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14156: FND_MSG_PUB.Add;
14157: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 14154: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

14150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14151:
14152: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14153: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14154: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14155: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14156: FND_MSG_PUB.Add;
14157: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14158: ,p_count => x_msg_count

Line 14155: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

14151:
14152: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14153: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14154: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14155: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14156: FND_MSG_PUB.Add;
14157: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14158: ,p_count => x_msg_count
14159: ,p_data => x_msg_data);

Line 14222: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

14218: ROLLBACK TO Delete_Action_Group_Entry_PUB;
14219: END IF;
14220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14221:
14222: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14223: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14224: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14225: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14226: FND_MSG_PUB.Add;

Line 14223: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

14219: END IF;
14220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14221:
14222: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14223: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14224: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14225: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14226: FND_MSG_PUB.Add;
14227: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 14224: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

14220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14221:
14222: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14223: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14224: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14225: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14226: FND_MSG_PUB.Add;
14227: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14228: ,p_count => x_msg_count

Line 14225: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

14221:
14222: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14223: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14224: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14225: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
14226: FND_MSG_PUB.Add;
14227: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14228: ,p_count => x_msg_count
14229: ,p_data => x_msg_data);

Line 14869: FND_MESSAGE.set_name('EGO','EGO_EF_NAME_EXTS');

14865: ,cp_attr_group_name => p_attr_group_name
14866: );
14867: FETCH c_check_agv_name INTO l_temp_agv_name;
14868: IF c_check_agv_name%FOUND THEN
14869: FND_MESSAGE.set_name('EGO','EGO_EF_NAME_EXTS');
14870: FND_MSG_PUB.add;
14871: RAISE FND_API.g_exc_error;
14872: END IF;
14873: CLOSE c_check_agv_name;

Line 14881: FND_MESSAGE.set_name('EGO','EGO_EF_NAME_EXTS');

14877: OPEN c_check_obj_name (cp_agv_name => l_agv_name,
14878: cp_appl_id => p_application_id);
14879: FETCH c_check_obj_name INTO l_temp_agv_name;
14880: IF c_check_obj_name%FOUND THEN
14881: FND_MESSAGE.set_name('EGO','EGO_EF_NAME_EXTS');
14882: FND_MSG_PUB.add;
14883: RAISE FND_API.g_exc_error;
14884: END IF;
14885: CLOSE c_check_obj_name;

Line 15065: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CL_INVALID');

15061:
15062: EXCEPTION
15063: WHEN e_control_level_invalid THEN
15064: x_return_status := FND_API.G_RET_STS_ERROR;
15065: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CL_INVALID');
15066: FND_MSG_PUB.Add;
15067: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
15068: ,p_count => x_msg_count
15069: ,p_data => x_msg_data);

Line 15074: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_NO_ATTR_FOUND');

15070:
15071:
15072: WHEN e_no_attr_for_id_error THEN
15073: x_return_status := FND_API.G_RET_STS_ERROR;
15074: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_NO_ATTR_FOUND');
15075: FND_MSG_PUB.Add;
15076: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
15077: ,p_count => x_msg_count
15078: ,p_data => x_msg_data);

Line 15085: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

15081:
15082: WHEN OTHERS THEN
15083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15084:
15085: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
15086: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
15087: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
15088: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
15089: FND_MSG_PUB.Add;

Line 15086: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

15082: WHEN OTHERS THEN
15083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15084:
15085: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
15086: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
15087: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
15088: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
15089: FND_MSG_PUB.Add;
15090: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 15087: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

15083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
15084:
15085: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
15086: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
15087: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
15088: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
15089: FND_MSG_PUB.Add;
15090: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
15091: ,p_count => x_msg_count

Line 15088: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());

15084:
15085: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
15086: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
15087: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
15088: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
15089: FND_MSG_PUB.Add;
15090: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
15091: ,p_count => x_msg_count
15092: ,p_data => x_msg_data);

Line 16113: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');

16109: EXCEPTION
16110:
16111: WHEN no_action_founded_exception THEN
16112: x_return_status := FND_API.G_RET_STS_ERROR;
16113: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16114: FND_MESSAGE.Set_Token('ACTION_NAME', nvl(l_action_name, l_action_rec.ACTION_ID));
16115: FND_MESSAGE.Set_Token('ERR_MSG', 'No such action definition founded');
16116: FND_MSG_PUB.Add;
16117: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 16114: FND_MESSAGE.Set_Token('ACTION_NAME', nvl(l_action_name, l_action_rec.ACTION_ID));

16110:
16111: WHEN no_action_founded_exception THEN
16112: x_return_status := FND_API.G_RET_STS_ERROR;
16113: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16114: FND_MESSAGE.Set_Token('ACTION_NAME', nvl(l_action_name, l_action_rec.ACTION_ID));
16115: FND_MESSAGE.Set_Token('ERR_MSG', 'No such action definition founded');
16116: FND_MSG_PUB.Add;
16117: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16118: ,p_count => x_msg_count

Line 16115: FND_MESSAGE.Set_Token('ERR_MSG', 'No such action definition founded');

16111: WHEN no_action_founded_exception THEN
16112: x_return_status := FND_API.G_RET_STS_ERROR;
16113: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16114: FND_MESSAGE.Set_Token('ACTION_NAME', nvl(l_action_name, l_action_rec.ACTION_ID));
16115: FND_MESSAGE.Set_Token('ERR_MSG', 'No such action definition founded');
16116: FND_MSG_PUB.Add;
16117: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16118: ,p_count => x_msg_count
16119: ,p_data => x_msg_data);

Line 16123: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');

16119: ,p_data => x_msg_data);
16120:
16121: WHEN no_function_founded_exception THEN
16122: x_return_status := FND_API.G_RET_STS_ERROR;
16123: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16124: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16125: FND_MESSAGE.Set_Token('ERR_MSG', 'No such function definition founded');
16126: FND_MSG_PUB.Add;
16127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 16124: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);

16120:
16121: WHEN no_function_founded_exception THEN
16122: x_return_status := FND_API.G_RET_STS_ERROR;
16123: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16124: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16125: FND_MESSAGE.Set_Token('ERR_MSG', 'No such function definition founded');
16126: FND_MSG_PUB.Add;
16127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16128: ,p_count => x_msg_count

Line 16125: FND_MESSAGE.Set_Token('ERR_MSG', 'No such function definition founded');

16121: WHEN no_function_founded_exception THEN
16122: x_return_status := FND_API.G_RET_STS_ERROR;
16123: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16124: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16125: FND_MESSAGE.Set_Token('ERR_MSG', 'No such function definition founded');
16126: FND_MSG_PUB.Add;
16127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16128: ,p_count => x_msg_count
16129: ,p_data => x_msg_data);

Line 16133: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');

16129: ,p_data => x_msg_data);
16130:
16131: WHEN func_params_mapping_exception THEN
16132: x_return_status := FND_API.G_RET_STS_ERROR;
16133: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16134: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16135: FND_MESSAGE.Set_Token('ERR_MSG', 'Function parameters is not compatible with action attr mapping');
16136: FND_MSG_PUB.Add;
16137: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 16134: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);

16130:
16131: WHEN func_params_mapping_exception THEN
16132: x_return_status := FND_API.G_RET_STS_ERROR;
16133: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16134: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16135: FND_MESSAGE.Set_Token('ERR_MSG', 'Function parameters is not compatible with action attr mapping');
16136: FND_MSG_PUB.Add;
16137: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16138: ,p_count => x_msg_count

Line 16135: FND_MESSAGE.Set_Token('ERR_MSG', 'Function parameters is not compatible with action attr mapping');

16131: WHEN func_params_mapping_exception THEN
16132: x_return_status := FND_API.G_RET_STS_ERROR;
16133: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16134: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16135: FND_MESSAGE.Set_Token('ERR_MSG', 'Function parameters is not compatible with action attr mapping');
16136: FND_MSG_PUB.Add;
16137: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16138: ,p_count => x_msg_count
16139: ,p_data => x_msg_data);

Line 16143: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');

16139: ,p_data => x_msg_data);
16140:
16141: WHEN bad_uda_row_info THEN
16142: x_return_status := FND_API.G_RET_STS_ERROR;
16143: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16144: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16145: FND_MESSAGE.Set_Token('ERR_MSG', 'Wrong x_attributes_row_table data, please check!');
16146: FND_MSG_PUB.Add;
16147: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 16144: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);

16140:
16141: WHEN bad_uda_row_info THEN
16142: x_return_status := FND_API.G_RET_STS_ERROR;
16143: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16144: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16145: FND_MESSAGE.Set_Token('ERR_MSG', 'Wrong x_attributes_row_table data, please check!');
16146: FND_MSG_PUB.Add;
16147: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16148: ,p_count => x_msg_count

Line 16145: FND_MESSAGE.Set_Token('ERR_MSG', 'Wrong x_attributes_row_table data, please check!');

16141: WHEN bad_uda_row_info THEN
16142: x_return_status := FND_API.G_RET_STS_ERROR;
16143: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16144: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16145: FND_MESSAGE.Set_Token('ERR_MSG', 'Wrong x_attributes_row_table data, please check!');
16146: FND_MSG_PUB.Add;
16147: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16148: ,p_count => x_msg_count
16149: ,p_data => x_msg_data);

Line 16153: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');

16149: ,p_data => x_msg_data);
16150:
16151: WHEN bad_uda_data_row_identifier THEN
16152: x_return_status := FND_API.G_RET_STS_ERROR;
16153: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16154: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16155: FND_MESSAGE.Set_Token('ERR_MSG', 'Incompatible x_attributes_row_table and x_attributes_data_table Row_Identifier');
16156: FND_MSG_PUB.Add;
16157: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 16154: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);

16150:
16151: WHEN bad_uda_data_row_identifier THEN
16152: x_return_status := FND_API.G_RET_STS_ERROR;
16153: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16154: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16155: FND_MESSAGE.Set_Token('ERR_MSG', 'Incompatible x_attributes_row_table and x_attributes_data_table Row_Identifier');
16156: FND_MSG_PUB.Add;
16157: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16158: ,p_count => x_msg_count

Line 16155: FND_MESSAGE.Set_Token('ERR_MSG', 'Incompatible x_attributes_row_table and x_attributes_data_table Row_Identifier');

16151: WHEN bad_uda_data_row_identifier THEN
16152: x_return_status := FND_API.G_RET_STS_ERROR;
16153: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16154: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16155: FND_MESSAGE.Set_Token('ERR_MSG', 'Incompatible x_attributes_row_table and x_attributes_data_table Row_Identifier');
16156: FND_MSG_PUB.Add;
16157: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16158: ,p_count => x_msg_count
16159: ,p_data => x_msg_data);

Line 16163: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');

16159: ,p_data => x_msg_data);
16160:
16161: WHEN no_data_found_for_param_bind THEN
16162: x_return_status := FND_API.G_RET_STS_ERROR;
16163: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16164: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16165: FND_MESSAGE.Set_Token('ERR_MSG', 'Not all output/return type function params assigned');
16166: FND_MSG_PUB.Add;
16167: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 16164: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);

16160:
16161: WHEN no_data_found_for_param_bind THEN
16162: x_return_status := FND_API.G_RET_STS_ERROR;
16163: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16164: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16165: FND_MESSAGE.Set_Token('ERR_MSG', 'Not all output/return type function params assigned');
16166: FND_MSG_PUB.Add;
16167: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16168: ,p_count => x_msg_count

Line 16165: FND_MESSAGE.Set_Token('ERR_MSG', 'Not all output/return type function params assigned');

16161: WHEN no_data_found_for_param_bind THEN
16162: x_return_status := FND_API.G_RET_STS_ERROR;
16163: FND_MESSAGE.Set_Name('EGO', 'EGO_ACTION_ERROR');
16164: FND_MESSAGE.Set_Token('ACTION_NAME', l_action_name);
16165: FND_MESSAGE.Set_Token('ERR_MSG', 'Not all output/return type function params assigned');
16166: FND_MSG_PUB.Add;
16167: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16168: ,p_count => x_msg_count
16169: ,p_data => x_msg_data);

Line 16174: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

16170:
16171: WHEN OTHERS THEN
16172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16173:
16174: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
16175: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_EXT_FWK_PUB');
16176: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
16177: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
16178: FND_MSG_PUB.Add;

Line 16175: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_EXT_FWK_PUB');

16171: WHEN OTHERS THEN
16172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16173:
16174: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
16175: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_EXT_FWK_PUB');
16176: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
16177: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
16178: FND_MSG_PUB.Add;
16179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

Line 16176: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

16172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
16173:
16174: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
16175: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_EXT_FWK_PUB');
16176: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
16177: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
16178: FND_MSG_PUB.Add;
16179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16180: ,p_count => x_msg_count

Line 16177: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

16173:
16174: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
16175: FND_MESSAGE.Set_Token('PKG_NAME', 'EGO_EXT_FWK_PUB');
16176: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
16177: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
16178: FND_MSG_PUB.Add;
16179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
16180: ,p_count => x_msg_count
16181: ,p_data => x_msg_data);