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 135: FND_MSG_PUB.ADD;

131: x_return_status := 'E';
132: X_msg := 'Resources';
133: RAISE RESOURCE_REQUIRED;
134: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
135: FND_MSG_PUB.ADD;
136: END IF; /* p_resources.resources IS NOT NULL */
137:
138: fnd_msg_pub.count_and_get (
139: p_count => x_message_count

Line 138: fnd_msg_pub.count_and_get (

134: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
135: FND_MSG_PUB.ADD;
136: END IF; /* p_resources.resources IS NOT NULL */
137:
138: fnd_msg_pub.count_and_get (
139: p_count => x_message_count
140: ,p_encoded => FND_API.g_false
141: ,p_data => x_message_list);
142:

Line 153: fnd_msg_pub.count_and_get (

149:
150: EXCEPTION
151: WHEN resource_creation_failure OR invalid_version THEN
152: ROLLBACK TO SAVEPOINT create_resources;
153: fnd_msg_pub.count_and_get (
154: p_count => x_message_count
155: ,p_encoded => FND_API.g_false
156: ,p_data => x_message_list);
157: x_return_status := FND_API.G_RET_STS_ERROR;

Line 163: FND_MSG_PUB.ADD;

159: WHEN RESOURCE_REQUIRED THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
162: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
163: FND_MSG_PUB.ADD;
164: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
165:
166: WHEN OTHERS THEN
167: ROLLBACK TO SAVEPOINT create_resources;

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

160: x_return_status := FND_API.G_RET_STS_ERROR;
161: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
162: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
163: FND_MSG_PUB.ADD;
164: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
165:
166: WHEN OTHERS THEN
167: ROLLBACK TO SAVEPOINT create_resources;
168: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 170: FND_MSG_PUB.ADD;

166: WHEN OTHERS THEN
167: ROLLBACK TO SAVEPOINT create_resources;
168: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
169: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
170: FND_MSG_PUB.ADD;
171: fnd_msg_pub.count_and_get (
172: p_count => x_message_count
173: ,p_encoded => FND_API.g_false
174: ,p_data => x_message_list);

Line 171: fnd_msg_pub.count_and_get (

167: ROLLBACK TO SAVEPOINT create_resources;
168: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
169: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
170: FND_MSG_PUB.ADD;
171: fnd_msg_pub.count_and_get (
172: p_count => x_message_count
173: ,p_encoded => FND_API.g_false
174: ,p_data => x_message_list);
175: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 368: FND_MSG_PUB.ADD;

364: EXCEPTION
365: WHEN INVALID_MIN_MAX THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: FND_MESSAGE.SET_NAME('GMP','GMP_MIN_MAX_CAPACITY');
368: FND_MSG_PUB.ADD;
369: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
370: --
371: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;

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

365: WHEN INVALID_MIN_MAX THEN
366: x_return_status := FND_API.G_RET_STS_ERROR;
367: FND_MESSAGE.SET_NAME('GMP','GMP_MIN_MAX_CAPACITY');
368: FND_MSG_PUB.ADD;
369: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
370: --
371: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

Line 375: FND_MSG_PUB.ADD;

371: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
372: x_return_status := FND_API.G_RET_STS_ERROR;
373: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
374: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
375: FND_MSG_PUB.ADD;
376: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
377: --
378: /* Bug: 7015717 Vpedarla */
379: WHEN STD_USAGE_UM_REQUIRED THEN

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

372: x_return_status := FND_API.G_RET_STS_ERROR;
373: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
374: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
375: FND_MSG_PUB.ADD;
376: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
377: --
378: /* Bug: 7015717 Vpedarla */
379: WHEN STD_USAGE_UM_REQUIRED THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;

Line 383: FND_MSG_PUB.ADD;

379: WHEN STD_USAGE_UM_REQUIRED THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
382: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
383: FND_MSG_PUB.ADD;
384: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
385: --
386: WHEN PS_DUP_REC THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;

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

380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
382: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
383: FND_MSG_PUB.ADD;
384: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
385: --
386: WHEN PS_DUP_REC THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');

Line 389: FND_MSG_PUB.ADD;

385: --
386: WHEN PS_DUP_REC THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');
389: FND_MSG_PUB.ADD;
390: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
391: --
392: WHEN INVALID_VALUE THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;

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

386: WHEN PS_DUP_REC THEN
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MESSAGE.SET_NAME('GMP','PS_DUP_REC');
389: FND_MSG_PUB.ADD;
390: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
391: --
392: WHEN INVALID_VALUE THEN
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');

Line 397: FND_MSG_PUB.ADD;

393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
395: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
396: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
397: FND_MSG_PUB.ADD;
398: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
399: --
400: WHEN RESOURCE_DESC_REQUIRED THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;

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

394: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
395: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
396: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
397: FND_MSG_PUB.ADD;
398: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
399: --
400: WHEN RESOURCE_DESC_REQUIRED THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

Line 404: FND_MSG_PUB.ADD;

400: WHEN RESOURCE_DESC_REQUIRED THEN
401: x_return_status := FND_API.G_RET_STS_ERROR;
402: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
403: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
404: FND_MSG_PUB.ADD;
405: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
406: --
407: WHEN INVALID_USAGE_UM THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;

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

401: x_return_status := FND_API.G_RET_STS_ERROR;
402: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
403: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
404: FND_MSG_PUB.ADD;
405: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
406: --
407: WHEN INVALID_USAGE_UM THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');

Line 410: FND_MSG_PUB.ADD;

406: --
407: WHEN INVALID_USAGE_UM THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
410: FND_MSG_PUB.ADD;
411: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
412: --
413: WHEN INVALID_RSRC_CLASS THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;

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

407: WHEN INVALID_USAGE_UM THEN
408: x_return_status := FND_API.G_RET_STS_ERROR;
409: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
410: FND_MSG_PUB.ADD;
411: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
412: --
413: WHEN INVALID_RSRC_CLASS THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: FND_MESSAGE.SET_NAME('GMP','CR_INVALID_RSRC_CLASS');

Line 416: FND_MSG_PUB.ADD;

412: --
413: WHEN INVALID_RSRC_CLASS THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: FND_MESSAGE.SET_NAME('GMP','CR_INVALID_RSRC_CLASS');
416: FND_MSG_PUB.ADD;
417: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
418: -- vkinduri Bug 13575854
419: WHEN COST_CMPTCLSID_REQUIRED THEN
420: x_return_status := FND_API.G_RET_STS_ERROR;

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

413: WHEN INVALID_RSRC_CLASS THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: FND_MESSAGE.SET_NAME('GMP','CR_INVALID_RSRC_CLASS');
416: FND_MSG_PUB.ADD;
417: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
418: -- vkinduri Bug 13575854
419: WHEN COST_CMPTCLSID_REQUIRED THEN
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

Line 423: FND_MSG_PUB.ADD;

419: WHEN COST_CMPTCLSID_REQUIRED THEN
420: x_return_status := FND_API.G_RET_STS_ERROR;
421: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
422: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
423: FND_MSG_PUB.ADD;
424: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
425: -- vkinduri Bug 13575854
426: WHEN INVALID_CMPTCLS_ID THEN
427: x_return_status := FND_API.G_RET_STS_ERROR;

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

420: x_return_status := FND_API.G_RET_STS_ERROR;
421: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
422: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
423: FND_MSG_PUB.ADD;
424: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
425: -- vkinduri Bug 13575854
426: WHEN INVALID_CMPTCLS_ID THEN
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MESSAGE.SET_NAME('GMP','INVALID_COST_CMPTCLSID');

Line 429: FND_MSG_PUB.ADD;

425: -- vkinduri Bug 13575854
426: WHEN INVALID_CMPTCLS_ID THEN
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MESSAGE.SET_NAME('GMP','INVALID_COST_CMPTCLSID');
429: FND_MSG_PUB.ADD;
430: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
431:
432:
433:

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

426: WHEN INVALID_CMPTCLS_ID THEN
427: x_return_status := FND_API.G_RET_STS_ERROR;
428: FND_MESSAGE.SET_NAME('GMP','INVALID_COST_CMPTCLSID');
429: FND_MSG_PUB.ADD;
430: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
431:
432:
433:
434: END check_data; /* End of Procedure check_resources */

Line 476: fnd_msg_pub.initialize;

472: x_return_status := FND_API.G_RET_STS_SUCCESS;
473:
474: /* Initialize message list and count if needed */
475: IF p_init_msg_list THEN
476: fnd_msg_pub.initialize;
477: END IF;
478:
479: /* Make sure we are call compatible */
480: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version

Line 508: FND_MSG_PUB.ADD;

504: l_return_status);
505:
506: IF l_return_status = 'E' THEN
507: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_DUPLICATION');
508: FND_MSG_PUB.ADD;
509: RAISE resource_update_failure;
510: ELSE
511: /* Update the Resource Data now */
512: CR_RSRC_MST_PKG.update_row(

Line 543: fnd_msg_pub.count_and_get (

539: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
540: RAISE resource_update_failure;
541: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
542:
543: fnd_msg_pub.count_and_get (
544: p_count => x_message_count
545: ,p_encoded => FND_API.g_false
546: ,p_data => x_message_list);
547:

Line 558: fnd_msg_pub.count_and_get (

554: EXCEPTION
555: WHEN resource_update_failure OR invalid_version THEN
556: ROLLBACK TO SAVEPOINT update_resources;
557: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
558: fnd_msg_pub.count_and_get (
559: p_count => x_message_count
560: ,p_encoded => FND_API.g_false
561: ,p_data => x_message_list);
562: x_return_status := FND_API.G_RET_STS_ERROR;

Line 568: FND_MSG_PUB.ADD;

564: ROLLBACK TO SAVEPOINT update_resources;
565: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
566: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
567: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
568: FND_MSG_PUB.ADD;
569: fnd_msg_pub.count_and_get (
570: p_count => x_message_count
571: ,p_encoded => FND_API.g_false
572: ,p_data => x_message_list);

Line 569: fnd_msg_pub.count_and_get (

565: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
566: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
567: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
568: FND_MSG_PUB.ADD;
569: fnd_msg_pub.count_and_get (
570: p_count => x_message_count
571: ,p_encoded => FND_API.g_false
572: ,p_data => x_message_list);
573: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 620: fnd_msg_pub.initialize;

616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617:
618: /* Initialize message list and count if needed */
619: IF p_init_msg_list THEN
620: fnd_msg_pub.initialize;
621: END IF;
622:
623: /* Make sure we are call compatible */
624: IF NOT FND_API.compatible_api_call ( GMP_RESOURCES_PUB.m_api_version

Line 639: FND_MSG_PUB.ADD;

635:
636: IF (l_counter = 0 ) then
637: l_return_status := 'E';
638: GMD_DEBUG.PUT_LINE('Resource to be deleted Does Not Exist ');
639: FND_MSG_PUB.ADD;
640: RAISE resource_delete_failure;
641: ELSE
642: delete from cr_rsrc_mst_tl
643: where resources = p_resources;

Line 650: fnd_msg_pub.count_and_get (

646: where resources = p_resources;
647: l_return_status := 'S';
648: END IF;
649: --
650: fnd_msg_pub.count_and_get (
651: p_count => x_message_count
652: ,p_encoded => FND_API.g_false
653: ,p_data => x_message_list);
654:

Line 665: fnd_msg_pub.count_and_get (

661: EXCEPTION
662: WHEN resource_delete_failure OR invalid_version THEN
663: ROLLBACK TO SAVEPOINT delete_resources;
664: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
665: fnd_msg_pub.count_and_get (
666: p_count => x_message_count
667: ,p_encoded => FND_API.g_false
668: ,p_data => x_message_list);
669: x_return_status := FND_API.G_RET_STS_ERROR;

Line 675: FND_MSG_PUB.ADD;

671: ROLLBACK TO SAVEPOINT delete_resources;
672: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
673: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
674: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
675: FND_MSG_PUB.ADD;
676: fnd_msg_pub.count_and_get (
677: p_count => x_message_count
678: ,p_encoded => FND_API.g_false
679: ,p_data => x_message_list);

Line 676: fnd_msg_pub.count_and_get (

672: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
673: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
674: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
675: FND_MSG_PUB.ADD;
676: fnd_msg_pub.count_and_get (
677: p_count => x_message_count
678: ,p_encoded => FND_API.g_false
679: ,p_data => x_message_list);
680: x_return_status := FND_API.g_ret_sts_unexp_error;