APPS.AMS_ACTMETRICFACT_PVT dependencies on JTF_PLSQL_API

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

66:
67: x_complete_rec := p_act_metric_fact_rec;
68:
69: -- Insert Mode
70: IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN
71:
72: IF p_act_metric_fact_rec.trans_forecasted_value IS NULL THEN
73: x_complete_rec.trans_forecasted_value := 0;
74: END IF;

Line 502: p_validation_mode => JTF_PLSQL_API.g_create,

498:
499: Default_ActMetricFact
500: ( p_init_msg_list => p_init_msg_list,
501: p_act_metric_fact_rec => p_act_metric_fact_rec,
502: p_validation_mode => JTF_PLSQL_API.g_create,
503: x_complete_rec => l_act_metric_fact_rec,
504: x_return_status => l_return_status,
505: x_msg_count => x_msg_count,
506: x_msg_data => x_msg_data ) ;

Line 953: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

949:
950: Default_ActMetricFact
951: ( p_init_msg_list => p_init_msg_list,
952: p_act_metric_fact_rec => p_act_metric_fact_rec,
953: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
954: x_complete_rec => l_act_metric_fact_rec,
955: x_return_status => l_return_status,
956: x_msg_count => x_msg_count,
957: x_msg_data => x_msg_data ) ;

Line 990: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

986: Complete_ActMetFact_Rec(p_act_metric_fact_rec => l_temp_act_metric_fact_rec,
987: x_complete_fact_rec => l_act_metric_fact_rec);
988:
989:
990: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
991: Validate_ActMetFact_Items(
992: p_act_metric_fact_rec => l_act_metric_fact_rec,
993: p_validation_mode => JTF_PLSQL_API.g_update,
994: x_return_status => l_return_status

Line 993: p_validation_mode => JTF_PLSQL_API.g_update,

989:
990: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
991: Validate_ActMetFact_Items(
992: p_act_metric_fact_rec => l_act_metric_fact_rec,
993: p_validation_mode => JTF_PLSQL_API.g_update,
994: x_return_status => l_return_status
995: );
996: -- dbms_output.put_line(l_full_name || ' validate_items returns ' || l_return_status);
997: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 1005: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1001: END IF;
1002: END IF;
1003:
1004:
1005: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1006: Validate_ActMetFact_Rec(
1007: p_act_metric_fact_rec => p_act_metric_fact_rec,
1008: p_complete_fact_rec => l_act_metric_fact_rec,
1009: x_return_status => l_return_status

Line 2035: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

2031:
2032:
2033:
2034: -- Validate required items in the record.
2035: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2036:
2037: Validate_ActMetFact_Items(
2038: p_act_metric_fact_rec => p_act_metric_fact_rec,
2039: p_validation_mode => JTF_PLSQL_API.g_create,

Line 2039: p_validation_mode => JTF_PLSQL_API.g_create,

2035: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2036:
2037: Validate_ActMetFact_Items(
2038: p_act_metric_fact_rec => p_act_metric_fact_rec,
2039: p_validation_mode => JTF_PLSQL_API.g_create,
2040: x_return_status => l_return_status
2041: );
2042:
2043: -- If any errors happen abort API.

Line 2062: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

2058:
2059:
2060:
2061:
2062: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
2063: Validate_ActMetFact_Rec(
2064: p_act_metric_fact_rec => p_act_metric_fact_rec,
2065: p_complete_fact_rec => NULL,
2066: x_return_status => l_return_status

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

2405:
2406:
2407: PROCEDURE Check_ActMetricFact_UK_Items(
2408: p_act_metric_fact_rec IN act_metric_fact_rec_type,
2409: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2410: x_return_status OUT NOCOPY VARCHAR2
2411: )
2412: IS
2413: l_where_clause VARCHAR2(2000); -- Used By Check_Uniqueness

Line 2420: IF p_validation_mode = JTF_PLSQL_API.g_create

2416: x_return_status := FND_API.g_ret_sts_success;
2417:
2418: -- For Create_ActMetricFact, when activity_metric_fact_id is passed in, we need to
2419: -- check if this activity_metric_id is unique.
2420: IF p_validation_mode = JTF_PLSQL_API.g_create
2421: AND p_act_metric_fact_rec.activity_metric_fact_id IS NOT NULL
2422: THEN
2423:
2424: l_where_clause := ' activity_metric_fact_id = '||p_act_metric_fact_rec.activity_metric_fact_id ;

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

2753: -- End of comments.
2754:
2755: PROCEDURE Validate_ActMetFact_Items (
2756: p_act_metric_fact_rec IN act_metric_fact_rec_type,
2757: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2758: x_return_status OUT NOCOPY VARCHAR2
2759: )
2760: IS
2761: BEGIN