DBA Data[Home] [Help]

APPS.JTF_TASK_TEMPLATES_PUB dependencies on FND_MSG_PUB

Line 89: fnd_msg_pub.initialize;

85: END IF;
86:
87: IF fnd_api.to_boolean (p_init_msg_list)
88: THEN
89: fnd_msg_pub.initialize;
90: END IF;
91:
92: jtf_task_templates_pvt.create_task
93: (

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

155: THEN
156: COMMIT WORK;
157: END IF;
158:
159: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
160: EXCEPTION
161: WHEN fnd_api.g_exc_unexpected_error
162: THEN
163: ROLLBACK TO create_task_pub1;

Line 165: fnd_msg_pub.count_and_get (

161: WHEN fnd_api.g_exc_unexpected_error
162: THEN
163: ROLLBACK TO create_task_pub1;
164: x_return_status := fnd_api.g_ret_sts_unexp_error;
165: fnd_msg_pub.count_and_get (
166: p_count => x_msg_count,
167: p_data => x_msg_data
168: );
169: WHEN OTHERS

Line 175: fnd_msg_pub.count_and_get (

171: ROLLBACK TO create_task_pub1;
172: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
173: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175: fnd_msg_pub.count_and_get (
176: p_count => x_msg_count,
177: p_data => x_msg_data
178: );
179: END;

Line 279: fnd_msg_pub.initialize;

275: END IF;
276:
277: IF fnd_api.to_boolean (p_init_msg_list)
278: THEN
279: fnd_msg_pub.initialize;
280: END IF;
281:
282: -------
283: ------- Validate Task Type

Line 295: fnd_msg_pub.add;

291:
292: IF l_task_type_id IS NULL
293: THEN
294: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TYPE');
295: fnd_msg_pub.add;
296: RAISE fnd_api.g_exc_unexpected_error;
297: END IF;
298:
299: -------

Line 319: fnd_msg_pub.add;

315:
316: IF l_task_status_id IS NULL
317: THEN
318: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_STATUS');
319: fnd_msg_pub.add;
320: RAISE fnd_api.g_exc_unexpected_error;
321: END IF;
322:
323:

Line 505: fnd_msg_pub.add ;

501: END IF;
502:
503: if l_task_group_id is null then
504: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_GROUP');
505: fnd_msg_pub.add ;
506: x_return_status := fnd_api.g_ret_sts_unexp_error;
507: RAISE fnd_api.g_exc_unexpected_error;
508: end if ;
509:

Line 576: fnd_msg_pub.add;

572:
573: IF c_task_templates%NOTFOUND
574: THEN
575: fnd_message.set_name ('JTF', 'JTF_TASK_ERROR_CREATING_TEMP');
576: fnd_msg_pub.add;
577: x_return_status := fnd_api.g_ret_sts_unexp_error;
578: RAISE fnd_api.g_exc_unexpected_error;
579: END IF;
580:

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

674: THEN
675: COMMIT WORK;
676: END IF;
677:
678: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
679: EXCEPTION
680: WHEN fnd_api.g_exc_unexpected_error
681: THEN
682:

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

682:
683:
684: ROLLBACK TO create_task_pub;
685: x_return_status := fnd_api.g_ret_sts_unexp_error;
686: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
687: WHEN OTHERS
688: THEN
689:
690:

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

690:
691:
692: ROLLBACK TO create_task_pub;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695: END;
696:
697: PROCEDURE lock_task (
698: p_api_version IN NUMBER,

Line 727: fnd_msg_pub.initialize;

723: END IF;
724:
725: IF fnd_api.to_boolean (p_init_msg_list)
726: THEN
727: fnd_msg_pub.initialize;
728: END IF;
729:
730: x_return_status := fnd_api.g_ret_sts_success;
731:

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

733: x_task_template_id => p_task_id ,
734: x_object_version_number => p_object_version_number );
735:
736:
737: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
738:
739: EXCEPTION
740: WHEN Resource_Locked then
741: ROLLBACK TO lock_task_pub;

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

741: ROLLBACK TO lock_task_pub;
742: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
743: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Contacts');
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
746:
747: WHEN fnd_api.g_exc_unexpected_error
748: THEN
749: ROLLBACK TO lock_task_pub;

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

747: WHEN fnd_api.g_exc_unexpected_error
748: THEN
749: ROLLBACK TO lock_task_pub;
750: x_return_status := fnd_api.g_ret_sts_unexp_error;
751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
752: WHEN OTHERS
753: THEN
754: ROLLBACK TO lock_task_pub;
755: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

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

754: ROLLBACK TO lock_task_pub;
755: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
756: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
757: x_return_status := fnd_api.g_ret_sts_unexp_error;
758: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
759: END;
760:
761:
762:

Line 923: fnd_msg_pub.initialize;

919: END IF;
920:
921: IF fnd_api.to_boolean (p_init_msg_list)
922: THEN
923: fnd_msg_pub.initialize;
924: END IF;
925:
926:
927:

Line 935: fnd_msg_pub.add;

931: IF ( l_task_id = fnd_api.g_miss_num
932: AND l_task_number = fnd_api.g_miss_char)
933: THEN
934: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
935: fnd_msg_pub.add;
936: x_return_status := fnd_api.g_ret_sts_unexp_error;
937: RAISE fnd_api.g_exc_unexpected_error;
938: ELSE
939: SELECT DECODE (l_task_id, fnd_api.g_miss_num, NULL, l_task_id)

Line 963: fnd_msg_pub.add;

959:
960: IF l_task_id IS NULL
961: THEN
962: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
963: fnd_msg_pub.add;
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965: RAISE fnd_api.g_exc_unexpected_error;
966: END IF;
967: END IF;

Line 977: fnd_msg_pub.add;

973: -----
974: IF l_task_name IS NULL
975: THEN
976: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP_NAME');
977: fnd_msg_pub.add;
978: x_return_status := fnd_api.g_ret_sts_unexp_error;
979: RAISE fnd_api.g_exc_unexpected_error;
980: END IF;
981:

Line 991: fnd_msg_pub.add;

987:
988: IF c_task_update%NOTFOUND
989: THEN
990: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP');
991: fnd_msg_pub.add;
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993: RAISE fnd_api.g_exc_unexpected_error;
994: END IF;
995:

Line 1042: fnd_msg_pub.add;

1038:
1039: IF l_task_type_id IS NULL
1040: THEN
1041: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TYPE');
1042: fnd_msg_pub.add;
1043: RAISE fnd_api.g_exc_unexpected_error;
1044: END IF;
1045:
1046:

Line 1100: fnd_msg_pub.add;

1096:
1097: IF l_task_status_id IS NULL
1098: THEN
1099: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_STATUS');
1100: fnd_msg_pub.add;
1101: RAISE fnd_api.g_exc_unexpected_error;
1102: END IF;
1103:
1104:

Line 1595: fnd_msg_pub.initialize;

1591: END IF;
1592:
1593: IF fnd_api.to_boolean (p_init_msg_list)
1594: THEN
1595: fnd_msg_pub.initialize;
1596: END IF;
1597:
1598: jtf_task_templates_pub.update_task (
1599: p_api_version => p_api_version,

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

1664: THEN
1665: COMMIT WORK;
1666: END IF;
1667:
1668: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1669: EXCEPTION
1670: WHEN fnd_api.g_exc_unexpected_error
1671: THEN
1672: ROLLBACK TO update_task_pub1;

Line 1674: fnd_msg_pub.count_and_get (

1670: WHEN fnd_api.g_exc_unexpected_error
1671: THEN
1672: ROLLBACK TO update_task_pub1;
1673: x_return_status := fnd_api.g_ret_sts_unexp_error;
1674: fnd_msg_pub.count_and_get (
1675: p_count => x_msg_count,
1676: p_data => x_msg_data
1677: );
1678: WHEN OTHERS

Line 1684: fnd_msg_pub.count_and_get (

1680: ROLLBACK TO update_task_pub1;
1681: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1682: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1683: x_return_status := fnd_api.g_ret_sts_unexp_error;
1684: fnd_msg_pub.count_and_get (
1685: p_count => x_msg_count,
1686: p_data => x_msg_data
1687: );
1688: END;

Line 1720: fnd_msg_pub.initialize;

1716: END IF;
1717:
1718: IF fnd_api.to_boolean (p_init_msg_list)
1719: THEN
1720: fnd_msg_pub.initialize;
1721: END IF;
1722:
1723: IF ( l_task_id IS NULL
1724: AND l_task_number IS NULL)

Line 1727: fnd_msg_pub.add;

1723: IF ( l_task_id IS NULL
1724: AND l_task_number IS NULL)
1725: THEN
1726: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TEMP');
1727: fnd_msg_pub.add;
1728: x_return_status := fnd_api.g_ret_sts_unexp_error;
1729: RAISE fnd_api.g_exc_unexpected_error;
1730: ELSE
1731: jtf_task_utl.validate_task_template (

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

1763: THEN
1764: COMMIT WORK;
1765: END IF;
1766:
1767: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1768: EXCEPTION
1769: WHEN fnd_api.g_exc_unexpected_error
1770: THEN
1771: ROLLBACK TO delete_task_pub;

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

1769: WHEN fnd_api.g_exc_unexpected_error
1770: THEN
1771: ROLLBACK TO delete_task_pub;
1772: x_return_status := fnd_api.g_ret_sts_unexp_error;
1773: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1774: WHEN OTHERS
1775: THEN
1776: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1777: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

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

1776: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1777: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1778: ROLLBACK TO delete_task_pub;
1779: x_return_status := fnd_api.g_ret_sts_unexp_error;
1780: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1781: END;
1782:
1783:
1784: END;