DBA Data[Home] [Help]

APPS.JG_GLOBE_FLEX_VAL dependencies on FND_PROFILE

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

27: --
28: -- RETURN
29: -- Table index if found, g_table_size if not found.
30: --
31: -- PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
32:
33: FUNCTION find
34: (p_flexfield_and_context IN VARCHAR2) RETURN BINARY_INTEGER IS
35:

Line 1685: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');

1681: PG_DEBUG varchar2(1);
1682:
1683: BEGIN
1684:
1685: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
1686: -- arp_standard.enable_debug;
1687:
1688: -- If there is a performance problem for Customers other than Chile,
1689: -- Colombia and Argentina, the performance can be improved by

Line 1933: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');

1929: l_current_record_status2 VARCHAR2(1);
1930: PG_DEBUG varchar2(1);
1931:
1932: BEGIN
1933: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
1934: l_current_record_status1 :='S';
1935: l_current_record_status2 :='S';
1936:
1937: --arp_standard.enable_debug;

Line 2030: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');

2026: l_errcode varchar2(50) DEFAULT NULL;
2027: PG_DEBUG varchar2(1);
2028:
2029: BEGIN
2030: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
2031:
2032: --
2033: -- Check whether multiple country context exists in a single record.
2034: --

Line 2302: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');

2298: PG_DEBUG varchar2(1);
2299:
2300: BEGIN
2301:
2302: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
2303:
2304: if p_org_id is null then
2305: --l_org_id := to_number(fnd_profile.value ('ORG_ID'));
2306: --

Line 2305: --l_org_id := to_number(fnd_profile.value ('ORG_ID'));

2301:
2302: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
2303:
2304: if p_org_id is null then
2305: --l_org_id := to_number(fnd_profile.value ('ORG_ID'));
2306: --
2307: --Bug 4499004
2308: --
2309: SELECT org_id into l_org_id FROM fnd_concurrent_requests

Line 2414: -- PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');

2410: PG_DEBUG varchar2(1);
2411:
2412: BEGIN
2413: NULL;
2414: -- PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
2415: -- l_debug_loc := 'Insert_Jg_Zz_Invoice_Info';
2416: --
2417: -- -------------------------- DEBUG INFORMATION ------------------------------
2418: -- l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;

Line 2533: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');

2529: l_product_code VARCHAR2(2);
2530: PG_DEBUG varchar2(1);
2531:
2532: BEGIN
2533: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
2534:
2535: l_product_code := fnd_profile.value('JG_PRODUCT_CODE');
2536:
2537: IF l_product_code = 'JL' THEN

Line 2535: l_product_code := fnd_profile.value('JG_PRODUCT_CODE');

2531:
2532: BEGIN
2533: PG_DEBUG := NVL(FND_PROFILE.value('AR_ENABLE_DEBUG_OUTPUT'), 'N');
2534:
2535: l_product_code := fnd_profile.value('JG_PRODUCT_CODE');
2536:
2537: IF l_product_code = 'JL' THEN
2538: --
2539: -- Call jl cover package