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.32 2010/12/15 12:08:06 smadhava 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 173: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',

169: WHEN OTHERS THEN
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: x_msg_count := 1;
172: x_msg_data := SQLERRM;
173: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
174: p_procedure_name => 'get_existing_schedule');
175: raise;
176:
177: END get_existing_schedule;

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

443: WHEN OTHERS THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
445: x_msg_count := 1;
446: x_msg_data := SQLERRM;
447: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
448: p_procedure_name => 'get_calendar_schedule');
449: raise;
450:
451: END get_calendar_schedule;

Line 722: PA_Schedule_Pvt.get_calendar_schedule(l_assignment_calendar_id,

718: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
719: /*bug 2335580 */
720: IF l_assignment_calendar_id IS NOT NULL THEN
721:
722: PA_Schedule_Pvt.get_calendar_schedule(l_assignment_calendar_id,
723: p_start_date,
724: l_out_schedule_rec(l_I).start_date-1,
725: l_temp_schedule_rec,
726: l_x_return_status,

Line 789: PA_Schedule_Pvt.get_calendar_schedule(l_assignment_calendar_id,

785: /*Code added for bug 2335580 */
786: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
787: IF l_assignment_calendar_id IS NOT NULL THEN
788:
789: PA_Schedule_Pvt.get_calendar_schedule(l_assignment_calendar_id,
790: l_out_schedule_rec(l_J).end_date+1,
791: p_end_date,
792: l_temp_schedule_rec,
793: l_x_return_status,

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

867: WHEN OTHERS THEN
868: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
869: x_msg_count := 1;
870: x_msg_data := SQLERRM;
871: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
872: p_procedure_name => 'get_assignment_schedule');
873: raise;
874:
875: END get_assignment_schedule;

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

1082:
1083: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1084: x_msg_count := 1;
1085: x_msg_data := SQLERRM;
1086: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1087: p_procedure_name => 'get_assignment_schedule');
1088: raise;
1089:
1090: END get_assignment_schedule;

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

1916: WHEN l_invalid_source_id THEN
1917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1918: x_msg_count := 1;
1919: x_msg_data := 'l_invalid_source_id';
1920: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1921: p_procedure_name => 'get_resource_schedule');
1922: raise;
1923: WHEN OTHERS THEN
1924: x_msg_count := 1;

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

1923: WHEN OTHERS THEN
1924: x_msg_count := 1;
1925: x_msg_data := SQLERRM;
1926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1927: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
1928: p_procedure_name => 'get_resource_schedule');
1929: raise;
1930:
1931: END get_resource_schedule;

Line 2004: 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);

2000: PA_SCHEDULE_PKG.Delete_Rows(p_del_sch_record_tab,l_x_return_status,x_msg_count,x_msg_data);
2001: END IF;
2002:
2003: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2004: 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);
2005: END IF;
2006:
2007: PA_SCHEDULE_UTILS.log_message(1,'end of apply_schedule_change .... ');
2008: x_return_status := l_x_return_status;

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

2013: WHEN OTHERS THEN
2014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2015: x_msg_count := 1;
2016: x_msg_data := SQLERRM;
2017: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2018: p_procedure_name => 'apply_schedule_change');
2019: raise;
2020:
2021: END apply_schedule_change;

Line 2061: PA_SCHEDULE_PVT.create_new_duration(p_sch_except_record,

2057: p_sch_except_record.exception_type_code = 'SHIFT_DURATION' OR
2058: p_sch_except_record.exception_type_code = 'DURATION_PATTERN_SHIFT') THEN
2059: -- Calling the procedure create_new_duration
2060: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2061: PA_SCHEDULE_PVT.create_new_duration(p_sch_except_record,
2062: p_sch_record,
2063: x_sch_record_tab,
2064: x_difference_days, -- Added for bug 7663765
2065: x_shift_unit_code, -- Added for bug 7663765

Line 2075: PA_SCHEDULE_PVT.create_new_hours(p_sch_except_record,

2071: -- This procedure will create the new schedule for the given change hours exception it will create by
2072: -- changing the hours for the given period
2073: -- Calling the procedure create_new_hours
2074: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2075: PA_SCHEDULE_PVT.create_new_hours(p_sch_except_record,
2076: p_sch_record,
2077: x_sch_record_tab,
2078: l_x_return_status,
2079: x_msg_count,

Line 2087: PA_SCHEDULE_PVT.create_new_pattern(p_sch_except_record,

2083: -- This procedure will create the new schedule for the given change work pattern exception it will create
2084: -- by just changing the work patern for the given period
2085: -- Calling the procedure create_new_pattern
2086: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2087: PA_SCHEDULE_PVT.create_new_pattern(p_sch_except_record,
2088: p_sch_record,
2089: x_sch_record_tab,
2090: l_x_return_status,
2091: x_msg_count,

Line 2099: PA_SCHEDULE_PVT.create_new_status(p_sch_except_record,

2095: -- This procedure will create the new schedule for the given change status exception it will create
2096: -- by changing the status for that period only
2097: -- Calling the procedure create_new_status
2098: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2099: PA_SCHEDULE_PVT.create_new_status(p_sch_except_record,
2100: p_sch_record,
2101: x_sch_record_tab,
2102: l_x_return_status,
2103: x_msg_count,

Line 2111: PA_SCHEDULE_PVT.create_new_calendar(p_sch_except_record,

2107: -- This procedure will create the new schedule for the given change calendar exception it will create
2108: -- by changing the calendar for that period only
2109: -- Calling the procedure create_new_calendar
2110: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2111: PA_SCHEDULE_PVT.create_new_calendar(p_sch_except_record,
2112: p_sch_record,
2113: x_sch_record_tab,
2114: l_x_return_status,
2115: x_msg_count,

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

2133: WHEN OTHERS THEN
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2135: x_msg_count := 1;
2136: x_msg_data := SQLERRM;
2137: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2138: p_procedure_name => 'create_new_schedule');
2139: raise;
2140:
2141: END create_new_schedule;

Line 2176: PA_SCHEDULE_PVT.get_calendar_schedule(p_sch_except_record.calendar_id,

2172: END IF;
2173:
2174: -- Calling the procedure get_calendar_schedule that will bring the new schedule of the passed calendar
2175: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2176: PA_SCHEDULE_PVT.get_calendar_schedule(p_sch_except_record.calendar_id,
2177: p_sch_except_record.start_date,
2178: p_sch_except_record.end_date,
2179: x_sch_record_tab,
2180: l_x_return_status,

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

2198: WHEN OTHERS THEN
2199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2200: x_msg_count := 1;
2201: x_msg_data := SQLERRM;
2202: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2203: p_procedure_name => 'create_new_calendar');
2204:
2205: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_schedule procedure ');
2206: raise;

Line 2296: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,

2292: END IF;
2293:
2294: -- Calling the procedure get_resource_schedule that will bring the schedule associated with the resource
2295: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2296: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,
2297: 'PA_PROJECT_PARTY_ID',
2298: p_sch_except_record.start_date,
2299: p_sch_except_record.end_date,
2300: x_sch_record_tab,

Line 2312: PA_SCHEDULE_PVT.get_calendar_schedule( l_t_calendar_id,

2308: INTO l_t_calendar_id
2309: FROM pa_project_assignments
2310: where assignment_id = p_sch_except_record.assignment_id;
2311:
2312: PA_SCHEDULE_PVT.get_calendar_schedule( l_t_calendar_id,
2313: p_sch_except_record.start_date,
2314: p_sch_except_record.end_date,
2315: x_sch_record_tab,
2316: l_x_return_status,

Line 2342: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,

2338:
2339: -- Calling the procedure get_calendar_schedule that will bring the schedule associated with the
2340: -- assignment on the basis of passed calendar id
2341: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2342: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,
2343: p_sch_except_record.start_date,
2344: p_sch_except_record.end_date,
2345: x_sch_record_tab,
2346: l_x_return_status,

Line 2416: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,

2412: END IF;
2413:
2414: -- Calling the procedure get_resource_schedule that will bring the schedule associated with the resource
2415: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2416: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,
2417: 'PA_PROJECT_PARTY_ID',
2418: p_sch_except_record.start_date,
2419: p_sch_except_record.end_date,
2420: x_sch_record_tab,

Line 2453: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,

2449:
2450: -- Calling the procedure get_calendar_schedule that will bring the schedule associated with the
2451: -- assignment on the basis of passed calendar id
2452: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2453: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,
2454: p_sch_except_record.start_date,
2455: p_sch_except_record.end_date,
2456: x_sch_record_tab,
2457: l_x_return_status,

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

2491: WHEN OTHERS THEN
2492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2493: x_msg_count := 1;
2494: x_msg_data := SQLERRM;
2495: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2496: p_procedure_name => 'create_new_hours');
2497: raise;
2498:
2499: END create_new_hours;

Line 2534: PA_SCHEDULE_PVT.get_existing_schedule(l_t_calendar_id,

2530: -- Bug 1580455: added STAFFED_ADMIN_ASSIGNMENT case.
2531: /* Added the below if for 7663765 */
2532: IF (p_sch_except_record.exception_type_code = 'DURATION_PATTERN_SHIFT') then
2533:
2534: PA_SCHEDULE_PVT.get_existing_schedule(l_t_calendar_id,
2535: p_sch_except_record.assignment_id,
2536: p_sch_except_record.start_date,
2537: p_sch_except_record.end_date,
2538: x_sch_record_tab,

Line 2556: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,

2552:
2553: IF ( l_t_calendar_type = 'RESOURCE' ) THEN
2554: -- Calling the procedure get_resource_schedule which is assigned to the assignment
2555: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2556: PA_SCHEDULE_PVT.get_resource_schedule(l_t_team_player_id,
2557: 'PA_PROJECT_PARTY_ID',
2558: p_sch_except_record.start_date,
2559: p_sch_except_record.end_date,
2560: x_sch_record_tab,

Line 2579: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,

2575: END IF;
2576:
2577: ELSE
2578: -- Calling the procedure get_calendar_schedule for the calendar assigned to that resource
2579: PA_SCHEDULE_PVT.get_calendar_schedule(l_t_calendar_id,
2580: p_sch_except_record.start_date,
2581: p_sch_except_record.end_date,
2582: x_sch_record_tab,
2583: l_x_return_status,

Line 2597: PA_SCHEDULE_PVT.get_calendar_schedule(p_sch_except_record.calendar_id,

2593:
2594: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2595: -- Calling the procedure get_calendar_schedule on the basis of passed calendar id and for
2596: -- calendar type like assignment,project or others
2597: PA_SCHEDULE_PVT.get_calendar_schedule(p_sch_except_record.calendar_id,
2598: p_sch_except_record.start_date,
2599: p_sch_except_record.end_date,
2600: x_sch_record_tab,
2601: l_x_return_status,

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

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

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

2840: WHEN OTHERS THEN
2841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2842: x_msg_count := 1;
2843: x_msg_data := SQLERRM;
2844: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2845: p_procedure_name => 'merge_work_pattern');
2846:
2847: PA_SCHEDULE_UTILS.log_message(1,'ERROR in merge_work_pattern procedure ');
2848: raise;

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

2902: WHEN OTHERS THEN
2903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2904: x_msg_count := 1;
2905: x_msg_data := SQLERRM;
2906: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2907: p_procedure_name => 'create_new_pattern');
2908: raise;
2909:
2910:

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

2973: WHEN OTHERS THEN
2974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2975: x_msg_count := 1;
2976: x_msg_data := SQLERRM;
2977: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
2978: p_procedure_name => 'create_new_status');
2979: raise;
2980:
2981: END create_new_status;

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

3389: WHEN OTHERS THEN
3390: x_return_status := FND_API.G_RET_STS_ERROR;
3391: x_msg_count := 1;
3392: x_msg_data := SQLERRM;
3393: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3394: p_procedure_name => 'apply_change_duration');
3395:
3396: PA_SCHEDULE_UTILS.log_message(1,'ERROR while running apply...');
3397: raise;

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

3659: WHEN OTHERS THEN
3660: x_return_status := FND_API.G_RET_STS_ERROR;
3661: x_msg_count := 1;
3662: x_msg_data := SQLERRM;
3663: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3664: p_procedure_name => 'apply_other_change');
3665:
3666: PA_SCHEDULE_UTILS.log_message(2,'ERROR in apply_other_changes ....');
3667: PA_SCHEDULE_UTILS.log_message(2,sqlerrm);

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

3888: WHEN OTHERS THEN
3889: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3890: x_msg_count := 1;
3891: x_msg_data := SQLERRM;
3892: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3893: p_procedure_name => 'apply_assignment_change');
3894: raise;
3895: END apply_assignment_change;
3896:

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

3989: PA_SCHEDULE_UTILS.log_message(1, 'Error in get_periodic_start_end.....'||sqlerrm);
3990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3991: x_msg_count := 1;
3992: x_msg_data := SQLERRM;
3993: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
3994: p_procedure_name => 'get_periodic_start_end');
3995: raise;
3996: END get_periodic_start_end;
3997:

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

4104:
4105: /*End for 4996210 */
4106:
4107:
4108: -- Calling the PA_SCHEDULE_PVT API to get the calendar schedule
4109: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,
4110: l_start_date,
4111: l_end_date,
4112: l_x_schedule_tab_rec,

Line 4109: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,

4105: /*End for 4996210 */
4106:
4107:
4108: -- Calling the PA_SCHEDULE_PVT API to get the calendar schedule
4109: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,
4110: l_start_date,
4111: l_end_date,
4112: l_x_schedule_tab_rec,
4113: l_x_return_status,

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

4197: PA_SCHEDULE_UTILS.log_message(1, 'Error in create_oasgn_schedule API .....'||sqlerrm);
4198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4199: x_msg_count := 1;
4200: x_msg_data := SQLERRM;
4201: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4202: p_procedure_name => 'create_opn_asg_schedule');
4203: raise;
4204:
4205: END create_opn_asg_schedule;

Line 4264: PA_SCHEDULE_PVT.create_opn_asg_schedule (

4260: -- table l_assignment_id_tbl.
4261:
4262:
4263:
4264: PA_SCHEDULE_PVT.create_opn_asg_schedule (
4265: p_project_id => p_project_id,
4266: p_calendar_id => p_calendar_id,
4267: p_assignment_id => l_assignment_id_tbl(l_assignment_id_tbl.FIRST).assignment_id,
4268: p_start_date => p_start_date,

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

4284: -- in l_assignment_id.
4285: l_assignment_id := l_assignment_id_tbl(l_assignment_id_tbl.FIRST).assignment_id;
4286: l_assignment_id_tbl.DELETE(l_assignment_id_tbl.FIRST);
4287:
4288: -- Calling the PA_SCHEDULE_PVT API to get the schedule of the first
4289: -- assignment.
4290: PA_SCHEDULE_PVT.get_assignment_schedule(l_assignment_id,
4291: l_current_sch_rec_tab,
4292: l_x_return_status,

Line 4290: PA_SCHEDULE_PVT.get_assignment_schedule(l_assignment_id,

4286: l_assignment_id_tbl.DELETE(l_assignment_id_tbl.FIRST);
4287:
4288: -- Calling the PA_SCHEDULE_PVT API to get the schedule of the first
4289: -- assignment.
4290: PA_SCHEDULE_PVT.get_assignment_schedule(l_assignment_id,
4291: l_current_sch_rec_tab,
4292: l_x_return_status,
4293: x_msg_count,
4294: x_msg_data

Line 4349: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,

4345:
4346:
4347: --Commenting below for Bug 6145532
4348: /*
4349: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,
4350: l_current_sch_rec_tab,
4351: l_x_return_status,
4352: x_msg_count,
4353: x_msg_data

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

4355: */
4356: /* Added for Bug 6145532*/
4357: IF ( NVL(p_asgn_creation_mode,'DEFAULT') = 'PARTIAL' ) THEN
4358:
4359: --New call of PA_SCHEDULE_PVT.get_assignment_schedule with
4360:
4361: --dates range, to get partial schedule of assignment for the
4362:
4363: --leftover requirement to be made.

Line 4365: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,

4361: --dates range, to get partial schedule of assignment for the
4362:
4363: --leftover requirement to be made.
4364:
4365: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,
4366: p_start_date,
4367: p_end_date,
4368: l_current_sch_rec_tab,
4369: l_x_return_status,

Line 4375: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,

4371: x_msg_data
4372: );
4373: ELSE
4374: -- Bug 6145532 : this is the old code that was being called always
4375: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,
4376: l_current_sch_rec_tab,
4377: l_x_return_status,
4378: x_msg_count,
4379: x_msg_data

Line 4446: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,

4442: -- Case IV: Copy schedule from an existing open assignment without any
4443: -- changes except for assignment id.
4444: ELSIF p_assignment_source_id IS NOT NULL AND p_assignment_status_code IS NULL AND p_calendar_id IS NULL THEN
4445: -- Get source assignment schedule.
4446: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_source_id,
4447: l_current_sch_rec_tab,
4448: l_x_return_status,
4449: x_msg_count,
4450: x_msg_data

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

4501: PA_SCHEDULE_UTILS.log_message(1, 'Error in create_opn_asgn_schedule API .....'||sqlerrm);
4502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4503: x_msg_count := 1;
4504: x_msg_data := SQLERRM;
4505: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4506: p_procedure_name => 'create_opn_asg_schedule');
4507: raise;
4508:
4509: END create_opn_asg_schedule;

Line 4610: PA_SCHEDULE_PVT.get_resource_schedule(p_project_party_id,

4606: PA_SCHEDULE_UTILS.log_message(1, 'Schedule Basis Flag - R');
4607: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API get_resource_schedule ....');
4608:
4609: -- Calling tthe PVT API which will get the schedule for staffed asignment and calendar type is resource
4610: PA_SCHEDULE_PVT.get_resource_schedule(p_project_party_id,
4611: 'PA_PROJECT_PARTY_ID',
4612: l_start_date,
4613: l_end_date,
4614: l_x_sch_record_tab,

Line 4653: PA_SCHEDULE_PVT.get_calendar_schedule(l_calendar_id,

4649: -- To check for this date clause jraj 12/19/03..
4650:
4651: IF (p_start_date >l_req_end_date and p_end_date >l_req_end_date) OR
4652: (p_start_date 4653: PA_SCHEDULE_PVT.get_calendar_schedule(l_calendar_id,
4654: l_start_date,
4655: l_end_date,
4656: l_x_sch_record_tab,
4657: l_x_return_status,

Line 4665: PA_SCHEDULE_PVT.get_assignment_schedule(p_open_assignment_id,

4661: );
4662: ELSE
4663:
4664:
4665: PA_SCHEDULE_PVT.get_assignment_schedule(p_open_assignment_id,
4666: l_start_date,
4667: l_end_date,
4668: l_x_sch_record_tab,
4669: l_x_return_status,

Line 4686: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,

4682: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API get_calendar_schedule ....');
4683:
4684: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
4685: -- Calling the PVT API which will get the schedule on the basis of passed calendar id
4686: PA_SCHEDULE_PVT.get_calendar_schedule(p_calendar_id,
4687: l_start_date,
4688: l_end_date,
4689: l_x_sch_record_tab,
4690: l_x_return_status,

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

4768: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_sasgn_schedule API ..'||sqlerrm);
4769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4770: x_msg_count := 1;
4771: x_msg_data := SQLERRM;
4772: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
4773: p_procedure_name => 'create_stf_asg_schedule');
4774: raise;
4775:
4776: END create_stf_asg_schedule;

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

5162: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_sch_wf_success API ..'||sqlerrm);
5163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5164: x_msg_count := 1;
5165: x_msg_data := SQLERRM;
5166: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5167: p_procedure_name => 'update_sch_wf_success');
5168: END update_sch_wf_success;
5169:
5170: -- Effects: Changes the schedule statuses of the assignment to the

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

5401: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_sch_wf_failure API ..'||sqlerrm);
5402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5403: x_msg_count := 1;
5404: x_msg_data := SQLERRM;
5405: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5406: p_procedure_name => 'update_sch_wf_failure');
5407: END update_sch_wf_failure;
5408:
5409: -- Effects: Reverts the schedule back to the last approved schedule.

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

5518: PA_SCHEDULE_UTILS.log_message(1,'ERROR in revert_to_last_approved API ..'||sqlerrm);
5519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5520: x_msg_count := 1;
5521: x_msg_data := SQLERRM;
5522: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5523: p_procedure_name => 'revert_to_last_approved');
5524: END revert_to_last_approved;
5525:
5526: -- Effects: Adds schedule records for p_assignment_id to pa_schedules_history

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

5626: PA_SCHEDULE_UTILS.log_message(1,'ERROR in update_history_table API ..'||sqlerrm);
5627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5628: x_msg_count := 1;
5629: x_msg_data := SQLERRM;
5630: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5631: p_procedure_name => 'update_history_table');
5632: END update_history_table;
5633:
5634:

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

5736: IF ( (v_c1.exception_type_code = 'CHANGE_DURATION' OR v_c1.exception_type_code = 'SHIFT_DURATION' OR v_c1.exception_type_code = 'DURATION_PATTERN_SHIFT') AND
5737: l_insert_schedule_change = FALSE) THEN
5738: NULL;
5739: ELSE
5740: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(v_c1.exception_type_code);
5741:
5742: IF (v_c1.exception_type_code='CHANGE_DURATION' OR v_c1.exception_type_code='SHIFT_DURATION' OR v_c1.exception_type_code = 'DURATION_PATTERN_SHIFT') THEN
5743: l_date_range := ' ';
5744: ELSE

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

5741:
5742: IF (v_c1.exception_type_code='CHANGE_DURATION' OR v_c1.exception_type_code='SHIFT_DURATION' OR v_c1.exception_type_code = 'DURATION_PATTERN_SHIFT') THEN
5743: l_date_range := ' ';
5744: ELSE
5745: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(v_c1.start_date, v_c1.end_date);
5746: END IF;
5747:
5748: -- v_c1.start_date,v_c1.end_date are not used for exception_type 'CHANGE_DURATION' or 'SHIFT_DURATION'
5749: l_old_value := get_old_value_text(v_c1.exception_type_code,

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

5824:
5825: IF p_start_date_tbl.COUNT > 0 THEN
5826: FOR j IN p_start_date_tbl.FIRST .. p_start_date_tbl.LAST LOOP
5827:
5828: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(p_exception_type_code);
5829:
5830: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(p_start_date_tbl(j), p_end_date_tbl(j));
5831:
5832: l_old_value := get_old_value_text(p_exception_type_code,

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

5826: FOR j IN p_start_date_tbl.FIRST .. p_start_date_tbl.LAST LOOP
5827:
5828: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(p_exception_type_code);
5829:
5830: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(p_start_date_tbl(j), p_end_date_tbl(j));
5831:
5832: l_old_value := get_old_value_text(p_exception_type_code,
5833: p_assignment_id,
5834: p_start_date_tbl(j),

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

5863: -----------------------------------------------
5864: -- For other changes (passed parameters)
5865: -----------------------------------------------
5866: ELSE
5867: l_changed_item_name := PA_SCHEDULE_PVT.get_changed_item_name_text(p_exception_type_code);
5868:
5869: IF (p_exception_type_code='CHANGE_DURATION' OR p_exception_type_code='SHIFT_DURATION' OR p_exception_type_code = 'DURATION_PATTERN_SHIFT') THEN
5870: l_date_range := ' ';
5871: ELSE

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

5868:
5869: IF (p_exception_type_code='CHANGE_DURATION' OR p_exception_type_code='SHIFT_DURATION' OR p_exception_type_code = 'DURATION_PATTERN_SHIFT') THEN
5870: l_date_range := ' ';
5871: ELSE
5872: l_date_range := PA_SCHEDULE_PVT.get_date_range_text(p_start_date, p_end_date);
5873: END IF;
5874:
5875: l_old_value := get_old_value_text(p_exception_type_code,
5876: p_assignment_id,

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

5968: EXCEPTION
5969: WHEN OTHERS THEN
5970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5971:
5972: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
5973: p_procedure_name => 'update_asgmt_changed_items_tab');
5974: RAISE;
5975:
5976: END update_asgmt_changed_items_tab;

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

6166:
6167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6168: x_msg_count := 1;
6169: x_msg_data := SQLERRM;
6170: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6171: p_procedure_name => 'check_overcommitment_single');
6172: RAISE;
6173: END check_overcommitment_single;
6174:

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

6441: x_conflict_group_id := NULL ;-- 4537865
6442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6443: x_msg_count := 1;
6444: x_msg_data := SQLERRM;
6445: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6446: p_procedure_name => 'check_overcommitment_mult');
6447: RAISE;
6448: END check_overcommitment_mult;
6449:

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

6577: x_self_conflict_flag := NULL ; -- 4537865
6578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6579: x_msg_count := 1;
6580: x_msg_data := SQLERRM;
6581: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
6582: p_procedure_name => 'check_self_conflict');
6583: RAISE;
6584: END check_self_conflict;
6585:

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

7021: WHEN OTHERS THEN
7022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7023: x_msg_count := 1;
7024: x_msg_data := SQLERRM;
7025: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7026: p_procedure_name => 'resolve_conflicts');
7027: RAISE;
7028: END resolve_conflicts;
7029:

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

7099: WHEN OTHERS THEN
7100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7101: x_msg_count := 1;
7102: x_msg_data := SQLERRM;
7103: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7104: p_procedure_name => 'insert_work_pattern_record');
7105: RAISE;
7106:
7107: END insert_work_pattern_record;

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

7213: WHEN OTHERS THEN
7214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7215: x_msg_count := 1;
7216: x_msg_data := SQLERRM;
7217: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7218: p_procedure_name => 'insert_work_pattern_record');
7219: RAISE;
7220:
7221: END update_work_pattern_record;

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

7305: WHEN OTHERS THEN
7306: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7307: x_msg_count := 1;
7308: x_msg_data := SQLERRM;
7309: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7310: p_procedure_name => 'insert_work_pattern_tab');
7311: RAISE;
7312:
7313: END insert_work_pattern_tab;

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

7680: WHEN OTHERS THEN
7681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7682: x_msg_count := 1;
7683: x_msg_data := SQLERRM;
7684: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7685: p_procedure_name => 'overcom_post_aprvl_processing');
7686: RAISE;
7687: END overcom_post_aprvl_processing;
7688:

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

7726:
7727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7728: x_msg_count := 1;
7729: x_msg_data := SQLERRM;
7730: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7731: p_procedure_name => 'will_resolve_conflicts_by_rmvl');
7732: RAISE;
7733: END will_resolve_conflicts_by_rmvl;
7734:

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

7770: x_resolve_conflicts_by_rmvl := NULL ;
7771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7772: x_msg_count := 1;
7773: x_msg_data := SQLERRM;
7774: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7775: p_procedure_name => 'has_resolved_conflicts_by_rmvl');
7776: RAISE;
7777: END has_resolved_conflicts_by_rmvl;
7778:

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

7822: WHEN OTHERS THEN
7823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7824: x_msg_count := 1;
7825: x_msg_data := SQLERRM;
7826: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7827: p_procedure_name => 'cancel_overcom_txn_items');
7828: RAISE;
7829: END cancel_overcom_txn_items;
7830:

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

7869: WHEN OTHERS THEN
7870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7871: x_msg_count := 1;
7872: x_msg_data := SQLERRM;
7873: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7874: p_procedure_name => 'revert_overcom_txn_items');
7875: RAISE;
7876: END revert_overcom_txn_items;
7877:

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

7901:
7902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7903: x_msg_count := 1;
7904: x_msg_data := SQLERRM;
7905: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7906: p_procedure_name => 'get_conflicting_asgmt_count');
7907: RAISE;
7908: END get_conflicting_asgmt_count;
7909:

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

7948:
7949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7950: x_msg_count := 1;
7951: x_msg_data := SQLERRM;
7952: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7953: p_procedure_name => 'has_action_taken_on_conflicts');
7954: RAISE;
7955: END has_action_taken_on_conflicts;
7956:

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

7993:
7994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7995: x_msg_count := 1;
7996: x_msg_data := SQLERRM;
7997: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
7998: p_procedure_name => 'check_asgmt_apprvl_working');
7999: RAISE;
8000: END check_asgmt_apprvl_working;
8001:

Line 8035: day_of_week PA_SCHEDULE_PVT.DayOfWeekType ,

8031: TYPE SummationRecord IS RECORD (
8032: schedule_date DATE ,
8033: working_day NUMBER ,
8034: hours NUMBER ,
8035: day_of_week PA_SCHEDULE_PVT.DayOfWeekType ,
8036: calendar_id NUMBER ,
8037: assignment_id NUMBER ,
8038: project_id NUMBER ,
8039: schedule_type_code VARCHAR2(30) ,

Line 8058: l_day_of_week PA_SCHEDULE_PVT.DayOfWeekType;

8054: l_current_date DATE;
8055: l_working_day NUMBER;
8056: l_hours NUMBER;
8057: l_found BOOLEAN;
8058: l_day_of_week PA_SCHEDULE_PVT.DayOfWeekType;
8059:
8060: l_summation_index_first NUMBER;
8061: l_summation_index_last NUMBER;
8062:

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

8377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8378: x_msg_count := 1;
8379: x_msg_data := SQLERRM;
8380: x_total_hours := 0; -- Bug 5126919
8381: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8382: p_procedure_name => 'sum_task_assignments');
8383: raise;
8384:
8385: END sum_task_assignments;

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

8387: -- This procedure sets the number of hours in a given schedule record for a particular day of the week
8388: -- Input parameters
8389: -- Parameters Type Required Description
8390: -- P_Schedule_Tbl PA_SCHEDULE_GLOB.ScheduleRecord YES Schedule Record
8391: -- P_Day_Of_Week PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week
8392: -- P_Hours NUMBER YES Hours for that day
8393: --
8394: -- Out parameters
8395: --

Line 8398: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType ,

8394: -- Out parameters
8395: --
8396: PROCEDURE set_hours_by_day_of_week (
8397: p_schedule_record IN OUT NOCOPY PA_SCHEDULE_GLOB.ScheduleRecord ,
8398: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType ,
8399: p_hours IN NUMBER) IS
8400: BEGIN
8401: IF p_day_of_week = 'MON' THEN
8402: p_schedule_record.monday_hours := p_hours;

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

8415: END IF;
8416: -- 4537865
8417: EXCEPTION
8418: WHEN OTHERS THEN
8419: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
8420: p_procedure_name => 'set_hours_by_day_of_week',
8421: p_error_text => SUBSTRB(SQLERRM,1,240));
8422: RAISE;
8423: END set_hours_by_day_of_week;

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

8586: -- CHANGE_DURATION OR SHIFT_DURATION
8587: ------------------------------------------------------------------
8588: IF p_exception_type_code = 'CHANGE_DURATION' OR p_exception_type_code = 'SHIFT_DURATION' OR p_exception_type_code = 'DURATION_PATTERN_SHIFT' THEN
8589: IF (l_history_exist = 'Y' AND l_apprvl_status_code <> PA_ASSIGNMENT_APPROVAL_PUB.g_approved) THEN
8590: l_old_value_text := PA_SCHEDULE_PVT.get_date_range_text(v_c1.start_date, v_c1.end_date);
8591: ELSE
8592: OPEN C1_CURRENT;
8593: FETCH C1_CURRENT INTO v_c1_current;
8594: CLOSE C1_CURRENT;

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

8856: --------------------------------------------------------------
8857: -- p_exception_type_code = 'CHANGE_DURATION'/ 'SHIFT_DURATION'
8858: --------------------------------------------------------------
8859: IF p_exception_type_code = 'CHANGE_DURATION' OR p_exception_type_code = 'SHIFT_DURATION' OR p_exception_type_code = 'DURATION_PATTERN_SHIFT' THEN
8860: l_new_value_text := PA_SCHEDULE_PVT.get_date_range_text(p_new_start_date, p_new_end_date);
8861:
8862: --------------------------------------------------
8863: -- p_exception_type_code = 'CHANGE_STATUS'
8864: --------------------------------------------------

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

9102: RETURN (l_count);
9103:
9104: EXCEPTION
9105: WHEN OTHERS THEN
9106: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9107: p_procedure_name => 'get_num_days_of_conflict');
9108: RAISE;
9109: END get_num_days_of_conflict;
9110:

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

9150: CLOSE c1;
9151:
9152: EXCEPTION
9153: WHEN OTHERS THEN
9154: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9155: p_procedure_name => 'column_val_conflict_exists');
9156: RAISE;
9157: END column_val_conflict_exists;
9158:

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

9196: close c1;
9197:
9198: EXCEPTION
9199: WHEN OTHERS THEN
9200: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9201: p_procedure_name => 'column_val_conflict_action');
9202: RAISE;
9203: END column_val_conflict_action;
9204:

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

9233: RETURN (l_affected);
9234:
9235: EXCEPTION
9236: WHEN OTHERS THEN
9237: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9238: p_procedure_name => 'check_conflict_proj_affected');
9239: RAISE;
9240: END check_conflict_proj_affected;
9241:

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

9272: RETURN (l_result);
9273:
9274: EXCEPTION
9275: WHEN OTHERS THEN
9276: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9277: p_procedure_name => 'check_self_conflict_exist');
9278: RAISE;
9279: END check_self_conflict_exist;
9280:

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

9299: EXCEPTION
9300: WHEN NO_DATA_FOUND THEN
9301: RETURN null;
9302: WHEN OTHERS THEN
9303: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PVT',
9304: p_procedure_name => 'get_ak_attribute_label');
9305: RAISE;
9306: END get_ak_attribute_label;
9307:

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

9310: -- Parameters Type Required Description
9311: -- P_Date DATE YES Date
9312: --
9313: -- Out parameters
9314: -- PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week (3 character abbreviation)
9315: --
9316: FUNCTION get_day_of_week (p_date IN DATE) RETURN PA_SCHEDULE_PVT.DayOfWeekType IS
9317: BEGIN
9318: -- RETURN to_char(p_date,'DY'); -- Changed for Bug 5364632

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

9312: --
9313: -- Out parameters
9314: -- PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week (3 character abbreviation)
9315: --
9316: FUNCTION get_day_of_week (p_date IN DATE) RETURN PA_SCHEDULE_PVT.DayOfWeekType IS
9317: BEGIN
9318: -- RETURN to_char(p_date,'DY'); -- Changed for Bug 5364632
9319: RETURN to_char(p_date,'DY','NLS_DATE_LANGUAGE = AMERICAN');
9320: END get_day_of_week;

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

9323: -- This function returns the number of hours in a given schedule record for a particular day of the week
9324: -- Input parameters
9325: -- Parameters Type Required Description
9326: -- P_Schedule_Record PA_SCHEDULE_GLOB.ScheduleRecord YES Schedule Record
9327: -- P_Day_Of_Week PA_SCHEDULE_PVT.DayOfWeekType YES Day of the week
9328: --
9329: -- Out parameters
9330: -- NUMBER YES Number of hours schedule on that day
9331: --

Line 9334: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType )

9330: -- NUMBER YES Number of hours schedule on that day
9331: --
9332: FUNCTION get_hours_by_day_of_week (
9333: p_schedule_record IN PA_SCHEDULE_GLOB.ScheduleRecord ,
9334: p_day_of_week IN PA_SCHEDULE_PVT.DayOfWeekType )
9335: RETURN NUMBER IS
9336: l_hours NUMBER := 0;
9337: BEGIN
9338: IF p_day_of_week = 'MON' THEN

Line 9356: END PA_SCHEDULE_PVT;

9352: END IF;
9353: RETURN l_hours;
9354: END get_hours_by_day_of_week;
9355:
9356: END PA_SCHEDULE_PVT;