DBA Data[Home] [Help]

APPS.IEM_TEMP_STORES_PVT dependencies on FND_API

Line 37: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

33: l_message_id number;
34:
35: BEGIN
36: -- Standard call to check for call compatibility.
37: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
38: p_api_version_number,
39: l_api_name,
40: G_PKG_NAME)
41: THEN

Line 42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

38: p_api_version_number,
39: l_api_name,
40: G_PKG_NAME)
41: THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45: /*
46: INSERT INTO iem_temp_stores (

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

40: G_PKG_NAME)
41: THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45: /*
46: INSERT INTO iem_temp_stores (
47: MESSAGE_ID ,
48: email_account_id ,

Line 94: WHEN FND_API.G_EXC_ERROR THEN

90: ( p_count => x_msg_count,
91: p_data => x_msg_data
92: );
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: x_return_status := FND_API.G_RET_STS_ERROR ;
96: FND_MSG_PUB.Count_And_Get
97: ( p_count => x_msg_count,
98: p_data => x_msg_data

Line 95: x_return_status := FND_API.G_RET_STS_ERROR ;

91: p_data => x_msg_data
92: );
93: EXCEPTION
94: WHEN FND_API.G_EXC_ERROR THEN
95: x_return_status := FND_API.G_RET_STS_ERROR ;
96: FND_MSG_PUB.Count_And_Get
97: ( p_count => x_msg_count,
98: p_data => x_msg_data
99: );

Line 100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

96: FND_MSG_PUB.Count_And_Get
97: ( p_count => x_msg_count,
98: p_data => x_msg_data
99: );
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: FND_MSG_PUB.Count_And_Get
103: ( p_count => x_msg_count,
104: p_data => x_msg_data

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

97: ( p_count => x_msg_count,
98: p_data => x_msg_data
99: );
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: FND_MSG_PUB.Count_And_Get
103: ( p_count => x_msg_count,
104: p_data => x_msg_data
105: );

Line 107: x_return_status := FND_API.G_RET_STS_ERROR;

103: ( p_count => x_msg_count,
104: p_data => x_msg_data
105: );
106: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_ERROR;
108: IF FND_MSG_PUB.Check_Msg_Level
109: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
110: THEN
111: FND_MSG_PUB.Add_Exc_Msg

Line 138: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

134: BEGIN
135: null;
136: /*
137: -- Standard call to check for call compatibility.
138: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
139: p_api_version_number,
140: l_api_name,
141: G_PKG_NAME)
142: THEN

Line 143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

139: p_api_version_number,
140: l_api_name,
141: G_PKG_NAME)
142: THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146: delete from iem_temp_stores
147: where message_id=p_message_id;

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

141: G_PKG_NAME)
142: THEN
143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
144: END IF;
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146: delete from iem_temp_stores
147: where message_id=p_message_id;
148:
149: -- Standard Check Of p_commit.

Line 159: WHEN FND_API.G_EXC_ERROR THEN

155: ( p_count => x_msg_count,
156: p_data => x_msg_data
157: );
158: EXCEPTION
159: WHEN FND_API.G_EXC_ERROR THEN
160: ROLLBACK TO delete_item_PVT;
161: x_return_status := FND_API.G_RET_STS_ERROR ;
162: FND_MSG_PUB.Count_And_Get
163: ( p_count => x_msg_count,

Line 161: x_return_status := FND_API.G_RET_STS_ERROR ;

157: );
158: EXCEPTION
159: WHEN FND_API.G_EXC_ERROR THEN
160: ROLLBACK TO delete_item_PVT;
161: x_return_status := FND_API.G_RET_STS_ERROR ;
162: FND_MSG_PUB.Count_And_Get
163: ( p_count => x_msg_count,
164: p_data => x_msg_data
165: );

Line 166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

162: FND_MSG_PUB.Count_And_Get
163: ( p_count => x_msg_count,
164: p_data => x_msg_data
165: );
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO delete_item_PVT;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
169: FND_MSG_PUB.Count_And_Get
170: ( p_count => x_msg_count,

Line 168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

164: p_data => x_msg_data
165: );
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: ROLLBACK TO delete_item_PVT;
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
169: FND_MSG_PUB.Count_And_Get
170: ( p_count => x_msg_count,
171: p_data => x_msg_data
172: );

Line 175: x_return_status := FND_API.G_RET_STS_ERROR;

171: p_data => x_msg_data
172: );
173: WHEN OTHERS THEN
174: ROLLBACK TO delete_item_PVT;
175: x_return_status := FND_API.G_RET_STS_ERROR;
176: IF FND_MSG_PUB.Check_Msg_Level
177: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
178: THEN
179: FND_MSG_PUB.Add_Exc_Msg