DBA Data[Home] [Help]

APPS.CSI_T_TXN_OUS_PVT dependencies on FND_MSG_PUB

Line 38: fnd_msg_pub.initialize;

34: SAVEPOINT create_txn_org_assgn_dtls;
35:
36: -- Initialize message list if p_init_msg_list is set to TRUE.
37: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
38: fnd_msg_pub.initialize;
39: END IF;
40:
41: -- Initialize API return status to success
42: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 174: fnd_msg_pub.add;

170: when others then
171: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
172: fnd_message.set_token('MESSAGE',
173: 'csi_t_org_assignments_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
174: fnd_msg_pub.add;
175: raise fnd_api.g_exc_error;
176: end;
177:
178: p_txn_org_assgn_rec.txn_operating_unit_id := l_txn_operating_unit_id;

Line 190: fnd_msg_pub.count_and_get(

186: csi_t_gen_utility_pvt.set_debug_off;
187: END IF;
188:
189: -- Standard call to get message count and if count is get message info.
190: fnd_msg_pub.count_and_get(
191: p_count => x_msg_count,
192: p_data => x_msg_data);
193:
194: EXCEPTION

Line 199: fnd_msg_pub.count_and_get (

195: WHEN fnd_api.G_EXC_ERROR THEN
196:
197: ROLLBACK TO Create_Txn_Org_Assgn_Dtls;
198: x_return_status := fnd_api.G_RET_STS_ERROR ;
199: fnd_msg_pub.count_and_get (
200: p_count => x_msg_count,
201: p_data => x_msg_data);
202:
203: WHEN fnd_api.g_exc_unexpected_error THEN

Line 208: fnd_msg_pub.count_and_get(

204:
205: ROLLBACK TO Create_Txn_Org_Assgn_Dtls;
206: x_return_status := fnd_api.g_ret_sts_unexp_error ;
207:
208: fnd_msg_pub.count_and_get(
209: p_count => x_msg_count,
210: p_data => x_msg_data);
211:
212: WHEN OTHERS THEN

Line 217: IF fnd_msg_pub.check_msg_level(

213:
214: ROLLBACK TO Create_Txn_Org_Assgn_Dtls;
215: x_return_status := fnd_api.g_ret_sts_unexp_error ;
216:
217: IF fnd_msg_pub.check_msg_level(
218: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
219:
220: fnd_msg_pub.add_exc_msg(
221: p_pkg_name => G_PKG_NAME,

Line 218: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN

214: ROLLBACK TO Create_Txn_Org_Assgn_Dtls;
215: x_return_status := fnd_api.g_ret_sts_unexp_error ;
216:
217: IF fnd_msg_pub.check_msg_level(
218: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
219:
220: fnd_msg_pub.add_exc_msg(
221: p_pkg_name => G_PKG_NAME,
222: p_procedure_name => l_api_name);

Line 220: fnd_msg_pub.add_exc_msg(

216:
217: IF fnd_msg_pub.check_msg_level(
218: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
219:
220: fnd_msg_pub.add_exc_msg(
221: p_pkg_name => G_PKG_NAME,
222: p_procedure_name => l_api_name);
223:
224: END IF;

Line 226: fnd_msg_pub.count_and_get(

222: p_procedure_name => l_api_name);
223:
224: END IF;
225:
226: fnd_msg_pub.count_and_get(
227: p_count => x_msg_count,
228: p_data => x_msg_data);
229:
230: END create_txn_org_assgn_dtls;

Line 264: fnd_msg_pub.initialize;

260: SAVEPOINT update_txn_org_assgn_dtls;
261:
262: -- Initialize message list if p_init_msg_list is set to TRUE.
263: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
264: fnd_msg_pub.initialize;
265: END IF;
266:
267: -- Initialize API return status to success
268: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 320: fnd_msg_pub.add;

316: IF l_return_status <> fnd_api.g_ret_sts_success THEN
317:
318: FND_MESSAGE.set_name('CSI','CSI_TXN_OU_ID_INVALID');
319: FND_MESSAGE.set_token('TXN_OU_ID',l_ou_rec.txn_operating_unit_id);
320: fnd_msg_pub.add;
321: RAISE fnd_api.g_exc_error;
322:
323: END IF;
324:

Line 341: fnd_msg_pub.add;

337:
338: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
339: FND_MESSAGE.set_token('LVL_ID', l_ou_rec.txn_operating_unit_id);
340: FND_MESSAGE.set_token('STATUS',l_processing_status);
341: fnd_msg_pub.add;
342: RAISE fnd_api.g_exc_error;
343:
344: END IF;
345:

Line 471: fnd_msg_pub.add;

467: when others then
468: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
469: fnd_message.set_token('MESSAGE',
470: 'csi_t_org_assignments_pkg.update_row failed. '||substr(sqlerrm,1,200));
471: fnd_msg_pub.add;
472: raise fnd_api.g_exc_error;
473: end;
474:
475: END LOOP;

Line 486: fnd_msg_pub.count_and_get(

482: COMMIT WORK;
483: END IF;
484:
485: -- Standard call to get message count and if count is get message info.
486: fnd_msg_pub.count_and_get(
487: p_count => x_msg_count,
488: p_data => x_msg_data);
489:
490: EXCEPTION

Line 495: fnd_msg_pub.count_and_get (

491: WHEN fnd_api.G_EXC_ERROR THEN
492:
493: ROLLBACK TO update_txn_org_assgn_dtls;
494: x_return_status := fnd_api.G_RET_STS_ERROR ;
495: fnd_msg_pub.count_and_get (
496: p_count => x_msg_count,
497: p_data => x_msg_data);
498:
499: WHEN fnd_api.g_exc_unexpected_error THEN

Line 504: fnd_msg_pub.count_and_get(

500:
501: ROLLBACK TO update_txn_org_assgn_dtls;
502: x_return_status := fnd_api.g_ret_sts_unexp_error ;
503:
504: fnd_msg_pub.count_and_get(
505: p_count => x_msg_count,
506: p_data => x_msg_data);
507:
508: WHEN OTHERS THEN

Line 513: IF fnd_msg_pub.check_msg_level(

509:
510: ROLLBACK TO update_txn_org_assgn_dtls;
511: x_return_status := fnd_api.g_ret_sts_unexp_error ;
512:
513: IF fnd_msg_pub.check_msg_level(
514: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
515:
516: fnd_msg_pub.add_exc_msg(
517: p_pkg_name => G_PKG_NAME,

Line 514: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN

510: ROLLBACK TO update_txn_org_assgn_dtls;
511: x_return_status := fnd_api.g_ret_sts_unexp_error ;
512:
513: IF fnd_msg_pub.check_msg_level(
514: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
515:
516: fnd_msg_pub.add_exc_msg(
517: p_pkg_name => G_PKG_NAME,
518: p_procedure_name => l_api_name);

Line 516: fnd_msg_pub.add_exc_msg(

512:
513: IF fnd_msg_pub.check_msg_level(
514: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
515:
516: fnd_msg_pub.add_exc_msg(
517: p_pkg_name => G_PKG_NAME,
518: p_procedure_name => l_api_name);
519:
520: END IF;

Line 522: fnd_msg_pub.count_and_get(

518: p_procedure_name => l_api_name);
519:
520: END IF;
521:
522: fnd_msg_pub.count_and_get(
523: p_count => x_msg_count,
524: p_data => x_msg_data);
525:
526: END update_txn_org_assgn_dtls;

Line 559: fnd_msg_pub.initialize;

555: SAVEPOINT delete_txn_org_assgn_dtls;
556:
557: -- Initialize message list if p_init_msg_list is set to TRUE.
558: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
559: fnd_msg_pub.initialize;
560: END IF;
561:
562: -- Initialize API return status to success
563: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 610: fnd_msg_pub.add;

606: IF l_return_status <> fnd_api.g_ret_sts_success THEN
607:
608: FND_MESSAGE.set_name('CSI','CSI_TXN_OU_ID_INVALID');
609: FND_MESSAGE.set_token('TXN_OU_ID',l_txn_ou_id);
610: fnd_msg_pub.add;
611: RAISE fnd_api.g_exc_error;
612:
613: END IF;
614:

Line 641: fnd_msg_pub.add;

637: IF l_return_status <> fnd_api.g_ret_sts_success THEN
638:
639: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
640: FND_MESSAGE.set_token('LINE_DTL_ID',l_line_dtl_id);
641: fnd_msg_pub.add;
642: RAISE fnd_api.g_exc_error;
643:
644: END IF;
645:

Line 670: fnd_msg_pub.count_and_get(

666: COMMIT WORK;
667: END IF;
668:
669: -- Standard call to get message count and if count is get message info.
670: fnd_msg_pub.count_and_get(
671: p_count => x_msg_count,
672: p_data => x_msg_data);
673:
674: EXCEPTION

Line 679: fnd_msg_pub.count_and_get (

675: WHEN fnd_api.G_EXC_ERROR THEN
676:
677: ROLLBACK TO delete_txn_org_assgn_dtls;
678: x_return_status := fnd_api.G_RET_STS_ERROR ;
679: fnd_msg_pub.count_and_get (
680: p_count => x_msg_count,
681: p_data => x_msg_data);
682:
683: WHEN fnd_api.g_exc_unexpected_error THEN

Line 688: fnd_msg_pub.count_and_get(

684:
685: ROLLBACK TO delete_txn_org_assgn_dtls;
686: x_return_status := fnd_api.g_ret_sts_unexp_error ;
687:
688: fnd_msg_pub.count_and_get(
689: p_count => x_msg_count,
690: p_data => x_msg_data);
691:
692: WHEN OTHERS THEN

Line 697: IF fnd_msg_pub.check_msg_level(

693:
694: ROLLBACK TO delete_txn_org_assgn_dtls;
695: x_return_status := fnd_api.g_ret_sts_unexp_error ;
696:
697: IF fnd_msg_pub.check_msg_level(
698: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
699:
700: fnd_msg_pub.add_exc_msg(
701: p_pkg_name => G_PKG_NAME,

Line 698: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN

694: ROLLBACK TO delete_txn_org_assgn_dtls;
695: x_return_status := fnd_api.g_ret_sts_unexp_error ;
696:
697: IF fnd_msg_pub.check_msg_level(
698: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
699:
700: fnd_msg_pub.add_exc_msg(
701: p_pkg_name => G_PKG_NAME,
702: p_procedure_name => l_api_name);

Line 700: fnd_msg_pub.add_exc_msg(

696:
697: IF fnd_msg_pub.check_msg_level(
698: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
699:
700: fnd_msg_pub.add_exc_msg(
701: p_pkg_name => G_PKG_NAME,
702: p_procedure_name => l_api_name);
703:
704: END IF;

Line 706: fnd_msg_pub.count_and_get(

702: p_procedure_name => l_api_name);
703:
704: END IF;
705:
706: fnd_msg_pub.count_and_get(
707: p_count => x_msg_count,
708: p_data => x_msg_data);
709:
710: END delete_txn_org_assgn_dtls;