APPS.FUN_RULE_OBJECTS_PUB dependencies on FND_LOG

Line 1591: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1587: l_param_value VARCHAR2(1);
1588:
1589:
1590: BEGIN
1591: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1592: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.rule_object_instance_exists', FALSE);
1593: end if;
1594:
1595: /*

Line 1592: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.rule_object_instance_exists', FALSE);

1588:
1589:
1590: BEGIN
1591: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1592: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start FUN_RULE_PUB.rule_object_instance_exists', FALSE);
1593: end if;
1594:
1595: /*
1596: Bug 7040957 - re_written the routine to avoid high parsing as dynamic code is not required under

Line 1620: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1616:
1617: EXCEPTION
1618:
1619: WHEN TOO_MANY_ROWS THEN
1620: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1621: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.rule_object_instance_exists:->TO_MANY_ROWS', FALSE);
1622: END IF;
1623: return TRUE;
1624:

Line 1621: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.rule_object_instance_exists:->TO_MANY_ROWS', FALSE);

1617: EXCEPTION
1618:
1619: WHEN TOO_MANY_ROWS THEN
1620: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1621: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.rule_object_instance_exists:->TO_MANY_ROWS', FALSE);
1622: END IF;
1623: return TRUE;
1624:
1625: WHEN NO_DATA_FOUND THEN

Line 1626: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1622: END IF;
1623: return TRUE;
1624:
1625: WHEN NO_DATA_FOUND THEN
1626: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1627: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.rule_object_instance_exists:->NO_DATA_FOUND', FALSE);
1628: END IF;
1629: return FALSE;
1630:

Line 1627: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.rule_object_instance_exists:->NO_DATA_FOUND', FALSE);

1623: return TRUE;
1624:
1625: WHEN NO_DATA_FOUND THEN
1626: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1627: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.rule_object_instance_exists:->NO_DATA_FOUND', FALSE);
1628: END IF;
1629: return FALSE;
1630:
1631: WHEN OTHERS THEN

Line 1633: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1629: return FALSE;
1630:
1631: WHEN OTHERS THEN
1632:
1633: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1634: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.rule_object_instance_exists:->'||SQLERRM, FALSE);
1635: END IF;
1636: RAISE;
1637: END rule_object_instance_exists;

Line 1634: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.rule_object_instance_exists:->'||SQLERRM, FALSE);

1630:
1631: WHEN OTHERS THEN
1632:
1633: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1634: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION , 'FUN_RULE_PUB.rule_object_instance_exists:->'||SQLERRM, FALSE);
1635: END IF;
1636: RAISE;
1637: END rule_object_instance_exists;
1638:

Line 1680: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1676: return_value VARCHAR2(1);
1677:
1678: BEGIN
1679:
1680: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1681: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start of FUN_RULE_PUB.rule_object_instance_exists', FALSE);
1682: end if;
1683:
1684: if(rule_object_instance_exists(p_application_id,p_rule_object_name,p_instance_label,p_org_id) = TRUE) then

Line 1681: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start of FUN_RULE_PUB.rule_object_instance_exists', FALSE);

1677:
1678: BEGIN
1679:
1680: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1681: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'Start of FUN_RULE_PUB.rule_object_instance_exists', FALSE);
1682: end if;
1683:
1684: if(rule_object_instance_exists(p_application_id,p_rule_object_name,p_instance_label,p_org_id) = TRUE) then
1685: return_value:='Y';

Line 1690: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1686: else
1687: return_value:='N';
1688: end if;
1689:
1690: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1691: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End of FUN_RULE_PUB.rule_object_instance_exists', FALSE);
1692: end if;
1693:
1694: return return_value;

Line 1691: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End of FUN_RULE_PUB.rule_object_instance_exists', FALSE);

1687: return_value:='N';
1688: end if;
1689:
1690: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1691: fnd_log.message(FND_LOG.LEVEL_STATEMENT, 'End of FUN_RULE_PUB.rule_object_instance_exists', FALSE);
1692: end if;
1693:
1694: return return_value;
1695: