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_MSG_PUB

Line 1353: fnd_msg_pub.initialize;

1349: x_msg_data varchar2(2000);
1350: begin
1351: check_result := 'NOK';
1352: wf_result := 'NOK';
1353: fnd_msg_pub.initialize;
1354: clean;
1355: check_status(org_id, article_version_id, x_result, x_msg_count, x_msg_data);
1356: if x_result = fnd_api.G_RET_STS_SUCCESS then
1357: start_wf_processes(wf_result);

Line 1612: fnd_msg_pub.add;

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
1616: is

Line 1661: fnd_msg_pub.initialize;

1657: approverS wf_users.name%type;
1658: approverB wf_users.name%type;
1659: begin
1660: result := 'N';
1661: fnd_msg_pub.initialize;
1662: approverS := get_approver(p_org_id, 'S');
1663: approverB := get_approver(p_org_id, 'B');
1664:
1665: if approverS is null then

Line 1702: fnd_msg_pub.add;

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');
1706: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

Line 1707: 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');
1711: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

Line 1712: 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');
1716: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

Line 1717: 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);
1721: return 'NOK';

Line 1748: fnd_msg_pub.initialize;

1744: approverS wf_users.name%type;
1745: approverB wf_users.name%type;
1746: begin
1747: result := 'N';
1748: fnd_msg_pub.initialize;
1749: approverS := get_approver(p_org_id, 'S');
1750: approverB := get_approver(p_org_id, 'B');
1751:
1752: if p_intent = 'S' then

Line 1791: fnd_msg_pub.add;

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');
1795: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

Line 1796: 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');
1800: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

Line 1801: 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');
1805: fnd_message.set_token('ORGNAME', get_org_name(p_org_id));

Line 1806: 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);
1810: return 'NOK';