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
36: l_standard_type := 'XML';
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',
66: l_standard_type);
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',
73: l_standard_type);
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
113: l_standard_type := 'XML';
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;
124:
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;
140: end if;
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:
152: return;
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:
160: end if;
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',
186: l_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',
194: l_standard_type);
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:
232: -- validate data seeded flag
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;
240:
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:
253: return;
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:
266: return;
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:
274: end if;
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;
289:
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',
305: 'Document Standard ID',
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:
341: -- make sure standard is not used in any code conversion or external process.
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',
359: 'Document Standard ID',