DBA Data[Home] [Help]

APPS.JTF_ATTACHMENT_GRP dependencies on FND_MSG_PUB

Line 77: FND_MSG_PUB.initialize;

73: END IF;
74:
75: -- Initialize message list if p_init_msg_list is set to TRUE
76: IF FND_API.to_boolean(p_init_msg_list) THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:
80: -- Initialize API rturn status to success
81: x_return_status := FND_API.g_ret_sts_success;

Line 90: FND_MSG_PUB.add;

86: OR (p_start_id = -1 AND p_batch_size = 0) THEN
87: FND_MESSAGE.set_name('JTF', 'JTF_DSP_QUERY_INVLD');
88: FND_MESSAGE.set_token('0', p_start_id);
89: FND_MESSAGE.set_token('1', p_batch_size);
90: FND_MSG_PUB.add;
91: RAISE FND_API.g_exc_unexpected_error;
92: END IF;
93:
94: IF p_deliverable_id IS NOT NULL THEN

Line 117: FND_MSG_PUB.count_and_get(

113: FETCH l_ath_cv INTO x_row_count;
114: CLOSE l_ath_cv;
115:
116: IF x_row_count = 0 THEN
117: FND_MSG_PUB.count_and_get(
118: p_encoded => FND_API.g_false,
119: p_count => x_msg_count,
120: p_data => x_msg_data
121: );

Line 140: FND_MSG_PUB.count_and_get(

136:
137: -- Get matchined rows
138: IF p_start_id > -1 THEN
139: IF p_start_id >= x_row_count THEN
140: FND_MSG_PUB.count_and_get(
141: p_encoded => FND_API.g_false,
142: p_count => x_msg_count,
143: p_data => x_msg_data
144: );

Line 250: FND_MSG_PUB.count_and_get(

246: END LOOP;
247: END IF;
248:
249: -- Standard call to get message count and if count is 1, get message info
250: FND_MSG_PUB.count_and_get(
251: p_encoded => FND_API.g_false,
252: p_count => x_msg_count,
253: p_data => x_msg_data
254: );

Line 262: FND_MSG_PUB.count_and_get(

258: EXCEPTION
259:
260: WHEN FND_API.g_exc_unexpected_error THEN
261: x_return_status := FND_API.g_ret_sts_unexp_error ;
262: FND_MSG_PUB.count_and_get(
263: p_encoded => FND_API.g_false,
264: p_count => x_msg_count,
265: p_data => x_msg_data
266: );

Line 271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

267:
268: WHEN OTHERS THEN
269: x_return_status := FND_API.g_ret_sts_unexp_error ;
270:
271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
272: END IF;
273:
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.g_false,

Line 274: FND_MSG_PUB.count_and_get(

270:
271: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
272: END IF;
273:
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.g_false,
276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );

Line 334: FND_MSG_PUB.initialize;

330: END IF;
331:
332: -- Initialize message list if p_init_msg_list is set to TRUE
333: IF FND_API.to_boolean(p_init_msg_list) THEN
334: FND_MSG_PUB.initialize;
335: END IF;
336:
337: -- Initialize API rturn status to success
338: x_return_status := FND_API.g_ret_sts_success;

Line 524: FND_MSG_PUB.count_and_get(

520: COMMIT;
521: END IF;
522:
523: -- Standard call to get message count and if count is 1, get message info
524: FND_MSG_PUB.count_and_get(
525: p_encoded => FND_API.g_false,
526: p_count => x_msg_count,
527: p_data => x_msg_data
528: );

Line 536: FND_MSG_PUB.count_and_get(

532: WHEN FND_API.g_exc_error THEN
533: ROLLBACK TO save_attachment_grp;
534: x_return_status := FND_API.g_ret_sts_error;
535: p_attachment_rec.x_action_status := FND_API.g_ret_sts_error;
536: FND_MSG_PUB.count_and_get(
537: p_encoded => FND_API.g_false,
538: p_count => x_msg_count,
539: p_data => x_msg_data
540: );

Line 546: FND_MSG_PUB.count_and_get(

542: WHEN FND_API.g_exc_unexpected_error THEN
543: ROLLBACK TO save_attachment_grp;
544: x_return_status := FND_API.g_ret_sts_unexp_error ;
545: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
546: FND_MSG_PUB.count_and_get(
547: p_encoded => FND_API.g_false,
548: p_count => x_msg_count,
549: p_data => x_msg_data
550: );

Line 557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

553: ROLLBACK TO save_attachment_grp;
554: x_return_status := FND_API.g_ret_sts_unexp_error ;
555: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
556:
557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
559: END IF;
560:
561: FND_MSG_PUB.count_and_get(

Line 558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

554: x_return_status := FND_API.g_ret_sts_unexp_error ;
555: p_attachment_rec.x_action_status := FND_API.g_ret_sts_unexp_error;
556:
557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
559: END IF;
560:
561: FND_MSG_PUB.count_and_get(
562: p_encoded => FND_API.g_false,

Line 561: FND_MSG_PUB.count_and_get(

557: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
558: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
559: END IF;
560:
561: FND_MSG_PUB.count_and_get(
562: p_encoded => FND_API.g_false,
563: p_count => x_msg_count,
564: p_data => x_msg_data
565: );

Line 621: FND_MSG_PUB.initialize;

617: END IF;
618:
619: -- Initialize message list if p_init_msg_list is set to TRUE
620: IF FND_API.to_boolean(p_init_msg_list) THEN
621: FND_MSG_PUB.initialize;
622: END IF;
623:
624: -- Initialize API rturn status to success
625: x_return_status := FND_API.g_ret_sts_success;

Line 658: FND_MSG_PUB.count_and_get(

654: COMMIT;
655: END IF;
656:
657: -- Standard call to get message count and if count is 1, get message info
658: FND_MSG_PUB.count_and_get(
659: p_encoded => FND_API.g_false,
660: p_count => x_msg_count,
661: p_data => x_msg_data
662: );

Line 670: FND_MSG_PUB.count_and_get(

666:
667: WHEN FND_API.g_exc_error THEN
668: ROLLBACK TO save_attachment_grp;
669: x_return_status := FND_API.g_ret_sts_error;
670: FND_MSG_PUB.count_and_get(
671: p_encoded => FND_API.g_false,
672: p_count => x_msg_count,
673: p_data => x_msg_data
674: );

Line 679: FND_MSG_PUB.count_and_get(

675:
676: WHEN FND_API.g_exc_unexpected_error THEN
677: ROLLBACK TO save_attachment_grp;
678: x_return_status := FND_API.g_ret_sts_unexp_error ;
679: FND_MSG_PUB.count_and_get(
680: p_encoded => FND_API.g_false,
681: p_count => x_msg_count,
682: p_data => x_msg_data
683: );

Line 688: FND_MSG_PUB.count_and_get(

684:
685: WHEN OTHERS THEN
686: ROLLBACK TO save_attachment_grp;
687: x_return_status := FND_API.g_ret_sts_unexp_error ;
688: FND_MSG_PUB.count_and_get(
689: p_encoded => FND_API.g_false,
690: p_count => x_msg_count,
691: p_data => x_msg_data
692: );

Line 696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

692: );
693:
694: x_return_status := FND_API.g_ret_sts_unexp_error ;
695:
696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
697: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
698: END IF;
699:
700: FND_MSG_PUB.count_and_get(

Line 697: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

693:
694: x_return_status := FND_API.g_ret_sts_unexp_error ;
695:
696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
697: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
698: END IF;
699:
700: FND_MSG_PUB.count_and_get(
701: p_encoded => FND_API.g_false,

Line 700: FND_MSG_PUB.count_and_get(

696: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
697: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
698: END IF;
699:
700: FND_MSG_PUB.count_and_get(
701: p_encoded => FND_API.g_false,
702: p_count => x_msg_count,
703: p_data => x_msg_data
704: );

Line 760: FND_MSG_PUB.initialize;

756: END IF;
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE
759: IF FND_API.to_boolean(p_init_msg_list) THEN
760: FND_MSG_PUB.initialize;
761: END IF;
762:
763: -- Initialize API rturn status to success
764: x_return_status := FND_API.g_ret_sts_success;

Line 830: IF FND_MSG_PUB.check_msg_level(

826: ROLLBACK TO delete_one_attachment_grp;
827: x_return_status := FND_API.g_ret_sts_unexp_error ;
828: p_ath_id_ver_tbl(l_index).x_action_status
829: := FND_API.g_ret_sts_unexp_error ;
830: IF FND_MSG_PUB.check_msg_level(
831: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
832: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
833: END IF;
834:

Line 831: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

827: x_return_status := FND_API.g_ret_sts_unexp_error ;
828: p_ath_id_ver_tbl(l_index).x_action_status
829: := FND_API.g_ret_sts_unexp_error ;
830: IF FND_MSG_PUB.check_msg_level(
831: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
832: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
833: END IF;
834:
835: END;

Line 832: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

828: p_ath_id_ver_tbl(l_index).x_action_status
829: := FND_API.g_ret_sts_unexp_error ;
830: IF FND_MSG_PUB.check_msg_level(
831: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
832: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
833: END IF;
834:
835: END;
836: END LOOP;

Line 846: FND_MSG_PUB.count_and_get(

842: COMMIT;
843: END IF;
844:
845: -- Standard call to get message count and if count is 1, get message info
846: FND_MSG_PUB.count_and_get(
847: p_encoded => FND_API.g_false,
848: p_count => x_msg_count,
849: p_data => x_msg_data
850: );

Line 851: -- x_msg_count := FND_MSG_PUB.count_msg();

847: p_encoded => FND_API.g_false,
848: p_count => x_msg_count,
849: p_data => x_msg_data
850: );
851: -- x_msg_count := FND_MSG_PUB.count_msg();
852: -- x_msg_data := FND_MSG_PUB.get(FND_MSG_PUB.g_last, FND_API.g_false);
853:
854: EXCEPTION
855:

Line 852: -- x_msg_data := FND_MSG_PUB.get(FND_MSG_PUB.g_last, FND_API.g_false);

848: p_count => x_msg_count,
849: p_data => x_msg_data
850: );
851: -- x_msg_count := FND_MSG_PUB.count_msg();
852: -- x_msg_data := FND_MSG_PUB.get(FND_MSG_PUB.g_last, FND_API.g_false);
853:
854: EXCEPTION
855:
856: WHEN FND_API.g_exc_error THEN

Line 859: FND_MSG_PUB.count_and_get(

855:
856: WHEN FND_API.g_exc_error THEN
857: ROLLBACK TO delete_attachment_grp;
858: x_return_status := FND_API.g_ret_sts_error;
859: FND_MSG_PUB.count_and_get(
860: p_encoded => FND_API.g_false,
861: p_count => x_msg_count,
862: p_data => x_msg_data
863: );

Line 868: FND_MSG_PUB.count_and_get(

864:
865: WHEN FND_API.g_exc_unexpected_error THEN
866: ROLLBACK TO delete_attachment_grp;
867: x_return_status := FND_API.g_ret_sts_unexp_error ;
868: FND_MSG_PUB.count_and_get(
869: p_encoded => FND_API.g_false,
870: p_count => x_msg_count,
871: p_data => x_msg_data
872: );

Line 878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

874: WHEN OTHERS THEN
875: ROLLBACK TO delete_attachment_grp;
876: x_return_status := FND_API.g_ret_sts_unexp_error ;
877:
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
879: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:
882: FND_MSG_PUB.count_and_get(

Line 879: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

875: ROLLBACK TO delete_attachment_grp;
876: x_return_status := FND_API.g_ret_sts_unexp_error ;
877:
878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
879: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:
882: FND_MSG_PUB.count_and_get(
883: p_encoded => FND_API.g_false,

Line 882: FND_MSG_PUB.count_and_get(

878: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
879: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
880: END IF;
881:
882: FND_MSG_PUB.count_and_get(
883: p_encoded => FND_API.g_false,
884: p_count => x_msg_count,
885: p_data => x_msg_data
886: );