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.CN_MARK_EVENTS_PKG dependencies on FND_LOG

Line 79: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

75: )
76: RETURNING event_log_id INTO x_event_log_id;
77: EXCEPTION
78: WHEN OTHERS THEN
79: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
80: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_mark_events_pkg.log_event.exception'
81: , SQLERRM);
82: END IF;
83:

Line 80: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_mark_events_pkg.log_event.exception'

76: RETURNING event_log_id INTO x_event_log_id;
77: EXCEPTION
78: WHEN OTHERS THEN
79: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
80: fnd_log.STRING(fnd_log.level_unexpected, 'cn.plsql.cn_mark_events_pkg.log_event.exception'
81: , SQLERRM);
82: END IF;
83:
84: RAISE;

Line 213: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

209: l_notify_log_id NUMBER(15);
210: l_insert_flag BOOLEAN;
211: l_update_flag BOOLEAN;
212: BEGIN
213: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
214: fnd_log.STRING(
215: fnd_log.level_procedure
216: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.begin'
217: , 'Beginning of mark_notify_real ...'

Line 214: fnd_log.STRING(

210: l_insert_flag BOOLEAN;
211: l_update_flag BOOLEAN;
212: BEGIN
213: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
214: fnd_log.STRING(
215: fnd_log.level_procedure
216: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.begin'
217: , 'Beginning of mark_notify_real ...'
218: );

Line 215: fnd_log.level_procedure

211: l_update_flag BOOLEAN;
212: BEGIN
213: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
214: fnd_log.STRING(
215: fnd_log.level_procedure
216: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.begin'
217: , 'Beginning of mark_notify_real ...'
218: );
219: END IF;

Line 500: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

496: );
497: END IF;
498: END IF;
499:
500: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
501: fnd_log.STRING(
502: fnd_log.level_procedure
503: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.end'
504: , 'End of mark_notify_real.'

Line 501: fnd_log.STRING(

497: END IF;
498: END IF;
499:
500: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
501: fnd_log.STRING(
502: fnd_log.level_procedure
503: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.end'
504: , 'End of mark_notify_real.'
505: );

Line 502: fnd_log.level_procedure

498: END IF;
499:
500: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
501: fnd_log.STRING(
502: fnd_log.level_procedure
503: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.end'
504: , 'End of mark_notify_real.'
505: );
506: END IF;

Line 541: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

537: IF l_col_all_entry_csr%ISOPEN THEN
538: CLOSE l_col_all_entry_csr;
539: END IF;
540:
541: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
542: fnd_log.STRING(
543: fnd_log.level_unexpected
544: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.exception'
545: , SQLERRM

Line 542: fnd_log.STRING(

538: CLOSE l_col_all_entry_csr;
539: END IF;
540:
541: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
542: fnd_log.STRING(
543: fnd_log.level_unexpected
544: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.exception'
545: , SQLERRM
546: );

Line 543: fnd_log.level_unexpected

539: END IF;
540:
541: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
542: fnd_log.STRING(
543: fnd_log.level_unexpected
544: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.exception'
545: , SQLERRM
546: );
547: END IF;

Line 669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

665: AND intel.processing_status_code <> 'CLEAN');
666:
667: l_revert_to_state VARCHAR2(30);
668: BEGIN
669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
670: fnd_log.STRING(
671: fnd_log.level_procedure
672: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.begin'
673: , 'Beginning of mark_subsequent_periods ...'

Line 670: fnd_log.STRING(

666:
667: l_revert_to_state VARCHAR2(30);
668: BEGIN
669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
670: fnd_log.STRING(
671: fnd_log.level_procedure
672: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.begin'
673: , 'Beginning of mark_subsequent_periods ...'
674: );

Line 671: fnd_log.level_procedure

667: l_revert_to_state VARCHAR2(30);
668: BEGIN
669: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
670: fnd_log.STRING(
671: fnd_log.level_procedure
672: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.begin'
673: , 'Beginning of mark_subsequent_periods ...'
674: );
675: END IF;

Line 729: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

725: END LOOP;
726: END IF;
727: END IF;
728:
729: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
730: fnd_log.STRING(
731: fnd_log.level_procedure
732: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.end'
733: , 'End of mark_subsequent_periods.'

Line 730: fnd_log.STRING(

726: END IF;
727: END IF;
728:
729: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
730: fnd_log.STRING(
731: fnd_log.level_procedure
732: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.end'
733: , 'End of mark_subsequent_periods.'
734: );

Line 731: fnd_log.level_procedure

727: END IF;
728:
729: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
730: fnd_log.STRING(
731: fnd_log.level_procedure
732: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.end'
733: , 'End of mark_subsequent_periods.'
734: );
735: END IF;

Line 738: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

734: );
735: END IF;
736: EXCEPTION
737: WHEN OTHERS THEN
738: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
739: fnd_log.STRING(
740: fnd_log.level_unexpected
741: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.exception'
742: , SQLERRM

Line 739: fnd_log.STRING(

735: END IF;
736: EXCEPTION
737: WHEN OTHERS THEN
738: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
739: fnd_log.STRING(
740: fnd_log.level_unexpected
741: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.exception'
742: , SQLERRM
743: );

Line 740: fnd_log.level_unexpected

736: EXCEPTION
737: WHEN OTHERS THEN
738: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
739: fnd_log.STRING(
740: fnd_log.level_unexpected
741: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.exception'
742: , SQLERRM
743: );
744: END IF;

Line 895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

891: AND NVL(base_salesrep_id, -999999) = NVL(p_base_salesrep_id, -999999)
892: AND NVL(base_comp_group_id, -999999) = NVL(p_base_comp_group_id, -999999)
893: AND NVL(role_id, -999999) = NVL(p_role_id, -999999);
894: BEGIN
895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
896: fnd_log.STRING(
897: fnd_log.level_procedure
898: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.begin'
899: , 'Beginning of mark_notify_salesreps...'

Line 896: fnd_log.STRING(

892: AND NVL(base_comp_group_id, -999999) = NVL(p_base_comp_group_id, -999999)
893: AND NVL(role_id, -999999) = NVL(p_role_id, -999999);
894: BEGIN
895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
896: fnd_log.STRING(
897: fnd_log.level_procedure
898: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.begin'
899: , 'Beginning of mark_notify_salesreps...'
900: );

Line 897: fnd_log.level_procedure

893: AND NVL(role_id, -999999) = NVL(p_role_id, -999999);
894: BEGIN
895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
896: fnd_log.STRING(
897: fnd_log.level_procedure
898: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.begin'
899: , 'Beginning of mark_notify_salesreps...'
900: );
901: END IF;

Line 1024: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1020: );
1021: END IF;
1022: END IF;
1023:
1024: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1025: fnd_log.STRING(
1026: fnd_log.level_procedure
1027: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.end'
1028: , 'End of mark_notify_salesreps.'

Line 1025: fnd_log.STRING(

1021: END IF;
1022: END IF;
1023:
1024: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1025: fnd_log.STRING(
1026: fnd_log.level_procedure
1027: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.end'
1028: , 'End of mark_notify_salesreps.'
1029: );

Line 1026: fnd_log.level_procedure

1022: END IF;
1023:
1024: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1025: fnd_log.STRING(
1026: fnd_log.level_procedure
1027: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.end'
1028: , 'End of mark_notify_salesreps.'
1029: );
1030: END IF;

Line 1033: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1029: );
1030: END IF;
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1034: fnd_log.STRING(
1035: fnd_log.level_unexpected
1036: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.exception'
1037: , SQLERRM

Line 1034: fnd_log.STRING(

1030: END IF;
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1034: fnd_log.STRING(
1035: fnd_log.level_unexpected
1036: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.exception'
1037: , SQLERRM
1038: );

Line 1035: fnd_log.level_unexpected

1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1034: fnd_log.STRING(
1035: fnd_log.level_unexpected
1036: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.exception'
1037: , SQLERRM
1038: );
1039: END IF;

Line 1065: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1061: AND acc.period_status = 'O'
1062: AND acc.org_id = p_org_id
1063: ORDER BY acc.period_id DESC;
1064: BEGIN
1065: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1066: fnd_log.STRING(
1067: fnd_log.level_procedure
1068: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.begin'
1069: , 'Beginning of mark_notify_dates ...'

Line 1066: fnd_log.STRING(

1062: AND acc.org_id = p_org_id
1063: ORDER BY acc.period_id DESC;
1064: BEGIN
1065: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1066: fnd_log.STRING(
1067: fnd_log.level_procedure
1068: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.begin'
1069: , 'Beginning of mark_notify_dates ...'
1070: );

Line 1067: fnd_log.level_procedure

1063: ORDER BY acc.period_id DESC;
1064: BEGIN
1065: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1066: fnd_log.STRING(
1067: fnd_log.level_procedure
1068: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.begin'
1069: , 'Beginning of mark_notify_dates ...'
1070: );
1071: END IF;

Line 1105: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1101: );
1102: END IF;
1103: END LOOP;
1104:
1105: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1106: fnd_log.STRING(
1107: fnd_log.level_procedure
1108: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.end'
1109: , 'End of mark_notify_dates.'

Line 1106: fnd_log.STRING(

1102: END IF;
1103: END LOOP;
1104:
1105: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1106: fnd_log.STRING(
1107: fnd_log.level_procedure
1108: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.end'
1109: , 'End of mark_notify_dates.'
1110: );

Line 1107: fnd_log.level_procedure

1103: END LOOP;
1104:
1105: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1106: fnd_log.STRING(
1107: fnd_log.level_procedure
1108: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.end'
1109: , 'End of mark_notify_dates.'
1110: );
1111: END IF;

Line 1114: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1110: );
1111: END IF;
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1115: fnd_log.STRING(
1116: fnd_log.level_unexpected
1117: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.exception'
1118: , SQLERRM

Line 1115: fnd_log.STRING(

1111: END IF;
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1115: fnd_log.STRING(
1116: fnd_log.level_unexpected
1117: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.exception'
1118: , SQLERRM
1119: );

Line 1116: fnd_log.level_unexpected

1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1115: fnd_log.STRING(
1116: fnd_log.level_unexpected
1117: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.exception'
1118: , SQLERRM
1119: );
1120: END IF;

Line 1197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1193: AND acc.period_status = 'O'
1194: AND acc.org_id = p_org_id
1195: ORDER BY acc.period_id DESC;
1196: BEGIN
1197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1198: fnd_log.STRING(
1199: fnd_log.level_procedure
1200: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.begin'
1201: , 'Beginning of mark_notify_dates ...'

Line 1198: fnd_log.STRING(

1194: AND acc.org_id = p_org_id
1195: ORDER BY acc.period_id DESC;
1196: BEGIN
1197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1198: fnd_log.STRING(
1199: fnd_log.level_procedure
1200: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.begin'
1201: , 'Beginning of mark_notify_dates ...'
1202: );

Line 1199: fnd_log.level_procedure

1195: ORDER BY acc.period_id DESC;
1196: BEGIN
1197: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1198: fnd_log.STRING(
1199: fnd_log.level_procedure
1200: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.begin'
1201: , 'Beginning of mark_notify_dates ...'
1202: );
1203: END IF;

Line 1237: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1233: );
1234: END IF;
1235: END LOOP;
1236:
1237: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1238: fnd_log.STRING(
1239: fnd_log.level_procedure
1240: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.end'
1241: , 'End of mark_notify_dates.'

Line 1238: fnd_log.STRING(

1234: END IF;
1235: END LOOP;
1236:
1237: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1238: fnd_log.STRING(
1239: fnd_log.level_procedure
1240: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.end'
1241: , 'End of mark_notify_dates.'
1242: );

Line 1239: fnd_log.level_procedure

1235: END LOOP;
1236:
1237: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1238: fnd_log.STRING(
1239: fnd_log.level_procedure
1240: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.end'
1241: , 'End of mark_notify_dates.'
1242: );
1243: END IF;

Line 1246: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1242: );
1243: END IF;
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1247: fnd_log.STRING(
1248: fnd_log.level_unexpected
1249: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.exception'
1250: , SQLERRM

Line 1247: fnd_log.STRING(

1243: END IF;
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1247: fnd_log.STRING(
1248: fnd_log.level_unexpected
1249: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.exception'
1250: , SQLERRM
1251: );

Line 1248: fnd_log.level_unexpected

1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1247: fnd_log.STRING(
1248: fnd_log.level_unexpected
1249: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.exception'
1250: , SQLERRM
1251: );
1252: END IF;

Line 1308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
1309: fnd_log.STRING(
1310: fnd_log.level_procedure
1311: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.begin'
1312: , 'Beginning of mark_event_sys_para ...'

Line 1309: fnd_log.STRING(

1305: RETURN;
1306: END IF;
1307:
1308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1309: fnd_log.STRING(
1310: fnd_log.level_procedure
1311: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.begin'
1312: , 'Beginning of mark_event_sys_para ...'
1313: );

Line 1310: fnd_log.level_procedure

1306: END IF;
1307:
1308: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1309: fnd_log.STRING(
1310: fnd_log.level_procedure
1311: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.begin'
1312: , 'Beginning of mark_event_sys_para ...'
1313: );
1314: END IF;

Line 1368: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1364: );
1365: END LOOP;
1366: END IF;
1367:
1368: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1369: fnd_log.STRING(
1370: fnd_log.level_procedure
1371: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.end'
1372: , 'End of mark_event_sys_para.'

Line 1369: fnd_log.STRING(

1365: END LOOP;
1366: END IF;
1367:
1368: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1369: fnd_log.STRING(
1370: fnd_log.level_procedure
1371: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.end'
1372: , 'End of mark_event_sys_para.'
1373: );

Line 1370: fnd_log.level_procedure

1366: END IF;
1367:
1368: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1369: fnd_log.STRING(
1370: fnd_log.level_procedure
1371: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.end'
1372: , 'End of mark_event_sys_para.'
1373: );
1374: END IF;

Line 1377: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1373: );
1374: END IF;
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1378: fnd_log.STRING(
1379: fnd_log.level_unexpected
1380: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.exception'
1381: , SQLERRM

Line 1378: fnd_log.STRING(

1374: END IF;
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1378: fnd_log.STRING(
1379: fnd_log.level_unexpected
1380: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.exception'
1381: , SQLERRM
1382: );

Line 1379: fnd_log.level_unexpected

1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1378: fnd_log.STRING(
1379: fnd_log.level_unexpected
1380: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.exception'
1381: , SQLERRM
1382: );
1383: END IF;

Line 1427: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
1428: fnd_log.STRING(
1429: fnd_log.level_procedure
1430: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.begin'
1431: , 'Beginning of mark_event_cls_rule ...'

Line 1428: fnd_log.STRING(

1424: RETURN;
1425: END IF;
1426:
1427: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1428: fnd_log.STRING(
1429: fnd_log.level_procedure
1430: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.begin'
1431: , 'Beginning of mark_event_cls_rule ...'
1432: );

Line 1429: fnd_log.level_procedure

1425: END IF;
1426:
1427: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1428: fnd_log.STRING(
1429: fnd_log.level_procedure
1430: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.begin'
1431: , 'Beginning of mark_event_cls_rule ...'
1432: );
1433: END IF;

Line 1464: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1460: );
1461: END LOOP;
1462: END IF;
1463:
1464: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1465: fnd_log.STRING(
1466: fnd_log.level_procedure
1467: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.end'
1468: , 'End of mark_event_cls_rule.'

Line 1465: fnd_log.STRING(

1461: END LOOP;
1462: END IF;
1463:
1464: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1465: fnd_log.STRING(
1466: fnd_log.level_procedure
1467: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.end'
1468: , 'End of mark_event_cls_rule.'
1469: );

Line 1466: fnd_log.level_procedure

1462: END IF;
1463:
1464: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1465: fnd_log.STRING(
1466: fnd_log.level_procedure
1467: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.end'
1468: , 'End of mark_event_cls_rule.'
1469: );
1470: END IF;

Line 1473: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1469: );
1470: END IF;
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1474: fnd_log.STRING(
1475: fnd_log.level_unexpected
1476: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.exception'
1477: , SQLERRM

Line 1474: fnd_log.STRING(

1470: END IF;
1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1474: fnd_log.STRING(
1475: fnd_log.level_unexpected
1476: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.exception'
1477: , SQLERRM
1478: );

Line 1475: fnd_log.level_unexpected

1471: EXCEPTION
1472: WHEN OTHERS THEN
1473: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1474: fnd_log.STRING(
1475: fnd_log.level_unexpected
1476: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.exception'
1477: , SQLERRM
1478: );
1479: END IF;

Line 1560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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'
1564: , 'Beginning of mark_event_rc_hier ...'

Line 1561: fnd_log.STRING(

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'
1564: , 'Beginning of mark_event_rc_hier ...'
1565: );

Line 1562: fnd_log.level_procedure

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'
1564: , 'Beginning of mark_event_rc_hier ...'
1565: );
1566: END IF;

Line 1597: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1593: );
1594: END LOOP;
1595: END IF;
1596:
1597: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1598: fnd_log.STRING(
1599: fnd_log.level_procedure
1600: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.end'
1601: , 'End of mark_event_rc_hier.'

Line 1598: fnd_log.STRING(

1594: END LOOP;
1595: END IF;
1596:
1597: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1598: fnd_log.STRING(
1599: fnd_log.level_procedure
1600: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.end'
1601: , 'End of mark_event_rc_hier.'
1602: );

Line 1599: fnd_log.level_procedure

1595: END IF;
1596:
1597: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1598: fnd_log.STRING(
1599: fnd_log.level_procedure
1600: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.end'
1601: , 'End of mark_event_rc_hier.'
1602: );
1603: END IF;

Line 1607: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1603: END IF;
1604: END IF;
1605: EXCEPTION
1606: WHEN OTHERS THEN
1607: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1608: fnd_log.STRING(
1609: fnd_log.level_unexpected
1610: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.exception'
1611: , SQLERRM

Line 1608: fnd_log.STRING(

1604: END IF;
1605: EXCEPTION
1606: WHEN OTHERS THEN
1607: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1608: fnd_log.STRING(
1609: fnd_log.level_unexpected
1610: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.exception'
1611: , SQLERRM
1612: );

Line 1609: fnd_log.level_unexpected

1605: EXCEPTION
1606: WHEN OTHERS THEN
1607: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1608: fnd_log.STRING(
1609: fnd_log.level_unexpected
1610: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.exception'
1611: , SQLERRM
1612: );
1613: END IF;

Line 1676: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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'
1680: , 'Beginning of mark_event_cls_hier ...'

Line 1677: fnd_log.STRING(

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'
1680: , 'Beginning of mark_event_cls_hier ...'
1681: );

Line 1678: fnd_log.level_procedure

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'
1680: , 'Beginning of mark_event_cls_hier ...'
1681: );
1682: END IF;

Line 1753: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1749:
1750: l_date_range_diff_tbl := l_date_range_null_tbl;
1751: END IF;
1752:
1753: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1754: fnd_log.STRING(
1755: fnd_log.level_procedure
1756: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.end'
1757: , 'End of mark_event_cls_hier.'

Line 1754: fnd_log.STRING(

1750: l_date_range_diff_tbl := l_date_range_null_tbl;
1751: END IF;
1752:
1753: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1754: fnd_log.STRING(
1755: fnd_log.level_procedure
1756: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.end'
1757: , 'End of mark_event_cls_hier.'
1758: );

Line 1755: fnd_log.level_procedure

1751: END IF;
1752:
1753: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1754: fnd_log.STRING(
1755: fnd_log.level_procedure
1756: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.end'
1757: , 'End of mark_event_cls_hier.'
1758: );
1759: END IF;

Line 1763: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

1759: END IF;
1760: END IF;
1761: EXCEPTION
1762: WHEN OTHERS THEN
1763: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1764: fnd_log.STRING(
1765: fnd_log.level_unexpected
1766: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.exception'
1767: , SQLERRM

Line 1764: fnd_log.STRING(

1760: END IF;
1761: EXCEPTION
1762: WHEN OTHERS THEN
1763: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1764: fnd_log.STRING(
1765: fnd_log.level_unexpected
1766: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.exception'
1767: , SQLERRM
1768: );

Line 1765: fnd_log.level_unexpected

1761: EXCEPTION
1762: WHEN OTHERS THEN
1763: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
1764: fnd_log.STRING(
1765: fnd_log.level_unexpected
1766: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.exception'
1767: , SQLERRM
1768: );
1769: END IF;

Line 1889: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
1890: fnd_log.STRING(
1891: fnd_log.level_procedure
1892: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.begin'
1893: , 'Beginning of mark_event_quota ...'

Line 1890: fnd_log.STRING(

1886: RETURN;
1887: END IF;
1888:
1889: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1890: fnd_log.STRING(
1891: fnd_log.level_procedure
1892: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.begin'
1893: , 'Beginning of mark_event_quota ...'
1894: );

Line 1891: fnd_log.level_procedure

1887: END IF;
1888:
1889: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1890: fnd_log.STRING(
1891: fnd_log.level_procedure
1892: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.begin'
1893: , 'Beginning of mark_event_quota ...'
1894: );
1895: END IF;

Line 2136: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2132: END LOOP;
2133: END LOOP;
2134: END IF;
2135:
2136: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2137: fnd_log.STRING(
2138: fnd_log.level_procedure
2139: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.end'
2140: , 'End of mark_event_quota.'

Line 2137: fnd_log.STRING(

2133: END LOOP;
2134: END IF;
2135:
2136: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2137: fnd_log.STRING(
2138: fnd_log.level_procedure
2139: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.end'
2140: , 'End of mark_event_quota.'
2141: );

Line 2138: fnd_log.level_procedure

2134: END IF;
2135:
2136: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2137: fnd_log.STRING(
2138: fnd_log.level_procedure
2139: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.end'
2140: , 'End of mark_event_quota.'
2141: );
2142: END IF;

Line 2145: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2141: );
2142: END IF;
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2146: fnd_log.STRING(
2147: fnd_log.level_unexpected
2148: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.exception'
2149: , SQLERRM

Line 2146: fnd_log.STRING(

2142: END IF;
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2146: fnd_log.STRING(
2147: fnd_log.level_unexpected
2148: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.exception'
2149: , SQLERRM
2150: );

Line 2147: fnd_log.level_unexpected

2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2146: fnd_log.STRING(
2147: fnd_log.level_unexpected
2148: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.exception'
2149: , SQLERRM
2150: );
2151: END IF;

Line 2236: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
2237: fnd_log.STRING(
2238: fnd_log.level_procedure
2239: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.begin'
2240: , 'Beginning of mark_event_rt_quota ...'

Line 2237: fnd_log.STRING(

2233: RETURN;
2234: END IF;
2235:
2236: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2237: fnd_log.STRING(
2238: fnd_log.level_procedure
2239: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.begin'
2240: , 'Beginning of mark_event_rt_quota ...'
2241: );

Line 2238: fnd_log.level_procedure

2234: END IF;
2235:
2236: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2237: fnd_log.STRING(
2238: fnd_log.level_procedure
2239: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.begin'
2240: , 'Beginning of mark_event_rt_quota ...'
2241: );
2242: END IF;

Line 2366: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2362: END LOOP;
2363: END LOOP;
2364: END IF;
2365:
2366: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2367: fnd_log.STRING(
2368: fnd_log.level_procedure
2369: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.end'
2370: , 'End of mark_event_rt_quota.'

Line 2367: fnd_log.STRING(

2363: END LOOP;
2364: END IF;
2365:
2366: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2367: fnd_log.STRING(
2368: fnd_log.level_procedure
2369: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.end'
2370: , 'End of mark_event_rt_quota.'
2371: );

Line 2368: fnd_log.level_procedure

2364: END IF;
2365:
2366: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2367: fnd_log.STRING(
2368: fnd_log.level_procedure
2369: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.end'
2370: , 'End of mark_event_rt_quota.'
2371: );
2372: END IF;

Line 2375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2371: );
2372: END IF;
2373: EXCEPTION
2374: WHEN OTHERS THEN
2375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2376: fnd_log.STRING(
2377: fnd_log.level_unexpected
2378: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.exception'
2379: , SQLERRM

Line 2376: fnd_log.STRING(

2372: END IF;
2373: EXCEPTION
2374: WHEN OTHERS THEN
2375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2376: fnd_log.STRING(
2377: fnd_log.level_unexpected
2378: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.exception'
2379: , SQLERRM
2380: );

Line 2377: fnd_log.level_unexpected

2373: EXCEPTION
2374: WHEN OTHERS THEN
2375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2376: fnd_log.STRING(
2377: fnd_log.level_unexpected
2378: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.exception'
2379: , SQLERRM
2380: );
2381: END IF;

Line 2473: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
2474: fnd_log.STRING(
2475: fnd_log.level_procedure
2476: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.begin'
2477: , 'Beginning of mark_event_trx_factor ...'

Line 2474: fnd_log.STRING(

2470: RETURN;
2471: END IF;
2472:
2473: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2474: fnd_log.STRING(
2475: fnd_log.level_procedure
2476: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.begin'
2477: , 'Beginning of mark_event_trx_factor ...'
2478: );

Line 2475: fnd_log.level_procedure

2471: END IF;
2472:
2473: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2474: fnd_log.STRING(
2475: fnd_log.level_procedure
2476: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.begin'
2477: , 'Beginning of mark_event_trx_factor ...'
2478: );
2479: END IF;

Line 2561: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2557: END IF; -- If (dependent_pe_tbl.count > 0)
2558: END LOOP;
2559: END IF;
2560:
2561: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2562: fnd_log.STRING(
2563: fnd_log.level_procedure
2564: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.end'
2565: , 'End of mark_event_trx_factor.'

Line 2562: fnd_log.STRING(

2558: END LOOP;
2559: END IF;
2560:
2561: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2562: fnd_log.STRING(
2563: fnd_log.level_procedure
2564: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.end'
2565: , 'End of mark_event_trx_factor.'
2566: );

Line 2563: fnd_log.level_procedure

2559: END IF;
2560:
2561: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2562: fnd_log.STRING(
2563: fnd_log.level_procedure
2564: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.end'
2565: , 'End of mark_event_trx_factor.'
2566: );
2567: END IF;

Line 2570: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2566: );
2567: END IF;
2568: EXCEPTION
2569: WHEN OTHERS THEN
2570: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2571: fnd_log.STRING(
2572: fnd_log.level_unexpected
2573: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.exception'
2574: , SQLERRM

Line 2571: fnd_log.STRING(

2567: END IF;
2568: EXCEPTION
2569: WHEN OTHERS THEN
2570: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2571: fnd_log.STRING(
2572: fnd_log.level_unexpected
2573: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.exception'
2574: , SQLERRM
2575: );

Line 2572: fnd_log.level_unexpected

2568: EXCEPTION
2569: WHEN OTHERS THEN
2570: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2571: fnd_log.STRING(
2572: fnd_log.level_unexpected
2573: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.exception'
2574: , SQLERRM
2575: );
2576: END IF;

Line 2632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
2633: fnd_log.STRING(
2634: fnd_log.level_procedure
2635: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.begin'
2636: , 'Beginning of mark_event_role_plans ...'

Line 2633: fnd_log.STRING(

2629: RETURN;
2630: END IF;
2631:
2632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2633: fnd_log.STRING(
2634: fnd_log.level_procedure
2635: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.begin'
2636: , 'Beginning of mark_event_role_plans ...'
2637: );

Line 2634: fnd_log.level_procedure

2630: END IF;
2631:
2632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2633: fnd_log.STRING(
2634: fnd_log.level_procedure
2635: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.begin'
2636: , 'Beginning of mark_event_role_plans ...'
2637: );
2638: END IF;

Line 2699: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2695: END LOOP;
2696: END LOOP;
2697: END IF;
2698:
2699: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2700: fnd_log.STRING(
2701: fnd_log.level_procedure
2702: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.end'
2703: , 'End of mark_event_role_plans.'

Line 2700: fnd_log.STRING(

2696: END LOOP;
2697: END IF;
2698:
2699: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2700: fnd_log.STRING(
2701: fnd_log.level_procedure
2702: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.end'
2703: , 'End of mark_event_role_plans.'
2704: );

Line 2701: fnd_log.level_procedure

2697: END IF;
2698:
2699: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2700: fnd_log.STRING(
2701: fnd_log.level_procedure
2702: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.end'
2703: , 'End of mark_event_role_plans.'
2704: );
2705: END IF;

Line 2708: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2704: );
2705: END IF;
2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2709: fnd_log.STRING(
2710: fnd_log.level_unexpected
2711: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.exception'
2712: , SQLERRM

Line 2709: fnd_log.STRING(

2705: END IF;
2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2709: fnd_log.STRING(
2710: fnd_log.level_unexpected
2711: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.exception'
2712: , SQLERRM
2713: );

Line 2710: fnd_log.level_unexpected

2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2709: fnd_log.STRING(
2710: fnd_log.level_unexpected
2711: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.exception'
2712: , SQLERRM
2713: );
2714: END IF;

Line 2767: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
2768: fnd_log.STRING(
2769: fnd_log.level_procedure
2770: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.begin'
2771: , 'Beginning of mark_event_spr_pay_group ...'

Line 2768: fnd_log.STRING(

2764: RETURN;
2765: END IF;
2766:
2767: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2768: fnd_log.STRING(
2769: fnd_log.level_procedure
2770: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.begin'
2771: , 'Beginning of mark_event_spr_pay_group ...'
2772: );

Line 2769: fnd_log.level_procedure

2765: END IF;
2766:
2767: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2768: fnd_log.STRING(
2769: fnd_log.level_procedure
2770: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.begin'
2771: , 'Beginning of mark_event_spr_pay_group ...'
2772: );
2773: END IF;

Line 2834: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2830: END LOOP;
2831: END LOOP;
2832: END IF;
2833:
2834: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2835: fnd_log.STRING(
2836: fnd_log.level_procedure
2837: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.end'
2838: , 'End of mark_event_srp_pay_group.'

Line 2835: fnd_log.STRING(

2831: END LOOP;
2832: END IF;
2833:
2834: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2835: fnd_log.STRING(
2836: fnd_log.level_procedure
2837: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.end'
2838: , 'End of mark_event_srp_pay_group.'
2839: );

Line 2836: fnd_log.level_procedure

2832: END IF;
2833:
2834: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2835: fnd_log.STRING(
2836: fnd_log.level_procedure
2837: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.end'
2838: , 'End of mark_event_srp_pay_group.'
2839: );
2840: END IF;

Line 2843: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2839: );
2840: END IF;
2841: EXCEPTION
2842: WHEN OTHERS THEN
2843: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2844: fnd_log.STRING(
2845: fnd_log.level_unexpected
2846: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.exception'
2847: , SQLERRM

Line 2844: fnd_log.STRING(

2840: END IF;
2841: EXCEPTION
2842: WHEN OTHERS THEN
2843: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2844: fnd_log.STRING(
2845: fnd_log.level_unexpected
2846: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.exception'
2847: , SQLERRM
2848: );

Line 2845: fnd_log.level_unexpected

2841: EXCEPTION
2842: WHEN OTHERS THEN
2843: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2844: fnd_log.STRING(
2845: fnd_log.level_unexpected
2846: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.exception'
2847: , SQLERRM
2848: );
2849: END IF;

Line 2901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
2902: fnd_log.STRING(
2903: fnd_log.level_procedure
2904: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.begin'
2905: , 'Beginning of mark_event_srp_roles ...'

Line 2902: fnd_log.STRING(

2898: RETURN;
2899: END IF;
2900:
2901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2902: fnd_log.STRING(
2903: fnd_log.level_procedure
2904: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.begin'
2905: , 'Beginning of mark_event_srp_roles ...'
2906: );

Line 2903: fnd_log.level_procedure

2899: END IF;
2900:
2901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2902: fnd_log.STRING(
2903: fnd_log.level_procedure
2904: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.begin'
2905: , 'Beginning of mark_event_srp_roles ...'
2906: );
2907: END IF;

Line 2971: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2967: END LOOP;
2968: END LOOP;
2969: END IF;
2970:
2971: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2972: fnd_log.STRING(
2973: fnd_log.level_procedure
2974: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.end'
2975: , 'End of mark_event_srp_roles.'

Line 2972: fnd_log.STRING(

2968: END LOOP;
2969: END IF;
2970:
2971: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2972: fnd_log.STRING(
2973: fnd_log.level_procedure
2974: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.end'
2975: , 'End of mark_event_srp_roles.'
2976: );

Line 2973: fnd_log.level_procedure

2969: END IF;
2970:
2971: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2972: fnd_log.STRING(
2973: fnd_log.level_procedure
2974: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.end'
2975: , 'End of mark_event_srp_roles.'
2976: );
2977: END IF;

Line 2980: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

2976: );
2977: END IF;
2978: EXCEPTION
2979: WHEN OTHERS THEN
2980: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2981: fnd_log.STRING(
2982: fnd_log.level_unexpected
2983: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.exception'
2984: , SQLERRM

Line 2981: fnd_log.STRING(

2977: END IF;
2978: EXCEPTION
2979: WHEN OTHERS THEN
2980: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2981: fnd_log.STRING(
2982: fnd_log.level_unexpected
2983: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.exception'
2984: , SQLERRM
2985: );

Line 2982: fnd_log.level_unexpected

2978: EXCEPTION
2979: WHEN OTHERS THEN
2980: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2981: fnd_log.STRING(
2982: fnd_log.level_unexpected
2983: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.exception'
2984: , SQLERRM
2985: );
2986: END IF;

Line 3046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
3047: fnd_log.STRING(
3048: fnd_log.level_procedure
3049: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.begin'
3050: , 'Beginning of mark_event_formula ...'

Line 3047: fnd_log.STRING(

3043: RETURN;
3044: END IF;
3045:
3046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3047: fnd_log.STRING(
3048: fnd_log.level_procedure
3049: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.begin'
3050: , 'Beginning of mark_event_formula ...'
3051: );

Line 3048: fnd_log.level_procedure

3044: END IF;
3045:
3046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3047: fnd_log.STRING(
3048: fnd_log.level_procedure
3049: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.begin'
3050: , 'Beginning of mark_event_formula ...'
3051: );
3052: END IF;

Line 3122: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3118: END IF; -- If (dependent_pe_tbl.count > 0)
3119: END LOOP;
3120: END IF;
3121:
3122: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3123: fnd_log.STRING(
3124: fnd_log.level_procedure
3125: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.end'
3126: , 'End of mark_event_formula.'

Line 3123: fnd_log.STRING(

3119: END LOOP;
3120: END IF;
3121:
3122: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3123: fnd_log.STRING(
3124: fnd_log.level_procedure
3125: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.end'
3126: , 'End of mark_event_formula.'
3127: );

Line 3124: fnd_log.level_procedure

3120: END IF;
3121:
3122: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3123: fnd_log.STRING(
3124: fnd_log.level_procedure
3125: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.end'
3126: , 'End of mark_event_formula.'
3127: );
3128: END IF;

Line 3131: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3127: );
3128: END IF;
3129: EXCEPTION
3130: WHEN OTHERS THEN
3131: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3132: fnd_log.STRING(
3133: fnd_log.level_unexpected
3134: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.exception'
3135: , SQLERRM

Line 3132: fnd_log.STRING(

3128: END IF;
3129: EXCEPTION
3130: WHEN OTHERS THEN
3131: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3132: fnd_log.STRING(
3133: fnd_log.level_unexpected
3134: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.exception'
3135: , SQLERRM
3136: );

Line 3133: fnd_log.level_unexpected

3129: EXCEPTION
3130: WHEN OTHERS THEN
3131: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3132: fnd_log.STRING(
3133: fnd_log.level_unexpected
3134: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.exception'
3135: , SQLERRM
3136: );
3137: END IF;

Line 3200: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
3201: fnd_log.STRING(
3202: fnd_log.level_procedure
3203: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.begin'
3204: , 'Beginning of mark_event_rate_table ...'

Line 3201: fnd_log.STRING(

3197: RETURN;
3198: END IF;
3199:
3200: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3201: fnd_log.STRING(
3202: fnd_log.level_procedure
3203: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.begin'
3204: , 'Beginning of mark_event_rate_table ...'
3205: );

Line 3202: fnd_log.level_procedure

3198: END IF;
3199:
3200: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3201: fnd_log.STRING(
3202: fnd_log.level_procedure
3203: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.begin'
3204: , 'Beginning of mark_event_rate_table ...'
3205: );
3206: END IF;

Line 3276: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3272: END IF; -- If (dependent_pe_tbl.count > 0)
3273: END LOOP;
3274: END IF;
3275:
3276: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3277: fnd_log.STRING(
3278: fnd_log.level_procedure
3279: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.end'
3280: , 'End of mark_event_rate_table.'

Line 3277: fnd_log.STRING(

3273: END LOOP;
3274: END IF;
3275:
3276: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3277: fnd_log.STRING(
3278: fnd_log.level_procedure
3279: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.end'
3280: , 'End of mark_event_rate_table.'
3281: );

Line 3278: fnd_log.level_procedure

3274: END IF;
3275:
3276: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3277: fnd_log.STRING(
3278: fnd_log.level_procedure
3279: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.end'
3280: , 'End of mark_event_rate_table.'
3281: );
3282: END IF;

Line 3285: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3281: );
3282: END IF;
3283: EXCEPTION
3284: WHEN OTHERS THEN
3285: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3286: fnd_log.STRING(
3287: fnd_log.level_unexpected
3288: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.exception'
3289: , SQLERRM

Line 3286: fnd_log.STRING(

3282: END IF;
3283: EXCEPTION
3284: WHEN OTHERS THEN
3285: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3286: fnd_log.STRING(
3287: fnd_log.level_unexpected
3288: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.exception'
3289: , SQLERRM
3290: );

Line 3287: fnd_log.level_unexpected

3283: EXCEPTION
3284: WHEN OTHERS THEN
3285: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3286: fnd_log.STRING(
3287: fnd_log.level_unexpected
3288: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.exception'
3289: , SQLERRM
3290: );
3291: END IF;

Line 3356: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
3357: fnd_log.STRING(
3358: fnd_log.level_procedure
3359: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.begin'
3360: , 'Beginning of mark_event_rate_tier_table...'

Line 3357: fnd_log.STRING(

3353: RETURN;
3354: END IF;
3355:
3356: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3357: fnd_log.STRING(
3358: fnd_log.level_procedure
3359: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.begin'
3360: , 'Beginning of mark_event_rate_tier_table...'
3361: );

Line 3358: fnd_log.level_procedure

3354: END IF;
3355:
3356: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3357: fnd_log.STRING(
3358: fnd_log.level_procedure
3359: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.begin'
3360: , 'Beginning of mark_event_rate_tier_table...'
3361: );
3362: END IF;

Line 3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3427: END IF; -- If (dependent_pe_tbl.count > 0)
3428: END LOOP;
3429: END IF;
3430:
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3432: fnd_log.STRING(
3433: fnd_log.level_procedure
3434: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.end'
3435: , 'End of mark_event_rate_tier_table.'

Line 3432: fnd_log.STRING(

3428: END LOOP;
3429: END IF;
3430:
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3432: fnd_log.STRING(
3433: fnd_log.level_procedure
3434: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.end'
3435: , 'End of mark_event_rate_tier_table.'
3436: );

Line 3433: fnd_log.level_procedure

3429: END IF;
3430:
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3432: fnd_log.STRING(
3433: fnd_log.level_procedure
3434: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.end'
3435: , 'End of mark_event_rate_tier_table.'
3436: );
3437: END IF;

Line 3440: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3436: );
3437: END IF;
3438: EXCEPTION
3439: WHEN OTHERS THEN
3440: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3441: fnd_log.STRING(
3442: fnd_log.level_unexpected
3443: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.exception'
3444: , SQLERRM

Line 3441: fnd_log.STRING(

3437: END IF;
3438: EXCEPTION
3439: WHEN OTHERS THEN
3440: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3441: fnd_log.STRING(
3442: fnd_log.level_unexpected
3443: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.exception'
3444: , SQLERRM
3445: );

Line 3442: fnd_log.level_unexpected

3438: EXCEPTION
3439: WHEN OTHERS THEN
3440: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3441: fnd_log.STRING(
3442: fnd_log.level_unexpected
3443: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.exception'
3444: , SQLERRM
3445: );
3446: END IF;

Line 3494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3490: l_msg_data VARCHAR2(2000);
3491: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3492: l_latest_quota_id NUMBER := 0;
3493: BEGIN
3494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3495: fnd_log.STRING(
3496: fnd_log.level_procedure
3497: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.begin'
3498: , 'Beginning of mark_notify_interval_number ...'

Line 3495: fnd_log.STRING(

3491: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;
3492: l_latest_quota_id NUMBER := 0;
3493: BEGIN
3494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3495: fnd_log.STRING(
3496: fnd_log.level_procedure
3497: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.begin'
3498: , 'Beginning of mark_notify_interval_number ...'
3499: );

Line 3496: fnd_log.level_procedure

3492: l_latest_quota_id NUMBER := 0;
3493: BEGIN
3494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3495: fnd_log.STRING(
3496: fnd_log.level_procedure
3497: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.begin'
3498: , 'Beginning of mark_notify_interval_number ...'
3499: );
3500: END IF;

Line 3560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3556: END IF; -- If (dependent_pe_tbl.count > 0)
3557: END LOOP;
3558: END IF;
3559:
3560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3561: fnd_log.STRING(
3562: fnd_log.level_procedure
3563: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.end'
3564: , 'End of mark_notify_interval_number.'

Line 3561: fnd_log.STRING(

3557: END LOOP;
3558: END IF;
3559:
3560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3561: fnd_log.STRING(
3562: fnd_log.level_procedure
3563: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.end'
3564: , 'End of mark_notify_interval_number.'
3565: );

Line 3562: fnd_log.level_procedure

3558: END IF;
3559:
3560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3561: fnd_log.STRING(
3562: fnd_log.level_procedure
3563: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.end'
3564: , 'End of mark_notify_interval_number.'
3565: );
3566: END IF;

Line 3569: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3565: );
3566: END IF;
3567: EXCEPTION
3568: WHEN OTHERS THEN
3569: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3570: fnd_log.STRING(
3571: fnd_log.level_unexpected
3572: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.exception'
3573: , SQLERRM

Line 3570: fnd_log.STRING(

3566: END IF;
3567: EXCEPTION
3568: WHEN OTHERS THEN
3569: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3570: fnd_log.STRING(
3571: fnd_log.level_unexpected
3572: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.exception'
3573: , SQLERRM
3574: );

Line 3571: fnd_log.level_unexpected

3567: EXCEPTION
3568: WHEN OTHERS THEN
3569: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3570: fnd_log.STRING(
3571: fnd_log.level_unexpected
3572: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.exception'
3573: , SQLERRM
3574: );
3575: END IF;

Line 3618: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
3619: fnd_log.STRING(
3620: fnd_log.level_procedure
3621: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.begin'
3622: , 'Beginning of mark_event_interval_number ...'

Line 3619: fnd_log.STRING(

3615: RETURN;
3616: END IF;
3617:
3618: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3619: fnd_log.STRING(
3620: fnd_log.level_procedure
3621: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.begin'
3622: , 'Beginning of mark_event_interval_number ...'
3623: );

Line 3620: fnd_log.level_procedure

3616: END IF;
3617:
3618: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3619: fnd_log.STRING(
3620: fnd_log.level_procedure
3621: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.begin'
3622: , 'Beginning of mark_event_interval_number ...'
3623: );
3624: END IF;

Line 3651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3647: , p_org_id
3648: );
3649: END LOOP;
3650:
3651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3652: fnd_log.STRING(
3653: fnd_log.level_procedure
3654: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.end'
3655: , 'End of mark_event_interval_number.'

Line 3652: fnd_log.STRING(

3648: );
3649: END LOOP;
3650:
3651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3652: fnd_log.STRING(
3653: fnd_log.level_procedure
3654: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.end'
3655: , 'End of mark_event_interval_number.'
3656: );

Line 3653: fnd_log.level_procedure

3649: END LOOP;
3650:
3651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3652: fnd_log.STRING(
3653: fnd_log.level_procedure
3654: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.end'
3655: , 'End of mark_event_interval_number.'
3656: );
3657: END IF;

Line 3660: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3656: );
3657: END IF;
3658: EXCEPTION
3659: WHEN OTHERS THEN
3660: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3661: fnd_log.STRING(
3662: fnd_log.level_unexpected
3663: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.exception'
3664: , SQLERRM

Line 3661: fnd_log.STRING(

3657: END IF;
3658: EXCEPTION
3659: WHEN OTHERS THEN
3660: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3661: fnd_log.STRING(
3662: fnd_log.level_unexpected
3663: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.exception'
3664: , SQLERRM
3665: );

Line 3662: fnd_log.level_unexpected

3658: EXCEPTION
3659: WHEN OTHERS THEN
3660: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3661: fnd_log.STRING(
3662: fnd_log.level_unexpected
3663: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.exception'
3664: , SQLERRM
3665: );
3666: END IF;

Line 3787: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
3788: fnd_log.STRING(
3789: fnd_log.level_procedure
3790: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.begin'
3791: , 'Beginning of mark_event_comp_plan ...'

Line 3788: fnd_log.STRING(

3784: RETURN;
3785: END IF;
3786:
3787: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3788: fnd_log.STRING(
3789: fnd_log.level_procedure
3790: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.begin'
3791: , 'Beginning of mark_event_comp_plan ...'
3792: );

Line 3789: fnd_log.level_procedure

3785: END IF;
3786:
3787: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3788: fnd_log.STRING(
3789: fnd_log.level_procedure
3790: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.begin'
3791: , 'Beginning of mark_event_comp_plan ...'
3792: );
3793: END IF;

Line 3826: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3822: );
3823: END LOOP;
3824: END IF;
3825:
3826: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3827: fnd_log.STRING(
3828: fnd_log.level_procedure
3829: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.end'
3830: , 'End of mark_event_comp_plan.'

Line 3827: fnd_log.STRING(

3823: END LOOP;
3824: END IF;
3825:
3826: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3827: fnd_log.STRING(
3828: fnd_log.level_procedure
3829: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.end'
3830: , 'End of mark_event_comp_plan.'
3831: );

Line 3828: fnd_log.level_procedure

3824: END IF;
3825:
3826: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3827: fnd_log.STRING(
3828: fnd_log.level_procedure
3829: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.end'
3830: , 'End of mark_event_comp_plan.'
3831: );
3832: END IF;

Line 3835: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3831: );
3832: END IF;
3833: EXCEPTION
3834: WHEN OTHERS THEN
3835: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3836: fnd_log.STRING(
3837: fnd_log.level_unexpected
3838: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.exception'
3839: , SQLERRM

Line 3836: fnd_log.STRING(

3832: END IF;
3833: EXCEPTION
3834: WHEN OTHERS THEN
3835: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3836: fnd_log.STRING(
3837: fnd_log.level_unexpected
3838: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.exception'
3839: , SQLERRM
3840: );

Line 3837: fnd_log.level_unexpected

3833: EXCEPTION
3834: WHEN OTHERS THEN
3835: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3836: fnd_log.STRING(
3837: fnd_log.level_unexpected
3838: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.exception'
3839: , SQLERRM
3840: );
3841: END IF;

Line 3899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
3900: fnd_log.STRING(
3901: fnd_log.level_procedure
3902: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.begin'
3903: , 'Beginning of mark_event_srp_quotas ...'

Line 3900: fnd_log.STRING(

3896: RETURN;
3897: END IF;
3898:
3899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3900: fnd_log.STRING(
3901: fnd_log.level_procedure
3902: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.begin'
3903: , 'Beginning of mark_event_srp_quotas ...'
3904: );

Line 3901: fnd_log.level_procedure

3897: END IF;
3898:
3899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3900: fnd_log.STRING(
3901: fnd_log.level_procedure
3902: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.begin'
3903: , 'Beginning of mark_event_srp_quotas ...'
3904: );
3905: END IF;

Line 3975: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3971: END IF; -- If (dependent_pe_tbl.count > 0)
3972: END LOOP;
3973: END IF;
3974:
3975: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3976: fnd_log.STRING(
3977: fnd_log.level_procedure
3978: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.end'
3979: , 'End of mark_event_srp_quotas.'

Line 3976: fnd_log.STRING(

3972: END LOOP;
3973: END IF;
3974:
3975: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3976: fnd_log.STRING(
3977: fnd_log.level_procedure
3978: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.end'
3979: , 'End of mark_event_srp_quotas.'
3980: );

Line 3977: fnd_log.level_procedure

3973: END IF;
3974:
3975: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3976: fnd_log.STRING(
3977: fnd_log.level_procedure
3978: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.end'
3979: , 'End of mark_event_srp_quotas.'
3980: );
3981: END IF;

Line 3984: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

3980: );
3981: END IF;
3982: EXCEPTION
3983: WHEN OTHERS THEN
3984: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3985: fnd_log.STRING(
3986: fnd_log.level_unexpected
3987: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.exception'
3988: , SQLERRM

Line 3985: fnd_log.STRING(

3981: END IF;
3982: EXCEPTION
3983: WHEN OTHERS THEN
3984: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3985: fnd_log.STRING(
3986: fnd_log.level_unexpected
3987: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.exception'
3988: , SQLERRM
3989: );

Line 3986: fnd_log.level_unexpected

3982: EXCEPTION
3983: WHEN OTHERS THEN
3984: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3985: fnd_log.STRING(
3986: fnd_log.level_unexpected
3987: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.exception'
3988: , SQLERRM
3989: );
3990: END IF;

Line 4064: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
4065: fnd_log.STRING(
4066: fnd_log.level_procedure
4067: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.begin'
4068: , 'Beginning of mark_event_srp_uplifts ...'

Line 4065: fnd_log.STRING(

4061: RETURN;
4062: END IF;
4063:
4064: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4065: fnd_log.STRING(
4066: fnd_log.level_procedure
4067: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.begin'
4068: , 'Beginning of mark_event_srp_uplifts ...'
4069: );

Line 4066: fnd_log.level_procedure

4062: END IF;
4063:
4064: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4065: fnd_log.STRING(
4066: fnd_log.level_procedure
4067: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.begin'
4068: , 'Beginning of mark_event_srp_uplifts ...'
4069: );
4070: END IF;

Line 4142: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4138: END IF; -- If (dependent_pe_tbl.count > 0)
4139: END LOOP;
4140: END IF;
4141:
4142: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4143: fnd_log.STRING(
4144: fnd_log.level_procedure
4145: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.end'
4146: , 'End of mark_event_srp_uplifts.'

Line 4143: fnd_log.STRING(

4139: END LOOP;
4140: END IF;
4141:
4142: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4143: fnd_log.STRING(
4144: fnd_log.level_procedure
4145: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.end'
4146: , 'End of mark_event_srp_uplifts.'
4147: );

Line 4144: fnd_log.level_procedure

4140: END IF;
4141:
4142: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4143: fnd_log.STRING(
4144: fnd_log.level_procedure
4145: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.end'
4146: , 'End of mark_event_srp_uplifts.'
4147: );
4148: END IF;

Line 4151: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4147: );
4148: END IF;
4149: EXCEPTION
4150: WHEN OTHERS THEN
4151: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4152: fnd_log.STRING(
4153: fnd_log.level_unexpected
4154: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.exception'
4155: , SQLERRM

Line 4152: fnd_log.STRING(

4148: END IF;
4149: EXCEPTION
4150: WHEN OTHERS THEN
4151: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4152: fnd_log.STRING(
4153: fnd_log.level_unexpected
4154: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.exception'
4155: , SQLERRM
4156: );

Line 4153: fnd_log.level_unexpected

4149: EXCEPTION
4150: WHEN OTHERS THEN
4151: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4152: fnd_log.STRING(
4153: fnd_log.level_unexpected
4154: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.exception'
4155: , SQLERRM
4156: );
4157: END IF;

Line 4226: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
4227: fnd_log.STRING(
4228: fnd_log.level_procedure
4229: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.begin'
4230: , 'Beginning of mark_event_srp_rate_assigns ...'

Line 4227: fnd_log.STRING(

4223: RETURN;
4224: END IF;
4225:
4226: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4227: fnd_log.STRING(
4228: fnd_log.level_procedure
4229: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.begin'
4230: , 'Beginning of mark_event_srp_rate_assigns ...'
4231: );

Line 4228: fnd_log.level_procedure

4224: END IF;
4225:
4226: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4227: fnd_log.STRING(
4228: fnd_log.level_procedure
4229: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.begin'
4230: , 'Beginning of mark_event_srp_rate_assigns ...'
4231: );
4232: END IF;

Line 4299: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4295: END IF; -- If (dependent_pe_tbl.count > 0)
4296: END LOOP;
4297: END IF;
4298:
4299: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4300: fnd_log.STRING(
4301: fnd_log.level_procedure
4302: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.end'
4303: , 'End of mark_event_srp_rate_assigns.'

Line 4300: fnd_log.STRING(

4296: END LOOP;
4297: END IF;
4298:
4299: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4300: fnd_log.STRING(
4301: fnd_log.level_procedure
4302: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.end'
4303: , 'End of mark_event_srp_rate_assigns.'
4304: );

Line 4301: fnd_log.level_procedure

4297: END IF;
4298:
4299: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4300: fnd_log.STRING(
4301: fnd_log.level_procedure
4302: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.end'
4303: , 'End of mark_event_srp_rate_assigns.'
4304: );
4305: END IF;

Line 4308: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4304: );
4305: END IF;
4306: EXCEPTION
4307: WHEN OTHERS THEN
4308: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4309: fnd_log.STRING(
4310: fnd_log.level_unexpected
4311: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.exception'
4312: , SQLERRM

Line 4309: fnd_log.STRING(

4305: END IF;
4306: EXCEPTION
4307: WHEN OTHERS THEN
4308: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4309: fnd_log.STRING(
4310: fnd_log.level_unexpected
4311: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.exception'
4312: , SQLERRM
4313: );

Line 4310: fnd_log.level_unexpected

4306: EXCEPTION
4307: WHEN OTHERS THEN
4308: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4309: fnd_log.STRING(
4310: fnd_log.level_unexpected
4311: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.exception'
4312: , SQLERRM
4313: );
4314: END IF;

Line 4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
4370: fnd_log.STRING(
4371: fnd_log.level_procedure
4372: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4373: , 'Beginning of mark_event_srp_period_quota ...'

Line 4370: fnd_log.STRING(

4366: RETURN;
4367: END IF;
4368:
4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4370: fnd_log.STRING(
4371: fnd_log.level_procedure
4372: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4373: , 'Beginning of mark_event_srp_period_quota ...'
4374: );

Line 4371: fnd_log.level_procedure

4367: END IF;
4368:
4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4370: fnd_log.STRING(
4371: fnd_log.level_procedure
4372: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4373: , 'Beginning of mark_event_srp_period_quota ...'
4374: );
4375: END IF;

Line 4439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4435: END IF; -- If (dependent_pe_tbl.count > 0)
4436: END LOOP;
4437: END IF;
4438:
4439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4440: fnd_log.STRING(
4441: fnd_log.level_procedure
4442: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4443: , 'End of mark_event_srp_period_quota.'

Line 4440: fnd_log.STRING(

4436: END LOOP;
4437: END IF;
4438:
4439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4440: fnd_log.STRING(
4441: fnd_log.level_procedure
4442: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4443: , 'End of mark_event_srp_period_quota.'
4444: );

Line 4441: fnd_log.level_procedure

4437: END IF;
4438:
4439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4440: fnd_log.STRING(
4441: fnd_log.level_procedure
4442: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4443: , 'End of mark_event_srp_period_quota.'
4444: );
4445: END IF;

Line 4448: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4444: );
4445: END IF;
4446: EXCEPTION
4447: WHEN OTHERS THEN
4448: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4449: fnd_log.STRING(
4450: fnd_log.level_unexpected
4451: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4452: , SQLERRM

Line 4449: fnd_log.STRING(

4445: END IF;
4446: EXCEPTION
4447: WHEN OTHERS THEN
4448: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4449: fnd_log.STRING(
4450: fnd_log.level_unexpected
4451: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4452: , SQLERRM
4453: );

Line 4450: fnd_log.level_unexpected

4446: EXCEPTION
4447: WHEN OTHERS THEN
4448: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4449: fnd_log.STRING(
4450: fnd_log.level_unexpected
4451: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4452: , SQLERRM
4453: );
4454: END IF;

Line 4488: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
4489: fnd_log.STRING(
4490: fnd_log.level_procedure
4491: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4492: , 'Beginning of mark_event_srp_period_quota ...'

Line 4489: fnd_log.STRING(

4485: RETURN;
4486: END IF;
4487:
4488: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4489: fnd_log.STRING(
4490: fnd_log.level_procedure
4491: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4492: , 'Beginning of mark_event_srp_period_quota ...'
4493: );

Line 4490: fnd_log.level_procedure

4486: END IF;
4487:
4488: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4489: fnd_log.STRING(
4490: fnd_log.level_procedure
4491: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4492: , 'Beginning of mark_event_srp_period_quota ...'
4493: );
4494: END IF;

Line 4572: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4568: END LOOP;
4569: END IF; -- If (dependent_pe_tbl.count > 0)
4570: END IF;
4571:
4572: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4573: fnd_log.STRING(
4574: fnd_log.level_procedure
4575: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4576: , 'End of mark_event_srp_period_quota.'

Line 4573: fnd_log.STRING(

4569: END IF; -- If (dependent_pe_tbl.count > 0)
4570: END IF;
4571:
4572: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4573: fnd_log.STRING(
4574: fnd_log.level_procedure
4575: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4576: , 'End of mark_event_srp_period_quota.'
4577: );

Line 4574: fnd_log.level_procedure

4570: END IF;
4571:
4572: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4573: fnd_log.STRING(
4574: fnd_log.level_procedure
4575: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4576: , 'End of mark_event_srp_period_quota.'
4577: );
4578: END IF;

Line 4581: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4577: );
4578: END IF;
4579: EXCEPTION
4580: WHEN OTHERS THEN
4581: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4582: fnd_log.STRING(
4583: fnd_log.level_unexpected
4584: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4585: , SQLERRM

Line 4582: fnd_log.STRING(

4578: END IF;
4579: EXCEPTION
4580: WHEN OTHERS THEN
4581: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4582: fnd_log.STRING(
4583: fnd_log.level_unexpected
4584: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4585: , SQLERRM
4586: );

Line 4583: fnd_log.level_unexpected

4579: EXCEPTION
4580: WHEN OTHERS THEN
4581: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4582: fnd_log.STRING(
4583: fnd_log.level_unexpected
4584: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4585: , SQLERRM
4586: );
4587: END IF;

Line 4661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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
4662: fnd_log.STRING(
4663: fnd_log.level_procedure
4664: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assigns.begin'
4665: , 'Beginning of mark_event_srp_payee_assigns ...'

Line 4662: fnd_log.STRING(

4658: RETURN;
4659: END IF;
4660:
4661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4662: fnd_log.STRING(
4663: fnd_log.level_procedure
4664: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assigns.begin'
4665: , 'Beginning of mark_event_srp_payee_assigns ...'
4666: );

Line 4663: fnd_log.level_procedure

4659: END IF;
4660:
4661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4662: fnd_log.STRING(
4663: fnd_log.level_procedure
4664: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assigns.begin'
4665: , 'Beginning of mark_event_srp_payee_assigns ...'
4666: );
4667: END IF;

Line 4818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4814: END LOOP;
4815: END LOOP;
4816: END IF;
4817:
4818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4819: fnd_log.STRING(
4820: fnd_log.level_procedure
4821: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_assign.end'
4822: , 'End of mark_event_srp_payee_assign.'

Line 4819: fnd_log.STRING(

4815: END LOOP;
4816: END IF;
4817:
4818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4819: fnd_log.STRING(
4820: fnd_log.level_procedure
4821: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_assign.end'
4822: , 'End of mark_event_srp_payee_assign.'
4823: );

Line 4820: fnd_log.level_procedure

4816: END IF;
4817:
4818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4819: fnd_log.STRING(
4820: fnd_log.level_procedure
4821: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_assign.end'
4822: , 'End of mark_event_srp_payee_assign.'
4823: );
4824: END IF;

Line 4827: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4823: );
4824: END IF;
4825: EXCEPTION
4826: WHEN OTHERS THEN
4827: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4828: fnd_log.STRING(
4829: fnd_log.level_unexpected
4830: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assign.exception'
4831: , SQLERRM

Line 4828: fnd_log.STRING(

4824: END IF;
4825: EXCEPTION
4826: WHEN OTHERS THEN
4827: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4828: fnd_log.STRING(
4829: fnd_log.level_unexpected
4830: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assign.exception'
4831: , SQLERRM
4832: );

Line 4829: fnd_log.level_unexpected

4825: EXCEPTION
4826: WHEN OTHERS THEN
4827: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4828: fnd_log.STRING(
4829: fnd_log.level_unexpected
4830: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assign.exception'
4831: , SQLERRM
4832: );
4833: END IF;

Line 4887: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4883: AND p.org_id = p_org_id
4884: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
4885: AND (p.end_date >= p_start_date);
4886: BEGIN
4887: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4888: fnd_log.STRING(
4889: fnd_log.level_procedure
4890: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.begin'
4891: , 'Beginning of mark_notify_team ...'

Line 4888: fnd_log.STRING(

4884: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
4885: AND (p.end_date >= p_start_date);
4886: BEGIN
4887: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4888: fnd_log.STRING(
4889: fnd_log.level_procedure
4890: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.begin'
4891: , 'Beginning of mark_notify_team ...'
4892: );

Line 4889: fnd_log.level_procedure

4885: AND (p.end_date >= p_start_date);
4886: BEGIN
4887: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4888: fnd_log.STRING(
4889: fnd_log.level_procedure
4890: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.begin'
4891: , 'Beginning of mark_notify_team ...'
4892: );
4893: END IF;

Line 4960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

4956: );
4957: END LOOP;
4958: END LOOP;
4959:
4960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4961: fnd_log.STRING(
4962: fnd_log.level_procedure
4963: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.end'
4964: , 'End of mark_notify_team.'

Line 4961: fnd_log.STRING(

4957: END LOOP;
4958: END LOOP;
4959:
4960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4961: fnd_log.STRING(
4962: fnd_log.level_procedure
4963: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.end'
4964: , 'End of mark_notify_team.'
4965: );

Line 4962: fnd_log.level_procedure

4958: END LOOP;
4959:
4960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4961: fnd_log.STRING(
4962: fnd_log.level_procedure
4963: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.end'
4964: , 'End of mark_notify_team.'
4965: );
4966: END IF;

Line 4969: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN

4965: );
4966: END IF;
4967: EXCEPTION
4968: WHEN OTHERS THEN
4969: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4970: fnd_log.STRING(
4971: fnd_log.level_unexpected
4972: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.exception'
4973: , SQLERRM

Line 4970: fnd_log.STRING(

4966: END IF;
4967: EXCEPTION
4968: WHEN OTHERS THEN
4969: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4970: fnd_log.STRING(
4971: fnd_log.level_unexpected
4972: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.exception'
4973: , SQLERRM
4974: );

Line 4971: fnd_log.level_unexpected

4967: EXCEPTION
4968: WHEN OTHERS THEN
4969: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4970: fnd_log.STRING(
4971: fnd_log.level_unexpected
4972: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.exception'
4973: , SQLERRM
4974: );
4975: END IF;