DBA Data[Home] [Help]

APPS.GMD_OPERATIONS_PUB dependencies on FND_MSG_PUB

Line 102: fnd_msg_pub.initialize;

98: END IF;
99:
100: /* Initialize message list and count if needed */
101: IF p_init_msg_list THEN
102: fnd_msg_pub.initialize;
103: END IF;
104:
105: /* Intializes the setup fields */
106: IF NOT gmd_api_grp.setup_done THEN

Line 124: FND_MSG_PUB.ADD;

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:
128: /* Operation Version must be passed, otherwise give error */

Line 136: FND_MSG_PUB.ADD;

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',
140: 'FIELD', 'OPRN_VERS');

Line 162: FND_MSG_PUB.ADD;

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:
166: /* PROCESS_QTY_UOM must be passed, otherwise give error */

Line 174: FND_MSG_PUB.ADD;

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
178: IF (l_debug = 'Y') THEN

Line 183: FND_MSG_PUB.ADD;

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:
187: /*

Line 194: FND_MSG_PUB.Add;

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:
198: -- Check if organization is accessible to the responsibility

Line 207: FND_MSG_PUB.Add;

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:
211: /* Effective start date must be passed, otherwise give error */

Line 226: FND_MSG_PUB.ADD;

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;
230:

Line 343: FND_MSG_PUB.count_and_get(p_count => x_message_count

339: COMMIT;
340: END IF; ---p_commit
341: END IF;
342:
343: FND_MSG_PUB.count_and_get(p_count => x_message_count
344: ,p_data => x_message_list);
345:
346: EXCEPTION
347: WHEN setup_failure OR invalid_version THEN

Line 350: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

346: EXCEPTION
347: WHEN setup_failure OR invalid_version THEN
348: ROLLBACK TO SAVEPOINT insert_oprn;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
351: P_data => x_message_list);
352: WHEN ins_operation_err THEN
353: ROLLBACK TO SAVEPOINT insert_oprn;
354: x_return_status := FND_API.g_ret_sts_error;

Line 355: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

351: P_data => x_message_list);
352: WHEN ins_operation_err THEN
353: ROLLBACK TO SAVEPOINT insert_oprn;
354: x_return_status := FND_API.g_ret_sts_error;
355: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
356: P_data => x_message_list);
357: WHEN default_status_err THEN
358: ROLLBACK TO default_status_sp;
359: x_return_status := FND_API.g_ret_sts_error;

Line 360: FND_MSG_PUB.Count_And_Get (

356: P_data => x_message_list);
357: WHEN default_status_err THEN
358: ROLLBACK TO default_status_sp;
359: x_return_status := FND_API.g_ret_sts_error;
360: FND_MSG_PUB.Count_And_Get (
361: p_count => x_message_count,
362: p_data => x_message_list );
363: WHEN OTHERS THEN
364: ROLLBACK TO SAVEPOINT insert_oprn;

Line 368: FND_MSG_PUB.ADD;

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;
372:

Line 369: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

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;
372:
373:

Line 428: fnd_msg_pub.initialize;

424: SAVEPOINT update_oprn;
425:
426: /* Initialize message list and count if needed */
427: IF p_init_msg_list THEN
428: fnd_msg_pub.initialize;
429: END IF;
430:
431: /* Make sure we are call compatible */
432: IF NOT FND_API.compatible_api_call(l_api_version

Line 463: FND_MSG_PUB.ADD;

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');
467: FND_MSG_PUB.ADD;

Line 467: FND_MSG_PUB.ADD;

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
471: OPEN check_oprn_id(p_oprn_id);

Line 507: FND_MSG_PUB.ADD;

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
511: IF (l_debug = 'Y') THEN

Line 515: FND_MSG_PUB.ADD;

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
519: IF p_update_table(i).p_value < 0 THEN

Line 533: FND_MSG_PUB.ADD;

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
537: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(i).p_value,

Line 541: FND_MSG_PUB.ADD;

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
545: /* Validation : Check if owner_orgn_idis valid */

Line 560: FND_MSG_PUB.ADD;

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;
564: END LOOP;

Line 587: FND_MSG_PUB.count_and_get(p_count => x_message_count

583: /* Adding message to stack indicating the success of the routine */
584: gmd_api_grp.log_message ('GMD_SAVED_CHANGES');
585: END IF;
586:
587: FND_MSG_PUB.count_and_get(p_count => x_message_count
588: ,p_data => x_message_list);
589:
590: EXCEPTION
591: WHEN invalid_version or setup_failure THEN

Line 594: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

590: EXCEPTION
591: WHEN invalid_version or setup_failure THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: ROLLBACK TO SAVEPOINT update_oprn;
594: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
595: P_data => x_message_list);
596: WHEN upd_oprn_err THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: ROLLBACK TO SAVEPOINT update_oprn;

Line 599: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

595: P_data => x_message_list);
596: WHEN upd_oprn_err THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: ROLLBACK TO SAVEPOINT update_oprn;
599: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
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;

Line 606: FND_MSG_PUB.ADD;

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:
610: END update_operation;

Line 607: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

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:
610: END update_operation;
611:

Line 640: fnd_msg_pub.initialize;

636: SAVEPOINT delete_oprn;
637:
638: /* Initialize message list and count if needed */
639: IF p_init_msg_list THEN
640: fnd_msg_pub.initialize;
641: END IF;
642:
643: /* Initially let us assign the return status to success */
644: x_return_status := FND_API.g_ret_sts_success;

Line 675: FND_MSG_PUB.count_and_get(p_count => x_message_count

671: END IF;
672:
673: /* Adding message to stack indicating the success of the routine */
674: gmd_api_grp.log_message ('GMD_SAVED_CHANGES');
675: FND_MSG_PUB.count_and_get(p_count => x_message_count
676: ,p_data => x_message_list);
677:
678: IF (l_debug = 'Y') THEN
679: gmd_debug.put_line('END of delete_operation PUB');

Line 686: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

682: EXCEPTION
683: WHEN upd_oprn_err THEN
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: ROLLBACK TO SAVEPOINT delete_oprn;
686: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
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;

Line 693: FND_MSG_PUB.ADD;

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:
697: END delete_operation;

Line 694: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

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:
697: END delete_operation;
698: