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_UMP_UNPLANNED_PVT dependencies on FND_MSG_PUB

Line 155: l_msg_count := FND_MSG_PUB.COUNT_MSG;

151: x_appln_code => l_appln_code,
152: x_return_status => l_return_status
153: );
154:
155: l_msg_count := FND_MSG_PUB.COUNT_MSG;
156: IF (l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS)
157: THEN
158: RAISE FND_API.G_EXC_ERROR;
159: END IF;

Line 169: FND_MSG_PUB.Initialize;

165: END IF;
166:
167:
168: IF (p_init_msg_list = FND_API.G_TRUE) THEN
169: FND_MSG_PUB.Initialize;
170: END IF;
171:
172: -- API body starts here
173: -- If (p_mr_header_id is null or p_instance_id is null), then display error

Line 182: FND_MSG_PUB.ADD;

178: )
179: THEN
180: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
181: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
182: FND_MSG_PUB.ADD;
183: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
184: fnd_log.string
185: (
186: G_DEBUG_ERROR,

Line 200: FND_MSG_PUB.ADD;

196: FETCH check_mr_exists INTO l_dummy_varchar;
197: IF (check_mr_exists%NOTFOUND)
198: THEN
199: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_MR_NOT_FOUND');
200: FND_MSG_PUB.ADD;
201: CLOSE check_mr_exists;
202: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
203: fnd_log.string
204: (

Line 220: FND_MSG_PUB.ADD;

216: FETCH check_instance_exists INTO l_dummy_varchar;
217: IF (check_instance_exists%NOTFOUND)
218: THEN
219: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE'); --message reused
220: FND_MSG_PUB.ADD;
221: CLOSE check_instance_exists;
222: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
223: fnd_log.string
224: (

Line 238: FND_MSG_PUB.add;

234: --Set the return status to an error and raise an error message if the application code returned is not AHL
235: IF (l_appln_code <> 'AHL') THEN
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
238: FND_MSG_PUB.add;
239: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
240: fnd_log.string
241: (
242: G_DEBUG_ERROR,

Line 266: x_msg_count := FND_MSG_PUB.count_msg;

262: x_return_status => x_return_status,
263: x_msg_count => x_msg_count,
264: x_msg_data => x_msg_data);
265:
266: x_msg_count := FND_MSG_PUB.count_msg;
267: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )
268: THEN
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;

Line 282: FND_MSG_PUB.ADD;

278: FETCH Get_all_appl_mrs INTO l_all_appl_mrs;
279: IF (Get_all_appl_mrs%NOTFOUND)
280: THEN
281: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
282: FND_MSG_PUB.ADD;
283: CLOSE Get_all_appl_mrs;
284: RAISE FND_API.G_EXC_ERROR;
285: END IF;
286:

Line 303: x_msg_count := FND_MSG_PUB.count_msg;

299: p_mr_header_id => p_mr_header_id,
300: p_components_flag => 'N', -- get applicability for only this instance.
301: x_applicable_mr_tbl => l_applicable_mr_tbl);
302:
303: x_msg_count := FND_MSG_PUB.count_msg;
304: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )
305: THEN
306: RAISE FND_API.G_EXC_ERROR;
307: END IF;

Line 327: FND_MSG_PUB.ADD;

323: END IF; -- Table Count > 0
324:
325: IF (l_mr_applicable_flag = false) THEN
326: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
327: FND_MSG_PUB.ADD;
328: RAISE FND_API.G_EXC_ERROR;
329: END IF; -- MR applicable
330:
331: l_all_appl_mrs.csi_item_instance_id := p_instance_id;

Line 421: x_msg_count := FND_MSG_PUB.count_msg;

417: p_top_mr_id => l_all_appl_mrs.MR_HEADER_ID ,
418: p_top_item_instance_id => l_all_appl_mrs.CSI_ITEM_INSTANCE_ID ,
419: p_init_temp_table => 'Y'); -- To clean up temp table first
420:
421: x_msg_count := FND_MSG_PUB.count_msg;
422: IF x_msg_count > 0
423: THEN
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;

Line 596: x_msg_count := FND_MSG_PUB.count_msg;

592: );
593: END IF;
594:
595: -- Check Error Message stack.
596: x_msg_count := FND_MSG_PUB.count_msg;
597: IF x_msg_count > 0
598: THEN
599: RAISE FND_API.G_EXC_ERROR;
600: END IF;

Line 615: FND_MSG_PUB.count_and_get

611: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
612: 'Expected error'
613: );
614: END IF;
615: FND_MSG_PUB.count_and_get
616: (
617: p_count => x_msg_count,
618: p_data => x_msg_data,
619: p_encoded => FND_API.G_FALSE

Line 633: FND_MSG_PUB.count_and_get

629: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
630: 'Unexpected error'
631: );
632: END IF;
633: FND_MSG_PUB.count_and_get
634: (
635: p_count => x_msg_count,
636: p_data => x_msg_data,
637: p_encoded => FND_API.G_FALSE

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

639:
640: WHEN OTHERS THEN
641: Rollback to sp_create_unit_effectivity;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
644: THEN
645: FND_MSG_PUB.add_exc_msg
646: (
647: p_pkg_name => G_PKG_NAME,

Line 645: FND_MSG_PUB.add_exc_msg

641: Rollback to sp_create_unit_effectivity;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
644: THEN
645: FND_MSG_PUB.add_exc_msg
646: (
647: p_pkg_name => G_PKG_NAME,
648: p_procedure_name => 'Create_Unit_Effectivity',
649: p_error_text => SUBSTR(SQLERRM,1,240)

Line 660: FND_MSG_PUB.count_and_get

656: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
657: 'Other errors'
658: );
659: END IF;
660: FND_MSG_PUB.count_and_get
661: (
662: p_count => x_msg_count,
663: p_data => x_msg_data,
664: p_encoded => FND_API.G_FALSE

Line 757: l_msg_count := FND_MSG_PUB.COUNT_MSG;

753: x_appln_code => l_appln_code,
754: x_return_status => l_return_status
755: );
756:
757: l_msg_count := FND_MSG_PUB.COUNT_MSG;
758: IF (l_msg_count > 0)
759: THEN
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;

Line 785: FND_MSG_PUB.ADD;

781: -- if the ue id to be deleted is not found
782: IF (l_originator_ue_id IS NULL)
783: THEN
784: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
785: FND_MSG_PUB.ADD;
786: RAISE FND_API.G_EXC_ERROR;
787: ELSE
788: -- validate the existance of the Unit Effectivity Id
789: OPEN GetStatusCode (p_unit_effectivity_id);

Line 793: FND_MSG_PUB.ADD;

789: OPEN GetStatusCode (p_unit_effectivity_id);
790: FETCH GetStatusCode INTO l_get_status_code,l_object_type;
791: IF (GetStatusCode%NOTFOUND) THEN
792: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
793: FND_MSG_PUB.ADD;
794: CLOSE GetStatusCode;
795: RAISE FND_API.G_EXC_ERROR;
796: ELSIF ( l_get_status_code IS NOT NULL AND l_get_status_code NOT IN ('EXCEPTION')
797: AND l_object_type = 'SR')THEN

Line 799: FND_MSG_PUB.ADD;

795: RAISE FND_API.G_EXC_ERROR;
796: ELSIF ( l_get_status_code IS NOT NULL AND l_get_status_code NOT IN ('EXCEPTION')
797: AND l_object_type = 'SR')THEN
798: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
799: FND_MSG_PUB.ADD;
800: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
801: fnd_log.string
802: (
803: G_DEBUG_ERROR,

Line 820: FND_MSG_PUB.ADD;

816: FETCH GetStatusCode into l_get_status_code,l_object_type ;
817: IF (GetStatusCode%NOTFOUND)
818: THEN
819: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_STATUS_NULL'); -- mesg reused
820: FND_MSG_PUB.ADD;
821: CLOSE GetStatusCode;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: CLOSE GetStatusCode;

Line 834: FND_MSG_PUB.ADD;

830: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW( l_all_ue_ids.RELATED_UE_ID);
831:
832: ELSE
833: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
834: FND_MSG_PUB.ADD;
835: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
836: fnd_log.string
837: (
838: G_DEBUG_ERROR,

Line 875: x_msg_count := FND_MSG_PUB.count_msg;

871: );
872: END IF;
873:
874: -- Check Error Message stack.
875: x_msg_count := FND_MSG_PUB.count_msg;
876: IF x_msg_count > 0
877: THEN
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;

Line 882: FND_MSG_PUB.count_and_get

878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880:
881: -- Standard call to get message count and if count is 1, get message info
882: FND_MSG_PUB.count_and_get
883: (
884: p_count => x_msg_count,
885: p_data => x_msg_data,
886: p_encoded => FND_API.G_FALSE

Line 901: FND_MSG_PUB.count_and_get

897: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
898: 'Expected error'
899: );
900: END IF;
901: FND_MSG_PUB.count_and_get
902: (
903: p_count => x_msg_count,
904: p_data => x_msg_data,
905: p_encoded => FND_API.G_FALSE

Line 919: FND_MSG_PUB.count_and_get

915: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
916: 'Unexpected error'
917: );
918: END IF;
919: FND_MSG_PUB.count_and_get
920: (
921: p_count => x_msg_count,
922: p_data => x_msg_data,
923: p_encoded => FND_API.G_FALSE

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

925:
926: WHEN OTHERS THEN
927: Rollback to sp_delete_unit_effectivity;
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
930: THEN
931: FND_MSG_PUB.add_exc_msg
932: (
933: p_pkg_name => G_PKG_NAME,

Line 931: FND_MSG_PUB.add_exc_msg

927: Rollback to sp_delete_unit_effectivity;
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
930: THEN
931: FND_MSG_PUB.add_exc_msg
932: (
933: p_pkg_name => G_PKG_NAME,
934: p_procedure_name => 'Delete_Unit_Effectivity',
935: p_error_text => SUBSTR(SQLERRM,1,240)

Line 946: FND_MSG_PUB.count_and_get

942: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
943: 'Other errors'
944: );
945: END IF;
946: FND_MSG_PUB.count_and_get
947: (
948: p_count => x_msg_count,
949: p_data => x_msg_data,
950: p_encoded => FND_API.G_FALSE