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.AHL_LTP_MTL_REQ_PVT dependencies on FND_API

Line 145: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

141: -- Parameters :
142: --
143: -- Standard IN Parameters :
144: -- p_api_version IN NUMBER Required
145: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
146: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
147: --
148: -- Standard OUT Parameters :
149: -- x_return_status OUT VARCHAR2 Required

Line 146: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

142: --
143: -- Standard IN Parameters :
144: -- p_api_version IN NUMBER Required
145: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
146: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
147: --
148: -- Standard OUT Parameters :
149: -- x_return_status OUT VARCHAR2 Required
150: -- x_msg_count OUT NUMBER Required

Line 178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

174:
175: PROCEDURE Get_Route_Mtl_Req
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,

Line 179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

175: PROCEDURE Get_Route_Mtl_Req
176: (
177: p_api_version IN NUMBER,
178: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
179: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_route_id IN NUMBER,

Line 245: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

241: ', p_request_type = ' || p_request_type);
242: END IF;
243:
244: -- Standard call to check for call compatibility
245: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: END IF;
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242: END IF;
243:
244: -- Standard call to check for call compatibility
245: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: END IF;
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE
250: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 250: IF FND_API.To_Boolean(p_init_msg_list) THEN

246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: END IF;
248:
249: -- Initialize message list if p_init_msg_list is set to TRUE
250: IF FND_API.To_Boolean(p_init_msg_list) THEN
251: FND_MSG_PUB.Initialize;
252: END IF;
253:
254: -- Initialize API return status to success

Line 255: x_return_status := FND_API.G_RET_STS_SUCCESS;

251: FND_MSG_PUB.Initialize;
252: END IF;
253:
254: -- Initialize API return status to success
255: x_return_status := FND_API.G_RET_STS_SUCCESS;
256:
257: -- Begin Processing
258: -- First Validate the input parameters
259: Validate_Mtl_Req_Input(p_route_id => p_route_id,

Line 269: RAISE FND_API.G_EXC_ERROR;

265: x_route_id => l_route_id);
266:
267: IF (FND_MSG_PUB.Count_Msg > 0) THEN
268: -- There are validation errors: Raise error
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: -- Get the Unit Instance
273: l_unit_instance_id := Get_Unit_Instance(p_item_instance_id);

Line 378: p_encoded => fnd_api.g_false

374: -- Standard call to get message count and if count is 1, get message info
375: FND_MSG_PUB.Count_And_Get
376: ( p_count => x_msg_count,
377: p_data => x_msg_data,
378: p_encoded => fnd_api.g_false
379: );
380:
381: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
382: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');

Line 386: WHEN FND_API.G_EXC_ERROR THEN

382: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
383: END IF;
384:
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
389: p_data => x_msg_data,
390: p_encoded => fnd_api.g_false);

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: END IF;
384:
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
389: p_data => x_msg_data,
390: p_encoded => fnd_api.g_false);
391:

Line 390: p_encoded => fnd_api.g_false);

386: WHEN FND_API.G_EXC_ERROR THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
389: p_data => x_msg_data,
390: p_encoded => fnd_api.g_false);
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

388: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
389: p_data => x_msg_data,
390: p_encoded => fnd_api.g_false);
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
395: p_data => x_msg_data,
396: p_encoded => fnd_api.g_false);

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: p_data => x_msg_data,
390: p_encoded => fnd_api.g_false);
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
395: p_data => x_msg_data,
396: p_encoded => fnd_api.g_false);
397:

Line 396: p_encoded => fnd_api.g_false);

392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
395: p_data => x_msg_data,
396: p_encoded => fnd_api.g_false);
397:
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: p_data => x_msg_data,
396: p_encoded => fnd_api.g_false);
397:
398: WHEN OTHERS THEN
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
401: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
402: p_procedure_name => 'Get_Route_Mtl_Req',
403: p_error_text => SUBSTR(SQLERRM,1,240));

Line 407: p_encoded => fnd_api.g_false);

403: p_error_text => SUBSTR(SQLERRM,1,240));
404: END IF;
405: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
406: p_data => x_msg_data,
407: p_encoded => fnd_api.g_false);
408:
409: END Get_Route_Mtl_Req;
410:
411: --------------------------------------

Line 964: IF (l_valid_flag = FND_API.G_FALSE) THEN

960: ', x_item_group_id = ' || l_pos_item_group_id ||
961: ', x_pos_instance_id = ' || l_pos_instance_id);
962: END IF;
963:
964: IF (l_valid_flag = FND_API.G_FALSE) THEN
965: -- Don't include the requirement if the position path is not valid
966: RETURN;
967: END IF;
968:

Line 1767: p_init_msg_list => FND_API.G_FALSE,

1763: ' p_csi_item_instance_id = ' || p_unit_instance_id);
1764: END IF;
1765:
1766: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance(p_api_version => 1.0,
1767: p_init_msg_list => FND_API.G_FALSE,
1768: p_commit => FND_API.G_FALSE,
1769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1770: x_return_status => l_return_status,
1771: x_msg_count => l_msg_count,

Line 1768: p_commit => FND_API.G_FALSE,

1764: END IF;
1765:
1766: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance(p_api_version => 1.0,
1767: p_init_msg_list => FND_API.G_FALSE,
1768: p_commit => FND_API.G_FALSE,
1769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1770: x_return_status => l_return_status,
1771: x_msg_count => l_msg_count,
1772: x_msg_data => l_msg_data,

Line 1769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1765:
1766: AHL_MC_PATH_POSITION_PVT.Get_Pos_Instance(p_api_version => 1.0,
1767: p_init_msg_list => FND_API.G_FALSE,
1768: p_commit => FND_API.G_FALSE,
1769: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1770: x_return_status => l_return_status,
1771: x_msg_count => l_msg_count,
1772: x_msg_data => l_msg_data,
1773: p_position_id => p_path_position_id,

Line 1787: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1783: ', x_item_instance_id = ' || l_installed_inst_id ||
1784: ', x_lowest_uc_csi_id = ' || l_lowest_unit_inst_id);
1785: END IF;
1786:
1787: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1789: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1790: RAISE FND_API.G_EXC_ERROR;
1791: END IF;

Line 1788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1784: ', x_lowest_uc_csi_id = ' || l_lowest_unit_inst_id);
1785: END IF;
1786:
1787: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1789: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1790: RAISE FND_API.G_EXC_ERROR;
1791: END IF;
1792:

Line 1789: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1785: END IF;
1786:
1787: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1789: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1790: RAISE FND_API.G_EXC_ERROR;
1791: END IF;
1792:
1793: IF(l_mapping_status = G_MAPPING_STATUS_NA) THEN

Line 1790: RAISE FND_API.G_EXC_ERROR;

1786:
1787: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1789: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1790: RAISE FND_API.G_EXC_ERROR;
1791: END IF;
1792:
1793: IF(l_mapping_status = G_MAPPING_STATUS_NA) THEN
1794: -- Position does not apply to current unit

Line 1795: x_valid_flag := FND_API.G_FALSE;

1791: END IF;
1792:
1793: IF(l_mapping_status = G_MAPPING_STATUS_NA) THEN
1794: -- Position does not apply to current unit
1795: x_valid_flag := FND_API.G_FALSE;
1796: RETURN;
1797: END IF;
1798:
1799: OPEN get_pos_path_dtls_csr;

Line 1822: x_valid_flag := FND_API.G_FALSE;

1818: position_dates_rec.ACTIVE_START_DATE > l_requirement_date) OR
1819: (position_dates_rec.ACTIVE_END_DATE IS NOT NULL AND
1820: position_dates_rec.ACTIVE_END_DATE <= l_requirement_date)) THEN
1821: -- Position is not valid on the requirement date
1822: x_valid_flag := FND_API.G_FALSE;
1823: RETURN;
1824: END IF;
1825: END LOOP;
1826: l_last_instance_id := l_lowest_unit_inst_id;

Line 1841: x_valid_flag := FND_API.G_FALSE;

1837: position_rec.ACTIVE_START_DATE > l_requirement_date) OR
1838: (position_rec.ACTIVE_END_DATE IS NOT NULL AND
1839: position_rec.ACTIVE_END_DATE <= l_requirement_date)) THEN
1840: -- Position is not valid on the requirement date
1841: x_valid_flag := FND_API.G_FALSE;
1842: RETURN;
1843: END IF;
1844: END LOOP;
1845: END IF;

Line 1848: x_valid_flag := FND_API.G_TRUE;

1844: END LOOP;
1845: END IF;
1846:
1847: -- The Position hierarchy is valid on the requirement Date
1848: x_valid_flag := FND_API.G_TRUE;
1849:
1850: -- Information available: l_position_key, l_lowest_mc_header_id, l_mapping_status, l_installed_inst_id
1851: -- Get the relationship id and the item group id for the position
1852: OPEN get_position_dtls_csr(c_pos_key => l_position_key,

Line 1959: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

1955: -- Parameters :
1956: --
1957: -- Standard IN Parameters :
1958: -- p_api_version IN NUMBER Required
1959: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1960: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1961: --
1962: -- Standard OUT Parameters :
1963: -- x_return_status OUT VARCHAR2 Required

Line 1960: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

1956: --
1957: -- Standard IN Parameters :
1958: -- p_api_version IN NUMBER Required
1959: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
1960: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
1961: --
1962: -- Standard OUT Parameters :
1963: -- x_return_status OUT VARCHAR2 Required
1964: -- x_msg_count OUT NUMBER Required

Line 1991: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1987: -- End of Comments.
1988:
1989: PROCEDURE Get_Material_Req_For_Pos (
1990: p_api_version IN NUMBER,
1991: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1993: x_return_status OUT NOCOPY VARCHAR2,
1994: x_msg_count OUT NOCOPY NUMBER,
1995: x_msg_data OUT NOCOPY VARCHAR2,

Line 1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1988:
1989: PROCEDURE Get_Material_Req_For_Pos (
1990: p_api_version IN NUMBER,
1991: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1992: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1993: x_return_status OUT NOCOPY VARCHAR2,
1994: x_msg_count OUT NOCOPY NUMBER,
1995: x_msg_data OUT NOCOPY VARCHAR2,
1996: p_uc_header_id IN NUMBER,

Line 2150: x_return_status := FND_API.G_RET_STS_SUCCESS;

2146:
2147: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Get_Material_Req_For_Pos';
2148: BEGIN
2149: --Initialize API return status to success
2150: x_return_status := FND_API.G_RET_STS_SUCCESS;
2151:
2152: --Standard Start of API savepoint
2153: SAVEPOINT get_material_req_for_pos;
2154:

Line 2156: IF NOT FND_API.compatible_api_call(

2152: --Standard Start of API savepoint
2153: SAVEPOINT get_material_req_for_pos;
2154:
2155: --Standard call to check for call compatibility.
2156: IF NOT FND_API.compatible_api_call(
2157: l_api_version,
2158: p_api_version,
2159: l_api_name,
2160: G_PKG_NAME)

Line 2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2158: p_api_version,
2159: l_api_name,
2160: G_PKG_NAME)
2161: THEN
2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: END IF;
2164:
2165: --Initialize message list if p_init_msg_list is set to TRUE.
2166: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 2166: IF FND_API.to_boolean( p_init_msg_list ) THEN

2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: END IF;
2164:
2165: --Initialize message list if p_init_msg_list is set to TRUE.
2166: IF FND_API.to_boolean( p_init_msg_list ) THEN
2167: FND_MSG_PUB.initialize;
2168: END IF;
2169:
2170: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2300: RAISE FND_API.G_EXC_ERROR;

2296: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2297: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
2298: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2299: FND_MSG_PUB.add;
2300: RAISE FND_API.G_EXC_ERROR;
2301: END IF;
2302:
2303: -- Fetching the primary UOM defined for the derived item
2304: p_x_route_mtl_reqs(p_x_index).uom_code := Get_Primary_UOM(

Line 2320: RAISE FND_API.G_EXC_ERROR;

2316: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2317: FND_MESSAGE.Set_Token('FUOM', l_cp_uom);
2318: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2319: FND_MSG_PUB.add;
2320: RAISE FND_API.G_EXC_ERROR;
2321: END IF;
2322:
2323: -- Fetching the primary UOM defined for the derived item
2324: l_cp_uom := Get_Primary_UOM(

Line 2372: RAISE FND_API.G_EXC_ERROR;

2368: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2369: l_msg_count := FND_MSG_PUB.count_msg;
2370: IF l_msg_count > 0 THEN
2371: x_msg_count := l_msg_count;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;
2374:
2375: -- Count and Get messages (optional)
2376: FND_MSG_PUB.count_and_get(

Line 2377: p_encoded => FND_API.G_FALSE,

2373: END IF;
2374:
2375: -- Count and Get messages (optional)
2376: FND_MSG_PUB.count_and_get(
2377: p_encoded => FND_API.G_FALSE,
2378: p_count => x_msg_count,
2379: p_data => x_msg_data);
2380:
2381: EXCEPTION

Line 2382: WHEN FND_API.G_EXC_ERROR THEN

2378: p_count => x_msg_count,
2379: p_data => x_msg_data);
2380:
2381: EXCEPTION
2382: WHEN FND_API.G_EXC_ERROR THEN
2383: ROLLBACK TO get_material_req_for_pos;
2384: x_return_status := FND_API.G_RET_STS_ERROR ;
2385: FND_MSG_PUB.count_and_get(
2386: p_encoded => FND_API.G_FALSE,

Line 2384: x_return_status := FND_API.G_RET_STS_ERROR ;

2380:
2381: EXCEPTION
2382: WHEN FND_API.G_EXC_ERROR THEN
2383: ROLLBACK TO get_material_req_for_pos;
2384: x_return_status := FND_API.G_RET_STS_ERROR ;
2385: FND_MSG_PUB.count_and_get(
2386: p_encoded => FND_API.G_FALSE,
2387: p_count => x_msg_count,
2388: p_data => x_msg_data);

Line 2386: p_encoded => FND_API.G_FALSE,

2382: WHEN FND_API.G_EXC_ERROR THEN
2383: ROLLBACK TO get_material_req_for_pos;
2384: x_return_status := FND_API.G_RET_STS_ERROR ;
2385: FND_MSG_PUB.count_and_get(
2386: p_encoded => FND_API.G_FALSE,
2387: p_count => x_msg_count,
2388: p_data => x_msg_data);
2389:
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2386: p_encoded => FND_API.G_FALSE,
2387: p_count => x_msg_count,
2388: p_data => x_msg_data);
2389:
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: ROLLBACK TO get_material_req_for_pos;
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2393: FND_MSG_PUB.count_and_get(
2394: p_encoded => FND_API.G_FALSE,

Line 2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2388: p_data => x_msg_data);
2389:
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: ROLLBACK TO get_material_req_for_pos;
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2393: FND_MSG_PUB.count_and_get(
2394: p_encoded => FND_API.G_FALSE,
2395: p_count => x_msg_count,
2396: p_data => x_msg_data);

Line 2394: p_encoded => FND_API.G_FALSE,

2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: ROLLBACK TO get_material_req_for_pos;
2392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2393: FND_MSG_PUB.count_and_get(
2394: p_encoded => FND_API.G_FALSE,
2395: p_count => x_msg_count,
2396: p_data => x_msg_data);
2397:
2398: WHEN OTHERS THEN

Line 2400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2396: p_data => x_msg_data);
2397:
2398: WHEN OTHERS THEN
2399: ROLLBACK TO get_material_req_for_pos;
2400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2401: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2402: THEN
2403: FND_MSG_PUB.add_exc_msg(
2404: p_pkg_name => G_PKG_NAME,

Line 2409: p_encoded => FND_API.G_FALSE,

2405: p_procedure_name => l_api_name,
2406: p_error_text => SUBSTRB(SQLERRM,1,240));
2407: END IF;
2408: FND_MSG_PUB.count_and_get(
2409: p_encoded => FND_API.G_FALSE,
2410: p_count => x_msg_count,
2411: p_data => x_msg_data);
2412:
2413:

Line 2516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2512: -- x_alt_items OUT Alt_Items_Tbl_Type Alternate Items for material requirement
2513: -- End of Comments
2514: PROCEDURE Get_Alternate_Items(
2515: p_api_version IN NUMBER,
2516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2518: p_schedule_material_id IN NUMBER,
2519: p_curr_item_flag IN VARCHAR2 := FND_API.G_FALSE,
2520: x_alt_items OUT NOCOPY Alt_Items_Tbl_Type,

Line 2517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2513: -- End of Comments
2514: PROCEDURE Get_Alternate_Items(
2515: p_api_version IN NUMBER,
2516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2518: p_schedule_material_id IN NUMBER,
2519: p_curr_item_flag IN VARCHAR2 := FND_API.G_FALSE,
2520: x_alt_items OUT NOCOPY Alt_Items_Tbl_Type,
2521: x_return_status OUT NOCOPY VARCHAR2,

Line 2519: p_curr_item_flag IN VARCHAR2 := FND_API.G_FALSE,

2515: p_api_version IN NUMBER,
2516: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2517: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2518: p_schedule_material_id IN NUMBER,
2519: p_curr_item_flag IN VARCHAR2 := FND_API.G_FALSE,
2520: x_alt_items OUT NOCOPY Alt_Items_Tbl_Type,
2521: x_return_status OUT NOCOPY VARCHAR2,
2522: x_msg_count OUT NOCOPY NUMBER,
2523: x_msg_data OUT NOCOPY VARCHAR2

Line 2710: x_return_status := FND_API.G_RET_STS_SUCCESS;

2706: l_inventory_item_id NUMBER := NULL;
2707: l_duplicate_item BOOLEAN := FALSE;
2708: BEGIN
2709: --Initialize API return status to success
2710: x_return_status := FND_API.G_RET_STS_SUCCESS;
2711:
2712: --Standard call to check for call compatibility.
2713: IF NOT FND_API.compatible_api_call(
2714: l_api_version,

Line 2713: IF NOT FND_API.compatible_api_call(

2709: --Initialize API return status to success
2710: x_return_status := FND_API.G_RET_STS_SUCCESS;
2711:
2712: --Standard call to check for call compatibility.
2713: IF NOT FND_API.compatible_api_call(
2714: l_api_version,
2715: p_api_version,
2716: l_api_name,
2717: G_PKG_NAME)

Line 2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2715: p_api_version,
2716: l_api_name,
2717: G_PKG_NAME)
2718: THEN
2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2720: END IF;
2721:
2722: --Initialize message list if p_init_msg_list is set to TRUE.
2723: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 2723: IF FND_API.to_boolean( p_init_msg_list ) THEN

2719: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2720: END IF;
2721:
2722: --Initialize message list if p_init_msg_list is set to TRUE.
2723: IF FND_API.to_boolean( p_init_msg_list ) THEN
2724: FND_MSG_PUB.initialize;
2725: END IF;
2726:
2727: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 2738: RAISE Fnd_Api.G_EXC_ERROR;

2734:
2735: IF p_schedule_material_id IS NULL THEN
2736: Fnd_Message.SET_NAME('AHL','AHL_LTP_MAT_ID_INVALID');
2737: Fnd_Msg_Pub.ADD;
2738: RAISE Fnd_Api.G_EXC_ERROR;
2739: END IF;
2740:
2741: OPEN get_asm_req_details_csr(p_schedule_material_id);
2742: FETCH get_asm_req_details_csr INTO l_asm_req_rec;

Line 2747: RAISE Fnd_Api.G_EXC_ERROR;

2743: IF get_asm_req_details_csr%NOTFOUND THEN
2744: Fnd_Message.SET_NAME('AHL','AHL_LTP_MAT_ID_INVALID');
2745: Fnd_Msg_Pub.ADD;
2746: CLOSE get_asm_req_details_csr;
2747: RAISE Fnd_Api.G_EXC_ERROR;
2748: END IF;
2749: CLOSE get_asm_req_details_csr;
2750:
2751: IF p_curr_item_flag IS NOT NULL AND p_curr_item_flag = FND_API.G_TRUE THEN

Line 2751: IF p_curr_item_flag IS NOT NULL AND p_curr_item_flag = FND_API.G_TRUE THEN

2747: RAISE Fnd_Api.G_EXC_ERROR;
2748: END IF;
2749: CLOSE get_asm_req_details_csr;
2750:
2751: IF p_curr_item_flag IS NOT NULL AND p_curr_item_flag = FND_API.G_TRUE THEN
2752: l_inventory_item_id := NULL;
2753: ELSE
2754: l_inventory_item_id := l_asm_req_rec.inventory_item_id;
2755: END IF;

Line 2849: RAISE FND_API.G_EXC_ERROR;

2845: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2846: l_msg_count := FND_MSG_PUB.count_msg;
2847: IF l_msg_count > 0 THEN
2848: x_msg_count := l_msg_count;
2849: RAISE FND_API.G_EXC_ERROR;
2850: END IF;
2851:
2852: -- Count and Get messages (optional)
2853: FND_MSG_PUB.count_and_get(

Line 2854: p_encoded => FND_API.G_FALSE,

2850: END IF;
2851:
2852: -- Count and Get messages (optional)
2853: FND_MSG_PUB.count_and_get(
2854: p_encoded => FND_API.G_FALSE,
2855: p_count => x_msg_count,
2856: p_data => x_msg_data);
2857:
2858: EXCEPTION

Line 2859: WHEN FND_API.G_EXC_ERROR THEN

2855: p_count => x_msg_count,
2856: p_data => x_msg_data);
2857:
2858: EXCEPTION
2859: WHEN FND_API.G_EXC_ERROR THEN
2860: x_return_status := FND_API.G_RET_STS_ERROR ;
2861: FND_MSG_PUB.count_and_get(
2862: p_encoded => FND_API.G_FALSE,
2863: p_count => x_msg_count,

Line 2860: x_return_status := FND_API.G_RET_STS_ERROR ;

2856: p_data => x_msg_data);
2857:
2858: EXCEPTION
2859: WHEN FND_API.G_EXC_ERROR THEN
2860: x_return_status := FND_API.G_RET_STS_ERROR ;
2861: FND_MSG_PUB.count_and_get(
2862: p_encoded => FND_API.G_FALSE,
2863: p_count => x_msg_count,
2864: p_data => x_msg_data);

Line 2862: p_encoded => FND_API.G_FALSE,

2858: EXCEPTION
2859: WHEN FND_API.G_EXC_ERROR THEN
2860: x_return_status := FND_API.G_RET_STS_ERROR ;
2861: FND_MSG_PUB.count_and_get(
2862: p_encoded => FND_API.G_FALSE,
2863: p_count => x_msg_count,
2864: p_data => x_msg_data);
2865:
2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2862: p_encoded => FND_API.G_FALSE,
2863: p_count => x_msg_count,
2864: p_data => x_msg_data);
2865:
2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2868: FND_MSG_PUB.count_and_get(
2869: p_encoded => FND_API.G_FALSE,
2870: p_count => x_msg_count,

Line 2867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2863: p_count => x_msg_count,
2864: p_data => x_msg_data);
2865:
2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2868: FND_MSG_PUB.count_and_get(
2869: p_encoded => FND_API.G_FALSE,
2870: p_count => x_msg_count,
2871: p_data => x_msg_data);

Line 2869: p_encoded => FND_API.G_FALSE,

2865:
2866: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2868: FND_MSG_PUB.count_and_get(
2869: p_encoded => FND_API.G_FALSE,
2870: p_count => x_msg_count,
2871: p_data => x_msg_data);
2872:
2873: WHEN OTHERS THEN

Line 2874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2870: p_count => x_msg_count,
2871: p_data => x_msg_data);
2872:
2873: WHEN OTHERS THEN
2874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2875: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2876: THEN
2877: FND_MSG_PUB.add_exc_msg(
2878: p_pkg_name => G_PKG_NAME,

Line 2883: p_encoded => FND_API.G_FALSE,

2879: p_procedure_name => l_api_name,
2880: p_error_text => SUBSTRB(SQLERRM,1,240));
2881: END IF;
2882: FND_MSG_PUB.count_and_get(
2883: p_encoded => FND_API.G_FALSE,
2884: p_count => x_msg_count,
2885: p_data => x_msg_data);
2886: END Get_Alternate_Items;
2887: ------------------------------------------------------------------------------------