DBA Data[Home] [Help]

APPS.GMP_RESOURCES_PUB dependencies on FND_MSG_PUB

Line 51: fnd_msg_pub.initialize;

47: l_resources_rec := p_resources;
48:
49: /* Initialize message list and count if needed */
50: IF p_init_msg_list THEN
51: fnd_msg_pub.initialize;
52: END IF;
53:
54: /* Make sure we are call compatible */
55: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version

Line 124: FND_MSG_PUB.ADD;

120: x_return_status := 'E';
121: X_msg := 'Resources';
122: RAISE RESOURCE_REQUIRED;
123: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
124: FND_MSG_PUB.ADD;
125: END IF; /* p_resources.resources IS NOT NULL */
126:
127: fnd_msg_pub.count_and_get (
128: p_count => x_message_count

Line 127: fnd_msg_pub.count_and_get (

123: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
124: FND_MSG_PUB.ADD;
125: END IF; /* p_resources.resources IS NOT NULL */
126:
127: fnd_msg_pub.count_and_get (
128: p_count => x_message_count
129: ,p_encoded => FND_API.g_false
130: ,p_data => x_message_list);
131:

Line 142: fnd_msg_pub.count_and_get (

138:
139: EXCEPTION
140: WHEN resource_creation_failure OR invalid_version THEN
141: ROLLBACK TO SAVEPOINT create_resources;
142: fnd_msg_pub.count_and_get (
143: p_count => x_message_count
144: ,p_encoded => FND_API.g_false
145: ,p_data => x_message_list);
146: x_return_status := FND_API.G_RET_STS_ERROR;

Line 152: FND_MSG_PUB.ADD;

148: WHEN RESOURCE_REQUIRED THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
151: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
152: FND_MSG_PUB.ADD;
153: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
154:
155: WHEN OTHERS THEN
156: ROLLBACK TO SAVEPOINT create_resources;

Line 153: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

149: x_return_status := FND_API.G_RET_STS_ERROR;
150: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
151: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
152: FND_MSG_PUB.ADD;
153: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
154:
155: WHEN OTHERS THEN
156: ROLLBACK TO SAVEPOINT create_resources;
157: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 159: FND_MSG_PUB.ADD;

155: WHEN OTHERS THEN
156: ROLLBACK TO SAVEPOINT create_resources;
157: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
158: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
159: FND_MSG_PUB.ADD;
160: fnd_msg_pub.count_and_get (
161: p_count => x_message_count
162: ,p_encoded => FND_API.g_false
163: ,p_data => x_message_list);

Line 160: fnd_msg_pub.count_and_get (

156: ROLLBACK TO SAVEPOINT create_resources;
157: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
158: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
159: FND_MSG_PUB.ADD;
160: fnd_msg_pub.count_and_get (
161: p_count => x_message_count
162: ,p_encoded => FND_API.g_false
163: ,p_data => x_message_list);
164: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 336: FND_MSG_PUB.ADD;

332: EXCEPTION
333: WHEN INVALID_MIN_MAX THEN
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MESSAGE.SET_NAME('GMP','GMP_MIN_MAX_CAPACITY');
336: FND_MSG_PUB.ADD;
337: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
338: --
339: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;

Line 337: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

333: WHEN INVALID_MIN_MAX THEN
334: x_return_status := FND_API.G_RET_STS_ERROR;
335: FND_MESSAGE.SET_NAME('GMP','GMP_MIN_MAX_CAPACITY');
336: FND_MSG_PUB.ADD;
337: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
338: --
339: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

Line 343: FND_MSG_PUB.ADD;

339: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
342: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
343: FND_MSG_PUB.ADD;
344: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
345: --
346: WHEN PS_DUP_REC THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;

Line 344: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

340: x_return_status := FND_API.G_RET_STS_ERROR;
341: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
342: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
343: FND_MSG_PUB.ADD;
344: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
345: --
346: WHEN PS_DUP_REC THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');

Line 349: FND_MSG_PUB.ADD;

345: --
346: WHEN PS_DUP_REC THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');
349: FND_MSG_PUB.ADD;
350: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
351: --
352: WHEN INVALID_VALUE THEN
353: x_return_status := FND_API.G_RET_STS_ERROR;

Line 350: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

346: WHEN PS_DUP_REC THEN
347: x_return_status := FND_API.G_RET_STS_ERROR;
348: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');
349: FND_MSG_PUB.ADD;
350: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
351: --
352: WHEN INVALID_VALUE THEN
353: x_return_status := FND_API.G_RET_STS_ERROR;
354: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');

Line 357: FND_MSG_PUB.ADD;

353: x_return_status := FND_API.G_RET_STS_ERROR;
354: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
355: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
356: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
357: FND_MSG_PUB.ADD;
358: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
359: --
360: WHEN RESOURCE_DESC_REQUIRED THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;

Line 358: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

354: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
355: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
356: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
357: FND_MSG_PUB.ADD;
358: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
359: --
360: WHEN RESOURCE_DESC_REQUIRED THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

Line 364: FND_MSG_PUB.ADD;

360: WHEN RESOURCE_DESC_REQUIRED THEN
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
363: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
364: FND_MSG_PUB.ADD;
365: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
366: --
367: WHEN INVALID_USAGE_UM THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;

Line 365: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

361: x_return_status := FND_API.G_RET_STS_ERROR;
362: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
363: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
364: FND_MSG_PUB.ADD;
365: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
366: --
367: WHEN INVALID_USAGE_UM THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');

Line 370: FND_MSG_PUB.ADD;

366: --
367: WHEN INVALID_USAGE_UM THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
370: FND_MSG_PUB.ADD;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
372: --
373: WHEN INVALID_RSRC_CLASS THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;

Line 371: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

367: WHEN INVALID_USAGE_UM THEN
368: x_return_status := FND_API.G_RET_STS_ERROR;
369: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
370: FND_MSG_PUB.ADD;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
372: --
373: WHEN INVALID_RSRC_CLASS THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MESSAGE.SET_NAME('GMP','CR_INVALID_RSRC_CLASS');

Line 376: FND_MSG_PUB.ADD;

372: --
373: WHEN INVALID_RSRC_CLASS THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MESSAGE.SET_NAME('GMP','CR_INVALID_RSRC_CLASS');
376: FND_MSG_PUB.ADD;
377: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
378:
379: END check_data; /* End of Procedure check_resources */
380:

Line 377: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

373: WHEN INVALID_RSRC_CLASS THEN
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MESSAGE.SET_NAME('GMP','CR_INVALID_RSRC_CLASS');
376: FND_MSG_PUB.ADD;
377: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
378:
379: END check_data; /* End of Procedure check_resources */
380:
381: /* =============================================================== */

Line 421: fnd_msg_pub.initialize;

417: x_return_status := FND_API.G_RET_STS_SUCCESS;
418:
419: /* Initialize message list and count if needed */
420: IF p_init_msg_list THEN
421: fnd_msg_pub.initialize;
422: END IF;
423:
424: /* Make sure we are call compatible */
425: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version

Line 453: FND_MSG_PUB.ADD;

449: l_return_status);
450:
451: IF l_return_status = 'E' THEN
452: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_DUPLICATION');
453: FND_MSG_PUB.ADD;
454: RAISE resource_update_failure;
455: ELSE
456: /* Update the Resource Data now */
457: CR_RSRC_MST_PKG.update_row(

Line 485: fnd_msg_pub.count_and_get (

481: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
482: RAISE resource_update_failure;
483: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
484:
485: fnd_msg_pub.count_and_get (
486: p_count => x_message_count
487: ,p_encoded => FND_API.g_false
488: ,p_data => x_message_list);
489:

Line 500: fnd_msg_pub.count_and_get (

496: EXCEPTION
497: WHEN resource_update_failure OR invalid_version THEN
498: ROLLBACK TO SAVEPOINT update_resources;
499: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
500: fnd_msg_pub.count_and_get (
501: p_count => x_message_count
502: ,p_encoded => FND_API.g_false
503: ,p_data => x_message_list);
504: x_return_status := FND_API.G_RET_STS_ERROR;

Line 510: FND_MSG_PUB.ADD;

506: ROLLBACK TO SAVEPOINT update_resources;
507: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
508: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
509: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
510: FND_MSG_PUB.ADD;
511: fnd_msg_pub.count_and_get (
512: p_count => x_message_count
513: ,p_encoded => FND_API.g_false
514: ,p_data => x_message_list);

Line 511: fnd_msg_pub.count_and_get (

507: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
508: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
509: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
510: FND_MSG_PUB.ADD;
511: fnd_msg_pub.count_and_get (
512: p_count => x_message_count
513: ,p_encoded => FND_API.g_false
514: ,p_data => x_message_list);
515: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 562: fnd_msg_pub.initialize;

558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559:
560: /* Initialize message list and count if needed */
561: IF p_init_msg_list THEN
562: fnd_msg_pub.initialize;
563: END IF;
564:
565: /* Make sure we are call compatible */
566: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version

Line 581: FND_MSG_PUB.ADD;

577:
578: IF (l_counter = 0 ) then
579: l_return_status := 'E';
580: GMD_DEBUG.PUT_LINE('Resource to be deleted Does Not Exist ');
581: FND_MSG_PUB.ADD;
582: RAISE resource_delete_failure;
583: ELSE
584: delete from cr_rsrc_mst_tl
585: where resources = p_resources;

Line 592: fnd_msg_pub.count_and_get (

588: where resources = p_resources;
589: l_return_status := 'S';
590: END IF;
591: --
592: fnd_msg_pub.count_and_get (
593: p_count => x_message_count
594: ,p_encoded => FND_API.g_false
595: ,p_data => x_message_list);
596:

Line 607: fnd_msg_pub.count_and_get (

603: EXCEPTION
604: WHEN resource_delete_failure OR invalid_version THEN
605: ROLLBACK TO SAVEPOINT delete_resources;
606: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
607: fnd_msg_pub.count_and_get (
608: p_count => x_message_count
609: ,p_encoded => FND_API.g_false
610: ,p_data => x_message_list);
611: x_return_status := FND_API.G_RET_STS_ERROR;

Line 617: FND_MSG_PUB.ADD;

613: ROLLBACK TO SAVEPOINT delete_resources;
614: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
615: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
616: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
617: FND_MSG_PUB.ADD;
618: fnd_msg_pub.count_and_get (
619: p_count => x_message_count
620: ,p_encoded => FND_API.g_false
621: ,p_data => x_message_list);

Line 618: fnd_msg_pub.count_and_get (

614: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
615: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
616: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
617: FND_MSG_PUB.ADD;
618: fnd_msg_pub.count_and_get (
619: p_count => x_message_count
620: ,p_encoded => FND_API.g_false
621: ,p_data => x_message_list);
622: x_return_status := FND_API.g_ret_sts_unexp_error;