DBA Data[Home] [Help]

APPS.GMD_OPERATIONS_PUB dependencies on FND_MSG_PUB

Line 106: fnd_msg_pub.initialize;

102: END IF;
103:
104: /* Initialize message list and count if needed */
105: IF p_init_msg_list THEN
106: fnd_msg_pub.initialize;
107: END IF;
108:
109: /* Intializes the setup fields */
110: IF NOT gmd_api_grp.setup_done THEN

Line 128: FND_MSG_PUB.ADD;

124: END IF;
125:
126: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
127: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO');
128: FND_MSG_PUB.ADD;
129: RAISE ins_operation_err;
130: END IF;
131:
132: /* Operation Version must be passed, otherwise give error */

Line 140: FND_MSG_PUB.ADD;

136: END IF;
137:
138: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
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');

Line 166: FND_MSG_PUB.ADD;

162: END IF;
163:
164: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
165: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_DESC');
166: FND_MSG_PUB.ADD;
167: RAISE ins_operation_err;
168: END IF;
169:
170: /* PROCESS_QTY_UOM must be passed, otherwise give error */

Line 178: FND_MSG_PUB.ADD;

174: END IF;
175:
176: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
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

Line 187: FND_MSG_PUB.ADD;

183: gmd_debug.put_line('process qty uom invalid');
184: END IF;
185:
186: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
187: FND_MSG_PUB.ADD;
188: RAISE ins_operation_err;
189: END IF;
190:
191: /*

Line 198: FND_MSG_PUB.Add;

194: */
195: --Check that organization id is not null if raise an error message
196: IF (p_operations.owner_organization_id IS NULL) THEN
197: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201:
202: -- Check if organization is accessible to the responsibility

Line 211: FND_MSG_PUB.Add;

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;
213: END IF;
214:
215: /* Effective start date must be passed, otherwise give error */

Line 233: FND_MSG_PUB.ADD;

229: IF (l_debug = 'Y') THEN
230: gmd_debug.put_line('effective start date must be less then end date');
231: END IF;
232: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
233: FND_MSG_PUB.ADD;
234: RAISE ins_operation_err;
235: END IF;
236: END IF;
237:

Line 350: FND_MSG_PUB.count_and_get(p_count => x_message_count

346: COMMIT;
347: END IF; ---p_commit
348: END IF;
349:
350: FND_MSG_PUB.count_and_get(p_count => x_message_count
351: ,p_data => x_message_list);
352:
353: EXCEPTION
354: WHEN setup_failure OR invalid_version THEN

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

353: EXCEPTION
354: WHEN setup_failure OR invalid_version THEN
355: ROLLBACK TO SAVEPOINT insert_oprn;
356: x_return_status := FND_API.G_RET_STS_ERROR;
357: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
358: P_data => x_message_list);
359: WHEN ins_operation_err THEN
360: ROLLBACK TO SAVEPOINT insert_oprn;
361: x_return_status := FND_API.g_ret_sts_error;

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

358: P_data => x_message_list);
359: WHEN ins_operation_err THEN
360: ROLLBACK TO SAVEPOINT insert_oprn;
361: x_return_status := FND_API.g_ret_sts_error;
362: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
363: P_data => x_message_list);
364: WHEN default_status_err THEN
365: ROLLBACK TO default_status_sp;
366: x_return_status := FND_API.g_ret_sts_error;

Line 367: FND_MSG_PUB.Count_And_Get (

363: P_data => x_message_list);
364: WHEN default_status_err THEN
365: ROLLBACK TO default_status_sp;
366: x_return_status := FND_API.g_ret_sts_error;
367: FND_MSG_PUB.Count_And_Get (
368: p_count => x_message_count,
369: p_data => x_message_list );
370: WHEN OTHERS THEN
371: ROLLBACK TO SAVEPOINT insert_oprn;

Line 375: FND_MSG_PUB.ADD;

371: ROLLBACK TO SAVEPOINT insert_oprn;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
374: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
375: FND_MSG_PUB.ADD;
376: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
377: P_data => x_message_list);
378: END Insert_Operation;
379:

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

372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
374: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
375: FND_MSG_PUB.ADD;
376: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
377: P_data => x_message_list);
378: END Insert_Operation;
379:
380:

Line 435: fnd_msg_pub.initialize;

431: SAVEPOINT update_oprn;
432:
433: /* Initialize message list and count if needed */
434: IF p_init_msg_list THEN
435: fnd_msg_pub.initialize;
436: END IF;
437:
438: /* Make sure we are call compatible */
439: IF NOT FND_API.compatible_api_call(l_api_version

Line 470: FND_MSG_PUB.ADD;

466:
467: IF (p_oprn_id IS NULL) THEN
468: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
469: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_ID');
470: FND_MSG_PUB.ADD;
471: ELSE
472: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
473: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO, OPRN_VERS');
474: FND_MSG_PUB.ADD;

Line 474: FND_MSG_PUB.ADD;

470: FND_MSG_PUB.ADD;
471: ELSE
472: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
473: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_NO, OPRN_VERS');
474: FND_MSG_PUB.ADD;
475: END IF;
476: RAISE upd_oprn_err;
477: ELSIF p_oprn_id IS NOT NULL THEN
478: OPEN check_oprn_id(p_oprn_id);

Line 514: FND_MSG_PUB.ADD;

510: END IF;
511:
512: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
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

Line 522: FND_MSG_PUB.ADD;

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

Line 540: FND_MSG_PUB.ADD;

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
538: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
539: FND_MESSAGE.SET_TOKEN ('MISSING', 'OPRN_DESC');
540: FND_MSG_PUB.ADD;
541: RAISE upd_oprn_err;
542: END IF;
543: ELSIF UPPER(p_update_table(i).p_col_to_update) = 'DELETE_MARK' THEN
544: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(i).p_value,

Line 548: FND_MSG_PUB.ADD;

544: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(i).p_value,
545: x_return_status => l_retn_status);
546: IF l_retn_status <> 'S' THEN /* it indicates that invalid value has been passed */
547: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');
548: FND_MSG_PUB.ADD;
549: RAISE upd_oprn_err;
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 */

Line 567: FND_MSG_PUB.ADD;

563: (Entity => 'OPERATION',
564: Entity_id => v_oprn_id,
565: Update_Column_name => p_update_table(i).p_col_to_update) THEN
566: FND_MESSAGE.SET_NAME('GMD', 'GMD_OPRN_NOT_VALID');
567: FND_MSG_PUB.ADD;
568: RAISE upd_oprn_err;
569: END IF;
570: END IF;
571: END LOOP;

Line 594: FND_MSG_PUB.count_and_get(p_count => x_message_count

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);
596:
597: EXCEPTION
598: WHEN invalid_version or setup_failure THEN

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

597: EXCEPTION
598: WHEN invalid_version or setup_failure THEN
599: x_return_status := FND_API.G_RET_STS_ERROR;
600: ROLLBACK TO SAVEPOINT update_oprn;
601: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
602: P_data => x_message_list);
603: WHEN upd_oprn_err THEN
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: ROLLBACK TO SAVEPOINT update_oprn;

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

602: P_data => x_message_list);
603: WHEN upd_oprn_err THEN
604: x_return_status := FND_API.G_RET_STS_ERROR;
605: ROLLBACK TO SAVEPOINT update_oprn;
606: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
607: P_data => x_message_list);
608: WHEN OTHERS THEN
609: ROLLBACK TO SAVEPOINT update_oprn;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 613: FND_MSG_PUB.ADD;

609: ROLLBACK TO SAVEPOINT update_oprn;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
612: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
613: FND_MSG_PUB.ADD;
614: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
615: P_data => x_message_list);
616:
617: END update_operation;

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

610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
612: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
613: FND_MSG_PUB.ADD;
614: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
615: P_data => x_message_list);
616:
617: END update_operation;
618:

Line 647: fnd_msg_pub.initialize;

643: SAVEPOINT delete_oprn;
644:
645: /* Initialize message list and count if needed */
646: IF p_init_msg_list THEN
647: fnd_msg_pub.initialize;
648: END IF;
649:
650: /* Initially let us assign the return status to success */
651: x_return_status := FND_API.g_ret_sts_success;

Line 682: FND_MSG_PUB.count_and_get(p_count => x_message_count

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
686: gmd_debug.put_line('END of delete_operation PUB');

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

689: EXCEPTION
690: WHEN upd_oprn_err THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: ROLLBACK TO SAVEPOINT delete_oprn;
693: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
694: P_data => x_message_list);
695: WHEN OTHERS THEN
696: ROLLBACK TO SAVEPOINT delete_oprn;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 700: FND_MSG_PUB.ADD;

696: ROLLBACK TO SAVEPOINT delete_oprn;
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
699: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
700: FND_MSG_PUB.ADD;
701: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
702: P_data => x_message_list);
703:
704: END delete_operation;

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

697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
699: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
700: FND_MSG_PUB.ADD;
701: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
702: P_data => x_message_list);
703:
704: END delete_operation;
705: