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_ORGANIZATION_BO_PVT dependencies on FND_LOG

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

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

Line 131: p_msg_level=>fnd_log.level_procedure);

127: -- Debug info.
128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
129: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos(+)',
130: p_prefix=>l_debug_prefix,
131: p_msg_level=>fnd_log.level_procedure);
132: END IF;
133:
134: x_financial_report_objs := HZ_FINANCIAL_BO_TBL();
135: open c1;

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

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

Line 144: p_msg_level=>fnd_log.level_exception);

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

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

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

Line 151: p_msg_level=>fnd_log.level_procedure);

147: -- Debug info.
148: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
149: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
150: p_prefix=>l_debug_prefix,
151: p_msg_level=>fnd_log.level_procedure);
152: END IF;
153:
154:
155: EXCEPTION

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

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

Line 169: p_msg_level=>fnd_log.level_error);

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

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

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

Line 174: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 188: p_msg_level=>fnd_log.level_error);

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

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

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

Line 193: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 211: p_msg_level=>fnd_log.level_error);

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

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

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

Line 216: p_msg_level=>fnd_log.level_procedure);

212: END IF;
213: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
214: hz_utility_v2pub.debug(p_message=>'get_financial_report_bos (-)',
215: p_prefix=>l_debug_prefix,
216: p_msg_level=>fnd_log.level_procedure);
217: END IF;
218:
219: end;
220:

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

665: END IF;
666:
667:
668: -- Debug info.
669: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
670: hz_utility_v2pub.debug(p_message=>'get_organization_bo(+)',
671: p_prefix=>l_debug_prefix,
672: p_msg_level=>fnd_log.level_procedure);
673: END IF;

Line 672: p_msg_level=>fnd_log.level_procedure);

668: -- Debug info.
669: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
670: hz_utility_v2pub.debug(p_message=>'get_organization_bo(+)',
671: p_prefix=>l_debug_prefix,
672: p_msg_level=>fnd_log.level_procedure);
673: END IF;
674:
675: open c1;
676: fetch c1 into x_organization_obj;

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

889: END IF;
890:
891:
892: -- Debug info.
893: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
894: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
895: p_msg_data=>x_msg_data,
896: p_msg_type=>'WARNING',
897: p_msg_level=>fnd_log.level_exception);

Line 897: p_msg_level=>fnd_log.level_exception);

893: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
894: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
895: p_msg_data=>x_msg_data,
896: p_msg_type=>'WARNING',
897: p_msg_level=>fnd_log.level_exception);
898: END IF;
899:
900: -- Debug info.
901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

897: p_msg_level=>fnd_log.level_exception);
898: END IF;
899:
900: -- Debug info.
901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
902: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
903: p_prefix=>l_debug_prefix,
904: p_msg_level=>fnd_log.level_procedure);
905: END IF;

Line 904: p_msg_level=>fnd_log.level_procedure);

900: -- Debug info.
901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
902: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
903: p_prefix=>l_debug_prefix,
904: p_msg_level=>fnd_log.level_procedure);
905: END IF;
906:
907:
908: EXCEPTION

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

914: p_count => x_msg_count,
915: p_data => x_msg_data);
916:
917: -- Debug info.
918: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
919: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
920: p_msg_data=>x_msg_data,
921: p_msg_type=>'ERROR',
922: p_msg_level=>fnd_log.level_error);

Line 922: p_msg_level=>fnd_log.level_error);

918: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
919: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
920: p_msg_data=>x_msg_data,
921: p_msg_type=>'ERROR',
922: p_msg_level=>fnd_log.level_error);
923: END IF;
924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
925: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
926: p_prefix=>l_debug_prefix,

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

920: p_msg_data=>x_msg_data,
921: p_msg_type=>'ERROR',
922: p_msg_level=>fnd_log.level_error);
923: END IF;
924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
925: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
926: p_prefix=>l_debug_prefix,
927: p_msg_level=>fnd_log.level_procedure);
928: END IF;

Line 927: p_msg_level=>fnd_log.level_procedure);

923: END IF;
924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
925: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
926: p_prefix=>l_debug_prefix,
927: p_msg_level=>fnd_log.level_procedure);
928: END IF;
929: WHEN fnd_api.g_exc_unexpected_error THEN
930: x_return_status := fnd_api.g_ret_sts_unexp_error;
931:

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

933: p_count => x_msg_count,
934: p_data => x_msg_data);
935:
936: -- Debug info.
937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
939: p_msg_data=>x_msg_data,
940: p_msg_type=>'UNEXPECTED ERROR',
941: p_msg_level=>fnd_log.level_error);

Line 941: p_msg_level=>fnd_log.level_error);

937: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
938: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
939: p_msg_data=>x_msg_data,
940: p_msg_type=>'UNEXPECTED ERROR',
941: p_msg_level=>fnd_log.level_error);
942: END IF;
943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
944: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
945: p_prefix=>l_debug_prefix,

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

939: p_msg_data=>x_msg_data,
940: p_msg_type=>'UNEXPECTED ERROR',
941: p_msg_level=>fnd_log.level_error);
942: END IF;
943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
944: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
945: p_prefix=>l_debug_prefix,
946: p_msg_level=>fnd_log.level_procedure);
947: END IF;

Line 946: p_msg_level=>fnd_log.level_procedure);

942: END IF;
943: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
944: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
945: p_prefix=>l_debug_prefix,
946: p_msg_level=>fnd_log.level_procedure);
947: END IF;
948: WHEN OTHERS THEN
949: x_return_status := fnd_api.g_ret_sts_unexp_error;
950:

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

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

Line 964: p_msg_level=>fnd_log.level_error);

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

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

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

Line 969: p_msg_level=>fnd_log.level_procedure);

965: END IF;
966: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
967: hz_utility_v2pub.debug(p_message=>'get_organization_bo (-)',
968: p_prefix=>l_debug_prefix,
969: p_msg_level=>fnd_log.level_procedure);
970: END IF;
971:
972: end;
973:

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

1045: END IF;
1046:
1047:
1048: -- Debug info.
1049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug(p_message=>'get_organization_created(+)',
1051: p_prefix=>l_debug_prefix,
1052: p_msg_level=>fnd_log.level_procedure);
1053: END IF;

Line 1052: p_msg_level=>fnd_log.level_procedure);

1048: -- Debug info.
1049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1050: hz_utility_v2pub.debug(p_message=>'get_organization_created(+)',
1051: p_prefix=>l_debug_prefix,
1052: p_msg_level=>fnd_log.level_procedure);
1053: END IF;
1054:
1055:
1056: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

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

1080: x_msg_data => x_msg_data);
1081: end loop;
1082:
1083: -- Debug info.
1084: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1085: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1086: p_msg_data=>x_msg_data,
1087: p_msg_type=>'WARNING',
1088: p_msg_level=>fnd_log.level_exception);

Line 1088: p_msg_level=>fnd_log.level_exception);

1084: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1085: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1086: p_msg_data=>x_msg_data,
1087: p_msg_type=>'WARNING',
1088: p_msg_level=>fnd_log.level_exception);
1089: END IF;
1090:
1091: -- Debug info.
1092: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

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

Line 1095: p_msg_level=>fnd_log.level_procedure);

1091: -- Debug info.
1092: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1093: hz_utility_v2pub.debug(p_message=>'get_organization_created (-)',
1094: p_prefix=>l_debug_prefix,
1095: p_msg_level=>fnd_log.level_procedure);
1096: END IF;
1097:
1098:
1099: EXCEPTION

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

1105: p_count => x_msg_count,
1106: p_data => x_msg_data);
1107:
1108: -- Debug info.
1109: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1111: p_msg_data=>x_msg_data,
1112: p_msg_type=>'ERROR',
1113: p_msg_level=>fnd_log.level_error);

Line 1113: p_msg_level=>fnd_log.level_error);

1109: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1111: p_msg_data=>x_msg_data,
1112: p_msg_type=>'ERROR',
1113: p_msg_level=>fnd_log.level_error);
1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1117: p_prefix=>l_debug_prefix,

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

1111: p_msg_data=>x_msg_data,
1112: p_msg_type=>'ERROR',
1113: p_msg_level=>fnd_log.level_error);
1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;

Line 1118: p_msg_level=>fnd_log.level_procedure);

1114: END IF;
1115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1116: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1117: p_prefix=>l_debug_prefix,
1118: p_msg_level=>fnd_log.level_procedure);
1119: END IF;
1120: WHEN fnd_api.g_exc_unexpected_error THEN
1121: x_return_status := fnd_api.g_ret_sts_unexp_error;
1122:

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

1124: p_count => x_msg_count,
1125: p_data => x_msg_data);
1126:
1127: -- Debug info.
1128: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1129: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1130: p_msg_data=>x_msg_data,
1131: p_msg_type=>'UNEXPECTED ERROR',
1132: p_msg_level=>fnd_log.level_error);

Line 1132: p_msg_level=>fnd_log.level_error);

1128: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1129: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1130: p_msg_data=>x_msg_data,
1131: p_msg_type=>'UNEXPECTED ERROR',
1132: p_msg_level=>fnd_log.level_error);
1133: END IF;
1134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1135: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1136: p_prefix=>l_debug_prefix,

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

1130: p_msg_data=>x_msg_data,
1131: p_msg_type=>'UNEXPECTED ERROR',
1132: p_msg_level=>fnd_log.level_error);
1133: END IF;
1134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1135: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1136: p_prefix=>l_debug_prefix,
1137: p_msg_level=>fnd_log.level_procedure);
1138: END IF;

Line 1137: p_msg_level=>fnd_log.level_procedure);

1133: END IF;
1134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1135: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1136: p_prefix=>l_debug_prefix,
1137: p_msg_level=>fnd_log.level_procedure);
1138: END IF;
1139: WHEN OTHERS THEN
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141:

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

1147: p_count => x_msg_count,
1148: p_data => x_msg_data);
1149:
1150: -- Debug info.
1151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1153: p_msg_data=>x_msg_data,
1154: p_msg_type=>'SQL ERROR',
1155: p_msg_level=>fnd_log.level_error);

Line 1155: p_msg_level=>fnd_log.level_error);

1151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1153: p_msg_data=>x_msg_data,
1154: p_msg_type=>'SQL ERROR',
1155: p_msg_level=>fnd_log.level_error);
1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1159: p_prefix=>l_debug_prefix,

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

1153: p_msg_data=>x_msg_data,
1154: p_msg_type=>'SQL ERROR',
1155: p_msg_level=>fnd_log.level_error);
1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1159: p_prefix=>l_debug_prefix,
1160: p_msg_level=>fnd_log.level_procedure);
1161: END IF;

Line 1160: p_msg_level=>fnd_log.level_procedure);

1156: END IF;
1157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1158: hz_utility_v2pub.debug(p_message=>'get_organization_created(-)',
1159: p_prefix=>l_debug_prefix,
1160: p_msg_level=>fnd_log.level_procedure);
1161: END IF;
1162:
1163: end;
1164:

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

1234: END IF;
1235:
1236:
1237: -- Debug info.
1238: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1239: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
1240: p_prefix=>l_debug_prefix,
1241: p_msg_level=>fnd_log.level_procedure);
1242: END IF;

Line 1241: p_msg_level=>fnd_log.level_procedure);

1237: -- Debug info.
1238: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1239: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
1240: p_prefix=>l_debug_prefix,
1241: p_msg_level=>fnd_log.level_procedure);
1242: END IF;
1243:
1244:
1245: HZ_EXTRACT_BO_UTIL_PVT.get_bo_root_ids(

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

1276:
1277:
1278:
1279: -- Debug info.
1280: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1282: p_msg_data=>x_msg_data,
1283: p_msg_type=>'WARNING',
1284: p_msg_level=>fnd_log.level_exception);

Line 1284: p_msg_level=>fnd_log.level_exception);

1280: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1282: p_msg_data=>x_msg_data,
1283: p_msg_type=>'WARNING',
1284: p_msg_level=>fnd_log.level_exception);
1285: END IF;
1286:
1287: -- Debug info.
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1284: p_msg_level=>fnd_log.level_exception);
1285: END IF;
1286:
1287: -- Debug info.
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1289: hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
1290: p_prefix=>l_debug_prefix,
1291: p_msg_level=>fnd_log.level_procedure);
1292: END IF;

Line 1291: p_msg_level=>fnd_log.level_procedure);

1287: -- Debug info.
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1289: hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
1290: p_prefix=>l_debug_prefix,
1291: p_msg_level=>fnd_log.level_procedure);
1292: END IF;
1293:
1294:
1295: EXCEPTION

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

1301: p_count => x_msg_count,
1302: p_data => x_msg_data);
1303:
1304: -- Debug info.
1305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'ERROR',
1309: p_msg_level=>fnd_log.level_error);

Line 1309: p_msg_level=>fnd_log.level_error);

1305: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1306: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'ERROR',
1309: p_msg_level=>fnd_log.level_error);
1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1313: p_prefix=>l_debug_prefix,

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

1307: p_msg_data=>x_msg_data,
1308: p_msg_type=>'ERROR',
1309: p_msg_level=>fnd_log.level_error);
1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;

Line 1314: p_msg_level=>fnd_log.level_procedure);

1310: END IF;
1311: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1312: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1313: p_prefix=>l_debug_prefix,
1314: p_msg_level=>fnd_log.level_procedure);
1315: END IF;
1316: WHEN fnd_api.g_exc_unexpected_error THEN
1317: x_return_status := fnd_api.g_ret_sts_unexp_error;
1318:

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

1320: p_count => x_msg_count,
1321: p_data => x_msg_data);
1322:
1323: -- Debug info.
1324: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'UNEXPECTED ERROR',
1328: p_msg_level=>fnd_log.level_error);

Line 1328: p_msg_level=>fnd_log.level_error);

1324: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1325: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'UNEXPECTED ERROR',
1328: p_msg_level=>fnd_log.level_error);
1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1332: p_prefix=>l_debug_prefix,

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

1326: p_msg_data=>x_msg_data,
1327: p_msg_type=>'UNEXPECTED ERROR',
1328: p_msg_level=>fnd_log.level_error);
1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;

Line 1333: p_msg_level=>fnd_log.level_procedure);

1329: END IF;
1330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1331: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1332: p_prefix=>l_debug_prefix,
1333: p_msg_level=>fnd_log.level_procedure);
1334: END IF;
1335: WHEN OTHERS THEN
1336: x_return_status := fnd_api.g_ret_sts_unexp_error;
1337:

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

1343: p_count => x_msg_count,
1344: p_data => x_msg_data);
1345:
1346: -- Debug info.
1347: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1349: p_msg_data=>x_msg_data,
1350: p_msg_type=>'SQL ERROR',
1351: p_msg_level=>fnd_log.level_error);

Line 1351: p_msg_level=>fnd_log.level_error);

1347: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1349: p_msg_data=>x_msg_data,
1350: p_msg_type=>'SQL ERROR',
1351: p_msg_level=>fnd_log.level_error);
1352: END IF;
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1355: p_prefix=>l_debug_prefix,

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

1349: p_msg_data=>x_msg_data,
1350: p_msg_type=>'SQL ERROR',
1351: p_msg_level=>fnd_log.level_error);
1352: END IF;
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1355: p_prefix=>l_debug_prefix,
1356: p_msg_level=>fnd_log.level_procedure);
1357: END IF;

Line 1356: p_msg_level=>fnd_log.level_procedure);

1352: END IF;
1353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1354: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
1355: p_prefix=>l_debug_prefix,
1356: p_msg_level=>fnd_log.level_procedure);
1357: END IF;
1358:
1359: end;
1360:

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

2074: END IF;
2075:
2076:
2077: -- Debug info.
2078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2079: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
2080: p_prefix=>l_debug_prefix,
2081: p_msg_level=>fnd_log.level_procedure);
2082: END IF;

Line 2081: p_msg_level=>fnd_log.level_procedure);

2077: -- Debug info.
2078: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2079: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(+)',
2080: p_prefix=>l_debug_prefix,
2081: p_msg_level=>fnd_log.level_procedure);
2082: END IF;
2083: /* moved to public api
2084: HZ_EXTRACT_BO_UTIL_PVT.validate_event_id(p_event_id => p_event_id,
2085: p_party_id => p_organization_id,

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

2122:
2123:
2124:
2125: -- Debug info.
2126: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2127: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2128: p_msg_data=>x_msg_data,
2129: p_msg_type=>'WARNING',
2130: p_msg_level=>fnd_log.level_exception);

Line 2130: p_msg_level=>fnd_log.level_exception);

2126: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2127: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2128: p_msg_data=>x_msg_data,
2129: p_msg_type=>'WARNING',
2130: p_msg_level=>fnd_log.level_exception);
2131: END IF;
2132:
2133: -- Debug info.
2134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2130: p_msg_level=>fnd_log.level_exception);
2131: END IF;
2132:
2133: -- Debug info.
2134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2135: hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
2136: p_prefix=>l_debug_prefix,
2137: p_msg_level=>fnd_log.level_procedure);
2138: END IF;

Line 2137: p_msg_level=>fnd_log.level_procedure);

2133: -- Debug info.
2134: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2135: hz_utility_v2pub.debug(p_message=>'get_organizations_updated (-)',
2136: p_prefix=>l_debug_prefix,
2137: p_msg_level=>fnd_log.level_procedure);
2138: END IF;
2139:
2140:
2141: EXCEPTION

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

2147: p_count => x_msg_count,
2148: p_data => x_msg_data);
2149:
2150: -- Debug info.
2151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2153: p_msg_data=>x_msg_data,
2154: p_msg_type=>'ERROR',
2155: p_msg_level=>fnd_log.level_error);

Line 2155: p_msg_level=>fnd_log.level_error);

2151: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2152: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2153: p_msg_data=>x_msg_data,
2154: p_msg_type=>'ERROR',
2155: p_msg_level=>fnd_log.level_error);
2156: END IF;
2157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2158: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2159: p_prefix=>l_debug_prefix,

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

2153: p_msg_data=>x_msg_data,
2154: p_msg_type=>'ERROR',
2155: p_msg_level=>fnd_log.level_error);
2156: END IF;
2157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2158: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2159: p_prefix=>l_debug_prefix,
2160: p_msg_level=>fnd_log.level_procedure);
2161: END IF;

Line 2160: p_msg_level=>fnd_log.level_procedure);

2156: END IF;
2157: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2158: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2159: p_prefix=>l_debug_prefix,
2160: p_msg_level=>fnd_log.level_procedure);
2161: END IF;
2162: WHEN fnd_api.g_exc_unexpected_error THEN
2163: x_return_status := fnd_api.g_ret_sts_unexp_error;
2164:

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

2166: p_count => x_msg_count,
2167: p_data => x_msg_data);
2168:
2169: -- Debug info.
2170: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2171: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2172: p_msg_data=>x_msg_data,
2173: p_msg_type=>'UNEXPECTED ERROR',
2174: p_msg_level=>fnd_log.level_error);

Line 2174: p_msg_level=>fnd_log.level_error);

2170: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2171: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2172: p_msg_data=>x_msg_data,
2173: p_msg_type=>'UNEXPECTED ERROR',
2174: p_msg_level=>fnd_log.level_error);
2175: END IF;
2176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2177: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2178: p_prefix=>l_debug_prefix,

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

2172: p_msg_data=>x_msg_data,
2173: p_msg_type=>'UNEXPECTED ERROR',
2174: p_msg_level=>fnd_log.level_error);
2175: END IF;
2176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2177: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2178: p_prefix=>l_debug_prefix,
2179: p_msg_level=>fnd_log.level_procedure);
2180: END IF;

Line 2179: p_msg_level=>fnd_log.level_procedure);

2175: END IF;
2176: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2177: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2178: p_prefix=>l_debug_prefix,
2179: p_msg_level=>fnd_log.level_procedure);
2180: END IF;
2181: WHEN OTHERS THEN
2182: x_return_status := fnd_api.g_ret_sts_unexp_error;
2183:

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

2189: p_count => x_msg_count,
2190: p_data => x_msg_data);
2191:
2192: -- Debug info.
2193: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2195: p_msg_data=>x_msg_data,
2196: p_msg_type=>'SQL ERROR',
2197: p_msg_level=>fnd_log.level_error);

Line 2197: p_msg_level=>fnd_log.level_error);

2193: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2195: p_msg_data=>x_msg_data,
2196: p_msg_type=>'SQL ERROR',
2197: p_msg_level=>fnd_log.level_error);
2198: END IF;
2199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2200: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2201: p_prefix=>l_debug_prefix,

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

2195: p_msg_data=>x_msg_data,
2196: p_msg_type=>'SQL ERROR',
2197: p_msg_level=>fnd_log.level_error);
2198: END IF;
2199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2200: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2201: p_prefix=>l_debug_prefix,
2202: p_msg_level=>fnd_log.level_procedure);
2203: END IF;

Line 2202: p_msg_level=>fnd_log.level_procedure);

2198: END IF;
2199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2200: hz_utility_v2pub.debug(p_message=>'get_organizations_updated(-)',
2201: p_prefix=>l_debug_prefix,
2202: p_msg_level=>fnd_log.level_procedure);
2203: END IF;
2204:
2205: end;
2206: