DBA Data[Home] [Help]

APPS.CSI_COUNTER_PUB dependencies on FND_MSG_PUB

Line 84: FND_MSG_PUB.initialize;

80: END IF;
81:
82: -- Initialize message list if p_init_msg_list is set to TRUE.
83: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86:
87: -- Initialize API return status to success
88: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 134: x_msg_data := FND_MSG_PUB.GET

130: l_msg_index := 1;
131: l_msg_count := x_msg_count;
132:
133: WHILE l_msg_count > 0 LOOP
134: x_msg_data := FND_MSG_PUB.GET
135: (l_msg_index,
136: FND_API.G_FALSE );
137: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_COUNTER_PRE API');
138: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 170: x_msg_data := FND_MSG_PUB.GET

166: l_msg_index := 1;
167: l_msg_count := x_msg_count;
168:
169: WHILE l_msg_count > 0 LOOP
170: x_msg_data := FND_MSG_PUB.GET
171: (l_msg_index,
172: FND_API.G_FALSE );
173: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_COUNTER_PRE API');
174: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 206: x_msg_data := FND_MSG_PUB.GET

202: l_msg_index := 1;
203: l_msg_count := x_msg_count;
204:
205: WHILE l_msg_count > 0 LOOP
206: x_msg_data := FND_MSG_PUB.GET
207: (l_msg_index,
208: FND_API.G_FALSE );
209: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_COUNTER API');
210: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 273: x_msg_data := FND_MSG_PUB.GET

269: l_msg_index := 1;
270: l_msg_count := x_msg_count;
271:
272: WHILE l_msg_count > 0 LOOP
273: x_msg_data := FND_MSG_PUB.GET
274: (l_msg_index,
275: FND_API.G_FALSE );
276: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_PROPERTY API');
277: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 336: x_msg_data := FND_MSG_PUB.GET

332: l_msg_index := 1;
333: l_msg_count := x_msg_count;
334:
335: WHILE l_msg_count > 0 LOOP
336: x_msg_data := FND_MSG_PUB.GET
337: (l_msg_index,
338: FND_API.G_FALSE );
339: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_RELATIONSHIP API');
340: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 372: x_msg_data := FND_MSG_PUB.GET

368: l_msg_index := 1;
369: l_msg_count := x_msg_count;
370:
371: WHILE l_msg_count > 0 LOOP
372: x_msg_data := FND_MSG_PUB.GET
373: (l_msg_index,
374: FND_API.G_FALSE );
375: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS API');
376: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 437: x_msg_data := FND_MSG_PUB.GET

433: l_msg_index := 1;
434: l_msg_count := x_msg_count;
435:
436: WHILE l_msg_count > 0 LOOP
437: x_msg_data := FND_MSG_PUB.GET
438: (l_msg_index,
439: FND_API.G_FALSE );
440: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS API');
441: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 544: x_msg_data := FND_MSG_PUB.GET

540: l_msg_index := 1;
541: l_msg_count := x_msg_count;
542:
543: WHILE l_msg_count > 0 LOOP
544: x_msg_data := FND_MSG_PUB.GET
545: (l_msg_index,
546: FND_API.G_FALSE );
547: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_COUNTER_POST API');
548: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 578: x_msg_data := FND_MSG_PUB.GET

574: l_msg_index := 1;
575: l_msg_count := x_msg_count;
576:
577: WHILE l_msg_count > 0 LOOP
578: x_msg_data := FND_MSG_PUB.GET
579: (l_msg_index,
580: FND_API.G_FALSE );
581: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_COUNTER_POST API');
582: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 599: FND_MSG_PUB.Count_And_Get

595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_ERROR ;
598: ROLLBACK TO create_counter_pub;
599: FND_MSG_PUB.Count_And_Get
600: (p_count => x_msg_count,
601: p_data => x_msg_data
602: );
603:

Line 607: FND_MSG_PUB.Count_And_Get

603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: ROLLBACK TO create_counter_pub;
607: FND_MSG_PUB.Count_And_Get
608: (p_count => x_msg_count,
609: p_data => x_msg_data
610: );
611: WHEN OTHERS THEN

Line 614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

610: );
611: WHEN OTHERS THEN
612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
613: ROLLBACK TO create_counter_pub;
614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
615: THEN
616: FND_MSG_PUB.Add_Exc_Msg
617: (G_PKG_NAME,
618: l_api_name

Line 616: FND_MSG_PUB.Add_Exc_Msg

612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
613: ROLLBACK TO create_counter_pub;
614: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
615: THEN
616: FND_MSG_PUB.Add_Exc_Msg
617: (G_PKG_NAME,
618: l_api_name
619: );
620: END IF;

Line 621: FND_MSG_PUB.Count_And_Get

617: (G_PKG_NAME,
618: l_api_name
619: );
620: END IF;
621: FND_MSG_PUB.Count_And_Get
622: (p_count => x_msg_count,
623: p_data => x_msg_data
624: );
625:

Line 674: FND_MSG_PUB.initialize;

670: END IF;
671:
672: -- Initialize message list if p_init_msg_list is set to TRUE.
673: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
674: FND_MSG_PUB.initialize;
675: END IF;
676:
677: -- Initialize API return status to success
678: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 720: x_msg_data := FND_MSG_PUB.GET

716: l_msg_index := 1;
717: l_msg_count := x_msg_count;
718:
719: WHILE l_msg_count > 0 LOOP
720: x_msg_data := FND_MSG_PUB.GET
721: (l_msg_index,
722: FND_API.G_FALSE );
723: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_PROPERTY_PRE API');
724: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 750: x_msg_data := FND_MSG_PUB.GET

746: l_msg_index := 1;
747: l_msg_count := x_msg_count;
748:
749: WHILE l_msg_count > 0 LOOP
750: x_msg_data := FND_MSG_PUB.GET
751: (l_msg_index,
752: FND_API.G_FALSE );
753: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_CTR_PROPERTY_PRE API');
754: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 817: x_msg_data := FND_MSG_PUB.GET

813: l_msg_index := 1;
814: l_msg_count := x_msg_count;
815:
816: WHILE l_msg_count > 0 LOOP
817: x_msg_data := FND_MSG_PUB.GET
818: (l_msg_index,
819: FND_API.G_FALSE );
820: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_PROPERTY API');
821: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 852: x_msg_data := FND_MSG_PUB.GET

848: l_msg_index := 1;
849: l_msg_count := x_msg_count;
850:
851: WHILE l_msg_count > 0 LOOP
852: x_msg_data := FND_MSG_PUB.GET
853: (l_msg_index,
854: FND_API.G_FALSE );
855: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_PROPERTY_POST API');
856: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 882: x_msg_data := FND_MSG_PUB.GET

878: l_msg_index := 1;
879: l_msg_count := x_msg_count;
880:
881: WHILE l_msg_count > 0 LOOP
882: x_msg_data := FND_MSG_PUB.GET
883: (l_msg_index,
884: FND_API.G_FALSE );
885: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_PROPERTY_POST API');
886: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 903: FND_MSG_PUB.Count_And_Get

899: EXCEPTION
900: WHEN FND_API.G_EXC_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_ERROR ;
902: ROLLBACK TO create_ctr_property_pub;
903: FND_MSG_PUB.Count_And_Get
904: (p_count => x_msg_count,
905: p_data => x_msg_data
906: );
907:

Line 911: FND_MSG_PUB.Count_And_Get

907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
910: ROLLBACK TO create_ctr_property_pub;
911: FND_MSG_PUB.Count_And_Get
912: (p_count => x_msg_count,
913: p_data => x_msg_data
914: );
915: WHEN OTHERS THEN

Line 918: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

914: );
915: WHEN OTHERS THEN
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
917: ROLLBACK TO create_ctr_property_pub;
918: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: FND_MSG_PUB.Add_Exc_Msg
921: (G_PKG_NAME,
922: l_api_name

Line 920: FND_MSG_PUB.Add_Exc_Msg

916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
917: ROLLBACK TO create_ctr_property_pub;
918: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
919: THEN
920: FND_MSG_PUB.Add_Exc_Msg
921: (G_PKG_NAME,
922: l_api_name
923: );
924: END IF;

Line 925: FND_MSG_PUB.Count_And_Get

921: (G_PKG_NAME,
922: l_api_name
923: );
924: END IF;
925: FND_MSG_PUB.Count_And_Get
926: (p_count => x_msg_count,
927: p_data => x_msg_data
928: );
929:

Line 978: FND_MSG_PUB.initialize;

974: END IF;
975:
976: -- Initialize message list if p_init_msg_list is set to TRUE.
977: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
978: FND_MSG_PUB.initialize;
979: END IF;
980:
981: -- Initialize API return status to success
982: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1024: x_msg_data := FND_MSG_PUB.GET

1020: l_msg_index := 1;
1021: l_msg_count := x_msg_count;
1022:
1023: WHILE l_msg_count > 0 LOOP
1024: x_msg_data := FND_MSG_PUB.GET
1025: (l_msg_index,
1026: FND_API.G_FALSE );
1027: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_ASSOCIATIONS_PRE API');
1028: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1055: x_msg_data := FND_MSG_PUB.GET

1051: l_msg_index := 1;
1052: l_msg_count := x_msg_count;
1053:
1054: WHILE l_msg_count > 0 LOOP
1055: x_msg_data := FND_MSG_PUB.GET
1056: (l_msg_index,
1057: FND_API.G_FALSE );
1058: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_CTR_ASSOCIATIONS_PRE API');
1059: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1116: x_msg_data := FND_MSG_PUB.GET

1112: l_msg_index := 1;
1113: l_msg_count := x_msg_count;
1114:
1115: WHILE l_msg_count > 0 LOOP
1116: x_msg_data := FND_MSG_PUB.GET
1117: (l_msg_index,
1118: FND_API.G_FALSE );
1119: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS API');
1120: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1149: x_msg_data := FND_MSG_PUB.GET

1145: l_msg_index := 1;
1146: l_msg_count := x_msg_count;
1147:
1148: WHILE l_msg_count > 0 LOOP
1149: x_msg_data := FND_MSG_PUB.GET
1150: (l_msg_index,
1151: FND_API.G_FALSE );
1152: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_CTR_ASSOCIATIONS_POST API');
1153: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1180: x_msg_data := FND_MSG_PUB.GET

1176: l_msg_index := 1;
1177: l_msg_count := x_msg_count;
1178:
1179: WHILE l_msg_count > 0 LOOP
1180: x_msg_data := FND_MSG_PUB.GET
1181: (l_msg_index,
1182: FND_API.G_FALSE );
1183: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_CTR_ASSOCIATIONS_POST API');
1184: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1203: FND_MSG_PUB.Count_And_Get

1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202: ROLLBACK TO create_ctr_associations_pub;
1203: FND_MSG_PUB.Count_And_Get
1204: (p_count => x_msg_count,
1205: p_data => x_msg_data
1206: );
1207:

Line 1211: FND_MSG_PUB.Count_And_Get

1207:
1208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1210: ROLLBACK TO create_ctr_associations_pub;
1211: FND_MSG_PUB.Count_And_Get
1212: (p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );
1215: WHEN OTHERS THEN

Line 1218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1214: );
1215: WHEN OTHERS THEN
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1217: ROLLBACK TO create_ctr_associations_pub;
1218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: FND_MSG_PUB.Add_Exc_Msg
1221: (G_PKG_NAME,
1222: l_api_name

Line 1220: FND_MSG_PUB.Add_Exc_Msg

1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1217: ROLLBACK TO create_ctr_associations_pub;
1218: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1219: THEN
1220: FND_MSG_PUB.Add_Exc_Msg
1221: (G_PKG_NAME,
1222: l_api_name
1223: );
1224: END IF;

Line 1225: FND_MSG_PUB.Count_And_Get

1221: (G_PKG_NAME,
1222: l_api_name
1223: );
1224: END IF;
1225: FND_MSG_PUB.Count_And_Get
1226: (p_count => x_msg_count,
1227: p_data => x_msg_data
1228: );
1229:

Line 1278: FND_MSG_PUB.initialize;

1274: END IF;
1275:
1276: -- Initialize message list if p_init_msg_list is set to TRUE.
1277: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1278: FND_MSG_PUB.initialize;
1279: END IF;
1280:
1281: -- Initialize API return status to success
1282: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1324: x_msg_data := FND_MSG_PUB.GET

1320: l_msg_index := 1;
1321: l_msg_count := x_msg_count;
1322:
1323: WHILE l_msg_count > 0 LOOP
1324: x_msg_data := FND_MSG_PUB.GET
1325: (l_msg_index,
1326: FND_API.G_FALSE );
1327: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_READING_LOCK_PRE API');
1328: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1354: x_msg_data := FND_MSG_PUB.GET

1350: l_msg_index := 1;
1351: l_msg_count := x_msg_count;
1352:
1353: WHILE l_msg_count > 0 LOOP
1354: x_msg_data := FND_MSG_PUB.GET
1355: (l_msg_index,
1356: FND_API.G_FALSE );
1357: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_READING_LOCK_PRE API');
1358: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1385: x_msg_data := FND_MSG_PUB.GET

1381: l_msg_index := 1;
1382: l_msg_count := x_msg_count;
1383:
1384: WHILE l_msg_count > 0 LOOP
1385: x_msg_data := FND_MSG_PUB.GET
1386: (l_msg_index,
1387: FND_API.G_FALSE );
1388: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_READING_LOCK API');
1389: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1417: x_msg_data := FND_MSG_PUB.GET

1413: l_msg_index := 1;
1414: l_msg_count := x_msg_count;
1415:
1416: WHILE l_msg_count > 0 LOOP
1417: x_msg_data := FND_MSG_PUB.GET
1418: (l_msg_index,
1419: FND_API.G_FALSE );
1420: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_READING_LOCK_POST API');
1421: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1447: x_msg_data := FND_MSG_PUB.GET

1443: l_msg_index := 1;
1444: l_msg_count := x_msg_count;
1445:
1446: WHILE l_msg_count > 0 LOOP
1447: x_msg_data := FND_MSG_PUB.GET
1448: (l_msg_index,
1449: FND_API.G_FALSE );
1450: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_READING_LOCK_POST API');
1451: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1470: FND_MSG_PUB.Count_And_Get

1466: EXCEPTION
1467: WHEN FND_API.G_EXC_ERROR THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR ;
1469: ROLLBACK TO create_reading_lock_pub;
1470: FND_MSG_PUB.Count_And_Get
1471: (p_count => x_msg_count,
1472: p_data => x_msg_data
1473: );
1474:

Line 1478: FND_MSG_PUB.Count_And_Get

1474:
1475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1477: ROLLBACK TO create_reading_lock_pub;
1478: FND_MSG_PUB.Count_And_Get
1479: (p_count => x_msg_count,
1480: p_data => x_msg_data
1481: );
1482: WHEN OTHERS THEN

Line 1485: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1481: );
1482: WHEN OTHERS THEN
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1484: ROLLBACK TO create_reading_lock_pub;
1485: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1486: THEN
1487: FND_MSG_PUB.Add_Exc_Msg
1488: (G_PKG_NAME,
1489: l_api_name

Line 1487: FND_MSG_PUB.Add_Exc_Msg

1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1484: ROLLBACK TO create_reading_lock_pub;
1485: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1486: THEN
1487: FND_MSG_PUB.Add_Exc_Msg
1488: (G_PKG_NAME,
1489: l_api_name
1490: );
1491: END IF;

Line 1492: FND_MSG_PUB.Count_And_Get

1488: (G_PKG_NAME,
1489: l_api_name
1490: );
1491: END IF;
1492: FND_MSG_PUB.Count_And_Get
1493: (p_count => x_msg_count,
1494: p_data => x_msg_data
1495: );
1496:

Line 1545: FND_MSG_PUB.initialize;

1541: END IF;
1542:
1543: -- Initialize message list if p_init_msg_list is set to TRUE.
1544: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1545: FND_MSG_PUB.initialize;
1546: END IF;
1547:
1548: -- Initialize API return status to success
1549: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1591: x_msg_data := FND_MSG_PUB.GET

1587: l_msg_index := 1;
1588: l_msg_count := x_msg_count;
1589:
1590: WHILE l_msg_count > 0 LOOP
1591: x_msg_data := FND_MSG_PUB.GET
1592: (l_msg_index,
1593: FND_API.G_FALSE );
1594: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_DAILY_USAGE_PRE API');
1595: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1621: x_msg_data := FND_MSG_PUB.GET

1617: l_msg_index := 1;
1618: l_msg_count := x_msg_count;
1619:
1620: WHILE l_msg_count > 0 LOOP
1621: x_msg_data := FND_MSG_PUB.GET
1622: (l_msg_index,
1623: FND_API.G_FALSE );
1624: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_DAILY_USAGE_PRE API');
1625: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1652: x_msg_data := FND_MSG_PUB.GET

1648: l_msg_index := 1;
1649: l_msg_count := x_msg_count;
1650:
1651: WHILE l_msg_count > 0 LOOP
1652: x_msg_data := FND_MSG_PUB.GET
1653: (l_msg_index,
1654: FND_API.G_FALSE );
1655: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_DAILY_USAGE API');
1656: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1684: x_msg_data := FND_MSG_PUB.GET

1680: l_msg_index := 1;
1681: l_msg_count := x_msg_count;
1682:
1683: WHILE l_msg_count > 0 LOOP
1684: x_msg_data := FND_MSG_PUB.GET
1685: (l_msg_index,
1686: FND_API.G_FALSE );
1687: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.CREATE_DAILY_USAGE_POST API');
1688: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1714: x_msg_data := FND_MSG_PUB.GET

1710: l_msg_index := 1;
1711: l_msg_count := x_msg_count;
1712:
1713: WHILE l_msg_count > 0 LOOP
1714: x_msg_data := FND_MSG_PUB.GET
1715: (l_msg_index,
1716: FND_API.G_FALSE );
1717: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.CREATE_DAILY_USAGE_POST API');
1718: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1735: FND_MSG_PUB.Count_And_Get

1731: EXCEPTION
1732: WHEN FND_API.G_EXC_ERROR THEN
1733: x_return_status := FND_API.G_RET_STS_ERROR ;
1734: ROLLBACK TO create_daily_usage_pub;
1735: FND_MSG_PUB.Count_And_Get
1736: (p_count => x_msg_count,
1737: p_data => x_msg_data
1738: );
1739:

Line 1743: FND_MSG_PUB.Count_And_Get

1739:
1740: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1742: ROLLBACK TO create_daily_usage_pub;
1743: FND_MSG_PUB.Count_And_Get
1744: (p_count => x_msg_count,
1745: p_data => x_msg_data
1746: );
1747: WHEN OTHERS THEN

Line 1750: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1746: );
1747: WHEN OTHERS THEN
1748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1749: ROLLBACK TO create_daily_usage_pub;
1750: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1751: THEN
1752: FND_MSG_PUB.Add_Exc_Msg
1753: (G_PKG_NAME,
1754: l_api_name

Line 1752: FND_MSG_PUB.Add_Exc_Msg

1748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1749: ROLLBACK TO create_daily_usage_pub;
1750: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1751: THEN
1752: FND_MSG_PUB.Add_Exc_Msg
1753: (G_PKG_NAME,
1754: l_api_name
1755: );
1756: END IF;

Line 1757: FND_MSG_PUB.Count_And_Get

1753: (G_PKG_NAME,
1754: l_api_name
1755: );
1756: END IF;
1757: FND_MSG_PUB.Count_And_Get
1758: (p_count => x_msg_count,
1759: p_data => x_msg_data
1760: );
1761:

Line 1816: FND_MSG_PUB.initialize;

1812: END IF;
1813:
1814: -- Initialize message list if p_init_msg_list is set to TRUE.
1815: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1816: FND_MSG_PUB.initialize;
1817: END IF;
1818:
1819: -- Initialize API return status to success
1820: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1865: x_msg_data := FND_MSG_PUB.GET

1861: l_msg_index := 1;
1862: l_msg_count := x_msg_count;
1863:
1864: WHILE l_msg_count > 0 LOOP
1865: x_msg_data := FND_MSG_PUB.GET
1866: (l_msg_index,
1867: FND_API.G_FALSE );
1868: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_COUNTER_PRE API');
1869: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1898: x_msg_data := FND_MSG_PUB.GET

1894: l_msg_index := 1;
1895: l_msg_count := x_msg_count;
1896:
1897: WHILE l_msg_count > 0 LOOP
1898: x_msg_data := FND_MSG_PUB.GET
1899: (l_msg_index,
1900: FND_API.G_FALSE );
1901: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_COUNTER_PRE API');
1902: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1927: x_msg_data := FND_MSG_PUB.GET

1923: l_msg_index := 1;
1924: l_msg_count := x_msg_count;
1925:
1926: WHILE l_msg_count > 0 LOOP
1927: x_msg_data := FND_MSG_PUB.GET
1928: (l_msg_index,
1929: FND_API.G_FALSE );
1930: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_COUNTER API');
1931: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1997: x_msg_data := FND_MSG_PUB.GET

1993: l_msg_index := 1;
1994: l_msg_count := x_msg_count;
1995:
1996: WHILE l_msg_count > 0 LOOP
1997: x_msg_data := FND_MSG_PUB.GET
1998: (l_msg_index,
1999: FND_API.G_FALSE );
2000: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_PROPERTY API');
2001: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2026: x_msg_data := FND_MSG_PUB.GET

2022: l_msg_index := 1;
2023: l_msg_count := x_msg_count;
2024:
2025: WHILE l_msg_count > 0 LOOP
2026: x_msg_data := FND_MSG_PUB.GET
2027: (l_msg_index,
2028: FND_API.G_FALSE );
2029: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_PROPERTY API');
2030: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2094: x_msg_data := FND_MSG_PUB.GET

2090: l_msg_index := 1;
2091: l_msg_count := x_msg_count;
2092:
2093: WHILE l_msg_count > 0 LOOP
2094: x_msg_data := FND_MSG_PUB.GET
2095: (l_msg_index,
2096: FND_API.G_FALSE );
2097: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_RELATIONSHIP API');
2098: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2122: x_msg_data := FND_MSG_PUB.GET

2118: l_msg_index := 1;
2119: l_msg_count := x_msg_count;
2120:
2121: WHILE l_msg_count > 0 LOOP
2122: x_msg_data := FND_MSG_PUB.GET
2123: (l_msg_index,
2124: FND_API.G_FALSE );
2125: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_RELATIONSHIP API');
2126: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2163: x_msg_data := FND_MSG_PUB.GET

2159: l_msg_index := 1;
2160: l_msg_count := x_msg_count;
2161:
2162: WHILE l_msg_count > 0 LOOP
2163: x_msg_data := FND_MSG_PUB.GET
2164: (l_msg_index,
2165: FND_API.G_FALSE );
2166: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_DERIVED_FILTERS API');
2167: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2228: x_msg_data := FND_MSG_PUB.GET

2224: l_msg_index := 1;
2225: l_msg_count := x_msg_count;
2226:
2227: WHILE l_msg_count > 0 LOOP
2228: x_msg_data := FND_MSG_PUB.GET
2229: (l_msg_index,
2230: FND_API.G_FALSE );
2231: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_ASSOCIATIONS API');
2232: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2257: x_msg_data := FND_MSG_PUB.GET

2253: l_msg_index := 1;
2254: l_msg_count := x_msg_count;
2255:
2256: WHILE l_msg_count > 0 LOOP
2257: x_msg_data := FND_MSG_PUB.GET
2258: (l_msg_index,
2259: FND_API.G_FALSE );
2260: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS API');
2261: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2297: x_msg_data := FND_MSG_PUB.GET

2293: l_msg_index := 1;
2294: l_msg_count := x_msg_count;
2295:
2296: WHILE l_msg_count > 0 LOOP
2297: x_msg_data := FND_MSG_PUB.GET
2298: (l_msg_index,
2299: FND_API.G_FALSE );
2300: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_COUNTER_POST API');
2301: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2330: x_msg_data := FND_MSG_PUB.GET

2326: l_msg_index := 1;
2327: l_msg_count := x_msg_count;
2328:
2329: WHILE l_msg_count > 0 LOOP
2330: x_msg_data := FND_MSG_PUB.GET
2331: (l_msg_index,
2332: FND_API.G_FALSE );
2333: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_COUNTER_POST API');
2334: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2351: FND_MSG_PUB.Count_And_Get

2347: EXCEPTION
2348: WHEN FND_API.G_EXC_ERROR THEN
2349: x_return_status := FND_API.G_RET_STS_ERROR ;
2350: ROLLBACK TO update_counter_pub;
2351: FND_MSG_PUB.Count_And_Get
2352: (p_count => x_msg_count,
2353: p_data => x_msg_data
2354: );
2355:

Line 2359: FND_MSG_PUB.Count_And_Get

2355:
2356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358: ROLLBACK TO update_counter_pub;
2359: FND_MSG_PUB.Count_And_Get
2360: (p_count => x_msg_count,
2361: p_data => x_msg_data
2362: );
2363: WHEN OTHERS THEN

Line 2366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2362: );
2363: WHEN OTHERS THEN
2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2365: ROLLBACK TO update_counter_pub;
2366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2367: THEN
2368: FND_MSG_PUB.Add_Exc_Msg
2369: (G_PKG_NAME,
2370: l_api_name

Line 2368: FND_MSG_PUB.Add_Exc_Msg

2364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2365: ROLLBACK TO update_counter_pub;
2366: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2367: THEN
2368: FND_MSG_PUB.Add_Exc_Msg
2369: (G_PKG_NAME,
2370: l_api_name
2371: );
2372: END IF;

Line 2373: FND_MSG_PUB.Count_And_Get

2369: (G_PKG_NAME,
2370: l_api_name
2371: );
2372: END IF;
2373: FND_MSG_PUB.Count_And_Get
2374: (p_count => x_msg_count,
2375: p_data => x_msg_data
2376: );
2377:

Line 2425: FND_MSG_PUB.initialize;

2421: END IF;
2422:
2423: -- Initialize message list if p_init_msg_list is set to TRUE.
2424: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2425: FND_MSG_PUB.initialize;
2426: END IF;
2427:
2428: -- Initialize API return status to success
2429: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2470: x_msg_data := FND_MSG_PUB.GET

2466: l_msg_index := 1;
2467: l_msg_count := x_msg_count;
2468:
2469: WHILE l_msg_count > 0 LOOP
2470: x_msg_data := FND_MSG_PUB.GET
2471: (l_msg_index,
2472: FND_API.G_FALSE );
2473: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_PROPERTY_PRE API');
2474: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2499: x_msg_data := FND_MSG_PUB.GET

2495: l_msg_index := 1;
2496: l_msg_count := x_msg_count;
2497:
2498: WHILE l_msg_count > 0 LOOP
2499: x_msg_data := FND_MSG_PUB.GET
2500: (l_msg_index,
2501: FND_API.G_FALSE );
2502: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_CTR_PROPERTY_PRE API');
2503: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2565: x_msg_data := FND_MSG_PUB.GET

2561: l_msg_index := 1;
2562: l_msg_count := x_msg_count;
2563:
2564: WHILE l_msg_count > 0 LOOP
2565: x_msg_data := FND_MSG_PUB.GET
2566: (l_msg_index,
2567: FND_API.G_FALSE );
2568: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_PROPERTY API');
2569: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2599: x_msg_data := FND_MSG_PUB.GET

2595: l_msg_index := 1;
2596: l_msg_count := x_msg_count;
2597:
2598: WHILE l_msg_count > 0 LOOP
2599: x_msg_data := FND_MSG_PUB.GET
2600: (l_msg_index,
2601: FND_API.G_FALSE );
2602: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_PROPERTY_POST API');
2603: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2628: x_msg_data := FND_MSG_PUB.GET

2624: l_msg_index := 1;
2625: l_msg_count := x_msg_count;
2626:
2627: WHILE l_msg_count > 0 LOOP
2628: x_msg_data := FND_MSG_PUB.GET
2629: (l_msg_index,
2630: FND_API.G_FALSE );
2631: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_VUHK.UPDATE_CTR_PROPERTY_POST API');
2632: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2649: FND_MSG_PUB.Count_And_Get

2645: EXCEPTION
2646: WHEN FND_API.G_EXC_ERROR THEN
2647: x_return_status := FND_API.G_RET_STS_ERROR ;
2648: ROLLBACK TO update_ctr_property_pub;
2649: FND_MSG_PUB.Count_And_Get
2650: (p_count => x_msg_count,
2651: p_data => x_msg_data
2652: );
2653:

Line 2657: FND_MSG_PUB.Count_And_Get

2653:
2654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2655: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2656: ROLLBACK TO update_ctr_property_pub;
2657: FND_MSG_PUB.Count_And_Get
2658: (p_count => x_msg_count,
2659: p_data => x_msg_data
2660: );
2661: WHEN OTHERS THEN

Line 2664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2660: );
2661: WHEN OTHERS THEN
2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2663: ROLLBACK TO update_ctr_property_pub;
2664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2665: THEN
2666: FND_MSG_PUB.Add_Exc_Msg
2667: (G_PKG_NAME,
2668: l_api_name

Line 2666: FND_MSG_PUB.Add_Exc_Msg

2662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2663: ROLLBACK TO update_ctr_property_pub;
2664: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2665: THEN
2666: FND_MSG_PUB.Add_Exc_Msg
2667: (G_PKG_NAME,
2668: l_api_name
2669: );
2670: END IF;

Line 2671: FND_MSG_PUB.Count_And_Get

2667: (G_PKG_NAME,
2668: l_api_name
2669: );
2670: END IF;
2671: FND_MSG_PUB.Count_And_Get
2672: (p_count => x_msg_count,
2673: p_data => x_msg_data
2674: );
2675:

Line 2717: FND_MSG_PUB.initialize;

2713: END IF;
2714:
2715: -- Initialize message list if p_init_msg_list is set to TRUE.
2716: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2717: FND_MSG_PUB.initialize;
2718: END IF;
2719:
2720: -- Initialize API return status to success
2721: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2762: x_msg_data := FND_MSG_PUB.GET

2758: l_msg_index := 1;
2759: l_msg_count := x_msg_count;
2760:
2761: WHILE l_msg_count > 0 LOOP
2762: x_msg_data := FND_MSG_PUB.GET
2763: (l_msg_index,
2764: FND_API.G_FALSE );
2765: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_PRE API');
2766: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2792: x_msg_data := FND_MSG_PUB.GET

2788: l_msg_index := 1;
2789: l_msg_count := x_msg_count;
2790:
2791: WHILE l_msg_count > 0 LOOP
2792: x_msg_data := FND_MSG_PUB.GET
2793: (l_msg_index,
2794: FND_API.G_FALSE );
2795: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_PRE API');
2796: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2852: x_msg_data := FND_MSG_PUB.GET

2848: l_msg_index := 1;
2849: l_msg_count := x_msg_count;
2850:
2851: WHILE l_msg_count > 0 LOOP
2852: x_msg_data := FND_MSG_PUB.GET
2853: (l_msg_index,
2854: FND_API.G_FALSE );
2855: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.UPDATE_CTR_ASSOCIATIONS API');
2856: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2886: x_msg_data := FND_MSG_PUB.GET

2882: l_msg_index := 1;
2883: l_msg_count := x_msg_count;
2884:
2885: WHILE l_msg_count > 0 LOOP
2886: x_msg_data := FND_MSG_PUB.GET
2887: (l_msg_index,
2888: FND_API.G_FALSE );
2889: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_POST API');
2890: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2916: x_msg_data := FND_MSG_PUB.GET

2912: l_msg_index := 1;
2913: l_msg_count := x_msg_count;
2914:
2915: WHILE l_msg_count > 0 LOOP
2916: x_msg_data := FND_MSG_PUB.GET
2917: (l_msg_index,
2918: FND_API.G_FALSE );
2919: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_CUHK.UPDATE_CTR_ASSOCIATIONS_POST API');
2920: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2937: FND_MSG_PUB.Count_And_Get

2933: EXCEPTION
2934: WHEN FND_API.G_EXC_ERROR THEN
2935: x_return_status := FND_API.G_RET_STS_ERROR ;
2936: ROLLBACK TO update_ctr_associations_pub;
2937: FND_MSG_PUB.Count_And_Get
2938: (p_count => x_msg_count,
2939: p_data => x_msg_data
2940: );
2941:

Line 2945: FND_MSG_PUB.Count_And_Get

2941:
2942: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2944: ROLLBACK TO update_ctr_associations_pub;
2945: FND_MSG_PUB.Count_And_Get
2946: (p_count => x_msg_count,
2947: p_data => x_msg_data
2948: );
2949: WHEN OTHERS THEN

Line 2952: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2948: );
2949: WHEN OTHERS THEN
2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: ROLLBACK TO update_ctr_associations_pub;
2952: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2953: THEN
2954: FND_MSG_PUB.Add_Exc_Msg
2955: (G_PKG_NAME,
2956: l_api_name

Line 2954: FND_MSG_PUB.Add_Exc_Msg

2950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2951: ROLLBACK TO update_ctr_associations_pub;
2952: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2953: THEN
2954: FND_MSG_PUB.Add_Exc_Msg
2955: (G_PKG_NAME,
2956: l_api_name
2957: );
2958: END IF;

Line 2959: FND_MSG_PUB.Count_And_Get

2955: (G_PKG_NAME,
2956: l_api_name
2957: );
2958: END IF;
2959: FND_MSG_PUB.Count_And_Get
2960: (p_count => x_msg_count,
2961: p_data => x_msg_data
2962: );
2963: