40:
41:
42: -- Initialize message list if p_init_msg_list is set to TRUE.
43: IF FND_API.To_Boolean( p_init_msg_list ) THEN
44: FND_MSG_PUB.Initialize;
45: END IF;
46:
47: -- Initialize API return status to success
48: x_return_status := FND_API.G_RET_STS_SUCCESS;
114: END IF;
115: ****/
116:
117: -- Standard call to get message count and if count is get message info.
118: FND_MSG_PUB.Count_And_Get(
119: p_count => x_msg_count,
120: p_data => x_msg_data);
121:
122: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Org Assignments');
128: WHEN FND_API.G_EXC_ERROR THEN
129:
130: ROLLBACK TO create_txn_org_assgn_dtls;
131: x_return_status := FND_API.G_RET_STS_ERROR ;
132: FND_MSG_PUB.Count_And_Get (
133: p_count => x_msg_count,
134: p_data => x_msg_data);
135:
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137:
138: ROLLBACK TO create_txn_org_assgn_dtls;
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
140:
141: FND_MSG_PUB.Count_And_Get(
142: p_count => x_msg_count,
143: p_data => x_msg_data);
144:
145: WHEN OTHERS THEN
146:
147: ROLLBACK TO create_txn_org_assgn_dtls;
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
149:
150: IF FND_MSG_PUB.Check_Msg_Level(
151: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
152:
153: FND_MSG_PUB.Add_Exc_Msg(
154: p_pkg_name => G_PKG_NAME,
147: ROLLBACK TO create_txn_org_assgn_dtls;
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
149:
150: IF FND_MSG_PUB.Check_Msg_Level(
151: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
152:
153: FND_MSG_PUB.Add_Exc_Msg(
154: p_pkg_name => G_PKG_NAME,
155: p_procedure_name => l_api_name);
149:
150: IF FND_MSG_PUB.Check_Msg_Level(
151: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
152:
153: FND_MSG_PUB.Add_Exc_Msg(
154: p_pkg_name => G_PKG_NAME,
155: p_procedure_name => l_api_name);
156:
157: END IF;
155: p_procedure_name => l_api_name);
156:
157: END IF;
158:
159: FND_MSG_PUB.Count_And_Get(
160: p_count => x_msg_count,
161: p_data => x_msg_data);
162:
163: END create_txn_org_assgn_dtls;
195:
196:
197: -- Initialize message list if p_init_msg_list is set to TRUE.
198: IF FND_API.to_Boolean( p_init_msg_list ) THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: -- Initialize API return status to success
203: x_return_status := FND_API.G_RET_STS_SUCCESS;
257: END IF;
258: ****/
259:
260: -- Standard call to get message count and if count is get message info.
261: FND_MSG_PUB.Count_And_Get(
262: p_count => x_msg_count,
263: p_data => x_msg_data);
264:
265: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Org Assignments');
271: WHEN FND_API.G_EXC_ERROR THEN
272:
273: ROLLBACK TO Update_Txn_Org_Assgn_Dtls;
274: x_return_status := FND_API.G_RET_STS_ERROR ;
275: FND_MSG_PUB.Count_And_Get (
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280:
281: ROLLBACK TO Update_Txn_Org_Assgn_Dtls;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283:
284: FND_MSG_PUB.Count_And_Get(
285: p_count => x_msg_count,
286: p_data => x_msg_data);
287:
288: WHEN OTHERS THEN
289:
290: ROLLBACK TO Update_Txn_Org_Assgn_Dtls;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
292:
293: IF FND_MSG_PUB.Check_Msg_Level(
294: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
295:
296: FND_MSG_PUB.Add_Exc_Msg(
297: p_pkg_name => G_PKG_NAME,
290: ROLLBACK TO Update_Txn_Org_Assgn_Dtls;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
292:
293: IF FND_MSG_PUB.Check_Msg_Level(
294: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
295:
296: FND_MSG_PUB.Add_Exc_Msg(
297: p_pkg_name => G_PKG_NAME,
298: p_procedure_name => l_api_name);
292:
293: IF FND_MSG_PUB.Check_Msg_Level(
294: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
295:
296: FND_MSG_PUB.Add_Exc_Msg(
297: p_pkg_name => G_PKG_NAME,
298: p_procedure_name => l_api_name);
299:
300: END IF;
298: p_procedure_name => l_api_name);
299:
300: END IF;
301:
302: FND_MSG_PUB.Count_And_Get(
303: p_count => x_msg_count,
304: p_data => x_msg_data);
305:
306: END update_txn_org_assgn_dtls;
337:
338:
339: -- Initialize message list if p_init_msg_list is set to TRUE.
340: IF FND_API.to_Boolean( p_init_msg_list ) THEN
341: FND_MSG_PUB.initialize;
342: END IF;
343:
344: -- Initialize API return status to success
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
399: END IF;
400: ****/
401:
402: -- Standard call to get message count and if count is get message info.
403: FND_MSG_PUB.Count_And_Get(
404: p_count => x_msg_count,
405: p_data => x_msg_data);
406:
407: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Org Assignments');
413: WHEN FND_API.G_EXC_ERROR THEN
414:
415: ROLLBACK TO delete_txn_org_assgn_dtls;
416: x_return_status := FND_API.G_RET_STS_ERROR ;
417: FND_MSG_PUB.Count_And_Get (
418: p_count => x_msg_count,
419: p_data => x_msg_data);
420:
421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
422:
423: ROLLBACK TO delete_txn_org_assgn_dtls;
424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
425:
426: FND_MSG_PUB.Count_And_Get(
427: p_count => x_msg_count,
428: p_data => x_msg_data);
429:
430: WHEN OTHERS THEN
431:
432: ROLLBACK TO delete_txn_org_assgn_dtls;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
434:
435: IF FND_MSG_PUB.Check_Msg_Level(
436: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
437:
438: FND_MSG_PUB.Add_Exc_Msg(
439: p_pkg_name => G_PKG_NAME,
432: ROLLBACK TO delete_txn_org_assgn_dtls;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
434:
435: IF FND_MSG_PUB.Check_Msg_Level(
436: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
437:
438: FND_MSG_PUB.Add_Exc_Msg(
439: p_pkg_name => G_PKG_NAME,
440: p_procedure_name => l_api_name);
434:
435: IF FND_MSG_PUB.Check_Msg_Level(
436: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
437:
438: FND_MSG_PUB.Add_Exc_Msg(
439: p_pkg_name => G_PKG_NAME,
440: p_procedure_name => l_api_name);
441:
442: END IF;
440: p_procedure_name => l_api_name);
441:
442: END IF;
443:
444: FND_MSG_PUB.Count_And_Get(
445: p_count => x_msg_count,
446: p_data => x_msg_data);
447:
448: END delete_txn_org_assgn_dtls;