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 OKC_REP_SEARCH_UTIL_PVT

Line 1: PACKAGE BODY OKC_REP_SEARCH_UTIL_PVT AS

1: PACKAGE BODY OKC_REP_SEARCH_UTIL_PVT AS
2: /* $Header: OKCVREPSRCHUTILB.pls 120.0.12010000.3 2009/01/08 13:56:27 kkolukul noship $ */
3:
4:
5: ---------------------------------------------------------------------------

Line 100: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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,
104: '201: Contract Id is: ' || to_char(p_bus_doc_id));

Line 101: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_doc_acl');

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,
104: '201: Contract Id is: ' || to_char(p_bus_doc_id));
105: END IF;

Line 103: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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
107: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 108: '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 ||
112: '.');

Line 174: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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);
178: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 179: '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:
183: EXCEPTION

Line 189: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'

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: '
193: ||sqlerrm);

Line 251: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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:
255: -- 1. Add the string 'no_acl' to the ACL keys.

Line 252: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_acl_keys');

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:
255: -- 1. Add the string 'no_acl' to the ACL keys.
256: x_keys := 'no_acl' || ' ';

Line 291: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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);
295: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 296: '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:
300: EXCEPTION

Line 306: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'

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: '
310: ||sqlerrm);

Line 362: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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:
366: l_user_id := FND_GLOBAL.user_id;

Line 363: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_moac_keys');

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:
366: l_user_id := FND_GLOBAL.user_id;
367: l_resp_id := FND_GLOBAL.RESP_ID;

Line 403: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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);
407: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 408: '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:
412: EXCEPTION

Line 418: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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;
422: Okc_Api.Set_Message(p_app_name => 'OKC',

Line 466: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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:
470: -- 1. Call FND_PROFILE.value('OKC_REP_INTENTS') to get the intent

Line 467: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_intent_profile_keys');

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:
470: -- 1. Call FND_PROFILE.value('OKC_REP_INTENTS') to get the intent
471: -- codes from the FND profile.

Line 483: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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);
487: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 488: '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:
492: EXCEPTION

Line 498: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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;
502: Okc_Api.Set_Message(p_app_name => 'OKC',

Line 543: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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
547: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 544: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_quote_access');

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
547: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
548: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

Line 548: '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;
552:

Line 580: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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);
584: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 585: '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:
589: EXCEPTION

Line 595: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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;
599: Okc_Api.Set_Message(p_app_name => 'OKC',

Line 651: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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
655: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 652: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_local_language_attributes');

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
655: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
656: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

Line 656: '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 ||
660: '.');

Line 786: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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);
790: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 791: '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:
795: EXCEPTION

Line 801: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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;
805: Okc_Api.Set_Message(p_app_name => 'OKC',

Line 854: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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
858: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 855: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_parties');

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
858: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
859: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

Line 859: '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;
863:

Line 904: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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 ,
908: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

Line 908: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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:
912: RETURN l_parties;

Line 920: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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;
924: Okc_Api.Set_Message(p_app_name => 'OKC',

Line 965: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.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,
969: 'Document Type is: ' || p_document_type);

Line 1068: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.draft_attachment_exists');

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,
1072: 'Document Type is: ' || p_document_type);

Line 1076: 'Calling OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');

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:
1080: l_terms_changed_date := OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date(

Line 1078: --- Call OKC_REP_SEARCH_UTIL_PVT.Get_Last_Update_Date procedure.

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:
1080: l_terms_changed_date := OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date(
1081: p_document_type => p_document_type,
1082: p_document_id => p_document_id

Line 1080: l_terms_changed_date := OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date(

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:
1080: l_terms_changed_date := OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date(
1081: p_document_type => p_document_type,
1082: p_document_id => p_document_id
1083: );
1084:

Line 1198: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.is_contract_status_draft');

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,
1202: 'Document Type is: ' || p_document_type);

Line 1409: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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
1413: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

Line 1410: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_neg_parties');

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
1413: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1414: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

Line 1414: '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;
1418: FOR party_rec IN party_csr

Line 1427: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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 ,
1431: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

Line 1431: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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:
1435: RETURN l_parties;

Line 1443: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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;
1447: Okc_Api.Set_Message(p_app_name => 'OKC',

Line 1456: END OKC_REP_SEARCH_UTIL_PVT;

1452: p_token2_value => sqlerrm);
1453: END get_neg_parties;
1454:
1455:
1456: END OKC_REP_SEARCH_UTIL_PVT;