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 EDR_FILE_UTIL_PUB

Line 75: EDR_FILE_UTIL_PUB.GET_FILE_NAME(l_event_key, l_file_name);

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);
77:
78: --Locate beginning of the extension in the file name string to use
79: --position to split up the file name

Line 92: EDR_FILE_UTIL_PUB.GET_CATEGORY_NAME(l_event_key, l_category_name);

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

Line 111: EDR_FILE_UTIL_PUB.GET_AUTHOR_NAME(l_event_key, l_author);

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

Line 121: EDR_FILE_UTIL_PUB.GET_VERSION_LABEL(l_event_key, l_version);

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

Line 128: EDR_FILE_UTIL_PUB.GET_ATTRIBUTE(l_event_key, 'ATTRIBUTE1', l_product);

124: wf_engine.setitemattrtext(p_itemtype, p_itemkey, 'VERSION', l_version);
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:

Line 145: EDR_FILE_UTIL_PUB.GET_FILE_DATA(l_event_key, l_file_data);

141: --Bug 3161353: Start
142: if (l_event_status = l_success_status OR l_event_status = l_no_approval_status) then
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