DBA Data[Home] [Help]

APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT dependencies on FND_MSG_PUB

Line 93: FND_MSG_PUB.initialize;

89: AHL_DEBUG_PUB.debug('Begin private API: AHL_MR_LOOP_CHAIN_RELNS_PVT.VALIDATE_LOOP_CHAIN');
90: END IF;
91:
92: IF FND_API.to_boolean(p_init_msg_list) THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: FOR l_mr_index IN p_mr_relns.FIRST..p_mr_relns.LAST
97: loop

Line 283: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

279: AHL_DEBUG_PUB.debug('ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');
280: END IF;
281:
282: WHEN OTHERS THEN
283: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
284: p_data => l_msg_data,
285: p_encoded => fnd_api.g_false);
286: IF l_debug = 'Y' THEN
287: AHL_DEBUG_PUB.enable_debug;

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

695: EXCEPTION
696: WHEN OTHERS THEN
697: ROLLBACK TO GET_CM_AFFECTED_ITEMS_PVT;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
700: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',
701: p_procedure_name => 'GET_CM_AFFECTED_ITEMS',
702: p_error_text => SUBSTRB(SQLERRM,1,240));
703: END IF;

Line 700: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',

696: WHEN OTHERS THEN
697: ROLLBACK TO GET_CM_AFFECTED_ITEMS_PVT;
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
700: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',
701: p_procedure_name => 'GET_CM_AFFECTED_ITEMS',
702: p_error_text => SUBSTRB(SQLERRM,1,240));
703: END IF;
704: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

700: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',
701: p_procedure_name => 'GET_CM_AFFECTED_ITEMS',
702: p_error_text => SUBSTRB(SQLERRM,1,240));
703: END IF;
704: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
705: p_count => x_msg_count,
706: p_data => x_msg_data);
707: IF l_debug = 'Y' THEN
708: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

Line 973: FND_MSG_PUB.initialize;

969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END IF;
971:
972: IF FND_API.to_boolean(p_init_msg_list) THEN
973: FND_MSG_PUB.initialize;
974: END IF;
975:
976: --Loop through ahl_mr_relationships to find the relationship
977: IF p_calling_module IS NOT NULL AND p_calling_module = 'UMP'

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

1079:
1080: EXCEPTION
1081: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1084: p_count => x_msg_count,
1085: p_data => x_msg_data);
1086: IF l_debug = 'Y' THEN
1087: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

1091: END IF;
1092:
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: x_return_status := FND_API.G_RET_STS_ERROR;
1095: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1096: p_count => x_msg_count,
1097: p_data => x_msg_data);
1098: IF l_debug = 'Y' THEN
1099: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data,

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

1103: END IF;
1104:
1105: WHEN OTHERS THEN
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1108: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',
1109: p_procedure_name => 'VIEW_MR_LOOP_CHAIN',
1110: p_error_text => SUBSTRB(SQLERRM,1,240));
1111: END IF;

Line 1108: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',

1104:
1105: WHEN OTHERS THEN
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1108: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',
1109: p_procedure_name => 'VIEW_MR_LOOP_CHAIN',
1110: p_error_text => SUBSTRB(SQLERRM,1,240));
1111: END IF;
1112: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

1108: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'AHL_MR_LOOP_CHAIN_RELNS_PVT',
1109: p_procedure_name => 'VIEW_MR_LOOP_CHAIN',
1110: p_error_text => SUBSTRB(SQLERRM,1,240));
1111: END IF;
1112: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1113: p_count => x_msg_count,
1114: p_data => x_msg_data);
1115: IF l_debug = 'Y' THEN
1116: AHL_DEBUG_PUB.log_app_messages (x_msg_count, x_msg_data,

Line 1248: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);

1244:
1245: EXCEPTION
1246: WHEN OTHERS THEN
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
1249:
1250: IF l_debug = 'Y' THEN
1251: AHL_DEBUG_PUB.log_app_messages(x_msg_count, x_msg_data, 'ERROR IN PRIVATE:' );
1252: AHL_DEBUG_PUB.DEBUG('AHL_MR_LOOP_CHAIN_RELNS_PVT.VIEW_MR_LOOP_CHAIN', l_debug_prefix);