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_API

Line 68: l_return_status := FND_API.G_RET_STS_SUCCESS;

64: BEGIN
65:
66: v_resource_id := NULL ;
67: v_instance_id := NULL ;
68: l_return_status := FND_API.G_RET_STS_SUCCESS;
69: g_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: SAVEPOINT create_resource_dtl;
72:

Line 69: g_return_status := FND_API.G_RET_STS_SUCCESS;

65:
66: v_resource_id := NULL ;
67: v_instance_id := NULL ;
68: l_return_status := FND_API.G_RET_STS_SUCCESS;
69: g_return_status := FND_API.G_RET_STS_SUCCESS;
70:
71: SAVEPOINT create_resource_dtl;
72:
73: fnd_file.put_line(fnd_file.log,'CreateResourceDtlPub');

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS;

72:
73: fnd_file.put_line(fnd_file.log,'CreateResourceDtlPub');
74:
75: /* Set the return status to success initially */
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77: l_resources_rec := p_resources;
78: l_rsrc_instances := p_rsrc_instances;
79:
80: /* Initialize message list and count if needed */

Line 86: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

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
87: ,p_api_version
88: ,'INSERT_RESOURCE_DTL'
89: ,GMP_RESOURCE_DTL_PUB.m_pkg_name) THEN
90: x_return_status := FND_API.G_RET_STS_ERROR;

Line 90: x_return_status := FND_API.G_RET_STS_ERROR;

86: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version
87: ,p_api_version
88: ,'INSERT_RESOURCE_DTL'
89: ,GMP_RESOURCE_DTL_PUB.m_pkg_name) THEN
90: x_return_status := FND_API.G_RET_STS_ERROR;
91: RAISE invalid_version;
92: END IF;
93:
94: /* B4724360 Rajesh Patangya INVCONV */

Line 279: ,p_encoded => FND_API.g_false

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:
282: IF x_message_count = 0 THEN
283: -- x_return_status := 'S' ;

Line 295: ,p_encoded => FND_API.g_false

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;
298:
299: WHEN resource_id_required THEN

Line 297: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 300: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

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');
308: FND_MSG_PUB.ADD;
309: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
310:

Line 318: ,p_encoded => FND_API.g_false

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;
321: END insert_resource_dtl;
322:

Line 320: x_return_status := FND_API.g_ret_sts_unexp_error;

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;
321: END insert_resource_dtl;
322:
323: /* =============================================================== */
324: /* Procedure: */

Line 663: x_return_status := FND_API.G_RET_STS_ERROR;

659: END IF;
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;

Line 671: x_return_status := FND_API.G_RET_STS_ERROR;

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');
673: FND_MSG_PUB.ADD;
674: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
675:

Line 677: x_return_status := FND_API.G_RET_STS_ERROR;

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');
679: FND_MSG_PUB.ADD;
680: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
681:

Line 683: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 690: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 697: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

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');
706: FND_MSG_PUB.ADD;
707: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
708:

Line 710: x_return_status := FND_API.G_RET_STS_ERROR;

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');
712: FND_MSG_PUB.ADD;
713: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
714:

Line 716: x_return_status := FND_API.G_RET_STS_ERROR;

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');
718: FND_MSG_PUB.ADD;
719: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
720:

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

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');
724: FND_MSG_PUB.ADD;
725: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
726:

Line 728: x_return_status := FND_API.G_RET_STS_ERROR;

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');
730: FND_MSG_PUB.ADD;
731: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
732:

Line 734: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 741: x_return_status := FND_API.G_RET_STS_ERROR;

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');
743: FND_MSG_PUB.ADD;
744: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count, p_data=>x_message_list);
745:

Line 1002: l_return_status := FND_API.G_RET_STS_SUCCESS;

998: RESOURCE_ID_REQUIRED EXCEPTION;
999:
1000:
1001: BEGIN
1002: l_return_status := FND_API.G_RET_STS_SUCCESS;
1003: g_return_status := FND_API.G_RET_STS_SUCCESS;
1004: X_msg := '';
1005:
1006: SAVEPOINT update_resource_dtl;

Line 1003: g_return_status := FND_API.G_RET_STS_SUCCESS;

999:
1000:
1001: BEGIN
1002: l_return_status := FND_API.G_RET_STS_SUCCESS;
1003: g_return_status := FND_API.G_RET_STS_SUCCESS;
1004: X_msg := '';
1005:
1006: SAVEPOINT update_resource_dtl;
1007: fnd_file.put_line(fnd_file.log,'UpdateResourcePub');

Line 1010: x_return_status := FND_API.G_RET_STS_SUCCESS;

1006: SAVEPOINT update_resource_dtl;
1007: fnd_file.put_line(fnd_file.log,'UpdateResourcePub');
1008:
1009: /* Set the return status to success initially */
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;

Line 1018: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

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
1019: ,p_api_version
1020: ,l_api_name
1021: ,GMP_RESOURCE_DTL_PUB.m_pkg_name) THEN
1022: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1022: x_return_status := FND_API.G_RET_STS_ERROR;

1018: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version
1019: ,p_api_version
1020: ,l_api_name
1021: ,GMP_RESOURCE_DTL_PUB.m_pkg_name) THEN
1022: x_return_status := FND_API.G_RET_STS_ERROR;
1023: RAISE invalid_version;
1024: END IF;
1025:
1026: /* Set the Update Flag to Yes */

Line 1116: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1112: /* set the Update flag back to 'No' */
1113: v_update_flag := 'N';
1114:
1115: /* Check if work was done */
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 (

Line 1118: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */

1114:
1115: /* Check if work was done */
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

Line 1122: ,p_encoded => FND_API.g_false

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:
1125: IF x_message_count = 0 THEN
1126: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');

Line 1138: ,p_encoded => FND_API.g_false

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;
1141:
1142: WHEN RESOURCES_REQUIRED THEN

Line 1140: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1141:
1142: WHEN RESOURCES_REQUIRED THEN
1143: x_return_status := 'E' ;
1144: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

Line 1156: ,p_encoded => FND_API.g_false

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;
1159: END update_resource_dtl;
1160:

Line 1158: x_return_status := FND_API.g_ret_sts_unexp_error;

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;
1159: END update_resource_dtl;
1160:
1161: /* =============================================================== */
1162: /* Procedure: */

Line 1287: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 1293: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 1331: l_return_status := FND_API.G_RET_STS_SUCCESS;

1327: invalid_version EXCEPTION;
1328: RESOURCES_REQUIRED EXCEPTION;
1329:
1330: BEGIN
1331: l_return_status := FND_API.G_RET_STS_SUCCESS;
1332: g_return_status := FND_API.G_RET_STS_SUCCESS;
1333: v_eff_start_date := NULL ;
1334: X_msg := '';
1335:

Line 1332: g_return_status := FND_API.G_RET_STS_SUCCESS;

1328: RESOURCES_REQUIRED EXCEPTION;
1329:
1330: BEGIN
1331: l_return_status := FND_API.G_RET_STS_SUCCESS;
1332: g_return_status := FND_API.G_RET_STS_SUCCESS;
1333: v_eff_start_date := NULL ;
1334: X_msg := '';
1335:
1336: SAVEPOINT update_instances;

Line 1340: x_return_status := FND_API.G_RET_STS_SUCCESS;

1336: SAVEPOINT update_instances;
1337: fnd_file.put_line(fnd_file.log,'UpdateInstancePub');
1338:
1339: /* Set the return status to success initially */
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;

Line 1348: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

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
1349: ,p_api_version
1350: ,l_api_name
1351: ,GMP_RESOURCE_DTL_PUB.m_pkg_name) THEN
1352: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1352: x_return_status := FND_API.G_RET_STS_ERROR;

1348: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version
1349: ,p_api_version
1350: ,l_api_name
1351: ,GMP_RESOURCE_DTL_PUB.m_pkg_name) THEN
1352: x_return_status := FND_API.G_RET_STS_ERROR;
1353: RAISE invalid_version;
1354: END IF;
1355:
1356: /* Set the Update Flag to Yes */

Line 1426: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1422: /* set the Update flag back to 'No' */
1423: v_update_flag := 'N';
1424:
1425: /* Check if work was done */
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 (

Line 1428: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */

1424:
1425: /* Check if work was done */
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

Line 1432: ,p_encoded => FND_API.g_false

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:
1435: IF x_message_count = 0 THEN
1436: fnd_file.put_line(fnd_file.log,'Resource was Updated successfullly');

Line 1447: ,p_encoded => FND_API.g_false

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;
1450: WHEN RESOURCES_REQUIRED THEN
1451: FND_MESSAGE.SET_NAME('GMA','SY_REQUIRED');

Line 1449: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1463: ,p_encoded => FND_API.g_false

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;
1466: END update_instances;
1467:

Line 1465: x_return_status := FND_API.g_ret_sts_unexp_error;

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;
1466: END update_instances;
1467:
1468:
1469: /* =============================================================== */

Line 1549: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 1555: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 1602: l_return_status := FND_API.G_RET_STS_SUCCESS;

1598: BEGIN
1599:
1600: l_counter := 0;
1601: v_resource_id := 0;
1602: l_return_status := FND_API.G_RET_STS_SUCCESS;
1603:
1604: SAVEPOINT delete_resources;
1605: fnd_file.put_line(fnd_file.log,'DeleteResourcePub');
1606:

Line 1608: x_return_status := FND_API.G_RET_STS_SUCCESS;

1604: SAVEPOINT delete_resources;
1605: fnd_file.put_line(fnd_file.log,'DeleteResourcePub');
1606:
1607: /* Set the return status to success initially */
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;

Line 1616: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version

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
1617: ,p_api_version
1618: ,l_api_name
1619: ,GMP_RESOURCE_DTL_PUB.m_pkg_name) THEN
1620: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1620: x_return_status := FND_API.G_RET_STS_ERROR;

1616: IF NOT FND_API.compatible_api_call ( GMP_RESOURCE_DTL_PUB.m_api_version
1617: ,p_api_version
1618: ,l_api_name
1619: ,GMP_RESOURCE_DTL_PUB.m_pkg_name) THEN
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621: RAISE invalid_version;
1622: END IF;
1623:
1624: OPEN Cur_resource_id;

Line 1663: ,p_encoded => FND_API.g_false

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:
1666: IF x_message_count = 0 THEN
1667: fnd_file.put_line(fnd_file.log,'Resource was deleted successfully');

Line 1678: ,p_encoded => FND_API.g_false

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;
1681: WHEN OTHERS THEN
1682: ROLLBACK TO SAVEPOINT delete_resources;

Line 1680: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1689: ,p_encoded => FND_API.g_false

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;
1692: END delete_resources;
1693:

Line 1691: x_return_status := FND_API.g_ret_sts_unexp_error;

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;
1692: END delete_resources;
1693:
1694: /* =============================================================== */
1695: /* Procedure: */

Line 1873: x_return_status := FND_API.G_RET_STS_ERROR;

1869:
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:

Line 1879: x_return_status := FND_API.G_RET_STS_ERROR;

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');
1881: FND_MESSAGE.SET_TOKEN('FIELD',X_field);
1882: FND_MESSAGE.SET_TOKEN('VALUE',X_value);
1883: FND_MSG_PUB.ADD;

Line 1887: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1894: x_return_status := FND_API.G_RET_STS_ERROR;

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');
1896: FND_MSG_PUB.ADD;
1897: FND_MSG_PUB.Count_And_Get(p_count=>x_message_count,p_data=>x_message_list);
1898: