148: END LOOP;
149:
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_TRANS') );
153: WHEN TOO_MANY_ROWS THEN
154: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
155:
156: END GET_DETAILS_TRANS;
150: EXCEPTION
151: WHEN NO_DATA_FOUND THEN
152: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_TRANS') );
153: WHEN TOO_MANY_ROWS THEN
154: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
155:
156: END GET_DETAILS_TRANS;
157:
158:
238: END;
239:
240: EXCEPTION
241: WHEN NO_DATA_FOUND THEN
242: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_FOUND') );
243: WHEN OTHERS THEN
244: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
245:
246: END GET_DETAILS_RULE;
240: EXCEPTION
241: WHEN NO_DATA_FOUND THEN
242: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_FOUND') );
243: WHEN OTHERS THEN
244: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
245:
246: END GET_DETAILS_RULE;
247:
248:
373: END LOOP;
374:
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN
377: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_TRANS') );
378: WHEN TOO_MANY_ROWS THEN
379: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
380:
381: END GET_TVAR_RULE_DETAIL;
375: EXCEPTION
376: WHEN NO_DATA_FOUND THEN
377: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_TRANS') );
378: WHEN TOO_MANY_ROWS THEN
379: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
380:
381: END GET_TVAR_RULE_DETAIL;
382:
383:
470: END;
471:
472: EXCEPTION
473: WHEN NO_DATA_FOUND THEN
474: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_FOUND') );
475: WHEN OTHERS THEN
476: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
477:
478: END GET_RVAR_RULE_DETAIL;
472: EXCEPTION
473: WHEN NO_DATA_FOUND THEN
474: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_FOUND') );
475: WHEN OTHERS THEN
476: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
477:
478: END GET_RVAR_RULE_DETAIL;
479:
480:
584: END LOOP;
585:
586: EXCEPTION
587: WHEN NO_DATA_FOUND THEN
588: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_TRANS') );
589: WHEN OTHERS THEN
590: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
591:
592: END GET_TRANS_RULES;
586: EXCEPTION
587: WHEN NO_DATA_FOUND THEN
588: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_TRANS') );
589: WHEN OTHERS THEN
590: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
591:
592: END GET_TRANS_RULES;
593:
594:
678: END;
679:
680: EXCEPTION
681: WHEN NO_DATA_FOUND THEN
682: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_FOUND') );
683: WHEN OTHERS THEN
684: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
685:
686: END GET_RULE_DETAIL;
680: EXCEPTION
681: WHEN NO_DATA_FOUND THEN
682: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_FOUND') );
683: WHEN OTHERS THEN
684: fnd_file.put_line(fnd_file.output, fnd_message.get_string('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
685:
686: END GET_RULE_DETAIL;
687:
688:
791: END LOOP;
792:
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('EDR', 'EDR_PLS_RULE_NOT_TRANS') );
796: WHEN OTHERS THEN
797: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
798:
799: END SET_TRANSACTION_DETAILS;
793: EXCEPTION
794: WHEN NO_DATA_FOUND THEN
795: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('EDR', 'EDR_PLS_RULE_NOT_TRANS') );
796: WHEN OTHERS THEN
797: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
798:
799: END SET_TRANSACTION_DETAILS;
800:
801:
880: END;
881:
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('EDR', 'EDR_PLS_RULE_NOT_FOUND') );
885: WHEN OTHERS THEN
886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
887:
888: END SET_RULE_DETAILS;
882: EXCEPTION
883: WHEN NO_DATA_FOUND THEN
884: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('EDR', 'EDR_PLS_RULE_NOT_FOUND') );
885: WHEN OTHERS THEN
886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('EDR', 'EDR_PLS_RULE_NOT_UNIQUE') );
887:
888: END SET_RULE_DETAILS;
889:
890: