937: END IF;
938:
939: --Bug 6956226. Modified below statement to assign 'Yes' if this profile
940: --has defined no value.
941: g_allow_pa_override := NVL(FND_PROFILE.VALUE('PA_ALLOW_FLEXBUILDER_OVERRIDES'),'Y');
942:
943: -- Bug 5294998. API from PA will be used
944: -- g_pa_expenditure_date_default := FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT');
945:
940: --has defined no value.
941: g_allow_pa_override := NVL(FND_PROFILE.VALUE('PA_ALLOW_FLEXBUILDER_OVERRIDES'),'Y');
942:
943: -- Bug 5294998. API from PA will be used
944: -- g_pa_expenditure_date_default := FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT');
945:
946: g_user_id := FND_PROFILE.VALUE('USER_ID');
947:
948: g_login_id := FND_PROFILE.VALUE('LOGIN_ID');
942:
943: -- Bug 5294998. API from PA will be used
944: -- g_pa_expenditure_date_default := FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT');
945:
946: g_user_id := FND_PROFILE.VALUE('USER_ID');
947:
948: g_login_id := FND_PROFILE.VALUE('LOGIN_ID');
949:
950: EXCEPTION
944: -- g_pa_expenditure_date_default := FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT');
945:
946: g_user_id := FND_PROFILE.VALUE('USER_ID');
947:
948: g_login_id := FND_PROFILE.VALUE('LOGIN_ID');
949:
950: EXCEPTION
951: WHEN OTHERS THEN
952: IF (SQLCODE <> -20001) THEN
2550:
2551: l_debug_info := 'Insert Invoice Distributions';
2552: -- Bug 6837035 Retrieve the profile value to check if the DFF info should be
2553: -- copied onto distributions for imported lines.
2554: l_copy_line_dff_flag := NVL(fnd_profile.value('AP_COPY_INV_LINE_DFF'),'N');
2555:
2556: FOR i in nvl(X_Dist_tab.FIRST, 0) .. nvl(X_Dist_tab.LAST, 0) LOOP
2557:
2558: IF (x_dist_tab.exists(i)) THEN