DBA Data[Home] [Help]

APPS.CN_MARK_EVENTS_PKG dependencies on FND_PROFILE

Line 774: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

770: p_event_log_id IN NUMBER
771: , p_org_id IN NUMBER
772: ) IS --required
773: BEGIN
774: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
775: RETURN;
776: END IF;
777:
778: mark_notify_real(

Line 819: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

815: p_mode IN VARCHAR2
816: , p_org_id IN NUMBER
817: ) IS
818: BEGIN
819: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
820: RETURN;
821: END IF;
822:
823: mark_notify_real(

Line 1304: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

1300:
1301: l_event_log_id NUMBER(15);
1302: dummy NUMBER;
1303: BEGIN
1304: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
1305: RETURN;
1306: END IF;
1307:
1308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 1423: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

1419: ) IS
1420: l_event_log_id NUMBER(15);
1421: l_date_range_tbl cn_api.date_range_tbl_type;
1422: BEGIN
1423: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
1424: RETURN;
1425: END IF;
1426:
1427: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 1559: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN

1555: ) IS
1556: l_event_log_id NUMBER(15);
1557: l_date_range_tbl cn_api.date_range_tbl_type;
1558: BEGIN
1559: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN
1560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1561: fnd_log.STRING(
1562: fnd_log.level_procedure
1563: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.begin'

Line 1675: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN

1671: l_date_range_diff_tbl cn_api.date_range_tbl_type;
1672: l_date_range_over_tbl cn_api.date_range_tbl_type;
1673: l_date_range_null_tbl cn_api.date_range_tbl_type;
1674: BEGIN
1675: IF fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y' THEN
1676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1677: fnd_log.STRING(
1678: fnd_log.level_procedure
1679: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.begin'

Line 1885: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

1881: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
1882: BEGIN
1883: -- Log the Event for the Quota changes or any changes in the
1884: -- Plan Element.
1885: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
1886: RETURN;
1887: END IF;
1888:
1889: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 2230: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

2226: l_msg_count NUMBER;
2227: l_msg_data VARCHAR2(2000);
2228: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
2229: BEGIN
2230: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2231: RETURN;
2232: END IF;
2233:
2234: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 2467: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

2463: l_msg_count NUMBER;
2464: l_msg_data VARCHAR2(2000);
2465: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
2466: BEGIN
2467: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2468: RETURN;
2469: END IF;
2470:
2471: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 2626: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

2622: AND intel.period_id = acc.period_id
2623: AND intel.org_id = p_org_id
2624: AND intel.processing_status_code <> 'CLEAN';
2625: BEGIN
2626: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2627: RETURN;
2628: END IF;
2629:
2630: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 2761: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

2757: AND intel.period_id = acc.period_id
2758: AND intel.org_id = acc.org_id
2759: AND intel.processing_status_code <> 'CLEAN';
2760: BEGIN
2761: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2762: RETURN;
2763: END IF;
2764:
2765: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 2895: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

2891: AND intel.period_id = acc.period_id
2892: AND intel.org_id = acc.org_id
2893: AND intel.processing_status_code <> 'CLEAN';
2894: BEGIN
2895: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2896: RETURN;
2897: END IF;
2898:
2899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 3040: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

3036: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3037: l_latest_quota_id NUMBER := 0;
3038: l_event_log_id NUMBER;
3039: BEGIN
3040: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3041: RETURN;
3042: END IF;
3043:
3044: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 3194: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

3190: l_msg_data VARCHAR2(2000);
3191: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3192: l_latest_quota_id NUMBER := 0;
3193: BEGIN
3194: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3195: RETURN;
3196: END IF;
3197:
3198: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 3350: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

3346: l_msg_data VARCHAR2(2000);
3347: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3348: l_latest_quota_id NUMBER := 0;
3349: BEGIN
3350: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3351: RETURN;
3352: END IF;
3353:
3354: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 3612: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

3608: AND cpit.org_id = p_org_id
3609: AND ps.period_id = cpit.cal_period_id
3610: AND ps.org_id = cpit.org_id;
3611: BEGIN
3612: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3613: RETURN;
3614: END IF;
3615:
3616: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 3702: IF (rec.interval_number <> x_interval_number AND fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y') THEN

3698: FETCH c INTO rec;
3699: CLOSE c;
3700:
3701: -- mark the "CHANGE_PERIOD_INTERVAL_NUMBER" event for intelligent calculation
3702: IF (rec.interval_number <> x_interval_number AND fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y') THEN
3703: -- get the object name which is the name of the interval type here.
3704: OPEN NAME(rec.org_id);
3705: FETCH NAME INTO l_object_name;
3706: CLOSE NAME;

Line 3781: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

3777: --
3778: -- Log the Event for the comp plan events or any changes in the
3779: -- plan Assigns
3780: --
3781: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3782: RETURN;
3783: END IF;
3784:
3785: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 3891: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

3887: l_msg_data VARCHAR2(2000);
3888: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3889: l_latest_quota_id NUMBER := 0;
3890: BEGIN
3891: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3892: RETURN;
3893: END IF;
3894:
3895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 4056: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

4052: l_msg_data VARCHAR2(2000);
4053: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4054: l_latest_quota_id NUMBER := 0;
4055: BEGIN
4056: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4057: RETURN;
4058: END IF;
4059:
4060: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 4218: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

4214: l_msg_data VARCHAR2(2000);
4215: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4216: l_latest_quota_id NUMBER := 0;
4217: BEGIN
4218: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4219: RETURN;
4220: END IF;
4221:
4222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 4360: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

4356: l_msg_data VARCHAR2(2000);
4357: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4358: l_latest_quota_id NUMBER := 0;
4359: BEGIN
4360: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4361: RETURN;
4362: END IF;
4363:
4364: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 4479: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

4475: l_msg_data VARCHAR2(2000);
4476: l_event_log_id NUMBER(15);
4477: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4478: BEGIN
4479: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4480: RETURN;
4481: END IF;
4482:
4483: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 4652: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN

4648: l_msg_data VARCHAR2(2000);
4649: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4650: l_latest_quota_id NUMBER := 0;
4651: BEGIN
4652: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4653: RETURN;
4654: END IF;
4655:
4656: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN