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

Line 777: FND_MSG_PUB.initialize;

773: AHL_DEBUG_PUB.enable_debug;
774: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
775: END IF;
776: IF FND_API.to_boolean(p_init_msg_list) THEN
777: FND_MSG_PUB.initialize;
778: END IF;
779: x_return_status := 'S';
780: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
781: p_api_version,

Line 798: FND_MSG_PUB.ADD;

794: FETCH check_mr_exists INTO l_mr_header_id;
795: IF check_mr_exists%NOTFOUND THEN
796: CLOSE check_mr_exists;
797: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR');
798: FND_MSG_PUB.ADD;
799: RAISE FND_API.G_EXC_ERROR;
800: END IF;
801: CLOSE check_mr_exists;
802: AHL_DEBUG_PUB.debug(' Phase 2');

Line 836: FND_MSG_PUB.ADD;

832: l_mr_header_id := l_mr_effect.mr_header_id;
833:
834: IF (l_mr_header_id <> p_mr_header_id) THEN
835: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR_EFFECTIVITY');
836: FND_MSG_PUB.ADD;
837: l_error_flag:='Y';
838: END IF;
839: --END IF;
840: END LOOP;

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

1184: END IF;
1185: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1186: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1189: p_count => x_msg_count,
1190: p_data => x_msg_data);
1191: IF l_debug = 'Y' THEN
1192: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

1196: END IF;
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1199: x_return_status := FND_API.G_RET_STS_ERROR;
1200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1201: p_count => x_msg_count,
1202: p_data => x_msg_data);
1203: IF l_debug = 'Y' THEN
1204: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 1212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1208: END IF;
1209: WHEN OTHERS THEN
1210: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1213: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1214: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1215: p_error_text => SUBSTR(SQLERRM,1,240));
1216: END IF;

Line 1213: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',

1209: WHEN OTHERS THEN
1210: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1213: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1214: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1215: p_error_text => SUBSTR(SQLERRM,1,240));
1216: END IF;
1217: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1213: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1214: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1215: p_error_text => SUBSTR(SQLERRM,1,240));
1216: END IF;
1217: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1218: p_count => x_msg_count,
1219: p_data => x_msg_data);
1220: IF l_debug = 'Y' THEN
1221: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

Line 2287: FND_MSG_PUB.initialize;

2283: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code, l_debug_prefix);
2284: END IF;
2285:
2286: IF FND_API.to_boolean(p_init_msg_list) THEN
2287: FND_MSG_PUB.initialize;
2288: END IF;
2289:
2290: x_return_status := 'S';
2291:

Line 2307: FND_MSG_PUB.ADD;

2303: IF check_instance_exists%NOTFOUND THEN
2304: CLOSE check_instance_exists;
2305: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
2306: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
2307: FND_MSG_PUB.ADD;
2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2309: END IF;
2310: CLOSE check_instance_exists;
2311: END IF;

Line 2764: FND_MSG_PUB.add;

2760: FETCH get_mr_attri INTO l_get_mr_attri;
2761: IF get_mr_attri%NOTFOUND THEN
2762: CLOSE get_mr_attri;
2763: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
2764: FND_MSG_PUB.add;
2765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2766: ELSE
2767: l_prev_mr_header_id := l_mr_header_id_tbl(i);
2768: CLOSE get_mr_attri;

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

3017:
3018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3019: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3021: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3022: p_count => x_msg_count,
3023: p_data => x_msg_data);
3024: IF l_debug = 'Y' THEN
3025: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

3030:
3031: WHEN FND_API.G_EXC_ERROR THEN
3032: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3033: x_return_status := FND_API.G_RET_STS_ERROR;
3034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3035: p_count => x_msg_count,
3036: p_data => x_msg_data);
3037: IF l_debug = 'Y' THEN
3038: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 3047: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3043:
3044: WHEN OTHERS THEN
3045: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3047: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3048: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3049: p_procedure_name => 'GET_APPLICABLE_MRS',
3050: p_error_text => SUBSTRB(SQLERRM,1,240));
3051: END IF;

Line 3048: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',

3044: WHEN OTHERS THEN
3045: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
3046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3047: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3048: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3049: p_procedure_name => 'GET_APPLICABLE_MRS',
3050: p_error_text => SUBSTRB(SQLERRM,1,240));
3051: END IF;
3052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

3048: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3049: p_procedure_name => 'GET_APPLICABLE_MRS',
3050: p_error_text => SUBSTRB(SQLERRM,1,240));
3051: END IF;
3052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3053: p_count => x_msg_count,
3054: p_data => x_msg_data);
3055: IF l_debug = 'Y' THEN
3056: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

Line 3451: FND_MSG_PUB.add;

3447: IF get_inst_attributes%NOTFOUND THEN
3448: CLOSE get_inst_attributes;
3449: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
3450: FND_MESSAGE.set_token('INSTANCE',p_item_instance_id);
3451: FND_MSG_PUB.add;
3452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3453: RETURN match_dtl;
3454: END IF;
3455: CLOSE get_inst_attributes;

Line 3961: FND_MSG_PUB.initialize;

3957: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3958: AHL_DEBUG_PUB.debug('');
3959: END IF;
3960: IF FND_API.to_boolean(p_init_msg_list) THEN
3961: FND_MSG_PUB.initialize;
3962: END IF;
3963: x_return_status := 'S';
3964: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
3965: l_api_name, G_PKG_NAME)

Line 3973: FND_MSG_PUB.add;

3969:
3970: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');
3971: IF l_appln_code <> 'PM' THEN
3972: FND_MESSAGE.set_name('AHL', 'AHL_FMP_PM_NOT_INSTALLED');
3973: FND_MSG_PUB.add;
3974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3975: END IF;
3976:
3977: OPEN check_instance_exists_csr(p_item_instance_id);

Line 3983: FND_MSG_PUB.ADD;

3979: IF check_instance_exists_csr%NOTFOUND THEN
3980: CLOSE check_instance_exists_csr;
3981: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
3982: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
3983: FND_MSG_PUB.ADD;
3984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3985: END IF;
3986: CLOSE check_instance_exists_csr;
3987:

Line 3995: FND_MSG_PUB.add;

3991: IF get_inventory_item%NOTFOUND THEN
3992: CLOSE get_inventory_item;
3993: FND_MESSAGE.set_name('AHL', 'AHL_FMP_ITEM_NOT_EXISTS');
3994: FND_MESSAGE.set_token('INSTANCE',p_item_instance_id);
3995: FND_MSG_PUB.add;
3996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3997: END IF;
3998: CLOSE get_inventory_item;
3999: */

Line 4034: FND_MSG_PUB.add;

4030: x_ent_contracts => l_ent_contracts,
4031: x_pm_activities => l_pm_activities );
4032: IF l_msg_count > 0 THEN
4033: FND_MESSAGE.set_name('AHL', 'AHL_FMP_CALLING_OKS_API_ERROR');
4034: FND_MSG_PUB.add;
4035: RAISE FND_API.G_EXC_ERROR;
4036: END IF;
4037:
4038: IF l_debug = 'Y' THEN

Line 4155: FND_MSG_PUB.add;

4151: FETCH get_mr_attri INTO l_get_mr_attri;
4152: IF get_mr_attri%NOTFOUND THEN
4153: CLOSE get_mr_attri;
4154: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
4155: FND_MSG_PUB.add;
4156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4157: ELSE
4158: x_applicable_activities_tbl(i).repetitive_flag := l_get_mr_attri.repetitive_flag;
4159: x_applicable_activities_tbl(i).show_repetitive_code := l_get_mr_attri.show_repetitive_code;

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

4171:
4172: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4173: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
4174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4175: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4176: p_count => x_msg_count,
4177: p_data => x_msg_data);
4178: IF l_debug = 'Y' THEN
4179: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

4183: END IF;
4184: WHEN FND_API.G_EXC_ERROR THEN
4185: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
4186: x_return_status := FND_API.G_RET_STS_ERROR;
4187: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4188: p_count => x_msg_count,
4189: p_data => x_msg_data);
4190: IF l_debug = 'Y' THEN
4191: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 4199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4195: END IF;
4196: WHEN OTHERS THEN
4197: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
4198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4200: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4201: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4202: p_error_text => SUBSTRB(SQLERRM,1,240));
4203: END IF;

Line 4200: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',

4196: WHEN OTHERS THEN
4197: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
4198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4199: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4200: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4201: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4202: p_error_text => SUBSTRB(SQLERRM,1,240));
4203: END IF;
4204: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

4200: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4201: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4202: p_error_text => SUBSTRB(SQLERRM,1,240));
4203: END IF;
4204: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4205: p_count => x_msg_count,
4206: p_data => x_msg_data);
4207: IF l_debug = 'Y' THEN
4208:

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

4317:
4318: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4319: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4321: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4322: p_count => x_msg_count,
4323: p_data => x_msg_data);
4324: WHEN FND_API.G_EXC_ERROR THEN
4325: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;

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

4323: p_data => x_msg_data);
4324: WHEN FND_API.G_EXC_ERROR THEN
4325: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4326: x_return_status := FND_API.G_RET_STS_ERROR;
4327: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4328: p_count => x_msg_count,
4329: p_data => x_msg_data);
4330: WHEN OTHERS THEN
4331: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;

Line 4333: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4329: p_data => x_msg_data);
4330: WHEN OTHERS THEN
4331: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4333: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4334: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4335: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4336: p_error_text => SUBSTRB(SQLERRM,1,240));
4337: END IF;

Line 4334: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',

4330: WHEN OTHERS THEN
4331: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
4332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4333: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4334: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4335: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4336: p_error_text => SUBSTRB(SQLERRM,1,240));
4337: END IF;
4338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

4334: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
4335: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
4336: p_error_text => SUBSTRB(SQLERRM,1,240));
4337: END IF;
4338: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4339: p_count => x_msg_count,
4340: p_data => x_msg_data);
4341: END GET_VISIT_APPLICABLE_MRS;
4342:

Line 4798: FND_MSG_PUB.initialize;

4794: AHL_DEBUG_PUB.debug('Input p_include_doNotImplmt:' || p_include_doNotImplmt, l_debug_prefix);
4795: END IF;
4796:
4797: IF FND_API.to_boolean(p_init_msg_list) THEN
4798: FND_MSG_PUB.initialize;
4799: END IF;
4800:
4801: x_return_status := 'S';
4802:

Line 4818: FND_MSG_PUB.ADD;

4814: IF check_instance_exists%NOTFOUND THEN
4815: CLOSE check_instance_exists;
4816: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
4817: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
4818: FND_MSG_PUB.ADD;
4819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4820: END IF;
4821: CLOSE check_instance_exists;
4822: END IF;

Line 5084: FND_MSG_PUB.add;

5080: FETCH get_mr_attri INTO l_get_mr_attri;
5081: IF get_mr_attri%NOTFOUND THEN
5082: CLOSE get_mr_attri;
5083: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
5084: FND_MSG_PUB.add;
5085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5086: ELSE
5087: l_prev_mr_header_id := l_mr_header_id_tbl(i);
5088: CLOSE get_mr_attri;

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

5177: EXCEPTION
5178:
5179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5181: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5182: p_count => x_msg_count,
5183: p_data => x_msg_data);
5184: IF l_debug = 'Y' THEN
5185: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

5189: END IF;
5190:
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: x_return_status := FND_API.G_RET_STS_ERROR;
5193: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5194: p_count => x_msg_count,
5195: p_data => x_msg_data);
5196: IF l_debug = 'Y' THEN
5197: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

Line 5205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5201: END IF;
5202:
5203: WHEN OTHERS THEN
5204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5206: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
5207: p_procedure_name => 'GET_MR_APPLICABILITY',
5208: p_error_text => SUBSTRB(SQLERRM,1,240));
5209: END IF;

Line 5206: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',

5202:
5203: WHEN OTHERS THEN
5204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5206: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
5207: p_procedure_name => 'GET_MR_APPLICABILITY',
5208: p_error_text => SUBSTRB(SQLERRM,1,240));
5209: END IF;
5210: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

5206: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
5207: p_procedure_name => 'GET_MR_APPLICABILITY',
5208: p_error_text => SUBSTRB(SQLERRM,1,240));
5209: END IF;
5210: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5211: p_count => x_msg_count,
5212: p_data => x_msg_data);
5213: IF l_debug = 'Y' THEN
5214: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,