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.

[Home] [Help]

APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on FND_API

Line 22: p_effectivity_detail_rec.serial_number_from <> FND_API.G_MISS_CHAR ) THEN

18:
19: BEGIN
20:
21: IF ( p_effectivity_detail_rec.serial_number_from IS NOT NULL AND
22: p_effectivity_detail_rec.serial_number_from <> FND_API.G_MISS_CHAR ) THEN
23: l_record_identifier := l_record_identifier || p_effectivity_detail_rec.serial_number_from;
24: END IF;
25:
26: l_record_identifier := l_record_identifier || ' - ';

Line 29: p_effectivity_detail_rec.serial_number_to <> FND_API.G_MISS_CHAR ) THEN

25:
26: l_record_identifier := l_record_identifier || ' - ';
27:
28: IF ( p_effectivity_detail_rec.serial_number_to IS NOT NULL AND
29: p_effectivity_detail_rec.serial_number_to <> FND_API.G_MISS_CHAR ) THEN
30: l_record_identifier := l_record_identifier || p_effectivity_detail_rec.serial_number_to;
31: END IF;
32:
33: l_record_identifier := l_record_identifier || ' - ';

Line 36: p_effectivity_detail_rec.manufacturer <> FND_API.G_MISS_CHAR ) THEN

32:
33: l_record_identifier := l_record_identifier || ' - ';
34:
35: IF ( p_effectivity_detail_rec.manufacturer IS NOT NULL AND
36: p_effectivity_detail_rec.manufacturer <> FND_API.G_MISS_CHAR ) THEN
37: l_record_identifier := l_record_identifier || p_effectivity_detail_rec.manufacturer;
38: END IF;
39:
40: l_record_identifier := l_record_identifier || ' - ';

Line 43: p_effectivity_detail_rec.manufacture_date_from <> FND_API.G_MISS_DATE ) THEN

39:
40: l_record_identifier := l_record_identifier || ' - ';
41:
42: IF ( p_effectivity_detail_rec.manufacture_date_from IS NOT NULL AND
43: p_effectivity_detail_rec.manufacture_date_from <> FND_API.G_MISS_DATE ) THEN
44: l_record_identifier := l_record_identifier || TO_CHAR( p_effectivity_detail_rec.manufacture_date_from, 'DD-MON-YYYY' );
45: END IF;
46:
47: l_record_identifier := l_record_identifier || ' - ';

Line 50: p_effectivity_detail_rec.manufacture_date_to <> FND_API.G_MISS_DATE ) THEN

46:
47: l_record_identifier := l_record_identifier || ' - ';
48:
49: IF ( p_effectivity_detail_rec.manufacture_date_to IS NOT NULL AND
50: p_effectivity_detail_rec.manufacture_date_to <> FND_API.G_MISS_DATE ) THEN
51: l_record_identifier := l_record_identifier || TO_CHAR( p_effectivity_detail_rec.manufacture_date_to, 'DD-MON-YYYY' );
52: END IF;
53:
54: l_record_identifier := l_record_identifier || ' - ';

Line 57: p_effectivity_detail_rec.country <> FND_API.G_MISS_CHAR ) THEN

53:
54: l_record_identifier := l_record_identifier || ' - ';
55:
56: IF ( p_effectivity_detail_rec.country IS NOT NULL AND
57: p_effectivity_detail_rec.country <> FND_API.G_MISS_CHAR ) THEN
58: l_record_identifier := l_record_identifier || p_effectivity_detail_rec.country;
59: END IF;
60:
61: RETURN l_record_identifier;

Line 77: p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR ) THEN

73:
74: BEGIN
75: IF ( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
76: IF ( p_effty_ext_detail_rec.owner IS NOT NULL AND
77: p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR ) THEN
78: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.owner;
79: END IF;
80: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
81: IF ( p_effty_ext_detail_rec.location IS NOT NULL AND

Line 82: p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR ) THEN

78: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.owner;
79: END IF;
80: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
81: IF ( p_effty_ext_detail_rec.location IS NOT NULL AND
82: p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR ) THEN
83: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.location;
84: END IF;
85: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
86: IF ( p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL AND

Line 87: p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ) THEN

83: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.location;
84: END IF;
85: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
86: IF ( p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL AND
87: p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ) THEN
88: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE;
89: END IF;
90: l_record_identifier := l_record_identifier || ' - ';
91: /*IF ( p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL AND

Line 92: p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR ) THEN

88: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE;
89: END IF;
90: l_record_identifier := l_record_identifier || ' - ';
91: /*IF ( p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL AND
92: p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR ) THEN
93: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME;
94: END IF;
95: l_record_identifier := l_record_identifier || ' - ';*/
96: IF ( p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE IS NOT NULL AND

Line 97: p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE <> FND_API.G_MISS_CHAR ) THEN

93: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME;
94: END IF;
95: l_record_identifier := l_record_identifier || ' - ';*/
96: IF ( p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE IS NOT NULL AND
97: p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE <> FND_API.G_MISS_CHAR ) THEN
98: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE;
99: END IF;
100: ELSE
101: IF ( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE IS NOT NULL AND

Line 102: p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE <> FND_API.G_MISS_CHAR ) THEN

98: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE;
99: END IF;
100: ELSE
101: IF ( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE IS NOT NULL AND
102: p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE <> FND_API.G_MISS_CHAR ) THEN
103: l_record_identifier := l_record_identifier || p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE;
104: END IF;
105: END IF;
106:

Line 125: x_return_status := FND_API.G_RET_STS_SUCCESS;

121: l_return_status VARCHAR2(1);
122: l_msg_data VARCHAR2(2000);
123: l_appln_code VARCHAR2(30);
124: BEGIN
125: x_return_status := FND_API.G_RET_STS_SUCCESS;
126:
127: -- Check Profile value
128:
129: IF G_APPLN_USAGE IS NULL THEN

Line 139: x_return_status := FND_API.G_RET_STS_ERROR;

135:
136: IF ( G_APPLN_USAGE = 'PM' ) THEN
137: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_MED_PM_INSTALL' );
138: FND_MSG_PUB.add;
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: RETURN;
141: END IF;
142:
143: -- Check if a valid value is passed in p_mr_header_id

Line 145: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR

141: END IF;
142:
143: -- Check if a valid value is passed in p_mr_header_id
144:
145: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
146: p_mr_header_id IS NULL ) THEN
147: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
148: FND_MSG_PUB.add;
149: x_return_status := FND_API.G_RET_STS_ERROR;

Line 149: x_return_status := FND_API.G_RET_STS_ERROR;

145: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
146: p_mr_header_id IS NULL ) THEN
147: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
148: FND_MSG_PUB.add;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: RETURN;
151: END IF;
152:
153: -- Check if the Maintenance Requirement is in Updatable status

Line 161: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

157: x_msg_data => l_msg_data,
158: p_mr_header_id => p_mr_header_id
159: );
160:
161: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
162: FND_MESSAGE.set_name( 'AHL', l_msg_data );
163: FND_MSG_PUB.add;
164: x_return_status := l_return_status;
165: RETURN;

Line 169: IF ( p_mr_effectivity_id = FND_API.G_MISS_NUM OR

165: RETURN;
166: END IF;
167:
168: -- Check if a valid value is passed in p_mr_effectivity_id
169: IF ( p_mr_effectivity_id = FND_API.G_MISS_NUM OR
170: p_mr_effectivity_id IS NULL ) THEN
171: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MRE_ID_NULL' );
172: FND_MSG_PUB.add;
173: x_return_status := FND_API.G_RET_STS_ERROR;

Line 173: x_return_status := FND_API.G_RET_STS_ERROR;

169: IF ( p_mr_effectivity_id = FND_API.G_MISS_NUM OR
170: p_mr_effectivity_id IS NULL ) THEN
171: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MRE_ID_NULL' );
172: FND_MSG_PUB.add;
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: RETURN;
175: END IF;
176:
177: -- Check if the Maintenance Requirement Effectivity exists

Line 185: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

181: x_msg_data => l_msg_data,
182: p_mr_effectivity_id => p_mr_effectivity_id
183: );
184:
185: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
186: FND_MESSAGE.set_name( 'AHL', l_msg_data );
187: FND_MSG_PUB.add;
188: x_return_status := l_return_status;
189: RETURN;

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: IF ( p_effectivity_detail_tbl.count < 1 AND p_effty_ext_detail_tbl.count < 1 ) THEN
194: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
195: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
196: FND_MSG_PUB.add;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: RETURN;
199: END IF;
200:
201: -- Validate DML Operation

Line 210: x_return_status := FND_API.G_RET_STS_ERROR;

206: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
207: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_tbl(i).dml_operation );
208: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_tbl(i) ) );
209: FND_MSG_PUB.add;
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: RETURN;
212: END IF;
213: END LOOP;
214:

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
221: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).dml_operation );
222: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );
223: FND_MSG_PUB.add;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: RETURN;
226: END IF;
227: IF ( p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'OWNER' AND
228: p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'LOCATION' AND

Line 234: x_return_status := FND_API.G_RET_STS_ERROR;

230: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
231: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE );
232: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );
233: FND_MSG_PUB.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: RETURN;
236: END IF;
237: END LOOP;
238:

Line 252: ELSIF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN

248: BEGIN
249:
250: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL ) THEN
251: p_x_effectivity_detail_rec.manufacturer_id := NULL;
252: ELSIF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
253: p_x_effectivity_detail_rec.manufacturer_id := FND_API.G_MISS_NUM;
254: END IF;
255:
256: IF ( p_x_effectivity_detail_rec.country IS NULL ) THEN

Line 253: p_x_effectivity_detail_rec.manufacturer_id := FND_API.G_MISS_NUM;

249:
250: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL ) THEN
251: p_x_effectivity_detail_rec.manufacturer_id := NULL;
252: ELSIF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
253: p_x_effectivity_detail_rec.manufacturer_id := FND_API.G_MISS_NUM;
254: END IF;
255:
256: IF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
257: p_x_effectivity_detail_rec.country_code := NULL;

Line 258: ELSIF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN

254: END IF;
255:
256: IF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
257: p_x_effectivity_detail_rec.country_code := NULL;
258: ELSIF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
259: p_x_effectivity_detail_rec.country_code := FND_API.G_MISS_CHAR;
260: END IF;
261:
262: END clear_lov_attribute_ids;

Line 259: p_x_effectivity_detail_rec.country_code := FND_API.G_MISS_CHAR;

255:
256: IF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
257: p_x_effectivity_detail_rec.country_code := NULL;
258: ELSIF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
259: p_x_effectivity_detail_rec.country_code := FND_API.G_MISS_CHAR;
260: END IF;
261:
262: END clear_lov_attribute_ids;
263:

Line 276: ELSIF ( p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN

272:
273: IF ( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
274: IF ( p_x_effty_ext_detail_rec.owner IS NULL ) THEN
275: p_x_effty_ext_detail_rec.owner_id := NULL;
276: ELSIF ( p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
277: p_x_effty_ext_detail_rec.owner_id := FND_API.G_MISS_NUM;
278: END IF;
279: ELSIF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
280: IF ( p_x_effty_ext_detail_rec.location IS NULL ) THEN

Line 277: p_x_effty_ext_detail_rec.owner_id := FND_API.G_MISS_NUM;

273: IF ( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
274: IF ( p_x_effty_ext_detail_rec.owner IS NULL ) THEN
275: p_x_effty_ext_detail_rec.owner_id := NULL;
276: ELSIF ( p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
277: p_x_effty_ext_detail_rec.owner_id := FND_API.G_MISS_NUM;
278: END IF;
279: ELSIF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
280: IF ( p_x_effty_ext_detail_rec.location IS NULL ) THEN
281: p_x_effty_ext_detail_rec.location_type_code := NULL;

Line 282: ELSIF ( p_x_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR ) THEN

278: END IF;
279: ELSIF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
280: IF ( p_x_effty_ext_detail_rec.location IS NULL ) THEN
281: p_x_effty_ext_detail_rec.location_type_code := NULL;
282: ELSIF ( p_x_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR ) THEN
283: p_x_effty_ext_detail_rec.location_type_code := FND_API.G_MISS_CHAR;
284: END IF;
285: ELSIF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
286: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL )THEN

Line 283: p_x_effty_ext_detail_rec.location_type_code := FND_API.G_MISS_CHAR;

279: ELSIF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
280: IF ( p_x_effty_ext_detail_rec.location IS NULL ) THEN
281: p_x_effty_ext_detail_rec.location_type_code := NULL;
282: ELSIF ( p_x_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR ) THEN
283: p_x_effty_ext_detail_rec.location_type_code := FND_API.G_MISS_CHAR;
284: END IF;
285: ELSIF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
286: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL )THEN
287: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME := NULL;

Line 288: ELSIF (p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR)THEN

284: END IF;
285: ELSIF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
286: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL )THEN
287: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME := NULL;
288: ELSIF (p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR)THEN
289: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME := FND_API.G_MISS_CHAR;
290: END IF;
291: END IF;
292:

Line 289: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME := FND_API.G_MISS_CHAR;

285: ELSIF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
286: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL )THEN
287: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME := NULL;
288: ELSIF (p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR)THEN
289: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME := FND_API.G_MISS_CHAR;
290: END IF;
291: END IF;
292:
293:

Line 326: x_return_status := FND_API.G_RET_STS_SUCCESS;

322: FROM AHL_MR_EFFECTIVITIES_V
323: WHERE mr_effectivity_id = c_mr_effectivity_id;
324:
325: BEGIN
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327:
328: -- Convert / Validate Manufacturer
329: IF ( ( p_x_effectivity_detail_rec.manufacturer_id IS NOT NULL AND
330: p_x_effectivity_detail_rec.manufacturer_id <> FND_API.G_MISS_NUM ) OR

Line 330: p_x_effectivity_detail_rec.manufacturer_id <> FND_API.G_MISS_NUM ) OR

326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327:
328: -- Convert / Validate Manufacturer
329: IF ( ( p_x_effectivity_detail_rec.manufacturer_id IS NOT NULL AND
330: p_x_effectivity_detail_rec.manufacturer_id <> FND_API.G_MISS_NUM ) OR
331: ( p_x_effectivity_detail_rec.manufacturer IS NOT NULL AND
332: p_x_effectivity_detail_rec.manufacturer <> FND_API.G_MISS_CHAR ) ) THEN
333:
334: OPEN get_item_effectivity( p_mr_effectivity_id );

Line 332: p_x_effectivity_detail_rec.manufacturer <> FND_API.G_MISS_CHAR ) ) THEN

328: -- Convert / Validate Manufacturer
329: IF ( ( p_x_effectivity_detail_rec.manufacturer_id IS NOT NULL AND
330: p_x_effectivity_detail_rec.manufacturer_id <> FND_API.G_MISS_NUM ) OR
331: ( p_x_effectivity_detail_rec.manufacturer IS NOT NULL AND
332: p_x_effectivity_detail_rec.manufacturer <> FND_API.G_MISS_CHAR ) ) THEN
333:
334: OPEN get_item_effectivity( p_mr_effectivity_id );
335:
336: FETCH get_item_effectivity INTO

Line 354: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

350: p_manufacturer_name => p_x_effectivity_detail_rec.manufacturer,
351: p_x_manufacturer_id => p_x_effectivity_detail_rec.manufacturer_id
352: );
353:
354: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
355: FND_MESSAGE.set_name( 'AHL', l_msg_data );
356:
357: IF ( l_msg_data = 'AHL_FMP_INVALID_MF' OR
358: l_msg_data = 'AHL_FMP_TOO_MANY_MFS' ) THEN

Line 360: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN

356:
357: IF ( l_msg_data = 'AHL_FMP_INVALID_MF' OR
358: l_msg_data = 'AHL_FMP_TOO_MANY_MFS' ) THEN
359: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR
360: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
361: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));
362: ELSE
363: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.manufacturer );
364: END IF;

Line 367: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN

363: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.manufacturer );
364: END IF;
365: ELSE
366: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR
367: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
368: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));
369: ELSE
370: FND_MESSAGE.set_token( 'FIELD1', p_x_effectivity_detail_rec.manufacturer );
371: END IF;

Line 388: p_x_effectivity_detail_rec.country_code <> FND_API.G_MISS_CHAR )

384: END IF;
385:
386: -- Convert / Validate Country
387: IF ( ( p_x_effectivity_detail_rec.country_code IS NOT NULL AND
388: p_x_effectivity_detail_rec.country_code <> FND_API.G_MISS_CHAR )
389: OR
390: ( p_x_effectivity_detail_rec.country IS NOT NULL AND
391: p_x_effectivity_detail_rec.country <> FND_API.G_MISS_CHAR ) )
392: THEN

Line 391: p_x_effectivity_detail_rec.country <> FND_API.G_MISS_CHAR ) )

387: IF ( ( p_x_effectivity_detail_rec.country_code IS NOT NULL AND
388: p_x_effectivity_detail_rec.country_code <> FND_API.G_MISS_CHAR )
389: OR
390: ( p_x_effectivity_detail_rec.country IS NOT NULL AND
391: p_x_effectivity_detail_rec.country <> FND_API.G_MISS_CHAR ) )
392: THEN
393:
394: AHL_FMP_COMMON_PVT.validate_country
395: (

Line 402: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

398: p_country_name => p_x_effectivity_detail_rec.country,
399: p_x_country_code => p_x_effectivity_detail_rec.country_code
400: );
401:
402: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
403: FND_MESSAGE.set_name( 'AHL', l_msg_data );
404: IF ( p_x_effectivity_detail_rec.country IS NULL OR
405: p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
406: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country_code );

Line 405: p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN

401:
402: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
403: FND_MESSAGE.set_name( 'AHL', l_msg_data );
404: IF ( p_x_effectivity_detail_rec.country IS NULL OR
405: p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
406: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country_code );
407: ELSE
408: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country );
409: END IF;

Line 447: x_return_status := FND_API.G_RET_STS_SUCCESS;

443: FROM AHL_MR_EFFECTIVITIES_V
444: WHERE mr_effectivity_id = c_mr_effectivity_id;
445:
446: BEGIN
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448:
449: -- Convert / Validate Manufacturer
450: IF ( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
451: IF ( ( p_x_effty_ext_detail_rec.owner_id IS NOT NULL AND

Line 452: p_x_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM ) OR

448:
449: -- Convert / Validate Manufacturer
450: IF ( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
451: IF ( ( p_x_effty_ext_detail_rec.owner_id IS NOT NULL AND
452: p_x_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM ) OR
453: ( p_x_effty_ext_detail_rec.owner IS NOT NULL AND
454: p_x_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR ) ) THEN
455:
456: OPEN get_item_effectivity( p_mr_effectivity_id );

Line 454: p_x_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR ) ) THEN

450: IF ( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
451: IF ( ( p_x_effty_ext_detail_rec.owner_id IS NOT NULL AND
452: p_x_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM ) OR
453: ( p_x_effty_ext_detail_rec.owner IS NOT NULL AND
454: p_x_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR ) ) THEN
455:
456: OPEN get_item_effectivity( p_mr_effectivity_id );
457:
458: FETCH get_item_effectivity INTO

Line 474: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

470: p_owner => p_x_effty_ext_detail_rec.owner,
471: p_x_owner_id => p_x_effty_ext_detail_rec.owner_id
472: );
473:
474: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
475: FND_MESSAGE.set_name( 'AHL', l_msg_data );
476:
477: IF ( l_msg_data = 'AHL_FMP_INVALID_OWNER' OR
478: l_msg_data = 'AHL_FMP_INV_TOO_MANY_OWNERS' ) THEN

Line 480: p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN

476:
477: IF ( l_msg_data = 'AHL_FMP_INVALID_OWNER' OR
478: l_msg_data = 'AHL_FMP_INV_TOO_MANY_OWNERS' ) THEN
479: IF ( p_x_effty_ext_detail_rec.owner IS NULL OR
480: p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
481: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effty_ext_detail_rec.owner_id ));
482: ELSE
483: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );
484: END IF;

Line 487: p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN

483: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );
484: END IF;
485: ELSE
486: IF ( p_x_effty_ext_detail_rec.owner IS NULL OR
487: p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
488: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effty_ext_detail_rec.owner_id ));
489: ELSE
490: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );
491: END IF;

Line 503: p_x_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )

499:
500: -- Convert / Validate Location
501: IF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
502: IF ( ( p_x_effty_ext_detail_rec.location_type_code IS NOT NULL AND
503: p_x_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )
504: OR
505: ( p_x_effty_ext_detail_rec.location IS NOT NULL AND
506: p_x_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR ) )
507: THEN

Line 506: p_x_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR ) )

502: IF ( ( p_x_effty_ext_detail_rec.location_type_code IS NOT NULL AND
503: p_x_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )
504: OR
505: ( p_x_effty_ext_detail_rec.location IS NOT NULL AND
506: p_x_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR ) )
507: THEN
508:
509: AHL_FMP_COMMON_PVT.validate_location
510: (

Line 517: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

513: p_location => p_x_effty_ext_detail_rec.location,
514: p_x_location_type_code => p_x_effty_ext_detail_rec.location_type_code
515: );
516:
517: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
518: FND_MESSAGE.set_name( 'AHL', l_msg_data );
519: IF ( p_x_effty_ext_detail_rec.location IS NULL OR
520: p_x_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR ) THEN
521: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location_type_code );

Line 520: p_x_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR ) THEN

516:
517: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
518: FND_MESSAGE.set_name( 'AHL', l_msg_data );
519: IF ( p_x_effty_ext_detail_rec.location IS NULL OR
520: p_x_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR ) THEN
521: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location_type_code );
522: ELSE
523: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location );
524: END IF;

Line 534: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR )

530:
531: -- Convert / Validate Location
532: IF( p_x_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
533: IF ( ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL AND
534: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR )
535: OR
536: ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL AND
537: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR ) )
538: THEN

Line 537: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR ) )

533: IF ( ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL AND
534: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR )
535: OR
536: ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL AND
537: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR ) )
538: THEN
539:
540: AHL_FMP_COMMON_PVT.validate_csi_ext_attribute
541: (

Line 548: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

544: p_csi_attribute_name => p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME,
545: p_x_csi_attribute_code => p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE
546: );
547:
548: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
549: FND_MESSAGE.set_name( 'AHL', l_msg_data );
550: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR
551: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN
552: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE );

Line 551: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN

547:
548: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
549: FND_MESSAGE.set_name( 'AHL', l_msg_data );
550: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR
551: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN
552: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE );
553: ELSE
554: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME );
555: END IF;

Line 616: IF ( p_x_effectivity_detail_rec.serial_number_from = FND_API.G_MISS_CHAR ) THEN

612:
613: BEGIN
614:
615: -- Convert G_MISS values to NULL
616: IF ( p_x_effectivity_detail_rec.serial_number_from = FND_API.G_MISS_CHAR ) THEN
617: p_x_effectivity_detail_rec.serial_number_from := null;
618: END IF;
619:
620: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN

Line 620: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN

616: IF ( p_x_effectivity_detail_rec.serial_number_from = FND_API.G_MISS_CHAR ) THEN
617: p_x_effectivity_detail_rec.serial_number_from := null;
618: END IF;
619:
620: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN
621: p_x_effectivity_detail_rec.serial_number_to := null;
622: END IF;
623:
624: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN

Line 624: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN

620: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN
621: p_x_effectivity_detail_rec.serial_number_to := null;
622: END IF;
623:
624: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN
625: p_x_effectivity_detail_rec.manufacturer_id := null;
626: END IF;
627:
628: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN

Line 628: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN

624: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN
625: p_x_effectivity_detail_rec.manufacturer_id := null;
626: END IF;
627:
628: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
629: p_x_effectivity_detail_rec.manufacturer := null;
630: END IF;
631:
632: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN

Line 632: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN

628: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
629: p_x_effectivity_detail_rec.manufacturer := null;
630: END IF;
631:
632: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN
633: p_x_effectivity_detail_rec.manufacture_date_from := null;
634: END IF;
635:
636: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN

Line 636: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN

632: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN
633: p_x_effectivity_detail_rec.manufacture_date_from := null;
634: END IF;
635:
636: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN
637: p_x_effectivity_detail_rec.manufacture_date_to := null;
638: END IF;
639:
640: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN

Line 640: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN

636: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN
637: p_x_effectivity_detail_rec.manufacture_date_to := null;
638: END IF;
639:
640: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN
641: p_x_effectivity_detail_rec.country_code := null;
642: END IF;
643:
644: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN

Line 644: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN

640: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN
641: p_x_effectivity_detail_rec.country_code := null;
642: END IF;
643:
644: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
645: p_x_effectivity_detail_rec.country := null;
646: END IF;
647:
648: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

Line 648: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

644: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
645: p_x_effectivity_detail_rec.country := null;
646: END IF;
647:
648: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
649: p_x_effectivity_detail_rec.attribute_category := null;
650: END IF;
651:
652: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

Line 652: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

648: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
649: p_x_effectivity_detail_rec.attribute_category := null;
650: END IF;
651:
652: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
653: p_x_effectivity_detail_rec.attribute1 := null;
654: END IF;
655:
656: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

Line 656: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

652: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
653: p_x_effectivity_detail_rec.attribute1 := null;
654: END IF;
655:
656: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
657: p_x_effectivity_detail_rec.attribute2 := null;
658: END IF;
659:
660: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

Line 660: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

656: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
657: p_x_effectivity_detail_rec.attribute2 := null;
658: END IF;
659:
660: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
661: p_x_effectivity_detail_rec.attribute3 := null;
662: END IF;
663:
664: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

Line 664: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

660: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
661: p_x_effectivity_detail_rec.attribute3 := null;
662: END IF;
663:
664: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
665: p_x_effectivity_detail_rec.attribute4 := null;
666: END IF;
667:
668: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

Line 668: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

664: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
665: p_x_effectivity_detail_rec.attribute4 := null;
666: END IF;
667:
668: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
669: p_x_effectivity_detail_rec.attribute5 := null;
670: END IF;
671:
672: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

Line 672: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

668: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
669: p_x_effectivity_detail_rec.attribute5 := null;
670: END IF;
671:
672: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
673: p_x_effectivity_detail_rec.attribute6 := null;
674: END IF;
675:
676: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

Line 676: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

672: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
673: p_x_effectivity_detail_rec.attribute6 := null;
674: END IF;
675:
676: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
677: p_x_effectivity_detail_rec.attribute7 := null;
678: END IF;
679:
680: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

Line 680: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

676: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
677: p_x_effectivity_detail_rec.attribute7 := null;
678: END IF;
679:
680: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
681: p_x_effectivity_detail_rec.attribute8 := null;
682: END IF;
683:
684: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

Line 684: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

680: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
681: p_x_effectivity_detail_rec.attribute8 := null;
682: END IF;
683:
684: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
685: p_x_effectivity_detail_rec.attribute9 := null;
686: END IF;
687:
688: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

Line 688: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

684: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
685: p_x_effectivity_detail_rec.attribute9 := null;
686: END IF;
687:
688: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
689: p_x_effectivity_detail_rec.attribute10 := null;
690: END IF;
691:
692: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

Line 692: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

688: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
689: p_x_effectivity_detail_rec.attribute10 := null;
690: END IF;
691:
692: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
693: p_x_effectivity_detail_rec.attribute11 := null;
694: END IF;
695:
696: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

Line 696: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

692: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
693: p_x_effectivity_detail_rec.attribute11 := null;
694: END IF;
695:
696: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
697: p_x_effectivity_detail_rec.attribute12 := null;
698: END IF;
699:
700: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

Line 700: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

696: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
697: p_x_effectivity_detail_rec.attribute12 := null;
698: END IF;
699:
700: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
701: p_x_effectivity_detail_rec.attribute13 := null;
702: END IF;
703:
704: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

Line 704: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

700: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
701: p_x_effectivity_detail_rec.attribute13 := null;
702: END IF;
703:
704: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
705: p_x_effectivity_detail_rec.attribute14 := null;
706: END IF;
707:
708: IF ( p_x_effectivity_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

Line 708: IF ( p_x_effectivity_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

704: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
705: p_x_effectivity_detail_rec.attribute14 := null;
706: END IF;
707:
708: IF ( p_x_effectivity_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
709: p_x_effectivity_detail_rec.attribute15 := null;
710: END IF;
711:
712: END default_missing_attributes;

Line 724: IF ( p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN

720:
721: BEGIN
722:
723: -- Convert G_MISS values to NULL
724: IF ( p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
725: p_x_effty_ext_detail_rec.owner := null;
726: END IF;
727:
728: IF ( p_x_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM ) THEN

Line 728: IF ( p_x_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM ) THEN

724: IF ( p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
725: p_x_effty_ext_detail_rec.owner := null;
726: END IF;
727:
728: IF ( p_x_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM ) THEN
729: p_x_effty_ext_detail_rec.owner_id := null;
730: END IF;
731:
732: IF ( p_x_effty_ext_detail_rec.LOCATION = FND_API.G_MISS_CHAR ) THEN

Line 732: IF ( p_x_effty_ext_detail_rec.LOCATION = FND_API.G_MISS_CHAR ) THEN

728: IF ( p_x_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM ) THEN
729: p_x_effty_ext_detail_rec.owner_id := null;
730: END IF;
731:
732: IF ( p_x_effty_ext_detail_rec.LOCATION = FND_API.G_MISS_CHAR ) THEN
733: p_x_effty_ext_detail_rec.LOCATION := null;
734: END IF;
735:
736: IF ( p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE = FND_API.G_MISS_CHAR ) THEN

Line 736: IF ( p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE = FND_API.G_MISS_CHAR ) THEN

732: IF ( p_x_effty_ext_detail_rec.LOCATION = FND_API.G_MISS_CHAR ) THEN
733: p_x_effty_ext_detail_rec.LOCATION := null;
734: END IF;
735:
736: IF ( p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE = FND_API.G_MISS_CHAR ) THEN
737: p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE := null;
738: END IF;
739:
740: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ) THEN

Line 740: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ) THEN

736: IF ( p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE = FND_API.G_MISS_CHAR ) THEN
737: p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE := null;
738: END IF;
739:
740: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ) THEN
741: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE := null;
742: END IF;
743:
744: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN

Line 744: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN

740: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ) THEN
741: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE := null;
742: END IF;
743:
744: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN
745: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME := null;
746: END IF;
747:
748: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE = FND_API.G_MISS_CHAR ) THEN

Line 748: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE = FND_API.G_MISS_CHAR ) THEN

744: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN
745: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME := null;
746: END IF;
747:
748: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE = FND_API.G_MISS_CHAR ) THEN
749: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE := null;
750: END IF;
751:
752: IF ( p_x_effty_ext_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

Line 752: IF ( p_x_effty_ext_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

748: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE = FND_API.G_MISS_CHAR ) THEN
749: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE := null;
750: END IF;
751:
752: IF ( p_x_effty_ext_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
753: p_x_effty_ext_detail_rec.attribute_category := null;
754: END IF;
755:
756: IF ( p_x_effty_ext_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

Line 756: IF ( p_x_effty_ext_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

752: IF ( p_x_effty_ext_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
753: p_x_effty_ext_detail_rec.attribute_category := null;
754: END IF;
755:
756: IF ( p_x_effty_ext_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
757: p_x_effty_ext_detail_rec.attribute1 := null;
758: END IF;
759:
760: IF ( p_x_effty_ext_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

Line 760: IF ( p_x_effty_ext_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

756: IF ( p_x_effty_ext_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
757: p_x_effty_ext_detail_rec.attribute1 := null;
758: END IF;
759:
760: IF ( p_x_effty_ext_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
761: p_x_effty_ext_detail_rec.attribute2 := null;
762: END IF;
763:
764: IF ( p_x_effty_ext_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

Line 764: IF ( p_x_effty_ext_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

760: IF ( p_x_effty_ext_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
761: p_x_effty_ext_detail_rec.attribute2 := null;
762: END IF;
763:
764: IF ( p_x_effty_ext_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
765: p_x_effty_ext_detail_rec.attribute3 := null;
766: END IF;
767:
768: IF ( p_x_effty_ext_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

Line 768: IF ( p_x_effty_ext_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

764: IF ( p_x_effty_ext_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
765: p_x_effty_ext_detail_rec.attribute3 := null;
766: END IF;
767:
768: IF ( p_x_effty_ext_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
769: p_x_effty_ext_detail_rec.attribute4 := null;
770: END IF;
771:
772: IF ( p_x_effty_ext_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

Line 772: IF ( p_x_effty_ext_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

768: IF ( p_x_effty_ext_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
769: p_x_effty_ext_detail_rec.attribute4 := null;
770: END IF;
771:
772: IF ( p_x_effty_ext_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
773: p_x_effty_ext_detail_rec.attribute5 := null;
774: END IF;
775:
776: IF ( p_x_effty_ext_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

Line 776: IF ( p_x_effty_ext_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

772: IF ( p_x_effty_ext_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
773: p_x_effty_ext_detail_rec.attribute5 := null;
774: END IF;
775:
776: IF ( p_x_effty_ext_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
777: p_x_effty_ext_detail_rec.attribute6 := null;
778: END IF;
779:
780: IF ( p_x_effty_ext_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

Line 780: IF ( p_x_effty_ext_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

776: IF ( p_x_effty_ext_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
777: p_x_effty_ext_detail_rec.attribute6 := null;
778: END IF;
779:
780: IF ( p_x_effty_ext_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
781: p_x_effty_ext_detail_rec.attribute7 := null;
782: END IF;
783:
784: IF ( p_x_effty_ext_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

Line 784: IF ( p_x_effty_ext_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

780: IF ( p_x_effty_ext_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
781: p_x_effty_ext_detail_rec.attribute7 := null;
782: END IF;
783:
784: IF ( p_x_effty_ext_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
785: p_x_effty_ext_detail_rec.attribute8 := null;
786: END IF;
787:
788: IF ( p_x_effty_ext_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

Line 788: IF ( p_x_effty_ext_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

784: IF ( p_x_effty_ext_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
785: p_x_effty_ext_detail_rec.attribute8 := null;
786: END IF;
787:
788: IF ( p_x_effty_ext_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
789: p_x_effty_ext_detail_rec.attribute9 := null;
790: END IF;
791:
792: IF ( p_x_effty_ext_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

Line 792: IF ( p_x_effty_ext_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

788: IF ( p_x_effty_ext_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
789: p_x_effty_ext_detail_rec.attribute9 := null;
790: END IF;
791:
792: IF ( p_x_effty_ext_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
793: p_x_effty_ext_detail_rec.attribute10 := null;
794: END IF;
795:
796: IF ( p_x_effty_ext_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

Line 796: IF ( p_x_effty_ext_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

792: IF ( p_x_effty_ext_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
793: p_x_effty_ext_detail_rec.attribute10 := null;
794: END IF;
795:
796: IF ( p_x_effty_ext_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
797: p_x_effty_ext_detail_rec.attribute11 := null;
798: END IF;
799:
800: IF ( p_x_effty_ext_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

Line 800: IF ( p_x_effty_ext_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

796: IF ( p_x_effty_ext_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
797: p_x_effty_ext_detail_rec.attribute11 := null;
798: END IF;
799:
800: IF ( p_x_effty_ext_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
801: p_x_effty_ext_detail_rec.attribute12 := null;
802: END IF;
803:
804: IF ( p_x_effty_ext_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

Line 804: IF ( p_x_effty_ext_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

800: IF ( p_x_effty_ext_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
801: p_x_effty_ext_detail_rec.attribute12 := null;
802: END IF;
803:
804: IF ( p_x_effty_ext_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
805: p_x_effty_ext_detail_rec.attribute13 := null;
806: END IF;
807:
808: IF ( p_x_effty_ext_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

Line 808: IF ( p_x_effty_ext_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

804: IF ( p_x_effty_ext_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
805: p_x_effty_ext_detail_rec.attribute13 := null;
806: END IF;
807:
808: IF ( p_x_effty_ext_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
809: p_x_effty_ext_detail_rec.attribute14 := null;
810: END IF;
811:
812: IF ( p_x_effty_ext_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

Line 812: IF ( p_x_effty_ext_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

808: IF ( p_x_effty_ext_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
809: p_x_effty_ext_detail_rec.attribute14 := null;
810: END IF;
811:
812: IF ( p_x_effty_ext_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
813: p_x_effty_ext_detail_rec.attribute15 := null;
814: END IF;
815:
816: END default_ext_missing_attributes;

Line 894: RAISE FND_API.G_EXC_ERROR;

890: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_EFF_DTL_REC' );
891: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );
892: FND_MSG_PUB.add;
893: CLOSE get_old_rec;
894: RAISE FND_API.G_EXC_ERROR;
895: END IF;
896:
897: CLOSE get_old_rec;
898:

Line 904: IF ( p_x_effectivity_detail_rec.serial_number_from = FND_API.G_MISS_CHAR ) THEN

900: IF ( p_x_effectivity_detail_rec.exclude_flag IS NULL ) THEN
901: p_x_effectivity_detail_rec.exclude_flag := l_old_effectivity_detail_rec.exclude_flag;
902: END IF;
903:
904: IF ( p_x_effectivity_detail_rec.serial_number_from = FND_API.G_MISS_CHAR ) THEN
905: p_x_effectivity_detail_rec.serial_number_from := null;
906: ELSIF ( p_x_effectivity_detail_rec.serial_number_from IS NULL ) THEN
907: p_x_effectivity_detail_rec.serial_number_from := l_old_effectivity_detail_rec.serial_number_from;
908: END IF;

Line 910: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN

906: ELSIF ( p_x_effectivity_detail_rec.serial_number_from IS NULL ) THEN
907: p_x_effectivity_detail_rec.serial_number_from := l_old_effectivity_detail_rec.serial_number_from;
908: END IF;
909:
910: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN
911: p_x_effectivity_detail_rec.serial_number_to := null;
912: ELSIF ( p_x_effectivity_detail_rec.serial_number_to IS NULL ) THEN
913: p_x_effectivity_detail_rec.serial_number_to := l_old_effectivity_detail_rec.serial_number_to;
914: END IF;

Line 916: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN

912: ELSIF ( p_x_effectivity_detail_rec.serial_number_to IS NULL ) THEN
913: p_x_effectivity_detail_rec.serial_number_to := l_old_effectivity_detail_rec.serial_number_to;
914: END IF;
915:
916: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN
917: p_x_effectivity_detail_rec.manufacturer_id := null;
918: ELSIF ( p_x_effectivity_detail_rec.manufacturer_id IS NULL ) THEN
919: p_x_effectivity_detail_rec.manufacturer_id := l_old_effectivity_detail_rec.manufacturer_id;
920: END IF;

Line 922: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN

918: ELSIF ( p_x_effectivity_detail_rec.manufacturer_id IS NULL ) THEN
919: p_x_effectivity_detail_rec.manufacturer_id := l_old_effectivity_detail_rec.manufacturer_id;
920: END IF;
921:
922: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
923: p_x_effectivity_detail_rec.manufacturer := null;
924: ELSIF ( p_x_effectivity_detail_rec.manufacturer IS NULL ) THEN
925: p_x_effectivity_detail_rec.manufacturer := l_old_effectivity_detail_rec.manufacturer;
926: END IF;

Line 928: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN

924: ELSIF ( p_x_effectivity_detail_rec.manufacturer IS NULL ) THEN
925: p_x_effectivity_detail_rec.manufacturer := l_old_effectivity_detail_rec.manufacturer;
926: END IF;
927:
928: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN
929: p_x_effectivity_detail_rec.manufacture_date_from := null;
930: ELSIF ( p_x_effectivity_detail_rec.manufacture_date_from IS NULL ) THEN
931: p_x_effectivity_detail_rec.manufacture_date_from := l_old_effectivity_detail_rec.manufacture_date_from;
932: END IF;

Line 934: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN

930: ELSIF ( p_x_effectivity_detail_rec.manufacture_date_from IS NULL ) THEN
931: p_x_effectivity_detail_rec.manufacture_date_from := l_old_effectivity_detail_rec.manufacture_date_from;
932: END IF;
933:
934: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN
935: p_x_effectivity_detail_rec.manufacture_date_to := null;
936: ELSIF ( p_x_effectivity_detail_rec.manufacture_date_to IS NULL ) THEN
937: p_x_effectivity_detail_rec.manufacture_date_to := l_old_effectivity_detail_rec.manufacture_date_to;
938: END IF;

Line 940: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN

936: ELSIF ( p_x_effectivity_detail_rec.manufacture_date_to IS NULL ) THEN
937: p_x_effectivity_detail_rec.manufacture_date_to := l_old_effectivity_detail_rec.manufacture_date_to;
938: END IF;
939:
940: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN
941: p_x_effectivity_detail_rec.country_code := null;
942: ELSIF ( p_x_effectivity_detail_rec.country_code IS NULL ) THEN
943: p_x_effectivity_detail_rec.country_code := l_old_effectivity_detail_rec.country_code;
944: END IF;

Line 946: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN

942: ELSIF ( p_x_effectivity_detail_rec.country_code IS NULL ) THEN
943: p_x_effectivity_detail_rec.country_code := l_old_effectivity_detail_rec.country_code;
944: END IF;
945:
946: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
947: p_x_effectivity_detail_rec.country := null;
948: ELSIF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
949: p_x_effectivity_detail_rec.country := l_old_effectivity_detail_rec.country;
950: END IF;

Line 952: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

948: ELSIF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
949: p_x_effectivity_detail_rec.country := l_old_effectivity_detail_rec.country;
950: END IF;
951:
952: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
953: p_x_effectivity_detail_rec.attribute_category := null;
954: ELSIF ( p_x_effectivity_detail_rec.attribute_category IS NULL ) THEN
955: p_x_effectivity_detail_rec.attribute_category := l_old_effectivity_detail_rec.attribute_category;
956: END IF;

Line 958: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

954: ELSIF ( p_x_effectivity_detail_rec.attribute_category IS NULL ) THEN
955: p_x_effectivity_detail_rec.attribute_category := l_old_effectivity_detail_rec.attribute_category;
956: END IF;
957:
958: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
959: p_x_effectivity_detail_rec.attribute1 := null;
960: ELSIF ( p_x_effectivity_detail_rec.attribute1 IS NULL ) THEN
961: p_x_effectivity_detail_rec.attribute1 := l_old_effectivity_detail_rec.attribute1;
962: END IF;

Line 964: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

960: ELSIF ( p_x_effectivity_detail_rec.attribute1 IS NULL ) THEN
961: p_x_effectivity_detail_rec.attribute1 := l_old_effectivity_detail_rec.attribute1;
962: END IF;
963:
964: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
965: p_x_effectivity_detail_rec.attribute2 := null;
966: ELSIF ( p_x_effectivity_detail_rec.attribute2 IS NULL ) THEN
967: p_x_effectivity_detail_rec.attribute2 := l_old_effectivity_detail_rec.attribute2;
968: END IF;

Line 970: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

966: ELSIF ( p_x_effectivity_detail_rec.attribute2 IS NULL ) THEN
967: p_x_effectivity_detail_rec.attribute2 := l_old_effectivity_detail_rec.attribute2;
968: END IF;
969:
970: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
971: p_x_effectivity_detail_rec.attribute3 := null;
972: ELSIF ( p_x_effectivity_detail_rec.attribute3 IS NULL ) THEN
973: p_x_effectivity_detail_rec.attribute3 := l_old_effectivity_detail_rec.attribute3;
974: END IF;

Line 976: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

972: ELSIF ( p_x_effectivity_detail_rec.attribute3 IS NULL ) THEN
973: p_x_effectivity_detail_rec.attribute3 := l_old_effectivity_detail_rec.attribute3;
974: END IF;
975:
976: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
977: p_x_effectivity_detail_rec.attribute4 := null;
978: ELSIF ( p_x_effectivity_detail_rec.attribute4 IS NULL ) THEN
979: p_x_effectivity_detail_rec.attribute4 := l_old_effectivity_detail_rec.attribute4;
980: END IF;

Line 982: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

978: ELSIF ( p_x_effectivity_detail_rec.attribute4 IS NULL ) THEN
979: p_x_effectivity_detail_rec.attribute4 := l_old_effectivity_detail_rec.attribute4;
980: END IF;
981:
982: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
983: p_x_effectivity_detail_rec.attribute5 := null;
984: ELSIF ( p_x_effectivity_detail_rec.attribute5 IS NULL ) THEN
985: p_x_effectivity_detail_rec.attribute5 := l_old_effectivity_detail_rec.attribute5;
986: END IF;

Line 988: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

984: ELSIF ( p_x_effectivity_detail_rec.attribute5 IS NULL ) THEN
985: p_x_effectivity_detail_rec.attribute5 := l_old_effectivity_detail_rec.attribute5;
986: END IF;
987:
988: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
989: p_x_effectivity_detail_rec.attribute6 := null;
990: ELSIF ( p_x_effectivity_detail_rec.attribute6 IS NULL ) THEN
991: p_x_effectivity_detail_rec.attribute6 := l_old_effectivity_detail_rec.attribute6;
992: END IF;

Line 994: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

990: ELSIF ( p_x_effectivity_detail_rec.attribute6 IS NULL ) THEN
991: p_x_effectivity_detail_rec.attribute6 := l_old_effectivity_detail_rec.attribute6;
992: END IF;
993:
994: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
995: p_x_effectivity_detail_rec.attribute7 := null;
996: ELSIF ( p_x_effectivity_detail_rec.attribute7 IS NULL ) THEN
997: p_x_effectivity_detail_rec.attribute7 := l_old_effectivity_detail_rec.attribute7;
998: END IF;

Line 1000: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

996: ELSIF ( p_x_effectivity_detail_rec.attribute7 IS NULL ) THEN
997: p_x_effectivity_detail_rec.attribute7 := l_old_effectivity_detail_rec.attribute7;
998: END IF;
999:
1000: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
1001: p_x_effectivity_detail_rec.attribute8 := null;
1002: ELSIF ( p_x_effectivity_detail_rec.attribute8 IS NULL ) THEN
1003: p_x_effectivity_detail_rec.attribute8 := l_old_effectivity_detail_rec.attribute8;
1004: END IF;

Line 1006: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

1002: ELSIF ( p_x_effectivity_detail_rec.attribute8 IS NULL ) THEN
1003: p_x_effectivity_detail_rec.attribute8 := l_old_effectivity_detail_rec.attribute8;
1004: END IF;
1005:
1006: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
1007: p_x_effectivity_detail_rec.attribute9 := null;
1008: ELSIF ( p_x_effectivity_detail_rec.attribute9 IS NULL ) THEN
1009: p_x_effectivity_detail_rec.attribute9 := l_old_effectivity_detail_rec.attribute9;
1010: END IF;

Line 1012: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

1008: ELSIF ( p_x_effectivity_detail_rec.attribute9 IS NULL ) THEN
1009: p_x_effectivity_detail_rec.attribute9 := l_old_effectivity_detail_rec.attribute9;
1010: END IF;
1011:
1012: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
1013: p_x_effectivity_detail_rec.attribute10 := null;
1014: ELSIF ( p_x_effectivity_detail_rec.attribute10 IS NULL ) THEN
1015: p_x_effectivity_detail_rec.attribute10 := l_old_effectivity_detail_rec.attribute10;
1016: END IF;

Line 1018: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

1014: ELSIF ( p_x_effectivity_detail_rec.attribute10 IS NULL ) THEN
1015: p_x_effectivity_detail_rec.attribute10 := l_old_effectivity_detail_rec.attribute10;
1016: END IF;
1017:
1018: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
1019: p_x_effectivity_detail_rec.attribute11 := null;
1020: ELSIF ( p_x_effectivity_detail_rec.attribute11 IS NULL ) THEN
1021: p_x_effectivity_detail_rec.attribute11 := l_old_effectivity_detail_rec.attribute11;
1022: END IF;

Line 1024: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

1020: ELSIF ( p_x_effectivity_detail_rec.attribute11 IS NULL ) THEN
1021: p_x_effectivity_detail_rec.attribute11 := l_old_effectivity_detail_rec.attribute11;
1022: END IF;
1023:
1024: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
1025: p_x_effectivity_detail_rec.attribute12 := null;
1026: ELSIF ( p_x_effectivity_detail_rec.attribute12 IS NULL ) THEN
1027: p_x_effectivity_detail_rec.attribute12 := l_old_effectivity_detail_rec.attribute12;
1028: END IF;

Line 1030: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

1026: ELSIF ( p_x_effectivity_detail_rec.attribute12 IS NULL ) THEN
1027: p_x_effectivity_detail_rec.attribute12 := l_old_effectivity_detail_rec.attribute12;
1028: END IF;
1029:
1030: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
1031: p_x_effectivity_detail_rec.attribute13 := null;
1032: ELSIF ( p_x_effectivity_detail_rec.attribute13 IS NULL ) THEN
1033: p_x_effectivity_detail_rec.attribute13 := l_old_effectivity_detail_rec.attribute13;
1034: END IF;

Line 1036: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

1032: ELSIF ( p_x_effectivity_detail_rec.attribute13 IS NULL ) THEN
1033: p_x_effectivity_detail_rec.attribute13 := l_old_effectivity_detail_rec.attribute13;
1034: END IF;
1035:
1036: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
1037: p_x_effectivity_detail_rec.attribute14 := null;
1038: ELSIF ( p_x_effectivity_detail_rec.attribute14 IS NULL ) THEN
1039: p_x_effectivity_detail_rec.attribute14 := l_old_effectivity_detail_rec.attribute14;
1040: END IF;

Line 1042: IF ( p_x_effectivity_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

1038: ELSIF ( p_x_effectivity_detail_rec.attribute14 IS NULL ) THEN
1039: p_x_effectivity_detail_rec.attribute14 := l_old_effectivity_detail_rec.attribute14;
1040: END IF;
1041:
1042: IF ( p_x_effectivity_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
1043: p_x_effectivity_detail_rec.attribute15 := null;
1044: ELSIF ( p_x_effectivity_detail_rec.attribute15 IS NULL ) THEN
1045: p_x_effectivity_detail_rec.attribute15 := l_old_effectivity_detail_rec.attribute15;
1046: END IF;

Line 1127: RAISE FND_API.G_EXC_ERROR;

1123: END IF;
1124: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );
1125: FND_MSG_PUB.add;
1126: CLOSE get_old_rec;
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129:
1130: CLOSE get_old_rec;
1131:

Line 1137: IF ( p_x_effty_ext_detail_rec.OWNER_ID = FND_API.G_MISS_NUM ) THEN

1133: IF ( p_x_effty_ext_detail_rec.exclude_flag IS NULL ) THEN
1134: p_x_effty_ext_detail_rec.exclude_flag := l_old_effty_ext_detail_rec.exclude_flag;
1135: END IF;
1136:
1137: IF ( p_x_effty_ext_detail_rec.OWNER_ID = FND_API.G_MISS_NUM ) THEN
1138: p_x_effty_ext_detail_rec.OWNER_ID := null;
1139: ELSIF ( p_x_effty_ext_detail_rec.OWNER_ID IS NULL ) THEN
1140: p_x_effty_ext_detail_rec.OWNER_ID := l_old_effty_ext_detail_rec.OWNER_ID;
1141: END IF;

Line 1143: IF ( p_x_effty_ext_detail_rec.OWNER = FND_API.G_MISS_CHAR ) THEN

1139: ELSIF ( p_x_effty_ext_detail_rec.OWNER_ID IS NULL ) THEN
1140: p_x_effty_ext_detail_rec.OWNER_ID := l_old_effty_ext_detail_rec.OWNER_ID;
1141: END IF;
1142:
1143: IF ( p_x_effty_ext_detail_rec.OWNER = FND_API.G_MISS_CHAR ) THEN
1144: p_x_effty_ext_detail_rec.OWNER := null;
1145: ELSIF ( p_x_effty_ext_detail_rec.OWNER IS NULL ) THEN
1146: p_x_effty_ext_detail_rec.OWNER := l_old_effty_ext_detail_rec.OWNER;
1147: END IF;

Line 1149: IF ( p_x_effty_ext_detail_rec.LOCATION = FND_API.G_MISS_CHAR ) THEN

1145: ELSIF ( p_x_effty_ext_detail_rec.OWNER IS NULL ) THEN
1146: p_x_effty_ext_detail_rec.OWNER := l_old_effty_ext_detail_rec.OWNER;
1147: END IF;
1148:
1149: IF ( p_x_effty_ext_detail_rec.LOCATION = FND_API.G_MISS_CHAR ) THEN
1150: p_x_effty_ext_detail_rec.LOCATION := null;
1151: ELSIF ( p_x_effty_ext_detail_rec.LOCATION IS NULL ) THEN
1152: p_x_effty_ext_detail_rec.LOCATION := l_old_effty_ext_detail_rec.LOCATION;
1153: END IF;

Line 1155: IF ( p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE = FND_API.G_MISS_CHAR ) THEN

1151: ELSIF ( p_x_effty_ext_detail_rec.LOCATION IS NULL ) THEN
1152: p_x_effty_ext_detail_rec.LOCATION := l_old_effty_ext_detail_rec.LOCATION;
1153: END IF;
1154:
1155: IF ( p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE = FND_API.G_MISS_CHAR ) THEN
1156: p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE := null;
1157: ELSIF ( p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE IS NULL ) THEN
1158: p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE := l_old_effty_ext_detail_rec.LOCATION_TYPE_CODE;
1159: END IF;

Line 1161: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ) THEN

1157: ELSIF ( p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE IS NULL ) THEN
1158: p_x_effty_ext_detail_rec.LOCATION_TYPE_CODE := l_old_effty_ext_detail_rec.LOCATION_TYPE_CODE;
1159: END IF;
1160:
1161: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ) THEN
1162: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE := null;
1163: ELSIF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL ) THEN
1164: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE := l_old_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE;
1165: END IF;

Line 1167: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE = FND_API.G_MISS_CHAR ) THEN

1163: ELSIF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL ) THEN
1164: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE := l_old_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE;
1165: END IF;
1166:
1167: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE = FND_API.G_MISS_CHAR ) THEN
1168: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE := null;
1169: ELSIF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE IS NULL ) THEN
1170: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE := l_old_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE;
1171: END IF;

Line 1173: IF ( p_x_effty_ext_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

1169: ELSIF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE IS NULL ) THEN
1170: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE := l_old_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_VALUE;
1171: END IF;
1172:
1173: IF ( p_x_effty_ext_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
1174: p_x_effty_ext_detail_rec.attribute_category := null;
1175: ELSIF ( p_x_effty_ext_detail_rec.attribute_category IS NULL ) THEN
1176: p_x_effty_ext_detail_rec.attribute_category := l_old_effty_ext_detail_rec.attribute_category;
1177: END IF;

Line 1179: IF ( p_x_effty_ext_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

1175: ELSIF ( p_x_effty_ext_detail_rec.attribute_category IS NULL ) THEN
1176: p_x_effty_ext_detail_rec.attribute_category := l_old_effty_ext_detail_rec.attribute_category;
1177: END IF;
1178:
1179: IF ( p_x_effty_ext_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
1180: p_x_effty_ext_detail_rec.attribute1 := null;
1181: ELSIF ( p_x_effty_ext_detail_rec.attribute1 IS NULL ) THEN
1182: p_x_effty_ext_detail_rec.attribute1 := l_old_effty_ext_detail_rec.attribute1;
1183: END IF;

Line 1185: IF ( p_x_effty_ext_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

1181: ELSIF ( p_x_effty_ext_detail_rec.attribute1 IS NULL ) THEN
1182: p_x_effty_ext_detail_rec.attribute1 := l_old_effty_ext_detail_rec.attribute1;
1183: END IF;
1184:
1185: IF ( p_x_effty_ext_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
1186: p_x_effty_ext_detail_rec.attribute2 := null;
1187: ELSIF ( p_x_effty_ext_detail_rec.attribute2 IS NULL ) THEN
1188: p_x_effty_ext_detail_rec.attribute2 := l_old_effty_ext_detail_rec.attribute2;
1189: END IF;

Line 1191: IF ( p_x_effty_ext_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

1187: ELSIF ( p_x_effty_ext_detail_rec.attribute2 IS NULL ) THEN
1188: p_x_effty_ext_detail_rec.attribute2 := l_old_effty_ext_detail_rec.attribute2;
1189: END IF;
1190:
1191: IF ( p_x_effty_ext_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
1192: p_x_effty_ext_detail_rec.attribute3 := null;
1193: ELSIF ( p_x_effty_ext_detail_rec.attribute3 IS NULL ) THEN
1194: p_x_effty_ext_detail_rec.attribute3 := l_old_effty_ext_detail_rec.attribute3;
1195: END IF;

Line 1197: IF ( p_x_effty_ext_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

1193: ELSIF ( p_x_effty_ext_detail_rec.attribute3 IS NULL ) THEN
1194: p_x_effty_ext_detail_rec.attribute3 := l_old_effty_ext_detail_rec.attribute3;
1195: END IF;
1196:
1197: IF ( p_x_effty_ext_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
1198: p_x_effty_ext_detail_rec.attribute4 := null;
1199: ELSIF ( p_x_effty_ext_detail_rec.attribute4 IS NULL ) THEN
1200: p_x_effty_ext_detail_rec.attribute4 := l_old_effty_ext_detail_rec.attribute4;
1201: END IF;

Line 1203: IF ( p_x_effty_ext_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

1199: ELSIF ( p_x_effty_ext_detail_rec.attribute4 IS NULL ) THEN
1200: p_x_effty_ext_detail_rec.attribute4 := l_old_effty_ext_detail_rec.attribute4;
1201: END IF;
1202:
1203: IF ( p_x_effty_ext_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
1204: p_x_effty_ext_detail_rec.attribute5 := null;
1205: ELSIF ( p_x_effty_ext_detail_rec.attribute5 IS NULL ) THEN
1206: p_x_effty_ext_detail_rec.attribute5 := l_old_effty_ext_detail_rec.attribute5;
1207: END IF;

Line 1209: IF ( p_x_effty_ext_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

1205: ELSIF ( p_x_effty_ext_detail_rec.attribute5 IS NULL ) THEN
1206: p_x_effty_ext_detail_rec.attribute5 := l_old_effty_ext_detail_rec.attribute5;
1207: END IF;
1208:
1209: IF ( p_x_effty_ext_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
1210: p_x_effty_ext_detail_rec.attribute6 := null;
1211: ELSIF ( p_x_effty_ext_detail_rec.attribute6 IS NULL ) THEN
1212: p_x_effty_ext_detail_rec.attribute6 := l_old_effty_ext_detail_rec.attribute6;
1213: END IF;

Line 1215: IF ( p_x_effty_ext_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

1211: ELSIF ( p_x_effty_ext_detail_rec.attribute6 IS NULL ) THEN
1212: p_x_effty_ext_detail_rec.attribute6 := l_old_effty_ext_detail_rec.attribute6;
1213: END IF;
1214:
1215: IF ( p_x_effty_ext_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
1216: p_x_effty_ext_detail_rec.attribute7 := null;
1217: ELSIF ( p_x_effty_ext_detail_rec.attribute7 IS NULL ) THEN
1218: p_x_effty_ext_detail_rec.attribute7 := l_old_effty_ext_detail_rec.attribute7;
1219: END IF;

Line 1221: IF ( p_x_effty_ext_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

1217: ELSIF ( p_x_effty_ext_detail_rec.attribute7 IS NULL ) THEN
1218: p_x_effty_ext_detail_rec.attribute7 := l_old_effty_ext_detail_rec.attribute7;
1219: END IF;
1220:
1221: IF ( p_x_effty_ext_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
1222: p_x_effty_ext_detail_rec.attribute8 := null;
1223: ELSIF ( p_x_effty_ext_detail_rec.attribute8 IS NULL ) THEN
1224: p_x_effty_ext_detail_rec.attribute8 := l_old_effty_ext_detail_rec.attribute8;
1225: END IF;

Line 1227: IF ( p_x_effty_ext_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

1223: ELSIF ( p_x_effty_ext_detail_rec.attribute8 IS NULL ) THEN
1224: p_x_effty_ext_detail_rec.attribute8 := l_old_effty_ext_detail_rec.attribute8;
1225: END IF;
1226:
1227: IF ( p_x_effty_ext_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
1228: p_x_effty_ext_detail_rec.attribute9 := null;
1229: ELSIF ( p_x_effty_ext_detail_rec.attribute9 IS NULL ) THEN
1230: p_x_effty_ext_detail_rec.attribute9 := l_old_effty_ext_detail_rec.attribute9;
1231: END IF;

Line 1233: IF ( p_x_effty_ext_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

1229: ELSIF ( p_x_effty_ext_detail_rec.attribute9 IS NULL ) THEN
1230: p_x_effty_ext_detail_rec.attribute9 := l_old_effty_ext_detail_rec.attribute9;
1231: END IF;
1232:
1233: IF ( p_x_effty_ext_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
1234: p_x_effty_ext_detail_rec.attribute10 := null;
1235: ELSIF ( p_x_effty_ext_detail_rec.attribute10 IS NULL ) THEN
1236: p_x_effty_ext_detail_rec.attribute10 := l_old_effty_ext_detail_rec.attribute10;
1237: END IF;

Line 1239: IF ( p_x_effty_ext_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

1235: ELSIF ( p_x_effty_ext_detail_rec.attribute10 IS NULL ) THEN
1236: p_x_effty_ext_detail_rec.attribute10 := l_old_effty_ext_detail_rec.attribute10;
1237: END IF;
1238:
1239: IF ( p_x_effty_ext_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
1240: p_x_effty_ext_detail_rec.attribute11 := null;
1241: ELSIF ( p_x_effty_ext_detail_rec.attribute11 IS NULL ) THEN
1242: p_x_effty_ext_detail_rec.attribute11 := l_old_effty_ext_detail_rec.attribute11;
1243: END IF;

Line 1245: IF ( p_x_effty_ext_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

1241: ELSIF ( p_x_effty_ext_detail_rec.attribute11 IS NULL ) THEN
1242: p_x_effty_ext_detail_rec.attribute11 := l_old_effty_ext_detail_rec.attribute11;
1243: END IF;
1244:
1245: IF ( p_x_effty_ext_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
1246: p_x_effty_ext_detail_rec.attribute12 := null;
1247: ELSIF ( p_x_effty_ext_detail_rec.attribute12 IS NULL ) THEN
1248: p_x_effty_ext_detail_rec.attribute12 := l_old_effty_ext_detail_rec.attribute12;
1249: END IF;

Line 1251: IF ( p_x_effty_ext_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

1247: ELSIF ( p_x_effty_ext_detail_rec.attribute12 IS NULL ) THEN
1248: p_x_effty_ext_detail_rec.attribute12 := l_old_effty_ext_detail_rec.attribute12;
1249: END IF;
1250:
1251: IF ( p_x_effty_ext_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
1252: p_x_effty_ext_detail_rec.attribute13 := null;
1253: ELSIF ( p_x_effty_ext_detail_rec.attribute13 IS NULL ) THEN
1254: p_x_effty_ext_detail_rec.attribute13 := l_old_effty_ext_detail_rec.attribute13;
1255: END IF;

Line 1257: IF ( p_x_effty_ext_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

1253: ELSIF ( p_x_effty_ext_detail_rec.attribute13 IS NULL ) THEN
1254: p_x_effty_ext_detail_rec.attribute13 := l_old_effty_ext_detail_rec.attribute13;
1255: END IF;
1256:
1257: IF ( p_x_effty_ext_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
1258: p_x_effty_ext_detail_rec.attribute14 := null;
1259: ELSIF ( p_x_effty_ext_detail_rec.attribute14 IS NULL ) THEN
1260: p_x_effty_ext_detail_rec.attribute14 := l_old_effty_ext_detail_rec.attribute14;
1261: END IF;

Line 1263: IF ( p_x_effty_ext_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

1259: ELSIF ( p_x_effty_ext_detail_rec.attribute14 IS NULL ) THEN
1260: p_x_effty_ext_detail_rec.attribute14 := l_old_effty_ext_detail_rec.attribute14;
1261: END IF;
1262:
1263: IF ( p_x_effty_ext_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
1264: p_x_effty_ext_detail_rec.attribute15 := null;
1265: ELSIF ( p_x_effty_ext_detail_rec.attribute15 IS NULL ) THEN
1266: p_x_effty_ext_detail_rec.attribute15 := l_old_effty_ext_detail_rec.attribute15;
1267: END IF;

Line 1280: x_return_status := FND_API.G_RET_STS_SUCCESS;

1276: )
1277: IS
1278:
1279: BEGIN
1280: x_return_status := FND_API.G_RET_STS_SUCCESS;
1281:
1282: IF ( p_effectivity_detail_rec.dml_operation = 'C' ) THEN
1283: -- Check if the Exclude Flag does not contain a null value.
1284: IF ( p_effectivity_detail_rec.exclude_flag IS NULL OR

Line 1285: p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN

1281:
1282: IF ( p_effectivity_detail_rec.dml_operation = 'C' ) THEN
1283: -- Check if the Exclude Flag does not contain a null value.
1284: IF ( p_effectivity_detail_rec.exclude_flag IS NULL OR
1285: p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1286: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1287: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1288: FND_MSG_PUB.add;
1289: ELSE

Line 1304: IF ( p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN

1300: END IF;
1301:
1302: IF ( p_effectivity_detail_rec.dml_operation = 'U' ) THEN
1303: -- Check if the Exclude Flag does not contain a null value.
1304: IF ( p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1305: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1306: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1307: FND_MSG_PUB.add;
1308: ELSIF ( p_effectivity_detail_rec.exclude_flag IS NOT NULL ) THEN

Line 1322: p_effectivity_detail_rec.mr_effectivity_detail_id = FND_API.G_MISS_NUM ) THEN

1318: END IF;
1319:
1320: -- Check if the mandatory Effectivity Detail ID column contains a null value.
1321: IF ( p_effectivity_detail_rec.mr_effectivity_detail_id IS NULL OR
1322: p_effectivity_detail_rec.mr_effectivity_detail_id = FND_API.G_MISS_NUM ) THEN
1323: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_EFF_DTL_ID_NULL' );
1324: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1325: FND_MSG_PUB.add;
1326: END IF;

Line 1330: p_effectivity_detail_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

1326: END IF;
1327:
1328: -- Check if the mandatory Object Version Number column contains a null value.
1329: IF ( p_effectivity_detail_rec.object_version_number IS NULL OR
1330: p_effectivity_detail_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1331: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MED_OBJ_VERSION_NULL' );
1332: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1333: FND_MSG_PUB.add;
1334: END IF;

Line 1347: x_return_status := FND_API.G_RET_STS_SUCCESS;

1343: )
1344: IS
1345:
1346: BEGIN
1347: x_return_status := FND_API.G_RET_STS_SUCCESS;
1348:
1349: IF ( p_effty_ext_detail_rec.dml_operation = 'C' ) THEN
1350: -- Check if the Exclude Flag does not contain a null value.
1351: IF ( p_effty_ext_detail_rec.exclude_flag IS NULL OR

Line 1352: p_effty_ext_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN

1348:
1349: IF ( p_effty_ext_detail_rec.dml_operation = 'C' ) THEN
1350: -- Check if the Exclude Flag does not contain a null value.
1351: IF ( p_effty_ext_detail_rec.exclude_flag IS NULL OR
1352: p_effty_ext_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1353: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1354: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1355: FND_MSG_PUB.add;
1356: ELSE

Line 1371: IF ( p_effty_ext_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN

1367: END IF;
1368:
1369: IF ( p_effty_ext_detail_rec.dml_operation = 'U' ) THEN
1370: -- Check if the Exclude Flag does not contain a null value.
1371: IF ( p_effty_ext_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1372: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1373: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1374: FND_MSG_PUB.add;
1375: ELSIF ( p_effty_ext_detail_rec.exclude_flag IS NOT NULL ) THEN

Line 1389: p_effty_ext_detail_rec.MR_EFFECTIVITY_EXT_DTL_ID = FND_API.G_MISS_NUM ) THEN

1385: END IF;
1386:
1387: -- Check if the mandatory Effectivity Detail ID column contains a null value.
1388: IF ( p_effty_ext_detail_rec.MR_EFFECTIVITY_EXT_DTL_ID IS NULL OR
1389: p_effty_ext_detail_rec.MR_EFFECTIVITY_EXT_DTL_ID = FND_API.G_MISS_NUM ) THEN
1390: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_EFF_EXT_DTL_ID_NULL' );
1391: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1392: FND_MSG_PUB.add;
1393: END IF;

Line 1397: p_effty_ext_detail_rec.object_version_number = FND_API.G_MISS_NUM ) THEN

1393: END IF;
1394:
1395: -- Check if the mandatory Object Version Number column contains a null value.
1396: IF ( p_effty_ext_detail_rec.object_version_number IS NULL OR
1397: p_effty_ext_detail_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1398: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MED_EXT_OBJ_VER_NULL' );
1399: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1400: FND_MSG_PUB.add;
1401: END IF;

Line 1417: x_return_status := FND_API.G_RET_STS_SUCCESS;

1413: l_return_status VARCHAR2(1);
1414: l_msg_data VARCHAR2(2000);
1415:
1416: BEGIN
1417: x_return_status := FND_API.G_RET_STS_SUCCESS;
1418:
1419: -- Check if Serial Number Range is valid
1420: IF ( p_effectivity_detail_rec.serial_number_from IS NOT NULL AND
1421: p_effectivity_detail_rec.serial_number_to IS NOT NULL ) THEN

Line 1431: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN

1427: p_serial_number_from => p_effectivity_detail_rec.serial_number_from,
1428: p_serial_number_to => p_effectivity_detail_rec.serial_number_to
1429: );
1430:
1431: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1432: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1433: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.serial_number_from );
1434: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.serial_number_to );
1435: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );

Line 1480: x_return_status := FND_API.G_RET_STS_SUCCESS;

1476: l_return_status VARCHAR2(1);
1477: l_msg_data VARCHAR2(2000);
1478:
1479: BEGIN
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: IF ( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
1483: IF ( (p_effty_ext_detail_rec.owner IS NULL OR p_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR) AND
1484: (p_effty_ext_detail_rec.owner_id IS NULL OR p_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM )) THEN

Line 1483: IF ( (p_effty_ext_detail_rec.owner IS NULL OR p_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR) AND

1479: BEGIN
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: IF ( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
1483: IF ( (p_effty_ext_detail_rec.owner IS NULL OR p_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR) AND
1484: (p_effty_ext_detail_rec.owner_id IS NULL OR p_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM )) THEN
1485: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_NLL' );
1486: FND_MSG_PUB.add;
1487: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND

Line 1484: (p_effty_ext_detail_rec.owner_id IS NULL OR p_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM )) THEN

1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: IF ( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
1483: IF ( (p_effty_ext_detail_rec.owner IS NULL OR p_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR) AND
1484: (p_effty_ext_detail_rec.owner_id IS NULL OR p_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM )) THEN
1485: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_NLL' );
1486: FND_MSG_PUB.add;
1487: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1488: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN

Line 1487: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND

1483: IF ( (p_effty_ext_detail_rec.owner IS NULL OR p_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR) AND
1484: (p_effty_ext_detail_rec.owner_id IS NULL OR p_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM )) THEN
1485: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_NLL' );
1486: FND_MSG_PUB.add;
1487: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1488: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1489: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1490: FND_MSG_PUB.add;
1491: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND

Line 1488: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN

1484: (p_effty_ext_detail_rec.owner_id IS NULL OR p_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM )) THEN
1485: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_NLL' );
1486: FND_MSG_PUB.add;
1487: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1488: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1489: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1490: FND_MSG_PUB.add;
1491: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1492: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN

Line 1491: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND

1487: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1488: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1489: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1490: FND_MSG_PUB.add;
1491: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1492: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN
1493: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1494: FND_MSG_PUB.add;
1495: END IF;

Line 1492: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN

1488: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1489: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1490: FND_MSG_PUB.add;
1491: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1492: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN
1493: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1494: FND_MSG_PUB.add;
1495: END IF;
1496: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN

Line 1497: IF((p_effty_ext_detail_rec.location IS NULL OR p_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR) AND

1493: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1494: FND_MSG_PUB.add;
1495: END IF;
1496: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
1497: IF((p_effty_ext_detail_rec.location IS NULL OR p_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR) AND
1498: (p_effty_ext_detail_rec.location_type_code IS NULL OR p_effty_ext_detail_rec.location_type_code = FND_API.G_MISS_CHAR )) THEN
1499: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_NLL' );
1500: FND_MSG_PUB.add;
1501: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND

Line 1498: (p_effty_ext_detail_rec.location_type_code IS NULL OR p_effty_ext_detail_rec.location_type_code = FND_API.G_MISS_CHAR )) THEN

1494: FND_MSG_PUB.add;
1495: END IF;
1496: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
1497: IF((p_effty_ext_detail_rec.location IS NULL OR p_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR) AND
1498: (p_effty_ext_detail_rec.location_type_code IS NULL OR p_effty_ext_detail_rec.location_type_code = FND_API.G_MISS_CHAR )) THEN
1499: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_NLL' );
1500: FND_MSG_PUB.add;
1501: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1502: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN

Line 1501: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND

1497: IF((p_effty_ext_detail_rec.location IS NULL OR p_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR) AND
1498: (p_effty_ext_detail_rec.location_type_code IS NULL OR p_effty_ext_detail_rec.location_type_code = FND_API.G_MISS_CHAR )) THEN
1499: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_NLL' );
1500: FND_MSG_PUB.add;
1501: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1502: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1503: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1504: FND_MSG_PUB.add;
1505: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND

Line 1502: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN

1498: (p_effty_ext_detail_rec.location_type_code IS NULL OR p_effty_ext_detail_rec.location_type_code = FND_API.G_MISS_CHAR )) THEN
1499: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_NLL' );
1500: FND_MSG_PUB.add;
1501: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1502: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1503: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1504: FND_MSG_PUB.add;
1505: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1506: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN

Line 1505: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND

1501: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1502: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1503: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1504: FND_MSG_PUB.add;
1505: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1506: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN
1507: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1508: FND_MSG_PUB.add;
1509: END IF;

Line 1506: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN

1502: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1503: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1504: FND_MSG_PUB.add;
1505: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1506: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN
1507: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1508: FND_MSG_PUB.add;
1509: END IF;
1510: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN

Line 1511: IF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR) AND

1507: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1508: FND_MSG_PUB.add;
1509: END IF;
1510: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
1511: IF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR) AND
1512: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ))THEN
1513: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_NLL' );
1514: FND_MSG_PUB.add;
1515: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND

Line 1512: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ))THEN

1508: FND_MSG_PUB.add;
1509: END IF;
1510: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
1511: IF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR) AND
1512: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ))THEN
1513: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_NLL' );
1514: FND_MSG_PUB.add;
1515: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1516: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN

Line 1515: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND

1511: IF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR) AND
1512: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ))THEN
1513: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_NLL' );
1514: FND_MSG_PUB.add;
1515: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1516: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1517: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );
1518: FND_MSG_PUB.add;
1519: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND

Line 1516: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN

1512: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ))THEN
1513: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_NLL' );
1514: FND_MSG_PUB.add;
1515: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1516: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1517: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );
1518: FND_MSG_PUB.add;
1519: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1520: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN

Line 1519: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND

1515: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1516: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1517: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );
1518: FND_MSG_PUB.add;
1519: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1520: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1521: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );
1522: FND_MSG_PUB.add;
1523: END IF;

Line 1520: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN

1516: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1517: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );
1518: FND_MSG_PUB.add;
1519: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1520: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1521: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );
1522: FND_MSG_PUB.add;
1523: END IF;
1524: END IF;

Line 1604: x_return_status := FND_API.G_RET_STS_SUCCESS;

1600:
1601: l_effty_ext_detail_rec effty_ext_detail_rec_type;
1602:
1603: BEGIN
1604: x_return_status := FND_API.G_RET_STS_SUCCESS;
1605:
1606: -- Check whether any duplicate effectivity_detail records exist
1607: OPEN get_dup_rec( p_mr_effectivity_id );
1608:

Line 1627: x_return_status := FND_API.G_RET_STS_ERROR;

1623: END LOOP;
1624:
1625: IF ( get_dup_rec%ROWCOUNT > 0 ) THEN
1626: CLOSE get_dup_rec;
1627: x_return_status := FND_API.G_RET_STS_ERROR;
1628: RETURN;
1629: END IF;
1630:
1631: CLOSE get_dup_rec;

Line 1651: x_return_status := FND_API.G_RET_STS_ERROR;

1647: END LOOP;
1648:
1649: IF ( get_dup_owner_rec%ROWCOUNT > 0 ) THEN
1650: CLOSE get_dup_owner_rec;
1651: x_return_status := FND_API.G_RET_STS_ERROR;
1652: RETURN;
1653: END IF;
1654:
1655: CLOSE get_dup_owner_rec;

Line 1675: x_return_status := FND_API.G_RET_STS_ERROR;

1671: END LOOP;
1672:
1673: IF ( get_dup_location_rec%ROWCOUNT > 0 ) THEN
1674: CLOSE get_dup_location_rec;
1675: x_return_status := FND_API.G_RET_STS_ERROR;
1676: RETURN;
1677: END IF;
1678:
1679: CLOSE get_dup_location_rec;

Line 1700: x_return_status := FND_API.G_RET_STS_ERROR;

1696: END LOOP;
1697:
1698: IF ( get_dup_csi_attrib_rec%ROWCOUNT > 0 ) THEN
1699: CLOSE get_dup_csi_attrib_rec;
1700: x_return_status := FND_API.G_RET_STS_ERROR;
1701: RETURN;
1702: END IF;
1703:
1704: CLOSE get_dup_csi_attrib_rec;

Line 1713: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1709:
1710: PROCEDURE process_effectivity_detail
1711: (
1712: p_api_version IN NUMBER := '1.0',
1713: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1716: p_default IN VARCHAR2 := FND_API.G_FALSE,
1717: p_module_type IN VARCHAR2 := NULL,

Line 1714: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1710: PROCEDURE process_effectivity_detail
1711: (
1712: p_api_version IN NUMBER := '1.0',
1713: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1716: p_default IN VARCHAR2 := FND_API.G_FALSE,
1717: p_module_type IN VARCHAR2 := NULL,
1718: x_return_status OUT NOCOPY VARCHAR2,

Line 1715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1711: (
1712: p_api_version IN NUMBER := '1.0',
1713: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1716: p_default IN VARCHAR2 := FND_API.G_FALSE,
1717: p_module_type IN VARCHAR2 := NULL,
1718: x_return_status OUT NOCOPY VARCHAR2,
1719: x_msg_count OUT NOCOPY NUMBER,

Line 1716: p_default IN VARCHAR2 := FND_API.G_FALSE,

1712: p_api_version IN NUMBER := '1.0',
1713: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1716: p_default IN VARCHAR2 := FND_API.G_FALSE,
1717: p_module_type IN VARCHAR2 := NULL,
1718: x_return_status OUT NOCOPY VARCHAR2,
1719: x_msg_count OUT NOCOPY NUMBER,
1720: x_msg_data OUT NOCOPY VARCHAR2,

Line 1776: x_return_status := FND_API.G_RET_STS_SUCCESS;

1772: l_MR_EFFECTIVITY_EXT_DTL_ID NUMBER;
1773:
1774: BEGIN
1775: -- Initialize API return status to success
1776: x_return_status := FND_API.G_RET_STS_SUCCESS;
1777:
1778: -- Standard Start of API savepoint
1779: SAVEPOINT process_effectivity_detail_PVT;
1780:

Line 1782: IF NOT FND_API.compatible_api_call

1778: -- Standard Start of API savepoint
1779: SAVEPOINT process_effectivity_detail_PVT;
1780:
1781: -- Standard call to check for call compatibility.
1782: IF NOT FND_API.compatible_api_call
1783: (
1784: l_api_version,
1785: p_api_version,
1786: G_API_NAME,

Line 1790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1786: G_API_NAME,
1787: G_PKG_NAME
1788: )
1789: THEN
1790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1791: END IF;
1792:
1793: -- Initialize message list if p_init_msg_list is set to TRUE.
1794: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 1794: IF FND_API.to_boolean( p_init_msg_list ) THEN

1790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1791: END IF;
1792:
1793: -- Initialize message list if p_init_msg_list is set to TRUE.
1794: IF FND_API.to_boolean( p_init_msg_list ) THEN
1795: FND_MSG_PUB.initialize;
1796: END IF;
1797:
1798: -- Enable Debug (optional)

Line 1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1814: l_return_status -- OUT
1815: );
1816:
1817: -- If any severe error occurs, then, abort API.
1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1819: RAISE FND_API.G_EXC_ERROR;
1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: END IF;

Line 1819: RAISE FND_API.G_EXC_ERROR;

1815: );
1816:
1817: -- If any severe error occurs, then, abort API.
1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1819: RAISE FND_API.G_EXC_ERROR;
1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: END IF;
1823:

Line 1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1816:
1817: -- If any severe error occurs, then, abort API.
1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1819: RAISE FND_API.G_EXC_ERROR;
1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: END IF;
1823:
1824: IF G_DEBUG = 'Y' THEN

Line 1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1817: -- If any severe error occurs, then, abort API.
1818: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1819: RAISE FND_API.G_EXC_ERROR;
1820: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: END IF;
1823:
1824: IF G_DEBUG = 'Y' THEN
1825: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Done validate_api_inputs' );

Line 1852: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

1848: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : Done clear_lov_attribute_ids and clear_ext_lov_attribute_ids' );
1849: END IF;
1850:
1851: -- Convert Values into Ids.
1852: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
1853: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
1854: IF ( p_x_effectivity_detail_tbl(i).dml_operation <> 'D' ) THEN
1855: convert_values_to_ids
1856: (

Line 1863: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1859: l_return_status -- OUT
1860: );
1861:
1862: -- If any severe error occurs, then, abort API.
1863: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1864: RAISE FND_API.G_EXC_ERROR;
1865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1867: END IF;

Line 1864: RAISE FND_API.G_EXC_ERROR;

1860: );
1861:
1862: -- If any severe error occurs, then, abort API.
1863: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1864: RAISE FND_API.G_EXC_ERROR;
1865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1867: END IF;
1868: END IF;

Line 1865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1861:
1862: -- If any severe error occurs, then, abort API.
1863: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1864: RAISE FND_API.G_EXC_ERROR;
1865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1867: END IF;
1868: END IF;
1869: END LOOP;

Line 1866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1862: -- If any severe error occurs, then, abort API.
1863: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1864: RAISE FND_API.G_EXC_ERROR;
1865: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1867: END IF;
1868: END IF;
1869: END LOOP;
1870: FOR i IN 1..p_x_effty_ext_detail_tbl.count LOOP

Line 1880: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1876: l_return_status -- OUT
1877: );
1878:
1879: -- If any severe error occurs, then, abort API.
1880: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1881: RAISE FND_API.G_EXC_ERROR;
1882: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1884: END IF;

Line 1881: RAISE FND_API.G_EXC_ERROR;

1877: );
1878:
1879: -- If any severe error occurs, then, abort API.
1880: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1881: RAISE FND_API.G_EXC_ERROR;
1882: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1884: END IF;
1885: END IF;

Line 1882: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1878:
1879: -- If any severe error occurs, then, abort API.
1880: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1881: RAISE FND_API.G_EXC_ERROR;
1882: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1884: END IF;
1885: END IF;
1886: END LOOP;

Line 1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1879: -- If any severe error occurs, then, abort API.
1880: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1881: RAISE FND_API.G_EXC_ERROR;
1882: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1883: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1884: END IF;
1885: END IF;
1886: END LOOP;
1887: END IF;

Line 1894: IF FND_API.to_boolean( p_default ) THEN

1890: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after convert_values_to_ids' );
1891: END IF;
1892:
1893: -- Default effectivity_detail attributes.
1894: IF FND_API.to_boolean( p_default ) THEN
1895: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
1896: IF ( p_x_effectivity_detail_tbl(i).dml_operation <> 'D' ) THEN
1897: default_attributes
1898: (

Line 1918: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

1914: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_attributes' );
1915: END IF;
1916:
1917: -- Validate all attributes (Item level validation)
1918: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
1919: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
1920: validate_attributes
1921: (
1922: p_x_effectivity_detail_tbl(i), -- IN

Line 1927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1923: l_return_status -- OUT
1924: );
1925:
1926: -- If any severe error occurs, then, abort API.
1927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1928: RAISE FND_API.G_EXC_ERROR;
1929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END IF;

Line 1928: RAISE FND_API.G_EXC_ERROR;

1924: );
1925:
1926: -- If any severe error occurs, then, abort API.
1927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1928: RAISE FND_API.G_EXC_ERROR;
1929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END IF;
1932: END LOOP;

Line 1929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1925:
1926: -- If any severe error occurs, then, abort API.
1927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1928: RAISE FND_API.G_EXC_ERROR;
1929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END IF;
1932: END LOOP;
1933: FOR i IN 1..p_x_effty_ext_detail_tbl.count LOOP

Line 1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1926: -- If any severe error occurs, then, abort API.
1927: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1928: RAISE FND_API.G_EXC_ERROR;
1929: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1931: END IF;
1932: END LOOP;
1933: FOR i IN 1..p_x_effty_ext_detail_tbl.count LOOP
1934: validate_ext_attributes

Line 1941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1937: l_return_status -- OUT
1938: );
1939:
1940: -- If any severe error occurs, then, abort API.
1941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1942: RAISE FND_API.G_EXC_ERROR;
1943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;

Line 1942: RAISE FND_API.G_EXC_ERROR;

1938: );
1939:
1940: -- If any severe error occurs, then, abort API.
1941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1942: RAISE FND_API.G_EXC_ERROR;
1943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;
1946: END LOOP;

Line 1943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1939:
1940: -- If any severe error occurs, then, abort API.
1941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1942: RAISE FND_API.G_EXC_ERROR;
1943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;
1946: END LOOP;
1947: END IF;

Line 1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1940: -- If any severe error occurs, then, abort API.
1941: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1942: RAISE FND_API.G_EXC_ERROR;
1943: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1945: END IF;
1946: END LOOP;
1947: END IF;
1948:

Line 1988: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN

1984: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_unchanged_attributes / default_missing_attributes' );
1985: END IF;
1986:
1987: -- Perform cross attribute validation and missing attribute checks (Record level validation)
1988: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
1989: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
1990: IF ( p_x_effectivity_detail_tbl(i).dml_operation <> 'D' ) THEN
1991: validate_record
1992: (

Line 1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1994: l_return_status -- OUT
1995: );
1996:
1997: -- If any severe error occurs, then, abort API.
1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: END IF;

Line 1999: RAISE FND_API.G_EXC_ERROR;

1995: );
1996:
1997: -- If any severe error occurs, then, abort API.
1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: END IF;
2003: END IF;

Line 2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1996:
1997: -- If any severe error occurs, then, abort API.
1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: END IF;
2003: END IF;
2004: END LOOP;

Line 2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1997: -- If any severe error occurs, then, abort API.
1998: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1999: RAISE FND_API.G_EXC_ERROR;
2000: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2002: END IF;
2003: END IF;
2004: END LOOP;
2005: FOR i IN 1..p_x_effty_ext_detail_tbl.count LOOP

Line 2014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2010: l_return_status -- OUT
2011: );
2012:
2013: -- If any severe error occurs, then, abort API.
2014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2018: END IF;

Line 2015: RAISE FND_API.G_EXC_ERROR;

2011: );
2012:
2013: -- If any severe error occurs, then, abort API.
2014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2018: END IF;
2019: END IF;

Line 2016: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2012:
2013: -- If any severe error occurs, then, abort API.
2014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2018: END IF;
2019: END IF;
2020: END LOOP;

Line 2017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2013: -- If any severe error occurs, then, abort API.
2014: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2015: RAISE FND_API.G_EXC_ERROR;
2016: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2018: END IF;
2019: END IF;
2020: END LOOP;
2021: END IF;

Line 2031: RAISE FND_API.G_EXC_ERROR;

2027: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2028: l_msg_count := FND_MSG_PUB.count_msg;
2029: IF l_msg_count > 0 THEN
2030: x_msg_count := l_msg_count;
2031: RAISE FND_API.G_EXC_ERROR;
2032: END IF;
2033:
2034: -- Perform the DML statement directly.
2035: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP

Line 2149: RAISE FND_API.G_EXC_ERROR;

2145: IF ( SQL%ROWCOUNT = 0 ) THEN
2146: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2147: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_tbl(i) ) );
2148: FND_MSG_PUB.add;
2149: RAISE FND_API.G_EXC_ERROR;
2150: END IF;
2151:
2152: -- Set OUT values
2153: p_x_effectivity_detail_tbl(i).object_version_number := p_x_effectivity_detail_tbl(i).object_version_number + 1;

Line 2167: RAISE FND_API.G_EXC_ERROR;

2163: IF ( SQL%ROWCOUNT = 0 ) THEN
2164: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2165: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2166: FND_MSG_PUB.add;
2167: RAISE FND_API.G_EXC_ERROR;
2168: END IF;
2169: END IF;
2170:
2171:

Line 2229: RAISE FND_API.G_EXC_ERROR;

2225: THEN
2226: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_MED_REC' );
2227: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_tbl(i) ) );
2228: FND_MSG_PUB.add;
2229: RAISE FND_API.G_EXC_ERROR;
2230: END IF;
2231:
2232: END IF;
2233:

Line 2354: RAISE FND_API.G_EXC_ERROR;

2350: IF ( SQL%ROWCOUNT = 0 ) THEN
2351: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2352: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_tbl(i) ) );
2353: FND_MSG_PUB.add;
2354: RAISE FND_API.G_EXC_ERROR;
2355: END IF;
2356:
2357: -- Set OUT values
2358: p_x_effty_ext_detail_tbl(i).object_version_number := p_x_effty_ext_detail_tbl(i).object_version_number + 1;

Line 2372: RAISE FND_API.G_EXC_ERROR;

2368: IF ( SQL%ROWCOUNT = 0 ) THEN
2369: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2370: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2371: FND_MSG_PUB.add;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;
2374: END IF;
2375:
2376:

Line 2388: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2384: l_return_status -- OUT
2385: );
2386:
2387: -- If any severe error occurs, then, abort API.
2388: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2389: RAISE FND_API.G_EXC_ERROR;
2390: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: END IF;

Line 2389: RAISE FND_API.G_EXC_ERROR;

2385: );
2386:
2387: -- If any severe error occurs, then, abort API.
2388: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2389: RAISE FND_API.G_EXC_ERROR;
2390: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: END IF;
2393:

Line 2390: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2386:
2387: -- If any severe error occurs, then, abort API.
2388: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2389: RAISE FND_API.G_EXC_ERROR;
2390: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: END IF;
2393:
2394: IF G_DEBUG = 'Y' THEN

Line 2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2387: -- If any severe error occurs, then, abort API.
2388: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2389: RAISE FND_API.G_EXC_ERROR;
2390: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: END IF;
2393:
2394: IF G_DEBUG = 'Y' THEN
2395: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );

Line 2399: IF FND_API.to_boolean( p_commit ) THEN

2395: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );
2396: END IF;
2397:
2398: -- Perform the Commit (if requested)
2399: IF FND_API.to_boolean( p_commit ) THEN
2400: COMMIT WORK;
2401: END IF;
2402:
2403: -- Count and Get messages (optional)

Line 2406: p_encoded => FND_API.G_FALSE,

2402:
2403: -- Count and Get messages (optional)
2404: FND_MSG_PUB.count_and_get
2405: (
2406: p_encoded => FND_API.G_FALSE,
2407: p_count => x_msg_count,
2408: p_data => x_msg_data
2409: );
2410:

Line 2418: WHEN FND_API.G_EXC_ERROR THEN

2414: END IF;
2415:
2416: EXCEPTION
2417:
2418: WHEN FND_API.G_EXC_ERROR THEN
2419: ROLLBACK TO process_effectivity_detail_PVT;
2420: x_return_status := FND_API.G_RET_STS_ERROR ;
2421: FND_MSG_PUB.count_and_get
2422: (

Line 2420: x_return_status := FND_API.G_RET_STS_ERROR ;

2416: EXCEPTION
2417:
2418: WHEN FND_API.G_EXC_ERROR THEN
2419: ROLLBACK TO process_effectivity_detail_PVT;
2420: x_return_status := FND_API.G_RET_STS_ERROR ;
2421: FND_MSG_PUB.count_and_get
2422: (
2423: p_encoded => FND_API.G_FALSE,
2424: p_count => x_msg_count,

Line 2423: p_encoded => FND_API.G_FALSE,

2419: ROLLBACK TO process_effectivity_detail_PVT;
2420: x_return_status := FND_API.G_RET_STS_ERROR ;
2421: FND_MSG_PUB.count_and_get
2422: (
2423: p_encoded => FND_API.G_FALSE,
2424: p_count => x_msg_count,
2425: p_data => x_msg_data
2426: );
2427:

Line 2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2429: IF ( G_DEBUG = 'Y' ) THEN
2430: AHL_DEBUG_PUB.disable_debug;
2431: END IF;
2432:
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: ROLLBACK TO process_effectivity_detail_PVT;
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2436: FND_MSG_PUB.count_and_get
2437: (

Line 2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2431: END IF;
2432:
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: ROLLBACK TO process_effectivity_detail_PVT;
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2436: FND_MSG_PUB.count_and_get
2437: (
2438: p_encoded => FND_API.G_FALSE,
2439: p_count => x_msg_count,

Line 2438: p_encoded => FND_API.G_FALSE,

2434: ROLLBACK TO process_effectivity_detail_PVT;
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2436: FND_MSG_PUB.count_and_get
2437: (
2438: p_encoded => FND_API.G_FALSE,
2439: p_count => x_msg_count,
2440: p_data => x_msg_data
2441: );
2442:

Line 2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2446: END IF;
2447:
2448: WHEN OTHERS THEN
2449: ROLLBACK TO process_effectivity_detail_PVT;
2450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2451: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2452: THEN
2453: FND_MSG_PUB.add_exc_msg
2454: (

Line 2462: p_encoded => FND_API.G_FALSE,

2458: );
2459: END IF;
2460: FND_MSG_PUB.count_and_get
2461: (
2462: p_encoded => FND_API.G_FALSE,
2463: p_count => x_msg_count,
2464: p_data => x_msg_data
2465: );
2466: