DBA Data[Home] [Help]

APPS.INV_RESERVATIONS_INTERFACE dependencies on FND_FILE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1292: -- kgm_msg
1293: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1294: fnd_message.set_token('INTERFACE_ID',
1295: to_char(p_reservation_interface_id));
1296: fnd_file.put_line(fnd_file.log,fnd_message.get);
1297: fnd_file.put_line(fnd_file.log,' ');
1298:
1299: /*
1300: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');

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

1293: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1294: fnd_message.set_token('INTERFACE_ID',
1295: to_char(p_reservation_interface_id));
1296: fnd_file.put_line(fnd_file.log,fnd_message.get);
1297: fnd_file.put_line(fnd_file.log,' ');
1298:
1299: /*
1300: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1301: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1297: fnd_file.put_line(fnd_file.log,' ');
1298:
1299: /*
1300: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1301: fnd_file.put_line(fnd_file.log,fnd_message.get);
1302: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1303: fnd_file.put_line(fnd_file.log,
1304: to_char(p_reservation_interface_id));
1305:

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

1298:
1299: /*
1300: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1301: fnd_file.put_line(fnd_file.log,fnd_message.get);
1302: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1303: fnd_file.put_line(fnd_file.log,
1304: to_char(p_reservation_interface_id));
1305:
1306: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');

Line 1303: fnd_file.put_line(fnd_file.log,

1299: /*
1300: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1301: fnd_file.put_line(fnd_file.log,fnd_message.get);
1302: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1303: fnd_file.put_line(fnd_file.log,
1304: to_char(p_reservation_interface_id));
1305:
1306: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');
1307: fnd_file.put_line(fnd_file.log,

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

1302: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1303: fnd_file.put_line(fnd_file.log,
1304: to_char(p_reservation_interface_id));
1305:
1306: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');
1307: fnd_file.put_line(fnd_file.log,
1308: to_char(l_quantity_reserved));
1309:
1310: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV

Line 1307: fnd_file.put_line(fnd_file.log,

1303: fnd_file.put_line(fnd_file.log,
1304: to_char(p_reservation_interface_id));
1305:
1306: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');
1307: fnd_file.put_line(fnd_file.log,
1308: to_char(l_quantity_reserved));
1309:
1310: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV
1311: fnd_file.put_line(fnd_file.log,

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

1306: fnd_file.put(fnd_file.log, 'Quantity Reserved: ');
1307: fnd_file.put_line(fnd_file.log,
1308: to_char(l_quantity_reserved));
1309:
1310: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV
1311: fnd_file.put_line(fnd_file.log,
1312: to_char(l_secondary_quantity_reserved)); -- INVCONV
1313:
1314: fnd_file.put(fnd_file.log, 'Reservation Id: ');

Line 1311: fnd_file.put_line(fnd_file.log,

1307: fnd_file.put_line(fnd_file.log,
1308: to_char(l_quantity_reserved));
1309:
1310: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV
1311: fnd_file.put_line(fnd_file.log,
1312: to_char(l_secondary_quantity_reserved)); -- INVCONV
1313:
1314: fnd_file.put(fnd_file.log, 'Reservation Id: ');
1315: fnd_file.put_line(fnd_file.log,

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

1310: fnd_file.put(fnd_file.log, 'Secondary Quantity Reserved: '); --INVCONV
1311: fnd_file.put_line(fnd_file.log,
1312: to_char(l_secondary_quantity_reserved)); -- INVCONV
1313:
1314: fnd_file.put(fnd_file.log, 'Reservation Id: ');
1315: fnd_file.put_line(fnd_file.log,
1316: to_char(l_reservation_id));
1317: fnd_file.put_line(fnd_file.log,' ');
1318: */

Line 1315: fnd_file.put_line(fnd_file.log,

1311: fnd_file.put_line(fnd_file.log,
1312: to_char(l_secondary_quantity_reserved)); -- INVCONV
1313:
1314: fnd_file.put(fnd_file.log, 'Reservation Id: ');
1315: fnd_file.put_line(fnd_file.log,
1316: to_char(l_reservation_id));
1317: fnd_file.put_line(fnd_file.log,' ');
1318: */
1319: end if;

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

1313:
1314: fnd_file.put(fnd_file.log, 'Reservation Id: ');
1315: fnd_file.put_line(fnd_file.log,
1316: to_char(l_reservation_id));
1317: fnd_file.put_line(fnd_file.log,' ');
1318: */
1319: end if;
1320:
1321: elsif (l_return_status = fnd_api.g_ret_sts_error) then

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

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

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

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

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

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

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

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

Line 1360: fnd_file.put_line(fnd_file.log,

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

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

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

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

1389: -- kgm_msg
1390: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1391: fnd_message.set_token('INTERFACE_ID',
1392: to_char(p_reservation_interface_id));
1393: fnd_file.put_line(fnd_file.log,fnd_message.get);
1394: fnd_file.put_line(fnd_file.log,' ');
1395:
1396: /*
1397: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');

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

1390: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1391: fnd_message.set_token('INTERFACE_ID',
1392: to_char(p_reservation_interface_id));
1393: fnd_file.put_line(fnd_file.log,fnd_message.get);
1394: fnd_file.put_line(fnd_file.log,' ');
1395:
1396: /*
1397: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1398: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

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

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

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

Line 1400: fnd_file.put_line(fnd_file.log,

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

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

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

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

1435: -- kgm_msg
1436: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1437: fnd_message.set_token('INTERFACE_ID',
1438: to_char(p_reservation_interface_id));
1439: fnd_file.put_line(fnd_file.log,fnd_message.get);
1440: fnd_file.put_line(fnd_file.log,' ');
1441:
1442: /*
1443: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');

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

1436: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_SUCCESS');
1437: fnd_message.set_token('INTERFACE_ID',
1438: to_char(p_reservation_interface_id));
1439: fnd_file.put_line(fnd_file.log,fnd_message.get);
1440: fnd_file.put_line(fnd_file.log,' ');
1441:
1442: /*
1443: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1444: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

1440: fnd_file.put_line(fnd_file.log,' ');
1441:
1442: /*
1443: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1444: fnd_file.put_line(fnd_file.log,fnd_message.get);
1445: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1446: fnd_file.put_line(fnd_file.log,
1447: to_char(p_reservation_interface_id));
1448: fnd_file.put_line(fnd_file.log,' ');

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

1441:
1442: /*
1443: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1444: fnd_file.put_line(fnd_file.log,fnd_message.get);
1445: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1446: fnd_file.put_line(fnd_file.log,
1447: to_char(p_reservation_interface_id));
1448: fnd_file.put_line(fnd_file.log,' ');
1449: */

Line 1446: fnd_file.put_line(fnd_file.log,

1442: /*
1443: fnd_message.set_name('INV', 'RSV_INTERFACE_SUCCESS');
1444: fnd_file.put_line(fnd_file.log,fnd_message.get);
1445: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1446: fnd_file.put_line(fnd_file.log,
1447: to_char(p_reservation_interface_id));
1448: fnd_file.put_line(fnd_file.log,' ');
1449: */
1450: end if;

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

1444: fnd_file.put_line(fnd_file.log,fnd_message.get);
1445: fnd_file.put(fnd_file.log, 'Reservation Interface Id: ');
1446: fnd_file.put_line(fnd_file.log,
1447: to_char(p_reservation_interface_id));
1448: fnd_file.put_line(fnd_file.log,' ');
1449: */
1450: end if;
1451:
1452: elsif (l_return_status = fnd_api.g_ret_sts_error) then

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

1476: if (p_form_mode in ('N','n')) then
1477: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1478: fnd_message.set_token('INTERFACE_ID',
1479: to_char(p_reservation_interface_id));
1480: fnd_file.put_line(fnd_file.log,fnd_message.get);
1481: end if;
1482:
1483: -- Add message to message list
1484: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_NOT_FOUND');

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

1504: -- kgm_msg
1505: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1506: fnd_message.set_token('INTERFACE_ID',
1507: to_char(p_reservation_interface_id));
1508: fnd_file.put_line(fnd_file.log,fnd_message.get);
1509: end if;
1510:
1511: -- Add message to message list
1512: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_INVALID_CODE');

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

1532: -- kgm_msg
1533: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1534: fnd_message.set_token('INTERFACE_ID',
1535: to_char(p_reservation_interface_id));
1536: fnd_file.put_line(fnd_file.log,fnd_message.get);
1537: end if;
1538:
1539: fnd_msg_pub.count_and_get(
1540: p_count => x_msg_count

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

1556: -- kgm_msg
1557: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1558: fnd_message.set_token('INTERFACE_ID',
1559: to_char(p_reservation_interface_id));
1560: fnd_file.put_line(fnd_file.log,fnd_message.get);
1561: end if;
1562:
1563: fnd_msg_pub.count_and_get(
1564: p_count => x_msg_count

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

1580: -- kgm_msg
1581: fnd_message.set_name('INV', 'INV_RSV_INTERFACE_ERROR');
1582: fnd_message.set_token('INTERFACE_ID',
1583: to_char(p_reservation_interface_id));
1584: fnd_file.put_line(fnd_file.log,fnd_message.get);
1585: end if;
1586:
1587: if (fnd_msg_pub.check_msg_level
1588: (fnd_msg_pub.g_msg_lvl_unexp_error))then

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

1631: null;
1632: else
1633: for i in 1..p_msg_count loop
1634: l_msg_data := fnd_msg_pub.get(i, 'F');
1635: fnd_file.put_line(fnd_file.log, l_msg_data);
1636: end loop;
1637:
1638: fnd_file.put_line(fnd_file.log, ' ');
1639: end if;

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

1634: l_msg_data := fnd_msg_pub.get(i, 'F');
1635: fnd_file.put_line(fnd_file.log, l_msg_data);
1636: end loop;
1637:
1638: fnd_file.put_line(fnd_file.log, ' ');
1639: end if;
1640:
1641: fnd_msg_pub.initialize;
1642:

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

1641: fnd_msg_pub.initialize;
1642:
1643: exception
1644: when others then
1645: fnd_file.put_line(fnd_file.log, sqlerrm);
1646: end print_error;
1647:
1648: END INV_RESERVATIONS_INTERFACE;