eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AMS_ACTMETRIC_PVT dependencies on JTF_PLSQL_API

Line 1055: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

1051: OPEN c_met_det(x_complete_rec.metric_id);
1052: FETCH c_met_det INTO l_met_det_rec;
1053: CLOSE c_met_det;
1054:
1055: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1056: -- Insert Mode
1057:
1058: -- Default Sensitive data Flag and UOM code if not sent to the API
1059: IF (x_complete_rec.sensitive_data_flag IS NULL OR

Line 1783: p_validation_mode => Jtf_Plsql_Api.g_create,

1779: -- Do Currency Conversion after defaulting functional currency code
1780: Default_ActMetric(
1781: p_init_msg_list => p_init_msg_list,
1782: --p_act_metric_rec => l_act_metrics_rec,
1783: p_validation_mode => Jtf_Plsql_Api.g_create,
1784: x_complete_rec => l_act_metrics_rec,
1785: x_return_status => l_return_status,
1786: x_msg_count => x_msg_count,
1787: x_msg_data => x_msg_data

Line 2319: p_validation_mode => Jtf_Plsql_Api.G_UPDATE,

2315: -- Do Currency Conversion
2316: Default_ActMetric(
2317: p_init_msg_list => p_init_msg_list,
2318: -- p_act_metric_rec => l_actmet_rec,
2319: p_validation_mode => Jtf_Plsql_Api.G_UPDATE,
2320: x_complete_rec => l_actmet_rec,
2321: x_return_status => l_return_status,
2322: x_msg_count => x_msg_count,
2323: x_msg_data => x_msg_data ) ;

Line 2331: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

2327: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
2328: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2329: END IF;
2330:
2331: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
2332: Validate_ActMetric_items(
2333: p_act_metric_rec => l_actmet_rec,
2334: p_validation_mode => Jtf_Plsql_Api.g_update,
2335: x_return_status => l_return_status

Line 2334: p_validation_mode => Jtf_Plsql_Api.g_update,

2330:
2331: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
2332: Validate_ActMetric_items(
2333: p_act_metric_rec => l_actmet_rec,
2334: p_validation_mode => Jtf_Plsql_Api.g_update,
2335: x_return_status => l_return_status
2336: );
2337: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
2338: RAISE Fnd_Api.g_exc_unexpected_error;

Line 2348: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN

2344:
2345: -- replace g_miss_char/num/date with current column values
2346: --Complete_ActMetric_Rec(l_actmet_rec, l_actmet_rec);
2347:
2348: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
2349:
2350: Validate_ActMetric_Record(
2351: p_act_metric_rec => l_actmet_rec,
2352: p_complete_rec => l_actmet_rec,

Line 3484: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

3480: Ams_Utility_Pvt.debug_message(l_full_name||': Validate items');
3481: END IF;
3482:
3483: -- Validate required items in the record.
3484: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
3485:
3486: Validate_ActMetric_items(
3487: p_act_metric_rec => p_act_metric_rec,
3488: p_validation_mode => Jtf_Plsql_Api.g_create,

Line 3488: p_validation_mode => Jtf_Plsql_Api.g_create,

3484: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
3485:
3486: Validate_ActMetric_items(
3487: p_act_metric_rec => p_act_metric_rec,
3488: p_validation_mode => Jtf_Plsql_Api.g_create,
3489: x_return_status => l_return_status
3490: );
3491:
3492: -- If any errors happen abort API.

Line 3504: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN

3500: IF (AMS_DEBUG_HIGH_ON) THEN
3501: Ams_Utility_Pvt.debug_message(l_full_name||': check record');
3502: END IF;
3503:
3504: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
3505: Validate_ActMetric_record(
3506: p_act_metric_rec => p_act_metric_rec,
3507: p_complete_rec => NULL,
3508: x_return_status => l_return_status

Line 3725: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

3721:
3722:
3723: PROCEDURE Check_ActMetric_UK_Items(
3724: p_act_metric_rec IN act_metric_rec_type,
3725: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
3726: x_return_status OUT NOCOPY VARCHAR2
3727: )
3728: IS
3729: l_where_clause VARCHAR2(2000); -- Used By Check_Uniqueness

Line 3756: IF p_validation_mode = Jtf_Plsql_Api.g_create

3752: x_return_status := Fnd_Api.g_ret_sts_success;
3753:
3754: -- For Create_ActMetric2, when activity_metric_id is passed in, we need to
3755: -- check if this activity_metric_id is unique.
3756: IF p_validation_mode = Jtf_Plsql_Api.g_create
3757: AND p_act_metric_rec.activity_metric_id IS NOT NULL
3758: THEN
3759: l_where_clause := ' activity_metric_id = '||p_act_metric_rec.activity_metric_id ;
3760:

Line 3779: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

3775:
3776: -- check other unique items
3777:
3778: -- Function metrics may only be added once.
3779: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
3780: l_test := NULL;
3781: OPEN c_check_function(p_act_metric_rec.metric_id,
3782: p_act_metric_rec.arc_act_metric_used_by,
3783: p_act_metric_rec.act_metric_used_by_id,

Line 4428: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,

4424: -- End of comments.
4425:
4426: PROCEDURE Validate_ActMetric_items(
4427: p_act_metric_rec IN act_metric_rec_type,
4428: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
4429: x_return_status OUT NOCOPY VARCHAR2
4430: )
4431: IS
4432: BEGIN