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.JTF_TASK_ASSIGNMENTS_PUB dependencies on FND_MSG_PUB

Line 148: fnd_msg_pub.initialize;

144: END IF;
145:
146: IF fnd_api.to_boolean (p_init_msg_list)
147: THEN
148: fnd_msg_pub.initialize;
149: END IF;
150:
151: -------------
152: ------------- Call the Internal Hook

Line 217: fnd_msg_pub.add;

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:
221: -----

Line 235: fnd_msg_pub.add;

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:
239: IF l_resource_type_code IS NULL

Line 244: fnd_msg_pub.add;

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:
248: IF l_resource_id IS NULL

Line 252: fnd_msg_pub.add;

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:
256: -----

Line 270: fnd_msg_pub.add;

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:
274: -------

Line 411: fnd_msg_pub.add;

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
415: AND l_alarm_contact IS NOT NULL

Line 420: fnd_msg_pub.add;

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: */
424: -------

Line 561: fnd_msg_pub.add;

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;
562: RAISE fnd_api.g_exc_unexpected_error;
563: END IF;
564: END IF;
565:

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

668: THEN
669: COMMIT WORK;
670: END IF;
671:
672: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
673: EXCEPTION
674: WHEN fnd_api.g_exc_error
675: THEN
676: ROLLBACK TO create_task_assignment_pub;

Line 678: fnd_msg_pub.count_and_get (

674: WHEN fnd_api.g_exc_error
675: THEN
676: ROLLBACK TO create_task_assignment_pub;
677: x_return_status := fnd_api.g_ret_sts_error;
678: fnd_msg_pub.count_and_get (
679: p_count => x_msg_count,
680: p_data => x_msg_data
681: );
682: WHEN fnd_api.g_exc_unexpected_error

Line 686: fnd_msg_pub.count_and_get (

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

Line 694: /* if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )

690: WHEN OTHERS
691: THEN
692: ROLLBACK TO create_task_assignment_pub;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: /* if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
695: then
696: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name) ;
697: end if ;*/
698: fnd_msg_pub.count_and_get (

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

692: ROLLBACK TO create_task_assignment_pub;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: /* if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
695: then
696: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name) ;
697: end if ;*/
698: fnd_msg_pub.count_and_get (
699: p_count => x_msg_count,
700: p_data => x_msg_data

Line 698: fnd_msg_pub.count_and_get (

694: /* if fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
695: then
696: fnd_msg_pub.add_exc_msg(g_pkg_name,l_api_name) ;
697: end if ;*/
698: fnd_msg_pub.count_and_get (
699: p_count => x_msg_count,
700: p_data => x_msg_data
701: );
702: END;

Line 1105: fnd_msg_pub.initialize;

1101: END IF;
1102:
1103: IF fnd_api.to_boolean (p_init_msg_list)
1104: THEN
1105: fnd_msg_pub.initialize;
1106: END IF;
1107:
1108: x_return_status := fnd_api.g_ret_sts_success;
1109: jtf_task_assignments_pkg.lock_row (

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

1109: jtf_task_assignments_pkg.lock_row (
1110: x_task_assignment_id => p_task_assignment_id,
1111: x_object_version_number => p_object_version_number
1112: );
1113: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1114: EXCEPTION
1115: WHEN resource_locked
1116: THEN
1117: ROLLBACK TO lock_task_assignment_pub;

Line 1120: fnd_msg_pub.add;

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,
1124: p_data => x_msg_data

Line 1122: fnd_msg_pub.count_and_get (

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,
1124: p_data => x_msg_data
1125: );
1126: WHEN fnd_api.g_exc_unexpected_error

Line 1130: fnd_msg_pub.count_and_get (

1126: WHEN fnd_api.g_exc_unexpected_error
1127: THEN
1128: ROLLBACK TO lock_task_assignment_pub;
1129: x_return_status := fnd_api.g_ret_sts_unexp_error;
1130: fnd_msg_pub.count_and_get (
1131: p_count => x_msg_count,
1132: p_data => x_msg_data
1133: );
1134: WHEN OTHERS

Line 1139: fnd_msg_pub.add;

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,
1143: p_data => x_msg_data

Line 1141: fnd_msg_pub.count_and_get (

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,
1143: p_data => x_msg_data
1144: );
1145: END;

Line 1555: fnd_msg_pub.initialize;

1551: END IF;
1552:
1553: IF fnd_api.to_boolean (p_init_msg_list)
1554: THEN
1555: fnd_msg_pub.initialize;
1556: END IF;
1557:
1558: /* -------------
1559: ------------- Call the Internal Hook

Line 1607: fnd_msg_pub.add;

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;
1611:

Line 1627: fnd_msg_pub.add;

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:
1631: -----

Line 1647: fnd_msg_pub.add;

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:
1651: IF l_resource_type_code IS NULL

Line 1656: fnd_msg_pub.add;

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:
1660: IF l_resource_id IS NULL

Line 1664: fnd_msg_pub.add;

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:
1668: -------

Line 1705: fnd_msg_pub.add;

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;
1706: RAISE fnd_api.g_exc_unexpected_error;
1707: END IF;
1708: END IF;
1709:

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

2099: THEN
2100: CLOSE task_ass_u;
2101: END IF;
2102:
2103: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2104: EXCEPTION
2105: WHEN fnd_api.g_exc_error
2106: THEN
2107: ROLLBACK TO update_task_assignment_pub;

Line 2115: fnd_msg_pub.count_and_get (

2111: CLOSE task_ass_u;
2112: END IF;
2113:
2114: x_return_status := fnd_api.g_ret_sts_error;
2115: fnd_msg_pub.count_and_get (
2116: p_count => x_msg_count,
2117: p_data => x_msg_data
2118: );
2119: WHEN fnd_api.g_exc_unexpected_error

Line 2129: fnd_msg_pub.count_and_get (

2125: CLOSE task_ass_u;
2126: END IF;
2127:
2128: x_return_status := fnd_api.g_ret_sts_unexp_error;
2129: fnd_msg_pub.count_and_get (
2130: p_count => x_msg_count,
2131: p_data => x_msg_data
2132: );
2133: WHEN OTHERS

Line 2144: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

2140: END IF;
2141:
2142: x_return_status := fnd_api.g_ret_sts_unexp_error;
2143:
2144: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2145: THEN
2146: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2147: END IF;
2148:

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

2142: x_return_status := fnd_api.g_ret_sts_unexp_error;
2143:
2144: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2145: THEN
2146: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2147: END IF;
2148:
2149: fnd_msg_pub.count_and_get (
2150: p_count => x_msg_count,

Line 2149: fnd_msg_pub.count_and_get (

2145: THEN
2146: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2147: END IF;
2148:
2149: fnd_msg_pub.count_and_get (
2150: p_count => x_msg_count,
2151: p_data => x_msg_data
2152: );
2153: END;

Line 2536: fnd_msg_pub.initialize;

2532: END IF;
2533:
2534: IF fnd_api.to_boolean (p_init_msg_list)
2535: THEN
2536: fnd_msg_pub.initialize;
2537: END IF;
2538:
2539: -------------
2540: ------------- Call the Internal Hook

Line 2561: fnd_msg_pub.add;

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;
2565:

Line 2590: fnd_msg_pub.add;

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
2594: jtf_task_assignments_pub.lock_task_assignment (

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

2656: THEN
2657: COMMIT WORK;
2658: END IF;
2659:
2660: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2661: EXCEPTION
2662: WHEN fnd_api.g_exc_error
2663: THEN
2664: ROLLBACK TO delete_task_assignment_pub;

Line 2671: fnd_msg_pub.count_and_get (

2667: CLOSE ra_d;
2668: END IF;
2669: */
2670: x_return_status := fnd_api.g_ret_sts_error;
2671: fnd_msg_pub.count_and_get (
2672: p_count => x_msg_count,
2673: p_data => x_msg_data
2674: );
2675: WHEN fnd_api.g_exc_unexpected_error

Line 2685: fnd_msg_pub.count_and_get (

2681: END IF;
2682:
2683: */
2684: x_return_status := fnd_api.g_ret_sts_unexp_error;
2685: fnd_msg_pub.count_and_get (
2686: p_count => x_msg_count,
2687: p_data => x_msg_data
2688: );
2689: WHEN OTHERS

Line 2698: fnd_msg_pub.count_and_get (

2694: CLOSE ra_d;
2695: END IF;
2696: */
2697: x_return_status := fnd_api.g_ret_sts_unexp_error;
2698: fnd_msg_pub.count_and_get (
2699: p_count => x_msg_count,
2700: p_data => x_msg_data
2701: );
2702: END;