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_MSG_PUB

Line 141: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 144: FND_MSG_PUB.ADD;

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

Line 150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

146: RAISE FND_API.G_EXC_ERROR;
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;

Line 153: FND_MSG_PUB.ADD;

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

Line 270: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

266: open c_user(p_requester_user_name);
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;

Line 273: FND_MSG_PUB.ADD;

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;
277: end if;

Line 328: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 332: FND_MSG_PUB.ADD;

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
336: FND_MESSAGE.Set_Name('JTF', 'JTA_UM_INVALID_USER_EMAIL');

Line 335: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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
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);

Line 341: FND_MSG_PUB.ADD;

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;
345: end if;

Line 476: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

Line 479: FND_MSG_PUB.ADD;

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

Line 590: FND_MSG_PUB.initialize;

586:
587:
588: -- Initialize message list if p_init_msg_list is set to TRUE.
589: IF FND_API.to_Boolean( p_init_msg_list ) THEN
590: FND_MSG_PUB.initialize;
591: END IF;
592:
593: -- Initialize API return status to success
594: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 603: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

599:
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);

Line 608: FND_MSG_PUB.ADD;

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

Line 654: FND_MSG_PUB.Count_And_Get(

650: END IF;
651:
652: -- Standard call to get message count and if count is 1, get message info.
653:
654: FND_MSG_PUB.Count_And_Get(
655: p_count => x_msg_count,
656: p_data => x_msg_data);
657:
658: -- Write to debug log

Line 667: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

663: WHEN FND_API.G_EXC_ERROR THEN
664: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
665: P_API_NAME => L_API_NAME
666: ,P_PKG_NAME => G_PKG_NAME
667: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
668: ,P_SQLCODE => SQLCODE
669: ,P_SQLERRM => SQLERRM
670: ,X_MSG_COUNT => X_MSG_COUNT
671: ,X_MSG_DATA => X_MSG_DATA

Line 678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
675: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
676: P_API_NAME => L_API_NAME
677: ,P_PKG_NAME => G_PKG_NAME
678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
679: ,P_SQLCODE => SQLCODE
680: ,P_SQLERRM => SQLERRM
681: ,X_MSG_COUNT => X_MSG_COUNT
682: ,X_MSG_DATA => X_MSG_DATA

Line 812: FND_MSG_PUB.initialize;

808: SAVEPOINT GetAdHocUser;
809:
810: -- Initialize message list if p_init_msg_list is set to TRUE.
811: IF FND_API.to_Boolean (p_init_msg_list) THEN
812: FND_MSG_PUB.initialize;
813: END IF;
814:
815: -- Initialize API return status to success
816: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 823: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

819: -- Beginning of API body
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;

Line 826: FND_MSG_PUB.ADD;

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

Line 832: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

828: RAISE FND_API.G_EXC_ERROR;
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;

Line 835: FND_MSG_PUB.ADD;

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

Line 878: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

874: COMMIT WORK;
875: END IF;
876:
877: -- Standard call to get message count and if count is 1, get message info.
878: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
879: p_data => x_msg_data);
880:
881: -- call the user hook if it is a public api. Private APIs do not require a user hook call.
882:

Line 890: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

886: EXCEPTION
887: WHEN FND_API.G_EXC_ERROR THEN
888: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
889: P_PKG_NAME => G_PKG_NAME,
890: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
891: P_SQLCODE => SQLCODE,
892: P_SQLERRM => SQLERRM,
893: X_MSG_COUNT => X_MSG_COUNT,
894: X_MSG_DATA => X_MSG_DATA,

Line 900: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
899: P_PKG_NAME => G_PKG_NAME,
900: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
901: P_SQLCODE => SQLCODE,
902: P_SQLERRM => SQLERRM,
903: X_MSG_COUNT => X_MSG_COUNT,
904: X_MSG_DATA => X_MSG_DATA,

Line 1063: FND_MSG_PUB.initialize;

1059: SAVEPOINT EMAIL_NOTIFICATION;
1060:
1061: -- Initialize message list if p_init_msg_list is set to TRUE.
1062: IF FND_API.to_Boolean (p_init_msg_list) THEN
1063: FND_MSG_PUB.initialize;
1064: END IF;
1065:
1066: -- Initialize API return status to success
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1076: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1072: -- Validate required fields for not null values
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;

Line 1079: FND_MSG_PUB.ADD;

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

Line 1085: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1081: RAISE FND_API.G_EXC_ERROR;
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';

Line 1098: FND_MSG_PUB.ADD;

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

Line 1152: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,

1148: COMMIT WORK;
1149: END IF;
1150:
1151: -- Standard call to get message count and if count is 1, get message info.
1152: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1153: p_data => x_msg_data);
1154:
1155: -- call the user hook if it is a public api. Private APIs do not require a user hook call.
1156:

Line 1164: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,

1160: EXCEPTION
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
1163: P_PKG_NAME => G_PKG_NAME,
1164: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1165: P_SQLCODE => SQLCODE,
1166: P_SQLERRM => SQLERRM,
1167: X_MSG_COUNT => X_MSG_COUNT,
1168: X_MSG_DATA => X_MSG_DATA,

Line 1174: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,

1170:
1171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1172: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
1173: P_PKG_NAME => G_PKG_NAME,
1174: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1175: P_SQLCODE => SQLCODE,
1176: P_SQLERRM => SQLERRM,
1177: X_MSG_COUNT => X_MSG_COUNT,
1178: X_MSG_DATA => X_MSG_DATA,