DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_ASSIGN_PUB dependencies on FND_MSG_PUB

Line 71: Fnd_Msg_Pub.initialize;

67: END IF;
68: -- Standard call to check for call compatibility.
69: IF Fnd_Api.to_boolean(p_init_msg_list)
70: THEN
71: Fnd_Msg_Pub.initialize;
72: END IF;
73: -- Initialize API return status to success
74: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
75: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 138: l_msg_count := Fnd_Msg_Pub.count_msg;

134: --
135: END LOOP;
136: --
137: --Standard check to count messages
138: l_msg_count := Fnd_Msg_Pub.count_msg;
139:
140: IF l_msg_count > 0 THEN
141: X_msg_count := l_msg_count;
142: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 163: l_msg_count := Fnd_Msg_Pub.count_msg;

159: x_msg_data => l_msg_data);
160: END IF; -- Visit ID
161: ------------------------End of Body---------------------------------------
162: --Standard check to count messages
163: l_msg_count := Fnd_Msg_Pub.count_msg;
164:
165: IF l_msg_count > 0 THEN
166: X_msg_count := l_msg_count;
167: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 187: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

183: EXCEPTION
184: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
185: ROLLBACK TO Assign_Sch_Visit_Spaces;
186: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
187: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
188: p_count => x_msg_count,
189: p_data => x_msg_data);
190: IF G_DEBUG='Y' THEN
191:

Line 201: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

197: END IF;
198: WHEN Fnd_Api.G_EXC_ERROR THEN
199: ROLLBACK TO Assign_Sch_Visit_Spaces;
200: X_return_status := Fnd_Api.G_RET_STS_ERROR;
201: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
202: p_count => x_msg_count,
203: p_data => X_msg_data);
204: IF G_DEBUG='Y' THEN
205: -- Debug info.

Line 215: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

211: END IF;
212: WHEN OTHERS THEN
213: ROLLBACK TO Assign_Sch_Visit_Spaces;
214: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
215: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
216: THEN
217: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PUB',
218: p_procedure_name => 'ASSIGN_SCH_VISIT_SPACES',
219: p_error_text => SUBSTR(SQLERRM,1,240));

Line 217: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PUB',

213: ROLLBACK TO Assign_Sch_Visit_Spaces;
214: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
215: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
216: THEN
217: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PUB',
218: p_procedure_name => 'ASSIGN_SCH_VISIT_SPACES',
219: p_error_text => SUBSTR(SQLERRM,1,240));
220: END IF;
221: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 221: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

217: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SPACE_ASSIGN_PUB',
218: p_procedure_name => 'ASSIGN_SCH_VISIT_SPACES',
219: p_error_text => SUBSTR(SQLERRM,1,240));
220: END IF;
221: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
222: p_count => x_msg_count,
223: p_data => X_msg_data);
224: IF G_DEBUG='Y' THEN
225:

Line 278: Fnd_Msg_Pub.initialize;

274: END IF;
275: -- Standard call to check for call compatibility.
276: IF Fnd_Api.to_boolean(p_init_msg_list)
277: THEN
278: Fnd_Msg_Pub.initialize;
279: END IF;
280: -- Initialize API return status to success
281: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
282: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 305: l_msg_count := Fnd_Msg_Pub.count_msg;

301: END IF;
302:
303: ------------------------End of Body---------------------------------------
304: --Standard check to count messages
305: l_msg_count := Fnd_Msg_Pub.count_msg;
306:
307: IF l_msg_count > 0 THEN
308: X_msg_count := l_msg_count;
309: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 330: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

326: EXCEPTION
327: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
328: ROLLBACK TO schedule_visit;
329: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
330: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
331: p_count => x_msg_count,
332: p_data => x_msg_data);
333: IF G_DEBUG='Y' THEN
334:

Line 344: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

340: END IF;
341: WHEN Fnd_Api.G_EXC_ERROR THEN
342: ROLLBACK TO schedule_visit;
343: X_return_status := Fnd_Api.G_RET_STS_ERROR;
344: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
345: p_count => x_msg_count,
346: p_data => X_msg_data);
347: IF G_DEBUG='Y' THEN
348: -- Debug info.

Line 358: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

354: END IF;
355: WHEN OTHERS THEN
356: ROLLBACK TO schedule_visit;
357: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
358: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
359: THEN
360: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_SPACE_ASSIGN_PUB',
361: p_procedure_name => 'SCHEDULE_VISIT',
362: p_error_text => SUBSTR(SQLERRM,1,240));

Line 360: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_SPACE_ASSIGN_PUB',

356: ROLLBACK TO schedule_visit;
357: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
358: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
359: THEN
360: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_SPACE_ASSIGN_PUB',
361: p_procedure_name => 'SCHEDULE_VISIT',
362: p_error_text => SUBSTR(SQLERRM,1,240));
363: END IF;
364: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 364: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

360: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_SPACE_ASSIGN_PUB',
361: p_procedure_name => 'SCHEDULE_VISIT',
362: p_error_text => SUBSTR(SQLERRM,1,240));
363: END IF;
364: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
365: p_count => x_msg_count,
366: p_data => X_msg_data);
367: IF G_DEBUG='Y' THEN
368: -- Debug info.

Line 422: Fnd_Msg_Pub.initialize;

418: END IF;
419: -- Standard call to check for call compatibility.
420: IF Fnd_Api.to_boolean(p_init_msg_list)
421: THEN
422: Fnd_Msg_Pub.initialize;
423: END IF;
424: -- Initialize API return status to success
425: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
426: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 449: l_msg_count := Fnd_Msg_Pub.count_msg;

445: END IF;
446:
447: ------------------------End of Body---------------------------------------
448: --Standard check to count messages
449: l_msg_count := Fnd_Msg_Pub.count_msg;
450:
451: IF l_msg_count > 0 THEN
452: X_msg_count := l_msg_count;
453: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 473: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

469: EXCEPTION
470: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
471: ROLLBACK TO unschedule_visit;
472: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
473: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
474: p_count => x_msg_count,
475: p_data => x_msg_data);
476: IF G_DEBUG='Y' THEN
477:

Line 487: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

483: END IF;
484: WHEN Fnd_Api.G_EXC_ERROR THEN
485: ROLLBACK TO unschedule_visit;
486: X_return_status := Fnd_Api.G_RET_STS_ERROR;
487: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
488: p_count => x_msg_count,
489: p_data => X_msg_data);
490: IF G_DEBUG='Y' THEN
491: -- Debug info.

Line 501: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

497: END IF;
498: WHEN OTHERS THEN
499: ROLLBACK TO unschedule_visit;
500: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
501: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
502: THEN
503: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_SPACE_ASSIGN_PUB',
504: p_procedure_name => 'UNSCHEDULE_VISIT',
505: p_error_text => SUBSTR(SQLERRM,1,240));

Line 503: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_SPACE_ASSIGN_PUB',

499: ROLLBACK TO unschedule_visit;
500: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
501: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
502: THEN
503: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_SPACE_ASSIGN_PUB',
504: p_procedure_name => 'UNSCHEDULE_VISIT',
505: p_error_text => SUBSTR(SQLERRM,1,240));
506: END IF;
507: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

Line 507: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,

503: Fnd_Msg_Pub.add_exc_msg(p_pkg_name => 'AHL_DI_SPACE_ASSIGN_PUB',
504: p_procedure_name => 'UNSCHEDULE_VISIT',
505: p_error_text => SUBSTR(SQLERRM,1,240));
506: END IF;
507: Fnd_Msg_Pub.count_and_get( p_encoded => Fnd_Api.G_FALSE,
508: p_count => x_msg_count,
509: p_data => X_msg_data);
510: IF G_DEBUG='Y' THEN
511: