APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_RA_NR_PROFILE_PVT

Line 3531: l_nrp_mat_req_tbl AHL_RA_NR_PROFILE_PVT.nrp_mat_req_tbl_type;

3527: l_init_msg_list VARCHAR2(10):= p_init_msg_list;
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;

Line 3643: 'Before calling AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ, p_mr_header_id : '

3639:
3640: IF (l_log_statement >= l_log_current_level)THEN
3641: fnd_log.string (l_log_statement,
3642: l_debug_key,
3643: 'Before calling AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ, p_mr_header_id : '
3644: || p_mr_header_id || ' , p_instance_id: '||p_instance_id ||' , p_ue_id: '||p_ue_id);
3645: END IF;
3646: --Get all the NR Profile material for the given MR
3647: AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ

Line 3647: AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ

3643: 'Before calling AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ, p_mr_header_id : '
3644: || p_mr_header_id || ' , p_instance_id: '||p_instance_id ||' , p_ue_id: '||p_ue_id);
3645: END IF;
3646: --Get all the NR Profile material for the given MR
3647: AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ
3648: (p_mr_header_id => p_mr_header_id,
3649: p_instance_id => p_instance_id,
3650: p_ue_id => p_ue_id,
3651: p_plan_id => null,

Line 4008: l_nrp_mat_req_tbl AHL_RA_NR_PROFILE_PVT.nrp_mat_req_tbl_type;

4004: l_uom_code VARCHAR2(30);
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;

Line 4095: 'Before calling AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ, p_mr_header_id : '

4091:
4092: IF (l_log_statement >= l_log_current_level)THEN
4093: fnd_log.string ( l_log_statement,
4094: l_debug_key,
4095: 'Before calling AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ, p_mr_header_id : '
4096: || p_mr_header_id || ' , p_instance_id: '||p_instance_id ||' , p_ue_id: '||p_ue_id);
4097: END IF;
4098: --Get all the NR Profile material for the given MR
4099: AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ

Line 4099: AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ

4095: 'Before calling AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ, p_mr_header_id : '
4096: || p_mr_header_id || ' , p_instance_id: '||p_instance_id ||' , p_ue_id: '||p_ue_id);
4097: END IF;
4098: --Get all the NR Profile material for the given MR
4099: AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ
4100: (p_mr_header_id => p_mr_header_id,
4101: p_instance_id => p_instance_id,
4102: p_ue_id => p_ue_id,
4103: p_plan_id => null,

Line 4113: 'After calling AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ. l_return_status = ' || l_return_status);

4109:
4110: IF (l_log_statement >= l_log_current_level) THEN
4111: fnd_log.string(l_log_statement,
4112: L_DEBUG_KEY,
4113: 'After calling AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ. l_return_status = ' || l_return_status);
4114: END IF;
4115:
4116: IF NVL(l_return_status,'x') <> FND_API.G_RET_STS_SUCCESS THEN
4117: x_msg_count := FND_MSG_PUB.count_msg;

Line 4121: 'Errors from AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ. Message count: ' || x_msg_count);

4117: x_msg_count := FND_MSG_PUB.count_msg;
4118: IF (l_log_statement >= l_log_current_level) THEN
4119: fnd_log.string(l_log_statement,
4120: L_DEBUG_KEY,
4121: 'Errors from AHL_RA_NR_PROFILE_PVT.POPULATE_PROF_MAT_REQ. Message count: ' || x_msg_count);
4122: END IF;
4123: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4124: RAISE FND_API.G_EXC_ERROR;
4125: ELSE