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.ECX_DOCUMENT_STANDARDS_API dependencies on ECX_UTIL_API

Line 24: x_return_status := ECX_UTIL_API.G_NO_ERROR;

20: x_created_by pls_integer;
21: x_creation_date date;
22: l_standard_type varchar2(80);
23: begin
24: x_return_status := ECX_UTIL_API.G_NO_ERROR;
25: x_msg := null;
26: l_standard_type := x_standard_type;
27:
28: -- make sure p_standard_code is not null.

Line 31: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

27:
28: -- make sure p_standard_code is not null.
29: If (p_standard_code is null)
30: then
31: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
32: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
33: return;
34: elsif (l_standard_type is null)
35: then

Line 61: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

57: where standard_code = p_standard_code
58: and standard_type = l_standard_type;
59: exception
60: when no_data_found then
61: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
62: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
63: 'p_standard_code',
64: p_standard_code,
65: 'p_standard_type',

Line 68: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;

64: p_standard_code,
65: 'p_standard_type',
66: l_standard_type);
67: when too_many_rows then
68: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',
70: 'p_standard_code',
71: p_standard_code,
72: 'p_standard_type',

Line 76: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

72: 'p_standard_type',
73: l_standard_type);
74:
75: when others then
76: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
77: x_msg := substr(SQLERRM,1,200);
78: end retrieve_standard;
79:
80: /**

Line 100: x_return_status := ECX_UTIL_API.G_NO_ERROR;

96: i_rowid varchar2(2000);
97: l_standard_type varchar2(80);
98: begin
99:
100: x_return_status := ECX_UTIL_API.G_NO_ERROR;
101: x_standard_id :=-1;
102: x_msg := null;
103: l_standard_type := p_standard_type;
104:

Line 108: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

104:
105: -- make sure p_standard_code is not null.
106: If (p_standard_code is null)
107: then
108: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
109: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');
110: return;
111: elsIf (l_standard_type is null)
112: then

Line 117: If NOT ecx_util_api.validate_data_seeded_flag(p_data_seeded)

113: l_standard_type := 'XML';
114: end If;
115:
116: -- validate data seeded flag
117: If NOT ecx_util_api.validate_data_seeded_flag(p_data_seeded)
118: then
119: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
120: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DATA_SEEDED',
121: 'p_data_seeded', p_data_seeded);

Line 119: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

115:
116: -- validate data seeded flag
117: If NOT ecx_util_api.validate_data_seeded_flag(p_data_seeded)
118: then
119: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
120: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DATA_SEEDED',
121: 'p_data_seeded', p_data_seeded);
122: return;
123: end If;

Line 135: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

131: if p_data_seeded = 'Y'
132: then
133: i_last_updated_by :=1;
134: else
135: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
136: x_msg := ecx_debug.getTranslatedMessage('ECX_DATA_OWNER_INCONSISTENT',
137: 'p_data_seeded', p_data_seeded,
138: 'p_owner', p_owner);
139: return;

Line 147: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

143: if NOT (p_data_seeded = 'Y')
144: then
145: i_last_updated_by :=0;
146: else
147: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
148: x_msg := ecx_debug.getTranslatedMessage('ECX_DATA_OWNER_INCONSISTENT',
149: 'p_data_seeded', p_data_seeded,
150: 'p_owner', p_owner);
151:

Line 155: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

151:
152: return;
153: end if;
154: else
155: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
156: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_OWNER',
157: 'p_owner', p_owner);
158: return;
159:

Line 181: x_return_status := ECX_UTIL_API.G_DUP_ERROR;

177:
178:
179: exception
180: when dup_val_on_index then
181: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
182: x_msg:=ecx_debug.getTranslatedMessage('ECX_DOCUMENT_STANDARD_EXISTS',
183: 'p_standard_code',
184: p_standard_code,
185: 'p_standard_type',

Line 189: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

185: 'p_standard_type',
186: l_standard_type);
187:
188: when no_data_found then
189: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
190: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',
191: 'p_standard_code',
192: p_standard_code,
193: 'p_standard_type',

Line 197: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

193: 'p_standard_type',
194: l_standard_type);
195:
196: when others then
197: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
198: x_msg := substr(SQLERRM,1,200);
199:
200: end create_standard;
201:

Line 221: x_return_status := ECX_UTIL_API.G_NO_ERROR;

217: i_last_updated_by pls_integer;
218:
219: begin
220:
221: x_return_status := ECX_UTIL_API.G_NO_ERROR;
222: x_msg := null;
223:
224: -- make sure standard_id is not null.
225: If (p_standard_id is null)

Line 227: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

223:
224: -- make sure standard_id is not null.
225: If (p_standard_id is null)
226: then
227: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
228: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');
229: return;
230: end if;
231:

Line 233: If NOT ecx_util_api.validate_data_seeded_flag(p_data_seeded)

229: return;
230: end if;
231:
232: -- validate data seeded flag
233: If NOT ecx_util_api.validate_data_seeded_flag(p_data_seeded)
234: then
235: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
236: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DATA_SEEDED',
237: 'p_data_seeded', p_data_seeded);

Line 235: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

231:
232: -- validate data seeded flag
233: If NOT ecx_util_api.validate_data_seeded_flag(p_data_seeded)
234: then
235: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
236: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DATA_SEEDED',
237: 'p_data_seeded', p_data_seeded);
238: return;
239: end If;

Line 248: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

244: if p_data_seeded = 'Y'
245: then
246: i_last_updated_by :=1;
247: else
248: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
249: x_msg := ecx_debug.getTranslatedMessage('ECX_DATA_OWNER_INCONSISTENT',
250: 'p_data_seeded', p_data_seeded,
251: 'p_owner', p_owner);
252:

Line 261: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

257: if NOT (p_data_seeded = 'Y')
258: then
259: i_last_updated_by :=0;
260: else
261: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
262: x_msg := ecx_debug.getTranslatedMessage('ECX_DATA_OWNER_INCONSISTENT',
263: 'p_data_seeded', p_data_seeded,
264: 'p_owner', p_owner);
265:

Line 269: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

265:
266: return;
267: end if;
268: else
269: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
270: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_OWNER',
271: 'p_owner', p_owner);
272: return;
273:

Line 284: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

280: where standard_id = p_standard_id;
281:
282: if (sql%rowcount = 0)
283: then
284: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
285: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
286: 'p_table', 'ECX_STANDARDS_B', 'p_param_name', 'Document Standard ID','p_param_id',p_standard_id);
287: return;
288: end if;

Line 300: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

296: userenv('LANG') in (language, source_lang);
297:
298: if (sql%rowcount = 0)
299: then
300: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
301: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
302: 'p_table',
303: 'ECX_STANDARDS_TL',
304: 'p_param_name',

Line 314: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

310:
311:
312: exception
313: when others then
314: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
315: x_msg := substr(SQLERRM,1,200);
316: end update_standard;
317:
318: /**

Line 331: x_return_status := ECX_UTIL_API.G_NO_ERROR;

327: )
328: is
329: begin
330:
331: x_return_status := ECX_UTIL_API.G_NO_ERROR;
332: x_msg := null;
333:
334: if (p_standard_id is null)
335: then

Line 336: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

332: x_msg := null;
333:
334: if (p_standard_id is null)
335: then
336: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
337: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');
338: return;
339: end if;
340:

Line 354: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

350:
351: exception
352:
353: when no_data_found then
354: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
355: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
356: 'p_table',
357: 'ECX_STANDARDS',
358: 'p_param_name',

Line 363: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

359: 'Document Standard ID',
360: 'p_param_id',p_standard_id);
361:
362: when others then
363: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
364: x_msg := substr(SQLERRM,1,200);
365: end delete_standard;
366:
367: END ECX_DOCUMENT_STANDARDS_API;