[Home] [Help]
2: /* $Header: AHLVMTXB.pls 120.42.12020000.3 2012/12/07 00:49:22 sareepar 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: -- pdoki added for Bug 9164678
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
666: END IF;
667:
668: IF(p_x_ahl_mtltxn_rec.recepient_id IS NULL OR p_x_ahl_mtltxn_rec.recepient_id = FND_API.G_MISS_NUM)
669: THEN
670: IF(NVL(FND_PROFILE.VALUE('AHL_PRD_MTX_RECEPIENT'),'N')='Y')
671: THEN
672: IF (p_x_ahl_mtltxn_rec.Transaction_Type_Id = WIP_CONSTANTS.RETCOMP_TYPE)
673: THEN
674: FND_MESSAGE.Set_Name('AHL','AHL_PRD_MTX_PERSON_MANDATORY2');
1357: IF (p_x_ahl_mtltxn_tbl(i).locator_segments IS NOT NULL AND
1358: p_x_ahl_mtltxn_tbl(i).locator_id IS NULL) THEN
1359:
1360: IF G_DEBUG='Y' THEN
1361: AHL_DEBUG_PUB.DEBUG('Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );
1362: END IF;
1363:
1364: l_valid_flag := fnd_flex_keyval.validate_segs(
1365: operation => 'FIND_COMBINATION'
2094: (
2095: SELECT 1
2096: FROM CS_SR_PROB_CODE_MAPPING_DETAIL
2097: WHERE
2098: INCIDENT_TYPE_ID = FND_PROFILE.VALUE('AHL_PRD_SR_TYPE') AND
2099: TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))
2100: )
2101: )
2102: OR
2105: (
2106: SELECT 1
2107: FROM CS_SR_PROB_CODE_MAPPING_DETAIL
2108: WHERE
2109: INCIDENT_TYPE_ID = FND_PROFILE.VALUE('AHL_PRD_SR_TYPE') AND
2110: PROBLEM_CODE = p_problem_code AND
2111: TRUNC(SYSDATE) BETWEEN TRUNC(NVL(START_DATE_ACTIVE,SYSDATE)) AND TRUNC(NVL(END_DATE_ACTIVE,SYSDATE))
2112: )
2113: )
2993: p_default => FND_API.G_FALSE,
2994: p_module_type => 'JSP',
2995: p_organization_id => p_x_ahl_mtltxn_rec.Organization_Id,
2996: p_transaction_number => 2004,
2997: p_col_trigger_value => fnd_profile.value('AHL_MRB_DISP_PLAN_TYPE'),
2998: x_return_status => l_return_status,
2999: x_msg_count => l_msg_count,
3000: x_msg_data => l_msg_data,
3001: x_plan_id => l_plan_id
4032:
4033: BEGIN
4034:
4035:
4036: --p_srvc_rec.TYPE_ID := FND_PROFILE.value(C_AHL_DEF_SR_TYPE);
4037: p_srvc_rec.SUMMARY := p_x_ahl_mtltxn_rec.SR_SUMMARY;
4038: --p_srvc_rec.CONTACT_TYPE := 'EMPLOYEE';
4039: p_srvc_rec.PROBLEM_CODE := p_x_ahl_mtltxn_rec.Problem_Code;
4040: p_srvc_rec.VISIT_ID := p_x_ahl_mtltxn_rec.Target_Visit_Id;
4037: p_srvc_rec.SUMMARY := p_x_ahl_mtltxn_rec.SR_SUMMARY;
4038: --p_srvc_rec.CONTACT_TYPE := 'EMPLOYEE';
4039: p_srvc_rec.PROBLEM_CODE := p_x_ahl_mtltxn_rec.Problem_Code;
4040: p_srvc_rec.VISIT_ID := p_x_ahl_mtltxn_rec.Target_Visit_Id;
4041: --p_srvc_rec.DURATION := FND_PROFILE.value(C_AHL_DEF_TASK_EST_DURATION);
4042: p_srvc_rec.INSTANCE_ID := p_item_instance_id;
4043: p_srvc_rec.ORIGINATING_WO_ID := p_x_ahl_mtltxn_rec.Workorder_Id;
4044: p_srvc_rec.OPERATION_TYPE := 'CREATE';
4045: p_srvc_rec.source_program_code := 'AHL_NONROUTINE';
7560: -- initialize status to success.
7561: x_return_status := FND_API.G_RET_STS_SUCCESS;
7562:
7563: -- set mfg_organization_id profile - bug# 6010795.
7564: fnd_profile.put('MFG_ORGANIZATION_ID', p_organization_id);
7565:
7566: l_mti_seglist := p_x_mti_seglist;
7567:
7568: fnd_flex_key_api.set_session_mode('seed_data');
7579: -- find segment delimiter
7580: l_delim := l_ffstru.segment_separator;
7581:
7582: IF G_DEBUG='Y' THEN
7583: AHL_DEBUG_PUB.DEBUG('Before Loc Seg validate:Profile mfg_organization_id:' || fnd_profile.value('MFG_ORGANIZATION_ID') );
7584: END IF;
7585:
7586: -- validate locator segments.
7587: l_valid_flag := fnd_flex_keyval.validate_segs(