DBA Data[Home] [Help]

APPS.PSA_XFR_TO_GL_PKG dependencies on PSA_MFAR_UTILS

Line 327: IF psa_mfar_utils.g_invalid_index > 0 THEN

323: END IF;
324:
325: END IF;
326:
327: IF psa_mfar_utils.g_invalid_index > 0 THEN
328: FND_MESSAGE.SET_NAME ('PSA', 'PSA_INVALID_CODE_COMBINATION');
329: psa_utils.debug_other_msg(p_level => g_error_level,
330: p_full_path => l_full_path,
331: p_remove_from_stack => FALSE);

Line 335: FOR i IN 1..psa_mfar_utils.g_invalid_index LOOP

331: p_remove_from_stack => FALSE);
332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.put_line(fnd_file.log, ' ');
334:
335: FOR i IN 1..psa_mfar_utils.g_invalid_index LOOP
336: fnd_file.put_line(fnd_file.log, psa_mfar_utils.g_invalid_combinations(i).combination );
337: fnd_file.put_line(fnd_file.log, psa_mfar_utils.g_invalid_combinations(i).error_message);
338: fnd_file.put_line(fnd_file.log, ' ');
339: END LOOP;

Line 336: fnd_file.put_line(fnd_file.log, psa_mfar_utils.g_invalid_combinations(i).combination );

332: fnd_file.put_line(fnd_file.log, fnd_message.get);
333: fnd_file.put_line(fnd_file.log, ' ');
334:
335: FOR i IN 1..psa_mfar_utils.g_invalid_index LOOP
336: fnd_file.put_line(fnd_file.log, psa_mfar_utils.g_invalid_combinations(i).combination );
337: fnd_file.put_line(fnd_file.log, psa_mfar_utils.g_invalid_combinations(i).error_message);
338: fnd_file.put_line(fnd_file.log, ' ');
339: END LOOP;
340: RAISE MFAR_PROC_EXCEPTION;

Line 337: fnd_file.put_line(fnd_file.log, psa_mfar_utils.g_invalid_combinations(i).error_message);

333: fnd_file.put_line(fnd_file.log, ' ');
334:
335: FOR i IN 1..psa_mfar_utils.g_invalid_index LOOP
336: fnd_file.put_line(fnd_file.log, psa_mfar_utils.g_invalid_combinations(i).combination );
337: fnd_file.put_line(fnd_file.log, psa_mfar_utils.g_invalid_combinations(i).error_message);
338: fnd_file.put_line(fnd_file.log, ' ');
339: END LOOP;
340: RAISE MFAR_PROC_EXCEPTION;
341: END IF;

Line 1091: '2', psa_mfar_utils.get_rec_ccid (null,p_customer_trx_id)) /* CREDIT A/C FROM CORE TRX_DIST */ ccid,

1087: ct.doc_sequence_value doc_num,
1088: ct.invoice_currency_code currency,
1089: DECODE (l1.lookup_code,
1090: '1', psa_trx_dist.mf_receivables_ccid, /* DEBIT A/C FROM PSA_TRX_DIST */
1091: '2', psa_mfar_utils.get_rec_ccid (null,p_customer_trx_id)) /* CREDIT A/C FROM CORE TRX_DIST */ ccid,
1092: DECODE (l1.lookup_code,
1093: '1', DECODE (SIGN (ctlgd.amount), -1, NULL, ctlgd.amount),
1094: '2', DECODE (SIGN (ctlgd.amount), -1, -ctlgd.amount, NULL)) entered_dr,
1095: DECODE (l1.lookup_code,

Line 1511: 2, DECODE(ra.application_type, 'CM', psa_mfar_utils.get_rec_ccid (ra.applied_customer_trx_id, ra.customer_trx_id), crh.account_code_combINation_id),

1507: DECODE( SUBSTR(ard.source_type,1,5),
1508: 'EXCH_', DECODE (cr.currency_code, l_func_curr, ctinv.invoice_currency_code, cr.currency_code), ctinv.invoice_currency_code), cr.currency_code),
1509: 'CM', ctcm.invoice_currency_code) currency,
1510: DECODE (to_NUMBER(l1.lookup_code), 1, psa_rct_dist.mf_cash_ccid,
1511: 2, DECODE(ra.application_type, 'CM', psa_mfar_utils.get_rec_ccid (ra.applied_customer_trx_id, ra.customer_trx_id), crh.account_code_combINation_id),
1512: 3, ra.code_combINation_id,
1513: 4, psa_trx_dist.mf_receivables_ccid,
1514: 5, psa_rct_dist.discount_ccid,
1515: 6, ra.earned_discount_ccid,

Line 2476: '3', PSA_MFAR_UTILS.get_rec_ccid (null, adj.customer_trx_id),

2472: adj.doc_sequence_value doc_num,
2473: ct.invoice_currency_code currency,
2474: DECODE(l.lookup_code, '1', psa_adj_dist.mf_adjustment_ccid,
2475: '2', get_adj_ccid (p_adjustment_id),
2476: '3', PSA_MFAR_UTILS.get_rec_ccid (null, adj.customer_trx_id),
2477: '4', psa_trx_dist.mf_receivables_ccid) ccid,
2478: get_entered_dr_adj (l.lookup_code, psa_adj_dist.amount) entered_dr,
2479: get_entered_cr_adj (l.lookup_code, psa_adj_dist.amount) entered_cr,
2480: get_entered_dr_adj (l.lookup_code, psa_adj_dist.amount) accounted_dr,

Line 2911: PSA_MFAR_UTILS.PSA_MF_ORG_DETAILS (l_org_details);

2907: psa_utils.debug_other_string(g_state_level,l_full_path,' l_chart_of_accounts_id --> ' || l_chart_of_accounts_id);
2908: psa_utils.debug_other_string(g_state_level,l_full_path,' Getting org details ');
2909: -- ========================= FND LOG ===========================
2910:
2911: PSA_MFAR_UTILS.PSA_MF_ORG_DETAILS (l_org_details);
2912:
2913: -- ========================= FND LOG ===========================
2914: psa_utils.debug_other_string(g_state_level,l_full_path,' l_org_details.allocation_method --> ' || l_org_details.allocation_method);
2915: -- ========================= FND LOG ===========================

Line 3802: 2, DECODE(ra.application_type, 'CM', psa_mfar_utils.get_rec_ccid (ra.applied_customer_trx_id, ra.customer_trx_id), crh.account_code_combINation_id),

3798: DECODE (ra.application_type, 'CASH', cr.doc_sequence_value,
3799: 'CM', ctcm.doc_sequence_value) doc_num,
3800: cr.currency_code currency,
3801: DECODE (to_NUMBER(l1.lookup_code), 1, psa_rct_dist.mf_cash_ccid,
3802: 2, DECODE(ra.application_type, 'CM', psa_mfar_utils.get_rec_ccid (ra.applied_customer_trx_id, ra.customer_trx_id), crh.account_code_combINation_id),
3803: 3, ar_trx_dist.code_combINation_id,
3804: 4, ar_trx_dist.code_combINation_id,
3805: 5, psa_rct_dist.discount_ccid,
3806: 6, ra.earned_discount_ccid,