1553: WHEN NO_DATA_FOUND THEN NULL;
1554: --insert into tmp2 values('WHEN NO_DATA_FOUND THEN NULL', 'WHEN NO_DATA_FOUND THEN NULL'); commit;
1555: WHEN OTHERS THEN
1556: --insert into tmp2 values('WHEN OTHERS THEN', 'WHEN OTHERS THEN'); commit;
1557: fnd_message.set_name ('JTF', 'JTF_TTY_ALIGN_UNEXPECTED_ERROR');
1558: x_msg_data := fnd_message.get();
1559: fnd_message.set_name ('JTF', x_msg_data);
1560:
1561: end;
1554: --insert into tmp2 values('WHEN NO_DATA_FOUND THEN NULL', 'WHEN NO_DATA_FOUND THEN NULL'); commit;
1555: WHEN OTHERS THEN
1556: --insert into tmp2 values('WHEN OTHERS THEN', 'WHEN OTHERS THEN'); commit;
1557: fnd_message.set_name ('JTF', 'JTF_TTY_ALIGN_UNEXPECTED_ERROR');
1558: x_msg_data := fnd_message.get();
1559: fnd_message.set_name ('JTF', x_msg_data);
1560:
1561: end;
1562:
1555: WHEN OTHERS THEN
1556: --insert into tmp2 values('WHEN OTHERS THEN', 'WHEN OTHERS THEN'); commit;
1557: fnd_message.set_name ('JTF', 'JTF_TTY_ALIGN_UNEXPECTED_ERROR');
1558: x_msg_data := fnd_message.get();
1559: fnd_message.set_name ('JTF', x_msg_data);
1560:
1561: end;
1562:
1563: