APPS.PA_SCHEDULE_PUB dependencies on PA_SCHEDULE_UTILS

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

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

Line 131: PA_SCHEDULE_UTILS.validate_date_range (p_change_start_date, p_change_end_date, l_x_return_status, l_err_msg_code);

127:
128: -- If this api has been called from the page which has start_date, end_date input, call
129: -- the validation date procedure. It will validate the date i.e. start_date should not be greater
130: -- than end_date. If end date date greater than start_date, then it will return l_x_return_status as error.
131: PA_SCHEDULE_UTILS.validate_date_range (p_change_start_date, p_change_end_date, l_x_return_status, l_err_msg_code);
132:
133: -- If validate_date_range fails, put error message into error stack and stop to process.
134: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
135: PA_UTILS.Add_Message ('PA', l_err_msg_code);

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

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

Line 545: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub.update_schedule_bulk', 'Assignment_type:'||l_assignment_type, 6);

541: INTO l_assignment_type
542: FROM pa_project_assignments
543: WHERE assignment_id= p_assignment_id_tbl(k);
544:
545: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub.update_schedule_bulk', 'Assignment_type:'||l_assignment_type, 6);
546: IF l_assignment_type IN ('STAFFED_ASSIGNMENT','STAFFED_ADMIN_ASSIGNMENT') THEN
547: l_assignment_status_code := '104';
548: END IF;
549: END IF;

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

547: l_assignment_status_code := '104';
548: END IF;
549: END IF;
550:
551: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub.update_schedule_bulk', 'Calling single_update_schedule', 6);
552:
553: --Bug#9817752 end
554:
555:

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

766: -- p_exception_type_code.
767: ELSIF (l_mass_update_flag_tbl(k) = FND_API.G_FALSE) THEN
768: -- call execute_update_schedule procedure for single schedule update.
769:
770: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling single_update_schedule', 6);
771:
772: -- Bug#9710585 START Adding Validation for percent
773: IF (p_change_hours_type_code_tbl(k) = 'PERCENTAGE') THEN
774: IF (p_calendar_percent_tbl(k) NOT BETWEEN 0 AND 100 ) THEN

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

994: ,x_msg_count => l_msg_count
995: ,x_msg_data => l_msg_data);
996:
997: ELSIF (p_exception_type_code = 'CHANGE_WORK_PATTERN') THEN
998: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling change_work_pattern', 6);
999: change_work_pattern (
1000: p_record_version_number => p_record_version_number
1001: ,p_project_id => p_project_id
1002: ,p_calendar_id => l_calendar_id

Line 1611: PA_SCHEDULE_UTILS.log_message(1,'Validate that resource is valid for new start date?');

1607:
1608: --
1609: -- Validate that resource is valid for new start date
1610: --
1611: PA_SCHEDULE_UTILS.log_message(1,'Validate that resource is valid for new start date?');
1612: IF p_assignment_type <> 'OPEN_ASSIGNMENT' THEN
1613: PA_SCHEDULE_UTILS.log_message(1,'Validating resource');
1614: -- Get resource source id for assignment
1615: OPEN get_resource_source_id;

Line 1613: PA_SCHEDULE_UTILS.log_message(1,'Validating resource');

1609: -- Validate that resource is valid for new start date
1610: --
1611: PA_SCHEDULE_UTILS.log_message(1,'Validate that resource is valid for new start date?');
1612: IF p_assignment_type <> 'OPEN_ASSIGNMENT' THEN
1613: PA_SCHEDULE_UTILS.log_message(1,'Validating resource');
1614: -- Get resource source id for assignment
1615: OPEN get_resource_source_id;
1616: FETCH get_resource_source_id INTO l_resource_source_id, l_resource_id;
1617: CLOSE get_resource_source_id;

Line 1632: PA_SCHEDULE_UTILS.log_message(1,'Resource dates are not valid');

1628: ,x_return_status => l_x_return_status
1629: ,x_error_message_code => l_error_message_code);
1630:
1631: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1632: PA_SCHEDULE_UTILS.log_message(1,'Resource dates are not valid');
1633: Raise l_resource_out_of_range;
1634: ELSE -- IF if l_x_return_status is success : 4537865
1635: l_resource_source_id := l_new_resource_id ;
1636: END IF;

Line 1638: PA_SCHEDULE_UTILS.log_message(1,'Resource dates are valid');

1634: ELSE -- IF if l_x_return_status is success : 4537865
1635: l_resource_source_id := l_new_resource_id ;
1636: END IF;
1637:
1638: PA_SCHEDULE_UTILS.log_message(1,'Resource dates are valid');
1639:
1640: -- Check if resource is assigned to a valid organization
1641: PA_RESOURCE_UTILS.check_cc_for_resource(p_resource_id => l_resource_id,
1642: p_project_id => p_project_id,

Line 1650: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is not valid: u');

1646: x_return_status => l_x_return_status,
1647: x_error_message_code => l_error_message_code);
1648:
1649: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1650: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is not valid: u');
1651: Raise l_resource_cc_error_u;
1652: END IF;
1653:
1654: IF l_cc_ok <> 'Y' THEN

Line 1655: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is not valid: e');

1651: Raise l_resource_cc_error_u;
1652: END IF;
1653:
1654: IF l_cc_ok <> 'Y' THEN
1655: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is not valid: e');
1656: Raise l_resource_cc_error_e;
1657: END IF;
1658:
1659: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is valid');

Line 1659: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is valid');

1655: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is not valid: e');
1656: Raise l_resource_cc_error_e;
1657: END IF;
1658:
1659: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is valid');
1660:
1661: -- Make sure duration change does not cause existing actuals to
1662: -- be out of range.
1663: -- 2797890: Added parameter p_project_id, p_person_id.

Line 1684: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_duration API ..... ');

1680:
1681: --
1682: -- Insert row to PA_SCHEDULE_EXCEPTIONS
1683: --
1684: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_duration API ..... ');
1685: PA_SCH_EXCEPT_PKG.Insert_Rows(
1686: p_calendar_id => p_calendar_id
1687: ,p_assignment_id => p_assignment_id
1688: ,p_project_id => p_project_id

Line 1744: PA_SCHEDULE_UTILS.log_message(1,'End of the change_duration API ..... ');

1740: --
1741: -- Exception Handling
1742: --
1743: ----------------------------------------------------------------------
1744: PA_SCHEDULE_UTILS.log_message(1,'End of the change_duration API ..... ');
1745: x_return_status := l_x_return_status;
1746:
1747: x_msg_count := FND_MSG_PUB.Count_Msg;
1748: If x_msg_count = 1 THEN

Line 1905: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_durarion API ..'||sqlerrm);

1901: p_msg_index_out => l_msg_index_out );
1902: x_msg_data := l_data; -- 4537865 : NOCOPY related change
1903: End If;
1904: WHEN OTHERS THEN
1905: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_durarion API ..'||sqlerrm);
1906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1907: x_msg_count := 1;
1908: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
1909: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

Line 2006: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_hours API ... ');

2002: (p_end_date NOT BETWEEN p_asgn_start_date AND p_asgn_end_date )) THEN
2003: Raise l_out_of_range_date;
2004: END IF;
2005:
2006: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_hours API ... ');
2007:
2008: PA_SCH_EXCEPT_PKG.Insert_Rows(
2009: p_calendar_id => p_calendar_id ,
2010: p_assignment_id => p_assignment_id ,

Line 2048: PA_SCHEDULE_UTILS.log_message(1,'End of the change_hours API ... ');

2044: x_msg_count => x_msg_count,
2045: x_msg_data => x_msg_data);
2046: END IF;
2047:
2048: PA_SCHEDULE_UTILS.log_message(1,'End of the change_hours API ... ');
2049: x_return_status := l_x_return_status;
2050: x_msg_count := FND_MSG_PUB.Count_Msg;
2051: If x_msg_count = 1 THEN
2052: pa_interface_utils_pub.get_messages

Line 2080: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_hours API ..'||sqlerrm);

2076: p_msg_index_out => l_msg_index_out );
2077: x_msg_data := l_data ; -- 4537865 : NOCOPY related Change
2078: End If;
2079: WHEN OTHERS THEN
2080: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_hours API ..'||sqlerrm);
2081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2082: x_msg_count := 1;
2083: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb
2084: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

Line 2193: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern API ... ');

2189: (p_end_date NOT BETWEEN p_asgn_start_date AND p_asgn_end_date )) THEN
2190: RAISE l_out_of_range_date;
2191: END IF;
2192:
2193: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern API ... ');
2194:
2195: l_p_monday_hours := p_monday_hours;
2196: l_p_tuesday_hours := p_tuesday_hours;
2197: l_p_wednesday_hours := p_wednesday_hours;

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

2269: IF p_sunday_hours = -99 THEN
2270: l_p_sunday_hours := null;
2271: END IF;
2272:
2273: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling pa_sch_except_pkg.insert_rows', 6);
2274:
2275: PA_SCH_EXCEPT_PKG.Insert_Rows(
2276: p_calendar_id => p_calendar_id ,
2277: p_assignment_id => p_assignment_id ,

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

2294:
2295: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS AND p_last_row_flag = 'Y') THEN
2296: -- Calling the change assignment schedule procedure that will generate the changed schedule
2297: -- of the passed assignment for the given exception i.e change work patern
2298: pa_schedule_utils.debug('pa.plsql.pa_schedule_pub', 'Calling change_asgn_schedule', 6);
2299: PA_SCHEDULE_PUB.change_asgn_schedule(
2300: p_record_version_number => p_record_version_number,
2301: p_assignment_id => p_assignment_id,
2302: p_project_id => p_project_id,

Line 2311: PA_SCHEDULE_UTILS.log_message(1,'End of the change_work_pattern API ... ');

2307: x_msg_count => x_msg_count,
2308: x_msg_data => x_msg_data);
2309: END IF;
2310:
2311: PA_SCHEDULE_UTILS.log_message(1,'End of the change_work_pattern API ... ');
2312: x_return_status := l_x_return_status;
2313:
2314: x_msg_count := FND_MSG_PUB.Count_Msg;
2315: If x_msg_count = 1 THEN

Line 2344: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern API ..'||sqlerrm);

2340: p_msg_index_out => l_msg_index_out );
2341: x_msg_data := l_data ; -- 4537865 : NOCOPY related change
2342: End If;
2343: WHEN OTHERS THEN
2344: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern API ..'||sqlerrm);
2345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2346: x_msg_count := 1;
2347: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Replaced substr with substrb
2348: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

Line 2457: PA_SCHEDULE_UTILS.log_message(1,'Start of Change_Status ... ');

2453: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
2454: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
2455: END IF;
2456:
2457: PA_SCHEDULE_UTILS.log_message(1,'Start of Change_Status ... ');
2458:
2459: -- p_assignment_status_code should not be null
2460: IF (p_assignment_status_code is NULL) THEN
2461: PA_UTILS.Add_Message ('PA', 'PA_SCH_ASGN_STATUS_NULL'); -- is this message okay?

Line 2504: PA_SCHEDULE_UTILS.log_message(1,'Calling Assignment API ... ');

2500: else
2501: l_status_type := p_status_type;
2502: end if;
2503:
2504: PA_SCHEDULE_UTILS.log_message(1,'Calling Assignment API ... ');
2505:
2506: -- Partially cancelled assignments are now possible, so we are removing the
2507: -- check.
2508:

Line 2534: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_status API ... ');

2530: -- END IF;
2531: -- END IF;
2532: -- */
2533:
2534: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_status API ... ');
2535: PA_SCH_EXCEPT_PKG.Insert_Rows(
2536: p_calendar_id => p_calendar_id ,
2537: p_assignment_id => p_assignment_id ,
2538: p_project_id => p_project_id ,

Line 2564: PA_SCHEDULE_UTILS.log_message(1,'End of the change_status API ... ');

2560: x_msg_count => x_msg_count,
2561: x_msg_data => x_msg_data);
2562: END IF;
2563:
2564: PA_SCHEDULE_UTILS.log_message(1,'End of the change_status API ... ');
2565: x_return_status := l_x_return_status;
2566:
2567: x_msg_count := FND_MSG_PUB.Count_Msg;
2568: If x_msg_count = 1 THEN

Line 2664: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_status API ..'||sqlerrm);

2660: WHEN OTHERS THEN
2661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2662: x_msg_count := 1;
2663: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 Replaced substr with substrb
2664: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_status API ..'||sqlerrm);
2665: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',
2666: p_procedure_name => 'change_status');
2667: If x_msg_count = 1 THEN
2668: pa_interface_utils_pub.get_messages

Line 2779: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_calendar API ... ');

2775: ELSE
2776: l_calendar_id := p_calendar_id;
2777: END IF;
2778:
2779: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_calendar API ... ');
2780: PA_SCH_EXCEPT_PKG.Insert_Rows(
2781: p_calendar_id => l_calendar_id ,
2782: p_assignment_id => p_assignment_id ,
2783: p_project_id => p_project_id ,

Line 2806: PA_SCHEDULE_UTILS.log_message(1,'End of the change_calendar API ... ');

2802: x_msg_count => x_msg_count,
2803: x_msg_data => x_msg_data);
2804: END IF;
2805:
2806: PA_SCHEDULE_UTILS.log_message(1,'End of the change_calendar API ... ');
2807: x_return_status := l_x_return_status;
2808:
2809: x_msg_count := FND_MSG_PUB.Count_Msg;
2810: If x_msg_count = 1 THEN

Line 2854: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_calendar API ..'||sqlerrm);

2850: p_msg_index_out => l_msg_index_out );
2851: x_msg_data := l_data ; -- 4537865 : NOCOPY related change
2852: End If;
2853: WHEN OTHERS THEN
2854: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_calendar API ..'||sqlerrm);
2855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: x_msg_count := 1;
2857: x_msg_data := substrb(SQLERRM,1,240); -- Changed substr to substrb : 4537865
2858: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

Line 2896: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_schedule API ... ');

2892: BEGIN
2893: -- store the status success to track the error
2894: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
2895:
2896: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_schedule API ... ');
2897:
2898: FOR rec_sch_excp IN csr_sch_excp LOOP
2899: PA_SCHEDULE_UTILS.log_message(1,
2900: 'Schedule Exception table - assignment Id :'||

Line 2899: PA_SCHEDULE_UTILS.log_message(1,

2895:
2896: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_schedule API ... ');
2897:
2898: FOR rec_sch_excp IN csr_sch_excp LOOP
2899: PA_SCHEDULE_UTILS.log_message(1,
2900: 'Schedule Exception table - assignment Id :'||
2901: to_char(rec_sch_excp.assignment_id));
2902: -- Calling the procedure change_asgn_schedule that will generate the
2903: -- change schedule for the passed start date and end date

Line 2913: PA_SCHEDULE_UTILS.log_message(1,'End of the change_schedule API ... ');

2909: x_return_status => l_x_return_status,
2910: x_msg_count => x_msg_count,
2911: x_msg_data => x_msg_data);
2912: END LOOP;
2913: PA_SCHEDULE_UTILS.log_message(1,'End of the change_schedule API ... ');
2914:
2915: x_return_status := l_x_return_status;
2916:
2917: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 2931: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_schedule API ..'||sqlerrm);

2927: End If;
2928:
2929: EXCEPTION
2930: WHEN OTHERS THEN
2931: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_schedule API ..'||sqlerrm);
2932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2933: x_msg_count := 1;
2934: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Replaced substr usage with substrb
2935: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

Line 3048: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_asgn_schedule API ... ');

3044:
3045: BEGIN
3046: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
3047:
3048: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_asgn_schedule API ... ');
3049:
3050: -- Unilog Begin
3051: l_save_to_hist := p_save_to_hist;
3052: IF p_generate_timeline_flag = 'N' THEN -- It means it is called from WeeklySchedule

Line 3092: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API get_assignment_schedule ....');

3088:
3089:
3090: l_apply_schedule_changes := FALSE;
3091:
3092: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API get_assignment_schedule ....');
3093:
3094: -- Calling the PVT API This api will bring the asignment schedule for the passed
3095: -- asignment id and it will store the schedule in tabel of record i.e l_tr_sch_rec_tab.
3096: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_id,

Line 3102: PA_SCHEDULE_UTILS.log_message(1,'START ASSG SCHEDULE ',l_tr_sch_rec_tab );

3098: l_x_return_status,
3099: x_msg_count,
3100: x_msg_data );
3101:
3102: PA_SCHEDULE_UTILS.log_message(1,'START ASSG SCHEDULE ',l_tr_sch_rec_tab );
3103: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API get_assignment_schedule ....');
3104:
3105: l_I := 1;
3106:

Line 3103: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API get_assignment_schedule ....');

3099: x_msg_count,
3100: x_msg_data );
3101:
3102: PA_SCHEDULE_UTILS.log_message(1,'START ASSG SCHEDULE ',l_tr_sch_rec_tab );
3103: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API get_assignment_schedule ....');
3104:
3105: l_I := 1;
3106:
3107: -- Copying the exceptions of the given assignment

Line 3164: PA_SCHEDULE_UTILS.log_message(1,'Index Value :' || to_char(l_i));

3160:
3161: l_exception_type_code := rec_sch_excp.exception_type_code ; -- 7663765
3162:
3163: IF (l_I > 1) THEN
3164: PA_SCHEDULE_UTILS.log_message(1,'Index Value :' || to_char(l_i));
3165: l_tr_sch_rec_tab.delete;
3166:
3167:
3168: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 3170: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(

3166:
3167:
3168: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3169: -- This procedure will copy the schedule record from one table of record to another
3170: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(
3171: l_chg_tr_sch_rec_tab,
3172: l_chg_tr_sch_rec_tab.first,
3173: l_chg_tr_sch_rec_tab.last,
3174: l_tr_sch_rec_tab,

Line 3181: PA_SCHEDULE_UTILS.log_message(1,'after copy schedule : ',l_tr_sch_rec_tab );

3177: x_msg_data
3178: );
3179: END IF;
3180:
3181: PA_SCHEDULE_UTILS.log_message(1,'after copy schedule : ',l_tr_sch_rec_tab );
3182: END IF;
3183:
3184: IF (rec_sch_excp.exception_type_code = 'CHANGE_DURATION' OR
3185: rec_sch_excp.exception_type_code = 'SHIFT_DURATION' OR rec_sch_excp.exception_type_code = 'DURATION_PATTERN_SHIFT') then -- 7663765

Line 3201: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ',l_out_tr_sch_rec_tab );

3197: l_new_start_date := l_sch_except_rec.start_date;
3198: l_new_end_date := l_sch_except_rec.end_date;
3199: END IF;
3200:
3201: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ',l_out_tr_sch_rec_tab );
3202: ELSE
3203:
3204: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ' );
3205:

Line 3204: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ' );

3200:
3201: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ',l_out_tr_sch_rec_tab );
3202: ELSE
3203:
3204: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ' );
3205:
3206: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3207: -- calling PVT API that will apply the changes
3208: PA_SCHEDULE_UTILS.log_message (1,' IN THE ELSE PART AND starting of apply other changes ');

Line 3208: PA_SCHEDULE_UTILS.log_message (1,' IN THE ELSE PART AND starting of apply other changes ');

3204: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ' );
3205:
3206: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3207: -- calling PVT API that will apply the changes
3208: PA_SCHEDULE_UTILS.log_message (1,' IN THE ELSE PART AND starting of apply other changes ');
3209: PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes1 :', l_tr_sch_rec_tab);
3210: --PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes2 :', l_sch_except_rec);
3211: PA_SCHEDULE_PVT.apply_other_changes(l_tr_sch_rec_tab,
3212: l_sch_except_rec,

Line 3209: PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes1 :', l_tr_sch_rec_tab);

3205:
3206: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3207: -- calling PVT API that will apply the changes
3208: PA_SCHEDULE_UTILS.log_message (1,' IN THE ELSE PART AND starting of apply other changes ');
3209: PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes1 :', l_tr_sch_rec_tab);
3210: --PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes2 :', l_sch_except_rec);
3211: PA_SCHEDULE_PVT.apply_other_changes(l_tr_sch_rec_tab,
3212: l_sch_except_rec,
3213: l_out_tr_sch_rec_tab,

Line 3210: --PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes2 :', l_sch_except_rec);

3206: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3207: -- calling PVT API that will apply the changes
3208: PA_SCHEDULE_UTILS.log_message (1,' IN THE ELSE PART AND starting of apply other changes ');
3209: PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes1 :', l_tr_sch_rec_tab);
3210: --PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes2 :', l_sch_except_rec);
3211: PA_SCHEDULE_PVT.apply_other_changes(l_tr_sch_rec_tab,
3212: l_sch_except_rec,
3213: l_out_tr_sch_rec_tab,
3214: l_x_return_status,

Line 3220: PA_SCHEDULE_UTILS.log_message(1,'after change_others : ',l_out_tr_sch_rec_tab );

3216: x_msg_data
3217: );
3218: END IF;
3219:
3220: PA_SCHEDULE_UTILS.log_message(1,'after change_others : ',l_out_tr_sch_rec_tab );
3221: END IF;
3222:
3223: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3224: -- seperating the deleted or non deleted record i.e inserted or updated

Line 3225: PA_SCHEDULE_UTILS.sep_del_sch_rec_tab(l_out_tr_sch_rec_tab,

3221: END IF;
3222:
3223: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3224: -- seperating the deleted or non deleted record i.e inserted or updated
3225: PA_SCHEDULE_UTILS.sep_del_sch_rec_tab(l_out_tr_sch_rec_tab,
3226: l_del_tr_sch_rec_tab,
3227: l_chg_tr_sch_rec_tab,
3228: l_x_return_status,
3229: x_msg_count,

Line 3236: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (change ) : ',l_chg_tr_sch_rec_tab );

3232: END IF;
3233:
3234: l_I := l_I + 1;
3235:
3236: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (change ) : ',l_chg_tr_sch_rec_tab );
3237: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (delete ) : ',l_del_tr_sch_rec_tab );
3238:
3239: END LOOP;
3240:

Line 3237: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (delete ) : ',l_del_tr_sch_rec_tab );

3233:
3234: l_I := l_I + 1;
3235:
3236: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (change ) : ',l_chg_tr_sch_rec_tab );
3237: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (delete ) : ',l_del_tr_sch_rec_tab );
3238:
3239: END LOOP;
3240:
3241: PA_SCHEDULE_UTILS.log_message(1,'FINAL (change ) : ',l_chg_tr_sch_rec_tab );

Line 3241: PA_SCHEDULE_UTILS.log_message(1,'FINAL (change ) : ',l_chg_tr_sch_rec_tab );

3237: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (delete ) : ',l_del_tr_sch_rec_tab );
3238:
3239: END LOOP;
3240:
3241: PA_SCHEDULE_UTILS.log_message(1,'FINAL (change ) : ',l_chg_tr_sch_rec_tab );
3242: PA_SCHEDULE_UTILS.log_message(1,'FINAL (delete ) : ',l_del_tr_sch_rec_tab );
3243:
3244: IF ( l_apply_schedule_changes ) THEN
3245: /* Added below for 7663765 */

Line 3242: PA_SCHEDULE_UTILS.log_message(1,'FINAL (delete ) : ',l_del_tr_sch_rec_tab );

3238:
3239: END LOOP;
3240:
3241: PA_SCHEDULE_UTILS.log_message(1,'FINAL (change ) : ',l_chg_tr_sch_rec_tab );
3242: PA_SCHEDULE_UTILS.log_message(1,'FINAL (delete ) : ',l_del_tr_sch_rec_tab );
3243:
3244: IF ( l_apply_schedule_changes ) THEN
3245: /* Added below for 7663765 */
3246: if (l_exception_type_code = 'DURATION_PATTERN_SHIFT') then

Line 3250: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API apply_schedule_change ....');

3246: if (l_exception_type_code = 'DURATION_PATTERN_SHIFT') then
3247: delete pa_schedules where assignment_id = p_assignment_id;
3248: end if;
3249:
3250: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API apply_schedule_change ....');
3251:
3252: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3253: -- Calling the PVT api that will change the schedule
3254: PA_SCHEDULE_PVT.apply_schedule_change(l_chg_tr_sch_rec_tab,

Line 3261: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API apply_schedule_change ....');

3257: x_msg_count,
3258: x_msg_data);
3259: END IF;
3260:
3261: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API apply_schedule_change ....');
3262:
3263: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3264: -- Calling the API PA_SCHEDULE_PVT.apply_assignment_change
3265:

Line 3291: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API delete_rows ....');

3287: x_msg_count => x_msg_count,
3288: x_msg_data => x_msg_data);
3289: END IF;
3290:
3291: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API delete_rows ....');
3292:
3293: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3294: -- Deleting the rows from pa_schedule_exception table
3295: PA_SCH_EXCEPT_PKG.delete_rows(l_sch_except_record_tab,

Line 3302: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API delete_rows ..');

3298: x_msg_data
3299: );
3300: END IF;
3301:
3302: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API delete_rows ..');
3303:
3304: -- inserting the rows from schedule except history table
3305: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3306: IF (FND_API.TO_BOOLEAN(NVL(l_save_to_hist,FND_API.G_TRUE))) THEN

Line 3317: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API insert_rows ....');

3313: );
3314: END IF;
3315: END IF;
3316:
3317: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API insert_rows ....');
3318: END IF;
3319:
3320: IF p_generate_timeline_flag = 'Y' THEN --Unilog
3321:

Line 3325: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');

3321:
3322: -- Calling the Timeline api to create the timeline records
3323: -- for the assignment
3324: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3325: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');
3326: PA_SCHEDULE_UTILS.log_message(1, 'Num: ' || FND_MSG_PUB.Count_Msg);
3327: PA_TIMELINE_PVT.create_timeline (
3328: p_assignment_id =>p_assignment_id ,
3329: x_return_status =>l_x_return_status ,

Line 3326: PA_SCHEDULE_UTILS.log_message(1, 'Num: ' || FND_MSG_PUB.Count_Msg);

3322: -- Calling the Timeline api to create the timeline records
3323: -- for the assignment
3324: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3325: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');
3326: PA_SCHEDULE_UTILS.log_message(1, 'Num: ' || FND_MSG_PUB.Count_Msg);
3327: PA_TIMELINE_PVT.create_timeline (
3328: p_assignment_id =>p_assignment_id ,
3329: x_return_status =>l_x_return_status ,
3330: x_msg_count =>x_msg_count ,

Line 3368: PA_SCHEDULE_UTILS.log_message(1,'End of the change_asgn_schedule API ... ');

3364: END IF;
3365: END IF;
3366: END IF; -- Unilog
3367:
3368: PA_SCHEDULE_UTILS.log_message(1,'End of the change_asgn_schedule API ... ');
3369: x_return_status := l_x_return_status;
3370:
3371: x_msg_count := FND_MSG_PUB.Count_Msg;
3372:

Line 3386: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_asgn_schedule API ..'

3382: End If;
3383:
3384: EXCEPTION
3385: WHEN OTHERS THEN
3386: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_asgn_schedule API ..'
3387: ||sqlerrm);
3388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3389: x_msg_count := 1;
3390: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substr to substrb

Line 3427: PA_SCHEDULE_UTILS.log_message(1,'Start of the create_calendar_schedule API ... ');

3423: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
3424: l_msg_index_out NUMBER;
3425: l_data varchar2(2000) ;-- 4537865
3426: BEGIN
3427: PA_SCHEDULE_UTILS.log_message(1,'Start of the create_calendar_schedule API ... ');
3428: -- storing the status success to track the error
3429: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
3430:
3431: -- Calling the Calendar API that will give the shift assign to the calendar*/

Line 3440: PA_SCHEDULE_UTILS.log_message(1,'GEN SCH ',l_schedule_rec_tab);

3436: x_msg_count,x_msg_data);
3437:
3438: END IF;
3439:
3440: PA_SCHEDULE_UTILS.log_message(1,'GEN SCH ',l_schedule_rec_tab);
3441: IF ( l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3442: -- Calling the PA_CALENDAR_UTILS API that will take the exception associated with the calendar
3443: PA_CALENDAR_UTILS.get_calendar_except(p_calendar_id,l_x_cal_except_record_tab,l_x_return_status,
3444: x_msg_count,x_msg_data);

Line 3473: PA_SCHEDULE_UTILS.log_message(1,'End of the create_calendar_schedule API ... ');

3469: ,x_msg_data => x_msg_data
3470: );*/
3471: -- End Of Bug No : 4666318
3472:
3473: PA_SCHEDULE_UTILS.log_message(1,'End of the create_calendar_schedule API ... ');
3474:
3475: x_return_status := l_x_return_status;
3476: x_msg_count := FND_MSG_PUB.Count_Msg;
3477: If x_msg_count = 1 THEN

Line 3489: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_calendar_schedule API ..'||sqlerrm);

3485: x_msg_Data := l_data ;-- 4537865
3486: End If;
3487: EXCEPTION
3488: WHEN OTHERS THEN
3489: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_calendar_schedule API ..'||sqlerrm);
3490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3491: x_msg_count := 1;
3492: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 changed substr to substrb
3493: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

Line 3537: PA_SCHEDULE_UTILS.log_message(1,'Start of the get_proj_calendar_default API ... ');

3533: L_MSG_INDEX_OUT NUMBER;
3534:
3535: l_data varchar2(2000); -- 4537865
3536: BEGIN
3537: PA_SCHEDULE_UTILS.log_message(1,'Start of the get_proj_calendar_default API ... ');
3538:
3539: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
3540: l_no_calendar_at_org := FALSE;
3541:

Line 3544: PA_SCHEDULE_UTILS.log_message(1,'PRM is not licensed, so returning null.');

3540: l_no_calendar_at_org := FALSE;
3541:
3542: /* Bug2873984
3543: IF (PA_INSTALL.IS_PRM_LICENSED() <> 'Y') THEN
3544: PA_SCHEDULE_UTILS.log_message(1,'PRM is not licensed, so returning null.');
3545: x_calendar_id := null;
3546: x_calendar_name := null;
3547: x_return_status := l_x_return_status;
3548: return;

Line 3551: PA_SCHEDULE_UTILS.log_message(1,'PRM is licensed, so continuing.');

3547: x_return_status := l_x_return_status;
3548: return;
3549: END IF; */
3550:
3551: PA_SCHEDULE_UTILS.log_message(1,'PRM is licensed, so continuing.');
3552:
3553: -- Taking out the orgnization id for passing to the get_proj_calendar_default */
3554: IF (p_project_id IS NOT NULL ) THEN
3555: BEGIN

Line 3572: PA_SCHEDULE_UTILS.log_message(1,'before select on hr_org.... ');

3568: l_t_carrying_out_org_id := p_proj_organization;
3569: END IF;
3570:
3571: BEGIN
3572: PA_SCHEDULE_UTILS.log_message(1,'before select on hr_org.... ');
3573:
3574: -- Taking the calendar on the basis of organization assigned to the project
3575: -- R12 changes - the calendar is now stored
3576: -- under a new information type - Resource Defaults

Line 3593: PA_SCHEDULE_UTILS.log_message(1,'after select on hr_org.... ');

3589: AND hr1.organization_id = l_t_carrying_out_org_id
3590: --AND hr1.org_information_context = 'Exp Organization Defaults';
3591: AND hr1.org_information_context = 'Resource Defaults';
3592:
3593: PA_SCHEDULE_UTILS.log_message(1,'after select on hr_org.... ');
3594: EXCEPTION
3595: WHEN NO_DATA_FOUND THEN
3596: PA_SCHEDULE_UTILS.log_message(1,'inside no data found for select on hr_org.... ');
3597: l_no_calendar_at_org := TRUE;

Line 3596: PA_SCHEDULE_UTILS.log_message(1,'inside no data found for select on hr_org.... ');

3592:
3593: PA_SCHEDULE_UTILS.log_message(1,'after select on hr_org.... ');
3594: EXCEPTION
3595: WHEN NO_DATA_FOUND THEN
3596: PA_SCHEDULE_UTILS.log_message(1,'inside no data found for select on hr_org.... ');
3597: l_no_calendar_at_org := TRUE;
3598: WHEN OTHERS THEN
3599: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on hr_org.... '||sqlerrm);
3600: RAISE;

Line 3599: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on hr_org.... '||sqlerrm);

3595: WHEN NO_DATA_FOUND THEN
3596: PA_SCHEDULE_UTILS.log_message(1,'inside no data found for select on hr_org.... ');
3597: l_no_calendar_at_org := TRUE;
3598: WHEN OTHERS THEN
3599: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on hr_org.... '||sqlerrm);
3600: RAISE;
3601: END;
3602:
3603: -- If no calendar is associated with the organization the we will take the calendar which will be

Line 3617: PA_SCHEDULE_UTILS.log_message(1,'calendar_id '||l_temp_calendar_id);

3613: x_calendar_id := null;
3614: x_calendar_name := null;
3615: /* Code Addition for bug 2873984 ends */
3616: ELSE
3617: PA_SCHEDULE_UTILS.log_message(1,'calendar_id '||l_temp_calendar_id);
3618: BEGIN
3619: SELECT
3620: calendar_name
3621: INTO x_calendar_name

Line 3629: PA_SCHEDULE_UTILS.log_message(1,'Not a valid calendar assigned to profile option ');

3625: x_calendar_id := TO_NUMBER(l_temp_calendar_id);
3626: EXCEPTION
3627: WHEN NO_DATA_FOUND THEN
3628: x_msg_data := 'Not a valid calendar assigned to profile option ';
3629: PA_SCHEDULE_UTILS.log_message(1,'Not a valid calendar assigned to profile option ');
3630: RAISE l_invalid_default_calendar;
3631: WHEN OTHERS THEN
3632: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on jtf_calendars_vl.... '||sqlerrm);
3633: RAISE;

Line 3632: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on jtf_calendars_vl.... '||sqlerrm);

3628: x_msg_data := 'Not a valid calendar assigned to profile option ';
3629: PA_SCHEDULE_UTILS.log_message(1,'Not a valid calendar assigned to profile option ');
3630: RAISE l_invalid_default_calendar;
3631: WHEN OTHERS THEN
3632: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on jtf_calendars_vl.... '||sqlerrm);
3633: RAISE;
3634: END;
3635:
3636: END IF;

Line 3639: PA_SCHEDULE_UTILS.log_message(1,'End of the get_proj_calendar_default API ... ');

3635:
3636: END IF;
3637: END IF;
3638:
3639: PA_SCHEDULE_UTILS.log_message(1,'End of the get_proj_calendar_default API ... ');
3640: x_return_status := l_x_return_status;
3641:
3642: EXCEPTION
3643: WHEN l_invalid_default_calendar THEN

Line 3644: PA_SCHEDULE_UTILS.log_message(1,'ERROR: invalid calendar id at profile option ..');

3640: x_return_status := l_x_return_status;
3641:
3642: EXCEPTION
3643: WHEN l_invalid_default_calendar THEN
3644: PA_SCHEDULE_UTILS.log_message(1,'ERROR: invalid calendar id at profile option ..');
3645: PA_UTILS.add_message('PA','PA_INVALID_PROFILE_CALENDAR_ID');
3646: x_return_status := FND_API.G_RET_STS_ERROR;
3647: x_msg_data := 'PA_INVALID_PROFILE_CALENDAR_ID';
3648: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 3665: PA_SCHEDULE_UTILS.log_message(1,'ERROR: Null calendar id at profile option ..');

3661: p_msg_index_out => l_msg_index_out );
3662: x_msg_data := l_data ; -- 4537865
3663: End If;
3664: WHEN l_null_default_calendar THEN
3665: PA_SCHEDULE_UTILS.log_message(1,'ERROR: Null calendar id at profile option ..');
3666: PA_UTILS.add_message('PA','PA_INVALID_PROFILE_CALENDAR_ID');
3667: x_return_status := FND_API.G_RET_STS_ERROR;
3668: x_msg_data := 'PA_NULL_PROFILE_CALENDAR_ID';
3669: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 3686: PA_SCHEDULE_UTILS.log_message(1,'ERROR in get_proj_calendar_default API ..'||sqlerrm);

3682: p_msg_index_out => l_msg_index_out );
3683: x_msg_data := l_data ; -- 4537865
3684: End If;
3685: WHEN OTHERS THEN
3686: PA_SCHEDULE_UTILS.log_message(1,'ERROR in get_proj_calendar_default API ..'||sqlerrm);
3687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3688: x_msg_count := 1;
3689: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : CHANGd substr to substrb
3690:

Line 3797: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');

3793:
3794: -- Creating new schedule for the Calendar Id */
3795: PA_SCHEDULE_PUB.create_calendar_schedule(v_c1.calendar_id,l_x_return_status,x_msg_count,x_msg_data);
3796:
3797: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');
3798: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
3799: PA_TIMELINE_PVT.Create_Timeline (p_calendar_id =>v_c1.calendar_id,
3800: x_return_status =>l_x_return_status,
3801: x_msg_count =>x_msg_count,

Line 3866: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_cal_schedules API ..'|| sqlerrm);

3862: -- End of 2843435
3863: WHEN NO_DATA_FOUND THEN
3864: NULL;
3865: WHEN OTHERS THEN
3866: PA_SCHEDULE_UTILS.log_message(1,'ERROR in create_new_cal_schedules API ..'|| sqlerrm);
3867: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3868: x_msg_count := 1;
3869: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Changed substrb to substr
3870: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

Line 3981: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');

3977: p_end_date := p_start_date+13;
3978:
3979: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY'); --Added for bug 4068167
3980:
3981: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3982: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3983: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3984: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);

Line 3982: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');

3978:
3979: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY'); --Added for bug 4068167
3980:
3981: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3982: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3983: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3984: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);

Line 3983: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);

3979: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY'); --Added for bug 4068167
3980:
3981: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3982: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3983: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3984: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);

Line 3984: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);

3980:
3981: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3982: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3983: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3984: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);

Line 3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);

3981: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3982: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3983: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3984: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);

Line 3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);

3982: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3983: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3984: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);

Line 3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);

3983: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3984: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);

Line 3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);

3984: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3992: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);

Line 3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);

3985: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3992: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3993: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);

Line 3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);

3986: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3992: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3993: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3994: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);

Line 3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);

3987: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3992: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3993: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3994: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3995: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167

Line 3992: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);

3988: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3992: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3993: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3994: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3995: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167
3996:

Line 3993: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);

3989: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3992: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3993: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3994: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3995: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167
3996:
3997: -- Initialize the out date variables, so that if changes are not required then no need to call

Line 3994: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);

3990: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3992: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3993: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3994: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3995: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167
3996:
3997: -- Initialize the out date variables, so that if changes are not required then no need to call
3998: -- create_forecast_items

Line 3995: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167

3991: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3992: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3993: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3994: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3995: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167
3996:
3997: -- Initialize the out date variables, so that if changes are not required then no need to call
3998: -- create_forecast_items
3999:

Line 4005: PA_SCHEDULE_UTILS.log_message(1,'p_start_date and p_end_date is wrongly passed');

4001: x_call_timeline_end_date := null;
4002: x_return_status := FND_API.G_RET_STS_SUCCESS;
4003:
4004: IF ((p_end_date - p_start_date <> 13) OR (p_end_date < p_start_date)) THEN
4005: PA_SCHEDULE_UTILS.log_message(1,'p_start_date and p_end_date is wrongly passed');
4006: raise API_ERROR;
4007: END IF;
4008:
4009: IF l_count <> 14 THEN

Line 4010: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table is not 14');

4006: raise API_ERROR;
4007: END IF;
4008:
4009: IF l_count <> 14 THEN
4010: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table is not 14');
4011: raise API_ERROR;
4012: END IF;
4013: -- Bug 3235656 : Added the below condition to show error
4014: FOR i IN p_hours_table.FIRST .. p_hours_table.LAST LOOP

Line 4027: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Begin');

4023: -- alwyas the first shown date in work pattern table and last date as p_start_date and
4024: -- p_end_date. And a table of hours p_hours_table with 14 values filled in this. These
4025: -- values may be null, 0 or any value
4026:
4027: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Begin');
4028:
4029: -- Parameters Detrmination Phase Begin : In this it will determine the following parameters
4030:
4031: -- l_actual_start_date : From which date actually changes starts in work pattern table

Line 4046: PA_SCHEDULE_UTILS.log_message(1,'Changes are Within Assignment Date Range');

4042: -- x_call_timeline_end_date : The end date till which timeline should be regenerated.
4043:
4044: IF ((p_start_date BETWEEN p_asgn_start_date AND p_asgn_end_date) AND (p_end_date BETWEEN p_asgn_start_date AND p_asgn_end_date)) THEN
4045: -- Changes are Within Assignment Date Range
4046: PA_SCHEDULE_UTILS.log_message(1,'Changes are Within Assignment Date Range');
4047: l_actual_start_date := p_start_date;
4048: l_actual_end_date := p_end_date;
4049: l_new_assgn_start_date := p_asgn_start_date;
4050: l_new_assgn_end_date := p_asgn_end_date;

Line 4065: PA_SCHEDULE_UTILS.log_message(1,'Moving Backward Totally outside range');

4061: END LOOP;
4062: ELSIF p_end_date < p_asgn_start_date THEN
4063: -- Moving Backward Totally outside range
4064:
4065: PA_SCHEDULE_UTILS.log_message(1,'Moving Backward Totally outside range');
4066:
4067: -- Example 1 : assgn start date is 20-Oct-2003 and assgn end date is 10-Nov-2003
4068: -- p_start_date is 01-Oct-2003 and p_end_date is 14-Oct-2003
4069: -- p_hours_table has 0,null,0,8,8,8,8,8,8,8,8,8,8,8

Line 4148: PA_SCHEDULE_UTILS.log_message(1,'Moving Forward Totally outside range');

4144:
4145: ELSIF p_start_date > p_asgn_end_date THEN
4146: -- Moving Forward Totally outside range
4147:
4148: PA_SCHEDULE_UTILS.log_message(1,'Moving Forward Totally outside range');
4149:
4150: -- Example 1 : assgn start date is 20-Oct-2003 and assgn end date is 10-Nov-2003
4151: -- p_start_date is 15-Nov-2003 and p_end_date is 28-Nov-2003
4152: -- p_hours_table has 8,null,0,8,8,8,8,8,8,8,8,null,null,null

Line 4229: PA_SCHEDULE_UTILS.log_message(1,'Moving Forward Partially outside range');

4225:
4226: ELSIF (p_start_date BETWEEN p_asgn_start_date AND p_asgn_end_date) AND p_end_date > p_asgn_end_date THEN
4227: -- Moving Forward Partially outside range
4228:
4229: PA_SCHEDULE_UTILS.log_message(1,'Moving Forward Partially outside range');
4230:
4231: --Changes are done, now further it needs to be determined that whether work pattern has changed or not
4232: l_changes_done := true;
4233: l_actual_start_date := p_start_date;

Line 4272: PA_SCHEDULE_UTILS.log_message(1,'Moving Backward Partially outside range');

4268: END LOOP;
4269: ELSIF (p_end_date BETWEEN p_asgn_start_date AND p_asgn_end_date) AND p_start_date < p_asgn_start_date THEN
4270: -- Moving Backward Partially outside range
4271:
4272: PA_SCHEDULE_UTILS.log_message(1,'Moving Backward Partially outside range');
4273:
4274: --Changes are done, now further it needs to be determined that whether work pattern has changed or not
4275: l_changes_done := true;
4276: l_actual_end_date := p_end_date;

Line 4315: PA_SCHEDULE_UTILS.log_message(1,'Moving Partially Backward and Forward Both outside range');

4311: END LOOP;
4312: ELSIF ((p_asgn_start_date BETWEEN p_start_date AND p_end_date) AND (p_asgn_end_date BETWEEN p_start_date AND p_end_date)) THEN
4313: -- Moving Partially Backward and Forward Both outside range
4314:
4315: PA_SCHEDULE_UTILS.log_message(1,'Moving Partially Backward and Forward Both outside range');
4316:
4317: --Changes are done, now further it needs to be determined that whether work pattern has changed or not
4318: l_changes_done := true;
4319: l_actual_end_date := p_end_date;

Line 4380: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');

4376:
4377: END IF; --(p_start_date BETWEEN p_asgn_start_date AND p_asgn_end_date) AND (p_end_date BETWEEN p_asgn_start_date AND p_asgn_end_date)) THEN
4378:
4379: -- Parameters Detrmination Phase Ends
4380: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
4381: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
4382: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
4383: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
4384: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);

Line 4381: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');

4377: END IF; --(p_start_date BETWEEN p_asgn_start_date AND p_asgn_end_date) AND (p_end_date BETWEEN p_asgn_start_date AND p_asgn_end_date)) THEN
4378:
4379: -- Parameters Detrmination Phase Ends
4380: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
4381: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
4382: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
4383: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
4384: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4385: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);

Line 4382: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);

4378:
4379: -- Parameters Detrmination Phase Ends
4380: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
4381: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
4382: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
4383: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
4384: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4385: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4386: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);

Line 4383: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);

4379: -- Parameters Detrmination Phase Ends
4380: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
4381: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
4382: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
4383: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
4384: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4385: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4386: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
4387: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);

Line 4384: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);

4380: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
4381: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
4382: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
4383: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
4384: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4385: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4386: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
4387: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
4388:

Line 4385: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);

4381: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
4382: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
4383: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
4384: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4385: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4386: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
4387: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
4388:
4389:

Line 4386: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);

4382: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
4383: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
4384: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4385: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4386: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
4387: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
4388:
4389:
4390: IF l_changes_done THEN

Line 4387: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);

4383: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
4384: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4385: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4386: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
4387: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
4388:
4389:
4390: IF l_changes_done THEN
4391: PA_SCHEDULE_UTILS.log_message(1,'l_changes_done is true');

Line 4391: PA_SCHEDULE_UTILS.log_message(1,'l_changes_done is true');

4387: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
4388:
4389:
4390: IF l_changes_done THEN
4391: PA_SCHEDULE_UTILS.log_message(1,'l_changes_done is true');
4392:
4393: -- Initialization of hours table
4394: -- These tables will be used while calling change_work_pattern
4395:

Line 4407: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');

4403: l_sunday_hours(i):= -99;
4404: END LOOP;
4405: /*Placed the call here for the bug 3421637*/
4406: IF l_call_change_duration THEN
4407: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4408:
4409: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
4410: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4411: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);

Line 4409: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');

4405: /*Placed the call here for the bug 3421637*/
4406: IF l_call_change_duration THEN
4407: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4408:
4409: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
4410: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4411: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4412:
4413: pa_schedule_pub.change_duration(

Line 4410: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);

4406: IF l_call_change_duration THEN
4407: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4408:
4409: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
4410: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4411: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4412:
4413: pa_schedule_pub.change_duration(
4414: p_record_version_number => p_record_version_number,

Line 4411: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);

4407: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4408:
4409: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
4410: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4411: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4412:
4413: pa_schedule_pub.change_duration(
4414: p_record_version_number => p_record_version_number,
4415: p_exception_type_code => 'CHANGE_DURATION' ,

Line 4437: PA_SCHEDULE_UTILS.log_message(1,'l_call_cng_work_patt_out_range is true');

4433: END IF;
4434:
4435: -- There is a gap found, so need to fill this with 0 hours
4436: IF l_call_cng_work_patt_out_range THEN
4437: PA_SCHEDULE_UTILS.log_message(1,'l_call_cng_work_patt_out_range is true');
4438:
4439: pa_schedule_pub.change_work_pattern(
4440: p_record_version_number => p_record_version_number ,
4441: p_project_id => p_project_id ,

Line 4470: PA_SCHEDULE_UTILS.log_message(1,'Calling pa_schedule_pvt.get_assignment_schedule');

4466: END IF; -- l_call_cng_work_patt_out_range THEN
4467:
4468: END IF; -- l_call_change_duration THEN*
4469:
4470: PA_SCHEDULE_UTILS.log_message(1,'Calling pa_schedule_pvt.get_assignment_schedule');
4471:
4472: pa_schedule_pvt.get_assignment_schedule ( p_assignment_id => p_assignment_id ,
4473: p_start_date => l_actual_start_date ,
4474: p_end_date => l_actual_end_date ,

Line 4497: PA_SCHEDULE_UTILS.log_message(1,'After calling pa_schedule_pvt.get_assignment_schedule l_sch_record_tab.count='||l_sch_record_tab.count);

4493: l_sch_record_tab(1).saturday_hours := 0;
4494: l_sch_record_tab(1).sunday_hours := 0;
4495: END IF;
4496:
4497: PA_SCHEDULE_UTILS.log_message(1,'After calling pa_schedule_pvt.get_assignment_schedule l_sch_record_tab.count='||l_sch_record_tab.count);
4498:
4499: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4500: raise API_ERROR;
4501: END IF;

Line 4664: PA_SCHEDULE_UTILS.log_message(1,'After populating the monday..sunday hours tables and l_hours_db_table ');

4660: END IF; -- l_sch_record_tab(j).start_date IS NOT NULL AND l_sch_record_tab(j).end_date IS NOT NULL THEN
4661: END LOOP; -- j IN l_sch_record_tab.FIRST..l_sch_record_tab.LAST LOOP
4662: END IF; -- l_sch_record_tab.COUNT > 0 THEN
4663:
4664: PA_SCHEDULE_UTILS.log_message(1,'After populating the monday..sunday hours tables and l_hours_db_table ');
4665:
4666: -- Compare the passed hours with the database values. If no changes then no need to call change_work_pattern
4667: -- if l_call_change_duration then it means work pattern changes will be alwyas there
4668: IF l_call_change_duration = false THEN

Line 4826: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');

4822:
4823:
4824: /*Moved the below call above */
4825: /* IF l_call_change_duration THEN
4826: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4827:
4828: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
4829: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4830: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);

Line 4828: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');

4824: /*Moved the below call above */
4825: /* IF l_call_change_duration THEN
4826: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4827:
4828: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
4829: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4830: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4831:
4832: pa_schedule_pub.change_duration(

Line 4829: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);

4825: /* IF l_call_change_duration THEN
4826: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4827:
4828: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
4829: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4830: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4831:
4832: pa_schedule_pub.change_duration(
4833: p_record_version_number => p_record_version_number,

Line 4830: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);

4826: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4827:
4828: PA_SCHEDULE_UTILS.log_message(1,'Calling change_duration');
4829: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
4830: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
4831:
4832: pa_schedule_pub.change_duration(
4833: p_record_version_number => p_record_version_number,
4834: p_exception_type_code => 'CHANGE_DURATION' ,

Line 4856: PA_SCHEDULE_UTILS.log_message(1,'l_call_cng_work_patt_out_range is true');

4852: END IF;
4853:
4854: -- There is a gap found, so need to fill this with 0 hours
4855: IF l_call_cng_work_patt_out_range THEN
4856: PA_SCHEDULE_UTILS.log_message(1,'l_call_cng_work_patt_out_range is true');
4857:
4858: pa_schedule_pub.change_work_pattern(
4859: p_record_version_number => p_record_version_number ,
4860: p_project_id => p_project_id ,

Line 4891: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_work_pattern is true');

4887: END IF; -- l_call_change_duration THEN*/
4888:
4889: IF l_call_change_work_pattern THEN
4890:
4891: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_work_pattern is true');
4892: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern first time');
4893: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date1='||l_ch_work_pattern_st_date1);
4894: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date1='||l_ch_work_pattern_end_date1);
4895:

Line 4892: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern first time');

4888:
4889: IF l_call_change_work_pattern THEN
4890:
4891: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_work_pattern is true');
4892: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern first time');
4893: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date1='||l_ch_work_pattern_st_date1);
4894: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date1='||l_ch_work_pattern_end_date1);
4895:
4896: -- Call change_work_pattern for the first 7 days

Line 4893: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date1='||l_ch_work_pattern_st_date1);

4889: IF l_call_change_work_pattern THEN
4890:
4891: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_work_pattern is true');
4892: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern first time');
4893: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date1='||l_ch_work_pattern_st_date1);
4894: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date1='||l_ch_work_pattern_end_date1);
4895:
4896: -- Call change_work_pattern for the first 7 days
4897: IF l_call_second_time THEN

Line 4894: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date1='||l_ch_work_pattern_end_date1);

4890:
4891: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_work_pattern is true');
4892: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern first time');
4893: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date1='||l_ch_work_pattern_st_date1);
4894: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date1='||l_ch_work_pattern_end_date1);
4895:
4896: -- Call change_work_pattern for the first 7 days
4897: IF l_call_second_time THEN
4898: l_last_row_flag := 'N';

Line 4934: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern second time');

4930: END IF;
4931: END IF;
4932:
4933: IF l_call_second_time THEN
4934: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern second time');
4935: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date2='||l_ch_work_pattern_st_date2);
4936: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date2='||l_ch_work_pattern_end_date2);
4937:
4938: pa_schedule_pub.change_work_pattern(

Line 4935: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date2='||l_ch_work_pattern_st_date2);

4931: END IF;
4932:
4933: IF l_call_second_time THEN
4934: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern second time');
4935: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date2='||l_ch_work_pattern_st_date2);
4936: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date2='||l_ch_work_pattern_end_date2);
4937:
4938: pa_schedule_pub.change_work_pattern(
4939: p_record_version_number => p_record_version_number ,

Line 4936: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date2='||l_ch_work_pattern_end_date2);

4932:
4933: IF l_call_second_time THEN
4934: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern second time');
4935: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date2='||l_ch_work_pattern_st_date2);
4936: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date2='||l_ch_work_pattern_end_date2);
4937:
4938: pa_schedule_pub.change_work_pattern(
4939: p_record_version_number => p_record_version_number ,
4940: p_project_id => p_project_id ,

Line 4997: PA_SCHEDULE_UTILS.log_message(1,'End of change_work_pattern_duration');

4993: IF p_prev_call_timeline_end_date IS NOT NULL AND p_prev_call_timeline_end_date > NVL(x_call_timeline_end_date, p_prev_call_timeline_end_date-1) THEN
4994: x_call_timeline_end_date := p_prev_call_timeline_end_date;
4995: END IF;
4996:
4997: PA_SCHEDULE_UTILS.log_message(1,'End of change_work_pattern_duration');
4998:
4999: -- Note : The calling environment should call the following API if x_call_timeline_st_date and x_call_timeline_end_date is not null
5000: -- PA_FORECASTITEM_PVT.Create_Forecast_Item (
5001: -- p_resource_id => p_resource_id,

Line 5028: PA_SCHEDULE_UTILS.log_message(1,'User Defined Exception in change_work_pattern_duration API ..');

5024: p_data => x_msg_data,
5025: p_msg_index_out => l_msg_index_out );
5026: END IF;
5027: WHEN API_ERROR THEN
5028: PA_SCHEDULE_UTILS.log_message(1,'User Defined Exception in change_work_pattern_duration API ..');
5029: x_return_status := 'E';
5030: IF x_msg_count = 0 THEN
5031: x_msg_count := 1;
5032: x_msg_data := 'User Defined Exception in change_work_pattern_duration API ..';

Line 5053: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern_duration API ..'|| sqlerrm);

5049: x_msg_data := l_data ; -- 4537865
5050: END IF;
5051:
5052: WHEN OTHERS THEN
5053: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_work_pattern_duration API ..'|| sqlerrm);
5054: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5055: x_msg_count := 1;
5056: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : Chnaged substr to substrb
5057: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_PUB',

Line 5222: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');

5218: ORDER BY resource_id, assignment_id, item_date, forecast_item_type desc;
5219:
5220: BEGIN
5221: FND_MSG_PUB.initialize;
5222: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
5223: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
5224: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
5226: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);

Line 5223: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');

5219:
5220: BEGIN
5221: FND_MSG_PUB.initialize;
5222: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
5223: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
5224: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
5226: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
5227: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);

Line 5224: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);

5220: BEGIN
5221: FND_MSG_PUB.initialize;
5222: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
5223: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
5224: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
5226: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
5227: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
5228: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);

Line 5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);

5221: FND_MSG_PUB.initialize;
5222: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
5223: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
5224: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
5226: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
5227: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
5228: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
5229: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);

Line 5226: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);

5222: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
5223: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
5224: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
5226: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
5227: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
5228: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
5229: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);
5230:

Line 5227: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);

5223: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
5224: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
5226: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
5227: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
5228: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
5229: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);
5230:
5231:

Line 5228: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);

5224: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
5226: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
5227: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
5228: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
5229: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);
5230:
5231:
5232: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5229: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);

5225: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
5226: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
5227: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
5228: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
5229: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);
5230:
5231:
5232: x_return_status := FND_API.G_RET_STS_SUCCESS;
5233: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY');

Line 5300: PA_SCHEDULE_UTILS.log_message(1,'Initialization Begin');

5296: -- After the initialization part, it fethes the forecast items and then loops thru this plsql table
5297: -- and populate the qty fields with respective capacity_quantity(for Capacity row) or item_quantity(for assignment rows).
5298:
5299: -- Initialization Part Begin
5300: PA_SCHEDULE_UTILS.log_message(1,'Initialization Begin');
5301:
5302: BEGIN
5303: SELECT meaning into l_capacity_label from pa_lookups where lookup_type='PA_CAPC_AVL_LABELS' and lookup_code ='CAPACITY';
5304: SELECT meaning into l_availability_label from pa_lookups where lookup_type='PA_CAPC_AVL_LABELS' and lookup_code ='AVAILABILITY';

Line 5594: PA_SCHEDULE_UTILS.log_message(1,'Initialization End');

5590: END LOOP; -- l_asgn IN c_assignments
5591: END LOOP; -- l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST
5592:
5593: -- Initialization Part End
5594: PA_SCHEDULE_UTILS.log_message(1,'Initialization End');
5595:
5596: -- Now loop thru the forecast items and populate the corresponding qty fields in
5597: -- l_work_pattern_table
5598:

Line 5700: PA_SCHEDULE_UTILS.log_message(1,'Inserting data in pa_work_pattern_temp_table');

5696: END LOOP; -- j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5697: END LOOP;-- l_temp IN c_quantity_cursor(l_resource_id_tbl(i)) LOOP
5698: END LOOP;--i IN l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST LOOP
5699:
5700: PA_SCHEDULE_UTILS.log_message(1,'Inserting data in pa_work_pattern_temp_table');
5701:
5702: FOR j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5703: INSERT INTO pa_work_pattern_temp_table
5704: (

Line 5805: PA_SCHEDULE_UTILS.log_message(1,'End of Populate_work_pattern_table');

5801: l_work_pattern_table(j).l_row_type_code,
5802: l_work_pattern_table(j).l_read_only_flag) ;
5803: END LOOP;
5804:
5805: PA_SCHEDULE_UTILS.log_message(1,'End of Populate_work_pattern_table');
5806: EXCEPTION
5807: WHEN OTHERS THEN
5808: PA_SCHEDULE_UTILS.log_message(1,'ERROR in Populate_work_pattern_table API ..'|| sqlerrm);
5809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 5808: PA_SCHEDULE_UTILS.log_message(1,'ERROR in Populate_work_pattern_table API ..'|| sqlerrm);

5804:
5805: PA_SCHEDULE_UTILS.log_message(1,'End of Populate_work_pattern_table');
5806: EXCEPTION
5807: WHEN OTHERS THEN
5808: PA_SCHEDULE_UTILS.log_message(1,'ERROR in Populate_work_pattern_table API ..'|| sqlerrm);
5809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5810: x_msg_count := 1;
5811: x_msg_data := substrb(SQLERRM,1,240); -- 4537865
5812: -- RESET x_show_start_date also