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_SRP_PRD_QUOTA_PUB dependencies on FND_API

Line 156: IF NOT FND_API.Compatible_API_Call

152: BEGIN
153: -- Standard Start of API savepoint
154: SAVEPOINT Distribute_Srp_Prd_Quota;
155: -- Standard call to check for call compatibility.
156: IF NOT FND_API.Compatible_API_Call
157: (l_api_version ,
158: p_api_version ,
159: l_api_name ,
160: G_PKG_NAME )

Line 162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

158: p_api_version ,
159: l_api_name ,
160: G_PKG_NAME )
161: THEN
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164: -- Initialize message list if p_init_msg_list is set to TRUE.
165: IF FND_API.to_Boolean( p_init_msg_list ) THEN
166: FND_MSG_PUB.initialize;

Line 165: IF FND_API.to_Boolean( p_init_msg_list ) THEN

161: THEN
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164: -- Initialize message list if p_init_msg_list is set to TRUE.
165: IF FND_API.to_Boolean( p_init_msg_list ) THEN
166: FND_MSG_PUB.initialize;
167: END IF;
168: -- Initialize API return status to success
169: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 169: x_return_status := FND_API.G_RET_STS_SUCCESS;

165: IF FND_API.to_Boolean( p_init_msg_list ) THEN
166: FND_MSG_PUB.initialize;
167: END IF;
168: -- Initialize API return status to success
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170: -- API body
171:
172: -- 0. if the org ID is valid
173: l_org_id := p_org_id;

Line 193: RAISE FND_API.G_EXC_ERROR ;

189: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
190: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PE_NAME', 'INPUT_TOKEN'));
191: FND_MSG_PUB.Add;
192: END IF;
193: RAISE FND_API.G_EXC_ERROR ;
194: END IF;
195:
196: -- Get the Quota ID if exist
197: OPEN l_quota_id_cr(p_pe_name);

Line 207: RAISE FND_API.G_EXC_ERROR ;

203: FND_MESSAGE.SET_NAME ('CN' , 'CN_PLN_NOT_EXIST');
204: FND_MESSAGE.SET_TOKEN ('PE_NAME' , p_pe_name);
205: FND_MSG_PUB.Add;
206: END IF;
207: RAISE FND_API.G_EXC_ERROR ;
208: END IF;
209:
210: CLOSE l_quota_id_cr;
211:

Line 224: RAISE FND_API.G_EXC_ERROR ;

220: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
221: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SR_NAME', 'INPUT_TOKEN'));
222: FND_MSG_PUB.Add;
223: END IF;
224: RAISE FND_API.G_EXC_ERROR ;
225: END IF;
226:
227: OPEN l_salesrep_id_cr(p_salesrep_name, p_employee_number);
228: FETCH l_salesrep_id_cr into f_salesrep_id_rec;

Line 236: RAISE FND_API.G_EXC_ERROR ;

232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
233: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_NOT_FOUND');
234: FND_MSG_PUB.Add;
235: END IF;
236: RAISE FND_API.G_EXC_ERROR ;
237: END IF;
238:
239: CLOSE l_salesrep_id_cr;
240: l_salesrep_id := f_salesrep_id_rec.salesrep_id;

Line 251: RAISE FND_API.G_EXC_ERROR ;

247: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
248: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('ROLE_NAME', 'INPUT_TOKEN'));
249: FND_MSG_PUB.Add;
250: END IF;
251: RAISE FND_API.G_EXC_ERROR ;
252: END IF;
253:
254: OPEN l_role_id_cr(p_role_name);
255: FETCH l_role_id_cr into f_role_id_rec;

Line 263: RAISE FND_API.G_EXC_ERROR ;

259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
260: FND_MESSAGE.SET_NAME ('CN' , 'CN_QM_INVALID_SRPROLE');
261: FND_MSG_PUB.Add;
262: END IF;
263: RAISE FND_API.G_EXC_ERROR ;
264: END IF;
265:
266: CLOSE l_role_id_cr;
267:

Line 278: RAISE FND_API.G_EXC_ERROR ;

274: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
275: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('CP_NAME', 'INPUT_TOKEN'));
276: FND_MSG_PUB.Add;
277: END IF;
278: RAISE FND_API.G_EXC_ERROR ;
279: END IF;
280:
281: OPEN l_comp_plan_id_cr(p_cp_name);
282: FETCH l_comp_plan_id_cr into f_comp_plan_id_rec;

Line 291: RAISE FND_API.G_EXC_ERROR ;

287: FND_MESSAGE.SET_NAME ('CN' , 'CN_CP_NOT_EXIST');
288: FND_MESSAGE.SET_TOKEN ('CP_NAME' , p_cp_name);
289: FND_MSG_PUB.Add;
290: END IF;
291: RAISE FND_API.G_EXC_ERROR ;
292: END IF;
293:
294: CLOSE l_comp_plan_id_cr;
295:

Line 307: RAISE FND_API.G_EXC_ERROR ;

303: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
304: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('SD', 'INPUT_TOKEN'));
305: FND_MSG_PUB.Add;
306: END IF;
307: RAISE FND_API.G_EXC_ERROR ;
308: END IF;
309:
310: OPEN l_srp_plan_assign_id_cr(l_salesrep_id, l_role_id, l_comp_plan_id, p_srp_plan_start_date, p_srp_plan_end_date);
311: FETCH l_srp_plan_assign_id_cr into f_srp_plan_assign_id_rec;

Line 319: RAISE FND_API.G_EXC_ERROR ;

315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
316: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PLN_ASSIGN_NOT_EXIST');
317: FND_MSG_PUB.Add;
318: END IF;
319: RAISE FND_API.G_EXC_ERROR ;
320: END IF;
321:
322: l_srp_plan_assign_id := f_srp_plan_assign_id_rec.srp_plan_assign_id;
323:

Line 335: RAISE FND_API.G_EXC_ERROR ;

331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
332: FND_MESSAGE.SET_NAME ('CN' , 'CN_QUOTA_ASSIGN_NOT_EXIST');
333: FND_MSG_PUB.Add;
334: END IF;
335: RAISE FND_API.G_EXC_ERROR ;
336: END IF;
337:
338: l_srp_quota_assign_id := f_srp_quota_assign_id_rec.srp_quota_assign_id;
339: l_customized_flag := f_srp_quota_assign_id_rec.customized_flag;

Line 347: RAISE FND_API.G_EXC_ERROR ;

343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
344: FND_MESSAGE.SET_NAME ('CN' , 'CN_PE_NOT_CUSTOMIZABLE');
345: FND_MSG_PUB.Add;
346: END IF;
347: RAISE FND_API.G_EXC_ERROR ;
348: END IF;
349:
350: select nvl(target, 0)
351: into f_target_amount

Line 473: RAISE FND_API.G_EXC_ERROR ;

469: FND_MESSAGE.SET_NAME ('CN' , 'CN_INPUT_CANT_NULL');
470: FND_MESSAGE.SET_TOKEN('INPUT_NAME', cn_api.get_lkup_meaning('PERIOD_NAME', 'INPUT_TOKEN'));
471: FND_MSG_PUB.Add;
472: END IF;
473: RAISE FND_API.G_EXC_ERROR ;
474: END IF;
475:
476: OPEN l_period_id_cr(p_srp_prd_quota_tbl(i).period_name);
477: FETCH l_period_id_cr into f_period_id_rec;

Line 484: RAISE FND_API.G_EXC_ERROR ;

480: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
481: FND_MESSAGE.SET_NAME ('CN' , 'CN_PERIOD_NOT_FOUND');
482: FND_MSG_PUB.Add;
483: END IF;
484: RAISE FND_API.G_EXC_ERROR ;
485: END IF;
486:
487: CLOSE l_period_id_cr;
488:

Line 499: RAISE FND_API.G_EXC_ERROR ;

495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
496: FND_MESSAGE.SET_NAME ('CN' , 'CN_SRP_PERIOD_QUOTA_NOT_EXIST');
497: FND_MSG_PUB.Add;
498: END IF;
499: RAISE FND_API.G_EXC_ERROR ;
500: END IF;
501:
502: CLOSE tbl_period_quota_info_cr;
503:

Line 545: IF FND_API.To_Boolean( p_commit ) THEN

541: END IF; --IF p_even_distribute = 'Y' THEN
542:
543: -- End of API body.
544: -- Standard check of p_commit.
545: IF FND_API.To_Boolean( p_commit ) THEN
546: COMMIT WORK;
547: END IF;
548: -- Standard call to get message count and if count is 1, get message info.
549: FND_MSG_PUB.Count_And_Get

Line 552: p_encoded => FND_API.G_FALSE );

548: -- Standard call to get message count and if count is 1, get message info.
549: FND_MSG_PUB.Count_And_Get
550: (p_count => x_msg_count ,
551: p_data => x_msg_data ,
552: p_encoded => FND_API.G_FALSE );
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: ROLLBACK TO Distribute_Srp_Prd_Quota;
556: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 554: WHEN FND_API.G_EXC_ERROR THEN

550: (p_count => x_msg_count ,
551: p_data => x_msg_data ,
552: p_encoded => FND_API.G_FALSE );
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: ROLLBACK TO Distribute_Srp_Prd_Quota;
556: x_return_status := FND_API.G_RET_STS_ERROR ;
557: FND_MSG_PUB.Count_And_Get
558: (p_count => x_msg_count ,

Line 556: x_return_status := FND_API.G_RET_STS_ERROR ;

552: p_encoded => FND_API.G_FALSE );
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: ROLLBACK TO Distribute_Srp_Prd_Quota;
556: x_return_status := FND_API.G_RET_STS_ERROR ;
557: FND_MSG_PUB.Count_And_Get
558: (p_count => x_msg_count ,
559: p_data => x_msg_data ,
560: p_encoded => FND_API.G_FALSE );

Line 560: p_encoded => FND_API.G_FALSE );

556: x_return_status := FND_API.G_RET_STS_ERROR ;
557: FND_MSG_PUB.Count_And_Get
558: (p_count => x_msg_count ,
559: p_data => x_msg_data ,
560: p_encoded => FND_API.G_FALSE );
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: ROLLBACK TO Distribute_Srp_Prd_Quota;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: FND_MSG_PUB.Count_And_Get

Line 561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

557: FND_MSG_PUB.Count_And_Get
558: (p_count => x_msg_count ,
559: p_data => x_msg_data ,
560: p_encoded => FND_API.G_FALSE );
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: ROLLBACK TO Distribute_Srp_Prd_Quota;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: FND_MSG_PUB.Count_And_Get
565: (p_count => x_msg_count ,

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

559: p_data => x_msg_data ,
560: p_encoded => FND_API.G_FALSE );
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: ROLLBACK TO Distribute_Srp_Prd_Quota;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: FND_MSG_PUB.Count_And_Get
565: (p_count => x_msg_count ,
566: p_data => x_msg_data ,
567: p_encoded => FND_API.G_FALSE );

Line 567: p_encoded => FND_API.G_FALSE );

563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
564: FND_MSG_PUB.Count_And_Get
565: (p_count => x_msg_count ,
566: p_data => x_msg_data ,
567: p_encoded => FND_API.G_FALSE );
568: WHEN OTHERS THEN
569: ROLLBACK TO Distribute_Srp_Prd_Quota;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level

Line 570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

566: p_data => x_msg_data ,
567: p_encoded => FND_API.G_FALSE );
568: WHEN OTHERS THEN
569: ROLLBACK TO Distribute_Srp_Prd_Quota;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg

Line 581: p_encoded => FND_API.G_FALSE );

577: END IF;
578: FND_MSG_PUB.Count_And_Get
579: (p_count => x_msg_count ,
580: p_data => x_msg_data ,
581: p_encoded => FND_API.G_FALSE );
582: END Distribute_Srp_Prd_Quota;
583:
584:
585: END CN_SRP_PRD_QUOTA_PUB;