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.

[Home] [Help]

APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on FND_MSG_PUB

Line 564: FND_MSG_PUB.initialize;

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

Line 792: FND_MSG_PUB.Count_And_Get

788: COMMIT WORK;
789: END IF;
790:
791: -- Standard call to get message count and IF count is get message info.
792: FND_MSG_PUB.Count_And_Get
793: ( p_count => x_msg_count,
794: p_data => x_msg_data
795: );
796: EXCEPTION

Line 800: FND_MSG_PUB.Count_And_Get

796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_ERROR ;
799: ROLLBACK TO create_counter_group_pvt;
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );
804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 807: FND_MSG_PUB.Count_And_Get

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

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

810: );
811: WHEN OTHERS THEN
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
813: ROLLBACK TO create_counter_group_pvt;
814: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
815: FND_MSG_PUB.Add_Exc_Msg
816: ( G_PKG_NAME,
817: l_api_name
818: );

Line 815: FND_MSG_PUB.Add_Exc_Msg

811: WHEN OTHERS THEN
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
813: ROLLBACK TO create_counter_group_pvt;
814: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
815: FND_MSG_PUB.Add_Exc_Msg
816: ( G_PKG_NAME,
817: l_api_name
818: );
819: END IF;

Line 820: FND_MSG_PUB.Count_And_Get

816: ( G_PKG_NAME,
817: l_api_name
818: );
819: END IF;
820: FND_MSG_PUB.Count_And_Get
821: ( p_count => x_msg_count,
822: p_data => x_msg_data
823: );
824: END create_counter_group;

Line 915: FND_MSG_PUB.initialize;

911: END IF;
912:
913: -- Initialize message list if p_init_msg_list is set to TRUE.
914: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
915: FND_MSG_PUB.initialize;
916: END IF;
917:
918: -- Read the debug profiles values in to global variable 7197402
919: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

Line 1291: FND_MSG_PUB.Count_And_Get

1287: COMMIT WORK;
1288: END IF;
1289:
1290: -- Standard call to get message count and IF count is get message info.
1291: FND_MSG_PUB.Count_And_Get
1292: ( p_count => x_msg_count,
1293: p_data => x_msg_data
1294: );
1295: EXCEPTION

Line 1299: FND_MSG_PUB.Count_And_Get

1295: EXCEPTION
1296: WHEN FND_API.G_EXC_ERROR THEN
1297: x_return_status := FND_API.G_RET_STS_ERROR ;
1298: ROLLBACK TO create_item_association_pvt;
1299: FND_MSG_PUB.Count_And_Get
1300: ( p_count => x_msg_count,
1301: p_data => x_msg_data
1302: );
1303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1306: FND_MSG_PUB.Count_And_Get

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

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

1309: );
1310: WHEN OTHERS THEN
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1312: ROLLBACK TO create_item_association_pvt;
1313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1314: FND_MSG_PUB.Add_Exc_Msg
1315: ( G_PKG_NAME,
1316: l_api_name
1317: );

Line 1314: FND_MSG_PUB.Add_Exc_Msg

1310: WHEN OTHERS THEN
1311: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1312: ROLLBACK TO create_item_association_pvt;
1313: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1314: FND_MSG_PUB.Add_Exc_Msg
1315: ( G_PKG_NAME,
1316: l_api_name
1317: );
1318: END IF;

Line 1319: FND_MSG_PUB.Count_And_Get

1315: ( G_PKG_NAME,
1316: l_api_name
1317: );
1318: END IF;
1319: FND_MSG_PUB.Count_And_Get
1320: ( p_count => x_msg_count,
1321: p_data => x_msg_data
1322: );
1323: END create_item_association;

Line 1442: FND_MSG_PUB.initialize;

1438: END IF;
1439:
1440: -- Initialize message list if p_init_msg_list is set to TRUE.
1441: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1442: FND_MSG_PUB.initialize;
1443: END IF;
1444:
1445: -- Read the debug profiles values in to global variable 7197402
1446: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

Line 1898: x_msg_data := FND_MSG_PUB.GET

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

Line 2022: FND_MSG_PUB.Count_And_Get

2018: COMMIT WORK;
2019: END IF;
2020:
2021: -- Standard call to get message count and IF count is get message info.
2022: FND_MSG_PUB.Count_And_Get
2023: ( p_count => x_msg_count,
2024: p_data => x_msg_data
2025: );
2026: EXCEPTION

Line 2030: FND_MSG_PUB.Count_And_Get

2026: EXCEPTION
2027: WHEN FND_API.G_EXC_ERROR THEN
2028: x_return_status := FND_API.G_RET_STS_ERROR ;
2029: ROLLBACK TO create_counter_template_pvt;
2030: FND_MSG_PUB.Count_And_Get
2031: ( p_count => x_msg_count,
2032: p_data => x_msg_data
2033: );
2034: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2037: FND_MSG_PUB.Count_And_Get

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

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

2040: );
2041: WHEN OTHERS THEN
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2043: ROLLBACK TO create_counter_template_pvt;
2044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2045: FND_MSG_PUB.Add_Exc_Msg
2046: ( G_PKG_NAME,
2047: l_api_name
2048: );

Line 2045: FND_MSG_PUB.Add_Exc_Msg

2041: WHEN OTHERS THEN
2042: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2043: ROLLBACK TO create_counter_template_pvt;
2044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2045: FND_MSG_PUB.Add_Exc_Msg
2046: ( G_PKG_NAME,
2047: l_api_name
2048: );
2049: END IF;

Line 2050: FND_MSG_PUB.Count_And_Get

2046: ( G_PKG_NAME,
2047: l_api_name
2048: );
2049: END IF;
2050: FND_MSG_PUB.Count_And_Get
2051: ( p_count => x_msg_count,
2052: p_data => x_msg_data
2053: );
2054: END create_counter_template;

Line 2131: FND_MSG_PUB.initialize;

2127: END IF;
2128:
2129: -- Initialize message list if p_init_msg_list is set to TRUE.
2130: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2131: FND_MSG_PUB.initialize;
2132: END IF;
2133:
2134: -- Read the debug profiles values in to global variable 7197402
2135: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

Line 2406: FND_MSG_PUB.Count_And_Get

2402: COMMIT WORK;
2403: END IF;
2404:
2405: -- Standard call to get message count and IF count is get message info.
2406: FND_MSG_PUB.Count_And_Get
2407: ( p_count => x_msg_count,
2408: p_data => x_msg_data
2409: );
2410: EXCEPTION

Line 2414: FND_MSG_PUB.Count_And_Get

2410: EXCEPTION
2411: WHEN FND_API.G_EXC_ERROR THEN
2412: x_return_status := FND_API.G_RET_STS_ERROR ;
2413: ROLLBACK TO create_ctr_property_tmpl_pvt;
2414: FND_MSG_PUB.Count_And_Get
2415: ( p_count => x_msg_count,
2416: p_data => x_msg_data
2417: );
2418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2421: FND_MSG_PUB.Count_And_Get

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

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

2424: );
2425: WHEN OTHERS THEN
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2427: ROLLBACK TO create_ctr_property_tmpl_pvt;
2428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2429: FND_MSG_PUB.Add_Exc_Msg
2430: ( G_PKG_NAME,
2431: l_api_name
2432: );

Line 2429: FND_MSG_PUB.Add_Exc_Msg

2425: WHEN OTHERS THEN
2426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2427: ROLLBACK TO create_ctr_property_tmpl_pvt;
2428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2429: FND_MSG_PUB.Add_Exc_Msg
2430: ( G_PKG_NAME,
2431: l_api_name
2432: );
2433: END IF;

Line 2434: FND_MSG_PUB.Count_And_Get

2430: ( G_PKG_NAME,
2431: l_api_name
2432: );
2433: END IF;
2434: FND_MSG_PUB.Count_And_Get
2435: ( p_count => x_msg_count,
2436: p_data => x_msg_data
2437: );
2438: END create_ctr_property_template;

Line 2525: FND_MSG_PUB.initialize;

2521: END IF;
2522:
2523: -- Initialize message list if p_init_msg_list is set to TRUE.
2524: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
2525: FND_MSG_PUB.initialize;
2526: END IF;
2527:
2528: -- Read the debug profiles values in to global variable 7197402
2529: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;

Line 2831: FND_MSG_PUB.Count_And_Get

2827: COMMIT WORK;
2828: END IF;
2829:
2830: -- Standard call to get message count and IF count is get message info.
2831: FND_MSG_PUB.Count_And_Get
2832: ( p_count => x_msg_count,
2833: p_data => x_msg_data
2834: );
2835: EXCEPTION

Line 2839: FND_MSG_PUB.Count_And_Get

2835: EXCEPTION
2836: WHEN FND_API.G_EXC_ERROR THEN
2837: x_return_status := FND_API.G_RET_STS_ERROR ;
2838: ROLLBACK TO create_ctr_relationship_pvt;
2839: FND_MSG_PUB.Count_And_Get
2840: ( p_count => x_msg_count,
2841: p_data => x_msg_data
2842: );
2843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2846: FND_MSG_PUB.Count_And_Get

2842: );
2843: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2845: ROLLBACK TO create_ctr_relationship_pvt;
2846: FND_MSG_PUB.Count_And_Get
2847: ( p_count => x_msg_count,
2848: p_data => x_msg_data
2849: );
2850: WHEN OTHERS THEN

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

2849: );
2850: WHEN OTHERS THEN
2851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2852: ROLLBACK TO create_ctr_relationship_pvt;
2853: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2854: FND_MSG_PUB.Add_Exc_Msg
2855: ( G_PKG_NAME,
2856: l_api_name
2857: );

Line 2854: FND_MSG_PUB.Add_Exc_Msg

2850: WHEN OTHERS THEN
2851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2852: ROLLBACK TO create_ctr_relationship_pvt;
2853: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2854: FND_MSG_PUB.Add_Exc_Msg
2855: ( G_PKG_NAME,
2856: l_api_name
2857: );
2858: END IF;

Line 2859: FND_MSG_PUB.Count_And_Get

2855: ( G_PKG_NAME,
2856: l_api_name
2857: );
2858: END IF;
2859: FND_MSG_PUB.Count_And_Get
2860: ( p_count => x_msg_count,
2861: p_data => x_msg_data
2862: );
2863: END create_counter_relationship;

Line 2919: FND_MSG_PUB.initialize;

2915: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2916: END IF;
2917: -- Initialize message list if p_init_msg_list is set to TRUE.
2918: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2919: FND_MSG_PUB.initialize;
2920: END IF;
2921:
2922: -- Initialize API return status to success
2923: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3131: FND_MSG_PUB.Count_And_Get

3127: IF FND_API.To_Boolean( p_commit ) THEN
3128: COMMIT WORK;
3129: END IF;
3130:
3131: FND_MSG_PUB.Count_And_Get
3132: (p_count => x_msg_count,
3133: p_data => x_msg_data
3134: );
3135:

Line 3140: FND_MSG_PUB.Count_And_Get

3136: EXCEPTION
3137: WHEN FND_API.G_EXC_ERROR THEN
3138: x_return_status := FND_API.G_RET_STS_ERROR ;
3139: ROLLBACK TO create_derived_filters;
3140: FND_MSG_PUB.Count_And_Get
3141: (p_count => x_msg_count,
3142: p_data => x_msg_data
3143: );
3144:

Line 3148: FND_MSG_PUB.Count_And_Get

3144:
3145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3147: ROLLBACK TO create_derived_filters;
3148: FND_MSG_PUB.Count_And_Get
3149: (p_count => x_msg_count,
3150: p_data => x_msg_data
3151: );
3152: WHEN OTHERS THEN

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

3151: );
3152: WHEN OTHERS THEN
3153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3154: ROLLBACK TO create_derived_filters;
3155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3156: THEN
3157: FND_MSG_PUB.Add_Exc_Msg
3158: (G_PKG_NAME,
3159: l_api_name

Line 3157: FND_MSG_PUB.Add_Exc_Msg

3153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3154: ROLLBACK TO create_derived_filters;
3155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3156: THEN
3157: FND_MSG_PUB.Add_Exc_Msg
3158: (G_PKG_NAME,
3159: l_api_name
3160: );
3161: END IF;

Line 3162: FND_MSG_PUB.Count_And_Get

3158: (G_PKG_NAME,
3159: l_api_name
3160: );
3161: END IF;
3162: FND_MSG_PUB.Count_And_Get
3163: (p_count => x_msg_count,
3164: p_data => x_msg_data
3165: );
3166:

Line 3251: FND_MSG_PUB.initialize;

3247: END IF;
3248:
3249: -- Initialize message list if p_init_msg_list is set to TRUE.
3250: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3251: FND_MSG_PUB.initialize;
3252: END IF;
3253:
3254: -- Initialize API return status to success
3255: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3275: FND_MSG_PUB.ADD;

3271: OPEN cur_group_rec(p_counter_groups_rec.counter_group_id);
3272: FETCH cur_group_rec INTO l_old_counter_groups_rec;
3273: IF (l_old_counter_groups_rec.object_version_number <> nvl(p_counter_groups_rec.OBJECT_VERSION_NUMBER,0)) THEN
3274: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
3275: FND_MSG_PUB.ADD;
3276: RAISE FND_API.G_EXC_ERROR;
3277: END IF;
3278:
3279: CLOSE cur_group_rec;

Line 3503: FND_MSG_PUB.Count_And_Get

3499: COMMIT WORK;
3500: END IF;
3501:
3502: -- Standard call to get message count and IF count is get message info.
3503: FND_MSG_PUB.Count_And_Get
3504: ( p_count => x_msg_count,
3505: p_data => x_msg_data
3506: );
3507: EXCEPTION

Line 3511: FND_MSG_PUB.Count_And_Get

3507: EXCEPTION
3508: WHEN FND_API.G_EXC_ERROR THEN
3509: x_return_status := FND_API.G_RET_STS_ERROR ;
3510: ROLLBACK TO update_counter_group_pvt;
3511: FND_MSG_PUB.Count_And_Get
3512: ( p_count => x_msg_count,
3513: p_data => x_msg_data
3514: );
3515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3518: FND_MSG_PUB.Count_And_Get

3514: );
3515: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3517: ROLLBACK TO update_counter_group_pvt;
3518: FND_MSG_PUB.Count_And_Get
3519: ( p_count => x_msg_count,
3520: p_data => x_msg_data
3521: );
3522: WHEN OTHERS THEN

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

3521: );
3522: WHEN OTHERS THEN
3523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3524: ROLLBACK TO update_counter_group_pvt;
3525: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3526: FND_MSG_PUB.Add_Exc_Msg
3527: ( G_PKG_NAME,
3528: l_api_name
3529: );

Line 3526: FND_MSG_PUB.Add_Exc_Msg

3522: WHEN OTHERS THEN
3523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3524: ROLLBACK TO update_counter_group_pvt;
3525: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3526: FND_MSG_PUB.Add_Exc_Msg
3527: ( G_PKG_NAME,
3528: l_api_name
3529: );
3530: END IF;

Line 3531: FND_MSG_PUB.Count_And_Get

3527: ( G_PKG_NAME,
3528: l_api_name
3529: );
3530: END IF;
3531: FND_MSG_PUB.Count_And_Get
3532: ( p_count => x_msg_count,
3533: p_data => x_msg_data
3534: );
3535: END update_counter_group;

Line 3624: FND_MSG_PUB.initialize;

3620: END IF;
3621:
3622: -- Initialize message list if p_init_msg_list is set to TRUE.
3623: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3624: FND_MSG_PUB.initialize;
3625: END IF;
3626:
3627: -- Initialize API return status to success
3628: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3647: FND_MSG_PUB.ADD;

3643: OPEN cur_item_assoc_rec(p_ctr_item_associations_rec.ctr_association_id);
3644: FETCH cur_item_assoc_rec INTO l_old_item_associations_rec;
3645: IF (l_old_item_associations_rec.object_version_number <> nvl(p_ctr_item_associations_rec.OBJECT_VERSION_NUMBER,0)) THEN
3646: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
3647: FND_MSG_PUB.ADD;
3648: RAISE FND_API.G_EXC_ERROR;
3649: END IF;
3650:
3651: CLOSE cur_item_assoc_rec;

Line 3971: FND_MSG_PUB.Count_And_Get

3967: COMMIT WORK;
3968: END IF;
3969:
3970: -- Standard call to get message count and IF count is get message info.
3971: FND_MSG_PUB.Count_And_Get
3972: ( p_count => x_msg_count,
3973: p_data => x_msg_data
3974: );
3975: EXCEPTION

Line 3979: FND_MSG_PUB.Count_And_Get

3975: EXCEPTION
3976: WHEN FND_API.G_EXC_ERROR THEN
3977: x_return_status := FND_API.G_RET_STS_ERROR ;
3978: ROLLBACK TO update_item_association_pvt;
3979: FND_MSG_PUB.Count_And_Get
3980: ( p_count => x_msg_count,
3981: p_data => x_msg_data
3982: );
3983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3986: FND_MSG_PUB.Count_And_Get

3982: );
3983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3985: ROLLBACK TO update_item_association_pvt;
3986: FND_MSG_PUB.Count_And_Get
3987: ( p_count => x_msg_count,
3988: p_data => x_msg_data
3989: );
3990: WHEN OTHERS THEN

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

3989: );
3990: WHEN OTHERS THEN
3991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3992: ROLLBACK TO update_item_association_pvt;
3993: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3994: FND_MSG_PUB.Add_Exc_Msg
3995: ( G_PKG_NAME,
3996: l_api_name
3997: );

Line 3994: FND_MSG_PUB.Add_Exc_Msg

3990: WHEN OTHERS THEN
3991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3992: ROLLBACK TO update_item_association_pvt;
3993: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3994: FND_MSG_PUB.Add_Exc_Msg
3995: ( G_PKG_NAME,
3996: l_api_name
3997: );
3998: END IF;

Line 3999: FND_MSG_PUB.Count_And_Get

3995: ( G_PKG_NAME,
3996: l_api_name
3997: );
3998: END IF;
3999: FND_MSG_PUB.Count_And_Get
4000: ( p_count => x_msg_count,
4001: p_data => x_msg_data
4002: );
4003: END update_item_association;

Line 4149: FND_MSG_PUB.initialize;

4145: END IF;
4146:
4147: -- Initialize message list if p_init_msg_list is set to TRUE.
4148: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4149: FND_MSG_PUB.initialize;
4150: END IF;
4151:
4152: -- Initialize API return status to success
4153: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4172: FND_MSG_PUB.ADD;

4168: OPEN cur_ctr_template_rec(p_counter_template_rec.counter_id);
4169: FETCH cur_ctr_template_rec INTO l_old_counter_template_rec;
4170: IF (l_old_counter_template_rec.object_version_number <> nvl(p_counter_template_rec.OBJECT_VERSION_NUMBER,0)) THEN
4171: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
4172: FND_MSG_PUB.ADD;
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;
4175:
4176: CLOSE cur_ctr_template_rec;

Line 4782: FND_MSG_PUB.Count_And_Get

4778: COMMIT WORK;
4779: END IF;
4780:
4781: -- Standard call to get message count and IF count is get message info.
4782: FND_MSG_PUB.Count_And_Get
4783: ( p_count => x_msg_count,
4784: p_data => x_msg_data
4785: );
4786: EXCEPTION

Line 4790: FND_MSG_PUB.Count_And_Get

4786: EXCEPTION
4787: WHEN FND_API.G_EXC_ERROR THEN
4788: x_return_status := FND_API.G_RET_STS_ERROR ;
4789: ROLLBACK TO update_counter_template_pvt;
4790: FND_MSG_PUB.Count_And_Get
4791: ( p_count => x_msg_count,
4792: p_data => x_msg_data
4793: );
4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4797: FND_MSG_PUB.Count_And_Get

4793: );
4794: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4796: ROLLBACK TO update_counter_template_pvt;
4797: FND_MSG_PUB.Count_And_Get
4798: ( p_count => x_msg_count,
4799: p_data => x_msg_data
4800: );
4801: WHEN OTHERS THEN

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

4800: );
4801: WHEN OTHERS THEN
4802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4803: ROLLBACK TO update_counter_template_pvt;
4804: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4805: FND_MSG_PUB.Add_Exc_Msg
4806: ( G_PKG_NAME,
4807: l_api_name
4808: );

Line 4805: FND_MSG_PUB.Add_Exc_Msg

4801: WHEN OTHERS THEN
4802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4803: ROLLBACK TO update_counter_template_pvt;
4804: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4805: FND_MSG_PUB.Add_Exc_Msg
4806: ( G_PKG_NAME,
4807: l_api_name
4808: );
4809: END IF;

Line 4810: FND_MSG_PUB.Count_And_Get

4806: ( G_PKG_NAME,
4807: l_api_name
4808: );
4809: END IF;
4810: FND_MSG_PUB.Count_And_Get
4811: ( p_count => x_msg_count,
4812: p_data => x_msg_data
4813: );
4814: END update_counter_template;

Line 4899: FND_MSG_PUB.initialize;

4895: END IF;
4896:
4897: -- Initialize message list if p_init_msg_list is set to TRUE.
4898: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4899: FND_MSG_PUB.initialize;
4900: END IF;
4901:
4902: -- Initialize API return status to success
4903: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4922: FND_MSG_PUB.ADD;

4918: OPEN cur_ctr_prop_rec(p_ctr_property_template_rec.counter_property_id);
4919: FETCH cur_ctr_prop_rec INTO l_old_ctr_property_tmpl_rec;
4920: IF (l_old_ctr_property_tmpl_rec.object_version_number <> nvl(p_ctr_property_template_rec.OBJECT_VERSION_NUMBER,0)) THEN
4921: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
4922: FND_MSG_PUB.ADD;
4923: RAISE FND_API.G_EXC_ERROR;
4924: END IF;
4925:
4926: CLOSE cur_ctr_prop_rec;

Line 5191: FND_MSG_PUB.Count_And_Get

5187: COMMIT WORK;
5188: END IF;
5189:
5190: -- Standard call to get message count and IF count is get message info.
5191: FND_MSG_PUB.Count_And_Get
5192: ( p_count => x_msg_count,
5193: p_data => x_msg_data
5194: );
5195: EXCEPTION

Line 5199: FND_MSG_PUB.Count_And_Get

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

Line 5206: FND_MSG_PUB.Count_And_Get

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

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

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

Line 5214: FND_MSG_PUB.Add_Exc_Msg

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

Line 5219: FND_MSG_PUB.Count_And_Get

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

Line 5318: FND_MSG_PUB.initialize;

5314: END IF;
5315:
5316: -- Initialize message list if p_init_msg_list is set to TRUE.
5317: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5318: FND_MSG_PUB.initialize;
5319: END IF;
5320:
5321: -- Initialize API return status to success
5322: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5348: FND_MSG_PUB.ADD;

5344: END IF;
5345:
5346: IF (l_old_ctr_relationships_rec.object_version_number <> nvl(p_counter_relationships_rec.OBJECT_VERSION_NUMBER,0)) THEN
5347: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
5348: FND_MSG_PUB.ADD;
5349: RAISE FND_API.G_EXC_ERROR;
5350: END IF;
5351:
5352: CLOSE cur_rel_rec;

Line 5643: FND_MSG_PUB.Count_And_Get

5639: COMMIT WORK;
5640: END IF;
5641:
5642: -- Standard call to get message count and IF count is get message info.
5643: FND_MSG_PUB.Count_And_Get
5644: ( p_count => x_msg_count,
5645: p_data => x_msg_data
5646: );
5647: EXCEPTION

Line 5651: FND_MSG_PUB.Count_And_Get

5647: EXCEPTION
5648: WHEN FND_API.G_EXC_ERROR THEN
5649: x_return_status := FND_API.G_RET_STS_ERROR ;
5650: ROLLBACK TO update_ctr_relationship_pvt;
5651: FND_MSG_PUB.Count_And_Get
5652: ( p_count => x_msg_count,
5653: p_data => x_msg_data
5654: );
5655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5658: FND_MSG_PUB.Count_And_Get

5654: );
5655: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5657: ROLLBACK TO update_ctr_relationship_pvt;
5658: FND_MSG_PUB.Count_And_Get
5659: ( p_count => x_msg_count,
5660: p_data => x_msg_data
5661: );
5662: WHEN OTHERS THEN

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

5661: );
5662: WHEN OTHERS THEN
5663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5664: ROLLBACK TO update_ctr_relationship_pvt;
5665: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5666: FND_MSG_PUB.Add_Exc_Msg
5667: ( G_PKG_NAME,
5668: l_api_name
5669: );

Line 5666: FND_MSG_PUB.Add_Exc_Msg

5662: WHEN OTHERS THEN
5663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5664: ROLLBACK TO update_ctr_relationship_pvt;
5665: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5666: FND_MSG_PUB.Add_Exc_Msg
5667: ( G_PKG_NAME,
5668: l_api_name
5669: );
5670: END IF;

Line 5671: FND_MSG_PUB.Count_And_Get

5667: ( G_PKG_NAME,
5668: l_api_name
5669: );
5670: END IF;
5671: FND_MSG_PUB.Count_And_Get
5672: ( p_count => x_msg_count,
5673: p_data => x_msg_data
5674: );
5675: END update_counter_relationship;

Line 5738: FND_MSG_PUB.initialize;

5734: END IF;
5735:
5736: -- Initialize message list if p_init_msg_list is set to TRUE.
5737: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5738: FND_MSG_PUB.initialize;
5739: END IF;
5740:
5741: -- Initialize API return status to success
5742: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5788: x_msg_data := FND_MSG_PUB.GET

5784: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5785: l_msg_index := 1;
5786: l_msg_count := x_msg_count;
5787: WHILE l_msg_count > 0 LOOP
5788: x_msg_data := FND_MSG_PUB.GET
5789: (l_msg_index,
5790: FND_API.G_FALSE);
5791: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');
5792: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 6032: FND_MSG_PUB.Count_And_Get

6028: IF FND_API.To_Boolean( p_commit ) THEN
6029: COMMIT WORK;
6030: END IF;
6031:
6032: FND_MSG_PUB.Count_And_Get
6033: ( p_count => x_msg_count,
6034: p_data => x_msg_data
6035: );
6036:

Line 6041: FND_MSG_PUB.Count_And_Get

6037: EXCEPTION
6038: WHEN FND_API.G_EXC_ERROR THEN
6039: x_return_status := FND_API.G_RET_STS_ERROR ;
6040: ROLLBACK TO update_derived_filters;
6041: FND_MSG_PUB.Count_And_Get
6042: (p_count => x_msg_count,
6043: p_data => x_msg_data
6044: );
6045:

Line 6049: FND_MSG_PUB.Count_And_Get

6045:
6046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6047: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6048: ROLLBACK TO update_derived_filters;
6049: FND_MSG_PUB.Count_And_Get
6050: (p_count => x_msg_count,
6051: p_data => x_msg_data
6052: );
6053: WHEN OTHERS THEN

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

6052: );
6053: WHEN OTHERS THEN
6054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6055: ROLLBACK TO update_derived_filters;
6056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6057: THEN
6058: FND_MSG_PUB.Add_Exc_Msg
6059: (G_PKG_NAME,
6060: l_api_name

Line 6058: FND_MSG_PUB.Add_Exc_Msg

6054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6055: ROLLBACK TO update_derived_filters;
6056: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6057: THEN
6058: FND_MSG_PUB.Add_Exc_Msg
6059: (G_PKG_NAME,
6060: l_api_name
6061: );
6062: END IF;

Line 6063: FND_MSG_PUB.Count_And_Get

6059: (G_PKG_NAME,
6060: l_api_name
6061: );
6062: END IF;
6063: FND_MSG_PUB.Count_And_Get
6064: (p_count => x_msg_count,
6065: p_data => x_msg_data
6066: );
6067:

Line 6139: FND_MSG_PUB.initialize;

6135: END IF;
6136:
6137: -- Initialize message list if p_init_msg_list is set to TRUE.
6138: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
6139: FND_MSG_PUB.initialize;
6140: END IF;
6141:
6142: -- Initialize API return status to success
6143: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6399: FND_MSG_PUB.Count_And_Get

6395: COMMIT WORK;
6396: END IF;
6397:
6398: -- Standard call to get message count and IF count is get message info.
6399: FND_MSG_PUB.Count_And_Get
6400: ( p_count => x_msg_count,
6401: p_data => x_msg_data
6402: );
6403: EXCEPTION

Line 6407: FND_MSG_PUB.Count_And_Get

6403: EXCEPTION
6404: WHEN FND_API.G_EXC_ERROR THEN
6405: x_return_status := FND_API.G_RET_STS_ERROR ;
6406: ROLLBACK TO create_estimation_method_pvt;
6407: FND_MSG_PUB.Count_And_Get
6408: ( p_count => x_msg_count,
6409: p_data => x_msg_data
6410: );
6411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6414: FND_MSG_PUB.Count_And_Get

6410: );
6411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6413: ROLLBACK TO create_estimation_method_pvt;
6414: FND_MSG_PUB.Count_And_Get
6415: ( p_count => x_msg_count,
6416: p_data => x_msg_data
6417: );
6418: WHEN OTHERS THEN

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

6417: );
6418: WHEN OTHERS THEN
6419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6420: ROLLBACK TO create_estimation_method_pvt;
6421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6422: FND_MSG_PUB.Add_Exc_Msg
6423: ( G_PKG_NAME,
6424: l_api_name
6425: );

Line 6422: FND_MSG_PUB.Add_Exc_Msg

6418: WHEN OTHERS THEN
6419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6420: ROLLBACK TO create_estimation_method_pvt;
6421: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6422: FND_MSG_PUB.Add_Exc_Msg
6423: ( G_PKG_NAME,
6424: l_api_name
6425: );
6426: END IF;

Line 6427: FND_MSG_PUB.Count_And_Get

6423: ( G_PKG_NAME,
6424: l_api_name
6425: );
6426: END IF;
6427: FND_MSG_PUB.Count_And_Get
6428: ( p_count => x_msg_count,
6429: p_data => x_msg_data
6430: );
6431: END create_estimation_method;

Line 6505: FND_MSG_PUB.initialize;

6501: END IF;
6502:
6503: -- Initialize message list if p_init_msg_list is set to TRUE.
6504: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
6505: FND_MSG_PUB.initialize;
6506: END IF;
6507:
6508: -- Initialize API return status to success
6509: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6528: FND_MSG_PUB.ADD;

6524: OPEN cur_estimation_rec(p_ctr_estimation_rec.estimation_id);
6525: FETCH cur_estimation_rec INTO l_old_ctr_estimation_rec;
6526: IF (l_old_ctr_estimation_rec.object_version_number <> nvl(p_ctr_estimation_rec.OBJECT_VERSION_NUMBER,0)) THEN
6527: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
6528: FND_MSG_PUB.ADD;
6529: RAISE FND_API.G_EXC_ERROR;
6530: END IF;
6531:
6532: CLOSE cur_estimation_rec;

Line 6759: FND_MSG_PUB.Count_And_Get

6755: COMMIT WORK;
6756: END IF;
6757:
6758: -- Standard call to get message count and IF count is get message info.
6759: FND_MSG_PUB.Count_And_Get
6760: ( p_count => x_msg_count,
6761: p_data => x_msg_data
6762: );
6763: EXCEPTION

Line 6767: FND_MSG_PUB.Count_And_Get

6763: EXCEPTION
6764: WHEN FND_API.G_EXC_ERROR THEN
6765: x_return_status := FND_API.G_RET_STS_ERROR ;
6766: ROLLBACK TO update_estimation_method_pvt;
6767: FND_MSG_PUB.Count_And_Get
6768: ( p_count => x_msg_count,
6769: p_data => x_msg_data
6770: );
6771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6774: FND_MSG_PUB.Count_And_Get

6770: );
6771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6773: ROLLBACK TO update_estimation_method_pvt;
6774: FND_MSG_PUB.Count_And_Get
6775: ( p_count => x_msg_count,
6776: p_data => x_msg_data
6777: );
6778: WHEN OTHERS THEN

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

6777: );
6778: WHEN OTHERS THEN
6779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6780: ROLLBACK TO update_estimation_method_pvt;
6781: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6782: FND_MSG_PUB.Add_Exc_Msg
6783: ( G_PKG_NAME,
6784: l_api_name
6785: );

Line 6782: FND_MSG_PUB.Add_Exc_Msg

6778: WHEN OTHERS THEN
6779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6780: ROLLBACK TO update_estimation_method_pvt;
6781: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6782: FND_MSG_PUB.Add_Exc_Msg
6783: ( G_PKG_NAME,
6784: l_api_name
6785: );
6786: END IF;

Line 6787: FND_MSG_PUB.Count_And_Get

6783: ( G_PKG_NAME,
6784: l_api_name
6785: );
6786: END IF;
6787: FND_MSG_PUB.Count_And_Get
6788: ( p_count => x_msg_count,
6789: p_data => x_msg_data
6790: );
6791: END update_estimation_method;

Line 7115: FND_MSG_PUB.initialize;

7111: END IF;
7112:
7113: -- Initialize message list if p_init_msg_list is set to TRUE.
7114: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
7115: FND_MSG_PUB.initialize;
7116: END IF;
7117:
7118: -- Initialize API return status to success
7119: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 7254: x_msg_data := FND_MSG_PUB.GET

7250: l_msg_index := 1;
7251: l_msg_count := x_msg_count;
7252:
7253: WHILE l_msg_count > 0 LOOP
7254: x_msg_data := FND_MSG_PUB.GET
7255: (l_msg_index,
7256: FND_API.G_FALSE );
7257: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_COUNTER');
7258: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7294: x_msg_data := FND_MSG_PUB.GET

7290: l_msg_index := 1;
7291: l_msg_count := x_msg_count;
7292:
7293: WHILE l_msg_count > 0 LOOP
7294: x_msg_data := FND_MSG_PUB.GET
7295: (l_msg_index,
7296: FND_API.G_FALSE );
7297: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS');
7298: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7386: x_msg_data := FND_MSG_PUB.GET

7382: l_msg_index := 1;
7383: l_msg_count := x_msg_count;
7384:
7385: WHILE l_msg_count > 0 LOOP
7386: x_msg_data := FND_MSG_PUB.GET
7387: (l_msg_index,
7388: FND_API.G_FALSE );
7389: csi_ctr_gen_utility_pvt.put_line( ' Error from Instantiate-Capture Readings');
7390: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7457: x_msg_data := FND_MSG_PUB.GET

7453: l_msg_index := 1;
7454: l_msg_count := x_msg_count;
7455:
7456: WHILE l_msg_count > 0 LOOP
7457: x_msg_data := FND_MSG_PUB.GET
7458: (l_msg_index,
7459: FND_API.G_FALSE );
7460: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_Counter_PVT.Create_Ctr_Property');
7461: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7540: x_msg_data := FND_MSG_PUB.GET

7536: l_msg_index := 1;
7537: l_msg_count := x_msg_count;
7538:
7539: WHILE l_msg_count > 0 LOOP
7540: x_msg_data := FND_MSG_PUB.GET
7541: (l_msg_index,
7542: FND_API.G_FALSE );
7543: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');
7544: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 7686: FND_MSG_PUB.Count_And_Get

7682: COMMIT WORK;
7683: END IF;
7684:
7685: -- Standard call to get message count and IF count is get message info.
7686: FND_MSG_PUB.Count_And_Get
7687: ( p_count => x_msg_count,
7688: p_data => x_msg_data
7689: );
7690: EXCEPTION

Line 7694: FND_MSG_PUB.Count_And_Get

7690: EXCEPTION
7691: WHEN FND_API.G_EXC_ERROR THEN
7692: x_return_status := FND_API.G_RET_STS_ERROR ;
7693: ROLLBACK TO instantiate_ctr_pvt;
7694: FND_MSG_PUB.Count_And_Get
7695: ( p_count => x_msg_count,
7696: p_data => x_msg_data
7697: );
7698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 7701: FND_MSG_PUB.Count_And_Get

7697: );
7698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7700: ROLLBACK TO instantiate_ctr_pvt;
7701: FND_MSG_PUB.Count_And_Get
7702: ( p_count => x_msg_count,
7703: p_data => x_msg_data
7704: );
7705: WHEN OTHERS THEN

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

7704: );
7705: WHEN OTHERS THEN
7706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7707: ROLLBACK TO instantiate_ctr_pvt;
7708: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7709: FND_MSG_PUB.Add_Exc_Msg
7710: ( G_PKG_NAME,
7711: l_api_name
7712: );

Line 7709: FND_MSG_PUB.Add_Exc_Msg

7705: WHEN OTHERS THEN
7706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7707: ROLLBACK TO instantiate_ctr_pvt;
7708: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7709: FND_MSG_PUB.Add_Exc_Msg
7710: ( G_PKG_NAME,
7711: l_api_name
7712: );
7713: END IF;

Line 7714: FND_MSG_PUB.Count_And_Get

7710: ( G_PKG_NAME,
7711: l_api_name
7712: );
7713: END IF;
7714: FND_MSG_PUB.Count_And_Get
7715: ( p_count => x_msg_count,
7716: p_data => x_msg_data
7717: );
7718: END Instantiate_Counters;

Line 8027: FND_MSG_PUB.initialize;

8023: END IF;
8024:
8025: -- Initialize message list if p_init_msg_list is set to TRUE.
8026: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
8027: FND_MSG_PUB.initialize;
8028: END IF;
8029:
8030: -- Initialize API return status to success
8031: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8119: x_msg_data := FND_MSG_PUB.GET

8115: l_msg_index := 1;
8116: l_msg_count := x_msg_count;
8117:
8118: WHILE l_msg_count > 0 LOOP
8119: x_msg_data := FND_MSG_PUB.GET
8120: (l_msg_index,
8121: FND_API.G_FALSE );
8122: csi_ctr_gen_utility_pvt.put_line('Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_COUNTER_GROUP');
8123: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8247: x_msg_data := FND_MSG_PUB.GET

8243: l_msg_index := 1;
8244: l_msg_count := x_msg_count;
8245:
8246: WHILE l_msg_count > 0 LOOP
8247: x_msg_data := FND_MSG_PUB.GET
8248: (l_msg_index,
8249: FND_API.G_FALSE );
8250: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_COUNTER');
8251: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8285: x_msg_data := FND_MSG_PUB.GET

8281: l_msg_index := 1;
8282: l_msg_count := x_msg_count;
8283:
8284: WHILE l_msg_count > 0 LOOP
8285: x_msg_data := FND_MSG_PUB.GET
8286: (l_msg_index,
8287: FND_API.G_FALSE );
8288: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_PVT.CREATE_CTR_ASSOCIATIONS');
8289: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8355: x_msg_data := FND_MSG_PUB.GET

8351: l_msg_index := 1;
8352: l_msg_count := x_msg_count;
8353:
8354: WHILE l_msg_count > 0 LOOP
8355: x_msg_data := FND_MSG_PUB.GET
8356: (l_msg_index,
8357: FND_API.G_FALSE );
8358: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_Counter_PVT.Create_Ctr_Property');
8359: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8405: x_msg_data := FND_MSG_PUB.GET

8401: l_msg_index := 1;
8402: l_msg_count := x_msg_count;
8403:
8404: WHILE l_msg_count > 0 LOOP
8405: x_msg_data := FND_MSG_PUB.GET
8406: (l_msg_index,
8407: FND_API.G_FALSE );
8408: csi_ctr_gen_utility_pvt.put_line( ' Error from CSI_COUNTER_TEMPLATE_PVT.CREATE_DERIVED_FILTERS');
8409: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

Line 8559: FND_MSG_PUB.Count_And_Get

8555: COMMIT WORK;
8556: END IF;
8557:
8558: -- Standard call to get message count and IF count is get message info.
8559: FND_MSG_PUB.Count_And_Get
8560: ( p_count => x_msg_count,
8561: p_data => x_msg_data
8562: );
8563: EXCEPTION

Line 8567: FND_MSG_PUB.Count_And_Get

8563: EXCEPTION
8564: WHEN FND_API.G_EXC_ERROR THEN
8565: x_return_status := FND_API.G_RET_STS_ERROR ;
8566: ROLLBACK TO instantiate_grp_counters;
8567: FND_MSG_PUB.Count_And_Get
8568: ( p_count => x_msg_count,
8569: p_data => x_msg_data
8570: );
8571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8574: FND_MSG_PUB.Count_And_Get

8570: );
8571: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8573: ROLLBACK TO instantiate_grp_counters;
8574: FND_MSG_PUB.Count_And_Get
8575: ( p_count => x_msg_count,
8576: p_data => x_msg_data
8577: );
8578: WHEN OTHERS THEN

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

8577: );
8578: WHEN OTHERS THEN
8579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8580: ROLLBACK TO instantiate_grp_counters;
8581: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8582: FND_MSG_PUB.Add_Exc_Msg
8583: ( G_PKG_NAME,
8584: l_api_name
8585: );

Line 8582: FND_MSG_PUB.Add_Exc_Msg

8578: WHEN OTHERS THEN
8579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8580: ROLLBACK TO instantiate_grp_counters;
8581: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8582: FND_MSG_PUB.Add_Exc_Msg
8583: ( G_PKG_NAME,
8584: l_api_name
8585: );
8586: END IF;

Line 8587: FND_MSG_PUB.Count_And_Get

8583: ( G_PKG_NAME,
8584: l_api_name
8585: );
8586: END IF;
8587: FND_MSG_PUB.Count_And_Get
8588: ( p_count => x_msg_count,
8589: p_data => x_msg_data
8590: );
8591: END Instantiate_Grp_Counters;

Line 8650: FND_MSG_PUB.initialize;

8646: END IF;
8647:
8648: -- Initialize message list if p_init_msg_list is set to TRUE.
8649: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
8650: FND_MSG_PUB.initialize;
8651: END IF;
8652:
8653: -- Initialize API return status to success
8654: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 8762: FND_MSG_PUB.Count_And_Get

8758: COMMIT WORK;
8759: END IF;
8760:
8761: -- Standard call to get message count and IF count is get message info.
8762: FND_MSG_PUB.Count_And_Get
8763: ( p_count => x_msg_count,
8764: p_data => x_msg_data
8765: );
8766: EXCEPTION

Line 8770: FND_MSG_PUB.Count_And_Get

8766: EXCEPTION
8767: WHEN FND_API.G_EXC_ERROR THEN
8768: x_return_status := FND_API.G_RET_STS_ERROR ;
8769: ROLLBACK TO delete_item_association_pvt;
8770: FND_MSG_PUB.Count_And_Get
8771: ( p_count => x_msg_count,
8772: p_data => x_msg_data
8773: );
8774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8777: FND_MSG_PUB.Count_And_Get

8773: );
8774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8776: ROLLBACK TO delete_item_association_pvt;
8777: FND_MSG_PUB.Count_And_Get
8778: ( p_count => x_msg_count,
8779: p_data => x_msg_data
8780: );
8781: WHEN OTHERS THEN

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

8780: );
8781: WHEN OTHERS THEN
8782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8783: ROLLBACK TO create_item_association_pvt;
8784: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8785: FND_MSG_PUB.Add_Exc_Msg
8786: ( G_PKG_NAME,
8787: l_api_name
8788: );

Line 8785: FND_MSG_PUB.Add_Exc_Msg

8781: WHEN OTHERS THEN
8782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
8783: ROLLBACK TO create_item_association_pvt;
8784: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8785: FND_MSG_PUB.Add_Exc_Msg
8786: ( G_PKG_NAME,
8787: l_api_name
8788: );
8789: END IF;

Line 8790: FND_MSG_PUB.Count_And_Get

8786: ( G_PKG_NAME,
8787: l_api_name
8788: );
8789: END IF;
8790: FND_MSG_PUB.Count_And_Get
8791: ( p_count => x_msg_count,
8792: p_data => x_msg_data
8793: );
8794: END delete_item_association;