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 118: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_ID_NULL' );

114: BEGIN
115:
116: IF ( p_plan_id IS NULL OR
117: p_plan_id = FND_API.G_MISS_NUM ) THEN
118: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_ID_NULL' );
119: FND_MSG_PUB.add;
120: RETURN FND_API.G_RET_STS_ERROR;
121: END IF;
122:

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

121: END IF;
122:
123: IF ( p_organization_id IS NULL OR
124: p_organization_id = FND_API.G_MISS_NUM ) THEN
125: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_ID_NULL' );
126: FND_MSG_PUB.add;
127: RETURN FND_API.G_RET_STS_ERROR;
128: END IF;
129:

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

127: RETURN FND_API.G_RET_STS_ERROR;
128: END IF;
129:
130: IF ( p_results_tbl.COUNT = 0 ) THEN
131: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ONE_RESULT_REQD' );
132: FND_MSG_PUB.add;
133: RETURN FND_API.G_RET_STS_ERROR;
134: END IF;
135:

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

140: WHERE plan_id = p_plan_id;
141:
142: EXCEPTION
143: WHEN NO_DATA_FOUND THEN
144: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_PLAN_NOT_FOUND' );
145: FND_MSG_PUB.add;
146: RETURN FND_API.G_RET_STS_ERROR;
147: END;
148:

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

176: IF l_return_status = FND_API.G_TRUE THEN
177: OPEN ue_title_csr(l_unit_effectivity_id);
178: FETCH ue_title_csr INTO l_mr_title;
179: CLOSE ue_title_csr;
180: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_UNTLCKD');
181: FND_MESSAGE.Set_Token('MR_TITLE', l_mr_title);
182: FND_MSG_PUB.ADD;
183: RETURN FND_API.G_RET_STS_ERROR;
184: END IF;

Line 181: FND_MESSAGE.Set_Token('MR_TITLE', l_mr_title);

177: OPEN ue_title_csr(l_unit_effectivity_id);
178: FETCH ue_title_csr INTO l_mr_title;
179: CLOSE ue_title_csr;
180: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_MR_QA_UNTLCKD');
181: FND_MESSAGE.Set_Token('MR_TITLE', l_mr_title);
182: FND_MSG_PUB.ADD;
183: RETURN FND_API.G_RET_STS_ERROR;
184: END IF;
185: ELSIF p_transaction_no = G_JOB_TXN_NO THEN

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

186: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,
187: p_visit_id => NULL,
188: p_item_instance_id => NULL);
189: IF l_return_status = FND_API.G_TRUE THEN
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: ELSIF p_transaction_no = G_OP_TXN_NO THEN

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

199: l_return_status := AHL_PRD_UTIL_PKG.Is_Unit_Locked(p_workorder_id => l_workorder_id, p_ue_id => NULL,
200: p_visit_id => NULL,
201: p_item_instance_id => NULL);
202: IF l_return_status = FND_API.G_TRUE THEN
203: FND_MESSAGE.Set_Name('AHL', 'AHL_PRD_OP_QA_UNTLCKD');
204: FND_MSG_PUB.ADD;
205: RETURN FND_API.G_RET_STS_ERROR;
206: END IF;
207: END IF;

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

208:
209:
210:
211: IF ( l_organization_id <> p_organization_id ) THEN
212: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_ORG_MISMATCH' );
213: FND_MSG_PUB.add;
214: RETURN FND_API.G_RET_STS_ERROR;
215: END IF;
216:

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

217: IF ( p_collection_id IS NOT NULL AND
218: p_collection_id <> FND_API.G_MISS_NUM ) THEN
219: FOR results_cursor IN get_plan_from_results( p_collection_id ) LOOP
220: IF ( results_cursor.plan_id <> p_plan_id ) THEN
221: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_MANY_PLANS' );
222: FND_MSG_PUB.add;
223: CLOSE get_plan_from_results;
224: RETURN FND_API.G_RET_STS_ERROR;
225: END IF;

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

227: l_element_count := l_element_count + 1;
228: END LOOP;
229:
230: IF ( l_element_count = 1 ) THEN
231: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_COLL_NOT_FOUND' );
232: FND_MSG_PUB.add;
233: RETURN FND_API.G_RET_STS_ERROR;
234: END IF;
235:

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

251: END IF;
252: END LOOP;
253:
254: IF ( l_match_found = FALSE ) THEN
255: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_RESULTS_NO_PLAN_CHAR' );
256: FND_MSG_PUB.add;
257: RETURN FND_API.G_RET_STS_ERROR;
258: END IF;
259:

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

270: END IF;
271: END LOOP;
272:
273: IF ( l_match_found = FALSE ) THEN
274: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_HIDDEN_NO_PLAN_CHAR' );
275: FND_MSG_PUB.add;
276: RETURN FND_API.G_RET_STS_ERROR;
277: END IF;
278:

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

321: IF ( p_transaction_no = G_MR_TXN_NO ) THEN
322:
323: IF ( l_unit_effectivity_id IS NULL OR
324: l_object_version_number IS NULL ) THEN
325: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_UE_INPUTS' );
326: FND_MSG_PUB.add;
327: RETURN FND_API.G_RET_STS_ERROR;
328: END IF;
329:

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

337: WHERE unit_effectivity_id = l_unit_effectivity_id
338: AND object_version_number = l_object_version_number;
339:
340: IF ( SQL%ROWCOUNT = 0 ) THEN
341: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_UE_NOT_FOUND' );
342: FND_MSG_PUB.add;
343: RETURN FND_API.G_RET_STS_ERROR;
344: END IF;
345:

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

346: ELSIF ( p_transaction_no = G_JOB_TXN_NO ) THEN
347:
348: IF ( l_workorder_id IS NULL OR
349: l_object_version_number IS NULL ) THEN
350: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_WO_INPUTS' );
351: FND_MSG_PUB.add;
352: RETURN FND_API.G_RET_STS_ERROR;
353: END IF;
354:

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

361: WHERE workorder_id = l_workorder_id
362: AND object_version_number = l_object_version_number;
363:
364: IF ( SQL%ROWCOUNT = 0 ) THEN
365: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_NOT_FOUND' );
366: FND_MSG_PUB.add;
367: RETURN FND_API.G_RET_STS_ERROR;
368: END IF;
369:

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

370: ELSIF ( p_transaction_no = G_OP_TXN_NO ) THEN
371:
372: IF ( l_workorder_operation_id IS NULL OR
373: l_object_version_number IS NULL ) THEN
374: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_INVALID_COP_INPUTS' );
375: FND_MSG_PUB.add;
376: RETURN FND_API.G_RET_STS_ERROR;
377: END IF;
378:

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

385: WHERE workorder_operation_id = l_workorder_operation_id
386: AND object_version_number = l_object_version_number;
387:
388: IF ( SQL%ROWCOUNT = 0 ) THEN
389: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_WO_OP_NOT_FOUND' );
390: FND_MSG_PUB.add;
391: RETURN FND_API.G_RET_STS_ERROR;
392: END IF;
393:

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

682: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || l_api_name || ' : Post Result Failed ' );
683: END IF;
684:
685: IF ( l_msg_data IS NULL ) THEN
686: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_POST_UNEXP_ERROR' );
687: FND_MSG_PUB.add;
688: RAISE FND_API.G_EXC_ERROR;
689: ELSE
690: x_return_status := FND_API.G_RET_STS_ERROR;

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

750: );
751:
752: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
753: IF ( l_msg_data IS NULL ) THEN
754: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_ACTION_UNEXP_ERROR' );
755: FND_MSG_PUB.add;
756: RAISE FND_API.G_EXC_ERROR;
757: ELSE
758: x_return_status := FND_API.G_RET_STS_ERROR;

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

906: RAISE FND_API.G_EXC_ERROR;
907: END IF;
908:
909: IF ( x_char_lov_sql IS NULL ) THEN
910: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_CHAR_LOV_NULL' );
911: FND_MSG_PUB.add;
912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:

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

1017: EXCEPTION
1018: WHEN NO_DATA_FOUND THEN
1019: x_plan_id := NULL;
1020: IF ( p_module_type = 'JSP' ) THEN
1021: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_QA_PLAN_NOT_FOUND' );
1022: FND_MSG_PUB.add;
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSE
1025: RETURN;