DBA Data[Home] [Help]

APPS.IEX_UWQ_PROM_ENUMS_PVT dependencies on FND_LOG

Line 644: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

640: l_ld_list(l_node_counter).HIDE_IF_EMPTY := '';
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;

Line 714: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

710: l_ld_list(l_node_counter).NODE_DEPTH := 2;
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:

Line 732: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

728:
729:
730: EXCEPTION
731: WHEN OTHERS THEN
732: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
733: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
734: End if;
735: RAISE;
736:

Line 733: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );

729:
730: EXCEPTION
731: WHEN OTHERS THEN
732: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
733: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
734: End if;
735: RAISE;
736:
737: END ENUMERATE_CU_PROM_NODES;

Line 1028: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1024: l_ld_list(l_node_counter).HIDE_IF_EMPTY := '';
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:

Line 1108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1104: l_ld_list(l_node_counter).NODE_DEPTH := 2;
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;

Line 1128: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1124:
1125:
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1129: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
1130: End if;
1131: RAISE;
1132:

Line 1129: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );

1125:
1126: EXCEPTION
1127: WHEN OTHERS THEN
1128: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1129: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
1130: End if;
1131: RAISE;
1132:
1133: END ENUMERATE_ACC_PROM_NODES;

Line 1414: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1410: l_ld_list(l_node_counter).NODE_TYPE := 0;
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: -- !!

Line 1495: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

Line 1513: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

1509:
1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1514: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
1515: End if;
1516: RAISE;
1517:

Line 1514: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );

1510:
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1514: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
1515: End if;
1516: RAISE;
1517:
1518: END ENUMERATE_BILLTO_PROM_NODES;

Line 1591: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

Line 1603: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

1599: return null;
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;