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 49: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

45:
46:
47: BEGIN
48: -- start debug log
49: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
50: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
51: G_MODULE||l_api_name,
52: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
53: END IF;

Line 50: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

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

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

71: set RMNDR_SUPPRESS_FLAG = p_suppress_yn,
72: object_version_number = object_version_number+1
73: where chr_id = p_chr_id;
74: ELSE
75: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
77: G_MODULE||l_api_name,
78: '1000: Not a valid action for this contract'||G_PKG_NAME ||'.'||l_api_name);
79: END IF;

Line 76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

72: object_version_number = object_version_number+1
73: where chr_id = p_chr_id;
74: ELSE
75: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
76: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
77: G_MODULE||l_api_name,
78: '1000: Not a valid action for this contract'||G_PKG_NAME ||'.'||l_api_name);
79: END IF;
80: x_return_status := G_RET_STS_ACTION_NOT_ALWD;

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

85: -- Standard call to get message count and if count is 1, get message info.
86: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
87:
88: -- end debug log
89: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
91: G_MODULE||l_api_name,
92: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
93: END IF;

Line 90: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

86: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
87:
88: -- end debug log
89: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
91: G_MODULE||l_api_name,
92: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
93: END IF;
94:

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

94:
95: EXCEPTION
96: WHEN ActionNotAllowedException THEN
97: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
98: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
99: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
100: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
101: ' Contract cannot be published since it is not in entered status');
102: END IF;

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

95: EXCEPTION
96: WHEN ActionNotAllowedException THEN
97: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
98: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
99: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
100: 'Leaving '||G_PKG_NAME ||'.'||l_api_name||'.ActionNotAllowedException '||
101: ' Contract cannot be published since it is not in entered status');
102: END IF;
103: x_return_status := G_RET_STS_ACTION_NOT_ALWD;

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

101: ' Contract cannot be published since it is not in entered status');
102: END IF;
103: x_return_status := G_RET_STS_ACTION_NOT_ALWD;
104: WHEN FND_API.G_EXC_ERROR THEN
105: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
106: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
107: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with ERROR status');
108: END IF;
109:

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

102: END IF;
103: x_return_status := G_RET_STS_ACTION_NOT_ALWD;
104: WHEN FND_API.G_EXC_ERROR THEN
105: IF FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
106: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,G_MODULE||l_api_name,
107: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with ERROR status');
108: END IF;
109:
110: x_return_status := G_RET_STS_ERROR ;

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

110: x_return_status := G_RET_STS_ERROR ;
111: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
115: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
116: G_MODULE||l_api_name,
117: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with Unexpected Error status');
118: END IF;

Line 115: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

111: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
112:
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
115: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
116: G_MODULE||l_api_name,
117: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name||' with Unexpected Error status');
118: END IF;
119:

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

120: x_return_status := G_RET_STS_UNEXP_ERROR ;
121: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
122:
123: WHEN OTHERS THEN
124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
126: G_MODULE||l_api_name,
127: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name ||' with unexpected error');
128: END IF;

Line 125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

121: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
122:
123: WHEN OTHERS THEN
124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
126: G_MODULE||l_api_name,
127: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name ||' with unexpected error');
128: END IF;
129: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

254: commit work;
255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
260: G_MODULE||l_api_name,
261: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
262: END IF;

Line 259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

255:
256: EXCEPTION
257: WHEN FND_API.G_EXC_ERROR THEN
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
259: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
260: G_MODULE||l_api_name,
261: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
262: END IF;
263:

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

264: x_return_status := G_RET_STS_ERROR ;
265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
270: G_MODULE||l_api_name,
271: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
272: END IF;

Line 269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

265: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
269: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
270: G_MODULE||l_api_name,
271: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
272: END IF;
273:

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

274: x_return_status := G_RET_STS_UNEXP_ERROR ;
275: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
276:
277: WHEN OTHERS THEN
278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
280: G_MODULE||l_api_name,
281: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
282: END IF;

Line 279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

275: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
276:
277: WHEN OTHERS THEN
278: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
280: G_MODULE||l_api_name,
281: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
282: END IF;
283: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 372: -- write to fnd_log file

368:
369: l_count := l_msg_tbl.first;
370: LOOP
371: IF l_msg_tbl(l_count).error_status='E' THEN
372: -- write to fnd_log file
373: fnd_file.put_line(FND_FILE.LOG,l_msg_ctr||' : '||l_msg_tbl(l_count).data);
374:
375: -- reset the out parameter to Error
376: x_return_status := 'E';

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

390: fnd_file.put_line(FND_FILE.LOG,' ');
391:
392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN
394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
396: G_MODULE||l_api_name,
397: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
398: END IF;

Line 395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

391:
392: EXCEPTION
393: WHEN FND_API.G_EXC_ERROR THEN
394: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
395: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
396: G_MODULE||l_api_name,
397: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
398: END IF;
399:

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

400: x_return_status := G_RET_STS_ERROR ;
401: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
402:
403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
404: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
406: G_MODULE||l_api_name,
407: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
408: END IF;

Line 405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

401: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
402:
403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
404: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
405: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
406: G_MODULE||l_api_name,
407: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
408: END IF;
409:

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

410: x_return_status := G_RET_STS_UNEXP_ERROR ;
411: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
412:
413: WHEN OTHERS THEN
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
416: G_MODULE||l_api_name,
417: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
418: END IF;

Line 415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

411: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
412:
413: WHEN OTHERS THEN
414: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
416: G_MODULE||l_api_name,
417: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
418: END IF;
419: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

457: l_request_id NUMBER := 0;
458:
459: BEGIN
460: -- start debug log
461: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
463: G_MODULE||l_api_name,
464: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
465: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

458:
459: BEGIN
460: -- start debug log
461: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
463: G_MODULE||l_api_name,
464: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
465: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
466: G_MODULE||l_api_name,

Line 465: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

461: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
462: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
463: G_MODULE||l_api_name,
464: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
465: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
466: G_MODULE||l_api_name,
467: '100: Parameters ');
468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
469: G_MODULE||l_api_name,

Line 468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

464: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
465: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
466: G_MODULE||l_api_name,
467: '100: Parameters ');
468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
469: G_MODULE||l_api_name,
470: '100: p_contract_list : '||p_contract_list);
471: END IF;
472:

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

489: tmp_contract_list := p_contract_list;
490: x_cp_request_id := 0;
491:
492: -- debug log
493: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
495: G_MODULE||l_api_name,
496: '110: Converting K list to pl/sql');
497: END IF;

Line 494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

490: x_cp_request_id := 0;
491:
492: -- debug log
493: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
494: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
495: G_MODULE||l_api_name,
496: '110: Converting K list to pl/sql');
497: END IF;
498:

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

500: LOOP
501: i := INSTR(tmp_contract_list,',');
502:
503: -- debug log
504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
506: G_MODULE||l_api_name,
507: '120: i : '||i);
508: END IF;

Line 505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

501: i := INSTR(tmp_contract_list,',');
502:
503: -- debug log
504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
506: G_MODULE||l_api_name,
507: '120: i : '||i);
508: END IF;
509:

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

512:
513: l_chr_id_tbl(j) := SUBSTR(tmp_contract_list,1,i-1);
514:
515: -- debug log
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
518: G_MODULE||l_api_name,
519: '130: j :'||j);
520: END IF;

Line 517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

513: l_chr_id_tbl(j) := SUBSTR(tmp_contract_list,1,i-1);
514:
515: -- debug log
516: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
517: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
518: G_MODULE||l_api_name,
519: '130: j :'||j);
520: END IF;
521:

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

521:
522: tmp_contract_list := SUBSTR(tmp_contract_list,i+1, length(tmp_contract_list) - i);
523:
524: -- debug log
525: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
526: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
527: G_MODULE||l_api_name,
528: '130: tmp_contract_list : '||tmp_contract_list);
529: END IF;

Line 526: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

522: tmp_contract_list := SUBSTR(tmp_contract_list,i+1, length(tmp_contract_list) - i);
523:
524: -- debug log
525: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
526: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
527: G_MODULE||l_api_name,
528: '130: tmp_contract_list : '||tmp_contract_list);
529: END IF;
530:

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

537:
538: END LOOP;
539:
540: -- debug log
541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
543: G_MODULE||l_api_name,
544: '200: After Converting K list to pl/sql');
545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

538: END LOOP;
539:
540: -- debug log
541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
543: G_MODULE||l_api_name,
544: '200: After Converting K list to pl/sql');
545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
546: G_MODULE||l_api_name,

Line 545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
543: G_MODULE||l_api_name,
544: '200: After Converting K list to pl/sql');
545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
546: G_MODULE||l_api_name,
547: '200: Count of Ks is : '||l_chr_id_tbl.COUNT);
548: END IF;
549:

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

566: ARGUMENT1 => p_contract_list
567: );
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: '300: Request Id of pgm : '||l_request_id);
574: END IF;

Line 571: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

567: );
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: '300: Request Id of pgm : '||l_request_id);
574: END IF;
575:

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

593: -- Standard call to get message count and if count is 1, get message info.
594: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
595:
596: -- end debug log
597: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
599: G_MODULE||l_api_name,
600: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
601: END IF;

Line 598: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

594: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
595:
596: -- end debug log
597: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
598: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
599: G_MODULE||l_api_name,
600: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
601: END IF;
602:

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

601: END IF;
602:
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
606: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
607: G_MODULE||l_api_name,
608: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
609: END IF;

Line 606: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

602:
603: EXCEPTION
604: WHEN FND_API.G_EXC_ERROR THEN
605: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
606: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
607: G_MODULE||l_api_name,
608: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
609: END IF;
610:

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

611: x_return_status := G_RET_STS_ERROR ;
612: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
613:
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
616: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
617: G_MODULE||l_api_name,
618: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
619: END IF;

Line 616: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

612: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
613:
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
616: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
617: G_MODULE||l_api_name,
618: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
619: END IF;
620:

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

621: x_return_status := G_RET_STS_UNEXP_ERROR ;
622: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
623:
624: WHEN OTHERS THEN
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
627: G_MODULE||l_api_name,
628: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
629: END IF;

Line 626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

622: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
623:
624: WHEN OTHERS THEN
625: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
627: G_MODULE||l_api_name,
628: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
629: END IF;
630: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

676:
677: BEGIN
678:
679: -- start debug log
680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
682: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
683: END IF;
684:

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

677: BEGIN
678:
679: -- start debug log
680: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
681: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
682: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
683: END IF;
684:
685: -- we don't want to restrict enabling / disabling reminders when contract is in

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

704: CLOSE chr_cur;
705: END IF;
706:
707: -- end debug log
708: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
710: G_MODULE||l_api_name,
711: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name || ' with return value: '||l_return_val);
712: END IF;

Line 709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

705: END IF;
706:
707: -- end debug log
708: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
709: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
710: G_MODULE||l_api_name,
711: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name || ' with return value: '||l_return_val);
712: END IF;
713: return(l_return_val);

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

713: return(l_return_val);
714:
715: EXCEPTION
716: WHEN others THEN
717: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
719: '2000: Leaving with error '||G_PKG_NAME ||'.'||l_api_name);
720: END IF;
721: l_return_val := 'N';

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

714:
715: EXCEPTION
716: WHEN others THEN
717: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
719: '2000: Leaving with error '||G_PKG_NAME ||'.'||l_api_name);
720: END IF;
721: l_return_val := 'N';
722: return(l_return_val);

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

759: mo_global.init('OKC');
760:
761:
762: -- start debug log
763: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
765: G_MODULE||l_api_name,
766: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

760:
761:
762: -- start debug log
763: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
765: G_MODULE||l_api_name,
766: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
768: G_MODULE||l_api_name,

Line 767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

763: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
765: G_MODULE||l_api_name,
766: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
768: G_MODULE||l_api_name,
769: '100: Parameters ');
770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
771: G_MODULE||l_api_name,

Line 770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

766: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
767: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
768: G_MODULE||l_api_name,
769: '100: Parameters ');
770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
771: G_MODULE||l_api_name,
772: '102: p_from_address : '||p_from_address);
773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
774: G_MODULE||l_api_name,

Line 773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

769: '100: Parameters ');
770: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
771: G_MODULE||l_api_name,
772: '102: p_from_address : '||p_from_address);
773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
774: G_MODULE||l_api_name,
775: '103: p_to_address : '||p_to_address);
776: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
777: G_MODULE||l_api_name,

Line 776: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

772: '102: p_from_address : '||p_from_address);
773: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
774: G_MODULE||l_api_name,
775: '103: p_to_address : '||p_to_address);
776: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
777: G_MODULE||l_api_name,
778: '104: p_cc_address : '||p_cc_address);
779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
780: G_MODULE||l_api_name,

Line 779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

775: '103: p_to_address : '||p_to_address);
776: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
777: G_MODULE||l_api_name,
778: '104: p_cc_address : '||p_cc_address);
779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
780: G_MODULE||l_api_name,
781: '106: p_reply_to_address : '||p_reply_to_address);
782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
783: G_MODULE||l_api_name,

Line 782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

778: '104: p_cc_address : '||p_cc_address);
779: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
780: G_MODULE||l_api_name,
781: '106: p_reply_to_address : '||p_reply_to_address);
782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
783: G_MODULE||l_api_name,
784: '107: p_message_template_id : '||p_message_template_id);
785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
786: G_MODULE||l_api_name,

Line 785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

781: '106: p_reply_to_address : '||p_reply_to_address);
782: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
783: G_MODULE||l_api_name,
784: '107: p_message_template_id : '||p_message_template_id);
785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
786: G_MODULE||l_api_name,
787: '108: p_attachment_template_id : '||p_attachment_template_id);
788: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
789: G_MODULE||l_api_name,

Line 788: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

784: '107: p_message_template_id : '||p_message_template_id);
785: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
786: G_MODULE||l_api_name,
787: '108: p_attachment_template_id : '||p_attachment_template_id);
788: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
789: G_MODULE||l_api_name,
790: '109: p_email_subject : '||p_email_subject);
791: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
792: G_MODULE||l_api_name,

Line 791: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

787: '108: p_attachment_template_id : '||p_attachment_template_id);
788: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
789: G_MODULE||l_api_name,
790: '109: p_email_subject : '||p_email_subject);
791: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
792: G_MODULE||l_api_name,
793: '111: p_email_contract_status : '||p_email_contract_status);
794: END IF;
795:

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

836:
837:
838: EXCEPTION
839: WHEN OTHERS THEN
840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
842: G_MODULE||l_api_name,
843: '4657: Leaving '||G_PKG_NAME ||'.'||l_api_name||'.'||SQLERRM);
844: END IF;

Line 841: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

837:
838: EXCEPTION
839: WHEN OTHERS THEN
840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
842: G_MODULE||l_api_name,
843: '4657: Leaving '||G_PKG_NAME ||'.'||l_api_name||'.'||SQLERRM);
844: END IF;
845:

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

844: END IF;
845:
846: END;
847:
848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
850: G_MODULE||l_api_name,
851: '200: After inserting into table:');
852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

845:
846: END;
847:
848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
850: G_MODULE||l_api_name,
851: '200: After inserting into table:');
852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
853: G_MODULE||l_api_name,

Line 852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
849: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
850: G_MODULE||l_api_name,
851: '200: After inserting into table:');
852: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
853: G_MODULE||l_api_name,
854: '201: email id generated from store_email_dtls : '||l_email_id);
855: END IF;
856:

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

859: commit work;
860:
861:
862: -- end debug log
863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
865: G_MODULE||l_api_name,
866: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
867: END IF;

Line 864: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

860:
861:
862: -- end debug log
863: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
865: G_MODULE||l_api_name,
866: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
867: END IF;
868:

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

867: END IF;
868:
869: EXCEPTION
870: WHEN FND_API.G_EXC_ERROR THEN
871: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
872: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
873: G_MODULE||l_api_name,
874: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
875: END IF;

Line 872: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

868:
869: EXCEPTION
870: WHEN FND_API.G_EXC_ERROR THEN
871: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
872: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
873: G_MODULE||l_api_name,
874: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
875: END IF;
876:

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

876:
877: x_return_status := G_RET_STS_ERROR ;
878:
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
882: G_MODULE||l_api_name,
883: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
884: END IF;

Line 881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

877: x_return_status := G_RET_STS_ERROR ;
878:
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
881: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
882: G_MODULE||l_api_name,
883: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
884: END IF;
885:

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

885:
886: x_return_status := G_RET_STS_UNEXP_ERROR ;
887:
888: WHEN OTHERS THEN
889: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
890: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
891: G_MODULE||l_api_name,
892: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name||'.'||SQLERRM);
893: END IF;

Line 890: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

886: x_return_status := G_RET_STS_UNEXP_ERROR ;
887:
888: WHEN OTHERS THEN
889: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
890: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
891: G_MODULE||l_api_name,
892: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name||'.'||SQLERRM);
893: END IF;
894:

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

911: l_api_name CONSTANT VARCHAR2(30) := 'GET_EMAIL_DTLS';
912:
913: BEGIN
914: -- start debug log
915: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
917: G_MODULE||l_api_name,
918: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 916: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

912:
913: BEGIN
914: -- start debug log
915: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
917: G_MODULE||l_api_name,
918: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
920: G_MODULE||l_api_name,

Line 919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

915: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
917: G_MODULE||l_api_name,
918: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
920: G_MODULE||l_api_name,
921: '300: Parameters ');
922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
923: G_MODULE||l_api_name,

Line 922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

918: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
919: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
920: G_MODULE||l_api_name,
921: '300: Parameters ');
922: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
923: G_MODULE||l_api_name,
924: '301: p_email_id : '||p_email_id);
925: END IF;
926:

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

936: FROM OKS_EMAIL_DETAILS
937: WHERE email_id = p_email_id;
938:
939: -- end debug log
940: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
941: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
942: G_MODULE||l_api_name,
943: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
944: END IF;

Line 941: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

937: WHERE email_id = p_email_id;
938:
939: -- end debug log
940: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
941: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
942: G_MODULE||l_api_name,
943: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
944: END IF;
945:

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

944: END IF;
945:
946: EXCEPTION
947: WHEN FND_API.G_EXC_ERROR THEN
948: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
950: G_MODULE||l_api_name,
951: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
952: END IF;

Line 949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

945:
946: EXCEPTION
947: WHEN FND_API.G_EXC_ERROR THEN
948: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
950: G_MODULE||l_api_name,
951: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
952: END IF;
953:

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

953:
954: x_return_status := G_RET_STS_ERROR ;
955:
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
959: G_MODULE||l_api_name,
960: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
961: END IF;

Line 958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

954: x_return_status := G_RET_STS_ERROR ;
955:
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
958: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
959: G_MODULE||l_api_name,
960: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
961: END IF;
962:

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

962:
963: x_return_status := G_RET_STS_UNEXP_ERROR ;
964:
965: WHEN OTHERS THEN
966: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
968: G_MODULE||l_api_name,
969: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
970: END IF;

Line 967: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

963: x_return_status := G_RET_STS_UNEXP_ERROR ;
964:
965: WHEN OTHERS THEN
966: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
967: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
968: G_MODULE||l_api_name,
969: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
970: END IF;
971:

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

988:
989: BEGIN
990:
991: -- start debug log
992: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
994: G_MODULE||l_api_name,
995: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
996: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

989: BEGIN
990:
991: -- start debug log
992: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
994: G_MODULE||l_api_name,
995: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
996: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
997: G_MODULE||l_api_name,

Line 996: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

992: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
993: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
994: G_MODULE||l_api_name,
995: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
996: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
997: G_MODULE||l_api_name,
998: '400: Parameters ');
999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1000: G_MODULE||l_api_name,

Line 999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

995: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
996: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
997: G_MODULE||l_api_name,
998: '400: Parameters ');
999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1000: G_MODULE||l_api_name,
1001: '401: p_email_id : '||p_email_id);
1002: END IF;
1003:

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

1010: DELETE FROM OKS_EMAIL_DETAILS WHERE email_id = p_email_id;
1011:
1012: IF SQL%ROWCOUNT = 0 THEN
1013:
1014: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1015: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1016: G_MODULE||l_api_name,
1017: '402: Rows are deleted successfully from OKS_EMAIL_DETAILS table');
1018: END IF;

Line 1015: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1011:
1012: IF SQL%ROWCOUNT = 0 THEN
1013:
1014: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1015: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1016: G_MODULE||l_api_name,
1017: '402: Rows are deleted successfully from OKS_EMAIL_DETAILS table');
1018: END IF;
1019:

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

1019:
1020: END IF;
1021:
1022: -- end debug log
1023: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1025: G_MODULE||l_api_name,
1026: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1027: END IF;

Line 1024: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1020: END IF;
1021:
1022: -- end debug log
1023: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1025: G_MODULE||l_api_name,
1026: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1027: END IF;
1028:

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

1027: END IF;
1028:
1029: EXCEPTION
1030: WHEN FND_API.G_EXC_ERROR THEN
1031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1033: G_MODULE||l_api_name,
1034: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1035: END IF;

Line 1032: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1028:
1029: EXCEPTION
1030: WHEN FND_API.G_EXC_ERROR THEN
1031: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1032: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1033: G_MODULE||l_api_name,
1034: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1035: END IF;
1036:

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

1036:
1037: x_return_status := G_RET_STS_ERROR ;
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1042: G_MODULE||l_api_name,
1043: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1044: END IF;

Line 1041: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1037: x_return_status := G_RET_STS_ERROR ;
1038:
1039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1040: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1041: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1042: G_MODULE||l_api_name,
1043: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1044: END IF;
1045:

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

1045:
1046: x_return_status := G_RET_STS_UNEXP_ERROR ;
1047:
1048: WHEN OTHERS THEN
1049: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1050: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1051: G_MODULE||l_api_name,
1052: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1053: END IF;

Line 1050: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1046: x_return_status := G_RET_STS_UNEXP_ERROR ;
1047:
1048: WHEN OTHERS THEN
1049: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1050: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1051: G_MODULE||l_api_name,
1052: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1053: END IF;
1054:

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

1180: commit work;
1181:
1182: EXCEPTION
1183: WHEN FND_API.G_EXC_ERROR THEN
1184: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1186: G_MODULE||l_api_name,
1187: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1188: END IF;

Line 1185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1181:
1182: EXCEPTION
1183: WHEN FND_API.G_EXC_ERROR THEN
1184: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1185: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1186: G_MODULE||l_api_name,
1187: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1188: END IF;
1189:

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

1190: x_return_status := G_RET_STS_ERROR ;
1191: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1192:
1193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1194: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1196: G_MODULE||l_api_name,
1197: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1198: END IF;

Line 1195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1191: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1192:
1193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1194: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1195: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1196: G_MODULE||l_api_name,
1197: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1198: END IF;
1199:

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

1200: x_return_status := G_RET_STS_UNEXP_ERROR ;
1201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1202:
1203: WHEN OTHERS THEN
1204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1206: G_MODULE||l_api_name,
1207: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1208: END IF;

Line 1205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1201: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1202:
1203: WHEN OTHERS THEN
1204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1205: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1206: G_MODULE||l_api_name,
1207: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1208: END IF;
1209: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

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

1259: l_old_est_rev_date oks_k_headers_b.est_rev_date%TYPE;
1260:
1261: BEGIN
1262: -- start debug log
1263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1264: THEN
1265: fnd_log.STRING (fnd_log.level_statement,
1266: g_module ||
1267: l_api_name,

Line 1265: fnd_log.STRING (fnd_log.level_statement,

1261: BEGIN
1262: -- start debug log
1263: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1264: THEN
1265: fnd_log.STRING (fnd_log.level_statement,
1266: g_module ||
1267: l_api_name,
1268: '100: Entered ' ||
1269: g_pkg_name ||

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

1280:
1281: DBMS_TRANSACTION.SAVEPOINT(l_api_name);
1282:
1283: -- Printing input paramter values
1284: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1285: THEN
1286: fnd_log.STRING (fnd_log.level_statement,
1287: g_module ||
1288: l_api_name,

Line 1286: fnd_log.STRING (fnd_log.level_statement,

1282:
1283: -- Printing input paramter values
1284: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1285: THEN
1286: fnd_log.STRING (fnd_log.level_statement,
1287: g_module ||
1288: l_api_name,
1289: '101:p_chr_id = ' ||p_chr_id
1290: );

Line 1291: fnd_log.STRING (fnd_log.level_statement,

1287: g_module ||
1288: l_api_name,
1289: '101:p_chr_id = ' ||p_chr_id
1290: );
1291: fnd_log.STRING (fnd_log.level_statement,
1292: g_module ||
1293: l_api_name,
1294: '102:p_status_code = ' ||p_status_code
1295: );

Line 1296: fnd_log.STRING (fnd_log.level_statement,

1292: g_module ||
1293: l_api_name,
1294: '102:p_status_code = ' ||p_status_code
1295: );
1296: fnd_log.STRING (fnd_log.level_statement,
1297: g_module ||
1298: l_api_name,
1299: '103:p_reason_code = ' ||p_reason_code
1300: );

Line 1301: fnd_log.STRING (fnd_log.level_statement,

1297: g_module ||
1298: l_api_name,
1299: '103:p_reason_code = ' ||p_reason_code
1300: );
1301: fnd_log.STRING (fnd_log.level_statement,
1302: g_module ||
1303: l_api_name,
1304: '104:p_comments = ' ||p_comments
1305: );

Line 1306: fnd_log.STRING (fnd_log.level_statement,

1302: g_module ||
1303: l_api_name,
1304: '104:p_comments = ' ||p_comments
1305: );
1306: fnd_log.STRING (fnd_log.level_statement,
1307: g_module ||
1308: l_api_name,
1309: '105:p_due_date = ' ||p_due_date
1310: );

Line 1311: fnd_log.STRING (fnd_log.level_statement,

1307: g_module ||
1308: l_api_name,
1309: '105:p_due_date = ' ||p_due_date
1310: );
1311: fnd_log.STRING (fnd_log.level_statement,
1312: g_module ||
1313: l_api_name,
1314: '106:p_action = ' ||p_action
1315: );

Line 1316: fnd_log.STRING (fnd_log.level_statement,

1312: g_module ||
1313: l_api_name,
1314: '106:p_action = ' ||p_action
1315: );
1316: fnd_log.STRING (fnd_log.level_statement,
1317: g_module ||
1318: l_api_name,
1319: '107:p_est_percent = ' ||p_est_percent
1320: );

Line 1321: fnd_log.STRING (fnd_log.level_statement,

1317: g_module ||
1318: l_api_name,
1319: '107:p_est_percent = ' ||p_est_percent
1320: );
1321: fnd_log.STRING (fnd_log.level_statement,
1322: g_module ||
1323: l_api_name,
1324: '108:p_est_date = ' ||p_est_date
1325: );

Line 1326: fnd_log.STRING (fnd_log.level_statement,

1322: g_module ||
1323: l_api_name,
1324: '108:p_est_date = ' ||p_est_date
1325: );
1326: fnd_log.STRING (fnd_log.level_statement,
1327: g_module ||
1328: l_api_name,
1329: '109:p_contract_notes = ' ||p_contract_notes
1330: );

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

1336: close csr_k_old_status;
1337:
1338: x_succ_err_contract:= l_contract_number;
1339:
1340: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1341: THEN
1342: fnd_log.STRING (fnd_log.level_statement,
1343: g_module ||
1344: l_api_name,

Line 1342: fnd_log.STRING (fnd_log.level_statement,

1338: x_succ_err_contract:= l_contract_number;
1339:
1340: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1341: THEN
1342: fnd_log.STRING (fnd_log.level_statement,
1343: g_module ||
1344: l_api_name,
1345: '210:l_old_status_code = ' ||l_old_status_code
1346: );

Line 1347: fnd_log.STRING (fnd_log.level_statement,

1343: g_module ||
1344: l_api_name,
1345: '210:l_old_status_code = ' ||l_old_status_code
1346: );
1347: fnd_log.STRING (fnd_log.level_statement,
1348: g_module ||
1349: l_api_name,
1350: '210a:l_contract_number = ' ||l_contract_number
1351: );

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

1359: l_old_est_rev_percent,
1360: l_old_est_rev_date;
1361: CLOSE csr_k_old_forecast;
1362:
1363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1364: THEN
1365: fnd_log.STRING (fnd_log.level_statement,
1366: g_module ||
1367: l_api_name,

Line 1365: fnd_log.STRING (fnd_log.level_statement,

1361: CLOSE csr_k_old_forecast;
1362:
1363: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1364: THEN
1365: fnd_log.STRING (fnd_log.level_statement,
1366: g_module ||
1367: l_api_name,
1368: '211:l_old_follow_up_date = ' ||l_old_follow_up_date
1369: );

Line 1370: fnd_log.STRING (fnd_log.level_statement,

1366: g_module ||
1367: l_api_name,
1368: '211:l_old_follow_up_date = ' ||l_old_follow_up_date
1369: );
1370: fnd_log.STRING (fnd_log.level_statement,
1371: g_module ||
1372: l_api_name,
1373: '211:l_old_follow_up_action = ' ||l_old_follow_up_action
1374: );

Line 1375: fnd_log.STRING (fnd_log.level_statement,

1371: g_module ||
1372: l_api_name,
1373: '211:l_old_follow_up_action = ' ||l_old_follow_up_action
1374: );
1375: fnd_log.STRING (fnd_log.level_statement,
1376: g_module ||
1377: l_api_name,
1378: '211:l_old_est_rev_percent = ' ||l_old_est_rev_percent
1379: );

Line 1380: fnd_log.STRING (fnd_log.level_statement,

1376: g_module ||
1377: l_api_name,
1378: '211:l_old_est_rev_percent = ' ||l_old_est_rev_percent
1379: );
1380: fnd_log.STRING (fnd_log.level_statement,
1381: g_module ||
1382: l_api_name,
1383: '211:l_old_est_rev_date = ' ||l_old_est_rev_date
1384: );

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

1386:
1387:
1388:
1389: IF (p_status_code IS NOT NULL) THEN
1390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1391: THEN
1392: fnd_log.STRING (fnd_log.level_statement,
1393: g_module ||
1394: l_api_name,

Line 1392: fnd_log.STRING (fnd_log.level_statement,

1388:
1389: IF (p_status_code IS NOT NULL) THEN
1390: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1391: THEN
1392: fnd_log.STRING (fnd_log.level_statement,
1393: g_module ||
1394: l_api_name,
1395: '211:Calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS API'
1396: );

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

1409: p_term_cancel_source => 'MANUAL',
1410: p_date_cancelled => sysdate,
1411: p_validate_status => 'Y');
1412:
1413: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1414: THEN
1415: fnd_log.STRING (fnd_log.level_statement,
1416: g_module ||
1417: l_api_name,

Line 1415: fnd_log.STRING (fnd_log.level_statement,

1411: p_validate_status => 'Y');
1412:
1413: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1414: THEN
1415: fnd_log.STRING (fnd_log.level_statement,
1416: g_module ||
1417: l_api_name,
1418: '212:x_return_status after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS: ' ||p_chr_id||': '||x_return_status);
1419: fnd_log.STRING (fnd_log.level_statement,

Line 1419: fnd_log.STRING (fnd_log.level_statement,

1415: fnd_log.STRING (fnd_log.level_statement,
1416: g_module ||
1417: l_api_name,
1418: '212:x_return_status after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS: ' ||p_chr_id||': '||x_return_status);
1419: fnd_log.STRING (fnd_log.level_statement,
1420: g_module ||
1421: l_api_name,
1422: '213:x_msg_data after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS for ' ||p_chr_id||': '||x_msg_data);
1423: fnd_log.STRING (fnd_log.level_statement,

Line 1423: fnd_log.STRING (fnd_log.level_statement,

1419: fnd_log.STRING (fnd_log.level_statement,
1420: g_module ||
1421: l_api_name,
1422: '213:x_msg_data after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS for ' ||p_chr_id||': '||x_msg_data);
1423: fnd_log.STRING (fnd_log.level_statement,
1424: g_module ||
1425: l_api_name,
1426: '214:x_msg_count after calling OKS_CHANGE_STATUS_PVT.UPDATE_HEADER_STATUS for ' ||p_chr_id||': '||x_msg_count);
1427: END IF;

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

1441:
1442:
1443: --if contract status got updated then update the jtf notes otherwise return error status
1444: if(p_contract_notes IS NOT NULL) then
1445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1446: THEN
1447: fnd_log.STRING (fnd_log.level_statement,
1448: g_module ||
1449: l_api_name,

Line 1447: fnd_log.STRING (fnd_log.level_statement,

1443: --if contract status got updated then update the jtf notes otherwise return error status
1444: if(p_contract_notes IS NOT NULL) then
1445: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1446: THEN
1447: fnd_log.STRING (fnd_log.level_statement,
1448: g_module ||
1449: l_api_name,
1450: '215:Calling JTF_NOTES_PUB.CREATE_NOTE API');
1451: END IF;

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

1472: p_created_by => FND_GLOBAL.USER_ID,
1473: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1474: p_note_type => 'OKS_ADMIN');
1475:
1476: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1477: THEN
1478: fnd_log.STRING (fnd_log.level_statement,
1479: g_module ||
1480: l_api_name,

Line 1478: fnd_log.STRING (fnd_log.level_statement,

1474: p_note_type => 'OKS_ADMIN');
1475:
1476: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1477: THEN
1478: fnd_log.STRING (fnd_log.level_statement,
1479: g_module ||
1480: l_api_name,
1481: '216:l_jtf_note_id after calling JTF_NOTES_PUB.CREATE_NOTE: ' ||p_chr_id||': '||l_jtf_note_id);
1482: fnd_log.STRING (fnd_log.level_statement,

Line 1482: fnd_log.STRING (fnd_log.level_statement,

1478: fnd_log.STRING (fnd_log.level_statement,
1479: g_module ||
1480: l_api_name,
1481: '216:l_jtf_note_id after calling JTF_NOTES_PUB.CREATE_NOTE: ' ||p_chr_id||': '||l_jtf_note_id);
1482: fnd_log.STRING (fnd_log.level_statement,
1483: g_module ||
1484: l_api_name,
1485: '217:x_return_status after calling JTF_NOTES_PUB.CREATE_NOTE: ' ||p_chr_id||': '||x_return_status);
1486: fnd_log.STRING (fnd_log.level_statement,

Line 1486: fnd_log.STRING (fnd_log.level_statement,

1482: fnd_log.STRING (fnd_log.level_statement,
1483: g_module ||
1484: l_api_name,
1485: '217:x_return_status after calling JTF_NOTES_PUB.CREATE_NOTE: ' ||p_chr_id||': '||x_return_status);
1486: fnd_log.STRING (fnd_log.level_statement,
1487: g_module ||
1488: l_api_name,
1489: '218:x_msg_data after calling JTF_NOTES_PUB.CREATE_NOTE for ' ||p_chr_id||': '||x_msg_data);
1490: fnd_log.STRING (fnd_log.level_statement,

Line 1490: fnd_log.STRING (fnd_log.level_statement,

1486: fnd_log.STRING (fnd_log.level_statement,
1487: g_module ||
1488: l_api_name,
1489: '218:x_msg_data after calling JTF_NOTES_PUB.CREATE_NOTE for ' ||p_chr_id||': '||x_msg_data);
1490: fnd_log.STRING (fnd_log.level_statement,
1491: g_module ||
1492: l_api_name,
1493: '219:x_msg_count after calling JTF_NOTES_PUB.CREATE_NOTE for ' ||p_chr_id||': '||x_msg_count);
1494: END IF;

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

1517:
1518: --Update Follow Up Action and Date, Forecast Percent and Date
1519: -- if ((p_est_percent IS NOT NULL) OR (p_action IS NOT NULL) ) then
1520:
1521: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1522: THEN
1523: fnd_log.STRING (fnd_log.level_statement,
1524: g_module ||
1525: l_api_name,

Line 1523: fnd_log.STRING (fnd_log.level_statement,

1519: -- if ((p_est_percent IS NOT NULL) OR (p_action IS NOT NULL) ) then
1520:
1521: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1522: THEN
1523: fnd_log.STRING (fnd_log.level_statement,
1524: g_module ||
1525: l_api_name,
1526: '220:Now Updating Follow Up Action and Date, Forecast Percent and Date in oks_k_headers_b');
1527: END IF;

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

1549: l_sql_err := SQLERRM;
1550: fnd_message.set_name('OKS','OKS_FOREACST_FOLLOWUP_ERROR');
1551: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1552:
1553: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1554: THEN
1555: fnd_log.STRING (fnd_log.level_statement,
1556: g_module ||
1557: l_api_name,

Line 1555: fnd_log.STRING (fnd_log.level_statement,

1551: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1552:
1553: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1554: THEN
1555: fnd_log.STRING (fnd_log.level_statement,
1556: g_module ||
1557: l_api_name,
1558: '221a:Forecast and Follow Up update failed - l_sql_err:'||l_sql_err);
1559: END IF;

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

1561: x_msg_data:= fnd_message.get;
1562: x_return_status := g_ret_sts_error;
1563: x_msg_count := 1;
1564: end if;
1565: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1566: THEN
1567: fnd_log.STRING (fnd_log.level_statement,
1568: g_module ||
1569: l_api_name,

Line 1567: fnd_log.STRING (fnd_log.level_statement,

1563: x_msg_count := 1;
1564: end if;
1565: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1566: THEN
1567: fnd_log.STRING (fnd_log.level_statement,
1568: g_module ||
1569: l_api_name,
1570: '221:Inside Update Follow Up and Forecast part - x_return_status:'||x_return_status);
1571: END IF;

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

1580: end if;--end Update Follow Up Action and Date
1581:
1582: --Update minor version
1583: if (l_minor_version_updated = 'F') THEN
1584: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1585: THEN
1586: fnd_log.STRING (fnd_log.level_statement,
1587: g_module ||
1588: l_api_name,

Line 1586: fnd_log.STRING (fnd_log.level_statement,

1582: --Update minor version
1583: if (l_minor_version_updated = 'F') THEN
1584: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1585: THEN
1586: fnd_log.STRING (fnd_log.level_statement,
1587: g_module ||
1588: l_api_name,
1589: '224:Now Updating minor_version in okc_k_vers_numbers');
1590: END IF;

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

1601: l_sql_err := SQLERRM;
1602: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1603: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1604:
1605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1606: THEN
1607: fnd_log.STRING (fnd_log.level_statement,
1608: g_module ||
1609: l_api_name,

Line 1607: fnd_log.STRING (fnd_log.level_statement,

1603: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1604:
1605: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1606: THEN
1607: fnd_log.STRING (fnd_log.level_statement,
1608: g_module ||
1609: l_api_name,
1610: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1611: END IF;

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

1620: l_sql_err := SQLERRM;
1621: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1622: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1625: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1626: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1627: END IF;
1628:

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

1621: fnd_message.set_name('OKS','OKS_K_VERSION_UPD_FAILED');
1622: fnd_message.set_token ('ERROR_MESSAGE', l_sql_err);
1623:
1624: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1625: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1626: '225a:Follow Up update failed - l_sql_err:'||l_sql_err);
1627: END IF;
1628:
1629: x_msg_data:= fnd_message.get;

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

1631: x_msg_count := 1;
1632: END IF;
1633:
1634:
1635: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1636: THEN
1637: fnd_log.STRING (fnd_log.level_statement,
1638: g_module ||
1639: l_api_name,

Line 1637: fnd_log.STRING (fnd_log.level_statement,

1633:
1634:
1635: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1636: THEN
1637: fnd_log.STRING (fnd_log.level_statement,
1638: g_module ||
1639: l_api_name,
1640: '225:Inside Update minor version part - x_return_status:'||x_return_status);
1641: END IF;

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

1649: end if;--end update minor version
1650:
1651: commit work;
1652:
1653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1654: THEN
1655: fnd_log.STRING (fnd_log.level_statement,
1656: g_module ||
1657: l_api_name,

Line 1655: fnd_log.STRING (fnd_log.level_statement,

1651: commit work;
1652:
1653: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1654: THEN
1655: fnd_log.STRING (fnd_log.level_statement,
1656: g_module ||
1657: l_api_name,
1658: '226:Changes commited');
1659: fnd_log.STRING (fnd_log.level_statement,

Line 1659: fnd_log.STRING (fnd_log.level_statement,

1655: fnd_log.STRING (fnd_log.level_statement,
1656: g_module ||
1657: l_api_name,
1658: '226:Changes commited');
1659: fnd_log.STRING (fnd_log.level_statement,
1660: g_module ||
1661: l_api_name,
1662: '227:Final x_return_status:'||x_return_status);
1663: END IF;

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

1666: EXCEPTION
1667: WHEN fnd_api.g_exc_error THEN
1668: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1669:
1670: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1671: fnd_log.STRING (fnd_log.level_statement,
1672: g_module ||
1673: l_api_name,
1674: '2000: Leaving ' ||

Line 1671: fnd_log.STRING (fnd_log.level_statement,

1667: WHEN fnd_api.g_exc_error THEN
1668: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1669:
1670: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1671: fnd_log.STRING (fnd_log.level_statement,
1672: g_module ||
1673: l_api_name,
1674: '2000: Leaving ' ||
1675: g_pkg_name ||

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

1686: );
1687: WHEN fnd_api.g_exc_unexpected_error THEN
1688: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1689:
1690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1691: fnd_log.STRING (fnd_log.level_statement,
1692: g_module ||
1693: l_api_name,
1694: '3000: Leaving ' ||

Line 1691: fnd_log.STRING (fnd_log.level_statement,

1687: WHEN fnd_api.g_exc_unexpected_error THEN
1688: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1689:
1690: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1691: fnd_log.STRING (fnd_log.level_statement,
1692: g_module ||
1693: l_api_name,
1694: '3000: Leaving ' ||
1695: g_pkg_name ||

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

1707:
1708: WHEN OTHERS THEN
1709: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1710:
1711: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1712: THEN
1713: fnd_log.STRING (fnd_log.level_statement,
1714: g_module ||
1715: l_api_name,

Line 1713: fnd_log.STRING (fnd_log.level_statement,

1709: DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name);
1710:
1711: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1712: THEN
1713: fnd_log.STRING (fnd_log.level_statement,
1714: g_module ||
1715: l_api_name,
1716: 'Leaving ' ||
1717: g_pkg_name ||