155:
156: EXCEPTION
157: WHEN OTHERS THEN
158: ROLLBACK TO get_group_pbh_prod;
159: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
160: THEN
161: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
162: END IF;
163:
157: WHEN OTHERS THEN
158: ROLLBACK TO get_group_pbh_prod;
159: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
160: THEN
161: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
162: END IF;
163:
164: END get_group_pbh_prod;
165:
1025: EXCEPTION
1026: WHEN OTHERS THEN
1027: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1028: ROLLBACK TO insert_volume;
1029: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1030: THEN
1031: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1032: END IF;
1033: Fnd_Msg_Pub.Count_AND_Get
1027: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1028: ROLLBACK TO insert_volume;
1029: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1030: THEN
1031: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1032: END IF;
1033: Fnd_Msg_Pub.Count_AND_Get
1034: ( p_count => x_msg_count,
1035: p_data => x_msg_data,
1029: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1030: THEN
1031: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1032: END IF;
1033: Fnd_Msg_Pub.Count_AND_Get
1034: ( p_count => x_msg_count,
1035: p_data => x_msg_data,
1036: p_encoded => Fnd_Api.G_FALSE
1037: );
1335: EXCEPTION
1336: WHEN OTHERS THEN
1337: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1338: ROLLBACK TO create_volume;
1339: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1340: THEN
1341: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1342: END IF;
1343: Fnd_Msg_Pub.Count_AND_Get
1337: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1338: ROLLBACK TO create_volume;
1339: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1340: THEN
1341: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1342: END IF;
1343: Fnd_Msg_Pub.Count_AND_Get
1344: ( p_count => x_msg_count,
1345: p_data => x_msg_data,
1339: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1340: THEN
1341: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1342: END IF;
1343: Fnd_Msg_Pub.Count_AND_Get
1344: ( p_count => x_msg_count,
1345: p_data => x_msg_data,
1346: p_encoded => Fnd_Api.G_FALSE
1347: );
1772:
1773: EXCEPTION
1774: WHEN OTHERS THEN
1775: ROLLBACK TO get_volume;
1776: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1777: THEN
1778: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1779: END IF;
1780: END get_volume;
1774: WHEN OTHERS THEN
1775: ROLLBACK TO get_volume;
1776: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1777: THEN
1778: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1779: END IF;
1780: END get_volume;
1781:
1782:
1921: EXCEPTION
1922: WHEN OTHERS THEN
1923: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1924: ROLLBACK TO get_volume_2;
1925: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1926: THEN
1927: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1928: END IF;
1929: Fnd_Msg_Pub.Count_AND_Get
1923: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1924: ROLLBACK TO get_volume_2;
1925: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1926: THEN
1927: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1928: END IF;
1929: Fnd_Msg_Pub.Count_AND_Get
1930: ( p_count => x_msg_count,
1931: p_data => x_msg_data,
1925: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1926: THEN
1927: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1928: END IF;
1929: Fnd_Msg_Pub.Count_AND_Get
1930: ( p_count => x_msg_count,
1931: p_data => x_msg_data,
1932: p_encoded => Fnd_Api.G_FALSE
1933: );
2298:
2299: EXCEPTION
2300: WHEN OTHERS THEN
2301: ROLLBACK TO get_numeric_attribute_value;
2302: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2303: THEN
2304: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2305: END IF;
2306: END get_numeric_attribute_value;
2300: WHEN OTHERS THEN
2301: ROLLBACK TO get_numeric_attribute_value;
2302: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2303: THEN
2304: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2305: END IF;
2306: END get_numeric_attribute_value;
2307:
2308:
2398: EXCEPTION
2399: WHEN OTHERS THEN
2400: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2401: ROLLBACK TO update_tracking_line;
2402: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2403: THEN
2404: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2405: END IF;
2406: Fnd_Msg_Pub.Count_AND_Get
2400: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
2401: ROLLBACK TO update_tracking_line;
2402: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2403: THEN
2404: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2405: END IF;
2406: Fnd_Msg_Pub.Count_AND_Get
2407: ( p_count => x_msg_count,
2408: p_data => x_msg_data,
2402: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
2403: THEN
2404: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2405: END IF;
2406: Fnd_Msg_Pub.Count_AND_Get
2407: ( p_count => x_msg_count,
2408: p_data => x_msg_data,
2409: p_encoded => Fnd_Api.G_FALSE
2410: );
2703: RETURN l_volume;
2704: EXCEPTION
2705: WHEN OTHERS THEN
2706: ROLLBACK TO copy_order_group_details;
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( G_PKG_NAME,l_api_name);
2710: END IF;
2711: END copy_order_group_details;
2705: WHEN OTHERS THEN
2706: ROLLBACK TO copy_order_group_details;
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( G_PKG_NAME,l_api_name);
2710: END IF;
2711: END copy_order_group_details;
2712:
2713: END OZF_VOLUME_CALCULATION_PUB;