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