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 CN_MARK_EVENTS_PKG

Line 1: PACKAGE BODY cn_mark_events_pkg AS

1: PACKAGE BODY cn_mark_events_pkg AS
2: -- $Header: cneventb.pls 120.7.12010000.4 2008/12/02 08:13:40 venjayar ship $
3:
4: -- forward declaration
5: PROCEDURE mark_subsequent_periods(

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 216: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.begin'

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;
220:

Line 503: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.end'

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;
507: EXCEPTION

Line 544: , 'cn.plsql.cn_mark_events_pkg.mark_notify_real.exception'

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;
548:

Line 672: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.begin'

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;
676:

Line 732: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.end'

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;
736: EXCEPTION

Line 741: , 'cn.plsql.cn_mark_events_pkg.mark_subsequent_periods.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;
745:

Line 898: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.begin'

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;
902:

Line 1027: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.end'

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;
1031: EXCEPTION

Line 1036: , 'cn.plsql.cn_mark_events_pkg.mark_notify_salesreps.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;
1040:

Line 1068: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.begin'

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;
1072:

Line 1108: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.end'

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;
1112: EXCEPTION

Line 1117: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.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;
1121:

Line 1200: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.begin'

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;
1204:

Line 1240: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.end'

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;
1244: EXCEPTION

Line 1249: , 'cn.plsql.cn_mark_events_pkg.mark_notify_dates.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;
1253:

Line 1311: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.begin'

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;
1315:

Line 1371: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.end'

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;
1375: EXCEPTION

Line 1380: , 'cn.plsql.cn_mark_events_pkg.mark_event_sys_para.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;
1384:

Line 1430: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.begin'

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;
1434:

Line 1467: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.end'

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;
1471: EXCEPTION

Line 1476: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_rule.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;
1480:

Line 1563: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.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;
1567:

Line 1600: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.end'

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;
1604: END IF;

Line 1610: , 'cn.plsql.cn_mark_events_pkg.mark_event_rc_hier.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;
1614:

Line 1679: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.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;
1683:

Line 1756: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.end'

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;
1760: END IF;

Line 1766: , 'cn.plsql.cn_mark_events_pkg.mark_event_cls_hier.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;
1770:

Line 1892: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.begin'

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;
1896:

Line 1897: cn_mark_events_pkg.log_event(

1893: , 'Beginning of mark_event_quota ...'
1894: );
1895: END IF;
1896:
1897: cn_mark_events_pkg.log_event(
1898: p_event_name => p_event_name
1899: , p_object_name => p_object_name
1900: , p_object_id => p_object_id
1901: , p_start_date => p_start_date

Line 1938: cn_mark_events_pkg.mark_notify(

1934: , l_start_date, l_end_date) LOOP
1935: -- modified by rjin 11/10/1999
1936: -- since all affected period (including subsequent periods)
1937: -- are garaunteed to be marked, so we only need to mark 'NEW'
1938: cn_mark_events_pkg.mark_notify(
1939: p_salesrep_id => affected_recs.salesrep_id
1940: , p_period_id => affected_recs.period_id
1941: , p_start_date => NULL
1942: , p_end_date => NULL

Line 1956: cn_mark_events_pkg.mark_notify(

1952: OPEN l_pe_cursor(affected_recs.salesrep_id, affected_recs.period_id, dependent_pe_tbl(i));
1953: FETCH l_pe_cursor INTO temp_quota_id;
1954:
1955: IF l_pe_cursor%FOUND THEN
1956: cn_mark_events_pkg.mark_notify(
1957: p_salesrep_id => affected_recs.salesrep_id
1958: , p_period_id => affected_recs.period_id
1959: , p_start_date => NULL
1960: , p_end_date => NULL

Line 1993: cn_mark_events_pkg.mark_notify(

1989: , l_end_period_id
1990: , l_date_range_rec_tbl(i).start_date
1991: , l_date_range_rec_tbl(i).end_date
1992: ) LOOP
1993: cn_mark_events_pkg.mark_notify(
1994: p_salesrep_id => affected_period_recs.salesrep_id
1995: , p_period_id => affected_period_recs.period_id
1996: , p_start_date => affected_period_recs.start_date
1997: , p_end_date => affected_period_recs.end_date

Line 2021: cn_mark_events_pkg.mark_notify(

2017: , l_start_date, l_end_date) LOOP
2018: -- modified by rjin 11/10/1999
2019: -- since all affected period (including subsequent periods)
2020: -- are garaunteed to be marked, so we only need to mark 'NEW'
2021: cn_mark_events_pkg.mark_notify(
2022: p_salesrep_id => affected_recs.salesrep_id
2023: , p_period_id => affected_recs.period_id
2024: , p_start_date => affected_recs.start_date
2025: , p_end_date => affected_recs.end_date

Line 2042: cn_mark_events_pkg.mark_notify(

2038: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2039:
2040: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id
2041: , p_start_date_old, p_end_date_old) LOOP
2042: cn_mark_events_pkg.mark_notify(
2043: p_salesrep_id => affected_recs.salesrep_id
2044: , p_period_id => affected_recs.period_id
2045: , p_start_date => affected_recs.start_date
2046: , p_end_date => affected_recs.end_date

Line 2059: cn_mark_events_pkg.mark_notify(

2055: OPEN l_pe_cursor(affected_recs.salesrep_id, affected_recs.period_id, dependent_pe_tbl(i));
2056: FETCH l_pe_cursor INTO temp_quota_id;
2057:
2058: IF l_pe_cursor%FOUND THEN
2059: cn_mark_events_pkg.mark_notify(
2060: p_salesrep_id => affected_recs.salesrep_id
2061: , p_period_id => affected_recs.period_id
2062: , p_start_date => affected_recs.start_date
2063: , p_end_date => affected_recs.end_date

Line 2098: cn_mark_events_pkg.mark_notify(

2094: , l_end_period_id
2095: , l_date_range_rec_tbl(i).start_date
2096: , l_date_range_rec_tbl(i).end_date
2097: ) LOOP
2098: cn_mark_events_pkg.mark_notify(
2099: p_salesrep_id => affected_period_recs.salesrep_id
2100: , p_period_id => affected_period_recs.period_id
2101: , p_start_date => affected_period_recs.start_date
2102: , p_end_date => affected_period_recs.end_date

Line 2115: cn_mark_events_pkg.mark_notify(

2111: OPEN l_pe_cursor(affected_period_recs.salesrep_id, affected_period_recs.period_id, dependent_pe_tbl(i));
2112: FETCH l_pe_cursor INTO temp_quota_id;
2113:
2114: IF l_pe_cursor%FOUND THEN
2115: cn_mark_events_pkg.mark_notify(
2116: p_salesrep_id => affected_period_recs.salesrep_id
2117: , p_period_id => affected_period_recs.period_id
2118: , p_start_date => affected_period_recs.start_date
2119: , p_end_date => affected_period_recs.end_date

Line 2137: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.end'

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;
2141: EXCEPTION

Line 2146: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.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;
2150:

Line 2237: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.begin'

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;
2241:

Line 2242: cn_mark_events_pkg.log_event(

2238: , 'Beginning of mark_event_rt_quota ...'
2239: );
2240: END IF;
2241:
2242: cn_mark_events_pkg.log_event(
2243: p_event_name => p_event_name
2244: , p_object_name => p_object_name
2245: , p_object_id => p_object_id
2246: , p_start_date => p_start_date

Line 2277: cn_mark_events_pkg.mark_notify(

2273: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2274: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2275:
2276: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id) LOOP
2277: cn_mark_events_pkg.mark_notify(
2278: p_salesrep_id => affected_recs.salesrep_id
2279: , p_period_id => affected_recs.period_id
2280: , p_start_date => NULL
2281: , p_end_date => NULL

Line 2294: cn_mark_events_pkg.mark_notify(

2290: OPEN l_pe_cursor(affected_recs.salesrep_id, affected_recs.period_id, dependent_pe_tbl(i));
2291: FETCH l_pe_cursor INTO temp_quota_id;
2292:
2293: IF l_pe_cursor%FOUND THEN
2294: cn_mark_events_pkg.mark_notify(
2295: p_salesrep_id => affected_recs.salesrep_id
2296: , p_period_id => affected_recs.period_id
2297: , p_start_date => NULL
2298: , p_end_date => NULL

Line 2328: cn_mark_events_pkg.mark_notify(

2324: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);
2325: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);
2326:
2327: FOR affected_period_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id) LOOP
2328: cn_mark_events_pkg.mark_notify(
2329: p_salesrep_id => affected_period_recs.salesrep_id
2330: , p_period_id => affected_period_recs.period_id
2331: , p_start_date => NULL
2332: , p_end_date => NULL

Line 2345: cn_mark_events_pkg.mark_notify(

2341: OPEN l_pe_cursor(affected_period_recs.salesrep_id, affected_period_recs.period_id, dependent_pe_tbl(i));
2342: FETCH l_pe_cursor INTO temp_quota_id;
2343:
2344: IF l_pe_cursor%FOUND THEN
2345: cn_mark_events_pkg.mark_notify(
2346: p_salesrep_id => affected_period_recs.salesrep_id
2347: , p_period_id => affected_period_recs.period_id
2348: , p_start_date => NULL
2349: , p_end_date => NULL

Line 2367: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.end'

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;
2371: EXCEPTION

Line 2376: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.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;
2380:

Line 2474: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.begin'

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;
2478:

Line 2479: cn_mark_events_pkg.log_event(

2475: , 'Beginning of mark_event_trx_factor ...'
2476: );
2477: END IF;
2478:
2479: cn_mark_events_pkg.log_event(
2480: p_event_name => p_event_name
2481: , p_object_name => p_object_name
2482: , p_object_id => p_object_id
2483: , p_start_date => p_start_date

Line 2522: cn_mark_events_pkg.mark_notify(

2518: , l_start_date, l_end_date) LOOP
2519: -- modified by rjin 11/10/1999
2520: -- since all affected period (including subsequent periods)
2521: -- are garaunteed to be marked, so we only need to mark 'NEW'
2522: cn_mark_events_pkg.mark_notify(
2523: p_salesrep_id => affected_recs.salesrep_id
2524: , p_period_id => affected_recs.period_id
2525: , p_start_date => affected_recs.start_date
2526: , p_end_date => affected_recs.end_date

Line 2540: cn_mark_events_pkg.mark_notify(

2536: OPEN l_pe_cursor(affected_recs.salesrep_id, affected_recs.period_id, dependent_pe_tbl(i));
2537: FETCH l_pe_cursor INTO temp_quota_id;
2538:
2539: IF l_pe_cursor%FOUND THEN
2540: cn_mark_events_pkg.mark_notify(
2541: p_salesrep_id => affected_recs.salesrep_id
2542: , p_period_id => affected_recs.period_id
2543: , p_start_date => affected_recs.start_date
2544: , p_end_date => affected_recs.end_date

Line 2562: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.end'

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;
2566: EXCEPTION

Line 2571: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.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;
2575:

Line 2633: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.begin'

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;
2637:

Line 2639: cn_mark_events_pkg.log_event(

2635: );
2636: END IF;
2637:
2638: l_role_id := p_object_id;
2639: cn_mark_events_pkg.log_event(
2640: p_event_name
2641: , p_object_name
2642: , p_object_id
2643: , p_start_date

Line 2657: cn_mark_events_pkg.mark_notify(

2653: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2654:
2655: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2656: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id
2657: cn_mark_events_pkg.mark_notify(
2658: l_rec.salesrep_id
2659: , l_rec.period_id
2660: , l_rec.start_date
2661: , l_rec.end_date

Line 2682: cn_mark_events_pkg.mark_notify(

2678:
2679: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date - 1
2680: , l_date_range_tbl(l_ctr).end_date) LOOP
2681: -- ROLL events : pass in start_date/end_date, pass null to p_quota_id
2682: cn_mark_events_pkg.mark_notify(
2683: l_rec.salesrep_id
2684: , l_rec.period_id
2685: , l_rec.start_date
2686: , l_rec.end_date

Line 2700: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.end'

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;
2704: EXCEPTION

Line 2709: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.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;
2713:

Line 2768: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.begin'

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;
2772:

Line 2775: cn_mark_events_pkg.log_event(

2771: END IF;
2772:
2773: l_pay_group_id := p_object_id;
2774: l_salesrep_id := p_srp_object_id;
2775: cn_mark_events_pkg.log_event(
2776: p_event_name
2777: , p_object_name
2778: , p_object_id
2779: , p_start_date

Line 2793: cn_mark_events_pkg.mark_notify(

2789: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2790:
2791: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2792: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id
2793: cn_mark_events_pkg.mark_notify(
2794: l_rec.salesrep_id
2795: , l_rec.period_id
2796: , l_rec.start_date
2797: , l_rec.end_date

Line 2817: cn_mark_events_pkg.mark_notify(

2813:
2814: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date - 1
2815: , l_date_range_tbl(l_ctr).end_date) LOOP
2816: -- ROLL events : pass in start_date/end_date, pass null to p_quota_id
2817: cn_mark_events_pkg.mark_notify(
2818: l_rec.salesrep_id
2819: , l_rec.period_id
2820: , l_rec.start_date
2821: , l_rec.end_date

Line 2835: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.end'

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;
2839: EXCEPTION

Line 2844: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.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;
2848:

Line 2902: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.begin'

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;
2906:

Line 2908: cn_mark_events_pkg.log_event(

2904: );
2905: END IF;
2906:
2907: l_salesrep_id := p_object_id;
2908: cn_mark_events_pkg.log_event(
2909: p_event_name
2910: , p_object_name
2911: , p_object_id
2912: , p_start_date

Line 2954: cn_mark_events_pkg.mark_notify(

2950:
2951: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date
2952: , l_date_range_tbl(l_ctr).end_date) LOOP
2953: -- ROLL events : pass in start_date/end_date, pass null to p_quota_id
2954: cn_mark_events_pkg.mark_notify(
2955: l_rec.salesrep_id
2956: , l_rec.period_id
2957: , l_rec.start_date
2958: , l_rec.end_date

Line 2972: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.end'

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;
2976: EXCEPTION

Line 2981: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.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;
2985:

Line 3047: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.begin'

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;
3051:

Line 3052: cn_mark_events_pkg.log_event(

3048: , 'Beginning of mark_event_formula ...'
3049: );
3050: END IF;
3051:
3052: cn_mark_events_pkg.log_event(
3053: p_event_name => p_event_name
3054: , p_object_name => p_object_name
3055: , p_object_id => p_object_id
3056: , p_start_date => p_start_date

Line 3101: cn_mark_events_pkg.mark_notify(

3097: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3098: FETCH l_pe_cursor INTO temp_quota_id;
3099:
3100: IF l_pe_cursor%FOUND THEN
3101: cn_mark_events_pkg.mark_notify(
3102: p_salesrep_id => srp_quota.salesrep_id
3103: , p_period_id => srp_quota.period_id
3104: , p_start_date => NULL
3105: , p_end_date => NULL

Line 3123: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.end'

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;
3127: EXCEPTION

Line 3132: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.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;
3136:

Line 3201: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.begin'

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;
3205:

Line 3206: cn_mark_events_pkg.log_event(

3202: , 'Beginning of mark_event_rate_table ...'
3203: );
3204: END IF;
3205:
3206: cn_mark_events_pkg.log_event(
3207: p_event_name => p_event_name
3208: , p_object_name => p_object_name
3209: , p_object_id => p_object_id
3210: , p_start_date => p_start_date

Line 3255: cn_mark_events_pkg.mark_notify(

3251: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3252: FETCH l_pe_cursor INTO temp_quota_id;
3253:
3254: IF l_pe_cursor%FOUND THEN
3255: cn_mark_events_pkg.mark_notify(
3256: p_salesrep_id => srp_quota.salesrep_id
3257: , p_period_id => srp_quota.period_id
3258: , p_start_date => NULL
3259: , p_end_date => NULL

Line 3277: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.end'

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;
3281: EXCEPTION

Line 3286: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.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;
3290:

Line 3357: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.begin'

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;
3361:

Line 3362: cn_mark_events_pkg.log_event(

3358: , 'Beginning of mark_event_rate_tier_table...'
3359: );
3360: END IF;
3361:
3362: cn_mark_events_pkg.log_event(
3363: p_event_name => p_event_name
3364: , p_object_name => p_object_name
3365: , p_object_id => p_object_id
3366: , p_start_date => p_start_date

Line 3410: cn_mark_events_pkg.mark_notify(

3406: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3407: FETCH l_pe_cursor INTO temp_quota_id;
3408:
3409: IF l_pe_cursor%FOUND THEN
3410: cn_mark_events_pkg.mark_notify(
3411: p_salesrep_id => srp_quota.salesrep_id
3412: , p_period_id => srp_quota.period_id
3413: , p_start_date => NULL
3414: , p_end_date => NULL

Line 3432: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.end'

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;
3436: EXCEPTION

Line 3441: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.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;
3445:

Line 3495: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.begin'

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;
3499:

Line 3539: cn_mark_events_pkg.mark_notify(

3535: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3536: FETCH l_pe_cursor INTO temp_quota_id;
3537:
3538: IF l_pe_cursor%FOUND THEN
3539: cn_mark_events_pkg.mark_notify(
3540: p_salesrep_id => srp_quota.salesrep_id
3541: , p_period_id => srp_quota.period_id
3542: , p_start_date => p_start_date
3543: , p_end_date => p_end_date

Line 3561: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.end'

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;
3565: EXCEPTION

Line 3570: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.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;
3574:

Line 3619: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.begin'

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;
3623:

Line 3624: cn_mark_events_pkg.log_event(

3620: , 'Beginning of mark_event_interval_number ...'
3621: );
3622: END IF;
3623:
3624: cn_mark_events_pkg.log_event(
3625: p_event_name
3626: , p_object_name
3627: , p_object_id
3628: , p_start_date

Line 3652: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.end'

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;
3656: EXCEPTION

Line 3661: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.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;
3665:

Line 3713: cn_mark_events_pkg.mark_event_interval_number(

3709: OPEN dates(rec.org_id);
3710: FETCH dates INTO l_start_date, l_end_date;
3711: CLOSE dates;
3712:
3713: cn_mark_events_pkg.mark_event_interval_number(
3714: 'CHANGE_PERIOD_INTERVAL_NUMBER'
3715: , l_object_name
3716: , rec.interval_type_id
3717: , NULL

Line 3788: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.begin'

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;
3792:

Line 3793: cn_mark_events_pkg.log_event(

3789: , 'Beginning of mark_event_comp_plan ...'
3790: );
3791: END IF;
3792:
3793: cn_mark_events_pkg.log_event(
3794: p_event_name => p_event_name
3795: , p_object_name => p_object_name
3796: , p_object_id => p_object_id
3797: , p_start_date => p_start_date

Line 3809: cn_mark_events_pkg.mark_notify(

3805: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
3806:
3807: IF p_event_name = 'CHANGE_COMP_PLAN' OR p_event_name = 'CHANGE_COMP_PLAN_OVERLAP' THEN
3808: FOR affected_recs IN affected_srp_curs(l_start_period_id, l_end_period_id) LOOP
3809: cn_mark_events_pkg.mark_notify(
3810: p_salesrep_id => affected_recs.salesrep_id
3811: , p_period_id => affected_recs.period_id
3812: , p_start_date => affected_recs.start_date
3813: , p_end_date => affected_recs.end_date

Line 3826: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.end'

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;
3830: EXCEPTION

Line 3835: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.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;
3839:

Line 3898: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.begin'

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;
3902:

Line 3903: cn_mark_events_pkg.log_event(

3899: , 'Beginning of mark_event_srp_quotas ...'
3900: );
3901: END IF;
3902:
3903: cn_mark_events_pkg.log_event(
3904: p_event_name
3905: , p_object_name
3906: , p_object_id
3907: , p_start_date

Line 3934: cn_mark_events_pkg.mark_notify(

3930:
3931: -- modified by rjin 11/10/1999
3932: -- since all affected period (including subsequent periods)
3933: -- are garaunteed to be marked, so we only need to mark 'NEW'
3934: cn_mark_events_pkg.mark_notify(
3935: p_salesrep_id => srp_quota.salesrep_id
3936: , p_period_id => srp_quota.period_id
3937: , p_start_date => NULL
3938: , p_end_date => NULL

Line 3952: cn_mark_events_pkg.mark_notify(

3948: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3949: FETCH l_pe_cursor INTO temp_quota_id;
3950:
3951: IF l_pe_cursor%FOUND THEN
3952: cn_mark_events_pkg.mark_notify(
3953: p_salesrep_id => srp_quota.salesrep_id
3954: , p_period_id => srp_quota.period_id
3955: , p_start_date => NULL
3956: , p_end_date => NULL

Line 3974: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.end'

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;
3978: EXCEPTION

Line 3983: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.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;
3987:

Line 4063: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.begin'

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;
4067:

Line 4068: cn_mark_events_pkg.log_event(

4064: , 'Beginning of mark_event_srp_uplifts ...'
4065: );
4066: END IF;
4067:
4068: cn_mark_events_pkg.log_event(
4069: p_event_name
4070: , p_object_name
4071: , p_object_id
4072: , p_start_date

Line 4103: cn_mark_events_pkg.mark_notify(

4099: );
4100: l_latest_quota_id := srp_quota.quota_id;
4101: END IF;
4102:
4103: cn_mark_events_pkg.mark_notify(
4104: srp_quota.salesrep_id
4105: , srp_quota.period_id
4106: , srp_quota.start_date
4107: , srp_quota.end_date

Line 4120: cn_mark_events_pkg.mark_notify(

4116: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4117: FETCH l_pe_cursor INTO temp_quota_id;
4118:
4119: IF l_pe_cursor%FOUND THEN
4120: cn_mark_events_pkg.mark_notify(
4121: p_salesrep_id => srp_quota.salesrep_id
4122: , p_period_id => srp_quota.period_id
4123: , p_start_date => srp_quota.start_date
4124: , p_end_date => srp_quota.end_date

Line 4141: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.end'

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;
4145: EXCEPTION

Line 4150: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.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;
4154:

Line 4225: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.begin'

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;
4229:

Line 4230: cn_mark_events_pkg.log_event(

4226: , 'Beginning of mark_event_srp_rate_assigns ...'
4227: );
4228: END IF;
4229:
4230: cn_mark_events_pkg.log_event(
4231: p_event_name
4232: , p_object_name
4233: , p_object_id
4234: , p_start_date

Line 4260: cn_mark_events_pkg.mark_notify(

4256: );
4257: l_latest_quota_id := srp_quota.quota_id;
4258: END IF;
4259:
4260: cn_mark_events_pkg.mark_notify(
4261: srp_quota.salesrep_id
4262: , srp_quota.period_id
4263: , NULL
4264: , NULL

Line 4277: cn_mark_events_pkg.mark_notify(

4273: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4274: FETCH l_pe_cursor INTO temp_quota_id;
4275:
4276: IF l_pe_cursor%FOUND THEN
4277: cn_mark_events_pkg.mark_notify(
4278: p_salesrep_id => srp_quota.salesrep_id
4279: , p_period_id => srp_quota.period_id
4280: , p_start_date => NULL
4281: , p_end_date => NULL

Line 4298: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.end'

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;
4302: EXCEPTION

Line 4307: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.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;
4311:

Line 4367: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'

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;
4371:

Line 4372: cn_mark_events_pkg.log_event(

4368: , 'Beginning of mark_event_srp_period_quota ...'
4369: );
4370: END IF;
4371:
4372: cn_mark_events_pkg.log_event(
4373: p_event_name
4374: , p_object_name
4375: , p_object_id
4376: , p_start_date

Line 4399: cn_mark_events_pkg.mark_notify(

4395: , x_msg_data => l_msg_data
4396: );
4397: END IF;
4398:
4399: cn_mark_events_pkg.mark_notify(
4400: srp_quota.salesrep_id
4401: , srp_quota.period_id
4402: , NULL
4403: , NULL

Line 4416: cn_mark_events_pkg.mark_notify(

4412: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4413: FETCH l_pe_cursor INTO temp_quota_id;
4414:
4415: IF l_pe_cursor%FOUND THEN
4416: cn_mark_events_pkg.mark_notify(
4417: p_salesrep_id => srp_quota.salesrep_id
4418: , p_period_id => srp_quota.period_id
4419: , p_start_date => NULL
4420: , p_end_date => NULL

Line 4437: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'

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;
4441: EXCEPTION

Line 4446: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.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;
4450:

Line 4486: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'

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;
4490:

Line 4491: cn_mark_events_pkg.log_event(

4487: , 'Beginning of mark_event_srp_period_quota ...'
4488: );
4489: END IF;
4490:
4491: cn_mark_events_pkg.log_event(
4492: p_event_name
4493: , p_object_name
4494: , p_object_id
4495: , p_start_date

Line 4515: cn_mark_events_pkg.mark_notify(

4511: , x_msg_count => l_msg_count
4512: , x_msg_data => l_msg_data
4513: );
4514:
4515: cn_mark_events_pkg.mark_notify(
4516: p_salesrep_id => p_object_id
4517: , p_period_id => p_period_id
4518: , p_start_date => NULL
4519: , p_end_date => NULL

Line 4553: cn_mark_events_pkg.mark_notify(

4549: -- notify Dependent PE's.
4550: --
4551: IF (dependent_pe_tbl.COUNT > 0) THEN
4552: FOR i IN 0 ..(dependent_pe_tbl.COUNT - 1) LOOP
4553: cn_mark_events_pkg.mark_notify(
4554: p_salesrep_id => p_object_id
4555: , p_period_id => p_period_id
4556: , p_start_date => NULL
4557: , p_end_date => NULL

Line 4570: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'

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;
4574: EXCEPTION

Line 4579: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.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;
4583:

Line 4659: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assigns.begin'

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;
4663:

Line 4664: cn_mark_events_pkg.log_event(

4660: , 'Beginning of mark_event_srp_payee_assigns ...'
4661: );
4662: END IF;
4663:
4664: cn_mark_events_pkg.log_event(
4665: p_event_name
4666: , p_object_name
4667: , p_object_id
4668: , p_start_date

Line 4723: cn_mark_events_pkg.mark_notify(

4719: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4720: FETCH l_pe_cursor INTO temp_quota_id;
4721:
4722: IF l_pe_cursor%FOUND THEN
4723: cn_mark_events_pkg.mark_notify(
4724: p_salesrep_id => srp_quota.salesrep_id
4725: , p_period_id => srp_quota.period_id
4726: , p_start_date => srp_quota.start_date
4727: , p_end_date => srp_quota.end_date

Line 4793: cn_mark_events_pkg.mark_notify(

4789: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4790: FETCH l_pe_cursor INTO temp_quota_id;
4791:
4792: IF l_pe_cursor%FOUND THEN
4793: cn_mark_events_pkg.mark_notify(
4794: p_salesrep_id => srp_quota.salesrep_id
4795: , p_period_id => srp_quota.period_id
4796: , p_start_date => srp_quota.start_date
4797: , p_end_date => srp_quota.end_date

Line 4816: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_assign.end'

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;
4820: EXCEPTION

Line 4825: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assign.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;
4829:

Line 4885: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.begin'

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;
4889:

Line 4906: cn_mark_events_pkg.log_event(

4902: t_end_date_active := p_end_date_active;
4903: END IF;
4904:
4905: IF p_event_log_id IS NULL THEN
4906: cn_mark_events_pkg.log_event(
4907: p_event_name => p_team_event_name
4908: , p_object_name => t_team_name
4909: , p_object_id => p_team_id
4910: , p_start_date => t_start_date_active

Line 4937: cn_mark_events_pkg.mark_notify_salesreps(

4933: , t_end_date_active
4934: , l_action
4935: , l_revert_state
4936: ) LOOP
4937: cn_mark_events_pkg.mark_notify_salesreps(
4938: p_salesrep_id => c_mem_rec.salesrep_id
4939: , p_comp_group_id => NULL
4940: , p_period_id => prd.period_id
4941: , p_start_date => prd.start_date

Line 4958: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.end'

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;
4962: EXCEPTION

Line 4967: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.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;
4971:

Line 4974: END cn_mark_events_pkg;

4970: END IF;
4971:
4972: RAISE;
4973: END mark_notify_team;
4974: END cn_mark_events_pkg;