APPS.AD_UTIL dependencies on DBMS_OUTPUT

Line 35: dbms_output.put_line('-- Unable to get APPS username.');

31: where oracle_id between 900 and 999
32: and read_only_flag = 'U';
33: exception
34: when others then
35: dbms_output.put_line('-- Unable to get APPS username.');
36: return;
37: end;
38:
39: begin

Line 47: dbms_output.put_line('-- Unable to determine owner for table ' ||

43: and table_name = ad_zd_table.ev_view(upper(p_tab_name))
44: and owner = upper(p_apps_username);
45: exception
46: when others then
47: dbms_output.put_line('-- Unable to determine owner for table ' ||
48: p_tab_name ||'.');
49: return;
50: end;
51:

Line 60: dbms_output.put_line('-- Table '||p_tab_name||' does not exist.');

56: and owner = upper(p_tab_owner);
57:
58: exception
59: when no_data_found then
60: dbms_output.put_line('-- Table '||p_tab_name||' does not exist.');
61: return;
62: end;
63:
64: begin

Line 74: dbms_output.put_line('-- Column '||p_col_name||

70: and syn.table_name = col.table_name
71: and syn.table_owner = col.owner;
72: exception
73: when no_data_found then
74: dbms_output.put_line('-- Column '||p_col_name||
75: ' is not a column of table '||
76: p_tab_name||'.');
77: return;
78: end;

Line 82: dbms_output.put_line(statement||';');

78: end;
79:
80: statement := 'update '||p_tab_name||' set '||p_col_name||' = '||
81: p_new_oid||' where '||p_col_name||' = '||p_old_oid;
82: dbms_output.put_line(statement||';');
83:
84: if upper(p_option) = 'N' then
85: return;
86: end if;

Line 91: dbms_output.put_line(' '||rows_processed||' rows updated.');

87:
88: p_cursor := dbms_sql.open_cursor;
89: dbms_sql.parse(p_cursor, statement, dbms_sql.native);
90: rows_processed := dbms_sql.execute(p_cursor);
91: dbms_output.put_line(' '||rows_processed||' rows updated.');
92: dbms_sql.close_cursor(p_cursor);
93:
94: exception
95: when others then

Line 241: dbms_output.put_line('-- select fnd_oracle_userid_s.nextval from dual;');

237: is
238: p_new_oid number;
239: begin
240:
241: dbms_output.put_line('-- select fnd_oracle_userid_s.nextval from dual;');
242:
243: select fnd_oracle_userid_s.nextval into p_new_oid
244: from dual;
245:

Line 327: -- dbms_output.put_line(x_oracle_id||x_db_status||x_ign);

323: x_db_status := c.db_status;
324: x_status := c.status;
325: x_ign := c.install_group_num;
326:
327: -- dbms_output.put_line(x_oracle_id||x_db_status||x_ign);
328:
329: if x_db_status = 'I' then
330: if x_status is null or (x_status <> 'I' and x_status <> 'S') then
331: --

Line 336: dbms_output.put_line(errmsg);

332: -- set the status to be licensed
333: --
334: errmsg := 'update fnd_product_installations for oracle_id '||
335: x_oracle_id;
336: dbms_output.put_line(errmsg);
337: update fnd_product_installations
338: set status = 'S',
339: last_update_date = sysdate
340: where application_id = appid

Line 344: dbms_output.put_line(SQL%ROWCOUNT||

340: where application_id = appid
341: and oracle_id = x_oracle_id;
342:
343: if SQL%ROWCOUNT = 1 then
344: dbms_output.put_line(SQL%ROWCOUNT||
345: ' row updated in fnd_product_installations.');
346: else
347: dbms_output.put_line(SQL%ROWCOUNT||
348: ' rows updated in fnd_product_installations.');

Line 347: dbms_output.put_line(SQL%ROWCOUNT||

343: if SQL%ROWCOUNT = 1 then
344: dbms_output.put_line(SQL%ROWCOUNT||
345: ' row updated in fnd_product_installations.');
346: else
347: dbms_output.put_line(SQL%ROWCOUNT||
348: ' rows updated in fnd_product_installations.');
349: end if;
350:
351: --

Line 405: dbms_output.put_line(SQL%ROWCOUNT||

401: and u2.application_id = appid
402: );
403:
404: if SQL%ROWCOUNT = 1 then
405: dbms_output.put_line(SQL%ROWCOUNT||
406: ' row inserted into fnd_data_group_units.');
407: else
408: dbms_output.put_line(SQL%ROWCOUNT||
409: ' rows inserted into fnd_data_group_units.');

Line 408: dbms_output.put_line(SQL%ROWCOUNT||

404: if SQL%ROWCOUNT = 1 then
405: dbms_output.put_line(SQL%ROWCOUNT||
406: ' row inserted into fnd_data_group_units.');
407: else
408: dbms_output.put_line(SQL%ROWCOUNT||
409: ' rows inserted into fnd_data_group_units.');
410: end if;
411:
412: exit; -- exit the LOOP

Line 451: dbms_output.put_line(SQL%ROWCOUNT||

447: and u2.application_id = appid
448: );
449:
450: if SQL%ROWCOUNT = 1 then
451: dbms_output.put_line(SQL%ROWCOUNT||
452: ' row inserted into fnd_data_group_units.');
453: else
454: dbms_output.put_line(SQL%ROWCOUNT||
455: ' rows inserted into fnd_data_group_units.');

Line 454: dbms_output.put_line(SQL%ROWCOUNT||

450: if SQL%ROWCOUNT = 1 then
451: dbms_output.put_line(SQL%ROWCOUNT||
452: ' row inserted into fnd_data_group_units.');
453: else
454: dbms_output.put_line(SQL%ROWCOUNT||
455: ' rows inserted into fnd_data_group_units.');
456: end if;
457:
458: