DBA Data[Home] [Help]

APPS.IEX_UWQ_PROM_ENUMS_PVT dependencies on FND_LOG

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

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

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

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

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

663:
664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
668: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
669: End if;
670: RAISE;
671:

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

664:
665: EXCEPTION
666: WHEN OTHERS THEN
667: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
668: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
669: End if;
670: RAISE;
671:
672: END ENUMERATE_CU_PROM_NODES;

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

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

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

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

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

1014:
1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1019: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
1020: End if;
1021: RAISE;
1022:

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

1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN
1018: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1019: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
1020: End if;
1021: RAISE;
1022:
1023: END ENUMERATE_ACC_PROM_NODES;

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

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

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

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

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

1352:
1353:
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1357: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
1358: End if;
1359: RAISE;
1360:

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

1353:
1354: EXCEPTION
1355: WHEN OTHERS THEN
1356: if( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1357: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, 'iex', 'An error was encountered - '||SQLCODE||' -ERROR- '||SQLERRM );
1358: End if;
1359: RAISE;
1360:
1361: END ENUMERATE_BILLTO_PROM_NODES;

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

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

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

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