eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_UTIL_PVT dependencies on OKC_REP_UTIL_PVT

Line 1: PACKAGE BODY OKC_REP_UTIL_PVT AS

1: PACKAGE BODY OKC_REP_UTIL_PVT AS
2: /* $Header: OKCVREPUTILB.pls 120.43.12020000.12 2013/05/22 06:27:41 nbingi ship $ */
3:
4:
5: ------------------------------------------------------------------------------

Line 142: '100: Entered OKC_REP_UTIL_PVT.check_contract_access');

138: l_api_name := 'check_contract_access_external';
139:
140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
142: '100: Entered OKC_REP_UTIL_PVT.check_contract_access');
143: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
144: '101: Contract Id is: ' || to_char(p_contract_id));
145: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
146: '102: Contract Type is: ' || p_contract_type);

Line 281: '110: Leaving OKC_REP_UTIL_PVT.check_contract_access');

277: END IF; -- End of MO_GLOBAL check
278:
279: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
280: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
281: '110: Leaving OKC_REP_UTIL_PVT.check_contract_access');
282: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
283: '111: x_has_access is: ' || x_has_access);
284: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
285: '112: x_return_status is: ' || x_return_status);

Line 548: '100: Entered OKC_REP_UTIL_PVT.check_contract_access');

544: l_api_name := 'check_contract_access';
545:
546: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
547: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
548: '100: Entered OKC_REP_UTIL_PVT.check_contract_access');
549: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
550: '101: Contract Id is: ' || to_char(p_contract_id));
551: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
552: '102: Fucntion Name is: ' || p_function_name);

Line 615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name, '200:Leaving OKC_REP_UTIL_PVT.check_contract_access');

611: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
612: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name, '200:Approver is the current user. so user have access.');
613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, '200:x_has_access is: ' || x_has_access);
614: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, '200:x_return_status is: ' || x_return_status);
615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name, '200:Leaving OKC_REP_UTIL_PVT.check_contract_access');
616: END IF;
617:
618: RETURN;
619: END IF;

Line 638: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name, '200:Leaving OKC_REP_UTIL_PVT.check_contract_access');

634: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name, '210:Signer is the current user. so user have access.');
636: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, '200:x_has_access is: ' || x_has_access);
637: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name, '200:x_return_status is: ' || x_return_status);
638: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name, '200:Leaving OKC_REP_UTIL_PVT.check_contract_access');
639: END IF;
640:
641: RETURN;
642: END IF;

Line 771: '110: Leaving OKC_REP_UTIL_PVT.check_contract_access');

767: END IF; -- End of MO_GLOBAL check
768:
769: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
770: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
771: '110: Leaving OKC_REP_UTIL_PVT.check_contract_access');
772: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
773: '111: x_has_access is: ' || x_has_access);
774: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
775: '112: x_return_status is: ' || x_return_status);

Line 886: 'Entered Function OKC_REP_UTIL_PVT.check_contract_access');

882: l_has_access := 'N';
883:
884: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
885: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
886: 'Entered Function OKC_REP_UTIL_PVT.check_contract_access');
887: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
888: 'Contract Id is: ' || p_contract_id);
889: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
890: 'Contract Type is: ' || p_contract_type);

Line 894: 'Calling OKC_REP_UTIL_PVT.has_contract_access');

890: 'Contract Type is: ' || p_contract_type);
891: END IF;
892: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
893: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
894: 'Calling OKC_REP_UTIL_PVT.has_contract_access');
895: END IF;
896: --- Call check_contract_access procedure.
897: check_contract_access_external(
898: p_api_version => 1.0,

Line 909: 'OKC_REP_UTIL_PVT.check_contract_access return status is: '

905: x_return_status => l_return_status
906: );
907: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
908: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
909: 'OKC_REP_UTIL_PVT.check_contract_access return status is: '
910: || l_return_status);
911: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
912: 'OKC_REP_UTIL_PVT.check_contract_access returns has_access as : '
913: || l_has_access);

Line 912: 'OKC_REP_UTIL_PVT.check_contract_access returns has_access as : '

908: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
909: 'OKC_REP_UTIL_PVT.check_contract_access return status is: '
910: || l_return_status);
911: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
912: 'OKC_REP_UTIL_PVT.check_contract_access returns has_access as : '
913: || l_has_access);
914: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
915: 'Leaving Function has_contract_access');
916: END IF;

Line 970: 'Entered Function OKC_REP_UTIL_PVT.check_contract_access');

966: l_has_access := 'N';
967:
968: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
969: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
970: 'Entered Function OKC_REP_UTIL_PVT.check_contract_access');
971: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
972: 'Contract Id is: ' || p_contract_id);
973: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
974: 'Access Function Name is: ' || p_function_name);

Line 978: 'Calling OKC_REP_UTIL_PVT.has_contract_access');

974: 'Access Function Name is: ' || p_function_name);
975: END IF;
976: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
978: 'Calling OKC_REP_UTIL_PVT.has_contract_access');
979: END IF;
980: --- Call check_contract_access procedure.
981: check_contract_access(
982: p_api_version => 1.0,

Line 993: 'OKC_REP_UTIL_PVT.check_contract_access return status is: '

989: x_return_status => l_return_status
990: );
991: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
992: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
993: 'OKC_REP_UTIL_PVT.check_contract_access return status is: '
994: || l_return_status);
995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
996: 'OKC_REP_UTIL_PVT.check_contract_access returns has_access as : '
997: || l_has_access);

Line 996: 'OKC_REP_UTIL_PVT.check_contract_access returns has_access as : '

992: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
993: 'OKC_REP_UTIL_PVT.check_contract_access return status is: '
994: || l_return_status);
995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
996: 'OKC_REP_UTIL_PVT.check_contract_access returns has_access as : '
997: || l_has_access);
998: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
999: 'Leaving Function has_contract_access');
1000: END IF;

Line 1050: '200: Entered OKC_REP_UTIL_PVT.change_contract_status');

1046: l_api_name := 'change_contract_status';
1047:
1048: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1049: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1050: '200: Entered OKC_REP_UTIL_PVT.change_contract_status');
1051: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1052: '201: Contract Id is: ' || to_char(p_contract_id));
1053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1054: '202: Contract version is: ' || p_contract_version);

Line 1233: '300: Entered OKC_REP_UTIL_PVT.add_approval_hist_record');

1229: l_api_name := 'add_approval_hist_record';
1230:
1231: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1232: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1233: '300: Entered OKC_REP_UTIL_PVT.add_approval_hist_record');
1234: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1235: '301: Contract Id is: ' || to_char(p_contract_id));
1236: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1237: '302: Contract version is: ' || p_contract_version);

Line 1390: '300: Entered OKC_REP_UTIL_PVT.add_signature_hist_record');

1386: l_api_name := 'add_signature_hist_record';
1387:
1388: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1389: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1390: '300: Entered OKC_REP_UTIL_PVT.add_signature_hist_record');
1391: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1392: '301: Contract Id is: ' || to_char(p_contract_id));
1393: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1394: '302: Contract version is: ' || p_contract_version);

Line 2837: 'Entered OKC_REP_UTIL_PVT.populate_import_errors');

2833: l_api_name := 'populate_import_errors';
2834:
2835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2836: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2837: 'Entered OKC_REP_UTIL_PVT.populate_import_errors');
2838: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2839: 'p_contract_id = ' || p_contract_id);
2840: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2841: 'p_error_obj_type = ' || p_error_obj_type);

Line 2910: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);

2906: );
2907:
2908: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2909: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2910: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
2911: END IF;
2912:
2913: EXCEPTION
2914: WHEN FND_API.G_EXC_ERROR THEN

Line 3052: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);

3048: l_api_name := 'validate_import_documents';
3049:
3050: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3051: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3052: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
3053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3054: 'p_run_id = ' || p_run_id);
3055:
3056: END IF;

Line 3279: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);

3275: COMMIT;
3276:
3277: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3278: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3279: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
3280: END IF;
3281:
3282: EXCEPTION
3283: WHEN FND_API.G_EXC_ERROR THEN

Line 3423: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);

3419: l_api_name := 'validate_import_parties';
3420:
3421: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3422: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3423: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
3424: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3425: 'p_run_id = ' || p_run_id);
3426:
3427: END IF;

Line 3791: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);

3787: CLOSE IMPORT_PARTIES_CSR;
3788:
3789: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3790: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3791: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
3792: END IF;
3793:
3794: EXCEPTION
3795:

Line 4152: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);

4148: l_api_name := 'validate_import_contracts';
4149:
4150: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4152: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
4153: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4154: 'p_run_id = ' || p_run_id);
4155:
4156: END IF;

Line 5378: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);

5374: CLOSE IMPORT_CONTRACTS_CSR;
5375:
5376: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5377: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5378: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
5379: END IF;
5380:
5381:
5382: EXCEPTION

Line 6242: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);

6238:
6239: BEGIN
6240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6241: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6242: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
6243: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6244: 'p_run_id = ' || p_run_id);
6245:
6246: END IF;

Line 6445: 'Entered OKC_REP_UTIL_PVT.delete_import_contract');

6441: l_api_name := 'delete_import_contract';
6442:
6443: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6445: 'Entered OKC_REP_UTIL_PVT.delete_import_contract');
6446: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6447: 'p_contract_id = ' || p_contract_id);
6448: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6449: 'p_imp_document_id = ' || p_imp_document_id);

Line 6536: 'Leaving OKC_REP_UTIL_PVT.delete_import_contract');

6532:
6533:
6534: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6535: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6536: 'Leaving OKC_REP_UTIL_PVT.delete_import_contract');
6537: END IF;
6538:
6539: EXCEPTION
6540:

Line 6611: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);

6607: l_api_name := 'add_quotes';
6608:
6609: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6610: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6611: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);
6612: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6613: 'p_string is: ' || p_string);
6614: END IF;
6615:

Line 6634: 'Leaving Function OKC_REP_UTIL_PVT.'||l_api_name);

6630: END IF;
6631:
6632: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6633: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6634: 'Leaving Function OKC_REP_UTIL_PVT.'||l_api_name);
6635: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6636: 'l_string is: ' || l_string);
6637: END IF;
6638:

Line 6758: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);

6754: l_api_name := 'get_csv_error_string';
6755:
6756: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6757: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6758: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);
6759: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6760: 'p_imp_contract_id is: ' || p_imp_contract_id);
6761: END IF;
6762:

Line 6947: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);

6943: l_api_name := 'get_csv_header_string';
6944:
6945: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6946: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6947: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);
6948: END IF;
6949:
6950: l_csv_header_string := NULL;
6951: OPEN CSV_HEADER_CSR;

Line 6966: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);

6962: END IF;
6963:
6964: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6965: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6966: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);
6967: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6968: 'l_csv_header_string is: ' || l_csv_header_string);
6969: END IF;
6970:

Line 7048: 'Entered OKC_REP_UTIL_PVT.get_external_userlist');

7044: l_api_name := 'get_vendor_userlist';
7045:
7046: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7047: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7048: 'Entered OKC_REP_UTIL_PVT.get_external_userlist');
7049: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7050: 'p_document_id is: ' || to_char(p_document_id));
7051: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7052: 'p_external_party_id is: ' || to_char(p_external_party_id));

Line 7092: 'Leaving OKC_REP_UTIL_PVT.get_vendor_userlist');

7088: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7089:
7090: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7091: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7092: 'Leaving OKC_REP_UTIL_PVT.get_vendor_userlist');
7093: END IF;
7094:
7095:
7096: EXCEPTION

Line 7216: 'Entered OKC_REP_UTIL_PVT.get_customer_userlist');

7212: l_api_name := 'get_customer_userlist';
7213:
7214: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7215: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7216: 'Entered OKC_REP_UTIL_PVT.get_customer_userlist');
7217: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7218: 'p_document_id is: ' || to_char(p_document_id));
7219: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7220: 'p_external_party_id is: ' || to_char(p_external_party_id));

Line 7259: 'Leaving OKC_REP_UTIL_PVT.get_customer_userlist');

7255: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7256:
7257: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7258: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7259: 'Leaving OKC_REP_UTIL_PVT.get_customer_userlist');
7260: END IF;
7261:
7262:
7263: EXCEPTION

Line 7370: 'Entered OKC_REP_UTIL_PVT.get_external_userlist');

7366: l_api_name := 'get_external_userlist';
7367:
7368: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7369: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7370: 'Entered OKC_REP_UTIL_PVT.get_external_userlist');
7371: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7372: 'p_document_id is: ' || to_char(p_document_id));
7373: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7374: 'p_document_type is: ' || to_char(p_document_type));

Line 7421: 'Leaving OKC_REP_UTIL_PVT.get_external_userlist');

7417: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7418:
7419: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7420: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7421: 'Leaving OKC_REP_UTIL_PVT.get_external_userlist');
7422: END IF;
7423:
7424:
7425: EXCEPTION

Line 7594: '110: Leaving OKC_REP_UTIL_PVT.ok_to_commit');

7590: -- Standard call to get message count and if count is 1, get message info.
7591: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7592: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7593: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
7594: '110: Leaving OKC_REP_UTIL_PVT.ok_to_commit');
7595: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7596: '111: Output is: ' || l_ok_to_commit);
7597: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7598: '112: x_return_status is: ' || x_return_status);

Line 7656: 'Entering OKC_REP_UTIL_PVT.purge_recent_contracts');

7652: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7653: FND_LOG.STRING(
7654: FND_LOG.LEVEL_PROCEDURE,
7655: G_MODULE||l_api_name,
7656: 'Entering OKC_REP_UTIL_PVT.purge_recent_contracts');
7657: END IF;
7658:
7659: DELETE FROM okc_rep_recent_contracts c
7660: WHERE c.last_visited_date < SYSDATE - p_num_days;

Line 7666: 'Leaving OKC_REP_UTIL_PVT.purge_recent_contracts');

7662: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7663: FND_LOG.STRING(
7664: FND_LOG.LEVEL_PROCEDURE,
7665: G_MODULE||l_api_name,
7666: 'Leaving OKC_REP_UTIL_PVT.purge_recent_contracts');
7667: END IF;
7668:
7669: retcode := G_RETURN_CODE_SUCCESS;
7670:

Line 7704: 'Entered Function OKC_REP_UTIL_PVT.can_update');

7700: l_can_update := 'N';
7701:
7702: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7703: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7704: 'Entered Function OKC_REP_UTIL_PVT.can_update');
7705: END IF;
7706:
7707: IF FND_FUNCTION.TEST(G_FUNC_OKC_REP_ADMINISTRATOR,'Y') OR FND_FUNCTION.TEST(G_FUNC_OKC_REP_USER_FUNC,'Y') THEN
7708: l_can_update := 'Y';

Line 7713: 'OKC_REP_UTIL_PVT.check_contract_access returns l_can_update as : '

7709: END IF;
7710:
7711: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7712: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7713: 'OKC_REP_UTIL_PVT.check_contract_access returns l_can_update as : '
7714: || l_can_update);
7715: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7716: 'Leaving Function l_can_update');
7717: END IF;

Line 7758: 'Entered Function OKC_REP_UTIL_PVT.is_sales_workbench');

7754: l_is_sales_workbench := 'N';
7755:
7756: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7757: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7758: 'Entered Function OKC_REP_UTIL_PVT.is_sales_workbench');
7759: END IF;
7760:
7761: IF FND_FUNCTION.TEST(G_FUNC_OKC_REP_SALES_WB_USER,'Y') THEN
7762: l_is_sales_workbench := 'Y';

Line 7767: 'OKC_REP_UTIL_PVT.is_sales_workbench returns l_is_sales_workbench as : '

7763: END IF;
7764:
7765: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7766: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7767: 'OKC_REP_UTIL_PVT.is_sales_workbench returns l_is_sales_workbench as : '
7768: || l_is_sales_workbench);
7769: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7770: 'Leaving Function is_sales_workbench');
7771: END IF;

Line 7858: 'Entering OKC_REP_UTIL_PVT.insert_new_vendor_contact');

7854: l_api_name := 'insert_new_vendor_contact';
7855:
7856: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7857: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
7858: 'Entering OKC_REP_UTIL_PVT.insert_new_vendor_contact');
7859: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7860: 'p_vendor_site_id: ' || p_vendor_site_id);
7861: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7862: 'p_contract_id: ' || p_contract_id);

Line 7940: 'Leaving OKC_REP_UTIL_PVT.insert_new_vendor_contact');

7936: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7937: FND_LOG.STRING(
7938: FND_LOG.LEVEL_PROCEDURE,
7939: G_MODULE||l_api_name,
7940: 'Leaving OKC_REP_UTIL_PVT.insert_new_vendor_contact');
7941: END IF;
7942:
7943: EXCEPTION
7944: WHEN OTHERS THEN

Line 8018: 'Entering OKC_REP_UTIL_PVT.sync_con_header_attributes');

8014: x_return_status := FND_API.G_RET_STS_SUCCESS;
8015:
8016: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8017: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
8018: 'Entering OKC_REP_UTIL_PVT.sync_con_header_attributes');
8019: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8020: 'p_contract_id: ' || p_contract_id);
8021: END IF;
8022:

Line 8061: 'Leaving OKC_REP_UTIL_PVT.sync_con_header_attributes');

8057: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
8058:
8059: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8060: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8061: 'Leaving OKC_REP_UTIL_PVT.sync_con_header_attributes');
8062: END IF;
8063:
8064: EXCEPTION
8065: WHEN OTHERS THEN

Line 8170: 'Entered Function OKC_REP_UTIL_PVT.get_accessible_ous');

8166:
8167:
8168: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8169: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8170: 'Entered Function OKC_REP_UTIL_PVT.get_accessible_ous');
8171: END IF;
8172:
8173: l_ou_tab := MO_GLOBAL.get_ou_tab;
8174:

Line 8193: 'OKC_REP_UTIL_PVT.get_accessible_ous returns l_ou_list as : '

8189: END IF;
8190:
8191: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8192: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8193: 'OKC_REP_UTIL_PVT.get_accessible_ous returns l_ou_list as : '
8194: || l_ou_list);
8195: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8196: 'Leaving Function get_accessible_ous');
8197: END IF;

Line 8246: 'Entered Function OKC_REP_UTIL_PVT.get_quote_access');

8242: l_api_name := 'get_quote_access';
8243:
8244: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8245: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8246: 'Entered Function OKC_REP_UTIL_PVT.get_quote_access');
8247: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8248: 'Resource Id is: ' || p_resource_id);
8249: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8250: 'Quote Number is: ' || p_quote_number);

Line 8273: 'OKC_REP_UTIL_PVT.get_quote_access returns l_access as : '

8269: l_access := ASO_SECURITY_INT.get_quote_access(p_resource_id, p_quote_number);
8270: END IF;
8271: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8272: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8273: 'OKC_REP_UTIL_PVT.get_quote_access returns l_access as : '
8274: || l_access);
8275: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8276: 'Leaving Function get_quote_access');
8277: END IF;

Line 8324: 'Entered Procedure OKC_REP_UTIL_PVT.contract_terms_disabled_yn');

8320: l_api_name := 'contract_terms_disabled_yn';
8321:
8322: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8324: 'Entered Procedure OKC_REP_UTIL_PVT.contract_terms_disabled_yn');
8325: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8326: 'Contract Type is: ' || p_contract_type);
8327:
8328: END IF;

Line 8337: 'OKC_REP_UTIL_PVT.contract_terms_disabled_yn returns x_disable_contract_terms_yn as : '

8333:
8334:
8335: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8336: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8337: 'OKC_REP_UTIL_PVT.contract_terms_disabled_yn returns x_disable_contract_terms_yn as : '
8338: || x_disable_contract_terms_yn);
8339: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8340: 'Leaving Procedure contract_terms_disabled_yn');
8341: END IF;

Line 8376: 'Entered Procedure OKC_REP_UTIL_PVT.DocTyp_subent_disabled_yn');

8372: l_api_name := 'DocTyp_subent_disabled_yn';
8373:
8374: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8375: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8376: 'Entered Procedure OKC_REP_UTIL_PVT.DocTyp_subent_disabled_yn');
8377: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8378: 'Contract Type is: ' || p_contract_type);
8379:
8380: END IF;

Line 8387: 'OKC_REP_UTIL_PVT.DocTyp_subent_disabled_yn returns x_disable_subentities_yn as : '

8383: SELECT Nvl((SELECT 'Y' FROM okc_rep_contracts_all WHERE contract_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_subentities_yn FROM dual;
8384:
8385: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8386: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8387: 'OKC_REP_UTIL_PVT.DocTyp_subent_disabled_yn returns x_disable_subentities_yn as : '
8388: || x_disable_subentities_yn);
8389: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8390: 'Leaving Procedure DocTyp_subent_disabled_yn');
8391: END IF;

Line 8492: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);

8488: l_api_name := 'validate_import_contacts';
8489:
8490: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8491: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8492: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
8493: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8494: 'p_run_id = ' || p_run_id);
8495:
8496: END IF;

Line 8804: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);

8800: CLOSE IMPORT_CONTACTS_CSR;
8801:
8802: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8803: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8804: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
8805: END IF;
8806:
8807: EXCEPTION
8808:

Line 8974: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);

8970: l_api_name := 'validate_import_risks';
8971:
8972: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8973: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8974: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
8975: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
8976: 'p_run_id = ' || p_run_id);
8977:
8978: END IF;

Line 9189: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);

9185: CLOSE IMPORT_RISKS_CSR;
9186:
9187: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
9188: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
9189: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
9190: END IF;
9191:
9192: EXCEPTION
9193:

Line 9284: END OKC_REP_UTIL_PVT;

9280:
9281: END validate_import_risks;
9282:
9283:
9284: END OKC_REP_UTIL_PVT;