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.10.12020000.12 2013/04/11 07:40:49 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 119: 'Entered OKC_REP_WF_PVT.initialize_attributes');

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

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

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

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

214: resultout := 'COMPLETE:';
215: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
216: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
217: g_module || l_api_name,
218: 'Leaving OKC_REP_WF_PVT.initialize_attributes from funcmode=CANCEL');
219: END IF;
220: RETURN;
221: END IF; -- (funcmode = 'CANCEL')
222:

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

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

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

238: END IF;
239: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
240: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
241: g_module || l_api_name,
242: 'Leaving OKC_REP_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
243: END IF;
244: wf_core.context('OKC_REP_WF_PVT',
245: 'initialize_attributes',
246: itemtype,

Line 244: wf_core.context('OKC_REP_WF_PVT',

240: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
241: g_module || l_api_name,
242: 'Leaving OKC_REP_WF_PVT.initialize_attributes with exceptions ' || sqlerrm);
243: END IF;
244: wf_core.context('OKC_REP_WF_PVT',
245: 'initialize_attributes',
246: itemtype,
247: itemkey,
248: to_char(actid),

Line 298: 'Entered OKC_REP_WF_PVT.has_next_approver');

294: l_api_name := 'has_next_approver';
295:
296: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
297: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
298: 'Entered OKC_REP_WF_PVT.has_next_approver');
299: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
300: 'Item Type is: ' || itemtype);
301: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
302: 'Item Key is: ' || itemkey);

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

405:
406: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
407: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
408: g_module || l_api_name,
409: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=RUN');
410: END IF;
411: RETURN;
412: END IF; -- (funcmode = 'RUN')
413:

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

416: resultout := 'COMPLETE:';
417: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
419: g_module || l_api_name,
420: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=CANCEL');
421: END IF;
422: RETURN;
423: END IF; -- (funcmode = 'CANCEL')
424:

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

426: resultout := 'COMPLETE:';
427: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
428: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
429: g_module || l_api_name,
430: 'Leaving OKC_REP_WF_PVT.has_next_approver from funcmode=TIMEOUT');
431: END IF;
432: RETURN;
433: END IF; -- (funcmode = 'TIMEOUT')
434:

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

436: WHEN others THEN
437: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
438: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
439: g_module || l_api_name,
440: 'Leaving OKC_REP_WF_PVT.has_next_approver with exceptions ' || sqlerrm);
441: END IF;
442: wf_core.context('OKC_REP_WF_PVT',
443: 'has_next_approver',
444: itemtype,

Line 442: wf_core.context('OKC_REP_WF_PVT',

438: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
439: g_module || l_api_name,
440: 'Leaving OKC_REP_WF_PVT.has_next_approver with exceptions ' || sqlerrm);
441: END IF;
442: wf_core.context('OKC_REP_WF_PVT',
443: 'has_next_approver',
444: itemtype,
445: itemkey,
446: to_char(actid),

Line 510: 'Entered OKC_REP_WF_PVT.is_approval_complete');

506:
507:
508: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
509: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
510: 'Entered OKC_REP_WF_PVT.is_approval_complete');
511: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
512: 'Item Type is: ' || itemtype);
513: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
514: 'Item Key is: ' || itemkey);

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

846:
847: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
849: g_module || l_api_name,
850: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=RUN');
851: END IF;
852: RETURN;
853: END IF; -- (funcmode = 'RUN')
854:

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

857: resultout := 'COMPLETE:';
858: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
860: g_module || l_api_name,
861: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=CANCEL');
862: END IF;
863: RETURN;
864: END IF; -- (funcmode = 'CANCEL')
865:

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

867: resultout := 'COMPLETE:';
868: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
869: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
870: g_module || l_api_name,
871: 'Leaving OKC_REP_WF_PVT.is_approval_complete from funcmode=TIMEOUT');
872: END IF;
873: RETURN;
874: END IF; -- (funcmode = 'TIMEOUT')
875:

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

877: WHEN others THEN
878: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
879: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
880: g_module || l_api_name,
881: 'Leaving OKC_REP_WF_PVT.is_approval_complete with exceptions ' || sqlerrm);
882: END IF;
883: wf_core.context('OKC_REP_WF_PVT',
884: 'is_approval_complete',
885: itemtype,

Line 883: wf_core.context('OKC_REP_WF_PVT',

879: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
880: g_module || l_api_name,
881: 'Leaving OKC_REP_WF_PVT.is_approval_complete with exceptions ' || sqlerrm);
882: END IF;
883: wf_core.context('OKC_REP_WF_PVT',
884: 'is_approval_complete',
885: itemtype,
886: itemkey,
887: to_char(actid),

Line 965: 'Entered OKC_REP_WF_PVT.update_ame_status');

961: l_api_name := 'update_ame_status';
962:
963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
965: 'Entered OKC_REP_WF_PVT.update_ame_status');
966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Item Type is: ' || itemtype);
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: 'Item Key is: ' || itemkey);

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

1132: g_module || l_api_name,
1133: 'resultout value is: ' || resultout);
1134: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1135: g_module || l_api_name,
1136: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RESPOND');
1137: END IF;
1138: END IF; -- (funcmode = 'RESPOND')
1139:
1140:

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

1149: END IF;
1150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1151: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1152: g_module || l_api_name,
1153: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=RUN');
1154: END IF;
1155: CLOSE notif_csr;
1156: RETURN;
1157: END IF; -- (funcmode = 'RUN')

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

1158:
1159: IF (funcmode = 'TIMEOUT') THEN
1160: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1161: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1162: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1163: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1164: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1165: END IF;
1166: OKC_REP_UTIL_PVT.add_approval_hist_record(

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

1201:
1202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1204: g_module || l_api_name,
1205: 'Leaving OKC_REP_WF_PVT.update_ame_status from funcmode=TIMEOUT');
1206: END IF;
1207: resultout := 'COMPLETE:';
1208: CLOSE notif_csr;
1209: RETURN;

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

1213: when others then
1214: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1215: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1216: g_module || l_api_name,
1217: '618: Leaving OKC_REP_WF_PVT.update_ame_status with exceptions ' || sqlerrm);
1218: END IF;
1219: --close cursors
1220: IF (notif_csr%ISOPEN) THEN
1221: CLOSE notif_csr ;

Line 1223: wf_core.context('OKC_REP_WF_PVT',

1219: --close cursors
1220: IF (notif_csr%ISOPEN) THEN
1221: CLOSE notif_csr ;
1222: END IF;
1223: wf_core.context('OKC_REP_WF_PVT',
1224: 'update_ame_status',
1225: itemtype,
1226: itemkey,
1227: to_char(actid),

Line 1307: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');

1303: l_api_name := 'update_ame_status';
1304:
1305: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1306: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1307: 'Entered OKC_REP_WF_PVT.update_ame_status_detailed');
1308: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1309: 'Item Type is: ' || itemtype);
1310: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1311: 'Item Key is: ' || itemkey);

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

1603: g_module || l_api_name,
1604: 'resultout value is: ' || resultout);
1605: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1606: g_module || l_api_name,
1607: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RESPOND');
1608: END IF;
1609: END IF; -- (funcmode = 'RESPOND')
1610:
1611:

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

1620: END IF;
1621: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1622: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1623: g_module || l_api_name,
1624: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=RUN');
1625: END IF;
1626: CLOSE notif_csr;
1627: RETURN;
1628: END IF; -- (funcmode = 'RUN')

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

1629:
1630: IF (funcmode = 'TIMEOUT') THEN
1631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1632: fnd_log.string(FND_LOG.LEVEL_PROCEDURE, g_module || l_api_name,
1633: 'In OKC_REP_WF_PVT.update_ame_status funcmode=TIMEOUT');
1634: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,g_module || l_api_name,
1635: 'Calling OKC_REP_UTIL_PVT.add_approval_hist_record');
1636: END IF;
1637: OKC_REP_UTIL_PVT.add_approval_hist_record(

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

1673:
1674: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1675: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
1676: g_module || l_api_name,
1677: 'Leaving OKC_REP_WF_PVT.update_ame_status_detailed from funcmode=TIMEOUT');
1678: END IF;
1679: resultout := 'COMPLETE:';
1680: CLOSE notif_csr;
1681: RETURN;

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

1752: when others then
1753: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1754: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1755: g_module || l_api_name,
1756: '618: Leaving OKC_REP_WF_PVT.update_ame_status_detailed with exceptions ' || sqlerrm);
1757: END IF;
1758: --close cursors
1759: IF (notif_csr%ISOPEN) THEN
1760: CLOSE notif_csr ;

Line 1762: wf_core.context('OKC_REP_WF_PVT',

1758: --close cursors
1759: IF (notif_csr%ISOPEN) THEN
1760: CLOSE notif_csr ;
1761: END IF;
1762: wf_core.context('OKC_REP_WF_PVT',
1763: 'update_ame_status_detailed',
1764: itemtype,
1765: itemkey,
1766: to_char(actid),

Line 1841: 'Entered OKC_REP_WF_PVT.approve_contract');

1837: l_api_name := 'approve_contract';
1838:
1839: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1841: 'Entered OKC_REP_WF_PVT.approve_contract');
1842: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1843: 'Item Type is: ' || itemtype);
1844: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1845: 'Item Key is: ' || itemkey);

Line 2105: 'Leaving OKC_REP_WF_PVT.approve_contract');

2101: resultout := 'COMPLETE:';
2102: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2103: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2104: g_module || l_api_name,
2105: 'Leaving OKC_REP_WF_PVT.approve_contract');
2106: END IF;
2107: RETURN;
2108: END IF; -- (funcmode = 'RUN')
2109:

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

2111: WHEN others THEN
2112: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2113: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2114: g_module || l_api_name,
2115: 'Leaving OKC_REP_WF_PVT.approve_contract with exceptions ' || sqlerrm);
2116: END IF;
2117: wf_core.context('OKC_REP_WF_PVT',
2118: 'approve_contract',
2119: itemtype,

Line 2117: wf_core.context('OKC_REP_WF_PVT',

2113: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2114: g_module || l_api_name,
2115: 'Leaving OKC_REP_WF_PVT.approve_contract with exceptions ' || sqlerrm);
2116: END IF;
2117: wf_core.context('OKC_REP_WF_PVT',
2118: 'approve_contract',
2119: itemtype,
2120: itemkey,
2121: to_char(actid),

Line 2168: 'Entered OKC_REP_WF_PVT.reject_contract');

2164: l_api_name := 'reject_contract';
2165:
2166: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2167: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2168: 'Entered OKC_REP_WF_PVT.reject_contract');
2169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2170: 'Item Type is: ' || itemtype);
2171: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2172: 'Item Key is: ' || itemkey);

Line 2227: 'Leaving OKC_REP_WF_PVT.reject_contract');

2223: resultout := 'COMPLETE:';
2224: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2225: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2226: g_module || l_api_name,
2227: 'Leaving OKC_REP_WF_PVT.reject_contract');
2228: END IF;
2229: RETURN;
2230: END IF; -- (funcmode = 'RUN')
2231: EXCEPTION

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

2232: WHEN others THEN
2233: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2234: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2235: g_module || l_api_name,
2236: 'Leaving OKC_REP_WF_PVT.reject_contract with exceptions ' || sqlerrm);
2237: END IF;
2238: wf_core.context('OKC_REP_WF_PVT',
2239: 'reject_contract',
2240: itemtype,

Line 2238: wf_core.context('OKC_REP_WF_PVT',

2234: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2235: g_module || l_api_name,
2236: 'Leaving OKC_REP_WF_PVT.reject_contract with exceptions ' || sqlerrm);
2237: END IF;
2238: wf_core.context('OKC_REP_WF_PVT',
2239: 'reject_contract',
2240: itemtype,
2241: itemkey,
2242: to_char(actid),

Line 2290: 'Entered OKC_REP_WF_PVT.is_contract_approved');

2286: l_api_name := 'is_contract_approved';
2287:
2288: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2290: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2291: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2292: 'Item Type is: ' || itemtype);
2293: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2294: 'Item Key is: ' || itemkey);

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

2350: END IF;
2351: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2352: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2353: g_module || l_api_name,
2354: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=RUN');
2355: END IF;
2356: RETURN;
2357: END IF; -- (funcmode = 'RUN')
2358:

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

2360: resultout := 'COMPLETE:';
2361: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2362: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2363: g_module || l_api_name,
2364: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=CANCEL');
2365: END IF;
2366: RETURN;
2367: END IF; -- (funcmode = 'CANCEL')
2368:

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

2370: resultout := 'COMPLETE:';
2371: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2372: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2373: g_module || l_api_name,
2374: 'Leaving OKC_REP_WF_PVT.is_contract_approved from funcmode=TIMEOUT');
2375: END IF;
2376: RETURN;
2377: END IF; -- (funcmode = 'TIMEOUT')
2378:

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

2380: WHEN others THEN
2381: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2382: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2383: g_module || l_api_name,
2384: 'Leaving OKC_REP_WF_PVT.is_contract_approved with exceptions ' || sqlerrm);
2385: END IF;
2386: wf_core.context('OKC_REP_WF_PVT',
2387: 'is_contract_approved',
2388: itemtype,

Line 2386: wf_core.context('OKC_REP_WF_PVT',

2382: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2383: g_module || l_api_name,
2384: 'Leaving OKC_REP_WF_PVT.is_contract_approved with exceptions ' || sqlerrm);
2385: END IF;
2386: wf_core.context('OKC_REP_WF_PVT',
2387: 'is_contract_approved',
2388: itemtype,
2389: itemkey,
2390: to_char(actid),

Line 2448: 'Entered OKC_REP_WF_PVT.is_contract_approved');

2444: l_api_name := 'is_contract_approved_detailed';
2445:
2446: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2447: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2448: 'Entered OKC_REP_WF_PVT.is_contract_approved');
2449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2450: 'Item Type is: ' || itemtype);
2451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2452: 'Item Key is: ' || itemkey);

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

2545:
2546: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2547: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2548: g_module || l_api_name,
2549: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=RUN');
2550: END IF;
2551: RETURN;
2552: END IF; -- (funcmode = 'RUN')
2553:

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

2555: resultout := 'COMPLETE:';
2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2557: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2558: g_module || l_api_name,
2559: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=CANCEL');
2560: END IF;
2561: RETURN;
2562: END IF; -- (funcmode = 'CANCEL')
2563:

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

2565: resultout := 'COMPLETE:';
2566: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2567: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2568: g_module || l_api_name,
2569: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed from funcmode=TIMEOUT');
2570: END IF;
2571: RETURN;
2572: END IF; -- (funcmode = 'TIMEOUT')
2573:

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

2575: WHEN others THEN
2576: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2577: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2578: g_module || l_api_name,
2579: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed with exceptions ' || sqlerrm);
2580: END IF;
2581: wf_core.context('OKC_REP_WF_PVT',
2582: 'is_contract_approved_detailed',
2583: itemtype,

Line 2581: wf_core.context('OKC_REP_WF_PVT',

2577: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2578: g_module || l_api_name,
2579: 'Leaving OKC_REP_WF_PVT.is_contract_approved_detailed with exceptions ' || sqlerrm);
2580: END IF;
2581: wf_core.context('OKC_REP_WF_PVT',
2582: 'is_contract_approved_detailed',
2583: itemtype,
2584: itemkey,
2585: to_char(actid),

Line 2634: 'Entered OKC_REP_WF_PVT.complete_notification');

2630: l_api_name := 'complete_notification';
2631:
2632: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2633: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2634: 'Entered OKC_REP_WF_PVT.complete_notification');
2635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2636: 'Item Type is: ' || itemtype);
2637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2638: 'Item Key is: ' || itemkey);

Line 2666: 'Leaving OKC_REP_WF_PVT.complete_notification');

2662: resultout := 'COMPLETE:';
2663: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2664: fnd_log.string(FND_LOG.LEVEL_PROCEDURE,
2665: g_module || l_api_name,
2666: 'Leaving OKC_REP_WF_PVT.complete_notification');
2667: END IF;
2668: RETURN;
2669: END IF; -- (funcmode = 'RUN')
2670: EXCEPTION

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

2671: WHEN others THEN
2672: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2673: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2674: g_module || l_api_name,
2675: 'Leaving OKC_REP_WF_PVT.complete_notification with exceptions ' || sqlerrm);
2676: END IF;
2677: wf_core.context('OKC_REP_WF_PVT',
2678: 'complete_notification',
2679: itemtype,

Line 2677: wf_core.context('OKC_REP_WF_PVT',

2673: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2674: g_module || l_api_name,
2675: 'Leaving OKC_REP_WF_PVT.complete_notification with exceptions ' || sqlerrm);
2676: END IF;
2677: wf_core.context('OKC_REP_WF_PVT',
2678: 'complete_notification',
2679: itemtype,
2680: itemkey,
2681: to_char(actid),

Line 2730: 'Entered OKC_REP_WF_PVT.complete_notification');

2726: l_api_name := 'con_has_terms';
2727:
2728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2730: 'Entered OKC_REP_WF_PVT.complete_notification');
2731: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2732: 'Item Type is: ' || itemtype);
2733: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2734: 'Item Key is: ' || itemkey);

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

2762: WHEN others THEN
2763: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2764: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2765: g_module || l_api_name,
2766: 'Leaving OKC_REP_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
2767: END IF;
2768: wf_core.context('OKC_REP_WF_PVT',
2769: 'con_has_terms',
2770: itemtype,

Line 2768: wf_core.context('OKC_REP_WF_PVT',

2764: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2765: g_module || l_api_name,
2766: 'Leaving OKC_REP_WF_PVT.con_has_terms with exceptions ' || sqlerrm);
2767: END IF;
2768: wf_core.context('OKC_REP_WF_PVT',
2769: 'con_has_terms',
2770: itemtype,
2771: itemkey,
2772: to_char(actid),

Line 2828: 'Entered OKC_REP_WF_PVT.complete_notification');

2824: l_api_name := 'con_attach_generated_yn';
2825:
2826: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2827: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2828: 'Entered OKC_REP_WF_PVT.complete_notification');
2829: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2830: 'Item Type is: ' || itemtype);
2831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2832: 'Item Key is: ' || itemkey);

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

2871: WHEN others THEN
2872: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2873: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2874: g_module || l_api_name,
2875: 'Leaving OKC_REP_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
2876: END IF;
2877: wf_core.context('OKC_REP_WF_PVT',
2878: 'con_attach_generated_yn',
2879: itemtype,

Line 2877: wf_core.context('OKC_REP_WF_PVT',

2873: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2874: g_module || l_api_name,
2875: 'Leaving OKC_REP_WF_PVT.con_attach_generated_yn with exceptions ' || sqlerrm);
2876: END IF;
2877: wf_core.context('OKC_REP_WF_PVT',
2878: 'con_attach_generated_yn',
2879: itemtype,
2880: itemkey,
2881: to_char(actid),

Line 2990: 'Entered OKC_REP_WF_PVT.allow_approver_edit');

2986: l_api_name := 'allow_approver_edit';
2987:
2988: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2989: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2990: 'Entered OKC_REP_WF_PVT.allow_approver_edit');
2991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2992: 'Item Type is: ' || itemtype);
2993: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2994: 'Item Key is: ' || itemkey);

Line 3025: 'Leaving OKC_REP_WF_PVT.allow_approver_edit with exceptions ' || sqlerrm);

3021: WHEN others THEN
3022: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3023: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3024: g_module || l_api_name,
3025: 'Leaving OKC_REP_WF_PVT.allow_approver_edit with exceptions ' || sqlerrm);
3026: END IF;
3027: wf_core.context('OKC_REP_WF_PVT',
3028: 'allow_approver_edit',
3029: itemtype,

Line 3027: wf_core.context('OKC_REP_WF_PVT',

3023: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3024: g_module || l_api_name,
3025: 'Leaving OKC_REP_WF_PVT.allow_approver_edit with exceptions ' || sqlerrm);
3026: END IF;
3027: wf_core.context('OKC_REP_WF_PVT',
3028: 'allow_approver_edit',
3029: itemtype,
3030: itemkey,
3031: to_char(actid),

Line 3074: 'Entered OKC_REP_WF_PVT.contract_preview_yn');

3070: l_api_name := 'contract_preview_yn';
3071:
3072: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3073: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3074: 'Entered OKC_REP_WF_PVT.contract_preview_yn');
3075: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3076: 'Item Type is: ' || itemtype);
3077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3078: 'Item Key is: ' || itemkey);

Line 3112: 'Leaving OKC_REP_WF_PVT.contract_preview_yn with exceptions ' || sqlerrm);

3108: WHEN others THEN
3109: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3110: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3111: g_module || l_api_name,
3112: 'Leaving OKC_REP_WF_PVT.contract_preview_yn with exceptions ' || sqlerrm);
3113: END IF;
3114: wf_core.context('OKC_REP_WF_PVT',
3115: 'contract_preview_yn',
3116: itemtype,

Line 3114: wf_core.context('OKC_REP_WF_PVT',

3110: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3111: g_module || l_api_name,
3112: 'Leaving OKC_REP_WF_PVT.contract_preview_yn with exceptions ' || sqlerrm);
3113: END IF;
3114: wf_core.context('OKC_REP_WF_PVT',
3115: 'contract_preview_yn',
3116: itemtype,
3117: itemkey,
3118: to_char(actid),

Line 3148: 'Entered OKC_REP_WF_PVT.Apps_initialize');

3144: l_api_name := 'Apps_initialize';
3145:
3146: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3148: 'Entered OKC_REP_WF_PVT.Apps_initialize');
3149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3150: 'Item Type is: ' || itemtype);
3151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3152: 'Item Key is: ' || itemkey);

Line 3205: 'Leaving OKC_REP_WF_PVT.Apps_initialize with exceptions ' || sqlerrm);

3201: WHEN others THEN
3202: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3203: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3204: g_module || l_api_name,
3205: 'Leaving OKC_REP_WF_PVT.Apps_initialize with exceptions ' || sqlerrm);
3206: END IF;
3207: wf_core.context('OKC_REP_WF_PVT',
3208: 'Apps_initialize',
3209: itemtype,

Line 3207: wf_core.context('OKC_REP_WF_PVT',

3203: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
3204: g_module || l_api_name,
3205: 'Leaving OKC_REP_WF_PVT.Apps_initialize with exceptions ' || sqlerrm);
3206: END IF;
3207: wf_core.context('OKC_REP_WF_PVT',
3208: 'Apps_initialize',
3209: itemtype,
3210: itemkey,
3211: to_char(actid),

Line 3218: END OKC_REP_WF_PVT;

3214:
3215: END Apps_initialize;
3216:
3217:
3218: END OKC_REP_WF_PVT;