DBA Data[Home] [Help]

APPS.OZF_SYS_PARAMETERS_PVT dependencies on OZF_UTILITY_PVT

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

162: --------------------- initialize -----------------------
163: SAVEPOINT Create_Sys_Parameters;
164:
165: IF g_debug THEN
166: OZF_Utility_PVT.debug_message(l_full_name||': start');
167: END IF;
168:
169: IF FND_API.to_boolean(p_init_msg_list) THEN
170: FND_MSG_PUB.initialize;

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

202: l_org_id := l_sys_parameters_rec.org_id; -- R12 Enhancements
203:
204: ----------------------- validate -----------------------
205: IF g_debug THEN
206: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
207: END IF;
208:
209: -- validate the uniqueness of the set_of_books_id
210: IF p_sys_parameters_rec.set_of_books_id IS NULL THEN

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

255: END IF;
256:
257: -------------------------- insert --------------------------
258: IF g_debug THEN
259: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
260: END IF;
261:
262: INSERT INTO ozf_sys_parameters_all (
263: set_of_books_id

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

480: p_data => x_msg_data
481: );
482:
483: IF g_debug THEN
484: OZF_Utility_PVT.debug_message(l_full_name ||': end');
485: END IF;
486:
487: EXCEPTION
488: WHEN FND_API.g_exc_error THEN

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

551: --------------------- initialize -----------------------
552: SAVEPOINT Delete_Sys_Parameters;
553:
554: IF g_debug THEN
555: OZF_Utility_PVT.debug_message(l_full_name||': start');
556: END IF;
557:
558: IF FND_API.to_boolean(p_init_msg_list) THEN
559: FND_MSG_PUB.initialize;

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

571: x_return_status := FND_API.G_RET_STS_SUCCESS;
572:
573: ------------------------ delete ------------------------
574: IF g_debug THEN
575: OZF_Utility_PVT.debug_message(l_full_name ||': delete');
576: END IF;
577:
578: DELETE FROM ozf_sys_parameters_all
579: WHERE set_of_books_id = p_set_of_books_id

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

600: p_data => x_msg_data
601: );
602:
603: IF g_debug THEN
604: OZF_Utility_PVT.debug_message(l_full_name ||': end');
605: END IF;
606:
607: EXCEPTION
608: WHEN FND_API.g_exc_error THEN

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

675: BEGIN
676:
677: -------------------- initialize ------------------------
678: IF g_debug THEN
679: OZF_Utility_PVT.debug_message(l_full_name||': start');
680: END IF;
681:
682: IF FND_API.to_boolean(p_init_msg_list) THEN
683: FND_MSG_PUB.initialize;

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

695: x_return_status := FND_API.G_RET_STS_SUCCESS;
696:
697: ------------------------ lock -------------------------
698: IF g_debug THEN
699: OZF_Utility_PVT.debug_message(l_full_name||': lock');
700: END IF;
701:
702: OPEN c_sys_para;
703: FETCH c_sys_para INTO l_set_of_books_id;

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

718: p_data => x_msg_data
719: );
720:
721: IF g_debug THEN
722: OZF_Utility_PVT.debug_message(l_full_name ||': end');
723: END IF;
724:
725: EXCEPTION
726: WHEN OZF_Utility_PVT.resource_locked THEN

Line 726: WHEN OZF_Utility_PVT.resource_locked THEN

722: OZF_Utility_PVT.debug_message(l_full_name ||': end');
723: END IF;
724:
725: EXCEPTION
726: WHEN OZF_Utility_PVT.resource_locked THEN
727: x_return_status := FND_API.g_ret_sts_error;
728: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
729: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
730: FND_MSG_PUB.add;

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

814: -------------------- initialize -------------------------
815: SAVEPOINT Update_Sys_Parameters;
816:
817: IF g_debug THEN
818: OZF_Utility_PVT.debug_message(l_full_name||': start');
819: END IF;
820:
821: IF FND_API.to_boolean(p_init_msg_list) THEN
822: FND_MSG_PUB.initialize;

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

837: l_last_update_login := NVL(FND_GLOBAL.conc_login_id,-1);
838:
839: ----------------------- validate ----------------------
840: IF g_debug THEN
841: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
842: END IF;
843:
844: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
845: Check_Sys_Parameters_Items(

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

885: RAISE FND_API.g_exc_error;
886: END IF;
887:
888: l_object_version_number := l_sys_parameters_rec.object_version_number + 1;
889: ozf_utility_pvt.debug_message('Object version number is :'||
890: l_sys_parameters_rec.object_version_number);
891:
892: ozf_utility_pvt.debug_message('Orgid is :'||p_sys_parameters_rec.org_id);
893: ozf_utility_pvt.debug_message('l_sys_parameters_rec.transfer_to_gl_in :'||l_sys_parameters_rec.transfer_to_gl_in);

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

888: l_object_version_number := l_sys_parameters_rec.object_version_number + 1;
889: ozf_utility_pvt.debug_message('Object version number is :'||
890: l_sys_parameters_rec.object_version_number);
891:
892: ozf_utility_pvt.debug_message('Orgid is :'||p_sys_parameters_rec.org_id);
893: ozf_utility_pvt.debug_message('l_sys_parameters_rec.transfer_to_gl_in :'||l_sys_parameters_rec.transfer_to_gl_in);
894:
895: -- Get the set_of_books_id for given org_id
896: MO_UTILS.Get_Ledger_Info (

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

889: ozf_utility_pvt.debug_message('Object version number is :'||
890: l_sys_parameters_rec.object_version_number);
891:
892: ozf_utility_pvt.debug_message('Orgid is :'||p_sys_parameters_rec.org_id);
893: ozf_utility_pvt.debug_message('l_sys_parameters_rec.transfer_to_gl_in :'||l_sys_parameters_rec.transfer_to_gl_in);
894:
895: -- Get the set_of_books_id for given org_id
896: MO_UTILS.Get_Ledger_Info (
897: p_operating_unit => p_sys_parameters_rec.org_id,

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

902: l_sys_parameters_rec.set_of_books_id := l_set_of_books_id;
903:
904: -------------------------- update --------------------
905: IF g_debug THEN
906: OZF_Utility_PVT.debug_message(l_full_name ||': update');
907: END IF;
908: UPDATE ozf_sys_parameters_all SET
909: set_of_books_id = l_sys_parameters_rec.set_of_books_id
910: ,object_version_number = l_object_version_number

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

1033: p_data => x_msg_data
1034: );
1035:
1036: IF g_debug THEN
1037: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1038: END IF;
1039:
1040: EXCEPTION
1041:

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

1102: BEGIN
1103:
1104: ----------------------- initialize --------------------
1105: IF g_debug THEN
1106: OZF_Utility_PVT.debug_message(l_full_name||': start');
1107: END IF;
1108:
1109: IF FND_API.to_boolean(p_init_msg_list) THEN
1110: FND_MSG_PUB.initialize;

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

1122: x_return_status := FND_API.g_ret_sts_success;
1123:
1124: ---------------------- validate ------------------------
1125: IF g_debug THEN
1126: OZF_Utility_PVT.debug_message(l_full_name||': check items');
1127: END IF;
1128:
1129: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1130: Check_Sys_Parameters_Items(

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

1140: END IF;
1141: END IF;
1142:
1143: IF g_debug THEN
1144: OZF_Utility_PVT.debug_message(l_full_name||': check record');
1145: END IF;
1146:
1147: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1148: Check_Sys_Parameters_Record(

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

1178: p_data => x_msg_data
1179: );
1180:
1181: IF g_debug THEN
1182: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1183: END IF;
1184:
1185: EXCEPTION
1186:

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

1679: IF p_sys_parameters_rec.post_to_gl IS NULL THEN
1680: x_complete_rec.post_to_gl := l_sys_parameters_rec.post_to_gl;
1681: END IF;
1682: IF p_sys_parameters_rec.transfer_to_gl_in = FND_API.G_MISS_CHAR THEN
1683: ozf_utility_pvt.debug_message('IN transfer_to_gl_in = FND_API.G_MISS_CHAR');
1684: --Commented as transfer_to_gl_in cannot be NULL and as this object is not displayed, the same value is retained.
1685: --x_complete_rec.transfer_to_gl_in := NULL;
1686: x_complete_rec.transfer_to_gl_in := l_sys_parameters_rec.transfer_to_gl_in;
1687: END IF;