[Home] [Help]
7043: p_error_text => lv_error_text,
7044: p_token1 => 'COLUMN_NAMES',
7045: p_token_value1 => 'SR_INSTANCE_CODE OR WEIGHT_UOM',
7046: p_token2 => 'MASTER_TABLE',
7047: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
7048: p_token3 => 'CHILD_TABLE',
7049: p_token_value3 => 'MSC_ST_TRADING_PARTNERS');
7050: IF lv_return <> 0 THEN
7051: RAISE ex_logging_err;
7061: ||' FROM msc_units_of_measure muom '
7062: ||' WHERE NVL(muom.uom_code, '||''''||NULL_CHAR||''''||') = '
7063: ||' NVL(mstp.weight_uom,'||''''||NULL_CHAR||''''||')'
7064: ||' UNION '
7065: ||' SELECT 1 FROM msc_st_units_of_measure msuom'
7066: ||' WHERE NVL(msuom.uom_code, '||''''||NULL_CHAR||''''||') = '
7067: ||' NVL(mstp.weight_uom,'||''''||NULL_CHAR||''''||')'
7068: ||' AND msuom.sr_instance_id = :v_instance_id'
7069: ||' AND msuom.process_flag = '||G_VALID||' ) '
7091: p_error_text => lv_error_text,
7092: p_token1 => 'COLUMN_NAMES',
7093: p_token_value1 => 'SR_INSTANCE_CODE OR VOLUME_UOM',
7094: p_token2 => 'MASTER_TABLE',
7095: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
7096: p_token3 => 'CHILD_TABLE',
7097: p_token_value3 => 'MSC_ST_TRADING_PARTNERS');
7098: IF lv_return <> 0 THEN
7099: RAISE ex_logging_err;
7108: ||' FROM msc_units_of_measure muom'
7109: ||' WHERE NVL(muom.uom_code, '||''''||NULL_CHAR||''''||') = '
7110: ||' NVL(mstp.volume_uom,'||''''||NULL_CHAR||''''||')'
7111: ||' UNION '
7112: ||' SELECT 1 FROM msc_st_units_of_measure msuom'
7113: ||' WHERE NVL(msuom.uom_code,' ||''''||NULL_CHAR||''''||') = '
7114: ||' NVL(mstp.volume_uom,'||''''||NULL_CHAR||''''||')'
7115: ||' AND msuom.sr_instance_id = :v_instance_id'
7116: ||' AND msuom.process_flag = '||G_VALID||' )'
16171: END LOAD_CATEGORY_SET;
16172:
16173: /*==========================================================================+
16174: | DESCRIPTION : This procedure performs validation and loads data into the |
16175: | table msc_st_units_of_measure. |
16176: +==========================================================================*/
16177: PROCEDURE LOAD_UOM IS
16178: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
16179: lb_rowid RowidTab;
16181: lv_error_text VARCHAR2(250);
16182: lv_where_str VARCHAR2(5000);
16183: lv_sql_stmt VARCHAR2(5000);
16184: lv_column_names VARCHAR2(5000);
16185: lv_batch_id msc_st_units_of_measure.batch_id%TYPE;
16186: lv_message_text msc_errors.error_text%TYPE;
16187:
16188: ex_logging_err EXCEPTION;
16189:
16188: ex_logging_err EXCEPTION;
16189:
16190: CURSOR c1(p_batch_id NUMBER) IS
16191: SELECT rowid
16192: FROM msc_st_units_of_measure
16193: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
16194: AND batch_id = p_batch_id
16195: AND sr_instance_code = v_instance_code;
16196:
16194: AND batch_id = p_batch_id
16195: AND sr_instance_code = v_instance_code;
16196:
16197: BEGIN
16198: --*********Validation for msc_st_units_of_measure***********
16199: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
16200: (p_app_short_name => 'MSC',
16201: p_error_code => 'MSC_PP_DUP_REC_FOR_XML',
16202: p_message_text => lv_message_text,
16208:
16209: --Duplicate records check for the records whose source is XML
16210: v_sql_stmt := 01;
16211: lv_sql_stmt :=
16212: ' UPDATE msc_st_units_of_measure mum1'
16213: ||' SET process_flag = '||G_ERROR_FLG||','
16214: ||' error_text = '||''''||lv_message_text||''''
16215: ||' WHERE message_id < (SELECT MAX(message_id)'
16216: ||' FROM msc_st_units_of_measure mum2'
16212: ' UPDATE msc_st_units_of_measure mum1'
16213: ||' SET process_flag = '||G_ERROR_FLG||','
16214: ||' error_text = '||''''||lv_message_text||''''
16215: ||' WHERE message_id < (SELECT MAX(message_id)'
16216: ||' FROM msc_st_units_of_measure mum2'
16217: ||' WHERE NVL(mum2.unit_of_measure,' ||''''||NULL_CHAR||''''||') ='
16218: ||' NVL(mum1.unit_of_measure,' ||''''||NULL_CHAR||''''||') '
16219: ||' AND NVL(mum2.company_name, ' ||''''||NULL_CHAR||''''||') = '
16220: ||' NVL(mum1.company_name, ' ||''''||NULL_CHAR||''''||')'
16246: --Different SQL is used because in XML we can identify the latest records
16247: --whereas in batch load we cannot.
16248: v_sql_stmt := 02;
16249: lv_sql_stmt :=
16250: ' UPDATE msc_st_units_of_measure mum1'
16251: ||' SET process_flag = '||G_ERROR_FLG||','
16252: ||' error_text = '||''''||lv_message_text||''''
16253: ||' WHERE EXISTS( SELECT 1 '
16254: ||' FROM msc_st_units_of_measure mum2'
16250: ' UPDATE msc_st_units_of_measure mum1'
16251: ||' SET process_flag = '||G_ERROR_FLG||','
16252: ||' error_text = '||''''||lv_message_text||''''
16253: ||' WHERE EXISTS( SELECT 1 '
16254: ||' FROM msc_st_units_of_measure mum2'
16255: ||' WHERE NVL(mum2.unit_of_measure, '||''''||NULL_CHAR||''''||')'
16256: ||' = NVL(mum1.unit_of_measure,'||''''||NULL_CHAR||''''||')'
16257: ||' AND NVL(mum2.company_name, '||''''||NULL_CHAR||''''||') = '
16258: ||' NVL(mum1.company_name, '||''''||NULL_CHAR||''''||')'
16290: FROM dual;
16291:
16292: v_sql_stmt := 04;
16293: lv_sql_stmt :=
16294: 'UPDATE msc_st_units_of_measure '
16295: ||' SET batch_id = :lv_batch_id'
16296: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
16297: ||' AND sr_instance_code = :v_instance_code'
16298: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE
16312: CLOSE c1;
16313:
16314: v_sql_stmt := 05;
16315: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
16316: UPDATE msc_st_units_of_measure
16317: SET st_transaction_id = msc_st_units_of_measure_s.NEXTVAL,
16318: refresh_id = v_refresh_id,
16319: last_update_date = v_current_date,
16320: last_updated_by = v_current_user,
16313:
16314: v_sql_stmt := 05;
16315: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
16316: UPDATE msc_st_units_of_measure
16317: SET st_transaction_id = msc_st_units_of_measure_s.NEXTVAL,
16318: refresh_id = v_refresh_id,
16319: last_update_date = v_current_date,
16320: last_updated_by = v_current_user,
16321: creation_date = v_current_date,
16328: p_error_code => 'MSC_PP_NO_DELETION',
16329: p_message_text => lv_message_text,
16330: p_error_text => lv_error_text,
16331: p_token1 => 'TABLE_NAME',
16332: p_token_value1 => 'MSC_ST_UNITS_OF_MEASURE');
16333:
16334: IF lv_return <> 0 THEN
16335: RAISE ex_logging_err;
16336: END IF;
16336: END IF;
16337:
16338: v_sql_stmt := 06;
16339: lv_sql_stmt :=
16340: 'UPDATE msc_st_units_of_measure '
16341: ||' SET process_flag = '||G_ERROR_FLG||','
16342: ||' error_text = '||''''||lv_message_text||''''
16343: ||' WHERE deleted_flag = '||SYS_YES
16344: ||' AND process_flag = '||G_IN_PROCESS
16371: ||' NOT IN(1,2)';
16372: --Log a warning for those records where the deleted_flag has a value other
16373: --than SYS_NO
16374: lv_return := MSC_ST_UTIL.LOG_ERROR
16375: (p_table_name => 'MSC_ST_UNITS_OF_MEASURE',
16376: p_instance_code => v_instance_code,
16377: p_row => lv_column_names,
16378: p_severity => G_SEV_WARNING,
16379: p_message_text => lv_message_text,
16401: END IF;
16402:
16403: v_sql_stmt := 07;
16404: lv_sql_stmt :=
16405: 'UPDATE msc_st_units_of_measure '
16406: ||' SET process_flag = '||G_ERROR_FLG||','
16407: ||' error_text = '||''''||lv_message_text||''''
16408: ||' WHERE (NVL(uom_code, '||''''||NULL_CHAR||''''||') '
16409: ||' = '||''''||NULL_CHAR||''''
16421: v_instance_code;
16422:
16423: v_sql_stmt := 08;
16424: lv_sql_stmt :=
16425: 'UPDATE msc_st_units_of_measure '
16426: ||' SET unit_of_measure = uom_code'
16427: ||' WHERE NVL(unit_of_measure,'||''''||NULL_CHAR||''''||') '
16428: ||' = '||''''||NULL_CHAR||''''
16429: ||' AND batch_id = :lv_batch_id'
16451: END IF;
16452:
16453: v_sql_stmt := 09;
16454: lv_sql_stmt :=
16455: 'UPDATE msc_st_units_of_measure mum1 '
16456: ||' SET process_flag = '||G_ERROR_FLG||','
16457: ||' error_text = '||''''||lv_message_text||''''
16458: ||' WHERE EXISTS(SELECT 1'
16459: ||' FROM msc_units_of_measure mum2'
16465: ||' NVL(mum1.uom_class, '||''''||NULL_CHAR||''''||' )'
16466: ||' AND mum2.base_uom_flag = ''Y'' '
16467: ||' UNION'
16468: ||' SELECT 1'
16469: ||' FROM msc_st_units_of_measure mum3'
16470: ||' WHERE NVL(mum3.unit_of_measure,'||''''||NULL_CHAR||''''||') <> '
16471: ||' NVL(mum1.unit_of_measure,'||''''||NULL_CHAR||''''||')'
16472: ||' AND NVL(mum3.uom_code, '||''''||NULL_CHAR||''''||') <> '
16473: ||' NVL(mum1.uom_code, '||''''||NULL_CHAR||''''||')'
16505: --Log a warning for those records where the base_uom_flag has value
16506: --other than('Y','N')
16507:
16508: lv_return := MSC_ST_UTIL.LOG_ERROR
16509: (p_table_name => 'MSC_ST_UNITS_OF_MEASURE',
16510: p_instance_code => v_instance_code,
16511: p_row => lv_column_names,
16512: p_severity => G_SEV_WARNING,
16513: p_message_text => lv_message_text,
16535: RAISE ex_logging_err;
16536: END IF;
16537:
16538: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
16539: (p_table_name => 'MSC_ST_UNITS_OF_MEASURE',
16540: p_instance_id => v_instance_id,
16541: p_instance_code => v_instance_code,
16542: p_process_flag => G_VALID,
16543: p_error_text => lv_error_text,
16548: RAISE ex_logging_err;
16549: END IF;
16550:
16551: lv_return := MSC_ST_UTIL.LOG_ERROR
16552: (p_table_name => 'MSC_ST_UNITS_OF_MEASURE',
16553: p_instance_code => v_instance_code,
16554: p_row => lv_column_names,
16555: p_severity => G_SEV_ERROR,
16556: p_message_text => NULL,
16977: p_error_text => lv_error_text,
16978: p_token1 => 'COLUMN_NAMES',
16979: p_token_value1 => 'FROM_UOM_CODE, FROM_UOM_CLASS AND FROM_UNIT_OF_MEASURE',
16980: p_token2 => 'MASTER_TABLE',
16981: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
16982: p_token3 => 'MASTER_TABLE',
16983: p_token_value3 => 'MSC_ST_UNITS_OF_MEASURE',
16984: p_token4 => 'CHILD_TABLE',
16985: p_token_value4 => 'MSC_ST_UOM_CLASS_CONVERSIONS');
16979: p_token_value1 => 'FROM_UOM_CODE, FROM_UOM_CLASS AND FROM_UNIT_OF_MEASURE',
16980: p_token2 => 'MASTER_TABLE',
16981: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
16982: p_token3 => 'MASTER_TABLE',
16983: p_token_value3 => 'MSC_ST_UNITS_OF_MEASURE',
16984: p_token4 => 'CHILD_TABLE',
16985: p_token_value4 => 'MSC_ST_UOM_CLASS_CONVERSIONS');
16986: IF lv_return <> 0 THEN
16987: RAISE ex_logging_err;
16999: ||' AND mum.unit_of_measure = mcc.from_unit_of_measure'
17000: ||' AND mum.base_uom_flag = ''Y'' '
17001: ||' UNION'
17002: ||' SELECT 1'
17003: ||' FROM msc_st_units_of_measure mum'
17004: ||' WHERE mum.uom_code = mcc.from_uom_code'
17005: ||' AND mum.uom_class = mcc.from_uom_class'
17006: ||' AND mum.unit_of_measure = mcc.from_unit_of_measure'
17007: ||' AND mum.base_uom_flag = ''Y'' '
17027: p_token1 => 'COLUMN_NAMES',
17028: p_token_value1 => 'TO_UOM_CODE, TO_UOM_CLASS'
17029: ||' AND TO_UNIT_OF_MEASURE',
17030: p_token2 => 'MASTER_TABLE',
17031: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
17032: p_token3 => 'CHILD_TABLE',
17033: p_token_value3 => 'MSC_ST_UOM_CLASS_CONVERSIONS');
17034: IF lv_return <> 0 THEN
17035: RAISE ex_logging_err;
17047: ||' AND mum.unit_of_measure = mcc.to_unit_of_measure'
17048: ||' AND mum.base_uom_flag = ''Y'' '
17049: ||' UNION'
17050: ||' SELECT 1'
17051: ||' FROM msc_st_units_of_measure mum'
17052: ||' WHERE mum.uom_code = mcc.to_uom_code'
17053: ||' AND mum.uom_class = mcc.to_uom_class'
17054: ||' AND mum.unit_of_measure = mcc.to_unit_of_measure'
17055: ||' AND mum.base_uom_flag = ''Y'' '
17556: p_error_text => lv_error_text,
17557: p_token1 => 'COLUMN_NAMES',
17558: p_token_value1 => 'UOM_CODE, UOM_CLASS AND UNIT_OF_MEASURE',
17559: p_token2 => 'MASTER_TABLE',
17560: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
17561: p_token3 => 'CHILD_TABLE',
17562: p_token_value3 => 'MSC_ST_UOM_CONVERSIONS');
17563: IF lv_return <> 0 THEN
17564: RAISE ex_logging_err;
17575: ||' AND mum.uom_class = mcc.uom_class'
17576: ||' AND mum.unit_of_measure = mcc.unit_of_measure'
17577: ||' UNION'
17578: ||' SELECT 1'
17579: ||' FROM msc_st_units_of_measure mum'
17580: ||' WHERE mum.uom_code = mcc.uom_code'
17581: ||' AND mum.uom_class = mcc.uom_class'
17582: ||' AND mum.unit_of_measure = mcc.unit_of_measure'
17583: ||' AND mum.process_flag = '||G_VALID||')'
19090: p_error_text => lv_error_text,
19091: p_token1 => 'COLUMN_NAMES',
19092: p_token_value1 => 'SR_INSTANCE_CODE ,UOM_CODE',
19093: p_token2 => 'MASTER_TABLE',
19094: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
19095: p_token3 => 'CHILD_TABLE',
19096: p_token_value3 => 'MSC_ST_SYSTEM_ITEMS');
19097: IF lv_return <> 0 THEN
19098: RAISE ex_logging_err;
19107: ||' WHERE NOT EXISTS (SELECT 1 '
19108: ||' FROM msc_units_of_measure muom'
19109: ||' WHERE muom.uom_code = mssi.uom_code'
19110: ||' UNION'
19111: ||' SELECT 1 FROM msc_st_units_of_measure msuom'
19112: ||' WHERE msuom.uom_code = mssi.uom_code'
19113: ||' AND msuom.sr_instance_id = :v_instance_id'
19114: ||' AND msuom.process_flag = '||G_VALID||')'
19115: ||' AND mssi.sr_instance_code = :v_instance_code'
19133: p_error_text => lv_error_text,
19134: p_token1 => 'COLUMN_NAMES',
19135: p_token_value1 => 'SR_INSTANCE_CODE OR VOLUME_UOM',
19136: p_token2 => 'MASTER_TABLE',
19137: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
19138: p_token3 => 'CHILD_TABLE',
19139: p_token_value3 => 'MSC_ST_SYSTEM_ITEMS');
19140: IF lv_return <> 0 THEN
19141: RAISE ex_logging_err;
19152: ||' FROM msc_units_of_measure muom'
19153: ||' WHERE muom.uom_code = mssi.volume_uom'
19154: ||' UNION'
19155: ||' SELECT 1 '
19156: ||' FROM msc_st_units_of_measure msuom'
19157: ||' WHERE msuom.uom_code = mssi.volume_uom'
19158: ||' AND msuom.sr_instance_id = :v_instance_id'
19159: ||' AND msuom.process_flag = '||G_VALID||')'
19160: ||' AND NVL(mssi.volume_uom,'||''''||NULL_CHAR||''''||') '
19181: p_error_text => lv_error_text,
19182: p_token1 => 'COLUMN_NAMES',
19183: p_token_value1 => 'SR_INSTANCE_CODE OR WEIGHT_UOM',
19184: p_token2 => 'MASTER_TABLE',
19185: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
19186: p_token3 => 'CHILD_TABLE',
19187: p_token_value3 => 'MSC_ST_SYSTEM_ITEMS');
19188: IF lv_return <> 0 THEN
19189: RAISE ex_logging_err;
19200: ||' WHERE NOT EXISTS( SELECT 1 '
19201: ||' FROM msc_units_of_measure muom'
19202: ||' WHERE muom.uom_code = mssi.weight_uom'
19203: ||' UNION'
19204: ||' SELECT 1 FROM msc_st_units_of_measure msuom'
19205: ||' WHERE msuom.uom_code = mssi.weight_uom'
19206: ||' AND msuom.sr_instance_id = :v_instance_id'
19207: ||' AND msuom.process_flag = '||G_VALID||')'
19208: ||' AND NVL(mssi.weight_uom,'||''''||NULL_CHAR||''''||') '
21719: p_token1 => 'COLUMN_NAMES',
21720: p_token_value1 => 'SR_INSTANCE_CODE OR'
21721: ||' PURCHASING_UNIT_OF_MEASURE',
21722: p_token2 => 'MASTER_TABLE',
21723: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
21724: p_token3 => 'CHILD_TABLE',
21725: p_token_value3 => 'MSC_ST_ITEM_SUPPLIERS');
21726:
21727: IF lv_return <> 0 THEN
21738: ||' FROM msc_units_of_measure muom '
21739: ||' WHERE NVL(muom.unit_of_measure, '||''''||NULL_CHAR||''''||') = '
21740: ||' NVL(mstp.purchasing_unit_of_measure,'||''''||NULL_CHAR||''''||')'
21741: ||' UNION '
21742: ||' SELECT 1 FROM msc_st_units_of_measure msuom'
21743: ||' WHERE NVL(msuom.unit_of_measure, '||''''||NULL_CHAR||''''||') = '
21744: ||' NVL(mstp.purchasing_unit_of_measure,'||''''||NULL_CHAR||''''||')'
21745: ||' AND msuom.sr_instance_id = :v_instance_id'
21746: ||' AND msuom.process_flag = '||G_VALID||' ) '
36088: ||' WHERE NOT EXISTS (SELECT 1'
36089: ||' FROM msc_units_of_measure muom'
36090: ||' WHERE muom.uom_code = msb.uom'
36091: ||' UNION'
36092: ||' SELECT 1 FROM msc_st_units_of_measure msuom'
36093: ||' WHERE msuom.uom_code = msb.uom'
36094: ||' AND msuom.sr_instance_id = :v_instance_id'
36095: ||' AND msuom.process_flag = '||G_VALID||' )'
36096: ||' AND NVL(msb.uom,'||''''||NULL_CHAR||''''||') '
36985: ||' WHERE NOT EXISTS (SELECT 1'
36986: ||' FROM msc_units_of_measure muom'
36987: ||' WHERE muom.uom_code = mbc.uom_code'
36988: ||' UNION'
36989: ||' SELECT 1 FROM msc_st_units_of_measure msuom'
36990: ||' WHERE msuom.uom_code = mbc.uom_code'
36991: ||' AND msuom.sr_instance_id = :v_instance_id'
36992: ||' AND msuom.process_flag = '||G_VALID||' )'
36993: ||' AND NVL(mbc.uom_code,'||''''||NULL_CHAR||''''||') '
39254: ||' FROM msc_units_of_measure muom'
39255: ||' WHERE NVL(muom.uom_code, '||''''||NULL_CHAR||''''||') = '
39256: ||' NVL(msr.uom_code, '||''''||NULL_CHAR||''''||')'
39257: ||' UNION'
39258: ||' SELECT 1 FROM msc_st_units_of_measure msuom'
39259: ||' WHERE NVL(msuom.uom_code, '||''''||NULL_CHAR||''''||') = '
39260: ||' NVL(msr.uom_code,'||''''||NULL_CHAR||''''||')'
39261: ||' AND msuom.process_flag = '||G_VALID
39262: ||' AND msuom.sr_instance_id = :v_instance_id)'
50364: EXECUTE IMMEDIATE lv_sql_stmt
50365: USING lv_batch_id,
50366: v_instance_code;
50367:
50368: -- UOM_CODE should refer to a valid record in msc_units_of_measure/msc_st_units_of_measure .
50369: -- Now check for UOM code if it is Invalid error out
50370: -- Set the error message
50371:
50372: v_sql_stmt := 10;
50378: p_error_text => lv_error_text,
50379: p_token1 => 'COLUMN_NAMES',
50380: p_token_value1 => 'SR_INSTANCE_CODE ,UOM_CODE',
50381: p_token2 => 'MASTER_TABLE',
50382: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
50383: p_token3 => 'CHILD_TABLE',
50384: p_token_value3 => 'MSC_ST_ITEM_CUSTOMERS');
50385: IF lv_return <> 0 THEN
50386: RAISE ex_logging_err;
50394: ||' WHERE NOT EXISTS (SELECT 1 '
50395: ||' FROM msc_units_of_measure muom'
50396: ||' WHERE muom.uom_code = mic.uom_code'
50397: ||' UNION'
50398: ||' SELECT 1 FROM msc_st_units_of_measure msuom'
50399: ||' WHERE msuom.uom_code = mic.uom_code'
50400: ||' AND msuom.sr_instance_id = :v_instance_id'
50401: ||' AND msuom.process_flag = '||G_VALID||')'
50402: ||' AND mic.sr_instance_code = :v_instance_code'
51059: End IF;
51060: END IF;
51061:
51062: IF v_uom_enabled = SYS_YES THEN
51063: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_UNITS_OF_MEASURE');
51064: IF lv_count > 0 Then
51065: prec.uom_flag:= SYS_YES;
51066: End IF;
51067: END IF;