DBA Data[Home] [Help]

APPS.OZF_SYS_PARAMETERS_PVT dependencies on OZF_UTILITY_PVT

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

127: --------------------- initialize -----------------------
128: SAVEPOINT Create_Sys_Parameters;
129:
130: IF g_debug THEN
131: OZF_Utility_PVT.debug_message(l_full_name||': start');
132: END IF;
133:
134: IF FND_API.to_boolean(p_init_msg_list) THEN
135: FND_MSG_PUB.initialize;

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

167: l_org_id := l_sys_parameters_rec.org_id; -- R12 Enhancements
168:
169: ----------------------- validate -----------------------
170: IF g_debug THEN
171: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
172: END IF;
173:
174: -- validate the uniqueness of the set_of_books_id
175: IF p_sys_parameters_rec.set_of_books_id IS NULL THEN

Line 224: OZF_Utility_PVT.debug_message(l_full_name ||': insert');

220: END IF;
221:
222: -------------------------- insert --------------------------
223: IF g_debug THEN
224: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
225: END IF;
226:
227: INSERT INTO ozf_sys_parameters_all (
228: set_of_books_id

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

422: p_data => x_msg_data
423: );
424:
425: IF g_debug THEN
426: OZF_Utility_PVT.debug_message(l_full_name ||': end');
427: END IF;
428:
429: EXCEPTION
430: WHEN FND_API.g_exc_error THEN

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

493: --------------------- initialize -----------------------
494: SAVEPOINT Delete_Sys_Parameters;
495:
496: IF g_debug THEN
497: OZF_Utility_PVT.debug_message(l_full_name||': start');
498: END IF;
499:
500: IF FND_API.to_boolean(p_init_msg_list) THEN
501: FND_MSG_PUB.initialize;

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

513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514:
515: ------------------------ delete ------------------------
516: IF g_debug THEN
517: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
518: END IF;
519:
520: DELETE FROM ozf_sys_parameters_all
521: WHERE set_of_books_id = p_set_of_books_id

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

542: p_data => x_msg_data
543: );
544:
545: IF g_debug THEN
546: OZF_Utility_PVT.debug_message(l_full_name ||': end');
547: END IF;
548:
549: EXCEPTION
550: WHEN FND_API.g_exc_error THEN

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

617: BEGIN
618:
619: -------------------- initialize ------------------------
620: IF g_debug THEN
621: OZF_Utility_PVT.debug_message(l_full_name||': start');
622: END IF;
623:
624: IF FND_API.to_boolean(p_init_msg_list) THEN
625: FND_MSG_PUB.initialize;

Line 641: OZF_Utility_PVT.debug_message(l_full_name||': lock');

637: x_return_status := FND_API.G_RET_STS_SUCCESS;
638:
639: ------------------------ lock -------------------------
640: IF g_debug THEN
641: OZF_Utility_PVT.debug_message(l_full_name||': lock');
642: END IF;
643:
644: OPEN c_sys_para;
645: FETCH c_sys_para INTO l_set_of_books_id;

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

660: p_data => x_msg_data
661: );
662:
663: IF g_debug THEN
664: OZF_Utility_PVT.debug_message(l_full_name ||': end');
665: END IF;
666:
667: EXCEPTION
668: WHEN OZF_Utility_PVT.resource_locked THEN

Line 668: WHEN OZF_Utility_PVT.resource_locked THEN

664: OZF_Utility_PVT.debug_message(l_full_name ||': end');
665: END IF;
666:
667: EXCEPTION
668: WHEN OZF_Utility_PVT.resource_locked THEN
669: x_return_status := FND_API.g_ret_sts_error;
670: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
671: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
672: FND_MSG_PUB.add;

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

756: -------------------- initialize -------------------------
757: SAVEPOINT Update_Sys_Parameters;
758:
759: IF g_debug THEN
760: OZF_Utility_PVT.debug_message(l_full_name||': start');
761: END IF;
762:
763: IF FND_API.to_boolean(p_init_msg_list) THEN
764: FND_MSG_PUB.initialize;

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

779: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
780:
781: ----------------------- validate ----------------------
782: IF g_debug THEN
783: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
784: END IF;
785:
786: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
787: Check_Sys_Parameters_Items(

Line 831: ozf_utility_pvt.debug_message('Object version number is :'||

827: RAISE FND_API.g_exc_error;
828: END IF;
829:
830: l_object_version_number := l_sys_parameters_rec.object_version_number + 1;
831: ozf_utility_pvt.debug_message('Object version number is :'||
832: l_sys_parameters_rec.object_version_number);
833:
834: ozf_utility_pvt.debug_message('Orgid is :'||p_sys_parameters_rec.org_id);
835: ozf_utility_pvt.debug_message('l_sys_parameters_rec.transfer_to_gl_in :'||l_sys_parameters_rec.transfer_to_gl_in);

Line 834: ozf_utility_pvt.debug_message('Orgid is :'||p_sys_parameters_rec.org_id);

830: l_object_version_number := l_sys_parameters_rec.object_version_number + 1;
831: ozf_utility_pvt.debug_message('Object version number is :'||
832: l_sys_parameters_rec.object_version_number);
833:
834: ozf_utility_pvt.debug_message('Orgid is :'||p_sys_parameters_rec.org_id);
835: ozf_utility_pvt.debug_message('l_sys_parameters_rec.transfer_to_gl_in :'||l_sys_parameters_rec.transfer_to_gl_in);
836:
837: -- Get the set_of_books_id for given org_id
838: MO_UTILS.Get_Ledger_Info (

Line 835: ozf_utility_pvt.debug_message('l_sys_parameters_rec.transfer_to_gl_in :'||l_sys_parameters_rec.transfer_to_gl_in);

831: ozf_utility_pvt.debug_message('Object version number is :'||
832: l_sys_parameters_rec.object_version_number);
833:
834: ozf_utility_pvt.debug_message('Orgid is :'||p_sys_parameters_rec.org_id);
835: ozf_utility_pvt.debug_message('l_sys_parameters_rec.transfer_to_gl_in :'||l_sys_parameters_rec.transfer_to_gl_in);
836:
837: -- Get the set_of_books_id for given org_id
838: MO_UTILS.Get_Ledger_Info (
839: p_operating_unit => p_sys_parameters_rec.org_id,

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

844: l_sys_parameters_rec.set_of_books_id := l_set_of_books_id;
845:
846: -------------------------- update --------------------
847: IF g_debug THEN
848: OZF_Utility_PVT.debug_message(l_full_name ||': update');
849: END IF;
850: UPDATE ozf_sys_parameters_all SET
851: set_of_books_id = l_sys_parameters_rec.set_of_books_id
852: ,object_version_number = l_object_version_number

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

962: p_data => x_msg_data
963: );
964:
965: IF g_debug THEN
966: OZF_Utility_PVT.debug_message(l_full_name ||': end');
967: END IF;
968:
969: EXCEPTION
970:

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

1031: BEGIN
1032:
1033: ----------------------- initialize --------------------
1034: IF g_debug THEN
1035: OZF_Utility_PVT.debug_message(l_full_name||': start');
1036: END IF;
1037:
1038: IF FND_API.to_boolean(p_init_msg_list) THEN
1039: FND_MSG_PUB.initialize;

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

1051: x_return_status := FND_API.g_ret_sts_success;
1052:
1053: ---------------------- validate ------------------------
1054: IF g_debug THEN
1055: OZF_Utility_PVT.debug_message(l_full_name||': check items');
1056: END IF;
1057:
1058: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1059: Check_Sys_Parameters_Items(

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

1069: END IF;
1070: END IF;
1071:
1072: IF g_debug THEN
1073: OZF_Utility_PVT.debug_message(l_full_name||': check record');
1074: END IF;
1075:
1076: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1077: Check_Sys_Parameters_Record(

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

1107: p_data => x_msg_data
1108: );
1109:
1110: IF g_debug THEN
1111: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1112: END IF;
1113:
1114: EXCEPTION
1115:

Line 1599: ozf_utility_pvt.debug_message('IN transfer_to_gl_in = FND_API.G_MISS_CHAR');

1595: IF p_sys_parameters_rec.post_to_gl IS NULL THEN
1596: x_complete_rec.post_to_gl := l_sys_parameters_rec.post_to_gl;
1597: END IF;
1598: IF p_sys_parameters_rec.transfer_to_gl_in = FND_API.G_MISS_CHAR THEN
1599: ozf_utility_pvt.debug_message('IN transfer_to_gl_in = FND_API.G_MISS_CHAR');
1600: --Commented as transfer_to_gl_in cannot be NULL and as this object is not displayed, the same value is retained.
1601: --x_complete_rec.transfer_to_gl_in := NULL;
1602: x_complete_rec.transfer_to_gl_in := l_sys_parameters_rec.transfer_to_gl_in;
1603: END IF;