eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SCHEDULE_PVT dependencies on PA_SCHEDULE_PVT

Line 1: PACKAGE BODY PA_SCHEDULE_PVT as

1: PACKAGE BODY PA_SCHEDULE_PVT as
2: --/* $Header: PARGPVTB.pls 120.19 2008/04/02 12:18:13 kjai ship $ */
3:
4: l_out_of_range_date EXCEPTION; -- Exception variable for raising the exception when date is out of range
5: l_invalid_date_range EXCEPTION; -- Exception variable for raising the exception when date is invalid of range

Line 277: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

273: WHEN OTHERS THEN
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: x_msg_count := 1;
276: x_msg_data := SQLERRM;
277: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
278: p_procedure_name => 'get_calendar_schedule');
279: raise;
280:
281: END get_calendar_schedule;

Line 552: PA_Schedule_Pvt.get_calendar_schedule(l_assignment_calendar_id,

548: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
549: /*bug 2335580 */
550: IF l_assignment_calendar_id IS NOT NULL THEN
551:
552: PA_Schedule_Pvt.get_calendar_schedule(l_assignment_calendar_id,
553: p_start_date,
554: l_out_schedule_rec(l_I).start_date-1,
555: l_temp_schedule_rec,
556: l_x_return_status,

Line 619: PA_Schedule_Pvt.get_calendar_schedule(l_assignment_calendar_id,

615: /*Code added for bug 2335580 */
616: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
617: IF l_assignment_calendar_id IS NOT NULL THEN
618:
619: PA_Schedule_Pvt.get_calendar_schedule(l_assignment_calendar_id,
620: l_out_schedule_rec(l_J).end_date+1,
621: p_end_date,
622: l_temp_schedule_rec,
623: l_x_return_status,

Line 701: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: x_msg_count := 1;
700: x_msg_data := SQLERRM;
701: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
702: p_procedure_name => 'get_assignment_schedule');
703: raise;
704:
705: END get_assignment_schedule;

Line 916: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

912:
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: x_msg_count := 1;
915: x_msg_data := SQLERRM;
916: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
917: p_procedure_name => 'get_assignment_schedule');
918: raise;
919:
920: END get_assignment_schedule;

Line 1750: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

1746: WHEN l_invalid_source_id THEN
1747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1748: x_msg_count := 1;
1749: x_msg_data := 'l_invalid_source_id';
1750: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1751: p_procedure_name => 'get_resource_schedule');
1752: raise;
1753: WHEN OTHERS THEN
1754: x_msg_count := 1;

Line 1757: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

1753: WHEN OTHERS THEN
1754: x_msg_count := 1;
1755: x_msg_data := SQLERRM;
1756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1757: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1758: p_procedure_name => 'get_resource_schedule');
1759: raise;
1760:
1761: END get_resource_schedule;

Line 1834: PA_SCHEDULE_PVT.merge_work_pattern(p_chg_sch_record_tab(1).project_id,p_chg_sch_record_tab(1).assignment_id,l_x_return_status,x_msg_count,x_msg_data);

1830: PA_SCHEDULE_PKG.Delete_Rows(p_del_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
1831: END IF;
1832:
1833: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1834: PA_SCHEDULE_PVT.merge_work_pattern(p_chg_sch_record_tab(1).project_id,p_chg_sch_record_tab(1).assignment_id,l_x_return_status,x_msg_count,x_msg_data);
1835: END IF;
1836:
1837: PA_SCHEDULE_UTILS.log_message(1,'end of apply_schedule_change .... ');
1838: x_return_status := l_x_return_status;

Line 1847: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

1843: WHEN OTHERS THEN
1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845: x_msg_count := 1;
1846: x_msg_data := SQLERRM;
1847: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1848: p_procedure_name => 'apply_schedule_change');
1849: raise;
1850:
1851: END apply_schedule_change;

Line 1888: PA_SCHEDULE_PVT.create_new_duration(p_sch_except_record,

1884: IF (p_sch_except_record.exception_type_code = 'CHANGE_DURATION' OR
1885: p_sch_except_record.exception_type_code = 'SHIFT_DURATION') THEN
1886: -- Calling the procedure create_new_duration
1887: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1888: PA_SCHEDULE_PVT.create_new_duration(p_sch_except_record,
1889: p_sch_record,
1890: x_sch_record_tab,
1891: l_x_return_status,
1892: x_msg_count,

Line 1900: PA_SCHEDULE_PVT.create_new_hours(p_sch_except_record,

1896: -- This procedure will create the new schedule for the given change hours exception it will create by
1897: -- changing the hours for the given period
1898: -- Calling the procedure create_new_hours
1899: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1900: PA_SCHEDULE_PVT.create_new_hours(p_sch_except_record,
1901: p_sch_record,
1902: x_sch_record_tab,
1903: l_x_return_status,
1904: x_msg_count,

Line 1912: PA_SCHEDULE_PVT.create_new_pattern(p_sch_except_record,

1908: -- This procedure will create the new schedule for the given change work pattern exception it will create
1909: -- by just changing the work patern for the given period
1910: -- Calling the procedure create_new_pattern
1911: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1912: PA_SCHEDULE_PVT.create_new_pattern(p_sch_except_record,
1913: p_sch_record,
1914: x_sch_record_tab,
1915: l_x_return_status,
1916: x_msg_count,

Line 1924: PA_SCHEDULE_PVT.create_new_status(p_sch_except_record,

1920: -- This procedure will create the new schedule for the given change status exception it will create
1921: -- by changing the status for that period only
1922: -- Calling the procedure create_new_status
1923: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1924: PA_SCHEDULE_PVT.create_new_status(p_sch_except_record,
1925: p_sch_record,
1926: x_sch_record_tab,
1927: l_x_return_status,
1928: x_msg_count,

Line 1936: PA_SCHEDULE_PVT.create_new_calendar(p_sch_except_record,

1932: -- This procedure will create the new schedule for the given change calendar exception it will create
1933: -- by changing the calendar for that period only
1934: -- Calling the procedure create_new_calendar
1935: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1936: PA_SCHEDULE_PVT.create_new_calendar(p_sch_except_record,
1937: p_sch_record,
1938: x_sch_record_tab,
1939: l_x_return_status,
1940: x_msg_count,

Line 1962: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

1958: WHEN OTHERS THEN
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1960: x_msg_count := 1;
1961: x_msg_data := SQLERRM;
1962: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1963: p_procedure_name => 'create_new_schedule');
1964: raise;
1965:
1966: END create_new_schedule;

Line 2001: PA_SCHEDULE_PVT.get_calendar_schedule(p_sch_except_record.calendar_id,

1997: END IF;
1998:
1999: -- Calling the procedure get_calendar_schedule that will bring the new schedule of the passed calendar
2000: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2001: PA_SCHEDULE_PVT.get_calendar_schedule(p_sch_except_record.calendar_id,
2002: p_sch_except_record.start_date,
2003: p_sch_except_record.end_date,
2004: x_sch_record_tab,
2005: l_x_return_status,

Line 2027: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2023: WHEN OTHERS THEN
2024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2025: x_msg_count := 1;
2026: x_msg_data := SQLERRM;
2027: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2028: p_procedure_name => 'create_new_calendar');
2029:
2030: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_schedule procedure ');
2031: raise;

Line 2117: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,

2113: END IF;
2114:
2115: -- Calling the procedure get_resource_schedule that will bring the schedule associated with the resource
2116: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2117: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,
2118: 'PA_PROJECT_PARTY_ID',
2119: p_sch_except_record.start_date,
2120: p_sch_except_record.end_date,
2121: x_sch_record_tab,

Line 2147: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,

2143:
2144: -- Calling the procedure get_calendar_schedule that will bring the schedule associated with the
2145: -- assignment on the basis of passed calendar id
2146: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2147: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,
2148: p_sch_except_record.start_date,
2149: p_sch_except_record.end_date,
2150: x_sch_record_tab,
2151: l_x_return_status,

Line 2221: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,

2217: END IF;
2218:
2219: -- Calling the procedure get_resource_schedule that will bring the schedule associated with the resource
2220: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2221: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,
2222: 'PA_PROJECT_PARTY_ID',
2223: p_sch_except_record.start_date,
2224: p_sch_except_record.end_date,
2225: x_sch_record_tab,

Line 2258: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,

2254:
2255: -- Calling the procedure get_calendar_schedule that will bring the schedule associated with the
2256: -- assignment on the basis of passed calendar id
2257: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2258: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,
2259: p_sch_except_record.start_date,
2260: p_sch_except_record.end_date,
2261: x_sch_record_tab,
2262: l_x_return_status,

Line 2300: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2296: WHEN OTHERS THEN
2297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2298: x_msg_count := 1;
2299: x_msg_data := SQLERRM;
2300: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2301: p_procedure_name => 'create_new_hours');
2302: raise;
2303:
2304: END create_new_hours;

Line 2345: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,

2341:
2342: IF ( l_t_calendar_type = 'RESOURCE' ) THEN
2343: -- Calling the procedure get_resource_schedule which is assigned to the assignment
2344: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2345: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,
2346: 'PA_PROJECT_PARTY_ID',
2347: p_sch_except_record.start_date,
2348: p_sch_except_record.end_date,
2349: x_sch_record_tab,

Line 2368: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,

2364: END IF;
2365:
2366: ELSE
2367: -- Calling the procedure get_calendar_schedule for the calendar assigned to that resource
2368: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,
2369: p_sch_except_record.start_date,
2370: p_sch_except_record.end_date,
2371: x_sch_record_tab,
2372: l_x_return_status,

Line 2386: PA_SCHEDULE_PVT.get_calendar_schedule(p_sch_except_record.calendar_id,

2382:
2383: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2384: -- Calling the procedure get_calendar_schedule on the basis of passed calendar id and for
2385: -- calendar type like assignment,project or others
2386: PA_SCHEDULE_PVT.get_calendar_schedule(p_sch_except_record.calendar_id,
2387: p_sch_except_record.start_date,
2388: p_sch_except_record.end_date,
2389: x_sch_record_tab,
2390: l_x_return_status,

Line 2418: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2414: WHEN OTHERS THEN
2415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2416: x_msg_count := 1;
2417: x_msg_data := SQLERRM;
2418: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2419: p_procedure_name => 'create_new_duration');
2420:
2421: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_duration procedure ');
2422: raise;

Line 2632: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2628: WHEN OTHERS THEN
2629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2630: x_msg_count := 1;
2631: x_msg_data := SQLERRM;
2632: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2633: p_procedure_name => 'merge_work_pattern');
2634:
2635: PA_SCHEDULE_UTILS.log_message(1,'ERROR in merge_work_pattern procedure ');
2636: raise;

Line 2694: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2690: WHEN OTHERS THEN
2691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2692: x_msg_count := 1;
2693: x_msg_data := SQLERRM;
2694: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2695: p_procedure_name => 'create_new_pattern');
2696: raise;
2697:
2698:

Line 2765: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

2761: WHEN OTHERS THEN
2762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2763: x_msg_count := 1;
2764: x_msg_data := SQLERRM;
2765: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2766: p_procedure_name => 'create_new_status');
2767: raise;
2768:
2769: END create_new_status;

Line 3122: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3118: WHEN OTHERS THEN
3119: x_return_status := FND_API.G_RET_STS_ERROR;
3120: x_msg_count := 1;
3121: x_msg_data := SQLERRM;
3122: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3123: p_procedure_name => 'apply_change_duration');
3124:
3125: PA_SCHEDULE_UTILS.log_message(1,'ERROR while running apply...');
3126: raise;

Line 3390: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3386: WHEN OTHERS THEN
3387: x_return_status := FND_API.G_RET_STS_ERROR;
3388: x_msg_count := 1;
3389: x_msg_data := SQLERRM;
3390: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3391: p_procedure_name => 'apply_other_change');
3392:
3393: PA_SCHEDULE_UTILS.log_message(2,'ERROR in apply_other_changes ....');
3394: PA_SCHEDULE_UTILS.log_message(2,sqlerrm);

Line 3606: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3602: WHEN OTHERS THEN
3603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3604: x_msg_count := 1;
3605: x_msg_data := SQLERRM;
3606: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3607: p_procedure_name => 'apply_assignment_change');
3608: raise;
3609: END apply_assignment_change;
3610:

Line 3707: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3703: PA_SCHEDULE_UTILS.log_message(1, 'Error in get_periodic_start_end.....'||sqlerrm);
3704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3705: x_msg_count := 1;
3706: x_msg_data := SQLERRM;
3707: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3708: p_procedure_name => 'get_periodic_start_end');
3709: raise;
3710: END get_periodic_start_end;
3711:

Line 3822: -- Calling the PA_SCHEDULE_PVT API to get the calendar schedule

3818:
3819: /*End for 4996210 */
3820:
3821:
3822: -- Calling the PA_SCHEDULE_PVT API to get the calendar schedule
3823: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,
3824: l_start_date,
3825: l_end_date,
3826: l_x_schedule_tab_rec,

Line 3823: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,

3819: /*End for 4996210 */
3820:
3821:
3822: -- Calling the PA_SCHEDULE_PVT API to get the calendar schedule
3823: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,
3824: l_start_date,
3825: l_end_date,
3826: l_x_schedule_tab_rec,
3827: l_x_return_status,

Line 3915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

3911: PA_SCHEDULE_UTILS.log_message(1, 'Error in create_oasgn_schedule API .....'||sqlerrm);
3912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3913: x_msg_count := 1;
3914: x_msg_data := SQLERRM;
3915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3916: p_procedure_name => 'create_opn_asg_schedule');
3917: raise;
3918:
3919: END create_opn_asg_schedule;

Line 3978: PA_SCHEDULE_PVT.create_opn_asg_schedule (

3974: -- table l_assignment_id_tbl.
3975:
3976:
3977:
3978: PA_SCHEDULE_PVT.create_opn_asg_schedule (
3979: p_project_id => p_project_id,
3980: p_calendar_id => p_calendar_id,
3981: p_assignment_id => l_assignment_id_tbl(l_assignment_id_tbl.FIRST).assignment_id,
3982: p_start_date => p_start_date,

Line 4002: -- Calling the PA_SCHEDULE_PVT API to get the schedule of the first

3998: -- in l_assignment_id.
3999: l_assignment_id := l_assignment_id_tbl(l_assignment_id_tbl.FIRST).assignment_id;
4000: l_assignment_id_tbl.DELETE(l_assignment_id_tbl.FIRST);
4001:
4002: -- Calling the PA_SCHEDULE_PVT API to get the schedule of the first
4003: -- assignment.
4004: PA_SCHEDULE_PVT.get_assignment_schedule(l_assignment_id,
4005: l_current_sch_rec_tab,
4006: l_x_return_status,

Line 4004: PA_SCHEDULE_PVT.get_assignment_schedule(l_assignment_id,

4000: l_assignment_id_tbl.DELETE(l_assignment_id_tbl.FIRST);
4001:
4002: -- Calling the PA_SCHEDULE_PVT API to get the schedule of the first
4003: -- assignment.
4004: PA_SCHEDULE_PVT.get_assignment_schedule(l_assignment_id,
4005: l_current_sch_rec_tab,
4006: l_x_return_status,
4007: x_msg_count,
4008: x_msg_data

Line 4063: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,

4059:
4060:
4061: --Commenting below for Bug 6145532
4062: /*
4063: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,
4064: l_current_sch_rec_tab,
4065: l_x_return_status,
4066: x_msg_count,
4067: x_msg_data

Line 4073: --New call of PA_SCHEDULE_PVT.get_assignment_schedule with

4069: */
4070: /* Added for Bug 6145532*/
4071: IF ( NVL(p_asgn_creation_mode,'DEFAULT') = 'PARTIAL' ) THEN
4072:
4073: --New call of PA_SCHEDULE_PVT.get_assignment_schedule with
4074:
4075: --dates range, to get partial schedule of assignment for the
4076:
4077: --leftover requirement to be made.

Line 4079: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,

4075: --dates range, to get partial schedule of assignment for the
4076:
4077: --leftover requirement to be made.
4078:
4079: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,
4080: p_start_date,
4081: p_end_date,
4082: l_current_sch_rec_tab,
4083: l_x_return_status,

Line 4089: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,

4085: x_msg_data
4086: );
4087: ELSE
4088: -- Bug 6145532 : this is the old code that was being called always
4089: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,
4090: l_current_sch_rec_tab,
4091: l_x_return_status,
4092: x_msg_count,
4093: x_msg_data

Line 4160: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,

4156: -- Case IV: Copy schedule from an existing open assignment without any
4157: -- changes except for assignment id.
4158: ELSIF p_assignment_source_id IS NOT NULL AND p_assignment_status_code IS NULL AND p_calendar_id IS NULL THEN
4159: -- Get source assignment schedule.
4160: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,
4161: l_current_sch_rec_tab,
4162: l_x_return_status,
4163: x_msg_count,
4164: x_msg_data

Line 4219: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

4215: PA_SCHEDULE_UTILS.log_message(1, 'Error in create_opn_asgn_schedule API .....'||sqlerrm);
4216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4217: x_msg_count := 1;
4218: x_msg_data := SQLERRM;
4219: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4220: p_procedure_name => 'create_opn_asg_schedule');
4221: raise;
4222:
4223: END create_opn_asg_schedule;

Line 4324: PA_SCHEDULE_PVT.get_resource_schedule(p_project_party_id,

4320: PA_SCHEDULE_UTILS.log_message(1, 'Schedule Basis Flag - R');
4321: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API get_resource_schedule ....');
4322:
4323: -- Calling tthe PVT API which will get the schedule for staffed asignment and calendar type is resource
4324: PA_SCHEDULE_PVT.get_resource_schedule(p_project_party_id,
4325: 'PA_PROJECT_PARTY_ID',
4326: l_start_date,
4327: l_end_date,
4328: l_x_sch_record_tab,

Line 4367: PA_SCHEDULE_PVT.get_calendar_schedule(l_calendar_id,

4363: -- To check for this date clause jraj 12/19/03..
4364:
4365: IF (p_start_date >l_req_end_date and p_end_date >l_req_end_date) OR
4366: (p_start_date 4367: PA_SCHEDULE_PVT.get_calendar_schedule(l_calendar_id,
4368: l_start_date,
4369: l_end_date,
4370: l_x_sch_record_tab,
4371: l_x_return_status,

Line 4379: PA_SCHEDULE_PVT.get_assignment_schedule(p_open_assignment_id,

4375: );
4376: ELSE
4377:
4378:
4379: PA_SCHEDULE_PVT.get_assignment_schedule(p_open_assignment_id,
4380: l_start_date,
4381: l_end_date,
4382: l_x_sch_record_tab,
4383: l_x_return_status,

Line 4400: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,

4396: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API get_calendar_schedule ....');
4397:
4398: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
4399: -- Calling the PVT API which will get the schedule on the basis of passed calendar id
4400: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,
4401: l_start_date,
4402: l_end_date,
4403: l_x_sch_record_tab,
4404: l_x_return_status,

Line 4486: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

4482: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_sasgn_schedule API ..'||sqlerrm);
4483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4484: x_msg_count := 1;
4485: x_msg_data := SQLERRM;
4486: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4487: p_procedure_name => 'create_stf_asg_schedule');
4488: raise;
4489:
4490: END create_stf_asg_schedule;

Line 4880: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

4876: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_sch_wf_success API ..'||sqlerrm);
4877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4878: x_msg_count := 1;
4879: x_msg_data := SQLERRM;
4880: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4881: p_procedure_name => 'update_sch_wf_success');
4882: END update_sch_wf_success;
4883:
4884: -- Effects: Changes the schedule statuses of the assignment to the

Line 5119: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5115: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_sch_wf_failure API ..'||sqlerrm);
5116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5117: x_msg_count := 1;
5118: x_msg_data := SQLERRM;
5119: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5120: p_procedure_name => 'update_sch_wf_failure');
5121: END update_sch_wf_failure;
5122:
5123: -- Effects: Reverts the schedule back to the last approved schedule.

Line 5236: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5232: PA_SCHEDULE_UTILS.log_message(1,'ERROR in revert_to_last_approved API ..'||sqlerrm);
5233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5234: x_msg_count := 1;
5235: x_msg_data := SQLERRM;
5236: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5237: p_procedure_name => 'revert_to_last_approved');
5238: END revert_to_last_approved;
5239:
5240: -- Effects: Adds schedule records for p_assignment_id to pa_schedules_history

Line 5344: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5340: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_history_table API ..'||sqlerrm);
5341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5342: x_msg_count := 1;
5343: x_msg_data := SQLERRM;
5344: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5345: p_procedure_name => 'update_history_table');
5346: END update_history_table;
5347:
5348:

Line 5452: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(v_c1.exception_type_code);

5448: IF ( (v_c1.exception_type_code = 'CHANGE_DURATION' OR v_c1.exception_type_code = 'SHIFT_DURATION') AND
5449: l_insert_schedule_change = FALSE) THEN
5450: NULL;
5451: ELSE
5452: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(v_c1.exception_type_code);
5453:
5454: IF (v_c1.exception_type_code='CHANGE_DURATION' OR v_c1.exception_type_code='SHIFT_DURATION') THEN
5455: l_date_range := ' ';
5456: ELSE

Line 5457: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(v_c1.start_date, v_c1.end_date);

5453:
5454: IF (v_c1.exception_type_code='CHANGE_DURATION' OR v_c1.exception_type_code='SHIFT_DURATION') THEN
5455: l_date_range := ' ';
5456: ELSE
5457: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(v_c1.start_date, v_c1.end_date);
5458: END IF;
5459:
5460: -- v_c1.start_date,v_c1.end_date are not used for exception_type 'CHANGE_DURATION' or 'SHIFT_DURATION'
5461: l_old_value := get_old_value_text(v_c1.exception_type_code,

Line 5540: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(p_exception_type_code);

5536:
5537: IF p_start_date_tbl.COUNT > 0 THEN
5538: FOR j IN p_start_date_tbl.FIRST .. p_start_date_tbl.LAST LOOP
5539:
5540: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(p_exception_type_code);
5541:
5542: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(p_start_date_tbl(j), p_end_date_tbl(j));
5543:
5544: l_old_value := get_old_value_text(p_exception_type_code,

Line 5542: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(p_start_date_tbl(j), p_end_date_tbl(j));

5538: FOR j IN p_start_date_tbl.FIRST .. p_start_date_tbl.LAST LOOP
5539:
5540: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(p_exception_type_code);
5541:
5542: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(p_start_date_tbl(j), p_end_date_tbl(j));
5543:
5544: l_old_value := get_old_value_text(p_exception_type_code,
5545: p_assignment_id,
5546: p_start_date_tbl(j),

Line 5579: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(p_exception_type_code);

5575: -----------------------------------------------
5576: -- For other changes (passed parameters)
5577: -----------------------------------------------
5578: ELSE
5579: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(p_exception_type_code);
5580:
5581: IF (p_exception_type_code='CHANGE_DURATION' OR p_exception_type_code='SHIFT_DURATION') THEN
5582: l_date_range := ' ';
5583: ELSE

Line 5584: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(p_start_date, p_end_date);

5580:
5581: IF (p_exception_type_code='CHANGE_DURATION' OR p_exception_type_code='SHIFT_DURATION') THEN
5582: l_date_range := ' ';
5583: ELSE
5584: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(p_start_date, p_end_date);
5585: END IF;
5586:
5587: l_old_value := get_old_value_text(p_exception_type_code,
5588: p_assignment_id,

Line 5684: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5680: EXCEPTION
5681: WHEN OTHERS THEN
5682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5683:
5684: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5685: p_procedure_name => 'update_asgmt_changed_items_tab');
5686: RAISE;
5687:
5688: END update_asgmt_changed_items_tab;

Line 5877: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

5873:
5874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5875: x_msg_count := 1;
5876: x_msg_data := SQLERRM;
5877: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5878: p_procedure_name => 'check_overcommitment_single');
5879: RAISE;
5880: END check_overcommitment_single;
5881:

Line 6152: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6148: x_conflict_group_id := NULL ;-- 4537865
6149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6150: x_msg_count := 1;
6151: x_msg_data := SQLERRM;
6152: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6153: p_procedure_name => 'check_overcommitment_mult');
6154: RAISE;
6155: END check_overcommitment_mult;
6156:

Line 6288: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6284: x_self_conflict_flag := NULL ; -- 4537865
6285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6286: x_msg_count := 1;
6287: x_msg_data := SQLERRM;
6288: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6289: p_procedure_name => 'check_self_conflict');
6290: RAISE;
6291: END check_self_conflict;
6292:

Line 6732: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6728: WHEN OTHERS THEN
6729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6730: x_msg_count := 1;
6731: x_msg_data := SQLERRM;
6732: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6733: p_procedure_name => 'resolve_conflicts');
6734: RAISE;
6735: END resolve_conflicts;
6736:

Line 6810: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6806: WHEN OTHERS THEN
6807: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6808: x_msg_count := 1;
6809: x_msg_data := SQLERRM;
6810: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6811: p_procedure_name => 'insert_work_pattern_record');
6812: RAISE;
6813:
6814: END insert_work_pattern_record;

Line 6924: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

6920: WHEN OTHERS THEN
6921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6922: x_msg_count := 1;
6923: x_msg_data := SQLERRM;
6924: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6925: p_procedure_name => 'insert_work_pattern_record');
6926: RAISE;
6927:
6928: END update_work_pattern_record;

Line 7016: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7012: WHEN OTHERS THEN
7013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7014: x_msg_count := 1;
7015: x_msg_data := SQLERRM;
7016: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7017: p_procedure_name => 'insert_work_pattern_tab');
7018: RAISE;
7019:
7020: END insert_work_pattern_tab;

Line 7391: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7387: WHEN OTHERS THEN
7388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7389: x_msg_count := 1;
7390: x_msg_data := SQLERRM;
7391: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7392: p_procedure_name => 'overcom_post_aprvl_processing');
7393: RAISE;
7394: END overcom_post_aprvl_processing;
7395:

Line 7437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7433:
7434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7435: x_msg_count := 1;
7436: x_msg_data := SQLERRM;
7437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7438: p_procedure_name => 'will_resolve_conflicts_by_rmvl');
7439: RAISE;
7440: END will_resolve_conflicts_by_rmvl;
7441:

Line 7481: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7477: x_resolve_conflicts_by_rmvl := NULL ;
7478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7479: x_msg_count := 1;
7480: x_msg_data := SQLERRM;
7481: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7482: p_procedure_name => 'has_resolved_conflicts_by_rmvl');
7483: RAISE;
7484: END has_resolved_conflicts_by_rmvl;
7485:

Line 7533: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7529: WHEN OTHERS THEN
7530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7531: x_msg_count := 1;
7532: x_msg_data := SQLERRM;
7533: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7534: p_procedure_name => 'cancel_overcom_txn_items');
7535: RAISE;
7536: END cancel_overcom_txn_items;
7537:

Line 7580: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7576: WHEN OTHERS THEN
7577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7578: x_msg_count := 1;
7579: x_msg_data := SQLERRM;
7580: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7581: p_procedure_name => 'revert_overcom_txn_items');
7582: RAISE;
7583: END revert_overcom_txn_items;
7584:

Line 7612: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7608:
7609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7610: x_msg_count := 1;
7611: x_msg_data := SQLERRM;
7612: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7613: p_procedure_name => 'get_conflicting_asgmt_count');
7614: RAISE;
7615: END get_conflicting_asgmt_count;
7616:

Line 7659: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7655:
7656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7657: x_msg_count := 1;
7658: x_msg_data := SQLERRM;
7659: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7660: p_procedure_name => 'has_action_taken_on_conflicts');
7661: RAISE;
7662: END has_action_taken_on_conflicts;
7663:

Line 7704: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

7700:
7701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7702: x_msg_count := 1;
7703: x_msg_data := SQLERRM;
7704: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7705: p_procedure_name => 'check_asgmt_apprvl_working');
7706: RAISE;
7707: END check_asgmt_apprvl_working;
7708:

Line 7742: day_of_week PA_SCHEDULE_PVT.DayOfWeekType ,

7738: TYPE SummationRecord IS RECORD (
7739: schedule_date DATE ,
7740: working_day NUMBER ,
7741: hours NUMBER ,
7742: day_of_week PA_SCHEDULE_PVT.DayOfWeekType ,
7743: calendar_id NUMBER ,
7744: assignment_id NUMBER ,
7745: project_id NUMBER ,
7746: schedule_type_code VARCHAR2(30) ,

Line 7765: l_day_of_week PA_SCHEDULE_PVT.DayOfWeekType;

7761: l_current_date DATE;
7762: l_working_day NUMBER;
7763: l_hours NUMBER;
7764: l_found BOOLEAN;
7765: l_day_of_week PA_SCHEDULE_PVT.DayOfWeekType;
7766:
7767: l_summation_index_first NUMBER;
7768: l_summation_index_last NUMBER;
7769:

Line 8088: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8085: x_msg_count := 1;
8086: x_msg_data := SQLERRM;
8087: x_total_hours := 0; -- Bug 5126919
8088: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8089: p_procedure_name => 'sum_task_assignments');
8090: raise;
8091:
8092: END sum_task_assignments;

Line 8098: -- P_Day_Of_Week PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week

8094: -- This procedure sets the number of hours in a given schedule record for a particular day of the week
8095: -- Input parameters
8096: -- Parameters Type Required Description
8097: -- P_Schedule_Tbl PA_SCHEDULE_GLOB.ScheduleRecord YES Schedule Record
8098: -- P_Day_Of_Week PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week
8099: -- P_Hours NUMBER YES Hours for that day
8100: --
8101: -- Out parameters
8102: --

Line 8105: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType ,

8101: -- Out parameters
8102: --
8103: PROCEDURE set_hours_by_day_of_week (
8104: p_schedule_record IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleRecord ,
8105: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType ,
8106: p_hours IN NUMBER) IS
8107: BEGIN
8108: IF p_day_of_week = 'MON' THEN
8109: p_schedule_record.monday_hours := p_hours;

Line 8126: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8122: END IF;
8123: -- 4537865
8124: EXCEPTION
8125: WHEN OTHERS THEN
8126: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8127: p_procedure_name => 'set_hours_by_day_of_week',
8128: p_error_text => SUBSTRB(SQLERRM,1,240));
8129: RAISE;
8130: END set_hours_by_day_of_week;

Line 8297: l_old_value_text := PA_SCHEDULE_PVT.get_date_range_text(v_c1.start_date, v_c1.end_date);

8293: -- CHANGE_DURATION OR SHIFT_DURATION
8294: ------------------------------------------------------------------
8295: IF p_exception_type_code = 'CHANGE_DURATION' OR p_exception_type_code = 'SHIFT_DURATION' THEN
8296: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8297: l_old_value_text := PA_SCHEDULE_PVT.get_date_range_text(v_c1.start_date, v_c1.end_date);
8298: ELSE
8299: OPEN C1_CURRENT;
8300: FETCH C1_CURRENT INTO v_c1_current;
8301: CLOSE C1_CURRENT;

Line 8567: l_new_value_text := PA_SCHEDULE_PVT.get_date_range_text(p_new_start_date, p_new_end_date);

8563: --------------------------------------------------------------
8564: -- p_exception_type_code = 'CHANGE_DURATION'/ 'SHIFT_DURATION'
8565: --------------------------------------------------------------
8566: IF p_exception_type_code = 'CHANGE_DURATION' OR p_exception_type_code = 'SHIFT_DURATION' THEN
8567: l_new_value_text := PA_SCHEDULE_PVT.get_date_range_text(p_new_start_date, p_new_end_date);
8568:
8569: --------------------------------------------------
8570: -- p_exception_type_code = 'CHANGE_STATUS'
8571: --------------------------------------------------

Line 8813: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8809: RETURN (l_count);
8810:
8811: EXCEPTION
8812: WHEN OTHERS THEN
8813: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8814: p_procedure_name => 'get_num_days_of_conflict');
8815: RAISE;
8816: END get_num_days_of_conflict;
8817:

Line 8861: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8857: CLOSE c1;
8858:
8859: EXCEPTION
8860: WHEN OTHERS THEN
8861: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8862: p_procedure_name => 'column_val_conflict_exists');
8863: RAISE;
8864: END column_val_conflict_exists;
8865:

Line 8907: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8903: close c1;
8904:
8905: EXCEPTION
8906: WHEN OTHERS THEN
8907: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8908: p_procedure_name => 'column_val_conflict_action');
8909: RAISE;
8910: END column_val_conflict_action;
8911:

Line 8944: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8940: RETURN (l_affected);
8941:
8942: EXCEPTION
8943: WHEN OTHERS THEN
8944: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8945: p_procedure_name => 'check_conflict_proj_affected');
8946: RAISE;
8947: END check_conflict_proj_affected;
8948:

Line 8983: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

8979: RETURN (l_result);
8980:
8981: EXCEPTION
8982: WHEN OTHERS THEN
8983: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8984: p_procedure_name => 'check_self_conflict_exist');
8985: RAISE;
8986: END check_self_conflict_exist;
8987:

Line 9010: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

9006: EXCEPTION
9007: WHEN NO_DATA_FOUND THEN
9008: RETURN null;
9009: WHEN OTHERS THEN
9010: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9011: p_procedure_name => 'get_ak_attribute_label');
9012: RAISE;
9013: END get_ak_attribute_label;
9014:

Line 9021: -- PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week (3 character abbreviation)

9017: -- Parameters Type Required Description
9018: -- P_Date DATE YES Date
9019: --
9020: -- Out parameters
9021: -- PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week (3 character abbreviation)
9022: --
9023: FUNCTION get_day_of_week (p_date IN DATE) RETURN PA_SCHEDULE_PVT.DayOfWeekType IS
9024: BEGIN
9025: -- RETURN to_char(p_date,'DY'); -- Changed for Bug 5364632

Line 9023: FUNCTION get_day_of_week (p_date IN DATE) RETURN PA_SCHEDULE_PVT.DayOfWeekType IS

9019: --
9020: -- Out parameters
9021: -- PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week (3 character abbreviation)
9022: --
9023: FUNCTION get_day_of_week (p_date IN DATE) RETURN PA_SCHEDULE_PVT.DayOfWeekType IS
9024: BEGIN
9025: -- RETURN to_char(p_date,'DY'); -- Changed for Bug 5364632
9026: RETURN to_char(p_date,'DY','NLS_DATE_LANGUAGE = AMERICAN');
9027: END get_day_of_week;

Line 9034: -- P_Day_Of_Week PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week

9030: -- This function returns the number of hours in a given schedule record for a particular day of the week
9031: -- Input parameters
9032: -- Parameters Type Required Description
9033: -- P_Schedule_Record PA_SCHEDULE_GLOB.ScheduleRecord YES Schedule Record
9034: -- P_Day_Of_Week PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week
9035: --
9036: -- Out parameters
9037: -- NUMBER YES Number of hours schedule on that day
9038: --

Line 9041: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType )

9037: -- NUMBER YES Number of hours schedule on that day
9038: --
9039: FUNCTION get_hours_by_day_of_week (
9040: p_schedule_record IN PA_SCHEDULE_GLOB.ScheduleRecord ,
9041: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType )
9042: RETURN NUMBER IS
9043: l_hours NUMBER := 0;
9044: BEGIN
9045: IF p_day_of_week = 'MON' THEN

Line 9063: END PA_SCHEDULE_PVT;

9059: END IF;
9060: RETURN l_hours;
9061: END get_hours_by_day_of_week;
9062:
9063: END PA_SCHEDULE_PVT;