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 OKC_ARTWF_PVT

Line 1: package body okc_artwf_pvt as

1: package body okc_artwf_pvt as
2: /* $Header: OKCARTWFB.pls 120.11 2010/05/19 10:06:07 harchand ship $ */
3:
4: -- get info from versions table
5: cursor cv(cp_org_id in number, cp_version_id in number) is

Line 128: g_module constant varchar2(250) := 'okc.plsql.okc_artwf_pvt.';

124:
125: --!!!
126: -- begin logging procedure declarations
127: g_level_procedure constant number := fnd_log.level_procedure;
128: g_module constant varchar2(250) := 'okc.plsql.okc_artwf_pvt.';
129: l_api_name varchar2(30);
130: -- end logging procedure declarations
131: -- begin logging procedures
132: procedure start_log(api_name in varchar2)

Line 761: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'set_notified_list', itemtype,

757: return;
758: end if;
759: exception
760: when others then
761: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'set_notified_list', itemtype,
762: itemkey, to_char(actid), funcmode);
763: raise;
764: end;
765:

Line 788: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'decrement_counter', itemtype,

784: end if;
785: return;
786: exception
787: when others then
788: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'decrement_counter', itemtype,
789: itemkey, to_char(actid), funcmode);
790: raise;
791: end;
792:

Line 851: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'set_notified', itemtype,

847: end if;
848: return;
849: exception
850: when others then
851: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'set_notified', itemtype,
852: itemkey, to_char(actid), funcmode);
853: raise;
854: end;
855:

Line 898: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'set_approver', itemtype,

894: return;
895: end if;
896: exception
897: when others then
898: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'set_approver', itemtype,
899: itemkey, to_char(actid), funcmode);
900: raise;
901: end;
902:

Line 1059: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'set_notification', itemtype,

1055: return;
1056: end if;
1057: exception
1058: when others then
1059: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'set_notification', itemtype,
1060: itemkey, to_char(actid), funcmode);
1061: raise;
1062: end;
1063:

Line 1151: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'selector', itemtype,

1147: return;
1148: end if;
1149: exception
1150: when others then
1151: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'selector', itemtype,
1152: itemkey, to_char(actid), command);
1153: raise;
1154: end;
1155:

Line 1187: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'select_process', itemtype,

1183: return;
1184: end if;
1185: exception
1186: when others then
1187: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'select_process', itemtype,
1188: itemkey, to_char(actid), command);
1189: raise;
1190: end;
1191:

Line 1232: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'set_approved', itemtype,

1228: WF_CORE.CONTEXT('OKC_ARTICLE_STATUS_CHANGE_PVT', 'approve', itemtype,
1229: itemkey, to_char(actid), funcmode);
1230: raise;
1231: when others then
1232: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'set_approved', itemtype,
1233: itemkey, to_char(actid), funcmode);
1234: raise;
1235: end;
1236:

Line 1277: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'set_rejected', itemtype,

1273: WF_CORE.CONTEXT('OKC_ARTICLE_STATUS_CHANGE_PVT', 'reject', itemtype,
1274: itemkey, to_char(actid), funcmode);
1275: raise;
1276: when others then
1277: WF_CORE.CONTEXT ( 'OKC_ARTWF_PVT', 'set_rejected', itemtype,
1278: itemkey, to_char(actid), funcmode);
1279: raise;
1280: end;
1281:

Line 1720: generic_error('okc_artwf_pvt.pre_submit_validation', sqlcode, sqlerrm);

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';
1722: end;
1723:
1724: -- -----------------------------------------------------------------------------

Line 1809: generic_error('okc_artwf_pvt.pre_submit_validation', sqlcode, sqlerrm);

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';
1811: end;
1812:
1813: procedure transfer(

Line 1846: wf_core.context( 'OKC_ARTWF_PVT',

1842: 'APPROVER_DISPLAY_NAME',
1843: approver_name);
1844: end if;
1845: exception when others then
1846: wf_core.context( 'OKC_ARTWF_PVT',
1847: 'TRANSFER',
1848: itemtype,
1849: itemkey,
1850: to_char(actid),

Line 1896: return ltrim(str, okc_artwf_pvt.code(str));

1892:
1893: function nid(str in varchar2) return varchar2
1894: is
1895: begin
1896: return ltrim(str, okc_artwf_pvt.code(str));
1897: exception when others then
1898: return null;
1899: end;
1900:

Line 1933: nid := to_number(okc_artwf_pvt.nid(document_id));

1929: begin
1930: start_log('subject');
1931: log('subject entry');
1932: document := 'Undefined';
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;

Line 1934: message_code := okc_artwf_pvt.code(document_id);

1930: start_log('subject');
1931: log('subject entry');
1932: document := 'Undefined';
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);

Line 1935: itemtype := okc_artwf_pvt.itemtype(nid);

1931: log('subject entry');
1932: document := 'Undefined';
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',

Line 1936: itemkey := okc_artwf_pvt.itemkey(nid);

1932: document := 'Undefined';
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',

Line 1968: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'subject', itemtype, itemkey, document_id);

1964: end if;
1965: log('subject exit');
1966: exception
1967: when others then
1968: WF_CORE.CONTEXT ('OKC_ARTWF_PVT', 'subject', itemtype, itemkey, document_id);
1969: raise;
1970: end;
1971:
1972: -- bug 5202585 start