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.GL_COA_SEG_VAL_IMP_PKG dependencies on FND_LOG

Line 373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

369: /* Main Flex Values Sub Process */
370: BEGIN
371:
372: v_compiled_value_attribute_s := NULL;
373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
374: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.start_logging_for','Fnd Flex Values');
375: END IF;
376:
377: p_c_rec_status := 'S';

Line 374: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.start_logging_for','Fnd Flex Values');

370: BEGIN
371:
372: v_compiled_value_attribute_s := NULL;
373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
374: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.start_logging_for','Fnd Flex Values');
375: END IF;
376:
377: p_c_rec_status := 'S';
378: FOR I in 1..p_gl_flex_values_tbl.LAST LOOP

Line 398: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

394: IF p_validation_level = FND_API.g_valid_level_full THEN
395: validate_parameters(p_gl_flex_values_tbl(I));
396: END IF;
397:
398: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
399: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Status_after_validate_parameters',
400: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
401: ||p_gl_flex_values_tbl(I).flex_value||' '||'Status:'||p_gl_flex_values_tbl(I).status );
402: END IF;

Line 399: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Status_after_validate_parameters',

395: validate_parameters(p_gl_flex_values_tbl(I));
396: END IF;
397:
398: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
399: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Status_after_validate_parameters',
400: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
401: ||p_gl_flex_values_tbl(I).flex_value||' '||'Status:'||p_gl_flex_values_tbl(I).status );
402: END IF;
403: END IF;

Line 409: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

405: --Find out whether it is insert/update of record
406: l_insert_update:='I';
407: IF p_gl_flex_values_tbl(I).status = 'S' THEN
408: l_insert_update:= check_insert_update(p_gl_flex_values_tbl(I));
409: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
410: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Insert_update',
411: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
412: ||p_gl_flex_values_tbl(I).flex_value||' '||'Insert_update:'||l_insert_update);
413: END IF;

Line 410: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Insert_update',

406: l_insert_update:='I';
407: IF p_gl_flex_values_tbl(I).status = 'S' THEN
408: l_insert_update:= check_insert_update(p_gl_flex_values_tbl(I));
409: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
410: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Insert_update',
411: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
412: ||p_gl_flex_values_tbl(I).flex_value||' '||'Insert_update:'||l_insert_update);
413: END IF;
414: END IF;

Line 419: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

415:
416: --Defaulting depending upon insert or update
417: IF p_gl_flex_values_tbl(I).status = 'S' THEN
418: assign_defaults(p_gl_flex_values_tbl(I),l_insert_update);
419: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
420: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Status_after_assign_defaults',
421: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
422: ||p_gl_flex_values_tbl(I).flex_value||' '||'Status:'||p_gl_flex_values_tbl(I).status );
423: END IF;

Line 420: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Status_after_assign_defaults',

416: --Defaulting depending upon insert or update
417: IF p_gl_flex_values_tbl(I).status = 'S' THEN
418: assign_defaults(p_gl_flex_values_tbl(I),l_insert_update);
419: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
420: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Status_after_assign_defaults',
421: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
422: ||p_gl_flex_values_tbl(I).flex_value||' '||'Status:'||p_gl_flex_values_tbl(I).status );
423: END IF;
424: END IF;

Line 429: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

425:
426: /* Business Validations */
427: IF p_gl_flex_values_tbl(I).status = 'S' THEN
428: validate_flex_values( p_gl_flex_values_tbl(I) );
429: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
430: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Status_after_Business_Val',
431: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
432: ||p_gl_flex_values_tbl(I).flex_value||' '||'Status:'||p_gl_flex_values_tbl(I).status );
433: END IF;

Line 430: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Status_after_Business_Val',

426: /* Business Validations */
427: IF p_gl_flex_values_tbl(I).status = 'S' THEN
428: validate_flex_values( p_gl_flex_values_tbl(I) );
429: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
430: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Status_after_Business_Val',
431: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
432: ||p_gl_flex_values_tbl(I).flex_value||' '||'Status:'||p_gl_flex_values_tbl(I).status );
433: END IF;
434: END IF;

Line 438: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

434: END IF;
435:
436: IF p_gl_flex_values_tbl(I).status = 'S' THEN
437: BEGIN
438: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
439: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Creation_values',
440: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
441: ||p_gl_flex_values_tbl(I).flex_value||' '||'enabled_flag:'||p_gl_flex_values_tbl(I).enabled_flag||' '||'summary_flag:'||
442: p_gl_flex_values_tbl(I).summary_flag||' '||'roll_up_group:'||p_gl_flex_values_tbl(I).roll_up_group

Line 439: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Creation_values',

435:
436: IF p_gl_flex_values_tbl(I).status = 'S' THEN
437: BEGIN
438: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
439: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Creation_values',
440: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
441: ||p_gl_flex_values_tbl(I).flex_value||' '||'enabled_flag:'||p_gl_flex_values_tbl(I).enabled_flag||' '||'summary_flag:'||
442: p_gl_flex_values_tbl(I).summary_flag||' '||'roll_up_group:'||p_gl_flex_values_tbl(I).roll_up_group
443: ||' '||'hierarchy_level:'||p_gl_flex_values_tbl(I).hierarchy_level

Line 595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

591: END IF;
592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
596: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Error_in_flex_API',
597: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
598: ||p_gl_flex_values_tbl(I).flex_value||' '||'Error_Message:'||FND_MESSAGE.GET
599: ||' '||'Unhandled Exception :'||sqlerrm);

Line 596: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Error_in_flex_API',

592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
596: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Error_in_flex_API',
597: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
598: ||p_gl_flex_values_tbl(I).flex_value||' '||'Error_Message:'||FND_MESSAGE.GET
599: ||' '||'Unhandled Exception :'||sqlerrm);
600: END IF;

Line 650: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

646: '', '', '', '', '', '', '', '', '', '',
647: '', '', '', '', '', '', '', '', '', '',
648: '', '', '', '', '', '', '', '', '', '',
649: '', '', '', '', '', '', '', '', '', '');
650: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
651: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Triggered_FDFCHY',
652: 'Value Set id:'||TO_CHAR(flex_vl_set_id_tab(i))||' '||'Request id:'||req_id);
653: END IF;
654: IF (req_id = 0) THEN

Line 651: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Triggered_FDFCHY',

647: '', '', '', '', '', '', '', '', '', '',
648: '', '', '', '', '', '', '', '', '', '',
649: '', '', '', '', '', '', '', '', '', '');
650: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
651: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Triggered_FDFCHY',
652: 'Value Set id:'||TO_CHAR(flex_vl_set_id_tab(i))||' '||'Request id:'||req_id);
653: END IF;
654: IF (req_id = 0) THEN
655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

651: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Triggered_FDFCHY',
652: 'Value Set id:'||TO_CHAR(flex_vl_set_id_tab(i))||' '||'Request id:'||req_id);
653: END IF;
654: IF (req_id = 0) THEN
655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
656: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Error_in_FDFCHY',
657: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
658: ||p_gl_flex_values_tbl(I).flex_value||' '||'Value_set_id:'||TO_CHAR(flex_vl_set_id_tab(i))||' '||'Error_Message:'||
659: FND_MESSAGE.GET);

Line 656: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Error_in_FDFCHY',

652: 'Value Set id:'||TO_CHAR(flex_vl_set_id_tab(i))||' '||'Request id:'||req_id);
653: END IF;
654: IF (req_id = 0) THEN
655: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
656: fnd_log.string( fnd_log.level_statement, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.Error_in_FDFCHY',
657: 'Value Set Name:'||p_gl_flex_values_tbl(I).value_set_name||' '||'Parent Flex Value:'||p_gl_flex_values_tbl(I).parent_flex_value||' '||'Flex Value:'
658: ||p_gl_flex_values_tbl(I).flex_value||' '||'Value_set_id:'||TO_CHAR(flex_vl_set_id_tab(i))||' '||'Error_Message:'||
659: FND_MESSAGE.GET);
660: END IF;

Line 668: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

664: END LOOP;
665:
666: flex_vl_set_id_tab.delete;
667:
668: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
669: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.status_after_import',p_c_rec_status);
670: END IF;
671: END create_gl_coa_flex_values;
672:

Line 669: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.status_after_import',p_c_rec_status);

665:
666: flex_vl_set_id_tab.delete;
667:
668: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
669: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values.status_after_import',p_c_rec_status);
670: END IF;
671: END create_gl_coa_flex_values;
672:
673: PROCEDURE create_gl_coa_flex_values_nh(

Line 835: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

831:
832:
833: /* Main Child ranges Sub Process */
834: BEGIN
835: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
836: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values_nh.start_logging_for','Child ranges');
837: END IF;
838:
839: p_c_rec_status := 'S';

Line 836: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values_nh.start_logging_for','Child ranges');

832:
833: /* Main Child ranges Sub Process */
834: BEGIN
835: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
836: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values_nh.start_logging_for','Child ranges');
837: END IF;
838:
839: p_c_rec_status := 'S';
840: l_nh_exists := NULL;

Line 989: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

985: END LOOP;
986:
987: flex_vl_set_id_tab.delete;
988:
989: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
990: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values_nh.status_after_import',p_c_rec_status);
991: END IF;
992:
993: END create_gl_coa_flex_values_nh;

Line 990: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values_nh.status_after_import',p_c_rec_status);

986:
987: flex_vl_set_id_tab.delete;
988:
989: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
990: fnd_log.string( fnd_log.level_procedure, 'gl.plsql.gl_coa_seg_val_imp_pkg.create_gl_coa_flex_values_nh.status_after_import',p_c_rec_status);
991: END IF;
992:
993: END create_gl_coa_flex_values_nh;
994: