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.4 2012/01/06 06:27:14 vechittu 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 297: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

293: -- Do logging.
294: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
295: THEN
296: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
297: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
298: 'OKC_REP_UTIL_PVT.get_current_user_acl_keys
299: returns x_keys as : '
300: || x_keys);
301: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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

298: 'OKC_REP_UTIL_PVT.get_current_user_acl_keys
299: returns x_keys as : '
300: || x_keys);
301: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
302: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
303: 'Leaving get_current_user_acl_keys');
304: END IF;
305:
306: EXCEPTION

Line 312: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'

308: THEN
309: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
310: THEN
311: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
312: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'
313: ||l_api_name,
314: 'Leaving PROCEDURE get_current_user_acl_keys
315: because of EXCEPTION: '
316: ||sqlerrm);

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

364:
365: -- Do logging.
366: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
367: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
368: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
369: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_moac_keys');
370: END IF;
371:
372: l_user_id := FND_GLOBAL.user_id;

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

365: -- Do logging.
366: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
367: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
368: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
369: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_moac_keys');
370: END IF;
371:
372: l_user_id := FND_GLOBAL.user_id;
373: l_resp_id := FND_GLOBAL.RESP_ID;

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

405: -- Do logging.
406: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
407: THEN
408: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
409: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
410: 'OKC_REP_UTIL_PVT.get_current_user_moac_keys
411: returns x_keys as : '
412: || x_keys);
413: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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

410: 'OKC_REP_UTIL_PVT.get_current_user_moac_keys
411: returns x_keys as : '
412: || x_keys);
413: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
414: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
415: 'Leaving get_current_user_moac_keys');
416: END IF;
417:
418: EXCEPTION

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

420: THEN
421: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
422: THEN
423: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
424: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
425: 'Leaving PROCEDURE get_current_user_moac_keys because of
426: EXCEPTION: '||sqlerrm);
427: END IF;
428: Okc_Api.Set_Message(p_app_name => 'OKC',

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

468:
469: -- Do logging.
470: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
471: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
472: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
473: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_intent_profile_keys');
474: END IF;
475:
476: -- 1. Call FND_PROFILE.value('OKC_REP_INTENTS') to get the intent

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

469: -- Do logging.
470: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
471: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
472: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
473: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_intent_profile_keys');
474: END IF;
475:
476: -- 1. Call FND_PROFILE.value('OKC_REP_INTENTS') to get the intent
477: -- codes from the FND profile.

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

485: -- Do logging.
486: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
487: THEN
488: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
489: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
490: 'OKC_REP_UTIL_PVT.get_intent_profile_keys
491: returns x_keys as : '
492: || x_keys);
493: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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

490: 'OKC_REP_UTIL_PVT.get_intent_profile_keys
491: returns x_keys as : '
492: || x_keys);
493: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
494: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
495: 'Leaving get_intent_profile_keys');
496: END IF;
497:
498: EXCEPTION

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

500: THEN
501: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
502: THEN
503: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,
504: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
505: 'Leaving PROCEDURE get_current_intent_profile_keys
506: because of EXCEPTION: '||sqlerrm);
507: END IF;
508: Okc_Api.Set_Message(p_app_name => 'OKC',

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

545:
546: -- Do logging.
547: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
549: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
550: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_quote_access');
551: END IF;
552: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
553: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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

546: -- Do logging.
547: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
549: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
550: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_quote_access');
551: END IF;
552: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
553: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
554: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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

550: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_current_user_quote_access');
551: END IF;
552: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
553: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
554: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
555: 'Input parameter is: p_quote_number = ' || p_quote_number||
556: '.');
557: END IF;
558:

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

582: -- Do logging.
583: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
584: THEN
585: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
586: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
587: 'OKC_REP_UTIL_PVT.get_current_user_quote_access
588: returns x_access as : '
589: || x_access);
590: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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

587: 'OKC_REP_UTIL_PVT.get_current_user_quote_access
588: returns x_access as : '
589: || x_access);
590: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
591: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
592: 'Leaving get_current_user_quote_access');
593: END IF;
594:
595: EXCEPTION

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

597: THEN
598: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
599: THEN
600: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
601: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
602: 'Leaving PROCEDURE get_current_user_quote_access
603: because of EXCEPTION: '||sqlerrm);
604: END IF;
605: Okc_Api.Set_Message(p_app_name => 'OKC',

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

653:
654: -- Do logging.
655: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
657: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
658: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_local_language_attributes');
659: END IF;
660: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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

654: -- Do logging.
655: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
657: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
658: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_local_language_attributes');
659: END IF;
660: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
662: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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

658: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_local_language_attributes');
659: END IF;
660: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
661: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
662: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
663: 'Input parameters are: p_doc_type_code = ' || p_doc_type_code ||
664: ', p_intent_code = ' || p_intent_code ||
665: ', p_status_code = ' || p_status_code ||
666: '.');

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

788: -- Do logging.
789: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
790: THEN
791: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
792: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
793: 'OKC_REP_UTIL_PVT.get_local_language_attributes
794: returns x_attrs as : '
795: || x_attrs);
796: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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

793: 'OKC_REP_UTIL_PVT.get_local_language_attributes
794: returns x_attrs as : '
795: || x_attrs);
796: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
797: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
798: 'Leaving get_local_language_attributes');
799: END IF;
800:
801: EXCEPTION

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

803: THEN
804: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
805: THEN
806: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED,
807: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
808: 'Leaving PROCEDURE get_local_language_attributes
809: because of EXCEPTION: '||sqlerrm);
810: END IF;
811: Okc_Api.Set_Message(p_app_name => 'OKC',

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

856:
857: -- Do logging.
858: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
860: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
861: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_parties');
862: END IF;
863: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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

857: -- Do logging.
858: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
859: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
860: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
861: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_parties');
862: END IF;
863: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
865: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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

861: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_rep_parties');
862: END IF;
863: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
864: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
865: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
866: 'Input parameter is: p_contract_id = ' || p_contract_id||
867: '.');
868: END IF;
869:

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

906: -- Do logging.
907: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
908: THEN
909: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
910: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
911: 'OKC_REP_UTIL_PVT.get_rep_parties returns l_parties as : '
912: || l_parties);
913: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
914: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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

910: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
911: 'OKC_REP_UTIL_PVT.get_rep_parties returns l_parties as : '
912: || l_parties);
913: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
914: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
915: 'Leaving get_rep_parties');
916: END IF;
917:
918: RETURN l_parties;

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

922: THEN
923: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
924: THEN
925: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
926: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
927: 'Leaving PROCEDURE get_rep_parties
928: because of EXCEPTION: '||sqlerrm);
929: END IF;
930: Okc_Api.Set_Message(p_app_name => 'OKC',

Line 971: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');

967: l_has_access := 'N';
968:
969: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
970: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
971: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
972: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
973: 'Document Id is: ' || p_document_id);
974: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
975: 'Document Type is: ' || p_document_type);

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

1070: l_attachment_exists := 'N';
1071:
1072: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1073: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1074: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.draft_attachment_exists');
1075: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1076: 'Document Id is: ' || p_document_id);
1077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1078: 'Document Type is: ' || p_document_type);

Line 1082: 'Calling OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');

1078: 'Document Type is: ' || p_document_type);
1079: END IF;
1080: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1081: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1082: 'Calling OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
1083: END IF;
1084: --- Call OKC_REP_SEARCH_UTIL_PVT.Get_Last_Update_Date procedure.
1085:
1086: l_terms_changed_date := OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date(

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

1080: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1081: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1082: 'Calling OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
1083: END IF;
1084: --- Call OKC_REP_SEARCH_UTIL_PVT.Get_Last_Update_Date procedure.
1085:
1086: l_terms_changed_date := OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date(
1087: p_document_type => p_document_type,
1088: p_document_id => p_document_id

Line 1086: l_terms_changed_date := OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date(

1082: 'Calling OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date');
1083: END IF;
1084: --- Call OKC_REP_SEARCH_UTIL_PVT.Get_Last_Update_Date procedure.
1085:
1086: l_terms_changed_date := OKC_REP_SEARCH_UTIL_PVT.get_terms_last_update_date(
1087: p_document_type => p_document_type,
1088: p_document_id => p_document_id
1089: );
1090:

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

1200: l_results := 'N';
1201:
1202: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1203: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1204: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.is_contract_status_draft');
1205: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1206: 'Document Id is: ' || p_document_id);
1207: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1208: 'Document Type is: ' || p_document_type);

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

1417:
1418: -- Do logging.
1419: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
1421: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1422: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_neg_parties');
1423: END IF;
1424: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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

1418: -- Do logging.
1419: IF ( FND_LOG.LEVEL_PROCEDURE>= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
1421: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1422: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_neg_parties');
1423: END IF;
1424: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1426: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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

1422: '200: Entered OKC_REP_SEARCH_UTIL_PVT.get_neg_parties');
1423: END IF;
1424: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1425: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1426: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1427: 'Input parameter is: p_auction_header_id = ' || p_auction_header_id||
1428: '.');
1429: END IF;
1430: FOR party_rec IN party_csr

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

1435: -- Do logging.
1436: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1437: THEN
1438: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1439: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1440: 'OKC_REP_UTIL_PVT.get_neg_parties returns l_parties as : '
1441: || l_parties);
1442: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1443: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,

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

1439: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1440: 'OKC_REP_UTIL_PVT.get_neg_parties returns l_parties as : '
1441: || l_parties);
1442: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,
1443: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1444: 'Leaving get_neg_parties');
1445: END IF;
1446:
1447: RETURN l_parties;

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

1451: THEN
1452: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1453: THEN
1454: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1455: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
1456: 'Leaving PROCEDURE get_neg_parties
1457: because of EXCEPTION: '||sqlerrm);
1458: END IF;
1459: Okc_Api.Set_Message(p_app_name => 'OKC',

Line 1526: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.get_contract_org');

1522: l_api_name := 'get_contract_org';
1523:
1524: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1525: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1526: 'Entered Function OKC_REP_SEARCH_UTIL_PVT.get_contract_org');
1527: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1528: 'Document Id is: ' || p_document_id);
1529: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1530: 'Document Type is: ' || p_document_type);

Line 1632: END OKC_REP_SEARCH_UTIL_PVT;

1628: RETURN -1;
1629: END get_contract_org;
1630:
1631:
1632: END OKC_REP_SEARCH_UTIL_PVT;