98: -- CHECKING PROPER COMBO FOR DS BALANCE TYPE CODE, BUDGET CODE AND INCUMBRANCE TYPE-------------
99:
100:
101: if((l_ds_balance_type_code = 'ACTUAL') AND (P_BUDGET_DISPLAY_CODE is not null OR P_ENCUMBRANCE_TYPE_CODE is not null)) then
102: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DS_ERROR');
103: APP_EXCEPTION.Raise_Exception ;
104: end if;
105: if ((l_ds_balance_type_code = 'BUDGET') AND (P_BUDGET_DISPLAY_CODE is null OR P_ENCUMBRANCE_TYPE_CODE is not null)) then
106: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DS_ERROR');
102: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DS_ERROR');
103: APP_EXCEPTION.Raise_Exception ;
104: end if;
105: if ((l_ds_balance_type_code = 'BUDGET') AND (P_BUDGET_DISPLAY_CODE is null OR P_ENCUMBRANCE_TYPE_CODE is not null)) then
106: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DS_ERROR');
107: APP_EXCEPTION.Raise_Exception ;
108: end if;
109: if ((l_ds_balance_type_code = 'ENCUMBRANCE') AND (P_BUDGET_DISPLAY_CODE is not null OR P_ENCUMBRANCE_TYPE_CODE is null)) then
110: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DS_ERROR');
106: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DS_ERROR');
107: APP_EXCEPTION.Raise_Exception ;
108: end if;
109: if ((l_ds_balance_type_code = 'ENCUMBRANCE') AND (P_BUDGET_DISPLAY_CODE is not null OR P_ENCUMBRANCE_TYPE_CODE is null)) then
110: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DS_ERROR');
111: APP_EXCEPTION.Raise_Exception ;
112: end if;
113:
114: ----------------- Finding load method code --------------------------
231:
232: EXCEPTION
233: --
234: WHEN DUP_VAL_ON_INDEX THEN
235: FND_MESSAGE.SET_NAME('FEM','FEM_ADI_DUPLICATE_ROWS');
236: APP_EXCEPTION.Raise_Exception ;
237:
238: END UPLOAD_FEM_BALANCES_INTERFACE;
239:
318: else
319: x_error_flag := 'N';
320: end if;
321:
322: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV_REQ');
323: l_lov_req_field := FND_MESSAGE.GET;
324: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV');
325: l_lov_field := FND_MESSAGE.GET;
326: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT_REQ');
319: x_error_flag := 'N';
320: end if;
321:
322: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV_REQ');
323: l_lov_req_field := FND_MESSAGE.GET;
324: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV');
325: l_lov_field := FND_MESSAGE.GET;
326: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT_REQ');
327: l_varchar_req_field := FND_MESSAGE.GET;
320: end if;
321:
322: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV_REQ');
323: l_lov_req_field := FND_MESSAGE.GET;
324: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV');
325: l_lov_field := FND_MESSAGE.GET;
326: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT_REQ');
327: l_varchar_req_field := FND_MESSAGE.GET;
328: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT');
321:
322: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV_REQ');
323: l_lov_req_field := FND_MESSAGE.GET;
324: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV');
325: l_lov_field := FND_MESSAGE.GET;
326: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT_REQ');
327: l_varchar_req_field := FND_MESSAGE.GET;
328: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT');
329: l_varchar_field := FND_MESSAGE.GET;
322: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV_REQ');
323: l_lov_req_field := FND_MESSAGE.GET;
324: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV');
325: l_lov_field := FND_MESSAGE.GET;
326: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT_REQ');
327: l_varchar_req_field := FND_MESSAGE.GET;
328: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT');
329: l_varchar_field := FND_MESSAGE.GET;
330: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER_REQ');
323: l_lov_req_field := FND_MESSAGE.GET;
324: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV');
325: l_lov_field := FND_MESSAGE.GET;
326: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT_REQ');
327: l_varchar_req_field := FND_MESSAGE.GET;
328: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT');
329: l_varchar_field := FND_MESSAGE.GET;
330: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER_REQ');
331: l_number_req_field := FND_MESSAGE.GET;
324: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_LOV');
325: l_lov_field := FND_MESSAGE.GET;
326: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT_REQ');
327: l_varchar_req_field := FND_MESSAGE.GET;
328: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT');
329: l_varchar_field := FND_MESSAGE.GET;
330: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER_REQ');
331: l_number_req_field := FND_MESSAGE.GET;
332: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER');
325: l_lov_field := FND_MESSAGE.GET;
326: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT_REQ');
327: l_varchar_req_field := FND_MESSAGE.GET;
328: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT');
329: l_varchar_field := FND_MESSAGE.GET;
330: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER_REQ');
331: l_number_req_field := FND_MESSAGE.GET;
332: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER');
333: l_number_field := FND_MESSAGE.GET;
326: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT_REQ');
327: l_varchar_req_field := FND_MESSAGE.GET;
328: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT');
329: l_varchar_field := FND_MESSAGE.GET;
330: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER_REQ');
331: l_number_req_field := FND_MESSAGE.GET;
332: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER');
333: l_number_field := FND_MESSAGE.GET;
334: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE_REQ');
327: l_varchar_req_field := FND_MESSAGE.GET;
328: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT');
329: l_varchar_field := FND_MESSAGE.GET;
330: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER_REQ');
331: l_number_req_field := FND_MESSAGE.GET;
332: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER');
333: l_number_field := FND_MESSAGE.GET;
334: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE_REQ');
335: l_date_req_field := FND_MESSAGE.GET;
328: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_TEXT');
329: l_varchar_field := FND_MESSAGE.GET;
330: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER_REQ');
331: l_number_req_field := FND_MESSAGE.GET;
332: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER');
333: l_number_field := FND_MESSAGE.GET;
334: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE_REQ');
335: l_date_req_field := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE');
329: l_varchar_field := FND_MESSAGE.GET;
330: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER_REQ');
331: l_number_req_field := FND_MESSAGE.GET;
332: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER');
333: l_number_field := FND_MESSAGE.GET;
334: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE_REQ');
335: l_date_req_field := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE');
337: l_date_field := FND_MESSAGE.GET;
330: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER_REQ');
331: l_number_req_field := FND_MESSAGE.GET;
332: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER');
333: l_number_field := FND_MESSAGE.GET;
334: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE_REQ');
335: l_date_req_field := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE');
337: l_date_field := FND_MESSAGE.GET;
338:
331: l_number_req_field := FND_MESSAGE.GET;
332: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER');
333: l_number_field := FND_MESSAGE.GET;
334: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE_REQ');
335: l_date_req_field := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE');
337: l_date_field := FND_MESSAGE.GET;
338:
339: --------------------------- Initially setting interface columns ----------------------------------
332: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_NUMBER');
333: l_number_field := FND_MESSAGE.GET;
334: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE_REQ');
335: l_date_req_field := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE');
337: l_date_field := FND_MESSAGE.GET;
338:
339: --------------------------- Initially setting interface columns ----------------------------------
340: for interface_cols in
333: l_number_field := FND_MESSAGE.GET;
334: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE_REQ');
335: l_date_req_field := FND_MESSAGE.GET;
336: FND_MESSAGE.SET_NAME ('FEM', 'FEM_ADI_USER_HINT_DATE');
337: l_date_field := FND_MESSAGE.GET;
338:
339: --------------------------- Initially setting interface columns ----------------------------------
340: for interface_cols in
341: (select table_name,column_name,data_type,nullable from dba_tab_columns