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 298: 'OKC_REP_UTIL_PVT.get_current_user_acl_keys

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

Line 319: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

315: because of EXCEPTION: '
316: ||sqlerrm);
317: END IF;
318: Okc_Api.Set_Message(p_app_name => 'OKC',
319: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
320: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
321: p_token1_value => sqlcode,
322: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
323: p_token2_value => sqlerrm);

Line 320: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

316: ||sqlerrm);
317: END IF;
318: Okc_Api.Set_Message(p_app_name => 'OKC',
319: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
320: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
321: p_token1_value => sqlcode,
322: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
323: p_token2_value => sqlerrm);
324: END;

Line 322: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

318: Okc_Api.Set_Message(p_app_name => 'OKC',
319: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
320: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
321: p_token1_value => sqlcode,
322: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
323: p_token2_value => sqlerrm);
324: END;
325:
326:

Line 410: 'OKC_REP_UTIL_PVT.get_current_user_moac_keys

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

Line 429: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

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',
429: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
430: p_token1 =>OKC_REP_UTIL_PVT. G_SQLCODE_TOKEN,
431: p_token1_value => sqlcode,
432: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
433: p_token2_value => sqlerrm);

Line 430: p_token1 =>OKC_REP_UTIL_PVT. G_SQLCODE_TOKEN,

426: EXCEPTION: '||sqlerrm);
427: END IF;
428: Okc_Api.Set_Message(p_app_name => 'OKC',
429: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
430: p_token1 =>OKC_REP_UTIL_PVT. G_SQLCODE_TOKEN,
431: p_token1_value => sqlcode,
432: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
433: p_token2_value => sqlerrm);
434: END;

Line 432: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

428: Okc_Api.Set_Message(p_app_name => 'OKC',
429: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
430: p_token1 =>OKC_REP_UTIL_PVT. G_SQLCODE_TOKEN,
431: p_token1_value => sqlcode,
432: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
433: p_token2_value => sqlerrm);
434: END;
435:
436:

Line 490: 'OKC_REP_UTIL_PVT.get_intent_profile_keys

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

Line 509: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

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',
509: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
510: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
511: p_token1_value => sqlcode,
512: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
513: p_token2_value => sqlerrm);

Line 510: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

506: because of EXCEPTION: '||sqlerrm);
507: END IF;
508: Okc_Api.Set_Message(p_app_name => 'OKC',
509: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
510: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
511: p_token1_value => sqlcode,
512: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
513: p_token2_value => sqlerrm);
514:

Line 512: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

508: Okc_Api.Set_Message(p_app_name => 'OKC',
509: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
510: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
511: p_token1_value => sqlcode,
512: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
513: p_token2_value => sqlerrm);
514:
515: END;
516:

Line 587: 'OKC_REP_UTIL_PVT.get_current_user_quote_access

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

Line 606: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

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',
606: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
607: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
608: p_token1_value => sqlcode,
609: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
610: p_token2_value => sqlerrm);

Line 607: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

603: because of EXCEPTION: '||sqlerrm);
604: END IF;
605: Okc_Api.Set_Message(p_app_name => 'OKC',
606: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
607: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
608: p_token1_value => sqlcode,
609: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
610: p_token2_value => sqlerrm);
611:

Line 609: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

605: Okc_Api.Set_Message(p_app_name => 'OKC',
606: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
607: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
608: p_token1_value => sqlcode,
609: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
610: p_token2_value => sqlerrm);
611:
612: END;
613:

Line 793: 'OKC_REP_UTIL_PVT.get_local_language_attributes

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

Line 812: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

808: 'Leaving PROCEDURE get_local_language_attributes
809: because of EXCEPTION: '||sqlerrm);
810: END IF;
811: Okc_Api.Set_Message(p_app_name => 'OKC',
812: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
813: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
814: p_token1_value => sqlcode,
815: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
816: p_token2_value => sqlerrm);

Line 813: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

809: because of EXCEPTION: '||sqlerrm);
810: END IF;
811: Okc_Api.Set_Message(p_app_name => 'OKC',
812: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
813: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
814: p_token1_value => sqlcode,
815: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
816: p_token2_value => sqlerrm);
817: END;

Line 815: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

811: Okc_Api.Set_Message(p_app_name => 'OKC',
812: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
813: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
814: p_token1_value => sqlcode,
815: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
816: p_token2_value => sqlerrm);
817: END;
818:
819:

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

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

Line 931: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

927: 'Leaving PROCEDURE get_rep_parties
928: because of EXCEPTION: '||sqlerrm);
929: END IF;
930: Okc_Api.Set_Message(p_app_name => 'OKC',
931: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
932: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
933: p_token1_value => sqlcode,
934: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
935: p_token2_value => sqlerrm);

Line 932: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

928: because of EXCEPTION: '||sqlerrm);
929: END IF;
930: Okc_Api.Set_Message(p_app_name => 'OKC',
931: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
932: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
933: p_token1_value => sqlcode,
934: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
935: p_token2_value => sqlerrm);
936: END;

Line 934: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

930: Okc_Api.Set_Message(p_app_name => 'OKC',
931: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
932: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
933: p_token1_value => sqlcode,
934: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
935: p_token2_value => sqlerrm);
936: END;
937:
938:

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

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

Line 1013: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

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,
1014: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1015: p_token1_value => sqlcode,
1016: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1017: p_token2_value => sqlerrm);

Line 1014: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

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,
1014: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1015: p_token1_value => sqlcode,
1016: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1017: p_token2_value => sqlerrm);
1018: RETURN l_has_access ;

Line 1016: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

1012: Okc_Api.Set_Message(p_app_name => 'OKC',
1013: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1014: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1015: p_token1_value => sqlcode,
1016: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1017: p_token2_value => sqlerrm);
1018: RETURN l_has_access ;
1019: END get_terms_last_update_date;
1020:

Line 1127: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

1123: IF (draft_attachment_csr%ISOPEN) THEN
1124: CLOSE draft_attachment_csr ;
1125: END IF;
1126: Okc_Api.Set_Message(p_app_name => 'OKC',
1127: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1128: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1129: p_token1_value => sqlcode,
1130: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1131: p_token2_value => sqlerrm);

Line 1128: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

1124: CLOSE draft_attachment_csr ;
1125: END IF;
1126: Okc_Api.Set_Message(p_app_name => 'OKC',
1127: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1128: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1129: p_token1_value => sqlcode,
1130: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1131: p_token2_value => sqlerrm);
1132: RETURN l_results ;

Line 1130: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

1126: Okc_Api.Set_Message(p_app_name => 'OKC',
1127: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1128: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1129: p_token1_value => sqlcode,
1130: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1131: p_token2_value => sqlerrm);
1132: RETURN l_results ;
1133: END draft_attachment_exists;
1134:

Line 1370: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

1366: IF (bsa_status_csr%ISOPEN) THEN
1367: CLOSE bsa_status_csr ;
1368: END IF;
1369: Okc_Api.Set_Message(p_app_name => 'OKC',
1370: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1371: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1372: p_token1_value => sqlcode,
1373: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1374: p_token2_value => sqlerrm);

Line 1371: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

1367: CLOSE bsa_status_csr ;
1368: END IF;
1369: Okc_Api.Set_Message(p_app_name => 'OKC',
1370: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1371: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1372: p_token1_value => sqlcode,
1373: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1374: p_token2_value => sqlerrm);
1375: RETURN l_results ;

Line 1373: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

1369: Okc_Api.Set_Message(p_app_name => 'OKC',
1370: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1371: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1372: p_token1_value => sqlcode,
1373: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1374: p_token2_value => sqlerrm);
1375: RETURN l_results ;
1376: END is_contract_status_draft;
1377:

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

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

Line 1460: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

1456: 'Leaving PROCEDURE get_neg_parties
1457: because of EXCEPTION: '||sqlerrm);
1458: END IF;
1459: Okc_Api.Set_Message(p_app_name => 'OKC',
1460: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1461: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1462: p_token1_value => sqlcode,
1463: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1464: p_token2_value => sqlerrm);

Line 1461: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

1457: because of EXCEPTION: '||sqlerrm);
1458: END IF;
1459: Okc_Api.Set_Message(p_app_name => 'OKC',
1460: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1461: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1462: p_token1_value => sqlcode,
1463: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1464: p_token2_value => sqlerrm);
1465: END get_neg_parties;

Line 1463: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

1459: Okc_Api.Set_Message(p_app_name => 'OKC',
1460: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1461: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1462: p_token1_value => sqlcode,
1463: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1464: p_token2_value => sqlerrm);
1465: END get_neg_parties;
1466:
1467: -- API name : get_contract_org

Line 1623: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,

1619: IF (bsa_org_csr%ISOPEN) THEN
1620: CLOSE bsa_org_csr ;
1621: END IF;
1622: Okc_Api.Set_Message(p_app_name => 'OKC',
1623: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1624: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1625: p_token1_value => sqlcode,
1626: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1627: p_token2_value => sqlerrm);

Line 1624: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,

1620: CLOSE bsa_org_csr ;
1621: END IF;
1622: Okc_Api.Set_Message(p_app_name => 'OKC',
1623: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1624: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1625: p_token1_value => sqlcode,
1626: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1627: p_token2_value => sqlerrm);
1628: RETURN -1;

Line 1626: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,

1622: Okc_Api.Set_Message(p_app_name => 'OKC',
1623: p_msg_name => OKC_REP_UTIL_PVT.G_UNEXPECTED_ERROR,
1624: p_token1 => OKC_REP_UTIL_PVT.G_SQLCODE_TOKEN,
1625: p_token1_value => sqlcode,
1626: p_token2 => OKC_REP_UTIL_PVT.G_SQLERRM_TOKEN,
1627: p_token2_value => sqlerrm);
1628: RETURN -1;
1629: END get_contract_org;
1630: