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 FND_API

Line 39: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

35: -- Desc : Procedure to create notification log records for the specified salesrep in the given time period
36: -- and optionally for the given plan element
37: -- Parameters :
38: -- IN p_api_version IN NUMBER Required
39: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
40: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
41: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
42: -- OUT x_return_status OUT VARCHAR2(1)
43: -- x_msg_count OUT NUMBER

Line 40: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

36: -- and optionally for the given plan element
37: -- Parameters :
38: -- IN p_api_version IN NUMBER Required
39: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
40: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
41: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
42: -- OUT x_return_status OUT VARCHAR2(1)
43: -- x_msg_count OUT NUMBER
44: -- x_msg_data OUT VARCHAR2(2000)

Line 41: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

37: -- Parameters :
38: -- IN p_api_version IN NUMBER Required
39: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
40: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
41: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
42: -- OUT x_return_status OUT VARCHAR2(1)
43: -- x_msg_count OUT NUMBER
44: -- x_msg_data OUT VARCHAR2(2000)
45: -- IN p_salesrep_id IN NUMBER

Line 68: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

64: -- End of comments
65:
66: PROCEDURE Mark_Event_Calc
67: (p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE,
70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,

Line 69: p_commit IN VARCHAR2 := FND_API.G_FALSE,

65:
66: PROCEDURE Mark_Event_Calc
67: (p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE,
70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,

Line 70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

66: PROCEDURE Mark_Event_Calc
67: (p_api_version IN NUMBER,
68: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69: p_commit IN VARCHAR2 := FND_API.G_FALSE,
70: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_salesrep_id IN NUMBER,

Line 96: IF NOT FND_API.compatible_api_call

92:
93: -- Standard Start of API savepoint
94: SAVEPOINT mark_event_calc;
95: -- Standard call to check for call compatibility.
96: IF NOT FND_API.compatible_api_call
97: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
98: THEN
99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
100: END IF;

Line 99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

95: -- Standard call to check for call compatibility.
96: IF NOT FND_API.compatible_api_call
97: ( l_api_version ,p_api_version ,l_api_name ,G_PKG_NAME )
98: THEN
99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
100: END IF;
101: -- Initialize message list if p_init_msg_list is set to TRUE.
102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
103: FND_MSG_PUB.initialize;

Line 102: IF FND_API.to_Boolean( p_init_msg_list ) THEN

98: THEN
99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
100: END IF;
101: -- Initialize message list if p_init_msg_list is set to TRUE.
102: IF FND_API.to_Boolean( p_init_msg_list ) THEN
103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: -- Initialize API return status to success

Line 107: x_return_status := FND_API.G_RET_STS_SUCCESS;

103: FND_MSG_PUB.initialize;
104: END IF;
105:
106: -- Initialize API return status to success
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108:
109: -- API body starts here
110: l_org_id := p_org_id;
111: mo_global.validate_orgid_pub_api(org_id => l_org_id,

Line 126: x_return_status := fnd_api.g_ret_sts_error;

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
128: open check_period_id(p_period_id, l_org_id);
129: fetch check_period_id into l_dummy;
130: close check_period_id;

Line 138: x_return_status := fnd_api.g_ret_sts_error;

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;
140: END IF;
141:
142: IF (p_salesrep_id IS NULL) THEN

Line 148: x_return_status := fnd_api.g_ret_sts_error;

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
150: l_dummy := 0;
151: open check_salesrep_id(p_salesrep_id, p_period_id, l_org_id);
152: fetch check_salesrep_id into l_dummy;

Line 149: ELSIF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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
150: l_dummy := 0;
151: open check_salesrep_id(p_salesrep_id, p_period_id, l_org_id);
152: fetch check_salesrep_id into l_dummy;
153: close check_salesrep_id;

Line 161: x_return_status := fnd_api.g_ret_sts_error;

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;
163: END IF;
164:
165: IF (p_quota_id IS NOT NULL) THEN

Line 177: x_return_status := fnd_api.g_ret_sts_error;

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;
179: END IF;
180:
181: if (p_start_date is not null) then

Line 193: x_return_status := fnd_api.g_ret_sts_error;

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;
195: end if;
196:
197: if (p_end_date is not null) then

Line 209: x_return_status := fnd_api.g_ret_sts_error;

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;
211: end if;
212:
213: if (p_start_date is not null and p_end_date is not null and p_start_date > p_end_date) then

Line 219: x_return_status := fnd_api.g_ret_sts_error;

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;
221:
222: if (x_return_status <> FND_API.g_ret_sts_success) then
223: raise FND_API.G_EXC_ERROR;

Line 222: if (x_return_status <> FND_API.g_ret_sts_success) then

218: end if;
219: x_return_status := fnd_api.g_ret_sts_error;
220: end if;
221:
222: if (x_return_status <> FND_API.g_ret_sts_success) then
223: raise FND_API.G_EXC_ERROR;
224: end if;
225:
226: -- if passing all validations, call mark_notify

Line 223: raise FND_API.G_EXC_ERROR;

219: x_return_status := fnd_api.g_ret_sts_error;
220: end if;
221:
222: if (x_return_status <> FND_API.g_ret_sts_success) then
223: raise FND_API.G_EXC_ERROR;
224: end if;
225:
226: -- if passing all validations, call mark_notify
227: cn_mark_events_pkg.mark_notify

Line 240: IF FND_API.To_Boolean( p_commit ) THEN

236:
237: -- End of API body.
238:
239: -- Standard check of p_commit.
240: IF FND_API.To_Boolean( p_commit ) THEN
241: COMMIT WORK;
242: END IF;
243: -- Standard call to get message count and if count is 1, get message info.
244: FND_MSG_PUB.Count_And_Get

Line 248: p_encoded => FND_API.G_FALSE

244: FND_MSG_PUB.Count_And_Get
245: (
246: p_count => x_msg_count ,
247: p_data => x_msg_data ,
248: p_encoded => FND_API.G_FALSE
249: );
250:
251: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
252: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 258: WHEN FND_API.G_EXC_ERROR THEN

254: 'End of mark_event_calc.');
255: end if;
256:
257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN
259: ROLLBACK TO mark_event_calc;
260: x_return_status := FND_API.G_RET_STS_ERROR ;
261: FND_MSG_PUB.Count_And_Get
262: (

Line 260: x_return_status := FND_API.G_RET_STS_ERROR ;

256:
257: EXCEPTION
258: WHEN FND_API.G_EXC_ERROR THEN
259: ROLLBACK TO mark_event_calc;
260: x_return_status := FND_API.G_RET_STS_ERROR ;
261: FND_MSG_PUB.Count_And_Get
262: (
263: p_count => x_msg_count ,
264: p_data => x_msg_data ,

Line 265: p_encoded => FND_API.G_FALSE

261: FND_MSG_PUB.Count_And_Get
262: (
263: p_count => x_msg_count ,
264: p_data => x_msg_data ,
265: p_encoded => FND_API.G_FALSE
266: );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO mark_event_calc;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

263: p_count => x_msg_count ,
264: p_data => x_msg_data ,
265: p_encoded => FND_API.G_FALSE
266: );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO mark_event_calc;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MSG_PUB.Count_And_Get
271: (

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

265: p_encoded => FND_API.G_FALSE
266: );
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO mark_event_calc;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270: FND_MSG_PUB.Count_And_Get
271: (
272: p_count => x_msg_count ,
273: p_data => x_msg_data ,

Line 274: p_encoded => FND_API.G_FALSE

270: FND_MSG_PUB.Count_And_Get
271: (
272: p_count => x_msg_count ,
273: p_data => x_msg_data ,
274: p_encoded => FND_API.G_FALSE
275: );
276: WHEN OTHERS THEN
277: ROLLBACK TO mark_event_calc;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

274: p_encoded => FND_API.G_FALSE
275: );
276: WHEN OTHERS THEN
277: ROLLBACK TO mark_event_calc;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
282: END IF;

Line 287: p_encoded => FND_API.G_FALSE

283: FND_MSG_PUB.Count_And_Get
284: (
285: p_count => x_msg_count ,
286: p_data => x_msg_data ,
287: p_encoded => FND_API.G_FALSE
288: );
289:
290: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
291: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,