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.JTF_UM_UTIL_PVT dependencies on JTF_DEBUG_PUB

Line 5: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME);

1: PACKAGE BODY JTF_UM_UTIL_PVT as
2: /* $Header: JTFVUUTB.pls 120.8 2006/02/14 00:16:14 snellepa ship $ */
3:
4: MODULE_NAME CONSTANT VARCHAR2(50) := 'JTF.UM.PLSQL.JTF_UM_UTIL_PVT';
5: l_is_debug_parameter_on boolean := JTF_DEBUG_PUB.IS_LOG_PARAMETERS_ON(MODULE_NAME);
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'JTF_UM_UTIL_PVT';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'JTFVUUTB.pls';
9:

Line 572: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');

568:
569: begin
570:
571: -- Write to debug log
572: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');
573: --
574:
575: -- Standard Start of API savepoint
576: SAVEPOINT get_wf_user;

Line 659: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');

655: p_count => x_msg_count,
656: p_data => x_msg_data);
657:
658: -- Write to debug log
659: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
660: --
661:
662: EXCEPTION
663: WHEN FND_API.G_EXC_ERROR THEN

Line 664: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(

660: --
661:
662: EXCEPTION
663: WHEN FND_API.G_EXC_ERROR THEN
664: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
665: P_API_NAME => L_API_NAME
666: ,P_PKG_NAME => G_PKG_NAME
667: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
668: ,P_SQLCODE => SQLCODE

Line 675: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(

671: ,X_MSG_DATA => X_MSG_DATA
672: ,X_RETURN_STATUS => X_RETURN_STATUS);
673:
674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
675: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
676: P_API_NAME => L_API_NAME
677: ,P_PKG_NAME => G_PKG_NAME
678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
679: ,P_SQLCODE => SQLCODE

Line 686: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(

682: ,X_MSG_DATA => X_MSG_DATA
683: ,X_RETURN_STATUS => X_RETURN_STATUS);
684:
685: WHEN OTHERS THEN
686: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
687: P_API_NAME => L_API_NAME
688: ,P_PKG_NAME => G_PKG_NAME
689: ,P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS
690: ,P_SQLCODE => SQLCODE

Line 689: ,P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS

685: WHEN OTHERS THEN
686: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS(
687: P_API_NAME => L_API_NAME
688: ,P_PKG_NAME => G_PKG_NAME
689: ,P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS
690: ,P_SQLCODE => SQLCODE
691: ,P_SQLERRM => SQLERRM
692: ,X_MSG_COUNT => X_MSG_COUNT
693: ,X_MSG_DATA => X_MSG_DATA

Line 794: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');

790: PRAGMA EXCEPTION_INIT (duplicated_user, -20002);
791:
792: BEGIN
793: -- Write to debug log
794: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');
795:
796: -- Standard call to check for call compatibility.
797: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
798: p_api_version_number,

Line 884: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');

880:
881: -- call the user hook if it is a public api. Private APIs do not require a user hook call.
882:
883: -- Write to debug log
884: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
885:
886: EXCEPTION
887: WHEN FND_API.G_EXC_ERROR THEN
888: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,

Line 888: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,

884: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
885:
886: EXCEPTION
887: WHEN FND_API.G_EXC_ERROR THEN
888: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
889: P_PKG_NAME => G_PKG_NAME,
890: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
891: P_SQLCODE => SQLCODE,
892: P_SQLERRM => SQLERRM,

Line 898: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,

894: X_MSG_DATA => X_MSG_DATA,
895: X_RETURN_STATUS => X_RETURN_STATUS);
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
899: P_PKG_NAME => G_PKG_NAME,
900: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
901: P_SQLCODE => SQLCODE,
902: P_SQLERRM => SQLERRM,

Line 908: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,

904: X_MSG_DATA => X_MSG_DATA,
905: X_RETURN_STATUS => X_RETURN_STATUS);
906:
907: WHEN OTHERS THEN
908: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
909: P_PKG_NAME => G_PKG_NAME,
910: P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS,
911: P_SQLCODE => SQLCODE,
912: P_SQLERRM => SQLERRM,

Line 910: P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS,

906:
907: WHEN OTHERS THEN
908: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
909: P_PKG_NAME => G_PKG_NAME,
910: P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS,
911: P_SQLCODE => SQLCODE,
912: P_SQLERRM => SQLERRM,
913: X_MSG_COUNT => X_MSG_COUNT,
914: X_MSG_DATA => X_MSG_DATA,

Line 1045: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');

1041: l_error_msg VARCHAR2 (20);
1042:
1043: BEGIN
1044: -- Write to debug log
1045: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Entering API send_Password ...');
1046:
1047: -- Standard call to check for call compatibility.
1048: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1049: p_api_version_number,

Line 1158: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');

1154:
1155: -- call the user hook if it is a public api. Private APIs do not require a user hook call.
1156:
1157: -- Write to debug log
1158: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
1159:
1160: EXCEPTION
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,

Line 1162: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,

1158: -- JTF_DEBUG_PUB.add_debug_msg('EVENT', G_MODULE, 'Exiting API send_Password ...');
1159:
1160: EXCEPTION
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
1163: P_PKG_NAME => G_PKG_NAME,
1164: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1165: P_SQLCODE => SQLCODE,
1166: P_SQLERRM => SQLERRM,

Line 1172: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,

1168: X_MSG_DATA => X_MSG_DATA,
1169: X_RETURN_STATUS => X_RETURN_STATUS);
1170:
1171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1172: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
1173: P_PKG_NAME => G_PKG_NAME,
1174: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1175: P_SQLCODE => SQLCODE,
1176: P_SQLERRM => SQLERRM,

Line 1182: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,

1178: X_MSG_DATA => X_MSG_DATA,
1179: X_RETURN_STATUS => X_RETURN_STATUS);
1180:
1181: WHEN OTHERS THEN
1182: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
1183: P_PKG_NAME => G_PKG_NAME,
1184: P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS,
1185: P_SQLCODE => SQLCODE,
1186: P_SQLERRM => SQLERRM,

Line 1184: P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS,

1180:
1181: WHEN OTHERS THEN
1182: JTF_DEBUG_PUB.HANDLE_EXCEPTIONS (P_API_NAME => L_API_NAME,
1183: P_PKG_NAME => G_PKG_NAME,
1184: P_EXCEPTION_LEVEL => JTF_DEBUG_PUB.G_EXC_OTHERS,
1185: P_SQLCODE => SQLCODE,
1186: P_SQLERRM => SQLERRM,
1187: X_MSG_COUNT => X_MSG_COUNT,
1188: X_MSG_DATA => X_MSG_DATA,

Line 1450: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1446: l_procedure_name CONSTANT varchar2(30) := 'VALIDATE_USER_ID';
1447: l_dummy_value number;
1448:
1449: begin
1450: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1451: p_message => l_procedure_name
1452: );
1453:
1454: if l_is_debug_parameter_on then

Line 1455: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1451: p_message => l_procedure_name
1452: );
1453:
1454: if l_is_debug_parameter_on then
1455: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1456: p_message => 'p_user_id:' || p_user_id
1457: );
1458: end if;
1459:

Line 1472: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1468: return true;
1469:
1470: end if;
1471:
1472: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1473: p_message => l_procedure_name
1474: );
1475:
1476:

Line 1509: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1505: l_dummy_value number;
1506:
1507: begin
1508:
1509: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1510: p_message => l_procedure_name
1511: );
1512:
1513: if l_is_debug_parameter_on then

Line 1514: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1510: p_message => l_procedure_name
1511: );
1512:
1513: if l_is_debug_parameter_on then
1514: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1515: p_message => 'p_subscription_id:' || p_subscription_id
1516: );
1517: end if;
1518:

Line 1531: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1527: close find_subscription_id;
1528: return true;
1529:
1530: end if;
1531: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1532: p_message => l_procedure_name
1533: );
1534:
1535:

Line 1579: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1575: l_dummy number;
1576:
1577: BEGIN
1578:
1579: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1580: p_message => l_procedure_name
1581: );
1582:
1583: if l_is_debug_parameter_on then

Line 1584: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1580: p_message => l_procedure_name
1581: );
1582:
1583: if l_is_debug_parameter_on then
1584: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1585: p_message => 'p_user_id:' || p_user_id || '+' || 'p_auth_principal_id:' || p_auth_principal_id
1586: );
1587: end if;
1588:

Line 1591: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

1587: end if;
1588:
1589:
1590: IF NOT VALIDATE_USER_ID(p_user_id) THEN
1591: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1592: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')
1593: );
1594:
1595: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));

Line 1592: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')

1588:
1589:
1590: IF NOT VALIDATE_USER_ID(p_user_id) THEN
1591: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1592: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')
1593: );
1594:
1595: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));
1596: END IF;

Line 1595: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));

1591: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1592: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id')
1593: );
1594:
1595: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('user_id'));
1596: END IF;
1597:
1598: OPEN VALIDATE_ROLE;
1599: FETCH VALIDATE_ROLE INTO l_role_id;

Line 1603: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

1599: FETCH VALIDATE_ROLE INTO l_role_id;
1600:
1601: IF VALIDATE_ROLE%NOTFOUND THEN
1602: CLOSE VALIDATE_ROLE;
1603: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1604: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_id')
1605: );
1606:
1607: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_id'));

Line 1604: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_id')

1600:
1601: IF VALIDATE_ROLE%NOTFOUND THEN
1602: CLOSE VALIDATE_ROLE;
1603: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1604: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_id')
1605: );
1606:
1607: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_id'));
1608: END IF;

Line 1607: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_id'));

1603: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1604: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_id')
1605: );
1606:
1607: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_id'));
1608: END IF;
1609:
1610: OPEN CHECK_ROLE_ASSIGNMENT;
1611: FETCH CHECK_ROLE_ASSIGNMENT INTO l_dummy;

Line 1660: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1656:
1657: l_role_id number;
1658:
1659: BEGIN
1660: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1661: p_message => l_procedure_name
1662: );
1663:
1664: if l_is_debug_parameter_on then

Line 1665: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1661: p_message => l_procedure_name
1662: );
1663:
1664: if l_is_debug_parameter_on then
1665: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1666: p_message => 'p_user_id:' || p_user_id || '+' || 'p_principal_name:' || p_principal_name
1667: );
1668: end if;
1669:

Line 1676: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,

1672: FETCH VALIDATE_ROLE_NAME INTO l_role_id;
1673:
1674: IF VALIDATE_ROLE_NAME%NOTFOUND THEN
1675: CLOSE VALIDATE_ROLE_NAME;
1676: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1677: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_name')
1678: );
1679:
1680: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_name'));

Line 1677: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_name')

1673:
1674: IF VALIDATE_ROLE_NAME%NOTFOUND THEN
1675: CLOSE VALIDATE_ROLE_NAME;
1676: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1677: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_name')
1678: );
1679:
1680: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_name'));
1681: END IF;

Line 1680: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_name'));

1676: JTF_DEBUG_PUB.LOG_EXCEPTION( p_module => MODULE_NAME,
1677: p_message => JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_name')
1678: );
1679:
1680: RAISE_APPLICATION_ERROR(-20000, JTF_DEBUG_PUB.GET_INVALID_PARAM_MSG('role_name'));
1681: END IF;
1682:
1683: return check_role(
1684: p_user_id => p_user_id,

Line 1688: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1684: p_user_id => p_user_id,
1685: p_auth_principal_id => l_role_id
1686: );
1687:
1688: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1689: p_message => l_procedure_name
1690: );
1691:
1692: END check_role;

Line 1735: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1731: WHERE JTF_AUTH_PRINCIPAL_ID = p_role_id;
1732: l_role_name JTF_AUTH_PRINCIPALS_B.PRINCIPAL_NAME%TYPE;
1733:
1734: BEGIN
1735: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1736: p_message => l_procedure_name
1737: );
1738:
1739: if l_is_debug_parameter_on then

Line 1740: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1736: p_message => l_procedure_name
1737: );
1738:
1739: if l_is_debug_parameter_on then
1740: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1741: p_message => 'p_user_name:' || p_user_name || '+' || 'p_role_id:' || p_role_id || '+' || 'p_source_name:' || p_source_name || '+' || 'p_source_id:' || p_source_id
1742: );
1743: end if;
1744:

Line 1761: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1757: );
1758:
1759: END IF;
1760:
1761: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1762: p_message => l_procedure_name
1763: );
1764:
1765: END grant_roles;

Line 1796: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1792: l_user_id NUMBER;
1793:
1794: BEGIN
1795:
1796: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1797: p_message => l_procedure_name
1798: );
1799:
1800: if l_is_debug_parameter_on then

Line 1801: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1797: p_message => l_procedure_name
1798: );
1799:
1800: if l_is_debug_parameter_on then
1801: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1802: p_message => 'p_user_name:' || p_user_name
1803: );
1804: end if;
1805:

Line 1810: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1806: OPEN GET_ID;
1807: FETCH GET_ID INTO l_user_id;
1808: CLOSE GET_ID;
1809:
1810: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1811: p_message => l_procedure_name
1812: );
1813: return l_user_id;
1814:

Line 1850: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,

1846: l_usertype_id NUMBER;
1847:
1848: BEGIN
1849:
1850: JTF_DEBUG_PUB.LOG_ENTERING_METHOD( p_module => MODULE_NAME,
1851: p_message => l_procedure_name
1852: );
1853:
1854: if l_is_debug_parameter_on then

Line 1855: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,

1851: p_message => l_procedure_name
1852: );
1853:
1854: if l_is_debug_parameter_on then
1855: JTF_DEBUG_PUB.LOG_PARAMETERS( p_module => MODULE_NAME,
1856: p_message => 'p_user_id:' || p_user_id
1857: );
1858: end if;
1859:

Line 1864: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,

1860: OPEN GET_ID;
1861: FETCH GET_ID INTO l_usertype_id;
1862: CLOSE GET_ID;
1863:
1864: JTF_DEBUG_PUB.LOG_EXITING_METHOD( p_module => MODULE_NAME,
1865: p_message => l_procedure_name
1866: );
1867: return l_usertype_id;
1868:

Line 2000: JTF_DEBUG_PUB.LOG_DEBUG(2, MODULE_NAME, sqlerrm);

1996: exception
1997: when others then
1998:
1999: if l_is_debug_parameter_on then
2000: JTF_DEBUG_PUB.LOG_DEBUG(2, MODULE_NAME, sqlerrm);
2001: end if;
2002: l_person_name := fname || ' ' || lname;
2003: return l_person_name;
2004: