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.OKC_ARTWF_PVT dependencies on FND_MESSAGE

Line 839: fnd_message.set_name('OKC', 'OKC_ART_UNDEFINED_ADMIN');

835: --end of fix
836:
837: wf_engine.setItemAttrText(itemtype, itemkey, 'NOTIFIED$', notified);
838: -- bug 3185684
839: fnd_message.set_name('OKC', 'OKC_ART_UNDEFINED_ADMIN');
840: fnd_message.set_token('ORGNAME', organization);
841: wf_engine.setItemAttrText(itemtype, itemkey, 'WARNING', fnd_message.get);
842: wf_engine.setItemAttrText(itemtype, itemkey, 'WF_ADMINISTRATOR', 'SYSADMIN');
843:

Line 840: fnd_message.set_token('ORGNAME', organization);

836:
837: wf_engine.setItemAttrText(itemtype, itemkey, 'NOTIFIED$', notified);
838: -- bug 3185684
839: fnd_message.set_name('OKC', 'OKC_ART_UNDEFINED_ADMIN');
840: fnd_message.set_token('ORGNAME', organization);
841: wf_engine.setItemAttrText(itemtype, itemkey, 'WARNING', fnd_message.get);
842: wf_engine.setItemAttrText(itemtype, itemkey, 'WF_ADMINISTRATOR', 'SYSADMIN');
843:
844: resultout := 'COMPLETE:'||operation;

Line 841: wf_engine.setItemAttrText(itemtype, itemkey, 'WARNING', fnd_message.get);

837: wf_engine.setItemAttrText(itemtype, itemkey, 'NOTIFIED$', notified);
838: -- bug 3185684
839: fnd_message.set_name('OKC', 'OKC_ART_UNDEFINED_ADMIN');
840: fnd_message.set_token('ORGNAME', organization);
841: wf_engine.setItemAttrText(itemtype, itemkey, 'WARNING', fnd_message.get);
842: wf_engine.setItemAttrText(itemtype, itemkey, 'WF_ADMINISTRATOR', 'SYSADMIN');
843:
844: resultout := 'COMPLETE:'||operation;
845: else

Line 1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');

1604: procedure generic_error(routine in varchar2,
1605: errcode in number,
1606: errmsg in varchar2) is
1607: begin
1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1609: fnd_message.set_token('ROUTINE', routine);
1610: fnd_message.set_token('ERRNO', errcode);
1611: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
1612: fnd_msg_pub.add;

Line 1609: fnd_message.set_token('ROUTINE', routine);

1605: errcode in number,
1606: errmsg in varchar2) is
1607: begin
1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1609: fnd_message.set_token('ROUTINE', routine);
1610: fnd_message.set_token('ERRNO', errcode);
1611: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
1612: fnd_msg_pub.add;
1613: end;

Line 1610: fnd_message.set_token('ERRNO', errcode);

1606: errmsg in varchar2) is
1607: begin
1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1609: fnd_message.set_token('ROUTINE', routine);
1610: fnd_message.set_token('ERRNO', errcode);
1611: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
1612: fnd_msg_pub.add;
1613: end;
1614:

Line 1611: fnd_message.set_token('REASON', dbms_utility.format_error_stack);

1607: begin
1608: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');
1609: fnd_message.set_token('ROUTINE', routine);
1610: fnd_message.set_token('ERRNO', errcode);
1611: fnd_message.set_token('REASON', dbms_utility.format_error_stack);
1612: fnd_msg_pub.add;
1613: end;
1614:
1615: function get_org_name(p_org_id in number) return varchar2

Line 1700: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_SELL_APPROVER');

1696:
1697: return 'OK';
1698: exception
1699: when undefined_approver1S then
1700: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_SELL_APPROVER');
1701: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1702: fnd_msg_pub.add;
1703: return 'NOK';
1704: when undefined_approver1B then

Line 1701: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

1697: return 'OK';
1698: exception
1699: when undefined_approver1S then
1700: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_SELL_APPROVER');
1701: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1702: fnd_msg_pub.add;
1703: return 'NOK';
1704: when undefined_approver1B then
1705: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_BUY_APPROVER');

Line 1705: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_BUY_APPROVER');

1701: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1702: fnd_msg_pub.add;
1703: return 'NOK';
1704: when undefined_approver1B then
1705: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_BUY_APPROVER');
1706: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1707: fnd_msg_pub.add;
1708: return 'NOK';
1709: when undefined_approver2S then

Line 1706: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

1702: fnd_msg_pub.add;
1703: return 'NOK';
1704: when undefined_approver1B then
1705: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_BUY_APPROVER');
1706: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1707: fnd_msg_pub.add;
1708: return 'NOK';
1709: when undefined_approver2S then
1710: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_SELL_APPROVER');

Line 1710: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_SELL_APPROVER');

1706: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1707: fnd_msg_pub.add;
1708: return 'NOK';
1709: when undefined_approver2S then
1710: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_SELL_APPROVER');
1711: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1712: fnd_msg_pub.add;
1713: return 'NOK';
1714: when undefined_approver2B then

Line 1711: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

1707: fnd_msg_pub.add;
1708: return 'NOK';
1709: when undefined_approver2S then
1710: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_SELL_APPROVER');
1711: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1712: fnd_msg_pub.add;
1713: return 'NOK';
1714: when undefined_approver2B then
1715: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_BUY_APPROVER');

Line 1715: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_BUY_APPROVER');

1711: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1712: fnd_msg_pub.add;
1713: return 'NOK';
1714: when undefined_approver2B then
1715: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_BUY_APPROVER');
1716: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1717: fnd_msg_pub.add;
1718: return 'NOK';
1719: when others then

Line 1716: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

1712: fnd_msg_pub.add;
1713: return 'NOK';
1714: when undefined_approver2B then
1715: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_BUY_APPROVER');
1716: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1717: fnd_msg_pub.add;
1718: return 'NOK';
1719: when others then
1720: generic_error('okc_artwf_pvt.pre_submit_validation', sqlcode, sqlerrm);

Line 1789: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_SELL_APPROVER');

1785:
1786: return 'OK';
1787: exception
1788: when undefined_approver1S then
1789: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_SELL_APPROVER');
1790: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1791: fnd_msg_pub.add;
1792: return 'NOK';
1793: when undefined_approver1B then

Line 1790: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

1786: return 'OK';
1787: exception
1788: when undefined_approver1S then
1789: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_SELL_APPROVER');
1790: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1791: fnd_msg_pub.add;
1792: return 'NOK';
1793: when undefined_approver1B then
1794: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_BUY_APPROVER');

Line 1794: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_BUY_APPROVER');

1790: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1791: fnd_msg_pub.add;
1792: return 'NOK';
1793: when undefined_approver1B then
1794: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_BUY_APPROVER');
1795: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1796: fnd_msg_pub.add;
1797: return 'NOK';
1798: when undefined_approver2S then

Line 1795: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

1791: fnd_msg_pub.add;
1792: return 'NOK';
1793: when undefined_approver1B then
1794: fnd_message.set_name('OKC', 'OKC_ART_UNDEF_BUY_APPROVER');
1795: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1796: fnd_msg_pub.add;
1797: return 'NOK';
1798: when undefined_approver2S then
1799: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_SELL_APPROVER');

Line 1799: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_SELL_APPROVER');

1795: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1796: fnd_msg_pub.add;
1797: return 'NOK';
1798: when undefined_approver2S then
1799: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_SELL_APPROVER');
1800: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1801: fnd_msg_pub.add;
1802: return 'NOK';
1803: when undefined_approver2B then

Line 1800: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

1796: fnd_msg_pub.add;
1797: return 'NOK';
1798: when undefined_approver2S then
1799: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_SELL_APPROVER');
1800: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1801: fnd_msg_pub.add;
1802: return 'NOK';
1803: when undefined_approver2B then
1804: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_BUY_APPROVER');

Line 1804: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_BUY_APPROVER');

1800: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1801: fnd_msg_pub.add;
1802: return 'NOK';
1803: when undefined_approver2B then
1804: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_BUY_APPROVER');
1805: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1806: fnd_msg_pub.add;
1807: return 'NOK';
1808: when others then

Line 1805: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

1801: fnd_msg_pub.add;
1802: return 'NOK';
1803: when undefined_approver2B then
1804: fnd_message.set_name('OKC', 'OKC_ART_UNKNOWN_BUY_APPROVER');
1805: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));
1806: fnd_msg_pub.add;
1807: return 'NOK';
1808: when others then
1809: generic_error('okc_artwf_pvt.pre_submit_validation', sqlcode, sqlerrm);

Line 1937: fnd_message.clear;

1933: nid := to_number(okc_artwf_pvt.nid(document_id));
1934: message_code := okc_artwf_pvt.code(document_id);
1935: itemtype := okc_artwf_pvt.itemtype(nid);
1936: itemkey := okc_artwf_pvt.itemkey(nid);
1937: fnd_message.clear;
1938: fnd_message.set_name(application => 'OKC', name => message_code);
1939: if message_code in ( 'OKC_ART_ADOPTION_NTF_SUBJECT',
1940: 'OKC_ART_ADOPTION_NTF_SUBJECT_A',
1941: 'OKC_ART_ADOPTION_NTF_SUBJECT_R',

Line 1938: fnd_message.set_name(application => 'OKC', name => message_code);

1934: message_code := okc_artwf_pvt.code(document_id);
1935: itemtype := okc_artwf_pvt.itemtype(nid);
1936: itemkey := okc_artwf_pvt.itemkey(nid);
1937: fnd_message.clear;
1938: fnd_message.set_name(application => 'OKC', name => message_code);
1939: if message_code in ( 'OKC_ART_ADOPTION_NTF_SUBJECT',
1940: 'OKC_ART_ADOPTION_NTF_SUBJECT_A',
1941: 'OKC_ART_ADOPTION_NTF_SUBJECT_R',
1942: 'OKC_ART_APPROVAL_NTF_SUBJECT',

Line 1947: fnd_message.set_token( token => 'ARTICLENUMBER',

1943: 'OKC_ART_APPROVAL_NTF_SUBJECT_A',
1944: 'OKC_ART_APPROVAL_NTF_SUBJECT_R',
1945: 'OKC_ART_ADOPTED_NTF_SUBJECT',
1946: 'OKC_ART_AVAILABLE_NTF_SUBJECT') then
1947: fnd_message.set_token( token => 'ARTICLENUMBER',
1948: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_NUMBER'));
1949: fnd_message.set_token( token => 'ARTICLETITLE',
1950: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_TITLE'));
1951: fnd_message.set_token( token => 'ARTICLEVERSIONNUMBER',

Line 1949: fnd_message.set_token( token => 'ARTICLETITLE',

1945: 'OKC_ART_ADOPTED_NTF_SUBJECT',
1946: 'OKC_ART_AVAILABLE_NTF_SUBJECT') then
1947: fnd_message.set_token( token => 'ARTICLENUMBER',
1948: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_NUMBER'));
1949: fnd_message.set_token( token => 'ARTICLETITLE',
1950: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_TITLE'));
1951: fnd_message.set_token( token => 'ARTICLEVERSIONNUMBER',
1952: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_VERSION_NUMBER'));
1953: if message_code in ( 'OKC_ART_ADOPTION_NTF_SUBJECT',

Line 1951: fnd_message.set_token( token => 'ARTICLEVERSIONNUMBER',

1947: fnd_message.set_token( token => 'ARTICLENUMBER',
1948: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_NUMBER'));
1949: fnd_message.set_token( token => 'ARTICLETITLE',
1950: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_TITLE'));
1951: fnd_message.set_token( token => 'ARTICLEVERSIONNUMBER',
1952: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_VERSION_NUMBER'));
1953: if message_code in ( 'OKC_ART_ADOPTION_NTF_SUBJECT',
1954: 'OKC_ART_APPROVAL_NTF_SUBJECT') then
1955: fnd_message.set_token( token => 'APPROVERNAME',

Line 1955: fnd_message.set_token( token => 'APPROVERNAME',

1951: fnd_message.set_token( token => 'ARTICLEVERSIONNUMBER',
1952: value => wf_notification.getAttrText(nid, '#HDR_ARTICLE_VERSION_NUMBER'));
1953: if message_code in ( 'OKC_ART_ADOPTION_NTF_SUBJECT',
1954: 'OKC_ART_APPROVAL_NTF_SUBJECT') then
1955: fnd_message.set_token( token => 'APPROVERNAME',
1956: value => wf_engine.GetItemAttrText( itemtype, itemkey, 'REQUESTOR_DISPLAY_NAME'));
1957: end if;
1958: if message_code in ( 'OKC_ART_ADOPTED_NTF_SUBJECT',
1959: 'OKC_ART_AVAILABLE_NTF_SUBJECT') then

Line 1960: fnd_message.set_token( token => 'ORGANIZATIONNAME',

1956: value => wf_engine.GetItemAttrText( itemtype, itemkey, 'REQUESTOR_DISPLAY_NAME'));
1957: end if;
1958: if message_code in ( 'OKC_ART_ADOPTED_NTF_SUBJECT',
1959: 'OKC_ART_AVAILABLE_NTF_SUBJECT') then
1960: fnd_message.set_token( token => 'ORGANIZATIONNAME',
1961: value => get_org_name(wf_notification.getAttrText(nid, 'ORGANIZATION$')));
1962: end if;
1963: document := fnd_message.get;
1964: end if;

Line 1963: document := fnd_message.get;

1959: 'OKC_ART_AVAILABLE_NTF_SUBJECT') then
1960: fnd_message.set_token( token => 'ORGANIZATIONNAME',
1961: value => get_org_name(wf_notification.getAttrText(nid, 'ORGANIZATION$')));
1962: end if;
1963: document := fnd_message.get;
1964: end if;
1965: log('subject exit');
1966: exception
1967: when others then