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 OZF_UTILITY_PVT

Line 190: OZF_Utility_PVT.Debug_Message(l_full_name||': start');

186: IF (OZF_DEBUG_HIGH_ON) THEN
187:
188:
189:
190: OZF_Utility_PVT.Debug_Message(l_full_name||': start');
191:
192: END IF;
193:
194: --

Line 290: OZF_Utility_PVT.debug_message(l_full_name ||': insert');

286: -- Debug message.
287: --
288: IF (OZF_DEBUG_HIGH_ON) THEN
289:
290: OZF_Utility_PVT.debug_message(l_full_name ||': insert');
291: END IF;
292:
293:
294:

Line 565: OZF_Utility_PVT.debug_message(l_full_name ||': end Success');

561: -- Add success message to message list.
562: --
563: IF (OZF_DEBUG_HIGH_ON) THEN
564:
565: OZF_Utility_PVT.debug_message(l_full_name ||': end Success');
566: END IF;
567:
568:
569:

Line 654: OZF_Utility_PVT.debug_message(l_full_name||': start');

650: -- Output debug message.
651: --
652: IF (OZF_DEBUG_HIGH_ON) THEN
653:
654: OZF_Utility_PVT.debug_message(l_full_name||': start');
655: END IF;
656:
657: --
658: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 709: OZF_Utility_PVT.debug_message(l_full_name ||': validate');

705:
706:
707:
708:
709: OZF_Utility_PVT.debug_message(l_full_name ||': validate');
710:
711:
712: END IF;
713:

Line 762: OZF_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Facts Table');

758:
759:
760:
761:
762: OZF_Utility_PVT.debug_message(l_full_name ||': Update Activity Metric Facts Table');
763:
764:
765: END IF;
766:

Line 914: OZF_Utility_PVT.debug_message(l_full_name ||': end');

910: -- Debug message.
911: --
912: IF (OZF_DEBUG_HIGH_ON) THEN
913:
914: OZF_Utility_PVT.debug_message(l_full_name ||': end');
915: END IF;
916:
917:
918: EXCEPTION

Line 1736: OZF_Utility_PVT.debug_message(l_full_name||': start');

1732: -- Output debug message.
1733: --
1734: IF (OZF_DEBUG_HIGH_ON) THEN
1735:
1736: OZF_Utility_PVT.debug_message(l_full_name||': start');
1737: END IF;
1738:
1739: --
1740: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1770: OZF_Utility_PVT.debug_message(l_full_name||': Validate items');

1766: IF (OZF_DEBUG_HIGH_ON) THEN
1767:
1768:
1769:
1770: OZF_Utility_PVT.debug_message(l_full_name||': Validate items');
1771:
1772: END IF;
1773:
1774:

Line 1797: OZF_Utility_PVT.debug_message(l_full_name||': check record');

1793: IF (OZF_DEBUG_HIGH_ON) THEN
1794:
1795:
1796:
1797: OZF_Utility_PVT.debug_message(l_full_name||': check record');
1798:
1799: END IF;
1800:
1801:

Line 1844: OZF_Utility_PVT.debug_message(l_full_name ||': end');

1840:
1841:
1842:
1843:
1844: OZF_Utility_PVT.debug_message(l_full_name ||': end');
1845:
1846:
1847:
1848: END IF;

Line 2168: IF OZF_Utility_PVT.Check_Uniqueness(

2164: THEN
2165:
2166: l_where_clause := ' activity_metric_fact_id = '||p_act_metric_fact_rec.activity_metric_fact_id ;
2167:
2168: IF OZF_Utility_PVT.Check_Uniqueness(
2169: p_table_name => 'ozf_act_metric_facts_all',
2170: p_where_clause => l_where_clause
2171: ) = FND_API.g_false
2172: THEN

Line 2245: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;

2241: IF l_act_metric_fact_rec.activity_metric_id <> FND_API.G_MISS_NUM THEN
2242: l_table_name := 'OZF_ACT_METRICS_ALL';
2243: l_pk_name := 'ACTIVITY_METRIC_ID';
2244: l_pk_value := l_act_metric_fact_rec.activity_metric_id;
2245: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;
2246: l_additional_where_clause := NULL ;
2247:
2248: IF OZF_Utility_PVT.Check_FK_Exists (
2249: p_table_name => l_table_name

Line 2248: IF OZF_Utility_PVT.Check_FK_Exists (

2244: l_pk_value := l_act_metric_fact_rec.activity_metric_id;
2245: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;
2246: l_additional_where_clause := NULL ;
2247:
2248: IF OZF_Utility_PVT.Check_FK_Exists (
2249: p_table_name => l_table_name
2250: ,p_pk_name => l_pk_name
2251: ,p_pk_value => l_pk_value
2252: ,p_pk_data_type => l_pk_data_type

Line 2376: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;

2372: -- first Check whether the Metric is attached to same usage or not
2373: l_table_name := 'OZF_ACT_METRICS_ALL';
2374: l_pk_name := 'ACTIVITY_METRIC_ID';
2375: l_pk_value := l_act_metric_fact_rec.activity_metric_id;
2376: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;
2377: l_additional_where_clause := ' arc_act_metric_used_by = '||''''||
2378: l_act_metric_fact_rec.arc_act_metric_used_by||'''' ;
2379:
2380:

Line 2382: IF OZF_Utility_PVT.Check_FK_Exists (

2378: l_act_metric_fact_rec.arc_act_metric_used_by||'''' ;
2379:
2380:
2381:
2382: IF OZF_Utility_PVT.Check_FK_Exists (
2383: p_table_name => l_table_name
2384: ,p_pk_name => l_pk_name
2385: ,p_pk_value => l_pk_value
2386: ,p_pk_data_type => l_pk_data_type

Line 2407: OZF_Utility_PVT.Get_Qual_Table_Name_And_PK (

2403:
2404: /*
2405:
2406: -- Get table_name and pk_name for the ARC qualifier.
2407: OZF_Utility_PVT.Get_Qual_Table_Name_And_PK (
2408: p_sys_qual => l_act_metric_fact_rec.arc_act_metric_used_by,
2409: x_return_status => l_return_status,
2410: x_table_name => l_table_name,
2411: x_pk_name => l_pk_name

Line 2417: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;

2413:
2414:
2415:
2416: l_pk_value := l_act_metric_fact_rec.act_metric_used_by_id;
2417: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;
2418: l_additional_where_clause := NULL;
2419:
2420: IF OZF_Utility_PVT.Check_FK_Exists (
2421: p_table_name => l_table_name

Line 2420: IF OZF_Utility_PVT.Check_FK_Exists (

2416: l_pk_value := l_act_metric_fact_rec.act_metric_used_by_id;
2417: l_pk_data_type := OZF_Utility_PVT.G_NUMBER;
2418: l_additional_where_clause := NULL;
2419:
2420: IF OZF_Utility_PVT.Check_FK_Exists (
2421: p_table_name => l_table_name
2422: ,p_pk_name => l_pk_name
2423: ,p_pk_value => l_pk_value
2424: ,p_pk_data_type => l_pk_data_type

Line 2916: IF ozf_utility_pvt.check_lookup_exists(p_lookup_type => 'OZF_FORMULA_TYPE',

2912:
2913: IF l_formula_rec.formula_type <> FND_API.G_MISS_CHAR THEN
2914:
2915:
2916: IF ozf_utility_pvt.check_lookup_exists(p_lookup_type => 'OZF_FORMULA_TYPE',
2917: p_lookup_code => l_formula_rec.formula_type) = FND_API.g_false THEN
2918:
2919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2920: FND_MESSAGE.set_name('OZF', 'OZF_FML_INVALID_TYPE');

Line 2971: IF ozf_utility_pvt.check_lookup_exists(p_lookup_type => 'OZF_FORMULA_ENT_TYPE',

2967:
2968: IF l_formula_entry_rec.formula_entry_type <> FND_API.G_MISS_CHAR THEN
2969:
2970:
2971: IF ozf_utility_pvt.check_lookup_exists(p_lookup_type => 'OZF_FORMULA_ENT_TYPE',
2972: p_lookup_code => l_formula_entry_rec.formula_entry_type) = FND_API.g_false THEN
2973:
2974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2975: FND_MESSAGE.set_name('OZF', 'OZF_FML_ENT_INVALID_TYPE');

Line 2989: IF ozf_utility_pvt.check_lookup_exists(p_lookup_type => 'OZF_FORMULA_OPERATOR',

2985:
2986: IF l_formula_entry_rec.formula_entry_operator IS NOT NULL AND l_formula_entry_rec.formula_entry_operator <> FND_API.G_MISS_CHAR THEN
2987:
2988:
2989: IF ozf_utility_pvt.check_lookup_exists(p_lookup_type => 'OZF_FORMULA_OPERATOR',
2990: p_lookup_code => l_formula_entry_rec.formula_entry_operator) = FND_API.g_false THEN
2991:
2992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2993: FND_MESSAGE.set_name('OZF', 'OZF_FML_ENT_INVALID_OP');

Line 3042: IF ozf_utility_pvt.Check_FK_Exists (

3038: x_return_status := FND_API.g_ret_sts_success;
3039:
3040: IF (l_formula_rec.activity_metric_id <> FND_API.G_MISS_NUM) THEN
3041:
3042: IF ozf_utility_pvt.Check_FK_Exists (
3043: p_table_name => 'OZF_ACT_METRICS_ALL'
3044: ,p_pk_name => 'ACTIVITY_METRIC_ID'
3045: ,p_pk_value => l_formula_rec.activity_metric_id
3046: ,p_pk_data_type => NULL

Line 3100: IF ozf_utility_pvt.Check_FK_Exists (

3096: x_return_status := FND_API.g_ret_sts_success;
3097:
3098: IF (l_formula_entry_rec.formula_id <> FND_API.G_MISS_NUM) THEN
3099:
3100: IF ozf_utility_pvt.Check_FK_Exists (
3101: p_table_name => 'OZF_ACT_METRIC_FORMULAS'
3102: ,p_pk_name => 'FORMULA_ID'
3103: ,p_pk_value => l_formula_entry_rec.formula_id
3104: ,p_pk_data_type => NULL

Line 3280: ozf_utility_pvt.debug_message(l_full_name||': start');

3276: --
3277: -- Output debug message.
3278: --
3279: IF G_DEBUG THEN
3280: ozf_utility_pvt.debug_message(l_full_name||': start');
3281: END IF;
3282:
3283: --
3284: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3311: ozf_utility_pvt.debug_message(l_full_name||': Validate items');

3307: -- Begin API Body.
3308: --
3309:
3310: IF G_DEBUG 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

Line 3332: ozf_utility_pvt.debug_message(l_full_name||': check record');

3328: END IF;
3329: END IF;
3330:
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(

Line 3344: ozf_utility_pvt.debug_message(l_full_name||': error in check record');

3340: );
3341:
3342: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3343: IF G_DEBUG THEN
3344: ozf_utility_pvt.debug_message(l_full_name||': error in check record');
3345: END IF;
3346: RAISE FND_API.g_exc_unexpected_error;
3347: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
3348: IF G_DEBUG THEN

Line 3349: ozf_utility_pvt.debug_message(l_full_name||': error in check record');

3345: END IF;
3346: RAISE FND_API.g_exc_unexpected_error;
3347: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
3348: IF G_DEBUG THEN
3349: ozf_utility_pvt.debug_message(l_full_name||': error in check record');
3350: END IF;
3351: RAISE FND_API.g_exc_error;
3352: END IF;
3353: END IF;

Line 3356: ozf_utility_pvt.debug_message(l_full_name||': after check record');

3352: END IF;
3353: END IF;
3354:
3355: IF G_DEBUG THEN
3356: ozf_utility_pvt.debug_message(l_full_name||': after check record');
3357: END IF;
3358:
3359:
3360: --

Line 3375: ozf_utility_pvt.debug_message(l_full_name ||': end');

3371: p_encoded => FND_API.G_FALSE
3372: );
3373:
3374: IF G_DEBUG THEN
3375: ozf_utility_pvt.debug_message(l_full_name ||': end');
3376: END IF;
3377:
3378:
3379: EXCEPTION

Line 3442: ozf_utility_pvt.debug_message(l_full_name||': start');

3438: --
3439: -- Output debug message.
3440: --
3441: IF G_DEBUG THEN
3442: ozf_utility_pvt.debug_message(l_full_name||': start');
3443: END IF;
3444:
3445: --
3446: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3473: ozf_utility_pvt.debug_message(l_full_name||': Validate items');

3469: -- Begin API Body.
3470: --
3471:
3472: IF G_DEBUG 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

Line 3494: ozf_utility_pvt.debug_message(l_full_name||': check record');

3490: END IF;
3491: END IF;
3492:
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(

Line 3506: ozf_utility_pvt.debug_message(l_full_name||': error in check record');

3502: );
3503:
3504: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
3505: IF G_DEBUG THEN
3506: ozf_utility_pvt.debug_message(l_full_name||': error in check record');
3507: END IF;
3508: RAISE FND_API.g_exc_unexpected_error;
3509: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
3510: IF G_DEBUG THEN

Line 3511: ozf_utility_pvt.debug_message(l_full_name||': error in check record');

3507: END IF;
3508: RAISE FND_API.g_exc_unexpected_error;
3509: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
3510: IF G_DEBUG THEN
3511: ozf_utility_pvt.debug_message(l_full_name||': error in check record');
3512: END IF;
3513: RAISE FND_API.g_exc_error;
3514: END IF;
3515: END IF;

Line 3518: ozf_utility_pvt.debug_message(l_full_name||': after check record');

3514: END IF;
3515: END IF;
3516:
3517: IF G_DEBUG THEN
3518: ozf_utility_pvt.debug_message(l_full_name||': after check record');
3519: END IF;
3520:
3521:
3522: --

Line 3537: ozf_utility_pvt.debug_message(l_full_name ||': end');

3533: p_encoded => FND_API.G_FALSE
3534: );
3535:
3536: IF G_DEBUG THEN
3537: ozf_utility_pvt.debug_message(l_full_name ||': end');
3538: END IF;
3539:
3540:
3541: EXCEPTION

Line 3628: ozf_utility_pvt.Debug_Message(l_full_name||': start');

3624:
3625: SAVEPOINT Create_Formula_Pvt;
3626:
3627: IF G_DEBUG THEN
3628: ozf_utility_pvt.Debug_Message(l_full_name||': start');
3629: END IF;
3630:
3631: --
3632: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3723: ozf_utility_pvt.debug_message(l_full_name ||': insert');

3719: --
3720: -- Debug message.
3721: --
3722: IF G_DEBUG THEN
3723: ozf_utility_pvt.debug_message(l_full_name ||': insert');
3724: END IF;
3725:
3726:
3727:

Line 3800: ozf_utility_pvt.debug_message(l_full_name ||': end Success');

3796: -- Add success message to message list.
3797: --
3798:
3799: IF G_DEBUG THEN
3800: ozf_utility_pvt.debug_message(l_full_name ||': end Success');
3801: END IF;
3802:
3803:
3804:

Line 3904: ozf_utility_pvt.Debug_Message(l_full_name||': start');

3900:
3901: SAVEPOINT Create_Formula_Entry_Pvt;
3902:
3903: IF G_DEBUG THEN
3904: ozf_utility_pvt.Debug_Message(l_full_name||': start');
3905: END IF;
3906:
3907: --
3908: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3999: ozf_utility_pvt.debug_message(l_full_name ||': insert');

3995: --
3996: -- Debug message.
3997: --
3998: IF G_DEBUG THEN
3999: ozf_utility_pvt.debug_message(l_full_name ||': insert');
4000: END IF;
4001:
4002:
4003:

Line 4080: ozf_utility_pvt.debug_message(l_full_name ||': end Success');

4076: -- Add success message to message list.
4077: --
4078:
4079: IF G_DEBUG THEN
4080: ozf_utility_pvt.debug_message(l_full_name ||': end Success');
4081: END IF;
4082:
4083:
4084:

Line 4166: ozf_utility_pvt.debug_message(l_full_name||': start');

4162: --
4163: -- Output debug message.
4164: --
4165: IF G_DEBUG THEN
4166: ozf_utility_pvt.debug_message(l_full_name||': start');
4167: END IF;
4168:
4169: --
4170: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 4198: ozf_utility_pvt.debug_message(l_full_name ||': delete with Validation');

4194: --
4195:
4196: -- Debug message.
4197: IF G_DEBUG THEN
4198: ozf_utility_pvt.debug_message(l_full_name ||': delete with Validation');
4199:
4200: ozf_utility_pvt.debug_message('formula id '||to_char(p_formula_id));
4201:
4202: ozf_utility_pvt.debug_message('object version number '||to_char(p_object_version_number));

Line 4200: ozf_utility_pvt.debug_message('formula id '||to_char(p_formula_id));

4196: -- Debug message.
4197: IF G_DEBUG THEN
4198: ozf_utility_pvt.debug_message(l_full_name ||': delete with Validation');
4199:
4200: ozf_utility_pvt.debug_message('formula id '||to_char(p_formula_id));
4201:
4202: ozf_utility_pvt.debug_message('object version number '||to_char(p_object_version_number));
4203: END IF;
4204:

Line 4202: ozf_utility_pvt.debug_message('object version number '||to_char(p_object_version_number));

4198: ozf_utility_pvt.debug_message(l_full_name ||': delete with Validation');
4199:
4200: ozf_utility_pvt.debug_message('formula id '||to_char(p_formula_id));
4201:
4202: ozf_utility_pvt.debug_message('object version number '||to_char(p_object_version_number));
4203: END IF;
4204:
4205: DELETE
4206: FROM ozf_act_metric_formulas

Line 4236: ozf_utility_pvt.debug_message(l_full_name ||': End');

4232: --
4233: -- Debug message.
4234: --
4235: IF G_DEBUG THEN
4236: ozf_utility_pvt.debug_message(l_full_name ||': End');
4237: END IF;
4238:
4239:
4240: --