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 2134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

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

Line 2135: fnd_log.STRING(

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

Line 2136: fnd_log.level_procedure

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

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

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

Line 2144: fnd_log.STRING(

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

Line 2145: fnd_log.level_unexpected

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

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

2230: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2231: RETURN;
2232: END IF;
2233:
2234: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2235: fnd_log.STRING(
2236: fnd_log.level_procedure
2237: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.begin'
2238: , 'Beginning of mark_event_rt_quota ...'

Line 2235: fnd_log.STRING(

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

Line 2236: fnd_log.level_procedure

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

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

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

Line 2365: fnd_log.STRING(

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

Line 2366: fnd_log.level_procedure

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

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

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

Line 2374: fnd_log.STRING(

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

Line 2375: fnd_log.level_unexpected

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

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

2467: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2468: RETURN;
2469: END IF;
2470:
2471: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2472: fnd_log.STRING(
2473: fnd_log.level_procedure
2474: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.begin'
2475: , 'Beginning of mark_event_trx_factor ...'

Line 2472: fnd_log.STRING(

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

Line 2473: fnd_log.level_procedure

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

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

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

Line 2560: fnd_log.STRING(

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

Line 2561: fnd_log.level_procedure

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

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

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

Line 2569: fnd_log.STRING(

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

Line 2570: fnd_log.level_unexpected

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

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

2626: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2627: RETURN;
2628: END IF;
2629:
2630: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2631: fnd_log.STRING(
2632: fnd_log.level_procedure
2633: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.begin'
2634: , 'Beginning of mark_event_role_plans ...'

Line 2631: fnd_log.STRING(

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

Line 2632: fnd_log.level_procedure

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

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

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

Line 2698: fnd_log.STRING(

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

Line 2699: fnd_log.level_procedure

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

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

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

Line 2707: fnd_log.STRING(

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

Line 2708: fnd_log.level_unexpected

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

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

2761: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2762: RETURN;
2763: END IF;
2764:
2765: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2766: fnd_log.STRING(
2767: fnd_log.level_procedure
2768: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.begin'
2769: , 'Beginning of mark_event_spr_pay_group ...'

Line 2766: fnd_log.STRING(

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

Line 2767: fnd_log.level_procedure

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

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

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

Line 2833: fnd_log.STRING(

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

Line 2834: fnd_log.level_procedure

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

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

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

Line 2842: fnd_log.STRING(

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

Line 2843: fnd_log.level_unexpected

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

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

2895: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
2896: RETURN;
2897: END IF;
2898:
2899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2900: fnd_log.STRING(
2901: fnd_log.level_procedure
2902: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.begin'
2903: , 'Beginning of mark_event_srp_roles ...'

Line 2900: fnd_log.STRING(

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

Line 2901: fnd_log.level_procedure

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

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

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

Line 2970: fnd_log.STRING(

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

Line 2971: fnd_log.level_procedure

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

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

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

Line 2979: fnd_log.STRING(

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

Line 2980: fnd_log.level_unexpected

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

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

3040: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3041: RETURN;
3042: END IF;
3043:
3044: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3045: fnd_log.STRING(
3046: fnd_log.level_procedure
3047: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.begin'
3048: , 'Beginning of mark_event_formula ...'

Line 3045: fnd_log.STRING(

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

Line 3046: fnd_log.level_procedure

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

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

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

Line 3121: fnd_log.STRING(

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

Line 3122: fnd_log.level_procedure

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

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

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

Line 3130: fnd_log.STRING(

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

Line 3131: fnd_log.level_unexpected

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

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

3194: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3195: RETURN;
3196: END IF;
3197:
3198: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3199: fnd_log.STRING(
3200: fnd_log.level_procedure
3201: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.begin'
3202: , 'Beginning of mark_event_rate_table ...'

Line 3199: fnd_log.STRING(

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

Line 3200: fnd_log.level_procedure

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

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

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

Line 3275: fnd_log.STRING(

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

Line 3276: fnd_log.level_procedure

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

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

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

Line 3284: fnd_log.STRING(

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

Line 3285: fnd_log.level_unexpected

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

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

3350: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3351: RETURN;
3352: END IF;
3353:
3354: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3355: fnd_log.STRING(
3356: fnd_log.level_procedure
3357: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.begin'
3358: , 'Beginning of mark_event_rate_tier_table...'

Line 3355: fnd_log.STRING(

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

Line 3356: fnd_log.level_procedure

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

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

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

Line 3430: fnd_log.STRING(

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

Line 3431: fnd_log.level_procedure

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

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

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

Line 3439: fnd_log.STRING(

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

Line 3440: fnd_log.level_unexpected

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

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

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

Line 3493: fnd_log.STRING(

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

Line 3494: fnd_log.level_procedure

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

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

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

Line 3559: fnd_log.STRING(

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

Line 3560: fnd_log.level_procedure

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

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

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

Line 3568: fnd_log.STRING(

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

Line 3569: fnd_log.level_unexpected

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

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

3612: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3613: RETURN;
3614: END IF;
3615:
3616: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3617: fnd_log.STRING(
3618: fnd_log.level_procedure
3619: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.begin'
3620: , 'Beginning of mark_event_interval_number ...'

Line 3617: fnd_log.STRING(

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

Line 3618: fnd_log.level_procedure

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

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

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

Line 3650: fnd_log.STRING(

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

Line 3651: fnd_log.level_procedure

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

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

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

Line 3659: fnd_log.STRING(

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

Line 3660: fnd_log.level_unexpected

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

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

3781: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3782: RETURN;
3783: END IF;
3784:
3785: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3786: fnd_log.STRING(
3787: fnd_log.level_procedure
3788: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.begin'
3789: , 'Beginning of mark_event_comp_plan ...'

Line 3786: fnd_log.STRING(

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

Line 3787: fnd_log.level_procedure

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

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

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

Line 3824: fnd_log.STRING(

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

Line 3825: fnd_log.level_procedure

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

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

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

Line 3833: fnd_log.STRING(

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

Line 3834: fnd_log.level_unexpected

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

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

3891: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
3892: RETURN;
3893: END IF;
3894:
3895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3896: fnd_log.STRING(
3897: fnd_log.level_procedure
3898: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.begin'
3899: , 'Beginning of mark_event_srp_quotas ...'

Line 3896: fnd_log.STRING(

3892: RETURN;
3893: END IF;
3894:
3895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3896: fnd_log.STRING(
3897: fnd_log.level_procedure
3898: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.begin'
3899: , 'Beginning of mark_event_srp_quotas ...'
3900: );

Line 3897: fnd_log.level_procedure

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

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

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

Line 3972: fnd_log.STRING(

3968: END LOOP;
3969: END IF;
3970:
3971: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3972: fnd_log.STRING(
3973: fnd_log.level_procedure
3974: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.end'
3975: , 'End of mark_event_srp_quotas.'
3976: );

Line 3973: fnd_log.level_procedure

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

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

3976: );
3977: END IF;
3978: EXCEPTION
3979: WHEN OTHERS THEN
3980: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3981: fnd_log.STRING(
3982: fnd_log.level_unexpected
3983: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.exception'
3984: , SQLERRM

Line 3981: fnd_log.STRING(

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

Line 3982: fnd_log.level_unexpected

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

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

4056: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4057: RETURN;
4058: END IF;
4059:
4060: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4061: fnd_log.STRING(
4062: fnd_log.level_procedure
4063: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.begin'
4064: , 'Beginning of mark_event_srp_uplifts ...'

Line 4061: fnd_log.STRING(

4057: RETURN;
4058: END IF;
4059:
4060: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4061: fnd_log.STRING(
4062: fnd_log.level_procedure
4063: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.begin'
4064: , 'Beginning of mark_event_srp_uplifts ...'
4065: );

Line 4062: fnd_log.level_procedure

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

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

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

Line 4139: fnd_log.STRING(

4135: END LOOP;
4136: END IF;
4137:
4138: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4139: fnd_log.STRING(
4140: fnd_log.level_procedure
4141: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.end'
4142: , 'End of mark_event_srp_uplifts.'
4143: );

Line 4140: fnd_log.level_procedure

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

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

4143: );
4144: END IF;
4145: EXCEPTION
4146: WHEN OTHERS THEN
4147: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4148: fnd_log.STRING(
4149: fnd_log.level_unexpected
4150: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.exception'
4151: , SQLERRM

Line 4148: fnd_log.STRING(

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

Line 4149: fnd_log.level_unexpected

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

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

4218: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4219: RETURN;
4220: END IF;
4221:
4222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4223: fnd_log.STRING(
4224: fnd_log.level_procedure
4225: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.begin'
4226: , 'Beginning of mark_event_srp_rate_assigns ...'

Line 4223: fnd_log.STRING(

4219: RETURN;
4220: END IF;
4221:
4222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4223: fnd_log.STRING(
4224: fnd_log.level_procedure
4225: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.begin'
4226: , 'Beginning of mark_event_srp_rate_assigns ...'
4227: );

Line 4224: fnd_log.level_procedure

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

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

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

Line 4296: fnd_log.STRING(

4292: END LOOP;
4293: END IF;
4294:
4295: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4296: fnd_log.STRING(
4297: fnd_log.level_procedure
4298: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.end'
4299: , 'End of mark_event_srp_rate_assigns.'
4300: );

Line 4297: fnd_log.level_procedure

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

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

4300: );
4301: END IF;
4302: EXCEPTION
4303: WHEN OTHERS THEN
4304: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4305: fnd_log.STRING(
4306: fnd_log.level_unexpected
4307: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.exception'
4308: , SQLERRM

Line 4305: fnd_log.STRING(

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

Line 4306: fnd_log.level_unexpected

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

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

4360: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4361: RETURN;
4362: END IF;
4363:
4364: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4365: fnd_log.STRING(
4366: fnd_log.level_procedure
4367: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4368: , 'Beginning of mark_event_srp_period_quota ...'

Line 4365: fnd_log.STRING(

4361: RETURN;
4362: END IF;
4363:
4364: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4365: fnd_log.STRING(
4366: fnd_log.level_procedure
4367: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4368: , 'Beginning of mark_event_srp_period_quota ...'
4369: );

Line 4366: fnd_log.level_procedure

4362: END IF;
4363:
4364: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4365: fnd_log.STRING(
4366: fnd_log.level_procedure
4367: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4368: , 'Beginning of mark_event_srp_period_quota ...'
4369: );
4370: END IF;

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

4430: END IF; -- If (dependent_pe_tbl.count > 0)
4431: END LOOP;
4432: END IF;
4433:
4434: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4435: fnd_log.STRING(
4436: fnd_log.level_procedure
4437: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4438: , 'End of mark_event_srp_period_quota.'

Line 4435: fnd_log.STRING(

4431: END LOOP;
4432: END IF;
4433:
4434: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4435: fnd_log.STRING(
4436: fnd_log.level_procedure
4437: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4438: , 'End of mark_event_srp_period_quota.'
4439: );

Line 4436: fnd_log.level_procedure

4432: END IF;
4433:
4434: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4435: fnd_log.STRING(
4436: fnd_log.level_procedure
4437: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4438: , 'End of mark_event_srp_period_quota.'
4439: );
4440: END IF;

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

4439: );
4440: END IF;
4441: EXCEPTION
4442: WHEN OTHERS THEN
4443: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4444: fnd_log.STRING(
4445: fnd_log.level_unexpected
4446: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4447: , SQLERRM

Line 4444: fnd_log.STRING(

4440: END IF;
4441: EXCEPTION
4442: WHEN OTHERS THEN
4443: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4444: fnd_log.STRING(
4445: fnd_log.level_unexpected
4446: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4447: , SQLERRM
4448: );

Line 4445: fnd_log.level_unexpected

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

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

4479: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4480: RETURN;
4481: END IF;
4482:
4483: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4484: fnd_log.STRING(
4485: fnd_log.level_procedure
4486: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4487: , 'Beginning of mark_event_srp_period_quota ...'

Line 4484: fnd_log.STRING(

4480: RETURN;
4481: END IF;
4482:
4483: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4484: fnd_log.STRING(
4485: fnd_log.level_procedure
4486: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4487: , 'Beginning of mark_event_srp_period_quota ...'
4488: );

Line 4485: fnd_log.level_procedure

4481: END IF;
4482:
4483: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4484: fnd_log.STRING(
4485: fnd_log.level_procedure
4486: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4487: , 'Beginning of mark_event_srp_period_quota ...'
4488: );
4489: END IF;

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

4563: END LOOP;
4564: END IF; -- If (dependent_pe_tbl.count > 0)
4565: END IF;
4566:
4567: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4568: fnd_log.STRING(
4569: fnd_log.level_procedure
4570: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4571: , 'End of mark_event_srp_period_quota.'

Line 4568: fnd_log.STRING(

4564: END IF; -- If (dependent_pe_tbl.count > 0)
4565: END IF;
4566:
4567: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4568: fnd_log.STRING(
4569: fnd_log.level_procedure
4570: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4571: , 'End of mark_event_srp_period_quota.'
4572: );

Line 4569: fnd_log.level_procedure

4565: END IF;
4566:
4567: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4568: fnd_log.STRING(
4569: fnd_log.level_procedure
4570: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4571: , 'End of mark_event_srp_period_quota.'
4572: );
4573: END IF;

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

4572: );
4573: END IF;
4574: EXCEPTION
4575: WHEN OTHERS THEN
4576: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4577: fnd_log.STRING(
4578: fnd_log.level_unexpected
4579: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4580: , SQLERRM

Line 4577: fnd_log.STRING(

4573: END IF;
4574: EXCEPTION
4575: WHEN OTHERS THEN
4576: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4577: fnd_log.STRING(
4578: fnd_log.level_unexpected
4579: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4580: , SQLERRM
4581: );

Line 4578: fnd_log.level_unexpected

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

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

4652: IF fnd_profile.VALUE('CN_MARK_EVENTS') <> 'Y' THEN
4653: RETURN;
4654: END IF;
4655:
4656: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4657: fnd_log.STRING(
4658: fnd_log.level_procedure
4659: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assigns.begin'
4660: , 'Beginning of mark_event_srp_payee_assigns ...'

Line 4657: fnd_log.STRING(

4653: RETURN;
4654: END IF;
4655:
4656: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4657: fnd_log.STRING(
4658: fnd_log.level_procedure
4659: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assigns.begin'
4660: , 'Beginning of mark_event_srp_payee_assigns ...'
4661: );

Line 4658: fnd_log.level_procedure

4654: END IF;
4655:
4656: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4657: fnd_log.STRING(
4658: fnd_log.level_procedure
4659: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assigns.begin'
4660: , 'Beginning of mark_event_srp_payee_assigns ...'
4661: );
4662: END IF;

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

4809: END LOOP;
4810: END LOOP;
4811: END IF;
4812:
4813: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4814: fnd_log.STRING(
4815: fnd_log.level_procedure
4816: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_assign.end'
4817: , 'End of mark_event_srp_payee_assign.'

Line 4814: fnd_log.STRING(

4810: END LOOP;
4811: END IF;
4812:
4813: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4814: fnd_log.STRING(
4815: fnd_log.level_procedure
4816: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_assign.end'
4817: , 'End of mark_event_srp_payee_assign.'
4818: );

Line 4815: fnd_log.level_procedure

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

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

4818: );
4819: END IF;
4820: EXCEPTION
4821: WHEN OTHERS THEN
4822: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4823: fnd_log.STRING(
4824: fnd_log.level_unexpected
4825: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assign.exception'
4826: , SQLERRM

Line 4823: fnd_log.STRING(

4819: END IF;
4820: EXCEPTION
4821: WHEN OTHERS THEN
4822: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4823: fnd_log.STRING(
4824: fnd_log.level_unexpected
4825: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assign.exception'
4826: , SQLERRM
4827: );

Line 4824: fnd_log.level_unexpected

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

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

4878: AND p.org_id = p_org_id
4879: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
4880: AND (p.end_date >= p_start_date);
4881: BEGIN
4882: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4883: fnd_log.STRING(
4884: fnd_log.level_procedure
4885: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.begin'
4886: , 'Beginning of mark_notify_team ...'

Line 4883: fnd_log.STRING(

4879: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
4880: AND (p.end_date >= p_start_date);
4881: BEGIN
4882: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4883: fnd_log.STRING(
4884: fnd_log.level_procedure
4885: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.begin'
4886: , 'Beginning of mark_notify_team ...'
4887: );

Line 4884: fnd_log.level_procedure

4880: AND (p.end_date >= p_start_date);
4881: BEGIN
4882: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4883: fnd_log.STRING(
4884: fnd_log.level_procedure
4885: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.begin'
4886: , 'Beginning of mark_notify_team ...'
4887: );
4888: END IF;

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

4951: );
4952: END LOOP;
4953: END LOOP;
4954:
4955: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4956: fnd_log.STRING(
4957: fnd_log.level_procedure
4958: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.end'
4959: , 'End of mark_notify_team.'

Line 4956: fnd_log.STRING(

4952: END LOOP;
4953: END LOOP;
4954:
4955: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4956: fnd_log.STRING(
4957: fnd_log.level_procedure
4958: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.end'
4959: , 'End of mark_notify_team.'
4960: );

Line 4957: fnd_log.level_procedure

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

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

4960: );
4961: END IF;
4962: EXCEPTION
4963: WHEN OTHERS THEN
4964: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4965: fnd_log.STRING(
4966: fnd_log.level_unexpected
4967: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.exception'
4968: , SQLERRM

Line 4965: fnd_log.STRING(

4961: END IF;
4962: EXCEPTION
4963: WHEN OTHERS THEN
4964: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4965: fnd_log.STRING(
4966: fnd_log.level_unexpected
4967: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.exception'
4968: , SQLERRM
4969: );

Line 4966: fnd_log.level_unexpected

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