44:
45:
46: -- Initialize message list if p_init_msg_list is set to TRUE.
47: IF FND_API.To_Boolean( p_init_msg_list ) THEN
48: FND_MSG_PUB.Initialize;
49: END IF;
50:
51: -- Initialize API return status to success
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: END IF;
123: ****/
124:
125: -- Standard call to get message count and if count is get message info.
126: FND_MSG_PUB.Count_And_Get(
127: p_count => x_msg_count,
128: p_data => x_msg_data);
129:
130: csi_t_gen_utility_pvt.add('API Successfully Executed : Create Txn Relationships');
136: WHEN FND_API.G_EXC_ERROR THEN
137:
138: ROLLBACK TO create_txn_ii_rltns_dtls;
139: x_return_status := FND_API.G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get (
141: p_count => x_msg_count,
142: p_data => x_msg_data);
143:
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145:
146: ROLLBACK TO create_txn_ii_rltns_dtls;
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
148:
149: FND_MSG_PUB.Count_And_Get(
150: p_count => x_msg_count,
151: p_data => x_msg_data);
152:
153: WHEN OTHERS THEN
154:
155: ROLLBACK TO create_txn_ii_rltns_dtls;
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
157:
158: IF FND_MSG_PUB.Check_Msg_Level(
159: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
160:
161: FND_MSG_PUB.Add_Exc_Msg(
162: p_pkg_name => G_PKG_NAME,
155: ROLLBACK TO create_txn_ii_rltns_dtls;
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
157:
158: IF FND_MSG_PUB.Check_Msg_Level(
159: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
160:
161: FND_MSG_PUB.Add_Exc_Msg(
162: p_pkg_name => G_PKG_NAME,
163: p_procedure_name => l_api_name);
157:
158: IF FND_MSG_PUB.Check_Msg_Level(
159: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
160:
161: FND_MSG_PUB.Add_Exc_Msg(
162: p_pkg_name => G_PKG_NAME,
163: p_procedure_name => l_api_name);
164:
165: END IF;
163: p_procedure_name => l_api_name);
164:
165: END IF;
166:
167: FND_MSG_PUB.Count_And_Get(
168: p_count => x_msg_count,
169: p_data => x_msg_data);
170:
171: END create_txn_ii_rltns_dtls;
203:
204:
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF FND_API.to_Boolean( p_init_msg_list ) THEN
207: FND_MSG_PUB.initialize;
208: END IF;
209:
210: -- Initialize API return status to success
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
264: dbms_session.set_sql_trace(false);
265: END IF;
266: ****/
267: -- Standard call to get message count and if count is get message info.
268: FND_MSG_PUB.Count_And_Get(
269: p_count => x_msg_count,
270: p_data => x_msg_data);
271:
272: csi_t_gen_utility_pvt.add('API Successfully Executed : Update Txn Relationships ');
278: WHEN FND_API.G_EXC_ERROR THEN
279:
280: ROLLBACK TO update_txn_ii_rltns_dtls;
281: x_return_status := FND_API.G_RET_STS_ERROR ;
282: FND_MSG_PUB.Count_And_Get (
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287:
288: ROLLBACK TO update_txn_ii_rltns_dtls;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
290:
291: FND_MSG_PUB.Count_And_Get(
292: p_count => x_msg_count,
293: p_data => x_msg_data);
294:
295: WHEN OTHERS THEN
296:
297: ROLLBACK TO update_txn_ii_rltns_dtls;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299:
300: IF FND_MSG_PUB.Check_Msg_Level(
301: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
302:
303: FND_MSG_PUB.Add_Exc_Msg(
304: p_pkg_name => G_PKG_NAME,
297: ROLLBACK TO update_txn_ii_rltns_dtls;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299:
300: IF FND_MSG_PUB.Check_Msg_Level(
301: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
302:
303: FND_MSG_PUB.Add_Exc_Msg(
304: p_pkg_name => G_PKG_NAME,
305: p_procedure_name => l_api_name);
299:
300: IF FND_MSG_PUB.Check_Msg_Level(
301: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
302:
303: FND_MSG_PUB.Add_Exc_Msg(
304: p_pkg_name => G_PKG_NAME,
305: p_procedure_name => l_api_name);
306:
307: END IF;
305: p_procedure_name => l_api_name);
306:
307: END IF;
308:
309: FND_MSG_PUB.Count_And_Get(
310: p_count => x_msg_count,
311: p_data => x_msg_data);
312:
313: END update_txn_ii_rltns_dtls;
344:
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
348: FND_MSG_PUB.initialize;
349: END IF;
350:
351: -- Initialize API return status to success
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
406: END IF;
407: ****/
408:
409: -- Standard call to get message count and if count is get message info.
410: FND_MSG_PUB.Count_And_Get(
411: p_count => x_msg_count,
412: p_data => x_msg_data);
413:
414: csi_t_gen_utility_pvt.add('API Successfully Executed : Delete Txn Relationships');
420: WHEN FND_API.G_EXC_ERROR THEN
421:
422: ROLLBACK TO Delete_Inst_Reltship_Dtls;
423: x_return_status := FND_API.G_RET_STS_ERROR ;
424: FND_MSG_PUB.Count_And_Get (
425: p_count => x_msg_count,
426: p_data => x_msg_data);
427:
428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429:
430: ROLLBACK TO Delete_Inst_Reltship_Dtls;
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432:
433: FND_MSG_PUB.Count_And_Get(
434: p_count => x_msg_count,
435: p_data => x_msg_data);
436:
437: WHEN OTHERS THEN
438:
439: ROLLBACK TO Delete_Inst_Reltship_Dtls;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441:
442: IF FND_MSG_PUB.Check_Msg_Level(
443: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
444:
445: FND_MSG_PUB.Add_Exc_Msg(
446: p_pkg_name => G_PKG_NAME,
439: ROLLBACK TO Delete_Inst_Reltship_Dtls;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
441:
442: IF FND_MSG_PUB.Check_Msg_Level(
443: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
444:
445: FND_MSG_PUB.Add_Exc_Msg(
446: p_pkg_name => G_PKG_NAME,
447: p_procedure_name => l_api_name);
441:
442: IF FND_MSG_PUB.Check_Msg_Level(
443: p_message_level => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
444:
445: FND_MSG_PUB.Add_Exc_Msg(
446: p_pkg_name => G_PKG_NAME,
447: p_procedure_name => l_api_name);
448:
449: END IF;
447: p_procedure_name => l_api_name);
448:
449: END IF;
450:
451: FND_MSG_PUB.Count_And_Get(
452: p_count => x_msg_count,
453: p_data => x_msg_data);
454:
455: END delete_txn_ii_rltns_dtls;