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_SOI_VOL_IMPORT dependencies on PNP_DEBUG_PKG

Line 212: pnp_debug_pkg.debug ('PN_SOI_VOL_IMPORT .IMPORT_VOL_HIST(+)');

208: lines_t NUM_T;
209:
210: BEGIN
211:
212: pnp_debug_pkg.debug ('PN_SOI_VOL_IMPORT .IMPORT_VOL_HIST(+)');
213: fnd_message.set_name ('PN','PN_SOI_PBATCH');
214: fnd_message.set_token ('ID', p_batch_id);
215: pnp_debug_pkg.put_log_msg(fnd_message.get);
216:

Line 215: pnp_debug_pkg.put_log_msg(fnd_message.get);

211:
212: pnp_debug_pkg.debug ('PN_SOI_VOL_IMPORT .IMPORT_VOL_HIST(+)');
213: fnd_message.set_name ('PN','PN_SOI_PBATCH');
214: fnd_message.set_token ('ID', p_batch_id);
215: pnp_debug_pkg.put_log_msg(fnd_message.get);
216:
217: l_imp_flag := 'N';
218:
219: OPEN c_all_lines_imprtd;

Line 242: pnp_debug_pkg.log('open cursor c_var_rent');

238: l_total := l_total + 1;
239:
240: BEGIN
241:
242: pnp_debug_pkg.log('open cursor c_var_rent');
243:
244: OPEN c_var_rent(v_lines.var_rent_id);
245: FETCH c_var_rent into v_var_rent_id,v_var_rent_NUMBER,v_lease_name, l_org_id;
246:

Line 255: pnp_debug_pkg.put_log_msg('-------------------------------------------------------');

251: RAISE INVALID_RECORD;
252: END IF;
253: CLOSE c_var_rent;
254:
255: pnp_debug_pkg.put_log_msg('-------------------------------------------------------');
256: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
257: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_str_DATE,'MM/DD/YYYY'));
258: pnp_debug_pkg.put_log_msg(fnd_message.get);
259:

Line 258: pnp_debug_pkg.put_log_msg(fnd_message.get);

254:
255: pnp_debug_pkg.put_log_msg('-------------------------------------------------------');
256: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
257: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_str_DATE,'MM/DD/YYYY'));
258: pnp_debug_pkg.put_log_msg(fnd_message.get);
259:
260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));
262: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 262: pnp_debug_pkg.put_log_msg(fnd_message.get);

258: pnp_debug_pkg.put_log_msg(fnd_message.get);
259:
260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));
262: pnp_debug_pkg.put_log_msg(fnd_message.get);
263:
264: pnp_debug_pkg.log('Variable Rent Id = '|| v_var_rent_id );
265: pnp_debug_pkg.log('open cursor c_line_item');
266:

Line 264: pnp_debug_pkg.log('Variable Rent Id = '|| v_var_rent_id );

260: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));
262: pnp_debug_pkg.put_log_msg(fnd_message.get);
263:
264: pnp_debug_pkg.log('Variable Rent Id = '|| v_var_rent_id );
265: pnp_debug_pkg.log('open cursor c_line_item');
266:
267: OPEN c_line_item(v_lines.line_item_id);
268: FETCH c_line_item into v_line_item_id, v_period_id,

Line 265: pnp_debug_pkg.log('open cursor c_line_item');

261: fnd_message.set_token ('DATE', TO_CHAR(v_Lines.rep_end_DATE,'MM/DD/YYYY'));
262: pnp_debug_pkg.put_log_msg(fnd_message.get);
263:
264: pnp_debug_pkg.log('Variable Rent Id = '|| v_var_rent_id );
265: pnp_debug_pkg.log('open cursor c_line_item');
266:
267: OPEN c_line_item(v_lines.line_item_id);
268: FETCH c_line_item into v_line_item_id, v_period_id,
269: v_sales_channel,v_item_category;

Line 281: pnp_debug_pkg.put_log_msg(fnd_message.get);

277: CLOSE c_line_item;
278:
279: fnd_message.set_name ('PN','PN_SOI_SALES_CH');
280: fnd_message.set_token ('CH',v_sales_channel);
281: pnp_debug_pkg.put_log_msg(fnd_message.get);
282:
283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');
284: fnd_message.set_token ('CAT',v_item_category);
285: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 285: pnp_debug_pkg.put_log_msg(fnd_message.get);

281: pnp_debug_pkg.put_log_msg(fnd_message.get);
282:
283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');
284: fnd_message.set_token ('CAT',v_item_category);
285: pnp_debug_pkg.put_log_msg(fnd_message.get);
286:
287: pnp_debug_pkg.log( 'Line Item Id = '|| v_line_item_id );
288: pnp_debug_pkg.log( 'Period Id = '|| v_period_id );
289: pnp_debug_pkg.log('open cursor c_group_DATE');

Line 287: pnp_debug_pkg.log( 'Line Item Id = '|| v_line_item_id );

283: fnd_message.set_name ('PN','PN_SOI_ITM_CATG');
284: fnd_message.set_token ('CAT',v_item_category);
285: pnp_debug_pkg.put_log_msg(fnd_message.get);
286:
287: pnp_debug_pkg.log( 'Line Item Id = '|| v_line_item_id );
288: pnp_debug_pkg.log( 'Period Id = '|| v_period_id );
289: pnp_debug_pkg.log('open cursor c_group_DATE');
290:
291: OPEN c_group_DATE(v_var_rent_id,v_period_id,

Line 288: pnp_debug_pkg.log( 'Period Id = '|| v_period_id );

284: fnd_message.set_token ('CAT',v_item_category);
285: pnp_debug_pkg.put_log_msg(fnd_message.get);
286:
287: pnp_debug_pkg.log( 'Line Item Id = '|| v_line_item_id );
288: pnp_debug_pkg.log( 'Period Id = '|| v_period_id );
289: pnp_debug_pkg.log('open cursor c_group_DATE');
290:
291: OPEN c_group_DATE(v_var_rent_id,v_period_id,
292: v_lines.rep_str_DATE,

Line 289: pnp_debug_pkg.log('open cursor c_group_DATE');

285: pnp_debug_pkg.put_log_msg(fnd_message.get);
286:
287: pnp_debug_pkg.log( 'Line Item Id = '|| v_line_item_id );
288: pnp_debug_pkg.log( 'Period Id = '|| v_period_id );
289: pnp_debug_pkg.log('open cursor c_group_DATE');
290:
291: OPEN c_group_DATE(v_var_rent_id,v_period_id,
292: v_lines.rep_str_DATE,
293: v_lines.rep_end_DATE);

Line 315: pnp_debug_pkg.put_log_msg(fnd_message.get);

311: CLOSE c_group_DATE;
312:
313: fnd_message.set_name ('PN','PN_SOI_GRP_DT');
314: fnd_message.set_token ('DATE',v_group_DATE);
315: pnp_debug_pkg.put_log_msg(fnd_message.get);
316:
317: fnd_message.set_name ('PN','PN_AMOUNT');
318: fnd_message.set_token ('AMT',v_lines.amount);
319: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 319: pnp_debug_pkg.put_log_msg(fnd_message.get);

315: pnp_debug_pkg.put_log_msg(fnd_message.get);
316:
317: fnd_message.set_name ('PN','PN_AMOUNT');
318: fnd_message.set_token ('AMT',v_lines.amount);
319: pnp_debug_pkg.put_log_msg(fnd_message.get);
320:
321: fnd_message.set_name ('PN','PN_LEASE_NAME');
322: fnd_message.set_token ('NAME',v_lease_name);
323: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 323: pnp_debug_pkg.put_log_msg(fnd_message.get);

319: pnp_debug_pkg.put_log_msg(fnd_message.get);
320:
321: fnd_message.set_name ('PN','PN_LEASE_NAME');
322: fnd_message.set_token ('NAME',v_lease_name);
323: pnp_debug_pkg.put_log_msg(fnd_message.get);
324:
325: fnd_message.set_name ('PN','PN_SOI_VRN');
326: fnd_message.set_token ('NUM',v_var_rent_NUMBER);
327: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 327: pnp_debug_pkg.put_log_msg(fnd_message.get);

323: pnp_debug_pkg.put_log_msg(fnd_message.get);
324:
325: fnd_message.set_name ('PN','PN_SOI_VRN');
326: fnd_message.set_token ('NUM',v_var_rent_NUMBER);
327: pnp_debug_pkg.put_log_msg(fnd_message.get);
328:
329: IF v_lines.volume_type = 'ACTUAL' THEN
330: v_act_amount := v_lines.amount;
331:

Line 343: pnp_debug_pkg.log( 'Volume Type = '|| v_lines.volume_type );

339: l_error_message := fnd_message.get;
340: RAISE INVALID_RECORD;
341: END IF;
342:
343: pnp_debug_pkg.log( 'Volume Type = '|| v_lines.volume_type );
344: pnp_debug_pkg.log('before insert in the table pn_var_vol_hist');
345:
346:
347: IF v_lines.volume_type IN ('ACTUAL','FORECASTED') THEN

Line 344: pnp_debug_pkg.log('before insert in the table pn_var_vol_hist');

340: RAISE INVALID_RECORD;
341: END IF;
342:
343: pnp_debug_pkg.log( 'Volume Type = '|| v_lines.volume_type );
344: pnp_debug_pkg.log('before insert in the table pn_var_vol_hist');
345:
346:
347: IF v_lines.volume_type IN ('ACTUAL','FORECASTED') THEN
348:

Line 1063: pnp_debug_pkg.log('before upDATE of table pn_vol_hist_lines_itf');

1059: END IF;
1060:
1061: END IF;
1062:
1063: pnp_debug_pkg.log('before upDATE of table pn_vol_hist_lines_itf');
1064:
1065: UPDATE pn_vol_hist_lines_itf
1066: SET status = 'I',
1067: error_log = NULL,

Line 1084: pnp_debug_pkg.put_log_msg(fnd_message.get||'-'||l_error_message);

1080: WHERE rowid = v_lines.rowid;
1081:
1082: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1083: fnd_message.set_token ('ID', p_batch_id);
1084: pnp_debug_pkg.put_log_msg(fnd_message.get||'-'||l_error_message);
1085:
1086: pnp_debug_pkg.log('Row Id :'||v_lines.rowid ||'-'||l_error_message);
1087:
1088: END;

Line 1086: pnp_debug_pkg.log('Row Id :'||v_lines.rowid ||'-'||l_error_message);

1082: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1083: fnd_message.set_token ('ID', p_batch_id);
1084: pnp_debug_pkg.put_log_msg(fnd_message.get||'-'||l_error_message);
1085:
1086: pnp_debug_pkg.log('Row Id :'||v_lines.rowid ||'-'||l_error_message);
1087:
1088: END;
1089: END LOOP;
1090: END IF;

Line 1095: pnp_debug_pkg.put_log_msg(l_error_message);

1091:
1092: IF (l_total = 0) THEN
1093: fnd_message.set_name ('PN', 'PN_SOI_BATCH_REC_NOT_FOUND');
1094: l_error_message := fnd_message.get;
1095: pnp_debug_pkg.put_log_msg(l_error_message);
1096: ELSE
1097: IF l_fail = 0 THEN
1098: v_status_code := 'I';
1099:

Line 1112: pnp_debug_pkg.put_log_msg('------------------------------------------------');

1108:
1109:
1110:
1111:
1112: pnp_debug_pkg.put_log_msg('------------------------------------------------');
1113:
1114: l_success := l_total- l_fail;
1115: fnd_message.set_name('PN', 'PN_SOI_PROC');
1116: fnd_message.set_token('NUM', TO_CHAR(l_success));

Line 1117: pnp_debug_pkg.put_log_msg(fnd_message.get);

1113:
1114: l_success := l_total- l_fail;
1115: fnd_message.set_name('PN', 'PN_SOI_PROC');
1116: fnd_message.set_token('NUM', TO_CHAR(l_success));
1117: pnp_debug_pkg.put_log_msg(fnd_message.get);
1118:
1119: fnd_message.set_name('PN', 'PN_SOI_FAILURE');
1120: fnd_message.set_token('FAILURE', l_fail);
1121: l_error_message := fnd_message.get;

Line 1122: pnp_debug_pkg.put_log_msg(l_error_message);

1118:
1119: fnd_message.set_name('PN', 'PN_SOI_FAILURE');
1120: fnd_message.set_token('FAILURE', l_fail);
1121: l_error_message := fnd_message.get;
1122: pnp_debug_pkg.put_log_msg(l_error_message);
1123:
1124: END IF;
1125:
1126: COMMIT;

Line 1140: pnp_debug_pkg.debug ('PN_VAR_RENTS_PKG.IMPORT_VOL_HIST (-)');

1136: sales_vol_update_flag = 'Y'
1137: WHERE
1138: line_item_id = lines_t(line_id);
1139:
1140: pnp_debug_pkg.debug ('PN_VAR_RENTS_PKG.IMPORT_VOL_HIST (-)');
1141:
1142: EXCEPTION
1143: WHEN NO_DATA_FOUND THEN
1144: pnp_debug_pkg.log('EXCEPTION: NO_DATA_FOUND');

Line 1144: pnp_debug_pkg.log('EXCEPTION: NO_DATA_FOUND');

1140: pnp_debug_pkg.debug ('PN_VAR_RENTS_PKG.IMPORT_VOL_HIST (-)');
1141:
1142: EXCEPTION
1143: WHEN NO_DATA_FOUND THEN
1144: pnp_debug_pkg.log('EXCEPTION: NO_DATA_FOUND');
1145: fnd_message.set_name ('PN', 'PN_SOI_BATCH_REC_NOT_FOUND');
1146: l_error_message := fnd_message.get;
1147: errbuf := l_error_message;
1148: retcode := '2';

Line 1149: pnp_debug_pkg.put_log_msg(errbuf);

1145: fnd_message.set_name ('PN', 'PN_SOI_BATCH_REC_NOT_FOUND');
1146: l_error_message := fnd_message.get;
1147: errbuf := l_error_message;
1148: retcode := '2';
1149: pnp_debug_pkg.put_log_msg(errbuf);
1150: RAISE;
1151:
1152: WHEN OTHERS THEN
1153: pnp_debug_pkg.log('EXCEPTION: OTHERS');

Line 1153: pnp_debug_pkg.log('EXCEPTION: OTHERS');

1149: pnp_debug_pkg.put_log_msg(errbuf);
1150: RAISE;
1151:
1152: WHEN OTHERS THEN
1153: pnp_debug_pkg.log('EXCEPTION: OTHERS');
1154: retcode := '2';
1155: pnp_debug_pkg.put_log_msg(errbuf);
1156: RAISE;
1157:

Line 1155: pnp_debug_pkg.put_log_msg(errbuf);

1151:
1152: WHEN OTHERS THEN
1153: pnp_debug_pkg.log('EXCEPTION: OTHERS');
1154: retcode := '2';
1155: pnp_debug_pkg.put_log_msg(errbuf);
1156: RAISE;
1157:
1158: END import_vol_hist;
1159:

Line 1188: PNP_DEBUG_PKG.debug ('PN_SOI_VOL_IMPORT .DELETE_VOL_HIST(+)');

1184: l_total_lines_deleted NUMBER := 0 ;
1185: l_error_message VARCHAR2(2000);
1186:
1187: BEGIN
1188: PNP_DEBUG_PKG.debug ('PN_SOI_VOL_IMPORT .DELETE_VOL_HIST(+)');
1189:
1190: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1191: fnd_message.set_token ('ID', p_batch_id);
1192: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1192: pnp_debug_pkg.put_log_msg(fnd_message.get);

1188: PNP_DEBUG_PKG.debug ('PN_SOI_VOL_IMPORT .DELETE_VOL_HIST(+)');
1189:
1190: fnd_message.set_name ('PN','PN_SOI_PBATCH');
1191: fnd_message.set_token ('ID', p_batch_id);
1192: pnp_debug_pkg.put_log_msg(fnd_message.get);
1193:
1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
1195: fnd_message.set_token ('DATE', p_start_DATE);
1196: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1196: pnp_debug_pkg.put_log_msg(fnd_message.get);

1192: pnp_debug_pkg.put_log_msg(fnd_message.get);
1193:
1194: fnd_message.set_name ('PN','PN_SOI_REP_DT_LOW');
1195: fnd_message.set_token ('DATE', p_start_DATE);
1196: pnp_debug_pkg.put_log_msg(fnd_message.get);
1197:
1198: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
1199: fnd_message.set_token ('DATE',p_start_DATE);
1200: pnp_debug_pkg.put_log_msg(fnd_message.get);

Line 1200: pnp_debug_pkg.put_log_msg(fnd_message.get);

1196: pnp_debug_pkg.put_log_msg(fnd_message.get);
1197:
1198: fnd_message.set_name ('PN','PN_SOI_REP_DT_HIGH');
1199: fnd_message.set_token ('DATE',p_start_DATE);
1200: pnp_debug_pkg.put_log_msg(fnd_message.get);
1201:
1202:
1203: FOR v_batch IN c_batch LOOP
1204:

Line 1209: pnp_debug_pkg.log ('Deleting Lines with status as I for batch Id:'||v_batch.batch_id);

1205: l_total := l_total + 1;
1206:
1207: IF (v_batch.status = 'I') THEN
1208:
1209: pnp_debug_pkg.log ('Deleting Lines with status as I for batch Id:'||v_batch.batch_id);
1210:
1211: DELETE FROM pn_vol_hist_lines_itf
1212: WHERE batch_id = v_batch.batch_id;
1213:

Line 1216: pnp_debug_pkg.log ('Deleting batch with status as I for Batch Id:'||v_batch.batch_id);

1212: WHERE batch_id = v_batch.batch_id;
1213:
1214: l_total_lines_deleted := l_total_lines_deleted + SQL%ROWCOUNT ;
1215:
1216: pnp_debug_pkg.log ('Deleting batch with status as I for Batch Id:'||v_batch.batch_id);
1217:
1218: DELETE FROM pn_vol_hist_batch_itf
1219: WHERE batch_id = v_batch.batch_id;
1220:

Line 1225: pnp_debug_pkg.log ('Deleting Lines with status as I for batch Id of status E:'||v_batch.batch_id);

1221: l_total_batch_deleted := l_total_batch_deleted + 1;
1222:
1223: ELSIF (v_batch.status = 'E') THEN
1224:
1225: pnp_debug_pkg.log ('Deleting Lines with status as I for batch Id of status E:'||v_batch.batch_id);
1226: DELETE FROM pn_vol_hist_lines_itf
1227: WHERE batch_id = v_batch.batch_id
1228: AND status = 'I';
1229:

Line 1237: pnp_debug_pkg.put_log_msg(l_error_message);

1233:
1234: IF (l_total = 0) THEN
1235: fnd_message.set_name ('PN', 'PN_SOI_NO_BATCH_FOUND');
1236: l_error_message := fnd_message.get;
1237: pnp_debug_pkg.put_log_msg(l_error_message);
1238:
1239: ELSE
1240: fnd_message.set_name('PN', 'PN_SOI_BATCH_TOTAL_DELETED');
1241: fnd_message.set_token('BATCH_TOTAL', l_total_batch_deleted);

Line 1243: pnp_debug_pkg.put_log_msg(l_error_message);

1239: ELSE
1240: fnd_message.set_name('PN', 'PN_SOI_BATCH_TOTAL_DELETED');
1241: fnd_message.set_token('BATCH_TOTAL', l_total_batch_deleted);
1242: l_error_message := fnd_message.get;
1243: pnp_debug_pkg.put_log_msg(l_error_message);
1244:
1245: fnd_message.set_name('PN', 'PN_SOI_LINES_TOTAL_DELETED');
1246: fnd_message.set_token('LINES_TOTAL', l_total_lines_deleted);
1247: l_error_message := fnd_message.get;

Line 1248: pnp_debug_pkg.put_log_msg(l_error_message);

1244:
1245: fnd_message.set_name('PN', 'PN_SOI_LINES_TOTAL_DELETED');
1246: fnd_message.set_token('LINES_TOTAL', l_total_lines_deleted);
1247: l_error_message := fnd_message.get;
1248: pnp_debug_pkg.put_log_msg(l_error_message);
1249: END IF;
1250:
1251: COMMIT;
1252:

Line 1253: pnp_debug_pkg.debug ('PN_VAR_RENTS_PKG.DELETE_VOL_HIST (-)');

1249: END IF;
1250:
1251: COMMIT;
1252:
1253: pnp_debug_pkg.debug ('PN_VAR_RENTS_PKG.DELETE_VOL_HIST (-)');
1254:
1255: END delete_vol_hist;
1256:
1257: END pn_soi_vol_import;