eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMP_RESOURCE_DTL_PUB dependencies on FND_MESSAGE

Line 272: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

268:
269: END IF; /* resource return value */
270: ELSE
271: RAISE resource_id_required;
272: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
273: FND_MSG_PUB.ADD;
274: END IF; /* p_resources.resource_id IS NOT NULL */
275:
276: fnd_msg_pub.count_and_get (

Line 300: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

296: x_return_status := FND_API.G_RET_STS_ERROR;
297:
298: WHEN resource_id_required THEN
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
301: FND_MSG_PUB.ADD;
302: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
303:
304: WHEN instance_id_required THEN

Line 306: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

302: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
303:
304: WHEN instance_id_required THEN
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
307: FND_MSG_PUB.ADD;
308: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
309:
310: WHEN OTHERS THEN

Line 312: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

308: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
309:
310: WHEN OTHERS THEN
311: ROLLBACK TO SAVEPOINT create_resource_dtl;
312: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
313: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
314: FND_MSG_PUB.ADD;
315: fnd_msg_pub.count_and_get (
316: p_count => x_message_count

Line 313: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

309:
310: WHEN OTHERS THEN
311: ROLLBACK TO SAVEPOINT create_resource_dtl;
312: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
313: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
314: FND_MSG_PUB.ADD;
315: fnd_msg_pub.count_and_get (
316: p_count => x_message_count
317: ,p_encoded => FND_API.g_false

Line 645: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');

641:
642: EXCEPTION
643: WHEN INVALID_VALUE THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
646: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
647: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
648: FND_MSG_PUB.ADD;
649: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

Line 646: FND_MESSAGE.SET_TOKEN('FIELD',X_field);

642: EXCEPTION
643: WHEN INVALID_VALUE THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
646: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
647: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
648: FND_MSG_PUB.ADD;
649: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
650:

Line 647: FND_MESSAGE.SET_TOKEN('VALUE',X_value);

643: WHEN INVALID_VALUE THEN
644: x_return_status := FND_API.G_RET_STS_ERROR;
645: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
646: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
647: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
648: FND_MSG_PUB.ADD;
649: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
650:
651: WHEN INVALID_ORGN_CODE THEN

Line 653: FND_MESSAGE.SET_NAME('GMI','IC_ORGNCODERR');

649: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
650:
651: WHEN INVALID_ORGN_CODE THEN
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MESSAGE.SET_NAME('GMI','IC_ORGNCODERR');
654: FND_MSG_PUB.ADD;
655: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
656:
657: WHEN BAD_RESOURCE THEN

Line 659: FND_MESSAGE.SET_NAME('GMP','BAD_RESOURCE');

655: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
656:
657: WHEN BAD_RESOURCE THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: FND_MESSAGE.SET_NAME('GMP','BAD_RESOURCE');
660: FND_MSG_PUB.ADD;
661: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
662:
663: WHEN CR_POSITIVE THEN

Line 665: FND_MESSAGE.SET_NAME('GMP','CR_POSITIVE');

661: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
662:
663: WHEN CR_POSITIVE THEN
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: FND_MESSAGE.SET_NAME('GMP','CR_POSITIVE');
666: fnd_file.put_line(fnd_file.log,'Qty Entered is < 0');
667: FND_MSG_PUB.ADD;
668: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
669:

Line 672: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

668: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
669:
670: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
673: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
674: FND_MSG_PUB.ADD;
675: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
676:

Line 673: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

669:
670: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
673: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
674: FND_MSG_PUB.ADD;
675: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
676:
677: WHEN ASSIGNED_QTY_REQUIRED THEN

Line 679: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

675: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
676:
677: WHEN ASSIGNED_QTY_REQUIRED THEN
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
680: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
681: FND_MSG_PUB.ADD;
682: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
683:

Line 680: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

676:
677: WHEN ASSIGNED_QTY_REQUIRED THEN
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
680: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
681: FND_MSG_PUB.ADD;
682: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
683:
684: WHEN INVALID_USAGE_UM THEN

Line 686: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');

682: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
683:
684: WHEN INVALID_USAGE_UM THEN
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
687: FND_MSG_PUB.ADD;
688: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
689:
690: WHEN INVALID_CAPACITY_UOM THEN

Line 692: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');

688: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
689:
690: WHEN INVALID_CAPACITY_UOM THEN
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
693: FND_MSG_PUB.ADD;
694: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
695:
696: WHEN INVALID_UOM_TYPE THEN

Line 698: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');

694: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
695:
696: WHEN INVALID_UOM_TYPE THEN
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
699: FND_MSG_PUB.ADD;
700: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
701:
702: WHEN CAPACITY_NOT_IN_RANGE THEN

Line 704: FND_MESSAGE.SET_NAME('GMP','CR_CAPACITY_NOT_IN_RANGE');

700: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
701:
702: WHEN CAPACITY_NOT_IN_RANGE THEN
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MESSAGE.SET_NAME('GMP','CR_CAPACITY_NOT_IN_RANGE');
705: FND_MSG_PUB.ADD;
706: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
707:
708: WHEN QC_MIN_MAX_SPEC THEN

Line 710: FND_MESSAGE.SET_NAME('GMD','QC_MIN_MAX_SPEC');

706: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
707:
708: WHEN QC_MIN_MAX_SPEC THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: FND_MESSAGE.SET_NAME('GMD','QC_MIN_MAX_SPEC');
711: FND_MSG_PUB.ADD;
712: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
713:
714: WHEN RESOURCE_REQUIRED THEN

Line 716: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

712: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
713:
714: WHEN RESOURCE_REQUIRED THEN
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
717: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
718: FND_MSG_PUB.ADD;
719: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
720:

Line 717: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

713:
714: WHEN RESOURCE_REQUIRED THEN
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
717: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
718: FND_MSG_PUB.ADD;
719: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
720:
721: WHEN DUPLICATE_RECORD THEN

Line 723: FND_MESSAGE.SET_NAME('GMP', 'PS_DUP_REC');

719: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
720:
721: WHEN DUPLICATE_RECORD THEN
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MESSAGE.SET_NAME('GMP', 'PS_DUP_REC');
724: FND_MSG_PUB.ADD;
725: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
726:
727: END check_data;

Line 1121: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118:
1119: WHEN RESOURCES_REQUIRED THEN
1120: x_return_status := 'E' ;
1121: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
1122: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1123: FND_MSG_PUB.ADD;
1124: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1125: WHEN OTHERS THEN

Line 1122: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

1118:
1119: WHEN RESOURCES_REQUIRED THEN
1120: x_return_status := 'E' ;
1121: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
1122: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1123: FND_MSG_PUB.ADD;
1124: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1125: WHEN OTHERS THEN
1126: ROLLBACK TO SAVEPOINT update_resource_dtl;

Line 1128: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1124: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1125: WHEN OTHERS THEN
1126: ROLLBACK TO SAVEPOINT update_resource_dtl;
1127: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1128: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1129: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1130: FND_MSG_PUB.ADD;
1131: fnd_msg_pub.count_and_get (
1132: p_count => x_message_count

Line 1129: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1125: WHEN OTHERS THEN
1126: ROLLBACK TO SAVEPOINT update_resource_dtl;
1127: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1128: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1129: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1130: FND_MSG_PUB.ADD;
1131: fnd_msg_pub.count_and_get (
1132: p_count => x_message_count
1133: ,p_encoded => FND_API.g_false

Line 1257: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1253:
1254: EXCEPTION
1255: WHEN no_data_found THEN
1256: ROLLBACK TO SAVEPOINT update_instances;
1257: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1258: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1259: FND_MSG_PUB.ADD;
1260: x_return_status := FND_API.g_ret_sts_unexp_error;
1261: WHEN OTHERS THEN

Line 1258: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1254: EXCEPTION
1255: WHEN no_data_found THEN
1256: ROLLBACK TO SAVEPOINT update_instances;
1257: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1258: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1259: FND_MSG_PUB.ADD;
1260: x_return_status := FND_API.g_ret_sts_unexp_error;
1261: WHEN OTHERS THEN
1262: ROLLBACK TO SAVEPOINT update_resource_dtl;

Line 1263: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1259: FND_MSG_PUB.ADD;
1260: x_return_status := FND_API.g_ret_sts_unexp_error;
1261: WHEN OTHERS THEN
1262: ROLLBACK TO SAVEPOINT update_resource_dtl;
1263: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1264: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1265: FND_MSG_PUB.ADD;
1266: x_return_status := FND_API.g_ret_sts_unexp_error;
1267: END update_detail_rows;

Line 1264: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1260: x_return_status := FND_API.g_ret_sts_unexp_error;
1261: WHEN OTHERS THEN
1262: ROLLBACK TO SAVEPOINT update_resource_dtl;
1263: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1264: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1265: FND_MSG_PUB.ADD;
1266: x_return_status := FND_API.g_ret_sts_unexp_error;
1267: END update_detail_rows;
1268:

Line 1424: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

1420: ,p_encoded => FND_API.g_false
1421: ,p_data => x_message_list);
1422: x_return_status := FND_API.G_RET_STS_ERROR;
1423: WHEN RESOURCES_REQUIRED THEN
1424: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
1425: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1426: FND_MSG_PUB.ADD;
1427: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1428: WHEN OTHERS THEN

Line 1425: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

1421: ,p_data => x_message_list);
1422: x_return_status := FND_API.G_RET_STS_ERROR;
1423: WHEN RESOURCES_REQUIRED THEN
1424: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
1425: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1426: FND_MSG_PUB.ADD;
1427: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1428: WHEN OTHERS THEN
1429: ROLLBACK TO SAVEPOINT update_instances;

Line 1431: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1427: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1428: WHEN OTHERS THEN
1429: ROLLBACK TO SAVEPOINT update_instances;
1430: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1431: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1432: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1433: FND_MSG_PUB.ADD;
1434: fnd_msg_pub.count_and_get (
1435: p_count => x_message_count

Line 1432: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1428: WHEN OTHERS THEN
1429: ROLLBACK TO SAVEPOINT update_instances;
1430: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1431: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1432: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1433: FND_MSG_PUB.ADD;
1434: fnd_msg_pub.count_and_get (
1435: p_count => x_message_count
1436: ,p_encoded => FND_API.g_false

Line 1519: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1515:
1516: EXCEPTION
1517: WHEN no_data_found THEN
1518: ROLLBACK TO SAVEPOINT update_instances;
1519: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1520: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1521: FND_MSG_PUB.ADD;
1522: x_return_status := FND_API.g_ret_sts_unexp_error;
1523: WHEN OTHERS THEN

Line 1520: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1516: EXCEPTION
1517: WHEN no_data_found THEN
1518: ROLLBACK TO SAVEPOINT update_instances;
1519: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1520: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1521: FND_MSG_PUB.ADD;
1522: x_return_status := FND_API.g_ret_sts_unexp_error;
1523: WHEN OTHERS THEN
1524: ROLLBACK TO SAVEPOINT update_instances;

Line 1525: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1521: FND_MSG_PUB.ADD;
1522: x_return_status := FND_API.g_ret_sts_unexp_error;
1523: WHEN OTHERS THEN
1524: ROLLBACK TO SAVEPOINT update_instances;
1525: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1526: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1527: FND_MSG_PUB.ADD;
1528: x_return_status := FND_API.g_ret_sts_unexp_error;
1529: END update_instance_row ;

Line 1526: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1522: x_return_status := FND_API.g_ret_sts_unexp_error;
1523: WHEN OTHERS THEN
1524: ROLLBACK TO SAVEPOINT update_instances;
1525: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1526: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1527: FND_MSG_PUB.ADD;
1528: x_return_status := FND_API.g_ret_sts_unexp_error;
1529: END update_instance_row ;
1530:

Line 1657: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

1653: x_return_status := FND_API.G_RET_STS_ERROR;
1654: WHEN OTHERS THEN
1655: ROLLBACK TO SAVEPOINT delete_resources;
1656: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1657: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1658: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1659: FND_MSG_PUB.ADD;
1660: fnd_msg_pub.count_and_get (
1661: p_count => x_message_count

Line 1658: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

1654: WHEN OTHERS THEN
1655: ROLLBACK TO SAVEPOINT delete_resources;
1656: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1657: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1658: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1659: FND_MSG_PUB.ADD;
1660: fnd_msg_pub.count_and_get (
1661: p_count => x_message_count
1662: ,p_encoded => FND_API.g_false

Line 1847: FND_MESSAGE.SET_NAME('GMP','MR_STARTENDDATEERR');

1843: EXCEPTION
1844:
1845: WHEN INVALID_DATE_RANGE THEN
1846: x_return_status := FND_API.G_RET_STS_ERROR;
1847: FND_MESSAGE.SET_NAME('GMP','MR_STARTENDDATEERR');
1848: FND_MSG_PUB.ADD;
1849: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1850:
1851: WHEN INVALID_VALUE THEN

Line 1853: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');

1849: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1850:
1851: WHEN INVALID_VALUE THEN
1852: x_return_status := FND_API.G_RET_STS_ERROR;
1853: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1854: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1855: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1856: FND_MSG_PUB.ADD;
1857: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);

Line 1854: FND_MESSAGE.SET_TOKEN('FIELD',X_field);

1850:
1851: WHEN INVALID_VALUE THEN
1852: x_return_status := FND_API.G_RET_STS_ERROR;
1853: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1854: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1855: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1856: FND_MSG_PUB.ADD;
1857: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1858:

Line 1855: FND_MESSAGE.SET_TOKEN('VALUE',X_value);

1851: WHEN INVALID_VALUE THEN
1852: x_return_status := FND_API.G_RET_STS_ERROR;
1853: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1854: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1855: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1856: FND_MSG_PUB.ADD;
1857: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1858:
1859: WHEN RESOURCE_REQUIRED THEN

Line 1861: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

1857: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1858:
1859: WHEN RESOURCE_REQUIRED THEN
1860: x_return_status := FND_API.G_RET_STS_ERROR;
1861: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1862: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1863: FND_MSG_PUB.ADD;
1864: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1865:

Line 1862: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);

1858:
1859: WHEN RESOURCE_REQUIRED THEN
1860: x_return_status := FND_API.G_RET_STS_ERROR;
1861: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1862: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1863: FND_MSG_PUB.ADD;
1864: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1865:
1866: WHEN DUPLICATE_RECORD THEN

Line 1868: FND_MESSAGE.SET_NAME('GMP', 'PS_DUP_REC');

1864: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1865:
1866: WHEN DUPLICATE_RECORD THEN
1867: x_return_status := FND_API.G_RET_STS_ERROR;
1868: FND_MESSAGE.SET_NAME('GMP', 'PS_DUP_REC');
1869: FND_MSG_PUB.ADD;
1870: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1871:
1872: END check_instance_data ;