eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_VARIANT_TIME_POINT_GRP dependencies on FND_API

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64: l_scheduled_start_date Date; -- bug 14469494
65:
66:
67: BEGIN
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: l_variant_no := get_max_variant_no(p_stability_study);
71:
72:

Line 127: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

123: l_stab_study.actual_start_date,
124: l_stab_study.created_by,
125: l_return_status);
126:
127: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: end loop;

Line 128: RAISE FND_API.G_EXC_ERROR;

124: l_stab_study.created_by,
125: l_return_status);
126:
127: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
128: RAISE FND_API.G_EXC_ERROR;
129: END IF;
130:
131: end loop;
132: end loop;

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

137: --dbms_output.put_line(SUBSTR(SQLERRM,1,100));
138: GMD_API_PUB.Log_Message('GMD_API_ERROR',
139: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS_TIME_POINTS',
140: 'ERROR', SUBSTR(SQLERRM,1,100));
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142:
143: END create_variants_time_points;
144:
145:

Line 173: x_return_status := FND_API.G_RET_STS_SUCCESS;

169: l_variant_id NUMBER;
170: l_return_status VARCHAR2(1);
171:
172: begin
173: x_return_status := FND_API.G_RET_STS_SUCCESS;
174:
175:
176: for package_counter in 1..p_no_of_packages loop
177: for l_storage_plan in c_storage_plan(p_storage_plan_id) loop

Line 241: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

237: 1,
238: p_created_by,
239: l_return_status);
240:
241: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: end loop;

Line 242: RAISE FND_API.G_EXC_ERROR;

238: p_created_by,
239: l_return_status);
240:
241: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
242: RAISE FND_API.G_EXC_ERROR;
243: END IF;
244:
245: end loop;
246: end loop;

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

250: --dbms_output.put_line(SUBSTR(SQLERRM,1,100));
251: GMD_API_PUB.Log_Message('GMD_API_ERROR',
252: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS',
253: 'ERROR', SUBSTR(SQLERRM,1,100));
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
255: end create_variants;
256:
257: procedure create_time_points(p_variant_id NUMBER,
258: p_scheduled_start_date DATE,

Line 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278:
279: l_test_interval_plan_id NUMBER;
280:
281: begin
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283: if (p_test_interval_plan_id IS NULL) then
284: select a.test_interval_plan_id
285: into l_test_interval_plan_id
286: from gmd_storage_plan_details a,

Line 358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

354:
355: GMD_API_PUB.Log_Message('GMD_API_ERROR',
356: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_TIME_POINTS',
357: 'ERROR', SUBSTR(SQLERRM,1,100));
358: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
359: end create_time_points;
360:
361:
362: PROCEDURE delete_variants

Line 392: x_return_status := FND_API.G_RET_STS_SUCCESS;

388:
389:
390: begin
391:
392: x_return_status := FND_API.G_RET_STS_SUCCESS;
393:
394: OPEN c_ss_id;
395: FETCH c_ss_id into l_ss_id;
396: CLOSE c_ss_id;

Line 424: x_return_status := FND_API.G_RET_STS_ERROR ;

420: IF cr_time_points%ISOPEN THEN
421: CLOSE cr_time_points;
422: END IF;
423: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
424: x_return_status := FND_API.G_RET_STS_ERROR ;
425: WHEN OTHERS THEN
426: GMD_API_PUB.Log_Message('GMD_API_ERROR',
427: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_VARIANTS',
428: 'ERROR', SUBSTR(SQLERRM,1,100));

Line 429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

425: WHEN OTHERS THEN
426: GMD_API_PUB.Log_Message('GMD_API_ERROR',
427: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_VARIANTS',
428: 'ERROR', SUBSTR(SQLERRM,1,100));
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
430: end delete_variants;
431:
432:
433:

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

455:
456:
457: begin
458:
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461: -- lock the variants and time points before deleting.
462: -- mahesh
463:

Line 480: x_return_status := FND_API.G_RET_STS_ERROR ;

476: IF cr_time_points%ISOPEN THEN
477: CLOSE cr_time_points;
478: END IF;
479: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
480: x_return_status := FND_API.G_RET_STS_ERROR ;
481: WHEN OTHERS THEN
482: GMD_API_PUB.Log_Message('GMD_API_ERROR',
483: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_TIME_POINTS',
484: 'ERROR', SUBSTR(SQLERRM,1,100));

Line 485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

481: WHEN OTHERS THEN
482: GMD_API_PUB.Log_Message('GMD_API_ERROR',
483: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_TIME_POINTS',
484: 'ERROR', SUBSTR(SQLERRM,1,100));
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: end delete_time_points;
487:
488:
489: function get_max_variant_no(p_ss_id NUMBER) RETURN NUMBER IS

Line 520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

516: WHEN OTHERS THEN
517: GMD_API_PUB.Log_Message('GMD_API_ERROR',
518: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_VARIANT_SEQ',
519: 'ERROR', SUBSTR(SQLERRM,1,100));
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
521: end update_variant_seq;
522:
523:
524: PROCEDURE update_base_spec( p_ss_id IN NUMBER,

Line 546: x_return_status := FND_API.G_RET_STS_SUCCESS;

542: REQ_FIELDS_MISSING EXCEPTION;
543:
544: BEGIN
545:
546: x_return_status := FND_API.G_RET_STS_SUCCESS;
547:
548: IF p_ss_id IS NULL OR p_base_spec_id IS NULL THEN
549: RAISE REQ_FIELDS_MISSING ;
550: END IF;

Line 578: x_return_status := FND_API.G_RET_STS_ERROR ;

574: IF cr_time_points%ISOPEN THEN
575: CLOSE cr_time_points;
576: END IF;
577: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
578: x_return_status := FND_API.G_RET_STS_ERROR ;
579: WHEN REQ_FIELDS_MISSING THEN
580: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC');
581: x_return_status := FND_API.G_RET_STS_ERROR ;
582: WHEN OTHERS THEN

Line 581: x_return_status := FND_API.G_RET_STS_ERROR ;

577: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
578: x_return_status := FND_API.G_RET_STS_ERROR ;
579: WHEN REQ_FIELDS_MISSING THEN
580: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC');
581: x_return_status := FND_API.G_RET_STS_ERROR ;
582: WHEN OTHERS THEN
583: GMD_API_PUB.Log_Message('GMD_API_ERROR',
584: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC','ERROR', SUBSTR(SQLERRM,1,100));
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

581: x_return_status := FND_API.G_RET_STS_ERROR ;
582: WHEN OTHERS THEN
583: GMD_API_PUB.Log_Message('GMD_API_ERROR',
584: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC','ERROR', SUBSTR(SQLERRM,1,100));
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
586: END update_base_spec ;
587:
588: PROCEDURE update_scheduled_start_date
589: (p_ss_id IN NUMBER,

Line 612: x_return_status := FND_API.G_RET_STS_SUCCESS;

608: REQ_FIELDS_MISSING EXCEPTION;
609:
610: BEGIN
611:
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613:
614: IF p_ss_id IS NULL OR p_scheduled_start_date IS NULL THEN
615: RAISE REQ_FIELDS_MISSING ;
616: END IF;

Line 647: x_return_status := FND_API.G_RET_STS_ERROR ;

643: IF cr_time_points%ISOPEN THEN
644: CLOSE cr_time_points;
645: END IF;
646: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
647: x_return_status := FND_API.G_RET_STS_ERROR ;
648: WHEN REQ_FIELDS_MISSING THEN
649: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE');
650: x_return_status := FND_API.G_RET_STS_ERROR ;
651: WHEN OTHERS THEN

Line 650: x_return_status := FND_API.G_RET_STS_ERROR ;

646: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
647: x_return_status := FND_API.G_RET_STS_ERROR ;
648: WHEN REQ_FIELDS_MISSING THEN
649: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE');
650: x_return_status := FND_API.G_RET_STS_ERROR ;
651: WHEN OTHERS THEN
652: GMD_API_PUB.Log_Message('GMD_API_ERROR',
653: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE','ERROR', SUBSTR(SQLERRM,1,100));
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

650: x_return_status := FND_API.G_RET_STS_ERROR ;
651: WHEN OTHERS THEN
652: GMD_API_PUB.Log_Message('GMD_API_ERROR',
653: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE','ERROR', SUBSTR(SQLERRM,1,100));
654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
655:
656: END update_scheduled_start_date;
657:
658: