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_UTILS

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 128: PA_SCHEDULE_UTILS.validate_date_range (p_change_start_date, p_change_end_date, l_x_return_status, l_err_msg_code);

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

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 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 1140: PA_SCHEDULE_UTILS.log_message(1,'Validate that resource is valid for new start date?');

1136:
1137: --
1138: -- Validate that resource is valid for new start date
1139: --
1140: PA_SCHEDULE_UTILS.log_message(1,'Validate that resource is valid for new start date?');
1141: IF p_assignment_type <> 'OPEN_ASSIGNMENT' THEN
1142: PA_SCHEDULE_UTILS.log_message(1,'Validating resource');
1143: -- Get resource source id for assignment
1144: OPEN get_resource_source_id;

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

1138: -- Validate that resource is valid for new start date
1139: --
1140: PA_SCHEDULE_UTILS.log_message(1,'Validate that resource is valid for new start date?');
1141: IF p_assignment_type <> 'OPEN_ASSIGNMENT' THEN
1142: PA_SCHEDULE_UTILS.log_message(1,'Validating resource');
1143: -- Get resource source id for assignment
1144: OPEN get_resource_source_id;
1145: FETCH get_resource_source_id INTO l_resource_source_id, l_resource_id;
1146: CLOSE get_resource_source_id;

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

1157: ,x_return_status => l_x_return_status
1158: ,x_error_message_code => l_error_message_code);
1159:
1160: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1161: PA_SCHEDULE_UTILS.log_message(1,'Resource dates are not valid');
1162: Raise l_resource_out_of_range;
1163: ELSE -- IF if l_x_return_status is success : 4537865
1164: l_resource_source_id := l_new_resource_id ;
1165: END IF;

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

1163: ELSE -- IF if l_x_return_status is success : 4537865
1164: l_resource_source_id := l_new_resource_id ;
1165: END IF;
1166:
1167: PA_SCHEDULE_UTILS.log_message(1,'Resource dates are valid');
1168:
1169: -- Check if resource is assigned to a valid organization
1170: PA_RESOURCE_UTILS.check_cc_for_resource(p_resource_id => l_resource_id,
1171: p_project_id => p_project_id,

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

1175: x_return_status => l_x_return_status,
1176: x_error_message_code => l_error_message_code);
1177:
1178: IF (l_x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1179: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is not valid: u');
1180: Raise l_resource_cc_error_u;
1181: END IF;
1182:
1183: IF l_cc_ok <> 'Y' THEN

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

1180: Raise l_resource_cc_error_u;
1181: END IF;
1182:
1183: IF l_cc_ok <> 'Y' THEN
1184: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is not valid: e');
1185: Raise l_resource_cc_error_e;
1186: END IF;
1187:
1188: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is valid');

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

1184: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is not valid: e');
1185: Raise l_resource_cc_error_e;
1186: END IF;
1187:
1188: PA_SCHEDULE_UTILS.log_message(1,'Resource cc is valid');
1189:
1190: -- Make sure duration change does not cause existing actuals to
1191: -- be out of range.
1192: -- 2797890: Added parameter p_project_id, p_person_id.

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

1209:
1210: --
1211: -- Insert row to PA_SCHEDULE_EXCEPTIONS
1212: --
1213: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_duration API ..... ');
1214: PA_SCH_EXCEPT_PKG.Insert_Rows(
1215: p_calendar_id => p_calendar_id
1216: ,p_assignment_id => p_assignment_id
1217: ,p_project_id => p_project_id

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

1268: --
1269: -- Exception Handling
1270: --
1271: ----------------------------------------------------------------------
1272: PA_SCHEDULE_UTILS.log_message(1,'End of the change_duration API ..... ');
1273: x_return_status := l_x_return_status;
1274:
1275: x_msg_count := FND_MSG_PUB.Count_Msg;
1276: If x_msg_count = 1 THEN

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

1429: p_msg_index_out => l_msg_index_out );
1430: x_msg_data := l_data; -- 4537865 : NOCOPY related change
1431: End If;
1432: WHEN OTHERS THEN
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',

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

1530: (p_end_date NOT BETWEEN p_asgn_start_date AND p_asgn_end_date )) THEN
1531: Raise l_out_of_range_date;
1532: END IF;
1533:
1534: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_hours API ... ');
1535:
1536: PA_SCH_EXCEPT_PKG.Insert_Rows(
1537: p_calendar_id => p_calendar_id ,
1538: p_assignment_id => p_assignment_id ,

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

1572: x_msg_count => x_msg_count,
1573: x_msg_data => x_msg_data);
1574: END IF;
1575:
1576: PA_SCHEDULE_UTILS.log_message(1,'End of the change_hours API ... ');
1577: x_return_status := l_x_return_status;
1578: x_msg_count := FND_MSG_PUB.Count_Msg;
1579: If x_msg_count = 1 THEN
1580: pa_interface_utils_pub.get_messages

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

1604: p_msg_index_out => l_msg_index_out );
1605: x_msg_data := l_data ; -- 4537865 : NOCOPY related Change
1606: End If;
1607: WHEN OTHERS THEN
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',

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

1717: (p_end_date NOT BETWEEN p_asgn_start_date AND p_asgn_end_date )) THEN
1718: RAISE l_out_of_range_date;
1719: END IF;
1720:
1721: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern API ... ');
1722:
1723: l_p_monday_hours := p_monday_hours;
1724: l_p_tuesday_hours := p_tuesday_hours;
1725: l_p_wednesday_hours := p_wednesday_hours;

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 1839: PA_SCHEDULE_UTILS.log_message(1,'End of the change_work_pattern API ... ');

1835: x_msg_count => x_msg_count,
1836: x_msg_data => x_msg_data);
1837: END IF;
1838:
1839: PA_SCHEDULE_UTILS.log_message(1,'End of the change_work_pattern API ... ');
1840: x_return_status := l_x_return_status;
1841:
1842: x_msg_count := FND_MSG_PUB.Count_Msg;
1843: If x_msg_count = 1 THEN

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

1868: p_msg_index_out => l_msg_index_out );
1869: x_msg_data := l_data ; -- 4537865 : NOCOPY related change
1870: End If;
1871: WHEN OTHERS THEN
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',

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

1981: l_a_an_text := FND_MESSAGE.GET_STRING('PA','PA_AN_TEXT');
1982: l_asgn_req_poss_text := FND_MESSAGE.GET_STRING('PA','PA_ASSIGNMENT_POSS_TEXT');
1983: END IF;
1984:
1985: PA_SCHEDULE_UTILS.log_message(1,'Start of Change_Status ... ');
1986:
1987: -- p_assignment_status_code should not be null
1988: IF (p_assignment_status_code is NULL) THEN
1989: PA_UTILS.Add_Message ('PA', 'PA_SCH_ASGN_STATUS_NULL'); -- is this message okay?

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

2028: else
2029: l_status_type := p_status_type;
2030: end if;
2031:
2032: PA_SCHEDULE_UTILS.log_message(1,'Calling Assignment API ... ');
2033:
2034: -- Partially cancelled assignments are now possible, so we are removing the
2035: -- check.
2036:

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

2058: -- END IF;
2059: -- END IF;
2060: -- */
2061:
2062: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_status API ... ');
2063: PA_SCH_EXCEPT_PKG.Insert_Rows(
2064: p_calendar_id => p_calendar_id ,
2065: p_assignment_id => p_assignment_id ,
2066: p_project_id => p_project_id ,

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

2088: x_msg_count => x_msg_count,
2089: x_msg_data => x_msg_data);
2090: END IF;
2091:
2092: PA_SCHEDULE_UTILS.log_message(1,'End of the change_status API ... ');
2093: x_return_status := l_x_return_status;
2094:
2095: x_msg_count := FND_MSG_PUB.Count_Msg;
2096: If x_msg_count = 1 THEN

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

2188: WHEN OTHERS THEN
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

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

2303: ELSE
2304: l_calendar_id := p_calendar_id;
2305: END IF;
2306:
2307: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_calendar API ... ');
2308: PA_SCH_EXCEPT_PKG.Insert_Rows(
2309: p_calendar_id => l_calendar_id ,
2310: p_assignment_id => p_assignment_id ,
2311: p_project_id => p_project_id ,

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

2330: x_msg_count => x_msg_count,
2331: x_msg_data => x_msg_data);
2332: END IF;
2333:
2334: PA_SCHEDULE_UTILS.log_message(1,'End of the change_calendar API ... ');
2335: x_return_status := l_x_return_status;
2336:
2337: x_msg_count := FND_MSG_PUB.Count_Msg;
2338: If x_msg_count = 1 THEN

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

2378: p_msg_index_out => l_msg_index_out );
2379: x_msg_data := l_data ; -- 4537865 : NOCOPY related change
2380: End If;
2381: WHEN OTHERS THEN
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',

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

2420: BEGIN
2421: -- store the status success to track the error
2422: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
2423:
2424: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_schedule API ... ');
2425:
2426: FOR rec_sch_excp IN csr_sch_excp LOOP
2427: PA_SCHEDULE_UTILS.log_message(1,
2428: 'Schedule Exception table - assignment Id :'||

Line 2427: PA_SCHEDULE_UTILS.log_message(1,

2423:
2424: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_schedule API ... ');
2425:
2426: FOR rec_sch_excp IN csr_sch_excp LOOP
2427: PA_SCHEDULE_UTILS.log_message(1,
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

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

2437: x_return_status => l_x_return_status,
2438: x_msg_count => x_msg_count,
2439: x_msg_data => x_msg_data);
2440: END LOOP;
2441: PA_SCHEDULE_UTILS.log_message(1,'End of the change_schedule API ... ');
2442:
2443: x_return_status := l_x_return_status;
2444:
2445: x_msg_count := FND_MSG_PUB.Count_Msg;

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

2455: End If;
2456:
2457: EXCEPTION
2458: WHEN OTHERS THEN
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',

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

2570:
2571: BEGIN
2572: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
2573:
2574: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_asgn_schedule API ... ');
2575:
2576: -- Unilog Begin
2577: l_save_to_hist := p_save_to_hist;
2578: IF p_generate_timeline_flag = 'N' THEN -- It means it is called from WeeklySchedule

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

2614:
2615:
2616: l_apply_schedule_changes := FALSE;
2617:
2618: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API get_assignment_schedule ....');
2619:
2620: -- Calling the PVT API This api will bring the asignment schedule for the passed
2621: -- asignment id and it will store the schedule in tabel of record i.e l_tr_sch_rec_tab.
2622: PA_SCHEDULE_PVT.get_assignment_schedule(p_assignment_id,

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

2624: l_x_return_status,
2625: x_msg_count,
2626: x_msg_data );
2627:
2628: PA_SCHEDULE_UTILS.log_message(1,'START ASSG SCHEDULE ',l_tr_sch_rec_tab );
2629: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API get_assignment_schedule ....');
2630:
2631: l_I := 1;
2632:

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

2625: x_msg_count,
2626: x_msg_data );
2627:
2628: PA_SCHEDULE_UTILS.log_message(1,'START ASSG SCHEDULE ',l_tr_sch_rec_tab );
2629: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API get_assignment_schedule ....');
2630:
2631: l_I := 1;
2632:
2633: -- Copying the exceptions of the given assignment

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

2685: l_sch_except_rec.Sunday_hours := rec_sch_excp.sunday_hours;
2686:
2687:
2688: IF (l_I > 1) THEN
2689: PA_SCHEDULE_UTILS.log_message(1,'Index Value :' || to_char(l_i));
2690: l_tr_sch_rec_tab.delete;
2691:
2692:
2693: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

Line 2695: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(

2691:
2692:
2693: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2694: -- This procedure will copy the schedule record from one table of record to another
2695: PA_SCHEDULE_UTILS.copy_schedule_rec_tab(
2696: l_chg_tr_sch_rec_tab,
2697: l_chg_tr_sch_rec_tab.first,
2698: l_chg_tr_sch_rec_tab.last,
2699: l_tr_sch_rec_tab,

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

2702: x_msg_data
2703: );
2704: END IF;
2705:
2706: PA_SCHEDULE_UTILS.log_message(1,'after copy schedule : ',l_tr_sch_rec_tab );
2707: END IF;
2708:
2709: IF (rec_sch_excp.exception_type_code = 'CHANGE_DURATION' OR
2710: rec_sch_excp.exception_type_code = 'SHIFT_DURATION') then

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

2722: l_new_start_date := l_sch_except_rec.start_date;
2723: l_new_end_date := l_sch_except_rec.end_date;
2724: END IF;
2725:
2726: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ',l_out_tr_sch_rec_tab );
2727: ELSE
2728:
2729: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ' );
2730:

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

2725:
2726: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ',l_out_tr_sch_rec_tab );
2727: ELSE
2728:
2729: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ' );
2730:
2731: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2732: -- calling PVT API that will apply the changes
2733: PA_SCHEDULE_UTILS.log_message (1,' IN THE ELSE PART AND starting of apply other changes ');

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

2729: PA_SCHEDULE_UTILS.log_message(1,'after change_duration : ' );
2730:
2731: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2732: -- calling PVT API that will apply the changes
2733: PA_SCHEDULE_UTILS.log_message (1,' IN THE ELSE PART AND starting of apply other changes ');
2734: PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes1 :', l_tr_sch_rec_tab);
2735: --PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes2 :', l_sch_except_rec);
2736: PA_SCHEDULE_PVT.apply_other_changes(l_tr_sch_rec_tab,
2737: l_sch_except_rec,

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

2730:
2731: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2732: -- calling PVT API that will apply the changes
2733: PA_SCHEDULE_UTILS.log_message (1,' IN THE ELSE PART AND starting of apply other changes ');
2734: PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes1 :', l_tr_sch_rec_tab);
2735: --PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes2 :', l_sch_except_rec);
2736: PA_SCHEDULE_PVT.apply_other_changes(l_tr_sch_rec_tab,
2737: l_sch_except_rec,
2738: l_out_tr_sch_rec_tab,

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

2731: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2732: -- calling PVT API that will apply the changes
2733: PA_SCHEDULE_UTILS.log_message (1,' IN THE ELSE PART AND starting of apply other changes ');
2734: PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes1 :', l_tr_sch_rec_tab);
2735: --PA_SCHEDULE_UTILS.log_message(1, 'Calling apply_other_changes2 :', l_sch_except_rec);
2736: PA_SCHEDULE_PVT.apply_other_changes(l_tr_sch_rec_tab,
2737: l_sch_except_rec,
2738: l_out_tr_sch_rec_tab,
2739: l_x_return_status,

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

2741: x_msg_data
2742: );
2743: END IF;
2744:
2745: PA_SCHEDULE_UTILS.log_message(1,'after change_others : ',l_out_tr_sch_rec_tab );
2746: END IF;
2747:
2748: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2749: -- seperating the deleted or non deleted record i.e inserted or updated

Line 2750: PA_SCHEDULE_UTILS.sep_del_sch_rec_tab(l_out_tr_sch_rec_tab,

2746: END IF;
2747:
2748: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2749: -- seperating the deleted or non deleted record i.e inserted or updated
2750: PA_SCHEDULE_UTILS.sep_del_sch_rec_tab(l_out_tr_sch_rec_tab,
2751: l_del_tr_sch_rec_tab,
2752: l_chg_tr_sch_rec_tab,
2753: l_x_return_status,
2754: x_msg_count,

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

2757: END IF;
2758:
2759: l_I := l_I + 1;
2760:
2761: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (change ) : ',l_chg_tr_sch_rec_tab );
2762: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (delete ) : ',l_del_tr_sch_rec_tab );
2763:
2764: END LOOP;
2765:

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

2758:
2759: l_I := l_I + 1;
2760:
2761: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (change ) : ',l_chg_tr_sch_rec_tab );
2762: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (delete ) : ',l_del_tr_sch_rec_tab );
2763:
2764: END LOOP;
2765:
2766: PA_SCHEDULE_UTILS.log_message(1,'FINAL (change ) : ',l_chg_tr_sch_rec_tab );

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

2762: PA_SCHEDULE_UTILS.log_message(1,'after delete seperate (delete ) : ',l_del_tr_sch_rec_tab );
2763:
2764: END LOOP;
2765:
2766: PA_SCHEDULE_UTILS.log_message(1,'FINAL (change ) : ',l_chg_tr_sch_rec_tab );
2767: PA_SCHEDULE_UTILS.log_message(1,'FINAL (delete ) : ',l_del_tr_sch_rec_tab );
2768:
2769: IF ( l_apply_schedule_changes ) THEN
2770:

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

2763:
2764: END LOOP;
2765:
2766: PA_SCHEDULE_UTILS.log_message(1,'FINAL (change ) : ',l_chg_tr_sch_rec_tab );
2767: PA_SCHEDULE_UTILS.log_message(1,'FINAL (delete ) : ',l_del_tr_sch_rec_tab );
2768:
2769: IF ( l_apply_schedule_changes ) THEN
2770:
2771: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API apply_schedule_change ....');

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

2767: PA_SCHEDULE_UTILS.log_message(1,'FINAL (delete ) : ',l_del_tr_sch_rec_tab );
2768:
2769: IF ( l_apply_schedule_changes ) THEN
2770:
2771: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API apply_schedule_change ....');
2772:
2773: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2774: -- Calling the PVT api that will change the schedule
2775: PA_SCHEDULE_PVT.apply_schedule_change(l_chg_tr_sch_rec_tab,

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

2778: x_msg_count,
2779: x_msg_data);
2780: END IF;
2781:
2782: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API apply_schedule_change ....');
2783:
2784: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2785: -- Calling the API PA_SCHEDULE_PVT.apply_assignment_change
2786:

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

2807: x_msg_count => x_msg_count,
2808: x_msg_data => x_msg_data);
2809: END IF;
2810:
2811: PA_SCHEDULE_UTILS.log_message(1, 'Before Calling the API delete_rows ....');
2812:
2813: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2814: -- Deleting the rows from pa_schedule_exception table
2815: PA_SCH_EXCEPT_PKG.delete_rows(l_sch_except_record_tab,

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

2818: x_msg_data
2819: );
2820: END IF;
2821:
2822: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API delete_rows ..');
2823:
2824: -- inserting the rows from schedule except history table
2825: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2826: IF (FND_API.TO_BOOLEAN(NVL(l_save_to_hist,FND_API.G_TRUE))) THEN

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

2833: );
2834: END IF;
2835: END IF;
2836:
2837: PA_SCHEDULE_UTILS.log_message(1, 'After Calling the API insert_rows ....');
2838: END IF;
2839:
2840: IF p_generate_timeline_flag = 'Y' THEN --Unilog
2841:

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

2841:
2842: -- Calling the Timeline api to create the timeline records
2843: -- for the assignment
2844: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2845: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');
2846: PA_SCHEDULE_UTILS.log_message(1, 'Num: ' || FND_MSG_PUB.Count_Msg);
2847: PA_TIMELINE_PVT.create_timeline (
2848: p_assignment_id =>p_assignment_id ,
2849: x_return_status =>l_x_return_status ,

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

2842: -- Calling the Timeline api to create the timeline records
2843: -- for the assignment
2844: IF (l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2845: PA_SCHEDULE_UTILS.log_message(1,'Calling Timeline API ..... ');
2846: PA_SCHEDULE_UTILS.log_message(1, 'Num: ' || FND_MSG_PUB.Count_Msg);
2847: PA_TIMELINE_PVT.create_timeline (
2848: p_assignment_id =>p_assignment_id ,
2849: x_return_status =>l_x_return_status ,
2850: x_msg_count =>x_msg_count ,

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

2884: END IF;
2885: END IF;
2886: END IF; -- Unilog
2887:
2888: PA_SCHEDULE_UTILS.log_message(1,'End of the change_asgn_schedule API ... ');
2889: x_return_status := l_x_return_status;
2890:
2891: x_msg_count := FND_MSG_PUB.Count_Msg;
2892:

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

2902: End If;
2903:
2904: EXCEPTION
2905: WHEN OTHERS THEN
2906: PA_SCHEDULE_UTILS.log_message(1,'ERROR in change_asgn_schedule API ..'
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

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

2943: l_x_cal_except_record_tab PA_SCHEDULE_GLOB.calExceptionTabTyp;
2944: l_msg_index_out NUMBER;
2945: l_data varchar2(2000) ;-- 4537865
2946: BEGIN
2947: PA_SCHEDULE_UTILS.log_message(1,'Start of the create_calendar_schedule API ... ');
2948: -- storing the status success to track the error
2949: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
2950:
2951: -- Calling the Calendar API that will give the shift assign to the calendar*/

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

2956: x_msg_count,x_msg_data);
2957:
2958: END IF;
2959:
2960: PA_SCHEDULE_UTILS.log_message(1,'GEN SCH ',l_schedule_rec_tab);
2961: IF ( l_x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
2962: -- Calling the PA_CALENDAR_UTILS API that will take the exception associated with the calendar
2963: PA_CALENDAR_UTILS.get_calendar_except(p_calendar_id,l_x_cal_except_record_tab,l_x_return_status,
2964: x_msg_count,x_msg_data);

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

2989: ,x_msg_data => x_msg_data
2990: );*/
2991: -- End Of Bug No : 4666318
2992:
2993: PA_SCHEDULE_UTILS.log_message(1,'End of the create_calendar_schedule API ... ');
2994:
2995: x_return_status := l_x_return_status;
2996: x_msg_count := FND_MSG_PUB.Count_Msg;
2997: If x_msg_count = 1 THEN

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

3005: x_msg_Data := l_data ;-- 4537865
3006: End If;
3007: EXCEPTION
3008: WHEN OTHERS THEN
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',

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

3053: L_MSG_INDEX_OUT NUMBER;
3054:
3055: l_data varchar2(2000); -- 4537865
3056: BEGIN
3057: PA_SCHEDULE_UTILS.log_message(1,'Start of the get_proj_calendar_default API ... ');
3058:
3059: l_x_return_status := FND_API.G_RET_STS_SUCCESS ;
3060: l_no_calendar_at_org := FALSE;
3061:

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

3060: l_no_calendar_at_org := FALSE;
3061:
3062: /* Bug2873984
3063: IF (PA_INSTALL.IS_PRM_LICENSED() <> 'Y') THEN
3064: PA_SCHEDULE_UTILS.log_message(1,'PRM is not licensed, so returning null.');
3065: x_calendar_id := null;
3066: x_calendar_name := null;
3067: x_return_status := l_x_return_status;
3068: return;

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

3067: x_return_status := l_x_return_status;
3068: return;
3069: END IF; */
3070:
3071: PA_SCHEDULE_UTILS.log_message(1,'PRM is licensed, so continuing.');
3072:
3073: -- Taking out the orgnization id for passing to the get_proj_calendar_default */
3074: IF (p_project_id IS NOT NULL ) THEN
3075: BEGIN

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

3088: l_t_carrying_out_org_id := p_proj_organization;
3089: END IF;
3090:
3091: BEGIN
3092: PA_SCHEDULE_UTILS.log_message(1,'before select on hr_org.... ');
3093:
3094: -- Taking the calendar on the basis of organization assigned to the project
3095: -- R12 changes - the calendar is now stored
3096: -- under a new information type - Resource Defaults

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

3109: AND hr1.organization_id = l_t_carrying_out_org_id
3110: --AND hr1.org_information_context = 'Exp Organization Defaults';
3111: AND hr1.org_information_context = 'Resource Defaults';
3112:
3113: PA_SCHEDULE_UTILS.log_message(1,'after select on hr_org.... ');
3114: EXCEPTION
3115: WHEN NO_DATA_FOUND THEN
3116: PA_SCHEDULE_UTILS.log_message(1,'inside no data found for select on hr_org.... ');
3117: l_no_calendar_at_org := TRUE;

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

3112:
3113: PA_SCHEDULE_UTILS.log_message(1,'after select on hr_org.... ');
3114: EXCEPTION
3115: WHEN NO_DATA_FOUND THEN
3116: PA_SCHEDULE_UTILS.log_message(1,'inside no data found for select on hr_org.... ');
3117: l_no_calendar_at_org := TRUE;
3118: WHEN OTHERS THEN
3119: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on hr_org.... '||sqlerrm);
3120: RAISE;

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

3115: WHEN NO_DATA_FOUND THEN
3116: PA_SCHEDULE_UTILS.log_message(1,'inside no data found for select on hr_org.... ');
3117: l_no_calendar_at_org := TRUE;
3118: WHEN OTHERS THEN
3119: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on hr_org.... '||sqlerrm);
3120: RAISE;
3121: END;
3122:
3123: -- If no calendar is associated with the organization the we will take the calendar which will be

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

3133: x_calendar_id := null;
3134: x_calendar_name := null;
3135: /* Code Addition for bug 2873984 ends */
3136: ELSE
3137: PA_SCHEDULE_UTILS.log_message(1,'calendar_id '||l_temp_calendar_id);
3138: BEGIN
3139: SELECT
3140: calendar_name
3141: INTO x_calendar_name

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

3145: x_calendar_id := TO_NUMBER(l_temp_calendar_id);
3146: EXCEPTION
3147: WHEN NO_DATA_FOUND THEN
3148: x_msg_data := 'Not a valid calendar assigned to profile option ';
3149: PA_SCHEDULE_UTILS.log_message(1,'Not a valid calendar assigned to profile option ');
3150: RAISE l_invalid_default_calendar;
3151: WHEN OTHERS THEN
3152: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on jtf_calendars_vl.... '||sqlerrm);
3153: RAISE;

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

3148: x_msg_data := 'Not a valid calendar assigned to profile option ';
3149: PA_SCHEDULE_UTILS.log_message(1,'Not a valid calendar assigned to profile option ');
3150: RAISE l_invalid_default_calendar;
3151: WHEN OTHERS THEN
3152: PA_SCHEDULE_UTILS.log_message(1,'ERROR while excuting select on jtf_calendars_vl.... '||sqlerrm);
3153: RAISE;
3154: END;
3155:
3156: END IF;

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

3155:
3156: END IF;
3157: END IF;
3158:
3159: PA_SCHEDULE_UTILS.log_message(1,'End of the get_proj_calendar_default API ... ');
3160: x_return_status := l_x_return_status;
3161:
3162: EXCEPTION
3163: WHEN l_invalid_default_calendar THEN

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

3160: x_return_status := l_x_return_status;
3161:
3162: EXCEPTION
3163: WHEN l_invalid_default_calendar THEN
3164: PA_SCHEDULE_UTILS.log_message(1,'ERROR: invalid calendar id at profile option ..');
3165: PA_UTILS.add_message('PA','PA_INVALID_PROFILE_CALENDAR_ID');
3166: x_return_status := FND_API.G_RET_STS_ERROR;
3167: x_msg_data := 'PA_INVALID_PROFILE_CALENDAR_ID';
3168: x_msg_count := FND_MSG_PUB.Count_Msg;

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

3181: p_msg_index_out => l_msg_index_out );
3182: x_msg_data := l_data ; -- 4537865
3183: End If;
3184: WHEN l_null_default_calendar THEN
3185: PA_SCHEDULE_UTILS.log_message(1,'ERROR: Null calendar id at profile option ..');
3186: PA_UTILS.add_message('PA','PA_INVALID_PROFILE_CALENDAR_ID');
3187: x_return_status := FND_API.G_RET_STS_ERROR;
3188: x_msg_data := 'PA_NULL_PROFILE_CALENDAR_ID';
3189: x_msg_count := FND_MSG_PUB.Count_Msg;

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

3202: p_msg_index_out => l_msg_index_out );
3203: x_msg_data := l_data ; -- 4537865
3204: End If;
3205: WHEN OTHERS THEN
3206: PA_SCHEDULE_UTILS.log_message(1,'ERROR in get_proj_calendar_default API ..'||sqlerrm);
3207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3208: x_msg_count := 1;
3209: x_msg_data := substrb(SQLERRM,1,240); -- 4537865 : CHANGd substr to substrb
3210:

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

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,
3320: x_return_status =>l_x_return_status,
3321: x_msg_count =>x_msg_count,

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

3382: -- End of 2843435
3383: WHEN NO_DATA_FOUND THEN
3384: NULL;
3385: WHEN OTHERS THEN
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',

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

3497: p_end_date := p_start_date+13;
3498:
3499: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY'); --Added for bug 4068167
3500:
3501: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3502: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3503: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3504: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3505: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);

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

3498:
3499: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY'); --Added for bug 4068167
3500:
3501: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3502: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3503: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3504: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3505: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3506: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);

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

3499: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY'); --Added for bug 4068167
3500:
3501: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3502: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3503: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3504: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3505: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3506: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3507: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);

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

3500:
3501: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3502: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3503: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3504: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3505: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3506: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3507: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3508: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);

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

3501: PA_SCHEDULE_UTILS.log_message(1,'Start of the change_work_pattern_duration API ... ');
3502: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3503: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3504: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3505: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3506: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3507: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3508: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3509: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);

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

3502: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
3503: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3504: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3505: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3506: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3507: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3508: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3509: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3510: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);

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

3503: PA_SCHEDULE_UTILS.log_message(1,'p_record_version_number='||p_record_version_number);
3504: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3505: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3506: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3507: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3508: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3509: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3510: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3511: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);

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

3504: PA_SCHEDULE_UTILS.log_message(1,'p_project_id='||p_project_id);
3505: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3506: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3507: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3508: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3509: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3510: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3511: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3512: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);

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

3505: PA_SCHEDULE_UTILS.log_message(1,'p_calendar_id='||p_calendar_id);
3506: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3507: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3508: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3509: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3510: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3511: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3512: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3513: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);

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

3506: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_id='||p_assignment_id);
3507: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3508: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3509: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3510: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3511: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3512: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3513: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3514: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);

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

3507: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id='||p_resource_id);
3508: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3509: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3510: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3511: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3512: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3513: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3514: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3515: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167

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

3508: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_type='||p_assignment_type);
3509: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3510: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3511: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3512: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3513: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3514: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3515: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167
3516:

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

3509: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_start_date='||p_asgn_start_date);
3510: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3511: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3512: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3513: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3514: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3515: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167
3516:
3517: -- Initialize the out date variables, so that if changes are not required then no need to call

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

3510: PA_SCHEDULE_UTILS.log_message(1,'p_asgn_end_date='||p_asgn_end_date);
3511: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3512: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3513: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3514: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3515: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167
3516:
3517: -- Initialize the out date variables, so that if changes are not required then no need to call
3518: -- create_forecast_items

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

3511: PA_SCHEDULE_UTILS.log_message(1,'p_start_date='||p_start_date);
3512: PA_SCHEDULE_UTILS.log_message(1,'p_end_date='||p_end_date);
3513: PA_SCHEDULE_UTILS.log_message(1,'p_assignment_status_code='||p_assignment_status_code);
3514: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table='||l_count);
3515: PA_SCHEDULE_UTILS.log_message(1,'Week start day l_global_week_start_day='||l_global_week_start_day); --Added for bug 4068167
3516:
3517: -- Initialize the out date variables, so that if changes are not required then no need to call
3518: -- create_forecast_items
3519:

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

3521: x_call_timeline_end_date := null;
3522: x_return_status := FND_API.G_RET_STS_SUCCESS;
3523:
3524: IF ((p_end_date - p_start_date <> 13) OR (p_end_date < p_start_date)) THEN
3525: PA_SCHEDULE_UTILS.log_message(1,'p_start_date and p_end_date is wrongly passed');
3526: raise API_ERROR;
3527: END IF;
3528:
3529: IF l_count <> 14 THEN

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

3526: raise API_ERROR;
3527: END IF;
3528:
3529: IF l_count <> 14 THEN
3530: PA_SCHEDULE_UTILS.log_message(1,'Number of records in p_hours_table is not 14');
3531: raise API_ERROR;
3532: END IF;
3533: -- Bug 3235656 : Added the below condition to show error
3534: FOR i IN p_hours_table.FIRST .. p_hours_table.LAST LOOP

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

3543: -- alwyas the first shown date in work pattern table and last date as p_start_date and
3544: -- p_end_date. And a table of hours p_hours_table with 14 values filled in this. These
3545: -- values may be null, 0 or any value
3546:
3547: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Begin');
3548:
3549: -- Parameters Detrmination Phase Begin : In this it will determine the following parameters
3550:
3551: -- l_actual_start_date : From which date actually changes starts in work pattern table

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

3562: -- x_call_timeline_end_date : The end date till which timeline should be regenerated.
3563:
3564: 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
3565: -- Changes are Within Assignment Date Range
3566: PA_SCHEDULE_UTILS.log_message(1,'Changes are Within Assignment Date Range');
3567: l_actual_start_date := p_start_date;
3568: l_actual_end_date := p_end_date;
3569: l_new_assgn_start_date := p_asgn_start_date;
3570: l_new_assgn_end_date := p_asgn_end_date;

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

3581: END LOOP;
3582: ELSIF p_end_date < p_asgn_start_date THEN
3583: -- Moving Backward Totally outside range
3584:
3585: PA_SCHEDULE_UTILS.log_message(1,'Moving Backward Totally outside range');
3586:
3587: -- Example 1 : assgn start date is 20-Oct-2003 and assgn end date is 10-Nov-2003
3588: -- p_start_date is 01-Oct-2003 and p_end_date is 14-Oct-2003
3589: -- p_hours_table has 0,null,0,8,8,8,8,8,8,8,8,8,8,8

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

3664:
3665: ELSIF p_start_date > p_asgn_end_date THEN
3666: -- Moving Forward Totally outside range
3667:
3668: PA_SCHEDULE_UTILS.log_message(1,'Moving Forward Totally outside range');
3669:
3670: -- Example 1 : assgn start date is 20-Oct-2003 and assgn end date is 10-Nov-2003
3671: -- p_start_date is 15-Nov-2003 and p_end_date is 28-Nov-2003
3672: -- p_hours_table has 8,null,0,8,8,8,8,8,8,8,8,null,null,null

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

3745:
3746: ELSIF (p_start_date BETWEEN p_asgn_start_date AND p_asgn_end_date) AND p_end_date > p_asgn_end_date THEN
3747: -- Moving Forward Partially outside range
3748:
3749: PA_SCHEDULE_UTILS.log_message(1,'Moving Forward Partially outside range');
3750:
3751: --Changes are done, now further it needs to be determined that whether work pattern has changed or not
3752: l_changes_done := true;
3753: l_actual_start_date := p_start_date;

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

3788: END LOOP;
3789: ELSIF (p_end_date BETWEEN p_asgn_start_date AND p_asgn_end_date) AND p_start_date < p_asgn_start_date THEN
3790: -- Moving Backward Partially outside range
3791:
3792: PA_SCHEDULE_UTILS.log_message(1,'Moving Backward Partially outside range');
3793:
3794: --Changes are done, now further it needs to be determined that whether work pattern has changed or not
3795: l_changes_done := true;
3796: l_actual_end_date := p_end_date;

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

3831: END LOOP;
3832: 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
3833: -- Moving Partially Backward and Forward Both outside range
3834:
3835: PA_SCHEDULE_UTILS.log_message(1,'Moving Partially Backward and Forward Both outside range');
3836:
3837: --Changes are done, now further it needs to be determined that whether work pattern has changed or not
3838: l_changes_done := true;
3839: l_actual_end_date := p_end_date;

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

3896:
3897: 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
3898:
3899: -- Parameters Detrmination Phase Ends
3900: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
3901: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
3902: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
3903: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
3904: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);

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

3897: 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
3898:
3899: -- Parameters Detrmination Phase Ends
3900: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
3901: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
3902: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
3903: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
3904: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
3905: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);

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

3898:
3899: -- Parameters Detrmination Phase Ends
3900: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
3901: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
3902: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
3903: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
3904: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
3905: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
3906: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);

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

3899: -- Parameters Detrmination Phase Ends
3900: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
3901: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
3902: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
3903: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
3904: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
3905: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
3906: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
3907: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);

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

3900: PA_SCHEDULE_UTILS.log_message(1,'Parameters Detrmination Phase Ends');
3901: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
3902: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
3903: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
3904: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
3905: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
3906: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
3907: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
3908:

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

3901: PA_SCHEDULE_UTILS.log_message(1,'Parameters Are ...');
3902: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
3903: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
3904: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
3905: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
3906: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
3907: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
3908:
3909:

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

3902: PA_SCHEDULE_UTILS.log_message(1,'l_actual_start_date='||l_actual_start_date);
3903: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
3904: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
3905: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
3906: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
3907: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
3908:
3909:
3910: IF l_changes_done THEN

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

3903: PA_SCHEDULE_UTILS.log_message(1,'l_actual_end_date='||l_actual_end_date);
3904: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_start_date='||l_new_assgn_start_date);
3905: PA_SCHEDULE_UTILS.log_message(1,'l_new_assgn_end_date='||l_new_assgn_end_date);
3906: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_start_date='||l_update_work_zero_start_date);
3907: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
3908:
3909:
3910: IF l_changes_done THEN
3911: PA_SCHEDULE_UTILS.log_message(1,'l_changes_done is true');

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

3907: PA_SCHEDULE_UTILS.log_message(1,'l_update_work_zero_end_date='||l_update_work_zero_end_date);
3908:
3909:
3910: IF l_changes_done THEN
3911: PA_SCHEDULE_UTILS.log_message(1,'l_changes_done is true');
3912:
3913: -- Initialization of hours table
3914: -- These tables will be used while calling change_work_pattern
3915:

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

3923: l_sunday_hours(i):= -99;
3924: END LOOP;
3925: /*Placed the call here for the bug 3421637*/
3926: IF l_call_change_duration THEN
3927: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
3928:
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);

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

3925: /*Placed the call here for the bug 3421637*/
3926: IF l_call_change_duration THEN
3927: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
3928:
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(

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

3926: IF l_call_change_duration THEN
3927: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
3928:
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,

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

3927: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
3928:
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' ,

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

3953: END IF;
3954:
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 ,

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

3986: END IF; -- l_call_cng_work_patt_out_range THEN
3987:
3988: END IF; -- l_call_change_duration THEN*
3989:
3990: PA_SCHEDULE_UTILS.log_message(1,'Calling pa_schedule_pvt.get_assignment_schedule');
3991:
3992: pa_schedule_pvt.get_assignment_schedule ( p_assignment_id => p_assignment_id ,
3993: p_start_date => l_actual_start_date ,
3994: p_end_date => l_actual_end_date ,

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

4013: l_sch_record_tab(1).saturday_hours := 0;
4014: l_sch_record_tab(1).sunday_hours := 0;
4015: END IF;
4016:
4017: PA_SCHEDULE_UTILS.log_message(1,'After calling pa_schedule_pvt.get_assignment_schedule l_sch_record_tab.count='||l_sch_record_tab.count);
4018:
4019: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4020: raise API_ERROR;
4021: END IF;

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

4180: END IF; -- l_sch_record_tab(j).start_date IS NOT NULL AND l_sch_record_tab(j).end_date IS NOT NULL THEN
4181: END LOOP; -- j IN l_sch_record_tab.FIRST..l_sch_record_tab.LAST LOOP
4182: END IF; -- l_sch_record_tab.COUNT > 0 THEN
4183:
4184: PA_SCHEDULE_UTILS.log_message(1,'After populating the monday..sunday hours tables and l_hours_db_table ');
4185:
4186: -- Compare the passed hours with the database values. If no changes then no need to call change_work_pattern
4187: -- if l_call_change_duration then it means work pattern changes will be alwyas there
4188: IF l_call_change_duration = false THEN

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

4342:
4343:
4344: /*Moved the below call above */
4345: /* IF l_call_change_duration THEN
4346: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4347:
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);

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

4344: /*Moved the below call above */
4345: /* IF l_call_change_duration THEN
4346: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4347:
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(

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

4345: /* IF l_call_change_duration THEN
4346: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4347:
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,

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

4346: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_duration is true');
4347:
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' ,

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

4372: END IF;
4373:
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 ,

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

4407: END IF; -- l_call_change_duration THEN*/
4408:
4409: IF l_call_change_work_pattern THEN
4410:
4411: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_work_pattern is true');
4412: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern first time');
4413: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date1='||l_ch_work_pattern_st_date1);
4414: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date1='||l_ch_work_pattern_end_date1);
4415:

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

4408:
4409: IF l_call_change_work_pattern THEN
4410:
4411: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_work_pattern is true');
4412: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern first time');
4413: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date1='||l_ch_work_pattern_st_date1);
4414: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date1='||l_ch_work_pattern_end_date1);
4415:
4416: -- Call change_work_pattern for the first 7 days

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

4409: IF l_call_change_work_pattern THEN
4410:
4411: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_work_pattern is true');
4412: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern first time');
4413: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date1='||l_ch_work_pattern_st_date1);
4414: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date1='||l_ch_work_pattern_end_date1);
4415:
4416: -- Call change_work_pattern for the first 7 days
4417: IF l_call_second_time THEN

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

4410:
4411: PA_SCHEDULE_UTILS.log_message(1,'l_call_change_work_pattern is true');
4412: PA_SCHEDULE_UTILS.log_message(1,'Calling change_work_pattern first time');
4413: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_st_date1='||l_ch_work_pattern_st_date1);
4414: PA_SCHEDULE_UTILS.log_message(1,'l_ch_work_pattern_end_date1='||l_ch_work_pattern_end_date1);
4415:
4416: -- Call change_work_pattern for the first 7 days
4417: IF l_call_second_time THEN
4418: l_last_row_flag := 'N';

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

4450: END IF;
4451: END IF;
4452:
4453: IF l_call_second_time THEN
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(

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

4451: END IF;
4452:
4453: IF l_call_second_time THEN
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 ,

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

4452:
4453: IF l_call_second_time THEN
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 ,

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

4513: 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
4514: x_call_timeline_end_date := p_prev_call_timeline_end_date;
4515: END IF;
4516:
4517: PA_SCHEDULE_UTILS.log_message(1,'End of change_work_pattern_duration');
4518:
4519: -- Note : The calling environment should call the following API if x_call_timeline_st_date and x_call_timeline_end_date is not null
4520: -- PA_FORECASTITEM_PVT.Create_Forecast_Item (
4521: -- p_resource_id => p_resource_id,

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

4544: p_data => x_msg_data,
4545: p_msg_index_out => l_msg_index_out );
4546: END IF;
4547: WHEN API_ERROR THEN
4548: PA_SCHEDULE_UTILS.log_message(1,'User Defined Exception in change_work_pattern_duration API ..');
4549: x_return_status := 'E';
4550: IF x_msg_count = 0 THEN
4551: x_msg_count := 1;
4552: x_msg_data := 'User Defined Exception in change_work_pattern_duration API ..';

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

4569: x_msg_data := l_data ; -- 4537865
4570: END IF;
4571:
4572: WHEN OTHERS THEN
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',

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

4738: ORDER BY resource_id, assignment_id, item_date, forecast_item_type desc;
4739:
4740: BEGIN
4741: FND_MSG_PUB.initialize;
4742: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
4743: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
4744: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
4745: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
4746: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);

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

4739:
4740: BEGIN
4741: FND_MSG_PUB.initialize;
4742: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
4743: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
4744: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
4745: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
4746: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
4747: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);

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

4740: BEGIN
4741: FND_MSG_PUB.initialize;
4742: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
4743: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
4744: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
4745: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
4746: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
4747: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
4748: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);

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

4741: FND_MSG_PUB.initialize;
4742: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
4743: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
4744: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
4745: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
4746: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
4747: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
4748: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
4749: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);

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

4742: PA_SCHEDULE_UTILS.log_message(1,'Start of the Populate_work_pattern_table API ... ');
4743: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
4744: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
4745: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
4746: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
4747: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
4748: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
4749: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);
4750:

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

4743: PA_SCHEDULE_UTILS.log_message(1,'Parameters ... ');
4744: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
4745: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
4746: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
4747: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
4748: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
4749: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);
4750:
4751:

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

4744: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_start_date='||p_assgn_range_start_date);
4745: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
4746: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
4747: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
4748: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
4749: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);
4750:
4751:
4752: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4745: PA_SCHEDULE_UTILS.log_message(1,'p_assgn_range_end_date='||p_assgn_range_end_date);
4746: PA_SCHEDULE_UTILS.log_message(1,'p_display_start_date='||p_display_start_date);
4747: PA_SCHEDULE_UTILS.log_message(1,'p_status_code='||p_status_code);
4748: PA_SCHEDULE_UTILS.log_message(1,'p_delete_flag='||p_delete_flag);
4749: PA_SCHEDULE_UTILS.log_message(1,'p_resource_id_tbl.count='||p_resource_id_tbl.count);
4750:
4751:
4752: x_return_status := FND_API.G_RET_STS_SUCCESS;
4753: l_global_week_start_day := fnd_profile.value_specific('PA_GLOBAL_WEEK_START_DAY');

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

4816: -- After the initialization part, it fethes the forecast items and then loops thru this plsql table
4817: -- and populate the qty fields with respective capacity_quantity(for Capacity row) or item_quantity(for assignment rows).
4818:
4819: -- Initialization Part Begin
4820: PA_SCHEDULE_UTILS.log_message(1,'Initialization Begin');
4821:
4822: BEGIN
4823: SELECT meaning into l_capacity_label from pa_lookups where lookup_type='PA_CAPC_AVL_LABELS' and lookup_code ='CAPACITY';
4824: SELECT meaning into l_availability_label from pa_lookups where lookup_type='PA_CAPC_AVL_LABELS' and lookup_code ='AVAILABILITY';

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

5110: END LOOP; -- l_asgn IN c_assignments
5111: END LOOP; -- l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST
5112:
5113: -- Initialization Part End
5114: PA_SCHEDULE_UTILS.log_message(1,'Initialization End');
5115:
5116: -- Now loop thru the forecast items and populate the corresponding qty fields in
5117: -- l_work_pattern_table
5118:

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

5216: END LOOP; -- j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5217: END LOOP;-- l_temp IN c_quantity_cursor(l_resource_id_tbl(i)) LOOP
5218: END LOOP;--i IN l_resource_id_tbl.FIRST .. l_resource_id_tbl.LAST LOOP
5219:
5220: PA_SCHEDULE_UTILS.log_message(1,'Inserting data in pa_work_pattern_temp_table');
5221:
5222: FOR j IN l_work_pattern_table.FIRST .. l_work_pattern_table.LAST LOOP
5223: INSERT INTO pa_work_pattern_temp_table
5224: (

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

5321: l_work_pattern_table(j).l_row_type_code,
5322: l_work_pattern_table(j).l_read_only_flag) ;
5323: END LOOP;
5324:
5325: PA_SCHEDULE_UTILS.log_message(1,'End of Populate_work_pattern_table');
5326: EXCEPTION
5327: WHEN OTHERS THEN
5328: PA_SCHEDULE_UTILS.log_message(1,'ERROR in Populate_work_pattern_table API ..'|| sqlerrm);
5329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

5324:
5325: PA_SCHEDULE_UTILS.log_message(1,'End of Populate_work_pattern_table');
5326: EXCEPTION
5327: WHEN OTHERS THEN
5328: PA_SCHEDULE_UTILS.log_message(1,'ERROR in Populate_work_pattern_table API ..'|| sqlerrm);
5329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5330: x_msg_count := 1;
5331: x_msg_data := substrb(SQLERRM,1,240); -- 4537865
5332: -- RESET x_show_start_date also