213:
214: -- replace g_miss_char/num/date with current column values
215: Complete_ListField_Rec (p_listfield_rec, l_listfield_rec);
216:
217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
218: Check_ListField_Items (
219: p_listfield_rec => p_listfield_rec,
220: p_validation_mode => JTF_PLSQL_API.g_update,
221: x_return_status => l_return_status
216:
217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
218: Check_ListField_Items (
219: p_listfield_rec => p_listfield_rec,
220: p_validation_mode => JTF_PLSQL_API.g_update,
221: x_return_status => l_return_status
222: );
223:
224: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
227: RAISE FND_API.g_exc_error;
228: END IF;
229: END IF;
230:
231: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
232: Check_ListField_Record (
233: p_listfield_rec => p_listfield_rec,
234: p_complete_rec => l_listfield_rec,
235: x_return_status => l_return_status
385:
386: ---------------------- validate ------------------------
387: AMS_Utility_PVT.debug_message (l_full_name || ': Check items');
388:
389: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
390: Check_ListField_Items (
391: p_listfield_rec => p_listfield_rec,
392: p_validation_mode => JTF_PLSQL_API.g_create,
393: x_return_status => l_return_status
388:
389: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
390: Check_ListField_Items (
391: p_listfield_rec => p_listfield_rec,
392: p_validation_mode => JTF_PLSQL_API.g_create,
393: x_return_status => l_return_status
394: );
395:
396: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
401: END IF;
402:
403: AMS_Utility_PVT.debug_message (l_full_name || ': Check record');
404:
405: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
406: Check_ListField_Record (
407: p_listfield_rec => p_listfield_rec,
408: p_complete_rec => NULL,
409: x_return_status => l_return_status
464: -- required columns, foreign keys, domain constraints.
465: --
466: -- PARAMETERS
467: -- p_listfield_rec: the record to be validated
468: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
469: ---------------------------------------------------------------------
470: PROCEDURE Check_ListField_Items (
471: p_listfield_rec IN List_Field_Rec_Type,
472: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
468: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
469: ---------------------------------------------------------------------
470: PROCEDURE Check_ListField_Items (
471: p_listfield_rec IN List_Field_Rec_Type,
472: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
473: x_return_status OUT VARCHAR2
474: )
475: IS
476: BEGIN