DBA Data[Home] [Help]

APPS.POS_SUPPLIER_USER_REG_PKG dependencies on FND_LOG

Line 56: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

52: OPEN l_cur;
53: FETCH l_cur INTO l_num;
54: IF l_cur%found THEN
55: CLOSE l_cur;
56: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
57: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' ||
58: lv_proc_name, 'Responsibility Security Attribute for resp_id=' ||
59: p_resp_id || ' and attribute_code=' || p_sec_attr_code || ' exists.'
60: );

Line 57: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' ||

53: FETCH l_cur INTO l_num;
54: IF l_cur%found THEN
55: CLOSE l_cur;
56: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
57: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' ||
58: lv_proc_name, 'Responsibility Security Attribute for resp_id=' ||
59: p_resp_id || ' and attribute_code=' || p_sec_attr_code || ' exists.'
60: );
61: END IF;

Line 66: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

62: RETURN;
63: END IF;
64: CLOSE l_cur;
65:
66: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
67: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
68: 'Creating Responsibility Security Attribute for resp_id=' || p_resp_id ||
69: ' and attribute_code=' || p_sec_attr_code
70: );

Line 67: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,

63: END IF;
64: CLOSE l_cur;
65:
66: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
67: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
68: 'Creating Responsibility Security Attribute for resp_id=' || p_resp_id ||
69: ' and attribute_code=' || p_sec_attr_code
70: );
71: END IF;

Line 97: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

93: fnd_global.login_id
94: );
95:
96:
97: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
98: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
99: 'Responsibility Security Attribute created');
100: END IF;
101:

Line 98: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,

94: );
95:
96:
97: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
98: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
99: 'Responsibility Security Attribute created');
100: END IF;
101:
102: END create_resp_sec_attr_ifneeded;

Line 147: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

143: FETCH l_cur INTO l_num;
144: IF l_cur%found THEN
145: CLOSE l_cur;
146:
147: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
148: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
149: 'No need to set Responsibility Security Attribute value for resp_id=' ||
150: p_resp_id || ' and attribute_code=' || p_sec_attr_code
151: );

Line 148: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,

144: IF l_cur%found THEN
145: CLOSE l_cur;
146:
147: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
148: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
149: 'No need to set Responsibility Security Attribute value for resp_id=' ||
150: p_resp_id || ' and attribute_code=' || p_sec_attr_code
151: );
152: END IF;

Line 158: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

154: RETURN;
155: END IF;
156: CLOSE l_cur;
157:
158: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
159: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
160: 'Setting Responsibility Security Attribute value for resp_id=' ||
161: p_resp_id || ' and attribute_code=' || p_sec_attr_code);
162: END IF;

Line 159: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,

155: END IF;
156: CLOSE l_cur;
157:
158: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
159: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
160: 'Setting Responsibility Security Attribute value for resp_id=' ||
161: p_resp_id || ' and attribute_code=' || p_sec_attr_code);
162: END IF;
163:

Line 184: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

180: p_number_value
181: );
182:
183:
184: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
185: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
186: 'Responsibility Security Attribute value set'
187: );
188: END IF;

Line 185: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,

181: );
182:
183:
184: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
185: fnd_log.string(fnd_log.level_procedure,g_log_module_name || '.' || lv_proc_name,
186: 'Responsibility Security Attribute value set'
187: );
188: END IF;
189:

Line 226: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

222: FETCH l_app_id_cur INTO l_isp_appl_id;
223: IF l_app_id_cur%notfound THEN
224: CLOSE l_app_id_cur;
225:
226: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
227: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' || lv_proc_name,
228: 'Application ID for POS is not found');
229: END IF;
230:

Line 227: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' || lv_proc_name,

223: IF l_app_id_cur%notfound THEN
224: CLOSE l_app_id_cur;
225:
226: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
227: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' || lv_proc_name,
228: 'Application ID for POS is not found');
229: END IF;
230:
231: RAISE NO_DATA_FOUND;

Line 306: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

302: FETCH l_resp_id_cur INTO ln_resp_id;
303: CLOSE l_resp_id_cur;
304: IF ln_resp_id IS NULL THEN
305:
306: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
307: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' ||
308: lv_proc_name, 'Invalid responsibility key ' || p_resp_key);
309: END IF;
310:

Line 307: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' ||

303: CLOSE l_resp_id_cur;
304: IF ln_resp_id IS NULL THEN
305:
306: IF ( fnd_log.level_exception >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
307: fnd_log.string(fnd_log.level_exception, g_log_module_name || '.' ||
308: lv_proc_name, 'Invalid responsibility key ' || p_resp_key);
309: END IF;
310:
311: RETURN;

Line 1568: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1564: lv_flag := ''; -- we want it to be case sensitive for now.
1565: If (owa_pattern.match(lv_external_web_agent,lv_pattern, lv_flag)) then
1566: -- The external profile still points to icx web site.
1567:
1568: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1569: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'Setting user level APPS_WEB_AGENT profile option value');
1570: END IF;
1571:
1572: IF ( fnd_profile.save( x_name => 'APPS_WEB_AGENT',

Line 1569: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'Setting user level APPS_WEB_AGENT profile option value');

1565: If (owa_pattern.match(lv_external_web_agent,lv_pattern, lv_flag)) then
1566: -- The external profile still points to icx web site.
1567:
1568: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1569: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'Setting user level APPS_WEB_AGENT profile option value');
1570: END IF;
1571:
1572: IF ( fnd_profile.save( x_name => 'APPS_WEB_AGENT',
1573: x_value => lv_external_web_agent,

Line 1577: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1573: x_value => lv_external_web_agent,
1574: x_level_name => 'USER',
1575: x_level_value => p_userid ) ) THEN
1576:
1577: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1578: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value set');
1579: END IF;
1580:
1581: ELSE

Line 1578: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value set');

1574: x_level_name => 'USER',
1575: x_level_value => p_userid ) ) THEN
1576:
1577: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1578: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value set');
1579: END IF;
1580:
1581: ELSE
1582:

Line 1583: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1579: END IF;
1580:
1581: ELSE
1582:
1583: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1584: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value fail');
1585: END IF;
1586:
1587: END IF;

Line 1584: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value fail');

1580:
1581: ELSE
1582:
1583: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1584: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value fail');
1585: END IF;
1586:
1587: END IF;
1588:

Line 1595: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1591: x_value => lv_ext_servlet_agent,
1592: x_level_name => 'USER',
1593: x_level_value => p_userid ) ) THEN
1594:
1595: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1596: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value set');
1597: END IF;
1598:
1599: ELSE

Line 1596: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value set');

1592: x_level_name => 'USER',
1593: x_level_value => p_userid ) ) THEN
1594:
1595: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1596: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value set');
1597: END IF;
1598:
1599: ELSE
1600:

Line 1601: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1597: END IF;
1598:
1599: ELSE
1600:
1601: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1602: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value fail');
1603: END IF;
1604:
1605: END IF;

Line 1602: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value fail');

1598:
1599: ELSE
1600:
1601: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1602: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value fail');
1603: END IF;
1604:
1605: END IF;
1606:

Line 1613: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1609: x_value => lv_ext_servlet_agent,
1610: x_level_name => 'USER',
1611: x_level_value => p_userid ) ) THEN
1612:
1613: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1614: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value set');
1615: END IF;
1616:
1617: ELSE

Line 1614: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value set');

1610: x_level_name => 'USER',
1611: x_level_value => p_userid ) ) THEN
1612:
1613: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1614: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value set');
1615: END IF;
1616:
1617: ELSE
1618:

Line 1619: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1615: END IF;
1616:
1617: ELSE
1618:
1619: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1620: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');
1621: END IF;
1622:
1623: END IF;

Line 1620: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');

1616:
1617: ELSE
1618:
1619: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1620: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');
1621: END IF;
1622:
1623: END IF;
1624: ELSE

Line 1630: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1626: x_value => lv_ext_servlet_agent,
1627: x_level_name => 'USER',
1628: x_level_value => p_userid ) ) THEN
1629:
1630: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1631: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value set');
1632: END IF;
1633:
1634: ELSE

Line 1631: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value set');

1627: x_level_name => 'USER',
1628: x_level_value => p_userid ) ) THEN
1629:
1630: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1631: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value set');
1632: END IF;
1633:
1634: ELSE
1635:

Line 1636: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1632: END IF;
1633:
1634: ELSE
1635:
1636: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1637: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');
1638: END IF;
1639:
1640: END IF;

Line 1637: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');

1633:
1634: ELSE
1635:
1636: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1637: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');
1638: END IF;
1639:
1640: END IF;
1641: -- set only the framework agent. there is no way to set web agent

Line 1649: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1645: x_value => lv_ext_servlet_agent,
1646: x_level_name => 'USER',
1647: x_level_value => p_userid ) ) THEN
1648:
1649: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1650: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value set');
1651: END IF;
1652:
1653: ELSE

Line 1650: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value set');

1646: x_level_name => 'USER',
1647: x_level_value => p_userid ) ) THEN
1648:
1649: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1650: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value set');
1651: END IF;
1652:
1653: ELSE
1654:

Line 1655: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1651: END IF;
1652:
1653: ELSE
1654:
1655: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1656: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value fail');
1657: END IF;
1658:
1659: END IF;

Line 1656: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value fail');

1652:
1653: ELSE
1654:
1655: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1656: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value fail');
1657: END IF;
1658:
1659: END IF;
1660: End if;

Line 1664: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1660: End if;
1661:
1662: ELSE
1663:
1664: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1665: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'POS_EXTERNAL_URL is not set');
1666: END IF;
1667:
1668: END IF;

Line 1665: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'POS_EXTERNAL_URL is not set');

1661:
1662: ELSE
1663:
1664: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1665: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'POS_EXTERNAL_URL is not set');
1666: END IF;
1667:
1668: END IF;
1669: