17: x_usage_code VARCHAR2) IS
18: bsv VARCHAR2(25);
19:
20: BEGIN
21: IF (fnd_flex_keyval.validate_ccid('SQLGL',
22: 'GL#',
23: x_chart_of_accounts_id,
24: x_ccid,
25: 'GL_BALANCING') = TRUE) THEN
22: 'GL#',
23: x_chart_of_accounts_id,
24: x_ccid,
25: 'GL_BALANCING') = TRUE) THEN
26: bsv := fnd_flex_keyval.concatenated_values;
27: ELSE
28: fnd_message.set_name('SQLGL', fnd_flex_keyval.encoded_error_message);
29: app_exception.raise_exception;
30: END IF;
24: x_ccid,
25: 'GL_BALANCING') = TRUE) THEN
26: bsv := fnd_flex_keyval.concatenated_values;
27: ELSE
28: fnd_message.set_name('SQLGL', fnd_flex_keyval.encoded_error_message);
29: app_exception.raise_exception;
30: END IF;
31:
32: UPDATE GL_TRANSLATION_STATUSES TS