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 234: hz_utility_v2pub.debug(p_message=>'maintain_self_node (+) node_id = '||p_node_id||' p_hierarchy_type = '||p_hierarchy_type ,

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;
238:

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

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;
257:

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

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;
275:

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

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;
306:

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

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),
319: p_prefix=>l_debug_prefix,
320: p_msg_level=>fnd_log.level_procedure);

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

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;
346: --Bug#8744353

Line 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) ' ,

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;
360:

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

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;
384:

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

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;
417:

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

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;
484:

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

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;
515:

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

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;
747:

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

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;
794:

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

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;
809:

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

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;
819:

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

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;
834:

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

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;
867:

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

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;
880:

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

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;
977:

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

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;
987:

Line 1137: hz_utility_v2pub.debug

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,
1141: p_module_prefix => l_module_prefix,

Line 1150: hz_utility_v2pub.debug

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,
1154: p_module_prefix => l_module_prefix,

Line 1174: hz_utility_v2pub.debug

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,
1178: p_module_prefix => l_module_prefix,

Line 1189: hz_utility_v2pub.debug

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,
1193: p_module_prefix => l_module_prefix,

Line 1205: hz_utility_v2pub.debug

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,
1209: p_module_prefix => l_module_prefix,

Line 1221: hz_utility_v2pub.debug

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,
1225: p_module_prefix => l_module_prefix,

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

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;
1241:

Line 1252: l_LAST_UPDATED_BY := HZ_UTILITY_V2PUB.last_updated_by;

1248: l_hierarchy_type := p_hierarchy_node_rec.hierarchy_type;
1249: l_parent_table := p_hierarchy_node_rec.parent_table_name;
1250: l_child_table := p_hierarchy_node_rec.child_table_name;
1251:
1252: l_LAST_UPDATED_BY := HZ_UTILITY_V2PUB.last_updated_by;
1253: l_LAST_UPDATE_DATE := HZ_UTILITY_V2PUB.last_update_date;
1254: l_LAST_UPDATE_LOGIN := HZ_UTILITY_V2PUB.last_update_login;
1255:
1256:

Line 1253: l_LAST_UPDATE_DATE := HZ_UTILITY_V2PUB.last_update_date;

1249: l_parent_table := p_hierarchy_node_rec.parent_table_name;
1250: l_child_table := p_hierarchy_node_rec.child_table_name;
1251:
1252: l_LAST_UPDATED_BY := HZ_UTILITY_V2PUB.last_updated_by;
1253: l_LAST_UPDATE_DATE := HZ_UTILITY_V2PUB.last_update_date;
1254: l_LAST_UPDATE_LOGIN := HZ_UTILITY_V2PUB.last_update_login;
1255:
1256:
1257: -- fetch existing effective start and end dates for relationship id

Line 1254: l_LAST_UPDATE_LOGIN := HZ_UTILITY_V2PUB.last_update_login;

1250: l_child_table := p_hierarchy_node_rec.child_table_name;
1251:
1252: l_LAST_UPDATED_BY := HZ_UTILITY_V2PUB.last_updated_by;
1253: l_LAST_UPDATE_DATE := HZ_UTILITY_V2PUB.last_update_date;
1254: l_LAST_UPDATE_LOGIN := HZ_UTILITY_V2PUB.last_update_login;
1255:
1256:
1257: -- fetch existing effective start and end dates for relationship id
1258: BEGIN

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

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;
1276:

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

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;
1291:

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

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;
1300:

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

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;
1347:

Line 1498: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.last_updated_by,

1494: LOOP
1495: UPDATE HZ_HIERARCHY_NODES
1496: SET EFFECTIVE_START_DATE = NVL(p_hierarchy_node_rec.effective_start_date, EFFECTIVE_START_DATE),
1497: EFFECTIVE_END_DATE = NVL(p_hierarchy_node_rec.effective_end_date, EFFECTIVE_END_DATE),
1498: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.last_updated_by,
1499: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.last_update_date,
1500: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.last_update_login
1501: WHERE PARENT_ID = r_get_all_parents.parent_id
1502: AND PARENT_TABLE_NAME = r_get_all_parents.parent_table_name

Line 1499: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.last_update_date,

1495: UPDATE HZ_HIERARCHY_NODES
1496: SET EFFECTIVE_START_DATE = NVL(p_hierarchy_node_rec.effective_start_date, EFFECTIVE_START_DATE),
1497: EFFECTIVE_END_DATE = NVL(p_hierarchy_node_rec.effective_end_date, EFFECTIVE_END_DATE),
1498: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.last_updated_by,
1499: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.last_update_date,
1500: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.last_update_login
1501: WHERE PARENT_ID = r_get_all_parents.parent_id
1502: AND PARENT_TABLE_NAME = r_get_all_parents.parent_table_name
1503: AND PARENT_OBJECT_TYPE = r_get_all_parents.parent_object_type

Line 1500: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.last_update_login

1496: SET EFFECTIVE_START_DATE = NVL(p_hierarchy_node_rec.effective_start_date, EFFECTIVE_START_DATE),
1497: EFFECTIVE_END_DATE = NVL(p_hierarchy_node_rec.effective_end_date, EFFECTIVE_END_DATE),
1498: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.last_updated_by,
1499: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.last_update_date,
1500: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.last_update_login
1501: WHERE PARENT_ID = r_get_all_parents.parent_id
1502: AND PARENT_TABLE_NAME = r_get_all_parents.parent_table_name
1503: AND PARENT_OBJECT_TYPE = r_get_all_parents.parent_object_type
1504: AND CHILD_ID = r_get_all_children.child_id

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

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;
1613:

Line 1633: hz_utility_v2pub.debug_return_messages(p_msg_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);
1637: END IF;

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

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;
1643:

Line 1659: hz_utility_v2pub.debug_return_messages(p_msg_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);
1663: END IF;

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

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;
1670:

Line 1682: hz_utility_v2pub.debug_return_messages(p_msg_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);
1686: END IF;

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

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;
1693:

Line 1708: hz_utility_v2pub.debug_return_messages(p_msg_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);
1712: END IF;

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

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;
1719:

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

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;
1775:

Line 1795: hz_utility_v2pub.debug_return_messages(p_msg_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);
1799: END IF;

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

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;
1805:

Line 1820: hz_utility_v2pub.debug_return_messages(p_msg_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);
1824: END IF;

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

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:
1831: END IF;

Line 1843: hz_utility_v2pub.debug_return_messages(p_msg_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);
1847: END IF;

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

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;
1854:

Line 1869: hz_utility_v2pub.debug_return_messages(p_msg_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);
1873: END IF;

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

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:
1880: END IF;