DBA Data[Home] [Help]

APPS.PO_CLM_CAR_UTIL dependencies on DBMS_UTILITY

Line 183: x_error_msg := 'Cannot sync CAR: ' || dbms_utility.format_error_backtrace;

179: x_return_status := 'E';
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

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 247: x_error_msg := 'Cannot link the CAR: ' || dbms_utility.format_error_backtrace;

243: x_return_status := 'E';
244: x_error_msg := 'Cannot link the CAR because the car has been existed in CLM CAR table.';
245: WHEN OTHERS THEN
246: x_return_status := 'E';
247: x_error_msg := 'Cannot link the CAR: ' || dbms_utility.format_error_backtrace;
248: END;
249:
250: PROCEDURE delete_clm_car
251: (

Line 284: x_error_msg := 'Cannot delete CAR: ' || dbms_utility.format_error_backtrace;

280:
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

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 355: 'Cannot log CAR messages: ' || dbms_utility.format_error_backtrace;

351: x_return_status := 'E';
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 ||

Line 362: 'Cannot log CAR messages: ' || dbms_utility.format_error_backtrace;

358: x_return_status := 'E';
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 (

Line 425: x_error_msg := 'Error in checking document number: ' || dbms_utility.format_error_backtrace;

421: ', PO DRAFT ID: ' || NVL(p_po_draft_id, -1);
422: WHEN OTHERS THEN
423: x_is_matching := 'F';
424: x_return_status := 'E';
425: x_error_msg := 'Error in checking document number: ' || dbms_utility.format_error_backtrace;
426: END;
427:
428: PROCEDURE get_referenced_IDV_info(
429: p_api_version IN NUMBER,

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 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: (