187: l_count_lines := l_count_lines + 1;
188:
189: pnp_debug_pkg.put_log_msg('*******************************************************************************');
190:
191: fnd_message.set_name ('PN','PN_XPEAM_SLNO');
192: fnd_message.set_token ('SL_NO', to_char(l_count_lines));
193: l_message := fnd_message.get;
194: pnp_debug_pkg.put_log_msg(l_message);
195:
188:
189: pnp_debug_pkg.put_log_msg('*******************************************************************************');
190:
191: fnd_message.set_name ('PN','PN_XPEAM_SLNO');
192: fnd_message.set_token ('SL_NO', to_char(l_count_lines));
193: l_message := fnd_message.get;
194: pnp_debug_pkg.put_log_msg(l_message);
195:
196: fnd_message.set_name ('PN','PN_XPEAM_PROC');
189: pnp_debug_pkg.put_log_msg('*******************************************************************************');
190:
191: fnd_message.set_name ('PN','PN_XPEAM_SLNO');
192: fnd_message.set_token ('SL_NO', to_char(l_count_lines));
193: l_message := fnd_message.get;
194: pnp_debug_pkg.put_log_msg(l_message);
195:
196: fnd_message.set_name ('PN','PN_XPEAM_PROC');
197: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
192: fnd_message.set_token ('SL_NO', to_char(l_count_lines));
193: l_message := fnd_message.get;
194: pnp_debug_pkg.put_log_msg(l_message);
195:
196: fnd_message.set_name ('PN','PN_XPEAM_PROC');
197: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
198: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
199: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
200: l_message := fnd_message.get;
193: l_message := fnd_message.get;
194: pnp_debug_pkg.put_log_msg(l_message);
195:
196: fnd_message.set_name ('PN','PN_XPEAM_PROC');
197: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
198: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
199: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
200: l_message := fnd_message.get;
201: pnp_debug_pkg.put_log_msg(l_message);
194: pnp_debug_pkg.put_log_msg(l_message);
195:
196: fnd_message.set_name ('PN','PN_XPEAM_PROC');
197: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
198: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
199: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
200: l_message := fnd_message.get;
201: pnp_debug_pkg.put_log_msg(l_message);
202:
195:
196: fnd_message.set_name ('PN','PN_XPEAM_PROC');
197: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
198: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
199: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
200: l_message := fnd_message.get;
201: pnp_debug_pkg.put_log_msg(l_message);
202:
203: l_info := 'Calling EAM API to validate data ';
196: fnd_message.set_name ('PN','PN_XPEAM_PROC');
197: fnd_message.set_token ('LOC_CODE',location_rec.location_code);
198: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);
199: fnd_message.set_token ('END_DATE',NVL(location_rec.active_end_date,TO_DATE('31/12/4712','DD/MM/YYYY')));
200: l_message := fnd_message.get;
201: pnp_debug_pkg.put_log_msg(l_message);
202:
203: l_info := 'Calling EAM API to validate data ';
204: pnp_debug_pkg.log(l_info);
241:
242:
243: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
244:
245: fnd_message.set_name ('PN','PN_XPEAM_INS');
246: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
247: l_message := fnd_message.get;
248: pnp_debug_pkg.put_log_msg(l_message);
249:
242:
243: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
244:
245: fnd_message.set_name ('PN','PN_XPEAM_INS');
246: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
247: l_message := fnd_message.get;
248: pnp_debug_pkg.put_log_msg(l_message);
249:
250:
243: l_info := 'Inserting data into mtl_eam_asset_num_interface table ';
244:
245: fnd_message.set_name ('PN','PN_XPEAM_INS');
246: fnd_message.set_token ('TBL', 'MTL_EAM_ASSET_NUM_INTERFACE');
247: l_message := fnd_message.get;
248: pnp_debug_pkg.put_log_msg(l_message);
249:
250:
251: BEGIN
249:
250:
251: BEGIN
252:
253: fnd_message.set_name ('PN','PN_XPEAM_INSERTING');
254: l_message := '*** '||fnd_message.get||' ...';
255: pnp_debug_pkg.put_log_msg(l_message);
256:
257: /* Commented for bug 9347599
250:
251: BEGIN
252:
253: fnd_message.set_name ('PN','PN_XPEAM_INSERTING');
254: l_message := '*** '||fnd_message.get||' ...';
255: pnp_debug_pkg.put_log_msg(l_message);
256:
257: /* Commented for bug 9347599
258: IF l_parent_instance_number is not null then
323: l_parent_instance_number,
324: l_parent_inv_id /* 8607381 */
325: );
326:
327: fnd_message.set_name ('PN','PN_XPEAM_LOC');
328: fnd_message.set_token ('LOC_CODE', TO_CHAR(l_serial_num));
329: l_message := fnd_message.get;
330: pnp_debug_pkg.put_log_msg(l_message);
331:
324: l_parent_inv_id /* 8607381 */
325: );
326:
327: fnd_message.set_name ('PN','PN_XPEAM_LOC');
328: fnd_message.set_token ('LOC_CODE', TO_CHAR(l_serial_num));
329: l_message := fnd_message.get;
330: pnp_debug_pkg.put_log_msg(l_message);
331:
332: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
325: );
326:
327: fnd_message.set_name ('PN','PN_XPEAM_LOC');
328: fnd_message.set_token ('LOC_CODE', TO_CHAR(l_serial_num));
329: l_message := fnd_message.get;
330: pnp_debug_pkg.put_log_msg(l_message);
331:
332: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
333: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
328: fnd_message.set_token ('LOC_CODE', TO_CHAR(l_serial_num));
329: l_message := fnd_message.get;
330: pnp_debug_pkg.put_log_msg(l_message);
331:
332: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
333: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
334: l_message := fnd_message.get;
335: pnp_debug_pkg.put_log_msg(l_message);
336:
329: l_message := fnd_message.get;
330: pnp_debug_pkg.put_log_msg(l_message);
331:
332: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
333: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
334: l_message := fnd_message.get;
335: pnp_debug_pkg.put_log_msg(l_message);
336:
337: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
330: pnp_debug_pkg.put_log_msg(l_message);
331:
332: fnd_message.set_name ('PN','PN_XPEAM_INV_ID');
333: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
334: l_message := fnd_message.get;
335: pnp_debug_pkg.put_log_msg(l_message);
336:
337: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
338: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
333: fnd_message.set_token ('INV_ID', TO_CHAR(p_inventory_item_id));
334: l_message := fnd_message.get;
335: pnp_debug_pkg.put_log_msg(l_message);
336:
337: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
338: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
339: l_message := fnd_message.get;
340: pnp_debug_pkg.put_log_msg(l_message);
341:
334: l_message := fnd_message.get;
335: pnp_debug_pkg.put_log_msg(l_message);
336:
337: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
338: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
339: l_message := fnd_message.get;
340: pnp_debug_pkg.put_log_msg(l_message);
341:
342: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
335: pnp_debug_pkg.put_log_msg(l_message);
336:
337: fnd_message.set_name ('PN','PN_XPEAM_IMP_MODE');
338: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
339: l_message := fnd_message.get;
340: pnp_debug_pkg.put_log_msg(l_message);
341:
342: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
343: fnd_message.set_token ('CUR_STATUS', TO_CHAR(l_insert_status));
338: fnd_message.set_token ('IMP_MODE', TO_CHAR(l_insert_mode));
339: l_message := fnd_message.get;
340: pnp_debug_pkg.put_log_msg(l_message);
341:
342: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
343: fnd_message.set_token ('CUR_STATUS', TO_CHAR(l_insert_status));
344: l_message := fnd_message.get;
345: pnp_debug_pkg.put_log_msg(l_message);
346:
339: l_message := fnd_message.get;
340: pnp_debug_pkg.put_log_msg(l_message);
341:
342: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
343: fnd_message.set_token ('CUR_STATUS', TO_CHAR(l_insert_status));
344: l_message := fnd_message.get;
345: pnp_debug_pkg.put_log_msg(l_message);
346:
347: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
340: pnp_debug_pkg.put_log_msg(l_message);
341:
342: fnd_message.set_name ('PN','PN_XPEAM_CUR_STATUS');
343: fnd_message.set_token ('CUR_STATUS', TO_CHAR(l_insert_status));
344: l_message := fnd_message.get;
345: pnp_debug_pkg.put_log_msg(l_message);
346:
347: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
348:
345: pnp_debug_pkg.put_log_msg(l_message);
346:
347: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
348:
349: fnd_message.set_name ('PN','PN_XPEAM_BNAME');
350: fnd_message.set_token ('BNAME', TO_CHAR(p_batch_name));
351: l_message := fnd_message.get;
352: pnp_debug_pkg.put_log_msg(l_message);
353:
346:
347: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
348:
349: fnd_message.set_name ('PN','PN_XPEAM_BNAME');
350: fnd_message.set_token ('BNAME', TO_CHAR(p_batch_name));
351: l_message := fnd_message.get;
352: pnp_debug_pkg.put_log_msg(l_message);
353:
354: pnp_debug_pkg.log( 'Current Organization ID: ' || to_char(p_organization_id));
347: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));
348:
349: fnd_message.set_name ('PN','PN_XPEAM_BNAME');
350: fnd_message.set_token ('BNAME', TO_CHAR(p_batch_name));
351: l_message := fnd_message.get;
352: pnp_debug_pkg.put_log_msg(l_message);
353:
354: pnp_debug_pkg.log( 'Current Organization ID: ' || to_char(p_organization_id));
355: pnp_debug_pkg.log( 'Owning Department ID: ' || to_char(p_owning_department_id));
357: pnp_debug_pkg.log( 'Process Flag: ' || to_char('P'));
358: pnp_debug_pkg.log( 'Maintainable Flag: ' || to_char('Y'));
359: l_count_success := l_count_success + 1;
360:
361: fnd_message.set_name ('PN','PN_XPEAM_PROC_LINE');
362: fnd_message.set_token ('LNO', TO_CHAR(l_count_success));
363: l_message := fnd_message.get;
364: pnp_debug_pkg.put_log_msg(l_message);
365:
358: pnp_debug_pkg.log( 'Maintainable Flag: ' || to_char('Y'));
359: l_count_success := l_count_success + 1;
360:
361: fnd_message.set_name ('PN','PN_XPEAM_PROC_LINE');
362: fnd_message.set_token ('LNO', TO_CHAR(l_count_success));
363: l_message := fnd_message.get;
364: pnp_debug_pkg.put_log_msg(l_message);
365:
366: fnd_message.set_name ('PN','PN_XPEAM_INSERTED');
359: l_count_success := l_count_success + 1;
360:
361: fnd_message.set_name ('PN','PN_XPEAM_PROC_LINE');
362: fnd_message.set_token ('LNO', TO_CHAR(l_count_success));
363: l_message := fnd_message.get;
364: pnp_debug_pkg.put_log_msg(l_message);
365:
366: fnd_message.set_name ('PN','PN_XPEAM_INSERTED');
367: l_message := fnd_message.get;
362: fnd_message.set_token ('LNO', TO_CHAR(l_count_success));
363: l_message := fnd_message.get;
364: pnp_debug_pkg.put_log_msg(l_message);
365:
366: fnd_message.set_name ('PN','PN_XPEAM_INSERTED');
367: l_message := fnd_message.get;
368: pnp_debug_pkg.put_log_msg('*** '||l_message||' ...');
369:
370: l_info := 'Doing batch commit after every 100 INSERT ';
363: l_message := fnd_message.get;
364: pnp_debug_pkg.put_log_msg(l_message);
365:
366: fnd_message.set_name ('PN','PN_XPEAM_INSERTED');
367: l_message := fnd_message.get;
368: pnp_debug_pkg.put_log_msg('*** '||l_message||' ...');
369:
370: l_info := 'Doing batch commit after every 100 INSERT ';
371: IF MOD(l_count_success, 100) = 0 THEN
375:
376: EXCEPTION
377: WHEN OTHERS THEN
378: l_count_failure := l_count_failure + 1;
379: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
380: fnd_message.set_token ('ER_LNO', TO_CHAR(l_count_failure));
381: l_message := fnd_message.get;
382: pnp_debug_pkg.put_log_msg(l_message);
383: END;
376: EXCEPTION
377: WHEN OTHERS THEN
378: l_count_failure := l_count_failure + 1;
379: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
380: fnd_message.set_token ('ER_LNO', TO_CHAR(l_count_failure));
381: l_message := fnd_message.get;
382: pnp_debug_pkg.put_log_msg(l_message);
383: END;
384:
377: WHEN OTHERS THEN
378: l_count_failure := l_count_failure + 1;
379: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
380: fnd_message.set_token ('ER_LNO', TO_CHAR(l_count_failure));
381: l_message := fnd_message.get;
382: pnp_debug_pkg.put_log_msg(l_message);
383: END;
384:
385: ELSE
383: END;
384:
385: ELSE
386: l_count_failure := l_count_failure + 1;
387: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
388: fnd_message.set_token ('PRO_LNO', TO_CHAR(l_count_failure));
389: l_message := fnd_message.get;
390: pnp_debug_pkg.put_log_msg(l_message);
391: END IF;
384:
385: ELSE
386: l_count_failure := l_count_failure + 1;
387: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
388: fnd_message.set_token ('PRO_LNO', TO_CHAR(l_count_failure));
389: l_message := fnd_message.get;
390: pnp_debug_pkg.put_log_msg(l_message);
391: END IF;
392:
385: ELSE
386: l_count_failure := l_count_failure + 1;
387: fnd_message.set_name ('PN','PN_XPEAM_ERR_LINES');
388: fnd_message.set_token ('PRO_LNO', TO_CHAR(l_count_failure));
389: l_message := fnd_message.get;
390: pnp_debug_pkg.put_log_msg(l_message);
391: END IF;
392:
393: END LOOP;
397: END IF;
398:
399:
400: pnp_debug_pkg.put_log_msg('===========================================================================');
401: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
402: fnd_message.set_token ('PR_LNO', TO_CHAR(l_count_lines));
403: l_message := fnd_message.get;
404: pnp_debug_pkg.put_log_msg(l_message);
405:
398:
399:
400: pnp_debug_pkg.put_log_msg('===========================================================================');
401: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
402: fnd_message.set_token ('PR_LNO', TO_CHAR(l_count_lines));
403: l_message := fnd_message.get;
404: pnp_debug_pkg.put_log_msg(l_message);
405:
406: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
399:
400: pnp_debug_pkg.put_log_msg('===========================================================================');
401: fnd_message.set_name ('PN','PN_XPEAM_PROC_LN');
402: fnd_message.set_token ('PR_LNO', TO_CHAR(l_count_lines));
403: l_message := fnd_message.get;
404: pnp_debug_pkg.put_log_msg(l_message);
405:
406: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
407: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
402: fnd_message.set_token ('PR_LNO', TO_CHAR(l_count_lines));
403: l_message := fnd_message.get;
404: pnp_debug_pkg.put_log_msg(l_message);
405:
406: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
407: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
408: l_message := fnd_message.get;
409: pnp_debug_pkg.put_log_msg(l_message);
410:
403: l_message := fnd_message.get;
404: pnp_debug_pkg.put_log_msg(l_message);
405:
406: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
407: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
408: l_message := fnd_message.get;
409: pnp_debug_pkg.put_log_msg(l_message);
410:
411: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
404: pnp_debug_pkg.put_log_msg(l_message);
405:
406: fnd_message.set_name ('PN','PN_XPEAM_SUCS_LN');
407: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
408: l_message := fnd_message.get;
409: pnp_debug_pkg.put_log_msg(l_message);
410:
411: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
412: fnd_message.set_token ('FAIL_LNO', TO_CHAR(l_count_failure));
407: fnd_message.set_token ('SUC_LNO', TO_CHAR(l_count_success));
408: l_message := fnd_message.get;
409: pnp_debug_pkg.put_log_msg(l_message);
410:
411: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
412: fnd_message.set_token ('FAIL_LNO', TO_CHAR(l_count_failure));
413: l_message := fnd_message.get;
414: pnp_debug_pkg.put_log_msg(l_message);
415: pnp_debug_pkg.put_log_msg('===========================================================================');
408: l_message := fnd_message.get;
409: pnp_debug_pkg.put_log_msg(l_message);
410:
411: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
412: fnd_message.set_token ('FAIL_LNO', TO_CHAR(l_count_failure));
413: l_message := fnd_message.get;
414: pnp_debug_pkg.put_log_msg(l_message);
415: pnp_debug_pkg.put_log_msg('===========================================================================');
416:
409: pnp_debug_pkg.put_log_msg(l_message);
410:
411: fnd_message.set_name ('PN','PN_XPEAM_FAIL_LN');
412: fnd_message.set_token ('FAIL_LNO', TO_CHAR(l_count_failure));
413: l_message := fnd_message.get;
414: pnp_debug_pkg.put_log_msg(l_message);
415: pnp_debug_pkg.put_log_msg('===========================================================================');
416:
417: pnp_debug_pkg.log('PN_EXP_TO_EAM_PVT.EXPORT_LOCATION_TO_EAM (-)');