DBA Data[Home] [Help]

APPS.GL_MC_CURRENCY_PKG dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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