33: END IF;
34:
35: -- Initialize message list if p_init_msg_list is set to TRUE.
36: IF FND_API.to_Boolean( p_init_msg_list ) THEN
37: FND_MSG_PUB.initialize;
38: END IF;
39:
40: -- Initialize API return status to success
41: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: x_failureset_id := l_failure_set_id;
58:
59: -- call to get message count and if count is 1, get message info.
60: FND_MSG_PUB.Count_And_Get
61: (p_count => x_msg_count,
62: p_data => x_msg_data
63: );
64: EXCEPTION
65:
66: WHEN OTHERS THEN
67: ROLLBACK TO Create_FailureSet_PUB;
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
69: IF FND_MSG_PUB.Check_Msg_Level
70: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
71: THEN
72: FND_MSG_PUB.Add_Exc_Msg
73: (G_PKG_NAME,
66: WHEN OTHERS THEN
67: ROLLBACK TO Create_FailureSet_PUB;
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
69: IF FND_MSG_PUB.Check_Msg_Level
70: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
71: THEN
72: FND_MSG_PUB.Add_Exc_Msg
73: (G_PKG_NAME,
74: l_api_name
68: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
69: IF FND_MSG_PUB.Check_Msg_Level
70: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
71: THEN
72: FND_MSG_PUB.Add_Exc_Msg
73: (G_PKG_NAME,
74: l_api_name
75: );
76: END IF;
73: (G_PKG_NAME,
74: l_api_name
75: );
76: END IF;
77: FND_MSG_PUB.Count_And_Get
78: (p_count => x_msg_count,
79: p_data => x_msg_data
80: );
81: END Create_FailureSet;
111: END IF;
112:
113: -- Initialize message list if p_init_msg_list is set to TRUE.
114: IF FND_API.to_Boolean( p_init_msg_list ) THEN
115: FND_MSG_PUB.initialize;
116: END IF;
117:
118: -- Initialize API return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:
135: x_failureset_id := l_failure_set_id;
136:
137: -- call to get message count and if count is 1, get message info.
138: FND_MSG_PUB.Count_And_Get
139: (p_count => x_msg_count,
140: p_data => x_msg_data
141: );
142: EXCEPTION
142: EXCEPTION
143: WHEN OTHERS THEN
144: ROLLBACK TO Update_FailureSet_PUB;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: IF FND_MSG_PUB.Check_Msg_Level
147: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg
150: (G_PKG_NAME,
143: WHEN OTHERS THEN
144: ROLLBACK TO Update_FailureSet_PUB;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: IF FND_MSG_PUB.Check_Msg_Level
147: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg
150: (G_PKG_NAME,
151: l_api_name
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
146: IF FND_MSG_PUB.Check_Msg_Level
147: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
148: THEN
149: FND_MSG_PUB.Add_Exc_Msg
150: (G_PKG_NAME,
151: l_api_name
152: );
153: END IF;
150: (G_PKG_NAME,
151: l_api_name
152: );
153: END IF;
154: FND_MSG_PUB.Count_And_Get
155: (p_count => x_msg_count,
156: p_data => x_msg_data
157: );
158: END Update_FailureSet;
185: END IF;
186:
187: -- Initialize message list if p_init_msg_list is set to TRUE.
188: IF FND_API.to_Boolean( p_init_msg_list ) THEN
189: FND_MSG_PUB.initialize;
190: END IF;
191:
192: -- Initialize API return status to success
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
205: x_msg_data
206: );
207:
208: -- call to get message count and if count is 1, get message info.
209: FND_MSG_PUB.Count_And_Get
210: (p_count => x_msg_count,
211: p_data => x_msg_data
212: );
213: EXCEPTION
213: EXCEPTION
214: WHEN OTHERS THEN
215: ROLLBACK TO Create_Association_PUB;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
217: IF FND_MSG_PUB.Check_Msg_Level
218: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg
221: (G_PKG_NAME,
214: WHEN OTHERS THEN
215: ROLLBACK TO Create_Association_PUB;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
217: IF FND_MSG_PUB.Check_Msg_Level
218: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg
221: (G_PKG_NAME,
222: l_api_name
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
217: IF FND_MSG_PUB.Check_Msg_Level
218: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
219: THEN
220: FND_MSG_PUB.Add_Exc_Msg
221: (G_PKG_NAME,
222: l_api_name
223: );
224: END IF;
221: (G_PKG_NAME,
222: l_api_name
223: );
224: END IF;
225: FND_MSG_PUB.Count_And_Get
226: (p_count => x_msg_count,
227: p_data => x_msg_data
228: );
229: END Create_Association;
256: END IF;
257:
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list ) THEN
260: FND_MSG_PUB.initialize;
261: END IF;
262:
263: -- Initialize API return status to success
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
276: x_msg_data
277: );
278:
279: -- call to get message count and if count is 1, get message info.
280: FND_MSG_PUB.Count_And_Get
281: (p_count => x_msg_count,
282: p_data => x_msg_data
283: );
284: EXCEPTION
284: EXCEPTION
285: WHEN OTHERS THEN
286: ROLLBACK TO Update_Association_PUB;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: IF FND_MSG_PUB.Check_Msg_Level
289: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg
292: (G_PKG_NAME,
285: WHEN OTHERS THEN
286: ROLLBACK TO Update_Association_PUB;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: IF FND_MSG_PUB.Check_Msg_Level
289: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg
292: (G_PKG_NAME,
293: l_api_name
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: IF FND_MSG_PUB.Check_Msg_Level
289: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
290: THEN
291: FND_MSG_PUB.Add_Exc_Msg
292: (G_PKG_NAME,
293: l_api_name
294: );
295: END IF;
292: (G_PKG_NAME,
293: l_api_name
294: );
295: END IF;
296: FND_MSG_PUB.Count_And_Get
297: (p_count => x_msg_count,
298: p_data => x_msg_data
299: );
300: END Update_Association;
327: END IF;
328:
329: -- Initialize message list if p_init_msg_list is set to TRUE.
330: IF FND_API.to_Boolean( p_init_msg_list ) THEN
331: FND_MSG_PUB.initialize;
332: END IF;
333:
334: -- Initialize API return status to success
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
347: x_msg_data
348: );
349:
350: -- call to get message count and if count is 1, get message info.
351: FND_MSG_PUB.Count_And_Get
352: (p_count => x_msg_count,
353: p_data => x_msg_data
354: );
355: EXCEPTION
355: EXCEPTION
356: WHEN OTHERS THEN
357: ROLLBACK TO Delete_Association_PUB;
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: IF FND_MSG_PUB.Check_Msg_Level
360: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
361: THEN
362: FND_MSG_PUB.Add_Exc_Msg
363: (G_PKG_NAME,
356: WHEN OTHERS THEN
357: ROLLBACK TO Delete_Association_PUB;
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: IF FND_MSG_PUB.Check_Msg_Level
360: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
361: THEN
362: FND_MSG_PUB.Add_Exc_Msg
363: (G_PKG_NAME,
364: l_api_name
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: IF FND_MSG_PUB.Check_Msg_Level
360: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
361: THEN
362: FND_MSG_PUB.Add_Exc_Msg
363: (G_PKG_NAME,
364: l_api_name
365: );
366: END IF;
363: (G_PKG_NAME,
364: l_api_name
365: );
366: END IF;
367: FND_MSG_PUB.Count_And_Get
368: (p_count => x_msg_count,
369: p_data => x_msg_data
370: );
371: END Delete_Association;