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_LEASE_PVT dependencies on PN_DISTRIBUTIONS_PKG

Line 13638: pn_distributions_pkg.update_row( x_rowid => r_dist_details.row_id

13634: FOR i in p_terms_exp_rev_accounts_tbl.FIRST..p_terms_exp_rev_accounts_tbl.LAST
13635: LOOP
13636: IF (l_count <= l_record_count) THEN
13637: BEGIN
13638: pn_distributions_pkg.update_row( x_rowid => r_dist_details.row_id
13639: , x_distribution_id => r_dist_details.distribution_id
13640: , x_account_id => NVL(p_terms_exp_rev_accounts_tbl(i).account_id,r_dist_details.account_id)
13641: ,x_payment_term_id => r_dist_details.payment_term_id
13642: ,x_term_template_id => r_dist_details.term_template_id

Line 13667: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.UPDATE_ROW Successful',3);

13663: ,x_attribute14 => r_dist_details.attribute14
13664: ,x_attribute15 => r_dist_details.attribute15
13665: ,x_lease_change_id => p_lease_terms_rec.lease_change_id
13666: );
13667: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.UPDATE_ROW Successful',3);
13668: commit;
13669: l_count := l_count + 1;
13670: --------dbms_output.put_line('IN IF:UPDATE ROW');
13671: EXCEPTION

Line 13675: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.UPDATE_ROW:Exception:'||SQLERRM,3);

13671: EXCEPTION
13672: WHEN OTHERS THEN
13673: NULL;
13674: --------dbms_output.put_line('In Exception:In Update'||SQLERRM);
13675: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.UPDATE_ROW:Exception:'||SQLERRM,3);
13676: END;
13677: ELSE
13678: BEGIN
13679:

Line 13680: pn_distributions_pkg.insert_row (x_rowid => x_rowid

13676: END;
13677: ELSE
13678: BEGIN
13679:
13680: pn_distributions_pkg.insert_row (x_rowid => x_rowid
13681: ,x_distribution_id => x_distribution_id--r_dist_details.distribution_id
13682: ,x_account_id => NVL(p_terms_exp_rev_accounts_tbl(i).account_id,r_dist_details.account_id)
13683: ,x_payment_term_id => r_dist_details.payment_term_id
13684: ,x_term_template_id => r_dist_details.term_template_id

Line 13711: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);

13707: ,x_attribute14 => NULL
13708: ,x_attribute15 => NULL
13709: ,x_org_id => fnd_global.org_id
13710: );
13711: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);
13712: commit;
13713: --------dbms_output.put_line('IN ELSE:INSERT ROW');
13714: EXCEPTION
13715: WHEN OTHERS THEN

Line 13718: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);

13714: EXCEPTION
13715: WHEN OTHERS THEN
13716: NULL;
13717: --------dbms_output.put_line('In Exception:In ELSE: INSERT'||SQLERRM);
13718: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
13719: END;
13720: END IF;
13721: END LOOP;
13722: END LOOP;

Line 13730: pn_distributions_pkg.insert_row (x_rowid => x_rowid

13726: LOOP
13727: x_distribution_id := NULL;
13728: l_max_rownum := NULL;
13729: BEGIN
13730: pn_distributions_pkg.insert_row (x_rowid => x_rowid
13731: ,x_distribution_id => x_distribution_id--r_dist_details.distribution_id
13732: ,x_account_id => p_terms_exp_rev_accounts_tbl(i).account_id
13733: ,x_payment_term_id => p_lease_terms_rec.payment_term_id
13734: ,x_term_template_id => p_lease_terms_rec.term_template_id

Line 13761: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);

13757: ,x_attribute14 => NULL
13758: ,x_attribute15 => NULL
13759: ,x_org_id => fnd_global.org_id
13760: );
13761: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);
13762: COMMIT;
13763: --------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
13764: --l_max_row_num := l_max_row_num + 1;
13765: EXCEPTION

Line 13767: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);

13763: --------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
13764: --l_max_row_num := l_max_row_num + 1;
13765: EXCEPTION
13766: WHEN OTHERS THEN
13767: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
13768: NULL;
13769: --------dbms_output.put_line('In Exception:In ELSE:ELSE: INSERT'||SQLERRM);
13770: END;
13771: END LOOP;

Line 16110: pn_distributions_pkg.insert_row (x_rowid => x_rowid

16106: x_distribution_id := NULL;
16107: l_max_rownum := NULL;
16108: x_rowid := NULL;
16109: BEGIN
16110: pn_distributions_pkg.insert_row (x_rowid => x_rowid
16111: ,x_distribution_id => x_distribution_id--r_dist_details.distribution_id
16112: ,x_account_id => p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(m).account_id
16113: ,x_payment_term_id => p_payment_terms_tbl(i).payment_term_id
16114: ,x_term_template_id => NULL--p_payment_terms_tbl(i).term_template_id

Line 16142: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);

16138: ,x_attribute15 => NULL
16139: ,x_org_id => g_org_id
16140: );
16141:
16142: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);
16143: ----------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW'||x_distribution_id);
16144:
16145: ----------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16146: --l_max_row_num := l_max_row_num + 1;

Line 16149: ----------------dbms_output.put_line('ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);

16145: ----------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16146: --l_max_row_num := l_max_row_num + 1;
16147: EXCEPTION
16148: WHEN OTHERS THEN
16149: ----------------dbms_output.put_line('ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16150: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16151: END;
16152: END LOOP;
16153:

Line 16150: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);

16146: --l_max_row_num := l_max_row_num + 1;
16147: EXCEPTION
16148: WHEN OTHERS THEN
16149: ----------------dbms_output.put_line('ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16150: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16151: END;
16152: END LOOP;
16153:
16154: ---------------------------------

Line 16163: pn_distributions_pkg.insert_row (x_rowid => x_rowid

16159: l_max_rownum := NULL;
16160: x_rowid := NULL;
16161: BEGIN
16162:
16163: pn_distributions_pkg.insert_row (x_rowid => x_rowid
16164: ,x_distribution_id => x_distribution_id--r_dist_details.distribution_id
16165: ,x_account_id => p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(m).account_id
16166: ,x_payment_term_id => p_payment_terms_tbl(i).payment_term_id
16167: ,x_term_template_id => NULL--p_payment_terms_tbl(i).term_template_id

Line 16195: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);

16191: ,x_attribute15 => NULL
16192: ,x_org_id => g_org_id
16193: );
16194:
16195: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);
16196: ----------------dbms_output.put_line('IN ELSE : ELSE:p_terms_liab_rcvl_account_tbl ROW'||x_distribution_id);
16197:
16198: ----------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16199: --l_max_row_num := l_max_row_num + 1;

Line 16202: ----------------dbms_output.put_line('p_terms_liab_rcvl_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);

16198: ----------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16199: --l_max_row_num := l_max_row_num + 1;
16200: EXCEPTION
16201: WHEN OTHERS THEN
16202: ----------------dbms_output.put_line('p_terms_liab_rcvl_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16203: pvt_debug(g_pkg_name||'p_terms_liab_rcvl_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16204: END;
16205: END LOOP;
16206:

Line 16203: pvt_debug(g_pkg_name||'p_terms_liab_rcvl_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);

16199: --l_max_row_num := l_max_row_num + 1;
16200: EXCEPTION
16201: WHEN OTHERS THEN
16202: ----------------dbms_output.put_line('p_terms_liab_rcvl_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16203: pvt_debug(g_pkg_name||'p_terms_liab_rcvl_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16204: END;
16205: END LOOP;
16206:
16207: ----------------------------------

Line 16214: pn_distributions_pkg.insert_row (x_rowid => x_rowid

16210: x_distribution_id := NULL;
16211: l_max_rownum := NULL;
16212: x_rowid := NULL;
16213: BEGIN
16214: pn_distributions_pkg.insert_row (x_rowid => x_rowid
16215: ,x_distribution_id => x_distribution_id--r_dist_details.distribution_id
16216: ,x_account_id => p_payment_terms_tbl(i).p_terms_accrual_account_tbl(m).account_id
16217: ,x_payment_term_id => p_payment_terms_tbl(i).payment_term_id
16218: ,x_term_template_id => NULL--p_payment_terms_tbl(i).term_template_id

Line 16246: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);

16242: ,x_attribute15 => NULL
16243: ,x_org_id => g_org_id
16244: );
16245:
16246: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);
16247: ----------------dbms_output.put_line('IN ELSE : ELSE:p_terms_accrual_account_tbl ROW'||x_distribution_id);
16248:
16249: ----------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16250: --l_max_row_num := l_max_row_num + 1;

Line 16253: ----------------dbms_output.put_line('p_terms_accrual_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);

16249: ----------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16250: --l_max_row_num := l_max_row_num + 1;
16251: EXCEPTION
16252: WHEN OTHERS THEN
16253: ----------------dbms_output.put_line('p_terms_accrual_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16254: pvt_debug(g_pkg_name||'p_terms_accrual_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16255: END;
16256: END LOOP;
16257: -------------------------------------

Line 16254: pvt_debug(g_pkg_name||'p_terms_accrual_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);

16250: --l_max_row_num := l_max_row_num + 1;
16251: EXCEPTION
16252: WHEN OTHERS THEN
16253: ----------------dbms_output.put_line('p_terms_accrual_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16254: pvt_debug(g_pkg_name||'p_terms_accrual_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16255: END;
16256: END LOOP;
16257: -------------------------------------
16258: END IF;--Success Status

Line 16310: pn_distributions_pkg.update_row( x_rowid => r_dist_details.row_id

16306: FOR p in 1..p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl.COUNT
16307: LOOP
16308: IF (l_count <= l_record_count_exp_rev) THEN
16309: BEGIN
16310: pn_distributions_pkg.update_row( x_rowid => r_dist_details.row_id
16311: , x_distribution_id => r_dist_details.distribution_id
16312: , x_account_id => NVL(p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(p).account_id,r_dist_details.account_id)
16313: ,x_payment_term_id => r_dist_details.payment_term_id
16314: ,x_term_template_id => NULL--r_dist_details.term_template_id

Line 16339: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.UPDATE_ROW Successful',3);

16335: ,x_attribute14 => r_dist_details.attribute14
16336: ,x_attribute15 => r_dist_details.attribute15
16337: ,x_lease_change_id => g_lease_change_id
16338: );
16339: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.UPDATE_ROW Successful',3);
16340:
16341: l_count := l_count + 1;
16342: ----------------------dbms_output.put_line('IN IF:UPDATE ROW');
16343: EXCEPTION

Line 16347: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.UPDATE_ROW:Exception:'||SQLERRM,3);

16343: EXCEPTION
16344: WHEN OTHERS THEN
16345: NULL;
16346: ----------------------dbms_output.put_line('In Exception:In Update'||SQLERRM);
16347: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.UPDATE_ROW:Exception:'||SQLERRM,3);
16348: END;
16349: ELSE
16350: BEGIN
16351: pn_distributions_pkg.insert_row (x_rowid => x_rowid

Line 16351: pn_distributions_pkg.insert_row (x_rowid => x_rowid

16347: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:PN_DISTRIBUTIONS_PKG.UPDATE_ROW:Exception:'||SQLERRM,3);
16348: END;
16349: ELSE
16350: BEGIN
16351: pn_distributions_pkg.insert_row (x_rowid => x_rowid
16352: ,x_distribution_id => x_distribution_id--r_dist_details.distribution_id
16353: ,x_account_id => NVL(p_payment_terms_tbl(i).p_terms_exp_rev_accounts_tbl(p).account_id,r_dist_details.account_id)
16354: ,x_payment_term_id => r_dist_details.payment_term_id
16355: ,x_term_template_id => NULL--r_dist_details.term_template_id

Line 16382: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.INSERT_ROW for Expense Revenue Successful',3);

16378: ,x_attribute14 => NULL
16379: ,x_attribute15 => NULL
16380: ,x_org_id => g_org_id--fnd_global.org_id
16381: );
16382: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.INSERT_ROW for Expense Revenue Successful',3);
16383:
16384: EXCEPTION
16385: WHEN OTHERS THEN
16386: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.INSERT_ROW for Expense Revenue :Exception:'||SQLERRM,3);

Line 16386: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.INSERT_ROW for Expense Revenue :Exception:'||SQLERRM,3);

16382: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.INSERT_ROW for Expense Revenue Successful',3);
16383:
16384: EXCEPTION
16385: WHEN OTHERS THEN
16386: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.INSERT_ROW for Expense Revenue :Exception:'||SQLERRM,3);
16387: END;
16388: END IF;
16389: END LOOP;
16390: END LOOP;

Line 16418: pn_distributions_pkg.update_row( x_rowid => r_dist_details.row_id

16414: FOR p in 1..p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl.COUNT
16415: LOOP
16416: IF(p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(p).account_id IS NOT NULL) THEN
16417: BEGIN
16418: pn_distributions_pkg.update_row( x_rowid => r_dist_details.row_id
16419: , x_distribution_id => r_dist_details.distribution_id
16420: , x_account_id => NVL(p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(p).account_id,r_dist_details.account_id)
16421: ,x_payment_term_id => r_dist_details.payment_term_id
16422: ,x_term_template_id => NULL--r_dist_details.term_template_id

Line 16447: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.UPDATE_ROW for Liability and Receivable Successful',3);

16443: ,x_attribute14 => r_dist_details.attribute14
16444: ,x_attribute15 => r_dist_details.attribute15
16445: ,x_lease_change_id => g_lease_change_id
16446: );
16447: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.UPDATE_ROW for Liability and Receivable Successful',3);
16448:
16449: l_count := l_count + 1;
16450: ----------------------dbms_output.put_line('IN IF:UPDATE ROW');
16451: EXCEPTION

Line 16454: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.UPDATE_ROW for Liability and Receivable:Exception:'||SQLERRM,3);

16450: ----------------------dbms_output.put_line('IN IF:UPDATE ROW');
16451: EXCEPTION
16452: WHEN OTHERS THEN
16453: ----------------------dbms_output.put_line('In Exception:In Update'||SQLERRM);
16454: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.UPDATE_ROW for Liability and Receivable:Exception:'||SQLERRM,3);
16455: END;
16456: ELSE
16457: IF(p_lease_class_code = 'DIRECT') THEN
16458: BEGIN

Line 16464: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Liability and Receivable DELETE ROW',3);

16460: WHERE account_class = l_acc_code
16461: AND payment_term_id = p_payment_terms_tbl(i).payment_term_id
16462: AND org_id = g_org_id;
16463: COMMIT;
16464: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Liability and Receivable DELETE ROW',3);
16465: EXCEPTION
16466: WHEN OTHERS THEN
16467: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Liability and Receivable DELETE ROW Successful',3);
16468: END;

Line 16467: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Liability and Receivable DELETE ROW Successful',3);

16463: COMMIT;
16464: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Liability and Receivable DELETE ROW',3);
16465: EXCEPTION
16466: WHEN OTHERS THEN
16467: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Liability and Receivable DELETE ROW Successful',3);
16468: END;
16469: ELSE
16470: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Cannot delete the Liability and Receivable for Revenue/Sublease',3);
16471: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');

Line 16470: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Cannot delete the Liability and Receivable for Revenue/Sublease',3);

16466: WHEN OTHERS THEN
16467: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Liability and Receivable DELETE ROW Successful',3);
16468: END;
16469: ELSE
16470: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.Cannot delete the Liability and Receivable for Revenue/Sublease',3);
16471: fnd_message.set_name('PN','PN_OTHERS_EXCEPTION');
16472: fnd_message.set_token('ERR_MSG', 'Cannot make the Liability/Receivable ID to NULL');
16473: fnd_msg_pub.ADD;
16474: RAISE fnd_api.g_exc_error;

Line 16487: pn_distributions_pkg.insert_row (x_rowid => x_rowid

16483: l_max_rownum := NULL;
16484: x_rowid := NULL;
16485: BEGIN
16486:
16487: pn_distributions_pkg.insert_row (x_rowid => x_rowid
16488: ,x_distribution_id => x_distribution_id--r_dist_details.distribution_id
16489: ,x_account_id => p_payment_terms_tbl(i).p_terms_liab_rcvl_account_tbl(p).account_id
16490: ,x_payment_term_id => p_payment_terms_tbl(i).payment_term_id
16491: ,x_term_template_id => NULL--p_payment_terms_tbl(i).term_template_id

Line 16519: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:UPDATE_TERMS:RECEIVABLES?LIABILITY:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);

16515: ,x_attribute15 => NULL
16516: ,x_org_id => g_org_id
16517: );
16518:
16519: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:UPDATE_TERMS:RECEIVABLES?LIABILITY:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);
16520: ----------------dbms_output.put_line('IN ELSE : ELSE:p_terms_liab_rcvl_account_tbl ROW'||x_distribution_id);
16521:
16522: ----------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16523: --l_max_row_num := l_max_row_num + 1;

Line 16526: ----------------dbms_output.put_line('p_terms_liab_rcvl_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);

16522: ----------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16523: --l_max_row_num := l_max_row_num + 1;
16524: EXCEPTION
16525: WHEN OTHERS THEN
16526: ----------------dbms_output.put_line('p_terms_liab_rcvl_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16527: pvt_debug(g_pkg_name||'p_terms_liab_rcvl_account_tbl:UPDATE_TERMS:RECEIVABLES?LIABILITY:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16528: END;
16529: END LOOP;
16530: END IF; -- (COUNT > 0)

Line 16527: pvt_debug(g_pkg_name||'p_terms_liab_rcvl_account_tbl:UPDATE_TERMS:RECEIVABLES?LIABILITY:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);

16523: --l_max_row_num := l_max_row_num + 1;
16524: EXCEPTION
16525: WHEN OTHERS THEN
16526: ----------------dbms_output.put_line('p_terms_liab_rcvl_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16527: pvt_debug(g_pkg_name||'p_terms_liab_rcvl_account_tbl:UPDATE_TERMS:RECEIVABLES?LIABILITY:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16528: END;
16529: END LOOP;
16530: END IF; -- (COUNT > 0)
16531: END IF; --

Line 16561: pn_distributions_pkg.update_row( x_rowid => r_dist_details.row_id

16557: FOR p in 1..p_payment_terms_tbl(i).p_terms_accrual_account_tbl.COUNT
16558: LOOP
16559: IF(p_payment_terms_tbl(i).p_terms_accrual_account_tbl(p).account_id IS NOT NULL) THEN
16560: BEGIN
16561: pn_distributions_pkg.update_row( x_rowid => r_dist_details.row_id
16562: , x_distribution_id => r_dist_details.distribution_id
16563: , x_account_id => NVL(p_payment_terms_tbl(i).p_terms_accrual_account_tbl(p).account_id,r_dist_details.account_id)
16564: ,x_payment_term_id => r_dist_details.payment_term_id
16565: ,x_term_template_id => NULL--r_dist_details.term_template_id

Line 16590: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.UPDATE_ROW for Accrual Successful',3);

16586: ,x_attribute14 => r_dist_details.attribute14
16587: ,x_attribute15 => r_dist_details.attribute15
16588: ,x_lease_change_id => g_lease_change_id
16589: );
16590: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.UPDATE_ROW for Accrual Successful',3);
16591:
16592: l_count := l_count + 1;
16593: ----------------------dbms_output.put_line('IN IF:UPDATE ROW');
16594: EXCEPTION

Line 16597: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.UPDATE_ROW for Accrual:Exception:'||SQLERRM,3);

16593: ----------------------dbms_output.put_line('IN IF:UPDATE ROW');
16594: EXCEPTION
16595: WHEN OTHERS THEN
16596: ----------------------dbms_output.put_line('In Exception:In Update'||SQLERRM);
16597: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.UPDATE_ROW for Accrual:Exception:'||SQLERRM,3);
16598: END;
16599: ELSE
16600: BEGIN
16601: DELETE FROM pn_distributions_all

Line 16606: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.DELETE ROW for Accrual',3);

16602: WHERE account_class = l_acc_code
16603: AND payment_term_id = p_payment_terms_tbl(i).payment_term_id
16604: AND org_id = g_org_id;
16605:
16606: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.DELETE ROW for Accrual',3);
16607: EXCEPTION
16608: WHEN OTHERS THEN
16609: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.DELETE ROW for Accrual Successful',3);
16610: END;

Line 16609: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.DELETE ROW for Accrual Successful',3);

16605:
16606: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.DELETE ROW for Accrual',3);
16607: EXCEPTION
16608: WHEN OTHERS THEN
16609: pvt_debug(g_pkg_name||'PN_DISTRIBUTIONS_PKG.DELETE ROW for Accrual Successful',3);
16610: END;
16611: END IF;
16612: END LOOP;
16613: END LOOP;

Line 16621: pn_distributions_pkg.insert_row (x_rowid => x_rowid

16617: x_distribution_id := NULL;
16618: l_max_rownum := NULL;
16619: x_rowid := NULL;
16620: BEGIN
16621: pn_distributions_pkg.insert_row (x_rowid => x_rowid
16622: ,x_distribution_id => x_distribution_id--r_dist_details.distribution_id
16623: ,x_account_id => p_payment_terms_tbl(i).p_terms_accrual_account_tbl(p).account_id
16624: ,x_payment_term_id => p_payment_terms_tbl(i).payment_term_id
16625: ,x_term_template_id => NULL--p_payment_terms_tbl(i).term_template_id

Line 16653: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:UPDATE_TERMS:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);

16649: ,x_attribute15 => NULL
16650: ,x_org_id => g_org_id
16651: );
16652:
16653: pvt_debug(g_pkg_name||'ADD_DIST_ACCOUNT:UPDATE_TERMS:PN_DISTRIBUTIONS_PKG.INSERT_ROW Successful',3);
16654: --------------dbms_output.put_line('IN ELSE : ELSE:p_terms_accrual_account_tbl ROW'||x_distribution_id);
16655:
16656: --------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16657: --l_max_row_num := l_max_row_num + 1;

Line 16660: --------------dbms_output.put_line('p_terms_accrual_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);

16656: --------------------dbms_output.put_line('IN ELSE : ELSE:INSERT ROW');
16657: --l_max_row_num := l_max_row_num + 1;
16658: EXCEPTION
16659: WHEN OTHERS THEN
16660: --------------dbms_output.put_line('p_terms_accrual_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16661: pvt_debug(g_pkg_name||'p_terms_accrual_account_tbl:UPDATE_TERMS:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16662: END;
16663: END LOOP;
16664: END IF; --(COUNT > 0)

Line 16661: pvt_debug(g_pkg_name||'p_terms_accrual_account_tbl:UPDATE_TERMS:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);

16657: --l_max_row_num := l_max_row_num + 1;
16658: EXCEPTION
16659: WHEN OTHERS THEN
16660: --------------dbms_output.put_line('p_terms_accrual_account_tbl:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM);
16661: pvt_debug(g_pkg_name||'p_terms_accrual_account_tbl:UPDATE_TERMS:PN_DISTRIBUTIONS_PKG.INSERT_ROW:Exception:'||SQLERRM,3);
16662: END;
16663: END LOOP;
16664: END IF; --(COUNT > 0)
16665: END IF;