DBA Data[Home] [Help]

APPS.GMD_VARIANT_TIME_POINT_GRP dependencies on GMD_VARIANT_TIME_POINT_GRP

Line 1: PACKAGE BODY GMD_VARIANT_TIME_POINT_GRP AS

1: PACKAGE BODY GMD_VARIANT_TIME_POINT_GRP AS
2: /* $Header: GMDGSVTB.pls 120.2.12020000.2 2012/10/19 03:08:29 guobxu ship $ */
3:
4: --
5: -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE

Line 136: --dbms_output.put_line('GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS_TIME_POINTS');

132: end loop;
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: --dbms_output.put_line('GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS_TIME_POINTS');
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));

Line 139: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS_TIME_POINTS',

135: WHEN OTHERS THEN
136: --dbms_output.put_line('GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS_TIME_POINTS');
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;

Line 249: --dbms_output.put_line('GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS');

245: end loop;
246: end loop;
247: EXCEPTION
248: WHEN OTHERS THEN
249: --dbms_output.put_line('GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS');
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));

Line 252: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS',

248: WHEN OTHERS THEN
249: --dbms_output.put_line('GMD_VARIANT_TIME_POINT_GRP.CREATE_VARIANTS');
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:

Line 352: --dbms_output.put_line('GMD_VARIANT_TIME_POINT_GRP.CREATE_TIME_POINTS');

348: p_created_by);
349: end loop;
350: EXCEPTION
351: WHEN OTHERS THEN
352: --dbms_output.put_line('GMD_VARIANT_TIME_POINT_GRP.CREATE_TIME_POINTS');
353: --dbms_output.put_line(SUBSTR(SQLERRM,1,100));
354:
355: GMD_API_PUB.Log_Message('GMD_API_ERROR',
356: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_TIME_POINTS',

Line 356: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.CREATE_TIME_POINTS',

352: --dbms_output.put_line('GMD_VARIANT_TIME_POINT_GRP.CREATE_TIME_POINTS');
353: --dbms_output.put_line(SUBSTR(SQLERRM,1,100));
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:

Line 427: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_VARIANTS',

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));
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
430: end delete_variants;
431:

Line 483: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.DELETE_TIME_POINTS',

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));
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: end delete_time_points;
487:

Line 518: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_VARIANT_SEQ',

514: end loop;
515: EXCEPTION
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:

Line 580: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC');

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
583: GMD_API_PUB.Log_Message('GMD_API_ERROR',
584: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC','ERROR', SUBSTR(SQLERRM,1,100));

Line 584: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_BASE_SPEC','ERROR', SUBSTR(SQLERRM,1,100));

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 ;
586: END update_base_spec ;
587:
588: PROCEDURE update_scheduled_start_date

Line 649: gmd_api_pub.log_message('GMD_REQ_FIELD_MIS','PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE');

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
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));

Line 653: 'PACKAGE','GMD_VARIANT_TIME_POINT_GRP.UPDATE_SCHEDULED_START_DATE','ERROR', SUBSTR(SQLERRM,1,100));

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 ;
655:
656: END update_scheduled_start_date;
657:

Line 666: END GMD_VARIANT_TIME_POINT_GRP; -- Package body

662: BEGIN
663: p_conc_id := FND_REQUEST.SUBMIT_REQUEST('GMD', 'SAMPLE_LABEL_GEN_STBL', '', '', FALSE,
664: '', '', '',',',p_variant_id, p_time_point_id);
665: END submit_srs_request;
666: END GMD_VARIANT_TIME_POINT_GRP; -- Package body