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.PN_EXP_TO_EAM_PVT dependencies on PNP_DEBUG_PKG

Line 53: pnp_debug_pkg.log('PN_EXP_TO_EAM_PVT.EXPORT_LOCATION_TO_EAM (+)');

49: WHERE instance_number = c_parent_instance_number;
50:
51: BEGIN
52:
53: pnp_debug_pkg.log('PN_EXP_TO_EAM_PVT.EXPORT_LOCATION_TO_EAM (+)');
54:
55: l_info := 'Initializing counters ';
56: pnp_debug_pkg.log(l_info);
57:

Line 56: pnp_debug_pkg.log(l_info);

52:
53: pnp_debug_pkg.log('PN_EXP_TO_EAM_PVT.EXPORT_LOCATION_TO_EAM (+)');
54:
55: l_info := 'Initializing counters ';
56: pnp_debug_pkg.log(l_info);
57:
58: l_count_lines := 0;
59: l_count_success := 0;
60: l_count_failure := 0;

Line 63: pnp_debug_pkg.log(l_info);

59: l_count_success := 0;
60: l_count_failure := 0;
61:
62: l_info := 'Checking for EAM installation ';
63: pnp_debug_pkg.log(l_info);
64:
65: IF fnd_installation.get (
66: appl_id => 426,
67: dep_appl_id => 426,

Line 75: pnp_debug_pkg.log('EAM is not installed ...');

71: null;
72: END IF;
73:
74: IF (l_installation_status not in ('I','S')) THEN
75: pnp_debug_pkg.log('EAM is not installed ...');
76: RETURN;
77: END IF;
78:
79: l_cursor := dbms_sql.open_cursor;

Line 96: pnp_debug_pkg.log(l_info);

92: || ''''||TO_DATE('31/12/4712','DD/MM/YYYY') || ''''
93: ||')';
94:
95: l_info := 'Figuring location type lookup code ';
96: pnp_debug_pkg.log(l_info);
97:
98: IF p_locn_type IS NOT NULL THEN
99: l_locn_type := p_locn_type;
100: l_query :=

Line 106: pnp_debug_pkg.log(l_info);

102:
103: END IF;
104:
105: l_info := 'Figuring location code ';
106: pnp_debug_pkg.log(l_info);
107:
108: IF p_locn_code_from IS NOT NULL AND p_locn_code_to IS NOT NULL THEN
109: l_locn_code_from := p_locn_code_from;
110: l_locn_code_to := p_locn_code_to;

Line 139: pnp_debug_pkg.log(l_info);

135: END IF;
136:
137: l_query := l_query || ' ORDER BY location_id ';
138: l_info := 'Figuring out the max id number in the mtl_eam_asset_num_interface ';
139: pnp_debug_pkg.log(l_info);
140:
141: dbms_sql.parse(l_cursor, l_query, dbms_sql.native);
142:
143: IF p_locn_type IS NOT NULL THEN

Line 189: pnp_debug_pkg.put_log_msg('*******************************************************************************');

185:
186: l_process_flag := TRUE;
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;

Line 194: pnp_debug_pkg.put_log_msg(l_message);

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);
198: fnd_message.set_token ('ST_DATE',location_rec.active_start_date);

Line 201: pnp_debug_pkg.put_log_msg(l_message);

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);
205:

Line 204: pnp_debug_pkg.log(l_info);

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);
205:
206: BEGIN
207: pnp_debug_pkg.log('EAM_PN_EXTRACTION_PUB.PN_EAM_EXPORT_MODE (+)');
208:

Line 207: pnp_debug_pkg.log('EAM_PN_EXTRACTION_PUB.PN_EAM_EXPORT_MODE (+)');

203: l_info := 'Calling EAM API to validate data ';
204: pnp_debug_pkg.log(l_info);
205:
206: BEGIN
207: pnp_debug_pkg.log('EAM_PN_EXTRACTION_PUB.PN_EAM_EXPORT_MODE (+)');
208:
209: eam_pn_extraction_pub.pn_eam_export_mode(
210: p_api_version => 1.0,
211: p_pn_location_id => location_rec.location_id,

Line 221: pnp_debug_pkg.log('EAM_PN_EXTRACTION_PUB.PN_EAM_EXPORT_MODE (-)');

217: x_insert_status => l_insert_status,
218: x_return_status => l_return_status,
219: x_msg_count => l_msg_count,
220: x_msg_data => l_msg_data);
221: pnp_debug_pkg.log('EAM_PN_EXTRACTION_PUB.PN_EAM_EXPORT_MODE (-)');
222: EXCEPTION
223: WHEN OTHERS THEN
224: l_process_flag := FALSE;
225: l_count_failure := l_count_failure + 1;

Line 226: pnp_debug_pkg.put_log_msg('Failure Number: ('||to_char(l_count_failure) ||')'||

222: EXCEPTION
223: WHEN OTHERS THEN
224: l_process_flag := FALSE;
225: l_count_failure := l_count_failure + 1;
226: pnp_debug_pkg.put_log_msg('Failure Number: ('||to_char(l_count_failure) ||')'||
227: 'Error while calling EAM API for location :'||location_rec.location_code);
228: END;
229:
230: IF l_insert = 1 AND l_process_flag THEN

Line 233: pnp_debug_pkg.log(l_info);

229:
230: IF l_insert = 1 AND l_process_flag THEN
231:
232: l_info := 'Figuring out how location code maps to serial number ';
233: pnp_debug_pkg.log(l_info);
234:
235: IF LENGTH(location_rec.location_code) > 30 THEN
236: l_serial_num := SUBSTR(location_rec.location_code, 1, 20) ||
237: SUBSTR(TO_CHAR(location_rec.location_id),1,10);

Line 248: pnp_debug_pkg.put_log_msg(l_message);

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
252:

Line 255: pnp_debug_pkg.put_log_msg(l_message);

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
259: select inventory_item_id

Line 330: pnp_debug_pkg.put_log_msg(l_message);

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));
334: l_message := fnd_message.get;

Line 335: 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));
339: l_message := fnd_message.get;

Line 340: 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));
344: l_message := fnd_message.get;

Line 345: 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:
349: fnd_message.set_name ('PN','PN_XPEAM_BNAME');

Line 347: pnp_debug_pkg.log( 'Batch ID: ' || to_char(p_inventory_item_id));

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:
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;

Line 352: pnp_debug_pkg.put_log_msg(l_message);

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));
356: pnp_debug_pkg.log( 'PN Location ID: ' || to_char(location_rec.location_id));

Line 354: pnp_debug_pkg.log( 'Current Organization ID: ' || to_char(p_organization_id));

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));
356: pnp_debug_pkg.log( 'PN Location ID: ' || to_char(location_rec.location_id));
357: pnp_debug_pkg.log( 'Process Flag: ' || to_char('P'));
358: pnp_debug_pkg.log( 'Maintainable Flag: ' || to_char('Y'));

Line 355: pnp_debug_pkg.log( 'Owning Department ID: ' || to_char(p_owning_department_id));

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));
356: pnp_debug_pkg.log( 'PN Location ID: ' || to_char(location_rec.location_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;

Line 356: pnp_debug_pkg.log( 'PN Location ID: ' || to_char(location_rec.location_id));

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));
356: pnp_debug_pkg.log( 'PN Location ID: ' || to_char(location_rec.location_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:

Line 357: pnp_debug_pkg.log( 'Process Flag: ' || to_char('P'));

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));
356: pnp_debug_pkg.log( 'PN Location ID: ' || to_char(location_rec.location_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');

Line 358: pnp_debug_pkg.log( 'Maintainable Flag: ' || to_char('Y'));

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));
356: pnp_debug_pkg.log( 'PN Location ID: ' || to_char(location_rec.location_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));

Line 364: pnp_debug_pkg.put_log_msg(l_message);

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;
368: pnp_debug_pkg.put_log_msg('*** '||l_message||' ...');

Line 368: pnp_debug_pkg.put_log_msg('*** '||l_message||' ...');

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
372: commit;

Line 373: pnp_debug_pkg.log(l_info);

369:
370: l_info := 'Doing batch commit after every 100 INSERT ';
371: IF MOD(l_count_success, 100) = 0 THEN
372: commit;
373: pnp_debug_pkg.log(l_info);
374: END IF;
375:
376: EXCEPTION
377: WHEN OTHERS THEN

Line 382: pnp_debug_pkg.put_log_msg(l_message);

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
386: l_count_failure := l_count_failure + 1;

Line 390: pnp_debug_pkg.put_log_msg(l_message);

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;
394:

Line 400: pnp_debug_pkg.put_log_msg('===========================================================================');

396: dbms_sql.close_cursor (l_cursor);
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);

Line 404: pnp_debug_pkg.put_log_msg(l_message);

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));
408: l_message := fnd_message.get;

Line 409: 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));
413: l_message := fnd_message.get;

Line 414: 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 (-)');
418:

Line 415: pnp_debug_pkg.put_log_msg('===========================================================================');

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 (-)');
418:
419: EXCEPTION

Line 417: pnp_debug_pkg.log('PN_EXP_TO_EAM_PVT.EXPORT_LOCATION_TO_EAM (-)');

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 (-)');
418:
419: EXCEPTION
420: WHEN OTHERS THEN
421:

Line 422: pnp_debug_pkg.put_log_msg('PN_EXP_TO_EAM_PVT.EXPORT_LOCATION_TO_EAM : Error while ' || l_info);

418:
419: EXCEPTION
420: WHEN OTHERS THEN
421:
422: pnp_debug_pkg.put_log_msg('PN_EXP_TO_EAM_PVT.EXPORT_LOCATION_TO_EAM : Error while ' || l_info);
423: raise;
424:
425: END export_location_to_eam;
426: