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 FND_API

Line 33: x_return_status := FND_API.G_RET_STS_SUCCESS;

29:
30: BEGIN
31: l_oidx := 1;
32: l_iidx := p_start_id;
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34: x_sch_record_tab.delete;
35:
36: /* Checking for the empty table of record */
37: IF (p_sch_record_tab.count = 0 ) THEN

Line 78: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

74: EXCEPTION
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:

Line 112: x_return_status := FND_API.G_RET_STS_SUCCESS;

108: BEGIN
109: l_iidx := p_start_id;
110: l_cnt := px_sch_record_tab.count;
111:
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113:
114: /* Validating the rows in the table for Null */
115: IF (l_cnt = 0 ) THEN
116: l_oidx := 1;

Line 154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

150: END LOOP;
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:

Line 183: x_return_status := FND_API.G_RET_STS_SUCCESS;

179: l_iidx NUMBER;
180:
181: BEGIN
182: l_iidx := p_start_id;
183: x_return_status := FND_API.G_RET_STS_SUCCESS;
184:
185: /* Marking for deletion */
186: LOOP
187:

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

197: END LOOP;
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:

Line 240: x_return_status := FND_API.G_RET_STS_SUCCESS;

236: l_didx := 1;
237: END IF;
238:
239: l_cidx := 1;
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241:
242: IF (p_sch_record_tab.count = 0 ) THEN
243: Raise l_empty_tab_record;
244: ELSE

Line 309: x_return_status := FND_API.G_RET_STS_SUCCESS;

305: END LOOP;
306:
307: EXCEPTION
308: WHEN l_empty_tab_record THEN
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',

Line 312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

308: WHEN l_empty_tab_record THEN
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:

Line 366: x_return_status := FND_API.G_RET_STS_SUCCESS;

362:
363: l_iidx NUMBER;
364:
365: BEGIN
366: x_return_status := FND_API.G_RET_STS_SUCCESS;
367: IF (px_sch_record_tab.count = 0) THEN
368: Raise l_empty_tab_record;
369: ELSE
370: l_iidx := px_sch_record_tab.first;

Line 404: x_return_status := FND_API.G_RET_STS_SUCCESS;

400: END LOOP;
401:
402: EXCEPTION
403: WHEN l_empty_tab_record THEN
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',

Line 407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

403: WHEN l_empty_tab_record THEN
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:

Line 432: x_return_status := FND_API.G_RET_STS_SUCCESS;

428:
429: l_iidx NUMBER;
430:
431: BEGIN
432: x_return_status := FND_API.G_RET_STS_SUCCESS;
433: IF (px_sch_record_tab.count = 0) THEN
434: Raise l_empty_tab_record;
435: ELSE
436: l_iidx := px_sch_record_tab.first;

Line 460: x_return_status := FND_API.G_RET_STS_SUCCESS;

456: END LOOP;
457:
458: EXCEPTION
459: WHEN l_empty_tab_record THEN
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',

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

459: WHEN l_empty_tab_record THEN
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:

Line 490: x_return_status := FND_API.G_RET_STS_SUCCESS;

486:
487:
488: BEGIN
489:
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: /* Copying all the structure elements */
493:
494: x_except_record.exceptRowid := p_except_record.exceptRowid;

Line 523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

519: x_except_record.sunday_hours := p_except_record.sunday_hours;
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:

Line 582: x_return_status := FND_API.G_RET_STS_SUCCESS;

578:
579:
580: BEGIN
581:
582: x_return_status := FND_API.G_RET_STS_SUCCESS;
583:
584: px_except_record.project_id := NVL(p_project_id,px_except_record.project_id);
585: px_except_record.calendar_id := NVL(p_calendar_id,px_except_record.calendar_id);
586: px_except_record.assignment_id := NVL(p_assignment_id,px_except_record.assignment_id);

Line 601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

597: px_except_record.sunday_hours := NVL(p_sunday_hours,px_except_record.sunday_hours);
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:

Line 716: x_return_status := FND_API.G_RET_STS_SUCCESS;

712: IS
713: BEGIN
714:
715: -- Storing the value for error tracking
716: x_return_status := FND_API.G_RET_STS_SUCCESS;
717:
718: /* validating the date for starting date should not be more then the ending date */
719: IF (( p_from_date IS NOT NULL ) AND ( p_to_date IS NOT NULL )) THEN
720: IF (p_from_date <= p_to_date ) THEN

Line 723: x_return_status := FND_API.G_RET_STS_ERROR;

719: IF (( p_from_date IS NOT NULL ) AND ( p_to_date IS NOT NULL )) THEN
720: IF (p_from_date <= p_to_date ) THEN
721: NULL;
722: ELSE
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: x_error_message_code := 'PA_SCH_INVALID_DATE_RANGE';
725: --DBMS_OUTPUT.PUT_LINE('DATE ERROR '||x_return_status);
726: END IF;
727: END IF;

Line 731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

727: END IF;
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:

Line 812: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN

808: x_jtf_resource_id => l_jtf_res_id,
809: x_return_status => x_return_status,
810: x_error_message_code => x_msg_data );
811:
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);

Line 989: -- Returns x_return_status = FND_API.G_RET_STS_SUCCESS if calendar(s)

985: WHEN OTHERS THEN
986: RAISE;
987: END check_input_system_status;
988:
989: -- Returns x_return_status = FND_API.G_RET_STS_SUCCESS if calendar(s)
990: -- assigned to p_resource_id or jtf_resource_id are valid. By valid we mean:
991: -- * For all primary calendars assigned to the resource,
992: -- min(start_date_time) <= max(p_start_date,sysdate-avail duration) and
993: -- max(end_date_time) >= min(p_end_date, sysdate+avail duration).

Line 1002: -- Otherwise x_return_status <> FND_API.G_RET_STS_SUCCESS.

998: -- * For all primary calendars assigned to the resource that overlap
999: -- p_start_date to p_end_date, call check_calendar(calendar_id)
1000: -- passing in max(start_date_time,max(p_start_date,sysdate-avail duration))
1001: -- and min(end_date_time,min(p_end_date,sysdate+avail duration)).
1002: -- Otherwise x_return_status <> FND_API.G_RET_STS_SUCCESS.
1003: PROCEDURE check_calendar(p_resource_id IN NUMBER := null,
1004: p_jtf_resource_id IN NUMBER := null,
1005: p_start_date IN DATE,
1006: p_end_date IN DATE,

Line 1066: x_return_status := FND_API.G_RET_STS_SUCCESS;

1062:
1063: rec_cal c_cal%ROWTYPE;
1064: BEGIN
1065: log_message(1,'Entering check_calendar for resource');
1066: x_return_status := FND_API.G_RET_STS_SUCCESS;
1067:
1068: if (p_resource_id is not null and p_jtf_resource_id is not null) then
1069: l_error_message := 'p_resource_id and p_jtf_resource_id cannot both be not null.';
1070: raise l_invalid_param;

Line 1099: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

1095: end if;
1096:
1097: log_message(1,'Entering calendar loop');
1098: FOR rec_cal in c_cal LOOP
1099: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1100: l_cal_start_date := trunc(rec_cal.start_date_time);
1101: l_cal_end_date := trunc(rec_cal.end_date_time);
1102: log_message(1,'l_cal_start_date: ' || l_cal_start_date);
1103: log_message(1,'l_cal_end_date: ' || l_cal_end_date);

Line 1168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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',
1172: p_procedure_name => 'check_calendar');

Line 1175: (p_encoded => FND_API.G_TRUE,

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,
1176: p_msg_index => 1,
1177: p_msg_count => x_msg_count,
1178: p_msg_data => x_msg_data,
1179: --p_data => x_msg_data, * Bug: 4537865

Line 1193: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1194: x_msg_data := 'PA_NO_ACTIVE_CALENDAR';
1195: x_msg_count := FND_MSG_PUB.Count_Msg;
1196: If x_msg_count = 1 THEN
1197: pa_interface_utils_pub.get_messages

Line 1198: (p_encoded => FND_API.G_TRUE,

1194: x_msg_data := 'PA_NO_ACTIVE_CALENDAR';
1195: x_msg_count := FND_MSG_PUB.Count_Msg;
1196: If x_msg_count = 1 THEN
1197: pa_interface_utils_pub.get_messages
1198: (p_encoded => FND_API.G_TRUE,
1199: p_msg_index => 1,
1200: p_msg_count => x_msg_count,
1201: p_msg_data => x_msg_data,
1202: --p_data => x_msg_data, * bug: 4537865

Line 1214: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1215: x_msg_data := 'PA_DUPLICATE_CALENDARS';
1216: x_msg_count := FND_MSG_PUB.Count_Msg;
1217: If x_msg_count = 1 THEN
1218: pa_interface_utils_pub.get_messages

Line 1219: (p_encoded => FND_API.G_TRUE,

1215: x_msg_data := 'PA_DUPLICATE_CALENDARS';
1216: x_msg_count := FND_MSG_PUB.Count_Msg;
1217: If x_msg_count = 1 THEN
1218: pa_interface_utils_pub.get_messages
1219: (p_encoded => FND_API.G_TRUE,
1220: p_msg_index => 1,
1221: p_msg_count => x_msg_count,
1222: p_msg_data => x_msg_data,
1223: --p_data => x_msg_data, * bug: 4537865

Line 1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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',
1236: p_procedure_name => 'check_calendar');

Line 1239: (p_encoded => FND_API.G_TRUE,

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,
1240: p_msg_index => 1,
1241: p_msg_count => x_msg_count,
1242: p_msg_data => x_msg_data,
1243: --p_data => x_msg_data, * bug: 4537865

Line 1253: -- Returns x_return_status = FND_API.G_RET_STS_SUCCESS if p_calendar_id

1249: End If;
1250: RAISE;
1251: END check_calendar;
1252:
1253: -- Returns x_return_status = FND_API.G_RET_STS_SUCCESS if p_calendar_id
1254: -- is valid between p_start_date and p_end_date. By valid we mean:
1255: -- * A schedule record exists for the calendar.
1256: -- Otherwise, adds error: PA_MISSING_CALENDAR_SCHEDULES
1257: -- * The calendar start date is <= p_start_date.

Line 1263: -- Otherwise x_return_status <> FND_API.G_RET_STS_SUCCESS.

1259: -- * The calendar end date is >= p_end_date.
1260: -- Otherwise, adds error: PA_CALENDAR_NOT_ACTIVE
1261: -- * The calendar has at least 1 non-zero shift.
1262: -- Otherwise, adds error: PA_CAL_MISSING_VALID_SHIFT
1263: -- Otherwise x_return_status <> FND_API.G_RET_STS_SUCCESS.
1264: PROCEDURE check_calendar(p_calendar_id IN NUMBER,
1265: p_start_date IN DATE,
1266: p_end_date IN DATE,
1267: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

1297: and calendar_id = p_calendar_id;
1298:
1299: BEGIN
1300: log_message(1,'Entering check_calendar for calendar');
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;
1302:
1303: open c_sch;
1304: fetch c_sch
1305: into l_min_start_date, l_max_end_date, l_max_total_hours;

Line 1341: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1344: If x_msg_count = 1 THEN
1345: pa_interface_utils_pub.get_messages

Line 1346: (p_encoded => FND_API.G_TRUE,

1342: x_msg_data := 'PA_MISSING_CALENDAR_SCHEDULES';
1343: x_msg_count := FND_MSG_PUB.Count_Msg;
1344: If x_msg_count = 1 THEN
1345: pa_interface_utils_pub.get_messages
1346: (p_encoded => FND_API.G_TRUE,
1347: p_msg_index => 1,
1348: p_msg_count => x_msg_count,
1349: p_msg_data => x_msg_data,
1350: --p_data => x_msg_data, * Bug: 4537865

Line 1362: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1363: x_msg_data := 'PA_CALENDAR_NOT_ACTIVE';
1364: x_msg_count := FND_MSG_PUB.Count_Msg;
1365: If x_msg_count = 1 THEN
1366: pa_interface_utils_pub.get_messages

Line 1367: (p_encoded => FND_API.G_TRUE,

1363: x_msg_data := 'PA_CALENDAR_NOT_ACTIVE';
1364: x_msg_count := FND_MSG_PUB.Count_Msg;
1365: If x_msg_count = 1 THEN
1366: pa_interface_utils_pub.get_messages
1367: (p_encoded => FND_API.G_TRUE,
1368: p_msg_index => 1,
1369: p_msg_count => x_msg_count,
1370: p_msg_data => x_msg_data,
1371: --p_data => x_msg_data, * Bug: 4537865

Line 1381: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1384: If x_msg_count = 1 THEN
1385: pa_interface_utils_pub.get_messages

Line 1386: (p_encoded => FND_API.G_TRUE,

1382: x_msg_data := 'PA_CAL_MISSING_VALID_SHIFT';
1383: x_msg_count := FND_MSG_PUB.Count_Msg;
1384: If x_msg_count = 1 THEN
1385: pa_interface_utils_pub.get_messages
1386: (p_encoded => FND_API.G_TRUE,
1387: p_msg_index => 1,
1388: p_msg_count => x_msg_count,
1389: p_msg_data => x_msg_data,
1390: --p_data => x_msg_data, * Bug: 4537865

Line 1399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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',
1403: p_procedure_name => 'check_calendar');

Line 1406: (p_encoded => FND_API.G_TRUE,

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,
1407: p_msg_index => 1,
1408: p_msg_count => x_msg_count,
1409: p_msg_data => x_msg_data,
1410: --p_data => x_msg_data, * Bug: 4537865

Line 1442: x_return_status := FND_API.G_RET_STS_SUCCESS;

1438: --Bug: 4537865
1439:
1440: BEGIN
1441: log_message(1,'Entering check_calendar main');
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;
1443:
1444: if (p_calendar_type = 'RESOURCE') then
1445: if (p_resource_id is null) then
1446: l_error_message := 'p_resource_id cannot be null if p_calendar_type = RESOURCE.';

Line 1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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',
1488: p_procedure_name => 'check_calendar');

Line 1491: (p_encoded => FND_API.G_TRUE,

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,
1492: p_msg_index => 1,
1493: p_msg_count => x_msg_count,
1494: p_msg_data => x_msg_data,
1495: --p_data => x_msg_data, * Bug: 4537865

Line 1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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',
1509: p_procedure_name => 'check_calendar');

Line 1512: (p_encoded => FND_API.G_TRUE,

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,
1513: p_msg_index => 1,
1514: p_msg_count => x_msg_count,
1515: p_msg_data => x_msg_data,
1516: --p_data => x_msg_data, Bug: 4537865