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_REP_SIGN_WF_PVT dependencies on OKC_REP_SIGN_WF_PVT

Line 1: PACKAGE BODY okc_rep_sign_wf_pvt AS

1: PACKAGE BODY okc_rep_sign_wf_pvt AS
2: /* $Header: OKCREPSWFB.pls 120.0.12020000.10 2013/04/25 18:28:20 kkolukul noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- Global VARIABLES

Line 7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REP_SIGN_WF_PVT';

3:
4: ---------------------------------------------------------------------------
5: -- Global VARIABLES
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REP_SIGN_WF_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := 'OKC';
9: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
10:
11: G_OBJECT_NAME CONSTANT VARCHAR2(200) := 'OKC_REP_CONTRACT';

Line 121: 'Entered OKC_REP_SIGN_WF_PVT.initialize_attributes');

117: l_api_name := 'initialize_attributes';
118:
119: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
120: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
121: 'Entered OKC_REP_SIGN_WF_PVT.initialize_attributes');
122: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
123: 'Item Type is: ' || itemtype);
124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
125: 'Item Key is: ' || itemkey);

Line 229: 'Leaving OKC_REP_SIGN_WF_PVT.initialize_attributes from funcmode=RUN');

225: resultout := 'COMPLETE:';
226: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
227: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
228: g_module || l_api_name ,
229: 'Leaving OKC_REP_SIGN_WF_PVT.initialize_attributes from funcmode=RUN');
230: END IF;
231: RETURN;
232: END IF; -- (funcmode = 'RUN')
233:

Line 240: 'Leaving OKC_REP_SIGN_WF_PVT.initialize_attributes from funcmode=CANCEL');

236: resultout := 'COMPLETE:';
237: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
238: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
239: g_module || l_api_name,
240: 'Leaving OKC_REP_SIGN_WF_PVT.initialize_attributes from funcmode=CANCEL');
241: END IF;
242: RETURN;
243: END IF; -- (funcmode = 'CANCEL')
244:

Line 250: 'Leaving OKC_REP_SIGN_WF_PVT.initialize_attributes from funcmode=TIMEOUT');

246: resultout := 'COMPLETE:';
247: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
248: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
249: g_module || l_api_name,
250: 'Leaving OKC_REP_SIGN_WF_PVT.initialize_attributes from funcmode=TIMEOUT');
251: END IF;
252: RETURN;
253: END IF; -- (funcmode = 'TIMEOUT')
254:

Line 264: 'Leaving OKC_REP_SIGN_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);

260: END IF;
261: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
262: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
263: g_module || l_api_name,
264: 'Leaving OKC_REP_SIGN_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
265: END IF;
266: wf_core.context('OKC_REP_SIGN_WF_PVT',
267: 'initialize_attributes',
268: itemtype,

Line 266: wf_core.context('OKC_REP_SIGN_WF_PVT',

262: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
263: g_module || l_api_name,
264: 'Leaving OKC_REP_SIGN_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
265: END IF;
266: wf_core.context('OKC_REP_SIGN_WF_PVT',
267: 'initialize_attributes',
268: itemtype,
269: itemkey,
270: to_char(actid),

Line 498: 'Entered OKC_REP_SIGN_WF_PVT.has_next_signer');

494:
495:
496: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
497: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
498: 'Entered OKC_REP_SIGN_WF_PVT.has_next_signer');
499: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
500: 'Item Type is: ' || itemtype);
501: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
502: 'Item Key is: ' || itemkey);

Line 833: 'Leaving OKC_REP_SIGN_WF_PVT.has_next_signer from funcmode=RUN');

829:
830: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
831: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
832: g_module || l_api_name,
833: 'Leaving OKC_REP_SIGN_WF_PVT.has_next_signer from funcmode=RUN');
834: END IF;
835: RETURN;
836: END IF; -- (funcmode = 'RUN')
837:

Line 844: 'Leaving OKC_REP_SIGN_WF_PVT.has_next_signer from funcmode=CANCEL');

840: resultout := 'COMPLETE:';
841: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
842: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
843: g_module || l_api_name,
844: 'Leaving OKC_REP_SIGN_WF_PVT.has_next_signer from funcmode=CANCEL');
845: END IF;
846: RETURN;
847: END IF; -- (funcmode = 'CANCEL')
848:

Line 854: 'Leaving OKC_REP_SIGN_WF_PVT.has_next_signer from funcmode=TIMEOUT');

850: resultout := 'COMPLETE:';
851: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
852: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
853: g_module || l_api_name,
854: 'Leaving OKC_REP_SIGN_WF_PVT.has_next_signer from funcmode=TIMEOUT');
855: END IF;
856: RETURN;
857: END IF; -- (funcmode = 'TIMEOUT')
858:

Line 864: 'Leaving OKC_REP_SIGN_WF_PVT.has_next_signer with exceptions ' || sqlerrm);

860: WHEN others THEN
861: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
862: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
863: g_module || l_api_name,
864: 'Leaving OKC_REP_SIGN_WF_PVT.has_next_signer with exceptions ' || sqlerrm);
865: END IF;
866: wf_core.context('OKC_REP_SIGN_WF_PVT',
867: 'has_next_signer',
868: itemtype,

Line 866: wf_core.context('OKC_REP_SIGN_WF_PVT',

862: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
863: g_module || l_api_name,
864: 'Leaving OKC_REP_SIGN_WF_PVT.has_next_signer with exceptions ' || sqlerrm);
865: END IF;
866: wf_core.context('OKC_REP_SIGN_WF_PVT',
867: 'has_next_signer',
868: itemtype,
869: itemkey,
870: to_char(actid),

Line 960: 'Entered OKC_REP_SIGN_WF_PVT.update_hist_status_detailed');

956: l_api_name := 'update_hist_status_detailed';
957:
958: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
959: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
960: 'Entered OKC_REP_SIGN_WF_PVT.update_hist_status_detailed');
961: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
962: 'Item Type is: ' || itemtype);
963: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
964: 'Item Key is: ' || itemkey);

Line 1258: 'Leaving OKC_REP_SIGN_WF_PVT.update_hist_status_detailed from funcmode=RUN');

1254: END IF;
1255: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1256: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1257: g_module || l_api_name,
1258: 'Leaving OKC_REP_SIGN_WF_PVT.update_hist_status_detailed from funcmode=RUN');
1259: END IF;
1260: CLOSE notif_csr;
1261: --RETURN;
1262: END IF; -- (funcmode = 'RUN')

Line 1267: 'In OKC_REP_SIGN_WF_PVT.update_hist_status_detailed funcmode=TIMEOUT');

1263:
1264: IF (funcmode = 'TIMEOUT') THEN
1265: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1266: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1267: 'In OKC_REP_SIGN_WF_PVT.update_hist_status_detailed funcmode=TIMEOUT');
1268: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1269: 'Calling OKC_REP_UTIL_PVT.add_signature_hist_record');
1270: END IF;
1271: OKC_REP_UTIL_PVT.add_signature_hist_record(

Line 1310: 'Leaving OKC_REP_SIGN_WF_PVT.update_hist_status_detailed');

1306:
1307: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1308: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1309: g_module || l_api_name,
1310: 'Leaving OKC_REP_SIGN_WF_PVT.update_hist_status_detailed');
1311: END IF;
1312:
1313:
1314: EXCEPTION

Line 1320: '618: Leaving OKC_REP_SIGN_WF_PVT.update_hist_status_detailed with exceptions ' || sqlerrm);

1316: when others then
1317: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1318: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1319: g_module || l_api_name,
1320: '618: Leaving OKC_REP_SIGN_WF_PVT.update_hist_status_detailed with exceptions ' || sqlerrm);
1321: END IF;
1322: --close cursors
1323: IF (notif_csr%ISOPEN) THEN
1324: CLOSE notif_csr ;

Line 1326: wf_core.context('OKC_REP_SIGN_WF_PVT',

1322: --close cursors
1323: IF (notif_csr%ISOPEN) THEN
1324: CLOSE notif_csr ;
1325: END IF;
1326: wf_core.context('OKC_REP_SIGN_WF_PVT',
1327: 'update_hist_status_detailed',
1328: itemtype,
1329: itemkey,
1330: to_char(actid),

Line 1399: 'Entered OKC_REP_SIGN_WF_PVT.sign_contract');

1395: l_api_name := 'sign_contract';
1396:
1397: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1398: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1399: 'Entered OKC_REP_SIGN_WF_PVT.sign_contract');
1400: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1401: 'Item Type is: ' || itemtype);
1402: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1403: 'Item Key is: ' || itemkey);

Line 1658: 'Leaving OKC_REP_sign_WF_PVT.sign_contract');

1654: resultout := 'COMPLETE:';
1655: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1656: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1657: g_module || l_api_name,
1658: 'Leaving OKC_REP_sign_WF_PVT.sign_contract');
1659: END IF;
1660: RETURN;
1661: END IF; -- (funcmode = 'RUN')
1662:

Line 1668: 'Leaving OKC_REP_sign_WF_PVT.sign_contract with exceptions ' || sqlerrm);

1664: WHEN others THEN
1665: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1666: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1667: g_module || l_api_name,
1668: 'Leaving OKC_REP_sign_WF_PVT.sign_contract with exceptions ' || sqlerrm);
1669: END IF;
1670: wf_core.context('OKC_REP_SIGN_WF_PVT',
1671: 'sign_contract',
1672: itemtype,

Line 1670: wf_core.context('OKC_REP_SIGN_WF_PVT',

1666: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1667: g_module || l_api_name,
1668: 'Leaving OKC_REP_sign_WF_PVT.sign_contract with exceptions ' || sqlerrm);
1669: END IF;
1670: wf_core.context('OKC_REP_SIGN_WF_PVT',
1671: 'sign_contract',
1672: itemtype,
1673: itemkey,
1674: to_char(actid),

Line 1719: 'Entered OKC_REP_SIGN_WF_PVT.reject_contract');

1715: l_api_name := 'reject_contract';
1716:
1717: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1719: 'Entered OKC_REP_SIGN_WF_PVT.reject_contract');
1720: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1721: 'Item Type is: ' || itemtype);
1722: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1723: 'Item Key is: ' || itemkey);

Line 1778: 'Leaving OKC_REP_SIGN_WF_PVT.reject_contract');

1774: resultout := 'COMPLETE:';
1775: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1776: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1777: g_module || l_api_name,
1778: 'Leaving OKC_REP_SIGN_WF_PVT.reject_contract');
1779: END IF;
1780: RETURN;
1781: END IF; -- (funcmode = 'RUN')
1782: EXCEPTION

Line 1787: 'Leaving OKC_REP_SIGN_WF_PVT.reject_contract with exceptions ' || sqlerrm);

1783: WHEN others THEN
1784: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1785: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1786: g_module || l_api_name,
1787: 'Leaving OKC_REP_SIGN_WF_PVT.reject_contract with exceptions ' || sqlerrm);
1788: END IF;
1789: wf_core.context('OKC_REP_SIGN_WF_PVT',
1790: 'reject_contract',
1791: itemtype,

Line 1789: wf_core.context('OKC_REP_SIGN_WF_PVT',

1785: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1786: g_module || l_api_name,
1787: 'Leaving OKC_REP_SIGN_WF_PVT.reject_contract with exceptions ' || sqlerrm);
1788: END IF;
1789: wf_core.context('OKC_REP_SIGN_WF_PVT',
1790: 'reject_contract',
1791: itemtype,
1792: itemkey,
1793: to_char(actid),

Line 1843: 'Entered OKC_REP_SIGN_WF_PVT.complete_notification');

1839: l_api_name := 'con_has_terms';
1840:
1841: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1843: 'Entered OKC_REP_SIGN_WF_PVT.complete_notification');
1844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1845: 'Item Type is: ' || itemtype);
1846: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1847: 'Item Key is: ' || itemkey);

Line 1879: 'Leaving OKC_REP_SIGN_WF_PVT.con_has_terms with exceptions ' || sqlerrm);

1875: WHEN others THEN
1876: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1877: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1878: g_module || l_api_name,
1879: 'Leaving OKC_REP_SIGN_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
1880: END IF;
1881: wf_core.context('OKC_REP_SIGN_WF_PVT',
1882: 'con_has_terms',
1883: itemtype,

Line 1881: wf_core.context('OKC_REP_SIGN_WF_PVT',

1877: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1878: g_module || l_api_name,
1879: 'Leaving OKC_REP_SIGN_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
1880: END IF;
1881: wf_core.context('OKC_REP_SIGN_WF_PVT',
1882: 'con_has_terms',
1883: itemtype,
1884: itemkey,
1885: to_char(actid),

Line 1942: 'Entered OKC_REP_SIGN_WF_PVT.complete_notification');

1938: l_api_name := 'con_attach_generated_yn';
1939:
1940: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1941: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1942: 'Entered OKC_REP_SIGN_WF_PVT.complete_notification');
1943: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1944: 'Item Type is: ' || itemtype);
1945: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1946: 'Item Key is: ' || itemkey);

Line 1989: 'Leaving OKC_REP_SIGN_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);

1985: WHEN others THEN
1986: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1987: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1988: g_module || l_api_name,
1989: 'Leaving OKC_REP_SIGN_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
1990: END IF;
1991: wf_core.context('OKC_REP_SIGN_WF_PVT',
1992: 'con_attach_generated_yn',
1993: itemtype,

Line 1991: wf_core.context('OKC_REP_SIGN_WF_PVT',

1987: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1988: g_module || l_api_name,
1989: 'Leaving OKC_REP_SIGN_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
1990: END IF;
1991: wf_core.context('OKC_REP_SIGN_WF_PVT',
1992: 'con_attach_generated_yn',
1993: itemtype,
1994: itemkey,
1995: to_char(actid),

Line 2037: 'Entered OKC_REP_SIGN_WF_PVT.contract_preview_yn');

2033: l_api_name := 'contract_preview_yn';
2034:
2035: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2036: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2037: 'Entered OKC_REP_SIGN_WF_PVT.contract_preview_yn');
2038: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2039: 'Item Type is: ' || itemtype);
2040: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2041: 'Item Key is: ' || itemkey);

Line 2075: 'Leaving OKC_REP_SIGN_WF_PVT.contract_preview_yn with exceptions ' || sqlerrm);

2071: WHEN others THEN
2072: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2073: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2074: g_module || l_api_name,
2075: 'Leaving OKC_REP_SIGN_WF_PVT.contract_preview_yn with exceptions ' || sqlerrm);
2076: END IF;
2077: wf_core.context('OKC_REP_SIGN_WF_PVT',
2078: 'contract_preview_yn',
2079: itemtype,

Line 2077: wf_core.context('OKC_REP_SIGN_WF_PVT',

2073: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2074: g_module || l_api_name,
2075: 'Leaving OKC_REP_SIGN_WF_PVT.contract_preview_yn with exceptions ' || sqlerrm);
2076: END IF;
2077: wf_core.context('OKC_REP_SIGN_WF_PVT',
2078: 'contract_preview_yn',
2079: itemtype,
2080: itemkey,
2081: to_char(actid),

Line 2180: END okc_rep_sign_wf_pvt;

2176: raise;
2177:
2178: END Apps_initialize;
2179:
2180: END okc_rep_sign_wf_pvt;