DBA Data[Home] [Help]

APPS.POS_SUPP_PUB_RAISE_EVENT_PKG dependencies on FND_FILE

Line 407: fnd_file.put_line(fnd_file.log,'Exception:'||SQLCODE ||':'|| SQLERRM);

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);
411: ROLLBACK;

Line 410: fnd_file.put_line(fnd_file.log,'Exception:'||SQLCODE ||':'|| SQLERRM);

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);
414: ROLLBACK;

Line 413: fnd_file.put_line(fnd_file.log,'Exception:'||SQLCODE ||':'|| SQLERRM);

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);
414: ROLLBACK;
415: END raise_publish_supplier_event;
416:
417: PROCEDURE populate_bo_and_save_concur(x_errbuf OUT NOCOPY VARCHAR2,

Line 470: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);

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
472: ROLLBACK TO populate_bo_and_save;
473: x_return_status := fnd_api.g_ret_sts_unexp_error;
474: x_msg_count := 1;

Line 476: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);

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
478: ROLLBACK TO populate_bo_and_save;
479: x_return_status := fnd_api.g_ret_sts_unexp_error;
480:

Line 483: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);

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);
484: END;
485:
486: FUNCTION get_curr_supp_pub_event_id RETURN NUMBER IS
487:

Line 522: fnd_file.put_line(fnd_file.log,'Extracting the data for the Party Id:'||p_party_id(i));

518: BEGIN
519:
520: FOR i IN p_party_id.first .. p_party_id.last LOOP
521:
522: fnd_file.put_line(fnd_file.log,'Extracting the data for the Party Id:'||p_party_id(i));
523:
524: pos_supplier_bo_pkg.pos_get_supplier_bo(NULL,
525: NULL,
526: p_party_id(i),

Line 547: fnd_file.put_line(fnd_file.log,'Inserting the XML Payload into pos_supp_pub_history table');

543: IF l_xml_conversion_stats = 0 THEN
544: GOTO exit1;
545: END IF;
546:
547: fnd_file.put_line(fnd_file.log,'Inserting the XML Payload into pos_supp_pub_history table');
548: INSERT INTO pos_supp_pub_history
549: (publication_event_id,
550: party_id,
551: publication_date,

Line 591: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);

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
593: ROLLBACK;
594: x_return_status := fnd_api.g_ret_sts_unexp_error;
595: x_msg_count := 1;

Line 597: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);

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
599: ROLLBACK;
600: x_return_status := fnd_api.g_ret_sts_unexp_error;
601:

Line 604: fnd_file.put_line(fnd_file.log,'Exception:'||x_msg_data);

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);
605: END get_bo_and_insert;
606:
607: FUNCTION test_event_subscription(p_subscription_guid IN RAW,
608: p_event IN OUT NOCOPY wf_event_t)