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.

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 1787: p_validation_mode => Jtf_Plsql_Api.g_create,

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

Line 2327: p_validation_mode => Jtf_Plsql_Api.G_UPDATE,

2323: -- Do Currency Conversion
2324: Default_ActMetric(
2325: p_init_msg_list => p_init_msg_list,
2326: -- p_act_metric_rec => l_actmet_rec,
2327: p_validation_mode => Jtf_Plsql_Api.G_UPDATE,
2328: x_complete_rec => l_actmet_rec,
2329: x_return_status => l_return_status,
2330: x_msg_count => x_msg_count,
2331: x_msg_data => x_msg_data ) ;

Line 2339: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

2335: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
2336: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2337: END IF;
2338:
2339: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
2340: Validate_ActMetric_items(
2341: p_act_metric_rec => l_actmet_rec,
2342: p_validation_mode => Jtf_Plsql_Api.g_update,
2343: x_return_status => l_return_status

Line 2342: p_validation_mode => Jtf_Plsql_Api.g_update,

2338:
2339: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
2340: Validate_ActMetric_items(
2341: p_act_metric_rec => l_actmet_rec,
2342: p_validation_mode => Jtf_Plsql_Api.g_update,
2343: x_return_status => l_return_status
2344: );
2345: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
2346: RAISE Fnd_Api.g_exc_unexpected_error;

Line 2356: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN

2352:
2353: -- replace g_miss_char/num/date with current column values
2354: --Complete_ActMetric_Rec(l_actmet_rec, l_actmet_rec);
2355:
2356: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
2357:
2358: Validate_ActMetric_Record(
2359: p_act_metric_rec => l_actmet_rec,
2360: p_complete_rec => l_actmet_rec,

Line 3492: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN

3488: Ams_Utility_Pvt.debug_message(l_full_name||': Validate items');
3489: END IF;
3490:
3491: -- Validate required items in the record.
3492: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
3493:
3494: Validate_ActMetric_items(
3495: p_act_metric_rec => p_act_metric_rec,
3496: p_validation_mode => Jtf_Plsql_Api.g_create,

Line 3496: p_validation_mode => Jtf_Plsql_Api.g_create,

3492: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
3493:
3494: Validate_ActMetric_items(
3495: p_act_metric_rec => p_act_metric_rec,
3496: p_validation_mode => Jtf_Plsql_Api.g_create,
3497: x_return_status => l_return_status
3498: );
3499:
3500: -- If any errors happen abort API.

Line 3512: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN

3508: IF (AMS_DEBUG_HIGH_ON) THEN
3509: Ams_Utility_Pvt.debug_message(l_full_name||': check record');
3510: END IF;
3511:
3512: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
3513: Validate_ActMetric_record(
3514: p_act_metric_rec => p_act_metric_rec,
3515: p_complete_rec => NULL,
3516: x_return_status => l_return_status

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

3729:
3730:
3731: PROCEDURE Check_ActMetric_UK_Items(
3732: p_act_metric_rec IN act_metric_rec_type,
3733: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
3734: x_return_status OUT NOCOPY VARCHAR2
3735: )
3736: IS
3737: l_where_clause VARCHAR2(2000); -- Used By Check_Uniqueness

Line 3764: IF p_validation_mode = Jtf_Plsql_Api.g_create

3760: x_return_status := Fnd_Api.g_ret_sts_success;
3761:
3762: -- For Create_ActMetric2, when activity_metric_id is passed in, we need to
3763: -- check if this activity_metric_id is unique.
3764: IF p_validation_mode = Jtf_Plsql_Api.g_create
3765: AND p_act_metric_rec.activity_metric_id IS NOT NULL
3766: THEN
3767: l_where_clause := ' activity_metric_id = '||p_act_metric_rec.activity_metric_id ;
3768:

Line 3787: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN

3783:
3784: -- check other unique items
3785:
3786: -- Function metrics may only be added once.
3787: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
3788: l_test := NULL;
3789: OPEN c_check_function(p_act_metric_rec.metric_id,
3790: p_act_metric_rec.arc_act_metric_used_by,
3791: p_act_metric_rec.act_metric_used_by_id,

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

4432: -- End of comments.
4433:
4434: PROCEDURE Validate_ActMetric_items(
4435: p_act_metric_rec IN act_metric_rec_type,
4436: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
4437: x_return_status OUT NOCOPY VARCHAR2
4438: )
4439: IS
4440: BEGIN