eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on FND_PROFILE

Line 18: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');

14:
15: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_OPEN_INTERFACE_PKG';
16:
17: -- The flag determines whether to print debug information or not.
18: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.VALUE('IGC_DEBUG_ENABLED'),'N');
19: g_high_date DATE := Add_Months(Sysdate, 1200);
20:
21: g_process_phase VARCHAR2(1);
22: g_batch_id NUMBER;

Line 1492: -- l_current_org_id := TO_NUMBER(FND_PROFILE.VALUE('ORG_ID'));

1488: -- 2871052, End
1489:
1490: -- Get the profile values
1491: /* Bug No : 6341012. MOAC uptake. ORG_ID,SOB_ID are retrieved from packages rather than from profiles*/
1492: -- l_current_org_id := TO_NUMBER(FND_PROFILE.VALUE('ORG_ID'));
1493: l_current_org_id := MO_GLOBAL.get_current_org_id;
1494: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1495: l_current_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1496: -- l_current_set_of_books_id := TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID'));

Line 1494: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

1490: -- Get the profile values
1491: /* Bug No : 6341012. MOAC uptake. ORG_ID,SOB_ID are retrieved from packages rather than from profiles*/
1492: -- l_current_org_id := TO_NUMBER(FND_PROFILE.VALUE('ORG_ID'));
1493: l_current_org_id := MO_GLOBAL.get_current_org_id;
1494: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1495: l_current_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1496: -- l_current_set_of_books_id := TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID'));
1497: MO_UTILS.get_ledger_info(l_current_org_id,l_current_set_of_books_id,l_sob_name);
1498:

Line 1495: l_current_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));

1491: /* Bug No : 6341012. MOAC uptake. ORG_ID,SOB_ID are retrieved from packages rather than from profiles*/
1492: -- l_current_org_id := TO_NUMBER(FND_PROFILE.VALUE('ORG_ID'));
1493: l_current_org_id := MO_GLOBAL.get_current_org_id;
1494: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1495: l_current_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1496: -- l_current_set_of_books_id := TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID'));
1497: MO_UTILS.get_ledger_info(l_current_org_id,l_current_set_of_books_id,l_sob_name);
1498:
1499:

Line 1496: -- l_current_set_of_books_id := TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID'));

1492: -- l_current_org_id := TO_NUMBER(FND_PROFILE.VALUE('ORG_ID'));
1493: l_current_org_id := MO_GLOBAL.get_current_org_id;
1494: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
1495: l_current_login_id := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
1496: -- l_current_set_of_books_id := TO_NUMBER(FND_PROFILE.VALUE('GL_SET_OF_BKS_ID'));
1497: MO_UTILS.get_ledger_info(l_current_org_id,l_current_set_of_books_id,l_sob_name);
1498:
1499:
1500: -- Get the Dual Budgetary Control Enable Flag

Line 3157: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))

3153: AND NVL(fu.end_date, sysdate)
3154: AND fu.employee_id IS NOT NULL
3155: AND fu.employee_id = p.person_id
3156: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */
3157: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))
3158: AND p.employee_number is not null
3159: AND trunc(sysdate) between p.effective_start_date and p.effective_end_date
3160: AND a.person_id = p.person_id
3161: AND a.primary_flag = 'Y'

Line 3171: FND_MESSAGE.SET_TOKEN('OWNER_UID', FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP'), TRUE);

3167:
3168: EXCEPTION WHEN NO_DATA_FOUND THEN
3169: l_error_message := NULL;
3170: FND_MESSAGE.SET_NAME('IGC', 'IGC_CC_OWNER_UID_INVALID');
3171: FND_MESSAGE.SET_TOKEN('OWNER_UID', FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP'), TRUE);
3172: /* FND_MESSAGE.SET_TOKEN('OWNER_UID', TO_CHAR(P_Cc_Owner_User_Id), TRUE);*/
3173: l_error_message := FND_MESSAGE.GET;
3174: INTERFACE_HANDLE_ERRORS
3175: ( P_Interface_Header_Id,

Line 3207: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))

3203: AND NVL(fu.end_date, sysdate)
3204: AND fu.employee_id IS NOT NULL
3205: AND fu.employee_id = p.person_id
3206: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */
3207: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))
3208: AND p.employee_number is not null
3209: AND trunc(sysdate) between p.effective_start_date and p.effective_end_date
3210: AND a.person_id = p.person_id
3211: AND a.primary_flag = 'Y'

Line 3347: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))

3343: AND NVL(fu.end_date, sysdate)
3344: AND fu.employee_id IS NOT NULL
3345: AND fu.employee_id = p.person_id
3346: /* AND p.business_group_id = (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp) */
3347: AND p.business_group_id = (Decode (FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP') , 'Y' , p.business_group_id , (select nvl(max(fsp.business_group_id),0) from financials_system_parameters fsp)))
3348: AND p.employee_number is not null
3349: AND trunc(sysdate) between p.effective_start_date and p.effective_end_date
3350: AND a.person_id = p.person_id
3351: AND a.primary_flag = 'Y'