DBA Data[Home] [Help]

APPS.CSI_T_TXN_SYSTEMS_GRP dependencies on FND_MSG_PUB

Line 52: fnd_msg_pub.initialize;

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:

Line 134: fnd_msg_pub.count_and_get

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:

Line 143: fnd_msg_pub.count_and_get

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:

Line 151: fnd_msg_pub.count_and_get

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:

Line 159: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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 ,

Line 160: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);

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

Line 162: fnd_msg_pub.count_and_get

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:

Line 206: fnd_msg_pub.initialize;

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

Line 281: fnd_msg_pub.count_and_get

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:

Line 290: fnd_msg_pub.count_and_get

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:

Line 298: fnd_msg_pub.count_and_get

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:

Line 306: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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 ,

Line 307: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);

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

Line 309: fnd_msg_pub.count_and_get

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;

Line 352: fnd_msg_pub.initialize;

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

Line 425: fnd_msg_pub.count_and_get

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:

Line 434: fnd_msg_pub.count_and_get

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:

Line 442: fnd_msg_pub.count_and_get

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:

Line 450: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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 ,

Line 451: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);

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

Line 453: fnd_msg_pub.count_and_get

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: