DBA Data[Home] [Help]

APPS.IGS_PT_CUSTM_PKG dependencies on FND_MSG_PUB

Line 206: FND_MSG_PUB.initialize;

202: cursor c_cus_id is SELECT igs_pt_custm_S.NEXTVAL FROM DUAL;
203:
204: BEGIN
205:
206: FND_MSG_PUB.initialize;
207:
208: IF x_cus_id IS NULL THEN
209: OPEN C_CUS_ID ;
210: FETCH C_CUS_ID INTO x_cus_id;

Line 286: FND_MSG_PUB.Count_And_Get(

282: -- Initialize API return status to success.
283: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
284: -- Standard call to get message count and if count is 1, get message
285: -- info.
286: FND_MSG_PUB.Count_And_Get(
287: p_encoded => FND_API.G_FALSE,
288: p_count => x_MSG_COUNT,
289: p_data => X_MSG_DATA);
290:

Line 294: FND_MSG_PUB.Count_And_Get(

290:
291: EXCEPTION
292: WHEN FND_API.G_EXC_ERROR THEN
293: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
294: FND_MSG_PUB.Count_And_Get(
295: p_encoded => FND_API.G_FALSE,
296: p_count => x_MSG_COUNT,
297: p_data => X_MSG_DATA);
298: RETURN;

Line 301: FND_MSG_PUB.Count_And_Get(

297: p_data => X_MSG_DATA);
298: RETURN;
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
301: FND_MSG_PUB.Count_And_Get(
302: p_encoded => FND_API.G_FALSE,
303: p_count => x_MSG_COUNT,
304: p_data => X_MSG_DATA);
305: RETURN;

Line 310: FND_MSG_PUB.ADD;

306: WHEN OTHERS THEN
307: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
308: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
309: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
310: FND_MSG_PUB.ADD;
311: FND_MSG_PUB.Count_And_Get(
312: p_encoded => FND_API.G_FALSE,
313: p_count => x_MSG_COUNT,
314: p_data => X_MSG_DATA);

Line 311: FND_MSG_PUB.Count_And_Get(

307: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
308: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
309: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
310: FND_MSG_PUB.ADD;
311: FND_MSG_PUB.Count_And_Get(
312: p_encoded => FND_API.G_FALSE,
313: p_count => x_MSG_COUNT,
314: p_data => X_MSG_DATA);
315: RETURN;

Line 352: FND_MSG_PUB.initialize;

348: tlinfo c1%ROWTYPE;
349:
350: BEGIN
351:
352: FND_MSG_PUB.initialize;
353:
354: OPEN c1;
355: FETCH c1 INTO tlinfo;
356: IF (c1%notfound) THEN

Line 381: FND_MSG_PUB.Count_And_Get(

377: -- Initialize API return status to success.
378: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
379: -- Standard call to get message count and if count is 1, get message
380: -- info.
381: FND_MSG_PUB.Count_And_Get(
382: p_encoded => FND_API.G_FALSE,
383: p_count => x_MSG_COUNT,
384: p_data => X_MSG_DATA);
385:

Line 389: FND_MSG_PUB.Count_And_Get(

385:
386: EXCEPTION
387: WHEN FND_API.G_EXC_ERROR THEN
388: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
389: FND_MSG_PUB.Count_And_Get(
390: p_encoded => FND_API.G_FALSE,
391: p_count => x_MSG_COUNT,
392: p_data => X_MSG_DATA);
393: RETURN;

Line 396: FND_MSG_PUB.Count_And_Get(

392: p_data => X_MSG_DATA);
393: RETURN;
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
396: FND_MSG_PUB.Count_And_Get(
397: p_encoded => FND_API.G_FALSE,
398: p_count => x_MSG_COUNT,
399: p_data => X_MSG_DATA);
400: RETURN;

Line 405: FND_MSG_PUB.ADD;

401: WHEN OTHERS THEN
402: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
403: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
404: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
405: FND_MSG_PUB.ADD;
406: FND_MSG_PUB.Count_And_Get(
407: p_encoded => FND_API.G_FALSE,
408: p_count => x_MSG_COUNT,
409: p_data => X_MSG_DATA);

Line 406: FND_MSG_PUB.Count_And_Get(

402: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
403: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
404: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
405: FND_MSG_PUB.ADD;
406: FND_MSG_PUB.Count_And_Get(
407: p_encoded => FND_API.G_FALSE,
408: p_count => x_MSG_COUNT,
409: p_data => X_MSG_DATA);
410: RETURN;

Line 441: FND_MSG_PUB.initialize;

437: x_last_update_login NUMBER;
438:
439: BEGIN
440:
441: FND_MSG_PUB.initialize;
442:
443: x_last_update_date := SYSDATE;
444: IF (X_MODE = 'I') THEN
445: x_last_updated_by := 1;

Line 494: FND_MSG_PUB.Count_And_Get(

490: -- Initialize API return status to success.
491: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
492: -- Standard call to get message count and if count is 1, get message
493: -- info.
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:

Line 502: FND_MSG_PUB.Count_And_Get(

498:
499: EXCEPTION
500: WHEN FND_API.G_EXC_ERROR THEN
501: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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: RETURN;

Line 509: FND_MSG_PUB.Count_And_Get(

505: p_data => X_MSG_DATA);
506: RETURN;
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_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 518: FND_MSG_PUB.ADD;

514: WHEN OTHERS THEN
515: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
516: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
517: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
518: FND_MSG_PUB.ADD;
519: FND_MSG_PUB.Count_And_Get(
520: p_encoded => FND_API.G_FALSE,
521: p_count => x_MSG_COUNT,
522: p_data => X_MSG_DATA);

Line 519: FND_MSG_PUB.Count_And_Get(

515: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
516: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
517: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
518: FND_MSG_PUB.ADD;
519: FND_MSG_PUB.Count_And_Get(
520: p_encoded => FND_API.G_FALSE,
521: p_count => x_MSG_COUNT,
522: p_data => X_MSG_DATA);
523: RETURN;

Line 610: FND_MSG_PUB.initialize;

606: || (reverse chronological order - newest change first)
607: */
608: BEGIN
609:
610: FND_MSG_PUB.initialize;
611:
612: before_dml (
613: p_action => 'DELETE',
614: x_rowid => x_rowid

Line 628: FND_MSG_PUB.Count_And_Get(

624: -- Initialize API return status to success.
625: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
626: -- Standard call to get message count and if count is 1, get message
627: -- info.
628: FND_MSG_PUB.Count_And_Get(
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_MSG_COUNT,
631: p_data => X_MSG_DATA);
632:

Line 636: FND_MSG_PUB.Count_And_Get(

632:
633: EXCEPTION
634: WHEN FND_API.G_EXC_ERROR THEN
635: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get(
637: p_encoded => FND_API.G_FALSE,
638: p_count => x_MSG_COUNT,
639: p_data => X_MSG_DATA);
640: RETURN;

Line 643: FND_MSG_PUB.Count_And_Get(

639: p_data => X_MSG_DATA);
640: RETURN;
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
643: FND_MSG_PUB.Count_And_Get(
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_MSG_COUNT,
646: p_data => X_MSG_DATA);
647: RETURN;

Line 652: FND_MSG_PUB.ADD;

648: WHEN OTHERS THEN
649: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
650: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
651: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
652: FND_MSG_PUB.ADD;
653: FND_MSG_PUB.Count_And_Get(
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_MSG_COUNT,
656: p_data => X_MSG_DATA);

Line 653: FND_MSG_PUB.Count_And_Get(

649: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
650: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
651: FND_MESSAGE.SET_TOKEN('NAME','Insert_Row : '||SQLERRM);
652: FND_MSG_PUB.ADD;
653: FND_MSG_PUB.Count_And_Get(
654: p_encoded => FND_API.G_FALSE,
655: p_count => x_MSG_COUNT,
656: p_data => X_MSG_DATA);
657: RETURN;