DBA Data[Home] [Help]

APPS.AMW_LOAD_KEY_ACC_DATA dependencies on FND_MESSAGE

Line 217: fnd_message.set_name('AMW', 'AMW_WEBADI_VALID_ERROR');

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;

Line 218: fnd_message.set_token('ITEM', 'NATURAL_ACCOUNT_ID');

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;

Line 219: V_ERR_MSG := fnd_message.get;

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*/

Line 251: fnd_message.set_name('AMW', 'AMW_WEBADI_VALID_ERROR');

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;

Line 252: fnd_message.set_token('ITEM', 'NATURAL_ACCOUNT_ID');

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;

Line 253: V_ERR_MSG := fnd_message.get;

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**/

Line 378: v_invalid_requestor_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_UNKNOWN_EMPLOYEE');

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

Line 395: v_no_import_privilege_msg := FND_MESSAGE.GET_STRING('AMW', 'AMW_NO_IMPORT_ACCESS');

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