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.

[Home] [Help]

APPS.AHL_RM_OPERATION_PVT dependencies on FND_MESSAGE

Line 33: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );

29:
30: -- Validate DML Operation
31: IF ( p_operation_rec.dml_operation <> 'C' AND
32: p_operation_rec.dml_operation <> 'U' ) THEN
33: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );
34: FND_MESSAGE.set_token( 'FIELD', p_operation_rec.dml_operation );
35: FND_MSG_PUB.add;
36: x_return_status := FND_API.G_RET_STS_ERROR;
37: END IF;

Line 34: FND_MESSAGE.set_token( 'FIELD', p_operation_rec.dml_operation );

30: -- Validate DML Operation
31: IF ( p_operation_rec.dml_operation <> 'C' AND
32: p_operation_rec.dml_operation <> 'U' ) THEN
33: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML_REC' );
34: FND_MESSAGE.set_token( 'FIELD', p_operation_rec.dml_operation );
35: FND_MSG_PUB.add;
36: x_return_status := FND_API.G_RET_STS_ERROR;
37: END IF;
38:

Line 101: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OPER_TYPE' );

97: );
98:
99: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
100: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
101: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OPER_TYPE' );
102: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
103: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_OPER_TYPES' );
104: ELSE
105: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 103: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_OPER_TYPES' );

99: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
100: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
101: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OPER_TYPE' );
102: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
103: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_OPER_TYPES' );
104: ELSE
105: FND_MESSAGE.set_name( 'AHL', l_msg_data );
106: END IF;
107:

Line 105: FND_MESSAGE.set_name( 'AHL', l_msg_data );

101: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_OPER_TYPE' );
102: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
103: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_OPER_TYPES' );
104: ELSE
105: FND_MESSAGE.set_name( 'AHL', l_msg_data );
106: END IF;
107:
108: IF ( p_x_operation_rec.operation_type IS NULL OR
109: p_x_operation_rec.operation_type = FND_API.G_MISS_CHAR ) THEN

Line 110: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.operation_type_code );

106: END IF;
107:
108: IF ( p_x_operation_rec.operation_type IS NULL OR
109: p_x_operation_rec.operation_type = FND_API.G_MISS_CHAR ) THEN
110: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.operation_type_code );
111: ELSE
112: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.operation_type );
113: END IF;
114:

Line 112: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.operation_type );

108: IF ( p_x_operation_rec.operation_type IS NULL OR
109: p_x_operation_rec.operation_type = FND_API.G_MISS_CHAR ) THEN
110: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.operation_type_code );
111: ELSE
112: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.operation_type );
113: END IF;
114:
115: FND_MSG_PUB.add;
116: END IF;

Line 137: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );

133: );
134:
135: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
136: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
137: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
138: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
139: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );
140: ELSE
141: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 139: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );

135: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
136: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
137: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
138: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
139: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );
140: ELSE
141: FND_MESSAGE.set_name( 'AHL', l_msg_data );
142: END IF;
143:

Line 141: FND_MESSAGE.set_name( 'AHL', l_msg_data );

137: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_PROCESS' );
138: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
139: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_PROCESSES' );
140: ELSE
141: FND_MESSAGE.set_name( 'AHL', l_msg_data );
142: END IF;
143:
144: IF ( p_x_operation_rec.process IS NULL OR
145: p_x_operation_rec.process = FND_API.G_MISS_CHAR ) THEN

Line 146: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.process_code );

142: END IF;
143:
144: IF ( p_x_operation_rec.process IS NULL OR
145: p_x_operation_rec.process = FND_API.G_MISS_CHAR ) THEN
146: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.process_code );
147: ELSE
148: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.process );
149: END IF;
150:

Line 148: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.process );

144: IF ( p_x_operation_rec.process IS NULL OR
145: p_x_operation_rec.process = FND_API.G_MISS_CHAR ) THEN
146: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.process_code );
147: ELSE
148: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.process );
149: END IF;
150:
151: FND_MSG_PUB.add;
152: END IF;

Line 173: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );

169: );
170:
171: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
172: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
173: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
174: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
175: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );
176: ELSE
177: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 175: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );

171: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
172: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
173: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
174: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
175: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );
176: ELSE
177: FND_MESSAGE.set_name( 'AHL', l_msg_data );
178: END IF;
179:

Line 177: FND_MESSAGE.set_name( 'AHL', l_msg_data );

173: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_INVALID_MODEL' );
174: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
175: FND_MESSAGE.set_name( 'AHL', 'AHL_CM_TOO_MANY_MODELS' );
176: ELSE
177: FND_MESSAGE.set_name( 'AHL', l_msg_data );
178: END IF;
179:
180: IF ( p_x_operation_rec.model_meaning IS NULL OR
181: p_x_operation_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN

Line 182: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.model_code );

178: END IF;
179:
180: IF ( p_x_operation_rec.model_meaning IS NULL OR
181: p_x_operation_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
182: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.model_code );
183: ELSE
184: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.model_meaning );
185: END IF;
186:

Line 184: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.model_meaning );

180: IF ( p_x_operation_rec.model_meaning IS NULL OR
181: p_x_operation_rec.model_meaning = FND_API.G_MISS_CHAR ) THEN
182: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.model_code );
183: ELSE
184: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.model_meaning );
185: END IF;
186:
187: FND_MSG_PUB.add;
188: END IF;

Line 210: FND_MESSAGE.set_name( 'AHL', l_msg_data );

206: p_x_qa_inspection_type => p_x_operation_rec.qa_inspection_type
207: );
208:
209: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
210: FND_MESSAGE.set_name( 'AHL', l_msg_data );
211:
212: IF ( p_x_operation_rec.qa_inspection_type_desc IS NULL OR
213: p_x_operation_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
214: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.qa_inspection_type );

Line 214: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.qa_inspection_type );

210: FND_MESSAGE.set_name( 'AHL', l_msg_data );
211:
212: IF ( p_x_operation_rec.qa_inspection_type_desc IS NULL OR
213: p_x_operation_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
214: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.qa_inspection_type );
215: ELSE
216: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.qa_inspection_type_desc );
217: END IF;
218:

Line 216: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.qa_inspection_type_desc );

212: IF ( p_x_operation_rec.qa_inspection_type_desc IS NULL OR
213: p_x_operation_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
214: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.qa_inspection_type );
215: ELSE
216: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.qa_inspection_type_desc );
217: END IF;
218:
219: FND_MSG_PUB.add;
220: END IF;

Line 241: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );

237: );
238:
239: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
240: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
241: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
242: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
243: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );
244: ELSE
245: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 243: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );

239: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
240: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
241: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
242: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
243: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );
244: ELSE
245: FND_MESSAGE.set_name( 'AHL', l_msg_data );
246: END IF;
247:

Line 245: FND_MESSAGE.set_name( 'AHL', l_msg_data );

241: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_STATUS' );
242: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
243: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_STATUSES' );
244: ELSE
245: FND_MESSAGE.set_name( 'AHL', l_msg_data );
246: END IF;
247:
248: IF ( p_x_operation_rec.revision_status IS NULL OR
249: p_x_operation_rec.revision_status = FND_API.G_MISS_CHAR ) THEN

Line 250: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.revision_status_code );

246: END IF;
247:
248: IF ( p_x_operation_rec.revision_status IS NULL OR
249: p_x_operation_rec.revision_status = FND_API.G_MISS_CHAR ) THEN
250: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.revision_status_code );
251: ELSE
252: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.revision_status );
253: END IF;
254:

Line 252: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.revision_status );

248: IF ( p_x_operation_rec.revision_status IS NULL OR
249: p_x_operation_rec.revision_status = FND_API.G_MISS_CHAR ) THEN
250: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.revision_status_code );
251: ELSE
252: FND_MESSAGE.set_token( 'FIELD', p_x_operation_rec.revision_status );
253: END IF;
254:
255: FND_MSG_PUB.add;
256: END IF;

Line 642: FND_MESSAGE.set_name( 'AHL', l_msg_data );

638: x_operation_rec => l_old_operation_rec
639: );
640:
641: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
642: FND_MESSAGE.set_name( 'AHL', l_msg_data );
643: FND_MSG_PUB.add;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;
646:

Line 659: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );

655: p_x_operation_rec.revision_status_code := l_old_operation_rec.revision_status_code;
656: END IF;
657: -- Validation added during 11.5.10 public api changes
658: ELSIF p_x_operation_rec.revision_status_code <> l_old_operation_rec.revision_status_code THEN
659: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );
660: FND_MSG_PUB.add;
661: END IF;
662:
663: IF ( p_x_operation_rec.revision_status IS NULL ) THEN

Line 666: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );

662:
663: IF ( p_x_operation_rec.revision_status IS NULL ) THEN
664: p_x_operation_rec.revision_status := l_old_operation_rec.revision_status;
665: ELSIF p_x_operation_rec.revision_status <> l_old_operation_rec.revision_status THEN
666: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );
667: FND_MSG_PUB.add;
668: END IF;
669:
670: IF ( p_x_operation_rec.revision_number IS NULL ) THEN

Line 673: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_REVISION_RO' );

669:
670: IF ( p_x_operation_rec.revision_number IS NULL ) THEN
671: p_x_operation_rec.revision_number := l_old_operation_rec.revision_number;
672: ELSIF p_x_operation_rec.revision_number <> l_old_operation_rec.revision_number THEN
673: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_REVISION_RO' );
674: FND_MSG_PUB.add;
675: END IF;
676:
677: IF ( p_x_operation_rec.concatenated_segments IS NULL ) THEN

Line 680: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_SEGMENTS_RO' );

676:
677: IF ( p_x_operation_rec.concatenated_segments IS NULL ) THEN
678: p_x_operation_rec.concatenated_segments := l_old_operation_rec.concatenated_segments;
679: ELSIF p_x_operation_rec.concatenated_segments <> l_old_operation_rec.concatenated_segments THEN
680: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_SEGMENTS_RO' );
681: FND_MSG_PUB.add;
682: END IF;
683:
684: IF ( p_x_operation_rec.revision_status_code = 'DRAFT' OR

Line 695: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STANDARD_OPER_RO' );

691: IF ( p_x_operation_rec.standard_operation_flag IS NULL ) THEN
692: p_x_operation_rec.standard_operation_flag := l_old_operation_rec.standard_operation_flag;
693: ELSE
694: IF ( l_read_only_flag = 'Y' ) THEN
695: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STANDARD_OPER_RO' );
696: FND_MSG_PUB.add;
697: END IF;
698: END IF;
699:

Line 704: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DESC_RO' );

700: IF ( p_x_operation_rec.description IS NULL ) THEN
701: p_x_operation_rec.description := l_old_operation_rec.description;
702: ELSE
703: IF ( l_read_only_flag = 'Y' ) THEN
704: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DESC_RO' );
705: FND_MSG_PUB.add;
706: END IF;
707: END IF;
708:

Line 713: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ST_DATE_RO' );

709: IF ( p_x_operation_rec.active_start_date IS NULL ) THEN
710: p_x_operation_rec.active_start_date := l_old_operation_rec.active_start_date;
711: ELSE
712: IF ( l_read_only_flag = 'Y' ) THEN
713: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ST_DATE_RO' );
714: FND_MSG_PUB.add;
715: END IF;
716: END IF;
717:

Line 722: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_RO' );

718: IF ( p_x_operation_rec.active_end_date IS NULL ) THEN
719: p_x_operation_rec.active_end_date := l_old_operation_rec.active_end_date;
720: ELSE
721: IF ( l_read_only_flag = 'Y' ) THEN
722: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_RO' );
723: FND_MSG_PUB.add;
724: ELSE
725: IF ( p_x_operation_rec.active_end_date = FND_API.G_MISS_DATE ) THEN
726: p_x_operation_rec.active_end_date := null;

Line 735: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );

731: IF ( p_x_operation_rec.qa_inspection_type IS NULL ) THEN
732: p_x_operation_rec.qa_inspection_type := l_old_operation_rec.qa_inspection_type;
733: ELSE
734: IF ( l_read_only_flag = 'Y' ) THEN
735: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
736: FND_MSG_PUB.add;
737: ELSE
738: IF ( p_x_operation_rec.qa_inspection_type = FND_API.G_MISS_CHAR ) THEN
739: p_x_operation_rec.qa_inspection_type := null;

Line 748: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );

744: IF ( p_x_operation_rec.qa_inspection_type_desc IS NULL ) THEN
745: p_x_operation_rec.qa_inspection_type_desc := l_old_operation_rec.qa_inspection_type_desc;
746: ELSE
747: IF ( l_read_only_flag = 'Y' ) THEN
748: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
749: FND_MSG_PUB.add;
750: ELSE
751: IF ( p_x_operation_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
752: p_x_operation_rec.qa_inspection_type_desc := null;

Line 1097: FND_MESSAGE.set_name( 'AHL','AHL_RM_SEGMENTS_ALL_NULL' );

1093: (p_operation_rec.segment12 IS NULL OR p_operation_rec.segment12 = FND_API.G_MISS_CHAR) AND
1094: (p_operation_rec.segment13 IS NULL OR p_operation_rec.segment13 = FND_API.G_MISS_CHAR) AND
1095: (p_operation_rec.segment14 IS NULL OR p_operation_rec.segment14 = FND_API.G_MISS_CHAR) AND
1096: (p_operation_rec.segment15 IS NULL OR p_operation_rec.segment15 = FND_API.G_MISS_CHAR)) THEN
1097: FND_MESSAGE.set_name( 'AHL','AHL_RM_SEGMENTS_ALL_NULL' );
1098: FND_MSG_PUB.add;
1099: x_return_status := FND_API.G_RET_STS_ERROR;
1100: RETURN;
1101: END IF;

Line 1113: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_DUP' );

1109: p_operation_rec.segment12, p_operation_rec.segment13, p_operation_rec.segment14,
1110: p_operation_rec.segment15);
1111: FETCH check_segments INTO l_dummy;
1112: IF check_segments%FOUND THEN
1113: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_DUP' );
1114: FND_MSG_PUB.add;
1115: x_return_status := FND_API.G_RET_STS_ERROR;
1116: END IF;
1117: CLOSE check_segments;

Line 1124: FND_MESSAGE.set_name( 'AHL','AHL_RM_STATUS_NULL' );

1120: -- Check if the Revision Status code column contains a null value.
1121: IF ( ( p_operation_rec.dml_operation = 'C' AND
1122: p_operation_rec.revision_status_code IS NULL ) OR
1123: p_operation_rec.revision_status_code = FND_API.G_MISS_CHAR ) THEN
1124: FND_MESSAGE.set_name( 'AHL','AHL_RM_STATUS_NULL' );
1125: FND_MSG_PUB.add;
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: END IF;
1128:

Line 1133: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_DESC_NULL' );

1129: -- Check if the Operation Description column contains a null value.
1130: IF ( ( p_operation_rec.dml_operation = 'C' AND
1131: p_operation_rec.description IS NULL ) OR
1132: p_operation_rec.description = FND_API.G_MISS_CHAR ) THEN
1133: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_DESC_NULL' );
1134: FND_MSG_PUB.add;
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: END IF;
1137:

Line 1142: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_NULL' );

1138: -- Check if the Opeartion Start Date does not column contains a null value.
1139: IF ( ( p_operation_rec.dml_operation = 'C' AND
1140: p_operation_rec.active_start_date IS NULL ) OR
1141: p_operation_rec.active_start_date = FND_API.G_MISS_DATE ) THEN
1142: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_NULL' );
1143: FND_MSG_PUB.add;
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: END IF;
1146:

Line 1151: FND_MESSAGE.set_name( 'AHL','AHL_RM_STANDARD_OPER_NULL' );

1147: -- Check if the Standard Operation Flag column contains a null value.
1148: IF ( ( p_operation_rec.dml_operation = 'C' AND
1149: p_operation_rec.standard_operation_flag IS NULL ) OR
1150: p_operation_rec.standard_operation_flag = FND_API.G_MISS_CHAR ) THEN
1151: FND_MESSAGE.set_name( 'AHL','AHL_RM_STANDARD_OPER_NULL' );
1152: FND_MSG_PUB.add;
1153: x_return_status := FND_API.G_RET_STS_ERROR;
1154: END IF;
1155:

Line 1164: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_CODE_NULL_OP' );

1160: /* --bachandr Enigma Phase I changes -- start
1161: IF ( p_operation_rec.dml_operation = 'C' AND p_operation_rec.enigma_op_id IS NOT NULL AND p_operation_rec.model_code IS NULL)
1162: THEN
1163: --throw error if model is null for enigma operations during creation.
1164: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_CODE_NULL_OP' );
1165: FND_MSG_PUB.add;
1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: END IF;
1168:

Line 1178: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MODEL_OP');

1174:
1175: IF ( p_operation_rec.model_code is null or (l_model_code <> p_operation_rec.model_code))
1176: THEN
1177: --throw error disallowing modification of model
1178: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MODEL_OP');
1179: FND_MSG_PUB.ADD;
1180: x_return_status := FND_API.G_RET_STS_ERROR;
1181: END IF;
1182: END IF;

Line 1189: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_CODE_NULL_OP' );

1185:
1186: --throw error if model is null for enigma operations during creation.
1187: IF ( p_operation_rec.dml_operation = 'C' AND (p_operation_rec.enigma_op_id IS NOT NULL OR p_operation_rec.enigmatype_code = 'MANUAL') AND p_operation_rec.model_code IS NULL)
1188: THEN
1189: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_CODE_NULL_OP' );
1190: FND_MSG_PUB.add;
1191: x_return_status := FND_API.G_RET_STS_ERROR;
1192: END IF;
1193:

Line 1207: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MODEL_OP');

1203: THEN
1204: IF ( p_operation_rec.model_code is null or (l_model_code <> p_operation_rec.model_code))
1205: THEN
1206: --throw error disallowing modification of model
1207: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MODEL_OP');
1208: FND_MSG_PUB.ADD;
1209: x_return_status := FND_API.G_RET_STS_ERROR;
1210: END IF;
1211:

Line 1215: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ENIGMA_DOC_ID_OP');

1211:
1212: IF ( p_operation_rec.enigma_doc_id is null or (l_enigma_doc_id <> p_operation_rec.enigma_doc_id))
1213: THEN
1214: --throw error disallowing modification of Enigma Document Id
1215: FND_MESSAGE.SET_NAME('AHL','AHL_RM_ENIGMA_DOC_ID_OP');
1216: FND_MSG_PUB.ADD;
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: END IF;
1219: ELSIF(p_operation_rec.enigmatype_code = 'MANUAL')

Line 1224: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MODEL_CODE_NULL_OP');

1220: THEN
1221: IF ( p_operation_rec.model_code is null)
1222: THEN
1223: --throw error disallowing modification of model
1224: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MODEL_CODE_NULL_OP');
1225: FND_MSG_PUB.ADD;
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: END IF;
1228: END IF;

Line 1237: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_ID_NULL' );

1233:
1234: -- Check if the mandatory Operation ID column contains a null value.
1235: IF ( p_operation_rec.dml_operation = 'U' AND (p_operation_rec.operation_id IS NULL OR
1236: p_operation_rec.operation_id = FND_API.G_MISS_NUM )) THEN
1237: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_ID_NULL' );
1238: FND_MSG_PUB.add;
1239: x_return_status := FND_API.G_RET_STS_ERROR;
1240: END IF;
1241:

Line 1245: FND_MESSAGE.set_name( 'AHL','AHL_RM_OBJ_VERSION_NULL' );

1241:
1242: -- Check if the mandatory Object Version Number column contains a null value.
1243: IF ( p_operation_rec.dml_operation = 'U' AND (p_operation_rec.object_version_number IS NULL OR
1244: p_operation_rec.object_version_number = FND_API.G_MISS_NUM )) THEN
1245: FND_MESSAGE.set_name( 'AHL','AHL_RM_OBJ_VERSION_NULL' );
1246: FND_MSG_PUB.add;
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: END IF;
1249:

Line 1253: FND_MESSAGE.set_name( 'AHL','AHL_RM_OP_STS_NO_UPD' );

1249:
1250: -- Added by Tamal for Bug #3854052
1251: IF (p_operation_rec.dml_operation = 'U' AND p_operation_rec.revision_status_code IN ('COMPLETE', 'APPROVAL_PENDING', 'TERMINATION_PENDING', 'TERMINATED'))
1252: THEN
1253: FND_MESSAGE.set_name( 'AHL','AHL_RM_OP_STS_NO_UPD' );
1254: FND_MSG_PUB.add;
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256: END IF;
1257: -- Added by Tamal for Bug #3854052

Line 1265: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

1261: OPEN validate_oper_ovn;
1262: FETCH validate_oper_ovn INTO l_dummy;
1263: IF (validate_oper_ovn%NOTFOUND)
1264: THEN
1265: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1266: FND_MSG_PUB.add;
1267: END IF;
1268: END IF;
1269:

Line 1325: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );

1321: IF ( p_operation_rec.revision_status_code = 'DRAFT' OR
1322: p_operation_rec.revision_status_code = 'APPROVAL_REJECTED' ) THEN
1323: /*
1324: IF trunc(p_operation_rec.active_start_date) < trunc(SYSDATE) THEN
1325: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );
1326: FND_MESSAGE.set_token('FIELD',trunc(SYSDATE));
1327: FND_MSG_PUB.add;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: */

Line 1326: FND_MESSAGE.set_token('FIELD',trunc(SYSDATE));

1322: p_operation_rec.revision_status_code = 'APPROVAL_REJECTED' ) THEN
1323: /*
1324: IF trunc(p_operation_rec.active_start_date) < trunc(SYSDATE) THEN
1325: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );
1326: FND_MESSAGE.set_token('FIELD',trunc(SYSDATE));
1327: FND_MSG_PUB.add;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: */
1330: -- Check if Active start date is less than the active start date of the operation's

Line 1340: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_LESSER' );

1336: FETCH check_previous_start_date INTO l_start_date;
1337: IF check_previous_start_date%FOUND THEN
1338: CLOSE check_previous_start_date;
1339: IF trunc(p_operation_rec.active_start_date) < trunc(l_start_date) THEN
1340: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_LESSER' );
1341: FND_MESSAGE.set_token('FIELD',trunc(l_start_date));
1342: FND_MSG_PUB.add;
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344: END IF;

Line 1341: FND_MESSAGE.set_token('FIELD',trunc(l_start_date));

1337: IF check_previous_start_date%FOUND THEN
1338: CLOSE check_previous_start_date;
1339: IF trunc(p_operation_rec.active_start_date) < trunc(l_start_date) THEN
1340: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_LESSER' );
1341: FND_MESSAGE.set_token('FIELD',trunc(l_start_date));
1342: FND_MSG_PUB.add;
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344: END IF;
1345: END IF;

Line 1361: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

1357: l_operation_id;
1358:
1359: IF ( get_dup_rec%FOUND ) THEN
1360: IF ( l_operation_id <> p_operation_rec.operation_id ) THEN
1361: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1362: FND_MSG_PUB.add;
1363: END IF;
1364: END IF;
1365:

Line 1700: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

1696: );
1697:
1698: EXCEPTION
1699: WHEN NO_DATA_FOUND THEN
1700: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1701: FND_MSG_PUB.add;
1702: WHEN OTHERS THEN
1703: IF ( SQLCODE = -1 ) THEN
1704: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

Line 1704: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

1700: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1701: FND_MSG_PUB.add;
1702: WHEN OTHERS THEN
1703: IF ( SQLCODE = -1 ) THEN
1704: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1705: FND_MSG_PUB.add;
1706: ELSE
1707: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1708: THEN

Line 1794: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

1790: );
1791:
1792: EXCEPTION
1793: WHEN NO_DATA_FOUND THEN
1794: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1795: FND_MSG_PUB.add;
1796: WHEN OTHERS THEN
1797: IF ( SQLCODE = -1 ) THEN
1798: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

Line 1798: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

1794: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1795: FND_MSG_PUB.add;
1796: WHEN OTHERS THEN
1797: IF ( SQLCODE = -1 ) THEN
1798: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1799: FND_MSG_PUB.add;
1800: ELSE
1801: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1802: THEN

Line 1973: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );

1969: IF ( p_operation_id IS NULL OR
1970: p_operation_id = FND_API.G_MISS_NUM OR
1971: p_object_version_number IS NULL OR
1972: p_object_version_number = FND_API.G_MISS_NUM ) THEN
1973: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
1974: FND_MSG_PUB.add;
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:

Line 1982: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

1978: OPEN validate_oper_ovn;
1979: FETCH validate_oper_ovn INTO l_dummy;
1980: IF (validate_oper_ovn%NOTFOUND)
1981: THEN
1982: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1983: FND_MSG_PUB.add;
1984: END IF;
1985: --bachandr Enigma Phase I changes -- start
1986: -- Fire the validation only if the call is from the CMRO end.

Line 1997: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OPER_ENIG_DELT');

1993:
1994: IF ( l_enig_op_id is not null and l_enig_op_id <> FND_API.G_MISS_CHAR)
1995: THEN
1996: --if the operation is from enigma do not allow deletion.
1997: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OPER_ENIG_DELT');
1998: FND_MSG_PUB.ADD;
1999: RAISE FND_API.G_EXC_ERROR;
2000: END IF;
2001: END IF;

Line 2013: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_DRAFT' );

2009: );
2010:
2011: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2012: IF ( l_msg_data = 'AHL_RM_INVALID_OPER_STATUS' ) THEN
2013: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_DRAFT' );
2014: ELSE
2015: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2016: END IF;
2017:

Line 2015: FND_MESSAGE.set_name( 'AHL', l_msg_data );

2011: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2012: IF ( l_msg_data = 'AHL_RM_INVALID_OPER_STATUS' ) THEN
2013: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_DRAFT' );
2014: ELSE
2015: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2016: END IF;
2017:
2018: FND_MSG_PUB.add;
2019: RAISE FND_API.G_EXC_ERROR;

Line 2031: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

2027: );
2028:
2029: EXCEPTION
2030: WHEN NO_DATA_FOUND THEN
2031: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2032: FND_MSG_PUB.add;
2033: RAISE FND_API.G_EXC_ERROR;
2034: WHEN OTHERS THEN
2035: RAISE;

Line 2325: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );

2321: IF ( p_operation_id IS NULL OR
2322: p_operation_id = FND_API.G_MISS_NUM OR
2323: p_object_version_number IS NULL OR
2324: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2325: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2326: FND_MSG_PUB.add;
2327: RAISE FND_API.G_EXC_ERROR;
2328: END IF;
2329:

Line 2340: FND_MESSAGE.set_name( 'AHL', l_msg_data );

2336: x_operation_rec => l_old_operation_rec
2337: );
2338:
2339: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2340: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2341: FND_MSG_PUB.add;
2342: RAISE FND_API.G_EXC_ERROR;
2343: END IF;
2344:

Line 2347: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_COMPLETE' );

2343: END IF;
2344:
2345: -- Check if the Status is COMPLETE
2346: IF ( l_old_operation_rec.revision_status_code <> 'COMPLETE' ) THEN
2347: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_COMPLETE' );
2348: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );
2349: FND_MSG_PUB.add;
2350: RAISE FND_API.G_EXC_ERROR;
2351: END IF;

Line 2348: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );

2344:
2345: -- Check if the Status is COMPLETE
2346: IF ( l_old_operation_rec.revision_status_code <> 'COMPLETE' ) THEN
2347: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_COMPLETE' );
2348: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );
2349: FND_MSG_PUB.add;
2350: RAISE FND_API.G_EXC_ERROR;
2351: END IF;
2352:

Line 2355: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );

2351: END IF;
2352:
2353: -- Check if active end date is set
2354: IF l_old_operation_rec.active_end_date is not null THEN
2355: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );
2356: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments )
2357: ;
2358: FND_MSG_PUB.add;
2359: RAISE FND_API.G_EXC_ERROR;

Line 2356: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments )

2352:
2353: -- Check if active end date is set
2354: IF l_old_operation_rec.active_end_date is not null THEN
2355: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );
2356: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments )
2357: ;
2358: FND_MSG_PUB.add;
2359: RAISE FND_API.G_EXC_ERROR;
2360: END IF;

Line 2368: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_REVISION_NOT_LATEST' );

2364: FETCH get_latest_revision INTO
2365: l_revision_number;
2366:
2367: IF ( l_revision_number <> l_old_operation_rec.revision_number ) THEN
2368: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_REVISION_NOT_LATEST' );
2369: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );
2370: FND_MSG_PUB.add;
2371: CLOSE get_latest_revision;
2372: RAISE FND_API.G_EXC_ERROR;

Line 2369: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );

2365: l_revision_number;
2366:
2367: IF ( l_revision_number <> l_old_operation_rec.revision_number ) THEN
2368: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_REVISION_NOT_LATEST' );
2369: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );
2370: FND_MSG_PUB.add;
2371: CLOSE get_latest_revision;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;

Line 2459: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );

2455: );
2456:
2457: EXCEPTION
2458: WHEN NO_DATA_FOUND THEN
2459: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2460: FND_MSG_PUB.add;
2461: WHEN OTHERS THEN
2462: IF ( SQLCODE = -1 ) THEN
2463: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

Line 2463: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

2459: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2460: FND_MSG_PUB.add;
2461: WHEN OTHERS THEN
2462: IF ( SQLCODE = -1 ) THEN
2463: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
2464: FND_MSG_PUB.add;
2465: ELSE
2466: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2467: THEN