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_PUB dependencies on CN_MARK_EVENTS_PUB

Line 1: PACKAGE BODY cn_mark_events_pub AS

1: PACKAGE BODY cn_mark_events_pub AS
2: /* $Header: cnpmkevb.pls 120.0 2006/08/25 00:19:15 ymao noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_MARK_EVENTS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpmkevb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_MARK_EVENTS_PUB';

1: PACKAGE BODY cn_mark_events_pub AS
2: /* $Header: cnpmkevb.pls 120.0 2006/08/25 00:19:15 ymao noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_MARK_EVENTS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpmkevb.pls';
6:
7: cursor check_period_id(p_period_id number, p_org_id number) is
8: select 1 from cn_period_statuses_all

Line 89: 'cn.plsql.cn_mark_events_pub.mark_event_calc.begin',

85: l_dummy NUMBER := 0;
86: BEGIN
87: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
88: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
89: 'cn.plsql.cn_mark_events_pub.mark_event_calc.begin',
90: 'Beginning of mark_event_calc for resource ('||p_salesrep_id||') ...');
91: end if;
92:
93: -- Standard Start of API savepoint

Line 116: 'cn.plsql.cn_mark_events_pub.mark_event_calc.org_validate',

112: status => l_status);
113:
114: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
115: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
116: 'cn.plsql.cn_mark_events_pub.mark_event_calc.org_validate',
117: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
118: end if;
119:
120: IF (p_period_id IS NULL) THEN

Line 123: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',

119:
120: IF (p_period_id IS NULL) THEN
121: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
122: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
123: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',
124: 'p_period_id is null');
125: end if;
126: x_return_status := fnd_api.g_ret_sts_error;
127: ELSE

Line 135: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',

131:
132: if (l_dummy <> 1) then
133: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
134: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
135: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',
136: 'p_period_id is not valid');
137: end if;
138: x_return_status := fnd_api.g_ret_sts_error;
139: end if;

Line 145: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',

141:
142: IF (p_salesrep_id IS NULL) THEN
143: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
144: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
145: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',
146: 'p_salesrep_id is null');
147: end if;
148: x_return_status := fnd_api.g_ret_sts_error;
149: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 158: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',

154:
155: if (l_dummy <> 1) then
156: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
157: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
158: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',
159: 'p_salesrep_id does not have valid setup in the given operating unit');
160: end if;
161: x_return_status := fnd_api.g_ret_sts_error;
162: end if;

Line 174: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',

170:
171: if (l_dummy <> 1) then
172: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
173: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
174: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',
175: 'p_quota_id is not valid in the given operating unit');
176: end if;
177: x_return_status := fnd_api.g_ret_sts_error;
178: end if;

Line 190: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',

186:
187: if (l_dummy <> 1) then
188: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
189: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
190: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',
191: 'p_start_date is not within the given period');
192: end if;
193: x_return_status := fnd_api.g_ret_sts_error;
194: end if;

Line 206: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',

202:
203: if (l_dummy <> 1) then
204: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
205: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
206: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',
207: 'p_end_date is not within the given period');
208: end if;
209: x_return_status := fnd_api.g_ret_sts_error;
210: end if;

Line 216: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',

212:
213: if (p_start_date is not null and p_end_date is not null and p_start_date > p_end_date) then
214: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
215: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,
216: 'cn.plsql.cn_mark_events_pub.mark_event_calc.error',
217: 'p_start_date is greater than p_end_date');
218: end if;
219: x_return_status := fnd_api.g_ret_sts_error;
220: end if;

Line 253: 'cn.plsql.cn_mark_events_pub.mark_event_calc.end',

249: );
250:
251: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
252: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
253: 'cn.plsql.cn_mark_events_pub.mark_event_calc.end',
254: 'End of mark_event_calc.');
255: end if;
256:
257: EXCEPTION

Line 292: 'cn.plsql.cn_mark_events_pub.mark_event_calc.exception',

288: );
289:
290: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
291: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
292: 'cn.plsql.cn_mark_events_pub.mark_event_calc.exception',
293: sqlerrm);
294: end if;
295:
296: END Mark_Event_Calc;

Line 299: END cn_mark_events_pub ;

295:
296: END Mark_Event_Calc;
297:
298:
299: END cn_mark_events_pub ;