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');
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'
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);
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
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;
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;
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,
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'));
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);
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:
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;
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
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
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');
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');
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');
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;
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;
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;
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;