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

Line 61: pnp_debug_pkg.log('pn_distribution_account.create_accounts (+)' );

57:
58:
59: BEGIN
60:
61: pnp_debug_pkg.log('pn_distribution_account.create_accounts (+)' );
62:
63: fnd_message.set_name ('PN','PN_UPGAC_INP_PRM');
64: fnd_message.set_token ('LS_CLASS',p_lease_class);
65: fnd_message.set_token ('LS_FRM',p_lease_num_from);

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

69: fnd_message.set_token ('LIA_ACC',TO_CHAR(p_lia_ccid));
70: fnd_message.set_token ('LIB_ACC',TO_CHAR(p_accr_liab_ccid));
71: fnd_message.set_token ('REC_ACC',TO_CHAR(p_rec_ccid));
72: fnd_message.set_token ('ASS_ACC',TO_CHAR(p_accr_asset_ccid));
73: pnp_debug_pkg.put_log_msg(fnd_message.get);
74:
75:
76: IF (p_lease_class IS NULL AND
77: (p_rec_ccid IS NULL OR

Line 90: pnp_debug_pkg.put_log_msg(l_err_msg);

86: p_accr_asset_ccid IS NULL)) THEN
87:
88: fnd_message.set_name ('PN', 'PN_ALL_ACNT_DIST_MSG');
89: l_err_msg := fnd_message.get;
90: pnp_debug_pkg.put_log_msg(l_err_msg);
91: RETURN;
92: END IF;
93:
94:

Line 202: pnp_debug_pkg.log('Processing ... ' );

198: dbms_sql.column_value (l_cursor, 5,l_distribution_set_id);
199: dbms_sql.column_value (l_cursor, 6,l_project_id);
200: dbms_sql.column_value (l_cursor, 7,l_lease_class_code);
201:
202: pnp_debug_pkg.log('Processing ... ' );
203: pnp_debug_pkg.log('Lease Num :' || l_lease_num );
204: pnp_debug_pkg.log('Payment Term Id :' || l_payment_term_id );
205: pnp_debug_pkg.log('Lease Class :' || l_lease_class_code );
206:

Line 203: pnp_debug_pkg.log('Lease Num :' || l_lease_num );

199: dbms_sql.column_value (l_cursor, 6,l_project_id);
200: dbms_sql.column_value (l_cursor, 7,l_lease_class_code);
201:
202: pnp_debug_pkg.log('Processing ... ' );
203: pnp_debug_pkg.log('Lease Num :' || l_lease_num );
204: pnp_debug_pkg.log('Payment Term Id :' || l_payment_term_id );
205: pnp_debug_pkg.log('Lease Class :' || l_lease_class_code );
206:
207: IF l_lease_class_code = 'DIRECT' AND l_project_id IS NULL AND l_distribution_set_id IS NULL

Line 204: pnp_debug_pkg.log('Payment Term Id :' || l_payment_term_id );

200: dbms_sql.column_value (l_cursor, 7,l_lease_class_code);
201:
202: pnp_debug_pkg.log('Processing ... ' );
203: pnp_debug_pkg.log('Lease Num :' || l_lease_num );
204: pnp_debug_pkg.log('Payment Term Id :' || l_payment_term_id );
205: pnp_debug_pkg.log('Lease Class :' || l_lease_class_code );
206:
207: IF l_lease_class_code = 'DIRECT' AND l_project_id IS NULL AND l_distribution_set_id IS NULL
208: THEN

Line 205: pnp_debug_pkg.log('Lease Class :' || l_lease_class_code );

201:
202: pnp_debug_pkg.log('Processing ... ' );
203: pnp_debug_pkg.log('Lease Num :' || l_lease_num );
204: pnp_debug_pkg.log('Payment Term Id :' || l_payment_term_id );
205: pnp_debug_pkg.log('Lease Class :' || l_lease_class_code );
206:
207: IF l_lease_class_code = 'DIRECT' AND l_project_id IS NULL AND l_distribution_set_id IS NULL
208: THEN
209:

Line 235: pnp_debug_pkg.log('Creating Liability/Receivable A/C ... ' );

231: (l_lease_class_code IN ('SUB_LEASE','THIRD_PARTY')) THEN
232:
233: /* Create an Liability/Receivable a/c distribution */
234:
235: pnp_debug_pkg.log('Creating Liability/Receivable A/C ... ' );
236:
237: l_context := 'Creating Liability/Receivables A/C ';
238:
239: savepoint create_accnts;

Line 250: pnp_debug_pkg.log('Creating Accrued Liability/ Accrued Asset A/C ... ' );

246: p_accnt_exists => l_lia_rec_acc_exists);
247:
248: /* Create an accrued asset/accrued liability a/c distribution */
249:
250: pnp_debug_pkg.log('Creating Accrued Liability/ Accrued Asset A/C ... ' );
251:
252: l_context := 'Creating Accrued Liability/ Accrued Receivables A/C ';
253:
254: create_accnt_dist (p_payment_term_id => l_payment_term_id,

Line 270: pnp_debug_pkg.log('commiting for count of 100 ... ' );

266:
267: IF l_count = 1000 THEN
268:
269: l_context := 'Commiting for count of 100';
270: pnp_debug_pkg.log('commiting for count of 100 ... ' );
271: COMMIT;
272: l_total_count := l_total_count + l_count;
273: l_count := 0;
274:

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

284:
285: COMMIT;
286: fnd_message.set_name ('PN','PN_UPGAC_PROC');
287: fnd_message.set_token ('NUM', TO_CHAR(l_total_count));
288: pnp_debug_pkg.put_log_msg(fnd_message.get);
289:
290: pnp_debug_pkg.log('pn_distribution_account.create_accounts (-)' );
291:
292: EXCEPTION

Line 290: pnp_debug_pkg.log('pn_distribution_account.create_accounts (-)' );

286: fnd_message.set_name ('PN','PN_UPGAC_PROC');
287: fnd_message.set_token ('NUM', TO_CHAR(l_total_count));
288: pnp_debug_pkg.put_log_msg(fnd_message.get);
289:
290: pnp_debug_pkg.log('pn_distribution_account.create_accounts (-)' );
291:
292: EXCEPTION
293:
294: WHEN OTHERS THEN

Line 295: pnp_debug_pkg.log(SUBSTRB('Error IN create_accounts - ' || TO_CHAR(sqlcode) || ' - '|| l_context,1,244));

291:
292: EXCEPTION
293:
294: WHEN OTHERS THEN
295: pnp_debug_pkg.log(SUBSTRB('Error IN create_accounts - ' || TO_CHAR(sqlcode) || ' - '|| l_context,1,244));
296: errbuf := SUBSTRB('Error - ' || TO_CHAR(sqlcode) || ' - '|| l_context,1,244);
297: Retcode := sqlcode;
298: ROLLBACK TO create_accnts;
299: RAISE;

Line 338: pnp_debug_pkg.log('pn_distribution_account.create_accnt_dist (+)' );

334:
335: l_org_ID NUMBER;
336: BEGIN
337:
338: pnp_debug_pkg.log('pn_distribution_account.create_accnt_dist (+)' );
339:
340: l_context := 'Opening cursor';
341: OPEN chk_exists;
342:

Line 360: pnp_debug_pkg.log('Line Number : ' || TO_CHAR(l_line_number) );

356: INTO l_line_number
357: FROM pn_distributions_all
358: WHERE payment_term_id = p_payment_term_id;
359:
360: pnp_debug_pkg.log('Line Number : ' || TO_CHAR(l_line_number) );
361:
362: l_context := 'inserting INTO dist.';
363:
364: IF p_org_ID IS NULL THEN

Line 397: pnp_debug_pkg.log('Inserted INTO pn_distributions ...' );

393: SYSDATE,
394: FND_GLOBAL.USER_ID,
395: l_org_ID);
396:
397: pnp_debug_pkg.log('Inserted INTO pn_distributions ...' );
398: pnp_debug_pkg.log('Payment Term Id : '|| TO_CHAR(p_payment_term_id) );
399: pnp_debug_pkg.log('Account Class : '|| p_accnt_class );
400: pnp_debug_pkg.log('Account Id : '|| TO_CHAR(p_accnt_ccid) );
401: pnp_debug_pkg.log('Percentage : '|| TO_CHAR(p_percent) );

Line 398: pnp_debug_pkg.log('Payment Term Id : '|| TO_CHAR(p_payment_term_id) );

394: FND_GLOBAL.USER_ID,
395: l_org_ID);
396:
397: pnp_debug_pkg.log('Inserted INTO pn_distributions ...' );
398: pnp_debug_pkg.log('Payment Term Id : '|| TO_CHAR(p_payment_term_id) );
399: pnp_debug_pkg.log('Account Class : '|| p_accnt_class );
400: pnp_debug_pkg.log('Account Id : '|| TO_CHAR(p_accnt_ccid) );
401: pnp_debug_pkg.log('Percentage : '|| TO_CHAR(p_percent) );
402: pnp_debug_pkg.log('Org. Id : '|| TO_CHAR(p_org_id) );

Line 399: pnp_debug_pkg.log('Account Class : '|| p_accnt_class );

395: l_org_ID);
396:
397: pnp_debug_pkg.log('Inserted INTO pn_distributions ...' );
398: pnp_debug_pkg.log('Payment Term Id : '|| TO_CHAR(p_payment_term_id) );
399: pnp_debug_pkg.log('Account Class : '|| p_accnt_class );
400: pnp_debug_pkg.log('Account Id : '|| TO_CHAR(p_accnt_ccid) );
401: pnp_debug_pkg.log('Percentage : '|| TO_CHAR(p_percent) );
402: pnp_debug_pkg.log('Org. Id : '|| TO_CHAR(p_org_id) );
403:

Line 400: pnp_debug_pkg.log('Account Id : '|| TO_CHAR(p_accnt_ccid) );

396:
397: pnp_debug_pkg.log('Inserted INTO pn_distributions ...' );
398: pnp_debug_pkg.log('Payment Term Id : '|| TO_CHAR(p_payment_term_id) );
399: pnp_debug_pkg.log('Account Class : '|| p_accnt_class );
400: pnp_debug_pkg.log('Account Id : '|| TO_CHAR(p_accnt_ccid) );
401: pnp_debug_pkg.log('Percentage : '|| TO_CHAR(p_percent) );
402: pnp_debug_pkg.log('Org. Id : '|| TO_CHAR(p_org_id) );
403:
404: END IF;

Line 401: pnp_debug_pkg.log('Percentage : '|| TO_CHAR(p_percent) );

397: pnp_debug_pkg.log('Inserted INTO pn_distributions ...' );
398: pnp_debug_pkg.log('Payment Term Id : '|| TO_CHAR(p_payment_term_id) );
399: pnp_debug_pkg.log('Account Class : '|| p_accnt_class );
400: pnp_debug_pkg.log('Account Id : '|| TO_CHAR(p_accnt_ccid) );
401: pnp_debug_pkg.log('Percentage : '|| TO_CHAR(p_percent) );
402: pnp_debug_pkg.log('Org. Id : '|| TO_CHAR(p_org_id) );
403:
404: END IF;
405:

Line 402: pnp_debug_pkg.log('Org. Id : '|| TO_CHAR(p_org_id) );

398: pnp_debug_pkg.log('Payment Term Id : '|| TO_CHAR(p_payment_term_id) );
399: pnp_debug_pkg.log('Account Class : '|| p_accnt_class );
400: pnp_debug_pkg.log('Account Id : '|| TO_CHAR(p_accnt_ccid) );
401: pnp_debug_pkg.log('Percentage : '|| TO_CHAR(p_percent) );
402: pnp_debug_pkg.log('Org. Id : '|| TO_CHAR(p_org_id) );
403:
404: END IF;
405:
406: l_context := 'done inserting INTO dist.';

Line 407: pnp_debug_pkg.log('pn_distribution_account.create_accnt_dist (-)' );

403:
404: END IF;
405:
406: l_context := 'done inserting INTO dist.';
407: pnp_debug_pkg.log('pn_distribution_account.create_accnt_dist (-)' );
408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: pnp_debug_pkg.log(SUBSTRB('Error IN create_accnt_dist - ' || TO_CHAR(sqlcode) || ' - '|| l_context,1,244));

Line 411: pnp_debug_pkg.log(SUBSTRB('Error IN create_accnt_dist - ' || TO_CHAR(sqlcode) || ' - '|| l_context,1,244));

407: pnp_debug_pkg.log('pn_distribution_account.create_accnt_dist (-)' );
408:
409: EXCEPTION
410: WHEN OTHERS THEN
411: pnp_debug_pkg.log(SUBSTRB('Error IN create_accnt_dist - ' || TO_CHAR(sqlcode) || ' - '|| l_context,1,244));
412: ROLLBACK;
413: RAISE;
414:
415: END create_accnt_dist;