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.POS_SUPP_PUB_RAISE_EVENT_PKG dependencies on FND_API

Line 198: WHEN fnd_api.g_exc_error THEN

194:
195:
196: COMMIT;
197: EXCEPTION
198: WHEN fnd_api.g_exc_error THEN
199: ROLLBACK;
200: x_return_status := fnd_api.g_ret_sts_error;
201: x_msg_count := 1;
202: x_msg_data := SQLCODE || SQLERRM;

Line 200: x_return_status := fnd_api.g_ret_sts_error;

196: COMMIT;
197: EXCEPTION
198: WHEN fnd_api.g_exc_error THEN
199: ROLLBACK;
200: x_return_status := fnd_api.g_ret_sts_error;
201: x_msg_count := 1;
202: x_msg_data := SQLCODE || SQLERRM;
203: WHEN fnd_api.g_exc_unexpected_error THEN
204: ROLLBACK;

Line 203: WHEN fnd_api.g_exc_unexpected_error THEN

199: ROLLBACK;
200: x_return_status := fnd_api.g_ret_sts_error;
201: x_msg_count := 1;
202: x_msg_data := SQLCODE || SQLERRM;
203: WHEN fnd_api.g_exc_unexpected_error THEN
204: ROLLBACK;
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206: x_msg_count := 1;
207: x_msg_data := SQLCODE || SQLERRM;

Line 205: x_return_status := fnd_api.g_ret_sts_unexp_error;

201: x_msg_count := 1;
202: x_msg_data := SQLCODE || SQLERRM;
203: WHEN fnd_api.g_exc_unexpected_error THEN
204: ROLLBACK;
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206: x_msg_count := 1;
207: x_msg_data := SQLCODE || SQLERRM;
208: WHEN OTHERS THEN
209: ROLLBACK;

Line 210: x_return_status := fnd_api.g_ret_sts_unexp_error;

206: x_msg_count := 1;
207: x_msg_data := SQLCODE || SQLERRM;
208: WHEN OTHERS THEN
209: ROLLBACK;
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211: x_msg_count := 1;
212: x_msg_data := SQLCODE || SQLERRM;
213: END create_supp_publish_event;
214:

Line 355: WHEN fnd_api.g_exc_error THEN

351: AND publication_event_id = p_publication_event_id
352: AND party_id = p_party_id;
353:
354: EXCEPTION
355: WHEN fnd_api.g_exc_error THEN
356: ROLLBACK;
357: x_return_status := fnd_api.g_ret_sts_error;
358: x_msg_count := 1;
359: x_msg_data := SQLCODE || SQLERRM;

Line 357: x_return_status := fnd_api.g_ret_sts_error;

353:
354: EXCEPTION
355: WHEN fnd_api.g_exc_error THEN
356: ROLLBACK;
357: x_return_status := fnd_api.g_ret_sts_error;
358: x_msg_count := 1;
359: x_msg_data := SQLCODE || SQLERRM;
360: WHEN fnd_api.g_exc_unexpected_error THEN
361: ROLLBACK;

Line 360: WHEN fnd_api.g_exc_unexpected_error THEN

356: ROLLBACK;
357: x_return_status := fnd_api.g_ret_sts_error;
358: x_msg_count := 1;
359: x_msg_data := SQLCODE || SQLERRM;
360: WHEN fnd_api.g_exc_unexpected_error THEN
361: ROLLBACK;
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363: x_msg_count := 1;
364: x_msg_data := SQLCODE || SQLERRM;

Line 362: x_return_status := fnd_api.g_ret_sts_unexp_error;

358: x_msg_count := 1;
359: x_msg_data := SQLCODE || SQLERRM;
360: WHEN fnd_api.g_exc_unexpected_error THEN
361: ROLLBACK;
362: x_return_status := fnd_api.g_ret_sts_unexp_error;
363: x_msg_count := 1;
364: x_msg_data := SQLCODE || SQLERRM;
365: WHEN OTHERS THEN
366: ROLLBACK;

Line 367: x_return_status := fnd_api.g_ret_sts_unexp_error;

363: x_msg_count := 1;
364: x_msg_data := SQLCODE || SQLERRM;
365: WHEN OTHERS THEN
366: ROLLBACK;
367: x_return_status := fnd_api.g_ret_sts_unexp_error;
368:
369: x_msg_count := 1;
370: x_msg_data := SQLCODE || SQLERRM;
371: END update_supp_pub_resp;

Line 406: WHEN fnd_api.g_exc_error THEN

402:
403: COMMIT;
404: RETURN l_itemkey;
405: EXCEPTION
406: WHEN fnd_api.g_exc_error THEN
407: fnd_file.put_line(fnd_file.log,'Exception:'||SQLCODE ||':'|| SQLERRM);
408: ROLLBACK;
409: WHEN fnd_api.g_exc_unexpected_error THEN
410: fnd_file.put_line(fnd_file.log,'Exception:'||SQLCODE ||':'|| SQLERRM);

Line 409: WHEN fnd_api.g_exc_unexpected_error THEN

405: EXCEPTION
406: WHEN fnd_api.g_exc_error THEN
407: fnd_file.put_line(fnd_file.log,'Exception:'||SQLCODE ||':'|| SQLERRM);
408: ROLLBACK;
409: WHEN fnd_api.g_exc_unexpected_error THEN
410: fnd_file.put_line(fnd_file.log,'Exception:'||SQLCODE ||':'|| SQLERRM);
411: ROLLBACK;
412: WHEN OTHERS THEN
413: fnd_file.put_line(fnd_file.log,'Exception:'||SQLCODE ||':'|| SQLERRM);

Line 465: WHEN fnd_api.g_exc_error THEN

461: l_event_key := raise_publish_supplier_event(l_publication_event_id);
462: x_retcode := 0;
463: x_errbuf := '';
464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN
466: ROLLBACK TO populate_bo_and_save;
467: x_return_status := fnd_api.g_ret_sts_error;
468: x_msg_count := 1;
469: x_msg_data := SQLCODE || SQLERRM;

Line 467: x_return_status := fnd_api.g_ret_sts_error;

463: x_errbuf := '';
464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN
466: ROLLBACK TO populate_bo_and_save;
467: x_return_status := fnd_api.g_ret_sts_error;
468: x_msg_count := 1;
469: x_msg_data := SQLCODE || SQLERRM;
470: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
471: WHEN fnd_api.g_exc_unexpected_error THEN

Line 471: WHEN fnd_api.g_exc_unexpected_error THEN

467: x_return_status := fnd_api.g_ret_sts_error;
468: x_msg_count := 1;
469: x_msg_data := SQLCODE || SQLERRM;
470: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
471: WHEN fnd_api.g_exc_unexpected_error THEN
472: ROLLBACK TO populate_bo_and_save;
473: x_return_status := fnd_api.g_ret_sts_unexp_error;
474: x_msg_count := 1;
475: x_msg_data := SQLCODE || SQLERRM;

Line 473: x_return_status := fnd_api.g_ret_sts_unexp_error;

469: x_msg_data := SQLCODE || SQLERRM;
470: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
471: WHEN fnd_api.g_exc_unexpected_error THEN
472: ROLLBACK TO populate_bo_and_save;
473: x_return_status := fnd_api.g_ret_sts_unexp_error;
474: x_msg_count := 1;
475: x_msg_data := SQLCODE || SQLERRM;
476: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
477: WHEN OTHERS THEN

Line 479: x_return_status := fnd_api.g_ret_sts_unexp_error;

475: x_msg_data := SQLCODE || SQLERRM;
476: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
477: WHEN OTHERS THEN
478: ROLLBACK TO populate_bo_and_save;
479: x_return_status := fnd_api.g_ret_sts_unexp_error;
480:
481: x_msg_count := 1;
482: x_msg_data := SQLCODE || SQLERRM;
483: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);

Line 586: WHEN fnd_api.g_exc_error THEN

582: COMMIT;
583:
584: END LOOP;
585: EXCEPTION
586: WHEN fnd_api.g_exc_error THEN
587: ROLLBACK;
588: x_return_status := fnd_api.g_ret_sts_error;
589: x_msg_count := 1;
590: x_msg_data := SQLCODE || SQLERRM;

Line 588: x_return_status := fnd_api.g_ret_sts_error;

584: END LOOP;
585: EXCEPTION
586: WHEN fnd_api.g_exc_error THEN
587: ROLLBACK;
588: x_return_status := fnd_api.g_ret_sts_error;
589: x_msg_count := 1;
590: x_msg_data := SQLCODE || SQLERRM;
591: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
592: WHEN fnd_api.g_exc_unexpected_error THEN

Line 592: WHEN fnd_api.g_exc_unexpected_error THEN

588: x_return_status := fnd_api.g_ret_sts_error;
589: x_msg_count := 1;
590: x_msg_data := SQLCODE || SQLERRM;
591: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
592: WHEN fnd_api.g_exc_unexpected_error THEN
593: ROLLBACK;
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: x_msg_count := 1;
596: x_msg_data := SQLCODE || SQLERRM;

Line 594: x_return_status := fnd_api.g_ret_sts_unexp_error;

590: x_msg_data := SQLCODE || SQLERRM;
591: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
592: WHEN fnd_api.g_exc_unexpected_error THEN
593: ROLLBACK;
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: x_msg_count := 1;
596: x_msg_data := SQLCODE || SQLERRM;
597: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
598: WHEN OTHERS THEN

Line 600: x_return_status := fnd_api.g_ret_sts_unexp_error;

596: x_msg_data := SQLCODE || SQLERRM;
597: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);
598: WHEN OTHERS THEN
599: ROLLBACK;
600: x_return_status := fnd_api.g_ret_sts_unexp_error;
601:
602: x_msg_count := 1;
603: x_msg_data := SQLCODE || SQLERRM;
604: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);

Line 654: x_return_status := fnd_api.g_ret_sts_unexp_error;

650: FROM pos_supp_pub_history
651: WHERE publication_event_id = p_publication_event_id;
652: EXCEPTION
653: WHEN OTHERS THEN
654: x_return_status := fnd_api.g_ret_sts_unexp_error;
655: x_msg_count := 1;
656: x_msg_data := SQLCODE || SQLERRM;
657: END;
658: