DBA Data[Home] [Help]

APPS.JTF_EC_UTIL dependencies on FND_MESSAGE

Line 62: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
66: END Validate_Owner;

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

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:
66: END Validate_Owner;
67:

Line 90: fnd_message.set_name ('JTF', 'JTF_EC_REQ_API_NULL');

86: And escalation_requester_flag = 'Y';
87:
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,

Line 99: fnd_message.set_name ('JTF', 'JTF_TK_REQUESTER_FLAG');

95: l_api_name
96: );
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,

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

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:
112: FND_MSG_PUB.Add_Exc_Msg

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

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:
112: FND_MSG_PUB.Add_Exc_Msg
113: (G_PKG_NAME,

Line 131: FND_MESSAGE.Set_Name('JTF','JTF_EC_API_INV_PARAMETER' );

127: IS
128:
129: BEGIN
130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
131: FND_MESSAGE.Set_Name('JTF','JTF_EC_API_INV_PARAMETER' );
132: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name );
133: FND_MESSAGE.Set_Token('VALUE', p_token_value );
134: FND_MESSAGE.Set_Token('PARAMETER',p_token_parameter);
135: FND_MSG_PUB.Add;

Line 132: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name );

128:
129: BEGIN
130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
131: FND_MESSAGE.Set_Name('JTF','JTF_EC_API_INV_PARAMETER' );
132: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name );
133: FND_MESSAGE.Set_Token('VALUE', p_token_value );
134: FND_MESSAGE.Set_Token('PARAMETER',p_token_parameter);
135: FND_MSG_PUB.Add;
136: END IF;

Line 133: FND_MESSAGE.Set_Token('VALUE', p_token_value );

129: BEGIN
130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
131: FND_MESSAGE.Set_Name('JTF','JTF_EC_API_INV_PARAMETER' );
132: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name );
133: FND_MESSAGE.Set_Token('VALUE', p_token_value );
134: FND_MESSAGE.Set_Token('PARAMETER',p_token_parameter);
135: FND_MSG_PUB.Add;
136: END IF;
137: END Add_Invalid_Argument_Msg;

Line 134: FND_MESSAGE.Set_Token('PARAMETER',p_token_parameter);

130: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
131: FND_MESSAGE.Set_Name('JTF','JTF_EC_API_INV_PARAMETER' );
132: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name );
133: FND_MESSAGE.Set_Token('VALUE', p_token_value );
134: FND_MESSAGE.Set_Token('PARAMETER',p_token_parameter);
135: FND_MSG_PUB.Add;
136: END IF;
137: END Add_Invalid_Argument_Msg;
138:

Line 216: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
220: END Validate_Esc_Status;

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

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:
220: END Validate_Esc_Status;
221:

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

249: end if;
250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
254: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
255: fnd_msg_pub.ADD;
256: RETURN FALSE;
257: END Validate_Lookup;

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

250:
251: EXCEPTION
252: WHEN OTHERS THEN
253: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
254: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
255: fnd_msg_pub.ADD;
256: RETURN FALSE;
257: END Validate_Lookup;
258:

Line 271: FND_MESSAGE.Set_Name('JTF', 'JTF_EC_API_IGN_PARAMETER');

267: )
268: IS
269: BEGIN
270: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
271: FND_MESSAGE.Set_Name('JTF', 'JTF_EC_API_IGN_PARAMETER');
272: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name);
273: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ignored_param);
274: FND_MSG_PUB.Add;
275: END IF;

Line 272: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name);

268: IS
269: BEGIN
270: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
271: FND_MESSAGE.Set_Name('JTF', 'JTF_EC_API_IGN_PARAMETER');
272: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name);
273: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ignored_param);
274: FND_MSG_PUB.Add;
275: END IF;
276: END Add_Param_Ignored_Msg;

Line 273: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ignored_param);

269: BEGIN
270: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
271: FND_MESSAGE.Set_Name('JTF', 'JTF_EC_API_IGN_PARAMETER');
272: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name);
273: FND_MESSAGE.Set_Token('IGNORED_PARAM', p_token_ignored_param);
274: FND_MSG_PUB.Add;
275: END IF;
276: END Add_Param_Ignored_Msg;
277:

Line 291: FND_MESSAGE.Set_Name('JTF', 'JTF_EC_API_MISS_PARAMETER');

287:
288: Begin
289:
290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
291: FND_MESSAGE.Set_Name('JTF', 'JTF_EC_API_MISS_PARAMETER');
292: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name);
293: FND_MESSAGE.Set_Token('MISSING_PARAM', p_token_miss_param);
294: FND_MSG_PUB.Add;
295: END IF;

Line 292: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name);

288: Begin
289:
290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
291: FND_MESSAGE.Set_Name('JTF', 'JTF_EC_API_MISS_PARAMETER');
292: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name);
293: FND_MESSAGE.Set_Token('MISSING_PARAM', p_token_miss_param);
294: FND_MSG_PUB.Add;
295: END IF;
296:

Line 293: FND_MESSAGE.Set_Token('MISSING_PARAM', p_token_miss_param);

289:
290: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
291: FND_MESSAGE.Set_Name('JTF', 'JTF_EC_API_MISS_PARAMETER');
292: FND_MESSAGE.Set_Token('API_NAME', p_token_api_name);
293: FND_MESSAGE.Set_Token('MISSING_PARAM', p_token_miss_param);
294: FND_MSG_PUB.Add;
295: END IF;
296:
297: END Add_Missing_Param_Msg;

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

368:
369: exception
370: when others then
371:
372: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
373: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
374: fnd_msg_pub.ADD;
375:
376: RETURN FALSE;

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

369: exception
370: when others then
371:
372: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
373: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
374: fnd_msg_pub.ADD;
375:
376: RETURN FALSE;
377:

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

439:
440: exception
441: when others then
442:
443: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
444: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
445: fnd_msg_pub.ADD;
446:
447: RETURN FALSE;

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

440: exception
441: when others then
442:
443: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
444: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
445: fnd_msg_pub.ADD;
446:
447: RETURN FALSE;
448:

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

476:
477: exception
478: when others then
479:
480: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
481: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
482: fnd_msg_pub.ADD;
483:
484: RETURN FALSE;

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

477: exception
478: when others then
479:
480: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
481: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
482: fnd_msg_pub.ADD;
483:
484: RETURN FALSE;
485:

Line 621: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
625: END Validate_Esc_Document;

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

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:
625: END Validate_Esc_Document;
626:

Line 703: fnd_message.set_name('JTF','JTF_EC_RESTRICT_TASKS');

699: open c_chk_open_tasks(p_esc_id) ;
700: fetch c_chk_open_tasks into l_dummy;
701: if c_chk_open_tasks%found then
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

Line 716: fnd_message.set_name('JTF','JTF_EC_CLOSE_WHEN_DEESCALATED');

712: -- check whether the level is De-Escalated.
713:
714: if l_close_deesc = 'Y'
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;

Line 735: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
739: END Check_Completed_Status;

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

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:
739: END Check_Completed_Status;
740:

Line 814: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
818: END Validate_Task_Phone_Id;

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

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:
818: END Validate_Task_Phone_Id;
819:

Line 868: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
872: END Validate_Contact_id;

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

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:
872: END Validate_Contact_id;
873:

Line 918: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
922: END Validate_Task_Contact_Id;

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

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:
922: END Validate_Task_Contact_Id;
923:

Line 968: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
972: END Validate_Task_Reference_Id;

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

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:
972: END Validate_Task_Reference_Id;
973:

Line 1037: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
1041:

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

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:
1041:
1042: END Validate_Who_Info;

Line 1090: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_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:
1094: END Validate_Note_Id;

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

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:
1094: END Validate_Note_Id;
1095:

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

1141:
1142: EXCEPTION
1143: WHEN OTHERS THEN
1144:
1145: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1146: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1147: fnd_msg_pub.ADD;
1148: RETURN NULL;
1149:

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

1142: EXCEPTION
1143: WHEN OTHERS THEN
1144:
1145: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
1146: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1147: fnd_msg_pub.ADD;
1148: RETURN NULL;
1149:
1150: End Get_Requester_Name;