DBA Data[Home] [Help]

APPS.IGS_PT_CUSTM_PKG dependencies on FND_API

Line 283: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

279: CLOSE c;
280:
281:
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,

Line 287: p_encoded => FND_API.G_FALSE,

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:
291: EXCEPTION

Line 292: WHEN FND_API.G_EXC_ERROR THEN

288: p_count => x_MSG_COUNT,
289: p_data => X_MSG_DATA);
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,

Line 293: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 295: p_encoded => FND_API.G_FALSE,

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;
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

295: p_encoded => FND_API.G_FALSE,
296: p_count => x_MSG_COUNT,
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,

Line 300: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

296: p_count => x_MSG_COUNT,
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);

Line 302: p_encoded => FND_API.G_FALSE,

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;
306: WHEN OTHERS THEN

Line 307: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

303: p_count => x_MSG_COUNT,
304: p_data => X_MSG_DATA);
305: RETURN;
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(

Line 312: p_encoded => FND_API.G_FALSE,

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;
316:

Line 378: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

374: app_exception.raise_exception;
375: END IF;
376:
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,

Line 382: p_encoded => FND_API.G_FALSE,

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:
386: EXCEPTION

Line 387: WHEN FND_API.G_EXC_ERROR THEN

383: p_count => x_MSG_COUNT,
384: p_data => X_MSG_DATA);
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,

Line 388: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 390: p_encoded => FND_API.G_FALSE,

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;
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

390: p_encoded => FND_API.G_FALSE,
391: p_count => x_MSG_COUNT,
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,

Line 395: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

391: p_count => x_MSG_COUNT,
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);

Line 397: p_encoded => FND_API.G_FALSE,

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;
401: WHEN OTHERS THEN

Line 402: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

398: p_count => x_MSG_COUNT,
399: p_data => X_MSG_DATA);
400: RETURN;
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(

Line 407: p_encoded => FND_API.G_FALSE,

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;
411:

Line 491: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

487: RAISE NO_DATA_FOUND;
488: END IF;
489:
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,

Line 495: p_encoded => FND_API.G_FALSE,

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:
499: EXCEPTION

Line 500: WHEN FND_API.G_EXC_ERROR THEN

496: p_count => x_MSG_COUNT,
497: p_data => X_MSG_DATA);
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,

Line 501: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 503: p_encoded => FND_API.G_FALSE,

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;
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

503: p_encoded => FND_API.G_FALSE,
504: p_count => x_MSG_COUNT,
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,

Line 508: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

504: p_count => x_MSG_COUNT,
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);

Line 510: p_encoded => FND_API.G_FALSE,

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;
514: WHEN OTHERS THEN

Line 515: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

511: p_count => x_MSG_COUNT,
512: p_data => X_MSG_DATA);
513: RETURN;
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(

Line 520: p_encoded => FND_API.G_FALSE,

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;
524:

Line 625: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

621: RAISE NO_DATA_FOUND;
622: END IF;
623:
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,

Line 629: p_encoded => FND_API.G_FALSE,

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:
633: EXCEPTION

Line 634: WHEN FND_API.G_EXC_ERROR THEN

630: p_count => x_MSG_COUNT,
631: p_data => X_MSG_DATA);
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,

Line 635: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 637: p_encoded => FND_API.G_FALSE,

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;
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

637: p_encoded => FND_API.G_FALSE,
638: p_count => x_MSG_COUNT,
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,

Line 642: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

638: p_count => x_MSG_COUNT,
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);

Line 644: p_encoded => FND_API.G_FALSE,

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;
648: WHEN OTHERS THEN

Line 649: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

645: p_count => x_MSG_COUNT,
646: p_data => X_MSG_DATA);
647: RETURN;
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(

Line 654: p_encoded => FND_API.G_FALSE,

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;
658: