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_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 207: FND_MESSAGE.set_name( 'AHL', l_msg_data );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

604: x_operation_rec => l_old_operation_rec
605: );
606:
607: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
608: FND_MESSAGE.set_name( 'AHL', l_msg_data );
609: FND_MSG_PUB.add;
610: RAISE FND_API.G_EXC_ERROR;
611: END IF;
612:

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

621: p_x_operation_rec.revision_status_code := l_old_operation_rec.revision_status_code;
622: END IF;
623: -- Validation added during 11.5.10 public api changes
624: ELSIF p_x_operation_rec.revision_status_code <> l_old_operation_rec.revision_status_code THEN
625: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );
626: FND_MSG_PUB.add;
627: END IF;
628:
629: IF ( p_x_operation_rec.revision_status IS NULL ) THEN

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

628:
629: IF ( p_x_operation_rec.revision_status IS NULL ) THEN
630: p_x_operation_rec.revision_status := l_old_operation_rec.revision_status;
631: ELSIF p_x_operation_rec.revision_status <> l_old_operation_rec.revision_status THEN
632: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STATUS_RO' );
633: FND_MSG_PUB.add;
634: END IF;
635:
636: IF ( p_x_operation_rec.revision_number IS NULL ) THEN

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

635:
636: IF ( p_x_operation_rec.revision_number IS NULL ) THEN
637: p_x_operation_rec.revision_number := l_old_operation_rec.revision_number;
638: ELSIF p_x_operation_rec.revision_number <> l_old_operation_rec.revision_number THEN
639: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_REVISION_RO' );
640: FND_MSG_PUB.add;
641: END IF;
642:
643: IF ( p_x_operation_rec.concatenated_segments IS NULL ) THEN

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

642:
643: IF ( p_x_operation_rec.concatenated_segments IS NULL ) THEN
644: p_x_operation_rec.concatenated_segments := l_old_operation_rec.concatenated_segments;
645: ELSIF p_x_operation_rec.concatenated_segments <> l_old_operation_rec.concatenated_segments THEN
646: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_SEGMENTS_RO' );
647: FND_MSG_PUB.add;
648: END IF;
649:
650: IF ( p_x_operation_rec.revision_status_code = 'DRAFT' OR

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

657: IF ( p_x_operation_rec.standard_operation_flag IS NULL ) THEN
658: p_x_operation_rec.standard_operation_flag := l_old_operation_rec.standard_operation_flag;
659: ELSE
660: IF ( l_read_only_flag = 'Y' ) THEN
661: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_STANDARD_OPER_RO' );
662: FND_MSG_PUB.add;
663: END IF;
664: END IF;
665:

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

666: IF ( p_x_operation_rec.description IS NULL ) THEN
667: p_x_operation_rec.description := l_old_operation_rec.description;
668: ELSE
669: IF ( l_read_only_flag = 'Y' ) THEN
670: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DESC_RO' );
671: FND_MSG_PUB.add;
672: END IF;
673: END IF;
674:

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

675: IF ( p_x_operation_rec.active_start_date IS NULL ) THEN
676: p_x_operation_rec.active_start_date := l_old_operation_rec.active_start_date;
677: ELSE
678: IF ( l_read_only_flag = 'Y' ) THEN
679: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ST_DATE_RO' );
680: FND_MSG_PUB.add;
681: END IF;
682: END IF;
683:

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

684: IF ( p_x_operation_rec.active_end_date IS NULL ) THEN
685: p_x_operation_rec.active_end_date := l_old_operation_rec.active_end_date;
686: ELSE
687: IF ( l_read_only_flag = 'Y' ) THEN
688: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_RO' );
689: FND_MSG_PUB.add;
690: ELSE
691: IF ( p_x_operation_rec.active_end_date = FND_API.G_MISS_DATE ) THEN
692: p_x_operation_rec.active_end_date := null;

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

697: IF ( p_x_operation_rec.qa_inspection_type IS NULL ) THEN
698: p_x_operation_rec.qa_inspection_type := l_old_operation_rec.qa_inspection_type;
699: ELSE
700: IF ( l_read_only_flag = 'Y' ) THEN
701: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
702: FND_MSG_PUB.add;
703: ELSE
704: IF ( p_x_operation_rec.qa_inspection_type = FND_API.G_MISS_CHAR ) THEN
705: p_x_operation_rec.qa_inspection_type := null;

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

710: IF ( p_x_operation_rec.qa_inspection_type_desc IS NULL ) THEN
711: p_x_operation_rec.qa_inspection_type_desc := l_old_operation_rec.qa_inspection_type_desc;
712: ELSE
713: IF ( l_read_only_flag = 'Y' ) THEN
714: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_QA_INSP_TYPE_RO' );
715: FND_MSG_PUB.add;
716: ELSE
717: IF ( p_x_operation_rec.qa_inspection_type_desc = FND_API.G_MISS_CHAR ) THEN
718: p_x_operation_rec.qa_inspection_type_desc := null;

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

1022: (p_operation_rec.segment12 IS NULL OR p_operation_rec.segment12 = FND_API.G_MISS_CHAR) AND
1023: (p_operation_rec.segment13 IS NULL OR p_operation_rec.segment13 = FND_API.G_MISS_CHAR) AND
1024: (p_operation_rec.segment14 IS NULL OR p_operation_rec.segment14 = FND_API.G_MISS_CHAR) AND
1025: (p_operation_rec.segment15 IS NULL OR p_operation_rec.segment15 = FND_API.G_MISS_CHAR)) THEN
1026: FND_MESSAGE.set_name( 'AHL','AHL_RM_SEGMENTS_ALL_NULL' );
1027: FND_MSG_PUB.add;
1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: RETURN;
1030: END IF;

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

1038: p_operation_rec.segment12, p_operation_rec.segment13, p_operation_rec.segment14,
1039: p_operation_rec.segment15);
1040: FETCH check_segments INTO l_dummy;
1041: IF check_segments%FOUND THEN
1042: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_DUP' );
1043: FND_MSG_PUB.add;
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: END IF;
1046: CLOSE check_segments;

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

1049: -- Check if the Revision Status code column contains a null value.
1050: IF ( ( p_operation_rec.dml_operation = 'C' AND
1051: p_operation_rec.revision_status_code IS NULL ) OR
1052: p_operation_rec.revision_status_code = FND_API.G_MISS_CHAR ) THEN
1053: FND_MESSAGE.set_name( 'AHL','AHL_RM_STATUS_NULL' );
1054: FND_MSG_PUB.add;
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: END IF;
1057:

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

1058: -- Check if the Operation Description column contains a null value.
1059: IF ( ( p_operation_rec.dml_operation = 'C' AND
1060: p_operation_rec.description IS NULL ) OR
1061: p_operation_rec.description = FND_API.G_MISS_CHAR ) THEN
1062: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_DESC_NULL' );
1063: FND_MSG_PUB.add;
1064: x_return_status := FND_API.G_RET_STS_ERROR;
1065: END IF;
1066:

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

1067: -- Check if the Opeartion Start Date does not column contains a null value.
1068: IF ( ( p_operation_rec.dml_operation = 'C' AND
1069: p_operation_rec.active_start_date IS NULL ) OR
1070: p_operation_rec.active_start_date = FND_API.G_MISS_DATE ) THEN
1071: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_NULL' );
1072: FND_MSG_PUB.add;
1073: x_return_status := FND_API.G_RET_STS_ERROR;
1074: END IF;
1075:

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

1076: -- Check if the Standard Operation Flag column contains a null value.
1077: IF ( ( p_operation_rec.dml_operation = 'C' AND
1078: p_operation_rec.standard_operation_flag IS NULL ) OR
1079: p_operation_rec.standard_operation_flag = FND_API.G_MISS_CHAR ) THEN
1080: FND_MESSAGE.set_name( 'AHL','AHL_RM_STANDARD_OPER_NULL' );
1081: FND_MSG_PUB.add;
1082: x_return_status := FND_API.G_RET_STS_ERROR;
1083: END IF;
1084:

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

1085: --bachandr Enigma Phase I changes -- start
1086: 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)
1087: THEN
1088: --throw error if model is null for enigma operations during creation.
1089: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MODEL_CODE_NULL_OP' );
1090: FND_MSG_PUB.add;
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092: END IF;
1093:

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

1099:
1100: IF ( p_operation_rec.model_code is null or (l_model_code <> p_operation_rec.model_code))
1101: THEN
1102: --throw error disallowing modification of model
1103: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MODEL_OP');
1104: FND_MSG_PUB.ADD;
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: END IF;
1107: END IF;

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

1108: --bachandr Enigma Phase I changes -- end
1109: -- Check if the mandatory Operation ID column contains a null value.
1110: IF ( p_operation_rec.dml_operation = 'U' AND (p_operation_rec.operation_id IS NULL OR
1111: p_operation_rec.operation_id = FND_API.G_MISS_NUM )) THEN
1112: FND_MESSAGE.set_name( 'AHL','AHL_RM_OPERATION_ID_NULL' );
1113: FND_MSG_PUB.add;
1114: x_return_status := FND_API.G_RET_STS_ERROR;
1115: END IF;
1116:

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

1116:
1117: -- Check if the mandatory Object Version Number column contains a null value.
1118: IF ( p_operation_rec.dml_operation = 'U' AND (p_operation_rec.object_version_number IS NULL OR
1119: p_operation_rec.object_version_number = FND_API.G_MISS_NUM )) THEN
1120: FND_MESSAGE.set_name( 'AHL','AHL_RM_OBJ_VERSION_NULL' );
1121: FND_MSG_PUB.add;
1122: x_return_status := FND_API.G_RET_STS_ERROR;
1123: END IF;
1124:

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

1124:
1125: -- Added by Tamal for Bug #3854052
1126: IF (p_operation_rec.dml_operation = 'U' AND p_operation_rec.revision_status_code IN ('COMPLETE', 'APPROVAL_PENDING', 'TERMINATION_PENDING', 'TERMINATED'))
1127: THEN
1128: FND_MESSAGE.set_name( 'AHL','AHL_RM_OP_STS_NO_UPD' );
1129: FND_MSG_PUB.add;
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: END IF;
1132: -- Added by Tamal for Bug #3854052

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

1136: OPEN validate_oper_ovn;
1137: FETCH validate_oper_ovn INTO l_dummy;
1138: IF (validate_oper_ovn%NOTFOUND)
1139: THEN
1140: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1141: FND_MSG_PUB.add;
1142: END IF;
1143: END IF;
1144:

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

1196: IF ( p_operation_rec.revision_status_code = 'DRAFT' OR
1197: p_operation_rec.revision_status_code = 'APPROVAL_REJECTED' ) THEN
1198: /*
1199: IF trunc(p_operation_rec.active_start_date) < trunc(SYSDATE) THEN
1200: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );
1201: FND_MESSAGE.set_token('FIELD',trunc(SYSDATE));
1202: FND_MSG_PUB.add;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: */

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

1197: p_operation_rec.revision_status_code = 'APPROVAL_REJECTED' ) THEN
1198: /*
1199: IF trunc(p_operation_rec.active_start_date) < trunc(SYSDATE) THEN
1200: FND_MESSAGE.set_name( 'AHL','AHL_RM_INVALID_ST_DATE' );
1201: FND_MESSAGE.set_token('FIELD',trunc(SYSDATE));
1202: FND_MSG_PUB.add;
1203: x_return_status := FND_API.G_RET_STS_ERROR;
1204: */
1205: -- Check if Active start date is less than the active start date of the operation's

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

1211: FETCH check_previous_start_date INTO l_start_date;
1212: IF check_previous_start_date%FOUND THEN
1213: CLOSE check_previous_start_date;
1214: IF trunc(p_operation_rec.active_start_date) < trunc(l_start_date) THEN
1215: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_LESSER' );
1216: FND_MESSAGE.set_token('FIELD',trunc(l_start_date));
1217: FND_MSG_PUB.add;
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: END IF;

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

1212: IF check_previous_start_date%FOUND THEN
1213: CLOSE check_previous_start_date;
1214: IF trunc(p_operation_rec.active_start_date) < trunc(l_start_date) THEN
1215: FND_MESSAGE.set_name( 'AHL','AHL_RM_ST_DATE_LESSER' );
1216: FND_MESSAGE.set_token('FIELD',trunc(l_start_date));
1217: FND_MSG_PUB.add;
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: END IF;
1220: END IF;

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

1232: l_operation_id;
1233:
1234: IF ( get_dup_rec%FOUND ) THEN
1235: IF ( l_operation_id <> p_operation_rec.operation_id ) THEN
1236: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1237: FND_MSG_PUB.add;
1238: END IF;
1239: END IF;
1240:

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

1503: );
1504:
1505: EXCEPTION
1506: WHEN NO_DATA_FOUND THEN
1507: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1508: FND_MSG_PUB.add;
1509: WHEN OTHERS THEN
1510: IF ( SQLCODE = -1 ) THEN
1511: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

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

1507: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1508: FND_MSG_PUB.add;
1509: WHEN OTHERS THEN
1510: IF ( SQLCODE = -1 ) THEN
1511: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1512: FND_MSG_PUB.add;
1513: ELSE
1514: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1515: THEN

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

1588: );
1589:
1590: EXCEPTION
1591: WHEN NO_DATA_FOUND THEN
1592: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1593: FND_MSG_PUB.add;
1594: WHEN OTHERS THEN
1595: IF ( SQLCODE = -1 ) THEN
1596: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

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

1592: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1593: FND_MSG_PUB.add;
1594: WHEN OTHERS THEN
1595: IF ( SQLCODE = -1 ) THEN
1596: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
1597: FND_MSG_PUB.add;
1598: ELSE
1599: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1600: THEN

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

1767: IF ( p_operation_id IS NULL OR
1768: p_operation_id = FND_API.G_MISS_NUM OR
1769: p_object_version_number IS NULL OR
1770: p_object_version_number = FND_API.G_MISS_NUM ) THEN
1771: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
1772: FND_MSG_PUB.add;
1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775:

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

1776: OPEN validate_oper_ovn;
1777: FETCH validate_oper_ovn INTO l_dummy;
1778: IF (validate_oper_ovn%NOTFOUND)
1779: THEN
1780: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
1781: FND_MSG_PUB.add;
1782: END IF;
1783: --bachandr Enigma Phase I changes -- start
1784: -- Fire the validation only if the call is from the CMRO end.

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

1789:
1790: IF ( l_enig_op_id is not null and l_enig_op_id <> FND_API.G_MISS_CHAR)
1791: THEN
1792: --if the operation is from enigma do not allow deletion.
1793: FND_MESSAGE.SET_NAME('AHL','AHL_RM_OPER_ENIG_DELT');
1794: FND_MSG_PUB.ADD;
1795: RAISE FND_API.G_EXC_ERROR;
1796: END IF;
1797: END IF;

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

1805: );
1806:
1807: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1808: IF ( l_msg_data = 'AHL_RM_INVALID_OPER_STATUS' ) THEN
1809: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_DRAFT' );
1810: ELSE
1811: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1812: END IF;
1813:

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

1807: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1808: IF ( l_msg_data = 'AHL_RM_INVALID_OPER_STATUS' ) THEN
1809: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_DRAFT' );
1810: ELSE
1811: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1812: END IF;
1813:
1814: FND_MSG_PUB.add;
1815: RAISE FND_API.G_EXC_ERROR;

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

1823: );
1824:
1825: EXCEPTION
1826: WHEN NO_DATA_FOUND THEN
1827: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
1828: FND_MSG_PUB.add;
1829: RAISE FND_API.G_EXC_ERROR;
1830: WHEN OTHERS THEN
1831: RAISE;

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

2117: IF ( p_operation_id IS NULL OR
2118: p_operation_id = FND_API.G_MISS_NUM OR
2119: p_object_version_number IS NULL OR
2120: p_object_version_number = FND_API.G_MISS_NUM ) THEN
2121: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
2122: FND_MSG_PUB.add;
2123: RAISE FND_API.G_EXC_ERROR;
2124: END IF;
2125:

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

2132: x_operation_rec => l_old_operation_rec
2133: );
2134:
2135: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
2136: FND_MESSAGE.set_name( 'AHL', l_msg_data );
2137: FND_MSG_PUB.add;
2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;
2140:

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

2139: END IF;
2140:
2141: -- Check if the Status is COMPLETE
2142: IF ( l_old_operation_rec.revision_status_code <> 'COMPLETE' ) THEN
2143: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_COMPLETE' );
2144: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );
2145: FND_MSG_PUB.add;
2146: RAISE FND_API.G_EXC_ERROR;
2147: END IF;

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

2140:
2141: -- Check if the Status is COMPLETE
2142: IF ( l_old_operation_rec.revision_status_code <> 'COMPLETE' ) THEN
2143: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_STATUS_NOT_COMPLETE' );
2144: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );
2145: FND_MSG_PUB.add;
2146: RAISE FND_API.G_EXC_ERROR;
2147: END IF;
2148:

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

2147: END IF;
2148:
2149: -- Check if active end date is set
2150: IF l_old_operation_rec.active_end_date is not null THEN
2151: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );
2152: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments )
2153: ;
2154: FND_MSG_PUB.add;
2155: RAISE FND_API.G_EXC_ERROR;

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

2148:
2149: -- Check if active end date is set
2150: IF l_old_operation_rec.active_end_date is not null THEN
2151: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_END_DATE_NOT_NULL' );
2152: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments )
2153: ;
2154: FND_MSG_PUB.add;
2155: RAISE FND_API.G_EXC_ERROR;
2156: END IF;

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

2160: FETCH get_latest_revision INTO
2161: l_revision_number;
2162:
2163: IF ( l_revision_number <> l_old_operation_rec.revision_number ) THEN
2164: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_REVISION_NOT_LATEST' );
2165: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );
2166: FND_MSG_PUB.add;
2167: CLOSE get_latest_revision;
2168: RAISE FND_API.G_EXC_ERROR;

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

2161: l_revision_number;
2162:
2163: IF ( l_revision_number <> l_old_operation_rec.revision_number ) THEN
2164: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OP_REVISION_NOT_LATEST' );
2165: FND_MESSAGE.set_token( 'RECORD', l_old_operation_rec.concatenated_segments );
2166: FND_MSG_PUB.add;
2167: CLOSE get_latest_revision;
2168: RAISE FND_API.G_EXC_ERROR;
2169: END IF;

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

2247: );
2248:
2249: EXCEPTION
2250: WHEN NO_DATA_FOUND THEN
2251: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2252: FND_MSG_PUB.add;
2253: WHEN OTHERS THEN
2254: IF ( SQLCODE = -1 ) THEN
2255: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );

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

2251: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_RECORD_CHANGED' );
2252: FND_MSG_PUB.add;
2253: WHEN OTHERS THEN
2254: IF ( SQLCODE = -1 ) THEN
2255: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OPERATION_DUP' );
2256: FND_MSG_PUB.add;
2257: ELSE
2258: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2259: THEN