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.30.12010000.2 2008/10/24 08:05:05 ssreekum ship $ */
3:
4:
5: ------------------------------------------------------------------------------

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

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

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

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

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

524: l_api_name := 'check_contract_access';
525:
526: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
527: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
528: '100: Entered OKC_REP_UTIL_PVT.check_contract_access');
529: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
530: '101: Contract Id is: ' || to_char(p_contract_id));
531: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
532: '102: Fucntion Name is: ' || p_function_name);

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

686: END IF; -- End of MO_GLOBAL check
687:
688: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
690: '110: Leaving OKC_REP_UTIL_PVT.check_contract_access');
691: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
692: '111: x_has_access is: ' || x_has_access);
693: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
694: '112: x_return_status is: ' || x_return_status);

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

801: l_has_access := 'N';
802:
803: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
804: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
805: 'Entered Function OKC_REP_UTIL_PVT.check_contract_access');
806: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
807: 'Contract Id is: ' || p_contract_id);
808: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
809: 'Contract Type is: ' || p_contract_type);

Line 813: 'Calling OKC_REP_UTIL_PVT.has_contract_access');

809: 'Contract Type is: ' || p_contract_type);
810: END IF;
811: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
812: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
813: 'Calling OKC_REP_UTIL_PVT.has_contract_access');
814: END IF;
815: --- Call check_contract_access procedure.
816: check_contract_access_external(
817: p_api_version => 1.0,

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

824: x_return_status => l_return_status
825: );
826: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
827: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
828: 'OKC_REP_UTIL_PVT.check_contract_access return status is: '
829: || l_return_status);
830: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
831: 'OKC_REP_UTIL_PVT.check_contract_access returns has_access as : '
832: || l_has_access);

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

827: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
828: 'OKC_REP_UTIL_PVT.check_contract_access return status is: '
829: || l_return_status);
830: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
831: 'OKC_REP_UTIL_PVT.check_contract_access returns has_access as : '
832: || l_has_access);
833: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
834: 'Leaving Function has_contract_access');
835: END IF;

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

885: l_has_access := 'N';
886:
887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
888: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
889: 'Entered Function OKC_REP_UTIL_PVT.check_contract_access');
890: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
891: 'Contract Id is: ' || p_contract_id);
892: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
893: 'Access Function Name is: ' || p_function_name);

Line 897: 'Calling OKC_REP_UTIL_PVT.has_contract_access');

893: 'Access Function Name is: ' || p_function_name);
894: END IF;
895: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
896: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
897: 'Calling OKC_REP_UTIL_PVT.has_contract_access');
898: END IF;
899: --- Call check_contract_access procedure.
900: check_contract_access(
901: p_api_version => 1.0,

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

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

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

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

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

965: l_api_name := 'change_contract_status';
966:
967: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
969: '200: Entered OKC_REP_UTIL_PVT.change_contract_status');
970: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
971: '201: Contract Id is: ' || to_char(p_contract_id));
972: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
973: '202: Contract version is: ' || p_contract_version);

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

1145: l_api_name := 'add_approval_hist_record';
1146:
1147: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1149: '300: Entered OKC_REP_UTIL_PVT.add_approval_hist_record');
1150: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1151: '301: Contract Id is: ' || to_char(p_contract_id));
1152: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1153: '302: Contract version is: ' || p_contract_version);

Line 2579: 'Entered OKC_REP_UTIL_PVT.populate_import_errors');

2575: l_api_name := 'populate_import_errors';
2576:
2577: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2578: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2579: 'Entered OKC_REP_UTIL_PVT.populate_import_errors');
2580: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2581: 'p_contract_id = ' || p_contract_id);
2582: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2583: 'p_error_obj_type = ' || p_error_obj_type);

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

2646: );
2647:
2648: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2649: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2650: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
2651: END IF;
2652:
2653: EXCEPTION
2654: WHEN FND_API.G_EXC_ERROR THEN

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

2788: l_api_name := 'validate_import_documents';
2789:
2790: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2791: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2792: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
2793: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2794: 'p_request_id = ' || p_request_id);
2795:
2796: END IF;

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

3015: COMMIT;
3016:
3017: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3018: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3019: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
3020: END IF;
3021:
3022: EXCEPTION
3023: WHEN FND_API.G_EXC_ERROR THEN

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

3151: l_api_name := 'validate_import_parties';
3152:
3153: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3154: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3155: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
3156: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3157: 'p_request_id = ' || p_request_id);
3158:
3159: END IF;

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

3511: CLOSE IMPORT_PARTIES_CSR;
3512:
3513: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3514: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3515: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
3516: END IF;
3517:
3518: EXCEPTION
3519:

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

3785: l_api_name := 'validate_import_contracts';
3786:
3787: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3788: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3789: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
3790: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3791: 'p_request_id = ' || p_request_id);
3792:
3793: END IF;

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

4689: CLOSE IMPORT_CONTRACTS_CSR;
4690:
4691: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4692: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4693: 'Leaving OKC_REP_UTIL_PVT.'||l_api_name);
4694: END IF;
4695:
4696:
4697: EXCEPTION

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

5384:
5385: BEGIN
5386: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5387: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5388: 'Entered OKC_REP_UTIL_PVT.'||l_api_name);
5389: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5390: 'p_request_id = ' || p_request_id);
5391:
5392: END IF;

Line 5562: 'Entered OKC_REP_UTIL_PVT.delete_import_contract');

5558: l_api_name := 'delete_import_contract';
5559:
5560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5561: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5562: 'Entered OKC_REP_UTIL_PVT.delete_import_contract');
5563: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5564: 'p_contract_id = ' || p_contract_id);
5565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5566: 'p_imp_document_id = ' || p_imp_document_id);

Line 5653: 'Leaving OKC_REP_UTIL_PVT.delete_import_contract');

5649:
5650:
5651: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5652: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5653: 'Leaving OKC_REP_UTIL_PVT.delete_import_contract');
5654: END IF;
5655:
5656: EXCEPTION
5657:

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

5724: l_api_name := 'add_quotes';
5725:
5726: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5727: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5728: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);
5729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5730: 'p_string is: ' || p_string);
5731: END IF;
5732:

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

5747: END IF;
5748:
5749: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5750: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5751: 'Leaving Function OKC_REP_UTIL_PVT.'||l_api_name);
5752: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5753: 'l_string is: ' || l_string);
5754: END IF;
5755:

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

5871: l_api_name := 'get_csv_error_string';
5872:
5873: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5874: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5875: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);
5876: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5877: 'p_imp_contract_id is: ' || p_imp_contract_id);
5878: END IF;
5879:

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

6060: l_api_name := 'get_csv_header_string';
6061:
6062: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6063: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6064: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);
6065: END IF;
6066:
6067: l_csv_header_string := NULL;
6068: OPEN CSV_HEADER_CSR;

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

6079: END IF;
6080:
6081: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6082: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6083: 'Entered Function OKC_REP_UTIL_PVT.'||l_api_name);
6084: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6085: 'l_csv_header_string is: ' || l_csv_header_string);
6086: END IF;
6087:

Line 6165: 'Entered OKC_REP_UTIL_PVT.get_external_userlist');

6161: l_api_name := 'get_vendor_userlist';
6162:
6163: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6164: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6165: 'Entered OKC_REP_UTIL_PVT.get_external_userlist');
6166: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6167: 'p_document_id is: ' || to_char(p_document_id));
6168: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6169: 'p_external_party_id is: ' || to_char(p_external_party_id));

Line 6209: 'Leaving OKC_REP_UTIL_PVT.get_vendor_userlist');

6205: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6206:
6207: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6208: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6209: 'Leaving OKC_REP_UTIL_PVT.get_vendor_userlist');
6210: END IF;
6211:
6212:
6213: EXCEPTION

Line 6333: 'Entered OKC_REP_UTIL_PVT.get_customer_userlist');

6329: l_api_name := 'get_customer_userlist';
6330:
6331: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6332: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6333: 'Entered OKC_REP_UTIL_PVT.get_customer_userlist');
6334: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6335: 'p_document_id is: ' || to_char(p_document_id));
6336: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6337: 'p_external_party_id is: ' || to_char(p_external_party_id));

Line 6376: 'Leaving OKC_REP_UTIL_PVT.get_customer_userlist');

6372: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6373:
6374: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6375: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6376: 'Leaving OKC_REP_UTIL_PVT.get_customer_userlist');
6377: END IF;
6378:
6379:
6380: EXCEPTION

Line 6487: 'Entered OKC_REP_UTIL_PVT.get_external_userlist');

6483: l_api_name := 'get_external_userlist';
6484:
6485: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6487: 'Entered OKC_REP_UTIL_PVT.get_external_userlist');
6488: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6489: 'p_document_id is: ' || to_char(p_document_id));
6490: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6491: 'p_document_type is: ' || to_char(p_document_type));

Line 6538: 'Leaving OKC_REP_UTIL_PVT.get_external_userlist');

6534: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6535:
6536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6537: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6538: 'Leaving OKC_REP_UTIL_PVT.get_external_userlist');
6539: END IF;
6540:
6541:
6542: EXCEPTION

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

6707: -- Standard call to get message count and if count is 1, get message info.
6708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6709: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6710: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6711: '110: Leaving OKC_REP_UTIL_PVT.ok_to_commit');
6712: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6713: '111: Output is: ' || l_ok_to_commit);
6714: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6715: '112: x_return_status is: ' || x_return_status);

Line 6773: 'Entering OKC_REP_UTIL_PVT.purge_recent_contracts');

6769: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6770: FND_LOG.STRING(
6771: FND_LOG.LEVEL_PROCEDURE,
6772: G_MODULE||l_api_name,
6773: 'Entering OKC_REP_UTIL_PVT.purge_recent_contracts');
6774: END IF;
6775:
6776: DELETE FROM okc_rep_recent_contracts c
6777: WHERE c.last_visited_date < SYSDATE - p_num_days;

Line 6783: 'Leaving OKC_REP_UTIL_PVT.purge_recent_contracts');

6779: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6780: FND_LOG.STRING(
6781: FND_LOG.LEVEL_PROCEDURE,
6782: G_MODULE||l_api_name,
6783: 'Leaving OKC_REP_UTIL_PVT.purge_recent_contracts');
6784: END IF;
6785:
6786: retcode := G_RETURN_CODE_SUCCESS;
6787:

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

6817: l_can_update := 'N';
6818:
6819: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6820: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6821: 'Entered Function OKC_REP_UTIL_PVT.can_update');
6822: END IF;
6823:
6824: IF FND_FUNCTION.TEST(G_FUNC_OKC_REP_ADMINISTRATOR,'Y') OR FND_FUNCTION.TEST(G_FUNC_OKC_REP_USER_FUNC,'Y') THEN
6825: l_can_update := 'Y';

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

6826: END IF;
6827:
6828: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6829: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6830: 'OKC_REP_UTIL_PVT.check_contract_access returns l_can_update as : '
6831: || l_can_update);
6832: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6833: 'Leaving Function l_can_update');
6834: END IF;

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

6871: l_is_sales_workbench := 'N';
6872:
6873: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6874: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6875: 'Entered Function OKC_REP_UTIL_PVT.is_sales_workbench');
6876: END IF;
6877:
6878: IF FND_FUNCTION.TEST(G_FUNC_OKC_REP_SALES_WB_USER,'Y') THEN
6879: l_is_sales_workbench := 'Y';

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

6880: END IF;
6881:
6882: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6883: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6884: 'OKC_REP_UTIL_PVT.is_sales_workbench returns l_is_sales_workbench as : '
6885: || l_is_sales_workbench);
6886: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6887: 'Leaving Function is_sales_workbench');
6888: END IF;

Line 6965: 'Entering OKC_REP_UTIL_PVT.insert_new_vendor_contact');

6961: l_api_name := 'insert_new_vendor_contact';
6962:
6963: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6964: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
6965: 'Entering OKC_REP_UTIL_PVT.insert_new_vendor_contact');
6966: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6967: 'p_vendor_site_id: ' || p_vendor_site_id);
6968: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6969: 'p_contract_id: ' || p_contract_id);

Line 7038: 'Leaving OKC_REP_UTIL_PVT.insert_new_vendor_contact');

7034: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7035: FND_LOG.STRING(
7036: FND_LOG.LEVEL_PROCEDURE,
7037: G_MODULE||l_api_name,
7038: 'Leaving OKC_REP_UTIL_PVT.insert_new_vendor_contact');
7039: END IF;
7040:
7041: EXCEPTION
7042: WHEN OTHERS THEN

Line 7116: 'Entering OKC_REP_UTIL_PVT.sync_con_header_attributes');

7112: x_return_status := FND_API.G_RET_STS_SUCCESS;
7113:
7114: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7115: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,
7116: 'Entering OKC_REP_UTIL_PVT.sync_con_header_attributes');
7117: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7118: 'p_contract_id: ' || p_contract_id);
7119: END IF;
7120:

Line 7159: 'Leaving OKC_REP_UTIL_PVT.sync_con_header_attributes');

7155: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7156:
7157: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7158: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7159: 'Leaving OKC_REP_UTIL_PVT.sync_con_header_attributes');
7160: END IF;
7161:
7162: EXCEPTION
7163: WHEN OTHERS THEN

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

7264:
7265:
7266: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7267: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7268: 'Entered Function OKC_REP_UTIL_PVT.get_accessible_ous');
7269: END IF;
7270:
7271: l_ou_tab := MO_GLOBAL.get_ou_tab;
7272:

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

7287: END IF;
7288:
7289: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7290: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7291: 'OKC_REP_UTIL_PVT.get_accessible_ous returns l_ou_list as : '
7292: || l_ou_list);
7293: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7294: 'Leaving Function get_accessible_ous');
7295: END IF;

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

7340: l_api_name := 'get_quote_access';
7341:
7342: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7343: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7344: 'Entered Function OKC_REP_UTIL_PVT.get_quote_access');
7345: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7346: 'Resource Id is: ' || p_resource_id);
7347: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7348: 'Quote Number is: ' || p_quote_number);

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

7367: l_access := ASO_SECURITY_INT.get_quote_access(p_resource_id, p_quote_number);
7368: END IF;
7369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7370: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7371: 'OKC_REP_UTIL_PVT.get_quote_access returns l_access as : '
7372: || l_access);
7373: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7374: 'Leaving Function get_quote_access');
7375: END IF;

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

7418: l_api_name := 'contract_terms_disabled_yn';
7419:
7420: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7421: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7422: 'Entered Procedure OKC_REP_UTIL_PVT.contract_terms_disabled_yn');
7423: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7424: 'Contract Type is: ' || p_contract_type);
7425:
7426: END IF;

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

7431:
7432:
7433: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7434: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7435: 'OKC_REP_UTIL_PVT.contract_terms_disabled_yn returns x_disable_contract_terms_yn as : '
7436: || x_disable_contract_terms_yn);
7437: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
7438: 'Leaving Procedure contract_terms_disabled_yn');
7439: END IF;

Line 7463: END OKC_REP_UTIL_PVT;

7459:
7460:
7461:
7462:
7463: END OKC_REP_UTIL_PVT;