APPS.IEX_UWQ_PROM_ENUMS_PVT dependencies on IEX_DEBUG_PUB

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

585: l_ld_list(l_node_counter).NODE_DEPTH := 1;
586:
587:
588: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
589: iex_debug_pub.LogMessage('ENUMERATE_CU_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
590: END IF;
591:
592: l_node_counter := l_node_counter + 1;
593: l_EnableNodes := NVL(FND_PROFILE.VALUE('IEX_ENABLE_UWQ_STATUS'),'N');

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

646:
647: l_ld_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
648:
649: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
650: iex_debug_pub.LogMessage('ENUMERATE_CU_PROM_NODES: Subnode final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
651: END IF;
652:
653:
654: l_node_counter := l_node_counter + 1;

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

924: l_ld_list(l_node_counter).NODE_DEPTH := 1;
925:
926:
927: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
928: iex_debug_pub.LogMessage('ENUMERATE_ACC_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
929: END IF;
930:
931:
932: -- !!

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

995:
996: l_ld_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
997:
998: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
999: iex_debug_pub.LogMessage('ENUMERATE_ACC_PROM_NODES: Subnode final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
1000: END IF;
1001:
1002: l_node_counter := l_node_counter + 1;
1003: END LOOP;

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

1264: l_ld_list(l_node_counter).HIDE_IF_EMPTY := '';
1265: l_ld_list(l_node_counter).NODE_DEPTH := 1;
1266:
1267: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1268: iex_debug_pub.LogMessage('ENUMERATE_BILLTO_PROM_NODES: main final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
1269: END IF;
1270:
1271: -- !!
1272: -- !!!!!!!!!! BUILDING SUB NODES WHERE CLAUSE

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

1335: l_ld_list(l_node_counter).RES_CAT_ENUM_FLAG := 'N';
1336:
1337:
1338: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1339: iex_debug_pub.LogMessage('ENUMERATE_BILLTO_PROM_NODES: Subnode final where clause: ' || l_ld_list(l_node_counter).WHERE_CLAUSE);
1340: END IF;
1341:
1342: l_node_counter := l_node_counter + 1;
1343: END LOOP;

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

1431:
1432:
1433:
1434: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1435: iex_debug_pub.LogMessage('RESOURCES_WHERE_CLAUSE: final where clause: ' || l_security_where );
1436: END IF;
1437:
1438: return l_security_where;
1439:

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

1438: return l_security_where;
1439:
1440: EXCEPTION WHEN OTHERS THEN
1441: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1442: iex_debug_pub.LogMessage('Error occurred while constructing the where clause ' || sqlerrm);
1443: END IF;
1444:
1445: return null;
1446: