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_K_ACTIONS_PVT dependencies on FND_LOG

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: ------------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_K_ACTIONS_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
9:
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'oks.plsql.'||g_pkg_name||'.';
12: G_APPLICATION_ID CONSTANT NUMBER :=515; -- OKS Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

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

46: /* Added for Bug# 7717268*/
47: l_sql_err VARCHAR2(2000);
48: BEGIN
49: -- start debug log
50: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
51: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
52: G_MODULE||l_api_name,
53: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
54: END IF;

Line 51: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

47: l_sql_err VARCHAR2(2000);
48: BEGIN
49: -- start debug log
50: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
51: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
52: G_MODULE||l_api_name,
53: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
54: END IF;
55: -- Standard call to check for call compatibility.

Line 93: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

89: l_sql_err := SQLERRM;
90: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
91: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
92:
93: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
94: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
95: '1111:Reminder Suppress Flag Update Failed - l_sql_err:'||l_sql_err);
96: END IF;
97:

Line 94: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,

90: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
91: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
92:
93: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
94: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
95: '1111:Reminder Suppress Flag Update Failed - l_sql_err:'||l_sql_err);
96: END IF;
97:
98: x_msg_data := fnd_message.get;

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

100: x_msg_count := 1;
101:
102: END IF;
103: ELSE
104: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
106: G_MODULE||l_api_name,
107: '1000: Not a valid action for this contract'||G_PKG_NAME ||'.'||l_api_name);
108: END IF;

Line 105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

101:
102: END IF;
103: ELSE
104: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
106: G_MODULE||l_api_name,
107: '1000: Not a valid action for this contract'||G_PKG_NAME ||'.'||l_api_name);
108: END IF;
109: x_return_status := G_RET_STS_ACTION_NOT_ALWD;

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

114: -- Standard call to get message count and if count is 1, get message info.
115: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
116:
117: -- end debug log
118: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
120: G_MODULE||l_api_name,
121: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
122: END IF;

Line 119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

115: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
116:
117: -- end debug log
118: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
119: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
120: G_MODULE||l_api_name,
121: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
122: END IF;
123:

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

123:
124: EXCEPTION
125: WHEN ActionNotAllowedException THEN
126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
127: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
128: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
129: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
130: ' Contract cannot be published since it is not in entered status');
131: END IF;

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

124: EXCEPTION
125: WHEN ActionNotAllowedException THEN
126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
127: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
128: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
129: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
130: ' Contract cannot be published since it is not in entered status');
131: END IF;
132: x_return_status := G_RET_STS_ACTION_NOT_ALWD;

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

130: ' Contract cannot be published since it is not in entered status');
131: END IF;
132: x_return_status := G_RET_STS_ACTION_NOT_ALWD;
133: WHEN FND_API.G_EXC_ERROR THEN
134: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
136: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with ERROR status');
137: END IF;
138:

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

131: END IF;
132: x_return_status := G_RET_STS_ACTION_NOT_ALWD;
133: WHEN FND_API.G_EXC_ERROR THEN
134: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
135: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
136: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with ERROR status');
137: END IF;
138:
139: x_return_status := G_RET_STS_ERROR ;

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

139: x_return_status := G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
145: G_MODULE||l_api_name,
146: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with Unexpected Error status');
147: END IF;

Line 144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

140: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
141:
142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
144: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
145: G_MODULE||l_api_name,
146: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with Unexpected Error status');
147: END IF;
148:

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

149: x_return_status := G_RET_STS_UNEXP_ERROR ;
150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
151:
152: WHEN OTHERS THEN
153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
155: G_MODULE||l_api_name,
156: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name ||' with unexpected error');
157: END IF;

Line 154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

150: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
151:
152: WHEN OTHERS THEN
153: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
155: G_MODULE||l_api_name,
156: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name ||' with unexpected error');
157: END IF;
158: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

283: commit work;
284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
288: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
289: G_MODULE||l_api_name,
290: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
291: END IF;

Line 288: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
288: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
289: G_MODULE||l_api_name,
290: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
291: END IF;
292:

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

293: x_return_status := G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
299: G_MODULE||l_api_name,
300: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
301: END IF;

Line 298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

294: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
299: G_MODULE||l_api_name,
300: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
301: END IF;
302:

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

303: x_return_status := G_RET_STS_UNEXP_ERROR ;
304: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
305:
306: WHEN OTHERS THEN
307: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
309: G_MODULE||l_api_name,
310: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
311: END IF;

Line 308: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

304: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
305:
306: WHEN OTHERS THEN
307: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
308: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
309: G_MODULE||l_api_name,
310: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
311: END IF;
312: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 401: -- write to fnd_log file

397:
398: l_count := l_msg_tbl.first;
399: LOOP
400: IF l_msg_tbl(l_count).error_status='E' THEN
401: -- write to fnd_log file
402: fnd_file.put_line(FND_FILE.LOG,l_msg_ctr||' : '||l_msg_tbl(l_count).data);
403:
404: -- reset the out parameter to Error
405: x_return_status := 'E';

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

419: fnd_file.put_line(FND_FILE.LOG,' ');
420:
421: EXCEPTION
422: WHEN FND_API.G_EXC_ERROR THEN
423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
425: G_MODULE||l_api_name,
426: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
427: END IF;

Line 424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

420:
421: EXCEPTION
422: WHEN FND_API.G_EXC_ERROR THEN
423: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
425: G_MODULE||l_api_name,
426: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
427: END IF;
428:

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

429: x_return_status := G_RET_STS_ERROR ;
430: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
431:
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
435: G_MODULE||l_api_name,
436: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
437: END IF;

Line 434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

430: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
431:
432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
433: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
434: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
435: G_MODULE||l_api_name,
436: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
437: END IF;
438:

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

439: x_return_status := G_RET_STS_UNEXP_ERROR ;
440: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
441:
442: WHEN OTHERS THEN
443: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
445: G_MODULE||l_api_name,
446: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
447: END IF;

Line 444: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

440: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
441:
442: WHEN OTHERS THEN
443: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
444: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
445: G_MODULE||l_api_name,
446: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
447: END IF;
448: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

486: l_request_id NUMBER := 0;
487:
488: BEGIN
489: -- start debug log
490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
492: G_MODULE||l_api_name,
493: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

487:
488: BEGIN
489: -- start debug log
490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
492: G_MODULE||l_api_name,
493: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
495: G_MODULE||l_api_name,

Line 494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
492: G_MODULE||l_api_name,
493: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
495: G_MODULE||l_api_name,
496: '100: Parameters ');
497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
498: G_MODULE||l_api_name,

Line 497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

493: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
495: G_MODULE||l_api_name,
496: '100: Parameters ');
497: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
498: G_MODULE||l_api_name,
499: '100: p_contract_list : '||p_contract_list);
500: END IF;
501:

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

518: tmp_contract_list := p_contract_list;
519: x_cp_request_id := 0;
520:
521: -- debug log
522: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
523: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
524: G_MODULE||l_api_name,
525: '110: Converting K list to pl/sql');
526: END IF;

Line 523: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

519: x_cp_request_id := 0;
520:
521: -- debug log
522: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
523: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
524: G_MODULE||l_api_name,
525: '110: Converting K list to pl/sql');
526: END IF;
527:

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

529: LOOP
530: i := INSTR(tmp_contract_list,',');
531:
532: -- debug log
533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
535: G_MODULE||l_api_name,
536: '120: i : '||i);
537: END IF;

Line 534: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

530: i := INSTR(tmp_contract_list,',');
531:
532: -- debug log
533: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
534: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
535: G_MODULE||l_api_name,
536: '120: i : '||i);
537: END IF;
538:

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

541:
542: l_chr_id_tbl(j) := SUBSTR(tmp_contract_list,1,i-1);
543:
544: -- debug log
545: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
546: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
547: G_MODULE||l_api_name,
548: '130: j :'||j);
549: END IF;

Line 546: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

542: l_chr_id_tbl(j) := SUBSTR(tmp_contract_list,1,i-1);
543:
544: -- debug log
545: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
546: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
547: G_MODULE||l_api_name,
548: '130: j :'||j);
549: END IF;
550:

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

550:
551: tmp_contract_list := SUBSTR(tmp_contract_list,i+1, length(tmp_contract_list) - i);
552:
553: -- debug log
554: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
556: G_MODULE||l_api_name,
557: '130: tmp_contract_list : '||tmp_contract_list);
558: END IF;

Line 555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

551: tmp_contract_list := SUBSTR(tmp_contract_list,i+1, length(tmp_contract_list) - i);
552:
553: -- debug log
554: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
555: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
556: G_MODULE||l_api_name,
557: '130: tmp_contract_list : '||tmp_contract_list);
558: END IF;
559:

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

566:
567: END LOOP;
568:
569: -- debug log
570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
572: G_MODULE||l_api_name,
573: '200: After Converting K list to pl/sql');
574: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

567: END LOOP;
568:
569: -- debug log
570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
572: G_MODULE||l_api_name,
573: '200: After Converting K list to pl/sql');
574: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
575: G_MODULE||l_api_name,

Line 574: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

570: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
572: G_MODULE||l_api_name,
573: '200: After Converting K list to pl/sql');
574: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
575: G_MODULE||l_api_name,
576: '200: Count of Ks is : '||l_chr_id_tbl.COUNT);
577: END IF;
578:

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

595: ARGUMENT1 => p_contract_list
596: );
597:
598: -- debug log
599: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
601: G_MODULE||l_api_name,
602: '300: Request Id of pgm : '||l_request_id);
603: END IF;

Line 600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

596: );
597:
598: -- debug log
599: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
600: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
601: G_MODULE||l_api_name,
602: '300: Request Id of pgm : '||l_request_id);
603: END IF;
604:

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

622: -- Standard call to get message count and if count is 1, get message info.
623: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
624:
625: -- end debug log
626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
627: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
628: G_MODULE||l_api_name,
629: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
630: END IF;

Line 627: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

623: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
624:
625: -- end debug log
626: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
627: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
628: G_MODULE||l_api_name,
629: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
630: END IF;
631:

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

630: END IF;
631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
636: G_MODULE||l_api_name,
637: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
638: END IF;

Line 635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
636: G_MODULE||l_api_name,
637: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
638: END IF;
639:

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

640: x_return_status := G_RET_STS_ERROR ;
641: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
642:
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
646: G_MODULE||l_api_name,
647: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
648: END IF;

Line 645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

641: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
642:
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
645: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
646: G_MODULE||l_api_name,
647: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
648: END IF;
649:

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

650: x_return_status := G_RET_STS_UNEXP_ERROR ;
651: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
652:
653: WHEN OTHERS THEN
654: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
655: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
656: G_MODULE||l_api_name,
657: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
658: END IF;

Line 655: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

651: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
652:
653: WHEN OTHERS THEN
654: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
655: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
656: G_MODULE||l_api_name,
657: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
658: END IF;
659: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

705:
706: BEGIN
707:
708: -- start debug log
709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
711: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
712: END IF;
713:

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

706: BEGIN
707:
708: -- start debug log
709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
711: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
712: END IF;
713:
714: -- we don't want to restrict enabling / disabling reminders when contract is in

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

733: CLOSE chr_cur;
734: END IF;
735:
736: -- end debug log
737: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
739: G_MODULE||l_api_name,
740: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name || ' with return value: '||l_return_val);
741: END IF;

Line 738: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

734: END IF;
735:
736: -- end debug log
737: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
739: G_MODULE||l_api_name,
740: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name || ' with return value: '||l_return_val);
741: END IF;
742: return(l_return_val);

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

742: return(l_return_val);
743:
744: EXCEPTION
745: WHEN others THEN
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
748: '2000: Leaving with error '||G_PKG_NAME ||'.'||l_api_name);
749: END IF;
750: l_return_val := 'N';

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

743:
744: EXCEPTION
745: WHEN others THEN
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
748: '2000: Leaving with error '||G_PKG_NAME ||'.'||l_api_name);
749: END IF;
750: l_return_val := 'N';
751: return(l_return_val);

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

788: mo_global.init('OKC');
789:
790:
791: -- start debug log
792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
794: G_MODULE||l_api_name,
795: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

789:
790:
791: -- start debug log
792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
794: G_MODULE||l_api_name,
795: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
797: G_MODULE||l_api_name,

Line 796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

792: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
793: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
794: G_MODULE||l_api_name,
795: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
797: G_MODULE||l_api_name,
798: '100: Parameters ');
799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
800: G_MODULE||l_api_name,

Line 799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

795: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
796: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
797: G_MODULE||l_api_name,
798: '100: Parameters ');
799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
800: G_MODULE||l_api_name,
801: '102: p_from_address : '||p_from_address);
802: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
803: G_MODULE||l_api_name,

Line 802: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

798: '100: Parameters ');
799: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
800: G_MODULE||l_api_name,
801: '102: p_from_address : '||p_from_address);
802: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
803: G_MODULE||l_api_name,
804: '103: p_to_address : '||p_to_address);
805: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
806: G_MODULE||l_api_name,

Line 805: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

801: '102: p_from_address : '||p_from_address);
802: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
803: G_MODULE||l_api_name,
804: '103: p_to_address : '||p_to_address);
805: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
806: G_MODULE||l_api_name,
807: '104: p_cc_address : '||p_cc_address);
808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
809: G_MODULE||l_api_name,

Line 808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

804: '103: p_to_address : '||p_to_address);
805: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
806: G_MODULE||l_api_name,
807: '104: p_cc_address : '||p_cc_address);
808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
809: G_MODULE||l_api_name,
810: '106: p_reply_to_address : '||p_reply_to_address);
811: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
812: G_MODULE||l_api_name,

Line 811: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

807: '104: p_cc_address : '||p_cc_address);
808: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
809: G_MODULE||l_api_name,
810: '106: p_reply_to_address : '||p_reply_to_address);
811: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
812: G_MODULE||l_api_name,
813: '107: p_message_template_id : '||p_message_template_id);
814: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
815: G_MODULE||l_api_name,

Line 814: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

810: '106: p_reply_to_address : '||p_reply_to_address);
811: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
812: G_MODULE||l_api_name,
813: '107: p_message_template_id : '||p_message_template_id);
814: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
815: G_MODULE||l_api_name,
816: '108: p_attachment_template_id : '||p_attachment_template_id);
817: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
818: G_MODULE||l_api_name,

Line 817: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

813: '107: p_message_template_id : '||p_message_template_id);
814: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
815: G_MODULE||l_api_name,
816: '108: p_attachment_template_id : '||p_attachment_template_id);
817: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
818: G_MODULE||l_api_name,
819: '109: p_email_subject : '||p_email_subject);
820: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
821: G_MODULE||l_api_name,

Line 820: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

816: '108: p_attachment_template_id : '||p_attachment_template_id);
817: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
818: G_MODULE||l_api_name,
819: '109: p_email_subject : '||p_email_subject);
820: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
821: G_MODULE||l_api_name,
822: '111: p_email_contract_status : '||p_email_contract_status);
823: END IF;
824:

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

865:
866:
867: EXCEPTION
868: WHEN OTHERS THEN
869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
871: G_MODULE||l_api_name,
872: '4657: Leaving '||G_PKG_NAME ||'.'||l_api_name||'.'||SQLERRM);
873: END IF;

Line 870: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

866:
867: EXCEPTION
868: WHEN OTHERS THEN
869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
870: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
871: G_MODULE||l_api_name,
872: '4657: Leaving '||G_PKG_NAME ||'.'||l_api_name||'.'||SQLERRM);
873: END IF;
874:

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

873: END IF;
874:
875: END;
876:
877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
879: G_MODULE||l_api_name,
880: '200: After inserting into table:');
881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

874:
875: END;
876:
877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
879: G_MODULE||l_api_name,
880: '200: After inserting into table:');
881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
882: G_MODULE||l_api_name,

Line 881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
879: G_MODULE||l_api_name,
880: '200: After inserting into table:');
881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
882: G_MODULE||l_api_name,
883: '201: email id generated from store_email_dtls : '||l_email_id);
884: END IF;
885:

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

888: commit work;
889:
890:
891: -- end debug log
892: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
893: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
894: G_MODULE||l_api_name,
895: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
896: END IF;

Line 893: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

889:
890:
891: -- end debug log
892: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
893: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
894: G_MODULE||l_api_name,
895: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
896: END IF;
897:

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

896: END IF;
897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
902: G_MODULE||l_api_name,
903: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
904: END IF;

Line 901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

897:
898: EXCEPTION
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
901: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
902: G_MODULE||l_api_name,
903: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
904: END IF;
905:

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

905:
906: x_return_status := G_RET_STS_ERROR ;
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
910: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
911: G_MODULE||l_api_name,
912: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
913: END IF;

Line 910: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

906: x_return_status := G_RET_STS_ERROR ;
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
910: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
911: G_MODULE||l_api_name,
912: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
913: END IF;
914:

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

914:
915: x_return_status := G_RET_STS_UNEXP_ERROR ;
916:
917: WHEN OTHERS THEN
918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
920: G_MODULE||l_api_name,
921: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name||'.'||SQLERRM);
922: END IF;

Line 919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

915: x_return_status := G_RET_STS_UNEXP_ERROR ;
916:
917: WHEN OTHERS THEN
918: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
920: G_MODULE||l_api_name,
921: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name||'.'||SQLERRM);
922: END IF;
923:

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

940: l_api_name CONSTANT VARCHAR2(30) := 'GET_EMAIL_DTLS';
941:
942: BEGIN
943: -- start debug log
944: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
945: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
946: G_MODULE||l_api_name,
947: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 945: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

941:
942: BEGIN
943: -- start debug log
944: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
945: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
946: G_MODULE||l_api_name,
947: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
949: G_MODULE||l_api_name,

Line 948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

944: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
945: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
946: G_MODULE||l_api_name,
947: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
949: G_MODULE||l_api_name,
950: '300: Parameters ');
951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
952: G_MODULE||l_api_name,

Line 951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

947: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
948: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
949: G_MODULE||l_api_name,
950: '300: Parameters ');
951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
952: G_MODULE||l_api_name,
953: '301: p_email_id : '||p_email_id);
954: END IF;
955:

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

965: FROM OKS_EMAIL_DETAILS
966: WHERE email_id = p_email_id;
967:
968: -- end debug log
969: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
971: G_MODULE||l_api_name,
972: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
973: END IF;

Line 970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

966: WHERE email_id = p_email_id;
967:
968: -- end debug log
969: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
970: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
971: G_MODULE||l_api_name,
972: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
973: END IF;
974:

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

973: END IF;
974:
975: EXCEPTION
976: WHEN FND_API.G_EXC_ERROR THEN
977: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
979: G_MODULE||l_api_name,
980: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
981: END IF;

Line 978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

974:
975: EXCEPTION
976: WHEN FND_API.G_EXC_ERROR THEN
977: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
979: G_MODULE||l_api_name,
980: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
981: END IF;
982:

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

982:
983: x_return_status := G_RET_STS_ERROR ;
984:
985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
986: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
988: G_MODULE||l_api_name,
989: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
990: END IF;

Line 987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

983: x_return_status := G_RET_STS_ERROR ;
984:
985: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
986: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
987: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
988: G_MODULE||l_api_name,
989: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
990: END IF;
991:

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

991:
992: x_return_status := G_RET_STS_UNEXP_ERROR ;
993:
994: WHEN OTHERS THEN
995: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
996: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
997: G_MODULE||l_api_name,
998: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
999: END IF;

Line 996: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

992: x_return_status := G_RET_STS_UNEXP_ERROR ;
993:
994: WHEN OTHERS THEN
995: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
996: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
997: G_MODULE||l_api_name,
998: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
999: END IF;
1000:

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

1017:
1018: BEGIN
1019:
1020: -- start debug log
1021: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1023: G_MODULE||l_api_name,
1024: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1025: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1018: BEGIN
1019:
1020: -- start debug log
1021: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1023: G_MODULE||l_api_name,
1024: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1025: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1026: G_MODULE||l_api_name,

Line 1025: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1021: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1022: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1023: G_MODULE||l_api_name,
1024: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1025: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1026: G_MODULE||l_api_name,
1027: '400: Parameters ');
1028: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1029: G_MODULE||l_api_name,

Line 1028: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1024: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1025: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1026: G_MODULE||l_api_name,
1027: '400: Parameters ');
1028: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1029: G_MODULE||l_api_name,
1030: '401: p_email_id : '||p_email_id);
1031: END IF;
1032:

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

1039: DELETE FROM OKS_EMAIL_DETAILS WHERE email_id = p_email_id;
1040:
1041: IF SQL%ROWCOUNT = 0 THEN
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: '402: Rows are deleted successfully from OKS_EMAIL_DETAILS table');
1047: END IF;

Line 1044: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1040:
1041: IF SQL%ROWCOUNT = 0 THEN
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: '402: Rows are deleted successfully from OKS_EMAIL_DETAILS table');
1047: END IF;
1048:

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

1048:
1049: END IF;
1050:
1051: -- end debug log
1052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1053: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1054: G_MODULE||l_api_name,
1055: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1056: END IF;

Line 1053: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1049: END IF;
1050:
1051: -- end debug log
1052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1053: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1054: G_MODULE||l_api_name,
1055: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1056: END IF;
1057:

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

1056: END IF;
1057:
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1062: G_MODULE||l_api_name,
1063: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1064: END IF;

Line 1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1057:
1058: EXCEPTION
1059: WHEN FND_API.G_EXC_ERROR THEN
1060: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1062: G_MODULE||l_api_name,
1063: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1064: END IF;
1065:

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

1065:
1066: x_return_status := G_RET_STS_ERROR ;
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1071: G_MODULE||l_api_name,
1072: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1073: END IF;

Line 1070: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1066: x_return_status := G_RET_STS_ERROR ;
1067:
1068: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1069: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1070: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1071: G_MODULE||l_api_name,
1072: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1073: END IF;
1074:

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

1074:
1075: x_return_status := G_RET_STS_UNEXP_ERROR ;
1076:
1077: WHEN OTHERS THEN
1078: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1079: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1080: G_MODULE||l_api_name,
1081: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1082: END IF;

Line 1079: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1075: x_return_status := G_RET_STS_UNEXP_ERROR ;
1076:
1077: WHEN OTHERS THEN
1078: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1079: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1080: G_MODULE||l_api_name,
1081: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1082: END IF;
1083:

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

1209: commit work;
1210:
1211: EXCEPTION
1212: WHEN FND_API.G_EXC_ERROR THEN
1213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1215: G_MODULE||l_api_name,
1216: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1217: END IF;

Line 1214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1210:
1211: EXCEPTION
1212: WHEN FND_API.G_EXC_ERROR THEN
1213: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1215: G_MODULE||l_api_name,
1216: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1217: END IF;
1218:

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

1219: x_return_status := G_RET_STS_ERROR ;
1220: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1225: G_MODULE||l_api_name,
1226: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1227: END IF;

Line 1224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1220: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1221:
1222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1223: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1224: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1225: G_MODULE||l_api_name,
1226: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1227: END IF;
1228:

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

1229: x_return_status := G_RET_STS_UNEXP_ERROR ;
1230: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1231:
1232: WHEN OTHERS THEN
1233: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1235: G_MODULE||l_api_name,
1236: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1237: END IF;

Line 1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1230: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1231:
1232: WHEN OTHERS THEN
1233: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1234: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1235: G_MODULE||l_api_name,
1236: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1237: END IF;
1238: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1289: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1290:
1291: BEGIN
1292: -- start debug log
1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1294: THEN
1295: fnd_log.STRING (fnd_log.level_statement,
1296: g_module ||
1297: l_api_name,

Line 1295: fnd_log.STRING (fnd_log.level_statement,

1291: BEGIN
1292: -- start debug log
1293: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1294: THEN
1295: fnd_log.STRING (fnd_log.level_statement,
1296: g_module ||
1297: l_api_name,
1298: '100: Entered ' ||
1299: g_pkg_name ||

Line 1314: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1310:
1311: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
1312:
1313: -- Printing input paramter values
1314: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1315: THEN
1316: fnd_log.STRING (fnd_log.level_statement,
1317: g_module ||
1318: l_api_name,

Line 1316: fnd_log.STRING (fnd_log.level_statement,

1312:
1313: -- Printing input paramter values
1314: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1315: THEN
1316: fnd_log.STRING (fnd_log.level_statement,
1317: g_module ||
1318: l_api_name,
1319: '101:p_chr_id = ' ||p_chr_id
1320: );

Line 1321: fnd_log.STRING (fnd_log.level_statement,

1317: g_module ||
1318: l_api_name,
1319: '101:p_chr_id = ' ||p_chr_id
1320: );
1321: fnd_log.STRING (fnd_log.level_statement,
1322: g_module ||
1323: l_api_name,
1324: '102:p_status_code = ' ||p_status_code
1325: );

Line 1326: fnd_log.STRING (fnd_log.level_statement,

1322: g_module ||
1323: l_api_name,
1324: '102:p_status_code = ' ||p_status_code
1325: );
1326: fnd_log.STRING (fnd_log.level_statement,
1327: g_module ||
1328: l_api_name,
1329: '103:p_reason_code = ' ||p_reason_code
1330: );

Line 1331: fnd_log.STRING (fnd_log.level_statement,

1327: g_module ||
1328: l_api_name,
1329: '103:p_reason_code = ' ||p_reason_code
1330: );
1331: fnd_log.STRING (fnd_log.level_statement,
1332: g_module ||
1333: l_api_name,
1334: '104:p_comments = ' ||p_comments
1335: );

Line 1336: fnd_log.STRING (fnd_log.level_statement,

1332: g_module ||
1333: l_api_name,
1334: '104:p_comments = ' ||p_comments
1335: );
1336: fnd_log.STRING (fnd_log.level_statement,
1337: g_module ||
1338: l_api_name,
1339: '105:p_due_date = ' ||p_due_date
1340: );

Line 1341: fnd_log.STRING (fnd_log.level_statement,

1337: g_module ||
1338: l_api_name,
1339: '105:p_due_date = ' ||p_due_date
1340: );
1341: fnd_log.STRING (fnd_log.level_statement,
1342: g_module ||
1343: l_api_name,
1344: '106:p_action = ' ||p_action
1345: );

Line 1346: fnd_log.STRING (fnd_log.level_statement,

1342: g_module ||
1343: l_api_name,
1344: '106:p_action = ' ||p_action
1345: );
1346: fnd_log.STRING (fnd_log.level_statement,
1347: g_module ||
1348: l_api_name,
1349: '107:p_est_percent = ' ||p_est_percent
1350: );

Line 1351: fnd_log.STRING (fnd_log.level_statement,

1347: g_module ||
1348: l_api_name,
1349: '107:p_est_percent = ' ||p_est_percent
1350: );
1351: fnd_log.STRING (fnd_log.level_statement,
1352: g_module ||
1353: l_api_name,
1354: '108:p_est_date = ' ||p_est_date
1355: );

Line 1356: fnd_log.STRING (fnd_log.level_statement,

1352: g_module ||
1353: l_api_name,
1354: '108:p_est_date = ' ||p_est_date
1355: );
1356: fnd_log.STRING (fnd_log.level_statement,
1357: g_module ||
1358: l_api_name,
1359: '109:p_contract_notes = ' ||p_contract_notes
1360: );

Line 1370: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1366: close csr_k_old_status;
1367:
1368: x_succ_err_contract:= l_contract_number;
1369:
1370: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1371: THEN
1372: fnd_log.STRING (fnd_log.level_statement,
1373: g_module ||
1374: l_api_name,

Line 1372: fnd_log.STRING (fnd_log.level_statement,

1368: x_succ_err_contract:= l_contract_number;
1369:
1370: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1371: THEN
1372: fnd_log.STRING (fnd_log.level_statement,
1373: g_module ||
1374: l_api_name,
1375: '210:l_old_status_code = ' ||l_old_status_code
1376: );

Line 1377: fnd_log.STRING (fnd_log.level_statement,

1373: g_module ||
1374: l_api_name,
1375: '210:l_old_status_code = ' ||l_old_status_code
1376: );
1377: fnd_log.STRING (fnd_log.level_statement,
1378: g_module ||
1379: l_api_name,
1380: '210a:l_contract_number = ' ||l_contract_number
1381: );

Line 1393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1389: l_old_est_rev_percent,
1390: l_old_est_rev_date;
1391: CLOSE csr_k_old_forecast;
1392:
1393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1394: THEN
1395: fnd_log.STRING (fnd_log.level_statement,
1396: g_module ||
1397: l_api_name,

Line 1395: fnd_log.STRING (fnd_log.level_statement,

1391: CLOSE csr_k_old_forecast;
1392:
1393: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1394: THEN
1395: fnd_log.STRING (fnd_log.level_statement,
1396: g_module ||
1397: l_api_name,
1398: '211:l_old_follow_up_date = ' ||l_old_follow_up_date
1399: );

Line 1400: fnd_log.STRING (fnd_log.level_statement,

1396: g_module ||
1397: l_api_name,
1398: '211:l_old_follow_up_date = ' ||l_old_follow_up_date
1399: );
1400: fnd_log.STRING (fnd_log.level_statement,
1401: g_module ||
1402: l_api_name,
1403: '211:l_old_follow_up_action = ' ||l_old_follow_up_action
1404: );

Line 1405: fnd_log.STRING (fnd_log.level_statement,

1401: g_module ||
1402: l_api_name,
1403: '211:l_old_follow_up_action = ' ||l_old_follow_up_action
1404: );
1405: fnd_log.STRING (fnd_log.level_statement,
1406: g_module ||
1407: l_api_name,
1408: '211:l_old_est_rev_percent = ' ||l_old_est_rev_percent
1409: );

Line 1410: fnd_log.STRING (fnd_log.level_statement,

1406: g_module ||
1407: l_api_name,
1408: '211:l_old_est_rev_percent = ' ||l_old_est_rev_percent
1409: );
1410: fnd_log.STRING (fnd_log.level_statement,
1411: g_module ||
1412: l_api_name,
1413: '211:l_old_est_rev_date = ' ||l_old_est_rev_date
1414: );

Line 1420: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1416:
1417:
1418:
1419: IF (p_status_code IS NOT NULL) THEN
1420: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1421: THEN
1422: fnd_log.STRING (fnd_log.level_statement,
1423: g_module ||
1424: l_api_name,

Line 1422: fnd_log.STRING (fnd_log.level_statement,

1418:
1419: IF (p_status_code IS NOT NULL) THEN
1420: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1421: THEN
1422: fnd_log.STRING (fnd_log.level_statement,
1423: g_module ||
1424: l_api_name,
1425: '211:Calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS API'
1426: );

Line 1443: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1439: p_term_cancel_source => 'MANUAL',
1440: p_date_cancelled => sysdate,
1441: p_validate_status => 'Y');
1442:
1443: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1444: THEN
1445: fnd_log.STRING (fnd_log.level_statement,
1446: g_module ||
1447: l_api_name,

Line 1445: fnd_log.STRING (fnd_log.level_statement,

1441: p_validate_status => 'Y');
1442:
1443: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1444: THEN
1445: fnd_log.STRING (fnd_log.level_statement,
1446: g_module ||
1447: l_api_name,
1448: '212:x_return_status after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS: ' ||p_chr_id||': '||x_return_status);
1449: fnd_log.STRING (fnd_log.level_statement,

Line 1449: fnd_log.STRING (fnd_log.level_statement,

1445: fnd_log.STRING (fnd_log.level_statement,
1446: g_module ||
1447: l_api_name,
1448: '212:x_return_status after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS: ' ||p_chr_id||': '||x_return_status);
1449: fnd_log.STRING (fnd_log.level_statement,
1450: g_module ||
1451: l_api_name,
1452: '213:x_msg_data after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS for ' ||p_chr_id||': '||x_msg_data);
1453: fnd_log.STRING (fnd_log.level_statement,

Line 1453: fnd_log.STRING (fnd_log.level_statement,

1449: fnd_log.STRING (fnd_log.level_statement,
1450: g_module ||
1451: l_api_name,
1452: '213:x_msg_data after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS for ' ||p_chr_id||': '||x_msg_data);
1453: fnd_log.STRING (fnd_log.level_statement,
1454: g_module ||
1455: l_api_name,
1456: '214:x_msg_count after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS for ' ||p_chr_id||': '||x_msg_count);
1457: END IF;

Line 1475: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1471:
1472:
1473: --if contract status got updated then update the jtf notes otherwise return error status
1474: if(p_contract_notes IS NOT NULL) then
1475: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1476: THEN
1477: fnd_log.STRING (fnd_log.level_statement,
1478: g_module ||
1479: l_api_name,

Line 1477: fnd_log.STRING (fnd_log.level_statement,

1473: --if contract status got updated then update the jtf notes otherwise return error status
1474: if(p_contract_notes IS NOT NULL) then
1475: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1476: THEN
1477: fnd_log.STRING (fnd_log.level_statement,
1478: g_module ||
1479: l_api_name,
1480: '215:Calling JTF_NOTES_PUB.CREATE_NOTE API');
1481: END IF;

Line 1506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1502: p_created_by => FND_GLOBAL.USER_ID,
1503: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1504: p_note_type => 'OKS_ADMIN');
1505:
1506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1507: THEN
1508: fnd_log.STRING (fnd_log.level_statement,
1509: g_module ||
1510: l_api_name,

Line 1508: fnd_log.STRING (fnd_log.level_statement,

1504: p_note_type => 'OKS_ADMIN');
1505:
1506: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1507: THEN
1508: fnd_log.STRING (fnd_log.level_statement,
1509: g_module ||
1510: l_api_name,
1511: '216:l_jtf_note_id after calling JTF_NOTES_PUB.CREATE_NOTE: ' ||p_chr_id||': '||l_jtf_note_id);
1512: fnd_log.STRING (fnd_log.level_statement,

Line 1512: fnd_log.STRING (fnd_log.level_statement,

1508: fnd_log.STRING (fnd_log.level_statement,
1509: g_module ||
1510: l_api_name,
1511: '216:l_jtf_note_id after calling JTF_NOTES_PUB.CREATE_NOTE: ' ||p_chr_id||': '||l_jtf_note_id);
1512: fnd_log.STRING (fnd_log.level_statement,
1513: g_module ||
1514: l_api_name,
1515: '217:x_return_status after calling JTF_NOTES_PUB.CREATE_NOTE: ' ||p_chr_id||': '||x_return_status);
1516: fnd_log.STRING (fnd_log.level_statement,

Line 1516: fnd_log.STRING (fnd_log.level_statement,

1512: fnd_log.STRING (fnd_log.level_statement,
1513: g_module ||
1514: l_api_name,
1515: '217:x_return_status after calling JTF_NOTES_PUB.CREATE_NOTE: ' ||p_chr_id||': '||x_return_status);
1516: fnd_log.STRING (fnd_log.level_statement,
1517: g_module ||
1518: l_api_name,
1519: '218:x_msg_data after calling JTF_NOTES_PUB.CREATE_NOTE for ' ||p_chr_id||': '||x_msg_data);
1520: fnd_log.STRING (fnd_log.level_statement,

Line 1520: fnd_log.STRING (fnd_log.level_statement,

1516: fnd_log.STRING (fnd_log.level_statement,
1517: g_module ||
1518: l_api_name,
1519: '218:x_msg_data after calling JTF_NOTES_PUB.CREATE_NOTE for ' ||p_chr_id||': '||x_msg_data);
1520: fnd_log.STRING (fnd_log.level_statement,
1521: g_module ||
1522: l_api_name,
1523: '219:x_msg_count after calling JTF_NOTES_PUB.CREATE_NOTE for ' ||p_chr_id||': '||x_msg_count);
1524: END IF;

Line 1560: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1556:
1557: --Update Follow Up Action and Date, Forecast Percent and Date
1558: -- if ((p_est_percent IS NOT NULL) OR (p_action IS NOT NULL) ) then
1559:
1560: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1561: THEN
1562: fnd_log.STRING (fnd_log.level_statement,
1563: g_module ||
1564: l_api_name,

Line 1562: fnd_log.STRING (fnd_log.level_statement,

1558: -- if ((p_est_percent IS NOT NULL) OR (p_action IS NOT NULL) ) then
1559:
1560: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1561: THEN
1562: fnd_log.STRING (fnd_log.level_statement,
1563: g_module ||
1564: l_api_name,
1565: '220:Now Updating Follow Up Action and Date, Forecast Percent and Date in oks_k_headers_b');
1566: END IF;

Line 1592: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1588: l_sql_err := SQLERRM;
1589: fnd_message.set_name('OKS','OKS_FOREACST_FOLLOWUP_ERROR');
1590: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1591:
1592: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1593: THEN
1594: fnd_log.STRING (fnd_log.level_statement,
1595: g_module ||
1596: l_api_name,

Line 1594: fnd_log.STRING (fnd_log.level_statement,

1590: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1591:
1592: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1593: THEN
1594: fnd_log.STRING (fnd_log.level_statement,
1595: g_module ||
1596: l_api_name,
1597: '221a:Forecast and Follow Up update failed - l_sql_err:'||l_sql_err);
1598: END IF;

Line 1604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1600: x_msg_data:= fnd_message.get;
1601: x_return_status := g_ret_sts_error;
1602: x_msg_count := 1;
1603: end if;
1604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1605: THEN
1606: fnd_log.STRING (fnd_log.level_statement,
1607: g_module ||
1608: l_api_name,

Line 1606: fnd_log.STRING (fnd_log.level_statement,

1602: x_msg_count := 1;
1603: end if;
1604: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1605: THEN
1606: fnd_log.STRING (fnd_log.level_statement,
1607: g_module ||
1608: l_api_name,
1609: '221:Inside Update Follow Up and Forecast part - x_return_status:'||x_return_status);
1610: END IF;

Line 1626: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1622: ---Update Renewal Notes - kkolukul
1623:
1624: IF(p_renewal_notes IS NOT NULL) THEN
1625:
1626: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1627: fnd_log.STRING (fnd_log.level_statement,
1628: g_module ||
1629: l_api_name,
1630: '222:Now Updating Renewal Comment in oks_k_headers_b');

Line 1627: fnd_log.STRING (fnd_log.level_statement,

1623:
1624: IF(p_renewal_notes IS NOT NULL) THEN
1625:
1626: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1627: fnd_log.STRING (fnd_log.level_statement,
1628: g_module ||
1629: l_api_name,
1630: '222:Now Updating Renewal Comment in oks_k_headers_b');
1631: END IF;

Line 1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1654: END IF; --End: Update Renewal Notes - kkolukul
1655:
1656: --Update minor version
1657: if (l_minor_version_updated = 'F') THEN
1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1659: THEN
1660: fnd_log.STRING (fnd_log.level_statement,
1661: g_module ||
1662: l_api_name,

Line 1660: fnd_log.STRING (fnd_log.level_statement,

1656: --Update minor version
1657: if (l_minor_version_updated = 'F') THEN
1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1659: THEN
1660: fnd_log.STRING (fnd_log.level_statement,
1661: g_module ||
1662: l_api_name,
1663: '224:Now Updating minor_version in okc_k_vers_numbers');
1664: END IF;

Line 1679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1675: l_sql_err := SQLERRM;
1676: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1677: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1678:
1679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1680: THEN
1681: fnd_log.STRING (fnd_log.level_statement,
1682: g_module ||
1683: l_api_name,

Line 1681: fnd_log.STRING (fnd_log.level_statement,

1677: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1678:
1679: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1680: THEN
1681: fnd_log.STRING (fnd_log.level_statement,
1682: g_module ||
1683: l_api_name,
1684: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1685: END IF;

Line 1698: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1694: l_sql_err := SQLERRM;
1695: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1696: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1697:
1698: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1699: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1700: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1701: END IF;
1702:

Line 1699: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,

1695: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1696: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1697:
1698: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1699: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1700: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1701: END IF;
1702:
1703: x_msg_data:= fnd_message.get;

Line 1709: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1705: x_msg_count := 1;
1706: END IF;
1707:
1708:
1709: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1710: THEN
1711: fnd_log.STRING (fnd_log.level_statement,
1712: g_module ||
1713: l_api_name,

Line 1711: fnd_log.STRING (fnd_log.level_statement,

1707:
1708:
1709: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1710: THEN
1711: fnd_log.STRING (fnd_log.level_statement,
1712: g_module ||
1713: l_api_name,
1714: '225:Inside Update minor version part - x_return_status:'||x_return_status);
1715: END IF;

Line 1727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1723: end if;--end update minor version
1724:
1725: commit work;
1726:
1727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1728: THEN
1729: fnd_log.STRING (fnd_log.level_statement,
1730: g_module ||
1731: l_api_name,

Line 1729: fnd_log.STRING (fnd_log.level_statement,

1725: commit work;
1726:
1727: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1728: THEN
1729: fnd_log.STRING (fnd_log.level_statement,
1730: g_module ||
1731: l_api_name,
1732: '226:Changes commited');
1733: fnd_log.STRING (fnd_log.level_statement,

Line 1733: fnd_log.STRING (fnd_log.level_statement,

1729: fnd_log.STRING (fnd_log.level_statement,
1730: g_module ||
1731: l_api_name,
1732: '226:Changes commited');
1733: fnd_log.STRING (fnd_log.level_statement,
1734: g_module ||
1735: l_api_name,
1736: '227:Final x_return_status:'||x_return_status);
1737: END IF;

Line 1746: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1742: EXCEPTION
1743: WHEN fnd_api.g_exc_error THEN
1744: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1745:
1746: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1747: fnd_log.STRING (fnd_log.level_statement,
1748: g_module ||
1749: l_api_name,
1750: '2000: Leaving ' ||

Line 1747: fnd_log.STRING (fnd_log.level_statement,

1743: WHEN fnd_api.g_exc_error THEN
1744: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1745:
1746: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1747: fnd_log.STRING (fnd_log.level_statement,
1748: g_module ||
1749: l_api_name,
1750: '2000: Leaving ' ||
1751: g_pkg_name ||

Line 1766: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1762: );
1763: WHEN fnd_api.g_exc_unexpected_error THEN
1764: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1765:
1766: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1767: fnd_log.STRING (fnd_log.level_statement,
1768: g_module ||
1769: l_api_name,
1770: '3000: Leaving ' ||

Line 1767: fnd_log.STRING (fnd_log.level_statement,

1763: WHEN fnd_api.g_exc_unexpected_error THEN
1764: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1765:
1766: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1767: fnd_log.STRING (fnd_log.level_statement,
1768: g_module ||
1769: l_api_name,
1770: '3000: Leaving ' ||
1771: g_pkg_name ||

Line 1787: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

1783:
1784: WHEN OTHERS THEN
1785: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1786:
1787: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1788: THEN
1789: fnd_log.STRING (fnd_log.level_statement,
1790: g_module ||
1791: l_api_name,

Line 1789: fnd_log.STRING (fnd_log.level_statement,

1785: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1786:
1787: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1788: THEN
1789: fnd_log.STRING (fnd_log.level_statement,
1790: g_module ||
1791: l_api_name,
1792: 'Leaving ' ||
1793: g_pkg_name ||