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:
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:
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:
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:
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 ,
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
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;
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:
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);
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);
415: l_msg_index := 1;
416: l_msg_count := x_msg_count;
417:
418: WHILE l_msg_count > 0 LOOP
419: x_msg_data := FND_MSG_PUB.GET
420: (l_msg_index,
421: FND_API.G_FALSE );
422: csi_gen_utility_pvt.put_line('Error from CSI_BUSINESS_EVENT.CREATE_INSTANCE_EVENT');
423: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
446: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
447: l_msg_index := 1;
448: l_msg_count := x_msg_count;
449: WHILE l_msg_count > 0 LOOP
450: x_msg_data := FND_MSG_PUB.GET
451: ( l_msg_index,
452: FND_API.G_FALSE );
453: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');
454: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
481: dbms_session.set_sql_trace(FALSE);
482: END IF;
483: ****/
484: -- standard call TO get message count AND IF count is 1, get message info.
485: fnd_msg_pub.count_and_get
486: ( p_count => x_msg_count,
487: p_data => x_msg_data
488: );
489:
490: EXCEPTION
491: WHEN fnd_api.g_exc_error THEN
492: ROLLBACK TO create_relationship_pub;
493: x_return_status := fnd_api.g_ret_sts_error ;
494: fnd_msg_pub.count_and_get
495: (p_count => x_msg_count ,
496: p_data => x_msg_data
497: );
498:
498:
499: WHEN fnd_api.g_exc_unexpected_error THEN
500: ROLLBACK TO create_relationship_pub;
501: x_return_status := fnd_api.g_ret_sts_unexp_error ;
502: fnd_msg_pub.count_and_get
503: (p_count => x_msg_count ,
504: p_data => x_msg_data
505: );
506:
506:
507: WHEN OTHERS THEN
508: ROLLBACK TO create_relationship_pub;
509: x_return_status := fnd_api.g_ret_sts_unexp_error ;
510: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
511: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
512: END IF;
513: fnd_msg_pub.count_and_get
514: (p_count => x_msg_count ,
507: WHEN OTHERS THEN
508: ROLLBACK TO create_relationship_pub;
509: x_return_status := fnd_api.g_ret_sts_unexp_error ;
510: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
511: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
512: END IF;
513: fnd_msg_pub.count_and_get
514: (p_count => x_msg_count ,
515: p_data => x_msg_data
509: x_return_status := fnd_api.g_ret_sts_unexp_error ;
510: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
511: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
512: END IF;
513: fnd_msg_pub.count_and_get
514: (p_count => x_msg_count ,
515: p_data => x_msg_data
516: );
517:
564:
565: -- initialize message list IF p_init_msg_list is set TO true.
566: IF fnd_api.to_boolean( p_init_msg_list )
567: THEN
568: fnd_msg_pub.initialize;
569: END IF;
570:
571:
572: -- initialize api return status TO success
657: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
658: l_msg_index := 1;
659: l_msg_count := x_msg_count;
660: WHILE l_msg_count > 0 LOOP
661: x_msg_data := FND_MSG_PUB.GET
662: ( l_msg_index,
663: FND_API.G_FALSE );
664: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.update_relationship..');
665: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
697: l_msg_index := 1;
698: l_msg_count := x_msg_count;
699: WHILE l_msg_count > 0
700: LOOP
701: x_msg_data := FND_MSG_PUB.GET
702: ( l_msg_index,
703: FND_API.G_FALSE );
704: csi_gen_utility_pvt.put_line( ' Error from csi_ii_relationships_pvt.create_relationship..');
705: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
738: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
739: l_msg_index := 1;
740: l_msg_count := x_msg_count;
741: WHILE l_msg_count > 0 LOOP
742: x_msg_data := FND_MSG_PUB.GET
743: ( l_msg_index,
744: FND_API.G_FALSE );
745: csi_gen_utility_pvt.put_line( ' Error from UPDATE_VERSION_TIME..');
746: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
760: dbms_session.set_sql_trace(FALSE);
761: END IF;
762: ****/
763: -- standard call TO get message count AND IF count is 1, get message info.
764: fnd_msg_pub.count_and_get
765: ( p_count => x_msg_count,
766: p_data => x_msg_data
767: );
768:
769: EXCEPTION
770: WHEN fnd_api.g_exc_error THEN
771: ROLLBACK TO update_relationship_pub;
772: x_return_status := fnd_api.g_ret_sts_error ;
773: fnd_msg_pub.count_and_get
774: (p_count => x_msg_count ,
775: p_data => x_msg_data
776: );
777:
777:
778: WHEN fnd_api.g_exc_unexpected_error THEN
779: ROLLBACK TO update_relationship_pub;
780: x_return_status := fnd_api.g_ret_sts_unexp_error ;
781: fnd_msg_pub.count_and_get
782: (p_count => x_msg_count ,
783: p_data => x_msg_data
784: );
785:
785:
786: WHEN OTHERS THEN
787: ROLLBACK TO update_relationship_pub;
788: x_return_status := fnd_api.g_ret_sts_unexp_error ;
789: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
791: END IF;
792: fnd_msg_pub.count_and_get
793: (p_count => x_msg_count ,
786: WHEN OTHERS THEN
787: ROLLBACK TO update_relationship_pub;
788: x_return_status := fnd_api.g_ret_sts_unexp_error ;
789: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
791: END IF;
792: fnd_msg_pub.count_and_get
793: (p_count => x_msg_count ,
794: p_data => x_msg_data
788: x_return_status := fnd_api.g_ret_sts_unexp_error ;
789: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
791: END IF;
792: fnd_msg_pub.count_and_get
793: (p_count => x_msg_count ,
794: p_data => x_msg_data
795: );
796: END update_relationship;
838:
839: -- initialize message list IF p_init_msg_list is set TO true.
840: IF fnd_api.to_boolean( p_init_msg_list )
841: THEN
842: fnd_msg_pub.initialize;
843: END IF;
844:
845:
846: -- initialize api return status TO success
912: dbms_session.set_sql_trace(FALSE);
913: END IF;
914: *****/
915: -- standard call TO get message count AND IF count is 1, get message info.
916: fnd_msg_pub.count_and_get
917: ( p_count => x_msg_count,
918: p_data => x_msg_data
919: );
920:
921: EXCEPTION
922: WHEN fnd_api.g_exc_error THEN
923: ROLLBACK TO expire_relationship_pub;
924: x_return_status := fnd_api.g_ret_sts_error ;
925: fnd_msg_pub.count_and_get
926: (p_count => x_msg_count ,
927: p_data => x_msg_data
928: );
929:
929:
930: WHEN fnd_api.g_exc_unexpected_error THEN
931: ROLLBACK TO expire_relationship_pub;
932: x_return_status := fnd_api.g_ret_sts_unexp_error ;
933: fnd_msg_pub.count_and_get
934: (p_count => x_msg_count ,
935: p_data => x_msg_data
936: );
937:
937:
938: WHEN OTHERS THEN
939: ROLLBACK TO expire_relationship_pub;
940: x_return_status := fnd_api.g_ret_sts_unexp_error ;
941: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
942: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
943: END IF;
944: fnd_msg_pub.count_and_get
945: (p_count => x_msg_count ,
938: WHEN OTHERS THEN
939: ROLLBACK TO expire_relationship_pub;
940: x_return_status := fnd_api.g_ret_sts_unexp_error ;
941: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
942: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
943: END IF;
944: fnd_msg_pub.count_and_get
945: (p_count => x_msg_count ,
946: p_data => x_msg_data
940: x_return_status := fnd_api.g_ret_sts_unexp_error ;
941: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
942: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
943: END IF;
944: fnd_msg_pub.count_and_get
945: (p_count => x_msg_count ,
946: p_data => x_msg_data
947: );
948: END expire_relationship;