DBA Data[Home] [Help]

APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on FND_MESSAGE

Line 184: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_REQUESTOR_TYPE');

180: IF pg_debug = 'Y'
181: THEN
182: debug ( 'Invalid Requestor Type ' || l_requestor_type );
183: END IF;
184: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_REQUESTOR_TYPE');
185: FND_MSG_PUB.Add;
186: x_msg_data := 'OCM_INVALID_REQUESTOR_TYPE';
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: return;

Line 292: FND_MESSAGE.SET_NAME('AR','OCM_UNKNOWN_CREDIT_REQUEST');

288: WHERE lookup_type = 'OCM_CREDIT_REQUEST_TYPE'
289: AND lookup_code = l_credit_request_type;
290: EXCEPTION
291: WHEN OTHERS THEN
292: FND_MESSAGE.SET_NAME('AR','OCM_UNKNOWN_CREDIT_REQUEST');
293: FND_MSG_PUB.Add;
294: x_return_status := FND_API.G_RET_STS_ERROR;
295: return;
296: END;

Line 356: FND_MESSAGE.SET_NAME('AR','OCM_APPEAL_EXPIRATION_REQUEST');

352: IF pg_debug = 'Y'
353: THEN
354: debug ( 'Appeal request is Out of date range');
355: END IF;
356: FND_MESSAGE.SET_NAME('AR','OCM_APPEAL_EXPIRATION_REQUEST');
357: FND_MSG_PUB.Add;
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: END IF;
360: EXCEPTION

Line 363: FND_MESSAGE.SET_NAME('AR','OCM_NO_RECO_APPEAL_REQUEST');

359: END IF;
360: EXCEPTION
361: WHEN NO_DATA_FOUND THEN
362: -- reject the application
363: FND_MESSAGE.SET_NAME('AR','OCM_NO_RECO_APPEAL_REQUEST');
364: FND_MSG_PUB.Add;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: WHEN OTHERS THEN
367: -- reject the application

Line 368: FND_MESSAGE.SET_NAME('AR','OCM_NO_RECO_APPEAL_REQUEST');

364: FND_MSG_PUB.Add;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366: WHEN OTHERS THEN
367: -- reject the application
368: FND_MESSAGE.SET_NAME('AR','OCM_NO_RECO_APPEAL_REQUEST');
369: FND_MSG_PUB.Add;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: END;
372: END IF; -- end APPEAL/APPEAL_REJECTION

Line 376: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');

372: END IF; -- end APPEAL/APPEAL_REJECTION
373:
374: ELSE
375: -- reject the application as parent request is not closed
376: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');
377: FND_MSG_PUB.Add;
378: x_return_status := FND_API.G_RET_STS_ERROR;
379: END IF;
380:

Line 384: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');

380:
381: EXCEPTION
382: WHEN NO_DATA_FOUND THEN
383: -- reject the application
384: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');
385: FND_MSG_PUB.Add;
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: WHEN OTHERS THEN
388: -- reject the application

Line 389: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');

385: FND_MSG_PUB.Add;
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: WHEN OTHERS THEN
388: -- reject the application
389: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');
390: FND_MSG_PUB.Add;
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: END;
393:

Line 396: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');

392: END;
393:
394: ELSE
395: -- reject the application parent credit request id is null
396: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');
397: FND_MSG_PUB.Add;
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: END IF; -- end parent_credit_request_id is not null
400: END IF; -- end APPEAL/REJECTION/RESUBMISSION

Line 404: FND_MESSAGE.SET_NAME('AR','OCM_UNKNOWN_CREDIT_REQUEST');

400: END IF; -- end APPEAL/REJECTION/RESUBMISSION
401:
402: ELSE
403: -- reject the application as request type is unknown
404: FND_MESSAGE.SET_NAME('AR','OCM_UNKNOWN_CREDIT_REQUEST');
405: FND_MSG_PUB.Add;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: END IF; -- end 'unknown' credit_request_type
408:

Line 451: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

447: l_isupdateable := 'Y'; -- 7185336
448: EXCEPTION
449: WHEN OTHERS THEN
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
452: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
453: 'GETTING_MAX_CREDIT_REQUEST_FOR_UPDATE : '||SQLERRM);
454: FND_MSG_PUB.Add;
455: return;

Line 452: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',

448: EXCEPTION
449: WHEN OTHERS THEN
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
451: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
452: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
453: 'GETTING_MAX_CREDIT_REQUEST_FOR_UPDATE : '||SQLERRM);
454: FND_MSG_PUB.Add;
455: return;
456: END;

Line 460: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

456: END;
457:
458: WHEN OTHERS THEN
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
460: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
461: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
462: 'GETTING_CREDIT_REQUEST_FOR_UPDATE : '||SQLERRM);
463: FND_MSG_PUB.Add;
464: return;

Line 461: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',

457:
458: WHEN OTHERS THEN
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
460: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
461: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
462: 'GETTING_CREDIT_REQUEST_FOR_UPDATE : '||SQLERRM);
463: FND_MSG_PUB.Add;
464: return;
465: END;

Line 522: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

518: END IF;
519: END IF;
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
522: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
523: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
524: 'GETTING_CASE_FOLDER_FOR_UPDATE : '||SQLERRM);
525: FND_MSG_PUB.Add;
526: return;

Line 523: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',

519: END IF;
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
522: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
523: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
524: 'GETTING_CASE_FOLDER_FOR_UPDATE : '||SQLERRM);
525: FND_MSG_PUB.Add;
526: return;
527: END;

Line 612: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_PARTY_ID');

608:
609: IF p_party_id IS NULL
610: THEN
611: --raise error message
612: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_PARTY_ID');
613: FND_MSG_PUB.Add;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: END IF;
616:

Line 621: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_REVIEW_TYPE');

617: IF p_review_type IS NULL
618: THEN
619: --raise error message
620: debug('AR_CMGT_NULL_REVIEW_TYPE');
621: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_REVIEW_TYPE');
622: FND_MSG_PUB.Add;
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: END IF;
625:

Line 630: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_REQ_CURR');

626: IF p_requested_currency IS NULL
627: THEN
628: --raise error message
629: debug('AR_CMGT_NULL_REQ_CURR');
630: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_REQ_CURR');
631: FND_MSG_PUB.Add;
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: END IF;
634:

Line 639: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_CREDIT_TYPE');

635: IF p_credit_type IS NULL
636: THEN
637: --raise error
638: debug('AR_CMGT_NULL_CREDIT_TYPE');
639: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_CREDIT_TYPE');
640: FND_MSG_PUB.Add;
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: ELSE
643: --verify the specified value is from lookups

Line 653: FND_MESSAGE.SET_NAME('AR','AR_CMGT_INVALID_CREDIT_TYPE');

649:
650: EXCEPTION
651: WHEN OTHERS THEN
652: debug('AR_CMGT_INVALID_CREDIT_TYPE');
653: FND_MESSAGE.SET_NAME('AR','AR_CMGT_INVALID_CREDIT_TYPE');
654: FND_MSG_PUB.Add;
655: x_return_status := FND_API.G_RET_STS_ERROR;
656: END;
657: END IF;

Line 668: FND_MESSAGE.SET_NAME('AR','AR_CMGT_INVALID_CR_STATUS');

664: ('SUBMIT','SAVE')
665: THEN
666: --raise error
667: debug('AR_CMGT_INVALID_CR_STATUS');
668: FND_MESSAGE.SET_NAME('AR','AR_CMGT_INVALID_CR_STATUS');
669: FND_MSG_PUB.Add;
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: END IF;
672:

Line 689: FND_MESSAGE.SET_NAME('AR','AR_CMGT_SCORE_NAME_INVALID');

685: nvl(end_date,sysdate);
686: EXCEPTION
687: WHEN NO_DATA_FOUND THEN
688: debug('AR_CMGT_SCORE_NAME_INVALID');
689: FND_MESSAGE.SET_NAME('AR','AR_CMGT_SCORE_NAME_INVALID');
690: FND_MSG_PUB.Add;
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: WHEN OTHERS THEN
693: debug('AR_CMGT_SCORE_NAME_INVALID, SQLERRM :'||SQLERRM);

Line 856: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

852: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);
853: WHEN OTHERS THEN
854:
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
856: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
857: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CREDIT_REQUEST : '||SQLERRM);
858: FND_MSG_PUB.Add;
859:
860:

Line 857: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CREDIT_REQUEST : '||SQLERRM);

853: WHEN OTHERS THEN
854:
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
856: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
857: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CREDIT_REQUEST : '||SQLERRM);
858: FND_MSG_PUB.Add;
859:
860:
861: ROLLBACK TO Create_credit_req_PVT;

Line 1056: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

1052: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);
1053: WHEN OTHERS THEN
1054:
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1057: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CREDIT_REQUEST : '||SQLERRM);
1058: FND_MSG_PUB.Add;
1059:
1060: -- Display_Parameters;

Line 1057: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CREDIT_REQUEST : '||SQLERRM);

1053: WHEN OTHERS THEN
1054:
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1056: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1057: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CREDIT_REQUEST : '||SQLERRM);
1058: FND_MSG_PUB.Add;
1059:
1060: -- Display_Parameters;
1061: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,