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

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

Line 277: fnd_msg_pub.count_and_get (

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

Line 293: fnd_msg_pub.count_and_get (

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

Line 302: FND_MSG_PUB.ADD;

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

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

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

Line 308: FND_MSG_PUB.ADD;

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

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

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

Line 315: FND_MSG_PUB.ADD;

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

Line 316: fnd_msg_pub.count_and_get (

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

Line 667: FND_MSG_PUB.ADD;

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

Line 673: FND_MSG_PUB.ADD;

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

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

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

Line 679: FND_MSG_PUB.ADD;

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

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

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

Line 686: FND_MSG_PUB.ADD;

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

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

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

Line 693: FND_MSG_PUB.ADD;

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

Line 700: FND_MSG_PUB.ADD;

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

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

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

Line 706: FND_MSG_PUB.ADD;

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

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

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

Line 712: FND_MSG_PUB.ADD;

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

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

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

Line 718: FND_MSG_PUB.ADD;

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

Line 724: FND_MSG_PUB.ADD;

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

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

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

Line 730: FND_MSG_PUB.ADD;

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

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

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

Line 737: FND_MSG_PUB.ADD;

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

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

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

Line 743: FND_MSG_PUB.ADD;

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

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

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;
747:
748: /* =============================================================== */

Line 1014: fnd_msg_pub.initialize;

1010: x_return_status := FND_API.G_RET_STS_SUCCESS;
1011:
1012: /* Initialize message list and count if needed */
1013: IF p_init_msg_list THEN
1014: fnd_msg_pub.initialize;
1015: END IF;
1016:
1017: /* Make sure we are call compatible */
1018: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

Line 1120: fnd_msg_pub.count_and_get (

1116: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1117: RAISE resource_update_failure;
1118: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1119:
1120: fnd_msg_pub.count_and_get (
1121: p_count => x_message_count
1122: ,p_encoded => FND_API.g_false
1123: ,p_data => x_message_list);
1124:

Line 1136: fnd_msg_pub.count_and_get (

1132:
1133: WHEN resource_update_failure OR invalid_version THEN
1134: ROLLBACK TO SAVEPOINT update_resource_dtl;
1135: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1136: fnd_msg_pub.count_and_get (
1137: p_count => x_message_count
1138: ,p_encoded => FND_API.g_false
1139: ,p_data => x_message_list);
1140: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1146: FND_MSG_PUB.ADD;

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

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

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

Line 1153: FND_MSG_PUB.ADD;

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

Line 1154: fnd_msg_pub.count_and_get (

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

Line 1286: FND_MSG_PUB.ADD;

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

Line 1292: FND_MSG_PUB.ADD;

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

Line 1344: fnd_msg_pub.initialize;

1340: x_return_status := FND_API.G_RET_STS_SUCCESS;
1341:
1342: /* Initialize message list and count if needed */
1343: IF p_init_msg_list THEN
1344: fnd_msg_pub.initialize;
1345: END IF;
1346:
1347: /* Make sure we are call compatible */
1348: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

Line 1430: fnd_msg_pub.count_and_get (

1426: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1427: RAISE instance_update_failure;
1428: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1429:
1430: fnd_msg_pub.count_and_get (
1431: p_count => x_message_count
1432: ,p_encoded => FND_API.g_false
1433: ,p_data => x_message_list);
1434:

Line 1445: fnd_msg_pub.count_and_get (

1441: EXCEPTION
1442: WHEN instance_update_failure OR invalid_version THEN
1443: ROLLBACK TO SAVEPOINT update_instances;
1444: fnd_file.put_line (fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1445: fnd_msg_pub.count_and_get (
1446: p_count => x_message_count
1447: ,p_encoded => FND_API.g_false
1448: ,p_data => x_message_list);
1449: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1453: FND_MSG_PUB.ADD;

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

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

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

Line 1460: FND_MSG_PUB.ADD;

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

Line 1461: fnd_msg_pub.count_and_get (

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

Line 1548: FND_MSG_PUB.ADD;

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

Line 1554: FND_MSG_PUB.ADD;

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

Line 1612: fnd_msg_pub.initialize;

1608: x_return_status := FND_API.G_RET_STS_SUCCESS;
1609:
1610: /* Initialize message list and count if needed */
1611: IF p_init_msg_list THEN
1612: fnd_msg_pub.initialize;
1613: END IF;
1614:
1615: /* Make sure we are call compatible */
1616: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

Line 1631: FND_MSG_PUB.ADD;

1627:
1628: IF (v_resource_id = 0 ) then
1629: l_return_status := 'E';
1630: GMD_DEBUG.PUT_LINE('Resource to be deleted Does Not Exist ');
1631: FND_MSG_PUB.ADD;
1632: RAISE resource_delete_failure;
1633: ELSE
1634: -- Added code Rajesh Patangya
1635: -- Resource exception

Line 1661: fnd_msg_pub.count_and_get (

1657: and organization_id = p_organization_id;
1658:
1659: END IF;
1660:
1661: fnd_msg_pub.count_and_get (
1662: p_count => x_message_count
1663: ,p_encoded => FND_API.g_false
1664: ,p_data => x_message_list);
1665:

Line 1676: fnd_msg_pub.count_and_get (

1672: EXCEPTION
1673: WHEN resource_delete_failure OR invalid_version THEN
1674: ROLLBACK TO SAVEPOINT delete_resources;
1675: fnd_file.put_line(fnd_file.log,m_pkg_name||'.'||l_api_name||':'||'API not complete');
1676: fnd_msg_pub.count_and_get (
1677: p_count => x_message_count
1678: ,p_encoded => FND_API.g_false
1679: ,p_data => x_message_list);
1680: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1686: FND_MSG_PUB.ADD;

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

Line 1687: fnd_msg_pub.count_and_get (

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

Line 1875: FND_MSG_PUB.ADD;

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

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

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

Line 1883: FND_MSG_PUB.ADD;

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

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

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

Line 1890: FND_MSG_PUB.ADD;

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

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

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

Line 1896: FND_MSG_PUB.ADD;

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

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

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 ;
1900:
1901: END GMP_RESOURCE_DTL_PUB;