397: x_last_updated_by NUMBER;
398: x_last_update_login NUMBER;
399:
400: BEGIN
401: FND_MSG_PUB.initialize;
402: x_last_update_date := SYSDATE;
403: IF (x_mode = 'I') THEN
404: x_last_updated_by := 1;
405: x_last_update_login := 0;
475: -- Initialize API return status to success.
476: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
477: -- Standard call to get message count and if count is 1, get message
478: -- info.
479: FND_MSG_PUB.Count_And_Get(
480: p_encoded => FND_API.G_FALSE,
481: p_count => x_MSG_COUNT,
482: p_data => X_MSG_DATA);
483:
483:
484: EXCEPTION
485: WHEN FND_API.G_EXC_ERROR THEN
486: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
487: FND_MSG_PUB.Count_And_Get(
488: p_encoded => FND_API.G_FALSE,
489: p_count => x_MSG_COUNT,
490: p_data => X_MSG_DATA);
491: RETURN;
490: p_data => X_MSG_DATA);
491: RETURN;
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
494: FND_MSG_PUB.Count_And_Get(
495: p_encoded => FND_API.G_FALSE,
496: p_count => x_MSG_COUNT,
497: p_data => X_MSG_DATA);
498: RETURN;
499: WHEN OTHERS THEN
500: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
502: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
503: FND_MSG_PUB.ADD;
504: FND_MSG_PUB.Count_And_Get(
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_MSG_COUNT,
507: p_data => X_MSG_DATA);
500: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
501: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
502: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
503: FND_MSG_PUB.ADD;
504: FND_MSG_PUB.Count_And_Get(
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_MSG_COUNT,
507: p_data => X_MSG_DATA);
508: RETURN;
551:
552: tlinfo c1%ROWTYPE;
553:
554: BEGIN
555: FND_MSG_PUB.initialize;
556: OPEN c1;
557: FETCH c1 INTO tlinfo;
558: IF (c1%NOTFOUND) THEN
559: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
585: -- Initialize API return status to success.
586: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
587: -- Standard call to get message count and if count is 1, get message
588: -- info.
589: FND_MSG_PUB.Count_And_Get(
590: p_encoded => FND_API.G_FALSE,
591: p_count => x_MSG_COUNT,
592: p_data => X_MSG_DATA);
593: RETURN;
593: RETURN;
594: EXCEPTION
595: WHEN FND_API.G_EXC_ERROR THEN
596: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
597: FND_MSG_PUB.Count_And_Get(
598: p_encoded => FND_API.G_FALSE,
599: p_count => x_MSG_COUNT,
600: p_data => X_MSG_DATA);
601: RETURN;
600: p_data => X_MSG_DATA);
601: RETURN;
602: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
603: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_And_Get(
605: p_encoded => FND_API.G_FALSE,
606: p_count => x_MSG_COUNT,
607: p_data => X_MSG_DATA);
608: RETURN;
609: WHEN OTHERS THEN
610: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
612: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
613: FND_MSG_PUB.ADD;
614: FND_MSG_PUB.Count_And_Get(
615: p_encoded => FND_API.G_FALSE,
616: p_count => x_MSG_COUNT,
617: p_data => X_MSG_DATA);
610: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
612: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
613: FND_MSG_PUB.ADD;
614: FND_MSG_PUB.Count_And_Get(
615: p_encoded => FND_API.G_FALSE,
616: p_count => x_MSG_COUNT,
617: p_data => X_MSG_DATA);
618: RETURN;
651: x_last_updated_by NUMBER;
652: x_last_update_login NUMBER;
653:
654: BEGIN
655: FND_MSG_PUB.initialize;
656: x_last_update_date := SYSDATE;
657: IF (X_MODE = 'I') THEN
658: x_last_updated_by := 1;
659: x_last_update_login := 0;
713: -- Initialize API return status to success.
714: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
715: -- Standard call to get message count and if count is 1, get message
716: -- info.
717: FND_MSG_PUB.Count_And_Get(
718: p_encoded => FND_API.G_FALSE,
719: p_count => x_MSG_COUNT,
720: p_data => X_MSG_DATA);
721:
721:
722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN
724: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.Count_And_Get(
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_MSG_COUNT,
728: p_data => X_MSG_DATA);
729: RETURN;
728: p_data => X_MSG_DATA);
729: RETURN;
730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
731: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
732: FND_MSG_PUB.Count_And_Get(
733: p_encoded => FND_API.G_FALSE,
734: p_count => x_MSG_COUNT,
735: p_data => X_MSG_DATA);
736: RETURN;
737: WHEN OTHERS THEN
738: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
739: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
740: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
741: FND_MSG_PUB.ADD;
742: FND_MSG_PUB.Count_And_Get(
743: p_encoded => FND_API.G_FALSE,
744: p_count => x_MSG_COUNT,
745: p_data => X_MSG_DATA);
738: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
739: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
740: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
741: FND_MSG_PUB.ADD;
742: FND_MSG_PUB.Count_And_Get(
743: p_encoded => FND_API.G_FALSE,
744: p_count => x_MSG_COUNT,
745: p_data => X_MSG_DATA);
746: RETURN;
843: || Who When What
844: || (reverse chronological order - newest change first)
845: */
846: BEGIN
847: FND_MSG_PUB.initialize;
848: before_dml (
849: p_action => 'DELETE',
850: x_rowid => x_rowid
851: );
859: -- Initialize API return status to success.
860: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
861: -- Standard call to get message count and if count is 1, get message
862: -- info.
863: FND_MSG_PUB.Count_And_Get(
864: p_encoded => FND_API.G_FALSE,
865: p_count => x_MSG_COUNT,
866: p_data => X_MSG_DATA);
867:
867:
868: EXCEPTION
869: WHEN FND_API.G_EXC_ERROR THEN
870: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
871: FND_MSG_PUB.Count_And_Get(
872: p_encoded => FND_API.G_FALSE,
873: p_count => x_MSG_COUNT,
874: p_data => X_MSG_DATA);
875: RETURN;
874: p_data => X_MSG_DATA);
875: RETURN;
876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
877: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
878: FND_MSG_PUB.Count_And_Get(
879: p_encoded => FND_API.G_FALSE,
880: p_count => x_MSG_COUNT,
881: p_data => X_MSG_DATA);
882: RETURN;
883: WHEN OTHERS THEN
884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
886: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
890: p_count => x_MSG_COUNT,
891: p_data => X_MSG_DATA);
884: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
886: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
890: p_count => x_MSG_COUNT,
891: p_data => X_MSG_DATA);
892: RETURN;