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_UTILS dependencies on PA_SCHEDULE_UTILS

Line 1: PACKAGE BODY PA_SCHEDULE_UTILS as

1: PACKAGE BODY PA_SCHEDULE_UTILS as
2: /* $Header: PARGUTLB.pls 120.2 2005/08/25 03:40:56 sunkalya noship $ */
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:

Line 79: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

75: WHEN l_empty_tab_record THEN
76: null;
77: WHEN OTHERS THEN
78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
80: p_procedure_name => 'copy_schedule_rec_tab');
81: raise;
82:
83: END copy_schedule_rec_tab;

Line 155: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

151:
152: EXCEPTION
153: WHEN OTHERS THEN
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
156: p_procedure_name => 'add_schedule_rec_tab');
157: raise;
158:
159: END add_schedule_rec_tab;

Line 202: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

198:
199: EXCEPTION
200: WHEN OTHERS THEN
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
203: p_procedure_name => 'mark_del_sch_rec_tab');
204: raise;
205:
206: END mark_del_sch_rec_tab;

Line 313: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

309: x_return_status := FND_API.G_RET_STS_SUCCESS;
310: NULL;
311: WHEN OTHERS THEN
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
314: p_procedure_name => 'sep_del_sch_rec_tab');
315: raise;
316:
317: END sep_del_sch_rec_tab;

Line 408: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

404: x_return_status := FND_API.G_RET_STS_SUCCESS;
405: NULL;
406: WHEN OTHERS THEN
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
409: p_procedure_name => 'update_sch_rec_tab');
410: raise;
411:
412:

Line 464: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461: NULL;
462: WHEN OTHERS THEN
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
465: p_procedure_name => 'apply_percentage');
466: raise;
467:
468:

Line 524: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
525: p_procedure_name => 'copy_except_record');
526: raise;
527:
528: END copy_except_record;

Line 602: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

598:
599: EXCEPTION
600: WHEN OTHERS THEN
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
603: p_procedure_name => 'update_except_record');
604: raise;
605:
606:

Line 684: IF (pa_schedule_utils.l_print_log ) then

680: IS
681: BEGIN
682: null;
683: /*
684: IF (pa_schedule_utils.l_print_log ) then
685: IF ( level1 <= 1000 ) then
686: IF ( wr_tab.count > 0 ) then
687: FOR i IN wr_tab.first..wr_tab.last LOOP
688:

Line 732: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

728:
729: EXCEPTION
730: WHEN OTHERS THEN
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
732: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
733: p_procedure_name => 'validate_date_range');
734: raise;
735:
736: END validate_date_range;

Line 816: PA_SCHEDULE_UTILS.log_message(1,'JTF Res ID: ' || l_jtf_res_id);

812: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
813: RAISE l_invalid_resource_id;
814: END IF;
815:
816: PA_SCHEDULE_UTILS.log_message(1,'JTF Res ID: ' || l_jtf_res_id);
817: PA_SCHEDULE_UTILS.log_message(1,'status ... '||x_return_status);
818:
819: -- 1965288: Work around for CRM bug (cannot create future dated resources).
820: -- If the jtf_resource_id is null, then we need to use the default

Line 817: PA_SCHEDULE_UTILS.log_message(1,'status ... '||x_return_status);

813: RAISE l_invalid_resource_id;
814: END IF;
815:
816: PA_SCHEDULE_UTILS.log_message(1,'JTF Res ID: ' || l_jtf_res_id);
817: PA_SCHEDULE_UTILS.log_message(1,'status ... '||x_return_status);
818:
819: -- 1965288: Work around for CRM bug (cannot create future dated resources).
820: -- If the jtf_resource_id is null, then we need to use the default
821: -- calendar instead of going to the jtf_cal_resource_assign table.

Line 869: PA_SCHEDULE_UTILS.log_message(1,'Start date ... '||to_char(l_temp_start_date)||to_char(p_start_date));

865: AND jtf_cal_resource_assign.calendar_id > 0
866: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
867: END IF;
868:
869: PA_SCHEDULE_UTILS.log_message(1,'Start date ... '||to_char(l_temp_start_date)||to_char(p_start_date));
870: PA_SCHEDULE_UTILS.log_message(1,'end date ... '||to_char(l_temp_end_date)||to_char(p_end_date));
871: IF (p_start_date IS NULL ) THEN
872: l_tc_start_date := l_temp_start_date;
873: ELSE

Line 870: PA_SCHEDULE_UTILS.log_message(1,'end date ... '||to_char(l_temp_end_date)||to_char(p_end_date));

866: AND jtf_cal_resource_assign.primary_calendar_flag = 'Y';
867: END IF;
868:
869: PA_SCHEDULE_UTILS.log_message(1,'Start date ... '||to_char(l_temp_start_date)||to_char(p_start_date));
870: PA_SCHEDULE_UTILS.log_message(1,'end date ... '||to_char(l_temp_end_date)||to_char(p_end_date));
871: IF (p_start_date IS NULL ) THEN
872: l_tc_start_date := l_temp_start_date;
873: ELSE
874: l_tc_start_date := p_start_date;

Line 1167: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '|| l_error_message);

1163:
1164: log_message(1,'Leaving check_calendar for resource');
1165: EXCEPTION
1166: WHEN l_invalid_param THEN
1167: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '|| l_error_message);
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: x_msg_count := 1;
1170: x_msg_data := substr(l_error_message,1,240);
1171: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

Line 1171: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

1167: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '|| l_error_message);
1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1169: x_msg_count := 1;
1170: x_msg_data := substr(l_error_message,1,240);
1171: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
1172: p_procedure_name => 'check_calendar');
1173: If x_msg_count = 1 THEN
1174: pa_interface_utils_pub.get_messages
1175: (p_encoded => FND_API.G_TRUE,

Line 1189: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_no_active_calendar');

1185: --Bug: 4537865
1186: End If;
1187: RAISE;
1188: WHEN l_no_active_calendar THEN
1189: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_no_active_calendar');
1190: PA_UTILS.add_message('PA','PA_NO_ACTIVE_CALENDAR',
1191: 'START_DATE', l_error_start_date,
1192: 'END_DATE', l_error_end_date);
1193: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1210: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_duplicate_calendars');

1206: x_msg_data := l_new_msg_data;
1207: --Bug: 4537865
1208: End If;
1209: WHEN l_duplicate_calendars THEN
1210: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_duplicate_calendars');
1211: PA_UTILS.add_message('PA','PA_DUPLICATE_CALENDARS',
1212: 'START_DATE', l_error_start_date,
1213: 'END_DATE', l_error_end_date);
1214: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1231: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '||sqlerrm);

1227: x_msg_data := l_new_msg_data;
1228: --bug: 4537865
1229: End If;
1230: WHEN OTHERS THEN
1231: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '||sqlerrm);
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: x_msg_count := 1;
1234: x_msg_data := substr(SQLERRM,1,240);
1235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

Line 1235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

1231: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '||sqlerrm);
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1233: x_msg_count := 1;
1234: x_msg_data := substr(SQLERRM,1,240);
1235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
1236: p_procedure_name => 'check_calendar');
1237: If x_msg_count = 1 THEN
1238: pa_interface_utils_pub.get_messages
1239: (p_encoded => FND_API.G_TRUE,

Line 1339: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_missing_calendar_schedules');

1335:
1336: log_message(1,'Leaving check_calendar for calendar');
1337: EXCEPTION
1338: WHEN l_missing_calendar_schedules THEN
1339: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_missing_calendar_schedules');
1340: PA_UTILS.add_message('PA','PA_MISSING_CALENDAR_SCHEDULES');
1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342: x_msg_data := 'PA_MISSING_CALENDAR_SCHEDULES';
1343: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 1358: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_calendar_not_active');

1354: x_msg_data := l_new_msg_data;
1355: --bug: 4537865
1356: End If;
1357: WHEN l_calendar_not_active THEN
1358: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_calendar_not_active');
1359: PA_UTILS.add_message('PA','PA_CALENDAR_NOT_ACTIVE',
1360: 'START_DATE', l_error_start_date,
1361: 'END_DATE', l_error_end_date);
1362: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1379: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_cal_missing_valid_shift');

1375: x_msg_data := l_new_msg_data;
1376: --Bug: 4537865
1377: End If;
1378: WHEN l_cal_missing_valid_shift THEN
1379: PA_SCHEDULE_UTILS.log_message(1,'ERROR: l_cal_missing_valid_shift');
1380: PA_UTILS.add_message('PA','PA_CAL_MISSING_VALID_SHIFT');
1381: x_return_status := FND_API.G_RET_STS_ERROR;
1382: x_msg_data := 'PA_CAL_MISSING_VALID_SHIFT';
1383: x_msg_count := FND_MSG_PUB.Count_Msg;

Line 1398: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '||sqlerrm);

1394: x_msg_data := l_new_msg_data;
1395: --Bug: 4537865
1396: End If;
1397: WHEN OTHERS THEN
1398: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '||sqlerrm);
1399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1400: x_msg_count := 1;
1401: x_msg_data := substr(SQLERRM,1,240);
1402: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

Line 1402: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

1398: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '||sqlerrm);
1399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1400: x_msg_count := 1;
1401: x_msg_data := substr(SQLERRM,1,240);
1402: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
1403: p_procedure_name => 'check_calendar');
1404: If x_msg_count = 1 THEN
1405: pa_interface_utils_pub.get_messages
1406: (p_encoded => FND_API.G_TRUE,

Line 1483: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '|| l_error_message);

1479: end if;
1480: log_message(1,'Leaving check_calendar main');
1481: EXCEPTION
1482: WHEN l_invalid_param THEN
1483: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '|| l_error_message);
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: x_msg_count := 1;
1486: x_msg_data := substr(l_error_message,1,240);
1487: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

Line 1487: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

1483: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '|| l_error_message);
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1485: x_msg_count := 1;
1486: x_msg_data := substr(l_error_message,1,240);
1487: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
1488: p_procedure_name => 'check_calendar');
1489: If x_msg_count = 1 THEN
1490: pa_interface_utils_pub.get_messages
1491: (p_encoded => FND_API.G_TRUE,

Line 1504: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '||sqlerrm);

1500: --Bug: 4537865
1501: End If;
1502: RAISE;
1503: WHEN OTHERS THEN
1504: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '||sqlerrm);
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1506: x_msg_count := 1;
1507: x_msg_data := substr(SQLERRM,1,240);
1508: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

Line 1508: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',

1504: PA_SCHEDULE_UTILS.log_message(1,'ERROR in check_calendar: '||sqlerrm);
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1506: x_msg_count := 1;
1507: x_msg_data := substr(SQLERRM,1,240);
1508: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_SCHEDULE_UTILS',
1509: p_procedure_name => 'check_calendar');
1510: If x_msg_count = 1 THEN
1511: pa_interface_utils_pub.get_messages
1512: (p_encoded => FND_API.G_TRUE,

Line 1528: END PA_SCHEDULE_UTILS;

1524:
1525: END check_calendar;
1526:
1527:
1528: END PA_SCHEDULE_UTILS;