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 548: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1122: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||': After Update of Val Rules ');
1123: END IF;
1124:
1125: /* Check if work was done */
1126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1127: RAISE vr_update_failure;
1128: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1129:
1130: /* Get the messgae list and count generated by this API */

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

1124:
1125: /* Check if work was done */
1126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1127: RAISE vr_update_failure;
1128: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1129:
1130: /* Get the messgae list and count generated by this API */
1131: fnd_msg_pub.count_and_get (
1132: p_count => x_message_count

Line 1133: ,p_encoded => FND_API.g_false

1129:
1130: /* Get the messgae list and count generated by this API */
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:
1136: IF (l_debug = 'Y') THEN
1137: gmd_debug.put_line(m_pkg_name||'.'||l_api_name

Line 1146: x_return_status := FND_API.G_RET_STS_ERROR;

1142: WHEN vr_update_failure OR invalid_version THEN
1143: IF (l_debug = 'Y') THEN
1144: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1145: END IF;
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: fnd_msg_pub.count_and_get (
1148: p_count => x_message_count
1149: ,p_encoded => FND_API.g_false
1150: ,p_data => x_message_list);

Line 1149: ,p_encoded => FND_API.g_false

1145: END IF;
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: fnd_msg_pub.count_and_get (
1148: p_count => x_message_count
1149: ,p_encoded => FND_API.g_false
1150: ,p_data => x_message_list);
1151: WHEN last_update_date_failure THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');

Line 1152: x_return_status := FND_API.G_RET_STS_ERROR;

1148: p_count => x_message_count
1149: ,p_encoded => FND_API.g_false
1150: ,p_data => x_message_list);
1151: WHEN last_update_date_failure THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1154: FND_MSG_PUB.ADD;
1155: fnd_msg_pub.count_and_get (
1156: p_count => x_message_count

Line 1157: ,p_encoded => FND_API.g_false

1153: FND_MESSAGE.SET_NAME('FND', 'FND_RECORD_CHANGED_ERROR');
1154: FND_MSG_PUB.ADD;
1155: fnd_msg_pub.count_and_get (
1156: p_count => x_message_count
1157: ,p_encoded => FND_API.g_false
1158: ,p_data => x_message_list);
1159: WHEN setup_failure THEN
1160: x_return_status := FND_API.G_RET_STS_ERROR;
1161: fnd_msg_pub.count_and_get (

Line 1160: x_return_status := FND_API.G_RET_STS_ERROR;

1156: p_count => x_message_count
1157: ,p_encoded => FND_API.g_false
1158: ,p_data => x_message_list);
1159: WHEN setup_failure THEN
1160: x_return_status := FND_API.G_RET_STS_ERROR;
1161: fnd_msg_pub.count_and_get (
1162: p_count => x_message_count
1163: ,p_encoded => FND_API.g_false
1164: ,p_data => x_message_list);

Line 1163: ,p_encoded => FND_API.g_false

1159: WHEN setup_failure THEN
1160: x_return_status := FND_API.G_RET_STS_ERROR;
1161: fnd_msg_pub.count_and_get (
1162: p_count => x_message_count
1163: ,p_encoded => FND_API.g_false
1164: ,p_data => x_message_list);
1165: WHEN OTHERS THEN
1166: IF (l_debug = 'Y') THEN
1167: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);

Line 1170: x_return_status := FND_API.g_ret_sts_unexp_error;

1166: IF (l_debug = 'Y') THEN
1167: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1168: END IF;
1169: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1170: x_return_status := FND_API.g_ret_sts_unexp_error;
1171: fnd_msg_pub.count_and_get (
1172: p_count => x_message_count
1173: ,p_encoded => FND_API.g_false
1174: ,p_data => x_message_list);

Line 1173: ,p_encoded => FND_API.g_false

1169: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1170: x_return_status := FND_API.g_ret_sts_unexp_error;
1171: fnd_msg_pub.count_and_get (
1172: p_count => x_message_count
1173: ,p_encoded => FND_API.g_false
1174: ,p_data => x_message_list);
1175: END update_validity_rules;
1176:
1177: END GMD_VALIDITY_RULES_PVT;