DBA Data[Home] [Help]

APPS.AHL_VISIT_TYPE_PVT dependencies on FND_MESSAGE

Line 109: FND_MESSAGE.set_name('AHL','AHL_VST_TYP_REC_CHNGD');

105: DELETE FROM AHL_VISIT_TYPES_B
106: WHERE VISIT_TYPE_ID = p_visit_type_id;
107:
108: IF ( SQL%ROWCOUNT = 0 ) THEN
109: FND_MESSAGE.set_name('AHL','AHL_VST_TYP_REC_CHNGD');
110: FND_MSG_PUB.add;
111: x_return_status := FND_API.G_RET_STS_ERROR;
112: END IF;
113:

Line 279: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYPE_STG_REQ');

275: FETCH count_stage INTO L_count_stage;
276: CLOSE count_stage;
277:
278: if (l_count_stage = 0) THEN
279: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYPE_STG_REQ');
280: Fnd_Message.Set_Token('VISIT_TYPE', l_visit_type);
281: Fnd_Message.Set_Token('MASTER_CONFIG', L_MC_Name);
282: Fnd_Msg_Pub.ADD;
283: RAISE Fnd_Api.G_EXC_ERROR;

Line 280: Fnd_Message.Set_Token('VISIT_TYPE', l_visit_type);

276: CLOSE count_stage;
277:
278: if (l_count_stage = 0) THEN
279: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYPE_STG_REQ');
280: Fnd_Message.Set_Token('VISIT_TYPE', l_visit_type);
281: Fnd_Message.Set_Token('MASTER_CONFIG', L_MC_Name);
282: Fnd_Msg_Pub.ADD;
283: RAISE Fnd_Api.G_EXC_ERROR;
284: END IF;

Line 281: Fnd_Message.Set_Token('MASTER_CONFIG', L_MC_Name);

277:
278: if (l_count_stage = 0) THEN
279: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYPE_STG_REQ');
280: Fnd_Message.Set_Token('VISIT_TYPE', l_visit_type);
281: Fnd_Message.Set_Token('MASTER_CONFIG', L_MC_Name);
282: Fnd_Msg_Pub.ADD;
283: RAISE Fnd_Api.G_EXC_ERROR;
284: END IF;
285:

Line 292: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_TYP_REQ');

288: FOR stage_rec in count_stage_type(p_visit_type_id)
289: LOOP
290:
291: If( stage_rec.count = 0) THEN
292: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_TYP_REQ');
293: Fnd_Message.Set_Token('VISIT_TYPE', l_visit_type);
294: Fnd_Message.Set_Token('MASTER_CONFIG', L_MC_Name);
295: Fnd_Message.Set_Token('STAGE_NUM', stage_rec.STAGE_NUMBER);
296: Fnd_Msg_Pub.ADD;

Line 293: Fnd_Message.Set_Token('VISIT_TYPE', l_visit_type);

289: LOOP
290:
291: If( stage_rec.count = 0) THEN
292: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_TYP_REQ');
293: Fnd_Message.Set_Token('VISIT_TYPE', l_visit_type);
294: Fnd_Message.Set_Token('MASTER_CONFIG', L_MC_Name);
295: Fnd_Message.Set_Token('STAGE_NUM', stage_rec.STAGE_NUMBER);
296: Fnd_Msg_Pub.ADD;
297: RAISE Fnd_Api.G_EXC_ERROR;

Line 294: Fnd_Message.Set_Token('MASTER_CONFIG', L_MC_Name);

290:
291: If( stage_rec.count = 0) THEN
292: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_TYP_REQ');
293: Fnd_Message.Set_Token('VISIT_TYPE', l_visit_type);
294: Fnd_Message.Set_Token('MASTER_CONFIG', L_MC_Name);
295: Fnd_Message.Set_Token('STAGE_NUM', stage_rec.STAGE_NUMBER);
296: Fnd_Msg_Pub.ADD;
297: RAISE Fnd_Api.G_EXC_ERROR;
298: END IF;

Line 295: Fnd_Message.Set_Token('STAGE_NUM', stage_rec.STAGE_NUMBER);

291: If( stage_rec.count = 0) THEN
292: Fnd_Message.SET_NAME('AHL','AHL_VWP_STG_TYP_REQ');
293: Fnd_Message.Set_Token('VISIT_TYPE', l_visit_type);
294: Fnd_Message.Set_Token('MASTER_CONFIG', L_MC_Name);
295: Fnd_Message.Set_Token('STAGE_NUM', stage_rec.STAGE_NUMBER);
296: Fnd_Msg_Pub.ADD;
297: RAISE Fnd_Api.G_EXC_ERROR;
298: END IF;
299:

Line 349: FND_MESSAGE.set_name('AHL','AHL_VWP_VST_TYP_REC_CHNGD');

345: WHERE VISIT_TYPE_ID = p_visit_type_id
346: and object_version_number = p_obj_version_num;
347:
348: IF(SQL%ROWCOUNT = 0 ) THEN
349: FND_MESSAGE.set_name('AHL','AHL_VWP_VST_TYP_REC_CHNGD');
350: FND_MSG_PUB.add;
351: x_return_status := FND_API.G_RET_STS_ERROR;
352: END IF;
353: END IF;

Line 498: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYP_DRAFT_EXISTS');

494:
495: -- If a draft record already exists then the visit type can not be completed
496: -- So corresponding error is thrown
497: if (L_visit_type is not null) THEN
498: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYP_DRAFT_EXISTS');
499: Fnd_Message.Set_Token('VISIT_TYPE', L_visit_type);
500: Fnd_Message.Set_Token('MC_NAME', L_mc_name);
501: Fnd_Msg_Pub.ADD;
502: RAISE Fnd_Api.G_EXC_ERROR;

Line 499: Fnd_Message.Set_Token('VISIT_TYPE', L_visit_type);

495: -- If a draft record already exists then the visit type can not be completed
496: -- So corresponding error is thrown
497: if (L_visit_type is not null) THEN
498: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYP_DRAFT_EXISTS');
499: Fnd_Message.Set_Token('VISIT_TYPE', L_visit_type);
500: Fnd_Message.Set_Token('MC_NAME', L_mc_name);
501: Fnd_Msg_Pub.ADD;
502: RAISE Fnd_Api.G_EXC_ERROR;
503: END IF;

Line 500: Fnd_Message.Set_Token('MC_NAME', L_mc_name);

496: -- So corresponding error is thrown
497: if (L_visit_type is not null) THEN
498: Fnd_Message.SET_NAME('AHL','AHL_VWP_VST_TYP_DRAFT_EXISTS');
499: Fnd_Message.Set_Token('VISIT_TYPE', L_visit_type);
500: Fnd_Message.Set_Token('MC_NAME', L_mc_name);
501: Fnd_Msg_Pub.ADD;
502: RAISE Fnd_Api.G_EXC_ERROR;
503: END IF;
504: