297: END IF;
298:
299: IF (counter = 0) THEN
300: fnd_message.set_name('SQLGL', 'GL_CONS_NO_CHILD');
301: app_exception.raise_exception;
302: END IF;
303:
304:
305: IF (prior_child_set_id IS NOT NULL) THEN
501:
502: instr_value := INSTR(all_parent_ledger_id, from_ledger_list);
503: IF (instr_value <> 0) THEN
504: fnd_message.set_name('SQLGL', 'GL_CONS_LOOP_FOUND');
505: app_exception.raise_exception;
506: END IF;
507:
508: -- concatenate additional comma to the list
509: IF ((counter > 1) AND (prior_child_set_id IS NOT NULL) AND
542: htp.p('