DBA Data[Home] [Help]

APPS.IGS_AZ_ADVISORS_PKG dependencies on FND_MSG_PUB

Line 380: FND_MSG_PUB.initialize;

376: x_last_update_login NUMBER;
377:
378: BEGIN
379:
380: FND_MSG_PUB.initialize;
381: x_last_update_date := SYSDATE;
382: IF (x_mode = 'I') THEN
383: x_last_updated_by := 1;
384: x_last_update_login := 0;

Line 457: FND_MSG_PUB.Count_And_Get(

453:
454: -- Initialize API return status to success.
455: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
456: -- Standard call to get message count and if count is 1, get message info.
457: FND_MSG_PUB.Count_And_Get(
458: p_encoded => FND_API.G_FALSE,
459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);
461: EXCEPTION

Line 464: FND_MSG_PUB.Count_And_Get(

460: p_data => X_MSG_DATA);
461: EXCEPTION
462: WHEN FND_API.G_EXC_ERROR THEN
463: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
464: FND_MSG_PUB.Count_And_Get(
465: p_encoded => FND_API.G_FALSE,
466: p_count => x_MSG_COUNT,
467: p_data => X_MSG_DATA);
468: RETURN;

Line 471: FND_MSG_PUB.Count_And_Get(

467: p_data => X_MSG_DATA);
468: RETURN;
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
471: FND_MSG_PUB.Count_And_Get(
472: p_encoded => FND_API.G_FALSE,
473: p_count => x_MSG_COUNT,
474: p_data => X_MSG_DATA);
475: RETURN;

Line 480: FND_MSG_PUB.ADD;

476: WHEN OTHERS THEN
477: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
479: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
480: FND_MSG_PUB.ADD;
481: FND_MSG_PUB.Count_And_Get(
482: p_encoded => FND_API.G_FALSE,
483: p_count => x_MSG_COUNT,
484: p_data => X_MSG_DATA);

Line 481: FND_MSG_PUB.Count_And_Get(

477: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
479: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
480: FND_MSG_PUB.ADD;
481: FND_MSG_PUB.Count_And_Get(
482: p_encoded => FND_API.G_FALSE,
483: p_count => x_MSG_COUNT,
484: p_data => X_MSG_DATA);
485: RETURN;

Line 532: FND_MSG_PUB.initialize;

528: tlinfo c1%ROWTYPE;
529:
530: BEGIN
531:
532: FND_MSG_PUB.initialize;
533: OPEN c1;
534: FETCH c1 INTO tlinfo;
535: IF (c1%notfound) THEN
536: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line 564: FND_MSG_PUB.Count_And_Get(

560:
561: -- Initialize API return status to success.
562: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
563: -- Standard call to get message count and if count is 1, get message info.
564: FND_MSG_PUB.Count_And_Get(
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_MSG_COUNT,
567: p_data => X_MSG_DATA);
568: RETURN;

Line 573: FND_MSG_PUB.Count_And_Get(

569:
570: EXCEPTION
571: WHEN FND_API.G_EXC_ERROR THEN
572: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
573: FND_MSG_PUB.Count_And_Get(
574: p_encoded => FND_API.G_FALSE,
575: p_count => x_MSG_COUNT,
576: p_data => X_MSG_DATA);
577: RETURN;

Line 580: FND_MSG_PUB.Count_And_Get(

576: p_data => X_MSG_DATA);
577: RETURN;
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.Count_And_Get(
581: p_encoded => FND_API.G_FALSE,
582: p_count => x_MSG_COUNT,
583: p_data => X_MSG_DATA);
584: RETURN;

Line 589: FND_MSG_PUB.ADD;

585: WHEN OTHERS THEN
586: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
587: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
588: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
589: FND_MSG_PUB.ADD;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_MSG_COUNT,
593: p_data => X_MSG_DATA);

Line 590: FND_MSG_PUB.Count_And_Get(

586: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
587: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
588: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
589: FND_MSG_PUB.ADD;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_MSG_COUNT,
593: p_data => X_MSG_DATA);
594: RETURN;

Line 630: FND_MSG_PUB.initialize;

626: x_last_update_login NUMBER;
627:
628: BEGIN
629:
630: FND_MSG_PUB.initialize;
631: x_last_update_date := SYSDATE;
632: IF (X_MODE = 'I') THEN
633: x_last_updated_by := 1;
634: x_last_update_login := 0;

Line 705: FND_MSG_PUB.Count_And_Get(

701:
702: -- Initialize API return status to success.
703: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
704: -- Standard call to get message count and if count is 1, get message info.
705: FND_MSG_PUB.Count_And_Get(
706: p_encoded => FND_API.G_FALSE,
707: p_count => x_MSG_COUNT,
708: p_data => X_MSG_DATA);
709: EXCEPTION

Line 712: FND_MSG_PUB.Count_And_Get(

708: p_data => X_MSG_DATA);
709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN
711: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
712: FND_MSG_PUB.Count_And_Get(
713: p_encoded => FND_API.G_FALSE,
714: p_count => x_MSG_COUNT,
715: p_data => X_MSG_DATA);
716: RETURN;

Line 719: FND_MSG_PUB.Count_And_Get(

715: p_data => X_MSG_DATA);
716: RETURN;
717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
718: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
719: FND_MSG_PUB.Count_And_Get(
720: p_encoded => FND_API.G_FALSE,
721: p_count => x_MSG_COUNT,
722: p_data => X_MSG_DATA);
723: RETURN;

Line 728: FND_MSG_PUB.ADD;

724: WHEN OTHERS THEN
725: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
726: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
727: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
728: FND_MSG_PUB.ADD;
729: FND_MSG_PUB.Count_And_Get(
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_MSG_COUNT,
732: p_data => X_MSG_DATA);

Line 729: FND_MSG_PUB.Count_And_Get(

725: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
726: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
727: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
728: FND_MSG_PUB.ADD;
729: FND_MSG_PUB.Count_And_Get(
730: p_encoded => FND_API.G_FALSE,
731: p_count => x_MSG_COUNT,
732: p_data => X_MSG_DATA);
733: RETURN;

Line 833: FND_MSG_PUB.initialize;

829: || (reverse chronological order - newest change first)
830: */
831: BEGIN
832:
833: FND_MSG_PUB.initialize;
834: before_dml (
835: p_action => 'DELETE',
836: x_rowid => x_rowid
837: );

Line 849: FND_MSG_PUB.Count_And_Get(

845:
846: -- Initialize API return status to success.
847: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
848: -- Standard call to get message count and if count is 1, get message info.
849: FND_MSG_PUB.Count_And_Get(
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_MSG_COUNT,
852: p_data => X_MSG_DATA);
853: EXCEPTION

Line 856: FND_MSG_PUB.Count_And_Get(

852: p_data => X_MSG_DATA);
853: EXCEPTION
854: WHEN FND_API.G_EXC_ERROR THEN
855: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
856: FND_MSG_PUB.Count_And_Get(
857: p_encoded => FND_API.G_FALSE,
858: p_count => x_MSG_COUNT,
859: p_data => X_MSG_DATA);
860: RETURN;

Line 863: FND_MSG_PUB.Count_And_Get(

859: p_data => X_MSG_DATA);
860: RETURN;
861: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
862: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
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: RETURN;

Line 872: FND_MSG_PUB.ADD;

868: WHEN OTHERS THEN
869: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
871: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,
875: p_count => x_MSG_COUNT,
876: p_data => X_MSG_DATA);

Line 873: FND_MSG_PUB.Count_And_Get(

869: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
871: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,
875: p_count => x_MSG_COUNT,
876: p_data => X_MSG_DATA);
877: RETURN;