DBA Data[Home] [Help]

APPS.AHL_PRD_NONROUTINE_PUB dependencies on FND_MESSAGE

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

26: BEGIN
27: OPEN get_user_id_csr(p_user_id);
28: FETCH get_user_id_csr INTO l_user_id;
29: IF get_user_id_csr%NOTFOUND THEN
30: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');
31: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);
32: FND_MSG_PUB.ADD;
33: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
34: END IF;

Line 31: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);

27: OPEN get_user_id_csr(p_user_id);
28: FETCH get_user_id_csr INTO l_user_id;
29: IF get_user_id_csr%NOTFOUND THEN
30: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');
31: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);
32: FND_MSG_PUB.ADD;
33: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
34: END IF;
35: CLOSE get_user_id_csr;

Line 218: FND_MESSAGE.SET_NAME ('AHL','AHL_NR_SUCC_MATRL_FAIL');

214: IF ( upper(x_return_status) <> FND_API.G_RET_STS_SUCCESS ) THEN
215: IF (l_log_statement >= l_log_current_level) THEN
216: fnd_log.string(fnd_log.level_statement,l_debug_module,'Error after AHL_PP_MATERIALS_PVT.Create_Material_Reqst');
217: ROLLBACK TO CREATE_NON_ROUTINE_MTRLS_SP;
218: FND_MESSAGE.SET_NAME ('AHL','AHL_NR_SUCC_MATRL_FAIL');
219: FND_MSG_PUB.ADD;
220: END IF;
221: -- RAISE FND_API.G_EXC_ERROR;
222: END IF;

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

356: AND NVL(tsk.instance_id,vst.item_instance_id)=csi.instance_id
357: AND wo.workorder_id = p_create_nr_input_rec.ORIGINATOR_WORKORDER_ID;
358: EXCEPTION
359: WHEN NO_DATA_FOUND THEN
360: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: WHEN TOO_MANY_ROWS THEN
364: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');

Line 364: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');

360: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: WHEN TOO_MANY_ROWS THEN
364: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
365: FND_MSG_PUB.ADD;
366: RAISE FND_API.G_EXC_ERROR;
367: END;
368: ELSIF

Line 387: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');

383: AND NVL(TSK.INSTANCE_ID,VST.ITEM_INSTANCE_ID)=CSI.INSTANCE_ID
384: AND WO.WORKORDER_NAME = p_create_nr_input_rec.ORIGINATOR_WORKORDER_NUMBER;
385: EXCEPTION
386: WHEN NO_DATA_FOUND THEN
387: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
388: FND_MSG_PUB.ADD;
389: RAISE FND_API.G_EXC_ERROR;
390: WHEN TOO_MANY_ROWS THEN
391: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');

Line 391: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');

387: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
388: FND_MSG_PUB.ADD;
389: RAISE FND_API.G_EXC_ERROR;
390: WHEN TOO_MANY_ROWS THEN
391: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
392: FND_MSG_PUB.ADD;
393: RAISE FND_API.G_EXC_ERROR;
394: END;
395: ELSE

Line 396: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');

392: FND_MSG_PUB.ADD;
393: RAISE FND_API.G_EXC_ERROR;
394: END;
395: ELSE
396: FND_MESSAGE.SET_NAME ('AHL','AHL_PRD_INVLD_WO');
397: FND_MSG_PUB.ADD;
398: RAISE FND_API.G_EXC_ERROR;
399: END IF;
400:

Line 530: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_INVALID');

526: OPEN get_instance_details(p_create_nr_input_rec.unit_name);
527: FETCH get_instance_details INTO x_nr_task_rec.instance_number,x_nr_task_rec.serial_number;
528: IF get_instance_details%NOTFOUND THEN
529: CLOSE get_instance_details;
530: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_INVALID');
531: FND_MESSAGE.Set_Token('NAME',p_create_nr_input_rec.unit_name);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;

Line 531: FND_MESSAGE.Set_Token('NAME',p_create_nr_input_rec.unit_name);

527: FETCH get_instance_details INTO x_nr_task_rec.instance_number,x_nr_task_rec.serial_number;
528: IF get_instance_details%NOTFOUND THEN
529: CLOSE get_instance_details;
530: FND_MESSAGE.Set_Name('AHL','AHL_UMP_PUE_UNIT_INVALID');
531: FND_MESSAGE.Set_Token('NAME',p_create_nr_input_rec.unit_name);
532: FND_MSG_PUB.ADD;
533: RAISE FND_API.G_EXC_ERROR;
534: END IF;
535: CLOSE get_instance_details;