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 OZF_UTILITY_PVT

Line 54: OZF_Utility_PVT.debug_message(l_full_name||': start');

50:
51: --------------------- initialize -----------------------
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;

Line 75: OZF_Utility_PVT.debug_message(l_full_name ||': validate');

71: --------------------API CODE--------------------------
72:
73:
74: ----------------------- validate -----------------------
75: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
76: --dbms_output.put_line('the validation begins');
77:
78: validate_denorm_queries(
79: p_api_version => l_api_version,

Line 179: OZF_Utility_PVT.debug_message(l_full_name ||': end');

175: p_count => x_msg_count,
176: p_data => x_msg_data
177: );
178:
179: OZF_Utility_PVT.debug_message(l_full_name ||': end');
180:
181: EXCEPTION
182:
183: WHEN FND_API.g_exc_error THEN

Line 256: OZF_Utility_PVT.debug_message(l_full_name||': entered update');

252: l_return_status VARCHAR2(1);
253: l_stringArray stringArray;
254: BEGIN
255:
256: OZF_Utility_PVT.debug_message(l_full_name||': entered update');
257:
258: -------------------- initialize -------------------------
259: SAVEPOINT update_denorm_queries;
260:

Line 261: OZF_Utility_PVT.debug_message(l_full_name||': start');

257:
258: -------------------- initialize -------------------------
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;

Line 280: OZF_Utility_PVT.debug_message(l_full_name ||': validate');

276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:
278: ----------------------- validate ----------------------
279:
280: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
281: OZF_Utility_PVT.debug_message(l_denorm_queries_rec.denorm_query_id ||': validate1');
282:
283: -- replace g_miss_char/num/date with current column values
284:

Line 281: OZF_Utility_PVT.debug_message(l_denorm_queries_rec.denorm_query_id ||': validate1');

277:
278: ----------------------- validate ----------------------
279:
280: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
281: OZF_Utility_PVT.debug_message(l_denorm_queries_rec.denorm_query_id ||': validate1');
282:
283: -- replace g_miss_char/num/date with current column values
284:
285: complete_denorm_queries_rec(l_denorm_queries_rec, temp_denorm_queries_rec);

Line 352: OZF_Utility_PVT.debug_message(l_full_name ||': end');

348: p_count => x_msg_count,
349: p_data => x_msg_data
350: );
351:
352: OZF_Utility_PVT.debug_message(l_full_name ||': end');
353:
354: EXCEPTION
355:
356: WHEN FND_API.g_exc_error THEN

Line 425: OZF_Utility_PVT.debug_message(l_full_name||': start');

421:
422: --------------------- initialize -----------------------
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;

Line 444: OZF_Utility_PVT.debug_message(l_full_name ||': delete');

440: x_return_status := FND_API.G_RET_STS_SUCCESS;
441:
442:
443: ------------------------ delete ------------------------
444: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
445:
446: delete ozf_denorm_queries
447: WHERE denorm_query_id = p_denorm_query_id
448: AND OBJECT_VERSION_NUMBER=p_object_version;

Line 461: OZF_Utility_PVT.debug_message(l_full_name ||': end');

457: p_count => x_msg_count,
458: p_data => x_msg_data
459: );
460:
461: OZF_Utility_PVT.debug_message(l_full_name ||': end');
462:
463: EXCEPTION
464:
465: WHEN FND_API.g_exc_error THEN

Line 529: OZF_Utility_PVT.debug_message(l_full_name||': start');

525: l_mode varchar2(3):=p_validation_mode;
526: BEGIN
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;

Line 547: OZF_Utility_PVT.debug_message(l_full_name||': check items');

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:
549: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
550: check_denorm_queries_items(
551: p_denorm_queries_rec => p_denorm_queries_rec,

Line 562: OZF_Utility_PVT.debug_message(l_full_name||': check record');

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');
563:
564:
565:
566:

Line 574: OZF_Utility_PVT.debug_message(l_full_name ||': end');

570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );
573:
574: OZF_Utility_PVT.debug_message(l_full_name ||': end');
575:
576: EXCEPTION
577:
578: WHEN FND_API.g_exc_error THEN

Line 645: OZF_Utility_PVT.debug_message('This record already exists');

641: CLOSE chkexists;
642: X_RETURN_STATUS:='S';
643: ELSE
644: IF(l_denorm_query_id<>p_denorm_queries_rec.denorm_query_id)THEN
645: OZF_Utility_PVT.debug_message('This record already exists');
646: x_return_status:='E';
647: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');
648: FND_MSG_PUB.add;
649: END IF;

Line 750: OZF_Utility_PVT.debug_message('the sql formed is '||l_str);

746: l_str:=l_str||' '||' '||'WHERE'||' '||p_denorm_queries_rec.condition_name_column||'='''''||''||' ' ||'AND'||' '||' '||p_denorm_queries_rec.condition_id_column||'=1';
747: END IF;
748: END IF;
749: END IF;
750: OZF_Utility_PVT.debug_message('the sql formed is '||l_str);
751: --p_denorm_queries_rec.SQL_STATEMENT:=p_denorm_queries_rec.SQL_STATEMENT||''||'AND'||''||p_denorm_queries_rec.condition_id_column=1;
752: EXECUTE IMMEDIATE l_str;
753: END IF;
754: EXCEPTION

Line 783: OZF_UTILITY_PVT.debug_message('before req_items');

779:
780:
781:
782: -------------------------- Create or Update Mode ----------------------------
783: OZF_UTILITY_PVT.debug_message('before req_items');
784:
785: check_denorm_queries_req_items(
786: p_denorm_queries_rec => p_denorm_queries_rec,
787: x_return_status => x_return_status

Line 797: OZF_UTILITY_PVT.debug_message('THE MODE IS'||p_validation_mode);

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
799:
800: check_denorm_queries_record(
801: p_denorm_queries_rec => p_denorm_queries_rec,

Line 812: OZF_UTILITY_PVT.debug_message('before ok_items');

808: END IF;
809: END IF;
810: -------------------------- Update Mode ----------------------------
811:
812: OZF_UTILITY_PVT.debug_message('before ok_items');
813: IF p_validation_mode = 'UPD' THEN
814: check_denorm_queries_upd_items(
815: p_denorm_queries_rec => p_denorm_queries_rec,
816: x_return_status => x_return_status

Line 862: OZF_Utility_PVT.debug_message('This record already exists');

858: IF chkexists%NOTFOUND THEN
859: CLOSE chkexists;
860: X_RETURN_STATUS:='S';
861: ELSE
862: OZF_Utility_PVT.debug_message('This record already exists');
863: x_return_status:='E';
864: FND_MESSAGE.set_name('OZF', 'OZF_DENORM_QUERIES_EXISTS');
865: FND_MSG_PUB.add;
866: END IF;

Line 911: OZF_UTILITY_PVT.debug_message('complete_denorm_queries_rec :'|| p_denorm_queries_rec.denorm_query_id);

907:
908: l_denorm_queries_rec c_denorm_queries%ROWTYPE;
909:
910: BEGIN
911: OZF_UTILITY_PVT.debug_message('complete_denorm_queries_rec :'|| p_denorm_queries_rec.denorm_query_id);
912:
913: x_complete_rec := p_denorm_queries_rec;
914:
915: OPEN c_denorm_queries;