212:
213: IF l_task_id IS NULL
214: THEN
215: x_return_status := fnd_api.g_ret_sts_unexp_error;
216: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
217: fnd_msg_pub.add;
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:
230: );
231:
232: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
233: THEN
234: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
235: fnd_msg_pub.add;
236: RAISE fnd_api.g_exc_unexpected_error;
237: END IF;
238:
238:
239: IF l_resource_type_code IS NULL
240: THEN
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
243: fnd_message.set_token ('RESOURCE_TYPE_CODE', p_resource_type_code);
244: fnd_msg_pub.add;
245: RAISE fnd_api.g_exc_unexpected_error;
246: END IF;
239: IF l_resource_type_code IS NULL
240: THEN
241: x_return_status := fnd_api.g_ret_sts_unexp_error;
242: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
243: fnd_message.set_token ('RESOURCE_TYPE_CODE', p_resource_type_code);
244: fnd_msg_pub.add;
245: RAISE fnd_api.g_exc_unexpected_error;
246: END IF;
247:
247:
248: IF l_resource_id IS NULL
249: THEN
250: x_return_status := fnd_api.g_ret_sts_unexp_error;
251: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_RES_ID');
252: fnd_msg_pub.add;
253: RAISE fnd_api.g_exc_unexpected_error;
254: END IF;
255:
265: );
266:
267: IF l_assignment_status_id IS NULL
268: THEN
269: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK_STATUS');
270: fnd_msg_pub.add;
271: RAISE fnd_api.g_exc_unexpected_error;
272: END IF;
273:
405: );
406:
407: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
408: THEN
409: fnd_message.set_name ('JTF', 'JTF_TASK_INV_ALA_TYPE');
410: fnd_message.set_token ('ALARM_TYPE_CODE', p_alarm_type_code);
411: fnd_msg_pub.add;
412: RAISE fnd_api.g_exc_unexpected_error;
413: END IF;
406:
407: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
408: THEN
409: fnd_message.set_name ('JTF', 'JTF_TASK_INV_ALA_TYPE');
410: fnd_message.set_token ('ALARM_TYPE_CODE', p_alarm_type_code);
411: fnd_msg_pub.add;
412: RAISE fnd_api.g_exc_unexpected_error;
413: END IF;
414: ELSIF l_alarm_type_code IS NULL
414: ELSIF l_alarm_type_code IS NULL
415: AND l_alarm_contact IS NOT NULL
416: THEN
417: x_return_status := fnd_api.g_ret_sts_unexp_error;
418: fnd_message.set_name ('JTF', 'JTF_TASK_INV_ALA_CON');
419: fnd_message.set_token ('ALARM_CONTACT', p_alarm_contact);
420: fnd_msg_pub.add;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
415: AND l_alarm_contact IS NOT NULL
416: THEN
417: x_return_status := fnd_api.g_ret_sts_unexp_error;
418: fnd_message.set_name ('JTF', 'JTF_TASK_INV_ALA_CON');
419: fnd_message.set_token ('ALARM_CONTACT', p_alarm_contact);
420: fnd_msg_pub.add;
421: RAISE fnd_api.g_exc_unexpected_error;
422: END IF;
423: */
551: IF l_shift_construct_id IS NOT NULL
552: THEN
553: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
554: THEN
555: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
556: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
557: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
558: 'JTF_TASK_TRANSLATED_MESSAGES',
559: 'SHIFT_CONSTRUCT_ID')
552: THEN
553: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
554: THEN
555: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
556: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
557: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
558: 'JTF_TASK_TRANSLATED_MESSAGES',
559: 'SHIFT_CONSTRUCT_ID')
560: );
553: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
554: THEN
555: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
556: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
557: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
558: 'JTF_TASK_TRANSLATED_MESSAGES',
559: 'SHIFT_CONSTRUCT_ID')
560: );
561: fnd_msg_pub.add;
1114: EXCEPTION
1115: WHEN resource_locked
1116: THEN
1117: ROLLBACK TO lock_task_assignment_pub;
1118: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
1119: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Assignments');
1120: fnd_msg_pub.add;
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122: fnd_msg_pub.count_and_get (
1115: WHEN resource_locked
1116: THEN
1117: ROLLBACK TO lock_task_assignment_pub;
1118: fnd_message.set_name ('JTF', 'JTF_TASK_RESOURCE_LOCKED');
1119: fnd_message.set_token ('P_LOCKED_RESOURCE', 'Assignments');
1120: fnd_msg_pub.add;
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122: fnd_msg_pub.count_and_get (
1123: p_count => x_msg_count,
1133: );
1134: WHEN OTHERS
1135: THEN
1136: ROLLBACK TO lock_task_assignment_pub;
1137: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1138: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1139: fnd_msg_pub.add;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141: fnd_msg_pub.count_and_get (
1134: WHEN OTHERS
1135: THEN
1136: ROLLBACK TO lock_task_assignment_pub;
1137: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1138: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1139: fnd_msg_pub.add;
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141: fnd_msg_pub.count_and_get (
1142: p_count => x_msg_count,
1601: FETCH task_ass_u INTO task_ass_rec;
1602:
1603: IF task_ass_u%NOTFOUND
1604: THEN
1605: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
1606: fnd_message.set_token ('TASK_ASSIGNMENT_ID', p_task_assignment_id);
1607: fnd_msg_pub.add;
1608: x_return_status := fnd_api.g_ret_sts_unexp_error;
1609: RAISE fnd_api.g_exc_unexpected_error;
1602:
1603: IF task_ass_u%NOTFOUND
1604: THEN
1605: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
1606: fnd_message.set_token ('TASK_ASSIGNMENT_ID', p_task_assignment_id);
1607: fnd_msg_pub.add;
1608: x_return_status := fnd_api.g_ret_sts_unexp_error;
1609: RAISE fnd_api.g_exc_unexpected_error;
1610: END IF;
1622: );
1623:
1624: IF l_assignment_status_id IS NULL
1625: THEN
1626: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK_STATUS');
1627: fnd_msg_pub.add;
1628: RAISE fnd_api.g_exc_unexpected_error;
1629: END IF;
1630:
1642: );
1643:
1644: IF (x_return_status = fnd_api.g_ret_sts_unexp_error)
1645: THEN
1646: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
1647: fnd_msg_pub.add;
1648: RAISE fnd_api.g_exc_unexpected_error;
1649: END IF;
1650:
1650:
1651: IF l_resource_type_code IS NULL
1652: THEN
1653: x_return_status := fnd_api.g_ret_sts_unexp_error;
1654: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
1655: fnd_message.set_token ('RESOURCE_TYPE_CODE', p_resource_type_code);
1656: fnd_msg_pub.add;
1657: RAISE fnd_api.g_exc_unexpected_error;
1658: END IF;
1651: IF l_resource_type_code IS NULL
1652: THEN
1653: x_return_status := fnd_api.g_ret_sts_unexp_error;
1654: fnd_message.set_name ('JTF', 'JTF_TASK_INV_RES_TYP_COD');
1655: fnd_message.set_token ('RESOURCE_TYPE_CODE', p_resource_type_code);
1656: fnd_msg_pub.add;
1657: RAISE fnd_api.g_exc_unexpected_error;
1658: END IF;
1659:
1659:
1660: IF l_resource_id IS NULL
1661: THEN
1662: x_return_status := fnd_api.g_ret_sts_unexp_error;
1663: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_RES_ID');
1664: fnd_msg_pub.add;
1665: RAISE fnd_api.g_exc_unexpected_error;
1666: END IF;
1667:
1695: IF l_shift_construct_id IS NOT NULL
1696: THEN
1697: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
1698: THEN
1699: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
1700: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
1701: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
1702: 'JTF_TASK_TRANSLATED_MESSAGES',
1703: 'SHIFT_CONSTRUCT_ID')
1696: THEN
1697: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
1698: THEN
1699: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
1700: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
1701: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
1702: 'JTF_TASK_TRANSLATED_MESSAGES',
1703: 'SHIFT_CONSTRUCT_ID')
1704: );
1697: IF NOT jtf_task_utl.validate_shift_construct (l_shift_construct_id)
1698: THEN
1699: fnd_message.set_name ('JTF', 'JTF_TASK_CONSTRUCT_ID');
1700: --fnd_message.set_token ('SHIFT_CONSTRUCT_ID', p_shift_construct_id);
1701: fnd_message.set_token ('P_SHIFT_CONSTRUCT_ID', jtf_task_utl.get_translated_lookup(
1702: 'JTF_TASK_TRANSLATED_MESSAGES',
1703: 'SHIFT_CONSTRUCT_ID')
1704: );
1705: fnd_msg_pub.add;
2556:
2557: ---- if Task Assignment Id is null, then it is an error
2558: IF (l_task_assignment_id IS NULL)
2559: THEN
2560: fnd_message.set_name ('JTF', 'JTF_TASK_NULL_TK_ASS');
2561: fnd_msg_pub.add;
2562: x_return_status := fnd_api.g_ret_sts_unexp_error;
2563: RAISE fnd_api.g_exc_unexpected_error;
2564: END IF;
2585: FETCH ra_d INTO x;
2586:
2587: IF ra_d%NOTFOUND
2588: THEN
2589: fnd_message.set_name ('JTF', 'JTF_TASK_INV_TK_ASS');
2590: fnd_msg_pub.add;
2591: x_return_status := fnd_api.g_ret_sts_unexp_error;
2592: RAISE fnd_api.g_exc_unexpected_error;
2593: ELSE