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.

[Home] [Help]

APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on GL_LEDGER_RELATIONSHIPS

Line 294: FROM gl_ledger_relationships

290: IF l_ledger_category_code = 'ALC' THEN
291:
292: SELECT alc_init_conv_option_code, alc_initializing_rate_type, alc_initializing_rate_date
293: INTO l_conversion_option, l_currency_conversion_type, l_currency_conversion_date
294: FROM gl_ledger_relationships
295: WHERE relationship_id = l_relationship_id;
296:
297: IF ( (l_conversion_option IS NULL) OR (l_currency_conversion_type IS NULL) OR (l_currency_conversion_date IS NULL) ) THEN
298: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 300: (p_msg => 'Error: gl_ledger_relationships returned a blank value for either l_conversion_option, l_currency_conversion_type, or l_currency_conversion_date for ALC ledger'

296:
297: IF ( (l_conversion_option IS NULL) OR (l_currency_conversion_type IS NULL) OR (l_currency_conversion_date IS NULL) ) THEN
298: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
299: trace
300: (p_msg => 'Error: gl_ledger_relationships returned a blank value for either l_conversion_option, l_currency_conversion_type, or l_currency_conversion_date for ALC ledger'
301: ,p_level => C_LEVEL_PROCEDURE
302: ,p_module => l_log_module);
303: END IF;
304: fnd_message.set_name('XLA','XLA_UPG_GL_LEDG_NULL');

Line 473: UPDATE gl_ledger_relationships

469:
470: p_retcode := 0;
471: p_errbuf := 'Upgrade Completed Successfully';
472:
473: UPDATE gl_ledger_relationships
474: SET hist_conv_status_code = 'SUCCESSFUL'
475: WHERE relationship_id = l_relationship_id;
476:
477:

Line 480: (p_msg => 'Upgrade Successfully Completed. Rows Updated in gl_ledger_relationships = ' || SQL%ROWCOUNT

476:
477:
478: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
479: trace
480: (p_msg => 'Upgrade Successfully Completed. Rows Updated in gl_ledger_relationships = ' || SQL%ROWCOUNT
481: ,p_level => C_LEVEL_PROCEDURE
482: ,p_module => l_log_module);
483:
484: END IF;

Line 617: UPDATE gl_ledger_relationships

613: END IF;
614:
615:
616:
617: UPDATE gl_ledger_relationships
618: SET hist_conv_status_code = 'FAILED'
619: WHERE relationship_id = l_relationship_id;
620:
621: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 623: (p_msg => 'Ledger id stamped as failed. Rows updated in gl_ledger_relationships = ' || SQL%ROWCOUNT

619: WHERE relationship_id = l_relationship_id;
620:
621: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
622: trace
623: (p_msg => 'Ledger id stamped as failed. Rows updated in gl_ledger_relationships = ' || SQL%ROWCOUNT
624: ,p_level => C_LEVEL_PROCEDURE
625: ,p_module => l_log_module);
626: END IF;
627:

Line 788: FROM gl_ledger_relationships

784: SELECT 1
785: INTO l_relationship_exists
786: FROM DUAL
787: WHERE EXISTS (SELECT 1
788: FROM gl_ledger_relationships
789: WHERE primary_ledger_id = l_primary_ledger_id
790: AND target_ledger_id = l_secondary_alc_ledger_id
791: AND relationship_enabled_flag = 'Y');
792:

Line 795: FROM gl_ledger_relationships

791: AND relationship_enabled_flag = 'Y');
792:
793: SELECT min(relationship_id)
794: INTO l_relationship_id
795: FROM gl_ledger_relationships
796: WHERE primary_ledger_id = l_primary_ledger_id
797: AND target_ledger_id = l_secondary_alc_ledger_id
798: AND relationship_enabled_flag = 'Y';
799:

Line 839: FROM gl_ledger_relationships

835: IF l_validation_mode = 'F' THEN --if running in validation mode, not concerned with last run
836:
837: SELECT hist_conv_status_code
838: INTO l_previous_status
839: FROM gl_ledger_relationships
840: WHERE relationship_id = l_relationship_id;
841:
842: IF l_previous_status = 'SUCCESSFUL' OR l_previous_status = 'RUNNING' THEN
843: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 857: UPDATE gl_ledger_relationships

853:
854: l_upgrade_status := -1;
855: RETURN;
856: ELSE
857: UPDATE gl_ledger_relationships
858: SET hist_conv_status_code = 'RUNNING'
859: WHERE relationship_id = l_relationship_id;
860:
861:

Line 864: (p_msg => 'Conversion status set to RUNNING, row updated in gl_ledger_relationships = ' || SQL%ROWCOUNT

860:
861:
862: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
863: trace
864: (p_msg => 'Conversion status set to RUNNING, row updated in gl_ledger_relationships = ' || SQL%ROWCOUNT
865: ,p_level => C_LEVEL_PROCEDURE
866: ,p_module => l_log_module);
867: END IF;
868:

Line 3830: FROM gl_ledger_relationships

3826: SELECT 1
3827: INTO l_relationship_exists
3828: FROM DUAL
3829: WHERE EXISTS (SELECT 1
3830: FROM gl_ledger_relationships
3831: WHERE primary_ledger_id = l_primary_ledger_id
3832: AND target_ledger_id = l_secondary_alc_ledger_id
3833: AND relationship_enabled_flag = 'Y');
3834:

Line 3837: FROM gl_ledger_relationships

3833: AND relationship_enabled_flag = 'Y');
3834:
3835: SELECT min(relationship_id)
3836: INTO l_relationship_id
3837: FROM gl_ledger_relationships
3838: WHERE primary_ledger_id = l_primary_ledger_id
3839: AND target_ledger_id = l_secondary_alc_ledger_id
3840: AND relationship_enabled_flag = 'Y';
3841:

Line 3872: FROM xla_rc_upgrade_rates rc, gl_ledger_relationships gl

3868: BEGIN
3869:
3870: SELECT max(upgrade_run_id)
3871: INTO last_crash_run
3872: FROM xla_rc_upgrade_rates rc, gl_ledger_relationships gl
3873: WHERE gl.relationship_id = rc.relationship_id
3874: AND gl.relationship_id = l_relationship_id
3875: AND rc.relationship_id = l_relationship_id -- redundant
3876: AND gl.hist_conv_status_code = 'RUNNING';