eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on FND_MSG_PUB

Line 132: FND_MSG_PUB.initialize;

128: +--------------------------------------------------------------*/
129:
130: IF FND_API.to_Boolean( p_init_msg_list )
131: THEN
132: FND_MSG_PUB.initialize;
133: END IF;
134:
135: IF pg_debug = 'Y'
136: THEN

Line 185: FND_MSG_PUB.Add;

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;
189: END IF;

Line 293: FND_MSG_PUB.Add;

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

Line 357: FND_MSG_PUB.Add;

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
361: WHEN NO_DATA_FOUND THEN

Line 364: FND_MSG_PUB.Add;

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
368: FND_MESSAGE.SET_NAME('AR','OCM_NO_RECO_APPEAL_REQUEST');

Line 369: 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
373:

Line 377: FND_MSG_PUB.Add;

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

Line 385: FND_MSG_PUB.Add;

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
389: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');

Line 390: 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:
394: ELSE

Line 397: FND_MSG_PUB.Add;

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
401:

Line 405: FND_MSG_PUB.Add;

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:
409:

Line 454: FND_MSG_PUB.Add;

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

Line 463: FND_MSG_PUB.Add;

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;
466:
467: BEGIN

Line 525: FND_MSG_PUB.Add;

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;
528:
529: IF l_isupdateable = 'Y'

Line 613: FND_MSG_PUB.Add;

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:
617: IF p_review_type IS NULL

Line 622: FND_MSG_PUB.Add;

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:
626: IF p_requested_currency IS NULL

Line 631: FND_MSG_PUB.Add;

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:
635: IF p_credit_type IS NULL

Line 640: FND_MSG_PUB.Add;

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
644: BEGIN

Line 654: FND_MSG_PUB.Add;

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

Line 669: FND_MSG_PUB.Add;

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:
673: END IF;

Line 690: FND_MSG_PUB.Add;

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);
694: x_return_status := FND_API.G_RET_STS_ERROR;

Line 817: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

813: p_credit_request_id := l_credit_request_id;
814:
815: ELSE
816: --error was raised during the validation
817: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
818: p_count => x_msg_count,
819: p_data => x_msg_data
820: );
821: return;

Line 836: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

832: x_return_status := FND_API.G_RET_STS_ERROR ;
833:
834: --Display_Parameters;
835:
836: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );
840: debug('FND_API.G_EXC_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

Line 848: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
845:
846: -- Display_Parameters;
847:
848: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
849: p_count => x_msg_count,
850: p_data => x_msg_data
851: );
852: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

Line 858: FND_MSG_PUB.Add;

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

Line 865: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

861: ROLLBACK TO Create_credit_req_PVT;
862:
863:
864: -- Display_Parameters;
865: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
866: p_count => x_msg_count,
867: p_data => x_msg_data
868: );
869: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

Line 1037: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1033: x_return_status := FND_API.G_RET_STS_ERROR ;
1034:
1035: --Display_Parameters;
1036:
1037: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1038: p_count => x_msg_count,
1039: p_data => x_msg_data
1040: );
1041: debug('FND_API.G_EXC_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

Line 1048: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045:
1046: -- Display_Parameters;
1047:
1048: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1049: p_count => x_msg_count,
1050: p_data => x_msg_data
1051: );
1052: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

Line 1058: FND_MSG_PUB.Add;

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,
1062: p_count => x_msg_count,

Line 1061: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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,
1062: p_count => x_msg_count,
1063: p_data => x_msg_data
1064: );
1065: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);