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

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

229:
230: begin
231:
232: -- Debug info.
233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug(p_message=>'maintain_self_node (+) node_id = '||p_node_id||' p_hierarchy_type = '||p_hierarchy_type ,
235: p_prefix=>l_debug_prefix,
236: p_msg_level=>fnd_log.level_procedure);
237: END IF;

Line 236: p_msg_level=>fnd_log.level_procedure);

232: -- Debug info.
233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
234: hz_utility_v2pub.debug(p_message=>'maintain_self_node (+) node_id = '||p_node_id||' p_hierarchy_type = '||p_hierarchy_type ,
235: p_prefix=>l_debug_prefix,
236: p_msg_level=>fnd_log.level_procedure);
237: END IF;
238:
239:
240: delete from hz_hierarchy_nodes

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

248: fetch c_dates bulk collect into l_start_date,l_end_date,l_pc_flag;
249: close c_dates;
250:
251: -- Debug info.
252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
253: hz_utility_v2pub.debug(p_message=>'l_start_date.count = '||l_start_date.count ,
254: p_prefix=>l_debug_prefix,
255: p_msg_level=>fnd_log.level_procedure);
256: END IF;

Line 255: p_msg_level=>fnd_log.level_procedure);

251: -- Debug info.
252: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
253: hz_utility_v2pub.debug(p_message=>'l_start_date.count = '||l_start_date.count ,
254: p_prefix=>l_debug_prefix,
255: p_msg_level=>fnd_log.level_procedure);
256: END IF;
257:
258:
259: if l_start_date.count=1

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

266: else l_lc:='Y';
267: end if;
268:
269: -- Debug info.
270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
271: hz_utility_v2pub.debug(p_message=>'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc ,
272: p_prefix=>l_debug_prefix,
273: p_msg_level=>fnd_log.level_procedure);
274: END IF;

Line 273: p_msg_level=>fnd_log.level_procedure);

269: -- Debug info.
270: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
271: hz_utility_v2pub.debug(p_message=>'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc ,
272: p_prefix=>l_debug_prefix,
273: p_msg_level=>fnd_log.level_procedure);
274: END IF;
275:
276: HZ_HIERARCHY_NODES_PKG.Insert_Row(
277: X_ROWID => l_rowid,

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

297: elsif l_start_date.count > 1 then -- multiple nodes present
298:
299:
300: -- Debug info.
301: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
302: hz_utility_v2pub.debug(p_message=> 'before the initial sort ...' ,
303: p_prefix=>l_debug_prefix,
304: p_msg_level=>fnd_log.level_procedure);
305: END IF;

Line 304: p_msg_level=>fnd_log.level_procedure);

300: -- Debug info.
301: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
302: hz_utility_v2pub.debug(p_message=> 'before the initial sort ...' ,
303: p_prefix=>l_debug_prefix,
304: p_msg_level=>fnd_log.level_procedure);
305: END IF;
306:
307:
308: l_line_number := 5;

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

310: -- sort the nodes
311: sort(l_start_date,l_end_date,l_pc_flag);
312:
313: -- Debug info.
314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
315: for n in 1..l_start_date.count loop
316: hz_utility_v2pub.debug(p_message=>'l_start_date = '||l_start_date(n)||' '||
317: 'l_end_date = '||l_end_date(n)||' '||
318: 'l_pc_flag = '||l_pc_flag(n),

Line 320: p_msg_level=>fnd_log.level_procedure);

316: hz_utility_v2pub.debug(p_message=>'l_start_date = '||l_start_date(n)||' '||
317: 'l_end_date = '||l_end_date(n)||' '||
318: 'l_pc_flag = '||l_pc_flag(n),
319: p_prefix=>l_debug_prefix,
320: p_msg_level=>fnd_log.level_procedure);
321: end loop;
322: END IF;
323:
324: l_line_number := 6;

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

337: then
338: l_line_number := 7;
339:
340: -- Debug info.
341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
342: hz_utility_v2pub.debug(p_message=> 'l_pc_flag(i) = B' ,
343: p_prefix=>l_debug_prefix,
344: p_msg_level=>fnd_log.level_procedure);
345: END IF;

Line 344: p_msg_level=>fnd_log.level_procedure);

340: -- Debug info.
341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
342: hz_utility_v2pub.debug(p_message=> 'l_pc_flag(i) = B' ,
343: p_prefix=>l_debug_prefix,
344: p_msg_level=>fnd_log.level_procedure);
345: END IF;
346: --Bug#8744353
347: --When l_pc_flag = 'B' (both) then check next record and if it falls
348: --in same date range then make next record flag as 'B'.

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

351: THEN
352: l_pc_flag(i+1) := 'B';
353:
354: -- Debug info.
355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
356: hz_utility_v2pub.debug(p_message=> 'l_start_date(i+1), l_end_date(i+1) between l_start_date(i), l_end_date(i) ' ,
357: p_prefix=>l_debug_prefix,
358: p_msg_level=>fnd_log.level_procedure);
359: END IF;

Line 358: p_msg_level=>fnd_log.level_procedure);

354: -- Debug info.
355: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
356: hz_utility_v2pub.debug(p_message=> 'l_start_date(i+1), l_end_date(i+1) between l_start_date(i), l_end_date(i) ' ,
357: p_prefix=>l_debug_prefix,
358: p_msg_level=>fnd_log.level_procedure);
359: END IF;
360:
361: ELSE
362: l_start_date(i+1):=l_end_date(i);

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

375: then
376: l_line_number := 10;
377:
378: -- Debug info.
379: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
380: hz_utility_v2pub.debug(p_message=> 'l_pc_flag(i)=l_pc_flag(i+1)' ,
381: p_prefix=>l_debug_prefix,
382: p_msg_level=>fnd_log.level_procedure);
383: END IF;

Line 382: p_msg_level=>fnd_log.level_procedure);

378: -- Debug info.
379: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
380: hz_utility_v2pub.debug(p_message=> 'l_pc_flag(i)=l_pc_flag(i+1)' ,
381: p_prefix=>l_debug_prefix,
382: p_msg_level=>fnd_log.level_procedure);
383: END IF;
384:
385:
386: if (l_end_date(i) between l_start_date(i+1) and l_end_date(i+1))

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

408: then
409: l_line_number := 14;
410:
411: -- Debug info.
412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
413: hz_utility_v2pub.debug(p_message=> 'l_end_date(i) between ...' ,
414: p_prefix=>l_debug_prefix,
415: p_msg_level=>fnd_log.level_procedure);
416: END IF;

Line 415: p_msg_level=>fnd_log.level_procedure);

411: -- Debug info.
412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
413: hz_utility_v2pub.debug(p_message=> 'l_end_date(i) between ...' ,
414: p_prefix=>l_debug_prefix,
415: p_msg_level=>fnd_log.level_procedure);
416: END IF;
417:
418:
419: if l_end_date(i+1)>l_end_date(i)

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

475:
476: l_line_number := 19;
477:
478: -- Debug info.
479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
480: hz_utility_v2pub.debug(p_message=> 'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc,
481: p_prefix=>l_debug_prefix,
482: p_msg_level=>fnd_log.level_procedure);
483: END IF;

Line 482: p_msg_level=>fnd_log.level_procedure);

478: -- Debug info.
479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
480: hz_utility_v2pub.debug(p_message=> 'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc,
481: p_prefix=>l_debug_prefix,
482: p_msg_level=>fnd_log.level_procedure);
483: END IF;
484:
485:
486: HZ_HIERARCHY_NODES_PKG.Insert_Row(

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

506:
507: end if;
508:
509: -- Debug info.
510: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
511: hz_utility_v2pub.debug(p_message=>'maintain_self_node (-)' ,
512: p_prefix=>l_debug_prefix,
513: p_msg_level=>fnd_log.level_procedure);
514: END IF;

Line 513: p_msg_level=>fnd_log.level_procedure);

509: -- Debug info.
510: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
511: hz_utility_v2pub.debug(p_message=>'maintain_self_node (-)' ,
512: p_prefix=>l_debug_prefix,
513: p_msg_level=>fnd_log.level_procedure);
514: END IF;
515:
516: end maintain_self_node;
517:

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

738:
739: BEGIN
740:
741: -- Debug info.
742: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'do_create_link (+)',
744: p_prefix=> '',
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;

Line 745: p_msg_level=>fnd_log.level_procedure);

741: -- Debug info.
742: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'do_create_link (+)',
744: p_prefix=> '',
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;
747:
748: -- when this procedure is called, the request is to incorporate a relation
749: -- between AAA and BBB in a hierarchy (defined by relationship type) where

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

785: ---------------------------------
786: -- PARENT'S SELF NODE MAINTENANCE
787: ---------------------------------
788: -- Debug info.
789: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
790: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Parent(+)',
791: p_prefix=> '',
792: p_msg_level=>fnd_log.level_procedure);
793: END IF;

Line 792: p_msg_level=>fnd_log.level_procedure);

788: -- Debug info.
789: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
790: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Parent(+)',
791: p_prefix=> '',
792: p_msg_level=>fnd_log.level_procedure);
793: END IF;
794:
795: maintain_self_node (
796: p_node_id => p_hierarchy_node_rec.parent_id,

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

800: p_actual_content_source => p_hierarchy_node_rec.actual_content_source
801: );
802:
803: -- Debug info.
804: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
805: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Parent(-)',
806: p_prefix=> '',
807: p_msg_level=>fnd_log.level_procedure);
808: END IF;

Line 807: p_msg_level=>fnd_log.level_procedure);

803: -- Debug info.
804: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
805: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Parent(-)',
806: p_prefix=> '',
807: p_msg_level=>fnd_log.level_procedure);
808: END IF;
809:
810: --------------------------------
811: -- CHILD'S SELF NODE MAINTENANCE

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

810: --------------------------------
811: -- CHILD'S SELF NODE MAINTENANCE
812: --------------------------------
813: -- Debug info.
814: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
815: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Child(+)',
816: p_prefix=> '',
817: p_msg_level=>fnd_log.level_procedure);
818: END IF;

Line 817: p_msg_level=>fnd_log.level_procedure);

813: -- Debug info.
814: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
815: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Child(+)',
816: p_prefix=> '',
817: p_msg_level=>fnd_log.level_procedure);
818: END IF;
819:
820: maintain_self_node (
821: p_node_id => p_hierarchy_node_rec.child_id,

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

825: p_actual_content_source => p_hierarchy_node_rec.actual_content_source
826: );
827:
828: -- Debug info.
829: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
830: hz_utility_v2pub.debug(p_message=>'maintain_self_node for child (-)',
831: p_prefix=> '',
832: p_msg_level=>fnd_log.level_procedure);
833: END IF;

Line 832: p_msg_level=>fnd_log.level_procedure);

828: -- Debug info.
829: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
830: hz_utility_v2pub.debug(p_message=>'maintain_self_node for child (-)',
831: p_prefix=> '',
832: p_msg_level=>fnd_log.level_procedure);
833: END IF;
834:
835: -- Bug 4902909.
836: -- we'll get the parents and children of the relationship,

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

858: l_existing_start_date := p_hierarchy_node_rec.effective_start_date;
859: l_existing_end_date := p_hierarchy_node_rec.effective_end_date;
860:
861: -- Debug info.
862: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
863: hz_utility_v2pub.debug(p_message=>'Local Exception:'||SQLERRM,
864: p_prefix=> '',
865: p_msg_level=>fnd_log.level_procedure);
866: END IF;

Line 865: p_msg_level=>fnd_log.level_procedure);

861: -- Debug info.
862: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
863: hz_utility_v2pub.debug(p_message=>'Local Exception:'||SQLERRM,
864: p_prefix=> '',
865: p_msg_level=>fnd_log.level_procedure);
866: END IF;
867:
868: END;
869:

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

871: --------------------------------
872: -- MAINTENANCE OF INDIRECT LINKS
873: --------------------------------
874: -- Debug info.
875: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
876: hz_utility_v2pub.debug(p_message=>'maintain indirect links (+)',
877: p_prefix=> '',
878: p_msg_level=>fnd_log.level_procedure);
879: END IF;

Line 878: p_msg_level=>fnd_log.level_procedure);

874: -- Debug info.
875: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
876: hz_utility_v2pub.debug(p_message=>'maintain indirect links (+)',
877: p_prefix=> '',
878: p_msg_level=>fnd_log.level_procedure);
879: END IF;
880:
881: -- first we'll get all the parents of AAA (this will include AAA itself)
882: OPEN c_get_all_parents;

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

968: CLOSE c_get_all_parents;
969:
970:
971: -- Debug info.
972: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
973: hz_utility_v2pub.debug(p_message=>'maintain indirect links (-)',
974: p_prefix=> '',
975: p_msg_level=>fnd_log.level_procedure);
976: END IF;

Line 975: p_msg_level=>fnd_log.level_procedure);

971: -- Debug info.
972: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
973: hz_utility_v2pub.debug(p_message=>'maintain indirect links (-)',
974: p_prefix=> '',
975: p_msg_level=>fnd_log.level_procedure);
976: END IF;
977:
978: l_temp_start_date := l_effective_start_date_lc;
979: l_temp_end_date := l_effective_end_date_lc;

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

978: l_temp_start_date := l_effective_start_date_lc;
979: l_temp_end_date := l_effective_end_date_lc;
980:
981: -- Debug info.
982: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
983: hz_utility_v2pub.debug(p_message=>'do_create_link (-)',
984: p_prefix=> '',
985: p_msg_level=>fnd_log.level_procedure);
986: END IF;

Line 985: p_msg_level=>fnd_log.level_procedure);

981: -- Debug info.
982: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
983: hz_utility_v2pub.debug(p_message=>'do_create_link (-)',
984: p_prefix=> '',
985: p_msg_level=>fnd_log.level_procedure);
986: END IF;
987:
988: END do_create_link;
989:

Line 1135: -- FND Logging for debug purpose

1131: l_parent_level NUMBER;
1132: l_parent_table VARCHAR2(100);
1133: l_counter NUMBER;
1134: BEGIN
1135: -- FND Logging for debug purpose
1136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1137: hz_utility_v2pub.debug
1138: (p_message => 'Input : '||p_child_id||' : '||p_child_type||' : '||p_child_level,
1139: p_prefix => l_debug_prefix,

Line 1136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1132: l_parent_table VARCHAR2(100);
1133: l_counter NUMBER;
1134: BEGIN
1135: -- FND Logging for debug purpose
1136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1137: hz_utility_v2pub.debug
1138: (p_message => 'Input : '||p_child_id||' : '||p_child_type||' : '||p_child_level,
1139: p_prefix => l_debug_prefix,
1140: p_msg_level => fnd_log.level_statement,

Line 1140: p_msg_level => fnd_log.level_statement,

1136: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1137: hz_utility_v2pub.debug
1138: (p_message => 'Input : '||p_child_id||' : '||p_child_type||' : '||p_child_level,
1139: p_prefix => l_debug_prefix,
1140: p_msg_level => fnd_log.level_statement,
1141: p_module_prefix => l_module_prefix,
1142: p_module => l_module
1143: );
1144: END IF;

Line 1148: -- FND Logging for debug purpose

1144: END IF;
1145:
1146: OPEN get_parent_id_cur (p_child_id, p_child_type, p_child_table);
1147:
1148: -- FND Logging for debug purpose
1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1150: hz_utility_v2pub.debug
1151: (p_message => 'Open get_parent_id_cur for id : '||p_child_id,
1152: p_prefix => l_debug_prefix,

Line 1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1145:
1146: OPEN get_parent_id_cur (p_child_id, p_child_type, p_child_table);
1147:
1148: -- FND Logging for debug purpose
1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1150: hz_utility_v2pub.debug
1151: (p_message => 'Open get_parent_id_cur for id : '||p_child_id,
1152: p_prefix => l_debug_prefix,
1153: p_msg_level => fnd_log.level_statement,

Line 1153: p_msg_level => fnd_log.level_statement,

1149: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1150: hz_utility_v2pub.debug
1151: (p_message => 'Open get_parent_id_cur for id : '||p_child_id,
1152: p_prefix => l_debug_prefix,
1153: p_msg_level => fnd_log.level_statement,
1154: p_module_prefix => l_module_prefix,
1155: p_module => l_module
1156: );
1157: END IF;

Line 1172: -- FND Logging for debug purpose

1168:
1169: -- Fix for Bug 5204188 (Parent Id and Child Id same at level =1, so it goes
1170: -- infinite recursion). Break out if parent and child id are same.
1171: IF (p_child_id = l_parent_id) THEN
1172: -- FND Logging for debug purpose
1173: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1174: hz_utility_v2pub.debug
1175: (p_message => 'Exit loop because parent child matched for level 1',
1176: p_prefix => l_debug_prefix,

Line 1173: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1169: -- Fix for Bug 5204188 (Parent Id and Child Id same at level =1, so it goes
1170: -- infinite recursion). Break out if parent and child id are same.
1171: IF (p_child_id = l_parent_id) THEN
1172: -- FND Logging for debug purpose
1173: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1174: hz_utility_v2pub.debug
1175: (p_message => 'Exit loop because parent child matched for level 1',
1176: p_prefix => l_debug_prefix,
1177: p_msg_level => fnd_log.level_statement,

Line 1177: p_msg_level => fnd_log.level_statement,

1173: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1174: hz_utility_v2pub.debug
1175: (p_message => 'Exit loop because parent child matched for level 1',
1176: p_prefix => l_debug_prefix,
1177: p_msg_level => fnd_log.level_statement,
1178: p_module_prefix => l_module_prefix,
1179: p_module => l_module
1180: );
1181: END IF;

Line 1187: -- FND Logging for debug purpose

1183: EXIT;
1184:
1185: ELSE
1186:
1187: -- FND Logging for debug purpose
1188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1189: hz_utility_v2pub.debug
1190: (p_message => 'Fetched for recursion : '||l_parent_id||' : '||l_parent_type||' : '||TO_CHAR(TO_NUMBER(p_child_level+1)),
1191: p_prefix => l_debug_prefix,

Line 1188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1184:
1185: ELSE
1186:
1187: -- FND Logging for debug purpose
1188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1189: hz_utility_v2pub.debug
1190: (p_message => 'Fetched for recursion : '||l_parent_id||' : '||l_parent_type||' : '||TO_CHAR(TO_NUMBER(p_child_level+1)),
1191: p_prefix => l_debug_prefix,
1192: p_msg_level => fnd_log.level_statement,

Line 1192: p_msg_level => fnd_log.level_statement,

1188: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1189: hz_utility_v2pub.debug
1190: (p_message => 'Fetched for recursion : '||l_parent_id||' : '||l_parent_type||' : '||TO_CHAR(TO_NUMBER(p_child_level+1)),
1191: p_prefix => l_debug_prefix,
1192: p_msg_level => fnd_log.level_statement,
1193: p_module_prefix => l_module_prefix,
1194: p_module => l_module
1195: );
1196: END IF;

Line 1203: -- FND Logging for debug purpose

1199: END IF;
1200:
1201: ELSE
1202:
1203: -- FND Logging for debug purpose
1204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1205: hz_utility_v2pub.debug
1206: (p_message => 'Exit Loop...',
1207: p_prefix => l_debug_prefix,

Line 1204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1200:
1201: ELSE
1202:
1203: -- FND Logging for debug purpose
1204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1205: hz_utility_v2pub.debug
1206: (p_message => 'Exit Loop...',
1207: p_prefix => l_debug_prefix,
1208: p_msg_level => fnd_log.level_statement,

Line 1208: p_msg_level => fnd_log.level_statement,

1204: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1205: hz_utility_v2pub.debug
1206: (p_message => 'Exit Loop...',
1207: p_prefix => l_debug_prefix,
1208: p_msg_level => fnd_log.level_statement,
1209: p_module_prefix => l_module_prefix,
1210: p_module => l_module
1211: );
1212: END IF;

Line 1219: -- FND Logging for debug purpose

1215: END IF;
1216:
1217: END LOOP;
1218:
1219: -- FND Logging for debug purpose
1220: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1221: hz_utility_v2pub.debug
1222: (p_message => 'Close get_parent_id_cur for id : '||p_child_id,
1223: p_prefix => l_debug_prefix,

Line 1220: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1216:
1217: END LOOP;
1218:
1219: -- FND Logging for debug purpose
1220: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1221: hz_utility_v2pub.debug
1222: (p_message => 'Close get_parent_id_cur for id : '||p_child_id,
1223: p_prefix => l_debug_prefix,
1224: p_msg_level => fnd_log.level_statement,

Line 1224: p_msg_level => fnd_log.level_statement,

1220: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1221: hz_utility_v2pub.debug
1222: (p_message => 'Close get_parent_id_cur for id : '||p_child_id,
1223: p_prefix => l_debug_prefix,
1224: p_msg_level => fnd_log.level_statement,
1225: p_module_prefix => l_module_prefix,
1226: p_module => l_module
1227: );
1228: END IF;

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

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

Line 1239: p_msg_level=>fnd_log.level_procedure);

1235: -- Debug info.
1236: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1237: hz_utility_v2pub.debug(p_message=>'do_update_link_pvt (+)',
1238: p_prefix=>l_debug_prefix,
1239: p_msg_level=>fnd_log.level_procedure);
1240: END IF;
1241:
1242: -- initialize variables
1243: l_parent_id := p_hierarchy_node_rec.parent_id;

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

1267: l_existing_start_date := p_hierarchy_node_rec.effective_start_date;
1268: l_existing_end_date := p_hierarchy_node_rec.effective_end_date;
1269:
1270: -- Debug info.
1271: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1272: hz_utility_v2pub.debug(p_message=>'Local Exception:'||SQLERRM,
1273: p_prefix=>l_debug_prefix,
1274: p_msg_level=>fnd_log.level_procedure);
1275: END IF;

Line 1274: p_msg_level=>fnd_log.level_procedure);

1270: -- Debug info.
1271: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1272: hz_utility_v2pub.debug(p_message=>'Local Exception:'||SQLERRM,
1273: p_prefix=>l_debug_prefix,
1274: p_msg_level=>fnd_log.level_procedure);
1275: END IF;
1276:
1277: END;
1278:

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

1282: parent_list_tbl(1).parent_table := l_parent_table;
1283: parent_list_tbl(1).level_number := 0;
1284:
1285: -- Debug info.
1286: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1287: hz_utility_v2pub.debug(p_message=>'do_recursive_parent_fetch (+)',
1288: p_prefix=>l_debug_prefix,
1289: p_msg_level=>fnd_log.level_procedure);
1290: END IF;

Line 1289: p_msg_level=>fnd_log.level_procedure);

1285: -- Debug info.
1286: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1287: hz_utility_v2pub.debug(p_message=>'do_recursive_parent_fetch (+)',
1288: p_prefix=>l_debug_prefix,
1289: p_msg_level=>fnd_log.level_procedure);
1290: END IF;
1291:
1292: do_recursive_parent_fetch(l_parent_id, l_parent_type, l_parent_table, l_level);
1293:

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

1291:
1292: do_recursive_parent_fetch(l_parent_id, l_parent_type, l_parent_table, l_level);
1293:
1294: -- Debug info.
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'do_recursive_parent_fetch (-)',
1297: p_prefix=>l_debug_prefix,
1298: p_msg_level=>fnd_log.level_procedure);
1299: END IF;

Line 1298: p_msg_level=>fnd_log.level_procedure);

1294: -- Debug info.
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'do_recursive_parent_fetch (-)',
1297: p_prefix=>l_debug_prefix,
1298: p_msg_level=>fnd_log.level_procedure);
1299: END IF;
1300:
1301: -- dbms_output.put_line('Table data:');
1302: IF (parent_list_tbl IS NOT NULL) THEN

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

1338: END IF;
1339: END IF;
1340:
1341: -- Debug info.
1342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1343: hz_utility_v2pub.debug(p_message=>'do_update_link_pvt (-)',
1344: p_prefix=>l_debug_prefix,
1345: p_msg_level=>fnd_log.level_procedure);
1346: END IF;

Line 1345: p_msg_level=>fnd_log.level_procedure);

1341: -- Debug info.
1342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1343: hz_utility_v2pub.debug(p_message=>'do_update_link_pvt (-)',
1344: p_prefix=>l_debug_prefix,
1345: p_msg_level=>fnd_log.level_procedure);
1346: END IF;
1347:
1348: END do_update_link_pvt;
1349: ------------------------------------------------------------------------------+

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

1604: -- Check if API is called in debug mode. If yes, enable debug.
1605: --enable_debug;
1606:
1607: -- Debug info.
1608: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1609: hz_utility_v2pub.debug(p_message=>'create_link (+)',
1610: p_prefix=>l_debug_prefix,
1611: p_msg_level=>fnd_log.level_procedure);
1612: END IF;

Line 1611: p_msg_level=>fnd_log.level_procedure);

1607: -- Debug info.
1608: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1609: hz_utility_v2pub.debug(p_message=>'create_link (+)',
1610: p_prefix=>l_debug_prefix,
1611: p_msg_level=>fnd_log.level_procedure);
1612: END IF;
1613:
1614: -- initialize message list if p_init_msg_list is set to TRUE.
1615: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1628: p_count => x_msg_count,
1629: p_data => x_msg_data);
1630:
1631: -- Debug info.
1632: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1633: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1634: p_msg_data=>x_msg_data,
1635: p_msg_type=>'WARNING',
1636: p_msg_level=>fnd_log.level_exception);

Line 1636: p_msg_level=>fnd_log.level_exception);

1632: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1633: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1634: p_msg_data=>x_msg_data,
1635: p_msg_type=>'WARNING',
1636: p_msg_level=>fnd_log.level_exception);
1637: END IF;
1638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1639: hz_utility_v2pub.debug(p_message=>'create_link (-)',
1640: p_prefix=>l_debug_prefix,

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

1634: p_msg_data=>x_msg_data,
1635: p_msg_type=>'WARNING',
1636: p_msg_level=>fnd_log.level_exception);
1637: END IF;
1638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1639: hz_utility_v2pub.debug(p_message=>'create_link (-)',
1640: p_prefix=>l_debug_prefix,
1641: p_msg_level=>fnd_log.level_procedure);
1642: END IF;

Line 1641: p_msg_level=>fnd_log.level_procedure);

1637: END IF;
1638: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1639: hz_utility_v2pub.debug(p_message=>'create_link (-)',
1640: p_prefix=>l_debug_prefix,
1641: p_msg_level=>fnd_log.level_procedure);
1642: END IF;
1643:
1644:
1645: -- Check if API is called in debug mode. If yes, disable debug.

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

1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656:
1657: -- Debug info.
1658: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1660: p_msg_data=>x_msg_data,
1661: p_msg_type=>'ERROR',
1662: p_msg_level=>fnd_log.level_error);

Line 1662: p_msg_level=>fnd_log.level_error);

1658: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1660: p_msg_data=>x_msg_data,
1661: p_msg_type=>'ERROR',
1662: p_msg_level=>fnd_log.level_error);
1663: END IF;
1664:
1665: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1666: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,

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

1661: p_msg_type=>'ERROR',
1662: p_msg_level=>fnd_log.level_error);
1663: END IF;
1664:
1665: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1666: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,
1667: p_prefix=>l_debug_prefix,
1668: p_msg_level=>fnd_log.level_procedure);
1669: END IF;

Line 1668: p_msg_level=>fnd_log.level_procedure);

1664:
1665: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1666: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,
1667: p_prefix=>l_debug_prefix,
1668: p_msg_level=>fnd_log.level_procedure);
1669: END IF;
1670:
1671:
1672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1677: p_count => x_msg_count,
1678: p_data => x_msg_data);
1679:
1680: -- Debug info.
1681: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1682: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1683: p_msg_data=>x_msg_data,
1684: p_msg_type=>'ERROR',
1685: p_msg_level=>fnd_log.level_error);

Line 1685: p_msg_level=>fnd_log.level_error);

1681: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1682: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1683: p_msg_data=>x_msg_data,
1684: p_msg_type=>'ERROR',
1685: p_msg_level=>fnd_log.level_error);
1686: END IF;
1687:
1688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1689: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,

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

1684: p_msg_type=>'ERROR',
1685: p_msg_level=>fnd_log.level_error);
1686: END IF;
1687:
1688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1689: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,
1690: p_prefix=>l_debug_prefix,
1691: p_msg_level=>fnd_log.level_procedure);
1692: END IF;

Line 1691: p_msg_level=>fnd_log.level_procedure);

1687:
1688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1689: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,
1690: p_prefix=>l_debug_prefix,
1691: p_msg_level=>fnd_log.level_procedure);
1692: END IF;
1693:
1694:
1695: WHEN OTHERS THEN

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

1703: p_count => x_msg_count,
1704: p_data => x_msg_data);
1705:
1706: -- Debug info.
1707: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1708: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1709: p_msg_data=>x_msg_data,
1710: p_msg_type=>'ERROR',
1711: p_msg_level=>fnd_log.level_error);

Line 1711: p_msg_level=>fnd_log.level_error);

1707: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1708: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1709: p_msg_data=>x_msg_data,
1710: p_msg_type=>'ERROR',
1711: p_msg_level=>fnd_log.level_error);
1712: END IF;
1713:
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,

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

1710: p_msg_type=>'ERROR',
1711: p_msg_level=>fnd_log.level_error);
1712: END IF;
1713:
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,
1716: p_prefix=>l_debug_prefix,
1717: p_msg_level=>fnd_log.level_procedure);
1718: END IF;

Line 1717: p_msg_level=>fnd_log.level_procedure);

1713:
1714: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1715: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,
1716: p_prefix=>l_debug_prefix,
1717: p_msg_level=>fnd_log.level_procedure);
1718: END IF;
1719:
1720:
1721: END create_link;

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

1766: -- Check if API is called in debug mode. If yes, enable debug.
1767: --enable_debug;
1768:
1769: -- Debug info.
1770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1771: hz_utility_v2pub.debug(p_message=>'update_link (+)',
1772: p_prefix=>l_debug_prefix,
1773: p_msg_level=>fnd_log.level_procedure);
1774: END IF;

Line 1773: p_msg_level=>fnd_log.level_procedure);

1769: -- Debug info.
1770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1771: hz_utility_v2pub.debug(p_message=>'update_link (+)',
1772: p_prefix=>l_debug_prefix,
1773: p_msg_level=>fnd_log.level_procedure);
1774: END IF;
1775:
1776: -- initialize message list if p_init_msg_list is set to TRUE.
1777: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

1790: p_count => x_msg_count,
1791: p_data => x_msg_data);
1792:
1793: -- Debug info.
1794: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1795: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1796: p_msg_data=>x_msg_data,
1797: p_msg_type=>'WARNING',
1798: p_msg_level=>fnd_log.level_exception);

Line 1798: p_msg_level=>fnd_log.level_exception);

1794: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1795: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1796: p_msg_data=>x_msg_data,
1797: p_msg_type=>'WARNING',
1798: p_msg_level=>fnd_log.level_exception);
1799: END IF;
1800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1801: hz_utility_v2pub.debug(p_message=>'update_link (-)',
1802: p_prefix=>l_debug_prefix,

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

1796: p_msg_data=>x_msg_data,
1797: p_msg_type=>'WARNING',
1798: p_msg_level=>fnd_log.level_exception);
1799: END IF;
1800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1801: hz_utility_v2pub.debug(p_message=>'update_link (-)',
1802: p_prefix=>l_debug_prefix,
1803: p_msg_level=>fnd_log.level_procedure);
1804: END IF;

Line 1803: p_msg_level=>fnd_log.level_procedure);

1799: END IF;
1800: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1801: hz_utility_v2pub.debug(p_message=>'update_link (-)',
1802: p_prefix=>l_debug_prefix,
1803: p_msg_level=>fnd_log.level_procedure);
1804: END IF;
1805:
1806: -- Check if API is called in debug mode. If yes, disable debug.
1807: --disable_debug;

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

1815: p_count => x_msg_count,
1816: p_data => x_msg_data);
1817:
1818: -- Debug info.
1819: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1820: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1821: p_msg_data=>x_msg_data,
1822: p_msg_type=>'ERROR',
1823: p_msg_level=>fnd_log.level_error);

Line 1823: p_msg_level=>fnd_log.level_error);

1819: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1820: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1821: p_msg_data=>x_msg_data,
1822: p_msg_type=>'ERROR',
1823: p_msg_level=>fnd_log.level_error);
1824: END IF;
1825:
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,

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

1822: p_msg_type=>'ERROR',
1823: p_msg_level=>fnd_log.level_error);
1824: END IF;
1825:
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure);
1830:

Line 1829: p_msg_level=>fnd_log.level_procedure);

1825:
1826: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,
1828: p_prefix=>l_debug_prefix,
1829: p_msg_level=>fnd_log.level_procedure);
1830:
1831: END IF;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1838: p_count => x_msg_count,
1839: p_data => x_msg_data);
1840:
1841: -- Debug info.
1842: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1843: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1844: p_msg_data=>x_msg_data,
1845: p_msg_type=>'ERROR',
1846: p_msg_level=>fnd_log.level_error);

Line 1846: p_msg_level=>fnd_log.level_error);

1842: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1843: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1844: p_msg_data=>x_msg_data,
1845: p_msg_type=>'ERROR',
1846: p_msg_level=>fnd_log.level_error);
1847: END IF;
1848:
1849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1850: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,

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

1845: p_msg_type=>'ERROR',
1846: p_msg_level=>fnd_log.level_error);
1847: END IF;
1848:
1849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1850: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,
1851: p_prefix=>l_debug_prefix,
1852: p_msg_level=>fnd_log.level_procedure);
1853: END IF;

Line 1852: p_msg_level=>fnd_log.level_procedure);

1848:
1849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1850: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,
1851: p_prefix=>l_debug_prefix,
1852: p_msg_level=>fnd_log.level_procedure);
1853: END IF;
1854:
1855:
1856: WHEN OTHERS THEN

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

1864: p_count => x_msg_count,
1865: p_data => x_msg_data);
1866:
1867: -- Debug info.
1868: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1869: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1870: p_msg_data=>x_msg_data,
1871: p_msg_type=>'ERROR',
1872: p_msg_level=>fnd_log.level_error);

Line 1872: p_msg_level=>fnd_log.level_error);

1868: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1869: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1870: p_msg_data=>x_msg_data,
1871: p_msg_type=>'ERROR',
1872: p_msg_level=>fnd_log.level_error);
1873: END IF;
1874:
1875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1876: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,

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

1871: p_msg_type=>'ERROR',
1872: p_msg_level=>fnd_log.level_error);
1873: END IF;
1874:
1875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1876: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,
1877: p_prefix=>l_debug_prefix,
1878: p_msg_level=>fnd_log.level_procedure);
1879:

Line 1878: p_msg_level=>fnd_log.level_procedure);

1874:
1875: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1876: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,
1877: p_prefix=>l_debug_prefix,
1878: p_msg_level=>fnd_log.level_procedure);
1879:
1880: END IF;
1881:
1882: END update_link;