eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on GL_CURRENCY_API

Line 449: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Calling GL_CURRENCY_API.is_fixed_rate()'); END IF;

445: -- deafult rate_date
446: p_headers_rec.rate_date(i) := sysdate;
447:
448: l_progress := '110';
449: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Calling GL_CURRENCY_API.is_fixed_rate()'); END IF;
450: -- default rate_type
451: l_is_fixed_rate := 'N';
452: BEGIN
453: l_is_fixed_rate := GL_CURRENCY_API.is_fixed_rate

Line 453: l_is_fixed_rate := GL_CURRENCY_API.is_fixed_rate

449: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Calling GL_CURRENCY_API.is_fixed_rate()'); END IF;
450: -- default rate_type
451: l_is_fixed_rate := 'N';
452: BEGIN
453: l_is_fixed_rate := GL_CURRENCY_API.is_fixed_rate
454: (
455: x_from_currency => p_headers_rec.currency_code(i),
456: x_to_currency => PO_R12_CAT_UPG_PVT.g_sys.currency_code,
457: x_effective_date => p_headers_rec.rate_date(i)

Line 461: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception from GL_CURRENCY_API.is_fixed_rate(): '|| SQLERRM(SQLCODE)); END IF;

457: x_effective_date => p_headers_rec.rate_date(i)
458: );
459: EXCEPTION
460: WHEN OTHERS THEN
461: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception from GL_CURRENCY_API.is_fixed_rate(): '|| SQLERRM(SQLCODE)); END IF;
462: -- Mark this record as errored and continue. Do not raise the exception
463: -- because we want to procss as many records as possible.
464: p_headers_rec.has_errors(i) := 'Y';
465:

Line 475: p_column_value => 'GL_CURRENCY_API.is_fixed_rate',

471: --p_error_message_name => 'PO_CAT_UPG_GL_API1_EXCEPTION',
472: p_error_message_name => 'ICX_CAT_ERR_IN_GL_CURR_API',
473: p_table_name => 'PO_HEADERS_INTERFACE',
474: p_column_name => 'API_NAME',
475: p_column_value => 'GL_CURRENCY_API.is_fixed_rate',
476: p_token1_name => 'API_NAME',
477: p_token1_value => 'GL_CURRENCY_API.is_fixed_rate'
478: );
479: END;

Line 477: p_token1_value => 'GL_CURRENCY_API.is_fixed_rate'

473: p_table_name => 'PO_HEADERS_INTERFACE',
474: p_column_name => 'API_NAME',
475: p_column_value => 'GL_CURRENCY_API.is_fixed_rate',
476: p_token1_name => 'API_NAME',
477: p_token1_value => 'GL_CURRENCY_API.is_fixed_rate'
478: );
479: END;
480:
481: IF (p_headers_rec.has_errors(i) <> 'Y' AND

Line 496: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Calling GL_CURRENCY_API.get_rate()'); END IF;

492: IF (p_headers_rec.has_errors(i) <> 'Y' AND
493: (p_headers_rec.rate(i) IS NULL OR
494: p_headers_rec.rate_type_code(i) = 'EMU FIXED')) THEN
495: l_progress := '130';
496: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Calling GL_CURRENCY_API.get_rate()'); END IF;
497: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_set_of_books_id='||PO_R12_CAT_UPG_PVT.g_sys.sob_id); END IF;
498: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_from_currency='||p_headers_rec.currency_code(i)); END IF;
499: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_conversion_date='||p_headers_rec.rate_date(i)); END IF;
500: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_conversion_type='||p_headers_rec.rate_type_code(i)); END IF;

Line 504: rate := GL_CURRENCY_API.get_rate

500: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'x_conversion_type='||p_headers_rec.rate_type_code(i)); END IF;
501:
502: BEGIN
503: rate := NULL; -- Bug 5461235
504: rate := GL_CURRENCY_API.get_rate
505: (
506: x_set_of_books_id => PO_R12_CAT_UPG_PVT.g_sys.sob_id,
507: x_from_currency => p_headers_rec.currency_code(i),
508: x_conversion_date => p_headers_rec.rate_date(i),

Line 513: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() returned rate='||rate); END IF;

509: x_conversion_type => p_headers_rec.rate_type_code(i)
510: );
511: -- Bug 5461235: Start
512: l_progress := '132';
513: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() returned rate='||rate); END IF;
514:
515: l_progress := '134';
516: IF (rate IS NULL) THEN
517: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() returned rate as NULL, raising NO_RATE exception.'); END IF;

Line 517: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() returned rate as NULL, raising NO_RATE exception.'); END IF;

513: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() returned rate='||rate); END IF;
514:
515: l_progress := '134';
516: IF (rate IS NULL) THEN
517: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() returned rate as NULL, raising NO_RATE exception.'); END IF;
518: RAISE GL_CURRENCY_API.NO_RATE;
519: END IF;
520: -- Bug 5461235: End
521: EXCEPTION

Line 518: RAISE GL_CURRENCY_API.NO_RATE;

514:
515: l_progress := '134';
516: IF (rate IS NULL) THEN
517: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() returned rate as NULL, raising NO_RATE exception.'); END IF;
518: RAISE GL_CURRENCY_API.NO_RATE;
519: END IF;
520: -- Bug 5461235: End
521: EXCEPTION
522: -- Bug 5461235: Start

Line 523: WHEN GL_CURRENCY_API.NO_RATE THEN

519: END IF;
520: -- Bug 5461235: End
521: EXCEPTION
522: -- Bug 5461235: Start
523: WHEN GL_CURRENCY_API.NO_RATE THEN
524: l_progress := '136';
525: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() throws GL_CURRENCY_API.NO_RATE exception'); END IF;
526: p_headers_rec.has_errors(i) := 'Y';
527: -- Add error message into INTERFACE_ERRORS table

Line 525: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() throws GL_CURRENCY_API.NO_RATE exception'); END IF;

521: EXCEPTION
522: -- Bug 5461235: Start
523: WHEN GL_CURRENCY_API.NO_RATE THEN
524: l_progress := '136';
525: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() throws GL_CURRENCY_API.NO_RATE exception'); END IF;
526: p_headers_rec.has_errors(i) := 'Y';
527: -- Add error message into INTERFACE_ERRORS table
528: -- ICX_CAT_RATE_REQD
529: -- "There is no rate for the rate date and type default combination."

Line 537: p_token1_value => 'GL_CURRENCY_API.get_rate'

533: p_table_name => 'PO_HEADERS_INTERFACE',
534: p_column_name => 'CURRENCY_CODE',
535: p_column_value => p_headers_rec.currency_code(i),
536: p_token1_name => 'API_NAME',
537: p_token1_value => 'GL_CURRENCY_API.get_rate'
538: );
539: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
540: l_progress := '138';
541: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() throws GL_CURRENCY_API.INVALID_CURRENCY exception'); END IF;

Line 539: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

535: p_column_value => p_headers_rec.currency_code(i),
536: p_token1_name => 'API_NAME',
537: p_token1_value => 'GL_CURRENCY_API.get_rate'
538: );
539: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
540: l_progress := '138';
541: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() throws GL_CURRENCY_API.INVALID_CURRENCY exception'); END IF;
542: p_headers_rec.has_errors(i) := 'Y';
543: -- Add error message into INTERFACE_ERRORS table

Line 541: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() throws GL_CURRENCY_API.INVALID_CURRENCY exception'); END IF;

537: p_token1_value => 'GL_CURRENCY_API.get_rate'
538: );
539: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
540: l_progress := '138';
541: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'GL_CURRENCY_API.get_rate() throws GL_CURRENCY_API.INVALID_CURRENCY exception'); END IF;
542: p_headers_rec.has_errors(i) := 'Y';
543: -- Add error message into INTERFACE_ERRORS table
544: -- ICX_CAT_INVALID_CURRENCY
545: -- "Default currency code is inactive or invalid."

Line 553: p_token1_value => 'GL_CURRENCY_API.get_rate'

549: p_table_name => 'PO_HEADERS_INTERFACE',
550: p_column_name => 'CURRENCY_CODE',
551: p_column_value => p_headers_rec.currency_code(i),
552: p_token1_name => 'API_NAME',
553: p_token1_value => 'GL_CURRENCY_API.get_rate'
554: );
555: -- Bug 5461235: End
556: WHEN OTHERS THEN
557: l_progress := '139';

Line 558: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception from GL_CURRENCY_API.get_rate(): '|| SQLERRM(SQLCODE)); END IF;

554: );
555: -- Bug 5461235: End
556: WHEN OTHERS THEN
557: l_progress := '139';
558: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Unexpected exception from GL_CURRENCY_API.get_rate(): '|| SQLERRM(SQLCODE)); END IF;
559: -- Mark this record as errored and continue. Do not raise the exception
560: -- because we want to procss as many records as possible.
561: p_headers_rec.has_errors(i) := 'Y';
562:

Line 572: p_column_value => 'GL_CURRENCY_API.get_rate',

568: --p_error_message_name => 'PO_CAT_UPG_GL_API2_EXCEPTION',
569: p_error_message_name => 'ICX_CAT_ERR_IN_GL_CURR_API',
570: p_table_name => 'PO_HEADERS_INTERFACE',
571: p_column_name => 'API_NAME',
572: p_column_value => 'GL_CURRENCY_API.get_rate',
573: p_token1_name => 'API_NAME',
574: p_token1_value => 'GL_CURRENCY_API.get_rate'
575: );
576: END; -- Exception block around GL_CURRENCY_API.get_rate API

Line 574: p_token1_value => 'GL_CURRENCY_API.get_rate'

570: p_table_name => 'PO_HEADERS_INTERFACE',
571: p_column_name => 'API_NAME',
572: p_column_value => 'GL_CURRENCY_API.get_rate',
573: p_token1_name => 'API_NAME',
574: p_token1_value => 'GL_CURRENCY_API.get_rate'
575: );
576: END; -- Exception block around GL_CURRENCY_API.get_rate API
577:
578: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Return Value, rate='||rate); END IF;

Line 576: END; -- Exception block around GL_CURRENCY_API.get_rate API

572: p_column_value => 'GL_CURRENCY_API.get_rate',
573: p_token1_name => 'API_NAME',
574: p_token1_value => 'GL_CURRENCY_API.get_rate'
575: );
576: END; -- Exception block around GL_CURRENCY_API.get_rate API
577:
578: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Return Value, rate='||rate); END IF;
579:
580: l_progress := '140';