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 261: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

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

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

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

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

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

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

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

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

826: EXCEPTION
827: WHEN OTHERS THEN
828: code_debug (l_api_name||' EXCEPTION -- OTHERS ');
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
831: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
832: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
833: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
834: FND_MSG_PUB.Add;

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

827: WHEN OTHERS THEN
828: code_debug (l_api_name||' EXCEPTION -- OTHERS ');
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
831: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
832: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
833: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
834: FND_MSG_PUB.Add;
835: END Process_Value_Set_Val;

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

828: code_debug (l_api_name||' EXCEPTION -- OTHERS ');
829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
831: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
832: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
833: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
834: FND_MSG_PUB.Add;
835: END Process_Value_Set_Val;
836:

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

829: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
830: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
831: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
832: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
833: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
834: FND_MSG_PUB.Add;
835: END Process_Value_Set_Val;
836:
837:

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

931: ROLLBACK TO Delete_Attribute_PRV;
932: END IF;
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934:
935: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
936: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
937: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
938: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
939: FND_MSG_PUB.Add;

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

932: END IF;
933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934:
935: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
936: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
937: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
938: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
939: FND_MSG_PUB.Add;
940: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934:
935: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
936: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
937: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
938: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
939: FND_MSG_PUB.Add;
940: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
941: ,p_count => x_msg_count

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

934:
935: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
936: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
937: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
938: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
939: FND_MSG_PUB.Add;
940: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
941: ,p_count => x_msg_count
942: ,p_data => x_msg_data);

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

1014: IF FND_API.TO_BOOLEAN(p_commit) THEN
1015: ROLLBACK TO Delete_Attribute_Group_PVT;
1016: END IF;
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1019: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1020: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1021: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1022: FND_MSG_PUB.Add;

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

1015: ROLLBACK TO Delete_Attribute_Group_PVT;
1016: END IF;
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1019: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1020: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1021: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1022: FND_MSG_PUB.Add;
1023: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

1016: END IF;
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1019: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1020: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1021: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1022: FND_MSG_PUB.Add;
1023: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1024: ,p_count => x_msg_count

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

1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1018: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1019: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1020: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1021: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1022: FND_MSG_PUB.Add;
1023: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1024: ,p_count => x_msg_count
1025: ,p_data => x_msg_data);

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

1470:
1471: --------------------------------------
1472: -- Report that the URL is not valid --
1473: --------------------------------------
1474: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
1475: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', p_attr_group_metadata_obj.ATTR_GROUP_DISP_NAME);
1476: FND_MSG_PUB.Add;
1477:
1478: RAISE FND_API.G_EXC_ERROR;

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

1471: --------------------------------------
1472: -- Report that the URL is not valid --
1473: --------------------------------------
1474: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
1475: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', p_attr_group_metadata_obj.ATTR_GROUP_DISP_NAME);
1476: FND_MSG_PUB.Add;
1477:
1478: RAISE FND_API.G_EXC_ERROR;
1479: END IF;

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

2498: IF FND_API.To_Boolean(p_commit) THEN
2499: ROLLBACK TO Create_Attribute_Group_PUB;
2500: END IF;
2501: x_return_status := FND_API.G_RET_STS_ERROR;
2502: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_GRP_EXIST');
2503: FND_MSG_PUB.Add;
2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2505: ,p_count => x_msg_count
2506: ,p_data => x_msg_data);

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

2512: IF FND_API.TO_BOOLEAN(p_commit) THEN
2513: ROLLBACK TO Create_Attribute_Group_PUB;
2514: END IF;
2515: x_return_status := FND_API.G_RET_STS_ERROR;
2516: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_NUM');
2517: FND_MSG_PUB.Add;
2518: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2519: ,p_count => x_msg_count
2520: ,p_data => x_msg_data);

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

2524: IF FND_API.TO_BOOLEAN(p_commit) THEN
2525: ROLLBACK TO Create_Attribute_Group_PUB;
2526: END IF;
2527: x_return_status := FND_API.G_RET_STS_ERROR;
2528: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_UND_SC');
2529: FND_MSG_PUB.Add;
2530: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2531: ,p_count => x_msg_count
2532: ,p_data => x_msg_data);

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

2543: FROM FND_NEW_MESSAGES
2544: WHERE MESSAGE_NAME = 'EGO_INTERNAL_NAME_EXISTS'
2545: AND LANGUAGE_CODE = USERENV('LANG');
2546: ELSE
2547: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2548: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2549: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2550: -- SQLERRM from the autonomous transaction will not be reflected here
2551: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.

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

2544: WHERE MESSAGE_NAME = 'EGO_INTERNAL_NAME_EXISTS'
2545: AND LANGUAGE_CODE = USERENV('LANG');
2546: ELSE
2547: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2548: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2549: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2550: -- SQLERRM from the autonomous transaction will not be reflected here
2551: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.
2552: -- Bug 6120553

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

2545: AND LANGUAGE_CODE = USERENV('LANG');
2546: ELSE
2547: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2548: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2549: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2550: -- SQLERRM from the autonomous transaction will not be reflected here
2551: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.
2552: -- Bug 6120553
2553: FND_MESSAGE.Set_Token('SQL_ERR_MSG', NVL(l_sql_errm, SQLERRM)||' '||FND_FLEX_DSC_API.Message());

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

2549: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2550: -- SQLERRM from the autonomous transaction will not be reflected here
2551: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.
2552: -- Bug 6120553
2553: FND_MESSAGE.Set_Token('SQL_ERR_MSG', NVL(l_sql_errm, SQLERRM)||' '||FND_FLEX_DSC_API.Message());
2554: FND_MSG_PUB.Add;
2555: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2556: ,p_count => x_msg_count
2557: ,p_data => x_msg_data);

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

2779: IF FND_API.TO_BOOLEAN(p_commit) THEN
2780: ROLLBACK TO Copy_Attribute_Group_PUB;
2781: END IF;
2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2783: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2784: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2785: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2786: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2787: FND_MSG_PUB.Add;

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

2780: ROLLBACK TO Copy_Attribute_Group_PUB;
2781: END IF;
2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2783: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2784: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2785: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2786: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2787: FND_MSG_PUB.Add;
2788: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

2781: END IF;
2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2783: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2784: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2785: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2786: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2787: FND_MSG_PUB.Add;
2788: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2789: ,p_count => x_msg_count

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

2782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2783: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2784: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2785: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2786: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2787: FND_MSG_PUB.Add;
2788: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2789: ,p_count => x_msg_count
2790: ,p_data => x_msg_data);

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

2963:
2964: IF (l_attr_group_pks IS NULL) THEN
2965: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
2966: ELSE
2967: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2968: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2969: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2970: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2971: FND_MSG_PUB.Add;

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

2964: IF (l_attr_group_pks IS NULL) THEN
2965: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
2966: ELSE
2967: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2968: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2969: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2970: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2971: FND_MSG_PUB.Add;
2972: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

2965: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
2966: ELSE
2967: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2968: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2969: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2970: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2971: FND_MSG_PUB.Add;
2972: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2973: ,p_count => x_msg_count

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

2966: ELSE
2967: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2968: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2969: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2970: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2971: FND_MSG_PUB.Add;
2972: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2973: ,p_count => x_msg_count
2974: ,p_data => x_msg_data);

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

3114: IF FND_API.TO_BOOLEAN(p_commit) THEN
3115: ROLLBACK TO Update_Attribute_Group_PUB;
3116: END IF;
3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3119: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3120: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3121: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3122: FND_MSG_PUB.Add;

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

3115: ROLLBACK TO Update_Attribute_Group_PUB;
3116: END IF;
3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3119: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3120: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3121: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3122: FND_MSG_PUB.Add;
3123: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

3116: END IF;
3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3119: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3120: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3121: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3122: FND_MSG_PUB.Add;
3123: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3124: ,p_count => x_msg_count

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

3117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3118: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3119: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3120: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3121: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3122: FND_MSG_PUB.Add;
3123: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3124: ,p_count => x_msg_count
3125: ,p_data => x_msg_data);

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

3183:
3184: IF (l_attr_group_pks IS NULL) THEN
3185: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
3186: ELSE
3187: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3188: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3189: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3190: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3191: FND_MSG_PUB.Add;

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

3184: IF (l_attr_group_pks IS NULL) THEN
3185: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
3186: ELSE
3187: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3188: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3189: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3190: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3191: FND_MSG_PUB.Add;
3192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

3185: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPKsFoundForAttrGroupID';
3186: ELSE
3187: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3188: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3189: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3190: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3191: FND_MSG_PUB.Add;
3192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3193: ,p_count => x_msg_count

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

3186: ELSE
3187: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3188: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3189: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3190: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3191: FND_MSG_PUB.Add;
3192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3193: ,p_count => x_msg_count
3194: ,p_data => x_msg_data);

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

3254: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
3255: AND LANGUAGE = USERENV('LANG');
3256:
3257:
3258: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ASSOCS_EXIST1');
3259: FND_MESSAGE.Set_Token('ATTR_GRP_NAME', l_attr_group_disp_name);
3260: FND_MSG_PUB.Add;
3261: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3262: ,p_count => x_msg_count

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

3255: AND LANGUAGE = USERENV('LANG');
3256:
3257:
3258: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ASSOCS_EXIST1');
3259: FND_MESSAGE.Set_Token('ATTR_GRP_NAME', l_attr_group_disp_name);
3260: FND_MSG_PUB.Add;
3261: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3262: ,p_count => x_msg_count
3263: ,p_data => x_msg_data);

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

3288: ROLLBACK TO Delete_Attribute_Group_PUB;
3289: END IF;
3290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3291:
3292: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3293: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3294: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3295: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3296: FND_MSG_PUB.Add;

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

3289: END IF;
3290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3291:
3292: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3293: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3294: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3295: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3296: FND_MSG_PUB.Add;
3297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

3290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3291:
3292: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3293: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3294: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3295: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3296: FND_MSG_PUB.Add;
3297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3298: ,p_count => x_msg_count

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

3291:
3292: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
3293: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3294: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3295: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3296: FND_MSG_PUB.Add;
3297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3298: ,p_count => x_msg_count
3299: ,p_data => x_msg_data);

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

4193: SAVEPOINT SYNC_DATA_LEVEL;
4194: END IF;
4195:
4196: IF (p_transaction_type IS NULL) THEN
4197: fnd_message.set_name(G_APP_NAME, 'EGO_TRANSACTION_TYPE');
4198: l_msg_data := fnd_msg_pub.get();
4199: ELSIF p_application_id IS NULL THEN
4200: fnd_message.set_name(G_APP_NAME, 'EGO_EF_APPLICATION_ID');
4201: l_msg_data := fnd_msg_pub.get();

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

4196: IF (p_transaction_type IS NULL) THEN
4197: fnd_message.set_name(G_APP_NAME, 'EGO_TRANSACTION_TYPE');
4198: l_msg_data := fnd_msg_pub.get();
4199: ELSIF p_application_id IS NULL THEN
4200: fnd_message.set_name(G_APP_NAME, 'EGO_EF_APPLICATION_ID');
4201: l_msg_data := fnd_msg_pub.get();
4202: ELSIF p_attr_group_type IS NULL THEN
4203: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GROUP_TYPE');
4204: l_msg_data := fnd_msg_pub.get();

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

4199: ELSIF p_application_id IS NULL THEN
4200: fnd_message.set_name(G_APP_NAME, 'EGO_EF_APPLICATION_ID');
4201: l_msg_data := fnd_msg_pub.get();
4202: ELSIF p_attr_group_type IS NULL THEN
4203: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GROUP_TYPE');
4204: l_msg_data := fnd_msg_pub.get();
4205: ELSIF p_data_level_name IS NULL THEN
4206: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');
4207: l_msg_data := fnd_msg_pub.get();

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

4202: ELSIF p_attr_group_type IS NULL THEN
4203: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GROUP_TYPE');
4204: l_msg_data := fnd_msg_pub.get();
4205: ELSIF p_data_level_name IS NULL THEN
4206: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');
4207: l_msg_data := fnd_msg_pub.get();
4208: END IF;
4209:
4210: IF l_msg_data IS NOT NULL THEN

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

4207: l_msg_data := fnd_msg_pub.get();
4208: END IF;
4209:
4210: IF l_msg_data IS NOT NULL THEN
4211: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4212: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4213: fnd_message.set_token('VALUE', l_msg_data);
4214: FND_MSG_PUB.Add;
4215: RAISE FND_API.G_EXC_ERROR;

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

4208: END IF;
4209:
4210: IF l_msg_data IS NOT NULL THEN
4211: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4212: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4213: fnd_message.set_token('VALUE', l_msg_data);
4214: FND_MSG_PUB.Add;
4215: RAISE FND_API.G_EXC_ERROR;
4216: END IF;

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

4209:
4210: IF l_msg_data IS NOT NULL THEN
4211: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4212: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4213: fnd_message.set_token('VALUE', l_msg_data);
4214: FND_MSG_PUB.Add;
4215: RAISE FND_API.G_EXC_ERROR;
4216: END IF;
4217: code_debug(l_api_name ||' Mandatory param validation complete '||p_transaction_type);

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

4243: l_data_level_id := l_data_level_id + 1;
4244: END IF;
4245:
4246: IF l_data_level_id = ((p_application_id+1) * 100) THEN
4247: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL_LIMIT');
4248: FND_MSG_PUB.Add;
4249: RAISE FND_API.G_EXC_ERROR;
4250: END IF;
4251:

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

4337: AND data_level_name = p_data_level_name;
4338: code_debug(l_api_name ||' Data level id being used in update: '||l_data_level_id);
4339:
4340: IF x_data_level_id IS NOT NULL AND x_data_level_id <> l_data_level_id THEN
4341: fnd_message.set_name(G_APP_NAME, 'EGO_EF_INVALID_DATA_LEVEL');
4342: FND_MSG_PUB.Add;
4343: RAISE FND_API.G_EXC_ERROR;
4344: END IF;
4345: UPDATE EGO_DATA_LEVEL_TL

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

4472: SAVEPOINT SYNC_DL_ASSOC;
4473: END IF;
4474:
4475: IF (p_transaction_type IS NULL) THEN
4476: fnd_message.set_name(G_APP_NAME, 'EGO_TRANSACTION_TYPE');
4477: l_msg_data := fnd_msg_pub.get();
4478: ELSIF p_attr_group_id IS NULL AND
4479: p_application_id IS NULL AND
4480: p_attr_group_type IS NULL AND

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

4478: ELSIF p_attr_group_id IS NULL AND
4479: p_application_id IS NULL AND
4480: p_attr_group_type IS NULL AND
4481: p_attr_group_name IS NULL THEN
4482: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GRP');
4483: l_msg_data := fnd_msg_pub.get();
4484: ELSIF p_data_level_id IS NULL AND
4485: p_data_level_name IS NULL THEN
4486: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');

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

4482: fnd_message.set_name(G_APP_NAME, 'EGO_EF_ATTR_GRP');
4483: l_msg_data := fnd_msg_pub.get();
4484: ELSIF p_data_level_id IS NULL AND
4485: p_data_level_name IS NULL THEN
4486: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL');
4487: l_msg_data := fnd_msg_pub.get();
4488: END IF;
4489:
4490: IF l_msg_data IS NOT NULL THEN

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

4487: l_msg_data := fnd_msg_pub.get();
4488: END IF;
4489:
4490: IF l_msg_data IS NOT NULL THEN
4491: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4492: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4493: fnd_message.set_token('VALUE', l_msg_data);
4494: FND_MSG_PUB.Add;
4495: RAISE FND_API.G_EXC_ERROR;

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

4488: END IF;
4489:
4490: IF l_msg_data IS NOT NULL THEN
4491: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4492: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4493: fnd_message.set_token('VALUE', l_msg_data);
4494: FND_MSG_PUB.Add;
4495: RAISE FND_API.G_EXC_ERROR;
4496: END IF;

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

4489:
4490: IF l_msg_data IS NOT NULL THEN
4491: fnd_message.set_name(G_APP_NAME,'EGO_PKG_MAND_VALUES_MISS1');
4492: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
4493: fnd_message.set_token('VALUE', l_msg_data);
4494: FND_MSG_PUB.Add;
4495: RAISE FND_API.G_EXC_ERROR;
4496: END IF;
4497: code_debug(l_api_name ||' Mandatory param validation complete '||p_transaction_type);

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

4513: END IF;
4514: code_debug(l_api_name ||' Attr Group Id '||l_attr_group_id);
4515: EXCEPTION
4516: WHEN NO_DATA_FOUND THEN
4517: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4518: IF p_attr_group_id IS NULL THEN
4519: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4520: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4521: ELSE

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

4515: EXCEPTION
4516: WHEN NO_DATA_FOUND THEN
4517: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4518: IF p_attr_group_id IS NULL THEN
4519: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4520: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4521: ELSE
4522: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4523: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);

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

4516: WHEN NO_DATA_FOUND THEN
4517: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4518: IF p_attr_group_id IS NULL THEN
4519: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4520: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4521: ELSE
4522: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4523: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);
4524: END IF;

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

4518: IF p_attr_group_id IS NULL THEN
4519: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4520: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4521: ELSE
4522: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4523: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);
4524: END IF;
4525: FND_MSG_PUB.Add;
4526: RAISE FND_API.G_EXC_ERROR;

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

4519: FND_MESSAGE.Set_Token('NAME','Attribute Group ' );
4520: FND_MESSAGE.Set_Token('VALUE',p_attr_group_type||' - '||p_attr_group_name );
4521: ELSE
4522: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4523: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);
4524: END IF;
4525: FND_MSG_PUB.Add;
4526: RAISE FND_API.G_EXC_ERROR;
4527: END;

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

4544: END IF;
4545: code_debug(l_api_name ||' Data Level Id '||l_data_level_rec.data_level_id);
4546: EXCEPTION
4547: WHEN NO_DATA_FOUND THEN
4548: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4549: IF p_data_level_id IS NULL THEN
4550: FND_MESSAGE.Set_Token('NAME','Data Level' );
4551: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4552: ELSE

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

4546: EXCEPTION
4547: WHEN NO_DATA_FOUND THEN
4548: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4549: IF p_data_level_id IS NULL THEN
4550: FND_MESSAGE.Set_Token('NAME','Data Level' );
4551: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4552: ELSE
4553: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4554: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);

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

4547: WHEN NO_DATA_FOUND THEN
4548: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4549: IF p_data_level_id IS NULL THEN
4550: FND_MESSAGE.Set_Token('NAME','Data Level' );
4551: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4552: ELSE
4553: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4554: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);
4555: END IF;

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

4549: IF p_data_level_id IS NULL THEN
4550: FND_MESSAGE.Set_Token('NAME','Data Level' );
4551: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4552: ELSE
4553: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4554: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);
4555: END IF;
4556: FND_MSG_PUB.Add;
4557: RAISE FND_API.G_EXC_ERROR;

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

4550: FND_MESSAGE.Set_Token('NAME','Data Level' );
4551: FND_MESSAGE.Set_Token('VALUE', p_data_level_name);
4552: ELSE
4553: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4554: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);
4555: END IF;
4556: FND_MSG_PUB.Add;
4557: RAISE FND_API.G_EXC_ERROR;
4558: END;

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

4579: l_defaulting := '';
4580: END IF;
4581: ELSE
4582: IF p_defaulting IS NOT NULL OR p_defaulting_name IS NOT NULL THEN
4583: FND_MESSAGE.SET_NAME(G_APP_NAME,'EGO_EF_DEFAULT_NOT_ALLOWED');
4584: FND_MSG_PUB.Add;
4585: RAISE FND_API.G_EXC_ERROR;
4586: END IF;
4587: END IF;

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

4586: END IF;
4587: END IF;
4588: EXCEPTION
4589: WHEN NO_DATA_FOUND THEN
4590: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4591: IF p_defaulting IS NULL THEN
4592: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4593: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4594: ELSE

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

4588: EXCEPTION
4589: WHEN NO_DATA_FOUND THEN
4590: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4591: IF p_defaulting IS NULL THEN
4592: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4593: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4594: ELSE
4595: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4596: FND_MESSAGE.Set_Token('VALUE',p_defaulting);

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

4589: WHEN NO_DATA_FOUND THEN
4590: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4591: IF p_defaulting IS NULL THEN
4592: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4593: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4594: ELSE
4595: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4596: FND_MESSAGE.Set_Token('VALUE',p_defaulting);
4597: END IF;

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

4591: IF p_defaulting IS NULL THEN
4592: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4593: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4594: ELSE
4595: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4596: FND_MESSAGE.Set_Token('VALUE',p_defaulting);
4597: END IF;
4598: FND_MSG_PUB.Add;
4599: RAISE FND_API.G_EXC_ERROR;

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

4592: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4593: FND_MESSAGE.Set_Token('VALUE',p_defaulting_name );
4594: ELSE
4595: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4596: FND_MESSAGE.Set_Token('VALUE',p_defaulting);
4597: END IF;
4598: FND_MSG_PUB.Add;
4599: RAISE FND_API.G_EXC_ERROR;
4600: END;

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

4623: END IF;
4624: ELSE
4625: IF p_view_priv_id IS NOT NULL OR p_view_priv_name IS NOT NULL THEN
4626: -- flash message you cannot view privileges
4627: fnd_message.set_name(G_APP_NAME,'EGO_VIEW_PRIV_NOT_ALLOWED');
4628: FND_MSG_PUB.Add;
4629: RAISE FND_API.G_EXC_ERROR;
4630: END IF;
4631: END IF;

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

4630: END IF;
4631: END IF;
4632: EXCEPTION
4633: WHEN NO_DATA_FOUND THEN
4634: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4635: IF p_view_priv_id IS NOT NULL THEN
4636: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4637: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4638: ELSIF p_view_priv_name IS NOT NULL THEN

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

4632: EXCEPTION
4633: WHEN NO_DATA_FOUND THEN
4634: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4635: IF p_view_priv_id IS NOT NULL THEN
4636: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4637: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4638: ELSIF p_view_priv_name IS NOT NULL THEN
4639: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4640: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);

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

4633: WHEN NO_DATA_FOUND THEN
4634: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4635: IF p_view_priv_id IS NOT NULL THEN
4636: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4637: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4638: ELSIF p_view_priv_name IS NOT NULL THEN
4639: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4640: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4641: ELSE

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

4635: IF p_view_priv_id IS NOT NULL THEN
4636: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4637: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4638: ELSIF p_view_priv_name IS NOT NULL THEN
4639: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4640: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4641: ELSE
4642: FND_MESSAGE.set_token('NAME','View Privilege');
4643: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);

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

4636: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4637: FND_MESSAGE.Set_Token('VALUE',p_view_priv_id );
4638: ELSIF p_view_priv_name IS NOT NULL THEN
4639: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4640: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4641: ELSE
4642: FND_MESSAGE.set_token('NAME','View Privilege');
4643: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);
4644: END IF;

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

4638: ELSIF p_view_priv_name IS NOT NULL THEN
4639: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4640: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4641: ELSE
4642: FND_MESSAGE.set_token('NAME','View Privilege');
4643: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);
4644: END IF;
4645: FND_MSG_PUB.Add;
4646: RAISE FND_API.G_EXC_ERROR;

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

4639: FND_MESSAGE.Set_Token('NAME','View Privilege' );
4640: FND_MESSAGE.Set_Token('VALUE',p_view_priv_name);
4641: ELSE
4642: FND_MESSAGE.set_token('NAME','View Privilege');
4643: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);
4644: END IF;
4645: FND_MSG_PUB.Add;
4646: RAISE FND_API.G_EXC_ERROR;
4647: END;

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

4670: END IF;
4671: ELSE
4672: IF p_edit_priv_id IS NOT NULL OR p_edit_priv_name IS NOT NULL THEN
4673: -- flash message you cannot view privileges
4674: fnd_message.set_name(G_APP_NAME,'EGO_EDIT_PRIV_NOT_ALLOWED');
4675: FND_MSG_PUB.Add;
4676: RAISE FND_API.G_EXC_ERROR;
4677: END IF;
4678: END IF;

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

4677: END IF;
4678: END IF;
4679: EXCEPTION
4680: WHEN NO_DATA_FOUND THEN
4681: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4682: IF p_edit_priv_id IS NOT NULL THEN
4683: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4684: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4685: ELSIF p_edit_priv_name IS NOT NULL THEN

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

4679: EXCEPTION
4680: WHEN NO_DATA_FOUND THEN
4681: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4682: IF p_edit_priv_id IS NOT NULL THEN
4683: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4684: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4685: ELSIF p_edit_priv_name IS NOT NULL THEN
4686: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4687: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);

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

4680: WHEN NO_DATA_FOUND THEN
4681: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4682: IF p_edit_priv_id IS NOT NULL THEN
4683: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4684: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4685: ELSIF p_edit_priv_name IS NOT NULL THEN
4686: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4687: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4688: ELSE

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

4682: IF p_edit_priv_id IS NOT NULL THEN
4683: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4684: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4685: ELSIF p_edit_priv_name IS NOT NULL THEN
4686: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4687: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4688: ELSE
4689: FND_MESSAGE.set_token('NAME','Edit Privilege');
4690: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);

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

4683: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4684: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_id );
4685: ELSIF p_edit_priv_name IS NOT NULL THEN
4686: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4687: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4688: ELSE
4689: FND_MESSAGE.set_token('NAME','Edit Privilege');
4690: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);
4691: END IF;

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

4685: ELSIF p_edit_priv_name IS NOT NULL THEN
4686: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4687: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4688: ELSE
4689: FND_MESSAGE.set_token('NAME','Edit Privilege');
4690: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);
4691: END IF;
4692: FND_MSG_PUB.Add;
4693: RAISE FND_API.G_EXC_ERROR;

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

4686: FND_MESSAGE.Set_Token('NAME','Edit Privilege' );
4687: FND_MESSAGE.Set_Token('VALUE',p_edit_priv_name);
4688: ELSE
4689: FND_MESSAGE.set_token('NAME','Edit Privilege');
4690: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);
4691: END IF;
4692: FND_MSG_PUB.Add;
4693: RAISE FND_API.G_EXC_ERROR;
4694: END;

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

4695: code_debug(l_api_name ||' Edit Priv id '||l_edit_priv_id);
4696:
4697: IF NVL(p_raise_pre_event,'N') IN ('Y', 'N') THEN
4698: IF l_data_level_rec.enable_pre_event = 'N' AND NVL(p_raise_pre_event,'N') = 'Y' THEN
4699: fnd_message.set_name(G_APP_NAME,'EGO_PRE_EVENT_NOT_ALLOWED');
4700: FND_MSG_PUB.Add;
4701: RAISE FND_API.G_EXC_ERROR;
4702: ELSE
4703: l_raise_pre_event := NVL(p_raise_pre_event,'N');

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

4702: ELSE
4703: l_raise_pre_event := NVL(p_raise_pre_event,'N');
4704: END IF;
4705: ELSE
4706: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4707: FND_MESSAGE.Set_Token('NAME','Pre Event' );
4708: FND_MESSAGE.Set_Token('VALUE',l_raise_pre_event );
4709: FND_MSG_PUB.Add;
4710: RAISE FND_API.G_EXC_ERROR;

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

4703: l_raise_pre_event := NVL(p_raise_pre_event,'N');
4704: END IF;
4705: ELSE
4706: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4707: FND_MESSAGE.Set_Token('NAME','Pre Event' );
4708: FND_MESSAGE.Set_Token('VALUE',l_raise_pre_event );
4709: FND_MSG_PUB.Add;
4710: RAISE FND_API.G_EXC_ERROR;
4711: END IF;

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

4704: END IF;
4705: ELSE
4706: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4707: FND_MESSAGE.Set_Token('NAME','Pre Event' );
4708: FND_MESSAGE.Set_Token('VALUE',l_raise_pre_event );
4709: FND_MSG_PUB.Add;
4710: RAISE FND_API.G_EXC_ERROR;
4711: END IF;
4712: code_debug(l_api_name ||' Pre Event '||l_raise_pre_event);

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

4712: code_debug(l_api_name ||' Pre Event '||l_raise_pre_event);
4713:
4714: IF NVL(p_raise_post_event,'N') IN ('Y', 'N') THEN
4715: IF l_data_level_rec.enable_post_event = 'N' AND NVL(p_raise_post_event,'N') = 'Y' THEN
4716: fnd_message.set_name(G_APP_NAME,'EGO_POST_EVENT_NOT_ALLOWED');
4717: FND_MSG_PUB.Add;
4718: RAISE FND_API.G_EXC_ERROR;
4719: ELSE
4720: l_raise_post_event := NVL(p_raise_post_event,'N');

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

4719: ELSE
4720: l_raise_post_event := NVL(p_raise_post_event,'N');
4721: END IF;
4722: ELSE
4723: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4724: FND_MESSAGE.Set_Token('NAME','Post Event' );
4725: FND_MESSAGE.Set_Token('VALUE',l_raise_post_event );
4726: FND_MSG_PUB.Add;
4727: RAISE FND_API.G_EXC_ERROR;

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

4720: l_raise_post_event := NVL(p_raise_post_event,'N');
4721: END IF;
4722: ELSE
4723: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4724: FND_MESSAGE.Set_Token('NAME','Post Event' );
4725: FND_MESSAGE.Set_Token('VALUE',l_raise_post_event );
4726: FND_MSG_PUB.Add;
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;

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

4721: END IF;
4722: ELSE
4723: FND_MESSAGE.Set_Name(G_APP_NAME, l_msg_name);
4724: FND_MESSAGE.Set_Token('NAME','Post Event' );
4725: FND_MESSAGE.Set_Token('VALUE',l_raise_post_event );
4726: FND_MSG_PUB.Add;
4727: RAISE FND_API.G_EXC_ERROR;
4728: END IF;
4729: code_debug(l_api_name ||' Post Event '||l_raise_post_event);

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

5433: ROLLBACK TO Create_Attribute_PUB;
5434: END IF;
5435:
5436: x_return_status := FND_API.G_RET_STS_ERROR;
5437: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_UNIQUE');
5438: FND_MSG_PUB.Add;
5439: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5440: ,p_count => x_msg_count
5441: ,p_data => x_msg_data);

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

5448: IF FND_API.TO_BOOLEAN(p_commit) THEN
5449: ROLLBACK TO Create_Attribute_PUB;
5450: END IF;
5451: x_return_status := FND_API.G_RET_STS_ERROR;
5452: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_NUM');
5453: FND_MSG_PUB.Add;
5454: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5455: ,p_count => x_msg_count
5456: ,p_data => x_msg_data);

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

5459: IF FND_API.TO_BOOLEAN(p_commit) THEN
5460: ROLLBACK TO Create_Attribute_PUB;
5461: END IF;
5462: x_return_status := FND_API.G_RET_STS_ERROR;
5463: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_UND_SC');
5464: FND_MSG_PUB.Add;
5465: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5466: ,p_count => x_msg_count
5467: ,p_data => x_msg_data);

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

5470: IF FND_API.TO_BOOLEAN(p_commit) THEN
5471: ROLLBACK TO Create_Attribute_PUB;
5472: END IF;
5473: x_return_status := FND_API.G_RET_STS_ERROR;
5474: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_INTRNL_NAME_ERR');
5475: FND_MSG_PUB.Add;
5476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5477: ,p_count => x_msg_count
5478: ,p_data => x_msg_data);

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

5481: IF FND_API.TO_BOOLEAN(p_commit) THEN
5482: ROLLBACK TO Create_Attribute_PUB;
5483: END IF;
5484: x_return_status := FND_API.G_RET_STS_ERROR;
5485: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
5486: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
5487: FND_MSG_PUB.Add;
5488: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5489: ,p_count => x_msg_count

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

5482: ROLLBACK TO Create_Attribute_PUB;
5483: END IF;
5484: x_return_status := FND_API.G_RET_STS_ERROR;
5485: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
5486: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
5487: FND_MSG_PUB.Add;
5488: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5489: ,p_count => x_msg_count
5490: ,p_data => x_msg_data);

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

5493: IF FND_API.TO_BOOLEAN(p_commit) THEN
5494: ROLLBACK TO Create_Attribute_PUB;
5495: END IF;
5496: x_return_status := FND_API.G_RET_STS_ERROR;
5497: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_DUP_SEQ_ERR');
5498: FND_MSG_PUB.Add;
5499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5500: ,p_count => x_msg_count
5501: ,p_data => x_msg_data);

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

5505: IF FND_API.TO_BOOLEAN(p_commit) THEN
5506: ROLLBACK TO Create_Attribute_PUB;
5507: END IF;
5508: x_return_status := FND_API.G_RET_STS_ERROR;
5509: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');
5510: FND_MSG_PUB.Add;
5511: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5512: ,p_count => x_msg_count
5513: ,p_data => x_msg_data);

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

5518: IF FND_API.TO_BOOLEAN(p_commit) THEN
5519: ROLLBACK TO Create_Attribute_PUB;
5520: END IF;
5521: x_return_status := FND_API.G_RET_STS_ERROR;
5522: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_COL_DT_ERR');
5523: FND_MSG_PUB.Add;
5524: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5525: ,p_count => x_msg_count
5526: ,p_data => x_msg_data);

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

5529: IF FND_API.TO_BOOLEAN(p_commit) THEN
5530: ROLLBACK TO Create_Attribute_PUB;
5531: END IF;
5532: x_return_status := FND_API.G_RET_STS_ERROR;
5533: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');
5534: FND_MSG_PUB.Add;
5535: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5536: ,p_count => x_msg_count
5537: ,p_data => x_msg_data);

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

5540: IF FND_API.TO_BOOLEAN(p_commit) THEN
5541: ROLLBACK TO Create_Attribute_PUB;
5542: END IF;
5543: x_return_status := FND_API.G_RET_STS_ERROR;
5544: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');
5545: FND_MSG_PUB.Add;
5546: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5547: ,p_count => x_msg_count
5548: ,p_data => x_msg_data);

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

5551: IF FND_API.TO_BOOLEAN(p_commit) THEN
5552: ROLLBACK TO Create_Attribute_PUB;
5553: END IF;
5554: x_return_status := FND_API.G_RET_STS_ERROR;
5555: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_NO_VS_ERR');
5556: FND_MSG_PUB.Add;
5557: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5558: ,p_count => x_msg_count
5559: ,p_data => x_msg_data);

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

5574: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attr_group_name
5575: AND LANGUAGE = USERENV('LANG');
5576:
5577: x_return_status := FND_API.G_RET_STS_ERROR;
5578: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5579: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', l_attr_group_disp_name);
5580: FND_MSG_PUB.Add;
5581: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5582: ,p_count => x_msg_count

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

5575: AND LANGUAGE = USERENV('LANG');
5576:
5577: x_return_status := FND_API.G_RET_STS_ERROR;
5578: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5579: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', l_attr_group_disp_name);
5580: FND_MSG_PUB.Add;
5581: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5582: ,p_count => x_msg_count
5583: ,p_data => x_msg_data);

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

5583: ,p_data => x_msg_data);
5584: EXCEPTION
5585: WHEN NO_DATA_FOUND THEN
5586: x_return_status := FND_API.G_RET_STS_ERROR;
5587: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5588: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', null);
5589: FND_MSG_PUB.Add;
5590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5591: ,p_count => x_msg_count

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

5584: EXCEPTION
5585: WHEN NO_DATA_FOUND THEN
5586: x_return_status := FND_API.G_RET_STS_ERROR;
5587: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5588: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', null);
5589: FND_MSG_PUB.Add;
5590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5591: ,p_count => x_msg_count
5592: ,p_data => x_msg_data);

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

5597: ROLLBACK TO Create_Attribute_PUB;
5598: END IF;
5599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5600:
5601: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
5602: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5603: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5604: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5605: FND_MSG_PUB.Add;

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

5598: END IF;
5599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5600:
5601: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
5602: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5603: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5604: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5605: FND_MSG_PUB.Add;
5606: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

5599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5600:
5601: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
5602: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5603: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5604: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5605: FND_MSG_PUB.Add;
5606: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5607: ,p_count => x_msg_count

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

5600:
5601: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
5602: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5603: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5604: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5605: FND_MSG_PUB.Add;
5606: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5607: ,p_count => x_msg_count
5608: ,p_data => x_msg_data);

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

6015: IF FND_API.To_Boolean(p_commit) THEN
6016: ROLLBACK TO Update_Attribute_PUB;
6017: END IF;
6018: x_return_status := FND_API.G_RET_STS_ERROR;
6019: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
6020: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
6021: FND_MSG_PUB.Add;
6022: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6023: ,p_count => x_msg_count

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

6016: ROLLBACK TO Update_Attribute_PUB;
6017: END IF;
6018: x_return_status := FND_API.G_RET_STS_ERROR;
6019: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
6020: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
6021: FND_MSG_PUB.Add;
6022: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6023: ,p_count => x_msg_count
6024: ,p_data => x_msg_data);

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

6027: IF FND_API.To_Boolean(p_commit) THEN
6028: ROLLBACK TO Update_Attribute_PUB;
6029: END IF;
6030: x_return_status := FND_API.G_RET_STS_ERROR;
6031: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ATTR_DUP_SEQ_ERR');
6032: FND_MSG_PUB.Add;
6033: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6034: ,p_count => x_msg_count
6035: ,p_data => x_msg_data);

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

6037: IF FND_API.TO_BOOLEAN(p_commit) THEN
6038: ROLLBACK TO Update_Attribute_PUB;
6039: END IF;
6040: x_return_status := FND_API.G_RET_STS_ERROR;
6041: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');
6042: FND_MSG_PUB.Add;
6043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6044: ,p_count => x_msg_count
6045: ,p_data => x_msg_data);

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

6049: IF FND_API.To_Boolean(p_commit) THEN
6050: ROLLBACK TO Update_Attribute_PUB;
6051: END IF;
6052: x_return_status := FND_API.G_RET_STS_ERROR;
6053: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');
6054: FND_MSG_PUB.Add;
6055: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6056: ,p_count => x_msg_count
6057: ,p_data => x_msg_data);

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

6061: ROLLBACK TO Update_Attribute_PUB;
6062: END IF;
6063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6064:
6065: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6066: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6067: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6068: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6069: FND_MSG_PUB.Add;

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

6062: END IF;
6063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6064:
6065: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6066: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6067: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6068: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6069: FND_MSG_PUB.Add;
6070: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

6063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6064:
6065: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6066: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6067: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6068: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6069: FND_MSG_PUB.Add;
6070: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6071: ,p_count => x_msg_count

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

6064:
6065: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6066: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6067: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6068: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6069: FND_MSG_PUB.Add;
6070: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6071: ,p_count => x_msg_count
6072: ,p_data => x_msg_data);

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

6435: code_debug(l_api_name ||' EXCEPTION - OTHERS '||SQLERRM);
6436: IF FND_API.To_Boolean( p_commit ) THEN
6437: ROLLBACK TO Create_Value_Set_PUB;
6438: END IF;
6439: x_msg_data := fnd_message.get();
6440: IF x_msg_data IS NULL THEN
6441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6442: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

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

6438: END IF;
6439: x_msg_data := fnd_message.get();
6440: IF x_msg_data IS NULL THEN
6441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6442: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6444: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6445: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
6446: FND_MSG_PUB.Add;

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

6439: x_msg_data := fnd_message.get();
6440: IF x_msg_data IS NULL THEN
6441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6442: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6444: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6445: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
6446: FND_MSG_PUB.Add;
6447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

6440: IF x_msg_data IS NULL THEN
6441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6442: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6444: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6445: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
6446: FND_MSG_PUB.Add;
6447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6448: ,p_count => x_msg_count

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

6441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6442: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6444: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6445: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
6446: FND_MSG_PUB.Add;
6447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6448: ,p_count => x_msg_count
6449: ,p_data => x_msg_data);

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

6727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6728:
6729: code_debug('SQL_ERR_MSG ' || SQLERRM);
6730:
6731: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6732: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6733: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6734: FND_MSG_PUB.Add;
6735: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

6728:
6729: code_debug('SQL_ERR_MSG ' || SQLERRM);
6730:
6731: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6732: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6733: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6734: FND_MSG_PUB.Add;
6735: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6736: ,p_count => x_msg_count

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

6729: code_debug('SQL_ERR_MSG ' || SQLERRM);
6730:
6731: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6732: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6733: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6734: FND_MSG_PUB.Add;
6735: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6736: ,p_count => x_msg_count
6737: ,p_data => x_msg_data);

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

6967: ROLLBACK TO Update_Value_Set_PUB;
6968: END IF;
6969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6970:
6971: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6972: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6973: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6974: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6975: FND_MSG_PUB.Add;

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

6968: END IF;
6969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6970:
6971: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6972: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6973: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6974: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6975: FND_MSG_PUB.Add;
6976: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

6969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6970:
6971: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6972: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6973: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6974: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6975: FND_MSG_PUB.Add;
6976: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6977: ,p_count => x_msg_count

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

6970:
6971: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
6972: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6973: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6974: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6975: FND_MSG_PUB.Add;
6976: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6977: ,p_count => x_msg_count
6978: ,p_data => x_msg_data);

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

7152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7153:
7154: code_debug('SQL_ERR_MSG ' || SQLERRM);
7155:
7156: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7157: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7158: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7159: FND_MSG_PUB.Add;
7160: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

7153:
7154: code_debug('SQL_ERR_MSG ' || SQLERRM);
7155:
7156: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7157: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7158: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7159: FND_MSG_PUB.Add;
7160: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7161: ,p_count => x_msg_count

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

7154: code_debug('SQL_ERR_MSG ' || SQLERRM);
7155:
7156: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7157: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7158: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7159: FND_MSG_PUB.Add;
7160: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7161: ,p_count => x_msg_count
7162: ,p_data => x_msg_data);

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

7330: ROLLBACK TO Insert_Value_Set_Table_Inf_PUB;
7331: END IF;
7332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7333:
7334: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7335: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7336: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7337: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7338: FND_MSG_PUB.Add;

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

7331: END IF;
7332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7333:
7334: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7335: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7336: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7337: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7338: FND_MSG_PUB.Add;
7339: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

7332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7333:
7334: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7335: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7336: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7337: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7338: FND_MSG_PUB.Add;
7339: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7340: ,p_count => x_msg_count

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

7333:
7334: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7335: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7336: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7337: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7338: FND_MSG_PUB.Add;
7339: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7340: ,p_count => x_msg_count
7341: ,p_data => x_msg_data);

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

7473: ROLLBACK TO Update_Value_Set_Table_Inf_PUB;
7474: END IF;
7475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7476:
7477: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7478: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7479: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7480: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7481: FND_MSG_PUB.Add;

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

7474: END IF;
7475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7476:
7477: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7478: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7479: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7480: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7481: FND_MSG_PUB.Add;
7482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

7475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7476:
7477: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7478: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7479: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7480: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7481: FND_MSG_PUB.Add;
7482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7483: ,p_count => x_msg_count

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

7476:
7477: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7478: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7479: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7480: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7481: FND_MSG_PUB.Add;
7482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7483: ,p_count => x_msg_count
7484: ,p_data => x_msg_data);

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

7669: ROLLBACK TO Create_Value_Set_Val_PUB;
7670: END IF;
7671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7672:
7673: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7674: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7675: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7676: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7677: FND_MSG_PUB.Add;

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

7670: END IF;
7671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7672:
7673: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7674: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7675: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7676: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7677: FND_MSG_PUB.Add;
7678: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

7671: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7672:
7673: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7674: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7675: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7676: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7677: FND_MSG_PUB.Add;
7678: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7679: ,p_count => x_msg_count

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

7672:
7673: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7674: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7675: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7676: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7677: FND_MSG_PUB.Add;
7678: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7679: ,p_count => x_msg_count
7680: ,p_data => x_msg_data);

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

7796: ROLLBACK TO Update_Value_Set_Val_PUB;
7797: END IF;
7798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7799:
7800: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7804: FND_MSG_PUB.Add;

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

7797: END IF;
7798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7799:
7800: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7804: FND_MSG_PUB.Add;
7805: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

7798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7799:
7800: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7804: FND_MSG_PUB.Add;
7805: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7806: ,p_count => x_msg_count

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

7799:
7800: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
7801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7804: FND_MSG_PUB.Add;
7805: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7806: ,p_count => x_msg_count
7807: ,p_data => x_msg_data);

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

8205: END IF;
8206: END IF;
8207:
8208: IF l_invalid_params THEN
8209: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
8210: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
8211: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
8212: FND_MSG_PUB.Add;
8213: RAISE FND_API.G_EXC_ERROR;

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

8206: END IF;
8207:
8208: IF l_invalid_params THEN
8209: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
8210: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
8211: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
8212: FND_MSG_PUB.Add;
8213: RAISE FND_API.G_EXC_ERROR;
8214: END IF;

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

8207:
8208: IF l_invalid_params THEN
8209: fnd_message.Set_Name(G_APP_NAME, 'EGO_API_INVALID_PARAMS');
8210: fnd_message.Set_Token(G_PKG_NAME_TOKEN, G_PKG_NAME);
8211: fnd_message.Set_Token(G_API_NAME_TOKEN, l_api_name);
8212: FND_MSG_PUB.Add;
8213: RAISE FND_API.G_EXC_ERROR;
8214: END IF;
8215:

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

8378: AND AGV.ATTR_GROUP_NAME = AV.ATTR_GROUP_NAME
8379: AND AGV.ATTR_GROUP_ID = p_attr_group_id;
8380:
8381: IF(l_attr_count = 0 AND l_variant_flag = 'Y') THEN
8382: Fnd_Message.Set_Name (application => 'EGO',
8383: name => 'EGO_EF_NO_ATTR_EXIST'
8384: );
8385: FND_MSG_PUB.Add;
8386: RAISE e_variant_assocs_excep;

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

8419:
8420:
8421: --EXECUTE IMMEDIATE l_dyn_sql;
8422: IF(l_style_exists = 'T' AND l_variant_flag = 'Y') THEN
8423: Fnd_Message.Set_Name (application => 'EGO',
8424: name => 'EGO_VARIANT_STYLE_EXIST'
8425: );
8426: FND_MSG_PUB.Add;
8427: RAISE e_variant_assocs_excep;

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

8543:
8544: l_data_level_name := Get_Data_Level_DispName(l_existing_datalevel);
8545:
8546:
8547: Fnd_Message.Set_Name (application => 'EGO',
8548: name => 'EGO_EF_DL_MISMATCH_ERR'
8549: );
8550:
8551: Fnd_Message.Set_Token ( token => 'ATTR_GROUP'

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

8547: Fnd_Message.Set_Name (application => 'EGO',
8548: name => 'EGO_EF_DL_MISMATCH_ERR'
8549: );
8550:
8551: Fnd_Message.Set_Token ( token => 'ATTR_GROUP'
8552: , value => l_attr_disp_name
8553: , translate => false
8554: );
8555:

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

8553: , translate => false
8554: );
8555:
8556:
8557: Fnd_Message.Set_Token ( token => 'DATA_LEVEL'
8558: , value => l_data_level_name
8559: , translate => false
8560: );
8561:

Line 8562: x_msg_data := Fnd_Message.Get;

8558: , value => l_data_level_name
8559: , translate => false
8560: );
8561:
8562: x_msg_data := Fnd_Message.Get;
8563:
8564: WHEN e_variant_assocs_excep THEN
8565: IF FND_API.To_Boolean(p_commit) THEN
8566: ROLLBACK TO Create_Association_PUB;

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

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

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

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

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

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

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

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

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

8666:
8667: IF l_attr_group_id IS NULL THEN
8668: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
8669: ELSE
8670: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8671: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8672: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8673: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8674: FND_MSG_PUB.Add;

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

8667: IF l_attr_group_id IS NULL THEN
8668: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
8669: ELSE
8670: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8671: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8672: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8673: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8674: FND_MSG_PUB.Add;
8675: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

8668: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
8669: ELSE
8670: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8671: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8672: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8673: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8674: FND_MSG_PUB.Add;
8675: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8676: ,p_count => x_msg_count

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

8669: ELSE
8670: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8671: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8672: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8673: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8674: FND_MSG_PUB.Add;
8675: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8676: ,p_count => x_msg_count
8677: ,p_data => x_msg_data);

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

8751:
8752: IF l_object_id IS NULL THEN
8753: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoObjectIdForObjectName';
8754: ELSE
8755: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8756: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8757: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8758: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8759: FND_MSG_PUB.Add;

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

8752: IF l_object_id IS NULL THEN
8753: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoObjectIdForObjectName';
8754: ELSE
8755: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8756: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8757: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8758: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8759: FND_MSG_PUB.Add;
8760: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

8753: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoObjectIdForObjectName';
8754: ELSE
8755: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8756: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8757: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8758: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8759: FND_MSG_PUB.Add;
8760: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8761: ,p_count => x_msg_count

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

8754: ELSE
8755: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8756: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8757: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8758: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8759: FND_MSG_PUB.Add;
8760: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8761: ,p_count => x_msg_count
8762: ,p_data => x_msg_data);

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

8834: ROLLBACK TO Update_Association_PUB;
8835: END IF;
8836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8837:
8838: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8839: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8840: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8841: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8842: FND_MSG_PUB.Add;

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

8835: END IF;
8836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8837:
8838: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8839: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8840: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8841: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8842: FND_MSG_PUB.Add;
8843: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

8836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8837:
8838: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8839: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8840: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8841: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8842: FND_MSG_PUB.Add;
8843: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8844: ,p_count => x_msg_count

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

8837:
8838: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8839: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8840: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8841: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8842: FND_MSG_PUB.Add;
8843: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8844: ,p_count => x_msg_count
8845: ,p_data => x_msg_data);

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

8911:
8912: IF l_association_id IS NULL THEN
8913: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
8914: ELSE
8915: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8916: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8917: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8918: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8919: FND_MSG_PUB.Add;

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

8912: IF l_association_id IS NULL THEN
8913: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
8914: ELSE
8915: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8916: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8917: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8918: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8919: FND_MSG_PUB.Add;
8920: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

8913: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
8914: ELSE
8915: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8916: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8917: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8918: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8919: FND_MSG_PUB.Add;
8920: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8921: ,p_count => x_msg_count

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

8914: ELSE
8915: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
8916: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8917: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8918: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8919: FND_MSG_PUB.Add;
8920: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8921: ,p_count => x_msg_count
8922: ,p_data => x_msg_data);

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

9002: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
9003: ELSIF l_association_id IS NULL THEN
9004: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
9005: ELSE
9006: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9007: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9008: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9009: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9010: FND_MSG_PUB.Add;

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

9003: ELSIF l_association_id IS NULL THEN
9004: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
9005: ELSE
9006: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9007: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9008: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9009: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9010: FND_MSG_PUB.Add;
9011: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9004: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAssocFound';
9005: ELSE
9006: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9007: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9008: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9009: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9010: FND_MSG_PUB.Add;
9011: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9012: ,p_count => x_msg_count

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

9005: ELSE
9006: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9007: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9008: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9009: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9010: FND_MSG_PUB.Add;
9011: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9012: ,p_count => x_msg_count
9013: ,p_data => x_msg_data);

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

9226: CLOSE get_assoc_records;
9227: END IF;
9228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9229:
9230: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9231: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9232: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9233: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9234: FND_MSG_PUB.Add;

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

9227: END IF;
9228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9229:
9230: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9231: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9232: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9233: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9234: FND_MSG_PUB.Add;
9235: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9229:
9230: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9231: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9232: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9233: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9234: FND_MSG_PUB.Add;
9235: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9236: ,p_count => x_msg_count

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

9229:
9230: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9231: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9232: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9233: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9234: FND_MSG_PUB.Add;
9235: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9236: ,p_count => x_msg_count
9237: ,p_data => x_msg_data);

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

9369: ROLLBACK TO Create_Page_PUB;
9370: END IF;
9371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9372:
9373: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9374: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9375: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9376: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9377: FND_MSG_PUB.Add;

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

9370: END IF;
9371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9372:
9373: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9374: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9375: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9376: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9377: FND_MSG_PUB.Add;
9378: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9372:
9373: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9374: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9375: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9376: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9377: FND_MSG_PUB.Add;
9378: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9379: ,p_count => x_msg_count

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

9372:
9373: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9374: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9375: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9376: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9377: FND_MSG_PUB.Add;
9378: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9379: ,p_count => x_msg_count
9380: ,p_data => x_msg_data);

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

9471: ROLLBACK TO Update_Page_PUB;
9472: END IF;
9473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9474:
9475: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9476: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9477: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9478: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9479: FND_MSG_PUB.Add;

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

9472: END IF;
9473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9474:
9475: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9476: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9477: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9478: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9479: FND_MSG_PUB.Add;
9480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9474:
9475: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9476: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9477: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9478: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9479: FND_MSG_PUB.Add;
9480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9481: ,p_count => x_msg_count

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

9474:
9475: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9476: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9477: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9478: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9479: FND_MSG_PUB.Add;
9480: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9481: ,p_count => x_msg_count
9482: ,p_data => x_msg_data);

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

9559:
9560: IF l_page_id IS NULL THEN
9561: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
9562: ELSE
9563: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9564: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9565: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9566: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9567: FND_MSG_PUB.Add;

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

9560: IF l_page_id IS NULL THEN
9561: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
9562: ELSE
9563: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9564: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9565: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9566: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9567: FND_MSG_PUB.Add;
9568: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9561: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
9562: ELSE
9563: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9564: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9565: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9566: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9567: FND_MSG_PUB.Add;
9568: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9569: ,p_count => x_msg_count

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

9562: ELSE
9563: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9564: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9565: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9566: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9567: FND_MSG_PUB.Add;
9568: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9569: ,p_count => x_msg_count
9570: ,p_data => x_msg_data);

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

9633: ROLLBACK TO Delete_Page_PUB;
9634: END IF;
9635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9636:
9637: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9638: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9639: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9640: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9641: FND_MSG_PUB.Add;

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

9634: END IF;
9635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9636:
9637: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9638: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9639: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9640: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9641: FND_MSG_PUB.Add;
9642: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9636:
9637: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9638: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9639: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9640: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9641: FND_MSG_PUB.Add;
9642: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9643: ,p_count => x_msg_count

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

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

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

9704:
9705: IF l_page_id IS NULL THEN
9706: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
9707: ELSE
9708: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9709: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9710: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9711: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9712: FND_MSG_PUB.Add;

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

9705: IF l_page_id IS NULL THEN
9706: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
9707: ELSE
9708: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9709: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9710: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9711: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9712: FND_MSG_PUB.Add;
9713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9706: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoPageFound';
9707: ELSE
9708: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9709: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9710: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9711: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9712: FND_MSG_PUB.Add;
9713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9714: ,p_count => x_msg_count

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

9707: ELSE
9708: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9709: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9710: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9711: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9712: FND_MSG_PUB.Add;
9713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9714: ,p_count => x_msg_count
9715: ,p_data => x_msg_data);

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

9874: WHERE A.ASSOCIATION_ID = PE.ASSOCIATION_ID
9875: AND PE.PAGE_ID = p_page_id
9876: AND PE.ASSOCIATION_ID = p_association_id;
9877:
9878: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
9879: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
9880: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
9881: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
9882: FND_MSG_PUB.Add;

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

9875: AND PE.PAGE_ID = p_page_id
9876: AND PE.ASSOCIATION_ID = p_association_id;
9877:
9878: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
9879: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
9880: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
9881: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
9882: FND_MSG_PUB.Add;
9883: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9876: AND PE.ASSOCIATION_ID = p_association_id;
9877:
9878: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
9879: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
9880: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
9881: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
9882: FND_MSG_PUB.Add;
9883: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9884: ,p_count => x_msg_count

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

9877:
9878: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
9879: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
9880: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
9881: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
9882: FND_MSG_PUB.Add;
9883: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9884: ,p_count => x_msg_count
9885: ,p_data => x_msg_data);

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

9891: EXCEPTION
9892: WHEN OTHERS THEN
9893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9894:
9895: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9897: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9898: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9899: FND_MSG_PUB.Add;

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

9892: WHEN OTHERS THEN
9893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9894:
9895: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9897: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9898: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9899: FND_MSG_PUB.Add;
9900: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9894:
9895: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9897: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9898: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9899: FND_MSG_PUB.Add;
9900: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9901: ,p_count => x_msg_count

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

9894:
9895: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9896: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9897: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9898: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9899: FND_MSG_PUB.Add;
9900: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9901: ,p_count => x_msg_count
9902: ,p_data => x_msg_data);

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

9907: ROLLBACK TO Create_Page_Entry_PUB;
9908: END IF;
9909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9910:
9911: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9912: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9913: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9914: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9915: FND_MSG_PUB.Add;

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

9908: END IF;
9909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9910:
9911: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9912: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9913: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9914: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9915: FND_MSG_PUB.Add;
9916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

9909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9910:
9911: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9912: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9913: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9914: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9915: FND_MSG_PUB.Add;
9916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9917: ,p_count => x_msg_count

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

9910:
9911: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
9912: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9913: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9914: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9915: FND_MSG_PUB.Add;
9916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9917: ,p_count => x_msg_count
9918: ,p_data => x_msg_data);

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

10001: WHERE A.ASSOCIATION_ID = PE.ASSOCIATION_ID
10002: AND PE.PAGE_ID = p_page_id
10003: AND PE.ASSOCIATION_ID = p_new_association_id;
10004:
10005: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10006: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10007: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10008: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10009: FND_MSG_PUB.Add;

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

10002: AND PE.PAGE_ID = p_page_id
10003: AND PE.ASSOCIATION_ID = p_new_association_id;
10004:
10005: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10006: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10007: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10008: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10009: FND_MSG_PUB.Add;
10010: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

10003: AND PE.ASSOCIATION_ID = p_new_association_id;
10004:
10005: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10006: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10007: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10008: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10009: FND_MSG_PUB.Add;
10010: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10011: ,p_count => x_msg_count

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

10004:
10005: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_ALREADY_IN_PAGE');
10006: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10007: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10008: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10009: FND_MSG_PUB.Add;
10010: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10011: ,p_count => x_msg_count
10012: ,p_data => x_msg_data);

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

10018: EXCEPTION
10019: WHEN OTHERS THEN
10020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10021:
10022: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10023: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10024: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10025: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10026: FND_MSG_PUB.Add;

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

10019: WHEN OTHERS THEN
10020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10021:
10022: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10023: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10024: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10025: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10026: FND_MSG_PUB.Add;
10027: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

10020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10021:
10022: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10023: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10024: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10025: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10026: FND_MSG_PUB.Add;
10027: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10028: ,p_count => x_msg_count

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

10021:
10022: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10023: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10024: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10025: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10026: FND_MSG_PUB.Add;
10027: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10028: ,p_count => x_msg_count
10029: ,p_data => x_msg_data);

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

10034: ROLLBACK TO Update_Page_Entry_PUB;
10035: END IF;
10036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10037:
10038: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10039: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10040: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10041: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10042: FND_MSG_PUB.Add;

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

10035: END IF;
10036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10037:
10038: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10039: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10040: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10041: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10042: FND_MSG_PUB.Add;
10043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

10036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10037:
10038: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10039: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10040: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10041: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10042: FND_MSG_PUB.Add;
10043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10044: ,p_count => x_msg_count

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

10037:
10038: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10039: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10040: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10041: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10042: FND_MSG_PUB.Add;
10043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10044: ,p_count => x_msg_count
10045: ,p_data => x_msg_data);

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

10106: ROLLBACK TO Delete_Page_Entry_PUB;
10107: END IF;
10108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10109:
10110: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10111: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10112: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10113: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10114: FND_MSG_PUB.Add;

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

10107: END IF;
10108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10109:
10110: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10111: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10112: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10113: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10114: FND_MSG_PUB.Add;
10115: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

10108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10109:
10110: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10111: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10112: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10113: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10114: FND_MSG_PUB.Add;
10115: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10116: ,p_count => x_msg_count

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

10109:
10110: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10111: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10112: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10113: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10114: FND_MSG_PUB.Add;
10115: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10116: ,p_count => x_msg_count
10117: ,p_data => x_msg_data);

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

10240: ROLLBACK TO Create_Function_PUB;
10241: END IF;
10242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10243:
10244: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10245: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10246: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10247: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10248: FND_MSG_PUB.Add;

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

10241: END IF;
10242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10243:
10244: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10245: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10246: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10247: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10248: FND_MSG_PUB.Add;
10249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

10242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10243:
10244: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10245: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10246: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10247: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10248: FND_MSG_PUB.Add;
10249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10250: ,p_count => x_msg_count

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

10243:
10244: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10245: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10246: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10247: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10248: FND_MSG_PUB.Add;
10249: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10250: ,p_count => x_msg_count
10251: ,p_data => x_msg_data);

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

10335: ROLLBACK TO Update_Function_PUB;
10336: END IF;
10337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10338:
10339: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10340: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10341: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10342: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10343: FND_MSG_PUB.Add;

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

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

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

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

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

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

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

10445: ROLLBACK TO Delete_Function_PUB;
10446: END IF;
10447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10448:
10449: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10450: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10451: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10452: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10453: FND_MSG_PUB.Add;

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

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

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

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

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

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

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

10630: ROLLBACK TO Create_Action_PUB;
10631: END IF;
10632: x_return_status := FND_API.G_RET_STS_ERROR;
10633: x_errorcode := 1;
10634: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_SEQ_ERR');
10635: FND_MSG_PUB.Add;
10636: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10637: ,p_count => x_msg_count
10638: ,p_data => x_msg_data);

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

10642: ROLLBACK TO Create_Action_PUB;
10643: END IF;
10644: x_return_status := FND_API.G_RET_STS_ERROR;
10645: x_errorcode := 1;
10646: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_NAME_ERR');
10647: FND_MSG_PUB.Add;
10648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10649: ,p_count => x_msg_count
10650: ,p_data => x_msg_data);

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

10654: ROLLBACK TO Create_Action_PUB;
10655: END IF;
10656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10657: x_errorcode := 1;
10658: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10659: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10660: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10661: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10662: FND_MSG_PUB.Add;

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

10655: END IF;
10656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10657: x_errorcode := 1;
10658: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10659: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10660: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10661: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10662: FND_MSG_PUB.Add;
10663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

10656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10657: x_errorcode := 1;
10658: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10659: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10660: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10661: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10662: FND_MSG_PUB.Add;
10663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10664: ,p_count => x_msg_count

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

10657: x_errorcode := 1;
10658: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10659: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10660: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10661: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10662: FND_MSG_PUB.Add;
10663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10664: ,p_count => x_msg_count
10665: ,p_data => x_msg_data);

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

10743:
10744: IF l_attr_group_id IS NULL THEN
10745: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
10746: ELSE
10747: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10748: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10749: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10750: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10751: FND_MSG_PUB.Add;

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

10744: IF l_attr_group_id IS NULL THEN
10745: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
10746: ELSE
10747: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10748: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10749: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10750: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10751: FND_MSG_PUB.Add;
10752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

10745: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupIDFoundForPKs';
10746: ELSE
10747: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10748: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10749: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10750: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10751: FND_MSG_PUB.Add;
10752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10753: ,p_count => x_msg_count

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

10746: ELSE
10747: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10748: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10749: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10750: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10751: FND_MSG_PUB.Add;
10752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10753: ,p_count => x_msg_count
10754: ,p_data => x_msg_data);

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

10913: ROLLBACK TO Update_Action_PUB;
10914: END IF;
10915: x_return_status := FND_API.G_RET_STS_ERROR;
10916: x_errorcode := 1;
10917: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_SEQ_ERR');
10918: FND_MSG_PUB.Add;
10919: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10920: ,p_count => x_msg_count
10921: ,p_data => x_msg_data);

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

10925: ROLLBACK TO Update_Action_PUB;
10926: END IF;
10927: x_return_status := FND_API.G_RET_STS_ERROR;
10928: x_errorcode := 1;
10929: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_NAME_ERR');
10930: FND_MSG_PUB.Add;
10931: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10932: ,p_count => x_msg_count
10933: ,p_data => x_msg_data);

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

10937: ROLLBACK TO Update_Action_PUB;
10938: END IF;
10939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10940:
10941: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10942: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10943: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10944: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10945: FND_MSG_PUB.Add;

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

10938: END IF;
10939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10940:
10941: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10942: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10943: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10944: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10945: FND_MSG_PUB.Add;
10946: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

10939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10940:
10941: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10942: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10943: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10944: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10945: FND_MSG_PUB.Add;
10946: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10947: ,p_count => x_msg_count

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

10940:
10941: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
10942: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10943: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10944: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10945: FND_MSG_PUB.Add;
10946: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10947: ,p_count => x_msg_count
10948: ,p_data => x_msg_data);

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

11048: ROLLBACK TO Delete_Action_PUB;
11049: END IF;
11050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11051:
11052: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11053: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11054: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11055: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11056: FND_MSG_PUB.Add;

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

11049: END IF;
11050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11051:
11052: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11053: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11054: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11055: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11056: FND_MSG_PUB.Add;
11057: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

11050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11051:
11052: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11053: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11054: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11055: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11056: FND_MSG_PUB.Add;
11057: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11058: ,p_count => x_msg_count

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

11051:
11052: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11053: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11054: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11055: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11056: FND_MSG_PUB.Add;
11057: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11058: ,p_count => x_msg_count
11059: ,p_data => x_msg_data);

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

11140: ROLLBACK TO Create_Visibilty_DL_PUB;
11141: END IF;
11142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11143:
11144: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11145: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11146: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11147: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11148: FND_MSG_PUB.Add;

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

11141: END IF;
11142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11143:
11144: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11145: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11146: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11147: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11148: FND_MSG_PUB.Add;
11149: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

11142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11143:
11144: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11145: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11146: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11147: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11148: FND_MSG_PUB.Add;
11149: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11150: ,p_count => x_msg_count

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

11143:
11144: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11145: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11146: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11147: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11148: FND_MSG_PUB.Add;
11149: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11150: ,p_count => x_msg_count
11151: ,p_data => x_msg_data);

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

11244: ROLLBACK TO Create_Action_Display_PUB;
11245: END IF;
11246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11247:
11248: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11249: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11250: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11251: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11252: FND_MSG_PUB.Add;

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

11245: END IF;
11246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11247:
11248: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11249: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11250: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11251: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11252: FND_MSG_PUB.Add;
11253: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

11246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11247:
11248: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11249: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11250: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11251: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11252: FND_MSG_PUB.Add;
11253: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11254: ,p_count => x_msg_count

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

11247:
11248: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11249: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11250: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11251: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11252: FND_MSG_PUB.Add;
11253: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11254: ,p_count => x_msg_count
11255: ,p_data => x_msg_data);

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

11335: ROLLBACK TO Create_Action_Display_PUB;
11336: END IF;
11337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11338:
11339: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11340: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11341: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11342: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11343: FND_MSG_PUB.Add;

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

11336: END IF;
11337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11338:
11339: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11340: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11341: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11342: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11343: FND_MSG_PUB.Add;
11344: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

11337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11338:
11339: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11340: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11341: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11342: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11343: FND_MSG_PUB.Add;
11344: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11345: ,p_count => x_msg_count

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

11338:
11339: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11340: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11341: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11342: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11343: FND_MSG_PUB.Add;
11344: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11345: ,p_count => x_msg_count
11346: ,p_data => x_msg_data);

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

11506: ROLLBACK TO Update_Action_Display_PUB;
11507: END IF;
11508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11509:
11510: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11511: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11512: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11513: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11514: FND_MSG_PUB.Add;

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

11507: END IF;
11508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11509:
11510: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11511: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11512: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11513: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11514: FND_MSG_PUB.Add;
11515: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

11508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11509:
11510: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11511: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11512: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11513: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11514: FND_MSG_PUB.Add;
11515: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11516: ,p_count => x_msg_count

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

11509:
11510: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11511: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11512: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11513: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11514: FND_MSG_PUB.Add;
11515: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11516: ,p_count => x_msg_count
11517: ,p_data => x_msg_data);

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

11666: ROLLBACK TO Update_Action_Display_PUB;
11667: END IF;
11668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11669:
11670: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11671: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11672: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11673: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11674: FND_MSG_PUB.Add;

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

11667: END IF;
11668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11669:
11670: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11671: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11672: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11673: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11674: FND_MSG_PUB.Add;
11675: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

11668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11669:
11670: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11671: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11672: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11673: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11674: FND_MSG_PUB.Add;
11675: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11676: ,p_count => x_msg_count

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

11669:
11670: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11671: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11672: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11673: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11674: FND_MSG_PUB.Add;
11675: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11676: ,p_count => x_msg_count
11677: ,p_data => x_msg_data);

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

11785: ROLLBACK TO Delete_Action_Display_PUB;
11786: END IF;
11787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11788:
11789: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11790: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11791: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11792: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11793: FND_MSG_PUB.Add;

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

11786: END IF;
11787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11788:
11789: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11790: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11791: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11792: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11793: FND_MSG_PUB.Add;
11794: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

11787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11788:
11789: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11790: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11791: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11792: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11793: FND_MSG_PUB.Add;
11794: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11795: ,p_count => x_msg_count

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

11788:
11789: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11790: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11791: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11792: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11793: FND_MSG_PUB.Add;
11794: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11795: ,p_count => x_msg_count
11796: ,p_data => x_msg_data);

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

11919: ROLLBACK TO Create_Function_Param_PUB;
11920: END IF;
11921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11922:
11923: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11924: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11925: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11926: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11927: FND_MSG_PUB.Add;

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

11920: END IF;
11921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11922:
11923: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11924: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11925: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11926: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11927: FND_MSG_PUB.Add;
11928: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

11921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11922:
11923: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11924: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11925: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11926: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11927: FND_MSG_PUB.Add;
11928: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11929: ,p_count => x_msg_count

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

11922:
11923: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
11924: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11925: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11926: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11927: FND_MSG_PUB.Add;
11928: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11929: ,p_count => x_msg_count
11930: ,p_data => x_msg_data);

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

12010: ROLLBACK TO Update_Function_Param_PUB;
12011: END IF;
12012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12013:
12014: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12015: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12016: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12017: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12018: FND_MSG_PUB.Add;

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

12011: END IF;
12012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12013:
12014: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12015: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12016: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12017: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12018: FND_MSG_PUB.Add;
12019: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12013:
12014: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12015: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12016: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12017: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12018: FND_MSG_PUB.Add;
12019: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12020: ,p_count => x_msg_count

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

12013:
12014: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12015: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12016: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12017: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12018: FND_MSG_PUB.Add;
12019: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12020: ,p_count => x_msg_count
12021: ,p_data => x_msg_data);

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

12088: ROLLBACK TO Delete_Function_Param_PUB;
12089: END IF;
12090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12091:
12092: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12093: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12094: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12095: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12096: FND_MSG_PUB.Add;

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

12089: END IF;
12090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12091:
12092: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12093: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12094: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12095: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12096: FND_MSG_PUB.Add;
12097: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12091:
12092: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12093: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12094: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12095: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12096: FND_MSG_PUB.Add;
12097: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12098: ,p_count => x_msg_count

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

12091:
12092: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12093: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12094: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12095: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12096: FND_MSG_PUB.Add;
12097: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12098: ,p_count => x_msg_count
12099: ,p_data => x_msg_data);

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

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

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

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

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

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

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

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

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

12302:
12303: IF l_application_id IS NULL THEN
12304: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
12305: ELSE
12306: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12307: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12308: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12309: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12310: FND_MSG_PUB.Add;

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

12303: IF l_application_id IS NULL THEN
12304: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
12305: ELSE
12306: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12307: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12308: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12309: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12310: FND_MSG_PUB.Add;
12311: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12304: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
12305: ELSE
12306: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12307: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12308: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12309: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12310: FND_MSG_PUB.Add;
12311: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12312: ,p_count => x_msg_count

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

12305: ELSE
12306: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12307: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12308: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12309: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12310: FND_MSG_PUB.Add;
12311: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12312: ,p_count => x_msg_count
12313: ,p_data => x_msg_data);

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

12438: ROLLBACK TO Update_Mapping_PUB;
12439: END IF;
12440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12441:
12442: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12444: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12445: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12446: FND_MSG_PUB.Add;

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

12439: END IF;
12440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12441:
12442: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12444: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12445: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12446: FND_MSG_PUB.Add;
12447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12441:
12442: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12444: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12445: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12446: FND_MSG_PUB.Add;
12447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12448: ,p_count => x_msg_count

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

12441:
12442: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12444: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12445: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12446: FND_MSG_PUB.Add;
12447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12448: ,p_count => x_msg_count
12449: ,p_data => x_msg_data);

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

12540:
12541: IF l_application_id IS NULL THEN
12542: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
12543: ELSE
12544: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12545: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12546: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12547: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12548: FND_MSG_PUB.Add;

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

12541: IF l_application_id IS NULL THEN
12542: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
12543: ELSE
12544: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12545: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12546: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12547: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12548: FND_MSG_PUB.Add;
12549: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12542: x_msg_data := 'Executing - '||G_PKG_NAME||'.'||l_api_name||' NoAttrGroupApplicationIDFoundForPKs';
12543: ELSE
12544: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12545: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12546: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12547: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12548: FND_MSG_PUB.Add;
12549: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12550: ,p_count => x_msg_count

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

12543: ELSE
12544: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12545: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12546: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12547: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12548: FND_MSG_PUB.Add;
12549: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12550: ,p_count => x_msg_count
12551: ,p_data => x_msg_data);

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

12614: ROLLBACK TO Delete_Func_Mapping_PUB;
12615: END IF;
12616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12617:
12618: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12619: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12620: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12621: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12622: FND_MSG_PUB.Add;

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

12615: END IF;
12616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12617:
12618: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12619: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12620: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12621: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12622: FND_MSG_PUB.Add;
12623: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12617:
12618: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12619: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12620: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12621: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12622: FND_MSG_PUB.Add;
12623: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12624: ,p_count => x_msg_count

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

12617:
12618: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12619: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12620: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12621: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12622: FND_MSG_PUB.Add;
12623: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12624: ,p_count => x_msg_count
12625: ,p_data => x_msg_data);

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

12689: ROLLBACK TO Delete_Func_Param_Mapping_PUB;
12690: END IF;
12691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12692:
12693: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12694: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12695: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12696: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12697: FND_MSG_PUB.Add;

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

12690: END IF;
12691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12692:
12693: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12694: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12695: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12696: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12697: FND_MSG_PUB.Add;
12698: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12692:
12693: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12694: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12695: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12696: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12697: FND_MSG_PUB.Add;
12698: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12699: ,p_count => x_msg_count

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

12692:
12693: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12694: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12695: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12696: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12697: FND_MSG_PUB.Add;
12698: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12699: ,p_count => x_msg_count
12700: ,p_data => x_msg_data);

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

12824: ROLLBACK TO Create_Action_Group_PUB;
12825: END IF;
12826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12827:
12828: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12829: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12830: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12831: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12832: FND_MSG_PUB.Add;

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

12825: END IF;
12826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12827:
12828: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12829: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12830: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12831: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12832: FND_MSG_PUB.Add;
12833: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12827:
12828: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12829: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12830: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12831: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12832: FND_MSG_PUB.Add;
12833: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12834: ,p_count => x_msg_count

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

12827:
12828: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12829: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12830: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12831: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12832: FND_MSG_PUB.Add;
12833: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12834: ,p_count => x_msg_count
12835: ,p_data => x_msg_data);

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

12918: ROLLBACK TO Update_Action_Group_PUB;
12919: END IF;
12920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12921:
12922: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12923: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12924: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12925: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12926: FND_MSG_PUB.Add;

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

12919: END IF;
12920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12921:
12922: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12923: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12924: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12925: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12926: FND_MSG_PUB.Add;
12927: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12921:
12922: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12923: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12924: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12925: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12926: FND_MSG_PUB.Add;
12927: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12928: ,p_count => x_msg_count

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

12921:
12922: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
12923: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12924: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12925: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12926: FND_MSG_PUB.Add;
12927: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12928: ,p_count => x_msg_count
12929: ,p_data => x_msg_data);

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

12996: ROLLBACK TO Delete_Action_Group_PUB;
12997: END IF;
12998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12999:
13000: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13001: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13002: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13003: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13004: FND_MSG_PUB.Add;

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

12997: END IF;
12998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12999:
13000: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13001: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13002: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13003: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13004: FND_MSG_PUB.Add;
13005: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

12998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12999:
13000: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13001: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13002: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13003: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13004: FND_MSG_PUB.Add;
13005: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13006: ,p_count => x_msg_count

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

12999:
13000: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13001: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13002: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13003: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13004: FND_MSG_PUB.Add;
13005: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13006: ,p_count => x_msg_count
13007: ,p_data => x_msg_data);

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

13102: ROLLBACK TO Create_Action_Group_Entry_PUB;
13103: END IF;
13104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13105:
13106: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13107: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13108: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13109: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13110: FND_MSG_PUB.Add;

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

13103: END IF;
13104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13105:
13106: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13107: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13108: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13109: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13110: FND_MSG_PUB.Add;
13111: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

13104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13105:
13106: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13107: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13108: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13109: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13110: FND_MSG_PUB.Add;
13111: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13112: ,p_count => x_msg_count

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

13105:
13106: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13107: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13108: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13109: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13110: FND_MSG_PUB.Add;
13111: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13112: ,p_count => x_msg_count
13113: ,p_data => x_msg_data);

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

13176: ROLLBACK TO Update_Action_Group_Entry_PUB;
13177: END IF;
13178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13179:
13180: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13181: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13182: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13183: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13184: FND_MSG_PUB.Add;

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

13177: END IF;
13178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13179:
13180: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13181: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13182: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13183: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13184: FND_MSG_PUB.Add;
13185: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

13178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13179:
13180: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13181: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13182: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13183: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13184: FND_MSG_PUB.Add;
13185: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13186: ,p_count => x_msg_count

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

13179:
13180: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13181: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13182: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13183: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13184: FND_MSG_PUB.Add;
13185: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13186: ,p_count => x_msg_count
13187: ,p_data => x_msg_data);

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

13246: ROLLBACK TO Delete_Action_Group_Entry_PUB;
13247: END IF;
13248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13249:
13250: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13251: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13252: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13253: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13254: FND_MSG_PUB.Add;

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

13247: END IF;
13248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13249:
13250: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13251: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13252: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13253: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13254: FND_MSG_PUB.Add;
13255: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

13248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13249:
13250: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13251: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13252: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13253: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13254: FND_MSG_PUB.Add;
13255: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13256: ,p_count => x_msg_count

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

13249:
13250: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
13251: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13252: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13253: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13254: FND_MSG_PUB.Add;
13255: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13256: ,p_count => x_msg_count
13257: ,p_data => x_msg_data);

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

13806: ,cp_attr_group_name => p_attr_group_name
13807: );
13808: FETCH c_check_agv_name INTO l_temp_agv_name;
13809: IF c_check_agv_name%FOUND THEN
13810: FND_MESSAGE.set_name('EGO','EGO_EF_NAME_EXTS');
13811: FND_MSG_PUB.add;
13812: RAISE FND_API.g_exc_error;
13813: END IF;
13814: CLOSE c_check_agv_name;

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

13818: OPEN c_check_obj_name (cp_agv_name => l_agv_name,
13819: cp_appl_id => p_application_id);
13820: FETCH c_check_obj_name INTO l_temp_agv_name;
13821: IF c_check_obj_name%FOUND THEN
13822: FND_MESSAGE.set_name('EGO','EGO_EF_NAME_EXTS');
13823: FND_MSG_PUB.add;
13824: RAISE FND_API.g_exc_error;
13825: END IF;
13826: CLOSE c_check_obj_name;

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

13991:
13992: EXCEPTION
13993: WHEN e_control_level_invalid THEN
13994: x_return_status := FND_API.G_RET_STS_ERROR;
13995: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CL_INVALID');
13996: FND_MSG_PUB.Add;
13997: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13998: ,p_count => x_msg_count
13999: ,p_data => x_msg_data);

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

14000:
14001:
14002: WHEN e_no_attr_for_id_error THEN
14003: x_return_status := FND_API.G_RET_STS_ERROR;
14004: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_NO_ATTR_FOUND');
14005: FND_MSG_PUB.Add;
14006: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14007: ,p_count => x_msg_count
14008: ,p_data => x_msg_data);

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

14011:
14012: WHEN OTHERS THEN
14013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14014:
14015: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14016: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14017: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14018: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
14019: FND_MSG_PUB.Add;

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

14012: WHEN OTHERS THEN
14013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14014:
14015: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14016: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14017: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14018: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
14019: FND_MSG_PUB.Add;
14020: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

14013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14014:
14015: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14016: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14017: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14018: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
14019: FND_MSG_PUB.Add;
14020: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14021: ,p_count => x_msg_count

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

14014:
14015: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
14016: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
14017: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
14018: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
14019: FND_MSG_PUB.Add;
14020: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14021: ,p_count => x_msg_count
14022: ,p_data => x_msg_data);