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

Line 11: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

Line 13: IF p_lsmv_rec.id = Okl_Api.G_MISS_NUM OR

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

Line 17: x_return_status := Okl_Api.G_RET_STS_ERROR;

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

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

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

Line 35: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

Line 49: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

Line 51: IF p_lsmv_rec.object_version_number = Okl_Api.G_MISS_NUM OR

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

Line 55: x_return_status := Okl_Api.G_RET_STS_ERROR;

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

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

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

Line 80: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

76: WHERE id = p_lsmv_rec.lln_id;
77:
78:
79: BEGIN
80: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
81:
82: --Check for Null
83: IF p_lsmv_rec.lln_id = Okl_Api.G_MISS_NUM OR
84: p_lsmv_rec.lln_id IS NULL

Line 83: IF p_lsmv_rec.lln_id = Okl_Api.G_MISS_NUM OR

79: BEGIN
80: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
81:
82: --Check for Null
83: IF p_lsmv_rec.lln_id = Okl_Api.G_MISS_NUM OR
84: p_lsmv_rec.lln_id IS NULL
85: THEN
86:
87: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 87: x_return_status := Okl_Api.G_RET_STS_ERROR;

83: IF p_lsmv_rec.lln_id = Okl_Api.G_MISS_NUM OR
84: p_lsmv_rec.lln_id IS NULL
85: THEN
86:
87: x_return_status := Okl_Api.G_RET_STS_ERROR;
88: --set error message in message stack
89: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
90: p_msg_name => G_REQUIRED_VALUE,
91: p_token1 => G_COL_NAME_TOKEN,

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

85: THEN
86:
87: x_return_status := Okl_Api.G_RET_STS_ERROR;
88: --set error message in message stack
89: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
90: p_msg_name => G_REQUIRED_VALUE,
91: p_token1 => G_COL_NAME_TOKEN,
92: p_token1_value => 'lln_id');
93: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 104: x_return_status := Okl_Api.G_RET_STS_ERROR;

100: FETCH l_lln_id_csr INTO l_dummy_var;
101: CLOSE l_lln_id_csr;
102:
103: IF (l_dummy_var <> '1') THEN
104: x_return_status := Okl_Api.G_RET_STS_ERROR;
105: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
106: p_msg_name => G_NO_PARENT_RECORD,
107: p_token1 => G_COL_NAME_TOKEN,
108: p_token1_value => 'LLN_ID_FOR',

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

101: CLOSE l_lln_id_csr;
102:
103: IF (l_dummy_var <> '1') THEN
104: x_return_status := Okl_Api.G_RET_STS_ERROR;
105: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
106: p_msg_name => G_NO_PARENT_RECORD,
107: p_token1 => G_COL_NAME_TOKEN,
108: p_token1_value => 'LLN_ID_FOR',
109: p_token2 => G_CHILD_TABLE_TOKEN,

Line 133: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

129: WHERE id = p_lsmv_rec.sty_id;
130:
131:
132: BEGIN
133: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
134:
135: --Check for Null
136: IF p_lsmv_rec.sty_id = Okl_Api.G_MISS_NUM OR
137: p_lsmv_rec.sty_id IS NULL

Line 136: IF p_lsmv_rec.sty_id = Okl_Api.G_MISS_NUM OR

132: BEGIN
133: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
134:
135: --Check for Null
136: IF p_lsmv_rec.sty_id = Okl_Api.G_MISS_NUM OR
137: p_lsmv_rec.sty_id IS NULL
138: THEN
139:
140: x_return_status := Okl_Api.G_RET_STS_ERROR;

Line 140: x_return_status := Okl_Api.G_RET_STS_ERROR;

136: IF p_lsmv_rec.sty_id = Okl_Api.G_MISS_NUM OR
137: p_lsmv_rec.sty_id IS NULL
138: THEN
139:
140: x_return_status := Okl_Api.G_RET_STS_ERROR;
141: --set error message in message stack
142: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
143: p_msg_name => G_REQUIRED_VALUE,
144: p_token1 => G_COL_NAME_TOKEN,

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

138: THEN
139:
140: x_return_status := Okl_Api.G_RET_STS_ERROR;
141: --set error message in message stack
142: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
143: p_msg_name => G_REQUIRED_VALUE,
144: p_token1 => G_COL_NAME_TOKEN,
145: p_token1_value => 'sty_id');
146: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 157: x_return_status := Okl_Api.G_RET_STS_ERROR;

153: FETCH l_sty_id_csr INTO l_dummy_var;
154: CLOSE l_sty_id_csr;
155:
156: IF (l_dummy_var <> '1') THEN
157: x_return_status := Okl_Api.G_RET_STS_ERROR;
158: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
159: p_msg_name => G_NO_PARENT_RECORD,
160: p_token1 => G_COL_NAME_TOKEN,
161: p_token1_value => 'STY_ID_FOR',

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

154: CLOSE l_sty_id_csr;
155:
156: IF (l_dummy_var <> '1') THEN
157: x_return_status := Okl_Api.G_RET_STS_ERROR;
158: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
159: p_msg_name => G_NO_PARENT_RECORD,
160: p_token1 => G_COL_NAME_TOKEN,
161: p_token1_value => 'STY_ID_FOR',
162: p_token2 => G_CHILD_TABLE_TOKEN,

Line 186: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

182: WHERE id = p_lsmv_rec.kle_id;
183:
184:
185: BEGIN
186: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
187:
188: IF (p_lsmv_rec.kle_id IS NOT NULL) THEN
189: OPEN l_kle_id_csr;
190: FETCH l_kle_id_csr INTO l_dummy_var;

Line 194: x_return_status := Okl_Api.G_RET_STS_ERROR;

190: FETCH l_kle_id_csr INTO l_dummy_var;
191: CLOSE l_kle_id_csr;
192:
193: IF (l_dummy_var <> '1') THEN
194: x_return_status := Okl_Api.G_RET_STS_ERROR;
195: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
196: p_msg_name => G_NO_PARENT_RECORD,
197: p_token1 => G_COL_NAME_TOKEN,
198: p_token1_value => 'KLE_ID_FOR',

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

191: CLOSE l_kle_id_csr;
192:
193: IF (l_dummy_var <> '1') THEN
194: x_return_status := Okl_Api.G_RET_STS_ERROR;
195: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
196: p_msg_name => G_NO_PARENT_RECORD,
197: p_token1 => G_COL_NAME_TOKEN,
198: p_token1_value => 'KLE_ID_FOR',
199: p_token2 => G_CHILD_TABLE_TOKEN,

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

743: p_lsmv_rec IN lsmv_rec_type
744: ) RETURN VARCHAR2 IS
745: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
746: -- Added 04/19/2001 -- Sunil Mathew
747: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
748:
749: BEGIN
750: validate_lln_id(p_lsmv_rec, x_return_status);
751: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

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

747: x_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
748:
749: BEGIN
750: validate_lln_id(p_lsmv_rec, x_return_status);
751: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
752: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
753: l_return_status := x_return_status;
754: RAISE G_EXCEPTION_HALT_VALIDATION;
755: ELSE

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

748:
749: BEGIN
750: validate_lln_id(p_lsmv_rec, x_return_status);
751: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
752: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
753: l_return_status := x_return_status;
754: RAISE G_EXCEPTION_HALT_VALIDATION;
755: ELSE
756: l_return_status := x_return_status; -- record that there was an error

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

757: END IF;
758: END IF;
759:
760: validate_sty_id(p_lsmv_rec, x_return_status);
761: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
762: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
763: l_return_status := x_return_status;
764: RAISE G_EXCEPTION_HALT_VALIDATION;
765: ELSE

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

758: END IF;
759:
760: validate_sty_id(p_lsmv_rec, x_return_status);
761: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
762: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
763: l_return_status := x_return_status;
764: RAISE G_EXCEPTION_HALT_VALIDATION;
765: ELSE
766: l_return_status := x_return_status; -- record that there was an error

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

767: END IF;
768: END IF;
769:
770: validate_kle_id(p_lsmv_rec, x_return_status);
771: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
772: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
773: l_return_status := x_return_status;
774: RAISE G_EXCEPTION_HALT_VALIDATION;
775: ELSE

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

768: END IF;
769:
770: validate_kle_id(p_lsmv_rec, x_return_status);
771: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
772: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
773: l_return_status := x_return_status;
774: RAISE G_EXCEPTION_HALT_VALIDATION;
775: ELSE
776: l_return_status := x_return_status; -- record that there was an error

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

777: END IF;
778: END IF;
779:
780: validate_id(p_lsmv_rec, x_return_status);
781: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
782: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
783: l_return_status := x_return_status;
784: RAISE G_EXCEPTION_HALT_VALIDATION;
785: ELSE

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

778: END IF;
779:
780: validate_id(p_lsmv_rec, x_return_status);
781: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
782: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
783: l_return_status := x_return_status;
784: RAISE G_EXCEPTION_HALT_VALIDATION;
785: ELSE
786: l_return_status := x_return_status; -- record that there was an error

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

787: END IF;
788: END IF;
789:
790: validate_object_version_number(p_lsmv_rec, x_return_status);
791: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
792: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
793: l_return_status := x_return_status;
794: RAISE G_EXCEPTION_HALT_VALIDATION;
795: ELSE

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

788: END IF;
789:
790: validate_object_version_number(p_lsmv_rec, x_return_status);
791: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
792: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
793: l_return_status := x_return_status;
794: RAISE G_EXCEPTION_HALT_VALIDATION;
795: ELSE
796: l_return_status := x_return_status; -- record that there was an error

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

797: END IF;
798: END IF;
799:
800: validate_org_id(p_lsmv_rec, x_return_status);
801: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
803: l_return_status := x_return_status;
804: RAISE G_EXCEPTION_HALT_VALIDATION;
805: ELSE

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

798: END IF;
799:
800: validate_org_id(p_lsmv_rec, x_return_status);
801: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
803: l_return_status := x_return_status;
804: RAISE G_EXCEPTION_HALT_VALIDATION;
805: ELSE
806: l_return_status := x_return_status; -- record that there was an error

Line 1074: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1070: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1071: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1072: -- Begin Post-Generation Change
1073: -- overall error status
1074: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1075: -- End Post-Generation Change
1076:
1077: i NUMBER := 0;
1078: BEGIN

Line 1094: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1090: p_lsmv_rec => p_lsmv_tbl(i));
1091:
1092: -- Begin Post-Generation Change
1093: -- store the highest degree of error
1094: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1095: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1096: l_overall_status := x_return_status;
1097: END IF;
1098: END IF;

Line 1095: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1091:
1092: -- Begin Post-Generation Change
1093: -- store the highest degree of error
1094: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1095: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1096: l_overall_status := x_return_status;
1097: END IF;
1098: END IF;
1099: -- End Post-Generation Change

Line 1478: IF (x_lsmv_rec.request_id IS NULL OR x_lsmv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

1474: x_lsmv_rec := p_lsmv_rec;
1475: x_lsmv_rec.OBJECT_VERSION_NUMBER := 1;
1476: x_lsmv_rec.SFWT_FLAG := 'N';
1477:
1478: IF (x_lsmv_rec.request_id IS NULL OR x_lsmv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
1479: SELECT
1480: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1481: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
1482: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

Line 1623: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1619: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1620: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1621: -- Begin Post-Generation Change
1622: -- overall error status
1623: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1624: -- End Post-Generation Change
1625:
1626: i NUMBER := 0;
1627: BEGIN

Line 1643: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1639: p_lsmv_rec => p_lsmv_tbl(i),
1640: x_lsmv_rec => x_lsmv_tbl(i));
1641: -- Begin Post-Generation Change
1642: -- store the highest degree of error
1643: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1644: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1645: l_overall_status := x_return_status;
1646: END IF;
1647: END IF;

Line 1644: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1640: x_lsmv_rec => x_lsmv_tbl(i));
1641: -- Begin Post-Generation Change
1642: -- store the highest degree of error
1643: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1644: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1645: l_overall_status := x_return_status;
1646: END IF;
1647: END IF;
1648: -- End Post-Generation Change

Line 1995: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1991: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1992: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1993: -- Begin Post-Generation Change
1994: -- overall error status
1995: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1996: -- End Post-Generation Change
1997:
1998: i NUMBER := 0;
1999: BEGIN

Line 2015: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2011: p_lsmv_rec => p_lsmv_tbl(i));
2012:
2013: -- Begin Post-Generation Change
2014: -- store the highest degree of error
2015: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2016: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2017: l_overall_status := x_return_status;
2018: END IF;
2019: END IF;

Line 2016: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2012:
2013: -- Begin Post-Generation Change
2014: -- store the highest degree of error
2015: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2016: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2017: l_overall_status := x_return_status;
2018: END IF;
2019: END IF;
2020: -- End Post-Generation Change

Line 2806: IF (x_lsmv_rec.request_id IS NULL OR x_lsmv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

2802: BEGIN
2803: x_lsmv_rec := p_lsmv_rec;
2804: x_lsmv_rec.OBJECT_VERSION_NUMBER := NVL(x_lsmv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
2805:
2806: IF (x_lsmv_rec.request_id IS NULL OR x_lsmv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
2807: -- Begin Post-Generation Change
2808: SELECT
2809: NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
2810: x_lsmv_rec.request_id),

Line 2960: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

2956: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2957: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2958: -- Begin Post-Generation Change
2959: -- overall error status
2960: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2961: -- End Post-Generation Change
2962:
2963: i NUMBER := 0;
2964: BEGIN

Line 2981: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2977: x_lsmv_rec => x_lsmv_tbl(i));
2978:
2979: -- Begin Post-Generation Change
2980: -- store the highest degree of error
2981: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2982: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2983: l_overall_status := x_return_status;
2984: END IF;
2985: END IF;

Line 2982: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

2978:
2979: -- Begin Post-Generation Change
2980: -- store the highest degree of error
2981: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2982: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
2983: l_overall_status := x_return_status;
2984: END IF;
2985: END IF;
2986: -- End Post-Generation Change