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.OZF_ACTMETRICFACT_PVT dependencies on JTF_PLSQL_API

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

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

Line 226: p_validation_mode => JTF_PLSQL_API.g_create,

222:
223: Default_ActMetricFact
224: ( p_init_msg_list => p_init_msg_list,
225: p_act_metric_fact_rec => p_act_metric_fact_rec,
226: p_validation_mode => JTF_PLSQL_API.g_create,
227: x_complete_rec => l_act_metric_fact_rec,
228: x_return_status => l_return_status,
229: x_msg_count => x_msg_count,
230: x_msg_data => x_msg_data ) ;

Line 689: p_validation_mode => JTF_PLSQL_API.G_UPDATE,

685:
686: Default_ActMetricFact
687: ( p_init_msg_list => p_init_msg_list,
688: p_act_metric_fact_rec => p_act_metric_fact_rec,
689: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
690: x_complete_rec => l_act_metric_fact_rec,
691: x_return_status => l_return_status,
692: x_msg_count => x_msg_count,
693: x_msg_data => x_msg_data ) ;

Line 726: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

722: Complete_ActMetFact_Rec(p_act_metric_fact_rec => l_temp_act_metric_fact_rec,
723: x_complete_fact_rec => l_act_metric_fact_rec);
724:
725:
726: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
727: Validate_ActMetFact_Items(
728: p_act_metric_fact_rec => l_act_metric_fact_rec,
729: p_validation_mode => JTF_PLSQL_API.g_update,
730: x_return_status => l_return_status

Line 729: p_validation_mode => JTF_PLSQL_API.g_update,

725:
726: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
727: Validate_ActMetFact_Items(
728: p_act_metric_fact_rec => l_act_metric_fact_rec,
729: p_validation_mode => JTF_PLSQL_API.g_update,
730: x_return_status => l_return_status
731: );
732: -- dbms_output.put_line(l_full_name || ' validate_items returns ' || l_return_status);
733: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

Line 741: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

737: END IF;
738: END IF;
739:
740:
741: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
742: Validate_ActMetFact_Rec(
743: p_act_metric_fact_rec => p_act_metric_fact_rec,
744: p_complete_fact_rec => l_act_metric_fact_rec,
745: x_return_status => l_return_status

Line 1777: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

1773:
1774:
1775:
1776: -- Validate required items in the record.
1777: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1778:
1779: Validate_ActMetFact_Items(
1780: p_act_metric_fact_rec => p_act_metric_fact_rec,
1781: p_validation_mode => JTF_PLSQL_API.g_create,

Line 1781: p_validation_mode => JTF_PLSQL_API.g_create,

1777: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1778:
1779: Validate_ActMetFact_Items(
1780: p_act_metric_fact_rec => p_act_metric_fact_rec,
1781: p_validation_mode => JTF_PLSQL_API.g_create,
1782: x_return_status => l_return_status
1783: );
1784:
1785: -- If any errors happen abort API.

Line 1804: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

1800:
1801:
1802:
1803:
1804: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1805: Validate_ActMetFact_Rec(
1806: p_act_metric_fact_rec => p_act_metric_fact_rec,
1807: p_complete_fact_rec => NULL,
1808: x_return_status => l_return_status

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

2147:
2148:
2149: PROCEDURE Check_ActMetricFact_UK_Items(
2150: p_act_metric_fact_rec IN act_metric_fact_rec_type,
2151: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2152: x_return_status OUT NOCOPY VARCHAR2
2153: )
2154: IS
2155: l_where_clause VARCHAR2(2000); -- Used By Check_Uniqueness

Line 2162: IF p_validation_mode = JTF_PLSQL_API.g_create

2158: x_return_status := FND_API.g_ret_sts_success;
2159:
2160: -- For Create_ActMetricFact, when activity_metric_fact_id is passed in, we need to
2161: -- check if this activity_metric_id is unique.
2162: IF p_validation_mode = JTF_PLSQL_API.g_create
2163: AND p_act_metric_fact_rec.activity_metric_fact_id IS NOT NULL
2164: THEN
2165:
2166: l_where_clause := ' activity_metric_fact_id = '||p_act_metric_fact_rec.activity_metric_fact_id ;

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

2462: -- End of comments.
2463:
2464: PROCEDURE Validate_ActMetFact_Items (
2465: p_act_metric_fact_rec IN act_metric_fact_rec_type,
2466: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2467: x_return_status OUT NOCOPY VARCHAR2
2468: )
2469: IS
2470: BEGIN

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

2545:
2546: x_complete_rec := p_formula_rec;
2547:
2548: -- Insert Mode
2549: IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN
2550: NULL;
2551: END IF;
2552:
2553: END Default_Formula ;

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

2594:
2595: x_complete_entry_rec := p_formula_entry_rec;
2596:
2597: -- Insert Mode
2598: IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN
2599:
2600: NULL;
2601: END IF;
2602:

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

2786:
2787:
2788: PROCEDURE Check_Formula_UK_Items(
2789: p_formula_rec IN ozf_formula_rec_type,
2790: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2791: x_return_status OUT NOCOPY VARCHAR2
2792: )
2793: IS
2794:

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

2839: --
2840: -- End of comments.
2841: PROCEDURE Check_Formula_Entry_UK_Items(
2842: p_formula_entry_rec IN ozf_formula_entry_rec_type,
2843: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2844: x_return_status OUT NOCOPY VARCHAR2
2845: )
2846: IS
2847:

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

3139: -- End of comments.
3140:
3141: PROCEDURE Validate_Formula_Items (
3142: p_formula_rec IN ozf_formula_rec_type,
3143: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
3144: x_return_status OUT NOCOPY VARCHAR2
3145: )
3146: IS
3147: BEGIN

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

3197: -- End of comments.
3198:
3199: PROCEDURE Validate_Form_Ent_Items (
3200: p_formula_entry_rec IN ozf_formula_entry_rec_type,
3201: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
3202: x_return_status OUT NOCOPY VARCHAR2
3203: )
3204: IS
3205: BEGIN

Line 3315: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

3311: ozf_utility_pvt.debug_message(l_full_name||': Validate items');
3312: END IF;
3313:
3314: -- Validate required items in the record.
3315: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3316:
3317: Validate_Formula_Items(
3318: p_formula_rec => p_formula_rec,
3319: p_validation_mode => JTF_PLSQL_API.g_create,

Line 3319: p_validation_mode => JTF_PLSQL_API.g_create,

3315: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3316:
3317: Validate_Formula_Items(
3318: p_formula_rec => p_formula_rec,
3319: p_validation_mode => JTF_PLSQL_API.g_create,
3320: x_return_status => l_return_status
3321: );
3322:
3323: -- If any errors happen abort API.

Line 3335: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

3331: IF G_DEBUG THEN
3332: ozf_utility_pvt.debug_message(l_full_name||': check record');
3333: END IF;
3334:
3335: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
3336: Validate_Formula_Rec(
3337: p_formula_rec => p_formula_rec,
3338: p_complete_formula_rec => NULL,
3339: x_return_status => l_return_status

Line 3477: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

3473: ozf_utility_pvt.debug_message(l_full_name||': Validate items');
3474: END IF;
3475:
3476: -- Validate required items in the record.
3477: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3478:
3479: Validate_Form_Ent_Items(
3480: p_formula_entry_rec => p_formula_entry_rec,
3481: p_validation_mode => JTF_PLSQL_API.g_create,

Line 3481: p_validation_mode => JTF_PLSQL_API.g_create,

3477: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
3478:
3479: Validate_Form_Ent_Items(
3480: p_formula_entry_rec => p_formula_entry_rec,
3481: p_validation_mode => JTF_PLSQL_API.g_create,
3482: x_return_status => l_return_status
3483: );
3484:
3485: -- If any errors happen abort API.

Line 3497: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

3493: IF G_DEBUG THEN
3494: ozf_utility_pvt.debug_message(l_full_name||': check record');
3495: END IF;
3496:
3497: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
3498: Validate_Form_Ent_Rec(
3499: p_formula_entry_rec => p_formula_entry_rec,
3500: p_complete_formula_entry_rec => NULL,
3501: x_return_status => l_return_status

Line 3661: p_validation_mode => JTF_PLSQL_API.g_create,

3657:
3658: Default_Formula
3659: ( p_init_msg_list => p_init_msg_list,
3660: p_formula_rec => p_formula_rec,
3661: p_validation_mode => JTF_PLSQL_API.g_create,
3662: x_complete_rec => l_formula_rec,
3663: x_return_status => l_return_status,
3664: x_msg_count => x_msg_count,
3665: x_msg_data => x_msg_data ) ;

Line 3937: p_validation_mode => JTF_PLSQL_API.g_create,

3933:
3934: Default_Formula_Entry
3935: ( p_init_msg_list => p_init_msg_list,
3936: p_formula_entry_rec => p_formula_entry_rec,
3937: p_validation_mode => JTF_PLSQL_API.g_create,
3938: x_complete_entry_rec => l_formula_entry_rec,
3939: x_return_status => l_return_status,
3940: x_msg_count => x_msg_count,
3941: x_msg_data => x_msg_data ) ;