DBA Data[Home] [Help]

APPS.AHL_UMP_UNPLANNED_PVT dependencies on FND_MESSAGE

Line 195: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');

191: p_mr_header_id IS NULL OR p_mr_header_id = FND_API.G_MISS_NUM OR
192: p_instance_id IS NULL OR p_instance_id = FND_API.G_MISS_NUM
193: )
194: THEN
195: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
197: FND_MSG_PUB.ADD;
198: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
199: fnd_log.string

Line 196: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);

192: p_instance_id IS NULL OR p_instance_id = FND_API.G_MISS_NUM
193: )
194: THEN
195: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
197: FND_MSG_PUB.ADD;
198: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
199: fnd_log.string
200: (

Line 214: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_MR_NOT_FOUND');

210: OPEN check_mr_exists (p_mr_header_id);
211: FETCH check_mr_exists INTO l_dummy_varchar;
212: IF (check_mr_exists%NOTFOUND)
213: THEN
214: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_MR_NOT_FOUND');
215: FND_MSG_PUB.ADD;
216: CLOSE check_mr_exists;
217: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
218: fnd_log.string

Line 234: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE'); --message reused

230: OPEN check_instance_exists (p_instance_id);
231: FETCH check_instance_exists INTO l_dummy_varchar;
232: IF (check_instance_exists%NOTFOUND)
233: THEN
234: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE'); --message reused
235: FND_MSG_PUB.ADD;
236: CLOSE check_instance_exists;
237: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
238: fnd_log.string

Line 252: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');

248:
249: --Set the return status to an error and raise an error message if the application code returned is not AHL
250: IF (l_appln_code <> 'AHL') THEN
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
253: FND_MSG_PUB.add;
254: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
255: fnd_log.string
256: (

Line 275: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');

271: INTO l_mr_title
272: FROM AHL_MR_HEADERS_B
273: WHERE mr_header_id = p_mr_header_id ;
274:
275: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
276: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
277: FND_MSG_PUB.ADD;
278: CLOSE Chk_UE_Init_Due;
279: RAISE FND_API.G_EXC_ERROR;

Line 276: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);

272: FROM AHL_MR_HEADERS_B
273: WHERE mr_header_id = p_mr_header_id ;
274:
275: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
276: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
277: FND_MSG_PUB.ADD;
278: CLOSE Chk_UE_Init_Due;
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;

Line 315: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');

311: OPEN Get_all_appl_mrs ( p_mr_header_id , p_instance_id );
312: FETCH Get_all_appl_mrs INTO l_all_appl_mrs;
313: IF (Get_all_appl_mrs%NOTFOUND)
314: THEN
315: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
316: FND_MSG_PUB.ADD;
317: CLOSE Get_all_appl_mrs;
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;

Line 360: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');

356: END LOOP; -- All Applicable MRs
357: END IF; -- Table Count > 0
358:
359: IF (l_mr_applicable_flag = false) THEN
360: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF; -- MR applicable
364:

Line 497: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');

493: SELECT title
494: INTO l_mr_title
495: FROM AHL_MR_HEADERS_B
496: WHERE mr_header_id = l_appl_mrs_relns.RELATED_MR_HEADER_ID;
497: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
498: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
499: FND_MSG_PUB.ADD;
500: CLOSE Chk_UE_Init_Due;
501: RAISE FND_API.G_EXC_ERROR;

Line 498: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);

494: INTO l_mr_title
495: FROM AHL_MR_HEADERS_B
496: WHERE mr_header_id = l_appl_mrs_relns.RELATED_MR_HEADER_ID;
497: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
498: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
499: FND_MSG_PUB.ADD;
500: CLOSE Chk_UE_Init_Due;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;

Line 858: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');

854:
855: -- if the ue id to be deleted is not found
856: IF (l_originator_ue_id IS NULL)
857: THEN
858: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: ELSE
862: -- validate the existance of the Unit Effectivity Id

Line 866: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');

862: -- validate the existance of the Unit Effectivity Id
863: OPEN GetStatusCode (p_unit_effectivity_id);
864: FETCH GetStatusCode INTO l_get_status_code,l_object_type;
865: IF (GetStatusCode%NOTFOUND) THEN
866: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
867: FND_MSG_PUB.ADD;
868: CLOSE GetStatusCode;
869: RAISE FND_API.G_EXC_ERROR;
870: ELSIF ( l_get_status_code IS NOT NULL AND l_get_status_code NOT IN ('EXCEPTION')

Line 872: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');

868: CLOSE GetStatusCode;
869: RAISE FND_API.G_EXC_ERROR;
870: ELSIF ( l_get_status_code IS NOT NULL AND l_get_status_code NOT IN ('EXCEPTION')
871: AND l_object_type = 'SR')THEN
872: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
873: FND_MSG_PUB.ADD;
874: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
875: fnd_log.string
876: (

Line 893: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_STATUS_NULL'); -- mesg reused

889: OPEN GetStatusCode( l_all_ue_ids.RELATED_UE_ID);
890: FETCH GetStatusCode into l_get_status_code,l_object_type ;
891: IF (GetStatusCode%NOTFOUND)
892: THEN
893: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_STATUS_NULL'); -- mesg reused
894: FND_MSG_PUB.ADD;
895: CLOSE GetStatusCode;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;

Line 907: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');

903: -- deletes all related ue ids of the originator ue id of the ue id passed for deletion.
904: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW( l_all_ue_ids.RELATED_UE_ID);
905:
906: ELSE
907: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
908: FND_MSG_PUB.ADD;
909: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
910: fnd_log.string
911: (