DBA Data[Home] [Help]

APPS.IGS_DA_REQ_FTRS_PKG dependencies on FND_MSG_PUB

Line 296: FND_MSG_PUB.initialize;

292: x_last_updated_by NUMBER;
293: x_last_update_login NUMBER;
294:
295: BEGIN
296: FND_MSG_PUB.initialize;
297: x_last_update_date := SYSDATE;
298: IF (x_mode = 'I') THEN
299: x_last_updated_by := 1;
300: x_last_update_login := 0;

Line 354: FND_MSG_PUB.Count_And_Get(

350: -- Initialize API return status to success.
351: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
352: -- Standard call to get message count and if count is 1, get message
353: -- info.
354: FND_MSG_PUB.Count_And_Get(
355: p_encoded => FND_API.G_FALSE,
356: p_count => x_MSG_COUNT,
357: p_data => X_MSG_DATA);
358:

Line 362: FND_MSG_PUB.Count_And_Get(

358:
359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362: FND_MSG_PUB.Count_And_Get(
363: p_encoded => FND_API.G_FALSE,
364: p_count => x_MSG_COUNT,
365: p_data => X_MSG_DATA);
366: RETURN;

Line 369: FND_MSG_PUB.Count_And_Get(

365: p_data => X_MSG_DATA);
366: RETURN;
367: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
368: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_And_Get(
370: p_encoded => FND_API.G_FALSE,
371: p_count => x_MSG_COUNT,
372: p_data => X_MSG_DATA);
373: RETURN;

Line 378: FND_MSG_PUB.ADD;

374: WHEN OTHERS THEN
375: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
377: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
378: FND_MSG_PUB.ADD;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_MSG_COUNT,
382: p_data => X_MSG_DATA);

Line 379: FND_MSG_PUB.Count_And_Get(

375: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
377: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
378: FND_MSG_PUB.ADD;
379: FND_MSG_PUB.Count_And_Get(
380: p_encoded => FND_API.G_FALSE,
381: p_count => x_MSG_COUNT,
382: p_data => X_MSG_DATA);
383: RETURN;

Line 416: FND_MSG_PUB.initialize;

412:
413: tlinfo c1%ROWTYPE;
414:
415: BEGIN
416: FND_MSG_PUB.initialize;
417: OPEN c1;
418: FETCH c1 INTO tlinfo;
419: IF (c1%notfound) THEN
420: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line 442: FND_MSG_PUB.Count_And_Get(

438: -- Initialize API return status to success.
439: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
440: -- Standard call to get message count and if count is 1, get message
441: -- info.
442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_MSG_COUNT,
445: p_data => X_MSG_DATA);
446: RETURN;

Line 450: FND_MSG_PUB.Count_And_Get(

446: RETURN;
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get(
451: p_encoded => FND_API.G_FALSE,
452: p_count => x_MSG_COUNT,
453: p_data => X_MSG_DATA);
454: RETURN;

Line 457: FND_MSG_PUB.Count_And_Get(

453: p_data => X_MSG_DATA);
454: RETURN;
455: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
456: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
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: RETURN;

Line 466: FND_MSG_PUB.ADD;

462: WHEN OTHERS THEN
463: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
464: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
465: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.Count_And_Get(
468: p_encoded => FND_API.G_FALSE,
469: p_count => x_MSG_COUNT,
470: p_data => X_MSG_DATA);

Line 467: FND_MSG_PUB.Count_And_Get(

463: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
464: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
465: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
466: FND_MSG_PUB.ADD;
467: FND_MSG_PUB.Count_And_Get(
468: p_encoded => FND_API.G_FALSE,
469: p_count => x_MSG_COUNT,
470: p_data => X_MSG_DATA);
471: RETURN;

Line 499: FND_MSG_PUB.initialize;

495: x_last_updated_by NUMBER;
496: x_last_update_login NUMBER;
497:
498: BEGIN
499: FND_MSG_PUB.initialize;
500: x_last_update_date := SYSDATE;
501: IF (X_MODE = 'I') THEN
502: x_last_updated_by := 1;
503: x_last_update_login := 0;

Line 548: FND_MSG_PUB.Count_And_Get(

544: -- Initialize API return status to success.
545: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
546: -- Standard call to get message count and if count is 1, get message
547: -- info.
548: FND_MSG_PUB.Count_And_Get(
549: p_encoded => FND_API.G_FALSE,
550: p_count => x_MSG_COUNT,
551: p_data => X_MSG_DATA);
552:

Line 556: FND_MSG_PUB.Count_And_Get(

552:
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
556: FND_MSG_PUB.Count_And_Get(
557: p_encoded => FND_API.G_FALSE,
558: p_count => x_MSG_COUNT,
559: p_data => X_MSG_DATA);
560: RETURN;

Line 563: FND_MSG_PUB.Count_And_Get(

559: p_data => X_MSG_DATA);
560: RETURN;
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MSG_PUB.Count_And_Get(
564: p_encoded => FND_API.G_FALSE,
565: p_count => x_MSG_COUNT,
566: p_data => X_MSG_DATA);
567: RETURN;

Line 572: FND_MSG_PUB.ADD;

568: WHEN OTHERS THEN
569: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
571: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
572: FND_MSG_PUB.ADD;
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);

Line 573: FND_MSG_PUB.Count_And_Get(

569: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
570: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
571: FND_MESSAGE.SET_TOKEN('NAME','Update_Row : '||SQLERRM);
572: FND_MSG_PUB.ADD;
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 659: FND_MSG_PUB.initialize;

655: || Who When What
656: || (reverse chronological order - newest change first)
657: */
658: BEGIN
659: FND_MSG_PUB.initialize;
660: before_dml (
661: p_action => 'DELETE',
662: x_rowid => x_rowid
663: );

Line 675: FND_MSG_PUB.Count_And_Get(

671: -- Initialize API return status to success.
672: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
673: -- Standard call to get message count and if count is 1, get message
674: -- info.
675: FND_MSG_PUB.Count_And_Get(
676: p_encoded => FND_API.G_FALSE,
677: p_count => x_MSG_COUNT,
678: p_data => X_MSG_DATA);
679:

Line 683: FND_MSG_PUB.Count_And_Get(

679:
680: EXCEPTION
681: WHEN FND_API.G_EXC_ERROR THEN
682: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
683: FND_MSG_PUB.Count_And_Get(
684: p_encoded => FND_API.G_FALSE,
685: p_count => x_MSG_COUNT,
686: p_data => X_MSG_DATA);
687: RETURN;

Line 690: FND_MSG_PUB.Count_And_Get(

686: p_data => X_MSG_DATA);
687: RETURN;
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
689: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.Count_And_Get(
691: p_encoded => FND_API.G_FALSE,
692: p_count => x_MSG_COUNT,
693: p_data => X_MSG_DATA);
694: RETURN;

Line 699: FND_MSG_PUB.ADD;

695: WHEN OTHERS THEN
696: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
698: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
699: FND_MSG_PUB.ADD;
700: FND_MSG_PUB.Count_And_Get(
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_MSG_COUNT,
703: p_data => X_MSG_DATA);

Line 700: FND_MSG_PUB.Count_And_Get(

696: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
698: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
699: FND_MSG_PUB.ADD;
700: FND_MSG_PUB.Count_And_Get(
701: p_encoded => FND_API.G_FALSE,
702: p_count => x_MSG_COUNT,
703: p_data => X_MSG_DATA);
704: RETURN;