68: EXCEPTION
69: WHEN NO_DATA_FOUND THEN
70: fnd_message.set_name('SQLGL', 'GL_CTAX_BAD_HEADER');
71: fnd_message.set_token('HEADER_ID', to_char(header_id));
72: app_exception.raise_exception;
73: END;
74:
75: IF (tax_status_code <> 'R') THEN
76: fnd_message.set_name('SQLGL', 'GL_CTAX_HEADER_TAXED');
73: END;
74:
75: IF (tax_status_code <> 'R') THEN
76: fnd_message.set_name('SQLGL', 'GL_CTAX_HEADER_TAXED');
77: app_exception.raise_exception;
78: END IF;
79:
80: -- Get various information about the tax setup
81: BEGIN
115: fnd_message.set_name('SQLGL', 'GL_CTAX_NO_OPTIONS_JOURN_ORG');
116: ELSE
117: fnd_message.set_name('SQLGL', 'GL_CTAX_NO_OPTIONS_BATCH_ORG');
118: END IF;
119: app_exception.raise_exception;
120: END;
121: END setup;
122:
123: --
293: EXCEPTION
294: WHEN NO_DATA_FOUND THEN
295: fnd_message.set_name('SQLGL', 'GL_CTAX_BAD_BATCH');
296: fnd_message.set_token('BATCH_ID', to_char(batch_header_id));
297: app_exception.raise_exception;
298: END;
299:
300: IF (nvl(tax_status_code,'0') <> '1') THEN
301: fnd_message.set_name('SQLGL', 'GL_CTAX_BATCH_TAXED');
298: END;
299:
300: IF (nvl(tax_status_code,'0') <> '1') THEN
301: fnd_message.set_name('SQLGL', 'GL_CTAX_BATCH_TAXED');
302: app_exception.raise_exception;
303: END IF;
304:
305: OPEN b_journals;
306: END IF;
582: -- Raise an error
583: IF (line_count = 0) THEN
584: IF (tax_level = 'B') THEN
585: fnd_message.set_name('SQLGL', 'GL_CTAX_BATCH_NO_TAX_LINES');
586: app_exception.raise_exception;
587: ELSE
588: fnd_message.set_name('SQLGL', 'GL_CTAX_JOURNAL_NO_TAX_LINES');
589: app_exception.raise_exception;
590: END IF;
585: fnd_message.set_name('SQLGL', 'GL_CTAX_BATCH_NO_TAX_LINES');
586: app_exception.raise_exception;
587: ELSE
588: fnd_message.set_name('SQLGL', 'GL_CTAX_JOURNAL_NO_TAX_LINES');
589: app_exception.raise_exception;
590: END IF;
591: END IF;
592:
593: -- Update the running totals