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_UTIL_PVT

Line 175: 'OKC_REP_UTIL_PVT.get_rep_doc_acl

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

Line 196: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

192: because of EXCEPTION: '
193: ||sqlerrm);
194: END IF;
195: Okc_Api.Set_Message(p_app_name => 'OKC',
196: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
197: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
198: p_token1_value => sqlcode,
199: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
200: p_token2_value => sqlerrm);

Line 197: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

193: ||sqlerrm);
194: END IF;
195: Okc_Api.Set_Message(p_app_name => 'OKC',
196: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
197: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
198: p_token1_value => sqlcode,
199: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
200: p_token2_value => sqlerrm);
201:

Line 199: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

195: Okc_Api.Set_Message(p_app_name => 'OKC',
196: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
197: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
198: p_token1_value => sqlcode,
199: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
200: p_token2_value => sqlerrm);
201:
202: END;
203:

Line 264: IF (FND_FUNCTION.TEST(OKC_REP_UTIL_PVT.G_FUNC_OKC_REP_ADMINISTRATOR,'Y'))

260: x_keys := x_keys || 'o' || to_char(l_user_id) || ' ';
261:
262: -- 3. If (the current user has admin responsibility), then add
263: -- 'admin_acl' and return the list of ACL keys.
264: IF (FND_FUNCTION.TEST(OKC_REP_UTIL_PVT.G_FUNC_OKC_REP_ADMINISTRATOR,'Y'))
265: THEN
266: x_keys := x_keys || 'admin_acl';
267:
268: -- 4. Else:

Line 292: 'OKC_REP_UTIL_PVT.get_current_user_acl_keys

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

Line 313: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

309: because of EXCEPTION: '
310: ||sqlerrm);
311: END IF;
312: Okc_Api.Set_Message(p_app_name => 'OKC',
313: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
314: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
315: p_token1_value => sqlcode,
316: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
317: p_token2_value => sqlerrm);

Line 314: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

310: ||sqlerrm);
311: END IF;
312: Okc_Api.Set_Message(p_app_name => 'OKC',
313: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
314: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
315: p_token1_value => sqlcode,
316: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
317: p_token2_value => sqlerrm);
318: END;

Line 316: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

312: Okc_Api.Set_Message(p_app_name => 'OKC',
313: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
314: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
315: p_token1_value => sqlcode,
316: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
317: p_token2_value => sqlerrm);
318: END;
319:
320:

Line 404: 'OKC_REP_UTIL_PVT.get_current_user_moac_keys

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

Line 423: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

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',
423: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
424: p_token1 =>OKC_REP_UTIL_PVT. G_SQLCODE_TOKEN,
425: p_token1_value => sqlcode,
426: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
427: p_token2_value => sqlerrm);

Line 424: p_token1 =>OKC_REP_UTIL_PVT. G_SQLCODE_TOKEN,

420: EXCEPTION: '||sqlerrm);
421: END IF;
422: Okc_Api.Set_Message(p_app_name => 'OKC',
423: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
424: p_token1 =>OKC_REP_UTIL_PVT. G_SQLCODE_TOKEN,
425: p_token1_value => sqlcode,
426: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
427: p_token2_value => sqlerrm);
428: END;

Line 426: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

422: Okc_Api.Set_Message(p_app_name => 'OKC',
423: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
424: p_token1 =>OKC_REP_UTIL_PVT. G_SQLCODE_TOKEN,
425: p_token1_value => sqlcode,
426: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
427: p_token2_value => sqlerrm);
428: END;
429:
430:

Line 484: 'OKC_REP_UTIL_PVT.get_intent_profile_keys

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

Line 503: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

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',
503: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
504: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
505: p_token1_value => sqlcode,
506: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
507: p_token2_value => sqlerrm);

Line 504: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

500: because of EXCEPTION: '||sqlerrm);
501: END IF;
502: Okc_Api.Set_Message(p_app_name => 'OKC',
503: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
504: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
505: p_token1_value => sqlcode,
506: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
507: p_token2_value => sqlerrm);
508:

Line 506: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

502: Okc_Api.Set_Message(p_app_name => 'OKC',
503: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
504: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
505: p_token1_value => sqlcode,
506: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
507: p_token2_value => sqlerrm);
508:
509: END;
510:

Line 581: 'OKC_REP_UTIL_PVT.get_current_user_quote_access

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

Line 600: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

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',
600: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
601: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
602: p_token1_value => sqlcode,
603: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
604: p_token2_value => sqlerrm);

Line 601: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

597: because of EXCEPTION: '||sqlerrm);
598: END IF;
599: Okc_Api.Set_Message(p_app_name => 'OKC',
600: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
601: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
602: p_token1_value => sqlcode,
603: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
604: p_token2_value => sqlerrm);
605:

Line 603: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

599: Okc_Api.Set_Message(p_app_name => 'OKC',
600: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
601: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
602: p_token1_value => sqlcode,
603: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
604: p_token2_value => sqlerrm);
605:
606: END;
607:

Line 787: 'OKC_REP_UTIL_PVT.get_local_language_attributes

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

Line 806: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

802: 'Leaving PROCEDURE get_local_language_attributes
803: because of EXCEPTION: '||sqlerrm);
804: END IF;
805: Okc_Api.Set_Message(p_app_name => 'OKC',
806: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
807: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
808: p_token1_value => sqlcode,
809: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
810: p_token2_value => sqlerrm);

Line 807: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

803: because of EXCEPTION: '||sqlerrm);
804: END IF;
805: Okc_Api.Set_Message(p_app_name => 'OKC',
806: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
807: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
808: p_token1_value => sqlcode,
809: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
810: p_token2_value => sqlerrm);
811: END;

Line 809: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

805: Okc_Api.Set_Message(p_app_name => 'OKC',
806: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
807: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
808: p_token1_value => sqlcode,
809: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
810: p_token2_value => sqlerrm);
811: END;
812:
813:

Line 905: 'OKC_REP_UTIL_PVT.get_rep_parties returns l_parties as : '

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,
909: 'Leaving get_rep_parties');

Line 925: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

921: 'Leaving PROCEDURE get_rep_parties
922: because of EXCEPTION: '||sqlerrm);
923: END IF;
924: Okc_Api.Set_Message(p_app_name => 'OKC',
925: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
926: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
927: p_token1_value => sqlcode,
928: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
929: p_token2_value => sqlerrm);

Line 926: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

922: because of EXCEPTION: '||sqlerrm);
923: END IF;
924: Okc_Api.Set_Message(p_app_name => 'OKC',
925: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
926: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
927: p_token1_value => sqlcode,
928: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
929: p_token2_value => sqlerrm);
930: END;

Line 928: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

924: Okc_Api.Set_Message(p_app_name => 'OKC',
925: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
926: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
927: p_token1_value => sqlcode,
928: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
929: p_token2_value => sqlerrm);
930: END;
931:
932:

Line 993: 'OKC_REP_UTIL_PVT.Get_Last_Update_Date returns x_terms_changed_date as : '

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

Line 1007: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

1003: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1004: 'Leaving Function get_terms_last_update_date because of EXCEPTION: '||sqlerrm);
1005: END IF;
1006: Okc_Api.Set_Message(p_app_name => 'OKC',
1007: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1008: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1009: p_token1_value => sqlcode,
1010: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1011: p_token2_value => sqlerrm);

Line 1008: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

1004: 'Leaving Function get_terms_last_update_date because of EXCEPTION: '||sqlerrm);
1005: END IF;
1006: Okc_Api.Set_Message(p_app_name => 'OKC',
1007: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1008: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1009: p_token1_value => sqlcode,
1010: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1011: p_token2_value => sqlerrm);
1012: RETURN l_has_access ;

Line 1010: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

1006: Okc_Api.Set_Message(p_app_name => 'OKC',
1007: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1008: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1009: p_token1_value => sqlcode,
1010: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1011: p_token2_value => sqlerrm);
1012: RETURN l_has_access ;
1013: END get_terms_last_update_date;
1014:

Line 1121: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

1117: IF (draft_attachment_csr%ISOPEN) THEN
1118: CLOSE draft_attachment_csr ;
1119: END IF;
1120: Okc_Api.Set_Message(p_app_name => 'OKC',
1121: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1122: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1123: p_token1_value => sqlcode,
1124: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1125: p_token2_value => sqlerrm);

Line 1122: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

1118: CLOSE draft_attachment_csr ;
1119: END IF;
1120: Okc_Api.Set_Message(p_app_name => 'OKC',
1121: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1122: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1123: p_token1_value => sqlcode,
1124: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1125: p_token2_value => sqlerrm);
1126: RETURN l_results ;

Line 1124: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

1120: Okc_Api.Set_Message(p_app_name => 'OKC',
1121: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1122: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1123: p_token1_value => sqlcode,
1124: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1125: p_token2_value => sqlerrm);
1126: RETURN l_results ;
1127: END draft_attachment_exists;
1128:

Line 1358: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

1354: IF (bsa_status_csr%ISOPEN) THEN
1355: CLOSE bsa_status_csr ;
1356: END IF;
1357: Okc_Api.Set_Message(p_app_name => 'OKC',
1358: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1359: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1360: p_token1_value => sqlcode,
1361: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1362: p_token2_value => sqlerrm);

Line 1359: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

1355: CLOSE bsa_status_csr ;
1356: END IF;
1357: Okc_Api.Set_Message(p_app_name => 'OKC',
1358: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1359: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1360: p_token1_value => sqlcode,
1361: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1362: p_token2_value => sqlerrm);
1363: RETURN l_results ;

Line 1361: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

1357: Okc_Api.Set_Message(p_app_name => 'OKC',
1358: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1359: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1360: p_token1_value => sqlcode,
1361: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1362: p_token2_value => sqlerrm);
1363: RETURN l_results ;
1364: END is_contract_status_draft;
1365:

Line 1428: 'OKC_REP_UTIL_PVT.get_neg_parties returns l_parties as : '

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,
1432: 'Leaving get_neg_parties');

Line 1448: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

1444: 'Leaving PROCEDURE get_neg_parties
1445: because of EXCEPTION: '||sqlerrm);
1446: END IF;
1447: Okc_Api.Set_Message(p_app_name => 'OKC',
1448: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1449: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1450: p_token1_value => sqlcode,
1451: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1452: p_token2_value => sqlerrm);

Line 1449: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

1445: because of EXCEPTION: '||sqlerrm);
1446: END IF;
1447: Okc_Api.Set_Message(p_app_name => 'OKC',
1448: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1449: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1450: p_token1_value => sqlcode,
1451: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1452: p_token2_value => sqlerrm);
1453: END get_neg_parties;

Line 1451: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

1447: Okc_Api.Set_Message(p_app_name => 'OKC',
1448: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1449: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1450: p_token1_value => sqlcode,
1451: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1452: p_token2_value => sqlerrm);
1453: END get_neg_parties;
1454:
1455: