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 241: FND_MSG_PUB.Initialize;

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

Line 265: FND_MSG_PUB.Add;

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

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

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

Line 834: FND_MSG_PUB.Add;

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

Line 939: FND_MSG_PUB.Add;

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

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

936: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
937: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
938: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
939: FND_MSG_PUB.Add;
940: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
941: ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943:
944: END Delete_Attribute_Internal;

Line 1022: FND_MSG_PUB.Add;

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

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

1019: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1020: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
1021: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1022: FND_MSG_PUB.Add;
1023: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
1024: ,p_count => x_msg_count
1025: ,p_data => x_msg_data);
1026:
1027: END Delete_Attr_Group_Internal;

Line 1476: FND_MSG_PUB.Add;

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

Line 2246: FND_MSG_PUB.Initialize;

2242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2243: END IF;
2244: -- Initialize message list even though we don't currently use it
2245: IF FND_API.To_Boolean(p_init_msg_list) THEN
2246: FND_MSG_PUB.Initialize;
2247: END IF;
2248: -----------------------------------
2249: --check if the Attribute Group name begins with a number.
2250: --Bug 5443697

Line 2503: FND_MSG_PUB.Add;

2499: ROLLBACK TO Create_Attribute_Group_PUB;
2500: END IF;
2501: x_return_status := FND_API.G_RET_STS_ERROR;
2502: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_GRP_EXIST');
2503: FND_MSG_PUB.Add;
2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2505: ,p_count => x_msg_count
2506: ,p_data => x_msg_data);
2507: END IF; --l_ego_exists <> Y --Bug 4703510

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

2500: END IF;
2501: x_return_status := FND_API.G_RET_STS_ERROR;
2502: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_GRP_EXIST');
2503: FND_MSG_PUB.Add;
2504: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2505: ,p_count => x_msg_count
2506: ,p_data => x_msg_data);
2507: END IF; --l_ego_exists <> Y --Bug 4703510
2508:

Line 2517: FND_MSG_PUB.Add;

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

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

2514: END IF;
2515: x_return_status := FND_API.G_RET_STS_ERROR;
2516: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_NUM');
2517: FND_MSG_PUB.Add;
2518: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2519: ,p_count => x_msg_count
2520: ,p_data => x_msg_data);
2521:
2522: --Bug 5443697

Line 2529: FND_MSG_PUB.Add;

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

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

2526: END IF;
2527: x_return_status := FND_API.G_RET_STS_ERROR;
2528: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_AG_NAME_ST_UND_SC');
2529: FND_MSG_PUB.Add;
2530: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2531: ,p_count => x_msg_count
2532: ,p_data => x_msg_data);
2533:
2534: WHEN OTHERS THEN

Line 2554: FND_MSG_PUB.Add;

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

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

2551: -- x_msg_data will maintain the SQLERRM generated in the autonomous transaction.
2552: -- Bug 6120553
2553: FND_MESSAGE.Set_Token('SQL_ERR_MSG', NVL(l_sql_errm, SQLERRM)||' '||FND_FLEX_DSC_API.Message());
2554: FND_MSG_PUB.Add;
2555: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2556: ,p_count => x_msg_count
2557: ,p_data => x_msg_data);
2558: END IF;
2559:

Line 2708: FND_MSG_PUB.Initialize;

2704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2705: END IF;
2706: -- Initialize message list even though we don't currently use it
2707: IF FND_API.To_Boolean(p_init_msg_list) THEN
2708: FND_MSG_PUB.Initialize;
2709: END IF;
2710:
2711: l_sequence_numbers := ' ';
2712:

Line 2787: FND_MSG_PUB.Add;

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

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

2784: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2785: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2786: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2787: FND_MSG_PUB.Add;
2788: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2789: ,p_count => x_msg_count
2790: ,p_data => x_msg_data);
2791:
2792: END Copy_Attribute_Group;

Line 2971: FND_MSG_PUB.Add;

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

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

2968: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2969: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2970: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2971: FND_MSG_PUB.Add;
2972: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
2973: ,p_count => x_msg_count
2974: ,p_data => x_msg_data);
2975: END IF;
2976:

Line 3036: FND_MSG_PUB.Initialize;

3032: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3033: END IF;
3034: -- Initialize message list even though we don't currently use it
3035: IF FND_API.To_Boolean(p_init_msg_list) THEN
3036: FND_MSG_PUB.Initialize;
3037: END IF;
3038: --Initialize num cols and rows.
3039: --Bug 6048237
3040: IF p_multi_row_attrib_group = 'Y' THEN

Line 3122: FND_MSG_PUB.Add;

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

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

3119: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3120: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3121: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3122: FND_MSG_PUB.Add;
3123: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3124: ,p_count => x_msg_count
3125: ,p_data => x_msg_data);
3126:
3127: END Update_Attribute_Group;

Line 3191: FND_MSG_PUB.Add;

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

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

3188: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3189: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3190: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3191: FND_MSG_PUB.Add;
3192: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3193: ,p_count => x_msg_count
3194: ,p_data => x_msg_data);
3195: END IF;
3196:

Line 3238: FND_MSG_PUB.Initialize;

3234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3235: END IF;
3236: -- Initialize message list even though we don't currently use it
3237: IF FND_API.To_Boolean(p_init_msg_list) THEN
3238: FND_MSG_PUB.Initialize;
3239: END IF;
3240:
3241: l_assocs_exist := Check_Associations_Exist(p_application_id,
3242: p_attr_group_type,

Line 3260: FND_MSG_PUB.Add;

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

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

3257:
3258: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ASSOCS_EXIST1');
3259: FND_MESSAGE.Set_Token('ATTR_GRP_NAME', l_attr_group_disp_name);
3260: FND_MSG_PUB.Add;
3261: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3262: ,p_count => x_msg_count
3263: ,p_data => x_msg_data);
3264:
3265: ELSE

Line 3296: FND_MSG_PUB.Add;

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

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

3293: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
3294: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
3295: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
3296: FND_MSG_PUB.Add;
3297: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
3298: ,p_count => x_msg_count
3299: ,p_data => x_msg_data);
3300:
3301: END Delete_Attribute_Group;

Line 3804: FND_MSG_PUB.Initialize;

3800: BEGIN
3801:
3802: -- Initialize message list if caller asked us to do so
3803: IF FND_API.To_Boolean(p_init_msg_list) THEN
3804: FND_MSG_PUB.Initialize;
3805: ERROR_HANDLER.Initialize;
3806: END IF;
3807:
3808: IF (p_attr_group_id_list IS NOT NULL) THEN

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

4117: /***
4118: Dylan wonders: did I write this? If so, why? If not, who did...and why?
4119: Maybe it was for PA integration...?
4120: ***/
4121: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4122: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4123: END IF;
4124:
4125: END Validate_Unique_Key_Attrs;

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

4118: Dylan wonders: did I write this? If so, why? If not, who did...and why?
4119: Maybe it was for PA integration...?
4120: ***/
4121: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4122: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
4123: END IF;
4124:
4125: END Validate_Unique_Key_Attrs;
4126:

Line 4181: FND_MSG_PUB.Initialize;

4177: code_debug(l_api_name ||' Start ');
4178:
4179: -- Initialize message list even though we don't currently use it
4180: IF FND_API.To_Boolean(p_init_msg_list) THEN
4181: FND_MSG_PUB.Initialize;
4182: END IF;
4183:
4184: -- Check for call compatibility
4185: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

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

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

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

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

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

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

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

Line 4214: FND_MSG_PUB.Add;

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

Line 4248: FND_MSG_PUB.Add;

4244: END IF;
4245:
4246: IF l_data_level_id = ((p_application_id+1) * 100) THEN
4247: fnd_message.set_name(G_APP_NAME, 'EGO_EF_DATA_LEVEL_LIMIT');
4248: FND_MSG_PUB.Add;
4249: RAISE FND_API.G_EXC_ERROR;
4250: END IF;
4251:
4252: code_debug(l_api_name ||' Data level id being used in insert: '||l_data_level_id);

Line 4342: FND_MSG_PUB.Add;

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

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

4387: code_debug(l_api_name ||' Exception - FND_API.G_EXC_ERROR '||x_msg_data);
4388: IF FND_API.TO_BOOLEAN(p_commit) THEN
4389: ROLLBACK to SYNC_DATA_LEVEL;
4390: END IF;
4391: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4392: ,p_count => x_msg_count
4393: ,p_data => x_msg_data);
4394: x_return_status := FND_API.G_RET_STS_ERROR;
4395:

Line 4460: FND_MSG_PUB.Initialize;

4456: code_debug(l_api_name ||' Start ');
4457:
4458: -- Initialize message list even though we don't currently use it
4459: IF FND_API.To_Boolean(p_init_msg_list) THEN
4460: FND_MSG_PUB.Initialize;
4461: END IF;
4462:
4463: -- Check for call compatibility
4464: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

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

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

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

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

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

Line 4494: FND_MSG_PUB.Add;

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

Line 4525: FND_MSG_PUB.Add;

4521: ELSE
4522: FND_MESSAGE.Set_Token('NAME','Attribute Id' );
4523: FND_MESSAGE.Set_Token('VALUE',l_attr_group_id);
4524: END IF;
4525: FND_MSG_PUB.Add;
4526: RAISE FND_API.G_EXC_ERROR;
4527: END;
4528:
4529: -- data level check

Line 4556: FND_MSG_PUB.Add;

4552: ELSE
4553: FND_MESSAGE.Set_Token('NAME','Data Level Id' );
4554: FND_MESSAGE.Set_Token('VALUE',p_data_level_id);
4555: END IF;
4556: FND_MSG_PUB.Add;
4557: RAISE FND_API.G_EXC_ERROR;
4558: END;
4559: code_debug(l_api_name ||' Data Level id '||l_data_level_rec.data_level_id);
4560:

Line 4584: FND_MSG_PUB.Add;

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

Line 4598: FND_MSG_PUB.Add;

4594: ELSE
4595: FND_MESSAGE.Set_Token('NAME','Defaulting ' );
4596: FND_MESSAGE.Set_Token('VALUE',p_defaulting);
4597: END IF;
4598: FND_MSG_PUB.Add;
4599: RAISE FND_API.G_EXC_ERROR;
4600: END;
4601: code_debug(l_api_name ||' Defaulting '||l_defaulting);
4602:

Line 4628: FND_MSG_PUB.Add;

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

Line 4645: FND_MSG_PUB.Add;

4641: ELSE
4642: FND_MESSAGE.set_token('NAME','View Privilege');
4643: FND_MESSAGE.set_token('VALUE',p_user_view_priv_name);
4644: END IF;
4645: FND_MSG_PUB.Add;
4646: RAISE FND_API.G_EXC_ERROR;
4647: END;
4648: code_debug(l_api_name ||' View Priv id '||l_view_priv_id);
4649:

Line 4675: FND_MSG_PUB.Add;

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

Line 4692: FND_MSG_PUB.Add;

4688: ELSE
4689: FND_MESSAGE.set_token('NAME','Edit Privilege');
4690: FND_MESSAGE.set_token('VALUE',p_user_edit_priv_name);
4691: END IF;
4692: FND_MSG_PUB.Add;
4693: RAISE FND_API.G_EXC_ERROR;
4694: END;
4695: code_debug(l_api_name ||' Edit Priv id '||l_edit_priv_id);
4696:

Line 4700: FND_MSG_PUB.Add;

4696:
4697: IF NVL(p_raise_pre_event,'N') IN ('Y', 'N') THEN
4698: IF l_data_level_rec.enable_pre_event = 'N' AND NVL(p_raise_pre_event,'N') = 'Y' THEN
4699: fnd_message.set_name(G_APP_NAME,'EGO_PRE_EVENT_NOT_ALLOWED');
4700: FND_MSG_PUB.Add;
4701: RAISE FND_API.G_EXC_ERROR;
4702: ELSE
4703: l_raise_pre_event := NVL(p_raise_pre_event,'N');
4704: END IF;

Line 4709: FND_MSG_PUB.Add;

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

Line 4717: FND_MSG_PUB.Add;

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

Line 4726: FND_MSG_PUB.Add;

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

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

4782: code_debug(l_api_name ||' Exception - FND_API.G_EXC_ERROR '||x_msg_data);
4783: IF FND_API.TO_BOOLEAN(p_commit) THEN
4784: ROLLBACK to SYNC_DL_ASSOC;
4785: END IF;
4786: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
4787: ,p_count => x_msg_count
4788: ,p_data => x_msg_data);
4789: x_return_status := FND_API.G_RET_STS_ERROR;
4790:

Line 4905: FND_MSG_PUB.Initialize;

4901: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4902: END IF;
4903: -- Initialize message list even though we don't currently use it
4904: IF FND_API.To_Boolean(p_init_msg_list) THEN
4905: FND_MSG_PUB.Initialize;
4906: END IF;
4907: --Bug 4703510
4908: --check if the Attribute name starts with a number
4909: --Bug 5443697

Line 5438: FND_MSG_PUB.Add;

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

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

5435:
5436: x_return_status := FND_API.G_RET_STS_ERROR;
5437: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_INTERNAL_NAME_UNIQUE');
5438: FND_MSG_PUB.Add;
5439: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5440: ,p_count => x_msg_count
5441: ,p_data => x_msg_data);
5442:
5443: END IF;--l_ego_exists <> 'Y'--Bug 4703510

Line 5453: FND_MSG_PUB.Add;

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

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

5450: END IF;
5451: x_return_status := FND_API.G_RET_STS_ERROR;
5452: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_NUM');
5453: FND_MSG_PUB.Add;
5454: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5455: ,p_count => x_msg_count
5456: ,p_data => x_msg_data);
5457:
5458: WHEN e_attr_starts_with_und_sc THEN

Line 5464: FND_MSG_PUB.Add;

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

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

5461: END IF;
5462: x_return_status := FND_API.G_RET_STS_ERROR;
5463: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_NAME_ST_UND_SC');
5464: FND_MSG_PUB.Add;
5465: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5466: ,p_count => x_msg_count
5467: ,p_data => x_msg_data);
5468:
5469: WHEN e_col_internal_name_error THEN

Line 5475: FND_MSG_PUB.Add;

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

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

5472: END IF;
5473: x_return_status := FND_API.G_RET_STS_ERROR;
5474: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_INTRNL_NAME_ERR');
5475: FND_MSG_PUB.Add;
5476: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5477: ,p_count => x_msg_count
5478: ,p_data => x_msg_data);
5479:
5480: WHEN e_default_value_len_err THEN

Line 5487: FND_MSG_PUB.Add;

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

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

5484: x_return_status := FND_API.G_RET_STS_ERROR;
5485: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
5486: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
5487: FND_MSG_PUB.Add;
5488: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5489: ,p_count => x_msg_count
5490: ,p_data => x_msg_data);
5491:
5492: WHEN e_attr_dup_seq_error THEN

Line 5498: FND_MSG_PUB.Add;

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

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

5495: END IF;
5496: x_return_status := FND_API.G_RET_STS_ERROR;
5497: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_DUP_SEQ_ERR');
5498: FND_MSG_PUB.Add;
5499: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5500: ,p_count => x_msg_count
5501: ,p_data => x_msg_data);
5502:
5503:

Line 5510: FND_MSG_PUB.Add;

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

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

5507: END IF;
5508: x_return_status := FND_API.G_RET_STS_ERROR;
5509: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');
5510: FND_MSG_PUB.Add;
5511: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5512: ,p_count => x_msg_count
5513: ,p_data => x_msg_data);
5514:
5515:

Line 5523: FND_MSG_PUB.Add;

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

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

5520: END IF;
5521: x_return_status := FND_API.G_RET_STS_ERROR;
5522: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_COL_DT_ERR');
5523: FND_MSG_PUB.Add;
5524: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5525: ,p_count => x_msg_count
5526: ,p_data => x_msg_data);
5527:
5528: WHEN e_uom_not_allowed THEN

Line 5534: FND_MSG_PUB.Add;

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

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

5531: END IF;
5532: x_return_status := FND_API.G_RET_STS_ERROR;
5533: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');
5534: FND_MSG_PUB.Add;
5535: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5536: ,p_count => x_msg_count
5537: ,p_data => x_msg_data);
5538:
5539: WHEN e_vs_data_type_error THEN

Line 5545: FND_MSG_PUB.Add;

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

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

5542: END IF;
5543: x_return_status := FND_API.G_RET_STS_ERROR;
5544: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_VS_DT_ERR');
5545: FND_MSG_PUB.Add;
5546: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5547: ,p_count => x_msg_count
5548: ,p_data => x_msg_data);
5549:
5550: WHEN e_no_vs_for_id_error THEN

Line 5556: FND_MSG_PUB.Add;

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

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

5553: END IF;
5554: x_return_status := FND_API.G_RET_STS_ERROR;
5555: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ATTR_NO_VS_ERR');
5556: FND_MSG_PUB.Add;
5557: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5558: ,p_count => x_msg_count
5559: ,p_data => x_msg_data);
5560:
5561: WHEN e_bad_info_1_error THEN

Line 5580: FND_MSG_PUB.Add;

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

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

5577: x_return_status := FND_API.G_RET_STS_ERROR;
5578: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5579: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', l_attr_group_disp_name);
5580: FND_MSG_PUB.Add;
5581: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5582: ,p_count => x_msg_count
5583: ,p_data => x_msg_data);
5584: EXCEPTION
5585: WHEN NO_DATA_FOUND THEN

Line 5589: FND_MSG_PUB.Add;

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

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

5586: x_return_status := FND_API.G_RET_STS_ERROR;
5587: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DYNAMIC_URL_DATA_ERROR');
5588: FND_MESSAGE.Set_Token('ATTR_GROUP_DISP_NAME', null);
5589: FND_MSG_PUB.Add;
5590: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5591: ,p_count => x_msg_count
5592: ,p_data => x_msg_data);
5593: END;
5594:

Line 5605: FND_MSG_PUB.Add;

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

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

5602: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
5603: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
5604: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
5605: FND_MSG_PUB.Add;
5606: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
5607: ,p_count => x_msg_count
5608: ,p_data => x_msg_data);
5609:
5610: END Create_Attribute;

Line 5695: FND_MSG_PUB.Initialize;

5691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5692: END IF;
5693: -- Initialize message list even though we don't currently use it
5694: IF FND_API.To_Boolean(p_init_msg_list) THEN
5695: FND_MSG_PUB.Initialize;
5696: END IF;
5697:
5698: -----------------------------------
5699: -- get the attribute details -- ego specific

Line 6021: FND_MSG_PUB.Add;

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

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

6018: x_return_status := FND_API.G_RET_STS_ERROR;
6019: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_DEFAULT_VAL_LEN_ERR');
6020: FND_MESSAGE.Set_Token('ATTR_MAX_LENGTH', l_col_width);
6021: FND_MSG_PUB.Add;
6022: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6023: ,p_count => x_msg_count
6024: ,p_data => x_msg_data);
6025:
6026: WHEN e_attr_dup_seq_error THEN

Line 6032: FND_MSG_PUB.Add;

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

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

6029: END IF;
6030: x_return_status := FND_API.G_RET_STS_ERROR;
6031: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ATTR_DUP_SEQ_ERR');
6032: FND_MSG_PUB.Add;
6033: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6034: ,p_count => x_msg_count
6035: ,p_data => x_msg_data);
6036: WHEN e_uom_not_allowed THEN
6037: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 6042: FND_MSG_PUB.Add;

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

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

6039: END IF;
6040: x_return_status := FND_API.G_RET_STS_ERROR;
6041: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_ATTR_UOM_COL_ERR');
6042: FND_MSG_PUB.Add;
6043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6044: ,p_count => x_msg_count
6045: ,p_data => x_msg_data);
6046:
6047:

Line 6054: FND_MSG_PUB.Add;

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

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

6051: END IF;
6052: x_return_status := FND_API.G_RET_STS_ERROR;
6053: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_MR_FIRST_ATTR_CBOX_ERR');
6054: FND_MSG_PUB.Add;
6055: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6056: ,p_count => x_msg_count
6057: ,p_data => x_msg_data);
6058:
6059: WHEN OTHERS THEN

Line 6069: FND_MSG_PUB.Add;

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

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

6066: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6067: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6068: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6069: FND_MSG_PUB.Add;
6070: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6071: ,p_count => x_msg_count
6072: ,p_data => x_msg_data);
6073:
6074: END Update_Attribute;

Line 6112: FND_MSG_PUB.Initialize;

6108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6109: END IF;
6110: -- Initialize message list even though we don't currently use it
6111: IF FND_API.To_Boolean(p_init_msg_list) THEN
6112: FND_MSG_PUB.Initialize;
6113: END IF;
6114:
6115: l_assocs_exist := Check_Associations_Exist(p_application_id,
6116: p_attr_group_type,

Line 6232: FND_MSG_PUB.Initialize;

6228: END IF;
6229:
6230: -- Initialize message list even though we don't currently use it
6231: IF FND_API.To_Boolean(p_init_msg_list) THEN
6232: FND_MSG_PUB.Initialize;
6233: END IF;
6234:
6235: -- Check for call compatibility
6236: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

6427: IF FND_API.To_Boolean( p_commit ) THEN
6428: ROLLBACK TO Create_Value_Set_PUB;
6429: END IF;
6430: x_return_status := FND_API.G_RET_STS_ERROR;
6431: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6432: ,p_count => x_msg_count
6433: ,p_data => x_msg_data);
6434: WHEN OTHERS THEN
6435: code_debug(l_api_name ||' EXCEPTION - OTHERS '||SQLERRM);

Line 6446: FND_MSG_PUB.Add;

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

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

6443: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6444: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6445: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM||' '||FND_FLEX_DSC_API.Message());
6446: FND_MSG_PUB.Add;
6447: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6448: ,p_count => x_msg_count
6449: ,p_data => x_msg_data);
6450: ELSE
6451: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6734: FND_MSG_PUB.Add;

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

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

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

Line 6837: FND_MSG_PUB.Initialize;

6833: END IF;
6834:
6835: -- Initialize message list even though we don't currently use it
6836: IF FND_API.To_Boolean(p_init_msg_list) THEN
6837: FND_MSG_PUB.Initialize;
6838: END IF;
6839:
6840: -- Check for call compatibility
6841: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

6957: IF FND_API.To_Boolean( p_commit ) THEN
6958: ROLLBACK TO Update_Value_Set_PUB;
6959: END IF;
6960: x_return_status := FND_API.G_RET_STS_ERROR;
6961: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6962: ,p_count => x_msg_count
6963: ,p_data => x_msg_data);
6964:
6965: WHEN OTHERS THEN

Line 6975: FND_MSG_PUB.Add;

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

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

6972: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
6973: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
6974: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
6975: FND_MSG_PUB.Add;
6976: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
6977: ,p_count => x_msg_count
6978: ,p_data => x_msg_data);
6979:
6980: END Update_Value_Set;

Line 7159: FND_MSG_PUB.Add;

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

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

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

Line 7215: FND_MSG_PUB.Initialize;

7211: END IF;
7212:
7213: -- Initialize message list even though we don't currently use it
7214: IF FND_API.To_Boolean(p_init_msg_list) THEN
7215: FND_MSG_PUB.Initialize;
7216: END IF;
7217:
7218: -- Check for call compatibility
7219: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

7320: IF FND_API.To_Boolean(p_commit) THEN
7321: ROLLBACK TO Insert_Value_Set_Table_Inf_PUB;
7322: END IF;
7323: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
7324: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7325: ,p_count => x_msg_count
7326: ,p_data => x_msg_data);
7327: WHEN OTHERS THEN
7328: code_debug(l_api_name ||' EXCEPTION OTHERS '|| SQLERRM);

Line 7338: FND_MSG_PUB.Add;

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

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

7335: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7336: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7337: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7338: FND_MSG_PUB.Add;
7339: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7340: ,p_count => x_msg_count
7341: ,p_data => x_msg_data);
7342:
7343: END Insert_Value_Set_table_Inf;

Line 7394: FND_MSG_PUB.Initialize;

7390: END IF;
7391:
7392: -- Initialize message list even though we don't currently use it
7393: IF FND_API.To_Boolean(p_init_msg_list) THEN
7394: FND_MSG_PUB.Initialize;
7395: END IF;
7396:
7397: -- Check for call compatibility
7398: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

7463: IF FND_API.To_Boolean(p_commit) THEN
7464: ROLLBACK TO Update_Value_Set_Table_Inf_PUB;
7465: END IF;
7466: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
7467: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7468: ,p_count => x_msg_count
7469: ,p_data => x_msg_data);
7470: WHEN OTHERS THEN
7471: code_debug(l_api_name ||' EXCEPTION OTHERS '|| SQLERRM);

Line 7481: FND_MSG_PUB.Add;

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

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

7478: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7479: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7480: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7481: FND_MSG_PUB.Add;
7482: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7483: ,p_count => x_msg_count
7484: ,p_data => x_msg_data);
7485:
7486: END Update_Value_Set_table_Inf;

Line 7538: FND_MSG_PUB.Initialize;

7534: END IF;
7535:
7536: -- Initialize message list even though we don't currently use it
7537: IF FND_API.To_Boolean(p_init_msg_list) THEN
7538: FND_MSG_PUB.Initialize;
7539: END IF;
7540:
7541: -- Check for call compatibility
7542: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

7658: IF FND_API.To_Boolean(p_commit) THEN
7659: ROLLBACK TO Create_Value_Set_Val_PUB;
7660: END IF;
7661: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
7662: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7663: ,p_count => x_msg_count
7664: ,p_data => x_msg_data);
7665: WHEN OTHERS THEN
7666: code_debug( l_api_name || ' EXCEPTION - OTHERS ');

Line 7677: FND_MSG_PUB.Add;

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

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

7674: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7675: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7676: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7677: FND_MSG_PUB.Add;
7678: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7679: ,p_count => x_msg_count
7680: ,p_data => x_msg_data);
7681:
7682: END Create_Value_Set_Val;

Line 7723: FND_MSG_PUB.Initialize;

7719: END IF;
7720:
7721: -- Initialize message list even though we don't currently use it
7722: IF FND_API.To_Boolean(p_init_msg_list) THEN
7723: FND_MSG_PUB.Initialize;
7724: END IF;
7725:
7726: -- Check for call compatibility
7727: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

7785: IF FND_API.To_Boolean(p_commit) THEN
7786: ROLLBACK TO Update_Value_Set_Val_PUB;
7787: END IF;
7788: x_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
7789: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7790: ,p_count => x_msg_count
7791: ,p_data => x_msg_data);
7792: WHEN OTHERS THEN
7793: code_debug( l_api_name || ' EXCEPTION - OTHERS ');

Line 7804: FND_MSG_PUB.Add;

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

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

7801: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
7802: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
7803: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
7804: FND_MSG_PUB.Add;
7805: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
7806: ,p_count => x_msg_count
7807: ,p_data => x_msg_data);
7808:
7809: END Update_Value_Set_Val;

Line 8152: FND_MSG_PUB.Initialize;

8148: --
8149: -- Initialize message list
8150: --
8151: IF FND_API.To_Boolean(p_init_msg_list) THEN
8152: FND_MSG_PUB.Initialize;
8153: END IF;
8154:
8155: code_debug(l_api_name||' msg pub initialized ' );
8156: --

Line 8212: FND_MSG_PUB.Add;

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

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

8269: IF FND_API.To_Boolean( p_commit ) THEN
8270: ROLLBACK TO PROCESS_VS_VALUE_SEQUENCE_SP;
8271: END IF;
8272: x_return_status := FND_API.G_RET_STS_ERROR;
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: WHEN OTHERS THEN
8277: IF FND_API.To_Boolean( p_commit ) THEN

Line 8365: FND_MSG_PUB.Initialize;

8361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8362: END IF;
8363: -- Initialize message list even though we don't currently use it
8364: IF FND_API.To_Boolean(p_init_msg_list) THEN
8365: FND_MSG_PUB.Initialize;
8366: END IF;
8367:
8368: --Checking if the variant attribute group trying to be associated has attributes in it, if not raise exception
8369: SELECT Nvl(VARIANT, 'N')

Line 8385: FND_MSG_PUB.Add;

8381: IF(l_attr_count = 0 AND l_variant_flag = 'Y') THEN
8382: Fnd_Message.Set_Name (application => 'EGO',
8383: name => 'EGO_EF_NO_ATTR_EXIST'
8384: );
8385: FND_MSG_PUB.Add;
8386: RAISE e_variant_assocs_excep;
8387: END IF;
8388:
8389: -- SSARNOBA: Why do we have this SELECT INTO statement? We're not using

Line 8426: FND_MSG_PUB.Add;

8422: IF(l_style_exists = 'T' AND l_variant_flag = 'Y') THEN
8423: Fnd_Message.Set_Name (application => 'EGO',
8424: name => 'EGO_VARIANT_STYLE_EXIST'
8425: );
8426: FND_MSG_PUB.Add;
8427: RAISE e_variant_assocs_excep;
8428: END IF;
8429:
8430: --l_existing_datalevel := Get_Associated_Datalevel(p_object_id, p_attr_group_id);

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

8565: IF FND_API.To_Boolean(p_commit) THEN
8566: ROLLBACK TO Create_Association_PUB;
8567: END IF;
8568: x_return_status := FND_API.G_RET_STS_ERROR;
8569: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8570: ,p_count => x_msg_count
8571: ,p_data => x_msg_data);
8572:
8573:

Line 8587: FND_MSG_PUB.Add;

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

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

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

Line 8674: FND_MSG_PUB.Add;

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

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

8671: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8672: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8673: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8674: FND_MSG_PUB.Add;
8675: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8676: ,p_count => x_msg_count
8677: ,p_data => x_msg_data);
8678: END IF;
8679:

Line 8759: FND_MSG_PUB.Add;

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

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

8756: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8757: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8758: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8759: FND_MSG_PUB.Add;
8760: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8761: ,p_count => x_msg_count
8762: ,p_data => x_msg_data);
8763: END IF;
8764:

Line 8808: FND_MSG_PUB.Initialize;

8804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8805: END IF;
8806: -- Initialize message list even though we don't currently use it
8807: IF FND_API.To_Boolean(p_init_msg_list) THEN
8808: FND_MSG_PUB.Initialize;
8809: END IF;
8810:
8811: --bug 5513610
8812: /*DELETE FROM EGO_PAGE_ENTRIES_B

Line 8842: FND_MSG_PUB.Add;

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

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

8839: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8840: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8841: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8842: FND_MSG_PUB.Add;
8843: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8844: ,p_count => x_msg_count
8845: ,p_data => x_msg_data);
8846:
8847: END Update_Association;

Line 8919: FND_MSG_PUB.Add;

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

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

8916: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
8917: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
8918: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
8919: FND_MSG_PUB.Add;
8920: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
8921: ,p_count => x_msg_count
8922: ,p_data => x_msg_data);
8923: END IF;
8924:

Line 9010: FND_MSG_PUB.Add;

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

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

9007: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9008: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9009: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9010: FND_MSG_PUB.Add;
9011: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9012: ,p_count => x_msg_count
9013: ,p_data => x_msg_data);
9014: END IF;
9015:

Line 9082: FND_MSG_PUB.Initialize;

9078: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9079: END IF;
9080: -- Initialize message list even though we don't currently use it
9081: IF FND_API.To_Boolean(p_init_msg_list) THEN
9082: FND_MSG_PUB.Initialize;
9083: END IF;
9084:
9085: --if p_force is true, skip all deletion checks
9086: IF( p_force = fnd_api.g_TRUE ) THEN

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

9174: EXCEPTION
9175: WHEN OTHERS THEN
9176: code_debug(l_api_name||' EXCEPTION from check '||x_msg_data);
9177:
9178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9179: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9180: END IF;
9181: l_is_ok_to_delete := FALSE;
9182: END;

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

9175: WHEN OTHERS THEN
9176: code_debug(l_api_name||' EXCEPTION from check '||x_msg_data);
9177:
9178: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9179: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
9180: END IF;
9181: l_is_ok_to_delete := FALSE;
9182: END;
9183: ELSE

Line 9234: FND_MSG_PUB.Add;

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

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

9231: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9232: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9233: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9234: FND_MSG_PUB.Add;
9235: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9236: ,p_count => x_msg_count
9237: ,p_data => x_msg_data);
9238:
9239: END Delete_Association;

Line 9293: FND_MSG_PUB.Initialize;

9289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9290: END IF;
9291: -- Initialize message list even though we don't currently use it
9292: IF FND_API.To_Boolean(p_init_msg_list) THEN
9293: FND_MSG_PUB.Initialize;
9294: END IF;
9295:
9296: --if page id is not provided, get page id from sequence
9297: IF( p_page_id IS NULL ) THEN

Line 9377: FND_MSG_PUB.Add;

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

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

9374: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9375: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9376: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9377: FND_MSG_PUB.Add;
9378: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9379: ,p_count => x_msg_count
9380: ,p_data => x_msg_data);
9381:
9382: END Create_Page;

Line 9426: FND_MSG_PUB.Initialize;

9422: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9423: END IF;
9424: -- Initialize message list even though we don't currently use it
9425: IF FND_API.To_Boolean(p_init_msg_list) THEN
9426: FND_MSG_PUB.Initialize;
9427: END IF;
9428:
9429: IF (FND_API.To_Boolean(p_is_nls_mode)) THEN
9430:

Line 9479: FND_MSG_PUB.Add;

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

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

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

Line 9567: FND_MSG_PUB.Add;

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

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

9564: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9565: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9566: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9567: FND_MSG_PUB.Add;
9568: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9569: ,p_count => x_msg_count
9570: ,p_data => x_msg_data);
9571:
9572: END IF;

Line 9611: FND_MSG_PUB.Initialize;

9607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9608: END IF;
9609: -- Initialize message list even though we don't currently use it
9610: IF FND_API.To_Boolean(p_init_msg_list) THEN
9611: FND_MSG_PUB.Initialize;
9612: END IF;
9613:
9614: DELETE FROM EGO_PAGE_ENTRIES_B
9615: WHERE PAGE_ID = p_page_id;

Line 9641: FND_MSG_PUB.Add;

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

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

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

Line 9712: FND_MSG_PUB.Add;

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

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

9709: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
9710: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
9711: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
9712: FND_MSG_PUB.Add;
9713: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9714: ,p_count => x_msg_count
9715: ,p_data => x_msg_data);
9716:
9717: END IF;

Line 9820: FND_MSG_PUB.Initialize;

9816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9817: END IF;
9818: -- Initialize message list even though we don't currently use it
9819: IF FND_API.To_Boolean(p_init_msg_list) THEN
9820: FND_MSG_PUB.Initialize;
9821: END IF;
9822:
9823: INSERT INTO EGO_PAGE_ENTRIES_B
9824: (

Line 9882: FND_MSG_PUB.Add;

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

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

9879: FND_MESSAGE.Set_Token('AG_NAME', l_ag_disp_name);
9880: FND_MESSAGE.Set_Token('PAGE_NAME', l_page_disp_name);
9881: FND_MESSAGE.Set_Token('CLASS_MEANING', l_class_meaning);
9882: FND_MSG_PUB.Add;
9883: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
9884: ,p_count => x_msg_count
9885: ,p_data => x_msg_data);
9886: --ego_ef_test_pub.insert_into_ego_err_msgs(x_msg_data);
9887: ------------------------------------------------------------------

Line 9899: FND_MSG_PUB.Add;

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

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

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

Line 9915: FND_MSG_PUB.Add;

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

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

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

Line 9963: FND_MSG_PUB.Initialize;

9959: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9960: END IF;
9961: -- Initialize message list even though we don't currently use it
9962: IF FND_API.To_Boolean(p_init_msg_list) THEN
9963: FND_MSG_PUB.Initialize;
9964: END IF;
9965:
9966: UPDATE EGO_PAGE_ENTRIES_B
9967: SET SEQUENCE = p_sequence,

Line 10009: FND_MSG_PUB.Add;

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

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

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

Line 10026: FND_MSG_PUB.Add;

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

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

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

Line 10042: FND_MSG_PUB.Add;

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

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

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

Line 10087: FND_MSG_PUB.Initialize;

10083: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10084: END IF;
10085: -- Initialize message list even though we don't currently use it
10086: IF FND_API.To_Boolean(p_init_msg_list) THEN
10087: FND_MSG_PUB.Initialize;
10088: END IF;
10089:
10090: --Bug 3871440
10091: DELETE FROM EGO_PAGE_ENTRIES_B

Line 10114: FND_MSG_PUB.Add;

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

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

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

Line 10171: FND_MSG_PUB.Initialize;

10167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10168: END IF;
10169: -- Initialize message list even though we don't currently use it
10170: IF FND_API.To_Boolean(p_init_msg_list) THEN
10171: FND_MSG_PUB.Initialize;
10172: END IF;
10173:
10174: SELECT EGO_FUNCTIONS_S.NEXTVAL INTO x_function_id FROM DUAL;
10175:

Line 10248: FND_MSG_PUB.Add;

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

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

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

Line 10298: FND_MSG_PUB.Initialize;

10294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10295: END IF;
10296: -- Initialize message list even though we don't currently use it
10297: IF FND_API.To_Boolean(p_init_msg_list) THEN
10298: FND_MSG_PUB.Initialize;
10299: END IF;
10300:
10301: UPDATE EGO_FUNCTIONS_B
10302: SET

Line 10343: FND_MSG_PUB.Add;

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

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

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

Line 10390: FND_MSG_PUB.Initialize;

10386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10387: END IF;
10388: -- Initialize message list even though we don't currently use it
10389: IF FND_API.To_Boolean(p_init_msg_list) THEN
10390: FND_MSG_PUB.Initialize;
10391: END IF;
10392:
10393: -- If a Function is in use by any Actions, it cannot be deleted.
10394: -- We check function_id, prompt_function_id and visibility_func_id

Line 10453: FND_MSG_PUB.Add;

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

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

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

Line 10522: FND_MSG_PUB.Initialize;

10518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10519: END IF;
10520: -- Initialize message list even though we don't currently use it
10521: IF FND_API.To_Boolean(p_init_msg_list) THEN
10522: FND_MSG_PUB.Initialize;
10523: END IF;
10524:
10525: SELECT EGO_ACTIONS_S.NEXTVAL INTO x_action_id FROM DUAL;
10526:

Line 10635: FND_MSG_PUB.Add;

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

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

10632: x_return_status := FND_API.G_RET_STS_ERROR;
10633: x_errorcode := 1;
10634: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_SEQ_ERR');
10635: FND_MSG_PUB.Add;
10636: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10637: ,p_count => x_msg_count
10638: ,p_data => x_msg_data);
10639:
10640: WHEN e_dup_action_name_error THEN

Line 10647: FND_MSG_PUB.Add;

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

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

10644: x_return_status := FND_API.G_RET_STS_ERROR;
10645: x_errorcode := 1;
10646: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_CR_ACTN_DUP_NAME_ERR');
10647: FND_MSG_PUB.Add;
10648: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10649: ,p_count => x_msg_count
10650: ,p_data => x_msg_data);
10651:
10652: WHEN OTHERS THEN

Line 10662: FND_MSG_PUB.Add;

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

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

10659: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10660: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10661: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10662: FND_MSG_PUB.Add;
10663: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10664: ,p_count => x_msg_count
10665: ,p_data => x_msg_data);
10666:
10667:

Line 10751: FND_MSG_PUB.Add;

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

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

10748: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
10749: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
10750: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
10751: FND_MSG_PUB.Add;
10752: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10753: ,p_count => x_msg_count
10754: ,p_data => x_msg_data);
10755:
10756: END IF;

Line 10813: FND_MSG_PUB.Initialize;

10809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10810: END IF;
10811: -- Initialize message list even though we don't currently use it
10812: IF FND_API.To_Boolean(p_init_msg_list) THEN
10813: FND_MSG_PUB.Initialize;
10814: END IF;
10815:
10816: -- Disallow changes that duplicate a preexisting action's sequence
10817: -- number or name in the classification/attribute group association.

Line 10918: FND_MSG_PUB.Add;

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

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

10915: x_return_status := FND_API.G_RET_STS_ERROR;
10916: x_errorcode := 1;
10917: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_SEQ_ERR');
10918: FND_MSG_PUB.Add;
10919: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10920: ,p_count => x_msg_count
10921: ,p_data => x_msg_data);
10922:
10923: WHEN e_dup_action_name_error THEN

Line 10930: FND_MSG_PUB.Add;

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

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

10927: x_return_status := FND_API.G_RET_STS_ERROR;
10928: x_errorcode := 1;
10929: FND_MESSAGE.Set_Name('EGO', 'EGO_EF_UP_ACTN_DUP_NAME_ERR');
10930: FND_MSG_PUB.Add;
10931: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
10932: ,p_count => x_msg_count
10933: ,p_data => x_msg_data);
10934:
10935: WHEN OTHERS THEN

Line 10945: FND_MSG_PUB.Add;

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

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

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

Line 10995: FND_MSG_PUB.Initialize;

10991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10992: END IF;
10993: -- Initialize message list even though we don't currently use it
10994: IF FND_API.To_Boolean(p_init_msg_list) THEN
10995: FND_MSG_PUB.Initialize;
10996: END IF;
10997:
10998: -- We get the Function ID before deleting the row so we can
10999: -- delete Mappings for the Function if necessary.

Line 11056: FND_MSG_PUB.Add;

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

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

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

Line 11104: FND_MSG_PUB.Initialize;

11100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11101: END IF;
11102: -- Initialize message list even though we don't currently use it
11103: IF FND_API.To_Boolean(p_init_msg_list) THEN
11104: FND_MSG_PUB.Initialize;
11105: END IF;
11106:
11107: INSERT INTO EGO_ACTIONS_DL
11108: (

Line 11148: FND_MSG_PUB.Add;

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

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

11145: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
11146: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
11147: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
11148: FND_MSG_PUB.Add;
11149: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
11150: ,p_count => x_msg_count
11151: ,p_data => x_msg_data);
11152: END Create_Action_Data_Level;
11153:

Line 11198: FND_MSG_PUB.Initialize;

11194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11195: END IF;
11196: -- Initialize message list even though we don't currently use it
11197: IF FND_API.To_Boolean(p_init_msg_list) THEN
11198: FND_MSG_PUB.Initialize;
11199: END IF;
11200:
11201: INSERT INTO EGO_ACTION_DISPLAYS_B
11202: (

Line 11252: FND_MSG_PUB.Add;

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

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

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

Line 11299: FND_MSG_PUB.Initialize;

11295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11296: END IF;
11297: -- Initialize message list even though we don't currently use it
11298: IF FND_API.To_Boolean(p_init_msg_list) THEN
11299: FND_MSG_PUB.Initialize;
11300: END IF;
11301:
11302: INSERT INTO EGO_ACTION_DISPLAYS_B
11303: (

Line 11343: FND_MSG_PUB.Add;

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

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

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

Line 11401: FND_MSG_PUB.Initialize;

11397: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11398: END IF;
11399: -- Initialize message list even though we don't currently use it
11400: IF FND_API.To_Boolean(p_init_msg_list) THEN
11401: FND_MSG_PUB.Initialize;
11402: END IF;
11403:
11404: -- Just in case caller is updating an Action that doesn't yet have a Display...
11405:

Line 11514: FND_MSG_PUB.Add;

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

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

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

Line 11567: FND_MSG_PUB.Initialize;

11563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11564: END IF;
11565: -- Initialize message list even though we don't currently use it
11566: IF FND_API.To_Boolean(p_init_msg_list) THEN
11567: FND_MSG_PUB.Initialize;
11568: END IF;
11569:
11570: SELECT COUNT(*)
11571: INTO l_disp_check_count

Line 11674: FND_MSG_PUB.Add;

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

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

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

Line 11723: FND_MSG_PUB.Initialize;

11719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11720: END IF;
11721: -- Initialize message list even though we don't currently use it
11722: IF FND_API.To_Boolean(p_init_msg_list) THEN
11723: FND_MSG_PUB.Initialize;
11724: END IF;
11725:
11726: -- We get the prompt and vis function IDs before we delete the row
11727: -- so we can also delete their function mappings, if necessary

Line 11793: FND_MSG_PUB.Add;

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

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

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

Line 11850: FND_MSG_PUB.Initialize;

11846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11847: END IF;
11848: -- Initialize message list even though we don't currently use it
11849: IF FND_API.To_Boolean(p_init_msg_list) THEN
11850: FND_MSG_PUB.Initialize;
11851: END IF;
11852:
11853: SELECT EGO_FUNC_PARAMS_S.NEXTVAL INTO x_function_param_id FROM DUAL;
11854:

Line 11927: FND_MSG_PUB.Add;

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

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

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

Line 11975: FND_MSG_PUB.Initialize;

11971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11972: END IF;
11973: -- Initialize message list even though we don't currently use it
11974: IF FND_API.To_Boolean(p_init_msg_list) THEN
11975: FND_MSG_PUB.Initialize;
11976: END IF;
11977:
11978: UPDATE EGO_FUNC_PARAMS_B
11979: SET

Line 12018: FND_MSG_PUB.Add;

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

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

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

Line 12063: FND_MSG_PUB.Initialize;

12059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12060: END IF;
12061: -- Initialize message list even though we don't currently use it
12062: IF FND_API.To_Boolean(p_init_msg_list) THEN
12063: FND_MSG_PUB.Initialize;
12064: END IF;
12065:
12066: DELETE FROM EGO_FUNC_PARAMS_B
12067: WHERE

Line 12096: FND_MSG_PUB.Add;

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

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

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

Line 12158: FND_MSG_PUB.Initialize;

12154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12155: END IF;
12156: -- Initialize message list even though we don't currently use it
12157: IF FND_API.To_Boolean(p_init_msg_list) THEN
12158: FND_MSG_PUB.Initialize;
12159: END IF;
12160:
12161: INSERT INTO EGO_MAPPINGS_B
12162: (

Line 12220: FND_MSG_PUB.Add;

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

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

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

Line 12310: FND_MSG_PUB.Add;

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

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

12307: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12308: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12309: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12310: FND_MSG_PUB.Add;
12311: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12312: ,p_count => x_msg_count
12313: ,p_data => x_msg_data);
12314:
12315: END IF;

Line 12372: FND_MSG_PUB.Initialize;

12368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12369: END IF;
12370: -- Initialize message list even though we don't currently use it
12371: IF FND_API.To_Boolean(p_init_msg_list) THEN
12372: FND_MSG_PUB.Initialize;
12373: END IF;
12374:
12375: IF (p_new_mapping_group_pk1 IS NOT NULL AND
12376: p_new_mapping_group_pk2 IS NOT NULL AND

Line 12446: FND_MSG_PUB.Add;

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

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

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

Line 12548: FND_MSG_PUB.Add;

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

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

12545: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
12546: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
12547: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
12548: FND_MSG_PUB.Add;
12549: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
12550: ,p_count => x_msg_count
12551: ,p_data => x_msg_data);
12552:
12553: END IF;

Line 12595: FND_MSG_PUB.Initialize;

12591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12592: END IF;
12593: -- Initialize message list even though we don't currently use it
12594: IF FND_API.To_Boolean(p_init_msg_list) THEN
12595: FND_MSG_PUB.Initialize;
12596: END IF;
12597:
12598: DELETE FROM EGO_MAPPINGS_B
12599: WHERE

Line 12622: FND_MSG_PUB.Add;

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

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

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

Line 12669: FND_MSG_PUB.Initialize;

12665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12666: END IF;
12667: -- Initialize message list even though we don't currently use it
12668: IF FND_API.To_Boolean(p_init_msg_list) THEN
12669: FND_MSG_PUB.Initialize;
12670: END IF;
12671:
12672: DELETE FROM EGO_MAPPINGS_B
12673: WHERE

Line 12697: FND_MSG_PUB.Add;

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

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

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

Line 12754: FND_MSG_PUB.Initialize;

12750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12751: END IF;
12752: -- Initialize message list even though we don't currently use it
12753: IF FND_API.To_Boolean(p_init_msg_list) THEN
12754: FND_MSG_PUB.Initialize;
12755: END IF;
12756:
12757: SELECT EGO_ACTION_GROUPS_S.NEXTVAL INTO x_action_group_id FROM DUAL;
12758:

Line 12832: FND_MSG_PUB.Add;

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

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

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

Line 12881: FND_MSG_PUB.Initialize;

12877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12878: END IF;
12879: -- Initialize message list even though we don't currently use it
12880: IF FND_API.To_Boolean(p_init_msg_list) THEN
12881: FND_MSG_PUB.Initialize;
12882: END IF;
12883:
12884: UPDATE EGO_ACTION_GROUPS_B
12885: SET

Line 12926: FND_MSG_PUB.Add;

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

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

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

Line 12969: FND_MSG_PUB.Initialize;

12965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12966: END IF;
12967: -- Initialize message list even though we don't currently use it
12968: IF FND_API.To_Boolean(p_init_msg_list) THEN
12969: FND_MSG_PUB.Initialize;
12970: END IF;
12971:
12972: -- If there are Actions in this Action Group, we delete their entries
12973: -- in the Action_Group_Entries table (but we don't delete the Actions).

Line 13004: FND_MSG_PUB.Add;

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

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

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

Line 13058: FND_MSG_PUB.Initialize;

13054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13055: END IF;
13056: -- Initialize message list even though we don't currently use it
13057: IF FND_API.To_Boolean(p_init_msg_list) THEN
13058: FND_MSG_PUB.Initialize;
13059: END IF;
13060:
13061: SELECT COUNT(ACTION_ID)
13062: INTO l_exist_action_count

Line 13110: FND_MSG_PUB.Add;

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

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

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

Line 13158: FND_MSG_PUB.Initialize;

13154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13155: END IF;
13156: -- Initialize message list even though we don't currently use it
13157: IF FND_API.To_Boolean(p_init_msg_list) THEN
13158: FND_MSG_PUB.Initialize;
13159: END IF;
13160:
13161: UPDATE EGO_ACTN_GRP_ENTRIES_B
13162: SET SEQUENCE = p_sequence

Line 13184: FND_MSG_PUB.Add;

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

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

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

Line 13228: FND_MSG_PUB.Initialize;

13224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
13225: END IF;
13226: -- Initialize message list even though we don't currently use it
13227: IF FND_API.To_Boolean(p_init_msg_list) THEN
13228: FND_MSG_PUB.Initialize;
13229: END IF;
13230:
13231: DELETE FROM EGO_ACTN_GRP_ENTRIES_B
13232: WHERE

Line 13254: FND_MSG_PUB.Add;

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

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

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

Line 13798: FND_MSG_PUB.initialize;

13794:
13795: -- Initialize API message list if necessary.
13796: -- Initialize message list if p_init_msg_list is set to TRUE.
13797: IF FND_API.to_Boolean( P_INIT_MSG_LIST ) THEN
13798: FND_MSG_PUB.initialize;
13799: END IF;
13800:
13801: -- Check If the view name is already present
13802: l_agv_name := UPPER(p_agv_name);

Line 13811: FND_MSG_PUB.add;

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

Line 13823: FND_MSG_PUB.add;

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

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

13866: END IF;
13867: IF c_check_obj_name%ISOPEN THEN
13868: CLOSE c_check_obj_name;
13869: END IF;
13870: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13871: ,p_count => x_msg_count
13872: ,p_data => x_msg_data);
13873: x_return_status := FND_API.G_RET_STS_ERROR;
13874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

13874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
13875: IF FND_API.To_Boolean( p_commit ) THEN
13876: ROLLBACK TO Update_AGV_Name;
13877: END IF;
13878: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13879: ,p_count => x_msg_count
13880: ,p_data => x_msg_data);
13881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13882: WHEN OTHERS THEN

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

13888: END IF;
13889: IF c_check_obj_name%ISOPEN THEN
13890: CLOSE c_check_obj_name;
13891: END IF;
13892: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE
13893: ,p_count => x_msg_count
13894: ,p_data => x_msg_data);
13895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
13896:

Line 13931: FND_MSG_PUB.initialize;

13927:
13928: -- Initialize API message list if necessary.
13929: -- Initialize message list if p_init_msg_list is set to TRUE.
13930: IF FND_API.to_Boolean( P_INIT_MSG_LIST ) THEN
13931: FND_MSG_PUB.initialize;
13932: END IF;
13933:
13934: -------------------------------------------------------------------------------------
13935: -- Make sure that the control level corresponds with either Master Level or Org Level

Line 13996: FND_MSG_PUB.Add;

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

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

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

Line 14005: FND_MSG_PUB.Add;

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

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

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

Line 14019: FND_MSG_PUB.Add;

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

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

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