DBA Data[Home] [Help]

APPS.GMD_OPERATIONS_PUB dependencies on FND_MESSAGE

Line 122: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

118: IF (l_debug = 'Y') THEN
119: gmd_debug.put_line('operation number required');
120: END IF;
121:
122: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
123: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO');
124: FND_MSG_PUB.ADD;
125: RAISE ins_operation_err;
126: END IF;

Line 123: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO');

119: gmd_debug.put_line('operation number required');
120: END IF;
121:
122: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
123: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO');
124: FND_MSG_PUB.ADD;
125: RAISE ins_operation_err;
126: END IF;
127:

Line 134: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

130: IF (l_debug = 'Y') THEN
131: gmd_debug.put_line('operation version required');
132: END IF;
133:
134: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
135: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_VERS');
136: FND_MSG_PUB.ADD;
137: RAISE ins_operation_err;
138: ELSIF p_operations.oprn_vers < 0 THEN

Line 135: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_VERS');

131: gmd_debug.put_line('operation version required');
132: END IF;
133:
134: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
135: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_VERS');
136: FND_MSG_PUB.ADD;
137: RAISE ins_operation_err;
138: ELSIF p_operations.oprn_vers < 0 THEN
139: gmd_api_grp.log_message ('GMD_NEGATIVE_FIELDS',

Line 160: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

156: IF (l_debug = 'Y') THEN
157: gmd_debug.put_line('operation desc required');
158: END IF;
159:
160: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
161: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_DESC');
162: FND_MSG_PUB.ADD;
163: RAISE ins_operation_err;
164: END IF;

Line 161: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_DESC');

157: gmd_debug.put_line('operation desc required');
158: END IF;
159:
160: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
161: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_DESC');
162: FND_MSG_PUB.ADD;
163: RAISE ins_operation_err;
164: END IF;
165:

Line 172: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

168: IF (l_debug = 'Y') THEN
169: gmd_debug.put_line('process qty uom required');
170: END IF;
171:
172: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
173: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_QTY_UOM');
174: FND_MSG_PUB.ADD;
175: RAISE ins_operation_err;
176: /* call common function to check if um passed is valid */

Line 173: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_QTY_UOM');

169: gmd_debug.put_line('process qty uom required');
170: END IF;
171:
172: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
173: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_QTY_UOM');
174: FND_MSG_PUB.ADD;
175: RAISE ins_operation_err;
176: /* call common function to check if um passed is valid */
177: ELSIF (NOT(gmd_api_grp.validate_um(p_operations.PROCESS_QTY_UOM))) THEN

Line 182: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

178: IF (l_debug = 'Y') THEN
179: gmd_debug.put_line('process qty uom invalid');
180: END IF;
181:
182: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
183: FND_MSG_PUB.ADD;
184: RAISE ins_operation_err;
185: END IF;
186:

Line 193: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');

189: *
190: */
191: --Check that organization id is not null if raise an error message
192: IF (p_operations.owner_organization_id IS NULL) THEN
193: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');
194: FND_MSG_PUB.Add;
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:

Line 205: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');

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

Line 206: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_operations.owner_organization_id);

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

Line 225: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');

221: IF p_operations.effective_start_date > p_operations.effective_end_date THEN
222: IF (l_debug = 'Y') THEN
223: gmd_debug.put_line('effective start date must be less then end date');
224: END IF;
225: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
226: FND_MSG_PUB.ADD;
227: RAISE ins_operation_err;
228: END IF;
229: END IF;

Line 366: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

362: p_data => x_message_list );
363: WHEN OTHERS THEN
364: ROLLBACK TO SAVEPOINT insert_oprn;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
367: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
368: FND_MSG_PUB.ADD;
369: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
370: P_data => x_message_list);

Line 367: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

363: WHEN OTHERS THEN
364: ROLLBACK TO SAVEPOINT insert_oprn;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
367: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
368: FND_MSG_PUB.ADD;
369: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
370: P_data => x_message_list);
371: END Insert_Operation;

Line 461: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

457: gmd_debug.put_line('operation id or operation number and version are required');
458: END IF;
459:
460: IF (p_oprn_id IS NULL) THEN
461: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
462: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');
463: FND_MSG_PUB.ADD;
464: ELSE
465: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

Line 462: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');

458: END IF;
459:
460: IF (p_oprn_id IS NULL) THEN
461: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
462: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');
463: FND_MSG_PUB.ADD;
464: ELSE
465: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
466: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO, OPRN_VERS');

Line 465: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

461: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
462: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');
463: FND_MSG_PUB.ADD;
464: ELSE
465: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
466: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO, OPRN_VERS');
467: FND_MSG_PUB.ADD;
468: END IF;
469: RAISE upd_oprn_err;

Line 466: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO, OPRN_VERS');

462: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');
463: FND_MSG_PUB.ADD;
464: ELSE
465: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
466: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO, OPRN_VERS');
467: FND_MSG_PUB.ADD;
468: END IF;
469: RAISE upd_oprn_err;
470: ELSIF p_oprn_id IS NOT NULL THEN

Line 505: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

501: IF (l_debug = 'Y') THEN
502: gmd_debug.put_line('col_to_update required');
503: END IF;
504:
505: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
506: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');
507: FND_MSG_PUB.ADD;
508: RAISE upd_oprn_err;
509: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'PROCESS_QTY_UOM' THEN

Line 506: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');

502: gmd_debug.put_line('col_to_update required');
503: END IF;
504:
505: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
506: FND_MESSAGE.SET_TOKEN ('MISSING', 'COL_TO_UPDATE');
507: FND_MSG_PUB.ADD;
508: RAISE upd_oprn_err;
509: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'PROCESS_QTY_UOM' THEN
510: IF (NOT(gmd_api_grp.validate_um(p_update_table(i).p_value))) THEN

Line 514: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

510: IF (NOT(gmd_api_grp.validate_um(p_update_table(i).p_value))) THEN
511: IF (l_debug = 'Y') THEN
512: gmd_debug.put_line('process qty uom invalid');
513: END IF;
514: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
515: FND_MSG_PUB.ADD;
516: RAISE upd_oprn_err;
517: END IF;
518: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'MINIMUM_TRANSFER_QTY' THEN

Line 531: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

527: RAISE upd_oprn_err;
528: END IF;
529: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'OPRN_DESC' THEN
530: IF p_update_table(i).p_value IS NULL THEN
531: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
532: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_DESC');
533: FND_MSG_PUB.ADD;
534: RAISE upd_oprn_err;
535: END IF;

Line 532: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_DESC');

528: END IF;
529: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'OPRN_DESC' THEN
530: IF p_update_table(i).p_value IS NULL THEN
531: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
532: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_DESC');
533: FND_MSG_PUB.ADD;
534: RAISE upd_oprn_err;
535: END IF;
536: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'DELETE_MARK' THEN

Line 540: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');

536: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'DELETE_MARK' THEN
537: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(i).p_value,
538: x_return_status => l_retn_status);
539: IF l_retn_status <> 'S' THEN /* it indicates that invalid value has been passed */
540: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');
541: FND_MSG_PUB.ADD;
542: RAISE upd_oprn_err;
543: END IF;
544: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'OWNER_ORGANIZATION_ID' THEN

Line 559: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');

555: IF NOT GMD_COMMON_VAL.UPDATE_ALLOWED
556: (Entity => 'OPERATION',
557: Entity_id => v_oprn_id,
558: Update_Column_name => p_update_table(i).p_col_to_update) THEN
559: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');
560: FND_MSG_PUB.ADD;
561: RAISE upd_oprn_err;
562: END IF;
563: END IF;

Line 604: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

600: P_data => x_message_list);
601: WHEN OTHERS THEN
602: ROLLBACK TO SAVEPOINT update_oprn;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
605: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
606: FND_MSG_PUB.ADD;
607: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
608: P_data => x_message_list);

Line 605: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

601: WHEN OTHERS THEN
602: ROLLBACK TO SAVEPOINT update_oprn;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
605: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
606: FND_MSG_PUB.ADD;
607: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
608: P_data => x_message_list);
609:

Line 691: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

687: P_data => x_message_list);
688: WHEN OTHERS THEN
689: ROLLBACK TO SAVEPOINT delete_oprn;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
692: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
693: FND_MSG_PUB.ADD;
694: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
695: P_data => x_message_list);

Line 692: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

688: WHEN OTHERS THEN
689: ROLLBACK TO SAVEPOINT delete_oprn;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
692: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
693: FND_MSG_PUB.ADD;
694: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
695: P_data => x_message_list);
696: