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_MSG_PUB

Line 242: FND_MSG_PUB.Initialize;

238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: END IF;
240: -- Initialize message list even though we don't currently use it
241: IF FND_API.To_Boolean(p_init_msg_list) THEN
242: FND_MSG_PUB.Initialize;
243: END IF;
244:
245: DELETE FROM EGO_ACTIONS_DL
246: WHERE ACTION_ID = p_action_id;

Line 266: FND_MSG_PUB.Add;

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

Line 267: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 874: FND_MSG_PUB.Add;

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

Line 979: FND_MSG_PUB.Add;

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

Line 980: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

976: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
977: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
978: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
979: FND_MSG_PUB.Add;
980: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
981: ,p_count => x_msg_count
982: ,p_data => x_msg_data);
983:
984: END Delete_Attribute_Internal;

Line 1062: FND_MSG_PUB.Add;

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

Line 1063: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

1059: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1060: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1061: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1062: FND_MSG_PUB.Add;
1063: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1064: ,p_count => x_msg_count
1065: ,p_data => x_msg_data);
1066:
1067: END Delete_Attr_Group_Internal;

Line 1534: FND_MSG_PUB.Add;

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

Line 2329: FND_MSG_PUB.Initialize;

2325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2326: END IF;
2327: -- Initialize message list even though we don't currently use it
2328: IF FND_API.To_Boolean(p_init_msg_list) THEN
2329: FND_MSG_PUB.Initialize;
2330: END IF;
2331: -----------------------------------
2332: --check if the Attribute Group name begins with a number.
2333: --Bug 5443697

Line 2589: FND_MSG_PUB.Add;

2585: ROLLBACK TO Create_Attribute_Group_PUB;
2586: END IF;
2587: x_return_status := FND_API.G_RET_STS_ERROR;
2588: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_GRP_EXIST');
2589: FND_MSG_PUB.Add;
2590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2591: ,p_count => x_msg_count
2592: ,p_data => x_msg_data);
2593: END IF; --l_ego_exists <> Y --Bug 4703510

Line 2590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2586: END IF;
2587: x_return_status := FND_API.G_RET_STS_ERROR;
2588: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_GRP_EXIST');
2589: FND_MSG_PUB.Add;
2590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2591: ,p_count => x_msg_count
2592: ,p_data => x_msg_data);
2593: END IF; --l_ego_exists <> Y --Bug 4703510
2594:

Line 2603: FND_MSG_PUB.Add;

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

Line 2604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2600: END IF;
2601: x_return_status := FND_API.G_RET_STS_ERROR;
2602: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_NUM');
2603: FND_MSG_PUB.Add;
2604: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2605: ,p_count => x_msg_count
2606: ,p_data => x_msg_data);
2607:
2608: --Bug 5443697

Line 2615: FND_MSG_PUB.Add;

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

Line 2616: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2612: END IF;
2613: x_return_status := FND_API.G_RET_STS_ERROR;
2614: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_UND_SC');
2615: FND_MSG_PUB.Add;
2616: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2617: ,p_count => x_msg_count
2618: ,p_data => x_msg_data);
2619:
2620: WHEN OTHERS THEN

Line 2640: FND_MSG_PUB.Add;

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

Line 2641: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2637: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.
2638: -- Bug 6120553
2639: FND_MESSAGE.Set_Token('SQL_ERR_MSG', NVL(l_sql_errm, SQLERRM)||' '||FND_FLEX_DSC_API.Message());
2640: FND_MSG_PUB.Add;
2641: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2642: ,p_count => x_msg_count
2643: ,p_data => x_msg_data);
2644: END IF;
2645:

Line 2794: FND_MSG_PUB.Initialize;

2790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2791: END IF;
2792: -- Initialize message list even though we don't currently use it
2793: IF FND_API.To_Boolean(p_init_msg_list) THEN
2794: FND_MSG_PUB.Initialize;
2795: END IF;
2796:
2797: l_sequence_numbers := ' ';
2798:

Line 2873: FND_MSG_PUB.Add;

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

Line 2874: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

2870: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2871: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2872: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2873: FND_MSG_PUB.Add;
2874: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2875: ,p_count => x_msg_count
2876: ,p_data => x_msg_data);
2877:
2878: END Copy_Attribute_Group;

Line 3057: FND_MSG_PUB.Add;

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

Line 3058: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

3054: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3055: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3056: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3057: FND_MSG_PUB.Add;
3058: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3059: ,p_count => x_msg_count
3060: ,p_data => x_msg_data);
3061: END IF;
3062:

Line 3122: FND_MSG_PUB.Initialize;

3118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3119: END IF;
3120: -- Initialize message list even though we don't currently use it
3121: IF FND_API.To_Boolean(p_init_msg_list) THEN
3122: FND_MSG_PUB.Initialize;
3123: END IF;
3124: --Initialize num cols and rows.
3125: --Bug 6048237
3126: IF p_multi_row_attrib_group = 'Y' THEN

Line 3208: FND_MSG_PUB.Add;

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

Line 3209: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

3205: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3206: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3207: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3208: FND_MSG_PUB.Add;
3209: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3210: ,p_count => x_msg_count
3211: ,p_data => x_msg_data);
3212:
3213: END Update_Attribute_Group;

Line 3277: FND_MSG_PUB.Add;

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

Line 3278: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

3274: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3275: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3276: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3277: FND_MSG_PUB.Add;
3278: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3279: ,p_count => x_msg_count
3280: ,p_data => x_msg_data);
3281: END IF;
3282:

Line 3324: FND_MSG_PUB.Initialize;

3320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3321: END IF;
3322: -- Initialize message list even though we don't currently use it
3323: IF FND_API.To_Boolean(p_init_msg_list) THEN
3324: FND_MSG_PUB.Initialize;
3325: END IF;
3326:
3327: l_assocs_exist := Check_Associations_Exist(p_application_id,
3328: p_attr_group_type,

Line 3346: FND_MSG_PUB.Add;

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

Line 3347: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

3343:
3344: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ASSOCS_EXIST1');
3345: FND_MESSAGE.Set_Token('ATTR_GRP_NAME', l_attr_group_disp_name);
3346: FND_MSG_PUB.Add;
3347: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3348: ,p_count => x_msg_count
3349: ,p_data => x_msg_data);
3350:
3351: ELSE

Line 3382: FND_MSG_PUB.Add;

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

Line 3383: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

3379: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3380: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3381: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3382: FND_MSG_PUB.Add;
3383: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3384: ,p_count => x_msg_count
3385: ,p_data => x_msg_data);
3386:
3387: END Delete_Attribute_Group;

Line 3917: FND_MSG_PUB.Initialize;

3913: BEGIN
3914:
3915: -- Initialize message list if caller asked us to do so
3916: IF FND_API.To_Boolean(p_init_msg_list) THEN
3917: FND_MSG_PUB.Initialize;
3918: ERROR_HANDLER.Initialize;
3919: END IF;
3920:
3921: IF (p_attr_group_id_list IS NOT NULL) THEN

Line 4246: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4242: /***
4243: Dylan wonders: did I write this? If so, why? If not, who did...and why?
4244: Maybe it was for PA integration...?
4245: ***/
4246: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4247: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4248: END IF;
4249:
4250: END Validate_Unique_Key_Attrs;

Line 4247: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

4243: Dylan wonders: did I write this? If so, why? If not, who did...and why?
4244: Maybe it was for PA integration...?
4245: ***/
4246: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4247: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4248: END IF;
4249:
4250: END Validate_Unique_Key_Attrs;
4251:

Line 4306: FND_MSG_PUB.Initialize;

4302: code_debug(l_api_name ||' Start ');
4303:
4304: -- Initialize message list even though we don't currently use it
4305: IF FND_API.To_Boolean(p_init_msg_list) THEN
4306: FND_MSG_PUB.Initialize;
4307: END IF;
4308:
4309: -- Check for call compatibility
4310: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 4323: l_msg_data := fnd_msg_pub.get();

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

Line 4326: l_msg_data := fnd_msg_pub.get();

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

Line 4329: l_msg_data := fnd_msg_pub.get();

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

Line 4332: l_msg_data := fnd_msg_pub.get();

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

Line 4339: FND_MSG_PUB.Add;

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

Line 4373: FND_MSG_PUB.Add;

4369: END IF;
4370:
4371: IF l_data_level_id = ((p_application_id+1) * 100) THEN
4372: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL_LIMIT');
4373: FND_MSG_PUB.Add;
4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;
4376:
4377: code_debug(l_api_name ||' Data level id being used in insert: '||l_data_level_id);

Line 4467: FND_MSG_PUB.Add;

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

Line 4516: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

4512: code_debug(l_api_name ||' Exception - FND_API.G_EXC_ERROR '||x_msg_data);
4513: IF FND_API.TO_BOOLEAN(p_commit) THEN
4514: ROLLBACK to SYNC_DATA_LEVEL;
4515: END IF;
4516: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4517: ,p_count => x_msg_count
4518: ,p_data => x_msg_data);
4519: x_return_status := FND_API.G_RET_STS_ERROR;
4520:

Line 4587: FND_MSG_PUB.Initialize;

4583:
4584:
4585: -- Initialize message list even though we don't currently use it
4586: IF FND_API.To_Boolean(p_init_msg_list) THEN
4587: FND_MSG_PUB.Initialize;
4588: END IF;
4589:
4590:
4591: -- Check for call compatibility

Line 4607: l_msg_data := fnd_msg_pub.get();

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

Line 4613: l_msg_data := fnd_msg_pub.get();

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

Line 4617: l_msg_data := fnd_msg_pub.get();

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

Line 4624: FND_MSG_PUB.Add;

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

Line 4657: FND_MSG_PUB.Add;

4653: ELSE
4654: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4655: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);
4656: END IF;
4657: FND_MSG_PUB.Add;
4658: RAISE FND_API.G_EXC_ERROR;
4659: END;
4660:
4661: -- data level check

Line 4691: FND_MSG_PUB.Add;

4687: ELSE
4688: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4689: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);
4690: END IF;
4691: FND_MSG_PUB.Add;
4692: RAISE FND_API.G_EXC_ERROR;
4693: END;
4694: code_debug(l_api_name ||' Data Level id '||l_data_level_rec.data_level_id);
4695:

Line 4720: FND_MSG_PUB.Add;

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

Line 4734: FND_MSG_PUB.Add;

4730: ELSE
4731: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4732: FND_MESSAGE.Set_Token('VALUE',p_defaulting);
4733: END IF;
4734: FND_MSG_PUB.Add;
4735: RAISE FND_API.G_EXC_ERROR;
4736: END;
4737: code_debug(l_api_name ||' Defaulting '||l_defaulting);
4738:

Line 4764: FND_MSG_PUB.Add;

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

Line 4781: FND_MSG_PUB.Add;

4777: ELSE
4778: FND_MESSAGE.set_token('NAME','View Privilege');
4779: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);
4780: END IF;
4781: FND_MSG_PUB.Add;
4782: RAISE FND_API.G_EXC_ERROR;
4783: END;
4784: code_debug(l_api_name ||' View Priv id '||l_view_priv_id);
4785:

Line 4811: FND_MSG_PUB.Add;

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

Line 4828: FND_MSG_PUB.Add;

4824: ELSE
4825: FND_MESSAGE.set_token('NAME','Edit Privilege');
4826: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);
4827: END IF;
4828: FND_MSG_PUB.Add;
4829: RAISE FND_API.G_EXC_ERROR;
4830: END;
4831: code_debug(l_api_name ||' Edit Priv id '||l_edit_priv_id);
4832:

Line 4836: FND_MSG_PUB.Add;

4832:
4833: IF NVL(p_raise_pre_event,'N') IN ('Y', 'N') THEN
4834: IF l_data_level_rec.enable_pre_event = 'N' AND NVL(p_raise_pre_event,'N') = 'Y' THEN
4835: fnd_message.set_name(G_APP_NAME,'EGO_PRE_EVENT_NOT_ALLOWED');
4836: FND_MSG_PUB.Add;
4837: RAISE FND_API.G_EXC_ERROR;
4838: ELSE
4839: l_raise_pre_event := NVL(p_raise_pre_event,'N');
4840: END IF;

Line 4845: FND_MSG_PUB.Add;

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

Line 4853: FND_MSG_PUB.Add;

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

Line 4862: FND_MSG_PUB.Add;

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

Line 4922: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

4918: code_debug(l_api_name ||' Exception - FND_API.G_EXC_ERROR '||x_msg_data);
4919: IF FND_API.TO_BOOLEAN(p_commit) THEN
4920: ROLLBACK to SYNC_DL_ASSOC;
4921: END IF;
4922: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4923: ,p_count => x_msg_count
4924: ,p_data => x_msg_data);
4925: x_return_status := FND_API.G_RET_STS_ERROR;
4926:

Line 5115: FND_MSG_PUB.Initialize;

5111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5112: END IF;
5113: -- Initialize message list even though we don't currently use it
5114: IF FND_API.To_Boolean(p_init_msg_list) THEN
5115: FND_MSG_PUB.Initialize;
5116: END IF;
5117: --Bug 4703510
5118: --check if the Attribute name starts with a number
5119: --Bug 5443697

Line 5646: FND_MSG_PUB.Add;

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

Line 5647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5643:
5644: x_return_status := FND_API.G_RET_STS_ERROR;
5645: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_UNIQUE');
5646: FND_MSG_PUB.Add;
5647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5648: ,p_count => x_msg_count
5649: ,p_data => x_msg_data);
5650:
5651: END IF;--l_ego_exists <> 'Y'--Bug 4703510

Line 5661: FND_MSG_PUB.Add;

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

Line 5662: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5658:
5659: x_return_status := FND_API.G_RET_STS_ERROR;
5660: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_NUM');
5661: FND_MSG_PUB.Add;
5662: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5663: ,p_count => x_msg_count
5664: ,p_data => x_msg_data);
5665:
5666: WHEN e_attr_starts_with_und_sc THEN

Line 5673: FND_MSG_PUB.Add;

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

Line 5674: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5670:
5671: x_return_status := FND_API.G_RET_STS_ERROR;
5672: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_UND_SC');
5673: FND_MSG_PUB.Add;
5674: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5675: ,p_count => x_msg_count
5676: ,p_data => x_msg_data);
5677:
5678: WHEN e_col_internal_name_error THEN

Line 5685: FND_MSG_PUB.Add;

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

Line 5686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5682:
5683: x_return_status := FND_API.G_RET_STS_ERROR;
5684: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_INTRNL_NAME_ERR');
5685: FND_MSG_PUB.Add;
5686: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5687: ,p_count => x_msg_count
5688: ,p_data => x_msg_data);
5689:
5690: WHEN e_default_value_len_err THEN

Line 5698: FND_MSG_PUB.Add;

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

Line 5699: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5695: x_return_status := FND_API.G_RET_STS_ERROR;
5696: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
5697: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
5698: FND_MSG_PUB.Add;
5699: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5700: ,p_count => x_msg_count
5701: ,p_data => x_msg_data);
5702:
5703: WHEN e_attr_dup_seq_error THEN

Line 5710: FND_MSG_PUB.Add;

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

Line 5711: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5707:
5708: x_return_status := FND_API.G_RET_STS_ERROR;
5709: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_DUP_SEQ_ERR');
5710: FND_MSG_PUB.Add;
5711: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5712: ,p_count => x_msg_count
5713: ,p_data => x_msg_data);
5714:
5715:

Line 5723: FND_MSG_PUB.Add;

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

Line 5724: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5720:
5721: x_return_status := FND_API.G_RET_STS_ERROR;
5722: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');
5723: FND_MSG_PUB.Add;
5724: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5725: ,p_count => x_msg_count
5726: ,p_data => x_msg_data);
5727:
5728:

Line 5737: FND_MSG_PUB.Add;

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

Line 5738: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5734:
5735: x_return_status := FND_API.G_RET_STS_ERROR;
5736: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_COL_DT_ERR');
5737: FND_MSG_PUB.Add;
5738: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5739: ,p_count => x_msg_count
5740: ,p_data => x_msg_data);
5741:
5742: WHEN e_uom_not_allowed THEN

Line 5749: FND_MSG_PUB.Add;

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

Line 5750: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5746:
5747: x_return_status := FND_API.G_RET_STS_ERROR;
5748: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');
5749: FND_MSG_PUB.Add;
5750: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5751: ,p_count => x_msg_count
5752: ,p_data => x_msg_data);
5753:
5754: WHEN e_vs_data_type_error THEN

Line 5760: FND_MSG_PUB.Add;

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

Line 5761: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5757: END IF;
5758: x_return_status := FND_API.G_RET_STS_ERROR;
5759: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');
5760: FND_MSG_PUB.Add;
5761: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5762: ,p_count => x_msg_count
5763: ,p_data => x_msg_data);
5764:
5765: WHEN e_no_vs_for_id_error THEN

Line 5772: FND_MSG_PUB.Add;

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

Line 5773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5769:
5770: x_return_status := FND_API.G_RET_STS_ERROR;
5771: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_NO_VS_ERR');
5772: FND_MSG_PUB.Add;
5773: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5774: ,p_count => x_msg_count
5775: ,p_data => x_msg_data);
5776:
5777: WHEN e_bad_info_1_error THEN

Line 5796: FND_MSG_PUB.Add;

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

Line 5797: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5793: x_return_status := FND_API.G_RET_STS_ERROR;
5794: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5795: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', l_attr_group_disp_name);
5796: FND_MSG_PUB.Add;
5797: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5798: ,p_count => x_msg_count
5799: ,p_data => x_msg_data);
5800: EXCEPTION
5801: WHEN NO_DATA_FOUND THEN

Line 5805: FND_MSG_PUB.Add;

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

Line 5806: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5802: x_return_status := FND_API.G_RET_STS_ERROR;
5803: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5804: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', null);
5805: FND_MSG_PUB.Add;
5806: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5807: ,p_count => x_msg_count
5808: ,p_data => x_msg_data);
5809: END;
5810:

Line 5820: FND_MSG_PUB.Add;

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

Line 5821: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

5817: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5818: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5819: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5820: FND_MSG_PUB.Add;
5821: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5822: ,p_count => x_msg_count
5823: ,p_data => x_msg_data);
5824:
5825: END Create_Attribute;

Line 5983: FND_MSG_PUB.Initialize;

5979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5980: END IF;
5981: -- Initialize message list even though we don't currently use it
5982: IF FND_API.To_Boolean(p_init_msg_list) THEN
5983: FND_MSG_PUB.Initialize;
5984: END IF;
5985:
5986: -----------------------------------
5987: -- get the attribute details -- ego specific

Line 6318: FND_MSG_PUB.Add;

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

Line 6319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

6315: x_return_status := FND_API.G_RET_STS_ERROR;
6316: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
6317: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
6318: FND_MSG_PUB.Add;
6319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6320: ,p_count => x_msg_count
6321: ,p_data => x_msg_data);
6322:
6323: WHEN e_attr_dup_seq_error THEN

Line 6329: FND_MSG_PUB.Add;

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

Line 6330: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

6326: END IF;
6327: x_return_status := FND_API.G_RET_STS_ERROR;
6328: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ATTR_DUP_SEQ_ERR');
6329: FND_MSG_PUB.Add;
6330: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6331: ,p_count => x_msg_count
6332: ,p_data => x_msg_data);
6333: WHEN e_uom_not_allowed THEN
6334: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 6339: FND_MSG_PUB.Add;

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

Line 6340: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

6336: END IF;
6337: x_return_status := FND_API.G_RET_STS_ERROR;
6338: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');
6339: FND_MSG_PUB.Add;
6340: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6341: ,p_count => x_msg_count
6342: ,p_data => x_msg_data);
6343:
6344:

Line 6351: FND_MSG_PUB.Add;

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

Line 6352: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

6348: END IF;
6349: x_return_status := FND_API.G_RET_STS_ERROR;
6350: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');
6351: FND_MSG_PUB.Add;
6352: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6353: ,p_count => x_msg_count
6354: ,p_data => x_msg_data);
6355:
6356: WHEN OTHERS THEN

Line 6366: FND_MSG_PUB.Add;

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

Line 6367: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

6363: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6364: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6365: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6366: FND_MSG_PUB.Add;
6367: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6368: ,p_count => x_msg_count
6369: ,p_data => x_msg_data);
6370:
6371: END Update_Attribute;

Line 6409: FND_MSG_PUB.Initialize;

6405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6406: END IF;
6407: -- Initialize message list even though we don't currently use it
6408: IF FND_API.To_Boolean(p_init_msg_list) THEN
6409: FND_MSG_PUB.Initialize;
6410: END IF;
6411:
6412: l_assocs_exist := Check_Associations_Exist(p_application_id,
6413: p_attr_group_type,

Line 6972: FND_MSG_PUB.Initialize;

6968: END IF;
6969:
6970: -- Initialize message list even though we don't currently use it
6971: IF FND_API.To_Boolean(p_init_msg_list) THEN
6972: FND_MSG_PUB.Initialize;
6973: END IF;
6974:
6975: -- Check for call compatibility
6976: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 7171: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

7167: IF FND_API.To_Boolean( p_commit ) THEN
7168: ROLLBACK TO Create_Value_Set_PUB;
7169: END IF;
7170: x_return_status := FND_API.G_RET_STS_ERROR;
7171: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7172: ,p_count => x_msg_count
7173: ,p_data => x_msg_data);
7174: WHEN OTHERS THEN
7175: code_debug(l_api_name ||' EXCEPTION - OTHERS '||SQLERRM);

Line 7186: FND_MSG_PUB.Add;

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

Line 7187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

7183: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7184: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7185: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
7186: FND_MSG_PUB.Add;
7187: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7188: ,p_count => x_msg_count
7189: ,p_data => x_msg_data);
7190: ELSE
7191: x_return_status := FND_API.G_RET_STS_ERROR;

Line 7474: FND_MSG_PUB.Add;

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

Line 7475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 7588: FND_MSG_PUB.Initialize;

7584: END IF;
7585:
7586: -- Initialize message list even though we don't currently use it
7587: IF FND_API.To_Boolean(p_init_msg_list) THEN
7588: FND_MSG_PUB.Initialize;
7589: END IF;
7590:
7591: -- Check for call compatibility
7592: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 7718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

7714: IF FND_API.To_Boolean( p_commit ) THEN
7715: ROLLBACK TO Update_Value_Set_PUB;
7716: END IF;
7717: x_return_status := FND_API.G_RET_STS_ERROR;
7718: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7719: ,p_count => x_msg_count
7720: ,p_data => x_msg_data);
7721:
7722: WHEN OTHERS THEN

Line 7732: FND_MSG_PUB.Add;

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

Line 7733: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

7729: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7730: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7731: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7732: FND_MSG_PUB.Add;
7733: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7734: ,p_count => x_msg_count
7735: ,p_data => x_msg_data);
7736:
7737: END Update_Value_Set;

Line 7950: FND_MSG_PUB.Add;

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

Line 7951: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 8006: FND_MSG_PUB.Initialize;

8002: END IF;
8003:
8004: -- Initialize message list even though we don't currently use it
8005: IF FND_API.To_Boolean(p_init_msg_list) THEN
8006: FND_MSG_PUB.Initialize;
8007: END IF;
8008:
8009: -- Check for call compatibility
8010: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 8115: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

8111: IF FND_API.To_Boolean(p_commit) THEN
8112: ROLLBACK TO Insert_Value_Set_Table_Inf_PUB;
8113: END IF;
8114: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
8115: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8116: ,p_count => x_msg_count
8117: ,p_data => x_msg_data);
8118: WHEN OTHERS THEN
8119: code_debug(l_api_name ||' EXCEPTION OTHERS '|| SQLERRM);

Line 8129: FND_MSG_PUB.Add;

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

Line 8130: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

8126: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8127: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8128: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8129: FND_MSG_PUB.Add;
8130: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8131: ,p_count => x_msg_count
8132: ,p_data => x_msg_data);
8133:
8134: END Insert_Value_Set_table_Inf;

Line 8185: FND_MSG_PUB.Initialize;

8181: END IF;
8182:
8183: -- Initialize message list even though we don't currently use it
8184: IF FND_API.To_Boolean(p_init_msg_list) THEN
8185: FND_MSG_PUB.Initialize;
8186: END IF;
8187:
8188: -- Check for call compatibility
8189: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 8258: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

8254: IF FND_API.To_Boolean(p_commit) THEN
8255: ROLLBACK TO Update_Value_Set_Table_Inf_PUB;
8256: END IF;
8257: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
8258: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8259: ,p_count => x_msg_count
8260: ,p_data => x_msg_data);
8261: WHEN OTHERS THEN
8262: code_debug(l_api_name ||' EXCEPTION OTHERS '|| SQLERRM);

Line 8272: FND_MSG_PUB.Add;

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

Line 8273: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

8269: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8270: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8271: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8272: FND_MSG_PUB.Add;
8273: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8274: ,p_count => x_msg_count
8275: ,p_data => x_msg_data);
8276:
8277: END Update_Value_Set_table_Inf;

Line 8446: FND_MSG_PUB.Initialize;

8442: END IF;
8443:
8444: -- Initialize message list even though we don't currently use it
8445: IF FND_API.To_Boolean(p_init_msg_list) THEN
8446: FND_MSG_PUB.Initialize;
8447: END IF;
8448:
8449: -- Check for call compatibility
8450: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 8574: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

8570: IF FND_API.To_Boolean(p_commit) THEN
8571: ROLLBACK TO Create_Value_Set_Val_PUB;
8572: END IF;
8573: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
8574: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8575: ,p_count => x_msg_count
8576: ,p_data => x_msg_data);
8577: WHEN OTHERS THEN
8578: code_debug( l_api_name || ' EXCEPTION - OTHERS ');

Line 8589: FND_MSG_PUB.Add;

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

Line 8590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

8586: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8587: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8588: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8589: FND_MSG_PUB.Add;
8590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8591: ,p_count => x_msg_count
8592: ,p_data => x_msg_data);
8593:
8594: END Create_Value_Set_Val;

Line 8641: FND_MSG_PUB.Initialize;

8637: END IF;
8638:
8639: -- Initialize message list even though we don't currently use it
8640: IF FND_API.To_Boolean(p_init_msg_list) THEN
8641: FND_MSG_PUB.Initialize;
8642: END IF;
8643:
8644: -- Check for call compatibility
8645: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

Line 8737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

8733: IF FND_API.To_Boolean(p_commit) THEN
8734: ROLLBACK TO Update_Value_Set_Val_PUB;
8735: END IF;
8736: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
8737: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8738: ,p_count => x_msg_count
8739: ,p_data => x_msg_data);
8740: WHEN OTHERS THEN
8741: code_debug( l_api_name || ' EXCEPTION - OTHERS ');

Line 8752: FND_MSG_PUB.Add;

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

Line 8753: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

8749: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8750: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8751: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8752: FND_MSG_PUB.Add;
8753: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8754: ,p_count => x_msg_count
8755: ,p_data => x_msg_data);
8756:
8757: END Update_Value_Set_Val;

Line 9101: FND_MSG_PUB.Initialize;

9097: --
9098: -- Initialize message list
9099: --
9100: IF FND_API.To_Boolean(p_init_msg_list) THEN
9101: FND_MSG_PUB.Initialize;
9102: END IF;
9103:
9104: code_debug(l_api_name||' msg pub initialized ' );
9105: --

Line 9161: FND_MSG_PUB.Add;

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

Line 9232: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

9228: IF FND_API.To_Boolean( p_commit ) THEN
9229: ROLLBACK TO PROCESS_VS_VALUE_SEQUENCE_SP;
9230: END IF;
9231: x_return_status := FND_API.G_RET_STS_ERROR;
9232: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9233: ,p_count => x_msg_count
9234: ,p_data => x_msg_data);
9235: WHEN OTHERS THEN
9236: IF FND_API.To_Boolean( p_commit ) THEN

Line 9324: FND_MSG_PUB.Initialize;

9320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9321: END IF;
9322: -- Initialize message list even though we don't currently use it
9323: IF FND_API.To_Boolean(p_init_msg_list) THEN
9324: FND_MSG_PUB.Initialize;
9325: END IF;
9326:
9327: --Checking if the variant attribute group trying to be associated has attributes in it, if not raise exception
9328: SELECT Nvl(VARIANT, 'N')

Line 9344: FND_MSG_PUB.Add;

9340: IF(l_attr_count = 0 AND l_variant_flag = 'Y') THEN
9341: Fnd_Message.Set_Name (application => 'EGO',
9342: name => 'EGO_EF_NO_ATTR_EXIST'
9343: );
9344: FND_MSG_PUB.Add;
9345: RAISE e_variant_assocs_excep;
9346: END IF;
9347:
9348: -- SSARNOBA: Why do we have this SELECT INTO statement? We're not using

Line 9390: FND_MSG_PUB.Add;

9386: IF(l_style_exists = 'T' AND l_variant_flag = 'Y') THEN
9387: Fnd_Message.Set_Name (application => 'EGO',
9388: name => 'EGO_VARIANT_STYLE_EXIST'
9389: );
9390: FND_MSG_PUB.Add;
9391: RAISE e_variant_assocs_excep;
9392: END IF;
9393:
9394: --l_existing_datalevel := Get_Associated_Datalevel(p_object_id, p_attr_group_id);

Line 9539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

9535: IF FND_API.To_Boolean(p_commit) THEN
9536: ROLLBACK TO Create_Association_PUB;
9537: END IF;
9538: x_return_status := FND_API.G_RET_STS_ERROR;
9539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9540: ,p_count => x_msg_count
9541: ,p_data => x_msg_data);
9542:
9543:

Line 9557: FND_MSG_PUB.Add;

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

Line 9558: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

9554: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9555: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9556: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9557: FND_MSG_PUB.Add;
9558: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9559: ,p_count => x_msg_count
9560: ,p_data => x_msg_data);
9561:
9562: END Create_Association;

Line 9644: FND_MSG_PUB.Add;

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

Line 9645: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

9641: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9642: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9643: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9644: FND_MSG_PUB.Add;
9645: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9646: ,p_count => x_msg_count
9647: ,p_data => x_msg_data);
9648: END IF;
9649:

Line 9729: FND_MSG_PUB.Add;

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

Line 9730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

9726: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9727: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9728: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9729: FND_MSG_PUB.Add;
9730: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9731: ,p_count => x_msg_count
9732: ,p_data => x_msg_data);
9733: END IF;
9734:

Line 9778: FND_MSG_PUB.Initialize;

9774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9775: END IF;
9776: -- Initialize message list even though we don't currently use it
9777: IF FND_API.To_Boolean(p_init_msg_list) THEN
9778: FND_MSG_PUB.Initialize;
9779: END IF;
9780:
9781: --bug 5513610
9782: /*DELETE FROM EGO_PAGE_ENTRIES_B

Line 9812: FND_MSG_PUB.Add;

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

Line 9813: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

9809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9810: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9812: FND_MSG_PUB.Add;
9813: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9814: ,p_count => x_msg_count
9815: ,p_data => x_msg_data);
9816:
9817: END Update_Association;

Line 9889: FND_MSG_PUB.Add;

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

Line 9890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

9886: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9887: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9888: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9889: FND_MSG_PUB.Add;
9890: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9891: ,p_count => x_msg_count
9892: ,p_data => x_msg_data);
9893: END IF;
9894:

Line 9980: FND_MSG_PUB.Add;

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

Line 9981: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

9977: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9978: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9979: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9980: FND_MSG_PUB.Add;
9981: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9982: ,p_count => x_msg_count
9983: ,p_data => x_msg_data);
9984: END IF;
9985:

Line 10052: FND_MSG_PUB.Initialize;

10048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10049: END IF;
10050: -- Initialize message list even though we don't currently use it
10051: IF FND_API.To_Boolean(p_init_msg_list) THEN
10052: FND_MSG_PUB.Initialize;
10053: END IF;
10054:
10055: --if p_force is true, skip all deletion checks
10056: IF( p_force = fnd_api.g_TRUE ) THEN

Line 10148: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

10144: EXCEPTION
10145: WHEN OTHERS THEN
10146: code_debug(l_api_name||' EXCEPTION from check '||x_msg_data);
10147:
10148: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10149: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10150: END IF;
10151: l_is_ok_to_delete := FALSE;
10152: END;

Line 10149: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

10145: WHEN OTHERS THEN
10146: code_debug(l_api_name||' EXCEPTION from check '||x_msg_data);
10147:
10148: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10149: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
10150: END IF;
10151: l_is_ok_to_delete := FALSE;
10152: END;
10153: ELSE

Line 10204: FND_MSG_PUB.Add;

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

Line 10205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

10201: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10202: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10203: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10204: FND_MSG_PUB.Add;
10205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10206: ,p_count => x_msg_count
10207: ,p_data => x_msg_data);
10208:
10209: END Delete_Association;

Line 10263: FND_MSG_PUB.Initialize;

10259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10260: END IF;
10261: -- Initialize message list even though we don't currently use it
10262: IF FND_API.To_Boolean(p_init_msg_list) THEN
10263: FND_MSG_PUB.Initialize;
10264: END IF;
10265:
10266: --if page id is not provided, get page id from sequence
10267: IF( p_page_id IS NULL ) THEN

Line 10347: FND_MSG_PUB.Add;

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

Line 10348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

10344: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10345: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10346: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10347: FND_MSG_PUB.Add;
10348: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10349: ,p_count => x_msg_count
10350: ,p_data => x_msg_data);
10351:
10352: END Create_Page;

Line 10396: FND_MSG_PUB.Initialize;

10392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10393: END IF;
10394: -- Initialize message list even though we don't currently use it
10395: IF FND_API.To_Boolean(p_init_msg_list) THEN
10396: FND_MSG_PUB.Initialize;
10397: END IF;
10398:
10399: IF (FND_API.To_Boolean(p_is_nls_mode)) THEN
10400:

Line 10449: FND_MSG_PUB.Add;

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

Line 10450: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 10537: FND_MSG_PUB.Add;

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

Line 10538: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

10534: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10535: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10536: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10537: FND_MSG_PUB.Add;
10538: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10539: ,p_count => x_msg_count
10540: ,p_data => x_msg_data);
10541:
10542: END IF;

Line 10581: FND_MSG_PUB.Initialize;

10577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10578: END IF;
10579: -- Initialize message list even though we don't currently use it
10580: IF FND_API.To_Boolean(p_init_msg_list) THEN
10581: FND_MSG_PUB.Initialize;
10582: END IF;
10583:
10584: DELETE FROM EGO_PAGE_ENTRIES_B
10585: WHERE PAGE_ID = p_page_id;

Line 10611: FND_MSG_PUB.Add;

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

Line 10612: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 10682: FND_MSG_PUB.Add;

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

Line 10683: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

10679: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10680: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10681: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10682: FND_MSG_PUB.Add;
10683: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10684: ,p_count => x_msg_count
10685: ,p_data => x_msg_data);
10686:
10687: END IF;

Line 10790: FND_MSG_PUB.Initialize;

10786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10787: END IF;
10788: -- Initialize message list even though we don't currently use it
10789: IF FND_API.To_Boolean(p_init_msg_list) THEN
10790: FND_MSG_PUB.Initialize;
10791: END IF;
10792:
10793: INSERT INTO EGO_PAGE_ENTRIES_B
10794: (

Line 10852: FND_MSG_PUB.Add;

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

Line 10853: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

10849: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
10850: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
10851: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
10852: FND_MSG_PUB.Add;
10853: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10854: ,p_count => x_msg_count
10855: ,p_data => x_msg_data);
10856: --ego_ef_test_pub.insert_into_ego_err_msgs(x_msg_data);
10857: ------------------------------------------------------------------

Line 10869: FND_MSG_PUB.Add;

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

Line 10870: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 10885: FND_MSG_PUB.Add;

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

Line 10886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 10933: FND_MSG_PUB.Initialize;

10929: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10930: END IF;
10931: -- Initialize message list even though we don't currently use it
10932: IF FND_API.To_Boolean(p_init_msg_list) THEN
10933: FND_MSG_PUB.Initialize;
10934: END IF;
10935:
10936: UPDATE EGO_PAGE_ENTRIES_B
10937: SET SEQUENCE = p_sequence,

Line 10979: FND_MSG_PUB.Add;

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

Line 10980: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 10996: FND_MSG_PUB.Add;

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

Line 10997: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 11012: FND_MSG_PUB.Add;

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

Line 11013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 11057: FND_MSG_PUB.Initialize;

11053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11054: END IF;
11055: -- Initialize message list even though we don't currently use it
11056: IF FND_API.To_Boolean(p_init_msg_list) THEN
11057: FND_MSG_PUB.Initialize;
11058: END IF;
11059:
11060: --Bug 3871440
11061: DELETE FROM EGO_PAGE_ENTRIES_B

Line 11084: FND_MSG_PUB.Add;

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

Line 11085: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 11141: FND_MSG_PUB.Initialize;

11137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11138: END IF;
11139: -- Initialize message list even though we don't currently use it
11140: IF FND_API.To_Boolean(p_init_msg_list) THEN
11141: FND_MSG_PUB.Initialize;
11142: END IF;
11143:
11144: SELECT EGO_FUNCTIONS_S.NEXTVAL INTO x_function_id FROM DUAL;
11145:

Line 11218: FND_MSG_PUB.Add;

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

Line 11219: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 11268: FND_MSG_PUB.Initialize;

11264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11265: END IF;
11266: -- Initialize message list even though we don't currently use it
11267: IF FND_API.To_Boolean(p_init_msg_list) THEN
11268: FND_MSG_PUB.Initialize;
11269: END IF;
11270:
11271: UPDATE EGO_FUNCTIONS_B
11272: SET

Line 11313: FND_MSG_PUB.Add;

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

Line 11314: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 11360: FND_MSG_PUB.Initialize;

11356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11357: END IF;
11358: -- Initialize message list even though we don't currently use it
11359: IF FND_API.To_Boolean(p_init_msg_list) THEN
11360: FND_MSG_PUB.Initialize;
11361: END IF;
11362:
11363: -- If a Function is in use by any Actions, it cannot be deleted.
11364: -- We check function_id, prompt_function_id and visibility_func_id

Line 11423: FND_MSG_PUB.Add;

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

Line 11424: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 11492: FND_MSG_PUB.Initialize;

11488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11489: END IF;
11490: -- Initialize message list even though we don't currently use it
11491: IF FND_API.To_Boolean(p_init_msg_list) THEN
11492: FND_MSG_PUB.Initialize;
11493: END IF;
11494:
11495: SELECT EGO_ACTIONS_S.NEXTVAL INTO x_action_id FROM DUAL;
11496:

Line 11605: FND_MSG_PUB.Add;

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

Line 11606: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

11602: x_return_status := FND_API.G_RET_STS_ERROR;
11603: x_errorcode := 1;
11604: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_SEQ_ERR');
11605: FND_MSG_PUB.Add;
11606: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11607: ,p_count => x_msg_count
11608: ,p_data => x_msg_data);
11609:
11610: WHEN e_dup_action_name_error THEN

Line 11617: FND_MSG_PUB.Add;

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

Line 11618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

11614: x_return_status := FND_API.G_RET_STS_ERROR;
11615: x_errorcode := 1;
11616: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_NAME_ERR');
11617: FND_MSG_PUB.Add;
11618: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11619: ,p_count => x_msg_count
11620: ,p_data => x_msg_data);
11621:
11622: WHEN OTHERS THEN

Line 11632: FND_MSG_PUB.Add;

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

Line 11633: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

11629: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11630: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11631: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11632: FND_MSG_PUB.Add;
11633: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11634: ,p_count => x_msg_count
11635: ,p_data => x_msg_data);
11636:
11637:

Line 11721: FND_MSG_PUB.Add;

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

Line 11722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

11718: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11719: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11720: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11721: FND_MSG_PUB.Add;
11722: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11723: ,p_count => x_msg_count
11724: ,p_data => x_msg_data);
11725:
11726: END IF;

Line 11783: FND_MSG_PUB.Initialize;

11779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11780: END IF;
11781: -- Initialize message list even though we don't currently use it
11782: IF FND_API.To_Boolean(p_init_msg_list) THEN
11783: FND_MSG_PUB.Initialize;
11784: END IF;
11785:
11786: -- Disallow changes that duplicate a preexisting action's sequence
11787: -- number or name in the classification/attribute group association.

Line 11888: FND_MSG_PUB.Add;

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

Line 11889: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

11885: x_return_status := FND_API.G_RET_STS_ERROR;
11886: x_errorcode := 1;
11887: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_SEQ_ERR');
11888: FND_MSG_PUB.Add;
11889: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11890: ,p_count => x_msg_count
11891: ,p_data => x_msg_data);
11892:
11893: WHEN e_dup_action_name_error THEN

Line 11900: FND_MSG_PUB.Add;

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

Line 11901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

11897: x_return_status := FND_API.G_RET_STS_ERROR;
11898: x_errorcode := 1;
11899: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_NAME_ERR');
11900: FND_MSG_PUB.Add;
11901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11902: ,p_count => x_msg_count
11903: ,p_data => x_msg_data);
11904:
11905: WHEN OTHERS THEN

Line 11915: FND_MSG_PUB.Add;

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

Line 11916: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 11965: FND_MSG_PUB.Initialize;

11961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11962: END IF;
11963: -- Initialize message list even though we don't currently use it
11964: IF FND_API.To_Boolean(p_init_msg_list) THEN
11965: FND_MSG_PUB.Initialize;
11966: END IF;
11967:
11968: -- We get the Function ID before deleting the row so we can
11969: -- delete Mappings for the Function if necessary.

Line 12026: FND_MSG_PUB.Add;

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

Line 12027: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 12074: FND_MSG_PUB.Initialize;

12070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12071: END IF;
12072: -- Initialize message list even though we don't currently use it
12073: IF FND_API.To_Boolean(p_init_msg_list) THEN
12074: FND_MSG_PUB.Initialize;
12075: END IF;
12076:
12077: INSERT INTO EGO_ACTIONS_DL
12078: (

Line 12118: FND_MSG_PUB.Add;

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

Line 12119: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

12115: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12116: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12117: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12118: FND_MSG_PUB.Add;
12119: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12120: ,p_count => x_msg_count
12121: ,p_data => x_msg_data);
12122: END Create_Action_Data_Level;
12123:

Line 12169: FND_MSG_PUB.Initialize;

12165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12166: END IF;
12167: -- Initialize message list even though we don't currently use it
12168: IF FND_API.To_Boolean(p_init_msg_list) THEN
12169: FND_MSG_PUB.Initialize;
12170: END IF;
12171:
12172: INSERT INTO EGO_ACTION_DISPLAYS_B
12173: (

Line 12223: FND_MSG_PUB.Add;

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

Line 12224: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 12270: FND_MSG_PUB.Initialize;

12266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12267: END IF;
12268: -- Initialize message list even though we don't currently use it
12269: IF FND_API.To_Boolean(p_init_msg_list) THEN
12270: FND_MSG_PUB.Initialize;
12271: END IF;
12272:
12273: INSERT INTO EGO_ACTION_DISPLAYS_B
12274: (

Line 12314: FND_MSG_PUB.Add;

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

Line 12315: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 12373: FND_MSG_PUB.Initialize;

12369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12370: END IF;
12371: -- Initialize message list even though we don't currently use it
12372: IF FND_API.To_Boolean(p_init_msg_list) THEN
12373: FND_MSG_PUB.Initialize;
12374: END IF;
12375:
12376: -- Just in case caller is updating an Action that doesn't yet have a Display...
12377:

Line 12486: FND_MSG_PUB.Add;

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

Line 12487: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 12539: FND_MSG_PUB.Initialize;

12535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12536: END IF;
12537: -- Initialize message list even though we don't currently use it
12538: IF FND_API.To_Boolean(p_init_msg_list) THEN
12539: FND_MSG_PUB.Initialize;
12540: END IF;
12541:
12542: SELECT COUNT(*)
12543: INTO l_disp_check_count

Line 12646: FND_MSG_PUB.Add;

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

Line 12647: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 12695: FND_MSG_PUB.Initialize;

12691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12692: END IF;
12693: -- Initialize message list even though we don't currently use it
12694: IF FND_API.To_Boolean(p_init_msg_list) THEN
12695: FND_MSG_PUB.Initialize;
12696: END IF;
12697:
12698: -- We get the prompt and vis function IDs before we delete the row
12699: -- so we can also delete their function mappings, if necessary

Line 12765: FND_MSG_PUB.Add;

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

Line 12766: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 12822: FND_MSG_PUB.Initialize;

12818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12819: END IF;
12820: -- Initialize message list even though we don't currently use it
12821: IF FND_API.To_Boolean(p_init_msg_list) THEN
12822: FND_MSG_PUB.Initialize;
12823: END IF;
12824:
12825: SELECT EGO_FUNC_PARAMS_S.NEXTVAL INTO x_function_param_id FROM DUAL;
12826:

Line 12899: FND_MSG_PUB.Add;

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

Line 12900: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 12947: FND_MSG_PUB.Initialize;

12943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12944: END IF;
12945: -- Initialize message list even though we don't currently use it
12946: IF FND_API.To_Boolean(p_init_msg_list) THEN
12947: FND_MSG_PUB.Initialize;
12948: END IF;
12949:
12950: UPDATE EGO_FUNC_PARAMS_B
12951: SET

Line 12990: FND_MSG_PUB.Add;

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

Line 12991: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 13035: FND_MSG_PUB.Initialize;

13031: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13032: END IF;
13033: -- Initialize message list even though we don't currently use it
13034: IF FND_API.To_Boolean(p_init_msg_list) THEN
13035: FND_MSG_PUB.Initialize;
13036: END IF;
13037:
13038: DELETE FROM EGO_FUNC_PARAMS_B
13039: WHERE

Line 13068: FND_MSG_PUB.Add;

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

Line 13069: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 13130: FND_MSG_PUB.Initialize;

13126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13127: END IF;
13128: -- Initialize message list even though we don't currently use it
13129: IF FND_API.To_Boolean(p_init_msg_list) THEN
13130: FND_MSG_PUB.Initialize;
13131: END IF;
13132:
13133: INSERT INTO EGO_MAPPINGS_B
13134: (

Line 13192: FND_MSG_PUB.Add;

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

Line 13193: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 13282: FND_MSG_PUB.Add;

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

Line 13283: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

13279: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13280: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13281: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13282: FND_MSG_PUB.Add;
13283: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13284: ,p_count => x_msg_count
13285: ,p_data => x_msg_data);
13286:
13287: END IF;

Line 13344: FND_MSG_PUB.Initialize;

13340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13341: END IF;
13342: -- Initialize message list even though we don't currently use it
13343: IF FND_API.To_Boolean(p_init_msg_list) THEN
13344: FND_MSG_PUB.Initialize;
13345: END IF;
13346:
13347: IF (p_new_mapping_group_pk1 IS NOT NULL AND
13348: p_new_mapping_group_pk2 IS NOT NULL AND

Line 13418: FND_MSG_PUB.Add;

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

Line 13419: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 13520: FND_MSG_PUB.Add;

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

Line 13521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

13517: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
13518: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
13519: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
13520: FND_MSG_PUB.Add;
13521: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13522: ,p_count => x_msg_count
13523: ,p_data => x_msg_data);
13524:
13525: END IF;

Line 13567: FND_MSG_PUB.Initialize;

13563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13564: END IF;
13565: -- Initialize message list even though we don't currently use it
13566: IF FND_API.To_Boolean(p_init_msg_list) THEN
13567: FND_MSG_PUB.Initialize;
13568: END IF;
13569:
13570: DELETE FROM EGO_MAPPINGS_B
13571: WHERE

Line 13594: FND_MSG_PUB.Add;

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

Line 13595: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 13641: FND_MSG_PUB.Initialize;

13637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13638: END IF;
13639: -- Initialize message list even though we don't currently use it
13640: IF FND_API.To_Boolean(p_init_msg_list) THEN
13641: FND_MSG_PUB.Initialize;
13642: END IF;
13643:
13644: DELETE FROM EGO_MAPPINGS_B
13645: WHERE

Line 13669: FND_MSG_PUB.Add;

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

Line 13670: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 13726: FND_MSG_PUB.Initialize;

13722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13723: END IF;
13724: -- Initialize message list even though we don't currently use it
13725: IF FND_API.To_Boolean(p_init_msg_list) THEN
13726: FND_MSG_PUB.Initialize;
13727: END IF;
13728:
13729: SELECT EGO_ACTION_GROUPS_S.NEXTVAL INTO x_action_group_id FROM DUAL;
13730:

Line 13804: FND_MSG_PUB.Add;

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

Line 13805: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 13853: FND_MSG_PUB.Initialize;

13849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13850: END IF;
13851: -- Initialize message list even though we don't currently use it
13852: IF FND_API.To_Boolean(p_init_msg_list) THEN
13853: FND_MSG_PUB.Initialize;
13854: END IF;
13855:
13856: UPDATE EGO_ACTION_GROUPS_B
13857: SET

Line 13898: FND_MSG_PUB.Add;

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

Line 13899: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 13941: FND_MSG_PUB.Initialize;

13937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13938: END IF;
13939: -- Initialize message list even though we don't currently use it
13940: IF FND_API.To_Boolean(p_init_msg_list) THEN
13941: FND_MSG_PUB.Initialize;
13942: END IF;
13943:
13944: -- If there are Actions in this Action Group, we delete their entries
13945: -- in the Action_Group_Entries table (but we don't delete the Actions).

Line 13976: FND_MSG_PUB.Add;

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

Line 13977: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 14030: FND_MSG_PUB.Initialize;

14026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14027: END IF;
14028: -- Initialize message list even though we don't currently use it
14029: IF FND_API.To_Boolean(p_init_msg_list) THEN
14030: FND_MSG_PUB.Initialize;
14031: END IF;
14032:
14033: SELECT COUNT(ACTION_ID)
14034: INTO l_exist_action_count

Line 14082: FND_MSG_PUB.Add;

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

Line 14083: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 14130: FND_MSG_PUB.Initialize;

14126: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14127: END IF;
14128: -- Initialize message list even though we don't currently use it
14129: IF FND_API.To_Boolean(p_init_msg_list) THEN
14130: FND_MSG_PUB.Initialize;
14131: END IF;
14132:
14133: UPDATE EGO_ACTN_GRP_ENTRIES_B
14134: SET SEQUENCE = p_sequence

Line 14156: FND_MSG_PUB.Add;

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

Line 14157: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 14200: FND_MSG_PUB.Initialize;

14196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
14197: END IF;
14198: -- Initialize message list even though we don't currently use it
14199: IF FND_API.To_Boolean(p_init_msg_list) THEN
14200: FND_MSG_PUB.Initialize;
14201: END IF;
14202:
14203: DELETE FROM EGO_ACTN_GRP_ENTRIES_B
14204: WHERE

Line 14226: FND_MSG_PUB.Add;

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

Line 14227: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 14857: FND_MSG_PUB.initialize;

14853:
14854: -- Initialize API message list if necessary.
14855: -- Initialize message list if p_init_msg_list is set to TRUE.
14856: IF FND_API.to_Boolean( P_INIT_MSG_LIST ) THEN
14857: FND_MSG_PUB.initialize;
14858: END IF;
14859:
14860: -- Check If the view name is already present
14861: l_agv_name := UPPER(p_agv_name);

Line 14870: FND_MSG_PUB.add;

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

Line 14882: FND_MSG_PUB.add;

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

Line 14940: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

14936: END IF;
14937: IF c_check_obj_name%ISOPEN THEN
14938: CLOSE c_check_obj_name;
14939: END IF;
14940: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14941: ,p_count => x_msg_count
14942: ,p_data => x_msg_data);
14943: x_return_status := FND_API.G_RET_STS_ERROR;
14944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 14948: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

14944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14945: IF FND_API.To_Boolean( p_commit ) THEN
14946: ROLLBACK TO Update_AGV_Name;
14947: END IF;
14948: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14949: ,p_count => x_msg_count
14950: ,p_data => x_msg_data);
14951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14952: WHEN OTHERS THEN

Line 14962: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

14958: END IF;
14959: IF c_check_obj_name%ISOPEN THEN
14960: CLOSE c_check_obj_name;
14961: END IF;
14962: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
14963: ,p_count => x_msg_count
14964: ,p_data => x_msg_data);
14965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
14966:

Line 15001: FND_MSG_PUB.initialize;

14997:
14998: -- Initialize API message list if necessary.
14999: -- Initialize message list if p_init_msg_list is set to TRUE.
15000: IF FND_API.to_Boolean( P_INIT_MSG_LIST ) THEN
15001: FND_MSG_PUB.initialize;
15002: END IF;
15003:
15004: -------------------------------------------------------------------------------------
15005: -- Make sure that the control level corresponds with either Master Level or Org Level

Line 15066: FND_MSG_PUB.Add;

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

Line 15067: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 15075: FND_MSG_PUB.Add;

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

Line 15076: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 15089: FND_MSG_PUB.Add;

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

Line 15090: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 16116: FND_MSG_PUB.Add;

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

Line 16117: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 16126: FND_MSG_PUB.Add;

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

Line 16127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 16136: FND_MSG_PUB.Add;

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

Line 16137: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 16146: FND_MSG_PUB.Add;

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

Line 16147: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 16156: FND_MSG_PUB.Add;

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

Line 16157: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 16166: FND_MSG_PUB.Add;

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

Line 16167: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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

Line 16178: FND_MSG_PUB.Add;

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

Line 16179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE

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