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.OZF_DENORM_QUERIES_PVT dependencies on FND_API

Line 16: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

12:
13: ---------------------------------------------------------------------
14: PROCEDURE create_denorm_queries(
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
17: p_commit IN VARCHAR2 := FND_API.g_false,
18: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
19:
20: p_denorm_queries_rec IN denorm_queries_rec_type,

Line 17: p_commit IN VARCHAR2 := FND_API.g_false,

13: ---------------------------------------------------------------------
14: PROCEDURE create_denorm_queries(
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
17: p_commit IN VARCHAR2 := FND_API.g_false,
18: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
19:
20: p_denorm_queries_rec IN denorm_queries_rec_type,
21:

Line 18: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

14: PROCEDURE create_denorm_queries(
15: p_api_version IN NUMBER,
16: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
17: p_commit IN VARCHAR2 := FND_API.g_false,
18: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
19:
20: p_denorm_queries_rec IN denorm_queries_rec_type,
21:
22: x_return_status OUT NOCOPY VARCHAR2,

Line 56: IF FND_API.to_boolean(p_init_msg_list) THEN

52: SAVEPOINT create_denorm_queries;
53:
54: OZF_Utility_PVT.debug_message(l_full_name||': start');
55:
56: IF FND_API.to_boolean(p_init_msg_list) THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59:
60: IF NOT FND_API.compatible_api_call(

Line 60: IF NOT FND_API.compatible_api_call(

56: IF FND_API.to_boolean(p_init_msg_list) THEN
57: FND_MSG_PUB.initialize;
58: END IF;
59:
60: IF NOT FND_API.compatible_api_call(
61: l_api_version,
62: p_api_version,
63: l_api_name,
64: g_pkg_name

Line 66: RAISE FND_API.g_exc_unexpected_error;

62: p_api_version,
63: l_api_name,
64: g_pkg_name
65: ) THEN
66: RAISE FND_API.g_exc_unexpected_error;
67: END IF;
68:
69: x_return_status := FND_API.g_ret_sts_success;
70:

Line 69: x_return_status := FND_API.g_ret_sts_success;

65: ) THEN
66: RAISE FND_API.g_exc_unexpected_error;
67: END IF;
68:
69: x_return_status := FND_API.g_ret_sts_success;
70:
71: --------------------API CODE--------------------------
72:
73:

Line 88: IF l_return_status = FND_API.g_ret_sts_error THEN

84: x_return_status => l_return_status,
85: x_msg_count => x_msg_count,
86: x_msg_data => x_msg_data
87: );
88: IF l_return_status = FND_API.g_ret_sts_error THEN
89: RAISE FND_API.g_exc_error;
90: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
91: RAISE FND_API.g_exc_unexpected_error;
92: END IF;

Line 89: RAISE FND_API.g_exc_error;

85: x_msg_count => x_msg_count,
86: x_msg_data => x_msg_data
87: );
88: IF l_return_status = FND_API.g_ret_sts_error THEN
89: RAISE FND_API.g_exc_error;
90: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
91: RAISE FND_API.g_exc_unexpected_error;
92: END IF;
93:

Line 90: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

86: x_msg_data => x_msg_data
87: );
88: IF l_return_status = FND_API.g_ret_sts_error THEN
89: RAISE FND_API.g_exc_error;
90: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
91: RAISE FND_API.g_exc_unexpected_error;
92: END IF;
93:
94: --dbms_output.put_line('the denorm query id beginning');

Line 91: RAISE FND_API.g_exc_unexpected_error;

87: );
88: IF l_return_status = FND_API.g_ret_sts_error THEN
89: RAISE FND_API.g_exc_error;
90: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
91: RAISE FND_API.g_exc_unexpected_error;
92: END IF;
93:
94: --dbms_output.put_line('the denorm query id beginning');
95: IF l_denorm_queries_rec.denorm_query_id IS NULL THEN

Line 169: IF FND_API.to_boolean(p_commit) THEN

165:
166: x_denorm_query_id := l_denorm_queries_rec.denorm_query_id;
167:
168:
169: IF FND_API.to_boolean(p_commit) THEN
170: COMMIT;
171: END IF;
172:
173: FND_MSG_PUB.count_and_get(

Line 174: p_encoded => FND_API.g_false,

170: COMMIT;
171: END IF;
172:
173: FND_MSG_PUB.count_and_get(
174: p_encoded => FND_API.g_false,
175: p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178:

Line 183: WHEN FND_API.g_exc_error THEN

179: OZF_Utility_PVT.debug_message(l_full_name ||': end');
180:
181: EXCEPTION
182:
183: WHEN FND_API.g_exc_error THEN
184: ROLLBACK TO create_denorm_queries;
185: x_return_status := FND_API.g_ret_sts_error;
186: FND_MSG_PUB.count_and_get(
187: p_encoded => FND_API.g_false,

Line 185: x_return_status := FND_API.g_ret_sts_error;

181: EXCEPTION
182:
183: WHEN FND_API.g_exc_error THEN
184: ROLLBACK TO create_denorm_queries;
185: x_return_status := FND_API.g_ret_sts_error;
186: FND_MSG_PUB.count_and_get(
187: p_encoded => FND_API.g_false,
188: p_count => x_msg_count,
189: p_data => x_msg_data

Line 187: p_encoded => FND_API.g_false,

183: WHEN FND_API.g_exc_error THEN
184: ROLLBACK TO create_denorm_queries;
185: x_return_status := FND_API.g_ret_sts_error;
186: FND_MSG_PUB.count_and_get(
187: p_encoded => FND_API.g_false,
188: p_count => x_msg_count,
189: p_data => x_msg_data
190: );
191:

Line 192: WHEN FND_API.g_exc_unexpected_error THEN

188: p_count => x_msg_count,
189: p_data => x_msg_data
190: );
191:
192: WHEN FND_API.g_exc_unexpected_error THEN
193: ROLLBACK TO create_denorm_queries;
194: x_return_status := FND_API.g_ret_sts_unexp_error ;
195: FND_MSG_PUB.count_and_get(
196: p_encoded => FND_API.g_false,

Line 194: x_return_status := FND_API.g_ret_sts_unexp_error ;

190: );
191:
192: WHEN FND_API.g_exc_unexpected_error THEN
193: ROLLBACK TO create_denorm_queries;
194: x_return_status := FND_API.g_ret_sts_unexp_error ;
195: FND_MSG_PUB.count_and_get(
196: p_encoded => FND_API.g_false,
197: p_count => x_msg_count,
198: p_data => x_msg_data

Line 196: p_encoded => FND_API.g_false,

192: WHEN FND_API.g_exc_unexpected_error THEN
193: ROLLBACK TO create_denorm_queries;
194: x_return_status := FND_API.g_ret_sts_unexp_error ;
195: FND_MSG_PUB.count_and_get(
196: p_encoded => FND_API.g_false,
197: p_count => x_msg_count,
198: p_data => x_msg_data
199: );
200:

Line 205: x_return_status := FND_API.g_ret_sts_unexp_error ;

201:
202: WHEN OTHERS THEN
203:
204: ROLLBACK TO create_denorm_queries;
205: x_return_status := FND_API.g_ret_sts_unexp_error ;
206:
207: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
208: THEN
209: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 213: p_encoded => FND_API.g_false,

209: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
210: END IF;
211:
212: FND_MSG_PUB.count_and_get(
213: p_encoded => FND_API.g_false,
214: p_count => x_msg_count,
215: p_data => x_msg_data
216: );
217:

Line 230: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

226:
227: ----------------------------------------------------------------------
228: PROCEDURE update_denorm_queries(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
231: p_commit IN VARCHAR2 := FND_API.g_false,
232: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
233:
234: p_denorm_queries_rec IN denorm_queries_rec_type,

Line 231: p_commit IN VARCHAR2 := FND_API.g_false,

227: ----------------------------------------------------------------------
228: PROCEDURE update_denorm_queries(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
231: p_commit IN VARCHAR2 := FND_API.g_false,
232: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
233:
234: p_denorm_queries_rec IN denorm_queries_rec_type,
235:

Line 232: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

228: PROCEDURE update_denorm_queries(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
231: p_commit IN VARCHAR2 := FND_API.g_false,
232: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
233:
234: p_denorm_queries_rec IN denorm_queries_rec_type,
235:
236: x_return_status OUT NOCOPY VARCHAR2,

Line 263: IF FND_API.to_boolean(p_init_msg_list) THEN

259: SAVEPOINT update_denorm_queries;
260:
261: OZF_Utility_PVT.debug_message(l_full_name||': start');
262:
263: IF FND_API.to_boolean(p_init_msg_list) THEN
264: FND_MSG_PUB.initialize;
265: END IF;
266:
267: IF NOT FND_API.compatible_api_call(

Line 267: IF NOT FND_API.compatible_api_call(

263: IF FND_API.to_boolean(p_init_msg_list) THEN
264: FND_MSG_PUB.initialize;
265: END IF;
266:
267: IF NOT FND_API.compatible_api_call(
268: l_api_version,
269: p_api_version,
270: l_api_name,
271: g_pkg_name

Line 273: RAISE FND_API.g_exc_unexpected_error;

269: p_api_version,
270: l_api_name,
271: g_pkg_name
272: ) THEN
273: RAISE FND_API.g_exc_unexpected_error;
274: END IF;
275:
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:

Line 276: x_return_status := FND_API.G_RET_STS_SUCCESS;

272: ) THEN
273: RAISE FND_API.g_exc_unexpected_error;
274: END IF;
275:
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: ----------------------- validate ----------------------
279:
280: OZF_Utility_PVT.debug_message(l_full_name ||': validate');

Line 297: IF l_return_status = FND_API.g_ret_sts_error THEN

293: x_return_status => l_return_status,
294: x_msg_count => x_msg_count,
295: x_msg_data => x_msg_data
296: );
297: IF l_return_status = FND_API.g_ret_sts_error THEN
298: RAISE FND_API.g_exc_error;
299: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
300: RAISE FND_API.g_exc_unexpected_error;
301: END IF;

Line 298: RAISE FND_API.g_exc_error;

294: x_msg_count => x_msg_count,
295: x_msg_data => x_msg_data
296: );
297: IF l_return_status = FND_API.g_ret_sts_error THEN
298: RAISE FND_API.g_exc_error;
299: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
300: RAISE FND_API.g_exc_unexpected_error;
301: END IF;
302:

Line 299: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

295: x_msg_data => x_msg_data
296: );
297: IF l_return_status = FND_API.g_ret_sts_error THEN
298: RAISE FND_API.g_exc_error;
299: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
300: RAISE FND_API.g_exc_unexpected_error;
301: END IF;
302:
303: string_length_check(temp_denorm_queries_rec.SQL_STATEMENT,l_stringArray);

Line 300: RAISE FND_API.g_exc_unexpected_error;

296: );
297: IF l_return_status = FND_API.g_ret_sts_error THEN
298: RAISE FND_API.g_exc_error;
299: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
300: RAISE FND_API.g_exc_unexpected_error;
301: END IF;
302:
303: string_length_check(temp_denorm_queries_rec.SQL_STATEMENT,l_stringArray);
304:

Line 335: RAISE FND_API.g_exc_error;

331: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
332: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
333: FND_MSG_PUB.add;
334: END IF;
335: RAISE FND_API.g_exc_error;
336: END IF;
337:
338:
339:

Line 342: IF FND_API.to_boolean(p_commit) THEN

338:
339:
340:
341: -------------------- finish --------------------------
342: IF FND_API.to_boolean(p_commit) THEN
343: COMMIT;
344: END IF;
345:
346: FND_MSG_PUB.count_and_get(

Line 347: p_encoded => FND_API.g_false,

343: COMMIT;
344: END IF;
345:
346: FND_MSG_PUB.count_and_get(
347: p_encoded => FND_API.g_false,
348: p_count => x_msg_count,
349: p_data => x_msg_data
350: );
351:

Line 356: WHEN FND_API.g_exc_error THEN

352: OZF_Utility_PVT.debug_message(l_full_name ||': end');
353:
354: EXCEPTION
355:
356: WHEN FND_API.g_exc_error THEN
357: ROLLBACK TO update_denorm_queries;
358: x_return_status := FND_API.g_ret_sts_error;
359: FND_MSG_PUB.count_and_get(
360: p_encoded => FND_API.g_false,

Line 358: x_return_status := FND_API.g_ret_sts_error;

354: EXCEPTION
355:
356: WHEN FND_API.g_exc_error THEN
357: ROLLBACK TO update_denorm_queries;
358: x_return_status := FND_API.g_ret_sts_error;
359: FND_MSG_PUB.count_and_get(
360: p_encoded => FND_API.g_false,
361: p_count => x_msg_count,
362: p_data => x_msg_data

Line 360: p_encoded => FND_API.g_false,

356: WHEN FND_API.g_exc_error THEN
357: ROLLBACK TO update_denorm_queries;
358: x_return_status := FND_API.g_ret_sts_error;
359: FND_MSG_PUB.count_and_get(
360: p_encoded => FND_API.g_false,
361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364:

Line 365: WHEN FND_API.g_exc_unexpected_error THEN

361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364:
365: WHEN FND_API.g_exc_unexpected_error THEN
366: ROLLBACK TO update_denorm_queries;
367: x_return_status := FND_API.g_ret_sts_unexp_error ;
368: FND_MSG_PUB.count_and_get(
369: p_encoded => FND_API.g_false,

Line 367: x_return_status := FND_API.g_ret_sts_unexp_error ;

363: );
364:
365: WHEN FND_API.g_exc_unexpected_error THEN
366: ROLLBACK TO update_denorm_queries;
367: x_return_status := FND_API.g_ret_sts_unexp_error ;
368: FND_MSG_PUB.count_and_get(
369: p_encoded => FND_API.g_false,
370: p_count => x_msg_count,
371: p_data => x_msg_data

Line 369: p_encoded => FND_API.g_false,

365: WHEN FND_API.g_exc_unexpected_error THEN
366: ROLLBACK TO update_denorm_queries;
367: x_return_status := FND_API.g_ret_sts_unexp_error ;
368: FND_MSG_PUB.count_and_get(
369: p_encoded => FND_API.g_false,
370: p_count => x_msg_count,
371: p_data => x_msg_data
372: );
373:

Line 378: x_return_status := FND_API.g_ret_sts_unexp_error ;

374: WHEN OTHERS THEN
375:
376:
377: ROLLBACK TO update_denorm_queries;
378: x_return_status := FND_API.g_ret_sts_unexp_error ;
379:
380: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
381: THEN
382: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 386: p_encoded => FND_API.g_false,

382: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
383: END IF;
384:
385: FND_MSG_PUB.count_and_get(
386: p_encoded => FND_API.g_false,
387: p_count => x_msg_count,
388: p_data => x_msg_data
389: );
390:

Line 402: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

398: -- PMOTHUKU Created.
399: ---------------------------------------------------------------
400: PROCEDURE delete_denorm_queries(
401: p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
403: p_commit IN VARCHAR2 := FND_API.g_false,
404:
405: p_denorm_query_id IN NUMBER,
406: p_object_version IN NUMBER,

Line 403: p_commit IN VARCHAR2 := FND_API.g_false,

399: ---------------------------------------------------------------
400: PROCEDURE delete_denorm_queries(
401: p_api_version IN NUMBER,
402: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
403: p_commit IN VARCHAR2 := FND_API.g_false,
404:
405: p_denorm_query_id IN NUMBER,
406: p_object_version IN NUMBER,
407:

Line 427: IF FND_API.to_boolean(p_init_msg_list) THEN

423: SAVEPOINT delete_denorm_queries;
424:
425: OZF_Utility_PVT.debug_message(l_full_name||': start');
426:
427: IF FND_API.to_boolean(p_init_msg_list) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: IF NOT FND_API.compatible_api_call(

Line 431: IF NOT FND_API.compatible_api_call(

427: IF FND_API.to_boolean(p_init_msg_list) THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:
431: IF NOT FND_API.compatible_api_call(
432: l_api_version,
433: p_api_version,
434: l_api_name,
435: g_pkg_name

Line 437: RAISE FND_API.g_exc_unexpected_error;

433: p_api_version,
434: l_api_name,
435: g_pkg_name
436: ) THEN
437: RAISE FND_API.g_exc_unexpected_error;
438: END IF;
439:
440: x_return_status := FND_API.G_RET_STS_SUCCESS;
441:

Line 440: x_return_status := FND_API.G_RET_STS_SUCCESS;

436: ) THEN
437: RAISE FND_API.g_exc_unexpected_error;
438: END IF;
439:
440: x_return_status := FND_API.G_RET_STS_SUCCESS;
441:
442:
443: ------------------------ delete ------------------------
444: OZF_Utility_PVT.debug_message(l_full_name ||': delete');

Line 451: IF FND_API.to_boolean(p_commit) THEN

447: WHERE denorm_query_id = p_denorm_query_id
448: AND OBJECT_VERSION_NUMBER=p_object_version;
449:
450: -------------------- finish --------------------------
451: IF FND_API.to_boolean(p_commit) THEN
452: COMMIT;
453: END IF;
454:
455: FND_MSG_PUB.count_and_get(

Line 456: p_encoded => FND_API.g_false,

452: COMMIT;
453: END IF;
454:
455: FND_MSG_PUB.count_and_get(
456: p_encoded => FND_API.g_false,
457: p_count => x_msg_count,
458: p_data => x_msg_data
459: );
460:

Line 465: WHEN FND_API.g_exc_error THEN

461: OZF_Utility_PVT.debug_message(l_full_name ||': end');
462:
463: EXCEPTION
464:
465: WHEN FND_API.g_exc_error THEN
466: ROLLBACK TO delete_denorm_queries;
467: x_return_status := FND_API.g_ret_sts_error;
468: FND_MSG_PUB.count_and_get(
469: p_encoded => FND_API.g_false,

Line 467: x_return_status := FND_API.g_ret_sts_error;

463: EXCEPTION
464:
465: WHEN FND_API.g_exc_error THEN
466: ROLLBACK TO delete_denorm_queries;
467: x_return_status := FND_API.g_ret_sts_error;
468: FND_MSG_PUB.count_and_get(
469: p_encoded => FND_API.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data

Line 469: p_encoded => FND_API.g_false,

465: WHEN FND_API.g_exc_error THEN
466: ROLLBACK TO delete_denorm_queries;
467: x_return_status := FND_API.g_ret_sts_error;
468: FND_MSG_PUB.count_and_get(
469: p_encoded => FND_API.g_false,
470: p_count => x_msg_count,
471: p_data => x_msg_data
472: );
473:

Line 474: WHEN FND_API.g_exc_unexpected_error THEN

470: p_count => x_msg_count,
471: p_data => x_msg_data
472: );
473:
474: WHEN FND_API.g_exc_unexpected_error THEN
475: ROLLBACK TO delete_denorm_queries;
476: x_return_status := FND_API.g_ret_sts_unexp_error ;
477: FND_MSG_PUB.count_and_get(
478: p_encoded => FND_API.g_false,

Line 476: x_return_status := FND_API.g_ret_sts_unexp_error ;

472: );
473:
474: WHEN FND_API.g_exc_unexpected_error THEN
475: ROLLBACK TO delete_denorm_queries;
476: x_return_status := FND_API.g_ret_sts_unexp_error ;
477: FND_MSG_PUB.count_and_get(
478: p_encoded => FND_API.g_false,
479: p_count => x_msg_count,
480: p_data => x_msg_data

Line 478: p_encoded => FND_API.g_false,

474: WHEN FND_API.g_exc_unexpected_error THEN
475: ROLLBACK TO delete_denorm_queries;
476: x_return_status := FND_API.g_ret_sts_unexp_error ;
477: FND_MSG_PUB.count_and_get(
478: p_encoded => FND_API.g_false,
479: p_count => x_msg_count,
480: p_data => x_msg_data
481: );
482:

Line 485: x_return_status := FND_API.g_ret_sts_unexp_error ;

481: );
482:
483: WHEN OTHERS THEN
484: ROLLBACK TO delete_denorm_queries;
485: x_return_status := FND_API.g_ret_sts_unexp_error ;
486:
487: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
488: THEN
489: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 493: p_encoded => FND_API.g_false,

489: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
490: END IF;
491:
492: FND_MSG_PUB.count_and_get(
493: p_encoded => FND_API.g_false,
494: p_count => x_msg_count,
495: p_data => x_msg_data
496: );
497:

Line 513: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

509: -- pmothuku Created.
510: --------------------------------------------------------------------
511: PROCEDURE validate_denorm_queries(
512: p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
514: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
515: p_validation_mode IN VARCHAR2,
516: p_denorm_queries_rec IN denorm_queries_rec_type,
517: x_return_status OUT NOCOPY VARCHAR2,

Line 514: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

510: --------------------------------------------------------------------
511: PROCEDURE validate_denorm_queries(
512: p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
514: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
515: p_validation_mode IN VARCHAR2,
516: p_denorm_queries_rec IN denorm_queries_rec_type,
517: x_return_status OUT NOCOPY VARCHAR2,
518: x_msg_count OUT NOCOPY NUMBER,

Line 531: IF FND_API.to_boolean(p_init_msg_list) THEN

527:
528: ----------------------- initialize --------------------
529: OZF_Utility_PVT.debug_message(l_full_name||': start');
530:
531: IF FND_API.to_boolean(p_init_msg_list) THEN
532: FND_MSG_PUB.initialize;
533: END IF;
534:
535: IF NOT FND_API.compatible_api_call(

Line 535: IF NOT FND_API.compatible_api_call(

531: IF FND_API.to_boolean(p_init_msg_list) THEN
532: FND_MSG_PUB.initialize;
533: END IF;
534:
535: IF NOT FND_API.compatible_api_call(
536: l_api_version,
537: p_api_version,
538: l_api_name,
539: g_pkg_name

Line 541: RAISE FND_API.g_exc_unexpected_error;

537: p_api_version,
538: l_api_name,
539: g_pkg_name
540: ) THEN
541: RAISE FND_API.g_exc_unexpected_error;
542: END IF;
543:
544: x_return_status := FND_API.g_ret_sts_success;
545:

Line 544: x_return_status := FND_API.g_ret_sts_success;

540: ) THEN
541: RAISE FND_API.g_exc_unexpected_error;
542: END IF;
543:
544: x_return_status := FND_API.g_ret_sts_success;
545:
546: ---------------------- validate ------------------------
547: OZF_Utility_PVT.debug_message(l_full_name||': check items');
548:

Line 555: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

551: p_denorm_queries_rec => p_denorm_queries_rec,
552: p_validation_mode => l_mode,
553: x_return_status => l_return_status
554: );
555: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
556: RAISE FND_API.g_exc_unexpected_error;
557: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
558: RAISE FND_API.g_exc_error;
559: END IF;

Line 556: RAISE FND_API.g_exc_unexpected_error;

552: p_validation_mode => l_mode,
553: x_return_status => l_return_status
554: );
555: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
556: RAISE FND_API.g_exc_unexpected_error;
557: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
558: RAISE FND_API.g_exc_error;
559: END IF;
560: END IF;

Line 557: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

553: x_return_status => l_return_status
554: );
555: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
556: RAISE FND_API.g_exc_unexpected_error;
557: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
558: RAISE FND_API.g_exc_error;
559: END IF;
560: END IF;
561:

Line 558: RAISE FND_API.g_exc_error;

554: );
555: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
556: RAISE FND_API.g_exc_unexpected_error;
557: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
558: RAISE FND_API.g_exc_error;
559: END IF;
560: END IF;
561:
562: OZF_Utility_PVT.debug_message(l_full_name||': check record');

Line 569: p_encoded => FND_API.g_false,

565:
566:
567: -------------------- finish --------------------------
568: FND_MSG_PUB.count_and_get(
569: p_encoded => FND_API.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );
573:

Line 578: WHEN FND_API.g_exc_error THEN

574: OZF_Utility_PVT.debug_message(l_full_name ||': end');
575:
576: EXCEPTION
577:
578: WHEN FND_API.g_exc_error THEN
579: x_return_status := FND_API.g_ret_sts_error;
580: FND_MSG_PUB.count_and_get(
581: p_encoded => FND_API.g_false,
582: p_count => x_msg_count,

Line 579: x_return_status := FND_API.g_ret_sts_error;

575:
576: EXCEPTION
577:
578: WHEN FND_API.g_exc_error THEN
579: x_return_status := FND_API.g_ret_sts_error;
580: FND_MSG_PUB.count_and_get(
581: p_encoded => FND_API.g_false,
582: p_count => x_msg_count,
583: p_data => x_msg_data

Line 581: p_encoded => FND_API.g_false,

577:
578: WHEN FND_API.g_exc_error THEN
579: x_return_status := FND_API.g_ret_sts_error;
580: FND_MSG_PUB.count_and_get(
581: p_encoded => FND_API.g_false,
582: p_count => x_msg_count,
583: p_data => x_msg_data
584: );
585:

Line 586: WHEN FND_API.g_exc_unexpected_error THEN

582: p_count => x_msg_count,
583: p_data => x_msg_data
584: );
585:
586: WHEN FND_API.g_exc_unexpected_error THEN
587: x_return_status := FND_API.g_ret_sts_unexp_error ;
588: FND_MSG_PUB.count_and_get(
589: p_encoded => FND_API.g_false,
590: p_count => x_msg_count,

Line 587: x_return_status := FND_API.g_ret_sts_unexp_error ;

583: p_data => x_msg_data
584: );
585:
586: WHEN FND_API.g_exc_unexpected_error THEN
587: x_return_status := FND_API.g_ret_sts_unexp_error ;
588: FND_MSG_PUB.count_and_get(
589: p_encoded => FND_API.g_false,
590: p_count => x_msg_count,
591: p_data => x_msg_data

Line 589: p_encoded => FND_API.g_false,

585:
586: WHEN FND_API.g_exc_unexpected_error THEN
587: x_return_status := FND_API.g_ret_sts_unexp_error ;
588: FND_MSG_PUB.count_and_get(
589: p_encoded => FND_API.g_false,
590: p_count => x_msg_count,
591: p_data => x_msg_data
592: );
593:

Line 595: x_return_status := FND_API.g_ret_sts_unexp_error;

591: p_data => x_msg_data
592: );
593:
594: WHEN OTHERS THEN
595: x_return_status := FND_API.g_ret_sts_unexp_error;
596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
597: THEN
598: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
599: END IF;

Line 602: p_encoded => FND_API.g_false,

598: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
599: END IF;
600:
601: FND_MSG_PUB.count_and_get(
602: p_encoded => FND_API.g_false,
603: p_count => x_msg_count,
604: p_data => x_msg_data
605: );
606:

Line 673: x_return_status := FND_API.g_ret_sts_success;

669:
670: l_str varchar2(32000);
671: BEGIN
672:
673: x_return_status := FND_API.g_ret_sts_success;
674: IF (p_denorm_queries_rec.query_for IS NULL OR p_denorm_queries_rec.query_for = FND_API.g_miss_char) THEN
675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
676: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUERY_FOR_TYPE');
677: FND_MSG_PUB.add;

Line 674: IF (p_denorm_queries_rec.query_for IS NULL OR p_denorm_queries_rec.query_for = FND_API.g_miss_char) THEN

670: l_str varchar2(32000);
671: BEGIN
672:
673: x_return_status := FND_API.g_ret_sts_success;
674: IF (p_denorm_queries_rec.query_for IS NULL OR p_denorm_queries_rec.query_for = FND_API.g_miss_char) THEN
675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
676: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUERY_FOR_TYPE');
677: FND_MSG_PUB.add;
678: END IF;

Line 679: x_return_status := FND_API.g_ret_sts_error;

675: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
676: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUERY_FOR_TYPE');
677: FND_MSG_PUB.add;
678: END IF;
679: x_return_status := FND_API.g_ret_sts_error;
680: RETURN;
681: END IF;
682: IF (p_denorm_queries_rec.context IS NULL OR p_denorm_queries_rec.context = FND_API.g_miss_char) THEN
683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 682: IF (p_denorm_queries_rec.context IS NULL OR p_denorm_queries_rec.context = FND_API.g_miss_char) THEN

678: END IF;
679: x_return_status := FND_API.g_ret_sts_error;
680: RETURN;
681: END IF;
682: IF (p_denorm_queries_rec.context IS NULL OR p_denorm_queries_rec.context = FND_API.g_miss_char) THEN
683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
684: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT');
685: FND_MSG_PUB.add;
686: END IF;

Line 687: x_return_status := FND_API.g_ret_sts_error;

683: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
684: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT');
685: FND_MSG_PUB.add;
686: END IF;
687: x_return_status := FND_API.g_ret_sts_error;
688: RETURN;
689: END IF;
690: ------------------------ qualifier_context_attribute --------------------------
691: IF (p_denorm_queries_rec.attribute IS NULL OR p_denorm_queries_rec.attribute = FND_API.g_miss_char) THEN

Line 691: IF (p_denorm_queries_rec.attribute IS NULL OR p_denorm_queries_rec.attribute = FND_API.g_miss_char) THEN

687: x_return_status := FND_API.g_ret_sts_error;
688: RETURN;
689: END IF;
690: ------------------------ qualifier_context_attribute --------------------------
691: IF (p_denorm_queries_rec.attribute IS NULL OR p_denorm_queries_rec.attribute = FND_API.g_miss_char) THEN
692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
693: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT_ATTR');
694: FND_MSG_PUB.add;
695: END IF;

Line 696: x_return_status := FND_API.g_ret_sts_error;

692: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
693: FND_MESSAGE.set_name('OZF', 'OZF_NO_QUALIFIER_CONTEXT_ATTR');
694: FND_MSG_PUB.add;
695: END IF;
696: x_return_status := FND_API.g_ret_sts_error;
697: RETURN;
698:
699:
700:

Line 705: IF (p_denorm_queries_rec.SQL_STATEMENT IS NULL ) OR (p_denorm_queries_rec.SQL_STATEMENT = FND_API.g_miss_char) THEN

701: END IF;
702:
703:
704:
705: IF (p_denorm_queries_rec.SQL_STATEMENT IS NULL ) OR (p_denorm_queries_rec.SQL_STATEMENT = FND_API.g_miss_char) THEN
706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
707: FND_MESSAGE.set_name('OZF', 'OZF_NO_SQLSTATEMENT');
708: FND_MSG_PUB.add;
709: END IF;

Line 710: x_return_status := FND_API.g_ret_sts_error;

706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
707: FND_MESSAGE.set_name('OZF', 'OZF_NO_SQLSTATEMENT');
708: FND_MSG_PUB.add;
709: END IF;
710: x_return_status := FND_API.g_ret_sts_error;
711: RETURN;
712: END IF;
713:
714: IF (((p_denorm_queries_rec.condition_id_column IS NULL ) OR (p_denorm_queries_rec.condition_id_column = FND_API.g_miss_char)) AND

Line 714: IF (((p_denorm_queries_rec.condition_id_column IS NULL ) OR (p_denorm_queries_rec.condition_id_column = FND_API.g_miss_char)) AND

710: x_return_status := FND_API.g_ret_sts_error;
711: RETURN;
712: END IF;
713:
714: IF (((p_denorm_queries_rec.condition_id_column IS NULL ) OR (p_denorm_queries_rec.condition_id_column = FND_API.g_miss_char)) AND
715: ((p_denorm_queries_rec.condition_name_column IS NULL ) OR (p_denorm_queries_rec.condition_name_column = FND_API.g_miss_char)))THEN
716:
717: EXECUTE IMMEDIATE p_denorm_queries_rec.SQL_STATEMENT;
718:

Line 715: ((p_denorm_queries_rec.condition_name_column IS NULL ) OR (p_denorm_queries_rec.condition_name_column = FND_API.g_miss_char)))THEN

711: RETURN;
712: END IF;
713:
714: IF (((p_denorm_queries_rec.condition_id_column IS NULL ) OR (p_denorm_queries_rec.condition_id_column = FND_API.g_miss_char)) AND
715: ((p_denorm_queries_rec.condition_name_column IS NULL ) OR (p_denorm_queries_rec.condition_name_column = FND_API.g_miss_char)))THEN
716:
717: EXECUTE IMMEDIATE p_denorm_queries_rec.SQL_STATEMENT;
718:
719: ELSE

Line 720: IF (((p_denorm_queries_rec.condition_id_column <> NULL ) OR (p_denorm_queries_rec.condition_id_column <> FND_API.g_miss_char)) AND

716:
717: EXECUTE IMMEDIATE p_denorm_queries_rec.SQL_STATEMENT;
718:
719: ELSE
720: IF (((p_denorm_queries_rec.condition_id_column <> NULL ) OR (p_denorm_queries_rec.condition_id_column <> FND_API.g_miss_char)) AND
721: ((p_denorm_queries_rec.condition_name_column IS NULL ) OR (p_denorm_queries_rec.condition_name_column = FND_API.g_miss_char)))
722: THEN
723: l_str :=upper(p_denorm_queries_rec.SQL_STATEMENT);
724: IF(INSTR(l_str,'WHERE',1,1)>0)THEN

Line 721: ((p_denorm_queries_rec.condition_name_column IS NULL ) OR (p_denorm_queries_rec.condition_name_column = FND_API.g_miss_char)))

717: EXECUTE IMMEDIATE p_denorm_queries_rec.SQL_STATEMENT;
718:
719: ELSE
720: IF (((p_denorm_queries_rec.condition_id_column <> NULL ) OR (p_denorm_queries_rec.condition_id_column <> FND_API.g_miss_char)) AND
721: ((p_denorm_queries_rec.condition_name_column IS NULL ) OR (p_denorm_queries_rec.condition_name_column = FND_API.g_miss_char)))
722: THEN
723: l_str :=upper(p_denorm_queries_rec.SQL_STATEMENT);
724: IF(INSTR(l_str,'WHERE',1,1)>0)THEN
725: l_str:=l_str||' '||' '||'AND'||' '||' '||p_denorm_queries_rec.condition_id_column||'=1';

Line 731: IF (((p_denorm_queries_rec.condition_name_column <> NULL ) OR (p_denorm_queries_rec.condition_name_column <> FND_API.g_miss_char)) AND

727: l_str:=l_str||' '||' '||'WHERE'||' '||p_denorm_queries_rec.condition_id_column||'=1';
728: END IF;
729:
730: ELSE
731: IF (((p_denorm_queries_rec.condition_name_column <> NULL ) OR (p_denorm_queries_rec.condition_name_column <> FND_API.g_miss_char)) AND
732: ((p_denorm_queries_rec.condition_id_column IS NULL ) OR (p_denorm_queries_rec.condition_id_column = FND_API.g_miss_char)))
733: THEN
734: l_str :=upper(p_denorm_queries_rec.SQL_STATEMENT);
735: IF(INSTR(l_str,'WHERE',1,1)>0)THEN

Line 732: ((p_denorm_queries_rec.condition_id_column IS NULL ) OR (p_denorm_queries_rec.condition_id_column = FND_API.g_miss_char)))

728: END IF;
729:
730: ELSE
731: IF (((p_denorm_queries_rec.condition_name_column <> NULL ) OR (p_denorm_queries_rec.condition_name_column <> FND_API.g_miss_char)) AND
732: ((p_denorm_queries_rec.condition_id_column IS NULL ) OR (p_denorm_queries_rec.condition_id_column = FND_API.g_miss_char)))
733: THEN
734: l_str :=upper(p_denorm_queries_rec.SQL_STATEMENT);
735: IF(INSTR(l_str,'WHERE',1,1)>0)THEN
736: l_str:=l_str||' '||' '||'AND'||' '||' '||p_denorm_queries_rec.condition_name_column||'=''''';

Line 756: x_return_status := FND_API.g_ret_sts_error;

752: EXECUTE IMMEDIATE l_str;
753: END IF;
754: EXCEPTION
755: when others then
756: x_return_status := FND_API.g_ret_sts_error;
757: FND_MESSAGE.set_name('OZF','OZF_NO_SQLSTATEMENT');
758: FND_MSG_PUB.add;
759: FND_MESSAGE.SET_NAME('OZF','OZF_API_DEBUG_MESSAGE');
760: FND_MESSAGE.SET_TOKEN('TEXT',SQLERRM);

Line 790: IF x_return_status <> FND_API.g_ret_sts_success THEN

786: p_denorm_queries_rec => p_denorm_queries_rec,
787: x_return_status => x_return_status
788: );
789:
790: IF x_return_status <> FND_API.g_ret_sts_success THEN
791: RETURN;
792: END IF;
793:
794: IF x_return_status <> FND_API.g_ret_sts_success THEN

Line 794: IF x_return_status <> FND_API.g_ret_sts_success THEN

790: IF x_return_status <> FND_API.g_ret_sts_success THEN
791: RETURN;
792: END IF;
793:
794: IF x_return_status <> FND_API.g_ret_sts_success THEN
795: RETURN;
796: END IF;
797: OZF_UTILITY_PVT.debug_message('THE MODE IS'||p_validation_mode);
798: IF p_validation_mode = 'CRE' THEN

Line 804: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN

800: check_denorm_queries_record(
801: p_denorm_queries_rec => p_denorm_queries_rec,
802: x_return_status => x_return_status
803: );
804: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
805: RAISE FND_API.g_exc_unexpected_error;
806: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
807: RAISE FND_API.g_exc_error;
808: END IF;

Line 805: RAISE FND_API.g_exc_unexpected_error;

801: p_denorm_queries_rec => p_denorm_queries_rec,
802: x_return_status => x_return_status
803: );
804: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
805: RAISE FND_API.g_exc_unexpected_error;
806: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
807: RAISE FND_API.g_exc_error;
808: END IF;
809: END IF;

Line 806: ELSIF x_return_status = FND_API.g_ret_sts_error THEN

802: x_return_status => x_return_status
803: );
804: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
805: RAISE FND_API.g_exc_unexpected_error;
806: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
807: RAISE FND_API.g_exc_error;
808: END IF;
809: END IF;
810: -------------------------- Update Mode ----------------------------

Line 807: RAISE FND_API.g_exc_error;

803: );
804: IF x_return_status = FND_API.g_ret_sts_unexp_error THEN
805: RAISE FND_API.g_exc_unexpected_error;
806: ELSIF x_return_status = FND_API.g_ret_sts_error THEN
807: RAISE FND_API.g_exc_error;
808: END IF;
809: END IF;
810: -------------------------- Update Mode ----------------------------
811:

Line 819: IF x_return_status <> FND_API.g_ret_sts_success THEN

815: p_denorm_queries_rec => p_denorm_queries_rec,
816: x_return_status => x_return_status
817: );
818:
819: IF x_return_status <> FND_API.g_ret_sts_success THEN
820: RETURN;
821: END IF;
822: END IF;
823:

Line 923: RAISE FND_API.g_exc_error;

919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
920: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
921: FND_MSG_PUB.add;
922: END IF;
923: RAISE FND_API.g_exc_error;
924: END IF;
925: CLOSE c_denorm_queries;
926:
927:

Line 928: IF p_denorm_queries_rec.query_for = FND_API.g_miss_char THEN

924: END IF;
925: CLOSE c_denorm_queries;
926:
927:
928: IF p_denorm_queries_rec.query_for = FND_API.g_miss_char THEN
929: x_complete_rec.query_for:= NULL;
930: END IF;
931: IF p_denorm_queries_rec.query_for IS NULL THEN
932: x_complete_rec.query_for:= l_denorm_queries_rec.query_for;

Line 935: IF p_denorm_queries_rec.creation_date = FND_API.g_miss_date THEN

931: IF p_denorm_queries_rec.query_for IS NULL THEN
932: x_complete_rec.query_for:= l_denorm_queries_rec.query_for;
933: END IF;
934:
935: IF p_denorm_queries_rec.creation_date = FND_API.g_miss_date THEN
936: x_complete_rec.creation_date:= NULL;
937: END IF;
938: IF p_denorm_queries_rec.creation_date IS NULL THEN
939: x_complete_rec.creation_date:= l_denorm_queries_rec.creation_date;

Line 941: IF p_denorm_queries_rec.created_by = FND_API.g_miss_num THEN

937: END IF;
938: IF p_denorm_queries_rec.creation_date IS NULL THEN
939: x_complete_rec.creation_date:= l_denorm_queries_rec.creation_date;
940: END IF;
941: IF p_denorm_queries_rec.created_by = FND_API.g_miss_num THEN
942: x_complete_rec.created_by := NULL;
943: END IF;
944: IF p_denorm_queries_rec.created_by IS NULL THEN
945: x_complete_rec.created_by := l_denorm_queries_rec.created_by;

Line 947: IF p_denorm_queries_rec.last_update_date = FND_API.g_miss_date THEN

943: END IF;
944: IF p_denorm_queries_rec.created_by IS NULL THEN
945: x_complete_rec.created_by := l_denorm_queries_rec.created_by;
946: END IF;
947: IF p_denorm_queries_rec.last_update_date = FND_API.g_miss_date THEN
948: x_complete_rec.last_update_date := NULL;
949: END IF;
950: IF p_denorm_queries_rec.last_update_date IS NULL THEN
951: x_complete_rec.last_update_date := l_denorm_queries_rec.last_update_date;

Line 953: IF p_denorm_queries_rec.last_updated_by = FND_API.g_miss_num THEN

949: END IF;
950: IF p_denorm_queries_rec.last_update_date IS NULL THEN
951: x_complete_rec.last_update_date := l_denorm_queries_rec.last_update_date;
952: END IF;
953: IF p_denorm_queries_rec.last_updated_by = FND_API.g_miss_num THEN
954: x_complete_rec.last_updated_by := NULL;
955: END IF;
956: IF p_denorm_queries_rec.last_updated_by IS NULL THEN
957: x_complete_rec.last_updated_by := l_denorm_queries_rec.last_updated_by;

Line 960: IF p_denorm_queries_rec.last_update_login = FND_API.g_miss_num THEN

956: IF p_denorm_queries_rec.last_updated_by IS NULL THEN
957: x_complete_rec.last_updated_by := l_denorm_queries_rec.last_updated_by;
958: END IF;
959:
960: IF p_denorm_queries_rec.last_update_login = FND_API.g_miss_num THEN
961: x_complete_rec.last_update_login := NULL;
962: END IF;
963: IF p_denorm_queries_rec.last_update_login IS NULL THEN
964: x_complete_rec.last_update_login := l_denorm_queries_rec.last_update_login;

Line 967: IF p_denorm_queries_rec.active_flag = FND_API.g_miss_char THEN

963: IF p_denorm_queries_rec.last_update_login IS NULL THEN
964: x_complete_rec.last_update_login := l_denorm_queries_rec.last_update_login;
965: END IF;
966:
967: IF p_denorm_queries_rec.active_flag = FND_API.g_miss_char THEN
968: x_complete_rec.active_flag := NULL;
969: END IF;
970: IF p_denorm_queries_rec.active_flag IS NULL THEN
971: x_complete_rec.active_flag := l_denorm_queries_rec.active_flag;

Line 974: IF p_denorm_queries_rec.context = fnd_api.g_miss_char then

970: IF p_denorm_queries_rec.active_flag IS NULL THEN
971: x_complete_rec.active_flag := l_denorm_queries_rec.active_flag;
972: END IF;
973:
974: IF p_denorm_queries_rec.context = fnd_api.g_miss_char then
975: x_complete_rec.context := NULL;
976: END IF;
977: IF p_denorm_queries_rec.context IS NULL then
978: x_complete_rec.context := l_denorm_queries_rec.context;

Line 981: IF p_denorm_queries_rec.attribute = FND_API.g_miss_char THEN

977: IF p_denorm_queries_rec.context IS NULL then
978: x_complete_rec.context := l_denorm_queries_rec.context;
979: END IF;
980:
981: IF p_denorm_queries_rec.attribute = FND_API.g_miss_char THEN
982: x_complete_rec.attribute := NULL;
983: END IF;
984: IF p_denorm_queries_rec.attribute IS NULL THEN
985: x_complete_rec.attribute := l_denorm_queries_rec.attribute;

Line 987: IF p_denorm_queries_rec.condition_name_column = fnd_api.g_miss_char then

983: END IF;
984: IF p_denorm_queries_rec.attribute IS NULL THEN
985: x_complete_rec.attribute := l_denorm_queries_rec.attribute;
986: END IF;
987: IF p_denorm_queries_rec.condition_name_column = fnd_api.g_miss_char then
988: x_complete_rec.condition_name_column := NULL;
989: END IF;
990: IF p_denorm_queries_rec.condition_name_column IS NULL then
991: x_complete_rec.condition_name_column := l_denorm_queries_rec.condition_name_column;

Line 994: IF p_denorm_queries_rec.condition_id_column = FND_API.g_miss_char THEN

990: IF p_denorm_queries_rec.condition_name_column IS NULL then
991: x_complete_rec.condition_name_column := l_denorm_queries_rec.condition_name_column;
992: END IF;
993:
994: IF p_denorm_queries_rec.condition_id_column = FND_API.g_miss_char THEN
995: x_complete_rec.condition_id_column:= NULL;
996: END IF;
997: IF p_denorm_queries_rec.condition_id_column IS NULL THEN
998: x_complete_rec.condition_id_column:= l_denorm_queries_rec.condition_id_column;

Line 1000: IF p_denorm_queries_rec.object_version_number = FND_API.g_miss_num THEN

996: END IF;
997: IF p_denorm_queries_rec.condition_id_column IS NULL THEN
998: x_complete_rec.condition_id_column:= l_denorm_queries_rec.condition_id_column;
999: END IF;
1000: IF p_denorm_queries_rec.object_version_number = FND_API.g_miss_num THEN
1001: x_complete_rec.object_version_number:= NULL;
1002: END IF;
1003: IF p_denorm_queries_rec.object_version_number IS NULL THEN
1004: x_complete_rec.object_version_number:= l_denorm_queries_rec.object_version_number;