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_NUM_IMPORT_PUB dependencies on FND_LOG

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

145:
146: l_api_name constant varchar2(30) := 'update_row_calculated_values';
147:
148: l_module varchar2(200);
149: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
150: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
151: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
152: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
153:

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

146: l_api_name constant varchar2(30) := 'update_row_calculated_values';
147:
148: l_module varchar2(200);
149: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
150: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
151: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
152: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
153:
154: begin

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

147:
148: l_module varchar2(200);
149: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
150: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
151: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
152: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
153:
154: begin
155:

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

148: l_module varchar2(200);
149: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
150: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
151: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
152: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
153:
154: begin
155:
156: if (l_ulog) then

Line 161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

157: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
158: end if;
159:
160: if (l_slog) then
161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
162: 'Updating interface table with calculated values');
163: end if;
164:
165: update mtl_eam_asset_num_interface set

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

220:
221: l_api_name CONSTANT VARCHAR2(30) := 'pn_genealogy_change';
222:
223: l_module varchar2(200);
224: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
226: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
227: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
228: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

221: l_api_name CONSTANT VARCHAR2(30) := 'pn_genealogy_change';
222:
223: l_module varchar2(200);
224: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
226: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
227: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
228: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
229:

Line 226: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

222:
223: l_module varchar2(200);
224: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
226: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
227: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
228: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
229:
230: begin

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

223: l_module varchar2(200);
224: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
226: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
227: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
228: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
229:
230: begin
231: if (l_ulog) then

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

224: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
225: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
226: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
227: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
228: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
229:
230: begin
231: if (l_ulog) then
232: l_module := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;

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

519: l_x_moi_msg_count NUMBER;
520: l_x_moi_msg_data VARCHAR2(20000);
521:
522: l_module varchar2(200);
523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
526: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
527: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

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

520: l_x_moi_msg_data VARCHAR2(20000);
521:
522: l_module varchar2(200);
523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
526: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
527: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
528: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

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

521:
522: l_module varchar2(200);
523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
526: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
527: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
528: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
529:

Line 526: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

522: l_module varchar2(200);
523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
526: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
527: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
528: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
529:
530: CURSOR asset_num_cur IS

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

523: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
526: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
527: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
528: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
529:
530: CURSOR asset_num_cur IS
531: SELECT *

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

524: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level;
525: l_exLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_exception >= l_log_level;
526: l_eLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
527: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
528: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
529:
530: CURSOR asset_num_cur IS
531: SELECT *
532: FROM MTL_EAM_ASSET_NUM_INTERFACE

Line 552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

548: l_module := 'eam.plsql.'|| l_full_name;
549: end if;
550:
551: if (l_plog) then
552: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
553: 'Entering ' || l_full_name);
554: end if;
555:
556:

Line 577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'');

573: l_error_code := 9999;
574: l_error_message := 'Unknown Exception';
575:
576: if (l_slog) then
577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'');
578:
579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
580: 'Start Worker for Asset Import. Time now is ' ||
581: to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));

Line 579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

575:
576: if (l_slog) then
577: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'');
578:
579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
580: 'Start Worker for Asset Import. Time now is ' ||
581: to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
582:
583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'');

Line 583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'');

579: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
580: 'Start Worker for Asset Import. Time now is ' ||
581: to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
582:
583: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,'');
584: end if;
585:
586:
587:

Line 588: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

584: end if;
585:
586:
587:
588: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
589: 'Processing interface group ' || p_interface_group_id ||
590: ' with purge option ' || p_purge_option);
591: end if;
592:

Line 597: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

593: --store the category set id for eAM for use in every loop
594: -- 2002-01-08: chrng: Use category_set_id directly, see bug 2175340.
595: l_category_set_id := 1000000014;
596:
597: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
598: 'Opening cursor for records in interface table');
599: end if;
600:
601: open asset_num_cur;

Line 608: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

604: SAVEPOINT LOOP_START;
605:
606:
607: if (l_slog) then
608: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
609: '___________________________________________________________');
610: end if;
611:
612: FETCH asset_num_cur INTO asset_rec;

Line 617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

613: EXIT WHEN asset_num_cur%NOTFOUND;
614:
615:
616: if (l_slog) then
617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
618: 'Processing Record with HEADER ID: '|| asset_rec.interface_header_id);
619:
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
621: ' for ORGANIZATION (Id/Code): ' ||

Line 620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

616: if (l_slog) then
617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
618: 'Processing Record with HEADER ID: '|| asset_rec.interface_header_id);
619:
620: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
621: ' for ORGANIZATION (Id/Code): ' ||
622: asset_rec.current_organization_id || '/' || asset_rec.organization_code ||
623: ', ITEM ID: ' || asset_rec.inventory_item_id ||
624: ', SERIAL: ' || asset_rec.serial_number);

Line 629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

625: end if;
626:
627:
628: if (l_slog) then
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
630: 'Record will be processed with SCOPE: '
631: || asset_rec.import_scope || ', MODE: ' || asset_rec.import_mode);
632: end if;
633:

Line 710: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

706: --if mode = 0, create row
707: IF asset_rec.import_mode = 0 AND asset_rec.import_scope<>2 THEN
708:
709: if (l_slog) then
710: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
711: 'Now inserting asset...');
712: end if;
713:
714: if asset_rec.pn_location_id is not null then

Line 763: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,l_error_message);

759: || l_return_status || ' and message: ' || l_data;
760:
761:
762: if (l_elog) then
763: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,l_error_message);
764: end if;
765:
766: RAISE NO_DATA_FOUND;
767: ELSE

Line 769: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

765:
766: RAISE NO_DATA_FOUND;
767: ELSE
768: if (l_slog) then
769: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
770: 'Asset was inserted.');
771: end if;
772: END IF;
773:

Line 805: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

801: -- if mode = 1 update record
802: IF asset_rec.import_mode = 1 THEN
803:
804: if (l_slog) then
805: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
806: 'Now updating asset with ROWID: ' || l_serial_rowid || '...');
807: end if;
808:
809: -- 2002-01-16: chrng: Fixed bug 2185999.

Line 884: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,l_error_message);

880: l_error_message := 'Asset update failed with return status: '
881: || l_return_status || ' and message: ' || l_data;
882:
883: if (l_elog) then
884: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,l_error_message);
885: end if;
886:
887: RAISE NO_DATA_FOUND;
888: ELSE

Line 890: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

886:
887: RAISE NO_DATA_FOUND;
888: ELSE
889: if (l_slog) then
890: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
891: 'Asset was updated');
892: end if;
893:
894: END IF;

Line 906: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

902: --Import Asset Extensible attributes
903: IF (asset_rec.import_scope <> 1) THEN
904:
905: if (l_slog) then
906: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
907: 'Now importing Attributes...');
908: end if;
909:
910: EAM_ASSET_ATTR_IMPORT_PVT.import_asset_attr_values(

Line 927: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,l_error_message);

923:
924: l_error_message := 'Failed because Extensible Attributes import failed';
925:
926: if (l_elog) then
927: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,l_error_message);
928: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute return status= ' || l_return_status);
929: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg count= ' || l_count);
930: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg data = ' || l_data);
931: end if;

Line 928: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute return status= ' || l_return_status);

924: l_error_message := 'Failed because Extensible Attributes import failed';
925:
926: if (l_elog) then
927: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,l_error_message);
928: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute return status= ' || l_return_status);
929: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg count= ' || l_count);
930: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg data = ' || l_data);
931: end if;
932:

Line 929: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg count= ' || l_count);

925:
926: if (l_elog) then
927: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,l_error_message);
928: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute return status= ' || l_return_status);
929: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg count= ' || l_count);
930: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg data = ' || l_data);
931: end if;
932:
933: RAISE attr_import_failed;

Line 930: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg data = ' || l_data);

926: if (l_elog) then
927: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,l_error_message);
928: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute return status= ' || l_return_status);
929: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg count= ' || l_count);
930: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, l_module,'Import attribute msg data = ' || l_data);
931: end if;
932:
933: RAISE attr_import_failed;
934:

Line 938: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

934:
935: ELSE
936:
937: if (l_slog) then
938: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
939: 'Attributes were imported.');
940: end if;
941:
942: END IF;

Line 953: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

949: WHERE interface_header_id = asset_rec.interface_header_id;
950: COMMIT;
951:
952: if (l_slog) then
953: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
954: 'Transaction Commited.');
955: end if;
956:
957: --end validations if scope =0 or 1

Line 986: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

982: BEGIN
983:
984:
985: if (l_exlog) then
986: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
987: 'ERROR: ' || l_error_code || ' - ' || l_error_message);
988: end if;
989:
990: -- Save the error messages and other calculated columns in the MEAVI table

Line 1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

996: ROLLBACK to LOOP_START;
997:
998:
999: if (l_exlog) then
1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
1001: 'After attr import failed: Transaction Rolled back to LOOP_START.');
1002: end if;
1003:
1004: -- Update MEAVI with error messages

Line 1037: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

1033: COMMIT;
1034:
1035:
1036: if (l_exlog) then
1037: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
1038: 'After attr import failed: Transaction Commited');
1039: end if;
1040:
1041: END;

Line 1046: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

1042:
1043: WHEN NO_DATA_FOUND or no_rows_updated THEN
1044:
1045: if (l_exlog) then
1046: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
1047: 'ERROR: ' || l_error_code || ' - ' || l_error_message);
1048: end if;
1049:
1050: ROLLBACK to LOOP_START;

Line 1053: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

1049:
1050: ROLLBACK to LOOP_START;
1051:
1052: if (l_exlog) then
1053: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
1054: 'Transaction Rolled back to LOOP_START.');
1055: end if;
1056:
1057: update_row_error(l_error_code, l_error_message, asset_rec);

Line 1064: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

1060: end if;
1061: COMMIT;
1062:
1063: if (l_exlog) then
1064: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
1065: 'Transaction Commited.');
1066: end if;
1067:
1068: -- pn integration changes

Line 1079: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

1075: --dbms_output.put_line(g_msg);
1076: WHEN OTHERS THEN
1077:
1078: if (l_exlog) then
1079: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
1080: 'UNEXPECTED ERROR: ' || SQLERRM);
1081: end if;
1082:
1083: ROLLBACK to LOOP_START;

Line 1086: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

1082:
1083: ROLLBACK to LOOP_START;
1084:
1085: if (l_exlog) then
1086: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
1087: 'Transaction Rolled back to LOOP_START.');
1088: end if;
1089:
1090: update_row_error(9999, l_varchar2000, asset_rec);

Line 1097: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

1093: end if;
1094: COMMIT;
1095:
1096: if (l_exlog) then
1097: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
1098: 'Transaction Commited.');
1099: end if;
1100:
1101: RAISE;

Line 1115: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1111: and interface_group_id = p_interface_group_id;
1112: END IF;
1113:
1114: if (l_plog) then
1115: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1116: 'Exiting ' || l_full_name);
1117:
1118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1119: 'End Worker for Asset Import. Time now is ' ||

Line 1118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

1114: if (l_plog) then
1115: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1116: 'Exiting ' || l_full_name);
1117:
1118: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
1119: 'End Worker for Asset Import. Time now is ' ||
1120: to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
1121: end if;
1122: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('NORMAL', l_error_message);

Line 1130: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,l_error_message);

1126: l_error_message := 'UNEXPECTED ERROR IN OUTER BLOCK: ' || SQLERRM;
1127: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', l_error_message);
1128:
1129: if (l_exlog) then
1130: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,l_error_message);
1131: end if;
1132:
1133: ROLLBACK;
1134:

Line 1136: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,'Transaction Rolled back.');

1132:
1133: ROLLBACK;
1134:
1135: if (l_exlog) then
1136: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,'Transaction Rolled back.');
1137: end if;
1138:
1139: IF asset_num_cur%ISOPEN THEN
1140: CLOSE asset_num_cur;

Line 1157: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,'Transaction Commited.');

1153: and process_flag = 'R';
1154: COMMIT;
1155:
1156: if (l_exlog) then
1157: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,'Transaction Commited.');
1158: end if;
1159:
1160: if (l_exlog) then
1161: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

Line 1161: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,

1157: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,'Transaction Commited.');
1158: end if;
1159:
1160: if (l_exlog) then
1161: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION, l_module,
1162: 'End Worker for Asset Import. Time now is ' ||
1163: to_char(sysdate, 'Month DD, YYYY HH24:MI:SS'));
1164: end if;
1165: