DBA Data[Home] [Help]

APPS.UMX_PASSWORD_PVT dependencies on FND_LOG

Line 37: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

33: AND fu.user_name = p_user_name;
34:
35: begin
36:
37: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
38: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
39: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
40: 'p_user_name: ' || p_user_name);
41: end if;

Line 38: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

34:
35: begin
36:
37: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
38: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
39: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
40: 'p_user_name: ' || p_user_name);
41: end if;
42:

Line 70: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

66: end if;
67: close get_fnd_email;
68: end if;
69:
70: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
71: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
72: 'fnd.plsql.UMXVUPWB.get_email_address.end',
73: 'x_role_name: ' || x_role_name ||
74: ' | x_email_address: ' || x_email_address ||

Line 71: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

67: close get_fnd_email;
68: end if;
69:
70: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
71: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
72: 'fnd.plsql.UMXVUPWB.get_email_address.end',
73: 'x_role_name: ' || x_role_name ||
74: ' | x_email_address: ' || x_email_address ||
75: ' | x_message_name: ' || x_message_name ||

Line 92: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

88: l_user_name fnd_user.user_name%type;
89:
90: begin
91:
92: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
93: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
94: 'fnd.plsql.UMXVUPWB.get_username_from_userid.begin',
95: 'p_user_id: ' || p_user_id);
96: end if;

Line 93: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

89:
90: begin
91:
92: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
93: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
94: 'fnd.plsql.UMXVUPWB.get_username_from_userid.begin',
95: 'p_user_id: ' || p_user_id);
96: end if;
97:

Line 102: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then

98: open get_username_from_userid;
99: fetch get_username_from_userid into l_user_name;
100: if (get_username_from_userid%notfound) then
101: close get_username_from_userid;
102: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
103: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
104: 'fnd.plsql.UMXVUPWB.ForgotPwd',
105: 'Username cannot be found with userid (' || p_user_id || ')');
106: end if;

Line 103: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

99: fetch get_username_from_userid into l_user_name;
100: if (get_username_from_userid%notfound) then
101: close get_username_from_userid;
102: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
103: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
104: 'fnd.plsql.UMXVUPWB.ForgotPwd',
105: 'Username cannot be found with userid (' || p_user_id || ')');
106: end if;
107: fnd_message.set_name ('FND', 'UMX_COMMON_UNEXPECTED_ERR_MSG');

Line 112: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

108: raise_application_error ('-20000', fnd_message.get);
109: end if;
110: close get_username_from_userid;
111:
112: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
113: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
114: 'fnd.plsql.UMXVUPWB.get_username_from_userid.end',
115: 'l_user_name: ' || l_user_name);
116: end if;

Line 113: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

109: end if;
110: close get_username_from_userid;
111:
112: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
113: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
114: 'fnd.plsql.UMXVUPWB.get_username_from_userid.end',
115: 'l_user_name: ' || l_user_name);
116: end if;
117:

Line 143: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

139: x_message_data out NOCOPY varchar2) is
140:
141: BEGIN
142:
143: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
144: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
145: 'fnd.plsql.UMXVUPWB.validate_password.begin',
146: 'p_username: ' || p_username ||
147: ' | p_password: ' || p_password);

Line 144: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

140:
141: BEGIN
142:
143: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
144: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
145: 'fnd.plsql.UMXVUPWB.validate_password.begin',
146: 'p_username: ' || p_username ||
147: ' | p_password: ' || p_password);
148: end if;

Line 158: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

154: else
155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156: end if;
157:
158: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
160: 'fnd.plsql.UMXVUPWB.validate_password.end',
161: 'x_return_status: ' || x_return_status ||
162: ' | x_message_data: ' || x_message_data);

Line 159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

155: x_return_status := FND_API.G_RET_STS_SUCCESS;
156: end if;
157:
158: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
160: 'fnd.plsql.UMXVUPWB.validate_password.end',
161: 'x_return_status: ' || x_return_status ||
162: ' | x_message_data: ' || x_message_data);
163: end if;

Line 190: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

186: user_id number;
187:
188: begin
189:
190: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
191: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
192: 'fnd.plsql.UMXVUPWB.generate_password.begin', '');
193: end if;
194:

Line 191: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

187:
188: begin
189:
190: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
191: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
192: 'fnd.plsql.UMXVUPWB.generate_password.begin', '');
193: end if;
194:
195: -- initialize the random number generator

Line 210: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

206:
207: -- generate a random number to determine where to use an alphabet or a
208: -- numeric character for a given position in the password
209:
210: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
211: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
212: 'fnd.plsql.UMXVUPWB.generate_password',
213: 'l_password_len: ' || l_password_len);
214: end if;

Line 211: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

207: -- generate a random number to determine where to use an alphabet or a
208: -- numeric character for a given position in the password
209:
210: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
211: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
212: 'fnd.plsql.UMXVUPWB.generate_password',
213: 'l_password_len: ' || l_password_len);
214: end if;
215:

Line 230: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

226:
227: -- terminate the random number generator
228: --dbms_random.terminate;
229:
230: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
231: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
232: 'fnd.plsql.UMXVUPWB.generate_password.end',
233: 'x_password: ' || x_password);
234: end if;

Line 231: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

227: -- terminate the random number generator
228: --dbms_random.terminate;
229:
230: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
231: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
232: 'fnd.plsql.UMXVUPWB.generate_password.end',
233: 'x_password: ' || x_password);
234: end if;
235:

Line 248: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

244: v_counter BINARY_INTEGER := 1;
245:
246: begin
247:
248: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
249: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
250: 'fnd.plsql.UMXVUPWB.SetPassword.begin',
251: 'p_username: ' || p_username ||
252: ' | x_password: ' || x_password);

Line 249: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

245:
246: begin
247:
248: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
249: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
250: 'fnd.plsql.UMXVUPWB.SetPassword.begin',
251: 'p_username: ' || p_username ||
252: ' | x_password: ' || x_password);
253: end if;

Line 271: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then

267:
268: IF (( v_counter > 100 ) and ( l_result <> 'Y' )) THEN
269: -- Throw exception as even though generated password 100 times, but
270: -- cannot pass validation criteria
271: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
272: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
273: 'fnd.plsql.UMXVUPWB.ForgotPwd',
274: 'Could not generated password automatically which satisfies validation requirements.');
275: end if;

Line 272: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

268: IF (( v_counter > 100 ) and ( l_result <> 'Y' )) THEN
269: -- Throw exception as even though generated password 100 times, but
270: -- cannot pass validation criteria
271: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
272: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
273: 'fnd.plsql.UMXVUPWB.ForgotPwd',
274: 'Could not generated password automatically which satisfies validation requirements.');
275: end if;
276: fnd_message.set_name ('FND', 'UMX_COMMON_UNEXPECTED_ERR_MSG');

Line 284: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

280: -- end of code for validating username
281:
282: end if;
283:
284: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
285: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
286: 'fnd.plsql.UMXVUPWB.SetPassword.end',
287: 'x_password: ' || x_password);
288: end if;

Line 285: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

281:
282: end if;
283:
284: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
285: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
286: 'fnd.plsql.UMXVUPWB.SetPassword.end',
287: 'x_password: ' || x_password);
288: end if;
289:

Line 470: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

466: p_htmlagent in varchar2,
467: x_itemkey out nocopy varchar2) is
468: begin
469:
470: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
471: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
472: 'fnd.plsql.UMXVUPWB.start_workflow.begin',
473: 'p_user_name: ' || p_user_name ||
474: ' | p_email_address: ' || p_email_address ||

Line 471: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

467: x_itemkey out nocopy varchar2) is
468: begin
469:
470: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
471: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
472: 'fnd.plsql.UMXVUPWB.start_workflow.begin',
473: 'p_user_name: ' || p_user_name ||
474: ' | p_email_address: ' || p_email_address ||
475: ' | p_role_name: ' || p_role_name ||

Line 554: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

550:
551: wf_engine.StartProcess(itemtype => g_itemtype,
552: itemkey => x_itemkey);
553:
554: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
555: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
556: 'fnd.plsql.UMXVUPWB.start_workflow.end',
557: 'x_itemkey: ' || x_itemkey);
558: end if;

Line 555: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

551: wf_engine.StartProcess(itemtype => g_itemtype,
552: itemkey => x_itemkey);
553:
554: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
555: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
556: 'fnd.plsql.UMXVUPWB.start_workflow.end',
557: 'x_itemkey: ' || x_itemkey);
558: end if;
559: end start_workflow;

Line 586: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

582: l_nonExistentUser boolean := false;
583:
584: begin
585:
586: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
587: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
588: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.begin',
589: 'p_username: ' || p_username ||
590: ' | p_htmlagent: ' || p_htmlagent ||

Line 587: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

583:
584: begin
585:
586: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
587: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
588: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.begin',
589: 'p_username: ' || p_username ||
590: ' | p_htmlagent: ' || p_htmlagent ||
591: ' | p_password: ' || p_password ||

Line 670: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

666:
667: end if;
668: end if;
669:
670: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
671: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
672: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.end',
673: 'x_return_status: ' || x_return_status ||
674: ' | x_message_name: ' || x_message_name ||

Line 671: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

667: end if;
668: end if;
669:
670: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
671: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
672: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.end',
673: 'x_return_status: ' || x_return_status ||
674: ' | x_message_name: ' || x_message_name ||
675: ' | x_message_data: ' || x_message_data);

Line 701: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

697: x_message_name varchar2(80);
698:
699: begin
700:
701: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
702: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
703: 'fnd.plsql.UMXVUPWB.ResetPwd.begin',
704: 'p_username: ' || p_username ||
705: ' | p_htmlagent: ' || p_htmlagent ||

Line 702: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

698:
699: begin
700:
701: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
702: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
703: 'fnd.plsql.UMXVUPWB.ResetPwd.begin',
704: 'p_username: ' || p_username ||
705: ' | p_htmlagent: ' || p_htmlagent ||
706: ' | p_password: ' || p_password ||

Line 722: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

718: x_return_status => x_return_status,
719: x_message_name => x_message_name,
720: x_message_data => x_message_data);
721:
722: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
723: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
724: 'fnd.plsql.UMXVUPWB.ResetPwd.end',
725: 'x_return_status: ' || x_return_status ||
726: ' | x_message_data: ' || x_message_data);

Line 723: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

719: x_message_name => x_message_name,
720: x_message_data => x_message_data);
721:
722: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
723: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
724: 'fnd.plsql.UMXVUPWB.ResetPwd.end',
725: 'x_return_status: ' || x_return_status ||
726: ' | x_message_data: ' || x_message_data);
727: end if;

Line 741: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

737: x_message_name out NOCOPY varchar2,
738: x_message_data out NOCOPY varchar2) is
739: begin
740:
741: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
742: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
743: 'fnd.plsql.UMXVUPWB.ForgotPwd.begin',
744: 'p_username: ' || p_username ||
745: ' | p_htmlagent: ' || p_htmlagent ||

Line 742: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

738: x_message_data out NOCOPY varchar2) is
739: begin
740:
741: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
742: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
743: 'fnd.plsql.UMXVUPWB.ForgotPwd.begin',
744: 'p_username: ' || p_username ||
745: ' | p_htmlagent: ' || p_htmlagent ||
746: ' | p_user_appr_msg_name: ' || p_user_appr_msg_name ||

Line 761: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

757: x_return_status => x_return_status,
758: x_message_name => x_message_name,
759: x_message_data => x_message_data);
760:
761: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
762: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
763: 'fnd.plsql.UMXVUPWB.ForgotPwd.end',
764: 'x_return_status: ' || x_return_status ||
765: ' | x_message_name: ' || x_message_name ||

Line 762: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

758: x_message_name => x_message_name,
759: x_message_data => x_message_data);
760:
761: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
762: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
763: 'fnd.plsql.UMXVUPWB.ForgotPwd.end',
764: 'x_return_status: ' || x_return_status ||
765: ' | x_message_name: ' || x_message_name ||
766: ' | x_message_data: ' || x_message_data);