APPS.ARI_UTILITIES dependencies on FND_PROFILE

Line 8: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ARI_UTILITIES';
8: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
9:
10: G_PRV_ADDRESS_ID HZ_CUST_ACCT_SITES.CUST_ACCT_SITE_ID%TYPE := 0;
11: G_BILL_TO_SITE_USE_ID HZ_CUST_SITE_USES.SITE_USE_ID%TYPE := 0;
12: G_PRV_SITE_USES VARCHAR2(2000);

Line 598: l_profile_default_currrency := FND_PROFILE.value('OIR_DEFAULT_CURRENCY_CODE');

594: l_default_org_id NUMBER(15,0);
595: l_profile_default_currrency VARCHAR2(15);
596: l_currency_exist NUMBER(4);
597: BEGIN
598: l_profile_default_currrency := FND_PROFILE.value('OIR_DEFAULT_CURRENCY_CODE');
599:
600: IF(p_customer_id IS NULL) THEN
601:
602: select count(*) into l_currency_exist from dual where l_profile_default_currrency in

Line 1204: ELSIF (nvl(FND_PROFILE.VALUE('OIR_SAVE_PAYMENT_INSTR_INFO'),'N') = 'N') THEN

1200: else
1201: return false;
1202: end if;
1203: end if;
1204: ELSIF (nvl(FND_PROFILE.VALUE('OIR_SAVE_PAYMENT_INSTR_INFO'),'N') = 'N') THEN
1205: RETURN FALSE;
1206: ELSE
1207: RETURN TRUE;
1208: END IF;

Line 1256: RETURN (NVL(FND_PROFILE.VALUE('OIR_AGING_BUCKETS'),'0'));

1252:
1253: IF(l_attr IS NOT NULL) THEN
1254: RETURN l_attr;
1255: ELSE
1256: RETURN (NVL(FND_PROFILE.VALUE('OIR_AGING_BUCKETS'),'0'));
1257: END IF;
1258: ELSE
1259: RETURN (NVL(FND_PROFILE.VALUE('OIR_AGING_BUCKETS'),'0'));
1260: END IF;

Line 1259: RETURN (NVL(FND_PROFILE.VALUE('OIR_AGING_BUCKETS'),'0'));

1255: ELSE
1256: RETURN (NVL(FND_PROFILE.VALUE('OIR_AGING_BUCKETS'),'0'));
1257: END IF;
1258: ELSE
1259: RETURN (NVL(FND_PROFILE.VALUE('OIR_AGING_BUCKETS'),'0'));
1260: END IF;
1261: EXCEPTION
1262: WHEN OTHERS THEN
1263: RETURN '0';

Line 1287: RETURN (NVL(FND_PROFILE.VALUE('OIR_BPA_MULTI_PRINT_LIMIT'),'0'));

1283: l_attr := FUN_RULE_PUB.get_string;
1284: IF(l_attr IS NOT NULL) THEN
1285: RETURN l_attr;
1286: ELSE
1287: RETURN (NVL(FND_PROFILE.VALUE('OIR_BPA_MULTI_PRINT_LIMIT'),'0'));
1288: END IF;
1289: ELSE
1290: RETURN (NVL(FND_PROFILE.VALUE('OIR_BPA_MULTI_PRINT_LIMIT'),'0'));
1291: END IF;

Line 1290: RETURN (NVL(FND_PROFILE.VALUE('OIR_BPA_MULTI_PRINT_LIMIT'),'0'));

1286: ELSE
1287: RETURN (NVL(FND_PROFILE.VALUE('OIR_BPA_MULTI_PRINT_LIMIT'),'0'));
1288: END IF;
1289: ELSE
1290: RETURN (NVL(FND_PROFILE.VALUE('OIR_BPA_MULTI_PRINT_LIMIT'),'0'));
1291: END IF;
1292:
1293: EXCEPTION
1294: WHEN OTHERS THEN

Line 1319: RETURN (NVL(FND_PROFILE.VALUE('OIR_ENABLE_DISCOUNT_GRACE_DAYS'),'N'));

1315: l_attr := FUN_RULE_PUB.get_string;
1316: IF(l_attr IS NOT NULL) THEN
1317: RETURN l_attr;
1318: ELSE
1319: RETURN (NVL(FND_PROFILE.VALUE('OIR_ENABLE_DISCOUNT_GRACE_DAYS'),'N'));
1320: END IF;
1321: ELSE
1322: RETURN (NVL(FND_PROFILE.VALUE('OIR_ENABLE_DISCOUNT_GRACE_DAYS'),'N'));
1323: END IF;

Line 1322: RETURN (NVL(FND_PROFILE.VALUE('OIR_ENABLE_DISCOUNT_GRACE_DAYS'),'N'));

1318: ELSE
1319: RETURN (NVL(FND_PROFILE.VALUE('OIR_ENABLE_DISCOUNT_GRACE_DAYS'),'N'));
1320: END IF;
1321: ELSE
1322: RETURN (NVL(FND_PROFILE.VALUE('OIR_ENABLE_DISCOUNT_GRACE_DAYS'),'N'));
1323: END IF;
1324:
1325: EXCEPTION
1326: WHEN OTHERS THEN

Line 1358: ELSIF (nvl(FND_PROFILE.VALUE('OIR_ENABLE_SERVICE_CHARGE'),'N') = 'Y') THEN

1354: return false;
1355: end if;
1356: end if;
1357:
1358: ELSIF (nvl(FND_PROFILE.VALUE('OIR_ENABLE_SERVICE_CHARGE'),'N') = 'Y') THEN
1359: RETURN TRUE;
1360: ELSE
1361: RETURN FALSE;
1362: END IF;

Line 1378: IF (nvl(FND_PROFILE.VALUE('OIR_ENABLE_DISCOUNT_GRACE_DAYS'),'N') = 'Y') THEN

1374: IS
1375: BEGIN
1376: -- This can be configured to return the appropriate value based on
1377: -- whether grace days have to be picked up for discounts.
1378: IF (nvl(FND_PROFILE.VALUE('OIR_ENABLE_DISCOUNT_GRACE_DAYS'),'N') = 'Y') THEN
1379: RETURN TRUE;
1380: ELSE
1381: RETURN FALSE;
1382: END IF;

Line 1499: RETURN TRUNC(SYSDATE + NVL(FND_PROFILE.VALUE('OIR_MAX_FUTURE_PAYMENT_DAYS_ALLOWED'),365));

1495: end if;
1496:
1497: END IF;
1498:
1499: RETURN TRUNC(SYSDATE + NVL(FND_PROFILE.VALUE('OIR_MAX_FUTURE_PAYMENT_DAYS_ALLOWED'),365));
1500:
1501: EXCEPTION
1502: WHEN OTHERS THEN
1503: RETURN TRUNC(SYSDATE + 365);

Line 2199: l_default_note_type varchar2(240) := FND_PROFILE.VALUE('AST_NOTES_DEFAULT_TYPE');

2195: new_dispute_date DATE;
2196: new_dispute_amt NUMBER;
2197: remove_from_dispute_amt NUMBER;
2198: i NUMBER;
2199: l_default_note_type varchar2(240) := FND_PROFILE.VALUE('AST_NOTES_DEFAULT_TYPE');
2200: l_jtf_note_contexts_table jtf_notes_pub.jtf_note_contexts_tbl_type;
2201: l_context_tab CONTEXTS_TBL_TYPE;
2202: l_return_status VARCHAR2(1);
2203: l_msg_count NUMBER;