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_MSG_PUB

Line 262: -- FND_MSG_PUB.Initialize;

258: END IF;
259:
260: -- Initialize message list
261: --AMSRINIV. Bug 5470730. Removing message initialization.
262: -- FND_MSG_PUB.Initialize;
263:
264: -- Initialize API return status to success
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266:

Line 298: FND_MSG_PUB.add;

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:
302: --Opening cursor to validate incident id

Line 310: FND_MSG_PUB.add;

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;
314:

Line 346: FND_MSG_PUB.add;

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:
350: --Set the return status to an error and raise an error message if the application code returned is not AHL

Line 355: FND_MSG_PUB.add;

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:
359: --******************************

Line 366: FND_MSG_PUB.add;

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:
370: --******************************

Line 377: FND_MSG_PUB.add;

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:
381: --Ensuring that the instance exists in csi_item_instances.

Line 388: FND_MSG_PUB.add;

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;
392:

Line 397: FND_MSG_PUB.add;

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;
401:

Line 423: FND_MSG_PUB.ADD;

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
427: l_uc_hdr_id := null;

Line 521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Msg Count:' || fnd_msg_pub.count_msg);

517: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
520: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Return Status:' || x_return_status);
521: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' Error: Msg Count:' || fnd_msg_pub.count_msg);
522: END IF;
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;

Line 529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' UnExpError: Msg Count:' || fnd_msg_pub.count_msg);

525: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
527: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
528: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' UnExpError: Return Status:' || x_return_status);
529: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, L_DEBUG_KEY , ' UnExpError: Msg Count:' || fnd_msg_pub.count_msg);
530: END IF;
531:
532: WHEN OTHERS THEN
533: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;

Line 535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

531:
532: WHEN OTHERS THEN
533: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
536: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
537: p_procedure_name => 'Create_SR_Unit_Effectivity',
538: p_error_text => SUBSTR(SQLERRM,1,240));
539: END IF;

Line 536: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

532: WHEN OTHERS THEN
533: ROLLBACK TO Create_SR_Unit_Effectivity_Pvt;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
536: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
537: p_procedure_name => 'Create_SR_Unit_Effectivity',
538: p_error_text => SUBSTR(SQLERRM,1,240));
539: END IF;
540:

Line 597: --FND_MSG_PUB.Initialize;

593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: -- Initialize message list
596: --AMSRINIV. Bug 5470730. Removing message initialization.
597: --FND_MSG_PUB.Initialize;
598:
599: -- Begin Processing
600: IF NOT (NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.old_type_cmro_flag, G_NO_FLAG) = G_YES_FLAG OR
601: NVL(CS_SERVICEREQUEST_PVT.USER_HOOKS_REC.new_type_cmro_flag, G_NO_FLAG)= G_YES_FLAG) THEN

Line 623: FND_MSG_PUB.ADD;

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;
627: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 630: FND_MSG_PUB.ADD;

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;
634: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

669:
670: WHEN OTHERS THEN
671: ROLLBACK TO Process_SR_Updates_Pvt;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
674: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
675: p_procedure_name => 'Process_SR_Updates',
676: p_error_text => SUBSTR(SQLERRM,1,240));
677: END IF;

Line 674: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

670: WHEN OTHERS THEN
671: ROLLBACK TO Process_SR_Updates_Pvt;
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
674: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
675: p_procedure_name => 'Process_SR_Updates',
676: p_error_text => SUBSTR(SQLERRM,1,240));
677: END IF;
678:

Line 763: FND_MSG_PUB.Initialize;

759: END IF;
760:
761: -- Initialize message list if p_init_msg_list is set to TRUE
762: IF FND_API.To_Boolean(p_init_msg_list) THEN
763: FND_MSG_PUB.Initialize;
764: END IF;
765:
766: -- Initialize API return status to success
767: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 781: FND_MSG_PUB.ADD;

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;
785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 788: FND_MSG_PUB.ADD;

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;
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 812: FND_MSG_PUB.ADD;

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;
816: RAISE FND_API.G_EXC_ERROR;

Line 825: IF (FND_MSG_PUB.Count_Msg > 0) THEN

821: p_sr_ue_id => l_sr_ue_id,
822: p_sr_instance_id => l_sr_instance_id,
823: p_x_sr_mr_association_tbl => p_x_sr_mr_association_tbl);
824:
825: IF (FND_MSG_PUB.Count_Msg > 0) THEN
826: -- There are validation errors: No need to process further
827: RAISE FND_API.G_EXC_ERROR;
828: END IF;
829:

Line 843: IF (FND_MSG_PUB.Count_Msg > 0) THEN

839: p_user_id => p_user_id,
840: p_login_id => p_login_id,
841: p_x_sr_mr_association_tbl => p_x_sr_mr_association_tbl);
842:
843: IF (FND_MSG_PUB.Count_Msg > 0) THEN
844: -- There are validation errors from Process_New_Associations: Raise error
845: RAISE FND_API.G_EXC_ERROR;
846: END IF;
847:

Line 857: FND_MSG_PUB.Count_And_Get

853: COMMIT WORK;
854: END IF;
855:
856: -- Standard call to get message count and if count is 1, get message info
857: FND_MSG_PUB.Count_And_Get
858: ( p_count => x_msg_count,
859: p_data => x_msg_data,
860: p_encoded => fnd_api.g_false
861: );

Line 871: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN
869: ROLLBACK TO Process_SR_MR_Associations_pvt;
870: x_return_status := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
872: p_data => x_msg_data,
873: p_encoded => fnd_api.g_false);
874: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
875:

Line 879: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

875:
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: ROLLBACK TO Process_SR_MR_Associations_pvt;
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
880: p_data => x_msg_data,
881: p_encoded => fnd_api.g_false);
882: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
883:

Line 887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

883:
884: WHEN OTHERS THEN
885: ROLLBACK TO Process_SR_MR_Associations_pvt;
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
888: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
889: p_procedure_name => 'Process_SR_MR_Associations',
890: p_error_text => SUBSTR(SQLERRM,1,240));
891: END IF;

Line 888: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,

884: WHEN OTHERS THEN
885: ROLLBACK TO Process_SR_MR_Associations_pvt;
886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
888: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
889: p_procedure_name => 'Process_SR_MR_Associations',
890: p_error_text => SUBSTR(SQLERRM,1,240));
891: END IF;
892: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 892: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

888: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
889: p_procedure_name => 'Process_SR_MR_Associations',
890: p_error_text => SUBSTR(SQLERRM,1,240));
891: END IF;
892: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
893: p_data => x_msg_data,
894: p_encoded => fnd_api.g_false);
895: --AHL_UTIL_PKG.Err_Mesg_To_Table(x_err_mesg_tbl);
896:

Line 958: FND_MSG_PUB.ADD;

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;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 965: FND_MSG_PUB.ADD;

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;
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 983: FND_MSG_PUB.ADD;

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;
987: CLOSE get_request_dtls_csr;

Line 995: FND_MSG_PUB.ADD;

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;
999: RAISE FND_API.G_EXC_ERROR;

Line 1010: FND_MSG_PUB.ADD;

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;
1014: RAISE FND_API.G_EXC_ERROR;

Line 1022: FND_MSG_PUB.ADD;

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;
1026: CLOSE get_ue_dtls_csr;

Line 1040: FND_MSG_PUB.ADD;

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;
1044: CLOSE get_tasks_for_ue_csr;

Line 1130: FND_MSG_PUB.ADD;

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;
1134: l_valid := false;

Line 1142: FND_MSG_PUB.ADD;

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;
1146: l_valid := false;

Line 1150: FND_MSG_PUB.ADD;

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;
1154: l_valid := false;

Line 1165: FND_MSG_PUB.ADD;

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;
1169: l_valid := false;

Line 1190: FND_MSG_PUB.ADD;

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;
1194: l_valid := false;

Line 1199: FND_MSG_PUB.ADD;

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;
1203: l_valid := false;

Line 1213: FND_MSG_PUB.ADD;

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;
1217: l_valid := false;

Line 1228: FND_MSG_PUB.ADD;

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;
1232: l_valid := false;

Line 1245: FND_MSG_PUB.ADD;

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;
1249: l_valid := false;

Line 1265: FND_MSG_PUB.ADD;

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;
1269: l_valid := false;

Line 1284: FND_MSG_PUB.ADD;

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;
1288: l_valid := false;

Line 1463: FND_MSG_PUB.ADD;

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;
1467: ELSE

Line 1558: Fnd_Msg_Pub.ADD;

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
1562:

Line 1961: FND_MSG_PUB.ADD;

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;
1965: RETURN; -- No need to process this Group MR further

Line 2005: FND_MSG_PUB.ADD;

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;
2009: p_x_valid_flag := false;

Line 2420: FND_MSG_PUB.ADD;

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;
2424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2434: FND_MSG_PUB.ADD;

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;
2438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2450: FND_MSG_PUB.ADD;

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;
2454: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2499: FND_MSG_PUB.ADD;

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;
2503: RAISE FND_API.G_EXC_ERROR;

Line 2517: FND_MSG_PUB.ADD;

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;
2521: ELSE

Line 2528: FND_MSG_PUB.ADD;

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;
2532: ELSE

Line 2561: FND_MSG_PUB.ADD;

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;
2565: RAISE FND_API.G_EXC_ERROR;

Line 2753: FND_MSG_PUB.ADD;

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;
2757: ELSIF (l_new_instance_id <> p_old_instance_id) THEN

Line 2762: FND_MSG_PUB.ADD;

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;
2766: ELSIF (CS_SERVICEREQUEST_PVT.user_hooks_rec.status_id = G_SR_PLANNED_STATUS_ID) THEN

Line 2769: FND_MSG_PUB.ADD;

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;
2773: ELSE

Line 2780: FND_MSG_PUB.ADD;

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;
2784: ELSE

Line 2841: FND_MSG_PUB.ADD;

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;
2845: ELSE

Line 2858: FND_MSG_PUB.ADD;

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;
2862: ELSE

Line 2882: FND_MSG_PUB.ADD;

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;
2886: ELSE

Line 2900: FND_MSG_PUB.ADD;

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;
2904: END IF; -- Not assigned

Line 2910: FND_MSG_PUB.ADD;

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;
2914: END IF; -- Already Assigned