DBA Data[Home] [Help]

APPS.PO_CLM_CAR_UTIL dependencies on DBMS_OUTPUT

Line 58: --DBMS_OUTPUT.PUT_LINE(l_car_id);

54: l_po_draft_id := p_clm_car_row.po_draft_id;
55: IF l_po_draft_id IS NULL THEN
56: l_po_draft_id := -1;
57: END IF;
58: --DBMS_OUTPUT.PUT_LINE(l_car_id);
59: --DBMS_OUTPUT.PUT_LINE(p_clm_car_row.po_header_id);
60: --DBMS_OUTPUT.PUT_LINE(l_po_draft_id);
61: --default the reporting method of mod to its base award's reporting method
62: IF l_po_draft_id <> -1 THEN

Line 59: --DBMS_OUTPUT.PUT_LINE(p_clm_car_row.po_header_id);

55: IF l_po_draft_id IS NULL THEN
56: l_po_draft_id := -1;
57: END IF;
58: --DBMS_OUTPUT.PUT_LINE(l_car_id);
59: --DBMS_OUTPUT.PUT_LINE(p_clm_car_row.po_header_id);
60: --DBMS_OUTPUT.PUT_LINE(l_po_draft_id);
61: --default the reporting method of mod to its base award's reporting method
62: IF l_po_draft_id <> -1 THEN
63: SELECT DISTINCT REPORTING_METHOD

Line 60: --DBMS_OUTPUT.PUT_LINE(l_po_draft_id);

56: l_po_draft_id := -1;
57: END IF;
58: --DBMS_OUTPUT.PUT_LINE(l_car_id);
59: --DBMS_OUTPUT.PUT_LINE(p_clm_car_row.po_header_id);
60: --DBMS_OUTPUT.PUT_LINE(l_po_draft_id);
61: --default the reporting method of mod to its base award's reporting method
62: IF l_po_draft_id <> -1 THEN
63: SELECT DISTINCT REPORTING_METHOD
64: INTO l_reporting_method

Line 184: --DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);

180: x_error_msg := 'Cannot create more than one CAR for Single CAR reporting method. ';
181: WHEN OTHERS THEN
182: x_return_status := 'E';
183: x_error_msg := 'Cannot sync CAR: ' || dbms_utility.format_error_backtrace;
184: --DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);
185: END;
186:
187: PROCEDURE link_car
188: (

Line 285: --DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);

281: EXCEPTION
282: WHEN OTHERS THEN
283: x_return_status := 'E';
284: x_error_msg := 'Cannot delete CAR: ' || dbms_utility.format_error_backtrace;
285: --DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);
286: END;
287:
288: PROCEDURE log_clm_car_messages
289: (

Line 356: --DBMS_OUTPUT.PUT_LINE(x_error_msg);

352: x_error_msg := 'No CAR ID was found. With ' ||
353: 'PO HEADER ID: ' || p_po_header_id ||
354: ', PO DRAFT ID: ' || NVL(p_po_draft_id, -1) ||
355: 'Cannot log CAR messages: ' || dbms_utility.format_error_backtrace;
356: --DBMS_OUTPUT.PUT_LINE(x_error_msg);
357: WHEN OTHERS THEN
358: x_return_status := 'E';
359: x_error_msg := 'With CAR ID: ' || p_car_id ||
360: ', PO HEADER ID: ' || p_po_header_id ||

Line 363: --DBMS_OUTPUT.PUT_LINE(x_error_msg);

359: x_error_msg := 'With CAR ID: ' || p_car_id ||
360: ', PO HEADER ID: ' || p_po_header_id ||
361: ', PO DRAFT ID: ' || NVL(p_po_draft_id, -1) ||
362: 'Cannot log CAR messages: ' || dbms_utility.format_error_backtrace;
363: --DBMS_OUTPUT.PUT_LINE(x_error_msg);
364: END;
365:
366: PROCEDURE check_doc_number (
367: p_api_version IN NUMBER,

Line 492: DBMS_OUTPUT.PUT_LINE('NO CAR WAS FOUND WITH CAR_ID = ' || p_car_id || ', PO_HEADER_ID = ' || p_po_header_id || ', PO_DRAFT_ID = ' || p_po_draft_id || '.');

488: AND PO_DRAFT_ID = p_po_draft_id;
489: RETURN l_car_status;
490: EXCEPTION
491: WHEN NO_DATA_FOUND THEN
492: DBMS_OUTPUT.PUT_LINE('NO CAR WAS FOUND WITH CAR_ID = ' || p_car_id || ', PO_HEADER_ID = ' || p_po_header_id || ', PO_DRAFT_ID = ' || p_po_draft_id || '.');
493: WHEN OTHERS THEN
494: DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);
495: END;
496:

Line 494: DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);

490: EXCEPTION
491: WHEN NO_DATA_FOUND THEN
492: DBMS_OUTPUT.PUT_LINE('NO CAR WAS FOUND WITH CAR_ID = ' || p_car_id || ', PO_HEADER_ID = ' || p_po_header_id || ', PO_DRAFT_ID = ' || p_po_draft_id || '.');
493: WHEN OTHERS THEN
494: DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);
495: END;
496:
497: FUNCTION get_report_type
498: (

Line 520: DBMS_OUTPUT.PUT_LINE('There is no PO header for the PO_HEADER_ID ' || p_po_header_id);

516: END IF;
517: RETURN l_report_type;
518: EXCEPTION
519: WHEN NO_DATA_FOUND THEN
520: DBMS_OUTPUT.PUT_LINE('There is no PO header for the PO_HEADER_ID ' || p_po_header_id);
521: RETURN l_report_type;
522: WHEN OTHERS THEN
523: DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);
524: END;

Line 523: DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);

519: WHEN NO_DATA_FOUND THEN
520: DBMS_OUTPUT.PUT_LINE('There is no PO header for the PO_HEADER_ID ' || p_po_header_id);
521: RETURN l_report_type;
522: WHEN OTHERS THEN
523: DBMS_OUTPUT.PUT_LINE(dbms_utility.format_error_backtrace);
524: END;
525:
526: FUNCTION get_car_number
527: (

Line 822: DBMS_OUTPUT.PUT_LINE('CAR_ID: ' || car_id);

818: p_validation_level => NULL,
819: x_car_id => car_id,
820: x_return_status => status,
821: x_error_msg => error_msg);
822: DBMS_OUTPUT.PUT_LINE('CAR_ID: ' || car_id);
823:
824:
825: car_log_tab := new PO_CLM_CAR_LOG_TAB(); */
826: --car_log_tab.EXTEND();

Line 877: DBMS_OUTPUT.PUT_LINE(get_report_type(p_po_header_id => 106440));

873: x_ref_idv_agency_id => ref_idv_agency_id,
874: x_ref_idv_piid => ref_idv_piid,
875: x_return_status => status,
876: x_error_msg => error_msg);
877: DBMS_OUTPUT.PUT_LINE(get_report_type(p_po_header_id => 106440));
878:
879: DBMS_OUTPUT.PUT_LINE(ref_idv_agency_id);
880: DBMS_OUTPUT.PUT_LINE(ref_idv_piid);
881: DBMS_OUTPUT.PUT_LINE(is_matching);

Line 879: DBMS_OUTPUT.PUT_LINE(ref_idv_agency_id);

875: x_return_status => status,
876: x_error_msg => error_msg);
877: DBMS_OUTPUT.PUT_LINE(get_report_type(p_po_header_id => 106440));
878:
879: DBMS_OUTPUT.PUT_LINE(ref_idv_agency_id);
880: DBMS_OUTPUT.PUT_LINE(ref_idv_piid);
881: DBMS_OUTPUT.PUT_LINE(is_matching);
882: DBMS_OUTPUT.PUT_LINE(status);
883: DBMS_OUTPUT.PUT_LINE(error_msg);

Line 880: DBMS_OUTPUT.PUT_LINE(ref_idv_piid);

876: x_error_msg => error_msg);
877: DBMS_OUTPUT.PUT_LINE(get_report_type(p_po_header_id => 106440));
878:
879: DBMS_OUTPUT.PUT_LINE(ref_idv_agency_id);
880: DBMS_OUTPUT.PUT_LINE(ref_idv_piid);
881: DBMS_OUTPUT.PUT_LINE(is_matching);
882: DBMS_OUTPUT.PUT_LINE(status);
883: DBMS_OUTPUT.PUT_LINE(error_msg);
884: END;*/

Line 881: DBMS_OUTPUT.PUT_LINE(is_matching);

877: DBMS_OUTPUT.PUT_LINE(get_report_type(p_po_header_id => 106440));
878:
879: DBMS_OUTPUT.PUT_LINE(ref_idv_agency_id);
880: DBMS_OUTPUT.PUT_LINE(ref_idv_piid);
881: DBMS_OUTPUT.PUT_LINE(is_matching);
882: DBMS_OUTPUT.PUT_LINE(status);
883: DBMS_OUTPUT.PUT_LINE(error_msg);
884: END;*/
885:

Line 882: DBMS_OUTPUT.PUT_LINE(status);

878:
879: DBMS_OUTPUT.PUT_LINE(ref_idv_agency_id);
880: DBMS_OUTPUT.PUT_LINE(ref_idv_piid);
881: DBMS_OUTPUT.PUT_LINE(is_matching);
882: DBMS_OUTPUT.PUT_LINE(status);
883: DBMS_OUTPUT.PUT_LINE(error_msg);
884: END;*/
885:
886: ------------------------------------------------------------------------------

Line 883: DBMS_OUTPUT.PUT_LINE(error_msg);

879: DBMS_OUTPUT.PUT_LINE(ref_idv_agency_id);
880: DBMS_OUTPUT.PUT_LINE(ref_idv_piid);
881: DBMS_OUTPUT.PUT_LINE(is_matching);
882: DBMS_OUTPUT.PUT_LINE(status);
883: DBMS_OUTPUT.PUT_LINE(error_msg);
884: END;*/
885:
886: ------------------------------------------------------------------------------
887: --Start of Comments