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_CREATE_ACC dependencies on PN_CREATE_ACC

Line 1: package body PN_CREATE_ACC as

1: package body PN_CREATE_ACC as
2: -- $Header: PNCRACCB.pls 120.10 2010/10/14 09:34:14 acprakas ship $
3:
4:
5: CURSOR c_ar_data (

Line 219: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info (+)');

215: AND period_set_name = l_period_set_name
216: AND period_type = l_user_period_type
217: AND NVL(ADJUSTMENT_PERIOD_FLAG, 'N') = 'N';
218: BEGIN
219: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info (+)');
220: l_ledger_id := p_ledger_id;
221: IF l_ledger_id IS NULL
222: THEN
223: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);

Line 226: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info l_ledger_id ' || l_ledger_id);

222: THEN
223: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);
224: END IF;
225:
226: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info l_ledger_id ' || l_ledger_id);
227:
228: OPEN prd_set_csr(l_ledger_id);
229: FETCH prd_set_csr INTO l_period_set_name, l_user_period_type;
230: CLOSE prd_set_csr;

Line 235: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info (-)');

231:
232: OPEN prd_name_csr (l_period_set_name, l_user_period_type);
233: FETCH prd_name_csr INTO p_period_name, p_start_date, p_end_date;
234: CLOSE prd_name_csr;
235: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_period_info (-)');
236:
237: EXCEPTION
238: WHEN OTHERS THEN
239: NULL;

Line 261: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (+)');

257: AND ledger_id = l_ledger_id
258: AND period_name = p_period_name;
259:
260: BEGIN
261: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (+)');
262: l_ledger_id := p_ledger_id;
263: IF l_ledger_id IS NULL
264: THEN
265: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);

Line 268: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status p_period_name '|| p_period_name);

264: THEN
265: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);
266: END IF;
267:
268: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status p_period_name '|| p_period_name);
269: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_ledger_id '|| l_ledger_id);
270:
271: OPEN sts_csr (l_ledger_id);
272: FETCH sts_csr INTO l_period_status;

Line 269: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_ledger_id '|| l_ledger_id);

265: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);
266: END IF;
267:
268: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status p_period_name '|| p_period_name);
269: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_ledger_id '|| l_ledger_id);
270:
271: OPEN sts_csr (l_ledger_id);
272: FETCH sts_csr INTO l_period_status;
273: CLOSE sts_csr;

Line 275: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_period_status '|| l_period_status);

271: OPEN sts_csr (l_ledger_id);
272: FETCH sts_csr INTO l_period_status;
273: CLOSE sts_csr;
274:
275: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_period_status '|| l_period_status);
276: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (-)');
277: RETURN l_period_status;
278:
279: EXCEPTION

Line 276: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (-)');

272: FETCH sts_csr INTO l_period_status;
273: CLOSE sts_csr;
274:
275: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status l_period_status '|| l_period_status);
276: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_pn_period_status (-)');
277: RETURN l_period_status;
278:
279: EXCEPTION
280: WHEN OTHERS THEN

Line 324: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date (+)');

320: l_period_status gl_period_statuses.closing_status%TYPE;
321: l_ledger_id NUMBER;
322:
323: BEGIN
324: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date (+)');
325: l_ledger_id := p_ledger_id;
326: IF l_ledger_id IS NULL
327: THEN
328: l_ledger_id := pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',pn_mo_cache_utils.get_current_org_id);

Line 349: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date Returuning Null(-)');

345: FETCH aft_csr INTO l_dummy_date;
346: CLOSE aft_csr;
347:
348: IF (l_dummy_date IS NULL) THEN
349: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date Returuning Null(-)');
350: RETURN NULL;
351: END IF;
352:
353: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date l_dummy_date '|| l_dummy_date);

Line 353: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date l_dummy_date '|| l_dummy_date);

349: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date Returuning Null(-)');
350: RETURN NULL;
351: END IF;
352:
353: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.get_valid_gl_date l_dummy_date '|| l_dummy_date);
354: RETURN l_dummy_date;
355:
356: END get_valid_gl_date;
357:

Line 659: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (+)');

655: l_success NUMBER;
656:
657: BEGIN
658:
659: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (+)');
660:
661: IF P_START_DATE IS NULL THEN
662: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
663: ELSE

Line 787: pn_create_acc.distribute_amount(p_payment_item_id => acct_rec.payment_item_id,

783:
784: END IF;
785:
786:
787: pn_create_acc.distribute_amount(p_payment_item_id => acct_rec.payment_item_id,
788: p_payment_term_id => acct_rec.payment_term_id,
789: p_accounted_amount => acct_rec.accounted_amount,
790: p_export_currency_amount => acct_rec.export_currency_amount,
791: p_export_currency_code => acct_rec.export_currency_code);

Line 898: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (-)');

894:
895: pnp_debug_pkg.put_log_msg('
896: ================================================================================');
897:
898: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AP_ACC_R12 (-)');
899:
900: END CREATE_AP_ACC_R12;
901:
902: -------------------------------------------------------------------------------

Line 958: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (+)');

954: l_success NUMBER;
955:
956: BEGIN
957:
958: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (+)');
959:
960: IF P_START_DATE IS NULL THEN
961: l_sch_start_date := to_date('01/01/0001','mm/dd/yyyy');
962: ELSE

Line 1080: pn_create_acc.distribute_amount(p_payment_item_id => acct_rec.payment_item_id,

1076:
1077: END IF;
1078:
1079:
1080: pn_create_acc.distribute_amount(p_payment_item_id => acct_rec.payment_item_id,
1081: p_payment_term_id => acct_rec.payment_term_id,
1082: p_accounted_amount => acct_rec.accounted_amount,
1083: p_export_currency_amount => acct_rec.export_currency_amount,
1084: p_export_currency_code => acct_rec.export_currency_code);

Line 1190: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (-)');

1186:
1187: pnp_debug_pkg.put_log_msg('
1188: ================================================================================');
1189:
1190: pnp_debug_pkg.put_log_msg('PN_CREATE_ACC.CREATE_AR_ACC_R12 (-)');
1191:
1192: END CREATE_AR_ACC_R12;
1193:
1194: -------------------------------------------------------------------------------

Line 1460: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (+)');

1456: l_accounted_amt NUMBER;
1457:
1458: BEGIN
1459:
1460: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (+)');
1461:
1462: IF p_conv_date > SYSDATE THEN
1463: l_conv_date := SYSDATE;
1464: ELSE

Line 1481: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (-)');

1477: p_called_from => 'NOTPNTAUPMT');
1478: END IF;
1479:
1480: pnp_debug_pkg.log('Accounted Amount = '||l_accounted_amt);
1481: pnp_debug_pkg.log('PN_CREATE_ACC.GET_ACCOUNTED_AMOUNT ----- (-)');
1482:
1483: RETURN l_accounted_amt;
1484:
1485: EXCEPTION

Line 3007: END PN_CREATE_ACC;

3003:
3004:
3005:
3006:
3007: END PN_CREATE_ACC;