173:
174: if (l_db_xsl_version > 0) then
175: if (l_db_xsl_version >= l_version_num) then
176: wf_log_pkg.string(6, 'UPLOAD_XSL','db version '||l_db_xsl_version);
177: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_BAD_XSL_VERSION3');
178: l_upload := 'FALSE';
179: end if;
180: end if;
181:
190: i_retcode => l_xsl_ret_code,
191: i_retmsg => l_xsl_ret_msg);
192: if (l_xsl_ret_code = 0) then
193:
194: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_XSL_SUCCESS');
195: else
196: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_XSL_ECX_FAILURE')||l_xsl_ret_msg;
197: end if;
198:
192: if (l_xsl_ret_code = 0) then
193:
194: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_XSL_SUCCESS');
195: else
196: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_XSL_ECX_FAILURE')||l_xsl_ret_msg;
197: end if;
198:
199: end if;
200:
198:
199: end if;
200:
201: elsif (l_event_status = 'REJECTED') then
202: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_APPROVAL_REJECTION');
203: else
204: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_XSL_FAILURE');
205: end if;
206: end if;
200:
201: elsif (l_event_status = 'REJECTED') then
202: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_APPROVAL_REJECTION');
203: else
204: l_upload_status := fnd_message.get_string('EDR','EDR_FILES_XSL_FAILURE');
205: end if;
206: end if;
207:
208: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'UPLOAD_STATUS', l_upload_status);