eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_COUNTER_TEMPLATE_PUB dependencies on FND_MSG_PUB

Line 87: FND_MSG_PUB.initialize;

83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean( p_init_msg_list ) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Initialize API return status to success
91: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 132: x_msg_data := FND_MSG_PUB.GET

128: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
129: l_msg_index := 1;
130: l_msg_count := x_msg_count;
131: WHILE l_msg_count > 0 LOOP
132: x_msg_data := FND_MSG_PUB.GET
133: ( l_msg_index,
134: FND_API.G_FALSE
135: );
136: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.CREATE_COUNTER_GROUP_PRE API ');

Line 163: x_msg_data := FND_MSG_PUB.GET

159: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
160: l_msg_index := 1;
161: l_msg_count := x_msg_count;
162: WHILE l_msg_count > 0 LOOP
163: x_msg_data := FND_MSG_PUB.GET
164: ( l_msg_index,
165: FND_API.G_FALSE
166: );
167: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_PRE API ');

Line 193: x_msg_data := FND_MSG_PUB.GET

189: l_msg_index := 1;
190: l_msg_count := x_msg_count;
191:
192: WHILE l_msg_count > 0 LOOP
193: x_msg_data := FND_MSG_PUB.GET
194: (l_msg_index,
195: FND_API.G_FALSE );
196: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_GROUP');
197: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 225: x_msg_data := FND_MSG_PUB.GET

221: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
222: l_msg_index := 1;
223: l_msg_count := x_msg_count;
224: WHILE l_msg_count > 0 LOOP
225: x_msg_data := FND_MSG_PUB.GET
226: ( l_msg_index,
227: FND_API.G_FALSE );
228: csi_gen_utility_pvt.put_line('ERROR FROM CSI_ITEM_INSTANCE_CUHK.Create_Item_Instance_Post API ');
229: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 265: x_msg_data := FND_MSG_PUB.GET

261: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
262: l_msg_index := 1;
263: l_msg_count := x_msg_count;
264: WHILE l_msg_count > 0 LOOP
265: x_msg_data := FND_MSG_PUB.GET
266: ( l_msg_index,
267: FND_API.G_FALSE );
268: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_COUNTER_GROUP_Post API ');
269: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 311: x_msg_data := FND_MSG_PUB.GET

307: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
308: l_msg_index := 1;
309: l_msg_count := x_msg_count;
310: WHILE l_msg_count > 0 LOOP
311: x_msg_data := FND_MSG_PUB.GET
312: (l_msg_index,
313: FND_API.G_FALSE);
314: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
315: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 336: FND_MSG_PUB.Count_And_Get

332: EXCEPTION
333: WHEN FND_API.G_EXC_ERROR THEN
334: x_return_status := FND_API.G_RET_STS_ERROR ;
335: ROLLBACK TO create_counter_group;
336: FND_MSG_PUB.Count_And_Get
337: (p_count => x_msg_count,
338: p_data => x_msg_data
339: );
340:

Line 344: FND_MSG_PUB.Count_And_Get

340:
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
343: ROLLBACK TO create_counter_group;
344: FND_MSG_PUB.Count_And_Get
345: (p_count => x_msg_count,
346: p_data => x_msg_data
347: );
348: WHEN OTHERS THEN

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

347: );
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: ROLLBACK TO create_counter_group;
351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: FND_MSG_PUB.Add_Exc_Msg
354: (G_PKG_NAME,
355: l_api_name

Line 353: FND_MSG_PUB.Add_Exc_Msg

349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
350: ROLLBACK TO create_counter_group;
351: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
352: THEN
353: FND_MSG_PUB.Add_Exc_Msg
354: (G_PKG_NAME,
355: l_api_name
356: );
357: END IF;

Line 358: FND_MSG_PUB.Count_And_Get

354: (G_PKG_NAME,
355: l_api_name
356: );
357: END IF;
358: FND_MSG_PUB.Count_And_Get
359: (p_count => x_msg_count,
360: p_data => x_msg_data
361: );
362:

Line 429: FND_MSG_PUB.initialize;

425: END IF;
426:
427: -- Initialize message list if p_init_msg_list is set to TRUE.
428: IF FND_API.to_Boolean( p_init_msg_list ) THEN
429: FND_MSG_PUB.initialize;
430: END IF;
431:
432: -- Initialize API return status to success
433: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 473: x_msg_data := FND_MSG_PUB.GET

469: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
470: l_msg_index := 1;
471: l_msg_count := x_msg_count;
472: WHILE l_msg_count > 0 LOOP
473: x_msg_data := FND_MSG_PUB.GET
474: ( l_msg_index,
475: FND_API.G_FALSE
476: );
477: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.CREATE_ITEM_ASSOCIATION_PRE API ');

Line 503: x_msg_data := FND_MSG_PUB.GET

499: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
500: l_msg_index := 1;
501: l_msg_count := x_msg_count;
502: WHILE l_msg_count > 0 LOOP
503: x_msg_data := FND_MSG_PUB.GET
504: ( l_msg_index,
505: FND_API.G_FALSE
506: );
507: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_PRE API ');

Line 533: x_msg_data := FND_MSG_PUB.GET

529: l_msg_index := 1;
530: l_msg_count := x_msg_count;
531:
532: WHILE l_msg_count > 0 LOOP
533: x_msg_data := FND_MSG_PUB.GET
534: (l_msg_index,
535: FND_API.G_FALSE );
536: csi_ctr_gen_utility_pvt.put_line(' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_ITEM_ASSOCIATION');
537: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 564: x_msg_data := FND_MSG_PUB.GET

560: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
561: l_msg_index := 1;
562: l_msg_count := x_msg_count;
563: WHILE l_msg_count > 0 LOOP
564: x_msg_data := FND_MSG_PUB.GET
565: ( l_msg_index,
566: FND_API.G_FALSE );
567: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.CREATE_ITEM_ASSOCIATION_Post API ');
568: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 603: x_msg_data := FND_MSG_PUB.GET

599: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
600: l_msg_index := 1;
601: l_msg_count := x_msg_count;
602: WHILE l_msg_count > 0 LOOP
603: x_msg_data := FND_MSG_PUB.GET
604: ( l_msg_index,
605: FND_API.G_FALSE );
606: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.CREATE_ITEM_ASSOCIATION_Post API ');
607: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 633: FND_MSG_PUB.Count_And_Get

629: EXCEPTION
630: WHEN FND_API.G_EXC_ERROR THEN
631: x_return_status := FND_API.G_RET_STS_ERROR ;
632: ROLLBACK TO create_item_association;
633: FND_MSG_PUB.Count_And_Get
634: (p_count => x_msg_count,
635: p_data => x_msg_data
636: );
637:

Line 641: FND_MSG_PUB.Count_And_Get

637:
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
640: ROLLBACK TO create_item_association;
641: FND_MSG_PUB.Count_And_Get
642: (p_count => x_msg_count,
643: p_data => x_msg_data
644: );
645: WHEN OTHERS THEN

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

644: );
645: WHEN OTHERS THEN
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647: ROLLBACK TO create_item_association;
648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
649: THEN
650: FND_MSG_PUB.Add_Exc_Msg
651: (G_PKG_NAME,
652: l_api_name

Line 650: FND_MSG_PUB.Add_Exc_Msg

646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
647: ROLLBACK TO create_item_association;
648: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
649: THEN
650: FND_MSG_PUB.Add_Exc_Msg
651: (G_PKG_NAME,
652: l_api_name
653: );
654: END IF;

Line 655: FND_MSG_PUB.Count_And_Get

651: (G_PKG_NAME,
652: l_api_name
653: );
654: END IF;
655: FND_MSG_PUB.Count_And_Get
656: (p_count => x_msg_count,
657: p_data => x_msg_data
658: );
659:

Line 734: FND_MSG_PUB.initialize;

730: END IF;
731:
732: -- Initialize message list if p_init_msg_list is set to TRUE.
733: IF FND_API.to_Boolean( p_init_msg_list ) THEN
734: FND_MSG_PUB.initialize;
735: END IF;
736:
737: -- Initialize API return status to success
738: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 781: x_msg_data := FND_MSG_PUB.GET

777: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
778: l_msg_index := 1;
779: l_msg_count := x_msg_count;
780: WHILE l_msg_count > 0 LOOP
781: x_msg_data := FND_MSG_PUB.GET
782: ( l_msg_index,
783: FND_API.G_FALSE
784: );
785: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_counter_template_pre API ');

Line 815: x_msg_data := FND_MSG_PUB.GET

811: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
812: l_msg_index := 1;
813: l_msg_count := x_msg_count;
814: WHILE l_msg_count > 0 LOOP
815: x_msg_data := FND_MSG_PUB.GET
816: ( l_msg_index,
817: FND_API.G_FALSE
818: );
819: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_pre API ');

Line 845: x_msg_data := FND_MSG_PUB.GET

841: l_msg_index := 1;
842: l_msg_count := x_msg_count;
843:
844: WHILE l_msg_count > 0 LOOP
845: x_msg_data := FND_MSG_PUB.GET
846: (l_msg_index,
847: FND_API.G_FALSE );
848: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_TEMPLATE');
849: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 880: x_msg_data := FND_MSG_PUB.GET

876: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
877: l_msg_index := 1;
878: l_msg_count := x_msg_count;
879: WHILE l_msg_count > 0 LOOP
880: x_msg_data := FND_MSG_PUB.GET
881: ( l_msg_index,
882: FND_API.G_FALSE );
883: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_counter_template_Post API ');
884: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 923: x_msg_data := FND_MSG_PUB.GET

919: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
920: l_msg_index := 1;
921: l_msg_count := x_msg_count;
922: WHILE l_msg_count > 0 LOOP
923: x_msg_data := FND_MSG_PUB.GET
924: ( l_msg_index,
925: FND_API.G_FALSE );
926: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_counter_template_Post API ');
927: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 965: x_msg_data := FND_MSG_PUB.GET

961: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
962: l_msg_index := 1;
963: l_msg_count := x_msg_count;
964: WHILE l_msg_count > 0 LOOP
965: x_msg_data := FND_MSG_PUB.GET
966: (l_msg_index,
967: FND_API.G_FALSE);
968: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
969: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1001: x_msg_data := FND_MSG_PUB.GET

997: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
998: l_msg_index := 1;
999: l_msg_count := x_msg_count;
1000: WHILE l_msg_count > 0 LOOP
1001: x_msg_data := FND_MSG_PUB.GET
1002: (l_msg_index,
1003: FND_API.G_FALSE);
1004: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_CTR_PROPERTY_TEMPLATE');
1005: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1047: x_msg_data := FND_MSG_PUB.GET

1043: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1044: l_msg_index := 1;
1045: l_msg_count := x_msg_count;
1046: WHILE l_msg_count > 0 LOOP
1047: x_msg_data := FND_MSG_PUB.GET
1048: (l_msg_index,
1049: FND_API.G_FALSE);
1050: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_COUNTER_RELATIONSHIP');
1051: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1085: x_msg_data := FND_MSG_PUB.GET

1081: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1082: l_msg_index := 1;
1083: l_msg_count := x_msg_count;
1084: WHILE l_msg_count > 0 LOOP
1085: x_msg_data := FND_MSG_PUB.GET
1086: (l_msg_index,
1087: FND_API.G_FALSE);
1088: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_DERIVED_FILTERS');
1089: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1109: FND_MSG_PUB.Count_And_Get

1105: EXCEPTION
1106: WHEN FND_API.G_EXC_ERROR THEN
1107: x_return_status := FND_API.G_RET_STS_ERROR ;
1108: ROLLBACK TO create_counter_template;
1109: FND_MSG_PUB.Count_And_Get
1110: (p_count => x_msg_count,
1111: p_data => x_msg_data
1112: );
1113:

Line 1117: FND_MSG_PUB.Count_And_Get

1113:
1114: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1116: ROLLBACK TO create_counter_template;
1117: FND_MSG_PUB.Count_And_Get
1118: (p_count => x_msg_count,
1119: p_data => x_msg_data
1120: );
1121: WHEN OTHERS THEN

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

1120: );
1121: WHEN OTHERS THEN
1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1123: ROLLBACK TO create_counter_template;
1124: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1125: THEN
1126: FND_MSG_PUB.Add_Exc_Msg
1127: (G_PKG_NAME,
1128: l_api_name

Line 1126: FND_MSG_PUB.Add_Exc_Msg

1122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1123: ROLLBACK TO create_counter_template;
1124: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1125: THEN
1126: FND_MSG_PUB.Add_Exc_Msg
1127: (G_PKG_NAME,
1128: l_api_name
1129: );
1130: END IF;

Line 1131: FND_MSG_PUB.Count_And_Get

1127: (G_PKG_NAME,
1128: l_api_name
1129: );
1130: END IF;
1131: FND_MSG_PUB.Count_And_Get
1132: (p_count => x_msg_count,
1133: p_data => x_msg_data
1134: );
1135:

Line 1201: FND_MSG_PUB.initialize;

1197: END IF;
1198:
1199: -- Initialize message list if p_init_msg_list is set to TRUE.
1200: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1201: FND_MSG_PUB.initialize;
1202: END IF;
1203:
1204: -- Initialize API return status to success
1205: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1244: x_msg_data := FND_MSG_PUB.GET

1240: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1241: l_msg_index := 1;
1242: l_msg_count := x_msg_count;
1243: WHILE l_msg_count > 0 LOOP
1244: x_msg_data := FND_MSG_PUB.GET
1245: ( l_msg_index,
1246: FND_API.G_FALSE
1247: );
1248: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_prop_template_pre API ');

Line 1274: x_msg_data := FND_MSG_PUB.GET

1270: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1271: l_msg_index := 1;
1272: l_msg_count := x_msg_count;
1273: WHILE l_msg_count > 0 LOOP
1274: x_msg_data := FND_MSG_PUB.GET
1275: ( l_msg_index,
1276: FND_API.G_FALSE
1277: );
1278: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_pre API ');

Line 1304: x_msg_data := FND_MSG_PUB.GET

1300: l_msg_index := 1;
1301: l_msg_count := x_msg_count;
1302:
1303: WHILE l_msg_count > 0 LOOP
1304: x_msg_data := FND_MSG_PUB.GET
1305: (l_msg_index,
1306: FND_API.G_FALSE );
1307: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_CTR_PROPERTY_TEMPLATE');
1308: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1335: x_msg_data := FND_MSG_PUB.GET

1331: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1332: l_msg_index := 1;
1333: l_msg_count := x_msg_count;
1334: WHILE l_msg_count > 0 LOOP
1335: x_msg_data := FND_MSG_PUB.GET
1336: ( l_msg_index,
1337: FND_API.G_FALSE );
1338: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_prop_template_Post API ');
1339: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1374: x_msg_data := FND_MSG_PUB.GET

1370: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1371: l_msg_index := 1;
1372: l_msg_count := x_msg_count;
1373: WHILE l_msg_count > 0 LOOP
1374: x_msg_data := FND_MSG_PUB.GET
1375: ( l_msg_index,
1376: FND_API.G_FALSE );
1377: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_prop_template_Post API ');
1378: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1404: FND_MSG_PUB.Count_And_Get

1400: EXCEPTION
1401: WHEN FND_API.G_EXC_ERROR THEN
1402: x_return_status := FND_API.G_RET_STS_ERROR ;
1403: ROLLBACK TO create_ctr_property_template;
1404: FND_MSG_PUB.Count_And_Get
1405: (p_count => x_msg_count,
1406: p_data => x_msg_data
1407: );
1408:

Line 1412: FND_MSG_PUB.Count_And_Get

1408:
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1411: ROLLBACK TO create_ctr_property_template;
1412: FND_MSG_PUB.Count_And_Get
1413: (p_count => x_msg_count,
1414: p_data => x_msg_data
1415: );
1416: WHEN OTHERS THEN

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

1415: );
1416: WHEN OTHERS THEN
1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1418: ROLLBACK TO create_ctr_property_template;
1419: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1420: THEN
1421: FND_MSG_PUB.Add_Exc_Msg
1422: (G_PKG_NAME,
1423: l_api_name

Line 1421: FND_MSG_PUB.Add_Exc_Msg

1417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1418: ROLLBACK TO create_ctr_property_template;
1419: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1420: THEN
1421: FND_MSG_PUB.Add_Exc_Msg
1422: (G_PKG_NAME,
1423: l_api_name
1424: );
1425: END IF;

Line 1426: FND_MSG_PUB.Count_And_Get

1422: (G_PKG_NAME,
1423: l_api_name
1424: );
1425: END IF;
1426: FND_MSG_PUB.Count_And_Get
1427: (p_count => x_msg_count,
1428: p_data => x_msg_data
1429: );
1430:

Line 1495: FND_MSG_PUB.initialize;

1491: END IF;
1492:
1493: -- Initialize message list if p_init_msg_list is set to TRUE.
1494: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1495: FND_MSG_PUB.initialize;
1496: END IF;
1497:
1498: -- Initialize API return status to success
1499: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1538: x_msg_data := FND_MSG_PUB.GET

1534: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1535: l_msg_index := 1;
1536: l_msg_count := x_msg_count;
1537: WHILE l_msg_count > 0 LOOP
1538: x_msg_data := FND_MSG_PUB.GET
1539: ( l_msg_index,
1540: FND_API.G_FALSE
1541: );
1542: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_relationship_pre API ');

Line 1568: x_msg_data := FND_MSG_PUB.GET

1564: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1565: l_msg_index := 1;
1566: l_msg_count := x_msg_count;
1567: WHILE l_msg_count > 0 LOOP
1568: x_msg_data := FND_MSG_PUB.GET
1569: ( l_msg_index,
1570: FND_API.G_FALSE
1571: );
1572: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_pre API ');

Line 1598: x_msg_data := FND_MSG_PUB.GET

1594: l_msg_index := 1;
1595: l_msg_count := x_msg_count;
1596:
1597: WHILE l_msg_count > 0 LOOP
1598: x_msg_data := FND_MSG_PUB.GET
1599: (l_msg_index,
1600: FND_API.G_FALSE );
1601: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_RELATIONSHIP');
1602: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1629: x_msg_data := FND_MSG_PUB.GET

1625: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1626: l_msg_index := 1;
1627: l_msg_count := x_msg_count;
1628: WHILE l_msg_count > 0 LOOP
1629: x_msg_data := FND_MSG_PUB.GET
1630: ( l_msg_index,
1631: FND_API.G_FALSE );
1632: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_ctr_relationship_Post API ');
1633: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1668: x_msg_data := FND_MSG_PUB.GET

1664: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1665: l_msg_index := 1;
1666: l_msg_count := x_msg_count;
1667: WHILE l_msg_count > 0 LOOP
1668: x_msg_data := FND_MSG_PUB.GET
1669: ( l_msg_index,
1670: FND_API.G_FALSE );
1671: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_ctr_relationship_Post API ');
1672: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1698: FND_MSG_PUB.Count_And_Get

1694: EXCEPTION
1695: WHEN FND_API.G_EXC_ERROR THEN
1696: x_return_status := FND_API.G_RET_STS_ERROR ;
1697: ROLLBACK TO create_counter_relationship;
1698: FND_MSG_PUB.Count_And_Get
1699: (p_count => x_msg_count,
1700: p_data => x_msg_data
1701: );
1702:

Line 1706: FND_MSG_PUB.Count_And_Get

1702:
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1705: ROLLBACK TO create_counter_relationship;
1706: FND_MSG_PUB.Count_And_Get
1707: (p_count => x_msg_count,
1708: p_data => x_msg_data
1709: );
1710: WHEN OTHERS THEN

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

1709: );
1710: WHEN OTHERS THEN
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1712: ROLLBACK TO create_counter_relationship;
1713: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1714: THEN
1715: FND_MSG_PUB.Add_Exc_Msg
1716: (G_PKG_NAME,
1717: l_api_name

Line 1715: FND_MSG_PUB.Add_Exc_Msg

1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1712: ROLLBACK TO create_counter_relationship;
1713: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1714: THEN
1715: FND_MSG_PUB.Add_Exc_Msg
1716: (G_PKG_NAME,
1717: l_api_name
1718: );
1719: END IF;

Line 1720: FND_MSG_PUB.Count_And_Get

1716: (G_PKG_NAME,
1717: l_api_name
1718: );
1719: END IF;
1720: FND_MSG_PUB.Count_And_Get
1721: (p_count => x_msg_count,
1722: p_data => x_msg_data
1723: );
1724:

Line 1784: FND_MSG_PUB.initialize;

1780: END IF;
1781:
1782: -- Initialize message list if p_init_msg_list is set to TRUE.
1783: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1784: FND_MSG_PUB.initialize;
1785: END IF;
1786:
1787: -- Initialize API return status to success
1788: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1827: x_msg_data := FND_MSG_PUB.GET

1823: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1824: l_msg_index := 1;
1825: l_msg_count := x_msg_count;
1826: WHILE l_msg_count > 0 LOOP
1827: x_msg_data := FND_MSG_PUB.GET
1828: ( l_msg_index,
1829: FND_API.G_FALSE
1830: );
1831: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_derived_filters_pre API ');

Line 1857: x_msg_data := FND_MSG_PUB.GET

1853: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1854: l_msg_index := 1;
1855: l_msg_count := x_msg_count;
1856: WHILE l_msg_count > 0 LOOP
1857: x_msg_data := FND_MSG_PUB.GET
1858: ( l_msg_index,
1859: FND_API.G_FALSE
1860: );
1861: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_pre API ');

Line 1887: x_msg_data := FND_MSG_PUB.GET

1883: l_msg_index := 1;
1884: l_msg_count := x_msg_count;
1885:
1886: WHILE l_msg_count > 0 LOOP
1887: x_msg_data := FND_MSG_PUB.GET
1888: (l_msg_index,
1889: FND_API.G_FALSE );
1890: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');
1891: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1918: x_msg_data := FND_MSG_PUB.GET

1914: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1915: l_msg_index := 1;
1916: l_msg_count := x_msg_count;
1917: WHILE l_msg_count > 0 LOOP
1918: x_msg_data := FND_MSG_PUB.GET
1919: ( l_msg_index,
1920: FND_API.G_FALSE );
1921: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_derived_filters_Post API ');
1922: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1957: x_msg_data := FND_MSG_PUB.GET

1953: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1954: l_msg_index := 1;
1955: l_msg_count := x_msg_count;
1956: WHILE l_msg_count > 0 LOOP
1957: x_msg_data := FND_MSG_PUB.GET
1958: ( l_msg_index,
1959: FND_API.G_FALSE );
1960: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_derived_filters_Post API ');
1961: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 1986: FND_MSG_PUB.Count_And_Get

1982: EXCEPTION
1983: WHEN FND_API.G_EXC_ERROR THEN
1984: x_return_status := FND_API.G_RET_STS_ERROR ;
1985: ROLLBACK TO create_derived_filters;
1986: FND_MSG_PUB.Count_And_Get
1987: (p_count => x_msg_count,
1988: p_data => x_msg_data
1989: );
1990:

Line 1994: FND_MSG_PUB.Count_And_Get

1990:
1991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1993: ROLLBACK TO create_derived_filters;
1994: FND_MSG_PUB.Count_And_Get
1995: (p_count => x_msg_count,
1996: p_data => x_msg_data
1997: );
1998:

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

1998:
1999: WHEN OTHERS THEN
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2001: ROLLBACK TO create_derived_filters;
2002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2003: THEN
2004: FND_MSG_PUB.Add_Exc_Msg
2005: (G_PKG_NAME,
2006: l_api_name

Line 2004: FND_MSG_PUB.Add_Exc_Msg

2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2001: ROLLBACK TO create_derived_filters;
2002: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2003: THEN
2004: FND_MSG_PUB.Add_Exc_Msg
2005: (G_PKG_NAME,
2006: l_api_name
2007: );
2008: END IF;

Line 2009: FND_MSG_PUB.Count_And_Get

2005: (G_PKG_NAME,
2006: l_api_name
2007: );
2008: END IF;
2009: FND_MSG_PUB.Count_And_Get
2010: (p_count => x_msg_count,
2011: p_data => x_msg_data
2012: );
2013:

Line 2090: FND_MSG_PUB.initialize;

2086: END IF;
2087:
2088: -- Initialize message list if p_init_msg_list is set to TRUE.
2089: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2090: FND_MSG_PUB.initialize;
2091: END IF;
2092:
2093: -- Initialize API return status to success
2094: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2134: x_msg_data := FND_MSG_PUB.GET

2130: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2131: l_msg_index := 1;
2132: l_msg_count := x_msg_count;
2133: WHILE l_msg_count > 0 LOOP
2134: x_msg_data := FND_MSG_PUB.GET
2135: ( l_msg_index,
2136: FND_API.G_FALSE
2137: );
2138: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_pre API ');

Line 2165: x_msg_data := FND_MSG_PUB.GET

2161: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2162: l_msg_index := 1;
2163: l_msg_count := x_msg_count;
2164: WHILE l_msg_count > 0 LOOP
2165: x_msg_data := FND_MSG_PUB.GET
2166: ( l_msg_index,
2167: FND_API.G_FALSE
2168: );
2169: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_pre API ');

Line 2195: x_msg_data := FND_MSG_PUB.GET

2191: l_msg_index := 1;
2192: l_msg_count := x_msg_count;
2193:
2194: WHILE l_msg_count > 0 LOOP
2195: x_msg_data := FND_MSG_PUB.GET
2196: (l_msg_index,
2197: FND_API.G_FALSE );
2198: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_GROUP');
2199: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2227: x_msg_data := FND_MSG_PUB.GET

2223: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2224: l_msg_index := 1;
2225: l_msg_count := x_msg_count;
2226: WHILE l_msg_count > 0 LOOP
2227: x_msg_data := FND_MSG_PUB.GET
2228: ( l_msg_index,
2229: FND_API.G_FALSE );
2230: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_group_Post API ');
2231: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2267: x_msg_data := FND_MSG_PUB.GET

2263: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2264: l_msg_index := 1;
2265: l_msg_count := x_msg_count;
2266: WHILE l_msg_count > 0 LOOP
2267: x_msg_data := FND_MSG_PUB.GET
2268: ( l_msg_index,
2269: FND_API.G_FALSE );
2270: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_group_Post API ');
2271: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2312: x_msg_data := FND_MSG_PUB.GET

2308: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2309: l_msg_index := 1;
2310: l_msg_count := x_msg_count;
2311: WHILE l_msg_count > 0 LOOP
2312: x_msg_data := FND_MSG_PUB.GET
2313: (l_msg_index,
2314: FND_API.G_FALSE);
2315: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
2316: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data); l_msg_index := l_msg_index + 1;

Line 2343: x_msg_data := FND_MSG_PUB.GET

2339: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2340: l_msg_index := 1;
2341: l_msg_count := x_msg_count;
2342: WHILE l_msg_count > 0 LOOP
2343: x_msg_data := FND_MSG_PUB.GET
2344: (l_msg_index,
2345: FND_API.G_FALSE);
2346: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
2347: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data); l_msg_index := l_msg_index + 1;

Line 2371: x_msg_data := FND_MSG_PUB.GET

2367: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2368: l_msg_index := 1;
2369: l_msg_count := x_msg_count;
2370: WHILE l_msg_count > 0 LOOP
2371: x_msg_data := FND_MSG_PUB.GET
2372: (l_msg_index,
2373: FND_API.G_FALSE);
2374: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');
2375: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2397: FND_MSG_PUB.Count_And_Get

2393: EXCEPTION
2394: WHEN FND_API.G_EXC_ERROR THEN
2395: x_return_status := FND_API.G_RET_STS_ERROR ;
2396: ROLLBACK TO update_counter_group;
2397: FND_MSG_PUB.Count_And_Get
2398: (p_count => x_msg_count,
2399: p_data => x_msg_data
2400: );
2401:

Line 2405: FND_MSG_PUB.Count_And_Get

2401:
2402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2404: ROLLBACK TO update_counter_group;
2405: FND_MSG_PUB.Count_And_Get
2406: (p_count => x_msg_count,
2407: p_data => x_msg_data
2408: );
2409: WHEN OTHERS THEN

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

2408: );
2409: WHEN OTHERS THEN
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2411: ROLLBACK TO update_counter_group;
2412: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2413: THEN
2414: FND_MSG_PUB.Add_Exc_Msg
2415: (G_PKG_NAME,
2416: l_api_name

Line 2414: FND_MSG_PUB.Add_Exc_Msg

2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2411: ROLLBACK TO update_counter_group;
2412: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2413: THEN
2414: FND_MSG_PUB.Add_Exc_Msg
2415: (G_PKG_NAME,
2416: l_api_name
2417: );
2418: END IF;

Line 2419: FND_MSG_PUB.Count_And_Get

2415: (G_PKG_NAME,
2416: l_api_name
2417: );
2418: END IF;
2419: FND_MSG_PUB.Count_And_Get
2420: (p_count => x_msg_count,
2421: p_data => x_msg_data
2422: );
2423:

Line 2490: FND_MSG_PUB.initialize;

2486: END IF;
2487:
2488: -- Initialize message list if p_init_msg_list is set to TRUE.
2489: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2490: FND_MSG_PUB.initialize;
2491: END IF;
2492:
2493: -- Initialize API return status to success
2494: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2533: x_msg_data := FND_MSG_PUB.GET

2529: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2530: l_msg_index := 1;
2531: l_msg_count := x_msg_count;
2532: WHILE l_msg_count > 0 LOOP
2533: x_msg_data := FND_MSG_PUB.GET
2534: ( l_msg_index,
2535: FND_API.G_FALSE
2536: );
2537: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_item_association_pre API ');

Line 2563: x_msg_data := FND_MSG_PUB.GET

2559: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2560: l_msg_index := 1;
2561: l_msg_count := x_msg_count;
2562: WHILE l_msg_count > 0 LOOP
2563: x_msg_data := FND_MSG_PUB.GET
2564: ( l_msg_index,
2565: FND_API.G_FALSE
2566: );
2567: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_item_association_pre API ');

Line 2593: x_msg_data := FND_MSG_PUB.GET

2589: l_msg_index := 1;
2590: l_msg_count := x_msg_count;
2591:
2592: WHILE l_msg_count > 0 LOOP
2593: x_msg_data := FND_MSG_PUB.GET
2594: (l_msg_index,
2595: FND_API.G_FALSE );
2596: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ITEM_ASSOCIATION');
2597: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2624: x_msg_data := FND_MSG_PUB.GET

2620: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2621: l_msg_index := 1;
2622: l_msg_count := x_msg_count;
2623: WHILE l_msg_count > 0 LOOP
2624: x_msg_data := FND_MSG_PUB.GET
2625: ( l_msg_index,
2626: FND_API.G_FALSE );
2627: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_item_association_Post API ');
2628: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2663: x_msg_data := FND_MSG_PUB.GET

2659: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2660: l_msg_index := 1;
2661: l_msg_count := x_msg_count;
2662: WHILE l_msg_count > 0 LOOP
2663: x_msg_data := FND_MSG_PUB.GET
2664: ( l_msg_index,
2665: FND_API.G_FALSE );
2666: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_item_association_Post API ');
2667: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2692: FND_MSG_PUB.Count_And_Get

2688: EXCEPTION
2689: WHEN FND_API.G_EXC_ERROR THEN
2690: x_return_status := FND_API.G_RET_STS_ERROR ;
2691: ROLLBACK TO update_item_association;
2692: FND_MSG_PUB.Count_And_Get
2693: (p_count => x_msg_count,
2694: p_data => x_msg_data
2695: );
2696:

Line 2700: FND_MSG_PUB.Count_And_Get

2696:
2697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2699: ROLLBACK TO update_item_association;
2700: FND_MSG_PUB.Count_And_Get
2701: (p_count => x_msg_count,
2702: p_data => x_msg_data
2703: );
2704: WHEN OTHERS THEN

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

2703: );
2704: WHEN OTHERS THEN
2705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2706: ROLLBACK TO update_item_association;
2707: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2708: THEN
2709: FND_MSG_PUB.Add_Exc_Msg
2710: (G_PKG_NAME,
2711: l_api_name

Line 2709: FND_MSG_PUB.Add_Exc_Msg

2705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2706: ROLLBACK TO update_item_association;
2707: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2708: THEN
2709: FND_MSG_PUB.Add_Exc_Msg
2710: (G_PKG_NAME,
2711: l_api_name
2712: );
2713: END IF;

Line 2714: FND_MSG_PUB.Count_And_Get

2710: (G_PKG_NAME,
2711: l_api_name
2712: );
2713: END IF;
2714: FND_MSG_PUB.Count_And_Get
2715: (p_count => x_msg_count,
2716: p_data => x_msg_data
2717: );
2718:

Line 2793: FND_MSG_PUB.initialize;

2789: END IF;
2790:
2791: -- Initialize message list if p_init_msg_list is set to TRUE.
2792: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2793: FND_MSG_PUB.initialize;
2794: END IF;
2795:
2796: -- Initialize API return status to success
2797: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2840: x_msg_data := FND_MSG_PUB.GET

2836: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2837: l_msg_index := 1;
2838: l_msg_count := x_msg_count;
2839: WHILE l_msg_count > 0 LOOP
2840: x_msg_data := FND_MSG_PUB.GET
2841: ( l_msg_index,
2842: FND_API.G_FALSE
2843: );
2844: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_pre API ');

Line 2874: x_msg_data := FND_MSG_PUB.GET

2870: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2871: l_msg_index := 1;
2872: l_msg_count := x_msg_count;
2873: WHILE l_msg_count > 0 LOOP
2874: x_msg_data := FND_MSG_PUB.GET
2875: ( l_msg_index,
2876: FND_API.G_FALSE
2877: );
2878: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_pre API ');

Line 2906: x_msg_data := FND_MSG_PUB.GET

2902: l_msg_index := 1;
2903: l_msg_count := x_msg_count;
2904:
2905: WHILE l_msg_count > 0 LOOP
2906: x_msg_data := FND_MSG_PUB.GET
2907: (l_msg_index,
2908: FND_API.G_FALSE );
2909: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_TEMPLATE');
2910: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2941: x_msg_data := FND_MSG_PUB.GET

2937: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2938: l_msg_index := 1;
2939: l_msg_count := x_msg_count;
2940: WHILE l_msg_count > 0 LOOP
2941: x_msg_data := FND_MSG_PUB.GET
2942: ( l_msg_index,
2943: FND_API.G_FALSE );
2944: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_counter_template_Post API ');
2945: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2984: x_msg_data := FND_MSG_PUB.GET

2980: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2981: l_msg_index := 1;
2982: l_msg_count := x_msg_count;
2983: WHILE l_msg_count > 0 LOOP
2984: x_msg_data := FND_MSG_PUB.GET
2985: ( l_msg_index,
2986: FND_API.G_FALSE );
2987: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_counter_template_Post API ');
2988: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3028: x_msg_data := FND_MSG_PUB.GET

3024: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3025: l_msg_index := 1;
3026: l_msg_count := x_msg_count;
3027: WHILE l_msg_count > 0 LOOP
3028: x_msg_data := FND_MSG_PUB.GET
3029: (l_msg_index,
3030: FND_API.G_FALSE);
3031: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_ITEM_ASSOCIATIONS');
3032: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3054: x_msg_data := FND_MSG_PUB.GET

3050: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3051: l_msg_index := 1;
3052: l_msg_count := x_msg_count;
3053: WHILE l_msg_count > 0 LOOP
3054: x_msg_data := FND_MSG_PUB.GET
3055: (l_msg_index,
3056: FND_API.G_FALSE);
3057: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_ITEM_ASSOCIATIONS');
3058: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3093: x_msg_data := FND_MSG_PUB.GET

3089: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3090: l_msg_index := 1;
3091: l_msg_count := x_msg_count;
3092: WHILE l_msg_count > 0 LOOP
3093: x_msg_data := FND_MSG_PUB.GET
3094: (l_msg_index,
3095: FND_API.G_FALSE);
3096: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_CTR_PROPERTY_TEMPLATE');
3097: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3119: x_msg_data := FND_MSG_PUB.GET

3115: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3116: l_msg_index := 1;
3117: l_msg_count := x_msg_count;
3118: WHILE l_msg_count > 0 LOOP
3119: x_msg_data := FND_MSG_PUB.GET
3120: (l_msg_index,
3121: FND_API.G_FALSE);
3122: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_CTR_PROPERTY_TEMPLATE');
3123: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3167: x_msg_data := FND_MSG_PUB.GET

3163: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3164: l_msg_index := 1;
3165: l_msg_count := x_msg_count;
3166: WHILE l_msg_count > 0 LOOP
3167: x_msg_data := FND_MSG_PUB.GET
3168: (l_msg_index,
3169: FND_API.G_FALSE);
3170: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.CREATE_COUNTER_RELATIONSHIP');
3171: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3195: x_msg_data := FND_MSG_PUB.GET

3191: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3192: l_msg_index := 1;
3193: l_msg_count := x_msg_count;
3194: WHILE l_msg_count > 0 LOOP
3195: x_msg_data := FND_MSG_PUB.GET
3196: (l_msg_index,
3197: FND_API.G_FALSE);
3198: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_COUNTER_RELATIONSHIP');
3199: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3234: x_msg_data := FND_MSG_PUB.GET

3230: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3231: l_msg_index := 1;
3232: l_msg_count := x_msg_count;
3233: WHILE l_msg_count > 0 LOOP
3234: x_msg_data := FND_MSG_PUB.GET
3235: (l_msg_index,
3236: FND_API.G_FALSE);
3237: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PUB.UPDATE_DERIVED_FILTERS');
3238: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3257: FND_MSG_PUB.Count_And_Get

3253: EXCEPTION
3254: WHEN FND_API.G_EXC_ERROR THEN
3255: x_return_status := FND_API.G_RET_STS_ERROR ;
3256: ROLLBACK TO update_counter_template;
3257: FND_MSG_PUB.Count_And_Get
3258: (p_count => x_msg_count,
3259: p_data => x_msg_data
3260: );
3261:

Line 3265: FND_MSG_PUB.Count_And_Get

3261:
3262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3264: ROLLBACK TO update_counter_template;
3265: FND_MSG_PUB.Count_And_Get
3266: (p_count => x_msg_count,
3267: p_data => x_msg_data
3268: );
3269: WHEN OTHERS THEN

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

3268: );
3269: WHEN OTHERS THEN
3270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3271: ROLLBACK TO update_counter_template;
3272: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3273: THEN
3274: FND_MSG_PUB.Add_Exc_Msg
3275: (G_PKG_NAME,
3276: l_api_name

Line 3274: FND_MSG_PUB.Add_Exc_Msg

3270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3271: ROLLBACK TO update_counter_template;
3272: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3273: THEN
3274: FND_MSG_PUB.Add_Exc_Msg
3275: (G_PKG_NAME,
3276: l_api_name
3277: );
3278: END IF;

Line 3279: FND_MSG_PUB.Count_And_Get

3275: (G_PKG_NAME,
3276: l_api_name
3277: );
3278: END IF;
3279: FND_MSG_PUB.Count_And_Get
3280: (p_count => x_msg_count,
3281: p_data => x_msg_data
3282: );
3283:

Line 3349: FND_MSG_PUB.initialize;

3345: END IF;
3346:
3347: -- Initialize message list if p_init_msg_list is set to TRUE.
3348: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3349: FND_MSG_PUB.initialize;
3350: END IF;
3351:
3352: -- Initialize API return status to success
3353: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3392: x_msg_data := FND_MSG_PUB.GET

3388: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3389: l_msg_index := 1;
3390: l_msg_count := x_msg_count;
3391: WHILE l_msg_count > 0 LOOP
3392: x_msg_data := FND_MSG_PUB.GET
3393: ( l_msg_index,
3394: FND_API.G_FALSE
3395: );
3396: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_pre API ');

Line 3422: x_msg_data := FND_MSG_PUB.GET

3418: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3419: l_msg_index := 1;
3420: l_msg_count := x_msg_count;
3421: WHILE l_msg_count > 0 LOOP
3422: x_msg_data := FND_MSG_PUB.GET
3423: ( l_msg_index,
3424: FND_API.G_FALSE
3425: );
3426: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_pre API ');

Line 3452: x_msg_data := FND_MSG_PUB.GET

3448: l_msg_index := 1;
3449: l_msg_count := x_msg_count;
3450:
3451: WHILE l_msg_count > 0 LOOP
3452: x_msg_data := FND_MSG_PUB.GET
3453: (l_msg_index,
3454: FND_API.G_FALSE );
3455: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_CTR_PROPERTY_TEMPLATE');
3456: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3483: x_msg_data := FND_MSG_PUB.GET

3479: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3480: l_msg_index := 1;
3481: l_msg_count := x_msg_count;
3482: WHILE l_msg_count > 0 LOOP
3483: x_msg_data := FND_MSG_PUB.GET
3484: ( l_msg_index,
3485: FND_API.G_FALSE );
3486: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_prop_template_post API ');
3487: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3522: x_msg_data := FND_MSG_PUB.GET

3518: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3519: l_msg_index := 1;
3520: l_msg_count := x_msg_count;
3521: WHILE l_msg_count > 0 LOOP
3522: x_msg_data := FND_MSG_PUB.GET
3523: ( l_msg_index,
3524: FND_API.G_FALSE );
3525: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_prop_template_post API ');
3526: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3552: FND_MSG_PUB.Count_And_Get

3548: EXCEPTION
3549: WHEN FND_API.G_EXC_ERROR THEN
3550: x_return_status := FND_API.G_RET_STS_ERROR ;
3551: ROLLBACK TO update_ctr_property_template;
3552: FND_MSG_PUB.Count_And_Get
3553: (p_count => x_msg_count,
3554: p_data => x_msg_data
3555: );
3556:

Line 3560: FND_MSG_PUB.Count_And_Get

3556:
3557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3559: ROLLBACK TO update_ctr_property_template;
3560: FND_MSG_PUB.Count_And_Get
3561: (p_count => x_msg_count,
3562: p_data => x_msg_data
3563: );
3564: WHEN OTHERS THEN

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

3563: );
3564: WHEN OTHERS THEN
3565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3566: ROLLBACK TO update_ctr_property_template;
3567: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3568: THEN
3569: FND_MSG_PUB.Add_Exc_Msg
3570: (G_PKG_NAME,
3571: l_api_name

Line 3569: FND_MSG_PUB.Add_Exc_Msg

3565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3566: ROLLBACK TO update_ctr_property_template;
3567: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3568: THEN
3569: FND_MSG_PUB.Add_Exc_Msg
3570: (G_PKG_NAME,
3571: l_api_name
3572: );
3573: END IF;

Line 3574: FND_MSG_PUB.Count_And_Get

3570: (G_PKG_NAME,
3571: l_api_name
3572: );
3573: END IF;
3574: FND_MSG_PUB.Count_And_Get
3575: (p_count => x_msg_count,
3576: p_data => x_msg_data
3577: );
3578:

Line 3643: FND_MSG_PUB.initialize;

3639: END IF;
3640:
3641: -- Initialize message list if p_init_msg_list is set to TRUE.
3642: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3643: FND_MSG_PUB.initialize;
3644: END IF;
3645:
3646: -- Initialize API return status to success
3647: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3686: x_msg_data := FND_MSG_PUB.GET

3682: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3683: l_msg_index := 1;
3684: l_msg_count := x_msg_count;
3685: WHILE l_msg_count > 0 LOOP
3686: x_msg_data := FND_MSG_PUB.GET
3687: ( l_msg_index,
3688: FND_API.G_FALSE
3689: );
3690: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_pre API ');

Line 3716: x_msg_data := FND_MSG_PUB.GET

3712: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3713: l_msg_index := 1;
3714: l_msg_count := x_msg_count;
3715: WHILE l_msg_count > 0 LOOP
3716: x_msg_data := FND_MSG_PUB.GET
3717: ( l_msg_index,
3718: FND_API.G_FALSE
3719: );
3720: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_pre API ');

Line 3746: x_msg_data := FND_MSG_PUB.GET

3742: l_msg_index := 1;
3743: l_msg_count := x_msg_count;
3744:
3745: WHILE l_msg_count > 0 LOOP
3746: x_msg_data := FND_MSG_PUB.GET
3747: (l_msg_index,
3748: FND_API.G_FALSE );
3749: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_COUNTER_RELATIONSHIP');
3750: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3777: x_msg_data := FND_MSG_PUB.GET

3773: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3774: l_msg_index := 1;
3775: l_msg_count := x_msg_count;
3776: WHILE l_msg_count > 0 LOOP
3777: x_msg_data := FND_MSG_PUB.GET
3778: ( l_msg_index,
3779: FND_API.G_FALSE );
3780: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_ctr_relationship_post API ');
3781: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3816: x_msg_data := FND_MSG_PUB.GET

3812: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3813: l_msg_index := 1;
3814: l_msg_count := x_msg_count;
3815: WHILE l_msg_count > 0 LOOP
3816: x_msg_data := FND_MSG_PUB.GET
3817: ( l_msg_index,
3818: FND_API.G_FALSE );
3819: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_ctr_relationship_post API ');
3820: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 3845: FND_MSG_PUB.Count_And_Get

3841: EXCEPTION
3842: WHEN FND_API.G_EXC_ERROR THEN
3843: x_return_status := FND_API.G_RET_STS_ERROR ;
3844: ROLLBACK TO update_counter_relationship;
3845: FND_MSG_PUB.Count_And_Get
3846: (p_count => x_msg_count,
3847: p_data => x_msg_data
3848: );
3849:

Line 3853: FND_MSG_PUB.Count_And_Get

3849:
3850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3852: ROLLBACK TO update_counter_relationship;
3853: FND_MSG_PUB.Count_And_Get
3854: (p_count => x_msg_count,
3855: p_data => x_msg_data
3856: );
3857: WHEN OTHERS THEN

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

3856: );
3857: WHEN OTHERS THEN
3858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3859: ROLLBACK TO update_counter_relationship;
3860: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3861: THEN
3862: FND_MSG_PUB.Add_Exc_Msg
3863: (G_PKG_NAME,
3864: l_api_name

Line 3862: FND_MSG_PUB.Add_Exc_Msg

3858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3859: ROLLBACK TO update_counter_relationship;
3860: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3861: THEN
3862: FND_MSG_PUB.Add_Exc_Msg
3863: (G_PKG_NAME,
3864: l_api_name
3865: );
3866: END IF;

Line 3867: FND_MSG_PUB.Count_And_Get

3863: (G_PKG_NAME,
3864: l_api_name
3865: );
3866: END IF;
3867: FND_MSG_PUB.Count_And_Get
3868: (p_count => x_msg_count,
3869: p_data => x_msg_data
3870: );
3871:

Line 3936: FND_MSG_PUB.initialize;

3932: END IF;
3933:
3934: -- Initialize message list if p_init_msg_list is set to TRUE.
3935: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3936: FND_MSG_PUB.initialize;
3937: END IF;
3938:
3939: -- Initialize API return status to success
3940: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3979: x_msg_data := FND_MSG_PUB.GET

3975: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
3976: l_msg_index := 1;
3977: l_msg_count := x_msg_count;
3978: WHILE l_msg_count > 0 LOOP
3979: x_msg_data := FND_MSG_PUB.GET
3980: ( l_msg_index,
3981: FND_API.G_FALSE
3982: );
3983: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');

Line 4009: x_msg_data := FND_MSG_PUB.GET

4005: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4006: l_msg_index := 1;
4007: l_msg_count := x_msg_count;
4008: WHILE l_msg_count > 0 LOOP
4009: x_msg_data := FND_MSG_PUB.GET
4010: ( l_msg_index,
4011: FND_API.G_FALSE
4012: );
4013: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_pre API ');

Line 4040: x_msg_data := FND_MSG_PUB.GET

4036: l_msg_index := 1;
4037: l_msg_count := x_msg_count;
4038:
4039: WHILE l_msg_count > 0 LOOP
4040: x_msg_data := FND_MSG_PUB.GET
4041: (l_msg_index,
4042: FND_API.G_FALSE );
4043: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_DERIVED_FILTERS');
4044: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4071: x_msg_data := FND_MSG_PUB.GET

4067: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4068: l_msg_index := 1;
4069: l_msg_count := x_msg_count;
4070: WHILE l_msg_count > 0 LOOP
4071: x_msg_data := FND_MSG_PUB.GET
4072: ( l_msg_index,
4073: FND_API.G_FALSE );
4074: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_derived_filters_post API ');
4075: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4110: x_msg_data := FND_MSG_PUB.GET

4106: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4107: l_msg_index := 1;
4108: l_msg_count := x_msg_count;
4109: WHILE l_msg_count > 0 LOOP
4110: x_msg_data := FND_MSG_PUB.GET
4111: ( l_msg_index,
4112: FND_API.G_FALSE );
4113: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_derived_filters_post API ');
4114: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4140: FND_MSG_PUB.Count_And_Get

4136: EXCEPTION
4137: WHEN FND_API.G_EXC_ERROR THEN
4138: x_return_status := FND_API.G_RET_STS_ERROR ;
4139: ROLLBACK TO update_derived_filters;
4140: FND_MSG_PUB.Count_And_Get
4141: (p_count => x_msg_count,
4142: p_data => x_msg_data
4143: );
4144:

Line 4148: FND_MSG_PUB.Count_And_Get

4144:
4145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4147: ROLLBACK TO update_derived_filters;
4148: FND_MSG_PUB.Count_And_Get
4149: (p_count => x_msg_count,
4150: p_data => x_msg_data
4151: );
4152:

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

4152:
4153: WHEN OTHERS THEN
4154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4155: ROLLBACK TO update_derived_filters;
4156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4157: THEN
4158: FND_MSG_PUB.Add_Exc_Msg
4159: (G_PKG_NAME,
4160: l_api_name

Line 4158: FND_MSG_PUB.Add_Exc_Msg

4154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4155: ROLLBACK TO update_derived_filters;
4156: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4157: THEN
4158: FND_MSG_PUB.Add_Exc_Msg
4159: (G_PKG_NAME,
4160: l_api_name
4161: );
4162: END IF;

Line 4163: FND_MSG_PUB.Count_And_Get

4159: (G_PKG_NAME,
4160: l_api_name
4161: );
4162: END IF;
4163: FND_MSG_PUB.Count_And_Get
4164: (p_count => x_msg_count,
4165: p_data => x_msg_data
4166: );
4167:

Line 4225: FND_MSG_PUB.initialize;

4221: END IF;
4222:
4223: -- Initialize message list if p_init_msg_list is set to TRUE.
4224: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4225: FND_MSG_PUB.initialize;
4226: END IF;
4227:
4228: -- Initialize API return status to success
4229: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4268: x_msg_data := FND_MSG_PUB.GET

4264: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4265: l_msg_index := 1;
4266: l_msg_count := x_msg_count;
4267: WHILE l_msg_count > 0 LOOP
4268: x_msg_data := FND_MSG_PUB.GET
4269: ( l_msg_index,
4270: FND_API.G_FALSE
4271: );
4272: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_estimation_method_pre API ');

Line 4298: x_msg_data := FND_MSG_PUB.GET

4294: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4295: l_msg_index := 1;
4296: l_msg_count := x_msg_count;
4297: WHILE l_msg_count > 0 LOOP
4298: x_msg_data := FND_MSG_PUB.GET
4299: ( l_msg_index,
4300: FND_API.G_FALSE
4301: );
4302: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_pre API ');

Line 4328: x_msg_data := FND_MSG_PUB.GET

4324: l_msg_index := 1;
4325: l_msg_count := x_msg_count;
4326:
4327: WHILE l_msg_count > 0 LOOP
4328: x_msg_data := FND_MSG_PUB.GET
4329: (l_msg_index,
4330: FND_API.G_FALSE );
4331: csi_ctr_gen_utility_pvt.put_line( ' Error from csi_counter_template_pvt.create_estimation_method');
4332: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4359: x_msg_data := FND_MSG_PUB.GET

4355: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4356: l_msg_index := 1;
4357: l_msg_count := x_msg_count;
4358: WHILE l_msg_count > 0 LOOP
4359: x_msg_data := FND_MSG_PUB.GET
4360: ( l_msg_index,
4361: FND_API.G_FALSE );
4362: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.create_estimation_method_post API ');
4363: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4397: x_msg_data := FND_MSG_PUB.GET

4393: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4394: l_msg_index := 1;
4395: l_msg_count := x_msg_count;
4396: WHILE l_msg_count > 0 LOOP
4397: x_msg_data := FND_MSG_PUB.GET
4398: ( l_msg_index,
4399: FND_API.G_FALSE );
4400: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.create_estimation_method_post ');
4401: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4427: FND_MSG_PUB.Count_And_Get

4423: EXCEPTION
4424: WHEN FND_API.G_EXC_ERROR THEN
4425: x_return_status := FND_API.G_RET_STS_ERROR ;
4426: ROLLBACK TO create_estimation_method;
4427: FND_MSG_PUB.Count_And_Get
4428: (p_count => x_msg_count,
4429: p_data => x_msg_data
4430: );
4431:

Line 4435: FND_MSG_PUB.Count_And_Get

4431:
4432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4434: ROLLBACK TO create_estimation_method;
4435: FND_MSG_PUB.Count_And_Get
4436: (p_count => x_msg_count,
4437: p_data => x_msg_data
4438: );
4439:

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

4439:
4440: WHEN OTHERS THEN
4441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4442: ROLLBACK TO create_estimation_method;
4443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4444: THEN
4445: FND_MSG_PUB.Add_Exc_Msg
4446: (G_PKG_NAME,
4447: l_api_name

Line 4445: FND_MSG_PUB.Add_Exc_Msg

4441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4442: ROLLBACK TO create_estimation_method;
4443: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4444: THEN
4445: FND_MSG_PUB.Add_Exc_Msg
4446: (G_PKG_NAME,
4447: l_api_name
4448: );
4449: END IF;

Line 4450: FND_MSG_PUB.Count_And_Get

4446: (G_PKG_NAME,
4447: l_api_name
4448: );
4449: END IF;
4450: FND_MSG_PUB.Count_And_Get
4451: (p_count => x_msg_count,
4452: p_data => x_msg_data
4453: );
4454: END create_estimation_method;

Line 4511: FND_MSG_PUB.initialize;

4507: END IF;
4508:
4509: -- Initialize message list if p_init_msg_list is set to TRUE.
4510: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4511: FND_MSG_PUB.initialize;
4512: END IF;
4513:
4514: -- Initialize API return status to success
4515: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4554: x_msg_data := FND_MSG_PUB.GET

4550: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4551: l_msg_index := 1;
4552: l_msg_count := x_msg_count;
4553: WHILE l_msg_count > 0 LOOP
4554: x_msg_data := FND_MSG_PUB.GET
4555: ( l_msg_index,
4556: FND_API.G_FALSE
4557: );
4558: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');

Line 4584: x_msg_data := FND_MSG_PUB.GET

4580: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4581: l_msg_index := 1;
4582: l_msg_count := x_msg_count;
4583: WHILE l_msg_count > 0 LOOP
4584: x_msg_data := FND_MSG_PUB.GET
4585: ( l_msg_index,
4586: FND_API.G_FALSE
4587: );
4588: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_pre API ');

Line 4615: x_msg_data := FND_MSG_PUB.GET

4611: l_msg_index := 1;
4612: l_msg_count := x_msg_count;
4613:
4614: WHILE l_msg_count > 0 LOOP
4615: x_msg_data := FND_MSG_PUB.GET
4616: (l_msg_index,
4617: FND_API.G_FALSE );
4618: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.UPDATE_ESTIMATION_METHOD');
4619: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4646: x_msg_data := FND_MSG_PUB.GET

4642: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4643: l_msg_index := 1;
4644: l_msg_count := x_msg_count;
4645: WHILE l_msg_count > 0 LOOP
4646: x_msg_data := FND_MSG_PUB.GET
4647: ( l_msg_index,
4648: FND_API.G_FALSE );
4649: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.update_estimation_method_post API ');
4650: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4685: x_msg_data := FND_MSG_PUB.GET

4681: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4682: l_msg_index := 1;
4683: l_msg_count := x_msg_count;
4684: WHILE l_msg_count > 0 LOOP
4685: x_msg_data := FND_MSG_PUB.GET
4686: ( l_msg_index,
4687: FND_API.G_FALSE );
4688: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.update_estimation_method_post API ');
4689: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 4714: FND_MSG_PUB.Count_And_Get

4710: EXCEPTION
4711: WHEN FND_API.G_EXC_ERROR THEN
4712: x_return_status := FND_API.G_RET_STS_ERROR ;
4713: ROLLBACK TO update_estimation_method;
4714: FND_MSG_PUB.Count_And_Get
4715: (p_count => x_msg_count,
4716: p_data => x_msg_data
4717: );
4718:

Line 4722: FND_MSG_PUB.Count_And_Get

4718:
4719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4721: ROLLBACK TO update_estimation_method;
4722: FND_MSG_PUB.Count_And_Get
4723: (p_count => x_msg_count,
4724: p_data => x_msg_data
4725: );
4726:

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

4726:
4727: WHEN OTHERS THEN
4728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4729: ROLLBACK TO update_estimation_method;
4730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4731: THEN
4732: FND_MSG_PUB.Add_Exc_Msg
4733: (G_PKG_NAME,
4734: l_api_name

Line 4732: FND_MSG_PUB.Add_Exc_Msg

4728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4729: ROLLBACK TO update_estimation_method;
4730: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4731: THEN
4732: FND_MSG_PUB.Add_Exc_Msg
4733: (G_PKG_NAME,
4734: l_api_name
4735: );
4736: END IF;

Line 4737: FND_MSG_PUB.Count_And_Get

4733: (G_PKG_NAME,
4734: l_api_name
4735: );
4736: END IF;
4737: FND_MSG_PUB.Count_And_Get
4738: (p_count => x_msg_count,
4739: p_data => x_msg_data
4740: );
4741: END update_estimation_method;

Line 4846: FND_MSG_PUB.initialize;

4842: END IF;
4843:
4844: -- Initialize message list if p_init_msg_list is set to TRUE.
4845: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4846: FND_MSG_PUB.initialize;
4847: END IF;
4848:
4849: -- Initialize API return status to success
4850: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4895: x_msg_data := FND_MSG_PUB.GET

4891: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4892: l_msg_index := 1;
4893: l_msg_count := x_msg_count;
4894: WHILE l_msg_count > 0 LOOP
4895: x_msg_data := FND_MSG_PUB.GET
4896: ( l_msg_index,
4897: FND_API.G_FALSE
4898: );
4899: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.AutoInstantiate_Counters_pre API ');

Line 4930: x_msg_data := FND_MSG_PUB.GET

4926: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4927: l_msg_index := 1;
4928: l_msg_count := x_msg_count;
4929: WHILE l_msg_count > 0 LOOP
4930: x_msg_data := FND_MSG_PUB.GET
4931: ( l_msg_index,
4932: FND_API.G_FALSE
4933: );
4934: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_pre API ');

Line 5035: x_msg_data := FND_MSG_PUB.GET

5031: l_msg_index := 1;
5032: l_msg_count := x_msg_count;
5033:
5034: WHILE l_msg_count > 0 LOOP
5035: x_msg_data := FND_MSG_PUB.GET
5036: (l_msg_index,
5037: FND_API.G_FALSE );
5038: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate_Counters');
5039: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5086: x_msg_data := FND_MSG_PUB.GET

5082: l_msg_index := 1;
5083: l_msg_count := x_msg_count;
5084:
5085: WHILE l_msg_count > 0 LOOP
5086: x_msg_data := FND_MSG_PUB.GET
5087: (l_msg_index,
5088: FND_API.G_FALSE );
5089: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate Group Counters');
5090: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5124: x_msg_data := FND_MSG_PUB.GET

5120: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5121: l_msg_index := 1;
5122: l_msg_count := x_msg_count;
5123: WHILE l_msg_count > 0 LOOP
5124: x_msg_data := FND_MSG_PUB.GET
5125: ( l_msg_index,
5126: FND_API.G_FALSE );
5127: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.AutoInstantiate_Counters_Post API ');
5128: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5168: x_msg_data := FND_MSG_PUB.GET

5164: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5165: l_msg_index := 1;
5166: l_msg_count := x_msg_count;
5167: WHILE l_msg_count > 0 LOOP
5168: x_msg_data := FND_MSG_PUB.GET
5169: ( l_msg_index,
5170: FND_API.G_FALSE );
5171: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.AutoInstantiate_Counters_Post API ');
5172: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5197: FND_MSG_PUB.Count_And_Get

5193: EXCEPTION
5194: WHEN FND_API.G_EXC_ERROR THEN
5195: x_return_status := FND_API.G_RET_STS_ERROR ;
5196: ROLLBACK TO autoinstantiate_counters;
5197: FND_MSG_PUB.Count_And_Get
5198: (p_count => x_msg_count,
5199: p_data => x_msg_data
5200: );
5201:

Line 5205: FND_MSG_PUB.Count_And_Get

5201:
5202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5204: ROLLBACK TO autoinstantiate_counters;
5205: FND_MSG_PUB.Count_And_Get
5206: (p_count => x_msg_count,
5207: p_data => x_msg_data
5208: );
5209:

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

5209:
5210: WHEN OTHERS THEN
5211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5212: ROLLBACK TO autoinstantiate_counters;
5213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5214: THEN
5215: FND_MSG_PUB.Add_Exc_Msg
5216: (G_PKG_NAME,
5217: l_api_name

Line 5215: FND_MSG_PUB.Add_Exc_Msg

5211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5212: ROLLBACK TO autoinstantiate_counters;
5213: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5214: THEN
5215: FND_MSG_PUB.Add_Exc_Msg
5216: (G_PKG_NAME,
5217: l_api_name
5218: );
5219: END IF;

Line 5220: FND_MSG_PUB.Count_And_Get

5216: (G_PKG_NAME,
5217: l_api_name
5218: );
5219: END IF;
5220: FND_MSG_PUB.Count_And_Get
5221: (p_count => x_msg_count,
5222: p_data => x_msg_data
5223: );
5224: END AutoInstantiate_Counters;

Line 5348: FND_MSG_PUB.initialize;

5344: END IF;
5345:
5346: -- Initialize message list if p_init_msg_list is set to TRUE.
5347: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5348: FND_MSG_PUB.initialize;
5349: END IF;
5350:
5351: -- Initialize API return status to success
5352: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5394: x_msg_data := FND_MSG_PUB.GET

5390: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5391: l_msg_index := 1;
5392: l_msg_count := x_msg_count;
5393: WHILE l_msg_count > 0 LOOP
5394: x_msg_data := FND_MSG_PUB.GET
5395: ( l_msg_index,
5396: FND_API.G_FALSE
5397: );
5398: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.instantiate_counters_pre API ');

Line 5427: x_msg_data := FND_MSG_PUB.GET

5423: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5424: l_msg_index := 1;
5425: l_msg_count := x_msg_count;
5426: WHILE l_msg_count > 0 LOOP
5427: x_msg_data := FND_MSG_PUB.GET
5428: ( l_msg_index,
5429: FND_API.G_FALSE
5430: );
5431: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_pre API ');

Line 5462: x_msg_data := FND_MSG_PUB.GET

5458: l_msg_index := 1;
5459: l_msg_count := x_msg_count;
5460:
5461: WHILE l_msg_count > 0 LOOP
5462: x_msg_data := FND_MSG_PUB.GET
5463: (l_msg_index,
5464: FND_API.G_FALSE );
5465: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.INSTANTIATE_COUNTERS');
5466: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5496: x_msg_data := FND_MSG_PUB.GET

5492: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5493: l_msg_index := 1;
5494: l_msg_count := x_msg_count;
5495: WHILE l_msg_count > 0 LOOP
5496: x_msg_data := FND_MSG_PUB.GET
5497: ( l_msg_index,
5498: FND_API.G_FALSE );
5499: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.instantiate_counters_Post API ');
5500: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5539: x_msg_data := FND_MSG_PUB.GET

5535: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5536: l_msg_index := 1;
5537: l_msg_count := x_msg_count;
5538: WHILE l_msg_count > 0 LOOP
5539: x_msg_data := FND_MSG_PUB.GET
5540: ( l_msg_index,
5541: FND_API.G_FALSE );
5542: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.instantiate_counters_Post API ');
5543: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5568: FND_MSG_PUB.Count_And_Get

5564: EXCEPTION
5565: WHEN FND_API.G_EXC_ERROR THEN
5566: x_return_status := FND_API.G_RET_STS_ERROR ;
5567: ROLLBACK TO instantiate_counters;
5568: FND_MSG_PUB.Count_And_Get
5569: (p_count => x_msg_count,
5570: p_data => x_msg_data
5571: );
5572:

Line 5576: FND_MSG_PUB.Count_And_Get

5572:
5573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5575: ROLLBACK TO instantiate_counters;
5576: FND_MSG_PUB.Count_And_Get
5577: (p_count => x_msg_count,
5578: p_data => x_msg_data
5579: );
5580:

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

5580:
5581: WHEN OTHERS THEN
5582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5583: ROLLBACK TO instantiate_counters;
5584: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5585: THEN
5586: FND_MSG_PUB.Add_Exc_Msg
5587: (G_PKG_NAME,
5588: l_api_name

Line 5586: FND_MSG_PUB.Add_Exc_Msg

5582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5583: ROLLBACK TO instantiate_counters;
5584: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5585: THEN
5586: FND_MSG_PUB.Add_Exc_Msg
5587: (G_PKG_NAME,
5588: l_api_name
5589: );
5590: END IF;

Line 5591: FND_MSG_PUB.Count_And_Get

5587: (G_PKG_NAME,
5588: l_api_name
5589: );
5590: END IF;
5591: FND_MSG_PUB.Count_And_Get
5592: (p_count => x_msg_count,
5593: p_data => x_msg_data
5594: );
5595: END Instantiate_Counters;

Line 5656: FND_MSG_PUB.initialize;

5652: END IF;
5653:
5654: -- Initialize message list if p_init_msg_list is set to TRUE.
5655: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5656: FND_MSG_PUB.initialize;
5657: END IF;
5658:
5659: -- Initialize API return status to success
5660: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5699: x_msg_data := FND_MSG_PUB.GET

5695: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5696: l_msg_index := 1;
5697: l_msg_count := x_msg_count;
5698: WHILE l_msg_count > 0 LOOP
5699: x_msg_data := FND_MSG_PUB.GET
5700: ( l_msg_index,
5701: FND_API.G_FALSE
5702: );
5703: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_PRE API ');

Line 5729: x_msg_data := FND_MSG_PUB.GET

5725: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5726: l_msg_index := 1;
5727: l_msg_count := x_msg_count;
5728: WHILE l_msg_count > 0 LOOP
5729: x_msg_data := FND_MSG_PUB.GET
5730: ( l_msg_index,
5731: FND_API.G_FALSE
5732: );
5733: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_PRE API ');

Line 5759: x_msg_data := FND_MSG_PUB.GET

5755: l_msg_index := 1;
5756: l_msg_count := x_msg_count;
5757:
5758: WHILE l_msg_count > 0 LOOP
5759: x_msg_data := FND_MSG_PUB.GET
5760: (l_msg_index,
5761: FND_API.G_FALSE );
5762: csi_ctr_gen_utility_pvt.put_line(' Error from CSI_COUNTER_TEMPLATE_PVT.DELETE_ITEM_ASSOCIATION');
5763: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5790: x_msg_data := FND_MSG_PUB.GET

5786: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5787: l_msg_index := 1;
5788: l_msg_count := x_msg_count;
5789: WHILE l_msg_count > 0 LOOP
5790: x_msg_data := FND_MSG_PUB.GET
5791: ( l_msg_index,
5792: FND_API.G_FALSE );
5793: csi_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_CUHK.DELETE_ITEM_ASSOCIATION_Post API ');
5794: csi_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5829: x_msg_data := FND_MSG_PUB.GET

5825: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5826: l_msg_index := 1;
5827: l_msg_count := x_msg_count;
5828: WHILE l_msg_count > 0 LOOP
5829: x_msg_data := FND_MSG_PUB.GET
5830: ( l_msg_index,
5831: FND_API.G_FALSE );
5832: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_TEMPLATE_VUHK.DELETE_ITEM_ASSOCIATION_Post API ');
5833: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 5859: FND_MSG_PUB.Count_And_Get

5855: EXCEPTION
5856: WHEN FND_API.G_EXC_ERROR THEN
5857: x_return_status := FND_API.G_RET_STS_ERROR ;
5858: ROLLBACK TO delete_item_association;
5859: FND_MSG_PUB.Count_And_Get
5860: (p_count => x_msg_count,
5861: p_data => x_msg_data
5862: );
5863:

Line 5867: FND_MSG_PUB.Count_And_Get

5863:
5864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5866: ROLLBACK TO delete_item_association;
5867: FND_MSG_PUB.Count_And_Get
5868: (p_count => x_msg_count,
5869: p_data => x_msg_data
5870: );
5871: WHEN OTHERS THEN

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

5870: );
5871: WHEN OTHERS THEN
5872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5873: ROLLBACK TO delete_item_association;
5874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5875: THEN
5876: FND_MSG_PUB.Add_Exc_Msg
5877: (G_PKG_NAME,
5878: l_api_name

Line 5876: FND_MSG_PUB.Add_Exc_Msg

5872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5873: ROLLBACK TO delete_item_association;
5874: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5875: THEN
5876: FND_MSG_PUB.Add_Exc_Msg
5877: (G_PKG_NAME,
5878: l_api_name
5879: );
5880: END IF;

Line 5881: FND_MSG_PUB.Count_And_Get

5877: (G_PKG_NAME,
5878: l_api_name
5879: );
5880: END IF;
5881: FND_MSG_PUB.Count_And_Get
5882: (p_count => x_msg_count,
5883: p_data => x_msg_data
5884: );
5885: