DBA Data[Home] [Help]

APPS.IGS_AZ_ADVISING_RELS_PKG dependencies on FND_MSG_PUB

Line 436: FND_MSG_PUB.initialize;

432: x_last_updated_by NUMBER;
433: x_last_update_login NUMBER;
434:
435: BEGIN
436: FND_MSG_PUB.initialize;
437: x_last_update_date := SYSDATE;
438: IF (x_mode = 'I') THEN
439: x_last_updated_by := 1;
440: x_last_update_login := 0;

Line 502: FND_MSG_PUB.Count_And_Get(

498: x_last_update_login
499: ) RETURNING ROWID, group_advising_rel_id INTO x_rowid, x_group_advising_rel_id;
500: -- Standard call to get message count and if count is 1, get message
501: -- info.
502: FND_MSG_PUB.Count_And_Get(
503: p_encoded => FND_API.G_FALSE,
504: p_count => x_MSG_COUNT,
505: p_data => X_MSG_DATA);
506: EXCEPTION

Line 509: FND_MSG_PUB.Count_And_Get(

505: p_data => X_MSG_DATA);
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR THEN
508: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
509: FND_MSG_PUB.Count_And_Get(
510: p_encoded => FND_API.G_FALSE,
511: p_count => x_MSG_COUNT,
512: p_data => X_MSG_DATA);
513: RETURN;

Line 516: FND_MSG_PUB.Count_And_Get(

512: p_data => X_MSG_DATA);
513: RETURN;
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
516: FND_MSG_PUB.Count_And_Get(
517: p_encoded => FND_API.G_FALSE,
518: p_count => x_MSG_COUNT,
519: p_data => X_MSG_DATA);
520: RETURN;

Line 525: FND_MSG_PUB.ADD;

521: WHEN OTHERS THEN
522: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
523: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
524: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
525: FND_MSG_PUB.ADD;
526: FND_MSG_PUB.Count_And_Get(
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_MSG_COUNT,
529: p_data => X_MSG_DATA);

Line 526: FND_MSG_PUB.Count_And_Get(

522: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
523: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
524: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
525: FND_MSG_PUB.ADD;
526: FND_MSG_PUB.Count_And_Get(
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_MSG_COUNT,
529: p_data => X_MSG_DATA);
530: RETURN;

Line 570: FND_MSG_PUB.initialize;

566:
567: tlinfo c1%ROWTYPE;
568:
569: BEGIN
570: FND_MSG_PUB.initialize;
571: OPEN c1;
572: FETCH c1 INTO tlinfo;
573: IF (c1%notfound) THEN
574: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line 599: FND_MSG_PUB.Count_And_Get(

595: -- Initialize API return status to success.
596: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
597: -- Standard call to get message count and if count is 1, get message
598: -- info.
599: FND_MSG_PUB.Count_And_Get(
600: p_encoded => FND_API.G_FALSE,
601: p_count => x_MSG_COUNT,
602: p_data => X_MSG_DATA);
603: RETURN;

Line 607: FND_MSG_PUB.Count_And_Get(

603: RETURN;
604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN
606: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
607: FND_MSG_PUB.Count_And_Get(
608: p_encoded => FND_API.G_FALSE,
609: p_count => x_MSG_COUNT,
610: p_data => X_MSG_DATA);
611: RETURN;

Line 614: FND_MSG_PUB.Count_And_Get(

610: p_data => X_MSG_DATA);
611: RETURN;
612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
613: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 623: FND_MSG_PUB.ADD;

619: WHEN OTHERS THEN
620: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
622: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
623: FND_MSG_PUB.ADD;
624: FND_MSG_PUB.Count_And_Get(
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_MSG_COUNT,
627: p_data => X_MSG_DATA);

Line 624: FND_MSG_PUB.Count_And_Get(

620: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
621: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
622: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
623: FND_MSG_PUB.ADD;
624: FND_MSG_PUB.Count_And_Get(
625: p_encoded => FND_API.G_FALSE,
626: p_count => x_MSG_COUNT,
627: p_data => X_MSG_DATA);
628: RETURN;

Line 661: FND_MSG_PUB.initialize;

657: x_last_update_login NUMBER;
658:
659:
660: BEGIN
661: FND_MSG_PUB.initialize;
662: x_last_update_date := SYSDATE;
663: IF (X_MODE = 'I') THEN
664: x_last_updated_by := 1;
665: x_last_update_login := 0;

Line 730: FND_MSG_PUB.Count_And_Get(

726: -- Initialize API return status to success.
727: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
728: -- Standard call to get message count and if count is 1, get message
729: -- info.
730: FND_MSG_PUB.Count_And_Get(
731: p_encoded => FND_API.G_FALSE,
732: p_count => x_MSG_COUNT,
733: p_data => X_MSG_DATA);
734: EXCEPTION

Line 737: FND_MSG_PUB.Count_And_Get(

733: p_data => X_MSG_DATA);
734: EXCEPTION
735: WHEN FND_API.G_EXC_ERROR THEN
736: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
737: FND_MSG_PUB.Count_And_Get(
738: p_encoded => FND_API.G_FALSE,
739: p_count => x_MSG_COUNT,
740: p_data => X_MSG_DATA);
741: RETURN;

Line 744: FND_MSG_PUB.Count_And_Get(

740: p_data => X_MSG_DATA);
741: RETURN;
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
743: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_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;

Line 753: FND_MSG_PUB.ADD;

749: WHEN OTHERS THEN
750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
752: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
753: FND_MSG_PUB.ADD;
754: FND_MSG_PUB.Count_And_Get(
755: p_encoded => FND_API.G_FALSE,
756: p_count => x_MSG_COUNT,
757: p_data => X_MSG_DATA);

Line 754: FND_MSG_PUB.Count_And_Get(

750: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
752: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
753: FND_MSG_PUB.ADD;
754: FND_MSG_PUB.Count_And_Get(
755: p_encoded => FND_API.G_FALSE,
756: p_count => x_MSG_COUNT,
757: p_data => X_MSG_DATA);
758: RETURN;

Line 848: FND_MSG_PUB.initialize;

844: || Who When What
845: || (reverse chronological order - newest change first)
846: */
847: BEGIN
848: FND_MSG_PUB.initialize;
849: before_dml (
850: p_action => 'DELETE',
851: x_rowid => x_rowid
852: );

Line 864: FND_MSG_PUB.Count_And_Get(

860: -- Initialize API return status to success.
861: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
862: -- Standard call to get message count and if count is 1, get message
863: -- info.
864: FND_MSG_PUB.Count_And_Get(
865: p_encoded => FND_API.G_FALSE,
866: p_count => x_MSG_COUNT,
867: p_data => X_MSG_DATA);
868: EXCEPTION

Line 871: FND_MSG_PUB.Count_And_Get(

867: p_data => X_MSG_DATA);
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;

Line 878: FND_MSG_PUB.Count_And_Get(

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;

Line 887: FND_MSG_PUB.ADD;

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

Line 888: FND_MSG_PUB.Count_And_Get(

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;