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 297: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');

293:
294: --Raising an error if the request id null
295: IF (l_request_id IS NULL OR l_request_id = FND_API.G_MISS_NUM) THEN
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: FND_MESSAGE.set_name('AHL', 'AHL_UMP_MISSING_REQUEST_ID');
298: FND_MSG_PUB.add;
299: RAISE FND_API.G_EXC_ERROR;
300: END IF;
301:

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

304: FETCH validate_incident_id into l_incident_id;
305:
306: --Raise an error if the incident id is not valid.
307: IF (validate_incident_id%NOTFOUND) THEN
308: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_INCIDENT_ID');
309: fnd_message.set_token('INCIDENT_ID', l_request_id, false);
310: FND_MSG_PUB.add;
311: CLOSE validate_instance;
312: RAISE FND_API.G_EXC_ERROR;

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

305:
306: --Raise an error if the incident id is not valid.
307: IF (validate_incident_id%NOTFOUND) THEN
308: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_INCIDENT_ID');
309: fnd_message.set_token('INCIDENT_ID', l_request_id, false);
310: FND_MSG_PUB.add;
311: CLOSE validate_instance;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;

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

341:
342: --Set the return status to an error and raise an error message if the return status is an error.
343: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
344: x_return_status := FND_API.G_RET_STS_ERROR;
345: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_PROF_NOT_SET');
346: FND_MSG_PUB.add;
347: RAISE FND_API.G_EXC_ERROR;
348: END IF;
349:

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

349:
350: --Set the return status to an error and raise an error message if the application code returned is not AHL
351: IF (l_appln_code <> 'AHL') THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
354: FND_MESSAGE.set_token('TASK', l_name, false);
355: FND_MSG_PUB.add;
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;

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

350: --Set the return status to an error and raise an error message if the application code returned is not AHL
351: IF (l_appln_code <> 'AHL') THEN
352: x_return_status := FND_API.G_RET_STS_ERROR;
353: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
354: FND_MESSAGE.set_token('TASK', l_name, false);
355: FND_MSG_PUB.add;
356: RAISE FND_API.G_EXC_ERROR;
357: END IF;
358:

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

361: --******************************
362: -- JR: Modified on 10/29/2003 (Using Status Id instead of Status Code)
363: -- Raise an error if the status is PLANNED.
364: IF (l_status_id = G_SR_PLANNED_STATUS_ID) THEN
365: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INVALID_STATUS_CODE');
366: FND_MSG_PUB.add;
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:

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

372: --******************************
373: --Raise an error if the item instance id null
374: IF (l_customer_product_id IS NULL OR l_customer_product_id = FND_API.G_MISS_NUM) THEN
375: x_return_status := FND_API.G_RET_STS_ERROR;
376: FND_MESSAGE.set_name('AHL', 'AHL_UMP_INSTANCE_MANDATORY');
377: FND_MSG_PUB.add;
378: RAISE FND_API.G_EXC_ERROR;
379: END IF;
380:

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

382: OPEN validate_instance(l_customer_product_id);
383: FETCH validate_instance into l_instance_id, l_instance_number, l_active_end_date;
384: --Raise an error if the instance is not a valid CSI Instance
385: IF (validate_instance%NOTFOUND) THEN
386: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE');
387: fnd_message.set_token('CSI_INSTANCE_ID', l_customer_product_id, false);
388: FND_MSG_PUB.add;
389: CLOSE validate_instance;
390: RAISE FND_API.G_EXC_ERROR;

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

383: FETCH validate_instance into l_instance_id, l_instance_number, l_active_end_date;
384: --Raise an error if the instance is not a valid CSI Instance
385: IF (validate_instance%NOTFOUND) THEN
386: fnd_message.set_name('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE');
387: fnd_message.set_token('CSI_INSTANCE_ID', l_customer_product_id, false);
388: FND_MSG_PUB.add;
389: CLOSE validate_instance;
390: RAISE FND_API.G_EXC_ERROR;
391: END IF;

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

391: END IF;
392:
393: --Raise an error if the instance is inactive.
394: IF ( l_active_end_date IS NOT NULL AND l_active_end_date <= SYSDATE ) THEN
395: fnd_message.set_name('AHL', 'AHL_UMP_INACTIVE_INSTANCE');
396: fnd_message.set_token('INSTANCE_NUMBER', l_instance_number, false);
397: FND_MSG_PUB.add;
398: CLOSE validate_instance;
399: RAISE FND_API.G_EXC_ERROR;

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

392:
393: --Raise an error if the instance is inactive.
394: IF ( l_active_end_date IS NOT NULL AND l_active_end_date <= SYSDATE ) THEN
395: fnd_message.set_name('AHL', 'AHL_UMP_INACTIVE_INSTANCE');
396: fnd_message.set_token('INSTANCE_NUMBER', l_instance_number, false);
397: FND_MSG_PUB.add;
398: CLOSE validate_instance;
399: RAISE FND_API.G_EXC_ERROR;
400: END IF;

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

418: -- for all other cases treat the NR as being created for IB component only, i.e. no unit info
419: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_hdr_id);
420: IF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
421: THEN
422: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_NR_UNIT_QUAR_INV');
423: FND_MSG_PUB.ADD;
424: RAISE FND_API.G_EXC_ERROR;
425: ELSIF (l_uc_status_code NOT IN ('COMPLETE', 'INCOMPLETE'))
426: THEN

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

618: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
619: x_return_status => x_return_status);
620:
621: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
622: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');
623: FND_MSG_PUB.ADD;
624: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
625: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
626: END IF;

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

625: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
626: END IF;
627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
628: ELSIF(l_appln_code IS NULL OR (l_appln_code <> G_APP_MODULE)) THEN
629: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');
630: FND_MSG_PUB.ADD;
631: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
632: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
633: END IF;

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

776: AHL_UTIL_PKG.Get_Appln_Usage(x_appln_code => l_appln_code,
777: x_return_status => x_return_status);
778:
779: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
780: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_NOT_SET');
781: FND_MSG_PUB.ADD;
782: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
783: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
784: END IF;

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

783: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
784: END IF;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
786: ELSIF(l_appln_code IS NULL OR (l_appln_code <> G_APP_MODULE)) THEN
787: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_APP_USAGE_INVALID');
788: FND_MSG_PUB.ADD;
789: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
790: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
791: END IF;

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

807: FND_LOG.STRING(FND_LOG.LEVEL_EVENT, L_DEBUG_KEY, 'Completed Validating the Request');
808: END IF;
809:
810: IF (p_x_sr_mr_association_tbl.COUNT = 0) THEN
811: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_SR_TBL_EMPTY');
812: FND_MSG_PUB.ADD;
813: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
814: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
815: END IF;

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

953: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Procedure');
954: END IF;
955:
956: IF(p_x_request_id IS NULL AND p_request_number IS NULL) THEN
957: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_NUM_NULL');
958: FND_MSG_PUB.ADD;
959: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
960: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
961: END IF;

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

960: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
961: END IF;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: ELSIF (p_object_version_number IS NULL) THEN
964: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_NULL');
965: FND_MSG_PUB.ADD;
966: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
968: END IF;

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

976: l_closed_flag,
977: x_sr_instance_id, -- OUT Parameter
978: x_sr_exp_resol_date; -- OUT Parameter
979: IF get_request_dtls_csr%NOTFOUND THEN
980: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_INVALID');
981: FND_MESSAGE.Set_Token('ID', p_x_request_id);
982: FND_MESSAGE.Set_Token('OVN', p_object_version_number);
983: FND_MSG_PUB.ADD;
984: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

977: x_sr_instance_id, -- OUT Parameter
978: x_sr_exp_resol_date; -- OUT Parameter
979: IF get_request_dtls_csr%NOTFOUND THEN
980: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_INVALID');
981: FND_MESSAGE.Set_Token('ID', p_x_request_id);
982: FND_MESSAGE.Set_Token('OVN', p_object_version_number);
983: FND_MSG_PUB.ADD;
984: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
985: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

978: x_sr_exp_resol_date; -- OUT Parameter
979: IF get_request_dtls_csr%NOTFOUND THEN
980: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_OVN_INVALID');
981: FND_MESSAGE.Set_Token('ID', p_x_request_id);
982: FND_MESSAGE.Set_Token('OVN', p_object_version_number);
983: FND_MSG_PUB.ADD;
984: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
985: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
986: END IF;

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

990: CLOSE get_request_dtls_csr;
991: END IF;
992:
993: IF(l_closed_flag = G_YES_FLAG) THEN
994: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_CLOSED');
995: FND_MSG_PUB.ADD;
996: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
998: END IF;

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

1005: Please refer the design document for more information.
1006:
1007: -- JR: Modified on 10/29/2003 (Using Status Id instead of Status Code)
1008: IF (l_sr_status_id = G_SR_PLANNED_STATUS_ID) THEN
1009: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
1010: FND_MSG_PUB.ADD;
1011: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1012: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1013: END IF;

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

1016: */
1017: OPEN get_ue_dtls_csr(p_request_id => p_x_request_id);
1018: FETCH get_ue_dtls_csr INTO x_sr_ue_id; -- OUT Parameter
1019: IF (get_ue_dtls_csr%NOTFOUND) THEN
1020: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NO_UE_FOR_REQ');
1021: FND_MESSAGE.Set_Token('ID', p_x_request_id);
1022: FND_MSG_PUB.ADD;
1023: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1017: OPEN get_ue_dtls_csr(p_request_id => p_x_request_id);
1018: FETCH get_ue_dtls_csr INTO x_sr_ue_id; -- OUT Parameter
1019: IF (get_ue_dtls_csr%NOTFOUND) THEN
1020: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NO_UE_FOR_REQ');
1021: FND_MESSAGE.Set_Token('ID', p_x_request_id);
1022: FND_MSG_PUB.ADD;
1023: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1025: END IF;

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

1035: Please refer the design document for more information.
1036: OPEN get_tasks_for_ue_csr(p_ue_id => x_sr_ue_id);
1037: FETCH get_tasks_for_ue_csr INTO l_dummy;
1038: IF (get_tasks_for_ue_csr%FOUND) THEN
1039: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ASGND_TO_VISIT');
1040: FND_MSG_PUB.ADD;
1041: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1042: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1043: END IF;

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

1123: END IF;
1124: FOR i in p_x_sr_mr_association_tbl.FIRST .. p_x_sr_mr_association_tbl.LAST LOOP
1125: l_valid := true;
1126: IF (p_x_sr_mr_association_tbl(i).OPERATION_FLAG NOT IN (G_OPR_CREATE, G_OPR_DELETE)) THEN
1127: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_OPR_INVALID');
1128: FND_MESSAGE.Set_Token('OPR_FLAG', p_x_sr_mr_association_tbl(i).OPERATION_FLAG);
1129: FND_MESSAGE.Set_Token('INDEX', i);
1130: FND_MSG_PUB.ADD;
1131: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1124: FOR i in p_x_sr_mr_association_tbl.FIRST .. p_x_sr_mr_association_tbl.LAST LOOP
1125: l_valid := true;
1126: IF (p_x_sr_mr_association_tbl(i).OPERATION_FLAG NOT IN (G_OPR_CREATE, G_OPR_DELETE)) THEN
1127: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_OPR_INVALID');
1128: FND_MESSAGE.Set_Token('OPR_FLAG', p_x_sr_mr_association_tbl(i).OPERATION_FLAG);
1129: FND_MESSAGE.Set_Token('INDEX', i);
1130: FND_MSG_PUB.ADD;
1131: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1132: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1125: l_valid := true;
1126: IF (p_x_sr_mr_association_tbl(i).OPERATION_FLAG NOT IN (G_OPR_CREATE, G_OPR_DELETE)) THEN
1127: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_OPR_INVALID');
1128: FND_MESSAGE.Set_Token('OPR_FLAG', p_x_sr_mr_association_tbl(i).OPERATION_FLAG);
1129: FND_MESSAGE.Set_Token('INDEX', i);
1130: FND_MSG_PUB.ADD;
1131: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1132: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1133: END IF;

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

1136: -- Delete Operation
1137: Get_MR_UnitEffectivity(p_sr_ue_id => p_sr_ue_id,
1138: p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1139: IF (p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID IS NULL) THEN
1140: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_ID_NULL');
1141: FND_MESSAGE.Set_Token('INDEX', i);
1142: FND_MSG_PUB.ADD;
1143: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1144: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1137: Get_MR_UnitEffectivity(p_sr_ue_id => p_sr_ue_id,
1138: p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1139: IF (p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID IS NULL) THEN
1140: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_ID_NULL');
1141: FND_MESSAGE.Set_Token('INDEX', i);
1142: FND_MSG_PUB.ADD;
1143: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1144: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1145: END IF;

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

1144: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1145: END IF;
1146: l_valid := false;
1147: ELSIF (p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER IS NULL) THEN
1148: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_NULL');
1149: FND_MESSAGE.Set_Token('INDEX', i);
1150: FND_MSG_PUB.ADD;
1151: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1145: END IF;
1146: l_valid := false;
1147: ELSIF (p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER IS NULL) THEN
1148: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_NULL');
1149: FND_MESSAGE.Set_Token('INDEX', i);
1150: FND_MSG_PUB.ADD;
1151: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1153: END IF;

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

1157: p_mr_ue_ovn => p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER,
1158: p_sr_ue_id => p_sr_ue_id);
1159: FETCH validate_mr_ue_csr INTO l_dummy;
1160: IF (validate_mr_ue_csr%NOTFOUND) THEN
1161: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_INVALID');
1162: FND_MESSAGE.Set_Token('UE_ID', p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1163: FND_MESSAGE.Set_Token('OVN', p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER);
1164: FND_MESSAGE.Set_Token('INDEX', i);
1165: FND_MSG_PUB.ADD;

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

1158: p_sr_ue_id => p_sr_ue_id);
1159: FETCH validate_mr_ue_csr INTO l_dummy;
1160: IF (validate_mr_ue_csr%NOTFOUND) THEN
1161: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_INVALID');
1162: FND_MESSAGE.Set_Token('UE_ID', p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1163: FND_MESSAGE.Set_Token('OVN', p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER);
1164: FND_MESSAGE.Set_Token('INDEX', i);
1165: FND_MSG_PUB.ADD;
1166: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1159: FETCH validate_mr_ue_csr INTO l_dummy;
1160: IF (validate_mr_ue_csr%NOTFOUND) THEN
1161: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_INVALID');
1162: FND_MESSAGE.Set_Token('UE_ID', p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1163: FND_MESSAGE.Set_Token('OVN', p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER);
1164: FND_MESSAGE.Set_Token('INDEX', i);
1165: FND_MSG_PUB.ADD;
1166: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1160: IF (validate_mr_ue_csr%NOTFOUND) THEN
1161: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_OVN_INVALID');
1162: FND_MESSAGE.Set_Token('UE_ID', p_x_sr_mr_association_tbl(i).UNIT_EFFECTIVITY_ID);
1163: FND_MESSAGE.Set_Token('OVN', p_x_sr_mr_association_tbl(i).OBJECT_VERSION_NUMBER);
1164: FND_MESSAGE.Set_Token('INDEX', i);
1165: FND_MSG_PUB.ADD;
1166: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1167: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1168: END IF;

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

1182: ELSE
1183: -- Create Operation
1184: Get_New_Asso_Val_To_Id(p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1185: IF (p_x_sr_mr_association_tbl(i).MR_HEADER_ID IS NULL) THEN
1186: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1187: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1188: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1189: FND_MESSAGE.Set_Token('INDEX', i);
1190: FND_MSG_PUB.ADD;

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

1183: -- Create Operation
1184: Get_New_Asso_Val_To_Id(p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1185: IF (p_x_sr_mr_association_tbl(i).MR_HEADER_ID IS NULL) THEN
1186: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1187: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1188: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1189: FND_MESSAGE.Set_Token('INDEX', i);
1190: FND_MSG_PUB.ADD;
1191: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1184: Get_New_Asso_Val_To_Id(p_x_sr_mr_association_rec => p_x_sr_mr_association_tbl(i));
1185: IF (p_x_sr_mr_association_tbl(i).MR_HEADER_ID IS NULL) THEN
1186: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1187: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1188: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1189: FND_MESSAGE.Set_Token('INDEX', i);
1190: FND_MSG_PUB.ADD;
1191: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1185: IF (p_x_sr_mr_association_tbl(i).MR_HEADER_ID IS NULL) THEN
1186: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1187: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1188: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1189: FND_MESSAGE.Set_Token('INDEX', i);
1190: FND_MSG_PUB.ADD;
1191: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1192: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1193: END IF;

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

1192: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1193: END IF;
1194: l_valid := false;
1195: ELSIF (p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID IS NULL) THEN
1196: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NUM_INVALID');
1197: FND_MESSAGE.Set_Token('INST_NUM', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_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('INST_NUM', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_NUMBER);

1193: END IF;
1194: l_valid := false;
1195: ELSIF (p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID IS NULL) THEN
1196: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NUM_INVALID');
1197: FND_MESSAGE.Set_Token('INST_NUM', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_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: l_valid := false;
1195: ELSIF (p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID IS NULL) THEN
1196: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NUM_INVALID');
1197: FND_MESSAGE.Set_Token('INST_NUM', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_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 1210: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_ID_INVALID');

1206: OPEN validate_mr_id_csr(p_mr_header_id => p_x_sr_mr_association_tbl(i).MR_HEADER_ID);
1207: FETCH validate_mr_id_csr INTO p_x_sr_mr_association_tbl(i).MR_TITLE, l_program_type_code;
1208: IF (validate_mr_id_csr%NOTFOUND) THEN
1209: CLOSE validate_mr_id_csr;
1210: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_ID_INVALID');
1211: FND_MESSAGE.Set_Token('MR_ID', p_x_sr_mr_association_tbl(i).MR_HEADER_ID);
1212: FND_MESSAGE.Set_Token('INDEX', i);
1213: FND_MSG_PUB.ADD;
1214: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1207: FETCH validate_mr_id_csr INTO p_x_sr_mr_association_tbl(i).MR_TITLE, l_program_type_code;
1208: IF (validate_mr_id_csr%NOTFOUND) THEN
1209: CLOSE validate_mr_id_csr;
1210: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_ID_INVALID');
1211: FND_MESSAGE.Set_Token('MR_ID', p_x_sr_mr_association_tbl(i).MR_HEADER_ID);
1212: FND_MESSAGE.Set_Token('INDEX', i);
1213: FND_MSG_PUB.ADD;
1214: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1208: IF (validate_mr_id_csr%NOTFOUND) THEN
1209: CLOSE validate_mr_id_csr;
1210: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_ID_INVALID');
1211: FND_MESSAGE.Set_Token('MR_ID', p_x_sr_mr_association_tbl(i).MR_HEADER_ID);
1212: FND_MESSAGE.Set_Token('INDEX', i);
1213: FND_MSG_PUB.ADD;
1214: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1216: END IF;

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

1221: OPEN validate_instance_id_csr(p_csi_instance_id => p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1222: FETCH validate_instance_id_csr INTO p_x_sr_mr_association_tbl(i).CSI_INSTANCE_NUMBER;
1223: IF (validate_instance_id_csr%NOTFOUND) THEN
1224: CLOSE validate_instance_id_csr;
1225: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_ID_INVALID');
1226: FND_MESSAGE.Set_Token('INST_ID', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1227: FND_MESSAGE.Set_Token('INDEX', i);
1228: FND_MSG_PUB.ADD;
1229: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1222: FETCH validate_instance_id_csr INTO p_x_sr_mr_association_tbl(i).CSI_INSTANCE_NUMBER;
1223: IF (validate_instance_id_csr%NOTFOUND) THEN
1224: CLOSE validate_instance_id_csr;
1225: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_ID_INVALID');
1226: FND_MESSAGE.Set_Token('INST_ID', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1227: FND_MESSAGE.Set_Token('INDEX', i);
1228: FND_MSG_PUB.ADD;
1229: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1230: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1223: IF (validate_instance_id_csr%NOTFOUND) THEN
1224: CLOSE validate_instance_id_csr;
1225: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_ID_INVALID');
1226: FND_MESSAGE.Set_Token('INST_ID', p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID);
1227: FND_MESSAGE.Set_Token('INDEX', i);
1228: FND_MSG_PUB.ADD;
1229: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1230: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1231: END IF;

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

1237: 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);
1238: FETCH validate_sr_mr_intance_rel INTO l_flag_sr_mr_inst;
1239: IF (validate_sr_mr_intance_rel%NOTFOUND) THEN
1240: CLOSE validate_sr_mr_intance_rel;
1241: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1242: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1243: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1244: FND_MESSAGE.Set_Token('INDEX', i);
1245: FND_MSG_PUB.ADD;

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

1238: FETCH validate_sr_mr_intance_rel INTO l_flag_sr_mr_inst;
1239: IF (validate_sr_mr_intance_rel%NOTFOUND) THEN
1240: CLOSE validate_sr_mr_intance_rel;
1241: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1242: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1243: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1244: FND_MESSAGE.Set_Token('INDEX', i);
1245: FND_MSG_PUB.ADD;
1246: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1239: IF (validate_sr_mr_intance_rel%NOTFOUND) THEN
1240: CLOSE validate_sr_mr_intance_rel;
1241: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1242: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1243: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1244: FND_MESSAGE.Set_Token('INDEX', i);
1245: FND_MSG_PUB.ADD;
1246: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1240: CLOSE validate_sr_mr_intance_rel;
1241: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_INVALID');
1242: FND_MESSAGE.Set_Token('TITLE', p_x_sr_mr_association_tbl(i).MR_TITLE);
1243: FND_MESSAGE.Set_Token('VERSION', p_x_sr_mr_association_tbl(i).MR_VERSION);
1244: FND_MESSAGE.Set_Token('INDEX', i);
1245: FND_MSG_PUB.ADD;
1246: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1247: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1248: END IF;

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

1259: p_item_instance_id => p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID,
1260: p_mr_header_id => p_x_sr_mr_association_tbl(i).MR_HEADER_ID,
1261: x_applicable_mr_tbl => l_applicable_mr_tbl);
1262: IF (l_temp_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1263: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_FAILED');
1264: FND_MESSAGE.Set_Token('INDEX', i);
1265: FND_MSG_PUB.ADD;
1266: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1267: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1260: p_mr_header_id => p_x_sr_mr_association_tbl(i).MR_HEADER_ID,
1261: x_applicable_mr_tbl => l_applicable_mr_tbl);
1262: IF (l_temp_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1263: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_DTLS_FAILED');
1264: FND_MESSAGE.Set_Token('INDEX', i);
1265: FND_MSG_PUB.ADD;
1266: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1267: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1268: END IF;

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

1278: END IF; -- Applicable
1279: END LOOP; -- All Applicable MRs
1280: END IF; -- Table Count > 0
1281: IF (l_mr_applicable = false) THEN
1282: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_NOT_APPLCBL');
1283: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));
1284: FND_MSG_PUB.ADD;
1285: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1286: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1279: END LOOP; -- All Applicable MRs
1280: END IF; -- Table Count > 0
1281: IF (l_mr_applicable = false) THEN
1282: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MR_NOT_APPLCBL');
1283: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));
1284: FND_MSG_PUB.ADD;
1285: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1286: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1287: END IF;

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

1457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Record ' || i || ' with MR Id ' ||
1458: p_x_sr_mr_association_tbl(i).MR_HEADER_ID || ' and Instance Id ' ||
1459: p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID || ' is a Duplicate.');
1460: END IF;
1461: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_DUPLICATE_MR');
1462: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));
1463: FND_MSG_PUB.ADD;
1464: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1465: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1458: p_x_sr_mr_association_tbl(i).MR_HEADER_ID || ' and Instance Id ' ||
1459: p_x_sr_mr_association_tbl(i).CSI_INSTANCE_ID || ' is a Duplicate.');
1460: END IF;
1461: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_DUPLICATE_MR');
1462: FND_MESSAGE.Set_Token('MR_TITLE', Get_MR_Title_From_MR_Id(p_x_sr_mr_association_tbl(i).MR_HEADER_ID));
1463: FND_MSG_PUB.ADD;
1464: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1465: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1466: END IF;

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

1553:
1554: EXCEPTION
1555:
1556: WHEN OTHERS THEN
1557: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_ORIGINWO_UPD_FAILED');
1558: Fnd_Msg_Pub.ADD;
1559: END;
1560: END IF;
1561: -- End Changes ER # 6123671

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

1955: x_msg_data => l_temp_msg_data);
1956: IF NOT (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1957: p_x_valid_flag := false;
1958: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
1959: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GRP_MR_FAILED');
1960: FND_MESSAGE.Set_Token('MR_TITLE', l_curr_mr_title);
1961: FND_MSG_PUB.ADD;
1962: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1963: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

1956: IF NOT (l_temp_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1957: p_x_valid_flag := false;
1958: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
1959: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GRP_MR_FAILED');
1960: FND_MESSAGE.Set_Token('MR_TITLE', l_curr_mr_title);
1961: FND_MSG_PUB.ADD;
1962: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1963: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
1964: END IF;

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

1998: -- At least one duplicate found
1999: CLOSE get_duplicate_mrs_csr;
2000: l_dup_mr_title := Get_MR_Title_From_MR_Id(l_duplicate_mr_id);
2001: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
2002: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GROUP_DUP_MR');
2003: FND_MESSAGE.Set_Token('NEW_MR', l_curr_mr_title);
2004: FND_MESSAGE.Set_Token('DUP_MR', l_dup_mr_title);
2005: FND_MSG_PUB.ADD;
2006: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

1999: CLOSE get_duplicate_mrs_csr;
2000: l_dup_mr_title := Get_MR_Title_From_MR_Id(l_duplicate_mr_id);
2001: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
2002: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GROUP_DUP_MR');
2003: FND_MESSAGE.Set_Token('NEW_MR', l_curr_mr_title);
2004: FND_MESSAGE.Set_Token('DUP_MR', l_dup_mr_title);
2005: FND_MSG_PUB.ADD;
2006: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2007: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

2000: l_dup_mr_title := Get_MR_Title_From_MR_Id(l_duplicate_mr_id);
2001: l_curr_mr_title := Get_MR_Title_From_MR_Id(p_mr_header_id);
2002: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_GROUP_DUP_MR');
2003: FND_MESSAGE.Set_Token('NEW_MR', l_curr_mr_title);
2004: FND_MESSAGE.Set_Token('DUP_MR', l_dup_mr_title);
2005: FND_MSG_PUB.ADD;
2006: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2007: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2008: END IF;

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

2415: END IF;
2416:
2417: -- Ensure that request id is not null
2418: IF(CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id IS NULL) THEN
2419: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_NULL');
2420: FND_MSG_PUB.ADD;
2421: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2422: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2423: END IF;

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

2428: OPEN check_request_exists_csr;
2429: FETCH check_request_exists_csr INTO l_dummy;
2430: IF(check_request_exists_csr%NOTFOUND) THEN
2431: CLOSE check_request_exists_csr;
2432: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2433: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2434: FND_MSG_PUB.ADD;
2435: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2436: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

2429: FETCH check_request_exists_csr INTO l_dummy;
2430: IF(check_request_exists_csr%NOTFOUND) THEN
2431: CLOSE check_request_exists_csr;
2432: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2433: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2434: FND_MSG_PUB.ADD;
2435: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2436: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2437: END IF;

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

2444: OPEN get_ue_dtls_csr;
2445: FETCH get_ue_dtls_csr INTO x_sr_ue_id, x_sr_ue_ovn;
2446: IF (get_ue_dtls_csr%NOTFOUND) THEN
2447: CLOSE get_ue_dtls_csr;
2448: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2449: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2450: FND_MSG_PUB.ADD;
2451: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2452: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);

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

2445: FETCH get_ue_dtls_csr INTO x_sr_ue_id, x_sr_ue_ovn;
2446: IF (get_ue_dtls_csr%NOTFOUND) THEN
2447: CLOSE get_ue_dtls_csr;
2448: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_ID_INVALID');
2449: FND_MESSAGE.Set_Token('REQ_ID', CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id);
2450: FND_MSG_PUB.ADD;
2451: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2452: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2453: END IF;

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

2494: END IF;
2495:
2496: -- Ensure that the SR is not closed
2497: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_flag = G_SR_CLOSED_FLAG) THEN
2498: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_CLOSED');
2499: FND_MSG_PUB.ADD;
2500: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2501: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2502: END IF;

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

2512: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2513: OPEN get_tasks_for_ue_csr;
2514: FETCH get_tasks_for_ue_csr INTO l_dummy;
2515: IF (get_tasks_for_ue_csr%FOUND) THEN
2516: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ASGND_TO_VISIT');
2517: FND_MSG_PUB.ADD;
2518: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2519: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2520: END IF;

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

2523: -- to a visit is not possible
2524: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2525: 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');
2526: END IF;
2527: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
2528: FND_MSG_PUB.ADD;
2529: END IF; -- tasks found
2530: CLOSE get_tasks_for_ue_csr;
2531: RAISE FND_API.G_EXC_ERROR;

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

2556: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2557: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Non-CMRO to CMRO type conversion');
2558: END IF;
2559: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2560: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_REQ_PLANNED');
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 2752: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NULL');

2748: x_instance_changed := false;
2749:
2750: IF (l_new_instance_id IS NULL) THEN
2751: p_x_valid_flag := false;
2752: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_NULL');
2753: FND_MSG_PUB.ADD;
2754: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2755: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2756: END IF;

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

2757: ELSIF (l_new_instance_id <> p_old_instance_id) THEN
2758: -- Instance has changed: Validate
2759: IF (CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.status_flag = G_SR_CLOSED_FLAG) THEN
2760: p_x_valid_flag := false;
2761: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_CLOSED');
2762: FND_MSG_PUB.ADD;
2763: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2764: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2765: END IF;

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

2764: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2765: END IF;
2766: ELSIF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2767: p_x_valid_flag := false;
2768: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_PLANNED');
2769: FND_MSG_PUB.ADD;
2770: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2771: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2772: END IF;

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

2775: FETCH get_rel_count_csr INTO l_temp_count;
2776: CLOSE get_rel_count_csr;
2777: IF (l_temp_count > 0) THEN
2778: p_x_valid_flag := false;
2779: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_INST_CHG_HAS_MRS');
2780: FND_MSG_PUB.ADD;
2781: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2782: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2783: END IF;

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

2836: -- SR UE Assigned to a visit
2837: 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
2838: -- UE Neither accomplished nor terminated
2839: p_x_valid_flag := false;
2840: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_TASK_NOT_ACC');
2841: FND_MSG_PUB.ADD;
2842: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2843: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2844: END IF;

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

2853: CLOSE get_rel_count_csr;
2854: IF (l_temp_count > 0) THEN
2855: -- SR has associated MRs, but the SR UE has not been assigned to any visit.
2856: p_x_valid_flag := false;
2857: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_MRS_NOT_ACC');
2858: FND_MSG_PUB.ADD;
2859: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2860: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2861: END IF;

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

2877: -- reopening an SR whose UE is already SR_CLOSED
2878: IF (p_old_ue_status = G_UMP_SR_CLOSED_STATUS) THEN
2879: -- Attempting to open an SR whose UE is already SR_CLOSED.
2880: p_x_valid_flag := false;
2881: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_UE_SR_CLSD');
2882: FND_MSG_PUB.ADD;
2883: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2884: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2885: END IF;

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

2895: IF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN
2896: IF (l_assigned = false) THEN
2897: -- SR is being moved to Planned status without assigning SR UE to any visit
2898: p_x_valid_flag := false;
2899: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_NOT_ASSND');
2900: FND_MSG_PUB.ADD;
2901: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2902: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2903: END IF;

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

2905: ELSE
2906: IF (l_assigned = true) THEN
2907: -- SR is being moved to a not-planned status while SR UE has already been assigned to a visit
2908: p_x_valid_flag := false;
2909: FND_MESSAGE.Set_Name('AHL', 'AHL_UMP_SR_ALREADY_ASSND');
2910: FND_MSG_PUB.ADD;
2911: IF (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2912: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR, L_DEBUG_KEY, FALSE);
2913: END IF;