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_WF_PVT dependencies on OKC_REP_WF_PVT

Line 1: PACKAGE BODY OKC_REP_WF_PVT AS

1: PACKAGE BODY OKC_REP_WF_PVT AS
2: /* $Header: OKCVREPWFB.pls 120.5.12010000.2 2008/11/14 11:35:43 harchand ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- Global VARIABLES

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

3:
4: ---------------------------------------------------------------------------
5: -- Global VARIABLES
6: ---------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_REP_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 102: 'Entered OKC_REP_WF_PVT.initialize_attributes');

98: l_api_name := 'initialize_attributes';
99:
100: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
101: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
102: 'Entered OKC_REP_WF_PVT.initialize_attributes');
103: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
104: 'Item Type is: ' || itemtype);
105: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
106: 'Item Key is: ' || itemkey);

Line 189: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=RUN');

185: resultout := 'COMPLETE:';
186: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
187: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
188: g_module || l_api_name ,
189: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=RUN');
190: END IF;
191: RETURN;
192: END IF; -- (funcmode = 'RUN')
193:

Line 200: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=CANCEL');

196: resultout := 'COMPLETE:';
197: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
198: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
199: g_module || l_api_name,
200: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=CANCEL');
201: END IF;
202: RETURN;
203: END IF; -- (funcmode = 'CANCEL')
204:

Line 210: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=TIMEOUT');

206: resultout := 'COMPLETE:';
207: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
208: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
209: g_module || l_api_name,
210: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=TIMEOUT');
211: END IF;
212: RETURN;
213: END IF; -- (funcmode = 'TIMEOUT')
214:

Line 224: 'Leaving OKC_REP_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);

220: END IF;
221: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
222: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
223: g_module || l_api_name,
224: 'Leaving OKC_REP_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
225: END IF;
226: wf_core.context('OKC_REP_WF_PVT',
227: 'initialize_attributes',
228: itemtype,

Line 226: wf_core.context('OKC_REP_WF_PVT',

222: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
223: g_module || l_api_name,
224: 'Leaving OKC_REP_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
225: END IF;
226: wf_core.context('OKC_REP_WF_PVT',
227: 'initialize_attributes',
228: itemtype,
229: itemkey,
230: to_char(actid),

Line 280: 'Entered OKC_REP_WF_PVT.has_next_approver');

276: l_api_name := 'has_next_approver';
277:
278: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
280: 'Entered OKC_REP_WF_PVT.has_next_approver');
281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
282: 'Item Type is: ' || itemtype);
283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
284: 'Item Key is: ' || itemkey);

Line 391: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=RUN');

387:
388: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
389: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
390: g_module || l_api_name,
391: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=RUN');
392: END IF;
393: RETURN;
394: END IF; -- (funcmode = 'RUN')
395:

Line 402: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=CANCEL');

398: resultout := 'COMPLETE:';
399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
400: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
401: g_module || l_api_name,
402: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=CANCEL');
403: END IF;
404: RETURN;
405: END IF; -- (funcmode = 'CANCEL')
406:

Line 412: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=TIMEOUT');

408: resultout := 'COMPLETE:';
409: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
410: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
411: g_module || l_api_name,
412: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=TIMEOUT');
413: END IF;
414: RETURN;
415: END IF; -- (funcmode = 'TIMEOUT')
416:

Line 422: 'Leaving OKC_REP_WF_PVT.has_next_approver with exceptions ' || sqlerrm);

418: WHEN others THEN
419: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
420: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
421: g_module || l_api_name,
422: 'Leaving OKC_REP_WF_PVT.has_next_approver with exceptions ' || sqlerrm);
423: END IF;
424: wf_core.context('OKC_REP_WF_PVT',
425: 'has_next_approver',
426: itemtype,

Line 424: wf_core.context('OKC_REP_WF_PVT',

420: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
421: g_module || l_api_name,
422: 'Leaving OKC_REP_WF_PVT.has_next_approver with exceptions ' || sqlerrm);
423: END IF;
424: wf_core.context('OKC_REP_WF_PVT',
425: 'has_next_approver',
426: itemtype,
427: itemkey,
428: to_char(actid),

Line 489: 'Entered OKC_REP_WF_PVT.is_approval_complete');

485:
486:
487: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
488: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
489: 'Entered OKC_REP_WF_PVT.is_approval_complete');
490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
491: 'Item Type is: ' || itemtype);
492: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
493: 'Item Key is: ' || itemkey);

Line 711: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=RUN');

707:
708: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
709: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
710: g_module || l_api_name,
711: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=RUN');
712: END IF;
713: RETURN;
714: END IF; -- (funcmode = 'RUN')
715:

Line 722: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=CANCEL');

718: resultout := 'COMPLETE:';
719: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
720: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
721: g_module || l_api_name,
722: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=CANCEL');
723: END IF;
724: RETURN;
725: END IF; -- (funcmode = 'CANCEL')
726:

Line 732: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=TIMEOUT');

728: resultout := 'COMPLETE:';
729: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
730: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
731: g_module || l_api_name,
732: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=TIMEOUT');
733: END IF;
734: RETURN;
735: END IF; -- (funcmode = 'TIMEOUT')
736:

Line 742: 'Leaving OKC_REP_WF_PVT.is_approval_complete with exceptions ' || sqlerrm);

738: WHEN others THEN
739: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
740: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
741: g_module || l_api_name,
742: 'Leaving OKC_REP_WF_PVT.is_approval_complete with exceptions ' || sqlerrm);
743: END IF;
744: wf_core.context('OKC_REP_WF_PVT',
745: 'is_approval_complete',
746: itemtype,

Line 744: wf_core.context('OKC_REP_WF_PVT',

740: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
741: g_module || l_api_name,
742: 'Leaving OKC_REP_WF_PVT.is_approval_complete with exceptions ' || sqlerrm);
743: END IF;
744: wf_core.context('OKC_REP_WF_PVT',
745: 'is_approval_complete',
746: itemtype,
747: itemkey,
748: to_char(actid),

Line 824: 'Entered OKC_REP_WF_PVT.update_ame_status');

820: l_api_name := 'update_ame_status';
821:
822: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
823: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
824: 'Entered OKC_REP_WF_PVT.update_ame_status');
825: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
826: 'Item Type is: ' || itemtype);
827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
828: 'Item Key is: ' || itemkey);

Line 977: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RESPOND');

973: g_module || l_api_name,
974: 'resultout value is: ' || resultout);
975: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
976: g_module || l_api_name,
977: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RESPOND');
978: END IF;
979: END IF; -- (funcmode = 'RESPOND')
980:
981:

Line 994: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RUN');

990: END IF;
991: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
992: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
993: g_module || l_api_name,
994: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RUN');
995: END IF;
996: CLOSE notif_csr;
997: RETURN;
998: END IF; -- (funcmode = 'RUN')

Line 1003: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');

999:
1000: IF (funcmode = 'TIMEOUT') THEN
1001: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1002: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1003: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1004: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1005: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1006: END IF;
1007: OKC_REP_UTIL_PVT.add_approval_hist_record(

Line 1046: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=TIMEOUT');

1042:
1043: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1045: g_module || l_api_name,
1046: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=TIMEOUT');
1047: END IF;
1048: resultout := 'COMPLETE:';
1049: CLOSE notif_csr;
1050: RETURN;

Line 1058: '618: Leaving OKC_REP_WF_PVT.update_ame_status with exceptions ' || sqlerrm);

1054: when others then
1055: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1056: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1057: g_module || l_api_name,
1058: '618: Leaving OKC_REP_WF_PVT.update_ame_status with exceptions ' || sqlerrm);
1059: END IF;
1060: --close cursors
1061: IF (notif_csr%ISOPEN) THEN
1062: CLOSE notif_csr ;

Line 1064: wf_core.context('OKC_REP_WF_PVT',

1060: --close cursors
1061: IF (notif_csr%ISOPEN) THEN
1062: CLOSE notif_csr ;
1063: END IF;
1064: wf_core.context('OKC_REP_WF_PVT',
1065: 'update_ame_status',
1066: itemtype,
1067: itemkey,
1068: to_char(actid),

Line 1139: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');

1135: l_api_name := 'update_ame_status';
1136:
1137: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1138: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1139: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1140: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1141: 'Item Type is: ' || itemtype);
1142: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1143: 'Item Key is: ' || itemkey);

Line 1301: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RESPOND');

1297: g_module || l_api_name,
1298: 'resultout value is: ' || resultout);
1299: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1300: g_module || l_api_name,
1301: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RESPOND');
1302: END IF;
1303: END IF; -- (funcmode = 'RESPOND')
1304:
1305:

Line 1318: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RUN');

1314: END IF;
1315: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1317: g_module || l_api_name,
1318: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RUN');
1319: END IF;
1320: CLOSE notif_csr;
1321: RETURN;
1322: END IF; -- (funcmode = 'RUN')

Line 1327: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');

1323:
1324: IF (funcmode = 'TIMEOUT') THEN
1325: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1326: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1327: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1328: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1329: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1330: END IF;
1331: OKC_REP_UTIL_PVT.add_approval_hist_record(

Line 1371: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=TIMEOUT');

1367:
1368: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1369: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1370: g_module || l_api_name,
1371: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=TIMEOUT');
1372: END IF;
1373: resultout := 'COMPLETE:';
1374: CLOSE notif_csr;
1375: RETURN;

Line 1383: '618: Leaving OKC_REP_WF_PVT.update_ame_status_detailed with exceptions ' || sqlerrm);

1379: when others then
1380: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1382: g_module || l_api_name,
1383: '618: Leaving OKC_REP_WF_PVT.update_ame_status_detailed with exceptions ' || sqlerrm);
1384: END IF;
1385: --close cursors
1386: IF (notif_csr%ISOPEN) THEN
1387: CLOSE notif_csr ;

Line 1389: wf_core.context('OKC_REP_WF_PVT',

1385: --close cursors
1386: IF (notif_csr%ISOPEN) THEN
1387: CLOSE notif_csr ;
1388: END IF;
1389: wf_core.context('OKC_REP_WF_PVT',
1390: 'update_ame_status_detailed',
1391: itemtype,
1392: itemkey,
1393: to_char(actid),

Line 1443: 'Entered OKC_REP_WF_PVT.approve_contract');

1439: l_api_name := 'approve_contract';
1440:
1441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1442: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1443: 'Entered OKC_REP_WF_PVT.approve_contract');
1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1445: 'Item Type is: ' || itemtype);
1446: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1447: 'Item Key is: ' || itemkey);

Line 1502: 'Leaving OKC_REP_WF_PVT.approve_contract');

1498: resultout := 'COMPLETE:';
1499: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1500: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1501: g_module || l_api_name,
1502: 'Leaving OKC_REP_WF_PVT.approve_contract');
1503: END IF;
1504: RETURN;
1505: END IF; -- (funcmode = 'RUN')
1506:

Line 1512: 'Leaving OKC_REP_WF_PVT.approve_contract with exceptions ' || sqlerrm);

1508: WHEN others THEN
1509: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1510: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1511: g_module || l_api_name,
1512: 'Leaving OKC_REP_WF_PVT.approve_contract with exceptions ' || sqlerrm);
1513: END IF;
1514: wf_core.context('OKC_REP_WF_PVT',
1515: 'approve_contract',
1516: itemtype,

Line 1514: wf_core.context('OKC_REP_WF_PVT',

1510: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1511: g_module || l_api_name,
1512: 'Leaving OKC_REP_WF_PVT.approve_contract with exceptions ' || sqlerrm);
1513: END IF;
1514: wf_core.context('OKC_REP_WF_PVT',
1515: 'approve_contract',
1516: itemtype,
1517: itemkey,
1518: to_char(actid),

Line 1564: 'Entered OKC_REP_WF_PVT.reject_contract');

1560: l_api_name := 'reject_contract';
1561:
1562: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1563: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1564: 'Entered OKC_REP_WF_PVT.reject_contract');
1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1566: 'Item Type is: ' || itemtype);
1567: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1568: 'Item Key is: ' || itemkey);

Line 1623: 'Leaving OKC_REP_WF_PVT.reject_contract');

1619: resultout := 'COMPLETE:';
1620: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1621: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1622: g_module || l_api_name,
1623: 'Leaving OKC_REP_WF_PVT.reject_contract');
1624: END IF;
1625: RETURN;
1626: END IF; -- (funcmode = 'RUN')
1627: EXCEPTION

Line 1632: 'Leaving OKC_REP_WF_PVT.reject_contract with exceptions ' || sqlerrm);

1628: WHEN others THEN
1629: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1630: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1631: g_module || l_api_name,
1632: 'Leaving OKC_REP_WF_PVT.reject_contract with exceptions ' || sqlerrm);
1633: END IF;
1634: wf_core.context('OKC_REP_WF_PVT',
1635: 'reject_contract',
1636: itemtype,

Line 1634: wf_core.context('OKC_REP_WF_PVT',

1630: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1631: g_module || l_api_name,
1632: 'Leaving OKC_REP_WF_PVT.reject_contract with exceptions ' || sqlerrm);
1633: END IF;
1634: wf_core.context('OKC_REP_WF_PVT',
1635: 'reject_contract',
1636: itemtype,
1637: itemkey,
1638: to_char(actid),

Line 1686: 'Entered OKC_REP_WF_PVT.is_contract_approved');

1682: l_api_name := 'is_contract_approved';
1683:
1684: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1685: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1686: 'Entered OKC_REP_WF_PVT.is_contract_approved');
1687: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1688: 'Item Type is: ' || itemtype);
1689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1690: 'Item Key is: ' || itemkey);

Line 1750: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=RUN');

1746: END IF;
1747: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1748: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1749: g_module || l_api_name,
1750: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=RUN');
1751: END IF;
1752: RETURN;
1753: END IF; -- (funcmode = 'RUN')
1754:

Line 1760: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=CANCEL');

1756: resultout := 'COMPLETE:';
1757: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1758: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1759: g_module || l_api_name,
1760: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=CANCEL');
1761: END IF;
1762: RETURN;
1763: END IF; -- (funcmode = 'CANCEL')
1764:

Line 1770: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=TIMEOUT');

1766: resultout := 'COMPLETE:';
1767: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1768: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1769: g_module || l_api_name,
1770: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=TIMEOUT');
1771: END IF;
1772: RETURN;
1773: END IF; -- (funcmode = 'TIMEOUT')
1774:

Line 1780: 'Leaving OKC_REP_WF_PVT.is_contract_approved with exceptions ' || sqlerrm);

1776: WHEN others THEN
1777: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1778: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1779: g_module || l_api_name,
1780: 'Leaving OKC_REP_WF_PVT.is_contract_approved with exceptions ' || sqlerrm);
1781: END IF;
1782: wf_core.context('OKC_REP_WF_PVT',
1783: 'is_contract_approved',
1784: itemtype,

Line 1782: wf_core.context('OKC_REP_WF_PVT',

1778: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1779: g_module || l_api_name,
1780: 'Leaving OKC_REP_WF_PVT.is_contract_approved with exceptions ' || sqlerrm);
1781: END IF;
1782: wf_core.context('OKC_REP_WF_PVT',
1783: 'is_contract_approved',
1784: itemtype,
1785: itemkey,
1786: to_char(actid),

Line 1844: 'Entered OKC_REP_WF_PVT.is_contract_approved');

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

Line 1928: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=RUN');

1924:
1925: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1926: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1927: g_module || l_api_name,
1928: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=RUN');
1929: END IF;
1930: RETURN;
1931: END IF; -- (funcmode = 'RUN')
1932:

Line 1938: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=CANCEL');

1934: resultout := 'COMPLETE:';
1935: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1936: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1937: g_module || l_api_name,
1938: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=CANCEL');
1939: END IF;
1940: RETURN;
1941: END IF; -- (funcmode = 'CANCEL')
1942:

Line 1948: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=TIMEOUT');

1944: resultout := 'COMPLETE:';
1945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1946: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1947: g_module || l_api_name,
1948: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=TIMEOUT');
1949: END IF;
1950: RETURN;
1951: END IF; -- (funcmode = 'TIMEOUT')
1952:

Line 1958: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed with exceptions ' || sqlerrm);

1954: WHEN others THEN
1955: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1956: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1957: g_module || l_api_name,
1958: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed with exceptions ' || sqlerrm);
1959: END IF;
1960: wf_core.context('OKC_REP_WF_PVT',
1961: 'is_contract_approved_detailed',
1962: itemtype,

Line 1960: wf_core.context('OKC_REP_WF_PVT',

1956: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1957: g_module || l_api_name,
1958: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed with exceptions ' || sqlerrm);
1959: END IF;
1960: wf_core.context('OKC_REP_WF_PVT',
1961: 'is_contract_approved_detailed',
1962: itemtype,
1963: itemkey,
1964: to_char(actid),

Line 2013: 'Entered OKC_REP_WF_PVT.complete_notification');

2009: l_api_name := 'complete_notification';
2010:
2011: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2013: 'Entered OKC_REP_WF_PVT.complete_notification');
2014: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2015: 'Item Type is: ' || itemtype);
2016: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2017: 'Item Key is: ' || itemkey);

Line 2045: 'Leaving OKC_REP_WF_PVT.complete_notification');

2041: resultout := 'COMPLETE:';
2042: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2043: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2044: g_module || l_api_name,
2045: 'Leaving OKC_REP_WF_PVT.complete_notification');
2046: END IF;
2047: RETURN;
2048: END IF; -- (funcmode = 'RUN')
2049: EXCEPTION

Line 2054: 'Leaving OKC_REP_WF_PVT.complete_notification with exceptions ' || sqlerrm);

2050: WHEN others THEN
2051: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2052: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2053: g_module || l_api_name,
2054: 'Leaving OKC_REP_WF_PVT.complete_notification with exceptions ' || sqlerrm);
2055: END IF;
2056: wf_core.context('OKC_REP_WF_PVT',
2057: 'complete_notification',
2058: itemtype,

Line 2056: wf_core.context('OKC_REP_WF_PVT',

2052: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2053: g_module || l_api_name,
2054: 'Leaving OKC_REP_WF_PVT.complete_notification with exceptions ' || sqlerrm);
2055: END IF;
2056: wf_core.context('OKC_REP_WF_PVT',
2057: 'complete_notification',
2058: itemtype,
2059: itemkey,
2060: to_char(actid),

Line 2109: 'Entered OKC_REP_WF_PVT.complete_notification');

2105: l_api_name := 'con_has_terms';
2106:
2107: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2108: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2109: 'Entered OKC_REP_WF_PVT.complete_notification');
2110: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2111: 'Item Type is: ' || itemtype);
2112: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2113: 'Item Key is: ' || itemkey);

Line 2145: 'Leaving OKC_REP_WF_PVT.con_has_terms with exceptions ' || sqlerrm);

2141: WHEN others THEN
2142: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2143: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2144: g_module || l_api_name,
2145: 'Leaving OKC_REP_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
2146: END IF;
2147: wf_core.context('OKC_REP_WF_PVT',
2148: 'con_has_terms',
2149: itemtype,

Line 2147: wf_core.context('OKC_REP_WF_PVT',

2143: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2144: g_module || l_api_name,
2145: 'Leaving OKC_REP_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
2146: END IF;
2147: wf_core.context('OKC_REP_WF_PVT',
2148: 'con_has_terms',
2149: itemtype,
2150: itemkey,
2151: to_char(actid),

Line 2207: 'Entered OKC_REP_WF_PVT.complete_notification');

2203: l_api_name := 'con_attach_generated_yn';
2204:
2205: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2206: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2207: 'Entered OKC_REP_WF_PVT.complete_notification');
2208: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2209: 'Item Type is: ' || itemtype);
2210: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2211: 'Item Key is: ' || itemkey);

Line 2254: 'Leaving OKC_REP_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);

2250: WHEN others THEN
2251: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2252: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2253: g_module || l_api_name,
2254: 'Leaving OKC_REP_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
2255: END IF;
2256: wf_core.context('OKC_REP_WF_PVT',
2257: 'con_attach_generated_yn',
2258: itemtype,

Line 2256: wf_core.context('OKC_REP_WF_PVT',

2252: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2253: g_module || l_api_name,
2254: 'Leaving OKC_REP_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
2255: END IF;
2256: wf_core.context('OKC_REP_WF_PVT',
2257: 'con_attach_generated_yn',
2258: itemtype,
2259: itemkey,
2260: to_char(actid),

Line 2266: END OKC_REP_WF_PVT;

2262: raise;
2263:
2264: END con_attach_generated_yn;
2265:
2266: END OKC_REP_WF_PVT;