DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES_PVT dependencies on FND_API

Line 79: x_return_status := FND_API.g_ret_sts_unexp_error;

75:
76: EXCEPTION
77: WHEN OTHERS THEN
78: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
79: x_return_status := FND_API.g_ret_sts_unexp_error;
80: END validate_start_date;
81:
82: /*#####################################################
83: # NAME

Line 118: x_return_status := FND_API.g_ret_sts_unexp_error;

114:
115: EXCEPTION
116: WHEN OTHERS THEN
117: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
118: x_return_status := FND_API.g_ret_sts_unexp_error;
119: END validate_end_date;
120:
121:
122: /*#####################################################

Line 148: x_return_status := FND_API.g_ret_sts_unexp_error;

144: END IF;
145: EXCEPTION
146: WHEN OTHERS THEN
147: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
148: x_return_status := FND_API.g_ret_sts_unexp_error;
149: END effective_dates;
150:
151: /*###################################################################
152: # NAME

Line 187: x_return_status := FND_API.g_ret_sts_unexp_error;

183: END IF; -- end if std qty is not null
184: EXCEPTION
185: WHEN OTHERS THEN
186: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
187: x_return_status := FND_API.g_ret_sts_unexp_error;
188: END std_qty;
189:
190: /*#####################################################
191: # NAME

Line 223: x_return_status := FND_API.g_ret_sts_unexp_error;

219: END IF; -- IF P_max_qty IS NOT NULL
220: EXCEPTION
221: WHEN OTHERS THEN
222: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
223: x_return_status := FND_API.g_ret_sts_unexp_error;
224: END max_qty;
225:
226:
227: /*#####################################################

Line 289: x_return_status := FND_API.g_ret_sts_unexp_error;

285: X_inv_max_qty := ROUND(X_inv_max_qty,5);
286: EXCEPTION
287: WHEN OTHERS THEN
288: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
289: x_return_status := FND_API.g_ret_sts_unexp_error;
290: END calc_inv_qtys;
291:
292: /*#####################################################
293: # NAME

Line 356: x_return_status := FND_API.g_ret_sts_unexp_error;

352: END IF;
353: EXCEPTION
354: WHEN OTHERS THEN
355: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
356: x_return_status := FND_API.g_ret_sts_unexp_error;
357: END calculate_process_loss;
358:
359: /*#####################################################
360: # NAME

Line 436: x_return_status := FND_API.g_ret_sts_unexp_error;

432: END LOOP;
433: EXCEPTION
434: WHEN OTHERS THEN
435: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
436: x_return_status := FND_API.g_ret_sts_unexp_error;
437: END check_for_duplicate;
438:
439:
440: /* =============================================================== */

Line 545: x_return_status := FND_API.G_RET_STS_SUCCESS;

541: RAISE setup_failure;
542: END IF;
543:
544: /* Set the return status to success initially */
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547: IF (l_debug = 'Y') THEN
548: gmd_debug.put_line(m_pkg_name||'.'||l_api_name
549: ||' : About to get the db VR record for VR id = '

Line 1113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1109: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||': After Update of Val Rules ');
1110: END IF;
1111:
1112: /* Check if work was done */
1113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1114: RAISE vr_update_failure;
1115: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1116:
1117: /* Get the messgae list and count generated by this API */

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

1111:
1112: /* Check if work was done */
1113: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1114: RAISE vr_update_failure;
1115: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1116:
1117: /* Get the messgae list and count generated by this API */
1118: fnd_msg_pub.count_and_get (
1119: p_count => x_message_count

Line 1120: ,p_encoded => FND_API.g_false

1116:
1117: /* Get the messgae list and count generated by this API */
1118: fnd_msg_pub.count_and_get (
1119: p_count => x_message_count
1120: ,p_encoded => FND_API.g_false
1121: ,p_data => x_message_list);
1122:
1123: IF (l_debug = 'Y') THEN
1124: gmd_debug.put_line(m_pkg_name||'.'||l_api_name

Line 1133: x_return_status := FND_API.G_RET_STS_ERROR;

1129: WHEN vr_update_failure OR invalid_version THEN
1130: IF (l_debug = 'Y') THEN
1131: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1132: END IF;
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: fnd_msg_pub.count_and_get (
1135: p_count => x_message_count
1136: ,p_encoded => FND_API.g_false
1137: ,p_data => x_message_list);

Line 1136: ,p_encoded => FND_API.g_false

1132: END IF;
1133: x_return_status := FND_API.G_RET_STS_ERROR;
1134: fnd_msg_pub.count_and_get (
1135: p_count => x_message_count
1136: ,p_encoded => FND_API.g_false
1137: ,p_data => x_message_list);
1138: WHEN last_update_date_failure THEN
1139: x_return_status := FND_API.G_RET_STS_ERROR;
1140: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

Line 1139: x_return_status := FND_API.G_RET_STS_ERROR;

1135: p_count => x_message_count
1136: ,p_encoded => FND_API.g_false
1137: ,p_data => x_message_list);
1138: WHEN last_update_date_failure THEN
1139: x_return_status := FND_API.G_RET_STS_ERROR;
1140: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1141: FND_MSG_PUB.ADD;
1142: fnd_msg_pub.count_and_get (
1143: p_count => x_message_count

Line 1144: ,p_encoded => FND_API.g_false

1140: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1141: FND_MSG_PUB.ADD;
1142: fnd_msg_pub.count_and_get (
1143: p_count => x_message_count
1144: ,p_encoded => FND_API.g_false
1145: ,p_data => x_message_list);
1146: WHEN setup_failure THEN
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: fnd_msg_pub.count_and_get (

Line 1147: x_return_status := FND_API.G_RET_STS_ERROR;

1143: p_count => x_message_count
1144: ,p_encoded => FND_API.g_false
1145: ,p_data => x_message_list);
1146: WHEN setup_failure THEN
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: fnd_msg_pub.count_and_get (
1149: p_count => x_message_count
1150: ,p_encoded => FND_API.g_false
1151: ,p_data => x_message_list);

Line 1150: ,p_encoded => FND_API.g_false

1146: WHEN setup_failure THEN
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: fnd_msg_pub.count_and_get (
1149: p_count => x_message_count
1150: ,p_encoded => FND_API.g_false
1151: ,p_data => x_message_list);
1152: WHEN OTHERS THEN
1153: IF (l_debug = 'Y') THEN
1154: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

Line 1157: x_return_status := FND_API.g_ret_sts_unexp_error;

1153: IF (l_debug = 'Y') THEN
1154: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1155: END IF;
1156: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1157: x_return_status := FND_API.g_ret_sts_unexp_error;
1158: fnd_msg_pub.count_and_get (
1159: p_count => x_message_count
1160: ,p_encoded => FND_API.g_false
1161: ,p_data => x_message_list);

Line 1160: ,p_encoded => FND_API.g_false

1156: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1157: x_return_status := FND_API.g_ret_sts_unexp_error;
1158: fnd_msg_pub.count_and_get (
1159: p_count => x_message_count
1160: ,p_encoded => FND_API.g_false
1161: ,p_data => x_message_list);
1162: END update_validity_rules;
1163:
1164: END GMD_VALIDITY_RULES_PVT;