DBA Data[Home] [Help]

APPS.GMD_SS_WFLOW_GRP dependencies on FND_API

Line 166: raise fnd_api.g_exc_error;

162: p_event_spec_disp.last_updated_by := ss_rec.created_by;
163: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (
164: p_sampling_event,
165: x_sampling_event ) THEN
166: raise fnd_api.g_exc_error;
167: END IF;
168: /* insert into bfs_msg
169: values
170: ( 'sampling_event_id = '||

Line 179: raise fnd_api.g_exc_error;

175: x_sampling_event_id := x_sampling_event.sampling_event_id;
176: IF not GMD_EVENT_SPEC_DISP_PVT.insert_row (
177: p_event_spec_disp,
178: x_event_spec_disp ) THEN
179: raise fnd_api.g_exc_error;
180: END IF;
181: /* insert into bfs_msg
182: values
183: ( 'event_spec_disp_id = '||

Line 192: WHEN FND_API.G_EXC_ERROR THEN

188: END IF;
189: CLOSE c_get_variant;
190: RETURN;
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: x_return_status := 'E';
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: x_return_status := 'U';
196: WHEN OTHERS THEN

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

190: RETURN;
191: EXCEPTION
192: WHEN FND_API.G_EXC_ERROR THEN
193: x_return_status := 'E';
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: x_return_status := 'U';
196: WHEN OTHERS THEN
197: x_return_status := 'E';
198: END variant_retained_sample;

Line 441: raise fnd_api.g_exc_error;

437: p_sampling_event.sample_active_cnt := 0;
438: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (
439: p_sampling_event,
440: x_sampling_event ) THEN
441: raise fnd_api.g_exc_error;
442: END IF;
443: -- insert into bfs_msg
444: --values
445: -- ( 'Var: sampling_event_id = '||

Line 462: raise fnd_api.g_exc_error;

458: x_sampling_event.sampling_event_id;
459: IF not GMD_EVENT_SPEC_DISP_PVT.insert_row (
460: p_event_spec_disp,
461: x_event_spec_disp ) THEN
462: raise fnd_api.g_exc_error;
463: END IF;
464: -- insert into bfs_msg
465: --values
466: --( 'Var: event_spec_disp_id = '||

Line 491: raise fnd_api.g_exc_error;

487: p_sample.sample_instance := smp_cnt;
488: IF not GMD_SAMPLES_PVT.insert_row (
489: p_sample,
490: x_sample ) THEN
491: raise fnd_api.g_exc_error;
492: END IF;
493: p_sample_spec_disp.sample_id := x_sample.sample_id;
494: -- insert into bfs_msg
495: -- values

Line 500: raise fnd_api.g_exc_error;

496: -- (' sample_id = ' || x_sample.sample_id );
497: --commit;
498: IF not GMD_SAMPLE_SPEC_DISP_PVT.insert_row (
499: p_sample_spec_disp ) THEN
500: raise fnd_api.g_exc_error;
501: END IF;
502: -- insert into bfs_msg
503: --values
504: --(' Sample Spec: sample_id = ' || x_sample.sample_id );

Line 536: raise fnd_api.g_exc_error;

532:
533: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (
534: p_sampling_event,
535: x_sampling_event ) THEN
536: raise fnd_api.g_exc_error;
537: END IF;
538: /* insert into bfs_msg
539: values
540: ( 'sampling_event_id = '||

Line 560: raise fnd_api.g_exc_error;

556:
557: IF not GMD_EVENT_SPEC_DISP_PVT.insert_row (
558: p_event_spec_disp,
559: x_event_spec_disp ) THEN
560: raise fnd_api.g_exc_error;
561: END IF;
562: /* insert into bfs_msg
563: values
564: ( 'event_spec_disp_id = '||

Line 596: raise fnd_api.g_exc_error;

592: p_sample.sample_instance := tp_cnt;
593: IF not GMD_SAMPLES_PVT.insert_row (
594: p_sample,
595: x_sample ) THEN
596: raise fnd_api.g_exc_error;
597: END IF;
598: /* insert into bfs_msg
599: values
600: (' sample_id = ' || x_sample.sample_id );

Line 605: raise fnd_api.g_exc_error;

601: commit; */
602: p_sample_spec_disp.sample_id := x_sample.sample_id;
603: IF not GMD_SAMPLE_SPEC_DISP_PVT.insert_row (
604: p_sample_spec_disp ) THEN
605: raise fnd_api.g_exc_error;
606:
607: END IF;
608: /* insert into bfs_msg
609: values

Line 634: raise fnd_api.g_exc_error;

630:
631: IF not GMD_SAMPLING_EVENTS_PVT.insert_row (
632: p_sampling_event,
633: x_sampling_event ) THEN
634: raise fnd_api.g_exc_error;
635: END IF;
636: /* insert into bfs_msg
637: values
638: ( 'Var: sampling_event_id = '||

Line 655: raise fnd_api.g_exc_error;

651: x_sampling_event.sampling_event_id;
652: IF not GMD_EVENT_SPEC_DISP_PVT.insert_row (
653: p_event_spec_disp,
654: x_event_spec_disp ) THEN
655: raise fnd_api.g_exc_error;
656: END IF;
657: /* insert into bfs_msg
658: values
659: ( 'Var: event_spec_disp_id = '||

Line 690: raise fnd_api.g_exc_error;

686:
687: IF not GMD_SAMPLES_PVT.insert_row (
688: p_sample,
689: x_sample ) THEN
690: raise fnd_api.g_exc_error;
691: END IF;
692: p_sample_spec_disp.sample_id := x_sample.sample_id;
693: /* insert into bfs_msg
694: values

Line 699: raise fnd_api.g_exc_error;

695: (' sample_id = ' || x_sample.sample_id );
696: commit; */
697: IF not GMD_SAMPLE_SPEC_DISP_PVT.insert_row (
698: p_sample_spec_disp ) THEN
699: raise fnd_api.g_exc_error;
700: END IF;
701: /* insert into bfs_msg
702: values
703: (' Sample Spec: sample_id = ' || x_sample.sample_id );

Line 721: WHEN FND_API.G_EXC_ERROR THEN

717: CLOSE c_get_ss;
718: COMMIT;
719: END IF;
720: EXCEPTION
721: WHEN FND_API.G_EXC_ERROR THEN
722: x_return_status := 'E';
723: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE',
724: 'GMD_SS_WFLOW_GRP.events_for_status_change',
725: 'ERROR', SUBSTR(SQLERRM,1,100),

Line 727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

723: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE',
724: 'GMD_SS_WFLOW_GRP.events_for_status_change',
725: 'ERROR', SUBSTR(SQLERRM,1,100),
726: 'POSITION',null);
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
728: x_return_status := 'U';
729: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE',
730: 'GMD_SS_WFLOW_GRP.events_for_status_change',
731: 'ERROR',