APPS.PSA_MFAR_VAL_PKG dependencies on FND_PROFILE

Line 253: l_profile_val := fnd_profile.value('AR_USE_INV_ACCT_FOR_CM_FLAG');

249: fnd_msg_pub.add;
250: RAISE FND_API.G_EXC_ERROR;
251: end if;
252:
253: l_profile_val := fnd_profile.value('AR_USE_INV_ACCT_FOR_CM_FLAG');
254: -- dbms_output.put_line(l_value);
255:
256: /* Bug Fix 1534215
257: -- modified by SIS

Line 400: fnd_profile.get('ORG_ID',l_org_id);

396:
397: FND_MSG_PUB.Initialize;
398: -- Get the org_id -- Bug 2374853
399:
400: fnd_profile.get('ORG_ID',l_org_id);
401:
402: SELECT 'X' into l_rct_check
403: from psa_trx_types_ALL a, ra_customer_trx_ALL b
404: -- ar_cash_receipts_ALL c,ar_receivable_applications_ALL d

Line 562: -- FND_PROFILE.GET('GL_SET_OF_BKS_ID', l_set_of_books_id);

558: -- ========================= FND LOG ===========================
559:
560: begin
561: l_return_status := 'N' ;
562: -- FND_PROFILE.GET('GL_SET_OF_BKS_ID', l_set_of_books_id);
563:
564: -- Bug 1632998
565:
566: l_set_of_books_id := PSA_MFAR_UTILS.get_ar_sob_id ;

Line 791: WHERE fnd_profile.value('AR_USE_INV_ACCT_FOR_CM_FLAG') <> 'Y'

787: WHERE L.REQUEST_ID = l_request_id
788: AND exists
789: (SELECT 'X' FROM RA_CUST_TRX_TYPES_ALL B,
790: PSA_TRX_TYPES_ALL C
791: WHERE fnd_profile.value('AR_USE_INV_ACCT_FOR_CM_FLAG') <> 'Y'
792: AND B.TYPE = 'CM'
793: AND L.REFERENCE_LINE_ID is not null
794: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID
795: AND b.cust_trx_type_id = c.psa_trx_type_id);