159: )
160: ) THEN
161: fnd_message.set_name('IGS','IGS_AS_PLAN_EXISTS_CAL');
162: FND_MSG_PUB.ADD;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165: END IF;
166: END IF;
167: END before_dml;
297: END IF;
298: CLOSE c;
299:
300: -- Initialize API return status to success.
301: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
302: -- Standard call to get message count and if count is 1, get message
303: -- info.
304: FND_MSG_PUB.Count_And_Get(
305: p_encoded => FND_API.G_FALSE,
301: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
302: -- Standard call to get message count and if count is 1, get message
303: -- info.
304: FND_MSG_PUB.Count_And_Get(
305: p_encoded => FND_API.G_FALSE,
306: p_count => x_MSG_COUNT,
307: p_data => X_MSG_DATA);
308:
309: EXCEPTION
306: p_count => x_MSG_COUNT,
307: p_data => X_MSG_DATA);
308:
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
312: FND_MSG_PUB.Count_And_Get(
313: p_encoded => FND_API.G_FALSE,
314: p_count => x_MSG_COUNT,
307: p_data => X_MSG_DATA);
308:
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
312: FND_MSG_PUB.Count_And_Get(
313: p_encoded => FND_API.G_FALSE,
314: p_count => x_MSG_COUNT,
315: p_data => X_MSG_DATA);
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
312: FND_MSG_PUB.Count_And_Get(
313: p_encoded => FND_API.G_FALSE,
314: p_count => x_MSG_COUNT,
315: p_data => X_MSG_DATA);
316: RETURN;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: p_encoded => FND_API.G_FALSE,
314: p_count => x_MSG_COUNT,
315: p_data => X_MSG_DATA);
316: RETURN;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_MSG_COUNT,
314: p_count => x_MSG_COUNT,
315: p_data => X_MSG_DATA);
316: RETURN;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_MSG_COUNT,
322: p_data => X_MSG_DATA);
316: RETURN;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
319: FND_MSG_PUB.Count_And_Get(
320: p_encoded => FND_API.G_FALSE,
321: p_count => x_MSG_COUNT,
322: p_data => X_MSG_DATA);
323: RETURN;
324: WHEN OTHERS THEN
321: p_count => x_MSG_COUNT,
322: p_data => X_MSG_DATA);
323: RETURN;
324: WHEN OTHERS THEN
325: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
326: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
327: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.Count_And_Get(
326: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
327: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
328: FND_MSG_PUB.ADD;
329: FND_MSG_PUB.Count_And_Get(
330: p_encoded => FND_API.G_FALSE,
331: p_count => x_MSG_COUNT,
332: p_data => X_MSG_DATA);
333: RETURN;
334:
416: NULL;
417: ELSE
418: fnd_message.set_name('FND', '*'||x_rowid||'*');
419: FND_MSG_PUB.ADD;
420: RAISE FND_API.G_EXC_ERROR;
421: END IF;
422:
423:
424: -- Initialize API return status to success.
421: END IF;
422:
423:
424: -- Initialize API return status to success.
425: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
426: -- Standard call to get message count and if count is 1, get message
427: -- info.
428: FND_MSG_PUB.Count_And_Get(
429: p_encoded => FND_API.G_FALSE,
425: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
426: -- Standard call to get message count and if count is 1, get message
427: -- info.
428: FND_MSG_PUB.Count_And_Get(
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_MSG_COUNT,
431: p_data => X_MSG_DATA);
432: RETURN;
433: EXCEPTION
430: p_count => x_MSG_COUNT,
431: p_data => X_MSG_DATA);
432: RETURN;
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.Count_And_Get(
437: p_encoded => FND_API.G_FALSE,
438: p_count => x_MSG_COUNT,
431: p_data => X_MSG_DATA);
432: RETURN;
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.Count_And_Get(
437: p_encoded => FND_API.G_FALSE,
438: p_count => x_MSG_COUNT,
439: p_data => X_MSG_DATA);
433: EXCEPTION
434: WHEN FND_API.G_EXC_ERROR THEN
435: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.Count_And_Get(
437: p_encoded => FND_API.G_FALSE,
438: p_count => x_MSG_COUNT,
439: p_data => X_MSG_DATA);
440: RETURN;
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: p_encoded => FND_API.G_FALSE,
438: p_count => x_MSG_COUNT,
439: p_data => X_MSG_DATA);
440: RETURN;
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.Count_And_Get(
444: p_encoded => FND_API.G_FALSE,
445: p_count => x_MSG_COUNT,
438: p_count => x_MSG_COUNT,
439: p_data => X_MSG_DATA);
440: RETURN;
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.Count_And_Get(
444: p_encoded => FND_API.G_FALSE,
445: p_count => x_MSG_COUNT,
446: p_data => X_MSG_DATA);
440: RETURN;
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.Count_And_Get(
444: p_encoded => FND_API.G_FALSE,
445: p_count => x_MSG_COUNT,
446: p_data => X_MSG_DATA);
447: RETURN;
448: WHEN OTHERS THEN
445: p_count => x_MSG_COUNT,
446: p_data => X_MSG_DATA);
447: RETURN;
448: WHEN OTHERS THEN
449: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
451: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.Count_And_Get(
450: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
451: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
452: FND_MSG_PUB.ADD;
453: FND_MSG_PUB.Count_And_Get(
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_MSG_COUNT,
456: p_data => X_MSG_DATA);
457: RETURN;
458:
573: EXCEPTION
574: WHEN OTHERS THEN
575: FND_MESSAGE.SET_NAME ('IGS','IGS_AS_TRNS_RECLC_ERR');
576: FND_MSG_PUB.ADD;
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END;
579:
580:
581: -- Initialize API return status to success.
578: END;
579:
580:
581: -- Initialize API return status to success.
582: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
583: -- Standard call to get message count and if count is 1, get message
584: -- info.
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
582: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
583: -- Standard call to get message count and if count is 1, get message
584: -- info.
585: FND_MSG_PUB.Count_And_Get(
586: p_encoded => FND_API.G_FALSE,
587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589:
590: EXCEPTION
587: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_MSG_COUNT,
588: p_data => X_MSG_DATA);
589:
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_MSG_COUNT,
596: p_data => X_MSG_DATA);
590: EXCEPTION
591: WHEN FND_API.G_EXC_ERROR THEN
592: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_MSG_COUNT,
596: p_data => X_MSG_DATA);
597: RETURN;
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_MSG_COUNT,
596: p_data => X_MSG_DATA);
597: RETURN;
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_MSG_COUNT,
595: p_count => x_MSG_COUNT,
596: p_data => X_MSG_DATA);
597: RETURN;
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_MSG_COUNT,
603: p_data => X_MSG_DATA);
597: RETURN;
598: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
599: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
600: FND_MSG_PUB.Count_And_Get(
601: p_encoded => FND_API.G_FALSE,
602: p_count => x_MSG_COUNT,
603: p_data => X_MSG_DATA);
604: RETURN;
605: WHEN OTHERS THEN
602: p_count => x_MSG_COUNT,
603: p_data => X_MSG_DATA);
604: RETURN;
605: WHEN OTHERS THEN
606: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
607: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
608: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
609: FND_MSG_PUB.ADD;
610: FND_MSG_PUB.Count_And_Get(
607: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
608: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
609: FND_MSG_PUB.ADD;
610: FND_MSG_PUB.Count_And_Get(
611: p_encoded => FND_API.G_FALSE,
612: p_count => x_MSG_COUNT,
613: p_data => X_MSG_DATA);
614: RETURN;
615:
729: IF (SQL%NOTFOUND) THEN
730: RAISE NO_DATA_FOUND;
731: END IF;
732: -- Initialize API return status to success.
733: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
734: -- Standard call to get message count and if count is 1, get message
735: -- info.
736: FND_MSG_PUB.Count_And_Get(
737: p_encoded => FND_API.G_FALSE,
733: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
734: -- Standard call to get message count and if count is 1, get message
735: -- info.
736: FND_MSG_PUB.Count_And_Get(
737: p_encoded => FND_API.G_FALSE,
738: p_count => x_MSG_COUNT,
739: p_data => X_MSG_DATA);
740:
741: EXCEPTION
738: p_count => x_MSG_COUNT,
739: p_data => X_MSG_DATA);
740:
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,
739: p_data => X_MSG_DATA);
740:
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);
741: EXCEPTION
742: WHEN FND_API.G_EXC_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);
748: RETURN;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);
748: RETURN;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_And_Get(
752: p_encoded => FND_API.G_FALSE,
753: p_count => x_MSG_COUNT,
746: p_count => x_MSG_COUNT,
747: p_data => X_MSG_DATA);
748: RETURN;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_And_Get(
752: p_encoded => FND_API.G_FALSE,
753: p_count => x_MSG_COUNT,
754: p_data => X_MSG_DATA);
748: RETURN;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_And_Get(
752: p_encoded => FND_API.G_FALSE,
753: p_count => x_MSG_COUNT,
754: p_data => X_MSG_DATA);
755: RETURN;
756: WHEN OTHERS THEN
753: p_count => x_MSG_COUNT,
754: p_data => X_MSG_DATA);
755: RETURN;
756: WHEN OTHERS THEN
757: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
758: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
759: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
760: FND_MSG_PUB.ADD;
761: FND_MSG_PUB.Count_And_Get(
758: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
759: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
760: FND_MSG_PUB.ADD;
761: FND_MSG_PUB.Count_And_Get(
762: p_encoded => FND_API.G_FALSE,
763: p_count => x_MSG_COUNT,
764: p_data => X_MSG_DATA);
765: RETURN;
766: