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 419: x_msg_data := FND_MSG_PUB.GET

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);

Line 450: x_msg_data := FND_MSG_PUB.GET

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);

Line 485: fnd_msg_pub.count_and_get

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:

Line 494: fnd_msg_pub.count_and_get

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:

Line 502: fnd_msg_pub.count_and_get

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:

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

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 ,

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

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

Line 513: fnd_msg_pub.count_and_get

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:

Line 568: fnd_msg_pub.initialize;

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

Line 661: x_msg_data := FND_MSG_PUB.GET

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);

Line 701: x_msg_data := FND_MSG_PUB.GET

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);

Line 742: x_msg_data := FND_MSG_PUB.GET

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);

Line 764: fnd_msg_pub.count_and_get

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:

Line 773: fnd_msg_pub.count_and_get

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:

Line 781: fnd_msg_pub.count_and_get

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:

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

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 ,

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

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

Line 792: fnd_msg_pub.count_and_get

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;

Line 842: fnd_msg_pub.initialize;

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

Line 916: fnd_msg_pub.count_and_get

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:

Line 925: fnd_msg_pub.count_and_get

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:

Line 933: fnd_msg_pub.count_and_get

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:

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

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 ,

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

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

Line 944: fnd_msg_pub.count_and_get

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;