DBA Data[Home] [Help]

APPS.AMS_FORMULA_PVT dependencies on JTF_PLSQL_API

Line 593: IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN

589:
590: x_complete_rec := p_formula_rec;
591:
592: -- Insert Mode
593: IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN
594: NULL;
595: END IF;
596:
597: END Default_Formula ;

Line 642: IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN

638:
639: x_complete_entry_rec := p_formula_entry_rec;
640:
641: -- Insert Mode
642: IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN
643:
644: NULL;
645: END IF;
646:

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

830:
831:
832: PROCEDURE Check_Formula_UK_Items(
833: p_formula_rec IN ams_formula_rec_type,
834: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
835: x_return_status OUT NOCOPY VARCHAR2
836: )
837: IS
838:

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

883: --
884: -- End of comments.
885: PROCEDURE Check_Formula_Entry_UK_Items(
886: p_formula_entry_rec IN ams_formula_entry_rec_type,
887: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
888: x_return_status OUT NOCOPY VARCHAR2
889: )
890: IS
891:

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

1183: -- End of comments.
1184:
1185: PROCEDURE Validate_Formula_Items (
1186: p_formula_rec IN ams_formula_rec_type,
1187: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1188: x_return_status OUT NOCOPY VARCHAR2
1189: )
1190: IS
1191: BEGIN

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

1241: -- End of comments.
1242:
1243: PROCEDURE Validate_Form_Ent_Items (
1244: p_formula_entry_rec IN ams_formula_entry_rec_type,
1245: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1246: x_return_status OUT NOCOPY VARCHAR2
1247: )
1248: IS
1249: BEGIN

Line 1359: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1355: AMS_Utility_PVT.debug_message(l_full_name||': Validate items');
1356: END IF;
1357:
1358: -- Validate required items in the record.
1359: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1360:
1361: Validate_Formula_Items(
1362: p_formula_rec => p_formula_rec,
1363: p_validation_mode => JTF_PLSQL_API.g_create,

Line 1363: p_validation_mode => JTF_PLSQL_API.g_create,

1359: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1360:
1361: Validate_Formula_Items(
1362: p_formula_rec => p_formula_rec,
1363: p_validation_mode => JTF_PLSQL_API.g_create,
1364: x_return_status => l_return_status
1365: );
1366:
1367: -- If any errors happen abort API.

Line 1379: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1375: IF G_DEBUG THEN
1376: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1377: END IF;
1378:
1379: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1380: Validate_Formula_Rec(
1381: p_formula_rec => p_formula_rec,
1382: p_complete_formula_rec => NULL,
1383: x_return_status => l_return_status

Line 1521: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1517: AMS_Utility_PVT.debug_message(l_full_name||': Validate items');
1518: END IF;
1519:
1520: -- Validate required items in the record.
1521: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1522:
1523: Validate_Form_Ent_Items(
1524: p_formula_entry_rec => p_formula_entry_rec,
1525: p_validation_mode => JTF_PLSQL_API.g_create,

Line 1525: p_validation_mode => JTF_PLSQL_API.g_create,

1521: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1522:
1523: Validate_Form_Ent_Items(
1524: p_formula_entry_rec => p_formula_entry_rec,
1525: p_validation_mode => JTF_PLSQL_API.g_create,
1526: x_return_status => l_return_status
1527: );
1528:
1529: -- If any errors happen abort API.

Line 1541: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1537: IF G_DEBUG THEN
1538: AMS_Utility_PVT.debug_message(l_full_name||': check record');
1539: END IF;
1540:
1541: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1542: Validate_Form_Ent_Rec(
1543: p_formula_entry_rec => p_formula_entry_rec,
1544: p_complete_formula_entry_rec => NULL,
1545: x_return_status => l_return_status

Line 1705: p_validation_mode => JTF_PLSQL_API.g_create,

1701:
1702: Default_Formula
1703: ( p_init_msg_list => p_init_msg_list,
1704: p_formula_rec => p_formula_rec,
1705: p_validation_mode => JTF_PLSQL_API.g_create,
1706: x_complete_rec => l_formula_rec,
1707: x_return_status => l_return_status,
1708: x_msg_count => x_msg_count,
1709: x_msg_data => x_msg_data ) ;

Line 1981: p_validation_mode => JTF_PLSQL_API.g_create,

1977:
1978: Default_Formula_Entry
1979: ( p_init_msg_list => p_init_msg_list,
1980: p_formula_entry_rec => p_formula_entry_rec,
1981: p_validation_mode => JTF_PLSQL_API.g_create,
1982: x_complete_entry_rec => l_formula_entry_rec,
1983: x_return_status => l_return_status,
1984: x_msg_count => x_msg_count,
1985: x_msg_data => x_msg_data ) ;

Line 2248: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

2244:
2245: Default_Formula
2246: ( p_init_msg_list => p_init_msg_list,
2247: p_formula_rec => p_formula_rec,
2248: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
2249: x_complete_rec => l_formula_rec,
2250: x_return_status => l_return_status,
2251: x_msg_count => x_msg_count,
2252: x_msg_data => x_msg_data ) ;

Line 2268: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2264: END IF;
2265:
2266:
2267:
2268: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2269: Validate_Formula_Items(
2270: p_formula_rec => l_formula_rec,
2271: p_validation_mode => JTF_PLSQL_API.g_update,
2272: x_return_status => l_return_status

Line 2271: p_validation_mode => JTF_PLSQL_API.g_update,

2267:
2268: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2269: Validate_Formula_Items(
2270: p_formula_rec => l_formula_rec,
2271: p_validation_mode => JTF_PLSQL_API.g_update,
2272: x_return_status => l_return_status
2273: );
2274: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2275: RAISE FND_API.g_exc_unexpected_error;

Line 2287: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

2283: -- replace g_miss_char/num/date with current column values
2284: Complete_Formula_Rec(l_formula_rec,l_formula_rec);
2285:
2286:
2287: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2288:
2289: Validate_Formula_Rec(
2290: p_formula_rec => p_formula_rec,
2291: p_complete_formula_rec => l_formula_rec,

Line 2473: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

2469:
2470: Default_Formula_Entry
2471: ( p_init_msg_list => p_init_msg_list,
2472: p_formula_entry_rec => p_formula_entry_rec,
2473: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
2474: x_complete_entry_rec => l_formula_entry_rec,
2475: x_return_status => l_return_status,
2476: x_msg_count => x_msg_count,
2477: x_msg_data => x_msg_data ) ;

Line 2493: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2489: END IF;
2490:
2491:
2492:
2493: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2494: Validate_Form_Ent_Items(
2495: p_formula_entry_rec => l_formula_entry_rec,
2496: p_validation_mode => JTF_PLSQL_API.g_update,
2497: x_return_status => l_return_status

Line 2496: p_validation_mode => JTF_PLSQL_API.g_update,

2492:
2493: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2494: Validate_Form_Ent_Items(
2495: p_formula_entry_rec => l_formula_entry_rec,
2496: p_validation_mode => JTF_PLSQL_API.g_update,
2497: x_return_status => l_return_status
2498: );
2499:
2500: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 2511: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

2507: -- replace g_miss_char/num/date with current column values
2508: Complete_Form_Ent_Rec(l_formula_entry_rec,l_formula_entry_rec);
2509:
2510:
2511: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2512:
2513: Validate_Form_Ent_Rec(
2514: p_formula_entry_rec => p_formula_entry_rec,
2515: p_complete_formula_entry_rec => l_formula_entry_rec,