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 FND_API

Line 14: -- Default = FND_API.G_FALSE

10: --Pre-reqs : None.
11: --Parameters :
12: --IN : p_api_version IN NUMBER Required
13: -- : p_init_msg_list IN VARCHAR2 Optional
14: -- Default = FND_API.G_FALSE
15: -- : p_contract_id IN NUMBER Required
16: -- ID of the contract to be checked
17: -- : p_severity IN VARCHAR2 Required
18: -- Severity level for this check. Possible values are ERROR, WARNING.

Line 73: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

69: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
70: 'Severity level is: ' || p_severity);
71: END IF;
72: -- Standard call to check for call compatibility.
73: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

70: 'Severity level is: ' || p_severity);
71: END IF;
72: -- Standard call to check for call compatibility.
73: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF FND_API.to_Boolean( p_init_msg_list ) THEN
78: FND_MSG_PUB.initialize;

Line 77: IF FND_API.to_Boolean( p_init_msg_list ) THEN

73: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END IF;
76: -- Initialize message list if p_init_msg_list is set to TRUE.
77: IF FND_API.to_Boolean( p_init_msg_list ) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API return status to success

Line 82: x_return_status := FND_API.G_RET_STS_SUCCESS;

78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API return status to success
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83:
84: open c_get_doctype;
85: fetch c_get_doctype into l_doc_type;
86: close c_get_doctype;

Line 139: WHEN FND_API.G_EXC_ERROR THEN

135: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
136: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party');
137: END IF;
138: EXCEPTION
139: WHEN FND_API.G_EXC_ERROR THEN
140: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
142: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party with G_EXC_ERROR');
143: END IF;

Line 154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

150: p_count => x_msg_count,
151: p_data => x_msg_data
152: );
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
156: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
157: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party with G_EXC_UNEXPECTED_ERROR');
158: END IF;

Line 206: -- Default = FND_API.G_FALSE

202: --Pre-reqs : None.
203: --Parameters :
204: --IN : p_api_version IN NUMBER Required
205: -- : p_init_msg_list IN VARCHAR2 Optional
206: -- Default = FND_API.G_FALSE
207: -- : p_effective_date IN NUMBER Required
208: -- Effective date of the contract to be checked
209: -- : p_severity IN VARCHAR2 Required
210: -- Severity level for this check. Possible values are ERROR, WARNING.

Line 261: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

257: 'Severity level is: ' || p_severity);
258: END IF;
259:
260: -- Standard call to check for call compatibility.
261: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: END IF;
259:
260: -- Standard call to check for call compatibility.
261: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
266: FND_MSG_PUB.initialize;

Line 265: IF FND_API.to_Boolean( p_init_msg_list ) THEN

261: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
266: FND_MSG_PUB.initialize;
267: END IF;
268:
269: open c_get_doctype;

Line 276: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
278: --Check for effective date
279: IF (p_effective_date IS NULL) THEN
280: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 317: WHEN FND_API.G_EXC_ERROR THEN

313: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
314: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date');
315: END IF;
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
320: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date with G_EXC_ERROR');
321: END IF;

Line 329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

325: p_count => x_msg_count,
326: p_data => x_msg_data
327: );
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
331: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
332: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date with G_EXC_UNEXPECTED_ERROR');
333: END IF;

Line 369: -- Default = FND_API.G_FALSE

365: --Pre-reqs : None.
366: --Parameters :
367: --IN : p_api_version IN NUMBER Required
368: -- : p_init_msg_list IN VARCHAR2 Optional
369: -- Default = FND_API.G_FALSE
370: -- : p_expiration_date IN NUMBER Required
371: -- Expiration date of the contract to be checked
372: -- : p_severity IN VARCHAR2 Required
373: -- Severity level for this check. Possible values are ERROR, WARNING.

Line 428: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

424: 'Severity level is: ' || p_severity);
425: END IF;
426:
427: -- Standard call to check for call compatibility.
428: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: -- Initialize message list if p_init_msg_list is set to TRUE.
432: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

425: END IF;
426:
427: -- Standard call to check for call compatibility.
428: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: -- Initialize message list if p_init_msg_list is set to TRUE.
432: IF FND_API.to_Boolean( p_init_msg_list ) THEN
433: FND_MSG_PUB.initialize;

Line 432: IF FND_API.to_Boolean( p_init_msg_list ) THEN

428: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430: END IF;
431: -- Initialize message list if p_init_msg_list is set to TRUE.
432: IF FND_API.to_Boolean( p_init_msg_list ) THEN
433: FND_MSG_PUB.initialize;
434: END IF;
435:
436: open c_get_doctype;

Line 443: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
445: --Check for effective date
446: IF (p_expiration_date <= SYSDATE ) THEN
447: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 484: WHEN FND_API.G_EXC_ERROR THEN

480: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
481: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check');
482: END IF;
483: EXCEPTION
484: WHEN FND_API.G_EXC_ERROR THEN
485: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
487: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check with G_EXC_ERROR');
488: END IF;

Line 496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );
495:
496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
498: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
499: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check with G_EXC_UNEXPECTED_ERROR');
500: END IF;

Line 538: -- Default = FND_API.G_FALSE

534: --Pre-reqs : None.
535: --Parameters :
536: --IN : p_api_version IN NUMBER Required
537: -- : p_init_msg_list IN VARCHAR2 Optional
538: -- Default = FND_API.G_FALSE
539: -- : p_contract_type IN NUMBER Required
540: -- Contract type to be validated
541: -- : p_severity IN VARCHAR2 Required
542: -- Severity level for this check. Possible values are ERROR, WARNING.

Line 635: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

631: 'Severity level is: ' || p_severity);
632: END IF;
633:
634: -- Standard call to check for call compatibility.
635: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

632: END IF;
633:
634: -- Standard call to check for call compatibility.
635: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list ) THEN
640: FND_MSG_PUB.initialize;

Line 639: IF FND_API.to_Boolean( p_init_msg_list ) THEN

635: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
636: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
637: END IF;
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list ) THEN
640: FND_MSG_PUB.initialize;
641: END IF;
642:
643: -- Initialize API return status to success

Line 644: x_return_status := FND_API.G_RET_STS_SUCCESS;

640: FND_MSG_PUB.initialize;
641: END IF;
642:
643: -- Initialize API return status to success
644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645: l_valid_E_sign_flag := 'Y';
646:
647: OPEN contacts_csr;
648: FETCH contacts_csr INTO l_contact_cnt;

Line 658: RAISE FND_API.G_EXC_ERROR;

654: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
655: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
656: G_MODULE||l_api_name, 'Contract Type: '|| p_contract_type || ' does not exist');
657: END IF;
658: RAISE FND_API.G_EXC_ERROR;
659: END IF; -- contract_type_csr%NOTFOUND
660:
661: IF contract_type_rec.signature_workflow_name IS NULL THEN
662:

Line 768: WHEN FND_API.G_EXC_ERROR THEN

764: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
765: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type');
766: END IF;
767: EXCEPTION
768: WHEN FND_API.G_EXC_ERROR THEN
769: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
770: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
771: 'Leaving OKC_REP_QA_CHECK_PVT.validate_E_Signature with G_EXC_ERROR');
772: END IF;

Line 782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

778: p_count => x_msg_count,
779: p_data => x_msg_data
780: );
781:
782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
783: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
784: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
785: 'Leaving OKC_REP_QA_CHECK_PVT.validate_E_Signature with G_EXC_UNEXPECTED_ERROR');
786: END IF;

Line 830: -- Default = FND_API.G_FALSE

826: --Pre-reqs : None.
827: --Parameters :
828: --IN : p_api_version IN NUMBER Required
829: -- : p_init_msg_list IN VARCHAR2 Optional
830: -- Default = FND_API.G_FALSE
831: -- : p_contract_type IN NUMBER Required
832: -- Contract type to be validated
833: -- : p_severity IN VARCHAR2 Required
834: -- Severity level for this check. Possible values are ERROR, WARNING.

Line 876: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

872: 'Severity level is: ' || p_severity);
873: END IF;
874:
875: -- Standard call to check for call compatibility.
876: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

873: END IF;
874:
875: -- Standard call to check for call compatibility.
876: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
881: FND_MSG_PUB.initialize;

Line 880: IF FND_API.to_Boolean( p_init_msg_list ) THEN

876: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
881: FND_MSG_PUB.initialize;
882: END IF;
883:
884: -- Initialize API return status to success

Line 885: x_return_status := FND_API.G_RET_STS_SUCCESS;

881: FND_MSG_PUB.initialize;
882: END IF;
883:
884: -- Initialize API return status to success
885: x_return_status := FND_API.G_RET_STS_SUCCESS;
886: l_valid_contract_type_flag := 'Y';
887:
888: OPEN contract_type_csr;
889: FETCH contract_type_csr INTO contract_type_rec;

Line 895: RAISE FND_API.G_EXC_ERROR;

891: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
892: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
893: G_MODULE||l_api_name, 'Contract Type: '|| p_contract_type || ' does not exist');
894: END IF;
895: RAISE FND_API.G_EXC_ERROR;
896: END IF; -- contract_type_csr%NOTFOUND
897: l_contract_type_name := contract_type_rec.name;
898: IF (sysdate BETWEEN nvl(contract_type_rec.start_date, sysdate) AND nvl(contract_type_rec.end_date, sysdate)) THEN
899: l_valid_contract_type_flag := 'Y';

Line 934: WHEN FND_API.G_EXC_ERROR THEN

930: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
931: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type');
932: END IF;
933: EXCEPTION
934: WHEN FND_API.G_EXC_ERROR THEN
935: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
936: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
937: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type with G_EXC_ERROR');
938: END IF;

Line 948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

944: p_count => x_msg_count,
945: p_data => x_msg_data
946: );
947:
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
950: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
951: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type with G_EXC_UNEXPECTED_ERROR');
952: END IF;

Line 995: -- Default = FND_API.G_FALSE

991: --Pre-reqs : None.
992: --Parameters :
993: --IN : p_api_version IN NUMBER Required
994: -- : p_init_msg_list IN VARCHAR2 Optional
995: -- Default = FND_API.G_FALSE
996: -- : p_party_role_code IN VARCHER Required
997: -- external party role code
998: -- : p_party_id IN NUMBER Required
999: -- party id of the external party.

Line 1053: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1049: 'Party Id is: ' || p_party_id);
1050: END IF;
1051:
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;
1056: -- Initialize message list if p_init_msg_list is set to TRUE.
1057: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1050: END IF;
1051:
1052: -- Standard call to check for call compatibility.
1053: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;
1056: -- Initialize message list if p_init_msg_list is set to TRUE.
1057: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1058: FND_MSG_PUB.initialize;

Line 1057: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1053: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1054: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1055: END IF;
1056: -- Initialize message list if p_init_msg_list is set to TRUE.
1057: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:
1061: -- Initialize API return status to success

Line 1062: x_return_status := FND_API.G_RET_STS_SUCCESS;

1058: FND_MSG_PUB.initialize;
1059: END IF;
1060:
1061: -- Initialize API return status to success
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063: l_valid_external_party_flag := 'Y';
1064:
1065: IF (p_party_role_code = G_PARTY_ROLE_PARTNER OR
1066: p_party_role_code = G_PARTY_ROLE_CUSTOMER) THEN

Line 1074: RAISE FND_API.G_EXC_ERROR;

1070: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1071: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1072: G_MODULE||l_api_name, 'Party with Party Id: '|| p_party_id || ' does not exist');
1073: END IF;
1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF; -- partner_csr%NOTFOUND
1076: l_party_name := partner_rec.party_name;
1077: if (partner_rec.status <> 'A') THEN
1078: l_valid_external_party_flag := 'N';

Line 1089: RAISE FND_API.G_EXC_ERROR;

1085: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1087: G_MODULE||l_api_name, 'Vendor with vendor Id: '|| p_party_id || ' does not exist');
1088: END IF;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF; -- vendor_csr%NOTFOUND
1091: l_party_name := vendor_rec.vendor_name;
1092: if (vendor_rec.enabled_flag <> 'Y' AND
1093: SYSDATE BETWEEN NVL(vendor_rec.start_date_active, SYSDATE - 1) AND NVL(vendor_rec.end_date_active, SYSDATE + 1)) THEN

Line 1128: WHEN FND_API.G_EXC_ERROR THEN

1124: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1125: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party');
1126: END IF;
1127: EXCEPTION
1128: WHEN FND_API.G_EXC_ERROR THEN
1129: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1130: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
1131: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party with G_EXC_ERROR');
1132: END IF;

Line 1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1141: p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144:
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1147: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1148: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party with G_EXC_UNEXPECTED_ERROR');
1149: END IF;

Line 1200: -- Default = FND_API.G_FALSE

1196: --Pre-reqs : None.
1197: --Parameters :
1198: --IN : p_api_version IN NUMBER Required
1199: -- : p_init_msg_list IN VARCHAR2 Optional
1200: -- Default = FND_API.G_FALSE
1201: -- : p_party_role_code IN VARCHER Required
1202: -- external party role code
1203: -- : p_party_id IN NUMBER Required
1204: -- party id of the external party.

Line 1292: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1288: 'Contact Id is: ' || p_contact_id);
1289: END IF;
1290:
1291: -- Standard call to check for call compatibility.
1292: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1289: END IF;
1290:
1291: -- Standard call to check for call compatibility.
1292: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1297: FND_MSG_PUB.initialize;

Line 1296: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1292: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295: -- Initialize message list if p_init_msg_list is set to TRUE.
1296: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1297: FND_MSG_PUB.initialize;
1298: END IF;
1299:
1300: -- Initialize API return status to success

Line 1301: x_return_status := FND_API.G_RET_STS_SUCCESS;

1297: FND_MSG_PUB.initialize;
1298: END IF;
1299:
1300: -- Initialize API return status to success
1301: x_return_status := FND_API.G_RET_STS_SUCCESS;
1302: l_valid_contact_flag := 'Y';
1303:
1304: IF ((p_party_role_code = G_PARTY_ROLE_PARTNER) OR (p_party_role_code = G_PARTY_ROLE_CUSTOMER)) THEN
1305:

Line 1314: RAISE FND_API.G_EXC_ERROR;

1310: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1311: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1312: G_MODULE||l_api_name, 'Contact with Contact Id: '|| p_contact_id || ' does not exist');
1313: END IF;
1314: RAISE FND_API.G_EXC_ERROR;
1315: END IF; -- partner_csr%NOTFOUND
1316:
1317: l_contact_name := tca_contact_rec.contact_name;
1318:

Line 1338: RAISE FND_API.G_EXC_ERROR;

1334: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1335: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1336: G_MODULE||l_api_name, 'Vendor contact Id: '|| p_contact_id || ' does not exist');
1337: END IF;
1338: RAISE FND_API.G_EXC_ERROR;
1339: END IF; -- vendor_contact_csr%NOTFOUND
1340:
1341: l_contact_name := vendor_contact_rec.contact_name;
1342:

Line 1405: WHEN FND_API.G_EXC_ERROR THEN

1401: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1402: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact');
1403: END IF;
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_ERROR THEN
1406: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1407: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
1408: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact with G_EXC_ERROR');
1409: END IF;

Line 1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1424: p_count => x_msg_count,
1425: p_data => x_msg_data
1426: );
1427:
1428: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1429: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1430: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1431: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact with G_EXC_UNEXPECTED_ERROR');
1432: END IF;

Line 1496: -- Default = FND_API.G_FALSE

1492: --Pre-reqs : None.
1493: --Parameters :
1494: --IN : p_api_version IN NUMBER Required
1495: -- : p_init_msg_list IN VARCHAR2 Optional
1496: -- Default = FND_API.G_FALSE
1497: -- : p_contact_role_id IN NUMBER Required
1498: -- Contract Role Id to be validated
1499: -- : p_severity IN VARCHAR2 Required
1500: -- Severity level for this check. Possible values are ERROR, WARNING.

Line 1542: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1538: 'Severity level is: ' || p_severity);
1539: END IF;
1540:
1541: -- Standard call to check for call compatibility.
1542: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: END IF;
1545: -- Initialize message list if p_init_msg_list is set to TRUE.
1546: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1539: END IF;
1540:
1541: -- Standard call to check for call compatibility.
1542: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: END IF;
1545: -- Initialize message list if p_init_msg_list is set to TRUE.
1546: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1547: FND_MSG_PUB.initialize;

Line 1546: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1542: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: END IF;
1545: -- Initialize message list if p_init_msg_list is set to TRUE.
1546: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1547: FND_MSG_PUB.initialize;
1548: END IF;
1549:
1550: -- Initialize API return status to success

Line 1551: x_return_status := FND_API.G_RET_STS_SUCCESS;

1547: FND_MSG_PUB.initialize;
1548: END IF;
1549:
1550: -- Initialize API return status to success
1551: x_return_status := FND_API.G_RET_STS_SUCCESS;
1552: l_valid_contact_role_flag := 'Y';
1553:
1554: OPEN contact_role_csr;
1555: FETCH contact_role_csr INTO contact_role_rec;

Line 1561: RAISE FND_API.G_EXC_ERROR;

1557: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1558: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1559: G_MODULE||l_api_name, 'Contact role with id : '|| p_contact_role_id || ' does not exist');
1560: END IF;
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF; -- contact_role_csr%NOTFOUND
1563: l_contact_role_name := contact_role_rec.name;
1564: IF (sysdate BETWEEN nvl(contact_role_rec.start_date, sysdate) AND nvl(contact_role_rec.end_date, sysdate)) THEN
1565: l_valid_contact_role_flag := 'Y';

Line 1599: WHEN FND_API.G_EXC_ERROR THEN

1595: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1596: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role');
1597: END IF;
1598: EXCEPTION
1599: WHEN FND_API.G_EXC_ERROR THEN
1600: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1601: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
1602: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role with G_EXC_ERROR');
1603: END IF;

Line 1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1609: p_count => x_msg_count,
1610: p_data => x_msg_data
1611: );
1612:
1613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1614: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1615: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1616: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role with G_EXC_UNEXPECTED_ERROR');
1617: END IF;

Line 1662: -- Default = FND_API.G_FALSE

1658: --Pre-reqs : None.
1659: --Parameters :
1660: --IN : p_api_version IN NUMBER Required
1661: -- : p_init_msg_list IN VARCHAR2 Optional
1662: -- Default = FND_API.G_FALSE
1663: -- : p_contact_role IN NUMBER Required
1664: -- Contract type to be validated
1665: -- : p_severity IN VARCHAR2 Required
1666: -- Severity level for this check. Possible values are ERROR, WARNING.

Line 1708: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1704: 'Severity level is: ' || p_severity);
1705: END IF;
1706:
1707: -- Standard call to check for call compatibility.
1708: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711: -- Initialize message list if p_init_msg_list is set to TRUE.
1712: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1705: END IF;
1706:
1707: -- Standard call to check for call compatibility.
1708: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711: -- Initialize message list if p_init_msg_list is set to TRUE.
1712: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1713: FND_MSG_PUB.initialize;

Line 1712: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1708: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710: END IF;
1711: -- Initialize message list if p_init_msg_list is set to TRUE.
1712: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1713: FND_MSG_PUB.initialize;
1714: END IF;
1715:
1716: -- Initialize API return status to success

Line 1717: x_return_status := FND_API.G_RET_STS_SUCCESS;

1713: FND_MSG_PUB.initialize;
1714: END IF;
1715:
1716: -- Initialize API return status to success
1717: x_return_status := FND_API.G_RET_STS_SUCCESS;
1718: l_valid_risk_event_flag := 'Y';
1719:
1720: OPEN risk_event_csr;
1721: FETCH risk_event_csr INTO risk_event_rec;

Line 1727: RAISE FND_API.G_EXC_ERROR;

1723: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1724: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
1725: G_MODULE||l_api_name, 'Risk Event with id : '|| p_risk_event_id || ' does not exist');
1726: END IF;
1727: RAISE FND_API.G_EXC_ERROR;
1728: END IF; -- risk_event_csr%NOTFOUND
1729: l_risk_event_name := risk_event_rec.name;
1730: IF (sysdate BETWEEN nvl(risk_event_rec.start_date, sysdate) AND nvl(risk_event_rec.end_date, sysdate)) THEN
1731: l_valid_risk_event_flag := 'Y';

Line 1765: WHEN FND_API.G_EXC_ERROR THEN

1761: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1762: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event');
1763: END IF;
1764: EXCEPTION
1765: WHEN FND_API.G_EXC_ERROR THEN
1766: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1767: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
1768: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event with G_EXC_ERROR');
1769: END IF;

Line 1779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1775: p_count => x_msg_count,
1776: p_data => x_msg_data
1777: );
1778:
1779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1780: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
1782: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event with G_EXC_UNEXPECTED_ERROR');
1783: END IF;

Line 1826: -- : Default = FND_API.G_FALSE

1822: --Pre-reqs : None.
1823: --Parameters :
1824: --IN : p_api_version IN NUMBER Required
1825: -- : p_init_msg_list IN VARCHAR2 Optional
1826: -- : Default = FND_API.G_FALSE
1827: -- : p_contract_id IN NUMBER Required
1828: -- : Contract ID of the contract to be QA checked
1829: -- : p_contract_type IN NUMBER Required
1830: -- : Type of the contract to be QA checked

Line 1897: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1893: END IF;
1894: x_return_status := G_RET_STS_SUCCESS;
1895:
1896: -- Initialize message list if p_init_msg_list is set to TRUE.
1897: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1898: FND_MSG_PUB.initialize;
1899: END IF;
1900:
1901: --Validations for Closeout Checklist Template Contract Type

Line 2140: WHEN FND_API.G_EXC_ERROR THEN

2136: G_MODULE||l_api_name,'leaving OKC_REP_QA_CHECK_PVT.contract_type_spec_validat');
2137: END IF;
2138:
2139: EXCEPTION
2140: WHEN FND_API.G_EXC_ERROR THEN
2141: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2142: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
2143: 'Leaving OKC_REP_QA_CHECK_PVT.contract_type_spec_validat with G_EXC_ERROR');
2144: END IF;

Line 2159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2155: p_count => x_msg_count,
2156: p_data => x_msg_data
2157: );
2158:
2159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2160: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2161: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
2162: 'Leaving OKC_REP_QA_CHECK_PVT.contract_type_spec_validat with G_EXC_UNEXPECTED_ERROR');
2163: END IF;

Line 2217: -- Default = FND_API.G_FALSE

2213: --Pre-reqs : None.
2214: --Parameters :
2215: --IN : p_api_version IN NUMBER Required
2216: -- : p_init_msg_list IN VARCHAR2 Optional
2217: -- Default = FND_API.G_FALSE
2218: -- : p_contract_type IN NUMBER Required
2219: -- Contract type to be validated
2220: -- : p_severity IN VARCHAR2 Required
2221: -- Severity level for this check. Possible values are ERROR, WARNING.

Line 2266: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2262: 'Severity level is: ' || p_severity);
2263: END IF;
2264:
2265: -- Standard call to check for call compatibility.
2266: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2268: END IF;
2269: -- Initialize message list if p_init_msg_list is set to TRUE.
2270: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2263: END IF;
2264:
2265: -- Standard call to check for call compatibility.
2266: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2268: END IF;
2269: -- Initialize message list if p_init_msg_list is set to TRUE.
2270: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2271: FND_MSG_PUB.initialize;

Line 2270: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2266: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2268: END IF;
2269: -- Initialize message list if p_init_msg_list is set to TRUE.
2270: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2271: FND_MSG_PUB.initialize;
2272: END IF;
2273:
2274: -- Initialize API return status to success

Line 2275: x_return_status := FND_API.G_RET_STS_SUCCESS;

2271: FND_MSG_PUB.initialize;
2272: END IF;
2273:
2274: -- Initialize API return status to success
2275: x_return_status := FND_API.G_RET_STS_SUCCESS;
2276:
2277: OPEN contract_type_csr;
2278: FETCH contract_type_csr INTO contract_type_rec;
2279: IF contract_type_csr%NOTFOUND THEN

Line 2284: RAISE FND_API.G_EXC_ERROR;

2280: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2281: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION ,
2282: G_MODULE||l_api_name, 'Contract Type: '|| p_contract_type || ' does not exist');
2283: END IF;
2284: RAISE FND_API.G_EXC_ERROR;
2285: END IF; -- contract_type_csr%NOTFOUND
2286:
2287: IF contract_type_rec.approval_workflow_name IS NULL THEN
2288:

Line 2316: WHEN FND_API.G_EXC_ERROR THEN

2312: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2313: 'Leaving OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow');
2314: END IF;
2315: EXCEPTION
2316: WHEN FND_API.G_EXC_ERROR THEN
2317: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2318: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
2319: 'Leaving OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow with G_EXC_ERROR');
2320: END IF;

Line 2333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2329: p_count => x_msg_count,
2330: p_data => x_msg_data
2331: );
2332:
2333: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2334: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2335: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
2336: 'Leaving OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow with G_EXC_UNEXPECTED_ERROR');
2337: END IF;

Line 2392: -- : Default = FND_API.G_FALSE

2388: --Pre-reqs : None.
2389: --Parameters :
2390: --IN : p_api_version IN NUMBER Required
2391: -- : p_init_msg_list IN VARCHAR2 Optional
2392: -- : Default = FND_API.G_FALSE
2393: -- : p_contract_id IN NUMBER Required
2394: -- : Contract ID of the contract to be QA checked
2395: -- : p_contract_type IN NUMBER Required
2396: -- : Type of the contract to be QA checked

Line 2475: IF FND_API.to_Boolean( p_init_msg_list ) 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
2476: FND_MSG_PUB.initialize;
2477: END IF;
2478:
2479: --Check for external party

Line 2486: p_init_msg_list => FND_API.G_FALSE,

2482: 'Calling OKC_REP_QA_CHECK_PVT.check_no_exteral_party() API');
2483: END IF;
2484: check_no_external_party (
2485: p_api_version => 1,
2486: p_init_msg_list => FND_API.G_FALSE,
2487: p_contract_id => p_contract_id,
2488: p_severity => G_QA_STS_WARNING,
2489: px_qa_result_tbl => p_qa_result_tbl,
2490: x_msg_data => x_msg_data,

Line 2521: p_init_msg_list => FND_API.G_FALSE,

2517: END IF;
2518:
2519: validate_E_Signature (
2520: p_api_version => 1,
2521: p_init_msg_list => FND_API.G_FALSE,
2522: p_contract_id => p_contract_id,
2523: p_contract_type => p_contract_type,
2524: p_severity => G_QA_STS_ERROR,
2525: px_qa_result_tbl => p_qa_result_tbl,

Line 2557: p_init_msg_list => FND_API.G_FALSE,

2553:
2554: if(p_contract_type <> 'REP_SBCR') then
2555: check_no_eff_date (
2556: p_api_version => 1,
2557: p_init_msg_list => FND_API.G_FALSE,
2558: p_effective_date => contract_rec.contract_effective_date,
2559: p_contract_id => p_contract_id,
2560: p_severity => G_QA_STS_ERROR,
2561: px_qa_result_tbl => p_qa_result_tbl,

Line 2598: p_init_msg_list => FND_API.G_FALSE,

2594:
2595:
2596: check_expiry_check (
2597: p_api_version => 1,
2598: p_init_msg_list => FND_API.G_FALSE,
2599: p_expiration_date => contract_exp_rec.contract_expiration_date,
2600: p_contract_id => p_contract_id,
2601: p_severity => G_QA_STS_ERROR,
2602: px_qa_result_tbl => p_qa_result_tbl,

Line 2628: p_init_msg_list => FND_API.G_FALSE,

2624: 'Calling OKC_REP_QA_CHECK_PVT.validate_contract_type() API');
2625: END IF;
2626: validate_contract_type (
2627: p_api_version => 1,
2628: p_init_msg_list => FND_API.G_FALSE,
2629: p_contract_type => p_contract_type,
2630: p_severity => G_QA_STS_WARNING,
2631: px_qa_result_tbl => p_qa_result_tbl,
2632: x_msg_data => x_msg_data,

Line 2654: p_init_msg_list => FND_API.G_FALSE,

2650: END IF;
2651:
2652: validate_Approval_Workflow (
2653: p_api_version => 1,
2654: p_init_msg_list => FND_API.G_FALSE,
2655: p_contract_id => p_contract_id,
2656: p_contract_type => p_contract_type,
2657: p_severity => G_QA_STS_ERROR,
2658: px_qa_result_tbl => p_qa_result_tbl,

Line 2687: p_init_msg_list => FND_API.G_FALSE,

2683: 'Party role code is: '|| party_rec.party_role_code);
2684: END IF;
2685: validate_external_party (
2686: p_api_version => 1,
2687: p_init_msg_list => FND_API.G_FALSE,
2688: p_party_role_code => party_rec.party_role_code,
2689: p_party_id => party_rec.party_id,
2690: p_severity => G_QA_STS_WARNING,
2691: px_qa_result_tbl => p_qa_result_tbl,

Line 2723: p_init_msg_list => FND_API.G_FALSE,

2719: END IF;
2720: -- Validate contact
2721: validate_contact (
2722: p_api_version => 1,
2723: p_init_msg_list => FND_API.G_FALSE,
2724: p_party_role_code => party_contact_rec.party_role_code,
2725: p_party_id => party_contact_rec.party_id,
2726: p_contact_id => party_contact_rec.contact_id,
2727: p_severity => G_QA_STS_WARNING,

Line 2746: p_init_msg_list => FND_API.G_FALSE,

2742:
2743: -- Validate contact role
2744: validate_contact_role (
2745: p_api_version => 1,
2746: p_init_msg_list => FND_API.G_FALSE,
2747: p_contact_role_id => party_contact_rec.contact_role_id,
2748: p_severity => G_QA_STS_WARNING,
2749: px_qa_result_tbl => p_qa_result_tbl,
2750: x_msg_data => x_msg_data,

Line 2777: p_init_msg_list => FND_API.G_FALSE,

2773: 'Risk Event Id is: '|| risk_rec.risk_event_id);
2774: END IF;
2775: validate_risk_event (
2776: p_api_version => 1,
2777: p_init_msg_list => FND_API.G_FALSE,
2778: p_risk_event_id => risk_rec.risk_event_id,
2779: p_severity => G_QA_STS_WARNING,
2780: px_qa_result_tbl => p_qa_result_tbl,
2781: x_msg_data => x_msg_data,

Line 2803: p_init_msg_list => FND_API.G_FALSE,

2799: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2800: 'Calling OKC_REP_QA_CHECK_PVT.contract_type_spec_validat() API');
2801: END IF;
2802: contract_type_spec_validat(p_api_version => 1,
2803: p_init_msg_list => FND_API.G_FALSE,
2804: p_contract_type => p_contract_type,
2805: p_contract_id => p_contract_id,
2806: px_qa_result_tbl => p_qa_result_tbl,
2807: x_msg_data => x_msg_data,

Line 2828: p_init_msg_list => FND_API.G_FALSE,

2824: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2825: 'Calling OKC_REP_VAL_CODE_HOOK.CUSTOM_CONT_VALIDATE() API');
2826: END IF;
2827: OKC_REP_VAL_CODE_HOOK.CUSTOM_CONT_VALIDATE(p_api_version => 1,
2828: p_init_msg_list => FND_API.G_FALSE,
2829: p_contract_type => p_contract_type,
2830: p_contract_id => p_contract_id,
2831: px_qa_result_tbl => p_qa_result_tbl,
2832: x_msg_data => x_msg_data,

Line 2857: WHEN FND_API.G_EXC_ERROR THEN

2853: G_MODULE||l_api_name,'leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa');
2854: END IF;
2855:
2856: EXCEPTION
2857: WHEN FND_API.G_EXC_ERROR THEN
2858: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2859: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION , G_MODULE||l_api_name,
2860: 'Leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa with G_EXC_ERROR');
2861: END IF;

Line 2872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2868: p_count => x_msg_count,
2869: p_data => x_msg_data
2870: );
2871:
2872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2873: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2874: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,G_MODULE||l_api_name,
2875: 'Leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa with G_EXC_UNEXPECTED_ERROR');
2876: END IF;

Line 2925: -- Default = FND_API.G_FALSE

2921: --Pre-reqs : None.
2922: --Parameters :
2923: --IN : p_api_version IN NUMBER Required
2924: -- : p_init_msg_list IN VARCHAR2 Optional
2925: -- Default = FND_API.G_FALSE
2926: -- : p_contract_id IN NUMBER Required
2927: -- Contract ID of the contract to be QA checked
2928: --OUT : x_return_status OUT VARCHAR2(1)
2929: -- : x_msg_count OUT NUMBER

Line 2987: IF FND_API.to_Boolean( p_init_msg_list ) 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
2988: FND_MSG_PUB.initialize;
2989: END IF;
2990:
2991: -- Get effective dates and contract_type of the contract.

Line 3004: RAISE FND_API.G_EXC_ERROR;

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;
3005: -- RAISE NO_DATA_FOUND;
3006: END IF;
3007:
3008:

Line 3053: p_init_msg_list => FND_API.G_FALSE,

3049: 'Calling OKC_REP_QA_CHECK_PVT.validate_repository_for_qa() API');
3050: END IF;
3051: validate_repository_for_qa (
3052: p_api_version => 1,
3053: p_init_msg_list => FND_API.G_FALSE,
3054: p_contract_type => contract_rec.contract_type,
3055: p_contract_id => p_contract_id,
3056: p_qa_result_tbl => l_qa_result_tbl,
3057: x_msg_data => x_msg_data,

Line 3084: p_init_msg_list => FND_API.G_FALSE,

3080: l_bus_doc_date_events_tbl(2).event_date := contract_rec.contract_expiration_date;
3081:
3082: OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa (
3083: p_api_version => 1,
3084: p_init_msg_list => FND_API.G_FALSE,
3085: p_doc_type => contract_rec.contract_type,
3086: p_doc_id => p_contract_id,
3087: p_mode => G_NORMAL_QA,
3088: p_bus_doc_date_events_tbl => l_bus_doc_date_events_tbl,

Line 3162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3158: 'Completed OKC_TERMS_QA_PVT.Log_QA_Messages');
3159: END IF;
3160: --------------------------------------------
3161: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3163: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3164: RAISE FND_API.G_EXC_ERROR ;
3165: END IF;
3166: --------------------------------------------

Line 3164: RAISE FND_API.G_EXC_ERROR ;

3160: --------------------------------------------
3161: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3163: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3164: RAISE FND_API.G_EXC_ERROR ;
3165: END IF;
3166: --------------------------------------------
3167:
3168: -- We should commit work now

Line 3182: WHEN FND_API.G_EXC_ERROR THEN

3178: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check');
3179: END IF;
3180:
3181: EXCEPTION
3182: WHEN FND_API.G_EXC_ERROR THEN
3183:
3184: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3185: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
3186: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check with G_EXC_ERROR');

Line 3198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3194: p_count => x_msg_count,
3195: p_data => x_msg_data
3196: );
3197:
3198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3199:
3200: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3201: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
3202: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check with G_EXC_UNEXPECTED_ERROR');

Line 3360: WHEN FND_API.G_EXC_ERROR THEN

3356: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks');
3357: END IF;
3358:
3359: EXCEPTION
3360: WHEN FND_API.G_EXC_ERROR THEN
3361:
3362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3363: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,
3364: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with G_EXC_ERROR');

Line 3374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3370: p_count => x_msg_count,
3371: p_data => x_msg_data
3372: );
3373:
3374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3375:
3376: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3377: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,
3378: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with G_EXC_UNEXPECTED_ERROR');