DBA Data[Home] [Help]

APPS.POS_IMP_SUPP_PKG dependencies on FND_MESSAGE

Line 350: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

346: WHERE batch_id = p_batch_id;
347:
348: EXCEPTION
349: WHEN no_data_found THEN
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;

Line 351: fnd_message.set_token('FK', 'p_batch_id');

347:
348: EXCEPTION
349: WHEN no_data_found THEN
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;

Line 352: fnd_message.set_token('COLUMN', 'batch_id');

348: EXCEPTION
349: WHEN no_data_found THEN
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;

Line 353: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');

349: WHEN no_data_found THEN
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:

Line 377: fnd_message.set_name('AR', 'HZ_INVALID_IMP_BATCH');

373: 'ACTION_REQUIRED');
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:

Line 436: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

432: ROLLBACK TO activate_batch;
433:
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,

Line 437: fnd_message.set_token('ERROR', SQLERRM);

433:
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,

Line 472: fnd_message.set_name('AR', 'HZ_IMP_DB_VER_CHECK');

468:
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,

Line 625: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

621: AND pos.batch_id = p_batch_id;
622:
623: EXCEPTION
624: WHEN no_data_found THEN
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;

Line 626: fnd_message.set_token('FK', 'p_batch_id');

622:
623: EXCEPTION
624: WHEN no_data_found THEN
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;

Line 627: fnd_message.set_token('COLUMN', 'batch_id');

623: EXCEPTION
624: WHEN no_data_found THEN
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;

Line 628: fnd_message.set_token('TABLE', 'pos_imp_batch_summary');

624: WHEN no_data_found THEN
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:

Line 659: fnd_message.set_name('AR', 'HZ_INVALID_IMP_BATCH');

655: 'ACTION_REQUIRED');
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:

Line 718: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

714: ROLLBACK TO reject_batch;
715:
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,

Line 719: fnd_message.set_token('ERROR', SQLERRM);

715:
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,

Line 776: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

772: AND orig_system <> 'SST'
773: AND status = 'A';
774: EXCEPTION
775: WHEN no_data_found THEN
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;

Line 777: fnd_message.set_token('FK', 'orig_system');

773: AND status = 'A';
774: EXCEPTION
775: WHEN no_data_found THEN
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;

Line 778: fnd_message.set_token('COLUMN', 'orig_system');

774: EXCEPTION
775: WHEN no_data_found THEN
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;

Line 779: fnd_message.set_token('TABLE', 'HZ_ORIG_SYSTEMS_B');

775: WHEN no_data_found THEN
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:

Line 846: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

842: ROLLBACK TO create_import_batch;
843:
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,

Line 847: fnd_message.set_token('ERROR', SQLERRM);

843:
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,