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_REP_QA_CHECK_PVT

Line 1: PACKAGE BODY OKC_REP_QA_CHECK_PVT AS

1: PACKAGE BODY OKC_REP_QA_CHECK_PVT AS
2: /* $Header: OKCVREPQACHKB.pls 120.12.12020000.16 2013/05/08 08:38:41 skavutha ship $ */
3:
4: -- Start of comments
5: --API name : check_no_external_party

Line 66: 'Entered OKC_REP_QA_CHECK_PVT.check_no_external_party ');

62:
63: BEGIN
64: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
65: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
66: 'Entered OKC_REP_QA_CHECK_PVT.check_no_external_party ');
67: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
68: 'Contract Id is: ' || p_contract_id);
69: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
70: 'Severity level is: ' || p_severity);

Line 136: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party');

132: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
133:
134: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 142: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party with G_EXC_ERROR');

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;
144: x_return_status := G_RET_STS_ERROR;
145: --close cursors
146: IF (party_csr%ISOPEN) THEN

Line 157: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party with G_EXC_UNEXPECTED_ERROR');

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;
159: x_return_status := G_RET_STS_UNEXP_ERROR;
160: --close cursors
161:

Line 175: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_external_party because of EXCEPTION: ' || sqlerrm);

171:
172: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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,

Line 253: 'Entered OKC_REP_QA_CHECK_PVT.check_no_eff_date ');

249: BEGIN
250:
251: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
252: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
253: 'Entered OKC_REP_QA_CHECK_PVT.check_no_eff_date ');
254: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
255: 'Effective Date is: ' || p_effective_date);
256: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
257: 'Severity level is: ' || p_severity);

Line 314: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date');

310: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
311:
312: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 320: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date with G_EXC_ERROR');

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;
322: x_return_status := G_RET_STS_ERROR;
323:
324: FND_MSG_PUB.Count_And_Get(

Line 332: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date with G_EXC_UNEXPECTED_ERROR');

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;
334:
335: x_return_status := G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.Count_And_Get(

Line 346: 'Leaving OKC_REP_QA_CHECK_PVT.check_no_eff_date because of EXCEPTION: ' || sqlerrm);

342:
343: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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,

Line 420: 'Entered OKC_REP_QA_CHECK_PVT.check_expiry_check ');

416: BEGIN
417:
418: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
419: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
420: 'Entered OKC_REP_QA_CHECK_PVT.check_expiry_check ');
421: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
422: 'Expiration Date is: ' || p_expiration_date);
423: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
424: 'Severity level is: ' || p_severity);

Line 481: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check');

477: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
478:
479: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 487: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check with G_EXC_ERROR');

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;
489: x_return_status := G_RET_STS_ERROR;
490:
491: FND_MSG_PUB.Count_And_Get(

Line 499: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check with G_EXC_UNEXPECTED_ERROR');

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;
501:
502: x_return_status := G_RET_STS_UNEXP_ERROR;
503: FND_MSG_PUB.Count_And_Get(

Line 513: 'Leaving OKC_REP_QA_CHECK_PVT.check_expiry_check because of EXCEPTION: ' || sqlerrm);

509:
510: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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,

Line 627: 'Entered OKC_REP_QA_CHECK_PVT.validate_E_Signature ');

623: BEGIN
624:
625: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
626: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
627: 'Entered OKC_REP_QA_CHECK_PVT.validate_E_Signature ');
628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
629: 'Contract type is: ' || p_contract_type);
630: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
631: 'Severity level is: ' || p_severity);

Line 765: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type');

761: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
762:
763: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 771: 'Leaving OKC_REP_QA_CHECK_PVT.validate_E_Signature with G_EXC_ERROR');

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;
773: IF (contract_type_csr%ISOPEN) THEN
774: CLOSE contract_type_csr ;
775: END IF;

Line 785: 'Leaving OKC_REP_QA_CHECK_PVT.validate_E_Signature with G_EXC_UNEXPECTED_ERROR');

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;
787: IF (contract_type_csr%ISOPEN) THEN
788: CLOSE contract_type_csr ;
789: END IF;

Line 800: 'Leaving OKC_REP_QA_CHECK_PVT.validate_E_Signature because of EXCEPTION: ' || sqlerrm);

796: WHEN OTHERS THEN
797: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
798: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
799: G_MODULE || l_api_name,
800: 'Leaving OKC_REP_QA_CHECK_PVT.validate_E_Signature because of EXCEPTION: ' || sqlerrm);
801: END IF;
802: IF (contract_type_csr%ISOPEN) THEN
803: CLOSE contract_type_csr ;
804: END IF;

Line 868: 'Entered OKC_REP_QA_CHECK_PVT.validate_contract_type ');

864: BEGIN
865:
866: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
867: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
868: 'Entered OKC_REP_QA_CHECK_PVT.validate_contract_type ');
869: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
870: 'Contract type is: ' || p_contract_type);
871: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
872: 'Severity level is: ' || p_severity);

Line 931: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type');

927: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
928:
929: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 937: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type with G_EXC_ERROR');

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;
939: IF (contract_type_csr%ISOPEN) THEN
940: CLOSE contract_type_csr ;
941: END IF;

Line 951: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type with G_EXC_UNEXPECTED_ERROR');

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;
953: IF (contract_type_csr%ISOPEN) THEN
954: CLOSE contract_type_csr ;
955: END IF;

Line 966: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type because of EXCEPTION: ' || sqlerrm);

962: WHEN OTHERS THEN
963: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
964: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
965: G_MODULE || l_api_name,
966: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contract_type because of EXCEPTION: ' || sqlerrm);
967: END IF;
968: IF (contract_type_csr%ISOPEN) THEN
969: CLOSE contract_type_csr ;
970: END IF;

Line 1045: 'Entered OKC_REP_QA_CHECK_PVT.validate_external_party ');

1041:
1042: BEGIN
1043: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1045: 'Entered OKC_REP_QA_CHECK_PVT.validate_external_party ');
1046: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1047: 'Party Role Code is: ' || p_party_role_code);
1048: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1049: 'Party Id is: ' || p_party_id);

Line 1125: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party');

1121: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1122:
1123: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 1131: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party with G_EXC_ERROR');

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;
1133: IF (partner_csr%ISOPEN) THEN
1134: CLOSE partner_csr ;
1135: END IF;

Line 1148: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party with G_EXC_UNEXPECTED_ERROR');

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;
1150: IF (partner_csr%ISOPEN) THEN
1151: CLOSE partner_csr ;
1152: END IF;

Line 1166: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party because of EXCEPTION: ' || sqlerrm);

1162: WHEN OTHERS THEN
1163: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1164: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1165: G_MODULE || l_api_name,
1166: 'Leaving OKC_REP_QA_CHECK_PVT.validate_external_party because of EXCEPTION: ' || sqlerrm);
1167: END IF;
1168: IF (partner_csr%ISOPEN) THEN
1169: CLOSE partner_csr ;
1170: END IF;

Line 1282: 'Entered OKC_REP_QA_CHECK_PVT.validate_contact ');

1278:
1279: BEGIN
1280: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1281: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1282: 'Entered OKC_REP_QA_CHECK_PVT.validate_contact ');
1283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1284: 'Party Role Code is: ' || p_party_role_code);
1285: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1286: 'Party Id is: ' || p_party_id);

Line 1402: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact');

1398: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1399:
1400: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 1408: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact with G_EXC_ERROR');

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;
1410: IF (tca_contact_csr%ISOPEN) THEN
1411: CLOSE tca_contact_csr ;
1412: END IF;

Line 1431: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact with G_EXC_UNEXPECTED_ERROR');

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;
1433: IF (tca_contact_csr%ISOPEN) THEN
1434: CLOSE tca_contact_csr ;
1435: END IF;

Line 1455: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact because of EXCEPTION: ' || sqlerrm);

1451: WHEN OTHERS THEN
1452: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1453: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1454: G_MODULE || l_api_name,
1455: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact because of EXCEPTION: ' || sqlerrm);
1456: END IF;
1457: IF (tca_contact_csr%ISOPEN) THEN
1458: CLOSE tca_contact_csr ;
1459: END IF;

Line 1534: 'Entered OKC_REP_QA_CHECK_PVT.validate_contact_role ');

1530: BEGIN
1531:
1532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1534: 'Entered OKC_REP_QA_CHECK_PVT.validate_contact_role ');
1535: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1536: 'Contact Role Id is: ' || p_contact_role_id);
1537: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1538: 'Severity level is: ' || p_severity);

Line 1596: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role');

1592: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1593:
1594: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 1602: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role with G_EXC_ERROR');

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;
1604: IF (contact_role_csr%ISOPEN) THEN
1605: CLOSE contact_role_csr ;
1606: END IF;

Line 1616: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role with G_EXC_UNEXPECTED_ERROR');

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;
1618: IF (contact_role_csr%ISOPEN) THEN
1619: CLOSE contact_role_csr ;
1620: END IF;

Line 1631: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role because of EXCEPTION: ' || sqlerrm);

1627: WHEN OTHERS THEN
1628: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1629: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1630: G_MODULE || l_api_name,
1631: 'Leaving OKC_REP_QA_CHECK_PVT.validate_contact_role because of EXCEPTION: ' || sqlerrm);
1632: END IF;
1633: IF (contact_role_csr%ISOPEN) THEN
1634: CLOSE contact_role_csr ;
1635: END IF;

Line 1700: 'Entered OKC_REP_QA_CHECK_PVT.validate_risk_event ');

1696: BEGIN
1697:
1698: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1699: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1700: 'Entered OKC_REP_QA_CHECK_PVT.validate_risk_event ');
1701: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1702: 'Risk Event Id is: ' || p_risk_event_id);
1703: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
1704: 'Severity level is: ' || p_severity);

Line 1762: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event');

1758: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1759:
1760: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 1768: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event with G_EXC_ERROR');

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;
1770: IF (risk_event_csr%ISOPEN) THEN
1771: CLOSE risk_event_csr ;
1772: END IF;

Line 1782: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event with G_EXC_UNEXPECTED_ERROR');

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;
1784: IF (risk_event_csr%ISOPEN) THEN
1785: CLOSE risk_event_csr ;
1786: END IF;

Line 1797: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event because of EXCEPTION: ' || sqlerrm);

1793: WHEN OTHERS THEN
1794: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1795: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1796: G_MODULE || l_api_name,
1797: 'Leaving OKC_REP_QA_CHECK_PVT.validate_risk_event because of EXCEPTION: ' || sqlerrm);
1798: END IF;
1799: IF (risk_event_csr%ISOPEN) THEN
1800: CLOSE risk_event_csr ;
1801: END IF;

Line 2136: G_MODULE||l_api_name,'leaving OKC_REP_QA_CHECK_PVT.contract_type_spec_validat');

2132: -- Standard call to get message count and if count is 1, get message info.
2133: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2134: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2135: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
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

Line 2143: 'Leaving OKC_REP_QA_CHECK_PVT.contract_type_spec_validat with G_EXC_ERROR');

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;
2145: x_return_status := G_RET_STS_ERROR;
2146: --close cursors
2147: IF (c_check_del_cct%ISOPEN) THEN

Line 2162: 'Leaving OKC_REP_QA_CHECK_PVT.contract_type_spec_validat with G_EXC_UNEXPECTED_ERROR');

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;
2164: x_return_status := G_RET_STS_UNEXP_ERROR;
2165: --close cursors
2166: IF (c_check_del_cct%ISOPEN) THEN

Line 2182: 'Leaving OKC_REP_QA_CHECK_PVT.contract_type_spec_validat because of EXCEPTION: ' || sqlerrm);

2178: WHEN OTHERS THEN
2179: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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,

Line 2258: 'Entered OKC_REP_QA_CHECK_PVT.validate_E_Signature ');

2254: BEGIN
2255:
2256: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2257: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2258: 'Entered OKC_REP_QA_CHECK_PVT.validate_E_Signature ');
2259: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2260: 'Contract type is: ' || p_contract_type);
2261: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
2262: 'Severity level is: ' || p_severity);

Line 2313: 'Leaving OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow');

2309: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2310:
2311: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) 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

Line 2319: 'Leaving OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow with G_EXC_ERROR');

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;
2321: --close cursors
2322: IF (contract_type_csr%ISOPEN) THEN
2323: CLOSE contract_type_csr ;

Line 2336: 'Leaving OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow with G_EXC_UNEXPECTED_ERROR');

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;
2338: --close cursors
2339: IF (contract_type_csr%ISOPEN) THEN
2340: CLOSE contract_type_csr ;

Line 2353: 'Leaving OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow because of EXCEPTION: ' || sqlerrm);

2349:
2350: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2351: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
2352: G_MODULE || l_api_name,
2353: 'Leaving OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow because of EXCEPTION: ' || sqlerrm);
2354: END IF;
2355: --close cursors
2356: IF (contract_type_csr%ISOPEN) THEN
2357: CLOSE contract_type_csr ;

Line 2482: 'Calling OKC_REP_QA_CHECK_PVT.check_no_exteral_party() API');

2478:
2479: --Check for external party
2480: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2481: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
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,

Line 2496: 'Completed OKC_REP_QA_CHECK_PVT.check_no_exteral_party with returned status: ' || x_return_status);

2492: x_return_status => x_return_status
2493: );
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

Line 2516: 'Calling OKC_REP_QA_CHECK_PVT.validate_E_Signature() API');

2512:
2513: --Check for ESignature
2514: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2515: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2516: 'Calling OKC_REP_QA_CHECK_PVT.validate_E_Signature() API');
2517: END IF;
2518:
2519: validate_E_Signature (
2520: p_api_version => 1,

Line 2532: 'Completed OKC_REP_QA_CHECK_PVT.validate_E_Signature with returned status: ' || x_return_status);

2528: x_return_status => x_return_status
2529: );
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

Line 2551: 'Calling OKC_REP_QA_CHECK_PVT.check_no_eff_date() API');

2547: END IF;
2548: --Check for null effective date
2549: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2550: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2551: 'Calling OKC_REP_QA_CHECK_PVT.check_no_eff_date() API');
2552: END IF;
2553:
2554: if(p_contract_type <> 'REP_SBCR') then
2555: check_no_eff_date (

Line 2569: 'Completed OKC_REP_QA_CHECK_PVT.check_no_eff_date with returned status: ' || x_return_status);

2565: end if;
2566:
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

Line 2592: 'Calling OKC_REP_QA_CHECK_PVT.check_expiry_check() API');

2588: END IF;
2589: --Check for expiry
2590: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2591: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2592: 'Calling OKC_REP_QA_CHECK_PVT.check_expiry_check() API');
2593: END IF;
2594:
2595:
2596: check_expiry_check (

Line 2613: 'Completed OKC_REP_QA_CHECK_PVT.check_expiry_check with returned status: ' || x_return_status);

2609:
2610:
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

Line 2624: 'Calling OKC_REP_QA_CHECK_PVT.validate_contract_type() API');

2620:
2621: --Validate contract type
2622: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2623: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
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,

Line 2638: 'Completed OKC_REP_QA_CHECK_PVT.validate_contract_type with returned status: ' || x_return_status);

2634: x_return_status => x_return_status
2635: );
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

Line 2649: 'Calling OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow() API');

2645:
2646: --Validate approval Workflow
2647: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2648: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2649: 'Calling OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow() API');
2650: END IF;
2651:
2652: validate_Approval_Workflow (
2653: p_api_version => 1,

Line 2666: 'Completed OKC_REP_QA_CHECK_PVT.validate_Approval_Workflow with returned status: ' || x_return_status);

2662: );
2663:
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

Line 2679: 'Calling OKC_REP_QA_CHECK_PVT.validate_external_party() API');

2675: -- Loop through all the external parties and check if these are still valid.
2676: FOR party_rec IN party_csr LOOP
2677: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2678: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2679: 'Calling OKC_REP_QA_CHECK_PVT.validate_external_party() API');
2680: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2681: 'Party Id is: '|| party_rec.party_id);
2682: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2683: 'Party role code is: '|| party_rec.party_role_code);

Line 2698: 'Completed OKC_REP_QA_CHECK_PVT.validate_external_party with returned status: ' || x_return_status);

2694: x_return_status => x_return_status
2695: );
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

Line 2712: 'Calling OKC_REP_QA_CHECK_PVT.validate_contact() and validate_contact_role() APIs');

2708: -- Loop through all the external contacts and check if these are still valid.
2709: FOR party_contact_rec IN party_contact_csr LOOP
2710: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2711: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2712: 'Calling OKC_REP_QA_CHECK_PVT.validate_contact() and validate_contact_role() APIs');
2713: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2714: 'Party Id is: '|| party_contact_rec.party_id);
2715: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2716: 'Party role code is: '|| party_contact_rec.party_role_code);

Line 2735: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact with returned status: ' || x_return_status);

2731: x_return_status => x_return_status
2732: );
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

Line 2756: 'Completed OKC_REP_QA_CHECK_PVT.validate_contact_role with returned status: ' || x_return_status);

2752: x_return_status => x_return_status
2753: );
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

Line 2771: 'Calling OKC_REP_QA_CHECK_PVT.validate_risk_event() API');

2767: -- Loop through all contract risk events and check if these are still valid.
2768: FOR risk_rec IN risk_csr LOOP
2769: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2770: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2771: 'Calling OKC_REP_QA_CHECK_PVT.validate_risk_event() API');
2772: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2773: 'Risk Event Id is: '|| risk_rec.risk_event_id);
2774: END IF;
2775: validate_risk_event (

Line 2787: 'Completed OKC_REP_QA_CHECK_PVT.validate_risk_event with returned status: ' || x_return_status);

2783: x_return_status => x_return_status
2784: );
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

Line 2800: 'Calling OKC_REP_QA_CHECK_PVT.contract_type_spec_validat() API');

2796: --Document Type Specific validations
2797:
2798: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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,

Line 2813: 'Completed OKC_REP_QA_CHECK_PVT.contract_type_spec_validat with returned status: ' || x_return_status);

2809: x_return_status => x_return_status );
2810:
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

Line 2853: G_MODULE||l_api_name,'leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa');

2849: -- Standard call to get message count and if count is 1, get message info.
2850: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2851: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2852: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
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

Line 2860: 'Leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa with G_EXC_ERROR');

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;
2862: x_return_status := G_RET_STS_ERROR;
2863: --close cursors
2864: IF (contract_csr%ISOPEN) THEN

Line 2875: 'Leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa with G_EXC_UNEXPECTED_ERROR');

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;
2877: x_return_status := G_RET_STS_UNEXP_ERROR;
2878: --close cursors
2879: IF (contract_csr%ISOPEN) THEN

Line 2891: 'Leaving OKC_REP_QA_CHECK_PVT.validate_repository_for_qa because of EXCEPTION: ' || sqlerrm);

2887: WHEN OTHERS THEN
2888: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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,

Line 2917: -- 1. Calls OKC_REP_QA_CHECK_PVT.validate_repository_for_qa() to qa check

2913: -- Start of comments
2914: --API name : perform_contract_qa_check
2915: --Type : Private.
2916: --Function : This API performs QA check on a Repository Contract. The API check for:
2917: -- 1. Calls OKC_REP_QA_CHECK_PVT.validate_repository_for_qa() to qa check
2918: -- repository contracts.
2919: -- 2. Calls OKC_DELIVERABLE_PROCESS_PVT.validate_deliverable_for_qa to check the
2920: -- deliverables.
2921: --Pre-reqs : None.

Line 3049: 'Calling OKC_REP_QA_CHECK_PVT.validate_repository_for_qa() API');

3045:
3046: -- Make call for Repository QA check
3047: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3048: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
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,

Line 3062: 'Completed OKC_REP_QA_CHECK_PVT.validate_repository_for_qa with returned status: ' || x_return_status);

3058: x_msg_count => x_msg_count,
3059: x_return_status => x_return_status);
3060: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
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

Line 3178: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check');

3174: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3175:
3176: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3177: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,
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

Line 3186: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check with G_EXC_ERROR');

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');
3187: END IF;
3188: --close cursors
3189: IF (contract_csr%ISOPEN) THEN
3190: CLOSE contract_csr ;

Line 3202: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check with G_EXC_UNEXPECTED_ERROR');

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');
3203: END IF;
3204: --close cursors
3205: IF (contract_csr%ISOPEN) THEN
3206: CLOSE contract_csr ;

Line 3218: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check with OTHERS EXCEPTION');

3214: WHEN OTHERS THEN
3215:
3216: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3217: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION ,
3218: G_MODULE||l_api_name,'Leaving OKC_REP_QA_CHECK_PVT.perform_contract_qa_check with OTHERS EXCEPTION');
3219: END IF;
3220: --close cursors
3221: IF (contract_csr%ISOPEN) THEN
3222: CLOSE contract_csr ;

Line 3356: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks');

3352: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3353:
3354: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3355: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE , G_MODULE||l_api_name,
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

Line 3364: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with G_EXC_ERROR');

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');
3365: END IF;
3366:
3367: x_return_status := G_RET_STS_ERROR;
3368:

Line 3378: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with G_EXC_UNEXPECTED_ERROR');

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');
3379: END IF;
3380:
3381: x_return_status := G_RET_STS_UNEXP_ERROR;
3382:

Line 3392: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with OTHERS EXCEPTION');

3388: WHEN OTHERS THEN
3389:
3390: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3391: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,
3392: 'Leaving OKC_REP_QA_CHECK_PVT.insert_deliverables_qa_checks with OTHERS EXCEPTION');
3393: END IF;
3394:
3395: x_return_status := G_RET_STS_UNEXP_ERROR;
3396:

Line 3411: END OKC_REP_QA_CHECK_PVT;

3407: );
3408:
3409: END insert_deliverables_qa_checks;
3410:
3411: END OKC_REP_QA_CHECK_PVT;