DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_WRAPPER dependencies on FND_LOG

Line 53: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

49: l_result BOOLEAN;
50:
51: BEGIN
52:
53: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
54: hz_utility_v2pub.debug(p_message=>'WRP:add_policy()+',
55: p_prefix=>'',
56: p_msg_level=>fnd_log.level_procedure);
57: END IF;

Line 56: p_msg_level=>fnd_log.level_procedure);

52:
53: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
54: hz_utility_v2pub.debug(p_message=>'WRP:add_policy()+',
55: p_prefix=>'',
56: p_msg_level=>fnd_log.level_procedure);
57: END IF;
58:
59: --Get ar and apps schema name
60: l_return_value := fnd_installation.get_app_info(

Line 112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
109: END IF;
110:
111:
112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
113: hz_utility_v2pub.debug(p_message=>'WRP:add_policy()-',
114: p_prefix=>'',
115: p_msg_level=>fnd_log.level_procedure);
116: END IF;

Line 115: p_msg_level=>fnd_log.level_procedure);

111:
112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
113: hz_utility_v2pub.debug(p_message=>'WRP:add_policy()-',
114: p_prefix=>'',
115: p_msg_level=>fnd_log.level_procedure);
116: END IF;
117:
118: END add_policy;
119:

Line 246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

242:
243:
244: BEGIN
245:
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'WRP:ident_dup_within_int()+',
248: p_prefix=>'',
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;

Line 249: p_msg_level=>fnd_log.level_procedure);

245:
246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
247: hz_utility_v2pub.debug(p_message=>'WRP:ident_dup_within_int()+',
248: p_prefix=>'',
249: p_msg_level=>fnd_log.level_procedure);
250: END IF;
251:
252: /* Check dup relationships */
253: OPEN dup_rel(P_BATCH_ID, P_BATCH_MODE_FLAG);

Line 477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

473: and interface_table_name in ('HZ_IMP_RELSHIPS_INT', 'HZ_IMP_CONTACTS_INT',
474: 'HZ_IMP_ADDRESSUSES_INT', 'HZ_IMP_CLASSIFICS_INT');
475:
476: COMMIT;
477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
478: hz_utility_v2pub.debug(p_message=>'WRP:ident_dup_within_int()-',
479: p_prefix=>'',
480: p_msg_level=>fnd_log.level_procedure);
481: END IF;

Line 480: p_msg_level=>fnd_log.level_procedure);

476: COMMIT;
477: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
478: hz_utility_v2pub.debug(p_message=>'WRP:ident_dup_within_int()-',
479: p_prefix=>'',
480: p_msg_level=>fnd_log.level_procedure);
481: END IF;
482:
483: END ident_dup_within_int;
484:

Line 540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

536: --l_debug_prefix VARCHAR2(30) := '';
537: BEGIN
538:
539:
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'WRP:ALTER_SEQUENCES()+',
542: p_prefix=>'',
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;

Line 543: p_msg_level=>fnd_log.level_procedure);

539:
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'WRP:ALTER_SEQUENCES()+',
542: p_prefix=>'',
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;
545:
546: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
547:

Line 619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

615: execute immediate 'alter sequence ' || l_schema || '.hz_relationships_s cache 20';
616: END IF;
617: */
618: END IF;
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(p_message=>'WRP:ALTER_SEQUENCES()-',
621: p_prefix=>'',
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;

Line 622: p_msg_level=>fnd_log.level_procedure);

618: END IF;
619: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
620: hz_utility_v2pub.debug(p_message=>'WRP:ALTER_SEQUENCES()-',
621: p_prefix=>'',
622: p_msg_level=>fnd_log.level_procedure);
623: END IF;
624:
625: END ALTER_SEQUENCES;
626:

Line 644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

640: l_tmp VARCHAR2(2000);
641: --l_debug_prefix VARCHAR2(30) := '';
642: BEGIN
643:
644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug(p_message=>'WRP:CLEANUP_STAGING()+',
646: p_prefix=>'',
647: p_msg_level=>fnd_log.level_procedure);
648: END IF;

Line 647: p_msg_level=>fnd_log.level_procedure);

643:
644: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
645: hz_utility_v2pub.debug(p_message=>'WRP:CLEANUP_STAGING()+',
646: p_prefix=>'',
647: p_msg_level=>fnd_log.level_procedure);
648: END IF;
649:
650: l_bool := fnd_installation.GET_APP_INFO('AR',l_status,l_tmp,l_schema);
651:

Line 706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

702: DELETE hz_imp_osr_change WHERE batch_id = P_BATCH_ID;
703: --DELETE HZ_IMP_INT_DEDUP_RESULTS WHERE batch_id = P_BATCH_ID;
704: DELETE HZ_IMP_TMP_REL_END_DATE WHERE batch_id = P_BATCH_ID;
705:
706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
707: hz_utility_v2pub.debug(p_message=>'WRP:CLEANUP_STAGING()-',
708: p_prefix=>'',
709: p_msg_level=>fnd_log.level_procedure);
710: END IF;

Line 709: p_msg_level=>fnd_log.level_procedure);

705:
706: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
707: hz_utility_v2pub.debug(p_message=>'WRP:CLEANUP_STAGING()-',
708: p_prefix=>'',
709: p_msg_level=>fnd_log.level_procedure);
710: END IF;
711:
712: END CLEANUP_STAGING;
713:

Line 1229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1225:
1226: --l_debug_prefix VARCHAR2(30) := '';
1227: BEGIN
1228:
1229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1230: hz_utility_v2pub.debug(p_message=>'WRP:UPDATE_DISPLAYED_DUNS_PID()+',
1231: p_prefix=>'',
1232: p_msg_level=>fnd_log.level_procedure);
1233: END IF;

Line 1232: p_msg_level=>fnd_log.level_procedure);

1228:
1229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1230: hz_utility_v2pub.debug(p_message=>'WRP:UPDATE_DISPLAYED_DUNS_PID()+',
1231: p_prefix=>'',
1232: p_msg_level=>fnd_log.level_procedure);
1233: END IF;
1234:
1235: hz_common_pub.disable_cont_source_security;
1236:

Line 1250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1246: and actual_content_source = 'DNB';
1247:
1248: CLOSE c_displayed_duns;
1249:
1250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1251: hz_utility_v2pub.debug(p_message=>'WRP:UPDATE_DISPLAYED_DUNS_PID()-',
1252: p_prefix=>'',
1253: p_msg_level=>fnd_log.level_procedure);
1254: END IF;

Line 1253: p_msg_level=>fnd_log.level_procedure);

1249:
1250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1251: hz_utility_v2pub.debug(p_message=>'WRP:UPDATE_DISPLAYED_DUNS_PID()-',
1252: p_prefix=>'',
1253: p_msg_level=>fnd_log.level_procedure);
1254: END IF;
1255:
1256: END UPDATE_DISPLAYED_DUNS_PID;
1257:

Line 1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1284: l_dss_ps_err VARCHAR2(2000) := hz_dss_util_pub.get_display_name(null,'PARTY_SITE_CONTACT_POINTS');
1285:
1286: --l_debug_prefix VARCHAR2(30) := '';
1287: BEGIN
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1289: hz_utility_v2pub.debug(p_message=>'WRP:GENERATE_ERRORS()+',
1290: p_prefix=>'',
1291: p_msg_level=>fnd_log.level_procedure);
1292: END IF;

Line 1291: p_msg_level=>fnd_log.level_procedure);

1287: BEGIN
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1289: hz_utility_v2pub.debug(p_message=>'WRP:GENERATE_ERRORS()+',
1290: p_prefix=>'',
1291: p_msg_level=>fnd_log.level_procedure);
1292: END IF;
1293:
1294: /* If not a new batch, clear all 'C' interface_status */
1295: IF P_RERUN_FLAG <> 'N' THEN

Line 3306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3302: and l_table_name(i) = 'HZ_IMP_RELSHIPS_INT';
3303:
3304: COMMIT;
3305:
3306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3307: hz_utility_v2pub.debug(p_message=>'WRP:GENERATE_ERRORS()-',
3308: p_prefix=>'',
3309: p_msg_level=>fnd_log.level_procedure);
3310: END IF;

Line 3309: p_msg_level=>fnd_log.level_procedure);

3305:
3306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3307: hz_utility_v2pub.debug(p_message=>'WRP:GENERATE_ERRORS()-',
3308: p_prefix=>'',
3309: p_msg_level=>fnd_log.level_procedure);
3310: END IF;
3311:
3312: END GENERATE_ERRORS;
3313:

Line 3342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3338: WHERE batch_id = p_batch_id
3339: AND rownum = 1;
3340: --l_debug_prefix VARCHAR2(30) := '';
3341: BEGIN
3342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3343: hz_utility_v2pub.debug(p_message=>'WRP:DATA_LOAD_PREPROCESSING()+',
3344: p_prefix=>'',
3345: p_msg_level=>fnd_log.level_procedure);
3346: END IF;

Line 3345: p_msg_level=>fnd_log.level_procedure);

3341: BEGIN
3342: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3343: hz_utility_v2pub.debug(p_message=>'WRP:DATA_LOAD_PREPROCESSING()+',
3344: p_prefix=>'',
3345: p_msg_level=>fnd_log.level_procedure);
3346: END IF;
3347:
3348: /* Get latest batch details status */
3349: OPEN c_batch_status(P_BATCH_ID);

Line 3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3396: GENERATE_ENTITIES_WORK_UNITS(P_BATCH_ID, P_ORIG_SYSTEM);
3397:
3398: END IF;
3399:
3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3401: hz_utility_v2pub.debug(p_message=>'WRP:DATA_LOAD_PREPROCESSING()-',
3402: p_prefix=>'',
3403: p_msg_level=>fnd_log.level_procedure);
3404: END IF;

Line 3403: p_msg_level=>fnd_log.level_procedure);

3399:
3400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3401: hz_utility_v2pub.debug(p_message=>'WRP:DATA_LOAD_PREPROCESSING()-',
3402: p_prefix=>'',
3403: p_msg_level=>fnd_log.level_procedure);
3404: END IF;
3405:
3406: END DATA_LOAD_PREPROCESSING;
3407:

Line 3667: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

3663: AND rownum = 1;
3664:
3665: --l_debug_prefix VARCHAR2(30) := '';
3666: BEGIN
3667: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3668: hz_utility_v2pub.debug(p_message=>'WRP:DATA_LOAD()+',
3669: p_prefix=>'',
3670: p_msg_level=>fnd_log.level_procedure);
3671: END IF;

Line 3670: p_msg_level=>fnd_log.level_procedure);

3666: BEGIN
3667: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3668: hz_utility_v2pub.debug(p_message=>'WRP:DATA_LOAD()+',
3669: p_prefix=>'',
3670: p_msg_level=>fnd_log.level_procedure);
3671: END IF;
3672:
3673: OPEN c_wu(P_BATCH_ID);
3674: FETCH c_wu INTO l_wu_exists;

Line 3914: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

3910:
3911: stage := stage + 1; -- proceed to next stage
3912: IF (stage=1) THEN
3913:
3914: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3915: hz_utility_v2pub.debug(p_message=>'WRP:Stage 1, P_RERUN_FLAG: ' || P_RERUN_FLAG,
3916: p_prefix =>'',
3917: p_msg_level=>fnd_log.level_statement);
3918: END IF;

Line 3917: p_msg_level=>fnd_log.level_statement);

3913:
3914: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3915: hz_utility_v2pub.debug(p_message=>'WRP:Stage 1, P_RERUN_FLAG: ' || P_RERUN_FLAG,
3916: p_prefix =>'',
3917: p_msg_level=>fnd_log.level_statement);
3918: END IF;
3919:
3920: /* Update batch summary status to PROCESSING */
3921: update_import_status(P_BATCH_ID, 'PROCESSING');

Line 4110: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4106:
4107: END IF;
4108:
4109: elsif (stage>TOTAL_NUM_STAGES) then
4110: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4111: hz_utility_v2pub.debug(p_message=>'WRP:All stages done: Start Postprocessing Wait',
4112: p_prefix =>'',
4113: p_msg_level=>fnd_log.level_statement);
4114: END IF;

Line 4113: p_msg_level=>fnd_log.level_statement);

4109: elsif (stage>TOTAL_NUM_STAGES) then
4110: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4111: hz_utility_v2pub.debug(p_message=>'WRP:All stages done: Start Postprocessing Wait',
4112: p_prefix =>'',
4113: p_msg_level=>fnd_log.level_statement);
4114: END IF;
4115:
4116: /* Update displayed duns party id. Originally done in PP-Wait */
4117: IF P_ORIG_SYSTEM = 'DNB' THEN

Line 4127: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4123:
4124: /* Clean up Staging table */
4125: /* CLEANUP_STAGING(P_BATCH_ID, P_BATCH_MODE_FLAG); */
4126:
4127: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4128: hz_utility_v2pub.debug(p_message=>'WRP:Staging table cleaned up',
4129: p_prefix =>'',
4130: p_msg_level=>fnd_log.level_statement);
4131: END IF;

Line 4130: p_msg_level=>fnd_log.level_statement);

4126:
4127: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4128: hz_utility_v2pub.debug(p_message=>'WRP:Staging table cleaned up',
4129: p_prefix =>'',
4130: p_msg_level=>fnd_log.level_statement);
4131: END IF;
4132: /* Delete Work Unit */
4133: /* delete hz_imp_work_units where batch_id = P_BATCH_ID;
4134:

Line 4135: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

4131: END IF;
4132: /* Delete Work Unit */
4133: /* delete hz_imp_work_units where batch_id = P_BATCH_ID;
4134:
4135: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4136: hz_utility_v2pub.debug(p_message=>'WRP:work united deleted',
4137: p_prefix =>'',
4138: p_msg_level=>fnd_log.level_statement);
4139: END IF;

Line 4138: p_msg_level=>fnd_log.level_statement);

4134:
4135: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4136: hz_utility_v2pub.debug(p_message=>'WRP:work united deleted',
4137: p_prefix =>'',
4138: p_msg_level=>fnd_log.level_statement);
4139: END IF;
4140:
4141: /* Update counts in batch summary */
4142:

Line 4143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4139: END IF;
4140:
4141: /* Update counts in batch summary */
4142:
4143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4144: hz_utility_v2pub.debug(p_message=>'WRP:post_import_counts()+',
4145: p_prefix=>'',
4146: p_msg_level=>fnd_log.level_procedure);
4147: END IF;

Line 4146: p_msg_level=>fnd_log.level_procedure);

4142:
4143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4144: hz_utility_v2pub.debug(p_message=>'WRP:post_import_counts()+',
4145: p_prefix=>'',
4146: p_msg_level=>fnd_log.level_procedure);
4147: END IF;
4148:
4149: HZ_IMP_LOAD_BATCH_COUNTS_PKG.post_import_counts(P_BATCH_ID, P_ORIG_SYSTEM,
4150: P_BATCH_MODE_FLAG,P_REQUEST_ID, P_RERUN_FLAG);

Line 4152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4148:
4149: HZ_IMP_LOAD_BATCH_COUNTS_PKG.post_import_counts(P_BATCH_ID, P_ORIG_SYSTEM,
4150: P_BATCH_MODE_FLAG,P_REQUEST_ID, P_RERUN_FLAG);
4151:
4152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4153: hz_utility_v2pub.debug(p_message=>'WRP:post_import_counts()-',
4154: p_prefix=>'',
4155: p_msg_level=>fnd_log.level_procedure);
4156: END IF;

Line 4155: p_msg_level=>fnd_log.level_procedure);

4151:
4152: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4153: hz_utility_v2pub.debug(p_message=>'WRP:post_import_counts()-',
4154: p_prefix=>'',
4155: p_msg_level=>fnd_log.level_procedure);
4156: END IF;
4157:
4158: /* Update import status */
4159: /* Check if any error in current run. If so, update import_status in

Line 4189: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4185: CLEANUP_SSM(l_content_src_type,P_BATCH_ID,P_BATCH_MODE_FLAG,P_ORIG_SYSTEM,P_REQUEST_ID);
4186:
4187: /*
4188:
4189: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4190: hz_utility_v2pub.debug(p_message=>'WRP:post_import_counts()+',
4191: p_prefix=>'',
4192: p_msg_level=>fnd_log.level_procedure);
4193: END IF;

Line 4192: p_msg_level=>fnd_log.level_procedure);

4188:
4189: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4190: hz_utility_v2pub.debug(p_message=>'WRP:post_import_counts()+',
4191: p_prefix=>'',
4192: p_msg_level=>fnd_log.level_procedure);
4193: END IF;
4194:
4195: HZ_IMP_LOAD_BATCH_COUNTS_PKG.post_import_counts(P_BATCH_ID, P_ORIG_SYSTEM,
4196: P_BATCH_MODE_FLAG,P_REQUEST_ID, P_RERUN_FLAG);

Line 4198: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4194:
4195: HZ_IMP_LOAD_BATCH_COUNTS_PKG.post_import_counts(P_BATCH_ID, P_ORIG_SYSTEM,
4196: P_BATCH_MODE_FLAG,P_REQUEST_ID, P_RERUN_FLAG);
4197:
4198: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4199: hz_utility_v2pub.debug(p_message=>'WRP:post_import_counts()-',
4200: p_prefix=>'',
4201: p_msg_level=>fnd_log.level_procedure);
4202: END IF;*/

Line 4201: p_msg_level=>fnd_log.level_procedure);

4197:
4198: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4199: hz_utility_v2pub.debug(p_message=>'WRP:post_import_counts()-',
4200: p_prefix=>'',
4201: p_msg_level=>fnd_log.level_procedure);
4202: END IF;*/
4203:
4204: /* Give warning if no records are imported. Need to check only
4205: for a new batch because if it is a rerun, total_records_imported is

Line 4321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

4317: request_data => TO_CHAR(stage)) ;
4318:
4319: errbuf := 'Concurrent Workers submitted.';
4320: retcode := 0;
4321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4322: hz_utility_v2pub.debug(p_message=>'WRP:DATA_LOAD()-',
4323: p_prefix=>'',
4324: p_msg_level=>fnd_log.level_procedure);
4325: END IF;

Line 4324: p_msg_level=>fnd_log.level_procedure);

4320: retcode := 0;
4321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4322: hz_utility_v2pub.debug(p_message=>'WRP:DATA_LOAD()-',
4323: p_prefix=>'',
4324: p_msg_level=>fnd_log.level_procedure);
4325: END IF;
4326: RETURN;
4327: EXCEPTION
4328: WHEN OTHERS THEN