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 371: fnd_msg_pub.ADD;

367: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
368: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
369: END IF;
370: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (p_new_status_id));
371: fnd_msg_pub.ADD;
372: RAISE fnd_api.g_exc_error;
373: END IF;
374: END validate_status_change;
375:

Line 440: fnd_msg_pub.ADD;

436: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
437: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
438: END IF;
439: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_close_status_id));
440: fnd_msg_pub.ADD;
441: RAISE fnd_api.g_exc_error;
442: END IF;
443:
444: -- Check whether the Assignments and the associated Debriefs have been closed

Line 482: fnd_msg_pub.ADD;

478: END IF;
479: IF NOT is_debrief_closed(v_task_assignment.task_assignment_id)
480: THEN
481: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');
482: fnd_msg_pub.ADD;
483: RAISE fnd_api.g_exc_error;
484: END IF;
485: END LOOP;
486: END IF;

Line 494: fnd_msg_pub.add;

490: RETURN TRUE;
491: ELSIF l_valid_status = TRUE
492: THEN
493: FND_MESSAGE.Set_Name('CSF', 'CSF_CLOSED_TASK');
494: fnd_msg_pub.add;
495: raise fnd_api.g_exc_error;
496: END IF;
497: ---- end of code for the bug 8282570
498: ELSE

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

500: END IF;
501: EXCEPTION
502: WHEN fnd_api.g_exc_error THEN
503: x_return_status := fnd_api.g_ret_sts_error;
504: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
505: RETURN FALSE;
506: WHEN fnd_api.g_exc_unexpected_error THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

504: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
505: RETURN FALSE;
506: WHEN fnd_api.g_exc_unexpected_error THEN
507: x_return_status := fnd_api.g_ret_sts_unexp_error;
508: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
509: RETURN FALSE;
510: WHEN OTHERS THEN
511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

508: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
509: RETURN FALSE;
510: WHEN OTHERS THEN
511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
513: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
514: END IF;
515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
516: RETURN FALSE;

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

509: RETURN FALSE;
510: WHEN OTHERS THEN
511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
513: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
514: END IF;
515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
516: RETURN FALSE;
517: END is_task_closable;

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

511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
513: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
514: END IF;
515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
516: RETURN FALSE;
517: END is_task_closable;
518:
519: /**

Line 590: fnd_msg_pub.ADD;

586: );
587:
588: IF NOT l_schedulable THEN
589: fnd_message.set_name('CSF', l_message_name);
590: fnd_msg_pub.ADD;
591: RAISE fnd_api.g_exc_error;
592: END IF;
593:
594: RETURN TRUE;

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

594: RETURN TRUE;
595: EXCEPTION
596: WHEN fnd_api.g_exc_error THEN
597: x_return_status := fnd_api.g_ret_sts_error;
598: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
599: RETURN FALSE;
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: x_return_status := fnd_api.g_ret_sts_unexp_error;
602: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

598: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
599: RETURN FALSE;
600: WHEN fnd_api.g_exc_unexpected_error THEN
601: x_return_status := fnd_api.g_ret_sts_unexp_error;
602: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
603: RETURN FALSE;
604: WHEN OTHERS THEN
605: x_return_status := fnd_api.g_ret_sts_unexp_error;
606: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

602: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
603: RETURN FALSE;
604: WHEN OTHERS THEN
605: x_return_status := fnd_api.g_ret_sts_unexp_error;
606: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
607: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
608: END IF;
609: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
610: RETURN FALSE;

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

603: RETURN FALSE;
604: WHEN OTHERS THEN
605: x_return_status := fnd_api.g_ret_sts_unexp_error;
606: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
607: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
608: END IF;
609: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
610: RETURN FALSE;
611: END is_task_schedulable;

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

605: x_return_status := fnd_api.g_ret_sts_unexp_error;
606: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
607: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
608: END IF;
609: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
610: RETURN FALSE;
611: END is_task_schedulable;
612:
613: FUNCTION is_task_scheduled (

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

659: RETURN FALSE;
660: EXCEPTION
661: WHEN OTHERS THEN
662: x_return_status := fnd_api.g_ret_sts_unexp_error;
663: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
664: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
665: END IF;
666: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
667: RETURN FALSE;

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

660: EXCEPTION
661: WHEN OTHERS THEN
662: x_return_status := fnd_api.g_ret_sts_unexp_error;
663: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
664: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
665: END IF;
666: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
667: RETURN FALSE;
668: END is_task_scheduled;

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

662: x_return_status := fnd_api.g_ret_sts_unexp_error;
663: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
664: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
665: END IF;
666: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
667: RETURN FALSE;
668: END is_task_scheduled;
669:
670: /**

Line 749: fnd_msg_pub.initialize;

745: END IF;
746:
747: -- Initialize message list if p_init_msg_list is set to TRUE
748: IF fnd_api.to_boolean (p_init_msg_list) THEN
749: fnd_msg_pub.initialize;
750: END IF;
751:
752: -- Initialize API return status to success
753: x_return_status := fnd_api.g_ret_sts_success;

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

773: IF fnd_api.to_boolean (p_commit) THEN
774: COMMIT WORK;
775: END IF;
776: -- Standard call to get message count and if count is 1, get message info
777: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
778: EXCEPTION
779: WHEN fnd_api.g_exc_error THEN
780: ROLLBACK TO close_task_pub;
781: x_return_status := fnd_api.g_ret_sts_error;

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

778: EXCEPTION
779: WHEN fnd_api.g_exc_error THEN
780: ROLLBACK TO close_task_pub;
781: x_return_status := fnd_api.g_ret_sts_error;
782: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
783: WHEN fnd_api.g_exc_unexpected_error THEN
784: ROLLBACK TO close_task_pub;
785: x_return_status := fnd_api.g_ret_sts_unexp_error;
786: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

782: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
783: WHEN fnd_api.g_exc_unexpected_error THEN
784: ROLLBACK TO close_task_pub;
785: x_return_status := fnd_api.g_ret_sts_unexp_error;
786: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
787: WHEN OTHERS THEN
788: x_return_status := fnd_api.g_ret_sts_unexp_error;
789: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

785: x_return_status := fnd_api.g_ret_sts_unexp_error;
786: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
787: WHEN OTHERS THEN
788: x_return_status := fnd_api.g_ret_sts_unexp_error;
789: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
791: END IF;
792: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
793: ROLLBACK TO close_task_pub;

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

786: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
787: WHEN OTHERS THEN
788: x_return_status := fnd_api.g_ret_sts_unexp_error;
789: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
791: END IF;
792: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
793: ROLLBACK TO close_task_pub;
794: END close_task;

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

788: x_return_status := fnd_api.g_ret_sts_unexp_error;
789: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
790: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
791: END IF;
792: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
793: ROLLBACK TO close_task_pub;
794: END close_task;
795:
796: -- Determines which tasks in a PL/SQL table are modified

Line 844: fnd_msg_pub.initialize;

840: END IF;
841:
842: -- initialize message list if p_init_msg_list is set to true
843: IF fnd_api.to_boolean (p_init_msg_list) THEN
844: fnd_msg_pub.initialize;
845: END IF;
846:
847: -- initialize api return status to success
848: x_return_status := fnd_api.g_ret_sts_success;

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

891: l_idx := x_collection.NEXT (l_idx);
892: END LOOP;
893:
894: -- standard call to get message count and if count is 1, get message info
895: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
896: EXCEPTION
897: WHEN OTHERS THEN
898: x_return_status := fnd_api.g_ret_sts_unexp_error;
899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

895: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
896: EXCEPTION
897: WHEN OTHERS THEN
898: x_return_status := fnd_api.g_ret_sts_unexp_error;
899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
901: END IF;
902: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
903: END identify_modified_tasks;

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

896: EXCEPTION
897: WHEN OTHERS THEN
898: x_return_status := fnd_api.g_ret_sts_unexp_error;
899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
901: END IF;
902: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
903: END identify_modified_tasks;
904:

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

898: x_return_status := fnd_api.g_ret_sts_unexp_error;
899: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
900: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
901: END IF;
902: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
903: END identify_modified_tasks;
904:
905: ---------------------------------------------------------------------------
906: -- validate_planned_dates

Line 1056: fnd_msg_pub.initialize;

1052: RAISE fnd_api.g_exc_unexpected_error;
1053: END IF;
1054:
1055: IF fnd_api.to_boolean (p_init_msg_list) THEN
1056: fnd_msg_pub.initialize;
1057: END IF;
1058:
1059: x_return_status := fnd_api.g_ret_sts_success;
1060:

Line 1074: fnd_msg_pub.ADD;

1070:
1071: -- Task is not schedulable.
1072: IF l_task_schedulable = FALSE OR x_return_status <> fnd_api.g_ret_sts_success THEN
1073: fnd_message.set_name ('CSF', l_reason_code);
1074: fnd_msg_pub.ADD;
1075: RAISE fnd_api.g_exc_error;
1076: END IF;
1077:
1078: jtf_tasks_pub.create_task (

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

1212: EXCEPTION
1213: WHEN fnd_api.g_exc_error THEN
1214: ROLLBACK TO csf_create_task_pub;
1215: x_return_status := fnd_api.g_ret_sts_error;
1216: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1217: WHEN fnd_api.g_exc_unexpected_error THEN
1218: ROLLBACK TO csf_create_task_pub;
1219: x_return_status := fnd_api.g_ret_sts_unexp_error;
1220: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1216: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1217: WHEN fnd_api.g_exc_unexpected_error THEN
1218: ROLLBACK TO csf_create_task_pub;
1219: x_return_status := fnd_api.g_ret_sts_unexp_error;
1220: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1221: WHEN OTHERS THEN
1222: x_return_status := fnd_api.g_ret_sts_unexp_error;
1223: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1224: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

1219: x_return_status := fnd_api.g_ret_sts_unexp_error;
1220: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1221: WHEN OTHERS THEN
1222: x_return_status := fnd_api.g_ret_sts_unexp_error;
1223: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1224: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1225: END IF;
1226: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1227: ROLLBACK TO csf_create_task_pub;

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

1220: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1221: WHEN OTHERS THEN
1222: x_return_status := fnd_api.g_ret_sts_unexp_error;
1223: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1224: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1225: END IF;
1226: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1227: ROLLBACK TO csf_create_task_pub;
1228: END create_task;

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

1222: x_return_status := fnd_api.g_ret_sts_unexp_error;
1223: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1224: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1225: END IF;
1226: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1227: ROLLBACK TO csf_create_task_pub;
1228: END create_task;
1229:
1230: PROCEDURE delete_task (

Line 1351: fnd_msg_pub.ADD;

1347: AND v_task_assignment.cancelled_flag = 'N'
1348: AND v_task_assignment.rejected_flag = 'N' )
1349: THEN
1350: fnd_message.set_name ('CSF', 'CSF_CLOSED_TASK');
1351: fnd_msg_pub.ADD;
1352: RAISE fnd_api.g_exc_error;
1353: END IF;
1354:
1355: -- Task Assignment is not open. Check for Debrief

Line 1358: fnd_msg_pub.ADD;

1354:
1355: -- Task Assignment is not open. Check for Debrief
1356: IF NOT is_debrief_closed(v_task_assignment.task_assignment_id) THEN
1357: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');
1358: fnd_msg_pub.ADD;
1359: RAISE fnd_api.g_exc_error;
1360: END IF;
1361:
1362: -- All validations done. Close the Task Assignment

Line 1447: fnd_msg_pub.initialize;

1443: END IF;
1444:
1445: -- Initialize message list if p_init_msg_list is set to TRUE
1446: IF fnd_api.to_boolean (p_init_msg_list) THEN
1447: fnd_msg_pub.initialize;
1448: END IF;
1449:
1450: -- Initialize API return status to success
1451: x_return_status := fnd_api.g_ret_sts_success;

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

1518: IF fnd_api.to_boolean (p_commit) THEN
1519: COMMIT WORK;
1520: END IF;
1521:
1522: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1523: EXCEPTION
1524: WHEN fnd_api.g_exc_error THEN
1525: ROLLBACK TO update_task_status_pub;
1526: x_return_status := fnd_api.g_ret_sts_error;

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

1523: EXCEPTION
1524: WHEN fnd_api.g_exc_error THEN
1525: ROLLBACK TO update_task_status_pub;
1526: x_return_status := fnd_api.g_ret_sts_error;
1527: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1528: WHEN fnd_api.g_exc_unexpected_error THEN
1529: ROLLBACK TO update_task_status_pub;
1530: x_return_status := fnd_api.g_ret_sts_unexp_error;
1531: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1527: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1528: WHEN fnd_api.g_exc_unexpected_error THEN
1529: ROLLBACK TO update_task_status_pub;
1530: x_return_status := fnd_api.g_ret_sts_unexp_error;
1531: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1532: WHEN OTHERS THEN
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1535: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

1530: x_return_status := fnd_api.g_ret_sts_unexp_error;
1531: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1532: WHEN OTHERS THEN
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1535: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1536: END IF;
1537: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1538: ROLLBACK TO update_task_status_pub;

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

1531: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1532: WHEN OTHERS THEN
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1535: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1536: END IF;
1537: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1538: ROLLBACK TO update_task_status_pub;
1539: END update_task_status;

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

1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1535: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1536: END IF;
1537: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1538: ROLLBACK TO update_task_status_pub;
1539: END update_task_status;
1540:
1541: PROCEDURE autoreject_task(

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

1580: IF fnd_api.to_boolean (p_commit) THEN
1581: COMMIT WORK;
1582: END IF;
1583:
1584: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1585:
1586: EXCEPTION
1587: WHEN fnd_api.g_exc_error THEN
1588: ROLLBACK TO autoreject_task;

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

1586: EXCEPTION
1587: WHEN fnd_api.g_exc_error THEN
1588: ROLLBACK TO autoreject_task;
1589: x_return_status := fnd_api.g_ret_sts_error;
1590: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1591: WHEN fnd_api.g_exc_unexpected_error THEN
1592: ROLLBACK TO autoreject_task;
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1590: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1591: WHEN fnd_api.g_exc_unexpected_error THEN
1592: ROLLBACK TO autoreject_task;
1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1595: WHEN OTHERS THEN
1596: x_return_status := fnd_api.g_ret_sts_unexp_error;
1597: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1598: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

1593: x_return_status := fnd_api.g_ret_sts_unexp_error;
1594: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1595: WHEN OTHERS THEN
1596: x_return_status := fnd_api.g_ret_sts_unexp_error;
1597: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1598: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1599: END IF;
1600: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1601: ROLLBACK TO autoreject_task;

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

1594: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1595: WHEN OTHERS THEN
1596: x_return_status := fnd_api.g_ret_sts_unexp_error;
1597: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1598: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1599: END IF;
1600: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1601: ROLLBACK TO autoreject_task;
1602: END autoreject_task;

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

1596: x_return_status := fnd_api.g_ret_sts_unexp_error;
1597: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1598: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1599: END IF;
1600: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1601: ROLLBACK TO autoreject_task;
1602: END autoreject_task;
1603:
1604: PROCEDURE update_task(

Line 1845: fnd_msg_pub.initialize;

1841: RAISE fnd_api.g_exc_unexpected_error;
1842: END IF;
1843:
1844: IF fnd_api.to_boolean (p_init_msg_list) THEN
1845: fnd_msg_pub.initialize;
1846: END IF;
1847:
1848: x_return_status := fnd_api.g_ret_sts_success;
1849:

Line 1891: fnd_msg_pub.add;

1887: AND l_planned_effort_minutes > CSR_SCHEDULER_PUB.GET_SCH_PARAMETER_VALUE('spDefaultShiftDuration')
1888: THEN
1889: fnd_message.set_name ('CSF', 'CSF_TASK_UPDATE_NOT_ALLOWED');
1890: fnd_message.set_token('TASK_NUMBER',l_task_number);
1891: fnd_msg_pub.add;
1892: RAISE fnd_api.g_exc_error;
1893: END IF;
1894:
1895: IF l_task_info.task_assignment_id IS NOT NULL

Line 2275: fnd_msg_pub.add;

2271: END IF;
2272:
2273: /*fnd_message.set_name('CSF','CSF_TASK_ACC_UPDATE_ERROR');
2274: fnd_message.set_token('VALUE',l_task_dtls.task_number);
2275: fnd_msg_pub.add;
2276: Add_Err_Msg;*/
2277: IF x_return_status = fnd_api.g_ret_sts_error THEN
2278: RAISE fnd_api.g_exc_error;
2279: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2295: fnd_msg_pub.add;

2291: IF l_overlap_tasks IS NOT NULL THEN
2292: fnd_message.set_name('CSR','CSR_TASK_OVERLAP');
2293: fnd_message.set_token('TASKID', l_task_number);
2294: fnd_message.set_token('TASKS',l_overlap_tasks);
2295: fnd_msg_pub.add;
2296: END IF;
2297:
2298: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2299:

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

2294: fnd_message.set_token('TASKS',l_overlap_tasks);
2295: fnd_msg_pub.add;
2296: END IF;
2297:
2298: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2299:
2300:
2301: EXCEPTION
2302: WHEN fnd_api.g_exc_error THEN

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

2301: EXCEPTION
2302: WHEN fnd_api.g_exc_error THEN
2303: ROLLBACK TO csf_update_task;
2304: x_return_status := fnd_api.g_ret_sts_error;
2305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2306: WHEN fnd_api.g_exc_unexpected_error THEN
2307: ROLLBACK TO csf_update_task;
2308: x_return_status := fnd_api.g_ret_sts_unexp_error;
2309: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2305: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2306: WHEN fnd_api.g_exc_unexpected_error THEN
2307: ROLLBACK TO csf_update_task;
2308: x_return_status := fnd_api.g_ret_sts_unexp_error;
2309: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2310: WHEN OTHERS THEN
2311: x_return_status := fnd_api.g_ret_sts_unexp_error;
2312: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2313: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

2308: x_return_status := fnd_api.g_ret_sts_unexp_error;
2309: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2310: WHEN OTHERS THEN
2311: x_return_status := fnd_api.g_ret_sts_unexp_error;
2312: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2313: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2314: END IF;
2315: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2316: ROLLBACK TO csf_update_task;

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

2309: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2310: WHEN OTHERS THEN
2311: x_return_status := fnd_api.g_ret_sts_unexp_error;
2312: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2313: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2314: END IF;
2315: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2316: ROLLBACK TO csf_update_task;
2317: END update_task;

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

2311: x_return_status := fnd_api.g_ret_sts_unexp_error;
2312: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2313: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2314: END IF;
2315: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2316: ROLLBACK TO csf_update_task;
2317: END update_task;
2318:
2319: PROCEDURE commit_task (

Line 2427: fnd_msg_pub.initialize;

2423: RAISE fnd_api.g_exc_unexpected_error;
2424: END IF;
2425:
2426: IF fnd_api.to_boolean (p_init_msg_list) THEN
2427: fnd_msg_pub.initialize;
2428: END IF;
2429:
2430: x_return_status := fnd_api.g_ret_sts_success;
2431:

Line 2442: fnd_msg_pub.ADD;

2438: IF c_task_details%NOTFOUND THEN
2439: CLOSE c_task_details;
2440: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
2441: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
2442: fnd_msg_pub.ADD;
2443: RAISE fnd_api.g_exc_error;
2444: END IF;
2445: CLOSE c_task_details;
2446: ELSE

Line 2453: fnd_msg_pub.ADD;

2449: IF c_task_details_1%NOTFOUND THEN
2450: CLOSE c_task_details_1;
2451: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
2452: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
2453: fnd_msg_pub.ADD;
2454: RAISE fnd_api.g_exc_error;
2455: END IF;
2456: CLOSE c_task_details_1;
2457: END IF;

Line 2463: fnd_msg_pub.ADD;

2459: -- Trip should not be in Blocked Status
2460: IF l_task_details.trip_status = csf_trips_pub.g_trip_unavailable THEN
2461: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TRIP_BLOCK');
2462: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2463: fnd_msg_pub.ADD;
2464: RAISE fnd_api.g_exc_error;
2465: END IF;
2466:
2467: -- Validate Status Transition

Line 2478: fnd_msg_pub.ADD;

2474: fnd_message.set_name ('CSF', 'CSF_INVALID_STATE_TRANSITION');
2475: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
2476: END IF;
2477: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_new_status_id));
2478: fnd_msg_pub.ADD;
2479: RAISE fnd_api.g_exc_error;
2480: END IF;
2481:
2482: -- Check the Customer Confirmation Status - Should be either No or Received

Line 2493: fnd_msg_pub.ADD;

2489: IF l_resource_tp IS NULL
2490: THEN
2491: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CUST_CONF');
2492: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2493: fnd_msg_pub.ADD;
2494: RAISE fnd_api.g_exc_error;
2495: END IF;
2496: END IF;
2497:

Line 2502: fnd_msg_pub.ADD;

2498: -- Check for Scheduled Dates
2499: IF l_task_details.scheduled_start_date IS NULL THEN
2500: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_SCHE');
2501: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2502: fnd_msg_pub.ADD;
2503: RAISE fnd_api.g_exc_error;
2504: END IF;
2505:
2506: csf_task_assignments_pub.update_assignment_status(

Line 2526: -- fnd_msg_pub.ADD;

2522: -- commented for the bug 6801965
2523: -- Committed Task Message is added to the message stack
2524: -- fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2525: -- fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2526: -- fnd_msg_pub.ADD;
2527: RETURN;
2528: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2529: RAISE fnd_api.g_exc_error;
2530: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

2539: EXCEPTION
2540: WHEN fnd_api.g_exc_error THEN
2541: ROLLBACK TO csf_commit_task;
2542: x_return_status := fnd_api.g_ret_sts_error;
2543: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2544: WHEN fnd_api.g_exc_unexpected_error THEN
2545: ROLLBACK TO csf_commit_task;
2546: x_return_status := fnd_api.g_ret_sts_unexp_error;
2547: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2543: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2544: WHEN fnd_api.g_exc_unexpected_error THEN
2545: ROLLBACK TO csf_commit_task;
2546: x_return_status := fnd_api.g_ret_sts_unexp_error;
2547: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2548: WHEN OTHERS THEN
2549: x_return_status := fnd_api.g_ret_sts_unexp_error;
2550: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2551: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

2546: x_return_status := fnd_api.g_ret_sts_unexp_error;
2547: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2548: WHEN OTHERS THEN
2549: x_return_status := fnd_api.g_ret_sts_unexp_error;
2550: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2551: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2552: END IF;
2553: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2554: ROLLBACK TO csf_commit_task;

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

2547: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2548: WHEN OTHERS THEN
2549: x_return_status := fnd_api.g_ret_sts_unexp_error;
2550: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2551: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2552: END IF;
2553: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2554: ROLLBACK TO csf_commit_task;
2555: END commit_task;

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

2549: x_return_status := fnd_api.g_ret_sts_unexp_error;
2550: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2551: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2552: END IF;
2553: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2554: ROLLBACK TO csf_commit_task;
2555: END commit_task;
2556:
2557: PROCEDURE commit_schedule (

Line 2672: fnd_msg_pub.initialize;

2668: RAISE fnd_api.g_exc_unexpected_error;
2669: END IF;
2670:
2671: IF fnd_api.to_boolean (p_init_msg_list) THEN
2672: fnd_msg_pub.initialize;
2673: END IF;
2674:
2675: x_return_status := fnd_api.g_ret_sts_success;
2676:

Line 2682: fnd_msg_pub.ADD;

2678: 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
2679: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2680: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2681: fnd_message.set_token('PARAM_NAME', 'P_QUERY_ID');
2682: fnd_msg_pub.ADD;
2683: RAISE fnd_api.g_exc_error;
2684: END IF;
2685:
2686: IF p_query_id IS NOT NULL AND p_query_id <> -9999 THEN

Line 2883: fnd_msg_pub.ADD;

2879:
2880: -- Process each Task in the Task List
2881: IF l_task_id_tbl.COUNT = 0 THEN -- if there are no tasks in the trip #bug7146595
2882: fnd_message.set_name('CSF','CSF_NO_TASK_FOR_RESOURCE');
2883: fnd_msg_pub.ADD;
2884: END IF; -- end of code for the bug7146595
2885:
2886: FOR i IN 1..l_task_id_tbl.COUNT
2887: LOOP

Line 2898: fnd_msg_pub.ADD;

2894: IF l_cnt > 1
2895: THEN
2896: fnd_message.set_name('CSF','CSF_AUTO_COMMIT_MULTI_RES');
2897: fnd_message.set_token ('TASK', task_number(l_task_id_tbl(i)));
2898: fnd_msg_pub.ADD;
2899: l_all_passed := FALSE;
2900: --End of the code added for this bug 6866929
2901: ELSE
2902: IF l_task_split_flag_tbl(i) IS NOT NULL THEN

Line 2915: fnd_msg_pub.ADD;

2911: IF l_trip_status_tbl(j) = csf_trips_pub.g_trip_unavailable THEN
2912: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CHILD_TRIP_BLK');
2913: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_child_task_id_tbl(j)));
2914: fnd_message.set_token ('P_PARENT_TASK', task_number(l_task_id_tbl(i)));
2915: fnd_msg_pub.ADD;
2916: l_blocked_trip_found := TRUE;
2917: l_all_passed := FALSE;
2918: EXIT;
2919: END IF;

Line 2966: fnd_msg_pub.ADD;

2962:
2963:
2964: IF l_processed_count = 0 AND p_query_id IS NOT NULL THEN
2965: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_NO_TASK');
2966: fnd_msg_pub.ADD;
2967: x_return_status := fnd_api.g_ret_sts_error;
2968: END IF;
2969:
2970: IF NOT l_all_passed THEN

Line 2979: fnd_msg_pub.ADD;

2975: FOR i in 1..l_task_num_tbl.count
2976: LOOP
2977: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2978: fnd_message.set_token ('P_TASK_NUMBER', task_number(l_task_num_tbl(i)));
2979: fnd_msg_pub.ADD;
2980: END LOOP;
2981: END IF;
2982: -- end of code for the bug 6801965
2983: CLOSE c_task_list;

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

2985: IF fnd_api.to_boolean (p_commit) THEN
2986: COMMIT WORK;
2987: END IF;
2988:
2989: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2990: EXCEPTION
2991: WHEN fnd_api.g_exc_error THEN
2992: ROLLBACK TO csf_commit_schedule;
2993: x_return_status := fnd_api.g_ret_sts_error;

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

2990: EXCEPTION
2991: WHEN fnd_api.g_exc_error THEN
2992: ROLLBACK TO csf_commit_schedule;
2993: x_return_status := fnd_api.g_ret_sts_error;
2994: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2995: WHEN fnd_api.g_exc_unexpected_error THEN
2996: ROLLBACK TO csf_commit_schedule;
2997: x_return_status := fnd_api.g_ret_sts_unexp_error;
2998: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2994: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2995: WHEN fnd_api.g_exc_unexpected_error THEN
2996: ROLLBACK TO csf_commit_schedule;
2997: x_return_status := fnd_api.g_ret_sts_unexp_error;
2998: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2999: WHEN OTHERS THEN
3000: x_return_status := fnd_api.g_ret_sts_unexp_error;
3001: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3002: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

2997: x_return_status := fnd_api.g_ret_sts_unexp_error;
2998: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2999: WHEN OTHERS THEN
3000: x_return_status := fnd_api.g_ret_sts_unexp_error;
3001: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3002: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3003: END IF;
3004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3005: ROLLBACK TO csf_commit_schedule;

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

2998: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2999: WHEN OTHERS THEN
3000: x_return_status := fnd_api.g_ret_sts_unexp_error;
3001: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3002: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3003: END IF;
3004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3005: ROLLBACK TO csf_commit_schedule;
3006: END commit_schedule;

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

3000: x_return_status := fnd_api.g_ret_sts_unexp_error;
3001: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3002: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3003: END IF;
3004: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3005: ROLLBACK TO csf_commit_schedule;
3006: END commit_schedule;
3007:
3008: /**

Line 3205: fnd_msg_pub.initialize;

3201: RAISE fnd_api.g_exc_unexpected_error;
3202: END IF;
3203:
3204: IF fnd_api.to_boolean (p_init_msg_list) THEN
3205: fnd_msg_pub.initialize;
3206: END IF;
3207:
3208: x_return_status := fnd_api.g_ret_sts_success;
3209:

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

3338: EXCEPTION
3339: WHEN fnd_api.g_exc_error THEN
3340: ROLLBACK TO csf_sync_parent_with_child;
3341: x_return_status := fnd_api.g_ret_sts_error;
3342: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3343: WHEN fnd_api.g_exc_unexpected_error THEN
3344: ROLLBACK TO csf_sync_parent_with_child;
3345: x_return_status := fnd_api.g_ret_sts_unexp_error;
3346: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3342: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3343: WHEN fnd_api.g_exc_unexpected_error THEN
3344: ROLLBACK TO csf_sync_parent_with_child;
3345: x_return_status := fnd_api.g_ret_sts_unexp_error;
3346: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3347: WHEN OTHERS THEN
3348: x_return_status := fnd_api.g_ret_sts_unexp_error;
3349: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3350: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

3345: x_return_status := fnd_api.g_ret_sts_unexp_error;
3346: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3347: WHEN OTHERS THEN
3348: x_return_status := fnd_api.g_ret_sts_unexp_error;
3349: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3350: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3351: END IF;
3352: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3353: ROLLBACK TO csf_sync_parent_with_child;

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

3346: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3347: WHEN OTHERS THEN
3348: x_return_status := fnd_api.g_ret_sts_unexp_error;
3349: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3350: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3351: END IF;
3352: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3353: ROLLBACK TO csf_sync_parent_with_child;
3354: END sync_parent_with_child;

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

3348: x_return_status := fnd_api.g_ret_sts_unexp_error;
3349: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3350: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3351: END IF;
3352: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3353: ROLLBACK TO csf_sync_parent_with_child;
3354: END sync_parent_with_child;
3355:
3356: /**

Line 3401: fnd_msg_pub.initialize;

3397: RAISE fnd_api.g_exc_unexpected_error;
3398: END IF;
3399:
3400: IF fnd_api.to_boolean (p_init_msg_list) THEN
3401: fnd_msg_pub.initialize;
3402: END IF;
3403:
3404: x_return_status := fnd_api.g_ret_sts_success;
3405:

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

3444: EXCEPTION
3445: WHEN fnd_api.g_exc_error THEN
3446: ROLLBACK TO csf_sync_child_from_parent;
3447: x_return_status := fnd_api.g_ret_sts_error;
3448: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3449: WHEN fnd_api.g_exc_unexpected_error THEN
3450: ROLLBACK TO csf_sync_child_from_parent;
3451: x_return_status := fnd_api.g_ret_sts_unexp_error;
3452: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

3448: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3449: WHEN fnd_api.g_exc_unexpected_error THEN
3450: ROLLBACK TO csf_sync_child_from_parent;
3451: x_return_status := fnd_api.g_ret_sts_unexp_error;
3452: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3453: WHEN OTHERS THEN
3454: x_return_status := fnd_api.g_ret_sts_unexp_error;
3455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

3451: x_return_status := fnd_api.g_ret_sts_unexp_error;
3452: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3453: WHEN OTHERS THEN
3454: x_return_status := fnd_api.g_ret_sts_unexp_error;
3455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3457: END IF;
3458: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3459: ROLLBACK TO csf_sync_child_from_parent;

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

3452: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3453: WHEN OTHERS THEN
3454: x_return_status := fnd_api.g_ret_sts_unexp_error;
3455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3457: END IF;
3458: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3459: ROLLBACK TO csf_sync_child_from_parent;
3460: END sync_child_from_parent;

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

3454: x_return_status := fnd_api.g_ret_sts_unexp_error;
3455: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3456: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3457: END IF;
3458: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
3459: ROLLBACK TO csf_sync_child_from_parent;
3460: END sync_child_from_parent;
3461:
3462: PROCEDURE assign_task(

Line 3533: fnd_msg_pub.initialize;

3529: RAISE fnd_api.g_exc_unexpected_error;
3530: END IF;
3531:
3532: IF fnd_api.to_boolean(p_init_msg_list) THEN
3533: fnd_msg_pub.initialize;
3534: END IF;
3535:
3536: x_return_status := fnd_api.g_ret_sts_success;
3537:

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

3540: FETCH c_task_info INTO l_task_info;
3541: CLOSE c_task_info;
3542:
3543: IF l_task_info.task_id IS NULL THEN
3544: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
3545: RAISE fnd_api.g_exc_unexpected_error;
3546: END IF;
3547:
3548: -- If the Task is already Scheduled, then the Task Should be treated to be

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

3685: IF fnd_api.to_boolean(p_commit) THEN
3686: COMMIT WORK;
3687: END IF;
3688:
3689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3690:
3691: EXCEPTION
3692: WHEN fnd_api.g_exc_error THEN
3693: ROLLBACK TO csf_assign_task;

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

3691: EXCEPTION
3692: WHEN fnd_api.g_exc_error THEN
3693: ROLLBACK TO csf_assign_task;
3694: x_return_status := fnd_api.g_ret_sts_error;
3695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3696: WHEN fnd_api.g_exc_unexpected_error THEN
3697: ROLLBACK TO csf_assign_task;
3698: x_return_status := fnd_api.g_ret_sts_unexp_error;
3699: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3695: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3696: WHEN fnd_api.g_exc_unexpected_error THEN
3697: ROLLBACK TO csf_assign_task;
3698: x_return_status := fnd_api.g_ret_sts_unexp_error;
3699: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3700: WHEN OTHERS THEN
3701: x_return_status := fnd_api.g_ret_sts_unexp_error;
3702: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3703: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

3698: x_return_status := fnd_api.g_ret_sts_unexp_error;
3699: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3700: WHEN OTHERS THEN
3701: x_return_status := fnd_api.g_ret_sts_unexp_error;
3702: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3703: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3704: END IF;
3705: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3706: ROLLBACK TO csf_assign_task;

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

3699: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3700: WHEN OTHERS THEN
3701: x_return_status := fnd_api.g_ret_sts_unexp_error;
3702: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3703: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3704: END IF;
3705: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3706: ROLLBACK TO csf_assign_task;
3707: END assign_task;

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

3701: x_return_status := fnd_api.g_ret_sts_unexp_error;
3702: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3703: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3704: END IF;
3705: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3706: ROLLBACK TO csf_assign_task;
3707: END assign_task;
3708:
3709: PROCEDURE unassign_task(

Line 3758: fnd_msg_pub.initialize;

3754: RAISE fnd_api.g_exc_unexpected_error;
3755: END IF;
3756:
3757: IF fnd_api.to_boolean(p_init_msg_list) THEN
3758: fnd_msg_pub.initialize;
3759: END IF;
3760:
3761: x_return_status := fnd_api.g_ret_sts_success;
3762:

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

3856: EXCEPTION
3857: WHEN fnd_api.g_exc_error THEN
3858: ROLLBACK TO csf_unassign_task;
3859: x_return_status := fnd_api.g_ret_sts_error;
3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3861: WHEN fnd_api.g_exc_unexpected_error THEN
3862: ROLLBACK TO csf_unassign_task;
3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3861: WHEN fnd_api.g_exc_unexpected_error THEN
3862: ROLLBACK TO csf_unassign_task;
3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3865: WHEN OTHERS THEN
3866: x_return_status := fnd_api.g_ret_sts_unexp_error;
3867: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3868: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3865: WHEN OTHERS THEN
3866: x_return_status := fnd_api.g_ret_sts_unexp_error;
3867: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3868: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3869: END IF;
3870: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3871: ROLLBACK TO csf_unassign_task;

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

3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3865: WHEN OTHERS THEN
3866: x_return_status := fnd_api.g_ret_sts_unexp_error;
3867: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3868: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3869: END IF;
3870: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3871: ROLLBACK TO csf_unassign_task;
3872: END unassign_task;

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

3866: x_return_status := fnd_api.g_ret_sts_unexp_error;
3867: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3868: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3869: END IF;
3870: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3871: ROLLBACK TO csf_unassign_task;
3872: END unassign_task;
3873:
3874: PROCEDURE update_task_and_assignment(

Line 3907: fnd_msg_pub.initialize;

3903: RAISE fnd_api.g_exc_unexpected_error;
3904: END IF;
3905:
3906: IF fnd_api.to_boolean(p_init_msg_list) THEN
3907: fnd_msg_pub.initialize;
3908: END IF;
3909:
3910: x_return_status := fnd_api.g_ret_sts_success;
3911:

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

3962: EXCEPTION
3963: WHEN fnd_api.g_exc_error THEN
3964: ROLLBACK TO csf_update_task_and_assignment;
3965: x_return_status := fnd_api.g_ret_sts_error;
3966: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3967: WHEN fnd_api.g_exc_unexpected_error THEN
3968: ROLLBACK TO csf_update_task_and_assignment;
3969: x_return_status := fnd_api.g_ret_sts_unexp_error;
3970: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3966: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3967: WHEN fnd_api.g_exc_unexpected_error THEN
3968: ROLLBACK TO csf_update_task_and_assignment;
3969: x_return_status := fnd_api.g_ret_sts_unexp_error;
3970: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3971: WHEN OTHERS THEN
3972: x_return_status := fnd_api.g_ret_sts_unexp_error;
3973: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3974: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

3969: x_return_status := fnd_api.g_ret_sts_unexp_error;
3970: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3971: WHEN OTHERS THEN
3972: x_return_status := fnd_api.g_ret_sts_unexp_error;
3973: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3974: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3975: END IF;
3976: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3977: ROLLBACK TO csf_update_task_and_assignment;

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

3970: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3971: WHEN OTHERS THEN
3972: x_return_status := fnd_api.g_ret_sts_unexp_error;
3973: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3974: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3975: END IF;
3976: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3977: ROLLBACK TO csf_update_task_and_assignment;
3978: END update_task_and_assignment;

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

3972: x_return_status := fnd_api.g_ret_sts_unexp_error;
3973: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3974: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3975: END IF;
3976: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3977: ROLLBACK TO csf_update_task_and_assignment;
3978: END update_task_and_assignment;
3979:
3980: PROCEDURE update_task_longer_than_shift(

Line 4035: fnd_msg_pub.initialize;

4031: RAISE fnd_api.g_exc_unexpected_error;
4032: END IF;
4033:
4034: IF fnd_api.to_boolean(p_init_msg_list) THEN
4035: fnd_msg_pub.initialize;
4036: END IF;
4037:
4038: x_return_status := fnd_api.g_ret_sts_success;
4039:

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

4042: FETCH c_parent_task_info INTO l_parent_task_info;
4043: CLOSE c_parent_task_info;
4044:
4045: IF l_parent_task_info.task_id IS NULL THEN
4046: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
4047: RAISE fnd_api.g_exc_unexpected_error;
4048: END IF;
4049:
4050: -- Find out whether the new Task Status is valid.

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

4143: EXCEPTION
4144: WHEN fnd_api.g_exc_error THEN
4145: ROLLBACK TO update_task_longer_than_shift;
4146: x_return_status := fnd_api.g_ret_sts_error;
4147: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4148: WHEN fnd_api.g_exc_unexpected_error THEN
4149: ROLLBACK TO update_task_longer_than_shift;
4150: x_return_status := fnd_api.g_ret_sts_unexp_error;
4151: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4147: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4148: WHEN fnd_api.g_exc_unexpected_error THEN
4149: ROLLBACK TO update_task_longer_than_shift;
4150: x_return_status := fnd_api.g_ret_sts_unexp_error;
4151: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4152: WHEN OTHERS THEN
4153: x_return_status := fnd_api.g_ret_sts_unexp_error;
4154: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4155: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

4150: x_return_status := fnd_api.g_ret_sts_unexp_error;
4151: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4152: WHEN OTHERS THEN
4153: x_return_status := fnd_api.g_ret_sts_unexp_error;
4154: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4155: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4156: END IF;
4157: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4158: ROLLBACK TO update_task_longer_than_shift;

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

4151: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4152: WHEN OTHERS THEN
4153: x_return_status := fnd_api.g_ret_sts_unexp_error;
4154: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4155: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4156: END IF;
4157: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4158: ROLLBACK TO update_task_longer_than_shift;
4159: END update_task_longer_than_shift;

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

4153: x_return_status := fnd_api.g_ret_sts_unexp_error;
4154: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4155: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4156: END IF;
4157: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4158: ROLLBACK TO update_task_longer_than_shift;
4159: END update_task_longer_than_shift;
4160:
4161: PROCEDURE create_child_task(

Line 4236: fnd_msg_pub.initialize;

4232: RAISE fnd_api.g_exc_unexpected_error;
4233: END IF;
4234:
4235: IF fnd_api.to_boolean(p_init_msg_list) THEN
4236: fnd_msg_pub.initialize;
4237: END IF;
4238:
4239: x_return_status := fnd_api.g_ret_sts_success;
4240:

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

4242: OPEN c_parent_task_info;
4243: FETCH c_parent_task_info INTO l_parent_task_info;
4244: IF c_parent_task_info%NOTFOUND THEN
4245: CLOSE c_parent_task_info;
4246: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_parent_task_id);
4247: RAISE fnd_api.g_exc_unexpected_error;
4248: END IF;
4249: CLOSE c_parent_task_info;
4250:

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

4403: EXCEPTION
4404: WHEN fnd_api.g_exc_error THEN
4405: ROLLBACK TO csf_create_child_task;
4406: x_return_status := fnd_api.g_ret_sts_error;
4407: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4408: WHEN fnd_api.g_exc_unexpected_error THEN
4409: ROLLBACK TO csf_create_child_task;
4410: x_return_status := fnd_api.g_ret_sts_unexp_error;
4411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4407: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4408: WHEN fnd_api.g_exc_unexpected_error THEN
4409: ROLLBACK TO csf_create_child_task;
4410: x_return_status := fnd_api.g_ret_sts_unexp_error;
4411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4412: WHEN OTHERS THEN
4413: x_return_status := fnd_api.g_ret_sts_unexp_error;
4414: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4415: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

4410: x_return_status := fnd_api.g_ret_sts_unexp_error;
4411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4412: WHEN OTHERS THEN
4413: x_return_status := fnd_api.g_ret_sts_unexp_error;
4414: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4415: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4416: END IF;
4417: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4418: ROLLBACK TO csf_create_child_task;

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

4411: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4412: WHEN OTHERS THEN
4413: x_return_status := fnd_api.g_ret_sts_unexp_error;
4414: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4415: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4416: END IF;
4417: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4418: ROLLBACK TO csf_create_child_task;
4419: END create_child_task;

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

4413: x_return_status := fnd_api.g_ret_sts_unexp_error;
4414: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4415: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4416: END IF;
4417: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4418: ROLLBACK TO csf_create_child_task;
4419: END create_child_task;
4420:
4421: /**

Line 4490: fnd_msg_pub.initialize;

4486:
4487: x_return_status := fnd_api.g_ret_sts_success;
4488:
4489: IF fnd_api.to_boolean (p_init_msg_list) THEN
4490: fnd_msg_pub.initialize;
4491: END IF;
4492:
4493: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
4494: RAISE fnd_api.g_exc_unexpected_error;

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

4599: EXCEPTION
4600: WHEN fnd_api.g_exc_error THEN
4601: ROLLBACK TO csf_update_cust_confirmation;
4602: x_return_status := fnd_api.g_ret_sts_error;
4603: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4604: WHEN fnd_api.g_exc_unexpected_error THEN
4605: ROLLBACK TO csf_update_cust_confirmation;
4606: x_return_status := fnd_api.g_ret_sts_unexp_error;
4607: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4603: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4604: WHEN fnd_api.g_exc_unexpected_error THEN
4605: ROLLBACK TO csf_update_cust_confirmation;
4606: x_return_status := fnd_api.g_ret_sts_unexp_error;
4607: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4608: WHEN OTHERS THEN
4609: x_return_status := fnd_api.g_ret_sts_unexp_error;
4610: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4611: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

4606: x_return_status := fnd_api.g_ret_sts_unexp_error;
4607: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4608: WHEN OTHERS THEN
4609: x_return_status := fnd_api.g_ret_sts_unexp_error;
4610: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4611: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4612: END IF;
4613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4614: ROLLBACK TO csf_update_cust_confirmation;

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

4607: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4608: WHEN OTHERS THEN
4609: x_return_status := fnd_api.g_ret_sts_unexp_error;
4610: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4611: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4612: END IF;
4613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4614: ROLLBACK TO csf_update_cust_confirmation;
4615: END update_cust_confirmation;

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

4609: x_return_status := fnd_api.g_ret_sts_unexp_error;
4610: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4611: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4612: END IF;
4613: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4614: ROLLBACK TO csf_update_cust_confirmation;
4615: END update_cust_confirmation;
4616:
4617: FUNCTION get_task_location_id (

Line 5067: fnd_msg_pub.initialize;

5063:
5064: x_return_status := fnd_api.g_ret_sts_success;
5065:
5066: IF fnd_api.to_boolean (p_init_msg_list) THEN
5067: fnd_msg_pub.initialize;
5068: END IF;
5069:
5070:
5071: jtf_tasks_pub.create_task(

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

5116: Exception
5117: WHEN fnd_api.g_exc_error THEN
5118: ROLLBACK TO csf_create_per_task;
5119: x_return_status := fnd_api.g_ret_sts_error;
5120: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5121: WHEN fnd_api.g_exc_unexpected_error THEN
5122: ROLLBACK TO csf_create_per_task;
5123: x_return_status := fnd_api.g_ret_sts_unexp_error;
5124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5120: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5121: WHEN fnd_api.g_exc_unexpected_error THEN
5122: ROLLBACK TO csf_create_per_task;
5123: x_return_status := fnd_api.g_ret_sts_unexp_error;
5124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5125: WHEN OTHERS THEN
5126: x_return_status := fnd_api.g_ret_sts_unexp_error;
5127: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5128: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

5123: x_return_status := fnd_api.g_ret_sts_unexp_error;
5124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5125: WHEN OTHERS THEN
5126: x_return_status := fnd_api.g_ret_sts_unexp_error;
5127: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5128: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5129: END IF;
5130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5131: ROLLBACK TO csf_create_per_task;

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

5124: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5125: WHEN OTHERS THEN
5126: x_return_status := fnd_api.g_ret_sts_unexp_error;
5127: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5128: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5129: END IF;
5130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5131: ROLLBACK TO csf_create_per_task;
5132: end;

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

5126: x_return_status := fnd_api.g_ret_sts_unexp_error;
5127: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5128: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5129: END IF;
5130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5131: ROLLBACK TO csf_create_per_task;
5132: end;
5133:
5134: procedure update_personal_task(

Line 5198: fnd_msg_pub.initialize;

5194:
5195: x_return_status := fnd_api.g_ret_sts_success;
5196:
5197: IF fnd_api.to_boolean (p_init_msg_list) THEN
5198: fnd_msg_pub.initialize;
5199: END IF;
5200:
5201: open c_obj(p_task_id);
5202: fetch c_obj into l_obj;

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

5244: Exception
5245: WHEN fnd_api.g_exc_error THEN
5246: ROLLBACK TO csf_update_per_task;
5247: x_return_status := fnd_api.g_ret_sts_error;
5248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5249: WHEN fnd_api.g_exc_unexpected_error THEN
5250: ROLLBACK TO csf_update_per_task;
5251: x_return_status := fnd_api.g_ret_sts_unexp_error;
5252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

5248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5249: WHEN fnd_api.g_exc_unexpected_error THEN
5250: ROLLBACK TO csf_update_per_task;
5251: x_return_status := fnd_api.g_ret_sts_unexp_error;
5252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5253: WHEN OTHERS THEN
5254: x_return_status := fnd_api.g_ret_sts_unexp_error;
5255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

5251: x_return_status := fnd_api.g_ret_sts_unexp_error;
5252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5253: WHEN OTHERS THEN
5254: x_return_status := fnd_api.g_ret_sts_unexp_error;
5255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5257: END IF;
5258: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5259: ROLLBACK TO csf_update_per_task;

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

5252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5253: WHEN OTHERS THEN
5254: x_return_status := fnd_api.g_ret_sts_unexp_error;
5255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5257: END IF;
5258: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5259: ROLLBACK TO csf_update_per_task;
5260: end;

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

5254: x_return_status := fnd_api.g_ret_sts_unexp_error;
5255: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5256: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
5257: END IF;
5258: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
5259: ROLLBACK TO csf_update_per_task;
5260: end;
5261: PROCEDURE set_desc_field_attr(
5262: p_inst_flex_fld_tbl IN csf_tasks_pub.Inst_flexfld_rec_type

Line 5514: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

5510: EXCEPTION
5511: WHEN fnd_api.g_exc_error THEN
5512: ROLLBACK TO set_desc_field_attr;
5513: p_return_status := fnd_api.g_ret_sts_error;
5514: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
5515:
5516: WHEN fnd_api.g_exc_unexpected_error THEN
5517: ROLLBACK TO set_desc_field_attr;
5518: p_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5519: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

5515:
5516: WHEN fnd_api.g_exc_unexpected_error THEN
5517: ROLLBACK TO set_desc_field_attr;
5518: p_return_status := fnd_api.g_ret_sts_unexp_error;
5519: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
5520:
5521: WHEN OTHERS THEN
5522: ROLLBACK TO set_desc_field_attr;
5523: p_return_status := fnd_api.g_ret_sts_unexp_error;

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

5520:
5521: WHEN OTHERS THEN
5522: ROLLBACK TO set_desc_field_attr;
5523: p_return_status := fnd_api.g_ret_sts_unexp_error;
5524: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5525: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5526: END IF;
5527: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
5528:

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

5521: WHEN OTHERS THEN
5522: ROLLBACK TO set_desc_field_attr;
5523: p_return_status := fnd_api.g_ret_sts_unexp_error;
5524: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5525: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5526: END IF;
5527: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
5528:
5529: END set_desc_field_attr;

Line 5527: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);

5523: p_return_status := fnd_api.g_ret_sts_unexp_error;
5524: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5525: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5526: END IF;
5527: fnd_msg_pub.count_and_get (p_count => p_msg_count, p_data => p_msg_data);
5528:
5529: END set_desc_field_attr;
5530:
5531:

Line 5578: fnd_msg_pub.initialize;

5574: END IF;
5575:
5576: -- Initialize message list if p_init_msg_list is set to TRUE
5577: IF fnd_api.to_boolean (p_init_msg_list) THEN
5578: fnd_msg_pub.initialize;
5579: END IF;
5580:
5581: -- Initialize API return status to success
5582: x_return_status := fnd_api.g_ret_sts_success;

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

5624: IF fnd_api.to_boolean (p_commit) THEN
5625: null;
5626: END IF;
5627:
5628: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5629: EXCEPTION
5630: WHEN fnd_api.g_exc_error THEN
5631: ROLLBACK TO update_task_attr;
5632: x_return_status := fnd_api.g_ret_sts_error;

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

5629: EXCEPTION
5630: WHEN fnd_api.g_exc_error THEN
5631: ROLLBACK TO update_task_attr;
5632: x_return_status := fnd_api.g_ret_sts_error;
5633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5634: WHEN fnd_api.g_exc_unexpected_error THEN
5635: ROLLBACK TO update_task_attr;
5636: x_return_status := fnd_api.g_ret_sts_unexp_error;
5637: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

5633: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5634: WHEN fnd_api.g_exc_unexpected_error THEN
5635: ROLLBACK TO update_task_attr;
5636: x_return_status := fnd_api.g_ret_sts_unexp_error;
5637: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5638: WHEN OTHERS THEN
5639: x_return_status := fnd_api.g_ret_sts_unexp_error;
5640: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5641: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

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

5636: x_return_status := fnd_api.g_ret_sts_unexp_error;
5637: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5638: WHEN OTHERS THEN
5639: x_return_status := fnd_api.g_ret_sts_unexp_error;
5640: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5641: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5642: END IF;
5643: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5644: ROLLBACK TO update_task_attr;

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

5637: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5638: WHEN OTHERS THEN
5639: x_return_status := fnd_api.g_ret_sts_unexp_error;
5640: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5641: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5642: END IF;
5643: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5644: ROLLBACK TO update_task_attr;
5645: END update_task_attr;

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

5639: x_return_status := fnd_api.g_ret_sts_unexp_error;
5640: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
5641: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5642: END IF;
5643: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
5644: ROLLBACK TO update_task_attr;
5645: END update_task_attr;
5646:
5647:

Line 5833: fnd_msg_pub.add;

5829: x_msg_data => x_msg_data );
5830:
5831: /*fnd_message.set_name('CSF','CSF_TASK_ACC_UPDATE_ERROR');
5832: fnd_message.set_token('VALUE',l_task_dtls.task_number);
5833: fnd_msg_pub.add;
5834: Add_Err_Msg;*/
5835: IF x_return_status = fnd_api.g_ret_sts_error THEN
5836: RAISE fnd_api.g_exc_error;
5837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 5905: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )

5901: EXCEPTION
5902: WHEN fnd_api.g_exc_unexpected_error THEN
5903: ROLLBACK TO create_achrs_s;
5904: x_return_status := fnd_api.g_ret_sts_unexp_error;
5905: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
5906: then
5907: fnd_msg_pub.add_exc_msg ( g_pkg_name, l_api_name );
5908: end if;
5909: WHEN OTHERS THEN

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

5903: ROLLBACK TO create_achrs_s;
5904: x_return_status := fnd_api.g_ret_sts_unexp_error;
5905: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
5906: then
5907: fnd_msg_pub.add_exc_msg ( g_pkg_name, l_api_name );
5908: end if;
5909: WHEN OTHERS THEN
5910: ROLLBACK TO create_achrs_s;
5911: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5912: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )

5908: end if;
5909: WHEN OTHERS THEN
5910: ROLLBACK TO create_achrs_s;
5911: x_return_status := fnd_api.g_ret_sts_unexp_error;
5912: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
5913: then
5914: fnd_msg_pub.add_exc_msg ( g_pkg_name, l_api_name );
5915: end if;
5916: END create_achrs;

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

5910: ROLLBACK TO create_achrs_s;
5911: x_return_status := fnd_api.g_ret_sts_unexp_error;
5912: if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
5913: then
5914: fnd_msg_pub.add_exc_msg ( g_pkg_name, l_api_name );
5915: end if;
5916: END create_achrs;
5917: END csf_tasks_pub;