APPS.AP_ACCTG_DATA_FIX_PKG dependencies on DBMS_OUTPUT

Line 6204: dbms_output.put_line(l_error_msg);

6200: l_error_msg := ' Encountered an Exception '||SQLERRM|| ' at : '
6201: || l_calling_sequence|| ' while performing : '
6202: ||l_debug_info || ' for new_vendor_contact_id='||new_vendor_contact_id
6203: ||',old_vendor_contact_id='||old_vendor_contact_id ;
6204: dbms_output.put_line(l_error_msg);
6205: PRINT(l_error_msg);
6206: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
6207: FND_LOG.STRING( G_LEVEL_PROCEDURE, G_MODULE_NAME||l_calling_sequence, l_error_msg );
6208: END IF;

Line 6357: dbms_output.put_line(l_error_msg);

6353: WHEN OTHERS THEN
6354: l_error_msg := ' Encountered an Exception '||SQLERRM|| ' at : '
6355: || l_calling_sequence|| ' while performing : '
6356: ||l_debug_info ;
6357: dbms_output.put_line(l_error_msg);
6358: PRINT(l_error_msg);
6359: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
6360: FND_LOG.STRING( G_LEVEL_PROCEDURE, G_MODULE_NAME||l_calling_sequence, l_error_msg );
6361: END IF;

Line 6423: Dbms_Output.put_line(SQLERRM);

6419: EXCEPTION
6420: WHEN NO_DATA_FOUND THEN
6421: utl_file.fclose(vInHandle_read);
6422: WHEN OTHERS THEN
6423: Dbms_Output.put_line(SQLERRM);
6424: END;
6425: -- establish the connection to the smtp server
6426: v_smtp_connection := utl_smtp.open_connection(v_smtp_host, v_smtp_port);
6427:

Line 6483: dbms_output.put_line('Invalid Operation in Mail attempt using UTL_SMTP.');

6479: RETURN TRUE;
6480:
6481: EXCEPTION
6482: WHEN utl_smtp.invalid_operation THEN
6483: dbms_output.put_line('Invalid Operation in Mail attempt using UTL_SMTP.');
6484: RETURN FALSE;
6485: WHEN utl_smtp.transient_error THEN
6486: dbms_output.put_line(' Temporary e-mail issue - try again');
6487: RETURN FALSE;

Line 6486: dbms_output.put_line(' Temporary e-mail issue - try again');

6482: WHEN utl_smtp.invalid_operation THEN
6483: dbms_output.put_line('Invalid Operation in Mail attempt using UTL_SMTP.');
6484: RETURN FALSE;
6485: WHEN utl_smtp.transient_error THEN
6486: dbms_output.put_line(' Temporary e-mail issue - try again');
6487: RETURN FALSE;
6488: WHEN utl_smtp.permanent_error THEN
6489: dbms_output.put_line(' Permanent Error Encountered.');
6490: RETURN FALSE;

Line 6489: dbms_output.put_line(' Permanent Error Encountered.');

6485: WHEN utl_smtp.transient_error THEN
6486: dbms_output.put_line(' Temporary e-mail issue - try again');
6487: RETURN FALSE;
6488: WHEN utl_smtp.permanent_error THEN
6489: dbms_output.put_line(' Permanent Error Encountered.');
6490: RETURN FALSE;
6491:
6492: END send_mail_clob_impl;
6493: