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.EDR_GENERAL_SUBS dependencies on WF_LOG_PKG

Line 71: wf_log_pkg.string(6, 'UPLOAD_XSL','event name '||l_event_name);

67: l_kilo := 1000;
68: l_offset := 1;
69: --Bug 4074173 : end
70:
71: wf_log_pkg.string(6, 'UPLOAD_XSL','event name '||l_event_name);
72: wf_log_pkg.string(6, 'UPLOAD_XSL','event key '||l_event_key);
73:
74: --start with checking that the file is a stylesheet
75: EDR_FILE_UTIL_PUB.GET_FILE_NAME(l_event_key, l_file_name);

Line 72: wf_log_pkg.string(6, 'UPLOAD_XSL','event key '||l_event_key);

68: l_offset := 1;
69: --Bug 4074173 : end
70:
71: wf_log_pkg.string(6, 'UPLOAD_XSL','event name '||l_event_name);
72: wf_log_pkg.string(6, 'UPLOAD_XSL','event key '||l_event_key);
73:
74: --start with checking that the file is a stylesheet
75: EDR_FILE_UTIL_PUB.GET_FILE_NAME(l_event_key, l_file_name);
76: wf_log_pkg.string(6, 'UPLOAD_XSL','file name'||l_file_name);

Line 76: wf_log_pkg.string(6, 'UPLOAD_XSL','file name'||l_file_name);

72: wf_log_pkg.string(6, 'UPLOAD_XSL','event key '||l_event_key);
73:
74: --start with checking that the file is a stylesheet
75: EDR_FILE_UTIL_PUB.GET_FILE_NAME(l_event_key, l_file_name);
76: wf_log_pkg.string(6, 'UPLOAD_XSL','file name'||l_file_name);
77:
78: --Locate beginning of the extension in the file name string to use
79: --position to split up the file name
80: l_extension := NULL;

Line 87: wf_log_pkg.string(6, 'UPLOAD_XSL','extension '||l_extension);

83: IF l_pos <> 0 THEN
84: l_extension := SUBSTR(l_file_name,l_pos+1,LENGTH(l_file_name));
85: END IF;
86:
87: wf_log_pkg.string(6, 'UPLOAD_XSL','extension '||l_extension);
88:
89: --only if the extension of the file is xsl proceed further
90: if (UPPER(l_extension) = G_XSL_EXTENSION) then
91: --get the category of the file

Line 93: wf_log_pkg.string(6, 'UPLOAD_XSL','category name '||l_category_name);

89: --only if the extension of the file is xsl proceed further
90: if (UPPER(l_extension) = G_XSL_EXTENSION) then
91: --get the category of the file
92: EDR_FILE_UTIL_PUB.GET_CATEGORY_NAME(l_event_key, l_category_name);
93: wf_log_pkg.string(6, 'UPLOAD_XSL','category name '||l_category_name);
94:
95: --Bug # 3170251 : check if category is either G_XSL_CATEGORY OR G_TMP_CATEGORY
96:
97: if ((l_category_name = G_XSL_CATEGORY) OR (l_category_name = G_TMP_CATEGORY)) then

Line 98: wf_log_pkg.string(6, 'UPLOAD_XSL','xsl category name found');

94:
95: --Bug # 3170251 : check if category is either G_XSL_CATEGORY OR G_TMP_CATEGORY
96:
97: if ((l_category_name = G_XSL_CATEGORY) OR (l_category_name = G_TMP_CATEGORY)) then
98: wf_log_pkg.string(6, 'UPLOAD_XSL','xsl category name found');
99: l_return_status := G_YES;
100: end if;
101: --Bug # 3170251 : End
102:

Line 108: wf_log_pkg.string(6, 'UPLOAD_XSL','return status is yes...starting upload');

104:
105: --now that we have made certain that the file extension is xsl and the category
106: --is stylesheet go ahead and try to upload it
107: if (l_return_status = G_YES) then
108: wf_log_pkg.string(6, 'UPLOAD_XSL','return status is yes...starting upload');
109:
110: --set the file author
111: EDR_FILE_UTIL_PUB.GET_AUTHOR_NAME(l_event_key, l_author);
112: wf_log_pkg.string(6, 'UPLOAD_XSL','author '||l_author);

Line 112: wf_log_pkg.string(6, 'UPLOAD_XSL','author '||l_author);

108: wf_log_pkg.string(6, 'UPLOAD_XSL','return status is yes...starting upload');
109:
110: --set the file author
111: EDR_FILE_UTIL_PUB.GET_AUTHOR_NAME(l_event_key, l_author);
112: wf_log_pkg.string(6, 'UPLOAD_XSL','author '||l_author);
113: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'AUTHOR', l_author);
114: wf_log_pkg.string(6, 'UPLOAD_XSL','author name set in the workflow');
115:
116: --set the file name

Line 114: wf_log_pkg.string(6, 'UPLOAD_XSL','author name set in the workflow');

110: --set the file author
111: EDR_FILE_UTIL_PUB.GET_AUTHOR_NAME(l_event_key, l_author);
112: wf_log_pkg.string(6, 'UPLOAD_XSL','author '||l_author);
113: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'AUTHOR', l_author);
114: wf_log_pkg.string(6, 'UPLOAD_XSL','author name set in the workflow');
115:
116: --set the file name
117: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'XSL_NAME', l_file_name);
118: wf_log_pkg.string(6, 'UPLOAD_XSL','file name set in the workflow');

Line 118: wf_log_pkg.string(6, 'UPLOAD_XSL','file name set in the workflow');

114: wf_log_pkg.string(6, 'UPLOAD_XSL','author name set in the workflow');
115:
116: --set the file name
117: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'XSL_NAME', l_file_name);
118: wf_log_pkg.string(6, 'UPLOAD_XSL','file name set in the workflow');
119:
120: --set the version
121: EDR_FILE_UTIL_PUB.GET_VERSION_LABEL(l_event_key, l_version);
122: l_version_num := l_version;

Line 123: wf_log_pkg.string(6, 'UPLOAD_XSL','version num '||l_version_num);

119:
120: --set the version
121: EDR_FILE_UTIL_PUB.GET_VERSION_LABEL(l_event_key, l_version);
122: l_version_num := l_version;
123: wf_log_pkg.string(6, 'UPLOAD_XSL','version num '||l_version_num);
124: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'VERSION', l_version);
125:
126:
127: --set the product name of the file owner product

Line 129: wf_log_pkg.string(6, 'UPLOAD_XSL','PRODUCT ' ||l_product);

125:
126:
127: --set the product name of the file owner product
128: EDR_FILE_UTIL_PUB.GET_ATTRIBUTE(l_event_key, 'ATTRIBUTE1', l_product);
129: wf_log_pkg.string(6, 'UPLOAD_XSL','PRODUCT ' ||l_product);
130:
131: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'PRODUCT', l_product);
132:
133: --convert to lower case for upload to ecx repository

Line 137: wf_log_pkg.string(6, 'UPLOAD_XSL','event status' ||l_event_status);

133: --convert to lower case for upload to ecx repository
134: l_product := LOWER(l_product);
135:
136: l_event_status := wf_engine.getitemattrtext(p_itemtype,p_itemkey,'FILE_STATUS');
137: wf_log_pkg.string(6, 'UPLOAD_XSL','event status' ||l_event_status);
138:
139:
140: --if the status is SUCCESS only then upload it to the database
141: --Bug 3161353: Start

Line 147: wf_log_pkg.string(6, 'UPLOAD_XSL','file size: '||dbms_lob.getlength(l_file_data));

143: --if (l_event_status = 'SUCCESS') then
144: --Bug 3161353: End
145: EDR_FILE_UTIL_PUB.GET_FILE_DATA(l_event_key, l_file_data);
146:
147: wf_log_pkg.string(6, 'UPLOAD_XSL','file size: '||dbms_lob.getlength(l_file_data));
148:
149: --convert the blob data to clob
150: dbms_lob.createtemporary(l_file_data_c,TRUE);
151: l_data_length := dbms_lob.getlength(l_file_data);

Line 176: wf_log_pkg.string(6, 'UPLOAD_XSL','db version '||l_db_xsl_version);

172: where name = l_file_name;
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;

Line 183: wf_log_pkg.string(6, 'UPLOAD_XSL','version '||l_version);

179: end if;
180: end if;
181:
182: if (l_upload = 'TRUE') then
183: wf_log_pkg.string(6, 'UPLOAD_XSL','version '||l_version);
184:
185: --call ecx api to upload xsl
186: ECX_XSLT_UTILS.INS(i_filename => l_file_name,
187: i_version => l_version,