DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OWNER dependencies on JTF_PLSQL_API

Line 14: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create

10: --
11: ---------------------------------------------------------------------
12: PROCEDURE Check_Uk_Items(
13: p_Lead_Owner_rec IN Lead_Owner_rec_type
14: ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
15: ,x_return_status OUT NOCOPY VARCHAR2
16: )
17: IS
18: l_valid_flag VARCHAR2(1);

Line 174: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create

170: -- Check_Lead_Owner_items
171: --
172: ---------------------------------------------------------------------
173: PROCEDURE Check_Lead_Owner_items(
174: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
175: ,x_return_status OUT NOCOPY VARCHAR2
176: ,p_Lead_Owner_rec IN Lead_Owner_rec_type
177: )
178: IS

Line 414: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

410: ---------------------- validate ------------------------
411: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': check items');
412: --DBMS_output.put_line(l_full_name||': start item validate');
413:
414: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
415: Check_Lead_Owner_items(
416: p_Lead_Owner_rec => p_Lead_Owner_rec,
417: p_validation_mode => JTF_PLSQL_API.g_create,
418: x_return_status => l_return_status

Line 417: p_validation_mode => JTF_PLSQL_API.g_create,

413:
414: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
415: Check_Lead_Owner_items(
416: p_Lead_Owner_rec => p_Lead_Owner_rec,
417: p_validation_mode => JTF_PLSQL_API.g_create,
418: x_return_status => l_return_status
419: );
420:
421: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 431: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

427:
428: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name||': check record');
429: --DBMS_output.put_line(l_full_name||': start record validate');
430:
431: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
432: Check_Lead_Owner_rec(
433: p_Lead_Owner_rec => p_Lead_Owner_rec,
434: p_complete_rec => NULL,
435: x_return_status => l_return_status

Line 1027: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1023: END IF;
1024: RAISE FND_API.g_exc_error;
1025: END IF;
1026:
1027: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1028: Check_Lead_Owner_Items(
1029: p_Lead_Owner_Rec => p_Lead_Owner_rec,
1030: p_validation_mode => JTF_PLSQL_API.g_update,
1031: x_return_status => l_return_status

Line 1030: p_validation_mode => JTF_PLSQL_API.g_update,

1026:
1027: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1028: Check_Lead_Owner_Items(
1029: p_Lead_Owner_Rec => p_Lead_Owner_rec,
1030: p_validation_mode => JTF_PLSQL_API.g_update,
1031: x_return_status => l_return_status
1032: );
1033:
1034: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1044: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1040:
1041: -- replace g_miss_char/num/date with current column values
1042: Complete_Lead_Owner_rec(p_Lead_Owner_rec, l_Lead_Owner_rec);
1043:
1044: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1045: Check_Lead_Owner_rec(
1046: p_Lead_Owner_rec => p_Lead_Owner_rec,
1047: p_complete_rec => l_Lead_Owner_rec,
1048: p_mode => l_mode,