435: RAISE LBins_err;
436: END IF;
437:
438: -- need to add base row for language for GR_RISK_PHRASES_TL
439: gr_risk_phrases_tl_pkg.insert_row(p_commit => 'T',
440: p_called_by_form => 'F',
441: p_risk_phrase_code => p_phrase_code,
442: p_language => p_language,
443: p_source_language => p_source_language,
461: OPEN Cur_count_risk_language;
462: FETCH Cur_count_risk_language INTO l_missing_count;
463: CLOSE Cur_count_risk_language;
464: IF l_missing_count > 0 THEN
465: gr_risk_phrases_tl_pkg.Add_Language (p_commit => 'T',
466: p_called_by_form => 'F',
467: p_risk_phrase_code => p_phrase_code,
468: p_language => p_language,
469: x_return_status => return_status,
504: END IF;
505: CLOSE c_get_risk_phrase_tl;
506:
507: -- The values for Source Language, Language and Description will be written to the GR_RISK_PHRASES_TL table;
508: gr_risk_phrases_tl_pkg.insert_row(p_commit => 'T',
509: p_called_by_form => 'F',
510: p_risk_phrase_code => p_phrase_code,
511: p_language => p_language,
512: p_source_language => p_source_language,
693: END IF;
694: CLOSE c_get_language;
695: -- If the record for the specified risk phrase and language does not exist in the
696: -- GR_RISK_PHRASES_TL table,an error will be written to the log file.
697: gr_risk_phrases_tl_pkg.Check_Primary_Key(
698: p_phrase_code,
699: p_language,
700: 'F',
701: row_id,
820: END IF;
821: CLOSE c_get_language;
822: -- If the record for the specified safety phrase and language does not exist in the
823: -- GR_SAFETY_PHRASES_TL table,an error will be written to the log file.
824: gr_risk_phrases_tl_pkg.Check_Primary_Key(
825: p_phrase_code,
826: p_language,
827: 'F',
828: row_id,