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_API

Line 115: IF FND_API.to_Boolean( p_init_msg_list )

111: /*--------------------------------------------------------------+
112: | Initialize message list if p_init_msg_list is set to TRUE |
113: +--------------------------------------------------------------*/
114:
115: IF FND_API.to_Boolean( p_init_msg_list )
116: THEN
117: FND_MSG_PUB.initialize;
118: END IF;
119:

Line 145: x_return_status := FND_API.G_RET_STS_SUCCESS;

141: /*-----------------------------------------+
142: | Initialize return status to SUCCESS |
143: +-----------------------------------------*/
144:
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146: l_application_date := p_application_date;
147: l_application_number := p_application_number;
148: l_credit_request_status := p_credit_request_status;
149: l_requestor_type := p_requestor_type;

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: END IF;
169: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_REQUESTOR_TYPE');
170: FND_MSG_PUB.Add;
171: x_msg_data := 'OCM_INVALID_REQUESTOR_TYPE';
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: return;
174: END IF;
175:
176: debug ( 'l_requestor_type ' || l_requestor_type );

Line 209: x_return_status := FND_API.G_RET_STS_ERROR;

205: FETCH cFndUser INTO l_char;
206: IF cFndUser%NOTFOUND
207: THEN
208: debug('p_requestor_type is passed as NULL, FND_USER check failed');
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: ELSE
211: -- The Requestor is a FND User, set the Requestor Type
212: l_requestor_type := 'FND_USER';
213: END IF;

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: OPEN employee(l_requestor_id);
230: FETCH employee INTO l_char;
231: IF employee%NOTFOUND THEN
232: debug('p_requestor_type is passed, Employee check is failed');
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: END IF;
235: CLOSE employee;
236: ELSIF l_requestor_id IS NOT NULL and l_requestor_type = 'FND_USER'
237: THEN

Line 243: x_return_status := FND_API.G_RET_STS_ERROR;

239: FETCH cFndUser INTO l_char;
240: IF cFndUser%NOTFOUND
241: THEN
242: debug('p_requestor_type is passed, FND USER check is failed');
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: END IF;
245: CLOSE cFndUser;
246: ELSE
247: debug('p_requestor_type is NOT passed OR Request ID is passed as NULL');

Line 248: x_return_status := FND_API.G_RET_STS_ERROR;

244: END IF;
245: CLOSE cFndUser;
246: ELSE
247: debug('p_requestor_type is NOT passed OR Request ID is passed as NULL');
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: END IF;
250:
251: /*---------------------------------------------+
252: | ========== Start of API Body ========== |

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: EXCEPTION
276: WHEN OTHERS THEN
277: FND_MESSAGE.SET_NAME('AR','OCM_UNKNOWN_CREDIT_REQUEST');
278: FND_MSG_PUB.Add;
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: return;
281: END;
282:
283: IF l_char IS NOT NULL

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339: debug ( 'Appeal request is Out of date range');
340: END IF;
341: FND_MESSAGE.SET_NAME('AR','OCM_APPEAL_EXPIRATION_REQUEST');
342: FND_MSG_PUB.Add;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: END IF;
345: EXCEPTION
346: WHEN NO_DATA_FOUND THEN
347: -- reject the application

Line 350: x_return_status := FND_API.G_RET_STS_ERROR;

346: WHEN NO_DATA_FOUND THEN
347: -- reject the application
348: FND_MESSAGE.SET_NAME('AR','OCM_NO_RECO_APPEAL_REQUEST');
349: FND_MSG_PUB.Add;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: WHEN OTHERS THEN
352: -- reject the application
353: FND_MESSAGE.SET_NAME('AR','OCM_NO_RECO_APPEAL_REQUEST');
354: FND_MSG_PUB.Add;

Line 355: x_return_status := FND_API.G_RET_STS_ERROR;

351: WHEN OTHERS THEN
352: -- reject the application
353: FND_MESSAGE.SET_NAME('AR','OCM_NO_RECO_APPEAL_REQUEST');
354: FND_MSG_PUB.Add;
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: END;
357: END IF; -- end APPEAL/APPEAL_REJECTION
358:
359: ELSE

Line 363: x_return_status := FND_API.G_RET_STS_ERROR;

359: ELSE
360: -- reject the application as parent request is not closed
361: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');
362: FND_MSG_PUB.Add;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: END IF;
365:
366: EXCEPTION
367: WHEN NO_DATA_FOUND THEN

Line 371: x_return_status := FND_API.G_RET_STS_ERROR;

367: WHEN NO_DATA_FOUND THEN
368: -- reject the application
369: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');
370: FND_MSG_PUB.Add;
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: WHEN OTHERS THEN
373: -- reject the application
374: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');
375: FND_MSG_PUB.Add;

Line 376: x_return_status := FND_API.G_RET_STS_ERROR;

372: WHEN OTHERS THEN
373: -- reject the application
374: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');
375: FND_MSG_PUB.Add;
376: x_return_status := FND_API.G_RET_STS_ERROR;
377: END;
378:
379: ELSE
380: -- reject the application parent credit request id is null

Line 383: x_return_status := FND_API.G_RET_STS_ERROR;

379: ELSE
380: -- reject the application parent credit request id is null
381: FND_MESSAGE.SET_NAME('AR','OCM_NO_PARENT_APPEAL_REQUEST');
382: FND_MSG_PUB.Add;
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: END IF; -- end parent_credit_request_id is not null
385: END IF; -- end APPEAL/REJECTION/RESUBMISSION
386:
387: ELSE

Line 391: x_return_status := FND_API.G_RET_STS_ERROR;

387: ELSE
388: -- reject the application as request type is unknown
389: FND_MESSAGE.SET_NAME('AR','OCM_UNKNOWN_CREDIT_REQUEST');
390: FND_MSG_PUB.Add;
391: x_return_status := FND_API.G_RET_STS_ERROR;
392: END IF; -- end 'unknown' credit_request_type
393:
394:
395: -- Bug 4137766, In case request comes from OM

Line 397: IF p_source_name = 'OM' and x_return_status = FND_API.G_RET_STS_SUCCESS

393:
394:
395: -- Bug 4137766, In case request comes from OM
396: -- need to verify update is possible or not.
397: IF p_source_name = 'OM' and x_return_status = FND_API.G_RET_STS_SUCCESS
398: THEN
399: -- Get the credit request Id
400: p_credit_request_rec.credit_request_status := 'SUBMIT';
401:

Line 435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

431:
432: l_isupdateable := 'Y'; -- 7185336
433: EXCEPTION
434: WHEN OTHERS THEN
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
436: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
437: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
438: 'GETTING_MAX_CREDIT_REQUEST_FOR_UPDATE : '||SQLERRM);
439: FND_MSG_PUB.Add;

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

440: return;
441: END;
442:
443: WHEN OTHERS THEN
444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
445: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
446: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
447: 'GETTING_CREDIT_REQUEST_FOR_UPDATE : '||SQLERRM);
448: FND_MSG_PUB.Add;

Line 506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

502: return;
503: END IF;
504: END IF;
505: WHEN OTHERS THEN
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
507: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
508: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',
509: 'GETTING_CASE_FOLDER_FOR_UPDATE : '||SQLERRM);
510: FND_MSG_PUB.Add;

Line 582: x_return_status := FND_API.G_RET_STS_ERROR;

578: IF pg_debug = 'Y'
579: THEN
580: debug ( 'Employee Requestor Not Found');
581: END IF;
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: END IF;
584: CLOSE employee;
585: ELSIF p_requestor_id IS NOT NULL and l_requestor_type = 'FND_USER'
586: THEN

Line 594: x_return_status := FND_API.G_RET_STS_ERROR;

590: IF pg_debug = 'Y'
591: THEN
592: debug ( 'FND User Not Found');
593: END IF;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: END IF;
596: CLOSE cFndUser;
597: ELSE
598: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_REQUESTOR');

Line 600: x_return_status := FND_API.G_RET_STS_ERROR;

596: CLOSE cFndUser;
597: ELSE
598: FND_MESSAGE.SET_NAME('AR','OCM_INVALID_REQUESTOR');
599: FND_MSG_PUB.Add;
600: x_return_status := FND_API.G_RET_STS_ERROR;
601: END IF;
602:
603: IF p_party_id IS NULL
604: THEN

Line 608: x_return_status := FND_API.G_RET_STS_ERROR;

604: THEN
605: --raise error message
606: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_PARTY_ID');
607: FND_MSG_PUB.Add;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: END IF;
610:
611: IF p_review_type IS NULL
612: THEN

Line 617: x_return_status := FND_API.G_RET_STS_ERROR;

613: --raise error message
614: debug('AR_CMGT_NULL_REVIEW_TYPE');
615: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_REVIEW_TYPE');
616: FND_MSG_PUB.Add;
617: x_return_status := FND_API.G_RET_STS_ERROR;
618: END IF;
619:
620: IF p_requested_currency IS NULL
621: THEN

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

622: --raise error message
623: debug('AR_CMGT_NULL_REQ_CURR');
624: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_REQ_CURR');
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628:
629: IF p_credit_type IS NULL
630: THEN

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631: --raise error
632: debug('AR_CMGT_NULL_CREDIT_TYPE');
633: FND_MESSAGE.SET_NAME('AR','AR_CMGT_NULL_CREDIT_TYPE');
634: FND_MSG_PUB.Add;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: ELSE
637: --verify the specified value is from lookups
638: BEGIN
639: SELECT lookup_code INTO l_credit_type

Line 649: x_return_status := FND_API.G_RET_STS_ERROR;

645: WHEN OTHERS THEN
646: debug('AR_CMGT_INVALID_CREDIT_TYPE');
647: FND_MESSAGE.SET_NAME('AR','AR_CMGT_INVALID_CREDIT_TYPE');
648: FND_MSG_PUB.Add;
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: END;
651: END IF;
652:
653: IF l_credit_request_status IS NULL

Line 664: x_return_status := FND_API.G_RET_STS_ERROR;

660: --raise error
661: debug('AR_CMGT_INVALID_CR_STATUS');
662: FND_MESSAGE.SET_NAME('AR','AR_CMGT_INVALID_CR_STATUS');
663: FND_MSG_PUB.Add;
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: END IF;
666:
667: END IF;
668:

Line 684: x_return_status := FND_API.G_RET_STS_ERROR;

680: EXCEPTION
681: WHEN NO_DATA_FOUND THEN
682: FND_MESSAGE.SET_NAME('AR','AR_CMGT_SCORE_NAME_INVALID');
683: FND_MSG_PUB.Add;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: WHEN OTHERS THEN
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: END;
688: END IF;

Line 686: x_return_status := FND_API.G_RET_STS_ERROR;

682: FND_MESSAGE.SET_NAME('AR','AR_CMGT_SCORE_NAME_INVALID');
683: FND_MSG_PUB.Add;
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: WHEN OTHERS THEN
686: x_return_status := FND_API.G_RET_STS_ERROR;
687: END;
688: END IF;
689:
690: /*-----------------------------------------+

Line 695: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

691: | CREATION |
692: +-----------------------------------------*/
693: /* bug4414414 : Added columns parent_credit_request_id and credit_request_type
694: */
695: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
696: INSERT INTO AR_CMGT_CREDIT_REQUESTS
697: (credit_request_id,
698: last_update_date,
699: last_updated_by,

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

805: p_credit_request_id := l_credit_request_id;
806:
807: ELSE
808: --error was raised during the validation
809: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
810: p_count => x_msg_count,
811: p_data => x_msg_data
812: );
813: return;

Line 821: WHEN FND_API.G_EXC_ERROR THEN

817: THEN
818: debug ( 'AR_CMGT_CREDIT_REQUEST_API(-)');
819: END IF;
820: EXCEPTION
821: WHEN FND_API.G_EXC_ERROR THEN
822:
823: ROLLBACK TO CREATE_CREDIT_REQ_PVT;
824: x_return_status := FND_API.G_RET_STS_ERROR ;
825:

Line 824: x_return_status := FND_API.G_RET_STS_ERROR ;

820: EXCEPTION
821: WHEN FND_API.G_EXC_ERROR THEN
822:
823: ROLLBACK TO CREATE_CREDIT_REQ_PVT;
824: x_return_status := FND_API.G_RET_STS_ERROR ;
825:
826: --Display_Parameters;
827:
828: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

824: x_return_status := FND_API.G_RET_STS_ERROR ;
825:
826: --Display_Parameters;
827:
828: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
829: p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832: debug('FND_API.G_EXC_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

Line 832: debug('FND_API.G_EXC_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

828: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
829: p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832: debug('FND_API.G_EXC_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);
833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
834:
835: ROLLBACK TO CREATE_CREDIT_REQ_PVT;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

829: p_count => x_msg_count,
830: p_data => x_msg_data
831: );
832: debug('FND_API.G_EXC_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);
833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
834:
835: ROLLBACK TO CREATE_CREDIT_REQ_PVT;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
837:

Line 836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

832: debug('FND_API.G_EXC_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);
833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
834:
835: ROLLBACK TO CREATE_CREDIT_REQ_PVT;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
837:
838: -- Display_Parameters;
839:
840: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

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

836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
837:
838: -- Display_Parameters;
839:
840: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data
843: );
844: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

Line 844: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

840: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data
843: );
844: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);
845: WHEN OTHERS THEN
846:
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
848: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');

Line 847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

843: );
844: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);
845: WHEN OTHERS THEN
846:
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
848: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
849: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','CREATE_CREDIT_REQUEST : '||SQLERRM);
850: FND_MSG_PUB.Add;
851:

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

853: ROLLBACK TO Create_credit_req_PVT;
854:
855:
856: -- Display_Parameters;
857: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

Line 861: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);

857: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
858: p_count => x_msg_count,
859: p_data => x_msg_data
860: );
861: debug('FND_API.G_EXC_UNEXPECTED_ERROR, x_msg_data :'||x_msg_data|| ' SQLERRM :'||SQLERRM);
862: END create_credit_request;
863:
864: FUNCTION is_Credit_Management_Installed
865: RETURN BOOLEAN