APPS.PA_ROLE_PROFILES_PUB dependencies on PA_UTILS

Line 55: pa_utils.add_message (p_app_short_name => 'PA',

51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: IF p_effective_end_date IS NOT NULL THEN
54: IF p_effective_start_date > p_effective_end_date THEN
55: pa_utils.add_message (p_app_short_name => 'PA',
56: p_msg_name => 'PA_INVALID_ASGMT_DATES');
57: RAISE FND_API.G_EXC_ERROR;
58: END IF;
59: END IF;

Line 117: pa_utils.add_message (p_app_short_name => 'PA',

113: AND TRUNC(effective_start_date) BETWEEN TRUNC(p_effective_start_date)
114: AND NVL(TRUNC(p_effective_end_date), TRUNC(effective_start_date))
115: AND rownum = 1;
116:
117: pa_utils.add_message (p_app_short_name => 'PA',
118: p_msg_name => 'PA_PROFILE_DATE_CONFLICT');
119: RAISE FND_API.G_EXC_ERROR;
120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN

Line 138: pa_utils.add_message (p_app_short_name => 'PA',

134: AND NVL(position_id, -1) = NVL(l_position_id, -1)
135: AND TRUNC(p_effective_start_date) BETWEEN TRUNC(effective_start_date)
136: AND NVL(TRUNC(effective_end_date), TRUNC(effective_start_date));
137:
138: pa_utils.add_message (p_app_short_name => 'PA',
139: p_msg_name => 'PA_PROFILE_DATE_CONFLICT');
140: RAISE FND_API.G_EXC_ERROR;
141:
142: EXCEPTION

Line 276: pa_utils.add_message (p_app_short_name => 'PA',

272: x_return_status := FND_API.G_RET_STS_SUCCESS;
273:
274: IF p_effective_end_date IS NOT NULL THEN
275: IF p_effective_start_date > p_effective_end_date THEN
276: pa_utils.add_message (p_app_short_name => 'PA',
277: p_msg_name => 'PA_INVALID_ASGMT_DATES');
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280: END IF;

Line 339: pa_utils.add_message (p_app_short_name => 'PA',

335: AND NVL(TRUNC(p_effective_end_date), TRUNC(effective_start_date))
336: AND profile_id <> p_profile_id
337: AND rownum = 1;
338:
339: pa_utils.add_message (p_app_short_name => 'PA',
340: p_msg_name => 'PA_PROFILE_DATE_CONFLICT');
341: RAISE FND_API.G_EXC_ERROR;
342: EXCEPTION
343: WHEN NO_DATA_FOUND THEN

Line 361: pa_utils.add_message (p_app_short_name => 'PA',

357: AND TRUNC(p_effective_start_date) BETWEEN TRUNC(effective_start_date)
358: AND NVL(TRUNC(effective_end_date), TRUNC(effective_start_date))
359: AND profile_id <> p_profile_id;
360:
361: pa_utils.add_message (p_app_short_name => 'PA',
362: p_msg_name => 'PA_PROFILE_DATE_CONFLICT');
363: RAISE FND_API.G_EXC_ERROR;
364:
365: EXCEPTION