1701: --Name: GET_APPRV_REG_USR_SUBJECT
1702: --Type:
1703: -- Function
1704: --Function:
1705: -- It returns the tokens replaced FND message to Notification Message Subject
1706: --Function Usage:
1707: -- This function is used to replace the workflow message subject by FND Message & its tokens
1708: --Logic Implemented:
1709: -- The FND Message Name 'POS_APPRV_REG_USER_SUBJECT' will be replaced with
1703: -- Function
1704: --Function:
1705: -- It returns the tokens replaced FND message to Notification Message Subject
1706: --Function Usage:
1707: -- This function is used to replace the workflow message subject by FND Message & its tokens
1708: --Logic Implemented:
1709: -- The FND Message Name 'POS_APPRV_REG_USER_SUBJECT' will be replaced with
1710: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1711: -- Then, replaced FND message will be return to the corresponding attribute
1705: -- It returns the tokens replaced FND message to Notification Message Subject
1706: --Function Usage:
1707: -- This function is used to replace the workflow message subject by FND Message & its tokens
1708: --Logic Implemented:
1709: -- The FND Message Name 'POS_APPRV_REG_USER_SUBJECT' will be replaced with
1710: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1711: -- Then, replaced FND message will be return to the corresponding attribute
1712: --Parameters:
1713: -- Enterprise Name
1707: -- This function is used to replace the workflow message subject by FND Message & its tokens
1708: --Logic Implemented:
1709: -- The FND Message Name 'POS_APPRV_REG_USER_SUBJECT' will be replaced with
1710: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1711: -- Then, replaced FND message will be return to the corresponding attribute
1712: --Parameters:
1713: -- Enterprise Name
1714: --IN:
1715: -- Enterprise Name
1725: l_document VARCHAR2(32000);
1726:
1727: BEGIN
1728:
1729: fnd_message.set_name('POS','POS_APPRV_REG_USER_SUBJECT');
1730: fnd_message.set_token('ENTERPRISE_NAME', p_enterprise_name);
1731: l_document := fnd_message.get;
1732: RETURN l_document;
1733: END GET_APPRV_REG_USR_SUBJECT;
1726:
1727: BEGIN
1728:
1729: fnd_message.set_name('POS','POS_APPRV_REG_USER_SUBJECT');
1730: fnd_message.set_token('ENTERPRISE_NAME', p_enterprise_name);
1731: l_document := fnd_message.get;
1732: RETURN l_document;
1733: END GET_APPRV_REG_USR_SUBJECT;
1734:
1727: BEGIN
1728:
1729: fnd_message.set_name('POS','POS_APPRV_REG_USER_SUBJECT');
1730: fnd_message.set_token('ENTERPRISE_NAME', p_enterprise_name);
1731: l_document := fnd_message.get;
1732: RETURN l_document;
1733: END GET_APPRV_REG_USR_SUBJECT;
1734:
1735: -------------------------------------------------------------------------------
1737: --Name: GENERATE_APPRV_REG_USR_BODY
1738: --Type:
1739: -- Procedure
1740: --Procedure:
1741: -- It returns the tokens replaced FND message to Notification Message Body
1742: --Procedure Usage:
1743: -- It is being used to replace the workflow message Body by FND Message & its tokens
1744: --Logic Implemented:
1745: -- For HTML Body:
1739: -- Procedure
1740: --Procedure:
1741: -- It returns the tokens replaced FND message to Notification Message Body
1742: --Procedure Usage:
1743: -- It is being used to replace the workflow message Body by FND Message & its tokens
1744: --Logic Implemented:
1745: -- For HTML Body:
1746: -- The FND Message Name 'POS_APPRV_REG_USER_HTML_BODY' will be replaced with
1747: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1742: --Procedure Usage:
1743: -- It is being used to replace the workflow message Body by FND Message & its tokens
1744: --Logic Implemented:
1745: -- For HTML Body:
1746: -- The FND Message Name 'POS_APPRV_REG_USER_HTML_BODY' will be replaced with
1747: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1748: -- Then, replaced FND message will be return to the corresponding attribute
1749: -- For TEXT Body:
1750: -- The FND Message Name 'POS_APPRV_REG_USER_TEXT_BODY' will be replaced with
1744: --Logic Implemented:
1745: -- For HTML Body:
1746: -- The FND Message Name 'POS_APPRV_REG_USER_HTML_BODY' will be replaced with
1747: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1748: -- Then, replaced FND message will be return to the corresponding attribute
1749: -- For TEXT Body:
1750: -- The FND Message Name 'POS_APPRV_REG_USER_TEXT_BODY' will be replaced with
1751: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1752: -- Then, replaced FND message will be return to the corresponding attribute
1746: -- The FND Message Name 'POS_APPRV_REG_USER_HTML_BODY' will be replaced with
1747: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1748: -- Then, replaced FND message will be return to the corresponding attribute
1749: -- For TEXT Body:
1750: -- The FND Message Name 'POS_APPRV_REG_USER_TEXT_BODY' will be replaced with
1751: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1752: -- Then, replaced FND message will be return to the corresponding attribute
1753: --Parameters:
1754: -- document_id
1748: -- Then, replaced FND message will be return to the corresponding attribute
1749: -- For TEXT Body:
1750: -- The FND Message Name 'POS_APPRV_REG_USER_TEXT_BODY' will be replaced with
1751: -- corresponding Message Text and tokens inside the Message Text also be replaced.
1752: -- Then, replaced FND message will be return to the corresponding attribute
1753: --Parameters:
1754: -- document_id
1755: --IN:
1756: -- document_id
1823: END IF;
1824:
1825: IF display_type = 'text/html' THEN
1826: l_disp_type:= display_type;
1827: fnd_message.set_name('POS','POS_APPRV_REG_USER_HTML_BODY');
1828: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1829: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1830: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1831: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1824:
1825: IF display_type = 'text/html' THEN
1826: l_disp_type:= display_type;
1827: fnd_message.set_name('POS','POS_APPRV_REG_USER_HTML_BODY');
1828: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1829: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1830: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1831: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1832: fnd_message.set_token('CONTACT_EMAIL',l_email);
1825: IF display_type = 'text/html' THEN
1826: l_disp_type:= display_type;
1827: fnd_message.set_name('POS','POS_APPRV_REG_USER_HTML_BODY');
1828: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1829: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1830: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1831: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1832: fnd_message.set_token('CONTACT_EMAIL',l_email);
1833: fnd_message.set_token('NOTE',l_note);
1826: l_disp_type:= display_type;
1827: fnd_message.set_name('POS','POS_APPRV_REG_USER_HTML_BODY');
1828: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1829: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1830: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1831: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1832: fnd_message.set_token('CONTACT_EMAIL',l_email);
1833: fnd_message.set_token('NOTE',l_note);
1834: l_document := l_document || NL || NL || fnd_message.get;
1827: fnd_message.set_name('POS','POS_APPRV_REG_USER_HTML_BODY');
1828: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1829: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1830: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1831: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1832: fnd_message.set_token('CONTACT_EMAIL',l_email);
1833: fnd_message.set_token('NOTE',l_note);
1834: l_document := l_document || NL || NL || fnd_message.get;
1835: WF_NOTIFICATION.WriteToClob(document, l_document);
1828: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1829: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1830: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1831: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1832: fnd_message.set_token('CONTACT_EMAIL',l_email);
1833: fnd_message.set_token('NOTE',l_note);
1834: l_document := l_document || NL || NL || fnd_message.get;
1835: WF_NOTIFICATION.WriteToClob(document, l_document);
1836:
1829: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1830: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1831: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1832: fnd_message.set_token('CONTACT_EMAIL',l_email);
1833: fnd_message.set_token('NOTE',l_note);
1834: l_document := l_document || NL || NL || fnd_message.get;
1835: WF_NOTIFICATION.WriteToClob(document, l_document);
1836:
1837: ELSE
1830: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1831: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1832: fnd_message.set_token('CONTACT_EMAIL',l_email);
1833: fnd_message.set_token('NOTE',l_note);
1834: l_document := l_document || NL || NL || fnd_message.get;
1835: WF_NOTIFICATION.WriteToClob(document, l_document);
1836:
1837: ELSE
1838: l_disp_type:= display_type;
1835: WF_NOTIFICATION.WriteToClob(document, l_document);
1836:
1837: ELSE
1838: l_disp_type:= display_type;
1839: fnd_message.set_name('POS','POS_APPRV_REG_USER_TEXT_BODY');
1840: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1841: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1842: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1843: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1836:
1837: ELSE
1838: l_disp_type:= display_type;
1839: fnd_message.set_name('POS','POS_APPRV_REG_USER_TEXT_BODY');
1840: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1841: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1842: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1843: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1844: fnd_message.set_token('CONTACT_EMAIL',l_email);
1837: ELSE
1838: l_disp_type:= display_type;
1839: fnd_message.set_name('POS','POS_APPRV_REG_USER_TEXT_BODY');
1840: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1841: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1842: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1843: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1844: fnd_message.set_token('CONTACT_EMAIL',l_email);
1845: fnd_message.set_token('NOTE',l_note);
1838: l_disp_type:= display_type;
1839: fnd_message.set_name('POS','POS_APPRV_REG_USER_TEXT_BODY');
1840: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1841: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1842: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1843: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1844: fnd_message.set_token('CONTACT_EMAIL',l_email);
1845: fnd_message.set_token('NOTE',l_note);
1846: l_document := l_document || NL || NL || fnd_message.get;
1839: fnd_message.set_name('POS','POS_APPRV_REG_USER_TEXT_BODY');
1840: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1841: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1842: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1843: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1844: fnd_message.set_token('CONTACT_EMAIL',l_email);
1845: fnd_message.set_token('NOTE',l_note);
1846: l_document := l_document || NL || NL || fnd_message.get;
1847: WF_NOTIFICATION.WriteToClob(document, l_document);
1840: fnd_message.set_token('ENTERPRISE_NAME',l_enterprisename);
1841: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1842: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1843: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1844: fnd_message.set_token('CONTACT_EMAIL',l_email);
1845: fnd_message.set_token('NOTE',l_note);
1846: l_document := l_document || NL || NL || fnd_message.get;
1847: WF_NOTIFICATION.WriteToClob(document, l_document);
1848:
1841: fnd_message.set_token('LOGON_PAGE_URL',l_url);
1842: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1843: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1844: fnd_message.set_token('CONTACT_EMAIL',l_email);
1845: fnd_message.set_token('NOTE',l_note);
1846: l_document := l_document || NL || NL || fnd_message.get;
1847: WF_NOTIFICATION.WriteToClob(document, l_document);
1848:
1849: END IF;
1842: fnd_message.set_token('ASSIGNED_USER_NAME',l_username);
1843: fnd_message.set_token('FIRST_LOGON_KEY',l_password);
1844: fnd_message.set_token('CONTACT_EMAIL',l_email);
1845: fnd_message.set_token('NOTE',l_note);
1846: l_document := l_document || NL || NL || fnd_message.get;
1847: WF_NOTIFICATION.WriteToClob(document, l_document);
1848:
1849: END IF;
1850: