DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on OKC_API

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

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

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

757: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
758: g_module || l_api_name || '.exception',
759: '117: Leaving check_contract_access because of EXCEPTION: ' || sqlerrm);
760: END IF;
761: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
762: p_msg_name => G_UNEXPECTED_ERROR,
763: p_token1 => G_SQLCODE_TOKEN,
764: p_token1_value => sqlcode,
765: p_token2 => G_SQLERRM_TOKEN,

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

840: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
842: 'Leaving Function has_contract_access because of EXCEPTION: '||sqlerrm);
843: END IF;
844: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
845: p_msg_name => G_UNEXPECTED_ERROR,
846: p_token1 => G_SQLCODE_TOKEN,
847: p_token1_value => sqlcode,
848: p_token2 => G_SQLERRM_TOKEN,

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

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

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

1086: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1087: g_module || l_api_name || '.exception',
1088: 'Leaving change_contract_status because of EXCEPTION: ' || sqlerrm);
1089: END IF;
1090: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1091: p_msg_name => G_UNEXPECTED_ERROR,
1092: p_token1 => G_SQLCODE_TOKEN,
1093: p_token1_value => sqlcode,
1094: p_token2 => G_SQLERRM_TOKEN,

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

1232: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
1233: g_module || l_api_name || '.exception',
1234: 'Leaving add_approval_hist_record because of EXCEPTION: ' || sqlerrm);
1235: END IF;
1236: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1237: p_msg_name => G_UNEXPECTED_ERROR,
1238: p_token1 => G_SQLCODE_TOKEN,
1239: p_token1_value => sqlcode,
1240: p_token2 => G_SQLERRM_TOKEN,

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

2118: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
2119: 'Leaving validate_contract_party because of EXCEPTION: ' || sqlerrm);
2120: END IF;
2121:
2122: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2123: p_msg_name => G_UNEXPECTED_ERROR,
2124: p_token1 => G_SQLCODE_TOKEN,
2125: p_token1_value => sqlcode,
2126: p_token2 => G_SQLERRM_TOKEN,

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

2504: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
2505: 'Leaving validate_party_contact because of EXCEPTION: ' || sqlerrm);
2506: END IF;
2507:
2508: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2509: p_msg_name => G_UNEXPECTED_ERROR,
2510: p_token1 => G_SQLCODE_TOKEN,
2511: p_token1_value => sqlcode,
2512: p_token2 => G_SQLERRM_TOKEN,

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

2705: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
2706: 'Leaving populate_import_errors because of EXCEPTION: ' || sqlerrm);
2707: END IF;
2708:
2709: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2710: p_msg_name => G_UNEXPECTED_ERROR,
2711: p_token1 => G_SQLCODE_TOKEN,
2712: p_token1_value => sqlcode,
2713: p_token2 => G_SQLERRM_TOKEN,

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

3066: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
3067: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
3068: END IF;
3069:
3070: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3071: p_msg_name => G_UNEXPECTED_ERROR,
3072: p_token1 => G_SQLCODE_TOKEN,
3073: p_token1_value => sqlcode,
3074: p_token2 => G_SQLERRM_TOKEN,

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

3569: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
3570: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
3571: END IF;
3572:
3573: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3574: p_msg_name => G_UNEXPECTED_ERROR,
3575: p_token1 => G_SQLCODE_TOKEN,
3576: p_token1_value => sqlcode,
3577: p_token2 => G_SQLERRM_TOKEN,

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

4871: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
4872: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
4873: END IF;
4874:
4875: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
4876: p_msg_name => G_UNEXPECTED_ERROR,
4877: p_token1 => G_SQLCODE_TOKEN,
4878: p_token1_value => sqlcode,
4879: p_token2 => G_SQLERRM_TOKEN,

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

5334: CLOSE contract_id_cur ;
5335: END IF;
5336:
5337:
5338: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5339: p_msg_name => G_UNEXPECTED_ERROR,
5340: p_token1 => G_SQLCODE_TOKEN,
5341: p_token1_value => sqlcode,
5342: p_token2 => G_SQLERRM_TOKEN,

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

5483: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
5484: 'Leaving '||l_api_name||' because of EXCEPTION: ' || sqlerrm);
5485: END IF;
5486:
5487: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5488: p_msg_name => G_UNEXPECTED_ERROR,
5489: p_token1 => G_SQLCODE_TOKEN,
5490: p_token1_value => sqlcode,
5491: p_token2 => G_SQLERRM_TOKEN,

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

5682: fnd_log.string(FND_LOG.LEVEL_EXCEPTION, g_module || l_api_name,
5683: 'Leaving delete_import_contract because of EXCEPTION: ' || sqlerrm);
5684: END IF;
5685:
5686: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5687: p_msg_name => G_UNEXPECTED_ERROR,
5688: p_token1 => G_SQLCODE_TOKEN,
5689: p_token1_value => sqlcode,
5690: p_token2 => G_SQLERRM_TOKEN,

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

5760: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5761: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
5762: 'Leaving Function '||l_api_name||' because of EXCEPTION: '||sqlerrm);
5763: END IF;
5764: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
5765: p_msg_name => G_UNEXPECTED_ERROR,
5766: p_token1 => G_SQLCODE_TOKEN,
5767: p_token1_value => sqlcode,
5768: p_token2 => G_SQLERRM_TOKEN,

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

6014: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6015: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
6016: 'Leaving Function '||l_api_name||' because of EXCEPTION: '||sqlerrm);
6017: END IF;
6018: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6019: p_msg_name => G_UNEXPECTED_ERROR,
6020: p_token1 => G_SQLCODE_TOKEN,
6021: p_token1_value => sqlcode,
6022: p_token2 => G_SQLERRM_TOKEN,

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

6097: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6098: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
6099: 'Leaving Function '||l_api_name||' because of EXCEPTION: '||sqlerrm);
6100: END IF;
6101: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6102: p_msg_name => G_UNEXPECTED_ERROR,
6103: p_token1 => G_SQLCODE_TOKEN,
6104: p_token1_value => sqlcode,
6105: p_token2 => G_SQLERRM_TOKEN,

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

6261: END IF;
6262: IF (vendor_email_csr%ISOPEN) THEN
6263: CLOSE vendor_email_csr ;
6264: END IF;
6265: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6266: p_msg_name => G_UNEXPECTED_ERROR,
6267: p_token1 => G_SQLCODE_TOKEN,
6268: p_token1_value => sqlcode,
6269: p_token2 => G_SQLERRM_TOKEN,

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

6425: END IF;
6426: IF (tca_email_csr%ISOPEN) THEN
6427: CLOSE tca_email_csr ;
6428: END IF;
6429: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6430: p_msg_name => G_UNEXPECTED_ERROR,
6431: p_token1 => G_SQLCODE_TOKEN,
6432: p_token1_value => sqlcode,
6433: p_token2 => G_SQLERRM_TOKEN,

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

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

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

6729: IF (l_contract_updatable_csr%ISOPEN) THEN
6730: CLOSE l_contract_updatable_csr ;
6731: END IF;
6732: x_return_status := FND_API.G_RET_STS_ERROR;
6733: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6734: p_msg_name => G_UNEXPECTED_ERROR,
6735: p_token1 => G_SQLCODE_TOKEN,
6736: p_token1_value => sqlcode,
6737: p_token2 => G_SQLERRM_TOKEN,

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

6839: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6840: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
6841: 'Leaving Function can_update because of EXCEPTION: '||sqlerrm);
6842: END IF;
6843: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
6844: p_msg_name => G_UNEXPECTED_ERROR,
6845: p_token1 => G_SQLCODE_TOKEN,
6846: p_token1_value => sqlcode,
6847: p_token2 => G_SQLERRM_TOKEN,

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

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

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

7237: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
7238: g_module || 'check_contract_doc_access.exception',
7239: '117: Leaving check_contract_access because of EXCEPTION: ' || sqlerrm);
7240: END IF;
7241: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7242: p_msg_name => G_UNEXPECTED_ERROR,
7243: p_token1 => G_SQLCODE_TOKEN,
7244: p_token1_value => sqlcode,
7245: p_token2 => G_SQLERRM_TOKEN,

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

7300: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7301: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
7302: 'Leaving Function get_accessible_ous because of EXCEPTION: '||sqlerrm);
7303: END IF;
7304: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7305: p_msg_name => G_UNEXPECTED_ERROR,
7306: p_token1 => G_SQLCODE_TOKEN,
7307: p_token1_value => sqlcode,
7308: p_token2 => G_SQLERRM_TOKEN,

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

7380: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7381: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
7382: 'Leaving Function get_quote_access because of EXCEPTION: '||sqlerrm);
7383: END IF;
7384: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7385: p_msg_name => G_UNEXPECTED_ERROR,
7386: p_token1 => G_SQLCODE_TOKEN,
7387: p_token1_value => sqlcode,
7388: p_token2 => G_SQLERRM_TOKEN,

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

7445: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
7446: 'Leaving Function contract_terms_disabled_yn because of EXCEPTION: '||sqlerrm);
7447: END IF;
7448:
7449: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
7450: p_msg_name => G_UNEXPECTED_ERROR,
7451: p_token1 => G_SQLCODE_TOKEN,
7452: p_token1_value => sqlcode,
7453: p_token2 => G_SQLERRM_TOKEN,