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.OKS_WF_K_APPROVE dependencies on FND_LOG

Line 92: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

88: l_dummy VARCHAR2(100);
89:
90: BEGIN
91:
92: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
93: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
94: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
95: END IF;
96: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 93: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

89:
90: BEGIN
91:
92: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
93: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
94: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
95: END IF;
96: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
97: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 96: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

92: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
93: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
94: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
95: END IF;
96: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
97: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
98: 'itemtype: ' || itemtype ||
99: ' itemkey: ' || itemkey);
100: END IF;

Line 97: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

93: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
94: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
95: END IF;
96: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
97: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
98: 'itemtype: ' || itemtype ||
99: ' itemkey: ' || itemkey);
100: END IF;
101: l_chr_id := wf_engine.GetItemAttrNumber(

Line 108: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

104: aname => 'CONTRACT_ID');
105:
106: -- Get Salesrep user name to whom the error notification
107: -- about valid approver not found should be sent to
108: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
109: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
110: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(p_chr_id= '||l_chr_id||')');
111: END IF;
112: OKS_RENEW_CONTRACT_PVT.GET_USER_NAME

Line 109: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',

105:
106: -- Get Salesrep user name to whom the error notification
107: -- about valid approver not found should be sent to
108: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
109: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
110: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(p_chr_id= '||l_chr_id||')');
111: END IF;
112: OKS_RENEW_CONTRACT_PVT.GET_USER_NAME
113: (

Line 124: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

120: p_hdesk_user_id => NULL,
121: x_user_id => l_salesrep_id,
122: x_user_name => l_salesrep_name
123: );
124: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
125: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
126: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(x_return_status= '||
127: x_return_status||' x_msg_count ='||x_msg_count||')');
128: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

Line 125: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

121: x_user_id => l_salesrep_id,
122: x_user_name => l_salesrep_name
123: );
124: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
125: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
126: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(x_return_status= '||
127: x_return_status||' x_msg_count ='||x_msg_count||')');
128: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
129: ' x_user_id ='||l_salesrep_id||

Line 128: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',

124: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
125: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
126: 'OKS_RENEW_CONTRACT_PVT.GET_USER_NAME(x_return_status= '||
127: x_return_status||' x_msg_count ='||x_msg_count||')');
128: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
129: ' x_user_id ='||l_salesrep_id||
130: ' x_user_name ='||l_salesrep_name);
131: END IF;
132: -- Check if SALESREP_HD_NAME item attribute exists, if not create one

Line 258: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

254: IF (l_debug = 'Y') THEN
255: okc_debug.log('OKSWCAPB: Select_Next() -- Start of Select_Next()', 2);
256: END IF;
257:
258: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
260: 'Entered '||G_PKG_NAME ||'.'||l_api_name||
261: ' Item Key '||itemkey||
262: ' Role Type '||p_role_type||' Current '||p_current);

Line 259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

255: okc_debug.log('OKSWCAPB: Select_Next() -- Start of Select_Next()', 2);
256: END IF;
257:
258: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
260: 'Entered '||G_PKG_NAME ||'.'||l_api_name||
261: ' Item Key '||itemkey||
262: ' Role Type '||p_role_type||' Current '||p_current);
263: END IF;

Line 314: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

310: itemIdsOut => l_item_ids,
311: itemSourcesOut => l_item_sources);
312: EXCEPTION
313: WHEN OTHERS THEN
314: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
315: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
316: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
317: ||SQLCODE||', sqlerrm = '||SQLERRM);
318: END IF;

Line 315: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,

311: itemSourcesOut => l_item_sources);
312: EXCEPTION
313: WHEN OTHERS THEN
314: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
315: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
316: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.Others sqlcode = '
317: ||SQLCODE||', sqlerrm = '||SQLERRM);
318: END IF;
319: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 364: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

360: fetch Next_Informed_csr into x_role, x_name;
361: close Next_Informed_csr;
362: end if;
363:
364: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
366: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||
367: ' x_role:'||x_role||' x_name:'||x_name);
368: END IF;

Line 365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,

361: close Next_Informed_csr;
362: end if;
363:
364: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
365: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,G_MODULE||l_api_name,
366: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||
367: ' x_role:'||x_role||' x_name:'||x_name);
368: END IF;
369: IF (l_debug = 'Y') THEN

Line 374: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

370: okc_debug.log('OKSWCAPB: Select_Next() -- End of Select_Next()', 2);
371: END IF;
372: EXCEPTION
373: WHEN NoValidApproverException THEN
374: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
375: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
376: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.NoValidApproverException '||
377: ' A valid approver is not found for this contract');
378: END IF;

Line 375: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,

371: END IF;
372: EXCEPTION
373: WHEN NoValidApproverException THEN
374: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
375: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
376: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.NoValidApproverException '||
377: ' A valid approver is not found for this contract');
378: END IF;
379: RAISE NoValidApproverException;

Line 381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

377: ' A valid approver is not found for this contract');
378: END IF;
379: RAISE NoValidApproverException;
380: WHEN OTHERS THEN
381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
382: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
383: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
384: ||SQLCODE||', sqlerrm = '||SQLERRM);
385: END IF;

Line 382: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,

378: END IF;
379: RAISE NoValidApproverException;
380: WHEN OTHERS THEN
381: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
382: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
383: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||' from OTHERS sqlcode = '
384: ||SQLCODE||', sqlerrm = '||SQLERRM);
385: END IF;
386: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 1155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1151: IF (l_debug = 'Y') THEN
1152: okc_debug.log('OKSWCAPB: Select_Approver() -- Start of Select_Approver()', 2);
1153: END IF;
1154:
1155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
1157: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1158: END IF;
1159: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 1156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,

1152: okc_debug.log('OKSWCAPB: Select_Approver() -- Start of Select_Approver()', 2);
1153: END IF;
1154:
1155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
1157: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1158: END IF;
1159: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1160: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1159: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1155: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
1157: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1158: END IF;
1159: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1160: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1161: 'itemtype: ' || itemtype ||
1162: ' itemkey: ' || itemkey ||
1163: ' actid: ' || to_char(actid) ||

Line 1160: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1156: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
1157: 'Entered '||G_PKG_NAME ||'.'||l_api_name);
1158: END IF;
1159: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1160: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1161: 'itemtype: ' || itemtype ||
1162: ' itemkey: ' || itemkey ||
1163: ' actid: ' || to_char(actid) ||
1164: ' funcmode: ' || funcmode);