DBA Data[Home] [Help]

APPS.POS_IMP_SUPP_PKG dependencies on FND_MSG_PUB

Line 323: fnd_msg_pub.initialize;

319: -- Check if API is called in debug mode. If yes, enable debug.
320:
321: -- initialize message list if p_init_msg_list is set to TRUE.
322: IF fnd_api.to_boolean(p_init_msg_list) THEN
323: fnd_msg_pub.initialize;
324: END IF;
325:
326: -- initialize API return status to success.
327: x_return_status := fnd_api.g_ret_sts_success;

Line 354: fnd_msg_pub.add;

350: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
351: fnd_message.set_token('FK', 'p_batch_id');
352: fnd_message.set_token('COLUMN', 'batch_id');
353: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
354: fnd_msg_pub.add;
355: x_return_status := fnd_api.g_ret_sts_error;
356: END;
357:
358: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 378: fnd_msg_pub.add;

374:
375: EXCEPTION
376: WHEN no_data_found THEN
377: fnd_message.set_name('AR', 'HZ_INVALID_IMP_BATCH');
378: fnd_msg_pub.add;
379: x_return_status := fnd_api.g_ret_sts_error;
380: END;
381:
382: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 408: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

404: EXECUTE IMMEDIATE l_pre_count_stat
405: USING p_batch_id, l_original_system;
406:
407: -- standard call to get message count and if count is 1, get message info.
408: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
409: p_count => x_msg_count,
410: p_data => x_msg_data);
411:
412: EXCEPTION

Line 418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

414: ROLLBACK TO activate_batch;
415:
416: x_return_status := fnd_api.g_ret_sts_error;
417:
418: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
419: p_count => x_msg_count,
420: p_data => x_msg_data);
421:
422: WHEN fnd_api.g_exc_unexpected_error THEN

Line 427: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

423: ROLLBACK TO activate_batch;
424:
425: x_return_status := fnd_api.g_ret_sts_unexp_error;
426:
427: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
428: p_count => x_msg_count,
429: p_data => x_msg_data);
430:
431: WHEN OTHERS THEN

Line 438: fnd_msg_pub.add;

434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435:
436: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
437: fnd_message.set_token('ERROR', SQLERRM);
438: fnd_msg_pub.add;
439:
440: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
441: p_count => x_msg_count,
442: p_data => x_msg_data);

Line 440: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

436: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
437: fnd_message.set_token('ERROR', SQLERRM);
438: fnd_msg_pub.add;
439:
440: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
441: p_count => x_msg_count,
442: p_data => x_msg_data);
443:
444: END activate_batch;

Line 473: fnd_msg_pub.add;

469: EXCEPTION
470: WHEN fnd_api.g_exc_error THEN
471: ROLLBACK WORK;
472: fnd_message.set_name('AR', 'HZ_IMP_DB_VER_CHECK');
473: fnd_msg_pub.add;
474: fnd_msg_pub.reset;
475: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
476: l_error_message := fnd_msg_pub.get(p_msg_index => i,
477: p_encoded => fnd_api.g_false);

Line 474: fnd_msg_pub.reset;

470: WHEN fnd_api.g_exc_error THEN
471: ROLLBACK WORK;
472: fnd_message.set_name('AR', 'HZ_IMP_DB_VER_CHECK');
473: fnd_msg_pub.add;
474: fnd_msg_pub.reset;
475: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
476: l_error_message := fnd_msg_pub.get(p_msg_index => i,
477: p_encoded => fnd_api.g_false);
478: fnd_file.put_line(fnd_file.output, l_error_message);

Line 475: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP

471: ROLLBACK WORK;
472: fnd_message.set_name('AR', 'HZ_IMP_DB_VER_CHECK');
473: fnd_msg_pub.add;
474: fnd_msg_pub.reset;
475: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
476: l_error_message := fnd_msg_pub.get(p_msg_index => i,
477: p_encoded => fnd_api.g_false);
478: fnd_file.put_line(fnd_file.output, l_error_message);
479: fnd_file.put_line(fnd_file.log, l_error_message);

Line 476: l_error_message := fnd_msg_pub.get(p_msg_index => i,

472: fnd_message.set_name('AR', 'HZ_IMP_DB_VER_CHECK');
473: fnd_msg_pub.add;
474: fnd_msg_pub.reset;
475: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
476: l_error_message := fnd_msg_pub.get(p_msg_index => i,
477: p_encoded => fnd_api.g_false);
478: fnd_file.put_line(fnd_file.output, l_error_message);
479: fnd_file.put_line(fnd_file.log, l_error_message);
480: END LOOP;

Line 602: fnd_msg_pub.initialize;

598: -- Check if API is called in debug mode. If yes, enable debug.
599:
600: -- initialize message list if p_init_msg_list is set to TRUE.
601: IF fnd_api.to_boolean(p_init_msg_list) THEN
602: fnd_msg_pub.initialize;
603: END IF;
604:
605: -- initialize API return status to success.
606: x_return_status := fnd_api.g_ret_sts_success;

Line 629: fnd_msg_pub.add;

625: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
626: fnd_message.set_token('FK', 'p_batch_id');
627: fnd_message.set_token('COLUMN', 'batch_id');
628: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');
629: fnd_msg_pub.add;
630: x_return_status := fnd_api.g_ret_sts_error;
631: END;
632:
633: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 660: fnd_msg_pub.add;

656:
657: EXCEPTION
658: WHEN no_data_found THEN
659: fnd_message.set_name('AR', 'HZ_INVALID_IMP_BATCH');
660: fnd_msg_pub.add;
661: x_return_status := fnd_api.g_ret_sts_error;
662: END;
663:
664: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 690: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

686: last_update_login = hz_utility_v2pub.last_update_login
687: WHERE batch_id = p_batch_id;
688:
689: -- standard call to get message count and if count is 1, get message info.
690: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
691: p_count => x_msg_count,
692: p_data => x_msg_data);
693:
694: EXCEPTION

Line 700: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

696: ROLLBACK TO reject_batch;
697:
698: x_return_status := fnd_api.g_ret_sts_error;
699:
700: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
701: p_count => x_msg_count,
702: p_data => x_msg_data);
703:
704: WHEN fnd_api.g_exc_unexpected_error THEN

Line 709: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

705: ROLLBACK TO reject_batch;
706:
707: x_return_status := fnd_api.g_ret_sts_unexp_error;
708:
709: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
710: p_count => x_msg_count,
711: p_data => x_msg_data);
712:
713: WHEN OTHERS THEN

Line 720: fnd_msg_pub.add;

716: x_return_status := fnd_api.g_ret_sts_unexp_error;
717:
718: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
719: fnd_message.set_token('ERROR', SQLERRM);
720: fnd_msg_pub.add;
721:
722: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
723: p_count => x_msg_count,
724: p_data => x_msg_data);

Line 722: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

718: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
719: fnd_message.set_token('ERROR', SQLERRM);
720: fnd_msg_pub.add;
721:
722: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
723: p_count => x_msg_count,
724: p_data => x_msg_data);
725:
726: END reject_batch;

Line 780: fnd_msg_pub.add;

776: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
777: fnd_message.set_token('FK', 'orig_system');
778: fnd_message.set_token('COLUMN', 'orig_system');
779: fnd_message.set_token('TABLE', 'HZ_ORIG_SYSTEMS_B');
780: fnd_msg_pub.add;
781: x_return_status := fnd_api.g_ret_sts_error;
782: END;
783:
784: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 818: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

814: hz_utility_v2pub.last_update_date,
815: hz_utility_v2pub.last_update_login);
816:
817: -- standard call to get message count and if count is 1, get message info.
818: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
819: p_count => x_msg_count,
820: p_data => x_msg_data);
821:
822: EXCEPTION

Line 828: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

824: ROLLBACK TO create_import_batch;
825:
826: x_return_status := fnd_api.g_ret_sts_error;
827:
828: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
829: p_count => x_msg_count,
830: p_data => x_msg_data);
831:
832: WHEN fnd_api.g_exc_unexpected_error THEN

Line 837: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

833: ROLLBACK TO create_import_batch;
834:
835: x_return_status := fnd_api.g_ret_sts_unexp_error;
836:
837: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
838: p_count => x_msg_count,
839: p_data => x_msg_data);
840:
841: WHEN OTHERS THEN

Line 848: fnd_msg_pub.add;

844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
847: fnd_message.set_token('ERROR', SQLERRM);
848: fnd_msg_pub.add;
849:
850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
851: p_count => x_msg_count,
852: p_data => x_msg_data);

Line 850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

846: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
847: fnd_message.set_token('ERROR', SQLERRM);
848: fnd_msg_pub.add;
849:
850: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
851: p_count => x_msg_count,
852: p_data => x_msg_data);
853:
854: END create_import_batch;