DBA Data[Home] [Help]

APPS.PA_ASSIGNMENTS_PUB dependencies on FND_PROFILE

Line 5: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

1: PACKAGE BODY pa_assignments_pub AS
2: /*$Header: PARAPUBB.pls 120.13.12010000.5 2009/02/23 11:10:49 jcgeorge ship $*/
3: --
4:
5: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
6: li_message_level NUMBER := 1;
7:
8: PROCEDURE Execute_Create_Assignment
9: ( p_asgn_creation_mode IN VARCHAR2 := 'FULL'

Line 170: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);

166:
167: IF p_status_code is NULL THEN -- Added default value population for Status Code. Bug 7309934
168:
169: IF p_assignment_type = 'OPEN_ASSIGNMENT' THEN
170: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);
171: IF l_assignment_rec.status_code IS NULL THEN
172: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
173: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
174: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

Line 179: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);

175: END IF;
176: END IF;
177:
178: IF (p_assignment_type = 'STAFFED_ASSIGNMENT' OR p_assignment_type = 'STAFFED_ADMIN_ASSIGNMENT') THEN
179: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);
180: IF l_assignment_rec.status_code IS NULL THEN
181: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
182: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
183: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

Line 284: IF NVL(FND_PROFILE.value('PA_GLOBAL_WEEK_START_DAY'),'N') = 'N' THEN

280: l_assignment_rec.enable_auto_cand_nom_flag := p_enable_auto_cand_nom_flag;
281: -- 5130421 End
282:
283: --Start Bug 3249669 : Check for profile option PA: Global Week Start Day being set.
284: IF NVL(FND_PROFILE.value('PA_GLOBAL_WEEK_START_DAY'),'N') = 'N' THEN
285: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
286: ,p_msg_name => 'PA_GLOBAL_WEEK_START_DAY_ERR' );
287: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
288: END IF;

Line 748: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);

744:
745: --Set calendar_type to 'PROJECT'as default
746: l_assignment_rec.calendar_type := 'PROJECT';
747:
748: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);
749:
750: IF l_assignment_rec.status_code IS NULL THEN
751:
752: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

Line 1840: -- l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */

1836: END IF;
1837: END IF;
1838:
1839: ELSE -- IF ( l_valid_assign_start_flag = 'Y' )
1840: -- l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
1841: l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
1842: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1843: ,p_msg_name => 'PA_INVALID_ASSIGN_START_DATE'
1844: ,p_token1 => 'PROFILE_DATE'

Line 1841: l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */

1837: END IF;
1838:
1839: ELSE -- IF ( l_valid_assign_start_flag = 'Y' )
1840: -- l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
1841: l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
1842: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1843: ,p_msg_name => 'PA_INVALID_ASSIGN_START_DATE'
1844: ,p_token1 => 'PROFILE_DATE'
1845: ,p_value1 => l_profile_begin_date );

Line 2323: FND_PROFILE.Get('PA_DEF_FILLED_ASGMT_STATUS',l_default_filled_status_code);

2319: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2320:
2321: ELSE
2322:
2323: FND_PROFILE.Get('PA_DEF_FILLED_ASGMT_STATUS',l_default_filled_status_code);
2324:
2325: IF l_default_filled_status_code IS NULL THEN
2326:
2327: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

Line 5322: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);

5318: keep link between the two records
5319: */
5320: IF p_asgn_creation_mode = 'FULL' THEN
5321:
5322: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);
5323:
5324: IF l_assignment_rec.status_code IS NULL THEN
5325:
5326: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'

Line 5510: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_status_code);

5506:
5507: IF l_status_code is NULL THEN
5508:
5509: IF (p_assignment_type = 'OPEN_ASSIGNMENT') THEN
5510: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_status_code);
5511: IF l_status_code IS NULL THEN
5512: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
5513: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
5514: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

Line 5519: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_status_code);

5515: END IF;
5516: END IF;
5517:
5518: IF (p_assignment_type = 'STAFFED_ASSIGNMENT' OR p_assignment_type = 'STAFFED_ADMIN_ASSIGNMENT') THEN
5519: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_status_code);
5520: IF l_status_code IS NULL THEN
5521: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
5522: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
5523: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;