APPS.CSF_TRIPS_PUB dependencies on FND_MESSAGE

Line 244: fnd_message.set_name('CSF', NVL(g_messages(i).message_name, 'CSF_PROCESS_TRIP_FAILED'));

240: l_failed := 0;
241:
242: FOR i IN 1..g_messages.COUNT LOOP
243: IF g_messages(i).message_type IN (g_error_message, g_warning_message) THEN
244: fnd_message.set_name('CSF', NVL(g_messages(i).message_name, 'CSF_PROCESS_TRIP_FAILED'));
245:
246: IF g_messages(i).resource_id IS NOT NULL THEN
247: IF g_suppress_res_info = TRUE THEN
248: fnd_message.set_token('RESOURCE', '');

Line 248: fnd_message.set_token('RESOURCE', '');

244: fnd_message.set_name('CSF', NVL(g_messages(i).message_name, 'CSF_PROCESS_TRIP_FAILED'));
245:
246: IF g_messages(i).resource_id IS NOT NULL THEN
247: IF g_suppress_res_info = TRUE THEN
248: fnd_message.set_token('RESOURCE', '');
249: ELSE
250: fnd_message.set_token('RESOURCE', get_resource_info(g_messages(i).resource_id, g_messages(i).resource_type));
251: END IF;
252: END IF;

Line 250: fnd_message.set_token('RESOURCE', get_resource_info(g_messages(i).resource_id, g_messages(i).resource_type));

246: IF g_messages(i).resource_id IS NOT NULL THEN
247: IF g_suppress_res_info = TRUE THEN
248: fnd_message.set_token('RESOURCE', '');
249: ELSE
250: fnd_message.set_token('RESOURCE', get_resource_info(g_messages(i).resource_id, g_messages(i).resource_type));
251: END IF;
252: END IF;
253:
254: IF g_messages(i).start_datetime IS NOT NULL THEN

Line 255: fnd_message.set_token('START_TIME', format_date(g_messages(i).start_datetime));

251: END IF;
252: END IF;
253:
254: IF g_messages(i).start_datetime IS NOT NULL THEN
255: fnd_message.set_token('START_TIME', format_date(g_messages(i).start_datetime));
256: END IF;
257:
258: IF g_messages(i).end_datetime IS NOT NULL THEN
259: fnd_message.set_token('END_TIME', format_date(g_messages(i).end_datetime));

Line 259: fnd_message.set_token('END_TIME', format_date(g_messages(i).end_datetime));

255: fnd_message.set_token('START_TIME', format_date(g_messages(i).start_datetime));
256: END IF;
257:
258: IF g_messages(i).end_datetime IS NOT NULL THEN
259: fnd_message.set_token('END_TIME', format_date(g_messages(i).end_datetime));
260: END IF;
261:
262: IF g_messages(i).error_reason IS NOT NULL THEN
263: fnd_message.set_token('REASON', g_messages(i).error_reason);

Line 263: fnd_message.set_token('REASON', g_messages(i).error_reason);

259: fnd_message.set_token('END_TIME', format_date(g_messages(i).end_datetime));
260: END IF;
261:
262: IF g_messages(i).error_reason IS NOT NULL THEN
263: fnd_message.set_token('REASON', g_messages(i).error_reason);
264: END IF;
265:
266: fnd_msg_pub.ADD;
267:

Line 308: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_WARN');

304: l_res_name := '';
305: END IF;
306:
307: IF l_failed > 0 THEN
308: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_WARN');
309: fnd_message.set_token('FAILED', l_failed);
310: ELSE
311: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
312: END IF;

Line 309: fnd_message.set_token('FAILED', l_failed);

305: END IF;
306:
307: IF l_failed > 0 THEN
308: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_WARN');
309: fnd_message.set_token('FAILED', l_failed);
310: ELSE
311: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
312: END IF;
313:

Line 311: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');

307: IF l_failed > 0 THEN
308: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_WARN');
309: fnd_message.set_token('FAILED', l_failed);
310: ELSE
311: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
312: END IF;
313:
314: fnd_message.set_token('SUCCESS', l_success);
315: fnd_message.set_token('ACTION', l_action_name);

Line 314: fnd_message.set_token('SUCCESS', l_success);

310: ELSE
311: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
312: END IF;
313:
314: fnd_message.set_token('SUCCESS', l_success);
315: fnd_message.set_token('ACTION', l_action_name);
316: fnd_message.set_token('RESOURCE', l_res_name);
317: fnd_message.set_token('START_DATE', p_start_date);
318: fnd_message.set_token('END_DATE', p_end_date);

Line 315: fnd_message.set_token('ACTION', l_action_name);

311: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
312: END IF;
313:
314: fnd_message.set_token('SUCCESS', l_success);
315: fnd_message.set_token('ACTION', l_action_name);
316: fnd_message.set_token('RESOURCE', l_res_name);
317: fnd_message.set_token('START_DATE', p_start_date);
318: fnd_message.set_token('END_DATE', p_end_date);
319: fnd_msg_pub.ADD;

Line 316: fnd_message.set_token('RESOURCE', l_res_name);

312: END IF;
313:
314: fnd_message.set_token('SUCCESS', l_success);
315: fnd_message.set_token('ACTION', l_action_name);
316: fnd_message.set_token('RESOURCE', l_res_name);
317: fnd_message.set_token('START_DATE', p_start_date);
318: fnd_message.set_token('END_DATE', p_end_date);
319: fnd_msg_pub.ADD;
320: END process_messages;

Line 317: fnd_message.set_token('START_DATE', p_start_date);

313:
314: fnd_message.set_token('SUCCESS', l_success);
315: fnd_message.set_token('ACTION', l_action_name);
316: fnd_message.set_token('RESOURCE', l_res_name);
317: fnd_message.set_token('START_DATE', p_start_date);
318: fnd_message.set_token('END_DATE', p_end_date);
319: fnd_msg_pub.ADD;
320: END process_messages;
321:

Line 318: fnd_message.set_token('END_DATE', p_end_date);

314: fnd_message.set_token('SUCCESS', l_success);
315: fnd_message.set_token('ACTION', l_action_name);
316: fnd_message.set_token('RESOURCE', l_res_name);
317: fnd_message.set_token('START_DATE', p_start_date);
318: fnd_message.set_token('END_DATE', p_end_date);
319: fnd_msg_pub.ADD;
320: END process_messages;
321:
322: PROCEDURE init_package IS

Line 520: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');

516: IF l_debug THEN
517: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
518: debug(' CSF_RESOURCE_ADDRESS_PVT failed to give Party Site ID' || x_msg_data, l_api_name, fnd_log.level_error);
519: END IF;
520: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
521: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
522: fnd_message.set_token('DATE', format_date(p_start_date_time));
523: fnd_msg_pub.ADD;
524: RAISE fnd_api.g_exc_error;

Line 521: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

517: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
518: debug(' CSF_RESOURCE_ADDRESS_PVT failed to give Party Site ID' || x_msg_data, l_api_name, fnd_log.level_error);
519: END IF;
520: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
521: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
522: fnd_message.set_token('DATE', format_date(p_start_date_time));
523: fnd_msg_pub.ADD;
524: RAISE fnd_api.g_exc_error;
525: END IF;

Line 522: fnd_message.set_token('DATE', format_date(p_start_date_time));

518: debug(' CSF_RESOURCE_ADDRESS_PVT failed to give Party Site ID' || x_msg_data, l_api_name, fnd_log.level_error);
519: END IF;
520: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
521: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
522: fnd_message.set_token('DATE', format_date(p_start_date_time));
523: fnd_msg_pub.ADD;
524: RAISE fnd_api.g_exc_error;
525: END IF;
526:

Line 569: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');

565: , x_task_id => x_dep_task_id
566: );
567:
568: IF x_return_status <> fnd_api.g_ret_sts_success THEN
569: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
570: fnd_message.set_token('TASK_NAME', g_dep_task_name);
571: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
572: fnd_msg_pub.ADD;
573:

Line 570: fnd_message.set_token('TASK_NAME', g_dep_task_name);

566: );
567:
568: IF x_return_status <> fnd_api.g_ret_sts_success THEN
569: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
570: fnd_message.set_token('TASK_NAME', g_dep_task_name);
571: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
572: fnd_msg_pub.ADD;
573:
574: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 571: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

567:
568: IF x_return_status <> fnd_api.g_ret_sts_success THEN
569: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
570: fnd_message.set_token('TASK_NAME', g_dep_task_name);
571: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
572: fnd_msg_pub.ADD;
573:
574: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
575: RAISE fnd_api.g_exc_unexpected_error;

Line 621: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');

617: , x_task_id => x_arr_task_id
618: );
619:
620: IF x_return_status <> fnd_api.g_ret_sts_success THEN
621: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
622: fnd_message.set_token('TASK_NAME', g_arr_task_name);
623: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
624: fnd_msg_pub.ADD;
625:

Line 622: fnd_message.set_token('TASK_NAME', g_arr_task_name);

618: );
619:
620: IF x_return_status <> fnd_api.g_ret_sts_success THEN
621: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
622: fnd_message.set_token('TASK_NAME', g_arr_task_name);
623: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
624: fnd_msg_pub.ADD;
625:
626: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 623: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

619:
620: IF x_return_status <> fnd_api.g_ret_sts_success THEN
621: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
622: fnd_message.set_token('TASK_NAME', g_arr_task_name);
623: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
624: fnd_msg_pub.ADD;
625:
626: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
627: RAISE fnd_api.g_exc_unexpected_error;

Line 754: fnd_message.set_name('CSF', 'CSF_TRIP_LENGTH_MORE_THAN_DAY');

750: THEN
751: IF l_debug THEN
752: debug(' The specified Trip Length is greater than one day', l_api_name, fnd_log.level_error);
753: END IF;
754: fnd_message.set_name('CSF', 'CSF_TRIP_LENGTH_MORE_THAN_DAY');
755: fnd_msg_pub.ADD;
756: RAISE fnd_api.g_exc_error;
757: END IF;
758:

Line 1009: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');

1005: IF l_debug THEN
1006: debug(' Trip Availability is more than Shift Length', l_api_name, fnd_log.level_error);
1007: END IF;
1008:
1009: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
1010: fnd_message.set_token('AVAILABLE', l_available_hours);
1011: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1012: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1013: fnd_msg_pub.ADD;

Line 1010: fnd_message.set_token('AVAILABLE', l_available_hours);

1006: debug(' Trip Availability is more than Shift Length', l_api_name, fnd_log.level_error);
1007: END IF;
1008:
1009: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
1010: fnd_message.set_token('AVAILABLE', l_available_hours);
1011: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1012: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1013: fnd_msg_pub.ADD;
1014: RAISE fnd_api.g_exc_error;

Line 1011: fnd_message.set_token('AVLBEFORE', l_available_hours_before);

1007: END IF;
1008:
1009: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
1010: fnd_message.set_token('AVAILABLE', l_available_hours);
1011: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1012: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1013: fnd_msg_pub.ADD;
1014: RAISE fnd_api.g_exc_error;
1015: END IF;*/

Line 1012: fnd_message.set_token('AVLAFTER', l_available_hours_after);

1008:
1009: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
1010: fnd_message.set_token('AVAILABLE', l_available_hours);
1011: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1012: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1013: fnd_msg_pub.ADD;
1014: RAISE fnd_api.g_exc_error;
1015: END IF;*/
1016:

Line 1027: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');

1023: IF l_debug THEN
1024: debug(' Available Hours Before and After must be NULL when Availability is Trip Length', l_api_name, fnd_log.level_error);
1025: END IF;
1026:
1027: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
1028: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1029: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1030: fnd_message.set_token('AVAILABLE', l_available_hours);
1031: fnd_msg_pub.ADD;

Line 1028: fnd_message.set_token('AVLBEFORE', l_available_hours_before);

1024: debug(' Available Hours Before and After must be NULL when Availability is Trip Length', l_api_name, fnd_log.level_error);
1025: END IF;
1026:
1027: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
1028: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1029: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1030: fnd_message.set_token('AVAILABLE', l_available_hours);
1031: fnd_msg_pub.ADD;
1032: RAISE fnd_api.g_exc_error;

Line 1029: fnd_message.set_token('AVLAFTER', l_available_hours_after);

1025: END IF;
1026:
1027: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
1028: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1029: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1030: fnd_message.set_token('AVAILABLE', l_available_hours);
1031: fnd_msg_pub.ADD;
1032: RAISE fnd_api.g_exc_error;
1033: END IF;

Line 1030: fnd_message.set_token('AVAILABLE', l_available_hours);

1026:
1027: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
1028: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1029: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1030: fnd_message.set_token('AVAILABLE', l_available_hours);
1031: fnd_msg_pub.ADD;
1032: RAISE fnd_api.g_exc_error;
1033: END IF;
1034:

Line 1107: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');

1103: x_msg_data := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);
1104: IF l_debug THEN
1105: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1106: END IF;
1107: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1108: fnd_message.set_token('TASK', v_task.task_number);
1109: fnd_message.set_token('REASON', x_msg_data);
1110: fnd_msg_pub.ADD;
1111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1108: fnd_message.set_token('TASK', v_task.task_number);

1104: IF l_debug THEN
1105: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1106: END IF;
1107: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1108: fnd_message.set_token('TASK', v_task.task_number);
1109: fnd_message.set_token('REASON', x_msg_data);
1110: fnd_msg_pub.ADD;
1111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1112: RAISE fnd_api.g_exc_unexpected_error;

Line 1109: fnd_message.set_token('REASON', x_msg_data);

1105: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1106: END IF;
1107: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1108: fnd_message.set_token('TASK', v_task.task_number);
1109: fnd_message.set_token('REASON', x_msg_data);
1110: fnd_msg_pub.ADD;
1111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1112: RAISE fnd_api.g_exc_unexpected_error;
1113: END IF;

Line 1180: fnd_message.set_name('CSF', 'CSF_TRIP_IS_BLOCKED');

1176: IF l_debug THEN
1177: debug(' The Trip is unavailable and so cant be deleted', l_api_name, fnd_log.level_error);
1178: END IF;
1179:
1180: fnd_message.set_name('CSF', 'CSF_TRIP_IS_BLOCKED');
1181: fnd_msg_pub.ADD;
1182: RAISE fnd_api.g_exc_error;
1183: END IF;
1184:

Line 1193: fnd_message.set_name('CSF', 'CSF_TRIP_HAS_ACTIVE_TASKS');

1189: IF l_debug THEN
1190: debug(' Trip has active Tasks and so cant be deleted', l_api_name, fnd_log.level_error);
1191: END IF;
1192:
1193: fnd_message.set_name('CSF', 'CSF_TRIP_HAS_ACTIVE_TASKS');
1194: fnd_msg_pub.ADD;
1195: RAISE fnd_api.g_exc_error;
1196: END IF;
1197: END IF;

Line 1217: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');

1213: IF l_debug THEN
1214: debug(' Unable to Delete the Shift Task id - ' || v_shift_task.task_id , l_api_name, fnd_log.level_error);
1215: END IF;
1216:
1217: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1218: fnd_message.set_token('TASK', v_shift_task.task_number);
1219: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1220: fnd_msg_pub.ADD;
1221: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1218: fnd_message.set_token('TASK', v_shift_task.task_number);

1214: debug(' Unable to Delete the Shift Task id - ' || v_shift_task.task_id , l_api_name, fnd_log.level_error);
1215: END IF;
1216:
1217: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1218: fnd_message.set_token('TASK', v_shift_task.task_number);
1219: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1220: fnd_msg_pub.ADD;
1221: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1222: RAISE fnd_api.g_exc_unexpected_error;

Line 1219: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

1215: END IF;
1216:
1217: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1218: fnd_message.set_token('TASK', v_shift_task.task_number);
1219: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1220: fnd_msg_pub.ADD;
1221: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1222: RAISE fnd_api.g_exc_unexpected_error;
1223: END IF;

Line 1415: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');

1411: IF l_debug THEN
1412: debug(' Unable to Delete the Task', l_api_name, fnd_log.level_error);
1413: END IF;
1414:
1415: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1416: fnd_message.set_token('TASK', v_shift_task.task_number);
1417: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1418: fnd_msg_pub.ADD;
1419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1416: fnd_message.set_token('TASK', v_shift_task.task_number);

1412: debug(' Unable to Delete the Task', l_api_name, fnd_log.level_error);
1413: END IF;
1414:
1415: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1416: fnd_message.set_token('TASK', v_shift_task.task_number);
1417: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1418: fnd_msg_pub.ADD;
1419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1420: RAISE fnd_api.g_exc_unexpected_error;

Line 1417: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

1413: END IF;
1414:
1415: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1416: fnd_message.set_token('TASK', v_shift_task.task_number);
1417: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1418: fnd_msg_pub.ADD;
1419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1420: RAISE fnd_api.g_exc_unexpected_error;
1421: END IF;

Line 1481: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');

1477: , p_abort_workflow => fnd_api.g_miss_char
1478: );
1479:
1480: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1481: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1482: fnd_message.set_token('TASK', v_task.task_number);
1483: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1484: fnd_msg_pub.ADD;
1485: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1482: fnd_message.set_token('TASK', v_task.task_number);

1478: );
1479:
1480: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1481: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1482: fnd_message.set_token('TASK', v_task.task_number);
1483: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1484: fnd_msg_pub.ADD;
1485: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1486: RAISE fnd_api.g_exc_unexpected_error;

Line 1483: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

1479:
1480: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1481: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1482: fnd_message.set_token('TASK', v_task.task_number);
1483: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1484: fnd_msg_pub.ADD;
1485: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1486: RAISE fnd_api.g_exc_unexpected_error;
1487: END IF;

Line 2673: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');

2669: IF l_trips.COUNT > 0 THEN
2670: IF l_debug THEN
2671: debug(' Trips already exists for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2672: END IF;
2673: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
2674: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2675: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2676: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2677: fnd_msg_pub.ADD;

Line 2674: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

2670: IF l_debug THEN
2671: debug(' Trips already exists for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2672: END IF;
2673: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
2674: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2675: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2676: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2677: fnd_msg_pub.ADD;
2678: RAISE fnd_api.g_exc_error;

Line 2675: fnd_message.set_token('START_TIME', format_date(p_start_date_time));

2671: debug(' Trips already exists for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2672: END IF;
2673: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
2674: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2675: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2676: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2677: fnd_msg_pub.ADD;
2678: RAISE fnd_api.g_exc_error;
2679: END IF;

Line 2676: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

2672: END IF;
2673: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
2674: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2675: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2676: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2677: fnd_msg_pub.ADD;
2678: RAISE fnd_api.g_exc_error;
2679: END IF;
2680:

Line 2697: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');

2693: IF l_shift_tasks_exist = 'Y' THEN
2694: IF l_debug THEN
2695: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2696: END IF;
2697: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
2698: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2699: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2700: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2701: fnd_msg_pub.ADD;

Line 2698: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

2694: IF l_debug THEN
2695: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2696: END IF;
2697: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
2698: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2699: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2700: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2701: fnd_msg_pub.ADD;
2702: RAISE fnd_api.g_exc_error;

Line 2699: fnd_message.set_token('START_TIME', format_date(p_start_date_time));

2695: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2696: END IF;
2697: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
2698: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2699: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2700: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2701: fnd_msg_pub.ADD;
2702: RAISE fnd_api.g_exc_error;
2703: END IF;

Line 2700: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

2696: END IF;
2697: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
2698: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2699: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2700: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2701: fnd_msg_pub.ADD;
2702: RAISE fnd_api.g_exc_error;
2703: END IF;
2704:

Line 2721: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');

2717: , x_trip => l_new_trip
2718: );
2719:
2720: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2721: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2722: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2723: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

Line 2722: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

2718: );
2719:
2720: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2721: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2722: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2723: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2726: fnd_msg_pub.ADD;

Line 2723: fnd_message.set_token('START_TIME', format_date(p_start_date_time));

2719:
2720: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2721: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2722: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2723: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2726: fnd_msg_pub.ADD;
2727: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

2720: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2721: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2722: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2723: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2726: fnd_msg_pub.ADD;
2727: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2728: RAISE fnd_api.g_exc_unexpected_error;

Line 2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

2721: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2722: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2723: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2726: fnd_msg_pub.ADD;
2727: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2728: RAISE fnd_api.g_exc_unexpected_error;
2729: END IF;

Line 2794: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

2790: x_return_status := fnd_api.g_ret_sts_success;
2791:
2792: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2793: -- Invalid Trip ID passed.
2794: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2795: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2796: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2797: fnd_msg_pub.ADD;
2798: RAISE fnd_api.g_exc_error;

Line 2795: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

2791:
2792: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2793: -- Invalid Trip ID passed.
2794: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2795: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2796: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2797: fnd_msg_pub.ADD;
2798: RAISE fnd_api.g_exc_error;
2799: END IF;

Line 2796: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');

2792: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2793: -- Invalid Trip ID passed.
2794: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2795: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2796: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2797: fnd_msg_pub.ADD;
2798: RAISE fnd_api.g_exc_error;
2799: END IF;
2800:

Line 2803: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

2799: END IF;
2800:
2801: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2802: -- Invalid Object Version Number passed.
2803: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2804: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2805: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2806: fnd_msg_pub.ADD;
2807: RAISE fnd_api.g_exc_error;

Line 2804: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

2800:
2801: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2802: -- Invalid Object Version Number passed.
2803: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2804: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2805: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2806: fnd_msg_pub.ADD;
2807: RAISE fnd_api.g_exc_error;
2808: END IF;

Line 2805: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');

2801: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2802: -- Invalid Object Version Number passed.
2803: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2804: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2805: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2806: fnd_msg_pub.ADD;
2807: RAISE fnd_api.g_exc_error;
2808: END IF;
2809:

Line 2812: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

2808: END IF;
2809:
2810: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
2811: -- Error out as both cant be passed.
2812: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2813: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2814: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
2815: fnd_msg_pub.ADD;
2816: RAISE fnd_api.g_exc_error;

Line 2813: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

2809:
2810: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
2811: -- Error out as both cant be passed.
2812: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2813: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2814: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
2815: fnd_msg_pub.ADD;
2816: RAISE fnd_api.g_exc_error;
2817: END IF;

Line 2814: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');

2810: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
2811: -- Error out as both cant be passed.
2812: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2813: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2814: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
2815: fnd_msg_pub.ADD;
2816: RAISE fnd_api.g_exc_error;
2817: END IF;
2818:

Line 2821: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');

2817: END IF;
2818:
2819: l_trip := get_trip(p_trip_id);
2820: IF l_trip.trip_id IS NULL THEN
2821: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2822: fnd_message.set_token('TRIP_ID', p_trip_id);
2823: fnd_msg_pub.ADD;
2824: RAISE fnd_api.g_exc_error;
2825: END IF;

Line 2822: fnd_message.set_token('TRIP_ID', p_trip_id);

2818:
2819: l_trip := get_trip(p_trip_id);
2820: IF l_trip.trip_id IS NULL THEN
2821: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2822: fnd_message.set_token('TRIP_ID', p_trip_id);
2823: fnd_msg_pub.ADD;
2824: RAISE fnd_api.g_exc_error;
2825: END IF;
2826:

Line 2841: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');

2837: , p_status => p_status
2838: );
2839:
2840: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2841: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2842: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2843: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

Line 2842: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));

2838: );
2839:
2840: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2841: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2842: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2843: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2846: fnd_msg_pub.ADD;

Line 2843: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));

2839:
2840: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2841: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2842: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2843: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2846: fnd_msg_pub.ADD;
2847: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));

2840: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2841: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2842: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2843: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2846: fnd_msg_pub.ADD;
2847: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2848: RAISE fnd_api.g_exc_unexpected_error;

Line 2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

2841: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2842: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2843: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2846: fnd_msg_pub.ADD;
2847: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2848: RAISE fnd_api.g_exc_unexpected_error;
2849: END IF;

Line 2912: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

2908: END IF;
2909:
2910: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2911: -- Invalid Trip ID passed.
2912: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2913: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2914: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2915: fnd_msg_pub.ADD;
2916: RAISE fnd_api.g_exc_error;

Line 2913: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

2909:
2910: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2911: -- Invalid Trip ID passed.
2912: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2913: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2914: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2915: fnd_msg_pub.ADD;
2916: RAISE fnd_api.g_exc_error;
2917: END IF;

Line 2914: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');

2910: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2911: -- Invalid Trip ID passed.
2912: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2913: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2914: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2915: fnd_msg_pub.ADD;
2916: RAISE fnd_api.g_exc_error;
2917: END IF;
2918:

Line 2921: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

2917: END IF;
2918:
2919: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2920: -- Invalid Object Version Number passed.
2921: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2922: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2923: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2924: fnd_msg_pub.ADD;
2925: RAISE fnd_api.g_exc_error;

Line 2922: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

2918:
2919: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2920: -- Invalid Object Version Number passed.
2921: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2922: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2923: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2924: fnd_msg_pub.ADD;
2925: RAISE fnd_api.g_exc_error;
2926: END IF;

Line 2923: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');

2919: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2920: -- Invalid Object Version Number passed.
2921: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2922: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2923: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2924: fnd_msg_pub.ADD;
2925: RAISE fnd_api.g_exc_error;
2926: END IF;
2927:

Line 2931: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');

2927:
2928: l_trip := get_trip(p_trip_id);
2929: -- No Trips found for the given Trip ID
2930: IF l_trip.trip_id IS NULL THEN
2931: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2932: fnd_message.set_token('TRIP_ID', p_trip_id);
2933: fnd_msg_pub.ADD;
2934: RAISE fnd_api.g_exc_error;
2935: END IF;

Line 2932: fnd_message.set_token('TRIP_ID', p_trip_id);

2928: l_trip := get_trip(p_trip_id);
2929: -- No Trips found for the given Trip ID
2930: IF l_trip.trip_id IS NULL THEN
2931: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2932: fnd_message.set_token('TRIP_ID', p_trip_id);
2933: fnd_msg_pub.ADD;
2934: RAISE fnd_api.g_exc_error;
2935: END IF;
2936:

Line 2951: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');

2947: debug( ' Unable to delete the Trip: Error = '
2948: || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2949: , l_api_name, fnd_log.level_error);
2950: END IF;
2951: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2952: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2953: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2954: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

Line 2952: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));

2948: || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2949: , l_api_name, fnd_log.level_error);
2950: END IF;
2951: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2952: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2953: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2954: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2956: fnd_msg_pub.ADD;

Line 2953: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));

2949: , l_api_name, fnd_log.level_error);
2950: END IF;
2951: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2952: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2953: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2954: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2956: fnd_msg_pub.ADD;
2957: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2954: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));

2950: END IF;
2951: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2952: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2953: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2954: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2956: fnd_msg_pub.ADD;
2957: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2958: RAISE fnd_api.g_exc_unexpected_error;

Line 2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

2951: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2952: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2953: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2954: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2956: fnd_msg_pub.ADD;
2957: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2958: RAISE fnd_api.g_exc_unexpected_error;
2959: END IF;

Line 3023: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

3019: END IF;
3020:
3021: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
3022: -- Invalid Trip ID passed.
3023: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3024: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3025: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
3026: fnd_msg_pub.ADD;
3027: RAISE fnd_api.g_exc_error;

Line 3024: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

3020:
3021: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
3022: -- Invalid Trip ID passed.
3023: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3024: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3025: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
3026: fnd_msg_pub.ADD;
3027: RAISE fnd_api.g_exc_error;
3028: END IF;

Line 3025: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');

3021: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
3022: -- Invalid Trip ID passed.
3023: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3024: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3025: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
3026: fnd_msg_pub.ADD;
3027: RAISE fnd_api.g_exc_error;
3028: END IF;
3029:

Line 3032: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

3028: END IF;
3029:
3030: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
3031: -- Invalid Object Version Number passed.
3032: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3033: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3034: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
3035: fnd_msg_pub.ADD;
3036: RAISE fnd_api.g_exc_error;

Line 3033: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

3029:
3030: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
3031: -- Invalid Object Version Number passed.
3032: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3033: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3034: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
3035: fnd_msg_pub.ADD;
3036: RAISE fnd_api.g_exc_error;
3037: END IF;

Line 3034: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');

3030: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
3031: -- Invalid Object Version Number passed.
3032: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3033: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3034: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
3035: fnd_msg_pub.ADD;
3036: RAISE fnd_api.g_exc_error;
3037: END IF;
3038:

Line 3041: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');

3037: END IF;
3038:
3039: l_trip := get_trip(p_trip_id);
3040: IF l_trip.trip_id IS NULL THEN
3041: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
3042: fnd_message.set_token('TRIP_ID', p_trip_id);
3043: fnd_msg_pub.ADD;
3044: RAISE fnd_api.g_exc_error;
3045: END IF;

Line 3042: fnd_message.set_token('TRIP_ID', p_trip_id);

3038:
3039: l_trip := get_trip(p_trip_id);
3040: IF l_trip.trip_id IS NULL THEN
3041: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
3042: fnd_message.set_token('TRIP_ID', p_trip_id);
3043: fnd_msg_pub.ADD;
3044: RAISE fnd_api.g_exc_error;
3045: END IF;
3046:

Line 3059: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');

3055: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3056: IF l_debug THEN
3057: debug(' Unable to fix the Trip', l_api_name, fnd_log.level_error);
3058: END IF;
3059: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
3060: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
3061: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
3062: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

Line 3060: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));

3056: IF l_debug THEN
3057: debug(' Unable to fix the Trip', l_api_name, fnd_log.level_error);
3058: END IF;
3059: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
3060: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
3061: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
3062: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
3064: fnd_msg_pub.ADD;

Line 3061: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));

3057: debug(' Unable to fix the Trip', l_api_name, fnd_log.level_error);
3058: END IF;
3059: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
3060: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
3061: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
3062: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
3064: fnd_msg_pub.ADD;
3065: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3062: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));

3058: END IF;
3059: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
3060: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
3061: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
3062: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
3064: fnd_msg_pub.ADD;
3065: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3066: RAISE fnd_api.g_exc_unexpected_error;

Line 3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

3059: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
3060: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
3061: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
3062: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
3064: fnd_msg_pub.ADD;
3065: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3066: RAISE fnd_api.g_exc_unexpected_error;
3067: END IF;

Line 3140: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');

3136: l_trips := find_trips(l_resource_tbl, p_start_date_time, p_end_date_time, p_overtime_flag);
3137:
3138: IF l_trips.COUNT = 0 OR l_trips.COUNT > 1 THEN
3139: IF l_trips.COUNT = 0 THEN
3140: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3141: ELSE
3142: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
3143: END IF;
3144: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

Line 3142: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');

3138: IF l_trips.COUNT = 0 OR l_trips.COUNT > 1 THEN
3139: IF l_trips.COUNT = 0 THEN
3140: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3141: ELSE
3142: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
3143: END IF;
3144: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3145: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3146: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

Line 3144: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

3140: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3141: ELSE
3142: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
3143: END IF;
3144: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3145: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3146: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
3147: fnd_msg_pub.add;
3148: RAISE fnd_api.g_exc_error;

Line 3145: fnd_message.set_token('START_TIME', format_date(p_start_date_time));

3141: ELSE
3142: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
3143: END IF;
3144: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3145: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3146: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
3147: fnd_msg_pub.add;
3148: RAISE fnd_api.g_exc_error;
3149: END IF;

Line 3146: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

3142: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
3143: END IF;
3144: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3145: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3146: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
3147: fnd_msg_pub.add;
3148: RAISE fnd_api.g_exc_error;
3149: END IF;
3150:

Line 3368: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

3364: l_param_name := 'P_END_DATE';
3365: END IF;
3366:
3367: IF l_param_name IS NOT NULL THEN
3368: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3369: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3370: fnd_message.set_token('PARAM_NAME', l_param_name);
3371: fnd_msg_pub.ADD;
3372: RAISE fnd_api.g_exc_error;

Line 3369: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

3365: END IF;
3366:
3367: IF l_param_name IS NOT NULL THEN
3368: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3369: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3370: fnd_message.set_token('PARAM_NAME', l_param_name);
3371: fnd_msg_pub.ADD;
3372: RAISE fnd_api.g_exc_error;
3373: END IF;

Line 3370: fnd_message.set_token('PARAM_NAME', l_param_name);

3366:
3367: IF l_param_name IS NOT NULL THEN
3368: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3369: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3370: fnd_message.set_token('PARAM_NAME', l_param_name);
3371: fnd_msg_pub.ADD;
3372: RAISE fnd_api.g_exc_error;
3373: END IF;
3374:

Line 3385: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');

3381: END IF;
3382:
3383: IF l_trips.COUNT = 0 THEN
3384: IF p_trip_id IS NOT NULL THEN
3385: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
3386: fnd_message.set_token('TRIP_ID', p_trip_id);
3387: ELSE
3388: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3389: IF p_resource_tbl.COUNT = 1 THEN

Line 3386: fnd_message.set_token('TRIP_ID', p_trip_id);

3382:
3383: IF l_trips.COUNT = 0 THEN
3384: IF p_trip_id IS NOT NULL THEN
3385: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
3386: fnd_message.set_token('TRIP_ID', p_trip_id);
3387: ELSE
3388: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3389: IF p_resource_tbl.COUNT = 1 THEN
3390: fnd_message.set_token('RESOURCE', get_resource_info(

Line 3388: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');

3384: IF p_trip_id IS NOT NULL THEN
3385: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
3386: fnd_message.set_token('TRIP_ID', p_trip_id);
3387: ELSE
3388: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3389: IF p_resource_tbl.COUNT = 1 THEN
3390: fnd_message.set_token('RESOURCE', get_resource_info(
3391: p_resource_tbl(1).resource_id
3392: , p_resource_tbl(1).resource_type

Line 3390: fnd_message.set_token('RESOURCE', get_resource_info(

3386: fnd_message.set_token('TRIP_ID', p_trip_id);
3387: ELSE
3388: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3389: IF p_resource_tbl.COUNT = 1 THEN
3390: fnd_message.set_token('RESOURCE', get_resource_info(
3391: p_resource_tbl(1).resource_id
3392: , p_resource_tbl(1).resource_type
3393: ));
3394: END IF;

Line 3395: fnd_message.set_token('START_TIME', format_date(p_start_date));

3391: p_resource_tbl(1).resource_id
3392: , p_resource_tbl(1).resource_type
3393: ));
3394: END IF;
3395: fnd_message.set_token('START_TIME', format_date(p_start_date));
3396: fnd_message.set_token('END_TIME', format_date(p_end_date));
3397: fnd_msg_pub.add;
3398: IF p_action = g_action_delete_trip
3399: THEN

Line 3396: fnd_message.set_token('END_TIME', format_date(p_end_date));

3392: , p_resource_tbl(1).resource_type
3393: ));
3394: END IF;
3395: fnd_message.set_token('START_TIME', format_date(p_start_date));
3396: fnd_message.set_token('END_TIME', format_date(p_end_date));
3397: fnd_msg_pub.add;
3398: IF p_action = g_action_delete_trip
3399: THEN
3400: check_dangling_tasks(p_resource_tbl => p_resource_tbl

Line 3582: fnd_message.set_name('CSF', 'CSF_GTR_CP_STARTED');

3578:
3579: BEGIN
3580: /******************* Concurrent Program Start Message *******************/
3581:
3582: fnd_message.set_name('CSF', 'CSF_GTR_CP_STARTED');
3583: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3584:
3585: init_package;
3586: g_suppress_res_info := TRUE;

Line 3583: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);

3579: BEGIN
3580: /******************* Concurrent Program Start Message *******************/
3581:
3582: fnd_message.set_name('CSF', 'CSF_GTR_CP_STARTED');
3583: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3584:
3585: init_package;
3586: g_suppress_res_info := TRUE;
3587:

Line 3657: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS_RESOURCE');

3653: end if;*/
3654:
3655: -- Concurrent Program Parameters
3656: IF p_resource_id IS NOT NULL AND p_resource_type IS NOT NULL THEN
3657: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS_RESOURCE');
3658: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3659:
3660: l_resource_info := fnd_message.get;
3661: l_resource_id_tbl := jtf_number_table();

Line 3658: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

3654:
3655: -- Concurrent Program Parameters
3656: IF p_resource_id IS NOT NULL AND p_resource_type IS NOT NULL THEN
3657: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS_RESOURCE');
3658: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3659:
3660: l_resource_info := fnd_message.get;
3661: l_resource_id_tbl := jtf_number_table();
3662: l_resource_id_tbl.extend(1);

Line 3660: l_resource_info := fnd_message.get;

3656: IF p_resource_id IS NOT NULL AND p_resource_type IS NOT NULL THEN
3657: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS_RESOURCE');
3658: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3659:
3660: l_resource_info := fnd_message.get;
3661: l_resource_id_tbl := jtf_number_table();
3662: l_resource_id_tbl.extend(1);
3663: l_resource_id_tbl(1) := p_resource_id;
3664:

Line 3676: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');

3672: FETCH c_resources BULK COLLECT INTO l_resource_id_tbl, l_resource_type_tbl;
3673: CLOSE c_resources;
3674: END IF;
3675:
3676: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3677: fnd_message.set_token('ACTION', p_action);
3678: fnd_message.set_token('START_DATE', l_start_date);
3679: fnd_message.set_token('END_DATE', l_end_date);
3680: fnd_message.set_token('RESOURCE_INFO', l_resource_info);

Line 3677: fnd_message.set_token('ACTION', p_action);

3673: CLOSE c_resources;
3674: END IF;
3675:
3676: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3677: fnd_message.set_token('ACTION', p_action);
3678: fnd_message.set_token('START_DATE', l_start_date);
3679: fnd_message.set_token('END_DATE', l_end_date);
3680: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3681: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);

Line 3678: fnd_message.set_token('START_DATE', l_start_date);

3674: END IF;
3675:
3676: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3677: fnd_message.set_token('ACTION', p_action);
3678: fnd_message.set_token('START_DATE', l_start_date);
3679: fnd_message.set_token('END_DATE', l_end_date);
3680: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3681: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3682:

Line 3679: fnd_message.set_token('END_DATE', l_end_date);

3675:
3676: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3677: fnd_message.set_token('ACTION', p_action);
3678: fnd_message.set_token('START_DATE', l_start_date);
3679: fnd_message.set_token('END_DATE', l_end_date);
3680: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3681: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3682:
3683: /********************* Concurrent Program Execution *********************/

Line 3680: fnd_message.set_token('RESOURCE_INFO', l_resource_info);

3676: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3677: fnd_message.set_token('ACTION', p_action);
3678: fnd_message.set_token('START_DATE', l_start_date);
3679: fnd_message.set_token('END_DATE', l_end_date);
3680: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3681: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3682:
3683: /********************* Concurrent Program Execution *********************/
3684: l_resources_failed := 0;

Line 3681: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);

3677: fnd_message.set_token('ACTION', p_action);
3678: fnd_message.set_token('START_DATE', l_start_date);
3679: fnd_message.set_token('END_DATE', l_end_date);
3680: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3681: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3682:
3683: /********************* Concurrent Program Execution *********************/
3684: l_resources_failed := 0;
3685: l_resources_success := 0;

Line 3695: fnd_message.set_name('CSF', 'CSF_RESOURCE_PROCESSED');

3691: l_resource(1).resource_id := l_resource_id_tbl(i);
3692: l_resource(1).resource_type := l_resource_type_tbl(i);
3693:
3694: l_resource_info := get_resource_info(l_resource(1).resource_id, l_resource(1).resource_type);
3695: fnd_message.set_name('CSF', 'CSF_RESOURCE_PROCESSED');
3696: fnd_message.set_token('RESOURCE', l_resource_info);
3697: debug(fnd_message.get, 'GEN_RESOURCE_TRIPS', g_level_cp_output);
3698: IF l_debug THEN
3699: debug('*****Starting generating Trips for Resource ID #' || l_resource(1).resource_id||

Line 3696: fnd_message.set_token('RESOURCE', l_resource_info);

3692: l_resource(1).resource_type := l_resource_type_tbl(i);
3693:
3694: l_resource_info := get_resource_info(l_resource(1).resource_id, l_resource(1).resource_type);
3695: fnd_message.set_name('CSF', 'CSF_RESOURCE_PROCESSED');
3696: fnd_message.set_token('RESOURCE', l_resource_info);
3697: debug(fnd_message.get, 'GEN_RESOURCE_TRIPS', g_level_cp_output);
3698: IF l_debug THEN
3699: debug('*****Starting generating Trips for Resource ID #' || l_resource(1).resource_id||
3700: ' Resource Type #'|| l_resource(1).resource_type, l_api_name, fnd_log.level_statement);

Line 3697: debug(fnd_message.get, 'GEN_RESOURCE_TRIPS', g_level_cp_output);

3693:
3694: l_resource_info := get_resource_info(l_resource(1).resource_id, l_resource(1).resource_type);
3695: fnd_message.set_name('CSF', 'CSF_RESOURCE_PROCESSED');
3696: fnd_message.set_token('RESOURCE', l_resource_info);
3697: debug(fnd_message.get, 'GEN_RESOURCE_TRIPS', g_level_cp_output);
3698: IF l_debug THEN
3699: debug('*****Starting generating Trips for Resource ID #' || l_resource(1).resource_id||
3700: ' Resource Type #'|| l_resource(1).resource_type, l_api_name, fnd_log.level_statement);
3701: END IF;

Line 3739: fnd_message.set_name('CSF', 'CSF_CP_DONE_WARNING');

3735: debug(' ', '', g_level_cp_output);
3736:
3737: IF l_resources_failed > 0 THEN
3738: retcode := 1;
3739: fnd_message.set_name('CSF', 'CSF_CP_DONE_WARNING');
3740: ELSE
3741: retcode := 0;
3742: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
3743: END IF;

Line 3742: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');

3738: retcode := 1;
3739: fnd_message.set_name('CSF', 'CSF_CP_DONE_WARNING');
3740: ELSE
3741: retcode := 0;
3742: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
3743: END IF;
3744:
3745: errbuf := fnd_message.get;
3746: debug(errbuf, l_api_name, g_level_cp_output);

Line 3745: errbuf := fnd_message.get;

3741: retcode := 0;
3742: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
3743: END IF;
3744:
3745: errbuf := fnd_message.get;
3746: debug(errbuf, l_api_name, g_level_cp_output);
3747:
3748: debug(' ', '', g_level_cp_output);
3749: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');

Line 3749: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');

3745: errbuf := fnd_message.get;
3746: debug(errbuf, l_api_name, g_level_cp_output);
3747:
3748: debug(' ', '', g_level_cp_output);
3749: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');
3750: fnd_message.set_token('NUMBER', l_resources_success);
3751: debug(fnd_message.get, l_api_name, g_level_cp_output);
3752:
3753: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');

Line 3750: fnd_message.set_token('NUMBER', l_resources_success);

3746: debug(errbuf, l_api_name, g_level_cp_output);
3747:
3748: debug(' ', '', g_level_cp_output);
3749: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');
3750: fnd_message.set_token('NUMBER', l_resources_success);
3751: debug(fnd_message.get, l_api_name, g_level_cp_output);
3752:
3753: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3754: fnd_message.set_token('NUMBER', l_resources_failed);

Line 3751: debug(fnd_message.get, l_api_name, g_level_cp_output);

3747:
3748: debug(' ', '', g_level_cp_output);
3749: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');
3750: fnd_message.set_token('NUMBER', l_resources_success);
3751: debug(fnd_message.get, l_api_name, g_level_cp_output);
3752:
3753: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3754: fnd_message.set_token('NUMBER', l_resources_failed);
3755: debug(fnd_message.get, l_api_name, g_level_cp_output);

Line 3753: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');

3749: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');
3750: fnd_message.set_token('NUMBER', l_resources_success);
3751: debug(fnd_message.get, l_api_name, g_level_cp_output);
3752:
3753: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3754: fnd_message.set_token('NUMBER', l_resources_failed);
3755: debug(fnd_message.get, l_api_name, g_level_cp_output);
3756:
3757: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');

Line 3754: fnd_message.set_token('NUMBER', l_resources_failed);

3750: fnd_message.set_token('NUMBER', l_resources_success);
3751: debug(fnd_message.get, l_api_name, g_level_cp_output);
3752:
3753: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3754: fnd_message.set_token('NUMBER', l_resources_failed);
3755: debug(fnd_message.get, l_api_name, g_level_cp_output);
3756:
3757: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3758: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);

Line 3755: debug(fnd_message.get, l_api_name, g_level_cp_output);

3751: debug(fnd_message.get, l_api_name, g_level_cp_output);
3752:
3753: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3754: fnd_message.set_token('NUMBER', l_resources_failed);
3755: debug(fnd_message.get, l_api_name, g_level_cp_output);
3756:
3757: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3758: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);
3759: debug(fnd_message.get, l_api_name, g_level_cp_output);

Line 3757: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');

3753: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3754: fnd_message.set_token('NUMBER', l_resources_failed);
3755: debug(fnd_message.get, l_api_name, g_level_cp_output);
3756:
3757: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3758: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);
3759: debug(fnd_message.get, l_api_name, g_level_cp_output);
3760: EXCEPTION
3761: WHEN OTHERS THEN

Line 3758: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);

3754: fnd_message.set_token('NUMBER', l_resources_failed);
3755: debug(fnd_message.get, l_api_name, g_level_cp_output);
3756:
3757: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3758: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);
3759: debug(fnd_message.get, l_api_name, g_level_cp_output);
3760: EXCEPTION
3761: WHEN OTHERS THEN
3762: IF SQLERRM IS NOT NULL THEN

Line 3759: debug(fnd_message.get, l_api_name, g_level_cp_output);

3755: debug(fnd_message.get, l_api_name, g_level_cp_output);
3756:
3757: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3758: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);
3759: debug(fnd_message.get, l_api_name, g_level_cp_output);
3760: EXCEPTION
3761: WHEN OTHERS THEN
3762: IF SQLERRM IS NOT NULL THEN
3763:

Line 3771: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');

3767: END IF;
3768: END IF;
3769:
3770: retcode := 2;
3771: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
3772: errbuf := fnd_message.get;
3773: debug(errbuf, l_api_name, g_level_cp_output);
3774: END generate_trips;
3775:

Line 3772: errbuf := fnd_message.get;

3768: END IF;
3769:
3770: retcode := 2;
3771: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
3772: errbuf := fnd_message.get;
3773: debug(errbuf, l_api_name, g_level_cp_output);
3774: END generate_trips;
3775:
3776:

Line 3843: fnd_message.set_name('CSR','OPTIMIZE_ACROSS_TRIPS');

3839: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3840: RAISE fnd_api.g_exc_unexpected_error;
3841: END IF;
3842:
3843: fnd_message.set_name('CSR','OPTIMIZE_ACROSS_TRIPS');
3844: l_oat_string := fnd_message.get;
3845:
3846: -- submit the concurrent request 'Optimize Across Trips'
3847: x_conc_request_id := fnd_request.submit_request (

Line 3844: l_oat_string := fnd_message.get;

3840: RAISE fnd_api.g_exc_unexpected_error;
3841: END IF;
3842:
3843: fnd_message.set_name('CSR','OPTIMIZE_ACROSS_TRIPS');
3844: l_oat_string := fnd_message.get;
3845:
3846: -- submit the concurrent request 'Optimize Across Trips'
3847: x_conc_request_id := fnd_request.submit_request (
3848: application => 'CSR'

Line 3969: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');

3965: IF (l_shift_tasks_exist = 'Y' or l_trip_exist = 'Y') THEN
3966: IF l_debug THEN
3967: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
3968: END IF;
3969: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
3970: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3971: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3972: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
3973: fnd_msg_pub.ADD;

Line 3970: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

3966: IF l_debug THEN
3967: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
3968: END IF;
3969: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
3970: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3971: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3972: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
3973: fnd_msg_pub.ADD;
3974: RAISE fnd_api.g_exc_error;

Line 3971: fnd_message.set_token('START_TIME', format_date(p_start_date_time));

3967: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
3968: END IF;
3969: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
3970: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3971: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3972: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
3973: fnd_msg_pub.ADD;
3974: RAISE fnd_api.g_exc_error;
3975: END IF;

Line 3972: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

3968: END IF;
3969: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
3970: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3971: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3972: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
3973: fnd_msg_pub.ADD;
3974: RAISE fnd_api.g_exc_error;
3975: END IF;
3976:

Line 4010: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');

4006: , x_msg_data => x_msg_data
4007: , x_msg_count => x_msg_count);
4008:
4009: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4010: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4011: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
4012: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

Line 4011: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

4007: , x_msg_count => x_msg_count);
4008:
4009: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4010: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4011: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
4012: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4015: fnd_msg_pub.ADD;

Line 4012: fnd_message.set_token('START_TIME', format_date(p_start_date_time));

4008:
4009: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4010: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4011: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
4012: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4015: fnd_msg_pub.ADD;
4016: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

4009: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4010: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4011: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
4012: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4015: fnd_msg_pub.ADD;
4016: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4017: RAISE fnd_api.g_exc_unexpected_error;

Line 4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4010: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4011: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
4012: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4015: fnd_msg_pub.ADD;
4016: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4017: RAISE fnd_api.g_exc_unexpected_error;
4018: END IF;

Line 4126: fnd_message.set_name('CSF', 'CSF_TRIP_LENGTH_MORE_THAN_DAY');

4122: THEN
4123: IF l_debug THEN
4124: debug(' The specified Trip Length is greater than one day', l_api_name, fnd_log.level_error);
4125: END IF;
4126: fnd_message.set_name('CSF', 'CSF_TRIP_LENGTH_MORE_THAN_DAY');
4127: fnd_msg_pub.ADD;
4128: RAISE fnd_api.g_exc_error;
4129: END IF;
4130:

Line 4344: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');

4340: , x_task_id => x_dep_task_id
4341: );
4342:
4343: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4344: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4345: fnd_message.set_token('TASK_NAME', g_dep_task_name);
4346: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4347: fnd_msg_pub.ADD;
4348:

Line 4345: fnd_message.set_token('TASK_NAME', g_dep_task_name);

4341: );
4342:
4343: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4344: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4345: fnd_message.set_token('TASK_NAME', g_dep_task_name);
4346: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4347: fnd_msg_pub.ADD;
4348:
4349: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4346: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4342:
4343: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4344: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4345: fnd_message.set_token('TASK_NAME', g_dep_task_name);
4346: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4347: fnd_msg_pub.ADD;
4348:
4349: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4350: RAISE fnd_api.g_exc_unexpected_error;

Line 4387: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');

4383: , x_task_id => x_arr_task_id
4384: );
4385:
4386: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4387: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4388: fnd_message.set_token('TASK_NAME', g_arr_task_name);
4389: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4390: fnd_msg_pub.ADD;
4391:

Line 4388: fnd_message.set_token('TASK_NAME', g_arr_task_name);

4384: );
4385:
4386: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4387: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4388: fnd_message.set_token('TASK_NAME', g_arr_task_name);
4389: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4390: fnd_msg_pub.ADD;
4391:
4392: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4389: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4385:
4386: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4387: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4388: fnd_message.set_token('TASK_NAME', g_arr_task_name);
4389: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4390: fnd_msg_pub.ADD;
4391:
4392: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4393: RAISE fnd_api.g_exc_unexpected_error;

Line 4472: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

4468: x_return_status := fnd_api.g_ret_sts_success;
4469:
4470: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
4471: -- Invalid Trip ID passed.
4472: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4473: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4474: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
4475: fnd_msg_pub.ADD;
4476: RAISE fnd_api.g_exc_error;

Line 4473: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

4469:
4470: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
4471: -- Invalid Trip ID passed.
4472: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4473: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4474: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
4475: fnd_msg_pub.ADD;
4476: RAISE fnd_api.g_exc_error;
4477: END IF;

Line 4474: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');

4470: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
4471: -- Invalid Trip ID passed.
4472: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4473: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4474: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
4475: fnd_msg_pub.ADD;
4476: RAISE fnd_api.g_exc_error;
4477: END IF;
4478:

Line 4481: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

4477: END IF;
4478:
4479: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
4480: -- Invalid Object Version Number passed.
4481: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4482: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4483: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
4484: fnd_msg_pub.ADD;
4485: RAISE fnd_api.g_exc_error;

Line 4482: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

4478:
4479: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
4480: -- Invalid Object Version Number passed.
4481: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4482: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4483: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
4484: fnd_msg_pub.ADD;
4485: RAISE fnd_api.g_exc_error;
4486: END IF;

Line 4483: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');

4479: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
4480: -- Invalid Object Version Number passed.
4481: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4482: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4483: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
4484: fnd_msg_pub.ADD;
4485: RAISE fnd_api.g_exc_error;
4486: END IF;
4487:

Line 4490: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

4486: END IF;
4487:
4488: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
4489: -- Error out as both cant be passed.
4490: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4491: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4492: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
4493: fnd_msg_pub.ADD;
4494: RAISE fnd_api.g_exc_error;

Line 4491: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);

4487:
4488: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
4489: -- Error out as both cant be passed.
4490: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4491: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4492: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
4493: fnd_msg_pub.ADD;
4494: RAISE fnd_api.g_exc_error;
4495: END IF;

Line 4492: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');

4488: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
4489: -- Error out as both cant be passed.
4490: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4491: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4492: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
4493: fnd_msg_pub.ADD;
4494: RAISE fnd_api.g_exc_error;
4495: END IF;
4496:

Line 4501: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');

4497:
4498:
4499: l_trip := get_trip(p_trip_id);
4500: IF l_trip.trip_id IS NULL THEN
4501: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
4502: fnd_message.set_token('TRIP_ID', p_trip_id);
4503: fnd_msg_pub.ADD;
4504: RAISE fnd_api.g_exc_error;
4505: END IF;

Line 4502: fnd_message.set_token('TRIP_ID', p_trip_id);

4498:
4499: l_trip := get_trip(p_trip_id);
4500: IF l_trip.trip_id IS NULL THEN
4501: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
4502: fnd_message.set_token('TRIP_ID', p_trip_id);
4503: fnd_msg_pub.ADD;
4504: RAISE fnd_api.g_exc_error;
4505: END IF;
4506:

Line 4520: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');

4516: IF (l_trip_exist = 'Y') THEN
4517: IF l_debug THEN
4518: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
4519: END IF;
4520: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
4521: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id,l_trip.resource_type));
4522: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4523: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4524: fnd_msg_pub.ADD;

Line 4521: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id,l_trip.resource_type));

4517: IF l_debug THEN
4518: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
4519: END IF;
4520: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
4521: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id,l_trip.resource_type));
4522: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4523: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4524: fnd_msg_pub.ADD;
4525: RAISE fnd_api.g_exc_error;

Line 4522: fnd_message.set_token('START_TIME', format_date(p_start_date_time));

4518: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
4519: END IF;
4520: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
4521: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id,l_trip.resource_type));
4522: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4523: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4524: fnd_msg_pub.ADD;
4525: RAISE fnd_api.g_exc_error;
4526: END IF;

Line 4523: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

4519: END IF;
4520: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
4521: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id,l_trip.resource_type));
4522: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4523: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4524: fnd_msg_pub.ADD;
4525: RAISE fnd_api.g_exc_error;
4526: END IF;
4527:

Line 4545: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');

4541: , p_end_date => p_end_date_time
4542: );
4543:
4544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4545: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
4546: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
4547: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

Line 4546: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));

4542: );
4543:
4544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4545: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
4546: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
4547: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4550: fnd_msg_pub.ADD;

Line 4547: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));

4543:
4544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4545: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
4546: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
4547: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4550: fnd_msg_pub.ADD;
4551: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));

4544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4545: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
4546: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
4547: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4550: fnd_msg_pub.ADD;
4551: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4552: RAISE fnd_api.g_exc_unexpected_error;

Line 4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4545: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
4546: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
4547: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4550: fnd_msg_pub.ADD;
4551: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4552: RAISE fnd_api.g_exc_unexpected_error;
4553: END IF;

Line 4759: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');

4755: --RAISE fnd_api.g_exc_error;
4756: --END IF;
4757:
4758: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4759: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4760: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type));
4761: fnd_message.set_token('START_TIME', format_date(p_start_date));
4762: fnd_message.set_token('END_TIME', format_date(p_end_date));
4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

Line 4760: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type));

4756: --END IF;
4757:
4758: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4759: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4760: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type));
4761: fnd_message.set_token('START_TIME', format_date(p_start_date));
4762: fnd_message.set_token('END_TIME', format_date(p_end_date));
4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4764: fnd_msg_pub.ADD;

Line 4761: fnd_message.set_token('START_TIME', format_date(p_start_date));

4757:
4758: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4759: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4760: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type));
4761: fnd_message.set_token('START_TIME', format_date(p_start_date));
4762: fnd_message.set_token('END_TIME', format_date(p_end_date));
4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4764: fnd_msg_pub.ADD;
4765: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4762: fnd_message.set_token('END_TIME', format_date(p_end_date));

4758: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4759: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4760: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type));
4761: fnd_message.set_token('START_TIME', format_date(p_start_date));
4762: fnd_message.set_token('END_TIME', format_date(p_end_date));
4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4764: fnd_msg_pub.ADD;
4765: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4766: RAISE fnd_api.g_exc_unexpected_error;

Line 4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4759: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4760: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type));
4761: fnd_message.set_token('START_TIME', format_date(p_start_date));
4762: fnd_message.set_token('END_TIME', format_date(p_end_date));
4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4764: fnd_msg_pub.ADD;
4765: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4766: RAISE fnd_api.g_exc_unexpected_error;
4767: END IF;