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

Line 88: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);

84: open c_get_doctype;
85: fetch c_get_doctype into l_doc_type;
86: close c_get_doctype;
87:
88: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
89: OPEN party_csr;
90: FETCH party_csr INTO party_rec;
91: IF (l_doc_type not in ('REP_SBCR', 'REP_ACQ', 'REP_CCT') )THEN
92:

Line 99: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_NO_EXT_PARTY,l_doc_type);

95: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, G_MODULE||l_api_name,
96: 'External Party is not found');
97: END IF;
98: -- Set the Qa Table index.
99: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_NO_EXT_PARTY,l_doc_type);
100:
101:
102:
103: l_OKC_REP_NO_EXT_PARTY := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, l_resolved_msg_name, p_token1 => 'HDR_TOKEN',

Line 106: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_NO_EXT_PARTY_S,l_doc_type);

102:
103: l_OKC_REP_NO_EXT_PARTY := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, l_resolved_msg_name, p_token1 => 'HDR_TOKEN',
104: p_token1_value => l_resolved_token) ;
105:
106: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_NO_EXT_PARTY_S,l_doc_type);
107:
108:
109: l_OKC_REP_NO_EXT_PARTY_S := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, l_resolved_msg_name, p_token1 => 'HDR_TOKEN',
110: p_token1_value => l_resolved_token) ;

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

173: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
174: G_MODULE || l_api_name,
175: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party because of EXCEPTION: ' || sqlerrm);
176: END IF;
177: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
178: p_msg_name => G_UNEXPECTED_ERROR,
179: p_token1 => G_SQLCODE_TOKEN,
180: p_token1_value => sqlcode,
181: p_token2 => G_SQLERRM_TOKEN,

Line 273: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);

269: open c_get_doctype;
270: fetch c_get_doctype into l_doc_type;
271: close c_get_doctype;
272:
273: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
274:
275: -- Initialize API return status to success
276: x_return_status := FND_API.G_RET_STS_SUCCESS;
277:

Line 284: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_NO_EFF_DATE,l_doc_type);

280: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
281: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, G_MODULE||l_api_name,
282: 'Effective Date is NULL');
283: END IF;
284: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_NO_EFF_DATE,l_doc_type);
285:
286:
287: l_OKC_REP_NO_EFF_DATE := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, l_resolved_msg_name, p_token1 => 'HDR_TOKEN',
288: p_token1_value => l_resolved_token) ;

Line 290: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_NO_EFF_DATE_S,l_doc_type);

286:
287: l_OKC_REP_NO_EFF_DATE := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, l_resolved_msg_name, p_token1 => 'HDR_TOKEN',
288: p_token1_value => l_resolved_token) ;
289:
290: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_NO_EFF_DATE_S,l_doc_type);
291:
292:
293: l_OKC_REP_NO_EFF_DATE_S := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, l_resolved_msg_name, p_token1 => 'HDR_TOKEN',
294: p_token1_value => l_resolved_token) ;

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

344: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
345: G_MODULE || l_api_name,
346: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date because of EXCEPTION: ' || sqlerrm);
347: END IF;
348: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
349: p_msg_name => G_UNEXPECTED_ERROR,
350: p_token1 => G_SQLCODE_TOKEN,
351: p_token1_value => sqlcode,
352: p_token2 => G_SQLERRM_TOKEN,

Line 440: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);

436: open c_get_doctype;
437: fetch c_get_doctype into l_doc_type;
438: close c_get_doctype;
439:
440: l_resolved_token := OKC_API.resolve_hdr_token(l_doc_type);
441:
442: -- Initialize API return status to success
443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:

Line 452: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_EXPIRED,l_doc_type);

448: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT, G_MODULE||l_api_name,
449: 'Contract expired');
450: END IF;
451:
452: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_EXPIRED,l_doc_type);
453:
454:
455: l_OKC_REP_EXPIRED := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, l_resolved_msg_name, p_token1 => 'HDR_TOKEN',
456: p_token1_value => l_resolved_token) ;

Line 458: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_EXPIRED_SD,l_doc_type);

454:
455: l_OKC_REP_EXPIRED := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, l_resolved_msg_name, p_token1 => 'HDR_TOKEN',
456: p_token1_value => l_resolved_token) ;
457:
458: l_resolved_msg_name := OKC_API.resolve_message(G_OKC_REP_EXPIRED_SD,l_doc_type);
459:
460:
461: l_OKC_REP_EXPIRED_SD := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, l_resolved_msg_name, p_token1 => 'HDR_TOKEN',
462: p_token1_value => l_resolved_token) ;

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

511: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
512: G_MODULE || l_api_name,
513: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check because of EXCEPTION: ' || sqlerrm);
514: END IF;
515: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
516: p_msg_name => G_UNEXPECTED_ERROR,
517: p_token1 => G_SQLCODE_TOKEN,
518: p_token1_value => sqlcode,
519: p_token2 => G_SQLERRM_TOKEN,

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

801: END IF;
802: IF (contract_type_csr%ISOPEN) THEN
803: CLOSE contract_type_csr ;
804: END IF;
805: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
806: p_msg_name => G_UNEXPECTED_ERROR,
807: p_token1 => G_SQLCODE_TOKEN,
808: p_token1_value => sqlcode,
809: p_token2 => G_SQLERRM_TOKEN,

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

967: END IF;
968: IF (contract_type_csr%ISOPEN) THEN
969: CLOSE contract_type_csr ;
970: END IF;
971: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
972: p_msg_name => G_UNEXPECTED_ERROR,
973: p_token1 => G_SQLCODE_TOKEN,
974: p_token1_value => sqlcode,
975: p_token2 => G_SQLERRM_TOKEN,

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

1170: END IF;
1171: IF (vendor_csr%ISOPEN) THEN
1172: CLOSE vendor_csr ;
1173: END IF;
1174: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1175: p_msg_name => G_UNEXPECTED_ERROR,
1176: p_token1 => G_SQLCODE_TOKEN,
1177: p_token1_value => sqlcode,
1178: p_token2 => G_SQLERRM_TOKEN,

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

1465: END IF;
1466: IF (employee_name_csr%ISOPEN) THEN
1467: CLOSE employee_name_csr ;
1468: END IF;
1469: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1470: p_msg_name => G_UNEXPECTED_ERROR,
1471: p_token1 => G_SQLCODE_TOKEN,
1472: p_token1_value => sqlcode,
1473: p_token2 => G_SQLERRM_TOKEN,

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

1632: END IF;
1633: IF (contact_role_csr%ISOPEN) THEN
1634: CLOSE contact_role_csr ;
1635: END IF;
1636: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1637: p_msg_name => G_UNEXPECTED_ERROR,
1638: p_token1 => G_SQLCODE_TOKEN,
1639: p_token1_value => sqlcode,
1640: p_token2 => G_SQLERRM_TOKEN,

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

1798: END IF;
1799: IF (risk_event_csr%ISOPEN) THEN
1800: CLOSE risk_event_csr ;
1801: END IF;
1802: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1803: p_msg_name => G_UNEXPECTED_ERROR,
1804: p_token1 => G_SQLCODE_TOKEN,
1805: p_token1_value => sqlcode,
1806: p_token2 => G_SQLERRM_TOKEN,

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

2180: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2181: G_MODULE || l_api_name,
2182: 'Leaving OKC_REP_QA_CHECK_PVT.contract_type_spec_validat because of EXCEPTION: ' || sqlerrm);
2183: END IF;
2184: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2185: p_msg_name => G_UNEXPECTED_ERROR,
2186: p_token1 => G_SQLCODE_TOKEN,
2187: p_token1_value => sqlcode,
2188: p_token2 => G_SQLERRM_TOKEN,

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

2356: IF (contract_type_csr%ISOPEN) THEN
2357: CLOSE contract_type_csr ;
2358: END IF;
2359:
2360: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2361: p_msg_name => G_UNEXPECTED_ERROR,
2362: p_token1 => G_SQLCODE_TOKEN,
2363: p_token1_value => sqlcode,
2364: p_token2 => G_SQLERRM_TOKEN,

Line 2463: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

2459: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2460: 'Contract Id is: ' || p_contract_id);
2461: END IF;
2462: x_return_status := G_RET_STS_SUCCESS;
2463: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
2464: p_init_msg_list,
2465: '_PVT',
2466: x_return_status);
2467:

Line 2468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2464: p_init_msg_list,
2465: '_PVT',
2466: x_return_status);
2467:
2468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2471: RAISE OKC_API.G_EXCEPTION_ERROR;
2472: END IF;

Line 2469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2465: '_PVT',
2466: x_return_status);
2467:
2468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2471: RAISE OKC_API.G_EXCEPTION_ERROR;
2472: END IF;
2473:

Line 2470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2466: x_return_status);
2467:
2468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2471: RAISE OKC_API.G_EXCEPTION_ERROR;
2472: END IF;
2473:
2474: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2471: RAISE OKC_API.G_EXCEPTION_ERROR;

2467:
2468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2470: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2471: RAISE OKC_API.G_EXCEPTION_ERROR;
2472: END IF;
2473:
2474: -- Initialize message list if p_init_msg_list is set to TRUE.
2475: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2498: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2495: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2496: 'Completed OKC_REP_QA_CHECK_PVT.check_no_exteral_party with returned status: ' || x_return_status);
2497: END IF;
2498: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2501: RAISE OKC_API.G_EXCEPTION_ERROR;
2502: END IF;

Line 2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2495: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2496: 'Completed OKC_REP_QA_CHECK_PVT.check_no_exteral_party with returned status: ' || x_return_status);
2497: END IF;
2498: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2501: RAISE OKC_API.G_EXCEPTION_ERROR;
2502: END IF;
2503:

Line 2500: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2496: 'Completed OKC_REP_QA_CHECK_PVT.check_no_exteral_party with returned status: ' || x_return_status);
2497: END IF;
2498: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2501: RAISE OKC_API.G_EXCEPTION_ERROR;
2502: END IF;
2503:
2504: -- Get effective_date column

Line 2501: RAISE OKC_API.G_EXCEPTION_ERROR;

2497: END IF;
2498: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2500: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2501: RAISE OKC_API.G_EXCEPTION_ERROR;
2502: END IF;
2503:
2504: -- Get effective_date column
2505: OPEN contract_csr;

Line 2534: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2530: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2531: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2532: 'Completed OKC_REP_QA_CHECK_PVT.validate_E_Signature with returned status: ' || x_return_status);
2533: END IF;
2534: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2536: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2537: RAISE OKC_API.G_EXCEPTION_ERROR;
2538: END IF;

Line 2535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2531: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2532: 'Completed OKC_REP_QA_CHECK_PVT.validate_E_Signature with returned status: ' || x_return_status);
2533: END IF;
2534: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2536: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2537: RAISE OKC_API.G_EXCEPTION_ERROR;
2538: END IF;
2539:

Line 2536: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2532: 'Completed OKC_REP_QA_CHECK_PVT.validate_E_Signature with returned status: ' || x_return_status);
2533: END IF;
2534: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2536: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2537: RAISE OKC_API.G_EXCEPTION_ERROR;
2538: END IF;
2539:
2540: END IF;

Line 2537: RAISE OKC_API.G_EXCEPTION_ERROR;

2533: END IF;
2534: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2535: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2536: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2537: RAISE OKC_API.G_EXCEPTION_ERROR;
2538: END IF;
2539:
2540: END IF;
2541:

Line 2571: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2567: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2568: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2569: 'Completed OKC_REP_QA_CHECK_PVT.check_no_eff_date with returned status: ' || x_return_status);
2570: END IF;
2571: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2574: RAISE OKC_API.G_EXCEPTION_ERROR;
2575: END IF;

Line 2572: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2568: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2569: 'Completed OKC_REP_QA_CHECK_PVT.check_no_eff_date with returned status: ' || x_return_status);
2570: END IF;
2571: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2574: RAISE OKC_API.G_EXCEPTION_ERROR;
2575: END IF;
2576:

Line 2573: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2569: 'Completed OKC_REP_QA_CHECK_PVT.check_no_eff_date with returned status: ' || x_return_status);
2570: END IF;
2571: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2574: RAISE OKC_API.G_EXCEPTION_ERROR;
2575: END IF;
2576:
2577: -- Get expiration_date column

Line 2574: RAISE OKC_API.G_EXCEPTION_ERROR;

2570: END IF;
2571: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2574: RAISE OKC_API.G_EXCEPTION_ERROR;
2575: END IF;
2576:
2577: -- Get expiration_date column
2578: OPEN contract_exp_csr;

Line 2615: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2611: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2612: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2613: 'Completed OKC_REP_QA_CHECK_PVT.check_expiry_check with returned status: ' || x_return_status);
2614: END IF;
2615: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2617: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2618: RAISE OKC_API.G_EXCEPTION_ERROR;
2619: END IF;

Line 2616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2612: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2613: 'Completed OKC_REP_QA_CHECK_PVT.check_expiry_check with returned status: ' || x_return_status);
2614: END IF;
2615: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2617: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2618: RAISE OKC_API.G_EXCEPTION_ERROR;
2619: END IF;
2620:

Line 2617: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2613: 'Completed OKC_REP_QA_CHECK_PVT.check_expiry_check with returned status: ' || x_return_status);
2614: END IF;
2615: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2617: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2618: RAISE OKC_API.G_EXCEPTION_ERROR;
2619: END IF;
2620:
2621: --Validate contract type

Line 2618: RAISE OKC_API.G_EXCEPTION_ERROR;

2614: END IF;
2615: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2616: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2617: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2618: RAISE OKC_API.G_EXCEPTION_ERROR;
2619: END IF;
2620:
2621: --Validate contract type
2622: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2640: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2636: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2637: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2638: 'Completed OKC_REP_QA_CHECK_PVT.validate_contract_type with returned status: ' || x_return_status);
2639: END IF;
2640: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2643: RAISE OKC_API.G_EXCEPTION_ERROR;
2644: END IF;

Line 2641: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2637: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2638: 'Completed OKC_REP_QA_CHECK_PVT.validate_contract_type with returned status: ' || x_return_status);
2639: END IF;
2640: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2643: RAISE OKC_API.G_EXCEPTION_ERROR;
2644: END IF;
2645:

Line 2642: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2638: 'Completed OKC_REP_QA_CHECK_PVT.validate_contract_type with returned status: ' || x_return_status);
2639: END IF;
2640: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2643: RAISE OKC_API.G_EXCEPTION_ERROR;
2644: END IF;
2645:
2646: --Validate approval Workflow

Line 2643: RAISE OKC_API.G_EXCEPTION_ERROR;

2639: END IF;
2640: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2641: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2643: RAISE OKC_API.G_EXCEPTION_ERROR;
2644: END IF;
2645:
2646: --Validate approval Workflow
2647: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2668: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2664: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2665: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2666: 'Completed OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow with returned status: ' || x_return_status);
2667: END IF;
2668: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2670: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2671: RAISE OKC_API.G_EXCEPTION_ERROR;
2672: END IF;

Line 2669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2665: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2666: 'Completed OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow with returned status: ' || x_return_status);
2667: END IF;
2668: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2670: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2671: RAISE OKC_API.G_EXCEPTION_ERROR;
2672: END IF;
2673:

Line 2670: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2666: 'Completed OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow with returned status: ' || x_return_status);
2667: END IF;
2668: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2670: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2671: RAISE OKC_API.G_EXCEPTION_ERROR;
2672: END IF;
2673:
2674: -- Validate Parties

Line 2671: RAISE OKC_API.G_EXCEPTION_ERROR;

2667: END IF;
2668: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2669: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2670: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2671: RAISE OKC_API.G_EXCEPTION_ERROR;
2672: END IF;
2673:
2674: -- Validate Parties
2675: -- Loop through all the external parties and check if these are still valid.

Line 2700: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2696: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2697: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2698: 'Completed OKC_REP_QA_CHECK_PVT.validate_external_party with returned status: ' || x_return_status);
2699: END IF;
2700: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2702: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2703: RAISE OKC_API.G_EXCEPTION_ERROR;
2704: END IF;

Line 2701: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2697: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2698: 'Completed OKC_REP_QA_CHECK_PVT.validate_external_party with returned status: ' || x_return_status);
2699: END IF;
2700: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2702: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2703: RAISE OKC_API.G_EXCEPTION_ERROR;
2704: END IF;
2705: END LOOP;

Line 2702: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2698: 'Completed OKC_REP_QA_CHECK_PVT.validate_external_party with returned status: ' || x_return_status);
2699: END IF;
2700: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2702: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2703: RAISE OKC_API.G_EXCEPTION_ERROR;
2704: END IF;
2705: END LOOP;
2706:

Line 2703: RAISE OKC_API.G_EXCEPTION_ERROR;

2699: END IF;
2700: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2702: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2703: RAISE OKC_API.G_EXCEPTION_ERROR;
2704: END IF;
2705: END LOOP;
2706:
2707: -- Validate contacts and contact roles

Line 2737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2733: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2734: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2735: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact with returned status: ' || x_return_status);
2736: END IF;
2737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2740: RAISE OKC_API.G_EXCEPTION_ERROR;
2741: END IF;

Line 2738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2734: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2735: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact with returned status: ' || x_return_status);
2736: END IF;
2737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2740: RAISE OKC_API.G_EXCEPTION_ERROR;
2741: END IF;
2742:

Line 2739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2735: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact with returned status: ' || x_return_status);
2736: END IF;
2737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2740: RAISE OKC_API.G_EXCEPTION_ERROR;
2741: END IF;
2742:
2743: -- Validate contact role

Line 2740: RAISE OKC_API.G_EXCEPTION_ERROR;

2736: END IF;
2737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2738: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2739: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2740: RAISE OKC_API.G_EXCEPTION_ERROR;
2741: END IF;
2742:
2743: -- Validate contact role
2744: validate_contact_role (

Line 2758: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2754: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2755: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2756: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact_role with returned status: ' || x_return_status);
2757: END IF;
2758: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2761: RAISE OKC_API.G_EXCEPTION_ERROR;
2762: END IF;

Line 2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2755: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2756: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact_role with returned status: ' || x_return_status);
2757: END IF;
2758: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2761: RAISE OKC_API.G_EXCEPTION_ERROR;
2762: END IF;
2763: END LOOP;

Line 2760: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2756: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact_role with returned status: ' || x_return_status);
2757: END IF;
2758: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2761: RAISE OKC_API.G_EXCEPTION_ERROR;
2762: END IF;
2763: END LOOP;
2764:

Line 2761: RAISE OKC_API.G_EXCEPTION_ERROR;

2757: END IF;
2758: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2759: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2760: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2761: RAISE OKC_API.G_EXCEPTION_ERROR;
2762: END IF;
2763: END LOOP;
2764:
2765:

Line 2789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2785: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2786: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2787: 'Completed OKC_REP_QA_CHECK_PVT.validate_risk_event with returned status: ' || x_return_status);
2788: END IF;
2789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2792: RAISE OKC_API.G_EXCEPTION_ERROR;
2793: END IF;

Line 2790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2786: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2787: 'Completed OKC_REP_QA_CHECK_PVT.validate_risk_event with returned status: ' || x_return_status);
2788: END IF;
2789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2792: RAISE OKC_API.G_EXCEPTION_ERROR;
2793: END IF;
2794: END LOOP;

Line 2791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2787: 'Completed OKC_REP_QA_CHECK_PVT.validate_risk_event with returned status: ' || x_return_status);
2788: END IF;
2789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2792: RAISE OKC_API.G_EXCEPTION_ERROR;
2793: END IF;
2794: END LOOP;
2795:

Line 2792: RAISE OKC_API.G_EXCEPTION_ERROR;

2788: END IF;
2789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2790: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2791: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2792: RAISE OKC_API.G_EXCEPTION_ERROR;
2793: END IF;
2794: END LOOP;
2795:
2796: --Document Type Specific validations

Line 2815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2811: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2812: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2813: 'Completed OKC_REP_QA_CHECK_PVT.contract_type_spec_validat with returned status: ' || x_return_status);
2814: END IF;
2815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2818: RAISE OKC_API.G_EXCEPTION_ERROR;
2819: END IF;

Line 2816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2812: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2813: 'Completed OKC_REP_QA_CHECK_PVT.contract_type_spec_validat with returned status: ' || x_return_status);
2814: END IF;
2815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2818: RAISE OKC_API.G_EXCEPTION_ERROR;
2819: END IF;
2820:

Line 2817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2813: 'Completed OKC_REP_QA_CHECK_PVT.contract_type_spec_validat with returned status: ' || x_return_status);
2814: END IF;
2815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2818: RAISE OKC_API.G_EXCEPTION_ERROR;
2819: END IF;
2820:
2821: --Call Custom Code hook for additional validations

Line 2818: RAISE OKC_API.G_EXCEPTION_ERROR;

2814: END IF;
2815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2817: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2818: RAISE OKC_API.G_EXCEPTION_ERROR;
2819: END IF;
2820:
2821: --Call Custom Code hook for additional validations
2822:

Line 2841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2837: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
2838: 'Completed OKC_REP_VAL_CODE_HOOK.CUSTOM_CONT_VALIDATE with returned status: ' || x_return_status);
2839: END IF;
2840:
2841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2843: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2844: RAISE OKC_API.G_EXCEPTION_ERROR;
2845: END IF;

Line 2842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2838: 'Completed OKC_REP_VAL_CODE_HOOK.CUSTOM_CONT_VALIDATE with returned status: ' || x_return_status);
2839: END IF;
2840:
2841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2843: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2844: RAISE OKC_API.G_EXCEPTION_ERROR;
2845: END IF;
2846:

Line 2843: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2839: END IF;
2840:
2841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2843: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2844: RAISE OKC_API.G_EXCEPTION_ERROR;
2845: END IF;
2846:
2847: -- Close all cursors.

Line 2844: RAISE OKC_API.G_EXCEPTION_ERROR;

2840:
2841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2843: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2844: RAISE OKC_API.G_EXCEPTION_ERROR;
2845: END IF;
2846:
2847: -- Close all cursors.
2848: CLOSE contract_csr;

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

2889: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2890: G_MODULE || l_api_name,
2891: 'Leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa because of EXCEPTION: ' || sqlerrm);
2892: END IF;
2893: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
2894: p_msg_name => G_UNEXPECTED_ERROR,
2895: p_token1 => G_SQLCODE_TOKEN,
2896: p_token1_value => sqlcode,
2897: p_token2 => G_SQLERRM_TOKEN,

Line 2975: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

2971: 'Contract Id is: ' || p_contract_id);
2972: END IF;
2973: x_qa_return_status := G_QA_STS_SUCCESS;
2974: x_return_status := G_RET_STS_SUCCESS;
2975: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
2976: p_init_msg_list,
2977: '_PVT',
2978: x_return_status);
2979:

Line 2980: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2976: p_init_msg_list,
2977: '_PVT',
2978: x_return_status);
2979:
2980: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2981: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2982: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2983: RAISE OKC_API.G_EXCEPTION_ERROR;
2984: END IF;

Line 2981: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2977: '_PVT',
2978: x_return_status);
2979:
2980: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2981: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2982: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2983: RAISE OKC_API.G_EXCEPTION_ERROR;
2984: END IF;
2985:

Line 2982: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2978: x_return_status);
2979:
2980: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2981: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2982: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2983: RAISE OKC_API.G_EXCEPTION_ERROR;
2984: END IF;
2985:
2986: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2983: RAISE OKC_API.G_EXCEPTION_ERROR;

2979:
2980: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2981: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2982: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2983: RAISE OKC_API.G_EXCEPTION_ERROR;
2984: END IF;
2985:
2986: -- Initialize message list if p_init_msg_list is set to TRUE.
2987: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

2996: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
2997: G_MODULE||l_api_name,
2998: 'Invalid Contract Id: '|| p_contract_id);
2999: END IF;
3000: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3001: p_msg_name => G_INVALID_CONTRACT_ID_MSG,
3002: p_token1 => G_CONTRACT_ID_TOKEN,
3003: p_token1_value => to_char(p_contract_id));
3004: RAISE FND_API.G_EXC_ERROR;

Line 3039: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3035: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
3036: 'Completed OKC_TERMS_QA_GRP.QA_Doc with returned status: ' || x_return_status);
3037: END IF;
3038:
3039: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3040: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3041: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3042: RAISE OKC_API.G_EXCEPTION_ERROR;
3043: END IF;

Line 3040: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3036: 'Completed OKC_TERMS_QA_GRP.QA_Doc with returned status: ' || x_return_status);
3037: END IF;
3038:
3039: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3040: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3041: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3042: RAISE OKC_API.G_EXCEPTION_ERROR;
3043: END IF;
3044: -- Repository Enhancement 12.1 Ends (For Validate Action)

Line 3041: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3037: END IF;
3038:
3039: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3040: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3041: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3042: RAISE OKC_API.G_EXCEPTION_ERROR;
3043: END IF;
3044: -- Repository Enhancement 12.1 Ends (For Validate Action)
3045:

Line 3042: RAISE OKC_API.G_EXCEPTION_ERROR;

3038:
3039: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3040: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3041: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3042: RAISE OKC_API.G_EXCEPTION_ERROR;
3043: END IF;
3044: -- Repository Enhancement 12.1 Ends (For Validate Action)
3045:
3046: -- Make call for Repository QA check

Line 3065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3061: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
3062: 'Completed OKC_REP_QA_CHECK_PVT.validate_repository_for_qa with returned status: ' || x_return_status);
3063: END IF;
3064: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3066: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3067: RAISE OKC_API.G_EXCEPTION_ERROR;
3068: END IF;
3069:

Line 3067: RAISE OKC_API.G_EXCEPTION_ERROR;

3063: END IF;
3064: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3065: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3066: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3067: RAISE OKC_API.G_EXCEPTION_ERROR;
3068: END IF;
3069:
3070: -- Make call for deliverables QA check
3071:

Line 3099: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3095: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3096: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
3097: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
3098: END IF;
3099: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_ERROR;
3103: END IF;

Line 3100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3096: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT , G_MODULE||l_api_name,
3097: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
3098: END IF;
3099: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_ERROR;
3103: END IF;
3104:

Line 3101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3097: 'Completed OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa with returned status: ' || x_return_status);
3098: END IF;
3099: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_ERROR;
3103: END IF;
3104:
3105: --------------------------------------------

Line 3102: RAISE OKC_API.G_EXCEPTION_ERROR;

3098: END IF;
3099: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3102: RAISE OKC_API.G_EXCEPTION_ERROR;
3103: END IF;
3104:
3105: --------------------------------------------
3106: -- VALIDATIONS are done for Repository and Deliverables.

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

3221: IF (contract_csr%ISOPEN) THEN
3222: CLOSE contract_csr ;
3223: END IF;
3224: x_return_status := G_RET_STS_UNEXP_ERROR;
3225: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3226: p_msg_name => G_UNEXPECTED_ERROR,
3227: p_token1 => G_SQLCODE_TOKEN,
3228: p_token1_value => sqlcode,
3229: p_token2 => G_SQLERRM_TOKEN,

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

3393: END IF;
3394:
3395: x_return_status := G_RET_STS_UNEXP_ERROR;
3396:
3397: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
3398: p_msg_name => G_UNEXPECTED_ERROR,
3399: p_token1 => G_SQLCODE_TOKEN,
3400: p_token1_value => sqlcode,
3401: p_token2 => G_SQLERRM_TOKEN,