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_PUB dependencies on PA_SCHEDULE_PUB

Line 1: PACKAGE BODY PA_SCHEDULE_PUB as

1: PACKAGE BODY PA_SCHEDULE_PUB as
2: /* $Header: PARGPUBB.pls 120.11.12010000.2 2008/10/20 10:29:25 vgovvala ship $ */
3:
4: l_out_of_range_date EXCEPTION; -- Exception variable for raising the exception when date is out of range
5: l_out_of_range_from_date EXCEPTION; -- Exception variable for raising the exception when date is out of range

Line 84: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.update_schedule');

80: --Clear the global PL/SQL message table
81: FND_MSG_PUB.initialize;
82:
83: -- Initialize the Error Stack
84: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.update_schedule');
85:
86: -- Issue API savepoint if the transaction is to be committed
87: IF (p_commit = FND_API.G_TRUE) THEN
88: SAVEPOINT SCH_PUB_UPDATE_SCH;

Line 97: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Start online validation', 6);

93: p_assign_start_date => p_change_start_date ) ;
94: IF ( l_valid_assign_start_flag = 'Y' )
95: THEN -- Bug 6411422
96:
97: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Start online validation', 6);
98: ----------------------------------------------------------------------------------------------
99: --
100: -- On Line Validation
101: --

Line 310: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling single_update_schedule', 6);

306: -- p_exception_type_code.
307: ELSIF (p_mass_update_flag = FND_API.G_FALSE) THEN
308: -- call execute_update_schedule procedure for single schedule update.
309:
310: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling single_update_schedule', 6);
311: single_update_schedule (
312: p_project_id => p_project_id
313: ,p_exception_type_code => p_exception_type_code
314: ,p_record_version_number => p_record_version_number

Line 389: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'

385: -- 4537865 : RESET x_msg_data also.
386: x_msg_data := SUBSTRB(SQLERRM,1,240);
387:
388: -- Set the excetption Message and the stack
389: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
390: ,p_procedure_name => 'execute_update_schedule'
391: ,p_error_text => x_msg_data ); -- 4537865
392:
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 476: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.single_update_schedule');

472: -- Initialize the return status to success
473: x_return_status := FND_API.G_RET_STS_SUCCESS ;
474:
475: -- Initialize the Error Stack
476: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.single_update_schedule');
477:
478: -- Issue API savepoint if the transaction is to be committed
479: IF p_commit = FND_API.G_TRUE THEN
480: SAVEPOINT SCH_PUB_SINGLE_UPDATE_SCH;

Line 530: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling change_work_pattern', 6);

526: ,x_msg_count => l_msg_count
527: ,x_msg_data => l_msg_data);
528:
529: ELSIF (p_exception_type_code = 'CHANGE_WORK_PATTERN') THEN
530: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling change_work_pattern', 6);
531: change_work_pattern (
532: p_record_version_number => p_record_version_number
533: ,p_project_id => p_project_id
534: ,p_calendar_id => l_calendar_id

Line 613: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'

609: -- 4537865 : RESET x_msg_data also
610: x_msg_data := SUBSTRB(SQLERRM,1,240);
611:
612: -- Set the excetption Message and the stack
613: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
614: ,p_procedure_name => 'single_update_schedule',
615: p_error_text => x_msg_data ); -- 4537865
616:
617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 706: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.mass_update_schedule');

702: FND_MSG_PUB.initialize;
703: END IF;
704:
705: -- Initialize the Error Stack
706: PA_DEBUG.init_err_stack('PA_SCHEDULE_PUB.mass_update_schedule');
707:
708:
709: ----------------------------------------------------------------------------------------------
710: --

Line 917: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'

913: -- 4537865 : RESET x_msg_data also
914: x_msg_data := SUBSTRB(SQLERRM,1,240);
915:
916: -- Set the excetption Message and the stack
917: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB'
918: ,p_procedure_name => 'mass_update_schedule'
919: ,p_error_text => x_msg_data ); -- 4537865
920:
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1233: PA_SCHEDULE_PUB.change_asgn_schedule(

1229: ,x_msg_data => x_msg_data );
1230:
1231: -- Calling the change assignment schedule procedure which will
1232: -- generate the schedule after applying the duration change
1233: PA_SCHEDULE_PUB.change_asgn_schedule(
1234: p_record_version_number => p_record_version_number,
1235: p_assignment_id => p_assignment_id,
1236: p_project_id => p_project_id,
1237: p_exception_id => l_exception_id,

Line 1437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

1433: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_durarion API ..'||sqlerrm);
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: x_msg_count := 1;
1436: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
1437: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
1438: p_procedure_name => 'change_duration');
1439: If x_msg_count = 1 THEN
1440: pa_interface_utils_pub.get_messages
1441: (p_encoded => FND_API.G_TRUE,

Line 1566: PA_SCHEDULE_PUB.change_asgn_schedule(

1562:
1563: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1564: -- Calling the change assignment schedule procedure
1565: -- which will generate the schedule after applying the hours change
1566: PA_SCHEDULE_PUB.change_asgn_schedule(
1567: p_record_version_number => p_record_version_number,
1568: p_assignment_id => p_assignment_id,
1569: p_project_id => p_project_id,
1570: p_exception_id => l_t_exception_id,

Line 1612: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

1608: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_hours API ..'||sqlerrm);
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1610: x_msg_count := 1;
1611: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
1612: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
1613: p_procedure_name => 'change_duration');
1614: If x_msg_count = 1 THEN
1615: pa_interface_utils_pub.get_messages
1616: (p_encoded => FND_API.G_TRUE,

Line 1801: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling pa_sch_except_pkg.insert_rows', 6);

1797: IF p_sunday_hours = -99 THEN
1798: l_p_sunday_hours := null;
1799: END IF;
1800:
1801: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling pa_sch_except_pkg.insert_rows', 6);
1802:
1803: PA_SCH_EXCEPT_PKG.Insert_Rows(
1804: p_calendar_id => p_calendar_id ,
1805: p_assignment_id => p_assignment_id ,

Line 1826: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling change_asgn_schedule', 6);

1822:
1823: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS AND p_last_row_flag = 'Y') THEN
1824: -- Calling the change assignment schedule procedure that will generate the changed schedule
1825: -- of the passed assignment for the given exception i.e change work patern
1826: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling change_asgn_schedule', 6);
1827: PA_SCHEDULE_PUB.change_asgn_schedule(
1828: p_record_version_number => p_record_version_number,
1829: p_assignment_id => p_assignment_id,
1830: p_project_id => p_project_id,

Line 1827: PA_SCHEDULE_PUB.change_asgn_schedule(

1823: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS AND p_last_row_flag = 'Y') THEN
1824: -- Calling the change assignment schedule procedure that will generate the changed schedule
1825: -- of the passed assignment for the given exception i.e change work patern
1826: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling change_asgn_schedule', 6);
1827: PA_SCHEDULE_PUB.change_asgn_schedule(
1828: p_record_version_number => p_record_version_number,
1829: p_assignment_id => p_assignment_id,
1830: p_project_id => p_project_id,
1831: p_exception_id => NULL,

Line 1876: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

1872: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern API ..'||sqlerrm);
1873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1874: x_msg_count := 1;
1875: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Replaced substr with substrb
1876: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
1877: p_procedure_name => 'change_work_pattern');
1878: If x_msg_count = 1 THEN
1879: pa_interface_utils_pub.get_messages
1880: (p_encoded => FND_API.G_TRUE,

Line 2081: PA_SCHEDULE_PUB.change_asgn_schedule(

2077: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2078: -- Calling the procedure change assignment schedule that will
2079: -- generate the changed schedule for the
2080: -- passed asignment only for the passed period
2081: PA_SCHEDULE_PUB.change_asgn_schedule(
2082: p_record_version_number => p_record_version_number,
2083: p_assignment_id => p_assignment_id,
2084: p_project_id => p_project_id,
2085: p_exception_id => l_exception_id,

Line 2193: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

2189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2190: x_msg_count := 1;
2191: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 Replaced substr with substrb
2192: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_status API ..'||sqlerrm);
2193: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2194: p_procedure_name => 'change_status');
2195: If x_msg_count = 1 THEN
2196: pa_interface_utils_pub.get_messages
2197: (p_encoded => FND_API.G_TRUE,

Line 2324: PA_SCHEDULE_PUB.change_asgn_schedule(

2320:
2321: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2322: -- Calling the change assignment schedule procedure that will generate the changed schedule
2323: -- according to the passed calendar but only for given period
2324: PA_SCHEDULE_PUB.change_asgn_schedule(
2325: p_record_version_number => p_record_version_number,
2326: p_assignment_id => p_assignment_id,
2327: p_project_id => p_project_id,
2328: p_exception_id => l_t_exception_id,

Line 2386: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

2382: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_calendar API ..'||sqlerrm);
2383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2384: x_msg_count := 1;
2385: x_msg_data := substrb(SQLERRM,1,240); -- Changed substr to substrb : 4537865
2386: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2387: p_procedure_name => 'change_calendar');
2388: If x_msg_count = 1 THEN
2389: pa_interface_utils_pub.get_messages
2390: (p_encoded => FND_API.G_TRUE,

Line 2432: PA_SCHEDULE_PUB.change_asgn_schedule(

2428: 'Schedule Exception table - assignment Id :'||
2429: to_char(rec_sch_excp.assignment_id));
2430: -- Calling the procedure change_asgn_schedule that will generate the
2431: -- change schedule for the passed start date and end date
2432: PA_SCHEDULE_PUB.change_asgn_schedule(
2433: p_record_version_number => rec_sch_excp.record_version_number,
2434: p_assignment_id => rec_sch_excp.assignment_id,
2435: p_project_id => rec_sch_excp.project_id,
2436: p_exception_id => null,

Line 2463: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

2459: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_schedule API ..'||sqlerrm);
2460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2461: x_msg_count := 1;
2462: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Replaced substr usage with substrb
2463: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2464: p_procedure_name => 'change_schedule');
2465: If x_msg_count = 1 THEN
2466: pa_interface_utils_pub.get_messages
2467: (p_encoded => FND_API.G_TRUE ,

Line 2911: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

2907: ||sqlerrm);
2908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2909: x_msg_count := 1;
2910: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
2911: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2912: p_procedure_name => 'change_asgn_schedule');
2913: If x_msg_count = 1 THEN
2914: pa_interface_utils_pub.get_messages
2915: (p_encoded => FND_API.G_TRUE ,

Line 3013: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

3009: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_calendar_schedule API ..'||sqlerrm);
3010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3011: x_msg_count := 1;
3012: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 changed substr to substrb
3013: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
3014: p_procedure_name => 'create_calendar_schedule');
3015: If x_msg_count = 1 THEN
3016: pa_interface_utils_pub.get_messages
3017: (p_encoded => FND_API.G_TRUE,

Line 3215: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

3211: -- RESET other out params also : 4537865
3212: x_calendar_id := NULL ;
3213: x_calendar_name := NULL;
3214:
3215: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
3216: p_procedure_name => 'get_proj_calendar_default');
3217: If x_msg_count = 1 THEN
3218: pa_interface_utils_pub.get_messages
3219: (p_encoded => FND_API.G_TRUE,

Line 3315: PA_SCHEDULE_PUB.create_calendar_schedule(v_c1.calendar_id,l_x_return_status,x_msg_count,x_msg_data);

3311: WHERE calendar_id = v_c1.calendar_id
3312: AND schedule_type_code = 'CALENDAR';
3313:
3314: -- Creating new schedule for the Calendar Id */
3315: PA_SCHEDULE_PUB.create_calendar_schedule(v_c1.calendar_id,l_x_return_status,x_msg_count,x_msg_data);
3316:
3317: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');
3318: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3319: PA_TIMELINE_PVT.Create_Timeline (p_calendar_id =>v_c1.calendar_id,

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

3386: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_cal_schedules API ..'|| sqlerrm);
3387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3388: x_msg_count := 1;
3389: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substrb to substr
3390: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
3391: p_procedure_name => 'create_new_cal_schedules');
3392: If x_msg_count = 1 THEN
3393: pa_interface_utils_pub.get_messages
3394: (p_encoded => FND_API.G_TRUE,

Line 3933: pa_schedule_pub.change_duration(

3929: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
3930: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
3931: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
3932:
3933: pa_schedule_pub.change_duration(
3934: p_record_version_number => p_record_version_number,
3935: p_exception_type_code => 'CHANGE_DURATION' ,
3936: p_project_id => p_project_id ,
3937: p_calendar_id => p_calendar_id ,

Line 3959: pa_schedule_pub.change_work_pattern(

3955: -- There is a gap found, so need to fill this with 0 hours
3956: IF l_call_cng_work_patt_out_range THEN
3957: PA_SCHEDULE_UTILS.log_message(1,'l_call_cng_work_patt_out_range is true');
3958:
3959: pa_schedule_pub.change_work_pattern(
3960: p_record_version_number => p_record_version_number ,
3961: p_project_id => p_project_id ,
3962: p_calendar_id => p_calendar_id ,
3963: p_assignment_id => p_assignment_id ,

Line 4352: pa_schedule_pub.change_duration(

4348: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
4349: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4350: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4351:
4352: pa_schedule_pub.change_duration(
4353: p_record_version_number => p_record_version_number,
4354: p_exception_type_code => 'CHANGE_DURATION' ,
4355: p_project_id => p_project_id ,
4356: p_calendar_id => p_calendar_id ,

Line 4378: pa_schedule_pub.change_work_pattern(

4374: -- There is a gap found, so need to fill this with 0 hours
4375: IF l_call_cng_work_patt_out_range THEN
4376: PA_SCHEDULE_UTILS.log_message(1,'l_call_cng_work_patt_out_range is true');
4377:
4378: pa_schedule_pub.change_work_pattern(
4379: p_record_version_number => p_record_version_number ,
4380: p_project_id => p_project_id ,
4381: p_calendar_id => p_calendar_id ,
4382: p_assignment_id => p_assignment_id ,

Line 4424: pa_schedule_pub.change_work_pattern(

4420: l_last_row_flag := 'Y';
4421: END IF;
4422:
4423: If l_call_first_time THEN
4424: pa_schedule_pub.change_work_pattern(
4425: p_record_version_number => p_record_version_number ,
4426: p_project_id => p_project_id ,
4427: p_calendar_id => p_calendar_id ,
4428: p_assignment_id => p_assignment_id ,

Line 4458: pa_schedule_pub.change_work_pattern(

4454: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern second time');
4455: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date2='||l_ch_work_pattern_st_date2);
4456: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date2='||l_ch_work_pattern_end_date2);
4457:
4458: pa_schedule_pub.change_work_pattern(
4459: p_record_version_number => p_record_version_number ,
4460: p_project_id => p_project_id ,
4461: p_calendar_id => p_calendar_id ,
4462: p_assignment_id => p_assignment_id ,

Line 4559: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

4555: -- 4537865 : RESET other out params also.
4556: x_call_timeline_st_date := NULL ;
4557: x_call_timeline_end_date := NULL ;
4558:
4559: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
4560: p_procedure_name => 'change_work_pattern_duration');
4561: IF x_msg_count = 1 THEN
4562: pa_interface_utils_pub.get_messages
4563: (p_encoded => FND_API.G_TRUE,

Line 4577: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

4573: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern_duration API ..'|| sqlerrm);
4574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4575: x_msg_count := 1;
4576: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Chnaged substr to substrb
4577: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
4578: p_procedure_name => 'change_work_pattern_duration');
4579:
4580: -- 4537865 : RESET other out params also.
4581: x_call_timeline_st_date := NULL ;

Line 5335: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

5331: x_msg_data := substrb(SQLERRM,1,240); -- 4537865
5332: -- RESET x_show_start_date also
5333: x_show_start_date := NULL ;
5334:
5335: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
5336: p_procedure_name => 'Populate_work_pattern_table');
5337: IF x_msg_count = 1 THEN
5338: pa_interface_utils_pub.get_messages
5339: (p_encoded => FND_API.G_TRUE,

Line 5353: END PA_SCHEDULE_PUB;

5349: END Populate_work_pattern_table;
5350:
5351: -- Unilog Enhancement END
5352:
5353: END PA_SCHEDULE_PUB;