APPS.JL_INTERFACE_VAL dependencies on FND_PROFILE

Line 4: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');

1: PACKAGE BODY JL_INTERFACE_VAL AS
2: /* $Header: jgjlgdfb.pls 120.13 2006/03/31 20:30:34 amohiudd ship $ */
3:
4: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
5: -- Bugfix# 3259701
6: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
7:
8: PROCEDURE ap_business_rules

Line 6: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

2: /* $Header: jgjlgdfb.pls 120.13 2006/03/31 20:30:34 amohiudd ship $ */
3:
4: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
5: -- Bugfix# 3259701
6: --PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
7:
8: PROCEDURE ap_business_rules
9: (p_calling_program_name IN VARCHAR2,
10: p_set_of_books_id IN NUMBER,

Line 329: --fnd_profile.get('ORG_ID',l_ou_id);

325: ------------------------
326: -- Get the Country Code
327: ------------------------
328: --Bug 2354736
329: --fnd_profile.get('ORG_ID',l_ou_id);
330: --Bug 4499004
331: --commented out above line and getting org id from fnd concurrents
332: SELECT org_id into l_ou_id FROM fnd_concurrent_requests
333: WHERE request_id = fnd_global.conc_request_id ;

Line 1371: PG_DEBUG varchar2(1); -- := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1367:
1368: l_current_record_status VARCHAR2(1); -- := 'S';
1369: l_ou_id NUMBER;
1370:
1371: PG_DEBUG varchar2(1); -- := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1372:
1373: BEGIN
1374: l_current_record_status := 'S';
1375: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line 1375: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1371: PG_DEBUG varchar2(1); -- := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1372:
1373: BEGIN
1374: l_current_record_status := 'S';
1375: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
1376: ----------------------------- DEBUG INFORMATION ------------------------------
1377: IF PG_DEBUG = 'Y' THEN
1378: arp_util_tax.debug('ar_business_rules: ' || 'Check ar business rules');
1379: END IF;

Line 1386: --fnd_profile.get('ORG_ID',l_ou_id);

1382: -- Call to validate the address gdfs
1383:
1384: IF p_int_table_name = 'CUSTOMER' THEN
1385:
1386: --fnd_profile.get('ORG_ID',l_ou_id);
1387:
1388: --Bug 4499004
1389: --commented out above line and getting org id from fnd concurrents
1390: SELECT org_id into l_ou_id FROM fnd_concurrent_requests

Line 1438: --fnd_profile.get('ORG_ID',l_ou_id);

1434: -- Call to validate the profile gdfs
1435:
1436: ELSIF (p_int_table_name) = 'PROFILE' THEN
1437:
1438: --fnd_profile.get('ORG_ID',l_ou_id);
1439: --Bug 4499004
1440: --commented out above line and getting org id from fnd concurrents
1441: SELECT org_id into l_ou_id FROM fnd_concurrent_requests
1442: WHERE request_id = fnd_global.conc_request_id ;

Line 2001: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

1997:
1998: PG_DEBUG varchar2(1);
1999:
2000: BEGIN
2001: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2002:
2003: FND_PROFILE.GET('JLZZ_TAXID_RAISE_ERROR',l_taxid_raise_error);
2004: IF p_country_code = 'CL' THEN
2005: l_taxid_raise_error := NVL(l_taxid_raise_error,'VALIDATION_TYPE_WARN');

Line 2003: FND_PROFILE.GET('JLZZ_TAXID_RAISE_ERROR',l_taxid_raise_error);

1999:
2000: BEGIN
2001: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
2002:
2003: FND_PROFILE.GET('JLZZ_TAXID_RAISE_ERROR',l_taxid_raise_error);
2004: IF p_country_code = 'CL' THEN
2005: l_taxid_raise_error := NVL(l_taxid_raise_error,'VALIDATION_TYPE_WARN');
2006: l_num_digits := 12; -- Maximum digits allowed for Chile
2007: END IF; -- End IF p_country_code = 'CL'

Line 2025: FND_PROFILE.GET('JLZZ_COPY_CUS_SUP_NUM',l_cus_sup_num);

2021: END IF; -- End IF p_country_code = 'AR'
2022:
2023:
2024: IF p_country_code IN ('CL','CO') THEN
2025: FND_PROFILE.GET('JLZZ_COPY_CUS_SUP_NUM',l_cus_sup_num);
2026: l_cus_sup_num := NVL(l_cus_sup_num,'Y');
2027: IF p_generate_customer_number='N' AND l_cus_sup_num='Y' THEN
2028: l_copy:='Y';
2029: ELSE