DBA Data[Home] [Help]

APPS.AHL_UMP_SMRINSTANCE_PVT dependencies on FND_MSG_PUB

Line 319: FND_MSG_PUB.Initialize;

315: END IF;
316:
317: -- Initialize message list if p_init_msg_list is set to TRUE
318: IF FND_API.To_Boolean(p_init_msg_list) THEN
319: FND_MSG_PUB.Initialize;
320: END IF;
321:
322: -- Initialize API return status to success
323: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 459: FND_MSG_PUB.ADD;

455: IF (p_search_mr_instance_rec.mr_title is NOT NULL) AND
456: (p_search_mr_instance_rec.INCIDENT_TYPE_ID IS NOT NULL OR p_search_mr_instance_rec.SERVICE_REQ_NUM IS NOT NULL)
457: THEN
458: FND_MESSAGE.Set_Name('AHL','AHL_UMP_MR_SERQ_INPUT');
459: FND_MSG_PUB.ADD;
460: RAISE FND_API.G_EXC_ERROR;
461: END IF;
462:
463: --start fix for bug#7327283

Line 981: IF FND_MSG_PUB.count_msg > 0 THEN

977: l_pick_record_flag := FALSE;
978: END IF;
979: --amsriniv ER 6116245
980: --Error check
981: IF FND_MSG_PUB.count_msg > 0 THEN
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: -- Handling Scheduled and Unscheduled status.
985: IF ( p_search_mr_instance_rec.mr_status = 'SCHEDULED' AND

Line 1152: FND_MSG_PUB.Count_And_Get

1148: --Close the dynamic cursor and free up resources
1149: CLOSE l_cur;
1150:
1151: -- Standard call to get message count and if count is 1, get message info
1152: FND_MSG_PUB.Count_And_Get
1153: (
1154: p_count => x_msg_count,
1155: p_data => x_msg_data,
1156: p_encoded => fnd_api.g_false

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

1177: EXCEPTION
1178: WHEN FND_API.G_EXC_ERROR THEN
1179: x_return_status := FND_API.G_RET_STS_ERROR;
1180: ROLLBACK TO Search_MR_Instances_Pvt;
1181: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1182: p_data => x_msg_data,
1183: p_encoded => fnd_api.g_false);
1184:
1185:

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

1185:
1186: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: ROLLBACK TO Search_MR_Instances_Pvt;
1189: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1190: p_data => x_msg_data,
1191: p_encoded => fnd_api.g_false);
1192:
1193: WHEN OTHERS THEN

Line 1196: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,

1192:
1193: WHEN OTHERS THEN
1194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1195: ROLLBACK TO Search_MR_Instances_Pvt;
1196: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1197: p_procedure_name => 'Search_MR_Instances',
1198: p_error_text => SQLERRM);
1199:
1200: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

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

1196: FND_MSG_PUB.add_exc_msg( p_pkg_name => G_PKG_NAME,
1197: p_procedure_name => 'Search_MR_Instances',
1198: p_error_text => SQLERRM);
1199:
1200: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
1201: p_data => x_msg_data,
1202: p_encoded => fnd_api.g_false);
1203:
1204: END Search_MR_Instances;