DBA Data[Home] [Help]

APPS.IEM_EMAIL_SERVERS_PVT dependencies on FND_MESSAGE

Line 89: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_TYPE');

85: Select count(*) into l_type_cnt from iem_email_server_types
86: where email_server_type_id=p_server_type_id
87: and rownum=1;
88: IF l_type_cnt=0 THEN
89: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_TYPE');
90: APP_EXCEPTION.RAISE_EXCEPTION;
91: END IF;
92:
93: /*Check For Existing Server Group Id */

Line 99: --FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');

95: Select count(*) into l_grp_cnt from iem_server_groups
96: where server_group_id=p_server_group_id
97: and rownum=1;
98: IF l_grp_cnt = 0 then
99: --FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');
100: --APP_EXCEPTION.RAISE_EXCEPTION;
101: raise IEM_NON_EXISTENT_SERVER_GRP;
102: END IF;
103: -- raise_application_error(-20002,'Server Group Id ||to_char(p_server_group_id)||' Does not Exist');

Line 180: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');

176: EXCEPTION
177:
178: -- WHEN IEM_DUP_EMAIL_SERVER THEN
179: -- ROLLBACK TO create_item_PVT;
180: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');
181: -- FND_MSG_PUB.Add;
182: -- x_return_status := FND_API.G_RET_STS_ERROR ;
183: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
184:

Line 187: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');

183: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
184:
185: WHEN IEM_NON_EXISTENT_SERVER_GRP THEN
186: ROLLBACK TO create_item_PVT;
187: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');
188: FND_MSG_PUB.Add;
189: x_return_status := FND_API.G_RET_STS_ERROR ;
190: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
191:

Line 194: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_GRP_DUP_RECORD');

190: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
191:
192: WHEN DUP_VAL_ON_INDEX THEN
193: ROLLBACK TO create_item_PVT;
194: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_GRP_DUP_RECORD');
195: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');
196: FND_MSG_PUB.Add;
197: x_return_status := FND_API.G_RET_STS_ERROR ;
198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 195: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');

191:
192: WHEN DUP_VAL_ON_INDEX THEN
193: ROLLBACK TO create_item_PVT;
194: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_GRP_DUP_RECORD');
195: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');
196: FND_MSG_PUB.Add;
197: x_return_status := FND_API.G_RET_STS_ERROR ;
198: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
199:

Line 362: -- FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_EMAIL_SVR_NOT_CREATED');

358:
359: WHEN EXCP_EMAIL_SERVER THEN
360: ROLLBACK TO create_item_PVT;
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: -- FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_EMAIL_SVR_NOT_CREATED');
363: -- FND_MSG_PUB.Add;
364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,p_data => x_msg_data);
365:
366: WHEN FND_API.G_EXC_ERROR THEN

Line 558: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_TYPE');

554: Select count(*) into l_type_cnt from iem_email_server_types
555: where email_server_type_id=p_server_type_id
556: and rownum=1;
557: IF l_type_cnt=0 THEN
558: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_TYPE');
559: APP_EXCEPTION.RAISE_EXCEPTION;
560: END IF;
561: end if;
562:

Line 570: --FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');

566: where server_group_id=p_server_group_id
567: and rownum=1;
568: IF l_grp_cnt = 0 then
569: raise IEM_NON_EXISTENT_SERVER_GRP;
570: --FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');
571: --APP_EXCEPTION.RAISE_EXCEPTION;
572: END IF;
573: end if;
574:

Line 644: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');

640: EXCEPTION
641:
642: -- WHEN IEM_DUP_EMAIL_SERVER THEN
643: -- ROLLBACK TO update_item_pvt;
644: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');
645: -- FND_MSG_PUB.Add;
646: -- x_return_status := FND_API.G_RET_STS_ERROR ;
647: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
648: WHEN IEM_NON_EXISTENT_SERVER_GRP THEN

Line 650: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');

646: -- x_return_status := FND_API.G_RET_STS_ERROR ;
647: -- FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
648: WHEN IEM_NON_EXISTENT_SERVER_GRP THEN
649: ROLLBACK TO update_item_pvt;
650: FND_MESSAGE.SET_NAME('IEM','IEM_NON_EXISTENT_SERVER_GRP');
651: FND_MSG_PUB.Add;
652: x_return_status := FND_API.G_RET_STS_ERROR ;
653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
654:

Line 657: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_GRP_DUP_RECORD');

653: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
654:
655: WHEN DUP_VAL_ON_INDEX THEN
656: ROLLBACK TO update_item_pvt;
657: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_GRP_DUP_RECORD');
658: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');
659: FND_MSG_PUB.Add;
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 658: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');

654:
655: WHEN DUP_VAL_ON_INDEX THEN
656: ROLLBACK TO update_item_pvt;
657: -- FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_GRP_DUP_RECORD');
658: FND_MESSAGE.SET_NAME('IEM','IEM_ADMIN_DUP_EMAIL_SERVER');
659: FND_MSG_PUB.Add;
660: x_return_status := FND_API.G_RET_STS_ERROR ;
661: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
662:

Line 826: -- FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_EMAIL_SVR_NOT_CREATED');

822:
823: WHEN EXCP_EMAIL_SERVER THEN
824: ROLLBACK TO create_item_PVT;
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: -- FND_MESSAGE.SET_NAME('IEM', 'IEM_SSS_EMAIL_SVR_NOT_CREATED');
827: -- FND_MSG_PUB.Add;
828: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,p_data => x_msg_data);
829:
830: WHEN FND_API.G_EXC_ERROR THEN

Line 941: FND_MESSAGE.SET_NAME('IEM', 'IEM_SERVER_GROUP_NOT_DELETED');

937: EXCEPTION
938: WHEN SERVER_GROUP_NOT_DELETED THEN
939: ROLLBACK TO delete_item_batch;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: FND_MESSAGE.SET_NAME('IEM', 'IEM_SERVER_GROUP_NOT_DELETED');
942: FND_MSG_PUB.ADD;
943: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
944:
945: WHEN FND_API.G_EXC_ERROR THEN