eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1593: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1589: lv_flag := ''; -- we want it to be case sensitive for now.
1590: If (owa_pattern.match(lv_external_web_agent,lv_pattern, lv_flag)) then
1591: -- The external profile still points to icx web site.
1592:
1593: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1594: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'Setting user level APPS_WEB_AGENT profile option value');
1595: END IF;
1596:
1597: IF ( fnd_profile.save( x_name => 'APPS_WEB_AGENT',

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

1590: If (owa_pattern.match(lv_external_web_agent,lv_pattern, lv_flag)) then
1591: -- The external profile still points to icx web site.
1592:
1593: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1594: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'Setting user level APPS_WEB_AGENT profile option value');
1595: END IF;
1596:
1597: IF ( fnd_profile.save( x_name => 'APPS_WEB_AGENT',
1598: x_value => lv_external_web_agent,

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

1598: x_value => lv_external_web_agent,
1599: x_level_name => 'USER',
1600: x_level_value => p_userid ) ) THEN
1601:
1602: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1603: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value set');
1604: END IF;
1605:
1606: ELSE

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

1599: x_level_name => 'USER',
1600: x_level_value => p_userid ) ) THEN
1601:
1602: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1603: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value set');
1604: END IF;
1605:
1606: ELSE
1607:

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

1604: END IF;
1605:
1606: ELSE
1607:
1608: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1609: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value fail');
1610: END IF;
1611:
1612: END IF;

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

1605:
1606: ELSE
1607:
1608: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1609: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_WEB_AGENT profile option value fail');
1610: END IF;
1611:
1612: END IF;
1613:

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

1616: x_value => lv_ext_servlet_agent,
1617: x_level_name => 'USER',
1618: x_level_value => p_userid ) ) THEN
1619:
1620: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1621: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value set');
1622: END IF;
1623:
1624: ELSE

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

1617: x_level_name => 'USER',
1618: x_level_value => p_userid ) ) THEN
1619:
1620: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1621: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value set');
1622: END IF;
1623:
1624: ELSE
1625:

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

1622: END IF;
1623:
1624: ELSE
1625:
1626: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1627: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value fail');
1628: END IF;
1629:
1630: END IF;

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

1623:
1624: ELSE
1625:
1626: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1627: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_SERVLET_AGENT profile option value fail');
1628: END IF;
1629:
1630: END IF;
1631:

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

1634: x_value => lv_ext_servlet_agent,
1635: x_level_name => 'USER',
1636: x_level_value => p_userid ) ) THEN
1637:
1638: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1639: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value set');
1640: END IF;
1641:
1642: ELSE

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

1635: x_level_name => 'USER',
1636: x_level_value => p_userid ) ) THEN
1637:
1638: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1639: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value set');
1640: END IF;
1641:
1642: ELSE
1643:

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

1640: END IF;
1641:
1642: ELSE
1643:
1644: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1645: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');
1646: END IF;
1647:
1648: END IF;

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

1641:
1642: ELSE
1643:
1644: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1645: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');
1646: END IF;
1647:
1648: END IF;
1649: ELSE

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

1651: x_value => lv_ext_servlet_agent,
1652: x_level_name => 'USER',
1653: x_level_value => p_userid ) ) THEN
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_FRAMEWORK_AGENT profile option value set');
1657: END IF;
1658:
1659: ELSE

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

1652: x_level_name => 'USER',
1653: x_level_value => p_userid ) ) THEN
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_FRAMEWORK_AGENT profile option value set');
1657: END IF;
1658:
1659: ELSE
1660:

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

1657: END IF;
1658:
1659: ELSE
1660:
1661: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1662: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');
1663: END IF;
1664:
1665: END IF;

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

1658:
1659: ELSE
1660:
1661: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1662: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_FRAMEWORK_AGENT profile option value fail');
1663: END IF;
1664:
1665: END IF;
1666: -- set only the framework agent. there is no way to set web agent

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

1670: x_value => lv_ext_servlet_agent,
1671: x_level_name => 'USER',
1672: x_level_value => p_userid ) ) THEN
1673:
1674: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1675: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value set');
1676: END IF;
1677:
1678: ELSE

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

1671: x_level_name => 'USER',
1672: x_level_value => p_userid ) ) THEN
1673:
1674: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1675: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value set');
1676: END IF;
1677:
1678: ELSE
1679:

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

1676: END IF;
1677:
1678: ELSE
1679:
1680: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1681: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value fail');
1682: END IF;
1683:
1684: END IF;

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

1677:
1678: ELSE
1679:
1680: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1681: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'User level APPS_servlet_AGENT profile option value fail');
1682: END IF;
1683:
1684: END IF;
1685: End if;

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

1685: End if;
1686:
1687: ELSE
1688:
1689: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1690: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'POS_EXTERNAL_URL is not set');
1691: END IF;
1692:
1693: END IF;

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

1686:
1687: ELSE
1688:
1689: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1690: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.' || lv_proc_name, 'POS_EXTERNAL_URL is not set');
1691: END IF;
1692:
1693: END IF;
1694:

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

1779: l_item_type wf_items.item_type%TYPE;
1780: l_item_key wf_items.item_key%TYPE;
1781: BEGIN
1782:
1783: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1784: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'p_document_id ' || p_document_id);
1785: END IF;
1786:
1787: l_item_type := substr(p_document_id, 1, instr(p_document_id, ':') - 1);

Line 1784: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'p_document_id ' || p_document_id);

1780: l_item_key wf_items.item_key%TYPE;
1781: BEGIN
1782:
1783: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1784: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'p_document_id ' || p_document_id);
1785: END IF;
1786:
1787: l_item_type := substr(p_document_id, 1, instr(p_document_id, ':') - 1);
1788: l_item_key := substr(p_document_id, instr(p_document_id, ':') + 1, length(p_document_id));

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

1786:
1787: l_item_type := substr(p_document_id, 1, instr(p_document_id, ':') - 1);
1788: l_item_key := substr(p_document_id, instr(p_document_id, ':') + 1, length(p_document_id));
1789:
1790: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1791: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_item_type ' || l_item_type);
1792: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_item_key ' || l_item_key);
1793: END IF;
1794:

Line 1791: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_item_type ' || l_item_type);

1787: l_item_type := substr(p_document_id, 1, instr(p_document_id, ':') - 1);
1788: l_item_key := substr(p_document_id, instr(p_document_id, ':') + 1, length(p_document_id));
1789:
1790: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1791: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_item_type ' || l_item_type);
1792: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_item_key ' || l_item_key);
1793: END IF;
1794:
1795: l_enterprisename := wf_engine.GetItemAttrText (itemtype => l_item_type,

Line 1792: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_item_key ' || l_item_key);

1788: l_item_key := substr(p_document_id, instr(p_document_id, ':') + 1, length(p_document_id));
1789:
1790: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1791: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_item_type ' || l_item_type);
1792: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_item_key ' || l_item_key);
1793: END IF;
1794:
1795: l_enterprisename := wf_engine.GetItemAttrText (itemtype => l_item_type,
1796: itemkey => l_item_key,

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

1811: l_note := wf_engine.GetItemAttrText (itemtype => l_item_type,
1812: itemkey => l_item_key,
1813: aname => 'NOTE');
1814:
1815: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1816: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_enterprisename ' || l_enterprisename);
1817: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_url ' || l_url);
1818: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_username ' || l_username);
1819: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_password ' || l_password);

Line 1816: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_enterprisename ' || l_enterprisename);

1812: itemkey => l_item_key,
1813: aname => 'NOTE');
1814:
1815: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1816: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_enterprisename ' || l_enterprisename);
1817: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_url ' || l_url);
1818: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_username ' || l_username);
1819: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_password ' || l_password);
1820: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_adminemail ' || l_email);

Line 1817: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_url ' || l_url);

1813: aname => 'NOTE');
1814:
1815: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1816: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_enterprisename ' || l_enterprisename);
1817: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_url ' || l_url);
1818: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_username ' || l_username);
1819: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_password ' || l_password);
1820: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_adminemail ' || l_email);
1821: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_note ' || l_note);

Line 1818: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_username ' || l_username);

1814:
1815: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1816: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_enterprisename ' || l_enterprisename);
1817: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_url ' || l_url);
1818: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_username ' || l_username);
1819: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_password ' || l_password);
1820: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_adminemail ' || l_email);
1821: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_note ' || l_note);
1822: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'display_type ' || display_type);

Line 1819: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_password ' || l_password);

1815: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1816: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_enterprisename ' || l_enterprisename);
1817: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_url ' || l_url);
1818: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_username ' || l_username);
1819: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_password ' || l_password);
1820: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_adminemail ' || l_email);
1821: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_note ' || l_note);
1822: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'display_type ' || display_type);
1823: END IF;

Line 1820: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_adminemail ' || l_email);

1816: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_enterprisename ' || l_enterprisename);
1817: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_url ' || l_url);
1818: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_username ' || l_username);
1819: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_password ' || l_password);
1820: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_adminemail ' || l_email);
1821: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_note ' || l_note);
1822: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'display_type ' || display_type);
1823: END IF;
1824:

Line 1821: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_note ' || l_note);

1817: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_url ' || l_url);
1818: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_username ' || l_username);
1819: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_password ' || l_password);
1820: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_adminemail ' || l_email);
1821: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_note ' || l_note);
1822: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'display_type ' || display_type);
1823: END IF;
1824:
1825: IF display_type = 'text/html' THEN

Line 1822: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'display_type ' || display_type);

1818: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_username ' || l_username);
1819: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_password ' || l_password);
1820: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_adminemail ' || l_email);
1821: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'l_note ' || l_note);
1822: fnd_log.string(fnd_log.level_procedure, g_log_module_name || '.GENERATE_APPRV_REG_USR_BODY', 'display_type ' || display_type);
1823: END IF;
1824:
1825: IF display_type = 'text/html' THEN
1826: l_disp_type:= display_type;