DBA Data[Home] [Help]

APPS.AHL_LTP_SIMUL_PLAN_PUB dependencies on FND_MSG_PUB

Line 72: FND_MSG_PUB.initialize;

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

Line 102: l_msg_count := Fnd_Msg_Pub.count_msg;

98: x_msg_count => l_msg_count,
99: x_msg_data => l_msg_data
100: );
101: --Standard check to count messages
102: l_msg_count := Fnd_Msg_Pub.count_msg;
103:
104: IF l_msg_count > 0 THEN
105: X_msg_count := l_msg_count;
106: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 125: l_msg_count := Fnd_Msg_Pub.count_msg;

121: x_msg_count => l_msg_count,
122: x_msg_data => l_msg_data
123: );
124: --Standard check to count messages
125: l_msg_count := Fnd_Msg_Pub.count_msg;
126:
127: IF l_msg_count > 0 THEN
128: X_msg_count := l_msg_count;
129: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 147: l_msg_count := Fnd_Msg_Pub.count_msg;

143: x_msg_data => l_msg_data
144: );
145: END IF;
146: --Standard check to count messages
147: l_msg_count := Fnd_Msg_Pub.count_msg;
148:
149: IF l_msg_count > 0 THEN
150: X_msg_count := l_msg_count;
151: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 160: l_msg_count := Fnd_Msg_Pub.count_msg;

156: END IF;
157:
158: ------------------------End of Body---------------------------------------
159: --Standard check to count messages
160: l_msg_count := Fnd_Msg_Pub.count_msg;
161:
162: IF l_msg_count > 0 THEN
163: X_msg_count := l_msg_count;
164: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 185: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

181: EXCEPTION
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO process_simulation_plan;
184: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
186: p_count => x_msg_count,
187: p_data => x_msg_data);
188:
189: IF G_DEBUG='Y' THEN

Line 200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

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

211:
212: WHEN OTHERS THEN
213: ROLLBACK TO process_simulation_plan;
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_SIMUL_PLAN_PUB',
218: p_procedure_name => 'PROCESS_SIMULATION_PLAN',
219: p_error_text => SUBSTR(SQLERRM,1,240));

Line 217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

213: ROLLBACK TO process_simulation_plan;
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_SIMUL_PLAN_PUB',
218: p_procedure_name => 'PROCESS_SIMULATION_PLAN',
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_SIMUL_PLAN_PUB',
218: p_procedure_name => 'PROCESS_SIMULATION_PLAN',
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:
225: -- Debug info.

Line 286: FND_MSG_PUB.initialize;

282: END IF;
283: -- Standard call to check for call compatibility.
284: IF FND_API.to_boolean(p_init_msg_list)
285: THEN
286: FND_MSG_PUB.initialize;
287: END IF;
288: -- Initialize API return status to success
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 332: l_msg_count := Fnd_Msg_Pub.count_msg;

328: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
329: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);
330: END IF;
331: --Standard check to count messages
332: l_msg_count := Fnd_Msg_Pub.count_msg;
333:
334: IF l_msg_count > 0 THEN
335: X_msg_count := l_msg_count;
336: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 386: l_msg_count := Fnd_Msg_Pub.count_msg;

382: AHL_DEBUG_PUB.debug( 'plan_id'||p_simulation_visit_tbl(i).plan_id);
383: AHL_DEBUG_PUB.debug( 'flag'||p_simulation_visit_tbl(i).operation_flag);
384: END IF;
385: --Standard check to count messages
386: l_msg_count := Fnd_Msg_Pub.count_msg;
387:
388: IF l_msg_count > 0 THEN
389: X_msg_count := l_msg_count;
390: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 409: l_msg_count := Fnd_Msg_Pub.count_msg;

405: x_msg_count => l_msg_count,
406: x_msg_data => l_msg_data);
407: END IF;
408: --Standard check to count messages
409: l_msg_count := Fnd_Msg_Pub.count_msg;
410:
411: IF l_msg_count > 0 THEN
412: X_msg_count := l_msg_count;
413: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 421: l_msg_count := Fnd_Msg_Pub.count_msg;

417: END LOOP;
418: END IF;
419: ------------------------End of Body---------------------------------------
420: --Standard check to count messages
421: l_msg_count := Fnd_Msg_Pub.count_msg;
422:
423: IF l_msg_count > 0 THEN
424: X_msg_count := l_msg_count;
425: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 446: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

442: EXCEPTION
443: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
444: ROLLBACK TO process_simulation_visit;
445: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
447: p_count => x_msg_count,
448: p_data => x_msg_data);
449:
450: IF G_DEBUG='Y' THEN

Line 461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

457:
458: WHEN FND_API.G_EXC_ERROR THEN
459: ROLLBACK TO process_simulation_visit;
460: X_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
462: p_count => x_msg_count,
463: p_data => X_msg_data);
464: -- Debug info.
465: IF G_DEBUG='Y' THEN

Line 476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

472:
473: WHEN OTHERS THEN
474: ROLLBACK TO process_simulation_visit;
475: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
477: THEN
478: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
479: p_procedure_name => 'PROCESS_SIMULATION_VISIT',
480: p_error_text => SUBSTR(SQLERRM,1,240));

Line 478: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

474: ROLLBACK TO process_simulation_visit;
475: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
477: THEN
478: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
479: p_procedure_name => 'PROCESS_SIMULATION_VISIT',
480: p_error_text => SUBSTR(SQLERRM,1,240));
481: END IF;
482: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 482: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

478: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
479: p_procedure_name => 'PROCESS_SIMULATION_VISIT',
480: p_error_text => SUBSTR(SQLERRM,1,240));
481: END IF;
482: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
483: p_count => x_msg_count,
484: p_data => X_msg_data);
485:
486: -- Debug info.

Line 547: FND_MSG_PUB.initialize;

543: END IF;
544: -- Standard call to check for call compatibility.
545: IF FND_API.to_boolean(p_init_msg_list)
546: THEN
547: FND_MSG_PUB.initialize;
548: END IF;
549: -- Initialize API return status to success
550: x_return_status := FND_API.G_RET_STS_SUCCESS;
551: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 575: l_msg_count := Fnd_Msg_Pub.count_msg;

571:
572:
573: ------------------------End of Body---------------------------------------
574: --Standard check to count messages
575: l_msg_count := Fnd_Msg_Pub.count_msg;
576:
577: IF l_msg_count > 0 THEN
578: X_msg_count := l_msg_count;
579: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 598: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

594: EXCEPTION
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO toggle_simulation_delete;
597: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
599: p_count => x_msg_count,
600: p_data => x_msg_data);
601:
602: IF G_DEBUG='Y' THEN

Line 613: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

609:
610: WHEN FND_API.G_EXC_ERROR THEN
611: ROLLBACK TO toggle_simulation_delete;
612: X_return_status := FND_API.G_RET_STS_ERROR;
613: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
614: p_count => x_msg_count,
615: p_data => X_msg_data);
616: -- Debug info.
617: IF G_DEBUG='Y' THEN

Line 628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

624:
625: WHEN OTHERS THEN
626: ROLLBACK TO toggle_simulation_delete;
627: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
631: p_procedure_name => 'TOGGLE_SIMULATION_DELETE',
632: p_error_text => SUBSTR(SQLERRM,1,240));

Line 630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

626: ROLLBACK TO toggle_simulation_delete;
627: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
631: p_procedure_name => 'TOGGLE_SIMULATION_DELETE',
632: p_error_text => SUBSTR(SQLERRM,1,240));
633: END IF;
634: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 634: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

630: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
631: p_procedure_name => 'TOGGLE_SIMULATION_DELETE',
632: p_error_text => SUBSTR(SQLERRM,1,240));
633: END IF;
634: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
635: p_count => x_msg_count,
636: p_data => X_msg_data);
637:
638: -- Debug info.

Line 699: FND_MSG_PUB.initialize;

695: END IF;
696: -- Standard call to check for call compatibility.
697: IF FND_API.to_boolean(p_init_msg_list)
698: THEN
699: FND_MSG_PUB.initialize;
700: END IF;
701: -- Initialize API return status to success
702: x_return_status := FND_API.G_RET_STS_SUCCESS;
703: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 727: l_msg_count := Fnd_Msg_Pub.count_msg;

723:
724:
725: ------------------------End of Body---------------------------------------
726: --Standard check to count messages
727: l_msg_count := Fnd_Msg_Pub.count_msg;
728:
729: IF l_msg_count > 0 THEN
730: X_msg_count := l_msg_count;
731: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 750: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

746: EXCEPTION
747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
748: ROLLBACK TO set_plan_as_primary;
749: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
751: p_count => x_msg_count,
752: p_data => x_msg_data);
753:
754: IF G_DEBUG='Y' THEN

Line 765: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

761:
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO set_plan_as_primary;
764: X_return_status := FND_API.G_RET_STS_ERROR;
765: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
766: p_count => x_msg_count,
767: p_data => X_msg_data);
768: -- Debug info.
769: IF G_DEBUG='Y' THEN

Line 780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

776:
777: WHEN OTHERS THEN
778: ROLLBACK TO set_plan_as_primary;
779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
781: THEN
782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
783: p_procedure_name => 'SET_PLAN_AS_PRIMARY',
784: p_error_text => SUBSTR(SQLERRM,1,240));

Line 782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

778: ROLLBACK TO set_plan_as_primary;
779: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
781: THEN
782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
783: p_procedure_name => 'SET_PLAN_AS_PRIMARY',
784: p_error_text => SUBSTR(SQLERRM,1,240));
785: END IF;
786: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 786: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
783: p_procedure_name => 'SET_PLAN_AS_PRIMARY',
784: p_error_text => SUBSTR(SQLERRM,1,240));
785: END IF;
786: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
787: p_count => x_msg_count,
788: p_data => X_msg_data);
789:
790: -- Debug info.

Line 852: FND_MSG_PUB.initialize;

848: END IF;
849: -- Standard call to check for call compatibility.
850: IF FND_API.to_boolean(p_init_msg_list)
851: THEN
852: FND_MSG_PUB.initialize;
853: END IF;
854: -- Initialize API return status to success
855: x_return_status := FND_API.G_RET_STS_SUCCESS;
856: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 881: l_msg_count := Fnd_Msg_Pub.count_msg;

877:
878:
879: ------------------------End of Body---------------------------------------
880: --Standard check to count messages
881: l_msg_count := Fnd_Msg_Pub.count_msg;
882:
883: IF l_msg_count > 0 THEN
884: X_msg_count := l_msg_count;
885: X_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 904: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

900: EXCEPTION
901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
902: ROLLBACK TO set_visit_as_primary;
903: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
905: p_count => x_msg_count,
906: p_data => x_msg_data);
907:
908: IF G_DEBUG='Y' THEN

Line 919: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

915:
916: WHEN FND_API.G_EXC_ERROR THEN
917: ROLLBACK TO set_visit_as_primary;
918: X_return_status := FND_API.G_RET_STS_ERROR;
919: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
920: p_count => x_msg_count,
921: p_data => X_msg_data);
922: -- Debug info.
923: IF G_DEBUG='Y' THEN

Line 934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

930:
931: WHEN OTHERS THEN
932: ROLLBACK TO set_visit_as_primary;
933: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
935: THEN
936: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
937: p_procedure_name => 'SET_VISIT_AS_PRIMARY',
938: p_error_text => SUBSTR(SQLERRM,1,240));

Line 936: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',

932: ROLLBACK TO set_visit_as_primary;
933: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
935: THEN
936: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
937: p_procedure_name => 'SET_VISIT_AS_PRIMARY',
938: p_error_text => SUBSTR(SQLERRM,1,240));
939: END IF;
940: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 940: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

936: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_LTP_SIMUL_PLAN_PUB',
937: p_procedure_name => 'SET_VISIT_AS_PRIMARY',
938: p_error_text => SUBSTR(SQLERRM,1,240));
939: END IF;
940: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
941: p_count => x_msg_count,
942: p_data => X_msg_data);
943:
944: -- Debug info.