48:
49: -- initialize message list IF p_init_msg_list is set to true.
50: IF fnd_api.to_boolean( p_init_msg_list )
51: THEN
52: fnd_msg_pub.initialize;
53: END IF;
54:
55:
56:
130: dbms_session.set_sql_trace(false);
131: END IF;
132:
133: -- standard call to get message count AND IF count is 1, get message info.
134: fnd_msg_pub.count_and_get
135: ( p_count => x_msg_count,
136: p_data => x_msg_data
137: );
138:
139: EXCEPTION
140: WHEN fnd_api.g_exc_error THEN
141: ROLLBACK TO csi_t_txn_systems_grp;
142: x_return_status := fnd_api.g_ret_sts_error ;
143: fnd_msg_pub.count_and_get
144: (p_count => x_msg_count ,
145: p_data => x_msg_data
146: );
147:
147:
148: WHEN fnd_api.g_exc_unexpected_error THEN
149: ROLLBACK TO csi_t_txn_systems_grp;
150: x_return_status := fnd_api.g_ret_sts_unexp_error ;
151: fnd_msg_pub.count_and_get
152: (p_count => x_msg_count ,
153: p_data => x_msg_data
154: );
155:
155:
156: WHEN OTHERS THEN
157: ROLLBACK TO csi_t_txn_systems_grp;
158: x_return_status := fnd_api.g_ret_sts_unexp_error ;
159: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
160: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
161: END IF;
162: fnd_msg_pub.count_and_get
163: (p_count => x_msg_count ,
156: WHEN OTHERS THEN
157: ROLLBACK TO csi_t_txn_systems_grp;
158: x_return_status := fnd_api.g_ret_sts_unexp_error ;
159: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
160: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
161: END IF;
162: fnd_msg_pub.count_and_get
163: (p_count => x_msg_count ,
164: p_data => x_msg_data
158: x_return_status := fnd_api.g_ret_sts_unexp_error ;
159: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
160: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
161: END IF;
162: fnd_msg_pub.count_and_get
163: (p_count => x_msg_count ,
164: p_data => x_msg_data
165: );
166:
202:
203: -- initialize message list IF p_init_msg_list is set to true.
204: IF fnd_api.to_boolean( p_init_msg_list )
205: THEN
206: fnd_msg_pub.initialize;
207: END IF;
208:
209:
210: -- initialize api return status to success
277: dbms_session.set_sql_trace(false);
278: END IF;
279:
280: -- standard call to get message count and if count is 1, get message info.
281: fnd_msg_pub.count_and_get
282: ( p_count => x_msg_count,
283: p_data => x_msg_data
284: );
285:
286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO update_txn_system_grp;
289: x_return_status := fnd_api.g_ret_sts_error ;
290: fnd_msg_pub.count_and_get
291: (p_count => x_msg_count ,
292: p_data => x_msg_data
293: );
294:
294:
295: WHEN fnd_api.g_exc_unexpected_error THEN
296: ROLLBACK TO update_txn_system_grp;
297: x_return_status := fnd_api.g_ret_sts_unexp_error ;
298: fnd_msg_pub.count_and_get
299: (p_count => x_msg_count ,
300: p_data => x_msg_data
301: );
302:
302:
303: WHEN OTHERS THEN
304: ROLLBACK TO update_txn_system_grp;
305: x_return_status := fnd_api.g_ret_sts_unexp_error ;
306: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
307: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
308: END IF;
309: fnd_msg_pub.count_and_get
310: (p_count => x_msg_count ,
303: WHEN OTHERS THEN
304: ROLLBACK TO update_txn_system_grp;
305: x_return_status := fnd_api.g_ret_sts_unexp_error ;
306: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
307: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
308: END IF;
309: fnd_msg_pub.count_and_get
310: (p_count => x_msg_count ,
311: p_data => x_msg_data
305: x_return_status := fnd_api.g_ret_sts_unexp_error ;
306: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
307: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
308: END IF;
309: fnd_msg_pub.count_and_get
310: (p_count => x_msg_count ,
311: p_data => x_msg_data
312: );
313: END update_txn_system;
348:
349: -- initialize message list IF p_init_msg_list is set to true.
350: IF fnd_api.to_boolean( p_init_msg_list )
351: THEN
352: fnd_msg_pub.initialize;
353: END IF;
354:
355:
356: -- initialize api return status to success
421: dbms_session.set_sql_trace(false);
422: END IF;
423:
424: -- standard call to get message count AND IF count is 1, get message info.
425: fnd_msg_pub.count_and_get
426: ( p_count => x_msg_count,
427: p_data => x_msg_data
428: );
429:
430: EXCEPTION
431: WHEN fnd_api.g_exc_error THEN
432: ROLLBACK TO delete_txn_system_grp;
433: x_return_status := fnd_api.g_ret_sts_error ;
434: fnd_msg_pub.count_and_get
435: (p_count => x_msg_count ,
436: p_data => x_msg_data
437: );
438:
438:
439: WHEN fnd_api.g_exc_unexpected_error THEN
440: ROLLBACK TO delete_txn_system_grp;
441: x_return_status := fnd_api.g_ret_sts_unexp_error ;
442: fnd_msg_pub.count_and_get
443: (p_count => x_msg_count ,
444: p_data => x_msg_data
445: );
446:
446:
447: WHEN OTHERS THEN
448: ROLLBACK TO delete_txn_system_grp;
449: x_return_status := fnd_api.g_ret_sts_unexp_error ;
450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
451: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
452: END IF;
453: fnd_msg_pub.count_and_get
454: (p_count => x_msg_count ,
447: WHEN OTHERS THEN
448: ROLLBACK TO delete_txn_system_grp;
449: x_return_status := fnd_api.g_ret_sts_unexp_error ;
450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
451: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
452: END IF;
453: fnd_msg_pub.count_and_get
454: (p_count => x_msg_count ,
455: p_data => x_msg_data
449: x_return_status := fnd_api.g_ret_sts_unexp_error ;
450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
451: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
452: END IF;
453: fnd_msg_pub.count_and_get
454: (p_count => x_msg_count ,
455: p_data => x_msg_data
456: );
457: