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 170: l_msg_count := FND_MSG_PUB.COUNT_MSG;

166: x_appln_code => l_appln_code,
167: x_return_status => l_return_status
168: );
169:
170: l_msg_count := FND_MSG_PUB.COUNT_MSG;
171: IF (l_msg_count > 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS)
172: THEN
173: RAISE FND_API.G_EXC_ERROR;
174: END IF;

Line 184: FND_MSG_PUB.Initialize;

180: END IF;
181:
182:
183: IF (p_init_msg_list = FND_API.G_TRUE) THEN
184: FND_MSG_PUB.Initialize;
185: END IF;
186:
187: -- API body starts here
188: -- If (p_mr_header_id is null or p_instance_id is null), then display error

Line 197: FND_MSG_PUB.ADD;

193: )
194: THEN
195: FND_MESSAGE.SET_NAME('AHL', 'AHL_COM_INVALID_PROCEDURE_CALL');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', l_api_name);
197: FND_MSG_PUB.ADD;
198: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
199: fnd_log.string
200: (
201: G_DEBUG_ERROR,

Line 215: FND_MSG_PUB.ADD;

211: FETCH check_mr_exists INTO l_dummy_varchar;
212: IF (check_mr_exists%NOTFOUND)
213: THEN
214: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_MR_NOT_FOUND');
215: FND_MSG_PUB.ADD;
216: CLOSE check_mr_exists;
217: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
218: fnd_log.string
219: (

Line 235: FND_MSG_PUB.ADD;

231: FETCH check_instance_exists INTO l_dummy_varchar;
232: IF (check_instance_exists%NOTFOUND)
233: THEN
234: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_INVALID_CSI_INSTANCE'); --message reused
235: FND_MSG_PUB.ADD;
236: CLOSE check_instance_exists;
237: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL )THEN
238: fnd_log.string
239: (

Line 253: FND_MSG_PUB.add;

249: --Set the return status to an error and raise an error message if the application code returned is not AHL
250: IF (l_appln_code <> 'AHL') THEN
251: x_return_status := FND_API.G_RET_STS_ERROR;
252: FND_MESSAGE.set_name('AHL', 'AHL_COM_APPL_USG_MODE_INVALID');
253: FND_MSG_PUB.add;
254: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
255: fnd_log.string
256: (
257: G_DEBUG_ERROR,

Line 277: FND_MSG_PUB.ADD;

273: WHERE mr_header_id = p_mr_header_id ;
274:
275: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
276: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
277: FND_MSG_PUB.ADD;
278: CLOSE Chk_UE_Init_Due;
279: RAISE FND_API.G_EXC_ERROR;
280: END IF;
281: CLOSE Chk_UE_Init_Due;

Line 300: x_msg_count := FND_MSG_PUB.count_msg;

296: x_return_status => x_return_status,
297: x_msg_count => x_msg_count,
298: x_msg_data => x_msg_data);
299:
300: x_msg_count := FND_MSG_PUB.count_msg;
301: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )
302: THEN
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;

Line 316: FND_MSG_PUB.ADD;

312: FETCH Get_all_appl_mrs INTO l_all_appl_mrs;
313: IF (Get_all_appl_mrs%NOTFOUND)
314: THEN
315: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
316: FND_MSG_PUB.ADD;
317: CLOSE Get_all_appl_mrs;
318: RAISE FND_API.G_EXC_ERROR;
319: END IF;
320:

Line 337: x_msg_count := FND_MSG_PUB.count_msg;

333: p_mr_header_id => p_mr_header_id,
334: p_components_flag => 'N', -- get applicability for only this instance.
335: x_applicable_mr_tbl => l_applicable_mr_tbl);
336:
337: x_msg_count := FND_MSG_PUB.count_msg;
338: IF ( x_msg_count > 0 OR x_return_status <> FND_API.G_RET_STS_SUCCESS )
339: THEN
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;

Line 361: FND_MSG_PUB.ADD;

357: END IF; -- Table Count > 0
358:
359: IF (l_mr_applicable_flag = false) THEN
360: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
361: FND_MSG_PUB.ADD;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF; -- MR applicable
364:
365: l_all_appl_mrs.csi_item_instance_id := p_instance_id;

Line 469: x_msg_count := FND_MSG_PUB.count_msg;

465: p_top_mr_id => l_all_appl_mrs.MR_HEADER_ID ,
466: p_top_item_instance_id => l_all_appl_mrs.CSI_ITEM_INSTANCE_ID ,
467: p_init_temp_table => 'Y'); -- To clean up temp table first
468:
469: x_msg_count := FND_MSG_PUB.count_msg;
470: IF x_msg_count > 0
471: THEN
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;

Line 499: FND_MSG_PUB.ADD;

495: FROM AHL_MR_HEADERS_B
496: WHERE mr_header_id = l_appl_mrs_relns.RELATED_MR_HEADER_ID;
497: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_CANNOT_ADD_MRS');
498: FND_MESSAGE.SET_TOKEN('MR_TITLE',l_mr_title);
499: FND_MSG_PUB.ADD;
500: CLOSE Chk_UE_Init_Due;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503: CLOSE Chk_UE_Init_Due;

Line 670: x_msg_count := FND_MSG_PUB.count_msg;

666: );
667: END IF;
668:
669: -- Check Error Message stack.
670: x_msg_count := FND_MSG_PUB.count_msg;
671: IF x_msg_count > 0
672: THEN
673: RAISE FND_API.G_EXC_ERROR;
674: END IF;

Line 689: FND_MSG_PUB.count_and_get

685: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
686: 'Expected error'
687: );
688: END IF;
689: FND_MSG_PUB.count_and_get
690: (
691: p_count => x_msg_count,
692: p_data => x_msg_data,
693: p_encoded => FND_API.G_FALSE

Line 707: FND_MSG_PUB.count_and_get

703: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
704: 'Unexpected error'
705: );
706: END IF;
707: FND_MSG_PUB.count_and_get
708: (
709: p_count => x_msg_count,
710: p_data => x_msg_data,
711: p_encoded => FND_API.G_FALSE

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

713:
714: WHEN OTHERS THEN
715: Rollback to sp_create_unit_effectivity;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
718: THEN
719: FND_MSG_PUB.add_exc_msg
720: (
721: p_pkg_name => G_PKG_NAME,

Line 719: FND_MSG_PUB.add_exc_msg

715: Rollback to sp_create_unit_effectivity;
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
718: THEN
719: FND_MSG_PUB.add_exc_msg
720: (
721: p_pkg_name => G_PKG_NAME,
722: p_procedure_name => 'Create_Unit_Effectivity',
723: p_error_text => SUBSTR(SQLERRM,1,240)

Line 734: FND_MSG_PUB.count_and_get

730: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
731: 'Other errors'
732: );
733: END IF;
734: FND_MSG_PUB.count_and_get
735: (
736: p_count => x_msg_count,
737: p_data => x_msg_data,
738: p_encoded => FND_API.G_FALSE

Line 831: l_msg_count := FND_MSG_PUB.COUNT_MSG;

827: x_appln_code => l_appln_code,
828: x_return_status => l_return_status
829: );
830:
831: l_msg_count := FND_MSG_PUB.COUNT_MSG;
832: IF (l_msg_count > 0)
833: THEN
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;

Line 859: FND_MSG_PUB.ADD;

855: -- if the ue id to be deleted is not found
856: IF (l_originator_ue_id IS NULL)
857: THEN
858: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
859: FND_MSG_PUB.ADD;
860: RAISE FND_API.G_EXC_ERROR;
861: ELSE
862: -- validate the existance of the Unit Effectivity Id
863: OPEN GetStatusCode (p_unit_effectivity_id);

Line 867: FND_MSG_PUB.ADD;

863: OPEN GetStatusCode (p_unit_effectivity_id);
864: FETCH GetStatusCode INTO l_get_status_code,l_object_type;
865: IF (GetStatusCode%NOTFOUND) THEN
866: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_NOT_FOUND');
867: FND_MSG_PUB.ADD;
868: CLOSE GetStatusCode;
869: RAISE FND_API.G_EXC_ERROR;
870: ELSIF ( l_get_status_code IS NOT NULL AND l_get_status_code NOT IN ('EXCEPTION')
871: AND l_object_type = 'SR')THEN

Line 873: FND_MSG_PUB.ADD;

869: RAISE FND_API.G_EXC_ERROR;
870: ELSIF ( l_get_status_code IS NOT NULL AND l_get_status_code NOT IN ('EXCEPTION')
871: AND l_object_type = 'SR')THEN
872: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
873: FND_MSG_PUB.ADD;
874: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
875: fnd_log.string
876: (
877: G_DEBUG_ERROR,

Line 894: FND_MSG_PUB.ADD;

890: FETCH GetStatusCode into l_get_status_code,l_object_type ;
891: IF (GetStatusCode%NOTFOUND)
892: THEN
893: FND_MESSAGE.SET_NAME('AHL', 'AHL_UMP_STATUS_NULL'); -- mesg reused
894: FND_MSG_PUB.ADD;
895: CLOSE GetStatusCode;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF;
898: CLOSE GetStatusCode;

Line 908: FND_MSG_PUB.ADD;

904: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW( l_all_ue_ids.RELATED_UE_ID);
905:
906: ELSE
907: FND_MESSAGE.SET_NAME('AHL', 'AHL_UA_UE_CANNOT_DELETE');
908: FND_MSG_PUB.ADD;
909: IF (G_DEBUG_ERROR >= G_DEBUG_LEVEL)THEN
910: fnd_log.string
911: (
912: G_DEBUG_ERROR,

Line 960: x_msg_count := FND_MSG_PUB.count_msg;

956: );
957: END IF;
958:
959: -- Check Error Message stack.
960: x_msg_count := FND_MSG_PUB.count_msg;
961: IF x_msg_count > 0
962: THEN
963: RAISE FND_API.G_EXC_ERROR;
964: END IF;

Line 967: FND_MSG_PUB.count_and_get

963: RAISE FND_API.G_EXC_ERROR;
964: END IF;
965:
966: -- Standard call to get message count and if count is 1, get message info
967: FND_MSG_PUB.count_and_get
968: (
969: p_count => x_msg_count,
970: p_data => x_msg_data,
971: p_encoded => FND_API.G_FALSE

Line 986: FND_MSG_PUB.count_and_get

982: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
983: 'Expected error'
984: );
985: END IF;
986: FND_MSG_PUB.count_and_get
987: (
988: p_count => x_msg_count,
989: p_data => x_msg_data,
990: p_encoded => FND_API.G_FALSE

Line 1004: FND_MSG_PUB.count_and_get

1000: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1001: 'Unexpected error'
1002: );
1003: END IF;
1004: FND_MSG_PUB.count_and_get
1005: (
1006: p_count => x_msg_count,
1007: p_data => x_msg_data,
1008: p_encoded => FND_API.G_FALSE

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

1010:
1011: WHEN OTHERS THEN
1012: Rollback to sp_delete_unit_effectivity;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1015: THEN
1016: FND_MSG_PUB.add_exc_msg
1017: (
1018: p_pkg_name => G_PKG_NAME,

Line 1016: FND_MSG_PUB.add_exc_msg

1012: Rollback to sp_delete_unit_effectivity;
1013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1015: THEN
1016: FND_MSG_PUB.add_exc_msg
1017: (
1018: p_pkg_name => G_PKG_NAME,
1019: p_procedure_name => 'Delete_Unit_Effectivity',
1020: p_error_text => SUBSTR(SQLERRM,1,240)

Line 1031: FND_MSG_PUB.count_and_get

1027: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||'.begin',
1028: 'Other errors'
1029: );
1030: END IF;
1031: FND_MSG_PUB.count_and_get
1032: (
1033: p_count => x_msg_count,
1034: p_data => x_msg_data,
1035: p_encoded => FND_API.G_FALSE