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_REQST_MATRL_PVT dependencies on AHL_PP_MATERIALS_PVT

Line 1662: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

1658: -- Variables added by surrkuma on 15-JUL-2010 for bug 9901811
1659: l_unsched_mtl_tbl AHL_LTP_MATRL_AVAL_PUB.Planned_Matrl_Tbl;
1660: l_unsched_mtl_index NUMBER := 1;
1661: --Variables added by surrkuma on 27-Jun-2011 for SB
1662: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
1663: l_req_mtl_index NUMBER := 1;
1664: l_mr_id NUMBER; -- Added by tchimira for VWPE 12673125
1665: l_unit_eff_id NUMBER; -- Added by tchimira for VWPE 12673125
1666: l_instance_id NUMBER; -- Added by tchimira for VWPE 12673125

Line 1968: 'Before Calling AHL_PP_MATERIALS_PVT.Process_Material_Request');

1964: -- Calling production API to change the item in ASM and WIP requirement
1965: IF l_req_material_tbl.COUNT > 0 THEN
1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1967: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,
1968: 'Before Calling AHL_PP_MATERIALS_PVT.Process_Material_Request');
1969: END IF;
1970: AHL_PP_MATERIALS_PVT.Process_Material_Request(
1971: p_api_version => l_api_version,
1972: p_x_req_material_tbl => l_req_material_tbl,

Line 1970: AHL_PP_MATERIALS_PVT.Process_Material_Request(

1966: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1967: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,
1968: 'Before Calling AHL_PP_MATERIALS_PVT.Process_Material_Request');
1969: END IF;
1970: AHL_PP_MATERIALS_PVT.Process_Material_Request(
1971: p_api_version => l_api_version,
1972: p_x_req_material_tbl => l_req_material_tbl,
1973: x_return_status => l_return_status,
1974: x_msg_count => l_msg_count,

Line 1979: 'Returned from call to AHL_PP_MATERIALS_PVT.Process_Material_Request. x_return_status = ' || l_return_status);

1975: x_msg_data => l_msg_data
1976: );
1977: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1978: fnd_log.string(fnd_log.level_statement, L_DEBUG_KEY,
1979: 'Returned from call to AHL_PP_MATERIALS_PVT.Process_Material_Request. x_return_status = ' || l_return_status);
1980: END IF;
1981: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
1982: l_msg_count := FND_MSG_PUB.count_msg;
1983: IF l_msg_count > 0 THEN

Line 3532: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

3528: l_commit VARCHAR2(30) := p_commit;
3529: l_prim_quantity NUMBER;
3530: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Associate_Stage_Materials';
3531: l_nrp_mat_req_tbl AHL_RA_NR_PROFILE_PVT.nrp_mat_req_tbl_type;
3532: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
3533: l_requested_date DATE;
3534: l_workorder_id NUMBER;
3535: l_operation_sequence NUMBER;
3536: l_workorder_operation_id NUMBER;

Line 3863: 'Before calling AHL_PP_MATERIALS_PVT.Process_Material_Request, l_req_material_tbl.count: '||l_req_material_tbl.count );

3859:
3860: IF (fnd_log.level_procedure >= l_log_current_level) THEN
3861: fnd_log.string ( fnd_log.level_procedure,
3862: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3863: 'Before calling AHL_PP_MATERIALS_PVT.Process_Material_Request, l_req_material_tbl.count: '||l_req_material_tbl.count );
3864: END IF;
3865:
3866: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM and to create in only WIP table
3867: IF l_req_material_tbl.count > 0 THEN

Line 3866: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM and to create in only WIP table

3862: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
3863: 'Before calling AHL_PP_MATERIALS_PVT.Process_Material_Request, l_req_material_tbl.count: '||l_req_material_tbl.count );
3864: END IF;
3865:
3866: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM and to create in only WIP table
3867: IF l_req_material_tbl.count > 0 THEN
3868: FOR i IN l_req_material_tbl.FIRST..l_req_material_tbl.LAST LOOP
3869: IF (l_log_statement >= l_log_current_level)THEN
3870: fnd_log.string (l_log_statement,

Line 3872: 'Attributes of l_req_material_tbl as passed to AHL_PP_MATERIALS_PVT.Process_Material_Request : Row - '|| i ||' ,SCHEDULE_MATERIAL_ID: '

3868: FOR i IN l_req_material_tbl.FIRST..l_req_material_tbl.LAST LOOP
3869: IF (l_log_statement >= l_log_current_level)THEN
3870: fnd_log.string (l_log_statement,
3871: l_debug_key,
3872: 'Attributes of l_req_material_tbl as passed to AHL_PP_MATERIALS_PVT.Process_Material_Request : Row - '|| i ||' ,SCHEDULE_MATERIAL_ID: '
3873: || l_req_material_tbl(i).SCHEDULE_MATERIAL_ID||' ,INVENTORY_ITEM_ID: ' || l_req_material_tbl(i).INVENTORY_ITEM_ID || ' , REQ QUANTITY : '
3874: || l_req_material_tbl(i).REQUESTED_QUANTITY || ' , SCH QTY: '||l_req_material_tbl(i).SCHEDULED_QUANTITY||' ,WORKORDER_ID: '||l_req_material_tbl(i).WORKORDER_ID
3875: ||' ,WORKORDER_OPERATION_ID: '||l_req_material_tbl(i).WORKORDER_OPERATION_ID ||' ,OPERATION_FLAG: '||l_req_material_tbl(i).OPERATION_FLAG);
3876: END IF;

Line 3879: AHL_PP_MATERIALS_PVT.Process_Material_Request (

3875: ||' ,WORKORDER_OPERATION_ID: '||l_req_material_tbl(i).WORKORDER_OPERATION_ID ||' ,OPERATION_FLAG: '||l_req_material_tbl(i).OPERATION_FLAG);
3876: END IF;
3877: END LOOP;
3878:
3879: AHL_PP_MATERIALS_PVT.Process_Material_Request (
3880: p_api_version => 1.0 ,
3881: p_init_msg_list => FND_API.G_TRUE,
3882: p_commit => FND_API.G_FALSE,
3883: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 3896: 'After calling AHL_PP_MATERIALS_PVT.Process_Material_Request. l_return_status = ' || l_return_status);

3892:
3893: IF (l_log_statement >= l_log_current_level) THEN
3894: fnd_log.string(l_log_statement,
3895: L_DEBUG_KEY,
3896: 'After calling AHL_PP_MATERIALS_PVT.Process_Material_Request. l_return_status = ' || l_return_status);
3897: END IF;
3898:
3899: -- Check Error Message stack.
3900: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 4009: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

4005: l_prim_req_quantity NUMBER;
4006: l_prim_sch_quantity NUMBER;
4007: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_REQST_MATRL_PVT.Remove_Stage_Materials';
4008: l_nrp_mat_req_tbl AHL_RA_NR_PROFILE_PVT.nrp_mat_req_tbl_type;
4009: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4010: l_requested_date DATE;
4011: l_workorder_id NUMBER;
4012: l_operation_sequence NUMBER;
4013: l_workorder_operation_id NUMBER;

Line 4173: 'Attributes of l_req_material_tbl passed to AHL_PP_MATERIALS_PVT.Process_Material_Request : Row - '|| i ||' - INVENTORY_ITEM_ID: ' || l_nrp_mat_req_tbl(i).INVENTORY_ITEM_ID

4169: fnd_log.string
4170: (
4171: l_log_statement,
4172: l_debug_key,
4173: 'Attributes of l_req_material_tbl passed to AHL_PP_MATERIALS_PVT.Process_Material_Request : Row - '|| i ||' - INVENTORY_ITEM_ID: ' || l_nrp_mat_req_tbl(i).INVENTORY_ITEM_ID
4174: || ' , Req QUANTITY : ' || l_prim_req_quantity || ' , Sch QUANTITY : ' || l_prim_sch_quantity || ' , UOM_CODE: '||l_uom_code || ' , l_workorder_id: '||l_workorder_id
4175: );
4176: END IF;
4177: -- SKPATHAK :: 18-JUL-2011 :: VWPE 12730539

Line 4229: 'Before calling AHL_PP_MATERIALS_PVT.Process_Material_Request, l_req_material_tbl.count= '||l_req_material_tbl.count );

4225:
4226: IF (fnd_log.level_procedure >= l_log_current_level) THEN
4227: fnd_log.string(fnd_log.level_procedure,
4228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4229: 'Before calling AHL_PP_MATERIALS_PVT.Process_Material_Request, l_req_material_tbl.count= '||l_req_material_tbl.count );
4230: END IF;
4231:
4232: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM
4233: IF l_req_material_tbl.count > 0 THEN

Line 4232: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM

4228: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4229: 'Before calling AHL_PP_MATERIALS_PVT.Process_Material_Request, l_req_material_tbl.count= '||l_req_material_tbl.count );
4230: END IF;
4231:
4232: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM
4233: IF l_req_material_tbl.count > 0 THEN
4234: FOR i IN l_req_material_tbl.FIRST..l_req_material_tbl.LAST LOOP
4235: IF (l_log_statement >= l_log_current_level)THEN
4236: fnd_log.string (l_log_statement,

Line 4238: 'Attributes of l_req_material_tbl as passed to AHL_PP_MATERIALS_PVT.Process_Material_Request : Row - '|| i

4234: FOR i IN l_req_material_tbl.FIRST..l_req_material_tbl.LAST LOOP
4235: IF (l_log_statement >= l_log_current_level)THEN
4236: fnd_log.string (l_log_statement,
4237: l_debug_key,
4238: 'Attributes of l_req_material_tbl as passed to AHL_PP_MATERIALS_PVT.Process_Material_Request : Row - '|| i
4239: ||' ,INVENTORY_ITEM_ID: ' || l_req_material_tbl(i).INVENTORY_ITEM_ID || ' , REQ QUANTITY : ' || l_req_material_tbl(i).REQUESTED_QUANTITY
4240: || ' , SCH QTY: '||l_req_material_tbl(i).SCHEDULED_QUANTITY||' ,WORKORDER_ID: '||l_req_material_tbl(i).WORKORDER_ID
4241: ||' ,WORKORDER_OPERATION_ID: '||l_req_material_tbl(i).WORKORDER_OPERATION_ID ||' ,OPERATION_FLAG: '||l_req_material_tbl(i).OPERATION_FLAG);
4242: END IF;

Line 4244: AHL_PP_MATERIALS_PVT.Process_Material_Request (

4240: || ' , SCH QTY: '||l_req_material_tbl(i).SCHEDULED_QUANTITY||' ,WORKORDER_ID: '||l_req_material_tbl(i).WORKORDER_ID
4241: ||' ,WORKORDER_OPERATION_ID: '||l_req_material_tbl(i).WORKORDER_OPERATION_ID ||' ,OPERATION_FLAG: '||l_req_material_tbl(i).OPERATION_FLAG);
4242: END IF;
4243: END LOOP;
4244: AHL_PP_MATERIALS_PVT.Process_Material_Request (
4245: p_api_version => 1.0 ,
4246: p_init_msg_list => FND_API.G_TRUE,
4247: p_commit => FND_API.G_FALSE,
4248: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4262: 'After calling AHL_PP_MATERIALS_PVT.Process_Material_Request. l_return_status = ' || l_return_status);

4258:
4259: IF (l_log_statement >= l_log_current_level) THEN
4260: fnd_log.string(l_log_statement,
4261: L_DEBUG_KEY,
4262: 'After calling AHL_PP_MATERIALS_PVT.Process_Material_Request. l_return_status = ' || l_return_status);
4263: END IF;
4264:
4265: -- Check Error Message stack.
4266: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN

Line 4372: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;

4368: l_workorder_operation_id NUMBER;
4369: l_visit_id NUMBER;
4370: i NUMBER := 0 ;
4371: l_workorder_tbl AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_TBL;
4372: l_req_material_tbl AHL_PP_MATERIALS_PVT.Req_Material_Tbl_Type;
4373:
4374: -- Cursor to get the materials associated to the default stage task
4375: Cursor get_scheduled_mat_detls (c_task_id IN NUMBER)
4376: IS

Line 4453: 'Before calling AHL_PP_MATERIALS_PVT.Process_Material_Request, l_req_material_tbl.count= '||l_req_material_tbl.count );

4449: END LOOP;
4450:
4451: IF (fnd_log.level_procedure >= l_log_current_level) THEN
4452: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY,
4453: 'Before calling AHL_PP_MATERIALS_PVT.Process_Material_Request, l_req_material_tbl.count= '||l_req_material_tbl.count );
4454: END IF;
4455:
4456: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM
4457: IF l_req_material_tbl.count > 0 THEN

Line 4456: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM

4452: fnd_log.string(fnd_log.level_procedure,L_DEBUG_KEY,
4453: 'Before calling AHL_PP_MATERIALS_PVT.Process_Material_Request, l_req_material_tbl.count= '||l_req_material_tbl.count );
4454: END IF;
4455:
4456: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM
4457: IF l_req_material_tbl.count > 0 THEN
4458: AHL_PP_MATERIALS_PVT.Process_Material_Request (
4459: p_api_version => 1.0 ,
4460: p_init_msg_list => FND_API.G_TRUE,

Line 4458: AHL_PP_MATERIALS_PVT.Process_Material_Request (

4454: END IF;
4455:
4456: --Call AHL_PP_MATERIALS_PVT.Process_Material_Request to update materials both in WIP table and in ASM
4457: IF l_req_material_tbl.count > 0 THEN
4458: AHL_PP_MATERIALS_PVT.Process_Material_Request (
4459: p_api_version => 1.0 ,
4460: p_init_msg_list => FND_API.G_TRUE,
4461: p_commit => FND_API.G_FALSE,
4462: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

Line 4476: 'After calling AHL_PP_MATERIALS_PVT.Process_Material_Request. l_return_status = ' || l_return_status);

4472:
4473: IF (l_log_statement >= l_log_current_level) THEN
4474: fnd_log.string(l_log_statement,
4475: L_DEBUG_KEY,
4476: 'After calling AHL_PP_MATERIALS_PVT.Process_Material_Request. l_return_status = ' || l_return_status);
4477: END IF;
4478:
4479: -- Check Error Message stack.
4480: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN