eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RESERVATIONS_INTERFACE dependencies on FND_FILE

Line 134: fnd_file.put_line(fnd_file.log,fnd_message.get);

130: l_return_status := fnd_api.g_ret_sts_success;
131:
132: if (p_form_mode in ('N','n')) then
133: fnd_message.set_name('INV', 'INV_RSV_MANAGER');
134: fnd_file.put_line(fnd_file.log,fnd_message.get);
135: fnd_file.put_line(fnd_file.log,' ');
136: end if;
137:
138: /*

Line 135: fnd_file.put_line(fnd_file.log,' ');

131:
132: if (p_form_mode in ('N','n')) then
133: fnd_message.set_name('INV', 'INV_RSV_MANAGER');
134: fnd_file.put_line(fnd_file.log,fnd_message.get);
135: fnd_file.put_line(fnd_file.log,' ');
136: end if;
137:
138: /*
139: ** ========================================================================

Line 167: fnd_file.put_line(fnd_file.log,fnd_message.get);

163: -- kgm_msg
164: fnd_message.set_name('INV', 'INV_RSV_BATCHES');
165: fnd_message.set_token('BATCHES',l_batch_arg);
166: fnd_message.set_token('LINES',to_char(l_curr_numof_lines));
167: fnd_file.put_line(fnd_file.log,fnd_message.get);
168: fnd_file.put_line(fnd_file.log,' ');
169:
170: /*
171: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');

Line 168: fnd_file.put_line(fnd_file.log,' ');

164: fnd_message.set_name('INV', 'INV_RSV_BATCHES');
165: fnd_message.set_token('BATCHES',l_batch_arg);
166: fnd_message.set_token('LINES',to_char(l_curr_numof_lines));
167: fnd_file.put_line(fnd_file.log,fnd_message.get);
168: fnd_file.put_line(fnd_file.log,' ');
169:
170: /*
171: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
172: fnd_file.put_line(fnd_file.log,l_batch_arg);

Line 171: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');

167: fnd_file.put_line(fnd_file.log,fnd_message.get);
168: fnd_file.put_line(fnd_file.log,' ');
169:
170: /*
171: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
172: fnd_file.put_line(fnd_file.log,l_batch_arg);
173:
174: fnd_file.put(fnd_file.log,'Total number of request lines - ');
175: fnd_file.put_line(fnd_file.log,to_char(l_curr_numof_lines));

Line 172: fnd_file.put_line(fnd_file.log,l_batch_arg);

168: fnd_file.put_line(fnd_file.log,' ');
169:
170: /*
171: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
172: fnd_file.put_line(fnd_file.log,l_batch_arg);
173:
174: fnd_file.put(fnd_file.log,'Total number of request lines - ');
175: fnd_file.put_line(fnd_file.log,to_char(l_curr_numof_lines));
176: fnd_file.put_line(fnd_file.log,' ');

Line 174: fnd_file.put(fnd_file.log,'Total number of request lines - ');

170: /*
171: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
172: fnd_file.put_line(fnd_file.log,l_batch_arg);
173:
174: fnd_file.put(fnd_file.log,'Total number of request lines - ');
175: fnd_file.put_line(fnd_file.log,to_char(l_curr_numof_lines));
176: fnd_file.put_line(fnd_file.log,' ');
177: */
178: end if;

Line 175: fnd_file.put_line(fnd_file.log,to_char(l_curr_numof_lines));

171: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
172: fnd_file.put_line(fnd_file.log,l_batch_arg);
173:
174: fnd_file.put(fnd_file.log,'Total number of request lines - ');
175: fnd_file.put_line(fnd_file.log,to_char(l_curr_numof_lines));
176: fnd_file.put_line(fnd_file.log,' ');
177: */
178: end if;
179:

Line 176: fnd_file.put_line(fnd_file.log,' ');

172: fnd_file.put_line(fnd_file.log,l_batch_arg);
173:
174: fnd_file.put(fnd_file.log,'Total number of request lines - ');
175: fnd_file.put_line(fnd_file.log,to_char(l_curr_numof_lines));
176: fnd_file.put_line(fnd_file.log,' ');
177: */
178: end if;
179:
180: -- Submit request

Line 212: fnd_file.put_line(fnd_file.log,fnd_message.get);

208: -- kgm_msg
209: fnd_message.set_name('INV', 'INV_RSV_BATCHES');
210: fnd_message.set_token('BATCHES',l_batch_array_arg);
211: fnd_message.set_token('LINES',to_char(l_numof_lines));
212: fnd_file.put_line(fnd_file.log,fnd_message.get);
213: fnd_file.put_line(fnd_file.log,' ');
214:
215: /*
216: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');

Line 213: fnd_file.put_line(fnd_file.log,' ');

209: fnd_message.set_name('INV', 'INV_RSV_BATCHES');
210: fnd_message.set_token('BATCHES',l_batch_array_arg);
211: fnd_message.set_token('LINES',to_char(l_numof_lines));
212: fnd_file.put_line(fnd_file.log,fnd_message.get);
213: fnd_file.put_line(fnd_file.log,' ');
214:
215: /*
216: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
217: fnd_file.put_line(fnd_file.log,l_batch_array_arg);

Line 216: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');

212: fnd_file.put_line(fnd_file.log,fnd_message.get);
213: fnd_file.put_line(fnd_file.log,' ');
214:
215: /*
216: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
217: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
218:
219: fnd_file.put(fnd_file.log,'Total number of request lines - ');
220: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));

Line 217: fnd_file.put_line(fnd_file.log,l_batch_array_arg);

213: fnd_file.put_line(fnd_file.log,' ');
214:
215: /*
216: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
217: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
218:
219: fnd_file.put(fnd_file.log,'Total number of request lines - ');
220: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));
221: fnd_file.put_line(fnd_file.log,' ');

Line 219: fnd_file.put(fnd_file.log,'Total number of request lines - ');

215: /*
216: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
217: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
218:
219: fnd_file.put(fnd_file.log,'Total number of request lines - ');
220: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));
221: fnd_file.put_line(fnd_file.log,' ');
222: */
223: end if;

Line 220: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));

216: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
217: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
218:
219: fnd_file.put(fnd_file.log,'Total number of request lines - ');
220: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));
221: fnd_file.put_line(fnd_file.log,' ');
222: */
223: end if;
224:

Line 221: fnd_file.put_line(fnd_file.log,' ');

217: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
218:
219: fnd_file.put(fnd_file.log,'Total number of request lines - ');
220: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));
221: fnd_file.put_line(fnd_file.log,' ');
222: */
223: end if;
224:
225: -- Submit request

Line 277: fnd_file.put_line(fnd_file.log,fnd_message.get);

273: -- kgm_msg
274: fnd_message.set_name('INV', 'INV_RSV_BATCHES');
275: fnd_message.set_token('BATCHES',l_batch_array_arg);
276: fnd_message.set_token('LINES',to_char(l_numof_lines));
277: fnd_file.put_line(fnd_file.log,fnd_message.get);
278: fnd_file.put_line(fnd_file.log, ' ');
279:
280: /*
281: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');

Line 278: fnd_file.put_line(fnd_file.log, ' ');

274: fnd_message.set_name('INV', 'INV_RSV_BATCHES');
275: fnd_message.set_token('BATCHES',l_batch_array_arg);
276: fnd_message.set_token('LINES',to_char(l_numof_lines));
277: fnd_file.put_line(fnd_file.log,fnd_message.get);
278: fnd_file.put_line(fnd_file.log, ' ');
279:
280: /*
281: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
282: fnd_file.put_line(fnd_file.log,l_batch_array_arg);

Line 281: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');

277: fnd_file.put_line(fnd_file.log,fnd_message.get);
278: fnd_file.put_line(fnd_file.log, ' ');
279:
280: /*
281: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
282: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
283:
284: fnd_file.put(fnd_file.log,'Total number of request lines - ');
285: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));

Line 282: fnd_file.put_line(fnd_file.log,l_batch_array_arg);

278: fnd_file.put_line(fnd_file.log, ' ');
279:
280: /*
281: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
282: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
283:
284: fnd_file.put(fnd_file.log,'Total number of request lines - ');
285: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));
286: fnd_file.put_line(fnd_file.log, ' ');

Line 284: fnd_file.put(fnd_file.log,'Total number of request lines - ');

280: /*
281: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
282: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
283:
284: fnd_file.put(fnd_file.log,'Total number of request lines - ');
285: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));
286: fnd_file.put_line(fnd_file.log, ' ');
287: */
288: end if;

Line 285: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));

281: fnd_file.put(fnd_file.log,'Reservation Batches submitted - ');
282: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
283:
284: fnd_file.put(fnd_file.log,'Total number of request lines - ');
285: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));
286: fnd_file.put_line(fnd_file.log, ' ');
287: */
288: end if;
289:

Line 286: fnd_file.put_line(fnd_file.log, ' ');

282: fnd_file.put_line(fnd_file.log,l_batch_array_arg);
283:
284: fnd_file.put(fnd_file.log,'Total number of request lines - ');
285: fnd_file.put_line(fnd_file.log,to_char(l_numof_lines));
286: fnd_file.put_line(fnd_file.log, ' ');
287: */
288: end if;
289:
290: -- Submit request

Line 543: fnd_file.put_line(fnd_file.log,fnd_message.get);

539: -- kgm_msg
540: fnd_message.set_name('INV', 'INV_RSV_BATCH_INTERFACE');
541: fnd_message.set_token('BATCH_ID',to_char(l_batch_id));
542: fnd_message.set_token('INTERFACE_ID',to_char(l_interface_id));
543: fnd_file.put_line(fnd_file.log,fnd_message.get);
544: fnd_file.put_line(fnd_file.log,' ');
545:
546: /*
547: fnd_file.put(fnd_file.log,'Reservation Batch - ');

Line 544: fnd_file.put_line(fnd_file.log,' ');

540: fnd_message.set_name('INV', 'INV_RSV_BATCH_INTERFACE');
541: fnd_message.set_token('BATCH_ID',to_char(l_batch_id));
542: fnd_message.set_token('INTERFACE_ID',to_char(l_interface_id));
543: fnd_file.put_line(fnd_file.log,fnd_message.get);
544: fnd_file.put_line(fnd_file.log,' ');
545:
546: /*
547: fnd_file.put(fnd_file.log,'Reservation Batch - ');
548: fnd_file.put(fnd_file.log, to_char(l_batch_id));

Line 547: fnd_file.put(fnd_file.log,'Reservation Batch - ');

543: fnd_file.put_line(fnd_file.log,fnd_message.get);
544: fnd_file.put_line(fnd_file.log,' ');
545:
546: /*
547: fnd_file.put(fnd_file.log,'Reservation Batch - ');
548: fnd_file.put(fnd_file.log, to_char(l_batch_id));
549: fnd_file.put(fnd_file.log,', Reservation Interface - ');
550: fnd_file.put(fnd_file.log, to_char(l_interface_id));
551: fnd_file.put_line(fnd_file.log, ' submitted ');

Line 548: fnd_file.put(fnd_file.log, to_char(l_batch_id));

544: fnd_file.put_line(fnd_file.log,' ');
545:
546: /*
547: fnd_file.put(fnd_file.log,'Reservation Batch - ');
548: fnd_file.put(fnd_file.log, to_char(l_batch_id));
549: fnd_file.put(fnd_file.log,', Reservation Interface - ');
550: fnd_file.put(fnd_file.log, to_char(l_interface_id));
551: fnd_file.put_line(fnd_file.log, ' submitted ');
552: fnd_file.put_line(fnd_file.log,' ');

Line 549: fnd_file.put(fnd_file.log,', Reservation Interface - ');

545:
546: /*
547: fnd_file.put(fnd_file.log,'Reservation Batch - ');
548: fnd_file.put(fnd_file.log, to_char(l_batch_id));
549: fnd_file.put(fnd_file.log,', Reservation Interface - ');
550: fnd_file.put(fnd_file.log, to_char(l_interface_id));
551: fnd_file.put_line(fnd_file.log, ' submitted ');
552: fnd_file.put_line(fnd_file.log,' ');
553: */

Line 550: fnd_file.put(fnd_file.log, to_char(l_interface_id));

546: /*
547: fnd_file.put(fnd_file.log,'Reservation Batch - ');
548: fnd_file.put(fnd_file.log, to_char(l_batch_id));
549: fnd_file.put(fnd_file.log,', Reservation Interface - ');
550: fnd_file.put(fnd_file.log, to_char(l_interface_id));
551: fnd_file.put_line(fnd_file.log, ' submitted ');
552: fnd_file.put_line(fnd_file.log,' ');
553: */
554: end if;

Line 551: fnd_file.put_line(fnd_file.log, ' submitted ');

547: fnd_file.put(fnd_file.log,'Reservation Batch - ');
548: fnd_file.put(fnd_file.log, to_char(l_batch_id));
549: fnd_file.put(fnd_file.log,', Reservation Interface - ');
550: fnd_file.put(fnd_file.log, to_char(l_interface_id));
551: fnd_file.put_line(fnd_file.log, ' submitted ');
552: fnd_file.put_line(fnd_file.log,' ');
553: */
554: end if;
555:

Line 552: fnd_file.put_line(fnd_file.log,' ');

548: fnd_file.put(fnd_file.log, to_char(l_batch_id));
549: fnd_file.put(fnd_file.log,', Reservation Interface - ');
550: fnd_file.put(fnd_file.log, to_char(l_interface_id));
551: fnd_file.put_line(fnd_file.log, ' submitted ');
552: fnd_file.put_line(fnd_file.log,' ');
553: */
554: end if;
555:
556: -- Call rsv_interface_line_processor

Line 1254: fnd_file.put_line(fnd_file.log,fnd_message.get);

1250: -- kgm_msg
1251: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1252: fnd_message.set_token('INTERFACE_ID',
1253: to_char(p_reservation_interface_id));
1254: fnd_file.put_line(fnd_file.log,fnd_message.get);
1255: fnd_file.put_line(fnd_file.log,' ');
1256:
1257: /*
1258: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');

Line 1255: fnd_file.put_line(fnd_file.log,' ');

1251: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1252: fnd_message.set_token('INTERFACE_ID',
1253: to_char(p_reservation_interface_id));
1254: fnd_file.put_line(fnd_file.log,fnd_message.get);
1255: fnd_file.put_line(fnd_file.log,' ');
1256:
1257: /*
1258: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1259: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1259: fnd_file.put_line(fnd_file.log,fnd_message.get);

1255: fnd_file.put_line(fnd_file.log,' ');
1256:
1257: /*
1258: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1259: fnd_file.put_line(fnd_file.log,fnd_message.get);
1260: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1261: fnd_file.put_line(fnd_file.log,
1262: to_char(p_reservation_interface_id));
1263:

Line 1260: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');

1256:
1257: /*
1258: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1259: fnd_file.put_line(fnd_file.log,fnd_message.get);
1260: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1261: fnd_file.put_line(fnd_file.log,
1262: to_char(p_reservation_interface_id));
1263:
1264: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');

Line 1261: fnd_file.put_line(fnd_file.log,

1257: /*
1258: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1259: fnd_file.put_line(fnd_file.log,fnd_message.get);
1260: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1261: fnd_file.put_line(fnd_file.log,
1262: to_char(p_reservation_interface_id));
1263:
1264: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');
1265: fnd_file.put_line(fnd_file.log,

Line 1264: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');

1260: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1261: fnd_file.put_line(fnd_file.log,
1262: to_char(p_reservation_interface_id));
1263:
1264: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');
1265: fnd_file.put_line(fnd_file.log,
1266: to_char(l_quantity_reserved));
1267:
1268: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV

Line 1265: fnd_file.put_line(fnd_file.log,

1261: fnd_file.put_line(fnd_file.log,
1262: to_char(p_reservation_interface_id));
1263:
1264: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');
1265: fnd_file.put_line(fnd_file.log,
1266: to_char(l_quantity_reserved));
1267:
1268: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV
1269: fnd_file.put_line(fnd_file.log,

Line 1268: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV

1264: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');
1265: fnd_file.put_line(fnd_file.log,
1266: to_char(l_quantity_reserved));
1267:
1268: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV
1269: fnd_file.put_line(fnd_file.log,
1270: to_char(l_secondary_quantity_reserved)); -- INVCONV
1271:
1272: fnd_file.put(fnd_file.log, 'Reservation Id: ');

Line 1269: fnd_file.put_line(fnd_file.log,

1265: fnd_file.put_line(fnd_file.log,
1266: to_char(l_quantity_reserved));
1267:
1268: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV
1269: fnd_file.put_line(fnd_file.log,
1270: to_char(l_secondary_quantity_reserved)); -- INVCONV
1271:
1272: fnd_file.put(fnd_file.log, 'Reservation Id: ');
1273: fnd_file.put_line(fnd_file.log,

Line 1272: fnd_file.put(fnd_file.log, 'Reservation Id: ');

1268: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV
1269: fnd_file.put_line(fnd_file.log,
1270: to_char(l_secondary_quantity_reserved)); -- INVCONV
1271:
1272: fnd_file.put(fnd_file.log, 'Reservation Id: ');
1273: fnd_file.put_line(fnd_file.log,
1274: to_char(l_reservation_id));
1275: fnd_file.put_line(fnd_file.log,' ');
1276: */

Line 1273: fnd_file.put_line(fnd_file.log,

1269: fnd_file.put_line(fnd_file.log,
1270: to_char(l_secondary_quantity_reserved)); -- INVCONV
1271:
1272: fnd_file.put(fnd_file.log, 'Reservation Id: ');
1273: fnd_file.put_line(fnd_file.log,
1274: to_char(l_reservation_id));
1275: fnd_file.put_line(fnd_file.log,' ');
1276: */
1277: end if;

Line 1275: fnd_file.put_line(fnd_file.log,' ');

1271:
1272: fnd_file.put(fnd_file.log, 'Reservation Id: ');
1273: fnd_file.put_line(fnd_file.log,
1274: to_char(l_reservation_id));
1275: fnd_file.put_line(fnd_file.log,' ');
1276: */
1277: end if;
1278:
1279: elsif (l_return_status = fnd_api.g_ret_sts_error) then

Line 1311: fnd_file.put_line(fnd_file.log,fnd_message.get);

1307: -- kgm_msg
1308: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1309: fnd_message.set_token('INTERFACE_ID',
1310: to_char(p_reservation_interface_id));
1311: fnd_file.put_line(fnd_file.log,fnd_message.get);
1312: fnd_file.put_line(fnd_file.log,' ');
1313:
1314: /*
1315: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');

Line 1312: fnd_file.put_line(fnd_file.log,' ');

1308: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1309: fnd_message.set_token('INTERFACE_ID',
1310: to_char(p_reservation_interface_id));
1311: fnd_file.put_line(fnd_file.log,fnd_message.get);
1312: fnd_file.put_line(fnd_file.log,' ');
1313:
1314: /*
1315: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1316: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1316: fnd_file.put_line(fnd_file.log,fnd_message.get);

1312: fnd_file.put_line(fnd_file.log,' ');
1313:
1314: /*
1315: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1316: fnd_file.put_line(fnd_file.log,fnd_message.get);
1317: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1318: fnd_file.put_line(fnd_file.log,
1319: to_char(p_reservation_interface_id));
1320: fnd_file.put_line(fnd_file.log,' ');

Line 1317: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');

1313:
1314: /*
1315: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1316: fnd_file.put_line(fnd_file.log,fnd_message.get);
1317: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1318: fnd_file.put_line(fnd_file.log,
1319: to_char(p_reservation_interface_id));
1320: fnd_file.put_line(fnd_file.log,' ');
1321: */

Line 1318: fnd_file.put_line(fnd_file.log,

1314: /*
1315: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1316: fnd_file.put_line(fnd_file.log,fnd_message.get);
1317: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1318: fnd_file.put_line(fnd_file.log,
1319: to_char(p_reservation_interface_id));
1320: fnd_file.put_line(fnd_file.log,' ');
1321: */
1322: end if;

Line 1320: fnd_file.put_line(fnd_file.log,' ');

1316: fnd_file.put_line(fnd_file.log,fnd_message.get);
1317: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1318: fnd_file.put_line(fnd_file.log,
1319: to_char(p_reservation_interface_id));
1320: fnd_file.put_line(fnd_file.log,' ');
1321: */
1322: end if;
1323:
1324: elsif (l_return_status = fnd_api.g_ret_sts_error) then

Line 1351: fnd_file.put_line(fnd_file.log,fnd_message.get);

1347: -- kgm_msg
1348: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1349: fnd_message.set_token('INTERFACE_ID',
1350: to_char(p_reservation_interface_id));
1351: fnd_file.put_line(fnd_file.log,fnd_message.get);
1352: fnd_file.put_line(fnd_file.log,' ');
1353:
1354: /*
1355: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');

Line 1352: fnd_file.put_line(fnd_file.log,' ');

1348: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1349: fnd_message.set_token('INTERFACE_ID',
1350: to_char(p_reservation_interface_id));
1351: fnd_file.put_line(fnd_file.log,fnd_message.get);
1352: fnd_file.put_line(fnd_file.log,' ');
1353:
1354: /*
1355: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1356: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1356: fnd_file.put_line(fnd_file.log,fnd_message.get);

1352: fnd_file.put_line(fnd_file.log,' ');
1353:
1354: /*
1355: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1356: fnd_file.put_line(fnd_file.log,fnd_message.get);
1357: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1358: fnd_file.put_line(fnd_file.log,
1359: to_char(p_reservation_interface_id));
1360: fnd_file.put_line(fnd_file.log,' ');

Line 1357: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');

1353:
1354: /*
1355: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1356: fnd_file.put_line(fnd_file.log,fnd_message.get);
1357: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1358: fnd_file.put_line(fnd_file.log,
1359: to_char(p_reservation_interface_id));
1360: fnd_file.put_line(fnd_file.log,' ');
1361: */

Line 1358: fnd_file.put_line(fnd_file.log,

1354: /*
1355: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1356: fnd_file.put_line(fnd_file.log,fnd_message.get);
1357: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1358: fnd_file.put_line(fnd_file.log,
1359: to_char(p_reservation_interface_id));
1360: fnd_file.put_line(fnd_file.log,' ');
1361: */
1362: end if;

Line 1360: fnd_file.put_line(fnd_file.log,' ');

1356: fnd_file.put_line(fnd_file.log,fnd_message.get);
1357: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1358: fnd_file.put_line(fnd_file.log,
1359: to_char(p_reservation_interface_id));
1360: fnd_file.put_line(fnd_file.log,' ');
1361: */
1362: end if;
1363:
1364: elsif (l_return_status = fnd_api.g_ret_sts_error) then

Line 1397: fnd_file.put_line(fnd_file.log,fnd_message.get);

1393: -- kgm_msg
1394: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1395: fnd_message.set_token('INTERFACE_ID',
1396: to_char(p_reservation_interface_id));
1397: fnd_file.put_line(fnd_file.log,fnd_message.get);
1398: fnd_file.put_line(fnd_file.log,' ');
1399:
1400: /*
1401: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');

Line 1398: fnd_file.put_line(fnd_file.log,' ');

1394: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1395: fnd_message.set_token('INTERFACE_ID',
1396: to_char(p_reservation_interface_id));
1397: fnd_file.put_line(fnd_file.log,fnd_message.get);
1398: fnd_file.put_line(fnd_file.log,' ');
1399:
1400: /*
1401: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1402: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1402: fnd_file.put_line(fnd_file.log,fnd_message.get);

1398: fnd_file.put_line(fnd_file.log,' ');
1399:
1400: /*
1401: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1402: fnd_file.put_line(fnd_file.log,fnd_message.get);
1403: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1404: fnd_file.put_line(fnd_file.log,
1405: to_char(p_reservation_interface_id));
1406: fnd_file.put_line(fnd_file.log,' ');

Line 1403: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');

1399:
1400: /*
1401: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1402: fnd_file.put_line(fnd_file.log,fnd_message.get);
1403: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1404: fnd_file.put_line(fnd_file.log,
1405: to_char(p_reservation_interface_id));
1406: fnd_file.put_line(fnd_file.log,' ');
1407: */

Line 1404: fnd_file.put_line(fnd_file.log,

1400: /*
1401: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1402: fnd_file.put_line(fnd_file.log,fnd_message.get);
1403: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1404: fnd_file.put_line(fnd_file.log,
1405: to_char(p_reservation_interface_id));
1406: fnd_file.put_line(fnd_file.log,' ');
1407: */
1408: end if;

Line 1406: fnd_file.put_line(fnd_file.log,' ');

1402: fnd_file.put_line(fnd_file.log,fnd_message.get);
1403: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1404: fnd_file.put_line(fnd_file.log,
1405: to_char(p_reservation_interface_id));
1406: fnd_file.put_line(fnd_file.log,' ');
1407: */
1408: end if;
1409:
1410: elsif (l_return_status = fnd_api.g_ret_sts_error) then

Line 1438: fnd_file.put_line(fnd_file.log,fnd_message.get);

1434: if (p_form_mode in ('N','n')) then
1435: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1436: fnd_message.set_token('INTERFACE_ID',
1437: to_char(p_reservation_interface_id));
1438: fnd_file.put_line(fnd_file.log,fnd_message.get);
1439: end if;
1440:
1441: -- Add message to message list
1442: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_NOT_FOUND');

Line 1466: fnd_file.put_line(fnd_file.log,fnd_message.get);

1462: -- kgm_msg
1463: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1464: fnd_message.set_token('INTERFACE_ID',
1465: to_char(p_reservation_interface_id));
1466: fnd_file.put_line(fnd_file.log,fnd_message.get);
1467: end if;
1468:
1469: -- Add message to message list
1470: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_INVALID_CODE');

Line 1494: fnd_file.put_line(fnd_file.log,fnd_message.get);

1490: -- kgm_msg
1491: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1492: fnd_message.set_token('INTERFACE_ID',
1493: to_char(p_reservation_interface_id));
1494: fnd_file.put_line(fnd_file.log,fnd_message.get);
1495: end if;
1496:
1497: fnd_msg_pub.count_and_get(
1498: p_count => x_msg_count

Line 1518: fnd_file.put_line(fnd_file.log,fnd_message.get);

1514: -- kgm_msg
1515: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1516: fnd_message.set_token('INTERFACE_ID',
1517: to_char(p_reservation_interface_id));
1518: fnd_file.put_line(fnd_file.log,fnd_message.get);
1519: end if;
1520:
1521: fnd_msg_pub.count_and_get(
1522: p_count => x_msg_count

Line 1542: fnd_file.put_line(fnd_file.log,fnd_message.get);

1538: -- kgm_msg
1539: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1540: fnd_message.set_token('INTERFACE_ID',
1541: to_char(p_reservation_interface_id));
1542: fnd_file.put_line(fnd_file.log,fnd_message.get);
1543: end if;
1544:
1545: if (fnd_msg_pub.check_msg_level
1546: (fnd_msg_pub.g_msg_lvl_unexp_error))then

Line 1593: fnd_file.put_line(fnd_file.log, l_msg_data);

1589: null;
1590: else
1591: for i in 1..p_msg_count loop
1592: l_msg_data := fnd_msg_pub.get(i, 'F');
1593: fnd_file.put_line(fnd_file.log, l_msg_data);
1594: end loop;
1595:
1596: fnd_file.put_line(fnd_file.log, ' ');
1597: end if;

Line 1596: fnd_file.put_line(fnd_file.log, ' ');

1592: l_msg_data := fnd_msg_pub.get(i, 'F');
1593: fnd_file.put_line(fnd_file.log, l_msg_data);
1594: end loop;
1595:
1596: fnd_file.put_line(fnd_file.log, ' ');
1597: end if;
1598:
1599: fnd_msg_pub.initialize;
1600:

Line 1603: fnd_file.put_line(fnd_file.log, sqlerrm);

1599: fnd_msg_pub.initialize;
1600:
1601: exception
1602: when others then
1603: fnd_file.put_line(fnd_file.log, sqlerrm);
1604: end print_error;
1605:
1606: END INV_RESERVATIONS_INTERFACE;