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 HZ_UTILITY_V2PUB

Line 64: * HZ_UTILITY_V2PUB.enable_debug

60: * DESCRIPTION
61: * Turn on debug mode.
62: *
63: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
64: * HZ_UTILITY_V2PUB.enable_debug
65: *
66: * MODIFICATION HISTORY
67: *
68: * 31-Oct-2001 Anupam Bordia o Created.

Line 79: HZ_UTILITY_V2PUB.enable_debug;

75:
76: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
77: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
78: THEN
79: HZ_UTILITY_V2PUB.enable_debug;
80: G_DEBUG := TRUE;
81: END IF;
82:
83: END enable_debug;

Line 93: * HZ_UTILITY_V2PUB.disable_debug

89: * DESCRIPTION
90: * Turn off debug mode.
91: *
92: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
93: * HZ_UTILITY_V2PUB.disable_debug
94: *
95: * MODIFICATION HISTORY
96: *
97: * 31-Oct-2001 Anupam Bordia o Created.

Line 106: HZ_UTILITY_V2PUB.disable_debug;

102:
103: BEGIN
104:
105: IF G_DEBUG THEN
106: HZ_UTILITY_V2PUB.disable_debug;
107: G_DEBUG := FALSE;
108: END IF;
109:
110: END disable_debug;

Line 233: hz_utility_v2pub.debug(p_message=>'maintain_self_node (+) node_id = '||p_node_id||' p_hierarchy_type = '||p_hierarchy_type ,

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

Line 251: hz_utility_v2pub.debug(p_message=>'l_start_date.count = '||l_start_date.count ,

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

Line 269: hz_utility_v2pub.debug(p_message=>'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc ,

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

Line 297: hz_utility_v2pub.debug(p_message=> 'before the initial sort ...' ,

293:
294:
295: -- Debug info.
296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
297: hz_utility_v2pub.debug(p_message=> 'before the initial sort ...' ,
298: p_prefix=>l_debug_prefix,
299: p_msg_level=>fnd_log.level_procedure);
300: END IF;
301:

Line 311: hz_utility_v2pub.debug(p_message=>'l_start_date = '||l_start_date(n)||' '||

307:
308: -- Debug info.
309: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
310: for n in 1..l_start_date.count loop
311: hz_utility_v2pub.debug(p_message=>'l_start_date = '||l_start_date(n)||' '||
312: 'l_end_date = '||l_end_date(n)||' '||
313: 'l_pc_flag = '||l_pc_flag(n),
314: p_prefix=>l_debug_prefix,
315: p_msg_level=>fnd_log.level_procedure);

Line 337: hz_utility_v2pub.debug(p_message=> 'l_pc_flag(i) = B' ,

333: l_line_number := 7;
334:
335: -- Debug info.
336: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
337: hz_utility_v2pub.debug(p_message=> 'l_pc_flag(i) = B' ,
338: p_prefix=>l_debug_prefix,
339: p_msg_level=>fnd_log.level_procedure);
340: END IF;
341:

Line 358: hz_utility_v2pub.debug(p_message=> 'l_pc_flag(i)=l_pc_flag(i+1)' ,

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

Line 391: hz_utility_v2pub.debug(p_message=> 'l_end_date(i) between ...' ,

387: l_line_number := 14;
388:
389: -- Debug info.
390: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
391: hz_utility_v2pub.debug(p_message=> 'l_end_date(i) between ...' ,
392: p_prefix=>l_debug_prefix,
393: p_msg_level=>fnd_log.level_procedure);
394: END IF;
395:

Line 458: hz_utility_v2pub.debug(p_message=> 'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc,

454: l_line_number := 19;
455:
456: -- Debug info.
457: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
458: hz_utility_v2pub.debug(p_message=> 'HZ_HIERARCHY_NODES_PKG.insert_row (+) l_tp = '||l_tp||' l_lc = '||l_lc,
459: p_prefix=>l_debug_prefix,
460: p_msg_level=>fnd_log.level_procedure);
461: END IF;
462:

Line 489: hz_utility_v2pub.debug(p_message=>'maintain_self_node (-)' ,

485: end if;
486:
487: -- Debug info.
488: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
489: hz_utility_v2pub.debug(p_message=>'maintain_self_node (-)' ,
490: p_prefix=>l_debug_prefix,
491: p_msg_level=>fnd_log.level_procedure);
492: END IF;
493:

Line 721: hz_utility_v2pub.debug(p_message=>'do_create_link (+)',

717: BEGIN
718:
719: -- Debug info.
720: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
721: hz_utility_v2pub.debug(p_message=>'do_create_link (+)',
722: p_prefix=> '',
723: p_msg_level=>fnd_log.level_procedure);
724: END IF;
725:

Line 768: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Parent(+)',

764: -- PARENT'S SELF NODE MAINTENANCE
765: ---------------------------------
766: -- Debug info.
767: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
768: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Parent(+)',
769: p_prefix=> '',
770: p_msg_level=>fnd_log.level_procedure);
771: END IF;
772:

Line 783: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Parent(-)',

779: );
780:
781: -- Debug info.
782: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
783: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Parent(-)',
784: p_prefix=> '',
785: p_msg_level=>fnd_log.level_procedure);
786: END IF;
787:

Line 793: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Child(+)',

789: -- CHILD'S SELF NODE MAINTENANCE
790: --------------------------------
791: -- Debug info.
792: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
793: hz_utility_v2pub.debug(p_message=>'maintain_self_node for Child(+)',
794: p_prefix=> '',
795: p_msg_level=>fnd_log.level_procedure);
796: END IF;
797:

Line 808: hz_utility_v2pub.debug(p_message=>'maintain_self_node for child (-)',

804: );
805:
806: -- Debug info.
807: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
808: hz_utility_v2pub.debug(p_message=>'maintain_self_node for child (-)',
809: p_prefix=> '',
810: p_msg_level=>fnd_log.level_procedure);
811: END IF;
812:

Line 841: hz_utility_v2pub.debug(p_message=>'Local Exception:'||SQLERRM,

837: l_existing_end_date := p_hierarchy_node_rec.effective_end_date;
838:
839: -- Debug info.
840: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
841: hz_utility_v2pub.debug(p_message=>'Local Exception:'||SQLERRM,
842: p_prefix=> '',
843: p_msg_level=>fnd_log.level_procedure);
844: END IF;
845:

Line 854: hz_utility_v2pub.debug(p_message=>'maintain indirect links (+)',

850: -- MAINTENANCE OF INDIRECT LINKS
851: --------------------------------
852: -- Debug info.
853: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
854: hz_utility_v2pub.debug(p_message=>'maintain indirect links (+)',
855: p_prefix=> '',
856: p_msg_level=>fnd_log.level_procedure);
857: END IF;
858:

Line 949: hz_utility_v2pub.debug(p_message=>'maintain indirect links (-)',

945:
946:
947: -- Debug info.
948: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
949: hz_utility_v2pub.debug(p_message=>'maintain indirect links (-)',
950: p_prefix=> '',
951: p_msg_level=>fnd_log.level_procedure);
952: END IF;
953:

Line 959: hz_utility_v2pub.debug(p_message=>'do_create_link (-)',

955: l_temp_end_date := l_effective_end_date_lc;
956:
957: -- Debug info.
958: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
959: hz_utility_v2pub.debug(p_message=>'do_create_link (-)',
960: p_prefix=> '',
961: p_msg_level=>fnd_log.level_procedure);
962: END IF;
963:

Line 1113: hz_utility_v2pub.debug

1109: l_counter NUMBER;
1110: BEGIN
1111: -- FND Logging for debug purpose
1112: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1113: hz_utility_v2pub.debug
1114: (p_message => 'Input : '||p_child_id||' : '||p_child_type||' : '||p_child_level,
1115: p_prefix => l_debug_prefix,
1116: p_msg_level => fnd_log.level_statement,
1117: p_module_prefix => l_module_prefix,

Line 1126: hz_utility_v2pub.debug

1122: OPEN get_parent_id_cur (p_child_id, p_child_type, p_child_table);
1123:
1124: -- FND Logging for debug purpose
1125: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1126: hz_utility_v2pub.debug
1127: (p_message => 'Open get_parent_id_cur for id : '||p_child_id,
1128: p_prefix => l_debug_prefix,
1129: p_msg_level => fnd_log.level_statement,
1130: p_module_prefix => l_module_prefix,

Line 1150: hz_utility_v2pub.debug

1146: -- infinite recursion). Break out if parent and child id are same.
1147: IF (p_child_id = l_parent_id) THEN
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 => 'Exit loop because parent child matched for level 1',
1152: p_prefix => l_debug_prefix,
1153: p_msg_level => fnd_log.level_statement,
1154: p_module_prefix => l_module_prefix,

Line 1165: hz_utility_v2pub.debug

1161: ELSE
1162:
1163: -- FND Logging for debug purpose
1164: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1165: hz_utility_v2pub.debug
1166: (p_message => 'Fetched for recursion : '||l_parent_id||' : '||l_parent_type||' : '||TO_CHAR(TO_NUMBER(p_child_level+1)),
1167: p_prefix => l_debug_prefix,
1168: p_msg_level => fnd_log.level_statement,
1169: p_module_prefix => l_module_prefix,

Line 1181: hz_utility_v2pub.debug

1177: ELSE
1178:
1179: -- FND Logging for debug purpose
1180: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1181: hz_utility_v2pub.debug
1182: (p_message => 'Exit Loop...',
1183: p_prefix => l_debug_prefix,
1184: p_msg_level => fnd_log.level_statement,
1185: p_module_prefix => l_module_prefix,

Line 1197: hz_utility_v2pub.debug

1193: END LOOP;
1194:
1195: -- FND Logging for debug purpose
1196: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1197: hz_utility_v2pub.debug
1198: (p_message => 'Close get_parent_id_cur for id : '||p_child_id,
1199: p_prefix => l_debug_prefix,
1200: p_msg_level => fnd_log.level_statement,
1201: p_module_prefix => l_module_prefix,

Line 1213: hz_utility_v2pub.debug(p_message=>'do_update_link_pvt (+)',

1209:
1210: BEGIN
1211: -- Debug info.
1212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1213: hz_utility_v2pub.debug(p_message=>'do_update_link_pvt (+)',
1214: p_prefix=>l_debug_prefix,
1215: p_msg_level=>fnd_log.level_procedure);
1216: END IF;
1217:

Line 1228: l_LAST_UPDATED_BY := HZ_UTILITY_V2PUB.last_updated_by;

1224: l_hierarchy_type := p_hierarchy_node_rec.hierarchy_type;
1225: l_parent_table := p_hierarchy_node_rec.parent_table_name;
1226: l_child_table := p_hierarchy_node_rec.child_table_name;
1227:
1228: l_LAST_UPDATED_BY := HZ_UTILITY_V2PUB.last_updated_by;
1229: l_LAST_UPDATE_DATE := HZ_UTILITY_V2PUB.last_update_date;
1230: l_LAST_UPDATE_LOGIN := HZ_UTILITY_V2PUB.last_update_login;
1231:
1232:

Line 1229: l_LAST_UPDATE_DATE := HZ_UTILITY_V2PUB.last_update_date;

1225: l_parent_table := p_hierarchy_node_rec.parent_table_name;
1226: l_child_table := p_hierarchy_node_rec.child_table_name;
1227:
1228: l_LAST_UPDATED_BY := HZ_UTILITY_V2PUB.last_updated_by;
1229: l_LAST_UPDATE_DATE := HZ_UTILITY_V2PUB.last_update_date;
1230: l_LAST_UPDATE_LOGIN := HZ_UTILITY_V2PUB.last_update_login;
1231:
1232:
1233: -- fetch existing effective start and end dates for relationship id

Line 1230: l_LAST_UPDATE_LOGIN := HZ_UTILITY_V2PUB.last_update_login;

1226: l_child_table := p_hierarchy_node_rec.child_table_name;
1227:
1228: l_LAST_UPDATED_BY := HZ_UTILITY_V2PUB.last_updated_by;
1229: l_LAST_UPDATE_DATE := HZ_UTILITY_V2PUB.last_update_date;
1230: l_LAST_UPDATE_LOGIN := HZ_UTILITY_V2PUB.last_update_login;
1231:
1232:
1233: -- fetch existing effective start and end dates for relationship id
1234: BEGIN

Line 1248: hz_utility_v2pub.debug(p_message=>'Local Exception:'||SQLERRM,

1244: l_existing_end_date := p_hierarchy_node_rec.effective_end_date;
1245:
1246: -- Debug info.
1247: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1248: hz_utility_v2pub.debug(p_message=>'Local Exception:'||SQLERRM,
1249: p_prefix=>l_debug_prefix,
1250: p_msg_level=>fnd_log.level_procedure);
1251: END IF;
1252:

Line 1263: hz_utility_v2pub.debug(p_message=>'do_recursive_parent_fetch (+)',

1259: parent_list_tbl(1).level_number := 0;
1260:
1261: -- Debug info.
1262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1263: hz_utility_v2pub.debug(p_message=>'do_recursive_parent_fetch (+)',
1264: p_prefix=>l_debug_prefix,
1265: p_msg_level=>fnd_log.level_procedure);
1266: END IF;
1267:

Line 1272: hz_utility_v2pub.debug(p_message=>'do_recursive_parent_fetch (-)',

1268: do_recursive_parent_fetch(l_parent_id, l_parent_type, l_parent_table, l_level);
1269:
1270: -- Debug info.
1271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1272: hz_utility_v2pub.debug(p_message=>'do_recursive_parent_fetch (-)',
1273: p_prefix=>l_debug_prefix,
1274: p_msg_level=>fnd_log.level_procedure);
1275: END IF;
1276:

Line 1319: hz_utility_v2pub.debug(p_message=>'do_update_link_pvt (-)',

1315: END IF;
1316:
1317: -- Debug info.
1318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1319: hz_utility_v2pub.debug(p_message=>'do_update_link_pvt (-)',
1320: p_prefix=>l_debug_prefix,
1321: p_msg_level=>fnd_log.level_procedure);
1322: END IF;
1323:

Line 1474: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.last_updated_by,

1470: LOOP
1471: UPDATE HZ_HIERARCHY_NODES
1472: SET EFFECTIVE_START_DATE = NVL(p_hierarchy_node_rec.effective_start_date, EFFECTIVE_START_DATE),
1473: EFFECTIVE_END_DATE = NVL(p_hierarchy_node_rec.effective_end_date, EFFECTIVE_END_DATE),
1474: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.last_updated_by,
1475: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.last_update_date,
1476: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.last_update_login
1477: WHERE PARENT_ID = r_get_all_parents.parent_id
1478: AND PARENT_TABLE_NAME = r_get_all_parents.parent_table_name

Line 1475: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.last_update_date,

1471: UPDATE HZ_HIERARCHY_NODES
1472: SET EFFECTIVE_START_DATE = NVL(p_hierarchy_node_rec.effective_start_date, EFFECTIVE_START_DATE),
1473: EFFECTIVE_END_DATE = NVL(p_hierarchy_node_rec.effective_end_date, EFFECTIVE_END_DATE),
1474: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.last_updated_by,
1475: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.last_update_date,
1476: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.last_update_login
1477: WHERE PARENT_ID = r_get_all_parents.parent_id
1478: AND PARENT_TABLE_NAME = r_get_all_parents.parent_table_name
1479: AND PARENT_OBJECT_TYPE = r_get_all_parents.parent_object_type

Line 1476: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.last_update_login

1472: SET EFFECTIVE_START_DATE = NVL(p_hierarchy_node_rec.effective_start_date, EFFECTIVE_START_DATE),
1473: EFFECTIVE_END_DATE = NVL(p_hierarchy_node_rec.effective_end_date, EFFECTIVE_END_DATE),
1474: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.last_updated_by,
1475: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.last_update_date,
1476: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.last_update_login
1477: WHERE PARENT_ID = r_get_all_parents.parent_id
1478: AND PARENT_TABLE_NAME = r_get_all_parents.parent_table_name
1479: AND PARENT_OBJECT_TYPE = r_get_all_parents.parent_object_type
1480: AND CHILD_ID = r_get_all_children.child_id

Line 1585: hz_utility_v2pub.debug(p_message=>'create_link (+)',

1581: --enable_debug;
1582:
1583: -- Debug info.
1584: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1585: hz_utility_v2pub.debug(p_message=>'create_link (+)',
1586: p_prefix=>l_debug_prefix,
1587: p_msg_level=>fnd_log.level_procedure);
1588: END IF;
1589:

Line 1609: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1605: p_data => x_msg_data);
1606:
1607: -- Debug info.
1608: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1609: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1610: p_msg_data=>x_msg_data,
1611: p_msg_type=>'WARNING',
1612: p_msg_level=>fnd_log.level_exception);
1613: END IF;

Line 1615: hz_utility_v2pub.debug(p_message=>'create_link (-)',

1611: p_msg_type=>'WARNING',
1612: p_msg_level=>fnd_log.level_exception);
1613: END IF;
1614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1615: hz_utility_v2pub.debug(p_message=>'create_link (-)',
1616: p_prefix=>l_debug_prefix,
1617: p_msg_level=>fnd_log.level_procedure);
1618: END IF;
1619:

Line 1635: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1631: p_data => x_msg_data);
1632:
1633: -- Debug info.
1634: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1635: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1636: p_msg_data=>x_msg_data,
1637: p_msg_type=>'ERROR',
1638: p_msg_level=>fnd_log.level_error);
1639: END IF;

Line 1642: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,

1638: p_msg_level=>fnd_log.level_error);
1639: END IF;
1640:
1641: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1642: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,
1643: p_prefix=>l_debug_prefix,
1644: p_msg_level=>fnd_log.level_procedure);
1645: END IF;
1646:

Line 1658: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 1665: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,

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

Line 1684: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 1691: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' create_link (-)' ,

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

Line 1747: hz_utility_v2pub.debug(p_message=>'update_link (+)',

1743: --enable_debug;
1744:
1745: -- Debug info.
1746: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1747: hz_utility_v2pub.debug(p_message=>'update_link (+)',
1748: p_prefix=>l_debug_prefix,
1749: p_msg_level=>fnd_log.level_procedure);
1750: END IF;
1751:

Line 1771: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1767: p_data => x_msg_data);
1768:
1769: -- Debug info.
1770: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1771: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1772: p_msg_data=>x_msg_data,
1773: p_msg_type=>'WARNING',
1774: p_msg_level=>fnd_log.level_exception);
1775: END IF;

Line 1777: hz_utility_v2pub.debug(p_message=>'update_link (-)',

1773: p_msg_type=>'WARNING',
1774: p_msg_level=>fnd_log.level_exception);
1775: END IF;
1776: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1777: hz_utility_v2pub.debug(p_message=>'update_link (-)',
1778: p_prefix=>l_debug_prefix,
1779: p_msg_level=>fnd_log.level_procedure);
1780: END IF;
1781:

Line 1796: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1792: p_data => x_msg_data);
1793:
1794: -- Debug info.
1795: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
1796: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1797: p_msg_data=>x_msg_data,
1798: p_msg_type=>'ERROR',
1799: p_msg_level=>fnd_log.level_error);
1800: END IF;

Line 1803: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,

1799: p_msg_level=>fnd_log.level_error);
1800: END IF;
1801:
1802: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1803: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,
1804: p_prefix=>l_debug_prefix,
1805: p_msg_level=>fnd_log.level_procedure);
1806:
1807: END IF;

Line 1819: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 1826: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,

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

Line 1845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

Line 1852: hz_utility_v2pub.debug(p_message=> 'l_line_number = '||l_line_number||' update_link (-)' ,

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