DBA Data[Home] [Help]

APPS.BIS_PMV_SCHED_PARAMETERS_PVT dependencies on FND_MSG_PUB

Line 82: FND_MSG_PUB.INITIALIZE;

78: from bis_user_attributes
79: where schedule_id=pScheduleId and
80: attribute_name = 'AS_OF_DATE';
81: begin
82: FND_MSG_PUB.INITIALIZE;
83: l_user_session_rec.function_name := pFunctionNAme;
84: l_user_session_rec.region_code := pRegionCode;
85: l_user_session_rec.page_id := pPageId;
86: l_user_session_rec.session_id := pSessionId;

Line 411: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

407: EXCEPTION
408: WHEN FND_API.G_EXC_ERROR THEN
409: ROLLBACK;
410: x_return_status := FND_API.G_RET_STS_ERROR;
411: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: ROLLBACK;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

411: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
413: ROLLBACK;
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
416: WHEN OTHERS THEN
417: ROLLBACK;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

Line 419: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

415: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
416: WHEN OTHERS THEN
417: ROLLBACK;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
419: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
420:
421: end;
422: PROCEDURE CREATE_SCHEDULE_PARAMETERS
423: (p_user_param_tbl IN BIS_PMV_PARAMETERS_PVT.parameter_tbl_type

Line 448: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

444: END IF;
445: EXCEPTION
446: WHEN FND_API.G_EXC_ERROR THEN
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
452: WHEN OTHERS THEN

Line 451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

447: x_return_status := FND_API.G_RET_STS_ERROR;
448: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
452: WHEN OTHERS THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
455:

Line 454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
452: WHEN OTHERS THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
455:
456: END;
457: PROCEDURE VALIDATE_AND_SAVE
458: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 502: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

498:
499: EXCEPTION
500: WHEN FND_API.G_EXC_ERROR THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
506: WHEN OTHERS THEN

Line 505: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
509:

Line 508: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
506: WHEN OTHERS THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
509:
510: END;
511: PROCEDURE CREATE_PARAMETER
512: (p_user_session_rec IN BIS_PMV_SESSION_PVT.session_rec_type

Line 546: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

542: sysdate, -1, sysdate, -1);
543: EXCEPTION
544: WHEN FND_API.G_EXC_ERROR THEN
545: x_return_status := FND_API.G_RET_STS_ERROR;
546: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN

Line 549: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

545: x_return_status := FND_API.G_RET_STS_ERROR;
546: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
553:

Line 552: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);

548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
550: WHEN OTHERS THEN
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
552: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count, p_data => x_msg_data);
553:
554: END;
555: end;