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 294: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

290:
291: END IF;
292:
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

Line 296: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

292:
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);

Line 301: 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 ,
302: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
303: 'Leaving get_current_user_acl_keys');
304: END IF;
305:

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

305:
306: EXCEPTION
307: WHEN OTHERS
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,

Line 311: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

307: WHEN OTHERS
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: '

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

362:
363: l_api_name := 'get_current_user_moac_keys';
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;

Line 367: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

363: l_api_name := 'get_current_user_moac_keys';
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:

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

402: END LOOP;
403: END IF;
404:
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

Line 408: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

404:
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);

Line 413: 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 ,
414: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
415: 'Leaving get_current_user_moac_keys');
416: END IF;
417:

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

417:
418: EXCEPTION
419: WHEN OTHERS
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

Line 423: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

419: WHEN OTHERS
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;

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

466:
467: l_api_name := 'get_intent_profile_keys';
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;

Line 471: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

467: l_api_name := 'get_intent_profile_keys';
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:

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

482: -- 2. Create a space-separated string of intent codes from step 1.
483: -- Will do this in the Java level.
484:
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

Line 488: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

484:
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);

Line 493: 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 ,
494: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
495: 'Leaving get_intent_profile_keys');
496: END IF;
497:

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

497:
498: EXCEPTION
499: WHEN OTHERS
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

Line 503: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION,

499: WHEN OTHERS
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;

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

543:
544: l_api_name := 'get_current_user_quote_access';
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;

Line 548: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

544: l_api_name := 'get_current_user_quote_access';
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

Line 552: IF ( FND_LOG.LEVEL_STATEMENT >= 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,
555: 'Input parameter is: p_quote_number = ' || p_quote_number||
556: '.');

Line 553: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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,
555: 'Input parameter is: p_quote_number = ' || p_quote_number||
556: '.');
557: END IF;

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

579: END IF;
580: END IF;
581:
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

Line 585: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

581:
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);

Line 590: 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 ,
591: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
592: 'Leaving get_current_user_quote_access');
593: END IF;
594:

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

594:
595: EXCEPTION
596: WHEN OTHERS
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

Line 600: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

596: WHEN OTHERS
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;

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

651:
652: l_api_name := 'get_local_language_attributes';
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;

Line 656: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

652: l_api_name := 'get_local_language_attributes';
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

Line 660: IF ( FND_LOG.LEVEL_STATEMENT >= 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,
663: 'Input parameters are: p_doc_type_code = ' || p_doc_type_code ||
664: ', p_intent_code = ' || p_intent_code ||

Line 661: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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,
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 ||

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

785: -- Append the status to the attribute list.
786: x_attrs := x_attrs || l_status;
787:
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

Line 791: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

787:
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);

Line 796: 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 ,
797: 'okc.plsql.OKC_REP_SEARCH_UTIL_PVT.'||l_api_name,
798: 'Leaving get_local_language_attributes');
799: END IF;
800:

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

800:
801: EXCEPTION
802: WHEN OTHERS
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

Line 806: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED,

802: WHEN OTHERS
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;

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

854:
855: l_api_name := 'get_rep_parties';
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;

Line 859: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

855: l_api_name := 'get_rep_parties';
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

Line 863: IF ( FND_LOG.LEVEL_STATEMENT >= 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,
866: 'Input parameter is: p_contract_id = ' || p_contract_id||
867: '.');

Line 864: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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,
866: 'Input parameter is: p_contract_id = ' || p_contract_id||
867: '.');
868: END IF;

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

903:
904: END LOOP;
905:
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 : '

Line 909: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

905:
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 ,

Line 913: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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,
915: 'Leaving get_rep_parties');
916: END IF;
917:

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

919:
920: EXCEPTION
921: WHEN OTHERS
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

Line 925: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

921: WHEN OTHERS
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;

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

965:
966: l_api_name := '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);

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

966: l_api_name := '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,

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

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);
976: END IF;

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

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);
976: END IF;
977: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

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);
976: END IF;
977: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
979: 'Calling OKC_TERMS_UTIL_GRP.Get_Last_Update_Date');
980: END IF;
981: --- Call OKC_TERMS_UTIL_GRP.Get_Last_Update_Date procedure.

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

974: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
975: 'Document Type is: ' || p_document_type);
976: END IF;
977: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
978: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
979: 'Calling OKC_TERMS_UTIL_GRP.Get_Last_Update_Date');
980: END IF;
981: --- Call OKC_TERMS_UTIL_GRP.Get_Last_Update_Date procedure.
982:

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

990: p_doc_id => p_document_id,
991: x_deliverable_changed_date => l_deliverable_changed_date,
992: x_terms_changed_date => l_terms_changed_date
993: );
994: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
996: 'OKC_TERMS_UTIL_GRP.Get_Last_Update_Date return status is: '
997: || l_return_status);
998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

991: x_deliverable_changed_date => l_deliverable_changed_date,
992: x_terms_changed_date => l_terms_changed_date
993: );
994: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
996: 'OKC_TERMS_UTIL_GRP.Get_Last_Update_Date return status is: '
997: || l_return_status);
998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
999: 'OKC_REP_UTIL_PVT.Get_Last_Update_Date returns x_terms_changed_date as : '

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

994: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
996: 'OKC_TERMS_UTIL_GRP.Get_Last_Update_Date return status is: '
997: || l_return_status);
998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
999: 'OKC_REP_UTIL_PVT.Get_Last_Update_Date returns x_terms_changed_date as : '
1000: || l_terms_changed_date);
1001: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1002: 'Leaving Function get_terms_last_update_date');

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

997: || l_return_status);
998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
999: 'OKC_REP_UTIL_PVT.Get_Last_Update_Date returns x_terms_changed_date as : '
1000: || l_terms_changed_date);
1001: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1002: 'Leaving Function get_terms_last_update_date');
1003: END IF;
1004: RETURN l_terms_changed_date ;
1005:

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

1004: RETURN l_terms_changed_date ;
1005:
1006: EXCEPTION
1007: WHEN OTHERS THEN
1008: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1009: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1010: 'Leaving Function get_terms_last_update_date because of EXCEPTION: '||sqlerrm);
1011: END IF;
1012: Okc_Api.Set_Message(p_app_name => 'OKC',

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

1005:
1006: EXCEPTION
1007: WHEN OTHERS THEN
1008: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1009: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1010: 'Leaving Function get_terms_last_update_date because of EXCEPTION: '||sqlerrm);
1011: END IF;
1012: Okc_Api.Set_Message(p_app_name => 'OKC',
1013: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

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

1068: l_api_name := 'draft_attachment_exists';
1069: l_results := 'N';
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);

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

1069: l_results := 'N';
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,

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

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);
1079: END IF;

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

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);
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,

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

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);
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.

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

1077: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
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:

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

1096: END IF;
1097:
1098: CLOSE draft_attachment_csr;
1099:
1100: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1102: 'l_terms_changed_date: ' || l_terms_changed_date);
1103: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1104: 'l_attachment_last_update_date: ' || l_attachment_last_update_date);

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

1097:
1098: CLOSE draft_attachment_csr;
1099:
1100: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1102: 'l_terms_changed_date: ' || l_terms_changed_date);
1103: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1104: 'l_attachment_last_update_date: ' || l_attachment_last_update_date);
1105: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

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

1099:
1100: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1101: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1102: 'l_terms_changed_date: ' || l_terms_changed_date);
1103: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1104: 'l_attachment_last_update_date: ' || l_attachment_last_update_date);
1105: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1106: 'l_attachment_exists: ' || l_attachment_exists);
1107: END IF;

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

1101: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1102: 'l_terms_changed_date: ' || l_terms_changed_date);
1103: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1104: 'l_attachment_last_update_date: ' || l_attachment_last_update_date);
1105: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1106: 'l_attachment_exists: ' || l_attachment_exists);
1107: END IF;
1108:
1109: IF ((l_attachment_exists = 'N') OR (l_attachment_last_update_date < l_terms_changed_date))THEN

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

1115: RETURN l_results;
1116:
1117: EXCEPTION
1118: WHEN OTHERS THEN
1119: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1120: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1121: 'Leaving Function draft_attachment_exists because of EXCEPTION: '||sqlerrm);
1122: END IF;
1123: IF (draft_attachment_csr%ISOPEN) THEN

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

1116:
1117: EXCEPTION
1118: WHEN OTHERS THEN
1119: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1120: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1121: 'Leaving Function draft_attachment_exists because of EXCEPTION: '||sqlerrm);
1122: END IF;
1123: IF (draft_attachment_csr%ISOPEN) THEN
1124: CLOSE draft_attachment_csr ;

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

1198: l_api_name := 'is_contract_status_draft';
1199: l_has_access := 'N';
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);

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

1199: l_has_access := 'N';
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,

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

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);
1209: END IF;

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

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);
1209: END IF;
1210: IF (SubStr(p_document_type,1,3) = 'REP') THEN
1211: OPEN rep_status_csr;

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

1209: END IF;
1210: IF (SubStr(p_document_type,1,3) = 'REP') THEN
1211: OPEN rep_status_csr;
1212: FETCH rep_status_csr INTO l_contract_status_code;
1213: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1215: 'Repository doc type, l_contract_status_code: ' || l_contract_status_code);
1216: END IF;
1217: IF ( (l_contract_status_code = 'DRAFT') OR

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

1210: IF (SubStr(p_document_type,1,3) = 'REP') THEN
1211: OPEN rep_status_csr;
1212: FETCH rep_status_csr INTO l_contract_status_code;
1213: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1214: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1215: 'Repository doc type, l_contract_status_code: ' || l_contract_status_code);
1216: END IF;
1217: IF ( (l_contract_status_code = 'DRAFT') OR
1218: (l_contract_status_code = 'REJECTED') OR

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

1226: ELSIF ((p_document_type='PA_BLANKET') OR (p_document_type='PA_CONTRACT')
1227: OR (p_document_type='PO_STANDARD')) THEN
1228: OPEN po_status_csr;
1229: FETCH po_status_csr INTO l_contract_status_code;
1230: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1231: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1232: 'PO doc type, l_contract_status_code: ' || l_contract_status_code);
1233: END IF;
1234: IF ( (l_contract_status_code = 'IN PROCESS') OR

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

1227: OR (p_document_type='PO_STANDARD')) THEN
1228: OPEN po_status_csr;
1229: FETCH po_status_csr INTO l_contract_status_code;
1230: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1231: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1232: 'PO doc type, l_contract_status_code: ' || l_contract_status_code);
1233: END IF;
1234: IF ( (l_contract_status_code = 'IN PROCESS') OR
1235: (l_contract_status_code = 'INCOMPLETE') OR

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

1245: ELSIF ((p_document_type='RFI') OR (p_document_type='RFQ')
1246: OR (p_document_type='AUCTION')) THEN
1247: OPEN neg_status_csr;
1248: FETCH neg_status_csr INTO l_contract_status_code;
1249: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1250: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1251: 'Negotiation doc type, l_contract_status_code: ' || l_contract_status_code);
1252: END IF;
1253: IF ( (l_contract_status_code = 'ACTIVE') OR

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

1246: OR (p_document_type='AUCTION')) THEN
1247: OPEN neg_status_csr;
1248: FETCH neg_status_csr INTO l_contract_status_code;
1249: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1250: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1251: 'Negotiation doc type, l_contract_status_code: ' || l_contract_status_code);
1252: END IF;
1253: IF ( (l_contract_status_code = 'ACTIVE') OR
1254: (l_contract_status_code = 'AWARD_APPROVAL_INPROCESS') OR

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

1267: CLOSE neg_status_csr;
1268: ELSIF (p_document_type='QUOTE') THEN
1269: /* OPEN quote_status_csr;
1270: FETCH quote_status_csr INTO l_contract_status_code;
1271: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1272: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1273: 'Sales Quote doc type, l_contract_status_code: ' || l_contract_status_code);
1274: END IF;
1275: IF ( (l_contract_status_code = 'APPROVAL CANCELED') OR

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

1268: ELSIF (p_document_type='QUOTE') THEN
1269: /* OPEN quote_status_csr;
1270: FETCH quote_status_csr INTO l_contract_status_code;
1271: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1272: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1273: 'Sales Quote doc type, l_contract_status_code: ' || l_contract_status_code);
1274: END IF;
1275: IF ( (l_contract_status_code = 'APPROVAL CANCELED') OR
1276: (l_contract_status_code = 'APPROVAL PENDING') OR

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

1290: l_results := 'Y';
1291: ELSIF (p_document_type='B') THEN
1292: /* OPEN bsa_status_csr;
1293: FETCH bsa_status_csr INTO l_contract_status_code;
1294: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1295: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1296: 'Sales Agreement doc type, l_contract_status_code: ' || l_contract_status_code);
1297: END IF;
1298:

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

1291: ELSIF (p_document_type='B') THEN
1292: /* OPEN bsa_status_csr;
1293: FETCH bsa_status_csr INTO l_contract_status_code;
1294: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1295: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1296: 'Sales Agreement doc type, l_contract_status_code: ' || l_contract_status_code);
1297: END IF;
1298:
1299: IF ( (l_contract_status_code= 'DRAFT') OR

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

1312: l_results := 'Y';
1313: ELSIF (p_document_type='O') THEN
1314: /* OPEN so_status_csr;
1315: FETCH so_status_csr INTO l_contract_status_code;
1316: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1318: 'Sale Order doc type, l_contract_status_code: ' || l_contract_status_code);
1319: END IF;
1320: IF ( (l_contract_status_code = 'DRAFT') OR

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

1313: ELSIF (p_document_type='O') THEN
1314: /* OPEN so_status_csr;
1315: FETCH so_status_csr INTO l_contract_status_code;
1316: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1318: 'Sale Order doc type, l_contract_status_code: ' || l_contract_status_code);
1319: END IF;
1320: IF ( (l_contract_status_code = 'DRAFT') OR
1321: (l_contract_status_code = 'DRAFT_CUSTOMER_REJECTED') OR

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

1332: l_results := 'Y';
1333: END IF; -- p_document_type like '%tmp_txt_search_draft'
1334:
1335:
1336: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1338: 'l_results: ' || l_results);
1339: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1340: 'Exiting is_contract_status_draft');

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

1333: END IF; -- p_document_type like '%tmp_txt_search_draft'
1334:
1335:
1336: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1338: 'l_results: ' || l_results);
1339: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1340: 'Exiting is_contract_status_draft');
1341: END IF;

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

1335:
1336: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1337: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1338: 'l_results: ' || l_results);
1339: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1340: 'Exiting is_contract_status_draft');
1341: END IF;
1342:
1343: RETURN l_results;

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

1343: RETURN l_results;
1344:
1345: EXCEPTION
1346: WHEN OTHERS THEN
1347: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1348: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1349: 'Leaving Function is_contract_status_draft because of EXCEPTION: '||sqlerrm);
1350: END IF;
1351: IF (rep_status_csr%ISOPEN) THEN

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

1344:
1345: EXCEPTION
1346: WHEN OTHERS THEN
1347: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1348: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1349: 'Leaving Function is_contract_status_draft because of EXCEPTION: '||sqlerrm);
1350: END IF;
1351: IF (rep_status_csr%ISOPEN) THEN
1352: CLOSE rep_status_csr ;

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

1415:
1416: l_api_name := 'get_neg_parties';
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;

Line 1420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,

1416: l_api_name := 'get_neg_parties';
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

Line 1424: IF ( FND_LOG.LEVEL_STATEMENT >= 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,
1427: 'Input parameter is: p_auction_header_id = ' || p_auction_header_id||
1428: '.');

Line 1425: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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,
1427: 'Input parameter is: p_auction_header_id = ' || p_auction_header_id||
1428: '.');
1429: END IF;

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

1432: l_parties := l_parties || party_rec.vendor_name || ' ';
1433: END LOOP;
1434:
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 : '

Line 1438: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

1434:
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 ,

Line 1442: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,

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,
1444: 'Leaving get_neg_parties');
1445: END IF;
1446:

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

1448:
1449: EXCEPTION
1450: WHEN OTHERS
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

Line 1454: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,

1450: WHEN OTHERS
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;

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

1520: BEGIN
1521:
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);

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

1521:
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,

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

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);
1531: END IF;

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

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);
1531: END IF;
1532: IF (SubStr(p_document_type,1,3) = 'REP') THEN
1533: OPEN rep_org_csr;

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

1531: END IF;
1532: IF (SubStr(p_document_type,1,3) = 'REP') THEN
1533: OPEN rep_org_csr;
1534: FETCH rep_org_csr INTO l_org_id;
1535: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1536: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1537: 'Repository doc type, l_org_id: ' || l_org_id);
1538: END IF;
1539: CLOSE rep_org_csr;

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

1532: IF (SubStr(p_document_type,1,3) = 'REP') THEN
1533: OPEN rep_org_csr;
1534: FETCH rep_org_csr INTO l_org_id;
1535: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1536: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1537: 'Repository doc type, l_org_id: ' || l_org_id);
1538: END IF;
1539: CLOSE rep_org_csr;
1540:

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

1541: ELSIF ((p_document_type='PA_BLANKET') OR (p_document_type='PA_CONTRACT')
1542: OR (p_document_type='PO_STANDARD')) THEN
1543: OPEN po_org_csr;
1544: FETCH po_org_csr INTO l_org_id;
1545: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1546: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1547: 'PO doc type, l_org_id: ' || l_org_id);
1548: END IF;
1549: CLOSE po_org_csr;

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

1542: OR (p_document_type='PO_STANDARD')) THEN
1543: OPEN po_org_csr;
1544: FETCH po_org_csr INTO l_org_id;
1545: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1546: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1547: 'PO doc type, l_org_id: ' || l_org_id);
1548: END IF;
1549: CLOSE po_org_csr;
1550:

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

1551: ELSIF ((p_document_type='RFI') OR (p_document_type='RFQ')
1552: OR (p_document_type='AUCTION')) THEN
1553: OPEN neg_org_csr;
1554: FETCH neg_org_csr INTO l_org_id;
1555: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1556: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1557: 'Negotiation doc type, l_org_id: ' || l_org_id);
1558: END IF;
1559: CLOSE neg_org_csr;

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

1552: OR (p_document_type='AUCTION')) THEN
1553: OPEN neg_org_csr;
1554: FETCH neg_org_csr INTO l_org_id;
1555: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1556: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1557: 'Negotiation doc type, l_org_id: ' || l_org_id);
1558: END IF;
1559: CLOSE neg_org_csr;
1560:

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

1560:
1561: ELSIF (p_document_type='QUOTE') THEN
1562: OPEN quote_org_csr;
1563: FETCH quote_org_csr INTO l_org_id;
1564: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1565: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1566: 'Sales Quote doc type, l_org_id: ' || l_org_id);
1567: END IF;
1568: CLOSE quote_org_csr;

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

1561: ELSIF (p_document_type='QUOTE') THEN
1562: OPEN quote_org_csr;
1563: FETCH quote_org_csr INTO l_org_id;
1564: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1565: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1566: 'Sales Quote doc type, l_org_id: ' || l_org_id);
1567: END IF;
1568: CLOSE quote_org_csr;
1569:

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

1569:
1570: ELSIF (p_document_type='B') THEN
1571: OPEN bsa_org_csr;
1572: FETCH bsa_org_csr INTO l_org_id;
1573: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1574: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1575: 'Sales Agreement doc type, l_org_id: ' || l_org_id);
1576: END IF;
1577: CLOSE bsa_org_csr;

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

1570: ELSIF (p_document_type='B') THEN
1571: OPEN bsa_org_csr;
1572: FETCH bsa_org_csr INTO l_org_id;
1573: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1574: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1575: 'Sales Agreement doc type, l_org_id: ' || l_org_id);
1576: END IF;
1577: CLOSE bsa_org_csr;
1578: ELSIF (p_document_type='O') THEN

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

1577: CLOSE bsa_org_csr;
1578: ELSIF (p_document_type='O') THEN
1579: OPEN so_org_csr;
1580: FETCH so_org_csr INTO l_org_id;
1581: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1583: 'Sale Order doc type, l_org_id: ' || l_org_id);
1584: END IF;
1585: CLOSE so_org_csr;

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

1578: ELSIF (p_document_type='O') THEN
1579: OPEN so_org_csr;
1580: FETCH so_org_csr INTO l_org_id;
1581: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1582: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1583: 'Sale Order doc type, l_org_id: ' || l_org_id);
1584: END IF;
1585: CLOSE so_org_csr;
1586: END IF;

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

1585: CLOSE so_org_csr;
1586: END IF;
1587:
1588:
1589: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1590: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1591: 'l_org_id: ' || l_org_id);
1592: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1593: 'Exiting get_contract_org');

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

1586: END IF;
1587:
1588:
1589: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1590: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1591: 'l_org_id: ' || l_org_id);
1592: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1593: 'Exiting get_contract_org');
1594: END IF;

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

1588:
1589: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1590: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1591: 'l_org_id: ' || l_org_id);
1592: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1593: 'Exiting get_contract_org');
1594: END IF;
1595:
1596: RETURN l_org_id;

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

1596: RETURN l_org_id;
1597:
1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1601: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1602: 'Leaving Function get_contract_org because of EXCEPTION: '||sqlerrm);
1603: END IF;
1604: IF (rep_org_csr%ISOPEN) THEN

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

1597:
1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1601: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1602: 'Leaving Function get_contract_org because of EXCEPTION: '||sqlerrm);
1603: END IF;
1604: IF (rep_org_csr%ISOPEN) THEN
1605: CLOSE rep_org_csr ;