DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_UTIL_PVT dependencies on AHL_PP_MATERIALS_PVT

Line 1982: l_req_material_rec AHL_PP_Materials_PVT.req_material_rec_type;

1978: l_mtl_requirement check_mtl_requirement%ROWTYPE;
1979:
1980: l_api_version CONSTANT NUMBER := 1.0;
1981: l_api_name CONSTANT VARCHAR2(30) := 'Create_Disp_Mtl_Requirement';
1982: l_req_material_rec AHL_PP_Materials_PVT.req_material_rec_type;
1983: l_req_material_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1984: l_req_material_u_rec AHL_PP_Materials_PVT.req_material_rec_type;
1985: l_req_material_u_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1986: l_disp_rec get_disp_dtls_csr%ROWTYPE;

Line 1983: l_req_material_tbl AHL_PP_Materials_PVT.req_material_tbl_type;

1979:
1980: l_api_version CONSTANT NUMBER := 1.0;
1981: l_api_name CONSTANT VARCHAR2(30) := 'Create_Disp_Mtl_Requirement';
1982: l_req_material_rec AHL_PP_Materials_PVT.req_material_rec_type;
1983: l_req_material_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1984: l_req_material_u_rec AHL_PP_Materials_PVT.req_material_rec_type;
1985: l_req_material_u_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1986: l_disp_rec get_disp_dtls_csr%ROWTYPE;
1987: l_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;

Line 1984: l_req_material_u_rec AHL_PP_Materials_PVT.req_material_rec_type;

1980: l_api_version CONSTANT NUMBER := 1.0;
1981: l_api_name CONSTANT VARCHAR2(30) := 'Create_Disp_Mtl_Requirement';
1982: l_req_material_rec AHL_PP_Materials_PVT.req_material_rec_type;
1983: l_req_material_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1984: l_req_material_u_rec AHL_PP_Materials_PVT.req_material_rec_type;
1985: l_req_material_u_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1986: l_disp_rec get_disp_dtls_csr%ROWTYPE;
1987: l_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1988: l_relationship_id NUMBER;

Line 1985: l_req_material_u_tbl AHL_PP_Materials_PVT.req_material_tbl_type;

1981: l_api_name CONSTANT VARCHAR2(30) := 'Create_Disp_Mtl_Requirement';
1982: l_req_material_rec AHL_PP_Materials_PVT.req_material_rec_type;
1983: l_req_material_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1984: l_req_material_u_rec AHL_PP_Materials_PVT.req_material_rec_type;
1985: l_req_material_u_tbl AHL_PP_Materials_PVT.req_material_tbl_type;
1986: l_disp_rec get_disp_dtls_csr%ROWTYPE;
1987: l_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE;
1988: l_relationship_id NUMBER;
1989: l_job_return_status VARCHAR2(1);

Line 2121: 'Just before calling API: Ahl_PP_Materials_PVT.Process_Material_Request');

2117:
2118: IF (FND_LOG.LEVEL_EVENT>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2119: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2120: G_LOG_PREFIX||l_api_name||': Within the API',
2121: 'Just before calling API: Ahl_PP_Materials_PVT.Process_Material_Request');
2122: END IF;
2123: Ahl_PP_Materials_PVT.Process_Material_Request (
2124: p_api_version => 1.0,
2125: p_init_msg_list => p_init_msg_list,

Line 2123: Ahl_PP_Materials_PVT.Process_Material_Request (

2119: FND_LOG.STRING(FND_LOG.LEVEL_EVENT,
2120: G_LOG_PREFIX||l_api_name||': Within the API',
2121: 'Just before calling API: Ahl_PP_Materials_PVT.Process_Material_Request');
2122: END IF;
2123: Ahl_PP_Materials_PVT.Process_Material_Request (
2124: p_api_version => 1.0,
2125: p_init_msg_list => p_init_msg_list,
2126: p_commit => FND_API.G_FALSE,
2127: p_validation_level => p_validation_level,

Line 2142: 'Just before calling API: Ahl_PP_Materials_PVT.Create_Material_Reqst');

2138: close check_mtl_requirement;
2139: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2140: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2141: G_LOG_PREFIX||l_api_name||': Within the API',
2142: 'Just before calling API: Ahl_PP_Materials_PVT.Create_Material_Reqst');
2143: END IF;
2144: Ahl_PP_Materials_PVT.Create_Material_Reqst (
2145: p_api_version => 1.0,
2146: p_init_msg_list => p_init_msg_list,

Line 2144: Ahl_PP_Materials_PVT.Create_Material_Reqst (

2140: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2141: G_LOG_PREFIX||l_api_name||': Within the API',
2142: 'Just before calling API: Ahl_PP_Materials_PVT.Create_Material_Reqst');
2143: END IF;
2144: Ahl_PP_Materials_PVT.Create_Material_Reqst (
2145: p_api_version => 1.0,
2146: p_init_msg_list => p_init_msg_list,
2147: p_commit => FND_API.G_FALSE,
2148: p_validation_level => p_validation_level,

Line 2162: 'Error occurred after calling the API in Ahl_PP_Materials_PVT and x_return_status='||

2158: IF x_msg_count > 0 THEN
2159: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2160: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2161: G_LOG_PREFIX||l_api_name||': Within the API',
2162: 'Error occurred after calling the API in Ahl_PP_Materials_PVT and x_return_status='||
2163: x_return_status||', x_msg_count='||x_msg_count);
2164: END IF;
2165: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2166: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;