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_PP_MATERIALS_PVT dependencies on FND_LOG

Line 4012: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4008:
4009: l_net_qty := l_issue_qty - l_rtn_qty;
4010:
4011: -- JKJAIN BUG # 7587902
4012: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4013: -- fnd_log.string
4014: -- (
4015: -- fnd_log.level_statement,
4016: -- 'ahl.plsql.AHL_PP_MATERIALS_PVT.GET_NET_QTY',

Line 4013: -- fnd_log.string

4009: l_net_qty := l_issue_qty - l_rtn_qty;
4010:
4011: -- JKJAIN BUG # 7587902
4012: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4013: -- fnd_log.string
4014: -- (
4015: -- fnd_log.level_statement,
4016: -- 'ahl.plsql.AHL_PP_MATERIALS_PVT.GET_NET_QTY',
4017: -- 'l_net_qty -> ' || l_net_qty

Line 4015: -- fnd_log.level_statement,

4011: -- JKJAIN BUG # 7587902
4012: -- IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4013: -- fnd_log.string
4014: -- (
4015: -- fnd_log.level_statement,
4016: -- 'ahl.plsql.AHL_PP_MATERIALS_PVT.GET_NET_QTY',
4017: -- 'l_net_qty -> ' || l_net_qty
4018: -- );
4019: -- END IF;

Line 4123: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4119: dff_default_values dff_default_values_type;
4120:
4121: BEGIN
4122:
4123: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4124: fnd_log.string
4125: (
4126: fnd_log.level_procedure,
4127: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials',

Line 4124: fnd_log.string

4120:
4121: BEGIN
4122:
4123: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4124: fnd_log.string
4125: (
4126: fnd_log.level_procedure,
4127: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials',
4128: 'At the start of PLSQL procedure'

Line 4126: fnd_log.level_procedure,

4122:
4123: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4124: fnd_log.string
4125: (
4126: fnd_log.level_procedure,
4127: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials',
4128: 'At the start of PLSQL procedure'
4129: );
4130: END IF;

Line 4166: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4162: FETCH Visit_Task_Cur INTO l_Visit_Task_Rec;
4163: CLOSE Visit_Task_Cur;
4164:
4165:
4166: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4167: fnd_log.string
4168: (
4169: fnd_log.level_statement,
4170: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 4167: fnd_log.string

4163: CLOSE Visit_Task_Cur;
4164:
4165:
4166: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4167: fnd_log.string
4168: (
4169: fnd_log.level_statement,
4170: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4171: 'Material Requirement for workorder id: ' || l_prd_wooperation_tbl(i).workorder_id

Line 4169: fnd_log.level_statement,

4165:
4166: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4167: fnd_log.string
4168: (
4169: fnd_log.level_statement,
4170: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4171: 'Material Requirement for workorder id: ' || l_prd_wooperation_tbl(i).workorder_id
4172: );
4173: fnd_log.string

Line 4173: fnd_log.string

4169: fnd_log.level_statement,
4170: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4171: 'Material Requirement for workorder id: ' || l_prd_wooperation_tbl(i).workorder_id
4172: );
4173: fnd_log.string
4174: (
4175: fnd_log.level_statement,
4176: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4177: 'Material Requirement for workorder operation id: ' || l_prd_wooperation_tbl(i).workorder_operation_id

Line 4175: fnd_log.level_statement,

4171: 'Material Requirement for workorder id: ' || l_prd_wooperation_tbl(i).workorder_id
4172: );
4173: fnd_log.string
4174: (
4175: fnd_log.level_statement,
4176: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4177: 'Material Requirement for workorder operation id: ' || l_prd_wooperation_tbl(i).workorder_operation_id
4178: );
4179: fnd_log.string

Line 4179: fnd_log.string

4175: fnd_log.level_statement,
4176: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4177: 'Material Requirement for workorder operation id: ' || l_prd_wooperation_tbl(i).workorder_operation_id
4178: );
4179: fnd_log.string
4180: (
4181: fnd_log.level_statement,
4182: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4183: 'Material Requirement for workorder operation seq: ' || l_prd_wooperation_tbl(i).operation_sequence_num

Line 4181: fnd_log.level_statement,

4177: 'Material Requirement for workorder operation id: ' || l_prd_wooperation_tbl(i).workorder_operation_id
4178: );
4179: fnd_log.string
4180: (
4181: fnd_log.level_statement,
4182: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4183: 'Material Requirement for workorder operation seq: ' || l_prd_wooperation_tbl(i).operation_sequence_num
4184: );
4185:

Line 4448: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4444: IF Fnd_Api.TO_BOOLEAN(p_commit) THEN
4445: COMMIT;
4446: END IF;
4447: -- Debug info
4448: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4449: fnd_log.string
4450: (
4451: fnd_log.level_procedure,
4452: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials.end',

Line 4449: fnd_log.string

4445: COMMIT;
4446: END IF;
4447: -- Debug info
4448: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4449: fnd_log.string
4450: (
4451: fnd_log.level_procedure,
4452: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials.end',
4453: 'At the end of PLSQL procedure'

Line 4451: fnd_log.level_procedure,

4447: -- Debug info
4448: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4449: fnd_log.string
4450: (
4451: fnd_log.level_procedure,
4452: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Process_Wo_Op_Materials.end',
4453: 'At the end of PLSQL procedure'
4454: );
4455: END IF;

Line 4617: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4613: l_Req_Material_Tbl Req_Material_Tbl_Type := p_Req_Material_Tbl;
4614:
4615: BEGIN
4616:
4617: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4618: fnd_log.string
4619: (
4620: fnd_log.level_procedure,
4621: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification',

Line 4618: fnd_log.string

4614:
4615: BEGIN
4616:
4617: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4618: fnd_log.string
4619: (
4620: fnd_log.level_procedure,
4621: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification',
4622: 'At the start of PLSQL procedure'

Line 4620: fnd_log.level_procedure,

4616:
4617: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4618: fnd_log.string
4619: (
4620: fnd_log.level_procedure,
4621: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification',
4622: 'At the start of PLSQL procedure'
4623: );
4624: END IF;

Line 4643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4639: THEN
4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: END IF;
4642:
4643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4644: fnd_log.string
4645: (
4646: fnd_log.level_statement,
4647: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 4644: fnd_log.string

4640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4641: END IF;
4642:
4643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4644: fnd_log.string
4645: (
4646: fnd_log.level_statement,
4647: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4648: 'Request for Material Notification for Number of Records : ' || l_Req_Material_Tbl.COUNT

Line 4646: fnd_log.level_statement,

4642:
4643: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4644: fnd_log.string
4645: (
4646: fnd_log.level_statement,
4647: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4648: 'Request for Material Notification for Number of Records : ' || l_Req_Material_Tbl.COUNT
4649: );
4650:

Line 4653: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4649: );
4650:
4651: END IF;
4652:
4653: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4654: fnd_log.string
4655: (
4656: fnd_log.level_procedure,
4657: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 4654: fnd_log.string

4650:
4651: END IF;
4652:
4653: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4654: fnd_log.string
4655: (
4656: fnd_log.level_procedure,
4657: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4658: 'Before calling Ahl_Utility_Pvt.Get_Wf_Process_Name'

Line 4656: fnd_log.level_procedure,

4652:
4653: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4654: fnd_log.string
4655: (
4656: fnd_log.level_procedure,
4657: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4658: 'Before calling Ahl_Utility_Pvt.Get_Wf_Process_Name'
4659: );
4660:

Line 4676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4672: x_msg_count =>l_msg_count,
4673: x_msg_data =>l_msg_data);
4674:
4675:
4676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4677: fnd_log.string
4678: (
4679: fnd_log.level_procedure,
4680: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',

Line 4677: fnd_log.string

4673: x_msg_data =>l_msg_data);
4674:
4675:
4676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4677: fnd_log.string
4678: (
4679: fnd_log.level_procedure,
4680: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
4681: 'After calling Ahl_Utility_Pvt.Get_Wf_Process_Name, Return Status : '|| l_return_status

Line 4679: fnd_log.level_procedure,

4675:
4676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4677: fnd_log.string
4678: (
4679: fnd_log.level_procedure,
4680: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
4681: 'After calling Ahl_Utility_Pvt.Get_Wf_Process_Name, Return Status : '|| l_return_status
4682: );
4683: END IF;

Line 4690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4686: IF (l_return_Status <> FND_API.G_RET_STS_SUCCESS) THEN
4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;
4689:
4690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4691: fnd_log.string
4692: (
4693: fnd_log.level_statement,
4694: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 4691: fnd_log.string

4687: RAISE FND_API.G_EXC_ERROR;
4688: END IF;
4689:
4690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4691: fnd_log.string
4692: (
4693: fnd_log.level_statement,
4694: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4695: 'Active flag : '||l_active

Line 4693: fnd_log.level_statement,

4689:
4690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4691: fnd_log.string
4692: (
4693: fnd_log.level_statement,
4694: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4695: 'Active flag : '||l_active
4696: );
4697: END IF;

Line 4747: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

4743: END IF;
4744:
4745: END LOOP;
4746:
4747: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4748: fnd_log.string
4749: (
4750: fnd_log.level_statement,
4751: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',

Line 4748: fnd_log.string

4744:
4745: END LOOP;
4746:
4747: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4748: fnd_log.string
4749: (
4750: fnd_log.level_statement,
4751: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4752: 'Number of records : '||l_Req_Material_Tbl.count

Line 4750: fnd_log.level_statement,

4746:
4747: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
4748: fnd_log.string
4749: (
4750: fnd_log.level_statement,
4751: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
4752: 'Number of records : '||l_Req_Material_Tbl.count
4753: );
4754: END IF;

Line 4787: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

4783:
4784: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
4785: END IF;
4786:
4787: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4788: fnd_log.string
4789: (
4790: fnd_log.level_procedure,
4791: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification.end',

Line 4788: fnd_log.string

4784: WF_NOTIFICATION.Denormalize_Notification(l_notif_id);
4785: END IF;
4786:
4787: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4788: fnd_log.string
4789: (
4790: fnd_log.level_procedure,
4791: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification.end',
4792: 'At the end of PLSQL procedure'

Line 4790: fnd_log.level_procedure,

4786:
4787: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
4788: fnd_log.string
4789: (
4790: fnd_log.level_procedure,
4791: 'ahl.plsql.AHL_PP_MATERIALS_PVT.Material_Notification.end',
4792: 'At the end of PLSQL procedure'
4793: );
4794: END IF;