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

Line 92: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

88: l_instance_number varchar2(30);
89: l_instance_id number;
90:
91: l_module varchar2(200) ;
92: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
93: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
94: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 93: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;

89: l_instance_id number;
90:
91: l_module varchar2(200) ;
92: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
93: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
94: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97:

Line 94: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;

90:
91: l_module varchar2(200) ;
92: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
93: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
94: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97:
98:

Line 95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

91: l_module varchar2(200) ;
92: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
93: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
94: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97:
98:
99: attr_import_failed EXCEPTION;

Line 96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

92: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
93: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
94: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
95: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
96: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
97:
98:
99: attr_import_failed EXCEPTION;
100:

Line 183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, '===== Entering EAM_ASSET_ATTR_IMPORT_PVT.import_asset_attr_values =====');

179: end if;
180: -- bug 2834438
181:
182: IF (l_plog) THEN
183: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, '===== Entering EAM_ASSET_ATTR_IMPORT_PVT.import_asset_attr_values =====');
184: END IF;
185:
186: -- Standard Start of API savepoint
187: SAVEPOINT import_asset_attr_values_pvt;

Line 335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'(asset_number_cur)asset.instance_number='||asset.instance_number);

331: FOR asset IN asset_numbers_cur LOOP
332:
333: IF (l_slog) THEN
334: -- bug 2834438
335: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'(asset_number_cur)asset.instance_number='||asset.instance_number);
336: END IF;
337:
338: -- Open loop for all attribute groups for an Asset Number
339: FOR attr_group IN attr_group_cur

Line 344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.application_id=' || attr_group.application_id);

340: LOOP
341:
342: IF (l_slog) THEN
343: -- bug 2834438
344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.application_id=' || attr_group.application_id);
345: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.descriptive_flexfield_name=' ||
346: attr_group.descriptive_flexfield_name);
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.attribute_category=' || attr_group.attribute_category);
348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.association_id=' || attr_group.association_id);

Line 345: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.descriptive_flexfield_name=' ||

341:
342: IF (l_slog) THEN
343: -- bug 2834438
344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.application_id=' || attr_group.application_id);
345: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.descriptive_flexfield_name=' ||
346: attr_group.descriptive_flexfield_name);
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.attribute_category=' || attr_group.attribute_category);
348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.association_id=' || attr_group.association_id);
349:

Line 347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.attribute_category=' || attr_group.attribute_category);

343: -- bug 2834438
344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.application_id=' || attr_group.application_id);
345: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.descriptive_flexfield_name=' ||
346: attr_group.descriptive_flexfield_name);
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.attribute_category=' || attr_group.attribute_category);
348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.association_id=' || attr_group.association_id);
349:
350: END IF;
351:

Line 348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.association_id=' || attr_group.association_id);

344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.application_id=' || attr_group.application_id);
345: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.descriptive_flexfield_name=' ||
346: attr_group.descriptive_flexfield_name);
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.attribute_category=' || attr_group.attribute_category);
348: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_group_cur)attr_group.association_id=' || attr_group.association_id);
349:
350: END IF;
351:
352: l_stmt_generated := 'S';

Line 510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.application_column_name=' || attr.application_column_name);

506: ) LOOP
507:
508: IF (l_slog) THEN
509: -- bug 2834438
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.application_column_name=' || attr.application_column_name);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.line_type=' || attr.line_type);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_varchar2_value=' || attr.attribute_varchar2_value);
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_number_value=' || attr.attribute_number_value);
514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_date_value=' || attr.attribute_date_value);

Line 511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.line_type=' || attr.line_type);

507:
508: IF (l_slog) THEN
509: -- bug 2834438
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.application_column_name=' || attr.application_column_name);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.line_type=' || attr.line_type);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_varchar2_value=' || attr.attribute_varchar2_value);
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_number_value=' || attr.attribute_number_value);
514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_date_value=' || attr.attribute_date_value);
515: END IF;

Line 512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_varchar2_value=' || attr.attribute_varchar2_value);

508: IF (l_slog) THEN
509: -- bug 2834438
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.application_column_name=' || attr.application_column_name);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.line_type=' || attr.line_type);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_varchar2_value=' || attr.attribute_varchar2_value);
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_number_value=' || attr.attribute_number_value);
514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_date_value=' || attr.attribute_date_value);
515: END IF;
516:

Line 513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_number_value=' || attr.attribute_number_value);

509: -- bug 2834438
510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.application_column_name=' || attr.application_column_name);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.line_type=' || attr.line_type);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_varchar2_value=' || attr.attribute_varchar2_value);
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_number_value=' || attr.attribute_number_value);
514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_date_value=' || attr.attribute_date_value);
515: END IF;
516:
517:

Line 514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_date_value=' || attr.attribute_date_value);

510: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.application_column_name=' || attr.application_column_name);
511: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.line_type=' || attr.line_type);
512: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_varchar2_value=' || attr.attribute_varchar2_value);
513: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_number_value=' || attr.attribute_number_value);
514: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, '(attr_cur)attr.attribute_date_value=' || attr.attribute_date_value);
515: END IF;
516:
517:
518: p_substr := substr(attr.application_column_name,-1,1);

Line 529: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'p_num=' || p_num);

525: p_num := to_number(p_substr);
526:
527: IF (l_slog) THEN
528: -- bug 2834438
529: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'p_num=' || p_num);
530: END IF;
531:
532:
533: IF (attr.line_type = 1) THEN

Line 677: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'FETCH failed_meavi_row_cur failed. Raising Exception.');

673: END IF;
674:
675: IF (l_exlog) THEN
676: -- bug 2834438
677: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'FETCH failed_meavi_row_cur failed. Raising Exception.');
678: END IF;
679:
680: RAISE;
681: END;

Line 686: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'l_stmt_generated=' || l_stmt_generated);

682:
683:
684: IF (l_slog) THEN
685: -- bug 2834438
686: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'l_stmt_generated=' || l_stmt_generated);
687: END IF;
688:
689:
690: IF (l_stmt_generated = 'S') THEN

Line 765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'EAM_ASSET_ATTR_PVT.Insert_Row return status=' || l_return_status);

761: );
762:
763: IF (l_slog) THEN
764: -- bug 2834438
765: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'EAM_ASSET_ATTR_PVT.Insert_Row return status=' || l_return_status);
766: END IF;
767:
768:
769:

Line 835: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'EAM_ASSET_ATTR_PVT.Update_Row return status=' || l_return_status);

831: );
832:
833: IF (l_slog) THEN
834: -- bug 2834438
835: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'EAM_ASSET_ATTR_PVT.Update_Row return status=' || l_return_status);
836: END IF;
837:
838:
839: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN

Line 864: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'Insert/Update call to EAM_ASSET_ATTR_PVT failed. Raising exception.');

860: END IF;
861:
862: IF (l_exlog) THEN
863: -- bug 2834438
864: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'Insert/Update call to EAM_ASSET_ATTR_PVT failed. Raising exception.');
865: END IF;
866: Raise;
867:
868: END;

Line 878: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Out of loop for Asset Numbers');

874: END LOOP; -- End Loop for Asset Numbers
875:
876: IF (l_slog) THEN
877: -- bug 2834438
878: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'Out of loop for Asset Numbers');
879: END IF;
880: -- Check if any attribute associated with the interface_header_id has failed.
881: -- Even if one has failed, fail the whole procedure.
882: DECLARE

Line 903: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'all_failed_meavi_row_cur%FOUND. Raising exception attr_import_failed');

899: IF all_failed_meavi_row_cur%FOUND
900: THEN
901: IF (l_slog) THEN
902: -- bug 2834438
903: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module, 'all_failed_meavi_row_cur%FOUND. Raising exception attr_import_failed');
904: END IF;
905: -- some row has failed, so the while import procedure fails
906: RAISE attr_import_failed;
907: END IF;

Line 922: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'FETCH all_failed_meavi_row_cur failed. Raising exception.');

918: END IF;
919:
920: IF (l_exlog) THEN
921: -- bug 2834438
922: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'FETCH all_failed_meavi_row_cur failed. Raising exception.');
923: END IF;
924: RAISE;
925: END;
926:

Line 951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, '===== Exiting EAM_ASSET_ATTR_IMPORT_PVT.import_asset_attr_values =====');

947: ,p_data => x_msg_data);
948:
949: IF (l_plog) THEN
950: -- bug 2834438
951: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module, '===== Exiting EAM_ASSET_ATTR_IMPORT_PVT.import_asset_attr_values =====');
952: END IF;
953: EXCEPTION
954:
955: WHEN attr_import_failed THEN

Line 987: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION attr_import_failed.');

983: ,p_data => x_msg_data);
984:
985: IF (l_exlog) THEN
986: -- bug 2834438
987: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION attr_import_failed.');
988: END IF;
989: WHEN fnd_api.g_exc_error THEN
990: -- ROLLBACK TO import_asset_attr_values_pvt;
991: x_return_status := fnd_api.g_ret_sts_error;

Line 999: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION fnd_api.g_exc_error.');

995: ,p_data => x_msg_data);
996:
997: IF (l_exlog) THEN
998: -- bug 2834438
999: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION fnd_api.g_exc_error.');
1000: END IF;
1001:
1002: WHEN fnd_api.g_exc_unexpected_error THEN
1003: -- ROLLBACK TO import_asset_attr_values_pvt;

Line 1012: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION fnd_api.g_exc_unexpected_error.');

1008: ,p_data => x_msg_data);
1009:
1010: IF (l_exlog) THEN
1011: -- bug 2834438
1012: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION fnd_api.g_exc_unexpected_error.');
1013: END IF;
1014:
1015: WHEN OTHERS THEN
1016: -- ROLLBACK TO import_asset_attr_values_pvt;

Line 1031: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION OTHERS.');

1027: ,p_data => x_msg_data);
1028:
1029: IF (l_exlog) THEN
1030: -- bug 2834438
1031: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module, 'EXEPTION OTHERS.');
1032: END IF;
1033:
1034: END import_asset_attr_values;
1035: