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_MSG_PUB

Line 166: FND_MSG_PUB.initialize;

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;
170: -- API body

Line 188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

184: -- 1. IF the PE concerned exists.
185:
186: IF p_pe_name IS NULL
187: THEN
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 191: FND_MSG_PUB.Add;

187: THEN
188: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

Line 202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

198: FETCH l_quota_id_cr into f_quota_id_rec;
199:
200: IF (l_quota_id_cr%NOTFOUND)
201: THEN
202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 205: FND_MSG_PUB.Add;

201: THEN
202: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

Line 219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

215:
216: -- 2. get the salesrep_id using salesrep_name and employee_number
217: IF p_salesrep_name IS NULL
218: THEN
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 222: FND_MSG_PUB.Add;

218: THEN
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

Line 232: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

228: FETCH l_salesrep_id_cr into f_salesrep_id_rec;
229:
230: IF (l_salesrep_id_cr%NOTFOUND)
231: THEN
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 ;

Line 234: FND_MSG_PUB.Add;

230: IF (l_salesrep_id_cr%NOTFOUND)
231: THEN
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:

Line 246: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

242: -- 3. get Role ID
243:
244: IF p_role_name IS NULL
245: THEN
246: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 249: FND_MSG_PUB.Add;

245: THEN
246: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

Line 259: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

255: FETCH l_role_id_cr into f_role_id_rec;
256:
257: IF (l_role_id_cr%NOTFOUND)
258: THEN
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 ;

Line 261: FND_MSG_PUB.Add;

257: IF (l_role_id_cr%NOTFOUND)
258: THEN
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:

Line 273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

269:
270: -- 4. get Comp Plan ID
271: IF p_cp_name IS NULL
272: THEN
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 276: FND_MSG_PUB.Add;

272: THEN
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

Line 286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

282: FETCH l_comp_plan_id_cr into f_comp_plan_id_rec;
283:
284: IF (l_comp_plan_id_cr%NOTFOUND)
285: THEN
286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 289: FND_MSG_PUB.Add;

285: THEN
286: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

Line 302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

298: -- 5. get srp_plan_assign_id using salesrep_id, role_id, comp_plan_id, start_date, end_date
299:
300: IF p_srp_plan_start_date IS NULL
301: THEN
302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 305: FND_MSG_PUB.Add;

301: THEN
302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

Line 315: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

311: FETCH l_srp_plan_assign_id_cr into f_srp_plan_assign_id_rec;
312:
313: IF (l_srp_plan_assign_id_cr%NOTFOUND)
314: THEN
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 ;

Line 317: FND_MSG_PUB.Add;

313: IF (l_srp_plan_assign_id_cr%NOTFOUND)
314: THEN
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:

Line 331: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

327: FETCH l_srp_quota_assign_id_cr into f_srp_quota_assign_id_rec;
328:
329: IF (l_srp_quota_assign_id_cr%NOTFOUND)
330: THEN
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 ;

Line 333: FND_MSG_PUB.Add;

329: IF (l_srp_quota_assign_id_cr%NOTFOUND)
330: THEN
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:

Line 343: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

339: l_customized_flag := f_srp_quota_assign_id_rec.customized_flag;
340:
341: If l_customized_flag <> 'Y'
342: THEN
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 ;

Line 345: FND_MSG_PUB.Add;

341: If l_customized_flag <> 'Y'
342: THEN
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:

Line 468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

464: FOR i IN 1 .. p_srp_prd_quota_tbl.COUNT LOOP
465:
466: IF p_srp_prd_quota_tbl(i).period_name IS NULL
467: THEN
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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;

Line 471: FND_MSG_PUB.Add;

467: THEN
468: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
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:

Line 480: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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;
478: IF (l_period_id_cr%NOTFOUND)
479: THEN
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 ;

Line 482: FND_MSG_PUB.Add;

478: IF (l_period_id_cr%NOTFOUND)
479: THEN
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:

Line 495: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

491: OPEN tbl_period_quota_info_cr(tbl_period_id, l_srp_quota_assign_id);
492: FETCH tbl_period_quota_info_cr into f_period_quota_info_rec;
493: IF (tbl_period_quota_info_cr%NOTFOUND)
494: THEN
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 ;

Line 497: FND_MSG_PUB.Add;

493: IF (tbl_period_quota_info_cr%NOTFOUND)
494: THEN
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:

Line 549: FND_MSG_PUB.Count_And_Get

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
550: (p_count => x_msg_count ,
551: p_data => x_msg_data ,
552: p_encoded => FND_API.G_FALSE );
553: EXCEPTION

Line 557: FND_MSG_PUB.Count_And_Get

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 );
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 564: FND_MSG_PUB.Count_And_Get

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 );
568: WHEN OTHERS THEN

Line 571: IF FND_MSG_PUB.Check_Msg_Level

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
575: (G_PKG_NAME ,

Line 572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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
575: (G_PKG_NAME ,
576: l_api_name );

Line 574: FND_MSG_PUB.Add_Exc_Msg

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
575: (G_PKG_NAME ,
576: l_api_name );
577: END IF;
578: FND_MSG_PUB.Count_And_Get

Line 578: FND_MSG_PUB.Count_And_Get

574: FND_MSG_PUB.Add_Exc_Msg
575: (G_PKG_NAME ,
576: l_api_name );
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;