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.HZ_EXTRACT_PERSON_BO_PVT dependencies on FND_LOG

Line 125: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

121: END IF;
122:
123:
124: -- Debug info.
125: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
126: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos(+)',
127: p_prefix=>l_debug_prefix,
128: p_msg_level=>fnd_log.level_procedure);
129: END IF;

Line 128: p_msg_level=>fnd_log.level_procedure);

124: -- Debug info.
125: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
126: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos(+)',
127: p_prefix=>l_debug_prefix,
128: p_msg_level=>fnd_log.level_procedure);
129: END IF;
130:
131: x_employ_hist_objs := HZ_EMPLOY_HIST_BO_TBL();
132: open c1;

Line 137: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

133: fetch c1 BULK COLLECT into x_employ_hist_objs;
134: close c1;
135:
136: -- Debug info.
137: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
138: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
139: p_msg_data=>x_msg_data,
140: p_msg_type=>'WARNING',
141: p_msg_level=>fnd_log.level_exception);

Line 141: p_msg_level=>fnd_log.level_exception);

137: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
138: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
139: p_msg_data=>x_msg_data,
140: p_msg_type=>'WARNING',
141: p_msg_level=>fnd_log.level_exception);
142: END IF;
143:
144: -- Debug info.
145: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 145: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

141: p_msg_level=>fnd_log.level_exception);
142: END IF;
143:
144: -- Debug info.
145: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
146: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
147: p_prefix=>l_debug_prefix,
148: p_msg_level=>fnd_log.level_procedure);
149: END IF;

Line 148: p_msg_level=>fnd_log.level_procedure);

144: -- Debug info.
145: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
146: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
147: p_prefix=>l_debug_prefix,
148: p_msg_level=>fnd_log.level_procedure);
149: END IF;
150:
151:
152: EXCEPTION

Line 162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

158: p_count => x_msg_count,
159: p_data => x_msg_data);
160:
161: -- Debug info.
162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
163: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
164: p_msg_data=>x_msg_data,
165: p_msg_type=>'ERROR',
166: p_msg_level=>fnd_log.level_error);

Line 166: p_msg_level=>fnd_log.level_error);

162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
163: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
164: p_msg_data=>x_msg_data,
165: p_msg_type=>'ERROR',
166: p_msg_level=>fnd_log.level_error);
167: END IF;
168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
169: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
170: p_prefix=>l_debug_prefix,

Line 168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

164: p_msg_data=>x_msg_data,
165: p_msg_type=>'ERROR',
166: p_msg_level=>fnd_log.level_error);
167: END IF;
168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
169: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
170: p_prefix=>l_debug_prefix,
171: p_msg_level=>fnd_log.level_procedure);
172: END IF;

Line 171: p_msg_level=>fnd_log.level_procedure);

167: END IF;
168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
169: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
170: p_prefix=>l_debug_prefix,
171: p_msg_level=>fnd_log.level_procedure);
172: END IF;
173: WHEN fnd_api.g_exc_unexpected_error THEN
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175:

Line 181: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

177: p_count => x_msg_count,
178: p_data => x_msg_data);
179:
180: -- Debug info.
181: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
183: p_msg_data=>x_msg_data,
184: p_msg_type=>'UNEXPECTED ERROR',
185: p_msg_level=>fnd_log.level_error);

Line 185: p_msg_level=>fnd_log.level_error);

181: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
182: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
183: p_msg_data=>x_msg_data,
184: p_msg_type=>'UNEXPECTED ERROR',
185: p_msg_level=>fnd_log.level_error);
186: END IF;
187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
188: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
189: p_prefix=>l_debug_prefix,

Line 187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

183: p_msg_data=>x_msg_data,
184: p_msg_type=>'UNEXPECTED ERROR',
185: p_msg_level=>fnd_log.level_error);
186: END IF;
187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
188: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
189: p_prefix=>l_debug_prefix,
190: p_msg_level=>fnd_log.level_procedure);
191: END IF;

Line 190: p_msg_level=>fnd_log.level_procedure);

186: END IF;
187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
188: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
189: p_prefix=>l_debug_prefix,
190: p_msg_level=>fnd_log.level_procedure);
191: END IF;
192: WHEN OTHERS THEN
193: x_return_status := fnd_api.g_ret_sts_unexp_error;
194:

Line 204: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

200: p_count => x_msg_count,
201: p_data => x_msg_data);
202:
203: -- Debug info.
204: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
206: p_msg_data=>x_msg_data,
207: p_msg_type=>'SQL ERROR',
208: p_msg_level=>fnd_log.level_error);

Line 208: p_msg_level=>fnd_log.level_error);

204: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
205: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
206: p_msg_data=>x_msg_data,
207: p_msg_type=>'SQL ERROR',
208: p_msg_level=>fnd_log.level_error);
209: END IF;
210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
211: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
212: p_prefix=>l_debug_prefix,

Line 210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

206: p_msg_data=>x_msg_data,
207: p_msg_type=>'SQL ERROR',
208: p_msg_level=>fnd_log.level_error);
209: END IF;
210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
211: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
212: p_prefix=>l_debug_prefix,
213: p_msg_level=>fnd_log.level_procedure);
214: END IF;

Line 213: p_msg_level=>fnd_log.level_procedure);

209: END IF;
210: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
211: hz_utility_v2pub.debug(p_message=>'get_employ_hist_bos (-)',
212: p_prefix=>l_debug_prefix,
213: p_msg_level=>fnd_log.level_procedure);
214: END IF;
215:
216: end;
217:

Line 569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

565: END IF;
566:
567:
568: -- Debug info.
569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
570: hz_utility_v2pub.debug(p_message=>'get_person_bo(+)',
571: p_prefix=>l_debug_prefix,
572: p_msg_level=>fnd_log.level_procedure);
573: END IF;

Line 572: p_msg_level=>fnd_log.level_procedure);

568: -- Debug info.
569: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
570: hz_utility_v2pub.debug(p_message=>'get_person_bo(+)',
571: p_prefix=>l_debug_prefix,
572: p_msg_level=>fnd_log.level_procedure);
573: END IF;
574:
575: open c1;
576: fetch c1 into x_person_obj;

Line 741: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

737: END IF;
738:
739:
740: -- Debug info.
741: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
742: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
743: p_msg_data=>x_msg_data,
744: p_msg_type=>'WARNING',
745: p_msg_level=>fnd_log.level_exception);

Line 745: p_msg_level=>fnd_log.level_exception);

741: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
742: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
743: p_msg_data=>x_msg_data,
744: p_msg_type=>'WARNING',
745: p_msg_level=>fnd_log.level_exception);
746: END IF;
747:
748: -- Debug info.
749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

745: p_msg_level=>fnd_log.level_exception);
746: END IF;
747:
748: -- Debug info.
749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
750: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
751: p_prefix=>l_debug_prefix,
752: p_msg_level=>fnd_log.level_procedure);
753: END IF;

Line 752: p_msg_level=>fnd_log.level_procedure);

748: -- Debug info.
749: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
750: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
751: p_prefix=>l_debug_prefix,
752: p_msg_level=>fnd_log.level_procedure);
753: END IF;
754:
755:
756: EXCEPTION

Line 766: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

762: p_count => x_msg_count,
763: p_data => x_msg_data);
764:
765: -- Debug info.
766: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
767: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
768: p_msg_data=>x_msg_data,
769: p_msg_type=>'ERROR',
770: p_msg_level=>fnd_log.level_error);

Line 770: p_msg_level=>fnd_log.level_error);

766: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
767: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
768: p_msg_data=>x_msg_data,
769: p_msg_type=>'ERROR',
770: p_msg_level=>fnd_log.level_error);
771: END IF;
772: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
773: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
774: p_prefix=>l_debug_prefix,

Line 772: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

768: p_msg_data=>x_msg_data,
769: p_msg_type=>'ERROR',
770: p_msg_level=>fnd_log.level_error);
771: END IF;
772: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
773: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
774: p_prefix=>l_debug_prefix,
775: p_msg_level=>fnd_log.level_procedure);
776: END IF;

Line 775: p_msg_level=>fnd_log.level_procedure);

771: END IF;
772: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
773: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
774: p_prefix=>l_debug_prefix,
775: p_msg_level=>fnd_log.level_procedure);
776: END IF;
777: WHEN fnd_api.g_exc_unexpected_error THEN
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779:

Line 785: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

781: p_count => x_msg_count,
782: p_data => x_msg_data);
783:
784: -- Debug info.
785: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
786: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
787: p_msg_data=>x_msg_data,
788: p_msg_type=>'UNEXPECTED ERROR',
789: p_msg_level=>fnd_log.level_error);

Line 789: p_msg_level=>fnd_log.level_error);

785: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
786: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
787: p_msg_data=>x_msg_data,
788: p_msg_type=>'UNEXPECTED ERROR',
789: p_msg_level=>fnd_log.level_error);
790: END IF;
791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
792: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
793: p_prefix=>l_debug_prefix,

Line 791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

787: p_msg_data=>x_msg_data,
788: p_msg_type=>'UNEXPECTED ERROR',
789: p_msg_level=>fnd_log.level_error);
790: END IF;
791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
792: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
793: p_prefix=>l_debug_prefix,
794: p_msg_level=>fnd_log.level_procedure);
795: END IF;

Line 794: p_msg_level=>fnd_log.level_procedure);

790: END IF;
791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
792: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
793: p_prefix=>l_debug_prefix,
794: p_msg_level=>fnd_log.level_procedure);
795: END IF;
796: WHEN OTHERS THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error;
798:

Line 808: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

804: p_count => x_msg_count,
805: p_data => x_msg_data);
806:
807: -- Debug info.
808: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
809: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
810: p_msg_data=>x_msg_data,
811: p_msg_type=>'SQL ERROR',
812: p_msg_level=>fnd_log.level_error);

Line 812: p_msg_level=>fnd_log.level_error);

808: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
809: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
810: p_msg_data=>x_msg_data,
811: p_msg_type=>'SQL ERROR',
812: p_msg_level=>fnd_log.level_error);
813: END IF;
814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
815: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
816: p_prefix=>l_debug_prefix,

Line 814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

810: p_msg_data=>x_msg_data,
811: p_msg_type=>'SQL ERROR',
812: p_msg_level=>fnd_log.level_error);
813: END IF;
814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
815: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
816: p_prefix=>l_debug_prefix,
817: p_msg_level=>fnd_log.level_procedure);
818: END IF;

Line 817: p_msg_level=>fnd_log.level_procedure);

813: END IF;
814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
815: hz_utility_v2pub.debug(p_message=>'get_person_bo (-)',
816: p_prefix=>l_debug_prefix,
817: p_msg_level=>fnd_log.level_procedure);
818: END IF;
819:
820: end;
821:

Line 896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

892: END IF;
893:
894:
895: -- Debug info.
896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
897: hz_utility_v2pub.debug(p_message=>'get_person_created(+)',
898: p_prefix=>l_debug_prefix,
899: p_msg_level=>fnd_log.level_procedure);
900: END IF;

Line 899: p_msg_level=>fnd_log.level_procedure);

895: -- Debug info.
896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
897: hz_utility_v2pub.debug(p_message=>'get_person_created(+)',
898: p_prefix=>l_debug_prefix,
899: p_msg_level=>fnd_log.level_procedure);
900: END IF;
901:
902:
903: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

Line 936: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

932:
933: end loop;
934:
935: -- Debug info.
936: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
937: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
938: p_msg_data=>x_msg_data,
939: p_msg_type=>'WARNING',
940: p_msg_level=>fnd_log.level_exception);

Line 940: p_msg_level=>fnd_log.level_exception);

936: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
937: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
938: p_msg_data=>x_msg_data,
939: p_msg_type=>'WARNING',
940: p_msg_level=>fnd_log.level_exception);
941: END IF;
942:
943: -- Debug info.
944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

940: p_msg_level=>fnd_log.level_exception);
941: END IF;
942:
943: -- Debug info.
944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
945: hz_utility_v2pub.debug(p_message=>'get_person_created (-)',
946: p_prefix=>l_debug_prefix,
947: p_msg_level=>fnd_log.level_procedure);
948: END IF;

Line 947: p_msg_level=>fnd_log.level_procedure);

943: -- Debug info.
944: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
945: hz_utility_v2pub.debug(p_message=>'get_person_created (-)',
946: p_prefix=>l_debug_prefix,
947: p_msg_level=>fnd_log.level_procedure);
948: END IF;
949:
950:
951: EXCEPTION

Line 961: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

957: p_count => x_msg_count,
958: p_data => x_msg_data);
959:
960: -- Debug info.
961: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
962: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
963: p_msg_data=>x_msg_data,
964: p_msg_type=>'ERROR',
965: p_msg_level=>fnd_log.level_error);

Line 965: p_msg_level=>fnd_log.level_error);

961: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
962: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
963: p_msg_data=>x_msg_data,
964: p_msg_type=>'ERROR',
965: p_msg_level=>fnd_log.level_error);
966: END IF;
967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
968: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
969: p_prefix=>l_debug_prefix,

Line 967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

963: p_msg_data=>x_msg_data,
964: p_msg_type=>'ERROR',
965: p_msg_level=>fnd_log.level_error);
966: END IF;
967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
968: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
969: p_prefix=>l_debug_prefix,
970: p_msg_level=>fnd_log.level_procedure);
971: END IF;

Line 970: p_msg_level=>fnd_log.level_procedure);

966: END IF;
967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
968: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
969: p_prefix=>l_debug_prefix,
970: p_msg_level=>fnd_log.level_procedure);
971: END IF;
972: WHEN fnd_api.g_exc_unexpected_error THEN
973: x_return_status := fnd_api.g_ret_sts_unexp_error;
974:

Line 980: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

976: p_count => x_msg_count,
977: p_data => x_msg_data);
978:
979: -- Debug info.
980: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
981: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
982: p_msg_data=>x_msg_data,
983: p_msg_type=>'UNEXPECTED ERROR',
984: p_msg_level=>fnd_log.level_error);

Line 984: p_msg_level=>fnd_log.level_error);

980: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
981: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
982: p_msg_data=>x_msg_data,
983: p_msg_type=>'UNEXPECTED ERROR',
984: p_msg_level=>fnd_log.level_error);
985: END IF;
986: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
987: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
988: p_prefix=>l_debug_prefix,

Line 986: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

982: p_msg_data=>x_msg_data,
983: p_msg_type=>'UNEXPECTED ERROR',
984: p_msg_level=>fnd_log.level_error);
985: END IF;
986: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
987: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
988: p_prefix=>l_debug_prefix,
989: p_msg_level=>fnd_log.level_procedure);
990: END IF;

Line 989: p_msg_level=>fnd_log.level_procedure);

985: END IF;
986: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
987: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
988: p_prefix=>l_debug_prefix,
989: p_msg_level=>fnd_log.level_procedure);
990: END IF;
991: WHEN OTHERS THEN
992: x_return_status := fnd_api.g_ret_sts_unexp_error;
993:

Line 1003: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

999: p_count => x_msg_count,
1000: p_data => x_msg_data);
1001:
1002: -- Debug info.
1003: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1004: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1005: p_msg_data=>x_msg_data,
1006: p_msg_type=>'SQL ERROR',
1007: p_msg_level=>fnd_log.level_error);

Line 1007: p_msg_level=>fnd_log.level_error);

1003: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1004: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1005: p_msg_data=>x_msg_data,
1006: p_msg_type=>'SQL ERROR',
1007: p_msg_level=>fnd_log.level_error);
1008: END IF;
1009: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1010: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
1011: p_prefix=>l_debug_prefix,

Line 1009: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1005: p_msg_data=>x_msg_data,
1006: p_msg_type=>'SQL ERROR',
1007: p_msg_level=>fnd_log.level_error);
1008: END IF;
1009: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1010: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
1011: p_prefix=>l_debug_prefix,
1012: p_msg_level=>fnd_log.level_procedure);
1013: END IF;

Line 1012: p_msg_level=>fnd_log.level_procedure);

1008: END IF;
1009: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1010: hz_utility_v2pub.debug(p_message=>'get_person_created(-)',
1011: p_prefix=>l_debug_prefix,
1012: p_msg_level=>fnd_log.level_procedure);
1013: END IF;
1014:
1015: end;
1016:

Line 1088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1084: END IF;
1085:
1086:
1087: -- Debug info.
1088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1089: hz_utility_v2pub.debug(p_message=>'get_persons_updated(+)',
1090: p_prefix=>l_debug_prefix,
1091: p_msg_level=>fnd_log.level_procedure);
1092: END IF;

Line 1091: p_msg_level=>fnd_log.level_procedure);

1087: -- Debug info.
1088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1089: hz_utility_v2pub.debug(p_message=>'get_persons_updated(+)',
1090: p_prefix=>l_debug_prefix,
1091: p_msg_level=>fnd_log.level_procedure);
1092: END IF;
1093:
1094:
1095: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

Line 1134: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1130:
1131:
1132:
1133: -- Debug info.
1134: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1135: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1136: p_msg_data=>x_msg_data,
1137: p_msg_type=>'WARNING',
1138: p_msg_level=>fnd_log.level_exception);

Line 1138: p_msg_level=>fnd_log.level_exception);

1134: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1135: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1136: p_msg_data=>x_msg_data,
1137: p_msg_type=>'WARNING',
1138: p_msg_level=>fnd_log.level_exception);
1139: END IF;
1140:
1141: -- Debug info.
1142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1138: p_msg_level=>fnd_log.level_exception);
1139: END IF;
1140:
1141: -- Debug info.
1142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1143: hz_utility_v2pub.debug(p_message=>'get_persons_updated (-)',
1144: p_prefix=>l_debug_prefix,
1145: p_msg_level=>fnd_log.level_procedure);
1146: END IF;

Line 1145: p_msg_level=>fnd_log.level_procedure);

1141: -- Debug info.
1142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1143: hz_utility_v2pub.debug(p_message=>'get_persons_updated (-)',
1144: p_prefix=>l_debug_prefix,
1145: p_msg_level=>fnd_log.level_procedure);
1146: END IF;
1147:
1148:
1149: EXCEPTION

Line 1159: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1155: p_count => x_msg_count,
1156: p_data => x_msg_data);
1157:
1158: -- Debug info.
1159: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1160: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1161: p_msg_data=>x_msg_data,
1162: p_msg_type=>'ERROR',
1163: p_msg_level=>fnd_log.level_error);

Line 1163: p_msg_level=>fnd_log.level_error);

1159: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1160: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1161: p_msg_data=>x_msg_data,
1162: p_msg_type=>'ERROR',
1163: p_msg_level=>fnd_log.level_error);
1164: END IF;
1165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1166: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1167: p_prefix=>l_debug_prefix,

Line 1165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1161: p_msg_data=>x_msg_data,
1162: p_msg_type=>'ERROR',
1163: p_msg_level=>fnd_log.level_error);
1164: END IF;
1165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1166: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1167: p_prefix=>l_debug_prefix,
1168: p_msg_level=>fnd_log.level_procedure);
1169: END IF;

Line 1168: p_msg_level=>fnd_log.level_procedure);

1164: END IF;
1165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1166: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1167: p_prefix=>l_debug_prefix,
1168: p_msg_level=>fnd_log.level_procedure);
1169: END IF;
1170: WHEN fnd_api.g_exc_unexpected_error THEN
1171: x_return_status := fnd_api.g_ret_sts_unexp_error;
1172:

Line 1178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1174: p_count => x_msg_count,
1175: p_data => x_msg_data);
1176:
1177: -- Debug info.
1178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1179: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1180: p_msg_data=>x_msg_data,
1181: p_msg_type=>'UNEXPECTED ERROR',
1182: p_msg_level=>fnd_log.level_error);

Line 1182: p_msg_level=>fnd_log.level_error);

1178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1179: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1180: p_msg_data=>x_msg_data,
1181: p_msg_type=>'UNEXPECTED ERROR',
1182: p_msg_level=>fnd_log.level_error);
1183: END IF;
1184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1185: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1186: p_prefix=>l_debug_prefix,

Line 1184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1180: p_msg_data=>x_msg_data,
1181: p_msg_type=>'UNEXPECTED ERROR',
1182: p_msg_level=>fnd_log.level_error);
1183: END IF;
1184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1185: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1186: p_prefix=>l_debug_prefix,
1187: p_msg_level=>fnd_log.level_procedure);
1188: END IF;

Line 1187: p_msg_level=>fnd_log.level_procedure);

1183: END IF;
1184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1185: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1186: p_prefix=>l_debug_prefix,
1187: p_msg_level=>fnd_log.level_procedure);
1188: END IF;
1189: WHEN OTHERS THEN
1190: x_return_status := fnd_api.g_ret_sts_unexp_error;
1191:

Line 1201: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1197: p_count => x_msg_count,
1198: p_data => x_msg_data);
1199:
1200: -- Debug info.
1201: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1203: p_msg_data=>x_msg_data,
1204: p_msg_type=>'SQL ERROR',
1205: p_msg_level=>fnd_log.level_error);

Line 1205: p_msg_level=>fnd_log.level_error);

1201: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1203: p_msg_data=>x_msg_data,
1204: p_msg_type=>'SQL ERROR',
1205: p_msg_level=>fnd_log.level_error);
1206: END IF;
1207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1208: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1209: p_prefix=>l_debug_prefix,

Line 1207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1203: p_msg_data=>x_msg_data,
1204: p_msg_type=>'SQL ERROR',
1205: p_msg_level=>fnd_log.level_error);
1206: END IF;
1207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1208: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1209: p_prefix=>l_debug_prefix,
1210: p_msg_level=>fnd_log.level_procedure);
1211: END IF;

Line 1210: p_msg_level=>fnd_log.level_procedure);

1206: END IF;
1207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1208: hz_utility_v2pub.debug(p_message=>'get_persons_updated(-)',
1209: p_prefix=>l_debug_prefix,
1210: p_msg_level=>fnd_log.level_procedure);
1211: END IF;
1212:
1213: end;
1214:

Line 1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1681: END IF;
1682:
1683:
1684: -- Debug info.
1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1686: hz_utility_v2pub.debug(p_message=>'get_person_updated(+)',
1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;

Line 1688: p_msg_level=>fnd_log.level_procedure);

1684: -- Debug info.
1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1686: hz_utility_v2pub.debug(p_message=>'get_person_updated(+)',
1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;
1690: /* moved to public api
1691: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
1692: p_party_id => p_person_id,

Line 1732: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1728: x_person_obj := l_person_obj;
1729:
1730:
1731: -- Debug info.
1732: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1734: p_msg_data=>x_msg_data,
1735: p_msg_type=>'WARNING',
1736: p_msg_level=>fnd_log.level_exception);

Line 1736: p_msg_level=>fnd_log.level_exception);

1732: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1733: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1734: p_msg_data=>x_msg_data,
1735: p_msg_type=>'WARNING',
1736: p_msg_level=>fnd_log.level_exception);
1737: END IF;
1738:
1739: -- Debug info.
1740: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1740: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1736: p_msg_level=>fnd_log.level_exception);
1737: END IF;
1738:
1739: -- Debug info.
1740: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1741: hz_utility_v2pub.debug(p_message=>'get_person_updated (-)',
1742: p_prefix=>l_debug_prefix,
1743: p_msg_level=>fnd_log.level_procedure);
1744: END IF;

Line 1743: p_msg_level=>fnd_log.level_procedure);

1739: -- Debug info.
1740: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1741: hz_utility_v2pub.debug(p_message=>'get_person_updated (-)',
1742: p_prefix=>l_debug_prefix,
1743: p_msg_level=>fnd_log.level_procedure);
1744: END IF;
1745:
1746:
1747: EXCEPTION

Line 1757: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1753: p_count => x_msg_count,
1754: p_data => x_msg_data);
1755:
1756: -- Debug info.
1757: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1758: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1759: p_msg_data=>x_msg_data,
1760: p_msg_type=>'ERROR',
1761: p_msg_level=>fnd_log.level_error);

Line 1761: p_msg_level=>fnd_log.level_error);

1757: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1758: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1759: p_msg_data=>x_msg_data,
1760: p_msg_type=>'ERROR',
1761: p_msg_level=>fnd_log.level_error);
1762: END IF;
1763: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1764: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1765: p_prefix=>l_debug_prefix,

Line 1763: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1759: p_msg_data=>x_msg_data,
1760: p_msg_type=>'ERROR',
1761: p_msg_level=>fnd_log.level_error);
1762: END IF;
1763: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1764: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1765: p_prefix=>l_debug_prefix,
1766: p_msg_level=>fnd_log.level_procedure);
1767: END IF;

Line 1766: p_msg_level=>fnd_log.level_procedure);

1762: END IF;
1763: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1764: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1765: p_prefix=>l_debug_prefix,
1766: p_msg_level=>fnd_log.level_procedure);
1767: END IF;
1768: WHEN fnd_api.g_exc_unexpected_error THEN
1769: x_return_status := fnd_api.g_ret_sts_unexp_error;
1770:

Line 1776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1772: p_count => x_msg_count,
1773: p_data => x_msg_data);
1774:
1775: -- Debug info.
1776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1777: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1778: p_msg_data=>x_msg_data,
1779: p_msg_type=>'UNEXPECTED ERROR',
1780: p_msg_level=>fnd_log.level_error);

Line 1780: p_msg_level=>fnd_log.level_error);

1776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1777: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1778: p_msg_data=>x_msg_data,
1779: p_msg_type=>'UNEXPECTED ERROR',
1780: p_msg_level=>fnd_log.level_error);
1781: END IF;
1782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1784: p_prefix=>l_debug_prefix,

Line 1782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1778: p_msg_data=>x_msg_data,
1779: p_msg_type=>'UNEXPECTED ERROR',
1780: p_msg_level=>fnd_log.level_error);
1781: END IF;
1782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1784: p_prefix=>l_debug_prefix,
1785: p_msg_level=>fnd_log.level_procedure);
1786: END IF;

Line 1785: p_msg_level=>fnd_log.level_procedure);

1781: END IF;
1782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1784: p_prefix=>l_debug_prefix,
1785: p_msg_level=>fnd_log.level_procedure);
1786: END IF;
1787: WHEN OTHERS THEN
1788: x_return_status := fnd_api.g_ret_sts_unexp_error;
1789:

Line 1799: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1795: p_count => x_msg_count,
1796: p_data => x_msg_data);
1797:
1798: -- Debug info.
1799: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1801: p_msg_data=>x_msg_data,
1802: p_msg_type=>'SQL ERROR',
1803: p_msg_level=>fnd_log.level_error);

Line 1803: p_msg_level=>fnd_log.level_error);

1799: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1800: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1801: p_msg_data=>x_msg_data,
1802: p_msg_type=>'SQL ERROR',
1803: p_msg_level=>fnd_log.level_error);
1804: END IF;
1805: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1806: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1807: p_prefix=>l_debug_prefix,

Line 1805: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1801: p_msg_data=>x_msg_data,
1802: p_msg_type=>'SQL ERROR',
1803: p_msg_level=>fnd_log.level_error);
1804: END IF;
1805: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1806: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1807: p_prefix=>l_debug_prefix,
1808: p_msg_level=>fnd_log.level_procedure);
1809: END IF;

Line 1808: p_msg_level=>fnd_log.level_procedure);

1804: END IF;
1805: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1806: hz_utility_v2pub.debug(p_message=>'get_person_updated(-)',
1807: p_prefix=>l_debug_prefix,
1808: p_msg_level=>fnd_log.level_procedure);
1809: END IF;
1810:
1811: end;
1812: