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_UPD_CON_ADMIN_PVT dependencies on FND_LOG

Line 45: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

41: BEGIN
42:
43: l_api_name := 'populate_output_and_log_file';
44:
45: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
46: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
47: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.populate_output_and_log_file');
48: END IF;
49:

Line 46: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

42:
43: l_api_name := 'populate_output_and_log_file';
44:
45: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
46: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
47: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.populate_output_and_log_file');
48: END IF;
49:
50: -- Show the text Contract Details only once

Line 110: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

106:
107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '====================================');
108: FND_FILE.PUT_LINE(FND_FILE.LOG, '====================================');
109:
110: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
112: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.populate_output_and_log_file');
113: END IF;
114:

Line 111: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '====================================');
108: FND_FILE.PUT_LINE(FND_FILE.LOG, '====================================');
109:
110: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
111: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
112: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.populate_output_and_log_file');
113: END IF;
114:
115: END populate_output_and_log_file;

Line 193: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

189: BEGIN
190:
191: l_api_name := 'populate_report_parameters';
192:
193: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
194: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
195: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.populate_report_parameters');
196: END IF;
197:

Line 194: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

190:
191: l_api_name := 'populate_report_parameters';
192:
193: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
194: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
195: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.populate_report_parameters');
196: END IF;
197:
198: -- Get the translated string for the text "Not Available"

Line 312: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

308:
309: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
310:
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_UPD_CON_ADMIN_PVT.populate_report_parameters');
315: END IF;
316:

Line 313: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

309: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
310:
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_UPD_CON_ADMIN_PVT.populate_report_parameters');
315: END IF;
316:
317: EXCEPTION

Line 319: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

315: END IF;
316:
317: EXCEPTION
318: WHEN OTHERS THEN
319: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
321: g_module || l_api_name,
322: 'Leaving populate_report_parameters because of EXCEPTION: ' || sqlerrm);
323: END IF;

Line 320: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

316:
317: EXCEPTION
318: WHEN OTHERS THEN
319: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
320: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
321: g_module || l_api_name,
322: 'Leaving populate_report_parameters because of EXCEPTION: ' || sqlerrm);
323: END IF;
324:

Line 604: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

600: BEGIN
601:
602: l_api_name := 'update_con_admin_manager';
603:
604: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
606: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');
607: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
608: 'p_doc_type: ' || p_doc_type);

Line 605: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

601:
602: l_api_name := 'update_con_admin_manager';
603:
604: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
606: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');
607: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
608: 'p_doc_type: ' || p_doc_type);
609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 607: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

603:
604: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
606: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');
607: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
608: 'p_doc_type: ' || p_doc_type);
609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
610: 'p_cust_id: ' || p_cust_id);
611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

605: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
606: 'Entered OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');
607: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
608: 'p_doc_type: ' || p_doc_type);
609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
610: 'p_cust_id: ' || p_cust_id);
611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
612: 'p_prev_con_admin_id: ' || p_prev_con_admin_id);
613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

607: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
608: 'p_doc_type: ' || p_doc_type);
609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
610: 'p_cust_id: ' || p_cust_id);
611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
612: 'p_prev_con_admin_id: ' || p_prev_con_admin_id);
613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
614: 'p_salesrep_id: ' || p_salesrep_id);
615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
610: 'p_cust_id: ' || p_cust_id);
611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
612: 'p_prev_con_admin_id: ' || p_prev_con_admin_id);
613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
614: 'p_salesrep_id: ' || p_salesrep_id);
615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
616: 'p_sales_group_id: ' || p_sales_group_id);
617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

611: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
612: 'p_prev_con_admin_id: ' || p_prev_con_admin_id);
613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
614: 'p_salesrep_id: ' || p_salesrep_id);
615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
616: 'p_sales_group_id: ' || p_sales_group_id);
617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
618: 'p_org_id: ' || p_org_id);
619: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

613: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
614: 'p_salesrep_id: ' || p_salesrep_id);
615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
616: 'p_sales_group_id: ' || p_sales_group_id);
617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
618: 'p_org_id: ' || p_org_id);
619: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
620: 'p_order_type_id: ' || p_order_type_id);
621: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 619: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
616: 'p_sales_group_id: ' || p_sales_group_id);
617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
618: 'p_org_id: ' || p_org_id);
619: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
620: 'p_order_type_id: ' || p_order_type_id);
621: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
622: 'p_con_admin_from: ' || p_con_admin_from);
623: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 621: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

617: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
618: 'p_org_id: ' || p_org_id);
619: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
620: 'p_order_type_id: ' || p_order_type_id);
621: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
622: 'p_con_admin_from: ' || p_con_admin_from);
623: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
624: 'p_new_con_admin_id: ' || p_new_con_admin_user_id);
625: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 623: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

619: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
620: 'p_order_type_id: ' || p_order_type_id);
621: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
622: 'p_con_admin_from: ' || p_con_admin_from);
623: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
624: 'p_new_con_admin_id: ' || p_new_con_admin_user_id);
625: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
626: 'p_new_con_admin_name: ' || p_new_con_admin_name);
627: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

Line 625: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

621: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
622: 'p_con_admin_from: ' || p_con_admin_from);
623: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
624: 'p_new_con_admin_id: ' || p_new_con_admin_user_id);
625: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
626: 'p_new_con_admin_name: ' || p_new_con_admin_name);
627: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
628: 'p_mode: ' || p_mode);
629: END IF;

Line 627: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

623: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
624: 'p_new_con_admin_id: ' || p_new_con_admin_user_id);
625: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
626: 'p_new_con_admin_name: ' || p_new_con_admin_name);
627: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
628: 'p_mode: ' || p_mode);
629: END IF;
630:
631: -- Standard Start of API savepoint

Line 656: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

652: IF(p_doc_type = G_DOC_TYPE_ANY OR
653: p_doc_type = G_DOC_TYPE_ALL_OM OR
654: p_doc_type = G_DOC_TYPE_BSA) THEN
655:
656: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
657: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
658: 'Fetching BSAs ...');
659: END IF;
660:

Line 657: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

653: p_doc_type = G_DOC_TYPE_ALL_OM OR
654: p_doc_type = G_DOC_TYPE_BSA) THEN
655:
656: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
657: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
658: 'Fetching BSAs ...');
659: END IF;
660:
661: OPEN selected_bsa_csr;

Line 722: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

718: IF(p_doc_type = G_DOC_TYPE_ANY OR
719: p_doc_type = G_DOC_TYPE_ALL_OM OR
720: p_doc_type = G_DOC_TYPE_SO) THEN
721:
722: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
724: 'Fetching Sales Orders ...');
725: END IF;
726:

Line 723: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

719: p_doc_type = G_DOC_TYPE_ALL_OM OR
720: p_doc_type = G_DOC_TYPE_SO) THEN
721:
722: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
724: 'Fetching Sales Orders ...');
725: END IF;
726:
727: OPEN selected_so_csr;

Line 788: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

784: -- Fetch Quotes using user entered search criteria
785: IF(p_doc_type = G_DOC_TYPE_ANY OR
786: p_doc_type = G_DOC_TYPE_QUOTE) THEN
787:
788: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
789: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
790: 'Fetching Sales Quotes ...');
791: END IF;
792:

Line 789: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

785: IF(p_doc_type = G_DOC_TYPE_ANY OR
786: p_doc_type = G_DOC_TYPE_QUOTE) THEN
787:
788: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
789: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
790: 'Fetching Sales Quotes ...');
791: END IF;
792:
793: OPEN selected_quote_csr;

Line 815: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

811:
812: -- If user selects Sales Group Assignment as Contract Administrator from
813: IF( p_con_admin_from = G_CON_ADMIN_FROM_SALES_GROUP) THEN
814:
815: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
816: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
817: 'Calling OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');
818: END IF;
819:

Line 816: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

812: -- If user selects Sales Group Assignment as Contract Administrator from
813: IF( p_con_admin_from = G_CON_ADMIN_FROM_SALES_GROUP) THEN
814:
815: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
816: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
817: 'Calling OKC_TERMS_UTIL_PVT.get_sales_group_con_admin');
818: END IF;
819:
820: -- Call the following Terms API to get the new contract administrator id according

Line 843: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

839:
840: -- Check whether the current and the new Contract Administrators are same
841: IF(l_new_con_admin_user_id = selected_quote(i).contract_admin_id) THEN
842:
843: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
844: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
845: 'Current and the new Contract Administrators are same');
846: END IF;
847:

Line 844: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

840: -- Check whether the current and the new Contract Administrators are same
841: IF(l_new_con_admin_user_id = selected_quote(i).contract_admin_id) THEN
842:
843: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
844: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
845: 'Current and the new Contract Administrators are same');
846: END IF;
847:
848: l_msg_type := G_WARNING_CODE;

Line 860: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

856: IF (validate_con_admin_csr%ROWCOUNT = 0) THEN
857:
858: -- If the contract administrator is not an active employee
859:
860: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
861: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
862: 'Contract Administrator with user id ' || l_new_con_admin_user_id || ' is not an active employee');
863: END IF;
864:

Line 861: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

857:
858: -- If the contract administrator is not an active employee
859:
860: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
861: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
862: 'Contract Administrator with user id ' || l_new_con_admin_user_id || ' is not an active employee');
863: END IF;
864:
865: l_msg_type := G_ERROR_CODE;

Line 873: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

869: ELSE -- If the contract administrator is an active employee
870:
871: CLOSE validate_con_admin_csr;
872:
873: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
874: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
875: 'New Contract Administrator Id ' || l_new_con_admin_user_id);
876: END IF;
877:

Line 874: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

870:
871: CLOSE validate_con_admin_csr;
872:
873: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
874: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
875: 'New Contract Administrator Id ' || l_new_con_admin_user_id);
876: END IF;
877:
878: OPEN con_admin_name_csr(l_new_con_admin_user_id);

Line 882: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

878: OPEN con_admin_name_csr(l_new_con_admin_user_id);
879: FETCH con_admin_name_csr INTO l_new_con_admin_user_name;
880: CLOSE con_admin_name_csr;
881:
882: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
883: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
884: 'New Contract Administrator Name ' || l_new_con_admin_user_name);
885: END IF;
886:

Line 883: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

879: FETCH con_admin_name_csr INTO l_new_con_admin_user_name;
880: CLOSE con_admin_name_csr;
881:
882: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
883: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
884: 'New Contract Administrator Name ' || l_new_con_admin_user_name);
885: END IF;
886:
887: END IF; -- End of validate_con_admin_csr%ROWCOUNT = 0

Line 893: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

889: END IF; -- End of l_new_con_admin_user_id = selected_quote(i).contract_admin_id
890:
891: ELSE -- l_new_con_admin_user_id is NULL
892:
893: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
895: 'No Contract Administrator found.');
896: END IF;
897:

Line 894: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

890:
891: ELSE -- l_new_con_admin_user_id is NULL
892:
893: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
894: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
895: 'No Contract Administrator found.');
896: END IF;
897:
898: -- Increment the errored document count

Line 962: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

958: -- Sales Orders and Sales Quotes
959: IF(p_mode = G_MODE_UPDATE AND
960: l_selected_doc_ids.LAST > 0) THEN
961:
962: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
963: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
964: 'Calling OKC_TERMS_UTIL_PVT.update_contract_admin');
965: END IF;
966:

Line 963: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

959: IF(p_mode = G_MODE_UPDATE AND
960: l_selected_doc_ids.LAST > 0) THEN
961:
962: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
963: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
964: 'Calling OKC_TERMS_UTIL_PVT.update_contract_admin');
965: END IF;
966:
967: OKC_TERMS_UTIL_PVT.update_contract_admin(

Line 994: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

990: -- Fetch Repository Contracts using user entered search criteria
991: IF(p_doc_type = G_DOC_TYPE_ANY OR
992: p_doc_type = G_DOC_TYPE_REP) THEN
993:
994: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
996: 'Fetching Repository Contracts ...');
997: END IF;
998:

Line 995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

991: IF(p_doc_type = G_DOC_TYPE_ANY OR
992: p_doc_type = G_DOC_TYPE_REP) THEN
993:
994: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
996: 'Fetching Repository Contracts ...');
997: END IF;
998:
999: l_msg_code := NULL;

Line 1023: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1019: -- Getting the following compilation error
1020: -- PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
1021: selected_rep_con_ids(i) := selected_rep(i).contract_id;
1022:
1023: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1025: 'Getting customer names of the current Repository Contract ...');
1026: END IF;
1027:

Line 1024: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1020: -- PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records
1021: selected_rep_con_ids(i) := selected_rep(i).contract_id;
1022:
1023: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1024: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1025: 'Getting customer names of the current Repository Contract ...');
1026: END IF;
1027:
1028: -- Fetch current contract customer names

Line 1044: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1040: l_cust_names := l_cust_names ||', '|| l_rep_cust_names(j);
1041: END IF;
1042: END LOOP;
1043:
1044: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1045: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1046: 'Customer names of the current Repository Contract ' || l_cust_names);
1047: END IF;
1048:

Line 1045: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1041: END IF;
1042: END LOOP;
1043:
1044: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1045: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1046: 'Customer names of the current Repository Contract ' || l_cust_names);
1047: END IF;
1048:
1049: -- Get current Contract Administrator name

Line 1073: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1069: -- If the current mode is UPDATE, then update the Contract Administrator of the
1070: -- selected Repository Contracts
1071: IF (p_mode = G_MODE_UPDATE) THEN
1072:
1073: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1074: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1075: 'Updating Latest version of Repository Contract with new Contract Administrator');
1076: END IF;
1077:

Line 1074: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1070: -- selected Repository Contracts
1071: IF (p_mode = G_MODE_UPDATE) THEN
1072:
1073: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1074: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1075: 'Updating Latest version of Repository Contract with new Contract Administrator');
1076: END IF;
1077:
1078: FORALL i IN NVL(selected_rep_con_ids.FIRST,0)..NVL(selected_rep_con_ids.LAST,-1)

Line 1085: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1081: SET owner_id = p_new_con_admin_user_id
1082: WHERE contract_id = selected_rep_con_ids(i);
1083:
1084: /* ---- Per CR, Contract Admin is now version specific.
1085: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1087: 'Updating Archived versions of Repository Contract with new Contract Administrator');
1088: END IF;
1089:

Line 1086: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,

1082: WHERE contract_id = selected_rep_con_ids(i);
1083:
1084: /* ---- Per CR, Contract Admin is now version specific.
1085: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1086: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1087: 'Updating Archived versions of Repository Contract with new Contract Administrator');
1088: END IF;
1089:
1090:

Line 1140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1136: END IF;
1137:
1138: retcode := G_RETURN_CODE_SUCCESS;
1139:
1140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1142: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');
1143: END IF;
1144:

Line 1141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,

1137:
1138: retcode := G_RETURN_CODE_SUCCESS;
1139:
1140: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1142: 'Leaving OKC_REP_UPD_CON_ADMIN_PVT.update_con_admin_manager');
1143: END IF;
1144:
1145: EXCEPTION

Line 1147: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1143: END IF;
1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1149: g_module || l_api_name,
1150: 'Leaving update_con_admin_manager because of EXCEPTION: ' || sqlerrm);
1151: END IF;

Line 1148: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,

1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1148: fnd_log.string(FND_LOG.LEVEL_EXCEPTION,
1149: g_module || l_api_name,
1150: 'Leaving update_con_admin_manager because of EXCEPTION: ' || sqlerrm);
1151: END IF;
1152: