DBA Data[Home] [Help]

APPS.GMD_OPERATIONS_PUB dependencies on GMD_API_GRP

Line 81: l_entity_status gmd_api_grp.status_rec_type; ---bug# 3408799

77: v_oprn_class gmd_operations.oprn_class%TYPE;
78: l_retn_status VARCHAR2(1);
79: my_rsrc_table_type gmd_operation_resources_pub.gmd_oprn_resources_tbl_type;
80: l_api_version NUMBER := 1.0;
81: l_entity_status gmd_api_grp.status_rec_type; ---bug# 3408799
82: default_status_err EXCEPTION;
83: l_resource_count NUMBER;
84:
85: invalid_version EXCEPTION;

Line 110: IF NOT gmd_api_grp.setup_done THEN

106: fnd_msg_pub.initialize;
107: END IF;
108:
109: /* Intializes the setup fields */
110: IF NOT gmd_api_grp.setup_done THEN
111: gmd_api_grp.setup_done := gmd_api_grp.setup;
112: END IF;
113: IF NOT gmd_api_grp.setup_done THEN
114: RAISE setup_failure;

Line 111: gmd_api_grp.setup_done := gmd_api_grp.setup;

107: END IF;
108:
109: /* Intializes the setup fields */
110: IF NOT gmd_api_grp.setup_done THEN
111: gmd_api_grp.setup_done := gmd_api_grp.setup;
112: END IF;
113: IF NOT gmd_api_grp.setup_done THEN
114: RAISE setup_failure;
115: END IF;

Line 113: IF NOT gmd_api_grp.setup_done THEN

109: /* Intializes the setup fields */
110: IF NOT gmd_api_grp.setup_done THEN
111: gmd_api_grp.setup_done := gmd_api_grp.setup;
112: END IF;
113: IF NOT gmd_api_grp.setup_done THEN
114: RAISE setup_failure;
115: END IF;
116:
117: /* Initially let us assign the return status to success */

Line 143: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',

139: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_VERS');
140: FND_MSG_PUB.ADD;
141: RAISE ins_operation_err;
142: ELSIF p_operations.oprn_vers < 0 THEN
143: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',
144: 'FIELD', 'OPRN_VERS');
145: RAISE ins_operation_err;
146: END IF;
147:

Line 154: gmd_api_grp.log_message('FM_OPER_CODE_EXISTS');

150: v_oprn_vers := p_operations.oprn_vers;
151: /* call common function which checks for duplicate operation no and vers */
152: P_ret := gmdopval_pub.check_duplicate_oprn(v_oprn_no, v_oprn_vers, 'F');
153: IF p_ret <> 0 THEN
154: gmd_api_grp.log_message('FM_OPER_CODE_EXISTS');
155: RAISE ins_operation_err;
156: END IF;
157:
158: /* Description must be passed, otherwise give error */

Line 181: ELSIF (NOT(gmd_api_grp.validate_um(p_operations.PROCESS_QTY_UOM))) THEN

177: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_QTY_UOM');
178: FND_MSG_PUB.ADD;
179: RAISE ins_operation_err;
180: /* call common function to check if um passed is valid */
181: ELSIF (NOT(gmd_api_grp.validate_um(p_operations.PROCESS_QTY_UOM))) THEN
182: IF (l_debug = 'Y') THEN
183: gmd_debug.put_line('process qty uom invalid');
184: END IF;
185:

Line 203: IF NOT (GMD_API_GRP.OrgnAccessible (powner_orgn_id => p_operations.owner_organization_id) ) THEN

199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: -- Check if organization is accessible to the responsibility
203: IF NOT (GMD_API_GRP.OrgnAccessible (powner_orgn_id => p_operations.owner_organization_id) ) THEN
204: RAISE ins_operation_err;
205: END IF;
206:
207: --Check the organization id passed is process enabled if not raise an error message

Line 208: IF NOT (gmd_api_grp.check_orgn_status(p_operations.owner_organization_id)) THEN

204: RAISE ins_operation_err;
205: END IF;
206:
207: --Check the organization id passed is process enabled if not raise an error message
208: IF NOT (gmd_api_grp.check_orgn_status(p_operations.owner_organization_id)) THEN
209: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
210: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_operations.owner_organization_id);
211: FND_MSG_PUB.Add;
212: RAISE FND_API.G_EXC_ERROR;

Line 239: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',

235: END IF;
236: END IF;
237:
238: IF p_operations.minimum_transfer_qty < 0 THEN
239: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',
240: 'FIELD', 'MINIMUM_TRANSFER_QTY');
241: RAISE ins_operation_err;
242: END IF;
243:

Line 250: gmd_api_grp.log_message('FM_INV_OPRN_CLASS');

246: /* calls common funciton which checks if class is valid */
247: v_oprn_class := p_operations.oprn_class;
248: P_ret := gmdopval_pub.check_oprn_class(v_oprn_class, 'F');
249: IF P_ret <> 0 THEN
250: gmd_api_grp.log_message('FM_INV_OPRN_CLASS');
251: END IF;
252: END IF;
253:
254: OPEN Cur_gen_oprn_id;

Line 260: gmd_api_grp.log_message ('GMD_DETAILS_REQUIRED');

256: CLOSE cur_gen_oprn_id;
257:
258: /* At least one activity must be passed to add operation */
259: IF (p_oprn_actv_tbl.count = 0) THEN
260: gmd_api_grp.log_message ('GMD_DETAILS_REQUIRED');
261: RAISE ins_operation_err;
262: END IF;
263:
264: IF x_return_status = 'S' THEN

Line 283: gmd_api_grp.get_status_details(v_entity_type => 'OPERATION'

279: /* validate oprn activity info and insert oprn activity */
280: FOR i in 1.. p_oprn_actv_tbl.count LOOP
281: p_oprn_actv_tbl(i).oprn_id := p_operations.oprn_id;
282: --Getting the default status for the owner orgn code fo operation from parameters table w.r.t. bug#3408799
283: gmd_api_grp.get_status_details(v_entity_type => 'OPERATION'
284: ,v_orgn_id => p_operations.owner_organization_id -- w.r.t. 4004501
285: ,x_entity_status => l_entity_status);
286:
287: --Copy the all related resources for the context activity w.r.t. bug#3408799

Line 300: gmd_api_grp.log_message('GMD_RESOURCE_NOT_ATTACH');

296: END LOOP; --j in 1 ..p_oprn_rsrc_tbl.count
297:
298: --Raise error if default status is 400/700 and no activites are attached w.r.t. bug#3408799
299: IF l_entity_status.status_type IN (400,700) AND l_resource_count = 0 THEN
300: gmd_api_grp.log_message('GMD_RESOURCE_NOT_ATTACH');
301: RAISE ins_operation_err;
302: END IF; --l_entity_status.status_type IN (400,700) AND l_resource_count = 0
303:
304: GMD_OPERATION_ACTIVITIES_PUB.insert_operation_activity(p_init_msg_list => FALSE,

Line 323: gmd_api_grp.get_status_details(v_entity_type => 'OPERATION'

319: SAVEPOINT default_status_sp;
320:
321: /* -- Why call this again
322: --Getting the default status for the owner orgn code fo operation from parameters table w.r.t. bug#3408799
323: gmd_api_grp.get_status_details(v_entity_type => 'OPERATION'
324: ,v_orgn_code => p_operations.owner_orgn_code
325: ,x_entity_status => l_entity_status);
326:
327: */

Line 447: IF NOT gmd_api_grp.setup_done THEN

443: RAISE invalid_version;
444: END IF;
445:
446: /* Intializes the setup fields */
447: IF NOT gmd_api_grp.setup_done THEN
448: gmd_api_grp.setup_done := gmd_api_grp.setup;
449: END IF;
450: IF NOT gmd_api_grp.setup_done THEN
451: RAISE setup_failure;

Line 448: gmd_api_grp.setup_done := gmd_api_grp.setup;

444: END IF;
445:
446: /* Intializes the setup fields */
447: IF NOT gmd_api_grp.setup_done THEN
448: gmd_api_grp.setup_done := gmd_api_grp.setup;
449: END IF;
450: IF NOT gmd_api_grp.setup_done THEN
451: RAISE setup_failure;
452: END IF;

Line 450: IF NOT gmd_api_grp.setup_done THEN

446: /* Intializes the setup fields */
447: IF NOT gmd_api_grp.setup_done THEN
448: gmd_api_grp.setup_done := gmd_api_grp.setup;
449: END IF;
450: IF NOT gmd_api_grp.setup_done THEN
451: RAISE setup_failure;
452: END IF;
453:
454: /* Initially let us assign the return status to success */

Line 481: gmd_api_grp.log_message ('FM_INVOPRN');

477: ELSIF p_oprn_id IS NOT NULL THEN
478: OPEN check_oprn_id(p_oprn_id);
479: FETCH check_oprn_id INTO v_oprn_id;
480: IF check_oprn_id%NOTFOUND THEN
481: gmd_api_grp.log_message ('FM_INVOPRN');
482: RAISE upd_oprn_err;
483: END IF;
484: CLOSE check_oprn_id;
485: ELSIF ((p_oprn_no IS NOT NULL) AND (p_oprn_vers IS NOT NULL)) THEN

Line 489: gmd_api_grp.log_message ('FM_INVOPRN');

485: ELSIF ((p_oprn_no IS NOT NULL) AND (p_oprn_vers IS NOT NULL)) THEN
486: OPEN get_oprn_id(p_oprn_no, p_oprn_vers);
487: FETCH get_oprn_id INTO v_oprn_id;
488: IF get_oprn_id%NOTFOUND THEN
489: gmd_api_grp.log_message ('FM_INVOPRN');
490: RAISE upd_oprn_err;
491: END IF;
492: CLOSE get_oprn_id;
493: END IF;

Line 500: IF NOT (GMD_API_GRP.OrgnAccessible (powner_orgn_id => l_orgn_id ) ) THEN

496: -- Added the check for Org Responsibility access.
497: OPEN get_orgn_id(p_oprn_id);
498: FETCH get_orgn_id INTO l_orgn_id;
499: CLOSE get_orgn_id;
500: IF NOT (GMD_API_GRP.OrgnAccessible (powner_orgn_id => l_orgn_id ) ) THEN
501: RAISE upd_oprn_err;
502: END IF;
503:
504: /* Loop thru cols to be updated - verify col and value are present */

Line 517: IF (NOT(gmd_api_grp.validate_um(p_update_table(i).p_value))) THEN

513: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');
514: FND_MSG_PUB.ADD;
515: RAISE upd_oprn_err;
516: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'PROCESS_QTY_UOM' THEN
517: IF (NOT(gmd_api_grp.validate_um(p_update_table(i).p_value))) THEN
518: IF (l_debug = 'Y') THEN
519: gmd_debug.put_line('process qty uom invalid');
520: END IF;
521: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

Line 527: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',

523: RAISE upd_oprn_err;
524: END IF;
525: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'MINIMUM_TRANSFER_QTY' THEN
526: IF p_update_table(i).p_value < 0 THEN
527: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',
528: 'FIELD', 'MINIMUM_TRANSFER_QTY');
529: RAISE upd_oprn_err;
530: END IF;
531: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'OPRN_CLASS' THEN

Line 533: gmd_api_grp.log_message('FM_INV_OPRN_CLASS');

529: RAISE upd_oprn_err;
530: END IF;
531: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'OPRN_CLASS' THEN
532: IF gmdopval_pub.check_oprn_class(p_update_table(i).p_value, 'F') <> 0 THEN
533: gmd_api_grp.log_message('FM_INV_OPRN_CLASS');
534: RAISE upd_oprn_err;
535: END IF;
536: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'OPRN_DESC' THEN
537: IF p_update_table(i).p_value IS NULL THEN

Line 554: IF NOT GMD_API_GRP.OrgnAccessible(l_owner_orgn_id) THEN

550: END IF;
551: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'OWNER_ORGANIZATION_ID' THEN
552: /* Validation : Check if owner_orgn_idis valid */
553: l_owner_orgn_id := p_update_table(i).p_value;
554: IF NOT GMD_API_GRP.OrgnAccessible(l_owner_orgn_id) THEN
555: RAISE upd_oprn_err;
556: END IF;
557: END IF;
558:

Line 591: gmd_api_grp.log_message ('GMD_SAVED_CHANGES');

587: COMMIT;
588: END IF;
589:
590: /* Adding message to stack indicating the success of the routine */
591: gmd_api_grp.log_message ('GMD_SAVED_CHANGES');
592: END IF;
593:
594: FND_MSG_PUB.count_and_get(p_count => x_message_count
595: ,p_data => x_message_list);

Line 681: gmd_api_grp.log_message ('GMD_SAVED_CHANGES');

677: COMMIT;
678: END IF;
679:
680: /* Adding message to stack indicating the success of the routine */
681: gmd_api_grp.log_message ('GMD_SAVED_CHANGES');
682: FND_MSG_PUB.count_and_get(p_count => x_message_count
683: ,p_data => x_message_list);
684:
685: IF (l_debug = 'Y') THEN