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_API

Line 88: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE))

84: select user_name
85: from fnd_user
86: where upper(email_address) = p_requester_email
87: and (nvl(end_date, sysdate + 1) > sysdate or
88: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE))
89:
90:
91: union
92:

Line 99: to_char(fnd.END_DATE) = to_char(FND_API.G_MISS_DATE))

95: from fnd_user fnd, per_all_people_f per
96: where per.person_id = fnd.employee_id
97: and per.effective_end_date > sysdate
98: and (nvl(fnd.end_date, sysdate+1) > sysdate or
99: to_char(fnd.END_DATE) = to_char(FND_API.G_MISS_DATE))
100: and upper(per.email_address) = p_requester_email
101:
102: union
103:

Line 129: x_return_status := FND_API.G_RET_STS_SUCCESS;

125: begin
126:
127: -- initialize return parameters
128: x_email := p_requester_email;
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130:
131: if p_requester_email is not NULL then
132: for i in C_user loop
133: x_user_name := i.user_name;

Line 146: RAISE FND_API.G_EXC_ERROR;

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:
149: if user_count > 1 then
150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 155: RAISE FND_API.G_EXC_ERROR;

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:
158: -- check if this user is a valid user in wf_user
159: if x_user_name is not NULL and l_wf_user_name is not NULL then

Line 215: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));

211: select email_address, customer_id, employee_id
212: from fnd_user
213: where user_name = l_user_name
214: and (nvl(end_date, sysdate + 1) > sysdate or
215: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
216:
217: cursor c_employee(p_employee_id in number) is
218: select email_address
219: from per_all_people_f

Line 262: x_return_status := FND_API.G_RET_STS_SUCCESS;

258: -- initialize return parameters
259: x_user := p_requester_user_name;
260: -- wf_user_name is different only if we find the email address in hz
261: l_wf_user_name := p_requester_user_name;
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263:
264: if p_requester_user_name is not NULL then
265: -- check to see if email available in fnd_user
266: open c_user(p_requester_user_name);

Line 276: RAISE FND_API.G_EXC_ERROR;

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;
278: close c_user;
279:
280: -- validate the input email.

Line 344: RAISE FND_API.G_EXC_ERROR;

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;
346:
347: -- check to see if wf_user has this user name
348: -- the reason for this check - a valid user, email combination may still

Line 405: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));

401: select user_name
402: from fnd_user
403: where upper(email_address) = p_requester_email
404: and (nvl(end_date, sysdate + 1) > sysdate or
405: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
406:
407: cursor c_employee is
408: select fnd.user_name
409: from fnd_user fnd, per_all_people_f per

Line 413: to_char(fnd.END_DATE) = to_char(FND_API.G_MISS_DATE))

409: from fnd_user fnd, per_all_people_f per
410: where per.person_id = fnd.employee_id
411: and per.effective_end_date > sysdate
412: and (nvl(fnd.end_date, sysdate+1) > sysdate or
413: to_char(fnd.END_DATE) = to_char(FND_API.G_MISS_DATE))
414: and upper(per.email_address) = p_requester_email;
415:
416: cursor c_party is
417: select fnd.user_name

Line 429: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));

425: select user_name
426: from fnd_user
427: where customer_id = l_party_id
428: and (nvl(end_date, sysdate+1) > sysdate or
429: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
430:
431: cursor c_wf_user(l_user_name in varchar2, l_email in varchar2) is
432: select name
433: from wf_users

Line 446: x_return_status := FND_API.G_RET_STS_SUCCESS;

442: begin
443:
444: -- initialize return parameters
445: x_email := p_requester_email;
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447:
448: if p_requester_email is not NULL then
449:
450: -- get the user name from fnd_user

Line 481: RAISE FND_API.G_EXC_ERROR;

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:
484: -- check if this user is a valid user in wf_user
485: if x_user_name is not NULL and l_wf_user_name is not NULL then

Line 543: p_init_msg_list in varchar2 := FND_API.G_FALSE,

539: * and contact_point = x_requester_email_Address
540: *
541: */
542: procedure get_wf_user(p_api_version_number in number,
543: p_init_msg_list in varchar2 := FND_API.G_FALSE,
544: p_commit in varchar2 := FND_API.G_FALSE,
545: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
546: x_requester_user_name in out NOCOPY varchar2,
547: x_requester_email in out NOCOPY varchar2,

Line 544: p_commit in varchar2 := FND_API.G_FALSE,

540: *
541: */
542: procedure get_wf_user(p_api_version_number in number,
543: p_init_msg_list in varchar2 := FND_API.G_FALSE,
544: p_commit in varchar2 := FND_API.G_FALSE,
545: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
546: x_requester_user_name in out NOCOPY varchar2,
547: x_requester_email in out NOCOPY varchar2,
548: x_wf_user out NOCOPY varchar2,

Line 545: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,

541: */
542: procedure get_wf_user(p_api_version_number in number,
543: p_init_msg_list in varchar2 := FND_API.G_FALSE,
544: p_commit in varchar2 := FND_API.G_FALSE,
545: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
546: x_requester_user_name in out NOCOPY varchar2,
547: x_requester_email in out NOCOPY varchar2,
548: x_wf_user out NOCOPY varchar2,
549: x_return_status out NOCOPY varchar2,

Line 579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

575: -- Standard Start of API savepoint
576: SAVEPOINT get_wf_user;
577:
578: -- Standard call to check for call compatibility.
579: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
580: p_api_version_number,
581: l_api_name,
582: G_PKG_NAME)
583: THEN

Line 584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

580: p_api_version_number,
581: l_api_name,
582: G_PKG_NAME)
583: THEN
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585: END IF;
586:
587:
588: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 589: IF FND_API.to_Boolean( p_init_msg_list ) THEN

585: END IF;
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

Line 594: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
595:
596: --
597: -- API body
598: --

Line 610: RAISE FND_API.G_EXC_ERROR;

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:
613:
614: -- default the email address if user name is not NULL

Line 625: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

621: x_email => x_requester_email,
622: x_wf_user_name => x_wf_user,
623: x_return_Status => x_return_status);
624: end if;
625: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
626: RAISE FND_API.G_EXC_ERROR;
627: end if;
628:
629: -- default the user if email is not NULL

Line 626: RAISE FND_API.G_EXC_ERROR;

622: x_wf_user_name => x_wf_user,
623: x_return_Status => x_return_status);
624: end if;
625: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
626: RAISE FND_API.G_EXC_ERROR;
627: end if;
628:
629: -- default the user if email is not NULL
630:

Line 638: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

634: x_email => x_requester_email,
635: x_wf_user_name => x_wf_user,
636: x_return_Status => x_return_status);
637: end if;
638: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
639: RAISE FND_API.G_EXC_ERROR;
640: end if;
641:
642: --

Line 639: RAISE FND_API.G_EXC_ERROR;

635: x_wf_user_name => x_wf_user,
636: x_return_Status => x_return_status);
637: end if;
638: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
639: RAISE FND_API.G_EXC_ERROR;
640: end if;
641:
642: --
643: -- End of API body

Line 647: IF FND_API.to_Boolean( p_commit )

643: -- End of API body
644: --
645:
646: -- Standard check for p_commit
647: IF FND_API.to_Boolean( p_commit )
648: THEN
649: COMMIT WORK;
650: END IF;
651:

Line 663: WHEN FND_API.G_EXC_ERROR THEN

659: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
660: --
661:
662: EXCEPTION
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

Line 674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

670: ,X_MSG_COUNT => X_MSG_COUNT
671: ,X_MSG_DATA => X_MSG_DATA
672: ,X_RETURN_STATUS => X_RETURN_STATUS);
673:
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

Line 768: p_init_msg_list in varchar2 default FND_API.G_FALSE,

764: * Errors :
765: * Other Comments :
766: */
767: PROCEDURE GetAdHocUser (p_api_version_number in number,
768: p_init_msg_list in varchar2 default FND_API.G_FALSE,
769: p_commit in varchar2 default FND_API.G_FALSE,
770: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
771: p_username in varchar2,
772: p_display_name in varchar2 default null,

Line 769: p_commit in varchar2 default FND_API.G_FALSE,

765: * Other Comments :
766: */
767: PROCEDURE GetAdHocUser (p_api_version_number in number,
768: p_init_msg_list in varchar2 default FND_API.G_FALSE,
769: p_commit in varchar2 default FND_API.G_FALSE,
770: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
771: p_username in varchar2,
772: p_display_name in varchar2 default null,
773: p_language in varchar2 default null,

Line 770: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,

766: */
767: PROCEDURE GetAdHocUser (p_api_version_number in number,
768: p_init_msg_list in varchar2 default FND_API.G_FALSE,
769: p_commit in varchar2 default FND_API.G_FALSE,
770: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
771: p_username in varchar2,
772: p_display_name in varchar2 default null,
773: p_language in varchar2 default null,
774: p_territory in varchar2 default null,

Line 797: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

793: -- Write to debug log
794: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');
795:
796: -- Standard call to check for call compatibility.
797: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
798: p_api_version_number,
799: l_api_name,
800: G_PKG_NAME)
801: THEN

Line 802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

798: p_api_version_number,
799: l_api_name,
800: G_PKG_NAME)
801: THEN
802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
803: END IF;
804:
805: -- call the user hook if it is a public api. Private APIs do not require a user hook call.
806:

Line 811: IF FND_API.to_Boolean (p_init_msg_list) THEN

807: -- Standard Start of API savepoint
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

Line 816: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 828: RAISE FND_API.G_EXC_ERROR;

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:
831: IF (p_email_address is null) THEN
832: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 837: RAISE FND_API.G_EXC_ERROR;

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:
840: IF (p_display_name is null) THEN
841: l_display_name := p_username;

Line 873: IF FND_API.to_Boolean (p_commit) THEN

869: -- End of API body
870: --
871:
872: -- Standard check for p_commit
873: IF FND_API.to_Boolean (p_commit) THEN
874: COMMIT WORK;
875: END IF;
876:
877: -- Standard call to get message count and if count is 1, get message info.

Line 887: WHEN FND_API.G_EXC_ERROR THEN

883: -- Write to debug log
884: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
885:
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,

Line 897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

893: X_MSG_COUNT => X_MSG_COUNT,
894: X_MSG_DATA => X_MSG_DATA,
895: X_RETURN_STATUS => X_RETURN_STATUS);
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,

Line 1023: p_init_msg_list in varchar2 default FND_API.G_FALSE,

1019: * Errors : possible errors raised by this API
1020: * Other Comments :
1021: */
1022: PROCEDURE EMAIL_NOTIFICATION (p_api_version_number in number,
1023: p_init_msg_list in varchar2 default FND_API.G_FALSE,
1024: p_commit in varchar2 default FND_API.G_FALSE,
1025: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
1026: p_username in varchar2 default null,
1027: p_email_address in varchar2 default null,

Line 1024: p_commit in varchar2 default FND_API.G_FALSE,

1020: * Other Comments :
1021: */
1022: PROCEDURE EMAIL_NOTIFICATION (p_api_version_number in number,
1023: p_init_msg_list in varchar2 default FND_API.G_FALSE,
1024: p_commit in varchar2 default FND_API.G_FALSE,
1025: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
1026: p_username in varchar2 default null,
1027: p_email_address in varchar2 default null,
1028: p_subject in varchar2,

Line 1025: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,

1021: */
1022: PROCEDURE EMAIL_NOTIFICATION (p_api_version_number in number,
1023: p_init_msg_list in varchar2 default FND_API.G_FALSE,
1024: p_commit in varchar2 default FND_API.G_FALSE,
1025: p_validation_level in number default FND_API.G_VALID_LEVEL_FULL,
1026: p_username in varchar2 default null,
1027: p_email_address in varchar2 default null,
1028: p_subject in varchar2,
1029: p_text_body in varchar2,

Line 1048: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1044: -- Write to debug log
1045: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');
1046:
1047: -- Standard call to check for call compatibility.
1048: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1049: p_api_version_number,
1050: l_api_name,
1051: G_PKG_NAME)
1052: THEN

Line 1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1049: p_api_version_number,
1050: l_api_name,
1051: G_PKG_NAME)
1052: THEN
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054: END IF;
1055:
1056: -- call the user hook if it is a public api. Private APIs do not require a user hook call.
1057:

Line 1062: IF FND_API.to_Boolean (p_init_msg_list) THEN

1058: -- Standard Start of API savepoint
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

Line 1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
1068:
1069: --
1070: -- Beginning of API body
1071: --

Line 1081: RAISE FND_API.G_EXC_ERROR;

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

Line 1100: RAISE FND_API.G_EXC_ERROR;

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:
1103: -- Call GET_WF_USER to get the username, email, and username in the
1104: -- wf_user table.

Line 1113: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1109: x_return_status => x_return_status,
1110: x_msg_count => x_msg_count,
1111: x_msg_data => x_msg_data);
1112:
1113: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1114: RAISE FND_API.G_EXC_ERROR;
1115: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: x_msg_count => x_msg_count,
1111: x_msg_data => x_msg_data);
1112:
1113: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1114: RAISE FND_API.G_EXC_ERROR;
1115: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;
1118:

Line 1115: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1111: x_msg_data => x_msg_data);
1112:
1113: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1114: RAISE FND_API.G_EXC_ERROR;
1115: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;
1118:
1119: IF (l_wf_username is null) THEN

Line 1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1112:
1113: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1114: RAISE FND_API.G_EXC_ERROR;
1115: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;
1118:
1119: IF (l_wf_username is null) THEN
1120: -- We need to send out workflow twice. One to the l_username and

Line 1147: IF FND_API.to_Boolean (p_commit) THEN

1143: -- End of API body
1144: --
1145:
1146: -- Standard check for p_commit
1147: IF FND_API.to_Boolean (p_commit) THEN
1148: COMMIT WORK;
1149: END IF;
1150:
1151: -- Standard call to get message count and if count is 1, get message info.

Line 1161: WHEN FND_API.G_EXC_ERROR THEN

1157: -- Write to debug log
1158: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
1159:
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,

Line 1171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1167: X_MSG_COUNT => X_MSG_COUNT,
1168: X_MSG_DATA => X_MSG_DATA,
1169: X_RETURN_STATUS => X_RETURN_STATUS);
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,

Line 1444: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));

1440: function VALIDATE_USER_ID(p_user_id number) return boolean is
1441:
1442: cursor find_user_id is select user_id from fnd_user where
1443: user_id = p_user_id and (nvl(end_date, sysdate+1) > sysdate or
1444: to_char(END_DATE) = to_char(FND_API.G_MISS_DATE));
1445:
1446: l_procedure_name CONSTANT varchar2(30) := 'VALIDATE_USER_ID';
1447: l_dummy_value number;
1448:

Line 1932: /* function to get the constant FND_API.G_MISS_DATE and use it in sql*/

1928:
1929: end validate_user_name_in_use;
1930:
1931:
1932: /* function to get the constant FND_API.G_MISS_DATE and use it in sql*/
1933: FUNCTION GET_G_MISS_DATE return DATE
1934: is
1935: BEGIN
1936: return FND_API.G_MISS_DATE;

Line 1936: return FND_API.G_MISS_DATE;

1932: /* function to get the constant FND_API.G_MISS_DATE and use it in sql*/
1933: FUNCTION GET_G_MISS_DATE return DATE
1934: is
1935: BEGIN
1936: return FND_API.G_MISS_DATE;
1937:
1938: END GET_G_MISS_DATE;
1939:
1940: