DBA Data[Home] [Help]

APPS.IEM_RT_PREPROC_EMAILS_PVT dependencies on FND_API

Line 30: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

26: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
27:
28: BEGIN
29: -- Standard call to check for call compatibility.
30: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
31: p_api_version_number,
32: l_api_name,
33: G_PKG_NAME)
34: THEN

Line 35: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

31: p_api_version_number,
32: l_api_name,
33: G_PKG_NAME)
34: THEN
35: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
36: END IF;
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38: INSERT INTO IEM_RT_PREPROC_EMAILS (
39: MESSAGE_ID ,

Line 37: x_return_status := FND_API.G_RET_STS_SUCCESS;

33: G_PKG_NAME)
34: THEN
35: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
36: END IF;
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38: INSERT INTO IEM_RT_PREPROC_EMAILS (
39: MESSAGE_ID ,
40: email_account_id ,
41: PRIORITY ,

Line 72: WHEN FND_API.G_EXC_ERROR THEN

68: ( p_count => x_msg_count,
69: p_data => x_msg_data
70: );
71: EXCEPTION
72: WHEN FND_API.G_EXC_ERROR THEN
73: x_return_status := FND_API.G_RET_STS_ERROR ;
74: FND_MSG_PUB.Count_And_Get
75: ( p_count => x_msg_count,
76: p_data => x_msg_data

Line 73: x_return_status := FND_API.G_RET_STS_ERROR ;

69: p_data => x_msg_data
70: );
71: EXCEPTION
72: WHEN FND_API.G_EXC_ERROR THEN
73: x_return_status := FND_API.G_RET_STS_ERROR ;
74: FND_MSG_PUB.Count_And_Get
75: ( p_count => x_msg_count,
76: p_data => x_msg_data
77: );

Line 78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

74: FND_MSG_PUB.Count_And_Get
75: ( p_count => x_msg_count,
76: p_data => x_msg_data
77: );
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
80: FND_MSG_PUB.Count_And_Get
81: ( p_count => x_msg_count,
82: p_data => x_msg_data

Line 79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

75: ( p_count => x_msg_count,
76: p_data => x_msg_data
77: );
78: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
80: FND_MSG_PUB.Count_And_Get
81: ( p_count => x_msg_count,
82: p_data => x_msg_data
83: );

Line 85: x_return_status := FND_API.G_RET_STS_ERROR;

81: ( p_count => x_msg_count,
82: p_data => x_msg_data
83: );
84: WHEN OTHERS THEN
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: IF FND_MSG_PUB.Check_Msg_Level
87: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
88: THEN
89: FND_MSG_PUB.Add_Exc_Msg

Line 114: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

110: l_api_version_number NUMBER:=1.0;
111:
112: BEGIN
113: -- Standard call to check for call compatibility.
114: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
115: p_api_version_number,
116: l_api_name,
117: G_PKG_NAME)
118: THEN

Line 119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

115: p_api_version_number,
116: l_api_name,
117: G_PKG_NAME)
118: THEN
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: END IF;
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: delete from IEM_RT_PREPROC_EMAILS
123: where message_id=p_message_id;

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: G_PKG_NAME)
118: THEN
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: END IF;
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: delete from IEM_RT_PREPROC_EMAILS
123: where message_id=p_message_id;
124:
125: -- Standard Check Of p_commit.

Line 135: WHEN FND_API.G_EXC_ERROR THEN

131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: ROLLBACK TO delete_item_PVT;
137: x_return_status := FND_API.G_RET_STS_ERROR ;
138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,

Line 137: x_return_status := FND_API.G_RET_STS_ERROR ;

133: );
134: EXCEPTION
135: WHEN FND_API.G_EXC_ERROR THEN
136: ROLLBACK TO delete_item_PVT;
137: x_return_status := FND_API.G_RET_STS_ERROR ;
138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,
140: p_data => x_msg_data
141: );

Line 142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,
140: p_data => x_msg_data
141: );
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: ROLLBACK TO delete_item_PVT;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
145: FND_MSG_PUB.Count_And_Get
146: ( p_count => x_msg_count,

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

140: p_data => x_msg_data
141: );
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: ROLLBACK TO delete_item_PVT;
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
145: FND_MSG_PUB.Count_And_Get
146: ( p_count => x_msg_count,
147: p_data => x_msg_data
148: );

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: p_data => x_msg_data
148: );
149: WHEN OTHERS THEN
150: ROLLBACK TO delete_item_PVT;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: IF FND_MSG_PUB.Check_Msg_Level
153: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
154: THEN
155: FND_MSG_PUB.Add_Exc_Msg