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.PO_CLM_CAR_UTIL dependencies on PO_LOG

Line 923: IF (PO_LOG.d_proc) THEN

919: d_progress NUMBER;
920: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_CAR_UTIL.car_for_control_type';
921: BEGIN
922: d_progress := 0;
923: IF (PO_LOG.d_proc) THEN
924: PO_LOG.proc_begin(d_module);
925: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
926: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
927: PO_LOG.proc_begin(d_module, 'p_special_contract_type ', p_special_contract_type);

Line 924: PO_LOG.proc_begin(d_module);

920: d_module VARCHAR2(70) := 'po.plsql.PO_CLM_CAR_UTIL.car_for_control_type';
921: BEGIN
922: d_progress := 0;
923: IF (PO_LOG.d_proc) THEN
924: PO_LOG.proc_begin(d_module);
925: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
926: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
927: PO_LOG.proc_begin(d_module, 'p_special_contract_type ', p_special_contract_type);
928: END IF;

Line 925: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);

921: BEGIN
922: d_progress := 0;
923: IF (PO_LOG.d_proc) THEN
924: PO_LOG.proc_begin(d_module);
925: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
926: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
927: PO_LOG.proc_begin(d_module, 'p_special_contract_type ', p_special_contract_type);
928: END IF;
929:

Line 926: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);

922: d_progress := 0;
923: IF (PO_LOG.d_proc) THEN
924: PO_LOG.proc_begin(d_module);
925: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
926: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
927: PO_LOG.proc_begin(d_module, 'p_special_contract_type ', p_special_contract_type);
928: END IF;
929:
930: d_progress := 10;

Line 927: PO_LOG.proc_begin(d_module, 'p_special_contract_type ', p_special_contract_type);

923: IF (PO_LOG.d_proc) THEN
924: PO_LOG.proc_begin(d_module);
925: PO_LOG.proc_begin(d_module, 'p_po_header_id', p_po_header_id);
926: PO_LOG.proc_begin(d_module, 'p_draft_id', p_draft_id);
927: PO_LOG.proc_begin(d_module, 'p_special_contract_type ', p_special_contract_type);
928: END IF;
929:
930: d_progress := 10;
931: -- Get reporting method and reason from global contract table as per special contract type passed

Line 936: IF (PO_LOG.d_stmt) THEN

932: l_fpds_reporting_method := PO_CORE_S3.g_object_special_contract_tbl(p_special_contract_type).FPDS_REPORTING_METHOD;
933: l_fpds_reason := PO_CORE_S3.g_object_special_contract_tbl(p_special_contract_type).FPDS_REASON;
934: l_exemptiom_reason := PO_CORE_S3.g_object_special_contract_tbl(p_special_contract_type).EXEMPTION_REASON;
935:
936: IF (PO_LOG.d_stmt) THEN
937: PO_LOG.stmt(d_module, d_progress, 'Reporting Method ' || l_fpds_reporting_method || ' and Reason ' || l_fpds_reason || ' exemption_reason is ' || l_exemptiom_reason );
938: END IF;
939:
940: IF l_fpds_reporting_method IS NOT NULL

Line 937: PO_LOG.stmt(d_module, d_progress, 'Reporting Method ' || l_fpds_reporting_method || ' and Reason ' || l_fpds_reason || ' exemption_reason is ' || l_exemptiom_reason );

933: l_fpds_reason := PO_CORE_S3.g_object_special_contract_tbl(p_special_contract_type).FPDS_REASON;
934: l_exemptiom_reason := PO_CORE_S3.g_object_special_contract_tbl(p_special_contract_type).EXEMPTION_REASON;
935:
936: IF (PO_LOG.d_stmt) THEN
937: PO_LOG.stmt(d_module, d_progress, 'Reporting Method ' || l_fpds_reporting_method || ' and Reason ' || l_fpds_reason || ' exemption_reason is ' || l_exemptiom_reason );
938: END IF;
939:
940: IF l_fpds_reporting_method IS NOT NULL
941: AND l_fpds_reason IS NOT NULL THEN

Line 957: IF (PO_LOG.d_stmt) THEN

953: INTO l_car_id
954: FROM po_clm_cars
955: WHERE po_header_id = p_po_header_id
956: AND NVL(po_draft_id, -1) = p_draft_id;
957: IF (PO_LOG.d_stmt) THEN
958: PO_LOG.stmt(d_module, d_progress, 'Car exists car_id '|| l_car_id);
959: END IF;
960:
961: -- Null out in casse values are hard coded as 'NA'

Line 958: PO_LOG.stmt(d_module, d_progress, 'Car exists car_id '|| l_car_id);

954: FROM po_clm_cars
955: WHERE po_header_id = p_po_header_id
956: AND NVL(po_draft_id, -1) = p_draft_id;
957: IF (PO_LOG.d_stmt) THEN
958: PO_LOG.stmt(d_module, d_progress, 'Car exists car_id '|| l_car_id);
959: END IF;
960:
961: -- Null out in casse values are hard coded as 'NA'
962: IF l_fpds_reason = 'NA' THEN

Line 985: IF (PO_LOG.d_stmt) THEN

981: AND reporting_method <> l_fpds_reporting_method
982: AND rel_without_rpt_reason <> l_fpds_reason;
983:
984: d_progress := 30;
985: IF (PO_LOG.d_stmt) THEN
986: PO_LOG.stmt(d_module, d_progress, 'Updated car ' || SQL%ROWCOUNT);
987: END IF;
988:
989: EXCEPTION

Line 986: PO_LOG.stmt(d_module, d_progress, 'Updated car ' || SQL%ROWCOUNT);

982: AND rel_without_rpt_reason <> l_fpds_reason;
983:
984: d_progress := 30;
985: IF (PO_LOG.d_stmt) THEN
986: PO_LOG.stmt(d_module, d_progress, 'Updated car ' || SQL%ROWCOUNT);
987: END IF;
988:
989: EXCEPTION
990: WHEN no_data_found THEN

Line 992: IF (PO_LOG.d_stmt) THEN

988:
989: EXCEPTION
990: WHEN no_data_found THEN
991: d_progress := 40;
992: IF (PO_LOG.d_stmt) THEN
993: PO_LOG.stmt(d_module, d_progress, 'Inserting new car');
994: END IF;
995: l_report_type := po_clm_car_util.get_report_type(p_po_header_id);
996: SELECT ATM.FPDS_AWARD_TYPE

Line 993: PO_LOG.stmt(d_module, d_progress, 'Inserting new car');

989: EXCEPTION
990: WHEN no_data_found THEN
991: d_progress := 40;
992: IF (PO_LOG.d_stmt) THEN
993: PO_LOG.stmt(d_module, d_progress, 'Inserting new car');
994: END IF;
995: l_report_type := po_clm_car_util.get_report_type(p_po_header_id);
996: SELECT ATM.FPDS_AWARD_TYPE
997: INTO l_award_idv_type

Line 1062: IF (PO_LOG.d_proc) THEN

1058: l_PIID);
1059: END; -- End for main begin
1060: END IF; -- End if for FPDS.REPORTING_METHOD and REASON
1061:
1062: IF (PO_LOG.d_proc) THEN
1063: PO_LOG.proc_end(d_module);
1064: END IF;
1065:
1066: EXCEPTION

Line 1063: PO_LOG.proc_end(d_module);

1059: END; -- End for main begin
1060: END IF; -- End if for FPDS.REPORTING_METHOD and REASON
1061:
1062: IF (PO_LOG.d_proc) THEN
1063: PO_LOG.proc_end(d_module);
1064: END IF;
1065:
1066: EXCEPTION
1067: WHEN OTHERS THEN

Line 1068: IF (PO_LOG.d_exc) THEN

1064: END IF;
1065:
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: IF (PO_LOG.d_exc) THEN
1069: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1070: PO_LOG.proc_end(d_module);
1071: END IF;
1072: RAISE;

Line 1069: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);

1065:
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: IF (PO_LOG.d_exc) THEN
1069: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1070: PO_LOG.proc_end(d_module);
1071: END IF;
1072: RAISE;
1073: END car_for_control_type;

Line 1070: PO_LOG.proc_end(d_module);

1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: IF (PO_LOG.d_exc) THEN
1069: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1070: PO_LOG.proc_end(d_module);
1071: END IF;
1072: RAISE;
1073: END car_for_control_type;
1074: