DBA Data[Home] [Help]

APPS.AMS_LISTFIELD_PVT dependencies on JTF_PLSQL_API

Line 217: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 220: p_validation_mode => JTF_PLSQL_API.g_update,

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

Line 231: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record 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

Line 389: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

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

Line 392: p_validation_mode => JTF_PLSQL_API.g_create,

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

Line 405: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record 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

Line 468: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update

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,

Line 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