[Home] [Help]
6: -- MODIFICATION HISTORY
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.
89: l_picklist_line_id NUMBER := 0;
90: l_creation_date DATE := p_creation_date;
91: l_last_update_date DATE := p_last_update_date;
92: -- for inserting data, the validation_level should be none
93: -- because we do not want to call the core apps standard validations.
94: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_NONE;
95: EXCP_USER_DEFINED EXCEPTION;
96: l_created_by NUMBER := p_created_by;
97: l_last_update_login NUMBER := p_last_update_login;
107: -- initialize message list
108: FND_MSG_PUB.initialize;
109: END IF;
110:
111: -- Standard call to check for call compatibility.
112: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
113: p_api_version_number,
114: l_api_name,
115: G_PKG_NAME)