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_MSG_PUB

Line 82: fnd_msg_pub.initialize;

78: l_rsrc_instances := p_rsrc_instances;
79:
80: /* Initialize message list and count if needed */
81: IF p_init_msg_list THEN
82: fnd_msg_pub.initialize;
83: END IF;
84:
85: /* Make sure we are call compatible */
86: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

Line 273: FND_MSG_PUB.ADD;

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 (
277: p_count => x_message_count

Line 276: fnd_msg_pub.count_and_get (

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 (
277: p_count => x_message_count
278: ,p_encoded => FND_API.g_false
279: ,p_data => x_message_list);
280:

Line 292: fnd_msg_pub.count_and_get (

288: WHEN resource_dtl_creation_failure OR invalid_version
289: OR instance_creation_failure THEN
290:
291: ROLLBACK TO SAVEPOINT create_resource_dtl;
292: fnd_msg_pub.count_and_get (
293: p_count => x_message_count
294: ,p_encoded => FND_API.g_false
295: ,p_data => x_message_list);
296: x_return_status := FND_API.G_RET_STS_ERROR;

Line 301: FND_MSG_PUB.ADD;

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
305: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
305: x_return_status := FND_API.G_RET_STS_ERROR;
306: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

Line 307: FND_MSG_PUB.ADD;

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
311: ROLLBACK TO SAVEPOINT create_resource_dtl;

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

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
311: ROLLBACK TO SAVEPOINT create_resource_dtl;
312: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 314: FND_MSG_PUB.ADD;

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
318: ,p_data => x_message_list);

Line 315: fnd_msg_pub.count_and_get (

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
318: ,p_data => x_message_list);
319: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 648: FND_MSG_PUB.ADD;

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
652: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: FND_MESSAGE.SET_NAME('GMI','IC_ORGNCODERR');

Line 654: FND_MSG_PUB.ADD;

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
658: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: FND_MESSAGE.SET_NAME('GMP','BAD_RESOURCE');

Line 660: FND_MSG_PUB.ADD;

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
664: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: FND_MESSAGE.SET_NAME('GMP','CR_POSITIVE');

Line 667: FND_MSG_PUB.ADD;

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:
670: WHEN MIN_MAX_CAPACITY_REQUIRED THEN
671: x_return_status := FND_API.G_RET_STS_ERROR;

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

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:
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');

Line 674: FND_MSG_PUB.ADD;

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
678: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

Line 681: FND_MSG_PUB.ADD;

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
685: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');

Line 687: FND_MSG_PUB.ADD;

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
691: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');

Line 693: FND_MSG_PUB.ADD;

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
697: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
697: x_return_status := FND_API.G_RET_STS_ERROR;
698: FND_MESSAGE.SET_NAME('GMA','SY_INVALID_UM_CODE');

Line 699: FND_MSG_PUB.ADD;

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
703: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
703: x_return_status := FND_API.G_RET_STS_ERROR;
704: FND_MESSAGE.SET_NAME('GMP','CR_CAPACITY_NOT_IN_RANGE');

Line 705: FND_MSG_PUB.ADD;

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
709: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: FND_MESSAGE.SET_NAME('GMD','QC_MIN_MAX_SPEC');

Line 711: FND_MSG_PUB.ADD;

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
715: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
715: x_return_status := FND_API.G_RET_STS_ERROR;
716: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

Line 718: FND_MSG_PUB.ADD;

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
722: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MESSAGE.SET_NAME('GMP', 'PS_DUP_REC');

Line 724: FND_MSG_PUB.ADD;

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;
728:

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

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;
728:
729: /* =============================================================== */

Line 992: fnd_msg_pub.initialize;

988: x_return_status := FND_API.G_RET_STS_SUCCESS;
989:
990: /* Initialize message list and count if needed */
991: IF p_init_msg_list THEN
992: fnd_msg_pub.initialize;
993: END IF;
994:
995: /* Make sure we are call compatible */
996: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

Line 1097: fnd_msg_pub.count_and_get (

1093: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1094: RAISE resource_update_failure;
1095: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1096:
1097: fnd_msg_pub.count_and_get (
1098: p_count => x_message_count
1099: ,p_encoded => FND_API.g_false
1100: ,p_data => x_message_list);
1101:

Line 1113: fnd_msg_pub.count_and_get (

1109:
1110: WHEN resource_update_failure OR invalid_version THEN
1111: ROLLBACK TO SAVEPOINT update_resource_dtl;
1112: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1113: fnd_msg_pub.count_and_get (
1114: p_count => x_message_count
1115: ,p_encoded => FND_API.g_false
1116: ,p_data => x_message_list);
1117: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1123: FND_MSG_PUB.ADD;

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;
1127: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

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

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;
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');

Line 1130: FND_MSG_PUB.ADD;

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
1134: ,p_data => x_message_list);

Line 1131: fnd_msg_pub.count_and_get (

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
1134: ,p_data => x_message_list);
1135: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1259: FND_MSG_PUB.ADD;

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;
1263: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1265: FND_MSG_PUB.ADD;

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:
1269: /* =============================================================== */

Line 1317: fnd_msg_pub.initialize;

1313: x_return_status := FND_API.G_RET_STS_SUCCESS;
1314:
1315: /* Initialize message list and count if needed */
1316: IF p_init_msg_list THEN
1317: fnd_msg_pub.initialize;
1318: END IF;
1319:
1320: /* Make sure we are call compatible */
1321: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

Line 1403: fnd_msg_pub.count_and_get (

1399: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1400: RAISE instance_update_failure;
1401: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1402:
1403: fnd_msg_pub.count_and_get (
1404: p_count => x_message_count
1405: ,p_encoded => FND_API.g_false
1406: ,p_data => x_message_list);
1407:

Line 1418: fnd_msg_pub.count_and_get (

1414: EXCEPTION
1415: WHEN instance_update_failure OR invalid_version THEN
1416: ROLLBACK TO SAVEPOINT update_instances;
1417: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1418: fnd_msg_pub.count_and_get (
1419: p_count => x_message_count
1420: ,p_encoded => FND_API.g_false
1421: ,p_data => x_message_list);
1422: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1426: FND_MSG_PUB.ADD;

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;
1430: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

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

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;
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');

Line 1433: FND_MSG_PUB.ADD;

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
1437: ,p_data => x_message_list);

Line 1434: fnd_msg_pub.count_and_get (

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
1437: ,p_data => x_message_list);
1438: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1521: FND_MSG_PUB.ADD;

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;
1525: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1527: FND_MSG_PUB.ADD;

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:
1531: /* =============================================================== */

Line 1585: fnd_msg_pub.initialize;

1581: x_return_status := FND_API.G_RET_STS_SUCCESS;
1582:
1583: /* Initialize message list and count if needed */
1584: IF p_init_msg_list THEN
1585: fnd_msg_pub.initialize;
1586: END IF;
1587:
1588: /* Make sure we are call compatible */
1589: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

Line 1604: FND_MSG_PUB.ADD;

1600:
1601: IF (v_resource_id = 0 ) then
1602: l_return_status := 'E';
1603: GMD_DEBUG.PUT_LINE('Resource to be deleted Does Not Exist ');
1604: FND_MSG_PUB.ADD;
1605: RAISE resource_delete_failure;
1606: ELSE
1607: -- Added code Rajesh Patangya
1608: -- Resource exception

Line 1634: fnd_msg_pub.count_and_get (

1630: and organization_id = p_organization_id;
1631:
1632: END IF;
1633:
1634: fnd_msg_pub.count_and_get (
1635: p_count => x_message_count
1636: ,p_encoded => FND_API.g_false
1637: ,p_data => x_message_list);
1638:

Line 1649: fnd_msg_pub.count_and_get (

1645: EXCEPTION
1646: WHEN resource_delete_failure OR invalid_version THEN
1647: ROLLBACK TO SAVEPOINT delete_resources;
1648: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1649: fnd_msg_pub.count_and_get (
1650: p_count => x_message_count
1651: ,p_encoded => FND_API.g_false
1652: ,p_data => x_message_list);
1653: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1659: FND_MSG_PUB.ADD;

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
1663: ,p_data => x_message_list);

Line 1660: fnd_msg_pub.count_and_get (

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
1663: ,p_data => x_message_list);
1664: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1848: FND_MSG_PUB.ADD;

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
1852: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
1852: x_return_status := FND_API.G_RET_STS_ERROR;
1853: FND_MESSAGE.SET_NAME('GMP','GMP_INVALID_VALUE');

Line 1856: FND_MSG_PUB.ADD;

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
1860: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
1860: x_return_status := FND_API.G_RET_STS_ERROR;
1861: FND_MESSAGE.SET_NAME('GMP','GMP_VALUE_REQUIRED');

Line 1863: FND_MSG_PUB.ADD;

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
1867: x_return_status := FND_API.G_RET_STS_ERROR;

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

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
1867: x_return_status := FND_API.G_RET_STS_ERROR;
1868: FND_MESSAGE.SET_NAME('GMP', 'PS_DUP_REC');

Line 1869: FND_MSG_PUB.ADD;

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 ;
1873:

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

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 ;
1873:
1874: END GMP_RESOURCE_DTL_PUB;