DBA Data[Home] [Help]

APPS.BIS_PMV_SCHED_PARAMETERS_PVT dependencies on FND_API

Line 223: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

219: ,x_return_Status => x_return_Status
220: ,x_msg_count => x_msg_count
221: ,x_msg_Data => x_msg_Data);
222:
223: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
224: ROLLBACK;
225: RETURN;
226: END IF;
227:

Line 271: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

267: ,p_parameter_rec => l_parameter_rec
268: ,x_return_status => x_return_status
269: ,x_msg_count => x_msg_count
270: ,x_msg_data => x_msg_data);
271: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
272: ROLLBACK;
273: RETURN;
274: END IF;
275: END IF;

Line 293: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

289: x_return_Status => x_return_status,
290: x_msg_count => x_msg_count,
291: x_msg_data => x_msg_data
292: );
293: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
294: ROLLBACK;
295: RETURN;
296: END IF;
297: l_parameter_rec.dimension := substr(pTimeParameter,1, instr(pTimeParameter,'+')-1);

Line 310: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

306: ,p_parameter_rec => l_parameter_rec
307: ,x_return_status => x_return_status
308: ,x_msg_count => x_msg_count
309: ,x_msg_data => x_msg_data);
310: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
311: ROLLBACK;
312: RETURN;
313: END IF;
314: l_parameter_rec.default_flag := 'N';

Line 400: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

396: ,x_msg_count => x_msg_count
397: ,x_msg_data => x_msg_data);
398:
399:
400: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
401: ROLLBACK;
402: RETURN;
403: END IF;
404: end if;

Line 408: WHEN FND_API.G_EXC_ERROR THEN

404: end if;
405: end if;
406: COMMIT;
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

Line 410: x_return_status := FND_API.G_RET_STS_ERROR;

406: COMMIT;
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;

Line 412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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);
416: WHEN OTHERS THEN
417: ROLLBACK;
418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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);
420:
421: end;
422: PROCEDURE CREATE_SCHEDULE_PARAMETERS

Line 446: WHEN FND_API.G_EXC_ERROR THEN

442: END IF;
443: END LOOP;
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;

Line 447: x_return_status := FND_API.G_RET_STS_ERROR;

443: END LOOP;
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);

Line 449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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);

Line 453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
456: END;
457: PROCEDURE VALIDATE_AND_SAVE

Line 500: WHEN FND_API.G_EXC_ERROR THEN

496: ,x_msg_data => x_msg_data);
497: END IF;
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;

Line 501: x_return_status := FND_API.G_RET_STS_ERROR;

497: END IF;
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);

Line 503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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);

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
510: END;
511: PROCEDURE CREATE_PARAMETER

Line 544: WHEN FND_API.G_EXC_ERROR THEN

540: p_parameter_rec.period_date, l_dimension,
541: p_parameter_rec.operator,
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;

Line 545: x_return_status := FND_API.G_RET_STS_ERROR;

541: p_parameter_rec.operator,
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);

Line 547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
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);

Line 551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
554: END;
555: end;