477: --(' sample_no = ' || p_sample.sample_no );
478: --commit;
479:
480: l_msg := NULL;
481: fnd_message.set_name('GMD','GMD_SS_VARIANT_SAMPLE_DESC');
482: fnd_message.set_token('VARIANT', var_rec.variant_no);
483: fnd_message.set_token('INST', smp_cnt);
484: l_msg := fnd_message.get;
485:
478: --commit;
479:
480: l_msg := NULL;
481: fnd_message.set_name('GMD','GMD_SS_VARIANT_SAMPLE_DESC');
482: fnd_message.set_token('VARIANT', var_rec.variant_no);
483: fnd_message.set_token('INST', smp_cnt);
484: l_msg := fnd_message.get;
485:
486: p_sample.sample_desc := l_msg;
479:
480: l_msg := NULL;
481: fnd_message.set_name('GMD','GMD_SS_VARIANT_SAMPLE_DESC');
482: fnd_message.set_token('VARIANT', var_rec.variant_no);
483: fnd_message.set_token('INST', smp_cnt);
484: l_msg := fnd_message.get;
485:
486: p_sample.sample_desc := l_msg;
487: p_sample.sample_instance := smp_cnt;
480: l_msg := NULL;
481: fnd_message.set_name('GMD','GMD_SS_VARIANT_SAMPLE_DESC');
482: fnd_message.set_token('VARIANT', var_rec.variant_no);
483: fnd_message.set_token('INST', smp_cnt);
484: l_msg := fnd_message.get;
485:
486: p_sample.sample_desc := l_msg;
487: p_sample.sample_instance := smp_cnt;
488: IF not GMD_SAMPLES_PVT.insert_row (
583: values
584: (' sample_no = ' || p_sample.sample_no );
585: commit; */
586: l_msg := NULL;
587: fnd_message.set_name('GMD','GMD_SS_TP_SAMPLE_DESC');
588: fnd_message.set_token('VARIANT', var_rec.variant_no);
589: fnd_message.set_token('TIMEPOINT', tp_cnt);
590: l_msg := fnd_message.get;
591: p_sample.sample_desc := l_msg;
584: (' sample_no = ' || p_sample.sample_no );
585: commit; */
586: l_msg := NULL;
587: fnd_message.set_name('GMD','GMD_SS_TP_SAMPLE_DESC');
588: fnd_message.set_token('VARIANT', var_rec.variant_no);
589: fnd_message.set_token('TIMEPOINT', tp_cnt);
590: l_msg := fnd_message.get;
591: p_sample.sample_desc := l_msg;
592: p_sample.sample_instance := tp_cnt;
585: commit; */
586: l_msg := NULL;
587: fnd_message.set_name('GMD','GMD_SS_TP_SAMPLE_DESC');
588: fnd_message.set_token('VARIANT', var_rec.variant_no);
589: fnd_message.set_token('TIMEPOINT', tp_cnt);
590: l_msg := fnd_message.get;
591: p_sample.sample_desc := l_msg;
592: p_sample.sample_instance := tp_cnt;
593: IF not GMD_SAMPLES_PVT.insert_row (
586: l_msg := NULL;
587: fnd_message.set_name('GMD','GMD_SS_TP_SAMPLE_DESC');
588: fnd_message.set_token('VARIANT', var_rec.variant_no);
589: fnd_message.set_token('TIMEPOINT', tp_cnt);
590: l_msg := fnd_message.get;
591: p_sample.sample_desc := l_msg;
592: p_sample.sample_instance := tp_cnt;
593: IF not GMD_SAMPLES_PVT.insert_row (
594: p_sample,
673: (' sample_no = ' || p_sample.sample_no );
674: commit; */
675:
676: l_msg := NULL;
677: fnd_message.set_name('GMD','GMD_SS_VARIANT_SAMPLE_DESC');
678: fnd_message.set_token('VARIANT', var_rec.variant_no);
679: fnd_message.set_token('INST', smp_cnt);
680: l_msg := fnd_message.get;
681:
674: commit; */
675:
676: l_msg := NULL;
677: fnd_message.set_name('GMD','GMD_SS_VARIANT_SAMPLE_DESC');
678: fnd_message.set_token('VARIANT', var_rec.variant_no);
679: fnd_message.set_token('INST', smp_cnt);
680: l_msg := fnd_message.get;
681:
682: p_sample.sample_desc := l_msg;
675:
676: l_msg := NULL;
677: fnd_message.set_name('GMD','GMD_SS_VARIANT_SAMPLE_DESC');
678: fnd_message.set_token('VARIANT', var_rec.variant_no);
679: fnd_message.set_token('INST', smp_cnt);
680: l_msg := fnd_message.get;
681:
682: p_sample.sample_desc := l_msg;
683: p_sample.sample_instance := smp_cnt;
676: l_msg := NULL;
677: fnd_message.set_name('GMD','GMD_SS_VARIANT_SAMPLE_DESC');
678: fnd_message.set_token('VARIANT', var_rec.variant_no);
679: fnd_message.set_token('INST', smp_cnt);
680: l_msg := fnd_message.get;
681:
682: p_sample.sample_desc := l_msg;
683: p_sample.sample_instance := smp_cnt;
684: