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

APPS.OZF_VOLUME_CALCULATION_PUB dependencies on FND_API

Line 63: l_precedence NUMBER := fnd_api.g_miss_num;

59: WHERE order_line_id = l_order_line_id
60: AND indirect_flag = p_indirect_flag
61: AND offer_id = p_offer_id;
62:
63: l_precedence NUMBER := fnd_api.g_miss_num;
64: l_dummy1 NUMBER;
65: l_dummy2 NUMBER;
66: l_offer_market_option_id NUMBER;
67: l_vol_track_type VARCHAR2(30);

Line 235: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;

231: l_api_name CONSTANT VARCHAR2(30) := 'insert_volume';
232: l_currency_code VARCHAR2(15);
233: l_convert_amt NUMBER;
234: l_return_status VARCHAR2(1);
235: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
236: l_rate NUMBER;
237: BEGIN
238: SAVEPOINT create_volume;
239: x_return_status := Fnd_Api.g_ret_sts_success;

Line 239: x_return_status := Fnd_Api.g_ret_sts_success;

235: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;
236: l_rate NUMBER;
237: BEGIN
238: SAVEPOINT create_volume;
239: x_return_status := Fnd_Api.g_ret_sts_success;
240: ozf_utility_pvt.write_conc_log('========================= Insert Volume =========================');
241: ozf_utility_pvt.write_conc_log('offer_id: ' || p_offer_id);
242:
243: IF p_offer_id IS NOT NULL THEN

Line 358: IF l_return_status <> fnd_api.g_ret_sts_success THEN

354: ,p_from_amount => p_volume_detail_rec.amount
355: ,x_to_amount => l_convert_amt
356: ,x_rate => l_rate); --7030415
357:
358: IF l_return_status <> fnd_api.g_ret_sts_success THEN
359: ozf_utility_pvt.write_conc_log('Convert Currency failed');
360: RAISE Fnd_Api.g_exc_unexpected_error;
361: END IF;
362:

Line 360: RAISE Fnd_Api.g_exc_unexpected_error;

356: ,x_rate => l_rate); --7030415
357:
358: IF l_return_status <> fnd_api.g_ret_sts_success THEN
359: ozf_utility_pvt.write_conc_log('Convert Currency failed');
360: RAISE Fnd_Api.g_exc_unexpected_error;
361: END IF;
362:
363: IF p_volume_detail_rec.source_code = 'OM' THEN
364: l_current_volume := l_convert_amt; -- for OM return order, amount is already negative

Line 527: --IF p_volume_detail_rec.sold_from_cust_account_id IS NOT NULL AND p_volume_detail_rec.sold_from_cust_account_id <> fnd_api.g_miss_num THEN

523: END IF; -- end l_volume_exists
524: END IF; -- end l_volume_track_type = 'GROUP'
525:
526: -- 2. distributor's volume
527: --IF p_volume_detail_rec.sold_from_cust_account_id IS NOT NULL AND p_volume_detail_rec.sold_from_cust_account_id <> fnd_api.g_miss_num THEN
528: IF p_indirect_flag = 'R' THEN -- indirect sales
529: l_volume_exists := 'N';
530: OPEN c_individual_volume_exists(p_offer_id, 'DISTRIBUTOR', p_volume_detail_rec.sold_from_cust_account_id, l_pbh_line_id);
531: FETCH c_individual_volume_exists INTO l_volume_exists;

Line 730: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

726: END IF; -- end offer_id is null
727:
728: EXCEPTION
729: WHEN OTHERS THEN
730: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
731: ROLLBACK TO insert_volume;
732: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
733: THEN
734: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 739: p_encoded => Fnd_Api.G_FALSE

735: END IF;
736: Fnd_Msg_Pub.Count_AND_Get
737: ( p_count => x_msg_count,
738: p_data => x_msg_data,
739: p_encoded => Fnd_Api.G_FALSE
740: );
741: END insert_volume;
742:
743:

Line 800: x_return_status := Fnd_Api.g_ret_sts_success;

796: l_api_name CONSTANT VARCHAR2(30) := 'create_volume';
797:
798: BEGIN
799: SAVEPOINT create_volume;
800: x_return_status := Fnd_Api.g_ret_sts_success;
801: ozf_utility_pvt.write_conc_log('========================= Create Volume =========================');
802: ozf_utility_pvt.write_conc_log('enter creat_volume : ' || p_volume_detail_rec.line_id);
803: ozf_utility_pvt.write_conc_log('source_code ' || p_volume_detail_rec.source_code);
804: ozf_utility_pvt.write_conc_log('transfer_type ' || p_volume_detail_rec.transfer_type);

Line 822: IF p_qp_list_header_id IS NULL OR p_qp_list_header_id = fnd_api.g_miss_num THEN

818: ELSIF p_volume_detail_rec.transfer_type = 'OUT' THEN
819: l_sign := -1;
820: END IF;
821:
822: IF p_qp_list_header_id IS NULL OR p_qp_list_header_id = fnd_api.g_miss_num THEN
823: FOR l_offer_id_om IN c_offer_id_om(p_volume_detail_rec.line_id, l_object_type) loop
824: ozf_utility_pvt.write_conc_log('OM offer_id 1: ' || l_offer_id_om.offer_id);
825: insert_volume(
826: p_init_msg_list => p_init_msg_list

Line 867: IF p_qp_list_header_id IS NULL OR p_qp_list_header_id = fnd_api.g_miss_num THEN

863: ELSIF p_volume_detail_rec.transfer_type = 'OUT' THEN
864: l_sign := 1;
865: END IF;
866:
867: IF p_qp_list_header_id IS NULL OR p_qp_list_header_id = fnd_api.g_miss_num THEN
868: FOR l_offer_id_is IN c_offer_id_is(p_volume_detail_rec.line_id, l_object_type) LOOP
869: ozf_utility_pvt.write_conc_log('IS offer_id 1: ' || l_offer_id_is.offer_id);
870: insert_volume(
871: p_init_msg_list => p_init_msg_list

Line 907: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

903: ozf_utility_pvt.write_conc_log('indirect_flag ' || l_indirect_flag);
904:
905: EXCEPTION
906: WHEN OTHERS THEN
907: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
908: ROLLBACK TO create_volume;
909: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
910: THEN
911: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 916: p_encoded => Fnd_Api.G_FALSE

912: END IF;
913: Fnd_Msg_Pub.Count_AND_Get
914: ( p_count => x_msg_count,
915: p_data => x_msg_data,
916: p_encoded => Fnd_Api.G_FALSE
917: );
918: END create_volume;
919:
920:

Line 1412: x_return_status := Fnd_Api.g_ret_sts_success;

1408: l_trx_date DATE;
1409: l_api_name CONSTANT VARCHAR2(30) := 'get_volume_2';
1410: BEGIN
1411: SAVEPOINT get_volume_2;
1412: x_return_status := Fnd_Api.g_ret_sts_success;
1413:
1414: OPEN c_volume_detail;
1415: FETCH c_volume_detail INTO l_cust_account_id, l_bill_to, l_ship_to;
1416: CLOSE c_volume_detail;

Line 1493: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

1489: END IF;
1490:
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1494: ROLLBACK TO get_volume_2;
1495: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1496: THEN
1497: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1502: p_encoded => Fnd_Api.G_FALSE

1498: END IF;
1499: Fnd_Msg_Pub.Count_AND_Get
1500: ( p_count => x_msg_count,
1501: p_data => x_msg_data,
1502: p_encoded => Fnd_Api.G_FALSE
1503: );
1504: END get_volume;
1505:
1506:

Line 1936: x_return_status := Fnd_Api.g_ret_sts_success;

1932: l_api_name CONSTANT VARCHAR2(30) := 'update_tracking_line';
1933: BEGIN
1934: SAVEPOINT update_tracking_line;
1935:
1936: x_return_status := Fnd_Api.g_ret_sts_success;
1937:
1938: UPDATE ozf_order_group_prod
1939: SET order_line_id = p_resale_line_id,
1940: indirect_flag = 'R'

Line 1947: x_return_status := Fnd_Api.g_ret_sts_unexp_error;

1943: AND indirect_flag = 'I';
1944:
1945: EXCEPTION
1946: WHEN OTHERS THEN
1947: x_return_status := Fnd_Api.g_ret_sts_unexp_error;
1948: ROLLBACK TO update_tracking_line;
1949: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1950: THEN
1951: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 1956: p_encoded => Fnd_Api.G_FALSE

1952: END IF;
1953: Fnd_Msg_Pub.Count_AND_Get
1954: ( p_count => x_msg_count,
1955: p_data => x_msg_data,
1956: p_encoded => Fnd_Api.G_FALSE
1957: );
1958: END update_tracking_line;
1959:
1960: