[Home] [Help]
1: PACKAGE BODY cn_mark_events_pkg AS
2: -- $Header: cneventb.pls 120.17.12020000.2 2013/04/16 06:10:45 ndamala ship $
3:
4: -- forward declaration
5: PROCEDURE mark_subsequent_periods(
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;
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:
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
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:
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:
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
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:
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:
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
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:
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:
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
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:
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:
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
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:
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:
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
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:
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:
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
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:
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:
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;
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:
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:
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;
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:
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:
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
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
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
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
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
2040: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2041:
2042: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id
2043: , p_start_date_old, p_end_date_old) LOOP
2044: cn_mark_events_pkg.mark_notify(
2045: p_salesrep_id => affected_recs.salesrep_id
2046: , p_period_id => affected_recs.period_id
2047: , p_start_date => affected_recs.start_date
2048: , p_end_date => affected_recs.end_date
2057: OPEN l_pe_cursor(affected_recs.salesrep_id, affected_recs.period_id, dependent_pe_tbl(i));
2058: FETCH l_pe_cursor INTO temp_quota_id;
2059:
2060: IF l_pe_cursor%FOUND THEN
2061: cn_mark_events_pkg.mark_notify(
2062: p_salesrep_id => affected_recs.salesrep_id
2063: , p_period_id => affected_recs.period_id
2064: , p_start_date => affected_recs.start_date
2065: , p_end_date => affected_recs.end_date
2096: , l_end_period_id
2097: , l_date_range_rec_tbl(i).start_date
2098: , l_date_range_rec_tbl(i).end_date
2099: ) LOOP
2100: cn_mark_events_pkg.mark_notify(
2101: p_salesrep_id => affected_period_recs.salesrep_id
2102: , p_period_id => affected_period_recs.period_id
2103: , p_start_date => affected_period_recs.start_date
2104: , p_end_date => affected_period_recs.end_date
2113: OPEN l_pe_cursor(affected_period_recs.salesrep_id, affected_period_recs.period_id, dependent_pe_tbl(i));
2114: FETCH l_pe_cursor INTO temp_quota_id;
2115:
2116: IF l_pe_cursor%FOUND THEN
2117: cn_mark_events_pkg.mark_notify(
2118: p_salesrep_id => affected_period_recs.salesrep_id
2119: , p_period_id => affected_period_recs.period_id
2120: , p_start_date => affected_period_recs.start_date
2121: , p_end_date => affected_period_recs.end_date
2135:
2136: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2137: fnd_log.STRING(
2138: fnd_log.level_procedure
2139: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.end'
2140: , 'End of mark_event_quota.'
2141: );
2142: END IF;
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2146: fnd_log.STRING(
2147: fnd_log.level_unexpected
2148: , 'cn.plsql.cn_mark_events_pkg.mark_event_quota.exception'
2149: , SQLERRM
2150: );
2151: END IF;
2152:
2235:
2236: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2237: fnd_log.STRING(
2238: fnd_log.level_procedure
2239: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.begin'
2240: , 'Beginning of mark_event_rt_quota ...'
2241: );
2242: END IF;
2243:
2240: , 'Beginning of mark_event_rt_quota ...'
2241: );
2242: END IF;
2243:
2244: cn_mark_events_pkg.log_event(
2245: p_event_name => p_event_name
2246: , p_object_name => p_object_name
2247: , p_object_id => p_object_id
2248: , p_start_date => p_start_date
2275: l_start_period_id := cn_api.get_acc_period_id(p_start_date_old, p_org_id);
2276: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2277:
2278: FOR affected_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id) LOOP
2279: cn_mark_events_pkg.mark_notify(
2280: p_salesrep_id => affected_recs.salesrep_id
2281: , p_period_id => affected_recs.period_id
2282: , p_start_date => NULL
2283: , p_end_date => NULL
2292: OPEN l_pe_cursor(affected_recs.salesrep_id, affected_recs.period_id, dependent_pe_tbl(i));
2293: FETCH l_pe_cursor INTO temp_quota_id;
2294:
2295: IF l_pe_cursor%FOUND THEN
2296: cn_mark_events_pkg.mark_notify(
2297: p_salesrep_id => affected_recs.salesrep_id
2298: , p_period_id => affected_recs.period_id
2299: , p_start_date => NULL
2300: , p_end_date => NULL
2326: cn_api.get_acc_period_id(l_date_range_rec_tbl(i).start_date, p_org_id);
2327: l_end_period_id := cn_api.get_acc_period_id(l_date_range_rec_tbl(i).end_date, p_org_id);
2328:
2329: FOR affected_period_recs IN affected_srp_period_curs(l_start_period_id, l_end_period_id) LOOP
2330: cn_mark_events_pkg.mark_notify(
2331: p_salesrep_id => affected_period_recs.salesrep_id
2332: , p_period_id => affected_period_recs.period_id
2333: , p_start_date => NULL
2334: , p_end_date => NULL
2343: OPEN l_pe_cursor(affected_period_recs.salesrep_id, affected_period_recs.period_id, dependent_pe_tbl(i));
2344: FETCH l_pe_cursor INTO temp_quota_id;
2345:
2346: IF l_pe_cursor%FOUND THEN
2347: cn_mark_events_pkg.mark_notify(
2348: p_salesrep_id => affected_period_recs.salesrep_id
2349: , p_period_id => affected_period_recs.period_id
2350: , p_start_date => NULL
2351: , p_end_date => NULL
2365:
2366: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2367: fnd_log.STRING(
2368: fnd_log.level_procedure
2369: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.end'
2370: , 'End of mark_event_rt_quota.'
2371: );
2372: END IF;
2373: EXCEPTION
2374: WHEN OTHERS THEN
2375: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2376: fnd_log.STRING(
2377: fnd_log.level_unexpected
2378: , 'cn.plsql.cn_mark_events_pkg.mark_event_rt_quota.exception'
2379: , SQLERRM
2380: );
2381: END IF;
2382:
2472:
2473: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2474: fnd_log.STRING(
2475: fnd_log.level_procedure
2476: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.begin'
2477: , 'Beginning of mark_event_trx_factor ...'
2478: );
2479: END IF;
2480:
2477: , 'Beginning of mark_event_trx_factor ...'
2478: );
2479: END IF;
2480:
2481: cn_mark_events_pkg.log_event(
2482: p_event_name => p_event_name
2483: , p_object_name => p_object_name
2484: , p_object_id => p_object_id
2485: , p_start_date => p_start_date
2520: , l_start_date, l_end_date) LOOP
2521: -- modified by rjin 11/10/1999
2522: -- since all affected period (including subsequent periods)
2523: -- are garaunteed to be marked, so we only need to mark 'NEW'
2524: cn_mark_events_pkg.mark_notify(
2525: p_salesrep_id => affected_recs.salesrep_id
2526: , p_period_id => affected_recs.period_id
2527: , p_start_date => affected_recs.start_date
2528: , p_end_date => affected_recs.end_date
2538: OPEN l_pe_cursor(affected_recs.salesrep_id, affected_recs.period_id, dependent_pe_tbl(i));
2539: FETCH l_pe_cursor INTO temp_quota_id;
2540:
2541: IF l_pe_cursor%FOUND THEN
2542: cn_mark_events_pkg.mark_notify(
2543: p_salesrep_id => affected_recs.salesrep_id
2544: , p_period_id => affected_recs.period_id
2545: , p_start_date => affected_recs.start_date
2546: , p_end_date => affected_recs.end_date
2560:
2561: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2562: fnd_log.STRING(
2563: fnd_log.level_procedure
2564: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.end'
2565: , 'End of mark_event_trx_factor.'
2566: );
2567: END IF;
2568: EXCEPTION
2569: WHEN OTHERS THEN
2570: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2571: fnd_log.STRING(
2572: fnd_log.level_unexpected
2573: , 'cn.plsql.cn_mark_events_pkg.mark_event_trx_factor.exception'
2574: , SQLERRM
2575: );
2576: END IF;
2577:
2631:
2632: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2633: fnd_log.STRING(
2634: fnd_log.level_procedure
2635: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.begin'
2636: , 'Beginning of mark_event_role_plans ...'
2637: );
2638: END IF;
2639:
2637: );
2638: END IF;
2639:
2640: l_role_id := p_object_id;
2641: cn_mark_events_pkg.log_event(
2642: p_event_name
2643: , p_object_name
2644: , p_object_id
2645: , p_start_date
2655: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2656:
2657: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2658: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id
2659: cn_mark_events_pkg.mark_notify(
2660: l_rec.salesrep_id
2661: , l_rec.period_id
2662: , l_rec.start_date
2663: , l_rec.end_date
2680:
2681: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date - 1
2682: , l_date_range_tbl(l_ctr).end_date) LOOP
2683: -- ROLL events : pass in start_date/end_date, pass null to p_quota_id
2684: cn_mark_events_pkg.mark_notify(
2685: l_rec.salesrep_id
2686: , l_rec.period_id
2687: , l_rec.start_date
2688: , l_rec.end_date
2698:
2699: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2700: fnd_log.STRING(
2701: fnd_log.level_procedure
2702: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.end'
2703: , 'End of mark_event_role_plans.'
2704: );
2705: END IF;
2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2709: fnd_log.STRING(
2710: fnd_log.level_unexpected
2711: , 'cn.plsql.cn_mark_events_pkg.mark_event_role_plans.exception'
2712: , SQLERRM
2713: );
2714: END IF;
2715:
2766:
2767: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2768: fnd_log.STRING(
2769: fnd_log.level_procedure
2770: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.begin'
2771: , 'Beginning of mark_event_spr_pay_group ...'
2772: );
2773: END IF;
2774:
2773: END IF;
2774:
2775: l_pay_group_id := p_object_id;
2776: l_salesrep_id := p_srp_object_id;
2777: cn_mark_events_pkg.log_event(
2778: p_event_name
2779: , p_object_name
2780: , p_object_id
2781: , p_start_date
2791: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
2792:
2793: FOR l_rec IN affected_srp_period(p_start_date_old, p_end_date_old) LOOP
2794: -- For ROLL events, pass in start_date/end_date, pass null to p_quota_id
2795: cn_mark_events_pkg.mark_notify(
2796: l_rec.salesrep_id
2797: , l_rec.period_id
2798: , l_rec.start_date
2799: , l_rec.end_date
2815:
2816: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date - 1
2817: , l_date_range_tbl(l_ctr).end_date) LOOP
2818: -- ROLL events : pass in start_date/end_date, pass null to p_quota_id
2819: cn_mark_events_pkg.mark_notify(
2820: l_rec.salesrep_id
2821: , l_rec.period_id
2822: , l_rec.start_date
2823: , l_rec.end_date
2833:
2834: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2835: fnd_log.STRING(
2836: fnd_log.level_procedure
2837: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.end'
2838: , 'End of mark_event_srp_pay_group.'
2839: );
2840: END IF;
2841: EXCEPTION
2842: WHEN OTHERS THEN
2843: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2844: fnd_log.STRING(
2845: fnd_log.level_unexpected
2846: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_group.exception'
2847: , SQLERRM
2848: );
2849: END IF;
2850:
2900:
2901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2902: fnd_log.STRING(
2903: fnd_log.level_procedure
2904: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.begin'
2905: , 'Beginning of mark_event_srp_roles ...'
2906: );
2907: END IF;
2908:
2906: );
2907: END IF;
2908:
2909: l_salesrep_id := p_object_id;
2910: cn_mark_events_pkg.log_event(
2911: p_event_name
2912: , p_object_name
2913: , p_object_id
2914: , p_start_date
2952:
2953: FOR l_rec IN affected_srp_period(l_date_range_tbl(l_ctr).start_date
2954: , l_date_range_tbl(l_ctr).end_date) LOOP
2955: -- ROLL events : pass in start_date/end_date, pass null to p_quota_id
2956: cn_mark_events_pkg.mark_notify(
2957: l_rec.salesrep_id
2958: , l_rec.period_id
2959: , l_rec.start_date
2960: , l_rec.end_date
2970:
2971: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2972: fnd_log.STRING(
2973: fnd_log.level_procedure
2974: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.end'
2975: , 'End of mark_event_srp_roles.'
2976: );
2977: END IF;
2978: EXCEPTION
2979: WHEN OTHERS THEN
2980: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
2981: fnd_log.STRING(
2982: fnd_log.level_unexpected
2983: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_roles.exception'
2984: , SQLERRM
2985: );
2986: END IF;
2987:
3045:
3046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3047: fnd_log.STRING(
3048: fnd_log.level_procedure
3049: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.begin'
3050: , 'Beginning of mark_event_formula ...'
3051: );
3052: END IF;
3053:
3050: , 'Beginning of mark_event_formula ...'
3051: );
3052: END IF;
3053:
3054: cn_mark_events_pkg.log_event(
3055: p_event_name => p_event_name
3056: , p_object_name => p_object_name
3057: , p_object_id => p_object_id
3058: , p_start_date => p_start_date
3099: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3100: FETCH l_pe_cursor INTO temp_quota_id;
3101:
3102: IF l_pe_cursor%FOUND THEN
3103: cn_mark_events_pkg.mark_notify(
3104: p_salesrep_id => srp_quota.salesrep_id
3105: , p_period_id => srp_quota.period_id
3106: , p_start_date => NULL
3107: , p_end_date => NULL
3121:
3122: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3123: fnd_log.STRING(
3124: fnd_log.level_procedure
3125: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.end'
3126: , 'End of mark_event_formula.'
3127: );
3128: END IF;
3129: EXCEPTION
3130: WHEN OTHERS THEN
3131: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3132: fnd_log.STRING(
3133: fnd_log.level_unexpected
3134: , 'cn.plsql.cn_mark_events_pkg.mark_event_formula.exception'
3135: , SQLERRM
3136: );
3137: END IF;
3138:
3199:
3200: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3201: fnd_log.STRING(
3202: fnd_log.level_procedure
3203: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.begin'
3204: , 'Beginning of mark_event_rate_table ...'
3205: );
3206: END IF;
3207:
3204: , 'Beginning of mark_event_rate_table ...'
3205: );
3206: END IF;
3207:
3208: cn_mark_events_pkg.log_event(
3209: p_event_name => p_event_name
3210: , p_object_name => p_object_name
3211: , p_object_id => p_object_id
3212: , p_start_date => p_start_date
3253: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3254: FETCH l_pe_cursor INTO temp_quota_id;
3255:
3256: IF l_pe_cursor%FOUND THEN
3257: cn_mark_events_pkg.mark_notify(
3258: p_salesrep_id => srp_quota.salesrep_id
3259: , p_period_id => srp_quota.period_id
3260: , p_start_date => NULL
3261: , p_end_date => NULL
3275:
3276: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3277: fnd_log.STRING(
3278: fnd_log.level_procedure
3279: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.end'
3280: , 'End of mark_event_rate_table.'
3281: );
3282: END IF;
3283: EXCEPTION
3284: WHEN OTHERS THEN
3285: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3286: fnd_log.STRING(
3287: fnd_log.level_unexpected
3288: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_table.exception'
3289: , SQLERRM
3290: );
3291: END IF;
3292:
3355:
3356: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3357: fnd_log.STRING(
3358: fnd_log.level_procedure
3359: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.begin'
3360: , 'Beginning of mark_event_rate_tier_table...'
3361: );
3362: END IF;
3363:
3360: , 'Beginning of mark_event_rate_tier_table...'
3361: );
3362: END IF;
3363:
3364: cn_mark_events_pkg.log_event(
3365: p_event_name => p_event_name
3366: , p_object_name => p_object_name
3367: , p_object_id => p_object_id
3368: , p_start_date => p_start_date
3408: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3409: FETCH l_pe_cursor INTO temp_quota_id;
3410:
3411: IF l_pe_cursor%FOUND THEN
3412: cn_mark_events_pkg.mark_notify(
3413: p_salesrep_id => srp_quota.salesrep_id
3414: , p_period_id => srp_quota.period_id
3415: , p_start_date => NULL
3416: , p_end_date => NULL
3430:
3431: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3432: fnd_log.STRING(
3433: fnd_log.level_procedure
3434: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.end'
3435: , 'End of mark_event_rate_tier_table.'
3436: );
3437: END IF;
3438: EXCEPTION
3439: WHEN OTHERS THEN
3440: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3441: fnd_log.STRING(
3442: fnd_log.level_unexpected
3443: , 'cn.plsql.cn_mark_events_pkg.mark_event_rate_tier_table.exception'
3444: , SQLERRM
3445: );
3446: END IF;
3447:
3493: BEGIN
3494: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3495: fnd_log.STRING(
3496: fnd_log.level_procedure
3497: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.begin'
3498: , 'Beginning of mark_notify_interval_number ...'
3499: );
3500: END IF;
3501:
3537: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3538: FETCH l_pe_cursor INTO temp_quota_id;
3539:
3540: IF l_pe_cursor%FOUND THEN
3541: cn_mark_events_pkg.mark_notify(
3542: p_salesrep_id => srp_quota.salesrep_id
3543: , p_period_id => srp_quota.period_id
3544: , p_start_date => p_start_date
3545: , p_end_date => p_end_date
3559:
3560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3561: fnd_log.STRING(
3562: fnd_log.level_procedure
3563: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.end'
3564: , 'End of mark_notify_interval_number.'
3565: );
3566: END IF;
3567: EXCEPTION
3568: WHEN OTHERS THEN
3569: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3570: fnd_log.STRING(
3571: fnd_log.level_unexpected
3572: , 'cn.plsql.cn_mark_events_pkg.mark_notify_interval_number.exception'
3573: , SQLERRM
3574: );
3575: END IF;
3576:
3617:
3618: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3619: fnd_log.STRING(
3620: fnd_log.level_procedure
3621: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.begin'
3622: , 'Beginning of mark_event_interval_number ...'
3623: );
3624: END IF;
3625:
3622: , 'Beginning of mark_event_interval_number ...'
3623: );
3624: END IF;
3625:
3626: cn_mark_events_pkg.log_event(
3627: p_event_name
3628: , p_object_name
3629: , p_object_id
3630: , p_start_date
3650:
3651: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3652: fnd_log.STRING(
3653: fnd_log.level_procedure
3654: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.end'
3655: , 'End of mark_event_interval_number.'
3656: );
3657: END IF;
3658: EXCEPTION
3659: WHEN OTHERS THEN
3660: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3661: fnd_log.STRING(
3662: fnd_log.level_unexpected
3663: , 'cn.plsql.cn_mark_events_pkg.mark_event_interval_number.exception'
3664: , SQLERRM
3665: );
3666: END IF;
3667:
3711: OPEN dates(rec.org_id);
3712: FETCH dates INTO l_start_date, l_end_date;
3713: CLOSE dates;
3714:
3715: cn_mark_events_pkg.mark_event_interval_number(
3716: 'CHANGE_PERIOD_INTERVAL_NUMBER'
3717: , l_object_name
3718: , rec.interval_type_id
3719: , NULL
3786:
3787: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3788: fnd_log.STRING(
3789: fnd_log.level_procedure
3790: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.begin'
3791: , 'Beginning of mark_event_comp_plan ...'
3792: );
3793: END IF;
3794:
3791: , 'Beginning of mark_event_comp_plan ...'
3792: );
3793: END IF;
3794:
3795: cn_mark_events_pkg.log_event(
3796: p_event_name => p_event_name
3797: , p_object_name => p_object_name
3798: , p_object_id => p_object_id
3799: , p_start_date => p_start_date
3808: l_end_period_id := cn_api.get_acc_period_id(p_end_date_old, p_org_id);
3809:
3810: IF p_event_name = 'CHANGE_COMP_PLAN' OR p_event_name = 'CHANGE_COMP_PLAN_OVERLAP' THEN
3811: FOR affected_recs IN affected_srp_curs(l_start_period_id, l_end_period_id) LOOP
3812: cn_mark_events_pkg.mark_notify(
3813: p_salesrep_id => affected_recs.salesrep_id
3814: , p_period_id => affected_recs.period_id
3815: , p_start_date => affected_recs.start_date
3816: , p_end_date => affected_recs.end_date
3825:
3826: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3827: fnd_log.STRING(
3828: fnd_log.level_procedure
3829: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.end'
3830: , 'End of mark_event_comp_plan.'
3831: );
3832: END IF;
3833: EXCEPTION
3834: WHEN OTHERS THEN
3835: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3836: fnd_log.STRING(
3837: fnd_log.level_unexpected
3838: , 'cn.plsql.cn_mark_events_pkg.mark_event_comp_plan.exception'
3839: , SQLERRM
3840: );
3841: END IF;
3842:
3898:
3899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3900: fnd_log.STRING(
3901: fnd_log.level_procedure
3902: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.begin'
3903: , 'Beginning of mark_event_srp_quotas ...'
3904: );
3905: END IF;
3906:
3903: , 'Beginning of mark_event_srp_quotas ...'
3904: );
3905: END IF;
3906:
3907: cn_mark_events_pkg.log_event(
3908: p_event_name
3909: , p_object_name
3910: , p_object_id
3911: , p_start_date
3934:
3935: -- modified by rjin 11/10/1999
3936: -- since all affected period (including subsequent periods)
3937: -- are garaunteed to be marked, so we only need to mark 'NEW'
3938: cn_mark_events_pkg.mark_notify(
3939: p_salesrep_id => srp_quota.salesrep_id
3940: , p_period_id => srp_quota.period_id
3941: , p_start_date => NULL
3942: , p_end_date => NULL
3952: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
3953: FETCH l_pe_cursor INTO temp_quota_id;
3954:
3955: IF l_pe_cursor%FOUND THEN
3956: cn_mark_events_pkg.mark_notify(
3957: p_salesrep_id => srp_quota.salesrep_id
3958: , p_period_id => srp_quota.period_id
3959: , p_start_date => NULL
3960: , p_end_date => NULL
3974:
3975: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3976: fnd_log.STRING(
3977: fnd_log.level_procedure
3978: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.end'
3979: , 'End of mark_event_srp_quotas.'
3980: );
3981: END IF;
3982: EXCEPTION
3983: WHEN OTHERS THEN
3984: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
3985: fnd_log.STRING(
3986: fnd_log.level_unexpected
3987: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_quotas.exception'
3988: , SQLERRM
3989: );
3990: END IF;
3991:
4063:
4064: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4065: fnd_log.STRING(
4066: fnd_log.level_procedure
4067: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.begin'
4068: , 'Beginning of mark_event_srp_uplifts ...'
4069: );
4070: END IF;
4071:
4068: , 'Beginning of mark_event_srp_uplifts ...'
4069: );
4070: END IF;
4071:
4072: cn_mark_events_pkg.log_event(
4073: p_event_name
4074: , p_object_name
4075: , p_object_id
4076: , p_start_date
4103: );
4104: l_latest_quota_id := srp_quota.quota_id;
4105: END IF;
4106:
4107: cn_mark_events_pkg.mark_notify(
4108: srp_quota.salesrep_id
4109: , srp_quota.period_id
4110: , srp_quota.start_date
4111: , srp_quota.end_date
4120: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4121: FETCH l_pe_cursor INTO temp_quota_id;
4122:
4123: IF l_pe_cursor%FOUND THEN
4124: cn_mark_events_pkg.mark_notify(
4125: p_salesrep_id => srp_quota.salesrep_id
4126: , p_period_id => srp_quota.period_id
4127: , p_start_date => srp_quota.start_date
4128: , p_end_date => srp_quota.end_date
4141:
4142: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4143: fnd_log.STRING(
4144: fnd_log.level_procedure
4145: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.end'
4146: , 'End of mark_event_srp_uplifts.'
4147: );
4148: END IF;
4149: EXCEPTION
4150: WHEN OTHERS THEN
4151: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4152: fnd_log.STRING(
4153: fnd_log.level_unexpected
4154: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_uplifts.exception'
4155: , SQLERRM
4156: );
4157: END IF;
4158:
4225:
4226: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4227: fnd_log.STRING(
4228: fnd_log.level_procedure
4229: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.begin'
4230: , 'Beginning of mark_event_srp_rate_assigns ...'
4231: );
4232: END IF;
4233:
4230: , 'Beginning of mark_event_srp_rate_assigns ...'
4231: );
4232: END IF;
4233:
4234: cn_mark_events_pkg.log_event(
4235: p_event_name
4236: , p_object_name
4237: , p_object_id
4238: , p_start_date
4260: );
4261: l_latest_quota_id := srp_quota.quota_id;
4262: END IF;
4263:
4264: cn_mark_events_pkg.mark_notify(
4265: srp_quota.salesrep_id
4266: , srp_quota.period_id
4267: , NULL
4268: , NULL
4277: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4278: FETCH l_pe_cursor INTO temp_quota_id;
4279:
4280: IF l_pe_cursor%FOUND THEN
4281: cn_mark_events_pkg.mark_notify(
4282: p_salesrep_id => srp_quota.salesrep_id
4283: , p_period_id => srp_quota.period_id
4284: , p_start_date => NULL
4285: , p_end_date => NULL
4298:
4299: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4300: fnd_log.STRING(
4301: fnd_log.level_procedure
4302: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.end'
4303: , 'End of mark_event_srp_rate_assigns.'
4304: );
4305: END IF;
4306: EXCEPTION
4307: WHEN OTHERS THEN
4308: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4309: fnd_log.STRING(
4310: fnd_log.level_unexpected
4311: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_rate_assigns.exception'
4312: , SQLERRM
4313: );
4314: END IF;
4315:
4368:
4369: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4370: fnd_log.STRING(
4371: fnd_log.level_procedure
4372: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4373: , 'Beginning of mark_event_srp_period_quota ...'
4374: );
4375: END IF;
4376:
4373: , 'Beginning of mark_event_srp_period_quota ...'
4374: );
4375: END IF;
4376:
4377: cn_mark_events_pkg.log_event(
4378: p_event_name
4379: , p_object_name
4380: , p_object_id
4381: , p_start_date
4400: , x_msg_data => l_msg_data
4401: );
4402: END IF;
4403:
4404: cn_mark_events_pkg.mark_notify(
4405: srp_quota.salesrep_id
4406: , srp_quota.period_id
4407: , NULL
4408: , NULL
4417: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4418: FETCH l_pe_cursor INTO temp_quota_id;
4419:
4420: IF l_pe_cursor%FOUND THEN
4421: cn_mark_events_pkg.mark_notify(
4422: p_salesrep_id => srp_quota.salesrep_id
4423: , p_period_id => srp_quota.period_id
4424: , p_start_date => NULL
4425: , p_end_date => NULL
4438:
4439: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4440: fnd_log.STRING(
4441: fnd_log.level_procedure
4442: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4443: , 'End of mark_event_srp_period_quota.'
4444: );
4445: END IF;
4446: EXCEPTION
4447: WHEN OTHERS THEN
4448: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4449: fnd_log.STRING(
4450: fnd_log.level_unexpected
4451: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4452: , SQLERRM
4453: );
4454: END IF;
4455:
4487:
4488: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4489: fnd_log.STRING(
4490: fnd_log.level_procedure
4491: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.begin'
4492: , 'Beginning of mark_event_srp_period_quota ...'
4493: );
4494: END IF;
4495:
4492: , 'Beginning of mark_event_srp_period_quota ...'
4493: );
4494: END IF;
4495:
4496: cn_mark_events_pkg.log_event(
4497: p_event_name
4498: , p_object_name
4499: , p_object_id
4500: , p_start_date
4516: , x_msg_count => l_msg_count
4517: , x_msg_data => l_msg_data
4518: );
4519:
4520: cn_mark_events_pkg.mark_notify(
4521: p_salesrep_id => p_object_id
4522: , p_period_id => p_period_id
4523: , p_start_date => NULL
4524: , p_end_date => NULL
4554: -- notify Dependent PE's.
4555: --
4556: IF (dependent_pe_tbl.COUNT > 0) THEN
4557: FOR i IN 0 ..(dependent_pe_tbl.COUNT - 1) LOOP
4558: cn_mark_events_pkg.mark_notify(
4559: p_salesrep_id => p_object_id
4560: , p_period_id => p_period_id
4561: , p_start_date => NULL
4562: , p_end_date => NULL
4571:
4572: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4573: fnd_log.STRING(
4574: fnd_log.level_procedure
4575: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.end'
4576: , 'End of mark_event_srp_period_quota.'
4577: );
4578: END IF;
4579: EXCEPTION
4580: WHEN OTHERS THEN
4581: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4582: fnd_log.STRING(
4583: fnd_log.level_unexpected
4584: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_period_quota.exception'
4585: , SQLERRM
4586: );
4587: END IF;
4588:
4660:
4661: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4662: fnd_log.STRING(
4663: fnd_log.level_procedure
4664: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assigns.begin'
4665: , 'Beginning of mark_event_srp_payee_assigns ...'
4666: );
4667: END IF;
4668:
4665: , 'Beginning of mark_event_srp_payee_assigns ...'
4666: );
4667: END IF;
4668:
4669: cn_mark_events_pkg.log_event(
4670: p_event_name
4671: , p_object_name
4672: , p_object_id
4673: , p_start_date
4724: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4725: FETCH l_pe_cursor INTO temp_quota_id;
4726:
4727: IF l_pe_cursor%FOUND THEN
4728: cn_mark_events_pkg.mark_notify(
4729: p_salesrep_id => srp_quota.salesrep_id
4730: , p_period_id => srp_quota.period_id
4731: , p_start_date => srp_quota.start_date
4732: , p_end_date => srp_quota.end_date
4794: OPEN l_pe_cursor(srp_quota.salesrep_id, srp_quota.period_id, dependent_pe_tbl(i));
4795: FETCH l_pe_cursor INTO temp_quota_id;
4796:
4797: IF l_pe_cursor%FOUND THEN
4798: cn_mark_events_pkg.mark_notify(
4799: p_salesrep_id => srp_quota.salesrep_id
4800: , p_period_id => srp_quota.period_id
4801: , p_start_date => srp_quota.start_date
4802: , p_end_date => srp_quota.end_date
4817:
4818: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4819: fnd_log.STRING(
4820: fnd_log.level_procedure
4821: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_pay_assign.end'
4822: , 'End of mark_event_srp_payee_assign.'
4823: );
4824: END IF;
4825: EXCEPTION
4826: WHEN OTHERS THEN
4827: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4828: fnd_log.STRING(
4829: fnd_log.level_unexpected
4830: , 'cn.plsql.cn_mark_events_pkg.mark_event_srp_payee_assign.exception'
4831: , SQLERRM
4832: );
4833: END IF;
4834:
4886: BEGIN
4887: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4888: fnd_log.STRING(
4889: fnd_log.level_procedure
4890: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.begin'
4891: , 'Beginning of mark_notify_team ...'
4892: );
4893: END IF;
4894:
4907: t_end_date_active := p_end_date_active;
4908: END IF;
4909:
4910: IF p_event_log_id IS NULL THEN
4911: cn_mark_events_pkg.log_event(
4912: p_event_name => p_team_event_name
4913: , p_object_name => t_team_name
4914: , p_object_id => p_team_id
4915: , p_start_date => t_start_date_active
4938: , t_end_date_active
4939: , l_action
4940: , l_revert_state
4941: ) LOOP
4942: cn_mark_events_pkg.mark_notify_salesreps(
4943: p_salesrep_id => c_mem_rec.salesrep_id
4944: , p_comp_group_id => NULL
4945: , p_period_id => prd.period_id
4946: , p_start_date => prd.start_date
4959:
4960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4961: fnd_log.STRING(
4962: fnd_log.level_procedure
4963: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.end'
4964: , 'End of mark_notify_team.'
4965: );
4966: END IF;
4967: EXCEPTION
4968: WHEN OTHERS THEN
4969: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
4970: fnd_log.STRING(
4971: fnd_log.level_unexpected
4972: , 'cn.plsql.cn_mark_events_pkg.mark_notify_team.exception'
4973: , SQLERRM
4974: );
4975: END IF;
4976:
4975: END IF;
4976:
4977: RAISE;
4978: END mark_notify_team;
4979: END cn_mark_events_pkg;