APPS.NTN dependencies on DBMS_OUTPUT

Line 52: dbms_output.put_line(p_message_name);

48:
49: begin
50: notification_id:=NULL;
51: return_code:=1;
52: dbms_output.put_line(p_message_name);
53: -- Check for valid message name
54:
55: /* Bug458110. gtummala. 3/14/97.
56: * Previously the code was:

Line 76: dbms_output.put_line('Application short name found');

72: into x_app_short_name
73: from fnd_application
74: where application_id = p_application_id;
75:
76: dbms_output.put_line('Application short name found');
77:
78: xxx_msg := fnd_message.get_string(x_app_short_name, p_message_name);
79: x_progress:='020';
80:

Line 81: dbms_output.put_line('xxx_msg =' || xxx_msg);

77:
78: xxx_msg := fnd_message.get_string(x_app_short_name, p_message_name);
79: x_progress:='020';
80:
81: dbms_output.put_line('xxx_msg =' || xxx_msg);
82:
83: if (xxx_msg is NULL) then
84: RAISE NO_DATA_FOUND;
85: end if;

Line 89: dbms_output.put_line(to_char(p_employee_id));

85: end if;
86:
87: x_progress:='030';
88:
89: dbms_output.put_line(to_char(p_employee_id));
90:
91:
92: -- Check for valid employee id
93: select rowid into xxx

Line 120: dbms_output.put_line(off_line);

116: else
117: off_line := 'N';
118: end if;
119:
120: dbms_output.put_line(off_line);
121:
122: stmt:= 'insert into fnd_notifications'
123: || '(notification_id, employee_id, message_name, priority, status, object_id, deletable, from_id, application_id, doc_type, ' ||
124: 'doc_number, amount, currency, note, start_effective_date, end_effective_date, doc_creation_date, date1, date2, date3, off_line,

Line 173: dbms_output.put_line('after message insert');

169: sys.dbms_sql.bind_variable(c,'status', status);
170: sys.dbms_sql.bind_variable(c,'user_id', user_id);
171: sys.dbms_sql.bind_variable(c,'login_id', login_id);
172:
173: dbms_output.put_line('after message insert');
174: num_attrs := 32;
175: for ix in 1..num_attrs loop
176: num_attrs_passed := array_ub - array_lb +1;
177: if (ix <= num_attrs_passed) then

Line 184: dbms_output.put_line('after attribute array');

180: sys.dbms_sql.bind_variable(c,'a' || (ix), '');
181: end if ;
182:
183: end loop;
184: dbms_output.put_line('after attribute array');
185: -- sys.dbms_output.put_line(stmt);
186:
187: rows_processed := sys.dbms_sql.execute(c);
188: sys.dbms_sql.close_cursor(c);

Line 185: -- sys.dbms_output.put_line(stmt);

181: end if ;
182:
183: end loop;
184: dbms_output.put_line('after attribute array');
185: -- sys.dbms_output.put_line(stmt);
186:
187: rows_processed := sys.dbms_sql.execute(c);
188: sys.dbms_sql.close_cursor(c);
189: select fnd_notifications_s.currval into notification_id from dual;

Line 191: dbms_output.put_line('after send notification');

187: rows_processed := sys.dbms_sql.execute(c);
188: sys.dbms_sql.close_cursor(c);
189: select fnd_notifications_s.currval into notification_id from dual;
190: return_code:=0;
191: dbms_output.put_line('after send notification');
192:
193:
194: /* Bug458110. gtummala. 3/14/97.
195: * Added this exception handler

Line 200: dbms_output.put_line('In Exception');

196: */
197:
198: EXCEPTION
199: WHEN OTHERS THEN
200: dbms_output.put_line('In Exception');
201: PO_MESSAGE_S.SQL_ERROR('Send_Notification', x_progress, sqlcode);
202: RAISE;
203: end Send_Notification;
204:

Line 354: dbms_output.put_line('In Exception');

350: END IF;
351:
352: EXCEPTION
353: WHEN OTHERS THEN
354: dbms_output.put_line('In Exception');
355: raise_application_error(-20000, sqlerrm);
356: END;
357:
358: