213: from amw_fin_key_accounts_vl afkav
214: where afkav.natural_account_id=kacc_rec.natural_account_id
215: and afkav.end_date is null);
216: if(l_prb_counts > 1) then
217: fnd_message.set_name('AMW', 'AMW_WEBADI_VALID_ERROR');
218: fnd_message.set_token('ITEM', 'NATURAL_ACCOUNT_ID');
219: V_ERR_MSG := fnd_message.get;
220: UPDATE_INTERFACE_WITH_ERROR(V_ERR_MSG,V_TABLE_NAME,v_interface_id);
221: end if;
214: where afkav.natural_account_id=kacc_rec.natural_account_id
215: and afkav.end_date is null);
216: if(l_prb_counts > 1) then
217: fnd_message.set_name('AMW', 'AMW_WEBADI_VALID_ERROR');
218: fnd_message.set_token('ITEM', 'NATURAL_ACCOUNT_ID');
219: V_ERR_MSG := fnd_message.get;
220: UPDATE_INTERFACE_WITH_ERROR(V_ERR_MSG,V_TABLE_NAME,v_interface_id);
221: end if;
222: end if;
215: and afkav.end_date is null);
216: if(l_prb_counts > 1) then
217: fnd_message.set_name('AMW', 'AMW_WEBADI_VALID_ERROR');
218: fnd_message.set_token('ITEM', 'NATURAL_ACCOUNT_ID');
219: V_ERR_MSG := fnd_message.get;
220: UPDATE_INTERFACE_WITH_ERROR(V_ERR_MSG,V_TABLE_NAME,v_interface_id);
221: end if;
222: end if;
223: /*04.12.2007 npanandi: ends fix for NULL columns*/
247: and natural_account_value=l_natural_account_value
248: and end_date is null);
249: exception
250: when others then
251: fnd_message.set_name('AMW', 'AMW_WEBADI_VALID_ERROR');
252: fnd_message.set_token('ITEM', 'NATURAL_ACCOUNT_ID');
253: V_ERR_MSG := fnd_message.get;
254: UPDATE_INTERFACE_WITH_ERROR(V_ERR_MSG,V_TABLE_NAME,v_interface_id);
255: end;
248: and end_date is null);
249: exception
250: when others then
251: fnd_message.set_name('AMW', 'AMW_WEBADI_VALID_ERROR');
252: fnd_message.set_token('ITEM', 'NATURAL_ACCOUNT_ID');
253: V_ERR_MSG := fnd_message.get;
254: UPDATE_INTERFACE_WITH_ERROR(V_ERR_MSG,V_TABLE_NAME,v_interface_id);
255: end;
256: end if;
249: exception
250: when others then
251: fnd_message.set_name('AMW', 'AMW_WEBADI_VALID_ERROR');
252: fnd_message.set_token('ITEM', 'NATURAL_ACCOUNT_ID');
253: V_ERR_MSG := fnd_message.get;
254: UPDATE_INTERFACE_WITH_ERROR(V_ERR_MSG,V_TABLE_NAME,v_interface_id);
255: end;
256: end if;
257: /**03.01.2007 npanandi: bug 5457611 fix ends**/
374: , 'Invalid requestor id.');
375:
376: BEGIN
377: IF v_invalid_requestor_msg is null THEN
378: v_invalid_requestor_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_UNKNOWN_EMPLOYEE');
379: END IF;
380: UPDATE amw_key_acc_interface
381: SET error_flag = 'Y'
382: ,interface_status = v_invalid_requestor_msg
391: , 'no import privilege');
392:
393: BEGIN
394: IF v_no_import_privilege_msg is null THEN
395: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');
396: END IF;
397: UPDATE amw_key_acc_interface
398: SET error_flag = 'Y'
399: ,interface_status = v_no_import_privilege_msg