eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_SERIAL_EO_PVT dependencies on FND_MSG_PUB

Line 120: fnd_msg_pub.ADD;

116: mydebug('Program insert_range_serial has failed with a Unexpected exception');
117: END IF;
118: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
119: FND_MESSAGE.SET_TOKEN('PROG_NAME','insert_range_serial');
120: fnd_msg_pub.ADD;
121: RAISE g_exc_unexpected_error;
122: END IF;
123:
124: mydebug('End of the program insert_range_serial. Program has completed successfully ');

Line 132: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

128: EXCEPTION
129: WHEN NO_DATA_FOUND THEN
130: x_return_status := fnd_api.g_ret_sts_error;
131: ROLLBACK TO inv_new_serial;
132: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
133: if( x_msg_count > 1 ) then
134: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
135: end if;
136: mydebug('In No data found ' || SQLERRM);

Line 134: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

130: x_return_status := fnd_api.g_ret_sts_error;
131: ROLLBACK TO inv_new_serial;
132: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
133: if( x_msg_count > 1 ) then
134: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
135: end if;
136: mydebug('In No data found ' || SQLERRM);
137: WHEN g_exc_error THEN
138: x_return_status := fnd_api.g_ret_sts_error;

Line 140: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

136: mydebug('In No data found ' || SQLERRM);
137: WHEN g_exc_error THEN
138: x_return_status := fnd_api.g_ret_sts_error;
139: ROLLBACK TO inv_new_serial;
140: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
141: if( x_msg_count > 1 ) then
142: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
143: end if;
144: mydebug('In g_exc_error ' || SQLERRM);

Line 142: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

138: x_return_status := fnd_api.g_ret_sts_error;
139: ROLLBACK TO inv_new_serial;
140: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
141: if( x_msg_count > 1 ) then
142: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
143: end if;
144: mydebug('In g_exc_error ' || SQLERRM);
145: WHEN g_exc_unexpected_error THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 148: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

144: mydebug('In g_exc_error ' || SQLERRM);
145: WHEN g_exc_unexpected_error THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: ROLLBACK TO inv_new_serial;
148: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
149: if( x_msg_count > 1 ) then
150: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
151: end if;
152: mydebug('In g_exc_unexpected_error ' || SQLERRM);

Line 150: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: ROLLBACK TO inv_new_serial;
148: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
149: if( x_msg_count > 1 ) then
150: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
151: end if;
152: mydebug('In g_exc_unexpected_error ' || SQLERRM);
153: WHEN OTHERS THEN
154: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 156: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

152: mydebug('In g_exc_unexpected_error ' || SQLERRM);
153: WHEN OTHERS THEN
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: ROLLBACK TO inv_new_serial;
156: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
157: if( x_msg_count > 1 ) then
158: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
159: end if;
160: mydebug('In others ' || SQLERRM);

Line 158: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: ROLLBACK TO inv_new_serial;
156: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
157: if( x_msg_count > 1 ) then
158: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
159: end if;
160: mydebug('In others ' || SQLERRM);
161:
162: END preprocess_serial;

Line 589: fnd_msg_pub.ADD;

585: mydebug('Program insert_range_serial has failed with a Unexpected exception');
586: END IF;
587: FND_MESSAGE.SET_NAME('INV','INV_PROGRAM_ERROR');
588: FND_MESSAGE.SET_TOKEN('PROG_NAME','insert_range_serial');
589: fnd_msg_pub.ADD;
590: RAISE g_exc_unexpected_error;
591: END IF;
592:
593: -- then call the update attribute routine to update the attributes

Line 703: fnd_msg_pub.ADD;

699: IF (l_validation_status <> 'Y'
700: OR x_return_status <> 'S') THEN
701: --raise error
702: fnd_message.set_name ('INV' , 'INV_FAIL_VALIDATE_SERIAL' );
703: fnd_msg_pub.ADD;
704:
705: RAISE fnd_api.g_exc_error;
706: END IF;
707:

Line 740: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

736: EXCEPTION
737: WHEN NO_DATA_FOUND THEN
738: x_return_status := fnd_api.g_ret_sts_error;
739: ROLLBACK TO inv_update_serial;
740: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
741: if( x_msg_count > 1 ) then
742: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
743: end if;
744: mydebug('In No data found ' || SQLERRM);

Line 742: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

738: x_return_status := fnd_api.g_ret_sts_error;
739: ROLLBACK TO inv_update_serial;
740: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
741: if( x_msg_count > 1 ) then
742: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
743: end if;
744: mydebug('In No data found ' || SQLERRM);
745: WHEN g_exc_error THEN
746: x_return_status := fnd_api.g_ret_sts_error;

Line 748: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

744: mydebug('In No data found ' || SQLERRM);
745: WHEN g_exc_error THEN
746: x_return_status := fnd_api.g_ret_sts_error;
747: ROLLBACK TO inv_update_serial;
748: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
749: if( x_msg_count > 1 ) then
750: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
751: end if;
752: mydebug('In g_exc_error ' || SQLERRM);

Line 750: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

746: x_return_status := fnd_api.g_ret_sts_error;
747: ROLLBACK TO inv_update_serial;
748: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
749: if( x_msg_count > 1 ) then
750: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
751: end if;
752: mydebug('In g_exc_error ' || SQLERRM);
753: WHEN g_exc_unexpected_error THEN
754: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 756: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

752: mydebug('In g_exc_error ' || SQLERRM);
753: WHEN g_exc_unexpected_error THEN
754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: ROLLBACK TO inv_update_serial;
756: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
757: if( x_msg_count > 1 ) then
758: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
759: end if;
760: mydebug('In g_exc_unexpected_error ' || SQLERRM);

Line 758: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

754: x_return_status := fnd_api.g_ret_sts_unexp_error;
755: ROLLBACK TO inv_update_serial;
756: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
757: if( x_msg_count > 1 ) then
758: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
759: end if;
760: mydebug('In g_exc_unexpected_error ' || SQLERRM);
761: WHEN OTHERS THEN
762: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 764: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

760: mydebug('In g_exc_unexpected_error ' || SQLERRM);
761: WHEN OTHERS THEN
762: x_return_status := fnd_api.g_ret_sts_unexp_error;
763: ROLLBACK TO inv_update_serial;
764: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
765: if( x_msg_count > 1 ) then
766: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
767: end if;
768: mydebug('In others ' || SQLERRM);

Line 766: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);

762: x_return_status := fnd_api.g_ret_sts_unexp_error;
763: ROLLBACK TO inv_update_serial;
764: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
765: if( x_msg_count > 1 ) then
766: x_msg_data := fnd_msg_pub.get(x_msg_count, FND_API.G_FALSE);
767: end if;
768: mydebug('In others ' || SQLERRM);
769:
770: