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.28 2011/11/24 11:28:15 krkondur 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 205: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);

201:
202: IF p_status_code is NULL THEN -- Added default value population for Status Code. Bug 7309934
203:
204: IF p_assignment_type = 'OPEN_ASSIGNMENT' THEN
205: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);
206: IF l_assignment_rec.status_code IS NULL THEN
207: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
208: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
209: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

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

210: END IF;
211: END IF;
212:
213: IF (p_assignment_type = 'STAFFED_ASSIGNMENT' OR p_assignment_type = 'STAFFED_ADMIN_ASSIGNMENT') THEN
214: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);
215: IF l_assignment_rec.status_code IS NULL THEN
216: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
217: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
218: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

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

315: l_assignment_rec.enable_auto_cand_nom_flag := p_enable_auto_cand_nom_flag;
316: -- 5130421 End
317:
318: --Start Bug 3249669 : Check for profile option PA: Global Week Start Day being set.
319: IF NVL(FND_PROFILE.value('PA_GLOBAL_WEEK_START_DAY'),'N') = 'N' THEN
320: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
321: ,p_msg_name => 'PA_GLOBAL_WEEK_START_DAY_ERR' );
322: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
323: END IF;

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

779:
780: --Set calendar_type to 'PROJECT'as default
781: l_assignment_rec.calendar_type := 'PROJECT';
782:
783: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_assignment_rec.status_code);
784:
785: IF l_assignment_rec.status_code IS NULL THEN
786:
787: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

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

1885: END IF;
1886: END IF;
1887:
1888: ELSE -- IF ( l_valid_assign_start_flag = 'Y' )
1889: -- l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
1890: l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
1891: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1892: ,p_msg_name => 'PA_INVALID_ASSIGN_START_DATE'
1893: ,p_token1 => 'PROFILE_DATE'

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

1886: END IF;
1887:
1888: ELSE -- IF ( l_valid_assign_start_flag = 'Y' )
1889: -- l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY'); /* commenting for For Bug 7304151 */
1890: l_profile_begin_date := to_date(fnd_profile.value('PA_UTL_START_DATE'), 'DD/MM/YYYY', 'NLS_DATE_LANGUAGE=AMERICAN'); /*Adding For Bug 7304151 */
1891: PA_ASSIGNMENT_UTILS.Add_Message( p_app_short_name => 'PA'
1892: ,p_msg_name => 'PA_INVALID_ASSIGN_START_DATE'
1893: ,p_token1 => 'PROFILE_DATE'
1894: ,p_value1 => l_profile_begin_date );

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

2384: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;
2385:
2386: ELSE
2387:
2388: FND_PROFILE.Get('PA_DEF_FILLED_ASGMT_STATUS',l_default_filled_status_code);
2389:
2390: IF l_default_filled_status_code IS NULL THEN
2391:
2392: PA_UTILS.Add_Message ( p_app_short_name => 'PA'

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

6294: keep link between the two records
6295: */
6296: IF p_asgn_creation_mode = 'FULL' THEN
6297:
6298: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_assignment_rec.status_code);
6299:
6300: IF l_assignment_rec.status_code IS NULL THEN
6301:
6302: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'

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

6482:
6483: IF l_status_code is NULL THEN
6484:
6485: IF (p_assignment_type = 'OPEN_ASSIGNMENT') THEN
6486: FND_PROFILE.Get('PA_START_OPEN_ASGMT_STATUS',l_status_code);
6487: IF l_status_code IS NULL THEN
6488: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
6489: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
6490: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;

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

6491: END IF;
6492: END IF;
6493:
6494: IF (p_assignment_type = 'STAFFED_ASSIGNMENT' OR p_assignment_type = 'STAFFED_ADMIN_ASSIGNMENT') THEN
6495: FND_PROFILE.Get('PA_START_STAFFED_ASGMT_STATUS',l_status_code);
6496: IF l_status_code IS NULL THEN
6497: PA_ASSIGNMENT_UTILS.Add_Message ( p_app_short_name => 'PA'
6498: ,p_msg_name => 'PA_START_STATUS_NOT_DEFINED');
6499: PA_ASSIGNMENTS_PUB.g_error_exists := FND_API.G_TRUE;