DBA Data[Home] [Help]

APPS.GL_MC_CURRENCY_PKG dependencies on FND_MESSAGE

Line 294: fnd_message.set_name('SQLGL', 'MRC_RSOB_NOT_FOUND');

290: IF p_application_id <> 101 AND p_result_code <> 'HEADER VALID ' -- NOT GL
291: THEN
292: IF p_result_code = 'RSOB NOT FOUND'
293: THEN
294: fnd_message.set_name('SQLGL', 'MRC_RSOB_NOT_FOUND');
295: fnd_message.set_token('RSOB', p_reporting_set_of_books_id);
296: ELSIF p_result_code = 'NO CONVERSION'
297: THEN
298: fnd_message.set_name('SQLGL', 'MRC_CONVERSION_RULE_NOT_FOUND');

Line 295: fnd_message.set_token('RSOB', p_reporting_set_of_books_id);

291: THEN
292: IF p_result_code = 'RSOB NOT FOUND'
293: THEN
294: fnd_message.set_name('SQLGL', 'MRC_RSOB_NOT_FOUND');
295: fnd_message.set_token('RSOB', p_reporting_set_of_books_id);
296: ELSIF p_result_code = 'NO CONVERSION'
297: THEN
298: fnd_message.set_name('SQLGL', 'MRC_CONVERSION_RULE_NOT_FOUND');
299: ELSIF p_result_code = 'IMPROPER RELATION'

Line 298: fnd_message.set_name('SQLGL', 'MRC_CONVERSION_RULE_NOT_FOUND');

294: fnd_message.set_name('SQLGL', 'MRC_RSOB_NOT_FOUND');
295: fnd_message.set_token('RSOB', p_reporting_set_of_books_id);
296: ELSIF p_result_code = 'NO CONVERSION'
297: THEN
298: fnd_message.set_name('SQLGL', 'MRC_CONVERSION_RULE_NOT_FOUND');
299: ELSIF p_result_code = 'IMPROPER RELATION'
300: THEN
301: fnd_message.set_name('SQLGL', 'MRC_NO_RELATIONSHIP_FOUND');
302: fnd_message.set_token('TCURR', p_trans_currency_code);

Line 301: fnd_message.set_name('SQLGL', 'MRC_NO_RELATIONSHIP_FOUND');

297: THEN
298: fnd_message.set_name('SQLGL', 'MRC_CONVERSION_RULE_NOT_FOUND');
299: ELSIF p_result_code = 'IMPROPER RELATION'
300: THEN
301: fnd_message.set_name('SQLGL', 'MRC_NO_RELATIONSHIP_FOUND');
302: fnd_message.set_token('TCURR', p_trans_currency_code);
303: fnd_message.set_token('RCURR', l_trans_currency_code);
304: ELSE
305: IF p_trans_conversion_type = 'User' THEN

Line 302: fnd_message.set_token('TCURR', p_trans_currency_code);

298: fnd_message.set_name('SQLGL', 'MRC_CONVERSION_RULE_NOT_FOUND');
299: ELSIF p_result_code = 'IMPROPER RELATION'
300: THEN
301: fnd_message.set_name('SQLGL', 'MRC_NO_RELATIONSHIP_FOUND');
302: fnd_message.set_token('TCURR', p_trans_currency_code);
303: fnd_message.set_token('RCURR', l_trans_currency_code);
304: ELSE
305: IF p_trans_conversion_type = 'User' THEN
306: p_trans_conversion_type := l_tmp_conversion_type;

Line 303: fnd_message.set_token('RCURR', l_trans_currency_code);

299: ELSIF p_result_code = 'IMPROPER RELATION'
300: THEN
301: fnd_message.set_name('SQLGL', 'MRC_NO_RELATIONSHIP_FOUND');
302: fnd_message.set_token('TCURR', p_trans_currency_code);
303: fnd_message.set_token('RCURR', l_trans_currency_code);
304: ELSE
305: IF p_trans_conversion_type = 'User' THEN
306: p_trans_conversion_type := l_tmp_conversion_type;
307: END IF;

Line 319: fnd_message.set_name('SQLGL', 'MRC_RATE_NOT_FOUND');

315: WHEN OTHERS THEN
316: l_user_conversion_type := p_trans_conversion_type;
317: END;
318:
319: fnd_message.set_name('SQLGL', 'MRC_RATE_NOT_FOUND');
320: fnd_message.set_token('FROM', l_trans_currency_code);
321: fnd_message.set_token('TO', l_target_curr);
322: -- 11/23/03 Updated by LPOON: Changed to display 4-digit year
323: fnd_message.set_token('TRANS_DATE', TO_CHAR(p_trans_conversion_date,

Line 320: fnd_message.set_token('FROM', l_trans_currency_code);

316: l_user_conversion_type := p_trans_conversion_type;
317: END;
318:
319: fnd_message.set_name('SQLGL', 'MRC_RATE_NOT_FOUND');
320: fnd_message.set_token('FROM', l_trans_currency_code);
321: fnd_message.set_token('TO', l_target_curr);
322: -- 11/23/03 Updated by LPOON: Changed to display 4-digit year
323: fnd_message.set_token('TRANS_DATE', TO_CHAR(p_trans_conversion_date,
324: 'DD-MON-YYYY'));

Line 321: fnd_message.set_token('TO', l_target_curr);

317: END;
318:
319: fnd_message.set_name('SQLGL', 'MRC_RATE_NOT_FOUND');
320: fnd_message.set_token('FROM', l_trans_currency_code);
321: fnd_message.set_token('TO', l_target_curr);
322: -- 11/23/03 Updated by LPOON: Changed to display 4-digit year
323: fnd_message.set_token('TRANS_DATE', TO_CHAR(p_trans_conversion_date,
324: 'DD-MON-YYYY'));
325: fnd_message.set_token('TYPE', l_user_conversion_type);

Line 323: fnd_message.set_token('TRANS_DATE', TO_CHAR(p_trans_conversion_date,

319: fnd_message.set_name('SQLGL', 'MRC_RATE_NOT_FOUND');
320: fnd_message.set_token('FROM', l_trans_currency_code);
321: fnd_message.set_token('TO', l_target_curr);
322: -- 11/23/03 Updated by LPOON: Changed to display 4-digit year
323: fnd_message.set_token('TRANS_DATE', TO_CHAR(p_trans_conversion_date,
324: 'DD-MON-YYYY'));
325: fnd_message.set_token('TYPE', l_user_conversion_type);
326: END IF; -- IF p_result_code = 'RSOB NOT FOUND'
327:

Line 325: fnd_message.set_token('TYPE', l_user_conversion_type);

321: fnd_message.set_token('TO', l_target_curr);
322: -- 11/23/03 Updated by LPOON: Changed to display 4-digit year
323: fnd_message.set_token('TRANS_DATE', TO_CHAR(p_trans_conversion_date,
324: 'DD-MON-YYYY'));
325: fnd_message.set_token('TYPE', l_user_conversion_type);
326: END IF; -- IF p_result_code = 'RSOB NOT FOUND'
327:
328: fnd_message.set_token('MODULE','GLMCCURB');
329: app_exception.raise_exception;

Line 328: fnd_message.set_token('MODULE','GLMCCURB');

324: 'DD-MON-YYYY'));
325: fnd_message.set_token('TYPE', l_user_conversion_type);
326: END IF; -- IF p_result_code = 'RSOB NOT FOUND'
327:
328: fnd_message.set_token('MODULE','GLMCCURB');
329: app_exception.raise_exception;
330: END IF; -- IF p_application_id <> 101 AND ...
331: EXCEPTION
332: WHEN OTHERS THEN

Line 399: fnd_message.set_name('SQLGL', 'MRC_DOCUMENT_NOT_FOUND');

395: FROM fnd_currencies
396: WHERE currency_code = p_currency_code;
397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: fnd_message.set_name('SQLGL', 'MRC_DOCUMENT_NOT_FOUND');
400: fnd_message.set_token('MODULE','GLMCCURB');
401: fnd_message.set_token('CURRENCY', p_currency_code);
402: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
403: WHEN OTHERS THEN

Line 400: fnd_message.set_token('MODULE','GLMCCURB');

396: WHERE currency_code = p_currency_code;
397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: fnd_message.set_name('SQLGL', 'MRC_DOCUMENT_NOT_FOUND');
400: fnd_message.set_token('MODULE','GLMCCURB');
401: fnd_message.set_token('CURRENCY', p_currency_code);
402: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');

Line 401: fnd_message.set_token('CURRENCY', p_currency_code);

397: EXCEPTION
398: WHEN NO_DATA_FOUND THEN
399: fnd_message.set_name('SQLGL', 'MRC_DOCUMENT_NOT_FOUND');
400: fnd_message.set_token('MODULE','GLMCCURB');
401: fnd_message.set_token('CURRENCY', p_currency_code);
402: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');
405: fnd_message.set_token('MODULE','GLMCCURB');

Line 402: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);

398: WHEN NO_DATA_FOUND THEN
399: fnd_message.set_name('SQLGL', 'MRC_DOCUMENT_NOT_FOUND');
400: fnd_message.set_token('MODULE','GLMCCURB');
401: fnd_message.set_token('CURRENCY', p_currency_code);
402: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');
405: fnd_message.set_token('MODULE','GLMCCURB');
406: fnd_message.set_token('TABLE','FND_CURRENCIES');

Line 404: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');

400: fnd_message.set_token('MODULE','GLMCCURB');
401: fnd_message.set_token('CURRENCY', p_currency_code);
402: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');
405: fnd_message.set_token('MODULE','GLMCCURB');
406: fnd_message.set_token('TABLE','FND_CURRENCIES');
407: RAISE_APPLICATION_ERROR(-20020, fnd_message.get);
408: END;

Line 405: fnd_message.set_token('MODULE','GLMCCURB');

401: fnd_message.set_token('CURRENCY', p_currency_code);
402: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');
405: fnd_message.set_token('MODULE','GLMCCURB');
406: fnd_message.set_token('TABLE','FND_CURRENCIES');
407: RAISE_APPLICATION_ERROR(-20020, fnd_message.get);
408: END;
409: Precision(i) := l_Precision;

Line 406: fnd_message.set_token('TABLE','FND_CURRENCIES');

402: RAISE_APPLICATION_ERROR(-20010, fnd_message.get);
403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');
405: fnd_message.set_token('MODULE','GLMCCURB');
406: fnd_message.set_token('TABLE','FND_CURRENCIES');
407: RAISE_APPLICATION_ERROR(-20020, fnd_message.get);
408: END;
409: Precision(i) := l_Precision;
410: Mau(i) := l_Mau;

Line 407: RAISE_APPLICATION_ERROR(-20020, fnd_message.get);

403: WHEN OTHERS THEN
404: fnd_message.set_name('SQLGL','MRC_TABLE_ERROR');
405: fnd_message.set_token('MODULE','GLMCCURB');
406: fnd_message.set_token('TABLE','FND_CURRENCIES');
407: RAISE_APPLICATION_ERROR(-20020, fnd_message.get);
408: END;
409: Precision(i) := l_Precision;
410: Mau(i) := l_Mau;
411: END;