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_CNR_PVT dependencies on OKL_API

Line 10: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

6: PROCEDURE validate_id (p_cnrv_rec IN cnrv_rec_type,
7: x_return_status OUT NOCOPY VARCHAR2) IS
8:
9: BEGIN
10: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
11: --Check for Null
12: IF p_cnrv_rec.id = Okl_Api.G_MISS_NUM OR
13: p_cnrv_rec.id IS NULL
14: THEN

Line 12: IF p_cnrv_rec.id = Okl_Api.G_MISS_NUM OR

8:
9: BEGIN
10: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
11: --Check for Null
12: IF p_cnrv_rec.id = Okl_Api.G_MISS_NUM OR
13: p_cnrv_rec.id IS NULL
14: THEN
15:
16: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 16: x_return_status := Okl_Api.G_RET_STS_ERROR;

12: IF p_cnrv_rec.id = Okl_Api.G_MISS_NUM OR
13: p_cnrv_rec.id IS NULL
14: THEN
15:
16: x_return_status := Okl_Api.G_RET_STS_ERROR;
17: --set error message in message stack
18: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
19: p_msg_name => G_REQUIRED_VALUE,
20: p_token1 => G_COL_NAME_TOKEN,

Line 18: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

14: THEN
15:
16: x_return_status := Okl_Api.G_RET_STS_ERROR;
17: --set error message in message stack
18: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
19: p_msg_name => G_REQUIRED_VALUE,
20: p_token1 => G_COL_NAME_TOKEN,
21: p_token1_value => 'id');
22: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 34: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

30:
31: PROCEDURE validate_org_id (p_cnrv_rec IN cnrv_rec_type,
32: x_return_status OUT NOCOPY VARCHAR2) IS
33: BEGIN
34: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
35:
36: x_return_status := Okl_Util.check_org_id(p_cnrv_rec.org_id);
37:
38: END validate_org_id;

Line 48: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

44: PROCEDURE validate_object_version_number (p_cnrv_rec IN cnrv_rec_type,
45: x_return_status OUT NOCOPY VARCHAR2) IS
46:
47: BEGIN
48: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
49: --Check for Null
50: IF p_cnrv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
51: p_cnrv_rec.object_version_number IS NULL
52: THEN

Line 50: IF p_cnrv_rec.object_version_number = Okl_Api.G_MISS_NUM OR

46:
47: BEGIN
48: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
49: --Check for Null
50: IF p_cnrv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
51: p_cnrv_rec.object_version_number IS NULL
52: THEN
53:
54: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 54: x_return_status := Okl_Api.G_RET_STS_ERROR;

50: IF p_cnrv_rec.object_version_number = Okl_Api.G_MISS_NUM OR
51: p_cnrv_rec.object_version_number IS NULL
52: THEN
53:
54: x_return_status := Okl_Api.G_RET_STS_ERROR;
55: --set error message in message stack
56: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
57: p_msg_name => G_REQUIRED_VALUE,
58: p_token1 => G_COL_NAME_TOKEN,

Line 56: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

52: THEN
53:
54: x_return_status := Okl_Api.G_RET_STS_ERROR;
55: --set error message in message stack
56: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
57: p_msg_name => G_REQUIRED_VALUE,
58: p_token1 => G_COL_NAME_TOKEN,
59: p_token1_value => 'object_version_number');
60: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 72: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

68: PROCEDURE validate_date_consolidated (p_cnrv_rec IN cnrv_rec_type,
69: x_return_status OUT NOCOPY VARCHAR2) IS
70:
71: BEGIN
72: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
73: --Check for Null
74: IF p_cnrv_rec.date_consolidated = Okl_Api.G_MISS_DATE OR
75: p_cnrv_rec.date_consolidated IS NULL
76: THEN

Line 74: IF p_cnrv_rec.date_consolidated = Okl_Api.G_MISS_DATE OR

70:
71: BEGIN
72: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
73: --Check for Null
74: IF p_cnrv_rec.date_consolidated = Okl_Api.G_MISS_DATE OR
75: p_cnrv_rec.date_consolidated IS NULL
76: THEN
77:
78: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 78: x_return_status := Okl_Api.G_RET_STS_ERROR;

74: IF p_cnrv_rec.date_consolidated = Okl_Api.G_MISS_DATE OR
75: p_cnrv_rec.date_consolidated IS NULL
76: THEN
77:
78: x_return_status := Okl_Api.G_RET_STS_ERROR;
79: --set error message in message stack
80: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
81: p_msg_name => G_REQUIRED_VALUE,
82: p_token1 => G_COL_NAME_TOKEN,

Line 80: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

76: THEN
77:
78: x_return_status := Okl_Api.G_RET_STS_ERROR;
79: --set error message in message stack
80: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
81: p_msg_name => G_REQUIRED_VALUE,
82: p_token1 => G_COL_NAME_TOKEN,
83: p_token1_value => 'date_consolidated');
84: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 103: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

99: WHERE currency_code = p_cnrv_rec.currency_code;
100:
101:
102: BEGIN
103: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
104: --Check for Null
105: IF p_cnrv_rec.currency_code = Okl_Api.G_MISS_CHAR OR
106: p_cnrv_rec.currency_code IS NULL
107: THEN

Line 105: IF p_cnrv_rec.currency_code = Okl_Api.G_MISS_CHAR OR

101:
102: BEGIN
103: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
104: --Check for Null
105: IF p_cnrv_rec.currency_code = Okl_Api.G_MISS_CHAR OR
106: p_cnrv_rec.currency_code IS NULL
107: THEN
108:
109: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 109: x_return_status := Okl_Api.G_RET_STS_ERROR;

105: IF p_cnrv_rec.currency_code = Okl_Api.G_MISS_CHAR OR
106: p_cnrv_rec.currency_code IS NULL
107: THEN
108:
109: x_return_status := Okl_Api.G_RET_STS_ERROR;
110: --set error message in message stack
111: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
112: p_msg_name => G_REQUIRED_VALUE,
113: p_token1 => G_COL_NAME_TOKEN,

Line 111: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

107: THEN
108:
109: x_return_status := Okl_Api.G_RET_STS_ERROR;
110: --set error message in message stack
111: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
112: p_msg_name => G_REQUIRED_VALUE,
113: p_token1 => G_COL_NAME_TOKEN,
114: p_token1_value => 'currency_code');
115: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 126: x_return_status := Okl_Api.G_RET_STS_ERROR;

122: FETCH l_currency_code_csr INTO l_dummy_var;
123: CLOSE l_currency_code_csr;
124:
125: IF (l_dummy_var <> '1') THEN
126: x_return_status := Okl_Api.G_RET_STS_ERROR;
127: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
128: p_msg_name => G_NO_PARENT_RECORD,
129: p_token1 => G_COL_NAME_TOKEN,
130: p_token1_value => 'CURRENCY_CODE_FOR',

Line 127: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

123: CLOSE l_currency_code_csr;
124:
125: IF (l_dummy_var <> '1') THEN
126: x_return_status := Okl_Api.G_RET_STS_ERROR;
127: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
128: p_msg_name => G_NO_PARENT_RECORD,
129: p_token1 => G_COL_NAME_TOKEN,
130: p_token1_value => 'CURRENCY_CODE_FOR',
131: p_token2 => G_CHILD_TABLE_TOKEN,

Line 151: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

147: x_return_status OUT NOCOPY VARCHAR2) IS
148: l_exists NUMBER(1);
149: item_not_found_error EXCEPTION;
150: BEGIN
151: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
152: IF (p_cnrv_rec.legal_entity_id IS NOT NULL) THEN
153: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_cnrv_rec.legal_entity_id);
154: IF(l_exists<>1) THEN
155: Okc_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');

Line 193: x_return_status := Okl_api.G_RET_STS_SUCCESS;

189: WHERE id = p_cnrv_rec.ibt_id;
190:
191:
192: BEGIN
193: x_return_status := Okl_api.G_RET_STS_SUCCESS;
194:
195: --Check for Null
196: IF p_cnrv_rec.ibt_id = Okl_api.G_MISS_NUM OR
197: p_cnrv_rec.ibt_id IS NULL

Line 196: IF p_cnrv_rec.ibt_id = Okl_api.G_MISS_NUM OR

192: BEGIN
193: x_return_status := Okl_api.G_RET_STS_SUCCESS;
194:
195: --Check for Null
196: IF p_cnrv_rec.ibt_id = Okl_api.G_MISS_NUM OR
197: p_cnrv_rec.ibt_id IS NULL
198: THEN
199:
200: x_return_status := Okl_api.G_RET_STS_ERROR;

Line 200: x_return_status := Okl_api.G_RET_STS_ERROR;

196: IF p_cnrv_rec.ibt_id = Okl_api.G_MISS_NUM OR
197: p_cnrv_rec.ibt_id IS NULL
198: THEN
199:
200: x_return_status := Okl_api.G_RET_STS_ERROR;
201: --set error message in message stack
202: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
203: p_msg_name => G_REQUIRED_VALUE,
204: p_token1 => G_COL_NAME_TOKEN,

Line 202: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,

198: THEN
199:
200: x_return_status := Okl_api.G_RET_STS_ERROR;
201: --set error message in message stack
202: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
203: p_msg_name => G_REQUIRED_VALUE,
204: p_token1 => G_COL_NAME_TOKEN,
205: p_token1_value => 'ibt_id');
206: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 216: x_return_status := Okl_api.G_RET_STS_ERROR;

212: FETCH l_ibt_id_csr INTO l_dummy_var;
213: CLOSE l_ibt_id_csr;
214:
215: IF (l_dummy_var <> '1') THEN
216: x_return_status := Okl_api.G_RET_STS_ERROR;
217: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
218: p_msg_name => G_NO_PARENT_RECORD,
219: p_token1 => G_COL_NAME_TOKEN,
220: p_token1_value => 'IBT_ID_FOR',

Line 217: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,

213: CLOSE l_ibt_id_csr;
214:
215: IF (l_dummy_var <> '1') THEN
216: x_return_status := Okl_api.G_RET_STS_ERROR;
217: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
218: p_msg_name => G_NO_PARENT_RECORD,
219: p_token1 => G_COL_NAME_TOKEN,
220: p_token1_value => 'IBT_ID_FOR',
221: p_token2 => G_CHILD_TABLE_TOKEN,

Line 248: x_return_status := Okl_api.G_RET_STS_SUCCESS;

244: WHERE id = p_cnrv_rec.ixx_id;
245:
246:
247: BEGIN
248: x_return_status := Okl_api.G_RET_STS_SUCCESS;
249:
250: --Check for Null
251: IF p_cnrv_rec.ixx_id = Okl_api.G_MISS_NUM OR
252: p_cnrv_rec.ixx_id IS NULL

Line 251: IF p_cnrv_rec.ixx_id = Okl_api.G_MISS_NUM OR

247: BEGIN
248: x_return_status := Okl_api.G_RET_STS_SUCCESS;
249:
250: --Check for Null
251: IF p_cnrv_rec.ixx_id = Okl_api.G_MISS_NUM OR
252: p_cnrv_rec.ixx_id IS NULL
253: THEN
254:
255: x_return_status := Okl_api.G_RET_STS_ERROR;

Line 255: x_return_status := Okl_api.G_RET_STS_ERROR;

251: IF p_cnrv_rec.ixx_id = Okl_api.G_MISS_NUM OR
252: p_cnrv_rec.ixx_id IS NULL
253: THEN
254:
255: x_return_status := Okl_api.G_RET_STS_ERROR;
256: --set error message in message stack
257: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
258: p_msg_name => G_REQUIRED_VALUE,
259: p_token1 => G_COL_NAME_TOKEN,

Line 257: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,

253: THEN
254:
255: x_return_status := Okl_api.G_RET_STS_ERROR;
256: --set error message in message stack
257: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
258: p_msg_name => G_REQUIRED_VALUE,
259: p_token1 => G_COL_NAME_TOKEN,
260: p_token1_value => 'ixx_id');
261: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 271: x_return_status := Okl_api.G_RET_STS_ERROR;

267: FETCH l_ixx_id_csr INTO l_dummy_var;
268: CLOSE l_ixx_id_csr;
269:
270: IF (l_dummy_var <> '1') THEN
271: x_return_status := Okl_api.G_RET_STS_ERROR;
272: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
273: p_msg_name => G_NO_PARENT_RECORD,
274: p_token1 => G_COL_NAME_TOKEN,
275: p_token1_value => 'IXX_ID_FOR',

Line 272: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,

268: CLOSE l_ixx_id_csr;
269:
270: IF (l_dummy_var <> '1') THEN
271: x_return_status := Okl_api.G_RET_STS_ERROR;
272: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
273: p_msg_name => G_NO_PARENT_RECORD,
274: p_token1 => G_COL_NAME_TOKEN,
275: p_token1_value => 'IXX_ID_FOR',
276: p_token2 => G_CHILD_TABLE_TOKEN,

Line 302: x_return_status := Okl_api.G_RET_STS_SUCCESS;

298: WHERE id = p_cnrv_rec.irm_id;
299:
300:
301: BEGIN
302: x_return_status := Okl_api.G_RET_STS_SUCCESS;
303:
304: --Check for Null
305: IF p_cnrv_rec.irm_id = Okl_api.G_MISS_NUM OR
306: p_cnrv_rec.irm_id IS NULL

Line 305: IF p_cnrv_rec.irm_id = Okl_api.G_MISS_NUM OR

301: BEGIN
302: x_return_status := Okl_api.G_RET_STS_SUCCESS;
303:
304: --Check for Null
305: IF p_cnrv_rec.irm_id = Okl_api.G_MISS_NUM OR
306: p_cnrv_rec.irm_id IS NULL
307: THEN
308:
309: x_return_status := Okl_api.G_RET_STS_ERROR;

Line 309: x_return_status := Okl_api.G_RET_STS_ERROR;

305: IF p_cnrv_rec.irm_id = Okl_api.G_MISS_NUM OR
306: p_cnrv_rec.irm_id IS NULL
307: THEN
308:
309: x_return_status := Okl_api.G_RET_STS_ERROR;
310: --set error message in message stack
311: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
312: p_msg_name => G_REQUIRED_VALUE,
313: p_token1 => G_COL_NAME_TOKEN,

Line 311: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,

307: THEN
308:
309: x_return_status := Okl_api.G_RET_STS_ERROR;
310: --set error message in message stack
311: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
312: p_msg_name => G_REQUIRED_VALUE,
313: p_token1 => G_COL_NAME_TOKEN,
314: p_token1_value => 'irm_id');
315: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 327: x_return_status := Okl_api.G_RET_STS_ERROR;

323: FETCH l_irm_id_csr INTO l_dummy_var;
324: CLOSE l_irm_id_csr;
325:
326: IF (l_dummy_var <> '1') THEN
327: x_return_status := Okl_api.G_RET_STS_ERROR;
328: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
329: p_msg_name => G_NO_PARENT_RECORD,
330: p_token1 => G_COL_NAME_TOKEN,
331: p_token1_value => 'IRM_ID_FOR',

Line 328: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,

324: CLOSE l_irm_id_csr;
325:
326: IF (l_dummy_var <> '1') THEN
327: x_return_status := Okl_api.G_RET_STS_ERROR;
328: Okl_api.SET_MESSAGE(p_app_name => G_APP_NAME,
329: p_msg_name => G_NO_PARENT_RECORD,
330: p_token1 => G_COL_NAME_TOKEN,
331: p_token1_value => 'IRM_ID_FOR',
332: p_token2 => G_CHILD_TABLE_TOKEN,

Line 358: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

354: WHERE id = p_cnrv_rec.inf_id;
355:
356:
357: BEGIN
358: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
359:
360: IF (p_cnrv_rec.inf_id IS NOT NULL) THEN
361: OPEN l_inf_id_csr;
362: FETCH l_inf_id_csr INTO l_dummy_var;

Line 366: x_return_status := Okl_Api.G_RET_STS_ERROR;

362: FETCH l_inf_id_csr INTO l_dummy_var;
363: CLOSE l_inf_id_csr;
364:
365: IF (l_dummy_var <> '1') THEN
366: x_return_status := Okl_Api.G_RET_STS_ERROR;
367: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
368: p_msg_name => G_NO_PARENT_RECORD,
369: p_token1 => G_COL_NAME_TOKEN,
370: p_token1_value => 'INF_ID_FOR',

Line 367: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

363: CLOSE l_inf_id_csr;
364:
365: IF (l_dummy_var <> '1') THEN
366: x_return_status := Okl_Api.G_RET_STS_ERROR;
367: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
368: p_msg_name => G_NO_PARENT_RECORD,
369: p_token1 => G_COL_NAME_TOKEN,
370: p_token1_value => 'INF_ID_FOR',
371: p_token2 => G_CHILD_TABLE_TOKEN,

Line 911: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

907: p_cnrv_rec IN cnrv_rec_type
908: ) RETURN VARCHAR2 IS
909: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
910: -- Added 04/19/2001 -- Sunil Mathew
911: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
912: BEGIN
913: -- Added 04/19/2001 -- Sunil Mathew
914: validate_currency_code(p_cnrv_rec, x_return_status);
915: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

Line 915: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

911: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
912: BEGIN
913: -- Added 04/19/2001 -- Sunil Mathew
914: validate_currency_code(p_cnrv_rec, x_return_status);
915: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
916: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
917: l_return_status := x_return_status;
918: RAISE G_EXCEPTION_HALT_VALIDATION;
919: ELSE

Line 916: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

912: BEGIN
913: -- Added 04/19/2001 -- Sunil Mathew
914: validate_currency_code(p_cnrv_rec, x_return_status);
915: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
916: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
917: l_return_status := x_return_status;
918: RAISE G_EXCEPTION_HALT_VALIDATION;
919: ELSE
920: l_return_status := x_return_status; -- record that there was an error

Line 924: IF ( p_cnrv_rec.legal_entity_id = Okl_Api.G_MISS_NUM OR p_cnrv_rec.legal_entity_id IS NULL)

920: l_return_status := x_return_status; -- record that there was an error
921: END IF;
922: END IF;
923: -- for LE Uptake project 08-11-2006
924: IF ( p_cnrv_rec.legal_entity_id = Okl_Api.G_MISS_NUM OR p_cnrv_rec.legal_entity_id IS NULL)
925: THEN
926: RAISE G_EXCEPTION_HALT_VALIDATION;
927: ELSE
928: validate_legal_entity_id(p_cnrv_rec, x_return_status);

Line 929: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

925: THEN
926: RAISE G_EXCEPTION_HALT_VALIDATION;
927: ELSE
928: validate_legal_entity_id(p_cnrv_rec, x_return_status);
929: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
930: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
931: l_return_status := x_return_status;
932: RAISE G_EXCEPTION_HALT_VALIDATION;
933: ELSE

Line 930: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

926: RAISE G_EXCEPTION_HALT_VALIDATION;
927: ELSE
928: validate_legal_entity_id(p_cnrv_rec, x_return_status);
929: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
930: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
931: l_return_status := x_return_status;
932: RAISE G_EXCEPTION_HALT_VALIDATION;
933: ELSE
934: l_return_status := x_return_status; -- record that there was an error

Line 940: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

936: END IF;
937: END IF;
938: -- for LE Uptake project 08-11-2006
939: -- validate_isob_id(p_cnrv_rec, x_return_status);
940: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
941: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
942: l_return_status := x_return_status;
943: RAISE G_EXCEPTION_HALT_VALIDATION;
944: ELSE

Line 941: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

937: END IF;
938: -- for LE Uptake project 08-11-2006
939: -- validate_isob_id(p_cnrv_rec, x_return_status);
940: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
941: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
942: l_return_status := x_return_status;
943: RAISE G_EXCEPTION_HALT_VALIDATION;
944: ELSE
945: l_return_status := x_return_status; -- record that there was an error

Line 950: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

946: END IF;
947: END IF;
948:
949: -- validate_ibt_id(p_cnrv_rec, x_return_status);
950: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
951: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
952: l_return_status := x_return_status;
953: RAISE G_EXCEPTION_HALT_VALIDATION;
954: ELSE

Line 951: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

947: END IF;
948:
949: -- validate_ibt_id(p_cnrv_rec, x_return_status);
950: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
951: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
952: l_return_status := x_return_status;
953: RAISE G_EXCEPTION_HALT_VALIDATION;
954: ELSE
955: l_return_status := x_return_status; -- record that there was an error

Line 960: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

956: END IF;
957: END IF;
958:
959: -- validate_ixx_id(p_cnrv_rec, x_return_status);
960: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
961: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
962: l_return_status := x_return_status;
963: RAISE G_EXCEPTION_HALT_VALIDATION;
964: ELSE

Line 961: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

957: END IF;
958:
959: -- validate_ixx_id(p_cnrv_rec, x_return_status);
960: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
961: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
962: l_return_status := x_return_status;
963: RAISE G_EXCEPTION_HALT_VALIDATION;
964: ELSE
965: l_return_status := x_return_status; -- record that there was an error

Line 970: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

966: END IF;
967: END IF;
968:
969: -- validate_irm_id(p_cnrv_rec, x_return_status);
970: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
971: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
972: l_return_status := x_return_status;
973: RAISE G_EXCEPTION_HALT_VALIDATION;
974: ELSE

Line 971: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

967: END IF;
968:
969: -- validate_irm_id(p_cnrv_rec, x_return_status);
970: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
971: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
972: l_return_status := x_return_status;
973: RAISE G_EXCEPTION_HALT_VALIDATION;
974: ELSE
975: l_return_status := x_return_status; -- record that there was an error

Line 980: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

976: END IF;
977: END IF;
978:
979: validate_inf_id(p_cnrv_rec, x_return_status);
980: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
981: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
982: l_return_status := x_return_status;
983: RAISE G_EXCEPTION_HALT_VALIDATION;
984: ELSE

Line 981: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

977: END IF;
978:
979: validate_inf_id(p_cnrv_rec, x_return_status);
980: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
981: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
982: l_return_status := x_return_status;
983: RAISE G_EXCEPTION_HALT_VALIDATION;
984: ELSE
985: l_return_status := x_return_status; -- record that there was an error

Line 990: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

986: END IF;
987: END IF;
988:
989: validate_org_id(p_cnrv_rec, x_return_status);
990: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
991: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
992: l_return_status := x_return_status;
993: RAISE G_EXCEPTION_HALT_VALIDATION;
994: ELSE

Line 991: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

987: END IF;
988:
989: validate_org_id(p_cnrv_rec, x_return_status);
990: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
991: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
992: l_return_status := x_return_status;
993: RAISE G_EXCEPTION_HALT_VALIDATION;
994: ELSE
995: l_return_status := x_return_status; -- record that there was an error

Line 1667: IF (x_cnrv_rec.request_id IS NULL OR x_cnrv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

1663: x_cnrv_rec := p_cnrv_rec;
1664: x_cnrv_rec.OBJECT_VERSION_NUMBER := 1;
1665: x_cnrv_rec.SFWT_FLAG := 'N';
1666:
1667: IF (x_cnrv_rec.request_id IS NULL OR x_cnrv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1668: SELECT
1669: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1670: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1671: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

Line 2939: IF (x_cnrv_rec.request_id IS NULL OR x_cnrv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

2935: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2936: BEGIN
2937: x_cnrv_rec := p_cnrv_rec;
2938: x_cnrv_rec.OBJECT_VERSION_NUMBER := NVL(x_cnrv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2939: IF (x_cnrv_rec.request_id IS NULL OR x_cnrv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2940: -- Begin Post-Generation Change
2941: SELECT
2942: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2943: x_cnrv_rec.request_id),