1491: FND_MSG_PUB.initialize;
1492: END IF;
1493:
1494: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1495: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
1496: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1497: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1498: ELSE
1499: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1492: END IF;
1493:
1494: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1495: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
1496: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1497: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1498: ELSE
1499: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1500: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1493:
1494: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1495: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
1496: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1497: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1498: ELSE
1499: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1500: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1501: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
1495: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
1496: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1497: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1498: ELSE
1499: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1500: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1501: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
1502: END IF;
1503:
1496: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1497: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1498: ELSE
1499: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1500: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1501: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
1502: END IF;
1503:
1504:
1497: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1498: ELSE
1499: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1500: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1501: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
1502: END IF;
1503:
1504:
1505: ----------------------------------------------------------------------------------------------
1986: FND_MSG_PUB.initialize;
1987: END IF;
1988:
1989: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1990: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
1991: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1992: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1993: ELSE
1994: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1987: END IF;
1988:
1989: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1990: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
1991: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1992: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1993: ELSE
1994: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1995: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1988:
1989: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
1990: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
1991: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1992: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1993: ELSE
1994: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1995: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1996: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
1990: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
1991: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1992: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1993: ELSE
1994: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1995: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1996: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
1997: END IF;
1998:
1991: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
1992: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1993: ELSE
1994: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1995: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1996: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
1997: END IF;
1998:
1999: -- The passed dates for changing the hours should be between
1992: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
1993: ELSE
1994: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
1995: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1996: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
1997: END IF;
1998:
1999: -- The passed dates for changing the hours should be between
2000: -- start and end date of the assignment.
2172: FND_MSG_PUB.initialize;
2173: END IF;
2174:
2175: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2176: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2177: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2178: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2179: ELSE
2180: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2173: END IF;
2174:
2175: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2176: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2177: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2178: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2179: ELSE
2180: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2181: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2174:
2175: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2176: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2177: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2178: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2179: ELSE
2180: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2181: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2182: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2176: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2177: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2178: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2179: ELSE
2180: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2181: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2182: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2183: END IF;
2184:
2177: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2178: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2179: ELSE
2180: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2181: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2182: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2183: END IF;
2184:
2185:
2178: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2179: ELSE
2180: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2181: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2182: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2183: END IF;
2184:
2185:
2186: -- The passed start date and end date should be between the
2444: FND_MSG_PUB.initialize;
2445: END IF;
2446:
2447: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2448: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2449: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2450: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2451: ELSE
2452: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2445: END IF;
2446:
2447: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2448: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2449: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2450: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2451: ELSE
2452: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2453: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2446:
2447: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2448: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2449: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2450: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2451: ELSE
2452: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2453: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2454: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2448: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2449: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2450: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2451: ELSE
2452: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2453: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2454: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2455: END IF;
2456:
2449: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2450: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2451: ELSE
2452: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2453: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2454: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2455: END IF;
2456:
2457: PA_SCHEDULE_UTILS.log_message(1,'Start of Change_Status ... ');
2450: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2451: ELSE
2452: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2453: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2454: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2455: END IF;
2456:
2457: PA_SCHEDULE_UTILS.log_message(1,'Start of Change_Status ... ');
2458:
2728: --Clear the global PL/SQL message table
2729: fnd_msg_pub.initialize;
2730:
2731: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2732: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2733: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2734: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2735: ELSE
2736: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2729: fnd_msg_pub.initialize;
2730:
2731: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2732: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2733: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2734: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2735: ELSE
2736: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2737: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2730:
2731: IF ( p_assignment_type = 'OPEN_ASSIGNMENT' ) THEN
2732: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2733: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2734: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2735: ELSE
2736: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2737: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2738: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2732: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_TEXT');
2733: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2734: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2735: ELSE
2736: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2737: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2738: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2739: END IF;
2740:
2733: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_A_TEXT');
2734: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2735: ELSE
2736: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2737: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2738: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2739: END IF;
2740:
2741: -- Current functionality allows user to change the work patern by specifing the calendar
2734: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_REQUIREMENT_POSS_TEXT');
2735: ELSE
2736: l_asgn_req_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_TEXT');
2737: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2738: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2739: END IF;
2740:
2741: -- Current functionality allows user to change the work patern by specifing the calendar
2742: -- for the whole period so we don't need to check the start /end date for null.