eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_TASKS_PUB dependencies on FND_MSG_PUB

Line 321: fnd_msg_pub.ADD;

317: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
318: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
319: END IF;
320: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (p_new_status_id));
321: fnd_msg_pub.ADD;
322: RAISE fnd_api.g_exc_error;
323: END IF;
324: END validate_status_change;
325:

Line 388: fnd_msg_pub.ADD;

384: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
385: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
386: END IF;
387: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_close_status_id));
388: fnd_msg_pub.ADD;
389: RAISE fnd_api.g_exc_error;
390: END IF;
391:
392: -- Check whether the Assignments and the associated Debriefs have been closed

Line 402: fnd_msg_pub.ADD;

398: AND v_task_assignment.cancelled_flag = 'N'
399: AND v_task_assignment.completed_flag = 'N'
400: AND v_task_assignment.rejected_flag = 'N' THEN
401: fnd_message.set_name('CSF', 'CSF_CLOSED_TASK');
402: fnd_msg_pub.ADD;
403: RAISE fnd_api.g_exc_error;
404: END IF;
405:
406: -- Check whether the Debrief is closed if Task Assignment is not open

Line 411: fnd_msg_pub.ADD;

407: -- and only when the profile "CSFW: Update Schedulable Task" is set to Yes
408: IF l_update_schedulable_task = 'YES' THEN
409: IF NOT is_debrief_closed(v_task_assignment.task_assignment_id) THEN
410: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');
411: fnd_msg_pub.ADD;
412: RAISE fnd_api.g_exc_error;
413: END IF;
414: END IF;
415: END LOOP;

Line 421: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

417: RETURN TRUE;
418: EXCEPTION
419: WHEN fnd_api.g_exc_error THEN
420: x_return_status := fnd_api.g_ret_sts_error;
421: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
422: RETURN FALSE;
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: x_return_status := fnd_api.g_ret_sts_unexp_error;
425: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 425: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

421: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
422: RETURN FALSE;
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: x_return_status := fnd_api.g_ret_sts_unexp_error;
425: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
426: RETURN FALSE;
427: WHEN OTHERS THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 429: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

425: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
426: RETURN FALSE;
427: WHEN OTHERS THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
430: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
431: END IF;
432: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
433: RETURN FALSE;

Line 430: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

426: RETURN FALSE;
427: WHEN OTHERS THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
430: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
431: END IF;
432: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
433: RETURN FALSE;
434: END is_task_closable;

Line 432: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
430: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
431: END IF;
432: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
433: RETURN FALSE;
434: END is_task_closable;
435:
436: /**

Line 507: fnd_msg_pub.ADD;

503: );
504:
505: IF NOT l_schedulable THEN
506: fnd_message.set_name('CSF', l_message_name);
507: fnd_msg_pub.ADD;
508: RAISE fnd_api.g_exc_error;
509: END IF;
510:
511: RETURN TRUE;

Line 515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

511: RETURN TRUE;
512: EXCEPTION
513: WHEN fnd_api.g_exc_error THEN
514: x_return_status := fnd_api.g_ret_sts_error;
515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
516: RETURN FALSE;
517: WHEN fnd_api.g_exc_unexpected_error THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 519: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
516: RETURN FALSE;
517: WHEN fnd_api.g_exc_unexpected_error THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
520: RETURN FALSE;
521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 523: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

519: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
520: RETURN FALSE;
521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
524: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
525: END IF;
526: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
527: RETURN FALSE;

Line 524: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

520: RETURN FALSE;
521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
524: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
525: END IF;
526: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
527: RETURN FALSE;
528: END is_task_schedulable;

Line 526: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
524: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
525: END IF;
526: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
527: RETURN FALSE;
528: END is_task_schedulable;
529:
530: FUNCTION is_task_scheduled (

Line 580: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

576: RETURN FALSE;
577: EXCEPTION
578: WHEN OTHERS THEN
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
581: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
582: END IF;
583: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
584: RETURN FALSE;

Line 581: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

577: EXCEPTION
578: WHEN OTHERS THEN
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
581: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
582: END IF;
583: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
584: RETURN FALSE;
585: END is_task_scheduled;

Line 583: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
581: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
582: END IF;
583: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
584: RETURN FALSE;
585: END is_task_scheduled;
586:
587: /**

Line 666: fnd_msg_pub.initialize;

662: END IF;
663:
664: -- Initialize message list if p_init_msg_list is set to TRUE
665: IF fnd_api.to_boolean (p_init_msg_list) THEN
666: fnd_msg_pub.initialize;
667: END IF;
668:
669: -- Initialize API return status to success
670: x_return_status := fnd_api.g_ret_sts_success;

Line 694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

690: IF fnd_api.to_boolean (p_commit) THEN
691: COMMIT WORK;
692: END IF;
693: -- Standard call to get message count and if count is 1, get message info
694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695: EXCEPTION
696: WHEN fnd_api.g_exc_error THEN
697: ROLLBACK TO close_task_pub;
698: x_return_status := fnd_api.g_ret_sts_error;

Line 699: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

695: EXCEPTION
696: WHEN fnd_api.g_exc_error THEN
697: ROLLBACK TO close_task_pub;
698: x_return_status := fnd_api.g_ret_sts_error;
699: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
700: WHEN fnd_api.g_exc_unexpected_error THEN
701: ROLLBACK TO close_task_pub;
702: x_return_status := fnd_api.g_ret_sts_unexp_error;
703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

699: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
700: WHEN fnd_api.g_exc_unexpected_error THEN
701: ROLLBACK TO close_task_pub;
702: x_return_status := fnd_api.g_ret_sts_unexp_error;
703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
704: WHEN OTHERS THEN
705: x_return_status := fnd_api.g_ret_sts_unexp_error;
706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
707: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

702: x_return_status := fnd_api.g_ret_sts_unexp_error;
703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
704: WHEN OTHERS THEN
705: x_return_status := fnd_api.g_ret_sts_unexp_error;
706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
707: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
708: END IF;
709: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
710: ROLLBACK TO close_task_pub;

Line 707: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
704: WHEN OTHERS THEN
705: x_return_status := fnd_api.g_ret_sts_unexp_error;
706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
707: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
708: END IF;
709: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
710: ROLLBACK TO close_task_pub;
711: END close_task;

Line 709: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

705: x_return_status := fnd_api.g_ret_sts_unexp_error;
706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
707: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
708: END IF;
709: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
710: ROLLBACK TO close_task_pub;
711: END close_task;
712:
713: -- Determines which tasks in a PL/SQL table are modified

Line 757: fnd_msg_pub.initialize;

753: END IF;
754:
755: -- initialize message list if p_init_msg_list is set to true
756: IF fnd_api.to_boolean (p_init_msg_list) THEN
757: fnd_msg_pub.initialize;
758: END IF;
759:
760: -- initialize api return status to success
761: x_return_status := fnd_api.g_ret_sts_success;

Line 804: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

800: l_idx := x_collection.NEXT (l_idx);
801: END LOOP;
802:
803: -- standard call to get message count and if count is 1, get message info
804: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
805: EXCEPTION
806: WHEN OTHERS THEN
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 808: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

804: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
805: EXCEPTION
806: WHEN OTHERS THEN
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
809: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
810: END IF;
811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
812: END identify_modified_tasks;

Line 809: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

805: EXCEPTION
806: WHEN OTHERS THEN
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
809: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
810: END IF;
811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
812: END identify_modified_tasks;
813:

Line 811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
809: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
810: END IF;
811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
812: END identify_modified_tasks;
813:
814: ---------------------------------------------------------------------------
815: -- validate_planned_dates

Line 963: fnd_msg_pub.initialize;

959: RAISE fnd_api.g_exc_unexpected_error;
960: END IF;
961:
962: IF fnd_api.to_boolean (p_init_msg_list) THEN
963: fnd_msg_pub.initialize;
964: END IF;
965:
966: x_return_status := fnd_api.g_ret_sts_success;
967:

Line 981: fnd_msg_pub.ADD;

977:
978: -- Task is not schedulable.
979: IF l_task_schedulable = FALSE OR x_return_status <> fnd_api.g_ret_sts_success THEN
980: fnd_message.set_name ('CSF', l_reason_code);
981: fnd_msg_pub.ADD;
982: RAISE fnd_api.g_exc_error;
983: END IF;
984:
985: jtf_tasks_pub.create_task (

Line 1110: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1106: EXCEPTION
1107: WHEN fnd_api.g_exc_error THEN
1108: ROLLBACK TO csf_create_task_pub;
1109: x_return_status := fnd_api.g_ret_sts_error;
1110: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1111: WHEN fnd_api.g_exc_unexpected_error THEN
1112: ROLLBACK TO csf_create_task_pub;
1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1114: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1110: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1111: WHEN fnd_api.g_exc_unexpected_error THEN
1112: ROLLBACK TO csf_create_task_pub;
1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1115: WHEN OTHERS THEN
1116: x_return_status := fnd_api.g_ret_sts_unexp_error;
1117: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1118: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1117: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1115: WHEN OTHERS THEN
1116: x_return_status := fnd_api.g_ret_sts_unexp_error;
1117: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1118: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1119: END IF;
1120: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1121: ROLLBACK TO csf_create_task_pub;

Line 1118: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1114: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1115: WHEN OTHERS THEN
1116: x_return_status := fnd_api.g_ret_sts_unexp_error;
1117: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1118: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1119: END IF;
1120: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1121: ROLLBACK TO csf_create_task_pub;
1122: END create_task;

Line 1120: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1116: x_return_status := fnd_api.g_ret_sts_unexp_error;
1117: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1118: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1119: END IF;
1120: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1121: ROLLBACK TO csf_create_task_pub;
1122: END create_task;
1123:
1124: PROCEDURE delete_task (

Line 1240: fnd_msg_pub.ADD;

1236: AND v_task_assignment.cancelled_flag = 'N'
1237: AND v_task_assignment.rejected_flag = 'N' )
1238: THEN
1239: fnd_message.set_name ('CSF', 'CSF_CLOSED_TASK');
1240: fnd_msg_pub.ADD;
1241: RAISE fnd_api.g_exc_error;
1242: END IF;
1243:
1244: -- Task Assignment is not open. Check for Debrief

Line 1247: fnd_msg_pub.ADD;

1243:
1244: -- Task Assignment is not open. Check for Debrief
1245: IF NOT is_debrief_closed(v_task_assignment.task_assignment_id) THEN
1246: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');
1247: fnd_msg_pub.ADD;
1248: RAISE fnd_api.g_exc_error;
1249: END IF;
1250:
1251: -- All validations done. Close the Task Assignment

Line 1332: fnd_msg_pub.initialize;

1328: END IF;
1329:
1330: -- Initialize message list if p_init_msg_list is set to TRUE
1331: IF fnd_api.to_boolean (p_init_msg_list) THEN
1332: fnd_msg_pub.initialize;
1333: END IF;
1334:
1335: -- Initialize API return status to success
1336: x_return_status := fnd_api.g_ret_sts_success;

Line 1407: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1403: IF fnd_api.to_boolean (p_commit) THEN
1404: COMMIT WORK;
1405: END IF;
1406:
1407: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1408: EXCEPTION
1409: WHEN fnd_api.g_exc_error THEN
1410: ROLLBACK TO update_task_status_pub;
1411: x_return_status := fnd_api.g_ret_sts_error;

Line 1412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1408: EXCEPTION
1409: WHEN fnd_api.g_exc_error THEN
1410: ROLLBACK TO update_task_status_pub;
1411: x_return_status := fnd_api.g_ret_sts_error;
1412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN fnd_api.g_exc_unexpected_error THEN
1414: ROLLBACK TO update_task_status_pub;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1416: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN fnd_api.g_exc_unexpected_error THEN
1414: ROLLBACK TO update_task_status_pub;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1417: WHEN OTHERS THEN
1418: x_return_status := fnd_api.g_ret_sts_unexp_error;
1419: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1420: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1419: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1417: WHEN OTHERS THEN
1418: x_return_status := fnd_api.g_ret_sts_unexp_error;
1419: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1420: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1421: END IF;
1422: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1423: ROLLBACK TO update_task_status_pub;

Line 1420: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1416: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1417: WHEN OTHERS THEN
1418: x_return_status := fnd_api.g_ret_sts_unexp_error;
1419: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1420: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1421: END IF;
1422: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1423: ROLLBACK TO update_task_status_pub;
1424: END update_task_status;

Line 1422: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1418: x_return_status := fnd_api.g_ret_sts_unexp_error;
1419: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1420: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1421: END IF;
1422: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1423: ROLLBACK TO update_task_status_pub;
1424: END update_task_status;
1425:
1426: PROCEDURE update_task(

Line 1608: fnd_msg_pub.initialize;

1604: RAISE fnd_api.g_exc_unexpected_error;
1605: END IF;
1606:
1607: IF fnd_api.to_boolean (p_init_msg_list) THEN
1608: fnd_msg_pub.initialize;
1609: END IF;
1610:
1611: x_return_status := fnd_api.g_ret_sts_success;
1612:

Line 1654: fnd_msg_pub.add;

1650: OR l_planned_effort_minutes > fnd_profile.value('CSR_DEFAULT_SHIFT_DURATION')
1651: THEN
1652: fnd_message.set_name ('CSF', 'CSF_TASK_UPDATE_NOT_ALLOWED');
1653: fnd_message.set_token('TASK_NUMBER',l_task_number);
1654: fnd_msg_pub.add;
1655: RAISE fnd_api.g_exc_error;
1656: END IF;
1657:
1658: IF l_task_info.task_assignment_id IS NOT NULL

Line 1868: fnd_msg_pub.add;

1864: IF l_overlap_tasks IS NOT NULL THEN
1865: fnd_message.set_name('CSR','CSR_TASK_OVERLAP');
1866: fnd_message.set_token('TASKID', l_task_number);
1867: fnd_message.set_token('TASKS',l_overlap_tasks);
1868: fnd_msg_pub.add;
1869: END IF;
1870:
1871: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1872: EXCEPTION

Line 1871: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1867: fnd_message.set_token('TASKS',l_overlap_tasks);
1868: fnd_msg_pub.add;
1869: END IF;
1870:
1871: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1872: EXCEPTION
1873: WHEN fnd_api.g_exc_error THEN
1874: ROLLBACK TO csf_update_task;
1875: x_return_status := fnd_api.g_ret_sts_error;

Line 1876: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1872: EXCEPTION
1873: WHEN fnd_api.g_exc_error THEN
1874: ROLLBACK TO csf_update_task;
1875: x_return_status := fnd_api.g_ret_sts_error;
1876: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1877: WHEN fnd_api.g_exc_unexpected_error THEN
1878: ROLLBACK TO csf_update_task;
1879: x_return_status := fnd_api.g_ret_sts_unexp_error;
1880: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1880: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1876: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1877: WHEN fnd_api.g_exc_unexpected_error THEN
1878: ROLLBACK TO csf_update_task;
1879: x_return_status := fnd_api.g_ret_sts_unexp_error;
1880: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1881: WHEN OTHERS THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1884: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

1879: x_return_status := fnd_api.g_ret_sts_unexp_error;
1880: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1881: WHEN OTHERS THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1884: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1885: END IF;
1886: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1887: ROLLBACK TO csf_update_task;

Line 1884: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

1880: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1881: WHEN OTHERS THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1884: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1885: END IF;
1886: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1887: ROLLBACK TO csf_update_task;
1888: END update_task;

Line 1886: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1884: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1885: END IF;
1886: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1887: ROLLBACK TO csf_update_task;
1888: END update_task;
1889:
1890: PROCEDURE commit_task (

Line 1974: fnd_msg_pub.initialize;

1970: RAISE fnd_api.g_exc_unexpected_error;
1971: END IF;
1972:
1973: IF fnd_api.to_boolean (p_init_msg_list) THEN
1974: fnd_msg_pub.initialize;
1975: END IF;
1976:
1977: x_return_status := fnd_api.g_ret_sts_success;
1978:

Line 1989: fnd_msg_pub.ADD;

1985: IF c_task_details%NOTFOUND THEN
1986: CLOSE c_task_details;
1987: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
1988: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
1989: fnd_msg_pub.ADD;
1990: RAISE fnd_api.g_exc_error;
1991: END IF;
1992: CLOSE c_task_details;
1993: ELSE

Line 2000: fnd_msg_pub.ADD;

1996: IF c_task_details_1%NOTFOUND THEN
1997: CLOSE c_task_details_1;
1998: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
1999: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
2000: fnd_msg_pub.ADD;
2001: RAISE fnd_api.g_exc_error;
2002: END IF;
2003: CLOSE c_task_details_1;
2004: END IF;

Line 2010: fnd_msg_pub.ADD;

2006: -- Trip should not be in Blocked Status
2007: IF l_task_details.trip_status = csf_trips_pub.g_trip_unavailable THEN
2008: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TRIP_BLOCK');
2009: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2010: fnd_msg_pub.ADD;
2011: RAISE fnd_api.g_exc_error;
2012: END IF;
2013:
2014: -- Validate Status Transition

Line 2025: fnd_msg_pub.ADD;

2021: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
2022: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
2023: END IF;
2024: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_new_status_id));
2025: fnd_msg_pub.ADD;
2026: RAISE fnd_api.g_exc_error;
2027: END IF;
2028:
2029: -- Check the Customer Confirmation Status - Should be either No or Received

Line 2033: fnd_msg_pub.ADD;

2029: -- Check the Customer Confirmation Status - Should be either No or Received
2030: IF l_task_details.task_confirmation_status = 'R' THEN
2031: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CUST_CONF');
2032: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2033: fnd_msg_pub.ADD;
2034: RAISE fnd_api.g_exc_error;
2035: END IF;
2036:
2037: -- Check for Scheduled Dates

Line 2041: fnd_msg_pub.ADD;

2037: -- Check for Scheduled Dates
2038: IF l_task_details.scheduled_start_date IS NULL THEN
2039: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_SCHE');
2040: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2041: fnd_msg_pub.ADD;
2042: RAISE fnd_api.g_exc_error;
2043: END IF;
2044:
2045: csf_task_assignments_pub.update_assignment_status(

Line 2065: -- fnd_msg_pub.ADD;

2061: -- commented for the bug 6801965
2062: -- Committed Task Message is added to the message stack
2063: -- fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2064: -- fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2065: -- fnd_msg_pub.ADD;
2066: RETURN;
2067: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2068: RAISE fnd_api.g_exc_error;
2069: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2082: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2078: EXCEPTION
2079: WHEN fnd_api.g_exc_error THEN
2080: ROLLBACK TO csf_commit_task;
2081: x_return_status := fnd_api.g_ret_sts_error;
2082: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2083: WHEN fnd_api.g_exc_unexpected_error THEN
2084: ROLLBACK TO csf_commit_task;
2085: x_return_status := fnd_api.g_ret_sts_unexp_error;
2086: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 2086: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2082: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2083: WHEN fnd_api.g_exc_unexpected_error THEN
2084: ROLLBACK TO csf_commit_task;
2085: x_return_status := fnd_api.g_ret_sts_unexp_error;
2086: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2087: WHEN OTHERS THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2090: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2089: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2085: x_return_status := fnd_api.g_ret_sts_unexp_error;
2086: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2087: WHEN OTHERS THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2090: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2091: END IF;
2092: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2093: ROLLBACK TO csf_commit_task;

Line 2090: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2086: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2087: WHEN OTHERS THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2090: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2091: END IF;
2092: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2093: ROLLBACK TO csf_commit_task;
2094: END commit_task;

Line 2092: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2090: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2091: END IF;
2092: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2093: ROLLBACK TO csf_commit_task;
2094: END commit_task;
2095:
2096: PROCEDURE commit_schedule (

Line 2176: fnd_msg_pub.initialize;

2172: RAISE fnd_api.g_exc_unexpected_error;
2173: END IF;
2174:
2175: IF fnd_api.to_boolean (p_init_msg_list) THEN
2176: fnd_msg_pub.initialize;
2177: END IF;
2178:
2179: x_return_status := fnd_api.g_ret_sts_success;
2180:

Line 2186: fnd_msg_pub.ADD;

2182: IF p_query_id IS NULL AND p_resource_id IS NULL AND p_task_id IS NULL AND p_trip_id IS NULL THEN
2183: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2184: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2185: fnd_message.set_token('PARAM_NAME', 'P_QUERY_ID');
2186: fnd_msg_pub.ADD;
2187: RAISE fnd_api.g_exc_error;
2188: END IF;
2189:
2190: IF p_query_id IS NOT NULL THEN

Line 2289: fnd_msg_pub.ADD;

2285:
2286: -- Process each Task in the Task List
2287: IF l_task_id_tbl.COUNT = 0 THEN -- if there are no tasks in the trip #bug7146595
2288: fnd_message.set_name('CSF','CSF_NO_TASK_FOR_RESOURCE');
2289: fnd_msg_pub.ADD;
2290: END IF; -- end of code for the bug7146595
2291: FOR i IN 1..l_task_id_tbl.COUNT
2292: LOOP
2293: l_processed_count := l_processed_count + 1;

Line 2303: fnd_msg_pub.ADD;

2299: IF l_cnt > 1
2300: THEN
2301: fnd_message.set_name('CSF','CSF_AUTO_COMMIT_MULTI_RES');
2302: fnd_message.set_token ('TASK', task_number(l_task_id_tbl(i)));
2303: fnd_msg_pub.ADD;
2304: l_all_passed := FALSE;
2305: --End of the code added for this bug 6866929
2306: ELSE
2307: IF l_task_split_flag_tbl(i) IS NOT NULL THEN

Line 2320: fnd_msg_pub.ADD;

2316: IF l_trip_status_tbl(j) = csf_trips_pub.g_trip_unavailable THEN
2317: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CHILD_TRIP_BLK');
2318: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_child_task_id_tbl(j)));
2319: fnd_message.set_token ('P_PARENT_TASK', task_number(l_task_id_tbl(i)));
2320: fnd_msg_pub.ADD;
2321: l_blocked_trip_found := TRUE;
2322: l_all_passed := FALSE;
2323: EXIT;
2324: END IF;

Line 2371: fnd_msg_pub.ADD;

2367:
2368:
2369: IF l_processed_count = 0 AND p_query_id IS NOT NULL THEN
2370: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_NO_TASK');
2371: fnd_msg_pub.ADD;
2372: x_return_status := fnd_api.g_ret_sts_error;
2373: END IF;
2374:
2375: IF NOT l_all_passed THEN

Line 2384: fnd_msg_pub.ADD;

2380: FOR i in 1..l_task_num_tbl.count
2381: LOOP
2382: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2383: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_task_num_tbl(i)));
2384: fnd_msg_pub.ADD;
2385: END LOOP;
2386: END IF;
2387: -- end of code for the bug 6801965
2388: CLOSE c_task_list;

Line 2394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2390: IF fnd_api.to_boolean (p_commit) THEN
2391: COMMIT WORK;
2392: END IF;
2393:
2394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2395: EXCEPTION
2396: WHEN fnd_api.g_exc_error THEN
2397: ROLLBACK TO csf_commit_schedule;
2398: x_return_status := fnd_api.g_ret_sts_error;

Line 2399: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2395: EXCEPTION
2396: WHEN fnd_api.g_exc_error THEN
2397: ROLLBACK TO csf_commit_schedule;
2398: x_return_status := fnd_api.g_ret_sts_error;
2399: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2400: WHEN fnd_api.g_exc_unexpected_error THEN
2401: ROLLBACK TO csf_commit_schedule;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 2403: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2399: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2400: WHEN fnd_api.g_exc_unexpected_error THEN
2401: ROLLBACK TO csf_commit_schedule;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2404: WHEN OTHERS THEN
2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2404: WHEN OTHERS THEN
2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2408: END IF;
2409: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2410: ROLLBACK TO csf_commit_schedule;

Line 2407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2403: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2404: WHEN OTHERS THEN
2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2408: END IF;
2409: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2410: ROLLBACK TO csf_commit_schedule;
2411: END commit_schedule;

Line 2409: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2408: END IF;
2409: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2410: ROLLBACK TO csf_commit_schedule;
2411: END commit_schedule;
2412:
2413: /**

Line 2610: fnd_msg_pub.initialize;

2606: RAISE fnd_api.g_exc_unexpected_error;
2607: END IF;
2608:
2609: IF fnd_api.to_boolean (p_init_msg_list) THEN
2610: fnd_msg_pub.initialize;
2611: END IF;
2612:
2613: x_return_status := fnd_api.g_ret_sts_success;
2614:

Line 2747: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2743: EXCEPTION
2744: WHEN fnd_api.g_exc_error THEN
2745: ROLLBACK TO csf_sync_parent_with_child;
2746: x_return_status := fnd_api.g_ret_sts_error;
2747: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2748: WHEN fnd_api.g_exc_unexpected_error THEN
2749: ROLLBACK TO csf_sync_parent_with_child;
2750: x_return_status := fnd_api.g_ret_sts_unexp_error;
2751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 2751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2747: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2748: WHEN fnd_api.g_exc_unexpected_error THEN
2749: ROLLBACK TO csf_sync_parent_with_child;
2750: x_return_status := fnd_api.g_ret_sts_unexp_error;
2751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2752: WHEN OTHERS THEN
2753: x_return_status := fnd_api.g_ret_sts_unexp_error;
2754: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2755: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2754: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2750: x_return_status := fnd_api.g_ret_sts_unexp_error;
2751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2752: WHEN OTHERS THEN
2753: x_return_status := fnd_api.g_ret_sts_unexp_error;
2754: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2755: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2756: END IF;
2757: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2758: ROLLBACK TO csf_sync_parent_with_child;

Line 2755: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2752: WHEN OTHERS THEN
2753: x_return_status := fnd_api.g_ret_sts_unexp_error;
2754: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2755: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2756: END IF;
2757: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2758: ROLLBACK TO csf_sync_parent_with_child;
2759: END sync_parent_with_child;

Line 2757: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2753: x_return_status := fnd_api.g_ret_sts_unexp_error;
2754: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2755: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2756: END IF;
2757: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2758: ROLLBACK TO csf_sync_parent_with_child;
2759: END sync_parent_with_child;
2760:
2761: /**

Line 2806: fnd_msg_pub.initialize;

2802: RAISE fnd_api.g_exc_unexpected_error;
2803: END IF;
2804:
2805: IF fnd_api.to_boolean (p_init_msg_list) THEN
2806: fnd_msg_pub.initialize;
2807: END IF;
2808:
2809: x_return_status := fnd_api.g_ret_sts_success;
2810:

Line 2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2849: EXCEPTION
2850: WHEN fnd_api.g_exc_error THEN
2851: ROLLBACK TO csf_sync_child_from_parent;
2852: x_return_status := fnd_api.g_ret_sts_error;
2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2854: WHEN fnd_api.g_exc_unexpected_error THEN
2855: ROLLBACK TO csf_sync_child_from_parent;
2856: x_return_status := fnd_api.g_ret_sts_unexp_error;
2857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 2857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2854: WHEN fnd_api.g_exc_unexpected_error THEN
2855: ROLLBACK TO csf_sync_child_from_parent;
2856: x_return_status := fnd_api.g_ret_sts_unexp_error;
2857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2858: WHEN OTHERS THEN
2859: x_return_status := fnd_api.g_ret_sts_unexp_error;
2860: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2861: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 2860: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

2856: x_return_status := fnd_api.g_ret_sts_unexp_error;
2857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2858: WHEN OTHERS THEN
2859: x_return_status := fnd_api.g_ret_sts_unexp_error;
2860: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2861: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2862: END IF;
2863: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2864: ROLLBACK TO csf_sync_child_from_parent;

Line 2861: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

2857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2858: WHEN OTHERS THEN
2859: x_return_status := fnd_api.g_ret_sts_unexp_error;
2860: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2861: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2862: END IF;
2863: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2864: ROLLBACK TO csf_sync_child_from_parent;
2865: END sync_child_from_parent;

Line 2863: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

2859: x_return_status := fnd_api.g_ret_sts_unexp_error;
2860: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2861: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2862: END IF;
2863: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2864: ROLLBACK TO csf_sync_child_from_parent;
2865: END sync_child_from_parent;
2866:
2867: PROCEDURE assign_task(

Line 2936: fnd_msg_pub.initialize;

2932: RAISE fnd_api.g_exc_unexpected_error;
2933: END IF;
2934:
2935: IF fnd_api.to_boolean(p_init_msg_list) THEN
2936: fnd_msg_pub.initialize;
2937: END IF;
2938:
2939: x_return_status := fnd_api.g_ret_sts_success;
2940:

Line 2947: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);

2943: FETCH c_task_info INTO l_task_info;
2944: CLOSE c_task_info;
2945:
2946: IF l_task_info.task_id IS NULL THEN
2947: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
2948: RAISE fnd_api.g_exc_unexpected_error;
2949: END IF;
2950:
2951: -- If the Task is already Scheduled, then the Task Should be treated to be

Line 3073: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3069: IF fnd_api.to_boolean(p_commit) THEN
3070: COMMIT WORK;
3071: END IF;
3072:
3073: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3074:
3075: EXCEPTION
3076: WHEN fnd_api.g_exc_error THEN
3077: ROLLBACK TO csf_assign_task;

Line 3079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3075: EXCEPTION
3076: WHEN fnd_api.g_exc_error THEN
3077: ROLLBACK TO csf_assign_task;
3078: x_return_status := fnd_api.g_ret_sts_error;
3079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3080: WHEN fnd_api.g_exc_unexpected_error THEN
3081: ROLLBACK TO csf_assign_task;
3082: x_return_status := fnd_api.g_ret_sts_unexp_error;
3083: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3083: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3080: WHEN fnd_api.g_exc_unexpected_error THEN
3081: ROLLBACK TO csf_assign_task;
3082: x_return_status := fnd_api.g_ret_sts_unexp_error;
3083: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3084: WHEN OTHERS THEN
3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3082: x_return_status := fnd_api.g_ret_sts_unexp_error;
3083: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3084: WHEN OTHERS THEN
3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3088: END IF;
3089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3090: ROLLBACK TO csf_assign_task;

Line 3087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3083: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3084: WHEN OTHERS THEN
3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3088: END IF;
3089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3090: ROLLBACK TO csf_assign_task;
3091: END assign_task;

Line 3089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3088: END IF;
3089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3090: ROLLBACK TO csf_assign_task;
3091: END assign_task;
3092:
3093: PROCEDURE unassign_task(

Line 3142: fnd_msg_pub.initialize;

3138: RAISE fnd_api.g_exc_unexpected_error;
3139: END IF;
3140:
3141: IF fnd_api.to_boolean(p_init_msg_list) THEN
3142: fnd_msg_pub.initialize;
3143: END IF;
3144:
3145: x_return_status := fnd_api.g_ret_sts_success;
3146:

Line 3244: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3240: EXCEPTION
3241: WHEN fnd_api.g_exc_error THEN
3242: ROLLBACK TO csf_unassign_task;
3243: x_return_status := fnd_api.g_ret_sts_error;
3244: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3245: WHEN fnd_api.g_exc_unexpected_error THEN
3246: ROLLBACK TO csf_unassign_task;
3247: x_return_status := fnd_api.g_ret_sts_unexp_error;
3248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3244: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3245: WHEN fnd_api.g_exc_unexpected_error THEN
3246: ROLLBACK TO csf_unassign_task;
3247: x_return_status := fnd_api.g_ret_sts_unexp_error;
3248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3249: WHEN OTHERS THEN
3250: x_return_status := fnd_api.g_ret_sts_unexp_error;
3251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3252: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3247: x_return_status := fnd_api.g_ret_sts_unexp_error;
3248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3249: WHEN OTHERS THEN
3250: x_return_status := fnd_api.g_ret_sts_unexp_error;
3251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3252: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3253: END IF;
3254: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3255: ROLLBACK TO csf_unassign_task;

Line 3252: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3249: WHEN OTHERS THEN
3250: x_return_status := fnd_api.g_ret_sts_unexp_error;
3251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3252: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3253: END IF;
3254: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3255: ROLLBACK TO csf_unassign_task;
3256: END unassign_task;

Line 3254: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3250: x_return_status := fnd_api.g_ret_sts_unexp_error;
3251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3252: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3253: END IF;
3254: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3255: ROLLBACK TO csf_unassign_task;
3256: END unassign_task;
3257:
3258: PROCEDURE update_task_and_assignment(

Line 3291: fnd_msg_pub.initialize;

3287: RAISE fnd_api.g_exc_unexpected_error;
3288: END IF;
3289:
3290: IF fnd_api.to_boolean(p_init_msg_list) THEN
3291: fnd_msg_pub.initialize;
3292: END IF;
3293:
3294: x_return_status := fnd_api.g_ret_sts_success;
3295:

Line 3350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3346: EXCEPTION
3347: WHEN fnd_api.g_exc_error THEN
3348: ROLLBACK TO csf_update_task_and_assignment;
3349: x_return_status := fnd_api.g_ret_sts_error;
3350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3351: WHEN fnd_api.g_exc_unexpected_error THEN
3352: ROLLBACK TO csf_update_task_and_assignment;
3353: x_return_status := fnd_api.g_ret_sts_unexp_error;
3354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3351: WHEN fnd_api.g_exc_unexpected_error THEN
3352: ROLLBACK TO csf_update_task_and_assignment;
3353: x_return_status := fnd_api.g_ret_sts_unexp_error;
3354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3355: WHEN OTHERS THEN
3356: x_return_status := fnd_api.g_ret_sts_unexp_error;
3357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3358: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3353: x_return_status := fnd_api.g_ret_sts_unexp_error;
3354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3355: WHEN OTHERS THEN
3356: x_return_status := fnd_api.g_ret_sts_unexp_error;
3357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3358: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3359: END IF;
3360: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3361: ROLLBACK TO csf_update_task_and_assignment;

Line 3358: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3355: WHEN OTHERS THEN
3356: x_return_status := fnd_api.g_ret_sts_unexp_error;
3357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3358: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3359: END IF;
3360: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3361: ROLLBACK TO csf_update_task_and_assignment;
3362: END update_task_and_assignment;

Line 3360: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3356: x_return_status := fnd_api.g_ret_sts_unexp_error;
3357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3358: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3359: END IF;
3360: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3361: ROLLBACK TO csf_update_task_and_assignment;
3362: END update_task_and_assignment;
3363:
3364: PROCEDURE update_task_longer_than_shift(

Line 3419: fnd_msg_pub.initialize;

3415: RAISE fnd_api.g_exc_unexpected_error;
3416: END IF;
3417:
3418: IF fnd_api.to_boolean(p_init_msg_list) THEN
3419: fnd_msg_pub.initialize;
3420: END IF;
3421:
3422: x_return_status := fnd_api.g_ret_sts_success;
3423:

Line 3430: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);

3426: FETCH c_parent_task_info INTO l_parent_task_info;
3427: CLOSE c_parent_task_info;
3428:
3429: IF l_parent_task_info.task_id IS NULL THEN
3430: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
3431: RAISE fnd_api.g_exc_unexpected_error;
3432: END IF;
3433:
3434: -- Find out whether the new Task Status is valid.

Line 3531: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3527: EXCEPTION
3528: WHEN fnd_api.g_exc_error THEN
3529: ROLLBACK TO update_task_longer_than_shift;
3530: x_return_status := fnd_api.g_ret_sts_error;
3531: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3532: WHEN fnd_api.g_exc_unexpected_error THEN
3533: ROLLBACK TO update_task_longer_than_shift;
3534: x_return_status := fnd_api.g_ret_sts_unexp_error;
3535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3531: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3532: WHEN fnd_api.g_exc_unexpected_error THEN
3533: ROLLBACK TO update_task_longer_than_shift;
3534: x_return_status := fnd_api.g_ret_sts_unexp_error;
3535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3536: WHEN OTHERS THEN
3537: x_return_status := fnd_api.g_ret_sts_unexp_error;
3538: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3539: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3538: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3534: x_return_status := fnd_api.g_ret_sts_unexp_error;
3535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3536: WHEN OTHERS THEN
3537: x_return_status := fnd_api.g_ret_sts_unexp_error;
3538: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3539: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3540: END IF;
3541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3542: ROLLBACK TO update_task_longer_than_shift;

Line 3539: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3536: WHEN OTHERS THEN
3537: x_return_status := fnd_api.g_ret_sts_unexp_error;
3538: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3539: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3540: END IF;
3541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3542: ROLLBACK TO update_task_longer_than_shift;
3543: END update_task_longer_than_shift;

Line 3541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3537: x_return_status := fnd_api.g_ret_sts_unexp_error;
3538: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3539: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3540: END IF;
3541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3542: ROLLBACK TO update_task_longer_than_shift;
3543: END update_task_longer_than_shift;
3544:
3545: PROCEDURE create_child_task(

Line 3604: fnd_msg_pub.initialize;

3600: RAISE fnd_api.g_exc_unexpected_error;
3601: END IF;
3602:
3603: IF fnd_api.to_boolean(p_init_msg_list) THEN
3604: fnd_msg_pub.initialize;
3605: END IF;
3606:
3607: x_return_status := fnd_api.g_ret_sts_success;
3608:

Line 3614: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_parent_task_id);

3610: OPEN c_parent_task_info;
3611: FETCH c_parent_task_info INTO l_parent_task_info;
3612: IF c_parent_task_info%NOTFOUND THEN
3613: CLOSE c_parent_task_info;
3614: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_parent_task_id);
3615: RAISE fnd_api.g_exc_unexpected_error;
3616: END IF;
3617: CLOSE c_parent_task_info;
3618:

Line 3759: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3755: EXCEPTION
3756: WHEN fnd_api.g_exc_error THEN
3757: ROLLBACK TO csf_create_child_task;
3758: x_return_status := fnd_api.g_ret_sts_error;
3759: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3760: WHEN fnd_api.g_exc_unexpected_error THEN
3761: ROLLBACK TO csf_create_child_task;
3762: x_return_status := fnd_api.g_ret_sts_unexp_error;
3763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3759: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3760: WHEN fnd_api.g_exc_unexpected_error THEN
3761: ROLLBACK TO csf_create_child_task;
3762: x_return_status := fnd_api.g_ret_sts_unexp_error;
3763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3764: WHEN OTHERS THEN
3765: x_return_status := fnd_api.g_ret_sts_unexp_error;
3766: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3767: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3766: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3762: x_return_status := fnd_api.g_ret_sts_unexp_error;
3763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3764: WHEN OTHERS THEN
3765: x_return_status := fnd_api.g_ret_sts_unexp_error;
3766: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3767: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3768: END IF;
3769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3770: ROLLBACK TO csf_create_child_task;

Line 3767: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3764: WHEN OTHERS THEN
3765: x_return_status := fnd_api.g_ret_sts_unexp_error;
3766: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3767: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3768: END IF;
3769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3770: ROLLBACK TO csf_create_child_task;
3771: END create_child_task;

Line 3769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3765: x_return_status := fnd_api.g_ret_sts_unexp_error;
3766: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3767: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3768: END IF;
3769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3770: ROLLBACK TO csf_create_child_task;
3771: END create_child_task;
3772:
3773: /**

Line 3842: fnd_msg_pub.initialize;

3838:
3839: x_return_status := fnd_api.g_ret_sts_success;
3840:
3841: IF fnd_api.to_boolean (p_init_msg_list) THEN
3842: fnd_msg_pub.initialize;
3843: END IF;
3844:
3845: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3846: RAISE fnd_api.g_exc_unexpected_error;

Line 3955: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3951: EXCEPTION
3952: WHEN fnd_api.g_exc_error THEN
3953: ROLLBACK TO csf_update_cust_confirmation;
3954: x_return_status := fnd_api.g_ret_sts_error;
3955: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3956: WHEN fnd_api.g_exc_unexpected_error THEN
3957: ROLLBACK TO csf_update_cust_confirmation;
3958: x_return_status := fnd_api.g_ret_sts_unexp_error;
3959: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3959: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3955: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3956: WHEN fnd_api.g_exc_unexpected_error THEN
3957: ROLLBACK TO csf_update_cust_confirmation;
3958: x_return_status := fnd_api.g_ret_sts_unexp_error;
3959: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: x_return_status := fnd_api.g_ret_sts_unexp_error;
3962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

3958: x_return_status := fnd_api.g_ret_sts_unexp_error;
3959: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: x_return_status := fnd_api.g_ret_sts_unexp_error;
3962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3964: END IF;
3965: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3966: ROLLBACK TO csf_update_cust_confirmation;

Line 3963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

3959: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: x_return_status := fnd_api.g_ret_sts_unexp_error;
3962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3964: END IF;
3965: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3966: ROLLBACK TO csf_update_cust_confirmation;
3967: END update_cust_confirmation;

Line 3965: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

3961: x_return_status := fnd_api.g_ret_sts_unexp_error;
3962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3964: END IF;
3965: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3966: ROLLBACK TO csf_update_cust_confirmation;
3967: END update_cust_confirmation;
3968:
3969: FUNCTION get_task_location_id (

Line 4419: fnd_msg_pub.initialize;

4415:
4416: x_return_status := fnd_api.g_ret_sts_success;
4417:
4418: IF fnd_api.to_boolean (p_init_msg_list) THEN
4419: fnd_msg_pub.initialize;
4420: END IF;
4421:
4422: if p_type = 'ONETIME'
4423: then

Line 4501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4497: Exception
4498: WHEN fnd_api.g_exc_error THEN
4499: ROLLBACK TO csf_create_per_task;
4500: x_return_status := fnd_api.g_ret_sts_error;
4501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4502: WHEN fnd_api.g_exc_unexpected_error THEN
4503: ROLLBACK TO csf_create_per_task;
4504: x_return_status := fnd_api.g_ret_sts_unexp_error;
4505: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4505: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4502: WHEN fnd_api.g_exc_unexpected_error THEN
4503: ROLLBACK TO csf_create_per_task;
4504: x_return_status := fnd_api.g_ret_sts_unexp_error;
4505: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4506: WHEN OTHERS THEN
4507: x_return_status := fnd_api.g_ret_sts_unexp_error;
4508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4509: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 4508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4504: x_return_status := fnd_api.g_ret_sts_unexp_error;
4505: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4506: WHEN OTHERS THEN
4507: x_return_status := fnd_api.g_ret_sts_unexp_error;
4508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4509: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4510: END IF;
4511: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4512: ROLLBACK TO csf_create_per_task;

Line 4509: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

4505: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4506: WHEN OTHERS THEN
4507: x_return_status := fnd_api.g_ret_sts_unexp_error;
4508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4509: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4510: END IF;
4511: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4512: ROLLBACK TO csf_create_per_task;
4513: end;

Line 4511: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4507: x_return_status := fnd_api.g_ret_sts_unexp_error;
4508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4509: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4510: END IF;
4511: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4512: ROLLBACK TO csf_create_per_task;
4513: end;
4514:
4515: procedure update_personal_task(

Line 4579: fnd_msg_pub.initialize;

4575:
4576: x_return_status := fnd_api.g_ret_sts_success;
4577:
4578: IF fnd_api.to_boolean (p_init_msg_list) THEN
4579: fnd_msg_pub.initialize;
4580: END IF;
4581:
4582: open c_obj(p_task_id);
4583: fetch c_obj into l_obj;

Line 4665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4661: Exception
4662: WHEN fnd_api.g_exc_error THEN
4663: ROLLBACK TO csf_update_per_task;
4664: x_return_status := fnd_api.g_ret_sts_error;
4665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4666: WHEN fnd_api.g_exc_unexpected_error THEN
4667: ROLLBACK TO csf_update_per_task;
4668: x_return_status := fnd_api.g_ret_sts_unexp_error;
4669: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4669: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4666: WHEN fnd_api.g_exc_unexpected_error THEN
4667: ROLLBACK TO csf_update_per_task;
4668: x_return_status := fnd_api.g_ret_sts_unexp_error;
4669: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4670: WHEN OTHERS THEN
4671: x_return_status := fnd_api.g_ret_sts_unexp_error;
4672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4673: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 4672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

4668: x_return_status := fnd_api.g_ret_sts_unexp_error;
4669: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4670: WHEN OTHERS THEN
4671: x_return_status := fnd_api.g_ret_sts_unexp_error;
4672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4673: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4674: END IF;
4675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4676: ROLLBACK TO csf_update_per_task;

Line 4673: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

4669: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4670: WHEN OTHERS THEN
4671: x_return_status := fnd_api.g_ret_sts_unexp_error;
4672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4673: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4674: END IF;
4675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4676: ROLLBACK TO csf_update_per_task;
4677: end;

Line 4675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

4671: x_return_status := fnd_api.g_ret_sts_unexp_error;
4672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4673: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4674: END IF;
4675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4676: ROLLBACK TO csf_update_per_task;
4677: end;
4678:
4679: END csf_tasks_pub;