DBA Data[Home] [Help]

APPS.CSI_II_RELATIONSHIPS_PUB dependencies on FND_MSG_PUB

Line 60: fnd_msg_pub.initialize;

56:
57: -- initialize message list IF p_init_msg_list is set TO true.
58: IF fnd_api.to_boolean( p_init_msg_list )
59: THEN
60: fnd_msg_pub.initialize;
61: END IF;
62:
63:
64:

Line 134: fnd_msg_pub.count_and_get

130: END IF;
131: ****/
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 get_relationships_pub;
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 get_relationships_pub;
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 get_relationships_pub;
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 get_relationships_pub;
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: END get_relationships;

Line 224: fnd_msg_pub.initialize;

220:
221: -- initialize message list IF p_init_msg_list is set TO true.
222: IF fnd_api.to_boolean( p_init_msg_list )
223: THEN
224: fnd_msg_pub.initialize;
225: END IF;
226:
227:
228:

Line 309: x_msg_data := FND_MSG_PUB.GET

305: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
306: l_msg_index := 1;
307: l_msg_count := x_msg_count;
308: WHILE l_msg_count > 0 LOOP
309: x_msg_data := FND_MSG_PUB.GET
310: ( l_msg_index,
311: FND_API.G_FALSE );
312: csi_gen_utility_pvt.put_line( ' Error from Update_relationship PVT..');
313: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 339: x_msg_data := FND_MSG_PUB.GET

335: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
336: l_msg_index := 1;
337: l_msg_count := x_msg_count;
338: WHILE l_msg_count > 0 LOOP
339: x_msg_data := FND_MSG_PUB.GET
340: ( l_msg_index,
341: FND_API.G_FALSE );
342: csi_gen_utility_pvt.put_line( ' Error from Create_relationship PVT..');
343: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 420: x_msg_data := FND_MSG_PUB.GET

416: l_msg_index := 1;
417: l_msg_count := x_msg_count;
418:
419: WHILE l_msg_count > 0 LOOP
420: x_msg_data := FND_MSG_PUB.GET
421: (l_msg_index,
422: FND_API.G_FALSE );
423: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.UPDATE_INSTANCE_EVENT');
424: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 451: x_msg_data := FND_MSG_PUB.GET

447: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
448: l_msg_index := 1;
449: l_msg_count := x_msg_count;
450: WHILE l_msg_count > 0 LOOP
451: x_msg_data := FND_MSG_PUB.GET
452: ( l_msg_index,
453: FND_API.G_FALSE );
454: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');
455: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 486: fnd_msg_pub.count_and_get

482: dbms_session.set_sql_trace(FALSE);
483: END IF;
484: ****/
485: -- standard call TO get message count AND IF count is 1, get message info.
486: fnd_msg_pub.count_and_get
487: ( p_count => x_msg_count,
488: p_data => x_msg_data
489: );
490:

Line 495: fnd_msg_pub.count_and_get

491: EXCEPTION
492: WHEN fnd_api.g_exc_error THEN
493: ROLLBACK TO create_relationship_pub;
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:

Line 503: fnd_msg_pub.count_and_get

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

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

507:
508: WHEN OTHERS THEN
509: ROLLBACK TO create_relationship_pub;
510: x_return_status := fnd_api.g_ret_sts_unexp_error ;
511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
512: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
513: END IF;
514: fnd_msg_pub.count_and_get
515: (p_count => x_msg_count ,

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

508: WHEN OTHERS THEN
509: ROLLBACK TO create_relationship_pub;
510: x_return_status := fnd_api.g_ret_sts_unexp_error ;
511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
512: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
513: END IF;
514: fnd_msg_pub.count_and_get
515: (p_count => x_msg_count ,
516: p_data => x_msg_data

Line 514: fnd_msg_pub.count_and_get

510: x_return_status := fnd_api.g_ret_sts_unexp_error ;
511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
512: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
513: END IF;
514: fnd_msg_pub.count_and_get
515: (p_count => x_msg_count ,
516: p_data => x_msg_data
517: );
518:

Line 569: fnd_msg_pub.initialize;

565:
566: -- initialize message list IF p_init_msg_list is set TO true.
567: IF fnd_api.to_boolean( p_init_msg_list )
568: THEN
569: fnd_msg_pub.initialize;
570: END IF;
571:
572:
573: -- initialize api return status TO success

Line 662: x_msg_data := FND_MSG_PUB.GET

658: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
659: l_msg_index := 1;
660: l_msg_count := x_msg_count;
661: WHILE l_msg_count > 0 LOOP
662: x_msg_data := FND_MSG_PUB.GET
663: ( l_msg_index,
664: FND_API.G_FALSE );
665: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.update_relationship..');
666: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 702: x_msg_data := FND_MSG_PUB.GET

698: l_msg_index := 1;
699: l_msg_count := x_msg_count;
700: WHILE l_msg_count > 0
701: LOOP
702: x_msg_data := FND_MSG_PUB.GET
703: ( l_msg_index,
704: FND_API.G_FALSE );
705: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.create_relationship..');
706: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 743: x_msg_data := FND_MSG_PUB.GET

739: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
740: l_msg_index := 1;
741: l_msg_count := x_msg_count;
742: WHILE l_msg_count > 0 LOOP
743: x_msg_data := FND_MSG_PUB.GET
744: ( l_msg_index,
745: FND_API.G_FALSE );
746: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');
747: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 765: fnd_msg_pub.count_and_get

761: dbms_session.set_sql_trace(FALSE);
762: END IF;
763: ****/
764: -- standard call TO get message count AND IF count is 1, get message info.
765: fnd_msg_pub.count_and_get
766: ( p_count => x_msg_count,
767: p_data => x_msg_data
768: );
769:

Line 774: fnd_msg_pub.count_and_get

770: EXCEPTION
771: WHEN fnd_api.g_exc_error THEN
772: ROLLBACK TO update_relationship_pub;
773: x_return_status := fnd_api.g_ret_sts_error ;
774: fnd_msg_pub.count_and_get
775: (p_count => x_msg_count ,
776: p_data => x_msg_data
777: );
778:

Line 782: fnd_msg_pub.count_and_get

778:
779: WHEN fnd_api.g_exc_unexpected_error THEN
780: ROLLBACK TO update_relationship_pub;
781: x_return_status := fnd_api.g_ret_sts_unexp_error ;
782: fnd_msg_pub.count_and_get
783: (p_count => x_msg_count ,
784: p_data => x_msg_data
785: );
786:

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

786:
787: WHEN OTHERS THEN
788: ROLLBACK TO update_relationship_pub;
789: x_return_status := fnd_api.g_ret_sts_unexp_error ;
790: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
791: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
792: END IF;
793: fnd_msg_pub.count_and_get
794: (p_count => x_msg_count ,

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

787: WHEN OTHERS THEN
788: ROLLBACK TO update_relationship_pub;
789: x_return_status := fnd_api.g_ret_sts_unexp_error ;
790: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
791: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
792: END IF;
793: fnd_msg_pub.count_and_get
794: (p_count => x_msg_count ,
795: p_data => x_msg_data

Line 793: fnd_msg_pub.count_and_get

789: x_return_status := fnd_api.g_ret_sts_unexp_error ;
790: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
791: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
792: END IF;
793: fnd_msg_pub.count_and_get
794: (p_count => x_msg_count ,
795: p_data => x_msg_data
796: );
797: END update_relationship;

Line 843: fnd_msg_pub.initialize;

839:
840: -- initialize message list IF p_init_msg_list is set TO true.
841: IF fnd_api.to_boolean( p_init_msg_list )
842: THEN
843: fnd_msg_pub.initialize;
844: END IF;
845:
846:
847: -- initialize api return status TO success

Line 917: fnd_msg_pub.count_and_get

913: dbms_session.set_sql_trace(FALSE);
914: END IF;
915: *****/
916: -- standard call TO get message count AND IF count is 1, get message info.
917: fnd_msg_pub.count_and_get
918: ( p_count => x_msg_count,
919: p_data => x_msg_data
920: );
921:

Line 926: fnd_msg_pub.count_and_get

922: EXCEPTION
923: WHEN fnd_api.g_exc_error THEN
924: ROLLBACK TO expire_relationship_pub;
925: x_return_status := fnd_api.g_ret_sts_error ;
926: fnd_msg_pub.count_and_get
927: (p_count => x_msg_count ,
928: p_data => x_msg_data
929: );
930:

Line 934: fnd_msg_pub.count_and_get

930:
931: WHEN fnd_api.g_exc_unexpected_error THEN
932: ROLLBACK TO expire_relationship_pub;
933: x_return_status := fnd_api.g_ret_sts_unexp_error ;
934: fnd_msg_pub.count_and_get
935: (p_count => x_msg_count ,
936: p_data => x_msg_data
937: );
938:

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

938:
939: WHEN OTHERS THEN
940: ROLLBACK TO expire_relationship_pub;
941: x_return_status := fnd_api.g_ret_sts_unexp_error ;
942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
943: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
944: END IF;
945: fnd_msg_pub.count_and_get
946: (p_count => x_msg_count ,

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

939: WHEN OTHERS THEN
940: ROLLBACK TO expire_relationship_pub;
941: x_return_status := fnd_api.g_ret_sts_unexp_error ;
942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
943: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
944: END IF;
945: fnd_msg_pub.count_and_get
946: (p_count => x_msg_count ,
947: p_data => x_msg_data

Line 945: fnd_msg_pub.count_and_get

941: x_return_status := fnd_api.g_ret_sts_unexp_error ;
942: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
943: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
944: END IF;
945: fnd_msg_pub.count_and_get
946: (p_count => x_msg_count ,
947: p_data => x_msg_data
948: );
949: END expire_relationship;