[Home] [Help]
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(
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(
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
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
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'
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'
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
2228: l_msg_count NUMBER;
2229: l_msg_data VARCHAR2(2000);
2230: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
2231: BEGIN
2232: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2233: RETURN;
2234: END IF;
2235:
2236: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2465: l_msg_count NUMBER;
2466: l_msg_data VARCHAR2(2000);
2467: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
2468: BEGIN
2469: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2470: RETURN;
2471: END IF;
2472:
2473: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2624: AND intel.period_id = acc.period_id
2625: AND intel.org_id = p_org_id
2626: AND intel.processing_status_code <> 'CLEAN';
2627: BEGIN
2628: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2629: RETURN;
2630: END IF;
2631:
2632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2759: AND intel.period_id = acc.period_id
2760: AND intel.org_id = acc.org_id
2761: AND intel.processing_status_code <> 'CLEAN';
2762: BEGIN
2763: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2764: RETURN;
2765: END IF;
2766:
2767: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2893: AND intel.period_id = acc.period_id
2894: AND intel.org_id = acc.org_id
2895: AND intel.processing_status_code <> 'CLEAN';
2896: BEGIN
2897: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2898: RETURN;
2899: END IF;
2900:
2901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3038: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3039: l_latest_quota_id NUMBER := 0;
3040: l_event_log_id NUMBER;
3041: BEGIN
3042: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3043: RETURN;
3044: END IF;
3045:
3046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3192: l_msg_data VARCHAR2(2000);
3193: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3194: l_latest_quota_id NUMBER := 0;
3195: BEGIN
3196: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3197: RETURN;
3198: END IF;
3199:
3200: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3348: l_msg_data VARCHAR2(2000);
3349: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3350: l_latest_quota_id NUMBER := 0;
3351: BEGIN
3352: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3353: RETURN;
3354: END IF;
3355:
3356: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3610: AND cpit.org_id = p_org_id
3611: AND ps.period_id = cpit.cal_period_id
3612: AND ps.org_id = cpit.org_id;
3613: BEGIN
3614: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3615: RETURN;
3616: END IF;
3617:
3618: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3700: FETCH c INTO rec;
3701: CLOSE c;
3702:
3703: -- mark the "CHANGE_PERIOD_INTERVAL_NUMBER" event for intelligent calculation
3704: IF (rec.interval_number <> x_interval_number AND fnd_profile.VALUE('CN_MARK_EVENTS') = 'Y') THEN
3705: -- get the object name which is the name of the interval type here.
3706: OPEN NAME(rec.org_id);
3707: FETCH NAME INTO l_object_name;
3708: CLOSE NAME;
3779: --
3780: -- Log the Event for the comp plan events or any changes in the
3781: -- plan Assigns
3782: --
3783: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3784: RETURN;
3785: END IF;
3786:
3787: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3891: l_msg_data VARCHAR2(2000);
3892: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3893: l_latest_quota_id NUMBER := 0;
3894: BEGIN
3895: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3896: RETURN;
3897: END IF;
3898:
3899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4056: l_msg_data VARCHAR2(2000);
4057: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4058: l_latest_quota_id NUMBER := 0;
4059: BEGIN
4060: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4061: RETURN;
4062: END IF;
4063:
4064: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4218: l_msg_data VARCHAR2(2000);
4219: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4220: l_latest_quota_id NUMBER := 0;
4221: BEGIN
4222: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4223: RETURN;
4224: END IF;
4225:
4226: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4361: l_msg_data VARCHAR2(2000);
4362: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4363: l_latest_quota_id NUMBER := 0;
4364: BEGIN
4365: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4366: RETURN;
4367: END IF;
4368:
4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4480: l_msg_data VARCHAR2(2000);
4481: l_event_log_id NUMBER(15);
4482: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4483: BEGIN
4484: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4485: RETURN;
4486: END IF;
4487:
4488: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4653: l_msg_data VARCHAR2(2000);
4654: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
4655: l_latest_quota_id NUMBER := 0;
4656: BEGIN
4657: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4658: RETURN;
4659: END IF;
4660:
4661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN