1564: -- x_errmsg: Error Message
1565: -- x_errstack: Error Stack
1566: --
1567: --
1568: procedure get_error_wf_info (p_reg_request_id in wf_items.item_type%type,
1569: x_itemtype out nocopy wf_items.item_type%type,
1570: x_itemkey out nocopy wf_items.item_key%type,
1571: x_status out nocopy varchar2,
1572: x_result out nocopy varchar2,
1565: -- x_errstack: Error Stack
1566: --
1567: --
1568: procedure get_error_wf_info (p_reg_request_id in wf_items.item_type%type,
1569: x_itemtype out nocopy wf_items.item_type%type,
1570: x_itemkey out nocopy wf_items.item_key%type,
1571: x_status out nocopy varchar2,
1572: x_result out nocopy varchar2,
1573: x_actid out nocopy number,
1566: --
1567: --
1568: procedure get_error_wf_info (p_reg_request_id in wf_items.item_type%type,
1569: x_itemtype out nocopy wf_items.item_type%type,
1570: x_itemkey out nocopy wf_items.item_key%type,
1571: x_status out nocopy varchar2,
1572: x_result out nocopy varchar2,
1573: x_actid out nocopy number,
1574: x_errname out nocopy varchar2,
1575: x_errmsg out nocopy varchar2,
1576: x_errstack out nocopy varchar2) IS
1577:
1578: cursor get_child_workflow is
1579: select * from wf_items
1580: where parent_item_type = umx_registration_util.g_item_type
1581: and parent_item_key = p_reg_request_id;
1582:
1583: child get_child_workflow%rowtype;
1660: -- x_errstack: Error Stack
1661: --
1662: --
1663: procedure get_error_wf_info (p_user_id in fnd_user.user_id%type,
1664: x_itemtype out nocopy wf_items.item_type%type,
1665: x_itemkey out nocopy wf_items.item_key%type,
1666: x_status out nocopy varchar2,
1667: x_result out nocopy varchar2,
1668: x_actid out nocopy number,
1661: --
1662: --
1663: procedure get_error_wf_info (p_user_id in fnd_user.user_id%type,
1664: x_itemtype out nocopy wf_items.item_type%type,
1665: x_itemkey out nocopy wf_items.item_key%type,
1666: x_status out nocopy varchar2,
1667: x_result out nocopy varchar2,
1668: x_actid out nocopy number,
1669: x_errname out nocopy varchar2,
1742: -- It will return 'Y' if pending account has error and 'N' if otherwise.
1743: --
1744: function is_pend_request_error (p_reg_request_id in umx_reg_requests.reg_request_id%type) return varchar2 is
1745:
1746: l_itemtype wf_items.item_type%type;
1747: l_itemkey wf_items.item_key%type;
1748: l_status varchar2(8);
1749: l_result varchar2(30);
1750: l_actid number;
1743: --
1744: function is_pend_request_error (p_reg_request_id in umx_reg_requests.reg_request_id%type) return varchar2 is
1745:
1746: l_itemtype wf_items.item_type%type;
1747: l_itemkey wf_items.item_key%type;
1748: l_status varchar2(8);
1749: l_result varchar2(30);
1750: l_actid number;
1751: l_errname varchar2(30);
1798: -- It will return 'Y' if pending account has error and 'N' if otherwise.
1799: --
1800: function is_pend_account_error (p_user_id in fnd_user.user_id%type) return varchar2 is
1801:
1802: l_itemtype wf_items.item_type%type;
1803: l_itemkey wf_items.item_key%type;
1804: l_status varchar2(8);
1805: l_result varchar2(30);
1806: l_actid number;
1799: --
1800: function is_pend_account_error (p_user_id in fnd_user.user_id%type) return varchar2 is
1801:
1802: l_itemtype wf_items.item_type%type;
1803: l_itemkey wf_items.item_key%type;
1804: l_status varchar2(8);
1805: l_result varchar2(30);
1806: l_actid number;
1807: l_errname varchar2(30);