130: ELSE
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 (
157: x_return_status := FND_API.G_RET_STS_ERROR;
158:
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:
158:
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
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');
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
165:
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
363: --
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
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');
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: --
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');
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 */
377: --
378: /* Bug: 7015717 Vpedarla */
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: --
378: /* Bug: 7015717 Vpedarla */
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
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');
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
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');
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);
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');
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: --
392: WHEN INVALID_VALUE THEN
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
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');
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: --
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');
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
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');
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
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');
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
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');
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
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');
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
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');
429: FND_MSG_PUB.ADD;
430: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
431:
432:
503: x_message_list,
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 */
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: WHEN OTHERS THEN
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
563: WHEN OTHERS THEN
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
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: WHEN OTHERS THEN
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
670: WHEN OTHERS THEN
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