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 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: l_package_cnt NUMBER;
64:
65:
66: BEGIN
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: l_variant_no := get_max_variant_no(p_stability_study);
70:
71:

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

116: l_stab_study.actual_start_date,
117: l_stab_study.created_by,
118: l_return_status);
119:
120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
121: RAISE FND_API.G_EXC_ERROR;
122: END IF;
123:
124: end loop;

Line 121: RAISE FND_API.G_EXC_ERROR;

117: l_stab_study.created_by,
118: l_return_status);
119:
120: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
121: RAISE FND_API.G_EXC_ERROR;
122: END IF;
123:
124: end loop;
125: end loop;

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

130: --dbms_output.put_line(SUBSTR(SQLERRM,1,100));
131: GMD_API_PUB.Log_Message('GMD_API_ERROR',
132: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS_TIME_POINTS',
133: 'ERROR', SUBSTR(SQLERRM,1,100));
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
135:
136: END create_variants_time_points;
137:
138:

Line 166: x_return_status := FND_API.G_RET_STS_SUCCESS;

162: l_variant_id NUMBER;
163: l_return_status VARCHAR2(1);
164:
165: begin
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
167:
168:
169: for package_counter in 1..p_no_of_packages loop
170: for l_storage_plan in c_storage_plan(p_storage_plan_id) loop

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

230: 1,
231: p_created_by,
232: l_return_status);
233:
234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237:
238: end loop;

Line 235: RAISE FND_API.G_EXC_ERROR;

231: p_created_by,
232: l_return_status);
233:
234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237:
238: end loop;
239: end loop;

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

243: --dbms_output.put_line(SUBSTR(SQLERRM,1,100));
244: GMD_API_PUB.Log_Message('GMD_API_ERROR',
245: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS',
246: 'ERROR', SUBSTR(SQLERRM,1,100));
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: end create_variants;
249:
250: procedure create_time_points(p_variant_id NUMBER,
251: p_scheduled_start_date DATE,

Line 275: x_return_status := FND_API.G_RET_STS_SUCCESS;

271:
272: l_test_interval_plan_id NUMBER;
273:
274: begin
275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276: if (p_test_interval_plan_id IS NULL) then
277: select a.test_interval_plan_id
278: into l_test_interval_plan_id
279: from gmd_storage_plan_details a,

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

347:
348: GMD_API_PUB.Log_Message('GMD_API_ERROR',
349: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_TIME_POINTS',
350: 'ERROR', SUBSTR(SQLERRM,1,100));
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
352: end create_time_points;
353:
354:
355: PROCEDURE delete_variants

Line 385: x_return_status := FND_API.G_RET_STS_SUCCESS;

381:
382:
383: begin
384:
385: x_return_status := FND_API.G_RET_STS_SUCCESS;
386:
387: OPEN c_ss_id;
388: FETCH c_ss_id into l_ss_id;
389: CLOSE c_ss_id;

Line 417: x_return_status := FND_API.G_RET_STS_ERROR ;

413: IF cr_time_points%ISOPEN THEN
414: CLOSE cr_time_points;
415: END IF;
416: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
417: x_return_status := FND_API.G_RET_STS_ERROR ;
418: WHEN OTHERS THEN
419: GMD_API_PUB.Log_Message('GMD_API_ERROR',
420: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_VARIANTS',
421: 'ERROR', SUBSTR(SQLERRM,1,100));

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

418: WHEN OTHERS THEN
419: GMD_API_PUB.Log_Message('GMD_API_ERROR',
420: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_VARIANTS',
421: 'ERROR', SUBSTR(SQLERRM,1,100));
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: end delete_variants;
424:
425:
426:

Line 452: x_return_status := FND_API.G_RET_STS_SUCCESS;

448:
449:
450: begin
451:
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453:
454: -- lock the variants and time points before deleting.
455: -- mahesh
456:

Line 473: x_return_status := FND_API.G_RET_STS_ERROR ;

469: IF cr_time_points%ISOPEN THEN
470: CLOSE cr_time_points;
471: END IF;
472: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
473: x_return_status := FND_API.G_RET_STS_ERROR ;
474: WHEN OTHERS THEN
475: GMD_API_PUB.Log_Message('GMD_API_ERROR',
476: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_TIME_POINTS',
477: 'ERROR', SUBSTR(SQLERRM,1,100));

Line 478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

474: WHEN OTHERS THEN
475: GMD_API_PUB.Log_Message('GMD_API_ERROR',
476: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_TIME_POINTS',
477: 'ERROR', SUBSTR(SQLERRM,1,100));
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
479: end delete_time_points;
480:
481:
482: function get_max_variant_no(p_ss_id NUMBER) RETURN NUMBER IS

Line 513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

509: WHEN OTHERS THEN
510: GMD_API_PUB.Log_Message('GMD_API_ERROR',
511: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_VARIANT_SEQ',
512: 'ERROR', SUBSTR(SQLERRM,1,100));
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
514: end update_variant_seq;
515:
516:
517: PROCEDURE update_base_spec( p_ss_id IN NUMBER,

Line 539: x_return_status := FND_API.G_RET_STS_SUCCESS;

535: REQ_FIELDS_MISSING EXCEPTION;
536:
537: BEGIN
538:
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
540:
541: IF p_ss_id IS NULL OR p_base_spec_id IS NULL THEN
542: RAISE REQ_FIELDS_MISSING ;
543: END IF;

Line 571: x_return_status := FND_API.G_RET_STS_ERROR ;

567: IF cr_time_points%ISOPEN THEN
568: CLOSE cr_time_points;
569: END IF;
570: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
571: x_return_status := FND_API.G_RET_STS_ERROR ;
572: WHEN REQ_FIELDS_MISSING THEN
573: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC');
574: x_return_status := FND_API.G_RET_STS_ERROR ;
575: WHEN OTHERS THEN

Line 574: x_return_status := FND_API.G_RET_STS_ERROR ;

570: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
571: x_return_status := FND_API.G_RET_STS_ERROR ;
572: WHEN REQ_FIELDS_MISSING THEN
573: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC');
574: x_return_status := FND_API.G_RET_STS_ERROR ;
575: WHEN OTHERS THEN
576: GMD_API_PUB.Log_Message('GMD_API_ERROR',
577: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC','ERROR', SUBSTR(SQLERRM,1,100));
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

574: x_return_status := FND_API.G_RET_STS_ERROR ;
575: WHEN OTHERS THEN
576: GMD_API_PUB.Log_Message('GMD_API_ERROR',
577: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC','ERROR', SUBSTR(SQLERRM,1,100));
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
579: END update_base_spec ;
580:
581: PROCEDURE update_scheduled_start_date
582: (p_ss_id IN NUMBER,

Line 605: x_return_status := FND_API.G_RET_STS_SUCCESS;

601: REQ_FIELDS_MISSING EXCEPTION;
602:
603: BEGIN
604:
605: x_return_status := FND_API.G_RET_STS_SUCCESS;
606:
607: IF p_ss_id IS NULL OR p_scheduled_start_date IS NULL THEN
608: RAISE REQ_FIELDS_MISSING ;
609: END IF;

Line 640: x_return_status := FND_API.G_RET_STS_ERROR ;

636: IF cr_time_points%ISOPEN THEN
637: CLOSE cr_time_points;
638: END IF;
639: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
640: x_return_status := FND_API.G_RET_STS_ERROR ;
641: WHEN REQ_FIELDS_MISSING THEN
642: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE');
643: x_return_status := FND_API.G_RET_STS_ERROR ;
644: WHEN OTHERS THEN

Line 643: x_return_status := FND_API.G_RET_STS_ERROR ;

639: GMD_API_PUB.Log_Message('GMD_SS_VARIANTS_LOCKED');
640: x_return_status := FND_API.G_RET_STS_ERROR ;
641: WHEN REQ_FIELDS_MISSING THEN
642: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE');
643: x_return_status := FND_API.G_RET_STS_ERROR ;
644: WHEN OTHERS THEN
645: GMD_API_PUB.Log_Message('GMD_API_ERROR',
646: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE','ERROR', SUBSTR(SQLERRM,1,100));
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

643: x_return_status := FND_API.G_RET_STS_ERROR ;
644: WHEN OTHERS THEN
645: GMD_API_PUB.Log_Message('GMD_API_ERROR',
646: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE','ERROR', SUBSTR(SQLERRM,1,100));
647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
648:
649: END update_scheduled_start_date;
650:
651: