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_UTL dependencies on FND_MESSAGE

Line 105: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');

101: -- check for null first
102: -- record the package name in the error stack
103: IF x_return_status IS NULL
104: THEN
105: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
106: /**** Fix Bug# 2042516 *****/
107: fnd_message.set_token (
108: 'P_PROCEDURE',
109: i.hook_package || '.' || i.hook_api

Line 107: fnd_message.set_token (

103: IF x_return_status IS NULL
104: THEN
105: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');
106: /**** Fix Bug# 2042516 *****/
107: fnd_message.set_token (
108: 'P_PROCEDURE',
109: i.hook_package || '.' || i.hook_api
110: );
111: /*-------------------------*/

Line 121: fnd_message.set_name ('JTF', 'JTF_TASK_HOOK_RETURN_ERROR');

117: -- return an error to indicate that the hook failed, to fix bug #2231728
118: -- record the package name in the error stack
119: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
120: THEN
121: fnd_message.set_name ('JTF', 'JTF_TASK_HOOK_RETURN_ERROR');
122: fnd_message.set_token (
123: 'P_PROCEDURE',
124: i.hook_package || '.' || i.hook_api
125: );

Line 122: fnd_message.set_token (

118: -- record the package name in the error stack
119: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
120: THEN
121: fnd_message.set_name ('JTF', 'JTF_TASK_HOOK_RETURN_ERROR');
122: fnd_message.set_token (
123: 'P_PROCEDURE',
124: i.hook_package || '.' || i.hook_api
125: );
126: -- Fix bug 2512087

Line 128: fnd_message.set_token (

124: i.hook_package || '.' || i.hook_api
125: );
126: -- Fix bug 2512087
127: -- Display application_id
128: fnd_message.set_token (
129: 'APPL_ID',
130: i.application_id
131: );
132: fnd_msg_pub.add;

Line 144: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

140: THEN
141: x_return_status := fnd_api.g_ret_sts_unexp_error;
142: WHEN OTHERS
143: THEN
144: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
145: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
146: fnd_msg_pub.add;
147: x_return_status := fnd_api.g_ret_sts_unexp_error;
148: END;

Line 145: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

141: x_return_status := fnd_api.g_ret_sts_unexp_error;
142: WHEN OTHERS
143: THEN
144: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
145: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
146: fnd_msg_pub.add;
147: x_return_status := fnd_api.g_ret_sts_unexp_error;
148: END;
149:

Line 181: fnd_message.set_name ('JTF', 'JTF_TASK_LOCATION_VALIDATION');

177: IF (p_task_id IS NOT NULL)
178: THEN
179: IF ((p_location_id <> fnd_api.g_miss_num AND p_address_id <> fnd_api.g_miss_num))
180: THEN
181: fnd_message.set_name ('JTF', 'JTF_TASK_LOCATION_VALIDATION');
182: fnd_msg_pub.add;
183: x_return_status := fnd_api.g_ret_sts_unexp_error;
184:
185: ELSIF (p_address_id <> fnd_api.g_miss_num)

Line 192: fnd_message.set_name ('JTF', 'JTF_TASK_LOCATION_EXIST');

188: Fetch C_Task into V_task;
189: Close C_Task;
190: IF (V_Task.Location_Id IS NOT NULL AND V_Task.Address_Id IS NOT NULL)
191: THEN
192: fnd_message.set_name ('JTF', 'JTF_TASK_LOCATION_EXIST');
193: fnd_msg_pub.add;
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: END IF;
196:

Line 204: fnd_message.set_name ('JTF', 'JTF_TASK_ADDRESS_EXIST');

200: Fetch C_Task into V_task;
201: Close C_Task;
202: IF (V_Task.Location_Id IS NOT NULL AND V_Task.Address_Id IS NOT NULL)
203: THEN
204: fnd_message.set_name ('JTF', 'JTF_TASK_ADDRESS_EXIST');
205: fnd_msg_pub.add;
206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207: END IF;
208: END IF;

Line 210: fnd_message.set_name ('JTF', 'JTF_TASK_LOCATION_VALIDATION');

206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207: END IF;
208: END IF;
209: ELSE
210: fnd_message.set_name ('JTF', 'JTF_TASK_LOCATION_VALIDATION');
211: fnd_msg_pub.add;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: END IF;
214: END IF;

Line 236: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

232: THEN
233: RETURN TRUE;
234: WHEN OTHERS
235: THEN
236: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
237: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
238: fnd_msg_pub.add;
239: RETURN FALSE;
240: END;

Line 237: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

233: RETURN TRUE;
234: WHEN OTHERS
235: THEN
236: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
237: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
238: fnd_msg_pub.add;
239: RETURN FALSE;
240: END;
241:

Line 255: fnd_message.set_name ('JTF', 'JTF_TASK_DISTANCE_UNITS');

251: IF p_distance_units IS NOT NULL
252: THEN
253: IF p_distance_units < 0
254: THEN
255: fnd_message.set_name ('JTF', 'JTF_TASK_DISTANCE_UNITS');
256: fnd_message.set_token ('P_DISTANCE_TAG', p_distance_tag);
257: fnd_msg_pub.add;
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259: END IF;

Line 256: fnd_message.set_token ('P_DISTANCE_TAG', p_distance_tag);

252: THEN
253: IF p_distance_units < 0
254: THEN
255: fnd_message.set_name ('JTF', 'JTF_TASK_DISTANCE_UNITS');
256: fnd_message.set_token ('P_DISTANCE_TAG', p_distance_tag);
257: fnd_msg_pub.add;
258: x_return_status := fnd_api.g_ret_sts_unexp_error;
259: END IF;
260: END IF;

Line 282: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_LOOKUP');

278: RETURN TRUE;
279: EXCEPTION
280: WHEN NO_DATA_FOUND
281: THEN
282: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_LOOKUP');
283: fnd_message.set_token ('P_LOOKUP_CODE', p_lookup_code);
284: fnd_message.set_token ('P_LOOKUP_TYPE', p_lookup_type);
285: fnd_msg_pub.add;
286: RETURN FALSE;

Line 283: fnd_message.set_token ('P_LOOKUP_CODE', p_lookup_code);

279: EXCEPTION
280: WHEN NO_DATA_FOUND
281: THEN
282: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_LOOKUP');
283: fnd_message.set_token ('P_LOOKUP_CODE', p_lookup_code);
284: fnd_message.set_token ('P_LOOKUP_TYPE', p_lookup_type);
285: fnd_msg_pub.add;
286: RETURN FALSE;
287: WHEN TOO_MANY_ROWS

Line 284: fnd_message.set_token ('P_LOOKUP_TYPE', p_lookup_type);

280: WHEN NO_DATA_FOUND
281: THEN
282: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_LOOKUP');
283: fnd_message.set_token ('P_LOOKUP_CODE', p_lookup_code);
284: fnd_message.set_token ('P_LOOKUP_TYPE', p_lookup_type);
285: fnd_msg_pub.add;
286: RETURN FALSE;
287: WHEN TOO_MANY_ROWS
288: THEN

Line 292: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

288: THEN
289: RETURN TRUE;
290: WHEN OTHERS
291: THEN
292: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
293: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
294: fnd_msg_pub.add;
295: RETURN FALSE;
296: END;

Line 293: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

289: RETURN TRUE;
290: WHEN OTHERS
291: THEN
292: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
293: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
294: fnd_msg_pub.add;
295: RETURN FALSE;
296: END;
297:

Line 393: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE_ID');

389: EXCEPTION
390: WHEN NO_DATA_FOUND
391: THEN
392: x_return_status := fnd_api.g_ret_sts_unexp_error;
393: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE_ID');
394: fnd_message.set_token ('P_PHONE_ID', p_phone_id);
395: fnd_msg_pub.add;
396: WHEN OTHERS
397: THEN

Line 394: fnd_message.set_token ('P_PHONE_ID', p_phone_id);

390: WHEN NO_DATA_FOUND
391: THEN
392: x_return_status := fnd_api.g_ret_sts_unexp_error;
393: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE_ID');
394: fnd_message.set_token ('P_PHONE_ID', p_phone_id);
395: fnd_msg_pub.add;
396: WHEN OTHERS
397: THEN
398: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 399: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

395: fnd_msg_pub.add;
396: WHEN OTHERS
397: THEN
398: x_return_status := fnd_api.g_ret_sts_unexp_error;
399: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
400: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
401: fnd_msg_pub.add;
402: END;
403: END;

Line 400: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

396: WHEN OTHERS
397: THEN
398: x_return_status := fnd_api.g_ret_sts_unexp_error;
399: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
400: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
401: fnd_msg_pub.add;
402: END;
403: END;
404:

Line 511: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACT');

507: END IF;
508: EXCEPTION
509: WHEN NO_DATA_FOUND
510: THEN
511: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CONTACT');
512: fnd_msg_pub.add;
513: x_return_status := fnd_api.g_ret_sts_unexp_error;
514: RAISE fnd_api.g_exc_unexpected_error;
515: WHEN TOO_MANY_ROWS

Line 545: fnd_message.set_name ('JTF', 'JTF_TASK_DUPLICATE_CONTACT');

541: Open c_dup_contact;
542: Fetch c_dup_contact Into l_dup_contact;
543: If c_dup_contact%FOUND
544: Then
545: fnd_message.set_name ('JTF', 'JTF_TASK_DUPLICATE_CONTACT');
546: fnd_msg_pub.add;
547: x_return_status := fnd_api.g_ret_sts_unexp_error;
548: End If;
549:

Line 589: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_ID');

585: FETCH c_task_template_group_id INTO x_task_template_group_id;
586:
587: IF c_task_template_group_id%NOTFOUND
588: THEN
589: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_ID');
590: fnd_message.set_token (
591: 'JTF_TASK_INVALID_TEMP_GROUP_ID',
592: p_task_template_group_id
593: );

Line 590: fnd_message.set_token (

586:
587: IF c_task_template_group_id%NOTFOUND
588: THEN
589: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_ID');
590: fnd_message.set_token (
591: 'JTF_TASK_INVALID_TEMP_GROUP_ID',
592: p_task_template_group_id
593: );
594: fnd_msg_pub.add;

Line 607: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_NAME');

603: FETCH c_task_template_group_name INTO x_task_template_group_id;
604:
605: IF c_task_template_group_name%NOTFOUND
606: THEN
607: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_NAME');
608: fnd_message.set_token (
609: 'JTF_TASK_INVALID_TEMP_GROUP_NAME',
610: p_task_template_group_name
611: );

Line 608: fnd_message.set_token (

604:
605: IF c_task_template_group_name%NOTFOUND
606: THEN
607: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_NAME');
608: fnd_message.set_token (
609: 'JTF_TASK_INVALID_TEMP_GROUP_NAME',
610: p_task_template_group_name
611: );
612: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 636: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_COST');

632: IF ( p_costs IS NULL
633: AND p_currency_code IS NOT NULL)
634: THEN
635: x_return_status := fnd_api.g_ret_sts_unexp_error;
636: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_COST');
637: fnd_message.set_token ('P_currency_code', p_currency_code);
638: fnd_msg_pub.add;
639: ELSIF ( p_costs IS NOT NULL
640: AND p_currency_code IS NULL)

Line 637: fnd_message.set_token ('P_currency_code', p_currency_code);

633: AND p_currency_code IS NOT NULL)
634: THEN
635: x_return_status := fnd_api.g_ret_sts_unexp_error;
636: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_COST');
637: fnd_message.set_token ('P_currency_code', p_currency_code);
638: fnd_msg_pub.add;
639: ELSIF ( p_costs IS NOT NULL
640: AND p_currency_code IS NULL)
641: THEN

Line 643: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_CURRENCY_CODE');

639: ELSIF ( p_costs IS NOT NULL
640: AND p_currency_code IS NULL)
641: THEN
642: x_return_status := fnd_api.g_ret_sts_unexp_error;
643: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_CURRENCY_CODE');
644: fnd_message.set_token ('P_cOSTs', p_costs);
645: fnd_msg_pub.add;
646: ELSIF ( p_costs IS NOT NULL
647: AND p_currency_code IS NOT NULL)

Line 644: fnd_message.set_token ('P_cOSTs', p_costs);

640: AND p_currency_code IS NULL)
641: THEN
642: x_return_status := fnd_api.g_ret_sts_unexp_error;
643: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_CURRENCY_CODE');
644: fnd_message.set_token ('P_cOSTs', p_costs);
645: fnd_msg_pub.add;
646: ELSIF ( p_costs IS NOT NULL
647: AND p_currency_code IS NOT NULL)
648: THEN

Line 681: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CURRENCY_CODE');

677:
678: IF c_jtf_currencies%NOTFOUND
679: THEN
680: l_result := fnd_api.g_false;
681: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CURRENCY_CODE');
682: fnd_message.set_token ('P_CURRENCY_CODE', p_currency_code);
683: fnd_msg_pub.add;
684: ELSE
685: l_result := fnd_api.g_true;

Line 682: fnd_message.set_token ('P_CURRENCY_CODE', p_currency_code);

678: IF c_jtf_currencies%NOTFOUND
679: THEN
680: l_result := fnd_api.g_false;
681: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CURRENCY_CODE');
682: fnd_message.set_token ('P_CURRENCY_CODE', p_currency_code);
683: fnd_msg_pub.add;
684: ELSE
685: l_result := fnd_api.g_true;
686: END IF;

Line 741: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');

737: FETCH c_object_code INTO x_object_code;
738:
739: IF c_object_code%NOTFOUND
740: THEN
741: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
742: fnd_message.set_token ('P_OBJECT_CODE', p_object_type_tag);
743: fnd_msg_pub.add;
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: RAISE fnd_api.g_exc_unexpected_error;

Line 742: fnd_message.set_token ('P_OBJECT_CODE', p_object_type_tag);

738:
739: IF c_object_code%NOTFOUND
740: THEN
741: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
742: fnd_message.set_token ('P_OBJECT_CODE', p_object_type_tag);
743: fnd_msg_pub.add;
744: x_return_status := fnd_api.g_ret_sts_unexp_error;
745: RAISE fnd_api.g_exc_unexpected_error;
746: END IF;

Line 756: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');

752: FETCH c_object_type_name INTO x_object_code;
753:
754: IF c_object_type_name%NOTFOUND
755: THEN
756: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
757: fnd_message.set_token ('P_TAG_NAME', p_object_type_tag);
758: fnd_msg_pub.add;
759: x_return_status := fnd_api.g_ret_sts_unexp_error;
760: RAISE fnd_api.g_exc_unexpected_error;

Line 757: fnd_message.set_token ('P_TAG_NAME', p_object_type_tag);

753:
754: IF c_object_type_name%NOTFOUND
755: THEN
756: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_NAME');
757: fnd_message.set_token ('P_TAG_NAME', p_object_type_tag);
758: fnd_msg_pub.add;
759: x_return_status := fnd_api.g_ret_sts_unexp_error;
760: RAISE fnd_api.g_exc_unexpected_error;
761: END IF;

Line 793: fnd_message.set_name ('JTF', 'JTF_TASK_REFERENCE_CODE');

789: FETCH c_reference_codes INTO x;
790:
791: IF c_reference_codes%NOTFOUND
792: THEN
793: fnd_message.set_name ('JTF', 'JTF_TASK_REFERENCE_CODE');
794: fnd_message.set_token ('P_REFERENCE_CODE', p_reference_code);
795: fnd_msg_pub.add;
796: RAISE fnd_api.g_exc_unexpected_error;
797: END IF;

Line 794: fnd_message.set_token ('P_REFERENCE_CODE', p_reference_code);

790:
791: IF c_reference_codes%NOTFOUND
792: THEN
793: fnd_message.set_name ('JTF', 'JTF_TASK_REFERENCE_CODE');
794: fnd_message.set_token ('P_REFERENCE_CODE', p_reference_code);
795: fnd_msg_pub.add;
796: RAISE fnd_api.g_exc_unexpected_error;
797: END IF;
798: END IF;

Line 838: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNED_ID');

834: FETCH c_assigned_by_id INTO x_assigned_by_id;
835:
836: IF c_assigned_by_id%NOTFOUND
837: THEN
838: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNED_ID');
839: fnd_message.set_token ('P_ASSIGNED_BY_ID', p_assigned_by_id);
840: fnd_msg_pub.add;
841: x_return_status := fnd_api.g_ret_sts_unexp_error;
842: RAISE fnd_api.g_exc_unexpected_error;

Line 839: fnd_message.set_token ('P_ASSIGNED_BY_ID', p_assigned_by_id);

835:
836: IF c_assigned_by_id%NOTFOUND
837: THEN
838: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNED_ID');
839: fnd_message.set_token ('P_ASSIGNED_BY_ID', p_assigned_by_id);
840: fnd_msg_pub.add;
841: x_return_status := fnd_api.g_ret_sts_unexp_error;
842: RAISE fnd_api.g_exc_unexpected_error;
843: END IF;

Line 853: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNED_NAME');

849: FETCH c_assigned_by_name INTO x_assigned_by_id;
850:
851: IF c_assigned_by_name%NOTFOUND
852: THEN
853: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNED_NAME');
854: fnd_message.set_token ('P_ASSIGNED_BY_NAME', p_assigned_by_name);
855: fnd_msg_pub.add;
856: x_return_status := fnd_api.g_ret_sts_unexp_error;
857: RAISE fnd_api.g_exc_unexpected_error;

Line 854: fnd_message.set_token ('P_ASSIGNED_BY_NAME', p_assigned_by_name);

850:
851: IF c_assigned_by_name%NOTFOUND
852: THEN
853: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ASSIGNED_NAME');
854: fnd_message.set_token ('P_ASSIGNED_BY_NAME', p_assigned_by_name);
855: fnd_msg_pub.add;
856: x_return_status := fnd_api.g_ret_sts_unexp_error;
857: RAISE fnd_api.g_exc_unexpected_error;
858: END IF;

Line 883: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');

879: FETCH c_dependency INTO x;
880:
881: IF c_dependency%NOTFOUND
882: THEN
883: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
884: fnd_message.set_token (
885: 'JTF_TASK_INVALID_DEPENDS_ID',
886: p_dependency_id
887: );

Line 884: fnd_message.set_token (

880:
881: IF c_dependency%NOTFOUND
882: THEN
883: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_ID');
884: fnd_message.set_token (
885: 'JTF_TASK_INVALID_DEPENDS_ID',
886: p_dependency_id
887: );
888: fnd_msg_pub.add;

Line 958: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_ID');

954: OR l_task_template_group_id IS NULL
955: THEN
956: IF c_task_template_group%NOTFOUND
957: THEN
958: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_ID');
959: fnd_message.set_token (
960: 'P_TASK_TEMPLATE_GROUP_ID',
961: l_task_template_group_id
962: );

Line 959: fnd_message.set_token (

955: THEN
956: IF c_task_template_group%NOTFOUND
957: THEN
958: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_GRP_ID');
959: fnd_message.set_token (
960: 'P_TASK_TEMPLATE_GROUP_ID',
961: l_task_template_group_id
962: );
963: fnd_msg_pub.add;

Line 993: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATES');

989: THEN
990: IF p_start_date > p_end_date
991: THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATES');
994: fnd_message.set_token ('P_DATE_TAG', p_date_tag);
995: fnd_msg_pub.add;
996: END IF;
997: END IF;

Line 994: fnd_message.set_token ('P_DATE_TAG', p_date_tag);

990: IF p_start_date > p_end_date
991: THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATES');
994: fnd_message.set_token ('P_DATE_TAG', p_date_tag);
995: fnd_msg_pub.add;
996: END IF;
997: END IF;
998: END;

Line 1018: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');

1014: IF NOT ( p_flag_value IN (jtf_task_utl.g_yes, jtf_task_utl.g_no)
1015: OR p_flag_value IS NULL)
1016: THEN
1017: x_return_status := fnd_api.g_ret_sts_unexp_error;
1018: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
1019: fnd_message.set_token ('P_FLAG_NAME', p_flag_name);
1020: fnd_msg_pub.add;
1021: END IF;
1022: END;

Line 1019: fnd_message.set_token ('P_FLAG_NAME', p_flag_name);

1015: OR p_flag_value IS NULL)
1016: THEN
1017: x_return_status := fnd_api.g_ret_sts_unexp_error;
1018: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_FLAG');
1019: fnd_message.set_token ('P_FLAG_NAME', p_flag_name);
1020: fnd_msg_pub.add;
1021: END IF;
1022: END;
1023:

Line 1055: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_ID');

1051:
1052: IF c_template_object_details%NOTFOUND
1053: THEN
1054: x_return_status := fnd_api.g_ret_sts_unexp_error;
1055: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_ID');
1056: fnd_message.set_token ('P_TASK_TEMPLATE_ID', p_task_id);
1057: fnd_msg_pub.add;
1058: END IF;
1059: ELSE

Line 1056: fnd_message.set_token ('P_TASK_TEMPLATE_ID', p_task_id);

1052: IF c_template_object_details%NOTFOUND
1053: THEN
1054: x_return_status := fnd_api.g_ret_sts_unexp_error;
1055: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_ID');
1056: fnd_message.set_token ('P_TASK_TEMPLATE_ID', p_task_id);
1057: fnd_msg_pub.add;
1058: END IF;
1059: ELSE
1060: OPEN c_task_object_details;

Line 1066: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');

1062:
1063: IF c_task_object_details%NOTFOUND
1064: THEN
1065: x_return_status := fnd_api.g_ret_sts_unexp_error;
1066: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1067: fnd_message.set_token ('P_TASK_ID', p_task_id);
1068: fnd_msg_pub.add;
1069: END IF;
1070: END IF;

Line 1067: fnd_message.set_token ('P_TASK_ID', p_task_id);

1063: IF c_task_object_details%NOTFOUND
1064: THEN
1065: x_return_status := fnd_api.g_ret_sts_unexp_error;
1066: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1067: fnd_message.set_token ('P_TASK_ID', p_task_id);
1068: fnd_msg_pub.add;
1069: END IF;
1070: END IF;
1071: END;

Line 1104: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SITE_ID');

1100: FETCH c_party_site_id INTO x_party_site_id;
1101:
1102: IF c_party_site_id%NOTFOUND
1103: THEN
1104: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SITE_ID');
1105: fnd_message.set_token ('P_PARTY_SITE_ID', p_party_site_id);
1106: fnd_msg_pub.add;
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: RAISE fnd_api.g_exc_unexpected_error;

Line 1105: fnd_message.set_token ('P_PARTY_SITE_ID', p_party_site_id);

1101:
1102: IF c_party_site_id%NOTFOUND
1103: THEN
1104: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SITE_ID');
1105: fnd_message.set_token ('P_PARTY_SITE_ID', p_party_site_id);
1106: fnd_msg_pub.add;
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: RAISE fnd_api.g_exc_unexpected_error;
1109: END IF;

Line 1119: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SITE_NUMBER');

1115: FETCH c_party_site_number INTO x_party_site_id;
1116:
1117: IF c_party_site_number%NOTFOUND
1118: THEN
1119: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SITE_NUMBER');
1120: fnd_message.set_token ('P_PARTY_SITE_NUMBER', p_party_site_number);
1121: fnd_msg_pub.add;
1122: x_return_status := fnd_api.g_ret_sts_unexp_error;
1123: RAISE fnd_api.g_exc_unexpected_error;

Line 1120: fnd_message.set_token ('P_PARTY_SITE_NUMBER', p_party_site_number);

1116:
1117: IF c_party_site_number%NOTFOUND
1118: THEN
1119: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SITE_NUMBER');
1120: fnd_message.set_token ('P_PARTY_SITE_NUMBER', p_party_site_number);
1121: fnd_msg_pub.add;
1122: x_return_status := fnd_api.g_ret_sts_unexp_error;
1123: RAISE fnd_api.g_exc_unexpected_error;
1124: END IF;

Line 1161: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PARTY_ID');

1157: FETCH c_party_id INTO x_party_id;
1158:
1159: IF c_party_id%NOTFOUND
1160: THEN
1161: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PARTY_ID');
1162: fnd_message.set_token ('P_PARTY_ID', p_party_id);
1163: fnd_msg_pub.add;
1164: x_return_status := fnd_api.g_ret_sts_unexp_error;
1165: RAISE fnd_api.g_exc_unexpected_error;

Line 1162: fnd_message.set_token ('P_PARTY_ID', p_party_id);

1158:
1159: IF c_party_id%NOTFOUND
1160: THEN
1161: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PARTY_ID');
1162: fnd_message.set_token ('P_PARTY_ID', p_party_id);
1163: fnd_msg_pub.add;
1164: x_return_status := fnd_api.g_ret_sts_unexp_error;
1165: RAISE fnd_api.g_exc_unexpected_error;
1166: END IF;

Line 1176: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PARTY_NUMBER');

1172: FETCH c_party_number INTO x_party_id;
1173:
1174: IF c_party_number%NOTFOUND
1175: THEN
1176: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PARTY_NUMBER');
1177: fnd_message.set_token (
1178: 'PARTY_NUMBER', -- Bug# 2120668
1179: p_party_number
1180: );

Line 1177: fnd_message.set_token (

1173:
1174: IF c_party_number%NOTFOUND
1175: THEN
1176: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PARTY_NUMBER');
1177: fnd_message.set_token (
1178: 'PARTY_NUMBER', -- Bug# 2120668
1179: p_party_number
1180: );
1181: fnd_msg_pub.add;

Line 1221: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CUST_ACCT_ID');

1217: FETCH c_cust_account_id INTO x_cust_account_id;
1218:
1219: IF c_cust_account_id%NOTFOUND
1220: THEN
1221: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CUST_ACCT_ID');
1222: fnd_message.set_token ('P_CUST_ACCOUNT_ID', p_cust_account_id);
1223: fnd_msg_pub.add;
1224: x_return_status := fnd_api.g_ret_sts_unexp_error;
1225: RAISE fnd_api.g_exc_unexpected_error;

Line 1222: fnd_message.set_token ('P_CUST_ACCOUNT_ID', p_cust_account_id);

1218:
1219: IF c_cust_account_id%NOTFOUND
1220: THEN
1221: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CUST_ACCT_ID');
1222: fnd_message.set_token ('P_CUST_ACCOUNT_ID', p_cust_account_id);
1223: fnd_msg_pub.add;
1224: x_return_status := fnd_api.g_ret_sts_unexp_error;
1225: RAISE fnd_api.g_exc_unexpected_error;
1226: END IF;

Line 1236: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CUST_ACCT_NUM'); -- Bug# 2120231

1232: FETCH c_cust_account_number INTO x_cust_account_id;
1233:
1234: IF c_cust_account_number%NOTFOUND
1235: THEN
1236: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CUST_ACCT_NUM'); -- Bug# 2120231
1237: fnd_message.set_token ('P_CUST_ACCOUNT_NUMBER', p_cust_account_number);
1238: fnd_msg_pub.add;
1239: x_return_status := fnd_api.g_ret_sts_unexp_error;
1240: RAISE fnd_api.g_exc_unexpected_error;

Line 1237: fnd_message.set_token ('P_CUST_ACCOUNT_NUMBER', p_cust_account_number);

1233:
1234: IF c_cust_account_number%NOTFOUND
1235: THEN
1236: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CUST_ACCT_NUM'); -- Bug# 2120231
1237: fnd_message.set_token ('P_CUST_ACCOUNT_NUMBER', p_cust_account_number);
1238: fnd_msg_pub.add;
1239: x_return_status := fnd_api.g_ret_sts_unexp_error;
1240: RAISE fnd_api.g_exc_unexpected_error;
1241: END IF;

Line 1396: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SOURCE_DTLS');

1392: return;
1393: ELSIF NOT ( l_object_code IS NOT NULL AND
1394: l_object_id IS NOT NULL)
1395: THEN
1396: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SOURCE_DTLS');
1397: fnd_msg_pub.add;
1398: x_return_status := fnd_api.g_ret_sts_unexp_error;
1399: RAISE fnd_api.g_exc_unexpected_error;
1400: END IF;

Line 1418: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');

1414: l_where_clause;
1415:
1416: IF c_references%NOTFOUND
1417: THEN
1418: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
1419: -- Bug 3418166 message token is null if p_tag is not passed in.
1420: -- Added message token to ensure that message token has accurate data.
1421: IF p_tag IS NOT NULL THEN
1422: l_tag := p_tag;

Line 1431: fnd_message.set_token ('P_OBJECT_CODE', l_tag);

1427: ELSIF p_object_id IS NOT NULL THEN
1428: l_tag := p_object_id;
1429: END IF;
1430:
1431: fnd_message.set_token ('P_OBJECT_CODE', l_tag);
1432: fnd_msg_pub.add;
1433: RAISE fnd_api.g_exc_unexpected_error;
1434: END IF;
1435:

Line 1440: -- fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SOURCE_DTLS');

1436: /************* Comment out (Bug 2118130) *****************************
1437: --IF p_object_name IS NULL
1438: -- OR p_object_id IS NULL
1439: --THEN
1440: -- fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SOURCE_DTLS');
1441: -- fnd_msg_pub.add;
1442: -- RAISE fnd_api.g_exc_unexpected_error;
1443: --END IF;
1444: *********************************************************************/

Line 1482: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SOURCE_DTLS');

1478: -- fix bug# 2602732
1479: -- removing the validation for p_object_name
1480: IF (l_object_id <> p_object_id)
1481: THEN
1482: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SOURCE_DTLS');
1483: fnd_msg_pub.add;
1484: x_return_status := fnd_api.g_ret_sts_unexp_error;
1485: RAISE fnd_api.g_exc_unexpected_error;
1486: END IF;

Line 1493: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SOURCE_DTLS');

1489: THEN
1490: x_return_status := fnd_api.g_ret_sts_unexp_error;
1491: WHEN NO_DATA_FOUND
1492: THEN
1493: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SOURCE_DTLS');
1494: fnd_msg_pub.add;
1495: x_return_status := fnd_api.g_ret_sts_unexp_error;
1496: WHEN OTHERS
1497: THEN

Line 1499: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

1495: x_return_status := fnd_api.g_ret_sts_unexp_error;
1496: WHEN OTHERS
1497: THEN
1498: x_return_status := fnd_api.g_ret_sts_unexp_error;
1499: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1500: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1501: fnd_msg_pub.add;
1502: END;
1503:

Line 1500: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

1496: WHEN OTHERS
1497: THEN
1498: x_return_status := fnd_api.g_ret_sts_unexp_error;
1499: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1500: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1501: fnd_msg_pub.add;
1502: END;
1503:
1504: -----------

Line 1542: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');

1538:
1539: IF c_task_id%NOTFOUND
1540: THEN
1541: x_return_status := fnd_api.g_ret_sts_unexp_error;
1542: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1543: fnd_message.set_token ('P_TASK_ID', p_task_id);
1544: fnd_msg_pub.add;
1545: END IF;
1546: ELSIF --- if the task id is null, then ignore

Line 1543: fnd_message.set_token ('P_TASK_ID', p_task_id);

1539: IF c_task_id%NOTFOUND
1540: THEN
1541: x_return_status := fnd_api.g_ret_sts_unexp_error;
1542: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_ID');
1543: fnd_message.set_token ('P_TASK_ID', p_task_id);
1544: fnd_msg_pub.add;
1545: END IF;
1546: ELSIF --- if the task id is null, then ignore
1547: (p_task_number IS NOT NULL)

Line 1555: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');

1551:
1552: IF c_task_number%NOTFOUND
1553: THEN
1554: x_return_status := fnd_api.g_ret_sts_unexp_error;
1555: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
1556: fnd_message.set_token ('P_TASK_NUMBER', p_task_number);
1557: fnd_msg_pub.add;
1558: END IF;
1559: END IF;

Line 1556: fnd_message.set_token ('P_TASK_NUMBER', p_task_number);

1552: IF c_task_number%NOTFOUND
1553: THEN
1554: x_return_status := fnd_api.g_ret_sts_unexp_error;
1555: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TASK_NUMBER');
1556: fnd_message.set_token ('P_TASK_NUMBER', p_task_number);
1557: fnd_msg_pub.add;
1558: END IF;
1559: END IF;
1560:

Line 1599: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_ID');

1595:
1596: IF c_task_id%NOTFOUND
1597: THEN
1598: x_return_status := fnd_api.g_ret_sts_unexp_error;
1599: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_ID');
1600: fnd_message.set_token ('P_TASK_TEMPLATE_ID', p_task_id);
1601: fnd_msg_pub.add;
1602: END IF;
1603: ELSIF --- if the task id is null, then ignore

Line 1600: fnd_message.set_token ('P_TASK_TEMPLATE_ID', p_task_id);

1596: IF c_task_id%NOTFOUND
1597: THEN
1598: x_return_status := fnd_api.g_ret_sts_unexp_error;
1599: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_ID');
1600: fnd_message.set_token ('P_TASK_TEMPLATE_ID', p_task_id);
1601: fnd_msg_pub.add;
1602: END IF;
1603: ELSIF --- if the task id is null, then ignore
1604: (p_task_number IS NOT NULL)

Line 1612: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_NUMBER');

1608:
1609: IF c_task_number%NOTFOUND
1610: THEN
1611: x_return_status := fnd_api.g_ret_sts_unexp_error;
1612: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_NUMBER');
1613: fnd_message.set_token ('P_TASK_TEMPLATE_NUMBER', p_task_number);
1614: fnd_msg_pub.add;
1615: END IF;
1616: END IF;

Line 1613: fnd_message.set_token ('P_TASK_TEMPLATE_NUMBER', p_task_number);

1609: IF c_task_number%NOTFOUND
1610: THEN
1611: x_return_status := fnd_api.g_ret_sts_unexp_error;
1612: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TEMP_NUMBER');
1613: fnd_message.set_token ('P_TASK_TEMPLATE_NUMBER', p_task_number);
1614: fnd_msg_pub.add;
1615: END IF;
1616: END IF;
1617:

Line 1642: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_CODE');

1638: FETCH c_dependency_type_code INTO x;
1639:
1640: IF c_dependency_type_code%NOTFOUND
1641: THEN
1642: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_CODE');
1643: fnd_message.set_token ('P_DEPENDENCY_CODE', p_dependency_code);
1644: fnd_msg_pub.add;
1645: l_result := FALSE;
1646: ELSE

Line 1643: fnd_message.set_token ('P_DEPENDENCY_CODE', p_dependency_code);

1639:
1640: IF c_dependency_type_code%NOTFOUND
1641: THEN
1642: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEPENDS_CODE');
1643: fnd_message.set_token ('P_DEPENDENCY_CODE', p_dependency_code);
1644: fnd_msg_pub.add;
1645: l_result := FALSE;
1646: ELSE
1647: l_result := TRUE;

Line 1716: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_QUANTITY');

1712:
1713: IF (l_effort IS NULL AND l_effort_uom IS NOT NULL)
1714: THEN
1715: x_return_status := fnd_api.g_ret_sts_unexp_error;
1716: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_QUANTITY');
1717: fnd_message.set_token ('P_TAG', p_tag);
1718: fnd_msg_pub.add;
1719: ELSIF (l_effort IS NOT NULL AND l_effort_uom IS NULL)
1720: THEN

Line 1717: fnd_message.set_token ('P_TAG', p_tag);

1713: IF (l_effort IS NULL AND l_effort_uom IS NOT NULL)
1714: THEN
1715: x_return_status := fnd_api.g_ret_sts_unexp_error;
1716: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_QUANTITY');
1717: fnd_message.set_token ('P_TAG', p_tag);
1718: fnd_msg_pub.add;
1719: ELSIF (l_effort IS NOT NULL AND l_effort_uom IS NULL)
1720: THEN
1721: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1722: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_UOM');

1718: fnd_msg_pub.add;
1719: ELSIF (l_effort IS NOT NULL AND l_effort_uom IS NULL)
1720: THEN
1721: x_return_status := fnd_api.g_ret_sts_unexp_error;
1722: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_UOM');
1723: fnd_message.set_token ('P_TAG', p_tag);
1724: fnd_msg_pub.add;
1725: ELSIF (l_effort IS NOT NULL AND l_effort_uom IS NOT NULL)
1726: THEN

Line 1723: fnd_message.set_token ('P_TAG', p_tag);

1719: ELSIF (l_effort IS NOT NULL AND l_effort_uom IS NULL)
1720: THEN
1721: x_return_status := fnd_api.g_ret_sts_unexp_error;
1722: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_UOM');
1723: fnd_message.set_token ('P_TAG', p_tag);
1724: fnd_msg_pub.add;
1725: ELSIF (l_effort IS NOT NULL AND l_effort_uom IS NOT NULL)
1726: THEN
1727: IF l_effort < g_minimum_effort

Line 1730: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_QUANTITY');

1726: THEN
1727: IF l_effort < g_minimum_effort
1728: THEN
1729: x_return_status := fnd_api.g_ret_sts_error;
1730: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_QUANTITY');
1731: fnd_message.set_token ('P_TAG', p_tag);
1732: fnd_msg_pub.add;
1733: END IF;
1734:

Line 1731: fnd_message.set_token ('P_TAG', p_tag);

1727: IF l_effort < g_minimum_effort
1728: THEN
1729: x_return_status := fnd_api.g_ret_sts_error;
1730: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_QUANTITY');
1731: fnd_message.set_token ('P_TAG', p_tag);
1732: fnd_msg_pub.add;
1733: END IF;
1734:
1735: IF NOT fnd_api.to_boolean (jtf_task_utl.validate_time_uom(l_effort_uom))

Line 1738: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_UOM');

1734:
1735: IF NOT fnd_api.to_boolean (jtf_task_utl.validate_time_uom(l_effort_uom))
1736: THEN
1737: x_return_status := fnd_api.g_ret_sts_unexp_error;
1738: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_UOM');
1739: fnd_message.set_token ('P_UOM_CODE', l_effort_uom); -- Fix Bug 2118718
1740: fnd_msg_pub.add;
1741: END IF;
1742: ELSE

Line 1739: fnd_message.set_token ('P_UOM_CODE', l_effort_uom); -- Fix Bug 2118718

1735: IF NOT fnd_api.to_boolean (jtf_task_utl.validate_time_uom(l_effort_uom))
1736: THEN
1737: x_return_status := fnd_api.g_ret_sts_unexp_error;
1738: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_UOM');
1739: fnd_message.set_token ('P_UOM_CODE', l_effort_uom); -- Fix Bug 2118718
1740: fnd_msg_pub.add;
1741: END IF;
1742: ELSE
1743: NULL;

Line 1783: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_ID');

1779: FETCH c_task_type_id INTO x_task_type_id;
1780:
1781: IF c_task_type_id%NOTFOUND
1782: THEN
1783: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_ID');
1784: fnd_message.set_token ('P_TASK_TYPE_ID', p_task_type_id);
1785: fnd_msg_pub.add;
1786: x_return_status := fnd_api.g_ret_sts_unexp_error;
1787: END IF;

Line 1784: fnd_message.set_token ('P_TASK_TYPE_ID', p_task_type_id);

1780:
1781: IF c_task_type_id%NOTFOUND
1782: THEN
1783: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_ID');
1784: fnd_message.set_token ('P_TASK_TYPE_ID', p_task_type_id);
1785: fnd_msg_pub.add;
1786: x_return_status := fnd_api.g_ret_sts_unexp_error;
1787: END IF;
1788:

Line 1797: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_NAME');

1793: FETCH c_task_type_name INTO x_task_type_id;
1794:
1795: IF c_task_type_name%NOTFOUND
1796: THEN
1797: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_NAME');
1798: fnd_message.set_token ('P_TASK_TYPE_NAME', p_task_type_name);
1799: fnd_msg_pub.add;
1800: RAISE fnd_api.g_exc_unexpected_error;
1801: END IF;

Line 1798: fnd_message.set_token ('P_TASK_TYPE_NAME', p_task_type_name);

1794:
1795: IF c_task_type_name%NOTFOUND
1796: THEN
1797: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TYPE_NAME');
1798: fnd_message.set_token ('P_TASK_TYPE_NAME', p_task_type_name);
1799: fnd_msg_pub.add;
1800: RAISE fnd_api.g_exc_unexpected_error;
1801: END IF;
1802:

Line 1847: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_ID');

1843: FETCH c_task_status_id INTO x_task_status_id;
1844:
1845: IF c_task_status_id%NOTFOUND
1846: THEN
1847: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_ID');
1848: fnd_message.set_token ('P_TASK_STATUS_ID', p_task_status_id);
1849: fnd_msg_pub.add;
1850: x_return_status := fnd_api.g_ret_sts_unexp_error;
1851: RAISE fnd_api.g_exc_unexpected_error;

Line 1848: fnd_message.set_token ('P_TASK_STATUS_ID', p_task_status_id);

1844:
1845: IF c_task_status_id%NOTFOUND
1846: THEN
1847: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_ID');
1848: fnd_message.set_token ('P_TASK_STATUS_ID', p_task_status_id);
1849: fnd_msg_pub.add;
1850: x_return_status := fnd_api.g_ret_sts_unexp_error;
1851: RAISE fnd_api.g_exc_unexpected_error;
1852: END IF;

Line 1862: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');

1858: FETCH c_task_status_name INTO x_task_status_id;
1859:
1860: IF c_task_status_name%NOTFOUND
1861: THEN
1862: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');
1863: fnd_message.set_token ('P_TASK_STATUS_NAME', p_task_status_name);
1864: fnd_msg_pub.add;
1865: x_return_status := fnd_api.g_ret_sts_unexp_error;
1866: RAISE fnd_api.g_exc_unexpected_error;

Line 1863: fnd_message.set_token ('P_TASK_STATUS_NAME', p_task_status_name);

1859:
1860: IF c_task_status_name%NOTFOUND
1861: THEN
1862: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');
1863: fnd_message.set_token ('P_TASK_STATUS_NAME', p_task_status_name);
1864: fnd_msg_pub.add;
1865: x_return_status := fnd_api.g_ret_sts_unexp_error;
1866: RAISE fnd_api.g_exc_unexpected_error;
1867: END IF;

Line 1924: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PRIORITY_ID');

1920: FETCH c_task_priority_id INTO x_task_priority_id;
1921:
1922: IF c_task_priority_id%NOTFOUND
1923: THEN
1924: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PRIORITY_ID');
1925: fnd_message.set_token ('P_TASK_PRIORITY_ID', p_task_priority_id);
1926: fnd_msg_pub.add;
1927: x_return_status := fnd_api.g_ret_sts_unexp_error;
1928: RAISE fnd_api.g_exc_unexpected_error;

Line 1925: fnd_message.set_token ('P_TASK_PRIORITY_ID', p_task_priority_id);

1921:
1922: IF c_task_priority_id%NOTFOUND
1923: THEN
1924: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PRIORITY_ID');
1925: fnd_message.set_token ('P_TASK_PRIORITY_ID', p_task_priority_id);
1926: fnd_msg_pub.add;
1927: x_return_status := fnd_api.g_ret_sts_unexp_error;
1928: RAISE fnd_api.g_exc_unexpected_error;
1929: END IF;

Line 1940: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PRIORITY_NAME');

1936: FETCH c_task_priority_name INTO x_task_priority_id;
1937:
1938: IF c_task_priority_name%NOTFOUND
1939: THEN
1940: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PRIORITY_NAME');
1941: fnd_message.set_token (
1942: 'P_TASK_PRIORITY_NAME',
1943: p_task_priority_name
1944: );

Line 1941: fnd_message.set_token (

1937:
1938: IF c_task_priority_name%NOTFOUND
1939: THEN
1940: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PRIORITY_NAME');
1941: fnd_message.set_token (
1942: 'P_TASK_PRIORITY_NAME',
1943: p_task_priority_name
1944: );
1945: fnd_msg_pub.add;

Line 1989: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE_TYPE_ID');

1985: FETCH c_date_type_id INTO x_date_type_id;
1986:
1987: IF c_date_type_id%NOTFOUND
1988: THEN
1989: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE_TYPE_ID');
1990: fnd_message.set_token ('P_DATE_TYPE_ID', p_date_type_id);
1991: fnd_msg_pub.add;
1992: x_return_status := fnd_api.g_ret_sts_unexp_error;
1993: END IF;

Line 1990: fnd_message.set_token ('P_DATE_TYPE_ID', p_date_type_id);

1986:
1987: IF c_date_type_id%NOTFOUND
1988: THEN
1989: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE_TYPE_ID');
1990: fnd_message.set_token ('P_DATE_TYPE_ID', p_date_type_id);
1991: fnd_msg_pub.add;
1992: x_return_status := fnd_api.g_ret_sts_unexp_error;
1993: END IF;
1994:

Line 2003: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE_TYPE_NAME');

1999: FETCH c_date_type_name INTO x_date_type_id;
2000:
2001: IF c_date_type_name%NOTFOUND
2002: THEN
2003: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE_TYPE_NAME');
2004: fnd_message.set_token ('P_DATE_TYPE', p_date_type);
2005: fnd_msg_pub.add;
2006: x_return_status := fnd_api.g_ret_sts_unexp_error;
2007: END IF;

Line 2004: fnd_message.set_token ('P_DATE_TYPE', p_date_type);

2000:
2001: IF c_date_type_name%NOTFOUND
2002: THEN
2003: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DATE_TYPE_NAME');
2004: fnd_message.set_token ('P_DATE_TYPE', p_date_type);
2005: fnd_msg_pub.add;
2006: x_return_status := fnd_api.g_ret_sts_unexp_error;
2007: END IF;
2008:

Line 2053: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TERR_ID');

2049: FETCH c_terr_id INTO x_terr_id;
2050:
2051: IF c_terr_id%NOTFOUND
2052: THEN
2053: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TERR_ID');
2054: fnd_message.set_token ('P_TERR_ID', p_terr_id);
2055: fnd_msg_pub.add;
2056: x_return_status := fnd_api.g_ret_sts_unexp_error;
2057: RAISE fnd_api.g_exc_unexpected_error;

Line 2054: fnd_message.set_token ('P_TERR_ID', p_terr_id);

2050:
2051: IF c_terr_id%NOTFOUND
2052: THEN
2053: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TERR_ID');
2054: fnd_message.set_token ('P_TERR_ID', p_terr_id);
2055: fnd_msg_pub.add;
2056: x_return_status := fnd_api.g_ret_sts_unexp_error;
2057: RAISE fnd_api.g_exc_unexpected_error;
2058: END IF;

Line 2068: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TERR_NAME');

2064: FETCH c_terr_name INTO x_terr_id;
2065:
2066: IF c_terr_name%NOTFOUND
2067: THEN
2068: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TERR_NAME');
2069: fnd_message.set_token ('P_TERR_NAME', p_terr_name);
2070: fnd_msg_pub.add;
2071: x_return_status := fnd_api.g_ret_sts_unexp_error;
2072: RAISE fnd_api.g_exc_unexpected_error;

Line 2069: fnd_message.set_token ('P_TERR_NAME', p_terr_name);

2065:
2066: IF c_terr_name%NOTFOUND
2067: THEN
2068: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TERR_NAME');
2069: fnd_message.set_token ('P_TERR_NAME', p_terr_name);
2070: fnd_msg_pub.add;
2071: x_return_status := fnd_api.g_ret_sts_unexp_error;
2072: RAISE fnd_api.g_exc_unexpected_error;
2073: END IF;

Line 2124: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ESC_DTLS');

2120: IF (p_owner_id IS NOT NULL)
2121: OR (p_terr_id IS NOT NULL)
2122: OR (p_terr_name IS NOT NULL)
2123: THEN
2124: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_ESC_DTLS');
2125: fnd_msg_pub.add;
2126: x_return_status := fnd_api.g_ret_sts_unexp_error;
2127: RAISE fnd_api.g_exc_unexpected_error;
2128: ELSE

Line 2137: fnd_message.set_name ('JTF', 'OWNER_OR_TERRITORY');

2133: IF (p_owner_id IS NULL)
2134: AND ( p_terr_id IS NULL
2135: OR p_terr_name IS NULL)
2136: THEN
2137: fnd_message.set_name ('JTF', 'OWNER_OR_TERRITORY');
2138: fnd_msg_pub.add;
2139: x_return_status := fnd_api.g_ret_sts_unexp_error;
2140: RAISE fnd_api.g_exc_unexpected_error;
2141: END IF;

Line 2150: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');

2146: FETCH c_owner INTO x_owner_id;
2147:
2148: IF c_owner%NOTFOUND
2149: THEN
2150: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
2151: fnd_message.set_token ('P_OWNER_ID', p_owner_id);
2152: fnd_msg_pub.add;
2153: x_return_status := fnd_api.g_ret_sts_unexp_error;
2154: RAISE fnd_api.g_exc_unexpected_error;

Line 2151: fnd_message.set_token ('P_OWNER_ID', p_owner_id);

2147:
2148: IF c_owner%NOTFOUND
2149: THEN
2150: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
2151: fnd_message.set_token ('P_OWNER_ID', p_owner_id);
2152: fnd_msg_pub.add;
2153: x_return_status := fnd_api.g_ret_sts_unexp_error;
2154: RAISE fnd_api.g_exc_unexpected_error;
2155: END IF;

Line 2214: fnd_message.set_name ('JTF', 'invalid_object_type');

2210: FETCH c_object_code INTO x_object_code;
2211:
2212: IF c_object_code%NOTFOUND
2213: THEN
2214: fnd_message.set_name ('JTF', 'invalid_object_type');
2215: fnd_msg_pub.add;
2216: x_return_status := fnd_api.g_ret_sts_unexp_error;
2217: END IF;
2218:

Line 2227: fnd_message.set_name ('JTF', 'invalid_object_type');

2223: FETCH c_object_type_name INTO x_object_code;
2224:
2225: IF c_object_type_name%NOTFOUND
2226: THEN
2227: fnd_message.set_name ('JTF', 'invalid_object_type');
2228: fnd_msg_pub.add;
2229: x_return_status := fnd_api.g_ret_sts_unexp_error;
2230: END IF;
2231:

Line 2283: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');

2279: FETCH c_owner_type INTO l_id_column, l_from_clause, l_where_clause;
2280:
2281: -- Bug 3128054 fixed by TSINGHAL removed dbms messages
2282: IF c_owner_type%NOTFOUND THEN
2283: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
2284: fnd_message.set_token ('P_OBJECT_CODE', 'Owner');
2285: fnd_msg_pub.add;
2286: x_return_status := fnd_api.g_ret_sts_unexp_error;
2287: RAISE fnd_api.g_exc_unexpected_error;

Line 2284: fnd_message.set_token ('P_OBJECT_CODE', 'Owner');

2280:
2281: -- Bug 3128054 fixed by TSINGHAL removed dbms messages
2282: IF c_owner_type%NOTFOUND THEN
2283: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OBJECT_CODE');
2284: fnd_message.set_token ('P_OBJECT_CODE', 'Owner');
2285: fnd_msg_pub.add;
2286: x_return_status := fnd_api.g_ret_sts_unexp_error;
2287: RAISE fnd_api.g_exc_unexpected_error;
2288: END IF;

Line 2326: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');

2322: THEN
2323: x_owner_id := NULL;
2324: x_owner_type_code := NULL;
2325: x_return_status := fnd_api.g_ret_sts_unexp_error;
2326: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
2327: fnd_message.set_token ('P_OWNER_ID', p_owner_id);
2328: fnd_msg_pub.add;
2329: RAISE fnd_api.g_exc_unexpected_error;
2330: END;

Line 2327: fnd_message.set_token ('P_OWNER_ID', p_owner_id);

2323: x_owner_id := NULL;
2324: x_owner_type_code := NULL;
2325: x_return_status := fnd_api.g_ret_sts_unexp_error;
2326: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
2327: fnd_message.set_token ('P_OWNER_ID', p_owner_id);
2328: fnd_msg_pub.add;
2329: RAISE fnd_api.g_exc_unexpected_error;
2330: END;
2331:

Line 2339: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');

2335: WHEN NO_DATA_FOUND
2336: THEN
2337: x_owner_id := NULL;
2338: x_owner_type_code := NULL;
2339: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
2340: fnd_message.set_token ('P_OWNER_ID', p_owner_id);
2341: fnd_msg_pub.add;
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343: RAISE fnd_api.g_exc_unexpected_error;

Line 2340: fnd_message.set_token ('P_OWNER_ID', p_owner_id);

2336: THEN
2337: x_owner_id := NULL;
2338: x_owner_type_code := NULL;
2339: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
2340: fnd_message.set_token ('P_OWNER_ID', p_owner_id);
2341: fnd_msg_pub.add;
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343: RAISE fnd_api.g_exc_unexpected_error;
2344: WHEN fnd_api.g_exc_unexpected_error

Line 2353: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

2349: THEN
2350: x_owner_id := NULL;
2351: x_owner_type_code := NULL;
2352: x_return_status := fnd_api.g_ret_sts_unexp_error;
2353: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2354: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2355: fnd_msg_pub.add;
2356: RAISE fnd_api.g_exc_unexpected_error;
2357: END;

Line 2354: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

2350: x_owner_id := NULL;
2351: x_owner_type_code := NULL;
2352: x_return_status := fnd_api.g_ret_sts_unexp_error;
2353: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2354: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2355: fnd_msg_pub.add;
2356: RAISE fnd_api.g_exc_unexpected_error;
2357: END;
2358:

Line 2391: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TIMEZONE_ID');

2387: FETCH c_timezone_id INTO x_timezone_id;
2388:
2389: IF c_timezone_id%NOTFOUND
2390: THEN
2391: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TIMEZONE_ID');
2392: fnd_message.set_token ('P_TIMEZONE_ID', p_timezone_id);
2393: fnd_msg_pub.add;
2394: x_return_status := fnd_api.g_ret_sts_unexp_error;
2395: END IF;

Line 2392: fnd_message.set_token ('P_TIMEZONE_ID', p_timezone_id);

2388:
2389: IF c_timezone_id%NOTFOUND
2390: THEN
2391: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TIMEZONE_ID');
2392: fnd_message.set_token ('P_TIMEZONE_ID', p_timezone_id);
2393: fnd_msg_pub.add;
2394: x_return_status := fnd_api.g_ret_sts_unexp_error;
2395: END IF;
2396:

Line 2405: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TIMEZONE_NAME');

2401: FETCH c_timezone_name INTO x_timezone_id;
2402:
2403: IF c_timezone_name%NOTFOUND
2404: THEN
2405: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TIMEZONE_NAME');
2406: fnd_message.set_token ('P_TIMEZONE_NAME', p_timezone_name);
2407: fnd_msg_pub.add;
2408: x_return_status := fnd_api.g_ret_sts_unexp_error;
2409: END IF;

Line 2406: fnd_message.set_token ('P_TIMEZONE_NAME', p_timezone_name);

2402:
2403: IF c_timezone_name%NOTFOUND
2404: THEN
2405: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_TIMEZONE_NAME');
2406: fnd_message.set_token ('P_TIMEZONE_NAME', p_timezone_name);
2407: fnd_msg_pub.add;
2408: x_return_status := fnd_api.g_ret_sts_unexp_error;
2409: END IF;
2410:

Line 2449: fnd_message.set_name ('JTF', 'JTF_TASK_PARENT_TYPE_CODE');

2445: AND l_source_object_code IS NULL)
2446: OR ( l_p_source_object_code IS NULL
2447: AND l_source_object_code IS NOT NULL)
2448: THEN
2449: fnd_message.set_name ('JTF', 'JTF_TASK_PARENT_TYPE_CODE');
2450: fnd_msg_pub.add;
2451: x_return_status := fnd_api.g_ret_sts_unexp_error;
2452: END IF;
2453:

Line 2459: fnd_message.set_name ('JTF', 'JTF_TASK_PARENT_TYPE_CODE');

2455: AND l_source_object_code IS NOT NULL)
2456: THEN
2457: IF l_p_source_object_code <> l_source_object_code
2458: THEN
2459: fnd_message.set_name ('JTF', 'JTF_TASK_PARENT_TYPE_CODE');
2460: fnd_msg_pub.add;
2461: x_return_status := fnd_api.g_ret_sts_unexp_error;
2462: END IF;
2463: END IF;

Line 2475: fnd_message.set_name ('JTF', 'JTF_TASK_PARENT');

2471: AND l_source_object_id IS NULL)
2472: OR ( l_p_source_object_id IS NULL
2473: AND l_source_object_id IS NOT NULL)
2474: THEN
2475: fnd_message.set_name ('JTF', 'JTF_TASK_PARENT');
2476: fnd_msg_pub.add;
2477: x_return_status := fnd_api.g_ret_sts_unexp_error;
2478: END IF;
2479:

Line 2485: fnd_message.set_name ('JTF', 'JTF_TASK_PARENT');

2481: AND l_source_object_id IS NOT NULL)
2482: THEN
2483: IF l_p_source_object_id <> l_source_object_id
2484: THEN
2485: fnd_message.set_name ('JTF', 'JTF_TASK_PARENT');
2486: fnd_msg_pub.add;
2487: x_return_status := fnd_api.g_ret_sts_unexp_error;
2488: END IF;
2489: END IF;

Line 2534: -- fnd_message.set_name ('JTF', 'INVALID_EFFORT');

2530: -- AND l_period_uom IS NULL)
2531: -- OR ( l_period IS NOT NULL
2532: -- AND l_period_uom IS NULL)
2533: --THEN
2534: -- fnd_message.set_name ('JTF', 'INVALID_EFFORT');
2535: -- fnd_msg_pub.add;
2536: -- x_return_status := fnd_api.g_ret_sts_unexp_error;
2537: --END IF;
2538: -----------------------------------------------------

Line 2627: fnd_message.set_name ('JTF', 'INVALID_ALARM_PARAMETERS');

2623: OR (l_alarm_count IS NULL)
2624: OR (l_alarm_interval IS NULL)
2625: OR (l_alarm_interval_uom IS NULL)
2626: THEN
2627: fnd_message.set_name ('JTF', 'INVALID_ALARM_PARAMETERS');
2628: fnd_msg_pub.add;
2629: x_return_status := fnd_api.g_ret_sts_unexp_error;
2630: RAISE fnd_api.g_exc_unexpected_error;
2631: END IF;

Line 2641: -- fnd_message.set_name ('JTF', 'Invalid_ALARM');

2637: );
2638:
2639: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2640: THEN
2641: -- fnd_message.set_name ('JTF', 'Invalid_ALARM');
2642: -- fnd_msg_pub.add;
2643: x_return_status := fnd_api.g_ret_sts_unexp_error;
2644: RAISE fnd_api.g_exc_unexpected_error;
2645: END IF;

Line 2658: -- fnd_message.set_name ('JTF', 'Invalid_ALARM');

2654: );
2655:
2656: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
2657: THEN
2658: -- fnd_message.set_name ('JTF', 'Invalid_ALARM');
2659: -- fnd_msg_pub.add;
2660: x_return_status := fnd_api.g_ret_sts_unexp_error;
2661: RAISE fnd_api.g_exc_unexpected_error;
2662: END IF;

Line 2671: fnd_message.set_name ('JTF', 'INVALID_ALARM_PARAMETERS');

2667: OR (l_alarm_count IS NOT NULL)
2668: OR (l_alarm_interval IS NOT NULL)
2669: OR (l_alarm_interval_uom IS NOT NULL)
2670: THEN
2671: fnd_message.set_name ('JTF', 'INVALID_ALARM_PARAMETERS');
2672: fnd_msg_pub.add;
2673: x_return_status := fnd_api.g_ret_sts_unexp_error;
2674: END IF;
2675: END IF;

Line 2750: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_USER_MAPPING');

2746: EXCEPTION
2747: WHEN NO_DATA_FOUND
2748: THEN
2749: x_return_status := fnd_api.g_ret_sts_unexp_error;
2750: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_USER_MAPPING');
2751: fnd_msg_pub.add;
2752: WHEN OTHERS
2753: THEN
2754: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2755: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

2751: fnd_msg_pub.add;
2752: WHEN OTHERS
2753: THEN
2754: x_return_status := fnd_api.g_ret_sts_unexp_error;
2755: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2756: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2757: fnd_msg_pub.add;
2758: RAISE fnd_api.g_exc_unexpected_error;
2759: END;

Line 2756: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

2752: WHEN OTHERS
2753: THEN
2754: x_return_status := fnd_api.g_ret_sts_unexp_error;
2755: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
2756: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
2757: fnd_msg_pub.add;
2758: RAISE fnd_api.g_exc_unexpected_error;
2759: END;
2760:

Line 2791: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEFAULT_OWNER');

2787: AND x_owner_id IS NOT NULL)
2788: OR ( x_owner_id IS NULL
2789: AND x_owner_type_code IS NOT NULL)
2790: THEN
2791: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_DEFAULT_OWNER');
2792: fnd_msg_pub.add;
2793: x_return_status := fnd_api.g_ret_sts_unexp_error;
2794: profile_set := FALSE;
2795: RETURN;

Line 2949: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');

2945: x_return_status := fnd_api.g_ret_sts_success;
2946:
2947: IF p_task_id IS NULL
2948: THEN
2949: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_TASK');
2950: fnd_msg_pub.add;
2951: x_return_status := fnd_api.g_ret_sts_unexp_error;
2952: RAISE fnd_api.g_exc_unexpected_error;
2953: END IF;

Line 2969: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_CONTACT');

2965: x_return_status := fnd_api.g_ret_sts_success;
2966:
2967: IF p_task_contact_id IS NULL
2968: THEN
2969: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_CONTACT');
2970: fnd_msg_pub.add;
2971: x_return_status := fnd_api.g_ret_sts_unexp_error;
2972: RAISE fnd_api.g_exc_unexpected_error;
2973: END IF;

Line 2989: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE');

2985: x_return_status := fnd_api.g_ret_sts_success;
2986:
2987: IF p_task_phone_id IS NULL
2988: THEN
2989: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_PHONE');
2990: fnd_msg_pub.add;
2991: x_return_status := fnd_api.g_ret_sts_unexp_error;
2992: RAISE fnd_api.g_exc_unexpected_error;
2993: END IF;

Line 3017: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_APPL_ID');

3013: WHERE application_id = p_application_id;
3014: EXCEPTION
3015: WHEN NO_DATA_FOUND
3016: THEN
3017: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_APPL_ID');
3018: fnd_message.set_token ('P_APPL_ID', p_application_id);
3019: fnd_msg_pub.add;
3020: x_return_status := fnd_api.g_ret_sts_unexp_error;
3021: WHEN TOO_MANY_ROWS

Line 3018: fnd_message.set_token ('P_APPL_ID', p_application_id);

3014: EXCEPTION
3015: WHEN NO_DATA_FOUND
3016: THEN
3017: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_APPL_ID');
3018: fnd_message.set_token ('P_APPL_ID', p_application_id);
3019: fnd_msg_pub.add;
3020: x_return_status := fnd_api.g_ret_sts_unexp_error;
3021: WHEN TOO_MANY_ROWS
3022: THEN

Line 3026: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

3022: THEN
3023: NULL;
3024: WHEN OTHERS
3025: THEN
3026: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3027: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3028: fnd_msg_pub.add;
3029: x_return_status := fnd_api.g_ret_sts_unexp_error;
3030: END;

Line 3027: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

3023: NULL;
3024: WHEN OTHERS
3025: THEN
3026: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3027: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3028: fnd_msg_pub.add;
3029: x_return_status := fnd_api.g_ret_sts_unexp_error;
3030: END;
3031:

Line 3116: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE_TABLE');

3112: IF p_owner_table_name IS NOT NULL
3113: THEN
3114: IF p_owner_table_name NOT IN ('JTF_TASKS_B', 'JTF_TASK_CONTACTS')
3115: THEN
3116: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_PHONE_TABLE');
3117: fnd_msg_pub.add;
3118: x_return_status := fnd_api.g_ret_sts_unexp_error;
3119: END IF;
3120: END IF;

Line 3154: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CATEGORY_ID');

3150: AND perz_data_id = p_category_id;
3151: END IF;
3152: EXCEPTION
3153: WHEN no_data_found THEN
3154: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CATEGORY_ID');
3155: fnd_message.set_token ('P_CATEGORY_ID', p_category_id );
3156: fnd_msg_pub.add;
3157: x_return_status := fnd_api.g_ret_sts_unexp_error;
3158: END;

Line 3155: fnd_message.set_token ('P_CATEGORY_ID', p_category_id );

3151: END IF;
3152: EXCEPTION
3153: WHEN no_data_found THEN
3154: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CATEGORY_ID');
3155: fnd_message.set_token ('P_CATEGORY_ID', p_category_id );
3156: fnd_msg_pub.add;
3157: x_return_status := fnd_api.g_ret_sts_unexp_error;
3158: END;
3159: -----

Line 3256: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_USER_ID');

3252:
3253: IF SQL%FOUND THEN
3254: x_return_status := fnd_api.g_ret_sts_success;
3255: ELSE
3256: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_USER_ID');
3257: fnd_message.set_token ('P_USER_ID', l_rs_id );
3258: fnd_msg_pub.add;
3259: x_return_status := fnd_api.g_ret_sts_unexp_error;
3260: END IF;

Line 3257: fnd_message.set_token ('P_USER_ID', l_rs_id );

3253: IF SQL%FOUND THEN
3254: x_return_status := fnd_api.g_ret_sts_success;
3255: ELSE
3256: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_USER_ID');
3257: fnd_message.set_token ('P_USER_ID', l_rs_id );
3258: fnd_msg_pub.add;
3259: x_return_status := fnd_api.g_ret_sts_unexp_error;
3260: END IF;
3261: END IF;

Line 3272: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_SECURITY_CHK');

3268:
3269: WHEN OTHERS
3270: THEN
3271:
3272: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_SECURITY_CHK');
3273: fnd_message.set_token ('P_USER_ID', l_rs_id );
3274: fnd_msg_pub.add;
3275: x_return_status := fnd_api.g_ret_sts_unexp_error;
3276:

Line 3273: fnd_message.set_token ('P_USER_ID', l_rs_id );

3269: WHEN OTHERS
3270: THEN
3271:
3272: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_SECURITY_CHK');
3273: fnd_message.set_token ('P_USER_ID', l_rs_id );
3274: fnd_msg_pub.add;
3275: x_return_status := fnd_api.g_ret_sts_unexp_error;
3276:
3277: END;

Line 3364: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');

3360: OPEN c_task_owner;
3361: FETCH c_task_owner INTO rec_task_owner;
3362: IF c_task_owner%NOTFOUND
3363: THEN
3364: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
3365: fnd_message.set_token('P_TASK_ID', p_task_id);
3366: fnd_msg_pub.add;
3367: x_return_status := fnd_api.g_ret_sts_error;
3368: RAISE fnd_api.g_exc_error;

Line 3365: fnd_message.set_token('P_TASK_ID', p_task_id);

3361: FETCH c_task_owner INTO rec_task_owner;
3362: IF c_task_owner%NOTFOUND
3363: THEN
3364: fnd_message.set_name('JTF', 'JTF_TASK_INVALID_TASK_ID');
3365: fnd_message.set_token('P_TASK_ID', p_task_id);
3366: fnd_msg_pub.add;
3367: x_return_status := fnd_api.g_ret_sts_error;
3368: RAISE fnd_api.g_exc_error;
3369: END IF;

Line 3376: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_USER_MAPPING');

3372: OPEN c_resource;
3373: FETCH c_resource INTO rec_resource;
3374: IF c_resource%NOTFOUND
3375: THEN
3376: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_USER_MAPPING');
3377: fnd_message.set_token('P_USER_ID', l_user_id);
3378: fnd_msg_pub.add;
3379: x_return_status := fnd_api.g_ret_sts_error;
3380: RAISE fnd_api.g_exc_error;

Line 3377: fnd_message.set_token('P_USER_ID', l_user_id);

3373: FETCH c_resource INTO rec_resource;
3374: IF c_resource%NOTFOUND
3375: THEN
3376: fnd_message.set_name('JTF', 'JTF_TASK_MISSING_USER_MAPPING');
3377: fnd_message.set_token('P_USER_ID', l_user_id);
3378: fnd_msg_pub.add;
3379: x_return_status := fnd_api.g_ret_sts_error;
3380: RAISE fnd_api.g_exc_error;
3381: END IF;

Line 3413: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_USER_ID');

3409: rec_resource.resource_id);
3410: FETCH c_grant INTO rec_grant;
3411: IF c_grant%NOTFOUND
3412: THEN
3413: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_USER_ID');
3414: fnd_message.set_token ('P_USER_ID', rec_resource.resource_id);
3415: fnd_msg_pub.add;
3416: x_return_status := fnd_api.g_ret_sts_error;
3417: -- Don't raise any exception.

Line 3414: fnd_message.set_token ('P_USER_ID', rec_resource.resource_id);

3410: FETCH c_grant INTO rec_grant;
3411: IF c_grant%NOTFOUND
3412: THEN
3413: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_USER_ID');
3414: fnd_message.set_token ('P_USER_ID', rec_resource.resource_id);
3415: fnd_msg_pub.add;
3416: x_return_status := fnd_api.g_ret_sts_error;
3417: -- Don't raise any exception.
3418: -- This is not an exception, but insufficient privilege error.

Line 3423: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_USER_ID');

3419: ELSE
3420: CLOSE c_grant;
3421: END IF; -- Check grant
3422: ELSE
3423: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_USER_ID');
3424: fnd_message.set_token ('P_USER_ID', rec_resource.resource_id);
3425: fnd_msg_pub.add;
3426: x_return_status := fnd_api.g_ret_sts_error;
3427: -- Don't raise any exception.

Line 3424: fnd_message.set_token ('P_USER_ID', rec_resource.resource_id);

3420: CLOSE c_grant;
3421: END IF; -- Check grant
3422: ELSE
3423: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_USER_ID');
3424: fnd_message.set_token ('P_USER_ID', rec_resource.resource_id);
3425: fnd_msg_pub.add;
3426: x_return_status := fnd_api.g_ret_sts_error;
3427: -- Don't raise any exception.
3428: -- This is not an exception, but insufficient privilege error.

Line 3483: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_SECURITY_CHK');

3479: END IF;
3480: IF c_grant%ISOPEN THEN
3481: CLOSE c_grant;
3482: END IF;
3483: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_SECURITY_CHK');
3484: fnd_message.set_token ('P_TEXT', SQLCODE ||' '|| SQLERRM);
3485: fnd_msg_pub.add;
3486: x_return_status := fnd_api.g_ret_sts_unexp_error;
3487: RAISE;

Line 3484: fnd_message.set_token ('P_TEXT', SQLCODE ||' '|| SQLERRM);

3480: IF c_grant%ISOPEN THEN
3481: CLOSE c_grant;
3482: END IF;
3483: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_SECURITY_CHK');
3484: fnd_message.set_token ('P_TEXT', SQLCODE ||' '|| SQLERRM);
3485: fnd_msg_pub.add;
3486: x_return_status := fnd_api.g_ret_sts_unexp_error;
3487: RAISE;
3488: END;

Line 3557: fnd_message.set_name ('JTF', 'JTF_TASK_NO_PARTY');

3553: AND (p_party_site_id IS NOT NULL
3554: OR p_cust_account_id IS NOT NULL) THEN
3555: -- cannot validate if there is no customer
3556: -- return a warning message
3557: fnd_message.set_name ('JTF', 'JTF_TASK_NO_PARTY');
3558: fnd_msg_pub.add;
3559: RETURN;
3560: END IF;
3561:

Line 3571: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SITE_ID');

3567:
3568: IF c_party_site%NOTFOUND
3569: THEN
3570: CLOSE c_party_site;
3571: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SITE_ID');
3572: fnd_message.set_token ('P_PARTY_SITE_ID', p_party_site_id);
3573: fnd_msg_pub.add;
3574: x_return_status := fnd_api.g_ret_sts_unexp_error;
3575: RAISE fnd_api.g_exc_unexpected_error;

Line 3572: fnd_message.set_token ('P_PARTY_SITE_ID', p_party_site_id);

3568: IF c_party_site%NOTFOUND
3569: THEN
3570: CLOSE c_party_site;
3571: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_SITE_ID');
3572: fnd_message.set_token ('P_PARTY_SITE_ID', p_party_site_id);
3573: fnd_msg_pub.add;
3574: x_return_status := fnd_api.g_ret_sts_unexp_error;
3575: RAISE fnd_api.g_exc_unexpected_error;
3576: END IF;

Line 3590: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CUST_ACCT_ID');

3586:
3587: IF c_party_acct%NOTFOUND
3588: THEN
3589: CLOSE c_party_acct;
3590: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CUST_ACCT_ID');
3591: fnd_message.set_token ('P_CUST_ACCOUNT_ID', p_cust_account_id);
3592: fnd_msg_pub.add;
3593: x_return_status := fnd_api.g_ret_sts_unexp_error;
3594: RAISE fnd_api.g_exc_unexpected_error;

Line 3591: fnd_message.set_token ('P_CUST_ACCOUNT_ID', p_cust_account_id);

3587: IF c_party_acct%NOTFOUND
3588: THEN
3589: CLOSE c_party_acct;
3590: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_CUST_ACCT_ID');
3591: fnd_message.set_token ('P_CUST_ACCOUNT_ID', p_cust_account_id);
3592: fnd_msg_pub.add;
3593: x_return_status := fnd_api.g_ret_sts_unexp_error;
3594: RAISE fnd_api.g_exc_unexpected_error;
3595: END IF;

Line 3610: fnd_message.set_name('JTF','JTF_CAL_COMMON_CATEGORY');

3606:
3607: BEGIN
3608: if p_category_id is null then
3609: fnd_msg_pub.initialize ;
3610: fnd_message.set_name('JTF','JTF_CAL_COMMON_CATEGORY');
3611: fnd_msg_pub.add ;
3612: l_msg_data := substrb(fnd_msg_pub.get( 1 , 'F' ),1,240); -- Fixed for bug 2540722
3613: else
3614: select perz_data_desc

Line 3716: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

3712: p_creation_date => NULL
3713: );
3714: EXCEPTION
3715: WHEN OTHERS THEN
3716: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3717: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3718: fnd_msg_pub.add;
3719: x_return_status := fnd_api.g_ret_sts_unexp_error;
3720: END;

Line 3717: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

3713: );
3714: EXCEPTION
3715: WHEN OTHERS THEN
3716: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
3717: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
3718: fnd_msg_pub.add;
3719: x_return_status := fnd_api.g_ret_sts_unexp_error;
3720: END;
3721: -----

Line 3755: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');

3751: IF p_type = 'ESCALATION' AND l_usage = 'ESCALATION'
3752: THEN
3753: x_return_status := fnd_api.g_ret_sts_success;
3754: ELSE
3755: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');
3756: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));
3757: fnd_msg_pub.add;
3758: x_return_status := fnd_api.g_ret_sts_unexp_error;
3759: END IF;

Line 3756: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));

3752: THEN
3753: x_return_status := fnd_api.g_ret_sts_success;
3754: ELSE
3755: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');
3756: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));
3757: fnd_msg_pub.add;
3758: x_return_status := fnd_api.g_ret_sts_unexp_error;
3759: END IF;
3760: END IF;

Line 3767: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');

3763:
3764: EXCEPTION
3765: WHEN OTHERS
3766: THEN
3767: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');
3768: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));
3769: fnd_msg_pub.add;
3770: x_return_status := fnd_api.g_ret_sts_unexp_error;
3771: END;

Line 3768: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));

3764: EXCEPTION
3765: WHEN OTHERS
3766: THEN
3767: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_STATUS_NAME');
3768: fnd_message.set_token ('P_TASK_STATUS_NAME', jtf_task_utl.get_status_name(l_status_id));
3769: fnd_msg_pub.add;
3770: x_return_status := fnd_api.g_ret_sts_unexp_error;
3771: END;
3772: -------------

Line 4322: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

4318: --*/
4319: exception
4320: when others
4321: then
4322: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4323: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
4324: fnd_msg_pub.add;
4325: x_return_status := fnd_api.g_ret_sts_unexp_error;
4326: end;

Line 4323: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

4319: exception
4320: when others
4321: then
4322: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4323: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
4324: fnd_msg_pub.add;
4325: x_return_status := fnd_api.g_ret_sts_unexp_error;
4326: end;
4327:

Line 4577: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');

4573: --*/
4574: exception
4575: when others
4576: then
4577: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4578: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
4579: fnd_msg_pub.add;
4580: x_return_status := fnd_api.g_ret_sts_unexp_error;
4581: end;

Line 4578: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);

4574: exception
4575: when others
4576: then
4577: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
4578: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
4579: fnd_msg_pub.add;
4580: x_return_status := fnd_api.g_ret_sts_unexp_error;
4581: end;
4582: