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

Line 99: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

95: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_setup_data_rec.REMOVAL_CODE -- '||l_setup_data_rec.REMOVAL_CODE);
96: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_setup_data_rec.OPERATION_FLAG -- '||l_setup_data_rec.OPERATION_FLAG);
97: END IF;
98:
99: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
100: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_SETUP_DATA');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103:

Line 100: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_SETUP_DATA');

96: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_setup_data_rec.OPERATION_FLAG -- '||l_setup_data_rec.OPERATION_FLAG);
97: END IF;
98:
99: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
100: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_SETUP_DATA');
101: FND_MSG_PUB.ADD;
102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103:
104: END IF;

Line 129: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_STATUS_CODE');

125: INTO l_code
126: FROM MTL_MATERIAL_STATUSES_VL
127: WHERE STATUS_ID = l_setup_data_rec.STATUS_ID;
128:
129: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_STATUS_CODE');
130: FND_MESSAGE.Set_Token('ITEM_STATUS',l_code);
131: FND_MSG_PUB.ADD;
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: EXCEPTION

Line 130: FND_MESSAGE.Set_Token('ITEM_STATUS',l_code);

126: FROM MTL_MATERIAL_STATUSES_VL
127: WHERE STATUS_ID = l_setup_data_rec.STATUS_ID;
128:
129: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_STATUS_CODE');
130: FND_MESSAGE.Set_Token('ITEM_STATUS',l_code);
131: FND_MSG_PUB.ADD;
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: EXCEPTION
134: WHEN NO_DATA_FOUND THEN

Line 149: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_REMOVAL_CODE');

145: FROM FND_LOOKUPS
146: WHERE LOOKUP_TYPE = 'AHL_REMOVAL_CODE'
147: AND LOOKUP_CODE = l_setup_data_rec.REMOVAL_CODE;
148:
149: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_REMOVAL_CODE');
150: FND_MESSAGE.Set_Token('REMOVAL_CODE',l_code);
151: FND_MSG_PUB.ADD;
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: EXCEPTION

Line 150: FND_MESSAGE.Set_Token('REMOVAL_CODE',l_code);

146: WHERE LOOKUP_TYPE = 'AHL_REMOVAL_CODE'
147: AND LOOKUP_CODE = l_setup_data_rec.REMOVAL_CODE;
148:
149: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_REMOVAL_CODE');
150: FND_MESSAGE.Set_Token('REMOVAL_CODE',l_code);
151: FND_MSG_PUB.ADD;
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN

Line 191: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

187: WHEN NO_DATA_FOUND THEN
188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
189: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Status Id Passed -- ERROR ... ' || l_setup_data_rec.STATUS_ID);
190: END IF;
191: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
192: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_SETUP_DATA');
193: FND_MSG_PUB.ADD;
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: END;

Line 192: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_SETUP_DATA');

188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
189: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Status Id Passed -- ERROR ... ' || l_setup_data_rec.STATUS_ID);
190: END IF;
191: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
192: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_SETUP_DATA');
193: FND_MSG_PUB.ADD;
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: END;
196:

Line 221: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

217: WHEN NO_DATA_FOUND THEN
218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
219: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Removal Code Passed -- ERROR ... ' || l_setup_data_rec.REMOVAL_CODE);
220: END IF;
221: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
222: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_SETUP_DATA');
223: FND_MSG_PUB.ADD;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END;

Line 222: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_SETUP_DATA');

218: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
219: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Removal Code Passed -- ERROR ... ' || l_setup_data_rec.REMOVAL_CODE);
220: END IF;
221: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
222: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_SETUP_DATA');
223: FND_MSG_PUB.ADD;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END;
226:

Line 416: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

412: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- RA SETUP ID :' || p_setup_data_rec.RA_SETUP_ID);
413: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OP FLAG :' || p_setup_data_rec.OPERATION_FLAG);
414: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || p_setup_data_rec.OBJECT_VERSION_NUMBER);
415: END IF;
416: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
417: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_SETUP_DATA');
418: FND_MSG_PUB.ADD;
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;

Line 417: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_SETUP_DATA');

413: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OP FLAG :' || p_setup_data_rec.OPERATION_FLAG);
414: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || p_setup_data_rec.OBJECT_VERSION_NUMBER);
415: END IF;
416: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
417: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_SETUP_DATA');
418: FND_MSG_PUB.ADD;
419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
420: END IF;
421:

Line 438: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

434: WHEN NO_DATA_FOUND THEN
435: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
436: fnd_log.string(fnd_log.level_statement,l_full_name,'-- DATA DOES NOT EXISTS -- ERROR ... ' || p_setup_data_rec.RA_SETUP_ID);
437: END IF;
438: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
439: FND_MSG_PUB.ADD;
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END;
442:

Line 451: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

447: IF p_setup_data_rec.OBJECT_VERSION_NUMBER <> l_obj_version_num THEN
448: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
449: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN passed : ' || p_setup_data_rec.OBJECT_VERSION_NUMBER);
450: END IF;
451: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
452: FND_MSG_PUB.ADD;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:

Line 590: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');

586: IF ((l_ra_def_hdr_rec.OPERATION_FLAG IS NULL) OR (l_ra_def_hdr_rec.OPERATION_FLAG <> G_DML_CREATE)) THEN
587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
588: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - OP Flag-');
589: END IF;
590: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
591: FND_MESSAGE.Set_Token('FIELD',l_ra_def_hdr_rec.OPERATION_FLAG);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;

Line 591: FND_MESSAGE.Set_Token('FIELD',l_ra_def_hdr_rec.OPERATION_FLAG);

587: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
588: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - OP Flag-');
589: END IF;
590: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
591: FND_MESSAGE.Set_Token('FIELD',l_ra_def_hdr_rec.OPERATION_FLAG);
592: FND_MSG_PUB.ADD;
593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
594: END IF;
595:

Line 612: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

608: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
609: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
610: END IF;
611:
612: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
613: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');
614: FND_MSG_PUB.ADD;
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: END IF;

Line 613: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');

609: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
610: END IF;
611:
612: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
613: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');
614: FND_MSG_PUB.ADD;
615: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
616: END IF;
617:

Line 637: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

633: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
634: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Validation Failed: MR_HEADER_ID --');
635: END IF;
636:
637: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
638: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');
639: FND_MSG_PUB.ADD;
640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
641: END;

Line 638: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');

634: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Validation Failed: MR_HEADER_ID --');
635: END IF;
636:
637: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
638: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');
639: FND_MSG_PUB.ADD;
640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
641: END;
642:

Line 663: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

659: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
660: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Validation Failed: RELATIONSHIP_ID --');
661: END IF;
662:
663: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
664: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END;

Line 664: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');

660: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Validation Failed: RELATIONSHIP_ID --');
661: END IF;
662:
663: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
664: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');
665: FND_MSG_PUB.ADD;
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END;
668:

Line 693: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

689: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
690: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Validation Failed: Item --');
691: END IF;
692:
693: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
694: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');
695: FND_MSG_PUB.ADD;
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END;

Line 694: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');

690: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Validation Failed: Item --');
691: END IF;
692:
693: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
694: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DATA');
695: FND_MSG_PUB.ADD;
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697: END;
698:

Line 716: FND_MESSAGE.Set_Name('AHL','AHL_RA_REL_DEF_EXISTS');

712: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
713: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Validation Failed: Uniqnuess Check --');
714: END IF;
715:
716: FND_MESSAGE.Set_Name('AHL','AHL_RA_REL_DEF_EXISTS');
717: FND_MSG_PUB.ADD;
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719:
720: EXCEPTION

Line 928: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');

924: IF ((p_reliability_data_rec.OPERATION_FLAG IS NULL) OR (p_reliability_data_rec.OPERATION_FLAG <> G_DML_DELETE)) THEN
925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
926: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
927: END IF;
928: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
929: FND_MESSAGE.Set_Token('FIELD', p_reliability_data_rec.OPERATION_FLAG);
930: FND_MSG_PUB.ADD;
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;

Line 929: FND_MESSAGE.Set_Token('FIELD', p_reliability_data_rec.OPERATION_FLAG);

925: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
926: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
927: END IF;
928: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
929: FND_MESSAGE.Set_Token('FIELD', p_reliability_data_rec.OPERATION_FLAG);
930: FND_MSG_PUB.ADD;
931: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
932: END IF;
933:

Line 943: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

939: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
940: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- RA_DEFINITION_HDR_ID :' || p_reliability_data_rec.RA_DEFINITION_HDR_ID);
941: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || p_reliability_data_rec.OBJECT_VERSION_NUMBER);
942: END IF;
943: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
944: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_RA_DEF_DATA');
945: FND_MSG_PUB.ADD;
946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947: END IF;

Line 944: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_RA_DEF_DATA');

940: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- RA_DEFINITION_HDR_ID :' || p_reliability_data_rec.RA_DEFINITION_HDR_ID);
941: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || p_reliability_data_rec.OBJECT_VERSION_NUMBER);
942: END IF;
943: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
944: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_RA_DEF_DATA');
945: FND_MSG_PUB.ADD;
946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
947: END IF;
948:

Line 970: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

966: WHEN NO_DATA_FOUND THEN
967: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
968: fnd_log.string(fnd_log.level_statement,l_full_name,'-- DATA DOES NOT EXISTS -- ERROR ... ' || p_reliability_data_rec.RA_DEFINITION_HDR_ID);
969: END IF;
970: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
971: FND_MSG_PUB.ADD;
972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
973: END;
974:

Line 983: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

979: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
980: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN passed : ' || p_reliability_data_rec.OBJECT_VERSION_NUMBER);
981: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN in db : ' || l_obj_version_num);
982: END IF;
983: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
984: FND_MSG_PUB.ADD;
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
986: END IF;
987:

Line 1137: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');

1133: IF ((l_ra_def_dtl_rec.OPERATION_FLAG IS NULL) OR (l_ra_def_dtl_rec.OPERATION_FLAG <> G_DML_CREATE)) THEN
1134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1135: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
1136: END IF;
1137: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
1138: FND_MESSAGE.Set_Token('FIELD',l_ra_def_dtl_rec.OPERATION_FLAG);
1139: FND_MSG_PUB.ADD;
1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: END IF;

Line 1138: FND_MESSAGE.Set_Token('FIELD',l_ra_def_dtl_rec.OPERATION_FLAG);

1134: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1135: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
1136: END IF;
1137: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
1138: FND_MESSAGE.Set_Token('FIELD',l_ra_def_dtl_rec.OPERATION_FLAG);
1139: FND_MSG_PUB.ADD;
1140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1141: END IF;
1142:

Line 1153: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

1149: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - COUNTER_ID -'||l_ra_def_dtl_rec.COUNTER_ID);
1150: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID -'||l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1151: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - OBJECT_VERSION_NUMBER -'||l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER);
1152: END IF;
1153: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1154: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DTL_DATA');
1155: FND_MSG_PUB.ADD;
1156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1157: END IF;

Line 1154: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DTL_DATA');

1150: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID -'||l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1151: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - OBJECT_VERSION_NUMBER -'||l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER);
1152: END IF;
1153: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1154: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DTL_DATA');
1155: FND_MSG_PUB.ADD;
1156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1157: END IF;
1158:

Line 1165: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

1161: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1162: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID MASTER-'||l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1163: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID CHILD-'||l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1164: END IF;
1165: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1166: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DTL_DATA');
1167: FND_MSG_PUB.ADD;
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: END IF;

Line 1166: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DTL_DATA');

1162: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID MASTER-'||l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1163: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID CHILD-'||l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1164: END IF;
1165: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1166: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DTL_DATA');
1167: FND_MSG_PUB.ADD;
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: END IF;
1170:

Line 1217: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

1213: WHEN NO_DATA_FOUND THEN
1214: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1215: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - COUNTER_ID -' || l_ra_def_dtl_rec.COUNTER_ID);
1216: END IF;
1217: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1218: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DTL_DATA');
1219: FND_MSG_PUB.ADD;
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END;

Line 1218: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DTL_DATA');

1214: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1215: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - COUNTER_ID -' || l_ra_def_dtl_rec.COUNTER_ID);
1216: END IF;
1217: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1218: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_RA_DEF_DTL_DATA');
1219: FND_MSG_PUB.ADD;
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END;
1222:

Line 1228: FND_MESSAGE.Set_Name('AHL','AHL_RA_MTBF_INV');

1224: IF(l_ra_def_dtl_rec.MTBF_VALUE IS NOT NULL and l_ra_def_dtl_rec.MTBF_VALUE < 0) THEN
1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1226: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - MTBF_VALUE -'||l_ra_def_dtl_rec.MTBF_VALUE);
1227: END IF;
1228: FND_MESSAGE.Set_Name('AHL','AHL_RA_MTBF_INV');
1229: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);
1230: FND_MESSAGE.Set_Token('MTBF', l_ra_def_dtl_rec.MTBF_VALUE);
1231: FND_MSG_PUB.ADD;
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1229: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);

1225: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1226: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - MTBF_VALUE -'||l_ra_def_dtl_rec.MTBF_VALUE);
1227: END IF;
1228: FND_MESSAGE.Set_Name('AHL','AHL_RA_MTBF_INV');
1229: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);
1230: FND_MESSAGE.Set_Token('MTBF', l_ra_def_dtl_rec.MTBF_VALUE);
1231: FND_MSG_PUB.ADD;
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;

Line 1230: FND_MESSAGE.Set_Token('MTBF', l_ra_def_dtl_rec.MTBF_VALUE);

1226: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - MTBF_VALUE -'||l_ra_def_dtl_rec.MTBF_VALUE);
1227: END IF;
1228: FND_MESSAGE.Set_Name('AHL','AHL_RA_MTBF_INV');
1229: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);
1230: FND_MESSAGE.Set_Token('MTBF', l_ra_def_dtl_rec.MTBF_VALUE);
1231: FND_MSG_PUB.ADD;
1232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1233: END IF;
1234:

Line 1249: FND_MESSAGE.Set_Name('AHL','AHL_RA_REL_DTL_EXISTS');

1245: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1246: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Duplicate exists - COUNTER_ID -' || l_ra_def_dtl_rec.COUNTER_ID);
1247: END IF;
1248:
1249: FND_MESSAGE.Set_Name('AHL','AHL_RA_REL_DTL_EXISTS');
1250: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253:

Line 1250: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);

1246: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Duplicate exists - COUNTER_ID -' || l_ra_def_dtl_rec.COUNTER_ID);
1247: END IF;
1248:
1249: FND_MESSAGE.Set_Name('AHL','AHL_RA_REL_DTL_EXISTS');
1250: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253:
1254: EXCEPTION

Line 1278: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

1274: WHEN NO_DATA_FOUND THEN
1275: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1276: fnd_log.string(fnd_log.level_statement,l_full_name,'-- DATA DOES NOT EXISTS -- ERROR ... ' || l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1277: END IF;
1278: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
1279: FND_MSG_PUB.ADD;
1280: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1281: END;
1282:

Line 1291: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

1287: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1288: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN passed : ' || l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER);
1289: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN in db : ' || l_m_obj_version_num);
1290: END IF;
1291: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1292: FND_MSG_PUB.ADD;
1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295:

Line 1527: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');

1523:
1524: IF ((l_ra_def_dtl_rec.OPERATION_FLAG IS NULL) OR (l_ra_def_dtl_rec.OPERATION_FLAG <> G_DML_UPDATE)) THEN
1525: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1526: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
1527: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
1528: FND_MESSAGE.Set_Token('FIELD',l_ra_def_dtl_rec.OPERATION_FLAG);
1529: FND_MSG_PUB.ADD;
1530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1531: END IF;

Line 1528: FND_MESSAGE.Set_Token('FIELD',l_ra_def_dtl_rec.OPERATION_FLAG);

1524: IF ((l_ra_def_dtl_rec.OPERATION_FLAG IS NULL) OR (l_ra_def_dtl_rec.OPERATION_FLAG <> G_DML_UPDATE)) THEN
1525: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1526: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
1527: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
1528: FND_MESSAGE.Set_Token('FIELD',l_ra_def_dtl_rec.OPERATION_FLAG);
1529: FND_MSG_PUB.ADD;
1530: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1531: END IF;
1532: END IF;

Line 1542: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

1538: l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER = FND_API.G_MISS_NUM OR
1539: l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID = FND_API.G_MISS_NUM OR
1540: l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID = FND_API.G_MISS_NUM OR
1541: (l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID IS NULL AND l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID IS NULL)) THEN
1542: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1543: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_RA_DEF_DTL_DATA');
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546: END IF;

Line 1543: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_RA_DEF_DTL_DATA');

1539: l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID = FND_API.G_MISS_NUM OR
1540: l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID = FND_API.G_MISS_NUM OR
1541: (l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID IS NULL AND l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID IS NULL)) THEN
1542: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1543: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_RA_DEF_DTL_DATA');
1544: FND_MSG_PUB.ADD;
1545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1546: END IF;
1547:

Line 1555: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

1551: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1552: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID MASTER-'||l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1553: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID CHILD-'||l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1554: END IF;
1555: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1556: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_RA_DEF_DTL_DATA');
1557: FND_MSG_PUB.ADD;
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559: END IF;

Line 1556: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_RA_DEF_DTL_DATA');

1552: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID MASTER-'||l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1553: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID CHILD-'||l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1554: END IF;
1555: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1556: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_RA_DEF_DTL_DATA');
1557: FND_MSG_PUB.ADD;
1558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1559: END IF;
1560:

Line 1578: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

1574: OPEN get_mtbf_data_cur(l_ra_def_dtl_rec.RA_DEFINITION_DTL_ID);
1575: FETCH get_mtbf_data_cur INTO l_mtbf_data_old_rec;
1576: IF(get_mtbf_data_cur%NOTFOUND) THEN
1577: CLOSE get_mtbf_data_cur;
1578: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
1579: FND_MSG_PUB.ADD;
1580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1581: END IF;
1582: CLOSE get_mtbf_data_cur;

Line 1588: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

1584: IF(l_mtbf_data_old_rec.OBJECT_VERSION_NUMBER <> l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER) THEN
1585: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1586: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN passed : ' || l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER);
1587: END IF;
1588: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1589: FND_MSG_PUB.ADD;
1590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1591: END IF;
1592:

Line 1662: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

1658: WHEN NO_DATA_FOUND THEN
1659: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1660: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - COUNTER_ID -' || l_ra_def_dtl_rec.COUNTER_ID);
1661: END IF;
1662: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1663: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_RA_DEF_DTL_DATA');
1664: FND_MSG_PUB.ADD;
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: END;

Line 1663: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_RA_DEF_DTL_DATA');

1659: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1660: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - COUNTER_ID -' || l_ra_def_dtl_rec.COUNTER_ID);
1661: END IF;
1662: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1663: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_RA_DEF_DTL_DATA');
1664: FND_MSG_PUB.ADD;
1665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1666: END;
1667:

Line 1670: FND_MESSAGE.Set_Name('AHL','AHL_RA_MTBF_INV');

1666: END;
1667:
1668: --MTBF should be >= 0 if not null
1669: IF(l_ra_def_dtl_rec.MTBF_VALUE IS NOT NULL AND l_ra_def_dtl_rec.MTBF_VALUE < 0) THEN
1670: FND_MESSAGE.Set_Name('AHL','AHL_RA_MTBF_INV');
1671: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);
1672: FND_MESSAGE.Set_Token('MTBF', l_ra_def_dtl_rec.MTBF_VALUE);
1673: FND_MSG_PUB.ADD;
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1671: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);

1667:
1668: --MTBF should be >= 0 if not null
1669: IF(l_ra_def_dtl_rec.MTBF_VALUE IS NOT NULL AND l_ra_def_dtl_rec.MTBF_VALUE < 0) THEN
1670: FND_MESSAGE.Set_Name('AHL','AHL_RA_MTBF_INV');
1671: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);
1672: FND_MESSAGE.Set_Token('MTBF', l_ra_def_dtl_rec.MTBF_VALUE);
1673: FND_MSG_PUB.ADD;
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;

Line 1672: FND_MESSAGE.Set_Token('MTBF', l_ra_def_dtl_rec.MTBF_VALUE);

1668: --MTBF should be >= 0 if not null
1669: IF(l_ra_def_dtl_rec.MTBF_VALUE IS NOT NULL AND l_ra_def_dtl_rec.MTBF_VALUE < 0) THEN
1670: FND_MESSAGE.Set_Name('AHL','AHL_RA_MTBF_INV');
1671: FND_MESSAGE.Set_Token('COUNTER',l_cou_name);
1672: FND_MESSAGE.Set_Token('MTBF', l_ra_def_dtl_rec.MTBF_VALUE);
1673: FND_MSG_PUB.ADD;
1674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1675: END IF;
1676:

Line 1694: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

1690: WHEN NO_DATA_FOUND THEN
1691: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1692: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Master DATA DOES NOT EXISTS -- ERROR ... ' || l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1693: END IF;
1694: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
1695: FND_MSG_PUB.ADD;
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: END;
1698:

Line 1707: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

1703: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1704: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Master Record has changed : OVN passed : ' || l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER);
1705: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Master Record has changed : OVN in db : ' || l_m_obj_version_num);
1706: END IF;
1707: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1708: FND_MSG_PUB.ADD;
1709: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711:

Line 1889: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');

1885: --Validate the Operation Flag
1886: IF ((l_ra_def_dtl_rec.OPERATION_FLAG IS NULL) OR (l_ra_def_dtl_rec.OPERATION_FLAG <> G_DML_DELETE)) THEN
1887: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1888: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
1889: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
1890: FND_MESSAGE.Set_Token('FIELD',l_ra_def_dtl_rec.OPERATION_FLAG);
1891: FND_MSG_PUB.ADD;
1892: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1893: END IF;

Line 1890: FND_MESSAGE.Set_Token('FIELD',l_ra_def_dtl_rec.OPERATION_FLAG);

1886: IF ((l_ra_def_dtl_rec.OPERATION_FLAG IS NULL) OR (l_ra_def_dtl_rec.OPERATION_FLAG <> G_DML_DELETE)) THEN
1887: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1888: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
1889: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
1890: FND_MESSAGE.Set_Token('FIELD',l_ra_def_dtl_rec.OPERATION_FLAG);
1891: FND_MSG_PUB.ADD;
1892: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1893: END IF;
1894: END IF;

Line 1908: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

1904: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER);
1905: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- Master RA_DEFINITION_HDR_ID :' || l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1906: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- Detail RA_DEFINITION_HDR_ID:' || l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1907: END IF;
1908: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1909: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_RA_DEF_DET_DATA');
1910: FND_MSG_PUB.ADD;
1911: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1912: END IF;

Line 1909: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_RA_DEF_DET_DATA');

1905: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- Master RA_DEFINITION_HDR_ID :' || l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1906: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- Detail RA_DEFINITION_HDR_ID:' || l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1907: END IF;
1908: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1909: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_RA_DEF_DET_DATA');
1910: FND_MSG_PUB.ADD;
1911: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1912: END IF;
1913:

Line 1921: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

1917: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1918: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID MASTER-'||l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1919: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID CHILD-'||l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1920: END IF;
1921: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1922: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_RA_DEF_DTL_DATA');
1923: FND_MSG_PUB.ADD;
1924: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1925: END IF;

Line 1922: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_RA_DEF_DTL_DATA');

1918: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID MASTER-'||l_ra_def_hdr_rec.RA_DEFINITION_HDR_ID);
1919: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - RA_DEFINITION_HDR_ID CHILD-'||l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1920: END IF;
1921: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
1922: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_RA_DEF_DTL_DATA');
1923: FND_MSG_PUB.ADD;
1924: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1925: END IF;
1926:

Line 1955: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

1951: WHEN NO_DATA_FOUND THEN
1952: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1953: fnd_log.string(fnd_log.level_statement,l_full_name,'-- DATA DOES NOT EXISTS -- ERROR ... ' || l_ra_def_dtl_rec.RA_DEFINITION_DTL_ID);
1954: END IF;
1955: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
1956: FND_MSG_PUB.ADD;
1957: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1958: END;
1959:

Line 1966: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

1962: IF l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER <> l_obj_version_num THEN
1963: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1964: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN passed : ' || l_ra_def_dtl_rec.OBJECT_VERSION_NUMBER);
1965: END IF;
1966: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1967: FND_MSG_PUB.ADD;
1968: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1969: END IF;
1970:

Line 1988: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

1984: WHEN NO_DATA_FOUND THEN
1985: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1986: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Master DATA DOES NOT EXISTS -- ERROR ... ' || l_ra_def_dtl_rec.RA_DEFINITION_HDR_ID);
1987: END IF;
1988: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
1989: FND_MSG_PUB.ADD;
1990: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1991: END;
1992:

Line 2001: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

1997: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1998: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Master Record has changed : OVN passed : ' || l_ra_def_hdr_rec.OBJECT_VERSION_NUMBER);
1999: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Master Record has changed : OVN in db : ' || l_m_obj_version_num);
2000: END IF;
2001: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2002: FND_MSG_PUB.ADD;
2003: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2004: END IF;
2005:

Line 2154: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');

2150: IF ((l_counter_assoc_rec.OPERATION_FLAG IS NULL) OR (l_counter_assoc_rec.OPERATION_FLAG <> G_DML_CREATE)) THEN
2151: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2152: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
2153: END IF;
2154: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
2155: FND_MESSAGE.Set_Token('FIELD',l_counter_assoc_rec.OPERATION_FLAG);
2156: FND_MSG_PUB.ADD;
2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2158: END IF;

Line 2155: FND_MESSAGE.Set_Token('FIELD',l_counter_assoc_rec.OPERATION_FLAG);

2151: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2152: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
2153: END IF;
2154: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
2155: FND_MESSAGE.Set_Token('FIELD',l_counter_assoc_rec.OPERATION_FLAG);
2156: FND_MSG_PUB.ADD;
2157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2158: END IF;
2159:

Line 2162: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

2158: END IF;
2159:
2160: --Mandatory validation for the Since New Counter
2161: IF(l_counter_assoc_rec.SINCE_NEW_COUNTER_ID is null) THEN
2162: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2163: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_COU_DATA');
2164: FND_MSG_PUB.ADD;
2165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2166: END IF;

Line 2163: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_COU_DATA');

2159:
2160: --Mandatory validation for the Since New Counter
2161: IF(l_counter_assoc_rec.SINCE_NEW_COUNTER_ID is null) THEN
2162: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2163: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_COU_DATA');
2164: FND_MSG_PUB.ADD;
2165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2166: END IF;
2167:

Line 2196: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

2192: WHEN NO_DATA_FOUND THEN
2193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2194: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - SINCE_NEW_COUNTER_ID -' || l_counter_assoc_rec.SINCE_NEW_COUNTER_ID);
2195: END IF;
2196: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2197: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_COU_DATA');
2198: FND_MSG_PUB.ADD;
2199: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2200: END;

Line 2197: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_COU_DATA');

2193: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2194: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - SINCE_NEW_COUNTER_ID -' || l_counter_assoc_rec.SINCE_NEW_COUNTER_ID);
2195: END IF;
2196: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2197: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_COU_DATA');
2198: FND_MSG_PUB.ADD;
2199: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2200: END;
2201:

Line 2230: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

2226: WHEN NO_DATA_FOUND THEN
2227: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2228: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - SINCE_OVERHAUL_COUNTER_ID -' || l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID);
2229: END IF;
2230: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2231: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_COU_DATA');
2232: FND_MSG_PUB.ADD;
2233: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2234: END;

Line 2231: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_COU_DATA');

2227: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2228: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - SINCE_OVERHAUL_COUNTER_ID -' || l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID);
2229: END IF;
2230: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2231: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_COU_DATA');
2232: FND_MSG_PUB.ADD;
2233: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2234: END;
2235: END IF;

Line 2241: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_OHAUL_COU_SAME');

2237:
2238: --A since counter cannot be declared new and overhaul at the same time
2239: IF(l_counter_assoc_rec.SINCE_NEW_COUNTER_ID IS NOT NULL AND l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID IS NOT NULL) THEN
2240: IF(l_counter_assoc_rec.SINCE_NEW_COUNTER_ID = l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID) THEN
2241: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_OHAUL_COU_SAME');
2242: FND_MESSAGE.Set_Token('COUNTER', l_new_cou_name);
2243: FND_MSG_PUB.ADD;
2244: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2245: END IF;

Line 2242: FND_MESSAGE.Set_Token('COUNTER', l_new_cou_name);

2238: --A since counter cannot be declared new and overhaul at the same time
2239: IF(l_counter_assoc_rec.SINCE_NEW_COUNTER_ID IS NOT NULL AND l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID IS NOT NULL) THEN
2240: IF(l_counter_assoc_rec.SINCE_NEW_COUNTER_ID = l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID) THEN
2241: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_OHAUL_COU_SAME');
2242: FND_MESSAGE.Set_Token('COUNTER', l_new_cou_name);
2243: FND_MSG_PUB.ADD;
2244: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2245: END IF;
2246: END IF;

Line 2253: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_OHAUL_UOM_DIFF');

2249: --The check below makes sense only when there is a overhaul counter defined in the association.
2250: IF(l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID IS NOT NULL) THEN
2251: IF(l_new_cou_uom IS NOT NULL and l_overhaul_cou_uom IS NOT NULL) THEN
2252: IF(l_new_cou_uom <> l_overhaul_cou_uom) THEN
2253: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_OHAUL_UOM_DIFF');
2254: FND_MESSAGE.Set_Token('NEW_COUNTER', l_new_cou_name);
2255: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);
2256: FND_MESSAGE.Set_Token('NEW_COU_UOM', l_new_cou_uom);
2257: FND_MESSAGE.Set_Token('OHAUL_COU_UOM', l_overhaul_cou_uom);

Line 2254: FND_MESSAGE.Set_Token('NEW_COUNTER', l_new_cou_name);

2250: IF(l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID IS NOT NULL) THEN
2251: IF(l_new_cou_uom IS NOT NULL and l_overhaul_cou_uom IS NOT NULL) THEN
2252: IF(l_new_cou_uom <> l_overhaul_cou_uom) THEN
2253: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_OHAUL_UOM_DIFF');
2254: FND_MESSAGE.Set_Token('NEW_COUNTER', l_new_cou_name);
2255: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);
2256: FND_MESSAGE.Set_Token('NEW_COU_UOM', l_new_cou_uom);
2257: FND_MESSAGE.Set_Token('OHAUL_COU_UOM', l_overhaul_cou_uom);
2258: FND_MSG_PUB.ADD;

Line 2255: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);

2251: IF(l_new_cou_uom IS NOT NULL and l_overhaul_cou_uom IS NOT NULL) THEN
2252: IF(l_new_cou_uom <> l_overhaul_cou_uom) THEN
2253: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_OHAUL_UOM_DIFF');
2254: FND_MESSAGE.Set_Token('NEW_COUNTER', l_new_cou_name);
2255: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);
2256: FND_MESSAGE.Set_Token('NEW_COU_UOM', l_new_cou_uom);
2257: FND_MESSAGE.Set_Token('OHAUL_COU_UOM', l_overhaul_cou_uom);
2258: FND_MSG_PUB.ADD;
2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2256: FND_MESSAGE.Set_Token('NEW_COU_UOM', l_new_cou_uom);

2252: IF(l_new_cou_uom <> l_overhaul_cou_uom) THEN
2253: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_OHAUL_UOM_DIFF');
2254: FND_MESSAGE.Set_Token('NEW_COUNTER', l_new_cou_name);
2255: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);
2256: FND_MESSAGE.Set_Token('NEW_COU_UOM', l_new_cou_uom);
2257: FND_MESSAGE.Set_Token('OHAUL_COU_UOM', l_overhaul_cou_uom);
2258: FND_MSG_PUB.ADD;
2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2260: END IF;

Line 2257: FND_MESSAGE.Set_Token('OHAUL_COU_UOM', l_overhaul_cou_uom);

2253: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_OHAUL_UOM_DIFF');
2254: FND_MESSAGE.Set_Token('NEW_COUNTER', l_new_cou_name);
2255: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);
2256: FND_MESSAGE.Set_Token('NEW_COU_UOM', l_new_cou_uom);
2257: FND_MESSAGE.Set_Token('OHAUL_COU_UOM', l_overhaul_cou_uom);
2258: FND_MSG_PUB.ADD;
2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2260: END IF;
2261: END IF;

Line 2277: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_COU_DEF_OHAUL');

2273: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2274: fnd_log.string(fnd_log.level_statement,l_full_name,'Validation Failure: This since new counter is already declared as overhaul - SINCE_NEW_COUNTER_ID -' || l_counter_assoc_rec.SINCE_NEW_COUNTER_ID);
2275: END IF;
2276:
2277: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_COU_DEF_OHAUL');
2278: FND_MESSAGE.Set_Token('COUNTER', l_new_cou_name);
2279: FND_MSG_PUB.ADD;
2280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2281:

Line 2278: FND_MESSAGE.Set_Token('COUNTER', l_new_cou_name);

2274: fnd_log.string(fnd_log.level_statement,l_full_name,'Validation Failure: This since new counter is already declared as overhaul - SINCE_NEW_COUNTER_ID -' || l_counter_assoc_rec.SINCE_NEW_COUNTER_ID);
2275: END IF;
2276:
2277: FND_MESSAGE.Set_Name('AHL','AHL_RA_NEW_COU_DEF_OHAUL');
2278: FND_MESSAGE.Set_Token('COUNTER', l_new_cou_name);
2279: FND_MSG_PUB.ADD;
2280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2281:
2282: EXCEPTION

Line 2303: FND_MESSAGE.Set_Name('AHL','AHL_RA_OHAUL_COU_DEF_NEW');

2299: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2300: fnd_log.string(fnd_log.level_statement,l_full_name,'--Validation Failure: This since new counter is already declared as overhaul - SINCE_OVERHAUL_COUNTER_ID -' || l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID);
2301: END IF;
2302:
2303: FND_MESSAGE.Set_Name('AHL','AHL_RA_OHAUL_COU_DEF_NEW');
2304: FND_MESSAGE.Set_Token('COUNTER', l_overhaul_cou_name);
2305: FND_MSG_PUB.ADD;
2306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2307:

Line 2304: FND_MESSAGE.Set_Token('COUNTER', l_overhaul_cou_name);

2300: fnd_log.string(fnd_log.level_statement,l_full_name,'--Validation Failure: This since new counter is already declared as overhaul - SINCE_OVERHAUL_COUNTER_ID -' || l_counter_assoc_rec.SINCE_OVERHAUL_COUNTER_ID);
2301: END IF;
2302:
2303: FND_MESSAGE.Set_Name('AHL','AHL_RA_OHAUL_COU_DEF_NEW');
2304: FND_MESSAGE.Set_Token('COUNTER', l_overhaul_cou_name);
2305: FND_MSG_PUB.ADD;
2306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2307:
2308: EXCEPTION

Line 2331: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_COU_ASSOC');

2327: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2328: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Validation Failuure: Duplicate Counter Association exists-- SINCE_NEW_COUNTER_NAME - '|| l_new_cou_name ||'- SINCE_OVERHAUL_COUNTER_NAME -' || l_overhaul_cou_name);
2329: END IF;
2330:
2331: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_COU_ASSOC');
2332: FND_MESSAGE.Set_Token('NEW_COUNTER',l_new_cou_name );
2333: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);
2334: FND_MSG_PUB.ADD;
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2332: FND_MESSAGE.Set_Token('NEW_COUNTER',l_new_cou_name );

2328: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Validation Failuure: Duplicate Counter Association exists-- SINCE_NEW_COUNTER_NAME - '|| l_new_cou_name ||'- SINCE_OVERHAUL_COUNTER_NAME -' || l_overhaul_cou_name);
2329: END IF;
2330:
2331: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_COU_ASSOC');
2332: FND_MESSAGE.Set_Token('NEW_COUNTER',l_new_cou_name );
2333: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);
2334: FND_MSG_PUB.ADD;
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336:

Line 2333: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);

2329: END IF;
2330:
2331: FND_MESSAGE.Set_Name('AHL','AHL_RA_DUP_COU_ASSOC');
2332: FND_MESSAGE.Set_Token('NEW_COUNTER',l_new_cou_name );
2333: FND_MESSAGE.Set_Token('OHAUL_COUNTER', l_overhaul_cou_name);
2334: FND_MSG_PUB.ADD;
2335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2336:
2337: EXCEPTION

Line 2546: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');

2542: IF ((p_counter_assoc_rec.OPERATION_FLAG IS NULL) OR (p_counter_assoc_rec.OPERATION_FLAG <> G_DML_DELETE)) THEN
2543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2544: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
2545: END IF;
2546: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
2547: FND_MESSAGE.Set_Token('FIELD',p_counter_assoc_rec.OPERATION_FLAG);
2548: FND_MSG_PUB.ADD;
2549: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2550: END IF;

Line 2547: FND_MESSAGE.Set_Token('FIELD',p_counter_assoc_rec.OPERATION_FLAG);

2543: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2544: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed --');
2545: END IF;
2546: FND_MESSAGE.Set_Name('AHL','AHL_COM_INVALID_DML_REC');
2547: FND_MESSAGE.Set_Token('FIELD',p_counter_assoc_rec.OPERATION_FLAG);
2548: FND_MSG_PUB.ADD;
2549: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2550: END IF;
2551:

Line 2561: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

2557: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2558: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- RA_COUNTER_ASSOCIATION_ID :' || p_counter_assoc_rec.RA_COUNTER_ASSOCIATION_ID);
2559: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || p_counter_assoc_rec.OBJECT_VERSION_NUMBER);
2560: END IF;
2561: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2562: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_COU_DATA');
2563: FND_MSG_PUB.ADD;
2564: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2565: END IF;

Line 2562: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_COU_DATA');

2558: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- RA_COUNTER_ASSOCIATION_ID :' || p_counter_assoc_rec.RA_COUNTER_ASSOCIATION_ID);
2559: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || p_counter_assoc_rec.OBJECT_VERSION_NUMBER);
2560: END IF;
2561: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2562: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_COU_DATA');
2563: FND_MSG_PUB.ADD;
2564: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2565: END IF;
2566:

Line 2584: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

2580: WHEN NO_DATA_FOUND THEN
2581: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2582: fnd_log.string(fnd_log.level_statement,l_full_name,'-- DATA DOES NOT EXISTS -- ERROR ... ' || p_counter_assoc_rec.RA_COUNTER_ASSOCIATION_ID);
2583: END IF;
2584: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
2585: FND_MSG_PUB.ADD;
2586: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2587: END;
2588:

Line 2595: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

2591: IF p_counter_assoc_rec.OBJECT_VERSION_NUMBER <> l_obj_version_num THEN
2592: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2593: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN passed : ' || p_counter_assoc_rec.OBJECT_VERSION_NUMBER);
2594: END IF;
2595: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
2596: FND_MSG_PUB.ADD;
2597: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2598: END IF;
2599:

Line 2743: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

2739: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.ASSOCIATION_TYPE_CODE -- '||l_fct_assoc_rec.ASSOCIATION_TYPE_CODE);
2740: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.OPERATION_FLAG --------- '||l_fct_assoc_rec.OPERATION_FLAG);
2741: END IF;
2742:
2743: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2744: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_FCT_DATA');
2745: FND_MSG_PUB.ADD;
2746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2747:

Line 2744: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_FCT_DATA');

2740: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.OPERATION_FLAG --------- '||l_fct_assoc_rec.OPERATION_FLAG);
2741: END IF;
2742:
2743: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2744: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_FCT_DATA');
2745: FND_MSG_PUB.ADD;
2746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2747:
2748: END IF;

Line 2758: FND_MESSAGE.Set_Name('AHL','AHL_RA_HIST_PROB_NULL');

2754: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_FROM ------- '||l_fct_assoc_rec.PROBABILITY_FROM);
2755: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_TO --------- '||l_fct_assoc_rec.PROBABILITY_TO);
2756: END IF;
2757:
2758: FND_MESSAGE.Set_Name('AHL','AHL_RA_HIST_PROB_NULL');
2759: FND_MSG_PUB.ADD;
2760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2761:
2762: END IF;

Line 2788: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

2784: WHEN NO_DATA_FOUND THEN
2785: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2786: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - ORGANIZATION_ID -' || l_fct_assoc_rec.ORGANIZATION_ID);
2787: END IF;
2788: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2789: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_FCT_DATA');
2790: FND_MSG_PUB.ADD;
2791: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2792: END;

Line 2789: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_FCT_DATA');

2785: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2786: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - ORGANIZATION_ID -' || l_fct_assoc_rec.ORGANIZATION_ID);
2787: END IF;
2788: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2789: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_FCT_DATA');
2790: FND_MSG_PUB.ADD;
2791: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
2792: END;
2793:

Line 2815: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

2811: WHEN NO_DATA_FOUND THEN
2812: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2813: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - FORECAST_DESIGNATOR -' || l_fct_assoc_rec.FORECAST_DESIGNATOR);
2814: END IF;
2815: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2816: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_FCT_DATA');
2817: FND_MSG_PUB.ADD;
2818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2819: END;

Line 2816: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_FCT_DATA');

2812: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2813: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - FORECAST_DESIGNATOR -' || l_fct_assoc_rec.FORECAST_DESIGNATOR);
2814: END IF;
2815: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
2816: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.C_FCT_DATA');
2817: FND_MSG_PUB.ADD;
2818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2819: END;
2820:

Line 2841: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_VALID_RANGE');

2837: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_FROM ------- '||l_fct_assoc_rec.PROBABILITY_FROM);
2838: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_TO --------- '||l_fct_assoc_rec.PROBABILITY_TO);
2839: END IF;
2840:
2841: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_VALID_RANGE');
2842: FND_MSG_PUB.ADD;
2843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2844: END IF;
2845:

Line 2855: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_RELATIONSHIP');

2851: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_FROM ------- '||l_fct_assoc_rec.PROBABILITY_FROM);
2852: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_TO --------- '||l_fct_assoc_rec.PROBABILITY_TO);
2853: END IF;
2854:
2855: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_RELATIONSHIP');
2856: FND_MSG_PUB.ADD;
2857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2858: END IF;
2859:

Line 2885: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_OVERLAP');

2881: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_FROM ------- '||l_fct_assoc_rec.PROBABILITY_FROM);
2882: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_TO --------- '||l_fct_assoc_rec.PROBABILITY_TO);
2883: END IF;
2884:
2885: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_OVERLAP');
2886: FND_MSG_PUB.ADD;
2887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2888:
2889: EXCEPTION

Line 2915: FND_MESSAGE.Set_Name('AHL','AHL_RA_FCT_ASSOC_MTBF_DUP');

2911: fnd_log.stRING(FND_LOG.Level_statement,l_full_name,'-- l_fct_assoc_rec.ORGANIZATION_ID ------- '||l_fct_assoc_rec.ORGANIZATION_ID);
2912: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.FORECAST_DESIGNATOR --------- '||l_fct_assoc_rec.FORECAST_DESIGNATOR);
2913: END IF;
2914:
2915: FND_MESSAGE.Set_Name('AHL','AHL_RA_FCT_ASSOC_MTBF_DUP');
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2918:
2919: EXCEPTION

Line 3142: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

3138: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- RA_FCT_ASSOCIATION_ID :' || l_fct_assoc_rec.RA_FCT_ASSOCIATION_ID);
3139: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OP FLAG :' || l_fct_assoc_rec.OPERATION_FLAG);
3140: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || l_fct_assoc_rec.OBJECT_VERSION_NUMBER);
3141: END IF;
3142: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3143: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCST_DATA');
3144: FND_MSG_PUB.ADD;
3145: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3146: END IF;

Line 3143: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCST_DATA');

3139: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OP FLAG :' || l_fct_assoc_rec.OPERATION_FLAG);
3140: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || l_fct_assoc_rec.OBJECT_VERSION_NUMBER);
3141: END IF;
3142: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3143: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCST_DATA');
3144: FND_MSG_PUB.ADD;
3145: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3146: END IF;
3147:

Line 3185: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

3181: WHEN NO_DATA_FOUND THEN
3182: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3183: fnd_log.string(fnd_log.level_statement,l_full_name,'-- DATA DOES NOT EXISTS -- ERROR ... ' || l_fct_assoc_rec.RA_FCT_ASSOCIATION_ID);
3184: END IF;
3185: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
3186: FND_MSG_PUB.ADD;
3187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3188: END;
3189:

Line 3197: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

3193: IF l_fct_assoc_rec.OBJECT_VERSION_NUMBER <> l_obj_version_num THEN
3194: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3195: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN passed : ' || l_fct_assoc_rec.OBJECT_VERSION_NUMBER);
3196: END IF;
3197: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
3198: FND_MSG_PUB.ADD;
3199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3200: END IF;
3201:

Line 3219: FND_MESSAGE.Set_Name('AHL','AHL_RA_HIST_PROB_NULL');

3215: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_FROM ------- '||l_fct_assoc_rec.PROBABILITY_FROM);
3216: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_TO --------- '||l_fct_assoc_rec.PROBABILITY_TO);
3217: END IF;
3218:
3219: FND_MESSAGE.Set_Name('AHL','AHL_RA_HIST_PROB_NULL');
3220: FND_MSG_PUB.ADD;
3221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3222:
3223: END IF;

Line 3241: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

3237: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.ASSOCIATION_TYPE_CODE -- '||l_fct_assoc_rec.ASSOCIATION_TYPE_CODE);
3238: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.OPERATION_FLAG --------- '||l_fct_assoc_rec.OPERATION_FLAG);
3239: END IF;
3240:
3241: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3242: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCT_DATA');
3243: FND_MSG_PUB.ADD;
3244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3245:

Line 3242: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCT_DATA');

3238: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.OPERATION_FLAG --------- '||l_fct_assoc_rec.OPERATION_FLAG);
3239: END IF;
3240:
3241: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3242: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCT_DATA');
3243: FND_MSG_PUB.ADD;
3244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3245:
3246: END IF;

Line 3271: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

3267: WHEN NO_DATA_FOUND THEN
3268: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3269: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - ORGANIZATION_ID -' || l_fct_assoc_rec.ORGANIZATION_ID);
3270: END IF;
3271: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3272: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCT_DATA');
3273: FND_MSG_PUB.ADD;
3274: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3275: END;

Line 3272: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCT_DATA');

3268: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3269: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - ORGANIZATION_ID -' || l_fct_assoc_rec.ORGANIZATION_ID);
3270: END IF;
3271: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3272: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCT_DATA');
3273: FND_MSG_PUB.ADD;
3274: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3275: END;
3276:

Line 3298: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

3294: WHEN NO_DATA_FOUND THEN
3295: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3296: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - FORECAST_DESIGNATOR -' || l_fct_assoc_rec.FORECAST_DESIGNATOR);
3297: END IF;
3298: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3299: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCT_DATA');
3300: FND_MSG_PUB.ADD;
3301: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3302: END;

Line 3299: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCT_DATA');

3295: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3296: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed - FORECAST_DESIGNATOR -' || l_fct_assoc_rec.FORECAST_DESIGNATOR);
3297: END IF;
3298: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3299: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.U_FCT_DATA');
3300: FND_MSG_PUB.ADD;
3301: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3302: END;
3303:

Line 3324: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_VALID_RANGE');

3320: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_FROM ------- '||l_fct_assoc_rec.PROBABILITY_FROM);
3321: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_TO --------- '||l_fct_assoc_rec.PROBABILITY_TO);
3322: END IF;
3323:
3324: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_VALID_RANGE');
3325: FND_MSG_PUB.ADD;
3326: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3327: END IF;
3328:

Line 3338: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_RELATIONSHIP');

3334: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_FROM ------- '||l_fct_assoc_rec.PROBABILITY_FROM);
3335: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_TO --------- '||l_fct_assoc_rec.PROBABILITY_TO);
3336: END IF;
3337:
3338: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_RELATIONSHIP');
3339: FND_MSG_PUB.ADD;
3340: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3341: END IF;
3342:

Line 3369: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_OVERLAP');

3365: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_FROM ------- '||l_fct_assoc_rec.PROBABILITY_FROM);
3366: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.PROBABILITY_TO --------- '||l_fct_assoc_rec.PROBABILITY_TO);
3367: END IF;
3368:
3369: FND_MESSAGE.Set_Name('AHL','AHL_RA_PROB_OVERLAP');
3370: FND_MSG_PUB.ADD;
3371: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3372:
3373: EXCEPTION

Line 3401: FND_MESSAGE.Set_Name('AHL','AHL_RA_FCT_ASSOC_MTBF_DUP');

3397: fnd_log.stRING(FND_LOG.Level_statement,l_full_name,'-- l_fct_assoc_rec.ORGANIZATION_ID ------- '||l_fct_assoc_rec.ORGANIZATION_ID);
3398: fnd_log.string(fnd_log.level_statement,l_full_name,'-- l_fct_assoc_rec.FORECAST_DESIGNATOR --------- '||l_fct_assoc_rec.FORECAST_DESIGNATOR);
3399: END IF;
3400:
3401: FND_MESSAGE.Set_Name('AHL','AHL_RA_FCT_ASSOC_MTBF_DUP');
3402: FND_MSG_PUB.ADD;
3403: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3404:
3405: EXCEPTION

Line 3590: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');

3586: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- RA_FCT_ASSOCIATION_ID :' || p_fct_assoc_rec.RA_FCT_ASSOCIATION_ID);
3587: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OP FLAG :' || p_fct_assoc_rec.OPERATION_FLAG);
3588: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || p_fct_assoc_rec.OBJECT_VERSION_NUMBER);
3589: END IF;
3590: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3591: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_FCST_DATA');
3592: FND_MSG_PUB.ADD;
3593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3594: END IF;

Line 3591: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_FCST_DATA');

3587: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OP FLAG :' || p_fct_assoc_rec.OPERATION_FLAG);
3588: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Invalid Param Passed -- OVN :' || p_fct_assoc_rec.OBJECT_VERSION_NUMBER);
3589: END IF;
3590: FND_MESSAGE.Set_Name('AHL','AHL_RA_INV_PARAM_PASSED');
3591: FND_MESSAGE.Set_Token('NAME','SETUP_PVT.D_FCST_DATA');
3592: FND_MSG_PUB.ADD;
3593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3594: END IF;
3595:

Line 3613: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');

3609: WHEN NO_DATA_FOUND THEN
3610: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3611: fnd_log.string(fnd_log.level_statement,l_full_name,'-- DATA DOES NOT EXISTS -- ERROR ... ' || p_fct_assoc_rec.RA_FCT_ASSOCIATION_ID);
3612: END IF;
3613: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_DELETED');
3614: FND_MSG_PUB.ADD;
3615: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
3616: END;
3617:

Line 3624: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');

3620: IF p_fct_assoc_rec.OBJECT_VERSION_NUMBER <> l_obj_version_num THEN
3621: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3622: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Record has changed : OVN passed : ' || p_fct_assoc_rec.OBJECT_VERSION_NUMBER);
3623: END IF;
3624: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
3625: FND_MSG_PUB.ADD;
3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3627: END IF;
3628: