173: l_count_lines := l_count_lines + 1;
174:
175: pnp_debug_pkg.put_log_msg('*******************************************************************************');
176:
177: fnd_message.set_name ('PN','PN_XPEAM_SLNO');
178: fnd_message.set_token ('SL_NO', to_char(l_count_lines));
179: l_message := fnd_message.get;
180: pnp_debug_pkg.put_log_msg(l_message);
181:
174:
175: pnp_debug_pkg.put_log_msg('*******************************************************************************');
176:
177: fnd_message.set_name ('PN','PN_XPEAM_SLNO');
178: fnd_message.set_token ('SL_NO', to_char(l_count_lines));
179: l_message := fnd_message.get;
180: pnp_debug_pkg.put_log_msg(l_message);
181:
182: fnd_message.set_name ('PN','PN_XPEAM_PROC');
175: pnp_debug_pkg.put_log_msg('*******************************************************************************');
176:
177: fnd_message.set_name ('PN','PN_XPEAM_SLNO');
178: fnd_message.set_token ('SL_NO', to_char(l_count_lines));
179: l_message := fnd_message.get;
180: pnp_debug_pkg.put_log_msg(l_message);
181:
182: fnd_message.set_name ('PN','PN_XPEAM_PROC');
183: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
178: fnd_message.set_token ('SL_NO', to_char(l_count_lines));
179: l_message := fnd_message.get;
180: pnp_debug_pkg.put_log_msg(l_message);
181:
182: fnd_message.set_name ('PN','PN_XPEAM_PROC');
183: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
184: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
185: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
186: l_message := fnd_message.get;
179: l_message := fnd_message.get;
180: pnp_debug_pkg.put_log_msg(l_message);
181:
182: fnd_message.set_name ('PN','PN_XPEAM_PROC');
183: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
184: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
185: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
186: l_message := fnd_message.get;
187: pnp_debug_pkg.put_log_msg(l_message);
180: pnp_debug_pkg.put_log_msg(l_message);
181:
182: fnd_message.set_name ('PN','PN_XPEAM_PROC');
183: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
184: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
185: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
186: l_message := fnd_message.get;
187: pnp_debug_pkg.put_log_msg(l_message);
188:
181:
182: fnd_message.set_name ('PN','PN_XPEAM_PROC');
183: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
184: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
185: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
186: l_message := fnd_message.get;
187: pnp_debug_pkg.put_log_msg(l_message);
188:
189: l_info := 'Calling EAM API to validate data ';
182: fnd_message.set_name ('PN','PN_XPEAM_PROC');
183: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
184: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
185: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
186: l_message := fnd_message.get;
187: pnp_debug_pkg.put_log_msg(l_message);
188:
189: l_info := 'Calling EAM API to validate data ';
190: pnp_debug_pkg.log(l_info);
226: END IF;
227:
228: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
229:
230: fnd_message.set_name ('PN','PN_XPEAM_INS');
231: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
232: l_message := fnd_message.get;
233: pnp_debug_pkg.put_log_msg(l_message);
234:
227:
228: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
229:
230: fnd_message.set_name ('PN','PN_XPEAM_INS');
231: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
232: l_message := fnd_message.get;
233: pnp_debug_pkg.put_log_msg(l_message);
234:
235:
228: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
229:
230: fnd_message.set_name ('PN','PN_XPEAM_INS');
231: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
232: l_message := fnd_message.get;
233: pnp_debug_pkg.put_log_msg(l_message);
234:
235:
236: BEGIN
234:
235:
236: BEGIN
237:
238: fnd_message.set_name ('PN','PN_XPEAM_INSERTING');
239: l_message := '*** '||fnd_message.get||' ...';
240: pnp_debug_pkg.put_log_msg(l_message);
241:
242:
235:
236: BEGIN
237:
238: fnd_message.set_name ('PN','PN_XPEAM_INSERTING');
239: l_message := '*** '||fnd_message.get||' ...';
240: pnp_debug_pkg.put_log_msg(l_message);
241:
242:
243: INSERT INTO mtl_eam_asset_num_interface(
285: location_rec.active_start_date,
286: location_rec.active_end_date
287: );
288:
289: fnd_message.set_name ('PN','PN_XPEAM_LOC');
290: fnd_message.set_token ('LOC_CODE', TO_CHAR(l_serial_num));
291: l_message := fnd_message.get;
292: pnp_debug_pkg.put_log_msg(l_message);
293:
286: location_rec.active_end_date
287: );
288:
289: fnd_message.set_name ('PN','PN_XPEAM_LOC');
290: fnd_message.set_token ('LOC_CODE', TO_CHAR(l_serial_num));
291: l_message := fnd_message.get;
292: pnp_debug_pkg.put_log_msg(l_message);
293:
294: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
287: );
288:
289: fnd_message.set_name ('PN','PN_XPEAM_LOC');
290: fnd_message.set_token ('LOC_CODE', TO_CHAR(l_serial_num));
291: l_message := fnd_message.get;
292: pnp_debug_pkg.put_log_msg(l_message);
293:
294: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
295: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
290: fnd_message.set_token ('LOC_CODE', TO_CHAR(l_serial_num));
291: l_message := fnd_message.get;
292: pnp_debug_pkg.put_log_msg(l_message);
293:
294: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
295: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
296: l_message := fnd_message.get;
297: pnp_debug_pkg.put_log_msg(l_message);
298:
291: l_message := fnd_message.get;
292: pnp_debug_pkg.put_log_msg(l_message);
293:
294: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
295: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
296: l_message := fnd_message.get;
297: pnp_debug_pkg.put_log_msg(l_message);
298:
299: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
292: pnp_debug_pkg.put_log_msg(l_message);
293:
294: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
295: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
296: l_message := fnd_message.get;
297: pnp_debug_pkg.put_log_msg(l_message);
298:
299: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
300: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
295: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
296: l_message := fnd_message.get;
297: pnp_debug_pkg.put_log_msg(l_message);
298:
299: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
300: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
301: l_message := fnd_message.get;
302: pnp_debug_pkg.put_log_msg(l_message);
303:
296: l_message := fnd_message.get;
297: pnp_debug_pkg.put_log_msg(l_message);
298:
299: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
300: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
301: l_message := fnd_message.get;
302: pnp_debug_pkg.put_log_msg(l_message);
303:
304: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
297: pnp_debug_pkg.put_log_msg(l_message);
298:
299: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
300: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
301: l_message := fnd_message.get;
302: pnp_debug_pkg.put_log_msg(l_message);
303:
304: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
305: fnd_message.set_token ('CUR_STATUS', TO_CHAR(l_insert_status));
300: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
301: l_message := fnd_message.get;
302: pnp_debug_pkg.put_log_msg(l_message);
303:
304: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
305: fnd_message.set_token ('CUR_STATUS', TO_CHAR(l_insert_status));
306: l_message := fnd_message.get;
307: pnp_debug_pkg.put_log_msg(l_message);
308:
301: l_message := fnd_message.get;
302: pnp_debug_pkg.put_log_msg(l_message);
303:
304: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
305: fnd_message.set_token ('CUR_STATUS', TO_CHAR(l_insert_status));
306: l_message := fnd_message.get;
307: pnp_debug_pkg.put_log_msg(l_message);
308:
309: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
302: pnp_debug_pkg.put_log_msg(l_message);
303:
304: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
305: fnd_message.set_token ('CUR_STATUS', TO_CHAR(l_insert_status));
306: l_message := fnd_message.get;
307: pnp_debug_pkg.put_log_msg(l_message);
308:
309: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
310:
307: pnp_debug_pkg.put_log_msg(l_message);
308:
309: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
310:
311: fnd_message.set_name ('PN','PN_XPEAM_BNAME');
312: fnd_message.set_token ('BNAME', TO_CHAR(p_batch_name));
313: l_message := fnd_message.get;
314: pnp_debug_pkg.put_log_msg(l_message);
315:
308:
309: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
310:
311: fnd_message.set_name ('PN','PN_XPEAM_BNAME');
312: fnd_message.set_token ('BNAME', TO_CHAR(p_batch_name));
313: l_message := fnd_message.get;
314: pnp_debug_pkg.put_log_msg(l_message);
315:
316: pnp_debug_pkg.log( 'Current Organization ID: ' || to_char(p_organization_id));
309: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
310:
311: fnd_message.set_name ('PN','PN_XPEAM_BNAME');
312: fnd_message.set_token ('BNAME', TO_CHAR(p_batch_name));
313: l_message := fnd_message.get;
314: pnp_debug_pkg.put_log_msg(l_message);
315:
316: pnp_debug_pkg.log( 'Current Organization ID: ' || to_char(p_organization_id));
317: pnp_debug_pkg.log( 'Owning Department ID: ' || to_char(p_owning_department_id));
319: pnp_debug_pkg.log( 'Process Flag: ' || to_char('P'));
320: pnp_debug_pkg.log( 'Maintainable Flag: ' || to_char('Y'));
321: l_count_success := l_count_success + 1;
322:
323: fnd_message.set_name ('PN','PN_XPEAM_PROC_LINE');
324: fnd_message.set_token ('LNO', TO_CHAR(l_count_success));
325: l_message := fnd_message.get;
326: pnp_debug_pkg.put_log_msg(l_message);
327:
320: pnp_debug_pkg.log( 'Maintainable Flag: ' || to_char('Y'));
321: l_count_success := l_count_success + 1;
322:
323: fnd_message.set_name ('PN','PN_XPEAM_PROC_LINE');
324: fnd_message.set_token ('LNO', TO_CHAR(l_count_success));
325: l_message := fnd_message.get;
326: pnp_debug_pkg.put_log_msg(l_message);
327:
328: fnd_message.set_name ('PN','PN_XPEAM_INSERTED');
321: l_count_success := l_count_success + 1;
322:
323: fnd_message.set_name ('PN','PN_XPEAM_PROC_LINE');
324: fnd_message.set_token ('LNO', TO_CHAR(l_count_success));
325: l_message := fnd_message.get;
326: pnp_debug_pkg.put_log_msg(l_message);
327:
328: fnd_message.set_name ('PN','PN_XPEAM_INSERTED');
329: l_message := fnd_message.get;
324: fnd_message.set_token ('LNO', TO_CHAR(l_count_success));
325: l_message := fnd_message.get;
326: pnp_debug_pkg.put_log_msg(l_message);
327:
328: fnd_message.set_name ('PN','PN_XPEAM_INSERTED');
329: l_message := fnd_message.get;
330: pnp_debug_pkg.put_log_msg('*** '||l_message||' ...');
331:
332: l_info := 'Doing batch commit after every 100 INSERT ';
325: l_message := fnd_message.get;
326: pnp_debug_pkg.put_log_msg(l_message);
327:
328: fnd_message.set_name ('PN','PN_XPEAM_INSERTED');
329: l_message := fnd_message.get;
330: pnp_debug_pkg.put_log_msg('*** '||l_message||' ...');
331:
332: l_info := 'Doing batch commit after every 100 INSERT ';
333: IF MOD(l_count_success, 100) = 0 THEN
337:
338: EXCEPTION
339: WHEN OTHERS THEN
340: l_count_failure := l_count_failure + 1;
341: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
342: fnd_message.set_token ('ER_LNO', TO_CHAR(l_count_failure));
343: l_message := fnd_message.get;
344: pnp_debug_pkg.put_log_msg(l_message);
345: END;
338: EXCEPTION
339: WHEN OTHERS THEN
340: l_count_failure := l_count_failure + 1;
341: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
342: fnd_message.set_token ('ER_LNO', TO_CHAR(l_count_failure));
343: l_message := fnd_message.get;
344: pnp_debug_pkg.put_log_msg(l_message);
345: END;
346:
339: WHEN OTHERS THEN
340: l_count_failure := l_count_failure + 1;
341: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
342: fnd_message.set_token ('ER_LNO', TO_CHAR(l_count_failure));
343: l_message := fnd_message.get;
344: pnp_debug_pkg.put_log_msg(l_message);
345: END;
346:
347: ELSE
345: END;
346:
347: ELSE
348: l_count_failure := l_count_failure + 1;
349: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
350: fnd_message.set_token ('PRO_LNO', TO_CHAR(l_count_failure));
351: l_message := fnd_message.get;
352: pnp_debug_pkg.put_log_msg(l_message);
353: END IF;
346:
347: ELSE
348: l_count_failure := l_count_failure + 1;
349: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
350: fnd_message.set_token ('PRO_LNO', TO_CHAR(l_count_failure));
351: l_message := fnd_message.get;
352: pnp_debug_pkg.put_log_msg(l_message);
353: END IF;
354:
347: ELSE
348: l_count_failure := l_count_failure + 1;
349: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
350: fnd_message.set_token ('PRO_LNO', TO_CHAR(l_count_failure));
351: l_message := fnd_message.get;
352: pnp_debug_pkg.put_log_msg(l_message);
353: END IF;
354:
355: END LOOP;
359: END IF;
360:
361:
362: pnp_debug_pkg.put_log_msg('===========================================================================');
363: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
364: fnd_message.set_token ('PR_LNO', TO_CHAR(l_count_lines));
365: l_message := fnd_message.get;
366: pnp_debug_pkg.put_log_msg(l_message);
367:
360:
361:
362: pnp_debug_pkg.put_log_msg('===========================================================================');
363: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
364: fnd_message.set_token ('PR_LNO', TO_CHAR(l_count_lines));
365: l_message := fnd_message.get;
366: pnp_debug_pkg.put_log_msg(l_message);
367:
368: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
361:
362: pnp_debug_pkg.put_log_msg('===========================================================================');
363: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
364: fnd_message.set_token ('PR_LNO', TO_CHAR(l_count_lines));
365: l_message := fnd_message.get;
366: pnp_debug_pkg.put_log_msg(l_message);
367:
368: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
369: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
364: fnd_message.set_token ('PR_LNO', TO_CHAR(l_count_lines));
365: l_message := fnd_message.get;
366: pnp_debug_pkg.put_log_msg(l_message);
367:
368: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
369: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
370: l_message := fnd_message.get;
371: pnp_debug_pkg.put_log_msg(l_message);
372:
365: l_message := fnd_message.get;
366: pnp_debug_pkg.put_log_msg(l_message);
367:
368: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
369: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
370: l_message := fnd_message.get;
371: pnp_debug_pkg.put_log_msg(l_message);
372:
373: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
366: pnp_debug_pkg.put_log_msg(l_message);
367:
368: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
369: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
370: l_message := fnd_message.get;
371: pnp_debug_pkg.put_log_msg(l_message);
372:
373: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
374: fnd_message.set_token ('FAIL_LNO', TO_CHAR(l_count_failure));
369: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
370: l_message := fnd_message.get;
371: pnp_debug_pkg.put_log_msg(l_message);
372:
373: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
374: fnd_message.set_token ('FAIL_LNO', TO_CHAR(l_count_failure));
375: l_message := fnd_message.get;
376: pnp_debug_pkg.put_log_msg(l_message);
377: pnp_debug_pkg.put_log_msg('===========================================================================');
370: l_message := fnd_message.get;
371: pnp_debug_pkg.put_log_msg(l_message);
372:
373: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
374: fnd_message.set_token ('FAIL_LNO', TO_CHAR(l_count_failure));
375: l_message := fnd_message.get;
376: pnp_debug_pkg.put_log_msg(l_message);
377: pnp_debug_pkg.put_log_msg('===========================================================================');
378:
371: pnp_debug_pkg.put_log_msg(l_message);
372:
373: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
374: fnd_message.set_token ('FAIL_LNO', TO_CHAR(l_count_failure));
375: l_message := fnd_message.get;
376: pnp_debug_pkg.put_log_msg(l_message);
377: pnp_debug_pkg.put_log_msg('===========================================================================');
378:
379: pnp_debug_pkg.log('PN_EXP_TO_EAM_PVT.EXPORT_LOCATION_TO_EAM (-)');