eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_SEARCH_UTIL_PVT dependencies on FND_LOG

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

94:
95: l_api_name := 'get_rep_doc_acl';
96:
97: -- Do logging.
98: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
99: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
100: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
101: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_doc_acl');
102: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

Line 99: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

95: l_api_name := 'get_rep_doc_acl';
96:
97: -- Do logging.
98: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
99: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
100: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
101: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_doc_acl');
102: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
103: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

Line 102: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

98: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
99: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
100: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
101: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_doc_acl');
102: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
103: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
104: '201: Contract Id is: ' || to_char(p_bus_doc_id));
105: END IF;
106: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 106: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

102: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
103: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
104: '201: Contract Id is: ' || to_char(p_bus_doc_id));
105: END IF;
106: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
107: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
108: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
109: 'Input parameters are: p_bus_doc_id = ' || p_bus_doc_id ||
110: ', p_bus_doc_version = ' || p_bus_doc_version ||

Line 107: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

103: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
104: '201: Contract Id is: ' || to_char(p_bus_doc_id));
105: END IF;
106: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
107: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
108: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
109: 'Input parameters are: p_bus_doc_id = ' || p_bus_doc_id ||
110: ', p_bus_doc_version = ' || p_bus_doc_version ||
111: ', p_driving_table = ' || p_driving_table ||

Line 171: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

167: END LOOP;
168: END IF;
169:
170: -- Do logging.
171: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
172: THEN
173: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
174: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
175: 'OKC_REP_UTIL_PVT.get_rep_doc_acl

Line 173: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

169:
170: -- Do logging.
171: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
172: THEN
173: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
174: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
175: 'OKC_REP_UTIL_PVT.get_rep_doc_acl
176: returns x_acl as : '
177: || x_acl);

Line 178: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

174: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
175: 'OKC_REP_UTIL_PVT.get_rep_doc_acl
176: returns x_acl as : '
177: || x_acl);
178: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
179: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
180: 'Leaving get_rep_doc_acl');
181: END IF;
182:

Line 186: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

182:
183: EXCEPTION
184: WHEN OTHERS
185: THEN
186: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
187: THEN
188: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
189: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'
190: ||l_api_name,

Line 188: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

184: WHEN OTHERS
185: THEN
186: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
187: THEN
188: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
189: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'
190: ||l_api_name,
191: 'Leaving PROCEDURE get_rep_doc_acl
192: because of EXCEPTION: '

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

245: BEGIN
246: l_api_name := 'get_current_user_acl_keys';
247:
248: -- Do logging.
249: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
251: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
252: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_acl_keys');
253: END IF;

Line 250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

246: l_api_name := 'get_current_user_acl_keys';
247:
248: -- Do logging.
249: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
250: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
251: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
252: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_acl_keys');
253: END IF;
254:

Line 288: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

284:
285: END IF;
286:
287: -- Do logging.
288: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
289: THEN
290: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
291: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
292: 'OKC_REP_UTIL_PVT.get_current_user_acl_keys

Line 290: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

286:
287: -- Do logging.
288: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
289: THEN
290: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
291: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
292: 'OKC_REP_UTIL_PVT.get_current_user_acl_keys
293: returns x_keys as : '
294: || x_keys);

Line 295: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

291: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
292: 'OKC_REP_UTIL_PVT.get_current_user_acl_keys
293: returns x_keys as : '
294: || x_keys);
295: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
296: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
297: 'Leaving get_current_user_acl_keys');
298: END IF;
299:

Line 303: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

299:
300: EXCEPTION
301: WHEN OTHERS
302: THEN
303: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
304: THEN
305: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
306: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'
307: ||l_api_name,

Line 305: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

301: WHEN OTHERS
302: THEN
303: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
304: THEN
305: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
306: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'
307: ||l_api_name,
308: 'Leaving PROCEDURE get_current_user_acl_keys
309: because of EXCEPTION: '

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

356:
357: l_api_name := 'get_current_user_moac_keys';
358:
359: -- Do logging.
360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
361: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
362: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
363: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_moac_keys');
364: END IF;

Line 361: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

357: l_api_name := 'get_current_user_moac_keys';
358:
359: -- Do logging.
360: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
361: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
362: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
363: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_moac_keys');
364: END IF;
365:

Line 400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

396: END LOOP;
397: END IF;
398:
399: -- Do logging.
400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
401: THEN
402: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
403: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
404: 'OKC_REP_UTIL_PVT.get_current_user_moac_keys

Line 402: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

398:
399: -- Do logging.
400: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
401: THEN
402: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
403: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
404: 'OKC_REP_UTIL_PVT.get_current_user_moac_keys
405: returns x_keys as : '
406: || x_keys);

Line 407: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

403: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
404: 'OKC_REP_UTIL_PVT.get_current_user_moac_keys
405: returns x_keys as : '
406: || x_keys);
407: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
408: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
409: 'Leaving get_current_user_moac_keys');
410: END IF;
411:

Line 415: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

411:
412: EXCEPTION
413: WHEN OTHERS
414: THEN
415: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
416: THEN
417: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
418: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
419: 'Leaving PROCEDURE get_current_user_moac_keys because of

Line 417: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

413: WHEN OTHERS
414: THEN
415: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
416: THEN
417: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
418: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
419: 'Leaving PROCEDURE get_current_user_moac_keys because of
420: EXCEPTION: '||sqlerrm);
421: END IF;

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

460:
461: l_api_name := 'get_intent_profile_keys';
462:
463: -- Do logging.
464: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
466: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
467: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_intent_profile_keys');
468: END IF;

Line 465: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

461: l_api_name := 'get_intent_profile_keys';
462:
463: -- Do logging.
464: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
466: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
467: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_intent_profile_keys');
468: END IF;
469:

Line 480: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

476: -- 2. Create a space-separated string of intent codes from step 1.
477: -- Will do this in the Java level.
478:
479: -- Do logging.
480: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
481: THEN
482: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
483: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
484: 'OKC_REP_UTIL_PVT.get_intent_profile_keys

Line 482: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

478:
479: -- Do logging.
480: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
481: THEN
482: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
483: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
484: 'OKC_REP_UTIL_PVT.get_intent_profile_keys
485: returns x_keys as : '
486: || x_keys);

Line 487: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

483: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
484: 'OKC_REP_UTIL_PVT.get_intent_profile_keys
485: returns x_keys as : '
486: || x_keys);
487: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
488: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
489: 'Leaving get_intent_profile_keys');
490: END IF;
491:

Line 495: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

491:
492: EXCEPTION
493: WHEN OTHERS
494: THEN
495: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
496: THEN
497: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
498: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
499: 'Leaving PROCEDURE get_current_intent_profile_keys

Line 497: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,

493: WHEN OTHERS
494: THEN
495: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
496: THEN
497: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
498: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
499: 'Leaving PROCEDURE get_current_intent_profile_keys
500: because of EXCEPTION: '||sqlerrm);
501: END IF;

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

537:
538: l_api_name := 'get_current_user_quote_access';
539:
540: -- Do logging.
541: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
543: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
544: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_quote_access');
545: END IF;

Line 542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

538: l_api_name := 'get_current_user_quote_access';
539:
540: -- Do logging.
541: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
543: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
544: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_quote_access');
545: END IF;
546: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 546: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

542: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
543: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
544: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_quote_access');
545: END IF;
546: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
548: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
549: 'Input parameter is: p_quote_number = ' || p_quote_number||
550: '.');

Line 547: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

543: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
544: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_quote_access');
545: END IF;
546: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
548: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
549: 'Input parameter is: p_quote_number = ' || p_quote_number||
550: '.');
551: END IF;

Line 577: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

573: END IF;
574: END IF;
575:
576: -- Do logging.
577: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
578: THEN
579: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
580: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
581: 'OKC_REP_UTIL_PVT.get_current_user_quote_access

Line 579: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

575:
576: -- Do logging.
577: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
578: THEN
579: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
580: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
581: 'OKC_REP_UTIL_PVT.get_current_user_quote_access
582: returns x_access as : '
583: || x_access);

Line 584: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

580: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
581: 'OKC_REP_UTIL_PVT.get_current_user_quote_access
582: returns x_access as : '
583: || x_access);
584: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
585: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
586: 'Leaving get_current_user_quote_access');
587: END IF;
588:

Line 592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

588:
589: EXCEPTION
590: WHEN OTHERS
591: THEN
592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
593: THEN
594: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
595: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
596: 'Leaving PROCEDURE get_current_user_quote_access

Line 594: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

590: WHEN OTHERS
591: THEN
592: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
593: THEN
594: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
595: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
596: 'Leaving PROCEDURE get_current_user_quote_access
597: because of EXCEPTION: '||sqlerrm);
598: END IF;

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

645:
646: l_api_name := 'get_local_language_attributes';
647:
648: -- Do logging.
649: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
651: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
652: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_local_language_attributes');
653: END IF;

Line 650: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

646: l_api_name := 'get_local_language_attributes';
647:
648: -- Do logging.
649: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
651: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
652: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_local_language_attributes');
653: END IF;
654: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

650: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
651: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
652: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_local_language_attributes');
653: END IF;
654: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
655: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
656: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
657: 'Input parameters are: p_doc_type_code = ' || p_doc_type_code ||
658: ', p_intent_code = ' || p_intent_code ||

Line 655: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

651: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
652: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_local_language_attributes');
653: END IF;
654: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
655: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
656: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
657: 'Input parameters are: p_doc_type_code = ' || p_doc_type_code ||
658: ', p_intent_code = ' || p_intent_code ||
659: ', p_status_code = ' || p_status_code ||

Line 783: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

779: -- Append the status to the attribute list.
780: x_attrs := x_attrs || l_status;
781:
782: -- Do logging.
783: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
784: THEN
785: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
786: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
787: 'OKC_REP_UTIL_PVT.get_local_language_attributes

Line 785: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

781:
782: -- Do logging.
783: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
784: THEN
785: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
786: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
787: 'OKC_REP_UTIL_PVT.get_local_language_attributes
788: returns x_attrs as : '
789: || x_attrs);

Line 790: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

786: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
787: 'OKC_REP_UTIL_PVT.get_local_language_attributes
788: returns x_attrs as : '
789: || x_attrs);
790: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
791: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
792: 'Leaving get_local_language_attributes');
793: END IF;
794:

Line 798: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

794:
795: EXCEPTION
796: WHEN OTHERS
797: THEN
798: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
799: THEN
800: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED,
801: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
802: 'Leaving PROCEDURE get_local_language_attributes

Line 800: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED,

796: WHEN OTHERS
797: THEN
798: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
799: THEN
800: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED,
801: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
802: 'Leaving PROCEDURE get_local_language_attributes
803: because of EXCEPTION: '||sqlerrm);
804: END IF;

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

848:
849: l_api_name := 'get_rep_parties';
850:
851: -- Do logging.
852: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
853: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
854: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
855: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_parties');
856: END IF;

Line 853: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

849: l_api_name := 'get_rep_parties';
850:
851: -- Do logging.
852: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
853: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
854: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
855: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_parties');
856: END IF;
857: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 857: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

853: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
854: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
855: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_parties');
856: END IF;
857: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
858: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
859: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
860: 'Input parameter is: p_contract_id = ' || p_contract_id||
861: '.');

Line 858: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

854: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
855: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_parties');
856: END IF;
857: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
858: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
859: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
860: 'Input parameter is: p_contract_id = ' || p_contract_id||
861: '.');
862: END IF;

Line 901: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

897:
898: END LOOP;
899:
900: -- Do logging.
901: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
902: THEN
903: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
904: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
905: 'OKC_REP_UTIL_PVT.get_rep_parties returns l_parties as : '

Line 903: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

899:
900: -- Do logging.
901: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
902: THEN
903: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
904: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
905: 'OKC_REP_UTIL_PVT.get_rep_parties returns l_parties as : '
906: || l_parties);
907: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 907: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

903: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
904: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
905: 'OKC_REP_UTIL_PVT.get_rep_parties returns l_parties as : '
906: || l_parties);
907: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
908: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
909: 'Leaving get_rep_parties');
910: END IF;
911:

Line 917: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

913:
914: EXCEPTION
915: WHEN OTHERS
916: THEN
917: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
918: THEN
919: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
920: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
921: 'Leaving PROCEDURE get_rep_parties

Line 919: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

915: WHEN OTHERS
916: THEN
917: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
918: THEN
919: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
920: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
921: 'Leaving PROCEDURE get_rep_parties
922: because of EXCEPTION: '||sqlerrm);
923: END IF;

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

959:
960: l_api_name := 'get_terms_last_update_date';
961: l_has_access := 'N';
962:
963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
965: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Document Id is: ' || p_document_id);

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

960: l_api_name := 'get_terms_last_update_date';
961: l_has_access := 'N';
962:
963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
965: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Document Id is: ' || p_document_id);
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

962:
963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
965: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Document Id is: ' || p_document_id);
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: 'Document Type is: ' || p_document_type);
970: END IF;

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

964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
965: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
967: 'Document Id is: ' || p_document_id);
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: 'Document Type is: ' || p_document_type);
970: END IF;
971: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
972: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 971: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

967: 'Document Id is: ' || p_document_id);
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: 'Document Type is: ' || p_document_type);
970: END IF;
971: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
972: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
973: 'Calling OKC_TERMS_UTIL_GRP.Get_Last_Update_Date');
974: END IF;
975: --- Call OKC_TERMS_UTIL_GRP.Get_Last_Update_Date procedure.

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

968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: 'Document Type is: ' || p_document_type);
970: END IF;
971: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
972: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
973: 'Calling OKC_TERMS_UTIL_GRP.Get_Last_Update_Date');
974: END IF;
975: --- Call OKC_TERMS_UTIL_GRP.Get_Last_Update_Date procedure.
976:

Line 988: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

984: p_doc_id => p_document_id,
985: x_deliverable_changed_date => l_deliverable_changed_date,
986: x_terms_changed_date => l_terms_changed_date
987: );
988: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
989: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
990: 'OKC_TERMS_UTIL_GRP.Get_Last_Update_Date return status is: '
991: || l_return_status);
992: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

985: x_deliverable_changed_date => l_deliverable_changed_date,
986: x_terms_changed_date => l_terms_changed_date
987: );
988: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
989: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
990: 'OKC_TERMS_UTIL_GRP.Get_Last_Update_Date return status is: '
991: || l_return_status);
992: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
993: 'OKC_REP_UTIL_PVT.Get_Last_Update_Date returns x_terms_changed_date as : '

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

988: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
989: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
990: 'OKC_TERMS_UTIL_GRP.Get_Last_Update_Date return status is: '
991: || l_return_status);
992: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
993: 'OKC_REP_UTIL_PVT.Get_Last_Update_Date returns x_terms_changed_date as : '
994: || l_terms_changed_date);
995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
996: 'Leaving Function get_terms_last_update_date');

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

991: || l_return_status);
992: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
993: 'OKC_REP_UTIL_PVT.Get_Last_Update_Date returns x_terms_changed_date as : '
994: || l_terms_changed_date);
995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
996: 'Leaving Function get_terms_last_update_date');
997: END IF;
998: RETURN l_terms_changed_date ;
999:

Line 1002: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

998: RETURN l_terms_changed_date ;
999:
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1003: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1004: 'Leaving Function get_terms_last_update_date because of EXCEPTION: '||sqlerrm);
1005: END IF;
1006: Okc_Api.Set_Message(p_app_name => 'OKC',

Line 1003: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,

999:
1000: EXCEPTION
1001: WHEN OTHERS THEN
1002: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1003: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1004: 'Leaving Function get_terms_last_update_date because of EXCEPTION: '||sqlerrm);
1005: END IF;
1006: Okc_Api.Set_Message(p_app_name => 'OKC',
1007: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

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

1062: l_api_name := 'draft_attachment_exists';
1063: l_results := 'N';
1064: l_attachment_exists := 'N';
1065:
1066: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1068: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.draft_attachment_exists');
1069: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1070: 'Document Id is: ' || p_document_id);

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

1063: l_results := 'N';
1064: l_attachment_exists := 'N';
1065:
1066: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1068: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.draft_attachment_exists');
1069: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1070: 'Document Id is: ' || p_document_id);
1071: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1065:
1066: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1067: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1068: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.draft_attachment_exists');
1069: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1070: 'Document Id is: ' || p_document_id);
1071: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1072: 'Document Type is: ' || p_document_type);
1073: END IF;

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

1067: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1068: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.draft_attachment_exists');
1069: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1070: 'Document Id is: ' || p_document_id);
1071: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1072: 'Document Type is: ' || p_document_type);
1073: END IF;
1074: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1075: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

Line 1074: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1070: 'Document Id is: ' || p_document_id);
1071: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1072: 'Document Type is: ' || p_document_type);
1073: END IF;
1074: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1075: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1076: 'Calling OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
1077: END IF;
1078: --- Call OKC_REP_SEARCH_UTIL_PVT.Get_Last_Update_Date procedure.

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

1071: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1072: 'Document Type is: ' || p_document_type);
1073: END IF;
1074: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1075: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1076: 'Calling OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
1077: END IF;
1078: --- Call OKC_REP_SEARCH_UTIL_PVT.Get_Last_Update_Date procedure.
1079:

Line 1094: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1090: END IF;
1091:
1092: CLOSE draft_attachment_csr;
1093:
1094: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1095: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1096: 'l_terms_changed_date: ' || l_terms_changed_date);
1097: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1098: 'l_attachment_last_update_date: ' || l_attachment_last_update_date);

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

1091:
1092: CLOSE draft_attachment_csr;
1093:
1094: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1095: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1096: 'l_terms_changed_date: ' || l_terms_changed_date);
1097: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1098: 'l_attachment_last_update_date: ' || l_attachment_last_update_date);
1099: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

1093:
1094: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1095: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1096: 'l_terms_changed_date: ' || l_terms_changed_date);
1097: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1098: 'l_attachment_last_update_date: ' || l_attachment_last_update_date);
1099: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1100: 'l_attachment_exists: ' || l_attachment_exists);
1101: END IF;

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

1095: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1096: 'l_terms_changed_date: ' || l_terms_changed_date);
1097: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1098: 'l_attachment_last_update_date: ' || l_attachment_last_update_date);
1099: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1100: 'l_attachment_exists: ' || l_attachment_exists);
1101: END IF;
1102:
1103: IF ((l_attachment_exists = 'N') OR (l_attachment_last_update_date < l_terms_changed_date))THEN

Line 1113: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1109: RETURN l_results;
1110:
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1114: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1115: 'Leaving Function draft_attachment_exists because of EXCEPTION: '||sqlerrm);
1116: END IF;
1117: IF (draft_attachment_csr%ISOPEN) THEN

Line 1114: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,

1110:
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1114: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1115: 'Leaving Function draft_attachment_exists because of EXCEPTION: '||sqlerrm);
1116: END IF;
1117: IF (draft_attachment_csr%ISOPEN) THEN
1118: CLOSE draft_attachment_csr ;

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

1192: l_api_name := 'is_contract_status_draft';
1193: l_has_access := 'N';
1194: l_results := 'N';
1195:
1196: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1197: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1198: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.is_contract_status_draft');
1199: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1200: 'Document Id is: ' || p_document_id);

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

1193: l_has_access := 'N';
1194: l_results := 'N';
1195:
1196: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1197: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1198: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.is_contract_status_draft');
1199: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1200: 'Document Id is: ' || p_document_id);
1201: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

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

1195:
1196: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1197: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1198: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.is_contract_status_draft');
1199: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1200: 'Document Id is: ' || p_document_id);
1201: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1202: 'Document Type is: ' || p_document_type);
1203: END IF;

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

1197: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1198: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.is_contract_status_draft');
1199: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1200: 'Document Id is: ' || p_document_id);
1201: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1202: 'Document Type is: ' || p_document_type);
1203: END IF;
1204: IF (SubStr(p_document_type,1,3) = 'REP') THEN
1205: OPEN rep_status_csr;

Line 1207: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1203: END IF;
1204: IF (SubStr(p_document_type,1,3) = 'REP') THEN
1205: OPEN rep_status_csr;
1206: FETCH rep_status_csr INTO l_contract_status_code;
1207: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1208: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1209: 'Repository doc type, l_contract_status_code: ' || l_contract_status_code);
1210: END IF;
1211: IF ( (l_contract_status_code = 'DRAFT') OR

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

1204: IF (SubStr(p_document_type,1,3) = 'REP') THEN
1205: OPEN rep_status_csr;
1206: FETCH rep_status_csr INTO l_contract_status_code;
1207: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1208: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1209: 'Repository doc type, l_contract_status_code: ' || l_contract_status_code);
1210: END IF;
1211: IF ( (l_contract_status_code = 'DRAFT') OR
1212: (l_contract_status_code = 'REJECTED') OR

Line 1224: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1220: ELSIF ((p_document_type='PA_BLANKET') OR (p_document_type='PA_CONTRACT')
1221: OR (p_document_type='PO_STANDARD')) THEN
1222: OPEN po_status_csr;
1223: FETCH po_status_csr INTO l_contract_status_code;
1224: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1225: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1226: 'PO doc type, l_contract_status_code: ' || l_contract_status_code);
1227: END IF;
1228: IF ( (l_contract_status_code = 'IN PROCESS') OR

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

1221: OR (p_document_type='PO_STANDARD')) THEN
1222: OPEN po_status_csr;
1223: FETCH po_status_csr INTO l_contract_status_code;
1224: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1225: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1226: 'PO doc type, l_contract_status_code: ' || l_contract_status_code);
1227: END IF;
1228: IF ( (l_contract_status_code = 'IN PROCESS') OR
1229: (l_contract_status_code = 'INCOMPLETE') OR

Line 1243: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1239: ELSIF ((p_document_type='RFI') OR (p_document_type='RFQ')
1240: OR (p_document_type='AUCTION')) THEN
1241: OPEN neg_status_csr;
1242: FETCH neg_status_csr INTO l_contract_status_code;
1243: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1244: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1245: 'Negotiation doc type, l_contract_status_code: ' || l_contract_status_code);
1246: END IF;
1247: IF ( (l_contract_status_code = 'ACTIVE') OR

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

1240: OR (p_document_type='AUCTION')) THEN
1241: OPEN neg_status_csr;
1242: FETCH neg_status_csr INTO l_contract_status_code;
1243: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1244: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1245: 'Negotiation doc type, l_contract_status_code: ' || l_contract_status_code);
1246: END IF;
1247: IF ( (l_contract_status_code = 'ACTIVE') OR
1248: (l_contract_status_code = 'AWARD_APPROVAL_INPROCESS') OR

Line 1265: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1261: CLOSE neg_status_csr;
1262: ELSIF (p_document_type='QUOTE') THEN
1263: OPEN quote_status_csr;
1264: FETCH quote_status_csr INTO l_contract_status_code;
1265: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1266: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1267: 'Sales Quote doc type, l_contract_status_code: ' || l_contract_status_code);
1268: END IF;
1269: IF ( (l_contract_status_code = 'APPROVAL CANCELED') OR

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

1262: ELSIF (p_document_type='QUOTE') THEN
1263: OPEN quote_status_csr;
1264: FETCH quote_status_csr INTO l_contract_status_code;
1265: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1266: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1267: 'Sales Quote doc type, l_contract_status_code: ' || l_contract_status_code);
1268: END IF;
1269: IF ( (l_contract_status_code = 'APPROVAL CANCELED') OR
1270: (l_contract_status_code = 'APPROVAL PENDING') OR

Line 1286: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1282: CLOSE quote_status_csr;
1283: ELSIF (p_document_type='B') THEN
1284: OPEN bsa_status_csr;
1285: FETCH bsa_status_csr INTO l_contract_status_code;
1286: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1287: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1288: 'Sales Agreement doc type, l_contract_status_code: ' || l_contract_status_code);
1289: END IF;
1290:

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

1283: ELSIF (p_document_type='B') THEN
1284: OPEN bsa_status_csr;
1285: FETCH bsa_status_csr INTO l_contract_status_code;
1286: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1287: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1288: 'Sales Agreement doc type, l_contract_status_code: ' || l_contract_status_code);
1289: END IF;
1290:
1291: IF ( (l_contract_status_code= 'DRAFT') OR

Line 1306: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1302: CLOSE bsa_status_csr;
1303: ELSIF (p_document_type='O') THEN
1304: OPEN so_status_csr;
1305: FETCH so_status_csr INTO l_contract_status_code;
1306: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1307: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1308: 'Sale Order doc type, l_contract_status_code: ' || l_contract_status_code);
1309: END IF;
1310: IF ( (l_contract_status_code = 'DRAFT') OR

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

1303: ELSIF (p_document_type='O') THEN
1304: OPEN so_status_csr;
1305: FETCH so_status_csr INTO l_contract_status_code;
1306: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1307: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1308: 'Sale Order doc type, l_contract_status_code: ' || l_contract_status_code);
1309: END IF;
1310: IF ( (l_contract_status_code = 'DRAFT') OR
1311: (l_contract_status_code = 'DRAFT_CUSTOMER_REJECTED') OR

Line 1324: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1320: CLOSE so_status_csr;
1321: END IF; -- p_document_type like '%tmp_txt_search_draft'
1322:
1323:
1324: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1326: 'l_results: ' || l_results);
1327: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1328: 'Exiting is_contract_status_draft');

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

1321: END IF; -- p_document_type like '%tmp_txt_search_draft'
1322:
1323:
1324: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1326: 'l_results: ' || l_results);
1327: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1328: 'Exiting is_contract_status_draft');
1329: END IF;

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

1323:
1324: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1325: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1326: 'l_results: ' || l_results);
1327: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1328: 'Exiting is_contract_status_draft');
1329: END IF;
1330:
1331: RETURN l_results;

Line 1335: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1331: RETURN l_results;
1332:
1333: EXCEPTION
1334: WHEN OTHERS THEN
1335: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1336: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1337: 'Leaving Function is_contract_status_draft because of EXCEPTION: '||sqlerrm);
1338: END IF;
1339: IF (rep_status_csr%ISOPEN) THEN

Line 1336: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,

1332:
1333: EXCEPTION
1334: WHEN OTHERS THEN
1335: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1336: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1337: 'Leaving Function is_contract_status_draft because of EXCEPTION: '||sqlerrm);
1338: END IF;
1339: IF (rep_status_csr%ISOPEN) THEN
1340: CLOSE rep_status_csr ;

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

1403:
1404: l_api_name := 'get_neg_parties';
1405:
1406: -- Do logging.
1407: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1408: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
1409: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1410: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_neg_parties');
1411: END IF;

Line 1408: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

1404: l_api_name := 'get_neg_parties';
1405:
1406: -- Do logging.
1407: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1408: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
1409: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1410: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_neg_parties');
1411: END IF;
1412: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1412: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1408: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
1409: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1410: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_neg_parties');
1411: END IF;
1412: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1413: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1414: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1415: 'Input parameter is: p_auction_header_id = ' || p_auction_header_id||
1416: '.');

Line 1413: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

1409: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1410: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_neg_parties');
1411: END IF;
1412: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1413: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1414: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1415: 'Input parameter is: p_auction_header_id = ' || p_auction_header_id||
1416: '.');
1417: END IF;

Line 1424: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1420: l_parties := l_parties || party_rec.vendor_name || ' ';
1421: END LOOP;
1422:
1423: -- Do logging.
1424: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1425: THEN
1426: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1427: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1428: 'OKC_REP_UTIL_PVT.get_neg_parties returns l_parties as : '

Line 1426: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

1422:
1423: -- Do logging.
1424: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1425: THEN
1426: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1427: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1428: 'OKC_REP_UTIL_PVT.get_neg_parties returns l_parties as : '
1429: || l_parties);
1430: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 1430: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

1426: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1427: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1428: 'OKC_REP_UTIL_PVT.get_neg_parties returns l_parties as : '
1429: || l_parties);
1430: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1431: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1432: 'Leaving get_neg_parties');
1433: END IF;
1434:

Line 1440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1436:
1437: EXCEPTION
1438: WHEN OTHERS
1439: THEN
1440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1441: THEN
1442: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1443: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1444: 'Leaving PROCEDURE get_neg_parties

Line 1442: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1438: WHEN OTHERS
1439: THEN
1440: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1441: THEN
1442: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1443: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1444: 'Leaving PROCEDURE get_neg_parties
1445: because of EXCEPTION: '||sqlerrm);
1446: END IF;