DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT dependencies on FND_MESSAGE

Line 23: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );

19: IS
20: BEGIN
21: IF ( p_organization_id IS NULL OR
22: p_organization_id = FND_API.G_MISS_NUM ) THEN
23: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );
24: FND_MSG_PUB.add;
25: RETURN FND_API.G_RET_STS_ERROR;
26: END IF;
27:

Line 30: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_TXN_NO_NULL' );

26: END IF;
27:
28: IF ( p_transaction_number IS NULL OR
29: p_transaction_number = FND_API.G_MISS_NUM ) THEN
30: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_TXN_NO_NULL' );
31: FND_MSG_PUB.add;
32: RETURN FND_API.G_RET_STS_ERROR;
33: END IF;
34:

Line 37: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INSPECTION_TYPE_NULL' );

33: END IF;
34:
35: IF ( p_col_trigger_value IS NULL OR
36: p_col_trigger_value = FND_API.G_MISS_NUM ) THEN
37: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INSPECTION_TYPE_NULL' );
38: FND_MSG_PUB.add;
39: RETURN FND_API.G_RET_STS_ERROR;
40: END IF;
41:

Line 122: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_ID_NULL' );

118: BEGIN
119:
120: IF ( p_plan_id IS NULL OR
121: p_plan_id = FND_API.G_MISS_NUM ) THEN
122: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_ID_NULL' );
123: FND_MSG_PUB.add;
124: RETURN FND_API.G_RET_STS_ERROR;
125: END IF;
126:

Line 129: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );

125: END IF;
126:
127: IF ( p_organization_id IS NULL OR
128: p_organization_id = FND_API.G_MISS_NUM ) THEN
129: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );
130: FND_MSG_PUB.add;
131: RETURN FND_API.G_RET_STS_ERROR;
132: END IF;
133:

Line 135: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ONE_RESULT_REQD' );

131: RETURN FND_API.G_RET_STS_ERROR;
132: END IF;
133:
134: IF ( p_results_tbl.COUNT = 0 ) THEN
135: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ONE_RESULT_REQD' );
136: FND_MSG_PUB.add;
137: RETURN FND_API.G_RET_STS_ERROR;
138: END IF;
139:

Line 148: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_NOT_FOUND' );

144: WHERE plan_id = p_plan_id;
145:
146: EXCEPTION
147: WHEN NO_DATA_FOUND THEN
148: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_NOT_FOUND' );
149: FND_MSG_PUB.add;
150: RETURN FND_API.G_RET_STS_ERROR;
151: END;
152:

Line 172: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_UNTLCKD');

168: CLOSE ue_details_csr;
169:
170:
171: IF l_unit_locked = FND_API.G_TRUE THEN
172: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_UNTLCKD');
173: FND_MESSAGE.Set_Token('MR_TITLE', L_TITLE);
174: FND_MSG_PUB.ADD;
175: RETURN FND_API.G_RET_STS_ERROR;
176: END IF;

Line 173: FND_MESSAGE.Set_Token('MR_TITLE', L_TITLE);

169:
170:
171: IF l_unit_locked = FND_API.G_TRUE THEN
172: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_UNTLCKD');
173: FND_MESSAGE.Set_Token('MR_TITLE', L_TITLE);
174: FND_MSG_PUB.ADD;
175: RETURN FND_API.G_RET_STS_ERROR;
176: END IF;
177:

Line 179: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_CAP_NALLWD');

175: RETURN FND_API.G_RET_STS_ERROR;
176: END IF;
177:
178: IF(L_STATUS_CODE IN ('ACCOMPLISHED','DEFERRED','UNRELEASED','TERMINATED','CANCELLED','DEFERRAL_PENDING'))THEN
179: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_CAP_NALLWD');
180: FND_MESSAGE.Set_Token('TITLE', L_TITLE);
181: FND_MSG_PUB.ADD;
182: RETURN FND_API.G_RET_STS_ERROR;
183: END IF;

Line 180: FND_MESSAGE.Set_Token('TITLE', L_TITLE);

176: END IF;
177:
178: IF(L_STATUS_CODE IN ('ACCOMPLISHED','DEFERRED','UNRELEASED','TERMINATED','CANCELLED','DEFERRAL_PENDING'))THEN
179: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_CAP_NALLWD');
180: FND_MESSAGE.Set_Token('TITLE', L_TITLE);
181: FND_MSG_PUB.ADD;
182: RETURN FND_API.G_RET_STS_ERROR;
183: END IF;
184: ELSIF p_transaction_no = G_JOB_TXN_NO THEN

Line 190: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_UNTLCKD');

186: FETCH get_wo_details INTO L_TITLE, L_status_code, l_unit_locked;
187: CLOSE get_wo_details;
188: IF l_unit_locked = FND_API.G_TRUE THEN
189:
190: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_UNTLCKD');
191: FND_MSG_PUB.ADD;
192: RETURN FND_API.G_RET_STS_ERROR;
193: END IF;
194: IF(L_STATUS_CODE IN ('1','4','5','7','12','21'))THEN

Line 195: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_CAP_NALLWD');

191: FND_MSG_PUB.ADD;
192: RETURN FND_API.G_RET_STS_ERROR;
193: END IF;
194: IF(L_STATUS_CODE IN ('1','4','5','7','12','21'))THEN
195: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_CAP_NALLWD');
196: FND_MESSAGE.Set_Token('TITLE', L_TITLE);
197: FND_MSG_PUB.ADD;
198: RETURN FND_API.G_RET_STS_ERROR;
199: END IF;

Line 196: FND_MESSAGE.Set_Token('TITLE', L_TITLE);

192: RETURN FND_API.G_RET_STS_ERROR;
193: END IF;
194: IF(L_STATUS_CODE IN ('1','4','5','7','12','21'))THEN
195: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_WO_QA_CAP_NALLWD');
196: FND_MESSAGE.Set_Token('TITLE', L_TITLE);
197: FND_MSG_PUB.ADD;
198: RETURN FND_API.G_RET_STS_ERROR;
199: END IF;
200:

Line 207: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_UNTLCKD');

203: FETCH get_op_details INTO L_TITLE, L_status_code, l_unit_locked;
204: CLOSE get_op_details;
205: IF l_unit_locked = FND_API.G_TRUE THEN
206:
207: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_UNTLCKD');
208: FND_MSG_PUB.ADD;
209: RETURN FND_API.G_RET_STS_ERROR;
210: END IF;
211: IF(L_STATUS_CODE IN ('1'))THEN

Line 212: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_CAP_NALLWD');

208: FND_MSG_PUB.ADD;
209: RETURN FND_API.G_RET_STS_ERROR;
210: END IF;
211: IF(L_STATUS_CODE IN ('1'))THEN
212: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_CAP_NALLWD');
213: FND_MESSAGE.Set_Token('TITLE', L_TITLE);
214: FND_MSG_PUB.ADD;
215: RETURN FND_API.G_RET_STS_ERROR;
216: END IF;

Line 213: FND_MESSAGE.Set_Token('TITLE', L_TITLE);

209: RETURN FND_API.G_RET_STS_ERROR;
210: END IF;
211: IF(L_STATUS_CODE IN ('1'))THEN
212: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_CAP_NALLWD');
213: FND_MESSAGE.Set_Token('TITLE', L_TITLE);
214: FND_MSG_PUB.ADD;
215: RETURN FND_API.G_RET_STS_ERROR;
216: END IF;
217: END IF;

Line 222: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_MISMATCH' );

218:
219:
220:
221: IF ( l_organization_id <> p_organization_id ) THEN
222: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_MISMATCH' );
223: FND_MSG_PUB.add;
224: RETURN FND_API.G_RET_STS_ERROR;
225: END IF;
226:

Line 231: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_MANY_PLANS' );

227: IF ( p_collection_id IS NOT NULL AND
228: p_collection_id <> FND_API.G_MISS_NUM ) THEN
229: FOR results_cursor IN get_plan_from_results( p_collection_id ) LOOP
230: IF ( results_cursor.plan_id <> p_plan_id ) THEN
231: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_MANY_PLANS' );
232: FND_MSG_PUB.add;
233: CLOSE get_plan_from_results;
234: RETURN FND_API.G_RET_STS_ERROR;
235: END IF;

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

237: l_element_count := l_element_count + 1;
238: END LOOP;
239:
240: IF ( l_element_count = 1 ) THEN
241: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_NOT_FOUND' );
242: FND_MSG_PUB.add;
243: RETURN FND_API.G_RET_STS_ERROR;
244: END IF;
245:

Line 265: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_RESULTS_NO_PLAN_CHAR' );

261: END IF;
262: END LOOP;
263:
264: IF ( l_match_found = FALSE ) THEN
265: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_RESULTS_NO_PLAN_CHAR' );
266: FND_MSG_PUB.add;
267: RETURN FND_API.G_RET_STS_ERROR;
268: END IF;
269:

Line 284: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_HIDDEN_NO_PLAN_CHAR' );

280: END IF;
281: END LOOP;
282:
283: IF ( l_match_found = FALSE ) THEN
284: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_HIDDEN_NO_PLAN_CHAR' );
285: FND_MSG_PUB.add;
286: RETURN FND_API.G_RET_STS_ERROR;
287: END IF;
288:

Line 335: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_UE_INPUTS' );

331: IF ( p_transaction_no = G_MR_TXN_NO ) THEN
332:
333: IF ( l_unit_effectivity_id IS NULL OR
334: l_object_version_number IS NULL ) THEN
335: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_UE_INPUTS' );
336: FND_MSG_PUB.add;
337: RETURN FND_API.G_RET_STS_ERROR;
338: END IF;
339:

Line 351: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_UE_NOT_FOUND' );

347: WHERE unit_effectivity_id = l_unit_effectivity_id
348: AND object_version_number = l_object_version_number;
349:
350: IF ( SQL%ROWCOUNT = 0 ) THEN
351: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_UE_NOT_FOUND' );
352: FND_MSG_PUB.add;
353: RETURN FND_API.G_RET_STS_ERROR;
354: END IF;
355:

Line 360: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_INPUTS' );

356: ELSIF ( p_transaction_no = G_JOB_TXN_NO ) THEN
357:
358: IF ( l_workorder_id IS NULL OR
359: l_object_version_number IS NULL ) THEN
360: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_INPUTS' );
361: FND_MSG_PUB.add;
362: RETURN FND_API.G_RET_STS_ERROR;
363: END IF;
364:

Line 375: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NOT_FOUND' );

371: WHERE workorder_id = l_workorder_id
372: AND object_version_number = l_object_version_number;
373:
374: IF ( SQL%ROWCOUNT = 0 ) THEN
375: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NOT_FOUND' );
376: FND_MSG_PUB.add;
377: RETURN FND_API.G_RET_STS_ERROR;
378: END IF;
379:

Line 384: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_COP_INPUTS' );

380: ELSIF ( p_transaction_no = G_OP_TXN_NO ) THEN
381:
382: IF ( l_workorder_operation_id IS NULL OR
383: l_object_version_number IS NULL ) THEN
384: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_COP_INPUTS' );
385: FND_MSG_PUB.add;
386: RETURN FND_API.G_RET_STS_ERROR;
387: END IF;
388:

Line 399: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_OP_NOT_FOUND' );

395: WHERE workorder_operation_id = l_workorder_operation_id
396: AND object_version_number = l_object_version_number;
397:
398: IF ( SQL%ROWCOUNT = 0 ) THEN
399: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_OP_NOT_FOUND' );
400: FND_MSG_PUB.add;
401: RETURN FND_API.G_RET_STS_ERROR;
402: END IF;
403:

Line 696: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_POST_UNEXP_ERROR' );

692: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Post Result Failed ' );
693: END IF;
694:
695: IF ( l_msg_data IS NULL ) THEN
696: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_POST_UNEXP_ERROR' );
697: FND_MSG_PUB.add;
698: RAISE FND_API.G_EXC_ERROR;
699: ELSE
700: x_return_status := FND_API.G_RET_STS_ERROR;

Line 774: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );

770: );
771:
772: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
773: IF ( l_msg_data IS NULL ) THEN
774: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );
775: FND_MSG_PUB.add;
776: RAISE FND_API.G_EXC_ERROR;
777: ELSE
778: x_return_status := FND_API.G_RET_STS_ERROR;

Line 930: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_CHAR_LOV_NULL' );

926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928:
929: IF ( x_char_lov_sql IS NULL ) THEN
930: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_CHAR_LOV_NULL' );
931: FND_MSG_PUB.add;
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934:

Line 1041: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_PLAN_NOT_FOUND' );

1037: EXCEPTION
1038: WHEN NO_DATA_FOUND THEN
1039: x_plan_id := NULL;
1040: IF ( p_module_type = 'JSP' ) THEN
1041: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_PLAN_NOT_FOUND' );
1042: FND_MSG_PUB.add;
1043: RAISE FND_API.G_EXC_ERROR;
1044: ELSE
1045: RETURN;