APPS.CSP_PART_SEARCH_PVT dependencies on FND_API

Line 4: l_return_status varchar2(30) := FND_API.G_RET_STS_SUCCESS;

1: package body csp_part_search_pvt as
2: /*$Header: cspvsrcb.pls 120.48.12020000.7 2013/03/15 06:38:53 htank ship $*/
3:
4: l_return_status varchar2(30) := FND_API.G_RET_STS_SUCCESS;
5: l_msg_data varchar2(2000);
6: l_msg_count number;
7:
8: procedure log(p_procedure in varchar2,p_message in varchar2) as

Line 1148: p_init_msg_list => fnd_api.g_false,

1144: close c_address;
1145: log('get_my_location','calling resolve_address');
1146: csf_resource_address_pvt.resolve_address (
1147: p_api_version => 1.0,
1148: p_init_msg_list => fnd_api.g_false,
1149: p_country => nvl (l_array(cpt).country, '_'),
1150: p_state => nvl (l_array(cpt).state,'_'),
1151: p_city => nvl (l_array(cpt).city, '_'),
1152: p_county => nvl (l_array(cpt).county,'_'),

Line 1202: l_return_status := fnd_api.g_ret_sts_success;

1198: log('get_my_location','l_distance_uom:'||l_distance_uom);
1199: log('get_my_location','l_return_status:'||l_return_status);
1200:
1201: --ignore errors from geo-coding process
1202: l_return_status := fnd_api.g_ret_sts_success;
1203: FND_MSG_PUB.initialize;
1204: log('get_my_location','End');
1205: exception
1206: when others then

Line 1210: l_return_status := fnd_api.g_ret_sts_success;

1206: when others then
1207: log('get_my_location','when others exception');
1208: log('get_my_location','sqlcode:'||sqlcode);
1209: log('get_my_location','sqlerrm:'||sqlerrm);
1210: l_return_status := fnd_api.g_ret_sts_success;
1211: FND_MSG_PUB.initialize;
1212: end;
1213:
1214: function get_organization_id return number as

Line 1234: l_subinventory_code := fnd_api.g_miss_char;

1230: log('get_organization_id','l_subinventory_code:'||l_subinventory_code);
1231: else
1232: log('get_organization_id','p_search_params.resource_id is null');
1233: l_organization_id := fnd_profile.value('CS_INV_VALIDATION_ORG');
1234: l_subinventory_code := fnd_api.g_miss_char;
1235: l_called_from_charges := 'Y';
1236: end if;
1237: log('get_organization_id','l_organization_id:'||l_organization_id);
1238: log('get_organization_id','End');

Line 1732: , p_init_msg_lst => fnd_api.g_false

1728: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');
1729: if not l_b_revision then
1730: inv_quantity_tree_pub.query_quantities(
1731: p_api_version_number => l_api_version
1732: , p_init_msg_lst => fnd_api.g_false
1733: , x_return_status => l_return_status
1734: , x_msg_count => l_msg_count
1735: , x_msg_data => l_msg_data
1736: , p_organization_id => p_organization_id

Line 1763: , p_init_msg_lst => fnd_api.g_false

1759: for crr in c_revisions loop
1760: log('get_avail_qty','crr.revision'||crr.revision);
1761: inv_quantity_tree_pub.query_quantities(
1762: p_api_version_number => l_api_version
1763: , p_init_msg_lst => fnd_api.g_false
1764: , x_return_status => l_return_status
1765: , x_msg_count => l_msg_count
1766: , x_msg_data => l_msg_data
1767: , p_organization_id => p_organization_id

Line 1808: , p_init_msg_lst => fnd_api.g_false

1804: log('get_avail_qty','in c_defective_sub loop');
1805: log('get_avail_qty','calling inv_quantity_tree_pub.query_quantities');
1806: inv_quantity_tree_pub.query_quantities(
1807: p_api_version_number => l_api_version
1808: , p_init_msg_lst => fnd_api.g_false
1809: , x_return_status => l_return_status
1810: , x_msg_count => l_msg_count
1811: , x_msg_data => l_msg_data
1812: , p_organization_id => p_organization_id

Line 2066: if l_ship_to_tz = -9999 or l_ship_to_tz = fnd_api.g_miss_num then

2062: end if;
2063:
2064: log('get_ship_to_tz', 'l_ship_to_tz:' || l_ship_to_tz);
2065:
2066: if l_ship_to_tz = -9999 or l_ship_to_tz = fnd_api.g_miss_num then
2067: hz_timezone_pub.get_timezone_id (
2068: p_api_version => 1.0,
2069: p_init_msg_list => fnd_api.g_false,
2070: p_postal_code => l_postal_code,

Line 2069: p_init_msg_list => fnd_api.g_false,

2065:
2066: if l_ship_to_tz = -9999 or l_ship_to_tz = fnd_api.g_miss_num then
2067: hz_timezone_pub.get_timezone_id (
2068: p_api_version => 1.0,
2069: p_init_msg_list => fnd_api.g_false,
2070: p_postal_code => l_postal_code,
2071: p_city => l_city,
2072: p_state => l_state,
2073: p_country => l_country,