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_UMP_SR_PVT dependencies on FND_MESSAGE

Line 315: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');

311:
312: --Raising an error if the request id null
313: IF (l_request_id IS NULL OR l_request_id = FND_API.G_MISS_NUM) THEN
314: x_return_status := FND_API.G_RET_STS_ERROR;
315: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');
316: FND_MSG_PUB.add;
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
319:

Line 326: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_INCIDENT_ID');

322: FETCH validate_incident_id into l_incident_id;
323:
324: --Raise an error if the incident id is not valid.
325: IF (validate_incident_id%NOTFOUND) THEN
326: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_INCIDENT_ID');
327: fnd_message.set_token('INCIDENT_ID', l_request_id, false);
328: FND_MSG_PUB.add;
329: CLOSE validate_instance;
330: RAISE FND_API.G_EXC_ERROR;

Line 327: fnd_message.set_token('INCIDENT_ID', l_request_id, false);

323:
324: --Raise an error if the incident id is not valid.
325: IF (validate_incident_id%NOTFOUND) THEN
326: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_INCIDENT_ID');
327: fnd_message.set_token('INCIDENT_ID', l_request_id, false);
328: FND_MSG_PUB.add;
329: CLOSE validate_instance;
330: RAISE FND_API.G_EXC_ERROR;
331: END IF;

Line 363: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_PROF_NOT_SET');

359:
360: --Set the return status to an error and raise an error message if the return status is an error.
361: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
362: x_return_status := FND_API.G_RET_STS_ERROR;
363: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_PROF_NOT_SET');
364: FND_MSG_PUB.add;
365: RAISE FND_API.G_EXC_ERROR;
366: END IF;
367:

Line 371: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');

367:
368: --Set the return status to an error and raise an error message if the application code returned is not AHL
369: IF (l_appln_code <> 'AHL') THEN
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
372: FND_MESSAGE.set_token('TASK', l_name, false);
373: FND_MSG_PUB.add;
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;

Line 372: FND_MESSAGE.set_token('TASK', l_name, false);

368: --Set the return status to an error and raise an error message if the application code returned is not AHL
369: IF (l_appln_code <> 'AHL') THEN
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
372: FND_MESSAGE.set_token('TASK', l_name, false);
373: FND_MSG_PUB.add;
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376:

Line 383: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INVALID_STATUS_CODE');

379: --******************************
380: -- JR: Modified on 10/29/2003 (Using Status Id instead of Status Code)
381: -- Raise an error if the status is PLANNED.
382: IF (l_status_id = G_SR_PLANNED_STATUS_ID) THEN
383: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INVALID_STATUS_CODE');
384: FND_MSG_PUB.add;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:

Line 394: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INSTANCE_MANDATORY');

390: --******************************
391: --Raise an error if the item instance id null
392: IF (l_customer_product_id IS NULL OR l_customer_product_id = FND_API.G_MISS_NUM) THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INSTANCE_MANDATORY');
395: FND_MSG_PUB.add;
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398:

Line 404: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE');

400: OPEN validate_instance(l_customer_product_id);
401: FETCH validate_instance into l_instance_id, l_instance_number, l_active_end_date;
402: --Raise an error if the instance is not a valid CSI Instance
403: IF (validate_instance%NOTFOUND) THEN
404: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE');
405: fnd_message.set_token('CSI_INSTANCE_ID', l_customer_product_id, false);
406: FND_MSG_PUB.add;
407: CLOSE validate_instance;
408: RAISE FND_API.G_EXC_ERROR;

Line 405: fnd_message.set_token('CSI_INSTANCE_ID', l_customer_product_id, false);

401: FETCH validate_instance into l_instance_id, l_instance_number, l_active_end_date;
402: --Raise an error if the instance is not a valid CSI Instance
403: IF (validate_instance%NOTFOUND) THEN
404: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE');
405: fnd_message.set_token('CSI_INSTANCE_ID', l_customer_product_id, false);
406: FND_MSG_PUB.add;
407: CLOSE validate_instance;
408: RAISE FND_API.G_EXC_ERROR;
409: END IF;

Line 413: fnd_message.set_name('AHL', 'AHL_UMP_INACTIVE_INSTANCE');

409: END IF;
410:
411: --Raise an error if the instance is inactive.
412: IF ( l_active_end_date IS NOT NULL AND l_active_end_date <= SYSDATE ) THEN
413: fnd_message.set_name('AHL', 'AHL_UMP_INACTIVE_INSTANCE');
414: fnd_message.set_token('INSTANCE_NUMBER', l_instance_number, false);
415: FND_MSG_PUB.add;
416: CLOSE validate_instance;
417: RAISE FND_API.G_EXC_ERROR;

Line 414: fnd_message.set_token('INSTANCE_NUMBER', l_instance_number, false);

410:
411: --Raise an error if the instance is inactive.
412: IF ( l_active_end_date IS NOT NULL AND l_active_end_date <= SYSDATE ) THEN
413: fnd_message.set_name('AHL', 'AHL_UMP_INACTIVE_INSTANCE');
414: fnd_message.set_token('INSTANCE_NUMBER', l_instance_number, false);
415: FND_MSG_PUB.add;
416: CLOSE validate_instance;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;

Line 440: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_NR_UNIT_QUAR_INV');

436: -- for all other cases treat the NR as being created for IB component only, i.e. no unit info
437: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_hdr_id);
438: IF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
439: THEN
440: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_NR_UNIT_QUAR_INV');
441: FND_MSG_PUB.ADD;
442: RAISE FND_API.G_EXC_ERROR;
443: ELSIF (l_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE'))
444: THEN

Line 654: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');

650: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
651: x_return_status => x_return_status);
652:
653: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
654: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');
655: FND_MSG_PUB.ADD;
656: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
657: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
658: END IF;

Line 661: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');

657: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
658: END IF;
659: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
660: ELSIF(l_appln_code IS NULL OR (l_appln_code <> G_APP_MODULE)) THEN
661: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');
662: FND_MSG_PUB.ADD;
663: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
664: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
665: END IF;

Line 814: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');

810: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
811: x_return_status => x_return_status);
812:
813: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
814: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');
815: FND_MSG_PUB.ADD;
816: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
817: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
818: END IF;

Line 821: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');

817: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
818: END IF;
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF(l_appln_code IS NULL OR (l_appln_code <> G_APP_MODULE)) THEN
821: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');
822: FND_MSG_PUB.ADD;
823: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
824: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
825: END IF;

Line 845: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_SR_TBL_EMPTY');

841: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Completed Validating the Request');
842: END IF;
843:
844: IF (p_x_sr_mr_association_tbl.COUNT = 0) THEN
845: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_SR_TBL_EMPTY');
846: FND_MSG_PUB.ADD;
847: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
849: END IF;

Line 991: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_NUM_NULL');

987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
988: END IF;
989:
990: IF(p_x_request_id IS NULL AND p_request_number IS NULL) THEN
991: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_NUM_NULL');
992: FND_MSG_PUB.ADD;
993: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
995: END IF;

Line 998: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_NULL');

994: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
995: END IF;
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (p_object_version_number IS NULL) THEN
998: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_NULL');
999: FND_MSG_PUB.ADD;
1000: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1001: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1002: END IF;

Line 1014: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_INVALID');

1010: l_closed_flag,
1011: x_sr_instance_id, -- OUT Parameter
1012: x_sr_exp_resol_date; -- OUT Parameter
1013: IF get_request_dtls_csr%NOTFOUND THEN
1014: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_INVALID');
1015: FND_MESSAGE.Set_Token('ID', p_x_request_id);
1016: FND_MESSAGE.Set_Token('OVN', p_object_version_number);
1017: FND_MSG_PUB.ADD;
1018: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1015: FND_MESSAGE.Set_Token('ID', p_x_request_id);

1011: x_sr_instance_id, -- OUT Parameter
1012: x_sr_exp_resol_date; -- OUT Parameter
1013: IF get_request_dtls_csr%NOTFOUND THEN
1014: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_INVALID');
1015: FND_MESSAGE.Set_Token('ID', p_x_request_id);
1016: FND_MESSAGE.Set_Token('OVN', p_object_version_number);
1017: FND_MSG_PUB.ADD;
1018: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1016: FND_MESSAGE.Set_Token('OVN', p_object_version_number);

1012: x_sr_exp_resol_date; -- OUT Parameter
1013: IF get_request_dtls_csr%NOTFOUND THEN
1014: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_INVALID');
1015: FND_MESSAGE.Set_Token('ID', p_x_request_id);
1016: FND_MESSAGE.Set_Token('OVN', p_object_version_number);
1017: FND_MSG_PUB.ADD;
1018: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1019: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1020: END IF;

Line 1028: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_CLOSED');

1024: CLOSE get_request_dtls_csr;
1025: END IF;
1026:
1027: IF(l_closed_flag = G_YES_FLAG) THEN
1028: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_CLOSED');
1029: FND_MSG_PUB.ADD;
1030: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1031: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1032: END IF;

Line 1043: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');

1039: Please refer the design document for more information.
1040:
1041: -- JR: Modified on 10/29/2003 (Using Status Id instead of Status Code)
1042: IF (l_sr_status_id = G_SR_PLANNED_STATUS_ID) THEN
1043: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
1044: FND_MSG_PUB.ADD;
1045: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1046: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1047: END IF;

Line 1054: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NO_UE_FOR_REQ');

1050: */
1051: OPEN get_ue_dtls_csr(p_request_id => p_x_request_id);
1052: FETCH get_ue_dtls_csr INTO x_sr_ue_id; -- OUT Parameter
1053: IF (get_ue_dtls_csr%NOTFOUND) THEN
1054: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NO_UE_FOR_REQ');
1055: FND_MESSAGE.Set_Token('ID', p_x_request_id);
1056: FND_MSG_PUB.ADD;
1057: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1058: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1055: FND_MESSAGE.Set_Token('ID', p_x_request_id);

1051: OPEN get_ue_dtls_csr(p_request_id => p_x_request_id);
1052: FETCH get_ue_dtls_csr INTO x_sr_ue_id; -- OUT Parameter
1053: IF (get_ue_dtls_csr%NOTFOUND) THEN
1054: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NO_UE_FOR_REQ');
1055: FND_MESSAGE.Set_Token('ID', p_x_request_id);
1056: FND_MSG_PUB.ADD;
1057: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1058: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1059: END IF;

Line 1073: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ASGND_TO_VISIT');

1069: Please refer the design document for more information.
1070: OPEN get_tasks_for_ue_csr(p_ue_id => x_sr_ue_id);
1071: FETCH get_tasks_for_ue_csr INTO l_dummy;
1072: IF (get_tasks_for_ue_csr%FOUND) THEN
1073: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ASGND_TO_VISIT');
1074: FND_MSG_PUB.ADD;
1075: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1076: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1077: END IF;

Line 1161: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_OPR_INVALID');

1157: END IF;
1158: FOR i in p_x_sr_mr_association_tbl.FIRST .. p_x_sr_mr_association_tbl.LAST LOOP
1159: l_valid := true;
1160: IF (p_x_sr_mr_association_tbl(i).OPERATION_FLAG NOT IN (G_OPR_CREATE, G_OPR_DELETE)) THEN
1161: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_OPR_INVALID');
1162: FND_MESSAGE.Set_Token('OPR_FLAG', p_x_sr_mr_association_tbl(i).OPERATION_FLAG);
1163: FND_MESSAGE.Set_Token('INDEX', i);
1164: FND_MSG_PUB.ADD;
1165: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1162: FND_MESSAGE.Set_Token('OPR_FLAG', p_x_sr_mr_association_tbl(i).OPERATION_FLAG);

1158: FOR i in p_x_sr_mr_association_tbl.FIRST .. p_x_sr_mr_association_tbl.LAST LOOP
1159: l_valid := true;
1160: IF (p_x_sr_mr_association_tbl(i).OPERATION_FLAG NOT IN (G_OPR_CREATE, G_OPR_DELETE)) THEN
1161: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_OPR_INVALID');
1162: FND_MESSAGE.Set_Token('OPR_FLAG', p_x_sr_mr_association_tbl(i).OPERATION_FLAG);
1163: FND_MESSAGE.Set_Token('INDEX', i);
1164: FND_MSG_PUB.ADD;
1165: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1163: FND_MESSAGE.Set_Token('INDEX', i);

1159: l_valid := true;
1160: IF (p_x_sr_mr_association_tbl(i).OPERATION_FLAG NOT IN (G_OPR_CREATE, G_OPR_DELETE)) THEN
1161: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_OPR_INVALID');
1162: FND_MESSAGE.Set_Token('OPR_FLAG', p_x_sr_mr_association_tbl(i).OPERATION_FLAG);
1163: FND_MESSAGE.Set_Token('INDEX', i);
1164: FND_MSG_PUB.ADD;
1165: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1166: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1167: END IF;

Line 1174: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_ID_NULL');

1170: -- Delete Operation
1171: Get_MR_UnitEffectivity(p_sr_ue_id => p_sr_ue_id,
1172: p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1173: IF (p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID IS NULL) THEN
1174: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_ID_NULL');
1175: FND_MESSAGE.Set_Token('INDEX', i);
1176: FND_MSG_PUB.ADD;
1177: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1175: FND_MESSAGE.Set_Token('INDEX', i);

1171: Get_MR_UnitEffectivity(p_sr_ue_id => p_sr_ue_id,
1172: p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1173: IF (p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID IS NULL) THEN
1174: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_ID_NULL');
1175: FND_MESSAGE.Set_Token('INDEX', i);
1176: FND_MSG_PUB.ADD;
1177: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1178: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1179: END IF;

Line 1182: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_NULL');

1178: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1179: END IF;
1180: l_valid := false;
1181: ELSIF (p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER IS NULL) THEN
1182: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_NULL');
1183: FND_MESSAGE.Set_Token('INDEX', i);
1184: FND_MSG_PUB.ADD;
1185: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1186: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1183: FND_MESSAGE.Set_Token('INDEX', i);

1179: END IF;
1180: l_valid := false;
1181: ELSIF (p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER IS NULL) THEN
1182: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_NULL');
1183: FND_MESSAGE.Set_Token('INDEX', i);
1184: FND_MSG_PUB.ADD;
1185: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1186: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1187: END IF;

Line 1195: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_INVALID');

1191: p_mr_ue_ovn => p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER,
1192: p_sr_ue_id => p_sr_ue_id);
1193: FETCH validate_mr_ue_csr INTO l_dummy;
1194: IF (validate_mr_ue_csr%NOTFOUND) THEN
1195: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_INVALID');
1196: FND_MESSAGE.Set_Token('UE_ID', p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1197: FND_MESSAGE.Set_Token('OVN', p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER);
1198: FND_MESSAGE.Set_Token('INDEX', i);
1199: FND_MSG_PUB.ADD;

Line 1196: FND_MESSAGE.Set_Token('UE_ID', p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);

1192: p_sr_ue_id => p_sr_ue_id);
1193: FETCH validate_mr_ue_csr INTO l_dummy;
1194: IF (validate_mr_ue_csr%NOTFOUND) THEN
1195: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_INVALID');
1196: FND_MESSAGE.Set_Token('UE_ID', p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1197: FND_MESSAGE.Set_Token('OVN', p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER);
1198: FND_MESSAGE.Set_Token('INDEX', i);
1199: FND_MSG_PUB.ADD;
1200: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1197: FND_MESSAGE.Set_Token('OVN', p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER);

1193: FETCH validate_mr_ue_csr INTO l_dummy;
1194: IF (validate_mr_ue_csr%NOTFOUND) THEN
1195: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_INVALID');
1196: FND_MESSAGE.Set_Token('UE_ID', p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1197: FND_MESSAGE.Set_Token('OVN', p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER);
1198: FND_MESSAGE.Set_Token('INDEX', i);
1199: FND_MSG_PUB.ADD;
1200: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1201: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1198: FND_MESSAGE.Set_Token('INDEX', i);

1194: IF (validate_mr_ue_csr%NOTFOUND) THEN
1195: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_INVALID');
1196: FND_MESSAGE.Set_Token('UE_ID', p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1197: FND_MESSAGE.Set_Token('OVN', p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER);
1198: FND_MESSAGE.Set_Token('INDEX', i);
1199: FND_MSG_PUB.ADD;
1200: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1201: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1202: END IF;

Line 1220: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');

1216: ELSE
1217: -- Create Operation
1218: Get_New_Asso_Val_To_Id(p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1219: IF (p_x_sr_mr_association_tbl(i).MR_HEADER_ID IS NULL) THEN
1220: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1221: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1222: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1223: FND_MESSAGE.Set_Token('INDEX', i);
1224: FND_MSG_PUB.ADD;

Line 1221: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);

1217: -- Create Operation
1218: Get_New_Asso_Val_To_Id(p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1219: IF (p_x_sr_mr_association_tbl(i).MR_HEADER_ID IS NULL) THEN
1220: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1221: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1222: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1223: FND_MESSAGE.Set_Token('INDEX', i);
1224: FND_MSG_PUB.ADD;
1225: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1222: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);

1218: Get_New_Asso_Val_To_Id(p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1219: IF (p_x_sr_mr_association_tbl(i).MR_HEADER_ID IS NULL) THEN
1220: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1221: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1222: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1223: FND_MESSAGE.Set_Token('INDEX', i);
1224: FND_MSG_PUB.ADD;
1225: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1226: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1223: FND_MESSAGE.Set_Token('INDEX', i);

1219: IF (p_x_sr_mr_association_tbl(i).MR_HEADER_ID IS NULL) THEN
1220: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1221: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1222: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1223: FND_MESSAGE.Set_Token('INDEX', i);
1224: FND_MSG_PUB.ADD;
1225: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1226: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1227: END IF;

Line 1230: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NUM_INVALID');

1226: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1227: END IF;
1228: l_valid := false;
1229: ELSIF (p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID IS NULL) THEN
1230: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NUM_INVALID');
1231: FND_MESSAGE.Set_Token('INST_NUM', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_NUMBER);
1232: FND_MESSAGE.Set_Token('INDEX', i);
1233: FND_MSG_PUB.ADD;
1234: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1231: FND_MESSAGE.Set_Token('INST_NUM', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_NUMBER);

1227: END IF;
1228: l_valid := false;
1229: ELSIF (p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID IS NULL) THEN
1230: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NUM_INVALID');
1231: FND_MESSAGE.Set_Token('INST_NUM', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_NUMBER);
1232: FND_MESSAGE.Set_Token('INDEX', i);
1233: FND_MSG_PUB.ADD;
1234: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1232: FND_MESSAGE.Set_Token('INDEX', i);

1228: l_valid := false;
1229: ELSIF (p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID IS NULL) THEN
1230: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NUM_INVALID');
1231: FND_MESSAGE.Set_Token('INST_NUM', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_NUMBER);
1232: FND_MESSAGE.Set_Token('INDEX', i);
1233: FND_MSG_PUB.ADD;
1234: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1235: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1236: END IF;

Line 1244: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_ID_INVALID');

1240: OPEN validate_mr_id_csr(p_mr_header_id => p_x_sr_mr_association_tbl(i).MR_HEADER_ID);
1241: FETCH validate_mr_id_csr INTO p_x_sr_mr_association_tbl(i).MR_TITLE, l_program_type_code;
1242: IF (validate_mr_id_csr%NOTFOUND) THEN
1243: CLOSE validate_mr_id_csr;
1244: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_ID_INVALID');
1245: FND_MESSAGE.Set_Token('MR_ID', p_x_sr_mr_association_tbl(i).MR_HEADER_ID);
1246: FND_MESSAGE.Set_Token('INDEX', i);
1247: FND_MSG_PUB.ADD;
1248: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1245: FND_MESSAGE.Set_Token('MR_ID', p_x_sr_mr_association_tbl(i).MR_HEADER_ID);

1241: FETCH validate_mr_id_csr INTO p_x_sr_mr_association_tbl(i).MR_TITLE, l_program_type_code;
1242: IF (validate_mr_id_csr%NOTFOUND) THEN
1243: CLOSE validate_mr_id_csr;
1244: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_ID_INVALID');
1245: FND_MESSAGE.Set_Token('MR_ID', p_x_sr_mr_association_tbl(i).MR_HEADER_ID);
1246: FND_MESSAGE.Set_Token('INDEX', i);
1247: FND_MSG_PUB.ADD;
1248: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1249: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1246: FND_MESSAGE.Set_Token('INDEX', i);

1242: IF (validate_mr_id_csr%NOTFOUND) THEN
1243: CLOSE validate_mr_id_csr;
1244: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_ID_INVALID');
1245: FND_MESSAGE.Set_Token('MR_ID', p_x_sr_mr_association_tbl(i).MR_HEADER_ID);
1246: FND_MESSAGE.Set_Token('INDEX', i);
1247: FND_MSG_PUB.ADD;
1248: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1249: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1250: END IF;

Line 1259: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_ID_INVALID');

1255: OPEN validate_instance_id_csr(p_csi_instance_id => p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1256: FETCH validate_instance_id_csr INTO p_x_sr_mr_association_tbl(i).CSI_INSTANCE_NUMBER;
1257: IF (validate_instance_id_csr%NOTFOUND) THEN
1258: CLOSE validate_instance_id_csr;
1259: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_ID_INVALID');
1260: FND_MESSAGE.Set_Token('INST_ID', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1261: FND_MESSAGE.Set_Token('INDEX', i);
1262: FND_MSG_PUB.ADD;
1263: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1260: FND_MESSAGE.Set_Token('INST_ID', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);

1256: FETCH validate_instance_id_csr INTO p_x_sr_mr_association_tbl(i).CSI_INSTANCE_NUMBER;
1257: IF (validate_instance_id_csr%NOTFOUND) THEN
1258: CLOSE validate_instance_id_csr;
1259: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_ID_INVALID');
1260: FND_MESSAGE.Set_Token('INST_ID', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1261: FND_MESSAGE.Set_Token('INDEX', i);
1262: FND_MSG_PUB.ADD;
1263: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1264: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1261: FND_MESSAGE.Set_Token('INDEX', i);

1257: IF (validate_instance_id_csr%NOTFOUND) THEN
1258: CLOSE validate_instance_id_csr;
1259: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_ID_INVALID');
1260: FND_MESSAGE.Set_Token('INST_ID', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1261: FND_MESSAGE.Set_Token('INDEX', i);
1262: FND_MSG_PUB.ADD;
1263: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1264: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1265: END IF;

Line 1275: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');

1271: OPEN validate_sr_mr_intance_rel(c_mr_instance_id => p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID,c_sr_instance_id => p_sr_instance_id);
1272: FETCH validate_sr_mr_intance_rel INTO l_flag_sr_mr_inst;
1273: IF (validate_sr_mr_intance_rel%NOTFOUND) THEN
1274: CLOSE validate_sr_mr_intance_rel;
1275: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1276: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1277: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1278: FND_MESSAGE.Set_Token('INDEX', i);
1279: FND_MSG_PUB.ADD;

Line 1276: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);

1272: FETCH validate_sr_mr_intance_rel INTO l_flag_sr_mr_inst;
1273: IF (validate_sr_mr_intance_rel%NOTFOUND) THEN
1274: CLOSE validate_sr_mr_intance_rel;
1275: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1276: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1277: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1278: FND_MESSAGE.Set_Token('INDEX', i);
1279: FND_MSG_PUB.ADD;
1280: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1277: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);

1273: IF (validate_sr_mr_intance_rel%NOTFOUND) THEN
1274: CLOSE validate_sr_mr_intance_rel;
1275: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1276: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1277: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1278: FND_MESSAGE.Set_Token('INDEX', i);
1279: FND_MSG_PUB.ADD;
1280: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1278: FND_MESSAGE.Set_Token('INDEX', i);

1274: CLOSE validate_sr_mr_intance_rel;
1275: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1276: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1277: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1278: FND_MESSAGE.Set_Token('INDEX', i);
1279: FND_MSG_PUB.ADD;
1280: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1282: END IF;

Line 1297: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_FAILED');

1293: p_item_instance_id => p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID,
1294: p_mr_header_id => p_x_sr_mr_association_tbl(i).MR_HEADER_ID,
1295: x_applicable_mr_tbl => l_applicable_mr_tbl);
1296: IF (l_temp_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1297: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_FAILED');
1298: FND_MESSAGE.Set_Token('INDEX', i);
1299: FND_MSG_PUB.ADD;
1300: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1301: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1298: FND_MESSAGE.Set_Token('INDEX', i);

1294: p_mr_header_id => p_x_sr_mr_association_tbl(i).MR_HEADER_ID,
1295: x_applicable_mr_tbl => l_applicable_mr_tbl);
1296: IF (l_temp_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1297: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_FAILED');
1298: FND_MESSAGE.Set_Token('INDEX', i);
1299: FND_MSG_PUB.ADD;
1300: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1301: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1302: END IF;

Line 1316: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_NOT_APPLCBL');

1312: END IF; -- Applicable
1313: END LOOP; -- All Applicable MRs
1314: END IF; -- Table Count > 0
1315: IF (l_mr_applicable = false) THEN
1316: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_NOT_APPLCBL');
1317: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));
1318: FND_MSG_PUB.ADD;
1319: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1320: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1317: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));

1313: END LOOP; -- All Applicable MRs
1314: END IF; -- Table Count > 0
1315: IF (l_mr_applicable = false) THEN
1316: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_NOT_APPLCBL');
1317: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));
1318: FND_MSG_PUB.ADD;
1319: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1320: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1321: END IF;

Line 1517: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_DUPLICATE_MR');

1513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Record ' || i || ' with MR Id ' ||
1514: p_x_sr_mr_association_tbl(i).MR_HEADER_ID || ' and Instance Id ' ||
1515: p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID || ' is a Duplicate.');
1516: END IF;
1517: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_DUPLICATE_MR');
1518: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));
1519: FND_MSG_PUB.ADD;
1520: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 1518: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));

1514: p_x_sr_mr_association_tbl(i).MR_HEADER_ID || ' and Instance Id ' ||
1515: p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID || ' is a Duplicate.');
1516: END IF;
1517: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_DUPLICATE_MR');
1518: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));
1519: FND_MSG_PUB.ADD;
1520: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1521: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1522: END IF;

Line 1533: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');

1529: --pdoki added for ER 9583373
1530: OPEN Chk_UE_Init_Due (p_x_sr_mr_association_tbl(i).MR_HEADER_ID, p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1531: FETCH Chk_UE_Init_Due INTO l_dummy;
1532: IF (Chk_UE_Init_Due%FOUND) THEN
1533: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
1534: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_x_sr_mr_association_tbl(i).MR_TITLE);
1535: FND_MSG_PUB.ADD;
1536: END IF;
1537: CLOSE Chk_UE_Init_Due;

Line 1534: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_x_sr_mr_association_tbl(i).MR_TITLE);

1530: OPEN Chk_UE_Init_Due (p_x_sr_mr_association_tbl(i).MR_HEADER_ID, p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1531: FETCH Chk_UE_Init_Due INTO l_dummy;
1532: IF (Chk_UE_Init_Due%FOUND) THEN
1533: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
1534: FND_MESSAGE.SET_TOKEN('MR_TITLE',p_x_sr_mr_association_tbl(i).MR_TITLE);
1535: FND_MSG_PUB.ADD;
1536: END IF;
1537: CLOSE Chk_UE_Init_Due;
1538:

Line 1631: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_ORIGINWO_UPD_FAILED');

1627:
1628: EXCEPTION
1629:
1630: WHEN OTHERS THEN
1631: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_ORIGINWO_UPD_FAILED');
1632: Fnd_Msg_Pub.ADD;
1633: END;
1634: END IF;
1635: -- End Changes ER # 6123671

Line 2055: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GRP_MR_FAILED');

2051: x_msg_data => l_temp_msg_data);
2052: IF NOT (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2053: p_x_valid_flag := false;
2054: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
2055: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GRP_MR_FAILED');
2056: FND_MESSAGE.Set_Token('MR_TITLE', l_curr_mr_title);
2057: FND_MSG_PUB.ADD;
2058: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2059: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 2056: FND_MESSAGE.Set_Token('MR_TITLE', l_curr_mr_title);

2052: IF NOT (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2053: p_x_valid_flag := false;
2054: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
2055: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GRP_MR_FAILED');
2056: FND_MESSAGE.Set_Token('MR_TITLE', l_curr_mr_title);
2057: FND_MSG_PUB.ADD;
2058: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2059: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2060: END IF;

Line 2098: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GROUP_DUP_MR');

2094: -- At least one duplicate found
2095: CLOSE get_duplicate_mrs_csr;
2096: l_dup_mr_title := Get_MR_Title_From_MR_Id(l_duplicate_mr_id);
2097: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
2098: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GROUP_DUP_MR');
2099: FND_MESSAGE.Set_Token('NEW_MR', l_curr_mr_title);
2100: FND_MESSAGE.Set_Token('DUP_MR', l_dup_mr_title);
2101: FND_MSG_PUB.ADD;
2102: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2099: FND_MESSAGE.Set_Token('NEW_MR', l_curr_mr_title);

2095: CLOSE get_duplicate_mrs_csr;
2096: l_dup_mr_title := Get_MR_Title_From_MR_Id(l_duplicate_mr_id);
2097: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
2098: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GROUP_DUP_MR');
2099: FND_MESSAGE.Set_Token('NEW_MR', l_curr_mr_title);
2100: FND_MESSAGE.Set_Token('DUP_MR', l_dup_mr_title);
2101: FND_MSG_PUB.ADD;
2102: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2103: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 2100: FND_MESSAGE.Set_Token('DUP_MR', l_dup_mr_title);

2096: l_dup_mr_title := Get_MR_Title_From_MR_Id(l_duplicate_mr_id);
2097: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
2098: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GROUP_DUP_MR');
2099: FND_MESSAGE.Set_Token('NEW_MR', l_curr_mr_title);
2100: FND_MESSAGE.Set_Token('DUP_MR', l_dup_mr_title);
2101: FND_MSG_PUB.ADD;
2102: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2103: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2104: END IF;

Line 2128: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');

2124: INTO l_mr_title
2125: FROM AHL_MR_HEADERS_B
2126: WHERE mr_header_id = mr_rel_rec.RELATED_MR_HEADER_ID;
2127:
2128: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
2129: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
2130: FND_MSG_PUB.ADD;
2131: p_x_valid_flag := false;
2132: CLOSE Chk_UE_Init_Due;

Line 2129: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);

2125: FROM AHL_MR_HEADERS_B
2126: WHERE mr_header_id = mr_rel_rec.RELATED_MR_HEADER_ID;
2127:
2128: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
2129: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
2130: FND_MSG_PUB.ADD;
2131: p_x_valid_flag := false;
2132: CLOSE Chk_UE_Init_Due;
2133: RETURN; -- No need to process this Group MR further

Line 2560: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_NULL');

2556: END IF;
2557:
2558: -- Ensure that request id is not null
2559: IF(CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id IS NULL) THEN
2560: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_NULL');
2561: FND_MSG_PUB.ADD;
2562: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2563: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2564: END IF;

Line 2573: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');

2569: OPEN check_request_exists_csr;
2570: FETCH check_request_exists_csr INTO l_dummy;
2571: IF(check_request_exists_csr%NOTFOUND) THEN
2572: CLOSE check_request_exists_csr;
2573: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2574: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2575: FND_MSG_PUB.ADD;
2576: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 2574: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);

2570: FETCH check_request_exists_csr INTO l_dummy;
2571: IF(check_request_exists_csr%NOTFOUND) THEN
2572: CLOSE check_request_exists_csr;
2573: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2574: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2575: FND_MSG_PUB.ADD;
2576: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2578: END IF;

Line 2590: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');

2586: OPEN get_ue_dtls_csr;
2587: FETCH get_ue_dtls_csr INTO x_sr_ue_id, x_sr_ue_ovn, x_defer_from_ue_id;
2588: IF (get_ue_dtls_csr%NOTFOUND) THEN
2589: CLOSE get_ue_dtls_csr;
2590: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2591: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2592: FND_MSG_PUB.ADD;
2593: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2594: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 2591: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);

2587: FETCH get_ue_dtls_csr INTO x_sr_ue_id, x_sr_ue_ovn, x_defer_from_ue_id;
2588: IF (get_ue_dtls_csr%NOTFOUND) THEN
2589: CLOSE get_ue_dtls_csr;
2590: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2591: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2592: FND_MSG_PUB.ADD;
2593: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2594: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2595: END IF;

Line 2641: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_CLOSED');

2637: END IF;
2638:
2639: -- Ensure that the SR is not closed
2640: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag = G_SR_CLOSED_FLAG) THEN
2641: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_CLOSED');
2642: FND_MSG_PUB.ADD;
2643: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2644: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2645: END IF;

Line 2659: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_DEFERRED');

2655: IF (p_defer_from_ue_id IS NOT NULL) THEN
2656: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2657: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'UE was deferred.');
2658: END IF;
2659: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_DEFERRED');
2660: FND_MSG_PUB.ADD;
2661: RAISE FND_API.G_EXC_ERROR;
2662: END IF;
2663: -- apattark end changes for bug #9166304

Line 2669: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ASGND_TO_VISIT');

2665: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2666: OPEN get_tasks_for_ue_csr;
2667: FETCH get_tasks_for_ue_csr INTO l_dummy;
2668: IF (get_tasks_for_ue_csr%FOUND) THEN
2669: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ASGND_TO_VISIT');
2670: FND_MSG_PUB.ADD;
2671: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2672: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2673: END IF;

Line 2680: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');

2676: -- to a visit is not possible
2677: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2678: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Odd case of originally CMRO type SR in Planned status but not assigned to a visit');
2679: END IF;
2680: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
2681: FND_MSG_PUB.ADD;
2682: END IF; -- tasks found
2683: CLOSE get_tasks_for_ue_csr;
2684: RAISE FND_API.G_EXC_ERROR;

Line 2713: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');

2709: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2710: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Non-CMRO to CMRO type conversion');
2711: END IF;
2712: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2713: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
2714: FND_MSG_PUB.ADD;
2715: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2716: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2717: END IF;

Line 2933: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NULL');

2929: x_instance_changed := false;
2930:
2931: IF (l_new_instance_id IS NULL) THEN
2932: p_x_valid_flag := false;
2933: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NULL');
2934: FND_MSG_PUB.ADD;
2935: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2936: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2937: END IF;

Line 2943: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_DEFERRED');

2939: -- Instance has changed: Validate
2940: --apattark begin changes for bug #9166304
2941: IF (p_defer_from_ue_id IS NOT NULL) THEN
2942: p_x_valid_flag := false;
2943: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_DEFERRED');
2944: FND_MSG_PUB.ADD;
2945: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2946: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2947: END IF;

Line 2952: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_CLOSED');

2948: END IF;
2949: --apattark end changes for bug #9166304
2950: IF (CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.status_flag = G_SR_CLOSED_FLAG) THEN
2951: p_x_valid_flag := false;
2952: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_CLOSED');
2953: FND_MSG_PUB.ADD;
2954: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2955: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2956: END IF;

Line 2960: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_PLANNED');

2956: END IF;
2957:
2958: ELSIF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2959: p_x_valid_flag := false;
2960: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_PLANNED');
2961: FND_MSG_PUB.ADD;
2962: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2963: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2964: END IF;

Line 2971: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_HAS_MRS');

2967: FETCH get_rel_count_csr INTO l_temp_count;
2968: CLOSE get_rel_count_csr;
2969: IF (l_temp_count > 0) THEN
2970: p_x_valid_flag := false;
2971: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_HAS_MRS');
2972: FND_MSG_PUB.ADD;
2973: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2974: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2975: END IF;

Line 3032: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_TASK_NOT_ACC');

3028: -- SR UE Assigned to a visit
3029: IF (p_old_ue_status IS NULL OR (p_old_ue_status NOT IN (G_UMP_ACCOMPLISHED_STATUS, G_UMP_TERMINATED_STATUS, G_UMP_MR_TERMINATE_STATUS))) THEN
3030: -- UE Neither accomplished nor terminated
3031: p_x_valid_flag := false;
3032: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_TASK_NOT_ACC');
3033: FND_MSG_PUB.ADD;
3034: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3035: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3036: END IF;

Line 3049: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MRS_NOT_ACC');

3045: CLOSE get_rel_count_csr;
3046: IF (l_temp_count > 0) THEN
3047: -- SR has associated MRs, but the SR UE has not been assigned to any visit.
3048: p_x_valid_flag := false;
3049: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MRS_NOT_ACC');
3050: FND_MSG_PUB.ADD;
3051: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3052: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3053: END IF;

Line 3073: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_SR_CLSD');

3069: -- reopening an SR whose UE is already SR_CLOSED
3070: IF (p_old_ue_status = G_UMP_SR_CLOSED_STATUS) THEN
3071: -- Attempting to open an SR whose UE is already SR_CLOSED.
3072: p_x_valid_flag := false;
3073: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_SR_CLSD');
3074: FND_MSG_PUB.ADD;
3075: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3076: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3077: END IF;

Line 3091: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NOT_ASSND');

3087: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
3088: IF (l_assigned = false) THEN
3089: -- SR is being moved to Planned status without assigning SR UE to any visit
3090: p_x_valid_flag := false;
3091: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NOT_ASSND');
3092: FND_MSG_PUB.ADD;
3093: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3094: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3095: END IF;

Line 3101: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ALREADY_ASSND');

3097: ELSE
3098: IF (l_assigned = true) THEN
3099: -- SR is being moved to a not-planned status while SR UE has already been assigned to a visit
3100: p_x_valid_flag := false;
3101: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ALREADY_ASSND');
3102: FND_MSG_PUB.ADD;
3103: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3104: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
3105: END IF;