APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on FND_MSG_PUB

Line 565: FND_MSG_PUB.initialize;

561: END IF;
562:
563: -- Initialize message list if p_init_msg_list is set to TRUE.
564: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
565: FND_MSG_PUB.initialize;
566: END IF;
567:
568: -- Initialize API return status to success
569: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 800: FND_MSG_PUB.Count_And_Get

796: COMMIT WORK;
797: END IF;
798:
799: -- Standard call to get message count and IF count is get message info.
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804: EXCEPTION

Line 808: FND_MSG_PUB.Count_And_Get

804: EXCEPTION
805: WHEN FND_API.G_EXC_ERROR THEN
806: x_return_status := FND_API.G_RET_STS_ERROR ;
807: ROLLBACK TO create_counter_group_pvt;
808: FND_MSG_PUB.Count_And_Get
809: ( p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 815: FND_MSG_PUB.Count_And_Get

811: );
812: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814: ROLLBACK TO create_counter_group_pvt;
815: FND_MSG_PUB.Count_And_Get
816: ( p_count => x_msg_count,
817: p_data => x_msg_data
818: );
819: WHEN OTHERS THEN

Line 822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

818: );
819: WHEN OTHERS THEN
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
821: ROLLBACK TO create_counter_group_pvt;
822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
823: FND_MSG_PUB.Add_Exc_Msg
824: ( G_PKG_NAME,
825: l_api_name
826: );

Line 823: FND_MSG_PUB.Add_Exc_Msg

819: WHEN OTHERS THEN
820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
821: ROLLBACK TO create_counter_group_pvt;
822: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
823: FND_MSG_PUB.Add_Exc_Msg
824: ( G_PKG_NAME,
825: l_api_name
826: );
827: END IF;

Line 828: FND_MSG_PUB.Count_And_Get

824: ( G_PKG_NAME,
825: l_api_name
826: );
827: END IF;
828: FND_MSG_PUB.Count_And_Get
829: ( p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832: END create_counter_group;

Line 923: FND_MSG_PUB.initialize;

919: END IF;
920:
921: -- Initialize message list if p_init_msg_list is set to TRUE.
922: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
923: FND_MSG_PUB.initialize;
924: END IF;
925:
926: -- Read the debug profiles values in to global variable 7197402
927: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

Line 1299: FND_MSG_PUB.Count_And_Get

1295: COMMIT WORK;
1296: END IF;
1297:
1298: -- Standard call to get message count and IF count is get message info.
1299: FND_MSG_PUB.Count_And_Get
1300: ( p_count => x_msg_count,
1301: p_data => x_msg_data
1302: );
1303: EXCEPTION

Line 1307: FND_MSG_PUB.Count_And_Get

1303: EXCEPTION
1304: WHEN FND_API.G_EXC_ERROR THEN
1305: x_return_status := FND_API.G_RET_STS_ERROR ;
1306: ROLLBACK TO create_item_association_pvt;
1307: FND_MSG_PUB.Count_And_Get
1308: ( p_count => x_msg_count,
1309: p_data => x_msg_data
1310: );
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1314: FND_MSG_PUB.Count_And_Get

1310: );
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1313: ROLLBACK TO create_item_association_pvt;
1314: FND_MSG_PUB.Count_And_Get
1315: ( p_count => x_msg_count,
1316: p_data => x_msg_data
1317: );
1318: WHEN OTHERS THEN

Line 1321: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1317: );
1318: WHEN OTHERS THEN
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1320: ROLLBACK TO create_item_association_pvt;
1321: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1322: FND_MSG_PUB.Add_Exc_Msg
1323: ( G_PKG_NAME,
1324: l_api_name
1325: );

Line 1322: FND_MSG_PUB.Add_Exc_Msg

1318: WHEN OTHERS THEN
1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1320: ROLLBACK TO create_item_association_pvt;
1321: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1322: FND_MSG_PUB.Add_Exc_Msg
1323: ( G_PKG_NAME,
1324: l_api_name
1325: );
1326: END IF;

Line 1327: FND_MSG_PUB.Count_And_Get

1323: ( G_PKG_NAME,
1324: l_api_name
1325: );
1326: END IF;
1327: FND_MSG_PUB.Count_And_Get
1328: ( p_count => x_msg_count,
1329: p_data => x_msg_data
1330: );
1331: END create_item_association;

Line 1450: FND_MSG_PUB.initialize;

1446: END IF;
1447:
1448: -- Initialize message list if p_init_msg_list is set to TRUE.
1449: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1450: FND_MSG_PUB.initialize;
1451: END IF;
1452:
1453: -- Read the debug profiles values in to global variable 7197402
1454: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

Line 1906: x_msg_data := FND_MSG_PUB.GET

1902: l_msg_index := 1;
1903: l_msg_count := x_msg_count;
1904:
1905: WHILE l_msg_count > 0 LOOP
1906: x_msg_data := FND_MSG_PUB.GET
1907: (l_msg_index,
1908: FND_API.G_FALSE );
1909: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_PVT.CREATE_COUNTER_GROUP');
1910: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 2030: FND_MSG_PUB.Count_And_Get

2026: COMMIT WORK;
2027: END IF;
2028:
2029: -- Standard call to get message count and IF count is get message info.
2030: FND_MSG_PUB.Count_And_Get
2031: ( p_count => x_msg_count,
2032: p_data => x_msg_data
2033: );
2034: EXCEPTION

Line 2038: FND_MSG_PUB.Count_And_Get

2034: EXCEPTION
2035: WHEN FND_API.G_EXC_ERROR THEN
2036: x_return_status := FND_API.G_RET_STS_ERROR ;
2037: ROLLBACK TO create_counter_template_pvt;
2038: FND_MSG_PUB.Count_And_Get
2039: ( p_count => x_msg_count,
2040: p_data => x_msg_data
2041: );
2042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2045: FND_MSG_PUB.Count_And_Get

2041: );
2042: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2044: ROLLBACK TO create_counter_template_pvt;
2045: FND_MSG_PUB.Count_And_Get
2046: ( p_count => x_msg_count,
2047: p_data => x_msg_data
2048: );
2049: WHEN OTHERS THEN

Line 2052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2048: );
2049: WHEN OTHERS THEN
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2051: ROLLBACK TO create_counter_template_pvt;
2052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2053: FND_MSG_PUB.Add_Exc_Msg
2054: ( G_PKG_NAME,
2055: l_api_name
2056: );

Line 2053: FND_MSG_PUB.Add_Exc_Msg

2049: WHEN OTHERS THEN
2050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2051: ROLLBACK TO create_counter_template_pvt;
2052: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2053: FND_MSG_PUB.Add_Exc_Msg
2054: ( G_PKG_NAME,
2055: l_api_name
2056: );
2057: END IF;

Line 2058: FND_MSG_PUB.Count_And_Get

2054: ( G_PKG_NAME,
2055: l_api_name
2056: );
2057: END IF;
2058: FND_MSG_PUB.Count_And_Get
2059: ( p_count => x_msg_count,
2060: p_data => x_msg_data
2061: );
2062: END create_counter_template;

Line 2139: FND_MSG_PUB.initialize;

2135: END IF;
2136:
2137: -- Initialize message list if p_init_msg_list is set to TRUE.
2138: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2139: FND_MSG_PUB.initialize;
2140: END IF;
2141:
2142: -- Read the debug profiles values in to global variable 7197402
2143: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

Line 2414: FND_MSG_PUB.Count_And_Get

2410: COMMIT WORK;
2411: END IF;
2412:
2413: -- Standard call to get message count and IF count is get message info.
2414: FND_MSG_PUB.Count_And_Get
2415: ( p_count => x_msg_count,
2416: p_data => x_msg_data
2417: );
2418: EXCEPTION

Line 2422: FND_MSG_PUB.Count_And_Get

2418: EXCEPTION
2419: WHEN FND_API.G_EXC_ERROR THEN
2420: x_return_status := FND_API.G_RET_STS_ERROR ;
2421: ROLLBACK TO create_ctr_property_tmpl_pvt;
2422: FND_MSG_PUB.Count_And_Get
2423: ( p_count => x_msg_count,
2424: p_data => x_msg_data
2425: );
2426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2429: FND_MSG_PUB.Count_And_Get

2425: );
2426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2428: ROLLBACK TO create_ctr_property_tmpl_pvt;
2429: FND_MSG_PUB.Count_And_Get
2430: ( p_count => x_msg_count,
2431: p_data => x_msg_data
2432: );
2433: WHEN OTHERS THEN

Line 2436: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2432: );
2433: WHEN OTHERS THEN
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2435: ROLLBACK TO create_ctr_property_tmpl_pvt;
2436: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2437: FND_MSG_PUB.Add_Exc_Msg
2438: ( G_PKG_NAME,
2439: l_api_name
2440: );

Line 2437: FND_MSG_PUB.Add_Exc_Msg

2433: WHEN OTHERS THEN
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2435: ROLLBACK TO create_ctr_property_tmpl_pvt;
2436: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2437: FND_MSG_PUB.Add_Exc_Msg
2438: ( G_PKG_NAME,
2439: l_api_name
2440: );
2441: END IF;

Line 2442: FND_MSG_PUB.Count_And_Get

2438: ( G_PKG_NAME,
2439: l_api_name
2440: );
2441: END IF;
2442: FND_MSG_PUB.Count_And_Get
2443: ( p_count => x_msg_count,
2444: p_data => x_msg_data
2445: );
2446: END create_ctr_property_template;

Line 2533: FND_MSG_PUB.initialize;

2529: END IF;
2530:
2531: -- Initialize message list if p_init_msg_list is set to TRUE.
2532: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2533: FND_MSG_PUB.initialize;
2534: END IF;
2535:
2536: -- Read the debug profiles values in to global variable 7197402
2537: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

Line 2844: FND_MSG_PUB.Count_And_Get

2840: COMMIT WORK;
2841: END IF;
2842:
2843: -- Standard call to get message count and IF count is get message info.
2844: FND_MSG_PUB.Count_And_Get
2845: ( p_count => x_msg_count,
2846: p_data => x_msg_data
2847: );
2848: EXCEPTION

Line 2852: FND_MSG_PUB.Count_And_Get

2848: EXCEPTION
2849: WHEN FND_API.G_EXC_ERROR THEN
2850: x_return_status := FND_API.G_RET_STS_ERROR ;
2851: ROLLBACK TO create_ctr_relationship_pvt;
2852: FND_MSG_PUB.Count_And_Get
2853: ( p_count => x_msg_count,
2854: p_data => x_msg_data
2855: );
2856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2859: FND_MSG_PUB.Count_And_Get

2855: );
2856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2858: ROLLBACK TO create_ctr_relationship_pvt;
2859: FND_MSG_PUB.Count_And_Get
2860: ( p_count => x_msg_count,
2861: p_data => x_msg_data
2862: );
2863: WHEN OTHERS THEN

Line 2866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2862: );
2863: WHEN OTHERS THEN
2864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2865: ROLLBACK TO create_ctr_relationship_pvt;
2866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2867: FND_MSG_PUB.Add_Exc_Msg
2868: ( G_PKG_NAME,
2869: l_api_name
2870: );

Line 2867: FND_MSG_PUB.Add_Exc_Msg

2863: WHEN OTHERS THEN
2864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2865: ROLLBACK TO create_ctr_relationship_pvt;
2866: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2867: FND_MSG_PUB.Add_Exc_Msg
2868: ( G_PKG_NAME,
2869: l_api_name
2870: );
2871: END IF;

Line 2872: FND_MSG_PUB.Count_And_Get

2868: ( G_PKG_NAME,
2869: l_api_name
2870: );
2871: END IF;
2872: FND_MSG_PUB.Count_And_Get
2873: ( p_count => x_msg_count,
2874: p_data => x_msg_data
2875: );
2876: END create_counter_relationship;

Line 2932: FND_MSG_PUB.initialize;

2928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2929: END IF;
2930: -- Initialize message list if p_init_msg_list is set to TRUE.
2931: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2932: FND_MSG_PUB.initialize;
2933: END IF;
2934:
2935: -- Initialize API return status to success
2936: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3144: FND_MSG_PUB.Count_And_Get

3140: IF FND_API.To_Boolean( p_commit ) THEN
3141: COMMIT WORK;
3142: END IF;
3143:
3144: FND_MSG_PUB.Count_And_Get
3145: (p_count => x_msg_count,
3146: p_data => x_msg_data
3147: );
3148:

Line 3153: FND_MSG_PUB.Count_And_Get

3149: EXCEPTION
3150: WHEN FND_API.G_EXC_ERROR THEN
3151: x_return_status := FND_API.G_RET_STS_ERROR ;
3152: ROLLBACK TO create_derived_filters;
3153: FND_MSG_PUB.Count_And_Get
3154: (p_count => x_msg_count,
3155: p_data => x_msg_data
3156: );
3157:

Line 3161: FND_MSG_PUB.Count_And_Get

3157:
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3160: ROLLBACK TO create_derived_filters;
3161: FND_MSG_PUB.Count_And_Get
3162: (p_count => x_msg_count,
3163: p_data => x_msg_data
3164: );
3165: WHEN OTHERS THEN

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

3164: );
3165: WHEN OTHERS THEN
3166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3167: ROLLBACK TO create_derived_filters;
3168: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3169: THEN
3170: FND_MSG_PUB.Add_Exc_Msg
3171: (G_PKG_NAME,
3172: l_api_name

Line 3170: FND_MSG_PUB.Add_Exc_Msg

3166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3167: ROLLBACK TO create_derived_filters;
3168: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3169: THEN
3170: FND_MSG_PUB.Add_Exc_Msg
3171: (G_PKG_NAME,
3172: l_api_name
3173: );
3174: END IF;

Line 3175: FND_MSG_PUB.Count_And_Get

3171: (G_PKG_NAME,
3172: l_api_name
3173: );
3174: END IF;
3175: FND_MSG_PUB.Count_And_Get
3176: (p_count => x_msg_count,
3177: p_data => x_msg_data
3178: );
3179:

Line 3264: FND_MSG_PUB.initialize;

3260: END IF;
3261:
3262: -- Initialize message list if p_init_msg_list is set to TRUE.
3263: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3264: FND_MSG_PUB.initialize;
3265: END IF;
3266:
3267: -- Initialize API return status to success
3268: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3288: FND_MSG_PUB.ADD;

3284: OPEN cur_group_rec(p_counter_groups_rec.counter_group_id);
3285: FETCH cur_group_rec INTO l_old_counter_groups_rec;
3286: IF (l_old_counter_groups_rec.object_version_number <> nvl(p_counter_groups_rec.OBJECT_VERSION_NUMBER,0)) THEN
3287: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
3288: FND_MSG_PUB.ADD;
3289: RAISE FND_API.G_EXC_ERROR;
3290: END IF;
3291:
3292: CLOSE cur_group_rec;

Line 3516: FND_MSG_PUB.Count_And_Get

3512: COMMIT WORK;
3513: END IF;
3514:
3515: -- Standard call to get message count and IF count is get message info.
3516: FND_MSG_PUB.Count_And_Get
3517: ( p_count => x_msg_count,
3518: p_data => x_msg_data
3519: );
3520: EXCEPTION

Line 3524: FND_MSG_PUB.Count_And_Get

3520: EXCEPTION
3521: WHEN FND_API.G_EXC_ERROR THEN
3522: x_return_status := FND_API.G_RET_STS_ERROR ;
3523: ROLLBACK TO update_counter_group_pvt;
3524: FND_MSG_PUB.Count_And_Get
3525: ( p_count => x_msg_count,
3526: p_data => x_msg_data
3527: );
3528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3531: FND_MSG_PUB.Count_And_Get

3527: );
3528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3530: ROLLBACK TO update_counter_group_pvt;
3531: FND_MSG_PUB.Count_And_Get
3532: ( p_count => x_msg_count,
3533: p_data => x_msg_data
3534: );
3535: WHEN OTHERS THEN

Line 3538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3534: );
3535: WHEN OTHERS THEN
3536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3537: ROLLBACK TO update_counter_group_pvt;
3538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3539: FND_MSG_PUB.Add_Exc_Msg
3540: ( G_PKG_NAME,
3541: l_api_name
3542: );

Line 3539: FND_MSG_PUB.Add_Exc_Msg

3535: WHEN OTHERS THEN
3536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3537: ROLLBACK TO update_counter_group_pvt;
3538: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3539: FND_MSG_PUB.Add_Exc_Msg
3540: ( G_PKG_NAME,
3541: l_api_name
3542: );
3543: END IF;

Line 3544: FND_MSG_PUB.Count_And_Get

3540: ( G_PKG_NAME,
3541: l_api_name
3542: );
3543: END IF;
3544: FND_MSG_PUB.Count_And_Get
3545: ( p_count => x_msg_count,
3546: p_data => x_msg_data
3547: );
3548: END update_counter_group;

Line 3637: FND_MSG_PUB.initialize;

3633: END IF;
3634:
3635: -- Initialize message list if p_init_msg_list is set to TRUE.
3636: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3637: FND_MSG_PUB.initialize;
3638: END IF;
3639:
3640: -- Initialize API return status to success
3641: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3660: FND_MSG_PUB.ADD;

3656: OPEN cur_item_assoc_rec(p_ctr_item_associations_rec.ctr_association_id);
3657: FETCH cur_item_assoc_rec INTO l_old_item_associations_rec;
3658: IF (l_old_item_associations_rec.object_version_number <> nvl(p_ctr_item_associations_rec.OBJECT_VERSION_NUMBER,0)) THEN
3659: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
3660: FND_MSG_PUB.ADD;
3661: RAISE FND_API.G_EXC_ERROR;
3662: END IF;
3663:
3664: CLOSE cur_item_assoc_rec;

Line 3984: FND_MSG_PUB.Count_And_Get

3980: COMMIT WORK;
3981: END IF;
3982:
3983: -- Standard call to get message count and IF count is get message info.
3984: FND_MSG_PUB.Count_And_Get
3985: ( p_count => x_msg_count,
3986: p_data => x_msg_data
3987: );
3988: EXCEPTION

Line 3992: FND_MSG_PUB.Count_And_Get

3988: EXCEPTION
3989: WHEN FND_API.G_EXC_ERROR THEN
3990: x_return_status := FND_API.G_RET_STS_ERROR ;
3991: ROLLBACK TO update_item_association_pvt;
3992: FND_MSG_PUB.Count_And_Get
3993: ( p_count => x_msg_count,
3994: p_data => x_msg_data
3995: );
3996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3999: FND_MSG_PUB.Count_And_Get

3995: );
3996: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3998: ROLLBACK TO update_item_association_pvt;
3999: FND_MSG_PUB.Count_And_Get
4000: ( p_count => x_msg_count,
4001: p_data => x_msg_data
4002: );
4003: WHEN OTHERS THEN

Line 4006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4002: );
4003: WHEN OTHERS THEN
4004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4005: ROLLBACK TO update_item_association_pvt;
4006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4007: FND_MSG_PUB.Add_Exc_Msg
4008: ( G_PKG_NAME,
4009: l_api_name
4010: );

Line 4007: FND_MSG_PUB.Add_Exc_Msg

4003: WHEN OTHERS THEN
4004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4005: ROLLBACK TO update_item_association_pvt;
4006: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4007: FND_MSG_PUB.Add_Exc_Msg
4008: ( G_PKG_NAME,
4009: l_api_name
4010: );
4011: END IF;

Line 4012: FND_MSG_PUB.Count_And_Get

4008: ( G_PKG_NAME,
4009: l_api_name
4010: );
4011: END IF;
4012: FND_MSG_PUB.Count_And_Get
4013: ( p_count => x_msg_count,
4014: p_data => x_msg_data
4015: );
4016: END update_item_association;

Line 4162: FND_MSG_PUB.initialize;

4158: END IF;
4159:
4160: -- Initialize message list if p_init_msg_list is set to TRUE.
4161: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4162: FND_MSG_PUB.initialize;
4163: END IF;
4164:
4165: -- Initialize API return status to success
4166: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4185: FND_MSG_PUB.ADD;

4181: OPEN cur_ctr_template_rec(p_counter_template_rec.counter_id);
4182: FETCH cur_ctr_template_rec INTO l_old_counter_template_rec;
4183: IF (l_old_counter_template_rec.object_version_number <> nvl(p_counter_template_rec.OBJECT_VERSION_NUMBER,0)) THEN
4184: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
4185: FND_MSG_PUB.ADD;
4186: RAISE FND_API.G_EXC_ERROR;
4187: END IF;
4188:
4189: CLOSE cur_ctr_template_rec;

Line 4803: FND_MSG_PUB.Count_And_Get

4799: COMMIT WORK;
4800: END IF;
4801:
4802: -- Standard call to get message count and IF count is get message info.
4803: FND_MSG_PUB.Count_And_Get
4804: ( p_count => x_msg_count,
4805: p_data => x_msg_data
4806: );
4807: EXCEPTION

Line 4811: FND_MSG_PUB.Count_And_Get

4807: EXCEPTION
4808: WHEN FND_API.G_EXC_ERROR THEN
4809: x_return_status := FND_API.G_RET_STS_ERROR ;
4810: ROLLBACK TO update_counter_template_pvt;
4811: FND_MSG_PUB.Count_And_Get
4812: ( p_count => x_msg_count,
4813: p_data => x_msg_data
4814: );
4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4818: FND_MSG_PUB.Count_And_Get

4814: );
4815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4817: ROLLBACK TO update_counter_template_pvt;
4818: FND_MSG_PUB.Count_And_Get
4819: ( p_count => x_msg_count,
4820: p_data => x_msg_data
4821: );
4822: WHEN OTHERS THEN

Line 4825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4821: );
4822: WHEN OTHERS THEN
4823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4824: ROLLBACK TO update_counter_template_pvt;
4825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4826: FND_MSG_PUB.Add_Exc_Msg
4827: ( G_PKG_NAME,
4828: l_api_name
4829: );

Line 4826: FND_MSG_PUB.Add_Exc_Msg

4822: WHEN OTHERS THEN
4823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4824: ROLLBACK TO update_counter_template_pvt;
4825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4826: FND_MSG_PUB.Add_Exc_Msg
4827: ( G_PKG_NAME,
4828: l_api_name
4829: );
4830: END IF;

Line 4831: FND_MSG_PUB.Count_And_Get

4827: ( G_PKG_NAME,
4828: l_api_name
4829: );
4830: END IF;
4831: FND_MSG_PUB.Count_And_Get
4832: ( p_count => x_msg_count,
4833: p_data => x_msg_data
4834: );
4835: END update_counter_template;

Line 4920: FND_MSG_PUB.initialize;

4916: END IF;
4917:
4918: -- Initialize message list if p_init_msg_list is set to TRUE.
4919: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4920: FND_MSG_PUB.initialize;
4921: END IF;
4922:
4923: -- Initialize API return status to success
4924: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4943: FND_MSG_PUB.ADD;

4939: OPEN cur_ctr_prop_rec(p_ctr_property_template_rec.counter_property_id);
4940: FETCH cur_ctr_prop_rec INTO l_old_ctr_property_tmpl_rec;
4941: IF (l_old_ctr_property_tmpl_rec.object_version_number <> nvl(p_ctr_property_template_rec.OBJECT_VERSION_NUMBER,0)) THEN
4942: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
4943: FND_MSG_PUB.ADD;
4944: RAISE FND_API.G_EXC_ERROR;
4945: END IF;
4946:
4947: CLOSE cur_ctr_prop_rec;

Line 5212: FND_MSG_PUB.Count_And_Get

5208: COMMIT WORK;
5209: END IF;
5210:
5211: -- Standard call to get message count and IF count is get message info.
5212: FND_MSG_PUB.Count_And_Get
5213: ( p_count => x_msg_count,
5214: p_data => x_msg_data
5215: );
5216: EXCEPTION

Line 5220: FND_MSG_PUB.Count_And_Get

5216: EXCEPTION
5217: WHEN FND_API.G_EXC_ERROR THEN
5218: x_return_status := FND_API.G_RET_STS_ERROR ;
5219: ROLLBACK TO update_ctr_property_tmpl_pvt;
5220: FND_MSG_PUB.Count_And_Get
5221: ( p_count => x_msg_count,
5222: p_data => x_msg_data
5223: );
5224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5227: FND_MSG_PUB.Count_And_Get

5223: );
5224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5226: ROLLBACK TO update_ctr_property_tmpl_pvt;
5227: FND_MSG_PUB.Count_And_Get
5228: ( p_count => x_msg_count,
5229: p_data => x_msg_data
5230: );
5231: WHEN OTHERS THEN

Line 5234: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5230: );
5231: WHEN OTHERS THEN
5232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5233: ROLLBACK TO update_ctr_property_tmpl_pvt;
5234: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5235: FND_MSG_PUB.Add_Exc_Msg
5236: ( G_PKG_NAME,
5237: l_api_name
5238: );

Line 5235: FND_MSG_PUB.Add_Exc_Msg

5231: WHEN OTHERS THEN
5232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5233: ROLLBACK TO update_ctr_property_tmpl_pvt;
5234: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5235: FND_MSG_PUB.Add_Exc_Msg
5236: ( G_PKG_NAME,
5237: l_api_name
5238: );
5239: END IF;

Line 5240: FND_MSG_PUB.Count_And_Get

5236: ( G_PKG_NAME,
5237: l_api_name
5238: );
5239: END IF;
5240: FND_MSG_PUB.Count_And_Get
5241: ( p_count => x_msg_count,
5242: p_data => x_msg_data
5243: );
5244: END update_ctr_property_template;

Line 5339: FND_MSG_PUB.initialize;

5335: END IF;
5336:
5337: -- Initialize message list if p_init_msg_list is set to TRUE.
5338: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5339: FND_MSG_PUB.initialize;
5340: END IF;
5341:
5342: -- Initialize API return status to success
5343: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5369: FND_MSG_PUB.ADD;

5365: END IF;
5366:
5367: IF (l_old_ctr_relationships_rec.object_version_number <> nvl(p_counter_relationships_rec.OBJECT_VERSION_NUMBER,0)) THEN
5368: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
5369: FND_MSG_PUB.ADD;
5370: RAISE FND_API.G_EXC_ERROR;
5371: END IF;
5372:
5373: CLOSE cur_rel_rec;

Line 5664: FND_MSG_PUB.Count_And_Get

5660: COMMIT WORK;
5661: END IF;
5662:
5663: -- Standard call to get message count and IF count is get message info.
5664: FND_MSG_PUB.Count_And_Get
5665: ( p_count => x_msg_count,
5666: p_data => x_msg_data
5667: );
5668: EXCEPTION

Line 5672: FND_MSG_PUB.Count_And_Get

5668: EXCEPTION
5669: WHEN FND_API.G_EXC_ERROR THEN
5670: x_return_status := FND_API.G_RET_STS_ERROR ;
5671: ROLLBACK TO update_ctr_relationship_pvt;
5672: FND_MSG_PUB.Count_And_Get
5673: ( p_count => x_msg_count,
5674: p_data => x_msg_data
5675: );
5676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5679: FND_MSG_PUB.Count_And_Get

5675: );
5676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5678: ROLLBACK TO update_ctr_relationship_pvt;
5679: FND_MSG_PUB.Count_And_Get
5680: ( p_count => x_msg_count,
5681: p_data => x_msg_data
5682: );
5683: WHEN OTHERS THEN

Line 5686: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5682: );
5683: WHEN OTHERS THEN
5684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5685: ROLLBACK TO update_ctr_relationship_pvt;
5686: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5687: FND_MSG_PUB.Add_Exc_Msg
5688: ( G_PKG_NAME,
5689: l_api_name
5690: );

Line 5687: FND_MSG_PUB.Add_Exc_Msg

5683: WHEN OTHERS THEN
5684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5685: ROLLBACK TO update_ctr_relationship_pvt;
5686: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5687: FND_MSG_PUB.Add_Exc_Msg
5688: ( G_PKG_NAME,
5689: l_api_name
5690: );
5691: END IF;

Line 5692: FND_MSG_PUB.Count_And_Get

5688: ( G_PKG_NAME,
5689: l_api_name
5690: );
5691: END IF;
5692: FND_MSG_PUB.Count_And_Get
5693: ( p_count => x_msg_count,
5694: p_data => x_msg_data
5695: );
5696: END update_counter_relationship;

Line 5759: FND_MSG_PUB.initialize;

5755: END IF;
5756:
5757: -- Initialize message list if p_init_msg_list is set to TRUE.
5758: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5759: FND_MSG_PUB.initialize;
5760: END IF;
5761:
5762: -- Initialize API return status to success
5763: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5809: x_msg_data := FND_MSG_PUB.GET

5805: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5806: l_msg_index := 1;
5807: l_msg_count := x_msg_count;
5808: WHILE l_msg_count > 0 LOOP
5809: x_msg_data := FND_MSG_PUB.GET
5810: (l_msg_index,
5811: FND_API.G_FALSE);
5812: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');
5813: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 6053: FND_MSG_PUB.Count_And_Get

6049: IF FND_API.To_Boolean( p_commit ) THEN
6050: COMMIT WORK;
6051: END IF;
6052:
6053: FND_MSG_PUB.Count_And_Get
6054: ( p_count => x_msg_count,
6055: p_data => x_msg_data
6056: );
6057:

Line 6062: FND_MSG_PUB.Count_And_Get

6058: EXCEPTION
6059: WHEN FND_API.G_EXC_ERROR THEN
6060: x_return_status := FND_API.G_RET_STS_ERROR ;
6061: ROLLBACK TO update_derived_filters;
6062: FND_MSG_PUB.Count_And_Get
6063: (p_count => x_msg_count,
6064: p_data => x_msg_data
6065: );
6066:

Line 6070: FND_MSG_PUB.Count_And_Get

6066:
6067: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6069: ROLLBACK TO update_derived_filters;
6070: FND_MSG_PUB.Count_And_Get
6071: (p_count => x_msg_count,
6072: p_data => x_msg_data
6073: );
6074: WHEN OTHERS THEN

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

6073: );
6074: WHEN OTHERS THEN
6075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6076: ROLLBACK TO update_derived_filters;
6077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6078: THEN
6079: FND_MSG_PUB.Add_Exc_Msg
6080: (G_PKG_NAME,
6081: l_api_name

Line 6079: FND_MSG_PUB.Add_Exc_Msg

6075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6076: ROLLBACK TO update_derived_filters;
6077: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6078: THEN
6079: FND_MSG_PUB.Add_Exc_Msg
6080: (G_PKG_NAME,
6081: l_api_name
6082: );
6083: END IF;

Line 6084: FND_MSG_PUB.Count_And_Get

6080: (G_PKG_NAME,
6081: l_api_name
6082: );
6083: END IF;
6084: FND_MSG_PUB.Count_And_Get
6085: (p_count => x_msg_count,
6086: p_data => x_msg_data
6087: );
6088:

Line 6160: FND_MSG_PUB.initialize;

6156: END IF;
6157:
6158: -- Initialize message list if p_init_msg_list is set to TRUE.
6159: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
6160: FND_MSG_PUB.initialize;
6161: END IF;
6162:
6163: -- Initialize API return status to success
6164: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6420: FND_MSG_PUB.Count_And_Get

6416: COMMIT WORK;
6417: END IF;
6418:
6419: -- Standard call to get message count and IF count is get message info.
6420: FND_MSG_PUB.Count_And_Get
6421: ( p_count => x_msg_count,
6422: p_data => x_msg_data
6423: );
6424: EXCEPTION

Line 6428: FND_MSG_PUB.Count_And_Get

6424: EXCEPTION
6425: WHEN FND_API.G_EXC_ERROR THEN
6426: x_return_status := FND_API.G_RET_STS_ERROR ;
6427: ROLLBACK TO create_estimation_method_pvt;
6428: FND_MSG_PUB.Count_And_Get
6429: ( p_count => x_msg_count,
6430: p_data => x_msg_data
6431: );
6432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6435: FND_MSG_PUB.Count_And_Get

6431: );
6432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6434: ROLLBACK TO create_estimation_method_pvt;
6435: FND_MSG_PUB.Count_And_Get
6436: ( p_count => x_msg_count,
6437: p_data => x_msg_data
6438: );
6439: WHEN OTHERS THEN

Line 6442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6438: );
6439: WHEN OTHERS THEN
6440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6441: ROLLBACK TO create_estimation_method_pvt;
6442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6443: FND_MSG_PUB.Add_Exc_Msg
6444: ( G_PKG_NAME,
6445: l_api_name
6446: );

Line 6443: FND_MSG_PUB.Add_Exc_Msg

6439: WHEN OTHERS THEN
6440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6441: ROLLBACK TO create_estimation_method_pvt;
6442: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6443: FND_MSG_PUB.Add_Exc_Msg
6444: ( G_PKG_NAME,
6445: l_api_name
6446: );
6447: END IF;

Line 6448: FND_MSG_PUB.Count_And_Get

6444: ( G_PKG_NAME,
6445: l_api_name
6446: );
6447: END IF;
6448: FND_MSG_PUB.Count_And_Get
6449: ( p_count => x_msg_count,
6450: p_data => x_msg_data
6451: );
6452: END create_estimation_method;

Line 6526: FND_MSG_PUB.initialize;

6522: END IF;
6523:
6524: -- Initialize message list if p_init_msg_list is set to TRUE.
6525: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
6526: FND_MSG_PUB.initialize;
6527: END IF;
6528:
6529: -- Initialize API return status to success
6530: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6549: FND_MSG_PUB.ADD;

6545: OPEN cur_estimation_rec(p_ctr_estimation_rec.estimation_id);
6546: FETCH cur_estimation_rec INTO l_old_ctr_estimation_rec;
6547: IF (l_old_ctr_estimation_rec.object_version_number <> nvl(p_ctr_estimation_rec.OBJECT_VERSION_NUMBER,0)) THEN
6548: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
6549: FND_MSG_PUB.ADD;
6550: RAISE FND_API.G_EXC_ERROR;
6551: END IF;
6552:
6553: CLOSE cur_estimation_rec;

Line 6780: FND_MSG_PUB.Count_And_Get

6776: COMMIT WORK;
6777: END IF;
6778:
6779: -- Standard call to get message count and IF count is get message info.
6780: FND_MSG_PUB.Count_And_Get
6781: ( p_count => x_msg_count,
6782: p_data => x_msg_data
6783: );
6784: EXCEPTION

Line 6788: FND_MSG_PUB.Count_And_Get

6784: EXCEPTION
6785: WHEN FND_API.G_EXC_ERROR THEN
6786: x_return_status := FND_API.G_RET_STS_ERROR ;
6787: ROLLBACK TO update_estimation_method_pvt;
6788: FND_MSG_PUB.Count_And_Get
6789: ( p_count => x_msg_count,
6790: p_data => x_msg_data
6791: );
6792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6795: FND_MSG_PUB.Count_And_Get

6791: );
6792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6794: ROLLBACK TO update_estimation_method_pvt;
6795: FND_MSG_PUB.Count_And_Get
6796: ( p_count => x_msg_count,
6797: p_data => x_msg_data
6798: );
6799: WHEN OTHERS THEN

Line 6802: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6798: );
6799: WHEN OTHERS THEN
6800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6801: ROLLBACK TO update_estimation_method_pvt;
6802: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6803: FND_MSG_PUB.Add_Exc_Msg
6804: ( G_PKG_NAME,
6805: l_api_name
6806: );

Line 6803: FND_MSG_PUB.Add_Exc_Msg

6799: WHEN OTHERS THEN
6800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6801: ROLLBACK TO update_estimation_method_pvt;
6802: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6803: FND_MSG_PUB.Add_Exc_Msg
6804: ( G_PKG_NAME,
6805: l_api_name
6806: );
6807: END IF;

Line 6808: FND_MSG_PUB.Count_And_Get

6804: ( G_PKG_NAME,
6805: l_api_name
6806: );
6807: END IF;
6808: FND_MSG_PUB.Count_And_Get
6809: ( p_count => x_msg_count,
6810: p_data => x_msg_data
6811: );
6812: END update_estimation_method;

Line 7137: FND_MSG_PUB.initialize;

7133: END IF;
7134:
7135: -- Initialize message list if p_init_msg_list is set to TRUE.
7136: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
7137: FND_MSG_PUB.initialize;
7138: END IF;
7139:
7140: -- Initialize API return status to success
7141: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7287: x_msg_data := FND_MSG_PUB.GET

7283: l_msg_index := 1;
7284: l_msg_count := x_msg_count;
7285:
7286: WHILE l_msg_count > 0 LOOP
7287: x_msg_data := FND_MSG_PUB.GET
7288: (l_msg_index,
7289: FND_API.G_FALSE );
7290: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_COUNTER');
7291: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7327: x_msg_data := FND_MSG_PUB.GET

7323: l_msg_index := 1;
7324: l_msg_count := x_msg_count;
7325:
7326: WHILE l_msg_count > 0 LOOP
7327: x_msg_data := FND_MSG_PUB.GET
7328: (l_msg_index,
7329: FND_API.G_FALSE );
7330: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS');
7331: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7419: x_msg_data := FND_MSG_PUB.GET

7415: l_msg_index := 1;
7416: l_msg_count := x_msg_count;
7417:
7418: WHILE l_msg_count > 0 LOOP
7419: x_msg_data := FND_MSG_PUB.GET
7420: (l_msg_index,
7421: FND_API.G_FALSE );
7422: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate-Capture Readings');
7423: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7490: x_msg_data := FND_MSG_PUB.GET

7486: l_msg_index := 1;
7487: l_msg_count := x_msg_count;
7488:
7489: WHILE l_msg_count > 0 LOOP
7490: x_msg_data := FND_MSG_PUB.GET
7491: (l_msg_index,
7492: FND_API.G_FALSE );
7493: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_Counter_PVT.Create_Ctr_Property');
7494: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7573: x_msg_data := FND_MSG_PUB.GET

7569: l_msg_index := 1;
7570: l_msg_count := x_msg_count;
7571:
7572: WHILE l_msg_count > 0 LOOP
7573: x_msg_data := FND_MSG_PUB.GET
7574: (l_msg_index,
7575: FND_API.G_FALSE );
7576: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');
7577: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7729: FND_MSG_PUB.Count_And_Get

7725: COMMIT WORK;
7726: END IF;
7727:
7728: -- Standard call to get message count and IF count is get message info.
7729: FND_MSG_PUB.Count_And_Get
7730: ( p_count => x_msg_count,
7731: p_data => x_msg_data
7732: );
7733: EXCEPTION

Line 7737: FND_MSG_PUB.Count_And_Get

7733: EXCEPTION
7734: WHEN FND_API.G_EXC_ERROR THEN
7735: x_return_status := FND_API.G_RET_STS_ERROR ;
7736: ROLLBACK TO instantiate_ctr_pvt;
7737: FND_MSG_PUB.Count_And_Get
7738: ( p_count => x_msg_count,
7739: p_data => x_msg_data
7740: );
7741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7744: FND_MSG_PUB.Count_And_Get

7740: );
7741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7743: ROLLBACK TO instantiate_ctr_pvt;
7744: FND_MSG_PUB.Count_And_Get
7745: ( p_count => x_msg_count,
7746: p_data => x_msg_data
7747: );
7748: WHEN OTHERS THEN

Line 7751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7747: );
7748: WHEN OTHERS THEN
7749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7750: ROLLBACK TO instantiate_ctr_pvt;
7751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7752: FND_MSG_PUB.Add_Exc_Msg
7753: ( G_PKG_NAME,
7754: l_api_name
7755: );

Line 7752: FND_MSG_PUB.Add_Exc_Msg

7748: WHEN OTHERS THEN
7749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7750: ROLLBACK TO instantiate_ctr_pvt;
7751: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7752: FND_MSG_PUB.Add_Exc_Msg
7753: ( G_PKG_NAME,
7754: l_api_name
7755: );
7756: END IF;

Line 7757: FND_MSG_PUB.Count_And_Get

7753: ( G_PKG_NAME,
7754: l_api_name
7755: );
7756: END IF;
7757: FND_MSG_PUB.Count_And_Get
7758: ( p_count => x_msg_count,
7759: p_data => x_msg_data
7760: );
7761: END Instantiate_Counters;

Line 8071: FND_MSG_PUB.initialize;

8067: END IF;
8068:
8069: -- Initialize message list if p_init_msg_list is set to TRUE.
8070: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
8071: FND_MSG_PUB.initialize;
8072: END IF;
8073:
8074: -- Initialize API return status to success
8075: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8167: x_msg_data := FND_MSG_PUB.GET

8163: l_msg_index := 1;
8164: l_msg_count := x_msg_count;
8165:
8166: WHILE l_msg_count > 0 LOOP
8167: x_msg_data := FND_MSG_PUB.GET
8168: (l_msg_index,
8169: FND_API.G_FALSE );
8170: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_GROUP');
8171: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8305: x_msg_data := FND_MSG_PUB.GET

8301: l_msg_index := 1;
8302: l_msg_count := x_msg_count;
8303:
8304: WHILE l_msg_count > 0 LOOP
8305: x_msg_data := FND_MSG_PUB.GET
8306: (l_msg_index,
8307: FND_API.G_FALSE );
8308: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_COUNTER');
8309: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8343: x_msg_data := FND_MSG_PUB.GET

8339: l_msg_index := 1;
8340: l_msg_count := x_msg_count;
8341:
8342: WHILE l_msg_count > 0 LOOP
8343: x_msg_data := FND_MSG_PUB.GET
8344: (l_msg_index,
8345: FND_API.G_FALSE );
8346: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS');
8347: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8413: x_msg_data := FND_MSG_PUB.GET

8409: l_msg_index := 1;
8410: l_msg_count := x_msg_count;
8411:
8412: WHILE l_msg_count > 0 LOOP
8413: x_msg_data := FND_MSG_PUB.GET
8414: (l_msg_index,
8415: FND_API.G_FALSE );
8416: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_Counter_PVT.Create_Ctr_Property');
8417: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8463: x_msg_data := FND_MSG_PUB.GET

8459: l_msg_index := 1;
8460: l_msg_count := x_msg_count;
8461:
8462: WHILE l_msg_count > 0 LOOP
8463: x_msg_data := FND_MSG_PUB.GET
8464: (l_msg_index,
8465: FND_API.G_FALSE );
8466: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');
8467: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8632: FND_MSG_PUB.Count_And_Get

8628: COMMIT WORK;
8629: END IF;
8630:
8631: -- Standard call to get message count and IF count is get message info.
8632: FND_MSG_PUB.Count_And_Get
8633: ( p_count => x_msg_count,
8634: p_data => x_msg_data
8635: );
8636: EXCEPTION

Line 8640: FND_MSG_PUB.Count_And_Get

8636: EXCEPTION
8637: WHEN FND_API.G_EXC_ERROR THEN
8638: x_return_status := FND_API.G_RET_STS_ERROR ;
8639: ROLLBACK TO instantiate_grp_counters;
8640: FND_MSG_PUB.Count_And_Get
8641: ( p_count => x_msg_count,
8642: p_data => x_msg_data
8643: );
8644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8647: FND_MSG_PUB.Count_And_Get

8643: );
8644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8645: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8646: ROLLBACK TO instantiate_grp_counters;
8647: FND_MSG_PUB.Count_And_Get
8648: ( p_count => x_msg_count,
8649: p_data => x_msg_data
8650: );
8651: WHEN OTHERS THEN

Line 8654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8650: );
8651: WHEN OTHERS THEN
8652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8653: ROLLBACK TO instantiate_grp_counters;
8654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8655: FND_MSG_PUB.Add_Exc_Msg
8656: ( G_PKG_NAME,
8657: l_api_name
8658: );

Line 8655: FND_MSG_PUB.Add_Exc_Msg

8651: WHEN OTHERS THEN
8652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8653: ROLLBACK TO instantiate_grp_counters;
8654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8655: FND_MSG_PUB.Add_Exc_Msg
8656: ( G_PKG_NAME,
8657: l_api_name
8658: );
8659: END IF;

Line 8660: FND_MSG_PUB.Count_And_Get

8656: ( G_PKG_NAME,
8657: l_api_name
8658: );
8659: END IF;
8660: FND_MSG_PUB.Count_And_Get
8661: ( p_count => x_msg_count,
8662: p_data => x_msg_data
8663: );
8664: END Instantiate_Grp_Counters;

Line 8725: FND_MSG_PUB.initialize;

8721: END IF;
8722:
8723: -- Initialize message list if p_init_msg_list is set to TRUE.
8724: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
8725: FND_MSG_PUB.initialize;
8726: END IF;
8727:
8728: -- Initialize API return status to success
8729: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8840: FND_MSG_PUB.Count_And_Get

8836: COMMIT WORK;
8837: END IF;
8838:
8839: -- Standard call to get message count and IF count is get message info.
8840: FND_MSG_PUB.Count_And_Get
8841: ( p_count => x_msg_count,
8842: p_data => x_msg_data
8843: );
8844: EXCEPTION

Line 8848: FND_MSG_PUB.Count_And_Get

8844: EXCEPTION
8845: WHEN FND_API.G_EXC_ERROR THEN
8846: x_return_status := FND_API.G_RET_STS_ERROR ;
8847: ROLLBACK TO delete_item_association_pvt;
8848: FND_MSG_PUB.Count_And_Get
8849: ( p_count => x_msg_count,
8850: p_data => x_msg_data
8851: );
8852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8855: FND_MSG_PUB.Count_And_Get

8851: );
8852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8854: ROLLBACK TO delete_item_association_pvt;
8855: FND_MSG_PUB.Count_And_Get
8856: ( p_count => x_msg_count,
8857: p_data => x_msg_data
8858: );
8859: WHEN OTHERS THEN

Line 8862: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8858: );
8859: WHEN OTHERS THEN
8860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8861: ROLLBACK TO create_item_association_pvt;
8862: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8863: FND_MSG_PUB.Add_Exc_Msg
8864: ( G_PKG_NAME,
8865: l_api_name
8866: );

Line 8863: FND_MSG_PUB.Add_Exc_Msg

8859: WHEN OTHERS THEN
8860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8861: ROLLBACK TO create_item_association_pvt;
8862: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8863: FND_MSG_PUB.Add_Exc_Msg
8864: ( G_PKG_NAME,
8865: l_api_name
8866: );
8867: END IF;

Line 8868: FND_MSG_PUB.Count_And_Get

8864: ( G_PKG_NAME,
8865: l_api_name
8866: );
8867: END IF;
8868: FND_MSG_PUB.Count_And_Get
8869: ( p_count => x_msg_count,
8870: p_data => x_msg_data
8871: );
8872: END delete_item_association;