[Home] [Help]
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
9: -- klou 04/03/00 Modify procedure to fix bug 1238607.
10: -- klou 02/08/00 Add standard messages.
11: -- klou 01/12/00 Replace change AS_UTILITY call with JTF_PLSQL_API.
12: -- klou 01/03/00 Modify the validations so that when a not null picklist_line_id is passed for
13: -- insert operation, it checks whether an identical picklist_line_id exists. It yes,
14: -- raise an exception because picklist_line_id should be unique.
15: -- klou 12/23/99 Add validations to creation_date and last_update_date
622: fnd_msg_pub.count_and_get
623: ( p_count => x_msg_count
624: , p_data => x_msg_data);
625: WHEN FND_API.G_EXC_ERROR THEN
626: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
627: P_API_NAME => L_API_NAME
628: ,P_PKG_NAME => G_PKG_NAME
629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
630: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
626: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
627: P_API_NAME => L_API_NAME
628: ,P_PKG_NAME => G_PKG_NAME
629: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
630: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
631: ,X_MSG_COUNT => X_MSG_COUNT
632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
631: ,X_MSG_COUNT => X_MSG_COUNT
632: ,X_MSG_DATA => X_MSG_DATA
633: ,X_RETURN_STATUS => X_RETURN_STATUS);
634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
635: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
639: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
635: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
636: P_API_NAME => L_API_NAME
637: ,P_PKG_NAME => G_PKG_NAME
638: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
639: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
640: ,X_MSG_COUNT => X_MSG_COUNT
641: ,X_MSG_DATA => X_MSG_DATA
642: ,X_RETURN_STATUS => X_RETURN_STATUS);
643: WHEN OTHERS THEN