DBA Data[Home] [Help]

APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on FND_MSG_PUB

Line 26: FND_MSG_PUB.Add;

22: EXCEPTION
23: WHEN no_data_found THEN
24: -- resource not exist for this user
25: FND_MESSAGE.SET_NAME ('CN','CN_USER_RESOURCE_NF');
26: FND_MSG_PUB.Add;
27: RAISE FND_API.G_EXC_ERROR;
28: END;
29: BEGIN
30: SELECT p.payrun_id,p.pay_period_id INTO x_payrun_id,x_period_id

Line 39: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

35: AND p.org_id = w.org_id
36: ;
37: EXCEPTION
38: WHEN no_data_found THEN
39: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
40: THEN
41: FND_MESSAGE.SET_NAME ('CN','CN_WKSHT_DOES_NOT_EXIST');
42: FND_MSG_PUB.Add;
43: END IF;

Line 42: FND_MSG_PUB.Add;

38: WHEN no_data_found THEN
39: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
40: THEN
41: FND_MESSAGE.SET_NAME ('CN','CN_WKSHT_DOES_NOT_EXIST');
42: FND_MSG_PUB.Add;
43: END IF;
44: RAISE FND_API.G_EXC_ERROR ;
45: END;
46: END Get_Payrun_Info ;

Line 208: FND_MSG_PUB.initialize;

204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
205: END IF;
206: -- Initialize message list if p_init_msg_list is set to TRUE.
207: IF FND_API.to_Boolean( p_init_msg_list ) THEN
208: FND_MSG_PUB.initialize;
209: END IF;
210: -- Initialize API return status to success
211: x_return_status := FND_API.G_RET_STS_SUCCESS;
212: -- API body

Line 250: FND_MSG_PUB.Count_And_Get

246: IF FND_API.To_Boolean( p_commit ) THEN
247: COMMIT WORK;
248: END IF;
249: -- Standard call to get message count and if count is 1, get message info.
250: FND_MSG_PUB.Count_And_Get
251: (p_count => x_msg_count ,
252: p_data => x_msg_data ,
253: p_encoded => FND_API.G_FALSE);
254:

Line 259: FND_MSG_PUB.Count_And_Get

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

Line 267: FND_MSG_PUB.count_and_get

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

Line 275: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

271:
272: WHEN OTHERS THEN
273: ROLLBACK TO Submit_Worksheet ;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
278: END IF;
279: FND_MSG_PUB.Count_And_Get

Line 277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

273: ROLLBACK TO Submit_Worksheet ;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
275: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
278: END IF;
279: FND_MSG_PUB.Count_And_Get
280: (p_count => x_msg_count ,
281: p_data => x_msg_data ,

Line 279: FND_MSG_PUB.Count_And_Get

275: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
278: END IF;
279: FND_MSG_PUB.Count_And_Get
280: (p_count => x_msg_count ,
281: p_data => x_msg_data ,
282: p_encoded => FND_API.G_FALSE);
283:

Line 330: FND_MSG_PUB.initialize;

326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328: -- Initialize message list if p_init_msg_list is set to TRUE.
329: IF FND_API.to_Boolean( p_init_msg_list ) THEN
330: FND_MSG_PUB.initialize;
331: END IF;
332: -- Initialize API return status to success
333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334: -- API body

Line 377: FND_MSG_PUB.Count_And_Get

373: IF FND_API.To_Boolean( p_commit ) THEN
374: COMMIT WORK;
375: END IF;
376: -- Standard call to get message count and if count is 1, get message info.
377: FND_MSG_PUB.Count_And_Get
378: (p_count => x_msg_count ,
379: p_data => x_msg_data ,
380: p_encoded => FND_API.G_FALSE);
381:

Line 386: FND_MSG_PUB.Count_And_Get

382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO Approve_Worksheet ;
385: x_return_status := FND_API.G_RET_STS_ERROR ;
386: FND_MSG_PUB.Count_And_Get
387: (p_count => x_msg_count ,
388: p_data => x_msg_data ,
389: p_encoded => FND_API.G_FALSE);
390:

Line 394: FND_MSG_PUB.count_and_get

390:
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: ROLLBACK TO Approve_Worksheet ;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: FND_MSG_PUB.count_and_get
395: (p_count => x_msg_count ,
396: p_data => x_msg_data ,
397: p_encoded => FND_API.G_FALSE);
398:

Line 402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

398:
399: WHEN OTHERS THEN
400: ROLLBACK TO Approve_Worksheet ;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
405: END IF;
406: FND_MSG_PUB.Count_And_Get

Line 404: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

400: ROLLBACK TO Approve_Worksheet ;
401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
405: END IF;
406: FND_MSG_PUB.Count_And_Get
407: (p_count => x_msg_count ,
408: p_data => x_msg_data ,

Line 406: FND_MSG_PUB.Count_And_Get

402: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
405: END IF;
406: FND_MSG_PUB.Count_And_Get
407: (p_count => x_msg_count ,
408: p_data => x_msg_data ,
409: p_encoded => FND_API.G_FALSE);
410:

Line 457: FND_MSG_PUB.initialize;

453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455: -- Initialize message list if p_init_msg_list is set to TRUE.
456: IF FND_API.to_Boolean( p_init_msg_list ) THEN
457: FND_MSG_PUB.initialize;
458: END IF;
459: -- Initialize API return status to success
460: x_return_status := FND_API.G_RET_STS_SUCCESS;
461: -- API body

Line 496: FND_MSG_PUB.Count_And_Get

492: IF FND_API.To_Boolean( p_commit ) THEN
493: COMMIT WORK;
494: END IF;
495: -- Standard call to get message count and if count is 1, get message info.
496: FND_MSG_PUB.Count_And_Get
497: (p_count => x_msg_count ,
498: p_data => x_msg_data ,
499: p_encoded => FND_API.G_FALSE);
500:

Line 505: FND_MSG_PUB.Count_And_Get

501: EXCEPTION
502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO Reject_Worksheet ;
504: x_return_status := FND_API.G_RET_STS_ERROR ;
505: FND_MSG_PUB.Count_And_Get
506: (p_count => x_msg_count ,
507: p_data => x_msg_data ,
508: p_encoded => FND_API.G_FALSE);
509:

Line 513: FND_MSG_PUB.count_and_get

509:
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: ROLLBACK TO Reject_Worksheet ;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: FND_MSG_PUB.count_and_get
514: (p_count => x_msg_count ,
515: p_data => x_msg_data ,
516: p_encoded => FND_API.G_FALSE);
517:

Line 521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

517:
518: WHEN OTHERS THEN
519: ROLLBACK TO Reject_Worksheet ;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
524: END IF;
525: FND_MSG_PUB.Count_And_Get

Line 523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

519: ROLLBACK TO Reject_Worksheet ;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
524: END IF;
525: FND_MSG_PUB.Count_And_Get
526: (p_count => x_msg_count ,
527: p_data => x_msg_data ,

Line 525: FND_MSG_PUB.Count_And_Get

521: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
524: END IF;
525: FND_MSG_PUB.Count_And_Get
526: (p_count => x_msg_count ,
527: p_data => x_msg_data ,
528: p_encoded => FND_API.G_FALSE);
529:

Line 571: FND_MSG_PUB.initialize;

567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
568: END IF;
569: -- Initialize message list if p_init_msg_list is set to TRUE.
570: IF FND_API.to_Boolean( p_init_msg_list ) THEN
571: FND_MSG_PUB.initialize;
572: END IF;
573: -- Initialize API return status to success
574: x_return_status := FND_API.G_RET_STS_SUCCESS;
575: -- API body

Line 597: FND_MSG_PUB.Count_And_Get

593: IF FND_API.To_Boolean( p_commit ) THEN
594: COMMIT WORK;
595: END IF;
596: -- Standard call to get message count and if count is 1, get message info.
597: FND_MSG_PUB.Count_And_Get
598: (p_count => x_msg_count ,
599: p_data => x_msg_data ,
600: p_encoded => FND_API.G_FALSE);
601:

Line 606: FND_MSG_PUB.Count_And_Get

602: EXCEPTION
603: WHEN FND_API.G_EXC_ERROR THEN
604: ROLLBACK TO Pay_Payrun_Flow ;
605: x_return_status := FND_API.G_RET_STS_ERROR ;
606: FND_MSG_PUB.Count_And_Get
607: (p_count => x_msg_count ,
608: p_data => x_msg_data ,
609: p_encoded => FND_API.G_FALSE);
610:

Line 614: FND_MSG_PUB.count_and_get

610:
611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
612: ROLLBACK TO Pay_Payrun_Flow ;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
614: FND_MSG_PUB.count_and_get
615: (p_count => x_msg_count ,
616: p_data => x_msg_data ,
617: p_encoded => FND_API.G_FALSE);
618:

Line 622: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

618:
619: WHEN OTHERS THEN
620: ROLLBACK TO Pay_Payrun_Flow ;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
622: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
623: THEN
624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
625: END IF;
626: FND_MSG_PUB.Count_And_Get

Line 624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );

620: ROLLBACK TO Pay_Payrun_Flow ;
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
622: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
623: THEN
624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
625: END IF;
626: FND_MSG_PUB.Count_And_Get
627: (p_count => x_msg_count ,
628: p_data => x_msg_data ,

Line 626: FND_MSG_PUB.Count_And_Get

622: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
623: THEN
624: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,l_api_name );
625: END IF;
626: FND_MSG_PUB.Count_And_Get
627: (p_count => x_msg_count ,
628: p_data => x_msg_data ,
629: p_encoded => FND_API.G_FALSE);
630: