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 273: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

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

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

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

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

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

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

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

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

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

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

660:
661: EXCEPTION
662: WHEN INVALID_VALUE THEN
663: x_return_status := FND_API.G_RET_STS_ERROR;
664: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
665: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
666: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
667: FND_MSG_PUB.ADD;
668: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);

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

661: EXCEPTION
662: WHEN INVALID_VALUE THEN
663: x_return_status := FND_API.G_RET_STS_ERROR;
664: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
665: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
666: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
667: FND_MSG_PUB.ADD;
668: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
669:

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

662: WHEN INVALID_VALUE THEN
663: x_return_status := FND_API.G_RET_STS_ERROR;
664: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
665: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
666: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
667: FND_MSG_PUB.ADD;
668: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
669:
670: WHEN INVALID_ORGN_CODE THEN

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

668: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
669:
670: WHEN INVALID_ORGN_CODE THEN
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MESSAGE.SET_NAME('GMI','IC_ORGNCODERR');
673: FND_MSG_PUB.ADD;
674: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
675:
676: WHEN BAD_RESOURCE THEN

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

674: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
675:
676: WHEN BAD_RESOURCE THEN
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MESSAGE.SET_NAME('GMP','BAD_RESOURCE');
679: FND_MSG_PUB.ADD;
680: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
681:
682: WHEN CR_POSITIVE THEN

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

680: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
681:
682: WHEN CR_POSITIVE THEN
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: FND_MESSAGE.SET_NAME('GMP','CR_POSITIVE');
685: fnd_file.put_line(fnd_file.log,'Qty Entered is < 0');
686: FND_MSG_PUB.ADD;
687: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
688:

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

687: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
688:
689: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
692: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
693: FND_MSG_PUB.ADD;
694: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
695:

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

688:
689: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
690: x_return_status := FND_API.G_RET_STS_ERROR;
691: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
692: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
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 ASSIGNED_QTY_REQUIRED THEN

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

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

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

695:
696: WHEN ASSIGNED_QTY_REQUIRED THEN
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
699: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
700: FND_MSG_PUB.ADD;
701: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
702:
703: WHEN INVALID_USAGE_UM THEN

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

701: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
702:
703: WHEN INVALID_USAGE_UM THEN
704: x_return_status := FND_API.G_RET_STS_ERROR;
705: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
706: FND_MSG_PUB.ADD;
707: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
708:
709: WHEN INVALID_CAPACITY_UOM THEN

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

707: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
708:
709: WHEN INVALID_CAPACITY_UOM THEN
710: x_return_status := FND_API.G_RET_STS_ERROR;
711: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
712: FND_MSG_PUB.ADD;
713: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
714:
715: WHEN INVALID_UOM_TYPE THEN

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

713: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
714:
715: WHEN INVALID_UOM_TYPE THEN
716: x_return_status := FND_API.G_RET_STS_ERROR;
717: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');
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 CAPACITY_NOT_IN_RANGE THEN

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

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

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

725: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
726:
727: WHEN QC_MIN_MAX_SPEC THEN
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: FND_MESSAGE.SET_NAME('GMD','QC_MIN_MAX_SPEC');
730: FND_MSG_PUB.ADD;
731: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
732:
733: WHEN RESOURCE_REQUIRED THEN

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

731: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
732:
733: WHEN RESOURCE_REQUIRED THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
736: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
739:

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

732:
733: WHEN RESOURCE_REQUIRED THEN
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
736: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
739:
740: WHEN DUPLICATE_RECORD THEN

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

738: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
739:
740: WHEN DUPLICATE_RECORD THEN
741: x_return_status := FND_API.G_RET_STS_ERROR;
742: FND_MESSAGE.SET_NAME('GMP', 'PS_DUP_REC');
743: FND_MSG_PUB.ADD;
744: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
745:
746: END check_data;

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

1140: x_return_status := FND_API.G_RET_STS_ERROR;
1141:
1142: WHEN RESOURCES_REQUIRED THEN
1143: x_return_status := 'E' ;
1144: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
1145: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1146: FND_MSG_PUB.ADD;
1147: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1148: WHEN OTHERS THEN

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

1141:
1142: WHEN RESOURCES_REQUIRED THEN
1143: x_return_status := 'E' ;
1144: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
1145: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1146: FND_MSG_PUB.ADD;
1147: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1148: WHEN OTHERS THEN
1149: ROLLBACK TO SAVEPOINT update_resource_dtl;

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

1147: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1148: WHEN OTHERS THEN
1149: ROLLBACK TO SAVEPOINT update_resource_dtl;
1150: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1151: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1152: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1153: FND_MSG_PUB.ADD;
1154: fnd_msg_pub.count_and_get (
1155: p_count => x_message_count

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

1148: WHEN OTHERS THEN
1149: ROLLBACK TO SAVEPOINT update_resource_dtl;
1150: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1151: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1152: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1153: FND_MSG_PUB.ADD;
1154: fnd_msg_pub.count_and_get (
1155: p_count => x_message_count
1156: ,p_encoded => FND_API.g_false

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

1280:
1281: EXCEPTION
1282: WHEN no_data_found THEN
1283: ROLLBACK TO SAVEPOINT update_instances;
1284: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1285: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1286: FND_MSG_PUB.ADD;
1287: x_return_status := FND_API.g_ret_sts_unexp_error;
1288: WHEN OTHERS THEN

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

1281: EXCEPTION
1282: WHEN no_data_found THEN
1283: ROLLBACK TO SAVEPOINT update_instances;
1284: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1285: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1286: FND_MSG_PUB.ADD;
1287: x_return_status := FND_API.g_ret_sts_unexp_error;
1288: WHEN OTHERS THEN
1289: ROLLBACK TO SAVEPOINT update_resource_dtl;

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

1286: FND_MSG_PUB.ADD;
1287: x_return_status := FND_API.g_ret_sts_unexp_error;
1288: WHEN OTHERS THEN
1289: ROLLBACK TO SAVEPOINT update_resource_dtl;
1290: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1291: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1292: FND_MSG_PUB.ADD;
1293: x_return_status := FND_API.g_ret_sts_unexp_error;
1294: END update_detail_rows;

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

1287: x_return_status := FND_API.g_ret_sts_unexp_error;
1288: WHEN OTHERS THEN
1289: ROLLBACK TO SAVEPOINT update_resource_dtl;
1290: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1291: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1292: FND_MSG_PUB.ADD;
1293: x_return_status := FND_API.g_ret_sts_unexp_error;
1294: END update_detail_rows;
1295:

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

1447: ,p_encoded => FND_API.g_false
1448: ,p_data => x_message_list);
1449: x_return_status := FND_API.G_RET_STS_ERROR;
1450: WHEN RESOURCES_REQUIRED THEN
1451: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
1452: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1453: FND_MSG_PUB.ADD;
1454: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1455: WHEN OTHERS THEN

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

1448: ,p_data => x_message_list);
1449: x_return_status := FND_API.G_RET_STS_ERROR;
1450: WHEN RESOURCES_REQUIRED THEN
1451: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');
1452: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1453: FND_MSG_PUB.ADD;
1454: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1455: WHEN OTHERS THEN
1456: ROLLBACK TO SAVEPOINT update_instances;

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

1454: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
1455: WHEN OTHERS THEN
1456: ROLLBACK TO SAVEPOINT update_instances;
1457: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1458: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1459: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1460: FND_MSG_PUB.ADD;
1461: fnd_msg_pub.count_and_get (
1462: p_count => x_message_count

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

1455: WHEN OTHERS THEN
1456: ROLLBACK TO SAVEPOINT update_instances;
1457: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1458: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1459: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1460: FND_MSG_PUB.ADD;
1461: fnd_msg_pub.count_and_get (
1462: p_count => x_message_count
1463: ,p_encoded => FND_API.g_false

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

1542:
1543: EXCEPTION
1544: WHEN no_data_found THEN
1545: ROLLBACK TO SAVEPOINT update_instances;
1546: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1547: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1548: FND_MSG_PUB.ADD;
1549: x_return_status := FND_API.g_ret_sts_unexp_error;
1550: WHEN OTHERS THEN

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

1543: EXCEPTION
1544: WHEN no_data_found THEN
1545: ROLLBACK TO SAVEPOINT update_instances;
1546: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1547: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1548: FND_MSG_PUB.ADD;
1549: x_return_status := FND_API.g_ret_sts_unexp_error;
1550: WHEN OTHERS THEN
1551: ROLLBACK TO SAVEPOINT update_instances;

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

1548: FND_MSG_PUB.ADD;
1549: x_return_status := FND_API.g_ret_sts_unexp_error;
1550: WHEN OTHERS THEN
1551: ROLLBACK TO SAVEPOINT update_instances;
1552: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1553: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1554: FND_MSG_PUB.ADD;
1555: x_return_status := FND_API.g_ret_sts_unexp_error;
1556: END update_instance_row ;

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

1549: x_return_status := FND_API.g_ret_sts_unexp_error;
1550: WHEN OTHERS THEN
1551: ROLLBACK TO SAVEPOINT update_instances;
1552: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1553: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1554: FND_MSG_PUB.ADD;
1555: x_return_status := FND_API.g_ret_sts_unexp_error;
1556: END update_instance_row ;
1557:

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

1680: x_return_status := FND_API.G_RET_STS_ERROR;
1681: WHEN OTHERS THEN
1682: ROLLBACK TO SAVEPOINT delete_resources;
1683: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1684: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1685: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1686: FND_MSG_PUB.ADD;
1687: fnd_msg_pub.count_and_get (
1688: p_count => x_message_count

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

1681: WHEN OTHERS THEN
1682: ROLLBACK TO SAVEPOINT delete_resources;
1683: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1684: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1685: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1686: FND_MSG_PUB.ADD;
1687: fnd_msg_pub.count_and_get (
1688: p_count => x_message_count
1689: ,p_encoded => FND_API.g_false

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

1870: EXCEPTION
1871:
1872: WHEN INVALID_DATE_RANGE THEN
1873: x_return_status := FND_API.G_RET_STS_ERROR;
1874: FND_MESSAGE.SET_NAME('GMP','MR_STARTENDDATEERR');
1875: FND_MSG_PUB.ADD;
1876: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1877:
1878: WHEN INVALID_VALUE THEN

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

1876: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1877:
1878: WHEN INVALID_VALUE THEN
1879: x_return_status := FND_API.G_RET_STS_ERROR;
1880: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1881: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1882: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1883: FND_MSG_PUB.ADD;
1884: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);

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

1877:
1878: WHEN INVALID_VALUE THEN
1879: x_return_status := FND_API.G_RET_STS_ERROR;
1880: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1881: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1882: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1883: FND_MSG_PUB.ADD;
1884: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1885:

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

1878: WHEN INVALID_VALUE THEN
1879: x_return_status := FND_API.G_RET_STS_ERROR;
1880: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');
1881: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1882: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1883: FND_MSG_PUB.ADD;
1884: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1885:
1886: WHEN RESOURCE_REQUIRED THEN

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

1884: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1885:
1886: WHEN RESOURCE_REQUIRED THEN
1887: x_return_status := FND_API.G_RET_STS_ERROR;
1888: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1889: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1890: FND_MSG_PUB.ADD;
1891: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1892:

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

1885:
1886: WHEN RESOURCE_REQUIRED THEN
1887: x_return_status := FND_API.G_RET_STS_ERROR;
1888: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');
1889: FND_MESSAGE.SET_TOKEN('VALUE_REQUIRED',X_msg);
1890: FND_MSG_PUB.ADD;
1891: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1892:
1893: WHEN DUPLICATE_RECORD THEN

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

1891: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1892:
1893: WHEN DUPLICATE_RECORD THEN
1894: x_return_status := FND_API.G_RET_STS_ERROR;
1895: FND_MESSAGE.SET_NAME('GMP', 'PS_DUP_REC');
1896: FND_MSG_PUB.ADD;
1897: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1898:
1899: END check_instance_data ;