APPS.OCM_CREDIT_REQUEST_UPDATE_PUB dependencies on OCM_CREDIT_REQUEST_UPDATE_PUB

Line 1: PACKAGE BODY OCM_CREDIT_REQUEST_UPDATE_PUB AS

1: PACKAGE BODY OCM_CREDIT_REQUEST_UPDATE_PUB AS
2: /*$Header: OCMUPCRB.pls 120.7.12020000.2 2013/03/19 20:59:49 rravikir ship $ */
3:
4: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
5:

Line 11: ar_cmgt_util.debug (p_message_name, 'ar.cmgt.plsql.OCM_CREDIT_REQUEST_UPDATE_PUB' );

7:
8: PROCEDURE debug (
9: p_message_name IN VARCHAR2 ) IS
10: BEGIN
11: ar_cmgt_util.debug (p_message_name, 'ar.cmgt.plsql.OCM_CREDIT_REQUEST_UPDATE_PUB' );
12: END;
13:
14: PROCEDURE UPDATE_CREDIT_REQUEST (
15: p_api_version IN NUMBER,

Line 34: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(+)');

30: l_check_flag VARCHAr2(60);
31: BEGIN
32: IF pg_debug = 'Y'
33: THEN
34: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(+)');
35: debug ( 'Trx Amount ' || p_credit_request_rec.trx_amount);
36: debug ( 'Requested Amount ' || p_credit_request_rec.requested_amount);
37: debug ( 'Requestor ID ' || p_credit_request_rec.requestor_id);
38: debug ( 'Case Folder ID ' || p_credit_request_rec.case_folder_id);

Line 232: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(-)');

228:
229: END IF;
230: IF pg_debug = 'Y'
231: THEN
232: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.UPDATE_CREDIT_REQUEST(-)');
233: END IF;
234: EXCEPTION
235: WHEN OTHERS THEN
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 302: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(+)');

298:
299: BEGIN
300: IF pg_debug = 'Y'
301: THEN
302: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(+)');
303: END IF;
304: p_return_status := FND_API.G_RET_STS_SUCCESS;
305: -- Get credit request rec
306: SELECT credit_request_id,

Line 399: debug ('OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC (+)' );

395: WHERE credit_request_id = p_credit_request_id;
396:
397: IF pg_debug = 'Y'
398: THEN
399: debug ('OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC (+)' );
400: debug ('Credit request Id : '|| l_credit_request_id );
401: debug ('APPLICATION_NUMBER '|| l_APPLICATION_NUMBER);
402: debug ('APPLICATION_DATE '|| l_APPLICATION_DATE);
403: debug ('REQUESTOR_TYPE '|| l_REQUESTOR_TYPE);

Line 492: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(-)');

488: p_credit_request_rec.REVIEW_CYCLE := l_REVIEW_CYCLE;
489:
490: IF pg_debug = 'Y'
491: THEN
492: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC(-)');
493: END IF;
494: EXCEPTION
495: WHEN NO_DATA_FOUND
496: THEN

Line 501: p_error_msg := 'OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC '|| sqlerrm;

497: NULL;
498: WHEN OTHERS
499: THEN
500: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501: p_error_msg := 'OCM_CREDIT_REQUEST_UPDATE_PUB.GET_CREDIT_REQUEST_REC '|| sqlerrm;
502:
503: END;
504:
505: PROCEDURE update_credit_request_status (

Line 553: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status(+)');

549:
550: BEGIN
551: IF pg_debug = 'Y'
552: THEN
553: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status(+)');
554: debug ( 'Credit request Id :' || to_char(p_credit_request_id));
555: debug ( 'Status :' || p_credit_request_status);
556: END IF;
557: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 736: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status(-)');

732: debug ( 'Submitted All Child Credit requests');
733: END IF;
734: IF pg_debug = 'Y'
735: THEN
736: debug ( 'OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status(-)');
737: END IF;
738:
739: EXCEPTION
740: WHEN OTHERS THEN

Line 747: END OCM_CREDIT_REQUEST_UPDATE_PUB;

743: ROLLBACK TO UPDATE_CREDIT_REQ_STATUS;
744: return;
745: END;
746:
747: END OCM_CREDIT_REQUEST_UPDATE_PUB;