APPS.CSF_TRIPS_PUB dependencies on FND_MESSAGE

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

200: l_failed := 0;
201:
202: FOR i IN 1..g_messages.COUNT LOOP
203: IF g_messages(i).message_type IN (g_error_message, g_warning_message) THEN
204: fnd_message.set_name('CSF', NVL(g_messages(i).message_name, 'CSF_PROCESS_TRIP_FAILED'));
205:
206: IF g_messages(i).resource_id IS NOT NULL THEN
207: IF g_suppress_res_info = TRUE THEN
208: fnd_message.set_token('RESOURCE', '');

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

204: fnd_message.set_name('CSF', NVL(g_messages(i).message_name, 'CSF_PROCESS_TRIP_FAILED'));
205:
206: IF g_messages(i).resource_id IS NOT NULL THEN
207: IF g_suppress_res_info = TRUE THEN
208: fnd_message.set_token('RESOURCE', '');
209: ELSE
210: fnd_message.set_token('RESOURCE', get_resource_info(g_messages(i).resource_id, g_messages(i).resource_type));
211: END IF;
212: END IF;

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

206: IF g_messages(i).resource_id IS NOT NULL THEN
207: IF g_suppress_res_info = TRUE THEN
208: fnd_message.set_token('RESOURCE', '');
209: ELSE
210: fnd_message.set_token('RESOURCE', get_resource_info(g_messages(i).resource_id, g_messages(i).resource_type));
211: END IF;
212: END IF;
213:
214: IF g_messages(i).start_datetime IS NOT NULL THEN

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

211: END IF;
212: END IF;
213:
214: IF g_messages(i).start_datetime IS NOT NULL THEN
215: fnd_message.set_token('START_TIME', format_date(g_messages(i).start_datetime));
216: END IF;
217:
218: IF g_messages(i).end_datetime IS NOT NULL THEN
219: fnd_message.set_token('END_TIME', format_date(g_messages(i).end_datetime));

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

215: fnd_message.set_token('START_TIME', format_date(g_messages(i).start_datetime));
216: END IF;
217:
218: IF g_messages(i).end_datetime IS NOT NULL THEN
219: fnd_message.set_token('END_TIME', format_date(g_messages(i).end_datetime));
220: END IF;
221:
222: IF g_messages(i).error_reason IS NOT NULL THEN
223: fnd_message.set_token('REASON', g_messages(i).error_reason);

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

219: fnd_message.set_token('END_TIME', format_date(g_messages(i).end_datetime));
220: END IF;
221:
222: IF g_messages(i).error_reason IS NOT NULL THEN
223: fnd_message.set_token('REASON', g_messages(i).error_reason);
224: END IF;
225:
226: fnd_msg_pub.ADD;
227:

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

264: l_res_name := '';
265: END IF;
266:
267: IF l_failed > 0 THEN
268: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_WARN');
269: fnd_message.set_token('FAILED', l_failed);
270: ELSE
271: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
272: END IF;

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

265: END IF;
266:
267: IF l_failed > 0 THEN
268: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_WARN');
269: fnd_message.set_token('FAILED', l_failed);
270: ELSE
271: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
272: END IF;
273:

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

267: IF l_failed > 0 THEN
268: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_WARN');
269: fnd_message.set_token('FAILED', l_failed);
270: ELSE
271: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
272: END IF;
273:
274: fnd_message.set_token('SUCCESS', l_success);
275: fnd_message.set_token('ACTION', l_action_name);

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

270: ELSE
271: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
272: END IF;
273:
274: fnd_message.set_token('SUCCESS', l_success);
275: fnd_message.set_token('ACTION', l_action_name);
276: fnd_message.set_token('RESOURCE', l_res_name);
277: fnd_message.set_token('START_DATE', p_start_date);
278: fnd_message.set_token('END_DATE', p_end_date);

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

271: fnd_message.set_name('CSF', 'CSF_TRIPS_ACTION_SUCC');
272: END IF;
273:
274: fnd_message.set_token('SUCCESS', l_success);
275: fnd_message.set_token('ACTION', l_action_name);
276: fnd_message.set_token('RESOURCE', l_res_name);
277: fnd_message.set_token('START_DATE', p_start_date);
278: fnd_message.set_token('END_DATE', p_end_date);
279: fnd_msg_pub.ADD;

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

272: END IF;
273:
274: fnd_message.set_token('SUCCESS', l_success);
275: fnd_message.set_token('ACTION', l_action_name);
276: fnd_message.set_token('RESOURCE', l_res_name);
277: fnd_message.set_token('START_DATE', p_start_date);
278: fnd_message.set_token('END_DATE', p_end_date);
279: fnd_msg_pub.ADD;
280: END process_messages;

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

273:
274: fnd_message.set_token('SUCCESS', l_success);
275: fnd_message.set_token('ACTION', l_action_name);
276: fnd_message.set_token('RESOURCE', l_res_name);
277: fnd_message.set_token('START_DATE', p_start_date);
278: fnd_message.set_token('END_DATE', p_end_date);
279: fnd_msg_pub.ADD;
280: END process_messages;
281:

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

274: fnd_message.set_token('SUCCESS', l_success);
275: fnd_message.set_token('ACTION', l_action_name);
276: fnd_message.set_token('RESOURCE', l_res_name);
277: fnd_message.set_token('START_DATE', p_start_date);
278: fnd_message.set_token('END_DATE', p_end_date);
279: fnd_msg_pub.ADD;
280: END process_messages;
281:
282: PROCEDURE init_package IS

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

459: IF l_debug THEN
460: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
461: debug(' CSF_RESOURCE_ADDRESS_PVT failed to give Party Site ID' || x_msg_data, l_api_name, fnd_log.level_error);
462: END IF;
463: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
464: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
465: fnd_message.set_token('DATE', format_date(p_start_date_time));
466: fnd_msg_pub.ADD;
467: RAISE fnd_api.g_exc_error;

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

460: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
461: debug(' CSF_RESOURCE_ADDRESS_PVT failed to give Party Site ID' || x_msg_data, l_api_name, fnd_log.level_error);
462: END IF;
463: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
464: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
465: fnd_message.set_token('DATE', format_date(p_start_date_time));
466: fnd_msg_pub.ADD;
467: RAISE fnd_api.g_exc_error;
468: END IF;

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

461: debug(' CSF_RESOURCE_ADDRESS_PVT failed to give Party Site ID' || x_msg_data, l_api_name, fnd_log.level_error);
462: END IF;
463: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
464: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
465: fnd_message.set_token('DATE', format_date(p_start_date_time));
466: fnd_msg_pub.ADD;
467: RAISE fnd_api.g_exc_error;
468: END IF;
469:

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

498: , x_task_id => x_dep_task_id
499: );
500:
501: IF x_return_status <> fnd_api.g_ret_sts_success THEN
502: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
503: fnd_message.set_token('TASK_NAME', g_dep_task_name);
504: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
505: fnd_msg_pub.ADD;
506:

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

499: );
500:
501: IF x_return_status <> fnd_api.g_ret_sts_success THEN
502: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
503: fnd_message.set_token('TASK_NAME', g_dep_task_name);
504: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
505: fnd_msg_pub.ADD;
506:
507: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

500:
501: IF x_return_status <> fnd_api.g_ret_sts_success THEN
502: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
503: fnd_message.set_token('TASK_NAME', g_dep_task_name);
504: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
505: fnd_msg_pub.ADD;
506:
507: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
508: RAISE fnd_api.g_exc_unexpected_error;

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

541: , x_task_id => x_arr_task_id
542: );
543:
544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
545: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
546: fnd_message.set_token('TASK_NAME', g_arr_task_name);
547: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
548: fnd_msg_pub.ADD;
549:

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

542: );
543:
544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
545: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
546: fnd_message.set_token('TASK_NAME', g_arr_task_name);
547: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
548: fnd_msg_pub.ADD;
549:
550: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

543:
544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
545: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
546: fnd_message.set_token('TASK_NAME', g_arr_task_name);
547: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
548: fnd_msg_pub.ADD;
549:
550: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
551: RAISE fnd_api.g_exc_unexpected_error;

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

670: IF l_available_hours > g_hours_in_day THEN
671: IF l_debug THEN
672: debug(' The specified Trip Length is greater than one day', l_api_name, fnd_log.level_error);
673: END IF;
674: fnd_message.set_name('CSF', 'CSF_TRIP_LENGTH_MORE_THAN_DAY');
675: fnd_msg_pub.ADD;
676: RAISE fnd_api.g_exc_error;
677: END IF;
678:

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

904: IF l_debug THEN
905: debug(' Trip Availability is more than Shift Length', l_api_name, fnd_log.level_error);
906: END IF;
907:
908: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
909: fnd_message.set_token('AVAILABLE', l_available_hours);
910: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
911: fnd_message.set_token('AVLAFTER', l_available_hours_after);
912: fnd_msg_pub.ADD;

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

905: debug(' Trip Availability is more than Shift Length', l_api_name, fnd_log.level_error);
906: END IF;
907:
908: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
909: fnd_message.set_token('AVAILABLE', l_available_hours);
910: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
911: fnd_message.set_token('AVLAFTER', l_available_hours_after);
912: fnd_msg_pub.ADD;
913: RAISE fnd_api.g_exc_error;

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

906: END IF;
907:
908: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
909: fnd_message.set_token('AVAILABLE', l_available_hours);
910: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
911: fnd_message.set_token('AVLAFTER', l_available_hours_after);
912: fnd_msg_pub.ADD;
913: RAISE fnd_api.g_exc_error;
914: END IF;

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

907:
908: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
909: fnd_message.set_token('AVAILABLE', l_available_hours);
910: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
911: fnd_message.set_token('AVLAFTER', l_available_hours_after);
912: fnd_msg_pub.ADD;
913: RAISE fnd_api.g_exc_error;
914: END IF;
915:

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

922: IF l_debug THEN
923: debug(' Available Hours Before and After must be NULL when Availability is Trip Length', l_api_name, fnd_log.level_error);
924: END IF;
925:
926: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
927: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
928: fnd_message.set_token('AVLAFTER', l_available_hours_after);
929: fnd_message.set_token('AVAILABLE', l_available_hours);
930: fnd_msg_pub.ADD;

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

923: debug(' Available Hours Before and After must be NULL when Availability is Trip Length', l_api_name, fnd_log.level_error);
924: END IF;
925:
926: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
927: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
928: fnd_message.set_token('AVLAFTER', l_available_hours_after);
929: fnd_message.set_token('AVAILABLE', l_available_hours);
930: fnd_msg_pub.ADD;
931: RAISE fnd_api.g_exc_error;

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

924: END IF;
925:
926: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
927: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
928: fnd_message.set_token('AVLAFTER', l_available_hours_after);
929: fnd_message.set_token('AVAILABLE', l_available_hours);
930: fnd_msg_pub.ADD;
931: RAISE fnd_api.g_exc_error;
932: END IF;

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

925:
926: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
927: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
928: fnd_message.set_token('AVLAFTER', l_available_hours_after);
929: fnd_message.set_token('AVAILABLE', l_available_hours);
930: fnd_msg_pub.ADD;
931: RAISE fnd_api.g_exc_error;
932: END IF;
933:

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

999: x_msg_data := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);
1000: IF l_debug THEN
1001: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1002: END IF;
1003: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1004: fnd_message.set_token('TASK', v_task.task_number);
1005: fnd_message.set_token('REASON', x_msg_data);
1006: fnd_msg_pub.ADD;
1007: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

1000: IF l_debug THEN
1001: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1002: END IF;
1003: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1004: fnd_message.set_token('TASK', v_task.task_number);
1005: fnd_message.set_token('REASON', x_msg_data);
1006: fnd_msg_pub.ADD;
1007: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1008: RAISE fnd_api.g_exc_unexpected_error;

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

1001: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1002: END IF;
1003: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1004: fnd_message.set_token('TASK', v_task.task_number);
1005: fnd_message.set_token('REASON', x_msg_data);
1006: fnd_msg_pub.ADD;
1007: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1008: RAISE fnd_api.g_exc_unexpected_error;
1009: END IF;

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

1072: IF l_debug THEN
1073: debug(' The Trip is unavailable and so cant be deleted', l_api_name, fnd_log.level_error);
1074: END IF;
1075:
1076: fnd_message.set_name('CSF', 'CSF_TRIP_IS_BLOCKED');
1077: fnd_msg_pub.ADD;
1078: RAISE fnd_api.g_exc_error;
1079: END IF;
1080:

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

1085: IF l_debug THEN
1086: debug(' Trip has active Tasks and so cant be deleted', l_api_name, fnd_log.level_error);
1087: END IF;
1088:
1089: fnd_message.set_name('CSF', 'CSF_TRIP_HAS_ACTIVE_TASKS');
1090: fnd_msg_pub.ADD;
1091: RAISE fnd_api.g_exc_error;
1092: END IF;
1093: END IF;

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

1109: IF l_debug THEN
1110: debug(' Unable to Delete the Shift Task - ' || v_shift_task.task_name, l_api_name, fnd_log.level_error);
1111: END IF;
1112:
1113: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1114: fnd_message.set_token('TASK', v_shift_task.task_number);
1115: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1116: fnd_msg_pub.ADD;
1117: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

1110: debug(' Unable to Delete the Shift Task - ' || v_shift_task.task_name, l_api_name, fnd_log.level_error);
1111: END IF;
1112:
1113: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1114: fnd_message.set_token('TASK', v_shift_task.task_number);
1115: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1116: fnd_msg_pub.ADD;
1117: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1118: RAISE fnd_api.g_exc_unexpected_error;

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

1111: END IF;
1112:
1113: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1114: fnd_message.set_token('TASK', v_shift_task.task_number);
1115: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1116: fnd_msg_pub.ADD;
1117: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1118: RAISE fnd_api.g_exc_unexpected_error;
1119: END IF;

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

1300: IF l_debug THEN
1301: debug(' Unable to Delete the Task', l_api_name, fnd_log.level_error);
1302: END IF;
1303:
1304: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1305: fnd_message.set_token('TASK', v_shift_task.task_number);
1306: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1307: fnd_msg_pub.ADD;
1308: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

1301: debug(' Unable to Delete the Task', l_api_name, fnd_log.level_error);
1302: END IF;
1303:
1304: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1305: fnd_message.set_token('TASK', v_shift_task.task_number);
1306: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1307: fnd_msg_pub.ADD;
1308: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1309: RAISE fnd_api.g_exc_unexpected_error;

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

1302: END IF;
1303:
1304: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1305: fnd_message.set_token('TASK', v_shift_task.task_number);
1306: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1307: fnd_msg_pub.ADD;
1308: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1309: RAISE fnd_api.g_exc_unexpected_error;
1310: END IF;

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

1366: , p_abort_workflow => fnd_api.g_miss_char
1367: );
1368:
1369: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1370: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1371: fnd_message.set_token('TASK', v_task.task_number);
1372: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1373: fnd_msg_pub.ADD;
1374: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

1367: );
1368:
1369: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1370: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1371: fnd_message.set_token('TASK', v_task.task_number);
1372: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1373: fnd_msg_pub.ADD;
1374: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1375: RAISE fnd_api.g_exc_unexpected_error;

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

1368:
1369: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1370: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1371: fnd_message.set_token('TASK', v_task.task_number);
1372: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1373: fnd_msg_pub.ADD;
1374: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1375: RAISE fnd_api.g_exc_unexpected_error;
1376: END IF;

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

2424: IF l_trips.COUNT > 0 THEN
2425: IF l_debug THEN
2426: debug(' Trips already exists for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2427: END IF;
2428: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
2429: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2430: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2431: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2432: fnd_msg_pub.ADD;

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

2425: IF l_debug THEN
2426: debug(' Trips already exists for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2427: END IF;
2428: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
2429: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2430: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2431: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2432: fnd_msg_pub.ADD;
2433: RAISE fnd_api.g_exc_error;

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

2426: debug(' Trips already exists for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2427: END IF;
2428: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
2429: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2430: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2431: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2432: fnd_msg_pub.ADD;
2433: RAISE fnd_api.g_exc_error;
2434: END IF;

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

2427: END IF;
2428: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
2429: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2430: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2431: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2432: fnd_msg_pub.ADD;
2433: RAISE fnd_api.g_exc_error;
2434: END IF;
2435:

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

2448: IF l_shift_tasks_exist = 'Y' THEN
2449: IF l_debug THEN
2450: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2451: END IF;
2452: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
2453: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2454: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2455: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2456: fnd_msg_pub.ADD;

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

2449: IF l_debug THEN
2450: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2451: END IF;
2452: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
2453: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2454: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2455: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2456: fnd_msg_pub.ADD;
2457: RAISE fnd_api.g_exc_error;

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

2450: debug(' Shift Tasks exist for the Resource in the specified interval', l_api_name, fnd_log.level_error);
2451: END IF;
2452: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
2453: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2454: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2455: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2456: fnd_msg_pub.ADD;
2457: RAISE fnd_api.g_exc_error;
2458: END IF;

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

2451: END IF;
2452: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
2453: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2454: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2455: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2456: fnd_msg_pub.ADD;
2457: RAISE fnd_api.g_exc_error;
2458: END IF;
2459:

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

2472: , x_trip => l_new_trip
2473: );
2474:
2475: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2476: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2477: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2478: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2479: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2480: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

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

2473: );
2474:
2475: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2476: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2477: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2478: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2479: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2480: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2481: fnd_msg_pub.ADD;

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

2474:
2475: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2476: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2477: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2478: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2479: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2480: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2481: fnd_msg_pub.ADD;
2482: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

2475: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2476: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2477: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2478: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2479: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2480: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2481: fnd_msg_pub.ADD;
2482: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2483: RAISE fnd_api.g_exc_unexpected_error;

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

2476: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2477: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2478: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2479: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2480: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2481: fnd_msg_pub.ADD;
2482: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2483: RAISE fnd_api.g_exc_unexpected_error;
2484: END IF;

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

2545: x_return_status := fnd_api.g_ret_sts_success;
2546:
2547: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2548: -- Invalid Trip ID passed.
2549: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2550: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2551: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2552: fnd_msg_pub.ADD;
2553: RAISE fnd_api.g_exc_error;

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

2546:
2547: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2548: -- Invalid Trip ID passed.
2549: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2550: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2551: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2552: fnd_msg_pub.ADD;
2553: RAISE fnd_api.g_exc_error;
2554: END IF;

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

2547: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2548: -- Invalid Trip ID passed.
2549: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2550: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2551: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2552: fnd_msg_pub.ADD;
2553: RAISE fnd_api.g_exc_error;
2554: END IF;
2555:

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

2554: END IF;
2555:
2556: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2557: -- Invalid Object Version Number passed.
2558: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2559: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2560: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2561: fnd_msg_pub.ADD;
2562: RAISE fnd_api.g_exc_error;

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

2555:
2556: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2557: -- Invalid Object Version Number passed.
2558: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2559: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2560: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2561: fnd_msg_pub.ADD;
2562: RAISE fnd_api.g_exc_error;
2563: END IF;

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

2556: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2557: -- Invalid Object Version Number passed.
2558: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2559: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2560: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2561: fnd_msg_pub.ADD;
2562: RAISE fnd_api.g_exc_error;
2563: END IF;
2564:

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

2563: END IF;
2564:
2565: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
2566: -- Error out as both cant be passed.
2567: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2568: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2569: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
2570: fnd_msg_pub.ADD;
2571: RAISE fnd_api.g_exc_error;

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

2564:
2565: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
2566: -- Error out as both cant be passed.
2567: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2568: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2569: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
2570: fnd_msg_pub.ADD;
2571: RAISE fnd_api.g_exc_error;
2572: END IF;

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

2565: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
2566: -- Error out as both cant be passed.
2567: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2568: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2569: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
2570: fnd_msg_pub.ADD;
2571: RAISE fnd_api.g_exc_error;
2572: END IF;
2573:

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

2572: END IF;
2573:
2574: l_trip := get_trip(p_trip_id);
2575: IF l_trip.trip_id IS NULL THEN
2576: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2577: fnd_message.set_token('TRIP_ID', p_trip_id);
2578: fnd_msg_pub.ADD;
2579: RAISE fnd_api.g_exc_error;
2580: END IF;

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

2573:
2574: l_trip := get_trip(p_trip_id);
2575: IF l_trip.trip_id IS NULL THEN
2576: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2577: fnd_message.set_token('TRIP_ID', p_trip_id);
2578: fnd_msg_pub.ADD;
2579: RAISE fnd_api.g_exc_error;
2580: END IF;
2581:

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

2592: , p_status => p_status
2593: );
2594:
2595: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2596: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2597: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2598: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2599: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2600: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

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

2593: );
2594:
2595: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2596: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2597: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2598: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2599: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2600: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2601: fnd_msg_pub.ADD;

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

2594:
2595: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2596: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2597: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2598: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2599: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2600: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2601: fnd_msg_pub.ADD;
2602: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

2595: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2596: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2597: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2598: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2599: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2600: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2601: fnd_msg_pub.ADD;
2602: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2603: RAISE fnd_api.g_exc_unexpected_error;

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

2596: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2597: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2598: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2599: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2600: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2601: fnd_msg_pub.ADD;
2602: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2603: RAISE fnd_api.g_exc_unexpected_error;
2604: END IF;

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

2663: END IF;
2664:
2665: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2666: -- Invalid Trip ID passed.
2667: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2668: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2669: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2670: fnd_msg_pub.ADD;
2671: RAISE fnd_api.g_exc_error;

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

2664:
2665: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2666: -- Invalid Trip ID passed.
2667: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2668: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2669: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2670: fnd_msg_pub.ADD;
2671: RAISE fnd_api.g_exc_error;
2672: END IF;

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

2665: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2666: -- Invalid Trip ID passed.
2667: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2668: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2669: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2670: fnd_msg_pub.ADD;
2671: RAISE fnd_api.g_exc_error;
2672: END IF;
2673:

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

2672: END IF;
2673:
2674: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2675: -- Invalid Object Version Number passed.
2676: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2677: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2678: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2679: fnd_msg_pub.ADD;
2680: RAISE fnd_api.g_exc_error;

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

2673:
2674: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2675: -- Invalid Object Version Number passed.
2676: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2677: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2678: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2679: fnd_msg_pub.ADD;
2680: RAISE fnd_api.g_exc_error;
2681: END IF;

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

2674: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2675: -- Invalid Object Version Number passed.
2676: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2677: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2678: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2679: fnd_msg_pub.ADD;
2680: RAISE fnd_api.g_exc_error;
2681: END IF;
2682:

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

2682:
2683: l_trip := get_trip(p_trip_id);
2684: -- No Trips found for the given Trip ID
2685: IF l_trip.trip_id IS NULL THEN
2686: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2687: fnd_message.set_token('TRIP_ID', p_trip_id);
2688: fnd_msg_pub.ADD;
2689: RAISE fnd_api.g_exc_error;
2690: END IF;

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

2683: l_trip := get_trip(p_trip_id);
2684: -- No Trips found for the given Trip ID
2685: IF l_trip.trip_id IS NULL THEN
2686: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2687: fnd_message.set_token('TRIP_ID', p_trip_id);
2688: fnd_msg_pub.ADD;
2689: RAISE fnd_api.g_exc_error;
2690: END IF;
2691:

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

2702: debug( ' Unable to delete the Trip: Error = '
2703: || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2704: , l_api_name, fnd_log.level_error);
2705: END IF;
2706: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2707: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2708: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2709: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2710: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

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

2703: || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2704: , l_api_name, fnd_log.level_error);
2705: END IF;
2706: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2707: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2708: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2709: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2710: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2711: fnd_msg_pub.ADD;

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

2704: , l_api_name, fnd_log.level_error);
2705: END IF;
2706: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2707: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2708: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2709: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2710: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2711: fnd_msg_pub.ADD;
2712: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

2705: END IF;
2706: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2707: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2708: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2709: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2710: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2711: fnd_msg_pub.ADD;
2712: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2713: RAISE fnd_api.g_exc_unexpected_error;

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

2706: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2707: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2708: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2709: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2710: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2711: fnd_msg_pub.ADD;
2712: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2713: RAISE fnd_api.g_exc_unexpected_error;
2714: END IF;

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

2774: END IF;
2775:
2776: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2777: -- Invalid Trip ID passed.
2778: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2779: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2780: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2781: fnd_msg_pub.ADD;
2782: RAISE fnd_api.g_exc_error;

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

2775:
2776: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2777: -- Invalid Trip ID passed.
2778: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2779: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2780: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2781: fnd_msg_pub.ADD;
2782: RAISE fnd_api.g_exc_error;
2783: END IF;

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

2776: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2777: -- Invalid Trip ID passed.
2778: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2779: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2780: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2781: fnd_msg_pub.ADD;
2782: RAISE fnd_api.g_exc_error;
2783: END IF;
2784:

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

2783: END IF;
2784:
2785: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2786: -- Invalid Object Version Number passed.
2787: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2788: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2789: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2790: fnd_msg_pub.ADD;
2791: RAISE fnd_api.g_exc_error;

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

2784:
2785: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2786: -- Invalid Object Version Number passed.
2787: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2788: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2789: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2790: fnd_msg_pub.ADD;
2791: RAISE fnd_api.g_exc_error;
2792: END IF;

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

2785: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2786: -- Invalid Object Version Number passed.
2787: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2788: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2789: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2790: fnd_msg_pub.ADD;
2791: RAISE fnd_api.g_exc_error;
2792: END IF;
2793:

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

2792: END IF;
2793:
2794: l_trip := get_trip(p_trip_id);
2795: IF l_trip.trip_id IS NULL THEN
2796: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2797: fnd_message.set_token('TRIP_ID', p_trip_id);
2798: fnd_msg_pub.ADD;
2799: RAISE fnd_api.g_exc_error;
2800: END IF;

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

2793:
2794: l_trip := get_trip(p_trip_id);
2795: IF l_trip.trip_id IS NULL THEN
2796: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2797: fnd_message.set_token('TRIP_ID', p_trip_id);
2798: fnd_msg_pub.ADD;
2799: RAISE fnd_api.g_exc_error;
2800: END IF;
2801:

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

2810: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2811: IF l_debug THEN
2812: debug(' Unable to fix the Trip', l_api_name, fnd_log.level_error);
2813: END IF;
2814: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
2815: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2816: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2817: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2818: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

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

2811: IF l_debug THEN
2812: debug(' Unable to fix the Trip', l_api_name, fnd_log.level_error);
2813: END IF;
2814: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
2815: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2816: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2817: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2818: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2819: fnd_msg_pub.ADD;

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

2812: debug(' Unable to fix the Trip', l_api_name, fnd_log.level_error);
2813: END IF;
2814: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
2815: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2816: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2817: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2818: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2819: fnd_msg_pub.ADD;
2820: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

2813: END IF;
2814: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
2815: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2816: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2817: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2818: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2819: fnd_msg_pub.ADD;
2820: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2821: RAISE fnd_api.g_exc_unexpected_error;

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

2814: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
2815: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2816: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2817: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2818: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2819: fnd_msg_pub.ADD;
2820: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2821: RAISE fnd_api.g_exc_unexpected_error;
2822: END IF;

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

2891: l_trips := find_trips(l_resource_tbl, p_start_date_time, p_end_date_time, p_overtime_flag);
2892:
2893: IF l_trips.COUNT = 0 OR l_trips.COUNT > 1 THEN
2894: IF l_trips.COUNT = 0 THEN
2895: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
2896: ELSE
2897: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
2898: END IF;
2899: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

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

2893: IF l_trips.COUNT = 0 OR l_trips.COUNT > 1 THEN
2894: IF l_trips.COUNT = 0 THEN
2895: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
2896: ELSE
2897: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
2898: END IF;
2899: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2900: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2901: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

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

2895: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
2896: ELSE
2897: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
2898: END IF;
2899: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2900: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2901: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2902: fnd_msg_pub.add;
2903: RAISE fnd_api.g_exc_error;

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

2896: ELSE
2897: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
2898: END IF;
2899: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2900: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2901: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2902: fnd_msg_pub.add;
2903: RAISE fnd_api.g_exc_error;
2904: END IF;

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

2897: fnd_message.set_name('CSF', 'CSF_MULTIPLE_TRIPS_FOUND');
2898: END IF;
2899: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2900: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2901: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2902: fnd_msg_pub.add;
2903: RAISE fnd_api.g_exc_error;
2904: END IF;
2905:

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

3115: l_param_name := 'P_END_DATE';
3116: END IF;
3117:
3118: IF l_param_name IS NOT NULL THEN
3119: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3120: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3121: fnd_message.set_token('PARAM_NAME', l_param_name);
3122: fnd_msg_pub.ADD;
3123: RAISE fnd_api.g_exc_error;

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

3116: END IF;
3117:
3118: IF l_param_name IS NOT NULL THEN
3119: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3120: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3121: fnd_message.set_token('PARAM_NAME', l_param_name);
3122: fnd_msg_pub.ADD;
3123: RAISE fnd_api.g_exc_error;
3124: END IF;

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

3117:
3118: IF l_param_name IS NOT NULL THEN
3119: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3120: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3121: fnd_message.set_token('PARAM_NAME', l_param_name);
3122: fnd_msg_pub.ADD;
3123: RAISE fnd_api.g_exc_error;
3124: END IF;
3125:

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

3132: END IF;
3133:
3134: IF l_trips.COUNT = 0 THEN
3135: IF p_trip_id IS NOT NULL THEN
3136: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
3137: fnd_message.set_token('TRIP_ID', p_trip_id);
3138: ELSE
3139: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3140: IF p_resource_tbl.COUNT = 1 THEN

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

3133:
3134: IF l_trips.COUNT = 0 THEN
3135: IF p_trip_id IS NOT NULL THEN
3136: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
3137: fnd_message.set_token('TRIP_ID', p_trip_id);
3138: ELSE
3139: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3140: IF p_resource_tbl.COUNT = 1 THEN
3141: fnd_message.set_token('RESOURCE', get_resource_info(

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

3135: IF p_trip_id IS NOT NULL THEN
3136: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
3137: fnd_message.set_token('TRIP_ID', p_trip_id);
3138: ELSE
3139: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3140: IF p_resource_tbl.COUNT = 1 THEN
3141: fnd_message.set_token('RESOURCE', get_resource_info(
3142: p_resource_tbl(1).resource_id
3143: , p_resource_tbl(1).resource_type

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

3137: fnd_message.set_token('TRIP_ID', p_trip_id);
3138: ELSE
3139: fnd_message.set_name('CSF', 'CSF_NO_TRIPS_FOUND');
3140: IF p_resource_tbl.COUNT = 1 THEN
3141: fnd_message.set_token('RESOURCE', get_resource_info(
3142: p_resource_tbl(1).resource_id
3143: , p_resource_tbl(1).resource_type
3144: ));
3145: END IF;

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

3142: p_resource_tbl(1).resource_id
3143: , p_resource_tbl(1).resource_type
3144: ));
3145: END IF;
3146: fnd_message.set_token('START_TIME', format_date(p_start_date));
3147: fnd_message.set_token('END_TIME', format_date(p_end_date));
3148: END IF;
3149: fnd_msg_pub.add;
3150: RAISE fnd_api.g_exc_error;

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

3143: , p_resource_tbl(1).resource_type
3144: ));
3145: END IF;
3146: fnd_message.set_token('START_TIME', format_date(p_start_date));
3147: fnd_message.set_token('END_TIME', format_date(p_end_date));
3148: END IF;
3149: fnd_msg_pub.add;
3150: RAISE fnd_api.g_exc_error;
3151: END IF;

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

3265: FROM csf_selected_resources_v
3266: ORDER BY resource_type, resource_id;
3267: BEGIN
3268: /******************* Concurrent Program Start Message *******************/
3269: fnd_message.set_name('CSF', 'CSF_GTR_CP_STARTED');
3270: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3271:
3272: init_package;
3273: g_suppress_res_info := TRUE;

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

3266: ORDER BY resource_type, resource_id;
3267: BEGIN
3268: /******************* Concurrent Program Start Message *******************/
3269: fnd_message.set_name('CSF', 'CSF_GTR_CP_STARTED');
3270: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3271:
3272: init_package;
3273: g_suppress_res_info := TRUE;
3274:

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

3310: l_end_date := l_end_date + (g_secs_in_day - 1) / g_secs_in_day;
3311:
3312: -- Concurrent Program Parameters
3313: IF p_resource_id IS NOT NULL AND p_resource_type IS NOT NULL THEN
3314: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS_RESOURCE');
3315: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3316:
3317: l_resource_info := fnd_message.get;
3318: l_resource_id_tbl := jtf_number_table();

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

3311:
3312: -- Concurrent Program Parameters
3313: IF p_resource_id IS NOT NULL AND p_resource_type IS NOT NULL THEN
3314: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS_RESOURCE');
3315: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3316:
3317: l_resource_info := fnd_message.get;
3318: l_resource_id_tbl := jtf_number_table();
3319: l_resource_id_tbl.extend(1);

Line 3317: l_resource_info := fnd_message.get;

3313: IF p_resource_id IS NOT NULL AND p_resource_type IS NOT NULL THEN
3314: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS_RESOURCE');
3315: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3316:
3317: l_resource_info := fnd_message.get;
3318: l_resource_id_tbl := jtf_number_table();
3319: l_resource_id_tbl.extend(1);
3320: l_resource_id_tbl(1) := p_resource_id;
3321:

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

3329: FETCH c_resources BULK COLLECT INTO l_resource_id_tbl, l_resource_type_tbl;
3330: CLOSE c_resources;
3331: END IF;
3332:
3333: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3334: fnd_message.set_token('ACTION', p_action);
3335: fnd_message.set_token('START_DATE', l_start_date);
3336: fnd_message.set_token('END_DATE', l_end_date);
3337: fnd_message.set_token('RESOURCE_INFO', l_resource_info);

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

3330: CLOSE c_resources;
3331: END IF;
3332:
3333: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3334: fnd_message.set_token('ACTION', p_action);
3335: fnd_message.set_token('START_DATE', l_start_date);
3336: fnd_message.set_token('END_DATE', l_end_date);
3337: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3338: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);

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

3331: END IF;
3332:
3333: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3334: fnd_message.set_token('ACTION', p_action);
3335: fnd_message.set_token('START_DATE', l_start_date);
3336: fnd_message.set_token('END_DATE', l_end_date);
3337: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3338: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3339:

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

3332:
3333: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3334: fnd_message.set_token('ACTION', p_action);
3335: fnd_message.set_token('START_DATE', l_start_date);
3336: fnd_message.set_token('END_DATE', l_end_date);
3337: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3338: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3339:
3340: /********************* Concurrent Program Execution *********************/

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

3333: fnd_message.set_name('CSF', 'CSF_GTR_CP_PARAMS');
3334: fnd_message.set_token('ACTION', p_action);
3335: fnd_message.set_token('START_DATE', l_start_date);
3336: fnd_message.set_token('END_DATE', l_end_date);
3337: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3338: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3339:
3340: /********************* Concurrent Program Execution *********************/
3341: l_resources_failed := 0;

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

3334: fnd_message.set_token('ACTION', p_action);
3335: fnd_message.set_token('START_DATE', l_start_date);
3336: fnd_message.set_token('END_DATE', l_end_date);
3337: fnd_message.set_token('RESOURCE_INFO', l_resource_info);
3338: debug(fnd_message.get, 'GENERATE_TRIPS', g_level_cp_output);
3339:
3340: /********************* Concurrent Program Execution *********************/
3341: l_resources_failed := 0;
3342: l_resources_success := 0;

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

3348: l_resource(1).resource_id := l_resource_id_tbl(i);
3349: l_resource(1).resource_type := l_resource_type_tbl(i);
3350:
3351: l_resource_info := get_resource_info(l_resource(1).resource_id, l_resource(1).resource_type);
3352: fnd_message.set_name('CSF', 'CSF_RESOURCE_PROCESSED');
3353: fnd_message.set_token('RESOURCE', l_resource_info);
3354: debug(fnd_message.get, 'GEN_RESOURCE_TRIPS', g_level_cp_output);
3355:
3356: process_action(

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

3349: l_resource(1).resource_type := l_resource_type_tbl(i);
3350:
3351: l_resource_info := get_resource_info(l_resource(1).resource_id, l_resource(1).resource_type);
3352: fnd_message.set_name('CSF', 'CSF_RESOURCE_PROCESSED');
3353: fnd_message.set_token('RESOURCE', l_resource_info);
3354: debug(fnd_message.get, 'GEN_RESOURCE_TRIPS', g_level_cp_output);
3355:
3356: process_action(
3357: p_api_version => 1.0

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

3350:
3351: l_resource_info := get_resource_info(l_resource(1).resource_id, l_resource(1).resource_type);
3352: fnd_message.set_name('CSF', 'CSF_RESOURCE_PROCESSED');
3353: fnd_message.set_token('RESOURCE', l_resource_info);
3354: debug(fnd_message.get, 'GEN_RESOURCE_TRIPS', g_level_cp_output);
3355:
3356: process_action(
3357: p_api_version => 1.0
3358: , p_init_msg_list => fnd_api.g_true

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

3388: debug(' ', '', g_level_cp_output);
3389:
3390: IF l_resources_failed > 0 THEN
3391: retcode := 1;
3392: fnd_message.set_name('CSF', 'CSF_CP_DONE_WARNING');
3393: ELSE
3394: retcode := 0;
3395: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
3396: END IF;

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

3391: retcode := 1;
3392: fnd_message.set_name('CSF', 'CSF_CP_DONE_WARNING');
3393: ELSE
3394: retcode := 0;
3395: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
3396: END IF;
3397:
3398: errbuf := fnd_message.get;
3399: debug(errbuf, l_api_name, g_level_cp_output);

Line 3398: errbuf := fnd_message.get;

3394: retcode := 0;
3395: fnd_message.set_name('CSF', 'CSF_CP_DONE_SUCCESS');
3396: END IF;
3397:
3398: errbuf := fnd_message.get;
3399: debug(errbuf, l_api_name, g_level_cp_output);
3400:
3401: debug(' ', '', g_level_cp_output);
3402: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');

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

3398: errbuf := fnd_message.get;
3399: debug(errbuf, l_api_name, g_level_cp_output);
3400:
3401: debug(' ', '', g_level_cp_output);
3402: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');
3403: fnd_message.set_token('NUMBER', l_resources_success);
3404: debug(fnd_message.get, l_api_name, g_level_cp_output);
3405:
3406: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');

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

3399: debug(errbuf, l_api_name, g_level_cp_output);
3400:
3401: debug(' ', '', g_level_cp_output);
3402: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');
3403: fnd_message.set_token('NUMBER', l_resources_success);
3404: debug(fnd_message.get, l_api_name, g_level_cp_output);
3405:
3406: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3407: fnd_message.set_token('NUMBER', l_resources_failed);

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

3400:
3401: debug(' ', '', g_level_cp_output);
3402: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');
3403: fnd_message.set_token('NUMBER', l_resources_success);
3404: debug(fnd_message.get, l_api_name, g_level_cp_output);
3405:
3406: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3407: fnd_message.set_token('NUMBER', l_resources_failed);
3408: debug(fnd_message.get, l_api_name, g_level_cp_output);

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

3402: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_SUCCESS');
3403: fnd_message.set_token('NUMBER', l_resources_success);
3404: debug(fnd_message.get, l_api_name, g_level_cp_output);
3405:
3406: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3407: fnd_message.set_token('NUMBER', l_resources_failed);
3408: debug(fnd_message.get, l_api_name, g_level_cp_output);
3409:
3410: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');

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

3403: fnd_message.set_token('NUMBER', l_resources_success);
3404: debug(fnd_message.get, l_api_name, g_level_cp_output);
3405:
3406: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3407: fnd_message.set_token('NUMBER', l_resources_failed);
3408: debug(fnd_message.get, l_api_name, g_level_cp_output);
3409:
3410: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3411: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);

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

3404: debug(fnd_message.get, l_api_name, g_level_cp_output);
3405:
3406: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3407: fnd_message.set_token('NUMBER', l_resources_failed);
3408: debug(fnd_message.get, l_api_name, g_level_cp_output);
3409:
3410: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3411: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);
3412: debug(fnd_message.get, l_api_name, g_level_cp_output);

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

3406: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_FAILED');
3407: fnd_message.set_token('NUMBER', l_resources_failed);
3408: debug(fnd_message.get, l_api_name, g_level_cp_output);
3409:
3410: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3411: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);
3412: debug(fnd_message.get, l_api_name, g_level_cp_output);
3413: EXCEPTION
3414: WHEN OTHERS THEN

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

3407: fnd_message.set_token('NUMBER', l_resources_failed);
3408: debug(fnd_message.get, l_api_name, g_level_cp_output);
3409:
3410: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3411: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);
3412: debug(fnd_message.get, l_api_name, g_level_cp_output);
3413: EXCEPTION
3414: WHEN OTHERS THEN
3415: IF SQLERRM IS NOT NULL THEN

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

3408: debug(fnd_message.get, l_api_name, g_level_cp_output);
3409:
3410: fnd_message.set_name('CSF', 'CSF_RESOURCES_DONE_TOTAL');
3411: fnd_message.set_token('NUMBER', l_resources_success + l_resources_failed);
3412: debug(fnd_message.get, l_api_name, g_level_cp_output);
3413: EXCEPTION
3414: WHEN OTHERS THEN
3415: IF SQLERRM IS NOT NULL THEN
3416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

3419: END IF;
3420: END IF;
3421:
3422: retcode := 2;
3423: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
3424: errbuf := fnd_message.get;
3425: debug(errbuf, l_api_name, g_level_cp_output);
3426: END generate_trips;
3427:

Line 3424: errbuf := fnd_message.get;

3420: END IF;
3421:
3422: retcode := 2;
3423: fnd_message.set_name('CSF', 'CSF_CP_DONE_ERROR');
3424: errbuf := fnd_message.get;
3425: debug(errbuf, l_api_name, g_level_cp_output);
3426: END generate_trips;
3427:
3428:

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

3491: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3492: RAISE fnd_api.g_exc_unexpected_error;
3493: END IF;
3494:
3495: fnd_message.set_name('CSR','OPTIMIZE_ACROSS_TRIPS');
3496: l_oat_string := fnd_message.get;
3497:
3498: -- submit the concurrent request 'Optimize Across Trips'
3499: x_conc_request_id := fnd_request.submit_request (

Line 3496: l_oat_string := fnd_message.get;

3492: RAISE fnd_api.g_exc_unexpected_error;
3493: END IF;
3494:
3495: fnd_message.set_name('CSR','OPTIMIZE_ACROSS_TRIPS');
3496: l_oat_string := fnd_message.get;
3497:
3498: -- submit the concurrent request 'Optimize Across Trips'
3499: x_conc_request_id := fnd_request.submit_request (
3500: application => 'CSR'