DBA Data[Home] [Help]

APPS.AHL_VISIT_TYPE_PVT dependencies on FND_MSG_PUB

Line 55: FND_MSG_PUB.initialize;

51:
52: -- Initialize API return status to success
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_boolean(p_init_msg_list) THEN
55: FND_MSG_PUB.initialize;
56: END IF;
57:
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:

Line 110: FND_MSG_PUB.add;

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:
114: ------------------------End of API Body--------------------------------------

Line 130: Fnd_Msg_Pub.count_and_get (

126:
127: WHEN Fnd_Api.g_exc_error THEN
128: ROLLBACK TO Delete_Visit_Type;
129: x_return_status := Fnd_Api.g_ret_sts_error;
130: Fnd_Msg_Pub.count_and_get (
131: p_encoded => Fnd_Api.g_false,
132: p_count => x_msg_count,
133: p_data => x_msg_data);
134: AHL_DEBUG_PUB.debug('Delete_Visit_Type: In g_exc_unexpected_error block ' || ' x_msg_count ' || x_msg_count );

Line 139: Fnd_Msg_Pub.count_and_get (

135:
136: WHEN Fnd_Api.g_exc_unexpected_error THEN
137: ROLLBACK TO Delete_Visit_Type;
138: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
139: Fnd_Msg_Pub.count_and_get (
140: p_encoded => Fnd_Api.g_false,
141: p_count => x_msg_count,
142: p_data => x_msg_data);
143: AHL_DEBUG_PUB.debug('Delete_Visit_Type: In g_exc_unexpected_error block ' || ' x_msg_count ' || x_msg_count );

Line 149: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

145:
146: WHEN OTHERS THEN
147: ROLLBACK TO Delete_Visit_Type;
148: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
149: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
150: THEN
151: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
152: END IF;
153: Fnd_Msg_Pub.count_and_get (

Line 151: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

147: ROLLBACK TO Delete_Visit_Type;
148: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
149: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
150: THEN
151: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
152: END IF;
153: Fnd_Msg_Pub.count_and_get (
154: p_encoded => Fnd_Api.g_false,
155: p_count => x_msg_count,

Line 153: Fnd_Msg_Pub.count_and_get (

149: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
150: THEN
151: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
152: END IF;
153: Fnd_Msg_Pub.count_and_get (
154: p_encoded => Fnd_Api.g_false,
155: p_count => x_msg_count,
156: p_data => x_msg_data);
157: AHL_DEBUG_PUB.debug('Delete_Visit_Type: In OTHERS block ' || ' x_msg_count ' || x_msg_count );

Line 245: FND_MSG_PUB.initialize;

241:
242: -- Initialize API return status to success
243: -- Initialize message list if p_init_msg_list is set to TRUE.
244: IF FND_API.to_boolean(p_init_msg_list) THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248: x_return_status := FND_API.G_RET_STS_SUCCESS;
249:

Line 282: Fnd_Msg_Pub.ADD;

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:
286: -- check if any of the stages have stage type count as 0, If yes

Line 296: Fnd_Msg_Pub.ADD;

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:
300: END LOOP;

Line 350: FND_MSG_PUB.add;

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;
354:

Line 372: Fnd_Msg_Pub.count_and_get (

368:
369: WHEN Fnd_Api.g_exc_error THEN
370: ROLLBACK TO Complete_Visit_Type;
371: x_return_status := Fnd_Api.g_ret_sts_error;
372: Fnd_Msg_Pub.count_and_get (
373: p_encoded => Fnd_Api.g_false,
374: p_count => x_msg_count,
375: p_data => x_msg_data);
376: AHL_DEBUG_PUB.debug('Complete_Visit_Type: In g_exc_error block ' || ' x_msg_count ' || x_msg_count );

Line 381: Fnd_Msg_Pub.count_and_get (

377:
378: WHEN Fnd_Api.g_exc_unexpected_error THEN
379: ROLLBACK TO Complete_Visit_Type;
380: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
381: Fnd_Msg_Pub.count_and_get (
382: p_encoded => Fnd_Api.g_false,
383: p_count => x_msg_count,
384: p_data => x_msg_data);
385: AHL_DEBUG_PUB.debug('Complete_Visit_Type: In G_EXC_UNEXPECTED_ERROR block ' || ' x_msg_count ' || x_msg_count );

Line 391: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

387:
388: WHEN OTHERS THEN
389: ROLLBACK TO Complete_Visit_Type;
390: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
391: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
392: THEN
393: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
394: END IF;
395: Fnd_Msg_Pub.count_and_get (

Line 393: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

389: ROLLBACK TO Complete_Visit_Type;
390: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
391: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
392: THEN
393: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
394: END IF;
395: Fnd_Msg_Pub.count_and_get (
396: p_encoded => Fnd_Api.g_false,
397: p_count => x_msg_count,

Line 395: Fnd_Msg_Pub.count_and_get (

391: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
392: THEN
393: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
394: END IF;
395: Fnd_Msg_Pub.count_and_get (
396: p_encoded => Fnd_Api.g_false,
397: p_count => x_msg_count,
398: p_data => x_msg_data);
399: AHL_DEBUG_PUB.debug('Complete_Visit_Type: In OTHERS block ' || ' x_msg_count ' || x_msg_count );

Line 478: FND_MSG_PUB.initialize;

474: END IF;
475:
476: -- Initialize message list if p_init_msg_list is set to TRUE.
477: IF FND_API.to_boolean(p_init_msg_list) THEN
478: FND_MSG_PUB.initialize;
479: END IF;
480:
481: -- Initialize API return status to success
482: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 501: Fnd_Msg_Pub.ADD;

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:
505:

Line 876: Fnd_Msg_Pub.count_and_get (

872:
873: WHEN Fnd_Api.g_exc_error THEN
874: ROLLBACK TO Create_Rev_Visit_Type;
875: x_return_status := Fnd_Api.g_ret_sts_error;
876: Fnd_Msg_Pub.count_and_get (
877: p_encoded => Fnd_Api.g_false,
878: p_count => x_msg_count,
879: p_data => x_msg_data);
880:

Line 884: Fnd_Msg_Pub.count_and_get (

880:
881: WHEN Fnd_Api.g_exc_unexpected_error THEN
882: ROLLBACK TO Create_Rev_Visit_Type;
883: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
884: Fnd_Msg_Pub.count_and_get (
885: p_encoded => Fnd_Api.g_false,
886: p_count => x_msg_count,
887: p_data => x_msg_data);
888:

Line 892: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)

888:
889: WHEN OTHERS THEN
890: ROLLBACK TO Create_Rev_Visit_Type;
891: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
892: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
893: THEN
894: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
895: END IF;
896: Fnd_Msg_Pub.count_and_get (

Line 894: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);

890: ROLLBACK TO Create_Rev_Visit_Type;
891: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
892: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
893: THEN
894: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
895: END IF;
896: Fnd_Msg_Pub.count_and_get (
897: p_encoded => Fnd_Api.g_false,
898: p_count => x_msg_count,

Line 896: Fnd_Msg_Pub.count_and_get (

892: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_unexp_error)
893: THEN
894: Fnd_Msg_Pub.add_exc_msg (G_PKG_NAME, l_api_name);
895: END IF;
896: Fnd_Msg_Pub.count_and_get (
897: p_encoded => Fnd_Api.g_false,
898: p_count => x_msg_count,
899: p_data => x_msg_data);
900: