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

Line 142: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_USER');

138: l_wf_user_name := x_user_name;
139:
140: if x_user_name is NULL then
141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
142: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_USER');
143: FND_MESSAGE.Set_TOKEN('0', p_requester_email, FALSE);
144: FND_MSG_PUB.ADD;
145: END IF;
146: RAISE FND_API.G_EXC_ERROR;

Line 143: FND_MESSAGE.Set_TOKEN('0', p_requester_email, FALSE);

139:
140: if x_user_name is NULL then
141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
142: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_USER');
143: FND_MESSAGE.Set_TOKEN('0', p_requester_email, FALSE);
144: FND_MSG_PUB.ADD;
145: END IF;
146: RAISE FND_API.G_EXC_ERROR;
147: end if;

Line 151: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_MULTIPLE_USER');

147: end if;
148:
149: if user_count > 1 then
150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
151: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_MULTIPLE_USER');
152: --FND_MESSAGE.Set_TOKEN('0', p_requester_email, FALSE);
153: FND_MSG_PUB.ADD;
154: END IF;
155: RAISE FND_API.G_EXC_ERROR;

Line 152: --FND_MESSAGE.Set_TOKEN('0', p_requester_email, FALSE);

148:
149: if user_count > 1 then
150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
151: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_MULTIPLE_USER');
152: --FND_MESSAGE.Set_TOKEN('0', p_requester_email, FALSE);
153: FND_MSG_PUB.ADD;
154: END IF;
155: RAISE FND_API.G_EXC_ERROR;
156: end if;

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

267: fetch c_user into x_email, l_customer_id, l_employee_id;
268: if (c_user%NOTFOUND) then
269: close c_user;
270: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
271: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_USER');
272: FND_MESSAGE.Set_TOKEN('0', p_requester_user_name, FALSE);
273: FND_MSG_PUB.ADD;
274: END IF;
275: x_user := NULL;

Line 272: FND_MESSAGE.Set_TOKEN('0', p_requester_user_name, FALSE);

268: if (c_user%NOTFOUND) then
269: close c_user;
270: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
271: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_USER');
272: FND_MESSAGE.Set_TOKEN('0', p_requester_user_name, FALSE);
273: FND_MSG_PUB.ADD;
274: END IF;
275: x_user := NULL;
276: RAISE FND_API.G_EXC_ERROR;

Line 329: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_EMAIL');

325: -- if x_email is null raise an error
326: if x_email is NULL then
327: if p_requester_email is NULL then
328: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
329: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_EMAIL');
330: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);
331: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);
332: FND_MSG_PUB.ADD;
333: END IF;

Line 330: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);

326: if x_email is NULL then
327: if p_requester_email is NULL then
328: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
329: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_EMAIL');
330: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);
331: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);
332: FND_MSG_PUB.ADD;
333: END IF;
334: else

Line 331: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);

327: if p_requester_email is NULL then
328: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
329: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_EMAIL');
330: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);
331: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);
332: FND_MSG_PUB.ADD;
333: END IF;
334: else
335: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 336: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_USER_EMAIL');

332: FND_MSG_PUB.ADD;
333: END IF;
334: else
335: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
336: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_USER_EMAIL');
337: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);
338: FND_MESSAGE.Set_TOKEN('1', p_requester_email, FALSE);
339: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);
340: --FND_MESSAGE.Set_TOKEN('EMAIL', p_requester_email, FALSE);

Line 337: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);

333: END IF;
334: else
335: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
336: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_USER_EMAIL');
337: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);
338: FND_MESSAGE.Set_TOKEN('1', p_requester_email, FALSE);
339: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);
340: --FND_MESSAGE.Set_TOKEN('EMAIL', p_requester_email, FALSE);
341: FND_MSG_PUB.ADD;

Line 338: FND_MESSAGE.Set_TOKEN('1', p_requester_email, FALSE);

334: else
335: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
336: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_USER_EMAIL');
337: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);
338: FND_MESSAGE.Set_TOKEN('1', p_requester_email, FALSE);
339: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);
340: --FND_MESSAGE.Set_TOKEN('EMAIL', p_requester_email, FALSE);
341: FND_MSG_PUB.ADD;
342: END IF;

Line 339: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);

335: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
336: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_USER_EMAIL');
337: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);
338: FND_MESSAGE.Set_TOKEN('1', p_requester_email, FALSE);
339: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);
340: --FND_MESSAGE.Set_TOKEN('EMAIL', p_requester_email, FALSE);
341: FND_MSG_PUB.ADD;
342: END IF;
343: end if;

Line 340: --FND_MESSAGE.Set_TOKEN('EMAIL', p_requester_email, FALSE);

336: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_USER_EMAIL');
337: FND_MESSAGE.Set_TOKEN('0', x_user, FALSE);
338: FND_MESSAGE.Set_TOKEN('1', p_requester_email, FALSE);
339: --FND_MESSAGE.Set_TOKEN('USER', x_user, FALSE);
340: --FND_MESSAGE.Set_TOKEN('EMAIL', p_requester_email, FALSE);
341: FND_MSG_PUB.ADD;
342: END IF;
343: end if;
344: RAISE FND_API.G_EXC_ERROR;

Line 477: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_USER');

473: end if;
474:
475: if x_user_name is NULL then
476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
477: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_USER');
478: FND_MESSAGE.Set_TOKEN('0', p_requester_email, FALSE);
479: FND_MSG_PUB.ADD;
480: END IF;
481: RAISE FND_API.G_EXC_ERROR;

Line 478: FND_MESSAGE.Set_TOKEN('0', p_requester_email, FALSE);

474:
475: if x_user_name is NULL then
476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
477: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_NO_USER');
478: FND_MESSAGE.Set_TOKEN('0', p_requester_email, FALSE);
479: FND_MSG_PUB.ADD;
480: END IF;
481: RAISE FND_API.G_EXC_ERROR;
482: end if;

Line 604: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');

600: -- Validate required fields for not null values
601:
602: if (x_requester_user_name is null and x_requester_email is null) then
603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
604: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
605: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
606: FND_MESSAGE.Set_Token('API_NAME', 'resetting the password', FALSE);
607: FND_MESSAGE.Set_Token('FIELD', 'USER_NAME, EMAIL', FALSE);
608: FND_MSG_PUB.ADD;

Line 605: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);

601:
602: if (x_requester_user_name is null and x_requester_email is null) then
603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
604: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
605: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
606: FND_MESSAGE.Set_Token('API_NAME', 'resetting the password', FALSE);
607: FND_MESSAGE.Set_Token('FIELD', 'USER_NAME, EMAIL', FALSE);
608: FND_MSG_PUB.ADD;
609: END IF;

Line 606: FND_MESSAGE.Set_Token('API_NAME', 'resetting the password', FALSE);

602: if (x_requester_user_name is null and x_requester_email is null) then
603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
604: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
605: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
606: FND_MESSAGE.Set_Token('API_NAME', 'resetting the password', FALSE);
607: FND_MESSAGE.Set_Token('FIELD', 'USER_NAME, EMAIL', FALSE);
608: FND_MSG_PUB.ADD;
609: END IF;
610: RAISE FND_API.G_EXC_ERROR;

Line 607: FND_MESSAGE.Set_Token('FIELD', 'USER_NAME, EMAIL', FALSE);

603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
604: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
605: --FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME, FALSE);
606: FND_MESSAGE.Set_Token('API_NAME', 'resetting the password', FALSE);
607: FND_MESSAGE.Set_Token('FIELD', 'USER_NAME, EMAIL', FALSE);
608: FND_MSG_PUB.ADD;
609: END IF;
610: RAISE FND_API.G_EXC_ERROR;
611: end if;

Line 824: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_EMAIL_MISS_USERNAME');

820: --
821: -- Validate required fields
822: IF (p_username is null) THEN
823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
824: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_EMAIL_MISS_USERNAME');
825: FND_MESSAGE.Set_Token('0', 'GetAdHocUser', FALSE);
826: FND_MSG_PUB.ADD;
827: END IF;
828: RAISE FND_API.G_EXC_ERROR;

Line 825: FND_MESSAGE.Set_Token('0', 'GetAdHocUser', FALSE);

821: -- Validate required fields
822: IF (p_username is null) THEN
823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
824: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_EMAIL_MISS_USERNAME');
825: FND_MESSAGE.Set_Token('0', 'GetAdHocUser', FALSE);
826: FND_MSG_PUB.ADD;
827: END IF;
828: RAISE FND_API.G_EXC_ERROR;
829: END IF;

Line 833: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_EMAIL_MISS_EMAIL');

829: END IF;
830:
831: IF (p_email_address is null) THEN
832: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
833: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_EMAIL_MISS_EMAIL');
834: FND_MESSAGE.Set_Token('0', 'GetAdHocUser', FALSE);
835: FND_MSG_PUB.ADD;
836: END IF;
837: RAISE FND_API.G_EXC_ERROR;

Line 834: FND_MESSAGE.Set_Token('0', 'GetAdHocUser', FALSE);

830:
831: IF (p_email_address is null) THEN
832: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
833: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_EMAIL_MISS_EMAIL');
834: FND_MESSAGE.Set_Token('0', 'GetAdHocUser', FALSE);
835: FND_MSG_PUB.ADD;
836: END IF;
837: RAISE FND_API.G_EXC_ERROR;
838: END IF;

Line 1077: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_EMAIL_MISS_USER_EMAIL');

1073:
1074: -- Both username and email_address cannot be null.
1075: IF (p_username is null) AND (p_email_address is null) THEN
1076: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1077: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_EMAIL_MISS_USER_EMAIL');
1078: FND_MESSAGE.Set_Token('0', 'EmailNotification', FALSE);
1079: FND_MSG_PUB.ADD;
1080: END IF;
1081: RAISE FND_API.G_EXC_ERROR;

Line 1078: FND_MESSAGE.Set_Token('0', 'EmailNotification', FALSE);

1074: -- Both username and email_address cannot be null.
1075: IF (p_username is null) AND (p_email_address is null) THEN
1076: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1077: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_EMAIL_MISS_USER_EMAIL');
1078: FND_MESSAGE.Set_Token('0', 'EmailNotification', FALSE);
1079: FND_MSG_PUB.ADD;
1080: END IF;
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;

Line 1086: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');

1082: END IF;
1083:
1084: IF (p_subject is null) OR (p_text_body is null) THEN
1085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1086: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
1087: FND_MESSAGE.Set_Token('API_NAME', 'UM Send Notification', FALSE);
1088: IF (p_subject is null) THEN
1089: l_error_msg := 'p_subject';
1090: END IF;

Line 1087: FND_MESSAGE.Set_Token('API_NAME', 'UM Send Notification', FALSE);

1083:
1084: IF (p_subject is null) OR (p_text_body is null) THEN
1085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1086: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_REQUIRED_FIELD');
1087: FND_MESSAGE.Set_Token('API_NAME', 'UM Send Notification', FALSE);
1088: IF (p_subject is null) THEN
1089: l_error_msg := 'p_subject';
1090: END IF;
1091: IF (p_text_body is null) THEN

Line 1097: FND_MESSAGE.Set_Token('FIELD', l_error_msg, FALSE);

1093: l_error_msg := l_error_msg || ', ';
1094: END IF;
1095: l_error_msg := l_error_msg || 'p_text_body';
1096: END IF;
1097: FND_MESSAGE.Set_Token('FIELD', l_error_msg, FALSE);
1098: FND_MSG_PUB.ADD;
1099: END IF;
1100: RAISE FND_API.G_EXC_ERROR;
1101: END IF;

Line 1895: Code Changes for 5033237/5033238, the errMsg from FND_MESSAGE Stack is being re-used.

1891: exception. We require this wrapper as we dont know whether the exception is due
1892: to invalid username or something other exception .We check the sqlcode and accordingly
1893: process.We cannot have a boolean function as we cannot access it from the JDBC layer.
1894:
1895: Code Changes for 5033237/5033238, the errMsg from FND_MESSAGE Stack is being re-used.
1896: */
1897:
1898: function validate_user_name(username varchar2, errMsg out NOCOPY varchar2) return number
1899:

Line 1909: errMsg := FND_MESSAGE.get;

1905: return 1;
1906: exception
1907: when others then
1908: IF sqlcode = -20001 then
1909: errMsg := FND_MESSAGE.get;
1910: return 0;
1911: else
1912: raise_application_error(-20001,sqlerrm);
1913: end if;