DBA Data[Home] [Help]

APPS.FARX_AL dependencies on FND_PROFILE

Line 157: fnd_profile.get('USER_ID',h_user_id);

153: h_cat_seg_val := cat_seg_val;
154: h_prop_type := prop_type;
155: h_bought := bought;
156:
157: fnd_profile.get('USER_ID',h_user_id);
158: fnd_profile.get ('GL_SET_OF_BKS_ID',l_orig_set_of_books_id);
159: l_orig_currency_context := SUBSTRB(USERENV('CLIENT_INFO'),45,10);
160: -- Set the gl_sob profile to this book
161: fnd_profile.put('GL_SET_OF_BKS_ID', h_sob_id);

Line 158: fnd_profile.get ('GL_SET_OF_BKS_ID',l_orig_set_of_books_id);

154: h_prop_type := prop_type;
155: h_bought := bought;
156:
157: fnd_profile.get('USER_ID',h_user_id);
158: fnd_profile.get ('GL_SET_OF_BKS_ID',l_orig_set_of_books_id);
159: l_orig_currency_context := SUBSTRB(USERENV('CLIENT_INFO'),45,10);
160: -- Set the gl_sob profile to this book
161: fnd_profile.put('GL_SET_OF_BKS_ID', h_sob_id);
162: fnd_client_info.set_currency_context (h_sob_id);

Line 161: fnd_profile.put('GL_SET_OF_BKS_ID', h_sob_id);

157: fnd_profile.get('USER_ID',h_user_id);
158: fnd_profile.get ('GL_SET_OF_BKS_ID',l_orig_set_of_books_id);
159: l_orig_currency_context := SUBSTRB(USERENV('CLIENT_INFO'),45,10);
160: -- Set the gl_sob profile to this book
161: fnd_profile.put('GL_SET_OF_BKS_ID', h_sob_id);
162: fnd_client_info.set_currency_context (h_sob_id);
163: if h_sob_id <> -1999 then
164: begin
165: select 'P'

Line 1033: fnd_profile.put('GL_SET_OF_BKS_ID', l_orig_set_of_books_id);

1029: fa_rx_util_pkg.debug('asset_listing_run: ' || 'END REPORT');
1030: END IF;
1031:
1032: -- reset GL sob id to original value before moving to next book
1033: fnd_profile.put('GL_SET_OF_BKS_ID', l_orig_set_of_books_id);
1034: fnd_client_info.set_currency_context (l_orig_currency_context);
1035: commit;
1036: EXCEPTION
1037: WHEN OTHERS THEN

Line 1039: fnd_profile.put('GL_SET_OF_BKS_ID', l_orig_set_of_books_id);

1035: commit;
1036: EXCEPTION
1037: WHEN OTHERS THEN
1038: -- reset GL sob id to original value before moving to next book
1039: fnd_profile.put('GL_SET_OF_BKS_ID', l_orig_set_of_books_id);
1040: fnd_client_info.set_currency_context (l_orig_currency_context);
1041: fa_rx_conc_mesg_pkg.log(SQLERRM);
1042:
1043: fnd_message.set_name('OFA',h_mesg_name);