[Home] [Help]
2: /* $Header: AHLVMTXB.pls 120.28.12010000.4 2008/11/26 11:31:26 jkjain ship $ */
3:
4: G_DEBUG VARCHAR2(1):=AHL_DEBUG_PUB.is_log_enabled;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_MTLTXN_PVT';
6: G_AHL_PRD_RECEPIENT VARCHAR2(30) := FND_PROFILE.VALUE('AHL_PRD_MTX_RECEPIENT');
7:
8: -- Hard coded string used in this proc
9: -- These are the profile names used to populate service request record default values
10:
652: END IF;
653:
654: IF(p_x_ahl_mtltxn_rec.recepient_id IS NULL OR p_x_ahl_mtltxn_rec.recepient_id = FND_API.G_MISS_NUM)
655: THEN
656: IF(NVL(FND_PROFILE.VALUE('AHL_PRD_MTX_RECEPIENT'),'N')='Y')
657: THEN
658: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
659: THEN
660: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY2');
1232: IF (p_x_ahl_mtltxn_tbl(i).locator_segments IS NOT NULL AND
1233: p_x_ahl_mtltxn_tbl(i).locator_id IS NULL) THEN
1234:
1235: IF G_DEBUG='Y' THEN
1236: AHL_DEBUG_PUB.DEBUG('Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );
1237: END IF;
1238:
1239: l_valid_flag := fnd_flex_keyval.validate_segs(
1240: operation => 'FIND_COMBINATION'
1805: (
1806: SELECT 1
1807: FROM CS_SR_PROB_CODE_MAPPING_DETAIL
1808: WHERE
1809: INCIDENT_TYPE_ID = FND_PROFILE.VALUE('AHL_PRD_SR_TYPE') AND
1810: TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))
1811: )
1812: )
1813: OR
1816: (
1817: SELECT 1
1818: FROM CS_SR_PROB_CODE_MAPPING_DETAIL
1819: WHERE
1820: INCIDENT_TYPE_ID = FND_PROFILE.VALUE('AHL_PRD_SR_TYPE') AND
1821: PROBLEM_CODE = p_problem_code AND
1822: TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))
1823: )
1824: )
2604: p_default => FND_API.G_FALSE,
2605: p_module_type => 'JSP',
2606: p_organization_id => p_x_ahl_mtltxn_rec.Organization_Id,
2607: p_transaction_number => 2004,
2608: p_col_trigger_value => fnd_profile.value('AHL_MRB_DISP_PLAN_TYPE'),
2609: x_return_status => l_return_status,
2610: x_msg_count => l_msg_count,
2611: x_msg_data => l_msg_data,
2612: x_plan_id => l_plan_id
3455:
3456: BEGIN
3457:
3458:
3459: --p_srvc_rec.TYPE_ID := FND_PROFILE.value(C_AHL_DEF_SR_TYPE);
3460: p_srvc_rec.SUMMARY := p_x_ahl_mtltxn_rec.SR_SUMMARY;
3461: --p_srvc_rec.CONTACT_TYPE := 'EMPLOYEE';
3462: p_srvc_rec.PROBLEM_CODE := p_x_ahl_mtltxn_rec.Problem_Code;
3463: p_srvc_rec.VISIT_ID := p_x_ahl_mtltxn_rec.Target_Visit_Id;
3460: p_srvc_rec.SUMMARY := p_x_ahl_mtltxn_rec.SR_SUMMARY;
3461: --p_srvc_rec.CONTACT_TYPE := 'EMPLOYEE';
3462: p_srvc_rec.PROBLEM_CODE := p_x_ahl_mtltxn_rec.Problem_Code;
3463: p_srvc_rec.VISIT_ID := p_x_ahl_mtltxn_rec.Target_Visit_Id;
3464: --p_srvc_rec.DURATION := FND_PROFILE.value(C_AHL_DEF_TASK_EST_DURATION);
3465: p_srvc_rec.INSTANCE_ID := p_item_instance_id;
3466: p_srvc_rec.ORIGINATING_WO_ID := p_x_ahl_mtltxn_rec.Workorder_Id;
3467: p_srvc_rec.OPERATION_TYPE := 'CREATE';
3468: p_srvc_rec.source_program_code := 'AHL_NONROUTINE';
5815: -- initialize status to success.
5816: x_return_status := FND_API.G_RET_STS_SUCCESS;
5817:
5818: -- set mfg_organization_id profile - bug# 6010795.
5819: fnd_profile.put('MFG_ORGANIZATION_ID', p_organization_id);
5820:
5821: l_mti_seglist := p_x_mti_seglist;
5822:
5823: fnd_flex_key_api.set_session_mode('seed_data');
5834: -- find segment delimiter
5835: l_delim := l_ffstru.segment_separator;
5836:
5837: IF G_DEBUG='Y' THEN
5838: AHL_DEBUG_PUB.DEBUG('Before Loc Seg validate:Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );
5839: END IF;
5840:
5841: -- validate locator segments.
5842: l_valid_flag := fnd_flex_keyval.validate_segs(