eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.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 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74: l_return_status VARCHAR2(1);
75: l_msg_data VARCHAR2(2000);
76: l_appln_code VARCHAR2(30);
77: BEGIN
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79:
80: -- Check Profile value
81:
82: IF G_APPLN_USAGE IS NULL

Line 93: x_return_status := FND_API.G_RET_STS_ERROR;

89:
90: IF ( G_APPLN_USAGE = 'PM' ) THEN
91: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_MED_PM_INSTALL' );
92: FND_MSG_PUB.add;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: RETURN;
95: END IF;
96:
97: -- Check if a valid value is passed in p_mr_header_id

Line 99: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR

95: END IF;
96:
97: -- Check if a valid value is passed in p_mr_header_id
98:
99: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
100: p_mr_header_id IS NULL ) THEN
101: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
102: FND_MSG_PUB.add;
103: x_return_status := FND_API.G_RET_STS_ERROR;

Line 103: x_return_status := FND_API.G_RET_STS_ERROR;

99: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
100: p_mr_header_id IS NULL ) THEN
101: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
102: FND_MSG_PUB.add;
103: x_return_status := FND_API.G_RET_STS_ERROR;
104: RETURN;
105: END IF;
106:
107: -- Check if the Maintenance Requirement is in Updatable status

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

111: x_msg_data => l_msg_data,
112: p_mr_header_id => p_mr_header_id
113: );
114:
115: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
116: FND_MESSAGE.set_name( 'AHL', l_msg_data );
117: FND_MSG_PUB.add;
118: x_return_status := l_return_status;
119: RETURN;

Line 123: IF ( p_mr_effectivity_id = FND_API.G_MISS_NUM OR

119: RETURN;
120: END IF;
121:
122: -- Check if a valid value is passed in p_mr_effectivity_id
123: IF ( p_mr_effectivity_id = FND_API.G_MISS_NUM OR
124: p_mr_effectivity_id IS NULL ) THEN
125: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MRE_ID_NULL' );
126: FND_MSG_PUB.add;
127: x_return_status := FND_API.G_RET_STS_ERROR;

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

123: IF ( p_mr_effectivity_id = FND_API.G_MISS_NUM OR
124: p_mr_effectivity_id IS NULL ) THEN
125: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MRE_ID_NULL' );
126: FND_MSG_PUB.add;
127: x_return_status := FND_API.G_RET_STS_ERROR;
128: RETURN;
129: END IF;
130:
131: -- Check if the Maintenance Requirement Effectivity exists

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

135: x_msg_data => l_msg_data,
136: p_mr_effectivity_id => p_mr_effectivity_id
137: );
138:
139: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
140: FND_MESSAGE.set_name( 'AHL', l_msg_data );
141: FND_MSG_PUB.add;
142: x_return_status := l_return_status;
143: RETURN;

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: IF ( p_effectivity_detail_tbl.count < 1 ) THEN
148: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
149: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
150: FND_MSG_PUB.add;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: RETURN;
153: END IF;
154:
155: -- Validate DML Operation

Line 164: x_return_status := FND_API.G_RET_STS_ERROR;

160: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
161: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_tbl(i).dml_operation );
162: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_tbl(i) ) );
163: FND_MSG_PUB.add;
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: RETURN;
166: END IF;
167: END LOOP;
168:

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

178: BEGIN
179:
180: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL ) THEN
181: p_x_effectivity_detail_rec.manufacturer_id := NULL;
182: ELSIF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
183: p_x_effectivity_detail_rec.manufacturer_id := FND_API.G_MISS_NUM;
184: END IF;
185:
186: IF ( p_x_effectivity_detail_rec.country IS NULL ) THEN

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

179:
180: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL ) THEN
181: p_x_effectivity_detail_rec.manufacturer_id := NULL;
182: ELSIF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
183: p_x_effectivity_detail_rec.manufacturer_id := FND_API.G_MISS_NUM;
184: END IF;
185:
186: IF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
187: p_x_effectivity_detail_rec.country_code := NULL;

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

184: END IF;
185:
186: IF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
187: p_x_effectivity_detail_rec.country_code := NULL;
188: ELSIF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
189: p_x_effectivity_detail_rec.country_code := FND_API.G_MISS_CHAR;
190: END IF;
191:
192: END clear_lov_attribute_ids;

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

185:
186: IF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
187: p_x_effectivity_detail_rec.country_code := NULL;
188: ELSIF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
189: p_x_effectivity_detail_rec.country_code := FND_API.G_MISS_CHAR;
190: END IF;
191:
192: END clear_lov_attribute_ids;
193:

Line 224: x_return_status := FND_API.G_RET_STS_SUCCESS;

220: FROM AHL_MR_EFFECTIVITIES_V
221: WHERE mr_effectivity_id = c_mr_effectivity_id;
222:
223: BEGIN
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: -- Convert / Validate Manufacturer
227: IF ( ( p_x_effectivity_detail_rec.manufacturer_id IS NOT NULL AND
228: p_x_effectivity_detail_rec.manufacturer_id <> FND_API.G_MISS_NUM ) OR

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

224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: -- Convert / Validate Manufacturer
227: IF ( ( p_x_effectivity_detail_rec.manufacturer_id IS NOT NULL AND
228: p_x_effectivity_detail_rec.manufacturer_id <> FND_API.G_MISS_NUM ) OR
229: ( p_x_effectivity_detail_rec.manufacturer IS NOT NULL AND
230: p_x_effectivity_detail_rec.manufacturer <> FND_API.G_MISS_CHAR ) ) THEN
231:
232: OPEN get_item_effectivity( p_mr_effectivity_id );

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

226: -- Convert / Validate Manufacturer
227: IF ( ( p_x_effectivity_detail_rec.manufacturer_id IS NOT NULL AND
228: p_x_effectivity_detail_rec.manufacturer_id <> FND_API.G_MISS_NUM ) OR
229: ( p_x_effectivity_detail_rec.manufacturer IS NOT NULL AND
230: p_x_effectivity_detail_rec.manufacturer <> FND_API.G_MISS_CHAR ) ) THEN
231:
232: OPEN get_item_effectivity( p_mr_effectivity_id );
233:
234: FETCH get_item_effectivity INTO

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

248: p_manufacturer_name => p_x_effectivity_detail_rec.manufacturer,
249: p_x_manufacturer_id => p_x_effectivity_detail_rec.manufacturer_id
250: );
251:
252: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
253: FND_MESSAGE.set_name( 'AHL', l_msg_data );
254:
255: IF ( l_msg_data = 'AHL_FMP_INVALID_MF' OR
256: l_msg_data = 'AHL_FMP_TOO_MANY_MFS' ) THEN

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

254:
255: IF ( l_msg_data = 'AHL_FMP_INVALID_MF' OR
256: l_msg_data = 'AHL_FMP_TOO_MANY_MFS' ) THEN
257: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR
258: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
259: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));
260: ELSE
261: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.manufacturer );
262: END IF;

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

261: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.manufacturer );
262: END IF;
263: ELSE
264: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR
265: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
266: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));
267: ELSE
268: FND_MESSAGE.set_token( 'FIELD1', p_x_effectivity_detail_rec.manufacturer );
269: END IF;

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

282: END IF;
283:
284: -- Convert / Validate Country
285: IF ( ( p_x_effectivity_detail_rec.country_code IS NOT NULL AND
286: p_x_effectivity_detail_rec.country_code <> FND_API.G_MISS_CHAR )
287: OR
288: ( p_x_effectivity_detail_rec.country IS NOT NULL AND
289: p_x_effectivity_detail_rec.country <> FND_API.G_MISS_CHAR ) )
290: THEN

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

285: IF ( ( p_x_effectivity_detail_rec.country_code IS NOT NULL AND
286: p_x_effectivity_detail_rec.country_code <> FND_API.G_MISS_CHAR )
287: OR
288: ( p_x_effectivity_detail_rec.country IS NOT NULL AND
289: p_x_effectivity_detail_rec.country <> FND_API.G_MISS_CHAR ) )
290: THEN
291:
292: AHL_FMP_COMMON_PVT.validate_country
293: (

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

296: p_country_name => p_x_effectivity_detail_rec.country,
297: p_x_country_code => p_x_effectivity_detail_rec.country_code
298: );
299:
300: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
301: FND_MESSAGE.set_name( 'AHL', l_msg_data );
302: IF ( p_x_effectivity_detail_rec.country IS NULL OR
303: p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
304: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country_code );

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

299:
300: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
301: FND_MESSAGE.set_name( 'AHL', l_msg_data );
302: IF ( p_x_effectivity_detail_rec.country IS NULL OR
303: p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
304: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country_code );
305: ELSE
306: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country );
307: END IF;

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

343:
344: BEGIN
345:
346: -- Convert G_MISS values to NULL
347: IF ( p_x_effectivity_detail_rec.serial_number_from = FND_API.G_MISS_CHAR ) THEN
348: p_x_effectivity_detail_rec.serial_number_from := null;
349: END IF;
350:
351: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN

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

347: IF ( p_x_effectivity_detail_rec.serial_number_from = FND_API.G_MISS_CHAR ) THEN
348: p_x_effectivity_detail_rec.serial_number_from := null;
349: END IF;
350:
351: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN
352: p_x_effectivity_detail_rec.serial_number_to := null;
353: END IF;
354:
355: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN

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

351: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN
352: p_x_effectivity_detail_rec.serial_number_to := null;
353: END IF;
354:
355: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN
356: p_x_effectivity_detail_rec.manufacturer_id := null;
357: END IF;
358:
359: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN

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

355: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN
356: p_x_effectivity_detail_rec.manufacturer_id := null;
357: END IF;
358:
359: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
360: p_x_effectivity_detail_rec.manufacturer := null;
361: END IF;
362:
363: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN

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

359: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
360: p_x_effectivity_detail_rec.manufacturer := null;
361: END IF;
362:
363: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN
364: p_x_effectivity_detail_rec.manufacture_date_from := null;
365: END IF;
366:
367: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN

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

363: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN
364: p_x_effectivity_detail_rec.manufacture_date_from := null;
365: END IF;
366:
367: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN
368: p_x_effectivity_detail_rec.manufacture_date_to := null;
369: END IF;
370:
371: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN

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

367: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN
368: p_x_effectivity_detail_rec.manufacture_date_to := null;
369: END IF;
370:
371: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN
372: p_x_effectivity_detail_rec.country_code := null;
373: END IF;
374:
375: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN

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

371: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN
372: p_x_effectivity_detail_rec.country_code := null;
373: END IF;
374:
375: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
376: p_x_effectivity_detail_rec.country := null;
377: END IF;
378:
379: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN

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

375: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
376: p_x_effectivity_detail_rec.country := null;
377: END IF;
378:
379: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
380: p_x_effectivity_detail_rec.attribute_category := null;
381: END IF;
382:
383: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN

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

379: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
380: p_x_effectivity_detail_rec.attribute_category := null;
381: END IF;
382:
383: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
384: p_x_effectivity_detail_rec.attribute1 := null;
385: END IF;
386:
387: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN

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

383: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
384: p_x_effectivity_detail_rec.attribute1 := null;
385: END IF;
386:
387: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
388: p_x_effectivity_detail_rec.attribute2 := null;
389: END IF;
390:
391: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN

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

387: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
388: p_x_effectivity_detail_rec.attribute2 := null;
389: END IF;
390:
391: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
392: p_x_effectivity_detail_rec.attribute3 := null;
393: END IF;
394:
395: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN

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

391: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
392: p_x_effectivity_detail_rec.attribute3 := null;
393: END IF;
394:
395: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
396: p_x_effectivity_detail_rec.attribute4 := null;
397: END IF;
398:
399: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN

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

395: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
396: p_x_effectivity_detail_rec.attribute4 := null;
397: END IF;
398:
399: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
400: p_x_effectivity_detail_rec.attribute5 := null;
401: END IF;
402:
403: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN

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

399: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
400: p_x_effectivity_detail_rec.attribute5 := null;
401: END IF;
402:
403: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
404: p_x_effectivity_detail_rec.attribute6 := null;
405: END IF;
406:
407: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN

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

403: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
404: p_x_effectivity_detail_rec.attribute6 := null;
405: END IF;
406:
407: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
408: p_x_effectivity_detail_rec.attribute7 := null;
409: END IF;
410:
411: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN

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

407: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
408: p_x_effectivity_detail_rec.attribute7 := null;
409: END IF;
410:
411: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
412: p_x_effectivity_detail_rec.attribute8 := null;
413: END IF;
414:
415: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN

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

411: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
412: p_x_effectivity_detail_rec.attribute8 := null;
413: END IF;
414:
415: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
416: p_x_effectivity_detail_rec.attribute9 := null;
417: END IF;
418:
419: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN

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

415: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
416: p_x_effectivity_detail_rec.attribute9 := null;
417: END IF;
418:
419: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
420: p_x_effectivity_detail_rec.attribute10 := null;
421: END IF;
422:
423: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN

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

419: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
420: p_x_effectivity_detail_rec.attribute10 := null;
421: END IF;
422:
423: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
424: p_x_effectivity_detail_rec.attribute11 := null;
425: END IF;
426:
427: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN

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

423: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
424: p_x_effectivity_detail_rec.attribute11 := null;
425: END IF;
426:
427: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
428: p_x_effectivity_detail_rec.attribute12 := null;
429: END IF;
430:
431: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN

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

427: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
428: p_x_effectivity_detail_rec.attribute12 := null;
429: END IF;
430:
431: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
432: p_x_effectivity_detail_rec.attribute13 := null;
433: END IF;
434:
435: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN

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

431: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
432: p_x_effectivity_detail_rec.attribute13 := null;
433: END IF;
434:
435: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
436: p_x_effectivity_detail_rec.attribute14 := null;
437: END IF;
438:
439: IF ( p_x_effectivity_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN

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

435: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
436: p_x_effectivity_detail_rec.attribute14 := null;
437: END IF;
438:
439: IF ( p_x_effectivity_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
440: p_x_effectivity_detail_rec.attribute15 := null;
441: END IF;
442:
443: END default_missing_attributes;

Line 521: RAISE FND_API.G_EXC_ERROR;

517: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_EFF_DTL_REC' );
518: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );
519: FND_MSG_PUB.add;
520: CLOSE get_old_rec;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524: CLOSE get_old_rec;
525:

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

527: IF ( p_x_effectivity_detail_rec.exclude_flag IS NULL ) THEN
528: p_x_effectivity_detail_rec.exclude_flag := l_old_effectivity_detail_rec.exclude_flag;
529: END IF;
530:
531: IF ( p_x_effectivity_detail_rec.serial_number_from = FND_API.G_MISS_CHAR ) THEN
532: p_x_effectivity_detail_rec.serial_number_from := null;
533: ELSIF ( p_x_effectivity_detail_rec.serial_number_from IS NULL ) THEN
534: p_x_effectivity_detail_rec.serial_number_from := l_old_effectivity_detail_rec.serial_number_from;
535: END IF;

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

533: ELSIF ( p_x_effectivity_detail_rec.serial_number_from IS NULL ) THEN
534: p_x_effectivity_detail_rec.serial_number_from := l_old_effectivity_detail_rec.serial_number_from;
535: END IF;
536:
537: IF ( p_x_effectivity_detail_rec.serial_number_to = FND_API.G_MISS_CHAR ) THEN
538: p_x_effectivity_detail_rec.serial_number_to := null;
539: ELSIF ( p_x_effectivity_detail_rec.serial_number_to IS NULL ) THEN
540: p_x_effectivity_detail_rec.serial_number_to := l_old_effectivity_detail_rec.serial_number_to;
541: END IF;

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

539: ELSIF ( p_x_effectivity_detail_rec.serial_number_to IS NULL ) THEN
540: p_x_effectivity_detail_rec.serial_number_to := l_old_effectivity_detail_rec.serial_number_to;
541: END IF;
542:
543: IF ( p_x_effectivity_detail_rec.manufacturer_id = FND_API.G_MISS_NUM ) THEN
544: p_x_effectivity_detail_rec.manufacturer_id := null;
545: ELSIF ( p_x_effectivity_detail_rec.manufacturer_id IS NULL ) THEN
546: p_x_effectivity_detail_rec.manufacturer_id := l_old_effectivity_detail_rec.manufacturer_id;
547: END IF;

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

545: ELSIF ( p_x_effectivity_detail_rec.manufacturer_id IS NULL ) THEN
546: p_x_effectivity_detail_rec.manufacturer_id := l_old_effectivity_detail_rec.manufacturer_id;
547: END IF;
548:
549: IF ( p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
550: p_x_effectivity_detail_rec.manufacturer := null;
551: ELSIF ( p_x_effectivity_detail_rec.manufacturer IS NULL ) THEN
552: p_x_effectivity_detail_rec.manufacturer := l_old_effectivity_detail_rec.manufacturer;
553: END IF;

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

551: ELSIF ( p_x_effectivity_detail_rec.manufacturer IS NULL ) THEN
552: p_x_effectivity_detail_rec.manufacturer := l_old_effectivity_detail_rec.manufacturer;
553: END IF;
554:
555: IF ( p_x_effectivity_detail_rec.manufacture_date_from = FND_API.G_MISS_DATE ) THEN
556: p_x_effectivity_detail_rec.manufacture_date_from := null;
557: ELSIF ( p_x_effectivity_detail_rec.manufacture_date_from IS NULL ) THEN
558: p_x_effectivity_detail_rec.manufacture_date_from := l_old_effectivity_detail_rec.manufacture_date_from;
559: END IF;

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

557: ELSIF ( p_x_effectivity_detail_rec.manufacture_date_from IS NULL ) THEN
558: p_x_effectivity_detail_rec.manufacture_date_from := l_old_effectivity_detail_rec.manufacture_date_from;
559: END IF;
560:
561: IF ( p_x_effectivity_detail_rec.manufacture_date_to = FND_API.G_MISS_DATE ) THEN
562: p_x_effectivity_detail_rec.manufacture_date_to := null;
563: ELSIF ( p_x_effectivity_detail_rec.manufacture_date_to IS NULL ) THEN
564: p_x_effectivity_detail_rec.manufacture_date_to := l_old_effectivity_detail_rec.manufacture_date_to;
565: END IF;

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

563: ELSIF ( p_x_effectivity_detail_rec.manufacture_date_to IS NULL ) THEN
564: p_x_effectivity_detail_rec.manufacture_date_to := l_old_effectivity_detail_rec.manufacture_date_to;
565: END IF;
566:
567: IF ( p_x_effectivity_detail_rec.country_code = FND_API.G_MISS_CHAR ) THEN
568: p_x_effectivity_detail_rec.country_code := null;
569: ELSIF ( p_x_effectivity_detail_rec.country_code IS NULL ) THEN
570: p_x_effectivity_detail_rec.country_code := l_old_effectivity_detail_rec.country_code;
571: END IF;

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

569: ELSIF ( p_x_effectivity_detail_rec.country_code IS NULL ) THEN
570: p_x_effectivity_detail_rec.country_code := l_old_effectivity_detail_rec.country_code;
571: END IF;
572:
573: IF ( p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
574: p_x_effectivity_detail_rec.country := null;
575: ELSIF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
576: p_x_effectivity_detail_rec.country := l_old_effectivity_detail_rec.country;
577: END IF;

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

575: ELSIF ( p_x_effectivity_detail_rec.country IS NULL ) THEN
576: p_x_effectivity_detail_rec.country := l_old_effectivity_detail_rec.country;
577: END IF;
578:
579: IF ( p_x_effectivity_detail_rec.attribute_category = FND_API.G_MISS_CHAR ) THEN
580: p_x_effectivity_detail_rec.attribute_category := null;
581: ELSIF ( p_x_effectivity_detail_rec.attribute_category IS NULL ) THEN
582: p_x_effectivity_detail_rec.attribute_category := l_old_effectivity_detail_rec.attribute_category;
583: END IF;

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

581: ELSIF ( p_x_effectivity_detail_rec.attribute_category IS NULL ) THEN
582: p_x_effectivity_detail_rec.attribute_category := l_old_effectivity_detail_rec.attribute_category;
583: END IF;
584:
585: IF ( p_x_effectivity_detail_rec.attribute1 = FND_API.G_MISS_CHAR ) THEN
586: p_x_effectivity_detail_rec.attribute1 := null;
587: ELSIF ( p_x_effectivity_detail_rec.attribute1 IS NULL ) THEN
588: p_x_effectivity_detail_rec.attribute1 := l_old_effectivity_detail_rec.attribute1;
589: END IF;

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

587: ELSIF ( p_x_effectivity_detail_rec.attribute1 IS NULL ) THEN
588: p_x_effectivity_detail_rec.attribute1 := l_old_effectivity_detail_rec.attribute1;
589: END IF;
590:
591: IF ( p_x_effectivity_detail_rec.attribute2 = FND_API.G_MISS_CHAR ) THEN
592: p_x_effectivity_detail_rec.attribute2 := null;
593: ELSIF ( p_x_effectivity_detail_rec.attribute2 IS NULL ) THEN
594: p_x_effectivity_detail_rec.attribute2 := l_old_effectivity_detail_rec.attribute2;
595: END IF;

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

593: ELSIF ( p_x_effectivity_detail_rec.attribute2 IS NULL ) THEN
594: p_x_effectivity_detail_rec.attribute2 := l_old_effectivity_detail_rec.attribute2;
595: END IF;
596:
597: IF ( p_x_effectivity_detail_rec.attribute3 = FND_API.G_MISS_CHAR ) THEN
598: p_x_effectivity_detail_rec.attribute3 := null;
599: ELSIF ( p_x_effectivity_detail_rec.attribute3 IS NULL ) THEN
600: p_x_effectivity_detail_rec.attribute3 := l_old_effectivity_detail_rec.attribute3;
601: END IF;

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

599: ELSIF ( p_x_effectivity_detail_rec.attribute3 IS NULL ) THEN
600: p_x_effectivity_detail_rec.attribute3 := l_old_effectivity_detail_rec.attribute3;
601: END IF;
602:
603: IF ( p_x_effectivity_detail_rec.attribute4 = FND_API.G_MISS_CHAR ) THEN
604: p_x_effectivity_detail_rec.attribute4 := null;
605: ELSIF ( p_x_effectivity_detail_rec.attribute4 IS NULL ) THEN
606: p_x_effectivity_detail_rec.attribute4 := l_old_effectivity_detail_rec.attribute4;
607: END IF;

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

605: ELSIF ( p_x_effectivity_detail_rec.attribute4 IS NULL ) THEN
606: p_x_effectivity_detail_rec.attribute4 := l_old_effectivity_detail_rec.attribute4;
607: END IF;
608:
609: IF ( p_x_effectivity_detail_rec.attribute5 = FND_API.G_MISS_CHAR ) THEN
610: p_x_effectivity_detail_rec.attribute5 := null;
611: ELSIF ( p_x_effectivity_detail_rec.attribute5 IS NULL ) THEN
612: p_x_effectivity_detail_rec.attribute5 := l_old_effectivity_detail_rec.attribute5;
613: END IF;

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

611: ELSIF ( p_x_effectivity_detail_rec.attribute5 IS NULL ) THEN
612: p_x_effectivity_detail_rec.attribute5 := l_old_effectivity_detail_rec.attribute5;
613: END IF;
614:
615: IF ( p_x_effectivity_detail_rec.attribute6 = FND_API.G_MISS_CHAR ) THEN
616: p_x_effectivity_detail_rec.attribute6 := null;
617: ELSIF ( p_x_effectivity_detail_rec.attribute6 IS NULL ) THEN
618: p_x_effectivity_detail_rec.attribute6 := l_old_effectivity_detail_rec.attribute6;
619: END IF;

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

617: ELSIF ( p_x_effectivity_detail_rec.attribute6 IS NULL ) THEN
618: p_x_effectivity_detail_rec.attribute6 := l_old_effectivity_detail_rec.attribute6;
619: END IF;
620:
621: IF ( p_x_effectivity_detail_rec.attribute7 = FND_API.G_MISS_CHAR ) THEN
622: p_x_effectivity_detail_rec.attribute7 := null;
623: ELSIF ( p_x_effectivity_detail_rec.attribute7 IS NULL ) THEN
624: p_x_effectivity_detail_rec.attribute7 := l_old_effectivity_detail_rec.attribute7;
625: END IF;

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

623: ELSIF ( p_x_effectivity_detail_rec.attribute7 IS NULL ) THEN
624: p_x_effectivity_detail_rec.attribute7 := l_old_effectivity_detail_rec.attribute7;
625: END IF;
626:
627: IF ( p_x_effectivity_detail_rec.attribute8 = FND_API.G_MISS_CHAR ) THEN
628: p_x_effectivity_detail_rec.attribute8 := null;
629: ELSIF ( p_x_effectivity_detail_rec.attribute8 IS NULL ) THEN
630: p_x_effectivity_detail_rec.attribute8 := l_old_effectivity_detail_rec.attribute8;
631: END IF;

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

629: ELSIF ( p_x_effectivity_detail_rec.attribute8 IS NULL ) THEN
630: p_x_effectivity_detail_rec.attribute8 := l_old_effectivity_detail_rec.attribute8;
631: END IF;
632:
633: IF ( p_x_effectivity_detail_rec.attribute9 = FND_API.G_MISS_CHAR ) THEN
634: p_x_effectivity_detail_rec.attribute9 := null;
635: ELSIF ( p_x_effectivity_detail_rec.attribute9 IS NULL ) THEN
636: p_x_effectivity_detail_rec.attribute9 := l_old_effectivity_detail_rec.attribute9;
637: END IF;

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

635: ELSIF ( p_x_effectivity_detail_rec.attribute9 IS NULL ) THEN
636: p_x_effectivity_detail_rec.attribute9 := l_old_effectivity_detail_rec.attribute9;
637: END IF;
638:
639: IF ( p_x_effectivity_detail_rec.attribute10 = FND_API.G_MISS_CHAR ) THEN
640: p_x_effectivity_detail_rec.attribute10 := null;
641: ELSIF ( p_x_effectivity_detail_rec.attribute10 IS NULL ) THEN
642: p_x_effectivity_detail_rec.attribute10 := l_old_effectivity_detail_rec.attribute10;
643: END IF;

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

641: ELSIF ( p_x_effectivity_detail_rec.attribute10 IS NULL ) THEN
642: p_x_effectivity_detail_rec.attribute10 := l_old_effectivity_detail_rec.attribute10;
643: END IF;
644:
645: IF ( p_x_effectivity_detail_rec.attribute11 = FND_API.G_MISS_CHAR ) THEN
646: p_x_effectivity_detail_rec.attribute11 := null;
647: ELSIF ( p_x_effectivity_detail_rec.attribute11 IS NULL ) THEN
648: p_x_effectivity_detail_rec.attribute11 := l_old_effectivity_detail_rec.attribute11;
649: END IF;

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

647: ELSIF ( p_x_effectivity_detail_rec.attribute11 IS NULL ) THEN
648: p_x_effectivity_detail_rec.attribute11 := l_old_effectivity_detail_rec.attribute11;
649: END IF;
650:
651: IF ( p_x_effectivity_detail_rec.attribute12 = FND_API.G_MISS_CHAR ) THEN
652: p_x_effectivity_detail_rec.attribute12 := null;
653: ELSIF ( p_x_effectivity_detail_rec.attribute12 IS NULL ) THEN
654: p_x_effectivity_detail_rec.attribute12 := l_old_effectivity_detail_rec.attribute12;
655: END IF;

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

653: ELSIF ( p_x_effectivity_detail_rec.attribute12 IS NULL ) THEN
654: p_x_effectivity_detail_rec.attribute12 := l_old_effectivity_detail_rec.attribute12;
655: END IF;
656:
657: IF ( p_x_effectivity_detail_rec.attribute13 = FND_API.G_MISS_CHAR ) THEN
658: p_x_effectivity_detail_rec.attribute13 := null;
659: ELSIF ( p_x_effectivity_detail_rec.attribute13 IS NULL ) THEN
660: p_x_effectivity_detail_rec.attribute13 := l_old_effectivity_detail_rec.attribute13;
661: END IF;

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

659: ELSIF ( p_x_effectivity_detail_rec.attribute13 IS NULL ) THEN
660: p_x_effectivity_detail_rec.attribute13 := l_old_effectivity_detail_rec.attribute13;
661: END IF;
662:
663: IF ( p_x_effectivity_detail_rec.attribute14 = FND_API.G_MISS_CHAR ) THEN
664: p_x_effectivity_detail_rec.attribute14 := null;
665: ELSIF ( p_x_effectivity_detail_rec.attribute14 IS NULL ) THEN
666: p_x_effectivity_detail_rec.attribute14 := l_old_effectivity_detail_rec.attribute14;
667: END IF;

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

665: ELSIF ( p_x_effectivity_detail_rec.attribute14 IS NULL ) THEN
666: p_x_effectivity_detail_rec.attribute14 := l_old_effectivity_detail_rec.attribute14;
667: END IF;
668:
669: IF ( p_x_effectivity_detail_rec.attribute15 = FND_API.G_MISS_CHAR ) THEN
670: p_x_effectivity_detail_rec.attribute15 := null;
671: ELSIF ( p_x_effectivity_detail_rec.attribute15 IS NULL ) THEN
672: p_x_effectivity_detail_rec.attribute15 := l_old_effectivity_detail_rec.attribute15;
673: END IF;

Line 686: x_return_status := FND_API.G_RET_STS_SUCCESS;

682: )
683: IS
684:
685: BEGIN
686: x_return_status := FND_API.G_RET_STS_SUCCESS;
687:
688: IF ( p_effectivity_detail_rec.dml_operation = 'C' ) THEN
689: -- Check if the Exclude Flag does not contain a null value.
690: IF ( p_effectivity_detail_rec.exclude_flag IS NULL OR

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

687:
688: IF ( p_effectivity_detail_rec.dml_operation = 'C' ) THEN
689: -- Check if the Exclude Flag does not contain a null value.
690: IF ( p_effectivity_detail_rec.exclude_flag IS NULL OR
691: p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
692: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
693: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
694: FND_MSG_PUB.add;
695: ELSE

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

706: END IF;
707:
708: IF ( p_effectivity_detail_rec.dml_operation = 'U' ) THEN
709: -- Check if the Exclude Flag does not contain a null value.
710: IF ( p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
711: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
712: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
713: FND_MSG_PUB.add;
714: ELSIF ( p_effectivity_detail_rec.exclude_flag IS NOT NULL ) THEN

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

724: END IF;
725:
726: -- Check if the mandatory Effectivity Detail ID column contains a null value.
727: IF ( p_effectivity_detail_rec.mr_effectivity_detail_id IS NULL OR
728: p_effectivity_detail_rec.mr_effectivity_detail_id = FND_API.G_MISS_NUM ) THEN
729: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_EFF_DTL_ID_NULL' );
730: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
731: FND_MSG_PUB.add;
732: END IF;

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

732: END IF;
733:
734: -- Check if the mandatory Object Version Number column contains a null value.
735: IF ( p_effectivity_detail_rec.object_version_number IS NULL OR
736: p_effectivity_detail_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
737: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MED_OBJ_VERSION_NULL' );
738: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
739: FND_MSG_PUB.add;
740: END IF;

Line 756: x_return_status := FND_API.G_RET_STS_SUCCESS;

752: l_return_status VARCHAR2(1);
753: l_msg_data VARCHAR2(2000);
754:
755: BEGIN
756: x_return_status := FND_API.G_RET_STS_SUCCESS;
757:
758: -- Check if Serial Number Range is valid
759: IF ( p_effectivity_detail_rec.serial_number_from IS NOT NULL AND
760: p_effectivity_detail_rec.serial_number_to IS NOT NULL ) THEN

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

766: p_serial_number_from => p_effectivity_detail_rec.serial_number_from,
767: p_serial_number_to => p_effectivity_detail_rec.serial_number_to
768: );
769:
770: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
771: FND_MESSAGE.set_name( 'AHL', l_msg_data );
772: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.serial_number_from );
773: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.serial_number_to );
774: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );

Line 836: x_return_status := FND_API.G_RET_STS_SUCCESS;

832: country
833: HAVING count(*) > 1;
834:
835: BEGIN
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837:
838: -- Check whether any duplicate effectivity_detail records exist
839: OPEN get_dup_rec( p_mr_effectivity_id );
840:

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855: END LOOP;
856:
857: IF ( get_dup_rec%ROWCOUNT > 0 ) THEN
858: CLOSE get_dup_rec;
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: RETURN;
861: END IF;
862:
863: CLOSE get_dup_rec;

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

866:
867: PROCEDURE process_effectivity_detail
868: (
869: p_api_version IN NUMBER := '1.0',
870: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
871: p_commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: p_default IN VARCHAR2 := FND_API.G_FALSE,
874: p_module_type IN VARCHAR2 := NULL,

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

867: PROCEDURE process_effectivity_detail
868: (
869: p_api_version IN NUMBER := '1.0',
870: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
871: p_commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: p_default IN VARCHAR2 := FND_API.G_FALSE,
874: p_module_type IN VARCHAR2 := NULL,
875: x_return_status OUT NOCOPY VARCHAR2,

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

868: (
869: p_api_version IN NUMBER := '1.0',
870: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
871: p_commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: p_default IN VARCHAR2 := FND_API.G_FALSE,
874: p_module_type IN VARCHAR2 := NULL,
875: x_return_status OUT NOCOPY VARCHAR2,
876: x_msg_count OUT NOCOPY NUMBER,

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

869: p_api_version IN NUMBER := '1.0',
870: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
871: p_commit IN VARCHAR2 := FND_API.G_FALSE,
872: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
873: p_default IN VARCHAR2 := FND_API.G_FALSE,
874: p_module_type IN VARCHAR2 := NULL,
875: x_return_status OUT NOCOPY VARCHAR2,
876: x_msg_count OUT NOCOPY NUMBER,
877: x_msg_data OUT NOCOPY VARCHAR2,

Line 931: x_return_status := FND_API.G_RET_STS_SUCCESS;

927:
928:
929: BEGIN
930: -- Initialize API return status to success
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:
933: -- Standard Start of API savepoint
934: SAVEPOINT process_effectivity_detail_PVT;
935:

Line 937: IF NOT FND_API.compatible_api_call

933: -- Standard Start of API savepoint
934: SAVEPOINT process_effectivity_detail_PVT;
935:
936: -- Standard call to check for call compatibility.
937: IF NOT FND_API.compatible_api_call
938: (
939: l_api_version,
940: p_api_version,
941: G_API_NAME,

Line 945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

941: G_API_NAME,
942: G_PKG_NAME
943: )
944: THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END IF;
947:
948: -- Initialize message list if p_init_msg_list is set to TRUE.
949: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 949: IF FND_API.to_boolean( p_init_msg_list ) THEN

945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END IF;
947:
948: -- Initialize message list if p_init_msg_list is set to TRUE.
949: IF FND_API.to_boolean( p_init_msg_list ) THEN
950: FND_MSG_PUB.initialize;
951: END IF;
952:
953: -- Enable Debug (optional)

Line 972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

968: l_return_status -- OUT
969: );
970:
971: -- If any severe error occurs, then, abort API.
972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
973: RAISE FND_API.G_EXC_ERROR;
974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;

Line 973: RAISE FND_API.G_EXC_ERROR;

969: );
970:
971: -- If any severe error occurs, then, abort API.
972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
973: RAISE FND_API.G_EXC_ERROR;
974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977:

Line 974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

970:
971: -- If any severe error occurs, then, abort API.
972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
973: RAISE FND_API.G_EXC_ERROR;
974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977:
978: -- If the module type is JSP, then default values for ID columns of LOV attributes

Line 975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

971: -- If any severe error occurs, then, abort API.
972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
973: RAISE FND_API.G_EXC_ERROR;
974: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977:
978: -- If the module type is JSP, then default values for ID columns of LOV attributes
979: IF ( p_module_type = 'JSP' ) THEN

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

987: END LOOP;
988: END IF;
989:
990: -- Convert Values into Ids.
991: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
992: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
993: IF ( p_x_effectivity_detail_tbl(i).dml_operation <> 'D' ) THEN
994: convert_values_to_ids
995: (

Line 1002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

998: l_return_status -- OUT
999: );
1000:
1001: -- If any severe error occurs, then, abort API.
1002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;

Line 1003: RAISE FND_API.G_EXC_ERROR;

999: );
1000:
1001: -- If any severe error occurs, then, abort API.
1002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007: END IF;

Line 1004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1000:
1001: -- If any severe error occurs, then, abort API.
1002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007: END IF;
1008: END LOOP;

Line 1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1001: -- If any severe error occurs, then, abort API.
1002: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END IF;
1007: END IF;
1008: END LOOP;
1009: END IF;

Line 1016: IF FND_API.to_boolean( p_default ) THEN

1012: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after convert_values_to_ids' );
1013: END IF;
1014:
1015: -- Default effectivity_detail attributes.
1016: IF FND_API.to_boolean( p_default ) THEN
1017: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
1018: IF ( p_x_effectivity_detail_tbl(i).dml_operation <> 'D' ) THEN
1019: default_attributes
1020: (

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

1028: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_attributes' );
1029: END IF;
1030:
1031: -- Validate all attributes (Item level validation)
1032: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
1033: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
1034: validate_attributes
1035: (
1036: p_x_effectivity_detail_tbl(i), -- IN

Line 1041: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1037: l_return_status -- OUT
1038: );
1039:
1040: -- If any severe error occurs, then, abort API.
1041: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1042: RAISE FND_API.G_EXC_ERROR;
1043: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: END IF;

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038: );
1039:
1040: -- If any severe error occurs, then, abort API.
1041: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1042: RAISE FND_API.G_EXC_ERROR;
1043: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: END IF;
1046: END LOOP;

Line 1043: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1039:
1040: -- If any severe error occurs, then, abort API.
1041: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1042: RAISE FND_API.G_EXC_ERROR;
1043: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: END IF;
1046: END LOOP;
1047: END IF;

Line 1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1040: -- If any severe error occurs, then, abort API.
1041: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1042: RAISE FND_API.G_EXC_ERROR;
1043: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: END IF;
1046: END LOOP;
1047: END IF;
1048:

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

1069: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after default_unchanged_attributes / default_missing_attributes' );
1070: END IF;
1071:
1072: -- Perform cross attribute validation and missing attribute checks (Record level validation)
1073: IF ( p_validation_level = FND_API.G_VALID_LEVEL_FULL ) THEN
1074: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP
1075: IF ( p_x_effectivity_detail_tbl(i).dml_operation <> 'D' ) THEN
1076: validate_record
1077: (

Line 1083: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1079: l_return_status -- OUT
1080: );
1081:
1082: -- If any severe error occurs, then, abort API.
1083: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END IF;

Line 1084: RAISE FND_API.G_EXC_ERROR;

1080: );
1081:
1082: -- If any severe error occurs, then, abort API.
1083: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END IF;
1088: END IF;

Line 1085: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1081:
1082: -- If any severe error occurs, then, abort API.
1083: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END IF;
1088: END IF;
1089: END LOOP;

Line 1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1082: -- If any severe error occurs, then, abort API.
1083: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087: END IF;
1088: END IF;
1089: END LOOP;
1090: END IF;

Line 1100: RAISE FND_API.G_EXC_ERROR;

1096: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1097: l_msg_count := FND_MSG_PUB.count_msg;
1098: IF l_msg_count > 0 THEN
1099: x_msg_count := l_msg_count;
1100: RAISE FND_API.G_EXC_ERROR;
1101: END IF;
1102:
1103: -- Perform the DML statement directly.
1104: FOR i IN 1..p_x_effectivity_detail_tbl.count LOOP

Line 1218: RAISE FND_API.G_EXC_ERROR;

1214: IF ( SQL%ROWCOUNT = 0 ) THEN
1215: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1216: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_tbl(i) ) );
1217: FND_MSG_PUB.add;
1218: RAISE FND_API.G_EXC_ERROR;
1219: END IF;
1220:
1221: -- Set OUT values
1222: p_x_effectivity_detail_tbl(i).object_version_number := p_x_effectivity_detail_tbl(i).object_version_number + 1;

Line 1236: RAISE FND_API.G_EXC_ERROR;

1232: IF ( SQL%ROWCOUNT = 0 ) THEN
1233: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1234: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
1235: FND_MSG_PUB.add;
1236: RAISE FND_API.G_EXC_ERROR;
1237: END IF;
1238: END IF;
1239:
1240:

Line 1298: RAISE FND_API.G_EXC_ERROR;

1294: THEN
1295: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_MED_REC' );
1296: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_tbl(i) ) );
1297: FND_MSG_PUB.add;
1298: RAISE FND_API.G_EXC_ERROR;
1299: END IF;
1300:
1301: END IF;
1302:

Line 1320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1316: l_return_status -- OUT
1317: );
1318:
1319: -- If any severe error occurs, then, abort API.
1320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1321: RAISE FND_API.G_EXC_ERROR;
1322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324: END IF;

Line 1321: RAISE FND_API.G_EXC_ERROR;

1317: );
1318:
1319: -- If any severe error occurs, then, abort API.
1320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1321: RAISE FND_API.G_EXC_ERROR;
1322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324: END IF;
1325:

Line 1322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1318:
1319: -- If any severe error occurs, then, abort API.
1320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1321: RAISE FND_API.G_EXC_ERROR;
1322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324: END IF;
1325:
1326: IF G_DEBUG = 'Y' THEN

Line 1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1319: -- If any severe error occurs, then, abort API.
1320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1321: RAISE FND_API.G_EXC_ERROR;
1322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324: END IF;
1325:
1326: IF G_DEBUG = 'Y' THEN
1327: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );

Line 1331: IF FND_API.to_boolean( p_commit ) THEN

1327: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_records' );
1328: END IF;
1329:
1330: -- Perform the Commit (if requested)
1331: IF FND_API.to_boolean( p_commit ) THEN
1332: COMMIT WORK;
1333: END IF;
1334:
1335: -- Count and Get messages (optional)

Line 1338: p_encoded => FND_API.G_FALSE,

1334:
1335: -- Count and Get messages (optional)
1336: FND_MSG_PUB.count_and_get
1337: (
1338: p_encoded => FND_API.G_FALSE,
1339: p_count => x_msg_count,
1340: p_data => x_msg_data
1341: );
1342:

Line 1350: WHEN FND_API.G_EXC_ERROR THEN

1346: END IF;
1347:
1348: EXCEPTION
1349:
1350: WHEN FND_API.G_EXC_ERROR THEN
1351: ROLLBACK TO process_effectivity_detail_PVT;
1352: x_return_status := FND_API.G_RET_STS_ERROR ;
1353: FND_MSG_PUB.count_and_get
1354: (

Line 1352: x_return_status := FND_API.G_RET_STS_ERROR ;

1348: EXCEPTION
1349:
1350: WHEN FND_API.G_EXC_ERROR THEN
1351: ROLLBACK TO process_effectivity_detail_PVT;
1352: x_return_status := FND_API.G_RET_STS_ERROR ;
1353: FND_MSG_PUB.count_and_get
1354: (
1355: p_encoded => FND_API.G_FALSE,
1356: p_count => x_msg_count,

Line 1355: p_encoded => FND_API.G_FALSE,

1351: ROLLBACK TO process_effectivity_detail_PVT;
1352: x_return_status := FND_API.G_RET_STS_ERROR ;
1353: FND_MSG_PUB.count_and_get
1354: (
1355: p_encoded => FND_API.G_FALSE,
1356: p_count => x_msg_count,
1357: p_data => x_msg_data
1358: );
1359:

Line 1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1361: IF ( G_DEBUG = 'Y' ) THEN
1362: AHL_DEBUG_PUB.disable_debug;
1363: END IF;
1364:
1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1366: ROLLBACK TO process_effectivity_detail_PVT;
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1368: FND_MSG_PUB.count_and_get
1369: (

Line 1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1363: END IF;
1364:
1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1366: ROLLBACK TO process_effectivity_detail_PVT;
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1368: FND_MSG_PUB.count_and_get
1369: (
1370: p_encoded => FND_API.G_FALSE,
1371: p_count => x_msg_count,

Line 1370: p_encoded => FND_API.G_FALSE,

1366: ROLLBACK TO process_effectivity_detail_PVT;
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1368: FND_MSG_PUB.count_and_get
1369: (
1370: p_encoded => FND_API.G_FALSE,
1371: p_count => x_msg_count,
1372: p_data => x_msg_data
1373: );
1374:

Line 1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1378: END IF;
1379:
1380: WHEN OTHERS THEN
1381: ROLLBACK TO process_effectivity_detail_PVT;
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1384: THEN
1385: FND_MSG_PUB.add_exc_msg
1386: (

Line 1394: p_encoded => FND_API.G_FALSE,

1390: );
1391: END IF;
1392: FND_MSG_PUB.count_and_get
1393: (
1394: p_encoded => FND_API.G_FALSE,
1395: p_count => x_msg_count,
1396: p_data => x_msg_data
1397: );
1398: