DBA Data[Home] [Help]

APPS.ECX_DOCUMENT_STANDARDS_API dependencies on ECX_DEBUG

Line 32: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');

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

Line 62: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',

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

Line 69: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_TOO_MANY_ROWS',

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

Line 109: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NULL');

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

Line 120: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DATA_SEEDED',

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:

Line 136: x_msg := ecx_debug.getTranslatedMessage('ECX_DATA_OWNER_INCONSISTENT',

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;

Line 148: x_msg := ecx_debug.getTranslatedMessage('ECX_DATA_OWNER_INCONSISTENT',

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;

Line 156: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_OWNER',

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;

Line 182: x_msg:=ecx_debug.getTranslatedMessage('ECX_DOCUMENT_STANDARD_EXISTS',

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

Line 190: x_msg :=ecx_debug.getTranslatedMessage('ECX_STANDARD_ROW_NOT_FOUND',

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

Line 228: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_NULL');

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

Line 236: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DATA_SEEDED',

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:

Line 249: x_msg := ecx_debug.getTranslatedMessage('ECX_DATA_OWNER_INCONSISTENT',

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;

Line 262: x_msg := ecx_debug.getTranslatedMessage('ECX_DATA_OWNER_INCONSISTENT',

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;

Line 270: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_OWNER',

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;

Line 285: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',

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:

Line 301: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',

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',

Line 337: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_ID_NOT_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:
341: -- make sure standard is not used in any code conversion or external process.

Line 355: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',

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',