98: ELSIF (access_privilege_code =
99: gl_access_set_security_pkg.FULL_ACCESS) THEN
100: RETURN ('AND acc.access_privilege_code = ''F'' ');
101: ELSE
102: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
103: fnd_message.set_token('VALUE', access_privilege_code);
104: fnd_message.set_token('PARAM', 'access_privilege_code');
105: RAISE INVALID_PARAM;
106: END IF;
99: gl_access_set_security_pkg.FULL_ACCESS) THEN
100: RETURN ('AND acc.access_privilege_code = ''F'' ');
101: ELSE
102: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
103: fnd_message.set_token('VALUE', access_privilege_code);
104: fnd_message.set_token('PARAM', 'access_privilege_code');
105: RAISE INVALID_PARAM;
106: END IF;
107: END build_privilege_clause;
100: RETURN ('AND acc.access_privilege_code = ''F'' ');
101: ELSE
102: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
103: fnd_message.set_token('VALUE', access_privilege_code);
104: fnd_message.set_token('PARAM', 'access_privilege_code');
105: RAISE INVALID_PARAM;
106: END IF;
107: END build_privilege_clause;
108:
221:
222: IF (ledger_check_mode = gl_access_set_security_pkg.CHECK_LEDGER_COLUMN) THEN
223:
224: IF (ledger_context IS NULL) THEN
225: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
226: fnd_message.set_token('VALUE', ledger_context);
227: fnd_message.set_token('PARAM', 'ledger_context');
228: RAISE INVALID_PARAM;
229: END IF;
222: IF (ledger_check_mode = gl_access_set_security_pkg.CHECK_LEDGER_COLUMN) THEN
223:
224: IF (ledger_context IS NULL) THEN
225: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
226: fnd_message.set_token('VALUE', ledger_context);
227: fnd_message.set_token('PARAM', 'ledger_context');
228: RAISE INVALID_PARAM;
229: END IF;
230:
223:
224: IF (ledger_context IS NULL) THEN
225: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
226: fnd_message.set_token('VALUE', ledger_context);
227: fnd_message.set_token('PARAM', 'ledger_context');
228: RAISE INVALID_PARAM;
229: END IF;
230:
231: IF (segval_mode = gl_access_set_security_pkg.NO_SEG_VALIDATION) THEN
257: END IF;
258:
259: EXCEPTION
260: WHEN INVALID_NUMBER THEN
261: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
262: fnd_message.set_token('VALUE', ledger_context);
263: fnd_message.set_token('PARAM', 'ledger_context');
264: RAISE INVALID_PARAM;
265:
258:
259: EXCEPTION
260: WHEN INVALID_NUMBER THEN
261: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
262: fnd_message.set_token('VALUE', ledger_context);
263: fnd_message.set_token('PARAM', 'ledger_context');
264: RAISE INVALID_PARAM;
265:
266: END;
259: EXCEPTION
260: WHEN INVALID_NUMBER THEN
261: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
262: fnd_message.set_token('VALUE', ledger_context);
263: fnd_message.set_token('PARAM', 'ledger_context');
264: RAISE INVALID_PARAM;
265:
266: END;
267:
289: gl_access_set_security_pkg.build_date_clause(edate) || ')' );
290: END IF;
291:
292: ELSE
293: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
294: fnd_message.set_token('VALUE', ledger_check_mode);
295: fnd_message.set_token('PARAM', 'ledger_check_mode');
296: RAISE INVALID_PARAM;
297: END IF;
290: END IF;
291:
292: ELSE
293: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
294: fnd_message.set_token('VALUE', ledger_check_mode);
295: fnd_message.set_token('PARAM', 'ledger_check_mode');
296: RAISE INVALID_PARAM;
297: END IF;
298:
291:
292: ELSE
293: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
294: fnd_message.set_token('VALUE', ledger_check_mode);
295: fnd_message.set_token('PARAM', 'ledger_check_mode');
296: RAISE INVALID_PARAM;
297: END IF;
298:
299: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
295: fnd_message.set_token('PARAM', 'ledger_check_mode');
296: RAISE INVALID_PARAM;
297: END IF;
298:
299: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
300: fnd_message.set_token('VALUE', segval_check_mode);
301: fnd_message.set_token('PARAM', 'segval_check_mode');
302: RAISE INVALID_PARAM;
303:
296: RAISE INVALID_PARAM;
297: END IF;
298:
299: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
300: fnd_message.set_token('VALUE', segval_check_mode);
301: fnd_message.set_token('PARAM', 'segval_check_mode');
302: RAISE INVALID_PARAM;
303:
304: END get_security_clause;
297: END IF;
298:
299: fnd_message.set_name('SQLGL', 'GL_INVALID_PARAM');
300: fnd_message.set_token('VALUE', segval_check_mode);
301: fnd_message.set_token('PARAM', 'segval_check_mode');
302: RAISE INVALID_PARAM;
303:
304: END get_security_clause;
305: