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.OKL_VP_CHANGE_REQUEST_PVT dependencies on FND_NEW_MESSAGES

Line 5: G_PENDING_CHANGE_REQ_EXISTS CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_PEND_CREQ_EXIST'; -- token AGR_NUMBER

1: PACKAGE BODY okl_vp_change_request_pvt AS
2: /* $Header: OKLRVCRB.pls 120.4 2005/09/21 07:19:11 sjalasut noship $ */
3:
4: -- Global Message Constants
5: G_PENDING_CHANGE_REQ_EXISTS CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_PEND_CREQ_EXIST'; -- token AGR_NUMBER
6: G_NOT_NEW_PASS_CR CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_NEW_PASS_CR'; -- token CHANGE_REQ_NUM
7: G_NO_AGR_COPY CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NO_AGR_COPY_FOUND'; -- token CHANGE_REQ_NUM
8: G_CR_PARMS_MISSING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_PARAM_MISSING'; -- no token
9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token

Line 6: G_NOT_NEW_PASS_CR CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_NEW_PASS_CR'; -- token CHANGE_REQ_NUM

2: /* $Header: OKLRVCRB.pls 120.4 2005/09/21 07:19:11 sjalasut noship $ */
3:
4: -- Global Message Constants
5: G_PENDING_CHANGE_REQ_EXISTS CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_PEND_CREQ_EXIST'; -- token AGR_NUMBER
6: G_NOT_NEW_PASS_CR CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_NEW_PASS_CR'; -- token CHANGE_REQ_NUM
7: G_NO_AGR_COPY CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NO_AGR_COPY_FOUND'; -- token CHANGE_REQ_NUM
8: G_CR_PARMS_MISSING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_PARAM_MISSING'; -- no token
9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token
10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM

Line 7: G_NO_AGR_COPY CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NO_AGR_COPY_FOUND'; -- token CHANGE_REQ_NUM

3:
4: -- Global Message Constants
5: G_PENDING_CHANGE_REQ_EXISTS CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_PEND_CREQ_EXIST'; -- token AGR_NUMBER
6: G_NOT_NEW_PASS_CR CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_NEW_PASS_CR'; -- token CHANGE_REQ_NUM
7: G_NO_AGR_COPY CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NO_AGR_COPY_FOUND'; -- token CHANGE_REQ_NUM
8: G_CR_PARMS_MISSING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_PARAM_MISSING'; -- no token
9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token
10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM
11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM

Line 8: G_CR_PARMS_MISSING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_PARAM_MISSING'; -- no token

4: -- Global Message Constants
5: G_PENDING_CHANGE_REQ_EXISTS CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_PEND_CREQ_EXIST'; -- token AGR_NUMBER
6: G_NOT_NEW_PASS_CR CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_NEW_PASS_CR'; -- token CHANGE_REQ_NUM
7: G_NO_AGR_COPY CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NO_AGR_COPY_FOUND'; -- token CHANGE_REQ_NUM
8: G_CR_PARMS_MISSING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_PARAM_MISSING'; -- no token
9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token
10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM
11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM
12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM

Line 9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token

5: G_PENDING_CHANGE_REQ_EXISTS CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_PEND_CREQ_EXIST'; -- token AGR_NUMBER
6: G_NOT_NEW_PASS_CR CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_NEW_PASS_CR'; -- token CHANGE_REQ_NUM
7: G_NO_AGR_COPY CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NO_AGR_COPY_FOUND'; -- token CHANGE_REQ_NUM
8: G_CR_PARMS_MISSING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_PARAM_MISSING'; -- no token
9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token
10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM
11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM
12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
13: G_NOT_ACTIVE_AGREEMENT CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_ACTIVE_AGREEMENT'; -- token AGR_NUMBER

Line 10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM

6: G_NOT_NEW_PASS_CR CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_NEW_PASS_CR'; -- token CHANGE_REQ_NUM
7: G_NO_AGR_COPY CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NO_AGR_COPY_FOUND'; -- token CHANGE_REQ_NUM
8: G_CR_PARMS_MISSING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_PARAM_MISSING'; -- no token
9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token
10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM
11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM
12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
13: G_NOT_ACTIVE_AGREEMENT CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_ACTIVE_AGREEMENT'; -- token AGR_NUMBER
14: G_INVALID_STS_PASSED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PASSED'; -- token CHANGE_REQ_NUM

Line 11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM

7: G_NO_AGR_COPY CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NO_AGR_COPY_FOUND'; -- token CHANGE_REQ_NUM
8: G_CR_PARMS_MISSING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_PARAM_MISSING'; -- no token
9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token
10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM
11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM
12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
13: G_NOT_ACTIVE_AGREEMENT CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_ACTIVE_AGREEMENT'; -- token AGR_NUMBER
14: G_INVALID_STS_PASSED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PASSED'; -- token CHANGE_REQ_NUM
15: G_ONE_REASON_REQD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_ONE_CR_REASON_REQD';

Line 12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM

8: G_CR_PARMS_MISSING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_PARAM_MISSING'; -- no token
9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token
10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM
11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM
12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
13: G_NOT_ACTIVE_AGREEMENT CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_ACTIVE_AGREEMENT'; -- token AGR_NUMBER
14: G_INVALID_STS_PASSED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PASSED'; -- token CHANGE_REQ_NUM
15: G_ONE_REASON_REQD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_ONE_CR_REASON_REQD';
16: G_SYSTEM_COPY_MSG fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_SYSTEM_COPY';

Line 13: G_NOT_ACTIVE_AGREEMENT CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_ACTIVE_AGREEMENT'; -- token AGR_NUMBER

9: G_NO_PARAM_STS_CODE CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_NO_STS_PARAM'; -- no token
10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM
11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM
12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
13: G_NOT_ACTIVE_AGREEMENT CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_ACTIVE_AGREEMENT'; -- token AGR_NUMBER
14: G_INVALID_STS_PASSED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PASSED'; -- token CHANGE_REQ_NUM
15: G_ONE_REASON_REQD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_ONE_CR_REASON_REQD';
16: G_SYSTEM_COPY_MSG fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_SYSTEM_COPY';
17:

Line 14: G_INVALID_STS_PASSED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PASSED'; -- token CHANGE_REQ_NUM

10: G_INVALID_STS_INCOMP CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_INCOMP'; -- token CHANGE_REQ_NUM
11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM
12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
13: G_NOT_ACTIVE_AGREEMENT CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_ACTIVE_AGREEMENT'; -- token AGR_NUMBER
14: G_INVALID_STS_PASSED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PASSED'; -- token CHANGE_REQ_NUM
15: G_ONE_REASON_REQD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_ONE_CR_REASON_REQD';
16: G_SYSTEM_COPY_MSG fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_SYSTEM_COPY';
17:
18: G_NO_ROWS_SELECTED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_LLA_NO_ROW_SELECTED';

Line 15: G_ONE_REASON_REQD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_ONE_CR_REASON_REQD';

11: G_INVALID_STS_PENDING CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PENDING'; -- token CHANGE_REQ_NUM
12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
13: G_NOT_ACTIVE_AGREEMENT CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_ACTIVE_AGREEMENT'; -- token AGR_NUMBER
14: G_INVALID_STS_PASSED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PASSED'; -- token CHANGE_REQ_NUM
15: G_ONE_REASON_REQD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_ONE_CR_REASON_REQD';
16: G_SYSTEM_COPY_MSG fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_SYSTEM_COPY';
17:
18: G_NO_ROWS_SELECTED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_LLA_NO_ROW_SELECTED';
19: -- Global lookup_code constants

Line 16: G_SYSTEM_COPY_MSG fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_SYSTEM_COPY';

12: G_INVALID_STS_APPROVED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_APPROVED'; -- token CHANGE_REQ_NUM
13: G_NOT_ACTIVE_AGREEMENT CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_NOT_ACTIVE_AGREEMENT'; -- token AGR_NUMBER
14: G_INVALID_STS_PASSED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PASSED'; -- token CHANGE_REQ_NUM
15: G_ONE_REASON_REQD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_ONE_CR_REASON_REQD';
16: G_SYSTEM_COPY_MSG fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_SYSTEM_COPY';
17:
18: G_NO_ROWS_SELECTED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_LLA_NO_ROW_SELECTED';
19: -- Global lookup_code constants
20: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';

Line 18: G_NO_ROWS_SELECTED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_LLA_NO_ROW_SELECTED';

14: G_INVALID_STS_PASSED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_INVAL_STS_PASSED'; -- token CHANGE_REQ_NUM
15: G_ONE_REASON_REQD CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_ONE_CR_REASON_REQD';
16: G_SYSTEM_COPY_MSG fnd_new_messages.message_name%TYPE DEFAULT 'OKL_VN_CR_SYSTEM_COPY';
17:
18: G_NO_ROWS_SELECTED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_LLA_NO_ROW_SELECTED';
19: -- Global lookup_code constants
20: G_ARGREEMENT_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'AGREEMENT';
21: G_ASSOCIATE_TYPE_CODE CONSTANT fnd_lookups.lookup_code%TYPE DEFAULT 'ASSOCIATION';
22:

Line 133: -- now also populate the notes for this reason, the note is derived from fnd_new_messages

129: -- 'System generated change request to maintain history'
130: -- populate the reason record
131: lv_vrrv_rec.crs_id := x_vcrv_rec.id;
132: lv_vrrv_rec.reason_code := G_SYSTEM_REASON_CD;
133: -- now also populate the notes for this reason, the note is derived from fnd_new_messages
134: fnd_message.set_name(G_APP_NAME, G_SYSTEM_COPY_MSG);
135: lv_vrrv_rec.note := fnd_message.get;
136:
137: okl_vrr_pvt.insert_row(p_api_version => p_api_version