APPS.IEX_UWQ_PROM_ENUMS_PVT dependencies on IEX_DEBUG_PUB

Line 645: iex_debug_pub.LogMessage('ENUMERATE_CU_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);

641: l_ld_list(l_node_counter).NODE_DEPTH := 1;
642:
643:
644: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
645: iex_debug_pub.LogMessage('ENUMERATE_CU_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
646: END IF;
647:
648: l_node_counter := l_node_counter + 1;
649: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');

Line 715: iex_debug_pub.LogMessage('ENUMERATE_CU_PROM_NODES: Subnode final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);

711:
712: l_ld_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
713:
714: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
715: iex_debug_pub.LogMessage('ENUMERATE_CU_PROM_NODES: Subnode final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
716: END IF;
717:
718:
719: l_node_counter := l_node_counter + 1;

Line 1029: iex_debug_pub.LogMessage('ENUMERATE_ACC_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);

1025: l_ld_list(l_node_counter).NODE_DEPTH := 1;
1026:
1027:
1028: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1029: iex_debug_pub.LogMessage('ENUMERATE_ACC_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
1030: END IF;
1031:
1032:
1033: -- !!

Line 1109: iex_debug_pub.LogMessage('ENUMERATE_ACC_PROM_NODES: Subnode final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);

1105:
1106: l_ld_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
1107:
1108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1109: iex_debug_pub.LogMessage('ENUMERATE_ACC_PROM_NODES: Subnode final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
1110: END IF;
1111:
1112: l_node_counter := l_node_counter + 1;
1113: END LOOP;

Line 1415: iex_debug_pub.LogMessage('ENUMERATE_BILLTO_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);

1411: l_ld_list(l_node_counter).HIDE_IF_EMPTY := '';
1412: l_ld_list(l_node_counter).NODE_DEPTH := 1;
1413:
1414: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1415: iex_debug_pub.LogMessage('ENUMERATE_BILLTO_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
1416: END IF;
1417:
1418: -- !!
1419: -- !!!!!!!!!! BUILDING SUB NODES WHERE CLAUSE

Line 1496: iex_debug_pub.LogMessage('ENUMERATE_BILLTO_PROM_NODES: Subnode final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);

1492: l_ld_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
1493:
1494:
1495: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1496: iex_debug_pub.LogMessage('ENUMERATE_BILLTO_PROM_NODES: Subnode final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
1497: END IF;
1498:
1499: l_node_counter := l_node_counter + 1;
1500: END LOOP;

Line 1592: iex_debug_pub.LogMessage('RESOURCES_WHERE_CLAUSE: final where clause: ' || l_security_where );

1588:
1589:
1590:
1591: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1592: iex_debug_pub.LogMessage('RESOURCES_WHERE_CLAUSE: final where clause: ' || l_security_where );
1593: END IF;
1594: -- Start for bug 8538637 PNAVEENK 11-8-2009
1595: if l_security_where is not null then
1596: l_security_where := 'and ' || l_security_where;

Line 1604: iex_debug_pub.LogMessage('Error occurred while constructing the where clause ' || sqlerrm);

1600: end if;
1601: -- end for bug 8538637
1602: EXCEPTION WHEN OTHERS THEN
1603: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1604: iex_debug_pub.LogMessage('Error occurred while constructing the where clause ' || sqlerrm);
1605: END IF;
1606:
1607: return null;
1608: