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_EC_UTIL dependencies on FND_API

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

24: WHERE object_user_code = 'RESOURCES'));
25:
26: BEGIN
27:
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: if p_owner_id is NULL or p_owner_id = fnd_api.g_miss_num then
31: Add_Invalid_Argument_Msg(l_api_name, 'NULL','owner_id');
32: raise fnd_api.g_exc_error;

Line 30: if p_owner_id is NULL or p_owner_id = fnd_api.g_miss_num then

26: BEGIN
27:
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: if p_owner_id is NULL or p_owner_id = fnd_api.g_miss_num then
31: Add_Invalid_Argument_Msg(l_api_name, 'NULL','owner_id');
32: raise fnd_api.g_exc_error;
33: --Bug 2723761
34: end if;

Line 32: raise fnd_api.g_exc_error;

28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: if p_owner_id is NULL or p_owner_id = fnd_api.g_miss_num then
31: Add_Invalid_Argument_Msg(l_api_name, 'NULL','owner_id');
32: raise fnd_api.g_exc_error;
33: --Bug 2723761
34: end if;
35:
36: -- elsif p_owner_type <> jtf_ec_pub.g_escalation_owner_type_code then

Line 38: if p_owner_type is not NULL and p_owner_type <> fnd_api.g_miss_char then

34: end if;
35:
36: -- elsif p_owner_type <> jtf_ec_pub.g_escalation_owner_type_code then
37:
38: if p_owner_type is not NULL and p_owner_type <> fnd_api.g_miss_char then
39: OPEN c_object_code;
40: FETCH c_object_code INTO x;
41:
42: IF c_object_code%NOTFOUND THEN

Line 44: raise fnd_api.g_exc_error;

40: FETCH c_object_code INTO x;
41:
42: IF c_object_code%NOTFOUND THEN
43: Add_Invalid_Argument_Msg(l_api_name, p_owner_type, 'owner_type');
44: raise fnd_api.g_exc_error;
45: END IF;
46: CLOSE c_object_code;
47: else
48: --end changes

Line 50: raise fnd_api.g_exc_error;

46: CLOSE c_object_code;
47: else
48: --end changes
49: Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'owner_type');
50: raise fnd_api.g_exc_error;
51: end if;
52:
53: EXCEPTION
54:

Line 55: WHEN fnd_api.g_exc_error

51: end if;
52:
53: EXCEPTION
54:
55: WHEN fnd_api.g_exc_error
56: THEN
57: x_return_status := fnd_api.g_ret_sts_error;
58:
59: WHEN OTHERS THEN

Line 57: x_return_status := fnd_api.g_ret_sts_error;

53: EXCEPTION
54:
55: WHEN fnd_api.g_exc_error
56: THEN
57: x_return_status := fnd_api.g_ret_sts_error;
58:
59: WHEN OTHERS THEN
60:
61: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 61: x_return_status := fnd_api.g_ret_sts_unexp_error;

57: x_return_status := fnd_api.g_ret_sts_error;
58:
59: WHEN OTHERS THEN
60:
61: x_return_status := fnd_api.g_ret_sts_unexp_error;
62: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
63: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
64: fnd_msg_pub.ADD;
65:

Line 81: x_return_status := fnd_api.g_ret_sts_success;

77:
78:
79: BEGIN
80:
81: x_return_status := fnd_api.g_ret_sts_success;
82:
83: Select 'x' into l_dummy
84: From jtf_task_contacts
85: Where task_id = p_escalation_id

Line 92: x_return_status := fnd_api.g_ret_sts_error;

88: Exception
89: When no_data_found then
90: fnd_message.set_name ('JTF', 'JTF_EC_REQ_API_NULL');
91: fnd_msg_pub.Add;
92: x_return_status := fnd_api.g_ret_sts_error;
93: FND_MSG_PUB.Add_Exc_Msg
94: (G_PKG_NAME,
95: l_api_name
96: );

Line 101: x_return_status := fnd_api.g_ret_sts_error;

97:
98: When too_many_rows then
99: fnd_message.set_name ('JTF', 'JTF_TK_REQUESTER_FLAG');
100: fnd_msg_pub.Add;
101: x_return_status := fnd_api.g_ret_sts_error;
102: FND_MSG_PUB.Add_Exc_Msg
103: (G_PKG_NAME,
104: l_api_name
105: );

Line 107: x_return_status := fnd_api.g_ret_sts_unexp_error;

103: (G_PKG_NAME,
104: l_api_name
105: );
106: When others then
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
109: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
110: fnd_msg_pub.ADD;
111:

Line 170: x_return_status := fnd_api.g_ret_sts_success;

166:
167:
168: BEGIN
169:
170: x_return_status := fnd_api.g_ret_sts_success;
171:
172: if p_esc_status_id is not NULL and p_esc_status_id <> fnd_api.g_miss_num then
173: open c_esc_status_id(p_esc_status_id);
174: fetch c_esc_status_id into x_esc_status_id;

Line 172: if p_esc_status_id is not NULL and p_esc_status_id <> fnd_api.g_miss_num then

168: BEGIN
169:
170: x_return_status := fnd_api.g_ret_sts_success;
171:
172: if p_esc_status_id is not NULL and p_esc_status_id <> fnd_api.g_miss_num then
173: open c_esc_status_id(p_esc_status_id);
174: fetch c_esc_status_id into x_esc_status_id;
175: if c_esc_status_id%NOTFOUND then
176: close c_esc_status_id;

Line 178: raise fnd_api.g_exc_error;

174: fetch c_esc_status_id into x_esc_status_id;
175: if c_esc_status_id%NOTFOUND then
176: close c_esc_status_id;
177: Add_Invalid_Argument_Msg(l_api_name, to_char(p_esc_status_id), 'esc_status_id');
178: raise fnd_api.g_exc_error;
179: end if;
180: close c_esc_status_id;
181:
182: if p_esc_status_name <> fnd_api.g_miss_char then

Line 182: if p_esc_status_name <> fnd_api.g_miss_char then

178: raise fnd_api.g_exc_error;
179: end if;
180: close c_esc_status_id;
181:
182: if p_esc_status_name <> fnd_api.g_miss_char then
183: jtf_ec_util.add_param_ignored_msg(l_api_name, 'status_name');
184: end if;
185:
186: elsif p_esc_status_name is not NULL and p_esc_status_name <> fnd_api.g_miss_char then

Line 186: elsif p_esc_status_name is not NULL and p_esc_status_name <> fnd_api.g_miss_char then

182: if p_esc_status_name <> fnd_api.g_miss_char then
183: jtf_ec_util.add_param_ignored_msg(l_api_name, 'status_name');
184: end if;
185:
186: elsif p_esc_status_name is not NULL and p_esc_status_name <> fnd_api.g_miss_char then
187: open c_esc_status_name(p_esc_status_name);
188: fetch c_esc_status_name into x_esc_status_id;
189: if c_esc_status_name%NOTFOUND then
190: close c_esc_status_name;

Line 192: raise fnd_api.g_exc_error;

188: fetch c_esc_status_name into x_esc_status_id;
189: if c_esc_status_name%NOTFOUND then
190: close c_esc_status_name;
191: Add_Invalid_Argument_Msg(l_api_name, p_esc_status_name, 'esc_status_name');
192: raise fnd_api.g_exc_error;
193: end if;
194: close c_esc_status_name;
195: elsif p_esc_status_name is NULL and p_esc_status_id is NULL then
196: Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'esc_status_id');

Line 198: raise fnd_api.g_exc_error;

194: close c_esc_status_name;
195: elsif p_esc_status_name is NULL and p_esc_status_id is NULL then
196: Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'esc_status_id');
197: Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'esc_status_name');
198: raise fnd_api.g_exc_error;
199: else
200: Add_Missing_Param_Msg(l_api_name, 'esc_status_id');
201: Add_Missing_Param_Msg(l_api_name, 'esc_status_name');
202: raise fnd_api.g_exc_error;

Line 202: raise fnd_api.g_exc_error;

198: raise fnd_api.g_exc_error;
199: else
200: Add_Missing_Param_Msg(l_api_name, 'esc_status_id');
201: Add_Missing_Param_Msg(l_api_name, 'esc_status_name');
202: raise fnd_api.g_exc_error;
203: end if;
204:
205:
206:

Line 209: WHEN fnd_api.g_exc_error

205:
206:
207: EXCEPTION
208:
209: WHEN fnd_api.g_exc_error
210: THEN
211: x_return_status := fnd_api.g_ret_sts_error;
212:
213: WHEN OTHERS THEN

Line 211: x_return_status := fnd_api.g_ret_sts_error;

207: EXCEPTION
208:
209: WHEN fnd_api.g_exc_error
210: THEN
211: x_return_status := fnd_api.g_ret_sts_error;
212:
213: WHEN OTHERS THEN
214:
215: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 215: x_return_status := fnd_api.g_ret_sts_unexp_error;

211: x_return_status := fnd_api.g_ret_sts_error;
212:
213: WHEN OTHERS THEN
214:
215: x_return_status := fnd_api.g_ret_sts_unexp_error;
216: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
217: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
218: fnd_msg_pub.ADD;
219:

Line 517: x_return_status := FND_API.G_RET_STS_SUCCESS;

513: l_error_message VARCHAR2(2000);
514:
515: BEGIN
516: -- Initialize API return status to success
517: x_return_status := FND_API.G_RET_STS_SUCCESS;
518:
519:
520: IF ( p_desc_context || p_desc_segment1 || p_desc_segment2 ||
521: p_desc_segment3 || p_desc_segment4 || p_desc_segment5 ||

Line 552: x_return_status := FND_API.G_RET_STS_ERROR;

548: resp_id => p_resp_id
549: ) THEN
550: l_error_message := FND_FLEX_DESCVAL.Error_Message;
551: -- need to return a message
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: END IF;
554: END IF;
555:
556: END Validate_Desc_Flex;

Line 586: x_return_status := FND_API.G_RET_STS_SUCCESS;

582:
583: BEGIN
584:
585: -- Initialize API return status to success
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: if p_esc_id is not NULL then
589: open c_esc_id(p_esc_id);
590: fetch c_esc_id into l_esc_id;

Line 594: raise fnd_api.g_exc_error;

590: fetch c_esc_id into l_esc_id;
591: if c_esc_id%NOTFOUND then
592: close c_esc_id;
593: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, p_esc_id, 'escalation_id');
594: raise fnd_api.g_exc_error;
595: end if;
596: close c_esc_id;
597: elsif p_esc_number is not NULL then
598: open c_esc_number(p_esc_number);

Line 603: raise fnd_api.g_exc_error;

599: fetch c_esc_number into l_esc_id;
600: if c_esc_number%NOTFOUND then
601: close c_esc_number;
602: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, p_esc_number, 'escalation_number');
603: raise fnd_api.g_exc_error;
604: end if;
605: close c_esc_number;
606: else jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'p_esc_id');
607: jtf_ec_util.Add_Invalid_Argument_Msg(l_api_name, 'NULL', 'p_esc_number');

Line 614: WHEN fnd_api.g_exc_error

610: x_esc_id := l_esc_id;
611:
612: EXCEPTION
613:
614: WHEN fnd_api.g_exc_error
615: THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617:
618: WHEN OTHERS THEN

Line 616: x_return_status := fnd_api.g_ret_sts_error;

612: EXCEPTION
613:
614: WHEN fnd_api.g_exc_error
615: THEN
616: x_return_status := fnd_api.g_ret_sts_error;
617:
618: WHEN OTHERS THEN
619:
620: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 620: x_return_status := fnd_api.g_ret_sts_unexp_error;

616: x_return_status := fnd_api.g_ret_sts_error;
617:
618: WHEN OTHERS THEN
619:
620: x_return_status := fnd_api.g_ret_sts_unexp_error;
621: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
622: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
623: fnd_msg_pub.ADD;
624:

Line 673: x_return_status := FND_API.G_RET_STS_SUCCESS;

669:
670: BEGIN
671:
672: -- Initialize API return status to success
673: x_return_status := FND_API.G_RET_STS_SUCCESS;
674:
675: fnd_profile.get('JTF_EC_CLOSE_WHEN_DEESCALATED', l_close_deesc);
676:
677:

Line 678: if p_esc_level = fnd_api.g_miss_char then

674:
675: fnd_profile.get('JTF_EC_CLOSE_WHEN_DEESCALATED', l_close_deesc);
676:
677:
678: if p_esc_level = fnd_api.g_miss_char then
679:
680: Open c_get_esc_level(p_esc_id);
681: fetch c_get_esc_level into l_esc_level;
682: if c_get_esc_level%NOTFOUND then

Line 684: raise fnd_api.g_exc_error; -- need to give the reason

680: Open c_get_esc_level(p_esc_id);
681: fetch c_get_esc_level into l_esc_level;
682: if c_get_esc_level%NOTFOUND then
683: close c_get_esc_level;
684: raise fnd_api.g_exc_error; -- need to give the reason
685: end if;
686: close c_get_esc_level;
687:
688: end if;

Line 706: raise fnd_api.g_exc_error;

702: close c_chk_open_tasks;
703: fnd_message.set_name('JTF','JTF_EC_RESTRICT_TASKS');
704: fnd_msg_pub.Add;
705: x_closed_flag := 'N';
706: raise fnd_api.g_exc_error;
707: else
708: close c_chk_open_tasks;
709: end if;
710:

Line 719: raise fnd_api.g_exc_error;

715: and l_esc_level <> 'DE' then
716: fnd_message.set_name('JTF','JTF_EC_CLOSE_WHEN_DEESCALATED');
717: fnd_msg_pub.Add;
718: x_closed_flag := 'N';
719: raise fnd_api.g_exc_error;
720: end if;
721: else
722: close c_chk_completed;
723: end if;

Line 728: WHEN fnd_api.g_exc_error

724:
725:
726: EXCEPTION
727:
728: WHEN fnd_api.g_exc_error
729: THEN
730: x_return_status := fnd_api.g_ret_sts_error;
731:
732: WHEN OTHERS THEN

Line 730: x_return_status := fnd_api.g_ret_sts_error;

726: EXCEPTION
727:
728: WHEN fnd_api.g_exc_error
729: THEN
730: x_return_status := fnd_api.g_ret_sts_error;
731:
732: WHEN OTHERS THEN
733:
734: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 734: x_return_status := fnd_api.g_ret_sts_unexp_error;

730: x_return_status := fnd_api.g_ret_sts_error;
731:
732: WHEN OTHERS THEN
733:
734: x_return_status := fnd_api.g_ret_sts_unexp_error;
735: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
736: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
737: fnd_msg_pub.ADD;
738:

Line 744: if p_number = fnd_api.g_miss_num then

740:
741: PROCEDURE Conv_Miss_Num(p_number IN OUT NOCOPY NUMBER) Is
742: BEGIN
743:
744: if p_number = fnd_api.g_miss_num then
745: p_number := NULL;
746: end if;
747:
748: END Conv_Miss_Num;

Line 753: if p_date = fnd_api.g_miss_date then

749:
750: PROCEDURE Conv_Miss_Date(p_date IN OUT NOCOPY DATE) Is
751: BEGIN
752:
753: if p_date = fnd_api.g_miss_date then
754: p_date := NULL;
755: end if;
756:
757: END Conv_Miss_Date;

Line 762: if p_char = fnd_api.g_miss_char then

758:
759: PROCEDURE Conv_Miss_Char(p_char IN OUT NOCOPY VARCHAR2) Is
760: BEGIN
761:
762: if p_char = fnd_api.g_miss_char then
763: p_char := NULL;
764: end if;
765:
766: END Conv_Miss_Char;

Line 792: x_return_status := FND_API.G_RET_STS_SUCCESS;

788:
789: BEGIN
790:
791: -- Initialize API return status to success
792: x_return_status := FND_API.G_RET_STS_SUCCESS;
793:
794: open c_check_phone_id(p_task_phone_id,p_escalation_id);
795: fetch c_check_phone_id into l_dummy;
796: if c_check_phone_id%NOTFOUND then

Line 799: raise fnd_api.g_exc_error;

795: fetch c_check_phone_id into l_dummy;
796: if c_check_phone_id%NOTFOUND then
797: close c_check_phone_id;
798: Add_Invalid_Argument_Msg(l_api_name, p_task_phone_id ,'task_phone_id');
799: raise fnd_api.g_exc_error;
800: else
801: close c_check_phone_id;
802: end if;
803:

Line 807: WHEN fnd_api.g_exc_error

803:
804:
805: EXCEPTION
806:
807: WHEN fnd_api.g_exc_error
808: THEN
809: x_return_status := fnd_api.g_ret_sts_error;
810:
811: WHEN OTHERS THEN

Line 809: x_return_status := fnd_api.g_ret_sts_error;

805: EXCEPTION
806:
807: WHEN fnd_api.g_exc_error
808: THEN
809: x_return_status := fnd_api.g_ret_sts_error;
810:
811: WHEN OTHERS THEN
812:
813: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 813: x_return_status := fnd_api.g_ret_sts_unexp_error;

809: x_return_status := fnd_api.g_ret_sts_error;
810:
811: WHEN OTHERS THEN
812:
813: x_return_status := fnd_api.g_ret_sts_unexp_error;
814: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
815: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
816: fnd_msg_pub.Add;
817:

Line 845: x_return_status := FND_API.G_RET_STS_SUCCESS;

841:
842: BEGIN
843:
844: -- Initialize API return status to success
845: x_return_status := FND_API.G_RET_STS_SUCCESS;
846:
847: open c_check_contact(p_contact_id, p_contact_type_code, p_escalation_id);
848: fetch c_check_contact into x_task_contact_id;
849: if c_check_contact%NOTFOUND then

Line 853: raise fnd_api.g_exc_error;

849: if c_check_contact%NOTFOUND then
850: close c_check_contact;
851: Add_Invalid_Argument_Msg(l_api_name, p_contact_id ,'contact_id');
852: Add_Invalid_Argument_Msg(l_api_name, p_contact_type_code,'contact_type_code');
853: raise fnd_api.g_exc_error;
854: else
855: close c_check_contact;
856: end if;
857:

Line 861: WHEN fnd_api.g_exc_error

857:
858:
859: EXCEPTION
860:
861: WHEN fnd_api.g_exc_error
862: THEN
863: x_return_status := fnd_api.g_ret_sts_error;
864:
865: WHEN OTHERS THEN

Line 863: x_return_status := fnd_api.g_ret_sts_error;

859: EXCEPTION
860:
861: WHEN fnd_api.g_exc_error
862: THEN
863: x_return_status := fnd_api.g_ret_sts_error;
864:
865: WHEN OTHERS THEN
866:
867: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 867: x_return_status := fnd_api.g_ret_sts_unexp_error;

863: x_return_status := fnd_api.g_ret_sts_error;
864:
865: WHEN OTHERS THEN
866:
867: x_return_status := fnd_api.g_ret_sts_unexp_error;
868: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
869: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
870: fnd_msg_pub.Add;
871:

Line 896: x_return_status := FND_API.G_RET_STS_SUCCESS;

892:
893: BEGIN
894:
895: -- Initialize API return status to success
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898: open c_check_task_contact_id(p_task_contact_id,p_escalation_id);
899: fetch c_check_task_contact_id into l_dummy;
900: if c_check_task_contact_id%NOTFOUND then

Line 903: raise fnd_api.g_exc_error;

899: fetch c_check_task_contact_id into l_dummy;
900: if c_check_task_contact_id%NOTFOUND then
901: close c_check_task_contact_id;
902: Add_Invalid_Argument_Msg(l_api_name, p_task_contact_id ,'task_contact_id');
903: raise fnd_api.g_exc_error;
904: else
905: close c_check_task_contact_id;
906: end if;
907:

Line 911: WHEN fnd_api.g_exc_error

907:
908:
909: EXCEPTION
910:
911: WHEN fnd_api.g_exc_error
912: THEN
913: x_return_status := fnd_api.g_ret_sts_error;
914:
915: WHEN OTHERS THEN

Line 913: x_return_status := fnd_api.g_ret_sts_error;

909: EXCEPTION
910:
911: WHEN fnd_api.g_exc_error
912: THEN
913: x_return_status := fnd_api.g_ret_sts_error;
914:
915: WHEN OTHERS THEN
916:
917: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 917: x_return_status := fnd_api.g_ret_sts_unexp_error;

913: x_return_status := fnd_api.g_ret_sts_error;
914:
915: WHEN OTHERS THEN
916:
917: x_return_status := fnd_api.g_ret_sts_unexp_error;
918: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
919: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
920: fnd_msg_pub.Add;
921:

Line 946: x_return_status := FND_API.G_RET_STS_SUCCESS;

942:
943: BEGIN
944:
945: -- Initialize API return status to success
946: x_return_status := FND_API.G_RET_STS_SUCCESS;
947:
948: open c_check_task_ref_id(p_task_reference_id,p_escalation_id);
949: fetch c_check_task_ref_id into l_dummy;
950: if c_check_task_ref_id%NOTFOUND then

Line 953: raise fnd_api.g_exc_error;

949: fetch c_check_task_ref_id into l_dummy;
950: if c_check_task_ref_id%NOTFOUND then
951: close c_check_task_ref_id;
952: Add_Invalid_Argument_Msg(l_api_name, p_task_reference_id ,'task_reference_id');
953: raise fnd_api.g_exc_error;
954: else
955: close c_check_task_ref_id;
956: end if;
957:

Line 961: WHEN fnd_api.g_exc_error

957:
958:
959: EXCEPTION
960:
961: WHEN fnd_api.g_exc_error
962: THEN
963: x_return_status := fnd_api.g_ret_sts_error;
964:
965: WHEN OTHERS THEN

Line 963: x_return_status := fnd_api.g_ret_sts_error;

959: EXCEPTION
960:
961: WHEN fnd_api.g_exc_error
962: THEN
963: x_return_status := fnd_api.g_ret_sts_error;
964:
965: WHEN OTHERS THEN
966:
967: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 967: x_return_status := fnd_api.g_ret_sts_unexp_error;

963: x_return_status := fnd_api.g_ret_sts_error;
964:
965: WHEN OTHERS THEN
966:
967: x_return_status := fnd_api.g_ret_sts_unexp_error;
968: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
969: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
970: fnd_msg_pub.Add;
971:

Line 1004: x_return_status := FND_API.G_RET_STS_SUCCESS;

1000:
1001: BEGIN
1002:
1003: -- Initialize Return Status to SUCCESS
1004: x_return_status := FND_API.G_RET_STS_SUCCESS;
1005:
1006: open c_check_user_id(p_user_id);
1007: fetch c_check_user_id into l_dummy;
1008: if c_check_user_id%NOTFOUND then

Line 1011: raise fnd_api.g_exc_error;

1007: fetch c_check_user_id into l_dummy;
1008: if c_check_user_id%NOTFOUND then
1009: close c_check_user_id;
1010: Add_Invalid_Argument_Msg(p_api_name, p_user_id ,'user_id');
1011: raise fnd_api.g_exc_error;
1012: else
1013: close c_check_user_id;
1014: end if;
1015:

Line 1022: raise fnd_api.g_exc_error;

1018: fetch c_check_login_id into l_dummy;
1019: if c_check_login_id%NOTFOUND then
1020: close c_check_login_id;
1021: Add_Invalid_Argument_Msg(p_api_name, p_login_id ,'login_id');
1022: raise fnd_api.g_exc_error;
1023: else
1024: close c_check_login_id;
1025: end if;
1026:

Line 1030: WHEN fnd_api.g_exc_error

1026:
1027: end if;
1028: EXCEPTION
1029:
1030: WHEN fnd_api.g_exc_error
1031: THEN
1032: x_return_status := fnd_api.g_ret_sts_error;
1033:
1034: WHEN OTHERS THEN

Line 1032: x_return_status := fnd_api.g_ret_sts_error;

1028: EXCEPTION
1029:
1030: WHEN fnd_api.g_exc_error
1031: THEN
1032: x_return_status := fnd_api.g_ret_sts_error;
1033:
1034: WHEN OTHERS THEN
1035:
1036: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1036: x_return_status := fnd_api.g_ret_sts_unexp_error;

1032: x_return_status := fnd_api.g_ret_sts_error;
1033:
1034: WHEN OTHERS THEN
1035:
1036: x_return_status := fnd_api.g_ret_sts_unexp_error;
1037: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1038: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1039: fnd_msg_pub.Add;
1040:

Line 1068: x_return_status := FND_API.G_RET_STS_SUCCESS;

1064:
1065: BEGIN
1066:
1067: -- Initialize API return status to success
1068: x_return_status := FND_API.G_RET_STS_SUCCESS;
1069:
1070: open c_check_note_id(p_note_id,p_escalation_id);
1071: fetch c_check_note_id into l_dummy;
1072: if c_check_note_id%NOTFOUND then

Line 1075: raise fnd_api.g_exc_error;

1071: fetch c_check_note_id into l_dummy;
1072: if c_check_note_id%NOTFOUND then
1073: close c_check_note_id;
1074: Add_Invalid_Argument_Msg(l_api_name, p_note_id ,'note_id');
1075: raise fnd_api.g_exc_error;
1076: else
1077: close c_check_note_id;
1078: end if;
1079:

Line 1083: WHEN fnd_api.g_exc_error

1079:
1080:
1081: EXCEPTION
1082:
1083: WHEN fnd_api.g_exc_error
1084: THEN
1085: x_return_status := fnd_api.g_ret_sts_error;
1086:
1087: WHEN OTHERS THEN

Line 1085: x_return_status := fnd_api.g_ret_sts_error;

1081: EXCEPTION
1082:
1083: WHEN fnd_api.g_exc_error
1084: THEN
1085: x_return_status := fnd_api.g_ret_sts_error;
1086:
1087: WHEN OTHERS THEN
1088:
1089: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1089: x_return_status := fnd_api.g_ret_sts_unexp_error;

1085: x_return_status := fnd_api.g_ret_sts_error;
1086:
1087: WHEN OTHERS THEN
1088:
1089: x_return_status := fnd_api.g_ret_sts_unexp_error;
1090: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1091: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1092: fnd_msg_pub.Add;
1093: