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_UTIL_PVT dependencies on OKC_API

Line 398: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

394: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
395: g_module || l_api_name || '.exception',
396: '117: Leaving check_contract_access because of EXCEPTION: ' || sqlerrm);
397: END IF;
398: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
399: p_msg_name => G_UNEXPECTED_ERROR,
400: p_token1 => G_SQLCODE_TOKEN,
401: p_token1_value => sqlcode,
402: p_token2 => G_SQLERRM_TOKEN,

Line 842: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

838: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
839: g_module || l_api_name || '.exception',
840: '117: Leaving check_contract_access because of EXCEPTION: ' || sqlerrm);
841: END IF;
842: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
843: p_msg_name => G_UNEXPECTED_ERROR,
844: p_token1 => G_SQLCODE_TOKEN,
845: p_token1_value => sqlcode,
846: p_token2 => G_SQLERRM_TOKEN,

Line 925: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

921: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
922: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
923: 'Leaving Function has_contract_access because of EXCEPTION: '||sqlerrm);
924: END IF;
925: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
926: p_msg_name => G_UNEXPECTED_ERROR,
927: p_token1 => G_SQLCODE_TOKEN,
928: p_token1_value => sqlcode,
929: p_token2 => G_SQLERRM_TOKEN,

Line 1009: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1005: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1006: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1007: 'Leaving Function has_contract_access because of EXCEPTION: '||sqlerrm);
1008: END IF;
1009: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1010: p_msg_name => G_UNEXPECTED_ERROR,
1011: p_token1 => G_SQLCODE_TOKEN,
1012: p_token1_value => sqlcode,
1013: p_token2 => G_SQLERRM_TOKEN,

Line 1171: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1167: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1168: g_module || l_api_name || '.exception',
1169: 'Leaving change_contract_status because of EXCEPTION: ' || sqlerrm);
1170: END IF;
1171: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1172: p_msg_name => G_UNEXPECTED_ERROR,
1173: p_token1 => G_SQLCODE_TOKEN,
1174: p_token1_value => sqlcode,
1175: p_token2 => G_SQLERRM_TOKEN,

Line 1324: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1320: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1321: g_module || l_api_name || '.exception',
1322: 'Leaving add_approval_hist_record because of EXCEPTION: ' || sqlerrm);
1323: END IF;
1324: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1325: p_msg_name => G_UNEXPECTED_ERROR,
1326: p_token1 => G_SQLCODE_TOKEN,
1327: p_token1_value => sqlcode,
1328: p_token2 => G_SQLERRM_TOKEN,

Line 1491: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1487: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1488: g_module || l_api_name || '.exception',
1489: 'Leaving add_signature_hist_record because of EXCEPTION: ' || sqlerrm);
1490: END IF;
1491: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1492: p_msg_name => G_UNEXPECTED_ERROR,
1493: p_token1 => G_SQLCODE_TOKEN,
1494: p_token1_value => sqlcode,
1495: p_token2 => G_SQLERRM_TOKEN,

Line 2380: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2376: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
2377: 'Leaving validate_contract_party because of EXCEPTION: ' || sqlerrm);
2378: END IF;
2379:
2380: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2381: p_msg_name => G_UNEXPECTED_ERROR,
2382: p_token1 => G_SQLCODE_TOKEN,
2383: p_token1_value => sqlcode,
2384: p_token2 => G_SQLERRM_TOKEN,

Line 2766: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2762: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
2763: 'Leaving validate_party_contact because of EXCEPTION: ' || sqlerrm);
2764: END IF;
2765:
2766: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2767: p_msg_name => G_UNEXPECTED_ERROR,
2768: p_token1 => G_SQLCODE_TOKEN,
2769: p_token1_value => sqlcode,
2770: p_token2 => G_SQLERRM_TOKEN,

Line 2969: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

2965: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
2966: 'Leaving populate_import_errors because of EXCEPTION: ' || sqlerrm);
2967: END IF;
2968:
2969: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2970: p_msg_name => G_UNEXPECTED_ERROR,
2971: p_token1 => G_SQLCODE_TOKEN,
2972: p_token1_value => sqlcode,
2973: p_token2 => G_SQLERRM_TOKEN,

Line 3330: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3326: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
3327: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
3328: END IF;
3329:
3330: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3331: p_msg_name => G_UNEXPECTED_ERROR,
3332: p_token1 => G_SQLCODE_TOKEN,
3333: p_token1_value => sqlcode,
3334: p_token2 => G_SQLERRM_TOKEN,

Line 3849: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

3845: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
3846: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
3847: END IF;
3848:
3849: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3850: p_msg_name => G_UNEXPECTED_ERROR,
3851: p_token1 => G_SQLCODE_TOKEN,
3852: p_token1_value => sqlcode,
3853: p_token2 => G_SQLERRM_TOKEN,

Line 4519: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_IMP_EXP_BEFORE_EFF',l_contract_type);

4515: l_valid_flag := 'N';
4516: --Acq Plan Message Cleanup
4517: --l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_EXP_BEFORE_EFF');
4518:
4519: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_IMP_EXP_BEFORE_EFF',l_contract_type);
4520: l_resolved_token := OKC_API.resolve_hdr_token(l_contract_type);
4521:
4522: --l_error_msg := fnd_message.get_string(G_APP_NAME,l_resolved_msg_name,p_token1=>'HDR_TOKEN',p_token1_value => l_resolved_token);
4523:

Line 4520: l_resolved_token := OKC_API.resolve_hdr_token(l_contract_type);

4516: --Acq Plan Message Cleanup
4517: --l_error_msg := fnd_message.get_string(G_APP_NAME,'OKC_REP_IMP_EXP_BEFORE_EFF');
4518:
4519: l_resolved_msg_name := OKC_API.resolve_message('OKC_REP_IMP_EXP_BEFORE_EFF',l_contract_type);
4520: l_resolved_token := OKC_API.resolve_hdr_token(l_contract_type);
4521:
4522: --l_error_msg := fnd_message.get_string(G_APP_NAME,l_resolved_msg_name,p_token1=>'HDR_TOKEN',p_token1_value => l_resolved_token);
4523:
4524: l_error_msg := OKC_TERMS_UTIL_PVT.Get_Message(G_APP_NAME,l_resolved_msg_name,p_token1=>'HDR_TOKEN',p_token1_value => l_resolved_token);

Line 5569: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

5565: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
5566: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
5567: END IF;
5568:
5569: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5570: p_msg_name => G_UNEXPECTED_ERROR,
5571: p_token1 => G_SQLCODE_TOKEN,
5572: p_token1_value => sqlcode,
5573: p_token2 => G_SQLERRM_TOKEN,

Line 6190: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

6186: CLOSE contract_id_cur ;
6187: END IF;
6188:
6189:
6190: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6191: p_msg_name => G_UNEXPECTED_ERROR,
6192: p_token1 => G_SQLCODE_TOKEN,
6193: p_token1_value => sqlcode,
6194: p_token2 => G_SQLERRM_TOKEN,

Line 6370: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

6366: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
6367: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
6368: END IF;
6369:
6370: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6371: p_msg_name => G_UNEXPECTED_ERROR,
6372: p_token1 => G_SQLCODE_TOKEN,
6373: p_token1_value => sqlcode,
6374: p_token2 => G_SQLERRM_TOKEN,

Line 6569: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

6565: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
6566: 'Leaving delete_import_contract because of EXCEPTION: ' || sqlerrm);
6567: END IF;
6568:
6569: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6570: p_msg_name => G_UNEXPECTED_ERROR,
6571: p_token1 => G_SQLCODE_TOKEN,
6572: p_token1_value => sqlcode,
6573: p_token2 => G_SQLERRM_TOKEN,

Line 6647: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

6643: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6644: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
6645: 'Leaving Function '||l_api_name||' because of EXCEPTION: '||sqlerrm);
6646: END IF;
6647: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6648: p_msg_name => G_UNEXPECTED_ERROR,
6649: p_token1 => G_SQLCODE_TOKEN,
6650: p_token1_value => sqlcode,
6651: p_token2 => G_SQLERRM_TOKEN,

Line 6901: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

6897: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6898: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
6899: 'Leaving Function '||l_api_name||' because of EXCEPTION: '||sqlerrm);
6900: END IF;
6901: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6902: p_msg_name => G_UNEXPECTED_ERROR,
6903: p_token1 => G_SQLCODE_TOKEN,
6904: p_token1_value => sqlcode,
6905: p_token2 => G_SQLERRM_TOKEN,

Line 6984: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

6980: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6981: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
6982: 'Leaving Function '||l_api_name||' because of EXCEPTION: '||sqlerrm);
6983: END IF;
6984: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6985: p_msg_name => G_UNEXPECTED_ERROR,
6986: p_token1 => G_SQLCODE_TOKEN,
6987: p_token1_value => sqlcode,
6988: p_token2 => G_SQLERRM_TOKEN,

Line 7148: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

7144: END IF;
7145: IF (vendor_email_csr%ISOPEN) THEN
7146: CLOSE vendor_email_csr ;
7147: END IF;
7148: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7149: p_msg_name => G_UNEXPECTED_ERROR,
7150: p_token1 => G_SQLCODE_TOKEN,
7151: p_token1_value => sqlcode,
7152: p_token2 => G_SQLERRM_TOKEN,

Line 7312: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

7308: END IF;
7309: IF (tca_email_csr%ISOPEN) THEN
7310: CLOSE tca_email_csr ;
7311: END IF;
7312: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7313: p_msg_name => G_UNEXPECTED_ERROR,
7314: p_token1 => G_SQLCODE_TOKEN,
7315: p_token1_value => sqlcode,
7316: p_token2 => G_SQLERRM_TOKEN,

Line 7456: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

7452: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
7453: g_module || l_api_name,
7454: 'Leaving get_external_userlist because of EXCEPTION: ' || sqlerrm);
7455: END IF;
7456: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7457: p_msg_name => G_UNEXPECTED_ERROR,
7458: p_token1 => G_SQLCODE_TOKEN,
7459: p_token1_value => sqlcode,
7460: p_token2 => G_SQLERRM_TOKEN,

Line 7616: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

7612: IF (l_contract_updatable_csr%ISOPEN) THEN
7613: CLOSE l_contract_updatable_csr ;
7614: END IF;
7615: x_return_status := FND_API.G_RET_STS_ERROR;
7616: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7617: p_msg_name => G_UNEXPECTED_ERROR,
7618: p_token1 => G_SQLCODE_TOKEN,
7619: p_token1_value => sqlcode,
7620: p_token2 => G_SQLERRM_TOKEN,

Line 7726: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

7722: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7723: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
7724: 'Leaving Function can_update because of EXCEPTION: '||sqlerrm);
7725: END IF;
7726: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7727: p_msg_name => G_UNEXPECTED_ERROR,
7728: p_token1 => G_SQLCODE_TOKEN,
7729: p_token1_value => sqlcode,
7730: p_token2 => G_SQLERRM_TOKEN,

Line 7781: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

7777: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7778: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
7779: 'Leaving Function is_sales_workbench because of EXCEPTION: '||sqlerrm);
7780: END IF;
7781: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7782: p_msg_name => G_UNEXPECTED_ERROR,
7783: p_token1 => G_SQLCODE_TOKEN,
7784: p_token1_value => sqlcode,
7785: p_token2 => G_SQLERRM_TOKEN,

Line 8143: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

8139: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
8140: g_module || 'check_contract_doc_access.exception',
8141: '117: Leaving check_contract_access because of EXCEPTION: ' || sqlerrm);
8142: END IF;
8143: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8144: p_msg_name => G_UNEXPECTED_ERROR,
8145: p_token1 => G_SQLCODE_TOKEN,
8146: p_token1_value => sqlcode,
8147: p_token2 => G_SQLERRM_TOKEN,

Line 8206: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

8202: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8203: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
8204: 'Leaving Function get_accessible_ous because of EXCEPTION: '||sqlerrm);
8205: END IF;
8206: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8207: p_msg_name => G_UNEXPECTED_ERROR,
8208: p_token1 => G_SQLCODE_TOKEN,
8209: p_token1_value => sqlcode,
8210: p_token2 => G_SQLERRM_TOKEN,

Line 8286: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

8282: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8283: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
8284: 'Leaving Function get_quote_access because of EXCEPTION: '||sqlerrm);
8285: END IF;
8286: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8287: p_msg_name => G_UNEXPECTED_ERROR,
8288: p_token1 => G_SQLCODE_TOKEN,
8289: p_token1_value => sqlcode,
8290: p_token2 => G_SQLERRM_TOKEN,

Line 8351: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

8347: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
8348: 'Leaving Function contract_terms_disabled_yn because of EXCEPTION: '||sqlerrm);
8349: END IF;
8350:
8351: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8352: p_msg_name => G_UNEXPECTED_ERROR,
8353: p_token1 => G_SQLCODE_TOKEN,
8354: p_token1_value => sqlcode,
8355: p_token2 => G_SQLERRM_TOKEN,

Line 8401: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

8397: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
8398: 'Leaving Function contract_terms_disabled_yn because of EXCEPTION: '||sqlerrm);
8399: END IF;
8400:
8401: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8402: p_msg_name => G_UNEXPECTED_ERROR,
8403: p_token1 => G_SQLCODE_TOKEN,
8404: p_token1_value => sqlcode,
8405: p_token2 => G_SQLERRM_TOKEN,

Line 8874: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

8870: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
8871: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
8872: END IF;
8873:
8874: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
8875: p_msg_name => G_UNEXPECTED_ERROR,
8876: p_token1 => G_SQLCODE_TOKEN,
8877: p_token1_value => sqlcode,
8878: p_token2 => G_SQLERRM_TOKEN,

Line 9271: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

9267: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
9268: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
9269: END IF;
9270:
9271: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
9272: p_msg_name => G_UNEXPECTED_ERROR,
9273: p_token1 => G_SQLCODE_TOKEN,
9274: p_token1_value => sqlcode,
9275: p_token2 => G_SQLERRM_TOKEN,