DBA Data[Home] [Help]

APPS.AHL_FMP_PVT dependencies on FND_MSG_PUB

Line 685: FND_MSG_PUB.initialize;

681: AHL_DEBUG_PUB.enable_debug;
682: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS');
683: END IF;
684: IF FND_API.to_boolean(p_init_msg_list) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687: x_return_status := 'S';
688: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
689: p_api_version,

Line 706: FND_MSG_PUB.ADD;

702: FETCH check_mr_exists INTO l_mr_header_id;
703: IF check_mr_exists%NOTFOUND THEN
704: CLOSE check_mr_exists;
705: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR');
706: FND_MSG_PUB.ADD;
707: RAISE FND_API.G_EXC_ERROR;
708: END IF;
709: CLOSE check_mr_exists;
710: AHL_DEBUG_PUB.debug(' Phase 2');

Line 744: FND_MSG_PUB.ADD;

740: l_mr_header_id := l_mr_effect.mr_header_id;
741:
742: IF (l_mr_header_id <> p_mr_header_id) THEN
743: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_MR_EFFECTIVITY');
744: FND_MSG_PUB.ADD;
745: l_error_flag:='Y';
746: END IF;
747: --END IF;
748: END LOOP;

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

1001: END IF;
1002: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1003: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1004: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1005: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1006: p_count => x_msg_count,
1007: p_data => x_msg_data);
1008: IF l_debug = 'Y' THEN
1009: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

1013: END IF;
1014: WHEN FND_API.G_EXC_ERROR THEN
1015: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data);
1020: IF l_debug = 'Y' THEN
1021: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

1025: END IF;
1026: WHEN OTHERS THEN
1027: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1030: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1031: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1032: p_error_text => SUBSTR(SQLERRM,1,240));
1033: END IF;

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

1026: WHEN OTHERS THEN
1027: ROLLBACK TO GET_MR_AFFECTED_ITEMS_PVT;
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1029: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1030: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1031: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1032: p_error_text => SUBSTR(SQLERRM,1,240));
1033: END IF;
1034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1030: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
1031: p_procedure_name => 'GET_MR_AFFECTED_ITEMS',
1032: p_error_text => SUBSTR(SQLERRM,1,240));
1033: END IF;
1034: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1035: p_count => x_msg_count,
1036: p_data => x_msg_data);
1037: IF l_debug = 'Y' THEN
1038: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

Line 1834: FND_MSG_PUB.initialize;

1830: AHL_DEBUG_PUB.debug('Input p_visit_type_code:' || p_visit_type_code);
1831: END IF;
1832:
1833: IF FND_API.to_boolean(p_init_msg_list) THEN
1834: FND_MSG_PUB.initialize;
1835: END IF;
1836:
1837: x_return_status := 'S';
1838:

Line 1854: FND_MSG_PUB.ADD;

1850: IF check_instance_exists%NOTFOUND THEN
1851: CLOSE check_instance_exists;
1852: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
1853: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
1854: FND_MSG_PUB.ADD;
1855: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1856: END IF;
1857: CLOSE check_instance_exists;
1858: END IF;

Line 2181: FND_MSG_PUB.add;

2177: FETCH get_mr_attri INTO l_get_mr_attri;
2178: IF get_mr_attri%NOTFOUND THEN
2179: CLOSE get_mr_attri;
2180: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
2181: FND_MSG_PUB.add;
2182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2183: ELSE
2184: l_prev_mr_header_id := l_mr_header_id_tbl(i);
2185: CLOSE get_mr_attri;

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

2274:
2275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2276: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2278: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2279: p_count => x_msg_count,
2280: p_data => x_msg_data);
2281: IF l_debug = 'Y' THEN
2282: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

2287:
2288: WHEN FND_API.G_EXC_ERROR THEN
2289: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2290: x_return_status := FND_API.G_RET_STS_ERROR;
2291: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2292: p_count => x_msg_count,
2293: p_data => x_msg_data);
2294: IF l_debug = 'Y' THEN
2295: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

2300:
2301: WHEN OTHERS THEN
2302: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2305: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
2306: p_procedure_name => 'GET_APPLICABLE_MRS',
2307: p_error_text => SUBSTRB(SQLERRM,1,240));
2308: END IF;

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

2301: WHEN OTHERS THEN
2302: ROLLBACK TO GET_APPLICABLE_MRS_PVT;
2303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2305: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
2306: p_procedure_name => 'GET_APPLICABLE_MRS',
2307: p_error_text => SUBSTRB(SQLERRM,1,240));
2308: END IF;
2309: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

2305: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
2306: p_procedure_name => 'GET_APPLICABLE_MRS',
2307: p_error_text => SUBSTRB(SQLERRM,1,240));
2308: END IF;
2309: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2310: p_count => x_msg_count,
2311: p_data => x_msg_data);
2312: IF l_debug = 'Y' THEN
2313: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

Line 2708: FND_MSG_PUB.add;

2704: IF get_inst_attributes%NOTFOUND THEN
2705: CLOSE get_inst_attributes;
2706: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
2707: FND_MESSAGE.set_token('INSTANCE',p_item_instance_id);
2708: FND_MSG_PUB.add;
2709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2710: RETURN match_dtl;
2711: END IF;
2712: CLOSE get_inst_attributes;

Line 3017: FND_MSG_PUB.initialize;

3013: AHL_DEBUG_PUB.debug('Begin private API: AHL_FMP_PVT.GET_PM_APPLICABLE_MRS');
3014: AHL_DEBUG_PUB.debug('');
3015: END IF;
3016: IF FND_API.to_boolean(p_init_msg_list) THEN
3017: FND_MSG_PUB.initialize;
3018: END IF;
3019: x_return_status := 'S';
3020: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version, p_api_version,
3021: l_api_name, G_PKG_NAME)

Line 3029: FND_MSG_PUB.add;

3025:
3026: l_appln_code:=nvl(FND_PROFILE.VALUE('AHL_APPLN_USAGE'),'x');
3027: IF l_appln_code <> 'PM' THEN
3028: FND_MESSAGE.set_name('AHL', 'AHL_FMP_PM_NOT_INSTALLED');
3029: FND_MSG_PUB.add;
3030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3031: END IF;
3032:
3033: OPEN check_instance_exists(p_item_instance_id);

Line 3039: FND_MSG_PUB.ADD;

3035: IF check_instance_exists%NOTFOUND THEN
3036: CLOSE check_instance_exists;
3037: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_INVALID_ITEM_INSTANCE');
3038: FND_MESSAGE.SET_TOKEN('INSTANCE',p_item_instance_id);
3039: FND_MSG_PUB.ADD;
3040: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3041: END IF;
3042: CLOSE check_instance_exists;
3043:

Line 3050: FND_MSG_PUB.add;

3046: IF get_inventory_item%NOTFOUND THEN
3047: CLOSE get_inventory_item;
3048: FND_MESSAGE.set_name('AHL', 'AHL_FMP_ITEM_NOT_EXISTS');
3049: FND_MESSAGE.set_token('INSTANCE',p_item_instance_id);
3050: FND_MSG_PUB.add;
3051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3052: END IF;
3053: CLOSE get_inventory_item;
3054:

Line 3088: FND_MSG_PUB.add;

3084: x_ent_contracts => l_ent_contracts,
3085: x_pm_activities => l_pm_activities );
3086: IF l_msg_count > 0 THEN
3087: FND_MESSAGE.set_name('AHL', 'AHL_FMP_CALLING_OKS_API_ERROR');
3088: FND_MSG_PUB.add;
3089: RAISE FND_API.G_EXC_ERROR;
3090: END IF;
3091:
3092: IF l_debug = 'Y' THEN

Line 3191: FND_MSG_PUB.add;

3187: FETCH get_mr_attri INTO l_get_mr_attri;
3188: IF get_mr_attri%NOTFOUND THEN
3189: CLOSE get_mr_attri;
3190: FND_MESSAGE.set_name('AHL','AHL_FMP_INVALID_MR');
3191: FND_MSG_PUB.add;
3192: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3193: ELSE
3194: x_applicable_activities_tbl(i).repetitive_flag := l_get_mr_attri.repetitive_flag;
3195: x_applicable_activities_tbl(i).show_repetitive_code := l_get_mr_attri.show_repetitive_code;

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

3207:
3208: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3209: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3211: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3212: p_count => x_msg_count,
3213: p_data => x_msg_data);
3214: IF l_debug = 'Y' THEN
3215: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

3219: END IF;
3220: WHEN FND_API.G_EXC_ERROR THEN
3221: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3222: x_return_status := FND_API.G_RET_STS_ERROR;
3223: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3224: p_count => x_msg_count,
3225: p_data => x_msg_data);
3226: IF l_debug = 'Y' THEN
3227: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

3231: END IF;
3232: WHEN OTHERS THEN
3233: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3236: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3237: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3238: p_error_text => SUBSTRB(SQLERRM,1,240));
3239: END IF;

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

3232: WHEN OTHERS THEN
3233: ROLLBACK TO GET_PM_APPLICABLE_MRS_PVT;
3234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3235: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3236: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3237: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3238: p_error_text => SUBSTRB(SQLERRM,1,240));
3239: END IF;
3240: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

3236: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3237: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3238: p_error_text => SUBSTRB(SQLERRM,1,240));
3239: END IF;
3240: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3241: p_count => x_msg_count,
3242: p_data => x_msg_data);
3243: IF l_debug = 'Y' THEN
3244:

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

3353:
3354: EXCEPTION WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3355: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3357: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3358: p_count => x_msg_count,
3359: p_data => x_msg_data);
3360: WHEN FND_API.G_EXC_ERROR THEN
3361: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;

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

3359: p_data => x_msg_data);
3360: WHEN FND_API.G_EXC_ERROR THEN
3361: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3362: x_return_status := FND_API.G_RET_STS_ERROR;
3363: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3364: p_count => x_msg_count,
3365: p_data => x_msg_data);
3366: WHEN OTHERS THEN
3367: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;

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

3365: p_data => x_msg_data);
3366: WHEN OTHERS THEN
3367: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3370: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3371: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3372: p_error_text => SUBSTRB(SQLERRM,1,240));
3373: END IF;

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

3366: WHEN OTHERS THEN
3367: ROLLBACK TO GET_VISIT_APPLICABLE_MRS_PVT;
3368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3369: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3370: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3371: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3372: p_error_text => SUBSTRB(SQLERRM,1,240));
3373: END IF;
3374: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

3370: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_FMP_PVT',
3371: p_procedure_name => 'GET_PM_APPLICABLE_MRS',
3372: p_error_text => SUBSTRB(SQLERRM,1,240));
3373: END IF;
3374: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3375: p_count => x_msg_count,
3376: p_data => x_msg_data);
3377: END GET_VISIT_APPLICABLE_MRS;
3378: