eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_UC_INSTANCE_PUB dependencies on FND_MSG_PUB

Line 40: FND_MSG_PUB.add;

36: IF p_uc_header_id IS NULL AND p_uc_name IS NULL THEN
37: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
38: FND_MESSAGE.set_token('NAME', 'uc_name');
39: FND_MESSAGE.set_token('VALUE', p_uc_name);
40: FND_MSG_PUB.add;
41: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
42: ELSIF p_uc_header_id IS NULL AND p_uc_name IS NOT NULL THEN
43: OPEN get_uc_header_id;
44: FETCH get_uc_header_id INTO x_uc_header_id;

Line 49: FND_MSG_PUB.add;

45: IF get_uc_header_id%NOTFOUND THEN
46: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
47: FND_MESSAGE.set_token('NAME', 'uc_name');
48: FND_MESSAGE.set_token('VALUE', p_uc_name);
49: FND_MSG_PUB.add;
50: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
51: END IF;
52: CLOSE get_uc_header_id;
53: ELSIF p_uc_header_id IS NOT NULL AND p_uc_name IS NULL THEN

Line 60: FND_MSG_PUB.add;

56: IF check_uc_header_id%NOTFOUND THEN
57: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
58: FND_MESSAGE.set_token('NAME', 'uc_header_id');
59: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
60: FND_MSG_PUB.add;
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
62: END IF;
63: CLOSE check_uc_header_id;
64: ELSIF p_uc_header_id IS NOT NULL AND p_uc_name IS NOT NULL THEN

Line 71: FND_MSG_PUB.add;

67: IF get_uc_header_id%NOTFOUND OR p_uc_header_id <> x_uc_header_id THEN
68: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
69: FND_MESSAGE.set_token('NAME', 'uc_name');
70: FND_MESSAGE.set_token('VALUE', p_uc_name);
71: FND_MSG_PUB.add;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: END IF;
74: CLOSE get_uc_header_id;
75: END IF;

Line 100: FND_MSG_PUB.add;

96: IF p_instance_id IS NULL AND p_instance_num IS NULL THEN
97: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
98: FND_MESSAGE.set_token('NAME', 'instance_number');
99: FND_MESSAGE.set_token('VALUE', p_instance_num);
100: FND_MSG_PUB.add;
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102: ELSIF p_instance_id IS NULL AND p_instance_num IS NOT NULL THEN
103: OPEN get_instance_id;
104: FETCH get_instance_id INTO x_instance_id;

Line 109: FND_MSG_PUB.add;

105: IF get_instance_id%NOTFOUND THEN
106: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
107: FND_MESSAGE.set_token('NAME', 'instance_number');
108: FND_MESSAGE.set_token('VALUE', p_instance_num);
109: FND_MSG_PUB.add;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: END IF;
112: CLOSE get_instance_id;
113: ELSIF p_instance_id IS NOT NULL AND p_instance_num IS NULL THEN

Line 120: FND_MSG_PUB.add;

116: IF check_instance_id%NOTFOUND THEN
117: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
118: FND_MESSAGE.set_token('NAME', 'instance_id');
119: FND_MESSAGE.set_token('VALUE', p_instance_id);
120: FND_MSG_PUB.add;
121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
122: END IF;
123: CLOSE check_instance_id;
124: ELSIF p_instance_id IS NOT NULL AND p_instance_num IS NOT NULL THEN

Line 131: FND_MSG_PUB.add;

127: IF get_instance_id%NOTFOUND OR p_instance_id <> x_instance_id THEN
128: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
129: FND_MESSAGE.set_token('NAME', 'instance_number');
130: FND_MESSAGE.set_token('VALUE', p_instance_num);
131: FND_MSG_PUB.add;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: END IF;
134: CLOSE get_instance_id;
135: END IF;

Line 184: FND_MSG_PUB.initialize;

180: END IF;
181:
182: --Initialize message list if p_init_msg_list is set to TRUE.
183: IF FND_API.to_boolean(p_init_msg_list) THEN
184: FND_MSG_PUB.initialize;
185: END IF;
186:
187: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
188: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 222: FND_MSG_PUB.add;

218: IF get_csi_ii_ovn%NOTFOUND THEN
219: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
220: FND_MESSAGE.set_token('NAME', 'instance_id');
221: FND_MESSAGE.set_token('VALUE', l_instance_id);
222: FND_MSG_PUB.add;
223: CLOSE get_csi_ii_ovn;
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225: END IF;
226: CLOSE get_csi_ii_ovn;

Line 255: l_msg_count := FND_MSG_PUB.count_msg;

251: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
252: END IF;
253:
254: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
255: l_msg_count := FND_MSG_PUB.count_msg;
256: IF l_msg_count > 0 THEN
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259: -- Perform the Commit (if requested)

Line 264: FND_MSG_PUB.count_and_get(

260: IF FND_API.to_boolean( p_commit ) THEN
261: COMMIT;
262: END IF;
263: -- Count and Get messages (optional)
264: FND_MSG_PUB.count_and_get(
265: p_encoded => FND_API.G_FALSE,
266: p_count => x_msg_count,
267: p_data => x_msg_data);
268:

Line 273: FND_MSG_PUB.count_and_get(

269: EXCEPTION
270: WHEN FND_API.G_EXC_ERROR THEN
271: ROLLBACK TO unassociate_instance;
272: x_return_status := FND_API.G_RET_STS_ERROR ;
273: FND_MSG_PUB.count_and_get(
274: p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data);
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 280: FND_MSG_PUB.count_and_get(

276: p_data => x_msg_data);
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: ROLLBACK TO unassociate_instance;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: FND_MSG_PUB.count_and_get(
281: p_encoded => FND_API.G_FALSE,
282: p_count => x_msg_count,
283: p_data => x_msg_data);
284: WHEN OTHERS THEN

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

283: p_data => x_msg_data);
284: WHEN OTHERS THEN
285: ROLLBACK TO unassociate_instance;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
288: THEN
289: FND_MSG_PUB.add_exc_msg(
290: p_pkg_name => G_PKG_NAME,
291: p_procedure_name => l_api_name,

Line 289: FND_MSG_PUB.add_exc_msg(

285: ROLLBACK TO unassociate_instance;
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
287: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
288: THEN
289: FND_MSG_PUB.add_exc_msg(
290: p_pkg_name => G_PKG_NAME,
291: p_procedure_name => l_api_name,
292: p_error_text => SUBSTRB(SQLERRM,1,240));
293: END IF;

Line 294: FND_MSG_PUB.count_and_get(

290: p_pkg_name => G_PKG_NAME,
291: p_procedure_name => l_api_name,
292: p_error_text => SUBSTRB(SQLERRM,1,240));
293: END IF;
294: FND_MSG_PUB.count_and_get(
295: p_encoded => FND_API.G_FALSE,
296: p_count => x_msg_count,
297: p_data => x_msg_data);
298: END unassociate_instance;

Line 346: FND_MSG_PUB.initialize;

342: END IF;
343:
344: --Initialize message list if p_init_msg_list is set to TRUE.
345: IF FND_API.to_boolean(p_init_msg_list) THEN
346: FND_MSG_PUB.initialize;
347: END IF;
348:
349: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
350: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 384: FND_MSG_PUB.add;

380: IF get_csi_ii_ovn%NOTFOUND THEN
381: FND_MESSAGE.set_name('AHL','AHL_UC_API_PARAMETER_INVALID');
382: FND_MESSAGE.set_token('NAME', 'instance_id');
383: FND_MESSAGE.set_token('VALUE', l_instance_id);
384: FND_MSG_PUB.add;
385: CLOSE get_csi_ii_ovn;
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388: CLOSE get_csi_ii_ovn;

Line 417: l_msg_count := FND_MSG_PUB.count_msg;

413: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
414: END IF;
415:
416: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
417: l_msg_count := FND_MSG_PUB.count_msg;
418: IF l_msg_count > 0 THEN
419: RAISE FND_API.G_EXC_ERROR;
420: END IF;
421: -- Perform the Commit (if requested)

Line 426: FND_MSG_PUB.count_and_get(

422: IF FND_API.to_boolean( p_commit ) THEN
423: COMMIT;
424: END IF;
425: -- Count and Get messages (optional)
426: FND_MSG_PUB.count_and_get(
427: p_encoded => FND_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data);
430:

Line 435: FND_MSG_PUB.count_and_get(

431: EXCEPTION
432: WHEN FND_API.G_EXC_ERROR THEN
433: ROLLBACK TO remove_instance;
434: x_return_status := FND_API.G_RET_STS_ERROR ;
435: FND_MSG_PUB.count_and_get(
436: p_encoded => FND_API.G_FALSE,
437: p_count => x_msg_count,
438: p_data => x_msg_data);
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 442: FND_MSG_PUB.count_and_get(

438: p_data => x_msg_data);
439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
440: ROLLBACK TO remove_instance;
441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
442: FND_MSG_PUB.count_and_get(
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count,
445: p_data => x_msg_data);
446: WHEN OTHERS THEN

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

445: p_data => x_msg_data);
446: WHEN OTHERS THEN
447: ROLLBACK TO remove_instance;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: FND_MSG_PUB.add_exc_msg(
452: p_pkg_name => G_PKG_NAME,
453: p_procedure_name => l_api_name,

Line 451: FND_MSG_PUB.add_exc_msg(

447: ROLLBACK TO remove_instance;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
449: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: FND_MSG_PUB.add_exc_msg(
452: p_pkg_name => G_PKG_NAME,
453: p_procedure_name => l_api_name,
454: p_error_text => SUBSTRB(SQLERRM,1,240));
455: END IF;

Line 456: FND_MSG_PUB.count_and_get(

452: p_pkg_name => G_PKG_NAME,
453: p_procedure_name => l_api_name,
454: p_error_text => SUBSTRB(SQLERRM,1,240));
455: END IF;
456: FND_MSG_PUB.count_and_get(
457: p_encoded => FND_API.G_FALSE,
458: p_count => x_msg_count,
459: p_data => x_msg_data);
460: END remove_instance;

Line 506: FND_MSG_PUB.initialize;

502: END IF;
503:
504: --Initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_boolean(p_init_msg_list) THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
510: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 552: l_msg_count := FND_MSG_PUB.count_msg;

548: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
549: END IF;
550:
551: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
552: l_msg_count := FND_MSG_PUB.count_msg;
553: IF l_msg_count > 0 THEN
554: RAISE FND_API.G_EXC_ERROR;
555: END IF;
556: -- Perform the Commit (if requested)

Line 561: FND_MSG_PUB.count_and_get(

557: IF FND_API.to_boolean( p_commit ) THEN
558: COMMIT;
559: END IF;
560: -- Count and Get messages (optional)
561: FND_MSG_PUB.count_and_get(
562: p_encoded => FND_API.G_FALSE,
563: p_count => x_msg_count,
564: p_data => x_msg_data);
565:

Line 570: FND_MSG_PUB.count_and_get(

566: EXCEPTION
567: WHEN FND_API.G_EXC_ERROR THEN
568: ROLLBACK TO update_instance;
569: x_return_status := FND_API.G_RET_STS_ERROR ;
570: FND_MSG_PUB.count_and_get(
571: p_encoded => FND_API.G_FALSE,
572: p_count => x_msg_count,
573: p_data => x_msg_data);
574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 577: FND_MSG_PUB.count_and_get(

573: p_data => x_msg_data);
574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: ROLLBACK TO update_instance;
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
577: FND_MSG_PUB.count_and_get(
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,
580: p_data => x_msg_data);
581: WHEN OTHERS THEN

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

580: p_data => x_msg_data);
581: WHEN OTHERS THEN
582: ROLLBACK TO update_instance;
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.add_exc_msg(
587: p_pkg_name => G_PKG_NAME,
588: p_procedure_name => l_api_name,

Line 586: FND_MSG_PUB.add_exc_msg(

582: ROLLBACK TO update_instance;
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
585: THEN
586: FND_MSG_PUB.add_exc_msg(
587: p_pkg_name => G_PKG_NAME,
588: p_procedure_name => l_api_name,
589: p_error_text => SUBSTRB(SQLERRM,1,240));
590: END IF;

Line 591: FND_MSG_PUB.count_and_get(

587: p_pkg_name => G_PKG_NAME,
588: p_procedure_name => l_api_name,
589: p_error_text => SUBSTRB(SQLERRM,1,240));
590: END IF;
591: FND_MSG_PUB.count_and_get(
592: p_encoded => FND_API.G_FALSE,
593: p_count => x_msg_count,
594: p_data => x_msg_data);
595: END update_instance;

Line 646: FND_MSG_PUB.initialize;

642: END IF;
643:
644: --Initialize message list if p_init_msg_list is set to TRUE.
645: IF FND_API.to_boolean(p_init_msg_list) THEN
646: FND_MSG_PUB.initialize;
647: END IF;
648:
649: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 704: l_msg_count := FND_MSG_PUB.count_msg;

700: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
701: END IF;
702:
703: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
704: l_msg_count := FND_MSG_PUB.count_msg;
705: IF l_msg_count > 0 THEN
706: RAISE FND_API.G_EXC_ERROR;
707: END IF;
708: -- Perform the Commit (if requested)

Line 713: FND_MSG_PUB.count_and_get(

709: IF FND_API.to_boolean( p_commit ) THEN
710: COMMIT;
711: END IF;
712: -- Count and Get messages (optional)
713: FND_MSG_PUB.count_and_get(
714: p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data);
717:

Line 722: FND_MSG_PUB.count_and_get(

718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO create_install_instance;
721: x_return_status := FND_API.G_RET_STS_ERROR ;
722: FND_MSG_PUB.count_and_get(
723: p_encoded => FND_API.G_FALSE,
724: p_count => x_msg_count,
725: p_data => x_msg_data);
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 729: FND_MSG_PUB.count_and_get(

725: p_data => x_msg_data);
726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
727: ROLLBACK TO create_install_instance;
728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
729: FND_MSG_PUB.count_and_get(
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_msg_count,
732: p_data => x_msg_data);
733: WHEN OTHERS THEN

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

732: p_data => x_msg_data);
733: WHEN OTHERS THEN
734: ROLLBACK TO create_install_instance;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
736: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: FND_MSG_PUB.add_exc_msg(
739: p_pkg_name => G_PKG_NAME,
740: p_procedure_name => l_api_name,

Line 738: FND_MSG_PUB.add_exc_msg(

734: ROLLBACK TO create_install_instance;
735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
736: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738: FND_MSG_PUB.add_exc_msg(
739: p_pkg_name => G_PKG_NAME,
740: p_procedure_name => l_api_name,
741: p_error_text => SUBSTRB(SQLERRM,1,240));
742: END IF;

Line 743: FND_MSG_PUB.count_and_get(

739: p_pkg_name => G_PKG_NAME,
740: p_procedure_name => l_api_name,
741: p_error_text => SUBSTRB(SQLERRM,1,240));
742: END IF;
743: FND_MSG_PUB.count_and_get(
744: p_encoded => FND_API.G_FALSE,
745: p_count => x_msg_count,
746: p_data => x_msg_data);
747: END create_install_instance;

Line 798: FND_MSG_PUB.initialize;

794: END IF;
795:
796: --Initialize message list if p_init_msg_list is set to TRUE.
797: IF FND_API.to_boolean(p_init_msg_list) THEN
798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
802: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 878: l_msg_count := FND_MSG_PUB.count_msg;

874: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
875: END IF;
876:
877: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
878: l_msg_count := FND_MSG_PUB.count_msg;
879: IF l_msg_count > 0 THEN
880: RAISE FND_API.G_EXC_ERROR;
881: END IF;
882: -- Perform the Commit (if requested)

Line 887: FND_MSG_PUB.count_and_get(

883: IF FND_API.to_boolean( p_commit ) THEN
884: COMMIT;
885: END IF;
886: -- Count and Get messages (optional)
887: FND_MSG_PUB.count_and_get(
888: p_encoded => FND_API.G_FALSE,
889: p_count => x_msg_count,
890: p_data => x_msg_data);
891:

Line 896: FND_MSG_PUB.count_and_get(

892: EXCEPTION
893: WHEN FND_API.G_EXC_ERROR THEN
894: ROLLBACK TO install_instance;
895: x_return_status := FND_API.G_RET_STS_ERROR ;
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: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 903: FND_MSG_PUB.count_and_get(

899: p_data => x_msg_data);
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901: ROLLBACK TO install_instance;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903: FND_MSG_PUB.count_and_get(
904: p_encoded => FND_API.G_FALSE,
905: p_count => x_msg_count,
906: p_data => x_msg_data);
907: WHEN OTHERS THEN

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

906: p_data => x_msg_data);
907: WHEN OTHERS THEN
908: ROLLBACK TO install_instance;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
911: THEN
912: FND_MSG_PUB.add_exc_msg(
913: p_pkg_name => G_PKG_NAME,
914: p_procedure_name => l_api_name,

Line 912: FND_MSG_PUB.add_exc_msg(

908: ROLLBACK TO install_instance;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
910: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
911: THEN
912: FND_MSG_PUB.add_exc_msg(
913: p_pkg_name => G_PKG_NAME,
914: p_procedure_name => l_api_name,
915: p_error_text => SUBSTRB(SQLERRM,1,240));
916: END IF;

Line 917: FND_MSG_PUB.count_and_get(

913: p_pkg_name => G_PKG_NAME,
914: p_procedure_name => l_api_name,
915: p_error_text => SUBSTRB(SQLERRM,1,240));
916: END IF;
917: FND_MSG_PUB.count_and_get(
918: p_encoded => FND_API.G_FALSE,
919: p_count => x_msg_count,
920: p_data => x_msg_data);
921: END install_instance;

Line 976: FND_MSG_PUB.initialize;

972: END IF;
973:
974: --Initialize message list if p_init_msg_list is set to TRUE.
975: IF FND_API.to_boolean(p_init_msg_list) THEN
976: FND_MSG_PUB.initialize;
977: END IF;
978:
979: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
980: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 1066: l_msg_count := FND_MSG_PUB.count_msg;

1062: 'ahl.plsql.'||G_PKG_NAME||'.'||l_api_name||': After normal execution','At the end of the procedure');
1063: END IF;
1064:
1065: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1066: l_msg_count := FND_MSG_PUB.count_msg;
1067: IF l_msg_count > 0 THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070: -- Perform the Commit (if requested)

Line 1075: FND_MSG_PUB.count_and_get(

1071: IF FND_API.to_boolean( p_commit ) THEN
1072: COMMIT;
1073: END IF;
1074: -- Count and Get messages (optional)
1075: FND_MSG_PUB.count_and_get(
1076: p_encoded => FND_API.G_FALSE,
1077: p_count => x_msg_count,
1078: p_data => x_msg_data);
1079:

Line 1084: FND_MSG_PUB.count_and_get(

1080: EXCEPTION
1081: WHEN FND_API.G_EXC_ERROR THEN
1082: ROLLBACK TO swap_instance;
1083: x_return_status := FND_API.G_RET_STS_ERROR ;
1084: FND_MSG_PUB.count_and_get(
1085: p_encoded => FND_API.G_FALSE,
1086: p_count => x_msg_count,
1087: p_data => x_msg_data);
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1091: FND_MSG_PUB.count_and_get(

1087: p_data => x_msg_data);
1088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1089: ROLLBACK TO swap_instance;
1090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1091: FND_MSG_PUB.count_and_get(
1092: p_encoded => FND_API.G_FALSE,
1093: p_count => x_msg_count,
1094: p_data => x_msg_data);
1095: WHEN OTHERS THEN

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

1094: p_data => x_msg_data);
1095: WHEN OTHERS THEN
1096: ROLLBACK TO swap_instance;
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1099: THEN
1100: FND_MSG_PUB.add_exc_msg(
1101: p_pkg_name => G_PKG_NAME,
1102: p_procedure_name => l_api_name,

Line 1100: FND_MSG_PUB.add_exc_msg(

1096: ROLLBACK TO swap_instance;
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1099: THEN
1100: FND_MSG_PUB.add_exc_msg(
1101: p_pkg_name => G_PKG_NAME,
1102: p_procedure_name => l_api_name,
1103: p_error_text => SUBSTRB(SQLERRM,1,240));
1104: END IF;

Line 1105: FND_MSG_PUB.count_and_get(

1101: p_pkg_name => G_PKG_NAME,
1102: p_procedure_name => l_api_name,
1103: p_error_text => SUBSTRB(SQLERRM,1,240));
1104: END IF;
1105: FND_MSG_PUB.count_and_get(
1106: p_encoded => FND_API.G_FALSE,
1107: p_count => x_msg_count,
1108: p_data => x_msg_data);
1109: END swap_instance;

Line 1154: FND_MSG_PUB.Initialize;

1150: END IF;
1151:
1152: -- Initialize message list if p_init_msg_list is set to TRUE
1153: IF FND_API.To_Boolean(p_init_msg_list) THEN
1154: FND_MSG_PUB.Initialize;
1155: END IF;
1156:
1157: -- Validate the parameters which are not present in the private API. All the other
1158: -- parameters are validated in the corresponding private API.

Line 1194: FND_MSG_PUB.Count_And_Get

1190: COMMIT WORK;
1191: END IF;
1192:
1193: -- Standard call to get message count and if count is 1, get message info
1194: FND_MSG_PUB.Count_And_Get
1195: ( p_count => x_msg_count,
1196: p_data => x_msg_data,
1197: p_encoded => FND_API.G_FALSE
1198: );

Line 1208: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: Rollback to create_unassigned_instance;
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1209: p_data => x_msg_data,
1210: p_encoded => fnd_api.g_false);
1211:
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1215: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1211:
1212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1213: Rollback to create_unassigned_instance;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1216: p_data => x_msg_data,
1217: p_encoded => fnd_api.g_false);
1218:
1219: WHEN OTHERS THEN

Line 1222: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,

1218:
1219: WHEN OTHERS THEN
1220: Rollback to create_unassigned_instance;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
1223: p_procedure_name => l_api_name,
1224: p_error_text => SQLERRM);
1225: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1226: p_data => x_msg_data,

Line 1225: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: FND_MSG_PUB.Add_Exc_Msg( p_pkg_name => G_PKG_NAME,
1223: p_procedure_name => l_api_name,
1224: p_error_text => SQLERRM);
1225: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1226: p_data => x_msg_data,
1227: p_encoded => FND_API.G_FALSE);
1228:
1229: END create_unassigned_instance;